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 _0xe0ab=['offset','limit','set','Content-Range','apply','reject','then','destroy','error','stack','name','send','index','MailQueueReport','type','map','query','keys','filters','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','options','findAll','catch','show','params','rawAttributes','include','find','create','update','body','describe','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','bluebird','mustache','util','sox','to-csv','ejs','lodash','jsforce','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','api','../../config/license/util','../../mysqldb','sendStatus','status','end','json','count'];(function(_0x355478,_0x3081cf){var _0xe01cdc=function(_0x5e6984){while(--_0x5e6984){_0x355478['push'](_0x355478['shift']());}};_0xe01cdc(++_0x3081cf);}(_0xe0ab,0x148));var _0xbe0a=function(_0x4243a3,_0x447337){_0x4243a3=_0x4243a3-0x0;var _0x1b2a33=_0xe0ab[_0x4243a3];return _0x1b2a33;};'use strict';var pdf=require(_0xbe0a('0x0'));var emlformat=require(_0xbe0a('0x1'));var rimraf=require(_0xbe0a('0x2'));var zipdir=require(_0xbe0a('0x3'));var jsonpatch=require(_0xbe0a('0x4'));var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0xbe0a('0x5'));var Mustache=require(_0xbe0a('0x6'));var util=require(_0xbe0a('0x7'));var path=require('path');var sox=require(_0xbe0a('0x8'));var csv=require(_0xbe0a('0x9'));var ejs=require(_0xbe0a('0xa'));var fs=require('fs');var _=require(_0xbe0a('0xb'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0xbe0a('0xc'));var deskjs=require(_0xbe0a('0xd'));var toCsv=require(_0xbe0a('0x9'));var querystring=require(_0xbe0a('0xe'));var Papa=require('papaparse');var Redis=require(_0xbe0a('0xf'));var authService=require(_0xbe0a('0x10'));var qs=require(_0xbe0a('0x11'));var as=require(_0xbe0a('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0xbe0a('0x13'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0xbe0a('0x14'));var db=require(_0xbe0a('0x15'))['db'];function respondWithStatusCode(_0x315477,_0x146e53){_0x146e53=_0x146e53||0xcc;return function(_0x124428){if(_0x124428){return _0x315477[_0xbe0a('0x16')](_0x146e53);}return _0x315477[_0xbe0a('0x17')](_0x146e53)[_0xbe0a('0x18')]();};}function respondWithResult(_0x97ce61,_0x33c885){_0x33c885=_0x33c885||0xc8;return function(_0x49a9b8){if(_0x49a9b8){return _0x97ce61[_0xbe0a('0x17')](_0x33c885)[_0xbe0a('0x19')](_0x49a9b8);}};}function respondWithFilteredResult(_0x16f6b0,_0x10e80d){return function(_0xe20c4c){if(_0xe20c4c){var _0x387eff=_0xe20c4c[_0xbe0a('0x1a')],_0x3f01cd=_0x10e80d['offset'],_0x536db3=_0x10e80d[_0xbe0a('0x1b')]+_0x10e80d[_0xbe0a('0x1c')],_0x50a738;if(_0x536db3>=_0x387eff){_0x536db3=_0x387eff;_0x50a738=0xc8;}else{_0x50a738=0xce;}_0x16f6b0[_0xbe0a('0x17')](_0x50a738);return _0x16f6b0[_0xbe0a('0x1d')](_0xbe0a('0x1e'),_0x3f01cd+'-'+_0x536db3+'/'+_0x387eff)[_0xbe0a('0x19')](_0xe20c4c);}return null;};}function patchUpdates(_0x259e43){return function(_0x5e4634){try{jsonpatch[_0xbe0a('0x1f')](_0x5e4634,_0x259e43,!![]);}catch(_0x47c619){return BPromise[_0xbe0a('0x20')](_0x47c619);}return _0x5e4634['save']();};}function saveUpdates(_0x3f0714,_0x48442f){return function(_0x39586e){if(_0x39586e){return _0x39586e['update'](_0x3f0714)[_0xbe0a('0x21')](function(_0x181fd8){return _0x181fd8;});}return null;};}function removeEntity(_0x33115b,_0x1da622){return function(_0x4270e4){if(_0x4270e4){return _0x4270e4[_0xbe0a('0x22')]()[_0xbe0a('0x21')](function(){_0x33115b['status'](0xcc)[_0xbe0a('0x18')]();});}};}function handleEntityNotFound(_0x449eb2,_0x70ece5){return function(_0x196465){if(!_0x196465){_0x449eb2['sendStatus'](0x194);}return _0x196465;};}function handleError(_0x1b28a0,_0x185a4a){_0x185a4a=_0x185a4a||0x1f4;return function(_0x21089c){logger[_0xbe0a('0x23')](_0x21089c[_0xbe0a('0x24')]);if(_0x21089c[_0xbe0a('0x25')]){delete _0x21089c[_0xbe0a('0x25')];}_0x1b28a0[_0xbe0a('0x17')](_0x185a4a)[_0xbe0a('0x26')](_0x21089c);};}exports[_0xbe0a('0x27')]=function(_0x2b1187,_0x344813){var _0x1eb7d7={},_0x5cd474={},_0x3a9de5={'count':0x0,'rows':[]};var _0x9d559f=_['map'](db[_0xbe0a('0x28')]['rawAttributes'],function(_0x1963ed){return{'name':_0x1963ed['fieldName'],'type':_0x1963ed[_0xbe0a('0x29')]['key']};});_0x5cd474['model']=_[_0xbe0a('0x2a')](_0x9d559f,_0xbe0a('0x25'));_0x5cd474[_0xbe0a('0x2b')]=_[_0xbe0a('0x2c')](_0x2b1187[_0xbe0a('0x2b')]);_0x5cd474[_0xbe0a('0x2d')]=_[_0xbe0a('0x2e')](_0x5cd474[_0xbe0a('0x2f')],_0x5cd474[_0xbe0a('0x2b')]);_0x1eb7d7[_0xbe0a('0x30')]=_['intersection'](_0x5cd474[_0xbe0a('0x2f')],qs[_0xbe0a('0x31')](_0x2b1187[_0xbe0a('0x2b')][_0xbe0a('0x31')]));_0x1eb7d7[_0xbe0a('0x30')]=_0x1eb7d7[_0xbe0a('0x30')][_0xbe0a('0x32')]?_0x1eb7d7[_0xbe0a('0x30')]:_0x5cd474[_0xbe0a('0x2f')];if(!_0x2b1187[_0xbe0a('0x2b')][_0xbe0a('0x33')](_0xbe0a('0x34'))){_0x1eb7d7[_0xbe0a('0x1c')]=qs[_0xbe0a('0x1c')](_0x2b1187['query'][_0xbe0a('0x1c')]);_0x1eb7d7[_0xbe0a('0x1b')]=qs['offset'](_0x2b1187[_0xbe0a('0x2b')][_0xbe0a('0x1b')]);}_0x1eb7d7[_0xbe0a('0x35')]=qs[_0xbe0a('0x36')](_0x2b1187['query']['sort']);_0x1eb7d7[_0xbe0a('0x37')]=qs[_0xbe0a('0x2d')](_[_0xbe0a('0x38')](_0x2b1187[_0xbe0a('0x2b')],_0x5cd474[_0xbe0a('0x2d')]),_0x9d559f);if(_0x2b1187[_0xbe0a('0x2b')]['filter']){_0x1eb7d7[_0xbe0a('0x37')]=_['merge'](_0x1eb7d7[_0xbe0a('0x37')],{'$or':_['map'](_0x9d559f,function(_0x27dfd7){if(_0x27dfd7[_0xbe0a('0x29')]!=='VIRTUAL'){var _0x24cd35={};_0x24cd35[_0x27dfd7['name']]={'$like':'%'+_0x2b1187[_0xbe0a('0x2b')][_0xbe0a('0x39')]+'%'};return _0x24cd35;}})});}_0x1eb7d7=_[_0xbe0a('0x3a')]({},_0x1eb7d7,_0x2b1187[_0xbe0a('0x3b')]);var _0x4e200b={'where':_0x1eb7d7[_0xbe0a('0x37')]};return db[_0xbe0a('0x28')]['count'](_0x4e200b)[_0xbe0a('0x21')](function(_0x532e37){_0x3a9de5['count']=_0x532e37;if(_0x2b1187['query']['includeAll']){_0x1eb7d7['include']=[{'all':!![]}];}return db[_0xbe0a('0x28')][_0xbe0a('0x3c')](_0x1eb7d7);})[_0xbe0a('0x21')](function(_0x30d615){_0x3a9de5['rows']=_0x30d615;return _0x3a9de5;})[_0xbe0a('0x21')](respondWithFilteredResult(_0x344813,_0x1eb7d7))[_0xbe0a('0x3d')](handleError(_0x344813,null));};exports[_0xbe0a('0x3e')]=function(_0x5b2189,_0x2eb033){var _0x350e28={'raw':!![],'where':{'id':_0x5b2189[_0xbe0a('0x3f')]['id']}},_0x5bacd7={};_0x5bacd7[_0xbe0a('0x2f')]=_[_0xbe0a('0x2c')](db[_0xbe0a('0x28')][_0xbe0a('0x40')]);_0x5bacd7['query']=_[_0xbe0a('0x2c')](_0x5b2189['query']);_0x5bacd7[_0xbe0a('0x2d')]=_[_0xbe0a('0x2e')](_0x5bacd7[_0xbe0a('0x2f')],_0x5bacd7[_0xbe0a('0x2b')]);_0x350e28[_0xbe0a('0x30')]=_[_0xbe0a('0x2e')](_0x5bacd7[_0xbe0a('0x2f')],qs[_0xbe0a('0x31')](_0x5b2189['query']['fields']));_0x350e28['attributes']=_0x350e28[_0xbe0a('0x30')]['length']?_0x350e28[_0xbe0a('0x30')]:_0x5bacd7[_0xbe0a('0x2f')];if(_0x5b2189[_0xbe0a('0x2b')]['includeAll']){_0x350e28[_0xbe0a('0x41')]=[{'all':!![]}];}_0x350e28=_[_0xbe0a('0x3a')]({},_0x350e28,_0x5b2189[_0xbe0a('0x3b')]);return db['MailQueueReport'][_0xbe0a('0x42')](_0x350e28)['then'](handleEntityNotFound(_0x2eb033,null))[_0xbe0a('0x21')](respondWithResult(_0x2eb033,null))[_0xbe0a('0x3d')](handleError(_0x2eb033,null));};exports[_0xbe0a('0x43')]=function(_0x4ba270,_0x47d5c5){return db[_0xbe0a('0x28')][_0xbe0a('0x43')](_0x4ba270['body'],{})[_0xbe0a('0x21')](respondWithResult(_0x47d5c5,0xc9))[_0xbe0a('0x3d')](handleError(_0x47d5c5,null));};exports[_0xbe0a('0x44')]=function(_0x43b450,_0x1d3c88){if(_0x43b450['body']['id']){delete _0x43b450[_0xbe0a('0x45')]['id'];}return db[_0xbe0a('0x28')]['find']({'where':{'id':_0x43b450[_0xbe0a('0x3f')]['id']}})[_0xbe0a('0x21')](handleEntityNotFound(_0x1d3c88,null))[_0xbe0a('0x21')](saveUpdates(_0x43b450[_0xbe0a('0x45')],null))[_0xbe0a('0x21')](respondWithResult(_0x1d3c88,null))[_0xbe0a('0x3d')](handleError(_0x1d3c88,null));};exports['destroy']=function(_0x11cff9,_0x1e7cb5){return db[_0xbe0a('0x28')]['find']({'where':{'id':_0x11cff9[_0xbe0a('0x3f')]['id']}})[_0xbe0a('0x21')](handleEntityNotFound(_0x1e7cb5,null))[_0xbe0a('0x21')](removeEntity(_0x1e7cb5,null))[_0xbe0a('0x3d')](handleError(_0x1e7cb5,null));};exports[_0xbe0a('0x46')]=function(_0x230fac,_0x684f86){return db[_0xbe0a('0x28')]['describe']()[_0xbe0a('0x21')](respondWithResult(_0x684f86,null))[_0xbe0a('0x3d')](handleError(_0x684f86,null));};