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 _0x3a37=['rows','show','rawAttributes','keys','includeAll','create','body','catch','update','params','find','describe','html-pdf','eml-format','zip-dir','fast-json-patch','request-promise','mustache','util','path','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','status','count','offset','set','Content-Range','json','apply','reject','then','end','sendStatus','error','stack','name','send','index','map','MemberReport','fieldName','type','key','query','filters','intersection','attributes','model','fields','length','hasOwnProperty','nolimit','limit','order','sort','where','pick','filter','VIRTUAL','merge','options','include','findAll'];(function(_0x46d786,_0xfaa203){var _0x3b5cdd=function(_0xd636ff){while(--_0xd636ff){_0x46d786['push'](_0x46d786['shift']());}};_0x3b5cdd(++_0xfaa203);}(_0x3a37,0xa8));var _0x73a3=function(_0x1fa19c,_0x5c740b){_0x1fa19c=_0x1fa19c-0x0;var _0x5b332d=_0x3a37[_0x1fa19c];return _0x5b332d;};'use strict';var pdf=require(_0x73a3('0x0'));var emlformat=require(_0x73a3('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x73a3('0x2'));var jsonpatch=require(_0x73a3('0x3'));var rp=require(_0x73a3('0x4'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x73a3('0x5'));var util=require(_0x73a3('0x6'));var path=require(_0x73a3('0x7'));var sox=require('sox');var csv=require(_0x73a3('0x8'));var ejs=require(_0x73a3('0x9'));var fs=require('fs');var _=require(_0x73a3('0xa'));var squel=require(_0x73a3('0xb'));var crypto=require(_0x73a3('0xc'));var jsforce=require(_0x73a3('0xd'));var deskjs=require(_0x73a3('0xe'));var toCsv=require('to-csv');var querystring=require(_0x73a3('0xf'));var Papa=require(_0x73a3('0x10'));var Redis=require(_0x73a3('0x11'));var authService=require(_0x73a3('0x12'));var qs=require(_0x73a3('0x13'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x73a3('0x14'));var logger=require('../../config/logger')(_0x73a3('0x15'));var utils=require(_0x73a3('0x16'));var config=require(_0x73a3('0x17'));var licenseUtil=require(_0x73a3('0x18'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x369428,_0x2481f3){_0x2481f3=_0x2481f3||0xcc;return function(_0x2e7d85){if(_0x2e7d85){return _0x369428['sendStatus'](_0x2481f3);}return _0x369428[_0x73a3('0x19')](_0x2481f3)['end']();};}function respondWithResult(_0x2d4b79,_0xff41f9){_0xff41f9=_0xff41f9||0xc8;return function(_0x13e165){if(_0x13e165){return _0x2d4b79[_0x73a3('0x19')](_0xff41f9)['json'](_0x13e165);}};}function respondWithFilteredResult(_0x50283c,_0xdbb75f){return function(_0x3c32a0){if(_0x3c32a0){var _0x466195=_0x3c32a0[_0x73a3('0x1a')],_0x1e62ce=_0xdbb75f[_0x73a3('0x1b')],_0x1524bf=_0xdbb75f[_0x73a3('0x1b')]+_0xdbb75f['limit'],_0x36e5f5;if(_0x1524bf>=_0x466195){_0x1524bf=_0x466195;_0x36e5f5=0xc8;}else{_0x36e5f5=0xce;}_0x50283c[_0x73a3('0x19')](_0x36e5f5);return _0x50283c[_0x73a3('0x1c')](_0x73a3('0x1d'),_0x1e62ce+'-'+_0x1524bf+'/'+_0x466195)[_0x73a3('0x1e')](_0x3c32a0);}return null;};}function patchUpdates(_0x9db92b){return function(_0x40afe5){try{jsonpatch[_0x73a3('0x1f')](_0x40afe5,_0x9db92b,!![]);}catch(_0x19a51d){return BPromise[_0x73a3('0x20')](_0x19a51d);}return _0x40afe5['save']();};}function saveUpdates(_0x17a106,_0x368603){return function(_0x3fc73f){if(_0x3fc73f){return _0x3fc73f['update'](_0x17a106)['then'](function(_0x28e715){return _0x28e715;});}return null;};}function removeEntity(_0x3bcbd5,_0x1ec81e){return function(_0x55d66b){if(_0x55d66b){return _0x55d66b['destroy']()[_0x73a3('0x21')](function(){_0x3bcbd5['status'](0xcc)[_0x73a3('0x22')]();});}};}function handleEntityNotFound(_0x4d3cd0,_0x30c35e){return function(_0x236f46){if(!_0x236f46){_0x4d3cd0[_0x73a3('0x23')](0x194);}return _0x236f46;};}function handleError(_0x21a137,_0x640ac8){_0x640ac8=_0x640ac8||0x1f4;return function(_0x5b01b8){logger[_0x73a3('0x24')](_0x5b01b8[_0x73a3('0x25')]);if(_0x5b01b8[_0x73a3('0x26')]){delete _0x5b01b8[_0x73a3('0x26')];}_0x21a137[_0x73a3('0x19')](_0x640ac8)[_0x73a3('0x27')](_0x5b01b8);};}exports[_0x73a3('0x28')]=function(_0x22a135,_0x27e4e9){var _0x37c068={},_0x121893={},_0x519c82={'count':0x0,'rows':[]};var _0x53d9a2=_[_0x73a3('0x29')](db[_0x73a3('0x2a')]['rawAttributes'],function(_0x365966){return{'name':_0x365966[_0x73a3('0x2b')],'type':_0x365966[_0x73a3('0x2c')][_0x73a3('0x2d')]};});_0x121893['model']=_[_0x73a3('0x29')](_0x53d9a2,_0x73a3('0x26'));_0x121893[_0x73a3('0x2e')]=_['keys'](_0x22a135[_0x73a3('0x2e')]);_0x121893[_0x73a3('0x2f')]=_[_0x73a3('0x30')](_0x121893['model'],_0x121893['query']);_0x37c068[_0x73a3('0x31')]=_[_0x73a3('0x30')](_0x121893[_0x73a3('0x32')],qs[_0x73a3('0x33')](_0x22a135[_0x73a3('0x2e')][_0x73a3('0x33')]));_0x37c068[_0x73a3('0x31')]=_0x37c068[_0x73a3('0x31')][_0x73a3('0x34')]?_0x37c068[_0x73a3('0x31')]:_0x121893[_0x73a3('0x32')];if(!_0x22a135[_0x73a3('0x2e')][_0x73a3('0x35')](_0x73a3('0x36'))){_0x37c068['limit']=qs[_0x73a3('0x37')](_0x22a135[_0x73a3('0x2e')][_0x73a3('0x37')]);_0x37c068['offset']=qs[_0x73a3('0x1b')](_0x22a135['query'][_0x73a3('0x1b')]);}_0x37c068[_0x73a3('0x38')]=qs[_0x73a3('0x39')](_0x22a135['query']['sort']);_0x37c068[_0x73a3('0x3a')]=qs[_0x73a3('0x2f')](_[_0x73a3('0x3b')](_0x22a135[_0x73a3('0x2e')],_0x121893[_0x73a3('0x2f')]),_0x53d9a2);if(_0x22a135['query'][_0x73a3('0x3c')]){_0x37c068[_0x73a3('0x3a')]=_['merge'](_0x37c068[_0x73a3('0x3a')],{'$or':_[_0x73a3('0x29')](_0x53d9a2,function(_0x59f458){if(_0x59f458[_0x73a3('0x2c')]!==_0x73a3('0x3d')){var _0x56ffc0={};_0x56ffc0[_0x59f458[_0x73a3('0x26')]]={'$like':'%'+_0x22a135[_0x73a3('0x2e')][_0x73a3('0x3c')]+'%'};return _0x56ffc0;}})});}_0x37c068=_[_0x73a3('0x3e')]({},_0x37c068,_0x22a135[_0x73a3('0x3f')]);var _0xd5e10={'where':_0x37c068[_0x73a3('0x3a')]};return db[_0x73a3('0x2a')][_0x73a3('0x1a')](_0xd5e10)[_0x73a3('0x21')](function(_0x4473cd){_0x519c82[_0x73a3('0x1a')]=_0x4473cd;if(_0x22a135[_0x73a3('0x2e')]['includeAll']){_0x37c068[_0x73a3('0x40')]=[{'all':!![]}];}return db['MemberReport'][_0x73a3('0x41')](_0x37c068);})['then'](function(_0x259887){_0x519c82[_0x73a3('0x42')]=_0x259887;return _0x519c82;})[_0x73a3('0x21')](respondWithFilteredResult(_0x27e4e9,_0x37c068))['catch'](handleError(_0x27e4e9,null));};exports[_0x73a3('0x43')]=function(_0xfed712,_0x5d1a9e){var _0x46e789={'raw':!![],'where':{'id':_0xfed712['params']['id']}},_0x4ffebb={};_0x4ffebb[_0x73a3('0x32')]=_['keys'](db[_0x73a3('0x2a')][_0x73a3('0x44')]);_0x4ffebb[_0x73a3('0x2e')]=_[_0x73a3('0x45')](_0xfed712[_0x73a3('0x2e')]);_0x4ffebb[_0x73a3('0x2f')]=_[_0x73a3('0x30')](_0x4ffebb['model'],_0x4ffebb[_0x73a3('0x2e')]);_0x46e789['attributes']=_[_0x73a3('0x30')](_0x4ffebb['model'],qs[_0x73a3('0x33')](_0xfed712[_0x73a3('0x2e')][_0x73a3('0x33')]));_0x46e789[_0x73a3('0x31')]=_0x46e789['attributes'][_0x73a3('0x34')]?_0x46e789['attributes']:_0x4ffebb['model'];if(_0xfed712[_0x73a3('0x2e')][_0x73a3('0x46')]){_0x46e789[_0x73a3('0x40')]=[{'all':!![]}];}_0x46e789=_[_0x73a3('0x3e')]({},_0x46e789,_0xfed712['options']);return db['MemberReport']['find'](_0x46e789)[_0x73a3('0x21')](handleEntityNotFound(_0x5d1a9e,null))[_0x73a3('0x21')](respondWithResult(_0x5d1a9e,null))['catch'](handleError(_0x5d1a9e,null));};exports[_0x73a3('0x47')]=function(_0x4f1c35,_0x56980d){return db[_0x73a3('0x2a')]['create'](_0x4f1c35[_0x73a3('0x48')],{})[_0x73a3('0x21')](respondWithResult(_0x56980d,0xc9))[_0x73a3('0x49')](handleError(_0x56980d,null));};exports[_0x73a3('0x4a')]=function(_0x1df710,_0x1e8b0e){if(_0x1df710[_0x73a3('0x48')]['id']){delete _0x1df710[_0x73a3('0x48')]['id'];}return db[_0x73a3('0x2a')]['find']({'where':{'id':_0x1df710[_0x73a3('0x4b')]['id']}})['then'](handleEntityNotFound(_0x1e8b0e,null))[_0x73a3('0x21')](saveUpdates(_0x1df710['body'],null))[_0x73a3('0x21')](respondWithResult(_0x1e8b0e,null))['catch'](handleError(_0x1e8b0e,null));};exports['destroy']=function(_0x2e1a24,_0x2b4d5e){return db[_0x73a3('0x2a')][_0x73a3('0x4c')]({'where':{'id':_0x2e1a24['params']['id']}})[_0x73a3('0x21')](handleEntityNotFound(_0x2b4d5e,null))['then'](removeEntity(_0x2b4d5e,null))['catch'](handleError(_0x2b4d5e,null));};exports[_0x73a3('0x4d')]=function(_0x5dc715,_0x162268){return db['MemberReport'][_0x73a3('0x4d')]()[_0x73a3('0x21')](respondWithResult(_0x162268,null))[_0x73a3('0x49')](handleError(_0x162268,null));};