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 _0x471b=['register','sendStatus','end','offset','undefined','count','status','set','Content-Range','json','apply','update','then','destroy','error','stack','name','send','map','rawAttributes','fieldName','key','model','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','limit','sort','where','pick','filter','merge','type','VIRTUAL','options','VoiceQueueReport','include','rows','catch','show','keys','find','create','body','params','describe','getVoiceQueuesReport','order','includeAll','findAll','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','fs-extra','lodash','squel','crypto','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','localhost','socket.io-emitter','./voiceQueueReport.socket'];(function(_0x21b8eb,_0x5546fb){var _0x1ed424=function(_0x473675){while(--_0x473675){_0x21b8eb['push'](_0x21b8eb['shift']());}};_0x1ed424(++_0x5546fb);}(_0x471b,0x133));var _0xb471=function(_0x503282,_0x4ea191){_0x503282=_0x503282-0x0;var _0x5b5fc9=_0x471b[_0x503282];return _0x5b5fc9;};'use strict';var emlformat=require(_0xb471('0x0'));var rimraf=require(_0xb471('0x1'));var zipdir=require(_0xb471('0x2'));var jsonpatch=require(_0xb471('0x3'));var rp=require(_0xb471('0x4'));var moment=require(_0xb471('0x5'));var BPromise=require(_0xb471('0x6'));var Mustache=require(_0xb471('0x7'));var util=require(_0xb471('0x8'));var path=require(_0xb471('0x9'));var sox=require(_0xb471('0xa'));var csv=require(_0xb471('0xb'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xb471('0xc'));var _=require(_0xb471('0xd'));var squel=require(_0xb471('0xe'));var crypto=require(_0xb471('0xf'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0xb471('0xb'));var querystring=require('querystring');var Papa=require(_0xb471('0x10'));var Redis=require('ioredis');var authService=require(_0xb471('0x11'));var qs=require(_0xb471('0x12'));var as=require(_0xb471('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0xb471('0x14'));var utils=require(_0xb471('0x15'));var config=require(_0xb471('0x16'));var licenseUtil=require(_0xb471('0x17'));var db=require(_0xb471('0x18'))['db'];config[_0xb471('0x19')]=_['defaults'](config[_0xb471('0x19')],{'host':_0xb471('0x1a'),'port':0x18eb});var socket=require(_0xb471('0x1b'))(new Redis(config[_0xb471('0x19')]));require(_0xb471('0x1c'))[_0xb471('0x1d')](socket);function respondWithStatusCode(_0x302866,_0x1618fa){_0x1618fa=_0x1618fa||0xcc;return function(_0x2d5551){if(_0x2d5551){return _0x302866[_0xb471('0x1e')](_0x1618fa);}return _0x302866['status'](_0x1618fa)[_0xb471('0x1f')]();};}function respondWithResult(_0x5499c4,_0x55f0dc){_0x55f0dc=_0x55f0dc||0xc8;return function(_0x4bef81){if(_0x4bef81){return _0x5499c4['status'](_0x55f0dc)['json'](_0x4bef81);}};}function respondWithFilteredResult(_0x268df6,_0x27da07){return function(_0x591061){if(_0x591061){var _0x1d6444=typeof _0x27da07[_0xb471('0x20')]===_0xb471('0x21')&&typeof _0x27da07['limit']===_0xb471('0x21');var _0x14f96f=_0x591061['count'];var _0x6eb2bb=_0x1d6444?0x0:_0x27da07['offset'];var _0x5a1b6f=_0x1d6444?_0x591061[_0xb471('0x22')]:_0x27da07['offset']+_0x27da07['limit'];var _0x52871f;if(_0x5a1b6f>=_0x14f96f){_0x5a1b6f=_0x14f96f;_0x52871f=0xc8;}else{_0x52871f=0xce;}_0x268df6[_0xb471('0x23')](_0x52871f);return _0x268df6[_0xb471('0x24')](_0xb471('0x25'),_0x6eb2bb+'-'+_0x5a1b6f+'/'+_0x14f96f)[_0xb471('0x26')](_0x591061);}return null;};}function patchUpdates(_0x2fb86c){return function(_0x4fecb0){try{jsonpatch[_0xb471('0x27')](_0x4fecb0,_0x2fb86c,!![]);}catch(_0x7b05bc){return BPromise['reject'](_0x7b05bc);}return _0x4fecb0['save']();};}function saveUpdates(_0x35c79d,_0x5bcbdc){return function(_0xac0e1c){if(_0xac0e1c){return _0xac0e1c[_0xb471('0x28')](_0x35c79d)[_0xb471('0x29')](function(_0x15fc8c){return _0x15fc8c;});}return null;};}function removeEntity(_0x38c14b,_0x4d7386){return function(_0x3fe1cb){if(_0x3fe1cb){return _0x3fe1cb[_0xb471('0x2a')]()['then'](function(){_0x38c14b[_0xb471('0x23')](0xcc)[_0xb471('0x1f')]();});}};}function handleEntityNotFound(_0x5ebade,_0x42f0bf){return function(_0x19268e){if(!_0x19268e){_0x5ebade[_0xb471('0x1e')](0x194);}return _0x19268e;};}function handleError(_0x34532c,_0x574e52){_0x574e52=_0x574e52||0x1f4;return function(_0x5ca23c){logger[_0xb471('0x2b')](_0x5ca23c[_0xb471('0x2c')]);if(_0x5ca23c['name']){delete _0x5ca23c[_0xb471('0x2d')];}_0x34532c['status'](_0x574e52)[_0xb471('0x2e')](_0x5ca23c);};}exports['index']=function(_0x19cc86,_0x523f9c){var _0x596711={},_0x1a15ff={},_0x45f3dc={'count':0x0,'rows':[]};var _0x3c7471=_[_0xb471('0x2f')](db['VoiceQueueReport'][_0xb471('0x30')],function(_0x323f3e){return{'name':_0x323f3e[_0xb471('0x31')],'type':_0x323f3e['type'][_0xb471('0x32')]};});_0x1a15ff[_0xb471('0x33')]=_[_0xb471('0x2f')](_0x3c7471,_0xb471('0x2d'));_0x1a15ff[_0xb471('0x34')]=_['keys'](_0x19cc86['query']);_0x1a15ff[_0xb471('0x35')]=_[_0xb471('0x36')](_0x1a15ff[_0xb471('0x33')],_0x1a15ff[_0xb471('0x34')]);_0x596711[_0xb471('0x37')]=_[_0xb471('0x36')](_0x1a15ff['model'],qs[_0xb471('0x38')](_0x19cc86[_0xb471('0x34')]['fields']));_0x596711[_0xb471('0x37')]=_0x596711[_0xb471('0x37')][_0xb471('0x39')]?_0x596711[_0xb471('0x37')]:_0x1a15ff[_0xb471('0x33')];if(!_0x19cc86['query'][_0xb471('0x3a')](_0xb471('0x3b'))){_0x596711['limit']=qs[_0xb471('0x3c')](_0x19cc86['query'][_0xb471('0x3c')]);_0x596711['offset']=qs[_0xb471('0x20')](_0x19cc86['query']['offset']);}_0x596711['order']=qs[_0xb471('0x3d')](_0x19cc86[_0xb471('0x34')]['sort']);_0x596711[_0xb471('0x3e')]=qs[_0xb471('0x35')](_[_0xb471('0x3f')](_0x19cc86[_0xb471('0x34')],_0x1a15ff[_0xb471('0x35')]),_0x3c7471);if(_0x19cc86[_0xb471('0x34')][_0xb471('0x40')]){_0x596711[_0xb471('0x3e')]=_[_0xb471('0x41')](_0x596711[_0xb471('0x3e')],{'$or':_[_0xb471('0x2f')](_0x3c7471,function(_0x37466c){if(_0x37466c[_0xb471('0x42')]!==_0xb471('0x43')){var _0x18115a={};_0x18115a[_0x37466c[_0xb471('0x2d')]]={'$like':'%'+_0x19cc86[_0xb471('0x34')]['filter']+'%'};return _0x18115a;}})});}_0x596711=_[_0xb471('0x41')]({},_0x596711,_0x19cc86[_0xb471('0x44')]);var _0x55f3a4={'where':_0x596711[_0xb471('0x3e')]};return db[_0xb471('0x45')]['count'](_0x55f3a4)['then'](function(_0x2da2d6){_0x45f3dc[_0xb471('0x22')]=_0x2da2d6;if(_0x19cc86[_0xb471('0x34')]['includeAll']){_0x596711[_0xb471('0x46')]=[{'all':!![]}];}return db[_0xb471('0x45')]['findAll'](_0x596711);})['then'](function(_0x43ebe2){_0x45f3dc[_0xb471('0x47')]=_0x43ebe2;return _0x45f3dc;})[_0xb471('0x29')](respondWithFilteredResult(_0x523f9c,_0x596711))[_0xb471('0x48')](handleError(_0x523f9c,null));};exports[_0xb471('0x49')]=function(_0x516579,_0xdbdec3){var _0x33e98a={'raw':![],'where':{'id':_0x516579['params']['id']}},_0x343e34={};_0x343e34[_0xb471('0x33')]=_[_0xb471('0x4a')](db['VoiceQueueReport'][_0xb471('0x30')]);_0x343e34[_0xb471('0x34')]=_[_0xb471('0x4a')](_0x516579[_0xb471('0x34')]);_0x343e34[_0xb471('0x35')]=_[_0xb471('0x36')](_0x343e34[_0xb471('0x33')],_0x343e34['query']);_0x33e98a[_0xb471('0x37')]=_[_0xb471('0x36')](_0x343e34['model'],qs[_0xb471('0x38')](_0x516579[_0xb471('0x34')][_0xb471('0x38')]));_0x33e98a['attributes']=_0x33e98a['attributes'][_0xb471('0x39')]?_0x33e98a[_0xb471('0x37')]:_0x343e34[_0xb471('0x33')];if(_0x516579[_0xb471('0x34')]['includeAll']){_0x33e98a[_0xb471('0x46')]=[{'all':!![]}];}_0x33e98a=_[_0xb471('0x41')]({},_0x33e98a,_0x516579[_0xb471('0x44')]);return db[_0xb471('0x45')][_0xb471('0x4b')](_0x33e98a)[_0xb471('0x29')](handleEntityNotFound(_0xdbdec3,null))[_0xb471('0x29')](respondWithResult(_0xdbdec3,null))[_0xb471('0x48')](handleError(_0xdbdec3,null));};exports[_0xb471('0x4c')]=function(_0x57622f,_0x1e131e){return db[_0xb471('0x45')][_0xb471('0x4c')](_0x57622f[_0xb471('0x4d')],{})[_0xb471('0x29')](respondWithResult(_0x1e131e,0xc9))[_0xb471('0x48')](handleError(_0x1e131e,null));};exports[_0xb471('0x28')]=function(_0x7599b3,_0x3f02fa){if(_0x7599b3[_0xb471('0x4d')]['id']){delete _0x7599b3[_0xb471('0x4d')]['id'];}return db['VoiceQueueReport'][_0xb471('0x4b')]({'where':{'id':_0x7599b3[_0xb471('0x4e')]['id']}})[_0xb471('0x29')](handleEntityNotFound(_0x3f02fa,null))[_0xb471('0x29')](saveUpdates(_0x7599b3[_0xb471('0x4d')],null))[_0xb471('0x29')](respondWithResult(_0x3f02fa,null))[_0xb471('0x48')](handleError(_0x3f02fa,null));};exports[_0xb471('0x2a')]=function(_0x1a5d8c,_0x5e5092){return db[_0xb471('0x45')]['find']({'where':{'id':_0x1a5d8c[_0xb471('0x4e')]['id']}})[_0xb471('0x29')](handleEntityNotFound(_0x5e5092,null))['then'](removeEntity(_0x5e5092,null))[_0xb471('0x48')](handleError(_0x5e5092,null));};exports['describe']=function(_0xdcad57,_0x4cc634){return db[_0xb471('0x45')][_0xb471('0x4f')]()['then'](respondWithResult(_0x4cc634,null))[_0xb471('0x48')](handleError(_0x4cc634,null));};exports[_0xb471('0x50')]=function(_0x3f1d4f,_0x54bf81){var _0x2ad268={},_0x219633={},_0x478563={'count':0x0,'rows':[]};_0x219633[_0xb471('0x33')]=_[_0xb471('0x4a')](db[_0xb471('0x45')][_0xb471('0x30')]);_0x219633[_0xb471('0x34')]=_[_0xb471('0x4a')](_0x3f1d4f[_0xb471('0x34')]);_0x219633['filters']=_[_0xb471('0x36')](_0x219633[_0xb471('0x33')],_0x219633['query']);_0x2ad268[_0xb471('0x37')]=_[_0xb471('0x36')](_0x219633['model'],qs[_0xb471('0x38')](_0x3f1d4f[_0xb471('0x34')][_0xb471('0x38')]));_0x2ad268[_0xb471('0x37')]=_0x2ad268[_0xb471('0x37')][_0xb471('0x39')]?_0x2ad268[_0xb471('0x37')]:_0x219633[_0xb471('0x33')];if(!_0x3f1d4f['query']['hasOwnProperty'](_0xb471('0x3b'))){_0x2ad268[_0xb471('0x3c')]=qs[_0xb471('0x3c')](_0x3f1d4f[_0xb471('0x34')]['limit']);_0x2ad268['offset']=qs[_0xb471('0x20')](_0x3f1d4f[_0xb471('0x34')]['offset']);}_0x2ad268[_0xb471('0x51')]=qs['sort'](_0x3f1d4f[_0xb471('0x34')][_0xb471('0x3d')]);_0x2ad268['where']=qs['filters'](_['pick'](_0x3f1d4f[_0xb471('0x34')],_0x219633['filters']));if(_0x3f1d4f[_0xb471('0x34')][_0xb471('0x40')]){_0x2ad268[_0xb471('0x3e')]=_['merge'](_0x2ad268[_0xb471('0x3e')],{'$or':_[_0xb471('0x2f')](_0x2ad268[_0xb471('0x37')],function(_0x27a65d){var _0x5af202={};_0x5af202[_0x27a65d]={'$like':'%'+_0x3f1d4f[_0xb471('0x34')][_0xb471('0x40')]+'%'};return _0x5af202;})});}_0x2ad268=_[_0xb471('0x41')]({},_0x2ad268,_0x3f1d4f[_0xb471('0x44')]);var _0x833d8c={'where':_0x2ad268['where']};return db[_0xb471('0x45')][_0xb471('0x22')](_0x833d8c)[_0xb471('0x29')](function(_0x11c9e9){_0x478563['count']=_0x11c9e9;if(_0x3f1d4f['query'][_0xb471('0x52')]){_0x2ad268['include']=[{'all':!![]}];}return db[_0xb471('0x45')][_0xb471('0x53')](_0x2ad268);})['then'](function(_0x46cdae){_0x478563[_0xb471('0x47')]=_0x46cdae;return _0x478563;})[_0xb471('0x29')](respondWithFilteredResult(_0x54bf81,_0x2ad268,_0xb471('0x50')))['catch'](handleError(_0x54bf81,null,_0xb471('0x50')));};