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 _0xd9a8=['status','end','json','offset','undefined','count','limit','set','Content-Range','apply','save','update','then','destroy','error','stack','name','send','index','map','ChatQueueReport','rawAttributes','fieldName','type','key','model','keys','filters','intersection','query','attributes','fields','length','hasOwnProperty','nolimit','sort','where','pick','filter','merge','VIRTUAL','includeAll','findAll','params','find','catch','create','body','describe','eml-format','rimraf','zip-dir','request-promise','moment','util','path','sox','to-csv','ejs','lodash','squel','crypto','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','api','../../config/utils','../../config/license/util','../../mysqldb','sendStatus'];(function(_0x520d35,_0x5df6e5){var _0x59c2cc=function(_0xc71ebe){while(--_0xc71ebe){_0x520d35['push'](_0x520d35['shift']());}};_0x59c2cc(++_0x5df6e5);}(_0xd9a8,0xc3));var _0x8d9a=function(_0x2b51a9,_0x5b9092){_0x2b51a9=_0x2b51a9-0x0;var _0x2de139=_0xd9a8[_0x2b51a9];return _0x2de139;};'use strict';var emlformat=require(_0x8d9a('0x0'));var rimraf=require(_0x8d9a('0x1'));var zipdir=require(_0x8d9a('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x8d9a('0x3'));var moment=require(_0x8d9a('0x4'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x8d9a('0x5'));var path=require(_0x8d9a('0x6'));var sox=require(_0x8d9a('0x7'));var csv=require(_0x8d9a('0x8'));var ejs=require(_0x8d9a('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x8d9a('0xa'));var squel=require(_0x8d9a('0xb'));var crypto=require(_0x8d9a('0xc'));var jsforce=require('jsforce');var deskjs=require(_0x8d9a('0xd'));var toCsv=require(_0x8d9a('0x8'));var querystring=require(_0x8d9a('0xe'));var Papa=require('papaparse');var Redis=require(_0x8d9a('0xf'));var authService=require(_0x8d9a('0x10'));var qs=require(_0x8d9a('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x8d9a('0x12'));var logger=require('../../config/logger')(_0x8d9a('0x13'));var utils=require(_0x8d9a('0x14'));var config=require('../../config/environment');var licenseUtil=require(_0x8d9a('0x15'));var db=require(_0x8d9a('0x16'))['db'];function respondWithStatusCode(_0x4b200f,_0x63c291){_0x63c291=_0x63c291||0xcc;return function(_0x297911){if(_0x297911){return _0x4b200f[_0x8d9a('0x17')](_0x63c291);}return _0x4b200f[_0x8d9a('0x18')](_0x63c291)[_0x8d9a('0x19')]();};}function respondWithResult(_0x44443f,_0x3a18b8){_0x3a18b8=_0x3a18b8||0xc8;return function(_0x29ceeb){if(_0x29ceeb){return _0x44443f['status'](_0x3a18b8)[_0x8d9a('0x1a')](_0x29ceeb);}};}function respondWithFilteredResult(_0x36fd8c,_0x44f260){return function(_0x2bbee0){if(_0x2bbee0){var _0x2439db=typeof _0x44f260[_0x8d9a('0x1b')]==='undefined'&&typeof _0x44f260['limit']===_0x8d9a('0x1c');var _0x49202a=_0x2bbee0[_0x8d9a('0x1d')];var _0x374714=_0x2439db?0x0:_0x44f260['offset'];var _0x1cd883=_0x2439db?_0x2bbee0[_0x8d9a('0x1d')]:_0x44f260[_0x8d9a('0x1b')]+_0x44f260[_0x8d9a('0x1e')];var _0x56a730;if(_0x1cd883>=_0x49202a){_0x1cd883=_0x49202a;_0x56a730=0xc8;}else{_0x56a730=0xce;}_0x36fd8c[_0x8d9a('0x18')](_0x56a730);return _0x36fd8c[_0x8d9a('0x1f')](_0x8d9a('0x20'),_0x374714+'-'+_0x1cd883+'/'+_0x49202a)[_0x8d9a('0x1a')](_0x2bbee0);}return null;};}function patchUpdates(_0x4de98e){return function(_0x30c0f7){try{jsonpatch[_0x8d9a('0x21')](_0x30c0f7,_0x4de98e,!![]);}catch(_0x2fac0c){return BPromise['reject'](_0x2fac0c);}return _0x30c0f7[_0x8d9a('0x22')]();};}function saveUpdates(_0x4593be,_0xc6e7a){return function(_0xd36efd){if(_0xd36efd){return _0xd36efd[_0x8d9a('0x23')](_0x4593be)[_0x8d9a('0x24')](function(_0x401be0){return _0x401be0;});}return null;};}function removeEntity(_0x36185d,_0x80ea5a){return function(_0x33344b){if(_0x33344b){return _0x33344b[_0x8d9a('0x25')]()[_0x8d9a('0x24')](function(){_0x36185d[_0x8d9a('0x18')](0xcc)[_0x8d9a('0x19')]();});}};}function handleEntityNotFound(_0x522ace,_0x5e181e){return function(_0x3140f1){if(!_0x3140f1){_0x522ace[_0x8d9a('0x17')](0x194);}return _0x3140f1;};}function handleError(_0x574de9,_0x26c6f4){_0x26c6f4=_0x26c6f4||0x1f4;return function(_0x2b1752){logger[_0x8d9a('0x26')](_0x2b1752[_0x8d9a('0x27')]);if(_0x2b1752['name']){delete _0x2b1752[_0x8d9a('0x28')];}_0x574de9[_0x8d9a('0x18')](_0x26c6f4)[_0x8d9a('0x29')](_0x2b1752);};}exports[_0x8d9a('0x2a')]=function(_0x3fdd5e,_0xcc127c){var _0x4fcb3a={},_0x4f0471={},_0x86b1ef={'count':0x0,'rows':[]};var _0x24a7b7=_[_0x8d9a('0x2b')](db[_0x8d9a('0x2c')][_0x8d9a('0x2d')],function(_0x5e18df){return{'name':_0x5e18df[_0x8d9a('0x2e')],'type':_0x5e18df[_0x8d9a('0x2f')][_0x8d9a('0x30')]};});_0x4f0471[_0x8d9a('0x31')]=_['map'](_0x24a7b7,_0x8d9a('0x28'));_0x4f0471['query']=_[_0x8d9a('0x32')](_0x3fdd5e['query']);_0x4f0471[_0x8d9a('0x33')]=_[_0x8d9a('0x34')](_0x4f0471['model'],_0x4f0471[_0x8d9a('0x35')]);_0x4fcb3a[_0x8d9a('0x36')]=_[_0x8d9a('0x34')](_0x4f0471[_0x8d9a('0x31')],qs[_0x8d9a('0x37')](_0x3fdd5e[_0x8d9a('0x35')][_0x8d9a('0x37')]));_0x4fcb3a[_0x8d9a('0x36')]=_0x4fcb3a[_0x8d9a('0x36')][_0x8d9a('0x38')]?_0x4fcb3a[_0x8d9a('0x36')]:_0x4f0471[_0x8d9a('0x31')];if(!_0x3fdd5e[_0x8d9a('0x35')][_0x8d9a('0x39')](_0x8d9a('0x3a'))){_0x4fcb3a['limit']=qs[_0x8d9a('0x1e')](_0x3fdd5e[_0x8d9a('0x35')]['limit']);_0x4fcb3a[_0x8d9a('0x1b')]=qs[_0x8d9a('0x1b')](_0x3fdd5e[_0x8d9a('0x35')][_0x8d9a('0x1b')]);}_0x4fcb3a['order']=qs['sort'](_0x3fdd5e['query'][_0x8d9a('0x3b')]);_0x4fcb3a[_0x8d9a('0x3c')]=qs[_0x8d9a('0x33')](_[_0x8d9a('0x3d')](_0x3fdd5e[_0x8d9a('0x35')],_0x4f0471['filters']),_0x24a7b7);if(_0x3fdd5e['query'][_0x8d9a('0x3e')]){_0x4fcb3a['where']=_[_0x8d9a('0x3f')](_0x4fcb3a[_0x8d9a('0x3c')],{'$or':_['map'](_0x24a7b7,function(_0x488ced){if(_0x488ced[_0x8d9a('0x2f')]!==_0x8d9a('0x40')){var _0x4fb5e9={};_0x4fb5e9[_0x488ced[_0x8d9a('0x28')]]={'$like':'%'+_0x3fdd5e[_0x8d9a('0x35')][_0x8d9a('0x3e')]+'%'};return _0x4fb5e9;}})});}_0x4fcb3a=_[_0x8d9a('0x3f')]({},_0x4fcb3a,_0x3fdd5e['options']);var _0x10d3c2={'where':_0x4fcb3a['where']};return db[_0x8d9a('0x2c')][_0x8d9a('0x1d')](_0x10d3c2)[_0x8d9a('0x24')](function(_0x42e6ce){_0x86b1ef[_0x8d9a('0x1d')]=_0x42e6ce;if(_0x3fdd5e['query'][_0x8d9a('0x41')]){_0x4fcb3a['include']=[{'all':!![]}];}return db[_0x8d9a('0x2c')][_0x8d9a('0x42')](_0x4fcb3a);})[_0x8d9a('0x24')](function(_0x59c145){_0x86b1ef['rows']=_0x59c145;return _0x86b1ef;})['then'](respondWithFilteredResult(_0xcc127c,_0x4fcb3a))['catch'](handleError(_0xcc127c,null));};exports['show']=function(_0x239d3d,_0x3774d6){var _0x14320e={'raw':!![],'where':{'id':_0x239d3d[_0x8d9a('0x43')]['id']}},_0x2f6514={};_0x2f6514[_0x8d9a('0x31')]=_['keys'](db[_0x8d9a('0x2c')][_0x8d9a('0x2d')]);_0x2f6514[_0x8d9a('0x35')]=_[_0x8d9a('0x32')](_0x239d3d[_0x8d9a('0x35')]);_0x2f6514['filters']=_[_0x8d9a('0x34')](_0x2f6514[_0x8d9a('0x31')],_0x2f6514[_0x8d9a('0x35')]);_0x14320e[_0x8d9a('0x36')]=_[_0x8d9a('0x34')](_0x2f6514[_0x8d9a('0x31')],qs[_0x8d9a('0x37')](_0x239d3d[_0x8d9a('0x35')][_0x8d9a('0x37')]));_0x14320e['attributes']=_0x14320e[_0x8d9a('0x36')][_0x8d9a('0x38')]?_0x14320e[_0x8d9a('0x36')]:_0x2f6514['model'];if(_0x239d3d[_0x8d9a('0x35')]['includeAll']){_0x14320e['include']=[{'all':!![]}];}_0x14320e=_[_0x8d9a('0x3f')]({},_0x14320e,_0x239d3d['options']);return db[_0x8d9a('0x2c')][_0x8d9a('0x44')](_0x14320e)['then'](handleEntityNotFound(_0x3774d6,null))[_0x8d9a('0x24')](respondWithResult(_0x3774d6,null))[_0x8d9a('0x45')](handleError(_0x3774d6,null));};exports[_0x8d9a('0x46')]=function(_0xb416a5,_0x574506){return db[_0x8d9a('0x2c')][_0x8d9a('0x46')](_0xb416a5['body'],{})['then'](respondWithResult(_0x574506,0xc9))[_0x8d9a('0x45')](handleError(_0x574506,null));};exports[_0x8d9a('0x23')]=function(_0x47ed1f,_0x4b728d){if(_0x47ed1f[_0x8d9a('0x47')]['id']){delete _0x47ed1f[_0x8d9a('0x47')]['id'];}return db[_0x8d9a('0x2c')]['find']({'where':{'id':_0x47ed1f[_0x8d9a('0x43')]['id']}})[_0x8d9a('0x24')](handleEntityNotFound(_0x4b728d,null))[_0x8d9a('0x24')](saveUpdates(_0x47ed1f[_0x8d9a('0x47')],null))[_0x8d9a('0x24')](respondWithResult(_0x4b728d,null))[_0x8d9a('0x45')](handleError(_0x4b728d,null));};exports[_0x8d9a('0x25')]=function(_0x40aa95,_0x5f0115){return db[_0x8d9a('0x2c')][_0x8d9a('0x44')]({'where':{'id':_0x40aa95[_0x8d9a('0x43')]['id']}})[_0x8d9a('0x24')](handleEntityNotFound(_0x5f0115,null))[_0x8d9a('0x24')](removeEntity(_0x5f0115,null))[_0x8d9a('0x45')](handleError(_0x5f0115,null));};exports[_0x8d9a('0x48')]=function(_0x38719a,_0x30e04c){return db[_0x8d9a('0x2c')]['describe']()[_0x8d9a('0x24')](respondWithResult(_0x30e04c,null))['catch'](handleError(_0x30e04c,null));};