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 _0xb52a=['destroy','error','stack','name','index','MailQueueReport','rawAttributes','model','keys','dateStart','query','dateEnd','filters','attributes','intersection','fields','length','hasOwnProperty','nolimit','sort','where','pick','add','day','merge','map','type','key','VIRTUAL','field','filter','options','includeAll','include','rows','show','params','find','catch','create','body','describe','eml-format','rimraf','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','lodash','crypto','jsforce','desk.js','papaparse','ioredis','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','json','count','offset','limit','set','Content-Range','reject','save','update','then'];(function(_0x2c3733,_0xb35501){var _0x5d7d42=function(_0xce1673){while(--_0xce1673){_0x2c3733['push'](_0x2c3733['shift']());}};_0x5d7d42(++_0xb35501);}(_0xb52a,0x76));var _0xab52=function(_0x55677b,_0x3e5655){_0x55677b=_0x55677b-0x0;var _0x104b88=_0xb52a[_0x55677b];return _0x104b88;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0xab52('0x0'));var rimraf=require(_0xab52('0x1'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0xab52('0x2'));var moment=require(_0xab52('0x3'));var BPromise=require(_0xab52('0x4'));var Mustache=require(_0xab52('0x5'));var util=require(_0xab52('0x6'));var path=require(_0xab52('0x7'));var sox=require('sox');var csv=require(_0xab52('0x8'));var ejs=require(_0xab52('0x9'));var fs=require('fs');var _=require(_0xab52('0xa'));var squel=require('squel');var crypto=require(_0xab52('0xb'));var jsforce=require(_0xab52('0xc'));var deskjs=require(_0xab52('0xd'));var toCsv=require(_0xab52('0x8'));var querystring=require('querystring');var Papa=require(_0xab52('0xe'));var Redis=require(_0xab52('0xf'));var qs=require('../../components/parsers/qs');var logger=require(_0xab52('0x10'))(_0xab52('0x11'));var utils=require(_0xab52('0x12'));var config=require(_0xab52('0x13'));var db=require(_0xab52('0x14'))['db'];function respondWithStatusCode(_0x2ac1e6,_0x497298){_0x497298=_0x497298||0xcc;return function(_0x35c107){if(_0x35c107){return _0x2ac1e6[_0xab52('0x15')](_0x497298);}return _0x2ac1e6[_0xab52('0x16')](_0x497298)[_0xab52('0x17')]();};}function respondWithResult(_0x2c0845,_0xd59315){_0xd59315=_0xd59315||0xc8;return function(_0x51fe2c){if(_0x51fe2c){return _0x2c0845[_0xab52('0x16')](_0xd59315)[_0xab52('0x18')](_0x51fe2c);}};}function respondWithFilteredResult(_0x76c2d7,_0x272bd4){return function(_0xab85ab){if(_0xab85ab){var _0x1d503b=_0xab85ab[_0xab52('0x19')],_0x11dd5b=_0x272bd4[_0xab52('0x1a')],_0x19f40c=_0x272bd4[_0xab52('0x1a')]+_0x272bd4[_0xab52('0x1b')],_0x1c38bf;if(_0x19f40c>=_0x1d503b){_0x19f40c=_0x1d503b;_0x1c38bf=0xc8;}else{_0x1c38bf=0xce;}_0x76c2d7[_0xab52('0x16')](_0x1c38bf);return _0x76c2d7[_0xab52('0x1c')](_0xab52('0x1d'),_0x11dd5b+'-'+_0x19f40c+'/'+_0x1d503b)[_0xab52('0x18')](_0xab85ab);}return null;};}function patchUpdates(_0x17b9e3){return function(_0x31d8fe){try{jsonpatch['apply'](_0x31d8fe,_0x17b9e3,!![]);}catch(_0x53ad54){return BPromise[_0xab52('0x1e')](_0x53ad54);}return _0x31d8fe[_0xab52('0x1f')]();};}function saveUpdates(_0x2e06c9,_0x473bd8){return function(_0x44a845){if(_0x44a845){return _0x44a845[_0xab52('0x20')](_0x2e06c9)[_0xab52('0x21')](function(_0x3681fd){return _0x3681fd;});}return null;};}function removeEntity(_0x5824a1,_0x1e5b95){return function(_0x5ce80e){if(_0x5ce80e){return _0x5ce80e[_0xab52('0x22')]()[_0xab52('0x21')](function(){_0x5824a1[_0xab52('0x16')](0xcc)[_0xab52('0x17')]();});}};}function handleEntityNotFound(_0x4a92d2,_0x152abf){return function(_0x39f6fc){if(!_0x39f6fc){_0x4a92d2[_0xab52('0x15')](0x194);}return _0x39f6fc;};}function handleError(_0x2b8690,_0x4e3ada){_0x4e3ada=_0x4e3ada||0x1f4;return function(_0x1e6af7){logger[_0xab52('0x23')](_0x1e6af7[_0xab52('0x24')]);if(_0x1e6af7[_0xab52('0x25')]){delete _0x1e6af7['name'];}_0x2b8690['status'](_0x4e3ada)['send'](_0x1e6af7);};}exports[_0xab52('0x26')]=function(_0x39b614,_0x5543fe){var _0x8dda3e={},_0xe6559d={},_0x4959de={'count':0x0,'rows':[]};var _0x37d474=db[_0xab52('0x27')][_0xab52('0x28')];_0xe6559d[_0xab52('0x29')]=_[_0xab52('0x2a')](_0x37d474);var _0x4f967f={'dateStart':_0x39b614['query'][_0xab52('0x2b')],'dateEnd':_0x39b614[_0xab52('0x2c')][_0xab52('0x2d')]};delete _0x39b614[_0xab52('0x2c')][_0xab52('0x2b')];delete _0x39b614['query'][_0xab52('0x2d')];_0xe6559d[_0xab52('0x2c')]=_[_0xab52('0x2a')](_0x39b614['query']);_0xe6559d[_0xab52('0x2e')]=_['intersection'](_0xe6559d[_0xab52('0x29')],_0xe6559d['query']);_0x8dda3e[_0xab52('0x2f')]=_[_0xab52('0x30')](_0xe6559d[_0xab52('0x29')],qs[_0xab52('0x31')](_0x39b614[_0xab52('0x2c')]['fields']));_0x8dda3e[_0xab52('0x2f')]=_0x8dda3e['attributes'][_0xab52('0x32')]?_0x8dda3e[_0xab52('0x2f')]:_0xe6559d['model'];if(!_0x39b614[_0xab52('0x2c')][_0xab52('0x33')](_0xab52('0x34'))){_0x8dda3e[_0xab52('0x1b')]=qs[_0xab52('0x1b')](_0x39b614['query']['limit']);_0x8dda3e[_0xab52('0x1a')]=qs[_0xab52('0x1a')](_0x39b614[_0xab52('0x2c')][_0xab52('0x1a')]);}_0x8dda3e['order']=qs[_0xab52('0x35')](_0x39b614[_0xab52('0x2c')][_0xab52('0x35')]);_0x8dda3e[_0xab52('0x36')]=qs['filters'](_[_0xab52('0x37')](_0x39b614['query'],_0xe6559d[_0xab52('0x2e')]));if(_0x4f967f['dateStart']){if(_0x4f967f[_0xab52('0x2d')]){_0x4f967f['dateEnd']=moment(_0x4f967f[_0xab52('0x2d')])[_0xab52('0x38')](0x1,_0xab52('0x39'));}else{_0x4f967f[_0xab52('0x2d')]=moment(_0x4f967f[_0xab52('0x2b')])[_0xab52('0x38')](0x1,_0xab52('0x39'));}_[_0xab52('0x3a')](_0x8dda3e[_0xab52('0x36')],{'createdAt':{'$gte':_0x4f967f['dateStart'],'$lte':_0x4f967f[_0xab52('0x2d')]}});}if(_0x39b614['query']['filter']){_0x8dda3e['where']=_['merge'](_0x8dda3e[_0xab52('0x36')],{'$or':_[_0xab52('0x3b')](_0x37d474,function(_0x4d4130){if(_0x4d4130[_0xab52('0x3c')][_0xab52('0x3d')]!==_0xab52('0x3e')){var _0x1e2de2={};_0x1e2de2[_0x4d4130[_0xab52('0x3f')]]={'$like':'%'+_0x39b614['query'][_0xab52('0x40')]+'%'};return _0x1e2de2;}})});}_0x8dda3e=_['merge']({},_0x8dda3e,_0x39b614[_0xab52('0x41')]);var _0x31b651={'where':_0x8dda3e[_0xab52('0x36')]};return db[_0xab52('0x27')][_0xab52('0x19')](_0x31b651)[_0xab52('0x21')](function(_0x571073){_0x4959de[_0xab52('0x19')]=_0x571073;if(_0x39b614[_0xab52('0x2c')][_0xab52('0x42')]){_0x8dda3e[_0xab52('0x43')]=[{'all':!![]}];}return db[_0xab52('0x27')]['findAll'](_0x8dda3e);})[_0xab52('0x21')](function(_0x405ccd){_0x4959de[_0xab52('0x44')]=_0x405ccd;return _0x4959de;})[_0xab52('0x21')](respondWithFilteredResult(_0x5543fe,_0x8dda3e))['catch'](handleError(_0x5543fe,null));};exports[_0xab52('0x45')]=function(_0x2e9ec1,_0x3cc0bc){var _0xeefdec={'raw':!![],'where':{'id':_0x2e9ec1[_0xab52('0x46')]['id']}},_0x166b0c={};_0x166b0c['model']=_[_0xab52('0x2a')](db[_0xab52('0x27')][_0xab52('0x28')]);_0x166b0c[_0xab52('0x2c')]=_[_0xab52('0x2a')](_0x2e9ec1['query']);_0x166b0c[_0xab52('0x2e')]=_[_0xab52('0x30')](_0x166b0c[_0xab52('0x29')],_0x166b0c[_0xab52('0x2c')]);_0xeefdec['attributes']=_[_0xab52('0x30')](_0x166b0c[_0xab52('0x29')],qs[_0xab52('0x31')](_0x2e9ec1['query']['fields']));_0xeefdec[_0xab52('0x2f')]=_0xeefdec[_0xab52('0x2f')][_0xab52('0x32')]?_0xeefdec['attributes']:_0x166b0c[_0xab52('0x29')];if(_0x2e9ec1[_0xab52('0x2c')]['includeAll']){_0xeefdec[_0xab52('0x43')]=[{'all':!![]}];}_0xeefdec=_[_0xab52('0x3a')]({},_0xeefdec,_0x2e9ec1[_0xab52('0x41')]);return db[_0xab52('0x27')][_0xab52('0x47')](_0xeefdec)[_0xab52('0x21')](handleEntityNotFound(_0x3cc0bc,null))[_0xab52('0x21')](respondWithResult(_0x3cc0bc,null))[_0xab52('0x48')](handleError(_0x3cc0bc,null));};exports['create']=function(_0x6c28a2,_0x1a24da){return db['MailQueueReport'][_0xab52('0x49')](_0x6c28a2[_0xab52('0x4a')],{})['then'](respondWithResult(_0x1a24da,0xc9))['catch'](handleError(_0x1a24da,null));};exports['update']=function(_0xb38883,_0x4959fc){if(_0xb38883['body']['id']){delete _0xb38883[_0xab52('0x4a')]['id'];}return db['MailQueueReport'][_0xab52('0x47')]({'where':{'id':_0xb38883[_0xab52('0x46')]['id']}})[_0xab52('0x21')](handleEntityNotFound(_0x4959fc,null))['then'](saveUpdates(_0xb38883[_0xab52('0x4a')],null))[_0xab52('0x21')](respondWithResult(_0x4959fc,null))[_0xab52('0x48')](handleError(_0x4959fc,null));};exports[_0xab52('0x22')]=function(_0x551026,_0x42ab70){return db[_0xab52('0x27')]['find']({'where':{'id':_0x551026[_0xab52('0x46')]['id']}})[_0xab52('0x21')](handleEntityNotFound(_0x42ab70,null))['then'](removeEntity(_0x42ab70,null))[_0xab52('0x48')](handleError(_0x42ab70,null));};exports[_0xab52('0x4b')]=function(_0x4261e9,_0x40ac21){return db['MailQueueReport']['describe']()[_0xab52('0x21')](respondWithResult(_0x40ac21,null))[_0xab52('0x48')](handleError(_0x40ac21,null));};