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 _0x7017=['jsforce','desk.js','querystring','ioredis','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','status','json','count','offset','limit','set','Content-Range','reject','save','then','end','sendStatus','name','send','index','SmsQueueReport','model','query','dateEnd','dateStart','filters','attributes','fields','nolimit','order','sort','where','pick','add','day','merge','filter','map','type','key','VIRTUAL','field','options','include','findAll','rows','catch','show','params','keys','rawAttributes','intersection','length','includeAll','find','create','body','update','destroy','describe','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','mustache','sox','ejs','squel','crypto'];(function(_0x2eccc6,_0x448168){var _0x5d12d4=function(_0x4ba26c){while(--_0x4ba26c){_0x2eccc6['push'](_0x2eccc6['shift']());}};_0x5d12d4(++_0x448168);}(_0x7017,0x8d));var _0x7701=function(_0x25e7cb,_0x3579b7){_0x25e7cb=_0x25e7cb-0x0;var _0x375d92=_0x7017[_0x25e7cb];return _0x375d92;};'use strict';var pdf=require(_0x7701('0x0'));var emlformat=require(_0x7701('0x1'));var rimraf=require(_0x7701('0x2'));var zipdir=require(_0x7701('0x3'));var jsonpatch=require(_0x7701('0x4'));var rp=require('request-promise');var moment=require(_0x7701('0x5'));var BPromise=require('bluebird');var Mustache=require(_0x7701('0x6'));var util=require('util');var path=require('path');var sox=require(_0x7701('0x7'));var csv=require('to-csv');var ejs=require(_0x7701('0x8'));var fs=require('fs');var _=require('lodash');var squel=require(_0x7701('0x9'));var crypto=require(_0x7701('0xa'));var jsforce=require(_0x7701('0xb'));var deskjs=require(_0x7701('0xc'));var toCsv=require('to-csv');var querystring=require(_0x7701('0xd'));var Papa=require('papaparse');var Redis=require(_0x7701('0xe'));var qs=require(_0x7701('0xf'));var logger=require(_0x7701('0x10'))(_0x7701('0x11'));var utils=require(_0x7701('0x12'));var config=require(_0x7701('0x13'));var db=require(_0x7701('0x14'))['db'];function respondWithStatusCode(_0x3e7c70,_0x115d1a){_0x115d1a=_0x115d1a||0xcc;return function(_0x2f8039){if(_0x2f8039){return _0x3e7c70['sendStatus'](_0x115d1a);}return _0x3e7c70[_0x7701('0x15')](_0x115d1a)['end']();};}function respondWithResult(_0xaed348,_0x1b2186){_0x1b2186=_0x1b2186||0xc8;return function(_0x229f89){if(_0x229f89){return _0xaed348[_0x7701('0x15')](_0x1b2186)[_0x7701('0x16')](_0x229f89);}};}function respondWithFilteredResult(_0x451a15,_0x5ba0e6){return function(_0x175901){if(_0x175901){var _0x15e238=_0x175901[_0x7701('0x17')],_0x3ac53c=_0x5ba0e6[_0x7701('0x18')],_0x4e71e1=_0x5ba0e6[_0x7701('0x18')]+_0x5ba0e6[_0x7701('0x19')],_0x379a7b;if(_0x4e71e1>=_0x15e238){_0x4e71e1=_0x15e238;_0x379a7b=0xc8;}else{_0x379a7b=0xce;}_0x451a15['status'](_0x379a7b);return _0x451a15[_0x7701('0x1a')](_0x7701('0x1b'),_0x3ac53c+'-'+_0x4e71e1+'/'+_0x15e238)[_0x7701('0x16')](_0x175901);}return null;};}function patchUpdates(_0x29627e){return function(_0x16507d){try{jsonpatch['apply'](_0x16507d,_0x29627e,!![]);}catch(_0x23cbd5){return BPromise[_0x7701('0x1c')](_0x23cbd5);}return _0x16507d[_0x7701('0x1d')]();};}function saveUpdates(_0x5b1f8d,_0x50249f){return function(_0x38ff68){if(_0x38ff68){return _0x38ff68['update'](_0x5b1f8d)[_0x7701('0x1e')](function(_0x55cd18){return _0x55cd18;});}return null;};}function removeEntity(_0x2d1c20,_0x2c2464){return function(_0x329585){if(_0x329585){return _0x329585['destroy']()[_0x7701('0x1e')](function(){_0x2d1c20[_0x7701('0x15')](0xcc)[_0x7701('0x1f')]();});}};}function handleEntityNotFound(_0x7e9e3e,_0x3150d4){return function(_0x26da69){if(!_0x26da69){_0x7e9e3e[_0x7701('0x20')](0x194);}return _0x26da69;};}function handleError(_0x4c2916,_0x4c5c68){_0x4c5c68=_0x4c5c68||0x1f4;return function(_0x29d119){logger['error'](_0x29d119['stack']);if(_0x29d119[_0x7701('0x21')]){delete _0x29d119[_0x7701('0x21')];}_0x4c2916[_0x7701('0x15')](_0x4c5c68)[_0x7701('0x22')](_0x29d119);};}exports[_0x7701('0x23')]=function(_0x7a0283,_0x5c90d7){var _0x34dcb7={},_0x188871={},_0x29f164={'count':0x0,'rows':[]};var _0x5572dd=db[_0x7701('0x24')]['rawAttributes'];_0x188871[_0x7701('0x25')]=_['keys'](_0x5572dd);var _0x377ad0={'dateStart':_0x7a0283['query']['dateStart'],'dateEnd':_0x7a0283[_0x7701('0x26')][_0x7701('0x27')]};delete _0x7a0283['query'][_0x7701('0x28')];delete _0x7a0283[_0x7701('0x26')]['dateEnd'];_0x188871[_0x7701('0x26')]=_['keys'](_0x7a0283[_0x7701('0x26')]);_0x188871[_0x7701('0x29')]=_['intersection'](_0x188871[_0x7701('0x25')],_0x188871[_0x7701('0x26')]);_0x34dcb7[_0x7701('0x2a')]=_['intersection'](_0x188871[_0x7701('0x25')],qs[_0x7701('0x2b')](_0x7a0283['query']['fields']));_0x34dcb7[_0x7701('0x2a')]=_0x34dcb7[_0x7701('0x2a')]['length']?_0x34dcb7[_0x7701('0x2a')]:_0x188871[_0x7701('0x25')];if(!_0x7a0283[_0x7701('0x26')]['hasOwnProperty'](_0x7701('0x2c'))){_0x34dcb7[_0x7701('0x19')]=qs[_0x7701('0x19')](_0x7a0283['query'][_0x7701('0x19')]);_0x34dcb7[_0x7701('0x18')]=qs[_0x7701('0x18')](_0x7a0283[_0x7701('0x26')][_0x7701('0x18')]);}_0x34dcb7[_0x7701('0x2d')]=qs[_0x7701('0x2e')](_0x7a0283[_0x7701('0x26')]['sort']);_0x34dcb7[_0x7701('0x2f')]=qs[_0x7701('0x29')](_[_0x7701('0x30')](_0x7a0283['query'],_0x188871[_0x7701('0x29')]));if(_0x377ad0[_0x7701('0x28')]){if(_0x377ad0['dateEnd']){_0x377ad0['dateEnd']=moment(_0x377ad0[_0x7701('0x27')])[_0x7701('0x31')](0x1,_0x7701('0x32'));}else{_0x377ad0['dateEnd']=moment(_0x377ad0[_0x7701('0x28')])[_0x7701('0x31')](0x1,_0x7701('0x32'));}_[_0x7701('0x33')](_0x34dcb7[_0x7701('0x2f')],{'createdAt':{'$gte':_0x377ad0[_0x7701('0x28')],'$lte':_0x377ad0[_0x7701('0x27')]}});}if(_0x7a0283[_0x7701('0x26')][_0x7701('0x34')]){_0x34dcb7[_0x7701('0x2f')]=_[_0x7701('0x33')](_0x34dcb7[_0x7701('0x2f')],{'$or':_[_0x7701('0x35')](_0x5572dd,function(_0x2bd568){if(_0x2bd568[_0x7701('0x36')][_0x7701('0x37')]!==_0x7701('0x38')){var _0x3b8d8a={};_0x3b8d8a[_0x2bd568[_0x7701('0x39')]]={'$like':'%'+_0x7a0283[_0x7701('0x26')][_0x7701('0x34')]+'%'};return _0x3b8d8a;}})});}_0x34dcb7=_[_0x7701('0x33')]({},_0x34dcb7,_0x7a0283[_0x7701('0x3a')]);var _0x2ade07={'where':_0x34dcb7['where']};return db['SmsQueueReport']['count'](_0x2ade07)[_0x7701('0x1e')](function(_0x33e9fd){_0x29f164[_0x7701('0x17')]=_0x33e9fd;if(_0x7a0283[_0x7701('0x26')]['includeAll']){_0x34dcb7[_0x7701('0x3b')]=[{'all':!![]}];}return db[_0x7701('0x24')][_0x7701('0x3c')](_0x34dcb7);})[_0x7701('0x1e')](function(_0x2063aa){_0x29f164[_0x7701('0x3d')]=_0x2063aa;return _0x29f164;})[_0x7701('0x1e')](respondWithFilteredResult(_0x5c90d7,_0x34dcb7))[_0x7701('0x3e')](handleError(_0x5c90d7,null));};exports[_0x7701('0x3f')]=function(_0x194ccc,_0x743f84){var _0x249198={'raw':!![],'where':{'id':_0x194ccc[_0x7701('0x40')]['id']}},_0x4ac186={};_0x4ac186[_0x7701('0x25')]=_[_0x7701('0x41')](db[_0x7701('0x24')][_0x7701('0x42')]);_0x4ac186[_0x7701('0x26')]=_['keys'](_0x194ccc['query']);_0x4ac186['filters']=_['intersection'](_0x4ac186[_0x7701('0x25')],_0x4ac186[_0x7701('0x26')]);_0x249198[_0x7701('0x2a')]=_[_0x7701('0x43')](_0x4ac186[_0x7701('0x25')],qs[_0x7701('0x2b')](_0x194ccc[_0x7701('0x26')]['fields']));_0x249198[_0x7701('0x2a')]=_0x249198[_0x7701('0x2a')][_0x7701('0x44')]?_0x249198[_0x7701('0x2a')]:_0x4ac186[_0x7701('0x25')];if(_0x194ccc[_0x7701('0x26')][_0x7701('0x45')]){_0x249198[_0x7701('0x3b')]=[{'all':!![]}];}_0x249198=_[_0x7701('0x33')]({},_0x249198,_0x194ccc[_0x7701('0x3a')]);return db[_0x7701('0x24')][_0x7701('0x46')](_0x249198)[_0x7701('0x1e')](handleEntityNotFound(_0x743f84,null))[_0x7701('0x1e')](respondWithResult(_0x743f84,null))[_0x7701('0x3e')](handleError(_0x743f84,null));};exports[_0x7701('0x47')]=function(_0x2c7f6b,_0xfc07b2){return db[_0x7701('0x24')][_0x7701('0x47')](_0x2c7f6b[_0x7701('0x48')],{})[_0x7701('0x1e')](respondWithResult(_0xfc07b2,0xc9))['catch'](handleError(_0xfc07b2,null));};exports[_0x7701('0x49')]=function(_0xc755b2,_0x1b1bc3){if(_0xc755b2[_0x7701('0x48')]['id']){delete _0xc755b2['body']['id'];}return db[_0x7701('0x24')][_0x7701('0x46')]({'where':{'id':_0xc755b2[_0x7701('0x40')]['id']}})[_0x7701('0x1e')](handleEntityNotFound(_0x1b1bc3,null))[_0x7701('0x1e')](saveUpdates(_0xc755b2[_0x7701('0x48')],null))[_0x7701('0x1e')](respondWithResult(_0x1b1bc3,null))[_0x7701('0x3e')](handleError(_0x1b1bc3,null));};exports[_0x7701('0x4a')]=function(_0xd66d05,_0x4fe3ee){return db[_0x7701('0x24')][_0x7701('0x46')]({'where':{'id':_0xd66d05['params']['id']}})[_0x7701('0x1e')](handleEntityNotFound(_0x4fe3ee,null))[_0x7701('0x1e')](removeEntity(_0x4fe3ee,null))[_0x7701('0x3e')](handleError(_0x4fe3ee,null));};exports[_0x7701('0x4b')]=function(_0x4664c9,_0x3c67da){return db['SmsQueueReport'][_0x7701('0x4b')]()[_0x7701('0x1e')](respondWithResult(_0x3c67da,null))['catch'](handleError(_0x3c67da,null));};