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 _0xd808=['map','AnalyticFieldReport','fieldName','type','key','model','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','VIRTUAL','options','includeAll','include','rows','catch','show','params','rawAttributes','keys','find','create','bulkCreate','body','destroy','bulkDestroy','ids','findOne','sequelize','transaction','findAll','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','path','sox','fs-extra','lodash','squel','crypto','desk.js','to-csv','papaparse','../../config/logger','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','undefined','limit','count','offset','set','Content-Range','apply','reject','save','update','then','stack','name','send','index'];(function(_0x1e896c,_0x3f9948){var _0xd149d9=function(_0x3281e5){while(--_0x3281e5){_0x1e896c['push'](_0x1e896c['shift']());}};_0xd149d9(++_0x3f9948);}(_0xd808,0x1b4));var _0x8d80=function(_0x2dc96f,_0x459058){_0x2dc96f=_0x2dc96f-0x0;var _0xd012da=_0xd808[_0x2dc96f];return _0xd012da;};'use strict';var emlformat=require(_0x8d80('0x0'));var rimraf=require(_0x8d80('0x1'));var zipdir=require(_0x8d80('0x2'));var jsonpatch=require(_0x8d80('0x3'));var rp=require(_0x8d80('0x4'));var moment=require('moment');var BPromise=require(_0x8d80('0x5'));var Mustache=require(_0x8d80('0x6'));var util=require('util');var path=require(_0x8d80('0x7'));var sox=require(_0x8d80('0x8'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x8d80('0x9'));var _=require(_0x8d80('0xa'));var squel=require(_0x8d80('0xb'));var crypto=require(_0x8d80('0xc'));var jsforce=require('jsforce');var deskjs=require(_0x8d80('0xd'));var toCsv=require(_0x8d80('0xe'));var querystring=require('querystring');var Papa=require(_0x8d80('0xf'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x8d80('0x10'))('api');var utils=require('../../config/utils');var config=require(_0x8d80('0x11'));var licenseUtil=require(_0x8d80('0x12'));var db=require(_0x8d80('0x13'))['db'];function respondWithStatusCode(_0x1e768a,_0x2d190d){_0x2d190d=_0x2d190d||0xcc;return function(_0x49fb74){if(_0x49fb74){return _0x1e768a[_0x8d80('0x14')](_0x2d190d);}return _0x1e768a[_0x8d80('0x15')](_0x2d190d)[_0x8d80('0x16')]();};}function respondWithResult(_0xccf71c,_0x409b13){_0x409b13=_0x409b13||0xc8;return function(_0x41b49e){if(_0x41b49e){return _0xccf71c[_0x8d80('0x15')](_0x409b13)['json'](_0x41b49e);}};}function respondWithFilteredResult(_0x1f44af,_0x562666){return function(_0x58d121){if(_0x58d121){var _0x1aebec=typeof _0x562666['offset']===_0x8d80('0x17')&&typeof _0x562666[_0x8d80('0x18')]===_0x8d80('0x17');var _0x4cff06=_0x58d121[_0x8d80('0x19')];var _0x5b60c4=_0x1aebec?0x0:_0x562666[_0x8d80('0x1a')];var _0x170865=_0x1aebec?_0x58d121['count']:_0x562666['offset']+_0x562666[_0x8d80('0x18')];var _0x4d56c2;if(_0x170865>=_0x4cff06){_0x170865=_0x4cff06;_0x4d56c2=0xc8;}else{_0x4d56c2=0xce;}_0x1f44af[_0x8d80('0x15')](_0x4d56c2);return _0x1f44af[_0x8d80('0x1b')](_0x8d80('0x1c'),_0x5b60c4+'-'+_0x170865+'/'+_0x4cff06)['json'](_0x58d121);}return null;};}function patchUpdates(_0x67d68){return function(_0x5a2dd5){try{jsonpatch[_0x8d80('0x1d')](_0x5a2dd5,_0x67d68,!![]);}catch(_0x139f30){return BPromise[_0x8d80('0x1e')](_0x139f30);}return _0x5a2dd5[_0x8d80('0x1f')]();};}function saveUpdates(_0x34ac8c,_0x42420d){return function(_0x5eddc0){if(_0x5eddc0){return _0x5eddc0[_0x8d80('0x20')](_0x34ac8c)['then'](function(_0x4e1a8b){return _0x4e1a8b;});}return null;};}function removeEntity(_0x526223,_0x477f5a){return function(_0x24ea66){if(_0x24ea66){return _0x24ea66['destroy']()[_0x8d80('0x21')](function(){_0x526223[_0x8d80('0x15')](0xcc)['end']();});}};}function handleEntityNotFound(_0x4126d9,_0x20a804){return function(_0x128ffa){if(!_0x128ffa){_0x4126d9[_0x8d80('0x14')](0x194);}return _0x128ffa;};}function handleError(_0x1a2d4e,_0x9c57b3){_0x9c57b3=_0x9c57b3||0x1f4;return function(_0x5836ba){logger['error'](_0x5836ba[_0x8d80('0x22')]);if(_0x5836ba[_0x8d80('0x23')]){delete _0x5836ba['name'];}_0x1a2d4e[_0x8d80('0x15')](_0x9c57b3)[_0x8d80('0x24')](_0x5836ba);};}exports[_0x8d80('0x25')]=function(_0x46c6d4,_0x4edaec){var _0x353fed={},_0x153e31={},_0x443a78={'count':0x0,'rows':[]};var _0x1d0f37=_[_0x8d80('0x26')](db[_0x8d80('0x27')]['rawAttributes'],function(_0x460c1d){return{'name':_0x460c1d[_0x8d80('0x28')],'type':_0x460c1d[_0x8d80('0x29')][_0x8d80('0x2a')]};});_0x153e31[_0x8d80('0x2b')]=_[_0x8d80('0x26')](_0x1d0f37,'name');_0x153e31[_0x8d80('0x2c')]=_['keys'](_0x46c6d4[_0x8d80('0x2c')]);_0x153e31[_0x8d80('0x2d')]=_[_0x8d80('0x2e')](_0x153e31['model'],_0x153e31[_0x8d80('0x2c')]);_0x353fed[_0x8d80('0x2f')]=_[_0x8d80('0x2e')](_0x153e31['model'],qs[_0x8d80('0x30')](_0x46c6d4[_0x8d80('0x2c')][_0x8d80('0x30')]));_0x353fed[_0x8d80('0x2f')]=_0x353fed['attributes'][_0x8d80('0x31')]?_0x353fed[_0x8d80('0x2f')]:_0x153e31['model'];if(!_0x46c6d4[_0x8d80('0x2c')][_0x8d80('0x32')](_0x8d80('0x33'))){_0x353fed[_0x8d80('0x18')]=qs[_0x8d80('0x18')](_0x46c6d4['query'][_0x8d80('0x18')]);_0x353fed[_0x8d80('0x1a')]=qs[_0x8d80('0x1a')](_0x46c6d4['query']['offset']);}_0x353fed[_0x8d80('0x34')]=qs[_0x8d80('0x35')](_0x46c6d4['query'][_0x8d80('0x35')]);_0x353fed['where']=qs[_0x8d80('0x2d')](_[_0x8d80('0x36')](_0x46c6d4[_0x8d80('0x2c')],_0x153e31[_0x8d80('0x2d')]),_0x1d0f37);if(_0x46c6d4['query'][_0x8d80('0x37')]){_0x353fed[_0x8d80('0x38')]=_[_0x8d80('0x39')](_0x353fed[_0x8d80('0x38')],{'$or':_[_0x8d80('0x26')](_0x1d0f37,function(_0x2b4790){if(_0x2b4790['type']!==_0x8d80('0x3a')){var _0x186b5={};_0x186b5[_0x2b4790['name']]={'$like':'%'+_0x46c6d4[_0x8d80('0x2c')][_0x8d80('0x37')]+'%'};return _0x186b5;}})});}_0x353fed=_[_0x8d80('0x39')]({},_0x353fed,_0x46c6d4[_0x8d80('0x3b')]);var _0x318192={'where':_0x353fed[_0x8d80('0x38')]};return db['AnalyticFieldReport'][_0x8d80('0x19')](_0x318192)[_0x8d80('0x21')](function(_0x571110){_0x443a78['count']=_0x571110;if(_0x46c6d4[_0x8d80('0x2c')][_0x8d80('0x3c')]){_0x353fed[_0x8d80('0x3d')]=[{'all':!![]}];}return db[_0x8d80('0x27')]['findAll'](_0x353fed);})[_0x8d80('0x21')](function(_0x547df7){_0x443a78[_0x8d80('0x3e')]=_0x547df7;return _0x443a78;})[_0x8d80('0x21')](respondWithFilteredResult(_0x4edaec,_0x353fed))[_0x8d80('0x3f')](handleError(_0x4edaec,null));};exports[_0x8d80('0x40')]=function(_0x4dc371,_0x551623){var _0xda17e2={'raw':![],'where':{'id':_0x4dc371[_0x8d80('0x41')]['id']}},_0x333a81={};_0x333a81[_0x8d80('0x2b')]=_['keys'](db[_0x8d80('0x27')][_0x8d80('0x42')]);_0x333a81[_0x8d80('0x2c')]=_[_0x8d80('0x43')](_0x4dc371[_0x8d80('0x2c')]);_0x333a81[_0x8d80('0x2d')]=_[_0x8d80('0x2e')](_0x333a81['model'],_0x333a81['query']);_0xda17e2[_0x8d80('0x2f')]=_[_0x8d80('0x2e')](_0x333a81['model'],qs[_0x8d80('0x30')](_0x4dc371[_0x8d80('0x2c')][_0x8d80('0x30')]));_0xda17e2[_0x8d80('0x2f')]=_0xda17e2['attributes']['length']?_0xda17e2[_0x8d80('0x2f')]:_0x333a81['model'];if(_0x4dc371[_0x8d80('0x2c')][_0x8d80('0x3c')]){_0xda17e2[_0x8d80('0x3d')]=[{'all':!![]}];}_0xda17e2=_[_0x8d80('0x39')]({},_0xda17e2,_0x4dc371['options']);return db[_0x8d80('0x27')][_0x8d80('0x44')](_0xda17e2)[_0x8d80('0x21')](handleEntityNotFound(_0x551623,null))[_0x8d80('0x21')](respondWithResult(_0x551623,null))[_0x8d80('0x3f')](handleError(_0x551623,null));};exports[_0x8d80('0x45')]=function(_0x5c27d5,_0x3e5fcf){return db[_0x8d80('0x27')][_0x8d80('0x45')](_0x5c27d5['body'],{})[_0x8d80('0x21')](respondWithResult(_0x3e5fcf,0xc9))[_0x8d80('0x3f')](handleError(_0x3e5fcf,null));};exports[_0x8d80('0x46')]=function(_0x34ca31,_0x51f3c3){return db[_0x8d80('0x27')]['bulkCreate'](_0x34ca31[_0x8d80('0x47')],{'raw':![],'individualHooks':!![]})[_0x8d80('0x21')](respondWithResult(_0x51f3c3,0xc9))[_0x8d80('0x3f')](handleError(_0x51f3c3,null));};exports[_0x8d80('0x20')]=function(_0x554508,_0x422030){if(_0x554508[_0x8d80('0x47')]['id']){delete _0x554508[_0x8d80('0x47')]['id'];}return db[_0x8d80('0x27')][_0x8d80('0x44')]({'where':{'id':_0x554508[_0x8d80('0x41')]['id']}})[_0x8d80('0x21')](handleEntityNotFound(_0x422030,null))[_0x8d80('0x21')](saveUpdates(_0x554508['body'],null))[_0x8d80('0x21')](respondWithResult(_0x422030,null))[_0x8d80('0x3f')](handleError(_0x422030,null));};exports[_0x8d80('0x48')]=function(_0x1c86dc,_0x37a869){return db[_0x8d80('0x27')][_0x8d80('0x44')]({'where':{'id':_0x1c86dc[_0x8d80('0x41')]['id']}})[_0x8d80('0x21')](handleEntityNotFound(_0x37a869,null))[_0x8d80('0x21')](removeEntity(_0x37a869,null))[_0x8d80('0x3f')](handleError(_0x37a869,null));};exports[_0x8d80('0x49')]=function(_0x28f72c,_0x4cbb19){return db['AnalyticFieldReport'][_0x8d80('0x48')]({'where':{'id':_0x28f72c['query'][_0x8d80('0x4a')]||[]},'raw':![],'individualHooks':!![]})[_0x8d80('0x21')](respondWithResult(_0x4cbb19,0xcc))[_0x8d80('0x3f')](handleError(_0x4cbb19,null));};exports['addFields']=function(_0x29d852,_0x2e4272,_0x144617){return db['AnalyticCustomReport'][_0x8d80('0x4b')]({'where':{'id':_0x29d852['params']['id']}})[_0x8d80('0x21')](handleEntityNotFound(_0x2e4272,null))['then'](function(_0x2ddda4){if(_0x2ddda4){return db[_0x8d80('0x4c')][_0x8d80('0x4d')](function(_0x6ef0fb){return db[_0x8d80('0x27')][_0x8d80('0x48')]({'where':{'CustomReportId':_0x29d852[_0x8d80('0x41')]['id']},'transaction':_0x6ef0fb})['then'](function(_0x37c26c){var _0x21108f=_['map'](_0x29d852[_0x8d80('0x47')],function(_0x29cdf3){delete _0x29cdf3['id'];_0x29cdf3['CustomReportId']=_0x29d852[_0x8d80('0x41')]['id'];return _0x29cdf3;});return db[_0x8d80('0x27')][_0x8d80('0x46')](_0x21108f,{'transaction':_0x6ef0fb});});})[_0x8d80('0x21')](function(){return db[_0x8d80('0x27')][_0x8d80('0x4e')]({'where':{'CustomReportId':_0x29d852[_0x8d80('0x41')]['id']}});});}})[_0x8d80('0x21')](respondWithResult(_0x2e4272,null))[_0x8d80('0x3f')](handleError(_0x2e4272,null));};