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 _0x0636=['key','model','map','query','keys','attributes','intersection','fields','length','hasOwnProperty','nolimit','order','sort','pick','filters','merge','where','type','VIRTUAL','filter','options','AnalyticFieldReport','include','findAll','rows','catch','params','rawAttributes','includeAll','find','create','body','bulkCreate','bulkDestroy','ids','addFields','findOne','sequelize','transaction','CustomReportId','eml-format','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','ejs','fs-extra','lodash','squel','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/license/util','../../mysqldb','sendStatus','status','end','json','undefined','limit','count','offset','set','Content-Range','apply','reject','save','update','destroy','then','error','stack','name','send','index'];(function(_0x25d386,_0x108d0d){var _0x857f4a=function(_0x3eb98d){while(--_0x3eb98d){_0x25d386['push'](_0x25d386['shift']());}};_0x857f4a(++_0x108d0d);}(_0x0636,0x1d6));var _0x6063=function(_0x3527a6,_0x40035b){_0x3527a6=_0x3527a6-0x0;var _0x2d9cba=_0x0636[_0x3527a6];return _0x2d9cba;};'use strict';var emlformat=require(_0x6063('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x6063('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0x6063('0x2'));var moment=require(_0x6063('0x3'));var BPromise=require(_0x6063('0x4'));var Mustache=require(_0x6063('0x5'));var util=require(_0x6063('0x6'));var path=require(_0x6063('0x7'));var sox=require(_0x6063('0x8'));var csv=require('to-csv');var ejs=require(_0x6063('0x9'));var fs=require('fs');var fs_extra=require(_0x6063('0xa'));var _=require(_0x6063('0xb'));var squel=require(_0x6063('0xc'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x6063('0xd'));var querystring=require(_0x6063('0xe'));var Papa=require(_0x6063('0xf'));var Redis=require(_0x6063('0x10'));var authService=require(_0x6063('0x11'));var qs=require(_0x6063('0x12'));var as=require(_0x6063('0x13'));var hardwareService=require(_0x6063('0x14'));var logger=require(_0x6063('0x15'))(_0x6063('0x16'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0x6063('0x17'));var db=require(_0x6063('0x18'))['db'];function respondWithStatusCode(_0x390de3,_0x89f275){_0x89f275=_0x89f275||0xcc;return function(_0x2abe3c){if(_0x2abe3c){return _0x390de3[_0x6063('0x19')](_0x89f275);}return _0x390de3[_0x6063('0x1a')](_0x89f275)[_0x6063('0x1b')]();};}function respondWithResult(_0x10a748,_0xf667f7){_0xf667f7=_0xf667f7||0xc8;return function(_0x5c15f4){if(_0x5c15f4){return _0x10a748[_0x6063('0x1a')](_0xf667f7)[_0x6063('0x1c')](_0x5c15f4);}};}function respondWithFilteredResult(_0x8e7a18,_0x2affd7){return function(_0x2aab63){if(_0x2aab63){var _0x48c2d4=typeof _0x2affd7['offset']===_0x6063('0x1d')&&typeof _0x2affd7[_0x6063('0x1e')]===_0x6063('0x1d');var _0x590de3=_0x2aab63[_0x6063('0x1f')];var _0x170c97=_0x48c2d4?0x0:_0x2affd7['offset'];var _0x50028a=_0x48c2d4?_0x2aab63['count']:_0x2affd7[_0x6063('0x20')]+_0x2affd7[_0x6063('0x1e')];var _0x43a1e8;if(_0x50028a>=_0x590de3){_0x50028a=_0x590de3;_0x43a1e8=0xc8;}else{_0x43a1e8=0xce;}_0x8e7a18[_0x6063('0x1a')](_0x43a1e8);return _0x8e7a18[_0x6063('0x21')](_0x6063('0x22'),_0x170c97+'-'+_0x50028a+'/'+_0x590de3)[_0x6063('0x1c')](_0x2aab63);}return null;};}function patchUpdates(_0x34a56f){return function(_0x3190ef){try{jsonpatch[_0x6063('0x23')](_0x3190ef,_0x34a56f,!![]);}catch(_0x4edf5d){return BPromise[_0x6063('0x24')](_0x4edf5d);}return _0x3190ef[_0x6063('0x25')]();};}function saveUpdates(_0x2c6abf,_0x322afe){return function(_0x528431){if(_0x528431){return _0x528431[_0x6063('0x26')](_0x2c6abf)['then'](function(_0x20a131){return _0x20a131;});}return null;};}function removeEntity(_0x5924f1,_0x2b3339){return function(_0x3c0448){if(_0x3c0448){return _0x3c0448[_0x6063('0x27')]()[_0x6063('0x28')](function(){_0x5924f1[_0x6063('0x1a')](0xcc)[_0x6063('0x1b')]();});}};}function handleEntityNotFound(_0x3090cc,_0x2d23ff){return function(_0x243b0d){if(!_0x243b0d){_0x3090cc[_0x6063('0x19')](0x194);}return _0x243b0d;};}function handleError(_0x41af3a,_0x562a75){_0x562a75=_0x562a75||0x1f4;return function(_0x49d710){logger[_0x6063('0x29')](_0x49d710[_0x6063('0x2a')]);if(_0x49d710[_0x6063('0x2b')]){delete _0x49d710[_0x6063('0x2b')];}_0x41af3a[_0x6063('0x1a')](_0x562a75)[_0x6063('0x2c')](_0x49d710);};}exports[_0x6063('0x2d')]=function(_0x5c7c1f,_0x5089cb){var _0x67e1ba={},_0x5a8122={},_0x50f439={'count':0x0,'rows':[]};var _0x12b521=_['map'](db['AnalyticFieldReport']['rawAttributes'],function(_0x18f5c1){return{'name':_0x18f5c1['fieldName'],'type':_0x18f5c1['type'][_0x6063('0x2e')]};});_0x5a8122[_0x6063('0x2f')]=_[_0x6063('0x30')](_0x12b521,_0x6063('0x2b'));_0x5a8122[_0x6063('0x31')]=_[_0x6063('0x32')](_0x5c7c1f[_0x6063('0x31')]);_0x5a8122['filters']=_['intersection'](_0x5a8122[_0x6063('0x2f')],_0x5a8122[_0x6063('0x31')]);_0x67e1ba[_0x6063('0x33')]=_[_0x6063('0x34')](_0x5a8122[_0x6063('0x2f')],qs['fields'](_0x5c7c1f['query'][_0x6063('0x35')]));_0x67e1ba[_0x6063('0x33')]=_0x67e1ba[_0x6063('0x33')][_0x6063('0x36')]?_0x67e1ba[_0x6063('0x33')]:_0x5a8122[_0x6063('0x2f')];if(!_0x5c7c1f['query'][_0x6063('0x37')](_0x6063('0x38'))){_0x67e1ba[_0x6063('0x1e')]=qs[_0x6063('0x1e')](_0x5c7c1f['query']['limit']);_0x67e1ba[_0x6063('0x20')]=qs[_0x6063('0x20')](_0x5c7c1f[_0x6063('0x31')][_0x6063('0x20')]);}_0x67e1ba[_0x6063('0x39')]=qs[_0x6063('0x3a')](_0x5c7c1f[_0x6063('0x31')]['sort']);_0x67e1ba['where']=qs['filters'](_[_0x6063('0x3b')](_0x5c7c1f[_0x6063('0x31')],_0x5a8122[_0x6063('0x3c')]),_0x12b521);if(_0x5c7c1f[_0x6063('0x31')]['filter']){_0x67e1ba['where']=_[_0x6063('0x3d')](_0x67e1ba[_0x6063('0x3e')],{'$or':_[_0x6063('0x30')](_0x12b521,function(_0x5b45bb){if(_0x5b45bb[_0x6063('0x3f')]!==_0x6063('0x40')){var _0x4b854a={};_0x4b854a[_0x5b45bb[_0x6063('0x2b')]]={'$like':'%'+_0x5c7c1f['query'][_0x6063('0x41')]+'%'};return _0x4b854a;}})});}_0x67e1ba=_[_0x6063('0x3d')]({},_0x67e1ba,_0x5c7c1f[_0x6063('0x42')]);var _0x47e8a6={'where':_0x67e1ba[_0x6063('0x3e')]};return db[_0x6063('0x43')][_0x6063('0x1f')](_0x47e8a6)[_0x6063('0x28')](function(_0x528cc0){_0x50f439['count']=_0x528cc0;if(_0x5c7c1f['query']['includeAll']){_0x67e1ba[_0x6063('0x44')]=[{'all':!![]}];}return db[_0x6063('0x43')][_0x6063('0x45')](_0x67e1ba);})['then'](function(_0x4f423e){_0x50f439[_0x6063('0x46')]=_0x4f423e;return _0x50f439;})[_0x6063('0x28')](respondWithFilteredResult(_0x5089cb,_0x67e1ba))[_0x6063('0x47')](handleError(_0x5089cb,null));};exports['show']=function(_0xf0a7e,_0x5d7e87){var _0x514a09={'raw':![],'where':{'id':_0xf0a7e[_0x6063('0x48')]['id']}},_0x13dc89={};_0x13dc89[_0x6063('0x2f')]=_[_0x6063('0x32')](db['AnalyticFieldReport'][_0x6063('0x49')]);_0x13dc89[_0x6063('0x31')]=_[_0x6063('0x32')](_0xf0a7e[_0x6063('0x31')]);_0x13dc89[_0x6063('0x3c')]=_[_0x6063('0x34')](_0x13dc89[_0x6063('0x2f')],_0x13dc89['query']);_0x514a09[_0x6063('0x33')]=_[_0x6063('0x34')](_0x13dc89['model'],qs['fields'](_0xf0a7e[_0x6063('0x31')][_0x6063('0x35')]));_0x514a09[_0x6063('0x33')]=_0x514a09[_0x6063('0x33')]['length']?_0x514a09[_0x6063('0x33')]:_0x13dc89[_0x6063('0x2f')];if(_0xf0a7e[_0x6063('0x31')][_0x6063('0x4a')]){_0x514a09[_0x6063('0x44')]=[{'all':!![]}];}_0x514a09=_['merge']({},_0x514a09,_0xf0a7e[_0x6063('0x42')]);return db['AnalyticFieldReport'][_0x6063('0x4b')](_0x514a09)[_0x6063('0x28')](handleEntityNotFound(_0x5d7e87,null))[_0x6063('0x28')](respondWithResult(_0x5d7e87,null))[_0x6063('0x47')](handleError(_0x5d7e87,null));};exports['create']=function(_0x2ab3e1,_0x19cd29){return db['AnalyticFieldReport'][_0x6063('0x4c')](_0x2ab3e1[_0x6063('0x4d')],{})[_0x6063('0x28')](respondWithResult(_0x19cd29,0xc9))[_0x6063('0x47')](handleError(_0x19cd29,null));};exports[_0x6063('0x4e')]=function(_0x1baf55,_0x57b987){return db[_0x6063('0x43')]['bulkCreate'](_0x1baf55[_0x6063('0x4d')],{'raw':![],'individualHooks':!![]})['then'](respondWithResult(_0x57b987,0xc9))[_0x6063('0x47')](handleError(_0x57b987,null));};exports[_0x6063('0x26')]=function(_0x2bb7a3,_0x5dff30){if(_0x2bb7a3['body']['id']){delete _0x2bb7a3[_0x6063('0x4d')]['id'];}return db['AnalyticFieldReport']['find']({'where':{'id':_0x2bb7a3[_0x6063('0x48')]['id']}})['then'](handleEntityNotFound(_0x5dff30,null))[_0x6063('0x28')](saveUpdates(_0x2bb7a3[_0x6063('0x4d')],null))[_0x6063('0x28')](respondWithResult(_0x5dff30,null))[_0x6063('0x47')](handleError(_0x5dff30,null));};exports['destroy']=function(_0xb1285d,_0x346960){return db[_0x6063('0x43')]['find']({'where':{'id':_0xb1285d[_0x6063('0x48')]['id']}})[_0x6063('0x28')](handleEntityNotFound(_0x346960,null))[_0x6063('0x28')](removeEntity(_0x346960,null))['catch'](handleError(_0x346960,null));};exports[_0x6063('0x4f')]=function(_0x1ca33a,_0x55b686){return db['AnalyticFieldReport'][_0x6063('0x27')]({'where':{'id':_0x1ca33a[_0x6063('0x31')][_0x6063('0x50')]||[]},'raw':![],'individualHooks':!![]})[_0x6063('0x28')](respondWithResult(_0x55b686,0xcc))[_0x6063('0x47')](handleError(_0x55b686,null));};exports[_0x6063('0x51')]=function(_0x3ffc3a,_0xa5b0df,_0x373a99){return db['AnalyticCustomReport'][_0x6063('0x52')]({'where':{'id':_0x3ffc3a['params']['id']}})[_0x6063('0x28')](handleEntityNotFound(_0xa5b0df,null))[_0x6063('0x28')](function(_0x17584d){if(_0x17584d){return db[_0x6063('0x53')][_0x6063('0x54')](function(_0x3636d5){return db['AnalyticFieldReport'][_0x6063('0x27')]({'where':{'CustomReportId':_0x3ffc3a[_0x6063('0x48')]['id']},'transaction':_0x3636d5})[_0x6063('0x28')](function(_0x2bdd63){var _0x273594=_['map'](_0x3ffc3a['body'],function(_0x5d0f1d){delete _0x5d0f1d['id'];_0x5d0f1d[_0x6063('0x55')]=_0x3ffc3a[_0x6063('0x48')]['id'];return _0x5d0f1d;});return db[_0x6063('0x43')][_0x6063('0x4e')](_0x273594,{'transaction':_0x3636d5});});})[_0x6063('0x28')](function(){return db[_0x6063('0x43')][_0x6063('0x45')]({'where':{'CustomReportId':_0x3ffc3a[_0x6063('0x48')]['id']}});});}})[_0x6063('0x28')](respondWithResult(_0xa5b0df,null))[_0x6063('0x47')](handleError(_0xa5b0df,null));};