server/api/mailQueueReport/mailQueueReport.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 _0x5ab0=['Content-Range','apply','save','then','error','stack','name','rawAttributes','key','model','map','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','filter','where','merge','type','VIRTUAL','options','includeAll','include','MailQueueReport','findAll','rows','catch','show','find','update','body','destroy','params','describe','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','sendStatus','end','json','count','offset','limit','status','set'];(function(_0x8b6f53,_0x3c6293){var _0x34288e=function(_0x5d7c62){while(--_0x5d7c62){_0x8b6f53['push'](_0x8b6f53['shift']());}};_0x34288e(++_0x3c6293);}(_0x5ab0,0x75));var _0x05ab=function(_0x446d4f,_0x4f7b58){_0x446d4f=_0x446d4f-0x0;var _0x2d7d09=_0x5ab0[_0x446d4f];return _0x2d7d09;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x05ab('0x0'));var rimraf=require(_0x05ab('0x1'));var zipdir=require(_0x05ab('0x2'));var jsonpatch=require(_0x05ab('0x3'));var rp=require(_0x05ab('0x4'));var moment=require(_0x05ab('0x5'));var BPromise=require(_0x05ab('0x6'));var Mustache=require(_0x05ab('0x7'));var util=require(_0x05ab('0x8'));var path=require(_0x05ab('0x9'));var sox=require(_0x05ab('0xa'));var csv=require(_0x05ab('0xb'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x05ab('0xc'));var squel=require(_0x05ab('0xd'));var crypto=require('crypto');var jsforce=require(_0x05ab('0xe'));var deskjs=require(_0x05ab('0xf'));var toCsv=require('to-csv');var querystring=require(_0x05ab('0x10'));var Papa=require(_0x05ab('0x11'));var Redis=require(_0x05ab('0x12'));var authService=require('../../components/auth/service');var qs=require(_0x05ab('0x13'));var as=require(_0x05ab('0x14'));var hardwareService=require(_0x05ab('0x15'));var logger=require(_0x05ab('0x16'))(_0x05ab('0x17'));var utils=require(_0x05ab('0x18'));var config=require(_0x05ab('0x19'));var licenseUtil=require(_0x05ab('0x1a'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x3f3d79,_0x5aa05e){_0x5aa05e=_0x5aa05e||0xcc;return function(_0x55e8e5){if(_0x55e8e5){return _0x3f3d79[_0x05ab('0x1b')](_0x5aa05e);}return _0x3f3d79['status'](_0x5aa05e)[_0x05ab('0x1c')]();};}function respondWithResult(_0x290fa7,_0x36e2f8){_0x36e2f8=_0x36e2f8||0xc8;return function(_0x181d14){if(_0x181d14){return _0x290fa7['status'](_0x36e2f8)[_0x05ab('0x1d')](_0x181d14);}};}function respondWithFilteredResult(_0x3d889f,_0x305638){return function(_0x35da13){if(_0x35da13){var _0x266914=_0x35da13[_0x05ab('0x1e')],_0x2bf70=_0x305638[_0x05ab('0x1f')],_0x224d8d=_0x305638['offset']+_0x305638[_0x05ab('0x20')],_0x59184e;if(_0x224d8d>=_0x266914){_0x224d8d=_0x266914;_0x59184e=0xc8;}else{_0x59184e=0xce;}_0x3d889f[_0x05ab('0x21')](_0x59184e);return _0x3d889f[_0x05ab('0x22')](_0x05ab('0x23'),_0x2bf70+'-'+_0x224d8d+'/'+_0x266914)[_0x05ab('0x1d')](_0x35da13);}return null;};}function patchUpdates(_0x5442b2){return function(_0x29ab96){try{jsonpatch[_0x05ab('0x24')](_0x29ab96,_0x5442b2,!![]);}catch(_0x40b781){return BPromise['reject'](_0x40b781);}return _0x29ab96[_0x05ab('0x25')]();};}function saveUpdates(_0x271cbb,_0x164f27){return function(_0x53d3ef){if(_0x53d3ef){return _0x53d3ef['update'](_0x271cbb)[_0x05ab('0x26')](function(_0x30dd05){return _0x30dd05;});}return null;};}function removeEntity(_0x3f7f07,_0x264b65){return function(_0x47a847){if(_0x47a847){return _0x47a847['destroy']()[_0x05ab('0x26')](function(){_0x3f7f07[_0x05ab('0x21')](0xcc)['end']();});}};}function handleEntityNotFound(_0xeb5d77,_0x3d787c){return function(_0x43386c){if(!_0x43386c){_0xeb5d77[_0x05ab('0x1b')](0x194);}return _0x43386c;};}function handleError(_0x5a1890,_0x346a24){_0x346a24=_0x346a24||0x1f4;return function(_0x43e9ba){logger[_0x05ab('0x27')](_0x43e9ba[_0x05ab('0x28')]);if(_0x43e9ba[_0x05ab('0x29')]){delete _0x43e9ba[_0x05ab('0x29')];}_0x5a1890[_0x05ab('0x21')](_0x346a24)['send'](_0x43e9ba);};}exports['index']=function(_0x32b239,_0x4e233e){var _0x1f8942={},_0x59cb72={},_0xa65f76={'count':0x0,'rows':[]};var _0x1c6660=_['map'](db['MailQueueReport'][_0x05ab('0x2a')],function(_0x58f4e3){return{'name':_0x58f4e3['fieldName'],'type':_0x58f4e3['type'][_0x05ab('0x2b')]};});_0x59cb72[_0x05ab('0x2c')]=_[_0x05ab('0x2d')](_0x1c6660,'name');_0x59cb72[_0x05ab('0x2e')]=_[_0x05ab('0x2f')](_0x32b239['query']);_0x59cb72[_0x05ab('0x30')]=_[_0x05ab('0x31')](_0x59cb72[_0x05ab('0x2c')],_0x59cb72[_0x05ab('0x2e')]);_0x1f8942[_0x05ab('0x32')]=_[_0x05ab('0x31')](_0x59cb72[_0x05ab('0x2c')],qs['fields'](_0x32b239[_0x05ab('0x2e')][_0x05ab('0x33')]));_0x1f8942[_0x05ab('0x32')]=_0x1f8942[_0x05ab('0x32')][_0x05ab('0x34')]?_0x1f8942[_0x05ab('0x32')]:_0x59cb72[_0x05ab('0x2c')];if(!_0x32b239[_0x05ab('0x2e')][_0x05ab('0x35')](_0x05ab('0x36'))){_0x1f8942[_0x05ab('0x20')]=qs[_0x05ab('0x20')](_0x32b239[_0x05ab('0x2e')][_0x05ab('0x20')]);_0x1f8942[_0x05ab('0x1f')]=qs['offset'](_0x32b239[_0x05ab('0x2e')][_0x05ab('0x1f')]);}_0x1f8942[_0x05ab('0x37')]=qs[_0x05ab('0x38')](_0x32b239['query'][_0x05ab('0x38')]);_0x1f8942['where']=qs[_0x05ab('0x30')](_['pick'](_0x32b239['query'],_0x59cb72['filters']),_0x1c6660);if(_0x32b239[_0x05ab('0x2e')][_0x05ab('0x39')]){_0x1f8942[_0x05ab('0x3a')]=_[_0x05ab('0x3b')](_0x1f8942[_0x05ab('0x3a')],{'$or':_[_0x05ab('0x2d')](_0x1c6660,function(_0x43048f){if(_0x43048f[_0x05ab('0x3c')]!==_0x05ab('0x3d')){var _0x22f691={};_0x22f691[_0x43048f[_0x05ab('0x29')]]={'$like':'%'+_0x32b239[_0x05ab('0x2e')][_0x05ab('0x39')]+'%'};return _0x22f691;}})});}_0x1f8942=_[_0x05ab('0x3b')]({},_0x1f8942,_0x32b239[_0x05ab('0x3e')]);var _0xf61058={'where':_0x1f8942[_0x05ab('0x3a')]};return db['MailQueueReport']['count'](_0xf61058)[_0x05ab('0x26')](function(_0x513bd4){_0xa65f76[_0x05ab('0x1e')]=_0x513bd4;if(_0x32b239['query'][_0x05ab('0x3f')]){_0x1f8942[_0x05ab('0x40')]=[{'all':!![]}];}return db[_0x05ab('0x41')][_0x05ab('0x42')](_0x1f8942);})[_0x05ab('0x26')](function(_0x2ca358){_0xa65f76[_0x05ab('0x43')]=_0x2ca358;return _0xa65f76;})['then'](respondWithFilteredResult(_0x4e233e,_0x1f8942))[_0x05ab('0x44')](handleError(_0x4e233e,null));};exports[_0x05ab('0x45')]=function(_0x2a41c5,_0xcd4024){var _0x28db0b={'raw':!![],'where':{'id':_0x2a41c5['params']['id']}},_0x286429={};_0x286429[_0x05ab('0x2c')]=_['keys'](db[_0x05ab('0x41')][_0x05ab('0x2a')]);_0x286429[_0x05ab('0x2e')]=_[_0x05ab('0x2f')](_0x2a41c5[_0x05ab('0x2e')]);_0x286429[_0x05ab('0x30')]=_['intersection'](_0x286429[_0x05ab('0x2c')],_0x286429['query']);_0x28db0b[_0x05ab('0x32')]=_[_0x05ab('0x31')](_0x286429[_0x05ab('0x2c')],qs['fields'](_0x2a41c5[_0x05ab('0x2e')][_0x05ab('0x33')]));_0x28db0b[_0x05ab('0x32')]=_0x28db0b[_0x05ab('0x32')]['length']?_0x28db0b[_0x05ab('0x32')]:_0x286429['model'];if(_0x2a41c5['query'][_0x05ab('0x3f')]){_0x28db0b['include']=[{'all':!![]}];}_0x28db0b=_['merge']({},_0x28db0b,_0x2a41c5['options']);return db[_0x05ab('0x41')][_0x05ab('0x46')](_0x28db0b)['then'](handleEntityNotFound(_0xcd4024,null))[_0x05ab('0x26')](respondWithResult(_0xcd4024,null))['catch'](handleError(_0xcd4024,null));};exports['create']=function(_0x3f5517,_0x3e91bc){return db[_0x05ab('0x41')]['create'](_0x3f5517['body'],{})[_0x05ab('0x26')](respondWithResult(_0x3e91bc,0xc9))[_0x05ab('0x44')](handleError(_0x3e91bc,null));};exports[_0x05ab('0x47')]=function(_0x3f9618,_0x3f809f){if(_0x3f9618[_0x05ab('0x48')]['id']){delete _0x3f9618[_0x05ab('0x48')]['id'];}return db[_0x05ab('0x41')][_0x05ab('0x46')]({'where':{'id':_0x3f9618['params']['id']}})['then'](handleEntityNotFound(_0x3f809f,null))[_0x05ab('0x26')](saveUpdates(_0x3f9618[_0x05ab('0x48')],null))[_0x05ab('0x26')](respondWithResult(_0x3f809f,null))[_0x05ab('0x44')](handleError(_0x3f809f,null));};exports[_0x05ab('0x49')]=function(_0x48ac8a,_0x25f24a){return db[_0x05ab('0x41')][_0x05ab('0x46')]({'where':{'id':_0x48ac8a[_0x05ab('0x4a')]['id']}})[_0x05ab('0x26')](handleEntityNotFound(_0x25f24a,null))[_0x05ab('0x26')](removeEntity(_0x25f24a,null))[_0x05ab('0x44')](handleError(_0x25f24a,null));};exports['describe']=function(_0x3993a0,_0xf5540c){return db[_0x05ab('0x41')][_0x05ab('0x4b')]()['then'](respondWithResult(_0xf5540c,null))[_0x05ab('0x44')](handleError(_0xf5540c,null));};