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 _0x7eee=['offset','limit','undefined','count','set','Content-Range','apply','reject','then','destroy','stack','name','send','index','rawAttributes','fieldName','type','key','model','map','keys','filters','intersection','attributes','length','hasOwnProperty','nolimit','query','order','sort','where','pick','filter','merge','VIRTUAL','options','ChatQueueReport','includeAll','include','findAll','catch','show','params','fields','create','body','update','find','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json'];(function(_0x3e69b6,_0x1f52e8){var _0xdae4f=function(_0x3454b2){while(--_0x3454b2){_0x3e69b6['push'](_0x3e69b6['shift']());}};_0xdae4f(++_0x1f52e8);}(_0x7eee,0xce));var _0xe7ee=function(_0x1f2bf5,_0x54160f){_0x1f2bf5=_0x1f2bf5-0x0;var _0x2edc41=_0x7eee[_0x1f2bf5];return _0x2edc41;};'use strict';var emlformat=require(_0xe7ee('0x0'));var rimraf=require(_0xe7ee('0x1'));var zipdir=require(_0xe7ee('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xe7ee('0x3'));var moment=require(_0xe7ee('0x4'));var BPromise=require(_0xe7ee('0x5'));var Mustache=require(_0xe7ee('0x6'));var util=require('util');var path=require(_0xe7ee('0x7'));var sox=require(_0xe7ee('0x8'));var csv=require(_0xe7ee('0x9'));var ejs=require(_0xe7ee('0xa'));var fs=require('fs');var fs_extra=require(_0xe7ee('0xb'));var _=require(_0xe7ee('0xc'));var squel=require(_0xe7ee('0xd'));var crypto=require(_0xe7ee('0xe'));var jsforce=require('jsforce');var deskjs=require(_0xe7ee('0xf'));var toCsv=require('to-csv');var querystring=require(_0xe7ee('0x10'));var Papa=require(_0xe7ee('0x11'));var Redis=require(_0xe7ee('0x12'));var authService=require('../../components/auth/service');var qs=require(_0xe7ee('0x13'));var as=require(_0xe7ee('0x14'));var hardwareService=require(_0xe7ee('0x15'));var logger=require(_0xe7ee('0x16'))('api');var utils=require(_0xe7ee('0x17'));var config=require(_0xe7ee('0x18'));var licenseUtil=require(_0xe7ee('0x19'));var db=require(_0xe7ee('0x1a'))['db'];function respondWithStatusCode(_0x4a8250,_0x1511db){_0x1511db=_0x1511db||0xcc;return function(_0x2c0c5b){if(_0x2c0c5b){return _0x4a8250[_0xe7ee('0x1b')](_0x1511db);}return _0x4a8250[_0xe7ee('0x1c')](_0x1511db)[_0xe7ee('0x1d')]();};}function respondWithResult(_0xbe0742,_0x138717){_0x138717=_0x138717||0xc8;return function(_0x184ab8){if(_0x184ab8){return _0xbe0742[_0xe7ee('0x1c')](_0x138717)[_0xe7ee('0x1e')](_0x184ab8);}};}function respondWithFilteredResult(_0x27f539,_0x10462b){return function(_0x8e9dc2){if(_0x8e9dc2){var _0x52bec7=typeof _0x10462b[_0xe7ee('0x1f')]==='undefined'&&typeof _0x10462b[_0xe7ee('0x20')]===_0xe7ee('0x21');var _0x302b73=_0x8e9dc2['count'];var _0x731dce=_0x52bec7?0x0:_0x10462b['offset'];var _0x402aac=_0x52bec7?_0x8e9dc2[_0xe7ee('0x22')]:_0x10462b[_0xe7ee('0x1f')]+_0x10462b[_0xe7ee('0x20')];var _0x150978;if(_0x402aac>=_0x302b73){_0x402aac=_0x302b73;_0x150978=0xc8;}else{_0x150978=0xce;}_0x27f539['status'](_0x150978);return _0x27f539[_0xe7ee('0x23')](_0xe7ee('0x24'),_0x731dce+'-'+_0x402aac+'/'+_0x302b73)[_0xe7ee('0x1e')](_0x8e9dc2);}return null;};}function patchUpdates(_0x1fc26f){return function(_0x56458b){try{jsonpatch[_0xe7ee('0x25')](_0x56458b,_0x1fc26f,!![]);}catch(_0x47ed53){return BPromise[_0xe7ee('0x26')](_0x47ed53);}return _0x56458b['save']();};}function saveUpdates(_0x135b43,_0x4d7b4a){return function(_0x4fe861){if(_0x4fe861){return _0x4fe861['update'](_0x135b43)[_0xe7ee('0x27')](function(_0xc49d67){return _0xc49d67;});}return null;};}function removeEntity(_0x1dd39b,_0x8899f6){return function(_0x2cf238){if(_0x2cf238){return _0x2cf238[_0xe7ee('0x28')]()['then'](function(){_0x1dd39b[_0xe7ee('0x1c')](0xcc)[_0xe7ee('0x1d')]();});}};}function handleEntityNotFound(_0x5a447d,_0x354174){return function(_0x46b073){if(!_0x46b073){_0x5a447d[_0xe7ee('0x1b')](0x194);}return _0x46b073;};}function handleError(_0x573d8e,_0x4e08e4){_0x4e08e4=_0x4e08e4||0x1f4;return function(_0x8763f9){logger['error'](_0x8763f9[_0xe7ee('0x29')]);if(_0x8763f9[_0xe7ee('0x2a')]){delete _0x8763f9[_0xe7ee('0x2a')];}_0x573d8e[_0xe7ee('0x1c')](_0x4e08e4)[_0xe7ee('0x2b')](_0x8763f9);};}exports[_0xe7ee('0x2c')]=function(_0x318746,_0x3aa503){var _0x3178fc={},_0x3a9b06={},_0x13d69d={'count':0x0,'rows':[]};var _0x413aa9=_['map'](db['ChatQueueReport'][_0xe7ee('0x2d')],function(_0x38d8a5){return{'name':_0x38d8a5[_0xe7ee('0x2e')],'type':_0x38d8a5[_0xe7ee('0x2f')][_0xe7ee('0x30')]};});_0x3a9b06[_0xe7ee('0x31')]=_[_0xe7ee('0x32')](_0x413aa9,'name');_0x3a9b06['query']=_[_0xe7ee('0x33')](_0x318746['query']);_0x3a9b06[_0xe7ee('0x34')]=_[_0xe7ee('0x35')](_0x3a9b06[_0xe7ee('0x31')],_0x3a9b06['query']);_0x3178fc['attributes']=_['intersection'](_0x3a9b06[_0xe7ee('0x31')],qs['fields'](_0x318746['query']['fields']));_0x3178fc[_0xe7ee('0x36')]=_0x3178fc['attributes'][_0xe7ee('0x37')]?_0x3178fc['attributes']:_0x3a9b06['model'];if(!_0x318746['query'][_0xe7ee('0x38')](_0xe7ee('0x39'))){_0x3178fc[_0xe7ee('0x20')]=qs[_0xe7ee('0x20')](_0x318746[_0xe7ee('0x3a')]['limit']);_0x3178fc[_0xe7ee('0x1f')]=qs[_0xe7ee('0x1f')](_0x318746[_0xe7ee('0x3a')][_0xe7ee('0x1f')]);}_0x3178fc[_0xe7ee('0x3b')]=qs[_0xe7ee('0x3c')](_0x318746[_0xe7ee('0x3a')][_0xe7ee('0x3c')]);_0x3178fc[_0xe7ee('0x3d')]=qs['filters'](_[_0xe7ee('0x3e')](_0x318746['query'],_0x3a9b06['filters']),_0x413aa9);if(_0x318746['query'][_0xe7ee('0x3f')]){_0x3178fc[_0xe7ee('0x3d')]=_[_0xe7ee('0x40')](_0x3178fc[_0xe7ee('0x3d')],{'$or':_[_0xe7ee('0x32')](_0x413aa9,function(_0x7e3198){if(_0x7e3198['type']!==_0xe7ee('0x41')){var _0x3efaf1={};_0x3efaf1[_0x7e3198[_0xe7ee('0x2a')]]={'$like':'%'+_0x318746[_0xe7ee('0x3a')][_0xe7ee('0x3f')]+'%'};return _0x3efaf1;}})});}_0x3178fc=_[_0xe7ee('0x40')]({},_0x3178fc,_0x318746[_0xe7ee('0x42')]);var _0x39350f={'where':_0x3178fc[_0xe7ee('0x3d')]};return db[_0xe7ee('0x43')][_0xe7ee('0x22')](_0x39350f)[_0xe7ee('0x27')](function(_0x1256a5){_0x13d69d[_0xe7ee('0x22')]=_0x1256a5;if(_0x318746['query'][_0xe7ee('0x44')]){_0x3178fc[_0xe7ee('0x45')]=[{'all':!![]}];}return db['ChatQueueReport'][_0xe7ee('0x46')](_0x3178fc);})[_0xe7ee('0x27')](function(_0x5f39bc){_0x13d69d['rows']=_0x5f39bc;return _0x13d69d;})[_0xe7ee('0x27')](respondWithFilteredResult(_0x3aa503,_0x3178fc))[_0xe7ee('0x47')](handleError(_0x3aa503,null));};exports[_0xe7ee('0x48')]=function(_0x2cda5d,_0x959e7c){var _0x3be0cd={'raw':!![],'where':{'id':_0x2cda5d[_0xe7ee('0x49')]['id']}},_0x2e7b66={};_0x2e7b66[_0xe7ee('0x31')]=_[_0xe7ee('0x33')](db[_0xe7ee('0x43')]['rawAttributes']);_0x2e7b66[_0xe7ee('0x3a')]=_[_0xe7ee('0x33')](_0x2cda5d[_0xe7ee('0x3a')]);_0x2e7b66[_0xe7ee('0x34')]=_[_0xe7ee('0x35')](_0x2e7b66[_0xe7ee('0x31')],_0x2e7b66[_0xe7ee('0x3a')]);_0x3be0cd[_0xe7ee('0x36')]=_['intersection'](_0x2e7b66[_0xe7ee('0x31')],qs['fields'](_0x2cda5d[_0xe7ee('0x3a')][_0xe7ee('0x4a')]));_0x3be0cd[_0xe7ee('0x36')]=_0x3be0cd[_0xe7ee('0x36')][_0xe7ee('0x37')]?_0x3be0cd['attributes']:_0x2e7b66['model'];if(_0x2cda5d[_0xe7ee('0x3a')][_0xe7ee('0x44')]){_0x3be0cd[_0xe7ee('0x45')]=[{'all':!![]}];}_0x3be0cd=_[_0xe7ee('0x40')]({},_0x3be0cd,_0x2cda5d[_0xe7ee('0x42')]);return db[_0xe7ee('0x43')]['find'](_0x3be0cd)[_0xe7ee('0x27')](handleEntityNotFound(_0x959e7c,null))['then'](respondWithResult(_0x959e7c,null))[_0xe7ee('0x47')](handleError(_0x959e7c,null));};exports['create']=function(_0x44cc78,_0x1cf65d){return db[_0xe7ee('0x43')][_0xe7ee('0x4b')](_0x44cc78[_0xe7ee('0x4c')],{})[_0xe7ee('0x27')](respondWithResult(_0x1cf65d,0xc9))[_0xe7ee('0x47')](handleError(_0x1cf65d,null));};exports[_0xe7ee('0x4d')]=function(_0x24bf10,_0x4a18ce){if(_0x24bf10[_0xe7ee('0x4c')]['id']){delete _0x24bf10['body']['id'];}return db[_0xe7ee('0x43')][_0xe7ee('0x4e')]({'where':{'id':_0x24bf10[_0xe7ee('0x49')]['id']}})[_0xe7ee('0x27')](handleEntityNotFound(_0x4a18ce,null))[_0xe7ee('0x27')](saveUpdates(_0x24bf10[_0xe7ee('0x4c')],null))['then'](respondWithResult(_0x4a18ce,null))[_0xe7ee('0x47')](handleError(_0x4a18ce,null));};exports[_0xe7ee('0x28')]=function(_0x1a1c6f,_0x3075ad){return db['ChatQueueReport'][_0xe7ee('0x4e')]({'where':{'id':_0x1a1c6f[_0xe7ee('0x49')]['id']}})['then'](handleEntityNotFound(_0x3075ad,null))['then'](removeEntity(_0x3075ad,null))[_0xe7ee('0x47')](handleError(_0x3075ad,null));};exports['describe']=function(_0x2108bd,_0x18c25f){return db[_0xe7ee('0x43')]['describe']()[_0xe7ee('0x27')](respondWithResult(_0x18c25f,null))[_0xe7ee('0x47')](handleError(_0x18c25f,null));};