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 _0x7194=['merge','count','include','rows','catch','show','keys','AnalyticFieldReport','fields','includeAll','options','find','create','body','bulkCreate','destroy','params','bulkDestroy','ids','addFields','AnalyticCustomReport','findOne','sequelize','CustomReportId','html-pdf','rimraf','zip-dir','request-promise','moment','bluebird','mustache','path','sox','to-csv','ejs','lodash','squel','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','limit','Content-Range','apply','reject','save','update','then','error','stack','name','send','index','map','rawAttributes','fieldName','type','model','query','intersection','attributes','length','nolimit','order','sort','filters','filter','where'];(function(_0x3a4838,_0x5eb63c){var _0x10fc53=function(_0x23e650){while(--_0x23e650){_0x3a4838['push'](_0x3a4838['shift']());}};_0x10fc53(++_0x5eb63c);}(_0x7194,0x1ad));var _0x4719=function(_0x14add3,_0x13ce8d){_0x14add3=_0x14add3-0x0;var _0x4a174f=_0x7194[_0x14add3];return _0x4a174f;};'use strict';var pdf=require(_0x4719('0x0'));var emlformat=require('eml-format');var rimraf=require(_0x4719('0x1'));var zipdir=require(_0x4719('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x4719('0x3'));var moment=require(_0x4719('0x4'));var BPromise=require(_0x4719('0x5'));var Mustache=require(_0x4719('0x6'));var util=require('util');var path=require(_0x4719('0x7'));var sox=require(_0x4719('0x8'));var csv=require(_0x4719('0x9'));var ejs=require(_0x4719('0xa'));var fs=require('fs');var _=require(_0x4719('0xb'));var squel=require(_0x4719('0xc'));var crypto=require('crypto');var jsforce=require(_0x4719('0xd'));var deskjs=require(_0x4719('0xe'));var toCsv=require(_0x4719('0x9'));var querystring=require(_0x4719('0xf'));var Papa=require(_0x4719('0x10'));var Redis=require('ioredis');var authService=require(_0x4719('0x11'));var qs=require(_0x4719('0x12'));var as=require(_0x4719('0x13'));var hardwareService=require(_0x4719('0x14'));var logger=require('../../config/logger')(_0x4719('0x15'));var utils=require('../../config/utils');var config=require(_0x4719('0x16'));var licenseUtil=require(_0x4719('0x17'));var db=require(_0x4719('0x18'))['db'];function respondWithStatusCode(_0x51f2dd,_0x18e1bc){_0x18e1bc=_0x18e1bc||0xcc;return function(_0x5bca00){if(_0x5bca00){return _0x51f2dd[_0x4719('0x19')](_0x18e1bc);}return _0x51f2dd[_0x4719('0x1a')](_0x18e1bc)[_0x4719('0x1b')]();};}function respondWithResult(_0x4d13bb,_0x4f91ad){_0x4f91ad=_0x4f91ad||0xc8;return function(_0x15e706){if(_0x15e706){return _0x4d13bb['status'](_0x4f91ad)[_0x4719('0x1c')](_0x15e706);}};}function respondWithFilteredResult(_0x5f0428,_0x532656){return function(_0x3400c6){if(_0x3400c6){var _0xb1d88=_0x3400c6['count'],_0x413c81=_0x532656[_0x4719('0x1d')],_0x2c4477=_0x532656[_0x4719('0x1d')]+_0x532656[_0x4719('0x1e')],_0x1fdb55;if(_0x2c4477>=_0xb1d88){_0x2c4477=_0xb1d88;_0x1fdb55=0xc8;}else{_0x1fdb55=0xce;}_0x5f0428[_0x4719('0x1a')](_0x1fdb55);return _0x5f0428['set'](_0x4719('0x1f'),_0x413c81+'-'+_0x2c4477+'/'+_0xb1d88)[_0x4719('0x1c')](_0x3400c6);}return null;};}function patchUpdates(_0x1e301f){return function(_0x308ee4){try{jsonpatch[_0x4719('0x20')](_0x308ee4,_0x1e301f,!![]);}catch(_0x3c1a78){return BPromise[_0x4719('0x21')](_0x3c1a78);}return _0x308ee4[_0x4719('0x22')]();};}function saveUpdates(_0x1bae19,_0x2c3a29){return function(_0x242ce4){if(_0x242ce4){return _0x242ce4[_0x4719('0x23')](_0x1bae19)[_0x4719('0x24')](function(_0x5cff71){return _0x5cff71;});}return null;};}function removeEntity(_0x5e7f08,_0x2513d8){return function(_0x326ee0){if(_0x326ee0){return _0x326ee0['destroy']()[_0x4719('0x24')](function(){_0x5e7f08['status'](0xcc)[_0x4719('0x1b')]();});}};}function handleEntityNotFound(_0x5135e2,_0x3ced3a){return function(_0x2f402b){if(!_0x2f402b){_0x5135e2[_0x4719('0x19')](0x194);}return _0x2f402b;};}function handleError(_0x47d958,_0x45c9b2){_0x45c9b2=_0x45c9b2||0x1f4;return function(_0xfc8f5e){logger[_0x4719('0x25')](_0xfc8f5e[_0x4719('0x26')]);if(_0xfc8f5e[_0x4719('0x27')]){delete _0xfc8f5e[_0x4719('0x27')];}_0x47d958[_0x4719('0x1a')](_0x45c9b2)[_0x4719('0x28')](_0xfc8f5e);};}exports[_0x4719('0x29')]=function(_0x2ec623,_0x1b6aee){var _0x294614={},_0x226f93={},_0x56cef6={'count':0x0,'rows':[]};var _0x15d866=_[_0x4719('0x2a')](db['AnalyticFieldReport'][_0x4719('0x2b')],function(_0x50bd47){return{'name':_0x50bd47[_0x4719('0x2c')],'type':_0x50bd47[_0x4719('0x2d')]['key']};});_0x226f93[_0x4719('0x2e')]=_[_0x4719('0x2a')](_0x15d866,_0x4719('0x27'));_0x226f93[_0x4719('0x2f')]=_['keys'](_0x2ec623[_0x4719('0x2f')]);_0x226f93['filters']=_[_0x4719('0x30')](_0x226f93['model'],_0x226f93['query']);_0x294614[_0x4719('0x31')]=_[_0x4719('0x30')](_0x226f93[_0x4719('0x2e')],qs['fields'](_0x2ec623[_0x4719('0x2f')]['fields']));_0x294614[_0x4719('0x31')]=_0x294614[_0x4719('0x31')][_0x4719('0x32')]?_0x294614[_0x4719('0x31')]:_0x226f93[_0x4719('0x2e')];if(!_0x2ec623[_0x4719('0x2f')]['hasOwnProperty'](_0x4719('0x33'))){_0x294614['limit']=qs['limit'](_0x2ec623['query'][_0x4719('0x1e')]);_0x294614['offset']=qs[_0x4719('0x1d')](_0x2ec623['query'][_0x4719('0x1d')]);}_0x294614[_0x4719('0x34')]=qs[_0x4719('0x35')](_0x2ec623[_0x4719('0x2f')][_0x4719('0x35')]);_0x294614['where']=qs[_0x4719('0x36')](_['pick'](_0x2ec623[_0x4719('0x2f')],_0x226f93['filters']),_0x15d866);if(_0x2ec623[_0x4719('0x2f')][_0x4719('0x37')]){_0x294614[_0x4719('0x38')]=_[_0x4719('0x39')](_0x294614[_0x4719('0x38')],{'$or':_[_0x4719('0x2a')](_0x15d866,function(_0x31d53d){if(_0x31d53d[_0x4719('0x2d')]!=='VIRTUAL'){var _0x20ca23={};_0x20ca23[_0x31d53d[_0x4719('0x27')]]={'$like':'%'+_0x2ec623[_0x4719('0x2f')][_0x4719('0x37')]+'%'};return _0x20ca23;}})});}_0x294614=_[_0x4719('0x39')]({},_0x294614,_0x2ec623['options']);var _0x2ce959={'where':_0x294614[_0x4719('0x38')]};return db['AnalyticFieldReport']['count'](_0x2ce959)[_0x4719('0x24')](function(_0x102f8f){_0x56cef6[_0x4719('0x3a')]=_0x102f8f;if(_0x2ec623[_0x4719('0x2f')]['includeAll']){_0x294614[_0x4719('0x3b')]=[{'all':!![]}];}return db['AnalyticFieldReport']['findAll'](_0x294614);})[_0x4719('0x24')](function(_0x1bf817){_0x56cef6[_0x4719('0x3c')]=_0x1bf817;return _0x56cef6;})[_0x4719('0x24')](respondWithFilteredResult(_0x1b6aee,_0x294614))[_0x4719('0x3d')](handleError(_0x1b6aee,null));};exports[_0x4719('0x3e')]=function(_0x596697,_0x34f002){var _0xf74d89={'raw':![],'where':{'id':_0x596697['params']['id']}},_0x366525={};_0x366525[_0x4719('0x2e')]=_[_0x4719('0x3f')](db[_0x4719('0x40')][_0x4719('0x2b')]);_0x366525[_0x4719('0x2f')]=_[_0x4719('0x3f')](_0x596697['query']);_0x366525['filters']=_['intersection'](_0x366525[_0x4719('0x2e')],_0x366525[_0x4719('0x2f')]);_0xf74d89[_0x4719('0x31')]=_[_0x4719('0x30')](_0x366525[_0x4719('0x2e')],qs[_0x4719('0x41')](_0x596697[_0x4719('0x2f')][_0x4719('0x41')]));_0xf74d89['attributes']=_0xf74d89[_0x4719('0x31')]['length']?_0xf74d89[_0x4719('0x31')]:_0x366525['model'];if(_0x596697[_0x4719('0x2f')][_0x4719('0x42')]){_0xf74d89[_0x4719('0x3b')]=[{'all':!![]}];}_0xf74d89=_[_0x4719('0x39')]({},_0xf74d89,_0x596697[_0x4719('0x43')]);return db['AnalyticFieldReport'][_0x4719('0x44')](_0xf74d89)[_0x4719('0x24')](handleEntityNotFound(_0x34f002,null))[_0x4719('0x24')](respondWithResult(_0x34f002,null))['catch'](handleError(_0x34f002,null));};exports[_0x4719('0x45')]=function(_0x132c40,_0x2c58fc){return db[_0x4719('0x40')]['create'](_0x132c40[_0x4719('0x46')],{})[_0x4719('0x24')](respondWithResult(_0x2c58fc,0xc9))[_0x4719('0x3d')](handleError(_0x2c58fc,null));};exports[_0x4719('0x47')]=function(_0x4cd063,_0x54835f){return db['AnalyticFieldReport'][_0x4719('0x47')](_0x4cd063[_0x4719('0x46')],{'raw':![],'individualHooks':!![]})['then'](respondWithResult(_0x54835f,0xc9))[_0x4719('0x3d')](handleError(_0x54835f,null));};exports[_0x4719('0x23')]=function(_0x5e3d2c,_0x2569f8){if(_0x5e3d2c[_0x4719('0x46')]['id']){delete _0x5e3d2c[_0x4719('0x46')]['id'];}return db[_0x4719('0x40')][_0x4719('0x44')]({'where':{'id':_0x5e3d2c['params']['id']}})[_0x4719('0x24')](handleEntityNotFound(_0x2569f8,null))[_0x4719('0x24')](saveUpdates(_0x5e3d2c[_0x4719('0x46')],null))['then'](respondWithResult(_0x2569f8,null))['catch'](handleError(_0x2569f8,null));};exports[_0x4719('0x48')]=function(_0x69daea,_0x4ab11e){return db[_0x4719('0x40')][_0x4719('0x44')]({'where':{'id':_0x69daea[_0x4719('0x49')]['id']}})[_0x4719('0x24')](handleEntityNotFound(_0x4ab11e,null))[_0x4719('0x24')](removeEntity(_0x4ab11e,null))[_0x4719('0x3d')](handleError(_0x4ab11e,null));};exports[_0x4719('0x4a')]=function(_0x3f5223,_0x40b1bb){return db['AnalyticFieldReport'][_0x4719('0x48')]({'where':{'id':_0x3f5223[_0x4719('0x2f')][_0x4719('0x4b')]||[]},'raw':![],'individualHooks':!![]})[_0x4719('0x24')](respondWithResult(_0x40b1bb,0xcc))['catch'](handleError(_0x40b1bb,null));};exports[_0x4719('0x4c')]=function(_0x154d5b,_0x332800,_0x28ba63){return db[_0x4719('0x4d')][_0x4719('0x4e')]({'where':{'id':_0x154d5b['params']['id']}})[_0x4719('0x24')](handleEntityNotFound(_0x332800,null))[_0x4719('0x24')](function(_0x1538e0){if(_0x1538e0){return db[_0x4719('0x4f')]['transaction'](function(_0xd892fe){return db[_0x4719('0x40')][_0x4719('0x48')]({'where':{'CustomReportId':_0x154d5b[_0x4719('0x49')]['id']},'transaction':_0xd892fe})['then'](function(_0x5df9ca){var _0x4475ca=_[_0x4719('0x2a')](_0x154d5b[_0x4719('0x46')],function(_0x439e40){delete _0x439e40['id'];_0x439e40[_0x4719('0x50')]=_0x154d5b[_0x4719('0x49')]['id'];return _0x439e40;});return db[_0x4719('0x40')][_0x4719('0x47')](_0x4475ca,{'transaction':_0xd892fe});});})[_0x4719('0x24')](function(){return db[_0x4719('0x40')]['findAll']({'where':{'CustomReportId':_0x154d5b[_0x4719('0x49')]['id']}});});}})[_0x4719('0x24')](respondWithResult(_0x332800,null))[_0x4719('0x3d')](handleError(_0x332800,null));};