// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x6200=['map','JscriptyProject','rawAttributes','fieldName','key','keys','query','filters','intersection','attributes','model','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','type','VIRTUAL','options','includeAll','include','findAll','show','find','create','body','role','user','Projects','UserProfileSection','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','catch','clone','params','omit','updatedAt','createdAt','Unable\x20to\x20retrieve\x20the\x20current\x20user','findOne','JscriptySessionReport','ProjectId','rows','getAnswers','JscriptyAnswerReport','fromCharCode','toString','indexOf','replace','getSummary','startTime','starttime','questionId','question','format','SessionId','answer','writeFileSync','setHeader','Content-disposition','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','text/csv','download','eml-format','rimraf','fast-json-patch','moment','bluebird','mustache','util','path','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','sendStatus','status','end','json','offset','undefined','count','limit','apply','reject','update','then','destroy','get','UserProfileResource','error','stack','name','index'];(function(_0xcd38d3,_0x3731b4){var _0x42d5b1=function(_0x480260){while(--_0x480260){_0xcd38d3['push'](_0xcd38d3['shift']());}};_0x42d5b1(++_0x3731b4);}(_0x6200,0x192));var _0x0620=function(_0x1c727d,_0x196fa9){_0x1c727d=_0x1c727d-0x0;var _0x39bf0e=_0x6200[_0x1c727d];return _0x39bf0e;};'use strict';var emlformat=require(_0x0620('0x0'));var rimraf=require(_0x0620('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x0620('0x2'));var rp=require('request-promise');var moment=require(_0x0620('0x3'));var BPromise=require(_0x0620('0x4'));var Mustache=require(_0x0620('0x5'));var util=require(_0x0620('0x6'));var path=require(_0x0620('0x7'));var sox=require('sox');var csv=require(_0x0620('0x8'));var ejs=require(_0x0620('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x0620('0xa'));var squel=require(_0x0620('0xb'));var crypto=require(_0x0620('0xc'));var jsforce=require(_0x0620('0xd'));var deskjs=require(_0x0620('0xe'));var toCsv=require(_0x0620('0x8'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0x0620('0xf'));var authService=require(_0x0620('0x10'));var qs=require(_0x0620('0x11'));var as=require(_0x0620('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x0620('0x13'))('api');var utils=require(_0x0620('0x14'));var config=require(_0x0620('0x15'));var licenseUtil=require(_0x0620('0x16'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x558eab,_0x42659a){_0x42659a=_0x42659a||0xcc;return function(_0x1b6eac){if(_0x1b6eac){return _0x558eab[_0x0620('0x17')](_0x42659a);}return _0x558eab[_0x0620('0x18')](_0x42659a)[_0x0620('0x19')]();};}function respondWithResult(_0xd2af42,_0x3e5155){_0x3e5155=_0x3e5155||0xc8;return function(_0x18e5c0){if(_0x18e5c0){return _0xd2af42[_0x0620('0x18')](_0x3e5155)[_0x0620('0x1a')](_0x18e5c0);}};}function respondWithFilteredResult(_0x19a09a,_0xb0c4c7){return function(_0x4c0e68){if(_0x4c0e68){var _0x1a57a2=typeof _0xb0c4c7[_0x0620('0x1b')]===_0x0620('0x1c')&&typeof _0xb0c4c7['limit']===_0x0620('0x1c');var _0x500bb5=_0x4c0e68['count'];var _0x5b2d81=_0x1a57a2?0x0:_0xb0c4c7[_0x0620('0x1b')];var _0x39a419=_0x1a57a2?_0x4c0e68[_0x0620('0x1d')]:_0xb0c4c7[_0x0620('0x1b')]+_0xb0c4c7[_0x0620('0x1e')];var _0x1add9d;if(_0x39a419>=_0x500bb5){_0x39a419=_0x500bb5;_0x1add9d=0xc8;}else{_0x1add9d=0xce;}_0x19a09a[_0x0620('0x18')](_0x1add9d);return _0x19a09a['set']('Content-Range',_0x5b2d81+'-'+_0x39a419+'/'+_0x500bb5)[_0x0620('0x1a')](_0x4c0e68);}return null;};}function patchUpdates(_0x312b82){return function(_0x3f0a80){try{jsonpatch[_0x0620('0x1f')](_0x3f0a80,_0x312b82,!![]);}catch(_0x597887){return BPromise[_0x0620('0x20')](_0x597887);}return _0x3f0a80['save']();};}function saveUpdates(_0x5c2b1e,_0x5d4ef1){return function(_0x546172){if(_0x546172){return _0x546172[_0x0620('0x21')](_0x5c2b1e)[_0x0620('0x22')](function(_0xce050c){return _0xce050c;});}return null;};}function removeEntity(_0x54c8e4,_0x4965ae){return function(_0x4e59c6){if(_0x4e59c6){return _0x4e59c6[_0x0620('0x23')]()['then'](function(){var _0x4bbdc0=_0x4e59c6[_0x0620('0x24')]({'plain':!![]});var _0x397295='Projects';return db[_0x0620('0x25')][_0x0620('0x23')]({'where':{'type':_0x397295,'resourceId':_0x4bbdc0['id']}})[_0x0620('0x22')](function(){return _0x4e59c6;});})[_0x0620('0x22')](function(){_0x54c8e4[_0x0620('0x18')](0xcc)[_0x0620('0x19')]();});}};}function handleEntityNotFound(_0x4502e7,_0x554cee){return function(_0x2e7ea7){if(!_0x2e7ea7){_0x4502e7[_0x0620('0x17')](0x194);}return _0x2e7ea7;};}function handleError(_0x2ba47e,_0x59629e){_0x59629e=_0x59629e||0x1f4;return function(_0x9500ab){logger[_0x0620('0x26')](_0x9500ab[_0x0620('0x27')]);if(_0x9500ab[_0x0620('0x28')]){delete _0x9500ab[_0x0620('0x28')];}_0x2ba47e['status'](_0x59629e)['send'](_0x9500ab);};}exports[_0x0620('0x29')]=function(_0x8fa158,_0x40c5e5){var _0x57901b={},_0x1e4d0b={},_0x597df5={'count':0x0,'rows':[]};var _0x14c951=_[_0x0620('0x2a')](db[_0x0620('0x2b')][_0x0620('0x2c')],function(_0x471a45){return{'name':_0x471a45[_0x0620('0x2d')],'type':_0x471a45['type'][_0x0620('0x2e')]};});_0x1e4d0b['model']=_[_0x0620('0x2a')](_0x14c951,_0x0620('0x28'));_0x1e4d0b['query']=_[_0x0620('0x2f')](_0x8fa158[_0x0620('0x30')]);_0x1e4d0b[_0x0620('0x31')]=_[_0x0620('0x32')](_0x1e4d0b['model'],_0x1e4d0b[_0x0620('0x30')]);_0x57901b[_0x0620('0x33')]=_['intersection'](_0x1e4d0b[_0x0620('0x34')],qs[_0x0620('0x35')](_0x8fa158[_0x0620('0x30')][_0x0620('0x35')]));_0x57901b[_0x0620('0x33')]=_0x57901b[_0x0620('0x33')][_0x0620('0x36')]?_0x57901b[_0x0620('0x33')]:_0x1e4d0b[_0x0620('0x34')];if(!_0x8fa158['query'][_0x0620('0x37')](_0x0620('0x38'))){_0x57901b[_0x0620('0x1e')]=qs[_0x0620('0x1e')](_0x8fa158[_0x0620('0x30')][_0x0620('0x1e')]);_0x57901b[_0x0620('0x1b')]=qs[_0x0620('0x1b')](_0x8fa158[_0x0620('0x30')][_0x0620('0x1b')]);}_0x57901b[_0x0620('0x39')]=qs[_0x0620('0x3a')](_0x8fa158[_0x0620('0x30')][_0x0620('0x3a')]);_0x57901b[_0x0620('0x3b')]=qs[_0x0620('0x31')](_[_0x0620('0x3c')](_0x8fa158[_0x0620('0x30')],_0x1e4d0b[_0x0620('0x31')]),_0x14c951);if(_0x8fa158['query'][_0x0620('0x3d')]){_0x57901b[_0x0620('0x3b')]=_[_0x0620('0x3e')](_0x57901b[_0x0620('0x3b')],{'$or':_[_0x0620('0x2a')](_0x14c951,function(_0x12b36c){if(_0x12b36c[_0x0620('0x3f')]!==_0x0620('0x40')){var _0xdb46e1={};_0xdb46e1[_0x12b36c[_0x0620('0x28')]]={'$like':'%'+_0x8fa158[_0x0620('0x30')]['filter']+'%'};return _0xdb46e1;}})});}_0x57901b=_['merge']({},_0x57901b,_0x8fa158[_0x0620('0x41')]);var _0x60eb58={'where':_0x57901b[_0x0620('0x3b')]};return db[_0x0620('0x2b')][_0x0620('0x1d')](_0x60eb58)['then'](function(_0x2c8f37){_0x597df5[_0x0620('0x1d')]=_0x2c8f37;if(_0x8fa158[_0x0620('0x30')][_0x0620('0x42')]){_0x57901b[_0x0620('0x43')]=[{'all':!![]}];}return db[_0x0620('0x2b')][_0x0620('0x44')](_0x57901b);})[_0x0620('0x22')](function(_0xf9e30d){_0x597df5['rows']=_0xf9e30d;return _0x597df5;})[_0x0620('0x22')](respondWithFilteredResult(_0x40c5e5,_0x57901b))['catch'](handleError(_0x40c5e5,null));};exports[_0x0620('0x45')]=function(_0x2285b6,_0x27861f){var _0x3bd1a3={'raw':![],'where':{'id':_0x2285b6['params']['id']}},_0x573281={};_0x573281[_0x0620('0x34')]=_[_0x0620('0x2f')](db[_0x0620('0x2b')][_0x0620('0x2c')]);_0x573281[_0x0620('0x30')]=_[_0x0620('0x2f')](_0x2285b6[_0x0620('0x30')]);_0x573281[_0x0620('0x31')]=_['intersection'](_0x573281[_0x0620('0x34')],_0x573281[_0x0620('0x30')]);_0x3bd1a3['attributes']=_[_0x0620('0x32')](_0x573281[_0x0620('0x34')],qs[_0x0620('0x35')](_0x2285b6[_0x0620('0x30')][_0x0620('0x35')]));_0x3bd1a3['attributes']=_0x3bd1a3[_0x0620('0x33')][_0x0620('0x36')]?_0x3bd1a3[_0x0620('0x33')]:_0x573281[_0x0620('0x34')];if(_0x2285b6[_0x0620('0x30')][_0x0620('0x42')]){_0x3bd1a3[_0x0620('0x43')]=[{'all':!![]}];}_0x3bd1a3=_[_0x0620('0x3e')]({},_0x3bd1a3,_0x2285b6[_0x0620('0x41')]);return db[_0x0620('0x2b')][_0x0620('0x46')](_0x3bd1a3)[_0x0620('0x22')](handleEntityNotFound(_0x27861f,null))[_0x0620('0x22')](respondWithResult(_0x27861f,null))['catch'](handleError(_0x27861f,null));};exports['create']=function(_0x1e3407,_0x563aa5){return db['JscriptyProject'][_0x0620('0x47')](_0x1e3407[_0x0620('0x48')],{})[_0x0620('0x22')](function(_0x1f9e01){var _0x8d4535=_0x1e3407['user'][_0x0620('0x24')]({'plain':!![]});if(!_0x8d4535)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x8d4535[_0x0620('0x49')]===_0x0620('0x4a')){var _0x4128a5=_0x1f9e01[_0x0620('0x24')]({'plain':!![]});var _0x4b278e=_0x0620('0x4b');return db[_0x0620('0x4c')][_0x0620('0x46')]({'where':{'name':_0x4b278e,'userProfileId':_0x8d4535[_0x0620('0x4d')]},'raw':!![]})[_0x0620('0x22')](function(_0x3e7562){if(_0x3e7562&&_0x3e7562['autoAssociation']===0x0){return db['UserProfileResource'][_0x0620('0x47')]({'name':_0x4128a5[_0x0620('0x28')],'resourceId':_0x4128a5['id'],'type':_0x3e7562['name'],'sectionId':_0x3e7562['id']},{})['then'](function(){return _0x1f9e01;});}else{return _0x1f9e01;}})['catch'](function(_0x21d59c){logger[_0x0620('0x26')](_0x0620('0x4e'),_0x21d59c);throw _0x21d59c;});}return _0x1f9e01;})[_0x0620('0x22')](respondWithResult(_0x563aa5,0xc9))[_0x0620('0x4f')](handleError(_0x563aa5,null));};exports[_0x0620('0x50')]=function(_0x2bfdec,_0x516b47){var _0x4ac25a={'where':{'id':_0x2bfdec[_0x0620('0x51')]['id']}},_0x36965f={};_0x36965f[_0x0620('0x34')]=_[_0x0620('0x2f')](db['JscriptyProject'][_0x0620('0x2c')]);_0x4ac25a[_0x0620('0x33')]=_['intersection'](_0x36965f[_0x0620('0x34')],qs[_0x0620('0x35')](_0x2bfdec['query'][_0x0620('0x35')]));_0x4ac25a[_0x0620('0x33')]=_0x4ac25a[_0x0620('0x33')]['length']?_0x4ac25a['attributes']:_0x36965f[_0x0620('0x34')];if(_0x2bfdec[_0x0620('0x30')][_0x0620('0x42')]){_0x4ac25a[_0x0620('0x43')]=[{'all':!![]}];}_0x4ac25a=_[_0x0620('0x3e')]({},_0x4ac25a,_0x2bfdec['options']);return db[_0x0620('0x2b')][_0x0620('0x46')](_0x4ac25a)[_0x0620('0x22')](handleEntityNotFound(_0x516b47,null))[_0x0620('0x22')](function(_0x333920){if(_0x333920){var _0x71f88=_0x333920['get']({'plain':!![]});_0x71f88=qs[_0x0620('0x52')](_0x71f88,['id','createdAt',_0x0620('0x53')]);_0x2bfdec[_0x0620('0x48')]=_[_0x0620('0x52')](_0x2bfdec[_0x0620('0x48')],['id',_0x0620('0x54'),_0x0620('0x53')]);return db[_0x0620('0x2b')]['create'](_[_0x0620('0x3e')](_0x71f88,_0x2bfdec[_0x0620('0x48')]),{'include':_0x2bfdec[_0x0620('0x30')][_0x0620('0x42')]?[{'all':!![]}]:undefined})[_0x0620('0x22')](function(_0x41fa17){var _0x673f3a=_0x2bfdec[_0x0620('0x4a')][_0x0620('0x24')]({'plain':!![]});if(!_0x673f3a)throw new Error(_0x0620('0x55'));if(_0x673f3a[_0x0620('0x49')]===_0x0620('0x4a')){var _0x360c55=_0x41fa17[_0x0620('0x24')]({'plain':!![]});var _0x12f06e=_0x0620('0x4b');return db[_0x0620('0x4c')]['find']({'where':{'name':_0x12f06e,'userProfileId':_0x673f3a['userProfileId']},'raw':!![]})[_0x0620('0x22')](function(_0x3fd1fa){if(_0x3fd1fa&&_0x3fd1fa['autoAssociation']===0x0){return db[_0x0620('0x25')][_0x0620('0x47')]({'name':_0x360c55['name'],'resourceId':_0x360c55['id'],'type':_0x3fd1fa[_0x0620('0x28')],'sectionId':_0x3fd1fa['id']},{})[_0x0620('0x22')](function(){return _0x41fa17;});}else{return _0x41fa17;}})[_0x0620('0x4f')](function(_0x236823){logger['error'](_0x0620('0x4e'),_0x236823);throw _0x236823;});}return _0x41fa17;});}})['then'](respondWithResult(_0x516b47,0xc9))[_0x0620('0x4f')](handleError(_0x516b47,null));};exports[_0x0620('0x21')]=function(_0x5e9c59,_0x14e7f0){if(_0x5e9c59[_0x0620('0x48')]['id']){delete _0x5e9c59['body']['id'];}return db[_0x0620('0x2b')][_0x0620('0x46')]({'where':{'id':_0x5e9c59[_0x0620('0x51')]['id']}})[_0x0620('0x22')](handleEntityNotFound(_0x14e7f0,null))[_0x0620('0x22')](saveUpdates(_0x5e9c59[_0x0620('0x48')],null))[_0x0620('0x22')](respondWithResult(_0x14e7f0,null))[_0x0620('0x4f')](handleError(_0x14e7f0,null));};exports[_0x0620('0x23')]=function(_0xf9b621,_0x424f11){return db[_0x0620('0x2b')][_0x0620('0x46')]({'where':{'id':_0xf9b621[_0x0620('0x51')]['id']}})[_0x0620('0x22')](handleEntityNotFound(_0x424f11,null))[_0x0620('0x22')](removeEntity(_0x424f11,null))['catch'](handleError(_0x424f11,null));};exports['getSessions']=function(_0x4a45a3,_0x1b3c37,_0x4d090c){var _0x4a0434={'raw':!![],'where':{}};var _0x55d8fc={};var _0x498d9b={'count':0x0,'rows':[]};return db['JscriptyProject'][_0x0620('0x56')]({'where':{'id':_0x4a45a3[_0x0620('0x51')]['id']}})[_0x0620('0x22')](handleEntityNotFound(_0x1b3c37,null))[_0x0620('0x22')](function(_0x5170f8){if(_0x5170f8){_0x55d8fc[_0x0620('0x34')]=_[_0x0620('0x2f')](db[_0x0620('0x57')][_0x0620('0x2c')]);_0x55d8fc[_0x0620('0x30')]=_[_0x0620('0x2f')](_0x4a45a3[_0x0620('0x30')]);_0x55d8fc[_0x0620('0x31')]=_['intersection'](_0x55d8fc[_0x0620('0x34')],_0x55d8fc[_0x0620('0x30')]);_0x4a0434[_0x0620('0x33')]=_[_0x0620('0x32')](_0x55d8fc[_0x0620('0x34')],qs[_0x0620('0x35')](_0x4a45a3[_0x0620('0x30')][_0x0620('0x35')]));_0x4a0434[_0x0620('0x33')]=_0x4a0434[_0x0620('0x33')][_0x0620('0x36')]?_0x4a0434[_0x0620('0x33')]:_0x55d8fc[_0x0620('0x34')];if(!_0x4a45a3['query'][_0x0620('0x37')](_0x0620('0x38'))){_0x4a0434['limit']=qs['limit'](_0x4a45a3[_0x0620('0x30')]['limit']);_0x4a0434[_0x0620('0x1b')]=qs[_0x0620('0x1b')](_0x4a45a3[_0x0620('0x30')][_0x0620('0x1b')]);}_0x4a0434[_0x0620('0x39')]=qs[_0x0620('0x3a')](_0x4a45a3['query'][_0x0620('0x3a')]);_0x4a0434['where']=qs[_0x0620('0x31')](_[_0x0620('0x3c')](_0x4a45a3[_0x0620('0x30')],_0x55d8fc[_0x0620('0x31')]));_0x4a0434['where'][_0x0620('0x58')]=_0x5170f8['id'];if(_0x4a45a3[_0x0620('0x30')]['filter']){_0x4a0434[_0x0620('0x3b')]=_['merge'](_0x4a0434[_0x0620('0x3b')],{'$or':_[_0x0620('0x2a')](_0x4a0434[_0x0620('0x33')],function(_0x5426d9){var _0x324df1={};_0x324df1[_0x5426d9]={'$like':'%'+_0x4a45a3[_0x0620('0x30')][_0x0620('0x3d')]+'%'};return _0x324df1;})});}_0x4a0434=_[_0x0620('0x3e')]({},_0x4a0434,_0x4a45a3[_0x0620('0x41')]);return db[_0x0620('0x57')][_0x0620('0x1d')]({'where':_0x4a0434[_0x0620('0x3b')]})[_0x0620('0x22')](function(_0x3ce90c){_0x498d9b[_0x0620('0x1d')]=_0x3ce90c;if(_0x4a45a3[_0x0620('0x30')][_0x0620('0x42')]){_0x4a0434[_0x0620('0x43')]=[{'all':!![]}];}return db[_0x0620('0x57')][_0x0620('0x44')](_0x4a0434);})['then'](function(_0x5f4c18){_0x498d9b[_0x0620('0x59')]=_0x5f4c18;return _0x498d9b;});}})[_0x0620('0x22')](respondWithFilteredResult(_0x1b3c37,_0x4a0434))[_0x0620('0x4f')](handleError(_0x1b3c37,null));};exports[_0x0620('0x5a')]=function(_0x32446f,_0x3e58d5,_0x1f3b57){var _0x19bae1={'raw':!![],'where':{}};var _0x2f3846={};var _0x5ae547={'count':0x0,'rows':[]};return db[_0x0620('0x2b')][_0x0620('0x56')]({'where':{'id':_0x32446f[_0x0620('0x51')]['id']}})['then'](handleEntityNotFound(_0x3e58d5,null))['then'](function(_0xbb62ab){if(_0xbb62ab){_0x2f3846['model']=_['keys'](db[_0x0620('0x5b')][_0x0620('0x2c')]);_0x2f3846[_0x0620('0x30')]=_[_0x0620('0x2f')](_0x32446f[_0x0620('0x30')]);_0x2f3846[_0x0620('0x31')]=_[_0x0620('0x32')](_0x2f3846[_0x0620('0x34')],_0x2f3846[_0x0620('0x30')]);_0x19bae1['attributes']=_[_0x0620('0x32')](_0x2f3846[_0x0620('0x34')],qs['fields'](_0x32446f['query'][_0x0620('0x35')]));_0x19bae1[_0x0620('0x33')]=_0x19bae1['attributes'][_0x0620('0x36')]?_0x19bae1['attributes']:_0x2f3846[_0x0620('0x34')];if(!_0x32446f[_0x0620('0x30')][_0x0620('0x37')](_0x0620('0x38'))){_0x19bae1['limit']=qs['limit'](_0x32446f[_0x0620('0x30')][_0x0620('0x1e')]);_0x19bae1['offset']=qs[_0x0620('0x1b')](_0x32446f['query'][_0x0620('0x1b')]);}_0x19bae1[_0x0620('0x39')]=qs[_0x0620('0x3a')](_0x32446f[_0x0620('0x30')]['sort']);_0x19bae1['where']=qs['filters'](_['pick'](_0x32446f[_0x0620('0x30')],_0x2f3846['filters']));_0x19bae1[_0x0620('0x3b')]['ProjectId']=_0xbb62ab['id'];if(_0x32446f[_0x0620('0x30')][_0x0620('0x3d')]){_0x19bae1['where']=_['merge'](_0x19bae1[_0x0620('0x3b')],{'$or':_[_0x0620('0x2a')](_0x19bae1[_0x0620('0x33')],function(_0x3d654e){var _0x456c77={};_0x456c77[_0x3d654e]={'$like':'%'+_0x32446f[_0x0620('0x30')][_0x0620('0x3d')]+'%'};return _0x456c77;})});}_0x19bae1=_[_0x0620('0x3e')]({},_0x19bae1,_0x32446f['options']);return db['JscriptyAnswerReport'][_0x0620('0x1d')]({'where':_0x19bae1[_0x0620('0x3b')]})[_0x0620('0x22')](function(_0x3c0fcf){_0x5ae547[_0x0620('0x1d')]=_0x3c0fcf;if(_0x32446f[_0x0620('0x30')][_0x0620('0x42')]){_0x19bae1[_0x0620('0x43')]=[{'all':!![]}];}return db['JscriptyAnswerReport'][_0x0620('0x44')](_0x19bae1);})[_0x0620('0x22')](function(_0x1dfe93){_0x5ae547['rows']=_0x1dfe93;return _0x5ae547;});}})[_0x0620('0x22')](respondWithFilteredResult(_0x3e58d5,_0x19bae1))[_0x0620('0x4f')](handleError(_0x3e58d5,null));};function char(_0x20bbd2){return'number'===typeof _0x20bbd2?String[_0x0620('0x5c')]['apply'](null,arguments):_0x20bbd2;}function needsEncapsulation(_0x11810c){return!!_0x11810c&&(_0x11810c[_0x0620('0x5d')]()['indexOf'](char(0xd))>=0x0||_0x11810c[_0x0620('0x5d')]()['indexOf'](char(0xa))>=0x0||_0x11810c[_0x0620('0x5d')]()[_0x0620('0x5e')](char(0x2c))>=0x0||_0x11810c[_0x0620('0x5d')]()[_0x0620('0x5e')](char(0x22))>=0x0);}function encapsulate(_0x37f556){var _0x572afd=char(0x22),_0x5d25bc='\x5c'+char(0x22),_0x3621a5=_0x37f556[_0x0620('0x5d')]()[_0x0620('0x5f')](new RegExp(_0x572afd,'g'),_0x5d25bc);return _0x572afd+_0x3621a5+_0x572afd;}exports[_0x0620('0x60')]=function(_0x3eeffe,_0x25ad3e,_0x1bd519){var _0x482cb9,_0x4192a0;var _0x2c22f9={'where':{'ProjectId':_0x3eeffe['params']['id']}};if(_0x3eeffe[_0x0620('0x30')][_0x0620('0x61')]){_0x2c22f9[_0x0620('0x3b')][_0x0620('0x62')]=JSON['parse'](_0x3eeffe[_0x0620('0x30')][_0x0620('0x61')]);}return db[_0x0620('0x57')][_0x0620('0x44')](_0x2c22f9)[_0x0620('0x22')](handleEntityNotFound(_0x25ad3e,null))[_0x0620('0x22')](function(_0x308073){if(_0x308073){_0x482cb9=_0x308073;return db['JscriptyQuestionReport'][_0x0620('0x44')]({'where':{'SessionId':{'$in':_[_0x0620('0x2a')](_0x482cb9,'id')},'ProjectId':_0x3eeffe[_0x0620('0x51')]['id']},'order':'-createdAt'});}})['then'](handleEntityNotFound(_0x25ad3e,null))[_0x0620('0x22')](function(_0x5af593){if(_0x5af593){_0x4192a0=_0x5af593;var _0x4a35d7={};for(var _0x457391=0x0,_0x4eb2f5=_0x4192a0['length'];_0x457391<_0x4eb2f5;_0x457391++){if(!_0x4a35d7[_0x0620('0x37')](_0x4192a0[_0x457391][_0x0620('0x63')])){_0x4a35d7[_0x4192a0[_0x457391][_0x0620('0x63')]]=needsEncapsulation(_0x4192a0[_0x457391][_0x0620('0x64')])?encapsulate(_0x4192a0[_0x457391][_0x0620('0x64')]):_0x4192a0[_0x457391][_0x0620('0x64')];}}var _0x451083=[],_0x40346a={};for(var _0x29541c=0x0,_0xbfcb07=_0x482cb9[_0x0620('0x36')];_0x29541c<_0xbfcb07;_0x29541c++){_0x40346a={'ProjectId':_0x3eeffe[_0x0620('0x51')]['id'],'SessionId':_0x482cb9[_0x29541c]['id'],'StartTime':moment(_0x482cb9[_0x29541c][_0x0620('0x62')])[_0x0620('0x65')]('YYYY-MM-DD\x20HH:mm:ss')};for(var _0x31aa65=0x0,_0x2cb16f=_0x4192a0[_0x0620('0x36')];_0x31aa65<_0x2cb16f;_0x31aa65++){if(_0x4192a0[_0x31aa65][_0x0620('0x66')]==_0x482cb9[_0x29541c]['id']&&_0x4a35d7['hasOwnProperty'](_0x4192a0[_0x31aa65][_0x0620('0x63')])){_0x40346a[_0x4a35d7[_0x4192a0[_0x31aa65][_0x0620('0x63')]]]=_0x4192a0[_0x31aa65][_0x0620('0x67')];}}for(var _0x14a23b in _0x4a35d7){if(!_0x40346a[_0x0620('0x37')](_0x4a35d7[_0x14a23b])){_0x40346a[_0x4a35d7[_0x14a23b]]=null;}}_0x451083['push'](_0x40346a);}return _0x451083;}})[_0x0620('0x22')](function(_0x26ec82){if(!_['isEmpty'](_0x26ec82)){var _0x52e741=toCsv(_0x26ec82);var _0x39e293=Date['now']();fs[_0x0620('0x68')](util['format']('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x3eeffe[_0x0620('0x51')]['id'],_0x39e293),_0x52e741);_0x25ad3e[_0x0620('0x69')](_0x0620('0x6a'),_0x0620('0x6b')+util[_0x0620('0x65')](_0x0620('0x6c'),_0x3eeffe[_0x0620('0x51')]['id'],_0x39e293));_0x25ad3e['setHeader']('Content-type',_0x0620('0x6d'));return _0x25ad3e[_0x0620('0x6e')](util['format']('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x3eeffe['params']['id'],_0x39e293));}else{return _0x25ad3e['sendStatus'](0xcc);}})['catch'](handleError(_0x25ad3e,null));};
\ No newline at end of file
+var _0x8383=['create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','include','omit','createdAt','body','findOne','JscriptySessionReport','JscriptyAnswerReport','number','fromCharCode','toString','indexOf','getSummary','starttime','parse','-createdAt','questionId','question','format','YYYY-MM-DD\x20HH:mm:ss','push','isEmpty','writeFileSync','setHeader','Content-disposition','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','Content-type','text/csv','download','/tmp/Jscripty_Project_%d_Summary_%s.csv','eml-format','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','jsforce','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','end','status','offset','limit','undefined','count','set','Content-Range','json','reject','update','then','destroy','get','Projects','UserProfileResource','error','stack','name','send','JscriptyProject','fieldName','type','map','query','keys','filters','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','VIRTUAL','options','includeAll','findAll','catch','show','params','rawAttributes','find'];(function(_0x4ec863,_0x85080a){var _0x2071fc=function(_0x5a49a2){while(--_0x5a49a2){_0x4ec863['push'](_0x4ec863['shift']());}};_0x2071fc(++_0x85080a);}(_0x8383,0x98));var _0x3838=function(_0x5cad1d,_0x1ee946){_0x5cad1d=_0x5cad1d-0x0;var _0x239dbb=_0x8383[_0x5cad1d];return _0x239dbb;};'use strict';var emlformat=require(_0x3838('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0x3838('0x1'));var rp=require(_0x3838('0x2'));var moment=require(_0x3838('0x3'));var BPromise=require(_0x3838('0x4'));var Mustache=require(_0x3838('0x5'));var util=require(_0x3838('0x6'));var path=require(_0x3838('0x7'));var sox=require(_0x3838('0x8'));var csv=require(_0x3838('0x9'));var ejs=require(_0x3838('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x3838('0xb'));var squel=require(_0x3838('0xc'));var crypto=require('crypto');var jsforce=require(_0x3838('0xd'));var deskjs=require('desk.js');var toCsv=require(_0x3838('0x9'));var querystring=require(_0x3838('0xe'));var Papa=require(_0x3838('0xf'));var Redis=require('ioredis');var authService=require(_0x3838('0x10'));var qs=require(_0x3838('0x11'));var as=require(_0x3838('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x3838('0x13'))(_0x3838('0x14'));var utils=require(_0x3838('0x15'));var config=require(_0x3838('0x16'));var licenseUtil=require('../../config/license/util');var db=require(_0x3838('0x17'))['db'];function respondWithStatusCode(_0x276d98,_0x21f2c0){_0x21f2c0=_0x21f2c0||0xcc;return function(_0x56e009){if(_0x56e009){return _0x276d98[_0x3838('0x18')](_0x21f2c0);}return _0x276d98['status'](_0x21f2c0)[_0x3838('0x19')]();};}function respondWithResult(_0x2cfc06,_0x104adf){_0x104adf=_0x104adf||0xc8;return function(_0x17e0c4){if(_0x17e0c4){return _0x2cfc06[_0x3838('0x1a')](_0x104adf)['json'](_0x17e0c4);}};}function respondWithFilteredResult(_0x284ec1,_0xb4bf82){return function(_0x396b2d){if(_0x396b2d){var _0x2d81b2=typeof _0xb4bf82[_0x3838('0x1b')]==='undefined'&&typeof _0xb4bf82[_0x3838('0x1c')]===_0x3838('0x1d');var _0x29e617=_0x396b2d['count'];var _0x45aa66=_0x2d81b2?0x0:_0xb4bf82[_0x3838('0x1b')];var _0x4a9a7a=_0x2d81b2?_0x396b2d[_0x3838('0x1e')]:_0xb4bf82[_0x3838('0x1b')]+_0xb4bf82['limit'];var _0x313a90;if(_0x4a9a7a>=_0x29e617){_0x4a9a7a=_0x29e617;_0x313a90=0xc8;}else{_0x313a90=0xce;}_0x284ec1['status'](_0x313a90);return _0x284ec1[_0x3838('0x1f')](_0x3838('0x20'),_0x45aa66+'-'+_0x4a9a7a+'/'+_0x29e617)[_0x3838('0x21')](_0x396b2d);}return null;};}function patchUpdates(_0x2f9965){return function(_0x31a4b8){try{jsonpatch['apply'](_0x31a4b8,_0x2f9965,!![]);}catch(_0x5d7dd0){return BPromise[_0x3838('0x22')](_0x5d7dd0);}return _0x31a4b8['save']();};}function saveUpdates(_0x211fa7,_0x220fdd){return function(_0x200e51){if(_0x200e51){return _0x200e51[_0x3838('0x23')](_0x211fa7)[_0x3838('0x24')](function(_0x30e98f){return _0x30e98f;});}return null;};}function removeEntity(_0xbd0fd1,_0x1e8d61){return function(_0x525b21){if(_0x525b21){return _0x525b21[_0x3838('0x25')]()['then'](function(){var _0x3e554a=_0x525b21[_0x3838('0x26')]({'plain':!![]});var _0x55eaa5=_0x3838('0x27');return db[_0x3838('0x28')]['destroy']({'where':{'type':_0x55eaa5,'resourceId':_0x3e554a['id']}})[_0x3838('0x24')](function(){return _0x525b21;});})[_0x3838('0x24')](function(){_0xbd0fd1['status'](0xcc)[_0x3838('0x19')]();});}};}function handleEntityNotFound(_0x4c1efb,_0x2b2bd6){return function(_0x5c26b9){if(!_0x5c26b9){_0x4c1efb['sendStatus'](0x194);}return _0x5c26b9;};}function handleError(_0xef609c,_0x328e57){_0x328e57=_0x328e57||0x1f4;return function(_0x41bb45){logger[_0x3838('0x29')](_0x41bb45[_0x3838('0x2a')]);if(_0x41bb45['name']){delete _0x41bb45[_0x3838('0x2b')];}_0xef609c[_0x3838('0x1a')](_0x328e57)[_0x3838('0x2c')](_0x41bb45);};}exports['index']=function(_0x14950a,_0x5ee2d8){var _0x2549bd={},_0x4b1a0c={},_0x441a7f={'count':0x0,'rows':[]};var _0x2a725c=_['map'](db[_0x3838('0x2d')]['rawAttributes'],function(_0x580d0a){return{'name':_0x580d0a[_0x3838('0x2e')],'type':_0x580d0a[_0x3838('0x2f')]['key']};});_0x4b1a0c['model']=_[_0x3838('0x30')](_0x2a725c,'name');_0x4b1a0c[_0x3838('0x31')]=_[_0x3838('0x32')](_0x14950a[_0x3838('0x31')]);_0x4b1a0c[_0x3838('0x33')]=_[_0x3838('0x34')](_0x4b1a0c[_0x3838('0x35')],_0x4b1a0c['query']);_0x2549bd[_0x3838('0x36')]=_[_0x3838('0x34')](_0x4b1a0c[_0x3838('0x35')],qs[_0x3838('0x37')](_0x14950a[_0x3838('0x31')][_0x3838('0x37')]));_0x2549bd[_0x3838('0x36')]=_0x2549bd[_0x3838('0x36')][_0x3838('0x38')]?_0x2549bd[_0x3838('0x36')]:_0x4b1a0c[_0x3838('0x35')];if(!_0x14950a['query'][_0x3838('0x39')](_0x3838('0x3a'))){_0x2549bd[_0x3838('0x1c')]=qs[_0x3838('0x1c')](_0x14950a['query'][_0x3838('0x1c')]);_0x2549bd[_0x3838('0x1b')]=qs[_0x3838('0x1b')](_0x14950a[_0x3838('0x31')]['offset']);}_0x2549bd[_0x3838('0x3b')]=qs[_0x3838('0x3c')](_0x14950a[_0x3838('0x31')][_0x3838('0x3c')]);_0x2549bd['where']=qs[_0x3838('0x33')](_[_0x3838('0x3d')](_0x14950a[_0x3838('0x31')],_0x4b1a0c['filters']),_0x2a725c);if(_0x14950a['query'][_0x3838('0x3e')]){_0x2549bd[_0x3838('0x3f')]=_[_0x3838('0x40')](_0x2549bd[_0x3838('0x3f')],{'$or':_[_0x3838('0x30')](_0x2a725c,function(_0x45e0e8){if(_0x45e0e8[_0x3838('0x2f')]!==_0x3838('0x41')){var _0x2c7521={};_0x2c7521[_0x45e0e8['name']]={'$like':'%'+_0x14950a[_0x3838('0x31')][_0x3838('0x3e')]+'%'};return _0x2c7521;}})});}_0x2549bd=_[_0x3838('0x40')]({},_0x2549bd,_0x14950a[_0x3838('0x42')]);var _0x43a8d6={'where':_0x2549bd[_0x3838('0x3f')]};return db[_0x3838('0x2d')][_0x3838('0x1e')](_0x43a8d6)['then'](function(_0x2bbd18){_0x441a7f[_0x3838('0x1e')]=_0x2bbd18;if(_0x14950a['query'][_0x3838('0x43')]){_0x2549bd['include']=[{'all':!![]}];}return db[_0x3838('0x2d')][_0x3838('0x44')](_0x2549bd);})['then'](function(_0x55af4f){_0x441a7f['rows']=_0x55af4f;return _0x441a7f;})[_0x3838('0x24')](respondWithFilteredResult(_0x5ee2d8,_0x2549bd))[_0x3838('0x45')](handleError(_0x5ee2d8,null));};exports[_0x3838('0x46')]=function(_0xbc0a4b,_0x5824c9){var _0x3826da={'raw':![],'where':{'id':_0xbc0a4b[_0x3838('0x47')]['id']}},_0x308d62={};_0x308d62[_0x3838('0x35')]=_[_0x3838('0x32')](db[_0x3838('0x2d')][_0x3838('0x48')]);_0x308d62[_0x3838('0x31')]=_[_0x3838('0x32')](_0xbc0a4b[_0x3838('0x31')]);_0x308d62['filters']=_[_0x3838('0x34')](_0x308d62[_0x3838('0x35')],_0x308d62[_0x3838('0x31')]);_0x3826da[_0x3838('0x36')]=_[_0x3838('0x34')](_0x308d62[_0x3838('0x35')],qs[_0x3838('0x37')](_0xbc0a4b['query'][_0x3838('0x37')]));_0x3826da['attributes']=_0x3826da['attributes'][_0x3838('0x38')]?_0x3826da[_0x3838('0x36')]:_0x308d62[_0x3838('0x35')];if(_0xbc0a4b['query'][_0x3838('0x43')]){_0x3826da['include']=[{'all':!![]}];}_0x3826da=_[_0x3838('0x40')]({},_0x3826da,_0xbc0a4b[_0x3838('0x42')]);return db[_0x3838('0x2d')][_0x3838('0x49')](_0x3826da)[_0x3838('0x24')](handleEntityNotFound(_0x5824c9,null))[_0x3838('0x24')](respondWithResult(_0x5824c9,null))[_0x3838('0x45')](handleError(_0x5824c9,null));};exports[_0x3838('0x4a')]=function(_0x415af0,_0x18b817){return db['JscriptyProject']['create'](_0x415af0['body'],{})[_0x3838('0x24')](function(_0x256e32){var _0x83b1a2=_0x415af0[_0x3838('0x4b')][_0x3838('0x26')]({'plain':!![]});if(!_0x83b1a2)throw new Error(_0x3838('0x4c'));if(_0x83b1a2[_0x3838('0x4d')]===_0x3838('0x4b')){var _0x1992a6=_0x256e32[_0x3838('0x26')]({'plain':!![]});var _0x12f4cd=_0x3838('0x27');return db[_0x3838('0x4e')][_0x3838('0x49')]({'where':{'name':_0x12f4cd,'userProfileId':_0x83b1a2[_0x3838('0x4f')]},'raw':!![]})[_0x3838('0x24')](function(_0x39abe2){if(_0x39abe2&&_0x39abe2[_0x3838('0x50')]===0x0){return db['UserProfileResource'][_0x3838('0x4a')]({'name':_0x1992a6[_0x3838('0x2b')],'resourceId':_0x1992a6['id'],'type':_0x39abe2['name'],'sectionId':_0x39abe2['id']},{})[_0x3838('0x24')](function(){return _0x256e32;});}else{return _0x256e32;}})['catch'](function(_0x41c671){logger[_0x3838('0x29')](_0x3838('0x51'),_0x41c671);throw _0x41c671;});}return _0x256e32;})[_0x3838('0x24')](respondWithResult(_0x18b817,0xc9))[_0x3838('0x45')](handleError(_0x18b817,null));};exports[_0x3838('0x52')]=function(_0x442aa6,_0x223441){var _0x47a370={'where':{'id':_0x442aa6[_0x3838('0x47')]['id']}},_0x4b4cd4={};_0x4b4cd4[_0x3838('0x35')]=_['keys'](db[_0x3838('0x2d')][_0x3838('0x48')]);_0x47a370['attributes']=_[_0x3838('0x34')](_0x4b4cd4[_0x3838('0x35')],qs[_0x3838('0x37')](_0x442aa6[_0x3838('0x31')][_0x3838('0x37')]));_0x47a370[_0x3838('0x36')]=_0x47a370[_0x3838('0x36')]['length']?_0x47a370['attributes']:_0x4b4cd4['model'];if(_0x442aa6[_0x3838('0x31')][_0x3838('0x43')]){_0x47a370[_0x3838('0x53')]=[{'all':!![]}];}_0x47a370=_['merge']({},_0x47a370,_0x442aa6[_0x3838('0x42')]);return db[_0x3838('0x2d')][_0x3838('0x49')](_0x47a370)[_0x3838('0x24')](handleEntityNotFound(_0x223441,null))[_0x3838('0x24')](function(_0x350e94){if(_0x350e94){var _0x2e352e=_0x350e94[_0x3838('0x26')]({'plain':!![]});_0x2e352e=qs[_0x3838('0x54')](_0x2e352e,['id',_0x3838('0x55'),'updatedAt']);_0x442aa6[_0x3838('0x56')]=_[_0x3838('0x54')](_0x442aa6[_0x3838('0x56')],['id','createdAt','updatedAt']);return db[_0x3838('0x2d')][_0x3838('0x4a')](_[_0x3838('0x40')](_0x2e352e,_0x442aa6[_0x3838('0x56')]),{'include':_0x442aa6['query'][_0x3838('0x43')]?[{'all':!![]}]:undefined})[_0x3838('0x24')](function(_0x1631b4){var _0x124ef9=_0x442aa6[_0x3838('0x4b')]['get']({'plain':!![]});if(!_0x124ef9)throw new Error(_0x3838('0x4c'));if(_0x124ef9[_0x3838('0x4d')]===_0x3838('0x4b')){var _0x40d406=_0x1631b4['get']({'plain':!![]});var _0x2f8ff6=_0x3838('0x27');return db['UserProfileSection']['find']({'where':{'name':_0x2f8ff6,'userProfileId':_0x124ef9[_0x3838('0x4f')]},'raw':!![]})[_0x3838('0x24')](function(_0xae078){if(_0xae078&&_0xae078['autoAssociation']===0x0){return db[_0x3838('0x28')][_0x3838('0x4a')]({'name':_0x40d406[_0x3838('0x2b')],'resourceId':_0x40d406['id'],'type':_0xae078[_0x3838('0x2b')],'sectionId':_0xae078['id']},{})[_0x3838('0x24')](function(){return _0x1631b4;});}else{return _0x1631b4;}})[_0x3838('0x45')](function(_0x4431ec){logger[_0x3838('0x29')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x4431ec);throw _0x4431ec;});}return _0x1631b4;});}})['then'](respondWithResult(_0x223441,0xc9))[_0x3838('0x45')](handleError(_0x223441,null));};exports['update']=function(_0x17f09d,_0x1228c7){if(_0x17f09d[_0x3838('0x56')]['id']){delete _0x17f09d[_0x3838('0x56')]['id'];}return db[_0x3838('0x2d')][_0x3838('0x49')]({'where':{'id':_0x17f09d[_0x3838('0x47')]['id']}})['then'](handleEntityNotFound(_0x1228c7,null))[_0x3838('0x24')](saveUpdates(_0x17f09d[_0x3838('0x56')],null))[_0x3838('0x24')](respondWithResult(_0x1228c7,null))[_0x3838('0x45')](handleError(_0x1228c7,null));};exports[_0x3838('0x25')]=function(_0x565af1,_0x2edbc8){return db[_0x3838('0x2d')][_0x3838('0x49')]({'where':{'id':_0x565af1[_0x3838('0x47')]['id']}})['then'](handleEntityNotFound(_0x2edbc8,null))[_0x3838('0x24')](removeEntity(_0x2edbc8,null))[_0x3838('0x45')](handleError(_0x2edbc8,null));};exports['getSessions']=function(_0xe43827,_0x19f103,_0x5e30b9){var _0x1a8844={'raw':!![],'where':{}};var _0x58eccf={};var _0x43e6d0={'count':0x0,'rows':[]};return db[_0x3838('0x2d')][_0x3838('0x57')]({'where':{'id':_0xe43827[_0x3838('0x47')]['id']}})[_0x3838('0x24')](handleEntityNotFound(_0x19f103,null))[_0x3838('0x24')](function(_0x1f1ad5){if(_0x1f1ad5){_0x58eccf[_0x3838('0x35')]=_[_0x3838('0x32')](db[_0x3838('0x58')][_0x3838('0x48')]);_0x58eccf['query']=_[_0x3838('0x32')](_0xe43827[_0x3838('0x31')]);_0x58eccf[_0x3838('0x33')]=_[_0x3838('0x34')](_0x58eccf['model'],_0x58eccf['query']);_0x1a8844[_0x3838('0x36')]=_['intersection'](_0x58eccf[_0x3838('0x35')],qs[_0x3838('0x37')](_0xe43827[_0x3838('0x31')][_0x3838('0x37')]));_0x1a8844['attributes']=_0x1a8844[_0x3838('0x36')]['length']?_0x1a8844[_0x3838('0x36')]:_0x58eccf[_0x3838('0x35')];if(!_0xe43827[_0x3838('0x31')][_0x3838('0x39')](_0x3838('0x3a'))){_0x1a8844[_0x3838('0x1c')]=qs[_0x3838('0x1c')](_0xe43827['query']['limit']);_0x1a8844[_0x3838('0x1b')]=qs[_0x3838('0x1b')](_0xe43827['query'][_0x3838('0x1b')]);}_0x1a8844[_0x3838('0x3b')]=qs['sort'](_0xe43827[_0x3838('0x31')][_0x3838('0x3c')]);_0x1a8844[_0x3838('0x3f')]=qs[_0x3838('0x33')](_['pick'](_0xe43827[_0x3838('0x31')],_0x58eccf[_0x3838('0x33')]));_0x1a8844['where']['ProjectId']=_0x1f1ad5['id'];if(_0xe43827['query'][_0x3838('0x3e')]){_0x1a8844[_0x3838('0x3f')]=_['merge'](_0x1a8844[_0x3838('0x3f')],{'$or':_[_0x3838('0x30')](_0x1a8844[_0x3838('0x36')],function(_0x59e738){var _0x49491a={};_0x49491a[_0x59e738]={'$like':'%'+_0xe43827[_0x3838('0x31')][_0x3838('0x3e')]+'%'};return _0x49491a;})});}_0x1a8844=_[_0x3838('0x40')]({},_0x1a8844,_0xe43827[_0x3838('0x42')]);return db[_0x3838('0x58')]['count']({'where':_0x1a8844['where']})[_0x3838('0x24')](function(_0x5af995){_0x43e6d0[_0x3838('0x1e')]=_0x5af995;if(_0xe43827[_0x3838('0x31')][_0x3838('0x43')]){_0x1a8844[_0x3838('0x53')]=[{'all':!![]}];}return db[_0x3838('0x58')][_0x3838('0x44')](_0x1a8844);})[_0x3838('0x24')](function(_0x1363c1){_0x43e6d0['rows']=_0x1363c1;return _0x43e6d0;});}})['then'](respondWithFilteredResult(_0x19f103,_0x1a8844))[_0x3838('0x45')](handleError(_0x19f103,null));};exports['getAnswers']=function(_0x17d8e0,_0x1bf104,_0x2d814f){var _0x461f7d={'raw':!![],'where':{}};var _0x5ea8df={};var _0x29f7c5={'count':0x0,'rows':[]};return db['JscriptyProject'][_0x3838('0x57')]({'where':{'id':_0x17d8e0['params']['id']}})[_0x3838('0x24')](handleEntityNotFound(_0x1bf104,null))[_0x3838('0x24')](function(_0x26a6fa){if(_0x26a6fa){_0x5ea8df[_0x3838('0x35')]=_[_0x3838('0x32')](db[_0x3838('0x59')][_0x3838('0x48')]);_0x5ea8df[_0x3838('0x31')]=_[_0x3838('0x32')](_0x17d8e0[_0x3838('0x31')]);_0x5ea8df[_0x3838('0x33')]=_['intersection'](_0x5ea8df[_0x3838('0x35')],_0x5ea8df[_0x3838('0x31')]);_0x461f7d[_0x3838('0x36')]=_[_0x3838('0x34')](_0x5ea8df[_0x3838('0x35')],qs[_0x3838('0x37')](_0x17d8e0[_0x3838('0x31')][_0x3838('0x37')]));_0x461f7d['attributes']=_0x461f7d['attributes'][_0x3838('0x38')]?_0x461f7d[_0x3838('0x36')]:_0x5ea8df[_0x3838('0x35')];if(!_0x17d8e0[_0x3838('0x31')][_0x3838('0x39')]('nolimit')){_0x461f7d[_0x3838('0x1c')]=qs[_0x3838('0x1c')](_0x17d8e0['query'][_0x3838('0x1c')]);_0x461f7d[_0x3838('0x1b')]=qs['offset'](_0x17d8e0[_0x3838('0x31')]['offset']);}_0x461f7d[_0x3838('0x3b')]=qs[_0x3838('0x3c')](_0x17d8e0[_0x3838('0x31')][_0x3838('0x3c')]);_0x461f7d[_0x3838('0x3f')]=qs[_0x3838('0x33')](_[_0x3838('0x3d')](_0x17d8e0[_0x3838('0x31')],_0x5ea8df[_0x3838('0x33')]));_0x461f7d[_0x3838('0x3f')]['ProjectId']=_0x26a6fa['id'];if(_0x17d8e0[_0x3838('0x31')][_0x3838('0x3e')]){_0x461f7d[_0x3838('0x3f')]=_[_0x3838('0x40')](_0x461f7d[_0x3838('0x3f')],{'$or':_[_0x3838('0x30')](_0x461f7d[_0x3838('0x36')],function(_0x54f3d8){var _0x217d21={};_0x217d21[_0x54f3d8]={'$like':'%'+_0x17d8e0['query'][_0x3838('0x3e')]+'%'};return _0x217d21;})});}_0x461f7d=_[_0x3838('0x40')]({},_0x461f7d,_0x17d8e0['options']);return db[_0x3838('0x59')][_0x3838('0x1e')]({'where':_0x461f7d[_0x3838('0x3f')]})[_0x3838('0x24')](function(_0x512b8f){_0x29f7c5[_0x3838('0x1e')]=_0x512b8f;if(_0x17d8e0['query'][_0x3838('0x43')]){_0x461f7d[_0x3838('0x53')]=[{'all':!![]}];}return db['JscriptyAnswerReport'][_0x3838('0x44')](_0x461f7d);})[_0x3838('0x24')](function(_0x54d573){_0x29f7c5['rows']=_0x54d573;return _0x29f7c5;});}})['then'](respondWithFilteredResult(_0x1bf104,_0x461f7d))['catch'](handleError(_0x1bf104,null));};function char(_0x19a275){return _0x3838('0x5a')===typeof _0x19a275?String[_0x3838('0x5b')]['apply'](null,arguments):_0x19a275;}function needsEncapsulation(_0x4716f5){return!!_0x4716f5&&(_0x4716f5[_0x3838('0x5c')]()[_0x3838('0x5d')](char(0xd))>=0x0||_0x4716f5[_0x3838('0x5c')]()['indexOf'](char(0xa))>=0x0||_0x4716f5[_0x3838('0x5c')]()['indexOf'](char(0x2c))>=0x0||_0x4716f5[_0x3838('0x5c')]()[_0x3838('0x5d')](char(0x22))>=0x0);}function encapsulate(_0x510e9b){var _0x2f7989=char(0x22),_0x3a9f9e='\x5c'+char(0x22),_0x287a10=_0x510e9b[_0x3838('0x5c')]()['replace'](new RegExp(_0x2f7989,'g'),_0x3a9f9e);return _0x2f7989+_0x287a10+_0x2f7989;}exports[_0x3838('0x5e')]=function(_0x625040,_0x474d90,_0x4a42be){var _0x2ae48f,_0x56bd07;var _0x406011={'where':{'ProjectId':_0x625040['params']['id']}};if(_0x625040[_0x3838('0x31')]['startTime']){_0x406011[_0x3838('0x3f')][_0x3838('0x5f')]=JSON[_0x3838('0x60')](_0x625040[_0x3838('0x31')]['startTime']);}return db[_0x3838('0x58')][_0x3838('0x44')](_0x406011)[_0x3838('0x24')](handleEntityNotFound(_0x474d90,null))[_0x3838('0x24')](function(_0x2bd982){if(_0x2bd982){_0x2ae48f=_0x2bd982;return db['JscriptyQuestionReport'][_0x3838('0x44')]({'where':{'SessionId':{'$in':_['map'](_0x2ae48f,'id')},'ProjectId':_0x625040['params']['id']},'order':_0x3838('0x61')});}})[_0x3838('0x24')](handleEntityNotFound(_0x474d90,null))['then'](function(_0x4fe4f4){if(_0x4fe4f4){_0x56bd07=_0x4fe4f4;var _0x4793e0={};for(var _0x493300=0x0,_0x3121cc=_0x56bd07[_0x3838('0x38')];_0x493300<_0x3121cc;_0x493300++){if(!_0x4793e0[_0x3838('0x39')](_0x56bd07[_0x493300]['questionId'])){_0x4793e0[_0x56bd07[_0x493300][_0x3838('0x62')]]=needsEncapsulation(_0x56bd07[_0x493300]['question'])?encapsulate(_0x56bd07[_0x493300][_0x3838('0x63')]):_0x56bd07[_0x493300][_0x3838('0x63')];}}var _0x7ab4fc=[],_0x5a3c54={};for(var _0x39a230=0x0,_0x1dc281=_0x2ae48f['length'];_0x39a230<_0x1dc281;_0x39a230++){_0x5a3c54={'ProjectId':_0x625040['params']['id'],'SessionId':_0x2ae48f[_0x39a230]['id'],'StartTime':moment(_0x2ae48f[_0x39a230][_0x3838('0x5f')])[_0x3838('0x64')](_0x3838('0x65'))};for(var _0xb55309=0x0,_0xafd77e=_0x56bd07[_0x3838('0x38')];_0xb55309<_0xafd77e;_0xb55309++){if(_0x56bd07[_0xb55309]['SessionId']==_0x2ae48f[_0x39a230]['id']&&_0x4793e0[_0x3838('0x39')](_0x56bd07[_0xb55309][_0x3838('0x62')])){_0x5a3c54[_0x4793e0[_0x56bd07[_0xb55309][_0x3838('0x62')]]]=_0x56bd07[_0xb55309]['answer'];}}for(var _0x554293 in _0x4793e0){if(!_0x5a3c54[_0x3838('0x39')](_0x4793e0[_0x554293])){_0x5a3c54[_0x4793e0[_0x554293]]=null;}}_0x7ab4fc[_0x3838('0x66')](_0x5a3c54);}return _0x7ab4fc;}})['then'](function(_0x137172){if(!_[_0x3838('0x67')](_0x137172)){var _0x3cff72=toCsv(_0x137172);var _0x5372ad=Date['now']();fs[_0x3838('0x68')](util['format']('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x625040[_0x3838('0x47')]['id'],_0x5372ad),_0x3cff72);_0x474d90[_0x3838('0x69')](_0x3838('0x6a'),_0x3838('0x6b')+util[_0x3838('0x64')](_0x3838('0x6c'),_0x625040[_0x3838('0x47')]['id'],_0x5372ad));_0x474d90['setHeader'](_0x3838('0x6d'),_0x3838('0x6e'));return _0x474d90[_0x3838('0x6f')](util[_0x3838('0x64')](_0x3838('0x70'),_0x625040[_0x3838('0x47')]['id'],_0x5372ad));}else{return _0x474d90[_0x3838('0x18')](0xcc);}})[_0x3838('0x45')](handleError(_0x474d90,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff