// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x1fc5=['questionId','question','format','SessionId','answer','isEmpty','now','writeFileSync','setHeader','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','Content-type','text/csv','download','/tmp/Jscripty_Project_%d_Summary_%s.csv','html-pdf','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','crypto','querystring','papaparse','../../components/auth/service','../../config/license/hardware','ioredis','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','json','offset','Content-Range','save','update','then','destroy','get','UserProfileResource','error','stack','name','send','index','JscriptyProject','rawAttributes','model','keys','query','filters','fields','attributes','hasOwnProperty','nolimit','limit','order','sort','where','pick','filter','merge','map','type','count','includeAll','include','findAll','rows','catch','show','params','intersection','length','options','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','Projects','UserProfileSection','userProfileId','clone','createdAt','updatedAt','omit','role','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','getSessions','findOne','JscriptySessionReport','ProjectId','getAnswers','JscriptyAnswerReport','number','fromCharCode','apply','indexOf','toString','replace','getSummary','startTime','starttime','JscriptyQuestionReport'];(function(_0x16d10f,_0x2ba2d5){var _0x50c823=function(_0x44e43f){while(--_0x44e43f){_0x16d10f['push'](_0x16d10f['shift']());}};_0x50c823(++_0x2ba2d5);}(_0x1fc5,0x86));var _0x51fc=function(_0x2246c6,_0x37032d){_0x2246c6=_0x2246c6-0x0;var _0x5baf4a=_0x1fc5[_0x2246c6];return _0x5baf4a;};'use strict';var pdf=require(_0x51fc('0x0'));var emlformat=require(_0x51fc('0x1'));var rimraf=require(_0x51fc('0x2'));var zipdir=require(_0x51fc('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0x51fc('0x4'));var moment=require(_0x51fc('0x5'));var BPromise=require(_0x51fc('0x6'));var Mustache=require(_0x51fc('0x7'));var util=require(_0x51fc('0x8'));var path=require(_0x51fc('0x9'));var sox=require(_0x51fc('0xa'));var csv=require(_0x51fc('0xb'));var ejs=require(_0x51fc('0xc'));var fs=require('fs');var _=require(_0x51fc('0xd'));var squel=require('squel');var crypto=require(_0x51fc('0xe'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x51fc('0xb'));var querystring=require(_0x51fc('0xf'));var Papa=require(_0x51fc('0x10'));var authService=require(_0x51fc('0x11'));var hardwareService=require(_0x51fc('0x12'));var Redis=require(_0x51fc('0x13'));var qs=require(_0x51fc('0x14'));var logger=require(_0x51fc('0x15'))(_0x51fc('0x16'));var utils=require(_0x51fc('0x17'));var config=require(_0x51fc('0x18'));var db=require(_0x51fc('0x19'))['db'];function respondWithStatusCode(_0x3700e3,_0x15bac0){_0x15bac0=_0x15bac0||0xcc;return function(_0x411b87){if(_0x411b87){return _0x3700e3[_0x51fc('0x1a')](_0x15bac0);}return _0x3700e3[_0x51fc('0x1b')](_0x15bac0)[_0x51fc('0x1c')]();};}function respondWithResult(_0x2b2d70,_0x519959){_0x519959=_0x519959||0xc8;return function(_0x206336){if(_0x206336){return _0x2b2d70[_0x51fc('0x1b')](_0x519959)[_0x51fc('0x1d')](_0x206336);}};}function respondWithFilteredResult(_0x280ba1,_0x3066a1){return function(_0x5081e5){if(_0x5081e5){var _0x131cbd=_0x5081e5['count'],_0x53386d=_0x3066a1[_0x51fc('0x1e')],_0x1b5c92=_0x3066a1[_0x51fc('0x1e')]+_0x3066a1['limit'],_0x416efa;if(_0x1b5c92>=_0x131cbd){_0x1b5c92=_0x131cbd;_0x416efa=0xc8;}else{_0x416efa=0xce;}_0x280ba1[_0x51fc('0x1b')](_0x416efa);return _0x280ba1['set'](_0x51fc('0x1f'),_0x53386d+'-'+_0x1b5c92+'/'+_0x131cbd)[_0x51fc('0x1d')](_0x5081e5);}return null;};}function patchUpdates(_0x1cc38c){return function(_0x27b84b){try{jsonpatch['apply'](_0x27b84b,_0x1cc38c,!![]);}catch(_0x55c1a3){return BPromise['reject'](_0x55c1a3);}return _0x27b84b[_0x51fc('0x20')]();};}function saveUpdates(_0x50c094,_0x5d0725){return function(_0x498e32){if(_0x498e32){return _0x498e32[_0x51fc('0x21')](_0x50c094)[_0x51fc('0x22')](function(_0x3fdd12){return _0x3fdd12;});}return null;};}function removeEntity(_0x15f1ce,_0x1926db){return function(_0x3e81d3){if(_0x3e81d3){return _0x3e81d3[_0x51fc('0x23')]()[_0x51fc('0x22')](function(){var _0x5cdd6e=_0x3e81d3[_0x51fc('0x24')]({'plain':!![]});var _0x4ecaa2='Projects';return db[_0x51fc('0x25')][_0x51fc('0x23')]({'where':{'type':_0x4ecaa2,'resourceId':_0x5cdd6e['id']}})[_0x51fc('0x22')](function(){return _0x3e81d3;});})[_0x51fc('0x22')](function(){_0x15f1ce[_0x51fc('0x1b')](0xcc)[_0x51fc('0x1c')]();});}};}function handleEntityNotFound(_0x2221c6,_0x345a7f){return function(_0x35f491){if(!_0x35f491){_0x2221c6[_0x51fc('0x1a')](0x194);}return _0x35f491;};}function handleError(_0x589aa6,_0x4e9b00){_0x4e9b00=_0x4e9b00||0x1f4;return function(_0x239258){logger[_0x51fc('0x26')](_0x239258[_0x51fc('0x27')]);if(_0x239258[_0x51fc('0x28')]){delete _0x239258[_0x51fc('0x28')];}_0x589aa6[_0x51fc('0x1b')](_0x4e9b00)[_0x51fc('0x29')](_0x239258);};}exports[_0x51fc('0x2a')]=function(_0x1968a2,_0x22acb6){var _0x4e8a76={},_0x59d6c8={},_0x1d1a20={'count':0x0,'rows':[]};var _0x5ba457=db[_0x51fc('0x2b')][_0x51fc('0x2c')];_0x59d6c8[_0x51fc('0x2d')]=_[_0x51fc('0x2e')](_0x5ba457);_0x59d6c8['query']=_[_0x51fc('0x2e')](_0x1968a2[_0x51fc('0x2f')]);_0x59d6c8[_0x51fc('0x30')]=_['intersection'](_0x59d6c8['model'],_0x59d6c8[_0x51fc('0x2f')]);_0x4e8a76['attributes']=_['intersection'](_0x59d6c8[_0x51fc('0x2d')],qs[_0x51fc('0x31')](_0x1968a2['query'][_0x51fc('0x31')]));_0x4e8a76[_0x51fc('0x32')]=_0x4e8a76[_0x51fc('0x32')]['length']?_0x4e8a76['attributes']:_0x59d6c8[_0x51fc('0x2d')];if(!_0x1968a2[_0x51fc('0x2f')][_0x51fc('0x33')](_0x51fc('0x34'))){_0x4e8a76[_0x51fc('0x35')]=qs[_0x51fc('0x35')](_0x1968a2[_0x51fc('0x2f')]['limit']);_0x4e8a76[_0x51fc('0x1e')]=qs[_0x51fc('0x1e')](_0x1968a2[_0x51fc('0x2f')][_0x51fc('0x1e')]);}_0x4e8a76[_0x51fc('0x36')]=qs[_0x51fc('0x37')](_0x1968a2[_0x51fc('0x2f')][_0x51fc('0x37')]);_0x4e8a76[_0x51fc('0x38')]=qs[_0x51fc('0x30')](_[_0x51fc('0x39')](_0x1968a2[_0x51fc('0x2f')],_0x59d6c8['filters']));if(_0x1968a2[_0x51fc('0x2f')][_0x51fc('0x3a')]){_0x4e8a76[_0x51fc('0x38')]=_[_0x51fc('0x3b')](_0x4e8a76[_0x51fc('0x38')],{'$or':_[_0x51fc('0x3c')](_0x5ba457,function(_0xe97bd2){if(_0xe97bd2[_0x51fc('0x3d')]['key']!=='VIRTUAL'){var _0x1ddb35={};_0x1ddb35[_0xe97bd2['field']]={'$like':'%'+_0x1968a2[_0x51fc('0x2f')]['filter']+'%'};return _0x1ddb35;}})});}_0x4e8a76=_[_0x51fc('0x3b')]({},_0x4e8a76,_0x1968a2['options']);var _0x5e8e0e={'where':_0x4e8a76['where']};return db[_0x51fc('0x2b')][_0x51fc('0x3e')](_0x5e8e0e)['then'](function(_0x36339c){_0x1d1a20[_0x51fc('0x3e')]=_0x36339c;if(_0x1968a2[_0x51fc('0x2f')][_0x51fc('0x3f')]){_0x4e8a76[_0x51fc('0x40')]=[{'all':!![]}];}return db[_0x51fc('0x2b')][_0x51fc('0x41')](_0x4e8a76);})['then'](function(_0x269a0a){_0x1d1a20[_0x51fc('0x42')]=_0x269a0a;return _0x1d1a20;})[_0x51fc('0x22')](respondWithFilteredResult(_0x22acb6,_0x4e8a76))[_0x51fc('0x43')](handleError(_0x22acb6,null));};exports[_0x51fc('0x44')]=function(_0x4b148f,_0x21af6a){var _0x1b3e79={'raw':![],'where':{'id':_0x4b148f[_0x51fc('0x45')]['id']}},_0x37228a={};_0x37228a[_0x51fc('0x2d')]=_['keys'](db[_0x51fc('0x2b')][_0x51fc('0x2c')]);_0x37228a[_0x51fc('0x2f')]=_['keys'](_0x4b148f[_0x51fc('0x2f')]);_0x37228a[_0x51fc('0x30')]=_[_0x51fc('0x46')](_0x37228a[_0x51fc('0x2d')],_0x37228a['query']);_0x1b3e79[_0x51fc('0x32')]=_[_0x51fc('0x46')](_0x37228a[_0x51fc('0x2d')],qs[_0x51fc('0x31')](_0x4b148f[_0x51fc('0x2f')][_0x51fc('0x31')]));_0x1b3e79[_0x51fc('0x32')]=_0x1b3e79[_0x51fc('0x32')][_0x51fc('0x47')]?_0x1b3e79[_0x51fc('0x32')]:_0x37228a[_0x51fc('0x2d')];if(_0x4b148f[_0x51fc('0x2f')][_0x51fc('0x3f')]){_0x1b3e79['include']=[{'all':!![]}];}_0x1b3e79=_['merge']({},_0x1b3e79,_0x4b148f[_0x51fc('0x48')]);return db[_0x51fc('0x2b')][_0x51fc('0x49')](_0x1b3e79)[_0x51fc('0x22')](handleEntityNotFound(_0x21af6a,null))[_0x51fc('0x22')](respondWithResult(_0x21af6a,null))[_0x51fc('0x43')](handleError(_0x21af6a,null));};exports['create']=function(_0xec78b8,_0x3be577){return db[_0x51fc('0x2b')][_0x51fc('0x4a')](_0xec78b8[_0x51fc('0x4b')],{})[_0x51fc('0x22')](function(_0x2773b5){var _0x341d3c=_0xec78b8[_0x51fc('0x4c')][_0x51fc('0x24')]({'plain':!![]});if(!_0x341d3c)throw new Error(_0x51fc('0x4d'));if(_0x341d3c['role']===_0x51fc('0x4c')){var _0x2f6a4e=_0x2773b5[_0x51fc('0x24')]({'plain':!![]});var _0x3af435=_0x51fc('0x4e');return db[_0x51fc('0x4f')][_0x51fc('0x49')]({'where':{'name':_0x3af435,'userProfileId':_0x341d3c[_0x51fc('0x50')]},'raw':!![]})[_0x51fc('0x22')](function(_0x3b8d4d){if(_0x3b8d4d&&_0x3b8d4d['autoAssociation']===0x0){return db[_0x51fc('0x25')]['create']({'name':_0x2f6a4e[_0x51fc('0x28')],'resourceId':_0x2f6a4e['id'],'type':_0x3b8d4d['name'],'sectionId':_0x3b8d4d['id']},{})[_0x51fc('0x22')](function(){return _0x2773b5;});}else{return _0x2773b5;}})[_0x51fc('0x43')](function(_0x1d2548){logger[_0x51fc('0x26')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x1d2548);throw _0x1d2548;});}return _0x2773b5;})['then'](respondWithResult(_0x3be577,0xc9))[_0x51fc('0x43')](handleError(_0x3be577,null));};exports[_0x51fc('0x51')]=function(_0x30845e,_0x39493a){var _0x4869bc={'raw':![],'where':{'id':_0x30845e[_0x51fc('0x45')]['id']}},_0x5b2f3e={};_0x5b2f3e[_0x51fc('0x2d')]=_['keys'](db[_0x51fc('0x2b')][_0x51fc('0x2c')]);_0x4869bc[_0x51fc('0x32')]=_[_0x51fc('0x46')](_0x5b2f3e['model'],qs[_0x51fc('0x31')](_0x30845e[_0x51fc('0x2f')][_0x51fc('0x31')]));_0x4869bc[_0x51fc('0x32')]=_0x4869bc['attributes'][_0x51fc('0x47')]?_0x4869bc['attributes']:_0x5b2f3e[_0x51fc('0x2d')];if(_0x30845e[_0x51fc('0x2f')][_0x51fc('0x3f')]){_0x4869bc['include']=[{'all':!![]}];}_0x4869bc=_[_0x51fc('0x3b')]({},_0x4869bc,_0x30845e[_0x51fc('0x48')]);return db[_0x51fc('0x2b')][_0x51fc('0x49')](_0x4869bc)[_0x51fc('0x22')](handleEntityNotFound(_0x39493a,null))[_0x51fc('0x22')](function(_0x3ab106){if(_0x3ab106){var _0x34f7de=_0x3ab106['get']({'plain':!![]});_0x34f7de=qs['omit'](_0x34f7de,['id',_0x51fc('0x52'),_0x51fc('0x53')]);_0x30845e['body']=_[_0x51fc('0x54')](_0x30845e[_0x51fc('0x4b')],['id',_0x51fc('0x52'),'updatedAt']);return db[_0x51fc('0x2b')][_0x51fc('0x4a')](_['merge'](_0x34f7de,_0x30845e['body']),{'include':_0x30845e['query']['includeAll']?[{'all':!![]}]:undefined})[_0x51fc('0x22')](function(_0x2be6fb){var _0x294c2c=_0x30845e['user'][_0x51fc('0x24')]({'plain':!![]});if(!_0x294c2c)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x294c2c[_0x51fc('0x55')]===_0x51fc('0x4c')){var _0x178b85=_0x2be6fb[_0x51fc('0x24')]({'plain':!![]});var _0x2baa38='Projects';return db['UserProfileSection'][_0x51fc('0x49')]({'where':{'name':_0x2baa38,'userProfileId':_0x294c2c['userProfileId']},'raw':!![]})['then'](function(_0x5cc50a){if(_0x5cc50a&&_0x5cc50a[_0x51fc('0x56')]===0x0){return db['UserProfileResource'][_0x51fc('0x4a')]({'name':_0x178b85[_0x51fc('0x28')],'resourceId':_0x178b85['id'],'type':_0x5cc50a[_0x51fc('0x28')],'sectionId':_0x5cc50a['id']},{})[_0x51fc('0x22')](function(){return _0x2be6fb;});}else{return _0x2be6fb;}})[_0x51fc('0x43')](function(_0x5992e7){logger['error'](_0x51fc('0x57'),_0x5992e7);throw _0x5992e7;});}return _0x2be6fb;});}})[_0x51fc('0x22')](respondWithResult(_0x39493a,0xc9))[_0x51fc('0x43')](handleError(_0x39493a,null));};exports['update']=function(_0x7e862d,_0x215a72){if(_0x7e862d[_0x51fc('0x4b')]['id']){delete _0x7e862d[_0x51fc('0x4b')]['id'];}return db[_0x51fc('0x2b')][_0x51fc('0x49')]({'where':{'id':_0x7e862d['params']['id']}})[_0x51fc('0x22')](handleEntityNotFound(_0x215a72,null))[_0x51fc('0x22')](saveUpdates(_0x7e862d[_0x51fc('0x4b')],null))[_0x51fc('0x22')](respondWithResult(_0x215a72,null))[_0x51fc('0x43')](handleError(_0x215a72,null));};exports[_0x51fc('0x23')]=function(_0x545007,_0x5ba542){return db[_0x51fc('0x2b')][_0x51fc('0x49')]({'where':{'id':_0x545007[_0x51fc('0x45')]['id']}})['then'](handleEntityNotFound(_0x5ba542,null))[_0x51fc('0x22')](removeEntity(_0x5ba542,null))[_0x51fc('0x43')](handleError(_0x5ba542,null));};exports[_0x51fc('0x58')]=function(_0x31e63d,_0x3e9394,_0x2c8ef6){var _0xe4f003={'raw':!![],'where':{}};var _0x3e9dc4={};var _0x29520c={'count':0x0,'rows':[]};return db[_0x51fc('0x2b')][_0x51fc('0x59')]({'where':{'id':_0x31e63d[_0x51fc('0x45')]['id']}})[_0x51fc('0x22')](handleEntityNotFound(_0x3e9394,null))[_0x51fc('0x22')](function(_0x1944ab){if(_0x1944ab){_0x3e9dc4['model']=_['keys'](db[_0x51fc('0x5a')][_0x51fc('0x2c')]);_0x3e9dc4['query']=_[_0x51fc('0x2e')](_0x31e63d['query']);_0x3e9dc4[_0x51fc('0x30')]=_[_0x51fc('0x46')](_0x3e9dc4[_0x51fc('0x2d')],_0x3e9dc4[_0x51fc('0x2f')]);_0xe4f003['attributes']=_[_0x51fc('0x46')](_0x3e9dc4[_0x51fc('0x2d')],qs[_0x51fc('0x31')](_0x31e63d[_0x51fc('0x2f')][_0x51fc('0x31')]));_0xe4f003[_0x51fc('0x32')]=_0xe4f003[_0x51fc('0x32')]['length']?_0xe4f003['attributes']:_0x3e9dc4[_0x51fc('0x2d')];if(!_0x31e63d['query'][_0x51fc('0x33')](_0x51fc('0x34'))){_0xe4f003[_0x51fc('0x35')]=qs[_0x51fc('0x35')](_0x31e63d[_0x51fc('0x2f')][_0x51fc('0x35')]);_0xe4f003[_0x51fc('0x1e')]=qs[_0x51fc('0x1e')](_0x31e63d['query'][_0x51fc('0x1e')]);}_0xe4f003[_0x51fc('0x36')]=qs[_0x51fc('0x37')](_0x31e63d[_0x51fc('0x2f')][_0x51fc('0x37')]);_0xe4f003[_0x51fc('0x38')]=qs[_0x51fc('0x30')](_[_0x51fc('0x39')](_0x31e63d[_0x51fc('0x2f')],_0x3e9dc4[_0x51fc('0x30')]));_0xe4f003[_0x51fc('0x38')][_0x51fc('0x5b')]=_0x1944ab['id'];if(_0x31e63d[_0x51fc('0x2f')][_0x51fc('0x3a')]){_0xe4f003[_0x51fc('0x38')]=_[_0x51fc('0x3b')](_0xe4f003[_0x51fc('0x38')],{'$or':_[_0x51fc('0x3c')](_0xe4f003['attributes'],function(_0xee658){var _0x5558e5={};_0x5558e5[_0xee658]={'$like':'%'+_0x31e63d['query'][_0x51fc('0x3a')]+'%'};return _0x5558e5;})});}_0xe4f003=_[_0x51fc('0x3b')]({},_0xe4f003,_0x31e63d[_0x51fc('0x48')]);return db[_0x51fc('0x5a')][_0x51fc('0x3e')]({'where':_0xe4f003[_0x51fc('0x38')]})[_0x51fc('0x22')](function(_0x1c13a5){_0x29520c['count']=_0x1c13a5;if(_0x31e63d['query'][_0x51fc('0x3f')]){_0xe4f003[_0x51fc('0x40')]=[{'all':!![]}];}return db[_0x51fc('0x5a')]['findAll'](_0xe4f003);})[_0x51fc('0x22')](function(_0x31ad06){_0x29520c[_0x51fc('0x42')]=_0x31ad06;return _0x29520c;});}})[_0x51fc('0x22')](respondWithFilteredResult(_0x3e9394,_0xe4f003))[_0x51fc('0x43')](handleError(_0x3e9394,null));};exports[_0x51fc('0x5c')]=function(_0x177c32,_0x4bcb74,_0x2ec12d){var _0x4982bc={'raw':!![],'where':{}};var _0x5438b1={};var _0x1e611a={'count':0x0,'rows':[]};return db['JscriptyProject'][_0x51fc('0x59')]({'where':{'id':_0x177c32[_0x51fc('0x45')]['id']}})[_0x51fc('0x22')](handleEntityNotFound(_0x4bcb74,null))[_0x51fc('0x22')](function(_0x228bab){if(_0x228bab){_0x5438b1[_0x51fc('0x2d')]=_['keys'](db[_0x51fc('0x5d')][_0x51fc('0x2c')]);_0x5438b1['query']=_['keys'](_0x177c32[_0x51fc('0x2f')]);_0x5438b1[_0x51fc('0x30')]=_[_0x51fc('0x46')](_0x5438b1[_0x51fc('0x2d')],_0x5438b1[_0x51fc('0x2f')]);_0x4982bc[_0x51fc('0x32')]=_[_0x51fc('0x46')](_0x5438b1[_0x51fc('0x2d')],qs[_0x51fc('0x31')](_0x177c32[_0x51fc('0x2f')][_0x51fc('0x31')]));_0x4982bc[_0x51fc('0x32')]=_0x4982bc[_0x51fc('0x32')][_0x51fc('0x47')]?_0x4982bc[_0x51fc('0x32')]:_0x5438b1['model'];if(!_0x177c32[_0x51fc('0x2f')][_0x51fc('0x33')](_0x51fc('0x34'))){_0x4982bc[_0x51fc('0x35')]=qs[_0x51fc('0x35')](_0x177c32[_0x51fc('0x2f')][_0x51fc('0x35')]);_0x4982bc[_0x51fc('0x1e')]=qs[_0x51fc('0x1e')](_0x177c32[_0x51fc('0x2f')][_0x51fc('0x1e')]);}_0x4982bc['order']=qs[_0x51fc('0x37')](_0x177c32['query'][_0x51fc('0x37')]);_0x4982bc[_0x51fc('0x38')]=qs['filters'](_[_0x51fc('0x39')](_0x177c32[_0x51fc('0x2f')],_0x5438b1[_0x51fc('0x30')]));_0x4982bc['where']['ProjectId']=_0x228bab['id'];if(_0x177c32['query'][_0x51fc('0x3a')]){_0x4982bc['where']=_['merge'](_0x4982bc[_0x51fc('0x38')],{'$or':_[_0x51fc('0x3c')](_0x4982bc[_0x51fc('0x32')],function(_0x4dd775){var _0x46f60c={};_0x46f60c[_0x4dd775]={'$like':'%'+_0x177c32[_0x51fc('0x2f')][_0x51fc('0x3a')]+'%'};return _0x46f60c;})});}_0x4982bc=_[_0x51fc('0x3b')]({},_0x4982bc,_0x177c32[_0x51fc('0x48')]);return db[_0x51fc('0x5d')][_0x51fc('0x3e')]({'where':_0x4982bc['where']})[_0x51fc('0x22')](function(_0x72abeb){_0x1e611a[_0x51fc('0x3e')]=_0x72abeb;if(_0x177c32[_0x51fc('0x2f')][_0x51fc('0x3f')]){_0x4982bc['include']=[{'all':!![]}];}return db['JscriptyAnswerReport'][_0x51fc('0x41')](_0x4982bc);})[_0x51fc('0x22')](function(_0x23c625){_0x1e611a['rows']=_0x23c625;return _0x1e611a;});}})[_0x51fc('0x22')](respondWithFilteredResult(_0x4bcb74,_0x4982bc))[_0x51fc('0x43')](handleError(_0x4bcb74,null));};function char(_0x541800){return _0x51fc('0x5e')===typeof _0x541800?String[_0x51fc('0x5f')][_0x51fc('0x60')](null,arguments):_0x541800;}function needsEncapsulation(_0x1dc54b){return!!_0x1dc54b&&(_0x1dc54b['toString']()[_0x51fc('0x61')](char(0xd))>=0x0||_0x1dc54b['toString']()[_0x51fc('0x61')](char(0xa))>=0x0||_0x1dc54b[_0x51fc('0x62')]()[_0x51fc('0x61')](char(0x2c))>=0x0||_0x1dc54b[_0x51fc('0x62')]()['indexOf'](char(0x22))>=0x0);}function encapsulate(_0x422a53){var _0x1fd4f2=char(0x22),_0x18e708='\x5c'+char(0x22),_0x551970=_0x422a53['toString']()[_0x51fc('0x63')](new RegExp(_0x1fd4f2,'g'),_0x18e708);return _0x1fd4f2+_0x551970+_0x1fd4f2;}exports[_0x51fc('0x64')]=function(_0x4787ee,_0x470748,_0x2a4ae3){var _0x43739e,_0x469101;var _0x49e53b={'where':{'ProjectId':_0x4787ee[_0x51fc('0x45')]['id']}};if(_0x4787ee['query'][_0x51fc('0x65')]){_0x49e53b[_0x51fc('0x38')][_0x51fc('0x66')]=JSON['parse'](_0x4787ee[_0x51fc('0x2f')][_0x51fc('0x65')]);}return db[_0x51fc('0x5a')][_0x51fc('0x41')](_0x49e53b)['then'](handleEntityNotFound(_0x470748,null))[_0x51fc('0x22')](function(_0x50e9df){if(_0x50e9df){_0x43739e=_0x50e9df;return db[_0x51fc('0x67')][_0x51fc('0x41')]({'where':{'SessionId':{'$in':_[_0x51fc('0x3c')](_0x43739e,'id')},'ProjectId':_0x4787ee[_0x51fc('0x45')]['id']},'order':'-createdAt'});}})[_0x51fc('0x22')](handleEntityNotFound(_0x470748,null))[_0x51fc('0x22')](function(_0x287b93){if(_0x287b93){_0x469101=_0x287b93;var _0x1d2aae={};for(var _0x2a17b9=0x0,_0x4ab053=_0x469101[_0x51fc('0x47')];_0x2a17b9<_0x4ab053;_0x2a17b9++){if(!_0x1d2aae[_0x51fc('0x33')](_0x469101[_0x2a17b9][_0x51fc('0x68')])){_0x1d2aae[_0x469101[_0x2a17b9]['questionId']]=needsEncapsulation(_0x469101[_0x2a17b9][_0x51fc('0x69')])?encapsulate(_0x469101[_0x2a17b9][_0x51fc('0x69')]):_0x469101[_0x2a17b9][_0x51fc('0x69')];}}var _0xcfefba=[],_0x2800c1={};for(var _0x3bbb41=0x0,_0x1a0d66=_0x43739e['length'];_0x3bbb41<_0x1a0d66;_0x3bbb41++){_0x2800c1={'ProjectId':_0x4787ee[_0x51fc('0x45')]['id'],'SessionId':_0x43739e[_0x3bbb41]['id'],'StartTime':moment(_0x43739e[_0x3bbb41][_0x51fc('0x66')])[_0x51fc('0x6a')]('YYYY-MM-DD\x20HH:mm:ss')};for(var _0x122e77=0x0,_0x4f01f5=_0x469101[_0x51fc('0x47')];_0x122e77<_0x4f01f5;_0x122e77++){if(_0x469101[_0x122e77][_0x51fc('0x6b')]==_0x43739e[_0x3bbb41]['id']&&_0x1d2aae['hasOwnProperty'](_0x469101[_0x122e77][_0x51fc('0x68')])){_0x2800c1[_0x1d2aae[_0x469101[_0x122e77]['questionId']]]=_0x469101[_0x122e77][_0x51fc('0x6c')];}}for(var _0x3b6169 in _0x1d2aae){if(!_0x2800c1[_0x51fc('0x33')](_0x1d2aae[_0x3b6169])){_0x2800c1[_0x1d2aae[_0x3b6169]]=null;}}_0xcfefba['push'](_0x2800c1);}return _0xcfefba;}})[_0x51fc('0x22')](function(_0x41177d){if(!_[_0x51fc('0x6d')](_0x41177d)){var _0x55367b=toCsv(_0x41177d);var _0x5e2593=Date[_0x51fc('0x6e')]();fs[_0x51fc('0x6f')](util[_0x51fc('0x6a')]('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x4787ee['params']['id'],_0x5e2593),_0x55367b);_0x470748[_0x51fc('0x70')]('Content-disposition',_0x51fc('0x71')+util[_0x51fc('0x6a')](_0x51fc('0x72'),_0x4787ee[_0x51fc('0x45')]['id'],_0x5e2593));_0x470748[_0x51fc('0x70')](_0x51fc('0x73'),_0x51fc('0x74'));return _0x470748[_0x51fc('0x75')](util[_0x51fc('0x6a')](_0x51fc('0x76'),_0x4787ee[_0x51fc('0x45')]['id'],_0x5e2593));}else{return _0x470748['sendStatus'](0xcc);}})[_0x51fc('0x43')](handleError(_0x470748,null));};
\ No newline at end of file
+var _0xaae9=['questionId','question','format','YYYY-MM-DD\x20HH:mm:ss','answer','writeFileSync','/tmp/Jscripty_Project_%d_Summary_%s.csv','Content-disposition','attachment;\x20filename=','setHeader','text/csv','download','html-pdf','eml-format','rimraf','fast-json-patch','request-promise','moment','mustache','util','sox','to-csv','ejs','lodash','squel','crypto','querystring','papaparse','../../components/auth/service','ioredis','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../mysqldb','end','json','count','offset','status','set','reject','update','then','destroy','Projects','UserProfileResource','sendStatus','error','stack','name','send','index','JscriptyProject','rawAttributes','model','query','intersection','attributes','fields','limit','order','sort','where','filters','pick','filter','map','type','key','VIRTUAL','field','merge','options','includeAll','include','rows','catch','show','params','keys','find','create','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','omit','updatedAt','body','getSessions','JscriptySessionReport','length','hasOwnProperty','nolimit','ProjectId','findAll','findOne','JscriptyAnswerReport','apply','indexOf','toString','getSummary','starttime','parse','startTime','JscriptyQuestionReport','-createdAt'];(function(_0x4e7d25,_0x58285f){var _0x526fe6=function(_0x4f0aec){while(--_0x4f0aec){_0x4e7d25['push'](_0x4e7d25['shift']());}};_0x526fe6(++_0x58285f);}(_0xaae9,0x1cc));var _0x9aae=function(_0xe8ae1,_0x48da04){_0xe8ae1=_0xe8ae1-0x0;var _0x32a154=_0xaae9[_0xe8ae1];return _0x32a154;};'use strict';var pdf=require(_0x9aae('0x0'));var emlformat=require(_0x9aae('0x1'));var rimraf=require(_0x9aae('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0x9aae('0x3'));var rp=require(_0x9aae('0x4'));var moment=require(_0x9aae('0x5'));var BPromise=require('bluebird');var Mustache=require(_0x9aae('0x6'));var util=require(_0x9aae('0x7'));var path=require('path');var sox=require(_0x9aae('0x8'));var csv=require(_0x9aae('0x9'));var ejs=require(_0x9aae('0xa'));var fs=require('fs');var _=require(_0x9aae('0xb'));var squel=require(_0x9aae('0xc'));var crypto=require(_0x9aae('0xd'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x9aae('0x9'));var querystring=require(_0x9aae('0xe'));var Papa=require(_0x9aae('0xf'));var authService=require(_0x9aae('0x10'));var hardwareService=require('../../config/license/hardware');var Redis=require(_0x9aae('0x11'));var qs=require(_0x9aae('0x12'));var logger=require(_0x9aae('0x13'))(_0x9aae('0x14'));var utils=require(_0x9aae('0x15'));var config=require('../../config/environment');var db=require(_0x9aae('0x16'))['db'];function respondWithStatusCode(_0xeaf2fc,_0x3be497){_0x3be497=_0x3be497||0xcc;return function(_0x160ba6){if(_0x160ba6){return _0xeaf2fc['sendStatus'](_0x3be497);}return _0xeaf2fc['status'](_0x3be497)[_0x9aae('0x17')]();};}function respondWithResult(_0x55b63c,_0x427b92){_0x427b92=_0x427b92||0xc8;return function(_0x2e052a){if(_0x2e052a){return _0x55b63c['status'](_0x427b92)[_0x9aae('0x18')](_0x2e052a);}};}function respondWithFilteredResult(_0x361194,_0x94219b){return function(_0x1d0d02){if(_0x1d0d02){var _0x60174c=_0x1d0d02[_0x9aae('0x19')],_0x3c1475=_0x94219b[_0x9aae('0x1a')],_0x3e724d=_0x94219b[_0x9aae('0x1a')]+_0x94219b['limit'],_0x20a8bf;if(_0x3e724d>=_0x60174c){_0x3e724d=_0x60174c;_0x20a8bf=0xc8;}else{_0x20a8bf=0xce;}_0x361194[_0x9aae('0x1b')](_0x20a8bf);return _0x361194[_0x9aae('0x1c')]('Content-Range',_0x3c1475+'-'+_0x3e724d+'/'+_0x60174c)['json'](_0x1d0d02);}return null;};}function patchUpdates(_0x275820){return function(_0xc85c72){try{jsonpatch['apply'](_0xc85c72,_0x275820,!![]);}catch(_0x14db76){return BPromise[_0x9aae('0x1d')](_0x14db76);}return _0xc85c72['save']();};}function saveUpdates(_0x34f55,_0x4f20d0){return function(_0x150169){if(_0x150169){return _0x150169[_0x9aae('0x1e')](_0x34f55)[_0x9aae('0x1f')](function(_0x5620a4){return _0x5620a4;});}return null;};}function removeEntity(_0x17b90e,_0x4d5b5b){return function(_0x47975c){if(_0x47975c){return _0x47975c[_0x9aae('0x20')]()['then'](function(){var _0x2ca5e9=_0x47975c['get']({'plain':!![]});var _0x1d0a0f=_0x9aae('0x21');return db[_0x9aae('0x22')]['destroy']({'where':{'type':_0x1d0a0f,'resourceId':_0x2ca5e9['id']}})[_0x9aae('0x1f')](function(){return _0x47975c;});})[_0x9aae('0x1f')](function(){_0x17b90e[_0x9aae('0x1b')](0xcc)[_0x9aae('0x17')]();});}};}function handleEntityNotFound(_0x168023,_0x36a849){return function(_0x1479c6){if(!_0x1479c6){_0x168023[_0x9aae('0x23')](0x194);}return _0x1479c6;};}function handleError(_0x691cb5,_0x4ceba0){_0x4ceba0=_0x4ceba0||0x1f4;return function(_0x5bc01e){logger[_0x9aae('0x24')](_0x5bc01e[_0x9aae('0x25')]);if(_0x5bc01e['name']){delete _0x5bc01e[_0x9aae('0x26')];}_0x691cb5[_0x9aae('0x1b')](_0x4ceba0)[_0x9aae('0x27')](_0x5bc01e);};}exports[_0x9aae('0x28')]=function(_0x439453,_0x2a3588){var _0x10c290={},_0x50f3d7={},_0xcff25a={'count':0x0,'rows':[]};var _0x3b4d53=db[_0x9aae('0x29')][_0x9aae('0x2a')];_0x50f3d7[_0x9aae('0x2b')]=_['keys'](_0x3b4d53);_0x50f3d7[_0x9aae('0x2c')]=_['keys'](_0x439453[_0x9aae('0x2c')]);_0x50f3d7['filters']=_[_0x9aae('0x2d')](_0x50f3d7[_0x9aae('0x2b')],_0x50f3d7['query']);_0x10c290[_0x9aae('0x2e')]=_[_0x9aae('0x2d')](_0x50f3d7[_0x9aae('0x2b')],qs[_0x9aae('0x2f')](_0x439453['query']['fields']));_0x10c290[_0x9aae('0x2e')]=_0x10c290['attributes']['length']?_0x10c290[_0x9aae('0x2e')]:_0x50f3d7[_0x9aae('0x2b')];if(!_0x439453[_0x9aae('0x2c')]['hasOwnProperty']('nolimit')){_0x10c290[_0x9aae('0x30')]=qs['limit'](_0x439453[_0x9aae('0x2c')][_0x9aae('0x30')]);_0x10c290[_0x9aae('0x1a')]=qs['offset'](_0x439453[_0x9aae('0x2c')][_0x9aae('0x1a')]);}_0x10c290[_0x9aae('0x31')]=qs['sort'](_0x439453['query'][_0x9aae('0x32')]);_0x10c290[_0x9aae('0x33')]=qs[_0x9aae('0x34')](_[_0x9aae('0x35')](_0x439453['query'],_0x50f3d7[_0x9aae('0x34')]));if(_0x439453[_0x9aae('0x2c')][_0x9aae('0x36')]){_0x10c290[_0x9aae('0x33')]=_['merge'](_0x10c290[_0x9aae('0x33')],{'$or':_[_0x9aae('0x37')](_0x3b4d53,function(_0x2d643e){if(_0x2d643e[_0x9aae('0x38')][_0x9aae('0x39')]!==_0x9aae('0x3a')){var _0x4b1b46={};_0x4b1b46[_0x2d643e[_0x9aae('0x3b')]]={'$like':'%'+_0x439453['query'][_0x9aae('0x36')]+'%'};return _0x4b1b46;}})});}_0x10c290=_[_0x9aae('0x3c')]({},_0x10c290,_0x439453[_0x9aae('0x3d')]);var _0x1b241b={'where':_0x10c290[_0x9aae('0x33')]};return db[_0x9aae('0x29')][_0x9aae('0x19')](_0x1b241b)[_0x9aae('0x1f')](function(_0x56c498){_0xcff25a[_0x9aae('0x19')]=_0x56c498;if(_0x439453['query'][_0x9aae('0x3e')]){_0x10c290[_0x9aae('0x3f')]=[{'all':!![]}];}return db[_0x9aae('0x29')]['findAll'](_0x10c290);})['then'](function(_0x19b85d){_0xcff25a[_0x9aae('0x40')]=_0x19b85d;return _0xcff25a;})[_0x9aae('0x1f')](respondWithFilteredResult(_0x2a3588,_0x10c290))[_0x9aae('0x41')](handleError(_0x2a3588,null));};exports[_0x9aae('0x42')]=function(_0x516bf3,_0x4ef735){var _0x28311c={'raw':![],'where':{'id':_0x516bf3[_0x9aae('0x43')]['id']}},_0x48013b={};_0x48013b['model']=_[_0x9aae('0x44')](db[_0x9aae('0x29')][_0x9aae('0x2a')]);_0x48013b['query']=_[_0x9aae('0x44')](_0x516bf3[_0x9aae('0x2c')]);_0x48013b['filters']=_[_0x9aae('0x2d')](_0x48013b['model'],_0x48013b[_0x9aae('0x2c')]);_0x28311c[_0x9aae('0x2e')]=_[_0x9aae('0x2d')](_0x48013b[_0x9aae('0x2b')],qs[_0x9aae('0x2f')](_0x516bf3[_0x9aae('0x2c')]['fields']));_0x28311c[_0x9aae('0x2e')]=_0x28311c[_0x9aae('0x2e')]['length']?_0x28311c[_0x9aae('0x2e')]:_0x48013b[_0x9aae('0x2b')];if(_0x516bf3[_0x9aae('0x2c')][_0x9aae('0x3e')]){_0x28311c[_0x9aae('0x3f')]=[{'all':!![]}];}_0x28311c=_[_0x9aae('0x3c')]({},_0x28311c,_0x516bf3[_0x9aae('0x3d')]);return db['JscriptyProject'][_0x9aae('0x45')](_0x28311c)[_0x9aae('0x1f')](handleEntityNotFound(_0x4ef735,null))[_0x9aae('0x1f')](respondWithResult(_0x4ef735,null))['catch'](handleError(_0x4ef735,null));};exports['create']=function(_0x412b6e,_0x4ccc5e){return db[_0x9aae('0x29')][_0x9aae('0x46')](_0x412b6e['body'],{})[_0x9aae('0x1f')](function(_0x42ab23){var _0x22e96d=_0x412b6e[_0x9aae('0x47')][_0x9aae('0x48')]({'plain':!![]});if(!_0x22e96d)throw new Error(_0x9aae('0x49'));if(_0x22e96d[_0x9aae('0x4a')]==='user'){var _0x3e8a43=_0x42ab23['get']({'plain':!![]});var _0x1d7f3c=_0x9aae('0x21');return db[_0x9aae('0x4b')][_0x9aae('0x45')]({'where':{'name':_0x1d7f3c,'userProfileId':_0x22e96d[_0x9aae('0x4c')]},'raw':!![]})[_0x9aae('0x1f')](function(_0x3a5f6d){if(_0x3a5f6d&&_0x3a5f6d[_0x9aae('0x4d')]===0x0){return db[_0x9aae('0x22')]['create']({'name':_0x3e8a43['name'],'resourceId':_0x3e8a43['id'],'type':_0x3a5f6d['name'],'sectionId':_0x3a5f6d['id']},{})[_0x9aae('0x1f')](function(){return _0x42ab23;});}else{return _0x42ab23;}})['catch'](function(_0x332f0b){logger[_0x9aae('0x24')](_0x9aae('0x4e'),_0x332f0b);throw _0x332f0b;});}return _0x42ab23;})[_0x9aae('0x1f')](respondWithResult(_0x4ccc5e,0xc9))['catch'](handleError(_0x4ccc5e,null));};exports['clone']=function(_0x3c041c,_0xc4166f){var _0x4b0f47={'raw':![],'where':{'id':_0x3c041c[_0x9aae('0x43')]['id']}},_0x337a87={};_0x337a87[_0x9aae('0x2b')]=_[_0x9aae('0x44')](db[_0x9aae('0x29')][_0x9aae('0x2a')]);_0x4b0f47['attributes']=_['intersection'](_0x337a87['model'],qs[_0x9aae('0x2f')](_0x3c041c[_0x9aae('0x2c')][_0x9aae('0x2f')]));_0x4b0f47[_0x9aae('0x2e')]=_0x4b0f47[_0x9aae('0x2e')]['length']?_0x4b0f47[_0x9aae('0x2e')]:_0x337a87[_0x9aae('0x2b')];if(_0x3c041c[_0x9aae('0x2c')][_0x9aae('0x3e')]){_0x4b0f47[_0x9aae('0x3f')]=[{'all':!![]}];}_0x4b0f47=_[_0x9aae('0x3c')]({},_0x4b0f47,_0x3c041c['options']);return db[_0x9aae('0x29')][_0x9aae('0x45')](_0x4b0f47)[_0x9aae('0x1f')](handleEntityNotFound(_0xc4166f,null))[_0x9aae('0x1f')](function(_0xfe74f9){if(_0xfe74f9){var _0x4a2c07=_0xfe74f9[_0x9aae('0x48')]({'plain':!![]});_0x4a2c07=qs[_0x9aae('0x4f')](_0x4a2c07,['id','createdAt',_0x9aae('0x50')]);_0x3c041c[_0x9aae('0x51')]=_['omit'](_0x3c041c['body'],['id','createdAt',_0x9aae('0x50')]);return db[_0x9aae('0x29')][_0x9aae('0x46')](_['merge'](_0x4a2c07,_0x3c041c[_0x9aae('0x51')]),{'include':_0x3c041c[_0x9aae('0x2c')][_0x9aae('0x3e')]?[{'all':!![]}]:undefined})['then'](function(_0x58dab4){var _0x5e524e=_0x3c041c[_0x9aae('0x47')][_0x9aae('0x48')]({'plain':!![]});if(!_0x5e524e)throw new Error(_0x9aae('0x49'));if(_0x5e524e['role']===_0x9aae('0x47')){var _0x5db664=_0x58dab4[_0x9aae('0x48')]({'plain':!![]});var _0x4c3732=_0x9aae('0x21');return db[_0x9aae('0x4b')][_0x9aae('0x45')]({'where':{'name':_0x4c3732,'userProfileId':_0x5e524e['userProfileId']},'raw':!![]})[_0x9aae('0x1f')](function(_0x27d94f){if(_0x27d94f&&_0x27d94f[_0x9aae('0x4d')]===0x0){return db[_0x9aae('0x22')][_0x9aae('0x46')]({'name':_0x5db664[_0x9aae('0x26')],'resourceId':_0x5db664['id'],'type':_0x27d94f['name'],'sectionId':_0x27d94f['id']},{})[_0x9aae('0x1f')](function(){return _0x58dab4;});}else{return _0x58dab4;}})[_0x9aae('0x41')](function(_0x1b40cd){logger[_0x9aae('0x24')](_0x9aae('0x4e'),_0x1b40cd);throw _0x1b40cd;});}return _0x58dab4;});}})[_0x9aae('0x1f')](respondWithResult(_0xc4166f,0xc9))[_0x9aae('0x41')](handleError(_0xc4166f,null));};exports[_0x9aae('0x1e')]=function(_0x485a59,_0xbe574b){if(_0x485a59[_0x9aae('0x51')]['id']){delete _0x485a59[_0x9aae('0x51')]['id'];}return db['JscriptyProject']['find']({'where':{'id':_0x485a59[_0x9aae('0x43')]['id']}})[_0x9aae('0x1f')](handleEntityNotFound(_0xbe574b,null))['then'](saveUpdates(_0x485a59['body'],null))['then'](respondWithResult(_0xbe574b,null))[_0x9aae('0x41')](handleError(_0xbe574b,null));};exports[_0x9aae('0x20')]=function(_0x562861,_0x214841){return db[_0x9aae('0x29')][_0x9aae('0x45')]({'where':{'id':_0x562861[_0x9aae('0x43')]['id']}})[_0x9aae('0x1f')](handleEntityNotFound(_0x214841,null))[_0x9aae('0x1f')](removeEntity(_0x214841,null))[_0x9aae('0x41')](handleError(_0x214841,null));};exports[_0x9aae('0x52')]=function(_0x275e95,_0x478580,_0x5644d2){var _0x384dbd={'raw':!![],'where':{}};var _0x33d9e1={};var _0x3af8d9={'count':0x0,'rows':[]};return db[_0x9aae('0x29')]['findOne']({'where':{'id':_0x275e95[_0x9aae('0x43')]['id']}})[_0x9aae('0x1f')](handleEntityNotFound(_0x478580,null))[_0x9aae('0x1f')](function(_0x37418c){if(_0x37418c){_0x33d9e1[_0x9aae('0x2b')]=_[_0x9aae('0x44')](db[_0x9aae('0x53')]['rawAttributes']);_0x33d9e1[_0x9aae('0x2c')]=_[_0x9aae('0x44')](_0x275e95[_0x9aae('0x2c')]);_0x33d9e1[_0x9aae('0x34')]=_['intersection'](_0x33d9e1['model'],_0x33d9e1[_0x9aae('0x2c')]);_0x384dbd[_0x9aae('0x2e')]=_[_0x9aae('0x2d')](_0x33d9e1[_0x9aae('0x2b')],qs[_0x9aae('0x2f')](_0x275e95['query'][_0x9aae('0x2f')]));_0x384dbd[_0x9aae('0x2e')]=_0x384dbd['attributes'][_0x9aae('0x54')]?_0x384dbd['attributes']:_0x33d9e1[_0x9aae('0x2b')];if(!_0x275e95['query'][_0x9aae('0x55')](_0x9aae('0x56'))){_0x384dbd[_0x9aae('0x30')]=qs[_0x9aae('0x30')](_0x275e95[_0x9aae('0x2c')][_0x9aae('0x30')]);_0x384dbd[_0x9aae('0x1a')]=qs[_0x9aae('0x1a')](_0x275e95[_0x9aae('0x2c')][_0x9aae('0x1a')]);}_0x384dbd[_0x9aae('0x31')]=qs[_0x9aae('0x32')](_0x275e95['query'][_0x9aae('0x32')]);_0x384dbd[_0x9aae('0x33')]=qs[_0x9aae('0x34')](_['pick'](_0x275e95[_0x9aae('0x2c')],_0x33d9e1[_0x9aae('0x34')]));_0x384dbd[_0x9aae('0x33')][_0x9aae('0x57')]=_0x37418c['id'];if(_0x275e95[_0x9aae('0x2c')][_0x9aae('0x36')]){_0x384dbd[_0x9aae('0x33')]=_['merge'](_0x384dbd['where'],{'$or':_[_0x9aae('0x37')](_0x384dbd[_0x9aae('0x2e')],function(_0x59902b){var _0x33b40f={};_0x33b40f[_0x59902b]={'$like':'%'+_0x275e95[_0x9aae('0x2c')][_0x9aae('0x36')]+'%'};return _0x33b40f;})});}_0x384dbd=_[_0x9aae('0x3c')]({},_0x384dbd,_0x275e95[_0x9aae('0x3d')]);return db[_0x9aae('0x53')][_0x9aae('0x19')]({'where':_0x384dbd[_0x9aae('0x33')]})[_0x9aae('0x1f')](function(_0x55f94d){_0x3af8d9[_0x9aae('0x19')]=_0x55f94d;if(_0x275e95[_0x9aae('0x2c')][_0x9aae('0x3e')]){_0x384dbd[_0x9aae('0x3f')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0x9aae('0x58')](_0x384dbd);})[_0x9aae('0x1f')](function(_0x1c1975){_0x3af8d9[_0x9aae('0x40')]=_0x1c1975;return _0x3af8d9;});}})[_0x9aae('0x1f')](respondWithFilteredResult(_0x478580,_0x384dbd))[_0x9aae('0x41')](handleError(_0x478580,null));};exports['getAnswers']=function(_0x2cbdaa,_0x4e7921,_0x4a7bf3){var _0x2509c9={'raw':!![],'where':{}};var _0x1a0351={};var _0x8c611a={'count':0x0,'rows':[]};return db[_0x9aae('0x29')][_0x9aae('0x59')]({'where':{'id':_0x2cbdaa[_0x9aae('0x43')]['id']}})[_0x9aae('0x1f')](handleEntityNotFound(_0x4e7921,null))[_0x9aae('0x1f')](function(_0x22487c){if(_0x22487c){_0x1a0351[_0x9aae('0x2b')]=_['keys'](db[_0x9aae('0x5a')]['rawAttributes']);_0x1a0351['query']=_['keys'](_0x2cbdaa['query']);_0x1a0351[_0x9aae('0x34')]=_['intersection'](_0x1a0351[_0x9aae('0x2b')],_0x1a0351[_0x9aae('0x2c')]);_0x2509c9[_0x9aae('0x2e')]=_[_0x9aae('0x2d')](_0x1a0351['model'],qs[_0x9aae('0x2f')](_0x2cbdaa[_0x9aae('0x2c')]['fields']));_0x2509c9[_0x9aae('0x2e')]=_0x2509c9[_0x9aae('0x2e')][_0x9aae('0x54')]?_0x2509c9['attributes']:_0x1a0351[_0x9aae('0x2b')];if(!_0x2cbdaa[_0x9aae('0x2c')][_0x9aae('0x55')](_0x9aae('0x56'))){_0x2509c9[_0x9aae('0x30')]=qs[_0x9aae('0x30')](_0x2cbdaa[_0x9aae('0x2c')]['limit']);_0x2509c9['offset']=qs[_0x9aae('0x1a')](_0x2cbdaa[_0x9aae('0x2c')]['offset']);}_0x2509c9[_0x9aae('0x31')]=qs[_0x9aae('0x32')](_0x2cbdaa['query']['sort']);_0x2509c9[_0x9aae('0x33')]=qs[_0x9aae('0x34')](_['pick'](_0x2cbdaa[_0x9aae('0x2c')],_0x1a0351[_0x9aae('0x34')]));_0x2509c9[_0x9aae('0x33')][_0x9aae('0x57')]=_0x22487c['id'];if(_0x2cbdaa['query'][_0x9aae('0x36')]){_0x2509c9[_0x9aae('0x33')]=_[_0x9aae('0x3c')](_0x2509c9[_0x9aae('0x33')],{'$or':_[_0x9aae('0x37')](_0x2509c9[_0x9aae('0x2e')],function(_0x3ff628){var _0x21f507={};_0x21f507[_0x3ff628]={'$like':'%'+_0x2cbdaa[_0x9aae('0x2c')][_0x9aae('0x36')]+'%'};return _0x21f507;})});}_0x2509c9=_[_0x9aae('0x3c')]({},_0x2509c9,_0x2cbdaa[_0x9aae('0x3d')]);return db[_0x9aae('0x5a')][_0x9aae('0x19')]({'where':_0x2509c9[_0x9aae('0x33')]})['then'](function(_0x13ad72){_0x8c611a['count']=_0x13ad72;if(_0x2cbdaa[_0x9aae('0x2c')][_0x9aae('0x3e')]){_0x2509c9['include']=[{'all':!![]}];}return db[_0x9aae('0x5a')][_0x9aae('0x58')](_0x2509c9);})['then'](function(_0x468845){_0x8c611a[_0x9aae('0x40')]=_0x468845;return _0x8c611a;});}})[_0x9aae('0x1f')](respondWithFilteredResult(_0x4e7921,_0x2509c9))['catch'](handleError(_0x4e7921,null));};function char(_0x57fae3){return'number'===typeof _0x57fae3?String['fromCharCode'][_0x9aae('0x5b')](null,arguments):_0x57fae3;}function needsEncapsulation(_0x142f30){return!!_0x142f30&&(_0x142f30['toString']()[_0x9aae('0x5c')](char(0xd))>=0x0||_0x142f30[_0x9aae('0x5d')]()['indexOf'](char(0xa))>=0x0||_0x142f30[_0x9aae('0x5d')]()[_0x9aae('0x5c')](char(0x2c))>=0x0||_0x142f30[_0x9aae('0x5d')]()[_0x9aae('0x5c')](char(0x22))>=0x0);}function encapsulate(_0x35d4cd){var _0x1e4db8=char(0x22),_0x18745d='\x5c'+char(0x22),_0x5103fe=_0x35d4cd[_0x9aae('0x5d')]()['replace'](new RegExp(_0x1e4db8,'g'),_0x18745d);return _0x1e4db8+_0x5103fe+_0x1e4db8;}exports[_0x9aae('0x5e')]=function(_0x19e9a1,_0xd318d4,_0x3c5669){var _0x249315,_0x3a2f7d;var _0x498e36={'where':{'ProjectId':_0x19e9a1[_0x9aae('0x43')]['id']}};if(_0x19e9a1['query']['startTime']){_0x498e36[_0x9aae('0x33')][_0x9aae('0x5f')]=JSON[_0x9aae('0x60')](_0x19e9a1[_0x9aae('0x2c')][_0x9aae('0x61')]);}return db[_0x9aae('0x53')]['findAll'](_0x498e36)[_0x9aae('0x1f')](handleEntityNotFound(_0xd318d4,null))[_0x9aae('0x1f')](function(_0x268d2e){if(_0x268d2e){_0x249315=_0x268d2e;return db[_0x9aae('0x62')][_0x9aae('0x58')]({'where':{'SessionId':{'$in':_[_0x9aae('0x37')](_0x249315,'id')},'ProjectId':_0x19e9a1[_0x9aae('0x43')]['id']},'order':_0x9aae('0x63')});}})[_0x9aae('0x1f')](handleEntityNotFound(_0xd318d4,null))[_0x9aae('0x1f')](function(_0x12d638){if(_0x12d638){_0x3a2f7d=_0x12d638;var _0x91d252={};for(var _0x535078=0x0,_0x5030f9=_0x3a2f7d['length'];_0x535078<_0x5030f9;_0x535078++){if(!_0x91d252['hasOwnProperty'](_0x3a2f7d[_0x535078][_0x9aae('0x64')])){_0x91d252[_0x3a2f7d[_0x535078][_0x9aae('0x64')]]=needsEncapsulation(_0x3a2f7d[_0x535078][_0x9aae('0x65')])?encapsulate(_0x3a2f7d[_0x535078]['question']):_0x3a2f7d[_0x535078][_0x9aae('0x65')];}}var _0x5a5531=[],_0x3af3da={};for(var _0x1e8205=0x0,_0x2b13aa=_0x249315[_0x9aae('0x54')];_0x1e8205<_0x2b13aa;_0x1e8205++){_0x3af3da={'ProjectId':_0x19e9a1['params']['id'],'SessionId':_0x249315[_0x1e8205]['id'],'StartTime':moment(_0x249315[_0x1e8205]['starttime'])[_0x9aae('0x66')](_0x9aae('0x67'))};for(var _0x1fb353=0x0,_0xf531e8=_0x3a2f7d['length'];_0x1fb353<_0xf531e8;_0x1fb353++){if(_0x3a2f7d[_0x1fb353]['SessionId']==_0x249315[_0x1e8205]['id']&&_0x91d252[_0x9aae('0x55')](_0x3a2f7d[_0x1fb353][_0x9aae('0x64')])){_0x3af3da[_0x91d252[_0x3a2f7d[_0x1fb353]['questionId']]]=_0x3a2f7d[_0x1fb353][_0x9aae('0x68')];}}for(var _0x2befb0 in _0x91d252){if(!_0x3af3da[_0x9aae('0x55')](_0x91d252[_0x2befb0])){_0x3af3da[_0x91d252[_0x2befb0]]=null;}}_0x5a5531['push'](_0x3af3da);}return _0x5a5531;}})[_0x9aae('0x1f')](function(_0x1d3e4e){if(!_['isEmpty'](_0x1d3e4e)){var _0xb9c09=toCsv(_0x1d3e4e);var _0x23d3b2=Date['now']();fs[_0x9aae('0x69')](util[_0x9aae('0x66')](_0x9aae('0x6a'),_0x19e9a1[_0x9aae('0x43')]['id'],_0x23d3b2),_0xb9c09);_0xd318d4['setHeader'](_0x9aae('0x6b'),_0x9aae('0x6c')+util[_0x9aae('0x66')]('Jscripty_Project_%d_Summary_%s.csv',_0x19e9a1[_0x9aae('0x43')]['id'],_0x23d3b2));_0xd318d4[_0x9aae('0x6d')]('Content-type',_0x9aae('0x6e'));return _0xd318d4[_0x9aae('0x6f')](util['format'](_0x9aae('0x6a'),_0x19e9a1[_0x9aae('0x43')]['id'],_0x23d3b2));}else{return _0xd318d4[_0x9aae('0x23')](0xcc);}})[_0x9aae('0x41')](handleError(_0xd318d4,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff