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 _0x5d46=['error','stack','name','send','index','map','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','nolimit','sort','where','pick','filter','VIRTUAL','merge','include','MemberReport','findAll','catch','show','params','options','find','create','body','describe','html-pdf','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','to-csv','ejs','lodash','squel','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','count','offset','limit','reject','save','update','then','destroy'];(function(_0x30c165,_0x1f8008){var _0x4a9550=function(_0x1e0ac6){while(--_0x1e0ac6){_0x30c165['push'](_0x30c165['shift']());}};_0x4a9550(++_0x1f8008);}(_0x5d46,0x148));var _0x65d4=function(_0x5f437d,_0x367ee7){_0x5f437d=_0x5f437d-0x0;var _0x40240a=_0x5d46[_0x5f437d];return _0x40240a;};'use strict';var pdf=require(_0x65d4('0x0'));var emlformat=require('eml-format');var rimraf=require(_0x65d4('0x1'));var zipdir=require(_0x65d4('0x2'));var jsonpatch=require(_0x65d4('0x3'));var rp=require(_0x65d4('0x4'));var moment=require('moment');var BPromise=require(_0x65d4('0x5'));var Mustache=require(_0x65d4('0x6'));var util=require(_0x65d4('0x7'));var path=require('path');var sox=require('sox');var csv=require(_0x65d4('0x8'));var ejs=require(_0x65d4('0x9'));var fs=require('fs');var _=require(_0x65d4('0xa'));var squel=require(_0x65d4('0xb'));var crypto=require('crypto');var jsforce=require(_0x65d4('0xc'));var deskjs=require('desk.js');var toCsv=require(_0x65d4('0x8'));var querystring=require(_0x65d4('0xd'));var Papa=require(_0x65d4('0xe'));var Redis=require(_0x65d4('0xf'));var authService=require(_0x65d4('0x10'));var qs=require(_0x65d4('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x65d4('0x12'));var logger=require(_0x65d4('0x13'))(_0x65d4('0x14'));var utils=require(_0x65d4('0x15'));var config=require(_0x65d4('0x16'));var licenseUtil=require(_0x65d4('0x17'));var db=require(_0x65d4('0x18'))['db'];function respondWithStatusCode(_0x195669,_0xdecad2){_0xdecad2=_0xdecad2||0xcc;return function(_0x12f7f6){if(_0x12f7f6){return _0x195669[_0x65d4('0x19')](_0xdecad2);}return _0x195669[_0x65d4('0x1a')](_0xdecad2)[_0x65d4('0x1b')]();};}function respondWithResult(_0x469029,_0x436d75){_0x436d75=_0x436d75||0xc8;return function(_0x36d33a){if(_0x36d33a){return _0x469029[_0x65d4('0x1a')](_0x436d75)[_0x65d4('0x1c')](_0x36d33a);}};}function respondWithFilteredResult(_0x3f92e3,_0x367b05){return function(_0x406ce2){if(_0x406ce2){var _0x325047=_0x406ce2[_0x65d4('0x1d')],_0x1f8fed=_0x367b05[_0x65d4('0x1e')],_0x276a72=_0x367b05[_0x65d4('0x1e')]+_0x367b05[_0x65d4('0x1f')],_0x2264bf;if(_0x276a72>=_0x325047){_0x276a72=_0x325047;_0x2264bf=0xc8;}else{_0x2264bf=0xce;}_0x3f92e3[_0x65d4('0x1a')](_0x2264bf);return _0x3f92e3['set']('Content-Range',_0x1f8fed+'-'+_0x276a72+'/'+_0x325047)['json'](_0x406ce2);}return null;};}function patchUpdates(_0x14d158){return function(_0x55d138){try{jsonpatch['apply'](_0x55d138,_0x14d158,!![]);}catch(_0xef1e68){return BPromise[_0x65d4('0x20')](_0xef1e68);}return _0x55d138[_0x65d4('0x21')]();};}function saveUpdates(_0x2b478b,_0x44778c){return function(_0x2368be){if(_0x2368be){return _0x2368be[_0x65d4('0x22')](_0x2b478b)[_0x65d4('0x23')](function(_0x4d3066){return _0x4d3066;});}return null;};}function removeEntity(_0x330dde,_0x5e1db5){return function(_0x5dcef1){if(_0x5dcef1){return _0x5dcef1[_0x65d4('0x24')]()[_0x65d4('0x23')](function(){_0x330dde[_0x65d4('0x1a')](0xcc)[_0x65d4('0x1b')]();});}};}function handleEntityNotFound(_0x34b683,_0x323baa){return function(_0x22e0d9){if(!_0x22e0d9){_0x34b683[_0x65d4('0x19')](0x194);}return _0x22e0d9;};}function handleError(_0x5ca7c6,_0x1fd254){_0x1fd254=_0x1fd254||0x1f4;return function(_0x46998a){logger[_0x65d4('0x25')](_0x46998a[_0x65d4('0x26')]);if(_0x46998a[_0x65d4('0x27')]){delete _0x46998a[_0x65d4('0x27')];}_0x5ca7c6[_0x65d4('0x1a')](_0x1fd254)[_0x65d4('0x28')](_0x46998a);};}exports[_0x65d4('0x29')]=function(_0x18bed4,_0x24641a){var _0x308bcf={},_0x430e47={},_0x1d4760={'count':0x0,'rows':[]};var _0x1f917d=_[_0x65d4('0x2a')](db['MemberReport'][_0x65d4('0x2b')],function(_0x1d66a2){return{'name':_0x1d66a2[_0x65d4('0x2c')],'type':_0x1d66a2[_0x65d4('0x2d')][_0x65d4('0x2e')]};});_0x430e47[_0x65d4('0x2f')]=_[_0x65d4('0x2a')](_0x1f917d,_0x65d4('0x27'));_0x430e47[_0x65d4('0x30')]=_[_0x65d4('0x31')](_0x18bed4[_0x65d4('0x30')]);_0x430e47[_0x65d4('0x32')]=_[_0x65d4('0x33')](_0x430e47[_0x65d4('0x2f')],_0x430e47[_0x65d4('0x30')]);_0x308bcf[_0x65d4('0x34')]=_['intersection'](_0x430e47[_0x65d4('0x2f')],qs[_0x65d4('0x35')](_0x18bed4['query'][_0x65d4('0x35')]));_0x308bcf[_0x65d4('0x34')]=_0x308bcf[_0x65d4('0x34')][_0x65d4('0x36')]?_0x308bcf[_0x65d4('0x34')]:_0x430e47[_0x65d4('0x2f')];if(!_0x18bed4['query']['hasOwnProperty'](_0x65d4('0x37'))){_0x308bcf[_0x65d4('0x1f')]=qs['limit'](_0x18bed4['query'][_0x65d4('0x1f')]);_0x308bcf['offset']=qs[_0x65d4('0x1e')](_0x18bed4[_0x65d4('0x30')][_0x65d4('0x1e')]);}_0x308bcf['order']=qs['sort'](_0x18bed4[_0x65d4('0x30')][_0x65d4('0x38')]);_0x308bcf[_0x65d4('0x39')]=qs[_0x65d4('0x32')](_[_0x65d4('0x3a')](_0x18bed4[_0x65d4('0x30')],_0x430e47['filters']),_0x1f917d);if(_0x18bed4[_0x65d4('0x30')][_0x65d4('0x3b')]){_0x308bcf['where']=_['merge'](_0x308bcf['where'],{'$or':_[_0x65d4('0x2a')](_0x1f917d,function(_0x496409){if(_0x496409[_0x65d4('0x2d')]!==_0x65d4('0x3c')){var _0x10a124={};_0x10a124[_0x496409[_0x65d4('0x27')]]={'$like':'%'+_0x18bed4[_0x65d4('0x30')]['filter']+'%'};return _0x10a124;}})});}_0x308bcf=_[_0x65d4('0x3d')]({},_0x308bcf,_0x18bed4['options']);var _0x21dc34={'where':_0x308bcf['where']};return db['MemberReport'][_0x65d4('0x1d')](_0x21dc34)['then'](function(_0x304aaf){_0x1d4760[_0x65d4('0x1d')]=_0x304aaf;if(_0x18bed4[_0x65d4('0x30')]['includeAll']){_0x308bcf[_0x65d4('0x3e')]=[{'all':!![]}];}return db[_0x65d4('0x3f')][_0x65d4('0x40')](_0x308bcf);})['then'](function(_0xb57001){_0x1d4760['rows']=_0xb57001;return _0x1d4760;})[_0x65d4('0x23')](respondWithFilteredResult(_0x24641a,_0x308bcf))[_0x65d4('0x41')](handleError(_0x24641a,null));};exports[_0x65d4('0x42')]=function(_0x11b66f,_0x322c83){var _0x5dd796={'raw':!![],'where':{'id':_0x11b66f[_0x65d4('0x43')]['id']}},_0x318b79={};_0x318b79[_0x65d4('0x2f')]=_['keys'](db[_0x65d4('0x3f')]['rawAttributes']);_0x318b79[_0x65d4('0x30')]=_[_0x65d4('0x31')](_0x11b66f[_0x65d4('0x30')]);_0x318b79[_0x65d4('0x32')]=_['intersection'](_0x318b79['model'],_0x318b79[_0x65d4('0x30')]);_0x5dd796[_0x65d4('0x34')]=_['intersection'](_0x318b79[_0x65d4('0x2f')],qs[_0x65d4('0x35')](_0x11b66f[_0x65d4('0x30')][_0x65d4('0x35')]));_0x5dd796[_0x65d4('0x34')]=_0x5dd796[_0x65d4('0x34')]['length']?_0x5dd796[_0x65d4('0x34')]:_0x318b79[_0x65d4('0x2f')];if(_0x11b66f['query']['includeAll']){_0x5dd796['include']=[{'all':!![]}];}_0x5dd796=_[_0x65d4('0x3d')]({},_0x5dd796,_0x11b66f[_0x65d4('0x44')]);return db[_0x65d4('0x3f')][_0x65d4('0x45')](_0x5dd796)[_0x65d4('0x23')](handleEntityNotFound(_0x322c83,null))[_0x65d4('0x23')](respondWithResult(_0x322c83,null))[_0x65d4('0x41')](handleError(_0x322c83,null));};exports[_0x65d4('0x46')]=function(_0xfa4708,_0x41622c){return db['MemberReport'][_0x65d4('0x46')](_0xfa4708[_0x65d4('0x47')],{})[_0x65d4('0x23')](respondWithResult(_0x41622c,0xc9))['catch'](handleError(_0x41622c,null));};exports[_0x65d4('0x22')]=function(_0x1f7381,_0x925e2f){if(_0x1f7381[_0x65d4('0x47')]['id']){delete _0x1f7381['body']['id'];}return db[_0x65d4('0x3f')][_0x65d4('0x45')]({'where':{'id':_0x1f7381['params']['id']}})[_0x65d4('0x23')](handleEntityNotFound(_0x925e2f,null))[_0x65d4('0x23')](saveUpdates(_0x1f7381['body'],null))[_0x65d4('0x23')](respondWithResult(_0x925e2f,null))[_0x65d4('0x41')](handleError(_0x925e2f,null));};exports[_0x65d4('0x24')]=function(_0x47ff4f,_0x2e069f){return db[_0x65d4('0x3f')][_0x65d4('0x45')]({'where':{'id':_0x47ff4f[_0x65d4('0x43')]['id']}})[_0x65d4('0x23')](handleEntityNotFound(_0x2e069f,null))[_0x65d4('0x23')](removeEntity(_0x2e069f,null))[_0x65d4('0x41')](handleError(_0x2e069f,null));};exports[_0x65d4('0x48')]=function(_0x4cbb8b,_0x1bacf5){return db[_0x65d4('0x3f')][_0x65d4('0x48')]()[_0x65d4('0x23')](respondWithResult(_0x1bacf5,null))[_0x65d4('0x41')](handleError(_0x1bacf5,null));};