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 _0x4b60=['body','params','describe','eml-format','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','ejs','fs-extra','squel','crypto','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','count','offset','limit','reject','save','update','then','destroy','name','send','index','map','MemberReport','rawAttributes','fieldName','type','key','model','query','keys','filters','attributes','fields','length','nolimit','order','sort','where','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','intersection','find','create'];(function(_0x323ca4,_0x3e4df1){var _0x1fa0d8=function(_0x55a786){while(--_0x55a786){_0x323ca4['push'](_0x323ca4['shift']());}};_0x1fa0d8(++_0x3e4df1);}(_0x4b60,0xe1));var _0x04b6=function(_0x501510,_0x61caa9){_0x501510=_0x501510-0x0;var _0x1e6ee5=_0x4b60[_0x501510];return _0x1e6ee5;};'use strict';var emlformat=require(_0x04b6('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x04b6('0x1'));var jsonpatch=require(_0x04b6('0x2'));var rp=require(_0x04b6('0x3'));var moment=require('moment');var BPromise=require(_0x04b6('0x4'));var Mustache=require(_0x04b6('0x5'));var util=require(_0x04b6('0x6'));var path=require(_0x04b6('0x7'));var sox=require(_0x04b6('0x8'));var csv=require('to-csv');var ejs=require(_0x04b6('0x9'));var fs=require('fs');var fs_extra=require(_0x04b6('0xa'));var _=require('lodash');var squel=require(_0x04b6('0xb'));var crypto=require(_0x04b6('0xc'));var jsforce=require('jsforce');var deskjs=require(_0x04b6('0xd'));var toCsv=require(_0x04b6('0xe'));var querystring=require(_0x04b6('0xf'));var Papa=require(_0x04b6('0x10'));var Redis=require(_0x04b6('0x11'));var authService=require(_0x04b6('0x12'));var qs=require('../../components/parsers/qs');var as=require(_0x04b6('0x13'));var hardwareService=require(_0x04b6('0x14'));var logger=require(_0x04b6('0x15'))(_0x04b6('0x16'));var utils=require(_0x04b6('0x17'));var config=require(_0x04b6('0x18'));var licenseUtil=require(_0x04b6('0x19'));var db=require(_0x04b6('0x1a'))['db'];function respondWithStatusCode(_0x38a2b4,_0x2840e1){_0x2840e1=_0x2840e1||0xcc;return function(_0x334ee7){if(_0x334ee7){return _0x38a2b4[_0x04b6('0x1b')](_0x2840e1);}return _0x38a2b4[_0x04b6('0x1c')](_0x2840e1)[_0x04b6('0x1d')]();};}function respondWithResult(_0x1c8944,_0x48f6d0){_0x48f6d0=_0x48f6d0||0xc8;return function(_0x290f11){if(_0x290f11){return _0x1c8944[_0x04b6('0x1c')](_0x48f6d0)['json'](_0x290f11);}};}function respondWithFilteredResult(_0x3bf5cc,_0x502e47){return function(_0x713add){if(_0x713add){var _0x174f58=typeof _0x502e47['offset']==='undefined'&&typeof _0x502e47['limit']==='undefined';var _0xaefeab=_0x713add[_0x04b6('0x1e')];var _0x2ef97b=_0x174f58?0x0:_0x502e47['offset'];var _0x10e560=_0x174f58?_0x713add['count']:_0x502e47[_0x04b6('0x1f')]+_0x502e47[_0x04b6('0x20')];var _0x37509d;if(_0x10e560>=_0xaefeab){_0x10e560=_0xaefeab;_0x37509d=0xc8;}else{_0x37509d=0xce;}_0x3bf5cc[_0x04b6('0x1c')](_0x37509d);return _0x3bf5cc['set']('Content-Range',_0x2ef97b+'-'+_0x10e560+'/'+_0xaefeab)['json'](_0x713add);}return null;};}function patchUpdates(_0x17bee1){return function(_0xecdac6){try{jsonpatch['apply'](_0xecdac6,_0x17bee1,!![]);}catch(_0x37c65e){return BPromise[_0x04b6('0x21')](_0x37c65e);}return _0xecdac6[_0x04b6('0x22')]();};}function saveUpdates(_0x21a3f8,_0x59ca9c){return function(_0x4270ec){if(_0x4270ec){return _0x4270ec[_0x04b6('0x23')](_0x21a3f8)[_0x04b6('0x24')](function(_0x15e95b){return _0x15e95b;});}return null;};}function removeEntity(_0x5e38b0,_0x26e25d){return function(_0x3b3ce9){if(_0x3b3ce9){return _0x3b3ce9[_0x04b6('0x25')]()[_0x04b6('0x24')](function(){_0x5e38b0[_0x04b6('0x1c')](0xcc)[_0x04b6('0x1d')]();});}};}function handleEntityNotFound(_0x3c45ab,_0x59b25f){return function(_0x184014){if(!_0x184014){_0x3c45ab[_0x04b6('0x1b')](0x194);}return _0x184014;};}function handleError(_0x3652d7,_0x37402c){_0x37402c=_0x37402c||0x1f4;return function(_0x43e99f){logger['error'](_0x43e99f['stack']);if(_0x43e99f[_0x04b6('0x26')]){delete _0x43e99f[_0x04b6('0x26')];}_0x3652d7['status'](_0x37402c)[_0x04b6('0x27')](_0x43e99f);};}exports[_0x04b6('0x28')]=function(_0x5bd08a,_0x11ddaf){var _0x39b513={},_0xdec6a1={},_0x5d7ee1={'count':0x0,'rows':[]};var _0x31c56a=_[_0x04b6('0x29')](db[_0x04b6('0x2a')][_0x04b6('0x2b')],function(_0x379958){return{'name':_0x379958[_0x04b6('0x2c')],'type':_0x379958[_0x04b6('0x2d')][_0x04b6('0x2e')]};});_0xdec6a1[_0x04b6('0x2f')]=_[_0x04b6('0x29')](_0x31c56a,_0x04b6('0x26'));_0xdec6a1[_0x04b6('0x30')]=_[_0x04b6('0x31')](_0x5bd08a[_0x04b6('0x30')]);_0xdec6a1[_0x04b6('0x32')]=_['intersection'](_0xdec6a1[_0x04b6('0x2f')],_0xdec6a1[_0x04b6('0x30')]);_0x39b513[_0x04b6('0x33')]=_['intersection'](_0xdec6a1[_0x04b6('0x2f')],qs[_0x04b6('0x34')](_0x5bd08a[_0x04b6('0x30')][_0x04b6('0x34')]));_0x39b513[_0x04b6('0x33')]=_0x39b513[_0x04b6('0x33')][_0x04b6('0x35')]?_0x39b513[_0x04b6('0x33')]:_0xdec6a1[_0x04b6('0x2f')];if(!_0x5bd08a[_0x04b6('0x30')]['hasOwnProperty'](_0x04b6('0x36'))){_0x39b513['limit']=qs[_0x04b6('0x20')](_0x5bd08a[_0x04b6('0x30')][_0x04b6('0x20')]);_0x39b513[_0x04b6('0x1f')]=qs['offset'](_0x5bd08a['query'][_0x04b6('0x1f')]);}_0x39b513[_0x04b6('0x37')]=qs[_0x04b6('0x38')](_0x5bd08a[_0x04b6('0x30')][_0x04b6('0x38')]);_0x39b513[_0x04b6('0x39')]=qs[_0x04b6('0x32')](_['pick'](_0x5bd08a[_0x04b6('0x30')],_0xdec6a1['filters']),_0x31c56a);if(_0x5bd08a[_0x04b6('0x30')][_0x04b6('0x3a')]){_0x39b513[_0x04b6('0x39')]=_[_0x04b6('0x3b')](_0x39b513[_0x04b6('0x39')],{'$or':_[_0x04b6('0x29')](_0x31c56a,function(_0x2d3c23){if(_0x2d3c23[_0x04b6('0x2d')]!==_0x04b6('0x3c')){var _0x2820ce={};_0x2820ce[_0x2d3c23[_0x04b6('0x26')]]={'$like':'%'+_0x5bd08a['query'][_0x04b6('0x3a')]+'%'};return _0x2820ce;}})});}_0x39b513=_[_0x04b6('0x3b')]({},_0x39b513,_0x5bd08a[_0x04b6('0x3d')]);var _0x3ebd87={'where':_0x39b513[_0x04b6('0x39')]};return db['MemberReport']['count'](_0x3ebd87)[_0x04b6('0x24')](function(_0x682174){_0x5d7ee1['count']=_0x682174;if(_0x5bd08a[_0x04b6('0x30')][_0x04b6('0x3e')]){_0x39b513[_0x04b6('0x3f')]=[{'all':!![]}];}return db[_0x04b6('0x2a')][_0x04b6('0x40')](_0x39b513);})['then'](function(_0x33873d){_0x5d7ee1[_0x04b6('0x41')]=_0x33873d;return _0x5d7ee1;})[_0x04b6('0x24')](respondWithFilteredResult(_0x11ddaf,_0x39b513))[_0x04b6('0x42')](handleError(_0x11ddaf,null));};exports[_0x04b6('0x43')]=function(_0x16812f,_0xc753e4){var _0x256126={'raw':!![],'where':{'id':_0x16812f['params']['id']}},_0x55f2b0={};_0x55f2b0[_0x04b6('0x2f')]=_[_0x04b6('0x31')](db[_0x04b6('0x2a')][_0x04b6('0x2b')]);_0x55f2b0['query']=_['keys'](_0x16812f['query']);_0x55f2b0[_0x04b6('0x32')]=_['intersection'](_0x55f2b0[_0x04b6('0x2f')],_0x55f2b0[_0x04b6('0x30')]);_0x256126[_0x04b6('0x33')]=_[_0x04b6('0x44')](_0x55f2b0[_0x04b6('0x2f')],qs[_0x04b6('0x34')](_0x16812f[_0x04b6('0x30')]['fields']));_0x256126[_0x04b6('0x33')]=_0x256126['attributes'][_0x04b6('0x35')]?_0x256126[_0x04b6('0x33')]:_0x55f2b0[_0x04b6('0x2f')];if(_0x16812f[_0x04b6('0x30')]['includeAll']){_0x256126[_0x04b6('0x3f')]=[{'all':!![]}];}_0x256126=_[_0x04b6('0x3b')]({},_0x256126,_0x16812f['options']);return db[_0x04b6('0x2a')][_0x04b6('0x45')](_0x256126)[_0x04b6('0x24')](handleEntityNotFound(_0xc753e4,null))[_0x04b6('0x24')](respondWithResult(_0xc753e4,null))[_0x04b6('0x42')](handleError(_0xc753e4,null));};exports['create']=function(_0xd8cc08,_0x3357ad){return db[_0x04b6('0x2a')][_0x04b6('0x46')](_0xd8cc08[_0x04b6('0x47')],{})['then'](respondWithResult(_0x3357ad,0xc9))[_0x04b6('0x42')](handleError(_0x3357ad,null));};exports[_0x04b6('0x23')]=function(_0x504bc7,_0x5c40f8){if(_0x504bc7[_0x04b6('0x47')]['id']){delete _0x504bc7[_0x04b6('0x47')]['id'];}return db[_0x04b6('0x2a')]['find']({'where':{'id':_0x504bc7[_0x04b6('0x48')]['id']}})[_0x04b6('0x24')](handleEntityNotFound(_0x5c40f8,null))['then'](saveUpdates(_0x504bc7['body'],null))[_0x04b6('0x24')](respondWithResult(_0x5c40f8,null))[_0x04b6('0x42')](handleError(_0x5c40f8,null));};exports[_0x04b6('0x25')]=function(_0x577e01,_0x24c73a){return db[_0x04b6('0x2a')][_0x04b6('0x45')]({'where':{'id':_0x577e01[_0x04b6('0x48')]['id']}})[_0x04b6('0x24')](handleEntityNotFound(_0x24c73a,null))[_0x04b6('0x24')](removeEntity(_0x24c73a,null))[_0x04b6('0x42')](handleError(_0x24c73a,null));};exports[_0x04b6('0x49')]=function(_0x11ac03,_0x12316d){return db[_0x04b6('0x2a')]['describe']()[_0x04b6('0x24')](respondWithResult(_0x12316d,null))[_0x04b6('0x42')](handleError(_0x12316d,null));};