// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x2396=['filters','intersection','attributes','fields','length','hasOwnProperty','sort','where','VIRTUAL','filter','merge','includeAll','include','findAll','rows','params','rawAttributes','options','find','catch','create','body','role','user','Projects','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','omit','createdAt','updatedAt','error','getSessions','nolimit','JscriptySessionReport','getAnswers','findOne','JscriptyAnswerReport','order','pick','number','fromCharCode','indexOf','toString','getSummary','startTime','parse','JscriptyQuestionReport','-createdAt','question','format','YYYY-MM-DD\x20HH:mm:ss','SessionId','questionId','answer','push','isEmpty','writeFileSync','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','Content-disposition','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','text/csv','eml-format','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','sox','to-csv','fs-extra','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','json','offset','limit','undefined','count','set','Content-Range','apply','reject','save','update','then','get','destroy','end','stack','name','index','map','JscriptyProject','fieldName','type','model','query','keys'];(function(_0x378ca8,_0x4502d8){var _0x2a0fe7=function(_0x241f8c){while(--_0x241f8c){_0x378ca8['push'](_0x378ca8['shift']());}};_0x2a0fe7(++_0x4502d8);}(_0x2396,0xb9));var _0x6239=function(_0x16dbcd,_0x274516){_0x16dbcd=_0x16dbcd-0x0;var _0x34706e=_0x2396[_0x16dbcd];return _0x34706e;};'use strict';var emlformat=require(_0x6239('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x6239('0x1'));var jsonpatch=require(_0x6239('0x2'));var rp=require(_0x6239('0x3'));var moment=require(_0x6239('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x6239('0x5'));var util=require(_0x6239('0x6'));var path=require(_0x6239('0x7'));var sox=require(_0x6239('0x8'));var csv=require(_0x6239('0x9'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x6239('0xa'));var _=require(_0x6239('0xb'));var squel=require('squel');var crypto=require(_0x6239('0xc'));var jsforce=require(_0x6239('0xd'));var deskjs=require(_0x6239('0xe'));var toCsv=require(_0x6239('0x9'));var querystring=require(_0x6239('0xf'));var Papa=require(_0x6239('0x10'));var Redis=require(_0x6239('0x11'));var authService=require('../../components/auth/service');var qs=require(_0x6239('0x12'));var as=require(_0x6239('0x13'));var hardwareService=require(_0x6239('0x14'));var logger=require('../../config/logger')(_0x6239('0x15'));var utils=require(_0x6239('0x16'));var config=require(_0x6239('0x17'));var licenseUtil=require(_0x6239('0x18'));var db=require(_0x6239('0x19'))['db'];function respondWithStatusCode(_0x1da6bd,_0x629a5e){_0x629a5e=_0x629a5e||0xcc;return function(_0x598003){if(_0x598003){return _0x1da6bd[_0x6239('0x1a')](_0x629a5e);}return _0x1da6bd[_0x6239('0x1b')](_0x629a5e)['end']();};}function respondWithResult(_0x42804f,_0x34a34b){_0x34a34b=_0x34a34b||0xc8;return function(_0x156283){if(_0x156283){return _0x42804f[_0x6239('0x1b')](_0x34a34b)[_0x6239('0x1c')](_0x156283);}};}function respondWithFilteredResult(_0x5111ae,_0x484ba2){return function(_0xa09487){if(_0xa09487){var _0xb5ea1b=typeof _0x484ba2[_0x6239('0x1d')]==='undefined'&&typeof _0x484ba2[_0x6239('0x1e')]===_0x6239('0x1f');var _0x51e317=_0xa09487[_0x6239('0x20')];var _0x1f2662=_0xb5ea1b?0x0:_0x484ba2['offset'];var _0x4eb829=_0xb5ea1b?_0xa09487[_0x6239('0x20')]:_0x484ba2[_0x6239('0x1d')]+_0x484ba2[_0x6239('0x1e')];var _0x28db33;if(_0x4eb829>=_0x51e317){_0x4eb829=_0x51e317;_0x28db33=0xc8;}else{_0x28db33=0xce;}_0x5111ae[_0x6239('0x1b')](_0x28db33);return _0x5111ae[_0x6239('0x21')](_0x6239('0x22'),_0x1f2662+'-'+_0x4eb829+'/'+_0x51e317)[_0x6239('0x1c')](_0xa09487);}return null;};}function patchUpdates(_0xa58b49){return function(_0x3076d0){try{jsonpatch[_0x6239('0x23')](_0x3076d0,_0xa58b49,!![]);}catch(_0x4b8fb4){return BPromise[_0x6239('0x24')](_0x4b8fb4);}return _0x3076d0[_0x6239('0x25')]();};}function saveUpdates(_0x5a53f7,_0x568ce4){return function(_0x26ecc1){if(_0x26ecc1){return _0x26ecc1[_0x6239('0x26')](_0x5a53f7)[_0x6239('0x27')](function(_0x5822c1){return _0x5822c1;});}return null;};}function removeEntity(_0x28d10c,_0x45dcff){return function(_0xca5c8b){if(_0xca5c8b){return _0xca5c8b['destroy']()[_0x6239('0x27')](function(){var _0x185a5f=_0xca5c8b[_0x6239('0x28')]({'plain':!![]});var _0x17d969='Projects';return db['UserProfileResource'][_0x6239('0x29')]({'where':{'type':_0x17d969,'resourceId':_0x185a5f['id']}})[_0x6239('0x27')](function(){return _0xca5c8b;});})[_0x6239('0x27')](function(){_0x28d10c['status'](0xcc)[_0x6239('0x2a')]();});}};}function handleEntityNotFound(_0x5ca2d6,_0x4cc5f9){return function(_0xb0ae16){if(!_0xb0ae16){_0x5ca2d6['sendStatus'](0x194);}return _0xb0ae16;};}function handleError(_0x2c4832,_0xa7a68d){_0xa7a68d=_0xa7a68d||0x1f4;return function(_0x262c52){logger['error'](_0x262c52[_0x6239('0x2b')]);if(_0x262c52[_0x6239('0x2c')]){delete _0x262c52[_0x6239('0x2c')];}_0x2c4832[_0x6239('0x1b')](_0xa7a68d)['send'](_0x262c52);};}exports[_0x6239('0x2d')]=function(_0x7e5aaf,_0x41b030){var _0x2c0c6f={},_0x31eb2a={},_0x1c9014={'count':0x0,'rows':[]};var _0x345bd9=_[_0x6239('0x2e')](db[_0x6239('0x2f')]['rawAttributes'],function(_0x360735){return{'name':_0x360735[_0x6239('0x30')],'type':_0x360735[_0x6239('0x31')]['key']};});_0x31eb2a[_0x6239('0x32')]=_[_0x6239('0x2e')](_0x345bd9,'name');_0x31eb2a[_0x6239('0x33')]=_[_0x6239('0x34')](_0x7e5aaf[_0x6239('0x33')]);_0x31eb2a[_0x6239('0x35')]=_[_0x6239('0x36')](_0x31eb2a['model'],_0x31eb2a['query']);_0x2c0c6f[_0x6239('0x37')]=_['intersection'](_0x31eb2a['model'],qs[_0x6239('0x38')](_0x7e5aaf[_0x6239('0x33')][_0x6239('0x38')]));_0x2c0c6f[_0x6239('0x37')]=_0x2c0c6f['attributes'][_0x6239('0x39')]?_0x2c0c6f['attributes']:_0x31eb2a[_0x6239('0x32')];if(!_0x7e5aaf['query'][_0x6239('0x3a')]('nolimit')){_0x2c0c6f[_0x6239('0x1e')]=qs[_0x6239('0x1e')](_0x7e5aaf[_0x6239('0x33')][_0x6239('0x1e')]);_0x2c0c6f['offset']=qs[_0x6239('0x1d')](_0x7e5aaf['query'][_0x6239('0x1d')]);}_0x2c0c6f['order']=qs[_0x6239('0x3b')](_0x7e5aaf[_0x6239('0x33')][_0x6239('0x3b')]);_0x2c0c6f['where']=qs[_0x6239('0x35')](_['pick'](_0x7e5aaf[_0x6239('0x33')],_0x31eb2a[_0x6239('0x35')]),_0x345bd9);if(_0x7e5aaf[_0x6239('0x33')]['filter']){_0x2c0c6f['where']=_['merge'](_0x2c0c6f[_0x6239('0x3c')],{'$or':_[_0x6239('0x2e')](_0x345bd9,function(_0x4834d7){if(_0x4834d7[_0x6239('0x31')]!==_0x6239('0x3d')){var _0x472f25={};_0x472f25[_0x4834d7[_0x6239('0x2c')]]={'$like':'%'+_0x7e5aaf[_0x6239('0x33')][_0x6239('0x3e')]+'%'};return _0x472f25;}})});}_0x2c0c6f=_[_0x6239('0x3f')]({},_0x2c0c6f,_0x7e5aaf['options']);var _0x1d3476={'where':_0x2c0c6f[_0x6239('0x3c')]};return db[_0x6239('0x2f')]['count'](_0x1d3476)[_0x6239('0x27')](function(_0x106eb5){_0x1c9014[_0x6239('0x20')]=_0x106eb5;if(_0x7e5aaf[_0x6239('0x33')][_0x6239('0x40')]){_0x2c0c6f[_0x6239('0x41')]=[{'all':!![]}];}return db[_0x6239('0x2f')][_0x6239('0x42')](_0x2c0c6f);})['then'](function(_0x199556){_0x1c9014[_0x6239('0x43')]=_0x199556;return _0x1c9014;})[_0x6239('0x27')](respondWithFilteredResult(_0x41b030,_0x2c0c6f))['catch'](handleError(_0x41b030,null));};exports['show']=function(_0x526237,_0x22d54f){var _0x5ac556={'raw':![],'where':{'id':_0x526237[_0x6239('0x44')]['id']}},_0x17258a={};_0x17258a['model']=_[_0x6239('0x34')](db[_0x6239('0x2f')][_0x6239('0x45')]);_0x17258a[_0x6239('0x33')]=_['keys'](_0x526237['query']);_0x17258a[_0x6239('0x35')]=_[_0x6239('0x36')](_0x17258a[_0x6239('0x32')],_0x17258a['query']);_0x5ac556[_0x6239('0x37')]=_[_0x6239('0x36')](_0x17258a[_0x6239('0x32')],qs['fields'](_0x526237['query']['fields']));_0x5ac556['attributes']=_0x5ac556[_0x6239('0x37')][_0x6239('0x39')]?_0x5ac556['attributes']:_0x17258a[_0x6239('0x32')];if(_0x526237[_0x6239('0x33')][_0x6239('0x40')]){_0x5ac556[_0x6239('0x41')]=[{'all':!![]}];}_0x5ac556=_[_0x6239('0x3f')]({},_0x5ac556,_0x526237[_0x6239('0x46')]);return db[_0x6239('0x2f')][_0x6239('0x47')](_0x5ac556)[_0x6239('0x27')](handleEntityNotFound(_0x22d54f,null))[_0x6239('0x27')](respondWithResult(_0x22d54f,null))[_0x6239('0x48')](handleError(_0x22d54f,null));};exports[_0x6239('0x49')]=function(_0x98da5a,_0x5c7a92){return db[_0x6239('0x2f')][_0x6239('0x49')](_0x98da5a[_0x6239('0x4a')],{})[_0x6239('0x27')](function(_0xa90e11){var _0x5b876b=_0x98da5a['user'][_0x6239('0x28')]({'plain':!![]});if(!_0x5b876b)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x5b876b[_0x6239('0x4b')]===_0x6239('0x4c')){var _0x2f64a1=_0xa90e11[_0x6239('0x28')]({'plain':!![]});var _0x3c2915=_0x6239('0x4d');return db[_0x6239('0x4e')][_0x6239('0x47')]({'where':{'name':_0x3c2915,'userProfileId':_0x5b876b[_0x6239('0x4f')]},'raw':!![]})[_0x6239('0x27')](function(_0x18140b){if(_0x18140b&&_0x18140b[_0x6239('0x50')]===0x0){return db[_0x6239('0x51')][_0x6239('0x49')]({'name':_0x2f64a1['name'],'resourceId':_0x2f64a1['id'],'type':_0x18140b[_0x6239('0x2c')],'sectionId':_0x18140b['id']},{})['then'](function(){return _0xa90e11;});}else{return _0xa90e11;}})[_0x6239('0x48')](function(_0x5996ca){logger['error'](_0x6239('0x52'),_0x5996ca);throw _0x5996ca;});}return _0xa90e11;})[_0x6239('0x27')](respondWithResult(_0x5c7a92,0xc9))['catch'](handleError(_0x5c7a92,null));};exports['clone']=function(_0x50665a,_0x2eff58){var _0x40c43d={'where':{'id':_0x50665a[_0x6239('0x44')]['id']}},_0x48e5e7={};_0x48e5e7[_0x6239('0x32')]=_[_0x6239('0x34')](db[_0x6239('0x2f')][_0x6239('0x45')]);_0x40c43d[_0x6239('0x37')]=_[_0x6239('0x36')](_0x48e5e7['model'],qs[_0x6239('0x38')](_0x50665a[_0x6239('0x33')][_0x6239('0x38')]));_0x40c43d[_0x6239('0x37')]=_0x40c43d[_0x6239('0x37')][_0x6239('0x39')]?_0x40c43d[_0x6239('0x37')]:_0x48e5e7['model'];if(_0x50665a[_0x6239('0x33')][_0x6239('0x40')]){_0x40c43d[_0x6239('0x41')]=[{'all':!![]}];}_0x40c43d=_['merge']({},_0x40c43d,_0x50665a[_0x6239('0x46')]);return db[_0x6239('0x2f')][_0x6239('0x47')](_0x40c43d)[_0x6239('0x27')](handleEntityNotFound(_0x2eff58,null))[_0x6239('0x27')](function(_0x2facb2){if(_0x2facb2){var _0x350d1e=_0x2facb2[_0x6239('0x28')]({'plain':!![]});_0x350d1e=qs[_0x6239('0x53')](_0x350d1e,['id',_0x6239('0x54'),_0x6239('0x55')]);_0x50665a[_0x6239('0x4a')]=_[_0x6239('0x53')](_0x50665a[_0x6239('0x4a')],['id',_0x6239('0x54'),'updatedAt']);return db[_0x6239('0x2f')][_0x6239('0x49')](_[_0x6239('0x3f')](_0x350d1e,_0x50665a[_0x6239('0x4a')]),{'include':_0x50665a['query']['includeAll']?[{'all':!![]}]:undefined})[_0x6239('0x27')](function(_0x341891){var _0xa96cf=_0x50665a[_0x6239('0x4c')][_0x6239('0x28')]({'plain':!![]});if(!_0xa96cf)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0xa96cf['role']==='user'){var _0x3015d4=_0x341891[_0x6239('0x28')]({'plain':!![]});var _0x111d44=_0x6239('0x4d');return db[_0x6239('0x4e')]['find']({'where':{'name':_0x111d44,'userProfileId':_0xa96cf[_0x6239('0x4f')]},'raw':!![]})[_0x6239('0x27')](function(_0x50a747){if(_0x50a747&&_0x50a747[_0x6239('0x50')]===0x0){return db[_0x6239('0x51')][_0x6239('0x49')]({'name':_0x3015d4[_0x6239('0x2c')],'resourceId':_0x3015d4['id'],'type':_0x50a747[_0x6239('0x2c')],'sectionId':_0x50a747['id']},{})['then'](function(){return _0x341891;});}else{return _0x341891;}})[_0x6239('0x48')](function(_0x38aeae){logger[_0x6239('0x56')](_0x6239('0x52'),_0x38aeae);throw _0x38aeae;});}return _0x341891;});}})[_0x6239('0x27')](respondWithResult(_0x2eff58,0xc9))[_0x6239('0x48')](handleError(_0x2eff58,null));};exports[_0x6239('0x26')]=function(_0xbfe3c1,_0x2394e8){if(_0xbfe3c1[_0x6239('0x4a')]['id']){delete _0xbfe3c1[_0x6239('0x4a')]['id'];}return db[_0x6239('0x2f')]['find']({'where':{'id':_0xbfe3c1[_0x6239('0x44')]['id']}})['then'](handleEntityNotFound(_0x2394e8,null))['then'](saveUpdates(_0xbfe3c1[_0x6239('0x4a')],null))['then'](respondWithResult(_0x2394e8,null))[_0x6239('0x48')](handleError(_0x2394e8,null));};exports[_0x6239('0x29')]=function(_0x4d1a7b,_0x3cd0a7){return db[_0x6239('0x2f')]['find']({'where':{'id':_0x4d1a7b['params']['id']}})[_0x6239('0x27')](handleEntityNotFound(_0x3cd0a7,null))[_0x6239('0x27')](removeEntity(_0x3cd0a7,null))[_0x6239('0x48')](handleError(_0x3cd0a7,null));};exports[_0x6239('0x57')]=function(_0x398ae4,_0x41a53d,_0x5e6834){var _0x146840={'raw':!![],'where':{}};var _0x2c41a5={};var _0x8e0a59={'count':0x0,'rows':[]};return db[_0x6239('0x2f')]['findOne']({'where':{'id':_0x398ae4['params']['id']}})[_0x6239('0x27')](handleEntityNotFound(_0x41a53d,null))[_0x6239('0x27')](function(_0x5f2174){if(_0x5f2174){_0x2c41a5[_0x6239('0x32')]=_[_0x6239('0x34')](db['JscriptySessionReport'][_0x6239('0x45')]);_0x2c41a5[_0x6239('0x33')]=_['keys'](_0x398ae4[_0x6239('0x33')]);_0x2c41a5[_0x6239('0x35')]=_[_0x6239('0x36')](_0x2c41a5['model'],_0x2c41a5['query']);_0x146840[_0x6239('0x37')]=_[_0x6239('0x36')](_0x2c41a5[_0x6239('0x32')],qs[_0x6239('0x38')](_0x398ae4['query'][_0x6239('0x38')]));_0x146840[_0x6239('0x37')]=_0x146840[_0x6239('0x37')][_0x6239('0x39')]?_0x146840[_0x6239('0x37')]:_0x2c41a5[_0x6239('0x32')];if(!_0x398ae4['query'][_0x6239('0x3a')](_0x6239('0x58'))){_0x146840[_0x6239('0x1e')]=qs[_0x6239('0x1e')](_0x398ae4['query'][_0x6239('0x1e')]);_0x146840[_0x6239('0x1d')]=qs[_0x6239('0x1d')](_0x398ae4[_0x6239('0x33')]['offset']);}_0x146840['order']=qs['sort'](_0x398ae4[_0x6239('0x33')]['sort']);_0x146840[_0x6239('0x3c')]=qs[_0x6239('0x35')](_['pick'](_0x398ae4[_0x6239('0x33')],_0x2c41a5['filters']));_0x146840[_0x6239('0x3c')]['ProjectId']=_0x5f2174['id'];if(_0x398ae4[_0x6239('0x33')][_0x6239('0x3e')]){_0x146840['where']=_[_0x6239('0x3f')](_0x146840['where'],{'$or':_['map'](_0x146840[_0x6239('0x37')],function(_0x4dcb6f){var _0x329282={};_0x329282[_0x4dcb6f]={'$like':'%'+_0x398ae4['query'][_0x6239('0x3e')]+'%'};return _0x329282;})});}_0x146840=_['merge']({},_0x146840,_0x398ae4[_0x6239('0x46')]);return db[_0x6239('0x59')][_0x6239('0x20')]({'where':_0x146840[_0x6239('0x3c')]})[_0x6239('0x27')](function(_0x50fb0d){_0x8e0a59['count']=_0x50fb0d;if(_0x398ae4[_0x6239('0x33')][_0x6239('0x40')]){_0x146840[_0x6239('0x41')]=[{'all':!![]}];}return db[_0x6239('0x59')][_0x6239('0x42')](_0x146840);})[_0x6239('0x27')](function(_0x1c9b12){_0x8e0a59[_0x6239('0x43')]=_0x1c9b12;return _0x8e0a59;});}})[_0x6239('0x27')](respondWithFilteredResult(_0x41a53d,_0x146840))[_0x6239('0x48')](handleError(_0x41a53d,null));};exports[_0x6239('0x5a')]=function(_0x12743b,_0x4207db,_0x1e72df){var _0x3472b2={'raw':!![],'where':{}};var _0x37027e={};var _0x1276ff={'count':0x0,'rows':[]};return db[_0x6239('0x2f')][_0x6239('0x5b')]({'where':{'id':_0x12743b['params']['id']}})['then'](handleEntityNotFound(_0x4207db,null))[_0x6239('0x27')](function(_0x553af2){if(_0x553af2){_0x37027e['model']=_[_0x6239('0x34')](db[_0x6239('0x5c')]['rawAttributes']);_0x37027e[_0x6239('0x33')]=_['keys'](_0x12743b['query']);_0x37027e[_0x6239('0x35')]=_[_0x6239('0x36')](_0x37027e[_0x6239('0x32')],_0x37027e[_0x6239('0x33')]);_0x3472b2['attributes']=_[_0x6239('0x36')](_0x37027e[_0x6239('0x32')],qs[_0x6239('0x38')](_0x12743b['query'][_0x6239('0x38')]));_0x3472b2[_0x6239('0x37')]=_0x3472b2['attributes'][_0x6239('0x39')]?_0x3472b2[_0x6239('0x37')]:_0x37027e[_0x6239('0x32')];if(!_0x12743b[_0x6239('0x33')]['hasOwnProperty'](_0x6239('0x58'))){_0x3472b2[_0x6239('0x1e')]=qs[_0x6239('0x1e')](_0x12743b[_0x6239('0x33')]['limit']);_0x3472b2['offset']=qs[_0x6239('0x1d')](_0x12743b[_0x6239('0x33')][_0x6239('0x1d')]);}_0x3472b2[_0x6239('0x5d')]=qs[_0x6239('0x3b')](_0x12743b[_0x6239('0x33')][_0x6239('0x3b')]);_0x3472b2[_0x6239('0x3c')]=qs[_0x6239('0x35')](_[_0x6239('0x5e')](_0x12743b[_0x6239('0x33')],_0x37027e[_0x6239('0x35')]));_0x3472b2[_0x6239('0x3c')]['ProjectId']=_0x553af2['id'];if(_0x12743b[_0x6239('0x33')][_0x6239('0x3e')]){_0x3472b2[_0x6239('0x3c')]=_[_0x6239('0x3f')](_0x3472b2[_0x6239('0x3c')],{'$or':_['map'](_0x3472b2['attributes'],function(_0xd9155a){var _0xc94e3={};_0xc94e3[_0xd9155a]={'$like':'%'+_0x12743b[_0x6239('0x33')][_0x6239('0x3e')]+'%'};return _0xc94e3;})});}_0x3472b2=_['merge']({},_0x3472b2,_0x12743b['options']);return db[_0x6239('0x5c')]['count']({'where':_0x3472b2[_0x6239('0x3c')]})['then'](function(_0x572b57){_0x1276ff['count']=_0x572b57;if(_0x12743b[_0x6239('0x33')]['includeAll']){_0x3472b2[_0x6239('0x41')]=[{'all':!![]}];}return db[_0x6239('0x5c')]['findAll'](_0x3472b2);})[_0x6239('0x27')](function(_0x1987b1){_0x1276ff['rows']=_0x1987b1;return _0x1276ff;});}})[_0x6239('0x27')](respondWithFilteredResult(_0x4207db,_0x3472b2))[_0x6239('0x48')](handleError(_0x4207db,null));};function char(_0x1b704e){return _0x6239('0x5f')===typeof _0x1b704e?String[_0x6239('0x60')][_0x6239('0x23')](null,arguments):_0x1b704e;}function needsEncapsulation(_0x35c500){return!!_0x35c500&&(_0x35c500['toString']()[_0x6239('0x61')](char(0xd))>=0x0||_0x35c500['toString']()[_0x6239('0x61')](char(0xa))>=0x0||_0x35c500['toString']()['indexOf'](char(0x2c))>=0x0||_0x35c500[_0x6239('0x62')]()[_0x6239('0x61')](char(0x22))>=0x0);}function encapsulate(_0x3d9100){var _0x301347=char(0x22),_0x345eb1='\x5c'+char(0x22),_0x2c1976=_0x3d9100[_0x6239('0x62')]()['replace'](new RegExp(_0x301347,'g'),_0x345eb1);return _0x301347+_0x2c1976+_0x301347;}exports[_0x6239('0x63')]=function(_0x51d854,_0x4da93f,_0x549484){var _0x146540,_0x4eb9d2;var _0xd69168={'where':{'ProjectId':_0x51d854[_0x6239('0x44')]['id']}};if(_0x51d854[_0x6239('0x33')][_0x6239('0x64')]){_0xd69168['where']['starttime']=JSON[_0x6239('0x65')](_0x51d854[_0x6239('0x33')][_0x6239('0x64')]);}return db[_0x6239('0x59')]['findAll'](_0xd69168)[_0x6239('0x27')](handleEntityNotFound(_0x4da93f,null))[_0x6239('0x27')](function(_0x16edfd){if(_0x16edfd){_0x146540=_0x16edfd;return db[_0x6239('0x66')][_0x6239('0x42')]({'where':{'SessionId':{'$in':_['map'](_0x146540,'id')},'ProjectId':_0x51d854[_0x6239('0x44')]['id']},'order':_0x6239('0x67')});}})[_0x6239('0x27')](handleEntityNotFound(_0x4da93f,null))[_0x6239('0x27')](function(_0x5bfb34){if(_0x5bfb34){_0x4eb9d2=_0x5bfb34;var _0xf715d3={};for(var _0x484354=0x0,_0xebc72d=_0x4eb9d2[_0x6239('0x39')];_0x484354<_0xebc72d;_0x484354++){if(!_0xf715d3[_0x6239('0x3a')](_0x4eb9d2[_0x484354]['questionId'])){_0xf715d3[_0x4eb9d2[_0x484354]['questionId']]=needsEncapsulation(_0x4eb9d2[_0x484354][_0x6239('0x68')])?encapsulate(_0x4eb9d2[_0x484354][_0x6239('0x68')]):_0x4eb9d2[_0x484354][_0x6239('0x68')];}}var _0x59e825=[],_0x38864a={};for(var _0x5541f7=0x0,_0x3644d8=_0x146540[_0x6239('0x39')];_0x5541f7<_0x3644d8;_0x5541f7++){_0x38864a={'ProjectId':_0x51d854[_0x6239('0x44')]['id'],'SessionId':_0x146540[_0x5541f7]['id'],'StartTime':moment(_0x146540[_0x5541f7]['starttime'])[_0x6239('0x69')](_0x6239('0x6a'))};for(var _0x134c23=0x0,_0x5de6a0=_0x4eb9d2['length'];_0x134c23<_0x5de6a0;_0x134c23++){if(_0x4eb9d2[_0x134c23][_0x6239('0x6b')]==_0x146540[_0x5541f7]['id']&&_0xf715d3['hasOwnProperty'](_0x4eb9d2[_0x134c23]['questionId'])){_0x38864a[_0xf715d3[_0x4eb9d2[_0x134c23][_0x6239('0x6c')]]]=_0x4eb9d2[_0x134c23][_0x6239('0x6d')];}}for(var _0x333e09 in _0xf715d3){if(!_0x38864a['hasOwnProperty'](_0xf715d3[_0x333e09])){_0x38864a[_0xf715d3[_0x333e09]]=null;}}_0x59e825[_0x6239('0x6e')](_0x38864a);}return _0x59e825;}})['then'](function(_0x3b2571){if(!_[_0x6239('0x6f')](_0x3b2571)){var _0x564928=toCsv(_0x3b2571);var _0x24d34e=Date['now']();fs[_0x6239('0x70')](util[_0x6239('0x69')](_0x6239('0x71'),_0x51d854['params']['id'],_0x24d34e),_0x564928);_0x4da93f[_0x6239('0x72')](_0x6239('0x73'),_0x6239('0x74')+util[_0x6239('0x69')](_0x6239('0x75'),_0x51d854[_0x6239('0x44')]['id'],_0x24d34e));_0x4da93f[_0x6239('0x72')]('Content-type',_0x6239('0x76'));return _0x4da93f['download'](util[_0x6239('0x69')]('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x51d854[_0x6239('0x44')]['id'],_0x24d34e));}else{return _0x4da93f[_0x6239('0x1a')](0xcc);}})[_0x6239('0x48')](handleError(_0x4da93f,null));};
\ No newline at end of file
+var _0x6002=['question','format','YYYY-MM-DD\x20HH:mm:ss','SessionId','answer','push','isEmpty','now','writeFileSync','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','Content-disposition','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','text/csv','download','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','mustache','util','path','sox','fs-extra','lodash','squel','crypto','jsforce','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','end','offset','undefined','limit','count','status','set','apply','reject','save','then','destroy','Projects','UserProfileResource','error','stack','name','send','map','JscriptyProject','rawAttributes','fieldName','type','model','query','keys','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','merge','VIRTUAL','filter','options','includeAll','findAll','rows','catch','show','find','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','get','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','params','include','omit','updatedAt','createdAt','user','UserProfileSection','findOne','JscriptySessionReport','pick','ProjectId','JscriptyAnswerReport','number','fromCharCode','toString','indexOf','replace','startTime','starttime','parse','-createdAt','questionId'];(function(_0x32cd29,_0x29f6bb){var _0x2f7e6e=function(_0x20a924){while(--_0x20a924){_0x32cd29['push'](_0x32cd29['shift']());}};_0x2f7e6e(++_0x29f6bb);}(_0x6002,0xfe));var _0x2600=function(_0x5d723a,_0x2c45eb){_0x5d723a=_0x5d723a-0x0;var _0x298403=_0x6002[_0x5d723a];return _0x298403;};'use strict';var emlformat=require(_0x2600('0x0'));var rimraf=require(_0x2600('0x1'));var zipdir=require(_0x2600('0x2'));var jsonpatch=require(_0x2600('0x3'));var rp=require(_0x2600('0x4'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x2600('0x5'));var util=require(_0x2600('0x6'));var path=require(_0x2600('0x7'));var sox=require(_0x2600('0x8'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x2600('0x9'));var _=require(_0x2600('0xa'));var squel=require(_0x2600('0xb'));var crypto=require(_0x2600('0xc'));var jsforce=require(_0x2600('0xd'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x2600('0xe'));var Redis=require(_0x2600('0xf'));var authService=require(_0x2600('0x10'));var qs=require(_0x2600('0x11'));var as=require(_0x2600('0x12'));var hardwareService=require(_0x2600('0x13'));var logger=require(_0x2600('0x14'))(_0x2600('0x15'));var utils=require(_0x2600('0x16'));var config=require(_0x2600('0x17'));var licenseUtil=require('../../config/license/util');var db=require(_0x2600('0x18'))['db'];function respondWithStatusCode(_0x45aa3f,_0x2f75a0){_0x2f75a0=_0x2f75a0||0xcc;return function(_0x3be0da){if(_0x3be0da){return _0x45aa3f[_0x2600('0x19')](_0x2f75a0);}return _0x45aa3f['status'](_0x2f75a0)[_0x2600('0x1a')]();};}function respondWithResult(_0x414239,_0x13a3ac){_0x13a3ac=_0x13a3ac||0xc8;return function(_0x1b0fa3){if(_0x1b0fa3){return _0x414239['status'](_0x13a3ac)['json'](_0x1b0fa3);}};}function respondWithFilteredResult(_0x3d20e3,_0x323358){return function(_0x225ecf){if(_0x225ecf){var _0x5be78c=typeof _0x323358[_0x2600('0x1b')]===_0x2600('0x1c')&&typeof _0x323358[_0x2600('0x1d')]===_0x2600('0x1c');var _0x109c16=_0x225ecf['count'];var _0x3068d1=_0x5be78c?0x0:_0x323358[_0x2600('0x1b')];var _0x4c96ae=_0x5be78c?_0x225ecf[_0x2600('0x1e')]:_0x323358[_0x2600('0x1b')]+_0x323358['limit'];var _0x43b25e;if(_0x4c96ae>=_0x109c16){_0x4c96ae=_0x109c16;_0x43b25e=0xc8;}else{_0x43b25e=0xce;}_0x3d20e3[_0x2600('0x1f')](_0x43b25e);return _0x3d20e3[_0x2600('0x20')]('Content-Range',_0x3068d1+'-'+_0x4c96ae+'/'+_0x109c16)['json'](_0x225ecf);}return null;};}function patchUpdates(_0xe07271){return function(_0x2f6030){try{jsonpatch[_0x2600('0x21')](_0x2f6030,_0xe07271,!![]);}catch(_0x59e37b){return BPromise[_0x2600('0x22')](_0x59e37b);}return _0x2f6030[_0x2600('0x23')]();};}function saveUpdates(_0x46c19a,_0x497e96){return function(_0xf89141){if(_0xf89141){return _0xf89141['update'](_0x46c19a)[_0x2600('0x24')](function(_0x52b8c1){return _0x52b8c1;});}return null;};}function removeEntity(_0x32ef3f,_0x102f23){return function(_0x4303c0){if(_0x4303c0){return _0x4303c0[_0x2600('0x25')]()['then'](function(){var _0x4ee8c7=_0x4303c0['get']({'plain':!![]});var _0x42b905=_0x2600('0x26');return db[_0x2600('0x27')][_0x2600('0x25')]({'where':{'type':_0x42b905,'resourceId':_0x4ee8c7['id']}})[_0x2600('0x24')](function(){return _0x4303c0;});})[_0x2600('0x24')](function(){_0x32ef3f[_0x2600('0x1f')](0xcc)[_0x2600('0x1a')]();});}};}function handleEntityNotFound(_0x1f1fe7,_0x20a0d5){return function(_0x154db3){if(!_0x154db3){_0x1f1fe7[_0x2600('0x19')](0x194);}return _0x154db3;};}function handleError(_0x214c8d,_0x18bd0f){_0x18bd0f=_0x18bd0f||0x1f4;return function(_0x2e4466){logger[_0x2600('0x28')](_0x2e4466[_0x2600('0x29')]);if(_0x2e4466[_0x2600('0x2a')]){delete _0x2e4466[_0x2600('0x2a')];}_0x214c8d[_0x2600('0x1f')](_0x18bd0f)[_0x2600('0x2b')](_0x2e4466);};}exports['index']=function(_0x5db721,_0x697368){var _0x5c84bf={},_0x5f3dd5={},_0x246bf4={'count':0x0,'rows':[]};var _0x8f19=_[_0x2600('0x2c')](db[_0x2600('0x2d')][_0x2600('0x2e')],function(_0x5e16df){return{'name':_0x5e16df[_0x2600('0x2f')],'type':_0x5e16df[_0x2600('0x30')]['key']};});_0x5f3dd5[_0x2600('0x31')]=_[_0x2600('0x2c')](_0x8f19,_0x2600('0x2a'));_0x5f3dd5[_0x2600('0x32')]=_[_0x2600('0x33')](_0x5db721[_0x2600('0x32')]);_0x5f3dd5[_0x2600('0x34')]=_[_0x2600('0x35')](_0x5f3dd5[_0x2600('0x31')],_0x5f3dd5['query']);_0x5c84bf['attributes']=_[_0x2600('0x35')](_0x5f3dd5[_0x2600('0x31')],qs[_0x2600('0x36')](_0x5db721[_0x2600('0x32')]['fields']));_0x5c84bf['attributes']=_0x5c84bf[_0x2600('0x37')][_0x2600('0x38')]?_0x5c84bf[_0x2600('0x37')]:_0x5f3dd5[_0x2600('0x31')];if(!_0x5db721['query'][_0x2600('0x39')](_0x2600('0x3a'))){_0x5c84bf[_0x2600('0x1d')]=qs[_0x2600('0x1d')](_0x5db721[_0x2600('0x32')]['limit']);_0x5c84bf['offset']=qs[_0x2600('0x1b')](_0x5db721[_0x2600('0x32')][_0x2600('0x1b')]);}_0x5c84bf[_0x2600('0x3b')]=qs['sort'](_0x5db721[_0x2600('0x32')][_0x2600('0x3c')]);_0x5c84bf[_0x2600('0x3d')]=qs[_0x2600('0x34')](_['pick'](_0x5db721[_0x2600('0x32')],_0x5f3dd5[_0x2600('0x34')]),_0x8f19);if(_0x5db721[_0x2600('0x32')]['filter']){_0x5c84bf[_0x2600('0x3d')]=_[_0x2600('0x3e')](_0x5c84bf[_0x2600('0x3d')],{'$or':_['map'](_0x8f19,function(_0x3da0cf){if(_0x3da0cf[_0x2600('0x30')]!==_0x2600('0x3f')){var _0x4b73ba={};_0x4b73ba[_0x3da0cf['name']]={'$like':'%'+_0x5db721[_0x2600('0x32')][_0x2600('0x40')]+'%'};return _0x4b73ba;}})});}_0x5c84bf=_[_0x2600('0x3e')]({},_0x5c84bf,_0x5db721[_0x2600('0x41')]);var _0x18546b={'where':_0x5c84bf[_0x2600('0x3d')]};return db['JscriptyProject']['count'](_0x18546b)[_0x2600('0x24')](function(_0x27e76a){_0x246bf4['count']=_0x27e76a;if(_0x5db721['query'][_0x2600('0x42')]){_0x5c84bf['include']=[{'all':!![]}];}return db['JscriptyProject'][_0x2600('0x43')](_0x5c84bf);})[_0x2600('0x24')](function(_0x2c00ae){_0x246bf4[_0x2600('0x44')]=_0x2c00ae;return _0x246bf4;})[_0x2600('0x24')](respondWithFilteredResult(_0x697368,_0x5c84bf))[_0x2600('0x45')](handleError(_0x697368,null));};exports[_0x2600('0x46')]=function(_0x3df8a1,_0x5386c9){var _0x52097f={'raw':![],'where':{'id':_0x3df8a1['params']['id']}},_0xcb01e6={};_0xcb01e6[_0x2600('0x31')]=_[_0x2600('0x33')](db['JscriptyProject'][_0x2600('0x2e')]);_0xcb01e6['query']=_[_0x2600('0x33')](_0x3df8a1[_0x2600('0x32')]);_0xcb01e6[_0x2600('0x34')]=_['intersection'](_0xcb01e6[_0x2600('0x31')],_0xcb01e6['query']);_0x52097f[_0x2600('0x37')]=_['intersection'](_0xcb01e6[_0x2600('0x31')],qs[_0x2600('0x36')](_0x3df8a1[_0x2600('0x32')][_0x2600('0x36')]));_0x52097f[_0x2600('0x37')]=_0x52097f[_0x2600('0x37')][_0x2600('0x38')]?_0x52097f[_0x2600('0x37')]:_0xcb01e6[_0x2600('0x31')];if(_0x3df8a1[_0x2600('0x32')][_0x2600('0x42')]){_0x52097f['include']=[{'all':!![]}];}_0x52097f=_[_0x2600('0x3e')]({},_0x52097f,_0x3df8a1[_0x2600('0x41')]);return db[_0x2600('0x2d')][_0x2600('0x47')](_0x52097f)[_0x2600('0x24')](handleEntityNotFound(_0x5386c9,null))[_0x2600('0x24')](respondWithResult(_0x5386c9,null))[_0x2600('0x45')](handleError(_0x5386c9,null));};exports['create']=function(_0x67d5ec,_0x7f1cdf){return db[_0x2600('0x2d')][_0x2600('0x48')](_0x67d5ec[_0x2600('0x49')],{})['then'](function(_0x292421){var _0x429fcd=_0x67d5ec['user']['get']({'plain':!![]});if(!_0x429fcd)throw new Error(_0x2600('0x4a'));if(_0x429fcd[_0x2600('0x4b')]==='user'){var _0x6ef171=_0x292421[_0x2600('0x4c')]({'plain':!![]});var _0x3fc562=_0x2600('0x26');return db['UserProfileSection'][_0x2600('0x47')]({'where':{'name':_0x3fc562,'userProfileId':_0x429fcd[_0x2600('0x4d')]},'raw':!![]})[_0x2600('0x24')](function(_0x8abcb5){if(_0x8abcb5&&_0x8abcb5[_0x2600('0x4e')]===0x0){return db[_0x2600('0x27')]['create']({'name':_0x6ef171[_0x2600('0x2a')],'resourceId':_0x6ef171['id'],'type':_0x8abcb5[_0x2600('0x2a')],'sectionId':_0x8abcb5['id']},{})['then'](function(){return _0x292421;});}else{return _0x292421;}})[_0x2600('0x45')](function(_0x3622af){logger[_0x2600('0x28')](_0x2600('0x4f'),_0x3622af);throw _0x3622af;});}return _0x292421;})[_0x2600('0x24')](respondWithResult(_0x7f1cdf,0xc9))['catch'](handleError(_0x7f1cdf,null));};exports[_0x2600('0x50')]=function(_0x5b4a6c,_0xdc6726){var _0x11a65c={'where':{'id':_0x5b4a6c[_0x2600('0x51')]['id']}},_0xe6e73={};_0xe6e73[_0x2600('0x31')]=_['keys'](db[_0x2600('0x2d')]['rawAttributes']);_0x11a65c['attributes']=_[_0x2600('0x35')](_0xe6e73[_0x2600('0x31')],qs[_0x2600('0x36')](_0x5b4a6c[_0x2600('0x32')][_0x2600('0x36')]));_0x11a65c[_0x2600('0x37')]=_0x11a65c[_0x2600('0x37')][_0x2600('0x38')]?_0x11a65c[_0x2600('0x37')]:_0xe6e73[_0x2600('0x31')];if(_0x5b4a6c[_0x2600('0x32')]['includeAll']){_0x11a65c[_0x2600('0x52')]=[{'all':!![]}];}_0x11a65c=_[_0x2600('0x3e')]({},_0x11a65c,_0x5b4a6c['options']);return db[_0x2600('0x2d')][_0x2600('0x47')](_0x11a65c)['then'](handleEntityNotFound(_0xdc6726,null))[_0x2600('0x24')](function(_0x1f69bc){if(_0x1f69bc){var _0x1174fd=_0x1f69bc[_0x2600('0x4c')]({'plain':!![]});_0x1174fd=qs[_0x2600('0x53')](_0x1174fd,['id','createdAt',_0x2600('0x54')]);_0x5b4a6c['body']=_[_0x2600('0x53')](_0x5b4a6c['body'],['id',_0x2600('0x55'),_0x2600('0x54')]);return db[_0x2600('0x2d')][_0x2600('0x48')](_[_0x2600('0x3e')](_0x1174fd,_0x5b4a6c[_0x2600('0x49')]),{'include':_0x5b4a6c['query']['includeAll']?[{'all':!![]}]:undefined})[_0x2600('0x24')](function(_0x4135dd){var _0x5c619f=_0x5b4a6c[_0x2600('0x56')]['get']({'plain':!![]});if(!_0x5c619f)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x5c619f['role']===_0x2600('0x56')){var _0xfc6892=_0x4135dd[_0x2600('0x4c')]({'plain':!![]});var _0x554192=_0x2600('0x26');return db[_0x2600('0x57')]['find']({'where':{'name':_0x554192,'userProfileId':_0x5c619f['userProfileId']},'raw':!![]})[_0x2600('0x24')](function(_0x489a5b){if(_0x489a5b&&_0x489a5b[_0x2600('0x4e')]===0x0){return db['UserProfileResource'][_0x2600('0x48')]({'name':_0xfc6892[_0x2600('0x2a')],'resourceId':_0xfc6892['id'],'type':_0x489a5b[_0x2600('0x2a')],'sectionId':_0x489a5b['id']},{})[_0x2600('0x24')](function(){return _0x4135dd;});}else{return _0x4135dd;}})[_0x2600('0x45')](function(_0x56f311){logger[_0x2600('0x28')](_0x2600('0x4f'),_0x56f311);throw _0x56f311;});}return _0x4135dd;});}})['then'](respondWithResult(_0xdc6726,0xc9))[_0x2600('0x45')](handleError(_0xdc6726,null));};exports['update']=function(_0x1e1dcd,_0x21ee20){if(_0x1e1dcd[_0x2600('0x49')]['id']){delete _0x1e1dcd[_0x2600('0x49')]['id'];}return db[_0x2600('0x2d')][_0x2600('0x47')]({'where':{'id':_0x1e1dcd[_0x2600('0x51')]['id']}})[_0x2600('0x24')](handleEntityNotFound(_0x21ee20,null))['then'](saveUpdates(_0x1e1dcd[_0x2600('0x49')],null))[_0x2600('0x24')](respondWithResult(_0x21ee20,null))[_0x2600('0x45')](handleError(_0x21ee20,null));};exports[_0x2600('0x25')]=function(_0x3533cc,_0x3d4b5e){return db[_0x2600('0x2d')]['find']({'where':{'id':_0x3533cc[_0x2600('0x51')]['id']}})[_0x2600('0x24')](handleEntityNotFound(_0x3d4b5e,null))['then'](removeEntity(_0x3d4b5e,null))[_0x2600('0x45')](handleError(_0x3d4b5e,null));};exports['getSessions']=function(_0x25c7a4,_0xb442d6,_0x42a92c){var _0x4265a5={'raw':!![],'where':{}};var _0x3616c0={};var _0x14546d={'count':0x0,'rows':[]};return db[_0x2600('0x2d')][_0x2600('0x58')]({'where':{'id':_0x25c7a4[_0x2600('0x51')]['id']}})[_0x2600('0x24')](handleEntityNotFound(_0xb442d6,null))[_0x2600('0x24')](function(_0x54d060){if(_0x54d060){_0x3616c0['model']=_['keys'](db[_0x2600('0x59')][_0x2600('0x2e')]);_0x3616c0[_0x2600('0x32')]=_['keys'](_0x25c7a4[_0x2600('0x32')]);_0x3616c0[_0x2600('0x34')]=_[_0x2600('0x35')](_0x3616c0[_0x2600('0x31')],_0x3616c0[_0x2600('0x32')]);_0x4265a5[_0x2600('0x37')]=_[_0x2600('0x35')](_0x3616c0['model'],qs['fields'](_0x25c7a4['query'][_0x2600('0x36')]));_0x4265a5[_0x2600('0x37')]=_0x4265a5[_0x2600('0x37')][_0x2600('0x38')]?_0x4265a5[_0x2600('0x37')]:_0x3616c0[_0x2600('0x31')];if(!_0x25c7a4[_0x2600('0x32')][_0x2600('0x39')](_0x2600('0x3a'))){_0x4265a5[_0x2600('0x1d')]=qs[_0x2600('0x1d')](_0x25c7a4[_0x2600('0x32')][_0x2600('0x1d')]);_0x4265a5[_0x2600('0x1b')]=qs[_0x2600('0x1b')](_0x25c7a4[_0x2600('0x32')][_0x2600('0x1b')]);}_0x4265a5[_0x2600('0x3b')]=qs[_0x2600('0x3c')](_0x25c7a4['query'][_0x2600('0x3c')]);_0x4265a5[_0x2600('0x3d')]=qs[_0x2600('0x34')](_[_0x2600('0x5a')](_0x25c7a4[_0x2600('0x32')],_0x3616c0['filters']));_0x4265a5[_0x2600('0x3d')][_0x2600('0x5b')]=_0x54d060['id'];if(_0x25c7a4[_0x2600('0x32')]['filter']){_0x4265a5[_0x2600('0x3d')]=_['merge'](_0x4265a5[_0x2600('0x3d')],{'$or':_['map'](_0x4265a5[_0x2600('0x37')],function(_0x158ff6){var _0x2e5f88={};_0x2e5f88[_0x158ff6]={'$like':'%'+_0x25c7a4[_0x2600('0x32')][_0x2600('0x40')]+'%'};return _0x2e5f88;})});}_0x4265a5=_[_0x2600('0x3e')]({},_0x4265a5,_0x25c7a4['options']);return db[_0x2600('0x59')]['count']({'where':_0x4265a5[_0x2600('0x3d')]})[_0x2600('0x24')](function(_0x2c6d95){_0x14546d[_0x2600('0x1e')]=_0x2c6d95;if(_0x25c7a4[_0x2600('0x32')][_0x2600('0x42')]){_0x4265a5['include']=[{'all':!![]}];}return db[_0x2600('0x59')][_0x2600('0x43')](_0x4265a5);})[_0x2600('0x24')](function(_0x3de445){_0x14546d[_0x2600('0x44')]=_0x3de445;return _0x14546d;});}})['then'](respondWithFilteredResult(_0xb442d6,_0x4265a5))[_0x2600('0x45')](handleError(_0xb442d6,null));};exports['getAnswers']=function(_0x11d2d0,_0x364a66,_0x544ee0){var _0x233970={'raw':!![],'where':{}};var _0x30d306={};var _0x2f0b29={'count':0x0,'rows':[]};return db[_0x2600('0x2d')][_0x2600('0x58')]({'where':{'id':_0x11d2d0[_0x2600('0x51')]['id']}})[_0x2600('0x24')](handleEntityNotFound(_0x364a66,null))[_0x2600('0x24')](function(_0x53b02b){if(_0x53b02b){_0x30d306[_0x2600('0x31')]=_['keys'](db[_0x2600('0x5c')][_0x2600('0x2e')]);_0x30d306[_0x2600('0x32')]=_['keys'](_0x11d2d0['query']);_0x30d306[_0x2600('0x34')]=_[_0x2600('0x35')](_0x30d306[_0x2600('0x31')],_0x30d306[_0x2600('0x32')]);_0x233970[_0x2600('0x37')]=_['intersection'](_0x30d306['model'],qs[_0x2600('0x36')](_0x11d2d0[_0x2600('0x32')][_0x2600('0x36')]));_0x233970[_0x2600('0x37')]=_0x233970['attributes'][_0x2600('0x38')]?_0x233970[_0x2600('0x37')]:_0x30d306[_0x2600('0x31')];if(!_0x11d2d0[_0x2600('0x32')][_0x2600('0x39')](_0x2600('0x3a'))){_0x233970['limit']=qs[_0x2600('0x1d')](_0x11d2d0['query']['limit']);_0x233970[_0x2600('0x1b')]=qs[_0x2600('0x1b')](_0x11d2d0[_0x2600('0x32')][_0x2600('0x1b')]);}_0x233970[_0x2600('0x3b')]=qs[_0x2600('0x3c')](_0x11d2d0[_0x2600('0x32')]['sort']);_0x233970[_0x2600('0x3d')]=qs['filters'](_['pick'](_0x11d2d0[_0x2600('0x32')],_0x30d306['filters']));_0x233970[_0x2600('0x3d')]['ProjectId']=_0x53b02b['id'];if(_0x11d2d0[_0x2600('0x32')][_0x2600('0x40')]){_0x233970[_0x2600('0x3d')]=_['merge'](_0x233970['where'],{'$or':_[_0x2600('0x2c')](_0x233970['attributes'],function(_0x37858d){var _0x49c8d9={};_0x49c8d9[_0x37858d]={'$like':'%'+_0x11d2d0[_0x2600('0x32')]['filter']+'%'};return _0x49c8d9;})});}_0x233970=_[_0x2600('0x3e')]({},_0x233970,_0x11d2d0[_0x2600('0x41')]);return db[_0x2600('0x5c')][_0x2600('0x1e')]({'where':_0x233970[_0x2600('0x3d')]})[_0x2600('0x24')](function(_0x2b0523){_0x2f0b29[_0x2600('0x1e')]=_0x2b0523;if(_0x11d2d0[_0x2600('0x32')]['includeAll']){_0x233970[_0x2600('0x52')]=[{'all':!![]}];}return db[_0x2600('0x5c')]['findAll'](_0x233970);})[_0x2600('0x24')](function(_0x3b068b){_0x2f0b29[_0x2600('0x44')]=_0x3b068b;return _0x2f0b29;});}})['then'](respondWithFilteredResult(_0x364a66,_0x233970))[_0x2600('0x45')](handleError(_0x364a66,null));};function char(_0x504f2e){return _0x2600('0x5d')===typeof _0x504f2e?String[_0x2600('0x5e')][_0x2600('0x21')](null,arguments):_0x504f2e;}function needsEncapsulation(_0x359899){return!!_0x359899&&(_0x359899[_0x2600('0x5f')]()[_0x2600('0x60')](char(0xd))>=0x0||_0x359899[_0x2600('0x5f')]()[_0x2600('0x60')](char(0xa))>=0x0||_0x359899['toString']()['indexOf'](char(0x2c))>=0x0||_0x359899[_0x2600('0x5f')]()[_0x2600('0x60')](char(0x22))>=0x0);}function encapsulate(_0x287c4b){var _0x575b7f=char(0x22),_0x16c9ec='\x5c'+char(0x22),_0x1c3802=_0x287c4b[_0x2600('0x5f')]()[_0x2600('0x61')](new RegExp(_0x575b7f,'g'),_0x16c9ec);return _0x575b7f+_0x1c3802+_0x575b7f;}exports['getSummary']=function(_0x5c6795,_0x108917,_0x4cdb7a){var _0x32884e,_0x46ac76;var _0x3ebee2={'where':{'ProjectId':_0x5c6795[_0x2600('0x51')]['id']}};if(_0x5c6795[_0x2600('0x32')][_0x2600('0x62')]){_0x3ebee2[_0x2600('0x3d')][_0x2600('0x63')]=JSON[_0x2600('0x64')](_0x5c6795[_0x2600('0x32')]['startTime']);}return db['JscriptySessionReport']['findAll'](_0x3ebee2)[_0x2600('0x24')](handleEntityNotFound(_0x108917,null))[_0x2600('0x24')](function(_0x4bbdd0){if(_0x4bbdd0){_0x32884e=_0x4bbdd0;return db['JscriptyQuestionReport']['findAll']({'where':{'SessionId':{'$in':_[_0x2600('0x2c')](_0x32884e,'id')},'ProjectId':_0x5c6795[_0x2600('0x51')]['id']},'order':_0x2600('0x65')});}})['then'](handleEntityNotFound(_0x108917,null))[_0x2600('0x24')](function(_0x538c5e){if(_0x538c5e){_0x46ac76=_0x538c5e;var _0x5789cf={};for(var _0x6d01e0=0x0,_0x286bf2=_0x46ac76[_0x2600('0x38')];_0x6d01e0<_0x286bf2;_0x6d01e0++){if(!_0x5789cf[_0x2600('0x39')](_0x46ac76[_0x6d01e0][_0x2600('0x66')])){_0x5789cf[_0x46ac76[_0x6d01e0]['questionId']]=needsEncapsulation(_0x46ac76[_0x6d01e0][_0x2600('0x67')])?encapsulate(_0x46ac76[_0x6d01e0][_0x2600('0x67')]):_0x46ac76[_0x6d01e0]['question'];}}var _0xc6f40d=[],_0x425abb={};for(var _0x2bfbe9=0x0,_0x107491=_0x32884e[_0x2600('0x38')];_0x2bfbe9<_0x107491;_0x2bfbe9++){_0x425abb={'ProjectId':_0x5c6795[_0x2600('0x51')]['id'],'SessionId':_0x32884e[_0x2bfbe9]['id'],'StartTime':moment(_0x32884e[_0x2bfbe9][_0x2600('0x63')])[_0x2600('0x68')](_0x2600('0x69'))};for(var _0x4124e7=0x0,_0x4925b0=_0x46ac76[_0x2600('0x38')];_0x4124e7<_0x4925b0;_0x4124e7++){if(_0x46ac76[_0x4124e7][_0x2600('0x6a')]==_0x32884e[_0x2bfbe9]['id']&&_0x5789cf[_0x2600('0x39')](_0x46ac76[_0x4124e7][_0x2600('0x66')])){_0x425abb[_0x5789cf[_0x46ac76[_0x4124e7]['questionId']]]=_0x46ac76[_0x4124e7][_0x2600('0x6b')];}}for(var _0x238f44 in _0x5789cf){if(!_0x425abb[_0x2600('0x39')](_0x5789cf[_0x238f44])){_0x425abb[_0x5789cf[_0x238f44]]=null;}}_0xc6f40d[_0x2600('0x6c')](_0x425abb);}return _0xc6f40d;}})[_0x2600('0x24')](function(_0x2c5497){if(!_[_0x2600('0x6d')](_0x2c5497)){var _0x501718=toCsv(_0x2c5497);var _0x46d155=Date[_0x2600('0x6e')]();fs[_0x2600('0x6f')](util['format'](_0x2600('0x70'),_0x5c6795[_0x2600('0x51')]['id'],_0x46d155),_0x501718);_0x108917[_0x2600('0x71')](_0x2600('0x72'),_0x2600('0x73')+util[_0x2600('0x68')](_0x2600('0x74'),_0x5c6795[_0x2600('0x51')]['id'],_0x46d155));_0x108917[_0x2600('0x71')]('Content-type',_0x2600('0x75'));return _0x108917[_0x2600('0x76')](util[_0x2600('0x68')](_0x2600('0x70'),_0x5c6795['params']['id'],_0x46d155));}else{return _0x108917[_0x2600('0x19')](0xcc);}})['catch'](handleError(_0x108917,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff