// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xbea3=['Projects','UserProfileResource','destroy','end','error','stack','name','send','index','map','JscriptyProject','type','key','model','query','keys','filters','fields','attributes','length','nolimit','limit','order','sort','where','filter','merge','VIRTUAL','options','count','includeAll','include','findAll','catch','show','params','rawAttributes','intersection','create','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','UserProfileSection','find','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','updatedAt','createdAt','role','getSessions','findOne','JscriptySessionReport','hasOwnProperty','pick','ProjectId','rows','getAnswers','JscriptyAnswerReport','number','fromCharCode','toString','startTime','-createdAt','questionId','question','starttime','format','YYYY-MM-DD\x20HH:mm:ss','push','isEmpty','now','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','Content-disposition','Jscripty_Project_%d_Summary_%s.csv','Content-type','text/csv','download','sendStatus','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','to-csv','ejs','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../mysqldb','status','json','offset','set','Content-Range','apply','reject','update','then'];(function(_0xd1e54b,_0x22673f){var _0x25ea86=function(_0x44a337){while(--_0x44a337){_0xd1e54b['push'](_0xd1e54b['shift']());}};_0x25ea86(++_0x22673f);}(_0xbea3,0x139));var _0x3bea=function(_0xfbcd43,_0x1c8289){_0xfbcd43=_0xfbcd43-0x0;var _0x1ba9db=_0xbea3[_0xfbcd43];return _0x1ba9db;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x3bea('0x0'));var rimraf=require(_0x3bea('0x1'));var zipdir=require(_0x3bea('0x2'));var jsonpatch=require(_0x3bea('0x3'));var rp=require('request-promise');var moment=require(_0x3bea('0x4'));var BPromise=require(_0x3bea('0x5'));var Mustache=require(_0x3bea('0x6'));var util=require(_0x3bea('0x7'));var path=require(_0x3bea('0x8'));var sox=require('sox');var csv=require(_0x3bea('0x9'));var ejs=require(_0x3bea('0xa'));var fs=require('fs');var _=require('lodash');var squel=require('squel');var crypto=require(_0x3bea('0xb'));var jsforce=require(_0x3bea('0xc'));var deskjs=require(_0x3bea('0xd'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x3bea('0xe'));var Redis=require(_0x3bea('0xf'));var authService=require(_0x3bea('0x10'));var qs=require('../../components/parsers/qs');var as=require(_0x3bea('0x11'));var hardwareService=require(_0x3bea('0x12'));var logger=require('../../config/logger')(_0x3bea('0x13'));var utils=require(_0x3bea('0x14'));var config=require(_0x3bea('0x15'));var db=require(_0x3bea('0x16'))['db'];function respondWithStatusCode(_0x38ee11,_0x23a7ed){_0x23a7ed=_0x23a7ed||0xcc;return function(_0x1de13a){if(_0x1de13a){return _0x38ee11['sendStatus'](_0x23a7ed);}return _0x38ee11[_0x3bea('0x17')](_0x23a7ed)['end']();};}function respondWithResult(_0x5f4198,_0x2266ca){_0x2266ca=_0x2266ca||0xc8;return function(_0x4d74e2){if(_0x4d74e2){return _0x5f4198[_0x3bea('0x17')](_0x2266ca)[_0x3bea('0x18')](_0x4d74e2);}};}function respondWithFilteredResult(_0x26b287,_0x4d0370){return function(_0x47d96e){if(_0x47d96e){var _0x3d5d72=_0x47d96e['count'],_0x550e75=_0x4d0370[_0x3bea('0x19')],_0x287f2f=_0x4d0370['offset']+_0x4d0370['limit'],_0x291f5f;if(_0x287f2f>=_0x3d5d72){_0x287f2f=_0x3d5d72;_0x291f5f=0xc8;}else{_0x291f5f=0xce;}_0x26b287['status'](_0x291f5f);return _0x26b287[_0x3bea('0x1a')](_0x3bea('0x1b'),_0x550e75+'-'+_0x287f2f+'/'+_0x3d5d72)[_0x3bea('0x18')](_0x47d96e);}return null;};}function patchUpdates(_0x4eae21){return function(_0x5a0df9){try{jsonpatch[_0x3bea('0x1c')](_0x5a0df9,_0x4eae21,!![]);}catch(_0x138f5b){return BPromise[_0x3bea('0x1d')](_0x138f5b);}return _0x5a0df9['save']();};}function saveUpdates(_0x233030,_0x21322d){return function(_0x519c3e){if(_0x519c3e){return _0x519c3e[_0x3bea('0x1e')](_0x233030)[_0x3bea('0x1f')](function(_0x4d6c81){return _0x4d6c81;});}return null;};}function removeEntity(_0x33079e,_0x450307){return function(_0x38994b){if(_0x38994b){return _0x38994b['destroy']()[_0x3bea('0x1f')](function(){var _0xa7c7f2=_0x38994b['get']({'plain':!![]});var _0x54b9d8=_0x3bea('0x20');return db[_0x3bea('0x21')][_0x3bea('0x22')]({'where':{'type':_0x54b9d8,'resourceId':_0xa7c7f2['id']}})[_0x3bea('0x1f')](function(){return _0x38994b;});})[_0x3bea('0x1f')](function(){_0x33079e[_0x3bea('0x17')](0xcc)[_0x3bea('0x23')]();});}};}function handleEntityNotFound(_0x2b0186,_0x40fa7b){return function(_0x3b753a){if(!_0x3b753a){_0x2b0186['sendStatus'](0x194);}return _0x3b753a;};}function handleError(_0x4fdd1e,_0x23d80b){_0x23d80b=_0x23d80b||0x1f4;return function(_0x16aa3d){logger[_0x3bea('0x24')](_0x16aa3d[_0x3bea('0x25')]);if(_0x16aa3d[_0x3bea('0x26')]){delete _0x16aa3d[_0x3bea('0x26')];}_0x4fdd1e['status'](_0x23d80b)[_0x3bea('0x27')](_0x16aa3d);};}exports[_0x3bea('0x28')]=function(_0x2f941f,_0x10ae17){var _0x29c53e={},_0x219e0d={},_0x59c05e={'count':0x0,'rows':[]};var _0x4c3df8=_[_0x3bea('0x29')](db[_0x3bea('0x2a')]['rawAttributes'],function(_0x12e7d6){return{'name':_0x12e7d6['fieldName'],'type':_0x12e7d6[_0x3bea('0x2b')][_0x3bea('0x2c')]};});_0x219e0d[_0x3bea('0x2d')]=_['map'](_0x4c3df8,_0x3bea('0x26'));_0x219e0d[_0x3bea('0x2e')]=_[_0x3bea('0x2f')](_0x2f941f[_0x3bea('0x2e')]);_0x219e0d[_0x3bea('0x30')]=_['intersection'](_0x219e0d[_0x3bea('0x2d')],_0x219e0d[_0x3bea('0x2e')]);_0x29c53e['attributes']=_['intersection'](_0x219e0d['model'],qs[_0x3bea('0x31')](_0x2f941f[_0x3bea('0x2e')][_0x3bea('0x31')]));_0x29c53e[_0x3bea('0x32')]=_0x29c53e[_0x3bea('0x32')][_0x3bea('0x33')]?_0x29c53e[_0x3bea('0x32')]:_0x219e0d['model'];if(!_0x2f941f[_0x3bea('0x2e')]['hasOwnProperty'](_0x3bea('0x34'))){_0x29c53e[_0x3bea('0x35')]=qs[_0x3bea('0x35')](_0x2f941f[_0x3bea('0x2e')]['limit']);_0x29c53e[_0x3bea('0x19')]=qs[_0x3bea('0x19')](_0x2f941f['query'][_0x3bea('0x19')]);}_0x29c53e[_0x3bea('0x36')]=qs[_0x3bea('0x37')](_0x2f941f[_0x3bea('0x2e')][_0x3bea('0x37')]);_0x29c53e[_0x3bea('0x38')]=qs[_0x3bea('0x30')](_['pick'](_0x2f941f[_0x3bea('0x2e')],_0x219e0d['filters']),_0x4c3df8);if(_0x2f941f[_0x3bea('0x2e')][_0x3bea('0x39')]){_0x29c53e[_0x3bea('0x38')]=_[_0x3bea('0x3a')](_0x29c53e['where'],{'$or':_[_0x3bea('0x29')](_0x4c3df8,function(_0x407470){if(_0x407470[_0x3bea('0x2b')]!==_0x3bea('0x3b')){var _0x33d7e3={};_0x33d7e3[_0x407470[_0x3bea('0x26')]]={'$like':'%'+_0x2f941f['query'][_0x3bea('0x39')]+'%'};return _0x33d7e3;}})});}_0x29c53e=_[_0x3bea('0x3a')]({},_0x29c53e,_0x2f941f[_0x3bea('0x3c')]);var _0x538b00={'where':_0x29c53e[_0x3bea('0x38')]};return db[_0x3bea('0x2a')]['count'](_0x538b00)[_0x3bea('0x1f')](function(_0x599c19){_0x59c05e[_0x3bea('0x3d')]=_0x599c19;if(_0x2f941f[_0x3bea('0x2e')][_0x3bea('0x3e')]){_0x29c53e[_0x3bea('0x3f')]=[{'all':!![]}];}return db[_0x3bea('0x2a')][_0x3bea('0x40')](_0x29c53e);})[_0x3bea('0x1f')](function(_0x2811be){_0x59c05e['rows']=_0x2811be;return _0x59c05e;})[_0x3bea('0x1f')](respondWithFilteredResult(_0x10ae17,_0x29c53e))[_0x3bea('0x41')](handleError(_0x10ae17,null));};exports[_0x3bea('0x42')]=function(_0x572e8e,_0x1e4342){var _0x5ae7b7={'raw':![],'where':{'id':_0x572e8e[_0x3bea('0x43')]['id']}},_0x5c4a0f={};_0x5c4a0f[_0x3bea('0x2d')]=_[_0x3bea('0x2f')](db[_0x3bea('0x2a')][_0x3bea('0x44')]);_0x5c4a0f[_0x3bea('0x2e')]=_['keys'](_0x572e8e[_0x3bea('0x2e')]);_0x5c4a0f[_0x3bea('0x30')]=_[_0x3bea('0x45')](_0x5c4a0f[_0x3bea('0x2d')],_0x5c4a0f[_0x3bea('0x2e')]);_0x5ae7b7[_0x3bea('0x32')]=_['intersection'](_0x5c4a0f[_0x3bea('0x2d')],qs[_0x3bea('0x31')](_0x572e8e[_0x3bea('0x2e')][_0x3bea('0x31')]));_0x5ae7b7[_0x3bea('0x32')]=_0x5ae7b7[_0x3bea('0x32')][_0x3bea('0x33')]?_0x5ae7b7[_0x3bea('0x32')]:_0x5c4a0f[_0x3bea('0x2d')];if(_0x572e8e['query'][_0x3bea('0x3e')]){_0x5ae7b7['include']=[{'all':!![]}];}_0x5ae7b7=_['merge']({},_0x5ae7b7,_0x572e8e['options']);return db[_0x3bea('0x2a')]['find'](_0x5ae7b7)[_0x3bea('0x1f')](handleEntityNotFound(_0x1e4342,null))[_0x3bea('0x1f')](respondWithResult(_0x1e4342,null))['catch'](handleError(_0x1e4342,null));};exports[_0x3bea('0x46')]=function(_0x476c86,_0x28bb8e){return db[_0x3bea('0x2a')][_0x3bea('0x46')](_0x476c86[_0x3bea('0x47')],{})[_0x3bea('0x1f')](function(_0x3d6a54){var _0x5bf724=_0x476c86[_0x3bea('0x48')][_0x3bea('0x49')]({'plain':!![]});if(!_0x5bf724)throw new Error(_0x3bea('0x4a'));if(_0x5bf724['role']===_0x3bea('0x48')){var _0x366de7=_0x3d6a54[_0x3bea('0x49')]({'plain':!![]});var _0x464bf3='Projects';return db[_0x3bea('0x4b')][_0x3bea('0x4c')]({'where':{'name':_0x464bf3,'userProfileId':_0x5bf724[_0x3bea('0x4d')]},'raw':!![]})['then'](function(_0x155589){if(_0x155589&&_0x155589[_0x3bea('0x4e')]===0x0){return db[_0x3bea('0x21')][_0x3bea('0x46')]({'name':_0x366de7['name'],'resourceId':_0x366de7['id'],'type':_0x155589[_0x3bea('0x26')],'sectionId':_0x155589['id']},{})[_0x3bea('0x1f')](function(){return _0x3d6a54;});}else{return _0x3d6a54;}})[_0x3bea('0x41')](function(_0x47f205){logger[_0x3bea('0x24')](_0x3bea('0x4f'),_0x47f205);throw _0x47f205;});}return _0x3d6a54;})[_0x3bea('0x1f')](respondWithResult(_0x28bb8e,0xc9))[_0x3bea('0x41')](handleError(_0x28bb8e,null));};exports[_0x3bea('0x50')]=function(_0x47b2b2,_0x3328c7){var _0x4af236={'where':{'id':_0x47b2b2['params']['id']}},_0x44b21c={};_0x44b21c[_0x3bea('0x2d')]=_[_0x3bea('0x2f')](db[_0x3bea('0x2a')][_0x3bea('0x44')]);_0x4af236[_0x3bea('0x32')]=_[_0x3bea('0x45')](_0x44b21c[_0x3bea('0x2d')],qs['fields'](_0x47b2b2[_0x3bea('0x2e')]['fields']));_0x4af236[_0x3bea('0x32')]=_0x4af236[_0x3bea('0x32')]['length']?_0x4af236[_0x3bea('0x32')]:_0x44b21c[_0x3bea('0x2d')];if(_0x47b2b2[_0x3bea('0x2e')][_0x3bea('0x3e')]){_0x4af236[_0x3bea('0x3f')]=[{'all':!![]}];}_0x4af236=_[_0x3bea('0x3a')]({},_0x4af236,_0x47b2b2[_0x3bea('0x3c')]);return db[_0x3bea('0x2a')][_0x3bea('0x4c')](_0x4af236)[_0x3bea('0x1f')](handleEntityNotFound(_0x3328c7,null))[_0x3bea('0x1f')](function(_0x45d9df){if(_0x45d9df){var _0x4474a6=_0x45d9df['get']({'plain':!![]});_0x4474a6=qs[_0x3bea('0x51')](_0x4474a6,['id','createdAt',_0x3bea('0x52')]);_0x47b2b2['body']=_[_0x3bea('0x51')](_0x47b2b2[_0x3bea('0x47')],['id',_0x3bea('0x53'),_0x3bea('0x52')]);return db[_0x3bea('0x2a')][_0x3bea('0x46')](_[_0x3bea('0x3a')](_0x4474a6,_0x47b2b2[_0x3bea('0x47')]),{'include':_0x47b2b2['query'][_0x3bea('0x3e')]?[{'all':!![]}]:undefined})[_0x3bea('0x1f')](function(_0x11c24b){var _0x473692=_0x47b2b2['user'][_0x3bea('0x49')]({'plain':!![]});if(!_0x473692)throw new Error(_0x3bea('0x4a'));if(_0x473692[_0x3bea('0x54')]===_0x3bea('0x48')){var _0x33a20f=_0x11c24b['get']({'plain':!![]});var _0x1e80e8=_0x3bea('0x20');return db[_0x3bea('0x4b')][_0x3bea('0x4c')]({'where':{'name':_0x1e80e8,'userProfileId':_0x473692[_0x3bea('0x4d')]},'raw':!![]})['then'](function(_0xe10886){if(_0xe10886&&_0xe10886['autoAssociation']===0x0){return db[_0x3bea('0x21')]['create']({'name':_0x33a20f[_0x3bea('0x26')],'resourceId':_0x33a20f['id'],'type':_0xe10886[_0x3bea('0x26')],'sectionId':_0xe10886['id']},{})['then'](function(){return _0x11c24b;});}else{return _0x11c24b;}})[_0x3bea('0x41')](function(_0xf254a7){logger[_0x3bea('0x24')](_0x3bea('0x4f'),_0xf254a7);throw _0xf254a7;});}return _0x11c24b;});}})['then'](respondWithResult(_0x3328c7,0xc9))[_0x3bea('0x41')](handleError(_0x3328c7,null));};exports['update']=function(_0x45e5a0,_0x2a8c26){if(_0x45e5a0[_0x3bea('0x47')]['id']){delete _0x45e5a0[_0x3bea('0x47')]['id'];}return db[_0x3bea('0x2a')]['find']({'where':{'id':_0x45e5a0[_0x3bea('0x43')]['id']}})['then'](handleEntityNotFound(_0x2a8c26,null))[_0x3bea('0x1f')](saveUpdates(_0x45e5a0[_0x3bea('0x47')],null))[_0x3bea('0x1f')](respondWithResult(_0x2a8c26,null))['catch'](handleError(_0x2a8c26,null));};exports['destroy']=function(_0x3bb260,_0x4a3ce5){return db['JscriptyProject'][_0x3bea('0x4c')]({'where':{'id':_0x3bb260['params']['id']}})['then'](handleEntityNotFound(_0x4a3ce5,null))['then'](removeEntity(_0x4a3ce5,null))[_0x3bea('0x41')](handleError(_0x4a3ce5,null));};exports[_0x3bea('0x55')]=function(_0x4746c2,_0x5c2e9b,_0x43ba2b){var _0x4746ca={'raw':!![],'where':{}};var _0x55306f={};var _0x25143c={'count':0x0,'rows':[]};return db[_0x3bea('0x2a')][_0x3bea('0x56')]({'where':{'id':_0x4746c2[_0x3bea('0x43')]['id']}})[_0x3bea('0x1f')](handleEntityNotFound(_0x5c2e9b,null))[_0x3bea('0x1f')](function(_0x3caf4d){if(_0x3caf4d){_0x55306f['model']=_[_0x3bea('0x2f')](db[_0x3bea('0x57')][_0x3bea('0x44')]);_0x55306f[_0x3bea('0x2e')]=_[_0x3bea('0x2f')](_0x4746c2[_0x3bea('0x2e')]);_0x55306f[_0x3bea('0x30')]=_[_0x3bea('0x45')](_0x55306f['model'],_0x55306f[_0x3bea('0x2e')]);_0x4746ca['attributes']=_['intersection'](_0x55306f[_0x3bea('0x2d')],qs[_0x3bea('0x31')](_0x4746c2[_0x3bea('0x2e')][_0x3bea('0x31')]));_0x4746ca[_0x3bea('0x32')]=_0x4746ca['attributes']['length']?_0x4746ca[_0x3bea('0x32')]:_0x55306f[_0x3bea('0x2d')];if(!_0x4746c2[_0x3bea('0x2e')][_0x3bea('0x58')](_0x3bea('0x34'))){_0x4746ca[_0x3bea('0x35')]=qs[_0x3bea('0x35')](_0x4746c2['query']['limit']);_0x4746ca[_0x3bea('0x19')]=qs[_0x3bea('0x19')](_0x4746c2[_0x3bea('0x2e')]['offset']);}_0x4746ca[_0x3bea('0x36')]=qs[_0x3bea('0x37')](_0x4746c2[_0x3bea('0x2e')][_0x3bea('0x37')]);_0x4746ca[_0x3bea('0x38')]=qs[_0x3bea('0x30')](_[_0x3bea('0x59')](_0x4746c2[_0x3bea('0x2e')],_0x55306f[_0x3bea('0x30')]));_0x4746ca[_0x3bea('0x38')][_0x3bea('0x5a')]=_0x3caf4d['id'];if(_0x4746c2[_0x3bea('0x2e')]['filter']){_0x4746ca[_0x3bea('0x38')]=_[_0x3bea('0x3a')](_0x4746ca[_0x3bea('0x38')],{'$or':_[_0x3bea('0x29')](_0x4746ca[_0x3bea('0x32')],function(_0x4cc11f){var _0x55f8f5={};_0x55f8f5[_0x4cc11f]={'$like':'%'+_0x4746c2[_0x3bea('0x2e')]['filter']+'%'};return _0x55f8f5;})});}_0x4746ca=_['merge']({},_0x4746ca,_0x4746c2['options']);return db['JscriptySessionReport'][_0x3bea('0x3d')]({'where':_0x4746ca['where']})['then'](function(_0x1f926c){_0x25143c['count']=_0x1f926c;if(_0x4746c2[_0x3bea('0x2e')][_0x3bea('0x3e')]){_0x4746ca[_0x3bea('0x3f')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0x3bea('0x40')](_0x4746ca);})[_0x3bea('0x1f')](function(_0x1ad8c5){_0x25143c[_0x3bea('0x5b')]=_0x1ad8c5;return _0x25143c;});}})[_0x3bea('0x1f')](respondWithFilteredResult(_0x5c2e9b,_0x4746ca))[_0x3bea('0x41')](handleError(_0x5c2e9b,null));};exports[_0x3bea('0x5c')]=function(_0x37a2e6,_0x35eaa8,_0xaa1187){var _0x30fdd2={'raw':!![],'where':{}};var _0x58b4b5={};var _0x341025={'count':0x0,'rows':[]};return db[_0x3bea('0x2a')]['findOne']({'where':{'id':_0x37a2e6[_0x3bea('0x43')]['id']}})['then'](handleEntityNotFound(_0x35eaa8,null))[_0x3bea('0x1f')](function(_0x23045c){if(_0x23045c){_0x58b4b5[_0x3bea('0x2d')]=_['keys'](db[_0x3bea('0x5d')][_0x3bea('0x44')]);_0x58b4b5[_0x3bea('0x2e')]=_[_0x3bea('0x2f')](_0x37a2e6[_0x3bea('0x2e')]);_0x58b4b5[_0x3bea('0x30')]=_[_0x3bea('0x45')](_0x58b4b5[_0x3bea('0x2d')],_0x58b4b5['query']);_0x30fdd2[_0x3bea('0x32')]=_['intersection'](_0x58b4b5['model'],qs['fields'](_0x37a2e6[_0x3bea('0x2e')][_0x3bea('0x31')]));_0x30fdd2[_0x3bea('0x32')]=_0x30fdd2[_0x3bea('0x32')][_0x3bea('0x33')]?_0x30fdd2['attributes']:_0x58b4b5[_0x3bea('0x2d')];if(!_0x37a2e6[_0x3bea('0x2e')][_0x3bea('0x58')](_0x3bea('0x34'))){_0x30fdd2['limit']=qs[_0x3bea('0x35')](_0x37a2e6[_0x3bea('0x2e')]['limit']);_0x30fdd2[_0x3bea('0x19')]=qs[_0x3bea('0x19')](_0x37a2e6[_0x3bea('0x2e')][_0x3bea('0x19')]);}_0x30fdd2[_0x3bea('0x36')]=qs['sort'](_0x37a2e6[_0x3bea('0x2e')]['sort']);_0x30fdd2[_0x3bea('0x38')]=qs[_0x3bea('0x30')](_['pick'](_0x37a2e6[_0x3bea('0x2e')],_0x58b4b5['filters']));_0x30fdd2[_0x3bea('0x38')]['ProjectId']=_0x23045c['id'];if(_0x37a2e6[_0x3bea('0x2e')][_0x3bea('0x39')]){_0x30fdd2[_0x3bea('0x38')]=_[_0x3bea('0x3a')](_0x30fdd2[_0x3bea('0x38')],{'$or':_[_0x3bea('0x29')](_0x30fdd2['attributes'],function(_0x37cc5d){var _0x46dea0={};_0x46dea0[_0x37cc5d]={'$like':'%'+_0x37a2e6['query'][_0x3bea('0x39')]+'%'};return _0x46dea0;})});}_0x30fdd2=_[_0x3bea('0x3a')]({},_0x30fdd2,_0x37a2e6[_0x3bea('0x3c')]);return db[_0x3bea('0x5d')]['count']({'where':_0x30fdd2[_0x3bea('0x38')]})[_0x3bea('0x1f')](function(_0xc20a6c){_0x341025[_0x3bea('0x3d')]=_0xc20a6c;if(_0x37a2e6['query'][_0x3bea('0x3e')]){_0x30fdd2[_0x3bea('0x3f')]=[{'all':!![]}];}return db[_0x3bea('0x5d')]['findAll'](_0x30fdd2);})[_0x3bea('0x1f')](function(_0x409106){_0x341025[_0x3bea('0x5b')]=_0x409106;return _0x341025;});}})[_0x3bea('0x1f')](respondWithFilteredResult(_0x35eaa8,_0x30fdd2))[_0x3bea('0x41')](handleError(_0x35eaa8,null));};function char(_0x26f51f){return _0x3bea('0x5e')===typeof _0x26f51f?String[_0x3bea('0x5f')][_0x3bea('0x1c')](null,arguments):_0x26f51f;}function needsEncapsulation(_0xfb4698){return!!_0xfb4698&&(_0xfb4698[_0x3bea('0x60')]()['indexOf'](char(0xd))>=0x0||_0xfb4698['toString']()['indexOf'](char(0xa))>=0x0||_0xfb4698[_0x3bea('0x60')]()['indexOf'](char(0x2c))>=0x0||_0xfb4698['toString']()['indexOf'](char(0x22))>=0x0);}function encapsulate(_0x383736){var _0x42ee49=char(0x22),_0x2daa74='\x5c'+char(0x22),_0x572747=_0x383736[_0x3bea('0x60')]()['replace'](new RegExp(_0x42ee49,'g'),_0x2daa74);return _0x42ee49+_0x572747+_0x42ee49;}exports['getSummary']=function(_0x1144be,_0x152fda,_0x530042){var _0x2f7db5,_0x1b049a;var _0x1d72e6={'where':{'ProjectId':_0x1144be['params']['id']}};if(_0x1144be[_0x3bea('0x2e')][_0x3bea('0x61')]){_0x1d72e6[_0x3bea('0x38')]['starttime']=JSON['parse'](_0x1144be[_0x3bea('0x2e')][_0x3bea('0x61')]);}return db[_0x3bea('0x57')][_0x3bea('0x40')](_0x1d72e6)[_0x3bea('0x1f')](handleEntityNotFound(_0x152fda,null))['then'](function(_0x563e87){if(_0x563e87){_0x2f7db5=_0x563e87;return db['JscriptyQuestionReport']['findAll']({'where':{'SessionId':{'$in':_[_0x3bea('0x29')](_0x2f7db5,'id')},'ProjectId':_0x1144be[_0x3bea('0x43')]['id']},'order':_0x3bea('0x62')});}})[_0x3bea('0x1f')](handleEntityNotFound(_0x152fda,null))['then'](function(_0x10eae1){if(_0x10eae1){_0x1b049a=_0x10eae1;var _0x234471={};for(var _0x2acaf9=0x0,_0x421b7d=_0x1b049a[_0x3bea('0x33')];_0x2acaf9<_0x421b7d;_0x2acaf9++){if(!_0x234471[_0x3bea('0x58')](_0x1b049a[_0x2acaf9][_0x3bea('0x63')])){_0x234471[_0x1b049a[_0x2acaf9]['questionId']]=needsEncapsulation(_0x1b049a[_0x2acaf9]['question'])?encapsulate(_0x1b049a[_0x2acaf9][_0x3bea('0x64')]):_0x1b049a[_0x2acaf9][_0x3bea('0x64')];}}var _0x460a5b=[],_0x5d8a6e={};for(var _0x3bbd81=0x0,_0x186dc5=_0x2f7db5[_0x3bea('0x33')];_0x3bbd81<_0x186dc5;_0x3bbd81++){_0x5d8a6e={'ProjectId':_0x1144be[_0x3bea('0x43')]['id'],'SessionId':_0x2f7db5[_0x3bbd81]['id'],'StartTime':moment(_0x2f7db5[_0x3bbd81][_0x3bea('0x65')])[_0x3bea('0x66')](_0x3bea('0x67'))};for(var _0x550764=0x0,_0x3910ea=_0x1b049a[_0x3bea('0x33')];_0x550764<_0x3910ea;_0x550764++){if(_0x1b049a[_0x550764]['SessionId']==_0x2f7db5[_0x3bbd81]['id']&&_0x234471[_0x3bea('0x58')](_0x1b049a[_0x550764][_0x3bea('0x63')])){_0x5d8a6e[_0x234471[_0x1b049a[_0x550764]['questionId']]]=_0x1b049a[_0x550764]['answer'];}}for(var _0x3ebae1 in _0x234471){if(!_0x5d8a6e[_0x3bea('0x58')](_0x234471[_0x3ebae1])){_0x5d8a6e[_0x234471[_0x3ebae1]]=null;}}_0x460a5b[_0x3bea('0x68')](_0x5d8a6e);}return _0x460a5b;}})['then'](function(_0x3f6ad9){if(!_[_0x3bea('0x69')](_0x3f6ad9)){var _0x44226f=toCsv(_0x3f6ad9);var _0x1a30b6=Date[_0x3bea('0x6a')]();fs['writeFileSync'](util[_0x3bea('0x66')](_0x3bea('0x6b'),_0x1144be[_0x3bea('0x43')]['id'],_0x1a30b6),_0x44226f);_0x152fda[_0x3bea('0x6c')](_0x3bea('0x6d'),'attachment;\x20filename='+util[_0x3bea('0x66')](_0x3bea('0x6e'),_0x1144be[_0x3bea('0x43')]['id'],_0x1a30b6));_0x152fda[_0x3bea('0x6c')](_0x3bea('0x6f'),_0x3bea('0x70'));return _0x152fda[_0x3bea('0x71')](util[_0x3bea('0x66')](_0x3bea('0x6b'),_0x1144be[_0x3bea('0x43')]['id'],_0x1a30b6));}else{return _0x152fda[_0x3bea('0x72')](0xcc);}})[_0x3bea('0x41')](handleError(_0x152fda,null));};
\ No newline at end of file
+var _0x91c4=['JscriptyAnswerReport','number','fromCharCode','toString','indexOf','replace','getSummary','startTime','starttime','parse','JscriptyQuestionReport','-createdAt','questionId','question','YYYY-MM-DD\x20HH:mm:ss','SessionId','answer','push','isEmpty','now','writeFileSync','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','Content-disposition','Content-type','text/csv','download','format','html-pdf','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','lodash','squel','jsforce','desk.js','querystring','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','count','offset','limit','set','Content-Range','json','apply','reject','save','update','then','Projects','UserProfileResource','destroy','error','name','send','index','JscriptyProject','rawAttributes','fieldName','key','model','map','keys','query','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','merge','type','include','findAll','rows','show','params','includeAll','options','find','catch','create','body','user','role','get','UserProfileSection','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','updatedAt','Unable\x20to\x20retrieve\x20the\x20current\x20user','autoAssociation','getSessions','findOne','JscriptySessionReport'];(function(_0x15bcce,_0x237a80){var _0x242d2e=function(_0x14bd98){while(--_0x14bd98){_0x15bcce['push'](_0x15bcce['shift']());}};_0x242d2e(++_0x237a80);}(_0x91c4,0x96));var _0x491c=function(_0x350a33,_0x7fe9be){_0x350a33=_0x350a33-0x0;var _0x22dc3e=_0x91c4[_0x350a33];return _0x22dc3e;};'use strict';var pdf=require(_0x491c('0x0'));var emlformat=require('eml-format');var rimraf=require(_0x491c('0x1'));var zipdir=require(_0x491c('0x2'));var jsonpatch=require(_0x491c('0x3'));var rp=require(_0x491c('0x4'));var moment=require(_0x491c('0x5'));var BPromise=require(_0x491c('0x6'));var Mustache=require(_0x491c('0x7'));var util=require(_0x491c('0x8'));var path=require('path');var sox=require(_0x491c('0x9'));var csv=require(_0x491c('0xa'));var ejs=require(_0x491c('0xb'));var fs=require('fs');var _=require(_0x491c('0xc'));var squel=require(_0x491c('0xd'));var crypto=require('crypto');var jsforce=require(_0x491c('0xe'));var deskjs=require(_0x491c('0xf'));var toCsv=require(_0x491c('0xa'));var querystring=require(_0x491c('0x10'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x491c('0x11'));var qs=require(_0x491c('0x12'));var as=require(_0x491c('0x13'));var hardwareService=require(_0x491c('0x14'));var logger=require(_0x491c('0x15'))('api');var utils=require(_0x491c('0x16'));var config=require(_0x491c('0x17'));var db=require(_0x491c('0x18'))['db'];function respondWithStatusCode(_0x17a72b,_0x325588){_0x325588=_0x325588||0xcc;return function(_0x4f03ff){if(_0x4f03ff){return _0x17a72b[_0x491c('0x19')](_0x325588);}return _0x17a72b[_0x491c('0x1a')](_0x325588)[_0x491c('0x1b')]();};}function respondWithResult(_0x216ee7,_0x41624b){_0x41624b=_0x41624b||0xc8;return function(_0x437916){if(_0x437916){return _0x216ee7[_0x491c('0x1a')](_0x41624b)['json'](_0x437916);}};}function respondWithFilteredResult(_0x50741a,_0x14620f){return function(_0x53583a){if(_0x53583a){var _0x420dcd=_0x53583a[_0x491c('0x1c')],_0x4fa721=_0x14620f['offset'],_0x239786=_0x14620f[_0x491c('0x1d')]+_0x14620f[_0x491c('0x1e')],_0x24c125;if(_0x239786>=_0x420dcd){_0x239786=_0x420dcd;_0x24c125=0xc8;}else{_0x24c125=0xce;}_0x50741a[_0x491c('0x1a')](_0x24c125);return _0x50741a[_0x491c('0x1f')](_0x491c('0x20'),_0x4fa721+'-'+_0x239786+'/'+_0x420dcd)[_0x491c('0x21')](_0x53583a);}return null;};}function patchUpdates(_0x415715){return function(_0x148043){try{jsonpatch[_0x491c('0x22')](_0x148043,_0x415715,!![]);}catch(_0x16e5ca){return BPromise[_0x491c('0x23')](_0x16e5ca);}return _0x148043[_0x491c('0x24')]();};}function saveUpdates(_0x2388ef,_0x58541b){return function(_0x1a937f){if(_0x1a937f){return _0x1a937f[_0x491c('0x25')](_0x2388ef)['then'](function(_0x500708){return _0x500708;});}return null;};}function removeEntity(_0x510d03,_0x5ae7ae){return function(_0x4b50a7){if(_0x4b50a7){return _0x4b50a7['destroy']()[_0x491c('0x26')](function(){var _0x2faaa4=_0x4b50a7['get']({'plain':!![]});var _0x1b4bf0=_0x491c('0x27');return db[_0x491c('0x28')][_0x491c('0x29')]({'where':{'type':_0x1b4bf0,'resourceId':_0x2faaa4['id']}})[_0x491c('0x26')](function(){return _0x4b50a7;});})['then'](function(){_0x510d03['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x3668c0,_0xdaf517){return function(_0x5c26df){if(!_0x5c26df){_0x3668c0['sendStatus'](0x194);}return _0x5c26df;};}function handleError(_0x52b759,_0x32fcdd){_0x32fcdd=_0x32fcdd||0x1f4;return function(_0xeb3d82){logger[_0x491c('0x2a')](_0xeb3d82['stack']);if(_0xeb3d82[_0x491c('0x2b')]){delete _0xeb3d82['name'];}_0x52b759['status'](_0x32fcdd)[_0x491c('0x2c')](_0xeb3d82);};}exports[_0x491c('0x2d')]=function(_0x198be4,_0x33e283){var _0x42aa7b={},_0x4e9508={},_0x199fcb={'count':0x0,'rows':[]};var _0x18bb18=_['map'](db[_0x491c('0x2e')][_0x491c('0x2f')],function(_0x2a643f){return{'name':_0x2a643f[_0x491c('0x30')],'type':_0x2a643f['type'][_0x491c('0x31')]};});_0x4e9508[_0x491c('0x32')]=_[_0x491c('0x33')](_0x18bb18,'name');_0x4e9508['query']=_[_0x491c('0x34')](_0x198be4[_0x491c('0x35')]);_0x4e9508['filters']=_[_0x491c('0x36')](_0x4e9508['model'],_0x4e9508[_0x491c('0x35')]);_0x42aa7b[_0x491c('0x37')]=_[_0x491c('0x36')](_0x4e9508[_0x491c('0x32')],qs['fields'](_0x198be4[_0x491c('0x35')][_0x491c('0x38')]));_0x42aa7b[_0x491c('0x37')]=_0x42aa7b[_0x491c('0x37')][_0x491c('0x39')]?_0x42aa7b['attributes']:_0x4e9508[_0x491c('0x32')];if(!_0x198be4[_0x491c('0x35')][_0x491c('0x3a')](_0x491c('0x3b'))){_0x42aa7b[_0x491c('0x1e')]=qs[_0x491c('0x1e')](_0x198be4[_0x491c('0x35')][_0x491c('0x1e')]);_0x42aa7b['offset']=qs[_0x491c('0x1d')](_0x198be4[_0x491c('0x35')][_0x491c('0x1d')]);}_0x42aa7b[_0x491c('0x3c')]=qs['sort'](_0x198be4[_0x491c('0x35')][_0x491c('0x3d')]);_0x42aa7b[_0x491c('0x3e')]=qs[_0x491c('0x3f')](_[_0x491c('0x40')](_0x198be4[_0x491c('0x35')],_0x4e9508['filters']),_0x18bb18);if(_0x198be4[_0x491c('0x35')][_0x491c('0x41')]){_0x42aa7b[_0x491c('0x3e')]=_[_0x491c('0x42')](_0x42aa7b[_0x491c('0x3e')],{'$or':_[_0x491c('0x33')](_0x18bb18,function(_0xb87e54){if(_0xb87e54[_0x491c('0x43')]!=='VIRTUAL'){var _0x560f5d={};_0x560f5d[_0xb87e54[_0x491c('0x2b')]]={'$like':'%'+_0x198be4[_0x491c('0x35')][_0x491c('0x41')]+'%'};return _0x560f5d;}})});}_0x42aa7b=_[_0x491c('0x42')]({},_0x42aa7b,_0x198be4['options']);var _0x4913a3={'where':_0x42aa7b[_0x491c('0x3e')]};return db[_0x491c('0x2e')]['count'](_0x4913a3)[_0x491c('0x26')](function(_0x4b521d){_0x199fcb[_0x491c('0x1c')]=_0x4b521d;if(_0x198be4[_0x491c('0x35')]['includeAll']){_0x42aa7b[_0x491c('0x44')]=[{'all':!![]}];}return db['JscriptyProject'][_0x491c('0x45')](_0x42aa7b);})[_0x491c('0x26')](function(_0x2e2490){_0x199fcb[_0x491c('0x46')]=_0x2e2490;return _0x199fcb;})['then'](respondWithFilteredResult(_0x33e283,_0x42aa7b))['catch'](handleError(_0x33e283,null));};exports[_0x491c('0x47')]=function(_0x1844e2,_0x51683b){var _0x1c4b9e={'raw':![],'where':{'id':_0x1844e2[_0x491c('0x48')]['id']}},_0x3c3335={};_0x3c3335[_0x491c('0x32')]=_[_0x491c('0x34')](db[_0x491c('0x2e')][_0x491c('0x2f')]);_0x3c3335['query']=_[_0x491c('0x34')](_0x1844e2[_0x491c('0x35')]);_0x3c3335['filters']=_['intersection'](_0x3c3335[_0x491c('0x32')],_0x3c3335[_0x491c('0x35')]);_0x1c4b9e['attributes']=_['intersection'](_0x3c3335[_0x491c('0x32')],qs[_0x491c('0x38')](_0x1844e2[_0x491c('0x35')][_0x491c('0x38')]));_0x1c4b9e[_0x491c('0x37')]=_0x1c4b9e[_0x491c('0x37')][_0x491c('0x39')]?_0x1c4b9e[_0x491c('0x37')]:_0x3c3335[_0x491c('0x32')];if(_0x1844e2[_0x491c('0x35')][_0x491c('0x49')]){_0x1c4b9e[_0x491c('0x44')]=[{'all':!![]}];}_0x1c4b9e=_['merge']({},_0x1c4b9e,_0x1844e2[_0x491c('0x4a')]);return db[_0x491c('0x2e')][_0x491c('0x4b')](_0x1c4b9e)[_0x491c('0x26')](handleEntityNotFound(_0x51683b,null))[_0x491c('0x26')](respondWithResult(_0x51683b,null))[_0x491c('0x4c')](handleError(_0x51683b,null));};exports[_0x491c('0x4d')]=function(_0x219d5a,_0xff5aa){return db[_0x491c('0x2e')]['create'](_0x219d5a[_0x491c('0x4e')],{})[_0x491c('0x26')](function(_0x39da5c){var _0x1bd77f=_0x219d5a[_0x491c('0x4f')]['get']({'plain':!![]});if(!_0x1bd77f)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x1bd77f[_0x491c('0x50')]===_0x491c('0x4f')){var _0x423cb6=_0x39da5c[_0x491c('0x51')]({'plain':!![]});var _0x6434b8=_0x491c('0x27');return db[_0x491c('0x52')][_0x491c('0x4b')]({'where':{'name':_0x6434b8,'userProfileId':_0x1bd77f[_0x491c('0x53')]},'raw':!![]})[_0x491c('0x26')](function(_0x51062f){if(_0x51062f&&_0x51062f['autoAssociation']===0x0){return db['UserProfileResource'][_0x491c('0x4d')]({'name':_0x423cb6[_0x491c('0x2b')],'resourceId':_0x423cb6['id'],'type':_0x51062f[_0x491c('0x2b')],'sectionId':_0x51062f['id']},{})['then'](function(){return _0x39da5c;});}else{return _0x39da5c;}})['catch'](function(_0x4ed3d4){logger[_0x491c('0x2a')](_0x491c('0x54'),_0x4ed3d4);throw _0x4ed3d4;});}return _0x39da5c;})[_0x491c('0x26')](respondWithResult(_0xff5aa,0xc9))[_0x491c('0x4c')](handleError(_0xff5aa,null));};exports[_0x491c('0x55')]=function(_0x56ed7c,_0x26604b){var _0x258b03={'where':{'id':_0x56ed7c[_0x491c('0x48')]['id']}},_0x144ac0={};_0x144ac0[_0x491c('0x32')]=_[_0x491c('0x34')](db[_0x491c('0x2e')][_0x491c('0x2f')]);_0x258b03[_0x491c('0x37')]=_['intersection'](_0x144ac0['model'],qs[_0x491c('0x38')](_0x56ed7c[_0x491c('0x35')]['fields']));_0x258b03[_0x491c('0x37')]=_0x258b03[_0x491c('0x37')][_0x491c('0x39')]?_0x258b03['attributes']:_0x144ac0[_0x491c('0x32')];if(_0x56ed7c[_0x491c('0x35')][_0x491c('0x49')]){_0x258b03[_0x491c('0x44')]=[{'all':!![]}];}_0x258b03=_['merge']({},_0x258b03,_0x56ed7c[_0x491c('0x4a')]);return db[_0x491c('0x2e')][_0x491c('0x4b')](_0x258b03)[_0x491c('0x26')](handleEntityNotFound(_0x26604b,null))['then'](function(_0x1b5458){if(_0x1b5458){var _0x5464ed=_0x1b5458[_0x491c('0x51')]({'plain':!![]});_0x5464ed=qs[_0x491c('0x56')](_0x5464ed,['id',_0x491c('0x57'),_0x491c('0x58')]);_0x56ed7c['body']=_['omit'](_0x56ed7c[_0x491c('0x4e')],['id',_0x491c('0x57'),'updatedAt']);return db[_0x491c('0x2e')][_0x491c('0x4d')](_[_0x491c('0x42')](_0x5464ed,_0x56ed7c[_0x491c('0x4e')]),{'include':_0x56ed7c[_0x491c('0x35')][_0x491c('0x49')]?[{'all':!![]}]:undefined})[_0x491c('0x26')](function(_0x4d484d){var _0x2bd57b=_0x56ed7c['user'][_0x491c('0x51')]({'plain':!![]});if(!_0x2bd57b)throw new Error(_0x491c('0x59'));if(_0x2bd57b[_0x491c('0x50')]===_0x491c('0x4f')){var _0x107baf=_0x4d484d[_0x491c('0x51')]({'plain':!![]});var _0xd3dfe4=_0x491c('0x27');return db[_0x491c('0x52')][_0x491c('0x4b')]({'where':{'name':_0xd3dfe4,'userProfileId':_0x2bd57b[_0x491c('0x53')]},'raw':!![]})[_0x491c('0x26')](function(_0x436c6f){if(_0x436c6f&&_0x436c6f[_0x491c('0x5a')]===0x0){return db['UserProfileResource'][_0x491c('0x4d')]({'name':_0x107baf[_0x491c('0x2b')],'resourceId':_0x107baf['id'],'type':_0x436c6f[_0x491c('0x2b')],'sectionId':_0x436c6f['id']},{})[_0x491c('0x26')](function(){return _0x4d484d;});}else{return _0x4d484d;}})[_0x491c('0x4c')](function(_0x3334a9){logger['error'](_0x491c('0x54'),_0x3334a9);throw _0x3334a9;});}return _0x4d484d;});}})[_0x491c('0x26')](respondWithResult(_0x26604b,0xc9))['catch'](handleError(_0x26604b,null));};exports['update']=function(_0x2cd141,_0x3eb755){if(_0x2cd141['body']['id']){delete _0x2cd141[_0x491c('0x4e')]['id'];}return db[_0x491c('0x2e')]['find']({'where':{'id':_0x2cd141[_0x491c('0x48')]['id']}})[_0x491c('0x26')](handleEntityNotFound(_0x3eb755,null))[_0x491c('0x26')](saveUpdates(_0x2cd141[_0x491c('0x4e')],null))[_0x491c('0x26')](respondWithResult(_0x3eb755,null))[_0x491c('0x4c')](handleError(_0x3eb755,null));};exports['destroy']=function(_0x43f351,_0x23d9f6){return db[_0x491c('0x2e')][_0x491c('0x4b')]({'where':{'id':_0x43f351[_0x491c('0x48')]['id']}})[_0x491c('0x26')](handleEntityNotFound(_0x23d9f6,null))['then'](removeEntity(_0x23d9f6,null))['catch'](handleError(_0x23d9f6,null));};exports[_0x491c('0x5b')]=function(_0xb707c6,_0x3d9c04,_0x5c3840){var _0x24ea7a={'raw':!![],'where':{}};var _0xa0f8a={};var _0x3b40f8={'count':0x0,'rows':[]};return db['JscriptyProject'][_0x491c('0x5c')]({'where':{'id':_0xb707c6[_0x491c('0x48')]['id']}})[_0x491c('0x26')](handleEntityNotFound(_0x3d9c04,null))[_0x491c('0x26')](function(_0x18d4bb){if(_0x18d4bb){_0xa0f8a[_0x491c('0x32')]=_[_0x491c('0x34')](db['JscriptySessionReport'][_0x491c('0x2f')]);_0xa0f8a[_0x491c('0x35')]=_[_0x491c('0x34')](_0xb707c6[_0x491c('0x35')]);_0xa0f8a[_0x491c('0x3f')]=_[_0x491c('0x36')](_0xa0f8a[_0x491c('0x32')],_0xa0f8a[_0x491c('0x35')]);_0x24ea7a['attributes']=_['intersection'](_0xa0f8a[_0x491c('0x32')],qs['fields'](_0xb707c6[_0x491c('0x35')]['fields']));_0x24ea7a[_0x491c('0x37')]=_0x24ea7a[_0x491c('0x37')][_0x491c('0x39')]?_0x24ea7a[_0x491c('0x37')]:_0xa0f8a[_0x491c('0x32')];if(!_0xb707c6['query'][_0x491c('0x3a')](_0x491c('0x3b'))){_0x24ea7a[_0x491c('0x1e')]=qs[_0x491c('0x1e')](_0xb707c6['query'][_0x491c('0x1e')]);_0x24ea7a[_0x491c('0x1d')]=qs['offset'](_0xb707c6[_0x491c('0x35')]['offset']);}_0x24ea7a['order']=qs[_0x491c('0x3d')](_0xb707c6['query'][_0x491c('0x3d')]);_0x24ea7a['where']=qs[_0x491c('0x3f')](_[_0x491c('0x40')](_0xb707c6[_0x491c('0x35')],_0xa0f8a[_0x491c('0x3f')]));_0x24ea7a[_0x491c('0x3e')]['ProjectId']=_0x18d4bb['id'];if(_0xb707c6[_0x491c('0x35')][_0x491c('0x41')]){_0x24ea7a['where']=_[_0x491c('0x42')](_0x24ea7a[_0x491c('0x3e')],{'$or':_[_0x491c('0x33')](_0x24ea7a['attributes'],function(_0xdd594f){var _0x1bc552={};_0x1bc552[_0xdd594f]={'$like':'%'+_0xb707c6[_0x491c('0x35')][_0x491c('0x41')]+'%'};return _0x1bc552;})});}_0x24ea7a=_[_0x491c('0x42')]({},_0x24ea7a,_0xb707c6[_0x491c('0x4a')]);return db['JscriptySessionReport'][_0x491c('0x1c')]({'where':_0x24ea7a[_0x491c('0x3e')]})[_0x491c('0x26')](function(_0x58d450){_0x3b40f8[_0x491c('0x1c')]=_0x58d450;if(_0xb707c6[_0x491c('0x35')][_0x491c('0x49')]){_0x24ea7a[_0x491c('0x44')]=[{'all':!![]}];}return db[_0x491c('0x5d')][_0x491c('0x45')](_0x24ea7a);})[_0x491c('0x26')](function(_0xba7b81){_0x3b40f8[_0x491c('0x46')]=_0xba7b81;return _0x3b40f8;});}})[_0x491c('0x26')](respondWithFilteredResult(_0x3d9c04,_0x24ea7a))[_0x491c('0x4c')](handleError(_0x3d9c04,null));};exports['getAnswers']=function(_0x7c35a,_0x46d01d,_0x36657f){var _0x15ea98={'raw':!![],'where':{}};var _0x5bd043={};var _0x39aa70={'count':0x0,'rows':[]};return db[_0x491c('0x2e')][_0x491c('0x5c')]({'where':{'id':_0x7c35a[_0x491c('0x48')]['id']}})[_0x491c('0x26')](handleEntityNotFound(_0x46d01d,null))[_0x491c('0x26')](function(_0x5aaccd){if(_0x5aaccd){_0x5bd043[_0x491c('0x32')]=_[_0x491c('0x34')](db[_0x491c('0x5e')][_0x491c('0x2f')]);_0x5bd043[_0x491c('0x35')]=_[_0x491c('0x34')](_0x7c35a[_0x491c('0x35')]);_0x5bd043[_0x491c('0x3f')]=_[_0x491c('0x36')](_0x5bd043[_0x491c('0x32')],_0x5bd043[_0x491c('0x35')]);_0x15ea98[_0x491c('0x37')]=_['intersection'](_0x5bd043[_0x491c('0x32')],qs[_0x491c('0x38')](_0x7c35a[_0x491c('0x35')]['fields']));_0x15ea98['attributes']=_0x15ea98[_0x491c('0x37')][_0x491c('0x39')]?_0x15ea98['attributes']:_0x5bd043[_0x491c('0x32')];if(!_0x7c35a[_0x491c('0x35')][_0x491c('0x3a')](_0x491c('0x3b'))){_0x15ea98['limit']=qs[_0x491c('0x1e')](_0x7c35a['query'][_0x491c('0x1e')]);_0x15ea98[_0x491c('0x1d')]=qs[_0x491c('0x1d')](_0x7c35a[_0x491c('0x35')]['offset']);}_0x15ea98[_0x491c('0x3c')]=qs[_0x491c('0x3d')](_0x7c35a['query']['sort']);_0x15ea98[_0x491c('0x3e')]=qs[_0x491c('0x3f')](_['pick'](_0x7c35a['query'],_0x5bd043[_0x491c('0x3f')]));_0x15ea98[_0x491c('0x3e')]['ProjectId']=_0x5aaccd['id'];if(_0x7c35a['query'][_0x491c('0x41')]){_0x15ea98[_0x491c('0x3e')]=_[_0x491c('0x42')](_0x15ea98[_0x491c('0x3e')],{'$or':_[_0x491c('0x33')](_0x15ea98['attributes'],function(_0x409738){var _0x4433e6={};_0x4433e6[_0x409738]={'$like':'%'+_0x7c35a['query'][_0x491c('0x41')]+'%'};return _0x4433e6;})});}_0x15ea98=_['merge']({},_0x15ea98,_0x7c35a[_0x491c('0x4a')]);return db[_0x491c('0x5e')][_0x491c('0x1c')]({'where':_0x15ea98[_0x491c('0x3e')]})[_0x491c('0x26')](function(_0x42d6ce){_0x39aa70['count']=_0x42d6ce;if(_0x7c35a[_0x491c('0x35')][_0x491c('0x49')]){_0x15ea98[_0x491c('0x44')]=[{'all':!![]}];}return db[_0x491c('0x5e')]['findAll'](_0x15ea98);})[_0x491c('0x26')](function(_0x69e1d9){_0x39aa70[_0x491c('0x46')]=_0x69e1d9;return _0x39aa70;});}})[_0x491c('0x26')](respondWithFilteredResult(_0x46d01d,_0x15ea98))['catch'](handleError(_0x46d01d,null));};function char(_0x4947f6){return _0x491c('0x5f')===typeof _0x4947f6?String[_0x491c('0x60')][_0x491c('0x22')](null,arguments):_0x4947f6;}function needsEncapsulation(_0x29ab3d){return!!_0x29ab3d&&(_0x29ab3d[_0x491c('0x61')]()[_0x491c('0x62')](char(0xd))>=0x0||_0x29ab3d['toString']()[_0x491c('0x62')](char(0xa))>=0x0||_0x29ab3d[_0x491c('0x61')]()['indexOf'](char(0x2c))>=0x0||_0x29ab3d[_0x491c('0x61')]()[_0x491c('0x62')](char(0x22))>=0x0);}function encapsulate(_0x407049){var _0x2b0587=char(0x22),_0x1ea375='\x5c'+char(0x22),_0x2b882c=_0x407049[_0x491c('0x61')]()[_0x491c('0x63')](new RegExp(_0x2b0587,'g'),_0x1ea375);return _0x2b0587+_0x2b882c+_0x2b0587;}exports[_0x491c('0x64')]=function(_0x59a7c7,_0x9ff94b,_0x175a8f){var _0x41ea0d,_0x360ff7;var _0x461a92={'where':{'ProjectId':_0x59a7c7[_0x491c('0x48')]['id']}};if(_0x59a7c7[_0x491c('0x35')][_0x491c('0x65')]){_0x461a92[_0x491c('0x3e')][_0x491c('0x66')]=JSON[_0x491c('0x67')](_0x59a7c7[_0x491c('0x35')]['startTime']);}return db['JscriptySessionReport']['findAll'](_0x461a92)[_0x491c('0x26')](handleEntityNotFound(_0x9ff94b,null))[_0x491c('0x26')](function(_0x38541b){if(_0x38541b){_0x41ea0d=_0x38541b;return db[_0x491c('0x68')][_0x491c('0x45')]({'where':{'SessionId':{'$in':_[_0x491c('0x33')](_0x41ea0d,'id')},'ProjectId':_0x59a7c7['params']['id']},'order':_0x491c('0x69')});}})[_0x491c('0x26')](handleEntityNotFound(_0x9ff94b,null))['then'](function(_0x5d3ea9){if(_0x5d3ea9){_0x360ff7=_0x5d3ea9;var _0x308fe1={};for(var _0x1140c2=0x0,_0x389f19=_0x360ff7[_0x491c('0x39')];_0x1140c2<_0x389f19;_0x1140c2++){if(!_0x308fe1['hasOwnProperty'](_0x360ff7[_0x1140c2][_0x491c('0x6a')])){_0x308fe1[_0x360ff7[_0x1140c2][_0x491c('0x6a')]]=needsEncapsulation(_0x360ff7[_0x1140c2][_0x491c('0x6b')])?encapsulate(_0x360ff7[_0x1140c2][_0x491c('0x6b')]):_0x360ff7[_0x1140c2][_0x491c('0x6b')];}}var _0x425947=[],_0x9cb878={};for(var _0x42e909=0x0,_0x2dbef4=_0x41ea0d['length'];_0x42e909<_0x2dbef4;_0x42e909++){_0x9cb878={'ProjectId':_0x59a7c7[_0x491c('0x48')]['id'],'SessionId':_0x41ea0d[_0x42e909]['id'],'StartTime':moment(_0x41ea0d[_0x42e909][_0x491c('0x66')])['format'](_0x491c('0x6c'))};for(var _0x755356=0x0,_0x48b2fe=_0x360ff7[_0x491c('0x39')];_0x755356<_0x48b2fe;_0x755356++){if(_0x360ff7[_0x755356][_0x491c('0x6d')]==_0x41ea0d[_0x42e909]['id']&&_0x308fe1[_0x491c('0x3a')](_0x360ff7[_0x755356][_0x491c('0x6a')])){_0x9cb878[_0x308fe1[_0x360ff7[_0x755356][_0x491c('0x6a')]]]=_0x360ff7[_0x755356][_0x491c('0x6e')];}}for(var _0x3579ae in _0x308fe1){if(!_0x9cb878[_0x491c('0x3a')](_0x308fe1[_0x3579ae])){_0x9cb878[_0x308fe1[_0x3579ae]]=null;}}_0x425947[_0x491c('0x6f')](_0x9cb878);}return _0x425947;}})['then'](function(_0x2c4ee0){if(!_[_0x491c('0x70')](_0x2c4ee0)){var _0x1a8860=toCsv(_0x2c4ee0);var _0x10d31e=Date[_0x491c('0x71')]();fs[_0x491c('0x72')](util['format'](_0x491c('0x73'),_0x59a7c7[_0x491c('0x48')]['id'],_0x10d31e),_0x1a8860);_0x9ff94b[_0x491c('0x74')](_0x491c('0x75'),'attachment;\x20filename='+util['format']('Jscripty_Project_%d_Summary_%s.csv',_0x59a7c7[_0x491c('0x48')]['id'],_0x10d31e));_0x9ff94b['setHeader'](_0x491c('0x76'),_0x491c('0x77'));return _0x9ff94b[_0x491c('0x78')](util[_0x491c('0x79')](_0x491c('0x73'),_0x59a7c7[_0x491c('0x48')]['id'],_0x10d31e));}else{return _0x9ff94b[_0x491c('0x19')](0xcc);}})['catch'](handleError(_0x9ff94b,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff