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 _0xa8d2=['filters','intersection','model','attributes','fields','hasOwnProperty','nolimit','order','where','pick','filter','key','field','merge','options','count','includeAll','include','catch','show','params','find','create','body','describe','html-pdf','eml-format','rimraf','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','to-csv','lodash','squel','crypto','papaparse','ioredis','../../components/auth/service','../../config/license/hardware','api','../../config/environment','status','end','json','offset','limit','set','Content-Range','apply','reject','save','destroy','then','sendStatus','error','stack','name','MailQueueReport','rawAttributes','keys','query'];(function(_0x2d3acf,_0x254c0e){var _0x268e64=function(_0x40a23f){while(--_0x40a23f){_0x2d3acf['push'](_0x2d3acf['shift']());}};_0x268e64(++_0x254c0e);}(_0xa8d2,0x11d));var _0x2a8d=function(_0xc93c3e,_0x295690){_0xc93c3e=_0xc93c3e-0x0;var _0xc8b94b=_0xa8d2[_0xc93c3e];return _0xc8b94b;};'use strict';var pdf=require(_0x2a8d('0x0'));var emlformat=require(_0x2a8d('0x1'));var rimraf=require(_0x2a8d('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0x2a8d('0x3'));var rp=require(_0x2a8d('0x4'));var moment=require('moment');var BPromise=require(_0x2a8d('0x5'));var Mustache=require(_0x2a8d('0x6'));var util=require(_0x2a8d('0x7'));var path=require(_0x2a8d('0x8'));var sox=require(_0x2a8d('0x9'));var csv=require(_0x2a8d('0xa'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x2a8d('0xb'));var squel=require(_0x2a8d('0xc'));var crypto=require(_0x2a8d('0xd'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x2a8d('0xe'));var Redis=require(_0x2a8d('0xf'));var authService=require(_0x2a8d('0x10'));var qs=require('../../components/parsers/qs');var hardwareService=require(_0x2a8d('0x11'));var logger=require('../../config/logger')(_0x2a8d('0x12'));var utils=require('../../config/utils');var config=require(_0x2a8d('0x13'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x3e3e94,_0xd1c2a9){_0xd1c2a9=_0xd1c2a9||0xcc;return function(_0x376a65){if(_0x376a65){return _0x3e3e94['sendStatus'](_0xd1c2a9);}return _0x3e3e94[_0x2a8d('0x14')](_0xd1c2a9)[_0x2a8d('0x15')]();};}function respondWithResult(_0x281a64,_0x5cc0da){_0x5cc0da=_0x5cc0da||0xc8;return function(_0x4a2679){if(_0x4a2679){return _0x281a64[_0x2a8d('0x14')](_0x5cc0da)[_0x2a8d('0x16')](_0x4a2679);}};}function respondWithFilteredResult(_0x3d88db,_0x16df08){return function(_0x299033){if(_0x299033){var _0x27bf09=_0x299033['count'],_0x2b90ec=_0x16df08[_0x2a8d('0x17')],_0x29054f=_0x16df08[_0x2a8d('0x17')]+_0x16df08[_0x2a8d('0x18')],_0x2d3ab0;if(_0x29054f>=_0x27bf09){_0x29054f=_0x27bf09;_0x2d3ab0=0xc8;}else{_0x2d3ab0=0xce;}_0x3d88db['status'](_0x2d3ab0);return _0x3d88db[_0x2a8d('0x19')](_0x2a8d('0x1a'),_0x2b90ec+'-'+_0x29054f+'/'+_0x27bf09)[_0x2a8d('0x16')](_0x299033);}return null;};}function patchUpdates(_0x2becf3){return function(_0x3a02ee){try{jsonpatch[_0x2a8d('0x1b')](_0x3a02ee,_0x2becf3,!![]);}catch(_0x18afa7){return BPromise[_0x2a8d('0x1c')](_0x18afa7);}return _0x3a02ee[_0x2a8d('0x1d')]();};}function saveUpdates(_0x41956b,_0x5bcdab){return function(_0x2d90ba){if(_0x2d90ba){return _0x2d90ba['update'](_0x41956b)['then'](function(_0x8984a8){return _0x8984a8;});}return null;};}function removeEntity(_0x27ecff,_0x37a4ca){return function(_0x1ab0c0){if(_0x1ab0c0){return _0x1ab0c0[_0x2a8d('0x1e')]()[_0x2a8d('0x1f')](function(){_0x27ecff[_0x2a8d('0x14')](0xcc)[_0x2a8d('0x15')]();});}};}function handleEntityNotFound(_0x52adb6,_0x3d509c){return function(_0x3323b5){if(!_0x3323b5){_0x52adb6[_0x2a8d('0x20')](0x194);}return _0x3323b5;};}function handleError(_0x52702a,_0x3bd81a){_0x3bd81a=_0x3bd81a||0x1f4;return function(_0x57c24a){logger[_0x2a8d('0x21')](_0x57c24a[_0x2a8d('0x22')]);if(_0x57c24a[_0x2a8d('0x23')]){delete _0x57c24a[_0x2a8d('0x23')];}_0x52702a[_0x2a8d('0x14')](_0x3bd81a)['send'](_0x57c24a);};}exports['index']=function(_0x49b2dc,_0x54d3d1){var _0x4af68e={},_0x3c57fb={},_0x2b886e={'count':0x0,'rows':[]};var _0xe4f253=db[_0x2a8d('0x24')][_0x2a8d('0x25')];_0x3c57fb['model']=_[_0x2a8d('0x26')](_0xe4f253);_0x3c57fb[_0x2a8d('0x27')]=_[_0x2a8d('0x26')](_0x49b2dc[_0x2a8d('0x27')]);_0x3c57fb[_0x2a8d('0x28')]=_[_0x2a8d('0x29')](_0x3c57fb[_0x2a8d('0x2a')],_0x3c57fb[_0x2a8d('0x27')]);_0x4af68e[_0x2a8d('0x2b')]=_[_0x2a8d('0x29')](_0x3c57fb[_0x2a8d('0x2a')],qs[_0x2a8d('0x2c')](_0x49b2dc[_0x2a8d('0x27')][_0x2a8d('0x2c')]));_0x4af68e[_0x2a8d('0x2b')]=_0x4af68e[_0x2a8d('0x2b')]['length']?_0x4af68e[_0x2a8d('0x2b')]:_0x3c57fb[_0x2a8d('0x2a')];if(!_0x49b2dc[_0x2a8d('0x27')][_0x2a8d('0x2d')](_0x2a8d('0x2e'))){_0x4af68e['limit']=qs['limit'](_0x49b2dc[_0x2a8d('0x27')][_0x2a8d('0x18')]);_0x4af68e[_0x2a8d('0x17')]=qs['offset'](_0x49b2dc[_0x2a8d('0x27')]['offset']);}_0x4af68e[_0x2a8d('0x2f')]=qs['sort'](_0x49b2dc[_0x2a8d('0x27')]['sort']);_0x4af68e[_0x2a8d('0x30')]=qs[_0x2a8d('0x28')](_[_0x2a8d('0x31')](_0x49b2dc['query'],_0x3c57fb[_0x2a8d('0x28')]));if(_0x49b2dc[_0x2a8d('0x27')][_0x2a8d('0x32')]){_0x4af68e[_0x2a8d('0x30')]=_['merge'](_0x4af68e[_0x2a8d('0x30')],{'$or':_['map'](_0xe4f253,function(_0x19cac9){if(_0x19cac9['type'][_0x2a8d('0x33')]!=='VIRTUAL'){var _0x295293={};_0x295293[_0x19cac9[_0x2a8d('0x34')]]={'$like':'%'+_0x49b2dc[_0x2a8d('0x27')][_0x2a8d('0x32')]+'%'};return _0x295293;}})});}_0x4af68e=_[_0x2a8d('0x35')]({},_0x4af68e,_0x49b2dc[_0x2a8d('0x36')]);var _0x28b466={'where':_0x4af68e[_0x2a8d('0x30')]};return db['MailQueueReport'][_0x2a8d('0x37')](_0x28b466)['then'](function(_0x18c762){_0x2b886e[_0x2a8d('0x37')]=_0x18c762;if(_0x49b2dc[_0x2a8d('0x27')][_0x2a8d('0x38')]){_0x4af68e[_0x2a8d('0x39')]=[{'all':!![]}];}return db[_0x2a8d('0x24')]['findAll'](_0x4af68e);})['then'](function(_0x3d47b9){_0x2b886e['rows']=_0x3d47b9;return _0x2b886e;})[_0x2a8d('0x1f')](respondWithFilteredResult(_0x54d3d1,_0x4af68e))[_0x2a8d('0x3a')](handleError(_0x54d3d1,null));};exports[_0x2a8d('0x3b')]=function(_0x5408a8,_0x3fbb00){var _0x4ad13f={'raw':!![],'where':{'id':_0x5408a8[_0x2a8d('0x3c')]['id']}},_0x388fed={};_0x388fed[_0x2a8d('0x2a')]=_[_0x2a8d('0x26')](db[_0x2a8d('0x24')][_0x2a8d('0x25')]);_0x388fed[_0x2a8d('0x27')]=_[_0x2a8d('0x26')](_0x5408a8[_0x2a8d('0x27')]);_0x388fed[_0x2a8d('0x28')]=_[_0x2a8d('0x29')](_0x388fed[_0x2a8d('0x2a')],_0x388fed[_0x2a8d('0x27')]);_0x4ad13f['attributes']=_[_0x2a8d('0x29')](_0x388fed[_0x2a8d('0x2a')],qs[_0x2a8d('0x2c')](_0x5408a8[_0x2a8d('0x27')]['fields']));_0x4ad13f[_0x2a8d('0x2b')]=_0x4ad13f[_0x2a8d('0x2b')]['length']?_0x4ad13f[_0x2a8d('0x2b')]:_0x388fed[_0x2a8d('0x2a')];if(_0x5408a8['query'][_0x2a8d('0x38')]){_0x4ad13f['include']=[{'all':!![]}];}_0x4ad13f=_[_0x2a8d('0x35')]({},_0x4ad13f,_0x5408a8[_0x2a8d('0x36')]);return db[_0x2a8d('0x24')][_0x2a8d('0x3d')](_0x4ad13f)['then'](handleEntityNotFound(_0x3fbb00,null))[_0x2a8d('0x1f')](respondWithResult(_0x3fbb00,null))[_0x2a8d('0x3a')](handleError(_0x3fbb00,null));};exports['create']=function(_0x5a00ad,_0x320863){return db[_0x2a8d('0x24')][_0x2a8d('0x3e')](_0x5a00ad['body'],{})[_0x2a8d('0x1f')](respondWithResult(_0x320863,0xc9))[_0x2a8d('0x3a')](handleError(_0x320863,null));};exports['update']=function(_0xd08330,_0x3b8570){if(_0xd08330[_0x2a8d('0x3f')]['id']){delete _0xd08330['body']['id'];}return db[_0x2a8d('0x24')][_0x2a8d('0x3d')]({'where':{'id':_0xd08330[_0x2a8d('0x3c')]['id']}})[_0x2a8d('0x1f')](handleEntityNotFound(_0x3b8570,null))['then'](saveUpdates(_0xd08330[_0x2a8d('0x3f')],null))['then'](respondWithResult(_0x3b8570,null))[_0x2a8d('0x3a')](handleError(_0x3b8570,null));};exports[_0x2a8d('0x1e')]=function(_0x33ac41,_0x5a7a7b){return db[_0x2a8d('0x24')][_0x2a8d('0x3d')]({'where':{'id':_0x33ac41[_0x2a8d('0x3c')]['id']}})[_0x2a8d('0x1f')](handleEntityNotFound(_0x5a7a7b,null))['then'](removeEntity(_0x5a7a7b,null))[_0x2a8d('0x3a')](handleError(_0x5a7a7b,null));};exports[_0x2a8d('0x40')]=function(_0x425279,_0x191f3c){return db[_0x2a8d('0x24')][_0x2a8d('0x40')]()[_0x2a8d('0x1f')](respondWithResult(_0x191f3c,null))[_0x2a8d('0x3a')](handleError(_0x191f3c,null));};