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 _0x8426=['rows','catch','show','params','keys','intersection','options','find','create','body','describe','html-pdf','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','sox','to-csv','lodash','squel','jsforce','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../config/environment','../../config/license/util','status','end','json','count','offset','limit','set','Content-Range','apply','save','update','then','destroy','error','stack','name','send','map','MailQueueReport','rawAttributes','fieldName','type','key','model','query','filters','attributes','fields','length','hasOwnProperty','nolimit','sort','where','pick','filter','merge','VIRTUAL','includeAll','include','findAll'];(function(_0x12c09c,_0x21172c){var _0x8df49e=function(_0x2ec417){while(--_0x2ec417){_0x12c09c['push'](_0x12c09c['shift']());}};_0x8df49e(++_0x21172c);}(_0x8426,0x12f));var _0x6842=function(_0x432682,_0x253044){_0x432682=_0x432682-0x0;var _0x463d05=_0x8426[_0x432682];return _0x463d05;};'use strict';var pdf=require(_0x6842('0x0'));var emlformat=require('eml-format');var rimraf=require(_0x6842('0x1'));var zipdir=require(_0x6842('0x2'));var jsonpatch=require(_0x6842('0x3'));var rp=require('request-promise');var moment=require(_0x6842('0x4'));var BPromise=require(_0x6842('0x5'));var Mustache=require(_0x6842('0x6'));var util=require(_0x6842('0x7'));var path=require('path');var sox=require(_0x6842('0x8'));var csv=require(_0x6842('0x9'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x6842('0xa'));var squel=require(_0x6842('0xb'));var crypto=require('crypto');var jsforce=require(_0x6842('0xc'));var deskjs=require(_0x6842('0xd'));var toCsv=require('to-csv');var querystring=require(_0x6842('0xe'));var Papa=require('papaparse');var Redis=require(_0x6842('0xf'));var authService=require(_0x6842('0x10'));var qs=require(_0x6842('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x6842('0x12'));var logger=require(_0x6842('0x13'))('api');var utils=require('../../config/utils');var config=require(_0x6842('0x14'));var licenseUtil=require(_0x6842('0x15'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x18bb2b,_0x1f2887){_0x1f2887=_0x1f2887||0xcc;return function(_0x1cecd4){if(_0x1cecd4){return _0x18bb2b['sendStatus'](_0x1f2887);}return _0x18bb2b[_0x6842('0x16')](_0x1f2887)[_0x6842('0x17')]();};}function respondWithResult(_0x429014,_0x41c52d){_0x41c52d=_0x41c52d||0xc8;return function(_0x56d75f){if(_0x56d75f){return _0x429014['status'](_0x41c52d)[_0x6842('0x18')](_0x56d75f);}};}function respondWithFilteredResult(_0x43316b,_0x51b9eb){return function(_0x3cc5e5){if(_0x3cc5e5){var _0x2d6283=_0x3cc5e5[_0x6842('0x19')],_0x1f80c9=_0x51b9eb['offset'],_0x41a6c7=_0x51b9eb[_0x6842('0x1a')]+_0x51b9eb[_0x6842('0x1b')],_0x2fef50;if(_0x41a6c7>=_0x2d6283){_0x41a6c7=_0x2d6283;_0x2fef50=0xc8;}else{_0x2fef50=0xce;}_0x43316b[_0x6842('0x16')](_0x2fef50);return _0x43316b[_0x6842('0x1c')](_0x6842('0x1d'),_0x1f80c9+'-'+_0x41a6c7+'/'+_0x2d6283)['json'](_0x3cc5e5);}return null;};}function patchUpdates(_0x563962){return function(_0x4b75d7){try{jsonpatch[_0x6842('0x1e')](_0x4b75d7,_0x563962,!![]);}catch(_0x235011){return BPromise['reject'](_0x235011);}return _0x4b75d7[_0x6842('0x1f')]();};}function saveUpdates(_0x1332ef,_0x3dcfe5){return function(_0x2ec30b){if(_0x2ec30b){return _0x2ec30b[_0x6842('0x20')](_0x1332ef)[_0x6842('0x21')](function(_0x58769f){return _0x58769f;});}return null;};}function removeEntity(_0x3640f1,_0x5920a1){return function(_0x89a0ce){if(_0x89a0ce){return _0x89a0ce[_0x6842('0x22')]()['then'](function(){_0x3640f1[_0x6842('0x16')](0xcc)[_0x6842('0x17')]();});}};}function handleEntityNotFound(_0x304db5,_0x40709b){return function(_0x30666d){if(!_0x30666d){_0x304db5['sendStatus'](0x194);}return _0x30666d;};}function handleError(_0x11dea0,_0x373c58){_0x373c58=_0x373c58||0x1f4;return function(_0x54e903){logger[_0x6842('0x23')](_0x54e903[_0x6842('0x24')]);if(_0x54e903[_0x6842('0x25')]){delete _0x54e903[_0x6842('0x25')];}_0x11dea0[_0x6842('0x16')](_0x373c58)[_0x6842('0x26')](_0x54e903);};}exports['index']=function(_0x974ed,_0x387ce3){var _0x45306f={},_0x167166={},_0x59e2c5={'count':0x0,'rows':[]};var _0x557033=_[_0x6842('0x27')](db[_0x6842('0x28')][_0x6842('0x29')],function(_0x4297e6){return{'name':_0x4297e6[_0x6842('0x2a')],'type':_0x4297e6[_0x6842('0x2b')][_0x6842('0x2c')]};});_0x167166[_0x6842('0x2d')]=_['map'](_0x557033,_0x6842('0x25'));_0x167166[_0x6842('0x2e')]=_['keys'](_0x974ed[_0x6842('0x2e')]);_0x167166[_0x6842('0x2f')]=_['intersection'](_0x167166[_0x6842('0x2d')],_0x167166[_0x6842('0x2e')]);_0x45306f[_0x6842('0x30')]=_['intersection'](_0x167166['model'],qs[_0x6842('0x31')](_0x974ed[_0x6842('0x2e')][_0x6842('0x31')]));_0x45306f[_0x6842('0x30')]=_0x45306f[_0x6842('0x30')][_0x6842('0x32')]?_0x45306f[_0x6842('0x30')]:_0x167166[_0x6842('0x2d')];if(!_0x974ed[_0x6842('0x2e')][_0x6842('0x33')](_0x6842('0x34'))){_0x45306f[_0x6842('0x1b')]=qs[_0x6842('0x1b')](_0x974ed[_0x6842('0x2e')][_0x6842('0x1b')]);_0x45306f[_0x6842('0x1a')]=qs['offset'](_0x974ed[_0x6842('0x2e')][_0x6842('0x1a')]);}_0x45306f['order']=qs[_0x6842('0x35')](_0x974ed[_0x6842('0x2e')][_0x6842('0x35')]);_0x45306f[_0x6842('0x36')]=qs[_0x6842('0x2f')](_[_0x6842('0x37')](_0x974ed['query'],_0x167166['filters']),_0x557033);if(_0x974ed['query'][_0x6842('0x38')]){_0x45306f[_0x6842('0x36')]=_[_0x6842('0x39')](_0x45306f[_0x6842('0x36')],{'$or':_['map'](_0x557033,function(_0x40000c){if(_0x40000c[_0x6842('0x2b')]!==_0x6842('0x3a')){var _0x2849bc={};_0x2849bc[_0x40000c[_0x6842('0x25')]]={'$like':'%'+_0x974ed[_0x6842('0x2e')][_0x6842('0x38')]+'%'};return _0x2849bc;}})});}_0x45306f=_['merge']({},_0x45306f,_0x974ed['options']);var _0xa528c2={'where':_0x45306f['where']};return db['MailQueueReport'][_0x6842('0x19')](_0xa528c2)[_0x6842('0x21')](function(_0x5bb055){_0x59e2c5[_0x6842('0x19')]=_0x5bb055;if(_0x974ed[_0x6842('0x2e')][_0x6842('0x3b')]){_0x45306f[_0x6842('0x3c')]=[{'all':!![]}];}return db['MailQueueReport'][_0x6842('0x3d')](_0x45306f);})['then'](function(_0x5b9431){_0x59e2c5[_0x6842('0x3e')]=_0x5b9431;return _0x59e2c5;})[_0x6842('0x21')](respondWithFilteredResult(_0x387ce3,_0x45306f))[_0x6842('0x3f')](handleError(_0x387ce3,null));};exports[_0x6842('0x40')]=function(_0x7d9874,_0x44b1cb){var _0x3d00b6={'raw':!![],'where':{'id':_0x7d9874[_0x6842('0x41')]['id']}},_0x4d721a={};_0x4d721a[_0x6842('0x2d')]=_[_0x6842('0x42')](db[_0x6842('0x28')][_0x6842('0x29')]);_0x4d721a['query']=_['keys'](_0x7d9874['query']);_0x4d721a[_0x6842('0x2f')]=_[_0x6842('0x43')](_0x4d721a[_0x6842('0x2d')],_0x4d721a[_0x6842('0x2e')]);_0x3d00b6[_0x6842('0x30')]=_['intersection'](_0x4d721a['model'],qs[_0x6842('0x31')](_0x7d9874[_0x6842('0x2e')]['fields']));_0x3d00b6[_0x6842('0x30')]=_0x3d00b6['attributes']['length']?_0x3d00b6['attributes']:_0x4d721a['model'];if(_0x7d9874[_0x6842('0x2e')][_0x6842('0x3b')]){_0x3d00b6[_0x6842('0x3c')]=[{'all':!![]}];}_0x3d00b6=_[_0x6842('0x39')]({},_0x3d00b6,_0x7d9874[_0x6842('0x44')]);return db[_0x6842('0x28')][_0x6842('0x45')](_0x3d00b6)[_0x6842('0x21')](handleEntityNotFound(_0x44b1cb,null))[_0x6842('0x21')](respondWithResult(_0x44b1cb,null))['catch'](handleError(_0x44b1cb,null));};exports[_0x6842('0x46')]=function(_0x54c5c5,_0x269c46){return db[_0x6842('0x28')][_0x6842('0x46')](_0x54c5c5[_0x6842('0x47')],{})[_0x6842('0x21')](respondWithResult(_0x269c46,0xc9))['catch'](handleError(_0x269c46,null));};exports[_0x6842('0x20')]=function(_0x341dec,_0xd6d1a3){if(_0x341dec[_0x6842('0x47')]['id']){delete _0x341dec[_0x6842('0x47')]['id'];}return db[_0x6842('0x28')][_0x6842('0x45')]({'where':{'id':_0x341dec[_0x6842('0x41')]['id']}})['then'](handleEntityNotFound(_0xd6d1a3,null))[_0x6842('0x21')](saveUpdates(_0x341dec['body'],null))[_0x6842('0x21')](respondWithResult(_0xd6d1a3,null))[_0x6842('0x3f')](handleError(_0xd6d1a3,null));};exports['destroy']=function(_0x4963d4,_0x6fd798){return db[_0x6842('0x28')][_0x6842('0x45')]({'where':{'id':_0x4963d4[_0x6842('0x41')]['id']}})[_0x6842('0x21')](handleEntityNotFound(_0x6fd798,null))['then'](removeEntity(_0x6fd798,null))['catch'](handleError(_0x6fd798,null));};exports[_0x6842('0x48')]=function(_0x5f2a34,_0x2cf4fb){return db[_0x6842('0x28')][_0x6842('0x48')]()[_0x6842('0x21')](respondWithResult(_0x2cf4fb,null))[_0x6842('0x3f')](handleError(_0x2cf4fb,null));};