server/api/cmContact/cmContact.model.js

   1 // *************************************************************************
   2 // *                                                                       *
   3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
   4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
   5 // *                                                                       *
   6 // *************************************************************************
   7 // *                                                                       *
   8 // * Email: info@xcally.com                                                *
   9 // * Website: https://www.xcally.com                                       *
  10 // *                                                                       *
  11 // *************************************************************************
  12 // *                                                                       *
  13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
  14 // * copyright treaties, as well as other intellectual property laws and   *
  15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
  16 // *                                                                       *
  17 // *************************************************************************
  18 var _0x794b=['onlyIfOpen','BlackLists','length','CmHopperBlack','cmContact,\x20%s,\x20%s','message','List\x20not\x20found','destroy','ContactId','VoiceQueueId','push','all','info','lodash','util','../../config/logger','api','moment','rimraf','../../config/environment','./cmContact.attributes','exports','CmContact','cm_contacts','phone','fti_cm_contacts','lastName','mobile','fax','email','FULLTEXT','utf8mb4','models','error','cmContact','afterCreate','inspect','scheduledat','YYYY-MM-DD\x20HH:mm:ss','dialTimezone','VoiceQueue','findOne','isNil','timezones','utcOffset','add','minutes','then','ret','CmHopper','cmContact,\x20afterCreate\x20','\x20contact\x20not\x20insert\x20in\x20hopper,\x20check\x20duplicate\x20onlyIfOpen,\x20exist\x20in\x20hopper\x20VoiceQueue\x20','create','priority','format','callbackUniqueid','cmContact,\x20afterCreate,\x20','ListId','catch','\x20contact\x20not\x20insert\x20in\x20hopper,\x20check\x20duplicate\x20onlyIfOpen,\x20exist\x20in\x20hopper\x20Campaign\x20','\x20contact\x20not\x20insert\x20in\x20hopper,\x20check\x20duplicate\x20always,\x20exist\x20in\x20hopper\x20Campaign\x20','CmHopperFinal','\x20contact\x20not\x20insert\x20in\x20hopper,\x20check\x20duplicate\x20always,\x20exist\x20in\x20hopperFinal\x20Campaign\x20','findAll','outbound','dialCheckDuplicateType','CmList','Lists','get','always'];(function(_0x25d386,_0x108d0d){var _0x857f4a=function(_0x3eb98d){while(--_0x3eb98d){_0x25d386['push'](_0x25d386['shift']());}};_0x857f4a(++_0x108d0d);}(_0x794b,0x1b1));var _0xb794=function(_0x44912a,_0x266423){_0x44912a=_0x44912a-0x0;var _0x15a566=_0x794b[_0x44912a];return _0x15a566;};'use strict';var _=require(_0xb794('0x0'));var util=require(_0xb794('0x1'));var logger=require(_0xb794('0x2'))(_0xb794('0x3'));var moment=require(_0xb794('0x4'));var BPromise=require('bluebird');var rp=require('request-promise');var fs=require('fs');var path=require('path');var rimraf=require(_0xb794('0x5'));var config=require(_0xb794('0x6'));var shared=require('../../config/environment/shared');var attributes=require(_0xb794('0x7'));module[_0xb794('0x8')]=function(_0x515b7e,_0x2ae045){return _0x515b7e['define'](_0xb794('0x9'),attributes,{'tableName':_0xb794('0xa'),'paranoid':!![],'indexes':[{'name':_0xb794('0xb'),'fields':[_0xb794('0xb')]},{'name':_0xb794('0xc'),'fields':['firstName',_0xb794('0xd'),'phone',_0xb794('0xe'),_0xb794('0xf'),_0xb794('0x10')],'type':_0xb794('0x11')}],'timestamps':!![],'charset':_0xb794('0x12'),'collate':'utf8mb4_unicode_ci','hooks':{'afterCreate':function(_0x2b3bf2,_0x4261b1,_0x3f5a3f){var _0xf466f=_0x515b7e[_0xb794('0x13')];var _0x4170d8=_0x2b3bf2['get']({'plain':!![]});function _0x121c0d(){return function(_0x5134ee){logger[_0xb794('0x14')](_0xb794('0x15'),_0xb794('0x16'),util[_0xb794('0x17')](_0x5134ee,{'showHidden':![],'depth':null}));};}function _0x2e55f1(_0x90c3a7,_0x21d276){var _0x4092fb=_0x21d276[_0xb794('0x18')]?_0x21d276[_0xb794('0x18')]:moment()['format'](_0xb794('0x19'));return new BPromise(function(_0x49fbfb,_0x10f77c){if(_['isNil'](_0x21d276[_0xb794('0x1a')])){_0x49fbfb({'ret':_0x4092fb});}else{_0xf466f[_0xb794('0x1b')][_0xb794('0x1c')]({'where':{'id':_0x90c3a7['id']}})['then'](function(_0x2090f0){if(!_['isNil'](_0x2090f0)){var _0x44d8eb=_0x2090f0[_0xb794('0x1a')];if(!_[_0xb794('0x1d')](_0x44d8eb)){var _0x35b0fc=shared[_0xb794('0x1e')];var _0x5b0a12=_0x35b0fc[_0x44d8eb];var _0x2aa8a1=_0x35b0fc[_0x21d276[_0xb794('0x1a')]];if(!_[_0xb794('0x1d')](_0x5b0a12)&&!_[_0xb794('0x1d')](_0x2aa8a1)){var _0x42cbfa=_0x5b0a12[_0xb794('0x1f')]-_0x2aa8a1[_0xb794('0x1f')];_0x4092fb=_0x21d276['scheduledat']?_0x21d276[_0xb794('0x18')]:moment();var _0x3d30c2=moment(_0x4092fb)[_0xb794('0x20')](_0x42cbfa,_0xb794('0x21'));_0x49fbfb({'ret':_0x3d30c2['format']('YYYY-MM-DD\x20HH:mm:ss')});}else _0x49fbfb({'ret':_0x4092fb});}else _0x49fbfb({'ret':_0x4092fb});}else{_0x49fbfb({'ret':_0x4092fb});}});}});return 0xa;}var _0x1a8b2d=function(_0x5dde2f){return new BPromise(function(_0x4fba1f,_0x19b656){_0x2e55f1(_0x5dde2f,_0x4170d8)[_0xb794('0x22')](function(_0xadf808){_0x4170d8[_0xb794('0x18')]=_0xadf808[_0xb794('0x23')];_0xf466f[_0xb794('0x24')][_0xb794('0x1c')]({'where':{'phone':_0x4170d8[_0xb794('0xb')],'VoiceQueueId':_0x5dde2f['id']}})['then'](function(_0x36ef60){if(!_[_0xb794('0x1d')](_0x36ef60)){throw new Error(_0xb794('0x25')+_0x4170d8['phone']+_0xb794('0x26')+_0x5dde2f['id']);}return _0xf466f[_0xb794('0x24')][_0xb794('0x27')]({'phone':_0x4170d8[_0xb794('0xb')],'ContactId':_0x4170d8['id'],'ListId':_0x4170d8['ListId'],'priority':_0x4170d8[_0xb794('0x28')]?_0x4170d8[_0xb794('0x28')]:0x2,'scheduledat':_0x4170d8[_0xb794('0x18')]?_0x4170d8[_0xb794('0x18')]:moment()[_0xb794('0x29')](_0xb794('0x19')),'callback':_0x4170d8['callbackUniqueid']?!![]:![],'callbackuniqueid':_0x4170d8[_0xb794('0x2a')]?_0x4170d8['callbackUniqueid']:undefined,'callbackat':_0x4170d8[_0xb794('0x2a')]?moment()['format'](_0xb794('0x19')):undefined,'VoiceQueueId':_0x5dde2f['id']});})['catch'](function(_0x31a16c){_0x19b656(_0x31a16c);});});});};var _0x4bd51f=function(_0x1e109d){return new BPromise(function(_0x765de1,_0x42cb07){_0x2e55f1(_0x1e109d,_0x4170d8)[_0xb794('0x22')](function(_0x4b2118){_0x4170d8['scheduledat']=_0x4b2118[_0xb794('0x23')];_0xf466f[_0xb794('0x24')][_0xb794('0x1c')]({'where':{'phone':_0x4170d8[_0xb794('0xb')],'VoiceQueueId':_0x1e109d['id']}})[_0xb794('0x22')](function(_0x188d1f){if(!_['isNil'](_0x188d1f)){throw new Error(_0xb794('0x25')+_0x4170d8['phone']+'\x20contact\x20not\x20insert\x20in\x20hopper,\x20check\x20duplicate\x20always,\x20exist\x20in\x20hopper\x20VoiceQueue\x20'+_0x1e109d['id']);}return _0xf466f['CmHopperFinal'][_0xb794('0x1c')]({'where':{'calleridnum':_0x4170d8[_0xb794('0xb')],'VoiceQueueId':_0x1e109d['id']}});})['then'](function(_0xcfd675){if(!_[_0xb794('0x1d')](_0xcfd675)){throw new Error(_0xb794('0x2b')+_0x4170d8[_0xb794('0xb')]+'\x20contact\x20not\x20insert\x20in\x20hopper,\x20check\x20duplicate\x20always,\x20exist\x20in\x20hopperFinal\x20VoiceQueue\x20'+_0x1e109d['id']);}return _0xf466f[_0xb794('0x24')]['create']({'phone':_0x4170d8[_0xb794('0xb')],'ContactId':_0x4170d8['id'],'ListId':_0x4170d8[_0xb794('0x2c')],'priority':_0x4170d8['priority']?_0x4170d8[_0xb794('0x28')]:0x2,'scheduledat':_0x4170d8[_0xb794('0x18')]?_0x4170d8[_0xb794('0x18')]:moment()[_0xb794('0x29')](_0xb794('0x19')),'callback':_0x4170d8['callbackUniqueid']?!![]:![],'callbackuniqueid':_0x4170d8[_0xb794('0x2a')]?_0x4170d8[_0xb794('0x2a')]:undefined,'callbackat':_0x4170d8[_0xb794('0x2a')]?moment()[_0xb794('0x29')](_0xb794('0x19')):undefined,'VoiceQueueId':_0x1e109d['id']});})[_0xb794('0x2d')](function(_0x22ac85){_0x42cb07(_0x22ac85);});});});};function _0x4f25d4(){return function(_0x56fa29){logger['error'](_0xb794('0x15'),_0xb794('0x16'),util[_0xb794('0x17')](_0x56fa29,{'showHidden':![],'depth':null}));};}function _0x1d3c60(_0x5670e4,_0x296a13){var _0x1d9376=_0x296a13[_0xb794('0x18')]?_0x296a13[_0xb794('0x18')]:moment()[_0xb794('0x29')]('YYYY-MM-DD\x20HH:mm:ss');return new BPromise(function(_0x13ff73,_0xaf0c2f){if(_['isNil'](_0x296a13[_0xb794('0x1a')])){_0x13ff73({'ret':_0x1d9376});}else{_0xf466f['Campaign'][_0xb794('0x1c')]({'where':{'id':_0x5670e4['id']}})[_0xb794('0x22')](function(_0x574e18){if(!_[_0xb794('0x1d')](_0x574e18)){var _0x1e3c9d=_0x574e18[_0xb794('0x1a')];if(!_['isNil'](_0x1e3c9d)){var _0x313ce=shared[_0xb794('0x1e')];var _0x29b79d=_0x313ce[_0x1e3c9d];var _0xe8fc8b=_0x313ce[_0x296a13[_0xb794('0x1a')]];if(!_['isNil'](_0x29b79d)&&!_[_0xb794('0x1d')](_0xe8fc8b)){var _0x5f77ca=_0x29b79d[_0xb794('0x1f')]-_0xe8fc8b[_0xb794('0x1f')];_0x1d9376=_0x296a13[_0xb794('0x18')]?_0x296a13[_0xb794('0x18')]:moment();var _0x50d872=moment(_0x1d9376)['add'](_0x5f77ca,'minutes');_0x13ff73({'ret':_0x50d872['format'](_0xb794('0x19'))});}else _0x13ff73({'ret':_0x1d9376});}else _0x13ff73({'ret':_0x1d9376});}else{_0x13ff73({'ret':_0x1d9376});}});}});return 0xa;}var _0x214e8f=function(_0xb1a037){return new BPromise(function(_0x5d0ccf,_0x4a3e97){_0x1d3c60(_0xb1a037,_0x4170d8)['then'](function(_0x1d3896){_0x4170d8[_0xb794('0x18')]=_0x1d3896[_0xb794('0x23')];_0xf466f[_0xb794('0x24')]['findOne']({'where':{'phone':_0x4170d8[_0xb794('0xb')],'CampaignId':_0xb1a037['id']}})[_0xb794('0x22')](function(_0x5bd8fd){if(!_['isNil'](_0x5bd8fd)){throw new Error(_0xb794('0x25')+_0x4170d8[_0xb794('0xb')]+_0xb794('0x2e')+_0xb1a037['id']);}return _0xf466f[_0xb794('0x24')][_0xb794('0x27')]({'phone':_0x4170d8['phone'],'ContactId':_0x4170d8['id'],'ListId':_0x4170d8['ListId'],'priority':_0x4170d8[_0xb794('0x28')]?_0x4170d8[_0xb794('0x28')]:0x2,'scheduledat':_0x4170d8[_0xb794('0x18')]?_0x4170d8[_0xb794('0x18')]:moment()[_0xb794('0x29')]('YYYY-MM-DD\x20HH:mm:ss'),'callback':_0x4170d8[_0xb794('0x2a')]?!![]:![],'callbackuniqueid':_0x4170d8[_0xb794('0x2a')]?_0x4170d8[_0xb794('0x2a')]:undefined,'callbackat':_0x4170d8[_0xb794('0x2a')]?moment()[_0xb794('0x29')](_0xb794('0x19')):undefined,'CampaignId':_0xb1a037['id']});})[_0xb794('0x2d')](function(_0x141889){_0x4a3e97(_0x141889);});});});};var _0x419a16=function(_0x4d4007){return new BPromise(function(_0x22a9c3,_0x21a570){_0x1d3c60(_0x4d4007,_0x4170d8)[_0xb794('0x22')](function(_0x1f30f2){_0x4170d8[_0xb794('0x18')]=_0x1f30f2[_0xb794('0x23')];_0xf466f['CmHopper'][_0xb794('0x1c')]({'where':{'phone':_0x4170d8[_0xb794('0xb')],'CampaignId':_0x4d4007['id']}})[_0xb794('0x22')](function(_0x52af52){if(!_['isNil'](_0x52af52)){throw new Error(_0xb794('0x25')+_0x4170d8[_0xb794('0xb')]+_0xb794('0x2f')+_0x4d4007['id']);}return _0xf466f[_0xb794('0x30')]['findOne']({'where':{'calleridnum':_0x4170d8[_0xb794('0xb')],'CampaignId':_0x4d4007['id']}});})[_0xb794('0x22')](function(_0x29e244){if(!_[_0xb794('0x1d')](_0x29e244)){throw new Error(_0xb794('0x2b')+_0x4170d8[_0xb794('0xb')]+_0xb794('0x31')+_0x4d4007['id']);}return _0xf466f[_0xb794('0x24')][_0xb794('0x27')]({'phone':_0x4170d8[_0xb794('0xb')],'ContactId':_0x4170d8['id'],'ListId':_0x4170d8[_0xb794('0x2c')],'priority':_0x4170d8[_0xb794('0x28')]?_0x4170d8['priority']:0x2,'scheduledat':_0x4170d8[_0xb794('0x18')]?_0x4170d8[_0xb794('0x18')]:moment()[_0xb794('0x29')](_0xb794('0x19')),'callback':_0x4170d8[_0xb794('0x2a')]?!![]:![],'callbackuniqueid':_0x4170d8['callbackUniqueid']?_0x4170d8[_0xb794('0x2a')]:undefined,'callbackat':_0x4170d8[_0xb794('0x2a')]?moment()[_0xb794('0x29')](_0xb794('0x19')):undefined,'CampaignId':_0x4d4007['id']});})[_0xb794('0x2d')](function(_0x10a77e){_0x21a570(_0x10a77e);});});});};if(_0x4170d8[_0xb794('0x2c')]){_0xf466f[_0xb794('0x1b')][_0xb794('0x32')]({'where':{'type':_0xb794('0x33')},'attributes':['id',_0xb794('0x34'),_0xb794('0x1a')],'include':[{'model':_0xf466f[_0xb794('0x35')],'as':_0xb794('0x36'),'where':{'id':_0x4170d8[_0xb794('0x2c')]}}]})['then'](function(_0x30f1c7){if(_0x30f1c7){var _0x24ec2b=[];for(var _0x18ed5e=0x0,_0x3facaa;_0x18ed5e<_0x30f1c7['length'];_0x18ed5e+=0x1){_0x3facaa=_0x30f1c7[_0x18ed5e][_0xb794('0x37')]({'plain':!![]});switch(_0x3facaa['dialCheckDuplicateType']){case _0xb794('0x38'):_0x4bd51f(_0x3facaa)[_0xb794('0x2d')](_0x121c0d());break;case _0xb794('0x39'):_0x1a8b2d(_0x3facaa)['catch'](_0x121c0d());break;default:_0x1d3c60(_0x3facaa,_0x4170d8)['then'](function(_0x6f6050){_0x4170d8[_0xb794('0x18')]=_0x6f6050['ret'];_0xf466f[_0xb794('0x24')][_0xb794('0x27')]({'phone':_0x4170d8['phone'],'ContactId':_0x4170d8['id'],'ListId':_0x4170d8[_0xb794('0x2c')],'scheduledat':_0x4170d8[_0xb794('0x18')]?_0x4170d8[_0xb794('0x18')]:moment()[_0xb794('0x29')](_0xb794('0x19')),'priority':_0x4170d8[_0xb794('0x28')]?_0x4170d8['priority']:0x2,'callback':_0x4170d8['callbackUniqueid']?!![]:![],'callbackuniqueid':_0x4170d8[_0xb794('0x2a')]?_0x4170d8[_0xb794('0x2a')]:undefined,'callbackat':_0x4170d8[_0xb794('0x2a')]?moment()[_0xb794('0x29')](_0xb794('0x19')):undefined,'VoiceQueueId':_0x3facaa['id']})['catch'](_0x121c0d());});}}}})['then'](function(){return _0xf466f[_0xb794('0x1b')]['findAll']({'where':{'type':'outbound'},'attributes':['id'],'include':[{'model':_0xf466f[_0xb794('0x35')],'as':_0xb794('0x3a'),'where':{'id':_0x4170d8[_0xb794('0x2c')]}}]})[_0xb794('0x22')](function(_0x340157){if(_0x340157){var _0xb27786=[];for(var _0x1b63e3=0x0,_0x1b104d;_0x1b63e3<_0x340157[_0xb794('0x3b')];_0x1b63e3+=0x1){_0x1b104d=_0x340157[_0x1b63e3][_0xb794('0x37')]({'plain':!![]});_0xf466f[_0xb794('0x3c')][_0xb794('0x27')]({'phone':_0x4170d8[_0xb794('0xb')],'ContactId':_0x4170d8['id'],'ListId':_0x4170d8[_0xb794('0x2c')],'VoiceQueueId':_0x1b104d['id']})[_0xb794('0x2d')](function(_0x3224cb){logger[_0xb794('0x14')](_0xb794('0x3d'),'afterCreate',_0x3224cb[_0xb794('0x3e')]);});}}});})[_0xb794('0x22')](function(){return _0xf466f['Campaign'][_0xb794('0x32')]({'attributes':['id',_0xb794('0x34'),_0xb794('0x1a')],'include':[{'model':_0xf466f[_0xb794('0x35')],'as':_0xb794('0x36'),'where':{'id':_0x4170d8['ListId']}}]})['then'](function(_0x457c13){if(_0x457c13){var _0x59ad34=[];for(var _0xea6bcb=0x0,_0x1c8003;_0xea6bcb<_0x457c13[_0xb794('0x3b')];_0xea6bcb+=0x1){_0x1c8003=_0x457c13[_0xea6bcb]['get']({'plain':!![]});switch(_0x1c8003[_0xb794('0x34')]){case _0xb794('0x38'):_0x419a16(_0x1c8003)[_0xb794('0x2d')](_0x4f25d4());break;case _0xb794('0x39'):_0x214e8f(_0x1c8003)['catch'](_0x4f25d4());break;default:_0xf466f[_0xb794('0x24')][_0xb794('0x27')]({'phone':_0x4170d8[_0xb794('0xb')],'ContactId':_0x4170d8['id'],'ListId':_0x4170d8[_0xb794('0x2c')],'scheduledat':_0x4170d8[_0xb794('0x18')]?_0x4170d8[_0xb794('0x18')]:moment()['format'](_0xb794('0x19')),'priority':_0x4170d8[_0xb794('0x28')]?_0x4170d8[_0xb794('0x28')]:0x2,'callback':_0x4170d8[_0xb794('0x2a')]?!![]:![],'callbackuniqueid':_0x4170d8[_0xb794('0x2a')]?_0x4170d8['callbackUniqueid']:undefined,'callbackat':_0x4170d8[_0xb794('0x2a')]?moment()['format'](_0xb794('0x19')):undefined,'CampaignId':_0x1c8003['id']})[_0xb794('0x2d')](_0x4f25d4());}}}});})[_0xb794('0x22')](function(){return _0xf466f['Campaign'][_0xb794('0x32')]({'attributes':['id'],'include':[{'model':_0xf466f[_0xb794('0x35')],'as':_0xb794('0x3a'),'where':{'id':_0x4170d8['ListId']}}]})[_0xb794('0x22')](function(_0x4a6b41){if(_0x4a6b41){var _0x346e56=[];for(var _0x300899=0x0,_0x36717a;_0x300899<_0x4a6b41[_0xb794('0x3b')];_0x300899+=0x1){_0x36717a=_0x4a6b41[_0x300899][_0xb794('0x37')]({'plain':!![]});_0xf466f[_0xb794('0x3c')][_0xb794('0x27')]({'phone':_0x4170d8[_0xb794('0xb')],'ContactId':_0x4170d8['id'],'ListId':_0x4170d8['ListId'],'CampaignId':_0x36717a['id']})[_0xb794('0x2d')](function(_0x845bad){logger[_0xb794('0x14')](_0xb794('0x3d'),_0xb794('0x16'),_0x845bad[_0xb794('0x3e')]);});}}});})['then'](function(){_0x3f5a3f();})[_0xb794('0x2d')](function(_0x40d49d){logger['error'](_0xb794('0x3d'),_0xb794('0x16'),_0x40d49d[_0xb794('0x3e')]);_0x3f5a3f(_0x40d49d);});}else{_0x3f5a3f(new Error(_0xb794('0x3f')));}},'afterDestroy':function(_0x323b44,_0x5b328b,_0x37d9cc){var _0x48809e=_0x515b7e[_0xb794('0x13')];var _0x574c1b=_0x323b44[_0xb794('0x37')]({'plain':!![]});return _0x48809e['CmHopper'][_0xb794('0x32')]({'raw':!![],'where':{'ListId':_0x574c1b[_0xb794('0x2c')],'ContactId':_0x574c1b['id']}})[_0xb794('0x22')](function(_0x1782e3){if(!_['isEmpty'](_0x1782e3)){var _0x28740d=[];for(var _0x538dfb=0x0;_0x538dfb<_0x1782e3[_0xb794('0x3b')];_0x538dfb+=0x1){var _0x3d4a92=_0x48809e[_0xb794('0x24')][_0xb794('0x40')]({'where':{'ListId':_0x1782e3[_0x538dfb][_0xb794('0x2c')],'ContactId':_0x1782e3[_0x538dfb][_0xb794('0x41')],'VoiceQueueId':_0x1782e3[_0x538dfb][_0xb794('0x42')],'CampaignId':_0x1782e3[_0x538dfb]['CampaignId']}});_0x28740d[_0xb794('0x43')](_0x3d4a92);}return BPromise[_0xb794('0x44')](_0x28740d);}})[_0xb794('0x22')](function(_0x54c9b6){logger[_0xb794('0x45')]('[CmContact][afterDestroy][Succesfull]',util[_0xb794('0x17')](_0x54c9b6,{'showHidden':![],'depth':null}));_0x37d9cc();})[_0xb794('0x2d')](function(_0x51471e){logger[_0xb794('0x14')]('[CmContact][afterDestroy][Error]',util[_0xb794('0x17')](_0x51471e,{'showHidden':![],'depth':null}));_0x37d9cc(_0x51471e);});}}});};