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 _0xd4c4=['sox','to-csv','fs-extra','crypto','jsforce','desk.js','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./voiceQueueReport.socket','end','json','offset','limit','count','status','set','Content-Range','apply','reject','update','then','destroy','sendStatus','error','stack','name','send','map','VoiceQueueReport','rawAttributes','type','key','query','keys','filters','model','attributes','intersection','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','params','find','catch','create','body','describe','getVoiceQueuesReport','rimraf','zip-dir','fast-json-patch','bluebird','mustache','util','path'];(function(_0x59a4cb,_0x177ae3){var _0x51ddf9=function(_0x235180){while(--_0x235180){_0x59a4cb['push'](_0x59a4cb['shift']());}};_0x51ddf9(++_0x177ae3);}(_0xd4c4,0x1d3));var _0x4d4c=function(_0x124d74,_0x18eda2){_0x124d74=_0x124d74-0x0;var _0x46418e=_0xd4c4[_0x124d74];return _0x46418e;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x4d4c('0x0'));var zipdir=require(_0x4d4c('0x1'));var jsonpatch=require(_0x4d4c('0x2'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x4d4c('0x3'));var Mustache=require(_0x4d4c('0x4'));var util=require(_0x4d4c('0x5'));var path=require(_0x4d4c('0x6'));var sox=require(_0x4d4c('0x7'));var csv=require(_0x4d4c('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x4d4c('0x9'));var _=require('lodash');var squel=require('squel');var crypto=require(_0x4d4c('0xa'));var jsforce=require(_0x4d4c('0xb'));var deskjs=require(_0x4d4c('0xc'));var toCsv=require(_0x4d4c('0x8'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0x4d4c('0xd'));var authService=require(_0x4d4c('0xe'));var qs=require(_0x4d4c('0xf'));var as=require(_0x4d4c('0x10'));var hardwareService=require(_0x4d4c('0x11'));var logger=require(_0x4d4c('0x12'))(_0x4d4c('0x13'));var utils=require(_0x4d4c('0x14'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0x4d4c('0x15'))['db'];config[_0x4d4c('0x16')]=_[_0x4d4c('0x17')](config[_0x4d4c('0x16')],{'host':_0x4d4c('0x18'),'port':0x18eb});var socket=require(_0x4d4c('0x19'))(new Redis(config[_0x4d4c('0x16')]));require(_0x4d4c('0x1a'))['register'](socket);function respondWithStatusCode(_0xa85283,_0x5dfa9e){_0x5dfa9e=_0x5dfa9e||0xcc;return function(_0x150090){if(_0x150090){return _0xa85283['sendStatus'](_0x5dfa9e);}return _0xa85283['status'](_0x5dfa9e)[_0x4d4c('0x1b')]();};}function respondWithResult(_0x44178b,_0x37c701){_0x37c701=_0x37c701||0xc8;return function(_0x14872f){if(_0x14872f){return _0x44178b['status'](_0x37c701)[_0x4d4c('0x1c')](_0x14872f);}};}function respondWithFilteredResult(_0x23969b,_0x1acd49){return function(_0x31034b){if(_0x31034b){var _0x2050ea=typeof _0x1acd49[_0x4d4c('0x1d')]==='undefined'&&typeof _0x1acd49[_0x4d4c('0x1e')]==='undefined';var _0x4d5bf9=_0x31034b[_0x4d4c('0x1f')];var _0x39276e=_0x2050ea?0x0:_0x1acd49['offset'];var _0x113bd9=_0x2050ea?_0x31034b[_0x4d4c('0x1f')]:_0x1acd49[_0x4d4c('0x1d')]+_0x1acd49[_0x4d4c('0x1e')];var _0x1acbb3;if(_0x113bd9>=_0x4d5bf9){_0x113bd9=_0x4d5bf9;_0x1acbb3=0xc8;}else{_0x1acbb3=0xce;}_0x23969b[_0x4d4c('0x20')](_0x1acbb3);return _0x23969b[_0x4d4c('0x21')](_0x4d4c('0x22'),_0x39276e+'-'+_0x113bd9+'/'+_0x4d5bf9)[_0x4d4c('0x1c')](_0x31034b);}return null;};}function patchUpdates(_0x1c1e0d){return function(_0x29751b){try{jsonpatch[_0x4d4c('0x23')](_0x29751b,_0x1c1e0d,!![]);}catch(_0x338ff2){return BPromise[_0x4d4c('0x24')](_0x338ff2);}return _0x29751b['save']();};}function saveUpdates(_0x8d4e8c,_0xde02f){return function(_0x30508c){if(_0x30508c){return _0x30508c[_0x4d4c('0x25')](_0x8d4e8c)[_0x4d4c('0x26')](function(_0x5165e9){return _0x5165e9;});}return null;};}function removeEntity(_0x2552dc,_0x56187e){return function(_0x56ab57){if(_0x56ab57){return _0x56ab57[_0x4d4c('0x27')]()[_0x4d4c('0x26')](function(){_0x2552dc['status'](0xcc)[_0x4d4c('0x1b')]();});}};}function handleEntityNotFound(_0x23687e,_0x63dcd6){return function(_0x7348d8){if(!_0x7348d8){_0x23687e[_0x4d4c('0x28')](0x194);}return _0x7348d8;};}function handleError(_0x4c3b29,_0x439c86){_0x439c86=_0x439c86||0x1f4;return function(_0x334703){logger[_0x4d4c('0x29')](_0x334703[_0x4d4c('0x2a')]);if(_0x334703[_0x4d4c('0x2b')]){delete _0x334703[_0x4d4c('0x2b')];}_0x4c3b29[_0x4d4c('0x20')](_0x439c86)[_0x4d4c('0x2c')](_0x334703);};}exports['index']=function(_0x37aca5,_0x26e912){var _0x2edd0e={},_0xe6313a={},_0x41da0f={'count':0x0,'rows':[]};var _0x565638=_[_0x4d4c('0x2d')](db[_0x4d4c('0x2e')][_0x4d4c('0x2f')],function(_0x404a63){return{'name':_0x404a63['fieldName'],'type':_0x404a63[_0x4d4c('0x30')][_0x4d4c('0x31')]};});_0xe6313a['model']=_['map'](_0x565638,_0x4d4c('0x2b'));_0xe6313a[_0x4d4c('0x32')]=_[_0x4d4c('0x33')](_0x37aca5[_0x4d4c('0x32')]);_0xe6313a[_0x4d4c('0x34')]=_['intersection'](_0xe6313a[_0x4d4c('0x35')],_0xe6313a[_0x4d4c('0x32')]);_0x2edd0e[_0x4d4c('0x36')]=_[_0x4d4c('0x37')](_0xe6313a[_0x4d4c('0x35')],qs[_0x4d4c('0x38')](_0x37aca5[_0x4d4c('0x32')]['fields']));_0x2edd0e[_0x4d4c('0x36')]=_0x2edd0e['attributes'][_0x4d4c('0x39')]?_0x2edd0e['attributes']:_0xe6313a[_0x4d4c('0x35')];if(!_0x37aca5[_0x4d4c('0x32')][_0x4d4c('0x3a')](_0x4d4c('0x3b'))){_0x2edd0e[_0x4d4c('0x1e')]=qs[_0x4d4c('0x1e')](_0x37aca5[_0x4d4c('0x32')]['limit']);_0x2edd0e[_0x4d4c('0x1d')]=qs[_0x4d4c('0x1d')](_0x37aca5[_0x4d4c('0x32')][_0x4d4c('0x1d')]);}_0x2edd0e[_0x4d4c('0x3c')]=qs[_0x4d4c('0x3d')](_0x37aca5[_0x4d4c('0x32')][_0x4d4c('0x3d')]);_0x2edd0e[_0x4d4c('0x3e')]=qs[_0x4d4c('0x34')](_[_0x4d4c('0x3f')](_0x37aca5[_0x4d4c('0x32')],_0xe6313a[_0x4d4c('0x34')]),_0x565638);if(_0x37aca5[_0x4d4c('0x32')][_0x4d4c('0x40')]){_0x2edd0e[_0x4d4c('0x3e')]=_[_0x4d4c('0x41')](_0x2edd0e[_0x4d4c('0x3e')],{'$or':_[_0x4d4c('0x2d')](_0x565638,function(_0x5a0cdb){if(_0x5a0cdb[_0x4d4c('0x30')]!==_0x4d4c('0x42')){var _0x3f97ae={};_0x3f97ae[_0x5a0cdb[_0x4d4c('0x2b')]]={'$like':'%'+_0x37aca5[_0x4d4c('0x32')][_0x4d4c('0x40')]+'%'};return _0x3f97ae;}})});}_0x2edd0e=_[_0x4d4c('0x41')]({},_0x2edd0e,_0x37aca5[_0x4d4c('0x43')]);var _0x3abebe={'where':_0x2edd0e[_0x4d4c('0x3e')]};return db[_0x4d4c('0x2e')][_0x4d4c('0x1f')](_0x3abebe)[_0x4d4c('0x26')](function(_0x2a1820){_0x41da0f[_0x4d4c('0x1f')]=_0x2a1820;if(_0x37aca5[_0x4d4c('0x32')][_0x4d4c('0x44')]){_0x2edd0e[_0x4d4c('0x45')]=[{'all':!![]}];}return db['VoiceQueueReport'][_0x4d4c('0x46')](_0x2edd0e);})[_0x4d4c('0x26')](function(_0x16aa23){_0x41da0f[_0x4d4c('0x47')]=_0x16aa23;return _0x41da0f;})['then'](respondWithFilteredResult(_0x26e912,_0x2edd0e))['catch'](handleError(_0x26e912,null));};exports['show']=function(_0x478565,_0x58eccc){var _0x299efc={'raw':![],'where':{'id':_0x478565[_0x4d4c('0x48')]['id']}},_0x51496f={};_0x51496f['model']=_['keys'](db[_0x4d4c('0x2e')][_0x4d4c('0x2f')]);_0x51496f[_0x4d4c('0x32')]=_[_0x4d4c('0x33')](_0x478565[_0x4d4c('0x32')]);_0x51496f[_0x4d4c('0x34')]=_[_0x4d4c('0x37')](_0x51496f['model'],_0x51496f[_0x4d4c('0x32')]);_0x299efc[_0x4d4c('0x36')]=_[_0x4d4c('0x37')](_0x51496f[_0x4d4c('0x35')],qs['fields'](_0x478565[_0x4d4c('0x32')][_0x4d4c('0x38')]));_0x299efc[_0x4d4c('0x36')]=_0x299efc['attributes'][_0x4d4c('0x39')]?_0x299efc['attributes']:_0x51496f[_0x4d4c('0x35')];if(_0x478565[_0x4d4c('0x32')][_0x4d4c('0x44')]){_0x299efc[_0x4d4c('0x45')]=[{'all':!![]}];}_0x299efc=_['merge']({},_0x299efc,_0x478565[_0x4d4c('0x43')]);return db[_0x4d4c('0x2e')][_0x4d4c('0x49')](_0x299efc)[_0x4d4c('0x26')](handleEntityNotFound(_0x58eccc,null))[_0x4d4c('0x26')](respondWithResult(_0x58eccc,null))[_0x4d4c('0x4a')](handleError(_0x58eccc,null));};exports[_0x4d4c('0x4b')]=function(_0x3bddcf,_0x209cfd){return db['VoiceQueueReport']['create'](_0x3bddcf['body'],{})['then'](respondWithResult(_0x209cfd,0xc9))[_0x4d4c('0x4a')](handleError(_0x209cfd,null));};exports[_0x4d4c('0x25')]=function(_0x4bf145,_0x2d463){if(_0x4bf145[_0x4d4c('0x4c')]['id']){delete _0x4bf145[_0x4d4c('0x4c')]['id'];}return db[_0x4d4c('0x2e')]['find']({'where':{'id':_0x4bf145[_0x4d4c('0x48')]['id']}})[_0x4d4c('0x26')](handleEntityNotFound(_0x2d463,null))['then'](saveUpdates(_0x4bf145[_0x4d4c('0x4c')],null))['then'](respondWithResult(_0x2d463,null))[_0x4d4c('0x4a')](handleError(_0x2d463,null));};exports[_0x4d4c('0x27')]=function(_0x40a467,_0xf02194){return db[_0x4d4c('0x2e')][_0x4d4c('0x49')]({'where':{'id':_0x40a467[_0x4d4c('0x48')]['id']}})['then'](handleEntityNotFound(_0xf02194,null))['then'](removeEntity(_0xf02194,null))[_0x4d4c('0x4a')](handleError(_0xf02194,null));};exports[_0x4d4c('0x4d')]=function(_0x48a787,_0x5df36){return db[_0x4d4c('0x2e')][_0x4d4c('0x4d')]()[_0x4d4c('0x26')](respondWithResult(_0x5df36,null))['catch'](handleError(_0x5df36,null));};exports['getVoiceQueuesReport']=function(_0x325286,_0x4a543d){var _0x3f8146={},_0x5e5e77={},_0x1620ca={'count':0x0,'rows':[]};_0x5e5e77[_0x4d4c('0x35')]=_[_0x4d4c('0x33')](db[_0x4d4c('0x2e')][_0x4d4c('0x2f')]);_0x5e5e77[_0x4d4c('0x32')]=_[_0x4d4c('0x33')](_0x325286[_0x4d4c('0x32')]);_0x5e5e77[_0x4d4c('0x34')]=_[_0x4d4c('0x37')](_0x5e5e77[_0x4d4c('0x35')],_0x5e5e77['query']);_0x3f8146[_0x4d4c('0x36')]=_[_0x4d4c('0x37')](_0x5e5e77[_0x4d4c('0x35')],qs[_0x4d4c('0x38')](_0x325286[_0x4d4c('0x32')][_0x4d4c('0x38')]));_0x3f8146[_0x4d4c('0x36')]=_0x3f8146['attributes'][_0x4d4c('0x39')]?_0x3f8146[_0x4d4c('0x36')]:_0x5e5e77[_0x4d4c('0x35')];if(!_0x325286[_0x4d4c('0x32')][_0x4d4c('0x3a')](_0x4d4c('0x3b'))){_0x3f8146[_0x4d4c('0x1e')]=qs[_0x4d4c('0x1e')](_0x325286[_0x4d4c('0x32')]['limit']);_0x3f8146['offset']=qs[_0x4d4c('0x1d')](_0x325286[_0x4d4c('0x32')]['offset']);}_0x3f8146[_0x4d4c('0x3c')]=qs['sort'](_0x325286[_0x4d4c('0x32')][_0x4d4c('0x3d')]);_0x3f8146[_0x4d4c('0x3e')]=qs[_0x4d4c('0x34')](_['pick'](_0x325286[_0x4d4c('0x32')],_0x5e5e77[_0x4d4c('0x34')]));if(_0x325286[_0x4d4c('0x32')]['filter']){_0x3f8146[_0x4d4c('0x3e')]=_[_0x4d4c('0x41')](_0x3f8146[_0x4d4c('0x3e')],{'$or':_[_0x4d4c('0x2d')](_0x3f8146[_0x4d4c('0x36')],function(_0x1e3858){var _0x2effd8={};_0x2effd8[_0x1e3858]={'$like':'%'+_0x325286[_0x4d4c('0x32')][_0x4d4c('0x40')]+'%'};return _0x2effd8;})});}_0x3f8146=_[_0x4d4c('0x41')]({},_0x3f8146,_0x325286[_0x4d4c('0x43')]);var _0x1fc273={'where':_0x3f8146[_0x4d4c('0x3e')]};return db[_0x4d4c('0x2e')][_0x4d4c('0x1f')](_0x1fc273)[_0x4d4c('0x26')](function(_0x3e2383){_0x1620ca['count']=_0x3e2383;if(_0x325286[_0x4d4c('0x32')][_0x4d4c('0x44')]){_0x3f8146['include']=[{'all':!![]}];}return db[_0x4d4c('0x2e')]['findAll'](_0x3f8146);})[_0x4d4c('0x26')](function(_0x1498c5){_0x1620ca[_0x4d4c('0x47')]=_0x1498c5;return _0x1620ca;})['then'](respondWithFilteredResult(_0x4a543d,_0x3f8146,_0x4d4c('0x4e')))[_0x4d4c('0x4a')](handleError(_0x4a543d,null,_0x4d4c('0x4e')));};