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 _0x3ef3=['where','pick','filter','VIRTUAL','merge','includeAll','include','MemberReport','rows','params','find','catch','create','body','describe','html-pdf','eml-format','rimraf','zip-dir','moment','bluebird','util','path','sox','ejs','lodash','squel','jsforce','desk.js','to-csv','papaparse','ioredis','../../components/auth/service','../../config/license/hardware','../../config/logger','api','sendStatus','status','json','count','offset','limit','set','Content-Range','reject','update','then','destroy','end','error','stack','name','send','index','map','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','fields','attributes','hasOwnProperty','order','sort'];(function(_0x3d83ac,_0x1d0135){var _0x299760=function(_0x40c1a3){while(--_0x40c1a3){_0x3d83ac['push'](_0x3d83ac['shift']());}};_0x299760(++_0x1d0135);}(_0x3ef3,0x99));var _0x33ef=function(_0x12fbf6,_0x2ab513){_0x12fbf6=_0x12fbf6-0x0;var _0x1bb0d7=_0x3ef3[_0x12fbf6];return _0x1bb0d7;};'use strict';var pdf=require(_0x33ef('0x0'));var emlformat=require(_0x33ef('0x1'));var rimraf=require(_0x33ef('0x2'));var zipdir=require(_0x33ef('0x3'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0x33ef('0x4'));var BPromise=require(_0x33ef('0x5'));var Mustache=require('mustache');var util=require(_0x33ef('0x6'));var path=require(_0x33ef('0x7'));var sox=require(_0x33ef('0x8'));var csv=require('to-csv');var ejs=require(_0x33ef('0x9'));var fs=require('fs');var _=require(_0x33ef('0xa'));var squel=require(_0x33ef('0xb'));var crypto=require('crypto');var jsforce=require(_0x33ef('0xc'));var deskjs=require(_0x33ef('0xd'));var toCsv=require(_0x33ef('0xe'));var querystring=require('querystring');var Papa=require(_0x33ef('0xf'));var Redis=require(_0x33ef('0x10'));var authService=require(_0x33ef('0x11'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x33ef('0x12'));var logger=require(_0x33ef('0x13'))(_0x33ef('0x14'));var utils=require('../../config/utils');var config=require('../../config/environment');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x1b7bf5,_0x9b5d16){_0x9b5d16=_0x9b5d16||0xcc;return function(_0x5b2770){if(_0x5b2770){return _0x1b7bf5[_0x33ef('0x15')](_0x9b5d16);}return _0x1b7bf5[_0x33ef('0x16')](_0x9b5d16)['end']();};}function respondWithResult(_0x5e9291,_0x205df7){_0x205df7=_0x205df7||0xc8;return function(_0x157994){if(_0x157994){return _0x5e9291[_0x33ef('0x16')](_0x205df7)[_0x33ef('0x17')](_0x157994);}};}function respondWithFilteredResult(_0xb20953,_0x10df88){return function(_0x3b0576){if(_0x3b0576){var _0x1cdd9d=_0x3b0576[_0x33ef('0x18')],_0x1c1774=_0x10df88[_0x33ef('0x19')],_0x75e0a1=_0x10df88['offset']+_0x10df88[_0x33ef('0x1a')],_0x28a966;if(_0x75e0a1>=_0x1cdd9d){_0x75e0a1=_0x1cdd9d;_0x28a966=0xc8;}else{_0x28a966=0xce;}_0xb20953[_0x33ef('0x16')](_0x28a966);return _0xb20953[_0x33ef('0x1b')](_0x33ef('0x1c'),_0x1c1774+'-'+_0x75e0a1+'/'+_0x1cdd9d)[_0x33ef('0x17')](_0x3b0576);}return null;};}function patchUpdates(_0x10f2e5){return function(_0x243099){try{jsonpatch['apply'](_0x243099,_0x10f2e5,!![]);}catch(_0x1b2569){return BPromise[_0x33ef('0x1d')](_0x1b2569);}return _0x243099['save']();};}function saveUpdates(_0xfd9575,_0x1969f2){return function(_0x265d8e){if(_0x265d8e){return _0x265d8e[_0x33ef('0x1e')](_0xfd9575)[_0x33ef('0x1f')](function(_0x156c36){return _0x156c36;});}return null;};}function removeEntity(_0x5e4aeb,_0x36aa69){return function(_0x3d440a){if(_0x3d440a){return _0x3d440a[_0x33ef('0x20')]()['then'](function(){_0x5e4aeb[_0x33ef('0x16')](0xcc)[_0x33ef('0x21')]();});}};}function handleEntityNotFound(_0x4b01a0,_0x4fc2a5){return function(_0x5ceb4a){if(!_0x5ceb4a){_0x4b01a0['sendStatus'](0x194);}return _0x5ceb4a;};}function handleError(_0x29cedc,_0x5e7bd2){_0x5e7bd2=_0x5e7bd2||0x1f4;return function(_0x390d87){logger[_0x33ef('0x22')](_0x390d87[_0x33ef('0x23')]);if(_0x390d87[_0x33ef('0x24')]){delete _0x390d87[_0x33ef('0x24')];}_0x29cedc['status'](_0x5e7bd2)[_0x33ef('0x25')](_0x390d87);};}exports[_0x33ef('0x26')]=function(_0x49f76c,_0x1d3714){var _0x130d92={},_0x1460e0={},_0x1ecd6d={'count':0x0,'rows':[]};var _0x4771ab=_[_0x33ef('0x27')](db['MemberReport'][_0x33ef('0x28')],function(_0x28ddc2){return{'name':_0x28ddc2[_0x33ef('0x29')],'type':_0x28ddc2[_0x33ef('0x2a')][_0x33ef('0x2b')]};});_0x1460e0[_0x33ef('0x2c')]=_['map'](_0x4771ab,_0x33ef('0x24'));_0x1460e0[_0x33ef('0x2d')]=_[_0x33ef('0x2e')](_0x49f76c[_0x33ef('0x2d')]);_0x1460e0[_0x33ef('0x2f')]=_['intersection'](_0x1460e0[_0x33ef('0x2c')],_0x1460e0['query']);_0x130d92['attributes']=_[_0x33ef('0x30')](_0x1460e0['model'],qs[_0x33ef('0x31')](_0x49f76c[_0x33ef('0x2d')][_0x33ef('0x31')]));_0x130d92['attributes']=_0x130d92[_0x33ef('0x32')]['length']?_0x130d92[_0x33ef('0x32')]:_0x1460e0[_0x33ef('0x2c')];if(!_0x49f76c[_0x33ef('0x2d')][_0x33ef('0x33')]('nolimit')){_0x130d92[_0x33ef('0x1a')]=qs[_0x33ef('0x1a')](_0x49f76c[_0x33ef('0x2d')][_0x33ef('0x1a')]);_0x130d92[_0x33ef('0x19')]=qs[_0x33ef('0x19')](_0x49f76c[_0x33ef('0x2d')][_0x33ef('0x19')]);}_0x130d92[_0x33ef('0x34')]=qs[_0x33ef('0x35')](_0x49f76c['query']['sort']);_0x130d92[_0x33ef('0x36')]=qs['filters'](_[_0x33ef('0x37')](_0x49f76c[_0x33ef('0x2d')],_0x1460e0['filters']),_0x4771ab);if(_0x49f76c['query'][_0x33ef('0x38')]){_0x130d92[_0x33ef('0x36')]=_['merge'](_0x130d92[_0x33ef('0x36')],{'$or':_[_0x33ef('0x27')](_0x4771ab,function(_0x228897){if(_0x228897['type']!==_0x33ef('0x39')){var _0x376ab1={};_0x376ab1[_0x228897['name']]={'$like':'%'+_0x49f76c[_0x33ef('0x2d')]['filter']+'%'};return _0x376ab1;}})});}_0x130d92=_[_0x33ef('0x3a')]({},_0x130d92,_0x49f76c['options']);var _0x3de77c={'where':_0x130d92[_0x33ef('0x36')]};return db['MemberReport']['count'](_0x3de77c)[_0x33ef('0x1f')](function(_0x549b56){_0x1ecd6d[_0x33ef('0x18')]=_0x549b56;if(_0x49f76c[_0x33ef('0x2d')][_0x33ef('0x3b')]){_0x130d92[_0x33ef('0x3c')]=[{'all':!![]}];}return db[_0x33ef('0x3d')]['findAll'](_0x130d92);})['then'](function(_0x2d1627){_0x1ecd6d[_0x33ef('0x3e')]=_0x2d1627;return _0x1ecd6d;})[_0x33ef('0x1f')](respondWithFilteredResult(_0x1d3714,_0x130d92))['catch'](handleError(_0x1d3714,null));};exports['show']=function(_0x287a71,_0x3acc66){var _0x59627d={'raw':!![],'where':{'id':_0x287a71[_0x33ef('0x3f')]['id']}},_0x1c942b={};_0x1c942b[_0x33ef('0x2c')]=_[_0x33ef('0x2e')](db[_0x33ef('0x3d')][_0x33ef('0x28')]);_0x1c942b[_0x33ef('0x2d')]=_['keys'](_0x287a71[_0x33ef('0x2d')]);_0x1c942b[_0x33ef('0x2f')]=_[_0x33ef('0x30')](_0x1c942b[_0x33ef('0x2c')],_0x1c942b['query']);_0x59627d['attributes']=_[_0x33ef('0x30')](_0x1c942b[_0x33ef('0x2c')],qs['fields'](_0x287a71[_0x33ef('0x2d')][_0x33ef('0x31')]));_0x59627d['attributes']=_0x59627d['attributes']['length']?_0x59627d[_0x33ef('0x32')]:_0x1c942b[_0x33ef('0x2c')];if(_0x287a71[_0x33ef('0x2d')]['includeAll']){_0x59627d[_0x33ef('0x3c')]=[{'all':!![]}];}_0x59627d=_[_0x33ef('0x3a')]({},_0x59627d,_0x287a71['options']);return db[_0x33ef('0x3d')][_0x33ef('0x40')](_0x59627d)['then'](handleEntityNotFound(_0x3acc66,null))[_0x33ef('0x1f')](respondWithResult(_0x3acc66,null))[_0x33ef('0x41')](handleError(_0x3acc66,null));};exports[_0x33ef('0x42')]=function(_0x23855c,_0x1d6d61){return db['MemberReport'][_0x33ef('0x42')](_0x23855c[_0x33ef('0x43')],{})['then'](respondWithResult(_0x1d6d61,0xc9))['catch'](handleError(_0x1d6d61,null));};exports[_0x33ef('0x1e')]=function(_0x564719,_0x12a1ad){if(_0x564719['body']['id']){delete _0x564719['body']['id'];}return db[_0x33ef('0x3d')][_0x33ef('0x40')]({'where':{'id':_0x564719[_0x33ef('0x3f')]['id']}})['then'](handleEntityNotFound(_0x12a1ad,null))['then'](saveUpdates(_0x564719['body'],null))[_0x33ef('0x1f')](respondWithResult(_0x12a1ad,null))[_0x33ef('0x41')](handleError(_0x12a1ad,null));};exports[_0x33ef('0x20')]=function(_0x491185,_0xa85748){return db[_0x33ef('0x3d')][_0x33ef('0x40')]({'where':{'id':_0x491185[_0x33ef('0x3f')]['id']}})['then'](handleEntityNotFound(_0xa85748,null))[_0x33ef('0x1f')](removeEntity(_0xa85748,null))[_0x33ef('0x41')](handleError(_0xa85748,null));};exports[_0x33ef('0x44')]=function(_0xa25397,_0x144220){return db[_0x33ef('0x3d')][_0x33ef('0x44')]()[_0x33ef('0x1f')](respondWithResult(_0x144220,null))[_0x33ef('0x41')](handleError(_0x144220,null));};