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 _0x1f2d=['sendStatus','status','end','offset','undefined','limit','count','set','Content-Range','json','apply','reject','save','error','stack','name','send','index','ChatQueueReport','fieldName','type','model','query','keys','filters','attributes','intersection','fields','length','hasOwnProperty','nolimit','sort','where','pick','filter','merge','map','VIRTUAL','options','then','include','findAll','catch','show','params','rawAttributes','create','update','body','find','destroy','describe','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../mysqldb'];(function(_0x164d5e,_0x3ce85d){var _0x442d46=function(_0x4dbfdb){while(--_0x4dbfdb){_0x164d5e['push'](_0x164d5e['shift']());}};_0x442d46(++_0x3ce85d);}(_0x1f2d,0x1c4));var _0xd1f2=function(_0x128443,_0x2fe025){_0x128443=_0x128443-0x0;var _0x1a4ce1=_0x1f2d[_0x128443];return _0x1a4ce1;};'use strict';var emlformat=require(_0xd1f2('0x0'));var rimraf=require(_0xd1f2('0x1'));var zipdir=require(_0xd1f2('0x2'));var jsonpatch=require(_0xd1f2('0x3'));var rp=require('request-promise');var moment=require(_0xd1f2('0x4'));var BPromise=require(_0xd1f2('0x5'));var Mustache=require(_0xd1f2('0x6'));var util=require(_0xd1f2('0x7'));var path=require(_0xd1f2('0x8'));var sox=require(_0xd1f2('0x9'));var csv=require(_0xd1f2('0xa'));var ejs=require(_0xd1f2('0xb'));var fs=require('fs');var fs_extra=require(_0xd1f2('0xc'));var _=require(_0xd1f2('0xd'));var squel=require(_0xd1f2('0xe'));var crypto=require(_0xd1f2('0xf'));var jsforce=require(_0xd1f2('0x10'));var deskjs=require(_0xd1f2('0x11'));var toCsv=require(_0xd1f2('0xa'));var querystring=require(_0xd1f2('0x12'));var Papa=require(_0xd1f2('0x13'));var Redis=require('ioredis');var authService=require(_0xd1f2('0x14'));var qs=require(_0xd1f2('0x15'));var as=require(_0xd1f2('0x16'));var hardwareService=require(_0xd1f2('0x17'));var logger=require('../../config/logger')(_0xd1f2('0x18'));var utils=require(_0xd1f2('0x19'));var config=require(_0xd1f2('0x1a'));var licenseUtil=require('../../config/license/util');var db=require(_0xd1f2('0x1b'))['db'];function respondWithStatusCode(_0x347eba,_0x2ef331){_0x2ef331=_0x2ef331||0xcc;return function(_0x1d09f6){if(_0x1d09f6){return _0x347eba[_0xd1f2('0x1c')](_0x2ef331);}return _0x347eba[_0xd1f2('0x1d')](_0x2ef331)[_0xd1f2('0x1e')]();};}function respondWithResult(_0x596a54,_0x4d71d1){_0x4d71d1=_0x4d71d1||0xc8;return function(_0x5a3c44){if(_0x5a3c44){return _0x596a54['status'](_0x4d71d1)['json'](_0x5a3c44);}};}function respondWithFilteredResult(_0x19eb09,_0x1e0226){return function(_0x20d25d){if(_0x20d25d){var _0x1bd6ac=typeof _0x1e0226[_0xd1f2('0x1f')]===_0xd1f2('0x20')&&typeof _0x1e0226[_0xd1f2('0x21')]==='undefined';var _0x2af2d8=_0x20d25d[_0xd1f2('0x22')];var _0x2cd4fa=_0x1bd6ac?0x0:_0x1e0226[_0xd1f2('0x1f')];var _0x1f05f4=_0x1bd6ac?_0x20d25d[_0xd1f2('0x22')]:_0x1e0226[_0xd1f2('0x1f')]+_0x1e0226['limit'];var _0x12343a;if(_0x1f05f4>=_0x2af2d8){_0x1f05f4=_0x2af2d8;_0x12343a=0xc8;}else{_0x12343a=0xce;}_0x19eb09[_0xd1f2('0x1d')](_0x12343a);return _0x19eb09[_0xd1f2('0x23')](_0xd1f2('0x24'),_0x2cd4fa+'-'+_0x1f05f4+'/'+_0x2af2d8)[_0xd1f2('0x25')](_0x20d25d);}return null;};}function patchUpdates(_0x40b992){return function(_0x2a666f){try{jsonpatch[_0xd1f2('0x26')](_0x2a666f,_0x40b992,!![]);}catch(_0x23250f){return BPromise[_0xd1f2('0x27')](_0x23250f);}return _0x2a666f[_0xd1f2('0x28')]();};}function saveUpdates(_0x4b74ff,_0x3ccd12){return function(_0x779022){if(_0x779022){return _0x779022['update'](_0x4b74ff)['then'](function(_0x36c147){return _0x36c147;});}return null;};}function removeEntity(_0x824485,_0x5a5278){return function(_0x527471){if(_0x527471){return _0x527471['destroy']()['then'](function(){_0x824485['status'](0xcc)[_0xd1f2('0x1e')]();});}};}function handleEntityNotFound(_0x3f181b,_0x2557d0){return function(_0x2c0bbb){if(!_0x2c0bbb){_0x3f181b[_0xd1f2('0x1c')](0x194);}return _0x2c0bbb;};}function handleError(_0x493870,_0xf935fc){_0xf935fc=_0xf935fc||0x1f4;return function(_0x3a99b2){logger[_0xd1f2('0x29')](_0x3a99b2[_0xd1f2('0x2a')]);if(_0x3a99b2[_0xd1f2('0x2b')]){delete _0x3a99b2[_0xd1f2('0x2b')];}_0x493870[_0xd1f2('0x1d')](_0xf935fc)[_0xd1f2('0x2c')](_0x3a99b2);};}exports[_0xd1f2('0x2d')]=function(_0x2c1d0e,_0x3e5e6c){var _0x58dd7c={},_0x4ef315={},_0x174306={'count':0x0,'rows':[]};var _0x409640=_['map'](db[_0xd1f2('0x2e')]['rawAttributes'],function(_0x1b9c0f){return{'name':_0x1b9c0f[_0xd1f2('0x2f')],'type':_0x1b9c0f[_0xd1f2('0x30')]['key']};});_0x4ef315[_0xd1f2('0x31')]=_['map'](_0x409640,'name');_0x4ef315[_0xd1f2('0x32')]=_[_0xd1f2('0x33')](_0x2c1d0e[_0xd1f2('0x32')]);_0x4ef315[_0xd1f2('0x34')]=_['intersection'](_0x4ef315[_0xd1f2('0x31')],_0x4ef315['query']);_0x58dd7c[_0xd1f2('0x35')]=_[_0xd1f2('0x36')](_0x4ef315['model'],qs[_0xd1f2('0x37')](_0x2c1d0e['query'][_0xd1f2('0x37')]));_0x58dd7c[_0xd1f2('0x35')]=_0x58dd7c[_0xd1f2('0x35')][_0xd1f2('0x38')]?_0x58dd7c[_0xd1f2('0x35')]:_0x4ef315[_0xd1f2('0x31')];if(!_0x2c1d0e['query'][_0xd1f2('0x39')](_0xd1f2('0x3a'))){_0x58dd7c[_0xd1f2('0x21')]=qs[_0xd1f2('0x21')](_0x2c1d0e[_0xd1f2('0x32')]['limit']);_0x58dd7c[_0xd1f2('0x1f')]=qs[_0xd1f2('0x1f')](_0x2c1d0e['query'][_0xd1f2('0x1f')]);}_0x58dd7c['order']=qs[_0xd1f2('0x3b')](_0x2c1d0e[_0xd1f2('0x32')][_0xd1f2('0x3b')]);_0x58dd7c[_0xd1f2('0x3c')]=qs['filters'](_[_0xd1f2('0x3d')](_0x2c1d0e[_0xd1f2('0x32')],_0x4ef315[_0xd1f2('0x34')]),_0x409640);if(_0x2c1d0e[_0xd1f2('0x32')][_0xd1f2('0x3e')]){_0x58dd7c[_0xd1f2('0x3c')]=_[_0xd1f2('0x3f')](_0x58dd7c['where'],{'$or':_[_0xd1f2('0x40')](_0x409640,function(_0x5db7f0){if(_0x5db7f0[_0xd1f2('0x30')]!==_0xd1f2('0x41')){var _0x1edc3d={};_0x1edc3d[_0x5db7f0['name']]={'$like':'%'+_0x2c1d0e[_0xd1f2('0x32')]['filter']+'%'};return _0x1edc3d;}})});}_0x58dd7c=_[_0xd1f2('0x3f')]({},_0x58dd7c,_0x2c1d0e[_0xd1f2('0x42')]);var _0x3c4cc1={'where':_0x58dd7c[_0xd1f2('0x3c')]};return db[_0xd1f2('0x2e')]['count'](_0x3c4cc1)[_0xd1f2('0x43')](function(_0x468311){_0x174306['count']=_0x468311;if(_0x2c1d0e[_0xd1f2('0x32')]['includeAll']){_0x58dd7c[_0xd1f2('0x44')]=[{'all':!![]}];}return db[_0xd1f2('0x2e')][_0xd1f2('0x45')](_0x58dd7c);})['then'](function(_0x3af39d){_0x174306['rows']=_0x3af39d;return _0x174306;})[_0xd1f2('0x43')](respondWithFilteredResult(_0x3e5e6c,_0x58dd7c))[_0xd1f2('0x46')](handleError(_0x3e5e6c,null));};exports[_0xd1f2('0x47')]=function(_0x6c46f8,_0x4256b6){var _0x1cca88={'raw':!![],'where':{'id':_0x6c46f8[_0xd1f2('0x48')]['id']}},_0x436b8b={};_0x436b8b['model']=_[_0xd1f2('0x33')](db[_0xd1f2('0x2e')][_0xd1f2('0x49')]);_0x436b8b[_0xd1f2('0x32')]=_[_0xd1f2('0x33')](_0x6c46f8[_0xd1f2('0x32')]);_0x436b8b['filters']=_[_0xd1f2('0x36')](_0x436b8b[_0xd1f2('0x31')],_0x436b8b[_0xd1f2('0x32')]);_0x1cca88['attributes']=_[_0xd1f2('0x36')](_0x436b8b[_0xd1f2('0x31')],qs[_0xd1f2('0x37')](_0x6c46f8[_0xd1f2('0x32')][_0xd1f2('0x37')]));_0x1cca88[_0xd1f2('0x35')]=_0x1cca88['attributes'][_0xd1f2('0x38')]?_0x1cca88[_0xd1f2('0x35')]:_0x436b8b[_0xd1f2('0x31')];if(_0x6c46f8[_0xd1f2('0x32')]['includeAll']){_0x1cca88[_0xd1f2('0x44')]=[{'all':!![]}];}_0x1cca88=_[_0xd1f2('0x3f')]({},_0x1cca88,_0x6c46f8['options']);return db[_0xd1f2('0x2e')]['find'](_0x1cca88)[_0xd1f2('0x43')](handleEntityNotFound(_0x4256b6,null))['then'](respondWithResult(_0x4256b6,null))[_0xd1f2('0x46')](handleError(_0x4256b6,null));};exports[_0xd1f2('0x4a')]=function(_0x45b0c6,_0x1b7b47){return db[_0xd1f2('0x2e')][_0xd1f2('0x4a')](_0x45b0c6['body'],{})[_0xd1f2('0x43')](respondWithResult(_0x1b7b47,0xc9))[_0xd1f2('0x46')](handleError(_0x1b7b47,null));};exports[_0xd1f2('0x4b')]=function(_0x83734e,_0xc33ad5){if(_0x83734e['body']['id']){delete _0x83734e[_0xd1f2('0x4c')]['id'];}return db[_0xd1f2('0x2e')][_0xd1f2('0x4d')]({'where':{'id':_0x83734e[_0xd1f2('0x48')]['id']}})[_0xd1f2('0x43')](handleEntityNotFound(_0xc33ad5,null))['then'](saveUpdates(_0x83734e[_0xd1f2('0x4c')],null))[_0xd1f2('0x43')](respondWithResult(_0xc33ad5,null))[_0xd1f2('0x46')](handleError(_0xc33ad5,null));};exports[_0xd1f2('0x4e')]=function(_0x23b429,_0x1f7d4c){return db[_0xd1f2('0x2e')][_0xd1f2('0x4d')]({'where':{'id':_0x23b429[_0xd1f2('0x48')]['id']}})[_0xd1f2('0x43')](handleEntityNotFound(_0x1f7d4c,null))['then'](removeEntity(_0x1f7d4c,null))['catch'](handleError(_0x1f7d4c,null));};exports[_0xd1f2('0x4f')]=function(_0x11730e,_0x37a3a8){return db[_0xd1f2('0x2e')][_0xd1f2('0x4f')]()['then'](respondWithResult(_0x37a3a8,null))[_0xd1f2('0x46')](handleError(_0x37a3a8,null));};