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 _0x1967=['../../config/environment','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./voiceQueueReport.socket','register','sendStatus','end','status','json','count','offset','reject','save','update','then','destroy','name','index','VoiceQueueReport','rawAttributes','fieldName','key','model','map','query','keys','filters','intersection','fields','attributes','length','hasOwnProperty','limit','order','sort','where','pick','filter','merge','VIRTUAL','includeAll','include','findAll','rows','catch','show','options','create','body','params','describe','getVoiceQueuesReport','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','lodash','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../config/license/hardware','../../config/logger','api','../../config/utils'];(function(_0x13b8f3,_0x442821){var _0x1a6d06=function(_0x5126f2){while(--_0x5126f2){_0x13b8f3['push'](_0x13b8f3['shift']());}};_0x1a6d06(++_0x442821);}(_0x1967,0x173));var _0x7196=function(_0x494616,_0x5b7908){_0x494616=_0x494616-0x0;var _0x3ef866=_0x1967[_0x494616];return _0x3ef866;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x7196('0x0'));var rimraf=require(_0x7196('0x1'));var zipdir=require(_0x7196('0x2'));var jsonpatch=require(_0x7196('0x3'));var rp=require(_0x7196('0x4'));var moment=require(_0x7196('0x5'));var BPromise=require(_0x7196('0x6'));var Mustache=require(_0x7196('0x7'));var util=require(_0x7196('0x8'));var path=require(_0x7196('0x9'));var sox=require('sox');var csv=require(_0x7196('0xa'));var ejs=require(_0x7196('0xb'));var fs=require('fs');var _=require(_0x7196('0xc'));var squel=require(_0x7196('0xd'));var crypto=require(_0x7196('0xe'));var jsforce=require(_0x7196('0xf'));var deskjs=require('desk.js');var toCsv=require(_0x7196('0xa'));var querystring=require(_0x7196('0x10'));var Papa=require(_0x7196('0x11'));var Redis=require(_0x7196('0x12'));var authService=require(_0x7196('0x13'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x7196('0x14'));var logger=require(_0x7196('0x15'))(_0x7196('0x16'));var utils=require(_0x7196('0x17'));var config=require(_0x7196('0x18'));var db=require(_0x7196('0x19'))['db'];config[_0x7196('0x1a')]=_[_0x7196('0x1b')](config[_0x7196('0x1a')],{'host':_0x7196('0x1c'),'port':0x18eb});var socket=require(_0x7196('0x1d'))(new Redis(config['redis']));require(_0x7196('0x1e'))[_0x7196('0x1f')](socket);function respondWithStatusCode(_0x3545aa,_0xf098c1){_0xf098c1=_0xf098c1||0xcc;return function(_0x511aa1){if(_0x511aa1){return _0x3545aa[_0x7196('0x20')](_0xf098c1);}return _0x3545aa['status'](_0xf098c1)[_0x7196('0x21')]();};}function respondWithResult(_0x2590a6,_0xf7e97){_0xf7e97=_0xf7e97||0xc8;return function(_0x3ed1ad){if(_0x3ed1ad){return _0x2590a6[_0x7196('0x22')](_0xf7e97)[_0x7196('0x23')](_0x3ed1ad);}};}function respondWithFilteredResult(_0x22bd62,_0x1ed296){return function(_0x3e4e69){if(_0x3e4e69){var _0x32fe2b=_0x3e4e69[_0x7196('0x24')],_0x385f2d=_0x1ed296[_0x7196('0x25')],_0x5b716a=_0x1ed296[_0x7196('0x25')]+_0x1ed296['limit'],_0x4c4f91;if(_0x5b716a>=_0x32fe2b){_0x5b716a=_0x32fe2b;_0x4c4f91=0xc8;}else{_0x4c4f91=0xce;}_0x22bd62[_0x7196('0x22')](_0x4c4f91);return _0x22bd62['set']('Content-Range',_0x385f2d+'-'+_0x5b716a+'/'+_0x32fe2b)[_0x7196('0x23')](_0x3e4e69);}return null;};}function patchUpdates(_0x627223){return function(_0x8dee9d){try{jsonpatch['apply'](_0x8dee9d,_0x627223,!![]);}catch(_0x57c390){return BPromise[_0x7196('0x26')](_0x57c390);}return _0x8dee9d[_0x7196('0x27')]();};}function saveUpdates(_0x598a26,_0x18649b){return function(_0x27ff84){if(_0x27ff84){return _0x27ff84[_0x7196('0x28')](_0x598a26)[_0x7196('0x29')](function(_0x38b3d6){return _0x38b3d6;});}return null;};}function removeEntity(_0x549f34,_0x3f8178){return function(_0x520d01){if(_0x520d01){return _0x520d01[_0x7196('0x2a')]()[_0x7196('0x29')](function(){_0x549f34[_0x7196('0x22')](0xcc)[_0x7196('0x21')]();});}};}function handleEntityNotFound(_0x70aa65,_0x43f6a2){return function(_0x530ab5){if(!_0x530ab5){_0x70aa65['sendStatus'](0x194);}return _0x530ab5;};}function handleError(_0x1482e5,_0x2d284f){_0x2d284f=_0x2d284f||0x1f4;return function(_0x184c09){logger['error'](_0x184c09['stack']);if(_0x184c09[_0x7196('0x2b')]){delete _0x184c09[_0x7196('0x2b')];}_0x1482e5[_0x7196('0x22')](_0x2d284f)['send'](_0x184c09);};}exports[_0x7196('0x2c')]=function(_0x4ecea1,_0x4fd339){var _0x59d79d={},_0x30151f={},_0x985727={'count':0x0,'rows':[]};var _0x1257ad=_['map'](db[_0x7196('0x2d')][_0x7196('0x2e')],function(_0x2f9583){return{'name':_0x2f9583[_0x7196('0x2f')],'type':_0x2f9583['type'][_0x7196('0x30')]};});_0x30151f[_0x7196('0x31')]=_[_0x7196('0x32')](_0x1257ad,_0x7196('0x2b'));_0x30151f[_0x7196('0x33')]=_[_0x7196('0x34')](_0x4ecea1[_0x7196('0x33')]);_0x30151f[_0x7196('0x35')]=_[_0x7196('0x36')](_0x30151f[_0x7196('0x31')],_0x30151f[_0x7196('0x33')]);_0x59d79d['attributes']=_[_0x7196('0x36')](_0x30151f['model'],qs[_0x7196('0x37')](_0x4ecea1['query'][_0x7196('0x37')]));_0x59d79d[_0x7196('0x38')]=_0x59d79d['attributes'][_0x7196('0x39')]?_0x59d79d[_0x7196('0x38')]:_0x30151f[_0x7196('0x31')];if(!_0x4ecea1[_0x7196('0x33')][_0x7196('0x3a')]('nolimit')){_0x59d79d[_0x7196('0x3b')]=qs[_0x7196('0x3b')](_0x4ecea1[_0x7196('0x33')][_0x7196('0x3b')]);_0x59d79d[_0x7196('0x25')]=qs[_0x7196('0x25')](_0x4ecea1['query'][_0x7196('0x25')]);}_0x59d79d[_0x7196('0x3c')]=qs[_0x7196('0x3d')](_0x4ecea1['query'][_0x7196('0x3d')]);_0x59d79d[_0x7196('0x3e')]=qs[_0x7196('0x35')](_[_0x7196('0x3f')](_0x4ecea1[_0x7196('0x33')],_0x30151f[_0x7196('0x35')]));if(_0x4ecea1[_0x7196('0x33')][_0x7196('0x40')]){_0x59d79d[_0x7196('0x3e')]=_[_0x7196('0x41')](_0x59d79d['where'],{'$or':_[_0x7196('0x32')](_0x1257ad,function(_0x17cefd){if(_0x17cefd['type']!==_0x7196('0x42')){var _0x54767f={};_0x54767f[_0x17cefd['name']]={'$like':'%'+_0x4ecea1[_0x7196('0x33')][_0x7196('0x40')]+'%'};return _0x54767f;}})});}_0x59d79d=_['merge']({},_0x59d79d,_0x4ecea1['options']);var _0x1bad95={'where':_0x59d79d[_0x7196('0x3e')]};return db[_0x7196('0x2d')]['count'](_0x1bad95)[_0x7196('0x29')](function(_0x2d13a5){_0x985727[_0x7196('0x24')]=_0x2d13a5;if(_0x4ecea1[_0x7196('0x33')][_0x7196('0x43')]){_0x59d79d[_0x7196('0x44')]=[{'all':!![]}];}return db[_0x7196('0x2d')][_0x7196('0x45')](_0x59d79d);})['then'](function(_0x89c8ea){_0x985727[_0x7196('0x46')]=_0x89c8ea;return _0x985727;})['then'](respondWithFilteredResult(_0x4fd339,_0x59d79d))[_0x7196('0x47')](handleError(_0x4fd339,null));};exports[_0x7196('0x48')]=function(_0x48178f,_0x471915){var _0x471bb2={'raw':![],'where':{'id':_0x48178f['params']['id']}},_0x3b78c8={};_0x3b78c8[_0x7196('0x31')]=_[_0x7196('0x34')](db['VoiceQueueReport'][_0x7196('0x2e')]);_0x3b78c8[_0x7196('0x33')]=_['keys'](_0x48178f[_0x7196('0x33')]);_0x3b78c8['filters']=_['intersection'](_0x3b78c8['model'],_0x3b78c8['query']);_0x471bb2['attributes']=_[_0x7196('0x36')](_0x3b78c8['model'],qs[_0x7196('0x37')](_0x48178f[_0x7196('0x33')][_0x7196('0x37')]));_0x471bb2[_0x7196('0x38')]=_0x471bb2['attributes'][_0x7196('0x39')]?_0x471bb2['attributes']:_0x3b78c8[_0x7196('0x31')];if(_0x48178f[_0x7196('0x33')][_0x7196('0x43')]){_0x471bb2['include']=[{'all':!![]}];}_0x471bb2=_[_0x7196('0x41')]({},_0x471bb2,_0x48178f[_0x7196('0x49')]);return db[_0x7196('0x2d')]['find'](_0x471bb2)['then'](handleEntityNotFound(_0x471915,null))[_0x7196('0x29')](respondWithResult(_0x471915,null))['catch'](handleError(_0x471915,null));};exports[_0x7196('0x4a')]=function(_0x582884,_0x53b4c7){return db[_0x7196('0x2d')]['create'](_0x582884['body'],{})['then'](respondWithResult(_0x53b4c7,0xc9))[_0x7196('0x47')](handleError(_0x53b4c7,null));};exports['update']=function(_0x48e3b5,_0x28591e){if(_0x48e3b5[_0x7196('0x4b')]['id']){delete _0x48e3b5[_0x7196('0x4b')]['id'];}return db[_0x7196('0x2d')]['find']({'where':{'id':_0x48e3b5[_0x7196('0x4c')]['id']}})['then'](handleEntityNotFound(_0x28591e,null))[_0x7196('0x29')](saveUpdates(_0x48e3b5[_0x7196('0x4b')],null))['then'](respondWithResult(_0x28591e,null))[_0x7196('0x47')](handleError(_0x28591e,null));};exports[_0x7196('0x2a')]=function(_0x3fe092,_0x4fa18f){return db[_0x7196('0x2d')]['find']({'where':{'id':_0x3fe092[_0x7196('0x4c')]['id']}})[_0x7196('0x29')](handleEntityNotFound(_0x4fa18f,null))[_0x7196('0x29')](removeEntity(_0x4fa18f,null))[_0x7196('0x47')](handleError(_0x4fa18f,null));};exports[_0x7196('0x4d')]=function(_0x19733a,_0x7e0d3){return db[_0x7196('0x2d')]['describe']()['then'](respondWithResult(_0x7e0d3,null))[_0x7196('0x47')](handleError(_0x7e0d3,null));};exports[_0x7196('0x4e')]=function(_0x40f820,_0xe4b032){var _0x4ebcd7={},_0x76b189={},_0x6948a={'count':0x0,'rows':[]};_0x76b189[_0x7196('0x31')]=_[_0x7196('0x34')](db[_0x7196('0x2d')][_0x7196('0x2e')]);_0x76b189[_0x7196('0x33')]=_[_0x7196('0x34')](_0x40f820[_0x7196('0x33')]);_0x76b189[_0x7196('0x35')]=_[_0x7196('0x36')](_0x76b189['model'],_0x76b189[_0x7196('0x33')]);_0x4ebcd7[_0x7196('0x38')]=_[_0x7196('0x36')](_0x76b189['model'],qs[_0x7196('0x37')](_0x40f820['query'][_0x7196('0x37')]));_0x4ebcd7[_0x7196('0x38')]=_0x4ebcd7[_0x7196('0x38')][_0x7196('0x39')]?_0x4ebcd7[_0x7196('0x38')]:_0x76b189['model'];if(!_0x40f820[_0x7196('0x33')]['hasOwnProperty']('nolimit')){_0x4ebcd7['limit']=qs[_0x7196('0x3b')](_0x40f820[_0x7196('0x33')][_0x7196('0x3b')]);_0x4ebcd7[_0x7196('0x25')]=qs[_0x7196('0x25')](_0x40f820[_0x7196('0x33')][_0x7196('0x25')]);}_0x4ebcd7['order']=qs[_0x7196('0x3d')](_0x40f820[_0x7196('0x33')][_0x7196('0x3d')]);_0x4ebcd7[_0x7196('0x3e')]=qs[_0x7196('0x35')](_['pick'](_0x40f820['query'],_0x76b189[_0x7196('0x35')]));if(_0x40f820[_0x7196('0x33')][_0x7196('0x40')]){_0x4ebcd7[_0x7196('0x3e')]=_[_0x7196('0x41')](_0x4ebcd7[_0x7196('0x3e')],{'$or':_[_0x7196('0x32')](_0x4ebcd7[_0x7196('0x38')],function(_0x13e9d0){var _0x2caadd={};_0x2caadd[_0x13e9d0]={'$like':'%'+_0x40f820[_0x7196('0x33')]['filter']+'%'};return _0x2caadd;})});}_0x4ebcd7=_[_0x7196('0x41')]({},_0x4ebcd7,_0x40f820[_0x7196('0x49')]);var _0x27d5d7={'where':_0x4ebcd7[_0x7196('0x3e')]};return db['VoiceQueueReport'][_0x7196('0x24')](_0x27d5d7)[_0x7196('0x29')](function(_0x1f3acc){_0x6948a[_0x7196('0x24')]=_0x1f3acc;if(_0x40f820[_0x7196('0x33')][_0x7196('0x43')]){_0x4ebcd7[_0x7196('0x44')]=[{'all':!![]}];}return db['VoiceQueueReport'][_0x7196('0x45')](_0x4ebcd7);})[_0x7196('0x29')](function(_0x40df9b){_0x6948a[_0x7196('0x46')]=_0x40df9b;return _0x6948a;})['then'](respondWithFilteredResult(_0xe4b032,_0x4ebcd7,_0x7196('0x4e')))[_0x7196('0x47')](handleError(_0xe4b032,null,_0x7196('0x4e')));};