bed1b7c40c8b332ddc9cdf3808e4d18abc3ba88f
[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 _0x1a54=['UserId','deletedat','format','calleridnum','campaigntype','queue','ContactId','firstName','lastName','isNil','calleridname','CmHopperFinal','create','getPreview','getVoiceQueues','preview','dialOrderByScheduledAt','sequelize','transaction','YYYY-MM-DD\x20HH:mm:ss','dialPreviewAutoRecallMe','value','prev','isEmpty','hopperIds','ASC','scheduledAt','literal','COALESCE(CmHopper.UserId,\x200)\x20ASC','priority','DESC','findOne','scheduledat','LOCK','UPDATE','CmContact','Contact','Company','CmList','List','Queue','getOpenContacts','outbound','isNumber','CmHopper,\x20%s,\x20%s,\x20%s','rimraf','fast-json-patch','request-promise','bluebird','util','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','status','end','json','offset','undefined','limit','set','Content-Range','reject','save','then','destroy','error','stack','name','map','rawAttributes','fieldName','type','key','model','query','keys','filters','concat','$and','$or','$gt','$gte','$lt','$lte','$ne','$not','$between','$notBetween','$in','$notIn','$notLike','$iLike','$notILike','$overlap','$contained','$any','intersection','fields','attributes','length','hasOwnProperty','order','sort','where','pick','filter','merge','VIRTUAL','CmHopper','count','includeAll','include','findAll','rows','catch','show','params','options','update','find','body','describe','VoiceQueueId','CampaignId','VoiceQueue','Campaign','omit','dataValues','campaign','membername','user'];(function(_0x4c5a90,_0x39edaf){var _0x8e83e8=function(_0xce4f7e){while(--_0xce4f7e){_0x4c5a90['push'](_0x4c5a90['shift']());}};_0x8e83e8(++_0x39edaf);}(_0x1a54,0x14f));var _0x41a5=function(_0x4b9813,_0x22c673){_0x4b9813=_0x4b9813-0x0;var _0x4296b7=_0x1a54[_0x4b9813];return _0x4296b7;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x41a5('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0x41a5('0x1'));var rp=require(_0x41a5('0x2'));var moment=require('moment');var BPromise=require(_0x41a5('0x3'));var Mustache=require('mustache');var util=require(_0x41a5('0x4'));var path=require('path');var sox=require(_0x41a5('0x5'));var csv=require(_0x41a5('0x6'));var ejs=require(_0x41a5('0x7'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x41a5('0x8'));var squel=require(_0x41a5('0x9'));var crypto=require(_0x41a5('0xa'));var jsforce=require(_0x41a5('0xb'));var deskjs=require(_0x41a5('0xc'));var toCsv=require(_0x41a5('0x6'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0x41a5('0xd'));var authService=require(_0x41a5('0xe'));var qs=require(_0x41a5('0xf'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x41a5('0x10'))(_0x41a5('0x11'));var utils=require(_0x41a5('0x12'));var config=require(_0x41a5('0x13'));var licenseUtil=require(_0x41a5('0x14'));var db=require(_0x41a5('0x15'))['db'];function respondWithStatusCode(_0x372b6a,_0x5bd44e){_0x5bd44e=_0x5bd44e||0xcc;return function(_0x6c18e1){if(_0x6c18e1){return _0x372b6a['sendStatus'](_0x5bd44e);}return _0x372b6a[_0x41a5('0x16')](_0x5bd44e)[_0x41a5('0x17')]();};}function respondWithResult(_0x4f9aab,_0x13d05f){_0x13d05f=_0x13d05f||0xc8;return function(_0x2e111b){if(_0x2e111b){return _0x4f9aab[_0x41a5('0x16')](_0x13d05f)[_0x41a5('0x18')](_0x2e111b);}};}function respondWithFilteredResult(_0x3fc008,_0x4dc67c){return function(_0x332861){if(_0x332861){var _0x53c211=typeof _0x4dc67c[_0x41a5('0x19')]===_0x41a5('0x1a')&&typeof _0x4dc67c[_0x41a5('0x1b')]===_0x41a5('0x1a');var _0x45bf8d=_0x332861['count'];var _0x18c379=_0x53c211?0x0:_0x4dc67c[_0x41a5('0x19')];var _0x1ae341=_0x53c211?_0x332861['count']:_0x4dc67c[_0x41a5('0x19')]+_0x4dc67c['limit'];var _0x1657ae;if(_0x1ae341>=_0x45bf8d){_0x1ae341=_0x45bf8d;_0x1657ae=0xc8;}else{_0x1657ae=0xce;}_0x3fc008[_0x41a5('0x16')](_0x1657ae);return _0x3fc008[_0x41a5('0x1c')](_0x41a5('0x1d'),_0x18c379+'-'+_0x1ae341+'/'+_0x45bf8d)[_0x41a5('0x18')](_0x332861);}return null;};}function patchUpdates(_0x1691cc){return function(_0x565cd4){try{jsonpatch['apply'](_0x565cd4,_0x1691cc,!![]);}catch(_0x4886c7){return BPromise[_0x41a5('0x1e')](_0x4886c7);}return _0x565cd4[_0x41a5('0x1f')]();};}function saveUpdates(_0x2682d9,_0x2d8878){return function(_0x3704df){if(_0x3704df){return _0x3704df['update'](_0x2682d9)[_0x41a5('0x20')](function(_0x1a87aa){return _0x1a87aa;});}return null;};}function removeEntity(_0x422baa,_0x2e3818){return function(_0x84b3aa){if(_0x84b3aa){return _0x84b3aa[_0x41a5('0x21')]()[_0x41a5('0x20')](function(){_0x422baa[_0x41a5('0x16')](0xcc)[_0x41a5('0x17')]();});}};}function handleEntityNotFound(_0x1148c4,_0x10fff6){return function(_0x4db9ff){if(!_0x4db9ff){_0x1148c4['sendStatus'](0x194);}return _0x4db9ff;};}function handleError(_0x33eebb,_0x4183e4){_0x4183e4=_0x4183e4||0x1f4;return function(_0xa33004){logger[_0x41a5('0x22')](_0xa33004[_0x41a5('0x23')]);if(_0xa33004['name']){delete _0xa33004[_0x41a5('0x24')];}_0x33eebb[_0x41a5('0x16')](_0x4183e4)['send'](_0xa33004);};}exports['index']=function(_0x1436bd,_0x4bb465){var _0x1f5e2d={},_0x2a8568={},_0x4d5afd={'count':0x0,'rows':[]};var _0x1a49b6=_[_0x41a5('0x25')](db['CmHopper'][_0x41a5('0x26')],function(_0x341ee7){return{'name':_0x341ee7[_0x41a5('0x27')],'type':_0x341ee7[_0x41a5('0x28')][_0x41a5('0x29')]};});_0x2a8568[_0x41a5('0x2a')]=_[_0x41a5('0x25')](_0x1a49b6,_0x41a5('0x24'));_0x2a8568[_0x41a5('0x2b')]=_[_0x41a5('0x2c')](_0x1436bd[_0x41a5('0x2b')]);_0x2a8568[_0x41a5('0x2d')]=_['intersection'](_0x2a8568[_0x41a5('0x2a')],_0x2a8568[_0x41a5('0x2b')]);_0x2a8568[_0x41a5('0x2d')]=_[_0x41a5('0x2e')](_0x2a8568['filters'],[_0x41a5('0x2f'),_0x41a5('0x30'),_0x41a5('0x31'),_0x41a5('0x32'),_0x41a5('0x33'),_0x41a5('0x34'),_0x41a5('0x35'),'$eq',_0x41a5('0x36'),_0x41a5('0x37'),_0x41a5('0x38'),_0x41a5('0x39'),_0x41a5('0x3a'),'$like',_0x41a5('0x3b'),_0x41a5('0x3c'),_0x41a5('0x3d'),'$like',_0x41a5('0x3e'),'$contains',_0x41a5('0x3f'),_0x41a5('0x40')]);_0x1f5e2d['attributes']=_[_0x41a5('0x41')](_0x2a8568[_0x41a5('0x2a')],qs[_0x41a5('0x42')](_0x1436bd['query'][_0x41a5('0x42')]));_0x1f5e2d[_0x41a5('0x43')]=_0x1f5e2d[_0x41a5('0x43')][_0x41a5('0x44')]?_0x1f5e2d[_0x41a5('0x43')]:_0x2a8568[_0x41a5('0x2a')];if(!_0x1436bd[_0x41a5('0x2b')][_0x41a5('0x45')]('nolimit')){_0x1f5e2d[_0x41a5('0x1b')]=qs[_0x41a5('0x1b')](_0x1436bd['query'][_0x41a5('0x1b')]);_0x1f5e2d[_0x41a5('0x19')]=qs['offset'](_0x1436bd[_0x41a5('0x2b')][_0x41a5('0x19')]);}_0x1f5e2d[_0x41a5('0x46')]=qs[_0x41a5('0x47')](_0x1436bd[_0x41a5('0x2b')][_0x41a5('0x47')]);_0x1f5e2d[_0x41a5('0x48')]=qs[_0x41a5('0x2d')](_[_0x41a5('0x49')](_0x1436bd[_0x41a5('0x2b')],_0x2a8568['filters']),_0x1a49b6);if(_0x1436bd['query'][_0x41a5('0x4a')]){_0x1f5e2d[_0x41a5('0x48')]=_[_0x41a5('0x4b')](_0x1f5e2d[_0x41a5('0x48')],{'$or':_[_0x41a5('0x25')](_0x1a49b6,function(_0x32dbce){if(_0x32dbce[_0x41a5('0x28')]!==_0x41a5('0x4c')){var _0x48be22={};_0x48be22[_0x32dbce[_0x41a5('0x24')]]={'$like':'%'+_0x1436bd[_0x41a5('0x2b')][_0x41a5('0x4a')]+'%'};return _0x48be22;}})});}_0x1f5e2d=_[_0x41a5('0x4b')]({},_0x1f5e2d,_0x1436bd['options']);var _0xd8acaf={'where':_0x1f5e2d[_0x41a5('0x48')]};return db[_0x41a5('0x4d')][_0x41a5('0x4e')](_0xd8acaf)[_0x41a5('0x20')](function(_0x48c9c0){_0x4d5afd['count']=_0x48c9c0;if(_0x1436bd[_0x41a5('0x2b')][_0x41a5('0x4f')]){_0x1f5e2d[_0x41a5('0x50')]=[{'all':!![]}];}return db[_0x41a5('0x4d')][_0x41a5('0x51')](_0x1f5e2d);})[_0x41a5('0x20')](function(_0x501a8c){_0x4d5afd[_0x41a5('0x52')]=_0x501a8c;return _0x4d5afd;})[_0x41a5('0x20')](respondWithFilteredResult(_0x4bb465,_0x1f5e2d))[_0x41a5('0x53')](handleError(_0x4bb465,null));};exports[_0x41a5('0x54')]=function(_0x2a930b,_0x144ac3){var _0x1de1c9={'raw':!![],'where':{'id':_0x2a930b[_0x41a5('0x55')]['id']}},_0x589431={};_0x589431['model']=_['keys'](db[_0x41a5('0x4d')][_0x41a5('0x26')]);_0x589431[_0x41a5('0x2b')]=_[_0x41a5('0x2c')](_0x2a930b['query']);_0x589431[_0x41a5('0x2d')]=_[_0x41a5('0x41')](_0x589431[_0x41a5('0x2a')],_0x589431[_0x41a5('0x2b')]);_0x1de1c9['attributes']=_[_0x41a5('0x41')](_0x589431['model'],qs[_0x41a5('0x42')](_0x2a930b[_0x41a5('0x2b')]['fields']));_0x1de1c9[_0x41a5('0x43')]=_0x1de1c9[_0x41a5('0x43')][_0x41a5('0x44')]?_0x1de1c9[_0x41a5('0x43')]:_0x589431['model'];if(_0x2a930b[_0x41a5('0x2b')][_0x41a5('0x4f')]){_0x1de1c9['include']=[{'all':!![]}];}_0x1de1c9=_[_0x41a5('0x4b')]({},_0x1de1c9,_0x2a930b[_0x41a5('0x56')]);return db['CmHopper']['find'](_0x1de1c9)[_0x41a5('0x20')](handleEntityNotFound(_0x144ac3,null))[_0x41a5('0x20')](respondWithResult(_0x144ac3,null))[_0x41a5('0x53')](handleError(_0x144ac3,null));};exports['create']=function(_0x99a42d,_0x5c459c){return db[_0x41a5('0x4d')]['create'](_0x99a42d['body'],{})[_0x41a5('0x20')](respondWithResult(_0x5c459c,0xc9))['catch'](handleError(_0x5c459c,null));};exports[_0x41a5('0x57')]=function(_0x2a38de,_0x4dea38){if(_0x2a38de['body']['id']){delete _0x2a38de['body']['id'];}return db[_0x41a5('0x4d')][_0x41a5('0x58')]({'where':{'id':_0x2a38de[_0x41a5('0x55')]['id']}})['then'](handleEntityNotFound(_0x4dea38,null))[_0x41a5('0x20')](saveUpdates(_0x2a38de[_0x41a5('0x59')],null))[_0x41a5('0x20')](respondWithResult(_0x4dea38,null))[_0x41a5('0x53')](handleError(_0x4dea38,null));};exports['describe']=function(_0x492b95,_0xc91915){return db[_0x41a5('0x4d')][_0x41a5('0x5a')]()[_0x41a5('0x20')](respondWithResult(_0xc91915,null))['catch'](handleError(_0xc91915,null));};exports[_0x41a5('0x21')]=function(_0x2b539e,_0x1e6341){var _0x4607a9;return db[_0x41a5('0x4d')]['find']({'where':{'id':_0x2b539e['params']['id']}})[_0x41a5('0x20')](handleEntityNotFound(_0x1e6341,null))[_0x41a5('0x20')](function(_0x11e7e0){if(_0x11e7e0){return _0x11e7e0[_0x41a5('0x21')]()[_0x41a5('0x20')](function(_0x5b1c79){return _0x5b1c79;});}})['then'](function(_0x471522){_0x4607a9=_0x471522;if(_0x471522){if(_0x471522[_0x41a5('0x5b')]||_0x471522[_0x41a5('0x5c')]){return db[_0x471522['VoiceQueueId']?_0x41a5('0x5d'):_0x41a5('0x5e')][_0x41a5('0x58')]({'where':{'id':_0x471522[_0x41a5('0x5b')]?_0x471522[_0x41a5('0x5b')]:_0x471522[_0x41a5('0x5c')]},'attributes':['id',_0x41a5('0x24')],'raw':!![]});}}})[_0x41a5('0x20')](function(_0x48fd33){var _0x3a02f4={};if(_0x48fd33){_[_0x41a5('0x4b')](_0x3a02f4,_[_0x41a5('0x5f')](_0x4607a9[_0x41a5('0x60')],['createdAt','updatedAt','id']));_0x3a02f4['state']=0x15;_0x3a02f4['statedesc']='deleted';_0x3a02f4[_0x41a5('0x61')]=_0x48fd33[_0x41a5('0x24')];_0x3a02f4[_0x41a5('0x62')]=_0x2b539e[_0x41a5('0x63')]['name'];_0x3a02f4[_0x41a5('0x64')]=_0x2b539e[_0x41a5('0x63')]['id'];_0x3a02f4['deleted']=!![];_0x3a02f4[_0x41a5('0x65')]=moment()[_0x41a5('0x66')]('YYYY-MM-DD\x20HH:mm:ss');_0x3a02f4[_0x41a5('0x67')]=_0x4607a9['phone'];_0x3a02f4[_0x41a5('0x68')]=_0x4607a9[_0x41a5('0x5b')]?_0x41a5('0x69'):'ivr';return db['CmContact'][_0x41a5('0x58')]({'where':{'id':_0x3a02f4[_0x41a5('0x6a')]},'attributes':[_0x41a5('0x6b'),_0x41a5('0x6c')]})['then'](function(_0x1f046b){if(!_[_0x41a5('0x6d')](_0x1e6341)&&!_[_0x41a5('0x6d')](_0x1f046b[_0x41a5('0x6b')])){_0x3a02f4[_0x41a5('0x6e')]=_0x1f046b['firstName'];if(!_[_0x41a5('0x6d')](_0x1f046b[_0x41a5('0x6c')])){_0x3a02f4['calleridname']+='\x20'+_0x1f046b['lastName'];}}})['finally'](function(){return db[_0x41a5('0x6f')][_0x41a5('0x70')](_0x3a02f4);});}})[_0x41a5('0x20')](function(){return _0x1e6341[_0x41a5('0x16')](0xcc)[_0x41a5('0x17')]();})['catch'](handleError(_0x1e6341,null));};exports[_0x41a5('0x71')]=function(_0x560a,_0xb7b18,_0x4dcc52){var _0x4218de=[];return db['CmContact'][_0x41a5('0x5a')]()['then'](function(_0x17881e){_0x4218de=_['keys'](_0x17881e);return _0x560a[_0x41a5('0x63')][_0x41a5('0x72')]({'where':{'type':'outbound','dialActive':!![],'dialMethod':_0x41a5('0x73')},'attributes':['id',_0x41a5('0x74'),'dialPreviewAutoRecallMe'],'raw':!![]});})[_0x41a5('0x20')](function(_0x362f3f){if(_0x362f3f&&_0x362f3f['length']){return db[_0x41a5('0x75')][_0x41a5('0x76')](function(_0x5c452e){var _0x14b141={'active':![],'recallme':![],'scheduledAt':{'$lte':moment()[_0x41a5('0x66')](_0x41a5('0x77'))},'VoiceQueueId':{'$in':_[_0x41a5('0x25')](_0x362f3f,'id')},'$or':[{'UserId':null},{'UserId':_0x560a['user']['id']}]};var _0x5ab32d={'active':![],'recallme':!![],'VoiceQueueId':{'$in':_(_0x362f3f)[_0x41a5('0x4a')]([_0x41a5('0x78'),0x0])['map']('id')[_0x41a5('0x79')]()},'$or':[{'UserId':null},{'UserId':_0x560a[_0x41a5('0x63')]['id']}]};var _0x52510b={'$or':[_0x14b141,_0x5ab32d]};var _0x3a92d5=[];if(_0x560a[_0x41a5('0x59')]['direction']&&_0x560a[_0x41a5('0x59')]['direction']===_0x41a5('0x7a')){if(!_[_0x41a5('0x7b')](_0x560a[_0x41a5('0x59')][_0x41a5('0x7c')])){_0x52510b['id']={'$in':_0x560a[_0x41a5('0x59')]['hopperIds']};}_0x3a92d5=[['priority',_0x41a5('0x7d')],[_0x41a5('0x7e'),_0x362f3f[0x0]['dialOrderByScheduledAt']==='ASC'?'DESC':'ASC'],db[_0x41a5('0x75')][_0x41a5('0x7f')](_0x41a5('0x80')),['id','DESC']];}else{if(!_[_0x41a5('0x7b')](_0x560a[_0x41a5('0x59')][_0x41a5('0x7c')])){_0x52510b['id']={'$notIn':_0x560a[_0x41a5('0x59')][_0x41a5('0x7c')]};}_0x3a92d5=[[_0x41a5('0x81'),_0x41a5('0x82')],[_0x41a5('0x7e'),_0x362f3f[0x0][_0x41a5('0x74')]],db['sequelize'][_0x41a5('0x7f')]('COALESCE(CmHopper.UserId,\x200)\x20DESC'),['id',_0x41a5('0x7d')]];}return db[_0x41a5('0x4d')][_0x41a5('0x83')]({'attributes':['id',_0x41a5('0x84'),'recallme'],'where':_0x52510b,'order':_0x3a92d5,'transaction':_0x5c452e,'lock':_0x5c452e[_0x41a5('0x85')][_0x41a5('0x86')],'include':[{'model':db[_0x41a5('0x87')],'as':_0x41a5('0x88'),'attributes':_0x4218de,'include':[{'model':db['CmCompany'],'as':_0x41a5('0x89'),'attributes':['id',_0x41a5('0x24')]}]},{'model':db[_0x41a5('0x8a')],'as':_0x41a5('0x8b'),'attributes':['id',_0x41a5('0x24')]},{'model':db['VoiceQueue'],'as':_0x41a5('0x8c'),'attributes':['id',_0x41a5('0x24'),'dialActive']}]})[_0x41a5('0x20')](function(_0x56eae7){if(_0x56eae7){return _0x56eae7['update']({'UserId':_0x560a[_0x41a5('0x63')]['id']},{'transaction':_0x5c452e});}});});}})['then'](handleEntityNotFound(_0xb7b18,null))[_0x41a5('0x20')](respondWithResult(_0xb7b18,null))[_0x41a5('0x53')](handleError(_0xb7b18,null));};exports[_0x41a5('0x8d')]=function(_0x216349,_0xa6690e,_0x149e3b){return _0x216349[_0x41a5('0x63')][_0x41a5('0x72')]({'where':{'type':_0x41a5('0x8e'),'dialActive':!![],'dialMethod':_0x41a5('0x73')},'attributes':['id'],'raw':!![]})[_0x41a5('0x20')](function(_0x1b5f08){if(_0x1b5f08&&_0x1b5f08[_0x41a5('0x44')]){return db[_0x41a5('0x4d')][_0x41a5('0x4e')]({'where':{'active':![],'recallme':![],'scheduledAt':{'$lte':moment()['format'](_0x41a5('0x77'))},'VoiceQueueId':{'$in':_['map'](_0x1b5f08,'id')},'$or':[{'UserId':null},{'UserId':_0x216349[_0x41a5('0x63')]['id']}]}});}return 0x0;})[_0x41a5('0x20')](function(_0xcc3cf5){if(!_[_0x41a5('0x6d')](_0xcc3cf5)&&_[_0x41a5('0x8f')](_0xcc3cf5)){return _0xa6690e[_0x41a5('0x16')](0xc8)['json']({'contacts':_0xcc3cf5});}else{logger['error'](_0x41a5('0x90'),_0x41a5('0x8d'),0x194,'entity\x20not\x20found');_0xa6690e['sendStatus'](0x194);}})[_0x41a5('0x53')](handleError(_0xa6690e,null));};