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 _0x53b6=['sox','to-csv','ejs','lodash','crypto','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','status','end','json','count','offset','set','apply','save','destroy','then','sendStatus','error','stack','name','send','index','map','rawAttributes','fieldName','type','key','query','keys','intersection','attributes','model','fields','length','hasOwnProperty','limit','order','sort','where','filters','pick','filter','merge','VIRTUAL','options','includeAll','include','MemberReport','findAll','rows','catch','show','params','create','body','update','find','describe','html-pdf','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util'];(function(_0x221e6d,_0x513ef7){var _0x1505c0=function(_0x4e042d){while(--_0x4e042d){_0x221e6d['push'](_0x221e6d['shift']());}};_0x1505c0(++_0x513ef7);}(_0x53b6,0x93));var _0x653b=function(_0x618414,_0x1a7a60){_0x618414=_0x618414-0x0;var _0x21c19a=_0x53b6[_0x618414];return _0x21c19a;};'use strict';var pdf=require(_0x653b('0x0'));var emlformat=require(_0x653b('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x653b('0x2'));var jsonpatch=require(_0x653b('0x3'));var rp=require(_0x653b('0x4'));var moment=require(_0x653b('0x5'));var BPromise=require(_0x653b('0x6'));var Mustache=require(_0x653b('0x7'));var util=require(_0x653b('0x8'));var path=require('path');var sox=require(_0x653b('0x9'));var csv=require(_0x653b('0xa'));var ejs=require(_0x653b('0xb'));var fs=require('fs');var _=require(_0x653b('0xc'));var squel=require('squel');var crypto=require(_0x653b('0xd'));var jsforce=require('jsforce');var deskjs=require(_0x653b('0xe'));var toCsv=require(_0x653b('0xa'));var querystring=require(_0x653b('0xf'));var Papa=require(_0x653b('0x10'));var Redis=require(_0x653b('0x11'));var authService=require(_0x653b('0x12'));var qs=require(_0x653b('0x13'));var as=require(_0x653b('0x14'));var hardwareService=require(_0x653b('0x15'));var logger=require(_0x653b('0x16'))(_0x653b('0x17'));var utils=require(_0x653b('0x18'));var config=require(_0x653b('0x19'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x4b1be8,_0x547759){_0x547759=_0x547759||0xcc;return function(_0x49c7a6){if(_0x49c7a6){return _0x4b1be8['sendStatus'](_0x547759);}return _0x4b1be8[_0x653b('0x1a')](_0x547759)[_0x653b('0x1b')]();};}function respondWithResult(_0x17e0ca,_0x482c88){_0x482c88=_0x482c88||0xc8;return function(_0x18c5db){if(_0x18c5db){return _0x17e0ca[_0x653b('0x1a')](_0x482c88)[_0x653b('0x1c')](_0x18c5db);}};}function respondWithFilteredResult(_0x3b74e5,_0x493111){return function(_0x1a27f5){if(_0x1a27f5){var _0x43d2bd=_0x1a27f5[_0x653b('0x1d')],_0x43b7e4=_0x493111[_0x653b('0x1e')],_0x3d5e7c=_0x493111['offset']+_0x493111['limit'],_0x507ee3;if(_0x3d5e7c>=_0x43d2bd){_0x3d5e7c=_0x43d2bd;_0x507ee3=0xc8;}else{_0x507ee3=0xce;}_0x3b74e5[_0x653b('0x1a')](_0x507ee3);return _0x3b74e5[_0x653b('0x1f')]('Content-Range',_0x43b7e4+'-'+_0x3d5e7c+'/'+_0x43d2bd)[_0x653b('0x1c')](_0x1a27f5);}return null;};}function patchUpdates(_0x451922){return function(_0x2f054a){try{jsonpatch[_0x653b('0x20')](_0x2f054a,_0x451922,!![]);}catch(_0xc16edc){return BPromise['reject'](_0xc16edc);}return _0x2f054a[_0x653b('0x21')]();};}function saveUpdates(_0x57e385,_0xa3b3c0){return function(_0xe89165){if(_0xe89165){return _0xe89165['update'](_0x57e385)['then'](function(_0xe0c207){return _0xe0c207;});}return null;};}function removeEntity(_0x24e051,_0x552a0a){return function(_0x243b6c){if(_0x243b6c){return _0x243b6c[_0x653b('0x22')]()[_0x653b('0x23')](function(){_0x24e051[_0x653b('0x1a')](0xcc)[_0x653b('0x1b')]();});}};}function handleEntityNotFound(_0x513f25,_0xd3ae83){return function(_0x4a2f96){if(!_0x4a2f96){_0x513f25[_0x653b('0x24')](0x194);}return _0x4a2f96;};}function handleError(_0x15528d,_0x1bbf02){_0x1bbf02=_0x1bbf02||0x1f4;return function(_0x609272){logger[_0x653b('0x25')](_0x609272[_0x653b('0x26')]);if(_0x609272[_0x653b('0x27')]){delete _0x609272['name'];}_0x15528d[_0x653b('0x1a')](_0x1bbf02)[_0x653b('0x28')](_0x609272);};}exports[_0x653b('0x29')]=function(_0x38d066,_0x4fe84c){var _0x385ce7={},_0x3d3d06={},_0x12373c={'count':0x0,'rows':[]};var _0x445556=_[_0x653b('0x2a')](db['MemberReport'][_0x653b('0x2b')],function(_0x11b7f5){return{'name':_0x11b7f5[_0x653b('0x2c')],'type':_0x11b7f5[_0x653b('0x2d')][_0x653b('0x2e')]};});_0x3d3d06['model']=_[_0x653b('0x2a')](_0x445556,_0x653b('0x27'));_0x3d3d06[_0x653b('0x2f')]=_[_0x653b('0x30')](_0x38d066[_0x653b('0x2f')]);_0x3d3d06['filters']=_[_0x653b('0x31')](_0x3d3d06['model'],_0x3d3d06[_0x653b('0x2f')]);_0x385ce7[_0x653b('0x32')]=_[_0x653b('0x31')](_0x3d3d06[_0x653b('0x33')],qs[_0x653b('0x34')](_0x38d066[_0x653b('0x2f')][_0x653b('0x34')]));_0x385ce7['attributes']=_0x385ce7['attributes'][_0x653b('0x35')]?_0x385ce7[_0x653b('0x32')]:_0x3d3d06[_0x653b('0x33')];if(!_0x38d066[_0x653b('0x2f')][_0x653b('0x36')]('nolimit')){_0x385ce7['limit']=qs[_0x653b('0x37')](_0x38d066['query']['limit']);_0x385ce7['offset']=qs[_0x653b('0x1e')](_0x38d066[_0x653b('0x2f')]['offset']);}_0x385ce7[_0x653b('0x38')]=qs[_0x653b('0x39')](_0x38d066[_0x653b('0x2f')][_0x653b('0x39')]);_0x385ce7[_0x653b('0x3a')]=qs[_0x653b('0x3b')](_[_0x653b('0x3c')](_0x38d066[_0x653b('0x2f')],_0x3d3d06['filters']));if(_0x38d066[_0x653b('0x2f')][_0x653b('0x3d')]){_0x385ce7[_0x653b('0x3a')]=_[_0x653b('0x3e')](_0x385ce7['where'],{'$or':_[_0x653b('0x2a')](_0x445556,function(_0x2fcb89){if(_0x2fcb89[_0x653b('0x2d')]!==_0x653b('0x3f')){var _0x1956ab={};_0x1956ab[_0x2fcb89[_0x653b('0x27')]]={'$like':'%'+_0x38d066[_0x653b('0x2f')][_0x653b('0x3d')]+'%'};return _0x1956ab;}})});}_0x385ce7=_[_0x653b('0x3e')]({},_0x385ce7,_0x38d066[_0x653b('0x40')]);var _0x1a197a={'where':_0x385ce7[_0x653b('0x3a')]};return db['MemberReport'][_0x653b('0x1d')](_0x1a197a)[_0x653b('0x23')](function(_0x50c5a6){_0x12373c[_0x653b('0x1d')]=_0x50c5a6;if(_0x38d066[_0x653b('0x2f')][_0x653b('0x41')]){_0x385ce7[_0x653b('0x42')]=[{'all':!![]}];}return db[_0x653b('0x43')][_0x653b('0x44')](_0x385ce7);})[_0x653b('0x23')](function(_0x409456){_0x12373c[_0x653b('0x45')]=_0x409456;return _0x12373c;})['then'](respondWithFilteredResult(_0x4fe84c,_0x385ce7))[_0x653b('0x46')](handleError(_0x4fe84c,null));};exports[_0x653b('0x47')]=function(_0x59c4e0,_0x5c8429){var _0x4d7a77={'raw':!![],'where':{'id':_0x59c4e0[_0x653b('0x48')]['id']}},_0x1458f4={};_0x1458f4['model']=_[_0x653b('0x30')](db[_0x653b('0x43')]['rawAttributes']);_0x1458f4['query']=_['keys'](_0x59c4e0[_0x653b('0x2f')]);_0x1458f4[_0x653b('0x3b')]=_[_0x653b('0x31')](_0x1458f4[_0x653b('0x33')],_0x1458f4[_0x653b('0x2f')]);_0x4d7a77[_0x653b('0x32')]=_[_0x653b('0x31')](_0x1458f4['model'],qs['fields'](_0x59c4e0['query'][_0x653b('0x34')]));_0x4d7a77['attributes']=_0x4d7a77[_0x653b('0x32')][_0x653b('0x35')]?_0x4d7a77[_0x653b('0x32')]:_0x1458f4[_0x653b('0x33')];if(_0x59c4e0[_0x653b('0x2f')][_0x653b('0x41')]){_0x4d7a77[_0x653b('0x42')]=[{'all':!![]}];}_0x4d7a77=_[_0x653b('0x3e')]({},_0x4d7a77,_0x59c4e0[_0x653b('0x40')]);return db['MemberReport']['find'](_0x4d7a77)['then'](handleEntityNotFound(_0x5c8429,null))['then'](respondWithResult(_0x5c8429,null))[_0x653b('0x46')](handleError(_0x5c8429,null));};exports[_0x653b('0x49')]=function(_0x3957bd,_0x11cd05){return db['MemberReport'][_0x653b('0x49')](_0x3957bd[_0x653b('0x4a')],{})[_0x653b('0x23')](respondWithResult(_0x11cd05,0xc9))[_0x653b('0x46')](handleError(_0x11cd05,null));};exports[_0x653b('0x4b')]=function(_0x2ee428,_0x927387){if(_0x2ee428['body']['id']){delete _0x2ee428[_0x653b('0x4a')]['id'];}return db[_0x653b('0x43')][_0x653b('0x4c')]({'where':{'id':_0x2ee428[_0x653b('0x48')]['id']}})[_0x653b('0x23')](handleEntityNotFound(_0x927387,null))[_0x653b('0x23')](saveUpdates(_0x2ee428[_0x653b('0x4a')],null))[_0x653b('0x23')](respondWithResult(_0x927387,null))[_0x653b('0x46')](handleError(_0x927387,null));};exports[_0x653b('0x22')]=function(_0x27f725,_0xf65f68){return db[_0x653b('0x43')]['find']({'where':{'id':_0x27f725[_0x653b('0x48')]['id']}})['then'](handleEntityNotFound(_0xf65f68,null))[_0x653b('0x23')](removeEntity(_0xf65f68,null))[_0x653b('0x46')](handleError(_0xf65f68,null));};exports[_0x653b('0x4d')]=function(_0x496c63,_0x112142){return db[_0x653b('0x43')][_0x653b('0x4d')]()[_0x653b('0x23')](respondWithResult(_0x112142,null))[_0x653b('0x46')](handleError(_0x112142,null));};