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 _0xad42=['filter','includeAll','include','findAll','rows','show','params','options','catch','create','body','bulkCreate','find','bulkDestroy','destroy','ids','AnalyticCustomReport','findOne','sequelize','CustomReportId','eml-format','rimraf','zip-dir','request-promise','moment','mustache','util','path','fs-extra','lodash','squel','crypto','desk.js','to-csv','querystring','papaparse','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../config/environment','../../mysqldb','status','json','offset','limit','count','set','Content-Range','save','then','end','sendStatus','error','stack','name','send','index','map','AnalyticFieldReport','rawAttributes','fieldName','type','key','model','keys','query','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','filters','merge','VIRTUAL'];(function(_0x1e6878,_0x783f07){var _0x189e27=function(_0x1f784a){while(--_0x1f784a){_0x1e6878['push'](_0x1e6878['shift']());}};_0x189e27(++_0x783f07);}(_0xad42,0xb2));var _0x2ad4=function(_0x5b3737,_0x54a3e0){_0x5b3737=_0x5b3737-0x0;var _0x1e9b47=_0xad42[_0x5b3737];return _0x1e9b47;};'use strict';var emlformat=require(_0x2ad4('0x0'));var rimraf=require(_0x2ad4('0x1'));var zipdir=require(_0x2ad4('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x2ad4('0x3'));var moment=require(_0x2ad4('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x2ad4('0x5'));var util=require(_0x2ad4('0x6'));var path=require(_0x2ad4('0x7'));var sox=require('sox');var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x2ad4('0x8'));var _=require(_0x2ad4('0x9'));var squel=require(_0x2ad4('0xa'));var crypto=require(_0x2ad4('0xb'));var jsforce=require('jsforce');var deskjs=require(_0x2ad4('0xc'));var toCsv=require(_0x2ad4('0xd'));var querystring=require(_0x2ad4('0xe'));var Papa=require(_0x2ad4('0xf'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0x2ad4('0x10'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x2ad4('0x11'));var logger=require(_0x2ad4('0x12'))('api');var utils=require('../../config/utils');var config=require(_0x2ad4('0x13'));var licenseUtil=require('../../config/license/util');var db=require(_0x2ad4('0x14'))['db'];function respondWithStatusCode(_0x263c76,_0x33deb5){_0x33deb5=_0x33deb5||0xcc;return function(_0x1be770){if(_0x1be770){return _0x263c76['sendStatus'](_0x33deb5);}return _0x263c76['status'](_0x33deb5)['end']();};}function respondWithResult(_0x4be9b6,_0x37c72c){_0x37c72c=_0x37c72c||0xc8;return function(_0xbd6753){if(_0xbd6753){return _0x4be9b6[_0x2ad4('0x15')](_0x37c72c)[_0x2ad4('0x16')](_0xbd6753);}};}function respondWithFilteredResult(_0x33b4cd,_0x45b6fd){return function(_0x161d1f){if(_0x161d1f){var _0x22b0f4=typeof _0x45b6fd[_0x2ad4('0x17')]==='undefined'&&typeof _0x45b6fd[_0x2ad4('0x18')]==='undefined';var _0x3c9a20=_0x161d1f[_0x2ad4('0x19')];var _0x16f28b=_0x22b0f4?0x0:_0x45b6fd[_0x2ad4('0x17')];var _0x2dd15e=_0x22b0f4?_0x161d1f[_0x2ad4('0x19')]:_0x45b6fd[_0x2ad4('0x17')]+_0x45b6fd[_0x2ad4('0x18')];var _0x47dc0;if(_0x2dd15e>=_0x3c9a20){_0x2dd15e=_0x3c9a20;_0x47dc0=0xc8;}else{_0x47dc0=0xce;}_0x33b4cd[_0x2ad4('0x15')](_0x47dc0);return _0x33b4cd[_0x2ad4('0x1a')](_0x2ad4('0x1b'),_0x16f28b+'-'+_0x2dd15e+'/'+_0x3c9a20)[_0x2ad4('0x16')](_0x161d1f);}return null;};}function patchUpdates(_0x46add0){return function(_0x2823fb){try{jsonpatch['apply'](_0x2823fb,_0x46add0,!![]);}catch(_0xeaa6e5){return BPromise['reject'](_0xeaa6e5);}return _0x2823fb[_0x2ad4('0x1c')]();};}function saveUpdates(_0x75f964,_0x34812c){return function(_0x300b18){if(_0x300b18){return _0x300b18['update'](_0x75f964)[_0x2ad4('0x1d')](function(_0x5ccd08){return _0x5ccd08;});}return null;};}function removeEntity(_0x401855,_0x1b4e9a){return function(_0x5e7630){if(_0x5e7630){return _0x5e7630['destroy']()[_0x2ad4('0x1d')](function(){_0x401855[_0x2ad4('0x15')](0xcc)[_0x2ad4('0x1e')]();});}};}function handleEntityNotFound(_0x2a22b2,_0x7c2aae){return function(_0x517ed2){if(!_0x517ed2){_0x2a22b2[_0x2ad4('0x1f')](0x194);}return _0x517ed2;};}function handleError(_0x2a9350,_0x161ca1){_0x161ca1=_0x161ca1||0x1f4;return function(_0x2220f5){logger[_0x2ad4('0x20')](_0x2220f5[_0x2ad4('0x21')]);if(_0x2220f5[_0x2ad4('0x22')]){delete _0x2220f5[_0x2ad4('0x22')];}_0x2a9350[_0x2ad4('0x15')](_0x161ca1)[_0x2ad4('0x23')](_0x2220f5);};}exports[_0x2ad4('0x24')]=function(_0x3c7277,_0x468334){var _0x37323f={},_0x1075ce={},_0x26dcc7={'count':0x0,'rows':[]};var _0x26d4f4=_[_0x2ad4('0x25')](db[_0x2ad4('0x26')][_0x2ad4('0x27')],function(_0x1f1c67){return{'name':_0x1f1c67[_0x2ad4('0x28')],'type':_0x1f1c67[_0x2ad4('0x29')][_0x2ad4('0x2a')]};});_0x1075ce[_0x2ad4('0x2b')]=_[_0x2ad4('0x25')](_0x26d4f4,_0x2ad4('0x22'));_0x1075ce['query']=_[_0x2ad4('0x2c')](_0x3c7277[_0x2ad4('0x2d')]);_0x1075ce['filters']=_[_0x2ad4('0x2e')](_0x1075ce[_0x2ad4('0x2b')],_0x1075ce[_0x2ad4('0x2d')]);_0x37323f['attributes']=_[_0x2ad4('0x2e')](_0x1075ce[_0x2ad4('0x2b')],qs['fields'](_0x3c7277['query'][_0x2ad4('0x2f')]));_0x37323f[_0x2ad4('0x30')]=_0x37323f[_0x2ad4('0x30')][_0x2ad4('0x31')]?_0x37323f['attributes']:_0x1075ce[_0x2ad4('0x2b')];if(!_0x3c7277['query'][_0x2ad4('0x32')](_0x2ad4('0x33'))){_0x37323f['limit']=qs['limit'](_0x3c7277[_0x2ad4('0x2d')][_0x2ad4('0x18')]);_0x37323f['offset']=qs['offset'](_0x3c7277['query'][_0x2ad4('0x17')]);}_0x37323f[_0x2ad4('0x34')]=qs[_0x2ad4('0x35')](_0x3c7277[_0x2ad4('0x2d')][_0x2ad4('0x35')]);_0x37323f[_0x2ad4('0x36')]=qs['filters'](_[_0x2ad4('0x37')](_0x3c7277[_0x2ad4('0x2d')],_0x1075ce[_0x2ad4('0x38')]),_0x26d4f4);if(_0x3c7277[_0x2ad4('0x2d')]['filter']){_0x37323f[_0x2ad4('0x36')]=_[_0x2ad4('0x39')](_0x37323f[_0x2ad4('0x36')],{'$or':_[_0x2ad4('0x25')](_0x26d4f4,function(_0x449db9){if(_0x449db9[_0x2ad4('0x29')]!==_0x2ad4('0x3a')){var _0x5e8c8a={};_0x5e8c8a[_0x449db9[_0x2ad4('0x22')]]={'$like':'%'+_0x3c7277[_0x2ad4('0x2d')][_0x2ad4('0x3b')]+'%'};return _0x5e8c8a;}})});}_0x37323f=_[_0x2ad4('0x39')]({},_0x37323f,_0x3c7277['options']);var _0x5c8d4e={'where':_0x37323f[_0x2ad4('0x36')]};return db['AnalyticFieldReport'][_0x2ad4('0x19')](_0x5c8d4e)[_0x2ad4('0x1d')](function(_0x56d33a){_0x26dcc7[_0x2ad4('0x19')]=_0x56d33a;if(_0x3c7277[_0x2ad4('0x2d')][_0x2ad4('0x3c')]){_0x37323f[_0x2ad4('0x3d')]=[{'all':!![]}];}return db[_0x2ad4('0x26')][_0x2ad4('0x3e')](_0x37323f);})[_0x2ad4('0x1d')](function(_0x146f9d){_0x26dcc7[_0x2ad4('0x3f')]=_0x146f9d;return _0x26dcc7;})['then'](respondWithFilteredResult(_0x468334,_0x37323f))['catch'](handleError(_0x468334,null));};exports[_0x2ad4('0x40')]=function(_0x49d889,_0x564abd){var _0x5a2059={'raw':![],'where':{'id':_0x49d889[_0x2ad4('0x41')]['id']}},_0x598c24={};_0x598c24[_0x2ad4('0x2b')]=_['keys'](db[_0x2ad4('0x26')][_0x2ad4('0x27')]);_0x598c24['query']=_[_0x2ad4('0x2c')](_0x49d889[_0x2ad4('0x2d')]);_0x598c24['filters']=_[_0x2ad4('0x2e')](_0x598c24[_0x2ad4('0x2b')],_0x598c24['query']);_0x5a2059[_0x2ad4('0x30')]=_[_0x2ad4('0x2e')](_0x598c24['model'],qs['fields'](_0x49d889['query'][_0x2ad4('0x2f')]));_0x5a2059['attributes']=_0x5a2059[_0x2ad4('0x30')]['length']?_0x5a2059['attributes']:_0x598c24[_0x2ad4('0x2b')];if(_0x49d889[_0x2ad4('0x2d')][_0x2ad4('0x3c')]){_0x5a2059[_0x2ad4('0x3d')]=[{'all':!![]}];}_0x5a2059=_[_0x2ad4('0x39')]({},_0x5a2059,_0x49d889[_0x2ad4('0x42')]);return db[_0x2ad4('0x26')]['find'](_0x5a2059)[_0x2ad4('0x1d')](handleEntityNotFound(_0x564abd,null))['then'](respondWithResult(_0x564abd,null))[_0x2ad4('0x43')](handleError(_0x564abd,null));};exports[_0x2ad4('0x44')]=function(_0x185d6c,_0x336eac){return db[_0x2ad4('0x26')][_0x2ad4('0x44')](_0x185d6c[_0x2ad4('0x45')],{})[_0x2ad4('0x1d')](respondWithResult(_0x336eac,0xc9))[_0x2ad4('0x43')](handleError(_0x336eac,null));};exports[_0x2ad4('0x46')]=function(_0x151721,_0x4c6cff){return db[_0x2ad4('0x26')][_0x2ad4('0x46')](_0x151721[_0x2ad4('0x45')],{'raw':![],'individualHooks':!![]})[_0x2ad4('0x1d')](respondWithResult(_0x4c6cff,0xc9))[_0x2ad4('0x43')](handleError(_0x4c6cff,null));};exports['update']=function(_0x52287a,_0x36abb6){if(_0x52287a[_0x2ad4('0x45')]['id']){delete _0x52287a['body']['id'];}return db['AnalyticFieldReport'][_0x2ad4('0x47')]({'where':{'id':_0x52287a['params']['id']}})[_0x2ad4('0x1d')](handleEntityNotFound(_0x36abb6,null))[_0x2ad4('0x1d')](saveUpdates(_0x52287a[_0x2ad4('0x45')],null))[_0x2ad4('0x1d')](respondWithResult(_0x36abb6,null))[_0x2ad4('0x43')](handleError(_0x36abb6,null));};exports['destroy']=function(_0x268798,_0x5552d3){return db[_0x2ad4('0x26')][_0x2ad4('0x47')]({'where':{'id':_0x268798[_0x2ad4('0x41')]['id']}})[_0x2ad4('0x1d')](handleEntityNotFound(_0x5552d3,null))['then'](removeEntity(_0x5552d3,null))[_0x2ad4('0x43')](handleError(_0x5552d3,null));};exports[_0x2ad4('0x48')]=function(_0x4b7d02,_0x46c9a6){return db[_0x2ad4('0x26')][_0x2ad4('0x49')]({'where':{'id':_0x4b7d02[_0x2ad4('0x2d')][_0x2ad4('0x4a')]||[]},'raw':![],'individualHooks':!![]})['then'](respondWithResult(_0x46c9a6,0xcc))['catch'](handleError(_0x46c9a6,null));};exports['addFields']=function(_0x5bfcf6,_0xbe00f8,_0x1cda72){return db[_0x2ad4('0x4b')][_0x2ad4('0x4c')]({'where':{'id':_0x5bfcf6[_0x2ad4('0x41')]['id']}})['then'](handleEntityNotFound(_0xbe00f8,null))[_0x2ad4('0x1d')](function(_0x1463f8){if(_0x1463f8){return db[_0x2ad4('0x4d')]['transaction'](function(_0x21b6ed){return db['AnalyticFieldReport'][_0x2ad4('0x49')]({'where':{'CustomReportId':_0x5bfcf6['params']['id']},'transaction':_0x21b6ed})['then'](function(_0x544551){var _0x3b2105=_[_0x2ad4('0x25')](_0x5bfcf6[_0x2ad4('0x45')],function(_0xf92d4){delete _0xf92d4['id'];_0xf92d4[_0x2ad4('0x4e')]=_0x5bfcf6['params']['id'];return _0xf92d4;});return db[_0x2ad4('0x26')][_0x2ad4('0x46')](_0x3b2105,{'transaction':_0x21b6ed});});})[_0x2ad4('0x1d')](function(){return db[_0x2ad4('0x26')][_0x2ad4('0x3e')]({'where':{'CustomReportId':_0x5bfcf6[_0x2ad4('0x41')]['id']}});});}})[_0x2ad4('0x1d')](respondWithResult(_0xbe00f8,null))['catch'](handleError(_0xbe00f8,null));};