server/api/analyticFieldReport/analyticFieldReport.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 _0xf9ee=['fast-json-patch','request-promise','moment','bluebird','mustache','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','querystring','ioredis','../../components/auth/service','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','sendStatus','status','offset','limit','undefined','count','set','Content-Range','json','save','update','destroy','then','stack','name','index','map','rawAttributes','fieldName','type','key','model','keys','query','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','filter','merge','VIRTUAL','options','AnalyticFieldReport','include','findAll','rows','show','params','includeAll','find','create','body','catch','bulkCreate','bulkDestroy','ids','addFields','sequelize','transaction','eml-format','rimraf','zip-dir'];(function(_0x271aa7,_0x309496){var _0xbb50e0=function(_0x12a74d){while(--_0x12a74d){_0x271aa7['push'](_0x271aa7['shift']());}};_0xbb50e0(++_0x309496);}(_0xf9ee,0x1dd));var _0xef9e=function(_0x2c47a5,_0x1c89fa){_0x2c47a5=_0x2c47a5-0x0;var _0x227dfc=_0xf9ee[_0x2c47a5];return _0x227dfc;};'use strict';var emlformat=require(_0xef9e('0x0'));var rimraf=require(_0xef9e('0x1'));var zipdir=require(_0xef9e('0x2'));var jsonpatch=require(_0xef9e('0x3'));var rp=require(_0xef9e('0x4'));var moment=require(_0xef9e('0x5'));var BPromise=require(_0xef9e('0x6'));var Mustache=require(_0xef9e('0x7'));var util=require('util');var path=require(_0xef9e('0x8'));var sox=require(_0xef9e('0x9'));var csv=require(_0xef9e('0xa'));var ejs=require(_0xef9e('0xb'));var fs=require('fs');var fs_extra=require(_0xef9e('0xc'));var _=require(_0xef9e('0xd'));var squel=require(_0xef9e('0xe'));var crypto=require(_0xef9e('0xf'));var jsforce=require(_0xef9e('0x10'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0xef9e('0x11'));var Papa=require('papaparse');var Redis=require(_0xef9e('0x12'));var authService=require(_0xef9e('0x13'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xef9e('0x14'));var logger=require('../../config/logger')(_0xef9e('0x15'));var utils=require(_0xef9e('0x16'));var config=require(_0xef9e('0x17'));var licenseUtil=require(_0xef9e('0x18'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x514a75,_0x4fa628){_0x4fa628=_0x4fa628||0xcc;return function(_0x5eff45){if(_0x5eff45){return _0x514a75[_0xef9e('0x19')](_0x4fa628);}return _0x514a75[_0xef9e('0x1a')](_0x4fa628)['end']();};}function respondWithResult(_0x39cc21,_0x46618e){_0x46618e=_0x46618e||0xc8;return function(_0x32e031){if(_0x32e031){return _0x39cc21[_0xef9e('0x1a')](_0x46618e)['json'](_0x32e031);}};}function respondWithFilteredResult(_0x56623a,_0x35948c){return function(_0x2dab4e){if(_0x2dab4e){var _0x10cb43=typeof _0x35948c[_0xef9e('0x1b')]==='undefined'&&typeof _0x35948c[_0xef9e('0x1c')]===_0xef9e('0x1d');var _0x48939c=_0x2dab4e[_0xef9e('0x1e')];var _0x3bb205=_0x10cb43?0x0:_0x35948c['offset'];var _0x3e103a=_0x10cb43?_0x2dab4e[_0xef9e('0x1e')]:_0x35948c[_0xef9e('0x1b')]+_0x35948c[_0xef9e('0x1c')];var _0x13536f;if(_0x3e103a>=_0x48939c){_0x3e103a=_0x48939c;_0x13536f=0xc8;}else{_0x13536f=0xce;}_0x56623a[_0xef9e('0x1a')](_0x13536f);return _0x56623a[_0xef9e('0x1f')](_0xef9e('0x20'),_0x3bb205+'-'+_0x3e103a+'/'+_0x48939c)[_0xef9e('0x21')](_0x2dab4e);}return null;};}function patchUpdates(_0x471a70){return function(_0x51742a){try{jsonpatch['apply'](_0x51742a,_0x471a70,!![]);}catch(_0x1c0b51){return BPromise['reject'](_0x1c0b51);}return _0x51742a[_0xef9e('0x22')]();};}function saveUpdates(_0x538bda,_0x2d4b70){return function(_0x4a0838){if(_0x4a0838){return _0x4a0838[_0xef9e('0x23')](_0x538bda)['then'](function(_0x3f9915){return _0x3f9915;});}return null;};}function removeEntity(_0x547b8d,_0x5d9b4d){return function(_0x3671f6){if(_0x3671f6){return _0x3671f6[_0xef9e('0x24')]()[_0xef9e('0x25')](function(){_0x547b8d['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x1b187d,_0x576ff2){return function(_0x310c2e){if(!_0x310c2e){_0x1b187d[_0xef9e('0x19')](0x194);}return _0x310c2e;};}function handleError(_0x13cb84,_0x42e8e6){_0x42e8e6=_0x42e8e6||0x1f4;return function(_0x560ec8){logger['error'](_0x560ec8[_0xef9e('0x26')]);if(_0x560ec8[_0xef9e('0x27')]){delete _0x560ec8[_0xef9e('0x27')];}_0x13cb84[_0xef9e('0x1a')](_0x42e8e6)['send'](_0x560ec8);};}exports[_0xef9e('0x28')]=function(_0x53cc7e,_0x29f7f9){var _0x51d3b1={},_0xb3c3d9={},_0x8d3ede={'count':0x0,'rows':[]};var _0x290147=_[_0xef9e('0x29')](db['AnalyticFieldReport'][_0xef9e('0x2a')],function(_0x2fd57b){return{'name':_0x2fd57b[_0xef9e('0x2b')],'type':_0x2fd57b[_0xef9e('0x2c')][_0xef9e('0x2d')]};});_0xb3c3d9[_0xef9e('0x2e')]=_[_0xef9e('0x29')](_0x290147,_0xef9e('0x27'));_0xb3c3d9['query']=_[_0xef9e('0x2f')](_0x53cc7e[_0xef9e('0x30')]);_0xb3c3d9['filters']=_[_0xef9e('0x31')](_0xb3c3d9[_0xef9e('0x2e')],_0xb3c3d9[_0xef9e('0x30')]);_0x51d3b1[_0xef9e('0x32')]=_[_0xef9e('0x31')](_0xb3c3d9[_0xef9e('0x2e')],qs['fields'](_0x53cc7e[_0xef9e('0x30')][_0xef9e('0x33')]));_0x51d3b1['attributes']=_0x51d3b1[_0xef9e('0x32')][_0xef9e('0x34')]?_0x51d3b1[_0xef9e('0x32')]:_0xb3c3d9[_0xef9e('0x2e')];if(!_0x53cc7e[_0xef9e('0x30')][_0xef9e('0x35')](_0xef9e('0x36'))){_0x51d3b1[_0xef9e('0x1c')]=qs['limit'](_0x53cc7e['query'][_0xef9e('0x1c')]);_0x51d3b1[_0xef9e('0x1b')]=qs['offset'](_0x53cc7e[_0xef9e('0x30')]['offset']);}_0x51d3b1[_0xef9e('0x37')]=qs[_0xef9e('0x38')](_0x53cc7e[_0xef9e('0x30')][_0xef9e('0x38')]);_0x51d3b1[_0xef9e('0x39')]=qs[_0xef9e('0x3a')](_['pick'](_0x53cc7e['query'],_0xb3c3d9[_0xef9e('0x3a')]),_0x290147);if(_0x53cc7e['query'][_0xef9e('0x3b')]){_0x51d3b1['where']=_[_0xef9e('0x3c')](_0x51d3b1[_0xef9e('0x39')],{'$or':_['map'](_0x290147,function(_0x27588a){if(_0x27588a['type']!==_0xef9e('0x3d')){var _0x38b080={};_0x38b080[_0x27588a[_0xef9e('0x27')]]={'$like':'%'+_0x53cc7e[_0xef9e('0x30')][_0xef9e('0x3b')]+'%'};return _0x38b080;}})});}_0x51d3b1=_['merge']({},_0x51d3b1,_0x53cc7e[_0xef9e('0x3e')]);var _0x4b84b2={'where':_0x51d3b1[_0xef9e('0x39')]};return db[_0xef9e('0x3f')][_0xef9e('0x1e')](_0x4b84b2)[_0xef9e('0x25')](function(_0x38c95c){_0x8d3ede[_0xef9e('0x1e')]=_0x38c95c;if(_0x53cc7e[_0xef9e('0x30')]['includeAll']){_0x51d3b1[_0xef9e('0x40')]=[{'all':!![]}];}return db[_0xef9e('0x3f')][_0xef9e('0x41')](_0x51d3b1);})[_0xef9e('0x25')](function(_0x21e72c){_0x8d3ede[_0xef9e('0x42')]=_0x21e72c;return _0x8d3ede;})['then'](respondWithFilteredResult(_0x29f7f9,_0x51d3b1))['catch'](handleError(_0x29f7f9,null));};exports[_0xef9e('0x43')]=function(_0x58354e,_0x64ef6e){var _0x5262af={'raw':![],'where':{'id':_0x58354e[_0xef9e('0x44')]['id']}},_0x31e43f={};_0x31e43f[_0xef9e('0x2e')]=_[_0xef9e('0x2f')](db[_0xef9e('0x3f')][_0xef9e('0x2a')]);_0x31e43f['query']=_[_0xef9e('0x2f')](_0x58354e[_0xef9e('0x30')]);_0x31e43f['filters']=_['intersection'](_0x31e43f[_0xef9e('0x2e')],_0x31e43f[_0xef9e('0x30')]);_0x5262af[_0xef9e('0x32')]=_[_0xef9e('0x31')](_0x31e43f[_0xef9e('0x2e')],qs[_0xef9e('0x33')](_0x58354e[_0xef9e('0x30')]['fields']));_0x5262af[_0xef9e('0x32')]=_0x5262af['attributes'][_0xef9e('0x34')]?_0x5262af[_0xef9e('0x32')]:_0x31e43f[_0xef9e('0x2e')];if(_0x58354e[_0xef9e('0x30')][_0xef9e('0x45')]){_0x5262af[_0xef9e('0x40')]=[{'all':!![]}];}_0x5262af=_['merge']({},_0x5262af,_0x58354e['options']);return db[_0xef9e('0x3f')][_0xef9e('0x46')](_0x5262af)['then'](handleEntityNotFound(_0x64ef6e,null))[_0xef9e('0x25')](respondWithResult(_0x64ef6e,null))['catch'](handleError(_0x64ef6e,null));};exports[_0xef9e('0x47')]=function(_0x4ced4d,_0x4def64){return db[_0xef9e('0x3f')][_0xef9e('0x47')](_0x4ced4d[_0xef9e('0x48')],{})[_0xef9e('0x25')](respondWithResult(_0x4def64,0xc9))[_0xef9e('0x49')](handleError(_0x4def64,null));};exports[_0xef9e('0x4a')]=function(_0x36d76e,_0x16f35d){return db[_0xef9e('0x3f')]['bulkCreate'](_0x36d76e['body'],{'raw':![],'individualHooks':!![]})[_0xef9e('0x25')](respondWithResult(_0x16f35d,0xc9))[_0xef9e('0x49')](handleError(_0x16f35d,null));};exports[_0xef9e('0x23')]=function(_0x24de2c,_0x3f7bac){if(_0x24de2c['body']['id']){delete _0x24de2c[_0xef9e('0x48')]['id'];}return db['AnalyticFieldReport'][_0xef9e('0x46')]({'where':{'id':_0x24de2c[_0xef9e('0x44')]['id']}})[_0xef9e('0x25')](handleEntityNotFound(_0x3f7bac,null))[_0xef9e('0x25')](saveUpdates(_0x24de2c[_0xef9e('0x48')],null))['then'](respondWithResult(_0x3f7bac,null))[_0xef9e('0x49')](handleError(_0x3f7bac,null));};exports[_0xef9e('0x24')]=function(_0x266c09,_0x3037ce){return db['AnalyticFieldReport']['find']({'where':{'id':_0x266c09['params']['id']}})[_0xef9e('0x25')](handleEntityNotFound(_0x3037ce,null))[_0xef9e('0x25')](removeEntity(_0x3037ce,null))[_0xef9e('0x49')](handleError(_0x3037ce,null));};exports[_0xef9e('0x4b')]=function(_0x5dafb0,_0x501c87){return db[_0xef9e('0x3f')][_0xef9e('0x24')]({'where':{'id':_0x5dafb0[_0xef9e('0x30')][_0xef9e('0x4c')]||[]},'raw':![],'individualHooks':!![]})[_0xef9e('0x25')](respondWithResult(_0x501c87,0xcc))[_0xef9e('0x49')](handleError(_0x501c87,null));};exports[_0xef9e('0x4d')]=function(_0x5ce858,_0x5d8748,_0x5d7489){return db['AnalyticCustomReport']['findOne']({'where':{'id':_0x5ce858[_0xef9e('0x44')]['id']}})[_0xef9e('0x25')](handleEntityNotFound(_0x5d8748,null))[_0xef9e('0x25')](function(_0x4c89ff){if(_0x4c89ff){return db[_0xef9e('0x4e')][_0xef9e('0x4f')](function(_0x2b8e04){return db[_0xef9e('0x3f')][_0xef9e('0x24')]({'where':{'CustomReportId':_0x5ce858[_0xef9e('0x44')]['id']},'transaction':_0x2b8e04})[_0xef9e('0x25')](function(_0x39c41){var _0x312e24=_['map'](_0x5ce858[_0xef9e('0x48')],function(_0x2b3ba7){delete _0x2b3ba7['id'];_0x2b3ba7['CustomReportId']=_0x5ce858['params']['id'];return _0x2b3ba7;});return db[_0xef9e('0x3f')]['bulkCreate'](_0x312e24,{'transaction':_0x2b8e04});});})['then'](function(){return db['AnalyticFieldReport'][_0xef9e('0x41')]({'where':{'CustomReportId':_0x5ce858[_0xef9e('0x44')]['id']}});});}})[_0xef9e('0x25')](respondWithResult(_0x5d8748,null))[_0xef9e('0x49')](handleError(_0x5d8748,null));};