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 _0x1e07=['length','hasOwnProperty','nolimit','order','sort','where','pick','filter','map','type','VIRTUAL','merge','includeAll','findAll','catch','show','keys','include','options','find','create','body','params','describe','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','util','sox','ejs','fs-extra','lodash','crypto','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','json','offset','undefined','limit','count','set','Content-Range','apply','save','then','destroy','error','name','send','index','MemberReport','rawAttributes','key','model','query','filters','intersection','attributes','fields'];(function(_0xa802a1,_0x4efb6b){var _0x49c1cb=function(_0x17a049){while(--_0x17a049){_0xa802a1['push'](_0xa802a1['shift']());}};_0x49c1cb(++_0x4efb6b);}(_0x1e07,0x18f));var _0x71e0=function(_0x83c046,_0x8e7fae){_0x83c046=_0x83c046-0x0;var _0x13388f=_0x1e07[_0x83c046];return _0x13388f;};'use strict';var emlformat=require(_0x71e0('0x0'));var rimraf=require(_0x71e0('0x1'));var zipdir=require(_0x71e0('0x2'));var jsonpatch=require(_0x71e0('0x3'));var rp=require(_0x71e0('0x4'));var moment=require('moment');var BPromise=require(_0x71e0('0x5'));var Mustache=require('mustache');var util=require(_0x71e0('0x6'));var path=require('path');var sox=require(_0x71e0('0x7'));var csv=require('to-csv');var ejs=require(_0x71e0('0x8'));var fs=require('fs');var fs_extra=require(_0x71e0('0x9'));var _=require(_0x71e0('0xa'));var squel=require('squel');var crypto=require(_0x71e0('0xb'));var jsforce=require(_0x71e0('0xc'));var deskjs=require(_0x71e0('0xd'));var toCsv=require(_0x71e0('0xe'));var querystring=require(_0x71e0('0xf'));var Papa=require(_0x71e0('0x10'));var Redis=require(_0x71e0('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x71e0('0x12'));var as=require(_0x71e0('0x13'));var hardwareService=require(_0x71e0('0x14'));var logger=require(_0x71e0('0x15'))('api');var utils=require(_0x71e0('0x16'));var config=require(_0x71e0('0x17'));var licenseUtil=require('../../config/license/util');var db=require(_0x71e0('0x18'))['db'];function respondWithStatusCode(_0x4b1871,_0x3c18fa){_0x3c18fa=_0x3c18fa||0xcc;return function(_0x3b7d80){if(_0x3b7d80){return _0x4b1871[_0x71e0('0x19')](_0x3c18fa);}return _0x4b1871[_0x71e0('0x1a')](_0x3c18fa)['end']();};}function respondWithResult(_0x30e80a,_0x3bf2f5){_0x3bf2f5=_0x3bf2f5||0xc8;return function(_0x2b37e2){if(_0x2b37e2){return _0x30e80a['status'](_0x3bf2f5)[_0x71e0('0x1b')](_0x2b37e2);}};}function respondWithFilteredResult(_0xc8a6d8,_0x345f49){return function(_0x3501c7){if(_0x3501c7){var _0x553e5c=typeof _0x345f49[_0x71e0('0x1c')]===_0x71e0('0x1d')&&typeof _0x345f49[_0x71e0('0x1e')]==='undefined';var _0x49badf=_0x3501c7[_0x71e0('0x1f')];var _0x57b599=_0x553e5c?0x0:_0x345f49[_0x71e0('0x1c')];var _0x508c1c=_0x553e5c?_0x3501c7[_0x71e0('0x1f')]:_0x345f49['offset']+_0x345f49[_0x71e0('0x1e')];var _0x11976d;if(_0x508c1c>=_0x49badf){_0x508c1c=_0x49badf;_0x11976d=0xc8;}else{_0x11976d=0xce;}_0xc8a6d8[_0x71e0('0x1a')](_0x11976d);return _0xc8a6d8[_0x71e0('0x20')](_0x71e0('0x21'),_0x57b599+'-'+_0x508c1c+'/'+_0x49badf)['json'](_0x3501c7);}return null;};}function patchUpdates(_0x4e0eaf){return function(_0x4b09fc){try{jsonpatch[_0x71e0('0x22')](_0x4b09fc,_0x4e0eaf,!![]);}catch(_0x301eaa){return BPromise['reject'](_0x301eaa);}return _0x4b09fc[_0x71e0('0x23')]();};}function saveUpdates(_0x32c86f,_0x1a21a2){return function(_0x5383a0){if(_0x5383a0){return _0x5383a0['update'](_0x32c86f)[_0x71e0('0x24')](function(_0x4f1c8a){return _0x4f1c8a;});}return null;};}function removeEntity(_0x485a0f,_0x44597c){return function(_0x44f522){if(_0x44f522){return _0x44f522[_0x71e0('0x25')]()[_0x71e0('0x24')](function(){_0x485a0f[_0x71e0('0x1a')](0xcc)['end']();});}};}function handleEntityNotFound(_0xbb9eb1,_0x183ce3){return function(_0x280604){if(!_0x280604){_0xbb9eb1[_0x71e0('0x19')](0x194);}return _0x280604;};}function handleError(_0x1bc9e7,_0x5b22af){_0x5b22af=_0x5b22af||0x1f4;return function(_0x2ae804){logger[_0x71e0('0x26')](_0x2ae804['stack']);if(_0x2ae804['name']){delete _0x2ae804[_0x71e0('0x27')];}_0x1bc9e7[_0x71e0('0x1a')](_0x5b22af)[_0x71e0('0x28')](_0x2ae804);};}exports[_0x71e0('0x29')]=function(_0x3e7c39,_0x2c3135){var _0x5bc951={},_0x41e2c9={},_0x14a7c0={'count':0x0,'rows':[]};var _0xe186ce=_['map'](db[_0x71e0('0x2a')][_0x71e0('0x2b')],function(_0x1fa999){return{'name':_0x1fa999['fieldName'],'type':_0x1fa999['type'][_0x71e0('0x2c')]};});_0x41e2c9[_0x71e0('0x2d')]=_['map'](_0xe186ce,_0x71e0('0x27'));_0x41e2c9[_0x71e0('0x2e')]=_['keys'](_0x3e7c39['query']);_0x41e2c9[_0x71e0('0x2f')]=_[_0x71e0('0x30')](_0x41e2c9['model'],_0x41e2c9[_0x71e0('0x2e')]);_0x5bc951[_0x71e0('0x31')]=_[_0x71e0('0x30')](_0x41e2c9[_0x71e0('0x2d')],qs['fields'](_0x3e7c39[_0x71e0('0x2e')][_0x71e0('0x32')]));_0x5bc951[_0x71e0('0x31')]=_0x5bc951[_0x71e0('0x31')][_0x71e0('0x33')]?_0x5bc951[_0x71e0('0x31')]:_0x41e2c9['model'];if(!_0x3e7c39['query'][_0x71e0('0x34')](_0x71e0('0x35'))){_0x5bc951[_0x71e0('0x1e')]=qs[_0x71e0('0x1e')](_0x3e7c39[_0x71e0('0x2e')][_0x71e0('0x1e')]);_0x5bc951['offset']=qs[_0x71e0('0x1c')](_0x3e7c39['query'][_0x71e0('0x1c')]);}_0x5bc951[_0x71e0('0x36')]=qs[_0x71e0('0x37')](_0x3e7c39[_0x71e0('0x2e')][_0x71e0('0x37')]);_0x5bc951[_0x71e0('0x38')]=qs[_0x71e0('0x2f')](_[_0x71e0('0x39')](_0x3e7c39[_0x71e0('0x2e')],_0x41e2c9[_0x71e0('0x2f')]),_0xe186ce);if(_0x3e7c39[_0x71e0('0x2e')][_0x71e0('0x3a')]){_0x5bc951['where']=_['merge'](_0x5bc951[_0x71e0('0x38')],{'$or':_[_0x71e0('0x3b')](_0xe186ce,function(_0x19664c){if(_0x19664c[_0x71e0('0x3c')]!==_0x71e0('0x3d')){var _0x377b12={};_0x377b12[_0x19664c[_0x71e0('0x27')]]={'$like':'%'+_0x3e7c39[_0x71e0('0x2e')]['filter']+'%'};return _0x377b12;}})});}_0x5bc951=_[_0x71e0('0x3e')]({},_0x5bc951,_0x3e7c39['options']);var _0x1cc7ff={'where':_0x5bc951['where']};return db[_0x71e0('0x2a')][_0x71e0('0x1f')](_0x1cc7ff)[_0x71e0('0x24')](function(_0x5af310){_0x14a7c0[_0x71e0('0x1f')]=_0x5af310;if(_0x3e7c39[_0x71e0('0x2e')][_0x71e0('0x3f')]){_0x5bc951['include']=[{'all':!![]}];}return db[_0x71e0('0x2a')][_0x71e0('0x40')](_0x5bc951);})[_0x71e0('0x24')](function(_0x50abf7){_0x14a7c0['rows']=_0x50abf7;return _0x14a7c0;})[_0x71e0('0x24')](respondWithFilteredResult(_0x2c3135,_0x5bc951))[_0x71e0('0x41')](handleError(_0x2c3135,null));};exports[_0x71e0('0x42')]=function(_0x58ffdc,_0x2698f0){var _0x363b06={'raw':!![],'where':{'id':_0x58ffdc['params']['id']}},_0x47dd9a={};_0x47dd9a[_0x71e0('0x2d')]=_[_0x71e0('0x43')](db['MemberReport'][_0x71e0('0x2b')]);_0x47dd9a[_0x71e0('0x2e')]=_[_0x71e0('0x43')](_0x58ffdc['query']);_0x47dd9a[_0x71e0('0x2f')]=_[_0x71e0('0x30')](_0x47dd9a[_0x71e0('0x2d')],_0x47dd9a[_0x71e0('0x2e')]);_0x363b06[_0x71e0('0x31')]=_[_0x71e0('0x30')](_0x47dd9a['model'],qs[_0x71e0('0x32')](_0x58ffdc[_0x71e0('0x2e')][_0x71e0('0x32')]));_0x363b06[_0x71e0('0x31')]=_0x363b06[_0x71e0('0x31')]['length']?_0x363b06[_0x71e0('0x31')]:_0x47dd9a['model'];if(_0x58ffdc[_0x71e0('0x2e')][_0x71e0('0x3f')]){_0x363b06[_0x71e0('0x44')]=[{'all':!![]}];}_0x363b06=_[_0x71e0('0x3e')]({},_0x363b06,_0x58ffdc[_0x71e0('0x45')]);return db[_0x71e0('0x2a')][_0x71e0('0x46')](_0x363b06)[_0x71e0('0x24')](handleEntityNotFound(_0x2698f0,null))[_0x71e0('0x24')](respondWithResult(_0x2698f0,null))[_0x71e0('0x41')](handleError(_0x2698f0,null));};exports[_0x71e0('0x47')]=function(_0x29172c,_0x22063b){return db['MemberReport'][_0x71e0('0x47')](_0x29172c[_0x71e0('0x48')],{})[_0x71e0('0x24')](respondWithResult(_0x22063b,0xc9))[_0x71e0('0x41')](handleError(_0x22063b,null));};exports['update']=function(_0x233c9d,_0x3ca35e){if(_0x233c9d['body']['id']){delete _0x233c9d[_0x71e0('0x48')]['id'];}return db['MemberReport'][_0x71e0('0x46')]({'where':{'id':_0x233c9d[_0x71e0('0x49')]['id']}})[_0x71e0('0x24')](handleEntityNotFound(_0x3ca35e,null))['then'](saveUpdates(_0x233c9d[_0x71e0('0x48')],null))['then'](respondWithResult(_0x3ca35e,null))[_0x71e0('0x41')](handleError(_0x3ca35e,null));};exports[_0x71e0('0x25')]=function(_0x2d2841,_0x3004dc){return db[_0x71e0('0x2a')][_0x71e0('0x46')]({'where':{'id':_0x2d2841[_0x71e0('0x49')]['id']}})[_0x71e0('0x24')](handleEntityNotFound(_0x3004dc,null))[_0x71e0('0x24')](removeEntity(_0x3004dc,null))['catch'](handleError(_0x3004dc,null));};exports[_0x71e0('0x4a')]=function(_0x4818f7,_0x47b528){return db['MemberReport'][_0x71e0('0x4a')]()['then'](respondWithResult(_0x47b528,null))[_0x71e0('0x41')](handleError(_0x47b528,null));};