e8454cb0b98a89f07d50b74c83fc98951bdafa72
[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 _0x0352=['name','send','index','map','rawAttributes','type','key','query','filters','intersection','model','concat','$and','$gt','$gte','$lt','$lte','$ne','$not','$between','$notLike','$notILike','$contains','$any','attributes','fields','length','hasOwnProperty','nolimit','sort','where','pick','filter','merge','options','CmHopper','then','includeAll','include','findAll','rows','catch','params','keys','find','create','body','describe','CampaignId','VoiceQueueId','VoiceQueue','Campaign','omit','dataValues','createdAt','updatedAt','statedesc','deleted','campaign','membername','user','UserId','format','calleridnum','phone','campaigntype','ivr','CmContact','firstName','lastName','isNil','finally','CmHopperFinal','getPreview','getVoiceQueues','outbound','preview','dialOrderByScheduledAt','sequelize','transaction','YYYY-MM-DD\x20HH:mm:ss','direction','prev','isEmpty','hopperIds','priority','ASC','DESC','literal','COALESCE(CmHopper.UserId,\x200)\x20ASC','COALESCE(CmHopper.UserId,\x200)\x20DESC','scheduledat','LOCK','UPDATE','CmCompany','CmList','List','Queue','getOpenContacts','isNumber','CmHopper,\x20%s,\x20%s,\x20%s','html-pdf','eml-format','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','sendStatus','status','end','json','count','offset','limit','set','apply','reject','save','update','destroy','error','stack'];(function(_0x1caf6a,_0x26a5bf){var _0x1bf493=function(_0x3982f5){while(--_0x3982f5){_0x1caf6a['push'](_0x1caf6a['shift']());}};_0x1bf493(++_0x26a5bf);}(_0x0352,0xf1));var _0x2035=function(_0x41827f,_0x21a9ec){_0x41827f=_0x41827f-0x0;var _0x5860c2=_0x0352[_0x41827f];return _0x5860c2;};'use strict';var pdf=require(_0x2035('0x0'));var emlformat=require(_0x2035('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x2035('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x2035('0x3'));var moment=require(_0x2035('0x4'));var BPromise=require(_0x2035('0x5'));var Mustache=require(_0x2035('0x6'));var util=require(_0x2035('0x7'));var path=require(_0x2035('0x8'));var sox=require(_0x2035('0x9'));var csv=require(_0x2035('0xa'));var ejs=require(_0x2035('0xb'));var fs=require('fs');var _=require(_0x2035('0xc'));var squel=require(_0x2035('0xd'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x2035('0xe'));var toCsv=require(_0x2035('0xa'));var querystring=require(_0x2035('0xf'));var Papa=require(_0x2035('0x10'));var Redis=require(_0x2035('0x11'));var authService=require(_0x2035('0x12'));var qs=require(_0x2035('0x13'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x2035('0x14'));var logger=require(_0x2035('0x15'))('api');var utils=require(_0x2035('0x16'));var config=require(_0x2035('0x17'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x23d6eb,_0x5a3772){_0x5a3772=_0x5a3772||0xcc;return function(_0x38fc95){if(_0x38fc95){return _0x23d6eb[_0x2035('0x18')](_0x5a3772);}return _0x23d6eb[_0x2035('0x19')](_0x5a3772)[_0x2035('0x1a')]();};}function respondWithResult(_0x2e4dbe,_0x22c002){_0x22c002=_0x22c002||0xc8;return function(_0x180dea){if(_0x180dea){return _0x2e4dbe[_0x2035('0x19')](_0x22c002)[_0x2035('0x1b')](_0x180dea);}};}function respondWithFilteredResult(_0x3e5a37,_0x3a9ac6){return function(_0x824e6b){if(_0x824e6b){var _0x4cc234=_0x824e6b[_0x2035('0x1c')],_0x4d897f=_0x3a9ac6[_0x2035('0x1d')],_0x2dfc0c=_0x3a9ac6[_0x2035('0x1d')]+_0x3a9ac6[_0x2035('0x1e')],_0x499a5d;if(_0x2dfc0c>=_0x4cc234){_0x2dfc0c=_0x4cc234;_0x499a5d=0xc8;}else{_0x499a5d=0xce;}_0x3e5a37[_0x2035('0x19')](_0x499a5d);return _0x3e5a37[_0x2035('0x1f')]('Content-Range',_0x4d897f+'-'+_0x2dfc0c+'/'+_0x4cc234)[_0x2035('0x1b')](_0x824e6b);}return null;};}function patchUpdates(_0x4751ca){return function(_0x8b61e4){try{jsonpatch[_0x2035('0x20')](_0x8b61e4,_0x4751ca,!![]);}catch(_0x24dc48){return BPromise[_0x2035('0x21')](_0x24dc48);}return _0x8b61e4[_0x2035('0x22')]();};}function saveUpdates(_0x501963,_0x3e6b80){return function(_0x513f94){if(_0x513f94){return _0x513f94[_0x2035('0x23')](_0x501963)['then'](function(_0xbf0045){return _0xbf0045;});}return null;};}function removeEntity(_0x44c961,_0x1742fe){return function(_0x235250){if(_0x235250){return _0x235250[_0x2035('0x24')]()['then'](function(){_0x44c961[_0x2035('0x19')](0xcc)[_0x2035('0x1a')]();});}};}function handleEntityNotFound(_0x39d60d,_0x2daf1b){return function(_0x304551){if(!_0x304551){_0x39d60d[_0x2035('0x18')](0x194);}return _0x304551;};}function handleError(_0x583ac0,_0x41b4eb){_0x41b4eb=_0x41b4eb||0x1f4;return function(_0xda61c0){logger[_0x2035('0x25')](_0xda61c0[_0x2035('0x26')]);if(_0xda61c0[_0x2035('0x27')]){delete _0xda61c0['name'];}_0x583ac0[_0x2035('0x19')](_0x41b4eb)[_0x2035('0x28')](_0xda61c0);};}exports[_0x2035('0x29')]=function(_0x3edef7,_0x39547d){var _0x21fe20={},_0x5aa978={},_0x3236bb={'count':0x0,'rows':[]};var _0x29a42b=_[_0x2035('0x2a')](db['CmHopper'][_0x2035('0x2b')],function(_0x25c694){return{'name':_0x25c694['fieldName'],'type':_0x25c694[_0x2035('0x2c')][_0x2035('0x2d')]};});_0x5aa978['model']=_['map'](_0x29a42b,_0x2035('0x27'));_0x5aa978[_0x2035('0x2e')]=_['keys'](_0x3edef7['query']);_0x5aa978[_0x2035('0x2f')]=_[_0x2035('0x30')](_0x5aa978[_0x2035('0x31')],_0x5aa978['query']);_0x5aa978['filters']=_[_0x2035('0x32')](_0x5aa978['filters'],[_0x2035('0x33'),'$or',_0x2035('0x34'),_0x2035('0x35'),_0x2035('0x36'),_0x2035('0x37'),_0x2035('0x38'),'$eq',_0x2035('0x39'),_0x2035('0x3a'),'$notBetween','$in','$notIn','$like',_0x2035('0x3b'),'$iLike',_0x2035('0x3c'),'$like','$overlap',_0x2035('0x3d'),'$contained',_0x2035('0x3e')]);_0x21fe20[_0x2035('0x3f')]=_[_0x2035('0x30')](_0x5aa978[_0x2035('0x31')],qs[_0x2035('0x40')](_0x3edef7['query'][_0x2035('0x40')]));_0x21fe20[_0x2035('0x3f')]=_0x21fe20[_0x2035('0x3f')][_0x2035('0x41')]?_0x21fe20['attributes']:_0x5aa978['model'];if(!_0x3edef7[_0x2035('0x2e')][_0x2035('0x42')](_0x2035('0x43'))){_0x21fe20[_0x2035('0x1e')]=qs[_0x2035('0x1e')](_0x3edef7[_0x2035('0x2e')][_0x2035('0x1e')]);_0x21fe20[_0x2035('0x1d')]=qs[_0x2035('0x1d')](_0x3edef7[_0x2035('0x2e')]['offset']);}_0x21fe20['order']=qs['sort'](_0x3edef7['query'][_0x2035('0x44')]);_0x21fe20[_0x2035('0x45')]=qs[_0x2035('0x2f')](_[_0x2035('0x46')](_0x3edef7[_0x2035('0x2e')],_0x5aa978[_0x2035('0x2f')]),_0x29a42b);if(_0x3edef7[_0x2035('0x2e')][_0x2035('0x47')]){_0x21fe20[_0x2035('0x45')]=_['merge'](_0x21fe20[_0x2035('0x45')],{'$or':_['map'](_0x29a42b,function(_0x2401f3){if(_0x2401f3['type']!=='VIRTUAL'){var _0x78394a={};_0x78394a[_0x2401f3[_0x2035('0x27')]]={'$like':'%'+_0x3edef7['query'][_0x2035('0x47')]+'%'};return _0x78394a;}})});}_0x21fe20=_[_0x2035('0x48')]({},_0x21fe20,_0x3edef7[_0x2035('0x49')]);var _0x41ad5d={'where':_0x21fe20[_0x2035('0x45')]};return db[_0x2035('0x4a')][_0x2035('0x1c')](_0x41ad5d)[_0x2035('0x4b')](function(_0x177334){_0x3236bb[_0x2035('0x1c')]=_0x177334;if(_0x3edef7['query'][_0x2035('0x4c')]){_0x21fe20[_0x2035('0x4d')]=[{'all':!![]}];}return db['CmHopper'][_0x2035('0x4e')](_0x21fe20);})[_0x2035('0x4b')](function(_0x47ab57){_0x3236bb[_0x2035('0x4f')]=_0x47ab57;return _0x3236bb;})['then'](respondWithFilteredResult(_0x39547d,_0x21fe20))[_0x2035('0x50')](handleError(_0x39547d,null));};exports['show']=function(_0x38d140,_0x5f4267){var _0x2cb4b7={'raw':!![],'where':{'id':_0x38d140[_0x2035('0x51')]['id']}},_0x5c65f5={};_0x5c65f5['model']=_['keys'](db['CmHopper']['rawAttributes']);_0x5c65f5[_0x2035('0x2e')]=_[_0x2035('0x52')](_0x38d140[_0x2035('0x2e')]);_0x5c65f5[_0x2035('0x2f')]=_[_0x2035('0x30')](_0x5c65f5['model'],_0x5c65f5[_0x2035('0x2e')]);_0x2cb4b7[_0x2035('0x3f')]=_[_0x2035('0x30')](_0x5c65f5[_0x2035('0x31')],qs[_0x2035('0x40')](_0x38d140[_0x2035('0x2e')][_0x2035('0x40')]));_0x2cb4b7[_0x2035('0x3f')]=_0x2cb4b7['attributes']['length']?_0x2cb4b7['attributes']:_0x5c65f5[_0x2035('0x31')];if(_0x38d140['query'][_0x2035('0x4c')]){_0x2cb4b7['include']=[{'all':!![]}];}_0x2cb4b7=_[_0x2035('0x48')]({},_0x2cb4b7,_0x38d140['options']);return db['CmHopper'][_0x2035('0x53')](_0x2cb4b7)[_0x2035('0x4b')](handleEntityNotFound(_0x5f4267,null))[_0x2035('0x4b')](respondWithResult(_0x5f4267,null))['catch'](handleError(_0x5f4267,null));};exports[_0x2035('0x54')]=function(_0x3c2cd6,_0x1ae202){return db[_0x2035('0x4a')]['create'](_0x3c2cd6[_0x2035('0x55')],{})[_0x2035('0x4b')](respondWithResult(_0x1ae202,0xc9))[_0x2035('0x50')](handleError(_0x1ae202,null));};exports[_0x2035('0x23')]=function(_0x532048,_0x57ffc1){if(_0x532048[_0x2035('0x55')]['id']){delete _0x532048[_0x2035('0x55')]['id'];}return db[_0x2035('0x4a')][_0x2035('0x53')]({'where':{'id':_0x532048[_0x2035('0x51')]['id']}})['then'](handleEntityNotFound(_0x57ffc1,null))['then'](saveUpdates(_0x532048[_0x2035('0x55')],null))[_0x2035('0x4b')](respondWithResult(_0x57ffc1,null))[_0x2035('0x50')](handleError(_0x57ffc1,null));};exports[_0x2035('0x56')]=function(_0x4c0e06,_0x39e984){return db[_0x2035('0x4a')][_0x2035('0x56')]()['then'](respondWithResult(_0x39e984,null))[_0x2035('0x50')](handleError(_0x39e984,null));};exports[_0x2035('0x24')]=function(_0x4247ba,_0x5a0240){var _0x322498;return db[_0x2035('0x4a')][_0x2035('0x53')]({'where':{'id':_0x4247ba[_0x2035('0x51')]['id']}})[_0x2035('0x4b')](handleEntityNotFound(_0x5a0240,null))[_0x2035('0x4b')](function(_0x5e0b58){if(_0x5e0b58){return _0x5e0b58[_0x2035('0x24')]()[_0x2035('0x4b')](function(_0x1a4ed5){return _0x1a4ed5;});}})[_0x2035('0x4b')](function(_0x307856){_0x322498=_0x307856;if(_0x307856){if(_0x307856['VoiceQueueId']||_0x307856[_0x2035('0x57')]){return db[_0x307856[_0x2035('0x58')]?_0x2035('0x59'):_0x2035('0x5a')][_0x2035('0x53')]({'where':{'id':_0x307856[_0x2035('0x58')]?_0x307856[_0x2035('0x58')]:_0x307856[_0x2035('0x57')]},'attributes':['id',_0x2035('0x27')],'raw':!![]});}}})[_0x2035('0x4b')](function(_0x1b25d7){var _0x246abe={};if(_0x1b25d7){_[_0x2035('0x48')](_0x246abe,_[_0x2035('0x5b')](_0x322498[_0x2035('0x5c')],[_0x2035('0x5d'),_0x2035('0x5e'),'id']));_0x246abe['state']=0x15;_0x246abe[_0x2035('0x5f')]=_0x2035('0x60');_0x246abe[_0x2035('0x61')]=_0x1b25d7[_0x2035('0x27')];_0x246abe[_0x2035('0x62')]=_0x4247ba[_0x2035('0x63')]['name'];_0x246abe[_0x2035('0x64')]=_0x4247ba[_0x2035('0x63')]['id'];_0x246abe['deleted']=!![];_0x246abe['deletedat']=moment()[_0x2035('0x65')]('YYYY-MM-DD\x20HH:mm:ss');_0x246abe[_0x2035('0x66')]=_0x322498[_0x2035('0x67')];_0x246abe[_0x2035('0x68')]=_0x322498['VoiceQueueId']?'queue':_0x2035('0x69');return db[_0x2035('0x6a')][_0x2035('0x53')]({'where':{'id':_0x246abe['ContactId']},'attributes':[_0x2035('0x6b'),_0x2035('0x6c')]})[_0x2035('0x4b')](function(_0x408bc1){if(!_[_0x2035('0x6d')](_0x5a0240)&&!_['isNil'](_0x408bc1[_0x2035('0x6b')])){_0x246abe['calleridname']=_0x408bc1[_0x2035('0x6b')];if(!_[_0x2035('0x6d')](_0x408bc1[_0x2035('0x6c')])){_0x246abe['calleridname']+='\x20'+_0x408bc1['lastName'];}}})[_0x2035('0x6e')](function(){return db[_0x2035('0x6f')][_0x2035('0x54')](_0x246abe);});}})[_0x2035('0x4b')](function(){return _0x5a0240[_0x2035('0x19')](0xcc)[_0x2035('0x1a')]();})[_0x2035('0x50')](handleError(_0x5a0240,null));};exports[_0x2035('0x70')]=function(_0x47324f,_0x2b92d9,_0x154638){var _0x507af9=[];return db[_0x2035('0x6a')][_0x2035('0x56')]()[_0x2035('0x4b')](function(_0x32e12b){_0x507af9=_[_0x2035('0x52')](_0x32e12b);return _0x47324f[_0x2035('0x63')][_0x2035('0x71')]({'where':{'type':_0x2035('0x72'),'dialActive':!![],'dialMethod':_0x2035('0x73')},'attributes':['id',_0x2035('0x74')],'raw':!![]});})[_0x2035('0x4b')](function(_0x102c75){if(_0x102c75&&_0x102c75[_0x2035('0x41')]){return db[_0x2035('0x75')][_0x2035('0x76')](function(_0xe0b27b){var _0x3cd2dd={'active':![],'recallme':![],'scheduledAt':{'$lte':moment()[_0x2035('0x65')](_0x2035('0x77'))},'VoiceQueueId':{'$in':_[_0x2035('0x2a')](_0x102c75,'id')},'$or':[{'UserId':null},{'UserId':_0x47324f[_0x2035('0x63')]['id']}]};var _0x240518=[];if(_0x47324f[_0x2035('0x55')][_0x2035('0x78')]&&_0x47324f[_0x2035('0x55')]['direction']===_0x2035('0x79')){if(!_[_0x2035('0x7a')](_0x47324f[_0x2035('0x55')][_0x2035('0x7b')])){_0x3cd2dd['id']={'$in':_0x47324f[_0x2035('0x55')][_0x2035('0x7b')]};}_0x240518=[[_0x2035('0x7c'),_0x2035('0x7d')],['scheduledAt',_0x102c75[0x0]['dialOrderByScheduledAt']===_0x2035('0x7d')?_0x2035('0x7e'):_0x2035('0x7d')],db[_0x2035('0x75')][_0x2035('0x7f')](_0x2035('0x80')),['id',_0x2035('0x7e')]];}else{if(!_[_0x2035('0x7a')](_0x47324f[_0x2035('0x55')][_0x2035('0x7b')])){_0x3cd2dd['id']={'$notIn':_0x47324f[_0x2035('0x55')][_0x2035('0x7b')]};}_0x240518=[['priority',_0x2035('0x7e')],['scheduledAt',_0x102c75[0x0]['dialOrderByScheduledAt']],db[_0x2035('0x75')][_0x2035('0x7f')](_0x2035('0x81')),['id',_0x2035('0x7d')]];}return db[_0x2035('0x4a')]['findOne']({'attributes':['id',_0x2035('0x82')],'where':_0x3cd2dd,'order':_0x240518,'transaction':_0xe0b27b,'lock':_0xe0b27b[_0x2035('0x83')][_0x2035('0x84')],'include':[{'model':db['CmContact'],'as':'Contact','attributes':_0x507af9,'include':[{'model':db[_0x2035('0x85')],'as':'Company','attributes':['id',_0x2035('0x27')]}]},{'model':db[_0x2035('0x86')],'as':_0x2035('0x87'),'attributes':['id',_0x2035('0x27')]},{'model':db[_0x2035('0x59')],'as':_0x2035('0x88'),'attributes':['id',_0x2035('0x27'),'dialActive']}]})[_0x2035('0x4b')](function(_0x1f2317){if(_0x1f2317){return _0x1f2317[_0x2035('0x23')]({'UserId':_0x47324f['user']['id']},{'transaction':_0xe0b27b});}});});}})['then'](handleEntityNotFound(_0x2b92d9,null))[_0x2035('0x4b')](respondWithResult(_0x2b92d9,null))[_0x2035('0x50')](handleError(_0x2b92d9,null));};exports[_0x2035('0x89')]=function(_0x53a379,_0x167c43,_0x3e96a1){return _0x53a379['user'][_0x2035('0x71')]({'where':{'type':_0x2035('0x72'),'dialActive':!![],'dialMethod':_0x2035('0x73')},'attributes':['id'],'raw':!![]})['then'](function(_0x33d102){if(_0x33d102&&_0x33d102['length']){return db[_0x2035('0x4a')][_0x2035('0x1c')]({'where':{'active':![],'recallme':![],'scheduledAt':{'$lte':moment()[_0x2035('0x65')](_0x2035('0x77'))},'VoiceQueueId':{'$in':_[_0x2035('0x2a')](_0x33d102,'id')},'$or':[{'UserId':null},{'UserId':_0x53a379[_0x2035('0x63')]['id']}]}});}return 0x0;})['then'](function(_0x51a47a){if(!_['isNil'](_0x51a47a)&&_[_0x2035('0x8a')](_0x51a47a)){return _0x167c43[_0x2035('0x19')](0xc8)['json']({'contacts':_0x51a47a});}else{logger[_0x2035('0x25')](_0x2035('0x8b'),_0x2035('0x89'),0x194,'entity\x20not\x20found');_0x167c43[_0x2035('0x18')](0x194);}})[_0x2035('0x50')](handleError(_0x167c43,null));};