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 _0x32b1=['fields','length','hasOwnProperty','nolimit','order','pick','where','map','type','key','VIRTUAL','field','filter','then','includeAll','include','findAll','rows','catch','show','params','merge','options','find','create','body','describe','getVoiceQueuesReport','html-pdf','eml-format','zip-dir','request-promise','moment','bluebird','util','sox','to-csv','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','redis','defaults','localhost','socket.io-emitter','register','sendStatus','status','end','json','count','offset','limit','set','Content-Range','apply','reject','update','destroy','error','stack','name','send','index','VoiceQueueReport','rawAttributes','model','keys','query','filters','intersection','attributes'];(function(_0x57b54c,_0x54ce0d){var _0x59cc19=function(_0xa33bc6){while(--_0xa33bc6){_0x57b54c['push'](_0x57b54c['shift']());}};_0x59cc19(++_0x54ce0d);}(_0x32b1,0xbc));var _0x132b=function(_0x3de80e,_0x5cabca){_0x3de80e=_0x3de80e-0x0;var _0x5629fd=_0x32b1[_0x3de80e];return _0x5629fd;};'use strict';var pdf=require(_0x132b('0x0'));var emlformat=require(_0x132b('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x132b('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x132b('0x3'));var moment=require(_0x132b('0x4'));var BPromise=require(_0x132b('0x5'));var Mustache=require('mustache');var util=require(_0x132b('0x6'));var path=require('path');var sox=require(_0x132b('0x7'));var csv=require(_0x132b('0x8'));var ejs=require('ejs');var fs=require('fs');var _=require('lodash');var squel=require(_0x132b('0x9'));var crypto=require(_0x132b('0xa'));var jsforce=require(_0x132b('0xb'));var deskjs=require(_0x132b('0xc'));var toCsv=require('to-csv');var querystring=require(_0x132b('0xd'));var Papa=require(_0x132b('0xe'));var Redis=require(_0x132b('0xf'));var authService=require(_0x132b('0x10'));var qs=require('../../components/parsers/qs');var hardwareService=require(_0x132b('0x11'));var logger=require(_0x132b('0x12'))('api');var utils=require(_0x132b('0x13'));var config=require(_0x132b('0x14'));var db=require('../../mysqldb')['db'];config[_0x132b('0x15')]=_[_0x132b('0x16')](config[_0x132b('0x15')],{'host':_0x132b('0x17'),'port':0x18eb});var socket=require(_0x132b('0x18'))(new Redis(config[_0x132b('0x15')]));require('./voiceQueueReport.socket')[_0x132b('0x19')](socket);function respondWithStatusCode(_0x4b8dd9,_0x436a8c){_0x436a8c=_0x436a8c||0xcc;return function(_0x187c43){if(_0x187c43){return _0x4b8dd9[_0x132b('0x1a')](_0x436a8c);}return _0x4b8dd9[_0x132b('0x1b')](_0x436a8c)[_0x132b('0x1c')]();};}function respondWithResult(_0x9c5ddd,_0x44182f){_0x44182f=_0x44182f||0xc8;return function(_0x4f5d14){if(_0x4f5d14){return _0x9c5ddd[_0x132b('0x1b')](_0x44182f)[_0x132b('0x1d')](_0x4f5d14);}};}function respondWithFilteredResult(_0x4e8a44,_0xa933ef){return function(_0x51a653){if(_0x51a653){var _0x4e7ed7=_0x51a653[_0x132b('0x1e')],_0x17bb29=_0xa933ef[_0x132b('0x1f')],_0x474313=_0xa933ef[_0x132b('0x1f')]+_0xa933ef[_0x132b('0x20')],_0x6772e4;if(_0x474313>=_0x4e7ed7){_0x474313=_0x4e7ed7;_0x6772e4=0xc8;}else{_0x6772e4=0xce;}_0x4e8a44[_0x132b('0x1b')](_0x6772e4);return _0x4e8a44[_0x132b('0x21')](_0x132b('0x22'),_0x17bb29+'-'+_0x474313+'/'+_0x4e7ed7)[_0x132b('0x1d')](_0x51a653);}return null;};}function patchUpdates(_0x18e81a){return function(_0x33f184){try{jsonpatch[_0x132b('0x23')](_0x33f184,_0x18e81a,!![]);}catch(_0x16173b){return BPromise[_0x132b('0x24')](_0x16173b);}return _0x33f184['save']();};}function saveUpdates(_0x79b879,_0x33902a){return function(_0xf66ab9){if(_0xf66ab9){return _0xf66ab9[_0x132b('0x25')](_0x79b879)['then'](function(_0x82b7ef){return _0x82b7ef;});}return null;};}function removeEntity(_0x29238f,_0x290487){return function(_0x65766c){if(_0x65766c){return _0x65766c[_0x132b('0x26')]()['then'](function(){_0x29238f[_0x132b('0x1b')](0xcc)[_0x132b('0x1c')]();});}};}function handleEntityNotFound(_0x11a4d4,_0x57dd1f){return function(_0x5c32ef){if(!_0x5c32ef){_0x11a4d4[_0x132b('0x1a')](0x194);}return _0x5c32ef;};}function handleError(_0x556027,_0x4a870b){_0x4a870b=_0x4a870b||0x1f4;return function(_0x1431ae){logger[_0x132b('0x27')](_0x1431ae[_0x132b('0x28')]);if(_0x1431ae['name']){delete _0x1431ae[_0x132b('0x29')];}_0x556027[_0x132b('0x1b')](_0x4a870b)[_0x132b('0x2a')](_0x1431ae);};}exports[_0x132b('0x2b')]=function(_0x31f06d,_0x36bff8){var _0x19b243={},_0x51a976={},_0x6d4a56={'count':0x0,'rows':[]};var _0x3d3b29=db[_0x132b('0x2c')][_0x132b('0x2d')];_0x51a976[_0x132b('0x2e')]=_[_0x132b('0x2f')](_0x3d3b29);_0x51a976[_0x132b('0x30')]=_[_0x132b('0x2f')](_0x31f06d[_0x132b('0x30')]);_0x51a976[_0x132b('0x31')]=_[_0x132b('0x32')](_0x51a976[_0x132b('0x2e')],_0x51a976[_0x132b('0x30')]);_0x19b243[_0x132b('0x33')]=_[_0x132b('0x32')](_0x51a976[_0x132b('0x2e')],qs['fields'](_0x31f06d[_0x132b('0x30')][_0x132b('0x34')]));_0x19b243[_0x132b('0x33')]=_0x19b243['attributes'][_0x132b('0x35')]?_0x19b243['attributes']:_0x51a976[_0x132b('0x2e')];if(!_0x31f06d[_0x132b('0x30')][_0x132b('0x36')](_0x132b('0x37'))){_0x19b243[_0x132b('0x20')]=qs[_0x132b('0x20')](_0x31f06d[_0x132b('0x30')]['limit']);_0x19b243[_0x132b('0x1f')]=qs[_0x132b('0x1f')](_0x31f06d[_0x132b('0x30')]['offset']);}_0x19b243[_0x132b('0x38')]=qs['sort'](_0x31f06d[_0x132b('0x30')]['sort']);_0x19b243['where']=qs[_0x132b('0x31')](_[_0x132b('0x39')](_0x31f06d[_0x132b('0x30')],_0x51a976[_0x132b('0x31')]));if(_0x31f06d['query']['filter']){_0x19b243[_0x132b('0x3a')]=_['merge'](_0x19b243['where'],{'$or':_[_0x132b('0x3b')](_0x3d3b29,function(_0x28a915){if(_0x28a915[_0x132b('0x3c')][_0x132b('0x3d')]!==_0x132b('0x3e')){var _0x56f619={};_0x56f619[_0x28a915[_0x132b('0x3f')]]={'$like':'%'+_0x31f06d[_0x132b('0x30')][_0x132b('0x40')]+'%'};return _0x56f619;}})});}_0x19b243=_['merge']({},_0x19b243,_0x31f06d['options']);var _0x583566={'where':_0x19b243[_0x132b('0x3a')]};return db['VoiceQueueReport']['count'](_0x583566)[_0x132b('0x41')](function(_0x42560c){_0x6d4a56[_0x132b('0x1e')]=_0x42560c;if(_0x31f06d['query'][_0x132b('0x42')]){_0x19b243[_0x132b('0x43')]=[{'all':!![]}];}return db[_0x132b('0x2c')][_0x132b('0x44')](_0x19b243);})[_0x132b('0x41')](function(_0x20fbd7){_0x6d4a56[_0x132b('0x45')]=_0x20fbd7;return _0x6d4a56;})['then'](respondWithFilteredResult(_0x36bff8,_0x19b243))[_0x132b('0x46')](handleError(_0x36bff8,null));};exports[_0x132b('0x47')]=function(_0x2cb62b,_0x5a2d9b){var _0x22209a={'raw':![],'where':{'id':_0x2cb62b[_0x132b('0x48')]['id']}},_0x45a9f4={};_0x45a9f4['model']=_['keys'](db[_0x132b('0x2c')][_0x132b('0x2d')]);_0x45a9f4['query']=_[_0x132b('0x2f')](_0x2cb62b[_0x132b('0x30')]);_0x45a9f4[_0x132b('0x31')]=_['intersection'](_0x45a9f4['model'],_0x45a9f4[_0x132b('0x30')]);_0x22209a[_0x132b('0x33')]=_[_0x132b('0x32')](_0x45a9f4[_0x132b('0x2e')],qs[_0x132b('0x34')](_0x2cb62b['query']['fields']));_0x22209a[_0x132b('0x33')]=_0x22209a[_0x132b('0x33')][_0x132b('0x35')]?_0x22209a[_0x132b('0x33')]:_0x45a9f4[_0x132b('0x2e')];if(_0x2cb62b['query'][_0x132b('0x42')]){_0x22209a[_0x132b('0x43')]=[{'all':!![]}];}_0x22209a=_[_0x132b('0x49')]({},_0x22209a,_0x2cb62b[_0x132b('0x4a')]);return db[_0x132b('0x2c')][_0x132b('0x4b')](_0x22209a)[_0x132b('0x41')](handleEntityNotFound(_0x5a2d9b,null))[_0x132b('0x41')](respondWithResult(_0x5a2d9b,null))[_0x132b('0x46')](handleError(_0x5a2d9b,null));};exports['create']=function(_0x5eef1a,_0x4d04a6){return db[_0x132b('0x2c')][_0x132b('0x4c')](_0x5eef1a[_0x132b('0x4d')],{})[_0x132b('0x41')](respondWithResult(_0x4d04a6,0xc9))[_0x132b('0x46')](handleError(_0x4d04a6,null));};exports[_0x132b('0x25')]=function(_0x166480,_0x5de310){if(_0x166480['body']['id']){delete _0x166480[_0x132b('0x4d')]['id'];}return db[_0x132b('0x2c')][_0x132b('0x4b')]({'where':{'id':_0x166480[_0x132b('0x48')]['id']}})['then'](handleEntityNotFound(_0x5de310,null))[_0x132b('0x41')](saveUpdates(_0x166480[_0x132b('0x4d')],null))['then'](respondWithResult(_0x5de310,null))[_0x132b('0x46')](handleError(_0x5de310,null));};exports[_0x132b('0x26')]=function(_0x27b5ca,_0x5b1ba9){return db[_0x132b('0x2c')]['find']({'where':{'id':_0x27b5ca[_0x132b('0x48')]['id']}})[_0x132b('0x41')](handleEntityNotFound(_0x5b1ba9,null))['then'](removeEntity(_0x5b1ba9,null))['catch'](handleError(_0x5b1ba9,null));};exports['describe']=function(_0xe04830,_0x4462b5){return db[_0x132b('0x2c')][_0x132b('0x4e')]()[_0x132b('0x41')](respondWithResult(_0x4462b5,null))[_0x132b('0x46')](handleError(_0x4462b5,null));};exports[_0x132b('0x4f')]=function(_0x5ede0f,_0x2517d6){var _0x4584fc={},_0x2844c8={},_0x52fb17={'count':0x0,'rows':[]};_0x2844c8[_0x132b('0x2e')]=_[_0x132b('0x2f')](db['VoiceQueueReport']['rawAttributes']);_0x2844c8['query']=_[_0x132b('0x2f')](_0x5ede0f[_0x132b('0x30')]);_0x2844c8[_0x132b('0x31')]=_[_0x132b('0x32')](_0x2844c8['model'],_0x2844c8[_0x132b('0x30')]);_0x4584fc[_0x132b('0x33')]=_[_0x132b('0x32')](_0x2844c8[_0x132b('0x2e')],qs[_0x132b('0x34')](_0x5ede0f[_0x132b('0x30')][_0x132b('0x34')]));_0x4584fc[_0x132b('0x33')]=_0x4584fc[_0x132b('0x33')][_0x132b('0x35')]?_0x4584fc[_0x132b('0x33')]:_0x2844c8[_0x132b('0x2e')];if(!_0x5ede0f[_0x132b('0x30')][_0x132b('0x36')](_0x132b('0x37'))){_0x4584fc[_0x132b('0x20')]=qs[_0x132b('0x20')](_0x5ede0f[_0x132b('0x30')][_0x132b('0x20')]);_0x4584fc[_0x132b('0x1f')]=qs[_0x132b('0x1f')](_0x5ede0f['query'][_0x132b('0x1f')]);}_0x4584fc[_0x132b('0x38')]=qs['sort'](_0x5ede0f[_0x132b('0x30')]['sort']);_0x4584fc['where']=qs[_0x132b('0x31')](_[_0x132b('0x39')](_0x5ede0f['query'],_0x2844c8[_0x132b('0x31')]));if(_0x5ede0f[_0x132b('0x30')]['filter']){_0x4584fc['where']=_[_0x132b('0x49')](_0x4584fc[_0x132b('0x3a')],{'$or':_[_0x132b('0x3b')](_0x4584fc[_0x132b('0x33')],function(_0x19532b){var _0x3d0874={};_0x3d0874[_0x19532b]={'$like':'%'+_0x5ede0f[_0x132b('0x30')][_0x132b('0x40')]+'%'};return _0x3d0874;})});}_0x4584fc=_['merge']({},_0x4584fc,_0x5ede0f[_0x132b('0x4a')]);var _0x58eee0={'where':_0x4584fc[_0x132b('0x3a')]};return db[_0x132b('0x2c')][_0x132b('0x1e')](_0x58eee0)[_0x132b('0x41')](function(_0x499963){_0x52fb17[_0x132b('0x1e')]=_0x499963;if(_0x5ede0f[_0x132b('0x30')][_0x132b('0x42')]){_0x4584fc['include']=[{'all':!![]}];}return db[_0x132b('0x2c')]['findAll'](_0x4584fc);})[_0x132b('0x41')](function(_0x19f78c){_0x52fb17[_0x132b('0x45')]=_0x19f78c;return _0x52fb17;})[_0x132b('0x41')](respondWithFilteredResult(_0x2517d6,_0x4584fc,'getVoiceQueuesReport'))[_0x132b('0x46')](handleError(_0x2517d6,null,'getVoiceQueuesReport'));};