26f815304d4429232249d789fae020e9d2abb8ef
[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 _0x961b=['model','map','query','filters','attributes','intersection','fields','length','hasOwnProperty','order','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','include','findAll','catch','show','params','keys','rawAttributes','find','create','body','destroy','describe','getVoiceQueuesReport','nolimit','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','fs-extra','squel','crypto','jsforce','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../mysqldb','redis','defaults','localhost','socket.io-emitter','./voiceQueueReport.socket','sendStatus','status','end','json','limit','undefined','count','offset','set','Content-Range','apply','reject','save','update','then','error','stack','name','send','index','VoiceQueueReport','fieldName','type','key'];(function(_0x13f20b,_0x85d184){var _0x4f1fb4=function(_0x18c8e8){while(--_0x18c8e8){_0x13f20b['push'](_0x13f20b['shift']());}};_0x4f1fb4(++_0x85d184);}(_0x961b,0x1c4));var _0xb961=function(_0xd1d19a,_0x1933f0){_0xd1d19a=_0xd1d19a-0x0;var _0x52a79d=_0x961b[_0xd1d19a];return _0x52a79d;};'use strict';var emlformat=require(_0xb961('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xb961('0x1'));var jsonpatch=require(_0xb961('0x2'));var rp=require(_0xb961('0x3'));var moment=require(_0xb961('0x4'));var BPromise=require(_0xb961('0x5'));var Mustache=require(_0xb961('0x6'));var util=require(_0xb961('0x7'));var path=require(_0xb961('0x8'));var sox=require(_0xb961('0x9'));var csv=require(_0xb961('0xa'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xb961('0xb'));var _=require('lodash');var squel=require(_0xb961('0xc'));var crypto=require(_0xb961('0xd'));var jsforce=require(_0xb961('0xe'));var deskjs=require('desk.js');var toCsv=require(_0xb961('0xa'));var querystring=require(_0xb961('0xf'));var Papa=require(_0xb961('0x10'));var Redis=require('ioredis');var authService=require(_0xb961('0x11'));var qs=require(_0xb961('0x12'));var as=require(_0xb961('0x13'));var hardwareService=require(_0xb961('0x14'));var logger=require(_0xb961('0x15'))('api');var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0xb961('0x16'))['db'];config[_0xb961('0x17')]=_[_0xb961('0x18')](config[_0xb961('0x17')],{'host':_0xb961('0x19'),'port':0x18eb});var socket=require(_0xb961('0x1a'))(new Redis(config[_0xb961('0x17')]));require(_0xb961('0x1b'))['register'](socket);function respondWithStatusCode(_0xefe3b9,_0x1023ef){_0x1023ef=_0x1023ef||0xcc;return function(_0x3e3ea9){if(_0x3e3ea9){return _0xefe3b9[_0xb961('0x1c')](_0x1023ef);}return _0xefe3b9[_0xb961('0x1d')](_0x1023ef)[_0xb961('0x1e')]();};}function respondWithResult(_0x2ccba6,_0x548aed){_0x548aed=_0x548aed||0xc8;return function(_0x4231dd){if(_0x4231dd){return _0x2ccba6[_0xb961('0x1d')](_0x548aed)[_0xb961('0x1f')](_0x4231dd);}};}function respondWithFilteredResult(_0x3c719e,_0x25aeb2){return function(_0x2d355a){if(_0x2d355a){var _0x56cc2a=typeof _0x25aeb2['offset']==='undefined'&&typeof _0x25aeb2[_0xb961('0x20')]===_0xb961('0x21');var _0x1b7cf9=_0x2d355a[_0xb961('0x22')];var _0x2fcb63=_0x56cc2a?0x0:_0x25aeb2[_0xb961('0x23')];var _0x29fc9a=_0x56cc2a?_0x2d355a[_0xb961('0x22')]:_0x25aeb2[_0xb961('0x23')]+_0x25aeb2[_0xb961('0x20')];var _0x185f42;if(_0x29fc9a>=_0x1b7cf9){_0x29fc9a=_0x1b7cf9;_0x185f42=0xc8;}else{_0x185f42=0xce;}_0x3c719e[_0xb961('0x1d')](_0x185f42);return _0x3c719e[_0xb961('0x24')](_0xb961('0x25'),_0x2fcb63+'-'+_0x29fc9a+'/'+_0x1b7cf9)[_0xb961('0x1f')](_0x2d355a);}return null;};}function patchUpdates(_0x24bf8a){return function(_0x4d8538){try{jsonpatch[_0xb961('0x26')](_0x4d8538,_0x24bf8a,!![]);}catch(_0x367c0a){return BPromise[_0xb961('0x27')](_0x367c0a);}return _0x4d8538[_0xb961('0x28')]();};}function saveUpdates(_0x293663,_0xfe9bef){return function(_0x24ad9f){if(_0x24ad9f){return _0x24ad9f[_0xb961('0x29')](_0x293663)[_0xb961('0x2a')](function(_0x7e1edb){return _0x7e1edb;});}return null;};}function removeEntity(_0x23fcc9,_0x1892c1){return function(_0x12856e){if(_0x12856e){return _0x12856e['destroy']()[_0xb961('0x2a')](function(){_0x23fcc9[_0xb961('0x1d')](0xcc)[_0xb961('0x1e')]();});}};}function handleEntityNotFound(_0x31f37b,_0x2d7f5e){return function(_0x5a9b98){if(!_0x5a9b98){_0x31f37b[_0xb961('0x1c')](0x194);}return _0x5a9b98;};}function handleError(_0x5226b7,_0x205af1){_0x205af1=_0x205af1||0x1f4;return function(_0x53ea2){logger[_0xb961('0x2b')](_0x53ea2[_0xb961('0x2c')]);if(_0x53ea2['name']){delete _0x53ea2[_0xb961('0x2d')];}_0x5226b7[_0xb961('0x1d')](_0x205af1)[_0xb961('0x2e')](_0x53ea2);};}exports[_0xb961('0x2f')]=function(_0x38e099,_0x58d414){var _0x37c988={},_0x571618={},_0x8cd966={'count':0x0,'rows':[]};var _0x29bd2e=_['map'](db[_0xb961('0x30')]['rawAttributes'],function(_0x4b4a8e){return{'name':_0x4b4a8e[_0xb961('0x31')],'type':_0x4b4a8e[_0xb961('0x32')][_0xb961('0x33')]};});_0x571618[_0xb961('0x34')]=_[_0xb961('0x35')](_0x29bd2e,_0xb961('0x2d'));_0x571618[_0xb961('0x36')]=_['keys'](_0x38e099[_0xb961('0x36')]);_0x571618[_0xb961('0x37')]=_['intersection'](_0x571618['model'],_0x571618[_0xb961('0x36')]);_0x37c988[_0xb961('0x38')]=_[_0xb961('0x39')](_0x571618['model'],qs[_0xb961('0x3a')](_0x38e099[_0xb961('0x36')][_0xb961('0x3a')]));_0x37c988[_0xb961('0x38')]=_0x37c988['attributes'][_0xb961('0x3b')]?_0x37c988[_0xb961('0x38')]:_0x571618['model'];if(!_0x38e099[_0xb961('0x36')][_0xb961('0x3c')]('nolimit')){_0x37c988[_0xb961('0x20')]=qs[_0xb961('0x20')](_0x38e099[_0xb961('0x36')]['limit']);_0x37c988['offset']=qs['offset'](_0x38e099[_0xb961('0x36')][_0xb961('0x23')]);}_0x37c988[_0xb961('0x3d')]=qs[_0xb961('0x3e')](_0x38e099['query'][_0xb961('0x3e')]);_0x37c988[_0xb961('0x3f')]=qs['filters'](_[_0xb961('0x40')](_0x38e099[_0xb961('0x36')],_0x571618[_0xb961('0x37')]),_0x29bd2e);if(_0x38e099['query'][_0xb961('0x41')]){_0x37c988['where']=_[_0xb961('0x42')](_0x37c988[_0xb961('0x3f')],{'$or':_[_0xb961('0x35')](_0x29bd2e,function(_0x24136f){if(_0x24136f[_0xb961('0x32')]!==_0xb961('0x43')){var _0x438237={};_0x438237[_0x24136f[_0xb961('0x2d')]]={'$like':'%'+_0x38e099[_0xb961('0x36')]['filter']+'%'};return _0x438237;}})});}_0x37c988=_['merge']({},_0x37c988,_0x38e099[_0xb961('0x44')]);var _0x44e9f5={'where':_0x37c988[_0xb961('0x3f')]};return db[_0xb961('0x30')]['count'](_0x44e9f5)['then'](function(_0x192f42){_0x8cd966['count']=_0x192f42;if(_0x38e099[_0xb961('0x36')][_0xb961('0x45')]){_0x37c988[_0xb961('0x46')]=[{'all':!![]}];}return db['VoiceQueueReport'][_0xb961('0x47')](_0x37c988);})[_0xb961('0x2a')](function(_0x3b772c){_0x8cd966['rows']=_0x3b772c;return _0x8cd966;})[_0xb961('0x2a')](respondWithFilteredResult(_0x58d414,_0x37c988))[_0xb961('0x48')](handleError(_0x58d414,null));};exports[_0xb961('0x49')]=function(_0x1c64ff,_0x29744e){var _0x418c42={'raw':![],'where':{'id':_0x1c64ff[_0xb961('0x4a')]['id']}},_0x45ae1a={};_0x45ae1a[_0xb961('0x34')]=_[_0xb961('0x4b')](db[_0xb961('0x30')][_0xb961('0x4c')]);_0x45ae1a[_0xb961('0x36')]=_[_0xb961('0x4b')](_0x1c64ff[_0xb961('0x36')]);_0x45ae1a[_0xb961('0x37')]=_['intersection'](_0x45ae1a['model'],_0x45ae1a['query']);_0x418c42[_0xb961('0x38')]=_[_0xb961('0x39')](_0x45ae1a[_0xb961('0x34')],qs[_0xb961('0x3a')](_0x1c64ff[_0xb961('0x36')][_0xb961('0x3a')]));_0x418c42[_0xb961('0x38')]=_0x418c42[_0xb961('0x38')][_0xb961('0x3b')]?_0x418c42[_0xb961('0x38')]:_0x45ae1a[_0xb961('0x34')];if(_0x1c64ff[_0xb961('0x36')][_0xb961('0x45')]){_0x418c42[_0xb961('0x46')]=[{'all':!![]}];}_0x418c42=_[_0xb961('0x42')]({},_0x418c42,_0x1c64ff[_0xb961('0x44')]);return db[_0xb961('0x30')][_0xb961('0x4d')](_0x418c42)['then'](handleEntityNotFound(_0x29744e,null))[_0xb961('0x2a')](respondWithResult(_0x29744e,null))['catch'](handleError(_0x29744e,null));};exports[_0xb961('0x4e')]=function(_0x526bba,_0x385774){return db[_0xb961('0x30')][_0xb961('0x4e')](_0x526bba[_0xb961('0x4f')],{})[_0xb961('0x2a')](respondWithResult(_0x385774,0xc9))['catch'](handleError(_0x385774,null));};exports[_0xb961('0x29')]=function(_0x5f2eed,_0x401e0c){if(_0x5f2eed[_0xb961('0x4f')]['id']){delete _0x5f2eed[_0xb961('0x4f')]['id'];}return db['VoiceQueueReport'][_0xb961('0x4d')]({'where':{'id':_0x5f2eed[_0xb961('0x4a')]['id']}})[_0xb961('0x2a')](handleEntityNotFound(_0x401e0c,null))[_0xb961('0x2a')](saveUpdates(_0x5f2eed[_0xb961('0x4f')],null))[_0xb961('0x2a')](respondWithResult(_0x401e0c,null))[_0xb961('0x48')](handleError(_0x401e0c,null));};exports[_0xb961('0x50')]=function(_0x2a0131,_0x586acc){return db[_0xb961('0x30')][_0xb961('0x4d')]({'where':{'id':_0x2a0131[_0xb961('0x4a')]['id']}})[_0xb961('0x2a')](handleEntityNotFound(_0x586acc,null))['then'](removeEntity(_0x586acc,null))['catch'](handleError(_0x586acc,null));};exports[_0xb961('0x51')]=function(_0x212cbb,_0x558466){return db[_0xb961('0x30')][_0xb961('0x51')]()['then'](respondWithResult(_0x558466,null))[_0xb961('0x48')](handleError(_0x558466,null));};exports[_0xb961('0x52')]=function(_0x37480e,_0x50d80a){var _0x1dee8f={},_0xb1ce73={},_0x55760d={'count':0x0,'rows':[]};_0xb1ce73[_0xb961('0x34')]=_[_0xb961('0x4b')](db['VoiceQueueReport'][_0xb961('0x4c')]);_0xb1ce73['query']=_[_0xb961('0x4b')](_0x37480e['query']);_0xb1ce73[_0xb961('0x37')]=_[_0xb961('0x39')](_0xb1ce73[_0xb961('0x34')],_0xb1ce73[_0xb961('0x36')]);_0x1dee8f[_0xb961('0x38')]=_[_0xb961('0x39')](_0xb1ce73[_0xb961('0x34')],qs[_0xb961('0x3a')](_0x37480e[_0xb961('0x36')][_0xb961('0x3a')]));_0x1dee8f[_0xb961('0x38')]=_0x1dee8f[_0xb961('0x38')][_0xb961('0x3b')]?_0x1dee8f[_0xb961('0x38')]:_0xb1ce73[_0xb961('0x34')];if(!_0x37480e[_0xb961('0x36')][_0xb961('0x3c')](_0xb961('0x53'))){_0x1dee8f[_0xb961('0x20')]=qs[_0xb961('0x20')](_0x37480e['query'][_0xb961('0x20')]);_0x1dee8f[_0xb961('0x23')]=qs[_0xb961('0x23')](_0x37480e['query']['offset']);}_0x1dee8f['order']=qs[_0xb961('0x3e')](_0x37480e[_0xb961('0x36')]['sort']);_0x1dee8f[_0xb961('0x3f')]=qs['filters'](_[_0xb961('0x40')](_0x37480e[_0xb961('0x36')],_0xb1ce73[_0xb961('0x37')]));if(_0x37480e['query']['filter']){_0x1dee8f[_0xb961('0x3f')]=_[_0xb961('0x42')](_0x1dee8f[_0xb961('0x3f')],{'$or':_['map'](_0x1dee8f['attributes'],function(_0x20804c){var _0x2e4394={};_0x2e4394[_0x20804c]={'$like':'%'+_0x37480e[_0xb961('0x36')][_0xb961('0x41')]+'%'};return _0x2e4394;})});}_0x1dee8f=_[_0xb961('0x42')]({},_0x1dee8f,_0x37480e['options']);var _0x5725c0={'where':_0x1dee8f[_0xb961('0x3f')]};return db[_0xb961('0x30')][_0xb961('0x22')](_0x5725c0)[_0xb961('0x2a')](function(_0x59ddf3){_0x55760d[_0xb961('0x22')]=_0x59ddf3;if(_0x37480e[_0xb961('0x36')][_0xb961('0x45')]){_0x1dee8f['include']=[{'all':!![]}];}return db[_0xb961('0x30')][_0xb961('0x47')](_0x1dee8f);})[_0xb961('0x2a')](function(_0x3311be){_0x55760d['rows']=_0x3311be;return _0x55760d;})[_0xb961('0x2a')](respondWithFilteredResult(_0x50d80a,_0x1dee8f,'getVoiceQueuesReport'))['catch'](handleError(_0x50d80a,null,_0xb961('0x52')));};