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 _0xba55=['socket.io-emitter','register','status','end','json','count','offset','limit','set','Content-Range','apply','save','then','sendStatus','stack','name','send','VoiceQueueReport','rawAttributes','model','keys','query','dateEnd','intersection','attributes','fields','hasOwnProperty','nolimit','order','where','filters','dateStart','add','day','merge','map','options','include','findAll','catch','params','length','includeAll','find','create','update','describe','getVoiceQueuesReport','sort','pick','filter','rows','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','path','to-csv','ejs','squel','desk.js','querystring','papaparse','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../mysqldb'];(function(_0x1ee8f4,_0x33e420){var _0x52b5e9=function(_0x20efe7){while(--_0x20efe7){_0x1ee8f4['push'](_0x1ee8f4['shift']());}};_0x52b5e9(++_0x33e420);}(_0xba55,0x1de));var _0x5ba5=function(_0x2dc155,_0x52376f){_0x2dc155=_0x2dc155-0x0;var _0x109b3f=_0xba55[_0x2dc155];return _0x109b3f;};'use strict';var pdf=require(_0x5ba5('0x0'));var emlformat=require(_0x5ba5('0x1'));var rimraf=require(_0x5ba5('0x2'));var zipdir=require(_0x5ba5('0x3'));var jsonpatch=require(_0x5ba5('0x4'));var rp=require(_0x5ba5('0x5'));var moment=require('moment');var BPromise=require(_0x5ba5('0x6'));var Mustache=require('mustache');var util=require('util');var path=require(_0x5ba5('0x7'));var sox=require('sox');var csv=require(_0x5ba5('0x8'));var ejs=require(_0x5ba5('0x9'));var fs=require('fs');var _=require('lodash');var squel=require(_0x5ba5('0xa'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x5ba5('0xb'));var toCsv=require('to-csv');var querystring=require(_0x5ba5('0xc'));var Papa=require(_0x5ba5('0xd'));var qs=require(_0x5ba5('0xe'));var logger=require(_0x5ba5('0xf'))(_0x5ba5('0x10'));var utils=require(_0x5ba5('0x11'));var config=require('../../config/environment');var db=require(_0x5ba5('0x12'))['db'];var socket=require(_0x5ba5('0x13'))({'host':'localhost','port':0x18eb});require('./voiceQueueReport.socket')[_0x5ba5('0x14')](socket);function respondWithStatusCode(_0x1e1f10,_0x13dd98){_0x13dd98=_0x13dd98||0xcc;return function(_0x3345b7){if(_0x3345b7){return _0x1e1f10['sendStatus'](_0x13dd98);}return _0x1e1f10[_0x5ba5('0x15')](_0x13dd98)[_0x5ba5('0x16')]();};}function respondWithResult(_0x4d9f2d,_0x20f4b8){_0x20f4b8=_0x20f4b8||0xc8;return function(_0x3b72c9){if(_0x3b72c9){return _0x4d9f2d['status'](_0x20f4b8)[_0x5ba5('0x17')](_0x3b72c9);}};}function respondWithFilteredResult(_0x328308,_0x50e610){return function(_0x348252){if(_0x348252){var _0x12fa8c=_0x348252[_0x5ba5('0x18')],_0x59bcf3=_0x50e610[_0x5ba5('0x19')],_0x4e6644=_0x50e610[_0x5ba5('0x19')]+_0x50e610[_0x5ba5('0x1a')],_0x47a450;if(_0x4e6644>=_0x12fa8c){_0x4e6644=_0x12fa8c;_0x47a450=0xc8;}else{_0x47a450=0xce;}_0x328308['status'](_0x47a450);return _0x328308[_0x5ba5('0x1b')](_0x5ba5('0x1c'),_0x59bcf3+'-'+_0x4e6644+'/'+_0x12fa8c)[_0x5ba5('0x17')](_0x348252);}return null;};}function patchUpdates(_0x3d577){return function(_0x2c3283){try{jsonpatch[_0x5ba5('0x1d')](_0x2c3283,_0x3d577,!![]);}catch(_0x424f1d){return BPromise['reject'](_0x424f1d);}return _0x2c3283[_0x5ba5('0x1e')]();};}function saveUpdates(_0x3cf8df,_0x4ec062){return function(_0xfe3d70){if(_0xfe3d70){return _0xfe3d70['update'](_0x3cf8df)[_0x5ba5('0x1f')](function(_0x48ccc7){return _0x48ccc7;});}return null;};}function removeEntity(_0x54e27d,_0x49a259){return function(_0x10413a){if(_0x10413a){return _0x10413a['destroy']()[_0x5ba5('0x1f')](function(){_0x54e27d[_0x5ba5('0x15')](0xcc)[_0x5ba5('0x16')]();});}};}function handleEntityNotFound(_0x37096f,_0x423a5f){return function(_0x469883){if(!_0x469883){_0x37096f[_0x5ba5('0x20')](0x194);}return _0x469883;};}function handleError(_0x13b7ef,_0xbd65b7){_0xbd65b7=_0xbd65b7||0x1f4;return function(_0x1e8aa8){logger['error'](_0x1e8aa8[_0x5ba5('0x21')]);if(_0x1e8aa8[_0x5ba5('0x22')]){delete _0x1e8aa8[_0x5ba5('0x22')];}_0x13b7ef['status'](_0xbd65b7)[_0x5ba5('0x23')](_0x1e8aa8);};}exports['index']=function(_0x233912,_0x41d776){var _0x208193={},_0x53c279={},_0x34fb45={'count':0x0,'rows':[]};var _0x228900=db[_0x5ba5('0x24')][_0x5ba5('0x25')];_0x53c279[_0x5ba5('0x26')]=_[_0x5ba5('0x27')](_0x228900);var _0x22fb9f={'dateStart':_0x233912[_0x5ba5('0x28')]['dateStart'],'dateEnd':_0x233912[_0x5ba5('0x28')][_0x5ba5('0x29')]};delete _0x233912[_0x5ba5('0x28')]['dateStart'];delete _0x233912[_0x5ba5('0x28')]['dateEnd'];_0x53c279[_0x5ba5('0x28')]=_[_0x5ba5('0x27')](_0x233912[_0x5ba5('0x28')]);_0x53c279['filters']=_[_0x5ba5('0x2a')](_0x53c279[_0x5ba5('0x26')],_0x53c279[_0x5ba5('0x28')]);_0x208193[_0x5ba5('0x2b')]=_[_0x5ba5('0x2a')](_0x53c279[_0x5ba5('0x26')],qs[_0x5ba5('0x2c')](_0x233912[_0x5ba5('0x28')][_0x5ba5('0x2c')]));_0x208193['attributes']=_0x208193['attributes']['length']?_0x208193[_0x5ba5('0x2b')]:_0x53c279['model'];if(!_0x233912[_0x5ba5('0x28')][_0x5ba5('0x2d')](_0x5ba5('0x2e'))){_0x208193[_0x5ba5('0x1a')]=qs[_0x5ba5('0x1a')](_0x233912[_0x5ba5('0x28')][_0x5ba5('0x1a')]);_0x208193[_0x5ba5('0x19')]=qs['offset'](_0x233912[_0x5ba5('0x28')][_0x5ba5('0x19')]);}_0x208193[_0x5ba5('0x2f')]=qs['sort'](_0x233912[_0x5ba5('0x28')]['sort']);_0x208193[_0x5ba5('0x30')]=qs[_0x5ba5('0x31')](_['pick'](_0x233912[_0x5ba5('0x28')],_0x53c279[_0x5ba5('0x31')]));if(_0x22fb9f[_0x5ba5('0x32')]){if(_0x22fb9f[_0x5ba5('0x29')]){_0x22fb9f[_0x5ba5('0x29')]=moment(_0x22fb9f[_0x5ba5('0x29')])[_0x5ba5('0x33')](0x1,_0x5ba5('0x34'));}else{_0x22fb9f[_0x5ba5('0x29')]=moment(_0x22fb9f['dateStart'])[_0x5ba5('0x33')](0x1,_0x5ba5('0x34'));}_['merge'](_0x208193[_0x5ba5('0x30')],{'createdAt':{'$gte':_0x22fb9f[_0x5ba5('0x32')],'$lte':_0x22fb9f[_0x5ba5('0x29')]}});}if(_0x233912['query']['filter']){_0x208193[_0x5ba5('0x30')]=_[_0x5ba5('0x35')](_0x208193[_0x5ba5('0x30')],{'$or':_[_0x5ba5('0x36')](_0x208193[_0x5ba5('0x2b')],function(_0x253453){var _0x482720={};_0x482720[_0x253453]={'$like':'%'+_0x233912[_0x5ba5('0x28')]['filter']+'%'};return _0x482720;})});}_0x208193=_[_0x5ba5('0x35')]({},_0x208193,_0x233912[_0x5ba5('0x37')]);var _0x426cee={'where':_0x208193['where']};return db[_0x5ba5('0x24')][_0x5ba5('0x18')](_0x426cee)[_0x5ba5('0x1f')](function(_0x57a7f0){_0x34fb45[_0x5ba5('0x18')]=_0x57a7f0;if(_0x233912[_0x5ba5('0x28')]['includeAll']){_0x208193[_0x5ba5('0x38')]=[{'all':!![]}];}return db['VoiceQueueReport'][_0x5ba5('0x39')](_0x208193);})[_0x5ba5('0x1f')](function(_0x221c69){_0x34fb45['rows']=_0x221c69;return _0x34fb45;})[_0x5ba5('0x1f')](respondWithFilteredResult(_0x41d776,_0x208193))[_0x5ba5('0x3a')](handleError(_0x41d776,null));};exports['show']=function(_0x38d119,_0x41dcfe){var _0x411bb1={'raw':![],'where':{'id':_0x38d119[_0x5ba5('0x3b')]['id']}},_0x36adc7={};_0x36adc7[_0x5ba5('0x26')]=_['keys'](db['VoiceQueueReport']['rawAttributes']);_0x36adc7[_0x5ba5('0x28')]=_[_0x5ba5('0x27')](_0x38d119[_0x5ba5('0x28')]);_0x36adc7['filters']=_[_0x5ba5('0x2a')](_0x36adc7[_0x5ba5('0x26')],_0x36adc7['query']);_0x411bb1[_0x5ba5('0x2b')]=_['intersection'](_0x36adc7[_0x5ba5('0x26')],qs[_0x5ba5('0x2c')](_0x38d119[_0x5ba5('0x28')]['fields']));_0x411bb1['attributes']=_0x411bb1['attributes'][_0x5ba5('0x3c')]?_0x411bb1[_0x5ba5('0x2b')]:_0x36adc7[_0x5ba5('0x26')];if(_0x38d119[_0x5ba5('0x28')][_0x5ba5('0x3d')]){_0x411bb1[_0x5ba5('0x38')]=[{'all':!![]}];}_0x411bb1=_[_0x5ba5('0x35')]({},_0x411bb1,_0x38d119['options']);return db[_0x5ba5('0x24')][_0x5ba5('0x3e')](_0x411bb1)[_0x5ba5('0x1f')](handleEntityNotFound(_0x41dcfe,null))[_0x5ba5('0x1f')](respondWithResult(_0x41dcfe,null))[_0x5ba5('0x3a')](handleError(_0x41dcfe,null));};exports[_0x5ba5('0x3f')]=function(_0x76f055,_0x1ca0c5){return db[_0x5ba5('0x24')][_0x5ba5('0x3f')](_0x76f055['body'],{})[_0x5ba5('0x1f')](respondWithResult(_0x1ca0c5,0xc9))[_0x5ba5('0x3a')](handleError(_0x1ca0c5,null));};exports[_0x5ba5('0x40')]=function(_0x340c07,_0x540e04){if(_0x340c07['body']['id']){delete _0x340c07['body']['id'];}return db[_0x5ba5('0x24')]['find']({'where':{'id':_0x340c07[_0x5ba5('0x3b')]['id']}})['then'](handleEntityNotFound(_0x540e04,null))[_0x5ba5('0x1f')](saveUpdates(_0x340c07['body'],null))[_0x5ba5('0x1f')](respondWithResult(_0x540e04,null))[_0x5ba5('0x3a')](handleError(_0x540e04,null));};exports['destroy']=function(_0x4636d6,_0x58c717){return db[_0x5ba5('0x24')][_0x5ba5('0x3e')]({'where':{'id':_0x4636d6[_0x5ba5('0x3b')]['id']}})['then'](handleEntityNotFound(_0x58c717,null))[_0x5ba5('0x1f')](removeEntity(_0x58c717,null))[_0x5ba5('0x3a')](handleError(_0x58c717,null));};exports[_0x5ba5('0x41')]=function(_0x5cc81c,_0x13190d){return db[_0x5ba5('0x24')][_0x5ba5('0x41')]()[_0x5ba5('0x1f')](respondWithResult(_0x13190d,null))[_0x5ba5('0x3a')](handleError(_0x13190d,null));};exports[_0x5ba5('0x42')]=function(_0xacb901,_0x3649d5){var _0x1ec004={},_0x4b789b={},_0x3d9c4f={'count':0x0,'rows':[]};_0x4b789b[_0x5ba5('0x26')]=_[_0x5ba5('0x27')](db[_0x5ba5('0x24')]['rawAttributes']);var _0x7a6c94={'dateStart':_0xacb901[_0x5ba5('0x28')][_0x5ba5('0x32')],'dateEnd':_0xacb901[_0x5ba5('0x28')]['dateEnd']};delete _0xacb901[_0x5ba5('0x28')][_0x5ba5('0x32')];delete _0xacb901['query']['dateEnd'];_0x4b789b['query']=_[_0x5ba5('0x27')](_0xacb901[_0x5ba5('0x28')]);_0x4b789b[_0x5ba5('0x31')]=_[_0x5ba5('0x2a')](_0x4b789b[_0x5ba5('0x26')],_0x4b789b[_0x5ba5('0x28')]);_0x1ec004['attributes']=_[_0x5ba5('0x2a')](_0x4b789b[_0x5ba5('0x26')],qs[_0x5ba5('0x2c')](_0xacb901[_0x5ba5('0x28')][_0x5ba5('0x2c')]));_0x1ec004[_0x5ba5('0x2b')]=_0x1ec004[_0x5ba5('0x2b')][_0x5ba5('0x3c')]?_0x1ec004[_0x5ba5('0x2b')]:_0x4b789b[_0x5ba5('0x26')];if(!_0xacb901[_0x5ba5('0x28')][_0x5ba5('0x2d')]('nolimit')){_0x1ec004[_0x5ba5('0x1a')]=qs[_0x5ba5('0x1a')](_0xacb901[_0x5ba5('0x28')][_0x5ba5('0x1a')]);_0x1ec004[_0x5ba5('0x19')]=qs[_0x5ba5('0x19')](_0xacb901[_0x5ba5('0x28')]['offset']);}_0x1ec004['order']=qs[_0x5ba5('0x43')](_0xacb901[_0x5ba5('0x28')][_0x5ba5('0x43')]);_0x1ec004[_0x5ba5('0x30')]=qs[_0x5ba5('0x31')](_[_0x5ba5('0x44')](_0xacb901[_0x5ba5('0x28')],_0x4b789b[_0x5ba5('0x31')]));if(_0x7a6c94[_0x5ba5('0x32')]){if(_0x7a6c94[_0x5ba5('0x29')]){_0x7a6c94[_0x5ba5('0x29')]=moment(_0x7a6c94[_0x5ba5('0x29')])[_0x5ba5('0x33')](0x1,_0x5ba5('0x34'));}else{_0x7a6c94[_0x5ba5('0x29')]=moment(_0x7a6c94[_0x5ba5('0x32')])[_0x5ba5('0x33')](0x1,'day');}_[_0x5ba5('0x35')](_0x1ec004['where'],{'createdAt':{'$gte':_0x7a6c94[_0x5ba5('0x32')],'$lte':_0x7a6c94[_0x5ba5('0x29')]}});}if(_0xacb901[_0x5ba5('0x28')][_0x5ba5('0x45')]){_0x1ec004[_0x5ba5('0x30')]=_[_0x5ba5('0x35')](_0x1ec004[_0x5ba5('0x30')],{'$or':_[_0x5ba5('0x36')](_0x1ec004[_0x5ba5('0x2b')],function(_0x56265e){var _0x577cec={};_0x577cec[_0x56265e]={'$like':'%'+_0xacb901[_0x5ba5('0x28')]['filter']+'%'};return _0x577cec;})});}_0x1ec004=_['merge']({},_0x1ec004,_0xacb901[_0x5ba5('0x37')]);var _0x5dfd42={'where':_0x1ec004[_0x5ba5('0x30')]};return db[_0x5ba5('0x24')][_0x5ba5('0x18')](_0x5dfd42)[_0x5ba5('0x1f')](function(_0x13f723){_0x3d9c4f['count']=_0x13f723;if(_0xacb901['query'][_0x5ba5('0x3d')]){_0x1ec004[_0x5ba5('0x38')]=[{'all':!![]}];}return db['VoiceQueueReport'][_0x5ba5('0x39')](_0x1ec004);})[_0x5ba5('0x1f')](function(_0x1dbcff){_0x3d9c4f[_0x5ba5('0x46')]=_0x1dbcff;return _0x3d9c4f;})[_0x5ba5('0x1f')](respondWithFilteredResult(_0x3649d5,_0x1ec004,'getVoiceQueuesReport'))[_0x5ba5('0x3a')](handleError(_0x3649d5,null,_0x5ba5('0x42')));};