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 _0x13e0=['Content-Range','save','update','then','destroy','end','error','stack','name','send','index','VoiceQueueReport','rawAttributes','type','key','model','map','keys','query','filters','intersection','attributes','fields','nolimit','sort','where','merge','VIRTUAL','filter','includeAll','include','findAll','rows','show','params','length','options','find','catch','body','describe','getVoiceQueuesReport','hasOwnProperty','order','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','fs-extra','lodash','squel','crypto','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/environment','../../config/license/util','../../mysqldb','redis','localhost','socket.io-emitter','./voiceQueueReport.socket','register','sendStatus','status','json','offset','undefined','limit','count'];(function(_0x138144,_0x14a733){var _0x489bbd=function(_0x5324c1){while(--_0x5324c1){_0x138144['push'](_0x138144['shift']());}};_0x489bbd(++_0x14a733);}(_0x13e0,0x119));var _0x013e=function(_0x29b462,_0x1b741b){_0x29b462=_0x29b462-0x0;var _0x39b72f=_0x13e0[_0x29b462];return _0x39b72f;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0x013e('0x0'));var jsonpatch=require(_0x013e('0x1'));var rp=require(_0x013e('0x2'));var moment=require(_0x013e('0x3'));var BPromise=require(_0x013e('0x4'));var Mustache=require(_0x013e('0x5'));var util=require(_0x013e('0x6'));var path=require('path');var sox=require(_0x013e('0x7'));var csv=require(_0x013e('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x013e('0x9'));var _=require(_0x013e('0xa'));var squel=require(_0x013e('0xb'));var crypto=require(_0x013e('0xc'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x013e('0x8'));var querystring=require(_0x013e('0xd'));var Papa=require(_0x013e('0xe'));var Redis=require('ioredis');var authService=require(_0x013e('0xf'));var qs=require(_0x013e('0x10'));var as=require(_0x013e('0x11'));var hardwareService=require(_0x013e('0x12'));var logger=require('../../config/logger')(_0x013e('0x13'));var utils=require('../../config/utils');var config=require(_0x013e('0x14'));var licenseUtil=require(_0x013e('0x15'));var db=require(_0x013e('0x16'))['db'];config[_0x013e('0x17')]=_['defaults'](config['redis'],{'host':_0x013e('0x18'),'port':0x18eb});var socket=require(_0x013e('0x19'))(new Redis(config[_0x013e('0x17')]));require(_0x013e('0x1a'))[_0x013e('0x1b')](socket);function respondWithStatusCode(_0x50dc63,_0xb37706){_0xb37706=_0xb37706||0xcc;return function(_0x5da507){if(_0x5da507){return _0x50dc63[_0x013e('0x1c')](_0xb37706);}return _0x50dc63[_0x013e('0x1d')](_0xb37706)['end']();};}function respondWithResult(_0x5e74f0,_0x15dfef){_0x15dfef=_0x15dfef||0xc8;return function(_0x5b93f2){if(_0x5b93f2){return _0x5e74f0[_0x013e('0x1d')](_0x15dfef)[_0x013e('0x1e')](_0x5b93f2);}};}function respondWithFilteredResult(_0x32fcfc,_0x23a355){return function(_0x37ad73){if(_0x37ad73){var _0x4de73f=typeof _0x23a355[_0x013e('0x1f')]===_0x013e('0x20')&&typeof _0x23a355[_0x013e('0x21')]===_0x013e('0x20');var _0x18c4de=_0x37ad73[_0x013e('0x22')];var _0x40861c=_0x4de73f?0x0:_0x23a355['offset'];var _0x24a388=_0x4de73f?_0x37ad73[_0x013e('0x22')]:_0x23a355['offset']+_0x23a355[_0x013e('0x21')];var _0x48a677;if(_0x24a388>=_0x18c4de){_0x24a388=_0x18c4de;_0x48a677=0xc8;}else{_0x48a677=0xce;}_0x32fcfc[_0x013e('0x1d')](_0x48a677);return _0x32fcfc['set'](_0x013e('0x23'),_0x40861c+'-'+_0x24a388+'/'+_0x18c4de)[_0x013e('0x1e')](_0x37ad73);}return null;};}function patchUpdates(_0x106218){return function(_0x2f7889){try{jsonpatch['apply'](_0x2f7889,_0x106218,!![]);}catch(_0x55aba9){return BPromise['reject'](_0x55aba9);}return _0x2f7889[_0x013e('0x24')]();};}function saveUpdates(_0x4e69c2,_0x58b40d){return function(_0x4a1e32){if(_0x4a1e32){return _0x4a1e32[_0x013e('0x25')](_0x4e69c2)[_0x013e('0x26')](function(_0x7bb5da){return _0x7bb5da;});}return null;};}function removeEntity(_0x206885,_0x1689b3){return function(_0x3e89cb){if(_0x3e89cb){return _0x3e89cb[_0x013e('0x27')]()[_0x013e('0x26')](function(){_0x206885[_0x013e('0x1d')](0xcc)[_0x013e('0x28')]();});}};}function handleEntityNotFound(_0x5110ff,_0x593d22){return function(_0x590166){if(!_0x590166){_0x5110ff['sendStatus'](0x194);}return _0x590166;};}function handleError(_0xfbb811,_0x1357c3){_0x1357c3=_0x1357c3||0x1f4;return function(_0x5e869e){logger[_0x013e('0x29')](_0x5e869e[_0x013e('0x2a')]);if(_0x5e869e[_0x013e('0x2b')]){delete _0x5e869e[_0x013e('0x2b')];}_0xfbb811['status'](_0x1357c3)[_0x013e('0x2c')](_0x5e869e);};}exports[_0x013e('0x2d')]=function(_0x5cf110,_0x4a5de3){var _0x445454={},_0x37e74a={},_0x5ba59e={'count':0x0,'rows':[]};var _0x5a6903=_['map'](db[_0x013e('0x2e')][_0x013e('0x2f')],function(_0x3a1e83){return{'name':_0x3a1e83['fieldName'],'type':_0x3a1e83[_0x013e('0x30')][_0x013e('0x31')]};});_0x37e74a[_0x013e('0x32')]=_[_0x013e('0x33')](_0x5a6903,_0x013e('0x2b'));_0x37e74a['query']=_[_0x013e('0x34')](_0x5cf110[_0x013e('0x35')]);_0x37e74a[_0x013e('0x36')]=_[_0x013e('0x37')](_0x37e74a[_0x013e('0x32')],_0x37e74a[_0x013e('0x35')]);_0x445454[_0x013e('0x38')]=_[_0x013e('0x37')](_0x37e74a[_0x013e('0x32')],qs[_0x013e('0x39')](_0x5cf110[_0x013e('0x35')][_0x013e('0x39')]));_0x445454[_0x013e('0x38')]=_0x445454[_0x013e('0x38')]['length']?_0x445454['attributes']:_0x37e74a['model'];if(!_0x5cf110[_0x013e('0x35')]['hasOwnProperty'](_0x013e('0x3a'))){_0x445454['limit']=qs[_0x013e('0x21')](_0x5cf110['query'][_0x013e('0x21')]);_0x445454[_0x013e('0x1f')]=qs['offset'](_0x5cf110[_0x013e('0x35')][_0x013e('0x1f')]);}_0x445454['order']=qs[_0x013e('0x3b')](_0x5cf110[_0x013e('0x35')][_0x013e('0x3b')]);_0x445454[_0x013e('0x3c')]=qs['filters'](_['pick'](_0x5cf110['query'],_0x37e74a['filters']),_0x5a6903);if(_0x5cf110[_0x013e('0x35')]['filter']){_0x445454['where']=_[_0x013e('0x3d')](_0x445454[_0x013e('0x3c')],{'$or':_[_0x013e('0x33')](_0x5a6903,function(_0x17ebdb){if(_0x17ebdb['type']!==_0x013e('0x3e')){var _0x445d31={};_0x445d31[_0x17ebdb[_0x013e('0x2b')]]={'$like':'%'+_0x5cf110[_0x013e('0x35')][_0x013e('0x3f')]+'%'};return _0x445d31;}})});}_0x445454=_[_0x013e('0x3d')]({},_0x445454,_0x5cf110['options']);var _0x22e8dd={'where':_0x445454[_0x013e('0x3c')]};return db[_0x013e('0x2e')]['count'](_0x22e8dd)['then'](function(_0xfc0aed){_0x5ba59e[_0x013e('0x22')]=_0xfc0aed;if(_0x5cf110[_0x013e('0x35')][_0x013e('0x40')]){_0x445454[_0x013e('0x41')]=[{'all':!![]}];}return db[_0x013e('0x2e')][_0x013e('0x42')](_0x445454);})[_0x013e('0x26')](function(_0x251e03){_0x5ba59e[_0x013e('0x43')]=_0x251e03;return _0x5ba59e;})['then'](respondWithFilteredResult(_0x4a5de3,_0x445454))['catch'](handleError(_0x4a5de3,null));};exports[_0x013e('0x44')]=function(_0x5bf069,_0x310c63){var _0x55b7ed={'raw':![],'where':{'id':_0x5bf069[_0x013e('0x45')]['id']}},_0x1da086={};_0x1da086['model']=_[_0x013e('0x34')](db[_0x013e('0x2e')][_0x013e('0x2f')]);_0x1da086[_0x013e('0x35')]=_[_0x013e('0x34')](_0x5bf069['query']);_0x1da086[_0x013e('0x36')]=_[_0x013e('0x37')](_0x1da086[_0x013e('0x32')],_0x1da086[_0x013e('0x35')]);_0x55b7ed[_0x013e('0x38')]=_['intersection'](_0x1da086[_0x013e('0x32')],qs[_0x013e('0x39')](_0x5bf069[_0x013e('0x35')][_0x013e('0x39')]));_0x55b7ed[_0x013e('0x38')]=_0x55b7ed[_0x013e('0x38')][_0x013e('0x46')]?_0x55b7ed['attributes']:_0x1da086['model'];if(_0x5bf069[_0x013e('0x35')]['includeAll']){_0x55b7ed[_0x013e('0x41')]=[{'all':!![]}];}_0x55b7ed=_[_0x013e('0x3d')]({},_0x55b7ed,_0x5bf069[_0x013e('0x47')]);return db['VoiceQueueReport'][_0x013e('0x48')](_0x55b7ed)['then'](handleEntityNotFound(_0x310c63,null))['then'](respondWithResult(_0x310c63,null))[_0x013e('0x49')](handleError(_0x310c63,null));};exports['create']=function(_0x2b0385,_0x200c4a){return db[_0x013e('0x2e')]['create'](_0x2b0385['body'],{})[_0x013e('0x26')](respondWithResult(_0x200c4a,0xc9))[_0x013e('0x49')](handleError(_0x200c4a,null));};exports[_0x013e('0x25')]=function(_0x1eefdf,_0x24f4c5){if(_0x1eefdf[_0x013e('0x4a')]['id']){delete _0x1eefdf[_0x013e('0x4a')]['id'];}return db['VoiceQueueReport'][_0x013e('0x48')]({'where':{'id':_0x1eefdf['params']['id']}})[_0x013e('0x26')](handleEntityNotFound(_0x24f4c5,null))['then'](saveUpdates(_0x1eefdf[_0x013e('0x4a')],null))['then'](respondWithResult(_0x24f4c5,null))[_0x013e('0x49')](handleError(_0x24f4c5,null));};exports[_0x013e('0x27')]=function(_0x58579d,_0x23f062){return db['VoiceQueueReport'][_0x013e('0x48')]({'where':{'id':_0x58579d[_0x013e('0x45')]['id']}})['then'](handleEntityNotFound(_0x23f062,null))[_0x013e('0x26')](removeEntity(_0x23f062,null))[_0x013e('0x49')](handleError(_0x23f062,null));};exports['describe']=function(_0x2de74b,_0x2f3ab2){return db[_0x013e('0x2e')][_0x013e('0x4b')]()['then'](respondWithResult(_0x2f3ab2,null))[_0x013e('0x49')](handleError(_0x2f3ab2,null));};exports[_0x013e('0x4c')]=function(_0x3c1fe7,_0x408a7c){var _0x50cdb8={},_0xaf36dc={},_0x2d6a1b={'count':0x0,'rows':[]};_0xaf36dc[_0x013e('0x32')]=_[_0x013e('0x34')](db[_0x013e('0x2e')][_0x013e('0x2f')]);_0xaf36dc[_0x013e('0x35')]=_[_0x013e('0x34')](_0x3c1fe7[_0x013e('0x35')]);_0xaf36dc['filters']=_[_0x013e('0x37')](_0xaf36dc['model'],_0xaf36dc['query']);_0x50cdb8[_0x013e('0x38')]=_[_0x013e('0x37')](_0xaf36dc[_0x013e('0x32')],qs['fields'](_0x3c1fe7[_0x013e('0x35')][_0x013e('0x39')]));_0x50cdb8['attributes']=_0x50cdb8[_0x013e('0x38')][_0x013e('0x46')]?_0x50cdb8[_0x013e('0x38')]:_0xaf36dc['model'];if(!_0x3c1fe7[_0x013e('0x35')][_0x013e('0x4d')](_0x013e('0x3a'))){_0x50cdb8['limit']=qs[_0x013e('0x21')](_0x3c1fe7[_0x013e('0x35')][_0x013e('0x21')]);_0x50cdb8[_0x013e('0x1f')]=qs['offset'](_0x3c1fe7['query'][_0x013e('0x1f')]);}_0x50cdb8[_0x013e('0x4e')]=qs['sort'](_0x3c1fe7[_0x013e('0x35')]['sort']);_0x50cdb8['where']=qs[_0x013e('0x36')](_['pick'](_0x3c1fe7[_0x013e('0x35')],_0xaf36dc['filters']));if(_0x3c1fe7['query'][_0x013e('0x3f')]){_0x50cdb8['where']=_[_0x013e('0x3d')](_0x50cdb8['where'],{'$or':_[_0x013e('0x33')](_0x50cdb8['attributes'],function(_0x405ea7){var _0x1e9511={};_0x1e9511[_0x405ea7]={'$like':'%'+_0x3c1fe7[_0x013e('0x35')][_0x013e('0x3f')]+'%'};return _0x1e9511;})});}_0x50cdb8=_['merge']({},_0x50cdb8,_0x3c1fe7['options']);var _0x4b70d2={'where':_0x50cdb8[_0x013e('0x3c')]};return db[_0x013e('0x2e')][_0x013e('0x22')](_0x4b70d2)[_0x013e('0x26')](function(_0x112749){_0x2d6a1b[_0x013e('0x22')]=_0x112749;if(_0x3c1fe7[_0x013e('0x35')][_0x013e('0x40')]){_0x50cdb8[_0x013e('0x41')]=[{'all':!![]}];}return db[_0x013e('0x2e')][_0x013e('0x42')](_0x50cdb8);})[_0x013e('0x26')](function(_0xd916a2){_0x2d6a1b['rows']=_0xd916a2;return _0x2d6a1b;})['then'](respondWithFilteredResult(_0x408a7c,_0x50cdb8,'getVoiceQueuesReport'))[_0x013e('0x49')](handleError(_0x408a7c,null,_0x013e('0x4c')));};