// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x86c0=['intersection','attributes','fields','query','length','hasOwnProperty','order','sort','where','pick','filter','merge','type','options','includeAll','include','findAll','catch','show','params','keys','rawAttributes','create','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','find','createdAt','updatedAt','omit','update','getSessions','findOne','JscriptySessionReport','nolimit','ProjectId','rows','getAnswers','JscriptyAnswerReport','number','apply','toString','indexOf','replace','startTime','JscriptyQuestionReport','-createdAt','questionId','question','starttime','format','YYYY-MM-DD\x20HH:mm:ss','SessionId','answer','isEmpty','now','writeFileSync','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','Content-type','text/csv','download','eml-format','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','sox','ejs','fs-extra','lodash','squel','crypto','jsforce','to-csv','querystring','papaparse','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','status','json','offset','limit','undefined','count','save','then','Projects','error','name','send','index','JscriptyProject','fieldName','key','model','map','filters'];(function(_0x5284fd,_0xf65de5){var _0x2facf5=function(_0x2394d0){while(--_0x2394d0){_0x5284fd['push'](_0x5284fd['shift']());}};_0x2facf5(++_0xf65de5);}(_0x86c0,0x133));var _0x086c=function(_0x180bb7,_0xb2334b){_0x180bb7=_0x180bb7-0x0;var _0x55888d=_0x86c0[_0x180bb7];return _0x55888d;};'use strict';var emlformat=require(_0x086c('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x086c('0x1'));var jsonpatch=require(_0x086c('0x2'));var rp=require(_0x086c('0x3'));var moment=require(_0x086c('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x086c('0x5'));var util=require(_0x086c('0x6'));var path=require(_0x086c('0x7'));var sox=require(_0x086c('0x8'));var csv=require('to-csv');var ejs=require(_0x086c('0x9'));var fs=require('fs');var fs_extra=require(_0x086c('0xa'));var _=require(_0x086c('0xb'));var squel=require(_0x086c('0xc'));var crypto=require(_0x086c('0xd'));var jsforce=require(_0x086c('0xe'));var deskjs=require('desk.js');var toCsv=require(_0x086c('0xf'));var querystring=require(_0x086c('0x10'));var Papa=require(_0x086c('0x11'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0x086c('0x12'));var as=require(_0x086c('0x13'));var hardwareService=require(_0x086c('0x14'));var logger=require(_0x086c('0x15'))(_0x086c('0x16'));var utils=require('../../config/utils');var config=require(_0x086c('0x17'));var licenseUtil=require(_0x086c('0x18'));var db=require(_0x086c('0x19'))['db'];function respondWithStatusCode(_0x3d7cde,_0x4b9681){_0x4b9681=_0x4b9681||0xcc;return function(_0x5144bb){if(_0x5144bb){return _0x3d7cde[_0x086c('0x1a')](_0x4b9681);}return _0x3d7cde['status'](_0x4b9681)[_0x086c('0x1b')]();};}function respondWithResult(_0x282e0a,_0x5db47b){_0x5db47b=_0x5db47b||0xc8;return function(_0x40666e){if(_0x40666e){return _0x282e0a[_0x086c('0x1c')](_0x5db47b)[_0x086c('0x1d')](_0x40666e);}};}function respondWithFilteredResult(_0x2db80a,_0x587053){return function(_0x2e37fb){if(_0x2e37fb){var _0x174791=typeof _0x587053[_0x086c('0x1e')]==='undefined'&&typeof _0x587053[_0x086c('0x1f')]===_0x086c('0x20');var _0x460e03=_0x2e37fb[_0x086c('0x21')];var _0x2add43=_0x174791?0x0:_0x587053['offset'];var _0x5463d6=_0x174791?_0x2e37fb[_0x086c('0x21')]:_0x587053[_0x086c('0x1e')]+_0x587053[_0x086c('0x1f')];var _0x36becb;if(_0x5463d6>=_0x460e03){_0x5463d6=_0x460e03;_0x36becb=0xc8;}else{_0x36becb=0xce;}_0x2db80a[_0x086c('0x1c')](_0x36becb);return _0x2db80a['set']('Content-Range',_0x2add43+'-'+_0x5463d6+'/'+_0x460e03)['json'](_0x2e37fb);}return null;};}function patchUpdates(_0x3ae033){return function(_0x15582b){try{jsonpatch['apply'](_0x15582b,_0x3ae033,!![]);}catch(_0x2e8fbd){return BPromise['reject'](_0x2e8fbd);}return _0x15582b[_0x086c('0x22')]();};}function saveUpdates(_0x216817,_0x2095d1){return function(_0x2dad53){if(_0x2dad53){return _0x2dad53['update'](_0x216817)[_0x086c('0x23')](function(_0x56a794){return _0x56a794;});}return null;};}function removeEntity(_0x48490b,_0x5469d4){return function(_0x31aaab){if(_0x31aaab){return _0x31aaab['destroy']()['then'](function(){var _0x32b15b=_0x31aaab['get']({'plain':!![]});var _0x7884d1=_0x086c('0x24');return db['UserProfileResource']['destroy']({'where':{'type':_0x7884d1,'resourceId':_0x32b15b['id']}})[_0x086c('0x23')](function(){return _0x31aaab;});})[_0x086c('0x23')](function(){_0x48490b[_0x086c('0x1c')](0xcc)[_0x086c('0x1b')]();});}};}function handleEntityNotFound(_0x5a0d00,_0x3c3798){return function(_0x24b233){if(!_0x24b233){_0x5a0d00['sendStatus'](0x194);}return _0x24b233;};}function handleError(_0x53a162,_0x5d28b0){_0x5d28b0=_0x5d28b0||0x1f4;return function(_0x3f44fe){logger[_0x086c('0x25')](_0x3f44fe['stack']);if(_0x3f44fe[_0x086c('0x26')]){delete _0x3f44fe['name'];}_0x53a162[_0x086c('0x1c')](_0x5d28b0)[_0x086c('0x27')](_0x3f44fe);};}exports[_0x086c('0x28')]=function(_0x55126b,_0x180691){var _0x1988d0={},_0x4b9e4c={},_0x5e3d48={'count':0x0,'rows':[]};var _0x338d4f=_['map'](db[_0x086c('0x29')]['rawAttributes'],function(_0x642526){return{'name':_0x642526[_0x086c('0x2a')],'type':_0x642526['type'][_0x086c('0x2b')]};});_0x4b9e4c[_0x086c('0x2c')]=_[_0x086c('0x2d')](_0x338d4f,'name');_0x4b9e4c['query']=_['keys'](_0x55126b['query']);_0x4b9e4c[_0x086c('0x2e')]=_[_0x086c('0x2f')](_0x4b9e4c['model'],_0x4b9e4c['query']);_0x1988d0[_0x086c('0x30')]=_[_0x086c('0x2f')](_0x4b9e4c[_0x086c('0x2c')],qs[_0x086c('0x31')](_0x55126b[_0x086c('0x32')][_0x086c('0x31')]));_0x1988d0['attributes']=_0x1988d0[_0x086c('0x30')][_0x086c('0x33')]?_0x1988d0['attributes']:_0x4b9e4c['model'];if(!_0x55126b['query'][_0x086c('0x34')]('nolimit')){_0x1988d0[_0x086c('0x1f')]=qs[_0x086c('0x1f')](_0x55126b['query'][_0x086c('0x1f')]);_0x1988d0['offset']=qs['offset'](_0x55126b['query'][_0x086c('0x1e')]);}_0x1988d0[_0x086c('0x35')]=qs[_0x086c('0x36')](_0x55126b[_0x086c('0x32')][_0x086c('0x36')]);_0x1988d0[_0x086c('0x37')]=qs[_0x086c('0x2e')](_[_0x086c('0x38')](_0x55126b['query'],_0x4b9e4c[_0x086c('0x2e')]),_0x338d4f);if(_0x55126b[_0x086c('0x32')][_0x086c('0x39')]){_0x1988d0[_0x086c('0x37')]=_[_0x086c('0x3a')](_0x1988d0[_0x086c('0x37')],{'$or':_[_0x086c('0x2d')](_0x338d4f,function(_0x148fab){if(_0x148fab[_0x086c('0x3b')]!=='VIRTUAL'){var _0x129492={};_0x129492[_0x148fab[_0x086c('0x26')]]={'$like':'%'+_0x55126b[_0x086c('0x32')][_0x086c('0x39')]+'%'};return _0x129492;}})});}_0x1988d0=_[_0x086c('0x3a')]({},_0x1988d0,_0x55126b[_0x086c('0x3c')]);var _0x5a324f={'where':_0x1988d0[_0x086c('0x37')]};return db[_0x086c('0x29')][_0x086c('0x21')](_0x5a324f)[_0x086c('0x23')](function(_0x45bef6){_0x5e3d48[_0x086c('0x21')]=_0x45bef6;if(_0x55126b[_0x086c('0x32')][_0x086c('0x3d')]){_0x1988d0[_0x086c('0x3e')]=[{'all':!![]}];}return db[_0x086c('0x29')][_0x086c('0x3f')](_0x1988d0);})[_0x086c('0x23')](function(_0x1c62ce){_0x5e3d48['rows']=_0x1c62ce;return _0x5e3d48;})[_0x086c('0x23')](respondWithFilteredResult(_0x180691,_0x1988d0))[_0x086c('0x40')](handleError(_0x180691,null));};exports[_0x086c('0x41')]=function(_0x5e5dc2,_0x4c5b06){var _0x2f1edb={'raw':![],'where':{'id':_0x5e5dc2[_0x086c('0x42')]['id']}},_0x486343={};_0x486343[_0x086c('0x2c')]=_[_0x086c('0x43')](db[_0x086c('0x29')][_0x086c('0x44')]);_0x486343[_0x086c('0x32')]=_[_0x086c('0x43')](_0x5e5dc2[_0x086c('0x32')]);_0x486343['filters']=_[_0x086c('0x2f')](_0x486343[_0x086c('0x2c')],_0x486343[_0x086c('0x32')]);_0x2f1edb['attributes']=_['intersection'](_0x486343[_0x086c('0x2c')],qs[_0x086c('0x31')](_0x5e5dc2[_0x086c('0x32')]['fields']));_0x2f1edb[_0x086c('0x30')]=_0x2f1edb[_0x086c('0x30')][_0x086c('0x33')]?_0x2f1edb[_0x086c('0x30')]:_0x486343['model'];if(_0x5e5dc2['query']['includeAll']){_0x2f1edb[_0x086c('0x3e')]=[{'all':!![]}];}_0x2f1edb=_[_0x086c('0x3a')]({},_0x2f1edb,_0x5e5dc2[_0x086c('0x3c')]);return db[_0x086c('0x29')]['find'](_0x2f1edb)[_0x086c('0x23')](handleEntityNotFound(_0x4c5b06,null))['then'](respondWithResult(_0x4c5b06,null))[_0x086c('0x40')](handleError(_0x4c5b06,null));};exports[_0x086c('0x45')]=function(_0x2b7cd7,_0xc63c2d){return db['JscriptyProject'][_0x086c('0x45')](_0x2b7cd7[_0x086c('0x46')],{})[_0x086c('0x23')](function(_0x11497f){var _0x464f07=_0x2b7cd7[_0x086c('0x47')][_0x086c('0x48')]({'plain':!![]});if(!_0x464f07)throw new Error(_0x086c('0x49'));if(_0x464f07[_0x086c('0x4a')]===_0x086c('0x47')){var _0x355a8a=_0x11497f[_0x086c('0x48')]({'plain':!![]});var _0x25e4ca='Projects';return db[_0x086c('0x4b')]['find']({'where':{'name':_0x25e4ca,'userProfileId':_0x464f07[_0x086c('0x4c')]},'raw':!![]})['then'](function(_0x2f2441){if(_0x2f2441&&_0x2f2441[_0x086c('0x4d')]===0x0){return db[_0x086c('0x4e')][_0x086c('0x45')]({'name':_0x355a8a[_0x086c('0x26')],'resourceId':_0x355a8a['id'],'type':_0x2f2441['name'],'sectionId':_0x2f2441['id']},{})['then'](function(){return _0x11497f;});}else{return _0x11497f;}})[_0x086c('0x40')](function(_0x2b2fe9){logger[_0x086c('0x25')](_0x086c('0x4f'),_0x2b2fe9);throw _0x2b2fe9;});}return _0x11497f;})['then'](respondWithResult(_0xc63c2d,0xc9))['catch'](handleError(_0xc63c2d,null));};exports['clone']=function(_0x1221ed,_0x29c1df){var _0x51fba7={'where':{'id':_0x1221ed[_0x086c('0x42')]['id']}},_0x2a8a6a={};_0x2a8a6a[_0x086c('0x2c')]=_[_0x086c('0x43')](db[_0x086c('0x29')][_0x086c('0x44')]);_0x51fba7[_0x086c('0x30')]=_[_0x086c('0x2f')](_0x2a8a6a['model'],qs[_0x086c('0x31')](_0x1221ed[_0x086c('0x32')]['fields']));_0x51fba7[_0x086c('0x30')]=_0x51fba7['attributes'][_0x086c('0x33')]?_0x51fba7['attributes']:_0x2a8a6a['model'];if(_0x1221ed[_0x086c('0x32')][_0x086c('0x3d')]){_0x51fba7[_0x086c('0x3e')]=[{'all':!![]}];}_0x51fba7=_[_0x086c('0x3a')]({},_0x51fba7,_0x1221ed[_0x086c('0x3c')]);return db['JscriptyProject'][_0x086c('0x50')](_0x51fba7)[_0x086c('0x23')](handleEntityNotFound(_0x29c1df,null))[_0x086c('0x23')](function(_0x37d577){if(_0x37d577){var _0x5a604c=_0x37d577[_0x086c('0x48')]({'plain':!![]});_0x5a604c=qs['omit'](_0x5a604c,['id',_0x086c('0x51'),_0x086c('0x52')]);_0x1221ed[_0x086c('0x46')]=_[_0x086c('0x53')](_0x1221ed[_0x086c('0x46')],['id',_0x086c('0x51'),_0x086c('0x52')]);return db['JscriptyProject'][_0x086c('0x45')](_[_0x086c('0x3a')](_0x5a604c,_0x1221ed[_0x086c('0x46')]),{'include':_0x1221ed['query']['includeAll']?[{'all':!![]}]:undefined})[_0x086c('0x23')](function(_0x1039e7){var _0xe9cc21=_0x1221ed[_0x086c('0x47')][_0x086c('0x48')]({'plain':!![]});if(!_0xe9cc21)throw new Error(_0x086c('0x49'));if(_0xe9cc21[_0x086c('0x4a')]===_0x086c('0x47')){var _0x2f7935=_0x1039e7['get']({'plain':!![]});var _0x1630a5=_0x086c('0x24');return db[_0x086c('0x4b')]['find']({'where':{'name':_0x1630a5,'userProfileId':_0xe9cc21[_0x086c('0x4c')]},'raw':!![]})[_0x086c('0x23')](function(_0x36e7c1){if(_0x36e7c1&&_0x36e7c1[_0x086c('0x4d')]===0x0){return db[_0x086c('0x4e')]['create']({'name':_0x2f7935[_0x086c('0x26')],'resourceId':_0x2f7935['id'],'type':_0x36e7c1[_0x086c('0x26')],'sectionId':_0x36e7c1['id']},{})['then'](function(){return _0x1039e7;});}else{return _0x1039e7;}})['catch'](function(_0x2a849f){logger[_0x086c('0x25')](_0x086c('0x4f'),_0x2a849f);throw _0x2a849f;});}return _0x1039e7;});}})[_0x086c('0x23')](respondWithResult(_0x29c1df,0xc9))[_0x086c('0x40')](handleError(_0x29c1df,null));};exports[_0x086c('0x54')]=function(_0x39f66d,_0x2d721f){if(_0x39f66d['body']['id']){delete _0x39f66d[_0x086c('0x46')]['id'];}return db[_0x086c('0x29')][_0x086c('0x50')]({'where':{'id':_0x39f66d[_0x086c('0x42')]['id']}})[_0x086c('0x23')](handleEntityNotFound(_0x2d721f,null))['then'](saveUpdates(_0x39f66d[_0x086c('0x46')],null))[_0x086c('0x23')](respondWithResult(_0x2d721f,null))[_0x086c('0x40')](handleError(_0x2d721f,null));};exports['destroy']=function(_0x46f623,_0x302a02){return db[_0x086c('0x29')][_0x086c('0x50')]({'where':{'id':_0x46f623[_0x086c('0x42')]['id']}})[_0x086c('0x23')](handleEntityNotFound(_0x302a02,null))[_0x086c('0x23')](removeEntity(_0x302a02,null))[_0x086c('0x40')](handleError(_0x302a02,null));};exports[_0x086c('0x55')]=function(_0x26986e,_0x1848c2,_0x4902b4){var _0x6945e9={'raw':!![],'where':{}};var _0xda9a8d={};var _0x267ac6={'count':0x0,'rows':[]};return db[_0x086c('0x29')][_0x086c('0x56')]({'where':{'id':_0x26986e['params']['id']}})[_0x086c('0x23')](handleEntityNotFound(_0x1848c2,null))['then'](function(_0x54d927){if(_0x54d927){_0xda9a8d[_0x086c('0x2c')]=_['keys'](db[_0x086c('0x57')][_0x086c('0x44')]);_0xda9a8d[_0x086c('0x32')]=_['keys'](_0x26986e['query']);_0xda9a8d[_0x086c('0x2e')]=_['intersection'](_0xda9a8d[_0x086c('0x2c')],_0xda9a8d[_0x086c('0x32')]);_0x6945e9[_0x086c('0x30')]=_[_0x086c('0x2f')](_0xda9a8d[_0x086c('0x2c')],qs[_0x086c('0x31')](_0x26986e[_0x086c('0x32')][_0x086c('0x31')]));_0x6945e9[_0x086c('0x30')]=_0x6945e9[_0x086c('0x30')][_0x086c('0x33')]?_0x6945e9[_0x086c('0x30')]:_0xda9a8d[_0x086c('0x2c')];if(!_0x26986e['query']['hasOwnProperty'](_0x086c('0x58'))){_0x6945e9[_0x086c('0x1f')]=qs['limit'](_0x26986e[_0x086c('0x32')][_0x086c('0x1f')]);_0x6945e9[_0x086c('0x1e')]=qs[_0x086c('0x1e')](_0x26986e[_0x086c('0x32')][_0x086c('0x1e')]);}_0x6945e9[_0x086c('0x35')]=qs['sort'](_0x26986e[_0x086c('0x32')]['sort']);_0x6945e9[_0x086c('0x37')]=qs['filters'](_[_0x086c('0x38')](_0x26986e[_0x086c('0x32')],_0xda9a8d[_0x086c('0x2e')]));_0x6945e9[_0x086c('0x37')][_0x086c('0x59')]=_0x54d927['id'];if(_0x26986e[_0x086c('0x32')][_0x086c('0x39')]){_0x6945e9[_0x086c('0x37')]=_['merge'](_0x6945e9[_0x086c('0x37')],{'$or':_['map'](_0x6945e9[_0x086c('0x30')],function(_0x4cb228){var _0x1a3463={};_0x1a3463[_0x4cb228]={'$like':'%'+_0x26986e[_0x086c('0x32')]['filter']+'%'};return _0x1a3463;})});}_0x6945e9=_[_0x086c('0x3a')]({},_0x6945e9,_0x26986e[_0x086c('0x3c')]);return db[_0x086c('0x57')][_0x086c('0x21')]({'where':_0x6945e9[_0x086c('0x37')]})[_0x086c('0x23')](function(_0xc3c4eb){_0x267ac6[_0x086c('0x21')]=_0xc3c4eb;if(_0x26986e[_0x086c('0x32')]['includeAll']){_0x6945e9['include']=[{'all':!![]}];}return db[_0x086c('0x57')][_0x086c('0x3f')](_0x6945e9);})[_0x086c('0x23')](function(_0x3980f6){_0x267ac6[_0x086c('0x5a')]=_0x3980f6;return _0x267ac6;});}})[_0x086c('0x23')](respondWithFilteredResult(_0x1848c2,_0x6945e9))['catch'](handleError(_0x1848c2,null));};exports[_0x086c('0x5b')]=function(_0x52dd84,_0x6a2a39,_0x89ceb8){var _0x3010dd={'raw':!![],'where':{}};var _0x492ada={};var _0x2ab39b={'count':0x0,'rows':[]};return db[_0x086c('0x29')][_0x086c('0x56')]({'where':{'id':_0x52dd84[_0x086c('0x42')]['id']}})[_0x086c('0x23')](handleEntityNotFound(_0x6a2a39,null))[_0x086c('0x23')](function(_0x3afd20){if(_0x3afd20){_0x492ada[_0x086c('0x2c')]=_[_0x086c('0x43')](db['JscriptyAnswerReport'][_0x086c('0x44')]);_0x492ada['query']=_[_0x086c('0x43')](_0x52dd84[_0x086c('0x32')]);_0x492ada[_0x086c('0x2e')]=_['intersection'](_0x492ada['model'],_0x492ada[_0x086c('0x32')]);_0x3010dd[_0x086c('0x30')]=_[_0x086c('0x2f')](_0x492ada[_0x086c('0x2c')],qs[_0x086c('0x31')](_0x52dd84[_0x086c('0x32')][_0x086c('0x31')]));_0x3010dd[_0x086c('0x30')]=_0x3010dd[_0x086c('0x30')][_0x086c('0x33')]?_0x3010dd[_0x086c('0x30')]:_0x492ada[_0x086c('0x2c')];if(!_0x52dd84[_0x086c('0x32')][_0x086c('0x34')](_0x086c('0x58'))){_0x3010dd['limit']=qs[_0x086c('0x1f')](_0x52dd84['query']['limit']);_0x3010dd[_0x086c('0x1e')]=qs[_0x086c('0x1e')](_0x52dd84[_0x086c('0x32')][_0x086c('0x1e')]);}_0x3010dd[_0x086c('0x35')]=qs[_0x086c('0x36')](_0x52dd84[_0x086c('0x32')][_0x086c('0x36')]);_0x3010dd[_0x086c('0x37')]=qs[_0x086c('0x2e')](_['pick'](_0x52dd84[_0x086c('0x32')],_0x492ada[_0x086c('0x2e')]));_0x3010dd[_0x086c('0x37')][_0x086c('0x59')]=_0x3afd20['id'];if(_0x52dd84[_0x086c('0x32')][_0x086c('0x39')]){_0x3010dd[_0x086c('0x37')]=_[_0x086c('0x3a')](_0x3010dd[_0x086c('0x37')],{'$or':_['map'](_0x3010dd[_0x086c('0x30')],function(_0x32d227){var _0x20a859={};_0x20a859[_0x32d227]={'$like':'%'+_0x52dd84[_0x086c('0x32')]['filter']+'%'};return _0x20a859;})});}_0x3010dd=_[_0x086c('0x3a')]({},_0x3010dd,_0x52dd84['options']);return db['JscriptyAnswerReport'][_0x086c('0x21')]({'where':_0x3010dd[_0x086c('0x37')]})[_0x086c('0x23')](function(_0x213165){_0x2ab39b['count']=_0x213165;if(_0x52dd84[_0x086c('0x32')]['includeAll']){_0x3010dd[_0x086c('0x3e')]=[{'all':!![]}];}return db[_0x086c('0x5c')]['findAll'](_0x3010dd);})[_0x086c('0x23')](function(_0x19a73f){_0x2ab39b[_0x086c('0x5a')]=_0x19a73f;return _0x2ab39b;});}})[_0x086c('0x23')](respondWithFilteredResult(_0x6a2a39,_0x3010dd))[_0x086c('0x40')](handleError(_0x6a2a39,null));};function char(_0x5a3f67){return _0x086c('0x5d')===typeof _0x5a3f67?String['fromCharCode'][_0x086c('0x5e')](null,arguments):_0x5a3f67;}function needsEncapsulation(_0x402c82){return!!_0x402c82&&(_0x402c82['toString']()['indexOf'](char(0xd))>=0x0||_0x402c82[_0x086c('0x5f')]()[_0x086c('0x60')](char(0xa))>=0x0||_0x402c82['toString']()['indexOf'](char(0x2c))>=0x0||_0x402c82[_0x086c('0x5f')]()[_0x086c('0x60')](char(0x22))>=0x0);}function encapsulate(_0x542d9e){var _0x4797d0=char(0x22),_0x23b183='\x5c'+char(0x22),_0x15adbc=_0x542d9e[_0x086c('0x5f')]()[_0x086c('0x61')](new RegExp(_0x4797d0,'g'),_0x23b183);return _0x4797d0+_0x15adbc+_0x4797d0;}exports['getSummary']=function(_0x37617b,_0x4e8208,_0xdd207a){var _0x1b8943,_0x1f2c1d;var _0x27addd={'where':{'ProjectId':_0x37617b['params']['id']}};if(_0x37617b['query'][_0x086c('0x62')]){_0x27addd[_0x086c('0x37')]['starttime']=JSON['parse'](_0x37617b[_0x086c('0x32')][_0x086c('0x62')]);}return db[_0x086c('0x57')][_0x086c('0x3f')](_0x27addd)[_0x086c('0x23')](handleEntityNotFound(_0x4e8208,null))[_0x086c('0x23')](function(_0x565ff9){if(_0x565ff9){_0x1b8943=_0x565ff9;return db[_0x086c('0x63')][_0x086c('0x3f')]({'where':{'SessionId':{'$in':_[_0x086c('0x2d')](_0x1b8943,'id')},'ProjectId':_0x37617b[_0x086c('0x42')]['id']},'order':_0x086c('0x64')});}})[_0x086c('0x23')](handleEntityNotFound(_0x4e8208,null))['then'](function(_0x439c3c){if(_0x439c3c){_0x1f2c1d=_0x439c3c;var _0x299499={};for(var _0x5e9270=0x0,_0x936570=_0x1f2c1d['length'];_0x5e9270<_0x936570;_0x5e9270++){if(!_0x299499[_0x086c('0x34')](_0x1f2c1d[_0x5e9270][_0x086c('0x65')])){_0x299499[_0x1f2c1d[_0x5e9270][_0x086c('0x65')]]=needsEncapsulation(_0x1f2c1d[_0x5e9270][_0x086c('0x66')])?encapsulate(_0x1f2c1d[_0x5e9270]['question']):_0x1f2c1d[_0x5e9270][_0x086c('0x66')];}}var _0x3545b9=[],_0x3c17f3={};for(var _0x100eeb=0x0,_0x8b58f1=_0x1b8943['length'];_0x100eeb<_0x8b58f1;_0x100eeb++){_0x3c17f3={'ProjectId':_0x37617b[_0x086c('0x42')]['id'],'SessionId':_0x1b8943[_0x100eeb]['id'],'StartTime':moment(_0x1b8943[_0x100eeb][_0x086c('0x67')])[_0x086c('0x68')](_0x086c('0x69'))};for(var _0x4ee7a1=0x0,_0x53f651=_0x1f2c1d['length'];_0x4ee7a1<_0x53f651;_0x4ee7a1++){if(_0x1f2c1d[_0x4ee7a1][_0x086c('0x6a')]==_0x1b8943[_0x100eeb]['id']&&_0x299499['hasOwnProperty'](_0x1f2c1d[_0x4ee7a1]['questionId'])){_0x3c17f3[_0x299499[_0x1f2c1d[_0x4ee7a1][_0x086c('0x65')]]]=_0x1f2c1d[_0x4ee7a1][_0x086c('0x6b')];}}for(var _0x2aedb1 in _0x299499){if(!_0x3c17f3[_0x086c('0x34')](_0x299499[_0x2aedb1])){_0x3c17f3[_0x299499[_0x2aedb1]]=null;}}_0x3545b9['push'](_0x3c17f3);}return _0x3545b9;}})[_0x086c('0x23')](function(_0x23b053){if(!_[_0x086c('0x6c')](_0x23b053)){var _0x2d8831=toCsv(_0x23b053);var _0x536844=Date[_0x086c('0x6d')]();fs[_0x086c('0x6e')](util['format'](_0x086c('0x6f'),_0x37617b['params']['id'],_0x536844),_0x2d8831);_0x4e8208[_0x086c('0x70')]('Content-disposition',_0x086c('0x71')+util[_0x086c('0x68')](_0x086c('0x72'),_0x37617b['params']['id'],_0x536844));_0x4e8208['setHeader'](_0x086c('0x73'),_0x086c('0x74'));return _0x4e8208[_0x086c('0x75')](util['format']('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x37617b[_0x086c('0x42')]['id'],_0x536844));}else{return _0x4e8208[_0x086c('0x1a')](0xcc);}})[_0x086c('0x40')](handleError(_0x4e8208,null));};
\ No newline at end of file
+var _0x349e=['offset','set','Content-Range','apply','save','update','then','destroy','get','Projects','UserProfileResource','error','stack','name','rawAttributes','type','key','model','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filter','merge','VIRTUAL','includeAll','JscriptyProject','findAll','rows','catch','show','params','keys','options','find','role','UserProfileSection','userProfileId','autoAssociation','create','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','updatedAt','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','user','getSessions','findOne','JscriptySessionReport','pick','map','include','getAnswers','JscriptyAnswerReport','number','fromCharCode','toString','indexOf','replace','getSummary','starttime','parse','startTime','-createdAt','questionId','question','SessionId','push','isEmpty','now','format','setHeader','Content-disposition','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','text/csv','/tmp/Jscripty_Project_%d_Summary_%s.csv','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','fs-extra','squel','crypto','desk.js','to-csv','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','undefined','limit','count'];(function(_0x5743a0,_0x1ba947){var _0x11e0cb=function(_0x405567){while(--_0x405567){_0x5743a0['push'](_0x5743a0['shift']());}};_0x11e0cb(++_0x1ba947);}(_0x349e,0xcb));var _0xe349=function(_0x1796a4,_0x94f68f){_0x1796a4=_0x1796a4-0x0;var _0x224214=_0x349e[_0x1796a4];return _0x224214;};'use strict';var emlformat=require(_0xe349('0x0'));var rimraf=require(_0xe349('0x1'));var zipdir=require(_0xe349('0x2'));var jsonpatch=require(_0xe349('0x3'));var rp=require(_0xe349('0x4'));var moment=require(_0xe349('0x5'));var BPromise=require(_0xe349('0x6'));var Mustache=require(_0xe349('0x7'));var util=require(_0xe349('0x8'));var path=require('path');var sox=require(_0xe349('0x9'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xe349('0xa'));var _=require('lodash');var squel=require(_0xe349('0xb'));var crypto=require(_0xe349('0xc'));var jsforce=require('jsforce');var deskjs=require(_0xe349('0xd'));var toCsv=require(_0xe349('0xe'));var querystring=require(_0xe349('0xf'));var Papa=require(_0xe349('0x10'));var Redis=require(_0xe349('0x11'));var authService=require('../../components/auth/service');var qs=require(_0xe349('0x12'));var as=require(_0xe349('0x13'));var hardwareService=require(_0xe349('0x14'));var logger=require(_0xe349('0x15'))(_0xe349('0x16'));var utils=require(_0xe349('0x17'));var config=require(_0xe349('0x18'));var licenseUtil=require(_0xe349('0x19'));var db=require(_0xe349('0x1a'))['db'];function respondWithStatusCode(_0x2ca887,_0x154cdf){_0x154cdf=_0x154cdf||0xcc;return function(_0x2fba52){if(_0x2fba52){return _0x2ca887[_0xe349('0x1b')](_0x154cdf);}return _0x2ca887[_0xe349('0x1c')](_0x154cdf)[_0xe349('0x1d')]();};}function respondWithResult(_0x15bf2e,_0x173dd7){_0x173dd7=_0x173dd7||0xc8;return function(_0x4f7787){if(_0x4f7787){return _0x15bf2e[_0xe349('0x1c')](_0x173dd7)['json'](_0x4f7787);}};}function respondWithFilteredResult(_0x344baf,_0x45a65f){return function(_0x33a492){if(_0x33a492){var _0x4b3c5a=typeof _0x45a65f['offset']===_0xe349('0x1e')&&typeof _0x45a65f[_0xe349('0x1f')]===_0xe349('0x1e');var _0x3a4e99=_0x33a492[_0xe349('0x20')];var _0x6f9c8=_0x4b3c5a?0x0:_0x45a65f[_0xe349('0x21')];var _0x27b519=_0x4b3c5a?_0x33a492[_0xe349('0x20')]:_0x45a65f[_0xe349('0x21')]+_0x45a65f[_0xe349('0x1f')];var _0x5ea6d7;if(_0x27b519>=_0x3a4e99){_0x27b519=_0x3a4e99;_0x5ea6d7=0xc8;}else{_0x5ea6d7=0xce;}_0x344baf['status'](_0x5ea6d7);return _0x344baf[_0xe349('0x22')](_0xe349('0x23'),_0x6f9c8+'-'+_0x27b519+'/'+_0x3a4e99)['json'](_0x33a492);}return null;};}function patchUpdates(_0xf3fa5a){return function(_0x22892e){try{jsonpatch[_0xe349('0x24')](_0x22892e,_0xf3fa5a,!![]);}catch(_0x55ad4e){return BPromise['reject'](_0x55ad4e);}return _0x22892e[_0xe349('0x25')]();};}function saveUpdates(_0x429d50,_0x1ec369){return function(_0x3e880c){if(_0x3e880c){return _0x3e880c[_0xe349('0x26')](_0x429d50)[_0xe349('0x27')](function(_0x4cfb6a){return _0x4cfb6a;});}return null;};}function removeEntity(_0x2fc880,_0x8f0454){return function(_0x299932){if(_0x299932){return _0x299932[_0xe349('0x28')]()[_0xe349('0x27')](function(){var _0x5178ca=_0x299932[_0xe349('0x29')]({'plain':!![]});var _0x569c44=_0xe349('0x2a');return db[_0xe349('0x2b')]['destroy']({'where':{'type':_0x569c44,'resourceId':_0x5178ca['id']}})[_0xe349('0x27')](function(){return _0x299932;});})['then'](function(){_0x2fc880[_0xe349('0x1c')](0xcc)[_0xe349('0x1d')]();});}};}function handleEntityNotFound(_0x40d4c1,_0x4ad8e){return function(_0x42cccd){if(!_0x42cccd){_0x40d4c1[_0xe349('0x1b')](0x194);}return _0x42cccd;};}function handleError(_0x4a80f8,_0x221e47){_0x221e47=_0x221e47||0x1f4;return function(_0x2ad65c){logger[_0xe349('0x2c')](_0x2ad65c[_0xe349('0x2d')]);if(_0x2ad65c[_0xe349('0x2e')]){delete _0x2ad65c[_0xe349('0x2e')];}_0x4a80f8[_0xe349('0x1c')](_0x221e47)['send'](_0x2ad65c);};}exports['index']=function(_0x315e60,_0x35f53c){var _0x3ddf5f={},_0x27acff={},_0x2ae7c3={'count':0x0,'rows':[]};var _0x3ad43f=_['map'](db['JscriptyProject'][_0xe349('0x2f')],function(_0x2a4068){return{'name':_0x2a4068['fieldName'],'type':_0x2a4068[_0xe349('0x30')][_0xe349('0x31')]};});_0x27acff[_0xe349('0x32')]=_['map'](_0x3ad43f,_0xe349('0x2e'));_0x27acff[_0xe349('0x33')]=_['keys'](_0x315e60[_0xe349('0x33')]);_0x27acff[_0xe349('0x34')]=_[_0xe349('0x35')](_0x27acff[_0xe349('0x32')],_0x27acff[_0xe349('0x33')]);_0x3ddf5f[_0xe349('0x36')]=_[_0xe349('0x35')](_0x27acff[_0xe349('0x32')],qs[_0xe349('0x37')](_0x315e60[_0xe349('0x33')][_0xe349('0x37')]));_0x3ddf5f[_0xe349('0x36')]=_0x3ddf5f['attributes'][_0xe349('0x38')]?_0x3ddf5f['attributes']:_0x27acff[_0xe349('0x32')];if(!_0x315e60[_0xe349('0x33')][_0xe349('0x39')](_0xe349('0x3a'))){_0x3ddf5f[_0xe349('0x1f')]=qs['limit'](_0x315e60[_0xe349('0x33')]['limit']);_0x3ddf5f[_0xe349('0x21')]=qs[_0xe349('0x21')](_0x315e60[_0xe349('0x33')][_0xe349('0x21')]);}_0x3ddf5f[_0xe349('0x3b')]=qs[_0xe349('0x3c')](_0x315e60[_0xe349('0x33')]['sort']);_0x3ddf5f[_0xe349('0x3d')]=qs[_0xe349('0x34')](_['pick'](_0x315e60['query'],_0x27acff[_0xe349('0x34')]),_0x3ad43f);if(_0x315e60['query'][_0xe349('0x3e')]){_0x3ddf5f[_0xe349('0x3d')]=_[_0xe349('0x3f')](_0x3ddf5f[_0xe349('0x3d')],{'$or':_['map'](_0x3ad43f,function(_0x1c3bf4){if(_0x1c3bf4['type']!==_0xe349('0x40')){var _0x4d0e54={};_0x4d0e54[_0x1c3bf4['name']]={'$like':'%'+_0x315e60['query']['filter']+'%'};return _0x4d0e54;}})});}_0x3ddf5f=_[_0xe349('0x3f')]({},_0x3ddf5f,_0x315e60['options']);var _0x4cd64d={'where':_0x3ddf5f[_0xe349('0x3d')]};return db['JscriptyProject']['count'](_0x4cd64d)[_0xe349('0x27')](function(_0x1c7770){_0x2ae7c3[_0xe349('0x20')]=_0x1c7770;if(_0x315e60['query'][_0xe349('0x41')]){_0x3ddf5f['include']=[{'all':!![]}];}return db[_0xe349('0x42')][_0xe349('0x43')](_0x3ddf5f);})['then'](function(_0x362148){_0x2ae7c3[_0xe349('0x44')]=_0x362148;return _0x2ae7c3;})['then'](respondWithFilteredResult(_0x35f53c,_0x3ddf5f))[_0xe349('0x45')](handleError(_0x35f53c,null));};exports[_0xe349('0x46')]=function(_0x548ee4,_0x467348){var _0x5615ce={'raw':![],'where':{'id':_0x548ee4[_0xe349('0x47')]['id']}},_0x2b56f5={};_0x2b56f5['model']=_[_0xe349('0x48')](db[_0xe349('0x42')][_0xe349('0x2f')]);_0x2b56f5[_0xe349('0x33')]=_[_0xe349('0x48')](_0x548ee4[_0xe349('0x33')]);_0x2b56f5[_0xe349('0x34')]=_['intersection'](_0x2b56f5[_0xe349('0x32')],_0x2b56f5[_0xe349('0x33')]);_0x5615ce['attributes']=_['intersection'](_0x2b56f5[_0xe349('0x32')],qs['fields'](_0x548ee4[_0xe349('0x33')][_0xe349('0x37')]));_0x5615ce['attributes']=_0x5615ce[_0xe349('0x36')][_0xe349('0x38')]?_0x5615ce[_0xe349('0x36')]:_0x2b56f5[_0xe349('0x32')];if(_0x548ee4[_0xe349('0x33')][_0xe349('0x41')]){_0x5615ce['include']=[{'all':!![]}];}_0x5615ce=_['merge']({},_0x5615ce,_0x548ee4[_0xe349('0x49')]);return db['JscriptyProject'][_0xe349('0x4a')](_0x5615ce)[_0xe349('0x27')](handleEntityNotFound(_0x467348,null))[_0xe349('0x27')](respondWithResult(_0x467348,null))[_0xe349('0x45')](handleError(_0x467348,null));};exports['create']=function(_0x4c9630,_0x2ea9a3){return db[_0xe349('0x42')]['create'](_0x4c9630['body'],{})[_0xe349('0x27')](function(_0x508d65){var _0xada2b1=_0x4c9630['user']['get']({'plain':!![]});if(!_0xada2b1)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0xada2b1[_0xe349('0x4b')]==='user'){var _0x3b4210=_0x508d65['get']({'plain':!![]});var _0x2f206f='Projects';return db[_0xe349('0x4c')]['find']({'where':{'name':_0x2f206f,'userProfileId':_0xada2b1[_0xe349('0x4d')]},'raw':!![]})[_0xe349('0x27')](function(_0x37df30){if(_0x37df30&&_0x37df30[_0xe349('0x4e')]===0x0){return db[_0xe349('0x2b')][_0xe349('0x4f')]({'name':_0x3b4210[_0xe349('0x2e')],'resourceId':_0x3b4210['id'],'type':_0x37df30['name'],'sectionId':_0x37df30['id']},{})[_0xe349('0x27')](function(){return _0x508d65;});}else{return _0x508d65;}})[_0xe349('0x45')](function(_0x128e29){logger[_0xe349('0x2c')](_0xe349('0x50'),_0x128e29);throw _0x128e29;});}return _0x508d65;})[_0xe349('0x27')](respondWithResult(_0x2ea9a3,0xc9))['catch'](handleError(_0x2ea9a3,null));};exports[_0xe349('0x51')]=function(_0x3ee362,_0x14234f){var _0x67b504={'where':{'id':_0x3ee362[_0xe349('0x47')]['id']}},_0x13f2ca={};_0x13f2ca['model']=_['keys'](db[_0xe349('0x42')][_0xe349('0x2f')]);_0x67b504[_0xe349('0x36')]=_[_0xe349('0x35')](_0x13f2ca['model'],qs[_0xe349('0x37')](_0x3ee362[_0xe349('0x33')]['fields']));_0x67b504[_0xe349('0x36')]=_0x67b504[_0xe349('0x36')][_0xe349('0x38')]?_0x67b504[_0xe349('0x36')]:_0x13f2ca[_0xe349('0x32')];if(_0x3ee362['query'][_0xe349('0x41')]){_0x67b504['include']=[{'all':!![]}];}_0x67b504=_[_0xe349('0x3f')]({},_0x67b504,_0x3ee362[_0xe349('0x49')]);return db['JscriptyProject'][_0xe349('0x4a')](_0x67b504)[_0xe349('0x27')](handleEntityNotFound(_0x14234f,null))['then'](function(_0x3a78bb){if(_0x3a78bb){var _0x451435=_0x3a78bb['get']({'plain':!![]});_0x451435=qs[_0xe349('0x52')](_0x451435,['id','createdAt',_0xe349('0x53')]);_0x3ee362[_0xe349('0x54')]=_[_0xe349('0x52')](_0x3ee362['body'],['id','createdAt',_0xe349('0x53')]);return db[_0xe349('0x42')][_0xe349('0x4f')](_[_0xe349('0x3f')](_0x451435,_0x3ee362[_0xe349('0x54')]),{'include':_0x3ee362[_0xe349('0x33')][_0xe349('0x41')]?[{'all':!![]}]:undefined})['then'](function(_0x1fe1a1){var _0x239c20=_0x3ee362['user'][_0xe349('0x29')]({'plain':!![]});if(!_0x239c20)throw new Error(_0xe349('0x55'));if(_0x239c20[_0xe349('0x4b')]===_0xe349('0x56')){var _0x162726=_0x1fe1a1['get']({'plain':!![]});var _0x5b8976=_0xe349('0x2a');return db[_0xe349('0x4c')][_0xe349('0x4a')]({'where':{'name':_0x5b8976,'userProfileId':_0x239c20[_0xe349('0x4d')]},'raw':!![]})[_0xe349('0x27')](function(_0x4b4295){if(_0x4b4295&&_0x4b4295[_0xe349('0x4e')]===0x0){return db[_0xe349('0x2b')][_0xe349('0x4f')]({'name':_0x162726[_0xe349('0x2e')],'resourceId':_0x162726['id'],'type':_0x4b4295[_0xe349('0x2e')],'sectionId':_0x4b4295['id']},{})['then'](function(){return _0x1fe1a1;});}else{return _0x1fe1a1;}})[_0xe349('0x45')](function(_0x508eda){logger[_0xe349('0x2c')](_0xe349('0x50'),_0x508eda);throw _0x508eda;});}return _0x1fe1a1;});}})[_0xe349('0x27')](respondWithResult(_0x14234f,0xc9))[_0xe349('0x45')](handleError(_0x14234f,null));};exports['update']=function(_0x92bef6,_0x15b104){if(_0x92bef6[_0xe349('0x54')]['id']){delete _0x92bef6['body']['id'];}return db['JscriptyProject'][_0xe349('0x4a')]({'where':{'id':_0x92bef6['params']['id']}})['then'](handleEntityNotFound(_0x15b104,null))['then'](saveUpdates(_0x92bef6['body'],null))[_0xe349('0x27')](respondWithResult(_0x15b104,null))['catch'](handleError(_0x15b104,null));};exports[_0xe349('0x28')]=function(_0x5f804e,_0x54b8c0){return db[_0xe349('0x42')][_0xe349('0x4a')]({'where':{'id':_0x5f804e[_0xe349('0x47')]['id']}})[_0xe349('0x27')](handleEntityNotFound(_0x54b8c0,null))[_0xe349('0x27')](removeEntity(_0x54b8c0,null))[_0xe349('0x45')](handleError(_0x54b8c0,null));};exports[_0xe349('0x57')]=function(_0x3804f9,_0x587a67,_0x170f1b){var _0x4df6eb={'raw':!![],'where':{}};var _0x971358={};var _0x25f3eb={'count':0x0,'rows':[]};return db[_0xe349('0x42')][_0xe349('0x58')]({'where':{'id':_0x3804f9[_0xe349('0x47')]['id']}})[_0xe349('0x27')](handleEntityNotFound(_0x587a67,null))['then'](function(_0xeb293e){if(_0xeb293e){_0x971358[_0xe349('0x32')]=_[_0xe349('0x48')](db[_0xe349('0x59')][_0xe349('0x2f')]);_0x971358['query']=_[_0xe349('0x48')](_0x3804f9[_0xe349('0x33')]);_0x971358[_0xe349('0x34')]=_[_0xe349('0x35')](_0x971358[_0xe349('0x32')],_0x971358[_0xe349('0x33')]);_0x4df6eb['attributes']=_[_0xe349('0x35')](_0x971358[_0xe349('0x32')],qs[_0xe349('0x37')](_0x3804f9[_0xe349('0x33')]['fields']));_0x4df6eb[_0xe349('0x36')]=_0x4df6eb['attributes'][_0xe349('0x38')]?_0x4df6eb[_0xe349('0x36')]:_0x971358[_0xe349('0x32')];if(!_0x3804f9[_0xe349('0x33')][_0xe349('0x39')](_0xe349('0x3a'))){_0x4df6eb[_0xe349('0x1f')]=qs[_0xe349('0x1f')](_0x3804f9[_0xe349('0x33')][_0xe349('0x1f')]);_0x4df6eb[_0xe349('0x21')]=qs[_0xe349('0x21')](_0x3804f9[_0xe349('0x33')][_0xe349('0x21')]);}_0x4df6eb[_0xe349('0x3b')]=qs['sort'](_0x3804f9[_0xe349('0x33')]['sort']);_0x4df6eb[_0xe349('0x3d')]=qs[_0xe349('0x34')](_[_0xe349('0x5a')](_0x3804f9[_0xe349('0x33')],_0x971358[_0xe349('0x34')]));_0x4df6eb[_0xe349('0x3d')]['ProjectId']=_0xeb293e['id'];if(_0x3804f9[_0xe349('0x33')][_0xe349('0x3e')]){_0x4df6eb[_0xe349('0x3d')]=_['merge'](_0x4df6eb[_0xe349('0x3d')],{'$or':_[_0xe349('0x5b')](_0x4df6eb[_0xe349('0x36')],function(_0x1619c3){var _0x5d3db6={};_0x5d3db6[_0x1619c3]={'$like':'%'+_0x3804f9['query']['filter']+'%'};return _0x5d3db6;})});}_0x4df6eb=_[_0xe349('0x3f')]({},_0x4df6eb,_0x3804f9[_0xe349('0x49')]);return db[_0xe349('0x59')][_0xe349('0x20')]({'where':_0x4df6eb['where']})['then'](function(_0x41ccd9){_0x25f3eb[_0xe349('0x20')]=_0x41ccd9;if(_0x3804f9['query'][_0xe349('0x41')]){_0x4df6eb[_0xe349('0x5c')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0xe349('0x43')](_0x4df6eb);})[_0xe349('0x27')](function(_0x3c7419){_0x25f3eb['rows']=_0x3c7419;return _0x25f3eb;});}})[_0xe349('0x27')](respondWithFilteredResult(_0x587a67,_0x4df6eb))[_0xe349('0x45')](handleError(_0x587a67,null));};exports[_0xe349('0x5d')]=function(_0xdc952f,_0x46e455,_0x303b64){var _0x451c67={'raw':!![],'where':{}};var _0x5744a0={};var _0x5d75f2={'count':0x0,'rows':[]};return db['JscriptyProject'][_0xe349('0x58')]({'where':{'id':_0xdc952f['params']['id']}})[_0xe349('0x27')](handleEntityNotFound(_0x46e455,null))[_0xe349('0x27')](function(_0x5364f5){if(_0x5364f5){_0x5744a0[_0xe349('0x32')]=_['keys'](db[_0xe349('0x5e')]['rawAttributes']);_0x5744a0[_0xe349('0x33')]=_[_0xe349('0x48')](_0xdc952f[_0xe349('0x33')]);_0x5744a0['filters']=_[_0xe349('0x35')](_0x5744a0['model'],_0x5744a0[_0xe349('0x33')]);_0x451c67[_0xe349('0x36')]=_[_0xe349('0x35')](_0x5744a0['model'],qs[_0xe349('0x37')](_0xdc952f['query']['fields']));_0x451c67[_0xe349('0x36')]=_0x451c67[_0xe349('0x36')][_0xe349('0x38')]?_0x451c67[_0xe349('0x36')]:_0x5744a0[_0xe349('0x32')];if(!_0xdc952f[_0xe349('0x33')][_0xe349('0x39')](_0xe349('0x3a'))){_0x451c67[_0xe349('0x1f')]=qs[_0xe349('0x1f')](_0xdc952f[_0xe349('0x33')][_0xe349('0x1f')]);_0x451c67['offset']=qs[_0xe349('0x21')](_0xdc952f['query']['offset']);}_0x451c67[_0xe349('0x3b')]=qs[_0xe349('0x3c')](_0xdc952f[_0xe349('0x33')][_0xe349('0x3c')]);_0x451c67[_0xe349('0x3d')]=qs['filters'](_[_0xe349('0x5a')](_0xdc952f[_0xe349('0x33')],_0x5744a0[_0xe349('0x34')]));_0x451c67[_0xe349('0x3d')]['ProjectId']=_0x5364f5['id'];if(_0xdc952f['query'][_0xe349('0x3e')]){_0x451c67[_0xe349('0x3d')]=_[_0xe349('0x3f')](_0x451c67[_0xe349('0x3d')],{'$or':_['map'](_0x451c67['attributes'],function(_0x5485b6){var _0x20b4d8={};_0x20b4d8[_0x5485b6]={'$like':'%'+_0xdc952f[_0xe349('0x33')][_0xe349('0x3e')]+'%'};return _0x20b4d8;})});}_0x451c67=_['merge']({},_0x451c67,_0xdc952f[_0xe349('0x49')]);return db[_0xe349('0x5e')][_0xe349('0x20')]({'where':_0x451c67[_0xe349('0x3d')]})[_0xe349('0x27')](function(_0x1cb1bc){_0x5d75f2['count']=_0x1cb1bc;if(_0xdc952f['query']['includeAll']){_0x451c67[_0xe349('0x5c')]=[{'all':!![]}];}return db[_0xe349('0x5e')]['findAll'](_0x451c67);})[_0xe349('0x27')](function(_0x415b7b){_0x5d75f2[_0xe349('0x44')]=_0x415b7b;return _0x5d75f2;});}})[_0xe349('0x27')](respondWithFilteredResult(_0x46e455,_0x451c67))[_0xe349('0x45')](handleError(_0x46e455,null));};function char(_0x51295a){return _0xe349('0x5f')===typeof _0x51295a?String[_0xe349('0x60')][_0xe349('0x24')](null,arguments):_0x51295a;}function needsEncapsulation(_0x5f8ae2){return!!_0x5f8ae2&&(_0x5f8ae2[_0xe349('0x61')]()['indexOf'](char(0xd))>=0x0||_0x5f8ae2[_0xe349('0x61')]()['indexOf'](char(0xa))>=0x0||_0x5f8ae2['toString']()[_0xe349('0x62')](char(0x2c))>=0x0||_0x5f8ae2[_0xe349('0x61')]()[_0xe349('0x62')](char(0x22))>=0x0);}function encapsulate(_0x580283){var _0xbca70=char(0x22),_0x15ae17='\x5c'+char(0x22),_0x5eae60=_0x580283[_0xe349('0x61')]()[_0xe349('0x63')](new RegExp(_0xbca70,'g'),_0x15ae17);return _0xbca70+_0x5eae60+_0xbca70;}exports[_0xe349('0x64')]=function(_0x205826,_0x5378fb,_0x26661e){var _0x41e1a8,_0x2c4e0b;var _0x552b8f={'where':{'ProjectId':_0x205826[_0xe349('0x47')]['id']}};if(_0x205826[_0xe349('0x33')]['startTime']){_0x552b8f[_0xe349('0x3d')][_0xe349('0x65')]=JSON[_0xe349('0x66')](_0x205826[_0xe349('0x33')][_0xe349('0x67')]);}return db[_0xe349('0x59')][_0xe349('0x43')](_0x552b8f)['then'](handleEntityNotFound(_0x5378fb,null))[_0xe349('0x27')](function(_0x36f8c0){if(_0x36f8c0){_0x41e1a8=_0x36f8c0;return db['JscriptyQuestionReport'][_0xe349('0x43')]({'where':{'SessionId':{'$in':_[_0xe349('0x5b')](_0x41e1a8,'id')},'ProjectId':_0x205826[_0xe349('0x47')]['id']},'order':_0xe349('0x68')});}})[_0xe349('0x27')](handleEntityNotFound(_0x5378fb,null))[_0xe349('0x27')](function(_0x4f3f54){if(_0x4f3f54){_0x2c4e0b=_0x4f3f54;var _0x47f0d1={};for(var _0x4f7f19=0x0,_0x57cf2f=_0x2c4e0b[_0xe349('0x38')];_0x4f7f19<_0x57cf2f;_0x4f7f19++){if(!_0x47f0d1[_0xe349('0x39')](_0x2c4e0b[_0x4f7f19]['questionId'])){_0x47f0d1[_0x2c4e0b[_0x4f7f19][_0xe349('0x69')]]=needsEncapsulation(_0x2c4e0b[_0x4f7f19][_0xe349('0x6a')])?encapsulate(_0x2c4e0b[_0x4f7f19]['question']):_0x2c4e0b[_0x4f7f19]['question'];}}var _0x51c3ee=[],_0x278e57={};for(var _0x55f9ac=0x0,_0x2c6d34=_0x41e1a8['length'];_0x55f9ac<_0x2c6d34;_0x55f9ac++){_0x278e57={'ProjectId':_0x205826[_0xe349('0x47')]['id'],'SessionId':_0x41e1a8[_0x55f9ac]['id'],'StartTime':moment(_0x41e1a8[_0x55f9ac]['starttime'])['format']('YYYY-MM-DD\x20HH:mm:ss')};for(var _0x49a42e=0x0,_0x40162e=_0x2c4e0b['length'];_0x49a42e<_0x40162e;_0x49a42e++){if(_0x2c4e0b[_0x49a42e][_0xe349('0x6b')]==_0x41e1a8[_0x55f9ac]['id']&&_0x47f0d1['hasOwnProperty'](_0x2c4e0b[_0x49a42e][_0xe349('0x69')])){_0x278e57[_0x47f0d1[_0x2c4e0b[_0x49a42e][_0xe349('0x69')]]]=_0x2c4e0b[_0x49a42e]['answer'];}}for(var _0x4df150 in _0x47f0d1){if(!_0x278e57[_0xe349('0x39')](_0x47f0d1[_0x4df150])){_0x278e57[_0x47f0d1[_0x4df150]]=null;}}_0x51c3ee[_0xe349('0x6c')](_0x278e57);}return _0x51c3ee;}})['then'](function(_0x2703cb){if(!_[_0xe349('0x6d')](_0x2703cb)){var _0x131f21=toCsv(_0x2703cb);var _0x2deafb=Date[_0xe349('0x6e')]();fs['writeFileSync'](util[_0xe349('0x6f')]('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x205826[_0xe349('0x47')]['id'],_0x2deafb),_0x131f21);_0x5378fb[_0xe349('0x70')](_0xe349('0x71'),_0xe349('0x72')+util[_0xe349('0x6f')](_0xe349('0x73'),_0x205826[_0xe349('0x47')]['id'],_0x2deafb));_0x5378fb[_0xe349('0x70')]('Content-type',_0xe349('0x74'));return _0x5378fb['download'](util['format'](_0xe349('0x75'),_0x205826[_0xe349('0x47')]['id'],_0x2deafb));}else{return _0x5378fb[_0xe349('0x1b')](0xcc);}})[_0xe349('0x45')](handleError(_0x5378fb,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff