// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x95aa=['fromCharCode','toString','indexOf','replace','startTime','parse','questionId','question','starttime','format','SessionId','answer','push','isEmpty','writeFileSync','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','Content-disposition','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','Content-type','text/csv','download','eml-format','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','squel','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','sendStatus','status','end','json','offset','limit','undefined','count','set','Content-Range','apply','reject','save','destroy','then','get','Projects','UserProfileResource','error','stack','name','index','map','JscriptyProject','rawAttributes','fieldName','key','model','query','keys','filters','intersection','fields','attributes','length','hasOwnProperty','sort','pick','type','VIRTUAL','filter','merge','options','includeAll','include','findAll','rows','catch','show','params','find','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','createdAt','updatedAt','omit','user','UserProfileSection','getSessions','JscriptySessionReport','order','where','ProjectId','getAnswers','findOne','nolimit','JscriptyAnswerReport','number'];(function(_0x3d3e6a,_0x3ac662){var _0x389380=function(_0x2d7a18){while(--_0x2d7a18){_0x3d3e6a['push'](_0x3d3e6a['shift']());}};_0x389380(++_0x3ac662);}(_0x95aa,0x91));var _0xa95a=function(_0x5a1cc9,_0x28f54d){_0x5a1cc9=_0x5a1cc9-0x0;var _0x471761=_0x95aa[_0x5a1cc9];return _0x471761;};'use strict';var emlformat=require(_0xa95a('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xa95a('0x1'));var jsonpatch=require(_0xa95a('0x2'));var rp=require('request-promise');var moment=require(_0xa95a('0x3'));var BPromise=require(_0xa95a('0x4'));var Mustache=require(_0xa95a('0x5'));var util=require(_0xa95a('0x6'));var path=require(_0xa95a('0x7'));var sox=require(_0xa95a('0x8'));var csv=require(_0xa95a('0x9'));var ejs=require(_0xa95a('0xa'));var fs=require('fs');var fs_extra=require(_0xa95a('0xb'));var _=require('lodash');var squel=require(_0xa95a('0xc'));var crypto=require('crypto');var jsforce=require(_0xa95a('0xd'));var deskjs=require(_0xa95a('0xe'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0xa95a('0xf'));var Redis=require(_0xa95a('0x10'));var authService=require(_0xa95a('0x11'));var qs=require(_0xa95a('0x12'));var as=require(_0xa95a('0x13'));var hardwareService=require(_0xa95a('0x14'));var logger=require(_0xa95a('0x15'))(_0xa95a('0x16'));var utils=require(_0xa95a('0x17'));var config=require(_0xa95a('0x18'));var licenseUtil=require(_0xa95a('0x19'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x4dd0db,_0x25ee8a){_0x25ee8a=_0x25ee8a||0xcc;return function(_0x4fbfc4){if(_0x4fbfc4){return _0x4dd0db[_0xa95a('0x1a')](_0x25ee8a);}return _0x4dd0db[_0xa95a('0x1b')](_0x25ee8a)[_0xa95a('0x1c')]();};}function respondWithResult(_0x23b41c,_0xa26339){_0xa26339=_0xa26339||0xc8;return function(_0x32dd48){if(_0x32dd48){return _0x23b41c[_0xa95a('0x1b')](_0xa26339)[_0xa95a('0x1d')](_0x32dd48);}};}function respondWithFilteredResult(_0x3265c5,_0x235e81){return function(_0x4c94a1){if(_0x4c94a1){var _0x1d60f7=typeof _0x235e81[_0xa95a('0x1e')]==='undefined'&&typeof _0x235e81[_0xa95a('0x1f')]===_0xa95a('0x20');var _0x44942d=_0x4c94a1[_0xa95a('0x21')];var _0x59aca9=_0x1d60f7?0x0:_0x235e81[_0xa95a('0x1e')];var _0x52be20=_0x1d60f7?_0x4c94a1[_0xa95a('0x21')]:_0x235e81[_0xa95a('0x1e')]+_0x235e81[_0xa95a('0x1f')];var _0x2e31a8;if(_0x52be20>=_0x44942d){_0x52be20=_0x44942d;_0x2e31a8=0xc8;}else{_0x2e31a8=0xce;}_0x3265c5[_0xa95a('0x1b')](_0x2e31a8);return _0x3265c5[_0xa95a('0x22')](_0xa95a('0x23'),_0x59aca9+'-'+_0x52be20+'/'+_0x44942d)[_0xa95a('0x1d')](_0x4c94a1);}return null;};}function patchUpdates(_0x26a3be){return function(_0x4004ef){try{jsonpatch[_0xa95a('0x24')](_0x4004ef,_0x26a3be,!![]);}catch(_0x4cd002){return BPromise[_0xa95a('0x25')](_0x4cd002);}return _0x4004ef[_0xa95a('0x26')]();};}function saveUpdates(_0x24b05c,_0x25355c){return function(_0x64522e){if(_0x64522e){return _0x64522e['update'](_0x24b05c)['then'](function(_0x3fdfef){return _0x3fdfef;});}return null;};}function removeEntity(_0xd27cab,_0xe930d2){return function(_0x24b33b){if(_0x24b33b){return _0x24b33b[_0xa95a('0x27')]()[_0xa95a('0x28')](function(){var _0x332aca=_0x24b33b[_0xa95a('0x29')]({'plain':!![]});var _0x3d27fc=_0xa95a('0x2a');return db[_0xa95a('0x2b')][_0xa95a('0x27')]({'where':{'type':_0x3d27fc,'resourceId':_0x332aca['id']}})[_0xa95a('0x28')](function(){return _0x24b33b;});})[_0xa95a('0x28')](function(){_0xd27cab['status'](0xcc)[_0xa95a('0x1c')]();});}};}function handleEntityNotFound(_0xa541a,_0x913f65){return function(_0x912d98){if(!_0x912d98){_0xa541a[_0xa95a('0x1a')](0x194);}return _0x912d98;};}function handleError(_0xdf3cce,_0x127fbd){_0x127fbd=_0x127fbd||0x1f4;return function(_0x161c25){logger[_0xa95a('0x2c')](_0x161c25[_0xa95a('0x2d')]);if(_0x161c25['name']){delete _0x161c25[_0xa95a('0x2e')];}_0xdf3cce['status'](_0x127fbd)['send'](_0x161c25);};}exports[_0xa95a('0x2f')]=function(_0x11f114,_0x558ab4){var _0x552afd={},_0x154688={},_0x199464={'count':0x0,'rows':[]};var _0x2258be=_[_0xa95a('0x30')](db[_0xa95a('0x31')][_0xa95a('0x32')],function(_0x18ae1a){return{'name':_0x18ae1a[_0xa95a('0x33')],'type':_0x18ae1a['type'][_0xa95a('0x34')]};});_0x154688[_0xa95a('0x35')]=_[_0xa95a('0x30')](_0x2258be,_0xa95a('0x2e'));_0x154688[_0xa95a('0x36')]=_[_0xa95a('0x37')](_0x11f114[_0xa95a('0x36')]);_0x154688[_0xa95a('0x38')]=_[_0xa95a('0x39')](_0x154688['model'],_0x154688[_0xa95a('0x36')]);_0x552afd['attributes']=_[_0xa95a('0x39')](_0x154688[_0xa95a('0x35')],qs[_0xa95a('0x3a')](_0x11f114['query'][_0xa95a('0x3a')]));_0x552afd[_0xa95a('0x3b')]=_0x552afd[_0xa95a('0x3b')][_0xa95a('0x3c')]?_0x552afd[_0xa95a('0x3b')]:_0x154688[_0xa95a('0x35')];if(!_0x11f114[_0xa95a('0x36')][_0xa95a('0x3d')]('nolimit')){_0x552afd['limit']=qs[_0xa95a('0x1f')](_0x11f114[_0xa95a('0x36')][_0xa95a('0x1f')]);_0x552afd['offset']=qs[_0xa95a('0x1e')](_0x11f114['query'][_0xa95a('0x1e')]);}_0x552afd['order']=qs[_0xa95a('0x3e')](_0x11f114[_0xa95a('0x36')]['sort']);_0x552afd['where']=qs[_0xa95a('0x38')](_[_0xa95a('0x3f')](_0x11f114['query'],_0x154688['filters']),_0x2258be);if(_0x11f114[_0xa95a('0x36')]['filter']){_0x552afd['where']=_['merge'](_0x552afd['where'],{'$or':_[_0xa95a('0x30')](_0x2258be,function(_0x32ee4b){if(_0x32ee4b[_0xa95a('0x40')]!==_0xa95a('0x41')){var _0x14a88f={};_0x14a88f[_0x32ee4b['name']]={'$like':'%'+_0x11f114[_0xa95a('0x36')][_0xa95a('0x42')]+'%'};return _0x14a88f;}})});}_0x552afd=_[_0xa95a('0x43')]({},_0x552afd,_0x11f114[_0xa95a('0x44')]);var _0x14bf44={'where':_0x552afd['where']};return db['JscriptyProject'][_0xa95a('0x21')](_0x14bf44)[_0xa95a('0x28')](function(_0x5b86fc){_0x199464[_0xa95a('0x21')]=_0x5b86fc;if(_0x11f114[_0xa95a('0x36')][_0xa95a('0x45')]){_0x552afd[_0xa95a('0x46')]=[{'all':!![]}];}return db['JscriptyProject'][_0xa95a('0x47')](_0x552afd);})[_0xa95a('0x28')](function(_0x418198){_0x199464[_0xa95a('0x48')]=_0x418198;return _0x199464;})['then'](respondWithFilteredResult(_0x558ab4,_0x552afd))[_0xa95a('0x49')](handleError(_0x558ab4,null));};exports[_0xa95a('0x4a')]=function(_0x343471,_0x451e86){var _0x3f7cd9={'raw':![],'where':{'id':_0x343471[_0xa95a('0x4b')]['id']}},_0x40cdba={};_0x40cdba[_0xa95a('0x35')]=_[_0xa95a('0x37')](db[_0xa95a('0x31')][_0xa95a('0x32')]);_0x40cdba['query']=_[_0xa95a('0x37')](_0x343471['query']);_0x40cdba[_0xa95a('0x38')]=_[_0xa95a('0x39')](_0x40cdba[_0xa95a('0x35')],_0x40cdba[_0xa95a('0x36')]);_0x3f7cd9[_0xa95a('0x3b')]=_[_0xa95a('0x39')](_0x40cdba[_0xa95a('0x35')],qs[_0xa95a('0x3a')](_0x343471[_0xa95a('0x36')][_0xa95a('0x3a')]));_0x3f7cd9[_0xa95a('0x3b')]=_0x3f7cd9[_0xa95a('0x3b')][_0xa95a('0x3c')]?_0x3f7cd9['attributes']:_0x40cdba[_0xa95a('0x35')];if(_0x343471[_0xa95a('0x36')]['includeAll']){_0x3f7cd9[_0xa95a('0x46')]=[{'all':!![]}];}_0x3f7cd9=_[_0xa95a('0x43')]({},_0x3f7cd9,_0x343471[_0xa95a('0x44')]);return db[_0xa95a('0x31')][_0xa95a('0x4c')](_0x3f7cd9)[_0xa95a('0x28')](handleEntityNotFound(_0x451e86,null))[_0xa95a('0x28')](respondWithResult(_0x451e86,null))[_0xa95a('0x49')](handleError(_0x451e86,null));};exports[_0xa95a('0x4d')]=function(_0x19c6e1,_0x2494c5){return db['JscriptyProject']['create'](_0x19c6e1[_0xa95a('0x4e')],{})[_0xa95a('0x28')](function(_0x1b8304){var _0x189d9f=_0x19c6e1['user'][_0xa95a('0x29')]({'plain':!![]});if(!_0x189d9f)throw new Error(_0xa95a('0x4f'));if(_0x189d9f[_0xa95a('0x50')]==='user'){var _0x1321cc=_0x1b8304[_0xa95a('0x29')]({'plain':!![]});var _0x23b322=_0xa95a('0x2a');return db['UserProfileSection'][_0xa95a('0x4c')]({'where':{'name':_0x23b322,'userProfileId':_0x189d9f[_0xa95a('0x51')]},'raw':!![]})[_0xa95a('0x28')](function(_0x3c1785){if(_0x3c1785&&_0x3c1785['autoAssociation']===0x0){return db[_0xa95a('0x2b')]['create']({'name':_0x1321cc[_0xa95a('0x2e')],'resourceId':_0x1321cc['id'],'type':_0x3c1785['name'],'sectionId':_0x3c1785['id']},{})['then'](function(){return _0x1b8304;});}else{return _0x1b8304;}})[_0xa95a('0x49')](function(_0x3a95d4){logger[_0xa95a('0x2c')](_0xa95a('0x52'),_0x3a95d4);throw _0x3a95d4;});}return _0x1b8304;})['then'](respondWithResult(_0x2494c5,0xc9))['catch'](handleError(_0x2494c5,null));};exports[_0xa95a('0x53')]=function(_0x597ae1,_0x38c97e){var _0x56df2e={'where':{'id':_0x597ae1[_0xa95a('0x4b')]['id']}},_0x3c6627={};_0x3c6627[_0xa95a('0x35')]=_[_0xa95a('0x37')](db[_0xa95a('0x31')]['rawAttributes']);_0x56df2e[_0xa95a('0x3b')]=_[_0xa95a('0x39')](_0x3c6627['model'],qs['fields'](_0x597ae1[_0xa95a('0x36')][_0xa95a('0x3a')]));_0x56df2e[_0xa95a('0x3b')]=_0x56df2e[_0xa95a('0x3b')][_0xa95a('0x3c')]?_0x56df2e['attributes']:_0x3c6627[_0xa95a('0x35')];if(_0x597ae1[_0xa95a('0x36')][_0xa95a('0x45')]){_0x56df2e['include']=[{'all':!![]}];}_0x56df2e=_['merge']({},_0x56df2e,_0x597ae1[_0xa95a('0x44')]);return db['JscriptyProject']['find'](_0x56df2e)[_0xa95a('0x28')](handleEntityNotFound(_0x38c97e,null))['then'](function(_0x2076e5){if(_0x2076e5){var _0x448145=_0x2076e5['get']({'plain':!![]});_0x448145=qs['omit'](_0x448145,['id',_0xa95a('0x54'),_0xa95a('0x55')]);_0x597ae1[_0xa95a('0x4e')]=_[_0xa95a('0x56')](_0x597ae1[_0xa95a('0x4e')],['id',_0xa95a('0x54'),_0xa95a('0x55')]);return db[_0xa95a('0x31')][_0xa95a('0x4d')](_[_0xa95a('0x43')](_0x448145,_0x597ae1['body']),{'include':_0x597ae1['query'][_0xa95a('0x45')]?[{'all':!![]}]:undefined})[_0xa95a('0x28')](function(_0x4b5913){var _0x17bd25=_0x597ae1[_0xa95a('0x57')][_0xa95a('0x29')]({'plain':!![]});if(!_0x17bd25)throw new Error(_0xa95a('0x4f'));if(_0x17bd25[_0xa95a('0x50')]===_0xa95a('0x57')){var _0x4045f8=_0x4b5913['get']({'plain':!![]});var _0x3b909d=_0xa95a('0x2a');return db[_0xa95a('0x58')][_0xa95a('0x4c')]({'where':{'name':_0x3b909d,'userProfileId':_0x17bd25[_0xa95a('0x51')]},'raw':!![]})[_0xa95a('0x28')](function(_0x318b12){if(_0x318b12&&_0x318b12['autoAssociation']===0x0){return db[_0xa95a('0x2b')][_0xa95a('0x4d')]({'name':_0x4045f8['name'],'resourceId':_0x4045f8['id'],'type':_0x318b12[_0xa95a('0x2e')],'sectionId':_0x318b12['id']},{})[_0xa95a('0x28')](function(){return _0x4b5913;});}else{return _0x4b5913;}})[_0xa95a('0x49')](function(_0x2a2fc5){logger[_0xa95a('0x2c')](_0xa95a('0x52'),_0x2a2fc5);throw _0x2a2fc5;});}return _0x4b5913;});}})[_0xa95a('0x28')](respondWithResult(_0x38c97e,0xc9))['catch'](handleError(_0x38c97e,null));};exports['update']=function(_0x33869e,_0x12897f){if(_0x33869e[_0xa95a('0x4e')]['id']){delete _0x33869e['body']['id'];}return db[_0xa95a('0x31')][_0xa95a('0x4c')]({'where':{'id':_0x33869e['params']['id']}})[_0xa95a('0x28')](handleEntityNotFound(_0x12897f,null))[_0xa95a('0x28')](saveUpdates(_0x33869e[_0xa95a('0x4e')],null))[_0xa95a('0x28')](respondWithResult(_0x12897f,null))['catch'](handleError(_0x12897f,null));};exports[_0xa95a('0x27')]=function(_0x3dda70,_0x394038){return db[_0xa95a('0x31')][_0xa95a('0x4c')]({'where':{'id':_0x3dda70[_0xa95a('0x4b')]['id']}})[_0xa95a('0x28')](handleEntityNotFound(_0x394038,null))[_0xa95a('0x28')](removeEntity(_0x394038,null))[_0xa95a('0x49')](handleError(_0x394038,null));};exports[_0xa95a('0x59')]=function(_0x572cb5,_0xfc400a,_0x3d4d81){var _0x3c8c75={'raw':!![],'where':{}};var _0x4ea5aa={};var _0x5170f9={'count':0x0,'rows':[]};return db[_0xa95a('0x31')]['findOne']({'where':{'id':_0x572cb5[_0xa95a('0x4b')]['id']}})[_0xa95a('0x28')](handleEntityNotFound(_0xfc400a,null))[_0xa95a('0x28')](function(_0x3aeea0){if(_0x3aeea0){_0x4ea5aa['model']=_[_0xa95a('0x37')](db[_0xa95a('0x5a')][_0xa95a('0x32')]);_0x4ea5aa[_0xa95a('0x36')]=_[_0xa95a('0x37')](_0x572cb5[_0xa95a('0x36')]);_0x4ea5aa[_0xa95a('0x38')]=_[_0xa95a('0x39')](_0x4ea5aa[_0xa95a('0x35')],_0x4ea5aa[_0xa95a('0x36')]);_0x3c8c75['attributes']=_[_0xa95a('0x39')](_0x4ea5aa[_0xa95a('0x35')],qs[_0xa95a('0x3a')](_0x572cb5[_0xa95a('0x36')][_0xa95a('0x3a')]));_0x3c8c75['attributes']=_0x3c8c75[_0xa95a('0x3b')][_0xa95a('0x3c')]?_0x3c8c75[_0xa95a('0x3b')]:_0x4ea5aa['model'];if(!_0x572cb5['query']['hasOwnProperty']('nolimit')){_0x3c8c75[_0xa95a('0x1f')]=qs[_0xa95a('0x1f')](_0x572cb5[_0xa95a('0x36')]['limit']);_0x3c8c75[_0xa95a('0x1e')]=qs[_0xa95a('0x1e')](_0x572cb5[_0xa95a('0x36')][_0xa95a('0x1e')]);}_0x3c8c75[_0xa95a('0x5b')]=qs[_0xa95a('0x3e')](_0x572cb5['query'][_0xa95a('0x3e')]);_0x3c8c75[_0xa95a('0x5c')]=qs[_0xa95a('0x38')](_['pick'](_0x572cb5[_0xa95a('0x36')],_0x4ea5aa['filters']));_0x3c8c75[_0xa95a('0x5c')][_0xa95a('0x5d')]=_0x3aeea0['id'];if(_0x572cb5[_0xa95a('0x36')]['filter']){_0x3c8c75['where']=_[_0xa95a('0x43')](_0x3c8c75['where'],{'$or':_[_0xa95a('0x30')](_0x3c8c75[_0xa95a('0x3b')],function(_0x56f52b){var _0x3528af={};_0x3528af[_0x56f52b]={'$like':'%'+_0x572cb5[_0xa95a('0x36')][_0xa95a('0x42')]+'%'};return _0x3528af;})});}_0x3c8c75=_[_0xa95a('0x43')]({},_0x3c8c75,_0x572cb5[_0xa95a('0x44')]);return db['JscriptySessionReport'][_0xa95a('0x21')]({'where':_0x3c8c75['where']})[_0xa95a('0x28')](function(_0x4f7936){_0x5170f9[_0xa95a('0x21')]=_0x4f7936;if(_0x572cb5[_0xa95a('0x36')]['includeAll']){_0x3c8c75[_0xa95a('0x46')]=[{'all':!![]}];}return db[_0xa95a('0x5a')][_0xa95a('0x47')](_0x3c8c75);})['then'](function(_0x3096c1){_0x5170f9[_0xa95a('0x48')]=_0x3096c1;return _0x5170f9;});}})['then'](respondWithFilteredResult(_0xfc400a,_0x3c8c75))[_0xa95a('0x49')](handleError(_0xfc400a,null));};exports[_0xa95a('0x5e')]=function(_0xb46903,_0x27ceeb,_0x110d4a){var _0x111519={'raw':!![],'where':{}};var _0x4d89de={};var _0x1984f4={'count':0x0,'rows':[]};return db[_0xa95a('0x31')][_0xa95a('0x5f')]({'where':{'id':_0xb46903['params']['id']}})['then'](handleEntityNotFound(_0x27ceeb,null))['then'](function(_0x160cb7){if(_0x160cb7){_0x4d89de[_0xa95a('0x35')]=_[_0xa95a('0x37')](db['JscriptyAnswerReport'][_0xa95a('0x32')]);_0x4d89de[_0xa95a('0x36')]=_['keys'](_0xb46903['query']);_0x4d89de[_0xa95a('0x38')]=_[_0xa95a('0x39')](_0x4d89de[_0xa95a('0x35')],_0x4d89de[_0xa95a('0x36')]);_0x111519[_0xa95a('0x3b')]=_[_0xa95a('0x39')](_0x4d89de[_0xa95a('0x35')],qs['fields'](_0xb46903[_0xa95a('0x36')][_0xa95a('0x3a')]));_0x111519[_0xa95a('0x3b')]=_0x111519[_0xa95a('0x3b')]['length']?_0x111519['attributes']:_0x4d89de[_0xa95a('0x35')];if(!_0xb46903[_0xa95a('0x36')][_0xa95a('0x3d')](_0xa95a('0x60'))){_0x111519[_0xa95a('0x1f')]=qs[_0xa95a('0x1f')](_0xb46903['query'][_0xa95a('0x1f')]);_0x111519[_0xa95a('0x1e')]=qs[_0xa95a('0x1e')](_0xb46903[_0xa95a('0x36')][_0xa95a('0x1e')]);}_0x111519['order']=qs[_0xa95a('0x3e')](_0xb46903['query'][_0xa95a('0x3e')]);_0x111519[_0xa95a('0x5c')]=qs[_0xa95a('0x38')](_[_0xa95a('0x3f')](_0xb46903[_0xa95a('0x36')],_0x4d89de[_0xa95a('0x38')]));_0x111519[_0xa95a('0x5c')][_0xa95a('0x5d')]=_0x160cb7['id'];if(_0xb46903['query'][_0xa95a('0x42')]){_0x111519[_0xa95a('0x5c')]=_[_0xa95a('0x43')](_0x111519[_0xa95a('0x5c')],{'$or':_[_0xa95a('0x30')](_0x111519[_0xa95a('0x3b')],function(_0x4a1a30){var _0x4a3c7b={};_0x4a3c7b[_0x4a1a30]={'$like':'%'+_0xb46903['query'][_0xa95a('0x42')]+'%'};return _0x4a3c7b;})});}_0x111519=_['merge']({},_0x111519,_0xb46903[_0xa95a('0x44')]);return db[_0xa95a('0x61')][_0xa95a('0x21')]({'where':_0x111519[_0xa95a('0x5c')]})[_0xa95a('0x28')](function(_0x5205e6){_0x1984f4[_0xa95a('0x21')]=_0x5205e6;if(_0xb46903[_0xa95a('0x36')][_0xa95a('0x45')]){_0x111519[_0xa95a('0x46')]=[{'all':!![]}];}return db[_0xa95a('0x61')][_0xa95a('0x47')](_0x111519);})['then'](function(_0x1c6731){_0x1984f4[_0xa95a('0x48')]=_0x1c6731;return _0x1984f4;});}})[_0xa95a('0x28')](respondWithFilteredResult(_0x27ceeb,_0x111519))[_0xa95a('0x49')](handleError(_0x27ceeb,null));};function char(_0x1aac1f){return _0xa95a('0x62')===typeof _0x1aac1f?String[_0xa95a('0x63')]['apply'](null,arguments):_0x1aac1f;}function needsEncapsulation(_0x2317d6){return!!_0x2317d6&&(_0x2317d6[_0xa95a('0x64')]()[_0xa95a('0x65')](char(0xd))>=0x0||_0x2317d6[_0xa95a('0x64')]()['indexOf'](char(0xa))>=0x0||_0x2317d6['toString']()['indexOf'](char(0x2c))>=0x0||_0x2317d6[_0xa95a('0x64')]()[_0xa95a('0x65')](char(0x22))>=0x0);}function encapsulate(_0x5ce647){var _0x13516e=char(0x22),_0x5e6841='\x5c'+char(0x22),_0x12bc64=_0x5ce647[_0xa95a('0x64')]()[_0xa95a('0x66')](new RegExp(_0x13516e,'g'),_0x5e6841);return _0x13516e+_0x12bc64+_0x13516e;}exports['getSummary']=function(_0x1f97dd,_0x33dbdb,_0x4010e5){var _0x14ca65,_0x495257;var _0x56f5a2={'where':{'ProjectId':_0x1f97dd[_0xa95a('0x4b')]['id']}};if(_0x1f97dd['query'][_0xa95a('0x67')]){_0x56f5a2[_0xa95a('0x5c')]['starttime']=JSON[_0xa95a('0x68')](_0x1f97dd[_0xa95a('0x36')][_0xa95a('0x67')]);}return db[_0xa95a('0x5a')][_0xa95a('0x47')](_0x56f5a2)[_0xa95a('0x28')](handleEntityNotFound(_0x33dbdb,null))[_0xa95a('0x28')](function(_0x4f7eb4){if(_0x4f7eb4){_0x14ca65=_0x4f7eb4;return db['JscriptyQuestionReport'][_0xa95a('0x47')]({'where':{'SessionId':{'$in':_[_0xa95a('0x30')](_0x14ca65,'id')},'ProjectId':_0x1f97dd['params']['id']},'order':'-createdAt'});}})['then'](handleEntityNotFound(_0x33dbdb,null))[_0xa95a('0x28')](function(_0x475913){if(_0x475913){_0x495257=_0x475913;var _0x14a8d7={};for(var _0x70499f=0x0,_0x1282bb=_0x495257[_0xa95a('0x3c')];_0x70499f<_0x1282bb;_0x70499f++){if(!_0x14a8d7['hasOwnProperty'](_0x495257[_0x70499f][_0xa95a('0x69')])){_0x14a8d7[_0x495257[_0x70499f][_0xa95a('0x69')]]=needsEncapsulation(_0x495257[_0x70499f][_0xa95a('0x6a')])?encapsulate(_0x495257[_0x70499f]['question']):_0x495257[_0x70499f][_0xa95a('0x6a')];}}var _0x5379d9=[],_0x340255={};for(var _0x4c9632=0x0,_0xb6e6b6=_0x14ca65[_0xa95a('0x3c')];_0x4c9632<_0xb6e6b6;_0x4c9632++){_0x340255={'ProjectId':_0x1f97dd[_0xa95a('0x4b')]['id'],'SessionId':_0x14ca65[_0x4c9632]['id'],'StartTime':moment(_0x14ca65[_0x4c9632][_0xa95a('0x6b')])[_0xa95a('0x6c')]('YYYY-MM-DD\x20HH:mm:ss')};for(var _0x1d0648=0x0,_0x50bb13=_0x495257[_0xa95a('0x3c')];_0x1d0648<_0x50bb13;_0x1d0648++){if(_0x495257[_0x1d0648][_0xa95a('0x6d')]==_0x14ca65[_0x4c9632]['id']&&_0x14a8d7[_0xa95a('0x3d')](_0x495257[_0x1d0648]['questionId'])){_0x340255[_0x14a8d7[_0x495257[_0x1d0648][_0xa95a('0x69')]]]=_0x495257[_0x1d0648][_0xa95a('0x6e')];}}for(var _0x38b71a in _0x14a8d7){if(!_0x340255[_0xa95a('0x3d')](_0x14a8d7[_0x38b71a])){_0x340255[_0x14a8d7[_0x38b71a]]=null;}}_0x5379d9[_0xa95a('0x6f')](_0x340255);}return _0x5379d9;}})[_0xa95a('0x28')](function(_0x28b90e){if(!_[_0xa95a('0x70')](_0x28b90e)){var _0x59e3a8=toCsv(_0x28b90e);var _0x26f48e=Date['now']();fs[_0xa95a('0x71')](util[_0xa95a('0x6c')](_0xa95a('0x72'),_0x1f97dd[_0xa95a('0x4b')]['id'],_0x26f48e),_0x59e3a8);_0x33dbdb[_0xa95a('0x73')](_0xa95a('0x74'),_0xa95a('0x75')+util[_0xa95a('0x6c')](_0xa95a('0x76'),_0x1f97dd['params']['id'],_0x26f48e));_0x33dbdb[_0xa95a('0x73')](_0xa95a('0x77'),_0xa95a('0x78'));return _0x33dbdb[_0xa95a('0x79')](util[_0xa95a('0x6c')](_0xa95a('0x72'),_0x1f97dd[_0xa95a('0x4b')]['id'],_0x26f48e));}else{return _0x33dbdb['sendStatus'](0xcc);}})[_0xa95a('0x49')](handleError(_0x33dbdb,null));};
\ No newline at end of file
+var _0x1691=['JscriptySessionReport','nolimit','order','ProjectId','getAnswers','JscriptyAnswerReport','number','fromCharCode','indexOf','toString','replace','startTime','starttime','JscriptyQuestionReport','-createdAt','questionId','question','format','SessionId','answer','push','isEmpty','Content-disposition','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','setHeader','Content-type','download','/tmp/Jscripty_Project_%d_Summary_%s.csv','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','ejs','lodash','crypto','jsforce','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/environment','../../config/license/util','status','end','json','offset','undefined','limit','count','Content-Range','apply','reject','save','update','then','get','destroy','error','stack','name','map','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','sort','pick','filter','where','type','options','include','JscriptyProject','findAll','rows','catch','show','rawAttributes','includeAll','merge','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Projects','UserProfileSection','find','userProfileId','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','updatedAt','params','getSessions','findOne'];(function(_0x31eb67,_0x9bc8c0){var _0x2a8cb8=function(_0xac1c5d){while(--_0xac1c5d){_0x31eb67['push'](_0x31eb67['shift']());}};_0x2a8cb8(++_0x9bc8c0);}(_0x1691,0x1ed));var _0x1169=function(_0x7b4f57,_0x2e96ed){_0x7b4f57=_0x7b4f57-0x0;var _0x544daa=_0x1691[_0x7b4f57];return _0x544daa;};'use strict';var emlformat=require(_0x1169('0x0'));var rimraf=require(_0x1169('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x1169('0x2'));var rp=require(_0x1169('0x3'));var moment=require(_0x1169('0x4'));var BPromise=require(_0x1169('0x5'));var Mustache=require(_0x1169('0x6'));var util=require(_0x1169('0x7'));var path=require(_0x1169('0x8'));var sox=require(_0x1169('0x9'));var csv=require('to-csv');var ejs=require(_0x1169('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x1169('0xb'));var squel=require('squel');var crypto=require(_0x1169('0xc'));var jsforce=require(_0x1169('0xd'));var deskjs=require('desk.js');var toCsv=require(_0x1169('0xe'));var querystring=require(_0x1169('0xf'));var Papa=require(_0x1169('0x10'));var Redis=require(_0x1169('0x11'));var authService=require(_0x1169('0x12'));var qs=require('../../components/parsers/qs');var as=require(_0x1169('0x13'));var hardwareService=require(_0x1169('0x14'));var logger=require('../../config/logger')(_0x1169('0x15'));var utils=require('../../config/utils');var config=require(_0x1169('0x16'));var licenseUtil=require(_0x1169('0x17'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x5b5d9b,_0x4f431e){_0x4f431e=_0x4f431e||0xcc;return function(_0x1a9f2b){if(_0x1a9f2b){return _0x5b5d9b['sendStatus'](_0x4f431e);}return _0x5b5d9b[_0x1169('0x18')](_0x4f431e)[_0x1169('0x19')]();};}function respondWithResult(_0x54ad46,_0x18ba76){_0x18ba76=_0x18ba76||0xc8;return function(_0x32636b){if(_0x32636b){return _0x54ad46[_0x1169('0x18')](_0x18ba76)[_0x1169('0x1a')](_0x32636b);}};}function respondWithFilteredResult(_0x4fc690,_0x4c4b90){return function(_0x34462b){if(_0x34462b){var _0x31a3e9=typeof _0x4c4b90[_0x1169('0x1b')]===_0x1169('0x1c')&&typeof _0x4c4b90[_0x1169('0x1d')]===_0x1169('0x1c');var _0x226420=_0x34462b[_0x1169('0x1e')];var _0x5f216f=_0x31a3e9?0x0:_0x4c4b90[_0x1169('0x1b')];var _0x51674a=_0x31a3e9?_0x34462b[_0x1169('0x1e')]:_0x4c4b90['offset']+_0x4c4b90['limit'];var _0x9c68cb;if(_0x51674a>=_0x226420){_0x51674a=_0x226420;_0x9c68cb=0xc8;}else{_0x9c68cb=0xce;}_0x4fc690['status'](_0x9c68cb);return _0x4fc690['set'](_0x1169('0x1f'),_0x5f216f+'-'+_0x51674a+'/'+_0x226420)['json'](_0x34462b);}return null;};}function patchUpdates(_0x3e6e45){return function(_0xba82ee){try{jsonpatch[_0x1169('0x20')](_0xba82ee,_0x3e6e45,!![]);}catch(_0x1b6af6){return BPromise[_0x1169('0x21')](_0x1b6af6);}return _0xba82ee[_0x1169('0x22')]();};}function saveUpdates(_0x38b4b1,_0x3c342e){return function(_0x594ac4){if(_0x594ac4){return _0x594ac4[_0x1169('0x23')](_0x38b4b1)[_0x1169('0x24')](function(_0x301646){return _0x301646;});}return null;};}function removeEntity(_0x277f69,_0x21e826){return function(_0x51040d){if(_0x51040d){return _0x51040d['destroy']()[_0x1169('0x24')](function(){var _0x5e235c=_0x51040d[_0x1169('0x25')]({'plain':!![]});var _0x428498='Projects';return db['UserProfileResource'][_0x1169('0x26')]({'where':{'type':_0x428498,'resourceId':_0x5e235c['id']}})[_0x1169('0x24')](function(){return _0x51040d;});})[_0x1169('0x24')](function(){_0x277f69['status'](0xcc)[_0x1169('0x19')]();});}};}function handleEntityNotFound(_0x3172c2,_0x494e2a){return function(_0x4edcac){if(!_0x4edcac){_0x3172c2['sendStatus'](0x194);}return _0x4edcac;};}function handleError(_0x4d89c7,_0xa60282){_0xa60282=_0xa60282||0x1f4;return function(_0x1c5499){logger[_0x1169('0x27')](_0x1c5499[_0x1169('0x28')]);if(_0x1c5499[_0x1169('0x29')]){delete _0x1c5499[_0x1169('0x29')];}_0x4d89c7[_0x1169('0x18')](_0xa60282)['send'](_0x1c5499);};}exports['index']=function(_0x40fa6d,_0x12edc7){var _0x23f6a7={},_0x44696c={},_0x44c0aa={'count':0x0,'rows':[]};var _0x4013f0=_[_0x1169('0x2a')](db['JscriptyProject']['rawAttributes'],function(_0x582758){return{'name':_0x582758['fieldName'],'type':_0x582758['type'][_0x1169('0x2b')]};});_0x44696c[_0x1169('0x2c')]=_[_0x1169('0x2a')](_0x4013f0,'name');_0x44696c[_0x1169('0x2d')]=_[_0x1169('0x2e')](_0x40fa6d[_0x1169('0x2d')]);_0x44696c[_0x1169('0x2f')]=_[_0x1169('0x30')](_0x44696c[_0x1169('0x2c')],_0x44696c[_0x1169('0x2d')]);_0x23f6a7[_0x1169('0x31')]=_[_0x1169('0x30')](_0x44696c[_0x1169('0x2c')],qs[_0x1169('0x32')](_0x40fa6d['query']['fields']));_0x23f6a7[_0x1169('0x31')]=_0x23f6a7['attributes'][_0x1169('0x33')]?_0x23f6a7[_0x1169('0x31')]:_0x44696c[_0x1169('0x2c')];if(!_0x40fa6d[_0x1169('0x2d')][_0x1169('0x34')]('nolimit')){_0x23f6a7[_0x1169('0x1d')]=qs['limit'](_0x40fa6d[_0x1169('0x2d')]['limit']);_0x23f6a7[_0x1169('0x1b')]=qs[_0x1169('0x1b')](_0x40fa6d[_0x1169('0x2d')][_0x1169('0x1b')]);}_0x23f6a7['order']=qs[_0x1169('0x35')](_0x40fa6d[_0x1169('0x2d')][_0x1169('0x35')]);_0x23f6a7['where']=qs['filters'](_[_0x1169('0x36')](_0x40fa6d[_0x1169('0x2d')],_0x44696c[_0x1169('0x2f')]),_0x4013f0);if(_0x40fa6d[_0x1169('0x2d')][_0x1169('0x37')]){_0x23f6a7[_0x1169('0x38')]=_['merge'](_0x23f6a7[_0x1169('0x38')],{'$or':_['map'](_0x4013f0,function(_0x2a307a){if(_0x2a307a[_0x1169('0x39')]!=='VIRTUAL'){var _0x120815={};_0x120815[_0x2a307a[_0x1169('0x29')]]={'$like':'%'+_0x40fa6d[_0x1169('0x2d')][_0x1169('0x37')]+'%'};return _0x120815;}})});}_0x23f6a7=_['merge']({},_0x23f6a7,_0x40fa6d[_0x1169('0x3a')]);var _0x8c4e97={'where':_0x23f6a7['where']};return db['JscriptyProject'][_0x1169('0x1e')](_0x8c4e97)[_0x1169('0x24')](function(_0x488025){_0x44c0aa['count']=_0x488025;if(_0x40fa6d['query']['includeAll']){_0x23f6a7[_0x1169('0x3b')]=[{'all':!![]}];}return db[_0x1169('0x3c')][_0x1169('0x3d')](_0x23f6a7);})[_0x1169('0x24')](function(_0x2ea766){_0x44c0aa[_0x1169('0x3e')]=_0x2ea766;return _0x44c0aa;})[_0x1169('0x24')](respondWithFilteredResult(_0x12edc7,_0x23f6a7))[_0x1169('0x3f')](handleError(_0x12edc7,null));};exports[_0x1169('0x40')]=function(_0x2e7d6b,_0xbc8661){var _0xef52fc={'raw':![],'where':{'id':_0x2e7d6b['params']['id']}},_0x255fc3={};_0x255fc3[_0x1169('0x2c')]=_[_0x1169('0x2e')](db[_0x1169('0x3c')][_0x1169('0x41')]);_0x255fc3[_0x1169('0x2d')]=_['keys'](_0x2e7d6b['query']);_0x255fc3[_0x1169('0x2f')]=_[_0x1169('0x30')](_0x255fc3[_0x1169('0x2c')],_0x255fc3[_0x1169('0x2d')]);_0xef52fc[_0x1169('0x31')]=_['intersection'](_0x255fc3['model'],qs[_0x1169('0x32')](_0x2e7d6b['query']['fields']));_0xef52fc[_0x1169('0x31')]=_0xef52fc[_0x1169('0x31')]['length']?_0xef52fc[_0x1169('0x31')]:_0x255fc3['model'];if(_0x2e7d6b[_0x1169('0x2d')][_0x1169('0x42')]){_0xef52fc['include']=[{'all':!![]}];}_0xef52fc=_[_0x1169('0x43')]({},_0xef52fc,_0x2e7d6b[_0x1169('0x3a')]);return db[_0x1169('0x3c')]['find'](_0xef52fc)[_0x1169('0x24')](handleEntityNotFound(_0xbc8661,null))[_0x1169('0x24')](respondWithResult(_0xbc8661,null))[_0x1169('0x3f')](handleError(_0xbc8661,null));};exports[_0x1169('0x44')]=function(_0x511eaa,_0x3160d2){return db[_0x1169('0x3c')][_0x1169('0x44')](_0x511eaa[_0x1169('0x45')],{})[_0x1169('0x24')](function(_0x27b2f1){var _0x2676f1=_0x511eaa[_0x1169('0x46')][_0x1169('0x25')]({'plain':!![]});if(!_0x2676f1)throw new Error(_0x1169('0x47'));if(_0x2676f1[_0x1169('0x48')]==='user'){var _0x23d3bb=_0x27b2f1[_0x1169('0x25')]({'plain':!![]});var _0x5f3e39=_0x1169('0x49');return db[_0x1169('0x4a')][_0x1169('0x4b')]({'where':{'name':_0x5f3e39,'userProfileId':_0x2676f1[_0x1169('0x4c')]},'raw':!![]})[_0x1169('0x24')](function(_0x54164d){if(_0x54164d&&_0x54164d[_0x1169('0x4d')]===0x0){return db[_0x1169('0x4e')][_0x1169('0x44')]({'name':_0x23d3bb[_0x1169('0x29')],'resourceId':_0x23d3bb['id'],'type':_0x54164d[_0x1169('0x29')],'sectionId':_0x54164d['id']},{})['then'](function(){return _0x27b2f1;});}else{return _0x27b2f1;}})[_0x1169('0x3f')](function(_0xb8bec8){logger[_0x1169('0x27')](_0x1169('0x4f'),_0xb8bec8);throw _0xb8bec8;});}return _0x27b2f1;})[_0x1169('0x24')](respondWithResult(_0x3160d2,0xc9))[_0x1169('0x3f')](handleError(_0x3160d2,null));};exports[_0x1169('0x50')]=function(_0x2863f9,_0x4ede5a){var _0xe6897a={'where':{'id':_0x2863f9['params']['id']}},_0x590536={};_0x590536[_0x1169('0x2c')]=_[_0x1169('0x2e')](db[_0x1169('0x3c')][_0x1169('0x41')]);_0xe6897a[_0x1169('0x31')]=_['intersection'](_0x590536[_0x1169('0x2c')],qs[_0x1169('0x32')](_0x2863f9[_0x1169('0x2d')][_0x1169('0x32')]));_0xe6897a[_0x1169('0x31')]=_0xe6897a[_0x1169('0x31')][_0x1169('0x33')]?_0xe6897a[_0x1169('0x31')]:_0x590536['model'];if(_0x2863f9[_0x1169('0x2d')][_0x1169('0x42')]){_0xe6897a['include']=[{'all':!![]}];}_0xe6897a=_['merge']({},_0xe6897a,_0x2863f9[_0x1169('0x3a')]);return db[_0x1169('0x3c')][_0x1169('0x4b')](_0xe6897a)['then'](handleEntityNotFound(_0x4ede5a,null))[_0x1169('0x24')](function(_0x19e50c){if(_0x19e50c){var _0x4f6932=_0x19e50c[_0x1169('0x25')]({'plain':!![]});_0x4f6932=qs[_0x1169('0x51')](_0x4f6932,['id',_0x1169('0x52'),_0x1169('0x53')]);_0x2863f9[_0x1169('0x45')]=_[_0x1169('0x51')](_0x2863f9[_0x1169('0x45')],['id','createdAt','updatedAt']);return db[_0x1169('0x3c')][_0x1169('0x44')](_[_0x1169('0x43')](_0x4f6932,_0x2863f9[_0x1169('0x45')]),{'include':_0x2863f9[_0x1169('0x2d')][_0x1169('0x42')]?[{'all':!![]}]:undefined})[_0x1169('0x24')](function(_0x1bd652){var _0x5c2437=_0x2863f9[_0x1169('0x46')]['get']({'plain':!![]});if(!_0x5c2437)throw new Error(_0x1169('0x47'));if(_0x5c2437[_0x1169('0x48')]===_0x1169('0x46')){var _0x5da8ef=_0x1bd652['get']({'plain':!![]});var _0x2cf9b7=_0x1169('0x49');return db[_0x1169('0x4a')][_0x1169('0x4b')]({'where':{'name':_0x2cf9b7,'userProfileId':_0x5c2437[_0x1169('0x4c')]},'raw':!![]})[_0x1169('0x24')](function(_0x4737f6){if(_0x4737f6&&_0x4737f6[_0x1169('0x4d')]===0x0){return db[_0x1169('0x4e')][_0x1169('0x44')]({'name':_0x5da8ef['name'],'resourceId':_0x5da8ef['id'],'type':_0x4737f6[_0x1169('0x29')],'sectionId':_0x4737f6['id']},{})[_0x1169('0x24')](function(){return _0x1bd652;});}else{return _0x1bd652;}})[_0x1169('0x3f')](function(_0x1bdb56){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x1bdb56);throw _0x1bdb56;});}return _0x1bd652;});}})[_0x1169('0x24')](respondWithResult(_0x4ede5a,0xc9))[_0x1169('0x3f')](handleError(_0x4ede5a,null));};exports['update']=function(_0x156d74,_0x2a2f83){if(_0x156d74[_0x1169('0x45')]['id']){delete _0x156d74['body']['id'];}return db['JscriptyProject'][_0x1169('0x4b')]({'where':{'id':_0x156d74[_0x1169('0x54')]['id']}})[_0x1169('0x24')](handleEntityNotFound(_0x2a2f83,null))[_0x1169('0x24')](saveUpdates(_0x156d74[_0x1169('0x45')],null))[_0x1169('0x24')](respondWithResult(_0x2a2f83,null))['catch'](handleError(_0x2a2f83,null));};exports['destroy']=function(_0x3e0cb0,_0xd97aa8){return db['JscriptyProject'][_0x1169('0x4b')]({'where':{'id':_0x3e0cb0[_0x1169('0x54')]['id']}})['then'](handleEntityNotFound(_0xd97aa8,null))[_0x1169('0x24')](removeEntity(_0xd97aa8,null))[_0x1169('0x3f')](handleError(_0xd97aa8,null));};exports[_0x1169('0x55')]=function(_0x19e7b8,_0x3e8114,_0x10b230){var _0x3b67c0={'raw':!![],'where':{}};var _0x51e5a6={};var _0x58d4bd={'count':0x0,'rows':[]};return db['JscriptyProject'][_0x1169('0x56')]({'where':{'id':_0x19e7b8[_0x1169('0x54')]['id']}})[_0x1169('0x24')](handleEntityNotFound(_0x3e8114,null))[_0x1169('0x24')](function(_0x3ac07d){if(_0x3ac07d){_0x51e5a6[_0x1169('0x2c')]=_['keys'](db[_0x1169('0x57')][_0x1169('0x41')]);_0x51e5a6['query']=_[_0x1169('0x2e')](_0x19e7b8[_0x1169('0x2d')]);_0x51e5a6[_0x1169('0x2f')]=_[_0x1169('0x30')](_0x51e5a6[_0x1169('0x2c')],_0x51e5a6[_0x1169('0x2d')]);_0x3b67c0['attributes']=_[_0x1169('0x30')](_0x51e5a6[_0x1169('0x2c')],qs[_0x1169('0x32')](_0x19e7b8['query'][_0x1169('0x32')]));_0x3b67c0['attributes']=_0x3b67c0['attributes'][_0x1169('0x33')]?_0x3b67c0[_0x1169('0x31')]:_0x51e5a6[_0x1169('0x2c')];if(!_0x19e7b8['query'][_0x1169('0x34')](_0x1169('0x58'))){_0x3b67c0[_0x1169('0x1d')]=qs[_0x1169('0x1d')](_0x19e7b8[_0x1169('0x2d')][_0x1169('0x1d')]);_0x3b67c0['offset']=qs[_0x1169('0x1b')](_0x19e7b8['query']['offset']);}_0x3b67c0[_0x1169('0x59')]=qs[_0x1169('0x35')](_0x19e7b8[_0x1169('0x2d')]['sort']);_0x3b67c0[_0x1169('0x38')]=qs[_0x1169('0x2f')](_[_0x1169('0x36')](_0x19e7b8[_0x1169('0x2d')],_0x51e5a6[_0x1169('0x2f')]));_0x3b67c0[_0x1169('0x38')][_0x1169('0x5a')]=_0x3ac07d['id'];if(_0x19e7b8['query'][_0x1169('0x37')]){_0x3b67c0[_0x1169('0x38')]=_[_0x1169('0x43')](_0x3b67c0[_0x1169('0x38')],{'$or':_[_0x1169('0x2a')](_0x3b67c0[_0x1169('0x31')],function(_0x28f45c){var _0x24979b={};_0x24979b[_0x28f45c]={'$like':'%'+_0x19e7b8[_0x1169('0x2d')][_0x1169('0x37')]+'%'};return _0x24979b;})});}_0x3b67c0=_[_0x1169('0x43')]({},_0x3b67c0,_0x19e7b8[_0x1169('0x3a')]);return db[_0x1169('0x57')][_0x1169('0x1e')]({'where':_0x3b67c0[_0x1169('0x38')]})[_0x1169('0x24')](function(_0x52314b){_0x58d4bd[_0x1169('0x1e')]=_0x52314b;if(_0x19e7b8[_0x1169('0x2d')][_0x1169('0x42')]){_0x3b67c0[_0x1169('0x3b')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0x1169('0x3d')](_0x3b67c0);})[_0x1169('0x24')](function(_0x1585fe){_0x58d4bd[_0x1169('0x3e')]=_0x1585fe;return _0x58d4bd;});}})['then'](respondWithFilteredResult(_0x3e8114,_0x3b67c0))[_0x1169('0x3f')](handleError(_0x3e8114,null));};exports[_0x1169('0x5b')]=function(_0x10847e,_0x2ee5e3,_0x5ece74){var _0x1a3c90={'raw':!![],'where':{}};var _0x5159ab={};var _0x36fbfd={'count':0x0,'rows':[]};return db[_0x1169('0x3c')][_0x1169('0x56')]({'where':{'id':_0x10847e[_0x1169('0x54')]['id']}})[_0x1169('0x24')](handleEntityNotFound(_0x2ee5e3,null))[_0x1169('0x24')](function(_0xfaa12c){if(_0xfaa12c){_0x5159ab[_0x1169('0x2c')]=_[_0x1169('0x2e')](db[_0x1169('0x5c')]['rawAttributes']);_0x5159ab[_0x1169('0x2d')]=_[_0x1169('0x2e')](_0x10847e[_0x1169('0x2d')]);_0x5159ab[_0x1169('0x2f')]=_[_0x1169('0x30')](_0x5159ab[_0x1169('0x2c')],_0x5159ab[_0x1169('0x2d')]);_0x1a3c90[_0x1169('0x31')]=_[_0x1169('0x30')](_0x5159ab[_0x1169('0x2c')],qs[_0x1169('0x32')](_0x10847e[_0x1169('0x2d')][_0x1169('0x32')]));_0x1a3c90[_0x1169('0x31')]=_0x1a3c90[_0x1169('0x31')][_0x1169('0x33')]?_0x1a3c90[_0x1169('0x31')]:_0x5159ab['model'];if(!_0x10847e['query'][_0x1169('0x34')](_0x1169('0x58'))){_0x1a3c90[_0x1169('0x1d')]=qs[_0x1169('0x1d')](_0x10847e[_0x1169('0x2d')]['limit']);_0x1a3c90[_0x1169('0x1b')]=qs['offset'](_0x10847e['query'][_0x1169('0x1b')]);}_0x1a3c90[_0x1169('0x59')]=qs[_0x1169('0x35')](_0x10847e['query'][_0x1169('0x35')]);_0x1a3c90[_0x1169('0x38')]=qs[_0x1169('0x2f')](_[_0x1169('0x36')](_0x10847e['query'],_0x5159ab[_0x1169('0x2f')]));_0x1a3c90[_0x1169('0x38')][_0x1169('0x5a')]=_0xfaa12c['id'];if(_0x10847e['query'][_0x1169('0x37')]){_0x1a3c90['where']=_[_0x1169('0x43')](_0x1a3c90[_0x1169('0x38')],{'$or':_['map'](_0x1a3c90['attributes'],function(_0xd6ef34){var _0x58740d={};_0x58740d[_0xd6ef34]={'$like':'%'+_0x10847e[_0x1169('0x2d')][_0x1169('0x37')]+'%'};return _0x58740d;})});}_0x1a3c90=_[_0x1169('0x43')]({},_0x1a3c90,_0x10847e['options']);return db[_0x1169('0x5c')][_0x1169('0x1e')]({'where':_0x1a3c90[_0x1169('0x38')]})[_0x1169('0x24')](function(_0x4d3dfc){_0x36fbfd[_0x1169('0x1e')]=_0x4d3dfc;if(_0x10847e['query'][_0x1169('0x42')]){_0x1a3c90[_0x1169('0x3b')]=[{'all':!![]}];}return db[_0x1169('0x5c')][_0x1169('0x3d')](_0x1a3c90);})['then'](function(_0x496e54){_0x36fbfd[_0x1169('0x3e')]=_0x496e54;return _0x36fbfd;});}})[_0x1169('0x24')](respondWithFilteredResult(_0x2ee5e3,_0x1a3c90))[_0x1169('0x3f')](handleError(_0x2ee5e3,null));};function char(_0x2f8ad5){return _0x1169('0x5d')===typeof _0x2f8ad5?String[_0x1169('0x5e')][_0x1169('0x20')](null,arguments):_0x2f8ad5;}function needsEncapsulation(_0x34f006){return!!_0x34f006&&(_0x34f006['toString']()[_0x1169('0x5f')](char(0xd))>=0x0||_0x34f006[_0x1169('0x60')]()[_0x1169('0x5f')](char(0xa))>=0x0||_0x34f006[_0x1169('0x60')]()[_0x1169('0x5f')](char(0x2c))>=0x0||_0x34f006[_0x1169('0x60')]()[_0x1169('0x5f')](char(0x22))>=0x0);}function encapsulate(_0x49fbd4){var _0x2bb509=char(0x22),_0x131d83='\x5c'+char(0x22),_0x19dd17=_0x49fbd4[_0x1169('0x60')]()[_0x1169('0x61')](new RegExp(_0x2bb509,'g'),_0x131d83);return _0x2bb509+_0x19dd17+_0x2bb509;}exports['getSummary']=function(_0x1d4bfc,_0x44b712,_0x325b5b){var _0x1776da,_0x40b47f;var _0x20a3a0={'where':{'ProjectId':_0x1d4bfc['params']['id']}};if(_0x1d4bfc[_0x1169('0x2d')][_0x1169('0x62')]){_0x20a3a0[_0x1169('0x38')][_0x1169('0x63')]=JSON['parse'](_0x1d4bfc[_0x1169('0x2d')]['startTime']);}return db[_0x1169('0x57')][_0x1169('0x3d')](_0x20a3a0)['then'](handleEntityNotFound(_0x44b712,null))[_0x1169('0x24')](function(_0x424ccc){if(_0x424ccc){_0x1776da=_0x424ccc;return db[_0x1169('0x64')][_0x1169('0x3d')]({'where':{'SessionId':{'$in':_[_0x1169('0x2a')](_0x1776da,'id')},'ProjectId':_0x1d4bfc[_0x1169('0x54')]['id']},'order':_0x1169('0x65')});}})[_0x1169('0x24')](handleEntityNotFound(_0x44b712,null))['then'](function(_0x23a2ba){if(_0x23a2ba){_0x40b47f=_0x23a2ba;var _0x5290a0={};for(var _0x2f097e=0x0,_0x11e7d0=_0x40b47f[_0x1169('0x33')];_0x2f097e<_0x11e7d0;_0x2f097e++){if(!_0x5290a0[_0x1169('0x34')](_0x40b47f[_0x2f097e][_0x1169('0x66')])){_0x5290a0[_0x40b47f[_0x2f097e][_0x1169('0x66')]]=needsEncapsulation(_0x40b47f[_0x2f097e][_0x1169('0x67')])?encapsulate(_0x40b47f[_0x2f097e]['question']):_0x40b47f[_0x2f097e]['question'];}}var _0x1dbe5b=[],_0x1e0f78={};for(var _0x27805f=0x0,_0x105ad1=_0x1776da[_0x1169('0x33')];_0x27805f<_0x105ad1;_0x27805f++){_0x1e0f78={'ProjectId':_0x1d4bfc[_0x1169('0x54')]['id'],'SessionId':_0x1776da[_0x27805f]['id'],'StartTime':moment(_0x1776da[_0x27805f][_0x1169('0x63')])[_0x1169('0x68')]('YYYY-MM-DD\x20HH:mm:ss')};for(var _0x39a7b0=0x0,_0x299b63=_0x40b47f[_0x1169('0x33')];_0x39a7b0<_0x299b63;_0x39a7b0++){if(_0x40b47f[_0x39a7b0][_0x1169('0x69')]==_0x1776da[_0x27805f]['id']&&_0x5290a0['hasOwnProperty'](_0x40b47f[_0x39a7b0][_0x1169('0x66')])){_0x1e0f78[_0x5290a0[_0x40b47f[_0x39a7b0]['questionId']]]=_0x40b47f[_0x39a7b0][_0x1169('0x6a')];}}for(var _0x10c81e in _0x5290a0){if(!_0x1e0f78[_0x1169('0x34')](_0x5290a0[_0x10c81e])){_0x1e0f78[_0x5290a0[_0x10c81e]]=null;}}_0x1dbe5b[_0x1169('0x6b')](_0x1e0f78);}return _0x1dbe5b;}})['then'](function(_0x458107){if(!_[_0x1169('0x6c')](_0x458107)){var _0x4a8597=toCsv(_0x458107);var _0x4ba64d=Date['now']();fs['writeFileSync'](util[_0x1169('0x68')]('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x1d4bfc[_0x1169('0x54')]['id'],_0x4ba64d),_0x4a8597);_0x44b712['setHeader'](_0x1169('0x6d'),_0x1169('0x6e')+util[_0x1169('0x68')](_0x1169('0x6f'),_0x1d4bfc[_0x1169('0x54')]['id'],_0x4ba64d));_0x44b712[_0x1169('0x70')](_0x1169('0x71'),'text/csv');return _0x44b712[_0x1169('0x72')](util[_0x1169('0x68')](_0x1169('0x73'),_0x1d4bfc[_0x1169('0x54')]['id'],_0x4ba64d));}else{return _0x44b712['sendStatus'](0xcc);}})[_0x1169('0x3f')](handleError(_0x44b712,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff