Built motion from commit da617fac.|2.6.6
[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 _0x62ce=['ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','defaults','localhost','socket.io-emitter','redis','./voiceQueueReport.socket','register','sendStatus','status','end','json','offset','undefined','count','limit','set','Content-Range','reject','save','then','error','stack','send','index','map','VoiceQueueReport','rawAttributes','fieldName','model','name','query','keys','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','type','VIRTUAL','includeAll','findAll','rows','catch','show','include','options','create','body','update','params','destroy','find','describe','getVoiceQueuesReport','eml-format','rimraf','fast-json-patch','request-promise','moment','path','to-csv','ejs','fs-extra','crypto','jsforce','desk.js','querystring','papaparse'];(function(_0x13c976,_0x57216f){var _0x342f1f=function(_0xffe87d){while(--_0xffe87d){_0x13c976['push'](_0x13c976['shift']());}};_0x342f1f(++_0x57216f);}(_0x62ce,0xee));var _0xe62c=function(_0x1facfa,_0x1acf7d){_0x1facfa=_0x1facfa-0x0;var _0x9ec701=_0x62ce[_0x1facfa];return _0x9ec701;};'use strict';var emlformat=require(_0xe62c('0x0'));var rimraf=require(_0xe62c('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xe62c('0x2'));var rp=require(_0xe62c('0x3'));var moment=require(_0xe62c('0x4'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require('util');var path=require(_0xe62c('0x5'));var sox=require('sox');var csv=require(_0xe62c('0x6'));var ejs=require(_0xe62c('0x7'));var fs=require('fs');var fs_extra=require(_0xe62c('0x8'));var _=require('lodash');var squel=require('squel');var crypto=require(_0xe62c('0x9'));var jsforce=require(_0xe62c('0xa'));var deskjs=require(_0xe62c('0xb'));var toCsv=require(_0xe62c('0x6'));var querystring=require(_0xe62c('0xc'));var Papa=require(_0xe62c('0xd'));var Redis=require(_0xe62c('0xe'));var authService=require(_0xe62c('0xf'));var qs=require('../../components/parsers/qs');var as=require(_0xe62c('0x10'));var hardwareService=require(_0xe62c('0x11'));var logger=require(_0xe62c('0x12'))('api');var utils=require(_0xe62c('0x13'));var config=require(_0xe62c('0x14'));var licenseUtil=require(_0xe62c('0x15'));var db=require(_0xe62c('0x16'))['db'];config['redis']=_[_0xe62c('0x17')](config['redis'],{'host':_0xe62c('0x18'),'port':0x18eb});var socket=require(_0xe62c('0x19'))(new Redis(config[_0xe62c('0x1a')]));require(_0xe62c('0x1b'))[_0xe62c('0x1c')](socket);function respondWithStatusCode(_0x20c611,_0x58cde4){_0x58cde4=_0x58cde4||0xcc;return function(_0xbd7f9a){if(_0xbd7f9a){return _0x20c611[_0xe62c('0x1d')](_0x58cde4);}return _0x20c611[_0xe62c('0x1e')](_0x58cde4)[_0xe62c('0x1f')]();};}function respondWithResult(_0x4a1748,_0x50a710){_0x50a710=_0x50a710||0xc8;return function(_0x5271c2){if(_0x5271c2){return _0x4a1748[_0xe62c('0x1e')](_0x50a710)[_0xe62c('0x20')](_0x5271c2);}};}function respondWithFilteredResult(_0x2632f8,_0x1f2667){return function(_0x19139f){if(_0x19139f){var _0x2ee697=typeof _0x1f2667[_0xe62c('0x21')]===_0xe62c('0x22')&&typeof _0x1f2667['limit']===_0xe62c('0x22');var _0x58c391=_0x19139f['count'];var _0x1ca7b3=_0x2ee697?0x0:_0x1f2667[_0xe62c('0x21')];var _0x246a3e=_0x2ee697?_0x19139f[_0xe62c('0x23')]:_0x1f2667[_0xe62c('0x21')]+_0x1f2667[_0xe62c('0x24')];var _0x2fdfd7;if(_0x246a3e>=_0x58c391){_0x246a3e=_0x58c391;_0x2fdfd7=0xc8;}else{_0x2fdfd7=0xce;}_0x2632f8[_0xe62c('0x1e')](_0x2fdfd7);return _0x2632f8[_0xe62c('0x25')](_0xe62c('0x26'),_0x1ca7b3+'-'+_0x246a3e+'/'+_0x58c391)['json'](_0x19139f);}return null;};}function patchUpdates(_0x5b5839){return function(_0x141cb5){try{jsonpatch['apply'](_0x141cb5,_0x5b5839,!![]);}catch(_0x1bf239){return BPromise[_0xe62c('0x27')](_0x1bf239);}return _0x141cb5[_0xe62c('0x28')]();};}function saveUpdates(_0x4a5e17,_0x368057){return function(_0x321b90){if(_0x321b90){return _0x321b90['update'](_0x4a5e17)[_0xe62c('0x29')](function(_0x5c79ca){return _0x5c79ca;});}return null;};}function removeEntity(_0x4ad7c6,_0x26f748){return function(_0x5f3943){if(_0x5f3943){return _0x5f3943['destroy']()[_0xe62c('0x29')](function(){_0x4ad7c6[_0xe62c('0x1e')](0xcc)[_0xe62c('0x1f')]();});}};}function handleEntityNotFound(_0x322498,_0x367256){return function(_0x1a3cc6){if(!_0x1a3cc6){_0x322498['sendStatus'](0x194);}return _0x1a3cc6;};}function handleError(_0x13e955,_0x2584bf){_0x2584bf=_0x2584bf||0x1f4;return function(_0x225f5f){logger[_0xe62c('0x2a')](_0x225f5f[_0xe62c('0x2b')]);if(_0x225f5f['name']){delete _0x225f5f['name'];}_0x13e955['status'](_0x2584bf)[_0xe62c('0x2c')](_0x225f5f);};}exports[_0xe62c('0x2d')]=function(_0x2a70ff,_0x3ae083){var _0x23c6ed={},_0x455b1c={},_0x4b2c06={'count':0x0,'rows':[]};var _0x26dd68=_[_0xe62c('0x2e')](db[_0xe62c('0x2f')][_0xe62c('0x30')],function(_0x20364a){return{'name':_0x20364a[_0xe62c('0x31')],'type':_0x20364a['type']['key']};});_0x455b1c[_0xe62c('0x32')]=_[_0xe62c('0x2e')](_0x26dd68,_0xe62c('0x33'));_0x455b1c[_0xe62c('0x34')]=_[_0xe62c('0x35')](_0x2a70ff['query']);_0x455b1c[_0xe62c('0x36')]=_[_0xe62c('0x37')](_0x455b1c['model'],_0x455b1c[_0xe62c('0x34')]);_0x23c6ed['attributes']=_['intersection'](_0x455b1c['model'],qs['fields'](_0x2a70ff['query'][_0xe62c('0x38')]));_0x23c6ed[_0xe62c('0x39')]=_0x23c6ed['attributes'][_0xe62c('0x3a')]?_0x23c6ed[_0xe62c('0x39')]:_0x455b1c[_0xe62c('0x32')];if(!_0x2a70ff['query'][_0xe62c('0x3b')](_0xe62c('0x3c'))){_0x23c6ed[_0xe62c('0x24')]=qs[_0xe62c('0x24')](_0x2a70ff[_0xe62c('0x34')]['limit']);_0x23c6ed['offset']=qs[_0xe62c('0x21')](_0x2a70ff['query']['offset']);}_0x23c6ed[_0xe62c('0x3d')]=qs[_0xe62c('0x3e')](_0x2a70ff[_0xe62c('0x34')][_0xe62c('0x3e')]);_0x23c6ed[_0xe62c('0x3f')]=qs[_0xe62c('0x36')](_[_0xe62c('0x40')](_0x2a70ff[_0xe62c('0x34')],_0x455b1c['filters']),_0x26dd68);if(_0x2a70ff[_0xe62c('0x34')][_0xe62c('0x41')]){_0x23c6ed[_0xe62c('0x3f')]=_[_0xe62c('0x42')](_0x23c6ed['where'],{'$or':_['map'](_0x26dd68,function(_0x2be2ee){if(_0x2be2ee[_0xe62c('0x43')]!==_0xe62c('0x44')){var _0x2605fd={};_0x2605fd[_0x2be2ee[_0xe62c('0x33')]]={'$like':'%'+_0x2a70ff[_0xe62c('0x34')][_0xe62c('0x41')]+'%'};return _0x2605fd;}})});}_0x23c6ed=_[_0xe62c('0x42')]({},_0x23c6ed,_0x2a70ff['options']);var _0x4b83b0={'where':_0x23c6ed[_0xe62c('0x3f')]};return db[_0xe62c('0x2f')][_0xe62c('0x23')](_0x4b83b0)['then'](function(_0x37489f){_0x4b2c06[_0xe62c('0x23')]=_0x37489f;if(_0x2a70ff[_0xe62c('0x34')][_0xe62c('0x45')]){_0x23c6ed['include']=[{'all':!![]}];}return db[_0xe62c('0x2f')][_0xe62c('0x46')](_0x23c6ed);})[_0xe62c('0x29')](function(_0xcdbccd){_0x4b2c06[_0xe62c('0x47')]=_0xcdbccd;return _0x4b2c06;})['then'](respondWithFilteredResult(_0x3ae083,_0x23c6ed))[_0xe62c('0x48')](handleError(_0x3ae083,null));};exports[_0xe62c('0x49')]=function(_0x16258c,_0xd90b1f){var _0x38aab3={'raw':![],'where':{'id':_0x16258c['params']['id']}},_0x263c1a={};_0x263c1a[_0xe62c('0x32')]=_[_0xe62c('0x35')](db['VoiceQueueReport'][_0xe62c('0x30')]);_0x263c1a[_0xe62c('0x34')]=_['keys'](_0x16258c['query']);_0x263c1a[_0xe62c('0x36')]=_['intersection'](_0x263c1a['model'],_0x263c1a[_0xe62c('0x34')]);_0x38aab3[_0xe62c('0x39')]=_[_0xe62c('0x37')](_0x263c1a[_0xe62c('0x32')],qs[_0xe62c('0x38')](_0x16258c[_0xe62c('0x34')][_0xe62c('0x38')]));_0x38aab3['attributes']=_0x38aab3[_0xe62c('0x39')][_0xe62c('0x3a')]?_0x38aab3[_0xe62c('0x39')]:_0x263c1a[_0xe62c('0x32')];if(_0x16258c[_0xe62c('0x34')]['includeAll']){_0x38aab3[_0xe62c('0x4a')]=[{'all':!![]}];}_0x38aab3=_['merge']({},_0x38aab3,_0x16258c[_0xe62c('0x4b')]);return db[_0xe62c('0x2f')]['find'](_0x38aab3)[_0xe62c('0x29')](handleEntityNotFound(_0xd90b1f,null))['then'](respondWithResult(_0xd90b1f,null))[_0xe62c('0x48')](handleError(_0xd90b1f,null));};exports[_0xe62c('0x4c')]=function(_0x2b6a5c,_0x342ac1){return db['VoiceQueueReport']['create'](_0x2b6a5c[_0xe62c('0x4d')],{})[_0xe62c('0x29')](respondWithResult(_0x342ac1,0xc9))[_0xe62c('0x48')](handleError(_0x342ac1,null));};exports[_0xe62c('0x4e')]=function(_0x145115,_0x28b6e5){if(_0x145115['body']['id']){delete _0x145115[_0xe62c('0x4d')]['id'];}return db[_0xe62c('0x2f')]['find']({'where':{'id':_0x145115[_0xe62c('0x4f')]['id']}})['then'](handleEntityNotFound(_0x28b6e5,null))['then'](saveUpdates(_0x145115['body'],null))[_0xe62c('0x29')](respondWithResult(_0x28b6e5,null))[_0xe62c('0x48')](handleError(_0x28b6e5,null));};exports[_0xe62c('0x50')]=function(_0x41f394,_0x141f4a){return db[_0xe62c('0x2f')][_0xe62c('0x51')]({'where':{'id':_0x41f394['params']['id']}})[_0xe62c('0x29')](handleEntityNotFound(_0x141f4a,null))[_0xe62c('0x29')](removeEntity(_0x141f4a,null))['catch'](handleError(_0x141f4a,null));};exports['describe']=function(_0x4b4065,_0x538a3f){return db['VoiceQueueReport'][_0xe62c('0x52')]()[_0xe62c('0x29')](respondWithResult(_0x538a3f,null))[_0xe62c('0x48')](handleError(_0x538a3f,null));};exports['getVoiceQueuesReport']=function(_0x21c881,_0x416a09){var _0x11b599={},_0x423678={},_0x161a43={'count':0x0,'rows':[]};_0x423678[_0xe62c('0x32')]=_[_0xe62c('0x35')](db[_0xe62c('0x2f')]['rawAttributes']);_0x423678[_0xe62c('0x34')]=_[_0xe62c('0x35')](_0x21c881[_0xe62c('0x34')]);_0x423678[_0xe62c('0x36')]=_[_0xe62c('0x37')](_0x423678[_0xe62c('0x32')],_0x423678[_0xe62c('0x34')]);_0x11b599[_0xe62c('0x39')]=_[_0xe62c('0x37')](_0x423678[_0xe62c('0x32')],qs[_0xe62c('0x38')](_0x21c881[_0xe62c('0x34')][_0xe62c('0x38')]));_0x11b599[_0xe62c('0x39')]=_0x11b599[_0xe62c('0x39')][_0xe62c('0x3a')]?_0x11b599['attributes']:_0x423678[_0xe62c('0x32')];if(!_0x21c881[_0xe62c('0x34')]['hasOwnProperty'](_0xe62c('0x3c'))){_0x11b599['limit']=qs[_0xe62c('0x24')](_0x21c881[_0xe62c('0x34')][_0xe62c('0x24')]);_0x11b599[_0xe62c('0x21')]=qs[_0xe62c('0x21')](_0x21c881[_0xe62c('0x34')]['offset']);}_0x11b599['order']=qs[_0xe62c('0x3e')](_0x21c881[_0xe62c('0x34')][_0xe62c('0x3e')]);_0x11b599[_0xe62c('0x3f')]=qs[_0xe62c('0x36')](_['pick'](_0x21c881[_0xe62c('0x34')],_0x423678[_0xe62c('0x36')]));if(_0x21c881[_0xe62c('0x34')]['filter']){_0x11b599[_0xe62c('0x3f')]=_[_0xe62c('0x42')](_0x11b599['where'],{'$or':_[_0xe62c('0x2e')](_0x11b599['attributes'],function(_0x285fbf){var _0x3aa08b={};_0x3aa08b[_0x285fbf]={'$like':'%'+_0x21c881['query'][_0xe62c('0x41')]+'%'};return _0x3aa08b;})});}_0x11b599=_[_0xe62c('0x42')]({},_0x11b599,_0x21c881[_0xe62c('0x4b')]);var _0x11ad8d={'where':_0x11b599['where']};return db[_0xe62c('0x2f')][_0xe62c('0x23')](_0x11ad8d)[_0xe62c('0x29')](function(_0x18a240){_0x161a43['count']=_0x18a240;if(_0x21c881[_0xe62c('0x34')][_0xe62c('0x45')]){_0x11b599['include']=[{'all':!![]}];}return db[_0xe62c('0x2f')]['findAll'](_0x11b599);})[_0xe62c('0x29')](function(_0x13e022){_0x161a43['rows']=_0x13e022;return _0x161a43;})[_0xe62c('0x29')](respondWithFilteredResult(_0x416a09,_0x11b599,_0xe62c('0x53')))[_0xe62c('0x48')](handleError(_0x416a09,null,_0xe62c('0x53')));};