b993be9a6efecc440d312168776bbbb5fd3ea5e8
[motion2.git] / server / api / cmHopper / cmHopper.controller.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 _0xfb71=['state','statedesc','deleted','user','UserId','deletedat','format','calleridnum','phone','campaigntype','queue','ivr','CmContact','ContactId','firstName','lastName','isNil','calleridname','finally','CmHopperFinal','getPreview','getVoiceQueues','preview','dialOrderByScheduledAt','sequelize','transaction','YYYY-MM-DD\x20HH:mm:ss','direction','hopperIds','priority','scheduledAt','ASC','literal','COALESCE(CmHopper.UserId,\x200)\x20ASC','DESC','isEmpty','COALESCE(CmHopper.UserId,\x200)\x20DESC','findOne','scheduledat','LOCK','UPDATE','Contact','CmCompany','Company','CmList','List','Queue','dialActive','getOpenContacts','outbound','isNumber','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','bluebird','mustache','util','sox','to-csv','ejs','lodash','squel','crypto','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/utils','../../config/environment','../../config/license/util','end','json','count','offset','limit','status','apply','update','then','destroy','sendStatus','stack','name','send','index','map','CmHopper','fieldName','type','key','model','query','filters','intersection','concat','$or','$gt','$gte','$lt','$ne','$eq','$not','$between','$notBetween','$in','$notIn','$like','$notILike','$overlap','$contains','$contained','$any','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','options','includeAll','include','rows','show','params','keys','rawAttributes','find','catch','create','body','describe','VoiceQueueId','CampaignId','VoiceQueue','omit','dataValues','createdAt','updatedAt'];(function(_0x30bd66,_0x36a93d){var _0x74c9dd=function(_0x2cd660){while(--_0x2cd660){_0x30bd66['push'](_0x30bd66['shift']());}};_0x74c9dd(++_0x36a93d);}(_0xfb71,0x1ef));var _0x1fb7=function(_0xfac6cd,_0x32fb94){_0xfac6cd=_0xfac6cd-0x0;var _0xeb2337=_0xfb71[_0xfac6cd];return _0xeb2337;};'use strict';var pdf=require(_0x1fb7('0x0'));var emlformat=require(_0x1fb7('0x1'));var rimraf=require(_0x1fb7('0x2'));var zipdir=require(_0x1fb7('0x3'));var jsonpatch=require(_0x1fb7('0x4'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x1fb7('0x5'));var Mustache=require(_0x1fb7('0x6'));var util=require(_0x1fb7('0x7'));var path=require('path');var sox=require(_0x1fb7('0x8'));var csv=require(_0x1fb7('0x9'));var ejs=require(_0x1fb7('0xa'));var fs=require('fs');var _=require(_0x1fb7('0xb'));var squel=require(_0x1fb7('0xc'));var crypto=require(_0x1fb7('0xd'));var jsforce=require('jsforce');var deskjs=require(_0x1fb7('0xe'));var toCsv=require(_0x1fb7('0x9'));var querystring=require('querystring');var Papa=require(_0x1fb7('0xf'));var Redis=require(_0x1fb7('0x10'));var authService=require(_0x1fb7('0x11'));var qs=require(_0x1fb7('0x12'));var as=require(_0x1fb7('0x13'));var hardwareService=require(_0x1fb7('0x14'));var logger=require('../../config/logger')('api');var utils=require(_0x1fb7('0x15'));var config=require(_0x1fb7('0x16'));var licenseUtil=require(_0x1fb7('0x17'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x49ac10,_0x195eb2){_0x195eb2=_0x195eb2||0xcc;return function(_0x3cc07d){if(_0x3cc07d){return _0x49ac10['sendStatus'](_0x195eb2);}return _0x49ac10['status'](_0x195eb2)[_0x1fb7('0x18')]();};}function respondWithResult(_0x508475,_0x5117a1){_0x5117a1=_0x5117a1||0xc8;return function(_0x1b333b){if(_0x1b333b){return _0x508475['status'](_0x5117a1)[_0x1fb7('0x19')](_0x1b333b);}};}function respondWithFilteredResult(_0x34b6c0,_0x3245cf){return function(_0x5a010a){if(_0x5a010a){var _0xf4c50f=_0x5a010a[_0x1fb7('0x1a')],_0x7bb15c=_0x3245cf['offset'],_0x2a5202=_0x3245cf[_0x1fb7('0x1b')]+_0x3245cf[_0x1fb7('0x1c')],_0x3126bf;if(_0x2a5202>=_0xf4c50f){_0x2a5202=_0xf4c50f;_0x3126bf=0xc8;}else{_0x3126bf=0xce;}_0x34b6c0[_0x1fb7('0x1d')](_0x3126bf);return _0x34b6c0['set']('Content-Range',_0x7bb15c+'-'+_0x2a5202+'/'+_0xf4c50f)[_0x1fb7('0x19')](_0x5a010a);}return null;};}function patchUpdates(_0x373465){return function(_0x1c4b31){try{jsonpatch[_0x1fb7('0x1e')](_0x1c4b31,_0x373465,!![]);}catch(_0x1a87d3){return BPromise['reject'](_0x1a87d3);}return _0x1c4b31['save']();};}function saveUpdates(_0x4124d2,_0x28ad2b){return function(_0x4e8a2a){if(_0x4e8a2a){return _0x4e8a2a[_0x1fb7('0x1f')](_0x4124d2)[_0x1fb7('0x20')](function(_0x4e4b8b){return _0x4e4b8b;});}return null;};}function removeEntity(_0x5792d1,_0x3c47be){return function(_0x294e2b){if(_0x294e2b){return _0x294e2b[_0x1fb7('0x21')]()[_0x1fb7('0x20')](function(){_0x5792d1[_0x1fb7('0x1d')](0xcc)[_0x1fb7('0x18')]();});}};}function handleEntityNotFound(_0x350384,_0x525149){return function(_0x3da6af){if(!_0x3da6af){_0x350384[_0x1fb7('0x22')](0x194);}return _0x3da6af;};}function handleError(_0x538ac2,_0x87cba1){_0x87cba1=_0x87cba1||0x1f4;return function(_0x4919a5){logger['error'](_0x4919a5[_0x1fb7('0x23')]);if(_0x4919a5[_0x1fb7('0x24')]){delete _0x4919a5[_0x1fb7('0x24')];}_0x538ac2['status'](_0x87cba1)[_0x1fb7('0x25')](_0x4919a5);};}exports[_0x1fb7('0x26')]=function(_0x36d07f,_0x434d3a){var _0x2e3e1c={},_0x8fe7f9={},_0x1db7ed={'count':0x0,'rows':[]};var _0x378c02=_[_0x1fb7('0x27')](db[_0x1fb7('0x28')]['rawAttributes'],function(_0x1513ef){return{'name':_0x1513ef[_0x1fb7('0x29')],'type':_0x1513ef[_0x1fb7('0x2a')][_0x1fb7('0x2b')]};});_0x8fe7f9[_0x1fb7('0x2c')]=_[_0x1fb7('0x27')](_0x378c02,'name');_0x8fe7f9[_0x1fb7('0x2d')]=_['keys'](_0x36d07f['query']);_0x8fe7f9[_0x1fb7('0x2e')]=_[_0x1fb7('0x2f')](_0x8fe7f9[_0x1fb7('0x2c')],_0x8fe7f9[_0x1fb7('0x2d')]);_0x8fe7f9['filters']=_[_0x1fb7('0x30')](_0x8fe7f9[_0x1fb7('0x2e')],['$and',_0x1fb7('0x31'),_0x1fb7('0x32'),_0x1fb7('0x33'),_0x1fb7('0x34'),'$lte',_0x1fb7('0x35'),_0x1fb7('0x36'),_0x1fb7('0x37'),_0x1fb7('0x38'),_0x1fb7('0x39'),_0x1fb7('0x3a'),_0x1fb7('0x3b'),_0x1fb7('0x3c'),'$notLike','$iLike',_0x1fb7('0x3d'),_0x1fb7('0x3c'),_0x1fb7('0x3e'),_0x1fb7('0x3f'),_0x1fb7('0x40'),_0x1fb7('0x41')]);_0x2e3e1c[_0x1fb7('0x42')]=_[_0x1fb7('0x2f')](_0x8fe7f9[_0x1fb7('0x2c')],qs[_0x1fb7('0x43')](_0x36d07f[_0x1fb7('0x2d')][_0x1fb7('0x43')]));_0x2e3e1c[_0x1fb7('0x42')]=_0x2e3e1c[_0x1fb7('0x42')][_0x1fb7('0x44')]?_0x2e3e1c['attributes']:_0x8fe7f9[_0x1fb7('0x2c')];if(!_0x36d07f[_0x1fb7('0x2d')][_0x1fb7('0x45')](_0x1fb7('0x46'))){_0x2e3e1c['limit']=qs[_0x1fb7('0x1c')](_0x36d07f['query'][_0x1fb7('0x1c')]);_0x2e3e1c[_0x1fb7('0x1b')]=qs['offset'](_0x36d07f[_0x1fb7('0x2d')][_0x1fb7('0x1b')]);}_0x2e3e1c[_0x1fb7('0x47')]=qs[_0x1fb7('0x48')](_0x36d07f[_0x1fb7('0x2d')][_0x1fb7('0x48')]);_0x2e3e1c[_0x1fb7('0x49')]=qs[_0x1fb7('0x2e')](_[_0x1fb7('0x4a')](_0x36d07f[_0x1fb7('0x2d')],_0x8fe7f9[_0x1fb7('0x2e')]),_0x378c02);if(_0x36d07f[_0x1fb7('0x2d')][_0x1fb7('0x4b')]){_0x2e3e1c[_0x1fb7('0x49')]=_[_0x1fb7('0x4c')](_0x2e3e1c[_0x1fb7('0x49')],{'$or':_['map'](_0x378c02,function(_0x3f0dcf){if(_0x3f0dcf[_0x1fb7('0x2a')]!=='VIRTUAL'){var _0x5c16b6={};_0x5c16b6[_0x3f0dcf[_0x1fb7('0x24')]]={'$like':'%'+_0x36d07f[_0x1fb7('0x2d')]['filter']+'%'};return _0x5c16b6;}})});}_0x2e3e1c=_[_0x1fb7('0x4c')]({},_0x2e3e1c,_0x36d07f[_0x1fb7('0x4d')]);var _0x272f57={'where':_0x2e3e1c['where']};return db[_0x1fb7('0x28')][_0x1fb7('0x1a')](_0x272f57)[_0x1fb7('0x20')](function(_0x3c34fa){_0x1db7ed[_0x1fb7('0x1a')]=_0x3c34fa;if(_0x36d07f[_0x1fb7('0x2d')][_0x1fb7('0x4e')]){_0x2e3e1c[_0x1fb7('0x4f')]=[{'all':!![]}];}return db[_0x1fb7('0x28')]['findAll'](_0x2e3e1c);})[_0x1fb7('0x20')](function(_0x3131bb){_0x1db7ed[_0x1fb7('0x50')]=_0x3131bb;return _0x1db7ed;})[_0x1fb7('0x20')](respondWithFilteredResult(_0x434d3a,_0x2e3e1c))['catch'](handleError(_0x434d3a,null));};exports[_0x1fb7('0x51')]=function(_0x400094,_0x108ee5){var _0x3db046={'raw':!![],'where':{'id':_0x400094[_0x1fb7('0x52')]['id']}},_0x348476={};_0x348476[_0x1fb7('0x2c')]=_[_0x1fb7('0x53')](db['CmHopper'][_0x1fb7('0x54')]);_0x348476[_0x1fb7('0x2d')]=_[_0x1fb7('0x53')](_0x400094[_0x1fb7('0x2d')]);_0x348476[_0x1fb7('0x2e')]=_[_0x1fb7('0x2f')](_0x348476[_0x1fb7('0x2c')],_0x348476['query']);_0x3db046[_0x1fb7('0x42')]=_[_0x1fb7('0x2f')](_0x348476['model'],qs[_0x1fb7('0x43')](_0x400094[_0x1fb7('0x2d')]['fields']));_0x3db046['attributes']=_0x3db046['attributes'][_0x1fb7('0x44')]?_0x3db046[_0x1fb7('0x42')]:_0x348476['model'];if(_0x400094[_0x1fb7('0x2d')][_0x1fb7('0x4e')]){_0x3db046[_0x1fb7('0x4f')]=[{'all':!![]}];}_0x3db046=_[_0x1fb7('0x4c')]({},_0x3db046,_0x400094[_0x1fb7('0x4d')]);return db[_0x1fb7('0x28')][_0x1fb7('0x55')](_0x3db046)[_0x1fb7('0x20')](handleEntityNotFound(_0x108ee5,null))[_0x1fb7('0x20')](respondWithResult(_0x108ee5,null))[_0x1fb7('0x56')](handleError(_0x108ee5,null));};exports['create']=function(_0xa6e820,_0x5976d6){return db['CmHopper'][_0x1fb7('0x57')](_0xa6e820[_0x1fb7('0x58')],{})[_0x1fb7('0x20')](respondWithResult(_0x5976d6,0xc9))['catch'](handleError(_0x5976d6,null));};exports[_0x1fb7('0x1f')]=function(_0x1ade39,_0x2a1899){if(_0x1ade39['body']['id']){delete _0x1ade39[_0x1fb7('0x58')]['id'];}return db[_0x1fb7('0x28')]['find']({'where':{'id':_0x1ade39['params']['id']}})[_0x1fb7('0x20')](handleEntityNotFound(_0x2a1899,null))['then'](saveUpdates(_0x1ade39['body'],null))[_0x1fb7('0x20')](respondWithResult(_0x2a1899,null))[_0x1fb7('0x56')](handleError(_0x2a1899,null));};exports[_0x1fb7('0x59')]=function(_0x1cc1da,_0x3820bc){return db[_0x1fb7('0x28')][_0x1fb7('0x59')]()['then'](respondWithResult(_0x3820bc,null))[_0x1fb7('0x56')](handleError(_0x3820bc,null));};exports[_0x1fb7('0x21')]=function(_0x3136c2,_0x21f345){var _0x36b971;return db[_0x1fb7('0x28')][_0x1fb7('0x55')]({'where':{'id':_0x3136c2['params']['id']}})[_0x1fb7('0x20')](handleEntityNotFound(_0x21f345,null))[_0x1fb7('0x20')](function(_0x529cfc){if(_0x529cfc){return _0x529cfc['destroy']()[_0x1fb7('0x20')](function(_0x2a5377){return _0x2a5377;});}})[_0x1fb7('0x20')](function(_0x185084){_0x36b971=_0x185084;if(_0x185084){if(_0x185084[_0x1fb7('0x5a')]||_0x185084[_0x1fb7('0x5b')]){return db[_0x185084[_0x1fb7('0x5a')]?_0x1fb7('0x5c'):'Campaign'][_0x1fb7('0x55')]({'where':{'id':_0x185084[_0x1fb7('0x5a')]?_0x185084['VoiceQueueId']:_0x185084[_0x1fb7('0x5b')]},'attributes':['id',_0x1fb7('0x24')],'raw':!![]});}}})[_0x1fb7('0x20')](function(_0x2e8119){var _0x4113fe={};if(_0x2e8119){_['merge'](_0x4113fe,_[_0x1fb7('0x5d')](_0x36b971[_0x1fb7('0x5e')],[_0x1fb7('0x5f'),_0x1fb7('0x60'),'id']));_0x4113fe[_0x1fb7('0x61')]=0x15;_0x4113fe[_0x1fb7('0x62')]=_0x1fb7('0x63');_0x4113fe['campaign']=_0x2e8119[_0x1fb7('0x24')];_0x4113fe['membername']=_0x3136c2[_0x1fb7('0x64')][_0x1fb7('0x24')];_0x4113fe[_0x1fb7('0x65')]=_0x3136c2[_0x1fb7('0x64')]['id'];_0x4113fe[_0x1fb7('0x63')]=!![];_0x4113fe[_0x1fb7('0x66')]=moment()[_0x1fb7('0x67')]('YYYY-MM-DD\x20HH:mm:ss');_0x4113fe[_0x1fb7('0x68')]=_0x36b971[_0x1fb7('0x69')];_0x4113fe[_0x1fb7('0x6a')]=_0x36b971[_0x1fb7('0x5a')]?_0x1fb7('0x6b'):_0x1fb7('0x6c');return db[_0x1fb7('0x6d')][_0x1fb7('0x55')]({'where':{'id':_0x4113fe[_0x1fb7('0x6e')]},'attributes':[_0x1fb7('0x6f'),_0x1fb7('0x70')]})['then'](function(_0x59f599){if(!_[_0x1fb7('0x71')](_0x21f345)&&!_['isNil'](_0x59f599['firstName'])){_0x4113fe[_0x1fb7('0x72')]=_0x59f599[_0x1fb7('0x6f')];if(!_[_0x1fb7('0x71')](_0x59f599[_0x1fb7('0x70')])){_0x4113fe[_0x1fb7('0x72')]+='\x20'+_0x59f599['lastName'];}}})[_0x1fb7('0x73')](function(){return db[_0x1fb7('0x74')][_0x1fb7('0x57')](_0x4113fe);});}})[_0x1fb7('0x20')](function(){return _0x21f345[_0x1fb7('0x1d')](0xcc)[_0x1fb7('0x18')]();})[_0x1fb7('0x56')](handleError(_0x21f345,null));};exports[_0x1fb7('0x75')]=function(_0x389b76,_0x598340,_0x20be0e){var _0x49b8ea=[];return db[_0x1fb7('0x6d')]['describe']()['then'](function(_0xea962f){_0x49b8ea=_[_0x1fb7('0x53')](_0xea962f);return _0x389b76['user'][_0x1fb7('0x76')]({'where':{'type':'outbound','dialActive':!![],'dialMethod':_0x1fb7('0x77')},'attributes':['id',_0x1fb7('0x78')],'raw':!![]});})[_0x1fb7('0x20')](function(_0x3895f8){if(_0x3895f8&&_0x3895f8[_0x1fb7('0x44')]){return db[_0x1fb7('0x79')][_0x1fb7('0x7a')](function(_0x5a958d){var _0x3eef33={'active':![],'recallme':![],'scheduledAt':{'$lte':moment()['format'](_0x1fb7('0x7b'))},'VoiceQueueId':{'$in':_[_0x1fb7('0x27')](_0x3895f8,'id')},'$or':[{'UserId':null},{'UserId':_0x389b76[_0x1fb7('0x64')]['id']}]};var _0x46b055=[];if(_0x389b76[_0x1fb7('0x58')][_0x1fb7('0x7c')]&&_0x389b76[_0x1fb7('0x58')]['direction']==='prev'){if(!_['isEmpty'](_0x389b76[_0x1fb7('0x58')][_0x1fb7('0x7d')])){_0x3eef33['id']={'$in':_0x389b76[_0x1fb7('0x58')]['hopperIds']};}_0x46b055=[[_0x1fb7('0x7e'),'ASC'],[_0x1fb7('0x7f'),_0x3895f8[0x0][_0x1fb7('0x78')]===_0x1fb7('0x80')?'DESC':'ASC'],db['sequelize'][_0x1fb7('0x81')](_0x1fb7('0x82')),['id',_0x1fb7('0x83')]];}else{if(!_[_0x1fb7('0x84')](_0x389b76['body'][_0x1fb7('0x7d')])){_0x3eef33['id']={'$notIn':_0x389b76[_0x1fb7('0x58')][_0x1fb7('0x7d')]};}_0x46b055=[['priority',_0x1fb7('0x83')],[_0x1fb7('0x7f'),_0x3895f8[0x0]['dialOrderByScheduledAt']],db[_0x1fb7('0x79')]['literal'](_0x1fb7('0x85')),['id',_0x1fb7('0x80')]];}return db[_0x1fb7('0x28')][_0x1fb7('0x86')]({'attributes':['id',_0x1fb7('0x87')],'where':_0x3eef33,'order':_0x46b055,'transaction':_0x5a958d,'lock':_0x5a958d[_0x1fb7('0x88')][_0x1fb7('0x89')],'include':[{'model':db['CmContact'],'as':_0x1fb7('0x8a'),'attributes':_0x49b8ea,'include':[{'model':db[_0x1fb7('0x8b')],'as':_0x1fb7('0x8c'),'attributes':['id',_0x1fb7('0x24')]}]},{'model':db[_0x1fb7('0x8d')],'as':_0x1fb7('0x8e'),'attributes':['id',_0x1fb7('0x24')]},{'model':db[_0x1fb7('0x5c')],'as':_0x1fb7('0x8f'),'attributes':['id',_0x1fb7('0x24'),_0x1fb7('0x90')]}]})['then'](function(_0xa19c22){if(_0xa19c22){return _0xa19c22[_0x1fb7('0x1f')]({'UserId':_0x389b76[_0x1fb7('0x64')]['id']},{'transaction':_0x5a958d});}});});}})['then'](handleEntityNotFound(_0x598340,null))[_0x1fb7('0x20')](respondWithResult(_0x598340,null))['catch'](handleError(_0x598340,null));};exports[_0x1fb7('0x91')]=function(_0x1e994d,_0x216ab5,_0x30d46c){return _0x1e994d[_0x1fb7('0x64')][_0x1fb7('0x76')]({'where':{'type':_0x1fb7('0x92'),'dialActive':!![],'dialMethod':_0x1fb7('0x77')},'attributes':['id'],'raw':!![]})[_0x1fb7('0x20')](function(_0x2b4290){if(_0x2b4290&&_0x2b4290[_0x1fb7('0x44')]){return db[_0x1fb7('0x28')]['count']({'where':{'active':![],'recallme':![],'scheduledAt':{'$lte':moment()['format'](_0x1fb7('0x7b'))},'VoiceQueueId':{'$in':_[_0x1fb7('0x27')](_0x2b4290,'id')},'$or':[{'UserId':null},{'UserId':_0x1e994d[_0x1fb7('0x64')]['id']}]}});}return 0x0;})[_0x1fb7('0x20')](function(_0x42058a){if(!_[_0x1fb7('0x71')](_0x42058a)&&_[_0x1fb7('0x93')](_0x42058a)){return _0x216ab5[_0x1fb7('0x1d')](0xc8)[_0x1fb7('0x19')]({'contacts':_0x42058a});}else{logger['error']('CmHopper,\x20%s,\x20%s,\x20%s',_0x1fb7('0x91'),0x194,'entity\x20not\x20found');_0x216ab5[_0x1fb7('0x22')](0x194);}})[_0x1fb7('0x56')](handleError(_0x216ab5,null));};