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 _0xa253=['offset','status','set','Content-Range','apply','reject','save','update','then','sendStatus','stack','name','send','index','MemberReport','rawAttributes','model','query','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','merge','map','type','options','includeAll','include','rows','catch','show','params','length','find','create','body','destroy','describe','eml-format','zip-dir','fast-json-patch','request-promise','moment','util','path','to-csv','ejs','fs-extra','crypto','jsforce','desk.js','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','end','limit','undefined','count'];(function(_0x1ac8ef,_0xe53e2){var _0x90f494=function(_0xa4c37e){while(--_0xa4c37e){_0x1ac8ef['push'](_0x1ac8ef['shift']());}};_0x90f494(++_0xe53e2);}(_0xa253,0x149));var _0x3a25=function(_0x333767,_0x220733){_0x333767=_0x333767-0x0;var _0x42a755=_0xa253[_0x333767];return _0x42a755;};'use strict';var emlformat=require(_0x3a25('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x3a25('0x1'));var jsonpatch=require(_0x3a25('0x2'));var rp=require(_0x3a25('0x3'));var moment=require(_0x3a25('0x4'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x3a25('0x5'));var path=require(_0x3a25('0x6'));var sox=require('sox');var csv=require(_0x3a25('0x7'));var ejs=require(_0x3a25('0x8'));var fs=require('fs');var fs_extra=require(_0x3a25('0x9'));var _=require('lodash');var squel=require('squel');var crypto=require(_0x3a25('0xa'));var jsforce=require(_0x3a25('0xb'));var deskjs=require(_0x3a25('0xc'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x3a25('0xd'));var qs=require(_0x3a25('0xe'));var as=require(_0x3a25('0xf'));var hardwareService=require(_0x3a25('0x10'));var logger=require(_0x3a25('0x11'))(_0x3a25('0x12'));var utils=require('../../config/utils');var config=require(_0x3a25('0x13'));var licenseUtil=require(_0x3a25('0x14'));var db=require(_0x3a25('0x15'))['db'];function respondWithStatusCode(_0x2b134e,_0x5da977){_0x5da977=_0x5da977||0xcc;return function(_0x1c637a){if(_0x1c637a){return _0x2b134e['sendStatus'](_0x5da977);}return _0x2b134e['status'](_0x5da977)[_0x3a25('0x16')]();};}function respondWithResult(_0x246c91,_0x37babb){_0x37babb=_0x37babb||0xc8;return function(_0x3b135d){if(_0x3b135d){return _0x246c91['status'](_0x37babb)['json'](_0x3b135d);}};}function respondWithFilteredResult(_0x4e9650,_0x4a062d){return function(_0xcb3382){if(_0xcb3382){var _0x185a5b=typeof _0x4a062d['offset']==='undefined'&&typeof _0x4a062d[_0x3a25('0x17')]===_0x3a25('0x18');var _0x2b318d=_0xcb3382[_0x3a25('0x19')];var _0x504126=_0x185a5b?0x0:_0x4a062d['offset'];var _0x3cc48d=_0x185a5b?_0xcb3382[_0x3a25('0x19')]:_0x4a062d[_0x3a25('0x1a')]+_0x4a062d['limit'];var _0x276f33;if(_0x3cc48d>=_0x2b318d){_0x3cc48d=_0x2b318d;_0x276f33=0xc8;}else{_0x276f33=0xce;}_0x4e9650[_0x3a25('0x1b')](_0x276f33);return _0x4e9650[_0x3a25('0x1c')](_0x3a25('0x1d'),_0x504126+'-'+_0x3cc48d+'/'+_0x2b318d)['json'](_0xcb3382);}return null;};}function patchUpdates(_0x5e8231){return function(_0x414384){try{jsonpatch[_0x3a25('0x1e')](_0x414384,_0x5e8231,!![]);}catch(_0x3c055c){return BPromise[_0x3a25('0x1f')](_0x3c055c);}return _0x414384[_0x3a25('0x20')]();};}function saveUpdates(_0x4c8760,_0x280de2){return function(_0x58123f){if(_0x58123f){return _0x58123f[_0x3a25('0x21')](_0x4c8760)[_0x3a25('0x22')](function(_0x24c601){return _0x24c601;});}return null;};}function removeEntity(_0x1b0f68,_0x21c513){return function(_0x37b22e){if(_0x37b22e){return _0x37b22e['destroy']()[_0x3a25('0x22')](function(){_0x1b0f68[_0x3a25('0x1b')](0xcc)['end']();});}};}function handleEntityNotFound(_0xc2efb4,_0x6038a4){return function(_0x20a33a){if(!_0x20a33a){_0xc2efb4[_0x3a25('0x23')](0x194);}return _0x20a33a;};}function handleError(_0x564c35,_0x193cd3){_0x193cd3=_0x193cd3||0x1f4;return function(_0x4f27fd){logger['error'](_0x4f27fd[_0x3a25('0x24')]);if(_0x4f27fd[_0x3a25('0x25')]){delete _0x4f27fd[_0x3a25('0x25')];}_0x564c35[_0x3a25('0x1b')](_0x193cd3)[_0x3a25('0x26')](_0x4f27fd);};}exports[_0x3a25('0x27')]=function(_0x1f9efd,_0x756896){var _0x5ad169={},_0x10fca4={},_0x571190={'count':0x0,'rows':[]};var _0x2d22d5=_['map'](db[_0x3a25('0x28')][_0x3a25('0x29')],function(_0x8c8a8f){return{'name':_0x8c8a8f['fieldName'],'type':_0x8c8a8f['type']['key']};});_0x10fca4[_0x3a25('0x2a')]=_['map'](_0x2d22d5,_0x3a25('0x25'));_0x10fca4[_0x3a25('0x2b')]=_['keys'](_0x1f9efd[_0x3a25('0x2b')]);_0x10fca4['filters']=_[_0x3a25('0x2c')](_0x10fca4[_0x3a25('0x2a')],_0x10fca4[_0x3a25('0x2b')]);_0x5ad169[_0x3a25('0x2d')]=_[_0x3a25('0x2c')](_0x10fca4['model'],qs['fields'](_0x1f9efd[_0x3a25('0x2b')][_0x3a25('0x2e')]));_0x5ad169[_0x3a25('0x2d')]=_0x5ad169[_0x3a25('0x2d')]['length']?_0x5ad169[_0x3a25('0x2d')]:_0x10fca4[_0x3a25('0x2a')];if(!_0x1f9efd['query'][_0x3a25('0x2f')](_0x3a25('0x30'))){_0x5ad169[_0x3a25('0x17')]=qs[_0x3a25('0x17')](_0x1f9efd[_0x3a25('0x2b')][_0x3a25('0x17')]);_0x5ad169[_0x3a25('0x1a')]=qs[_0x3a25('0x1a')](_0x1f9efd[_0x3a25('0x2b')][_0x3a25('0x1a')]);}_0x5ad169[_0x3a25('0x31')]=qs['sort'](_0x1f9efd[_0x3a25('0x2b')][_0x3a25('0x32')]);_0x5ad169[_0x3a25('0x33')]=qs[_0x3a25('0x34')](_[_0x3a25('0x35')](_0x1f9efd[_0x3a25('0x2b')],_0x10fca4['filters']),_0x2d22d5);if(_0x1f9efd['query'][_0x3a25('0x36')]){_0x5ad169[_0x3a25('0x33')]=_[_0x3a25('0x37')](_0x5ad169[_0x3a25('0x33')],{'$or':_[_0x3a25('0x38')](_0x2d22d5,function(_0x2cb8ae){if(_0x2cb8ae[_0x3a25('0x39')]!=='VIRTUAL'){var _0xf8b64e={};_0xf8b64e[_0x2cb8ae[_0x3a25('0x25')]]={'$like':'%'+_0x1f9efd[_0x3a25('0x2b')]['filter']+'%'};return _0xf8b64e;}})});}_0x5ad169=_[_0x3a25('0x37')]({},_0x5ad169,_0x1f9efd[_0x3a25('0x3a')]);var _0x314297={'where':_0x5ad169[_0x3a25('0x33')]};return db[_0x3a25('0x28')][_0x3a25('0x19')](_0x314297)[_0x3a25('0x22')](function(_0x4ebdd5){_0x571190[_0x3a25('0x19')]=_0x4ebdd5;if(_0x1f9efd[_0x3a25('0x2b')][_0x3a25('0x3b')]){_0x5ad169[_0x3a25('0x3c')]=[{'all':!![]}];}return db[_0x3a25('0x28')]['findAll'](_0x5ad169);})[_0x3a25('0x22')](function(_0x3e8835){_0x571190[_0x3a25('0x3d')]=_0x3e8835;return _0x571190;})[_0x3a25('0x22')](respondWithFilteredResult(_0x756896,_0x5ad169))[_0x3a25('0x3e')](handleError(_0x756896,null));};exports[_0x3a25('0x3f')]=function(_0x19441c,_0xc3778e){var _0x4c4bd8={'raw':!![],'where':{'id':_0x19441c[_0x3a25('0x40')]['id']}},_0x1c4e62={};_0x1c4e62[_0x3a25('0x2a')]=_['keys'](db[_0x3a25('0x28')][_0x3a25('0x29')]);_0x1c4e62['query']=_['keys'](_0x19441c[_0x3a25('0x2b')]);_0x1c4e62[_0x3a25('0x34')]=_[_0x3a25('0x2c')](_0x1c4e62[_0x3a25('0x2a')],_0x1c4e62[_0x3a25('0x2b')]);_0x4c4bd8['attributes']=_[_0x3a25('0x2c')](_0x1c4e62[_0x3a25('0x2a')],qs[_0x3a25('0x2e')](_0x19441c[_0x3a25('0x2b')][_0x3a25('0x2e')]));_0x4c4bd8[_0x3a25('0x2d')]=_0x4c4bd8[_0x3a25('0x2d')][_0x3a25('0x41')]?_0x4c4bd8[_0x3a25('0x2d')]:_0x1c4e62['model'];if(_0x19441c[_0x3a25('0x2b')][_0x3a25('0x3b')]){_0x4c4bd8[_0x3a25('0x3c')]=[{'all':!![]}];}_0x4c4bd8=_[_0x3a25('0x37')]({},_0x4c4bd8,_0x19441c[_0x3a25('0x3a')]);return db[_0x3a25('0x28')][_0x3a25('0x42')](_0x4c4bd8)[_0x3a25('0x22')](handleEntityNotFound(_0xc3778e,null))[_0x3a25('0x22')](respondWithResult(_0xc3778e,null))[_0x3a25('0x3e')](handleError(_0xc3778e,null));};exports[_0x3a25('0x43')]=function(_0x307e5b,_0x4fdb5e){return db['MemberReport'][_0x3a25('0x43')](_0x307e5b[_0x3a25('0x44')],{})[_0x3a25('0x22')](respondWithResult(_0x4fdb5e,0xc9))[_0x3a25('0x3e')](handleError(_0x4fdb5e,null));};exports[_0x3a25('0x21')]=function(_0x3a06b4,_0x19da70){if(_0x3a06b4[_0x3a25('0x44')]['id']){delete _0x3a06b4['body']['id'];}return db[_0x3a25('0x28')]['find']({'where':{'id':_0x3a06b4[_0x3a25('0x40')]['id']}})[_0x3a25('0x22')](handleEntityNotFound(_0x19da70,null))[_0x3a25('0x22')](saveUpdates(_0x3a06b4[_0x3a25('0x44')],null))[_0x3a25('0x22')](respondWithResult(_0x19da70,null))[_0x3a25('0x3e')](handleError(_0x19da70,null));};exports[_0x3a25('0x45')]=function(_0x4e6e56,_0x3e47ab){return db[_0x3a25('0x28')][_0x3a25('0x42')]({'where':{'id':_0x4e6e56[_0x3a25('0x40')]['id']}})[_0x3a25('0x22')](handleEntityNotFound(_0x3e47ab,null))[_0x3a25('0x22')](removeEntity(_0x3e47ab,null))[_0x3a25('0x3e')](handleError(_0x3e47ab,null));};exports[_0x3a25('0x46')]=function(_0x4191cc,_0x2a8d1f){return db[_0x3a25('0x28')][_0x3a25('0x46')]()[_0x3a25('0x22')](respondWithResult(_0x2a8d1f,null))[_0x3a25('0x3e')](handleError(_0x2a8d1f,null));};