server/api/voiceQueueReport/voiceQueueReport.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 _0x17df=['Content-Range','apply','reject','save','update','destroy','then','sendStatus','error','stack','name','send','index','VoiceQueueReport','rawAttributes','fieldName','model','query','keys','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','where','pick','merge','map','type','VIRTUAL','options','includeAll','include','findAll','catch','params','filters','create','body','find','describe','getVoiceQueuesReport','sort','filter','rows','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','defaults','localhost','socket.io-emitter','redis','./voiceQueueReport.socket','status','end','json','offset','limit','undefined','count'];(function(_0x4dfbd1,_0x179d28){var _0x26c962=function(_0x3db7c3){while(--_0x3db7c3){_0x4dfbd1['push'](_0x4dfbd1['shift']());}};_0x26c962(++_0x179d28);}(_0x17df,0x134));var _0xf17d=function(_0x1a9e2b,_0x435edf){_0x1a9e2b=_0x1a9e2b-0x0;var _0x5e46b2=_0x17df[_0x1a9e2b];return _0x5e46b2;};'use strict';var emlformat=require(_0xf17d('0x0'));var rimraf=require(_0xf17d('0x1'));var zipdir=require(_0xf17d('0x2'));var jsonpatch=require(_0xf17d('0x3'));var rp=require(_0xf17d('0x4'));var moment=require(_0xf17d('0x5'));var BPromise=require(_0xf17d('0x6'));var Mustache=require(_0xf17d('0x7'));var util=require(_0xf17d('0x8'));var path=require(_0xf17d('0x9'));var sox=require(_0xf17d('0xa'));var csv=require(_0xf17d('0xb'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xf17d('0xc'));var _=require(_0xf17d('0xd'));var squel=require(_0xf17d('0xe'));var crypto=require(_0xf17d('0xf'));var jsforce=require(_0xf17d('0x10'));var deskjs=require(_0xf17d('0x11'));var toCsv=require(_0xf17d('0xb'));var querystring=require(_0xf17d('0x12'));var Papa=require(_0xf17d('0x13'));var Redis=require(_0xf17d('0x14'));var authService=require('../../components/auth/service');var qs=require(_0xf17d('0x15'));var as=require(_0xf17d('0x16'));var hardwareService=require(_0xf17d('0x17'));var logger=require(_0xf17d('0x18'))('api');var utils=require(_0xf17d('0x19'));var config=require(_0xf17d('0x1a'));var licenseUtil=require(_0xf17d('0x1b'));var db=require('../../mysqldb')['db'];config['redis']=_[_0xf17d('0x1c')](config['redis'],{'host':_0xf17d('0x1d'),'port':0x18eb});var socket=require(_0xf17d('0x1e'))(new Redis(config[_0xf17d('0x1f')]));require(_0xf17d('0x20'))['register'](socket);function respondWithStatusCode(_0x33a4d6,_0xce2f49){_0xce2f49=_0xce2f49||0xcc;return function(_0x80d81d){if(_0x80d81d){return _0x33a4d6['sendStatus'](_0xce2f49);}return _0x33a4d6[_0xf17d('0x21')](_0xce2f49)[_0xf17d('0x22')]();};}function respondWithResult(_0x15a716,_0x2e153e){_0x2e153e=_0x2e153e||0xc8;return function(_0x4843cc){if(_0x4843cc){return _0x15a716[_0xf17d('0x21')](_0x2e153e)[_0xf17d('0x23')](_0x4843cc);}};}function respondWithFilteredResult(_0x182814,_0x34142f){return function(_0x4807f3){if(_0x4807f3){var _0x14f19d=typeof _0x34142f[_0xf17d('0x24')]==='undefined'&&typeof _0x34142f[_0xf17d('0x25')]===_0xf17d('0x26');var _0x57a515=_0x4807f3[_0xf17d('0x27')];var _0x26d8e0=_0x14f19d?0x0:_0x34142f['offset'];var _0x26aae1=_0x14f19d?_0x4807f3['count']:_0x34142f[_0xf17d('0x24')]+_0x34142f['limit'];var _0x53de1d;if(_0x26aae1>=_0x57a515){_0x26aae1=_0x57a515;_0x53de1d=0xc8;}else{_0x53de1d=0xce;}_0x182814['status'](_0x53de1d);return _0x182814['set'](_0xf17d('0x28'),_0x26d8e0+'-'+_0x26aae1+'/'+_0x57a515)[_0xf17d('0x23')](_0x4807f3);}return null;};}function patchUpdates(_0x2c5836){return function(_0xaf7fe8){try{jsonpatch[_0xf17d('0x29')](_0xaf7fe8,_0x2c5836,!![]);}catch(_0x5285e9){return BPromise[_0xf17d('0x2a')](_0x5285e9);}return _0xaf7fe8[_0xf17d('0x2b')]();};}function saveUpdates(_0xde1773,_0x3162ba){return function(_0x4f8c94){if(_0x4f8c94){return _0x4f8c94[_0xf17d('0x2c')](_0xde1773)['then'](function(_0x5f1cc3){return _0x5f1cc3;});}return null;};}function removeEntity(_0x3ff45e,_0x31331e){return function(_0x2776c0){if(_0x2776c0){return _0x2776c0[_0xf17d('0x2d')]()[_0xf17d('0x2e')](function(){_0x3ff45e[_0xf17d('0x21')](0xcc)['end']();});}};}function handleEntityNotFound(_0x92e1f5,_0x2c5f0d){return function(_0xc94804){if(!_0xc94804){_0x92e1f5[_0xf17d('0x2f')](0x194);}return _0xc94804;};}function handleError(_0x2cde5b,_0xc607ef){_0xc607ef=_0xc607ef||0x1f4;return function(_0x88dc43){logger[_0xf17d('0x30')](_0x88dc43[_0xf17d('0x31')]);if(_0x88dc43[_0xf17d('0x32')]){delete _0x88dc43[_0xf17d('0x32')];}_0x2cde5b['status'](_0xc607ef)[_0xf17d('0x33')](_0x88dc43);};}exports[_0xf17d('0x34')]=function(_0x152725,_0x45bf5d){var _0x1b2639={},_0x6b3d44={},_0x645b37={'count':0x0,'rows':[]};var _0x1f774a=_['map'](db[_0xf17d('0x35')][_0xf17d('0x36')],function(_0x3ef3f7){return{'name':_0x3ef3f7[_0xf17d('0x37')],'type':_0x3ef3f7['type']['key']};});_0x6b3d44[_0xf17d('0x38')]=_['map'](_0x1f774a,_0xf17d('0x32'));_0x6b3d44[_0xf17d('0x39')]=_[_0xf17d('0x3a')](_0x152725[_0xf17d('0x39')]);_0x6b3d44['filters']=_[_0xf17d('0x3b')](_0x6b3d44[_0xf17d('0x38')],_0x6b3d44[_0xf17d('0x39')]);_0x1b2639['attributes']=_[_0xf17d('0x3b')](_0x6b3d44[_0xf17d('0x38')],qs[_0xf17d('0x3c')](_0x152725[_0xf17d('0x39')]['fields']));_0x1b2639[_0xf17d('0x3d')]=_0x1b2639[_0xf17d('0x3d')][_0xf17d('0x3e')]?_0x1b2639[_0xf17d('0x3d')]:_0x6b3d44[_0xf17d('0x38')];if(!_0x152725[_0xf17d('0x39')][_0xf17d('0x3f')](_0xf17d('0x40'))){_0x1b2639['limit']=qs['limit'](_0x152725[_0xf17d('0x39')][_0xf17d('0x25')]);_0x1b2639[_0xf17d('0x24')]=qs[_0xf17d('0x24')](_0x152725[_0xf17d('0x39')][_0xf17d('0x24')]);}_0x1b2639[_0xf17d('0x41')]=qs['sort'](_0x152725[_0xf17d('0x39')]['sort']);_0x1b2639[_0xf17d('0x42')]=qs['filters'](_[_0xf17d('0x43')](_0x152725[_0xf17d('0x39')],_0x6b3d44['filters']),_0x1f774a);if(_0x152725[_0xf17d('0x39')]['filter']){_0x1b2639[_0xf17d('0x42')]=_[_0xf17d('0x44')](_0x1b2639[_0xf17d('0x42')],{'$or':_[_0xf17d('0x45')](_0x1f774a,function(_0x1f2829){if(_0x1f2829[_0xf17d('0x46')]!==_0xf17d('0x47')){var _0x50a9d9={};_0x50a9d9[_0x1f2829[_0xf17d('0x32')]]={'$like':'%'+_0x152725[_0xf17d('0x39')]['filter']+'%'};return _0x50a9d9;}})});}_0x1b2639=_[_0xf17d('0x44')]({},_0x1b2639,_0x152725[_0xf17d('0x48')]);var _0xfac432={'where':_0x1b2639[_0xf17d('0x42')]};return db[_0xf17d('0x35')][_0xf17d('0x27')](_0xfac432)[_0xf17d('0x2e')](function(_0x48c26e){_0x645b37[_0xf17d('0x27')]=_0x48c26e;if(_0x152725[_0xf17d('0x39')][_0xf17d('0x49')]){_0x1b2639[_0xf17d('0x4a')]=[{'all':!![]}];}return db[_0xf17d('0x35')][_0xf17d('0x4b')](_0x1b2639);})[_0xf17d('0x2e')](function(_0x28b4e5){_0x645b37['rows']=_0x28b4e5;return _0x645b37;})[_0xf17d('0x2e')](respondWithFilteredResult(_0x45bf5d,_0x1b2639))[_0xf17d('0x4c')](handleError(_0x45bf5d,null));};exports['show']=function(_0x236fb3,_0x60367d){var _0x557fea={'raw':![],'where':{'id':_0x236fb3[_0xf17d('0x4d')]['id']}},_0x3534d6={};_0x3534d6[_0xf17d('0x38')]=_[_0xf17d('0x3a')](db[_0xf17d('0x35')][_0xf17d('0x36')]);_0x3534d6[_0xf17d('0x39')]=_[_0xf17d('0x3a')](_0x236fb3['query']);_0x3534d6[_0xf17d('0x4e')]=_['intersection'](_0x3534d6[_0xf17d('0x38')],_0x3534d6['query']);_0x557fea[_0xf17d('0x3d')]=_[_0xf17d('0x3b')](_0x3534d6[_0xf17d('0x38')],qs[_0xf17d('0x3c')](_0x236fb3[_0xf17d('0x39')]['fields']));_0x557fea[_0xf17d('0x3d')]=_0x557fea[_0xf17d('0x3d')][_0xf17d('0x3e')]?_0x557fea[_0xf17d('0x3d')]:_0x3534d6[_0xf17d('0x38')];if(_0x236fb3[_0xf17d('0x39')][_0xf17d('0x49')]){_0x557fea['include']=[{'all':!![]}];}_0x557fea=_['merge']({},_0x557fea,_0x236fb3[_0xf17d('0x48')]);return db[_0xf17d('0x35')]['find'](_0x557fea)[_0xf17d('0x2e')](handleEntityNotFound(_0x60367d,null))[_0xf17d('0x2e')](respondWithResult(_0x60367d,null))['catch'](handleError(_0x60367d,null));};exports[_0xf17d('0x4f')]=function(_0x1af6f6,_0x462a57){return db[_0xf17d('0x35')][_0xf17d('0x4f')](_0x1af6f6['body'],{})[_0xf17d('0x2e')](respondWithResult(_0x462a57,0xc9))[_0xf17d('0x4c')](handleError(_0x462a57,null));};exports[_0xf17d('0x2c')]=function(_0x5e2c4d,_0x69c093){if(_0x5e2c4d[_0xf17d('0x50')]['id']){delete _0x5e2c4d[_0xf17d('0x50')]['id'];}return db['VoiceQueueReport'][_0xf17d('0x51')]({'where':{'id':_0x5e2c4d[_0xf17d('0x4d')]['id']}})[_0xf17d('0x2e')](handleEntityNotFound(_0x69c093,null))[_0xf17d('0x2e')](saveUpdates(_0x5e2c4d['body'],null))[_0xf17d('0x2e')](respondWithResult(_0x69c093,null))[_0xf17d('0x4c')](handleError(_0x69c093,null));};exports['destroy']=function(_0x3818b9,_0x18d56f){return db['VoiceQueueReport'][_0xf17d('0x51')]({'where':{'id':_0x3818b9[_0xf17d('0x4d')]['id']}})[_0xf17d('0x2e')](handleEntityNotFound(_0x18d56f,null))[_0xf17d('0x2e')](removeEntity(_0x18d56f,null))[_0xf17d('0x4c')](handleError(_0x18d56f,null));};exports[_0xf17d('0x52')]=function(_0x157b8c,_0x15966c){return db[_0xf17d('0x35')][_0xf17d('0x52')]()['then'](respondWithResult(_0x15966c,null))[_0xf17d('0x4c')](handleError(_0x15966c,null));};exports[_0xf17d('0x53')]=function(_0x14b1f0,_0x264662){var _0x38e7ad={},_0x4311cd={},_0x39070f={'count':0x0,'rows':[]};_0x4311cd['model']=_[_0xf17d('0x3a')](db[_0xf17d('0x35')][_0xf17d('0x36')]);_0x4311cd[_0xf17d('0x39')]=_[_0xf17d('0x3a')](_0x14b1f0[_0xf17d('0x39')]);_0x4311cd[_0xf17d('0x4e')]=_[_0xf17d('0x3b')](_0x4311cd['model'],_0x4311cd[_0xf17d('0x39')]);_0x38e7ad[_0xf17d('0x3d')]=_[_0xf17d('0x3b')](_0x4311cd[_0xf17d('0x38')],qs[_0xf17d('0x3c')](_0x14b1f0[_0xf17d('0x39')][_0xf17d('0x3c')]));_0x38e7ad[_0xf17d('0x3d')]=_0x38e7ad[_0xf17d('0x3d')]['length']?_0x38e7ad['attributes']:_0x4311cd['model'];if(!_0x14b1f0['query'][_0xf17d('0x3f')](_0xf17d('0x40'))){_0x38e7ad[_0xf17d('0x25')]=qs[_0xf17d('0x25')](_0x14b1f0[_0xf17d('0x39')]['limit']);_0x38e7ad[_0xf17d('0x24')]=qs[_0xf17d('0x24')](_0x14b1f0[_0xf17d('0x39')][_0xf17d('0x24')]);}_0x38e7ad[_0xf17d('0x41')]=qs[_0xf17d('0x54')](_0x14b1f0[_0xf17d('0x39')][_0xf17d('0x54')]);_0x38e7ad[_0xf17d('0x42')]=qs[_0xf17d('0x4e')](_['pick'](_0x14b1f0['query'],_0x4311cd['filters']));if(_0x14b1f0['query'][_0xf17d('0x55')]){_0x38e7ad[_0xf17d('0x42')]=_[_0xf17d('0x44')](_0x38e7ad['where'],{'$or':_[_0xf17d('0x45')](_0x38e7ad[_0xf17d('0x3d')],function(_0x5e5161){var _0x5cf00e={};_0x5cf00e[_0x5e5161]={'$like':'%'+_0x14b1f0[_0xf17d('0x39')][_0xf17d('0x55')]+'%'};return _0x5cf00e;})});}_0x38e7ad=_[_0xf17d('0x44')]({},_0x38e7ad,_0x14b1f0[_0xf17d('0x48')]);var _0x8874ab={'where':_0x38e7ad[_0xf17d('0x42')]};return db[_0xf17d('0x35')][_0xf17d('0x27')](_0x8874ab)['then'](function(_0x4a5ebc){_0x39070f[_0xf17d('0x27')]=_0x4a5ebc;if(_0x14b1f0[_0xf17d('0x39')][_0xf17d('0x49')]){_0x38e7ad[_0xf17d('0x4a')]=[{'all':!![]}];}return db['VoiceQueueReport'][_0xf17d('0x4b')](_0x38e7ad);})[_0xf17d('0x2e')](function(_0x1676bf){_0x39070f[_0xf17d('0x56')]=_0x1676bf;return _0x39070f;})[_0xf17d('0x2e')](respondWithFilteredResult(_0x264662,_0x38e7ad,_0xf17d('0x53')))[_0xf17d('0x4c')](handleError(_0x264662,null,_0xf17d('0x53')));};