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 _0xdf43=['lodash','squel','crypto','jsforce','desk.js','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','offset','undefined','limit','Content-Range','json','apply','reject','save','update','then','destroy','error','stack','name','index','map','AnalyticFieldReport','rawAttributes','fieldName','type','model','query','keys','filters','intersection','fields','attributes','length','nolimit','order','where','pick','filter','merge','VIRTUAL','options','count','includeAll','include','findAll','rows','catch','show','params','find','create','bulkCreate','body','bulkDestroy','ids','addFields','findOne','transaction','CustomReportId','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','sox','to-csv','ejs','fs-extra'];(function(_0x203319,_0x1f5d86){var _0x57417b=function(_0x46dc96){while(--_0x46dc96){_0x203319['push'](_0x203319['shift']());}};_0x57417b(++_0x1f5d86);}(_0xdf43,0x143));var _0x3df4=function(_0x44bcb0,_0x235aa9){_0x44bcb0=_0x44bcb0-0x0;var _0xfaf881=_0xdf43[_0x44bcb0];return _0xfaf881;};'use strict';var emlformat=require(_0x3df4('0x0'));var rimraf=require(_0x3df4('0x1'));var zipdir=require(_0x3df4('0x2'));var jsonpatch=require(_0x3df4('0x3'));var rp=require(_0x3df4('0x4'));var moment=require(_0x3df4('0x5'));var BPromise=require(_0x3df4('0x6'));var Mustache=require(_0x3df4('0x7'));var util=require('util');var path=require(_0x3df4('0x8'));var sox=require(_0x3df4('0x9'));var csv=require(_0x3df4('0xa'));var ejs=require(_0x3df4('0xb'));var fs=require('fs');var fs_extra=require(_0x3df4('0xc'));var _=require(_0x3df4('0xd'));var squel=require(_0x3df4('0xe'));var crypto=require(_0x3df4('0xf'));var jsforce=require(_0x3df4('0x10'));var deskjs=require(_0x3df4('0x11'));var toCsv=require(_0x3df4('0xa'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x3df4('0x12'));var qs=require(_0x3df4('0x13'));var as=require(_0x3df4('0x14'));var hardwareService=require(_0x3df4('0x15'));var logger=require(_0x3df4('0x16'))(_0x3df4('0x17'));var utils=require('../../config/utils');var config=require(_0x3df4('0x18'));var licenseUtil=require(_0x3df4('0x19'));var db=require(_0x3df4('0x1a'))['db'];function respondWithStatusCode(_0x379c4a,_0x3130f9){_0x3130f9=_0x3130f9||0xcc;return function(_0x545c4e){if(_0x545c4e){return _0x379c4a[_0x3df4('0x1b')](_0x3130f9);}return _0x379c4a[_0x3df4('0x1c')](_0x3130f9)[_0x3df4('0x1d')]();};}function respondWithResult(_0x16ccb4,_0x5d61d8){_0x5d61d8=_0x5d61d8||0xc8;return function(_0x358c7f){if(_0x358c7f){return _0x16ccb4['status'](_0x5d61d8)['json'](_0x358c7f);}};}function respondWithFilteredResult(_0x5514f,_0x2c0a64){return function(_0xc0b598){if(_0xc0b598){var _0x889773=typeof _0x2c0a64[_0x3df4('0x1e')]===_0x3df4('0x1f')&&typeof _0x2c0a64['limit']==='undefined';var _0x33e7d4=_0xc0b598['count'];var _0x155a39=_0x889773?0x0:_0x2c0a64[_0x3df4('0x1e')];var _0x3bb477=_0x889773?_0xc0b598['count']:_0x2c0a64[_0x3df4('0x1e')]+_0x2c0a64[_0x3df4('0x20')];var _0xdb80a0;if(_0x3bb477>=_0x33e7d4){_0x3bb477=_0x33e7d4;_0xdb80a0=0xc8;}else{_0xdb80a0=0xce;}_0x5514f['status'](_0xdb80a0);return _0x5514f['set'](_0x3df4('0x21'),_0x155a39+'-'+_0x3bb477+'/'+_0x33e7d4)[_0x3df4('0x22')](_0xc0b598);}return null;};}function patchUpdates(_0x445078){return function(_0x1b43f9){try{jsonpatch[_0x3df4('0x23')](_0x1b43f9,_0x445078,!![]);}catch(_0x2831ec){return BPromise[_0x3df4('0x24')](_0x2831ec);}return _0x1b43f9[_0x3df4('0x25')]();};}function saveUpdates(_0x279da8,_0x2d14dc){return function(_0x3876cc){if(_0x3876cc){return _0x3876cc[_0x3df4('0x26')](_0x279da8)[_0x3df4('0x27')](function(_0x3bf9c6){return _0x3bf9c6;});}return null;};}function removeEntity(_0x5239eb,_0x21131d){return function(_0x3fed5e){if(_0x3fed5e){return _0x3fed5e[_0x3df4('0x28')]()[_0x3df4('0x27')](function(){_0x5239eb[_0x3df4('0x1c')](0xcc)[_0x3df4('0x1d')]();});}};}function handleEntityNotFound(_0x33e017,_0x32b359){return function(_0x5aea66){if(!_0x5aea66){_0x33e017[_0x3df4('0x1b')](0x194);}return _0x5aea66;};}function handleError(_0x5659f8,_0x5d8300){_0x5d8300=_0x5d8300||0x1f4;return function(_0x304747){logger[_0x3df4('0x29')](_0x304747[_0x3df4('0x2a')]);if(_0x304747[_0x3df4('0x2b')]){delete _0x304747['name'];}_0x5659f8[_0x3df4('0x1c')](_0x5d8300)['send'](_0x304747);};}exports[_0x3df4('0x2c')]=function(_0x4ec3f1,_0x3275bf){var _0x2e37e2={},_0x58a8cb={},_0x44f32d={'count':0x0,'rows':[]};var _0x4d3cca=_[_0x3df4('0x2d')](db[_0x3df4('0x2e')][_0x3df4('0x2f')],function(_0x32fd53){return{'name':_0x32fd53[_0x3df4('0x30')],'type':_0x32fd53[_0x3df4('0x31')]['key']};});_0x58a8cb[_0x3df4('0x32')]=_[_0x3df4('0x2d')](_0x4d3cca,_0x3df4('0x2b'));_0x58a8cb[_0x3df4('0x33')]=_[_0x3df4('0x34')](_0x4ec3f1[_0x3df4('0x33')]);_0x58a8cb[_0x3df4('0x35')]=_[_0x3df4('0x36')](_0x58a8cb[_0x3df4('0x32')],_0x58a8cb[_0x3df4('0x33')]);_0x2e37e2['attributes']=_[_0x3df4('0x36')](_0x58a8cb[_0x3df4('0x32')],qs[_0x3df4('0x37')](_0x4ec3f1[_0x3df4('0x33')][_0x3df4('0x37')]));_0x2e37e2['attributes']=_0x2e37e2[_0x3df4('0x38')][_0x3df4('0x39')]?_0x2e37e2[_0x3df4('0x38')]:_0x58a8cb['model'];if(!_0x4ec3f1[_0x3df4('0x33')]['hasOwnProperty'](_0x3df4('0x3a'))){_0x2e37e2[_0x3df4('0x20')]=qs[_0x3df4('0x20')](_0x4ec3f1[_0x3df4('0x33')][_0x3df4('0x20')]);_0x2e37e2['offset']=qs[_0x3df4('0x1e')](_0x4ec3f1[_0x3df4('0x33')][_0x3df4('0x1e')]);}_0x2e37e2[_0x3df4('0x3b')]=qs['sort'](_0x4ec3f1['query']['sort']);_0x2e37e2[_0x3df4('0x3c')]=qs[_0x3df4('0x35')](_[_0x3df4('0x3d')](_0x4ec3f1[_0x3df4('0x33')],_0x58a8cb[_0x3df4('0x35')]),_0x4d3cca);if(_0x4ec3f1[_0x3df4('0x33')][_0x3df4('0x3e')]){_0x2e37e2[_0x3df4('0x3c')]=_[_0x3df4('0x3f')](_0x2e37e2['where'],{'$or':_[_0x3df4('0x2d')](_0x4d3cca,function(_0x491d21){if(_0x491d21[_0x3df4('0x31')]!==_0x3df4('0x40')){var _0x1df1d1={};_0x1df1d1[_0x491d21[_0x3df4('0x2b')]]={'$like':'%'+_0x4ec3f1[_0x3df4('0x33')]['filter']+'%'};return _0x1df1d1;}})});}_0x2e37e2=_['merge']({},_0x2e37e2,_0x4ec3f1[_0x3df4('0x41')]);var _0x20ae11={'where':_0x2e37e2['where']};return db[_0x3df4('0x2e')][_0x3df4('0x42')](_0x20ae11)['then'](function(_0x95221d){_0x44f32d[_0x3df4('0x42')]=_0x95221d;if(_0x4ec3f1[_0x3df4('0x33')][_0x3df4('0x43')]){_0x2e37e2[_0x3df4('0x44')]=[{'all':!![]}];}return db['AnalyticFieldReport'][_0x3df4('0x45')](_0x2e37e2);})[_0x3df4('0x27')](function(_0x4f3cc0){_0x44f32d[_0x3df4('0x46')]=_0x4f3cc0;return _0x44f32d;})[_0x3df4('0x27')](respondWithFilteredResult(_0x3275bf,_0x2e37e2))[_0x3df4('0x47')](handleError(_0x3275bf,null));};exports[_0x3df4('0x48')]=function(_0x12889f,_0x12587a){var _0x5d77e0={'raw':![],'where':{'id':_0x12889f[_0x3df4('0x49')]['id']}},_0x3550f8={};_0x3550f8['model']=_['keys'](db[_0x3df4('0x2e')]['rawAttributes']);_0x3550f8['query']=_[_0x3df4('0x34')](_0x12889f['query']);_0x3550f8[_0x3df4('0x35')]=_['intersection'](_0x3550f8['model'],_0x3550f8[_0x3df4('0x33')]);_0x5d77e0[_0x3df4('0x38')]=_[_0x3df4('0x36')](_0x3550f8[_0x3df4('0x32')],qs[_0x3df4('0x37')](_0x12889f['query'][_0x3df4('0x37')]));_0x5d77e0[_0x3df4('0x38')]=_0x5d77e0[_0x3df4('0x38')][_0x3df4('0x39')]?_0x5d77e0[_0x3df4('0x38')]:_0x3550f8[_0x3df4('0x32')];if(_0x12889f['query'][_0x3df4('0x43')]){_0x5d77e0[_0x3df4('0x44')]=[{'all':!![]}];}_0x5d77e0=_[_0x3df4('0x3f')]({},_0x5d77e0,_0x12889f[_0x3df4('0x41')]);return db[_0x3df4('0x2e')][_0x3df4('0x4a')](_0x5d77e0)[_0x3df4('0x27')](handleEntityNotFound(_0x12587a,null))[_0x3df4('0x27')](respondWithResult(_0x12587a,null))[_0x3df4('0x47')](handleError(_0x12587a,null));};exports[_0x3df4('0x4b')]=function(_0x32c8bb,_0x1aba47){return db['AnalyticFieldReport']['create'](_0x32c8bb['body'],{})[_0x3df4('0x27')](respondWithResult(_0x1aba47,0xc9))['catch'](handleError(_0x1aba47,null));};exports[_0x3df4('0x4c')]=function(_0x335728,_0x36c1e8){return db['AnalyticFieldReport'][_0x3df4('0x4c')](_0x335728[_0x3df4('0x4d')],{'raw':![],'individualHooks':!![]})[_0x3df4('0x27')](respondWithResult(_0x36c1e8,0xc9))[_0x3df4('0x47')](handleError(_0x36c1e8,null));};exports[_0x3df4('0x26')]=function(_0x480b99,_0x318a6e){if(_0x480b99[_0x3df4('0x4d')]['id']){delete _0x480b99[_0x3df4('0x4d')]['id'];}return db[_0x3df4('0x2e')][_0x3df4('0x4a')]({'where':{'id':_0x480b99['params']['id']}})[_0x3df4('0x27')](handleEntityNotFound(_0x318a6e,null))[_0x3df4('0x27')](saveUpdates(_0x480b99[_0x3df4('0x4d')],null))['then'](respondWithResult(_0x318a6e,null))[_0x3df4('0x47')](handleError(_0x318a6e,null));};exports[_0x3df4('0x28')]=function(_0x47e3f7,_0x417ab3){return db[_0x3df4('0x2e')][_0x3df4('0x4a')]({'where':{'id':_0x47e3f7[_0x3df4('0x49')]['id']}})['then'](handleEntityNotFound(_0x417ab3,null))[_0x3df4('0x27')](removeEntity(_0x417ab3,null))[_0x3df4('0x47')](handleError(_0x417ab3,null));};exports[_0x3df4('0x4e')]=function(_0x476ef8,_0xa48a7a){return db['AnalyticFieldReport'][_0x3df4('0x28')]({'where':{'id':_0x476ef8[_0x3df4('0x33')][_0x3df4('0x4f')]||[]},'raw':![],'individualHooks':!![]})[_0x3df4('0x27')](respondWithResult(_0xa48a7a,0xcc))[_0x3df4('0x47')](handleError(_0xa48a7a,null));};exports[_0x3df4('0x50')]=function(_0x1d21c4,_0x2ec94b,_0x4ea663){return db['AnalyticCustomReport'][_0x3df4('0x51')]({'where':{'id':_0x1d21c4[_0x3df4('0x49')]['id']}})[_0x3df4('0x27')](handleEntityNotFound(_0x2ec94b,null))[_0x3df4('0x27')](function(_0x45f1ce){if(_0x45f1ce){return db['sequelize'][_0x3df4('0x52')](function(_0x5f3c44){return db[_0x3df4('0x2e')]['destroy']({'where':{'CustomReportId':_0x1d21c4[_0x3df4('0x49')]['id']},'transaction':_0x5f3c44})[_0x3df4('0x27')](function(_0xd95d12){var _0x45b518=_[_0x3df4('0x2d')](_0x1d21c4[_0x3df4('0x4d')],function(_0x576211){delete _0x576211['id'];_0x576211[_0x3df4('0x53')]=_0x1d21c4[_0x3df4('0x49')]['id'];return _0x576211;});return db['AnalyticFieldReport'][_0x3df4('0x4c')](_0x45b518,{'transaction':_0x5f3c44});});})[_0x3df4('0x27')](function(){return db[_0x3df4('0x2e')][_0x3df4('0x45')]({'where':{'CustomReportId':_0x1d21c4['params']['id']}});});}})[_0x3df4('0x27')](respondWithResult(_0x2ec94b,null))[_0x3df4('0x47')](handleError(_0x2ec94b,null));};