Built motion from commit b0a9a629.|2.6.33
[motion2.git] / server / api / analyticExtractedReport / analyticExtractedReport.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 _0x25fe=['include','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','find','download','savename','output','join','root','server/files/reports','Sequelize','ValidationError','format','%s.%s','toLowerCase','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/license/util','../../mysqldb','end','status','json','offset','undefined','limit','count','set','apply','reject','save','destroy','then','get','ExtractedReports','UserProfileResource','sendStatus','error','stack','name','send','index','map','AnalyticExtractedReport','rawAttributes','fieldName','key','model','query','keys','filters','attributes','intersection','fields','length','hasOwnProperty','nolimit','order','sort','pick','filter','merge','where','VIRTUAL','options','includeAll','findAll','catch','show','params'];(function(_0x302099,_0xe61dca){var _0x24a042=function(_0x50b7fb){while(--_0x50b7fb){_0x302099['push'](_0x302099['shift']());}};_0x24a042(++_0xe61dca);}(_0x25fe,0x19d));var _0xe25f=function(_0x5471ec,_0x1ce81a){_0x5471ec=_0x5471ec-0x0;var _0x121d4c=_0x25fe[_0x5471ec];return _0x121d4c;};'use strict';var emlformat=require(_0xe25f('0x0'));var rimraf=require(_0xe25f('0x1'));var zipdir=require(_0xe25f('0x2'));var jsonpatch=require(_0xe25f('0x3'));var rp=require(_0xe25f('0x4'));var moment=require('moment');var BPromise=require(_0xe25f('0x5'));var Mustache=require(_0xe25f('0x6'));var util=require('util');var path=require(_0xe25f('0x7'));var sox=require(_0xe25f('0x8'));var csv=require(_0xe25f('0x9'));var ejs=require(_0xe25f('0xa'));var fs=require('fs');var fs_extra=require(_0xe25f('0xb'));var _=require(_0xe25f('0xc'));var squel=require(_0xe25f('0xd'));var crypto=require(_0xe25f('0xe'));var jsforce=require(_0xe25f('0xf'));var deskjs=require('desk.js');var toCsv=require(_0xe25f('0x9'));var querystring=require(_0xe25f('0x10'));var Papa=require(_0xe25f('0x11'));var Redis=require(_0xe25f('0x12'));var authService=require(_0xe25f('0x13'));var qs=require(_0xe25f('0x14'));var as=require(_0xe25f('0x15'));var hardwareService=require(_0xe25f('0x16'));var logger=require(_0xe25f('0x17'))(_0xe25f('0x18'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0xe25f('0x19'));var db=require(_0xe25f('0x1a'))['db'];function respondWithStatusCode(_0x12ac98,_0x364fe7){_0x364fe7=_0x364fe7||0xcc;return function(_0x439a76){if(_0x439a76){return _0x12ac98['sendStatus'](_0x364fe7);}return _0x12ac98['status'](_0x364fe7)[_0xe25f('0x1b')]();};}function respondWithResult(_0x5acd54,_0x1b4ab9){_0x1b4ab9=_0x1b4ab9||0xc8;return function(_0x2af5e9){if(_0x2af5e9){return _0x5acd54[_0xe25f('0x1c')](_0x1b4ab9)[_0xe25f('0x1d')](_0x2af5e9);}};}function respondWithFilteredResult(_0x5c2fce,_0x3cc95a){return function(_0xa0b7f){if(_0xa0b7f){var _0x33877b=typeof _0x3cc95a[_0xe25f('0x1e')]===_0xe25f('0x1f')&&typeof _0x3cc95a[_0xe25f('0x20')]===_0xe25f('0x1f');var _0x1e1010=_0xa0b7f[_0xe25f('0x21')];var _0xf5421a=_0x33877b?0x0:_0x3cc95a['offset'];var _0x4a4542=_0x33877b?_0xa0b7f[_0xe25f('0x21')]:_0x3cc95a[_0xe25f('0x1e')]+_0x3cc95a[_0xe25f('0x20')];var _0x3a3b03;if(_0x4a4542>=_0x1e1010){_0x4a4542=_0x1e1010;_0x3a3b03=0xc8;}else{_0x3a3b03=0xce;}_0x5c2fce['status'](_0x3a3b03);return _0x5c2fce[_0xe25f('0x22')]('Content-Range',_0xf5421a+'-'+_0x4a4542+'/'+_0x1e1010)[_0xe25f('0x1d')](_0xa0b7f);}return null;};}function patchUpdates(_0x567e25){return function(_0x3762d0){try{jsonpatch[_0xe25f('0x23')](_0x3762d0,_0x567e25,!![]);}catch(_0x493e84){return BPromise[_0xe25f('0x24')](_0x493e84);}return _0x3762d0[_0xe25f('0x25')]();};}function saveUpdates(_0x45a055,_0x335c15){return function(_0x45113d){if(_0x45113d){return _0x45113d['update'](_0x45a055)['then'](function(_0x224aef){return _0x224aef;});}return null;};}function removeEntity(_0xe8756f,_0x5c121b){return function(_0x3fceda){if(_0x3fceda){return _0x3fceda[_0xe25f('0x26')]()[_0xe25f('0x27')](function(){var _0x265d03=_0x3fceda[_0xe25f('0x28')]({'plain':!![]});var _0x1052fe=_0xe25f('0x29');return db[_0xe25f('0x2a')][_0xe25f('0x26')]({'where':{'type':_0x1052fe,'resourceId':_0x265d03['id']}})['then'](function(){return _0x3fceda;});})[_0xe25f('0x27')](function(){_0xe8756f[_0xe25f('0x1c')](0xcc)[_0xe25f('0x1b')]();});}};}function handleEntityNotFound(_0x4a5ba1,_0x1c3e8e){return function(_0x415638){if(!_0x415638){_0x4a5ba1[_0xe25f('0x2b')](0x194);}return _0x415638;};}function handleError(_0x4c89a4,_0xfed027){_0xfed027=_0xfed027||0x1f4;return function(_0x216b90){logger[_0xe25f('0x2c')](_0x216b90[_0xe25f('0x2d')]);if(_0x216b90[_0xe25f('0x2e')]){delete _0x216b90['name'];}_0x4c89a4[_0xe25f('0x1c')](_0xfed027)[_0xe25f('0x2f')](_0x216b90);};}exports[_0xe25f('0x30')]=function(_0x1b4fd6,_0x2e359c){var _0x2f8ca4={},_0x569b0f={},_0x3144e0={'count':0x0,'rows':[]};var _0x31c8f6=_[_0xe25f('0x31')](db[_0xe25f('0x32')][_0xe25f('0x33')],function(_0x49212c){return{'name':_0x49212c[_0xe25f('0x34')],'type':_0x49212c['type'][_0xe25f('0x35')]};});_0x569b0f[_0xe25f('0x36')]=_['map'](_0x31c8f6,_0xe25f('0x2e'));_0x569b0f[_0xe25f('0x37')]=_[_0xe25f('0x38')](_0x1b4fd6[_0xe25f('0x37')]);_0x569b0f[_0xe25f('0x39')]=_['intersection'](_0x569b0f[_0xe25f('0x36')],_0x569b0f[_0xe25f('0x37')]);_0x2f8ca4[_0xe25f('0x3a')]=_[_0xe25f('0x3b')](_0x569b0f[_0xe25f('0x36')],qs[_0xe25f('0x3c')](_0x1b4fd6['query'][_0xe25f('0x3c')]));_0x2f8ca4[_0xe25f('0x3a')]=_0x2f8ca4[_0xe25f('0x3a')][_0xe25f('0x3d')]?_0x2f8ca4[_0xe25f('0x3a')]:_0x569b0f['model'];if(!_0x1b4fd6[_0xe25f('0x37')][_0xe25f('0x3e')](_0xe25f('0x3f'))){_0x2f8ca4[_0xe25f('0x20')]=qs[_0xe25f('0x20')](_0x1b4fd6[_0xe25f('0x37')][_0xe25f('0x20')]);_0x2f8ca4[_0xe25f('0x1e')]=qs[_0xe25f('0x1e')](_0x1b4fd6['query'][_0xe25f('0x1e')]);}_0x2f8ca4[_0xe25f('0x40')]=qs[_0xe25f('0x41')](_0x1b4fd6[_0xe25f('0x37')][_0xe25f('0x41')]);_0x2f8ca4['where']=qs[_0xe25f('0x39')](_[_0xe25f('0x42')](_0x1b4fd6[_0xe25f('0x37')],_0x569b0f[_0xe25f('0x39')]),_0x31c8f6);if(_0x1b4fd6[_0xe25f('0x37')][_0xe25f('0x43')]){_0x2f8ca4['where']=_[_0xe25f('0x44')](_0x2f8ca4[_0xe25f('0x45')],{'$or':_['map'](_0x31c8f6,function(_0x4a174f){if(_0x4a174f['type']!==_0xe25f('0x46')){var _0x26cbfd={};_0x26cbfd[_0x4a174f['name']]={'$like':'%'+_0x1b4fd6[_0xe25f('0x37')][_0xe25f('0x43')]+'%'};return _0x26cbfd;}})});}_0x2f8ca4=_['merge']({},_0x2f8ca4,_0x1b4fd6[_0xe25f('0x47')]);var _0x1cdd21={'where':_0x2f8ca4['where']};return db[_0xe25f('0x32')][_0xe25f('0x21')](_0x1cdd21)['then'](function(_0x4c2f40){_0x3144e0[_0xe25f('0x21')]=_0x4c2f40;if(_0x1b4fd6[_0xe25f('0x37')][_0xe25f('0x48')]){_0x2f8ca4['include']=[{'all':!![]}];}return db[_0xe25f('0x32')][_0xe25f('0x49')](_0x2f8ca4);})[_0xe25f('0x27')](function(_0x4fe55b){_0x3144e0['rows']=_0x4fe55b;return _0x3144e0;})[_0xe25f('0x27')](respondWithFilteredResult(_0x2e359c,_0x2f8ca4))[_0xe25f('0x4a')](handleError(_0x2e359c,null));};exports[_0xe25f('0x4b')]=function(_0x1f992e,_0x5c19fe){var _0x33e014={'raw':!![],'where':{'id':_0x1f992e[_0xe25f('0x4c')]['id']}},_0x44ce10={};_0x44ce10['model']=_[_0xe25f('0x38')](db[_0xe25f('0x32')][_0xe25f('0x33')]);_0x44ce10['query']=_[_0xe25f('0x38')](_0x1f992e[_0xe25f('0x37')]);_0x44ce10[_0xe25f('0x39')]=_['intersection'](_0x44ce10[_0xe25f('0x36')],_0x44ce10[_0xe25f('0x37')]);_0x33e014[_0xe25f('0x3a')]=_['intersection'](_0x44ce10[_0xe25f('0x36')],qs[_0xe25f('0x3c')](_0x1f992e[_0xe25f('0x37')][_0xe25f('0x3c')]));_0x33e014['attributes']=_0x33e014[_0xe25f('0x3a')][_0xe25f('0x3d')]?_0x33e014[_0xe25f('0x3a')]:_0x44ce10[_0xe25f('0x36')];if(_0x1f992e[_0xe25f('0x37')][_0xe25f('0x48')]){_0x33e014[_0xe25f('0x4d')]=[{'all':!![]}];}_0x33e014=_['merge']({},_0x33e014,_0x1f992e[_0xe25f('0x47')]);return db[_0xe25f('0x32')]['find'](_0x33e014)[_0xe25f('0x27')](handleEntityNotFound(_0x5c19fe,null))['then'](respondWithResult(_0x5c19fe,null))[_0xe25f('0x4a')](handleError(_0x5c19fe,null));};exports[_0xe25f('0x4e')]=function(_0x3ea1ab,_0x457f49){return db[_0xe25f('0x32')]['create'](_0x3ea1ab[_0xe25f('0x4f')],{})['then'](function(_0x1e6d63){var _0x6e38f7=_0x3ea1ab[_0xe25f('0x50')][_0xe25f('0x28')]({'plain':!![]});if(!_0x6e38f7)throw new Error(_0xe25f('0x51'));if(_0x6e38f7[_0xe25f('0x52')]==='user'){var _0x473dd1=_0x1e6d63[_0xe25f('0x28')]({'plain':!![]});var _0x4c6a0b='ExtractedReports';return db[_0xe25f('0x53')]['find']({'where':{'name':_0x4c6a0b,'userProfileId':_0x6e38f7[_0xe25f('0x54')]},'raw':!![]})[_0xe25f('0x27')](function(_0x5afda3){if(_0x5afda3&&_0x5afda3['autoAssociation']===0x0){return db[_0xe25f('0x2a')][_0xe25f('0x4e')]({'name':_0x473dd1[_0xe25f('0x2e')],'resourceId':_0x473dd1['id'],'type':_0x5afda3[_0xe25f('0x2e')],'sectionId':_0x5afda3['id']},{})['then'](function(){return _0x1e6d63;});}else{return _0x1e6d63;}})[_0xe25f('0x4a')](function(_0x372d41){logger[_0xe25f('0x2c')](_0xe25f('0x55'),_0x372d41);throw _0x372d41;});}return _0x1e6d63;})['then'](respondWithResult(_0x457f49,0xc9))[_0xe25f('0x4a')](handleError(_0x457f49,null));};exports['update']=function(_0x570436,_0x49b0e1){if(_0x570436[_0xe25f('0x4f')]['id']){delete _0x570436['body']['id'];}return db['AnalyticExtractedReport']['find']({'where':{'id':_0x570436['params']['id']}})[_0xe25f('0x27')](handleEntityNotFound(_0x49b0e1,null))[_0xe25f('0x27')](saveUpdates(_0x570436[_0xe25f('0x4f')],null))[_0xe25f('0x27')](respondWithResult(_0x49b0e1,null))['catch'](handleError(_0x49b0e1,null));};exports[_0xe25f('0x26')]=function(_0x2b8e85,_0x22e23f){return db['AnalyticExtractedReport'][_0xe25f('0x56')]({'where':{'id':_0x2b8e85[_0xe25f('0x4c')]['id']}})[_0xe25f('0x27')](handleEntityNotFound(_0x22e23f,null))[_0xe25f('0x27')](removeEntity(_0x22e23f,null))[_0xe25f('0x4a')](handleError(_0x22e23f,null));};exports[_0xe25f('0x57')]=function(_0x15e58e,_0x11a190,_0x3eebe6){return db['AnalyticExtractedReport'][_0xe25f('0x56')]({'where':{'id':_0x15e58e[_0xe25f('0x4c')]['id']},'attributes':[_0xe25f('0x2e'),'basename',_0xe25f('0x58'),_0xe25f('0x59')],'raw':!![]})[_0xe25f('0x27')](handleEntityNotFound(_0x11a190,null))[_0xe25f('0x27')](function(_0x503667){if(_0x503667){if(!fs['existsSync'](path[_0xe25f('0x5a')](config[_0xe25f('0x5b')],_0xe25f('0x5c'),_0x503667[_0xe25f('0x58')]))){throw new db[(_0xe25f('0x5d'))][(_0xe25f('0x5e'))]('Report\x20not\x20found\x20or\x20empty');}if(_0x15e58e[_0xe25f('0x37')]['exists']){return _0x11a190[_0xe25f('0x2b')](0xc8);}return _0x11a190[_0xe25f('0x57')](path[_0xe25f('0x5a')](config['root'],_0xe25f('0x5c'),_0x503667[_0xe25f('0x58')]),util[_0xe25f('0x5f')](_0xe25f('0x60'),_0x503667['basename']||_0x503667[_0xe25f('0x2e')],_0x503667[_0xe25f('0x59')][_0xe25f('0x61')]()));}})['catch'](handleError(_0x11a190,null));};