c6f22c6324da8dbe5ddacd53ebbc967714ebbf77
[motion-next.git] / server / api / jscriptyProject / jscriptyProject.controller.js
1 const a378_0x1a97=['number','Content-type','startTime','JscriptyQuestionReport','offset','rows','rawAttributes','getAnswers','map','util','length','type','model','Content-disposition','json','answer','body','include','undefined','nolimit','download','error','fields','fieldName','Jscripty_Project_%d_Summary_%s.csv','clone','query','questionId','like','catch','question','pick','../../mysqldb','../../components/parsers/qs','parse','filters','autoAssociation','lodash','sort','JscriptySessionReport','stack','UserProfileSection','count','sendStatus','isEmpty','sequelize','findAll','status','update','UserProfileResource','createdAt','setHeader','Content-Range','where','to-csv','role','JscriptyAnswerReport','send','name','Unable\x20to\x20retrieve\x20the\x20current\x20user','get','-createdAt','userProfileId','merge','options','destroy','findOne','starttime','toString','replace','Projects','params','user','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','JscriptyProject','filter','format','order','includeAll','updatedAt','getSessions','create','limit','set','attributes','push','indexOf','apply','index','fromCharCode','ProjectId','intersection','keys','../../config/logger','omit','then','VIRTUAL'];(function(_0x20d385,_0x1a970b){const _0x525164=function(_0x5b41f2){while(--_0x5b41f2){_0x20d385['push'](_0x20d385['shift']());}};_0x525164(++_0x1a970b);}(a378_0x1a97,0x1ad));const a378_0x5251=function(_0x20d385,_0x1a970b){_0x20d385=_0x20d385-0x0;let _0x525164=a378_0x1a97[_0x20d385];return _0x525164;};const _0x4e23d1=a378_0x5251;'use strict';const moment=require('moment'),util=require(_0x4e23d1('0x41')),fs=require('fs'),_=require(_0x4e23d1('0x5d')),toCsv=require(_0x4e23d1('0xd')),qs=require(_0x4e23d1('0x59')),logger=require(_0x4e23d1('0x34'))('api'),db=require(_0x4e23d1('0x58'))['db'],{Op}=require(_0x4e23d1('0x4'));function respondWithResult(_0x5b41f2,_0x58667a){return _0x58667a=_0x58667a||0xc8,function(_0x2b14a3){const _0x50d89c=a378_0x5251;if(_0x2b14a3)return _0x5b41f2['status'](_0x58667a)[_0x50d89c('0x46')](_0x2b14a3);};}function respondWithFilteredResult(_0x14936f,_0x2660da){return function(_0x1f5ef3){const _0x47b650=a378_0x5251;if(_0x1f5ef3){const _0x16f4e5=_0x1f5ef3[_0x47b650('0x1')],_0x41451b=_0x2660da['offset'];let _0x135626=_0x2660da[_0x47b650('0x3c')]+_0x2660da[_0x47b650('0x29')],_0x14f8fd;return _0x135626>=_0x16f4e5?(_0x135626=_0x16f4e5,_0x14f8fd=0xc8):_0x14f8fd=0xce,_0x14936f[_0x47b650('0x6')](_0x14f8fd),_0x14936f[_0x47b650('0x2a')](_0x47b650('0xb'),_0x41451b+'-'+_0x135626+'/'+_0x16f4e5)[_0x47b650('0x46')](_0x1f5ef3);}return null;};}function saveUpdates(_0x24fe5d){return function(_0x359dc9){const _0x2fd7c0=a378_0x5251;if(_0x359dc9)return _0x359dc9[_0x2fd7c0('0x7')](_0x24fe5d)[_0x2fd7c0('0x36')](function(_0x3b1351){return _0x3b1351;});return null;};}function removeEntity(_0xdecc9e){return function(_0x1b004b){const _0x47161c=a378_0x5251;if(_0x1b004b)return _0x1b004b[_0x47161c('0x18')]()['then'](function(){const _0x16903c=_0x47161c,_0x401d53=_0x1b004b['get']({'plain':!![]}),_0x2482d2=_0x16903c('0x1d');return db[_0x16903c('0x8')]['destroy']({'where':{'type':_0x2482d2,'resourceId':_0x401d53['id']}})[_0x16903c('0x36')](function(){return _0x1b004b;});})[_0x47161c('0x36')](function(){const _0x215430=_0x47161c;_0xdecc9e[_0x215430('0x6')](0xcc)['end']();});};}function handleEntityNotFound(_0x2834d3){return function(_0x1deb2d){const _0x505a33=a378_0x5251;return!_0x1deb2d&&_0x2834d3[_0x505a33('0x2')](0x194),_0x1deb2d;};}function handleError(_0x2d248b,_0x1e430b){return _0x1e430b=_0x1e430b||0x1f4,function(_0x1e1ed6){const _0x48c3f8=a378_0x5251;logger[_0x48c3f8('0x4d')](_0x1e1ed6[_0x48c3f8('0x60')]),_0x1e1ed6[_0x48c3f8('0x11')]&&delete _0x1e1ed6['name'],_0x2d248b[_0x48c3f8('0x6')](_0x1e430b)[_0x48c3f8('0x10')](_0x1e1ed6);};}exports[_0x4e23d1('0x2f')]=function(_0x43b538,_0x57e1bb){const _0x113541=_0x4e23d1;let _0x4b2173={};const _0x333148={},_0xa371a4={'count':0x0,'rows':[]},_0x4185a1=_[_0x113541('0x40')](db[_0x113541('0x21')][_0x113541('0x3e')],function(_0x38403b){const _0x315bc2=_0x113541;return{'name':_0x38403b[_0x315bc2('0x4f')],'type':_0x38403b[_0x315bc2('0x43')]['key']};});_0x333148[_0x113541('0x44')]=_[_0x113541('0x40')](_0x4185a1,_0x113541('0x11')),_0x333148[_0x113541('0x52')]=_[_0x113541('0x33')](_0x43b538[_0x113541('0x52')]),_0x333148[_0x113541('0x5b')]=_['intersection'](_0x333148[_0x113541('0x44')],_0x333148[_0x113541('0x52')]),_0x4b2173['attributes']=_[_0x113541('0x32')](_0x333148[_0x113541('0x44')],qs[_0x113541('0x4e')](_0x43b538['query'][_0x113541('0x4e')])),_0x4b2173[_0x113541('0x2b')]=_0x4b2173[_0x113541('0x2b')]['length']?_0x4b2173['attributes']:_0x333148[_0x113541('0x44')];typeof _0x43b538[_0x113541('0x52')][_0x113541('0x4b')]===_0x113541('0x4a')&&(_0x4b2173[_0x113541('0x29')]=qs[_0x113541('0x29')](_0x43b538['query'][_0x113541('0x29')]),_0x4b2173[_0x113541('0x3c')]=qs[_0x113541('0x3c')](_0x43b538[_0x113541('0x52')][_0x113541('0x3c')]));_0x4b2173['order']=qs[_0x113541('0x5e')](_0x43b538[_0x113541('0x52')]['sort']),_0x4b2173['where']=qs['filters'](_[_0x113541('0x57')](_0x43b538[_0x113541('0x52')],_0x333148[_0x113541('0x5b')]),_0x4185a1);_0x43b538[_0x113541('0x52')]['filter']&&(_0x4b2173[_0x113541('0xc')]=_['merge'](_0x4b2173[_0x113541('0xc')],{[Op['or']]:_['map'](_0x4185a1,function(_0xa03f94){const _0xd9d422=_0x113541;if(_0xa03f94[_0xd9d422('0x43')]!==_0xd9d422('0x37')){const _0x461f9a={};return _0x461f9a[_0xa03f94[_0xd9d422('0x11')]]={[Op[_0xd9d422('0x54')]]:'%'+_0x43b538['query'][_0xd9d422('0x22')]+'%'},_0x461f9a;}})}));_0x4b2173=_[_0x113541('0x16')]({},_0x4b2173,_0x43b538['options']);const _0x2685f3={'where':_0x4b2173[_0x113541('0xc')]};return db[_0x113541('0x21')][_0x113541('0x1')](_0x2685f3)['then'](function(_0x1de822){const _0x4223c5=_0x113541;return _0xa371a4['count']=_0x1de822,_0x43b538['query'][_0x4223c5('0x25')]&&(_0x4b2173['include']=[{'all':!![]}]),db[_0x4223c5('0x21')][_0x4223c5('0x5')](_0x4b2173);})[_0x113541('0x36')](function(_0x40d356){const _0x4edb84=_0x113541;return _0xa371a4[_0x4edb84('0x3d')]=_0x40d356,_0xa371a4;})['then'](respondWithFilteredResult(_0x57e1bb,_0x4b2173))['catch'](handleError(_0x57e1bb,null));},exports['show']=function(_0x4af3ac,_0xc49870){const _0x247c31=_0x4e23d1;let _0x56929a={'raw':![],'where':{'id':_0x4af3ac['params']['id']}};const _0x5eab27={};return _0x5eab27[_0x247c31('0x44')]=_[_0x247c31('0x33')](db[_0x247c31('0x21')]['rawAttributes']),_0x5eab27['query']=_['keys'](_0x4af3ac[_0x247c31('0x52')]),_0x5eab27[_0x247c31('0x5b')]=_[_0x247c31('0x32')](_0x5eab27['model'],_0x5eab27['query']),_0x56929a[_0x247c31('0x2b')]=_[_0x247c31('0x32')](_0x5eab27[_0x247c31('0x44')],qs[_0x247c31('0x4e')](_0x4af3ac[_0x247c31('0x52')][_0x247c31('0x4e')])),_0x56929a['attributes']=_0x56929a[_0x247c31('0x2b')][_0x247c31('0x42')]?_0x56929a[_0x247c31('0x2b')]:_0x5eab27[_0x247c31('0x44')],_0x4af3ac[_0x247c31('0x52')][_0x247c31('0x25')]&&(_0x56929a['include']=[{'all':!![]}]),_0x56929a=_[_0x247c31('0x16')]({},_0x56929a,_0x4af3ac[_0x247c31('0x17')]),db[_0x247c31('0x21')][_0x247c31('0x19')](_0x56929a)['then'](handleEntityNotFound(_0xc49870,null))[_0x247c31('0x36')](respondWithResult(_0xc49870,null))[_0x247c31('0x55')](handleError(_0xc49870,null));},exports[_0x4e23d1('0x28')]=function(_0x277ff4,_0x585b90){const _0x23c93e=_0x4e23d1;return db[_0x23c93e('0x21')][_0x23c93e('0x28')](_0x277ff4[_0x23c93e('0x48')],{})[_0x23c93e('0x36')](function(_0x3fa7c0){const _0x129b6c=_0x23c93e,_0x28e7ec=_0x277ff4[_0x129b6c('0x1f')]['get']({'plain':!![]});if(!_0x28e7ec)throw new Error(_0x129b6c('0x12'));if(_0x28e7ec['role']===_0x129b6c('0x1f')){const _0x47b38e=_0x3fa7c0[_0x129b6c('0x13')]({'plain':!![]}),_0x2ad53d=_0x129b6c('0x1d');return db[_0x129b6c('0x0')][_0x129b6c('0x19')]({'where':{'name':_0x2ad53d,'userProfileId':_0x28e7ec[_0x129b6c('0x15')]},'raw':!![]})[_0x129b6c('0x36')](function(_0x377417){const _0x407858=_0x129b6c;return _0x377417&&_0x377417[_0x407858('0x5c')]===0x0?db['UserProfileResource'][_0x407858('0x28')]({'name':_0x47b38e[_0x407858('0x11')],'resourceId':_0x47b38e['id'],'type':_0x377417[_0x407858('0x11')],'sectionId':_0x377417['id']},{})[_0x407858('0x36')](function(){return _0x3fa7c0;}):_0x3fa7c0;})[_0x129b6c('0x55')](function(_0x13799f){const _0x500d89=_0x129b6c;logger['error'](_0x500d89('0x20'),_0x13799f);throw _0x13799f;});}return _0x3fa7c0;})[_0x23c93e('0x36')](respondWithResult(_0x585b90,0xc9))[_0x23c93e('0x55')](handleError(_0x585b90,null));},exports[_0x4e23d1('0x51')]=function(_0x17cd55,_0x45451f){const _0x1af5e8=_0x4e23d1;let _0x5ad7cc={'where':{'id':_0x17cd55['params']['id']}};const _0x3410b2={};return _0x3410b2[_0x1af5e8('0x44')]=_[_0x1af5e8('0x33')](db[_0x1af5e8('0x21')]['rawAttributes']),_0x5ad7cc[_0x1af5e8('0x2b')]=_[_0x1af5e8('0x32')](_0x3410b2['model'],qs[_0x1af5e8('0x4e')](_0x17cd55[_0x1af5e8('0x52')][_0x1af5e8('0x4e')])),_0x5ad7cc[_0x1af5e8('0x2b')]=_0x5ad7cc[_0x1af5e8('0x2b')]['length']?_0x5ad7cc['attributes']:_0x3410b2[_0x1af5e8('0x44')],_0x17cd55[_0x1af5e8('0x52')][_0x1af5e8('0x25')]&&(_0x5ad7cc[_0x1af5e8('0x49')]=[{'all':!![]}]),_0x5ad7cc=_[_0x1af5e8('0x16')]({},_0x5ad7cc,_0x17cd55[_0x1af5e8('0x17')]),db[_0x1af5e8('0x21')][_0x1af5e8('0x19')](_0x5ad7cc)['then'](handleEntityNotFound(_0x45451f,null))[_0x1af5e8('0x36')](function(_0x1f9b38){const _0x5afebf=_0x1af5e8;if(_0x1f9b38){let _0x321b4f=_0x1f9b38[_0x5afebf('0x13')]({'plain':!![]});return _0x321b4f=qs[_0x5afebf('0x35')](_0x321b4f,['id',_0x5afebf('0x9'),_0x5afebf('0x26')]),_0x17cd55[_0x5afebf('0x48')]=_['omit'](_0x17cd55[_0x5afebf('0x48')],['id',_0x5afebf('0x9'),_0x5afebf('0x26')]),db[_0x5afebf('0x21')]['create'](_[_0x5afebf('0x16')](_0x321b4f,_0x17cd55[_0x5afebf('0x48')]),{'include':_0x17cd55[_0x5afebf('0x52')][_0x5afebf('0x25')]?[{'all':!![]}]:undefined})[_0x5afebf('0x36')](function(_0x4aaf55){const _0x506bf3=_0x5afebf,_0x137207=_0x17cd55[_0x506bf3('0x1f')][_0x506bf3('0x13')]({'plain':!![]});if(!_0x137207)throw new Error(_0x506bf3('0x12'));if(_0x137207[_0x506bf3('0xe')]==='user'){const _0x46f9e5=_0x4aaf55[_0x506bf3('0x13')]({'plain':!![]}),_0x468168='Projects';return db[_0x506bf3('0x0')][_0x506bf3('0x19')]({'where':{'name':_0x468168,'userProfileId':_0x137207[_0x506bf3('0x15')]},'raw':!![]})[_0x506bf3('0x36')](function(_0x437d15){const _0x136145=_0x506bf3;return _0x437d15&&_0x437d15[_0x136145('0x5c')]===0x0?db[_0x136145('0x8')][_0x136145('0x28')]({'name':_0x46f9e5['name'],'resourceId':_0x46f9e5['id'],'type':_0x437d15[_0x136145('0x11')],'sectionId':_0x437d15['id']},{})[_0x136145('0x36')](function(){return _0x4aaf55;}):_0x4aaf55;})['catch'](function(_0x1ae75b){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x1ae75b);throw _0x1ae75b;});}return _0x4aaf55;});}})[_0x1af5e8('0x36')](respondWithResult(_0x45451f,0xc9))[_0x1af5e8('0x55')](handleError(_0x45451f,null));},exports[_0x4e23d1('0x7')]=function(_0xece735,_0xf086b0){const _0x289be0=_0x4e23d1;return _0xece735['body']['id']&&delete _0xece735[_0x289be0('0x48')]['id'],db[_0x289be0('0x21')][_0x289be0('0x19')]({'where':{'id':_0xece735[_0x289be0('0x1e')]['id']}})[_0x289be0('0x36')](handleEntityNotFound(_0xf086b0,null))[_0x289be0('0x36')](saveUpdates(_0xece735[_0x289be0('0x48')],null))[_0x289be0('0x36')](respondWithResult(_0xf086b0,null))[_0x289be0('0x55')](handleError(_0xf086b0,null));},exports[_0x4e23d1('0x18')]=function(_0x4ab924,_0x42f40f){const _0x40d121=_0x4e23d1;return db[_0x40d121('0x21')][_0x40d121('0x19')]({'where':{'id':_0x4ab924[_0x40d121('0x1e')]['id']}})[_0x40d121('0x36')](handleEntityNotFound(_0x42f40f,null))['then'](removeEntity(_0x42f40f,null))[_0x40d121('0x55')](handleError(_0x42f40f,null));},exports[_0x4e23d1('0x27')]=function(_0xcbe842,_0x1bee55){const _0xfc29cb=_0x4e23d1;let _0x155bf4={'raw':!![],'where':{}};const _0x2713ce={},_0x5cd9fd={'count':0x0,'rows':[]};return db[_0xfc29cb('0x21')][_0xfc29cb('0x19')]({'where':{'id':_0xcbe842[_0xfc29cb('0x1e')]['id']}})[_0xfc29cb('0x36')](handleEntityNotFound(_0x1bee55,null))['then'](function(_0x5a5f3e){const _0x16166f=_0xfc29cb;if(_0x5a5f3e)return _0x2713ce['model']=_[_0x16166f('0x33')](db['JscriptySessionReport'][_0x16166f('0x3e')]),_0x2713ce[_0x16166f('0x52')]=_['keys'](_0xcbe842[_0x16166f('0x52')]),_0x2713ce[_0x16166f('0x5b')]=_['intersection'](_0x2713ce['model'],_0x2713ce['query']),_0x155bf4[_0x16166f('0x2b')]=_[_0x16166f('0x32')](_0x2713ce[_0x16166f('0x44')],qs[_0x16166f('0x4e')](_0xcbe842[_0x16166f('0x52')][_0x16166f('0x4e')])),_0x155bf4[_0x16166f('0x2b')]=_0x155bf4[_0x16166f('0x2b')][_0x16166f('0x42')]?_0x155bf4[_0x16166f('0x2b')]:_0x2713ce[_0x16166f('0x44')],typeof _0xcbe842[_0x16166f('0x52')][_0x16166f('0x4b')]===_0x16166f('0x4a')&&(_0x155bf4[_0x16166f('0x29')]=qs[_0x16166f('0x29')](_0xcbe842['query'][_0x16166f('0x29')]),_0x155bf4[_0x16166f('0x3c')]=qs['offset'](_0xcbe842['query'][_0x16166f('0x3c')])),_0x155bf4[_0x16166f('0x24')]=qs[_0x16166f('0x5e')](_0xcbe842[_0x16166f('0x52')][_0x16166f('0x5e')]),_0x155bf4[_0x16166f('0xc')]=qs[_0x16166f('0x5b')](_['pick'](_0xcbe842[_0x16166f('0x52')],_0x2713ce[_0x16166f('0x5b')])),_0x155bf4[_0x16166f('0xc')][_0x16166f('0x31')]=_0x5a5f3e['id'],_0xcbe842['query']['filter']&&(_0x155bf4[_0x16166f('0xc')]=_['merge'](_0x155bf4['where'],{[Op['or']]:_[_0x16166f('0x40')](_0x155bf4[_0x16166f('0x2b')],function(_0x3b0e2e){const _0x59df9b=_0x16166f,_0x288679={};return _0x288679[_0x3b0e2e]={[Op['like']]:'%'+_0xcbe842[_0x59df9b('0x52')]['filter']+'%'},_0x288679;})})),_0x155bf4=_[_0x16166f('0x16')]({},_0x155bf4,_0xcbe842[_0x16166f('0x17')]),db[_0x16166f('0x5f')][_0x16166f('0x1')]({'where':_0x155bf4[_0x16166f('0xc')]})[_0x16166f('0x36')](function(_0x2a48d8){const _0xc64181=_0x16166f;return _0x5cd9fd[_0xc64181('0x1')]=_0x2a48d8,_0xcbe842[_0xc64181('0x52')][_0xc64181('0x25')]&&(_0x155bf4['include']=[{'all':!![]}]),db['JscriptySessionReport'][_0xc64181('0x5')](_0x155bf4);})[_0x16166f('0x36')](function(_0x34e925){const _0x1202e3=_0x16166f;return _0x5cd9fd[_0x1202e3('0x3d')]=_0x34e925,_0x5cd9fd;});})[_0xfc29cb('0x36')](respondWithFilteredResult(_0x1bee55,_0x155bf4))[_0xfc29cb('0x55')](handleError(_0x1bee55,null));},exports[_0x4e23d1('0x3f')]=function(_0x2f4b57,_0x476322){const _0x4a73e9=_0x4e23d1;let _0x905c04={'raw':!![],'where':{}};const _0x1e8d3f={},_0x26b2db={'count':0x0,'rows':[]};return db[_0x4a73e9('0x21')][_0x4a73e9('0x19')]({'where':{'id':_0x2f4b57['params']['id']}})[_0x4a73e9('0x36')](handleEntityNotFound(_0x476322,null))[_0x4a73e9('0x36')](function(_0x3f6df3){const _0x4f7ad4=_0x4a73e9;if(_0x3f6df3)return _0x1e8d3f[_0x4f7ad4('0x44')]=_[_0x4f7ad4('0x33')](db[_0x4f7ad4('0xf')][_0x4f7ad4('0x3e')]),_0x1e8d3f['query']=_[_0x4f7ad4('0x33')](_0x2f4b57[_0x4f7ad4('0x52')]),_0x1e8d3f[_0x4f7ad4('0x5b')]=_[_0x4f7ad4('0x32')](_0x1e8d3f[_0x4f7ad4('0x44')],_0x1e8d3f[_0x4f7ad4('0x52')]),_0x905c04['attributes']=_[_0x4f7ad4('0x32')](_0x1e8d3f[_0x4f7ad4('0x44')],qs['fields'](_0x2f4b57[_0x4f7ad4('0x52')][_0x4f7ad4('0x4e')])),_0x905c04[_0x4f7ad4('0x2b')]=_0x905c04[_0x4f7ad4('0x2b')]['length']?_0x905c04[_0x4f7ad4('0x2b')]:_0x1e8d3f[_0x4f7ad4('0x44')],typeof _0x2f4b57[_0x4f7ad4('0x52')][_0x4f7ad4('0x4b')]===_0x4f7ad4('0x4a')&&(_0x905c04[_0x4f7ad4('0x29')]=qs[_0x4f7ad4('0x29')](_0x2f4b57['query'][_0x4f7ad4('0x29')]),_0x905c04[_0x4f7ad4('0x3c')]=qs[_0x4f7ad4('0x3c')](_0x2f4b57[_0x4f7ad4('0x52')][_0x4f7ad4('0x3c')])),_0x905c04[_0x4f7ad4('0x24')]=qs[_0x4f7ad4('0x5e')](_0x2f4b57['query'][_0x4f7ad4('0x5e')]),_0x905c04[_0x4f7ad4('0xc')]=qs[_0x4f7ad4('0x5b')](_[_0x4f7ad4('0x57')](_0x2f4b57[_0x4f7ad4('0x52')],_0x1e8d3f[_0x4f7ad4('0x5b')])),_0x905c04[_0x4f7ad4('0xc')][_0x4f7ad4('0x31')]=_0x3f6df3['id'],_0x2f4b57[_0x4f7ad4('0x52')][_0x4f7ad4('0x22')]&&(_0x905c04[_0x4f7ad4('0xc')]=_[_0x4f7ad4('0x16')](_0x905c04[_0x4f7ad4('0xc')],{[Op['or']]:_['map'](_0x905c04[_0x4f7ad4('0x2b')],function(_0x200b72){const _0x540e6f=_0x4f7ad4,_0x4b9825={};return _0x4b9825[_0x200b72]={[Op['like']]:'%'+_0x2f4b57[_0x540e6f('0x52')]['filter']+'%'},_0x4b9825;})})),_0x905c04=_[_0x4f7ad4('0x16')]({},_0x905c04,_0x2f4b57[_0x4f7ad4('0x17')]),db[_0x4f7ad4('0xf')][_0x4f7ad4('0x1')]({'where':_0x905c04[_0x4f7ad4('0xc')]})[_0x4f7ad4('0x36')](function(_0xefacaa){const _0x3b1606=_0x4f7ad4;return _0x26b2db[_0x3b1606('0x1')]=_0xefacaa,_0x2f4b57[_0x3b1606('0x52')][_0x3b1606('0x25')]&&(_0x905c04['include']=[{'all':!![]}]),db[_0x3b1606('0xf')][_0x3b1606('0x5')](_0x905c04);})[_0x4f7ad4('0x36')](function(_0x2123b0){return _0x26b2db['rows']=_0x2123b0,_0x26b2db;});})[_0x4a73e9('0x36')](respondWithFilteredResult(_0x476322,_0x905c04))[_0x4a73e9('0x55')](handleError(_0x476322,null));};function char(_0x2bb959){const _0x55552f=_0x4e23d1;return _0x55552f('0x38')===typeof _0x2bb959?String[_0x55552f('0x30')][_0x55552f('0x2e')](null,arguments):_0x2bb959;}function needsEncapsulation(_0x6fc2e7){const _0x109a1c=_0x4e23d1;return!!_0x6fc2e7&&(_0x6fc2e7[_0x109a1c('0x1b')]()[_0x109a1c('0x2d')](char(0xd))>=0x0||_0x6fc2e7[_0x109a1c('0x1b')]()[_0x109a1c('0x2d')](char(0xa))>=0x0||_0x6fc2e7[_0x109a1c('0x1b')]()['indexOf'](char(0x2c))>=0x0||_0x6fc2e7[_0x109a1c('0x1b')]()['indexOf'](char(0x22))>=0x0);}function encapsulate(_0x3bb5a9){const _0x1c25de=_0x4e23d1,_0x193cb5=char(0x22),_0x1c03dc='\x5c'+char(0x22),_0x138300=_0x3bb5a9['toString']()[_0x1c25de('0x1c')](new RegExp(_0x193cb5,'g'),_0x1c03dc);return _0x193cb5+_0x138300+_0x193cb5;}exports['getSummary']=function(_0x202a52,_0xa640d0){const _0x56e13e=_0x4e23d1;let _0x118ee9,_0x42afa5;const _0x3eef00={'where':{'ProjectId':_0x202a52[_0x56e13e('0x1e')]['id']}};return _0x202a52['query']['startTime']&&(_0x3eef00[_0x56e13e('0xc')][_0x56e13e('0x1a')]=JSON[_0x56e13e('0x5a')](_0x202a52[_0x56e13e('0x52')][_0x56e13e('0x3a')])),db[_0x56e13e('0x5f')][_0x56e13e('0x5')](_0x3eef00)[_0x56e13e('0x36')](handleEntityNotFound(_0xa640d0,null))[_0x56e13e('0x36')](function(_0x2a9d3f){const _0x20a5da=_0x56e13e;if(_0x2a9d3f)return _0x118ee9=_0x2a9d3f,db[_0x20a5da('0x3b')]['findAll']({'where':{'SessionId':{[Op['in']]:_[_0x20a5da('0x40')](_0x118ee9,'id')},'ProjectId':_0x202a52[_0x20a5da('0x1e')]['id']},'order':_0x20a5da('0x14')});})[_0x56e13e('0x36')](handleEntityNotFound(_0xa640d0,null))[_0x56e13e('0x36')](function(_0x3ee8ee){const _0x4f8bf5=_0x56e13e;if(_0x3ee8ee){_0x42afa5=_0x3ee8ee;const _0x6c3bf7={};for(let _0x112ed4=0x0,_0x2201f5=_0x42afa5[_0x4f8bf5('0x42')];_0x112ed4<_0x2201f5;_0x112ed4++){typeof _0x6c3bf7[_0x42afa5[_0x112ed4][_0x4f8bf5('0x53')]]===_0x4f8bf5('0x4a')&&(_0x6c3bf7[_0x42afa5[_0x112ed4][_0x4f8bf5('0x53')]]=needsEncapsulation(_0x42afa5[_0x112ed4][_0x4f8bf5('0x56')])?encapsulate(_0x42afa5[_0x112ed4][_0x4f8bf5('0x56')]):_0x42afa5[_0x112ed4][_0x4f8bf5('0x56')]);}const _0x51627e=[];let _0x591485={};for(let _0x3136d1=0x0,_0x36b343=_0x118ee9[_0x4f8bf5('0x42')];_0x3136d1<_0x36b343;_0x3136d1++){_0x591485={'ProjectId':_0x202a52[_0x4f8bf5('0x1e')]['id'],'SessionId':_0x118ee9[_0x3136d1]['id'],'StartTime':moment(_0x118ee9[_0x3136d1][_0x4f8bf5('0x1a')])[_0x4f8bf5('0x23')]('YYYY-MM-DD\x20HH:mm:ss')};for(let _0x200d2b=0x0,_0x440ebf=_0x42afa5[_0x4f8bf5('0x42')];_0x200d2b<_0x440ebf;_0x200d2b++){_0x42afa5[_0x200d2b]['SessionId']===_0x118ee9[_0x3136d1]['id']&&typeof _0x6c3bf7[_0x42afa5[_0x200d2b][_0x4f8bf5('0x53')]]!==_0x4f8bf5('0x4a')&&(_0x591485[_0x6c3bf7[_0x42afa5[_0x200d2b][_0x4f8bf5('0x53')]]]=_0x42afa5[_0x200d2b][_0x4f8bf5('0x47')]);}for(const _0x482fdc in _0x6c3bf7){typeof _0x591485[_0x6c3bf7[_0x482fdc]]===_0x4f8bf5('0x4a')&&(_0x591485[_0x6c3bf7[_0x482fdc]]=null);}_0x51627e[_0x4f8bf5('0x2c')](_0x591485);}return _0x51627e;}})['then'](function(_0xc5471a){const _0x52e558=_0x56e13e;if(!_[_0x52e558('0x3')](_0xc5471a)){const _0x2a8e8c=toCsv(_0xc5471a),_0x4815f6=Date['now']();return fs['writeFileSync'](util['format']('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x202a52['params']['id'],_0x4815f6),_0x2a8e8c),_0xa640d0[_0x52e558('0xa')](_0x52e558('0x45'),'attachment;\x20filename='+util[_0x52e558('0x23')](_0x52e558('0x50'),_0x202a52[_0x52e558('0x1e')]['id'],_0x4815f6)),_0xa640d0[_0x52e558('0xa')](_0x52e558('0x39'),'text/csv'),_0xa640d0[_0x52e558('0x4c')](util[_0x52e558('0x23')]('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x202a52[_0x52e558('0x1e')]['id'],_0x4815f6));}else return _0xa640d0[_0x52e558('0x2')](0xcc);})['catch'](handleError(_0xa640d0,null));};