Bug for DID Disconnet Status stuck at 3 for Toll-Free : now we have set 0
    
    E:\nodenew\signalmash_new\trunk\node\dist\include\Inteliquent.js

    disconnectDID(req, res, payload, callback) {
        const sdata = req.body;
        let iduser = (typeof sdata.iduser != 'undefined' && sdata.iduser > 0) ? sdata.iduser : this.sessdata.iduser;
        let obj2 = new RawQuery_1.ModelRawQuery(req, res);
        obj2.qrysql = "SELECT `type` from `did_buy` WHERE `iduser`='" + iduser + "' AND `did`='" + sdata.DID.trim() + "'";
        obj2.prepare();
        obj2.execute((err, resu) => {
            if (resu.length > 0) {
                if (resu[0].type == "TF") {
                    var options = {
                        'method': 'POST',
                        'url': this.URL + '/tfDisconnect',
                        'headers': {
                            'Content-Type': 'application/json',
                            'Authorization': 'Basic ' + this.key
                        },
                        body: JSON.stringify({
                            "privateKey": this.privateKey,
                            "tnList": {
                                "tnItem": [
                                    {
                                        "tn": sdata.DID.trim()
                                    }
                                ]
                            }
                        })
                    };
                    request(options, (error, response) => {
                        if (!error) {
                            try {
                                let data = JSON.parse(response.body);
                                if (data.status == 'Success') {
                                    let obj = new RawNonQuery_1.ModelRawNonQuery(req, res);
                                    obj.nonqrysql = "UPDATE `did_buy` set `disconnect_did_status`='0',`updated_at`=NOW() WHERE `did`='" + sdata.DID.trim() + "'AND `iduser`='" + iduser + "'";
                                    obj.prepare();
                                    obj.execute((error, resp) => {
                                        if (error == 1) {
                                            let obj = new RawNonQuery_1.ModelRawNonQuery(req, res);
                                            obj.nonqrysql = "INSERT INTO `did_log` (`account_id`,`iduser`,`updated_at`,`event_type`,`description`,`did`) VALUE('" + this.sessdata.idaccount + "','" + iduser + "',NOW(),'5','Disconnect DID from provider','" + sdata.DID.trim() + "')";
                                            obj.prepare();
                                            obj.execute((errorDiDLg, resDiDLg) => { });
                                            let objv = new RawView_1.RawView(res);
                                            objv.prepare({ status: 201, message: "DID Disconnected Successfully" });
                                            objv.execute();
                                        }
                                        else {
                                            let objv = new RawView_1.RawView(res);
                                            objv.prepare({ status: 502, message: "Something went wrong with connection!" });
                                            objv.execute();
                                        }
                                    });
                                }
                                else {
                                    let objn = new RawNonQuery_1.ModelRawNonQuery(req, res);
                                    objn.nonqrysql = "INSERT INTO `did_log`(`account_id`,`iduser`,`updated_at`,`event_type`,`description`,`did`,`full_log`) VALUE('" + this.sessdata.idaccount + "','" + this.sessdata.iduser + "',NOW(),'39','DID disconnect failed from provider','" + sdata.DID.trim() + "','" + data + "')";
                                    objn.prepare();
                                    objn.execute((errorDiDLg, resDiDLg) => {
                                        console.log("DID disconnect failed FROM provider");
                                    });
                                    let objv = new RawView_1.RawView(res);
                                    objv.prepare({ status: data.statusCode, message: data.status });
                                    objv.execute();
                                }
                            }
                            catch (e) {
                                console.log("Error :: Inteliquent->disconnectDID::", e);
                                let obj = new RawView_1.RawView(res);
                                obj.prepare({ error_code: 0, status: 502, message: "Something went wrong!" });
                                obj.execute();
                            }
                        }
                        else {
                            console.log("Inteliquent :::::::::::::::::::");
                            let objv = new RawView_1.RawView(res);
                            objv.prepare({ status: 400, error: error, message: "DID not Disconnected!" });
                            objv.execute();
                        }
                    });
                }
                else {
                    var options = {
                        'method': 'POST',
                        'url': this.URL + '/tnDisconnect',
                        'headers': {
                            'Content-Type': 'application/json',
                            'Authorization': 'Basic ' + this.key
                        },
                        body: JSON.stringify({
                            "privateKey": this.privateKey,
                            "tnList": {
                                "tnItem": [
                                    {
                                        "tn": sdata.DID.trim()
                                    }
                                ]
                            }
                        })
                    };
                    request(options, (error, response) => {
                        if (!error) {
                            try {
                                let data = JSON.parse(response.body);
                                if (data.status == 'Success' || data.statusCode == '425') {
                                    let obj = new RawNonQuery_1.ModelRawNonQuery(req, res);
                                    obj.nonqrysql = "UPDATE `did_buy` set `disconnect_did_status`='3',`updated_at`=NOW() WHERE `did`='" + sdata.DID.trim() + "'AND `iduser`='" + iduser + "'";
                                    obj.prepare();
                                    obj.execute((error, resp) => {
                                        if (error == 1) {
                                            let obj = new RawNonQuery_1.ModelRawNonQuery(req, res);
                                            obj.nonqrysql = "INSERT INTO `did_log` (`account_id`,`iduser`,`updated_at`,`event_type`,`description`,`did`,`full_log`) VALUE('" + this.sessdata.idaccount + "','" + iduser + "',NOW(),'5','DID Disconnected Successfully','" + sdata.DID.trim() + "','" + data + "')";
                                            obj.prepare();
                                            obj.execute((errorDiDLg, resDiDLg) => { });
                                            let payLoad = {
                                                DID: sdata.DID.trim(),
                                                campaign: payload.campaign,
                                                iduser: iduser
                                            };
                                            let osr = new Osr_1.OsrApi(this.priority, this.sessdata);
                                            osr.deleteNumberM2(req, res, payLoad, (error, response) => {
                                                if (error == 1) {
                                                    if (payload.sms_provider == 'sinch') {
                                                        let osr = new SinchSubmitNumber_1.SinchApi(this.priority, this.sessdata);
                                                        osr.deleteNumberM2(req, res, payLoad, (error, response) => {
                                                        });
                                                    }
                                                    else {
                                                        let osr = new SinchSubmitNumber_1.SinchApi(this.priority, this.sessdata);
                                                        osr.deleteNumberM2fromSyniverse(req, res, payLoad, (error, response) => {
                                                        });
                                                    }
                                                }
                                            });
                                            let objv = new RawView_1.RawView(res);
                                            objv.prepare({ status: 201, message: "DID Disconnected Successfully" });
                                            objv.execute();
                                        }
                                        else {
                                            let objv = new RawView_1.RawView(res);
                                            objv.prepare({ status: 502, message: "Something Went Wrong" });
                                            objv.execute();
                                        }
                                    });
                                }
                                else {
                                    let objn = new RawNonQuery_1.ModelRawNonQuery(req, res);
                                    objn.nonqrysql = "INSERT INTO `did_log`(`account_id`,`iduser`,`updated_at`,`event_type`,`description`,`did`,`full_log`) VALUE('" + this.sessdata.idaccount + "','" + this.sessdata.iduser + "',NOW(),'39','DID disconnect failed from provider','" + sdata.DID.trim() + "','" + data + "')";
                                    objn.prepare();
                                    objn.execute((errorDiDLg, resDiDLg) => {
                                        console.log("DID disconnect failed FROM provider");
                                    });
                                    let objv = new RawView_1.RawView(res);
                                    objv.prepare({ status: data.statusCode, message: data.status });
                                    objv.execute();
                                }
                            }
                            catch (e) {
                                console.log("Error :: Inteliquent->disconnectDID::", e);
                                let obj = new RawView_1.RawView(res);
                                obj.prepare({ error_code: 0, status: 502, message: "Something went wrong!" });
                                obj.execute();
                            }
                        }
                        else {
                            let objv = new RawView_1.RawView(res);
                            objv.prepare({ status: 400, error: error });
                            objv.execute();
                        }
                    });
                }
            }
            else {
                let objv = new RawView_1.RawView(res);
                objv.prepare({ status: 502, message: "Something went wrong with connection!" });
                objv.execute();
            }
        });
    }