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 _0x9988=['undefined','limit','count','set','json','apply','save','update','then','destroy','error','stack','name','send','index','map','AnalyticFieldReport','rawAttributes','fieldName','type','key','model','query','keys','intersection','attributes','fields','length','hasOwnProperty','sort','filters','filter','where','merge','options','includeAll','include','findAll','rows','catch','params','find','create','body','bulkCreate','bulkDestroy','ids','findOne','rimraf','zip-dir','moment','bluebird','util','path','sox','to-csv','ejs','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','offset'];(function(_0x3c27fb,_0x2d2608){var _0x3f8b5d=function(_0x40ae85){while(--_0x40ae85){_0x3c27fb['push'](_0x3c27fb['shift']());}};_0x3f8b5d(++_0x2d2608);}(_0x9988,0x160));var _0x8998=function(_0x3c7869,_0x207240){_0x3c7869=_0x3c7869-0x0;var _0x23bc0b=_0x9988[_0x3c7869];return _0x23bc0b;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x8998('0x0'));var zipdir=require(_0x8998('0x1'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0x8998('0x2'));var BPromise=require(_0x8998('0x3'));var Mustache=require('mustache');var util=require(_0x8998('0x4'));var path=require(_0x8998('0x5'));var sox=require(_0x8998('0x6'));var csv=require(_0x8998('0x7'));var ejs=require(_0x8998('0x8'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x8998('0x9'));var squel=require(_0x8998('0xa'));var crypto=require('crypto');var jsforce=require(_0x8998('0xb'));var deskjs=require(_0x8998('0xc'));var toCsv=require(_0x8998('0x7'));var querystring=require(_0x8998('0xd'));var Papa=require(_0x8998('0xe'));var Redis=require(_0x8998('0xf'));var authService=require('../../components/auth/service');var qs=require(_0x8998('0x10'));var as=require(_0x8998('0x11'));var hardwareService=require(_0x8998('0x12'));var logger=require(_0x8998('0x13'))('api');var utils=require(_0x8998('0x14'));var config=require(_0x8998('0x15'));var licenseUtil=require(_0x8998('0x16'));var db=require(_0x8998('0x17'))['db'];function respondWithStatusCode(_0x5dce16,_0x4b3b03){_0x4b3b03=_0x4b3b03||0xcc;return function(_0x44ef69){if(_0x44ef69){return _0x5dce16[_0x8998('0x18')](_0x4b3b03);}return _0x5dce16[_0x8998('0x19')](_0x4b3b03)[_0x8998('0x1a')]();};}function respondWithResult(_0x4d4ce4,_0x1ac445){_0x1ac445=_0x1ac445||0xc8;return function(_0x4aeac0){if(_0x4aeac0){return _0x4d4ce4[_0x8998('0x19')](_0x1ac445)['json'](_0x4aeac0);}};}function respondWithFilteredResult(_0x82d1f,_0x176e45){return function(_0x554953){if(_0x554953){var _0x14887e=typeof _0x176e45[_0x8998('0x1b')]===_0x8998('0x1c')&&typeof _0x176e45[_0x8998('0x1d')]===_0x8998('0x1c');var _0x3bfa94=_0x554953[_0x8998('0x1e')];var _0x3adc32=_0x14887e?0x0:_0x176e45[_0x8998('0x1b')];var _0x1bd6ab=_0x14887e?_0x554953[_0x8998('0x1e')]:_0x176e45['offset']+_0x176e45[_0x8998('0x1d')];var _0x1d869f;if(_0x1bd6ab>=_0x3bfa94){_0x1bd6ab=_0x3bfa94;_0x1d869f=0xc8;}else{_0x1d869f=0xce;}_0x82d1f[_0x8998('0x19')](_0x1d869f);return _0x82d1f[_0x8998('0x1f')]('Content-Range',_0x3adc32+'-'+_0x1bd6ab+'/'+_0x3bfa94)[_0x8998('0x20')](_0x554953);}return null;};}function patchUpdates(_0x775148){return function(_0x504f85){try{jsonpatch[_0x8998('0x21')](_0x504f85,_0x775148,!![]);}catch(_0x5b8e4c){return BPromise['reject'](_0x5b8e4c);}return _0x504f85[_0x8998('0x22')]();};}function saveUpdates(_0x59ba71,_0x26495f){return function(_0x36af6d){if(_0x36af6d){return _0x36af6d[_0x8998('0x23')](_0x59ba71)[_0x8998('0x24')](function(_0x29151e){return _0x29151e;});}return null;};}function removeEntity(_0x143494,_0x126576){return function(_0x59cc43){if(_0x59cc43){return _0x59cc43[_0x8998('0x25')]()[_0x8998('0x24')](function(){_0x143494[_0x8998('0x19')](0xcc)['end']();});}};}function handleEntityNotFound(_0x299d28,_0x2918a4){return function(_0x206e92){if(!_0x206e92){_0x299d28[_0x8998('0x18')](0x194);}return _0x206e92;};}function handleError(_0x10607e,_0x2211c0){_0x2211c0=_0x2211c0||0x1f4;return function(_0x7a4340){logger[_0x8998('0x26')](_0x7a4340[_0x8998('0x27')]);if(_0x7a4340[_0x8998('0x28')]){delete _0x7a4340[_0x8998('0x28')];}_0x10607e['status'](_0x2211c0)[_0x8998('0x29')](_0x7a4340);};}exports[_0x8998('0x2a')]=function(_0x3172a8,_0x210599){var _0xbf2ada={},_0x56a9d5={},_0x3ef3d4={'count':0x0,'rows':[]};var _0x1a85a0=_[_0x8998('0x2b')](db[_0x8998('0x2c')][_0x8998('0x2d')],function(_0x10e755){return{'name':_0x10e755[_0x8998('0x2e')],'type':_0x10e755[_0x8998('0x2f')][_0x8998('0x30')]};});_0x56a9d5[_0x8998('0x31')]=_[_0x8998('0x2b')](_0x1a85a0,_0x8998('0x28'));_0x56a9d5[_0x8998('0x32')]=_[_0x8998('0x33')](_0x3172a8['query']);_0x56a9d5['filters']=_[_0x8998('0x34')](_0x56a9d5[_0x8998('0x31')],_0x56a9d5[_0x8998('0x32')]);_0xbf2ada[_0x8998('0x35')]=_[_0x8998('0x34')](_0x56a9d5['model'],qs[_0x8998('0x36')](_0x3172a8['query'][_0x8998('0x36')]));_0xbf2ada[_0x8998('0x35')]=_0xbf2ada[_0x8998('0x35')][_0x8998('0x37')]?_0xbf2ada['attributes']:_0x56a9d5[_0x8998('0x31')];if(!_0x3172a8[_0x8998('0x32')][_0x8998('0x38')]('nolimit')){_0xbf2ada[_0x8998('0x1d')]=qs[_0x8998('0x1d')](_0x3172a8['query']['limit']);_0xbf2ada['offset']=qs[_0x8998('0x1b')](_0x3172a8[_0x8998('0x32')][_0x8998('0x1b')]);}_0xbf2ada['order']=qs['sort'](_0x3172a8[_0x8998('0x32')][_0x8998('0x39')]);_0xbf2ada['where']=qs[_0x8998('0x3a')](_['pick'](_0x3172a8['query'],_0x56a9d5[_0x8998('0x3a')]),_0x1a85a0);if(_0x3172a8[_0x8998('0x32')][_0x8998('0x3b')]){_0xbf2ada[_0x8998('0x3c')]=_[_0x8998('0x3d')](_0xbf2ada[_0x8998('0x3c')],{'$or':_[_0x8998('0x2b')](_0x1a85a0,function(_0x180d46){if(_0x180d46[_0x8998('0x2f')]!=='VIRTUAL'){var _0x47211c={};_0x47211c[_0x180d46[_0x8998('0x28')]]={'$like':'%'+_0x3172a8[_0x8998('0x32')][_0x8998('0x3b')]+'%'};return _0x47211c;}})});}_0xbf2ada=_[_0x8998('0x3d')]({},_0xbf2ada,_0x3172a8[_0x8998('0x3e')]);var _0x2d6e83={'where':_0xbf2ada[_0x8998('0x3c')]};return db[_0x8998('0x2c')][_0x8998('0x1e')](_0x2d6e83)[_0x8998('0x24')](function(_0x35755f){_0x3ef3d4['count']=_0x35755f;if(_0x3172a8['query'][_0x8998('0x3f')]){_0xbf2ada[_0x8998('0x40')]=[{'all':!![]}];}return db[_0x8998('0x2c')][_0x8998('0x41')](_0xbf2ada);})[_0x8998('0x24')](function(_0x49e2b2){_0x3ef3d4[_0x8998('0x42')]=_0x49e2b2;return _0x3ef3d4;})[_0x8998('0x24')](respondWithFilteredResult(_0x210599,_0xbf2ada))[_0x8998('0x43')](handleError(_0x210599,null));};exports['show']=function(_0x197bac,_0x544989){var _0x4c0d2d={'raw':![],'where':{'id':_0x197bac[_0x8998('0x44')]['id']}},_0x46d631={};_0x46d631['model']=_[_0x8998('0x33')](db[_0x8998('0x2c')][_0x8998('0x2d')]);_0x46d631[_0x8998('0x32')]=_[_0x8998('0x33')](_0x197bac[_0x8998('0x32')]);_0x46d631[_0x8998('0x3a')]=_['intersection'](_0x46d631['model'],_0x46d631[_0x8998('0x32')]);_0x4c0d2d[_0x8998('0x35')]=_[_0x8998('0x34')](_0x46d631['model'],qs[_0x8998('0x36')](_0x197bac[_0x8998('0x32')]['fields']));_0x4c0d2d[_0x8998('0x35')]=_0x4c0d2d[_0x8998('0x35')]['length']?_0x4c0d2d['attributes']:_0x46d631['model'];if(_0x197bac[_0x8998('0x32')][_0x8998('0x3f')]){_0x4c0d2d[_0x8998('0x40')]=[{'all':!![]}];}_0x4c0d2d=_[_0x8998('0x3d')]({},_0x4c0d2d,_0x197bac['options']);return db[_0x8998('0x2c')][_0x8998('0x45')](_0x4c0d2d)['then'](handleEntityNotFound(_0x544989,null))[_0x8998('0x24')](respondWithResult(_0x544989,null))['catch'](handleError(_0x544989,null));};exports['create']=function(_0x4a1d84,_0x56a94b){return db[_0x8998('0x2c')][_0x8998('0x46')](_0x4a1d84[_0x8998('0x47')],{})[_0x8998('0x24')](respondWithResult(_0x56a94b,0xc9))[_0x8998('0x43')](handleError(_0x56a94b,null));};exports['bulkCreate']=function(_0x5853c8,_0x5d2974){return db['AnalyticFieldReport'][_0x8998('0x48')](_0x5853c8['body'],{'raw':![],'individualHooks':!![]})[_0x8998('0x24')](respondWithResult(_0x5d2974,0xc9))[_0x8998('0x43')](handleError(_0x5d2974,null));};exports['update']=function(_0x1cba5e,_0x406f03){if(_0x1cba5e['body']['id']){delete _0x1cba5e[_0x8998('0x47')]['id'];}return db[_0x8998('0x2c')][_0x8998('0x45')]({'where':{'id':_0x1cba5e[_0x8998('0x44')]['id']}})[_0x8998('0x24')](handleEntityNotFound(_0x406f03,null))[_0x8998('0x24')](saveUpdates(_0x1cba5e['body'],null))['then'](respondWithResult(_0x406f03,null))[_0x8998('0x43')](handleError(_0x406f03,null));};exports[_0x8998('0x25')]=function(_0x59cd26,_0x3817bc){return db[_0x8998('0x2c')][_0x8998('0x45')]({'where':{'id':_0x59cd26[_0x8998('0x44')]['id']}})[_0x8998('0x24')](handleEntityNotFound(_0x3817bc,null))[_0x8998('0x24')](removeEntity(_0x3817bc,null))[_0x8998('0x43')](handleError(_0x3817bc,null));};exports[_0x8998('0x49')]=function(_0x4ff9f6,_0x4a8594){return db[_0x8998('0x2c')][_0x8998('0x25')]({'where':{'id':_0x4ff9f6[_0x8998('0x32')][_0x8998('0x4a')]||[]},'raw':![],'individualHooks':!![]})[_0x8998('0x24')](respondWithResult(_0x4a8594,0xcc))['catch'](handleError(_0x4a8594,null));};exports['addFields']=function(_0x1d599c,_0x1b3f61,_0x16ab7f){return db['AnalyticCustomReport'][_0x8998('0x4b')]({'where':{'id':_0x1d599c[_0x8998('0x44')]['id']}})[_0x8998('0x24')](handleEntityNotFound(_0x1b3f61,null))[_0x8998('0x24')](function(_0x464524){if(_0x464524){return db['sequelize']['transaction'](function(_0x205bbf){return db['AnalyticFieldReport'][_0x8998('0x25')]({'where':{'CustomReportId':_0x1d599c[_0x8998('0x44')]['id']},'transaction':_0x205bbf})['then'](function(_0x344c28){var _0x36dad8=_[_0x8998('0x2b')](_0x1d599c[_0x8998('0x47')],function(_0x35418f){delete _0x35418f['id'];_0x35418f['CustomReportId']=_0x1d599c[_0x8998('0x44')]['id'];return _0x35418f;});return db[_0x8998('0x2c')][_0x8998('0x48')](_0x36dad8,{'transaction':_0x205bbf});});})['then'](function(){return db['AnalyticFieldReport']['findAll']({'where':{'CustomReportId':_0x1d599c['params']['id']}});});}})['then'](respondWithResult(_0x1b3f61,null))['catch'](handleError(_0x1b3f61,null));};