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 _0x1b64=['json','offset','limit','undefined','count','set','Content-Range','reject','update','then','destroy','sendStatus','error','name','index','map','fieldName','type','model','query','keys','filters','intersection','attributes','length','hasOwnProperty','nolimit','sort','where','pick','merge','VIRTUAL','filter','options','ChatQueueReport','includeAll','include','findAll','catch','show','params','fields','find','create','body','describe','eml-format','rimraf','fast-json-patch','mustache','util','path','sox','ejs','fs-extra','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','status','end'];(function(_0x14add3,_0x13ce8d){var _0x4a174f=function(_0x2b3ed7){while(--_0x2b3ed7){_0x14add3['push'](_0x14add3['shift']());}};_0x4a174f(++_0x13ce8d);}(_0x1b64,0x76));var _0x41b6=function(_0x116098,_0x582222){_0x116098=_0x116098-0x0;var _0x299fc1=_0x1b64[_0x116098];return _0x299fc1;};'use strict';var emlformat=require(_0x41b6('0x0'));var rimraf=require(_0x41b6('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x41b6('0x2'));var rp=require('request-promise');var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x41b6('0x3'));var util=require(_0x41b6('0x4'));var path=require(_0x41b6('0x5'));var sox=require(_0x41b6('0x6'));var csv=require('to-csv');var ejs=require(_0x41b6('0x7'));var fs=require('fs');var fs_extra=require(_0x41b6('0x8'));var _=require('lodash');var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x41b6('0x9'));var deskjs=require(_0x41b6('0xa'));var toCsv=require(_0x41b6('0xb'));var querystring=require(_0x41b6('0xc'));var Papa=require(_0x41b6('0xd'));var Redis=require(_0x41b6('0xe'));var authService=require('../../components/auth/service');var qs=require(_0x41b6('0xf'));var as=require(_0x41b6('0x10'));var hardwareService=require(_0x41b6('0x11'));var logger=require(_0x41b6('0x12'))(_0x41b6('0x13'));var utils=require(_0x41b6('0x14'));var config=require(_0x41b6('0x15'));var licenseUtil=require(_0x41b6('0x16'));var db=require(_0x41b6('0x17'))['db'];function respondWithStatusCode(_0x1d6080,_0x663516){_0x663516=_0x663516||0xcc;return function(_0x249c3c){if(_0x249c3c){return _0x1d6080['sendStatus'](_0x663516);}return _0x1d6080[_0x41b6('0x18')](_0x663516)[_0x41b6('0x19')]();};}function respondWithResult(_0x11256f,_0x26bb9d){_0x26bb9d=_0x26bb9d||0xc8;return function(_0x549976){if(_0x549976){return _0x11256f[_0x41b6('0x18')](_0x26bb9d)[_0x41b6('0x1a')](_0x549976);}};}function respondWithFilteredResult(_0x24e59a,_0x2d948d){return function(_0x1d4441){if(_0x1d4441){var _0x1bd0b0=typeof _0x2d948d[_0x41b6('0x1b')]==='undefined'&&typeof _0x2d948d[_0x41b6('0x1c')]===_0x41b6('0x1d');var _0x1b2500=_0x1d4441[_0x41b6('0x1e')];var _0x14a786=_0x1bd0b0?0x0:_0x2d948d['offset'];var _0x5637f6=_0x1bd0b0?_0x1d4441['count']:_0x2d948d['offset']+_0x2d948d[_0x41b6('0x1c')];var _0x5a427a;if(_0x5637f6>=_0x1b2500){_0x5637f6=_0x1b2500;_0x5a427a=0xc8;}else{_0x5a427a=0xce;}_0x24e59a[_0x41b6('0x18')](_0x5a427a);return _0x24e59a[_0x41b6('0x1f')](_0x41b6('0x20'),_0x14a786+'-'+_0x5637f6+'/'+_0x1b2500)[_0x41b6('0x1a')](_0x1d4441);}return null;};}function patchUpdates(_0x10c17c){return function(_0x448c62){try{jsonpatch['apply'](_0x448c62,_0x10c17c,!![]);}catch(_0x59948c){return BPromise[_0x41b6('0x21')](_0x59948c);}return _0x448c62['save']();};}function saveUpdates(_0xb4596c,_0x1c37ea){return function(_0x309eba){if(_0x309eba){return _0x309eba[_0x41b6('0x22')](_0xb4596c)[_0x41b6('0x23')](function(_0x1c8e7a){return _0x1c8e7a;});}return null;};}function removeEntity(_0x1fea00,_0x11cc02){return function(_0x2f8e9c){if(_0x2f8e9c){return _0x2f8e9c[_0x41b6('0x24')]()[_0x41b6('0x23')](function(){_0x1fea00['status'](0xcc)[_0x41b6('0x19')]();});}};}function handleEntityNotFound(_0x2c1290,_0x5a984b){return function(_0x7e3269){if(!_0x7e3269){_0x2c1290[_0x41b6('0x25')](0x194);}return _0x7e3269;};}function handleError(_0x4f98de,_0x22d399){_0x22d399=_0x22d399||0x1f4;return function(_0x454b5f){logger[_0x41b6('0x26')](_0x454b5f['stack']);if(_0x454b5f[_0x41b6('0x27')]){delete _0x454b5f['name'];}_0x4f98de['status'](_0x22d399)['send'](_0x454b5f);};}exports[_0x41b6('0x28')]=function(_0x425c16,_0x5b5ca7){var _0x2dee1f={},_0x45f9e2={},_0x102345={'count':0x0,'rows':[]};var _0x426cfc=_[_0x41b6('0x29')](db['ChatQueueReport']['rawAttributes'],function(_0x3338c4){return{'name':_0x3338c4[_0x41b6('0x2a')],'type':_0x3338c4[_0x41b6('0x2b')]['key']};});_0x45f9e2[_0x41b6('0x2c')]=_[_0x41b6('0x29')](_0x426cfc,'name');_0x45f9e2[_0x41b6('0x2d')]=_[_0x41b6('0x2e')](_0x425c16[_0x41b6('0x2d')]);_0x45f9e2[_0x41b6('0x2f')]=_[_0x41b6('0x30')](_0x45f9e2[_0x41b6('0x2c')],_0x45f9e2[_0x41b6('0x2d')]);_0x2dee1f['attributes']=_[_0x41b6('0x30')](_0x45f9e2['model'],qs['fields'](_0x425c16[_0x41b6('0x2d')]['fields']));_0x2dee1f[_0x41b6('0x31')]=_0x2dee1f[_0x41b6('0x31')][_0x41b6('0x32')]?_0x2dee1f[_0x41b6('0x31')]:_0x45f9e2[_0x41b6('0x2c')];if(!_0x425c16[_0x41b6('0x2d')][_0x41b6('0x33')](_0x41b6('0x34'))){_0x2dee1f['limit']=qs[_0x41b6('0x1c')](_0x425c16[_0x41b6('0x2d')][_0x41b6('0x1c')]);_0x2dee1f[_0x41b6('0x1b')]=qs[_0x41b6('0x1b')](_0x425c16[_0x41b6('0x2d')][_0x41b6('0x1b')]);}_0x2dee1f['order']=qs[_0x41b6('0x35')](_0x425c16['query']['sort']);_0x2dee1f[_0x41b6('0x36')]=qs[_0x41b6('0x2f')](_[_0x41b6('0x37')](_0x425c16[_0x41b6('0x2d')],_0x45f9e2[_0x41b6('0x2f')]),_0x426cfc);if(_0x425c16[_0x41b6('0x2d')]['filter']){_0x2dee1f[_0x41b6('0x36')]=_[_0x41b6('0x38')](_0x2dee1f[_0x41b6('0x36')],{'$or':_[_0x41b6('0x29')](_0x426cfc,function(_0x10cec5){if(_0x10cec5[_0x41b6('0x2b')]!==_0x41b6('0x39')){var _0x565ff8={};_0x565ff8[_0x10cec5[_0x41b6('0x27')]]={'$like':'%'+_0x425c16[_0x41b6('0x2d')][_0x41b6('0x3a')]+'%'};return _0x565ff8;}})});}_0x2dee1f=_[_0x41b6('0x38')]({},_0x2dee1f,_0x425c16[_0x41b6('0x3b')]);var _0x158d55={'where':_0x2dee1f[_0x41b6('0x36')]};return db[_0x41b6('0x3c')][_0x41b6('0x1e')](_0x158d55)[_0x41b6('0x23')](function(_0x175b33){_0x102345[_0x41b6('0x1e')]=_0x175b33;if(_0x425c16['query'][_0x41b6('0x3d')]){_0x2dee1f[_0x41b6('0x3e')]=[{'all':!![]}];}return db[_0x41b6('0x3c')][_0x41b6('0x3f')](_0x2dee1f);})[_0x41b6('0x23')](function(_0x3b26ca){_0x102345['rows']=_0x3b26ca;return _0x102345;})['then'](respondWithFilteredResult(_0x5b5ca7,_0x2dee1f))[_0x41b6('0x40')](handleError(_0x5b5ca7,null));};exports[_0x41b6('0x41')]=function(_0x501bab,_0x56d9ab){var _0x1e4d30={'raw':!![],'where':{'id':_0x501bab[_0x41b6('0x42')]['id']}},_0x2e72ae={};_0x2e72ae['model']=_['keys'](db[_0x41b6('0x3c')]['rawAttributes']);_0x2e72ae[_0x41b6('0x2d')]=_[_0x41b6('0x2e')](_0x501bab[_0x41b6('0x2d')]);_0x2e72ae[_0x41b6('0x2f')]=_[_0x41b6('0x30')](_0x2e72ae['model'],_0x2e72ae[_0x41b6('0x2d')]);_0x1e4d30[_0x41b6('0x31')]=_[_0x41b6('0x30')](_0x2e72ae[_0x41b6('0x2c')],qs['fields'](_0x501bab[_0x41b6('0x2d')][_0x41b6('0x43')]));_0x1e4d30[_0x41b6('0x31')]=_0x1e4d30[_0x41b6('0x31')][_0x41b6('0x32')]?_0x1e4d30[_0x41b6('0x31')]:_0x2e72ae[_0x41b6('0x2c')];if(_0x501bab['query'][_0x41b6('0x3d')]){_0x1e4d30['include']=[{'all':!![]}];}_0x1e4d30=_[_0x41b6('0x38')]({},_0x1e4d30,_0x501bab[_0x41b6('0x3b')]);return db['ChatQueueReport'][_0x41b6('0x44')](_0x1e4d30)[_0x41b6('0x23')](handleEntityNotFound(_0x56d9ab,null))['then'](respondWithResult(_0x56d9ab,null))[_0x41b6('0x40')](handleError(_0x56d9ab,null));};exports[_0x41b6('0x45')]=function(_0x11a951,_0x690c7a){return db[_0x41b6('0x3c')]['create'](_0x11a951[_0x41b6('0x46')],{})[_0x41b6('0x23')](respondWithResult(_0x690c7a,0xc9))[_0x41b6('0x40')](handleError(_0x690c7a,null));};exports['update']=function(_0x1b519a,_0x46a496){if(_0x1b519a[_0x41b6('0x46')]['id']){delete _0x1b519a[_0x41b6('0x46')]['id'];}return db[_0x41b6('0x3c')][_0x41b6('0x44')]({'where':{'id':_0x1b519a[_0x41b6('0x42')]['id']}})['then'](handleEntityNotFound(_0x46a496,null))['then'](saveUpdates(_0x1b519a[_0x41b6('0x46')],null))['then'](respondWithResult(_0x46a496,null))['catch'](handleError(_0x46a496,null));};exports[_0x41b6('0x24')]=function(_0x40a284,_0x39d4a0){return db[_0x41b6('0x3c')][_0x41b6('0x44')]({'where':{'id':_0x40a284[_0x41b6('0x42')]['id']}})['then'](handleEntityNotFound(_0x39d4a0,null))[_0x41b6('0x23')](removeEntity(_0x39d4a0,null))['catch'](handleError(_0x39d4a0,null));};exports[_0x41b6('0x47')]=function(_0x50b062,_0x1d11f5){return db[_0x41b6('0x3c')]['describe']()[_0x41b6('0x23')](respondWithResult(_0x1d11f5,null))[_0x41b6('0x40')](handleError(_0x1d11f5,null));};