// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x5ed9=['path','sox','ejs','lodash','squel','crypto','jsforce','desk.js','to-csv','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','end','json','undefined','count','offset','limit','status','set','Content-Range','apply','reject','save','update','then','destroy','get','Projects','UserProfileResource','sendStatus','error','stack','name','index','rawAttributes','fieldName','type','key','model','map','query','keys','fields','attributes','hasOwnProperty','nolimit','sort','where','filters','pick','merge','VIRTUAL','filter','JscriptyProject','includeAll','include','rows','catch','intersection','length','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','clone','params','options','omit','updatedAt','createdAt','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','getSessions','findOne','JscriptySessionReport','ProjectId','getAnswers','JscriptyAnswerReport','order','findAll','fromCharCode','toString','indexOf','getSummary','starttime','parse','startTime','JscriptyQuestionReport','-createdAt','questionId','question','format','SessionId','answer','push','isEmpty','now','writeFileSync','Content-disposition','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','setHeader','Content-type','text/csv','download','/tmp/Jscripty_Project_%d_Summary_%s.csv','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','util'];(function(_0x5f0777,_0x759274){var _0x1fbcc9=function(_0x1d3b08){while(--_0x1d3b08){_0x5f0777['push'](_0x5f0777['shift']());}};_0x1fbcc9(++_0x759274);}(_0x5ed9,0x1e9));var _0x95ed=function(_0x580576,_0x2f107d){_0x580576=_0x580576-0x0;var _0x3f55a0=_0x5ed9[_0x580576];return _0x3f55a0;};'use strict';var emlformat=require(_0x95ed('0x0'));var rimraf=require(_0x95ed('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x95ed('0x2'));var rp=require(_0x95ed('0x3'));var moment=require(_0x95ed('0x4'));var BPromise=require(_0x95ed('0x5'));var Mustache=require('mustache');var util=require(_0x95ed('0x6'));var path=require(_0x95ed('0x7'));var sox=require(_0x95ed('0x8'));var csv=require('to-csv');var ejs=require(_0x95ed('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x95ed('0xa'));var squel=require(_0x95ed('0xb'));var crypto=require(_0x95ed('0xc'));var jsforce=require(_0x95ed('0xd'));var deskjs=require(_0x95ed('0xe'));var toCsv=require(_0x95ed('0xf'));var querystring=require('querystring');var Papa=require(_0x95ed('0x10'));var Redis=require(_0x95ed('0x11'));var authService=require(_0x95ed('0x12'));var qs=require('../../components/parsers/qs');var as=require(_0x95ed('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x95ed('0x14'))(_0x95ed('0x15'));var utils=require(_0x95ed('0x16'));var config=require(_0x95ed('0x17'));var licenseUtil=require(_0x95ed('0x18'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x5e4571,_0x3da05b){_0x3da05b=_0x3da05b||0xcc;return function(_0x4236c1){if(_0x4236c1){return _0x5e4571['sendStatus'](_0x3da05b);}return _0x5e4571['status'](_0x3da05b)[_0x95ed('0x19')]();};}function respondWithResult(_0x11671d,_0x22211f){_0x22211f=_0x22211f||0xc8;return function(_0x3ebfda){if(_0x3ebfda){return _0x11671d['status'](_0x22211f)[_0x95ed('0x1a')](_0x3ebfda);}};}function respondWithFilteredResult(_0xd3fe73,_0x477b8f){return function(_0x597a04){if(_0x597a04){var _0x5fc6b5=typeof _0x477b8f['offset']===_0x95ed('0x1b')&&typeof _0x477b8f['limit']==='undefined';var _0x47f841=_0x597a04[_0x95ed('0x1c')];var _0x58fb9e=_0x5fc6b5?0x0:_0x477b8f[_0x95ed('0x1d')];var _0x1bc47c=_0x5fc6b5?_0x597a04['count']:_0x477b8f[_0x95ed('0x1d')]+_0x477b8f[_0x95ed('0x1e')];var _0x4432c9;if(_0x1bc47c>=_0x47f841){_0x1bc47c=_0x47f841;_0x4432c9=0xc8;}else{_0x4432c9=0xce;}_0xd3fe73[_0x95ed('0x1f')](_0x4432c9);return _0xd3fe73[_0x95ed('0x20')](_0x95ed('0x21'),_0x58fb9e+'-'+_0x1bc47c+'/'+_0x47f841)[_0x95ed('0x1a')](_0x597a04);}return null;};}function patchUpdates(_0x3e05cf){return function(_0x10823b){try{jsonpatch[_0x95ed('0x22')](_0x10823b,_0x3e05cf,!![]);}catch(_0x5887e3){return BPromise[_0x95ed('0x23')](_0x5887e3);}return _0x10823b[_0x95ed('0x24')]();};}function saveUpdates(_0x4e8a5d,_0x5d5afe){return function(_0x54c5ae){if(_0x54c5ae){return _0x54c5ae[_0x95ed('0x25')](_0x4e8a5d)[_0x95ed('0x26')](function(_0x31384c){return _0x31384c;});}return null;};}function removeEntity(_0x61d85e,_0x2c0824){return function(_0x19b664){if(_0x19b664){return _0x19b664[_0x95ed('0x27')]()[_0x95ed('0x26')](function(){var _0x146f74=_0x19b664[_0x95ed('0x28')]({'plain':!![]});var _0x3b298f=_0x95ed('0x29');return db[_0x95ed('0x2a')][_0x95ed('0x27')]({'where':{'type':_0x3b298f,'resourceId':_0x146f74['id']}})['then'](function(){return _0x19b664;});})[_0x95ed('0x26')](function(){_0x61d85e['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x2f515d,_0x2d6df0){return function(_0x45e403){if(!_0x45e403){_0x2f515d[_0x95ed('0x2b')](0x194);}return _0x45e403;};}function handleError(_0x2d5042,_0x3a4ee8){_0x3a4ee8=_0x3a4ee8||0x1f4;return function(_0x88e102){logger[_0x95ed('0x2c')](_0x88e102[_0x95ed('0x2d')]);if(_0x88e102[_0x95ed('0x2e')]){delete _0x88e102[_0x95ed('0x2e')];}_0x2d5042[_0x95ed('0x1f')](_0x3a4ee8)['send'](_0x88e102);};}exports[_0x95ed('0x2f')]=function(_0xf73b6f,_0x53b1f4){var _0x28c738={},_0x5e0c25={},_0x5365ae={'count':0x0,'rows':[]};var _0x5d550a=_['map'](db['JscriptyProject'][_0x95ed('0x30')],function(_0x77f14b){return{'name':_0x77f14b[_0x95ed('0x31')],'type':_0x77f14b[_0x95ed('0x32')][_0x95ed('0x33')]};});_0x5e0c25[_0x95ed('0x34')]=_[_0x95ed('0x35')](_0x5d550a,'name');_0x5e0c25[_0x95ed('0x36')]=_[_0x95ed('0x37')](_0xf73b6f[_0x95ed('0x36')]);_0x5e0c25['filters']=_['intersection'](_0x5e0c25[_0x95ed('0x34')],_0x5e0c25['query']);_0x28c738['attributes']=_['intersection'](_0x5e0c25['model'],qs[_0x95ed('0x38')](_0xf73b6f['query'][_0x95ed('0x38')]));_0x28c738[_0x95ed('0x39')]=_0x28c738['attributes']['length']?_0x28c738['attributes']:_0x5e0c25['model'];if(!_0xf73b6f['query'][_0x95ed('0x3a')](_0x95ed('0x3b'))){_0x28c738[_0x95ed('0x1e')]=qs[_0x95ed('0x1e')](_0xf73b6f[_0x95ed('0x36')][_0x95ed('0x1e')]);_0x28c738['offset']=qs[_0x95ed('0x1d')](_0xf73b6f[_0x95ed('0x36')][_0x95ed('0x1d')]);}_0x28c738['order']=qs[_0x95ed('0x3c')](_0xf73b6f[_0x95ed('0x36')][_0x95ed('0x3c')]);_0x28c738[_0x95ed('0x3d')]=qs[_0x95ed('0x3e')](_[_0x95ed('0x3f')](_0xf73b6f[_0x95ed('0x36')],_0x5e0c25[_0x95ed('0x3e')]),_0x5d550a);if(_0xf73b6f['query']['filter']){_0x28c738['where']=_[_0x95ed('0x40')](_0x28c738[_0x95ed('0x3d')],{'$or':_[_0x95ed('0x35')](_0x5d550a,function(_0x2ab65e){if(_0x2ab65e[_0x95ed('0x32')]!==_0x95ed('0x41')){var _0x4b9e16={};_0x4b9e16[_0x2ab65e[_0x95ed('0x2e')]]={'$like':'%'+_0xf73b6f[_0x95ed('0x36')][_0x95ed('0x42')]+'%'};return _0x4b9e16;}})});}_0x28c738=_['merge']({},_0x28c738,_0xf73b6f['options']);var _0x284948={'where':_0x28c738[_0x95ed('0x3d')]};return db[_0x95ed('0x43')][_0x95ed('0x1c')](_0x284948)[_0x95ed('0x26')](function(_0x5c4c54){_0x5365ae['count']=_0x5c4c54;if(_0xf73b6f[_0x95ed('0x36')][_0x95ed('0x44')]){_0x28c738[_0x95ed('0x45')]=[{'all':!![]}];}return db[_0x95ed('0x43')]['findAll'](_0x28c738);})[_0x95ed('0x26')](function(_0x537c2b){_0x5365ae[_0x95ed('0x46')]=_0x537c2b;return _0x5365ae;})[_0x95ed('0x26')](respondWithFilteredResult(_0x53b1f4,_0x28c738))[_0x95ed('0x47')](handleError(_0x53b1f4,null));};exports['show']=function(_0x3c1477,_0x203579){var _0xaae315={'raw':![],'where':{'id':_0x3c1477['params']['id']}},_0x4ea3fd={};_0x4ea3fd[_0x95ed('0x34')]=_['keys'](db[_0x95ed('0x43')]['rawAttributes']);_0x4ea3fd[_0x95ed('0x36')]=_[_0x95ed('0x37')](_0x3c1477[_0x95ed('0x36')]);_0x4ea3fd[_0x95ed('0x3e')]=_[_0x95ed('0x48')](_0x4ea3fd['model'],_0x4ea3fd[_0x95ed('0x36')]);_0xaae315[_0x95ed('0x39')]=_[_0x95ed('0x48')](_0x4ea3fd['model'],qs[_0x95ed('0x38')](_0x3c1477['query'][_0x95ed('0x38')]));_0xaae315[_0x95ed('0x39')]=_0xaae315['attributes'][_0x95ed('0x49')]?_0xaae315[_0x95ed('0x39')]:_0x4ea3fd['model'];if(_0x3c1477['query'][_0x95ed('0x44')]){_0xaae315['include']=[{'all':!![]}];}_0xaae315=_[_0x95ed('0x40')]({},_0xaae315,_0x3c1477['options']);return db[_0x95ed('0x43')][_0x95ed('0x4a')](_0xaae315)[_0x95ed('0x26')](handleEntityNotFound(_0x203579,null))[_0x95ed('0x26')](respondWithResult(_0x203579,null))[_0x95ed('0x47')](handleError(_0x203579,null));};exports['create']=function(_0x373f2b,_0x2d0849){return db[_0x95ed('0x43')][_0x95ed('0x4b')](_0x373f2b[_0x95ed('0x4c')],{})[_0x95ed('0x26')](function(_0x25f27d){var _0x26cd04=_0x373f2b[_0x95ed('0x4d')][_0x95ed('0x28')]({'plain':!![]});if(!_0x26cd04)throw new Error(_0x95ed('0x4e'));if(_0x26cd04[_0x95ed('0x4f')]===_0x95ed('0x4d')){var _0x4dc496=_0x25f27d[_0x95ed('0x28')]({'plain':!![]});var _0x6b718e='Projects';return db[_0x95ed('0x50')]['find']({'where':{'name':_0x6b718e,'userProfileId':_0x26cd04[_0x95ed('0x51')]},'raw':!![]})[_0x95ed('0x26')](function(_0x198c7a){if(_0x198c7a&&_0x198c7a[_0x95ed('0x52')]===0x0){return db[_0x95ed('0x2a')][_0x95ed('0x4b')]({'name':_0x4dc496['name'],'resourceId':_0x4dc496['id'],'type':_0x198c7a['name'],'sectionId':_0x198c7a['id']},{})[_0x95ed('0x26')](function(){return _0x25f27d;});}else{return _0x25f27d;}})['catch'](function(_0x2fa867){logger[_0x95ed('0x2c')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x2fa867);throw _0x2fa867;});}return _0x25f27d;})[_0x95ed('0x26')](respondWithResult(_0x2d0849,0xc9))[_0x95ed('0x47')](handleError(_0x2d0849,null));};exports[_0x95ed('0x53')]=function(_0x296f64,_0x5f4083){var _0x4a0b09={'where':{'id':_0x296f64[_0x95ed('0x54')]['id']}},_0x4c7642={};_0x4c7642[_0x95ed('0x34')]=_[_0x95ed('0x37')](db[_0x95ed('0x43')][_0x95ed('0x30')]);_0x4a0b09[_0x95ed('0x39')]=_['intersection'](_0x4c7642[_0x95ed('0x34')],qs[_0x95ed('0x38')](_0x296f64[_0x95ed('0x36')][_0x95ed('0x38')]));_0x4a0b09[_0x95ed('0x39')]=_0x4a0b09['attributes']['length']?_0x4a0b09[_0x95ed('0x39')]:_0x4c7642[_0x95ed('0x34')];if(_0x296f64['query']['includeAll']){_0x4a0b09[_0x95ed('0x45')]=[{'all':!![]}];}_0x4a0b09=_[_0x95ed('0x40')]({},_0x4a0b09,_0x296f64[_0x95ed('0x55')]);return db['JscriptyProject']['find'](_0x4a0b09)['then'](handleEntityNotFound(_0x5f4083,null))[_0x95ed('0x26')](function(_0x5f3cea){if(_0x5f3cea){var _0x1ce0f2=_0x5f3cea[_0x95ed('0x28')]({'plain':!![]});_0x1ce0f2=qs[_0x95ed('0x56')](_0x1ce0f2,['id','createdAt',_0x95ed('0x57')]);_0x296f64[_0x95ed('0x4c')]=_[_0x95ed('0x56')](_0x296f64[_0x95ed('0x4c')],['id',_0x95ed('0x58'),_0x95ed('0x57')]);return db[_0x95ed('0x43')]['create'](_[_0x95ed('0x40')](_0x1ce0f2,_0x296f64[_0x95ed('0x4c')]),{'include':_0x296f64[_0x95ed('0x36')]['includeAll']?[{'all':!![]}]:undefined})['then'](function(_0x368d6c){var _0x4f8b85=_0x296f64[_0x95ed('0x4d')][_0x95ed('0x28')]({'plain':!![]});if(!_0x4f8b85)throw new Error(_0x95ed('0x4e'));if(_0x4f8b85['role']==='user'){var _0x3649ff=_0x368d6c[_0x95ed('0x28')]({'plain':!![]});var _0x1419e7=_0x95ed('0x29');return db[_0x95ed('0x50')][_0x95ed('0x4a')]({'where':{'name':_0x1419e7,'userProfileId':_0x4f8b85[_0x95ed('0x51')]},'raw':!![]})[_0x95ed('0x26')](function(_0x236080){if(_0x236080&&_0x236080[_0x95ed('0x52')]===0x0){return db[_0x95ed('0x2a')][_0x95ed('0x4b')]({'name':_0x3649ff[_0x95ed('0x2e')],'resourceId':_0x3649ff['id'],'type':_0x236080['name'],'sectionId':_0x236080['id']},{})['then'](function(){return _0x368d6c;});}else{return _0x368d6c;}})[_0x95ed('0x47')](function(_0x4c8b52){logger[_0x95ed('0x2c')](_0x95ed('0x59'),_0x4c8b52);throw _0x4c8b52;});}return _0x368d6c;});}})[_0x95ed('0x26')](respondWithResult(_0x5f4083,0xc9))[_0x95ed('0x47')](handleError(_0x5f4083,null));};exports[_0x95ed('0x25')]=function(_0xe45240,_0x375e2f){if(_0xe45240[_0x95ed('0x4c')]['id']){delete _0xe45240[_0x95ed('0x4c')]['id'];}return db[_0x95ed('0x43')][_0x95ed('0x4a')]({'where':{'id':_0xe45240['params']['id']}})[_0x95ed('0x26')](handleEntityNotFound(_0x375e2f,null))[_0x95ed('0x26')](saveUpdates(_0xe45240[_0x95ed('0x4c')],null))[_0x95ed('0x26')](respondWithResult(_0x375e2f,null))[_0x95ed('0x47')](handleError(_0x375e2f,null));};exports[_0x95ed('0x27')]=function(_0x4679ad,_0x546ff6){return db['JscriptyProject']['find']({'where':{'id':_0x4679ad['params']['id']}})[_0x95ed('0x26')](handleEntityNotFound(_0x546ff6,null))[_0x95ed('0x26')](removeEntity(_0x546ff6,null))[_0x95ed('0x47')](handleError(_0x546ff6,null));};exports[_0x95ed('0x5a')]=function(_0x570a8f,_0x566bd7,_0x19e4f1){var _0x525dfb={'raw':!![],'where':{}};var _0x217615={};var _0x5b958b={'count':0x0,'rows':[]};return db['JscriptyProject'][_0x95ed('0x5b')]({'where':{'id':_0x570a8f[_0x95ed('0x54')]['id']}})[_0x95ed('0x26')](handleEntityNotFound(_0x566bd7,null))[_0x95ed('0x26')](function(_0x2d4b1c){if(_0x2d4b1c){_0x217615[_0x95ed('0x34')]=_[_0x95ed('0x37')](db[_0x95ed('0x5c')][_0x95ed('0x30')]);_0x217615[_0x95ed('0x36')]=_[_0x95ed('0x37')](_0x570a8f[_0x95ed('0x36')]);_0x217615[_0x95ed('0x3e')]=_['intersection'](_0x217615[_0x95ed('0x34')],_0x217615[_0x95ed('0x36')]);_0x525dfb[_0x95ed('0x39')]=_[_0x95ed('0x48')](_0x217615[_0x95ed('0x34')],qs[_0x95ed('0x38')](_0x570a8f['query'][_0x95ed('0x38')]));_0x525dfb[_0x95ed('0x39')]=_0x525dfb[_0x95ed('0x39')]['length']?_0x525dfb[_0x95ed('0x39')]:_0x217615[_0x95ed('0x34')];if(!_0x570a8f[_0x95ed('0x36')][_0x95ed('0x3a')](_0x95ed('0x3b'))){_0x525dfb[_0x95ed('0x1e')]=qs['limit'](_0x570a8f[_0x95ed('0x36')]['limit']);_0x525dfb[_0x95ed('0x1d')]=qs[_0x95ed('0x1d')](_0x570a8f['query'][_0x95ed('0x1d')]);}_0x525dfb['order']=qs[_0x95ed('0x3c')](_0x570a8f['query']['sort']);_0x525dfb[_0x95ed('0x3d')]=qs[_0x95ed('0x3e')](_[_0x95ed('0x3f')](_0x570a8f[_0x95ed('0x36')],_0x217615[_0x95ed('0x3e')]));_0x525dfb[_0x95ed('0x3d')][_0x95ed('0x5d')]=_0x2d4b1c['id'];if(_0x570a8f[_0x95ed('0x36')][_0x95ed('0x42')]){_0x525dfb[_0x95ed('0x3d')]=_[_0x95ed('0x40')](_0x525dfb[_0x95ed('0x3d')],{'$or':_[_0x95ed('0x35')](_0x525dfb[_0x95ed('0x39')],function(_0x4dacef){var _0x2d623e={};_0x2d623e[_0x4dacef]={'$like':'%'+_0x570a8f['query']['filter']+'%'};return _0x2d623e;})});}_0x525dfb=_[_0x95ed('0x40')]({},_0x525dfb,_0x570a8f[_0x95ed('0x55')]);return db['JscriptySessionReport']['count']({'where':_0x525dfb[_0x95ed('0x3d')]})[_0x95ed('0x26')](function(_0x807f5b){_0x5b958b[_0x95ed('0x1c')]=_0x807f5b;if(_0x570a8f[_0x95ed('0x36')][_0x95ed('0x44')]){_0x525dfb['include']=[{'all':!![]}];}return db['JscriptySessionReport']['findAll'](_0x525dfb);})[_0x95ed('0x26')](function(_0x49c503){_0x5b958b['rows']=_0x49c503;return _0x5b958b;});}})[_0x95ed('0x26')](respondWithFilteredResult(_0x566bd7,_0x525dfb))[_0x95ed('0x47')](handleError(_0x566bd7,null));};exports[_0x95ed('0x5e')]=function(_0x237f55,_0xe39280,_0x292b0e){var _0x69fe2c={'raw':!![],'where':{}};var _0x3ffc4c={};var _0x44dc25={'count':0x0,'rows':[]};return db[_0x95ed('0x43')][_0x95ed('0x5b')]({'where':{'id':_0x237f55['params']['id']}})[_0x95ed('0x26')](handleEntityNotFound(_0xe39280,null))[_0x95ed('0x26')](function(_0x41ec06){if(_0x41ec06){_0x3ffc4c[_0x95ed('0x34')]=_[_0x95ed('0x37')](db[_0x95ed('0x5f')][_0x95ed('0x30')]);_0x3ffc4c[_0x95ed('0x36')]=_['keys'](_0x237f55[_0x95ed('0x36')]);_0x3ffc4c[_0x95ed('0x3e')]=_[_0x95ed('0x48')](_0x3ffc4c[_0x95ed('0x34')],_0x3ffc4c[_0x95ed('0x36')]);_0x69fe2c[_0x95ed('0x39')]=_[_0x95ed('0x48')](_0x3ffc4c[_0x95ed('0x34')],qs[_0x95ed('0x38')](_0x237f55[_0x95ed('0x36')][_0x95ed('0x38')]));_0x69fe2c['attributes']=_0x69fe2c[_0x95ed('0x39')][_0x95ed('0x49')]?_0x69fe2c[_0x95ed('0x39')]:_0x3ffc4c[_0x95ed('0x34')];if(!_0x237f55[_0x95ed('0x36')]['hasOwnProperty'](_0x95ed('0x3b'))){_0x69fe2c[_0x95ed('0x1e')]=qs[_0x95ed('0x1e')](_0x237f55[_0x95ed('0x36')][_0x95ed('0x1e')]);_0x69fe2c[_0x95ed('0x1d')]=qs[_0x95ed('0x1d')](_0x237f55[_0x95ed('0x36')][_0x95ed('0x1d')]);}_0x69fe2c[_0x95ed('0x60')]=qs['sort'](_0x237f55[_0x95ed('0x36')][_0x95ed('0x3c')]);_0x69fe2c[_0x95ed('0x3d')]=qs[_0x95ed('0x3e')](_[_0x95ed('0x3f')](_0x237f55[_0x95ed('0x36')],_0x3ffc4c[_0x95ed('0x3e')]));_0x69fe2c[_0x95ed('0x3d')][_0x95ed('0x5d')]=_0x41ec06['id'];if(_0x237f55[_0x95ed('0x36')][_0x95ed('0x42')]){_0x69fe2c[_0x95ed('0x3d')]=_['merge'](_0x69fe2c['where'],{'$or':_['map'](_0x69fe2c['attributes'],function(_0x4631b6){var _0x3ca3d5={};_0x3ca3d5[_0x4631b6]={'$like':'%'+_0x237f55['query']['filter']+'%'};return _0x3ca3d5;})});}_0x69fe2c=_[_0x95ed('0x40')]({},_0x69fe2c,_0x237f55[_0x95ed('0x55')]);return db[_0x95ed('0x5f')]['count']({'where':_0x69fe2c['where']})[_0x95ed('0x26')](function(_0x558f32){_0x44dc25['count']=_0x558f32;if(_0x237f55['query']['includeAll']){_0x69fe2c[_0x95ed('0x45')]=[{'all':!![]}];}return db[_0x95ed('0x5f')][_0x95ed('0x61')](_0x69fe2c);})[_0x95ed('0x26')](function(_0x2146b0){_0x44dc25['rows']=_0x2146b0;return _0x44dc25;});}})['then'](respondWithFilteredResult(_0xe39280,_0x69fe2c))['catch'](handleError(_0xe39280,null));};function char(_0x2ebb86){return'number'===typeof _0x2ebb86?String[_0x95ed('0x62')][_0x95ed('0x22')](null,arguments):_0x2ebb86;}function needsEncapsulation(_0x4ae1c9){return!!_0x4ae1c9&&(_0x4ae1c9[_0x95ed('0x63')]()[_0x95ed('0x64')](char(0xd))>=0x0||_0x4ae1c9[_0x95ed('0x63')]()[_0x95ed('0x64')](char(0xa))>=0x0||_0x4ae1c9[_0x95ed('0x63')]()[_0x95ed('0x64')](char(0x2c))>=0x0||_0x4ae1c9[_0x95ed('0x63')]()['indexOf'](char(0x22))>=0x0);}function encapsulate(_0x1f496e){var _0x2ad9a5=char(0x22),_0xd13ac6='\x5c'+char(0x22),_0x32ddca=_0x1f496e[_0x95ed('0x63')]()['replace'](new RegExp(_0x2ad9a5,'g'),_0xd13ac6);return _0x2ad9a5+_0x32ddca+_0x2ad9a5;}exports[_0x95ed('0x65')]=function(_0x4de4e2,_0x5ac297,_0x752b59){var _0x3ccdbc,_0x559250;var _0x3c0895={'where':{'ProjectId':_0x4de4e2[_0x95ed('0x54')]['id']}};if(_0x4de4e2[_0x95ed('0x36')]['startTime']){_0x3c0895['where'][_0x95ed('0x66')]=JSON[_0x95ed('0x67')](_0x4de4e2[_0x95ed('0x36')][_0x95ed('0x68')]);}return db['JscriptySessionReport'][_0x95ed('0x61')](_0x3c0895)[_0x95ed('0x26')](handleEntityNotFound(_0x5ac297,null))[_0x95ed('0x26')](function(_0x5bc52c){if(_0x5bc52c){_0x3ccdbc=_0x5bc52c;return db[_0x95ed('0x69')][_0x95ed('0x61')]({'where':{'SessionId':{'$in':_[_0x95ed('0x35')](_0x3ccdbc,'id')},'ProjectId':_0x4de4e2['params']['id']},'order':_0x95ed('0x6a')});}})[_0x95ed('0x26')](handleEntityNotFound(_0x5ac297,null))[_0x95ed('0x26')](function(_0x5ac32b){if(_0x5ac32b){_0x559250=_0x5ac32b;var _0x25201d={};for(var _0x2c3b98=0x0,_0x4a21bb=_0x559250[_0x95ed('0x49')];_0x2c3b98<_0x4a21bb;_0x2c3b98++){if(!_0x25201d['hasOwnProperty'](_0x559250[_0x2c3b98][_0x95ed('0x6b')])){_0x25201d[_0x559250[_0x2c3b98][_0x95ed('0x6b')]]=needsEncapsulation(_0x559250[_0x2c3b98][_0x95ed('0x6c')])?encapsulate(_0x559250[_0x2c3b98][_0x95ed('0x6c')]):_0x559250[_0x2c3b98][_0x95ed('0x6c')];}}var _0x34b0c4=[],_0x1afc3f={};for(var _0x5cbd70=0x0,_0x7c1456=_0x3ccdbc[_0x95ed('0x49')];_0x5cbd70<_0x7c1456;_0x5cbd70++){_0x1afc3f={'ProjectId':_0x4de4e2[_0x95ed('0x54')]['id'],'SessionId':_0x3ccdbc[_0x5cbd70]['id'],'StartTime':moment(_0x3ccdbc[_0x5cbd70][_0x95ed('0x66')])[_0x95ed('0x6d')]('YYYY-MM-DD\x20HH:mm:ss')};for(var _0x15e981=0x0,_0x4c38b2=_0x559250['length'];_0x15e981<_0x4c38b2;_0x15e981++){if(_0x559250[_0x15e981][_0x95ed('0x6e')]==_0x3ccdbc[_0x5cbd70]['id']&&_0x25201d[_0x95ed('0x3a')](_0x559250[_0x15e981][_0x95ed('0x6b')])){_0x1afc3f[_0x25201d[_0x559250[_0x15e981]['questionId']]]=_0x559250[_0x15e981][_0x95ed('0x6f')];}}for(var _0x1d5881 in _0x25201d){if(!_0x1afc3f[_0x95ed('0x3a')](_0x25201d[_0x1d5881])){_0x1afc3f[_0x25201d[_0x1d5881]]=null;}}_0x34b0c4[_0x95ed('0x70')](_0x1afc3f);}return _0x34b0c4;}})[_0x95ed('0x26')](function(_0x5ac026){if(!_[_0x95ed('0x71')](_0x5ac026)){var _0x21509e=toCsv(_0x5ac026);var _0x16f2dd=Date[_0x95ed('0x72')]();fs[_0x95ed('0x73')](util['format']('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x4de4e2[_0x95ed('0x54')]['id'],_0x16f2dd),_0x21509e);_0x5ac297['setHeader'](_0x95ed('0x74'),_0x95ed('0x75')+util[_0x95ed('0x6d')](_0x95ed('0x76'),_0x4de4e2[_0x95ed('0x54')]['id'],_0x16f2dd));_0x5ac297[_0x95ed('0x77')](_0x95ed('0x78'),_0x95ed('0x79'));return _0x5ac297[_0x95ed('0x7a')](util[_0x95ed('0x6d')](_0x95ed('0x7b'),_0x4de4e2[_0x95ed('0x54')]['id'],_0x16f2dd));}else{return _0x5ac297[_0x95ed('0x2b')](0xcc);}})['catch'](handleError(_0x5ac297,null));};
\ No newline at end of file
+var _0x23a3=['fields','length','hasOwnProperty','nolimit','order','sort','where','filter','merge','map','VIRTUAL','options','includeAll','include','findAll','rows','show','params','rawAttributes','find','catch','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','UserProfileSection','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','updatedAt','userProfileId','getSessions','findOne','JscriptySessionReport','pick','getAnswers','JscriptyAnswerReport','ProjectId','number','fromCharCode','toString','indexOf','getSummary','starttime','parse','startTime','-createdAt','questionId','question','format','YYYY-MM-DD\x20HH:mm:ss','SessionId','push','now','writeFileSync','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','Content-type','text/csv','download','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','squel','crypto','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','status','undefined','limit','count','offset','Content-Range','apply','save','update','destroy','then','get','Projects','UserProfileResource','end','sendStatus','error','stack','name','send','JscriptyProject','fieldName','type','key','model','keys','filters','intersection','query','attributes'];(function(_0x2ed3a2,_0x5cc62a){var _0xf11bbc=function(_0x241d9d){while(--_0x241d9d){_0x2ed3a2['push'](_0x2ed3a2['shift']());}};_0xf11bbc(++_0x5cc62a);}(_0x23a3,0x131));var _0x323a=function(_0x4237d8,_0x13cc54){_0x4237d8=_0x4237d8-0x0;var _0x1e8caf=_0x23a3[_0x4237d8];return _0x1e8caf;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0x323a('0x0'));var rp=require('request-promise');var moment=require(_0x323a('0x1'));var BPromise=require(_0x323a('0x2'));var Mustache=require(_0x323a('0x3'));var util=require(_0x323a('0x4'));var path=require(_0x323a('0x5'));var sox=require(_0x323a('0x6'));var csv=require(_0x323a('0x7'));var ejs=require(_0x323a('0x8'));var fs=require('fs');var fs_extra=require(_0x323a('0x9'));var _=require('lodash');var squel=require(_0x323a('0xa'));var crypto=require(_0x323a('0xb'));var jsforce=require('jsforce');var deskjs=require(_0x323a('0xc'));var toCsv=require(_0x323a('0x7'));var querystring=require(_0x323a('0xd'));var Papa=require('papaparse');var Redis=require(_0x323a('0xe'));var authService=require(_0x323a('0xf'));var qs=require(_0x323a('0x10'));var as=require(_0x323a('0x11'));var hardwareService=require(_0x323a('0x12'));var logger=require(_0x323a('0x13'))(_0x323a('0x14'));var utils=require(_0x323a('0x15'));var config=require(_0x323a('0x16'));var licenseUtil=require(_0x323a('0x17'));var db=require(_0x323a('0x18'))['db'];function respondWithStatusCode(_0x33d226,_0x460fd8){_0x460fd8=_0x460fd8||0xcc;return function(_0x1ae315){if(_0x1ae315){return _0x33d226['sendStatus'](_0x460fd8);}return _0x33d226[_0x323a('0x19')](_0x460fd8)['end']();};}function respondWithResult(_0x16b92e,_0x4ccd19){_0x4ccd19=_0x4ccd19||0xc8;return function(_0x5f3922){if(_0x5f3922){return _0x16b92e[_0x323a('0x19')](_0x4ccd19)['json'](_0x5f3922);}};}function respondWithFilteredResult(_0x46c247,_0x582631){return function(_0x1cc64d){if(_0x1cc64d){var _0x64003=typeof _0x582631['offset']===_0x323a('0x1a')&&typeof _0x582631[_0x323a('0x1b')]==='undefined';var _0x5c1947=_0x1cc64d[_0x323a('0x1c')];var _0x221ae4=_0x64003?0x0:_0x582631[_0x323a('0x1d')];var _0x29dd21=_0x64003?_0x1cc64d[_0x323a('0x1c')]:_0x582631[_0x323a('0x1d')]+_0x582631['limit'];var _0x5bf1c9;if(_0x29dd21>=_0x5c1947){_0x29dd21=_0x5c1947;_0x5bf1c9=0xc8;}else{_0x5bf1c9=0xce;}_0x46c247['status'](_0x5bf1c9);return _0x46c247['set'](_0x323a('0x1e'),_0x221ae4+'-'+_0x29dd21+'/'+_0x5c1947)['json'](_0x1cc64d);}return null;};}function patchUpdates(_0xc0f3e4){return function(_0x38bc95){try{jsonpatch[_0x323a('0x1f')](_0x38bc95,_0xc0f3e4,!![]);}catch(_0xd35d83){return BPromise['reject'](_0xd35d83);}return _0x38bc95[_0x323a('0x20')]();};}function saveUpdates(_0x549e64,_0x12c8d7){return function(_0x323517){if(_0x323517){return _0x323517[_0x323a('0x21')](_0x549e64)['then'](function(_0x41ea3d){return _0x41ea3d;});}return null;};}function removeEntity(_0x358bcb,_0x36d4d9){return function(_0x2960e0){if(_0x2960e0){return _0x2960e0[_0x323a('0x22')]()[_0x323a('0x23')](function(){var _0x5ba015=_0x2960e0[_0x323a('0x24')]({'plain':!![]});var _0x5d82c2=_0x323a('0x25');return db[_0x323a('0x26')][_0x323a('0x22')]({'where':{'type':_0x5d82c2,'resourceId':_0x5ba015['id']}})[_0x323a('0x23')](function(){return _0x2960e0;});})[_0x323a('0x23')](function(){_0x358bcb['status'](0xcc)[_0x323a('0x27')]();});}};}function handleEntityNotFound(_0x384c93,_0x30dbe6){return function(_0x17907c){if(!_0x17907c){_0x384c93[_0x323a('0x28')](0x194);}return _0x17907c;};}function handleError(_0x4ba792,_0x23a989){_0x23a989=_0x23a989||0x1f4;return function(_0x571264){logger[_0x323a('0x29')](_0x571264[_0x323a('0x2a')]);if(_0x571264[_0x323a('0x2b')]){delete _0x571264[_0x323a('0x2b')];}_0x4ba792[_0x323a('0x19')](_0x23a989)[_0x323a('0x2c')](_0x571264);};}exports['index']=function(_0x2a1a85,_0x3f6809){var _0x580c2b={},_0x32c05b={},_0x4abf8d={'count':0x0,'rows':[]};var _0x4a70dd=_['map'](db[_0x323a('0x2d')]['rawAttributes'],function(_0x2a8da8){return{'name':_0x2a8da8[_0x323a('0x2e')],'type':_0x2a8da8[_0x323a('0x2f')][_0x323a('0x30')]};});_0x32c05b[_0x323a('0x31')]=_['map'](_0x4a70dd,_0x323a('0x2b'));_0x32c05b['query']=_[_0x323a('0x32')](_0x2a1a85['query']);_0x32c05b[_0x323a('0x33')]=_[_0x323a('0x34')](_0x32c05b['model'],_0x32c05b[_0x323a('0x35')]);_0x580c2b[_0x323a('0x36')]=_[_0x323a('0x34')](_0x32c05b[_0x323a('0x31')],qs[_0x323a('0x37')](_0x2a1a85[_0x323a('0x35')][_0x323a('0x37')]));_0x580c2b[_0x323a('0x36')]=_0x580c2b['attributes'][_0x323a('0x38')]?_0x580c2b[_0x323a('0x36')]:_0x32c05b[_0x323a('0x31')];if(!_0x2a1a85[_0x323a('0x35')][_0x323a('0x39')](_0x323a('0x3a'))){_0x580c2b[_0x323a('0x1b')]=qs['limit'](_0x2a1a85['query'][_0x323a('0x1b')]);_0x580c2b[_0x323a('0x1d')]=qs[_0x323a('0x1d')](_0x2a1a85['query'][_0x323a('0x1d')]);}_0x580c2b[_0x323a('0x3b')]=qs[_0x323a('0x3c')](_0x2a1a85[_0x323a('0x35')]['sort']);_0x580c2b[_0x323a('0x3d')]=qs[_0x323a('0x33')](_['pick'](_0x2a1a85['query'],_0x32c05b[_0x323a('0x33')]),_0x4a70dd);if(_0x2a1a85['query'][_0x323a('0x3e')]){_0x580c2b[_0x323a('0x3d')]=_[_0x323a('0x3f')](_0x580c2b['where'],{'$or':_[_0x323a('0x40')](_0x4a70dd,function(_0x52f80f){if(_0x52f80f[_0x323a('0x2f')]!==_0x323a('0x41')){var _0x2d6c6f={};_0x2d6c6f[_0x52f80f[_0x323a('0x2b')]]={'$like':'%'+_0x2a1a85[_0x323a('0x35')][_0x323a('0x3e')]+'%'};return _0x2d6c6f;}})});}_0x580c2b=_['merge']({},_0x580c2b,_0x2a1a85[_0x323a('0x42')]);var _0xcff0c6={'where':_0x580c2b[_0x323a('0x3d')]};return db[_0x323a('0x2d')][_0x323a('0x1c')](_0xcff0c6)['then'](function(_0x1482d2){_0x4abf8d[_0x323a('0x1c')]=_0x1482d2;if(_0x2a1a85['query'][_0x323a('0x43')]){_0x580c2b[_0x323a('0x44')]=[{'all':!![]}];}return db[_0x323a('0x2d')][_0x323a('0x45')](_0x580c2b);})[_0x323a('0x23')](function(_0x599b28){_0x4abf8d[_0x323a('0x46')]=_0x599b28;return _0x4abf8d;})['then'](respondWithFilteredResult(_0x3f6809,_0x580c2b))['catch'](handleError(_0x3f6809,null));};exports[_0x323a('0x47')]=function(_0x3543a7,_0x3d98ce){var _0x357a22={'raw':![],'where':{'id':_0x3543a7[_0x323a('0x48')]['id']}},_0x5284dd={};_0x5284dd[_0x323a('0x31')]=_[_0x323a('0x32')](db[_0x323a('0x2d')][_0x323a('0x49')]);_0x5284dd['query']=_[_0x323a('0x32')](_0x3543a7[_0x323a('0x35')]);_0x5284dd['filters']=_['intersection'](_0x5284dd[_0x323a('0x31')],_0x5284dd[_0x323a('0x35')]);_0x357a22[_0x323a('0x36')]=_['intersection'](_0x5284dd[_0x323a('0x31')],qs[_0x323a('0x37')](_0x3543a7[_0x323a('0x35')]['fields']));_0x357a22[_0x323a('0x36')]=_0x357a22[_0x323a('0x36')][_0x323a('0x38')]?_0x357a22[_0x323a('0x36')]:_0x5284dd[_0x323a('0x31')];if(_0x3543a7[_0x323a('0x35')][_0x323a('0x43')]){_0x357a22[_0x323a('0x44')]=[{'all':!![]}];}_0x357a22=_[_0x323a('0x3f')]({},_0x357a22,_0x3543a7[_0x323a('0x42')]);return db[_0x323a('0x2d')][_0x323a('0x4a')](_0x357a22)['then'](handleEntityNotFound(_0x3d98ce,null))[_0x323a('0x23')](respondWithResult(_0x3d98ce,null))[_0x323a('0x4b')](handleError(_0x3d98ce,null));};exports[_0x323a('0x4c')]=function(_0x4dc7da,_0x481f08){return db[_0x323a('0x2d')][_0x323a('0x4c')](_0x4dc7da[_0x323a('0x4d')],{})[_0x323a('0x23')](function(_0x5686f0){var _0x2616bd=_0x4dc7da['user'][_0x323a('0x24')]({'plain':!![]});if(!_0x2616bd)throw new Error(_0x323a('0x4e'));if(_0x2616bd[_0x323a('0x4f')]===_0x323a('0x50')){var _0x2cb64b=_0x5686f0['get']({'plain':!![]});var _0x2f1a14=_0x323a('0x25');return db[_0x323a('0x51')][_0x323a('0x4a')]({'where':{'name':_0x2f1a14,'userProfileId':_0x2616bd['userProfileId']},'raw':!![]})[_0x323a('0x23')](function(_0x5c590e){if(_0x5c590e&&_0x5c590e[_0x323a('0x52')]===0x0){return db[_0x323a('0x26')][_0x323a('0x4c')]({'name':_0x2cb64b[_0x323a('0x2b')],'resourceId':_0x2cb64b['id'],'type':_0x5c590e[_0x323a('0x2b')],'sectionId':_0x5c590e['id']},{})[_0x323a('0x23')](function(){return _0x5686f0;});}else{return _0x5686f0;}})[_0x323a('0x4b')](function(_0x101357){logger[_0x323a('0x29')](_0x323a('0x53'),_0x101357);throw _0x101357;});}return _0x5686f0;})['then'](respondWithResult(_0x481f08,0xc9))['catch'](handleError(_0x481f08,null));};exports[_0x323a('0x54')]=function(_0x14502c,_0x2d86dc){var _0x45ced7={'where':{'id':_0x14502c[_0x323a('0x48')]['id']}},_0x2875ce={};_0x2875ce['model']=_[_0x323a('0x32')](db[_0x323a('0x2d')][_0x323a('0x49')]);_0x45ced7['attributes']=_[_0x323a('0x34')](_0x2875ce[_0x323a('0x31')],qs['fields'](_0x14502c[_0x323a('0x35')]['fields']));_0x45ced7[_0x323a('0x36')]=_0x45ced7[_0x323a('0x36')][_0x323a('0x38')]?_0x45ced7[_0x323a('0x36')]:_0x2875ce['model'];if(_0x14502c[_0x323a('0x35')]['includeAll']){_0x45ced7[_0x323a('0x44')]=[{'all':!![]}];}_0x45ced7=_['merge']({},_0x45ced7,_0x14502c[_0x323a('0x42')]);return db[_0x323a('0x2d')]['find'](_0x45ced7)[_0x323a('0x23')](handleEntityNotFound(_0x2d86dc,null))['then'](function(_0x1aa6dd){if(_0x1aa6dd){var _0x387b40=_0x1aa6dd['get']({'plain':!![]});_0x387b40=qs[_0x323a('0x55')](_0x387b40,['id',_0x323a('0x56'),_0x323a('0x57')]);_0x14502c['body']=_[_0x323a('0x55')](_0x14502c[_0x323a('0x4d')],['id',_0x323a('0x56'),_0x323a('0x57')]);return db[_0x323a('0x2d')][_0x323a('0x4c')](_[_0x323a('0x3f')](_0x387b40,_0x14502c[_0x323a('0x4d')]),{'include':_0x14502c[_0x323a('0x35')][_0x323a('0x43')]?[{'all':!![]}]:undefined})[_0x323a('0x23')](function(_0x1e540e){var _0x181072=_0x14502c[_0x323a('0x50')][_0x323a('0x24')]({'plain':!![]});if(!_0x181072)throw new Error(_0x323a('0x4e'));if(_0x181072['role']===_0x323a('0x50')){var _0x188777=_0x1e540e[_0x323a('0x24')]({'plain':!![]});var _0x40df26='Projects';return db['UserProfileSection']['find']({'where':{'name':_0x40df26,'userProfileId':_0x181072[_0x323a('0x58')]},'raw':!![]})[_0x323a('0x23')](function(_0x17a608){if(_0x17a608&&_0x17a608[_0x323a('0x52')]===0x0){return db[_0x323a('0x26')][_0x323a('0x4c')]({'name':_0x188777[_0x323a('0x2b')],'resourceId':_0x188777['id'],'type':_0x17a608[_0x323a('0x2b')],'sectionId':_0x17a608['id']},{})[_0x323a('0x23')](function(){return _0x1e540e;});}else{return _0x1e540e;}})[_0x323a('0x4b')](function(_0x1291aa){logger[_0x323a('0x29')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x1291aa);throw _0x1291aa;});}return _0x1e540e;});}})[_0x323a('0x23')](respondWithResult(_0x2d86dc,0xc9))[_0x323a('0x4b')](handleError(_0x2d86dc,null));};exports[_0x323a('0x21')]=function(_0x5e4fb3,_0x3744f9){if(_0x5e4fb3[_0x323a('0x4d')]['id']){delete _0x5e4fb3[_0x323a('0x4d')]['id'];}return db['JscriptyProject']['find']({'where':{'id':_0x5e4fb3['params']['id']}})[_0x323a('0x23')](handleEntityNotFound(_0x3744f9,null))[_0x323a('0x23')](saveUpdates(_0x5e4fb3[_0x323a('0x4d')],null))[_0x323a('0x23')](respondWithResult(_0x3744f9,null))[_0x323a('0x4b')](handleError(_0x3744f9,null));};exports[_0x323a('0x22')]=function(_0x205d9f,_0x484f2a){return db['JscriptyProject']['find']({'where':{'id':_0x205d9f['params']['id']}})['then'](handleEntityNotFound(_0x484f2a,null))[_0x323a('0x23')](removeEntity(_0x484f2a,null))[_0x323a('0x4b')](handleError(_0x484f2a,null));};exports[_0x323a('0x59')]=function(_0x605792,_0x1ee247,_0xed1022){var _0x11e7c8={'raw':!![],'where':{}};var _0x540b8c={};var _0x39e692={'count':0x0,'rows':[]};return db['JscriptyProject'][_0x323a('0x5a')]({'where':{'id':_0x605792['params']['id']}})['then'](handleEntityNotFound(_0x1ee247,null))['then'](function(_0x4916e0){if(_0x4916e0){_0x540b8c[_0x323a('0x31')]=_['keys'](db[_0x323a('0x5b')]['rawAttributes']);_0x540b8c[_0x323a('0x35')]=_[_0x323a('0x32')](_0x605792[_0x323a('0x35')]);_0x540b8c['filters']=_['intersection'](_0x540b8c[_0x323a('0x31')],_0x540b8c[_0x323a('0x35')]);_0x11e7c8[_0x323a('0x36')]=_[_0x323a('0x34')](_0x540b8c['model'],qs[_0x323a('0x37')](_0x605792[_0x323a('0x35')][_0x323a('0x37')]));_0x11e7c8[_0x323a('0x36')]=_0x11e7c8[_0x323a('0x36')]['length']?_0x11e7c8[_0x323a('0x36')]:_0x540b8c[_0x323a('0x31')];if(!_0x605792[_0x323a('0x35')][_0x323a('0x39')](_0x323a('0x3a'))){_0x11e7c8[_0x323a('0x1b')]=qs[_0x323a('0x1b')](_0x605792['query']['limit']);_0x11e7c8[_0x323a('0x1d')]=qs['offset'](_0x605792[_0x323a('0x35')]['offset']);}_0x11e7c8[_0x323a('0x3b')]=qs[_0x323a('0x3c')](_0x605792['query'][_0x323a('0x3c')]);_0x11e7c8[_0x323a('0x3d')]=qs[_0x323a('0x33')](_[_0x323a('0x5c')](_0x605792['query'],_0x540b8c[_0x323a('0x33')]));_0x11e7c8[_0x323a('0x3d')]['ProjectId']=_0x4916e0['id'];if(_0x605792['query'][_0x323a('0x3e')]){_0x11e7c8['where']=_['merge'](_0x11e7c8[_0x323a('0x3d')],{'$or':_[_0x323a('0x40')](_0x11e7c8[_0x323a('0x36')],function(_0x1ec023){var _0x26e50d={};_0x26e50d[_0x1ec023]={'$like':'%'+_0x605792[_0x323a('0x35')][_0x323a('0x3e')]+'%'};return _0x26e50d;})});}_0x11e7c8=_[_0x323a('0x3f')]({},_0x11e7c8,_0x605792['options']);return db[_0x323a('0x5b')]['count']({'where':_0x11e7c8[_0x323a('0x3d')]})['then'](function(_0x540997){_0x39e692[_0x323a('0x1c')]=_0x540997;if(_0x605792[_0x323a('0x35')][_0x323a('0x43')]){_0x11e7c8[_0x323a('0x44')]=[{'all':!![]}];}return db[_0x323a('0x5b')][_0x323a('0x45')](_0x11e7c8);})[_0x323a('0x23')](function(_0xac7a0a){_0x39e692['rows']=_0xac7a0a;return _0x39e692;});}})[_0x323a('0x23')](respondWithFilteredResult(_0x1ee247,_0x11e7c8))[_0x323a('0x4b')](handleError(_0x1ee247,null));};exports[_0x323a('0x5d')]=function(_0x36db83,_0x1caf86,_0x3ab588){var _0x10dced={'raw':!![],'where':{}};var _0x390bed={};var _0x4ba690={'count':0x0,'rows':[]};return db[_0x323a('0x2d')][_0x323a('0x5a')]({'where':{'id':_0x36db83[_0x323a('0x48')]['id']}})[_0x323a('0x23')](handleEntityNotFound(_0x1caf86,null))[_0x323a('0x23')](function(_0x2c61b8){if(_0x2c61b8){_0x390bed[_0x323a('0x31')]=_['keys'](db[_0x323a('0x5e')]['rawAttributes']);_0x390bed[_0x323a('0x35')]=_[_0x323a('0x32')](_0x36db83[_0x323a('0x35')]);_0x390bed[_0x323a('0x33')]=_[_0x323a('0x34')](_0x390bed[_0x323a('0x31')],_0x390bed[_0x323a('0x35')]);_0x10dced['attributes']=_[_0x323a('0x34')](_0x390bed[_0x323a('0x31')],qs[_0x323a('0x37')](_0x36db83['query'][_0x323a('0x37')]));_0x10dced[_0x323a('0x36')]=_0x10dced[_0x323a('0x36')][_0x323a('0x38')]?_0x10dced['attributes']:_0x390bed['model'];if(!_0x36db83[_0x323a('0x35')][_0x323a('0x39')](_0x323a('0x3a'))){_0x10dced[_0x323a('0x1b')]=qs[_0x323a('0x1b')](_0x36db83[_0x323a('0x35')][_0x323a('0x1b')]);_0x10dced['offset']=qs[_0x323a('0x1d')](_0x36db83[_0x323a('0x35')][_0x323a('0x1d')]);}_0x10dced['order']=qs[_0x323a('0x3c')](_0x36db83[_0x323a('0x35')][_0x323a('0x3c')]);_0x10dced[_0x323a('0x3d')]=qs[_0x323a('0x33')](_[_0x323a('0x5c')](_0x36db83[_0x323a('0x35')],_0x390bed[_0x323a('0x33')]));_0x10dced[_0x323a('0x3d')][_0x323a('0x5f')]=_0x2c61b8['id'];if(_0x36db83[_0x323a('0x35')][_0x323a('0x3e')]){_0x10dced[_0x323a('0x3d')]=_['merge'](_0x10dced['where'],{'$or':_[_0x323a('0x40')](_0x10dced['attributes'],function(_0x3116ff){var _0x523b3a={};_0x523b3a[_0x3116ff]={'$like':'%'+_0x36db83[_0x323a('0x35')]['filter']+'%'};return _0x523b3a;})});}_0x10dced=_[_0x323a('0x3f')]({},_0x10dced,_0x36db83['options']);return db[_0x323a('0x5e')][_0x323a('0x1c')]({'where':_0x10dced[_0x323a('0x3d')]})[_0x323a('0x23')](function(_0x8e860f){_0x4ba690['count']=_0x8e860f;if(_0x36db83[_0x323a('0x35')][_0x323a('0x43')]){_0x10dced['include']=[{'all':!![]}];}return db[_0x323a('0x5e')][_0x323a('0x45')](_0x10dced);})[_0x323a('0x23')](function(_0x3a6183){_0x4ba690[_0x323a('0x46')]=_0x3a6183;return _0x4ba690;});}})[_0x323a('0x23')](respondWithFilteredResult(_0x1caf86,_0x10dced))[_0x323a('0x4b')](handleError(_0x1caf86,null));};function char(_0x5e3986){return _0x323a('0x60')===typeof _0x5e3986?String[_0x323a('0x61')][_0x323a('0x1f')](null,arguments):_0x5e3986;}function needsEncapsulation(_0x255a0a){return!!_0x255a0a&&(_0x255a0a[_0x323a('0x62')]()[_0x323a('0x63')](char(0xd))>=0x0||_0x255a0a[_0x323a('0x62')]()['indexOf'](char(0xa))>=0x0||_0x255a0a[_0x323a('0x62')]()['indexOf'](char(0x2c))>=0x0||_0x255a0a[_0x323a('0x62')]()[_0x323a('0x63')](char(0x22))>=0x0);}function encapsulate(_0x5ec090){var _0xf5ea70=char(0x22),_0x4f359b='\x5c'+char(0x22),_0x4ab9b3=_0x5ec090[_0x323a('0x62')]()['replace'](new RegExp(_0xf5ea70,'g'),_0x4f359b);return _0xf5ea70+_0x4ab9b3+_0xf5ea70;}exports[_0x323a('0x64')]=function(_0xbecdc2,_0x3b1e42,_0x2c3680){var _0x612998,_0x1d6647;var _0x2abd47={'where':{'ProjectId':_0xbecdc2[_0x323a('0x48')]['id']}};if(_0xbecdc2['query']['startTime']){_0x2abd47[_0x323a('0x3d')][_0x323a('0x65')]=JSON[_0x323a('0x66')](_0xbecdc2[_0x323a('0x35')][_0x323a('0x67')]);}return db['JscriptySessionReport'][_0x323a('0x45')](_0x2abd47)[_0x323a('0x23')](handleEntityNotFound(_0x3b1e42,null))[_0x323a('0x23')](function(_0x286f7d){if(_0x286f7d){_0x612998=_0x286f7d;return db['JscriptyQuestionReport'][_0x323a('0x45')]({'where':{'SessionId':{'$in':_[_0x323a('0x40')](_0x612998,'id')},'ProjectId':_0xbecdc2['params']['id']},'order':_0x323a('0x68')});}})['then'](handleEntityNotFound(_0x3b1e42,null))[_0x323a('0x23')](function(_0x6aa585){if(_0x6aa585){_0x1d6647=_0x6aa585;var _0x923da6={};for(var _0x2b3dcf=0x0,_0x5d1326=_0x1d6647[_0x323a('0x38')];_0x2b3dcf<_0x5d1326;_0x2b3dcf++){if(!_0x923da6[_0x323a('0x39')](_0x1d6647[_0x2b3dcf][_0x323a('0x69')])){_0x923da6[_0x1d6647[_0x2b3dcf]['questionId']]=needsEncapsulation(_0x1d6647[_0x2b3dcf]['question'])?encapsulate(_0x1d6647[_0x2b3dcf][_0x323a('0x6a')]):_0x1d6647[_0x2b3dcf][_0x323a('0x6a')];}}var _0x392b19=[],_0x543e08={};for(var _0x43457f=0x0,_0xd9e118=_0x612998[_0x323a('0x38')];_0x43457f<_0xd9e118;_0x43457f++){_0x543e08={'ProjectId':_0xbecdc2[_0x323a('0x48')]['id'],'SessionId':_0x612998[_0x43457f]['id'],'StartTime':moment(_0x612998[_0x43457f][_0x323a('0x65')])[_0x323a('0x6b')](_0x323a('0x6c'))};for(var _0x61ca84=0x0,_0x203bb1=_0x1d6647['length'];_0x61ca84<_0x203bb1;_0x61ca84++){if(_0x1d6647[_0x61ca84][_0x323a('0x6d')]==_0x612998[_0x43457f]['id']&&_0x923da6['hasOwnProperty'](_0x1d6647[_0x61ca84]['questionId'])){_0x543e08[_0x923da6[_0x1d6647[_0x61ca84]['questionId']]]=_0x1d6647[_0x61ca84]['answer'];}}for(var _0x29d978 in _0x923da6){if(!_0x543e08[_0x323a('0x39')](_0x923da6[_0x29d978])){_0x543e08[_0x923da6[_0x29d978]]=null;}}_0x392b19[_0x323a('0x6e')](_0x543e08);}return _0x392b19;}})[_0x323a('0x23')](function(_0x42332d){if(!_['isEmpty'](_0x42332d)){var _0x1d878d=toCsv(_0x42332d);var _0x3b80bd=Date[_0x323a('0x6f')]();fs[_0x323a('0x70')](util[_0x323a('0x6b')](_0x323a('0x71'),_0xbecdc2[_0x323a('0x48')]['id'],_0x3b80bd),_0x1d878d);_0x3b1e42[_0x323a('0x72')]('Content-disposition',_0x323a('0x73')+util['format'](_0x323a('0x74'),_0xbecdc2[_0x323a('0x48')]['id'],_0x3b80bd));_0x3b1e42[_0x323a('0x72')](_0x323a('0x75'),_0x323a('0x76'));return _0x3b1e42[_0x323a('0x77')](util[_0x323a('0x6b')](_0x323a('0x71'),_0xbecdc2['params']['id'],_0x3b80bd));}else{return _0x3b1e42[_0x323a('0x28')](0xcc);}})['catch'](handleError(_0x3b1e42,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff