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 _0xe526=['../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','sendStatus','status','json','count','offset','limit','set','Content-Range','apply','save','update','then','destroy','end','error','stack','name','index','map','MailQueueReport','fieldName','type','key','model','query','keys','filters','attributes','intersection','fields','length','nolimit','sort','pick','where','filter','merge','options','includeAll','findAll','rows','catch','show','params','rawAttributes','find','create','body','html-pdf','eml-format','rimraf','zip-dir','moment','bluebird','mustache','util','path','ejs','lodash','squel','desk.js','to-csv','querystring','papaparse','../../components/auth/service'];(function(_0x487a0b,_0x33c302){var _0x4cb1ba=function(_0x2a3615){while(--_0x2a3615){_0x487a0b['push'](_0x487a0b['shift']());}};_0x4cb1ba(++_0x33c302);}(_0xe526,0x103));var _0x6e52=function(_0x499a83,_0x14823f){_0x499a83=_0x499a83-0x0;var _0xcd5797=_0xe526[_0x499a83];return _0xcd5797;};'use strict';var pdf=require(_0x6e52('0x0'));var emlformat=require(_0x6e52('0x1'));var rimraf=require(_0x6e52('0x2'));var zipdir=require(_0x6e52('0x3'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0x6e52('0x4'));var BPromise=require(_0x6e52('0x5'));var Mustache=require(_0x6e52('0x6'));var util=require(_0x6e52('0x7'));var path=require(_0x6e52('0x8'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x6e52('0x9'));var fs=require('fs');var _=require(_0x6e52('0xa'));var squel=require(_0x6e52('0xb'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x6e52('0xc'));var toCsv=require(_0x6e52('0xd'));var querystring=require(_0x6e52('0xe'));var Papa=require(_0x6e52('0xf'));var Redis=require('ioredis');var authService=require(_0x6e52('0x10'));var qs=require(_0x6e52('0x11'));var as=require(_0x6e52('0x12'));var hardwareService=require(_0x6e52('0x13'));var logger=require('../../config/logger')(_0x6e52('0x14'));var utils=require('../../config/utils');var config=require('../../config/environment');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x56405a,_0x50bf85){_0x50bf85=_0x50bf85||0xcc;return function(_0x25d9a5){if(_0x25d9a5){return _0x56405a[_0x6e52('0x15')](_0x50bf85);}return _0x56405a[_0x6e52('0x16')](_0x50bf85)['end']();};}function respondWithResult(_0x1037c8,_0x466cda){_0x466cda=_0x466cda||0xc8;return function(_0x226331){if(_0x226331){return _0x1037c8[_0x6e52('0x16')](_0x466cda)[_0x6e52('0x17')](_0x226331);}};}function respondWithFilteredResult(_0x3deec3,_0x4cc4ed){return function(_0x3b26d3){if(_0x3b26d3){var _0xe31a00=_0x3b26d3[_0x6e52('0x18')],_0x325daa=_0x4cc4ed['offset'],_0x3cd299=_0x4cc4ed[_0x6e52('0x19')]+_0x4cc4ed[_0x6e52('0x1a')],_0x103dc4;if(_0x3cd299>=_0xe31a00){_0x3cd299=_0xe31a00;_0x103dc4=0xc8;}else{_0x103dc4=0xce;}_0x3deec3['status'](_0x103dc4);return _0x3deec3[_0x6e52('0x1b')](_0x6e52('0x1c'),_0x325daa+'-'+_0x3cd299+'/'+_0xe31a00)['json'](_0x3b26d3);}return null;};}function patchUpdates(_0x14f98f){return function(_0x38f7aa){try{jsonpatch[_0x6e52('0x1d')](_0x38f7aa,_0x14f98f,!![]);}catch(_0x30b819){return BPromise['reject'](_0x30b819);}return _0x38f7aa[_0x6e52('0x1e')]();};}function saveUpdates(_0x563864,_0x35efd6){return function(_0x3297fa){if(_0x3297fa){return _0x3297fa[_0x6e52('0x1f')](_0x563864)[_0x6e52('0x20')](function(_0x3ac54d){return _0x3ac54d;});}return null;};}function removeEntity(_0x4fd886,_0x3231f7){return function(_0xda17cc){if(_0xda17cc){return _0xda17cc[_0x6e52('0x21')]()[_0x6e52('0x20')](function(){_0x4fd886[_0x6e52('0x16')](0xcc)[_0x6e52('0x22')]();});}};}function handleEntityNotFound(_0x2e6236,_0x267363){return function(_0x37a5bd){if(!_0x37a5bd){_0x2e6236[_0x6e52('0x15')](0x194);}return _0x37a5bd;};}function handleError(_0x5d67e5,_0x11ab23){_0x11ab23=_0x11ab23||0x1f4;return function(_0x9ed94c){logger[_0x6e52('0x23')](_0x9ed94c[_0x6e52('0x24')]);if(_0x9ed94c[_0x6e52('0x25')]){delete _0x9ed94c[_0x6e52('0x25')];}_0x5d67e5[_0x6e52('0x16')](_0x11ab23)['send'](_0x9ed94c);};}exports[_0x6e52('0x26')]=function(_0x2ae4ee,_0x2f3ca4){var _0x16ccbc={},_0x215834={},_0x5ccc47={'count':0x0,'rows':[]};var _0x4f69fb=_[_0x6e52('0x27')](db[_0x6e52('0x28')]['rawAttributes'],function(_0x37d610){return{'name':_0x37d610[_0x6e52('0x29')],'type':_0x37d610[_0x6e52('0x2a')][_0x6e52('0x2b')]};});_0x215834[_0x6e52('0x2c')]=_[_0x6e52('0x27')](_0x4f69fb,_0x6e52('0x25'));_0x215834[_0x6e52('0x2d')]=_[_0x6e52('0x2e')](_0x2ae4ee['query']);_0x215834[_0x6e52('0x2f')]=_['intersection'](_0x215834[_0x6e52('0x2c')],_0x215834['query']);_0x16ccbc[_0x6e52('0x30')]=_[_0x6e52('0x31')](_0x215834['model'],qs[_0x6e52('0x32')](_0x2ae4ee[_0x6e52('0x2d')][_0x6e52('0x32')]));_0x16ccbc[_0x6e52('0x30')]=_0x16ccbc[_0x6e52('0x30')][_0x6e52('0x33')]?_0x16ccbc[_0x6e52('0x30')]:_0x215834['model'];if(!_0x2ae4ee[_0x6e52('0x2d')]['hasOwnProperty'](_0x6e52('0x34'))){_0x16ccbc[_0x6e52('0x1a')]=qs['limit'](_0x2ae4ee['query']['limit']);_0x16ccbc[_0x6e52('0x19')]=qs[_0x6e52('0x19')](_0x2ae4ee[_0x6e52('0x2d')][_0x6e52('0x19')]);}_0x16ccbc['order']=qs[_0x6e52('0x35')](_0x2ae4ee[_0x6e52('0x2d')][_0x6e52('0x35')]);_0x16ccbc['where']=qs[_0x6e52('0x2f')](_[_0x6e52('0x36')](_0x2ae4ee[_0x6e52('0x2d')],_0x215834['filters']),_0x4f69fb);if(_0x2ae4ee[_0x6e52('0x2d')]['filter']){_0x16ccbc[_0x6e52('0x37')]=_['merge'](_0x16ccbc[_0x6e52('0x37')],{'$or':_[_0x6e52('0x27')](_0x4f69fb,function(_0x17365c){if(_0x17365c[_0x6e52('0x2a')]!=='VIRTUAL'){var _0x5e2702={};_0x5e2702[_0x17365c[_0x6e52('0x25')]]={'$like':'%'+_0x2ae4ee['query'][_0x6e52('0x38')]+'%'};return _0x5e2702;}})});}_0x16ccbc=_[_0x6e52('0x39')]({},_0x16ccbc,_0x2ae4ee[_0x6e52('0x3a')]);var _0x38d740={'where':_0x16ccbc[_0x6e52('0x37')]};return db[_0x6e52('0x28')]['count'](_0x38d740)[_0x6e52('0x20')](function(_0x359a78){_0x5ccc47[_0x6e52('0x18')]=_0x359a78;if(_0x2ae4ee['query'][_0x6e52('0x3b')]){_0x16ccbc['include']=[{'all':!![]}];}return db[_0x6e52('0x28')][_0x6e52('0x3c')](_0x16ccbc);})[_0x6e52('0x20')](function(_0x35db07){_0x5ccc47[_0x6e52('0x3d')]=_0x35db07;return _0x5ccc47;})[_0x6e52('0x20')](respondWithFilteredResult(_0x2f3ca4,_0x16ccbc))[_0x6e52('0x3e')](handleError(_0x2f3ca4,null));};exports[_0x6e52('0x3f')]=function(_0x251a98,_0xa40ca9){var _0x3cc574={'raw':!![],'where':{'id':_0x251a98[_0x6e52('0x40')]['id']}},_0x43a7ef={};_0x43a7ef[_0x6e52('0x2c')]=_[_0x6e52('0x2e')](db['MailQueueReport'][_0x6e52('0x41')]);_0x43a7ef[_0x6e52('0x2d')]=_[_0x6e52('0x2e')](_0x251a98[_0x6e52('0x2d')]);_0x43a7ef['filters']=_['intersection'](_0x43a7ef['model'],_0x43a7ef[_0x6e52('0x2d')]);_0x3cc574['attributes']=_[_0x6e52('0x31')](_0x43a7ef['model'],qs[_0x6e52('0x32')](_0x251a98[_0x6e52('0x2d')]['fields']));_0x3cc574[_0x6e52('0x30')]=_0x3cc574[_0x6e52('0x30')][_0x6e52('0x33')]?_0x3cc574['attributes']:_0x43a7ef[_0x6e52('0x2c')];if(_0x251a98[_0x6e52('0x2d')][_0x6e52('0x3b')]){_0x3cc574['include']=[{'all':!![]}];}_0x3cc574=_['merge']({},_0x3cc574,_0x251a98[_0x6e52('0x3a')]);return db[_0x6e52('0x28')][_0x6e52('0x42')](_0x3cc574)['then'](handleEntityNotFound(_0xa40ca9,null))[_0x6e52('0x20')](respondWithResult(_0xa40ca9,null))[_0x6e52('0x3e')](handleError(_0xa40ca9,null));};exports[_0x6e52('0x43')]=function(_0x5adc16,_0x2fe67c){return db[_0x6e52('0x28')][_0x6e52('0x43')](_0x5adc16[_0x6e52('0x44')],{})[_0x6e52('0x20')](respondWithResult(_0x2fe67c,0xc9))['catch'](handleError(_0x2fe67c,null));};exports[_0x6e52('0x1f')]=function(_0x3f050c,_0x5e23d6){if(_0x3f050c[_0x6e52('0x44')]['id']){delete _0x3f050c['body']['id'];}return db[_0x6e52('0x28')][_0x6e52('0x42')]({'where':{'id':_0x3f050c[_0x6e52('0x40')]['id']}})[_0x6e52('0x20')](handleEntityNotFound(_0x5e23d6,null))[_0x6e52('0x20')](saveUpdates(_0x3f050c[_0x6e52('0x44')],null))[_0x6e52('0x20')](respondWithResult(_0x5e23d6,null))[_0x6e52('0x3e')](handleError(_0x5e23d6,null));};exports[_0x6e52('0x21')]=function(_0x2f9520,_0x27412a){return db[_0x6e52('0x28')][_0x6e52('0x42')]({'where':{'id':_0x2f9520[_0x6e52('0x40')]['id']}})[_0x6e52('0x20')](handleEntityNotFound(_0x27412a,null))[_0x6e52('0x20')](removeEntity(_0x27412a,null))[_0x6e52('0x3e')](handleError(_0x27412a,null));};exports['describe']=function(_0xf62b8d,_0x21fd9f){return db[_0x6e52('0x28')]['describe']()[_0x6e52('0x20')](respondWithResult(_0x21fd9f,null))[_0x6e52('0x3e')](handleError(_0x21fd9f,null));};