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 _0xf5ea=['includeAll','include','findAll','rows','show','find','catch','create','body','destroy','params','describe','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','status','end','json','offset','Content-Range','apply','reject','save','update','then','error','stack','send','index','map','MemberReport','rawAttributes','key','name','keys','query','intersection','attributes','model','fields','length','hasOwnProperty','nolimit','limit','order','sort','where','filters','pick','filter','merge','VIRTUAL','count'];(function(_0x126fb9,_0x122c59){var _0xc8a3b1=function(_0x355744){while(--_0x355744){_0x126fb9['push'](_0x126fb9['shift']());}};_0xc8a3b1(++_0x122c59);}(_0xf5ea,0xa2));var _0xaf5e=function(_0x1facfa,_0x1acf7d){_0x1facfa=_0x1facfa-0x0;var _0x9ec701=_0xf5ea[_0x1facfa];return _0x9ec701;};'use strict';var pdf=require(_0xaf5e('0x0'));var emlformat=require(_0xaf5e('0x1'));var rimraf=require(_0xaf5e('0x2'));var zipdir=require(_0xaf5e('0x3'));var jsonpatch=require(_0xaf5e('0x4'));var rp=require(_0xaf5e('0x5'));var moment=require(_0xaf5e('0x6'));var BPromise=require(_0xaf5e('0x7'));var Mustache=require(_0xaf5e('0x8'));var util=require(_0xaf5e('0x9'));var path=require('path');var sox=require(_0xaf5e('0xa'));var csv=require(_0xaf5e('0xb'));var ejs=require(_0xaf5e('0xc'));var fs=require('fs');var _=require(_0xaf5e('0xd'));var squel=require(_0xaf5e('0xe'));var crypto=require(_0xaf5e('0xf'));var jsforce=require(_0xaf5e('0x10'));var deskjs=require(_0xaf5e('0x11'));var toCsv=require(_0xaf5e('0xb'));var querystring=require('querystring');var Papa=require(_0xaf5e('0x12'));var Redis=require('ioredis');var authService=require(_0xaf5e('0x13'));var qs=require(_0xaf5e('0x14'));var as=require(_0xaf5e('0x15'));var hardwareService=require(_0xaf5e('0x16'));var logger=require('../../config/logger')(_0xaf5e('0x17'));var utils=require(_0xaf5e('0x18'));var config=require('../../config/environment');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x1ae471,_0x15c163){_0x15c163=_0x15c163||0xcc;return function(_0x1871bc){if(_0x1871bc){return _0x1ae471['sendStatus'](_0x15c163);}return _0x1ae471[_0xaf5e('0x19')](_0x15c163)[_0xaf5e('0x1a')]();};}function respondWithResult(_0x1998fd,_0x3dad3a){_0x3dad3a=_0x3dad3a||0xc8;return function(_0x15e4b1){if(_0x15e4b1){return _0x1998fd[_0xaf5e('0x19')](_0x3dad3a)[_0xaf5e('0x1b')](_0x15e4b1);}};}function respondWithFilteredResult(_0x597c71,_0x2ab6ca){return function(_0x398bf6){if(_0x398bf6){var _0x211f34=_0x398bf6['count'],_0x203468=_0x2ab6ca[_0xaf5e('0x1c')],_0x28779d=_0x2ab6ca[_0xaf5e('0x1c')]+_0x2ab6ca['limit'],_0x1b4d2f;if(_0x28779d>=_0x211f34){_0x28779d=_0x211f34;_0x1b4d2f=0xc8;}else{_0x1b4d2f=0xce;}_0x597c71[_0xaf5e('0x19')](_0x1b4d2f);return _0x597c71['set'](_0xaf5e('0x1d'),_0x203468+'-'+_0x28779d+'/'+_0x211f34)[_0xaf5e('0x1b')](_0x398bf6);}return null;};}function patchUpdates(_0x561844){return function(_0x4b51af){try{jsonpatch[_0xaf5e('0x1e')](_0x4b51af,_0x561844,!![]);}catch(_0x3c8a43){return BPromise[_0xaf5e('0x1f')](_0x3c8a43);}return _0x4b51af[_0xaf5e('0x20')]();};}function saveUpdates(_0x561e7a,_0x37bcd6){return function(_0x3977d7){if(_0x3977d7){return _0x3977d7[_0xaf5e('0x21')](_0x561e7a)[_0xaf5e('0x22')](function(_0x26c264){return _0x26c264;});}return null;};}function removeEntity(_0x2733ea,_0x421dda){return function(_0x430e25){if(_0x430e25){return _0x430e25['destroy']()[_0xaf5e('0x22')](function(){_0x2733ea['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x15700e,_0x4cd2a7){return function(_0x3d8ff8){if(!_0x3d8ff8){_0x15700e['sendStatus'](0x194);}return _0x3d8ff8;};}function handleError(_0x50f769,_0x5de633){_0x5de633=_0x5de633||0x1f4;return function(_0x379705){logger[_0xaf5e('0x23')](_0x379705[_0xaf5e('0x24')]);if(_0x379705['name']){delete _0x379705['name'];}_0x50f769['status'](_0x5de633)[_0xaf5e('0x25')](_0x379705);};}exports[_0xaf5e('0x26')]=function(_0x50498e,_0x289bce){var _0x45d7fe={},_0x54c281={},_0xa54237={'count':0x0,'rows':[]};var _0x12043a=_[_0xaf5e('0x27')](db[_0xaf5e('0x28')][_0xaf5e('0x29')],function(_0x1883b7){return{'name':_0x1883b7['fieldName'],'type':_0x1883b7['type'][_0xaf5e('0x2a')]};});_0x54c281['model']=_[_0xaf5e('0x27')](_0x12043a,_0xaf5e('0x2b'));_0x54c281['query']=_[_0xaf5e('0x2c')](_0x50498e[_0xaf5e('0x2d')]);_0x54c281['filters']=_[_0xaf5e('0x2e')](_0x54c281['model'],_0x54c281[_0xaf5e('0x2d')]);_0x45d7fe[_0xaf5e('0x2f')]=_[_0xaf5e('0x2e')](_0x54c281[_0xaf5e('0x30')],qs[_0xaf5e('0x31')](_0x50498e[_0xaf5e('0x2d')][_0xaf5e('0x31')]));_0x45d7fe['attributes']=_0x45d7fe[_0xaf5e('0x2f')][_0xaf5e('0x32')]?_0x45d7fe[_0xaf5e('0x2f')]:_0x54c281[_0xaf5e('0x30')];if(!_0x50498e[_0xaf5e('0x2d')][_0xaf5e('0x33')](_0xaf5e('0x34'))){_0x45d7fe['limit']=qs[_0xaf5e('0x35')](_0x50498e[_0xaf5e('0x2d')][_0xaf5e('0x35')]);_0x45d7fe['offset']=qs['offset'](_0x50498e[_0xaf5e('0x2d')][_0xaf5e('0x1c')]);}_0x45d7fe[_0xaf5e('0x36')]=qs[_0xaf5e('0x37')](_0x50498e['query'][_0xaf5e('0x37')]);_0x45d7fe[_0xaf5e('0x38')]=qs[_0xaf5e('0x39')](_[_0xaf5e('0x3a')](_0x50498e['query'],_0x54c281[_0xaf5e('0x39')]));if(_0x50498e[_0xaf5e('0x2d')][_0xaf5e('0x3b')]){_0x45d7fe[_0xaf5e('0x38')]=_[_0xaf5e('0x3c')](_0x45d7fe[_0xaf5e('0x38')],{'$or':_[_0xaf5e('0x27')](_0x12043a,function(_0x5a5eaa){if(_0x5a5eaa['type']!==_0xaf5e('0x3d')){var _0x20f9f7={};_0x20f9f7[_0x5a5eaa[_0xaf5e('0x2b')]]={'$like':'%'+_0x50498e[_0xaf5e('0x2d')][_0xaf5e('0x3b')]+'%'};return _0x20f9f7;}})});}_0x45d7fe=_[_0xaf5e('0x3c')]({},_0x45d7fe,_0x50498e['options']);var _0x40c0db={'where':_0x45d7fe[_0xaf5e('0x38')]};return db[_0xaf5e('0x28')]['count'](_0x40c0db)[_0xaf5e('0x22')](function(_0x2f03d8){_0xa54237[_0xaf5e('0x3e')]=_0x2f03d8;if(_0x50498e['query'][_0xaf5e('0x3f')]){_0x45d7fe[_0xaf5e('0x40')]=[{'all':!![]}];}return db[_0xaf5e('0x28')][_0xaf5e('0x41')](_0x45d7fe);})['then'](function(_0x4445fd){_0xa54237[_0xaf5e('0x42')]=_0x4445fd;return _0xa54237;})['then'](respondWithFilteredResult(_0x289bce,_0x45d7fe))['catch'](handleError(_0x289bce,null));};exports[_0xaf5e('0x43')]=function(_0x5c1e70,_0x4805fd){var _0x5f2394={'raw':!![],'where':{'id':_0x5c1e70['params']['id']}},_0xe75460={};_0xe75460['model']=_['keys'](db[_0xaf5e('0x28')][_0xaf5e('0x29')]);_0xe75460['query']=_[_0xaf5e('0x2c')](_0x5c1e70[_0xaf5e('0x2d')]);_0xe75460[_0xaf5e('0x39')]=_[_0xaf5e('0x2e')](_0xe75460[_0xaf5e('0x30')],_0xe75460[_0xaf5e('0x2d')]);_0x5f2394[_0xaf5e('0x2f')]=_['intersection'](_0xe75460[_0xaf5e('0x30')],qs[_0xaf5e('0x31')](_0x5c1e70[_0xaf5e('0x2d')][_0xaf5e('0x31')]));_0x5f2394[_0xaf5e('0x2f')]=_0x5f2394[_0xaf5e('0x2f')]['length']?_0x5f2394['attributes']:_0xe75460[_0xaf5e('0x30')];if(_0x5c1e70[_0xaf5e('0x2d')][_0xaf5e('0x3f')]){_0x5f2394[_0xaf5e('0x40')]=[{'all':!![]}];}_0x5f2394=_[_0xaf5e('0x3c')]({},_0x5f2394,_0x5c1e70['options']);return db[_0xaf5e('0x28')][_0xaf5e('0x44')](_0x5f2394)[_0xaf5e('0x22')](handleEntityNotFound(_0x4805fd,null))[_0xaf5e('0x22')](respondWithResult(_0x4805fd,null))[_0xaf5e('0x45')](handleError(_0x4805fd,null));};exports[_0xaf5e('0x46')]=function(_0x4afee0,_0x38ef54){return db[_0xaf5e('0x28')][_0xaf5e('0x46')](_0x4afee0[_0xaf5e('0x47')],{})[_0xaf5e('0x22')](respondWithResult(_0x38ef54,0xc9))[_0xaf5e('0x45')](handleError(_0x38ef54,null));};exports['update']=function(_0x382fd1,_0x51b8c5){if(_0x382fd1[_0xaf5e('0x47')]['id']){delete _0x382fd1[_0xaf5e('0x47')]['id'];}return db[_0xaf5e('0x28')][_0xaf5e('0x44')]({'where':{'id':_0x382fd1['params']['id']}})['then'](handleEntityNotFound(_0x51b8c5,null))[_0xaf5e('0x22')](saveUpdates(_0x382fd1[_0xaf5e('0x47')],null))['then'](respondWithResult(_0x51b8c5,null))[_0xaf5e('0x45')](handleError(_0x51b8c5,null));};exports[_0xaf5e('0x48')]=function(_0x33cd91,_0x291fe4){return db[_0xaf5e('0x28')][_0xaf5e('0x44')]({'where':{'id':_0x33cd91[_0xaf5e('0x49')]['id']}})[_0xaf5e('0x22')](handleEntityNotFound(_0x291fe4,null))[_0xaf5e('0x22')](removeEntity(_0x291fe4,null))[_0xaf5e('0x45')](handleError(_0x291fe4,null));};exports[_0xaf5e('0x4a')]=function(_0x237e6b,_0x739f22){return db[_0xaf5e('0x28')][_0xaf5e('0x4a')]()['then'](respondWithResult(_0x739f22,null))[_0xaf5e('0x45')](handleError(_0x739f22,null));};