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 _0x53ca=['moment','mustache','util','path','sox','to-csv','fs-extra','crypto','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../config/license/hardware','../../config/utils','../../config/environment','../../config/license/util','end','undefined','limit','count','offset','status','set','Content-Range','json','apply','save','update','destroy','then','sendStatus','error','stack','name','send','index','map','SmsQueueReport','fieldName','type','key','model','query','keys','filters','attributes','intersection','fields','length','hasOwnProperty','nolimit','sort','where','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','rawAttributes','create','body','find','params','describe','rimraf','zip-dir','fast-json-patch'];(function(_0x2dafbe,_0x5d04de){var _0x58a45a=function(_0x50ac96){while(--_0x50ac96){_0x2dafbe['push'](_0x2dafbe['shift']());}};_0x58a45a(++_0x5d04de);}(_0x53ca,0x1b3));var _0xa53c=function(_0x39336c,_0x5ef836){_0x39336c=_0x39336c-0x0;var _0x36aba1=_0x53ca[_0x39336c];return _0x36aba1;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xa53c('0x0'));var zipdir=require(_0xa53c('0x1'));var jsonpatch=require(_0xa53c('0x2'));var rp=require('request-promise');var moment=require(_0xa53c('0x3'));var BPromise=require('bluebird');var Mustache=require(_0xa53c('0x4'));var util=require(_0xa53c('0x5'));var path=require(_0xa53c('0x6'));var sox=require(_0xa53c('0x7'));var csv=require(_0xa53c('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xa53c('0x9'));var _=require('lodash');var squel=require('squel');var crypto=require(_0xa53c('0xa'));var jsforce=require('jsforce');var deskjs=require(_0xa53c('0xb'));var toCsv=require(_0xa53c('0x8'));var querystring=require(_0xa53c('0xc'));var Papa=require(_0xa53c('0xd'));var Redis=require(_0xa53c('0xe'));var authService=require(_0xa53c('0xf'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xa53c('0x10'));var logger=require('../../config/logger')('api');var utils=require(_0xa53c('0x11'));var config=require(_0xa53c('0x12'));var licenseUtil=require(_0xa53c('0x13'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x49595c,_0x536260){_0x536260=_0x536260||0xcc;return function(_0x1d7e7d){if(_0x1d7e7d){return _0x49595c['sendStatus'](_0x536260);}return _0x49595c['status'](_0x536260)[_0xa53c('0x14')]();};}function respondWithResult(_0x44cc7e,_0x403e77){_0x403e77=_0x403e77||0xc8;return function(_0xd0c30d){if(_0xd0c30d){return _0x44cc7e['status'](_0x403e77)['json'](_0xd0c30d);}};}function respondWithFilteredResult(_0x145601,_0x2bc1bc){return function(_0x135004){if(_0x135004){var _0x213f26=typeof _0x2bc1bc['offset']===_0xa53c('0x15')&&typeof _0x2bc1bc[_0xa53c('0x16')]===_0xa53c('0x15');var _0x5ada43=_0x135004['count'];var _0x16390d=_0x213f26?0x0:_0x2bc1bc['offset'];var _0x1f831d=_0x213f26?_0x135004[_0xa53c('0x17')]:_0x2bc1bc[_0xa53c('0x18')]+_0x2bc1bc[_0xa53c('0x16')];var _0x7b9600;if(_0x1f831d>=_0x5ada43){_0x1f831d=_0x5ada43;_0x7b9600=0xc8;}else{_0x7b9600=0xce;}_0x145601[_0xa53c('0x19')](_0x7b9600);return _0x145601[_0xa53c('0x1a')](_0xa53c('0x1b'),_0x16390d+'-'+_0x1f831d+'/'+_0x5ada43)[_0xa53c('0x1c')](_0x135004);}return null;};}function patchUpdates(_0x53aeaa){return function(_0x4668e4){try{jsonpatch[_0xa53c('0x1d')](_0x4668e4,_0x53aeaa,!![]);}catch(_0x3bcb3d){return BPromise['reject'](_0x3bcb3d);}return _0x4668e4[_0xa53c('0x1e')]();};}function saveUpdates(_0x26d7af,_0x3b493e){return function(_0x12c759){if(_0x12c759){return _0x12c759[_0xa53c('0x1f')](_0x26d7af)['then'](function(_0x6e9407){return _0x6e9407;});}return null;};}function removeEntity(_0x3c75a8,_0x27e1ae){return function(_0x290bdd){if(_0x290bdd){return _0x290bdd[_0xa53c('0x20')]()[_0xa53c('0x21')](function(){_0x3c75a8[_0xa53c('0x19')](0xcc)[_0xa53c('0x14')]();});}};}function handleEntityNotFound(_0x3ce2a6,_0x4dfad8){return function(_0x608d38){if(!_0x608d38){_0x3ce2a6[_0xa53c('0x22')](0x194);}return _0x608d38;};}function handleError(_0x4b361a,_0x9c9cef){_0x9c9cef=_0x9c9cef||0x1f4;return function(_0x5733b1){logger[_0xa53c('0x23')](_0x5733b1[_0xa53c('0x24')]);if(_0x5733b1[_0xa53c('0x25')]){delete _0x5733b1['name'];}_0x4b361a[_0xa53c('0x19')](_0x9c9cef)[_0xa53c('0x26')](_0x5733b1);};}exports[_0xa53c('0x27')]=function(_0x93385e,_0xeb82a0){var _0x2ba51d={},_0x184776={},_0x44c8a6={'count':0x0,'rows':[]};var _0x2a2708=_[_0xa53c('0x28')](db[_0xa53c('0x29')]['rawAttributes'],function(_0x45cf2c){return{'name':_0x45cf2c[_0xa53c('0x2a')],'type':_0x45cf2c[_0xa53c('0x2b')][_0xa53c('0x2c')]};});_0x184776[_0xa53c('0x2d')]=_['map'](_0x2a2708,_0xa53c('0x25'));_0x184776[_0xa53c('0x2e')]=_[_0xa53c('0x2f')](_0x93385e[_0xa53c('0x2e')]);_0x184776[_0xa53c('0x30')]=_['intersection'](_0x184776[_0xa53c('0x2d')],_0x184776['query']);_0x2ba51d[_0xa53c('0x31')]=_[_0xa53c('0x32')](_0x184776['model'],qs[_0xa53c('0x33')](_0x93385e[_0xa53c('0x2e')][_0xa53c('0x33')]));_0x2ba51d[_0xa53c('0x31')]=_0x2ba51d[_0xa53c('0x31')][_0xa53c('0x34')]?_0x2ba51d[_0xa53c('0x31')]:_0x184776['model'];if(!_0x93385e['query'][_0xa53c('0x35')](_0xa53c('0x36'))){_0x2ba51d[_0xa53c('0x16')]=qs[_0xa53c('0x16')](_0x93385e[_0xa53c('0x2e')][_0xa53c('0x16')]);_0x2ba51d[_0xa53c('0x18')]=qs[_0xa53c('0x18')](_0x93385e[_0xa53c('0x2e')][_0xa53c('0x18')]);}_0x2ba51d['order']=qs[_0xa53c('0x37')](_0x93385e[_0xa53c('0x2e')][_0xa53c('0x37')]);_0x2ba51d[_0xa53c('0x38')]=qs['filters'](_['pick'](_0x93385e[_0xa53c('0x2e')],_0x184776['filters']),_0x2a2708);if(_0x93385e[_0xa53c('0x2e')][_0xa53c('0x39')]){_0x2ba51d['where']=_[_0xa53c('0x3a')](_0x2ba51d[_0xa53c('0x38')],{'$or':_[_0xa53c('0x28')](_0x2a2708,function(_0x37cfa3){if(_0x37cfa3[_0xa53c('0x2b')]!==_0xa53c('0x3b')){var _0x22d9ae={};_0x22d9ae[_0x37cfa3[_0xa53c('0x25')]]={'$like':'%'+_0x93385e[_0xa53c('0x2e')]['filter']+'%'};return _0x22d9ae;}})});}_0x2ba51d=_[_0xa53c('0x3a')]({},_0x2ba51d,_0x93385e[_0xa53c('0x3c')]);var _0x44d6ff={'where':_0x2ba51d[_0xa53c('0x38')]};return db['SmsQueueReport']['count'](_0x44d6ff)[_0xa53c('0x21')](function(_0x269b1e){_0x44c8a6['count']=_0x269b1e;if(_0x93385e[_0xa53c('0x2e')][_0xa53c('0x3d')]){_0x2ba51d[_0xa53c('0x3e')]=[{'all':!![]}];}return db[_0xa53c('0x29')][_0xa53c('0x3f')](_0x2ba51d);})[_0xa53c('0x21')](function(_0x12d559){_0x44c8a6[_0xa53c('0x40')]=_0x12d559;return _0x44c8a6;})[_0xa53c('0x21')](respondWithFilteredResult(_0xeb82a0,_0x2ba51d))[_0xa53c('0x41')](handleError(_0xeb82a0,null));};exports[_0xa53c('0x42')]=function(_0x31b8b1,_0x4e2b0e){var _0x243b29={'raw':!![],'where':{'id':_0x31b8b1['params']['id']}},_0x48bfae={};_0x48bfae[_0xa53c('0x2d')]=_[_0xa53c('0x2f')](db[_0xa53c('0x29')][_0xa53c('0x43')]);_0x48bfae[_0xa53c('0x2e')]=_[_0xa53c('0x2f')](_0x31b8b1[_0xa53c('0x2e')]);_0x48bfae[_0xa53c('0x30')]=_[_0xa53c('0x32')](_0x48bfae[_0xa53c('0x2d')],_0x48bfae['query']);_0x243b29[_0xa53c('0x31')]=_[_0xa53c('0x32')](_0x48bfae[_0xa53c('0x2d')],qs[_0xa53c('0x33')](_0x31b8b1['query']['fields']));_0x243b29[_0xa53c('0x31')]=_0x243b29[_0xa53c('0x31')][_0xa53c('0x34')]?_0x243b29[_0xa53c('0x31')]:_0x48bfae[_0xa53c('0x2d')];if(_0x31b8b1[_0xa53c('0x2e')][_0xa53c('0x3d')]){_0x243b29[_0xa53c('0x3e')]=[{'all':!![]}];}_0x243b29=_[_0xa53c('0x3a')]({},_0x243b29,_0x31b8b1[_0xa53c('0x3c')]);return db[_0xa53c('0x29')]['find'](_0x243b29)[_0xa53c('0x21')](handleEntityNotFound(_0x4e2b0e,null))[_0xa53c('0x21')](respondWithResult(_0x4e2b0e,null))[_0xa53c('0x41')](handleError(_0x4e2b0e,null));};exports[_0xa53c('0x44')]=function(_0x2b089d,_0x32dda5){return db['SmsQueueReport'][_0xa53c('0x44')](_0x2b089d[_0xa53c('0x45')],{})['then'](respondWithResult(_0x32dda5,0xc9))[_0xa53c('0x41')](handleError(_0x32dda5,null));};exports[_0xa53c('0x1f')]=function(_0x22d2f0,_0x58098a){if(_0x22d2f0[_0xa53c('0x45')]['id']){delete _0x22d2f0[_0xa53c('0x45')]['id'];}return db[_0xa53c('0x29')][_0xa53c('0x46')]({'where':{'id':_0x22d2f0[_0xa53c('0x47')]['id']}})[_0xa53c('0x21')](handleEntityNotFound(_0x58098a,null))[_0xa53c('0x21')](saveUpdates(_0x22d2f0[_0xa53c('0x45')],null))[_0xa53c('0x21')](respondWithResult(_0x58098a,null))[_0xa53c('0x41')](handleError(_0x58098a,null));};exports[_0xa53c('0x20')]=function(_0x385d2f,_0x3c49ef){return db[_0xa53c('0x29')][_0xa53c('0x46')]({'where':{'id':_0x385d2f['params']['id']}})[_0xa53c('0x21')](handleEntityNotFound(_0x3c49ef,null))[_0xa53c('0x21')](removeEntity(_0x3c49ef,null))[_0xa53c('0x41')](handleError(_0x3c49ef,null));};exports['describe']=function(_0x3813e0,_0x455bd9){return db[_0xa53c('0x29')][_0xa53c('0x48')]()['then'](respondWithResult(_0x455bd9,null))[_0xa53c('0x41')](handleError(_0x455bd9,null));};