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 _0xca84=['filters','model','attributes','intersection','fields','length','hasOwnProperty','nolimit','order','sort','where','merge','VIRTUAL','includeAll','findAll','rows','catch','params','include','find','create','body','describe','eml-format','rimraf','zip-dir','request-promise','moment','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','desk.js','querystring','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','status','end','json','offset','undefined','limit','count','Content-Range','apply','reject','update','then','destroy','sendStatus','stack','name','send','index','map','ChatQueueReport','rawAttributes','fieldName','type','key','query','keys'];(function(_0x227954,_0x1a4dd1){var _0xe547f2=function(_0x3d77e4){while(--_0x3d77e4){_0x227954['push'](_0x227954['shift']());}};_0xe547f2(++_0x1a4dd1);}(_0xca84,0xf5));var _0x4ca8=function(_0x381b64,_0x4ba9d9){_0x381b64=_0x381b64-0x0;var _0x1cfc83=_0xca84[_0x381b64];return _0x1cfc83;};'use strict';var emlformat=require(_0x4ca8('0x0'));var rimraf=require(_0x4ca8('0x1'));var zipdir=require(_0x4ca8('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x4ca8('0x3'));var moment=require(_0x4ca8('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x4ca8('0x5'));var util=require(_0x4ca8('0x6'));var path=require(_0x4ca8('0x7'));var sox=require(_0x4ca8('0x8'));var csv=require(_0x4ca8('0x9'));var ejs=require(_0x4ca8('0xa'));var fs=require('fs');var fs_extra=require(_0x4ca8('0xb'));var _=require(_0x4ca8('0xc'));var squel=require(_0x4ca8('0xd'));var crypto=require(_0x4ca8('0xe'));var jsforce=require('jsforce');var deskjs=require(_0x4ca8('0xf'));var toCsv=require('to-csv');var querystring=require(_0x4ca8('0x10'));var Papa=require('papaparse');var Redis=require(_0x4ca8('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x4ca8('0x12'));var as=require(_0x4ca8('0x13'));var hardwareService=require(_0x4ca8('0x14'));var logger=require(_0x4ca8('0x15'))(_0x4ca8('0x16'));var utils=require(_0x4ca8('0x17'));var config=require(_0x4ca8('0x18'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x4d58bf,_0x49f39e){_0x49f39e=_0x49f39e||0xcc;return function(_0x309286){if(_0x309286){return _0x4d58bf['sendStatus'](_0x49f39e);}return _0x4d58bf[_0x4ca8('0x19')](_0x49f39e)[_0x4ca8('0x1a')]();};}function respondWithResult(_0x522db3,_0x564518){_0x564518=_0x564518||0xc8;return function(_0xaf215e){if(_0xaf215e){return _0x522db3[_0x4ca8('0x19')](_0x564518)[_0x4ca8('0x1b')](_0xaf215e);}};}function respondWithFilteredResult(_0x770b5b,_0x379d8c){return function(_0x64c350){if(_0x64c350){var _0x342481=typeof _0x379d8c[_0x4ca8('0x1c')]===_0x4ca8('0x1d')&&typeof _0x379d8c[_0x4ca8('0x1e')]===_0x4ca8('0x1d');var _0x316b80=_0x64c350['count'];var _0xedd3=_0x342481?0x0:_0x379d8c[_0x4ca8('0x1c')];var _0x59e85b=_0x342481?_0x64c350[_0x4ca8('0x1f')]:_0x379d8c[_0x4ca8('0x1c')]+_0x379d8c['limit'];var _0x23b57a;if(_0x59e85b>=_0x316b80){_0x59e85b=_0x316b80;_0x23b57a=0xc8;}else{_0x23b57a=0xce;}_0x770b5b[_0x4ca8('0x19')](_0x23b57a);return _0x770b5b['set'](_0x4ca8('0x20'),_0xedd3+'-'+_0x59e85b+'/'+_0x316b80)['json'](_0x64c350);}return null;};}function patchUpdates(_0x2764e4){return function(_0x2e8cb8){try{jsonpatch[_0x4ca8('0x21')](_0x2e8cb8,_0x2764e4,!![]);}catch(_0x838ff0){return BPromise[_0x4ca8('0x22')](_0x838ff0);}return _0x2e8cb8['save']();};}function saveUpdates(_0x273a4d,_0xf50050){return function(_0x354072){if(_0x354072){return _0x354072[_0x4ca8('0x23')](_0x273a4d)[_0x4ca8('0x24')](function(_0x4d090a){return _0x4d090a;});}return null;};}function removeEntity(_0x30b731,_0x3691e2){return function(_0x398ed4){if(_0x398ed4){return _0x398ed4[_0x4ca8('0x25')]()[_0x4ca8('0x24')](function(){_0x30b731['status'](0xcc)[_0x4ca8('0x1a')]();});}};}function handleEntityNotFound(_0x297341,_0xbe9bd4){return function(_0x5c150c){if(!_0x5c150c){_0x297341[_0x4ca8('0x26')](0x194);}return _0x5c150c;};}function handleError(_0x22f857,_0x8443c6){_0x8443c6=_0x8443c6||0x1f4;return function(_0x1f2231){logger['error'](_0x1f2231[_0x4ca8('0x27')]);if(_0x1f2231[_0x4ca8('0x28')]){delete _0x1f2231['name'];}_0x22f857[_0x4ca8('0x19')](_0x8443c6)[_0x4ca8('0x29')](_0x1f2231);};}exports[_0x4ca8('0x2a')]=function(_0x2735d1,_0x1eb599){var _0x5f1ce5={},_0xab2501={},_0x418c30={'count':0x0,'rows':[]};var _0x4d28a9=_[_0x4ca8('0x2b')](db[_0x4ca8('0x2c')][_0x4ca8('0x2d')],function(_0xe96d6c){return{'name':_0xe96d6c[_0x4ca8('0x2e')],'type':_0xe96d6c[_0x4ca8('0x2f')][_0x4ca8('0x30')]};});_0xab2501['model']=_[_0x4ca8('0x2b')](_0x4d28a9,_0x4ca8('0x28'));_0xab2501[_0x4ca8('0x31')]=_[_0x4ca8('0x32')](_0x2735d1[_0x4ca8('0x31')]);_0xab2501[_0x4ca8('0x33')]=_['intersection'](_0xab2501[_0x4ca8('0x34')],_0xab2501['query']);_0x5f1ce5[_0x4ca8('0x35')]=_[_0x4ca8('0x36')](_0xab2501[_0x4ca8('0x34')],qs[_0x4ca8('0x37')](_0x2735d1['query']['fields']));_0x5f1ce5[_0x4ca8('0x35')]=_0x5f1ce5['attributes'][_0x4ca8('0x38')]?_0x5f1ce5[_0x4ca8('0x35')]:_0xab2501[_0x4ca8('0x34')];if(!_0x2735d1[_0x4ca8('0x31')][_0x4ca8('0x39')](_0x4ca8('0x3a'))){_0x5f1ce5[_0x4ca8('0x1e')]=qs[_0x4ca8('0x1e')](_0x2735d1['query']['limit']);_0x5f1ce5['offset']=qs['offset'](_0x2735d1[_0x4ca8('0x31')]['offset']);}_0x5f1ce5[_0x4ca8('0x3b')]=qs[_0x4ca8('0x3c')](_0x2735d1[_0x4ca8('0x31')][_0x4ca8('0x3c')]);_0x5f1ce5[_0x4ca8('0x3d')]=qs[_0x4ca8('0x33')](_['pick'](_0x2735d1[_0x4ca8('0x31')],_0xab2501[_0x4ca8('0x33')]),_0x4d28a9);if(_0x2735d1[_0x4ca8('0x31')]['filter']){_0x5f1ce5[_0x4ca8('0x3d')]=_[_0x4ca8('0x3e')](_0x5f1ce5[_0x4ca8('0x3d')],{'$or':_[_0x4ca8('0x2b')](_0x4d28a9,function(_0x52bbc){if(_0x52bbc[_0x4ca8('0x2f')]!==_0x4ca8('0x3f')){var _0x2fd55a={};_0x2fd55a[_0x52bbc[_0x4ca8('0x28')]]={'$like':'%'+_0x2735d1[_0x4ca8('0x31')]['filter']+'%'};return _0x2fd55a;}})});}_0x5f1ce5=_[_0x4ca8('0x3e')]({},_0x5f1ce5,_0x2735d1['options']);var _0x516453={'where':_0x5f1ce5[_0x4ca8('0x3d')]};return db[_0x4ca8('0x2c')][_0x4ca8('0x1f')](_0x516453)[_0x4ca8('0x24')](function(_0x184845){_0x418c30['count']=_0x184845;if(_0x2735d1[_0x4ca8('0x31')][_0x4ca8('0x40')]){_0x5f1ce5['include']=[{'all':!![]}];}return db[_0x4ca8('0x2c')][_0x4ca8('0x41')](_0x5f1ce5);})[_0x4ca8('0x24')](function(_0xeaf988){_0x418c30[_0x4ca8('0x42')]=_0xeaf988;return _0x418c30;})[_0x4ca8('0x24')](respondWithFilteredResult(_0x1eb599,_0x5f1ce5))[_0x4ca8('0x43')](handleError(_0x1eb599,null));};exports['show']=function(_0x447df4,_0x2be5b5){var _0x4937f4={'raw':!![],'where':{'id':_0x447df4[_0x4ca8('0x44')]['id']}},_0x346fa1={};_0x346fa1[_0x4ca8('0x34')]=_[_0x4ca8('0x32')](db[_0x4ca8('0x2c')][_0x4ca8('0x2d')]);_0x346fa1['query']=_[_0x4ca8('0x32')](_0x447df4['query']);_0x346fa1[_0x4ca8('0x33')]=_['intersection'](_0x346fa1[_0x4ca8('0x34')],_0x346fa1[_0x4ca8('0x31')]);_0x4937f4[_0x4ca8('0x35')]=_['intersection'](_0x346fa1[_0x4ca8('0x34')],qs[_0x4ca8('0x37')](_0x447df4[_0x4ca8('0x31')][_0x4ca8('0x37')]));_0x4937f4[_0x4ca8('0x35')]=_0x4937f4[_0x4ca8('0x35')][_0x4ca8('0x38')]?_0x4937f4[_0x4ca8('0x35')]:_0x346fa1[_0x4ca8('0x34')];if(_0x447df4[_0x4ca8('0x31')][_0x4ca8('0x40')]){_0x4937f4[_0x4ca8('0x45')]=[{'all':!![]}];}_0x4937f4=_[_0x4ca8('0x3e')]({},_0x4937f4,_0x447df4['options']);return db['ChatQueueReport'][_0x4ca8('0x46')](_0x4937f4)['then'](handleEntityNotFound(_0x2be5b5,null))[_0x4ca8('0x24')](respondWithResult(_0x2be5b5,null))['catch'](handleError(_0x2be5b5,null));};exports[_0x4ca8('0x47')]=function(_0x31957f,_0x38df23){return db[_0x4ca8('0x2c')][_0x4ca8('0x47')](_0x31957f[_0x4ca8('0x48')],{})[_0x4ca8('0x24')](respondWithResult(_0x38df23,0xc9))[_0x4ca8('0x43')](handleError(_0x38df23,null));};exports[_0x4ca8('0x23')]=function(_0x4d71e4,_0x362329){if(_0x4d71e4[_0x4ca8('0x48')]['id']){delete _0x4d71e4['body']['id'];}return db[_0x4ca8('0x2c')][_0x4ca8('0x46')]({'where':{'id':_0x4d71e4[_0x4ca8('0x44')]['id']}})[_0x4ca8('0x24')](handleEntityNotFound(_0x362329,null))[_0x4ca8('0x24')](saveUpdates(_0x4d71e4[_0x4ca8('0x48')],null))[_0x4ca8('0x24')](respondWithResult(_0x362329,null))[_0x4ca8('0x43')](handleError(_0x362329,null));};exports[_0x4ca8('0x25')]=function(_0x1528c3,_0x2c6d71){return db[_0x4ca8('0x2c')][_0x4ca8('0x46')]({'where':{'id':_0x1528c3['params']['id']}})[_0x4ca8('0x24')](handleEntityNotFound(_0x2c6d71,null))[_0x4ca8('0x24')](removeEntity(_0x2c6d71,null))[_0x4ca8('0x43')](handleError(_0x2c6d71,null));};exports[_0x4ca8('0x49')]=function(_0xac9871,_0x24ea2f){return db[_0x4ca8('0x2c')][_0x4ca8('0x49')]()[_0x4ca8('0x24')](respondWithResult(_0x24ea2f,null))[_0x4ca8('0x43')](handleError(_0x24ea2f,null));};