d85343925584a4b9362bb5076d79c1d124bc6f99
[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 _0x1486=['../../config/license/hardware','../../config/logger','api','../../config/license/util','redis','defaults','socket.io-emitter','./voiceQueueReport.socket','register','sendStatus','end','offset','undefined','limit','count','status','set','json','apply','reject','save','update','then','error','stack','name','index','map','VoiceQueueReport','fieldName','type','model','query','filters','intersection','fields','attributes','sort','pick','filter','where','merge','VIRTUAL','options','includeAll','findAll','catch','show','params','keys','rawAttributes','length','include','find','create','body','describe','getVoiceQueuesReport','hasOwnProperty','rows','eml-format','zip-dir','moment','mustache','util','sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch'];(function(_0x2e6aad,_0x23a607){var _0x4dce73=function(_0xa268ea){while(--_0xa268ea){_0x2e6aad['push'](_0x2e6aad['shift']());}};_0x4dce73(++_0x23a607);}(_0x1486,0x126));var _0x6148=function(_0x572660,_0x55c2b6){_0x572660=_0x572660-0x0;var _0x33da1d=_0x1486[_0x572660];return _0x33da1d;};'use strict';var emlformat=require(_0x6148('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x6148('0x1'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0x6148('0x2'));var BPromise=require('bluebird');var Mustache=require(_0x6148('0x3'));var util=require(_0x6148('0x4'));var path=require('path');var sox=require(_0x6148('0x5'));var csv=require(_0x6148('0x6'));var ejs=require(_0x6148('0x7'));var fs=require('fs');var fs_extra=require(_0x6148('0x8'));var _=require('lodash');var squel=require(_0x6148('0x9'));var crypto=require(_0x6148('0xa'));var jsforce=require(_0x6148('0xb'));var deskjs=require(_0x6148('0xc'));var toCsv=require(_0x6148('0x6'));var querystring=require('querystring');var Papa=require(_0x6148('0xd'));var Redis=require(_0x6148('0xe'));var authService=require(_0x6148('0xf'));var qs=require(_0x6148('0x10'));var as=require(_0x6148('0x11'));var hardwareService=require(_0x6148('0x12'));var logger=require(_0x6148('0x13'))(_0x6148('0x14'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0x6148('0x15'));var db=require('../../mysqldb')['db'];config[_0x6148('0x16')]=_[_0x6148('0x17')](config[_0x6148('0x16')],{'host':'localhost','port':0x18eb});var socket=require(_0x6148('0x18'))(new Redis(config[_0x6148('0x16')]));require(_0x6148('0x19'))[_0x6148('0x1a')](socket);function respondWithStatusCode(_0x48e5d4,_0x4c0c29){_0x4c0c29=_0x4c0c29||0xcc;return function(_0x54ad69){if(_0x54ad69){return _0x48e5d4[_0x6148('0x1b')](_0x4c0c29);}return _0x48e5d4['status'](_0x4c0c29)[_0x6148('0x1c')]();};}function respondWithResult(_0x5b6c97,_0x3fd79f){_0x3fd79f=_0x3fd79f||0xc8;return function(_0x3ab8f1){if(_0x3ab8f1){return _0x5b6c97['status'](_0x3fd79f)['json'](_0x3ab8f1);}};}function respondWithFilteredResult(_0x4634c1,_0x20a4e3){return function(_0x3a7d4c){if(_0x3a7d4c){var _0xfdac4a=typeof _0x20a4e3[_0x6148('0x1d')]===_0x6148('0x1e')&&typeof _0x20a4e3[_0x6148('0x1f')]===_0x6148('0x1e');var _0x438a1d=_0x3a7d4c[_0x6148('0x20')];var _0x52ec40=_0xfdac4a?0x0:_0x20a4e3[_0x6148('0x1d')];var _0x3d73aa=_0xfdac4a?_0x3a7d4c[_0x6148('0x20')]:_0x20a4e3[_0x6148('0x1d')]+_0x20a4e3[_0x6148('0x1f')];var _0x5b9e32;if(_0x3d73aa>=_0x438a1d){_0x3d73aa=_0x438a1d;_0x5b9e32=0xc8;}else{_0x5b9e32=0xce;}_0x4634c1[_0x6148('0x21')](_0x5b9e32);return _0x4634c1[_0x6148('0x22')]('Content-Range',_0x52ec40+'-'+_0x3d73aa+'/'+_0x438a1d)[_0x6148('0x23')](_0x3a7d4c);}return null;};}function patchUpdates(_0x3d42f8){return function(_0x337372){try{jsonpatch[_0x6148('0x24')](_0x337372,_0x3d42f8,!![]);}catch(_0x3c12ea){return BPromise[_0x6148('0x25')](_0x3c12ea);}return _0x337372[_0x6148('0x26')]();};}function saveUpdates(_0x484904,_0x12c28c){return function(_0x419a8d){if(_0x419a8d){return _0x419a8d[_0x6148('0x27')](_0x484904)[_0x6148('0x28')](function(_0x5c741a){return _0x5c741a;});}return null;};}function removeEntity(_0x63ed34,_0x1fd569){return function(_0x2647e3){if(_0x2647e3){return _0x2647e3['destroy']()[_0x6148('0x28')](function(){_0x63ed34[_0x6148('0x21')](0xcc)[_0x6148('0x1c')]();});}};}function handleEntityNotFound(_0x43e541,_0x4142e7){return function(_0x1ad30e){if(!_0x1ad30e){_0x43e541[_0x6148('0x1b')](0x194);}return _0x1ad30e;};}function handleError(_0x2e4ac1,_0x2f0fbe){_0x2f0fbe=_0x2f0fbe||0x1f4;return function(_0x22aaaa){logger[_0x6148('0x29')](_0x22aaaa[_0x6148('0x2a')]);if(_0x22aaaa[_0x6148('0x2b')]){delete _0x22aaaa[_0x6148('0x2b')];}_0x2e4ac1[_0x6148('0x21')](_0x2f0fbe)['send'](_0x22aaaa);};}exports[_0x6148('0x2c')]=function(_0x34c989,_0x277b4b){var _0x4bfece={},_0x7af64={},_0x158eaf={'count':0x0,'rows':[]};var _0x11da2a=_[_0x6148('0x2d')](db[_0x6148('0x2e')]['rawAttributes'],function(_0x4f8af7){return{'name':_0x4f8af7[_0x6148('0x2f')],'type':_0x4f8af7[_0x6148('0x30')]['key']};});_0x7af64[_0x6148('0x31')]=_['map'](_0x11da2a,_0x6148('0x2b'));_0x7af64[_0x6148('0x32')]=_['keys'](_0x34c989[_0x6148('0x32')]);_0x7af64[_0x6148('0x33')]=_[_0x6148('0x34')](_0x7af64[_0x6148('0x31')],_0x7af64[_0x6148('0x32')]);_0x4bfece['attributes']=_[_0x6148('0x34')](_0x7af64['model'],qs[_0x6148('0x35')](_0x34c989[_0x6148('0x32')][_0x6148('0x35')]));_0x4bfece['attributes']=_0x4bfece[_0x6148('0x36')]['length']?_0x4bfece[_0x6148('0x36')]:_0x7af64[_0x6148('0x31')];if(!_0x34c989['query']['hasOwnProperty']('nolimit')){_0x4bfece['limit']=qs[_0x6148('0x1f')](_0x34c989[_0x6148('0x32')][_0x6148('0x1f')]);_0x4bfece[_0x6148('0x1d')]=qs[_0x6148('0x1d')](_0x34c989[_0x6148('0x32')]['offset']);}_0x4bfece['order']=qs[_0x6148('0x37')](_0x34c989['query'][_0x6148('0x37')]);_0x4bfece['where']=qs[_0x6148('0x33')](_[_0x6148('0x38')](_0x34c989[_0x6148('0x32')],_0x7af64[_0x6148('0x33')]),_0x11da2a);if(_0x34c989['query'][_0x6148('0x39')]){_0x4bfece[_0x6148('0x3a')]=_[_0x6148('0x3b')](_0x4bfece[_0x6148('0x3a')],{'$or':_[_0x6148('0x2d')](_0x11da2a,function(_0x1d4d41){if(_0x1d4d41[_0x6148('0x30')]!==_0x6148('0x3c')){var _0x4305d8={};_0x4305d8[_0x1d4d41['name']]={'$like':'%'+_0x34c989[_0x6148('0x32')][_0x6148('0x39')]+'%'};return _0x4305d8;}})});}_0x4bfece=_[_0x6148('0x3b')]({},_0x4bfece,_0x34c989[_0x6148('0x3d')]);var _0x50eca2={'where':_0x4bfece['where']};return db[_0x6148('0x2e')][_0x6148('0x20')](_0x50eca2)[_0x6148('0x28')](function(_0x102764){_0x158eaf[_0x6148('0x20')]=_0x102764;if(_0x34c989[_0x6148('0x32')][_0x6148('0x3e')]){_0x4bfece['include']=[{'all':!![]}];}return db[_0x6148('0x2e')][_0x6148('0x3f')](_0x4bfece);})[_0x6148('0x28')](function(_0x6aeb50){_0x158eaf['rows']=_0x6aeb50;return _0x158eaf;})[_0x6148('0x28')](respondWithFilteredResult(_0x277b4b,_0x4bfece))[_0x6148('0x40')](handleError(_0x277b4b,null));};exports[_0x6148('0x41')]=function(_0x59260a,_0x317a3e){var _0x1eb5f5={'raw':![],'where':{'id':_0x59260a[_0x6148('0x42')]['id']}},_0x43821a={};_0x43821a[_0x6148('0x31')]=_[_0x6148('0x43')](db[_0x6148('0x2e')][_0x6148('0x44')]);_0x43821a['query']=_[_0x6148('0x43')](_0x59260a['query']);_0x43821a[_0x6148('0x33')]=_['intersection'](_0x43821a['model'],_0x43821a[_0x6148('0x32')]);_0x1eb5f5[_0x6148('0x36')]=_[_0x6148('0x34')](_0x43821a[_0x6148('0x31')],qs[_0x6148('0x35')](_0x59260a[_0x6148('0x32')]['fields']));_0x1eb5f5[_0x6148('0x36')]=_0x1eb5f5[_0x6148('0x36')][_0x6148('0x45')]?_0x1eb5f5['attributes']:_0x43821a['model'];if(_0x59260a['query'][_0x6148('0x3e')]){_0x1eb5f5[_0x6148('0x46')]=[{'all':!![]}];}_0x1eb5f5=_[_0x6148('0x3b')]({},_0x1eb5f5,_0x59260a['options']);return db['VoiceQueueReport'][_0x6148('0x47')](_0x1eb5f5)[_0x6148('0x28')](handleEntityNotFound(_0x317a3e,null))['then'](respondWithResult(_0x317a3e,null))['catch'](handleError(_0x317a3e,null));};exports[_0x6148('0x48')]=function(_0x1699f6,_0x3ce67f){return db['VoiceQueueReport'][_0x6148('0x48')](_0x1699f6[_0x6148('0x49')],{})[_0x6148('0x28')](respondWithResult(_0x3ce67f,0xc9))[_0x6148('0x40')](handleError(_0x3ce67f,null));};exports[_0x6148('0x27')]=function(_0x37535d,_0x4bd029){if(_0x37535d[_0x6148('0x49')]['id']){delete _0x37535d[_0x6148('0x49')]['id'];}return db[_0x6148('0x2e')][_0x6148('0x47')]({'where':{'id':_0x37535d[_0x6148('0x42')]['id']}})[_0x6148('0x28')](handleEntityNotFound(_0x4bd029,null))[_0x6148('0x28')](saveUpdates(_0x37535d['body'],null))[_0x6148('0x28')](respondWithResult(_0x4bd029,null))[_0x6148('0x40')](handleError(_0x4bd029,null));};exports['destroy']=function(_0x135f80,_0x2240e6){return db['VoiceQueueReport'][_0x6148('0x47')]({'where':{'id':_0x135f80[_0x6148('0x42')]['id']}})[_0x6148('0x28')](handleEntityNotFound(_0x2240e6,null))['then'](removeEntity(_0x2240e6,null))[_0x6148('0x40')](handleError(_0x2240e6,null));};exports[_0x6148('0x4a')]=function(_0xf90dc5,_0x4d4de9){return db['VoiceQueueReport'][_0x6148('0x4a')]()[_0x6148('0x28')](respondWithResult(_0x4d4de9,null))[_0x6148('0x40')](handleError(_0x4d4de9,null));};exports[_0x6148('0x4b')]=function(_0x1fe0e9,_0x5ab55c){var _0x173a21={},_0x51b6df={},_0xbd157a={'count':0x0,'rows':[]};_0x51b6df[_0x6148('0x31')]=_[_0x6148('0x43')](db[_0x6148('0x2e')]['rawAttributes']);_0x51b6df['query']=_[_0x6148('0x43')](_0x1fe0e9[_0x6148('0x32')]);_0x51b6df[_0x6148('0x33')]=_[_0x6148('0x34')](_0x51b6df[_0x6148('0x31')],_0x51b6df['query']);_0x173a21[_0x6148('0x36')]=_['intersection'](_0x51b6df[_0x6148('0x31')],qs[_0x6148('0x35')](_0x1fe0e9[_0x6148('0x32')][_0x6148('0x35')]));_0x173a21[_0x6148('0x36')]=_0x173a21[_0x6148('0x36')][_0x6148('0x45')]?_0x173a21[_0x6148('0x36')]:_0x51b6df[_0x6148('0x31')];if(!_0x1fe0e9[_0x6148('0x32')][_0x6148('0x4c')]('nolimit')){_0x173a21[_0x6148('0x1f')]=qs[_0x6148('0x1f')](_0x1fe0e9[_0x6148('0x32')][_0x6148('0x1f')]);_0x173a21['offset']=qs[_0x6148('0x1d')](_0x1fe0e9[_0x6148('0x32')][_0x6148('0x1d')]);}_0x173a21['order']=qs[_0x6148('0x37')](_0x1fe0e9[_0x6148('0x32')][_0x6148('0x37')]);_0x173a21[_0x6148('0x3a')]=qs[_0x6148('0x33')](_['pick'](_0x1fe0e9[_0x6148('0x32')],_0x51b6df[_0x6148('0x33')]));if(_0x1fe0e9[_0x6148('0x32')][_0x6148('0x39')]){_0x173a21[_0x6148('0x3a')]=_[_0x6148('0x3b')](_0x173a21[_0x6148('0x3a')],{'$or':_[_0x6148('0x2d')](_0x173a21[_0x6148('0x36')],function(_0x53c8ab){var _0x40adfe={};_0x40adfe[_0x53c8ab]={'$like':'%'+_0x1fe0e9['query']['filter']+'%'};return _0x40adfe;})});}_0x173a21=_['merge']({},_0x173a21,_0x1fe0e9[_0x6148('0x3d')]);var _0x423670={'where':_0x173a21[_0x6148('0x3a')]};return db['VoiceQueueReport'][_0x6148('0x20')](_0x423670)[_0x6148('0x28')](function(_0x490df4){_0xbd157a['count']=_0x490df4;if(_0x1fe0e9['query'][_0x6148('0x3e')]){_0x173a21[_0x6148('0x46')]=[{'all':!![]}];}return db[_0x6148('0x2e')][_0x6148('0x3f')](_0x173a21);})['then'](function(_0x3a8178){_0xbd157a[_0x6148('0x4d')]=_0x3a8178;return _0xbd157a;})[_0x6148('0x28')](respondWithFilteredResult(_0x5ab55c,_0x173a21,_0x6148('0x4b')))['catch'](handleError(_0x5ab55c,null,_0x6148('0x4b')));};