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 _0xd2bb=['name','send','index','MailQueueReport','model','keys','dateStart','query','dateEnd','filters','intersection','attributes','fields','order','sort','pick','day','add','merge','where','map','key','VIRTUAL','field','filter','count','includeAll','include','findAll','rows','catch','show','rawAttributes','length','create','body','find','params','describe','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','sox','lodash','squel','crypto','to-csv','querystring','papaparse','ioredis','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','offset','limit','json','reject','save','then','destroy','error'];(function(_0x4a7d36,_0x8066f0){var _0x145bcd=function(_0x2dcb3a){while(--_0x2dcb3a){_0x4a7d36['push'](_0x4a7d36['shift']());}};_0x145bcd(++_0x8066f0);}(_0xd2bb,0xb9));var _0xbd2b=function(_0x2e60cf,_0x309262){_0x2e60cf=_0x2e60cf-0x0;var _0xa18531=_0xd2bb[_0x2e60cf];return _0xa18531;};'use strict';var pdf=require(_0xbd2b('0x0'));var emlformat=require(_0xbd2b('0x1'));var rimraf=require(_0xbd2b('0x2'));var zipdir=require(_0xbd2b('0x3'));var jsonpatch=require(_0xbd2b('0x4'));var rp=require(_0xbd2b('0x5'));var moment=require('moment');var BPromise=require(_0xbd2b('0x6'));var Mustache=require(_0xbd2b('0x7'));var util=require(_0xbd2b('0x8'));var path=require('path');var sox=require(_0xbd2b('0x9'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var _=require(_0xbd2b('0xa'));var squel=require(_0xbd2b('0xb'));var crypto=require(_0xbd2b('0xc'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0xbd2b('0xd'));var querystring=require(_0xbd2b('0xe'));var Papa=require(_0xbd2b('0xf'));var Redis=require(_0xbd2b('0x10'));var qs=require(_0xbd2b('0x11'));var logger=require(_0xbd2b('0x12'))(_0xbd2b('0x13'));var utils=require(_0xbd2b('0x14'));var config=require(_0xbd2b('0x15'));var db=require(_0xbd2b('0x16'))['db'];function respondWithStatusCode(_0x652d4d,_0x37d497){_0x37d497=_0x37d497||0xcc;return function(_0x5014fa){if(_0x5014fa){return _0x652d4d[_0xbd2b('0x17')](_0x37d497);}return _0x652d4d[_0xbd2b('0x18')](_0x37d497)[_0xbd2b('0x19')]();};}function respondWithResult(_0x3c3e3f,_0x562665){_0x562665=_0x562665||0xc8;return function(_0x2a04a2){if(_0x2a04a2){return _0x3c3e3f[_0xbd2b('0x18')](_0x562665)['json'](_0x2a04a2);}};}function respondWithFilteredResult(_0x2888bd,_0x5f9c56){return function(_0x3111b8){if(_0x3111b8){var _0x256be=_0x3111b8['count'],_0x153b60=_0x5f9c56[_0xbd2b('0x1a')],_0x2d054a=_0x5f9c56['offset']+_0x5f9c56[_0xbd2b('0x1b')],_0x2dd6b6;if(_0x2d054a>=_0x256be){_0x2d054a=_0x256be;_0x2dd6b6=0xc8;}else{_0x2dd6b6=0xce;}_0x2888bd[_0xbd2b('0x18')](_0x2dd6b6);return _0x2888bd['set']('Content-Range',_0x153b60+'-'+_0x2d054a+'/'+_0x256be)[_0xbd2b('0x1c')](_0x3111b8);}return null;};}function patchUpdates(_0x4aed10){return function(_0x513de4){try{jsonpatch['apply'](_0x513de4,_0x4aed10,!![]);}catch(_0x326f44){return BPromise[_0xbd2b('0x1d')](_0x326f44);}return _0x513de4[_0xbd2b('0x1e')]();};}function saveUpdates(_0x32f676,_0x4fb501){return function(_0x2cabe2){if(_0x2cabe2){return _0x2cabe2['update'](_0x32f676)[_0xbd2b('0x1f')](function(_0x1b71e2){return _0x1b71e2;});}return null;};}function removeEntity(_0x1a3d57,_0x1681a9){return function(_0x3b0b04){if(_0x3b0b04){return _0x3b0b04[_0xbd2b('0x20')]()[_0xbd2b('0x1f')](function(){_0x1a3d57[_0xbd2b('0x18')](0xcc)[_0xbd2b('0x19')]();});}};}function handleEntityNotFound(_0x42b9f9,_0x2486f8){return function(_0x2b69ae){if(!_0x2b69ae){_0x42b9f9[_0xbd2b('0x17')](0x194);}return _0x2b69ae;};}function handleError(_0x261937,_0x5acbbc){_0x5acbbc=_0x5acbbc||0x1f4;return function(_0x342f79){logger[_0xbd2b('0x21')](_0x342f79['stack']);if(_0x342f79[_0xbd2b('0x22')]){delete _0x342f79['name'];}_0x261937[_0xbd2b('0x18')](_0x5acbbc)[_0xbd2b('0x23')](_0x342f79);};}exports[_0xbd2b('0x24')]=function(_0x5c1c87,_0xfaacec){var _0x5ee171={},_0x40e300={},_0xa0c63a={'count':0x0,'rows':[]};var _0x22fc02=db[_0xbd2b('0x25')]['rawAttributes'];_0x40e300[_0xbd2b('0x26')]=_[_0xbd2b('0x27')](_0x22fc02);var _0x49871c={'dateStart':_0x5c1c87['query'][_0xbd2b('0x28')],'dateEnd':_0x5c1c87[_0xbd2b('0x29')]['dateEnd']};delete _0x5c1c87[_0xbd2b('0x29')]['dateStart'];delete _0x5c1c87[_0xbd2b('0x29')][_0xbd2b('0x2a')];_0x40e300['query']=_['keys'](_0x5c1c87[_0xbd2b('0x29')]);_0x40e300[_0xbd2b('0x2b')]=_[_0xbd2b('0x2c')](_0x40e300['model'],_0x40e300['query']);_0x5ee171[_0xbd2b('0x2d')]=_[_0xbd2b('0x2c')](_0x40e300[_0xbd2b('0x26')],qs[_0xbd2b('0x2e')](_0x5c1c87['query'][_0xbd2b('0x2e')]));_0x5ee171[_0xbd2b('0x2d')]=_0x5ee171[_0xbd2b('0x2d')]['length']?_0x5ee171['attributes']:_0x40e300[_0xbd2b('0x26')];if(!_0x5c1c87[_0xbd2b('0x29')]['hasOwnProperty']('nolimit')){_0x5ee171[_0xbd2b('0x1b')]=qs[_0xbd2b('0x1b')](_0x5c1c87[_0xbd2b('0x29')]['limit']);_0x5ee171[_0xbd2b('0x1a')]=qs[_0xbd2b('0x1a')](_0x5c1c87[_0xbd2b('0x29')]['offset']);}_0x5ee171[_0xbd2b('0x2f')]=qs[_0xbd2b('0x30')](_0x5c1c87['query'][_0xbd2b('0x30')]);_0x5ee171['where']=qs[_0xbd2b('0x2b')](_[_0xbd2b('0x31')](_0x5c1c87['query'],_0x40e300['filters']));if(_0x49871c['dateStart']){if(_0x49871c['dateEnd']){_0x49871c['dateEnd']=moment(_0x49871c[_0xbd2b('0x2a')])['add'](0x1,_0xbd2b('0x32'));}else{_0x49871c[_0xbd2b('0x2a')]=moment(_0x49871c[_0xbd2b('0x28')])[_0xbd2b('0x33')](0x1,_0xbd2b('0x32'));}_[_0xbd2b('0x34')](_0x5ee171[_0xbd2b('0x35')],{'createdAt':{'$gte':_0x49871c[_0xbd2b('0x28')],'$lte':_0x49871c['dateEnd']}});}if(_0x5c1c87[_0xbd2b('0x29')]['filter']){_0x5ee171['where']=_[_0xbd2b('0x34')](_0x5ee171[_0xbd2b('0x35')],{'$or':_[_0xbd2b('0x36')](_0x22fc02,function(_0x2c5420){if(_0x2c5420['type'][_0xbd2b('0x37')]!==_0xbd2b('0x38')){var _0x35f67b={};_0x35f67b[_0x2c5420[_0xbd2b('0x39')]]={'$like':'%'+_0x5c1c87[_0xbd2b('0x29')][_0xbd2b('0x3a')]+'%'};return _0x35f67b;}})});}_0x5ee171=_['merge']({},_0x5ee171,_0x5c1c87['options']);var _0x1f6e3f={'where':_0x5ee171[_0xbd2b('0x35')]};return db[_0xbd2b('0x25')][_0xbd2b('0x3b')](_0x1f6e3f)[_0xbd2b('0x1f')](function(_0x202f16){_0xa0c63a[_0xbd2b('0x3b')]=_0x202f16;if(_0x5c1c87[_0xbd2b('0x29')][_0xbd2b('0x3c')]){_0x5ee171[_0xbd2b('0x3d')]=[{'all':!![]}];}return db[_0xbd2b('0x25')][_0xbd2b('0x3e')](_0x5ee171);})[_0xbd2b('0x1f')](function(_0x3ade08){_0xa0c63a[_0xbd2b('0x3f')]=_0x3ade08;return _0xa0c63a;})['then'](respondWithFilteredResult(_0xfaacec,_0x5ee171))[_0xbd2b('0x40')](handleError(_0xfaacec,null));};exports[_0xbd2b('0x41')]=function(_0x443ab6,_0x52777f){var _0x215e72={'raw':!![],'where':{'id':_0x443ab6['params']['id']}},_0x4c26dc={};_0x4c26dc[_0xbd2b('0x26')]=_[_0xbd2b('0x27')](db[_0xbd2b('0x25')][_0xbd2b('0x42')]);_0x4c26dc[_0xbd2b('0x29')]=_[_0xbd2b('0x27')](_0x443ab6['query']);_0x4c26dc[_0xbd2b('0x2b')]=_[_0xbd2b('0x2c')](_0x4c26dc[_0xbd2b('0x26')],_0x4c26dc['query']);_0x215e72['attributes']=_[_0xbd2b('0x2c')](_0x4c26dc[_0xbd2b('0x26')],qs[_0xbd2b('0x2e')](_0x443ab6['query'][_0xbd2b('0x2e')]));_0x215e72[_0xbd2b('0x2d')]=_0x215e72[_0xbd2b('0x2d')][_0xbd2b('0x43')]?_0x215e72[_0xbd2b('0x2d')]:_0x4c26dc[_0xbd2b('0x26')];if(_0x443ab6['query'][_0xbd2b('0x3c')]){_0x215e72[_0xbd2b('0x3d')]=[{'all':!![]}];}_0x215e72=_[_0xbd2b('0x34')]({},_0x215e72,_0x443ab6['options']);return db[_0xbd2b('0x25')]['find'](_0x215e72)['then'](handleEntityNotFound(_0x52777f,null))[_0xbd2b('0x1f')](respondWithResult(_0x52777f,null))['catch'](handleError(_0x52777f,null));};exports['create']=function(_0x326e0d,_0x3bfd22){return db[_0xbd2b('0x25')][_0xbd2b('0x44')](_0x326e0d[_0xbd2b('0x45')],{})[_0xbd2b('0x1f')](respondWithResult(_0x3bfd22,0xc9))['catch'](handleError(_0x3bfd22,null));};exports['update']=function(_0x10f413,_0x115ddb){if(_0x10f413[_0xbd2b('0x45')]['id']){delete _0x10f413[_0xbd2b('0x45')]['id'];}return db[_0xbd2b('0x25')][_0xbd2b('0x46')]({'where':{'id':_0x10f413[_0xbd2b('0x47')]['id']}})[_0xbd2b('0x1f')](handleEntityNotFound(_0x115ddb,null))[_0xbd2b('0x1f')](saveUpdates(_0x10f413[_0xbd2b('0x45')],null))['then'](respondWithResult(_0x115ddb,null))['catch'](handleError(_0x115ddb,null));};exports[_0xbd2b('0x20')]=function(_0x53ad46,_0x443132){return db[_0xbd2b('0x25')]['find']({'where':{'id':_0x53ad46[_0xbd2b('0x47')]['id']}})['then'](handleEntityNotFound(_0x443132,null))[_0xbd2b('0x1f')](removeEntity(_0x443132,null))[_0xbd2b('0x40')](handleError(_0x443132,null));};exports['describe']=function(_0x18feda,_0x4cd3df){return db['MailQueueReport'][_0xbd2b('0x48')]()[_0xbd2b('0x1f')](respondWithResult(_0x4cd3df,null))[_0xbd2b('0x40')](handleError(_0x4cd3df,null));};