ddd4f331100cd6b805b278f7a93d9903d7990cf9
[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 _0x0d55=['rawAttributes','fieldName','key','model','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','count','includeAll','include','findAll','rows','params','keys','options','find','body','catch','update','destroy','describe','getVoiceQueuesReport','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','util','path','sox','to-csv','ejs','fs-extra','squel','crypto','desk.js','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','socket.io-emitter','./voiceQueueReport.socket','register','sendStatus','status','end','offset','undefined','limit','set','Content-Range','json','apply','save','then','error','stack','name','send','index','map','VoiceQueueReport'];(function(_0x362ed9,_0x4bc126){var _0x52325e=function(_0x1a4ade){while(--_0x1a4ade){_0x362ed9['push'](_0x362ed9['shift']());}};_0x52325e(++_0x4bc126);}(_0x0d55,0x11b));var _0x50d5=function(_0x2fe7b9,_0x1bcf21){_0x2fe7b9=_0x2fe7b9-0x0;var _0x1836e1=_0x0d55[_0x2fe7b9];return _0x1836e1;};'use strict';var emlformat=require(_0x50d5('0x0'));var rimraf=require(_0x50d5('0x1'));var zipdir=require(_0x50d5('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x50d5('0x3'));var moment=require(_0x50d5('0x4'));var BPromise=require(_0x50d5('0x5'));var Mustache=require('mustache');var util=require(_0x50d5('0x6'));var path=require(_0x50d5('0x7'));var sox=require(_0x50d5('0x8'));var csv=require(_0x50d5('0x9'));var ejs=require(_0x50d5('0xa'));var fs=require('fs');var fs_extra=require(_0x50d5('0xb'));var _=require('lodash');var squel=require(_0x50d5('0xc'));var crypto=require(_0x50d5('0xd'));var jsforce=require('jsforce');var deskjs=require(_0x50d5('0xe'));var toCsv=require(_0x50d5('0x9'));var querystring=require('querystring');var Papa=require(_0x50d5('0xf'));var Redis=require('ioredis');var authService=require(_0x50d5('0x10'));var qs=require(_0x50d5('0x11'));var as=require(_0x50d5('0x12'));var hardwareService=require(_0x50d5('0x13'));var logger=require(_0x50d5('0x14'))('api');var utils=require(_0x50d5('0x15'));var config=require(_0x50d5('0x16'));var licenseUtil=require(_0x50d5('0x17'));var db=require(_0x50d5('0x18'))['db'];config[_0x50d5('0x19')]=_[_0x50d5('0x1a')](config[_0x50d5('0x19')],{'host':'localhost','port':0x18eb});var socket=require(_0x50d5('0x1b'))(new Redis(config[_0x50d5('0x19')]));require(_0x50d5('0x1c'))[_0x50d5('0x1d')](socket);function respondWithStatusCode(_0x3064de,_0x44605d){_0x44605d=_0x44605d||0xcc;return function(_0x5852be){if(_0x5852be){return _0x3064de[_0x50d5('0x1e')](_0x44605d);}return _0x3064de[_0x50d5('0x1f')](_0x44605d)[_0x50d5('0x20')]();};}function respondWithResult(_0x437514,_0x44a879){_0x44a879=_0x44a879||0xc8;return function(_0x33ef13){if(_0x33ef13){return _0x437514[_0x50d5('0x1f')](_0x44a879)['json'](_0x33ef13);}};}function respondWithFilteredResult(_0x2c5e26,_0x2c4ba9){return function(_0x391b9d){if(_0x391b9d){var _0x19a3b1=typeof _0x2c4ba9[_0x50d5('0x21')]===_0x50d5('0x22')&&typeof _0x2c4ba9[_0x50d5('0x23')]==='undefined';var _0x1fdc3c=_0x391b9d['count'];var _0x1c0e15=_0x19a3b1?0x0:_0x2c4ba9[_0x50d5('0x21')];var _0x141a34=_0x19a3b1?_0x391b9d['count']:_0x2c4ba9[_0x50d5('0x21')]+_0x2c4ba9[_0x50d5('0x23')];var _0x2ff1a7;if(_0x141a34>=_0x1fdc3c){_0x141a34=_0x1fdc3c;_0x2ff1a7=0xc8;}else{_0x2ff1a7=0xce;}_0x2c5e26['status'](_0x2ff1a7);return _0x2c5e26[_0x50d5('0x24')](_0x50d5('0x25'),_0x1c0e15+'-'+_0x141a34+'/'+_0x1fdc3c)[_0x50d5('0x26')](_0x391b9d);}return null;};}function patchUpdates(_0x4c6256){return function(_0x8a0494){try{jsonpatch[_0x50d5('0x27')](_0x8a0494,_0x4c6256,!![]);}catch(_0x4ffdd7){return BPromise['reject'](_0x4ffdd7);}return _0x8a0494[_0x50d5('0x28')]();};}function saveUpdates(_0x2b15b9,_0x175170){return function(_0x22a005){if(_0x22a005){return _0x22a005['update'](_0x2b15b9)[_0x50d5('0x29')](function(_0x115c6c){return _0x115c6c;});}return null;};}function removeEntity(_0x56adf1,_0xccdb4c){return function(_0xd1d9b8){if(_0xd1d9b8){return _0xd1d9b8['destroy']()[_0x50d5('0x29')](function(){_0x56adf1[_0x50d5('0x1f')](0xcc)['end']();});}};}function handleEntityNotFound(_0x28f5bc,_0x4283cd){return function(_0x5f4ba9){if(!_0x5f4ba9){_0x28f5bc['sendStatus'](0x194);}return _0x5f4ba9;};}function handleError(_0x2cc22f,_0x3b4902){_0x3b4902=_0x3b4902||0x1f4;return function(_0x535759){logger[_0x50d5('0x2a')](_0x535759[_0x50d5('0x2b')]);if(_0x535759[_0x50d5('0x2c')]){delete _0x535759['name'];}_0x2cc22f[_0x50d5('0x1f')](_0x3b4902)[_0x50d5('0x2d')](_0x535759);};}exports[_0x50d5('0x2e')]=function(_0xf97ddb,_0x14b3cd){var _0x5b49fa={},_0x49ae7c={},_0x47e9b4={'count':0x0,'rows':[]};var _0xca9d0d=_[_0x50d5('0x2f')](db[_0x50d5('0x30')][_0x50d5('0x31')],function(_0x2a8098){return{'name':_0x2a8098[_0x50d5('0x32')],'type':_0x2a8098['type'][_0x50d5('0x33')]};});_0x49ae7c[_0x50d5('0x34')]=_[_0x50d5('0x2f')](_0xca9d0d,'name');_0x49ae7c[_0x50d5('0x35')]=_['keys'](_0xf97ddb[_0x50d5('0x35')]);_0x49ae7c[_0x50d5('0x36')]=_[_0x50d5('0x37')](_0x49ae7c[_0x50d5('0x34')],_0x49ae7c[_0x50d5('0x35')]);_0x5b49fa[_0x50d5('0x38')]=_[_0x50d5('0x37')](_0x49ae7c[_0x50d5('0x34')],qs[_0x50d5('0x39')](_0xf97ddb[_0x50d5('0x35')][_0x50d5('0x39')]));_0x5b49fa[_0x50d5('0x38')]=_0x5b49fa[_0x50d5('0x38')][_0x50d5('0x3a')]?_0x5b49fa['attributes']:_0x49ae7c[_0x50d5('0x34')];if(!_0xf97ddb[_0x50d5('0x35')][_0x50d5('0x3b')](_0x50d5('0x3c'))){_0x5b49fa['limit']=qs[_0x50d5('0x23')](_0xf97ddb[_0x50d5('0x35')][_0x50d5('0x23')]);_0x5b49fa[_0x50d5('0x21')]=qs[_0x50d5('0x21')](_0xf97ddb[_0x50d5('0x35')]['offset']);}_0x5b49fa[_0x50d5('0x3d')]=qs['sort'](_0xf97ddb[_0x50d5('0x35')][_0x50d5('0x3e')]);_0x5b49fa[_0x50d5('0x3f')]=qs[_0x50d5('0x36')](_[_0x50d5('0x40')](_0xf97ddb[_0x50d5('0x35')],_0x49ae7c['filters']),_0xca9d0d);if(_0xf97ddb[_0x50d5('0x35')][_0x50d5('0x41')]){_0x5b49fa[_0x50d5('0x3f')]=_[_0x50d5('0x42')](_0x5b49fa[_0x50d5('0x3f')],{'$or':_[_0x50d5('0x2f')](_0xca9d0d,function(_0x413dc7){if(_0x413dc7['type']!==_0x50d5('0x43')){var _0x5171ea={};_0x5171ea[_0x413dc7['name']]={'$like':'%'+_0xf97ddb[_0x50d5('0x35')][_0x50d5('0x41')]+'%'};return _0x5171ea;}})});}_0x5b49fa=_[_0x50d5('0x42')]({},_0x5b49fa,_0xf97ddb['options']);var _0x34f342={'where':_0x5b49fa['where']};return db[_0x50d5('0x30')][_0x50d5('0x44')](_0x34f342)[_0x50d5('0x29')](function(_0x2e0b11){_0x47e9b4['count']=_0x2e0b11;if(_0xf97ddb[_0x50d5('0x35')][_0x50d5('0x45')]){_0x5b49fa[_0x50d5('0x46')]=[{'all':!![]}];}return db['VoiceQueueReport'][_0x50d5('0x47')](_0x5b49fa);})[_0x50d5('0x29')](function(_0x3259b0){_0x47e9b4[_0x50d5('0x48')]=_0x3259b0;return _0x47e9b4;})[_0x50d5('0x29')](respondWithFilteredResult(_0x14b3cd,_0x5b49fa))['catch'](handleError(_0x14b3cd,null));};exports['show']=function(_0x1392f5,_0x1a1340){var _0x58ae58={'raw':![],'where':{'id':_0x1392f5[_0x50d5('0x49')]['id']}},_0x3c0cbe={};_0x3c0cbe[_0x50d5('0x34')]=_['keys'](db[_0x50d5('0x30')][_0x50d5('0x31')]);_0x3c0cbe['query']=_[_0x50d5('0x4a')](_0x1392f5[_0x50d5('0x35')]);_0x3c0cbe['filters']=_['intersection'](_0x3c0cbe[_0x50d5('0x34')],_0x3c0cbe[_0x50d5('0x35')]);_0x58ae58[_0x50d5('0x38')]=_['intersection'](_0x3c0cbe['model'],qs[_0x50d5('0x39')](_0x1392f5[_0x50d5('0x35')][_0x50d5('0x39')]));_0x58ae58[_0x50d5('0x38')]=_0x58ae58['attributes']['length']?_0x58ae58[_0x50d5('0x38')]:_0x3c0cbe[_0x50d5('0x34')];if(_0x1392f5[_0x50d5('0x35')][_0x50d5('0x45')]){_0x58ae58[_0x50d5('0x46')]=[{'all':!![]}];}_0x58ae58=_[_0x50d5('0x42')]({},_0x58ae58,_0x1392f5[_0x50d5('0x4b')]);return db[_0x50d5('0x30')][_0x50d5('0x4c')](_0x58ae58)['then'](handleEntityNotFound(_0x1a1340,null))[_0x50d5('0x29')](respondWithResult(_0x1a1340,null))['catch'](handleError(_0x1a1340,null));};exports['create']=function(_0x395037,_0x190697){return db[_0x50d5('0x30')]['create'](_0x395037[_0x50d5('0x4d')],{})[_0x50d5('0x29')](respondWithResult(_0x190697,0xc9))[_0x50d5('0x4e')](handleError(_0x190697,null));};exports[_0x50d5('0x4f')]=function(_0x1b567c,_0x56c45b){if(_0x1b567c[_0x50d5('0x4d')]['id']){delete _0x1b567c[_0x50d5('0x4d')]['id'];}return db[_0x50d5('0x30')][_0x50d5('0x4c')]({'where':{'id':_0x1b567c[_0x50d5('0x49')]['id']}})[_0x50d5('0x29')](handleEntityNotFound(_0x56c45b,null))[_0x50d5('0x29')](saveUpdates(_0x1b567c[_0x50d5('0x4d')],null))[_0x50d5('0x29')](respondWithResult(_0x56c45b,null))[_0x50d5('0x4e')](handleError(_0x56c45b,null));};exports[_0x50d5('0x50')]=function(_0x5a2834,_0x475cf6){return db[_0x50d5('0x30')][_0x50d5('0x4c')]({'where':{'id':_0x5a2834[_0x50d5('0x49')]['id']}})['then'](handleEntityNotFound(_0x475cf6,null))['then'](removeEntity(_0x475cf6,null))['catch'](handleError(_0x475cf6,null));};exports[_0x50d5('0x51')]=function(_0x1cce13,_0x5b50ff){return db[_0x50d5('0x30')][_0x50d5('0x51')]()[_0x50d5('0x29')](respondWithResult(_0x5b50ff,null))[_0x50d5('0x4e')](handleError(_0x5b50ff,null));};exports['getVoiceQueuesReport']=function(_0x3898f7,_0x2e2216){var _0x425ec0={},_0x89b808={},_0x2b2443={'count':0x0,'rows':[]};_0x89b808[_0x50d5('0x34')]=_[_0x50d5('0x4a')](db[_0x50d5('0x30')]['rawAttributes']);_0x89b808[_0x50d5('0x35')]=_[_0x50d5('0x4a')](_0x3898f7[_0x50d5('0x35')]);_0x89b808[_0x50d5('0x36')]=_[_0x50d5('0x37')](_0x89b808[_0x50d5('0x34')],_0x89b808['query']);_0x425ec0['attributes']=_[_0x50d5('0x37')](_0x89b808[_0x50d5('0x34')],qs['fields'](_0x3898f7['query']['fields']));_0x425ec0[_0x50d5('0x38')]=_0x425ec0[_0x50d5('0x38')][_0x50d5('0x3a')]?_0x425ec0[_0x50d5('0x38')]:_0x89b808['model'];if(!_0x3898f7[_0x50d5('0x35')]['hasOwnProperty'](_0x50d5('0x3c'))){_0x425ec0[_0x50d5('0x23')]=qs[_0x50d5('0x23')](_0x3898f7[_0x50d5('0x35')]['limit']);_0x425ec0[_0x50d5('0x21')]=qs[_0x50d5('0x21')](_0x3898f7[_0x50d5('0x35')]['offset']);}_0x425ec0['order']=qs[_0x50d5('0x3e')](_0x3898f7[_0x50d5('0x35')][_0x50d5('0x3e')]);_0x425ec0[_0x50d5('0x3f')]=qs['filters'](_['pick'](_0x3898f7[_0x50d5('0x35')],_0x89b808[_0x50d5('0x36')]));if(_0x3898f7['query'][_0x50d5('0x41')]){_0x425ec0[_0x50d5('0x3f')]=_[_0x50d5('0x42')](_0x425ec0[_0x50d5('0x3f')],{'$or':_[_0x50d5('0x2f')](_0x425ec0[_0x50d5('0x38')],function(_0x1032b1){var _0x5d3843={};_0x5d3843[_0x1032b1]={'$like':'%'+_0x3898f7[_0x50d5('0x35')][_0x50d5('0x41')]+'%'};return _0x5d3843;})});}_0x425ec0=_[_0x50d5('0x42')]({},_0x425ec0,_0x3898f7[_0x50d5('0x4b')]);var _0x346938={'where':_0x425ec0[_0x50d5('0x3f')]};return db['VoiceQueueReport'][_0x50d5('0x44')](_0x346938)[_0x50d5('0x29')](function(_0xdd6d54){_0x2b2443['count']=_0xdd6d54;if(_0x3898f7['query'][_0x50d5('0x45')]){_0x425ec0['include']=[{'all':!![]}];}return db[_0x50d5('0x30')][_0x50d5('0x47')](_0x425ec0);})[_0x50d5('0x29')](function(_0x7a370f){_0x2b2443[_0x50d5('0x48')]=_0x7a370f;return _0x2b2443;})[_0x50d5('0x29')](respondWithFilteredResult(_0x2e2216,_0x425ec0,_0x50d5('0x52')))[_0x50d5('0x4e')](handleError(_0x2e2216,null,_0x50d5('0x52')));};