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 _0xa030=['stack','name','index','map','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','VIRTUAL','filter','merge','options','includeAll','include','MemberReport','findAll','rows','catch','show','params','find','create','body','describe','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','desk.js','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','count','offset','limit','set','Content-Range','json','apply','reject','update','destroy','then','error'];(function(_0x1d7218,_0x34cc1a){var _0x253cd7=function(_0x3421fa){while(--_0x3421fa){_0x1d7218['push'](_0x1d7218['shift']());}};_0x253cd7(++_0x34cc1a);}(_0xa030,0x119));var _0x0a03=function(_0x4d5894,_0x424650){_0x4d5894=_0x4d5894-0x0;var _0x4725c0=_0xa030[_0x4d5894];return _0x4725c0;};'use strict';var pdf=require(_0x0a03('0x0'));var emlformat=require(_0x0a03('0x1'));var rimraf=require(_0x0a03('0x2'));var zipdir=require(_0x0a03('0x3'));var jsonpatch=require(_0x0a03('0x4'));var rp=require(_0x0a03('0x5'));var moment=require(_0x0a03('0x6'));var BPromise=require('bluebird');var Mustache=require(_0x0a03('0x7'));var util=require(_0x0a03('0x8'));var path=require(_0x0a03('0x9'));var sox=require(_0x0a03('0xa'));var csv=require(_0x0a03('0xb'));var ejs=require(_0x0a03('0xc'));var fs=require('fs');var _=require(_0x0a03('0xd'));var squel=require(_0x0a03('0xe'));var crypto=require(_0x0a03('0xf'));var jsforce=require('jsforce');var deskjs=require(_0x0a03('0x10'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x0a03('0x11'));var Redis=require('ioredis');var authService=require(_0x0a03('0x12'));var qs=require(_0x0a03('0x13'));var as=require(_0x0a03('0x14'));var hardwareService=require(_0x0a03('0x15'));var logger=require(_0x0a03('0x16'))(_0x0a03('0x17'));var utils=require(_0x0a03('0x18'));var config=require(_0x0a03('0x19'));var licenseUtil=require(_0x0a03('0x1a'));var db=require(_0x0a03('0x1b'))['db'];function respondWithStatusCode(_0x4c693f,_0x593ba9){_0x593ba9=_0x593ba9||0xcc;return function(_0x44ce22){if(_0x44ce22){return _0x4c693f[_0x0a03('0x1c')](_0x593ba9);}return _0x4c693f[_0x0a03('0x1d')](_0x593ba9)[_0x0a03('0x1e')]();};}function respondWithResult(_0x17a770,_0x149d3e){_0x149d3e=_0x149d3e||0xc8;return function(_0x3fd363){if(_0x3fd363){return _0x17a770[_0x0a03('0x1d')](_0x149d3e)['json'](_0x3fd363);}};}function respondWithFilteredResult(_0x4b8cf1,_0x180f3b){return function(_0x24e840){if(_0x24e840){var _0x5bdb22=_0x24e840[_0x0a03('0x1f')],_0x317298=_0x180f3b[_0x0a03('0x20')],_0x576e3a=_0x180f3b[_0x0a03('0x20')]+_0x180f3b[_0x0a03('0x21')],_0x553164;if(_0x576e3a>=_0x5bdb22){_0x576e3a=_0x5bdb22;_0x553164=0xc8;}else{_0x553164=0xce;}_0x4b8cf1[_0x0a03('0x1d')](_0x553164);return _0x4b8cf1[_0x0a03('0x22')](_0x0a03('0x23'),_0x317298+'-'+_0x576e3a+'/'+_0x5bdb22)[_0x0a03('0x24')](_0x24e840);}return null;};}function patchUpdates(_0x418ce8){return function(_0x52958a){try{jsonpatch[_0x0a03('0x25')](_0x52958a,_0x418ce8,!![]);}catch(_0x1cf6d6){return BPromise[_0x0a03('0x26')](_0x1cf6d6);}return _0x52958a['save']();};}function saveUpdates(_0x492138,_0x3dc291){return function(_0x4e343e){if(_0x4e343e){return _0x4e343e[_0x0a03('0x27')](_0x492138)['then'](function(_0x3c423e){return _0x3c423e;});}return null;};}function removeEntity(_0x5e46c4,_0x51ce42){return function(_0x48ae19){if(_0x48ae19){return _0x48ae19[_0x0a03('0x28')]()[_0x0a03('0x29')](function(){_0x5e46c4[_0x0a03('0x1d')](0xcc)[_0x0a03('0x1e')]();});}};}function handleEntityNotFound(_0x519540,_0x2f387b){return function(_0x46e551){if(!_0x46e551){_0x519540[_0x0a03('0x1c')](0x194);}return _0x46e551;};}function handleError(_0x53d0be,_0x5b72fd){_0x5b72fd=_0x5b72fd||0x1f4;return function(_0x9b507){logger[_0x0a03('0x2a')](_0x9b507[_0x0a03('0x2b')]);if(_0x9b507['name']){delete _0x9b507[_0x0a03('0x2c')];}_0x53d0be[_0x0a03('0x1d')](_0x5b72fd)['send'](_0x9b507);};}exports[_0x0a03('0x2d')]=function(_0x37fc81,_0x3a4b53){var _0x1b68be={},_0x3bb0be={},_0x420657={'count':0x0,'rows':[]};var _0x21d1a1=_[_0x0a03('0x2e')](db['MemberReport'][_0x0a03('0x2f')],function(_0x4cd476){return{'name':_0x4cd476[_0x0a03('0x30')],'type':_0x4cd476[_0x0a03('0x31')][_0x0a03('0x32')]};});_0x3bb0be[_0x0a03('0x33')]=_[_0x0a03('0x2e')](_0x21d1a1,_0x0a03('0x2c'));_0x3bb0be[_0x0a03('0x34')]=_[_0x0a03('0x35')](_0x37fc81['query']);_0x3bb0be[_0x0a03('0x36')]=_[_0x0a03('0x37')](_0x3bb0be[_0x0a03('0x33')],_0x3bb0be[_0x0a03('0x34')]);_0x1b68be[_0x0a03('0x38')]=_[_0x0a03('0x37')](_0x3bb0be[_0x0a03('0x33')],qs['fields'](_0x37fc81[_0x0a03('0x34')][_0x0a03('0x39')]));_0x1b68be[_0x0a03('0x38')]=_0x1b68be[_0x0a03('0x38')][_0x0a03('0x3a')]?_0x1b68be[_0x0a03('0x38')]:_0x3bb0be[_0x0a03('0x33')];if(!_0x37fc81[_0x0a03('0x34')][_0x0a03('0x3b')](_0x0a03('0x3c'))){_0x1b68be['limit']=qs[_0x0a03('0x21')](_0x37fc81[_0x0a03('0x34')][_0x0a03('0x21')]);_0x1b68be[_0x0a03('0x20')]=qs[_0x0a03('0x20')](_0x37fc81[_0x0a03('0x34')][_0x0a03('0x20')]);}_0x1b68be[_0x0a03('0x3d')]=qs[_0x0a03('0x3e')](_0x37fc81[_0x0a03('0x34')]['sort']);_0x1b68be[_0x0a03('0x3f')]=qs['filters'](_[_0x0a03('0x40')](_0x37fc81[_0x0a03('0x34')],_0x3bb0be[_0x0a03('0x36')]),_0x21d1a1);if(_0x37fc81[_0x0a03('0x34')]['filter']){_0x1b68be[_0x0a03('0x3f')]=_['merge'](_0x1b68be[_0x0a03('0x3f')],{'$or':_[_0x0a03('0x2e')](_0x21d1a1,function(_0x22ea3f){if(_0x22ea3f['type']!==_0x0a03('0x41')){var _0x359df6={};_0x359df6[_0x22ea3f[_0x0a03('0x2c')]]={'$like':'%'+_0x37fc81[_0x0a03('0x34')][_0x0a03('0x42')]+'%'};return _0x359df6;}})});}_0x1b68be=_[_0x0a03('0x43')]({},_0x1b68be,_0x37fc81[_0x0a03('0x44')]);var _0x466f9a={'where':_0x1b68be[_0x0a03('0x3f')]};return db['MemberReport'][_0x0a03('0x1f')](_0x466f9a)[_0x0a03('0x29')](function(_0x2fd8cb){_0x420657[_0x0a03('0x1f')]=_0x2fd8cb;if(_0x37fc81[_0x0a03('0x34')][_0x0a03('0x45')]){_0x1b68be[_0x0a03('0x46')]=[{'all':!![]}];}return db[_0x0a03('0x47')][_0x0a03('0x48')](_0x1b68be);})[_0x0a03('0x29')](function(_0x2a4d9f){_0x420657[_0x0a03('0x49')]=_0x2a4d9f;return _0x420657;})[_0x0a03('0x29')](respondWithFilteredResult(_0x3a4b53,_0x1b68be))[_0x0a03('0x4a')](handleError(_0x3a4b53,null));};exports[_0x0a03('0x4b')]=function(_0x42d490,_0x5a43e7){var _0x248d98={'raw':!![],'where':{'id':_0x42d490[_0x0a03('0x4c')]['id']}},_0x20f6cc={};_0x20f6cc[_0x0a03('0x33')]=_[_0x0a03('0x35')](db[_0x0a03('0x47')][_0x0a03('0x2f')]);_0x20f6cc['query']=_[_0x0a03('0x35')](_0x42d490[_0x0a03('0x34')]);_0x20f6cc[_0x0a03('0x36')]=_['intersection'](_0x20f6cc['model'],_0x20f6cc['query']);_0x248d98[_0x0a03('0x38')]=_[_0x0a03('0x37')](_0x20f6cc['model'],qs[_0x0a03('0x39')](_0x42d490['query'][_0x0a03('0x39')]));_0x248d98[_0x0a03('0x38')]=_0x248d98[_0x0a03('0x38')]['length']?_0x248d98[_0x0a03('0x38')]:_0x20f6cc['model'];if(_0x42d490[_0x0a03('0x34')]['includeAll']){_0x248d98['include']=[{'all':!![]}];}_0x248d98=_[_0x0a03('0x43')]({},_0x248d98,_0x42d490[_0x0a03('0x44')]);return db[_0x0a03('0x47')][_0x0a03('0x4d')](_0x248d98)[_0x0a03('0x29')](handleEntityNotFound(_0x5a43e7,null))[_0x0a03('0x29')](respondWithResult(_0x5a43e7,null))['catch'](handleError(_0x5a43e7,null));};exports[_0x0a03('0x4e')]=function(_0x135af0,_0x2fea62){return db[_0x0a03('0x47')][_0x0a03('0x4e')](_0x135af0['body'],{})['then'](respondWithResult(_0x2fea62,0xc9))[_0x0a03('0x4a')](handleError(_0x2fea62,null));};exports['update']=function(_0x4ad184,_0x4b591b){if(_0x4ad184['body']['id']){delete _0x4ad184[_0x0a03('0x4f')]['id'];}return db[_0x0a03('0x47')]['find']({'where':{'id':_0x4ad184[_0x0a03('0x4c')]['id']}})[_0x0a03('0x29')](handleEntityNotFound(_0x4b591b,null))[_0x0a03('0x29')](saveUpdates(_0x4ad184[_0x0a03('0x4f')],null))[_0x0a03('0x29')](respondWithResult(_0x4b591b,null))[_0x0a03('0x4a')](handleError(_0x4b591b,null));};exports[_0x0a03('0x28')]=function(_0x568528,_0x51115c){return db[_0x0a03('0x47')]['find']({'where':{'id':_0x568528[_0x0a03('0x4c')]['id']}})[_0x0a03('0x29')](handleEntityNotFound(_0x51115c,null))[_0x0a03('0x29')](removeEntity(_0x51115c,null))[_0x0a03('0x4a')](handleError(_0x51115c,null));};exports[_0x0a03('0x50')]=function(_0x4d4701,_0x30751d){return db[_0x0a03('0x47')][_0x0a03('0x50')]()[_0x0a03('0x29')](respondWithResult(_0x30751d,null))[_0x0a03('0x4a')](handleError(_0x30751d,null));};