Built motion from commit b5413ace.|2.6.9
[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 _0x1e3b=['reject','save','then','destroy','sendStatus','error','stack','index','map','VoiceQueueReport','fieldName','type','key','name','query','intersection','attributes','fields','model','nolimit','order','sort','filters','filter','merge','where','VIRTUAL','options','includeAll','include','findAll','rows','catch','params','rawAttributes','keys','length','create','body','update','find','describe','getVoiceQueuesReport','hasOwnProperty','pick','eml-format','rimraf','fast-json-patch','request-promise','mustache','path','sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/environment','../../config/license/util','redis','localhost','socket.io-emitter','register','status','end','json','undefined','limit','count','offset','set','Content-Range','apply'];(function(_0x4b73a2,_0x40b5fe){var _0x383c66=function(_0x3917ae){while(--_0x3917ae){_0x4b73a2['push'](_0x4b73a2['shift']());}};_0x383c66(++_0x40b5fe);}(_0x1e3b,0x7f));var _0xb1e3=function(_0x24d88c,_0x83be3c){_0x24d88c=_0x24d88c-0x0;var _0x3e082d=_0x1e3b[_0x24d88c];return _0x3e082d;};'use strict';var emlformat=require(_0xb1e3('0x0'));var rimraf=require(_0xb1e3('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xb1e3('0x2'));var rp=require(_0xb1e3('0x3'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0xb1e3('0x4'));var util=require('util');var path=require(_0xb1e3('0x5'));var sox=require(_0xb1e3('0x6'));var csv=require(_0xb1e3('0x7'));var ejs=require(_0xb1e3('0x8'));var fs=require('fs');var fs_extra=require(_0xb1e3('0x9'));var _=require('lodash');var squel=require(_0xb1e3('0xa'));var crypto=require(_0xb1e3('0xb'));var jsforce=require(_0xb1e3('0xc'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0xb1e3('0xd'));var Papa=require(_0xb1e3('0xe'));var Redis=require(_0xb1e3('0xf'));var authService=require(_0xb1e3('0x10'));var qs=require(_0xb1e3('0x11'));var as=require(_0xb1e3('0x12'));var hardwareService=require(_0xb1e3('0x13'));var logger=require('../../config/logger')(_0xb1e3('0x14'));var utils=require('../../config/utils');var config=require(_0xb1e3('0x15'));var licenseUtil=require(_0xb1e3('0x16'));var db=require('../../mysqldb')['db'];config[_0xb1e3('0x17')]=_['defaults'](config[_0xb1e3('0x17')],{'host':_0xb1e3('0x18'),'port':0x18eb});var socket=require(_0xb1e3('0x19'))(new Redis(config['redis']));require('./voiceQueueReport.socket')[_0xb1e3('0x1a')](socket);function respondWithStatusCode(_0x165a96,_0x4a7039){_0x4a7039=_0x4a7039||0xcc;return function(_0x40865e){if(_0x40865e){return _0x165a96['sendStatus'](_0x4a7039);}return _0x165a96[_0xb1e3('0x1b')](_0x4a7039)[_0xb1e3('0x1c')]();};}function respondWithResult(_0x3620a0,_0x36bb12){_0x36bb12=_0x36bb12||0xc8;return function(_0x2ba374){if(_0x2ba374){return _0x3620a0[_0xb1e3('0x1b')](_0x36bb12)[_0xb1e3('0x1d')](_0x2ba374);}};}function respondWithFilteredResult(_0xcd8318,_0x1c15ed){return function(_0x5c839b){if(_0x5c839b){var _0x49832f=typeof _0x1c15ed['offset']===_0xb1e3('0x1e')&&typeof _0x1c15ed[_0xb1e3('0x1f')]===_0xb1e3('0x1e');var _0xeacfbd=_0x5c839b[_0xb1e3('0x20')];var _0x45af9e=_0x49832f?0x0:_0x1c15ed[_0xb1e3('0x21')];var _0x56c012=_0x49832f?_0x5c839b[_0xb1e3('0x20')]:_0x1c15ed['offset']+_0x1c15ed['limit'];var _0x33c0c3;if(_0x56c012>=_0xeacfbd){_0x56c012=_0xeacfbd;_0x33c0c3=0xc8;}else{_0x33c0c3=0xce;}_0xcd8318[_0xb1e3('0x1b')](_0x33c0c3);return _0xcd8318[_0xb1e3('0x22')](_0xb1e3('0x23'),_0x45af9e+'-'+_0x56c012+'/'+_0xeacfbd)[_0xb1e3('0x1d')](_0x5c839b);}return null;};}function patchUpdates(_0x1f9e55){return function(_0x53399f){try{jsonpatch[_0xb1e3('0x24')](_0x53399f,_0x1f9e55,!![]);}catch(_0x417390){return BPromise[_0xb1e3('0x25')](_0x417390);}return _0x53399f[_0xb1e3('0x26')]();};}function saveUpdates(_0x45b942,_0x270495){return function(_0x8b8458){if(_0x8b8458){return _0x8b8458['update'](_0x45b942)[_0xb1e3('0x27')](function(_0x2aa7c5){return _0x2aa7c5;});}return null;};}function removeEntity(_0xec611b,_0x1166b3){return function(_0x1b5507){if(_0x1b5507){return _0x1b5507[_0xb1e3('0x28')]()['then'](function(){_0xec611b[_0xb1e3('0x1b')](0xcc)[_0xb1e3('0x1c')]();});}};}function handleEntityNotFound(_0x429fe0,_0xa597de){return function(_0x516aae){if(!_0x516aae){_0x429fe0[_0xb1e3('0x29')](0x194);}return _0x516aae;};}function handleError(_0x5e0a49,_0x3b7e77){_0x3b7e77=_0x3b7e77||0x1f4;return function(_0x282bd4){logger[_0xb1e3('0x2a')](_0x282bd4[_0xb1e3('0x2b')]);if(_0x282bd4['name']){delete _0x282bd4['name'];}_0x5e0a49[_0xb1e3('0x1b')](_0x3b7e77)['send'](_0x282bd4);};}exports[_0xb1e3('0x2c')]=function(_0x18d312,_0x5de66a){var _0x4d7f56={},_0xd35191={},_0x3af130={'count':0x0,'rows':[]};var _0x1681c8=_[_0xb1e3('0x2d')](db[_0xb1e3('0x2e')]['rawAttributes'],function(_0x2fd9db){return{'name':_0x2fd9db[_0xb1e3('0x2f')],'type':_0x2fd9db[_0xb1e3('0x30')][_0xb1e3('0x31')]};});_0xd35191['model']=_[_0xb1e3('0x2d')](_0x1681c8,_0xb1e3('0x32'));_0xd35191[_0xb1e3('0x33')]=_['keys'](_0x18d312['query']);_0xd35191['filters']=_[_0xb1e3('0x34')](_0xd35191['model'],_0xd35191[_0xb1e3('0x33')]);_0x4d7f56[_0xb1e3('0x35')]=_['intersection'](_0xd35191['model'],qs[_0xb1e3('0x36')](_0x18d312[_0xb1e3('0x33')]['fields']));_0x4d7f56[_0xb1e3('0x35')]=_0x4d7f56['attributes']['length']?_0x4d7f56['attributes']:_0xd35191[_0xb1e3('0x37')];if(!_0x18d312[_0xb1e3('0x33')]['hasOwnProperty'](_0xb1e3('0x38'))){_0x4d7f56[_0xb1e3('0x1f')]=qs['limit'](_0x18d312[_0xb1e3('0x33')][_0xb1e3('0x1f')]);_0x4d7f56['offset']=qs[_0xb1e3('0x21')](_0x18d312['query'][_0xb1e3('0x21')]);}_0x4d7f56[_0xb1e3('0x39')]=qs[_0xb1e3('0x3a')](_0x18d312[_0xb1e3('0x33')]['sort']);_0x4d7f56['where']=qs[_0xb1e3('0x3b')](_['pick'](_0x18d312[_0xb1e3('0x33')],_0xd35191[_0xb1e3('0x3b')]),_0x1681c8);if(_0x18d312[_0xb1e3('0x33')][_0xb1e3('0x3c')]){_0x4d7f56['where']=_[_0xb1e3('0x3d')](_0x4d7f56[_0xb1e3('0x3e')],{'$or':_['map'](_0x1681c8,function(_0x369cc1){if(_0x369cc1[_0xb1e3('0x30')]!==_0xb1e3('0x3f')){var _0x5e8e29={};_0x5e8e29[_0x369cc1['name']]={'$like':'%'+_0x18d312[_0xb1e3('0x33')]['filter']+'%'};return _0x5e8e29;}})});}_0x4d7f56=_[_0xb1e3('0x3d')]({},_0x4d7f56,_0x18d312[_0xb1e3('0x40')]);var _0x4a15bb={'where':_0x4d7f56[_0xb1e3('0x3e')]};return db[_0xb1e3('0x2e')]['count'](_0x4a15bb)['then'](function(_0x464c4b){_0x3af130[_0xb1e3('0x20')]=_0x464c4b;if(_0x18d312['query'][_0xb1e3('0x41')]){_0x4d7f56[_0xb1e3('0x42')]=[{'all':!![]}];}return db[_0xb1e3('0x2e')][_0xb1e3('0x43')](_0x4d7f56);})[_0xb1e3('0x27')](function(_0x4e2f58){_0x3af130[_0xb1e3('0x44')]=_0x4e2f58;return _0x3af130;})[_0xb1e3('0x27')](respondWithFilteredResult(_0x5de66a,_0x4d7f56))[_0xb1e3('0x45')](handleError(_0x5de66a,null));};exports['show']=function(_0x34171f,_0x903fab){var _0xd61082={'raw':![],'where':{'id':_0x34171f[_0xb1e3('0x46')]['id']}},_0x454b64={};_0x454b64[_0xb1e3('0x37')]=_['keys'](db[_0xb1e3('0x2e')][_0xb1e3('0x47')]);_0x454b64[_0xb1e3('0x33')]=_[_0xb1e3('0x48')](_0x34171f[_0xb1e3('0x33')]);_0x454b64['filters']=_[_0xb1e3('0x34')](_0x454b64[_0xb1e3('0x37')],_0x454b64[_0xb1e3('0x33')]);_0xd61082[_0xb1e3('0x35')]=_['intersection'](_0x454b64[_0xb1e3('0x37')],qs['fields'](_0x34171f[_0xb1e3('0x33')][_0xb1e3('0x36')]));_0xd61082['attributes']=_0xd61082[_0xb1e3('0x35')][_0xb1e3('0x49')]?_0xd61082['attributes']:_0x454b64['model'];if(_0x34171f['query'][_0xb1e3('0x41')]){_0xd61082[_0xb1e3('0x42')]=[{'all':!![]}];}_0xd61082=_['merge']({},_0xd61082,_0x34171f['options']);return db[_0xb1e3('0x2e')]['find'](_0xd61082)[_0xb1e3('0x27')](handleEntityNotFound(_0x903fab,null))[_0xb1e3('0x27')](respondWithResult(_0x903fab,null))['catch'](handleError(_0x903fab,null));};exports[_0xb1e3('0x4a')]=function(_0x4e01f3,_0x5a6475){return db['VoiceQueueReport'][_0xb1e3('0x4a')](_0x4e01f3[_0xb1e3('0x4b')],{})[_0xb1e3('0x27')](respondWithResult(_0x5a6475,0xc9))[_0xb1e3('0x45')](handleError(_0x5a6475,null));};exports[_0xb1e3('0x4c')]=function(_0x367f75,_0xac6d2a){if(_0x367f75['body']['id']){delete _0x367f75['body']['id'];}return db[_0xb1e3('0x2e')][_0xb1e3('0x4d')]({'where':{'id':_0x367f75['params']['id']}})[_0xb1e3('0x27')](handleEntityNotFound(_0xac6d2a,null))[_0xb1e3('0x27')](saveUpdates(_0x367f75[_0xb1e3('0x4b')],null))['then'](respondWithResult(_0xac6d2a,null))['catch'](handleError(_0xac6d2a,null));};exports[_0xb1e3('0x28')]=function(_0x304fab,_0x354a12){return db[_0xb1e3('0x2e')][_0xb1e3('0x4d')]({'where':{'id':_0x304fab[_0xb1e3('0x46')]['id']}})[_0xb1e3('0x27')](handleEntityNotFound(_0x354a12,null))[_0xb1e3('0x27')](removeEntity(_0x354a12,null))[_0xb1e3('0x45')](handleError(_0x354a12,null));};exports[_0xb1e3('0x4e')]=function(_0x54f29b,_0x1001d3){return db[_0xb1e3('0x2e')][_0xb1e3('0x4e')]()[_0xb1e3('0x27')](respondWithResult(_0x1001d3,null))[_0xb1e3('0x45')](handleError(_0x1001d3,null));};exports[_0xb1e3('0x4f')]=function(_0x5a2ed4,_0x2f742c){var _0x237f06={},_0x2e9962={},_0x2a5669={'count':0x0,'rows':[]};_0x2e9962[_0xb1e3('0x37')]=_[_0xb1e3('0x48')](db[_0xb1e3('0x2e')][_0xb1e3('0x47')]);_0x2e9962[_0xb1e3('0x33')]=_['keys'](_0x5a2ed4[_0xb1e3('0x33')]);_0x2e9962[_0xb1e3('0x3b')]=_[_0xb1e3('0x34')](_0x2e9962[_0xb1e3('0x37')],_0x2e9962[_0xb1e3('0x33')]);_0x237f06[_0xb1e3('0x35')]=_[_0xb1e3('0x34')](_0x2e9962[_0xb1e3('0x37')],qs['fields'](_0x5a2ed4['query'][_0xb1e3('0x36')]));_0x237f06[_0xb1e3('0x35')]=_0x237f06[_0xb1e3('0x35')][_0xb1e3('0x49')]?_0x237f06[_0xb1e3('0x35')]:_0x2e9962[_0xb1e3('0x37')];if(!_0x5a2ed4[_0xb1e3('0x33')][_0xb1e3('0x50')](_0xb1e3('0x38'))){_0x237f06['limit']=qs[_0xb1e3('0x1f')](_0x5a2ed4[_0xb1e3('0x33')][_0xb1e3('0x1f')]);_0x237f06[_0xb1e3('0x21')]=qs['offset'](_0x5a2ed4[_0xb1e3('0x33')][_0xb1e3('0x21')]);}_0x237f06[_0xb1e3('0x39')]=qs[_0xb1e3('0x3a')](_0x5a2ed4[_0xb1e3('0x33')][_0xb1e3('0x3a')]);_0x237f06[_0xb1e3('0x3e')]=qs[_0xb1e3('0x3b')](_[_0xb1e3('0x51')](_0x5a2ed4['query'],_0x2e9962[_0xb1e3('0x3b')]));if(_0x5a2ed4[_0xb1e3('0x33')]['filter']){_0x237f06[_0xb1e3('0x3e')]=_[_0xb1e3('0x3d')](_0x237f06[_0xb1e3('0x3e')],{'$or':_[_0xb1e3('0x2d')](_0x237f06[_0xb1e3('0x35')],function(_0x24d59e){var _0x58dcc6={};_0x58dcc6[_0x24d59e]={'$like':'%'+_0x5a2ed4[_0xb1e3('0x33')][_0xb1e3('0x3c')]+'%'};return _0x58dcc6;})});}_0x237f06=_['merge']({},_0x237f06,_0x5a2ed4['options']);var _0x55307f={'where':_0x237f06[_0xb1e3('0x3e')]};return db['VoiceQueueReport'][_0xb1e3('0x20')](_0x55307f)[_0xb1e3('0x27')](function(_0x310991){_0x2a5669[_0xb1e3('0x20')]=_0x310991;if(_0x5a2ed4[_0xb1e3('0x33')][_0xb1e3('0x41')]){_0x237f06['include']=[{'all':!![]}];}return db[_0xb1e3('0x2e')][_0xb1e3('0x43')](_0x237f06);})[_0xb1e3('0x27')](function(_0x15b209){_0x2a5669['rows']=_0x15b209;return _0x2a5669;})[_0xb1e3('0x27')](respondWithFilteredResult(_0x2f742c,_0x237f06,_0xb1e3('0x4f')))[_0xb1e3('0x45')](handleError(_0x2f742c,null,'getVoiceQueuesReport'));};