server/api/memberReport/memberReport.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 _0x7b77=['map','MemberReport','fieldName','key','name','query','keys','filters','model','fields','attributes','hasOwnProperty','nolimit','order','sort','where','filter','merge','type','VIRTUAL','options','count','includeAll','include','findAll','rows','catch','rawAttributes','filtears','intersection','length','create','body','params','find','describe','html-pdf','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','sox','to-csv','lodash','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','status','offset','limit','set','Content-Range','apply','save','then','destroy','error','stack','send','index'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0x7b77,0x108));var _0x77b7=function(_0x29db36,_0x410ae9){_0x29db36=_0x29db36-0x0;var _0x234e87=_0x7b77[_0x29db36];return _0x234e87;};'use strict';var pdf=require(_0x77b7('0x0'));var emlformat=require(_0x77b7('0x1'));var rimraf=require(_0x77b7('0x2'));var zipdir=require(_0x77b7('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0x77b7('0x4'));var moment=require(_0x77b7('0x5'));var BPromise=require(_0x77b7('0x6'));var Mustache=require(_0x77b7('0x7'));var util=require(_0x77b7('0x8'));var path=require('path');var sox=require(_0x77b7('0x9'));var csv=require(_0x77b7('0xa'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x77b7('0xb'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x77b7('0xc'));var deskjs=require(_0x77b7('0xd'));var toCsv=require(_0x77b7('0xa'));var querystring=require(_0x77b7('0xe'));var Papa=require(_0x77b7('0xf'));var Redis=require(_0x77b7('0x10'));var authService=require(_0x77b7('0x11'));var qs=require(_0x77b7('0x12'));var as=require(_0x77b7('0x13'));var hardwareService=require(_0x77b7('0x14'));var logger=require('../../config/logger')(_0x77b7('0x15'));var utils=require('../../config/utils');var config=require(_0x77b7('0x16'));var licenseUtil=require(_0x77b7('0x17'));var db=require(_0x77b7('0x18'))['db'];function respondWithStatusCode(_0x2172e7,_0x4ff781){_0x4ff781=_0x4ff781||0xcc;return function(_0x597aa4){if(_0x597aa4){return _0x2172e7[_0x77b7('0x19')](_0x4ff781);}return _0x2172e7['status'](_0x4ff781)[_0x77b7('0x1a')]();};}function respondWithResult(_0xf0a756,_0x36ed58){_0x36ed58=_0x36ed58||0xc8;return function(_0xef2bde){if(_0xef2bde){return _0xf0a756[_0x77b7('0x1b')](_0x36ed58)['json'](_0xef2bde);}};}function respondWithFilteredResult(_0x553212,_0x5455c8){return function(_0x3ebb58){if(_0x3ebb58){var _0x3858db=_0x3ebb58['count'],_0x763267=_0x5455c8[_0x77b7('0x1c')],_0x15d891=_0x5455c8[_0x77b7('0x1c')]+_0x5455c8[_0x77b7('0x1d')],_0x40be58;if(_0x15d891>=_0x3858db){_0x15d891=_0x3858db;_0x40be58=0xc8;}else{_0x40be58=0xce;}_0x553212[_0x77b7('0x1b')](_0x40be58);return _0x553212[_0x77b7('0x1e')](_0x77b7('0x1f'),_0x763267+'-'+_0x15d891+'/'+_0x3858db)['json'](_0x3ebb58);}return null;};}function patchUpdates(_0x11142c){return function(_0x22a5e7){try{jsonpatch[_0x77b7('0x20')](_0x22a5e7,_0x11142c,!![]);}catch(_0x4df043){return BPromise['reject'](_0x4df043);}return _0x22a5e7[_0x77b7('0x21')]();};}function saveUpdates(_0x47fdf9,_0x8933e){return function(_0x3ce76b){if(_0x3ce76b){return _0x3ce76b['update'](_0x47fdf9)[_0x77b7('0x22')](function(_0x44c815){return _0x44c815;});}return null;};}function removeEntity(_0x564452,_0x376307){return function(_0x58f106){if(_0x58f106){return _0x58f106[_0x77b7('0x23')]()[_0x77b7('0x22')](function(){_0x564452['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x3d93ff,_0x217695){return function(_0xbe0c4f){if(!_0xbe0c4f){_0x3d93ff[_0x77b7('0x19')](0x194);}return _0xbe0c4f;};}function handleError(_0x130a52,_0x677197){_0x677197=_0x677197||0x1f4;return function(_0x3507ee){logger[_0x77b7('0x24')](_0x3507ee[_0x77b7('0x25')]);if(_0x3507ee['name']){delete _0x3507ee['name'];}_0x130a52[_0x77b7('0x1b')](_0x677197)[_0x77b7('0x26')](_0x3507ee);};}exports[_0x77b7('0x27')]=function(_0x1a6ad2,_0x1a21ba){var _0x4f523e={},_0x344230={},_0x4e488c={'count':0x0,'rows':[]};var _0x4ff96d=_[_0x77b7('0x28')](db[_0x77b7('0x29')]['rawAttributes'],function(_0x2633b5){return{'name':_0x2633b5[_0x77b7('0x2a')],'type':_0x2633b5['type'][_0x77b7('0x2b')]};});_0x344230['model']=_[_0x77b7('0x28')](_0x4ff96d,_0x77b7('0x2c'));_0x344230[_0x77b7('0x2d')]=_[_0x77b7('0x2e')](_0x1a6ad2[_0x77b7('0x2d')]);_0x344230[_0x77b7('0x2f')]=_['intersection'](_0x344230[_0x77b7('0x30')],_0x344230[_0x77b7('0x2d')]);_0x4f523e['attributes']=_['intersection'](_0x344230[_0x77b7('0x30')],qs['fields'](_0x1a6ad2[_0x77b7('0x2d')][_0x77b7('0x31')]));_0x4f523e[_0x77b7('0x32')]=_0x4f523e['attributes']['length']?_0x4f523e[_0x77b7('0x32')]:_0x344230['model'];if(!_0x1a6ad2[_0x77b7('0x2d')][_0x77b7('0x33')](_0x77b7('0x34'))){_0x4f523e[_0x77b7('0x1d')]=qs[_0x77b7('0x1d')](_0x1a6ad2[_0x77b7('0x2d')]['limit']);_0x4f523e[_0x77b7('0x1c')]=qs['offset'](_0x1a6ad2['query'][_0x77b7('0x1c')]);}_0x4f523e[_0x77b7('0x35')]=qs[_0x77b7('0x36')](_0x1a6ad2['query'][_0x77b7('0x36')]);_0x4f523e[_0x77b7('0x37')]=qs[_0x77b7('0x2f')](_['pick'](_0x1a6ad2['query'],_0x344230[_0x77b7('0x2f')]),_0x4ff96d);if(_0x1a6ad2['query'][_0x77b7('0x38')]){_0x4f523e[_0x77b7('0x37')]=_[_0x77b7('0x39')](_0x4f523e['where'],{'$or':_[_0x77b7('0x28')](_0x4ff96d,function(_0x4022b9){if(_0x4022b9[_0x77b7('0x3a')]!==_0x77b7('0x3b')){var _0x2a1151={};_0x2a1151[_0x4022b9[_0x77b7('0x2c')]]={'$like':'%'+_0x1a6ad2['query'][_0x77b7('0x38')]+'%'};return _0x2a1151;}})});}_0x4f523e=_[_0x77b7('0x39')]({},_0x4f523e,_0x1a6ad2[_0x77b7('0x3c')]);var _0x198fce={'where':_0x4f523e['where']};return db['MemberReport'][_0x77b7('0x3d')](_0x198fce)[_0x77b7('0x22')](function(_0x40807d){_0x4e488c[_0x77b7('0x3d')]=_0x40807d;if(_0x1a6ad2[_0x77b7('0x2d')][_0x77b7('0x3e')]){_0x4f523e[_0x77b7('0x3f')]=[{'all':!![]}];}return db['MemberReport'][_0x77b7('0x40')](_0x4f523e);})[_0x77b7('0x22')](function(_0x255dfb){_0x4e488c[_0x77b7('0x41')]=_0x255dfb;return _0x4e488c;})['then'](respondWithFilteredResult(_0x1a21ba,_0x4f523e))[_0x77b7('0x42')](handleError(_0x1a21ba,null));};exports['show']=function(_0x140adc,_0x1525c8){var _0x582c92={'raw':!![],'where':{'id':_0x140adc['params']['id']}},_0x529fb8={};_0x529fb8[_0x77b7('0x30')]=_['keys'](db[_0x77b7('0x29')][_0x77b7('0x43')]);_0x529fb8['query']=_[_0x77b7('0x2e')](_0x140adc[_0x77b7('0x2d')]);_0x529fb8[_0x77b7('0x44')]=_[_0x77b7('0x45')](_0x529fb8[_0x77b7('0x30')],_0x529fb8[_0x77b7('0x2d')]);_0x582c92[_0x77b7('0x32')]=_[_0x77b7('0x45')](_0x529fb8[_0x77b7('0x30')],qs[_0x77b7('0x31')](_0x140adc['query'][_0x77b7('0x31')]));_0x582c92[_0x77b7('0x32')]=_0x582c92[_0x77b7('0x32')][_0x77b7('0x46')]?_0x582c92['attributes']:_0x529fb8[_0x77b7('0x30')];if(_0x140adc[_0x77b7('0x2d')][_0x77b7('0x3e')]){_0x582c92[_0x77b7('0x3f')]=[{'all':!![]}];}_0x582c92=_[_0x77b7('0x39')]({},_0x582c92,_0x140adc[_0x77b7('0x3c')]);return db[_0x77b7('0x29')]['find'](_0x582c92)[_0x77b7('0x22')](handleEntityNotFound(_0x1525c8,null))[_0x77b7('0x22')](respondWithResult(_0x1525c8,null))[_0x77b7('0x42')](handleError(_0x1525c8,null));};exports[_0x77b7('0x47')]=function(_0xb29bea,_0x1e8b70){return db[_0x77b7('0x29')]['create'](_0xb29bea['body'],{})[_0x77b7('0x22')](respondWithResult(_0x1e8b70,0xc9))[_0x77b7('0x42')](handleError(_0x1e8b70,null));};exports['update']=function(_0x24c20b,_0x4b6191){if(_0x24c20b['body']['id']){delete _0x24c20b[_0x77b7('0x48')]['id'];}return db[_0x77b7('0x29')]['find']({'where':{'id':_0x24c20b[_0x77b7('0x49')]['id']}})[_0x77b7('0x22')](handleEntityNotFound(_0x4b6191,null))[_0x77b7('0x22')](saveUpdates(_0x24c20b[_0x77b7('0x48')],null))[_0x77b7('0x22')](respondWithResult(_0x4b6191,null))[_0x77b7('0x42')](handleError(_0x4b6191,null));};exports[_0x77b7('0x23')]=function(_0x241662,_0x5135e6){return db[_0x77b7('0x29')][_0x77b7('0x4a')]({'where':{'id':_0x241662[_0x77b7('0x49')]['id']}})[_0x77b7('0x22')](handleEntityNotFound(_0x5135e6,null))['then'](removeEntity(_0x5135e6,null))[_0x77b7('0x42')](handleError(_0x5135e6,null));};exports[_0x77b7('0x4b')]=function(_0x53fbe0,_0x3dbaa7){return db[_0x77b7('0x29')][_0x77b7('0x4b')]()['then'](respondWithResult(_0x3dbaa7,null))[_0x77b7('0x42')](handleError(_0x3dbaa7,null));};