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 _0xf72b=['status','json','count','offset','limit','set','Content-Range','apply','reject','save','update','then','destroy','error','name','send','index','map','fieldName','key','model','query','keys','filters','intersection','fields','length','attributes','hasOwnProperty','order','sort','where','pick','filter','merge','type','VIRTUAL','options','AnalyticFieldReport','includeAll','include','findAll','catch','params','find','create','body','bulkCreate','bulkDestroy','ids','addFields','transaction','eml-format','rimraf','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','fs-extra','squel','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','sendStatus','end'];(function(_0x27a65e,_0x15e437){var _0x18355a=function(_0x4b88fd){while(--_0x4b88fd){_0x27a65e['push'](_0x27a65e['shift']());}};_0x18355a(++_0x15e437);}(_0xf72b,0x118));var _0xbf72=function(_0x4d5ed6,_0x2ec70b){_0x4d5ed6=_0x4d5ed6-0x0;var _0x34dc03=_0xf72b[_0x4d5ed6];return _0x34dc03;};'use strict';var emlformat=require(_0xbf72('0x0'));var rimraf=require(_0xbf72('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xbf72('0x2'));var rp=require('request-promise');var moment=require(_0xbf72('0x3'));var BPromise=require(_0xbf72('0x4'));var Mustache=require(_0xbf72('0x5'));var util=require(_0xbf72('0x6'));var path=require(_0xbf72('0x7'));var sox=require(_0xbf72('0x8'));var csv=require(_0xbf72('0x9'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xbf72('0xa'));var _=require('lodash');var squel=require(_0xbf72('0xb'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0xbf72('0xc'));var toCsv=require(_0xbf72('0x9'));var querystring=require(_0xbf72('0xd'));var Papa=require(_0xbf72('0xe'));var Redis=require(_0xbf72('0xf'));var authService=require(_0xbf72('0x10'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0xbf72('0x11'))(_0xbf72('0x12'));var utils=require(_0xbf72('0x13'));var config=require(_0xbf72('0x14'));var licenseUtil=require(_0xbf72('0x15'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x47c5c0,_0x3faff3){_0x3faff3=_0x3faff3||0xcc;return function(_0xb0fba2){if(_0xb0fba2){return _0x47c5c0[_0xbf72('0x16')](_0x3faff3);}return _0x47c5c0['status'](_0x3faff3)[_0xbf72('0x17')]();};}function respondWithResult(_0x278e74,_0x537411){_0x537411=_0x537411||0xc8;return function(_0x1b7897){if(_0x1b7897){return _0x278e74[_0xbf72('0x18')](_0x537411)[_0xbf72('0x19')](_0x1b7897);}};}function respondWithFilteredResult(_0x34cec5,_0x2dda54){return function(_0xe910){if(_0xe910){var _0x333ca2=_0xe910[_0xbf72('0x1a')],_0x285249=_0x2dda54['offset'],_0x1a9018=_0x2dda54[_0xbf72('0x1b')]+_0x2dda54[_0xbf72('0x1c')],_0x4e1dcf;if(_0x1a9018>=_0x333ca2){_0x1a9018=_0x333ca2;_0x4e1dcf=0xc8;}else{_0x4e1dcf=0xce;}_0x34cec5['status'](_0x4e1dcf);return _0x34cec5[_0xbf72('0x1d')](_0xbf72('0x1e'),_0x285249+'-'+_0x1a9018+'/'+_0x333ca2)[_0xbf72('0x19')](_0xe910);}return null;};}function patchUpdates(_0x4249e4){return function(_0x56555d){try{jsonpatch[_0xbf72('0x1f')](_0x56555d,_0x4249e4,!![]);}catch(_0x293004){return BPromise[_0xbf72('0x20')](_0x293004);}return _0x56555d[_0xbf72('0x21')]();};}function saveUpdates(_0x23d3fe,_0x48360a){return function(_0x402ca2){if(_0x402ca2){return _0x402ca2[_0xbf72('0x22')](_0x23d3fe)[_0xbf72('0x23')](function(_0x4c81b4){return _0x4c81b4;});}return null;};}function removeEntity(_0x75c238,_0x327752){return function(_0x584eee){if(_0x584eee){return _0x584eee[_0xbf72('0x24')]()['then'](function(){_0x75c238[_0xbf72('0x18')](0xcc)[_0xbf72('0x17')]();});}};}function handleEntityNotFound(_0xcf5567,_0x3d34ce){return function(_0x34a711){if(!_0x34a711){_0xcf5567[_0xbf72('0x16')](0x194);}return _0x34a711;};}function handleError(_0x436ad4,_0xf88dcf){_0xf88dcf=_0xf88dcf||0x1f4;return function(_0xb715b){logger[_0xbf72('0x25')](_0xb715b['stack']);if(_0xb715b[_0xbf72('0x26')]){delete _0xb715b[_0xbf72('0x26')];}_0x436ad4[_0xbf72('0x18')](_0xf88dcf)[_0xbf72('0x27')](_0xb715b);};}exports[_0xbf72('0x28')]=function(_0x1d1ac0,_0xd67ff7){var _0x3b6c56={},_0x48f0e5={},_0x494848={'count':0x0,'rows':[]};var _0x3f5f4b=_[_0xbf72('0x29')](db['AnalyticFieldReport']['rawAttributes'],function(_0x1bc991){return{'name':_0x1bc991[_0xbf72('0x2a')],'type':_0x1bc991['type'][_0xbf72('0x2b')]};});_0x48f0e5[_0xbf72('0x2c')]=_[_0xbf72('0x29')](_0x3f5f4b,'name');_0x48f0e5[_0xbf72('0x2d')]=_[_0xbf72('0x2e')](_0x1d1ac0['query']);_0x48f0e5[_0xbf72('0x2f')]=_[_0xbf72('0x30')](_0x48f0e5[_0xbf72('0x2c')],_0x48f0e5[_0xbf72('0x2d')]);_0x3b6c56['attributes']=_[_0xbf72('0x30')](_0x48f0e5[_0xbf72('0x2c')],qs[_0xbf72('0x31')](_0x1d1ac0[_0xbf72('0x2d')][_0xbf72('0x31')]));_0x3b6c56['attributes']=_0x3b6c56['attributes'][_0xbf72('0x32')]?_0x3b6c56[_0xbf72('0x33')]:_0x48f0e5[_0xbf72('0x2c')];if(!_0x1d1ac0[_0xbf72('0x2d')][_0xbf72('0x34')]('nolimit')){_0x3b6c56[_0xbf72('0x1c')]=qs[_0xbf72('0x1c')](_0x1d1ac0[_0xbf72('0x2d')]['limit']);_0x3b6c56[_0xbf72('0x1b')]=qs[_0xbf72('0x1b')](_0x1d1ac0[_0xbf72('0x2d')][_0xbf72('0x1b')]);}_0x3b6c56[_0xbf72('0x35')]=qs[_0xbf72('0x36')](_0x1d1ac0['query']['sort']);_0x3b6c56[_0xbf72('0x37')]=qs[_0xbf72('0x2f')](_[_0xbf72('0x38')](_0x1d1ac0[_0xbf72('0x2d')],_0x48f0e5[_0xbf72('0x2f')]),_0x3f5f4b);if(_0x1d1ac0[_0xbf72('0x2d')][_0xbf72('0x39')]){_0x3b6c56[_0xbf72('0x37')]=_[_0xbf72('0x3a')](_0x3b6c56[_0xbf72('0x37')],{'$or':_[_0xbf72('0x29')](_0x3f5f4b,function(_0xaf3564){if(_0xaf3564[_0xbf72('0x3b')]!==_0xbf72('0x3c')){var _0x2e6b78={};_0x2e6b78[_0xaf3564[_0xbf72('0x26')]]={'$like':'%'+_0x1d1ac0['query'][_0xbf72('0x39')]+'%'};return _0x2e6b78;}})});}_0x3b6c56=_[_0xbf72('0x3a')]({},_0x3b6c56,_0x1d1ac0[_0xbf72('0x3d')]);var _0x565d02={'where':_0x3b6c56[_0xbf72('0x37')]};return db[_0xbf72('0x3e')][_0xbf72('0x1a')](_0x565d02)[_0xbf72('0x23')](function(_0x2fb922){_0x494848[_0xbf72('0x1a')]=_0x2fb922;if(_0x1d1ac0['query'][_0xbf72('0x3f')]){_0x3b6c56[_0xbf72('0x40')]=[{'all':!![]}];}return db[_0xbf72('0x3e')][_0xbf72('0x41')](_0x3b6c56);})['then'](function(_0x4dcbb7){_0x494848['rows']=_0x4dcbb7;return _0x494848;})[_0xbf72('0x23')](respondWithFilteredResult(_0xd67ff7,_0x3b6c56))[_0xbf72('0x42')](handleError(_0xd67ff7,null));};exports['show']=function(_0x386d5b,_0x15c3be){var _0x4e6b05={'raw':![],'where':{'id':_0x386d5b[_0xbf72('0x43')]['id']}},_0x5ad68b={};_0x5ad68b['model']=_[_0xbf72('0x2e')](db[_0xbf72('0x3e')]['rawAttributes']);_0x5ad68b[_0xbf72('0x2d')]=_[_0xbf72('0x2e')](_0x386d5b[_0xbf72('0x2d')]);_0x5ad68b[_0xbf72('0x2f')]=_[_0xbf72('0x30')](_0x5ad68b['model'],_0x5ad68b[_0xbf72('0x2d')]);_0x4e6b05[_0xbf72('0x33')]=_[_0xbf72('0x30')](_0x5ad68b[_0xbf72('0x2c')],qs[_0xbf72('0x31')](_0x386d5b[_0xbf72('0x2d')]['fields']));_0x4e6b05[_0xbf72('0x33')]=_0x4e6b05[_0xbf72('0x33')]['length']?_0x4e6b05['attributes']:_0x5ad68b['model'];if(_0x386d5b[_0xbf72('0x2d')][_0xbf72('0x3f')]){_0x4e6b05[_0xbf72('0x40')]=[{'all':!![]}];}_0x4e6b05=_['merge']({},_0x4e6b05,_0x386d5b[_0xbf72('0x3d')]);return db[_0xbf72('0x3e')][_0xbf72('0x44')](_0x4e6b05)[_0xbf72('0x23')](handleEntityNotFound(_0x15c3be,null))[_0xbf72('0x23')](respondWithResult(_0x15c3be,null))[_0xbf72('0x42')](handleError(_0x15c3be,null));};exports[_0xbf72('0x45')]=function(_0x2caba9,_0x41f861){return db[_0xbf72('0x3e')]['create'](_0x2caba9[_0xbf72('0x46')],{})[_0xbf72('0x23')](respondWithResult(_0x41f861,0xc9))[_0xbf72('0x42')](handleError(_0x41f861,null));};exports['bulkCreate']=function(_0x2ade93,_0x4185e1){return db[_0xbf72('0x3e')][_0xbf72('0x47')](_0x2ade93[_0xbf72('0x46')],{'raw':![],'individualHooks':!![]})[_0xbf72('0x23')](respondWithResult(_0x4185e1,0xc9))['catch'](handleError(_0x4185e1,null));};exports[_0xbf72('0x22')]=function(_0x4d44f3,_0xd16a83){if(_0x4d44f3[_0xbf72('0x46')]['id']){delete _0x4d44f3[_0xbf72('0x46')]['id'];}return db['AnalyticFieldReport'][_0xbf72('0x44')]({'where':{'id':_0x4d44f3[_0xbf72('0x43')]['id']}})[_0xbf72('0x23')](handleEntityNotFound(_0xd16a83,null))[_0xbf72('0x23')](saveUpdates(_0x4d44f3['body'],null))[_0xbf72('0x23')](respondWithResult(_0xd16a83,null))['catch'](handleError(_0xd16a83,null));};exports[_0xbf72('0x24')]=function(_0x5cd735,_0xd1bb9f){return db['AnalyticFieldReport'][_0xbf72('0x44')]({'where':{'id':_0x5cd735[_0xbf72('0x43')]['id']}})[_0xbf72('0x23')](handleEntityNotFound(_0xd1bb9f,null))[_0xbf72('0x23')](removeEntity(_0xd1bb9f,null))[_0xbf72('0x42')](handleError(_0xd1bb9f,null));};exports[_0xbf72('0x48')]=function(_0x12d62f,_0x14fb43){return db['AnalyticFieldReport'][_0xbf72('0x24')]({'where':{'id':_0x12d62f[_0xbf72('0x2d')][_0xbf72('0x49')]||[]},'raw':![],'individualHooks':!![]})[_0xbf72('0x23')](respondWithResult(_0x14fb43,0xcc))[_0xbf72('0x42')](handleError(_0x14fb43,null));};exports[_0xbf72('0x4a')]=function(_0x4ead87,_0x5c8c37,_0x5e7112){return db['AnalyticCustomReport']['findOne']({'where':{'id':_0x4ead87[_0xbf72('0x43')]['id']}})[_0xbf72('0x23')](handleEntityNotFound(_0x5c8c37,null))[_0xbf72('0x23')](function(_0x3d7625){if(_0x3d7625){return db['sequelize'][_0xbf72('0x4b')](function(_0x186321){return db[_0xbf72('0x3e')][_0xbf72('0x24')]({'where':{'CustomReportId':_0x4ead87[_0xbf72('0x43')]['id']},'transaction':_0x186321})[_0xbf72('0x23')](function(_0x4a4e73){var _0x1121d3=_[_0xbf72('0x29')](_0x4ead87[_0xbf72('0x46')],function(_0x5a1f3a){delete _0x5a1f3a['id'];_0x5a1f3a['CustomReportId']=_0x4ead87['params']['id'];return _0x5a1f3a;});return db[_0xbf72('0x3e')][_0xbf72('0x47')](_0x1121d3,{'transaction':_0x186321});});})['then'](function(){return db['AnalyticFieldReport'][_0xbf72('0x41')]({'where':{'CustomReportId':_0x4ead87['params']['id']}});});}})[_0xbf72('0x23')](respondWithResult(_0x5c8c37,null))[_0xbf72('0x42')](handleError(_0x5c8c37,null));};