Built motion from commit 97153652.|2.6.26
[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 _0x4b0a=['order','sort','where','pick','filter','merge','map','options','count','includeAll','include','findAll','rows','catch','show','params','rawAttributes','create','body','find','describe','hasOwnProperty','getVoiceQueuesReport','eml-format','fast-json-patch','request-promise','moment','bluebird','util','sox','to-csv','ejs','fs-extra','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','redis','register','sendStatus','status','end','json','offset','undefined','limit','Content-Range','apply','reject','save','update','then','error','stack','name','send','index','VoiceQueueReport','type','key','query','keys','filters','intersection','model','attributes','fields','length','nolimit'];(function(_0x31e29a,_0x349c9b){var _0x32d892=function(_0x41cc86){while(--_0x41cc86){_0x31e29a['push'](_0x31e29a['shift']());}};_0x32d892(++_0x349c9b);}(_0x4b0a,0x104));var _0xa4b0=function(_0x5b4cb5,_0x2c296e){_0x5b4cb5=_0x5b4cb5-0x0;var _0x13d4e0=_0x4b0a[_0x5b4cb5];return _0x13d4e0;};'use strict';var emlformat=require(_0xa4b0('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xa4b0('0x1'));var rp=require(_0xa4b0('0x2'));var moment=require(_0xa4b0('0x3'));var BPromise=require(_0xa4b0('0x4'));var Mustache=require('mustache');var util=require(_0xa4b0('0x5'));var path=require('path');var sox=require(_0xa4b0('0x6'));var csv=require(_0xa4b0('0x7'));var ejs=require(_0xa4b0('0x8'));var fs=require('fs');var fs_extra=require(_0xa4b0('0x9'));var _=require(_0xa4b0('0xa'));var squel=require('squel');var crypto=require(_0xa4b0('0xb'));var jsforce=require(_0xa4b0('0xc'));var deskjs=require(_0xa4b0('0xd'));var toCsv=require(_0xa4b0('0x7'));var querystring=require(_0xa4b0('0xe'));var Papa=require(_0xa4b0('0xf'));var Redis=require(_0xa4b0('0x10'));var authService=require(_0xa4b0('0x11'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xa4b0('0x12'));var logger=require(_0xa4b0('0x13'))(_0xa4b0('0x14'));var utils=require('../../config/utils');var config=require(_0xa4b0('0x15'));var licenseUtil=require(_0xa4b0('0x16'));var db=require(_0xa4b0('0x17'))['db'];config['redis']=_['defaults'](config['redis'],{'host':'localhost','port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0xa4b0('0x18')]));require('./voiceQueueReport.socket')[_0xa4b0('0x19')](socket);function respondWithStatusCode(_0x20c5d1,_0x5dff22){_0x5dff22=_0x5dff22||0xcc;return function(_0xa83c38){if(_0xa83c38){return _0x20c5d1[_0xa4b0('0x1a')](_0x5dff22);}return _0x20c5d1[_0xa4b0('0x1b')](_0x5dff22)[_0xa4b0('0x1c')]();};}function respondWithResult(_0x48c983,_0x1be186){_0x1be186=_0x1be186||0xc8;return function(_0xbc3470){if(_0xbc3470){return _0x48c983[_0xa4b0('0x1b')](_0x1be186)[_0xa4b0('0x1d')](_0xbc3470);}};}function respondWithFilteredResult(_0x3bd202,_0x53d1cd){return function(_0x5ac9e4){if(_0x5ac9e4){var _0x5e6763=typeof _0x53d1cd[_0xa4b0('0x1e')]===_0xa4b0('0x1f')&&typeof _0x53d1cd[_0xa4b0('0x20')]===_0xa4b0('0x1f');var _0xab868e=_0x5ac9e4['count'];var _0x105ed4=_0x5e6763?0x0:_0x53d1cd[_0xa4b0('0x1e')];var _0x3a68ab=_0x5e6763?_0x5ac9e4['count']:_0x53d1cd[_0xa4b0('0x1e')]+_0x53d1cd[_0xa4b0('0x20')];var _0x5d6426;if(_0x3a68ab>=_0xab868e){_0x3a68ab=_0xab868e;_0x5d6426=0xc8;}else{_0x5d6426=0xce;}_0x3bd202[_0xa4b0('0x1b')](_0x5d6426);return _0x3bd202['set'](_0xa4b0('0x21'),_0x105ed4+'-'+_0x3a68ab+'/'+_0xab868e)[_0xa4b0('0x1d')](_0x5ac9e4);}return null;};}function patchUpdates(_0x3de929){return function(_0x4ebf3d){try{jsonpatch[_0xa4b0('0x22')](_0x4ebf3d,_0x3de929,!![]);}catch(_0x46bebd){return BPromise[_0xa4b0('0x23')](_0x46bebd);}return _0x4ebf3d[_0xa4b0('0x24')]();};}function saveUpdates(_0x2c5326,_0x392b71){return function(_0x3003ec){if(_0x3003ec){return _0x3003ec[_0xa4b0('0x25')](_0x2c5326)['then'](function(_0x377f82){return _0x377f82;});}return null;};}function removeEntity(_0x3adae3,_0x5847a2){return function(_0x3e08d6){if(_0x3e08d6){return _0x3e08d6['destroy']()[_0xa4b0('0x26')](function(){_0x3adae3[_0xa4b0('0x1b')](0xcc)[_0xa4b0('0x1c')]();});}};}function handleEntityNotFound(_0x565d17,_0x56e0a4){return function(_0x3ce163){if(!_0x3ce163){_0x565d17[_0xa4b0('0x1a')](0x194);}return _0x3ce163;};}function handleError(_0x242784,_0x21de85){_0x21de85=_0x21de85||0x1f4;return function(_0x4a68d7){logger[_0xa4b0('0x27')](_0x4a68d7[_0xa4b0('0x28')]);if(_0x4a68d7[_0xa4b0('0x29')]){delete _0x4a68d7[_0xa4b0('0x29')];}_0x242784[_0xa4b0('0x1b')](_0x21de85)[_0xa4b0('0x2a')](_0x4a68d7);};}exports[_0xa4b0('0x2b')]=function(_0x4c94d2,_0x3ba029){var _0x9c351e={},_0x1a6f3d={},_0x1dbd0f={'count':0x0,'rows':[]};var _0x2f5317=_['map'](db[_0xa4b0('0x2c')]['rawAttributes'],function(_0x1881de){return{'name':_0x1881de['fieldName'],'type':_0x1881de[_0xa4b0('0x2d')][_0xa4b0('0x2e')]};});_0x1a6f3d['model']=_['map'](_0x2f5317,_0xa4b0('0x29'));_0x1a6f3d[_0xa4b0('0x2f')]=_[_0xa4b0('0x30')](_0x4c94d2[_0xa4b0('0x2f')]);_0x1a6f3d[_0xa4b0('0x31')]=_[_0xa4b0('0x32')](_0x1a6f3d[_0xa4b0('0x33')],_0x1a6f3d[_0xa4b0('0x2f')]);_0x9c351e[_0xa4b0('0x34')]=_['intersection'](_0x1a6f3d[_0xa4b0('0x33')],qs[_0xa4b0('0x35')](_0x4c94d2[_0xa4b0('0x2f')]['fields']));_0x9c351e[_0xa4b0('0x34')]=_0x9c351e['attributes'][_0xa4b0('0x36')]?_0x9c351e[_0xa4b0('0x34')]:_0x1a6f3d[_0xa4b0('0x33')];if(!_0x4c94d2[_0xa4b0('0x2f')]['hasOwnProperty'](_0xa4b0('0x37'))){_0x9c351e[_0xa4b0('0x20')]=qs[_0xa4b0('0x20')](_0x4c94d2[_0xa4b0('0x2f')][_0xa4b0('0x20')]);_0x9c351e['offset']=qs[_0xa4b0('0x1e')](_0x4c94d2['query'][_0xa4b0('0x1e')]);}_0x9c351e[_0xa4b0('0x38')]=qs[_0xa4b0('0x39')](_0x4c94d2['query'][_0xa4b0('0x39')]);_0x9c351e[_0xa4b0('0x3a')]=qs[_0xa4b0('0x31')](_[_0xa4b0('0x3b')](_0x4c94d2['query'],_0x1a6f3d['filters']),_0x2f5317);if(_0x4c94d2[_0xa4b0('0x2f')][_0xa4b0('0x3c')]){_0x9c351e[_0xa4b0('0x3a')]=_[_0xa4b0('0x3d')](_0x9c351e[_0xa4b0('0x3a')],{'$or':_[_0xa4b0('0x3e')](_0x2f5317,function(_0x2ba8d3){if(_0x2ba8d3[_0xa4b0('0x2d')]!=='VIRTUAL'){var _0x400423={};_0x400423[_0x2ba8d3[_0xa4b0('0x29')]]={'$like':'%'+_0x4c94d2[_0xa4b0('0x2f')][_0xa4b0('0x3c')]+'%'};return _0x400423;}})});}_0x9c351e=_[_0xa4b0('0x3d')]({},_0x9c351e,_0x4c94d2[_0xa4b0('0x3f')]);var _0x1c0828={'where':_0x9c351e[_0xa4b0('0x3a')]};return db['VoiceQueueReport'][_0xa4b0('0x40')](_0x1c0828)[_0xa4b0('0x26')](function(_0x1e9d33){_0x1dbd0f['count']=_0x1e9d33;if(_0x4c94d2[_0xa4b0('0x2f')][_0xa4b0('0x41')]){_0x9c351e[_0xa4b0('0x42')]=[{'all':!![]}];}return db['VoiceQueueReport'][_0xa4b0('0x43')](_0x9c351e);})['then'](function(_0x4b3df0){_0x1dbd0f[_0xa4b0('0x44')]=_0x4b3df0;return _0x1dbd0f;})[_0xa4b0('0x26')](respondWithFilteredResult(_0x3ba029,_0x9c351e))[_0xa4b0('0x45')](handleError(_0x3ba029,null));};exports[_0xa4b0('0x46')]=function(_0x561832,_0x4b1660){var _0x2b7957={'raw':![],'where':{'id':_0x561832[_0xa4b0('0x47')]['id']}},_0x531b9c={};_0x531b9c['model']=_[_0xa4b0('0x30')](db['VoiceQueueReport'][_0xa4b0('0x48')]);_0x531b9c[_0xa4b0('0x2f')]=_[_0xa4b0('0x30')](_0x561832[_0xa4b0('0x2f')]);_0x531b9c[_0xa4b0('0x31')]=_[_0xa4b0('0x32')](_0x531b9c['model'],_0x531b9c[_0xa4b0('0x2f')]);_0x2b7957[_0xa4b0('0x34')]=_[_0xa4b0('0x32')](_0x531b9c['model'],qs[_0xa4b0('0x35')](_0x561832[_0xa4b0('0x2f')][_0xa4b0('0x35')]));_0x2b7957[_0xa4b0('0x34')]=_0x2b7957[_0xa4b0('0x34')]['length']?_0x2b7957[_0xa4b0('0x34')]:_0x531b9c[_0xa4b0('0x33')];if(_0x561832[_0xa4b0('0x2f')][_0xa4b0('0x41')]){_0x2b7957[_0xa4b0('0x42')]=[{'all':!![]}];}_0x2b7957=_[_0xa4b0('0x3d')]({},_0x2b7957,_0x561832[_0xa4b0('0x3f')]);return db[_0xa4b0('0x2c')]['find'](_0x2b7957)[_0xa4b0('0x26')](handleEntityNotFound(_0x4b1660,null))[_0xa4b0('0x26')](respondWithResult(_0x4b1660,null))['catch'](handleError(_0x4b1660,null));};exports[_0xa4b0('0x49')]=function(_0x3fd1c0,_0x4e8b76){return db[_0xa4b0('0x2c')]['create'](_0x3fd1c0[_0xa4b0('0x4a')],{})[_0xa4b0('0x26')](respondWithResult(_0x4e8b76,0xc9))[_0xa4b0('0x45')](handleError(_0x4e8b76,null));};exports[_0xa4b0('0x25')]=function(_0x106198,_0x1e7490){if(_0x106198[_0xa4b0('0x4a')]['id']){delete _0x106198[_0xa4b0('0x4a')]['id'];}return db[_0xa4b0('0x2c')]['find']({'where':{'id':_0x106198['params']['id']}})[_0xa4b0('0x26')](handleEntityNotFound(_0x1e7490,null))[_0xa4b0('0x26')](saveUpdates(_0x106198[_0xa4b0('0x4a')],null))[_0xa4b0('0x26')](respondWithResult(_0x1e7490,null))[_0xa4b0('0x45')](handleError(_0x1e7490,null));};exports['destroy']=function(_0x2d5f42,_0xb54309){return db[_0xa4b0('0x2c')][_0xa4b0('0x4b')]({'where':{'id':_0x2d5f42['params']['id']}})[_0xa4b0('0x26')](handleEntityNotFound(_0xb54309,null))[_0xa4b0('0x26')](removeEntity(_0xb54309,null))[_0xa4b0('0x45')](handleError(_0xb54309,null));};exports[_0xa4b0('0x4c')]=function(_0x281b15,_0x2879c8){return db[_0xa4b0('0x2c')][_0xa4b0('0x4c')]()[_0xa4b0('0x26')](respondWithResult(_0x2879c8,null))[_0xa4b0('0x45')](handleError(_0x2879c8,null));};exports['getVoiceQueuesReport']=function(_0x460f3d,_0x46264c){var _0x416e50={},_0x3139b0={},_0x589606={'count':0x0,'rows':[]};_0x3139b0['model']=_[_0xa4b0('0x30')](db[_0xa4b0('0x2c')][_0xa4b0('0x48')]);_0x3139b0['query']=_[_0xa4b0('0x30')](_0x460f3d[_0xa4b0('0x2f')]);_0x3139b0['filters']=_['intersection'](_0x3139b0['model'],_0x3139b0[_0xa4b0('0x2f')]);_0x416e50[_0xa4b0('0x34')]=_[_0xa4b0('0x32')](_0x3139b0[_0xa4b0('0x33')],qs[_0xa4b0('0x35')](_0x460f3d[_0xa4b0('0x2f')][_0xa4b0('0x35')]));_0x416e50[_0xa4b0('0x34')]=_0x416e50['attributes']['length']?_0x416e50[_0xa4b0('0x34')]:_0x3139b0[_0xa4b0('0x33')];if(!_0x460f3d['query'][_0xa4b0('0x4d')](_0xa4b0('0x37'))){_0x416e50[_0xa4b0('0x20')]=qs['limit'](_0x460f3d[_0xa4b0('0x2f')][_0xa4b0('0x20')]);_0x416e50[_0xa4b0('0x1e')]=qs[_0xa4b0('0x1e')](_0x460f3d['query'][_0xa4b0('0x1e')]);}_0x416e50[_0xa4b0('0x38')]=qs[_0xa4b0('0x39')](_0x460f3d['query'][_0xa4b0('0x39')]);_0x416e50[_0xa4b0('0x3a')]=qs[_0xa4b0('0x31')](_[_0xa4b0('0x3b')](_0x460f3d[_0xa4b0('0x2f')],_0x3139b0[_0xa4b0('0x31')]));if(_0x460f3d[_0xa4b0('0x2f')][_0xa4b0('0x3c')]){_0x416e50[_0xa4b0('0x3a')]=_[_0xa4b0('0x3d')](_0x416e50[_0xa4b0('0x3a')],{'$or':_[_0xa4b0('0x3e')](_0x416e50[_0xa4b0('0x34')],function(_0x10b33d){var _0x292f43={};_0x292f43[_0x10b33d]={'$like':'%'+_0x460f3d[_0xa4b0('0x2f')][_0xa4b0('0x3c')]+'%'};return _0x292f43;})});}_0x416e50=_['merge']({},_0x416e50,_0x460f3d[_0xa4b0('0x3f')]);var _0x3f129c={'where':_0x416e50[_0xa4b0('0x3a')]};return db[_0xa4b0('0x2c')][_0xa4b0('0x40')](_0x3f129c)['then'](function(_0x60b0b2){_0x589606[_0xa4b0('0x40')]=_0x60b0b2;if(_0x460f3d['query'][_0xa4b0('0x41')]){_0x416e50[_0xa4b0('0x42')]=[{'all':!![]}];}return db['VoiceQueueReport'][_0xa4b0('0x43')](_0x416e50);})[_0xa4b0('0x26')](function(_0x8ff2e7){_0x589606[_0xa4b0('0x44')]=_0x8ff2e7;return _0x589606;})[_0xa4b0('0x26')](respondWithFilteredResult(_0x46264c,_0x416e50,_0xa4b0('0x4e')))[_0xa4b0('0x45')](handleError(_0x46264c,null,_0xa4b0('0x4e')));};