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 _0x2553=['reject','destroy','then','name','send','index','MailQueueReport','rawAttributes','keys','query','dateStart','dateEnd','filters','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','offset','order','sort','where','pick','add','day','merge','filter','map','options','includeAll','include','findAll','params','find','catch','create','update','body','describe','html-pdf','eml-format','zip-dir','fast-json-patch','request-promise','moment','path','sox','to-csv','ejs','squel','crypto','jsforce','papaparse','../../config/logger','../../config/environment','../../mysqldb','sendStatus','status','end','json','count','limit','set','apply'];(function(_0x4a747d,_0x3b747f){var _0x3a5b5c=function(_0x4b3e81){while(--_0x4b3e81){_0x4a747d['push'](_0x4a747d['shift']());}};_0x3a5b5c(++_0x3b747f);}(_0x2553,0x1b5));var _0x3255=function(_0x37d718,_0x4b5779){_0x37d718=_0x37d718-0x0;var _0x1b650a=_0x2553[_0x37d718];return _0x1b650a;};'use strict';var pdf=require(_0x3255('0x0'));var emlformat=require(_0x3255('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x3255('0x2'));var jsonpatch=require(_0x3255('0x3'));var rp=require(_0x3255('0x4'));var moment=require(_0x3255('0x5'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require('util');var path=require(_0x3255('0x6'));var sox=require(_0x3255('0x7'));var csv=require(_0x3255('0x8'));var ejs=require(_0x3255('0x9'));var fs=require('fs');var _=require('lodash');var squel=require(_0x3255('0xa'));var crypto=require(_0x3255('0xb'));var jsforce=require(_0x3255('0xc'));var deskjs=require('desk.js');var toCsv=require(_0x3255('0x8'));var querystring=require('querystring');var Papa=require(_0x3255('0xd'));var qs=require('../../components/parsers/qs');var logger=require(_0x3255('0xe'))('api');var utils=require('../../config/utils');var config=require(_0x3255('0xf'));var db=require(_0x3255('0x10'))['db'];function respondWithStatusCode(_0x120651,_0x3e898){_0x3e898=_0x3e898||0xcc;return function(_0x456369){if(_0x456369){return _0x120651[_0x3255('0x11')](_0x3e898);}return _0x120651[_0x3255('0x12')](_0x3e898)[_0x3255('0x13')]();};}function respondWithResult(_0x214216,_0x406fb1){_0x406fb1=_0x406fb1||0xc8;return function(_0x51c371){if(_0x51c371){return _0x214216['status'](_0x406fb1)[_0x3255('0x14')](_0x51c371);}};}function respondWithFilteredResult(_0x2b63b9,_0x5bb3c4){return function(_0x1ec6f4){if(_0x1ec6f4){var _0x383087=_0x1ec6f4[_0x3255('0x15')],_0x574f18=_0x5bb3c4['offset'],_0x5e9e46=_0x5bb3c4['offset']+_0x5bb3c4[_0x3255('0x16')],_0x1b212e;if(_0x5e9e46>=_0x383087){_0x5e9e46=_0x383087;_0x1b212e=0xc8;}else{_0x1b212e=0xce;}_0x2b63b9[_0x3255('0x12')](_0x1b212e);return _0x2b63b9[_0x3255('0x17')]('Content-Range',_0x574f18+'-'+_0x5e9e46+'/'+_0x383087)[_0x3255('0x14')](_0x1ec6f4);}return null;};}function patchUpdates(_0x4a6d99){return function(_0x11bb8a){try{jsonpatch[_0x3255('0x18')](_0x11bb8a,_0x4a6d99,!![]);}catch(_0x1a2ea0){return BPromise[_0x3255('0x19')](_0x1a2ea0);}return _0x11bb8a['save']();};}function saveUpdates(_0x2922ad,_0x1f70f8){return function(_0x394079){if(_0x394079){return _0x394079['update'](_0x2922ad)['then'](function(_0x2f31e2){return _0x2f31e2;});}return null;};}function removeEntity(_0x1262de,_0x25b273){return function(_0x2d86b5){if(_0x2d86b5){return _0x2d86b5[_0x3255('0x1a')]()[_0x3255('0x1b')](function(){_0x1262de[_0x3255('0x12')](0xcc)[_0x3255('0x13')]();});}};}function handleEntityNotFound(_0x446908,_0x2c03b5){return function(_0x6c9ad0){if(!_0x6c9ad0){_0x446908[_0x3255('0x11')](0x194);}return _0x6c9ad0;};}function handleError(_0x43c572,_0xb36ca0){_0xb36ca0=_0xb36ca0||0x1f4;return function(_0x49d478){logger['error'](_0x49d478['stack']);if(_0x49d478[_0x3255('0x1c')]){delete _0x49d478[_0x3255('0x1c')];}_0x43c572[_0x3255('0x12')](_0xb36ca0)[_0x3255('0x1d')](_0x49d478);};}exports[_0x3255('0x1e')]=function(_0x4936d5,_0xc47494){var _0x45cec8={},_0x884625={},_0x5aaebf={'count':0x0,'rows':[]};var _0x112e99=db[_0x3255('0x1f')][_0x3255('0x20')];_0x884625['model']=_[_0x3255('0x21')](_0x112e99);var _0x245f57={'dateStart':_0x4936d5[_0x3255('0x22')][_0x3255('0x23')],'dateEnd':_0x4936d5['query'][_0x3255('0x24')]};delete _0x4936d5[_0x3255('0x22')][_0x3255('0x23')];delete _0x4936d5[_0x3255('0x22')][_0x3255('0x24')];_0x884625[_0x3255('0x22')]=_[_0x3255('0x21')](_0x4936d5['query']);_0x884625[_0x3255('0x25')]=_[_0x3255('0x26')](_0x884625[_0x3255('0x27')],_0x884625[_0x3255('0x22')]);_0x45cec8[_0x3255('0x28')]=_[_0x3255('0x26')](_0x884625[_0x3255('0x27')],qs['fields'](_0x4936d5[_0x3255('0x22')][_0x3255('0x29')]));_0x45cec8[_0x3255('0x28')]=_0x45cec8[_0x3255('0x28')][_0x3255('0x2a')]?_0x45cec8[_0x3255('0x28')]:_0x884625['model'];if(!_0x4936d5[_0x3255('0x22')][_0x3255('0x2b')](_0x3255('0x2c'))){_0x45cec8['limit']=qs[_0x3255('0x16')](_0x4936d5[_0x3255('0x22')][_0x3255('0x16')]);_0x45cec8[_0x3255('0x2d')]=qs[_0x3255('0x2d')](_0x4936d5[_0x3255('0x22')][_0x3255('0x2d')]);}_0x45cec8[_0x3255('0x2e')]=qs[_0x3255('0x2f')](_0x4936d5['query'][_0x3255('0x2f')]);_0x45cec8[_0x3255('0x30')]=qs[_0x3255('0x25')](_[_0x3255('0x31')](_0x4936d5[_0x3255('0x22')],_0x884625[_0x3255('0x25')]));if(_0x245f57[_0x3255('0x23')]){if(_0x245f57[_0x3255('0x24')]){_0x245f57[_0x3255('0x24')]=moment(_0x245f57[_0x3255('0x24')])[_0x3255('0x32')](0x1,_0x3255('0x33'));}else{_0x245f57[_0x3255('0x24')]=moment(_0x245f57['dateStart'])[_0x3255('0x32')](0x1,'day');}_[_0x3255('0x34')](_0x45cec8[_0x3255('0x30')],{'createdAt':{'$gte':_0x245f57[_0x3255('0x23')],'$lte':_0x245f57[_0x3255('0x24')]}});}if(_0x4936d5[_0x3255('0x22')][_0x3255('0x35')]){_0x45cec8['where']=_[_0x3255('0x34')](_0x45cec8['where'],{'$or':_[_0x3255('0x36')](_0x45cec8[_0x3255('0x28')],function(_0x5a77a4){var _0x5396b0={};_0x5396b0[_0x5a77a4]={'$like':'%'+_0x4936d5[_0x3255('0x22')][_0x3255('0x35')]+'%'};return _0x5396b0;})});}_0x45cec8=_[_0x3255('0x34')]({},_0x45cec8,_0x4936d5[_0x3255('0x37')]);var _0x2255cb={'where':_0x45cec8[_0x3255('0x30')]};return db['MailQueueReport']['count'](_0x2255cb)[_0x3255('0x1b')](function(_0x5d7287){_0x5aaebf[_0x3255('0x15')]=_0x5d7287;if(_0x4936d5[_0x3255('0x22')][_0x3255('0x38')]){_0x45cec8[_0x3255('0x39')]=[{'all':!![]}];}return db[_0x3255('0x1f')][_0x3255('0x3a')](_0x45cec8);})[_0x3255('0x1b')](function(_0x2ea143){_0x5aaebf['rows']=_0x2ea143;return _0x5aaebf;})[_0x3255('0x1b')](respondWithFilteredResult(_0xc47494,_0x45cec8))['catch'](handleError(_0xc47494,null));};exports['show']=function(_0x2ec780,_0x5ea0cd){var _0x3e4bf7={'raw':!![],'where':{'id':_0x2ec780[_0x3255('0x3b')]['id']}},_0x4aabbd={};_0x4aabbd[_0x3255('0x27')]=_['keys'](db['MailQueueReport'][_0x3255('0x20')]);_0x4aabbd[_0x3255('0x22')]=_[_0x3255('0x21')](_0x2ec780[_0x3255('0x22')]);_0x4aabbd[_0x3255('0x25')]=_['intersection'](_0x4aabbd[_0x3255('0x27')],_0x4aabbd[_0x3255('0x22')]);_0x3e4bf7['attributes']=_[_0x3255('0x26')](_0x4aabbd['model'],qs[_0x3255('0x29')](_0x2ec780['query'][_0x3255('0x29')]));_0x3e4bf7['attributes']=_0x3e4bf7['attributes']['length']?_0x3e4bf7[_0x3255('0x28')]:_0x4aabbd[_0x3255('0x27')];if(_0x2ec780['query'][_0x3255('0x38')]){_0x3e4bf7[_0x3255('0x39')]=[{'all':!![]}];}_0x3e4bf7=_[_0x3255('0x34')]({},_0x3e4bf7,_0x2ec780[_0x3255('0x37')]);return db[_0x3255('0x1f')][_0x3255('0x3c')](_0x3e4bf7)[_0x3255('0x1b')](handleEntityNotFound(_0x5ea0cd,null))[_0x3255('0x1b')](respondWithResult(_0x5ea0cd,null))[_0x3255('0x3d')](handleError(_0x5ea0cd,null));};exports[_0x3255('0x3e')]=function(_0x4545e8,_0x1145fc){return db[_0x3255('0x1f')]['create'](_0x4545e8['body'],{})[_0x3255('0x1b')](respondWithResult(_0x1145fc,0xc9))[_0x3255('0x3d')](handleError(_0x1145fc,null));};exports[_0x3255('0x3f')]=function(_0x5dd2b4,_0x599949){if(_0x5dd2b4[_0x3255('0x40')]['id']){delete _0x5dd2b4[_0x3255('0x40')]['id'];}return db[_0x3255('0x1f')]['find']({'where':{'id':_0x5dd2b4['params']['id']}})[_0x3255('0x1b')](handleEntityNotFound(_0x599949,null))[_0x3255('0x1b')](saveUpdates(_0x5dd2b4[_0x3255('0x40')],null))[_0x3255('0x1b')](respondWithResult(_0x599949,null))[_0x3255('0x3d')](handleError(_0x599949,null));};exports[_0x3255('0x1a')]=function(_0x41a6ab,_0x3e6e5b){return db[_0x3255('0x1f')][_0x3255('0x3c')]({'where':{'id':_0x41a6ab[_0x3255('0x3b')]['id']}})[_0x3255('0x1b')](handleEntityNotFound(_0x3e6e5b,null))[_0x3255('0x1b')](removeEntity(_0x3e6e5b,null))[_0x3255('0x3d')](handleError(_0x3e6e5b,null));};exports[_0x3255('0x41')]=function(_0x5c8c24,_0xc9526e){return db[_0x3255('0x1f')][_0x3255('0x41')]()[_0x3255('0x1b')](respondWithResult(_0xc9526e,null))[_0x3255('0x3d')](handleError(_0xc9526e,null));};