Validation for National Numbering Plan in Mexico

OBJECTIVE To develop modules which returns status of Mobile, Fixed or Invalid of a given number. Baselines: Exportable Modules programmed in Node JS. Must support a Mongo Database filled monthly by converting an Excel XLSX datasheet which contains information about Area Codes, Prefixes and numbering ranges which indicates if It belongs to a Mobile or Fixed number. It is not necessary to develop the html code for receiving the XLSX file, the programmer will receive the current numbering plan file which contains approximately 85,000 rows grouped by area codes. Description of modules Module A Procedure 1- Receives an XLSX file. 2- The Mongo database is filled with the XLSX data file. Modules B Procedure: 1. Receives a string with a dialing number [+][CC][1][AAA]PPPSSSS, read from right to left, where: a) + E.164 format (Optional) b) CC- Country code (2 digits) (Optional) c) 1- Mobile indicator (Digit 1) (Optional) d) AAA- Area code (2 or 3 digits) (Optional) e) PPP- Prefix (If AAA=2 PPP=3 digits, If AAA=3 PPP=2 digits) (Mandatory) f) SSSS- Suffix (4 digits) (Mandatory) 2. If exists AAA a) Search PPP for the given AAA b) Check if SSSS belongs to Fixed or Mobile Number c) Build the number in E.164 format If does not exists AAA a) Search PPP in the database. b) If there are more than one PPP occurrence return Invalid Number c) If there are one PPP occurrence obtain its AAA d) Check if SSSS belongs to Fixed or Mobile Number e) Build the number in E.164 format