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 _0xedef=['intersection','attributes','fields','length','hasOwnProperty','sort','filters','pick','where','merge','VIRTUAL','filter','includeAll','include','findAll','rows','catch','show','params','options','find','create','body','bulkCreate','bulkDestroy','destroy','addFields','AnalyticCustomReport','findOne','transaction','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','ejs','lodash','squel','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','status','json','count','offset','limit','Content-Range','apply','reject','save','update','then','end','sendStatus','stack','name','send','index','map','AnalyticFieldReport','rawAttributes','fieldName','type','key','model','keys','query'];(function(_0x57da61,_0x1d42ff){var _0x492f3d=function(_0x556383){while(--_0x556383){_0x57da61['push'](_0x57da61['shift']());}};_0x492f3d(++_0x1d42ff);}(_0xedef,0x1b3));var _0xfede=function(_0x3d7eaf,_0x2f6b14){_0x3d7eaf=_0x3d7eaf-0x0;var _0x38ed77=_0xedef[_0x3d7eaf];return _0x38ed77;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0xfede('0x0'));var rimraf=require(_0xfede('0x1'));var zipdir=require(_0xfede('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xfede('0x3'));var moment=require(_0xfede('0x4'));var BPromise=require(_0xfede('0x5'));var Mustache=require(_0xfede('0x6'));var util=require(_0xfede('0x7'));var path=require(_0xfede('0x8'));var sox=require(_0xfede('0x9'));var csv=require('to-csv');var ejs=require(_0xfede('0xa'));var fs=require('fs');var _=require(_0xfede('0xb'));var squel=require(_0xfede('0xc'));var crypto=require('crypto');var jsforce=require(_0xfede('0xd'));var deskjs=require(_0xfede('0xe'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0xfede('0xf'));var Redis=require(_0xfede('0x10'));var authService=require(_0xfede('0x11'));var qs=require('../../components/parsers/qs');var as=require(_0xfede('0x12'));var hardwareService=require(_0xfede('0x13'));var logger=require(_0xfede('0x14'))(_0xfede('0x15'));var utils=require('../../config/utils');var config=require(_0xfede('0x16'));var licenseUtil=require(_0xfede('0x17'));var db=require(_0xfede('0x18'))['db'];function respondWithStatusCode(_0xb1b2df,_0x2fa71d){_0x2fa71d=_0x2fa71d||0xcc;return function(_0x166473){if(_0x166473){return _0xb1b2df['sendStatus'](_0x2fa71d);}return _0xb1b2df['status'](_0x2fa71d)['end']();};}function respondWithResult(_0x52c495,_0x50e163){_0x50e163=_0x50e163||0xc8;return function(_0x4a771c){if(_0x4a771c){return _0x52c495[_0xfede('0x19')](_0x50e163)[_0xfede('0x1a')](_0x4a771c);}};}function respondWithFilteredResult(_0xe9bac6,_0x1a612b){return function(_0x532ced){if(_0x532ced){var _0x3e5200=_0x532ced[_0xfede('0x1b')],_0x1cd2b0=_0x1a612b[_0xfede('0x1c')],_0x2b73ed=_0x1a612b[_0xfede('0x1c')]+_0x1a612b[_0xfede('0x1d')],_0x933c7c;if(_0x2b73ed>=_0x3e5200){_0x2b73ed=_0x3e5200;_0x933c7c=0xc8;}else{_0x933c7c=0xce;}_0xe9bac6[_0xfede('0x19')](_0x933c7c);return _0xe9bac6['set'](_0xfede('0x1e'),_0x1cd2b0+'-'+_0x2b73ed+'/'+_0x3e5200)['json'](_0x532ced);}return null;};}function patchUpdates(_0x5fb76f){return function(_0x5c135a){try{jsonpatch[_0xfede('0x1f')](_0x5c135a,_0x5fb76f,!![]);}catch(_0xa43432){return BPromise[_0xfede('0x20')](_0xa43432);}return _0x5c135a[_0xfede('0x21')]();};}function saveUpdates(_0x4bd555,_0x44befb){return function(_0x4ea6da){if(_0x4ea6da){return _0x4ea6da[_0xfede('0x22')](_0x4bd555)['then'](function(_0x212210){return _0x212210;});}return null;};}function removeEntity(_0x3c3f6a,_0x4f4cc5){return function(_0x1f8b9){if(_0x1f8b9){return _0x1f8b9['destroy']()[_0xfede('0x23')](function(){_0x3c3f6a[_0xfede('0x19')](0xcc)[_0xfede('0x24')]();});}};}function handleEntityNotFound(_0xc5490d,_0x4318a3){return function(_0x392775){if(!_0x392775){_0xc5490d[_0xfede('0x25')](0x194);}return _0x392775;};}function handleError(_0x585e83,_0x10f40a){_0x10f40a=_0x10f40a||0x1f4;return function(_0x18b218){logger['error'](_0x18b218[_0xfede('0x26')]);if(_0x18b218[_0xfede('0x27')]){delete _0x18b218[_0xfede('0x27')];}_0x585e83[_0xfede('0x19')](_0x10f40a)[_0xfede('0x28')](_0x18b218);};}exports[_0xfede('0x29')]=function(_0x52eedf,_0x427b1e){var _0x261e7c={},_0x174381={},_0x1bd9d2={'count':0x0,'rows':[]};var _0x623989=_[_0xfede('0x2a')](db[_0xfede('0x2b')][_0xfede('0x2c')],function(_0x44aa9e){return{'name':_0x44aa9e[_0xfede('0x2d')],'type':_0x44aa9e[_0xfede('0x2e')][_0xfede('0x2f')]};});_0x174381[_0xfede('0x30')]=_[_0xfede('0x2a')](_0x623989,_0xfede('0x27'));_0x174381['query']=_[_0xfede('0x31')](_0x52eedf[_0xfede('0x32')]);_0x174381['filters']=_[_0xfede('0x33')](_0x174381[_0xfede('0x30')],_0x174381[_0xfede('0x32')]);_0x261e7c[_0xfede('0x34')]=_['intersection'](_0x174381[_0xfede('0x30')],qs[_0xfede('0x35')](_0x52eedf[_0xfede('0x32')][_0xfede('0x35')]));_0x261e7c[_0xfede('0x34')]=_0x261e7c[_0xfede('0x34')][_0xfede('0x36')]?_0x261e7c['attributes']:_0x174381[_0xfede('0x30')];if(!_0x52eedf[_0xfede('0x32')][_0xfede('0x37')]('nolimit')){_0x261e7c['limit']=qs[_0xfede('0x1d')](_0x52eedf[_0xfede('0x32')][_0xfede('0x1d')]);_0x261e7c[_0xfede('0x1c')]=qs[_0xfede('0x1c')](_0x52eedf[_0xfede('0x32')][_0xfede('0x1c')]);}_0x261e7c['order']=qs[_0xfede('0x38')](_0x52eedf[_0xfede('0x32')][_0xfede('0x38')]);_0x261e7c['where']=qs[_0xfede('0x39')](_[_0xfede('0x3a')](_0x52eedf[_0xfede('0x32')],_0x174381['filters']),_0x623989);if(_0x52eedf[_0xfede('0x32')]['filter']){_0x261e7c[_0xfede('0x3b')]=_[_0xfede('0x3c')](_0x261e7c[_0xfede('0x3b')],{'$or':_[_0xfede('0x2a')](_0x623989,function(_0x2b00c8){if(_0x2b00c8[_0xfede('0x2e')]!==_0xfede('0x3d')){var _0x337146={};_0x337146[_0x2b00c8['name']]={'$like':'%'+_0x52eedf[_0xfede('0x32')][_0xfede('0x3e')]+'%'};return _0x337146;}})});}_0x261e7c=_['merge']({},_0x261e7c,_0x52eedf['options']);var _0x36571e={'where':_0x261e7c[_0xfede('0x3b')]};return db[_0xfede('0x2b')][_0xfede('0x1b')](_0x36571e)[_0xfede('0x23')](function(_0x1aae76){_0x1bd9d2[_0xfede('0x1b')]=_0x1aae76;if(_0x52eedf[_0xfede('0x32')][_0xfede('0x3f')]){_0x261e7c[_0xfede('0x40')]=[{'all':!![]}];}return db[_0xfede('0x2b')][_0xfede('0x41')](_0x261e7c);})[_0xfede('0x23')](function(_0x28130b){_0x1bd9d2[_0xfede('0x42')]=_0x28130b;return _0x1bd9d2;})[_0xfede('0x23')](respondWithFilteredResult(_0x427b1e,_0x261e7c))[_0xfede('0x43')](handleError(_0x427b1e,null));};exports[_0xfede('0x44')]=function(_0x29a4eb,_0x15bf02){var _0x521e08={'raw':![],'where':{'id':_0x29a4eb[_0xfede('0x45')]['id']}},_0x36ee39={};_0x36ee39[_0xfede('0x30')]=_[_0xfede('0x31')](db['AnalyticFieldReport']['rawAttributes']);_0x36ee39[_0xfede('0x32')]=_[_0xfede('0x31')](_0x29a4eb[_0xfede('0x32')]);_0x36ee39[_0xfede('0x39')]=_[_0xfede('0x33')](_0x36ee39[_0xfede('0x30')],_0x36ee39[_0xfede('0x32')]);_0x521e08[_0xfede('0x34')]=_['intersection'](_0x36ee39['model'],qs['fields'](_0x29a4eb[_0xfede('0x32')]['fields']));_0x521e08[_0xfede('0x34')]=_0x521e08[_0xfede('0x34')]['length']?_0x521e08[_0xfede('0x34')]:_0x36ee39[_0xfede('0x30')];if(_0x29a4eb['query']['includeAll']){_0x521e08['include']=[{'all':!![]}];}_0x521e08=_['merge']({},_0x521e08,_0x29a4eb[_0xfede('0x46')]);return db[_0xfede('0x2b')][_0xfede('0x47')](_0x521e08)[_0xfede('0x23')](handleEntityNotFound(_0x15bf02,null))[_0xfede('0x23')](respondWithResult(_0x15bf02,null))['catch'](handleError(_0x15bf02,null));};exports[_0xfede('0x48')]=function(_0x4f7505,_0x5aff22){return db[_0xfede('0x2b')][_0xfede('0x48')](_0x4f7505[_0xfede('0x49')],{})[_0xfede('0x23')](respondWithResult(_0x5aff22,0xc9))['catch'](handleError(_0x5aff22,null));};exports[_0xfede('0x4a')]=function(_0x15e941,_0x99df6b){return db['AnalyticFieldReport'][_0xfede('0x4a')](_0x15e941[_0xfede('0x49')],{'raw':![],'individualHooks':!![]})['then'](respondWithResult(_0x99df6b,0xc9))[_0xfede('0x43')](handleError(_0x99df6b,null));};exports['update']=function(_0x5ddf5c,_0x285130){if(_0x5ddf5c[_0xfede('0x49')]['id']){delete _0x5ddf5c[_0xfede('0x49')]['id'];}return db[_0xfede('0x2b')][_0xfede('0x47')]({'where':{'id':_0x5ddf5c[_0xfede('0x45')]['id']}})['then'](handleEntityNotFound(_0x285130,null))[_0xfede('0x23')](saveUpdates(_0x5ddf5c[_0xfede('0x49')],null))[_0xfede('0x23')](respondWithResult(_0x285130,null))[_0xfede('0x43')](handleError(_0x285130,null));};exports['destroy']=function(_0x4885ea,_0x45ec74){return db['AnalyticFieldReport'][_0xfede('0x47')]({'where':{'id':_0x4885ea[_0xfede('0x45')]['id']}})['then'](handleEntityNotFound(_0x45ec74,null))[_0xfede('0x23')](removeEntity(_0x45ec74,null))[_0xfede('0x43')](handleError(_0x45ec74,null));};exports[_0xfede('0x4b')]=function(_0x5f18dd,_0x12049d){return db[_0xfede('0x2b')][_0xfede('0x4c')]({'where':{'id':_0x5f18dd[_0xfede('0x32')]['ids']||[]},'raw':![],'individualHooks':!![]})['then'](respondWithResult(_0x12049d,0xcc))[_0xfede('0x43')](handleError(_0x12049d,null));};exports[_0xfede('0x4d')]=function(_0x47cc7b,_0x1e2f18,_0x2287e2){return db[_0xfede('0x4e')][_0xfede('0x4f')]({'where':{'id':_0x47cc7b[_0xfede('0x45')]['id']}})[_0xfede('0x23')](handleEntityNotFound(_0x1e2f18,null))[_0xfede('0x23')](function(_0x3b11a5){if(_0x3b11a5){return db['sequelize'][_0xfede('0x50')](function(_0x21052f){return db[_0xfede('0x2b')][_0xfede('0x4c')]({'where':{'CustomReportId':_0x47cc7b[_0xfede('0x45')]['id']},'transaction':_0x21052f})[_0xfede('0x23')](function(_0x1f5432){var _0xa1d28c=_[_0xfede('0x2a')](_0x47cc7b[_0xfede('0x49')],function(_0x1bf4ac){delete _0x1bf4ac['id'];_0x1bf4ac['CustomReportId']=_0x47cc7b[_0xfede('0x45')]['id'];return _0x1bf4ac;});return db['AnalyticFieldReport'][_0xfede('0x4a')](_0xa1d28c,{'transaction':_0x21052f});});})['then'](function(){return db[_0xfede('0x2b')][_0xfede('0x41')]({'where':{'CustomReportId':_0x47cc7b[_0xfede('0x45')]['id']}});});}})[_0xfede('0x23')](respondWithResult(_0x1e2f18,null))['catch'](handleError(_0x1e2f18,null));};