e65668e44f6c955dd0fbe39d2cfff6875b0741f1
[motion2.git] / 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 _0x3468=['stack','name','send','index','map','VoiceQueueReport','fieldName','type','query','keys','filters','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','limit','order','sort','where','filter','merge','VIRTUAL','options','includeAll','include','rows','catch','show','params','rawAttributes','find','create','body','describe','getVoiceQueuesReport','pick','findAll','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/license/util','../../mysqldb','redis','defaults','socket.io-emitter','./voiceQueueReport.socket','register','sendStatus','status','end','json','count','offset','set','apply','reject','save','then','destroy','error'];(function(_0x56dda5,_0x40d426){var _0x12574f=function(_0x27934c){while(--_0x27934c){_0x56dda5['push'](_0x56dda5['shift']());}};_0x12574f(++_0x40d426);}(_0x3468,0x184));var _0x8346=function(_0x27d8c2,_0x22fcb8){_0x27d8c2=_0x27d8c2-0x0;var _0x11de16=_0x3468[_0x27d8c2];return _0x11de16;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x8346('0x0'));var zipdir=require(_0x8346('0x1'));var jsonpatch=require(_0x8346('0x2'));var rp=require(_0x8346('0x3'));var moment=require(_0x8346('0x4'));var BPromise=require(_0x8346('0x5'));var Mustache=require(_0x8346('0x6'));var util=require(_0x8346('0x7'));var path=require(_0x8346('0x8'));var sox=require(_0x8346('0x9'));var csv=require('to-csv');var ejs=require(_0x8346('0xa'));var fs=require('fs');var fs_extra=require(_0x8346('0xb'));var _=require(_0x8346('0xc'));var squel=require(_0x8346('0xd'));var crypto=require(_0x8346('0xe'));var jsforce=require(_0x8346('0xf'));var deskjs=require(_0x8346('0x10'));var toCsv=require(_0x8346('0x11'));var querystring=require(_0x8346('0x12'));var Papa=require(_0x8346('0x13'));var Redis=require(_0x8346('0x14'));var authService=require(_0x8346('0x15'));var qs=require(_0x8346('0x16'));var as=require(_0x8346('0x17'));var hardwareService=require(_0x8346('0x18'));var logger=require('../../config/logger')(_0x8346('0x19'));var utils=require(_0x8346('0x1a'));var config=require('../../config/environment');var licenseUtil=require(_0x8346('0x1b'));var db=require(_0x8346('0x1c'))['db'];config[_0x8346('0x1d')]=_[_0x8346('0x1e')](config[_0x8346('0x1d')],{'host':'localhost','port':0x18eb});var socket=require(_0x8346('0x1f'))(new Redis(config[_0x8346('0x1d')]));require(_0x8346('0x20'))[_0x8346('0x21')](socket);function respondWithStatusCode(_0x3b930c,_0xcd8fd0){_0xcd8fd0=_0xcd8fd0||0xcc;return function(_0x2c6a33){if(_0x2c6a33){return _0x3b930c[_0x8346('0x22')](_0xcd8fd0);}return _0x3b930c[_0x8346('0x23')](_0xcd8fd0)[_0x8346('0x24')]();};}function respondWithResult(_0x30209c,_0x48b0d8){_0x48b0d8=_0x48b0d8||0xc8;return function(_0x36ab4b){if(_0x36ab4b){return _0x30209c[_0x8346('0x23')](_0x48b0d8)[_0x8346('0x25')](_0x36ab4b);}};}function respondWithFilteredResult(_0x16f722,_0x4429b9){return function(_0x29f17b){if(_0x29f17b){var _0x4c4e01=_0x29f17b[_0x8346('0x26')],_0x563671=_0x4429b9[_0x8346('0x27')],_0x5dec73=_0x4429b9[_0x8346('0x27')]+_0x4429b9['limit'],_0x5c342a;if(_0x5dec73>=_0x4c4e01){_0x5dec73=_0x4c4e01;_0x5c342a=0xc8;}else{_0x5c342a=0xce;}_0x16f722[_0x8346('0x23')](_0x5c342a);return _0x16f722[_0x8346('0x28')]('Content-Range',_0x563671+'-'+_0x5dec73+'/'+_0x4c4e01)[_0x8346('0x25')](_0x29f17b);}return null;};}function patchUpdates(_0x202af4){return function(_0x286c6f){try{jsonpatch[_0x8346('0x29')](_0x286c6f,_0x202af4,!![]);}catch(_0x307fec){return BPromise[_0x8346('0x2a')](_0x307fec);}return _0x286c6f[_0x8346('0x2b')]();};}function saveUpdates(_0x512cbb,_0x2b7161){return function(_0x5a86e9){if(_0x5a86e9){return _0x5a86e9['update'](_0x512cbb)[_0x8346('0x2c')](function(_0x20cbe7){return _0x20cbe7;});}return null;};}function removeEntity(_0x442646,_0x3e052b){return function(_0x25e523){if(_0x25e523){return _0x25e523[_0x8346('0x2d')]()[_0x8346('0x2c')](function(){_0x442646['status'](0xcc)[_0x8346('0x24')]();});}};}function handleEntityNotFound(_0x432204,_0x33e3a7){return function(_0x24b191){if(!_0x24b191){_0x432204[_0x8346('0x22')](0x194);}return _0x24b191;};}function handleError(_0x2f1620,_0x481b4d){_0x481b4d=_0x481b4d||0x1f4;return function(_0x46d9d1){logger[_0x8346('0x2e')](_0x46d9d1[_0x8346('0x2f')]);if(_0x46d9d1[_0x8346('0x30')]){delete _0x46d9d1[_0x8346('0x30')];}_0x2f1620[_0x8346('0x23')](_0x481b4d)[_0x8346('0x31')](_0x46d9d1);};}exports[_0x8346('0x32')]=function(_0x9b23f8,_0x331ed6){var _0x325bcb={},_0xb4e51b={},_0xf8d232={'count':0x0,'rows':[]};var _0x1c6042=_[_0x8346('0x33')](db[_0x8346('0x34')]['rawAttributes'],function(_0x636a52){return{'name':_0x636a52[_0x8346('0x35')],'type':_0x636a52[_0x8346('0x36')]['key']};});_0xb4e51b['model']=_[_0x8346('0x33')](_0x1c6042,'name');_0xb4e51b[_0x8346('0x37')]=_[_0x8346('0x38')](_0x9b23f8[_0x8346('0x37')]);_0xb4e51b[_0x8346('0x39')]=_[_0x8346('0x3a')](_0xb4e51b[_0x8346('0x3b')],_0xb4e51b['query']);_0x325bcb[_0x8346('0x3c')]=_[_0x8346('0x3a')](_0xb4e51b[_0x8346('0x3b')],qs[_0x8346('0x3d')](_0x9b23f8[_0x8346('0x37')][_0x8346('0x3d')]));_0x325bcb[_0x8346('0x3c')]=_0x325bcb[_0x8346('0x3c')][_0x8346('0x3e')]?_0x325bcb[_0x8346('0x3c')]:_0xb4e51b['model'];if(!_0x9b23f8[_0x8346('0x37')][_0x8346('0x3f')](_0x8346('0x40'))){_0x325bcb[_0x8346('0x41')]=qs[_0x8346('0x41')](_0x9b23f8[_0x8346('0x37')][_0x8346('0x41')]);_0x325bcb[_0x8346('0x27')]=qs[_0x8346('0x27')](_0x9b23f8[_0x8346('0x37')][_0x8346('0x27')]);}_0x325bcb[_0x8346('0x42')]=qs[_0x8346('0x43')](_0x9b23f8['query'][_0x8346('0x43')]);_0x325bcb[_0x8346('0x44')]=qs[_0x8346('0x39')](_['pick'](_0x9b23f8[_0x8346('0x37')],_0xb4e51b[_0x8346('0x39')]),_0x1c6042);if(_0x9b23f8[_0x8346('0x37')][_0x8346('0x45')]){_0x325bcb[_0x8346('0x44')]=_[_0x8346('0x46')](_0x325bcb[_0x8346('0x44')],{'$or':_[_0x8346('0x33')](_0x1c6042,function(_0x7e00c2){if(_0x7e00c2['type']!==_0x8346('0x47')){var _0x4634fe={};_0x4634fe[_0x7e00c2[_0x8346('0x30')]]={'$like':'%'+_0x9b23f8[_0x8346('0x37')][_0x8346('0x45')]+'%'};return _0x4634fe;}})});}_0x325bcb=_['merge']({},_0x325bcb,_0x9b23f8[_0x8346('0x48')]);var _0x44b40b={'where':_0x325bcb[_0x8346('0x44')]};return db['VoiceQueueReport']['count'](_0x44b40b)['then'](function(_0x31f9ff){_0xf8d232['count']=_0x31f9ff;if(_0x9b23f8[_0x8346('0x37')][_0x8346('0x49')]){_0x325bcb[_0x8346('0x4a')]=[{'all':!![]}];}return db[_0x8346('0x34')]['findAll'](_0x325bcb);})[_0x8346('0x2c')](function(_0x951172){_0xf8d232[_0x8346('0x4b')]=_0x951172;return _0xf8d232;})[_0x8346('0x2c')](respondWithFilteredResult(_0x331ed6,_0x325bcb))[_0x8346('0x4c')](handleError(_0x331ed6,null));};exports[_0x8346('0x4d')]=function(_0x188999,_0x2205d7){var _0x56178e={'raw':![],'where':{'id':_0x188999[_0x8346('0x4e')]['id']}},_0x363672={};_0x363672[_0x8346('0x3b')]=_[_0x8346('0x38')](db[_0x8346('0x34')][_0x8346('0x4f')]);_0x363672[_0x8346('0x37')]=_[_0x8346('0x38')](_0x188999[_0x8346('0x37')]);_0x363672[_0x8346('0x39')]=_['intersection'](_0x363672[_0x8346('0x3b')],_0x363672['query']);_0x56178e[_0x8346('0x3c')]=_[_0x8346('0x3a')](_0x363672['model'],qs[_0x8346('0x3d')](_0x188999[_0x8346('0x37')]['fields']));_0x56178e['attributes']=_0x56178e[_0x8346('0x3c')][_0x8346('0x3e')]?_0x56178e[_0x8346('0x3c')]:_0x363672[_0x8346('0x3b')];if(_0x188999['query'][_0x8346('0x49')]){_0x56178e[_0x8346('0x4a')]=[{'all':!![]}];}_0x56178e=_[_0x8346('0x46')]({},_0x56178e,_0x188999['options']);return db[_0x8346('0x34')][_0x8346('0x50')](_0x56178e)[_0x8346('0x2c')](handleEntityNotFound(_0x2205d7,null))[_0x8346('0x2c')](respondWithResult(_0x2205d7,null))['catch'](handleError(_0x2205d7,null));};exports['create']=function(_0x32f2a0,_0x1e4650){return db[_0x8346('0x34')][_0x8346('0x51')](_0x32f2a0[_0x8346('0x52')],{})[_0x8346('0x2c')](respondWithResult(_0x1e4650,0xc9))[_0x8346('0x4c')](handleError(_0x1e4650,null));};exports['update']=function(_0x81633e,_0x36937e){if(_0x81633e[_0x8346('0x52')]['id']){delete _0x81633e[_0x8346('0x52')]['id'];}return db[_0x8346('0x34')][_0x8346('0x50')]({'where':{'id':_0x81633e['params']['id']}})[_0x8346('0x2c')](handleEntityNotFound(_0x36937e,null))['then'](saveUpdates(_0x81633e[_0x8346('0x52')],null))[_0x8346('0x2c')](respondWithResult(_0x36937e,null))[_0x8346('0x4c')](handleError(_0x36937e,null));};exports[_0x8346('0x2d')]=function(_0x53ad17,_0xe9b9f6){return db[_0x8346('0x34')][_0x8346('0x50')]({'where':{'id':_0x53ad17['params']['id']}})[_0x8346('0x2c')](handleEntityNotFound(_0xe9b9f6,null))[_0x8346('0x2c')](removeEntity(_0xe9b9f6,null))[_0x8346('0x4c')](handleError(_0xe9b9f6,null));};exports[_0x8346('0x53')]=function(_0x56e8aa,_0x2cf728){return db[_0x8346('0x34')][_0x8346('0x53')]()['then'](respondWithResult(_0x2cf728,null))[_0x8346('0x4c')](handleError(_0x2cf728,null));};exports[_0x8346('0x54')]=function(_0x2c674d,_0xa3ccde){var _0x423ef9={},_0x586abf={},_0x82f64c={'count':0x0,'rows':[]};_0x586abf[_0x8346('0x3b')]=_[_0x8346('0x38')](db[_0x8346('0x34')][_0x8346('0x4f')]);_0x586abf[_0x8346('0x37')]=_[_0x8346('0x38')](_0x2c674d[_0x8346('0x37')]);_0x586abf[_0x8346('0x39')]=_[_0x8346('0x3a')](_0x586abf[_0x8346('0x3b')],_0x586abf['query']);_0x423ef9[_0x8346('0x3c')]=_['intersection'](_0x586abf['model'],qs[_0x8346('0x3d')](_0x2c674d[_0x8346('0x37')][_0x8346('0x3d')]));_0x423ef9['attributes']=_0x423ef9[_0x8346('0x3c')][_0x8346('0x3e')]?_0x423ef9[_0x8346('0x3c')]:_0x586abf[_0x8346('0x3b')];if(!_0x2c674d[_0x8346('0x37')]['hasOwnProperty'](_0x8346('0x40'))){_0x423ef9['limit']=qs[_0x8346('0x41')](_0x2c674d[_0x8346('0x37')][_0x8346('0x41')]);_0x423ef9[_0x8346('0x27')]=qs[_0x8346('0x27')](_0x2c674d[_0x8346('0x37')][_0x8346('0x27')]);}_0x423ef9[_0x8346('0x42')]=qs[_0x8346('0x43')](_0x2c674d[_0x8346('0x37')][_0x8346('0x43')]);_0x423ef9[_0x8346('0x44')]=qs[_0x8346('0x39')](_[_0x8346('0x55')](_0x2c674d[_0x8346('0x37')],_0x586abf[_0x8346('0x39')]));if(_0x2c674d['query'][_0x8346('0x45')]){_0x423ef9[_0x8346('0x44')]=_['merge'](_0x423ef9['where'],{'$or':_[_0x8346('0x33')](_0x423ef9[_0x8346('0x3c')],function(_0xc7c2e7){var _0x25ec7a={};_0x25ec7a[_0xc7c2e7]={'$like':'%'+_0x2c674d[_0x8346('0x37')][_0x8346('0x45')]+'%'};return _0x25ec7a;})});}_0x423ef9=_[_0x8346('0x46')]({},_0x423ef9,_0x2c674d[_0x8346('0x48')]);var _0x2cf473={'where':_0x423ef9[_0x8346('0x44')]};return db['VoiceQueueReport']['count'](_0x2cf473)[_0x8346('0x2c')](function(_0x107143){_0x82f64c['count']=_0x107143;if(_0x2c674d[_0x8346('0x37')]['includeAll']){_0x423ef9[_0x8346('0x4a')]=[{'all':!![]}];}return db['VoiceQueueReport'][_0x8346('0x56')](_0x423ef9);})['then'](function(_0x334edc){_0x82f64c['rows']=_0x334edc;return _0x82f64c;})[_0x8346('0x2c')](respondWithFilteredResult(_0xa3ccde,_0x423ef9,_0x8346('0x54')))[_0x8346('0x4c')](handleError(_0xa3ccde,null,_0x8346('0x54')));};