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 _0x2b29=['querystring','papaparse','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','json','offset','Content-Range','apply','reject','save','update','then','end','error','stack','name','send','MailQueueReport','rawAttributes','keys','query','dateStart','dateEnd','filters','intersection','attributes','model','fields','length','hasOwnProperty','nolimit','limit','order','where','add','merge','filter','map','key','VIRTUAL','field','count','includeAll','include','rows','options','find','catch','create','body','destroy','params','describe','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','ejs','squel','crypto','desk.js','to-csv'];(function(_0x4b975b,_0x3b1e75){var _0x4cbdf3=function(_0x30b817){while(--_0x30b817){_0x4b975b['push'](_0x4b975b['shift']());}};_0x4cbdf3(++_0x3b1e75);}(_0x2b29,0x163));var _0x92b2=function(_0x2b8df8,_0x450756){_0x2b8df8=_0x2b8df8-0x0;var _0x14d355=_0x2b29[_0x2b8df8];return _0x14d355;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x92b2('0x0'));var rimraf=require(_0x92b2('0x1'));var zipdir=require(_0x92b2('0x2'));var jsonpatch=require(_0x92b2('0x3'));var rp=require('request-promise');var moment=require(_0x92b2('0x4'));var BPromise=require(_0x92b2('0x5'));var Mustache=require(_0x92b2('0x6'));var util=require(_0x92b2('0x7'));var path=require(_0x92b2('0x8'));var sox=require(_0x92b2('0x9'));var csv=require('to-csv');var ejs=require(_0x92b2('0xa'));var fs=require('fs');var _=require('lodash');var squel=require(_0x92b2('0xb'));var crypto=require(_0x92b2('0xc'));var jsforce=require('jsforce');var deskjs=require(_0x92b2('0xd'));var toCsv=require(_0x92b2('0xe'));var querystring=require(_0x92b2('0xf'));var Papa=require(_0x92b2('0x10'));var Redis=require('ioredis');var qs=require(_0x92b2('0x11'));var logger=require(_0x92b2('0x12'))(_0x92b2('0x13'));var utils=require(_0x92b2('0x14'));var config=require(_0x92b2('0x15'));var db=require(_0x92b2('0x16'))['db'];function respondWithStatusCode(_0xa18d4e,_0x492e48){_0x492e48=_0x492e48||0xcc;return function(_0x3e6a2a){if(_0x3e6a2a){return _0xa18d4e[_0x92b2('0x17')](_0x492e48);}return _0xa18d4e[_0x92b2('0x18')](_0x492e48)['end']();};}function respondWithResult(_0x1b7dd6,_0x3e5309){_0x3e5309=_0x3e5309||0xc8;return function(_0x3c5db1){if(_0x3c5db1){return _0x1b7dd6[_0x92b2('0x18')](_0x3e5309)[_0x92b2('0x19')](_0x3c5db1);}};}function respondWithFilteredResult(_0x179834,_0x52ef07){return function(_0x11e175){if(_0x11e175){var _0x5c42b5=_0x11e175['count'],_0x299a9d=_0x52ef07['offset'],_0x2be641=_0x52ef07[_0x92b2('0x1a')]+_0x52ef07['limit'],_0x2ac0c8;if(_0x2be641>=_0x5c42b5){_0x2be641=_0x5c42b5;_0x2ac0c8=0xc8;}else{_0x2ac0c8=0xce;}_0x179834[_0x92b2('0x18')](_0x2ac0c8);return _0x179834['set'](_0x92b2('0x1b'),_0x299a9d+'-'+_0x2be641+'/'+_0x5c42b5)[_0x92b2('0x19')](_0x11e175);}return null;};}function patchUpdates(_0x39d811){return function(_0xceaa2f){try{jsonpatch[_0x92b2('0x1c')](_0xceaa2f,_0x39d811,!![]);}catch(_0x3dfd47){return BPromise[_0x92b2('0x1d')](_0x3dfd47);}return _0xceaa2f[_0x92b2('0x1e')]();};}function saveUpdates(_0x21bc07,_0xa08831){return function(_0xfd81c5){if(_0xfd81c5){return _0xfd81c5[_0x92b2('0x1f')](_0x21bc07)[_0x92b2('0x20')](function(_0x422ab6){return _0x422ab6;});}return null;};}function removeEntity(_0x2f0e68,_0x4d2850){return function(_0x46078b){if(_0x46078b){return _0x46078b['destroy']()[_0x92b2('0x20')](function(){_0x2f0e68[_0x92b2('0x18')](0xcc)[_0x92b2('0x21')]();});}};}function handleEntityNotFound(_0x1e09b6,_0x13f46b){return function(_0x574c3e){if(!_0x574c3e){_0x1e09b6['sendStatus'](0x194);}return _0x574c3e;};}function handleError(_0x131b6b,_0x31567c){_0x31567c=_0x31567c||0x1f4;return function(_0x8ed58d){logger[_0x92b2('0x22')](_0x8ed58d[_0x92b2('0x23')]);if(_0x8ed58d[_0x92b2('0x24')]){delete _0x8ed58d[_0x92b2('0x24')];}_0x131b6b[_0x92b2('0x18')](_0x31567c)[_0x92b2('0x25')](_0x8ed58d);};}exports['index']=function(_0xd31d50,_0x57c1ff){var _0x183f81={},_0x4a587f={},_0x5e9688={'count':0x0,'rows':[]};var _0x105270=db[_0x92b2('0x26')][_0x92b2('0x27')];_0x4a587f['model']=_[_0x92b2('0x28')](_0x105270);var _0x482706={'dateStart':_0xd31d50[_0x92b2('0x29')][_0x92b2('0x2a')],'dateEnd':_0xd31d50[_0x92b2('0x29')][_0x92b2('0x2b')]};delete _0xd31d50[_0x92b2('0x29')][_0x92b2('0x2a')];delete _0xd31d50[_0x92b2('0x29')]['dateEnd'];_0x4a587f['query']=_['keys'](_0xd31d50[_0x92b2('0x29')]);_0x4a587f[_0x92b2('0x2c')]=_[_0x92b2('0x2d')](_0x4a587f['model'],_0x4a587f['query']);_0x183f81[_0x92b2('0x2e')]=_[_0x92b2('0x2d')](_0x4a587f[_0x92b2('0x2f')],qs[_0x92b2('0x30')](_0xd31d50[_0x92b2('0x29')]['fields']));_0x183f81['attributes']=_0x183f81['attributes'][_0x92b2('0x31')]?_0x183f81[_0x92b2('0x2e')]:_0x4a587f['model'];if(!_0xd31d50[_0x92b2('0x29')][_0x92b2('0x32')](_0x92b2('0x33'))){_0x183f81[_0x92b2('0x34')]=qs[_0x92b2('0x34')](_0xd31d50[_0x92b2('0x29')][_0x92b2('0x34')]);_0x183f81[_0x92b2('0x1a')]=qs['offset'](_0xd31d50[_0x92b2('0x29')][_0x92b2('0x1a')]);}_0x183f81[_0x92b2('0x35')]=qs['sort'](_0xd31d50[_0x92b2('0x29')]['sort']);_0x183f81[_0x92b2('0x36')]=qs[_0x92b2('0x2c')](_['pick'](_0xd31d50['query'],_0x4a587f[_0x92b2('0x2c')]));if(_0x482706[_0x92b2('0x2a')]){if(_0x482706['dateEnd']){_0x482706['dateEnd']=moment(_0x482706[_0x92b2('0x2b')])[_0x92b2('0x37')](0x1,'day');}else{_0x482706[_0x92b2('0x2b')]=moment(_0x482706[_0x92b2('0x2a')])[_0x92b2('0x37')](0x1,'day');}_[_0x92b2('0x38')](_0x183f81['where'],{'createdAt':{'$gte':_0x482706[_0x92b2('0x2a')],'$lte':_0x482706[_0x92b2('0x2b')]}});}if(_0xd31d50[_0x92b2('0x29')][_0x92b2('0x39')]){_0x183f81[_0x92b2('0x36')]=_[_0x92b2('0x38')](_0x183f81['where'],{'$or':_[_0x92b2('0x3a')](_0x105270,function(_0x35ca4d){if(_0x35ca4d['type'][_0x92b2('0x3b')]!==_0x92b2('0x3c')){var _0x129af1={};_0x129af1[_0x35ca4d[_0x92b2('0x3d')]]={'$like':'%'+_0xd31d50[_0x92b2('0x29')][_0x92b2('0x39')]+'%'};return _0x129af1;}})});}_0x183f81=_[_0x92b2('0x38')]({},_0x183f81,_0xd31d50['options']);var _0x19efe0={'where':_0x183f81['where']};return db[_0x92b2('0x26')]['count'](_0x19efe0)[_0x92b2('0x20')](function(_0xefc848){_0x5e9688[_0x92b2('0x3e')]=_0xefc848;if(_0xd31d50['query'][_0x92b2('0x3f')]){_0x183f81[_0x92b2('0x40')]=[{'all':!![]}];}return db[_0x92b2('0x26')]['findAll'](_0x183f81);})[_0x92b2('0x20')](function(_0x19fe8f){_0x5e9688[_0x92b2('0x41')]=_0x19fe8f;return _0x5e9688;})[_0x92b2('0x20')](respondWithFilteredResult(_0x57c1ff,_0x183f81))['catch'](handleError(_0x57c1ff,null));};exports['show']=function(_0x49ca54,_0x399bb7){var _0x150958={'raw':!![],'where':{'id':_0x49ca54['params']['id']}},_0x423c41={};_0x423c41[_0x92b2('0x2f')]=_['keys'](db[_0x92b2('0x26')][_0x92b2('0x27')]);_0x423c41[_0x92b2('0x29')]=_[_0x92b2('0x28')](_0x49ca54[_0x92b2('0x29')]);_0x423c41[_0x92b2('0x2c')]=_[_0x92b2('0x2d')](_0x423c41[_0x92b2('0x2f')],_0x423c41[_0x92b2('0x29')]);_0x150958[_0x92b2('0x2e')]=_[_0x92b2('0x2d')](_0x423c41[_0x92b2('0x2f')],qs['fields'](_0x49ca54[_0x92b2('0x29')]['fields']));_0x150958[_0x92b2('0x2e')]=_0x150958['attributes'][_0x92b2('0x31')]?_0x150958[_0x92b2('0x2e')]:_0x423c41[_0x92b2('0x2f')];if(_0x49ca54['query'][_0x92b2('0x3f')]){_0x150958['include']=[{'all':!![]}];}_0x150958=_[_0x92b2('0x38')]({},_0x150958,_0x49ca54[_0x92b2('0x42')]);return db['MailQueueReport'][_0x92b2('0x43')](_0x150958)[_0x92b2('0x20')](handleEntityNotFound(_0x399bb7,null))[_0x92b2('0x20')](respondWithResult(_0x399bb7,null))[_0x92b2('0x44')](handleError(_0x399bb7,null));};exports[_0x92b2('0x45')]=function(_0x7d6dcf,_0x2c4531){return db[_0x92b2('0x26')][_0x92b2('0x45')](_0x7d6dcf[_0x92b2('0x46')],{})[_0x92b2('0x20')](respondWithResult(_0x2c4531,0xc9))[_0x92b2('0x44')](handleError(_0x2c4531,null));};exports[_0x92b2('0x1f')]=function(_0x12f255,_0x563ded){if(_0x12f255[_0x92b2('0x46')]['id']){delete _0x12f255[_0x92b2('0x46')]['id'];}return db['MailQueueReport']['find']({'where':{'id':_0x12f255['params']['id']}})[_0x92b2('0x20')](handleEntityNotFound(_0x563ded,null))[_0x92b2('0x20')](saveUpdates(_0x12f255['body'],null))['then'](respondWithResult(_0x563ded,null))['catch'](handleError(_0x563ded,null));};exports[_0x92b2('0x47')]=function(_0x1cb272,_0x4265f6){return db[_0x92b2('0x26')][_0x92b2('0x43')]({'where':{'id':_0x1cb272[_0x92b2('0x48')]['id']}})[_0x92b2('0x20')](handleEntityNotFound(_0x4265f6,null))[_0x92b2('0x20')](removeEntity(_0x4265f6,null))['catch'](handleError(_0x4265f6,null));};exports['describe']=function(_0x4dd900,_0x32fa61){return db['MailQueueReport'][_0x92b2('0x49')]()['then'](respondWithResult(_0x32fa61,null))[_0x92b2('0x44')](handleError(_0x32fa61,null));};