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 _0x48c9=['name','send','index','map','MemberReport','rawAttributes','fieldName','type','query','keys','intersection','model','attributes','fields','hasOwnProperty','nolimit','order','sort','filters','filter','where','merge','VIRTUAL','includeAll','include','findAll','rows','catch','show','params','length','options','find','create','body','update','describe','eml-format','rimraf','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','sendStatus','status','end','json','count','offset','limit','set','Content-Range','apply','reject','save','then','destroy','error','stack'];(function(_0x3cfb38,_0x4e8697){var _0x5c0c91=function(_0x3c6b50){while(--_0x3c6b50){_0x3cfb38['push'](_0x3cfb38['shift']());}};_0x5c0c91(++_0x4e8697);}(_0x48c9,0xc5));var _0x948c=function(_0x213065,_0x3afd09){_0x213065=_0x213065-0x0;var _0x50a790=_0x48c9[_0x213065];return _0x50a790;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x948c('0x0'));var rimraf=require(_0x948c('0x1'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x948c('0x2'));var moment=require(_0x948c('0x3'));var BPromise=require(_0x948c('0x4'));var Mustache=require(_0x948c('0x5'));var util=require(_0x948c('0x6'));var path=require(_0x948c('0x7'));var sox=require(_0x948c('0x8'));var csv=require(_0x948c('0x9'));var ejs=require(_0x948c('0xa'));var fs=require('fs');var _=require(_0x948c('0xb'));var squel=require('squel');var crypto=require(_0x948c('0xc'));var jsforce=require(_0x948c('0xd'));var deskjs=require(_0x948c('0xe'));var toCsv=require(_0x948c('0x9'));var querystring=require(_0x948c('0xf'));var Papa=require(_0x948c('0x10'));var Redis=require(_0x948c('0x11'));var authService=require(_0x948c('0x12'));var qs=require(_0x948c('0x13'));var as=require(_0x948c('0x14'));var hardwareService=require(_0x948c('0x15'));var logger=require(_0x948c('0x16'))(_0x948c('0x17'));var utils=require(_0x948c('0x18'));var config=require(_0x948c('0x19'));var licenseUtil=require(_0x948c('0x1a'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x54b6be,_0x119898){_0x119898=_0x119898||0xcc;return function(_0x366452){if(_0x366452){return _0x54b6be[_0x948c('0x1b')](_0x119898);}return _0x54b6be[_0x948c('0x1c')](_0x119898)[_0x948c('0x1d')]();};}function respondWithResult(_0x384e59,_0x316d53){_0x316d53=_0x316d53||0xc8;return function(_0x2d0424){if(_0x2d0424){return _0x384e59[_0x948c('0x1c')](_0x316d53)[_0x948c('0x1e')](_0x2d0424);}};}function respondWithFilteredResult(_0x26806b,_0x2d89d5){return function(_0x113fd1){if(_0x113fd1){var _0x4596bf=_0x113fd1[_0x948c('0x1f')],_0x277225=_0x2d89d5[_0x948c('0x20')],_0x348397=_0x2d89d5[_0x948c('0x20')]+_0x2d89d5[_0x948c('0x21')],_0x573be4;if(_0x348397>=_0x4596bf){_0x348397=_0x4596bf;_0x573be4=0xc8;}else{_0x573be4=0xce;}_0x26806b[_0x948c('0x1c')](_0x573be4);return _0x26806b[_0x948c('0x22')](_0x948c('0x23'),_0x277225+'-'+_0x348397+'/'+_0x4596bf)[_0x948c('0x1e')](_0x113fd1);}return null;};}function patchUpdates(_0x3a3b82){return function(_0x474dd7){try{jsonpatch[_0x948c('0x24')](_0x474dd7,_0x3a3b82,!![]);}catch(_0x3ceba9){return BPromise[_0x948c('0x25')](_0x3ceba9);}return _0x474dd7[_0x948c('0x26')]();};}function saveUpdates(_0x150c92,_0x22fa9e){return function(_0x1411c6){if(_0x1411c6){return _0x1411c6['update'](_0x150c92)[_0x948c('0x27')](function(_0x393fa4){return _0x393fa4;});}return null;};}function removeEntity(_0x25d993,_0x1fe4c0){return function(_0x8984b1){if(_0x8984b1){return _0x8984b1[_0x948c('0x28')]()[_0x948c('0x27')](function(){_0x25d993[_0x948c('0x1c')](0xcc)[_0x948c('0x1d')]();});}};}function handleEntityNotFound(_0x698389,_0x5cdf47){return function(_0x5edd0c){if(!_0x5edd0c){_0x698389[_0x948c('0x1b')](0x194);}return _0x5edd0c;};}function handleError(_0x4a2e28,_0x31d464){_0x31d464=_0x31d464||0x1f4;return function(_0x48e70c){logger[_0x948c('0x29')](_0x48e70c[_0x948c('0x2a')]);if(_0x48e70c[_0x948c('0x2b')]){delete _0x48e70c[_0x948c('0x2b')];}_0x4a2e28['status'](_0x31d464)[_0x948c('0x2c')](_0x48e70c);};}exports[_0x948c('0x2d')]=function(_0x399fc0,_0x49a328){var _0x546f29={},_0x4762b8={},_0x3810ae={'count':0x0,'rows':[]};var _0x5d1e89=_[_0x948c('0x2e')](db[_0x948c('0x2f')][_0x948c('0x30')],function(_0xa5c5a7){return{'name':_0xa5c5a7[_0x948c('0x31')],'type':_0xa5c5a7[_0x948c('0x32')]['key']};});_0x4762b8['model']=_[_0x948c('0x2e')](_0x5d1e89,_0x948c('0x2b'));_0x4762b8[_0x948c('0x33')]=_[_0x948c('0x34')](_0x399fc0[_0x948c('0x33')]);_0x4762b8['filters']=_[_0x948c('0x35')](_0x4762b8[_0x948c('0x36')],_0x4762b8[_0x948c('0x33')]);_0x546f29[_0x948c('0x37')]=_[_0x948c('0x35')](_0x4762b8[_0x948c('0x36')],qs[_0x948c('0x38')](_0x399fc0[_0x948c('0x33')]['fields']));_0x546f29[_0x948c('0x37')]=_0x546f29[_0x948c('0x37')]['length']?_0x546f29[_0x948c('0x37')]:_0x4762b8[_0x948c('0x36')];if(!_0x399fc0['query'][_0x948c('0x39')](_0x948c('0x3a'))){_0x546f29[_0x948c('0x21')]=qs[_0x948c('0x21')](_0x399fc0['query']['limit']);_0x546f29['offset']=qs[_0x948c('0x20')](_0x399fc0[_0x948c('0x33')][_0x948c('0x20')]);}_0x546f29[_0x948c('0x3b')]=qs[_0x948c('0x3c')](_0x399fc0['query'][_0x948c('0x3c')]);_0x546f29['where']=qs[_0x948c('0x3d')](_['pick'](_0x399fc0['query'],_0x4762b8[_0x948c('0x3d')]),_0x5d1e89);if(_0x399fc0['query'][_0x948c('0x3e')]){_0x546f29[_0x948c('0x3f')]=_[_0x948c('0x40')](_0x546f29[_0x948c('0x3f')],{'$or':_[_0x948c('0x2e')](_0x5d1e89,function(_0x3db2f0){if(_0x3db2f0[_0x948c('0x32')]!==_0x948c('0x41')){var _0x261d1e={};_0x261d1e[_0x3db2f0[_0x948c('0x2b')]]={'$like':'%'+_0x399fc0[_0x948c('0x33')][_0x948c('0x3e')]+'%'};return _0x261d1e;}})});}_0x546f29=_[_0x948c('0x40')]({},_0x546f29,_0x399fc0['options']);var _0x17f181={'where':_0x546f29[_0x948c('0x3f')]};return db['MemberReport']['count'](_0x17f181)[_0x948c('0x27')](function(_0x3fbd03){_0x3810ae[_0x948c('0x1f')]=_0x3fbd03;if(_0x399fc0[_0x948c('0x33')][_0x948c('0x42')]){_0x546f29[_0x948c('0x43')]=[{'all':!![]}];}return db[_0x948c('0x2f')][_0x948c('0x44')](_0x546f29);})[_0x948c('0x27')](function(_0x82f457){_0x3810ae[_0x948c('0x45')]=_0x82f457;return _0x3810ae;})[_0x948c('0x27')](respondWithFilteredResult(_0x49a328,_0x546f29))[_0x948c('0x46')](handleError(_0x49a328,null));};exports[_0x948c('0x47')]=function(_0x48351d,_0x33a197){var _0x24fc6f={'raw':!![],'where':{'id':_0x48351d[_0x948c('0x48')]['id']}},_0xf768e9={};_0xf768e9[_0x948c('0x36')]=_[_0x948c('0x34')](db[_0x948c('0x2f')][_0x948c('0x30')]);_0xf768e9[_0x948c('0x33')]=_[_0x948c('0x34')](_0x48351d['query']);_0xf768e9[_0x948c('0x3d')]=_[_0x948c('0x35')](_0xf768e9['model'],_0xf768e9[_0x948c('0x33')]);_0x24fc6f[_0x948c('0x37')]=_['intersection'](_0xf768e9['model'],qs[_0x948c('0x38')](_0x48351d[_0x948c('0x33')][_0x948c('0x38')]));_0x24fc6f[_0x948c('0x37')]=_0x24fc6f[_0x948c('0x37')][_0x948c('0x49')]?_0x24fc6f[_0x948c('0x37')]:_0xf768e9[_0x948c('0x36')];if(_0x48351d[_0x948c('0x33')]['includeAll']){_0x24fc6f['include']=[{'all':!![]}];}_0x24fc6f=_[_0x948c('0x40')]({},_0x24fc6f,_0x48351d[_0x948c('0x4a')]);return db[_0x948c('0x2f')][_0x948c('0x4b')](_0x24fc6f)[_0x948c('0x27')](handleEntityNotFound(_0x33a197,null))['then'](respondWithResult(_0x33a197,null))[_0x948c('0x46')](handleError(_0x33a197,null));};exports[_0x948c('0x4c')]=function(_0x21e364,_0x39bb35){return db['MemberReport'][_0x948c('0x4c')](_0x21e364[_0x948c('0x4d')],{})['then'](respondWithResult(_0x39bb35,0xc9))[_0x948c('0x46')](handleError(_0x39bb35,null));};exports[_0x948c('0x4e')]=function(_0x2a99dd,_0x589f68){if(_0x2a99dd['body']['id']){delete _0x2a99dd['body']['id'];}return db[_0x948c('0x2f')][_0x948c('0x4b')]({'where':{'id':_0x2a99dd[_0x948c('0x48')]['id']}})[_0x948c('0x27')](handleEntityNotFound(_0x589f68,null))[_0x948c('0x27')](saveUpdates(_0x2a99dd['body'],null))[_0x948c('0x27')](respondWithResult(_0x589f68,null))[_0x948c('0x46')](handleError(_0x589f68,null));};exports[_0x948c('0x28')]=function(_0x290c63,_0x50c6a7){return db[_0x948c('0x2f')]['find']({'where':{'id':_0x290c63[_0x948c('0x48')]['id']}})[_0x948c('0x27')](handleEntityNotFound(_0x50c6a7,null))['then'](removeEntity(_0x50c6a7,null))[_0x948c('0x46')](handleError(_0x50c6a7,null));};exports[_0x948c('0x4f')]=function(_0x97fbc,_0x50c6e9){return db['MemberReport'][_0x948c('0x4f')]()[_0x948c('0x27')](respondWithResult(_0x50c6e9,null))[_0x948c('0x46')](handleError(_0x50c6e9,null));};