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 _0x8618=['html-pdf','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','json','count','offset','limit','set','Content-Range','apply','reject','then','status','error','stack','name','send','index','map','MemberReport','fieldName','type','key','model','keys','query','intersection','attributes','fields','length','hasOwnProperty','order','where','filters','pick','filter','merge','VIRTUAL','options','includeAll','findAll','rows','catch','show','rawAttributes','include','create','body','update','find','params','describe'];(function(_0x59c683,_0x209444){var _0x47251b=function(_0x4db046){while(--_0x4db046){_0x59c683['push'](_0x59c683['shift']());}};_0x47251b(++_0x209444);}(_0x8618,0x138));var _0x8861=function(_0xfd2d90,_0x33db0d){_0xfd2d90=_0xfd2d90-0x0;var _0x34689b=_0x8618[_0xfd2d90];return _0x34689b;};'use strict';var pdf=require(_0x8861('0x0'));var emlformat=require('eml-format');var rimraf=require(_0x8861('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x8861('0x2'));var rp=require(_0x8861('0x3'));var moment=require(_0x8861('0x4'));var BPromise=require(_0x8861('0x5'));var Mustache=require(_0x8861('0x6'));var util=require(_0x8861('0x7'));var path=require(_0x8861('0x8'));var sox=require(_0x8861('0x9'));var csv=require(_0x8861('0xa'));var ejs=require(_0x8861('0xb'));var fs=require('fs');var _=require(_0x8861('0xc'));var squel=require(_0x8861('0xd'));var crypto=require(_0x8861('0xe'));var jsforce=require(_0x8861('0xf'));var deskjs=require(_0x8861('0x10'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x8861('0x11'));var Redis=require(_0x8861('0x12'));var authService=require(_0x8861('0x13'));var qs=require(_0x8861('0x14'));var as=require(_0x8861('0x15'));var hardwareService=require(_0x8861('0x16'));var logger=require(_0x8861('0x17'))('api');var utils=require('../../config/utils');var config=require(_0x8861('0x18'));var licenseUtil=require(_0x8861('0x19'));var db=require(_0x8861('0x1a'))['db'];function respondWithStatusCode(_0x3e2a13,_0x3b3545){_0x3b3545=_0x3b3545||0xcc;return function(_0x2bacb4){if(_0x2bacb4){return _0x3e2a13[_0x8861('0x1b')](_0x3b3545);}return _0x3e2a13['status'](_0x3b3545)[_0x8861('0x1c')]();};}function respondWithResult(_0x479146,_0x494853){_0x494853=_0x494853||0xc8;return function(_0x5382f8){if(_0x5382f8){return _0x479146['status'](_0x494853)[_0x8861('0x1d')](_0x5382f8);}};}function respondWithFilteredResult(_0x16858d,_0x333acf){return function(_0x38d317){if(_0x38d317){var _0x5f4615=_0x38d317[_0x8861('0x1e')],_0x327153=_0x333acf[_0x8861('0x1f')],_0x4168d9=_0x333acf[_0x8861('0x1f')]+_0x333acf[_0x8861('0x20')],_0x3cfb1a;if(_0x4168d9>=_0x5f4615){_0x4168d9=_0x5f4615;_0x3cfb1a=0xc8;}else{_0x3cfb1a=0xce;}_0x16858d['status'](_0x3cfb1a);return _0x16858d[_0x8861('0x21')](_0x8861('0x22'),_0x327153+'-'+_0x4168d9+'/'+_0x5f4615)[_0x8861('0x1d')](_0x38d317);}return null;};}function patchUpdates(_0x2191ae){return function(_0x22451b){try{jsonpatch[_0x8861('0x23')](_0x22451b,_0x2191ae,!![]);}catch(_0x89a070){return BPromise[_0x8861('0x24')](_0x89a070);}return _0x22451b['save']();};}function saveUpdates(_0x193159,_0x5aeac4){return function(_0x1d859d){if(_0x1d859d){return _0x1d859d['update'](_0x193159)[_0x8861('0x25')](function(_0x4ab812){return _0x4ab812;});}return null;};}function removeEntity(_0x596fb8,_0x1804a2){return function(_0x2415c1){if(_0x2415c1){return _0x2415c1['destroy']()[_0x8861('0x25')](function(){_0x596fb8[_0x8861('0x26')](0xcc)[_0x8861('0x1c')]();});}};}function handleEntityNotFound(_0x17a746,_0x44b166){return function(_0x48118a){if(!_0x48118a){_0x17a746[_0x8861('0x1b')](0x194);}return _0x48118a;};}function handleError(_0x2e2ce3,_0x12ef0b){_0x12ef0b=_0x12ef0b||0x1f4;return function(_0xec0d93){logger[_0x8861('0x27')](_0xec0d93[_0x8861('0x28')]);if(_0xec0d93[_0x8861('0x29')]){delete _0xec0d93[_0x8861('0x29')];}_0x2e2ce3[_0x8861('0x26')](_0x12ef0b)[_0x8861('0x2a')](_0xec0d93);};}exports[_0x8861('0x2b')]=function(_0x4f2fa4,_0x4a7403){var _0x399161={},_0x579324={},_0x1200db={'count':0x0,'rows':[]};var _0x4f6bad=_[_0x8861('0x2c')](db[_0x8861('0x2d')]['rawAttributes'],function(_0x5581d2){return{'name':_0x5581d2[_0x8861('0x2e')],'type':_0x5581d2[_0x8861('0x2f')][_0x8861('0x30')]};});_0x579324[_0x8861('0x31')]=_[_0x8861('0x2c')](_0x4f6bad,_0x8861('0x29'));_0x579324['query']=_[_0x8861('0x32')](_0x4f2fa4[_0x8861('0x33')]);_0x579324['filters']=_[_0x8861('0x34')](_0x579324[_0x8861('0x31')],_0x579324[_0x8861('0x33')]);_0x399161[_0x8861('0x35')]=_[_0x8861('0x34')](_0x579324[_0x8861('0x31')],qs[_0x8861('0x36')](_0x4f2fa4[_0x8861('0x33')][_0x8861('0x36')]));_0x399161[_0x8861('0x35')]=_0x399161[_0x8861('0x35')][_0x8861('0x37')]?_0x399161[_0x8861('0x35')]:_0x579324[_0x8861('0x31')];if(!_0x4f2fa4[_0x8861('0x33')][_0x8861('0x38')]('nolimit')){_0x399161['limit']=qs['limit'](_0x4f2fa4[_0x8861('0x33')]['limit']);_0x399161[_0x8861('0x1f')]=qs['offset'](_0x4f2fa4[_0x8861('0x33')][_0x8861('0x1f')]);}_0x399161[_0x8861('0x39')]=qs['sort'](_0x4f2fa4['query']['sort']);_0x399161[_0x8861('0x3a')]=qs[_0x8861('0x3b')](_[_0x8861('0x3c')](_0x4f2fa4['query'],_0x579324[_0x8861('0x3b')]),_0x4f6bad);if(_0x4f2fa4[_0x8861('0x33')][_0x8861('0x3d')]){_0x399161[_0x8861('0x3a')]=_[_0x8861('0x3e')](_0x399161[_0x8861('0x3a')],{'$or':_[_0x8861('0x2c')](_0x4f6bad,function(_0x5c688f){if(_0x5c688f[_0x8861('0x2f')]!==_0x8861('0x3f')){var _0x9f1de8={};_0x9f1de8[_0x5c688f[_0x8861('0x29')]]={'$like':'%'+_0x4f2fa4['query'][_0x8861('0x3d')]+'%'};return _0x9f1de8;}})});}_0x399161=_[_0x8861('0x3e')]({},_0x399161,_0x4f2fa4[_0x8861('0x40')]);var _0x5b5beb={'where':_0x399161[_0x8861('0x3a')]};return db[_0x8861('0x2d')][_0x8861('0x1e')](_0x5b5beb)['then'](function(_0x4f64f6){_0x1200db['count']=_0x4f64f6;if(_0x4f2fa4['query'][_0x8861('0x41')]){_0x399161['include']=[{'all':!![]}];}return db[_0x8861('0x2d')][_0x8861('0x42')](_0x399161);})[_0x8861('0x25')](function(_0x261d4a){_0x1200db[_0x8861('0x43')]=_0x261d4a;return _0x1200db;})[_0x8861('0x25')](respondWithFilteredResult(_0x4a7403,_0x399161))[_0x8861('0x44')](handleError(_0x4a7403,null));};exports[_0x8861('0x45')]=function(_0x17b394,_0x4084b8){var _0xe3c8ee={'raw':!![],'where':{'id':_0x17b394['params']['id']}},_0x2334cc={};_0x2334cc[_0x8861('0x31')]=_[_0x8861('0x32')](db[_0x8861('0x2d')][_0x8861('0x46')]);_0x2334cc[_0x8861('0x33')]=_[_0x8861('0x32')](_0x17b394['query']);_0x2334cc[_0x8861('0x3b')]=_[_0x8861('0x34')](_0x2334cc['model'],_0x2334cc[_0x8861('0x33')]);_0xe3c8ee['attributes']=_[_0x8861('0x34')](_0x2334cc[_0x8861('0x31')],qs[_0x8861('0x36')](_0x17b394[_0x8861('0x33')][_0x8861('0x36')]));_0xe3c8ee[_0x8861('0x35')]=_0xe3c8ee['attributes'][_0x8861('0x37')]?_0xe3c8ee[_0x8861('0x35')]:_0x2334cc[_0x8861('0x31')];if(_0x17b394['query'][_0x8861('0x41')]){_0xe3c8ee[_0x8861('0x47')]=[{'all':!![]}];}_0xe3c8ee=_[_0x8861('0x3e')]({},_0xe3c8ee,_0x17b394['options']);return db[_0x8861('0x2d')]['find'](_0xe3c8ee)[_0x8861('0x25')](handleEntityNotFound(_0x4084b8,null))[_0x8861('0x25')](respondWithResult(_0x4084b8,null))['catch'](handleError(_0x4084b8,null));};exports['create']=function(_0x34b689,_0x94d58b){return db[_0x8861('0x2d')][_0x8861('0x48')](_0x34b689[_0x8861('0x49')],{})[_0x8861('0x25')](respondWithResult(_0x94d58b,0xc9))[_0x8861('0x44')](handleError(_0x94d58b,null));};exports[_0x8861('0x4a')]=function(_0x56ecb5,_0x32864f){if(_0x56ecb5[_0x8861('0x49')]['id']){delete _0x56ecb5[_0x8861('0x49')]['id'];}return db['MemberReport'][_0x8861('0x4b')]({'where':{'id':_0x56ecb5[_0x8861('0x4c')]['id']}})[_0x8861('0x25')](handleEntityNotFound(_0x32864f,null))[_0x8861('0x25')](saveUpdates(_0x56ecb5[_0x8861('0x49')],null))[_0x8861('0x25')](respondWithResult(_0x32864f,null))[_0x8861('0x44')](handleError(_0x32864f,null));};exports['destroy']=function(_0x3f4a78,_0x161f74){return db['MemberReport']['find']({'where':{'id':_0x3f4a78[_0x8861('0x4c')]['id']}})[_0x8861('0x25')](handleEntityNotFound(_0x161f74,null))[_0x8861('0x25')](removeEntity(_0x161f74,null))[_0x8861('0x44')](handleError(_0x161f74,null));};exports[_0x8861('0x4d')]=function(_0x20a8bf,_0x2aa16d){return db[_0x8861('0x2d')]['describe']()['then'](respondWithResult(_0x2aa16d,null))[_0x8861('0x44')](handleError(_0x2aa16d,null));};