server/api/chatQueueReport/chatQueueReport.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 _0x62b3=['index','map','ChatQueueReport','rawAttributes','fieldName','type','model','query','keys','filters','intersection','fields','attributes','hasOwnProperty','nolimit','order','sort','where','filter','VIRTUAL','includeAll','include','rows','catch','show','params','length','merge','options','find','create','body','destroy','describe','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','ejs','fs-extra','crypto','jsforce','desk.js','to-csv','querystring','ioredis','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','offset','undefined','limit','count','set','Content-Range','json','apply','reject','update','then','error','stack','name','send','message','agent','interaction','account'];(function(_0xc936fa,_0x5ac2a9){var _0x3c0609=function(_0x559b7f){while(--_0x559b7f){_0xc936fa['push'](_0xc936fa['shift']());}};_0x3c0609(++_0x5ac2a9);}(_0x62b3,0x16a));var _0x362b=function(_0x352f20,_0x2c7c0a){_0x352f20=_0x352f20-0x0;var _0x22b094=_0x62b3[_0x352f20];return _0x22b094;};'use strict';var emlformat=require(_0x362b('0x0'));var rimraf=require(_0x362b('0x1'));var zipdir=require(_0x362b('0x2'));var jsonpatch=require(_0x362b('0x3'));var rp=require(_0x362b('0x4'));var moment=require(_0x362b('0x5'));var BPromise=require(_0x362b('0x6'));var Mustache=require(_0x362b('0x7'));var util=require(_0x362b('0x8'));var path=require(_0x362b('0x9'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x362b('0xa'));var fs=require('fs');var fs_extra=require(_0x362b('0xb'));var _=require('lodash');var squel=require('squel');var crypto=require(_0x362b('0xc'));var jsforce=require(_0x362b('0xd'));var deskjs=require(_0x362b('0xe'));var toCsv=require(_0x362b('0xf'));var querystring=require(_0x362b('0x10'));var Papa=require('papaparse');var Redis=require(_0x362b('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x362b('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x362b('0x13'));var logger=require(_0x362b('0x14'))(_0x362b('0x15'));var utils=require(_0x362b('0x16'));var config=require(_0x362b('0x17'));var licenseUtil=require(_0x362b('0x18'));var db=require(_0x362b('0x19'))['db'];function respondWithStatusCode(_0x34842a,_0x3b2471){_0x3b2471=_0x3b2471||0xcc;return function(_0x1ce03d){if(_0x1ce03d){return _0x34842a[_0x362b('0x1a')](_0x3b2471);}return _0x34842a[_0x362b('0x1b')](_0x3b2471)[_0x362b('0x1c')]();};}function respondWithResult(_0x22af7a,_0x3307ff){_0x3307ff=_0x3307ff||0xc8;return function(_0x219b6d){if(_0x219b6d){return _0x22af7a[_0x362b('0x1b')](_0x3307ff)['json'](_0x219b6d);}};}function respondWithFilteredResult(_0x45fa99,_0x1ba00a){return function(_0xa20e3){if(_0xa20e3){var _0x58d07c=typeof _0x1ba00a[_0x362b('0x1d')]===_0x362b('0x1e')&&typeof _0x1ba00a[_0x362b('0x1f')]==='undefined';var _0x2149d6=_0xa20e3[_0x362b('0x20')];var _0x4dc721=_0x58d07c?0x0:_0x1ba00a[_0x362b('0x1d')];var _0x29c145=_0x58d07c?_0xa20e3['count']:_0x1ba00a['offset']+_0x1ba00a[_0x362b('0x1f')];var _0x1eed33;if(_0x29c145>=_0x2149d6){_0x29c145=_0x2149d6;_0x1eed33=0xc8;}else{_0x1eed33=0xce;}_0x45fa99[_0x362b('0x1b')](_0x1eed33);return _0x45fa99[_0x362b('0x21')](_0x362b('0x22'),_0x4dc721+'-'+_0x29c145+'/'+_0x2149d6)[_0x362b('0x23')](_0xa20e3);}return null;};}function patchUpdates(_0x36ecf2){return function(_0x5df526){try{jsonpatch[_0x362b('0x24')](_0x5df526,_0x36ecf2,!![]);}catch(_0x497875){return BPromise[_0x362b('0x25')](_0x497875);}return _0x5df526['save']();};}function saveUpdates(_0x1f2b5d,_0x1a72f2){return function(_0x57e2bf){if(_0x57e2bf){return _0x57e2bf[_0x362b('0x26')](_0x1f2b5d)[_0x362b('0x27')](function(_0x599fde){return _0x599fde;});}return null;};}function removeEntity(_0x475f22,_0xf24ab){return function(_0x5781ed){if(_0x5781ed){return _0x5781ed['destroy']()[_0x362b('0x27')](function(){_0x475f22['status'](0xcc)[_0x362b('0x1c')]();});}};}function handleEntityNotFound(_0x53b44c,_0x3dfdb7){return function(_0x124bc7){if(!_0x124bc7){_0x53b44c['sendStatus'](0x194);}return _0x124bc7;};}function handleError(_0x31e298,_0x13ce72){_0x13ce72=_0x13ce72||0x1f4;return function(_0x3b7f62){logger[_0x362b('0x28')](_0x3b7f62[_0x362b('0x29')]);if(_0x3b7f62[_0x362b('0x2a')]){delete _0x3b7f62[_0x362b('0x2a')];}_0x31e298[_0x362b('0x1b')](_0x13ce72)[_0x362b('0x2b')](_0x3b7f62);};}function getMustacheRender(_0x18e14b,_0x5eb1d9){return Mustache['render'](_0x18e14b,_['merge'](_0x5eb1d9['body'],{'contact':_0x5eb1d9['contact'],'message':_0x5eb1d9[_0x362b('0x2c')],'agent':_0x5eb1d9[_0x362b('0x2d')],'interaction':_0x5eb1d9[_0x362b('0x2e')],'account':_0x5eb1d9[_0x362b('0x2f')]}))||'';}exports[_0x362b('0x30')]=function(_0x39b01d,_0x59beba){var _0x2744c5={},_0x22f11b={},_0x3b2289={'count':0x0,'rows':[]};var _0x5ada9a=_[_0x362b('0x31')](db[_0x362b('0x32')][_0x362b('0x33')],function(_0x56694e){return{'name':_0x56694e[_0x362b('0x34')],'type':_0x56694e[_0x362b('0x35')]['key']};});_0x22f11b[_0x362b('0x36')]=_[_0x362b('0x31')](_0x5ada9a,'name');_0x22f11b[_0x362b('0x37')]=_[_0x362b('0x38')](_0x39b01d['query']);_0x22f11b[_0x362b('0x39')]=_['intersection'](_0x22f11b[_0x362b('0x36')],_0x22f11b[_0x362b('0x37')]);_0x2744c5['attributes']=_[_0x362b('0x3a')](_0x22f11b['model'],qs[_0x362b('0x3b')](_0x39b01d['query'][_0x362b('0x3b')]));_0x2744c5[_0x362b('0x3c')]=_0x2744c5['attributes']['length']?_0x2744c5['attributes']:_0x22f11b[_0x362b('0x36')];if(!_0x39b01d['query'][_0x362b('0x3d')](_0x362b('0x3e'))){_0x2744c5['limit']=qs[_0x362b('0x1f')](_0x39b01d[_0x362b('0x37')][_0x362b('0x1f')]);_0x2744c5[_0x362b('0x1d')]=qs[_0x362b('0x1d')](_0x39b01d['query'][_0x362b('0x1d')]);}_0x2744c5[_0x362b('0x3f')]=qs['sort'](_0x39b01d[_0x362b('0x37')][_0x362b('0x40')]);_0x2744c5[_0x362b('0x41')]=qs['filters'](_['pick'](_0x39b01d[_0x362b('0x37')],_0x22f11b[_0x362b('0x39')]),_0x5ada9a);if(_0x39b01d[_0x362b('0x37')][_0x362b('0x42')]){_0x2744c5[_0x362b('0x41')]=_['merge'](_0x2744c5[_0x362b('0x41')],{'$or':_['map'](_0x5ada9a,function(_0x58a9cd){if(_0x58a9cd[_0x362b('0x35')]!==_0x362b('0x43')){var _0xb286aa={};_0xb286aa[_0x58a9cd[_0x362b('0x2a')]]={'$like':'%'+_0x39b01d['query'][_0x362b('0x42')]+'%'};return _0xb286aa;}})});}_0x2744c5=_['merge']({},_0x2744c5,_0x39b01d['options']);var _0x2f4272={'where':_0x2744c5[_0x362b('0x41')]};return db[_0x362b('0x32')]['count'](_0x2f4272)[_0x362b('0x27')](function(_0x4b3b3c){_0x3b2289[_0x362b('0x20')]=_0x4b3b3c;if(_0x39b01d[_0x362b('0x37')][_0x362b('0x44')]){_0x2744c5[_0x362b('0x45')]=[{'all':!![]}];}return db[_0x362b('0x32')]['findAll'](_0x2744c5);})[_0x362b('0x27')](function(_0x2c8b04){_0x3b2289[_0x362b('0x46')]=_0x2c8b04;return _0x3b2289;})[_0x362b('0x27')](respondWithFilteredResult(_0x59beba,_0x2744c5))[_0x362b('0x47')](handleError(_0x59beba,null));};exports[_0x362b('0x48')]=function(_0x3dfd20,_0x19e17f){var _0x5bdd27={'raw':!![],'where':{'id':_0x3dfd20[_0x362b('0x49')]['id']}},_0x536c94={};_0x536c94[_0x362b('0x36')]=_[_0x362b('0x38')](db[_0x362b('0x32')][_0x362b('0x33')]);_0x536c94[_0x362b('0x37')]=_[_0x362b('0x38')](_0x3dfd20[_0x362b('0x37')]);_0x536c94[_0x362b('0x39')]=_['intersection'](_0x536c94[_0x362b('0x36')],_0x536c94[_0x362b('0x37')]);_0x5bdd27['attributes']=_[_0x362b('0x3a')](_0x536c94[_0x362b('0x36')],qs[_0x362b('0x3b')](_0x3dfd20[_0x362b('0x37')][_0x362b('0x3b')]));_0x5bdd27[_0x362b('0x3c')]=_0x5bdd27[_0x362b('0x3c')][_0x362b('0x4a')]?_0x5bdd27[_0x362b('0x3c')]:_0x536c94[_0x362b('0x36')];if(_0x3dfd20['query'][_0x362b('0x44')]){_0x5bdd27[_0x362b('0x45')]=[{'all':!![]}];}_0x5bdd27=_[_0x362b('0x4b')]({},_0x5bdd27,_0x3dfd20[_0x362b('0x4c')]);return db[_0x362b('0x32')][_0x362b('0x4d')](_0x5bdd27)[_0x362b('0x27')](handleEntityNotFound(_0x19e17f,null))[_0x362b('0x27')](respondWithResult(_0x19e17f,null))[_0x362b('0x47')](handleError(_0x19e17f,null));};exports[_0x362b('0x4e')]=function(_0x49ac63,_0x2b9530){return db[_0x362b('0x32')][_0x362b('0x4e')](_0x49ac63[_0x362b('0x4f')],{})[_0x362b('0x27')](respondWithResult(_0x2b9530,0xc9))['catch'](handleError(_0x2b9530,null));};exports[_0x362b('0x26')]=function(_0x2477ec,_0x54d98a){if(_0x2477ec['body']['id']){delete _0x2477ec[_0x362b('0x4f')]['id'];}return db[_0x362b('0x32')]['find']({'where':{'id':_0x2477ec[_0x362b('0x49')]['id']}})[_0x362b('0x27')](handleEntityNotFound(_0x54d98a,null))[_0x362b('0x27')](saveUpdates(_0x2477ec[_0x362b('0x4f')],null))[_0x362b('0x27')](respondWithResult(_0x54d98a,null))['catch'](handleError(_0x54d98a,null));};exports[_0x362b('0x50')]=function(_0x27f6c5,_0x53d3de){return db[_0x362b('0x32')]['find']({'where':{'id':_0x27f6c5['params']['id']}})[_0x362b('0x27')](handleEntityNotFound(_0x53d3de,null))[_0x362b('0x27')](removeEntity(_0x53d3de,null))[_0x362b('0x47')](handleError(_0x53d3de,null));};exports[_0x362b('0x51')]=function(_0x297aa5,_0x59984f){return db['ChatQueueReport'][_0x362b('0x51')]()[_0x362b('0x27')](respondWithResult(_0x59984f,null))['catch'](handleError(_0x59984f,null));};