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 _0x8855=['order','sort','pick','filter','where','merge','type','VIRTUAL','count','includeAll','include','findAll','rows','catch','show','params','keys','length','options','find','create','body','update','describe','html-pdf','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','sendStatus','end','status','json','offset','limit','set','Content-Range','reject','then','destroy','error','stack','name','send','index','map','MemberReport','rawAttributes','model','query','filters','intersection','attributes','fields'];(function(_0x1b1d3c,_0x554e8c){var _0x4ed334=function(_0x1eefe8){while(--_0x1eefe8){_0x1b1d3c['push'](_0x1b1d3c['shift']());}};_0x4ed334(++_0x554e8c);}(_0x8855,0xaa));var _0x5885=function(_0x48206b,_0x31e00c){_0x48206b=_0x48206b-0x0;var _0x217cf6=_0x8855[_0x48206b];return _0x217cf6;};'use strict';var pdf=require(_0x5885('0x0'));var emlformat=require('eml-format');var rimraf=require(_0x5885('0x1'));var zipdir=require(_0x5885('0x2'));var jsonpatch=require(_0x5885('0x3'));var rp=require(_0x5885('0x4'));var moment=require(_0x5885('0x5'));var BPromise=require(_0x5885('0x6'));var Mustache=require(_0x5885('0x7'));var util=require(_0x5885('0x8'));var path=require(_0x5885('0x9'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x5885('0xa'));var fs=require('fs');var _=require(_0x5885('0xb'));var squel=require(_0x5885('0xc'));var crypto=require(_0x5885('0xd'));var jsforce=require(_0x5885('0xe'));var deskjs=require(_0x5885('0xf'));var toCsv=require('to-csv');var querystring=require(_0x5885('0x10'));var Papa=require('papaparse');var Redis=require(_0x5885('0x11'));var authService=require(_0x5885('0x12'));var qs=require('../../components/parsers/qs');var as=require(_0x5885('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x5885('0x14'))('api');var utils=require(_0x5885('0x15'));var config=require(_0x5885('0x16'));var db=require(_0x5885('0x17'))['db'];function respondWithStatusCode(_0x23d9b3,_0x370cbc){_0x370cbc=_0x370cbc||0xcc;return function(_0x438dfb){if(_0x438dfb){return _0x23d9b3[_0x5885('0x18')](_0x370cbc);}return _0x23d9b3['status'](_0x370cbc)[_0x5885('0x19')]();};}function respondWithResult(_0x3c483e,_0x22397e){_0x22397e=_0x22397e||0xc8;return function(_0x49dc00){if(_0x49dc00){return _0x3c483e[_0x5885('0x1a')](_0x22397e)[_0x5885('0x1b')](_0x49dc00);}};}function respondWithFilteredResult(_0x483c9f,_0x174200){return function(_0x3212f1){if(_0x3212f1){var _0x3c9416=_0x3212f1['count'],_0x5a3d81=_0x174200[_0x5885('0x1c')],_0x34312a=_0x174200['offset']+_0x174200[_0x5885('0x1d')],_0x197016;if(_0x34312a>=_0x3c9416){_0x34312a=_0x3c9416;_0x197016=0xc8;}else{_0x197016=0xce;}_0x483c9f['status'](_0x197016);return _0x483c9f[_0x5885('0x1e')](_0x5885('0x1f'),_0x5a3d81+'-'+_0x34312a+'/'+_0x3c9416)[_0x5885('0x1b')](_0x3212f1);}return null;};}function patchUpdates(_0xa2d841){return function(_0x29ec92){try{jsonpatch['apply'](_0x29ec92,_0xa2d841,!![]);}catch(_0x725798){return BPromise[_0x5885('0x20')](_0x725798);}return _0x29ec92['save']();};}function saveUpdates(_0x19e73f,_0x2adca7){return function(_0x5df7a4){if(_0x5df7a4){return _0x5df7a4['update'](_0x19e73f)[_0x5885('0x21')](function(_0xae8cf0){return _0xae8cf0;});}return null;};}function removeEntity(_0x560ddc,_0x1a03b5){return function(_0x2d056d){if(_0x2d056d){return _0x2d056d[_0x5885('0x22')]()[_0x5885('0x21')](function(){_0x560ddc['status'](0xcc)[_0x5885('0x19')]();});}};}function handleEntityNotFound(_0x1b9db1,_0x7050fc){return function(_0x28e431){if(!_0x28e431){_0x1b9db1[_0x5885('0x18')](0x194);}return _0x28e431;};}function handleError(_0xf2fe9b,_0x5d5ccf){_0x5d5ccf=_0x5d5ccf||0x1f4;return function(_0x1e1a13){logger[_0x5885('0x23')](_0x1e1a13[_0x5885('0x24')]);if(_0x1e1a13[_0x5885('0x25')]){delete _0x1e1a13['name'];}_0xf2fe9b['status'](_0x5d5ccf)[_0x5885('0x26')](_0x1e1a13);};}exports[_0x5885('0x27')]=function(_0x59a437,_0x4a2b24){var _0x2aa9a7={},_0x539d15={},_0x1feeeb={'count':0x0,'rows':[]};var _0x297c30=_[_0x5885('0x28')](db[_0x5885('0x29')][_0x5885('0x2a')],function(_0x4c0d3c){return{'name':_0x4c0d3c['fieldName'],'type':_0x4c0d3c['type']['key']};});_0x539d15[_0x5885('0x2b')]=_[_0x5885('0x28')](_0x297c30,_0x5885('0x25'));_0x539d15['query']=_['keys'](_0x59a437[_0x5885('0x2c')]);_0x539d15[_0x5885('0x2d')]=_[_0x5885('0x2e')](_0x539d15['model'],_0x539d15[_0x5885('0x2c')]);_0x2aa9a7[_0x5885('0x2f')]=_[_0x5885('0x2e')](_0x539d15['model'],qs[_0x5885('0x30')](_0x59a437[_0x5885('0x2c')]['fields']));_0x2aa9a7[_0x5885('0x2f')]=_0x2aa9a7[_0x5885('0x2f')]['length']?_0x2aa9a7['attributes']:_0x539d15[_0x5885('0x2b')];if(!_0x59a437[_0x5885('0x2c')]['hasOwnProperty']('nolimit')){_0x2aa9a7[_0x5885('0x1d')]=qs[_0x5885('0x1d')](_0x59a437['query'][_0x5885('0x1d')]);_0x2aa9a7[_0x5885('0x1c')]=qs['offset'](_0x59a437['query']['offset']);}_0x2aa9a7[_0x5885('0x31')]=qs[_0x5885('0x32')](_0x59a437[_0x5885('0x2c')]['sort']);_0x2aa9a7['where']=qs['filters'](_[_0x5885('0x33')](_0x59a437[_0x5885('0x2c')],_0x539d15[_0x5885('0x2d')]));if(_0x59a437[_0x5885('0x2c')][_0x5885('0x34')]){_0x2aa9a7[_0x5885('0x35')]=_[_0x5885('0x36')](_0x2aa9a7[_0x5885('0x35')],{'$or':_[_0x5885('0x28')](_0x297c30,function(_0x46e4a0){if(_0x46e4a0[_0x5885('0x37')]!==_0x5885('0x38')){var _0x4d6362={};_0x4d6362[_0x46e4a0[_0x5885('0x25')]]={'$like':'%'+_0x59a437[_0x5885('0x2c')][_0x5885('0x34')]+'%'};return _0x4d6362;}})});}_0x2aa9a7=_['merge']({},_0x2aa9a7,_0x59a437['options']);var _0x51d4cb={'where':_0x2aa9a7[_0x5885('0x35')]};return db[_0x5885('0x29')]['count'](_0x51d4cb)[_0x5885('0x21')](function(_0x52fb03){_0x1feeeb[_0x5885('0x39')]=_0x52fb03;if(_0x59a437[_0x5885('0x2c')][_0x5885('0x3a')]){_0x2aa9a7[_0x5885('0x3b')]=[{'all':!![]}];}return db[_0x5885('0x29')][_0x5885('0x3c')](_0x2aa9a7);})[_0x5885('0x21')](function(_0x257020){_0x1feeeb[_0x5885('0x3d')]=_0x257020;return _0x1feeeb;})['then'](respondWithFilteredResult(_0x4a2b24,_0x2aa9a7))[_0x5885('0x3e')](handleError(_0x4a2b24,null));};exports[_0x5885('0x3f')]=function(_0x4dfd7c,_0x332976){var _0x49a5e4={'raw':!![],'where':{'id':_0x4dfd7c[_0x5885('0x40')]['id']}},_0x26588c={};_0x26588c[_0x5885('0x2b')]=_[_0x5885('0x41')](db['MemberReport'][_0x5885('0x2a')]);_0x26588c[_0x5885('0x2c')]=_[_0x5885('0x41')](_0x4dfd7c[_0x5885('0x2c')]);_0x26588c[_0x5885('0x2d')]=_[_0x5885('0x2e')](_0x26588c[_0x5885('0x2b')],_0x26588c[_0x5885('0x2c')]);_0x49a5e4[_0x5885('0x2f')]=_[_0x5885('0x2e')](_0x26588c[_0x5885('0x2b')],qs[_0x5885('0x30')](_0x4dfd7c[_0x5885('0x2c')][_0x5885('0x30')]));_0x49a5e4['attributes']=_0x49a5e4['attributes'][_0x5885('0x42')]?_0x49a5e4['attributes']:_0x26588c['model'];if(_0x4dfd7c['query']['includeAll']){_0x49a5e4[_0x5885('0x3b')]=[{'all':!![]}];}_0x49a5e4=_[_0x5885('0x36')]({},_0x49a5e4,_0x4dfd7c[_0x5885('0x43')]);return db[_0x5885('0x29')][_0x5885('0x44')](_0x49a5e4)['then'](handleEntityNotFound(_0x332976,null))['then'](respondWithResult(_0x332976,null))[_0x5885('0x3e')](handleError(_0x332976,null));};exports[_0x5885('0x45')]=function(_0xebb48c,_0x33a025){return db['MemberReport'][_0x5885('0x45')](_0xebb48c[_0x5885('0x46')],{})[_0x5885('0x21')](respondWithResult(_0x33a025,0xc9))[_0x5885('0x3e')](handleError(_0x33a025,null));};exports[_0x5885('0x47')]=function(_0x31a356,_0x92b33c){if(_0x31a356[_0x5885('0x46')]['id']){delete _0x31a356[_0x5885('0x46')]['id'];}return db['MemberReport'][_0x5885('0x44')]({'where':{'id':_0x31a356['params']['id']}})[_0x5885('0x21')](handleEntityNotFound(_0x92b33c,null))[_0x5885('0x21')](saveUpdates(_0x31a356[_0x5885('0x46')],null))[_0x5885('0x21')](respondWithResult(_0x92b33c,null))['catch'](handleError(_0x92b33c,null));};exports[_0x5885('0x22')]=function(_0x432dfe,_0x165365){return db[_0x5885('0x29')][_0x5885('0x44')]({'where':{'id':_0x432dfe[_0x5885('0x40')]['id']}})[_0x5885('0x21')](handleEntityNotFound(_0x165365,null))[_0x5885('0x21')](removeEntity(_0x165365,null))[_0x5885('0x3e')](handleError(_0x165365,null));};exports[_0x5885('0x48')]=function(_0xc49365,_0x3d665d){return db[_0x5885('0x29')]['describe']()[_0x5885('0x21')](respondWithResult(_0x3d665d,null))[_0x5885('0x3e')](handleError(_0x3d665d,null));};