server/api/smsQueueReport/smsQueueReport.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 _0x7a7e=['keys','query','filters','intersection','attributes','fields','hasOwnProperty','order','sort','where','pick','type','filter','merge','includeAll','include','findAll','rows','catch','show','params','rawAttributes','find','create','body','describe','fast-json-patch','moment','bluebird','mustache','util','path','ejs','lodash','jsforce','to-csv','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','json','offset','limit','undefined','count','set','apply','reject','update','destroy','then','end','stack','name','index','SmsQueueReport','fieldName','key','model','map'];(function(_0x48a96f,_0x530059){var _0x3ff3ef=function(_0x286059){while(--_0x286059){_0x48a96f['push'](_0x48a96f['shift']());}};_0x3ff3ef(++_0x530059);}(_0x7a7e,0x1ef));var _0xe7a7=function(_0xad12bb,_0x3c9ce3){_0xad12bb=_0xad12bb-0x0;var _0x558bb9=_0x7a7e[_0xad12bb];return _0x558bb9;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xe7a7('0x0'));var rp=require('request-promise');var moment=require(_0xe7a7('0x1'));var BPromise=require(_0xe7a7('0x2'));var Mustache=require(_0xe7a7('0x3'));var util=require(_0xe7a7('0x4'));var path=require(_0xe7a7('0x5'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0xe7a7('0x6'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xe7a7('0x7'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0xe7a7('0x8'));var deskjs=require('desk.js');var toCsv=require(_0xe7a7('0x9'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0xe7a7('0xa'));var qs=require(_0xe7a7('0xb'));var as=require(_0xe7a7('0xc'));var hardwareService=require(_0xe7a7('0xd'));var logger=require('../../config/logger')(_0xe7a7('0xe'));var utils=require(_0xe7a7('0xf'));var config=require(_0xe7a7('0x10'));var licenseUtil=require(_0xe7a7('0x11'));var db=require(_0xe7a7('0x12'))['db'];function respondWithStatusCode(_0x110644,_0x145371){_0x145371=_0x145371||0xcc;return function(_0x26a8a1){if(_0x26a8a1){return _0x110644[_0xe7a7('0x13')](_0x145371);}return _0x110644[_0xe7a7('0x14')](_0x145371)['end']();};}function respondWithResult(_0x324c99,_0x5e0a00){_0x5e0a00=_0x5e0a00||0xc8;return function(_0x567dc3){if(_0x567dc3){return _0x324c99[_0xe7a7('0x14')](_0x5e0a00)[_0xe7a7('0x15')](_0x567dc3);}};}function respondWithFilteredResult(_0x115fa7,_0x107233){return function(_0xf4d73b){if(_0xf4d73b){var _0x47ca14=typeof _0x107233[_0xe7a7('0x16')]==='undefined'&&typeof _0x107233[_0xe7a7('0x17')]===_0xe7a7('0x18');var _0x499da8=_0xf4d73b[_0xe7a7('0x19')];var _0x3dd3ea=_0x47ca14?0x0:_0x107233['offset'];var _0x4e4de4=_0x47ca14?_0xf4d73b['count']:_0x107233[_0xe7a7('0x16')]+_0x107233[_0xe7a7('0x17')];var _0xfcd383;if(_0x4e4de4>=_0x499da8){_0x4e4de4=_0x499da8;_0xfcd383=0xc8;}else{_0xfcd383=0xce;}_0x115fa7[_0xe7a7('0x14')](_0xfcd383);return _0x115fa7[_0xe7a7('0x1a')]('Content-Range',_0x3dd3ea+'-'+_0x4e4de4+'/'+_0x499da8)['json'](_0xf4d73b);}return null;};}function patchUpdates(_0x5e4f88){return function(_0x248342){try{jsonpatch[_0xe7a7('0x1b')](_0x248342,_0x5e4f88,!![]);}catch(_0x4cd2eb){return BPromise[_0xe7a7('0x1c')](_0x4cd2eb);}return _0x248342['save']();};}function saveUpdates(_0x36faa4,_0x3594f5){return function(_0x1b109e){if(_0x1b109e){return _0x1b109e[_0xe7a7('0x1d')](_0x36faa4)['then'](function(_0x42948e){return _0x42948e;});}return null;};}function removeEntity(_0x43360d,_0xcb05be){return function(_0x1f6d21){if(_0x1f6d21){return _0x1f6d21[_0xe7a7('0x1e')]()[_0xe7a7('0x1f')](function(){_0x43360d[_0xe7a7('0x14')](0xcc)[_0xe7a7('0x20')]();});}};}function handleEntityNotFound(_0x1d2277,_0x2ac4f0){return function(_0x29fdeb){if(!_0x29fdeb){_0x1d2277[_0xe7a7('0x13')](0x194);}return _0x29fdeb;};}function handleError(_0x3d3fe1,_0x4dafe7){_0x4dafe7=_0x4dafe7||0x1f4;return function(_0x341606){logger['error'](_0x341606[_0xe7a7('0x21')]);if(_0x341606[_0xe7a7('0x22')]){delete _0x341606[_0xe7a7('0x22')];}_0x3d3fe1[_0xe7a7('0x14')](_0x4dafe7)['send'](_0x341606);};}exports[_0xe7a7('0x23')]=function(_0xa4ff95,_0x10cbc3){var _0xe78548={},_0x4fc481={},_0x5d3320={'count':0x0,'rows':[]};var _0x4672fd=_['map'](db[_0xe7a7('0x24')]['rawAttributes'],function(_0x3d5648){return{'name':_0x3d5648[_0xe7a7('0x25')],'type':_0x3d5648['type'][_0xe7a7('0x26')]};});_0x4fc481[_0xe7a7('0x27')]=_[_0xe7a7('0x28')](_0x4672fd,_0xe7a7('0x22'));_0x4fc481['query']=_[_0xe7a7('0x29')](_0xa4ff95[_0xe7a7('0x2a')]);_0x4fc481[_0xe7a7('0x2b')]=_[_0xe7a7('0x2c')](_0x4fc481[_0xe7a7('0x27')],_0x4fc481['query']);_0xe78548[_0xe7a7('0x2d')]=_[_0xe7a7('0x2c')](_0x4fc481['model'],qs[_0xe7a7('0x2e')](_0xa4ff95['query']['fields']));_0xe78548[_0xe7a7('0x2d')]=_0xe78548[_0xe7a7('0x2d')]['length']?_0xe78548[_0xe7a7('0x2d')]:_0x4fc481['model'];if(!_0xa4ff95['query'][_0xe7a7('0x2f')]('nolimit')){_0xe78548[_0xe7a7('0x17')]=qs[_0xe7a7('0x17')](_0xa4ff95[_0xe7a7('0x2a')][_0xe7a7('0x17')]);_0xe78548['offset']=qs[_0xe7a7('0x16')](_0xa4ff95[_0xe7a7('0x2a')][_0xe7a7('0x16')]);}_0xe78548[_0xe7a7('0x30')]=qs[_0xe7a7('0x31')](_0xa4ff95[_0xe7a7('0x2a')][_0xe7a7('0x31')]);_0xe78548[_0xe7a7('0x32')]=qs['filters'](_[_0xe7a7('0x33')](_0xa4ff95['query'],_0x4fc481['filters']),_0x4672fd);if(_0xa4ff95[_0xe7a7('0x2a')]['filter']){_0xe78548[_0xe7a7('0x32')]=_['merge'](_0xe78548[_0xe7a7('0x32')],{'$or':_[_0xe7a7('0x28')](_0x4672fd,function(_0x1f1305){if(_0x1f1305[_0xe7a7('0x34')]!=='VIRTUAL'){var _0x290a05={};_0x290a05[_0x1f1305['name']]={'$like':'%'+_0xa4ff95[_0xe7a7('0x2a')][_0xe7a7('0x35')]+'%'};return _0x290a05;}})});}_0xe78548=_[_0xe7a7('0x36')]({},_0xe78548,_0xa4ff95['options']);var _0x441471={'where':_0xe78548[_0xe7a7('0x32')]};return db['SmsQueueReport'][_0xe7a7('0x19')](_0x441471)['then'](function(_0x29e1f7){_0x5d3320[_0xe7a7('0x19')]=_0x29e1f7;if(_0xa4ff95[_0xe7a7('0x2a')][_0xe7a7('0x37')]){_0xe78548[_0xe7a7('0x38')]=[{'all':!![]}];}return db[_0xe7a7('0x24')][_0xe7a7('0x39')](_0xe78548);})['then'](function(_0x17250d){_0x5d3320[_0xe7a7('0x3a')]=_0x17250d;return _0x5d3320;})[_0xe7a7('0x1f')](respondWithFilteredResult(_0x10cbc3,_0xe78548))[_0xe7a7('0x3b')](handleError(_0x10cbc3,null));};exports[_0xe7a7('0x3c')]=function(_0x485377,_0x42f63b){var _0x15ca88={'raw':!![],'where':{'id':_0x485377[_0xe7a7('0x3d')]['id']}},_0x643188={};_0x643188[_0xe7a7('0x27')]=_['keys'](db[_0xe7a7('0x24')][_0xe7a7('0x3e')]);_0x643188[_0xe7a7('0x2a')]=_[_0xe7a7('0x29')](_0x485377['query']);_0x643188[_0xe7a7('0x2b')]=_[_0xe7a7('0x2c')](_0x643188[_0xe7a7('0x27')],_0x643188['query']);_0x15ca88[_0xe7a7('0x2d')]=_[_0xe7a7('0x2c')](_0x643188[_0xe7a7('0x27')],qs[_0xe7a7('0x2e')](_0x485377[_0xe7a7('0x2a')]['fields']));_0x15ca88[_0xe7a7('0x2d')]=_0x15ca88[_0xe7a7('0x2d')]['length']?_0x15ca88['attributes']:_0x643188[_0xe7a7('0x27')];if(_0x485377[_0xe7a7('0x2a')][_0xe7a7('0x37')]){_0x15ca88['include']=[{'all':!![]}];}_0x15ca88=_['merge']({},_0x15ca88,_0x485377['options']);return db[_0xe7a7('0x24')][_0xe7a7('0x3f')](_0x15ca88)[_0xe7a7('0x1f')](handleEntityNotFound(_0x42f63b,null))[_0xe7a7('0x1f')](respondWithResult(_0x42f63b,null))['catch'](handleError(_0x42f63b,null));};exports[_0xe7a7('0x40')]=function(_0x302a86,_0x1280a0){return db[_0xe7a7('0x24')]['create'](_0x302a86[_0xe7a7('0x41')],{})[_0xe7a7('0x1f')](respondWithResult(_0x1280a0,0xc9))[_0xe7a7('0x3b')](handleError(_0x1280a0,null));};exports[_0xe7a7('0x1d')]=function(_0x3f8cd8,_0x2add45){if(_0x3f8cd8['body']['id']){delete _0x3f8cd8[_0xe7a7('0x41')]['id'];}return db[_0xe7a7('0x24')][_0xe7a7('0x3f')]({'where':{'id':_0x3f8cd8['params']['id']}})[_0xe7a7('0x1f')](handleEntityNotFound(_0x2add45,null))[_0xe7a7('0x1f')](saveUpdates(_0x3f8cd8[_0xe7a7('0x41')],null))[_0xe7a7('0x1f')](respondWithResult(_0x2add45,null))['catch'](handleError(_0x2add45,null));};exports[_0xe7a7('0x1e')]=function(_0x298c6e,_0x3db509){return db[_0xe7a7('0x24')][_0xe7a7('0x3f')]({'where':{'id':_0x298c6e[_0xe7a7('0x3d')]['id']}})[_0xe7a7('0x1f')](handleEntityNotFound(_0x3db509,null))[_0xe7a7('0x1f')](removeEntity(_0x3db509,null))['catch'](handleError(_0x3db509,null));};exports[_0xe7a7('0x42')]=function(_0x1c1407,_0x458ad7){return db[_0xe7a7('0x24')][_0xe7a7('0x42')]()[_0xe7a7('0x1f')](respondWithResult(_0x458ad7,null))[_0xe7a7('0x3b')](handleError(_0x458ad7,null));};