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 _0x64d5=['limit','status','Content-Range','json','save','update','then','destroy','sendStatus','error','stack','name','index','map','MemberReport','fieldName','type','model','query','keys','filters','intersection','fields','attributes','hasOwnProperty','order','sort','where','pick','filter','VIRTUAL','merge','options','includeAll','include','findAll','catch','params','rawAttributes','length','create','body','find','describe','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','sox','to-csv','lodash','crypto','jsforce','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','end','count','offset'];(function(_0x1ca3ee,_0x3d9885){var _0x321c20=function(_0x548c95){while(--_0x548c95){_0x1ca3ee['push'](_0x1ca3ee['shift']());}};_0x321c20(++_0x3d9885);}(_0x64d5,0x101));var _0x564d=function(_0x542534,_0x8b5b35){_0x542534=_0x542534-0x0;var _0x4912cc=_0x64d5[_0x542534];return _0x4912cc;};'use strict';var pdf=require('html-pdf');var emlformat=require('eml-format');var rimraf=require(_0x564d('0x0'));var zipdir=require(_0x564d('0x1'));var jsonpatch=require(_0x564d('0x2'));var rp=require(_0x564d('0x3'));var moment=require(_0x564d('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x564d('0x5'));var util=require(_0x564d('0x6'));var path=require(_0x564d('0x7'));var sox=require(_0x564d('0x8'));var csv=require(_0x564d('0x9'));var ejs=require('ejs');var fs=require('fs');var _=require(_0x564d('0xa'));var squel=require('squel');var crypto=require(_0x564d('0xb'));var jsforce=require(_0x564d('0xc'));var deskjs=require('desk.js');var toCsv=require(_0x564d('0x9'));var querystring=require(_0x564d('0xd'));var Papa=require('papaparse');var Redis=require(_0x564d('0xe'));var authService=require(_0x564d('0xf'));var qs=require(_0x564d('0x10'));var as=require(_0x564d('0x11'));var hardwareService=require(_0x564d('0x12'));var logger=require(_0x564d('0x13'))(_0x564d('0x14'));var utils=require('../../config/utils');var config=require(_0x564d('0x15'));var licenseUtil=require(_0x564d('0x16'));var db=require(_0x564d('0x17'))['db'];function respondWithStatusCode(_0x542d3d,_0x4e4082){_0x4e4082=_0x4e4082||0xcc;return function(_0x94bb38){if(_0x94bb38){return _0x542d3d['sendStatus'](_0x4e4082);}return _0x542d3d['status'](_0x4e4082)[_0x564d('0x18')]();};}function respondWithResult(_0x3657a9,_0x13009a){_0x13009a=_0x13009a||0xc8;return function(_0x18afd4){if(_0x18afd4){return _0x3657a9['status'](_0x13009a)['json'](_0x18afd4);}};}function respondWithFilteredResult(_0x16ae82,_0x502fa4){return function(_0x347580){if(_0x347580){var _0x52edae=_0x347580[_0x564d('0x19')],_0x74a074=_0x502fa4[_0x564d('0x1a')],_0x5931f7=_0x502fa4[_0x564d('0x1a')]+_0x502fa4[_0x564d('0x1b')],_0x415f69;if(_0x5931f7>=_0x52edae){_0x5931f7=_0x52edae;_0x415f69=0xc8;}else{_0x415f69=0xce;}_0x16ae82[_0x564d('0x1c')](_0x415f69);return _0x16ae82['set'](_0x564d('0x1d'),_0x74a074+'-'+_0x5931f7+'/'+_0x52edae)[_0x564d('0x1e')](_0x347580);}return null;};}function patchUpdates(_0xcc55d3){return function(_0x312986){try{jsonpatch['apply'](_0x312986,_0xcc55d3,!![]);}catch(_0x57b7a1){return BPromise['reject'](_0x57b7a1);}return _0x312986[_0x564d('0x1f')]();};}function saveUpdates(_0x5cae22,_0x1d095b){return function(_0x196717){if(_0x196717){return _0x196717[_0x564d('0x20')](_0x5cae22)[_0x564d('0x21')](function(_0x3f3663){return _0x3f3663;});}return null;};}function removeEntity(_0x2eab92,_0x212a37){return function(_0xf035b){if(_0xf035b){return _0xf035b[_0x564d('0x22')]()[_0x564d('0x21')](function(){_0x2eab92[_0x564d('0x1c')](0xcc)[_0x564d('0x18')]();});}};}function handleEntityNotFound(_0x327299,_0x5c8ab0){return function(_0x51477e){if(!_0x51477e){_0x327299[_0x564d('0x23')](0x194);}return _0x51477e;};}function handleError(_0x131af3,_0xa16bb6){_0xa16bb6=_0xa16bb6||0x1f4;return function(_0x12c263){logger[_0x564d('0x24')](_0x12c263[_0x564d('0x25')]);if(_0x12c263[_0x564d('0x26')]){delete _0x12c263[_0x564d('0x26')];}_0x131af3[_0x564d('0x1c')](_0xa16bb6)['send'](_0x12c263);};}exports[_0x564d('0x27')]=function(_0x7fa701,_0x162ffa){var _0x1fb8ba={},_0x5aedd8={},_0x21bff2={'count':0x0,'rows':[]};var _0x2f41e8=_[_0x564d('0x28')](db[_0x564d('0x29')]['rawAttributes'],function(_0x28d93c){return{'name':_0x28d93c[_0x564d('0x2a')],'type':_0x28d93c[_0x564d('0x2b')]['key']};});_0x5aedd8[_0x564d('0x2c')]=_[_0x564d('0x28')](_0x2f41e8,'name');_0x5aedd8[_0x564d('0x2d')]=_[_0x564d('0x2e')](_0x7fa701[_0x564d('0x2d')]);_0x5aedd8[_0x564d('0x2f')]=_[_0x564d('0x30')](_0x5aedd8['model'],_0x5aedd8[_0x564d('0x2d')]);_0x1fb8ba['attributes']=_['intersection'](_0x5aedd8[_0x564d('0x2c')],qs[_0x564d('0x31')](_0x7fa701[_0x564d('0x2d')]['fields']));_0x1fb8ba[_0x564d('0x32')]=_0x1fb8ba['attributes']['length']?_0x1fb8ba[_0x564d('0x32')]:_0x5aedd8[_0x564d('0x2c')];if(!_0x7fa701[_0x564d('0x2d')][_0x564d('0x33')]('nolimit')){_0x1fb8ba[_0x564d('0x1b')]=qs['limit'](_0x7fa701[_0x564d('0x2d')][_0x564d('0x1b')]);_0x1fb8ba[_0x564d('0x1a')]=qs[_0x564d('0x1a')](_0x7fa701[_0x564d('0x2d')][_0x564d('0x1a')]);}_0x1fb8ba[_0x564d('0x34')]=qs[_0x564d('0x35')](_0x7fa701[_0x564d('0x2d')][_0x564d('0x35')]);_0x1fb8ba[_0x564d('0x36')]=qs[_0x564d('0x2f')](_[_0x564d('0x37')](_0x7fa701[_0x564d('0x2d')],_0x5aedd8[_0x564d('0x2f')]),_0x2f41e8);if(_0x7fa701['query'][_0x564d('0x38')]){_0x1fb8ba[_0x564d('0x36')]=_['merge'](_0x1fb8ba[_0x564d('0x36')],{'$or':_[_0x564d('0x28')](_0x2f41e8,function(_0x606297){if(_0x606297[_0x564d('0x2b')]!==_0x564d('0x39')){var _0x246a71={};_0x246a71[_0x606297['name']]={'$like':'%'+_0x7fa701['query']['filter']+'%'};return _0x246a71;}})});}_0x1fb8ba=_[_0x564d('0x3a')]({},_0x1fb8ba,_0x7fa701[_0x564d('0x3b')]);var _0x5a349f={'where':_0x1fb8ba['where']};return db[_0x564d('0x29')][_0x564d('0x19')](_0x5a349f)[_0x564d('0x21')](function(_0x2be138){_0x21bff2[_0x564d('0x19')]=_0x2be138;if(_0x7fa701['query'][_0x564d('0x3c')]){_0x1fb8ba[_0x564d('0x3d')]=[{'all':!![]}];}return db['MemberReport'][_0x564d('0x3e')](_0x1fb8ba);})[_0x564d('0x21')](function(_0x5d7842){_0x21bff2['rows']=_0x5d7842;return _0x21bff2;})['then'](respondWithFilteredResult(_0x162ffa,_0x1fb8ba))[_0x564d('0x3f')](handleError(_0x162ffa,null));};exports['show']=function(_0x358169,_0x3bfc47){var _0x377f3f={'raw':!![],'where':{'id':_0x358169[_0x564d('0x40')]['id']}},_0x27d885={};_0x27d885[_0x564d('0x2c')]=_[_0x564d('0x2e')](db[_0x564d('0x29')][_0x564d('0x41')]);_0x27d885[_0x564d('0x2d')]=_[_0x564d('0x2e')](_0x358169[_0x564d('0x2d')]);_0x27d885[_0x564d('0x2f')]=_['intersection'](_0x27d885[_0x564d('0x2c')],_0x27d885[_0x564d('0x2d')]);_0x377f3f[_0x564d('0x32')]=_[_0x564d('0x30')](_0x27d885[_0x564d('0x2c')],qs[_0x564d('0x31')](_0x358169[_0x564d('0x2d')]['fields']));_0x377f3f[_0x564d('0x32')]=_0x377f3f[_0x564d('0x32')][_0x564d('0x42')]?_0x377f3f['attributes']:_0x27d885['model'];if(_0x358169[_0x564d('0x2d')]['includeAll']){_0x377f3f['include']=[{'all':!![]}];}_0x377f3f=_['merge']({},_0x377f3f,_0x358169[_0x564d('0x3b')]);return db[_0x564d('0x29')]['find'](_0x377f3f)[_0x564d('0x21')](handleEntityNotFound(_0x3bfc47,null))['then'](respondWithResult(_0x3bfc47,null))[_0x564d('0x3f')](handleError(_0x3bfc47,null));};exports[_0x564d('0x43')]=function(_0x5d33e0,_0x40b102){return db[_0x564d('0x29')][_0x564d('0x43')](_0x5d33e0[_0x564d('0x44')],{})[_0x564d('0x21')](respondWithResult(_0x40b102,0xc9))[_0x564d('0x3f')](handleError(_0x40b102,null));};exports[_0x564d('0x20')]=function(_0x34f24f,_0x4b4411){if(_0x34f24f['body']['id']){delete _0x34f24f[_0x564d('0x44')]['id'];}return db[_0x564d('0x29')][_0x564d('0x45')]({'where':{'id':_0x34f24f[_0x564d('0x40')]['id']}})[_0x564d('0x21')](handleEntityNotFound(_0x4b4411,null))[_0x564d('0x21')](saveUpdates(_0x34f24f[_0x564d('0x44')],null))[_0x564d('0x21')](respondWithResult(_0x4b4411,null))[_0x564d('0x3f')](handleError(_0x4b4411,null));};exports[_0x564d('0x22')]=function(_0x1cac6c,_0x19fc84){return db[_0x564d('0x29')][_0x564d('0x45')]({'where':{'id':_0x1cac6c[_0x564d('0x40')]['id']}})[_0x564d('0x21')](handleEntityNotFound(_0x19fc84,null))[_0x564d('0x21')](removeEntity(_0x19fc84,null))['catch'](handleError(_0x19fc84,null));};exports['describe']=function(_0x2197ab,_0x1bb332){return db[_0x564d('0x29')][_0x564d('0x46')]()[_0x564d('0x21')](respondWithResult(_0x1bb332,null))[_0x564d('0x3f')](handleError(_0x1bb332,null));};