43e443b4d3b09446e9475f69a3d4bc834c4a0975
[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 _0xd400=['send','index','map','VoiceQueueReport','fieldName','type','key','model','keys','query','filters','attributes','fields','length','hasOwnProperty','order','sort','where','pick','merge','filter','options','includeAll','findAll','rows','catch','rawAttributes','intersection','include','find','create','body','update','params','describe','nolimit','getVoiceQueuesReport','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','path','sox','to-csv','squel','crypto','jsforce','desk.js','querystring','../../components/auth/service','../../components/parsers/qs','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./voiceQueueReport.socket','status','json','offset','undefined','limit','count','set','Content-Range','apply','save','then','destroy','end','sendStatus','error','stack','name'];(function(_0x4c3b33,_0x58f69d){var _0x1d6d41=function(_0x4da977){while(--_0x4da977){_0x4c3b33['push'](_0x4c3b33['shift']());}};_0x1d6d41(++_0x58f69d);}(_0xd400,0x165));var _0x0d40=function(_0x50eea5,_0x4378af){_0x50eea5=_0x50eea5-0x0;var _0x3f94a6=_0xd400[_0x50eea5];return _0x3f94a6;};'use strict';var emlformat=require(_0x0d40('0x0'));var rimraf=require(_0x0d40('0x1'));var zipdir=require(_0x0d40('0x2'));var jsonpatch=require(_0x0d40('0x3'));var rp=require('request-promise');var moment=require(_0x0d40('0x4'));var BPromise=require(_0x0d40('0x5'));var Mustache=require(_0x0d40('0x6'));var util=require('util');var path=require(_0x0d40('0x7'));var sox=require(_0x0d40('0x8'));var csv=require(_0x0d40('0x9'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require('fs-extra');var _=require('lodash');var squel=require(_0x0d40('0xa'));var crypto=require(_0x0d40('0xb'));var jsforce=require(_0x0d40('0xc'));var deskjs=require(_0x0d40('0xd'));var toCsv=require(_0x0d40('0x9'));var querystring=require(_0x0d40('0xe'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x0d40('0xf'));var qs=require(_0x0d40('0x10'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')('api');var utils=require(_0x0d40('0x11'));var config=require(_0x0d40('0x12'));var licenseUtil=require(_0x0d40('0x13'));var db=require(_0x0d40('0x14'))['db'];config[_0x0d40('0x15')]=_[_0x0d40('0x16')](config[_0x0d40('0x15')],{'host':_0x0d40('0x17'),'port':0x18eb});var socket=require(_0x0d40('0x18'))(new Redis(config['redis']));require(_0x0d40('0x19'))['register'](socket);function respondWithStatusCode(_0x3c9199,_0x5723b9){_0x5723b9=_0x5723b9||0xcc;return function(_0xe4e494){if(_0xe4e494){return _0x3c9199['sendStatus'](_0x5723b9);}return _0x3c9199[_0x0d40('0x1a')](_0x5723b9)['end']();};}function respondWithResult(_0x3c754c,_0x16a98a){_0x16a98a=_0x16a98a||0xc8;return function(_0x215514){if(_0x215514){return _0x3c754c[_0x0d40('0x1a')](_0x16a98a)[_0x0d40('0x1b')](_0x215514);}};}function respondWithFilteredResult(_0x1caacf,_0x3d0a0b){return function(_0x59d59e){if(_0x59d59e){var _0x58383b=typeof _0x3d0a0b[_0x0d40('0x1c')]===_0x0d40('0x1d')&&typeof _0x3d0a0b[_0x0d40('0x1e')]===_0x0d40('0x1d');var _0x56da03=_0x59d59e[_0x0d40('0x1f')];var _0x58ee09=_0x58383b?0x0:_0x3d0a0b[_0x0d40('0x1c')];var _0x204699=_0x58383b?_0x59d59e['count']:_0x3d0a0b['offset']+_0x3d0a0b[_0x0d40('0x1e')];var _0xf9e489;if(_0x204699>=_0x56da03){_0x204699=_0x56da03;_0xf9e489=0xc8;}else{_0xf9e489=0xce;}_0x1caacf[_0x0d40('0x1a')](_0xf9e489);return _0x1caacf[_0x0d40('0x20')](_0x0d40('0x21'),_0x58ee09+'-'+_0x204699+'/'+_0x56da03)[_0x0d40('0x1b')](_0x59d59e);}return null;};}function patchUpdates(_0x24cd1a){return function(_0x461cb4){try{jsonpatch[_0x0d40('0x22')](_0x461cb4,_0x24cd1a,!![]);}catch(_0x3551b3){return BPromise['reject'](_0x3551b3);}return _0x461cb4[_0x0d40('0x23')]();};}function saveUpdates(_0x23d0d5,_0xdbb977){return function(_0x48117c){if(_0x48117c){return _0x48117c['update'](_0x23d0d5)[_0x0d40('0x24')](function(_0x1e9a90){return _0x1e9a90;});}return null;};}function removeEntity(_0x41d601,_0x1df763){return function(_0x1c0bd1){if(_0x1c0bd1){return _0x1c0bd1[_0x0d40('0x25')]()['then'](function(){_0x41d601['status'](0xcc)[_0x0d40('0x26')]();});}};}function handleEntityNotFound(_0x54cf90,_0x170ccc){return function(_0x335459){if(!_0x335459){_0x54cf90[_0x0d40('0x27')](0x194);}return _0x335459;};}function handleError(_0x57f78c,_0x25f192){_0x25f192=_0x25f192||0x1f4;return function(_0x33ef24){logger[_0x0d40('0x28')](_0x33ef24[_0x0d40('0x29')]);if(_0x33ef24[_0x0d40('0x2a')]){delete _0x33ef24[_0x0d40('0x2a')];}_0x57f78c[_0x0d40('0x1a')](_0x25f192)[_0x0d40('0x2b')](_0x33ef24);};}exports[_0x0d40('0x2c')]=function(_0x566170,_0x2117e8){var _0x43b283={},_0x4a65c3={},_0x1015e3={'count':0x0,'rows':[]};var _0x4591dd=_[_0x0d40('0x2d')](db[_0x0d40('0x2e')]['rawAttributes'],function(_0x522308){return{'name':_0x522308[_0x0d40('0x2f')],'type':_0x522308[_0x0d40('0x30')][_0x0d40('0x31')]};});_0x4a65c3[_0x0d40('0x32')]=_[_0x0d40('0x2d')](_0x4591dd,_0x0d40('0x2a'));_0x4a65c3['query']=_[_0x0d40('0x33')](_0x566170[_0x0d40('0x34')]);_0x4a65c3[_0x0d40('0x35')]=_['intersection'](_0x4a65c3[_0x0d40('0x32')],_0x4a65c3[_0x0d40('0x34')]);_0x43b283[_0x0d40('0x36')]=_['intersection'](_0x4a65c3[_0x0d40('0x32')],qs[_0x0d40('0x37')](_0x566170[_0x0d40('0x34')][_0x0d40('0x37')]));_0x43b283[_0x0d40('0x36')]=_0x43b283[_0x0d40('0x36')][_0x0d40('0x38')]?_0x43b283[_0x0d40('0x36')]:_0x4a65c3[_0x0d40('0x32')];if(!_0x566170[_0x0d40('0x34')][_0x0d40('0x39')]('nolimit')){_0x43b283[_0x0d40('0x1e')]=qs[_0x0d40('0x1e')](_0x566170[_0x0d40('0x34')][_0x0d40('0x1e')]);_0x43b283[_0x0d40('0x1c')]=qs[_0x0d40('0x1c')](_0x566170[_0x0d40('0x34')]['offset']);}_0x43b283[_0x0d40('0x3a')]=qs[_0x0d40('0x3b')](_0x566170[_0x0d40('0x34')]['sort']);_0x43b283[_0x0d40('0x3c')]=qs[_0x0d40('0x35')](_[_0x0d40('0x3d')](_0x566170[_0x0d40('0x34')],_0x4a65c3[_0x0d40('0x35')]),_0x4591dd);if(_0x566170['query']['filter']){_0x43b283['where']=_[_0x0d40('0x3e')](_0x43b283['where'],{'$or':_[_0x0d40('0x2d')](_0x4591dd,function(_0x5d2358){if(_0x5d2358['type']!=='VIRTUAL'){var _0x3826d5={};_0x3826d5[_0x5d2358['name']]={'$like':'%'+_0x566170[_0x0d40('0x34')][_0x0d40('0x3f')]+'%'};return _0x3826d5;}})});}_0x43b283=_['merge']({},_0x43b283,_0x566170[_0x0d40('0x40')]);var _0x1fb232={'where':_0x43b283[_0x0d40('0x3c')]};return db['VoiceQueueReport'][_0x0d40('0x1f')](_0x1fb232)[_0x0d40('0x24')](function(_0x371840){_0x1015e3[_0x0d40('0x1f')]=_0x371840;if(_0x566170['query'][_0x0d40('0x41')]){_0x43b283['include']=[{'all':!![]}];}return db['VoiceQueueReport'][_0x0d40('0x42')](_0x43b283);})['then'](function(_0x53ee2d){_0x1015e3[_0x0d40('0x43')]=_0x53ee2d;return _0x1015e3;})[_0x0d40('0x24')](respondWithFilteredResult(_0x2117e8,_0x43b283))[_0x0d40('0x44')](handleError(_0x2117e8,null));};exports['show']=function(_0x1b0cd3,_0x16197f){var _0x54bbb0={'raw':![],'where':{'id':_0x1b0cd3['params']['id']}},_0x49a461={};_0x49a461[_0x0d40('0x32')]=_[_0x0d40('0x33')](db[_0x0d40('0x2e')][_0x0d40('0x45')]);_0x49a461[_0x0d40('0x34')]=_[_0x0d40('0x33')](_0x1b0cd3[_0x0d40('0x34')]);_0x49a461['filters']=_['intersection'](_0x49a461[_0x0d40('0x32')],_0x49a461[_0x0d40('0x34')]);_0x54bbb0[_0x0d40('0x36')]=_[_0x0d40('0x46')](_0x49a461[_0x0d40('0x32')],qs[_0x0d40('0x37')](_0x1b0cd3[_0x0d40('0x34')]['fields']));_0x54bbb0[_0x0d40('0x36')]=_0x54bbb0[_0x0d40('0x36')][_0x0d40('0x38')]?_0x54bbb0[_0x0d40('0x36')]:_0x49a461[_0x0d40('0x32')];if(_0x1b0cd3[_0x0d40('0x34')][_0x0d40('0x41')]){_0x54bbb0[_0x0d40('0x47')]=[{'all':!![]}];}_0x54bbb0=_[_0x0d40('0x3e')]({},_0x54bbb0,_0x1b0cd3['options']);return db[_0x0d40('0x2e')][_0x0d40('0x48')](_0x54bbb0)[_0x0d40('0x24')](handleEntityNotFound(_0x16197f,null))[_0x0d40('0x24')](respondWithResult(_0x16197f,null))[_0x0d40('0x44')](handleError(_0x16197f,null));};exports[_0x0d40('0x49')]=function(_0x2504aa,_0x59439a){return db[_0x0d40('0x2e')][_0x0d40('0x49')](_0x2504aa[_0x0d40('0x4a')],{})[_0x0d40('0x24')](respondWithResult(_0x59439a,0xc9))['catch'](handleError(_0x59439a,null));};exports[_0x0d40('0x4b')]=function(_0x52df33,_0x264b50){if(_0x52df33[_0x0d40('0x4a')]['id']){delete _0x52df33[_0x0d40('0x4a')]['id'];}return db[_0x0d40('0x2e')][_0x0d40('0x48')]({'where':{'id':_0x52df33[_0x0d40('0x4c')]['id']}})[_0x0d40('0x24')](handleEntityNotFound(_0x264b50,null))['then'](saveUpdates(_0x52df33[_0x0d40('0x4a')],null))[_0x0d40('0x24')](respondWithResult(_0x264b50,null))[_0x0d40('0x44')](handleError(_0x264b50,null));};exports[_0x0d40('0x25')]=function(_0x1d0e06,_0x4b98ae){return db['VoiceQueueReport'][_0x0d40('0x48')]({'where':{'id':_0x1d0e06[_0x0d40('0x4c')]['id']}})['then'](handleEntityNotFound(_0x4b98ae,null))[_0x0d40('0x24')](removeEntity(_0x4b98ae,null))[_0x0d40('0x44')](handleError(_0x4b98ae,null));};exports[_0x0d40('0x4d')]=function(_0x39a395,_0xb46c0){return db[_0x0d40('0x2e')][_0x0d40('0x4d')]()[_0x0d40('0x24')](respondWithResult(_0xb46c0,null))[_0x0d40('0x44')](handleError(_0xb46c0,null));};exports['getVoiceQueuesReport']=function(_0x1a35b8,_0x17be00){var _0x46833d={},_0xe64fcd={},_0x2ba0b7={'count':0x0,'rows':[]};_0xe64fcd['model']=_[_0x0d40('0x33')](db[_0x0d40('0x2e')]['rawAttributes']);_0xe64fcd[_0x0d40('0x34')]=_[_0x0d40('0x33')](_0x1a35b8[_0x0d40('0x34')]);_0xe64fcd[_0x0d40('0x35')]=_['intersection'](_0xe64fcd['model'],_0xe64fcd[_0x0d40('0x34')]);_0x46833d[_0x0d40('0x36')]=_[_0x0d40('0x46')](_0xe64fcd[_0x0d40('0x32')],qs[_0x0d40('0x37')](_0x1a35b8[_0x0d40('0x34')][_0x0d40('0x37')]));_0x46833d[_0x0d40('0x36')]=_0x46833d[_0x0d40('0x36')][_0x0d40('0x38')]?_0x46833d[_0x0d40('0x36')]:_0xe64fcd['model'];if(!_0x1a35b8['query'][_0x0d40('0x39')](_0x0d40('0x4e'))){_0x46833d[_0x0d40('0x1e')]=qs[_0x0d40('0x1e')](_0x1a35b8[_0x0d40('0x34')][_0x0d40('0x1e')]);_0x46833d[_0x0d40('0x1c')]=qs[_0x0d40('0x1c')](_0x1a35b8[_0x0d40('0x34')]['offset']);}_0x46833d[_0x0d40('0x3a')]=qs[_0x0d40('0x3b')](_0x1a35b8[_0x0d40('0x34')][_0x0d40('0x3b')]);_0x46833d[_0x0d40('0x3c')]=qs['filters'](_[_0x0d40('0x3d')](_0x1a35b8[_0x0d40('0x34')],_0xe64fcd[_0x0d40('0x35')]));if(_0x1a35b8[_0x0d40('0x34')][_0x0d40('0x3f')]){_0x46833d[_0x0d40('0x3c')]=_[_0x0d40('0x3e')](_0x46833d[_0x0d40('0x3c')],{'$or':_[_0x0d40('0x2d')](_0x46833d['attributes'],function(_0x586710){var _0x4317b6={};_0x4317b6[_0x586710]={'$like':'%'+_0x1a35b8['query'][_0x0d40('0x3f')]+'%'};return _0x4317b6;})});}_0x46833d=_[_0x0d40('0x3e')]({},_0x46833d,_0x1a35b8['options']);var _0x26d22f={'where':_0x46833d[_0x0d40('0x3c')]};return db[_0x0d40('0x2e')][_0x0d40('0x1f')](_0x26d22f)[_0x0d40('0x24')](function(_0x16e3d9){_0x2ba0b7[_0x0d40('0x1f')]=_0x16e3d9;if(_0x1a35b8['query'][_0x0d40('0x41')]){_0x46833d['include']=[{'all':!![]}];}return db[_0x0d40('0x2e')][_0x0d40('0x42')](_0x46833d);})[_0x0d40('0x24')](function(_0x598888){_0x2ba0b7[_0x0d40('0x43')]=_0x598888;return _0x2ba0b7;})['then'](respondWithFilteredResult(_0x17be00,_0x46833d,_0x0d40('0x4f')))[_0x0d40('0x44')](handleError(_0x17be00,null,_0x0d40('0x4f')));};