// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xceab=['indexOf','replace','startTime','starttime','parse','JscriptyQuestionReport','-createdAt','question','YYYY-MM-DD\x20HH:mm:ss','SessionId','questionId','push','isEmpty','writeFileSync','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','Content-disposition','attachment;\x20filename=','format','Jscripty_Project_%d_Summary_%s.csv','text/csv','download','eml-format','zip-dir','fast-json-patch','moment','bluebird','util','path','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','status','json','undefined','offset','count','limit','set','Content-Range','apply','reject','save','then','get','Projects','UserProfileResource','destroy','end','sendStatus','error','stack','name','send','index','rawAttributes','fieldName','type','key','model','keys','query','filters','intersection','attributes','fields','nolimit','order','sort','pick','filter','where','merge','map','VIRTUAL','JscriptyProject','includeAll','include','catch','show','params','length','find','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','user','UserProfileSection','autoAssociation','clone','omit','createdAt','updatedAt','role','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','findOne','JscriptySessionReport','hasOwnProperty','ProjectId','options','findAll','rows','getAnswers','JscriptyAnswerReport','toString'];(function(_0x16cb82,_0x2bc17f){var _0x353e1a=function(_0xda4d3f){while(--_0xda4d3f){_0x16cb82['push'](_0x16cb82['shift']());}};_0x353e1a(++_0x2bc17f);}(_0xceab,0x106));var _0xbcea=function(_0x2b020c,_0x22216a){_0x2b020c=_0x2b020c-0x0;var _0x276d93=_0xceab[_0x2b020c];return _0x276d93;};'use strict';var emlformat=require(_0xbcea('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xbcea('0x1'));var jsonpatch=require(_0xbcea('0x2'));var rp=require('request-promise');var moment=require(_0xbcea('0x3'));var BPromise=require(_0xbcea('0x4'));var Mustache=require('mustache');var util=require(_0xbcea('0x5'));var path=require(_0xbcea('0x6'));var sox=require('sox');var csv=require(_0xbcea('0x7'));var ejs=require(_0xbcea('0x8'));var fs=require('fs');var fs_extra=require(_0xbcea('0x9'));var _=require(_0xbcea('0xa'));var squel=require(_0xbcea('0xb'));var crypto=require('crypto');var jsforce=require(_0xbcea('0xc'));var deskjs=require(_0xbcea('0xd'));var toCsv=require(_0xbcea('0x7'));var querystring=require(_0xbcea('0xe'));var Papa=require(_0xbcea('0xf'));var Redis=require('ioredis');var authService=require(_0xbcea('0x10'));var qs=require('../../components/parsers/qs');var as=require(_0xbcea('0x11'));var hardwareService=require(_0xbcea('0x12'));var logger=require(_0xbcea('0x13'))(_0xbcea('0x14'));var utils=require(_0xbcea('0x15'));var config=require(_0xbcea('0x16'));var licenseUtil=require(_0xbcea('0x17'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x24822a,_0x365160){_0x365160=_0x365160||0xcc;return function(_0x39dde5){if(_0x39dde5){return _0x24822a['sendStatus'](_0x365160);}return _0x24822a[_0xbcea('0x18')](_0x365160)['end']();};}function respondWithResult(_0x47b444,_0xd2be3c){_0xd2be3c=_0xd2be3c||0xc8;return function(_0x3ae03e){if(_0x3ae03e){return _0x47b444[_0xbcea('0x18')](_0xd2be3c)[_0xbcea('0x19')](_0x3ae03e);}};}function respondWithFilteredResult(_0x419364,_0x326814){return function(_0x4f205f){if(_0x4f205f){var _0x407cda=typeof _0x326814['offset']==='undefined'&&typeof _0x326814['limit']===_0xbcea('0x1a');var _0x1487d8=_0x4f205f['count'];var _0x3d68f0=_0x407cda?0x0:_0x326814[_0xbcea('0x1b')];var _0x356754=_0x407cda?_0x4f205f[_0xbcea('0x1c')]:_0x326814[_0xbcea('0x1b')]+_0x326814[_0xbcea('0x1d')];var _0x3466bb;if(_0x356754>=_0x1487d8){_0x356754=_0x1487d8;_0x3466bb=0xc8;}else{_0x3466bb=0xce;}_0x419364[_0xbcea('0x18')](_0x3466bb);return _0x419364[_0xbcea('0x1e')](_0xbcea('0x1f'),_0x3d68f0+'-'+_0x356754+'/'+_0x1487d8)[_0xbcea('0x19')](_0x4f205f);}return null;};}function patchUpdates(_0x4bae81){return function(_0x2f133b){try{jsonpatch[_0xbcea('0x20')](_0x2f133b,_0x4bae81,!![]);}catch(_0x5c3c29){return BPromise[_0xbcea('0x21')](_0x5c3c29);}return _0x2f133b[_0xbcea('0x22')]();};}function saveUpdates(_0x4350a8,_0x3eb213){return function(_0x4cb14f){if(_0x4cb14f){return _0x4cb14f['update'](_0x4350a8)[_0xbcea('0x23')](function(_0x2465bc){return _0x2465bc;});}return null;};}function removeEntity(_0x805c0,_0x56f7fb){return function(_0xb58516){if(_0xb58516){return _0xb58516['destroy']()['then'](function(){var _0x5f1f1e=_0xb58516[_0xbcea('0x24')]({'plain':!![]});var _0x17aeac=_0xbcea('0x25');return db[_0xbcea('0x26')][_0xbcea('0x27')]({'where':{'type':_0x17aeac,'resourceId':_0x5f1f1e['id']}})[_0xbcea('0x23')](function(){return _0xb58516;});})[_0xbcea('0x23')](function(){_0x805c0[_0xbcea('0x18')](0xcc)[_0xbcea('0x28')]();});}};}function handleEntityNotFound(_0x4eeb4c,_0x11cf9f){return function(_0x2df4d6){if(!_0x2df4d6){_0x4eeb4c[_0xbcea('0x29')](0x194);}return _0x2df4d6;};}function handleError(_0x53f9a0,_0x4e956f){_0x4e956f=_0x4e956f||0x1f4;return function(_0x2358e8){logger[_0xbcea('0x2a')](_0x2358e8[_0xbcea('0x2b')]);if(_0x2358e8['name']){delete _0x2358e8[_0xbcea('0x2c')];}_0x53f9a0[_0xbcea('0x18')](_0x4e956f)[_0xbcea('0x2d')](_0x2358e8);};}exports[_0xbcea('0x2e')]=function(_0x1393a5,_0x2a7468){var _0x2ddaee={},_0x32d3cd={},_0x34ccdc={'count':0x0,'rows':[]};var _0x3abfae=_['map'](db['JscriptyProject'][_0xbcea('0x2f')],function(_0x266ca5){return{'name':_0x266ca5[_0xbcea('0x30')],'type':_0x266ca5[_0xbcea('0x31')][_0xbcea('0x32')]};});_0x32d3cd[_0xbcea('0x33')]=_['map'](_0x3abfae,'name');_0x32d3cd['query']=_[_0xbcea('0x34')](_0x1393a5[_0xbcea('0x35')]);_0x32d3cd[_0xbcea('0x36')]=_[_0xbcea('0x37')](_0x32d3cd[_0xbcea('0x33')],_0x32d3cd[_0xbcea('0x35')]);_0x2ddaee[_0xbcea('0x38')]=_[_0xbcea('0x37')](_0x32d3cd['model'],qs['fields'](_0x1393a5['query'][_0xbcea('0x39')]));_0x2ddaee['attributes']=_0x2ddaee[_0xbcea('0x38')]['length']?_0x2ddaee['attributes']:_0x32d3cd[_0xbcea('0x33')];if(!_0x1393a5[_0xbcea('0x35')]['hasOwnProperty'](_0xbcea('0x3a'))){_0x2ddaee[_0xbcea('0x1d')]=qs[_0xbcea('0x1d')](_0x1393a5['query'][_0xbcea('0x1d')]);_0x2ddaee['offset']=qs[_0xbcea('0x1b')](_0x1393a5[_0xbcea('0x35')][_0xbcea('0x1b')]);}_0x2ddaee[_0xbcea('0x3b')]=qs[_0xbcea('0x3c')](_0x1393a5[_0xbcea('0x35')][_0xbcea('0x3c')]);_0x2ddaee['where']=qs['filters'](_[_0xbcea('0x3d')](_0x1393a5['query'],_0x32d3cd[_0xbcea('0x36')]),_0x3abfae);if(_0x1393a5['query'][_0xbcea('0x3e')]){_0x2ddaee[_0xbcea('0x3f')]=_[_0xbcea('0x40')](_0x2ddaee[_0xbcea('0x3f')],{'$or':_[_0xbcea('0x41')](_0x3abfae,function(_0x169136){if(_0x169136['type']!==_0xbcea('0x42')){var _0x232ea4={};_0x232ea4[_0x169136[_0xbcea('0x2c')]]={'$like':'%'+_0x1393a5[_0xbcea('0x35')]['filter']+'%'};return _0x232ea4;}})});}_0x2ddaee=_[_0xbcea('0x40')]({},_0x2ddaee,_0x1393a5['options']);var _0x12d0ba={'where':_0x2ddaee[_0xbcea('0x3f')]};return db[_0xbcea('0x43')]['count'](_0x12d0ba)[_0xbcea('0x23')](function(_0x4ba3eb){_0x34ccdc[_0xbcea('0x1c')]=_0x4ba3eb;if(_0x1393a5[_0xbcea('0x35')][_0xbcea('0x44')]){_0x2ddaee[_0xbcea('0x45')]=[{'all':!![]}];}return db[_0xbcea('0x43')]['findAll'](_0x2ddaee);})['then'](function(_0x3f5b33){_0x34ccdc['rows']=_0x3f5b33;return _0x34ccdc;})[_0xbcea('0x23')](respondWithFilteredResult(_0x2a7468,_0x2ddaee))[_0xbcea('0x46')](handleError(_0x2a7468,null));};exports[_0xbcea('0x47')]=function(_0x31bab8,_0x274299){var _0x31a1bc={'raw':![],'where':{'id':_0x31bab8[_0xbcea('0x48')]['id']}},_0x1f5680={};_0x1f5680[_0xbcea('0x33')]=_[_0xbcea('0x34')](db[_0xbcea('0x43')][_0xbcea('0x2f')]);_0x1f5680[_0xbcea('0x35')]=_['keys'](_0x31bab8['query']);_0x1f5680[_0xbcea('0x36')]=_[_0xbcea('0x37')](_0x1f5680[_0xbcea('0x33')],_0x1f5680[_0xbcea('0x35')]);_0x31a1bc[_0xbcea('0x38')]=_[_0xbcea('0x37')](_0x1f5680[_0xbcea('0x33')],qs[_0xbcea('0x39')](_0x31bab8[_0xbcea('0x35')][_0xbcea('0x39')]));_0x31a1bc[_0xbcea('0x38')]=_0x31a1bc[_0xbcea('0x38')][_0xbcea('0x49')]?_0x31a1bc[_0xbcea('0x38')]:_0x1f5680[_0xbcea('0x33')];if(_0x31bab8['query'][_0xbcea('0x44')]){_0x31a1bc[_0xbcea('0x45')]=[{'all':!![]}];}_0x31a1bc=_['merge']({},_0x31a1bc,_0x31bab8['options']);return db[_0xbcea('0x43')][_0xbcea('0x4a')](_0x31a1bc)['then'](handleEntityNotFound(_0x274299,null))[_0xbcea('0x23')](respondWithResult(_0x274299,null))[_0xbcea('0x46')](handleError(_0x274299,null));};exports['create']=function(_0x3f83f1,_0x4bcce3){return db[_0xbcea('0x43')][_0xbcea('0x4b')](_0x3f83f1[_0xbcea('0x4c')],{})[_0xbcea('0x23')](function(_0x464c66){var _0x5cb081=_0x3f83f1['user'][_0xbcea('0x24')]({'plain':!![]});if(!_0x5cb081)throw new Error(_0xbcea('0x4d'));if(_0x5cb081['role']===_0xbcea('0x4e')){var _0x5ec50a=_0x464c66[_0xbcea('0x24')]({'plain':!![]});var _0x3ee0bd=_0xbcea('0x25');return db[_0xbcea('0x4f')][_0xbcea('0x4a')]({'where':{'name':_0x3ee0bd,'userProfileId':_0x5cb081['userProfileId']},'raw':!![]})['then'](function(_0x259262){if(_0x259262&&_0x259262[_0xbcea('0x50')]===0x0){return db['UserProfileResource'][_0xbcea('0x4b')]({'name':_0x5ec50a[_0xbcea('0x2c')],'resourceId':_0x5ec50a['id'],'type':_0x259262[_0xbcea('0x2c')],'sectionId':_0x259262['id']},{})[_0xbcea('0x23')](function(){return _0x464c66;});}else{return _0x464c66;}})[_0xbcea('0x46')](function(_0x41569b){logger[_0xbcea('0x2a')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x41569b);throw _0x41569b;});}return _0x464c66;})[_0xbcea('0x23')](respondWithResult(_0x4bcce3,0xc9))['catch'](handleError(_0x4bcce3,null));};exports[_0xbcea('0x51')]=function(_0x2637c1,_0x50dcc3){var _0x43a5da={'where':{'id':_0x2637c1[_0xbcea('0x48')]['id']}},_0x305545={};_0x305545[_0xbcea('0x33')]=_[_0xbcea('0x34')](db[_0xbcea('0x43')]['rawAttributes']);_0x43a5da[_0xbcea('0x38')]=_[_0xbcea('0x37')](_0x305545['model'],qs[_0xbcea('0x39')](_0x2637c1[_0xbcea('0x35')]['fields']));_0x43a5da[_0xbcea('0x38')]=_0x43a5da['attributes'][_0xbcea('0x49')]?_0x43a5da[_0xbcea('0x38')]:_0x305545[_0xbcea('0x33')];if(_0x2637c1[_0xbcea('0x35')][_0xbcea('0x44')]){_0x43a5da[_0xbcea('0x45')]=[{'all':!![]}];}_0x43a5da=_[_0xbcea('0x40')]({},_0x43a5da,_0x2637c1['options']);return db['JscriptyProject'][_0xbcea('0x4a')](_0x43a5da)[_0xbcea('0x23')](handleEntityNotFound(_0x50dcc3,null))[_0xbcea('0x23')](function(_0x19c645){if(_0x19c645){var _0x5c8c7d=_0x19c645[_0xbcea('0x24')]({'plain':!![]});_0x5c8c7d=qs[_0xbcea('0x52')](_0x5c8c7d,['id',_0xbcea('0x53'),'updatedAt']);_0x2637c1['body']=_[_0xbcea('0x52')](_0x2637c1[_0xbcea('0x4c')],['id',_0xbcea('0x53'),_0xbcea('0x54')]);return db[_0xbcea('0x43')][_0xbcea('0x4b')](_[_0xbcea('0x40')](_0x5c8c7d,_0x2637c1[_0xbcea('0x4c')]),{'include':_0x2637c1[_0xbcea('0x35')][_0xbcea('0x44')]?[{'all':!![]}]:undefined})[_0xbcea('0x23')](function(_0x394c86){var _0x159b95=_0x2637c1['user']['get']({'plain':!![]});if(!_0x159b95)throw new Error(_0xbcea('0x4d'));if(_0x159b95[_0xbcea('0x55')]==='user'){var _0x4e6973=_0x394c86[_0xbcea('0x24')]({'plain':!![]});var _0x260b57=_0xbcea('0x25');return db[_0xbcea('0x4f')][_0xbcea('0x4a')]({'where':{'name':_0x260b57,'userProfileId':_0x159b95['userProfileId']},'raw':!![]})[_0xbcea('0x23')](function(_0x1731e9){if(_0x1731e9&&_0x1731e9[_0xbcea('0x50')]===0x0){return db[_0xbcea('0x26')][_0xbcea('0x4b')]({'name':_0x4e6973[_0xbcea('0x2c')],'resourceId':_0x4e6973['id'],'type':_0x1731e9[_0xbcea('0x2c')],'sectionId':_0x1731e9['id']},{})[_0xbcea('0x23')](function(){return _0x394c86;});}else{return _0x394c86;}})[_0xbcea('0x46')](function(_0x1814fe){logger['error'](_0xbcea('0x56'),_0x1814fe);throw _0x1814fe;});}return _0x394c86;});}})['then'](respondWithResult(_0x50dcc3,0xc9))[_0xbcea('0x46')](handleError(_0x50dcc3,null));};exports[_0xbcea('0x57')]=function(_0x1c0191,_0x3bf9cc){if(_0x1c0191['body']['id']){delete _0x1c0191[_0xbcea('0x4c')]['id'];}return db['JscriptyProject']['find']({'where':{'id':_0x1c0191[_0xbcea('0x48')]['id']}})[_0xbcea('0x23')](handleEntityNotFound(_0x3bf9cc,null))[_0xbcea('0x23')](saveUpdates(_0x1c0191[_0xbcea('0x4c')],null))[_0xbcea('0x23')](respondWithResult(_0x3bf9cc,null))[_0xbcea('0x46')](handleError(_0x3bf9cc,null));};exports[_0xbcea('0x27')]=function(_0x2b8b93,_0x13c7ff){return db[_0xbcea('0x43')]['find']({'where':{'id':_0x2b8b93[_0xbcea('0x48')]['id']}})[_0xbcea('0x23')](handleEntityNotFound(_0x13c7ff,null))[_0xbcea('0x23')](removeEntity(_0x13c7ff,null))[_0xbcea('0x46')](handleError(_0x13c7ff,null));};exports['getSessions']=function(_0x262c25,_0x549ac0,_0x412c62){var _0x23114c={'raw':!![],'where':{}};var _0x24422c={};var _0x1f4960={'count':0x0,'rows':[]};return db[_0xbcea('0x43')][_0xbcea('0x58')]({'where':{'id':_0x262c25[_0xbcea('0x48')]['id']}})['then'](handleEntityNotFound(_0x549ac0,null))['then'](function(_0x187491){if(_0x187491){_0x24422c['model']=_[_0xbcea('0x34')](db[_0xbcea('0x59')][_0xbcea('0x2f')]);_0x24422c[_0xbcea('0x35')]=_['keys'](_0x262c25[_0xbcea('0x35')]);_0x24422c[_0xbcea('0x36')]=_[_0xbcea('0x37')](_0x24422c['model'],_0x24422c[_0xbcea('0x35')]);_0x23114c['attributes']=_[_0xbcea('0x37')](_0x24422c[_0xbcea('0x33')],qs[_0xbcea('0x39')](_0x262c25[_0xbcea('0x35')][_0xbcea('0x39')]));_0x23114c[_0xbcea('0x38')]=_0x23114c[_0xbcea('0x38')][_0xbcea('0x49')]?_0x23114c[_0xbcea('0x38')]:_0x24422c[_0xbcea('0x33')];if(!_0x262c25[_0xbcea('0x35')][_0xbcea('0x5a')](_0xbcea('0x3a'))){_0x23114c[_0xbcea('0x1d')]=qs[_0xbcea('0x1d')](_0x262c25[_0xbcea('0x35')][_0xbcea('0x1d')]);_0x23114c[_0xbcea('0x1b')]=qs[_0xbcea('0x1b')](_0x262c25[_0xbcea('0x35')]['offset']);}_0x23114c['order']=qs['sort'](_0x262c25[_0xbcea('0x35')]['sort']);_0x23114c[_0xbcea('0x3f')]=qs['filters'](_[_0xbcea('0x3d')](_0x262c25[_0xbcea('0x35')],_0x24422c[_0xbcea('0x36')]));_0x23114c[_0xbcea('0x3f')][_0xbcea('0x5b')]=_0x187491['id'];if(_0x262c25['query']['filter']){_0x23114c[_0xbcea('0x3f')]=_[_0xbcea('0x40')](_0x23114c['where'],{'$or':_[_0xbcea('0x41')](_0x23114c['attributes'],function(_0x47c2cb){var _0x48b040={};_0x48b040[_0x47c2cb]={'$like':'%'+_0x262c25[_0xbcea('0x35')]['filter']+'%'};return _0x48b040;})});}_0x23114c=_[_0xbcea('0x40')]({},_0x23114c,_0x262c25[_0xbcea('0x5c')]);return db['JscriptySessionReport'][_0xbcea('0x1c')]({'where':_0x23114c[_0xbcea('0x3f')]})['then'](function(_0x1ad7ad){_0x1f4960['count']=_0x1ad7ad;if(_0x262c25[_0xbcea('0x35')][_0xbcea('0x44')]){_0x23114c[_0xbcea('0x45')]=[{'all':!![]}];}return db[_0xbcea('0x59')][_0xbcea('0x5d')](_0x23114c);})[_0xbcea('0x23')](function(_0x43a316){_0x1f4960[_0xbcea('0x5e')]=_0x43a316;return _0x1f4960;});}})['then'](respondWithFilteredResult(_0x549ac0,_0x23114c))[_0xbcea('0x46')](handleError(_0x549ac0,null));};exports[_0xbcea('0x5f')]=function(_0x24d3c3,_0x21c421,_0x510078){var _0x14e6c0={'raw':!![],'where':{}};var _0x601bf1={};var _0x3b979c={'count':0x0,'rows':[]};return db[_0xbcea('0x43')][_0xbcea('0x58')]({'where':{'id':_0x24d3c3[_0xbcea('0x48')]['id']}})['then'](handleEntityNotFound(_0x21c421,null))['then'](function(_0x46ca41){if(_0x46ca41){_0x601bf1[_0xbcea('0x33')]=_[_0xbcea('0x34')](db[_0xbcea('0x60')][_0xbcea('0x2f')]);_0x601bf1['query']=_['keys'](_0x24d3c3[_0xbcea('0x35')]);_0x601bf1[_0xbcea('0x36')]=_['intersection'](_0x601bf1[_0xbcea('0x33')],_0x601bf1[_0xbcea('0x35')]);_0x14e6c0[_0xbcea('0x38')]=_[_0xbcea('0x37')](_0x601bf1[_0xbcea('0x33')],qs[_0xbcea('0x39')](_0x24d3c3[_0xbcea('0x35')][_0xbcea('0x39')]));_0x14e6c0[_0xbcea('0x38')]=_0x14e6c0[_0xbcea('0x38')][_0xbcea('0x49')]?_0x14e6c0[_0xbcea('0x38')]:_0x601bf1[_0xbcea('0x33')];if(!_0x24d3c3[_0xbcea('0x35')][_0xbcea('0x5a')](_0xbcea('0x3a'))){_0x14e6c0[_0xbcea('0x1d')]=qs[_0xbcea('0x1d')](_0x24d3c3[_0xbcea('0x35')][_0xbcea('0x1d')]);_0x14e6c0[_0xbcea('0x1b')]=qs[_0xbcea('0x1b')](_0x24d3c3['query'][_0xbcea('0x1b')]);}_0x14e6c0[_0xbcea('0x3b')]=qs['sort'](_0x24d3c3[_0xbcea('0x35')][_0xbcea('0x3c')]);_0x14e6c0[_0xbcea('0x3f')]=qs[_0xbcea('0x36')](_[_0xbcea('0x3d')](_0x24d3c3['query'],_0x601bf1['filters']));_0x14e6c0[_0xbcea('0x3f')][_0xbcea('0x5b')]=_0x46ca41['id'];if(_0x24d3c3[_0xbcea('0x35')][_0xbcea('0x3e')]){_0x14e6c0['where']=_[_0xbcea('0x40')](_0x14e6c0[_0xbcea('0x3f')],{'$or':_[_0xbcea('0x41')](_0x14e6c0['attributes'],function(_0x3f7159){var _0xabc3a0={};_0xabc3a0[_0x3f7159]={'$like':'%'+_0x24d3c3['query']['filter']+'%'};return _0xabc3a0;})});}_0x14e6c0=_[_0xbcea('0x40')]({},_0x14e6c0,_0x24d3c3['options']);return db[_0xbcea('0x60')]['count']({'where':_0x14e6c0[_0xbcea('0x3f')]})[_0xbcea('0x23')](function(_0x99ed2d){_0x3b979c['count']=_0x99ed2d;if(_0x24d3c3[_0xbcea('0x35')][_0xbcea('0x44')]){_0x14e6c0['include']=[{'all':!![]}];}return db[_0xbcea('0x60')][_0xbcea('0x5d')](_0x14e6c0);})[_0xbcea('0x23')](function(_0x47709a){_0x3b979c[_0xbcea('0x5e')]=_0x47709a;return _0x3b979c;});}})[_0xbcea('0x23')](respondWithFilteredResult(_0x21c421,_0x14e6c0))[_0xbcea('0x46')](handleError(_0x21c421,null));};function char(_0x35cde9){return'number'===typeof _0x35cde9?String['fromCharCode'][_0xbcea('0x20')](null,arguments):_0x35cde9;}function needsEncapsulation(_0xdc026e){return!!_0xdc026e&&(_0xdc026e[_0xbcea('0x61')]()['indexOf'](char(0xd))>=0x0||_0xdc026e[_0xbcea('0x61')]()[_0xbcea('0x62')](char(0xa))>=0x0||_0xdc026e[_0xbcea('0x61')]()['indexOf'](char(0x2c))>=0x0||_0xdc026e[_0xbcea('0x61')]()[_0xbcea('0x62')](char(0x22))>=0x0);}function encapsulate(_0x26737a){var _0xf1791c=char(0x22),_0x6d0cac='\x5c'+char(0x22),_0x449970=_0x26737a['toString']()[_0xbcea('0x63')](new RegExp(_0xf1791c,'g'),_0x6d0cac);return _0xf1791c+_0x449970+_0xf1791c;}exports['getSummary']=function(_0x2183ac,_0x1715b5,_0x3d6304){var _0x1c9b13,_0x3ae4ba;var _0x3ed87a={'where':{'ProjectId':_0x2183ac[_0xbcea('0x48')]['id']}};if(_0x2183ac[_0xbcea('0x35')][_0xbcea('0x64')]){_0x3ed87a['where'][_0xbcea('0x65')]=JSON[_0xbcea('0x66')](_0x2183ac[_0xbcea('0x35')][_0xbcea('0x64')]);}return db[_0xbcea('0x59')][_0xbcea('0x5d')](_0x3ed87a)[_0xbcea('0x23')](handleEntityNotFound(_0x1715b5,null))[_0xbcea('0x23')](function(_0x2bc249){if(_0x2bc249){_0x1c9b13=_0x2bc249;return db[_0xbcea('0x67')][_0xbcea('0x5d')]({'where':{'SessionId':{'$in':_[_0xbcea('0x41')](_0x1c9b13,'id')},'ProjectId':_0x2183ac[_0xbcea('0x48')]['id']},'order':_0xbcea('0x68')});}})[_0xbcea('0x23')](handleEntityNotFound(_0x1715b5,null))[_0xbcea('0x23')](function(_0x57f62b){if(_0x57f62b){_0x3ae4ba=_0x57f62b;var _0x3ef315={};for(var _0x2daf89=0x0,_0xa4e3b4=_0x3ae4ba[_0xbcea('0x49')];_0x2daf89<_0xa4e3b4;_0x2daf89++){if(!_0x3ef315[_0xbcea('0x5a')](_0x3ae4ba[_0x2daf89]['questionId'])){_0x3ef315[_0x3ae4ba[_0x2daf89]['questionId']]=needsEncapsulation(_0x3ae4ba[_0x2daf89][_0xbcea('0x69')])?encapsulate(_0x3ae4ba[_0x2daf89][_0xbcea('0x69')]):_0x3ae4ba[_0x2daf89][_0xbcea('0x69')];}}var _0x38d412=[],_0x1aee28={};for(var _0x4fe7ec=0x0,_0x3eecc1=_0x1c9b13['length'];_0x4fe7ec<_0x3eecc1;_0x4fe7ec++){_0x1aee28={'ProjectId':_0x2183ac[_0xbcea('0x48')]['id'],'SessionId':_0x1c9b13[_0x4fe7ec]['id'],'StartTime':moment(_0x1c9b13[_0x4fe7ec][_0xbcea('0x65')])['format'](_0xbcea('0x6a'))};for(var _0x329ebf=0x0,_0x246002=_0x3ae4ba[_0xbcea('0x49')];_0x329ebf<_0x246002;_0x329ebf++){if(_0x3ae4ba[_0x329ebf][_0xbcea('0x6b')]==_0x1c9b13[_0x4fe7ec]['id']&&_0x3ef315[_0xbcea('0x5a')](_0x3ae4ba[_0x329ebf][_0xbcea('0x6c')])){_0x1aee28[_0x3ef315[_0x3ae4ba[_0x329ebf][_0xbcea('0x6c')]]]=_0x3ae4ba[_0x329ebf]['answer'];}}for(var _0x43aeb0 in _0x3ef315){if(!_0x1aee28[_0xbcea('0x5a')](_0x3ef315[_0x43aeb0])){_0x1aee28[_0x3ef315[_0x43aeb0]]=null;}}_0x38d412[_0xbcea('0x6d')](_0x1aee28);}return _0x38d412;}})[_0xbcea('0x23')](function(_0x344cc6){if(!_[_0xbcea('0x6e')](_0x344cc6)){var _0x1028a9=toCsv(_0x344cc6);var _0x191217=Date['now']();fs[_0xbcea('0x6f')](util['format'](_0xbcea('0x70'),_0x2183ac[_0xbcea('0x48')]['id'],_0x191217),_0x1028a9);_0x1715b5[_0xbcea('0x71')](_0xbcea('0x72'),_0xbcea('0x73')+util[_0xbcea('0x74')](_0xbcea('0x75'),_0x2183ac[_0xbcea('0x48')]['id'],_0x191217));_0x1715b5['setHeader']('Content-type',_0xbcea('0x76'));return _0x1715b5[_0xbcea('0x77')](util[_0xbcea('0x74')](_0xbcea('0x70'),_0x2183ac[_0xbcea('0x48')]['id'],_0x191217));}else{return _0x1715b5[_0xbcea('0x29')](0xcc);}})[_0xbcea('0x46')](handleError(_0x1715b5,null));};
\ No newline at end of file
+var _0x317b=['../../mysqldb','status','json','offset','limit','undefined','count','Content-Range','apply','reject','save','update','then','destroy','get','Projects','UserProfileResource','end','stack','name','send','index','map','rawAttributes','fieldName','key','model','keys','query','attributes','intersection','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','merge','type','VIRTUAL','options','JscriptyProject','findAll','rows','catch','show','params','includeAll','include','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','omit','updatedAt','body','createdAt','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','getSessions','JscriptySessionReport','ProjectId','findOne','JscriptyAnswerReport','number','fromCharCode','indexOf','toString','replace','getSummary','startTime','starttime','parse','JscriptyQuestionReport','-createdAt','questionId','question','format','answer','now','writeFileSync','setHeader','Content-disposition','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','text/csv','download','/tmp/Jscripty_Project_%d_Summary_%s.csv','eml-format','rimraf','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/environment'];(function(_0x4f5ed3,_0x4790de){var _0xf2a2c8=function(_0x15223b){while(--_0x15223b){_0x4f5ed3['push'](_0x4f5ed3['shift']());}};_0xf2a2c8(++_0x4790de);}(_0x317b,0x1c7));var _0xb317=function(_0x2181fb,_0x1da064){_0x2181fb=_0x2181fb-0x0;var _0x46143b=_0x317b[_0x2181fb];return _0x46143b;};'use strict';var emlformat=require(_0xb317('0x0'));var rimraf=require(_0xb317('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0xb317('0x2'));var rp=require(_0xb317('0x3'));var moment=require('moment');var BPromise=require(_0xb317('0x4'));var Mustache=require(_0xb317('0x5'));var util=require(_0xb317('0x6'));var path=require(_0xb317('0x7'));var sox=require(_0xb317('0x8'));var csv=require(_0xb317('0x9'));var ejs=require(_0xb317('0xa'));var fs=require('fs');var fs_extra=require(_0xb317('0xb'));var _=require(_0xb317('0xc'));var squel=require(_0xb317('0xd'));var crypto=require('crypto');var jsforce=require(_0xb317('0xe'));var deskjs=require(_0xb317('0xf'));var toCsv=require('to-csv');var querystring=require(_0xb317('0x10'));var Papa=require(_0xb317('0x11'));var Redis=require(_0xb317('0x12'));var authService=require(_0xb317('0x13'));var qs=require(_0xb317('0x14'));var as=require(_0xb317('0x15'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xb317('0x16'))(_0xb317('0x17'));var utils=require('../../config/utils');var config=require(_0xb317('0x18'));var licenseUtil=require('../../config/license/util');var db=require(_0xb317('0x19'))['db'];function respondWithStatusCode(_0x1f9624,_0x458584){_0x458584=_0x458584||0xcc;return function(_0x15f3f5){if(_0x15f3f5){return _0x1f9624['sendStatus'](_0x458584);}return _0x1f9624[_0xb317('0x1a')](_0x458584)['end']();};}function respondWithResult(_0x5562b0,_0x41f778){_0x41f778=_0x41f778||0xc8;return function(_0x4c2585){if(_0x4c2585){return _0x5562b0[_0xb317('0x1a')](_0x41f778)[_0xb317('0x1b')](_0x4c2585);}};}function respondWithFilteredResult(_0x2ef2c6,_0x5f288e){return function(_0x4ade83){if(_0x4ade83){var _0x5f1f1d=typeof _0x5f288e[_0xb317('0x1c')]==='undefined'&&typeof _0x5f288e[_0xb317('0x1d')]===_0xb317('0x1e');var _0x4ceef3=_0x4ade83[_0xb317('0x1f')];var _0x337eaf=_0x5f1f1d?0x0:_0x5f288e['offset'];var _0x497992=_0x5f1f1d?_0x4ade83[_0xb317('0x1f')]:_0x5f288e[_0xb317('0x1c')]+_0x5f288e[_0xb317('0x1d')];var _0x13d760;if(_0x497992>=_0x4ceef3){_0x497992=_0x4ceef3;_0x13d760=0xc8;}else{_0x13d760=0xce;}_0x2ef2c6[_0xb317('0x1a')](_0x13d760);return _0x2ef2c6['set'](_0xb317('0x20'),_0x337eaf+'-'+_0x497992+'/'+_0x4ceef3)[_0xb317('0x1b')](_0x4ade83);}return null;};}function patchUpdates(_0x2467b){return function(_0x2493a2){try{jsonpatch[_0xb317('0x21')](_0x2493a2,_0x2467b,!![]);}catch(_0x187458){return BPromise[_0xb317('0x22')](_0x187458);}return _0x2493a2[_0xb317('0x23')]();};}function saveUpdates(_0x1fb834,_0x2f85d4){return function(_0x2dfdee){if(_0x2dfdee){return _0x2dfdee[_0xb317('0x24')](_0x1fb834)[_0xb317('0x25')](function(_0x3539fd){return _0x3539fd;});}return null;};}function removeEntity(_0x569c6a,_0x42ef04){return function(_0x55bf91){if(_0x55bf91){return _0x55bf91[_0xb317('0x26')]()[_0xb317('0x25')](function(){var _0x3009fb=_0x55bf91[_0xb317('0x27')]({'plain':!![]});var _0x3bab40=_0xb317('0x28');return db[_0xb317('0x29')][_0xb317('0x26')]({'where':{'type':_0x3bab40,'resourceId':_0x3009fb['id']}})['then'](function(){return _0x55bf91;});})[_0xb317('0x25')](function(){_0x569c6a[_0xb317('0x1a')](0xcc)[_0xb317('0x2a')]();});}};}function handleEntityNotFound(_0x81db2f,_0x2960a8){return function(_0x1254cb){if(!_0x1254cb){_0x81db2f['sendStatus'](0x194);}return _0x1254cb;};}function handleError(_0x130c41,_0x35e446){_0x35e446=_0x35e446||0x1f4;return function(_0x5be03a){logger['error'](_0x5be03a[_0xb317('0x2b')]);if(_0x5be03a[_0xb317('0x2c')]){delete _0x5be03a[_0xb317('0x2c')];}_0x130c41['status'](_0x35e446)[_0xb317('0x2d')](_0x5be03a);};}exports[_0xb317('0x2e')]=function(_0xb475dd,_0x3a174f){var _0x42f5a8={},_0x5a14ae={},_0x39c2aa={'count':0x0,'rows':[]};var _0x4bab2b=_[_0xb317('0x2f')](db['JscriptyProject'][_0xb317('0x30')],function(_0x1ece9d){return{'name':_0x1ece9d[_0xb317('0x31')],'type':_0x1ece9d['type'][_0xb317('0x32')]};});_0x5a14ae[_0xb317('0x33')]=_[_0xb317('0x2f')](_0x4bab2b,'name');_0x5a14ae['query']=_[_0xb317('0x34')](_0xb475dd['query']);_0x5a14ae['filters']=_['intersection'](_0x5a14ae[_0xb317('0x33')],_0x5a14ae[_0xb317('0x35')]);_0x42f5a8[_0xb317('0x36')]=_[_0xb317('0x37')](_0x5a14ae['model'],qs[_0xb317('0x38')](_0xb475dd[_0xb317('0x35')][_0xb317('0x38')]));_0x42f5a8[_0xb317('0x36')]=_0x42f5a8['attributes'][_0xb317('0x39')]?_0x42f5a8['attributes']:_0x5a14ae[_0xb317('0x33')];if(!_0xb475dd[_0xb317('0x35')][_0xb317('0x3a')](_0xb317('0x3b'))){_0x42f5a8['limit']=qs[_0xb317('0x1d')](_0xb475dd[_0xb317('0x35')][_0xb317('0x1d')]);_0x42f5a8['offset']=qs[_0xb317('0x1c')](_0xb475dd[_0xb317('0x35')][_0xb317('0x1c')]);}_0x42f5a8[_0xb317('0x3c')]=qs['sort'](_0xb475dd[_0xb317('0x35')][_0xb317('0x3d')]);_0x42f5a8[_0xb317('0x3e')]=qs[_0xb317('0x3f')](_[_0xb317('0x40')](_0xb475dd[_0xb317('0x35')],_0x5a14ae[_0xb317('0x3f')]),_0x4bab2b);if(_0xb475dd['query'][_0xb317('0x41')]){_0x42f5a8['where']=_[_0xb317('0x42')](_0x42f5a8[_0xb317('0x3e')],{'$or':_[_0xb317('0x2f')](_0x4bab2b,function(_0x48fd3f){if(_0x48fd3f[_0xb317('0x43')]!==_0xb317('0x44')){var _0x20a881={};_0x20a881[_0x48fd3f[_0xb317('0x2c')]]={'$like':'%'+_0xb475dd['query'][_0xb317('0x41')]+'%'};return _0x20a881;}})});}_0x42f5a8=_['merge']({},_0x42f5a8,_0xb475dd[_0xb317('0x45')]);var _0x4c5418={'where':_0x42f5a8[_0xb317('0x3e')]};return db['JscriptyProject'][_0xb317('0x1f')](_0x4c5418)['then'](function(_0x33e929){_0x39c2aa[_0xb317('0x1f')]=_0x33e929;if(_0xb475dd[_0xb317('0x35')]['includeAll']){_0x42f5a8['include']=[{'all':!![]}];}return db[_0xb317('0x46')][_0xb317('0x47')](_0x42f5a8);})['then'](function(_0x450ff8){_0x39c2aa[_0xb317('0x48')]=_0x450ff8;return _0x39c2aa;})[_0xb317('0x25')](respondWithFilteredResult(_0x3a174f,_0x42f5a8))[_0xb317('0x49')](handleError(_0x3a174f,null));};exports[_0xb317('0x4a')]=function(_0x580eee,_0x518490){var _0xb460ce={'raw':![],'where':{'id':_0x580eee[_0xb317('0x4b')]['id']}},_0x55567a={};_0x55567a[_0xb317('0x33')]=_[_0xb317('0x34')](db[_0xb317('0x46')][_0xb317('0x30')]);_0x55567a[_0xb317('0x35')]=_[_0xb317('0x34')](_0x580eee[_0xb317('0x35')]);_0x55567a[_0xb317('0x3f')]=_[_0xb317('0x37')](_0x55567a[_0xb317('0x33')],_0x55567a[_0xb317('0x35')]);_0xb460ce[_0xb317('0x36')]=_['intersection'](_0x55567a[_0xb317('0x33')],qs['fields'](_0x580eee[_0xb317('0x35')][_0xb317('0x38')]));_0xb460ce[_0xb317('0x36')]=_0xb460ce['attributes']['length']?_0xb460ce[_0xb317('0x36')]:_0x55567a[_0xb317('0x33')];if(_0x580eee[_0xb317('0x35')][_0xb317('0x4c')]){_0xb460ce[_0xb317('0x4d')]=[{'all':!![]}];}_0xb460ce=_['merge']({},_0xb460ce,_0x580eee[_0xb317('0x45')]);return db[_0xb317('0x46')][_0xb317('0x4e')](_0xb460ce)[_0xb317('0x25')](handleEntityNotFound(_0x518490,null))['then'](respondWithResult(_0x518490,null))[_0xb317('0x49')](handleError(_0x518490,null));};exports[_0xb317('0x4f')]=function(_0x1918b9,_0x3a9b5d){return db[_0xb317('0x46')][_0xb317('0x4f')](_0x1918b9['body'],{})[_0xb317('0x25')](function(_0x45ab45){var _0xd3c143=_0x1918b9[_0xb317('0x50')][_0xb317('0x27')]({'plain':!![]});if(!_0xd3c143)throw new Error(_0xb317('0x51'));if(_0xd3c143[_0xb317('0x52')]==='user'){var _0x11428f=_0x45ab45[_0xb317('0x27')]({'plain':!![]});var _0x2cb086=_0xb317('0x28');return db[_0xb317('0x53')][_0xb317('0x4e')]({'where':{'name':_0x2cb086,'userProfileId':_0xd3c143['userProfileId']},'raw':!![]})['then'](function(_0x351507){if(_0x351507&&_0x351507['autoAssociation']===0x0){return db[_0xb317('0x29')][_0xb317('0x4f')]({'name':_0x11428f[_0xb317('0x2c')],'resourceId':_0x11428f['id'],'type':_0x351507[_0xb317('0x2c')],'sectionId':_0x351507['id']},{})['then'](function(){return _0x45ab45;});}else{return _0x45ab45;}})[_0xb317('0x49')](function(_0x49f860){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x49f860);throw _0x49f860;});}return _0x45ab45;})[_0xb317('0x25')](respondWithResult(_0x3a9b5d,0xc9))['catch'](handleError(_0x3a9b5d,null));};exports['clone']=function(_0x1a6fe6,_0x3ab9b5){var _0x46a631={'where':{'id':_0x1a6fe6[_0xb317('0x4b')]['id']}},_0x232ff0={};_0x232ff0[_0xb317('0x33')]=_[_0xb317('0x34')](db[_0xb317('0x46')][_0xb317('0x30')]);_0x46a631[_0xb317('0x36')]=_[_0xb317('0x37')](_0x232ff0[_0xb317('0x33')],qs[_0xb317('0x38')](_0x1a6fe6[_0xb317('0x35')]['fields']));_0x46a631[_0xb317('0x36')]=_0x46a631[_0xb317('0x36')][_0xb317('0x39')]?_0x46a631[_0xb317('0x36')]:_0x232ff0[_0xb317('0x33')];if(_0x1a6fe6[_0xb317('0x35')][_0xb317('0x4c')]){_0x46a631['include']=[{'all':!![]}];}_0x46a631=_[_0xb317('0x42')]({},_0x46a631,_0x1a6fe6[_0xb317('0x45')]);return db[_0xb317('0x46')]['find'](_0x46a631)[_0xb317('0x25')](handleEntityNotFound(_0x3ab9b5,null))[_0xb317('0x25')](function(_0x21838d){if(_0x21838d){var _0xa6af78=_0x21838d[_0xb317('0x27')]({'plain':!![]});_0xa6af78=qs[_0xb317('0x54')](_0xa6af78,['id','createdAt',_0xb317('0x55')]);_0x1a6fe6[_0xb317('0x56')]=_['omit'](_0x1a6fe6['body'],['id',_0xb317('0x57'),_0xb317('0x55')]);return db[_0xb317('0x46')][_0xb317('0x4f')](_[_0xb317('0x42')](_0xa6af78,_0x1a6fe6[_0xb317('0x56')]),{'include':_0x1a6fe6[_0xb317('0x35')][_0xb317('0x4c')]?[{'all':!![]}]:undefined})[_0xb317('0x25')](function(_0x2dcedb){var _0x163da1=_0x1a6fe6[_0xb317('0x50')][_0xb317('0x27')]({'plain':!![]});if(!_0x163da1)throw new Error(_0xb317('0x51'));if(_0x163da1[_0xb317('0x52')]===_0xb317('0x50')){var _0x2f68d8=_0x2dcedb[_0xb317('0x27')]({'plain':!![]});var _0xb602c5=_0xb317('0x28');return db[_0xb317('0x53')]['find']({'where':{'name':_0xb602c5,'userProfileId':_0x163da1[_0xb317('0x58')]},'raw':!![]})[_0xb317('0x25')](function(_0x21c953){if(_0x21c953&&_0x21c953[_0xb317('0x59')]===0x0){return db[_0xb317('0x29')][_0xb317('0x4f')]({'name':_0x2f68d8[_0xb317('0x2c')],'resourceId':_0x2f68d8['id'],'type':_0x21c953[_0xb317('0x2c')],'sectionId':_0x21c953['id']},{})[_0xb317('0x25')](function(){return _0x2dcedb;});}else{return _0x2dcedb;}})['catch'](function(_0x47613f){logger['error'](_0xb317('0x5a'),_0x47613f);throw _0x47613f;});}return _0x2dcedb;});}})[_0xb317('0x25')](respondWithResult(_0x3ab9b5,0xc9))[_0xb317('0x49')](handleError(_0x3ab9b5,null));};exports['update']=function(_0x2d1530,_0x20ee0c){if(_0x2d1530[_0xb317('0x56')]['id']){delete _0x2d1530['body']['id'];}return db['JscriptyProject']['find']({'where':{'id':_0x2d1530[_0xb317('0x4b')]['id']}})['then'](handleEntityNotFound(_0x20ee0c,null))['then'](saveUpdates(_0x2d1530[_0xb317('0x56')],null))[_0xb317('0x25')](respondWithResult(_0x20ee0c,null))['catch'](handleError(_0x20ee0c,null));};exports[_0xb317('0x26')]=function(_0x335776,_0x41f20a){return db[_0xb317('0x46')][_0xb317('0x4e')]({'where':{'id':_0x335776[_0xb317('0x4b')]['id']}})['then'](handleEntityNotFound(_0x41f20a,null))[_0xb317('0x25')](removeEntity(_0x41f20a,null))[_0xb317('0x49')](handleError(_0x41f20a,null));};exports[_0xb317('0x5b')]=function(_0x4c22ac,_0x15bebb,_0x28962d){var _0x38a6ce={'raw':!![],'where':{}};var _0x1c4400={};var _0x56d841={'count':0x0,'rows':[]};return db['JscriptyProject']['findOne']({'where':{'id':_0x4c22ac['params']['id']}})['then'](handleEntityNotFound(_0x15bebb,null))['then'](function(_0x1dc2fa){if(_0x1dc2fa){_0x1c4400['model']=_[_0xb317('0x34')](db[_0xb317('0x5c')][_0xb317('0x30')]);_0x1c4400[_0xb317('0x35')]=_[_0xb317('0x34')](_0x4c22ac[_0xb317('0x35')]);_0x1c4400['filters']=_[_0xb317('0x37')](_0x1c4400[_0xb317('0x33')],_0x1c4400['query']);_0x38a6ce['attributes']=_[_0xb317('0x37')](_0x1c4400[_0xb317('0x33')],qs[_0xb317('0x38')](_0x4c22ac[_0xb317('0x35')]['fields']));_0x38a6ce[_0xb317('0x36')]=_0x38a6ce[_0xb317('0x36')][_0xb317('0x39')]?_0x38a6ce[_0xb317('0x36')]:_0x1c4400[_0xb317('0x33')];if(!_0x4c22ac[_0xb317('0x35')][_0xb317('0x3a')]('nolimit')){_0x38a6ce[_0xb317('0x1d')]=qs[_0xb317('0x1d')](_0x4c22ac['query'][_0xb317('0x1d')]);_0x38a6ce[_0xb317('0x1c')]=qs[_0xb317('0x1c')](_0x4c22ac[_0xb317('0x35')][_0xb317('0x1c')]);}_0x38a6ce[_0xb317('0x3c')]=qs[_0xb317('0x3d')](_0x4c22ac[_0xb317('0x35')][_0xb317('0x3d')]);_0x38a6ce['where']=qs[_0xb317('0x3f')](_[_0xb317('0x40')](_0x4c22ac[_0xb317('0x35')],_0x1c4400[_0xb317('0x3f')]));_0x38a6ce[_0xb317('0x3e')][_0xb317('0x5d')]=_0x1dc2fa['id'];if(_0x4c22ac[_0xb317('0x35')][_0xb317('0x41')]){_0x38a6ce[_0xb317('0x3e')]=_[_0xb317('0x42')](_0x38a6ce[_0xb317('0x3e')],{'$or':_[_0xb317('0x2f')](_0x38a6ce[_0xb317('0x36')],function(_0x1d4ee9){var _0x2af3e4={};_0x2af3e4[_0x1d4ee9]={'$like':'%'+_0x4c22ac[_0xb317('0x35')]['filter']+'%'};return _0x2af3e4;})});}_0x38a6ce=_[_0xb317('0x42')]({},_0x38a6ce,_0x4c22ac[_0xb317('0x45')]);return db[_0xb317('0x5c')]['count']({'where':_0x38a6ce['where']})[_0xb317('0x25')](function(_0x3ec4b7){_0x56d841['count']=_0x3ec4b7;if(_0x4c22ac[_0xb317('0x35')][_0xb317('0x4c')]){_0x38a6ce[_0xb317('0x4d')]=[{'all':!![]}];}return db[_0xb317('0x5c')][_0xb317('0x47')](_0x38a6ce);})[_0xb317('0x25')](function(_0x5c0523){_0x56d841['rows']=_0x5c0523;return _0x56d841;});}})['then'](respondWithFilteredResult(_0x15bebb,_0x38a6ce))['catch'](handleError(_0x15bebb,null));};exports['getAnswers']=function(_0x4a67fb,_0x43fc3a,_0x404fc0){var _0x4d82d2={'raw':!![],'where':{}};var _0x2cde3d={};var _0x1f097d={'count':0x0,'rows':[]};return db[_0xb317('0x46')][_0xb317('0x5e')]({'where':{'id':_0x4a67fb[_0xb317('0x4b')]['id']}})[_0xb317('0x25')](handleEntityNotFound(_0x43fc3a,null))['then'](function(_0x433d3b){if(_0x433d3b){_0x2cde3d['model']=_[_0xb317('0x34')](db['JscriptyAnswerReport'][_0xb317('0x30')]);_0x2cde3d[_0xb317('0x35')]=_[_0xb317('0x34')](_0x4a67fb['query']);_0x2cde3d[_0xb317('0x3f')]=_['intersection'](_0x2cde3d['model'],_0x2cde3d['query']);_0x4d82d2[_0xb317('0x36')]=_['intersection'](_0x2cde3d[_0xb317('0x33')],qs[_0xb317('0x38')](_0x4a67fb[_0xb317('0x35')][_0xb317('0x38')]));_0x4d82d2[_0xb317('0x36')]=_0x4d82d2[_0xb317('0x36')]['length']?_0x4d82d2[_0xb317('0x36')]:_0x2cde3d[_0xb317('0x33')];if(!_0x4a67fb[_0xb317('0x35')][_0xb317('0x3a')](_0xb317('0x3b'))){_0x4d82d2['limit']=qs['limit'](_0x4a67fb[_0xb317('0x35')][_0xb317('0x1d')]);_0x4d82d2[_0xb317('0x1c')]=qs[_0xb317('0x1c')](_0x4a67fb[_0xb317('0x35')][_0xb317('0x1c')]);}_0x4d82d2[_0xb317('0x3c')]=qs[_0xb317('0x3d')](_0x4a67fb[_0xb317('0x35')][_0xb317('0x3d')]);_0x4d82d2[_0xb317('0x3e')]=qs[_0xb317('0x3f')](_[_0xb317('0x40')](_0x4a67fb[_0xb317('0x35')],_0x2cde3d[_0xb317('0x3f')]));_0x4d82d2['where'][_0xb317('0x5d')]=_0x433d3b['id'];if(_0x4a67fb[_0xb317('0x35')][_0xb317('0x41')]){_0x4d82d2[_0xb317('0x3e')]=_[_0xb317('0x42')](_0x4d82d2[_0xb317('0x3e')],{'$or':_['map'](_0x4d82d2[_0xb317('0x36')],function(_0x4742b0){var _0x261af5={};_0x261af5[_0x4742b0]={'$like':'%'+_0x4a67fb[_0xb317('0x35')][_0xb317('0x41')]+'%'};return _0x261af5;})});}_0x4d82d2=_[_0xb317('0x42')]({},_0x4d82d2,_0x4a67fb[_0xb317('0x45')]);return db[_0xb317('0x5f')][_0xb317('0x1f')]({'where':_0x4d82d2[_0xb317('0x3e')]})[_0xb317('0x25')](function(_0x54c071){_0x1f097d[_0xb317('0x1f')]=_0x54c071;if(_0x4a67fb[_0xb317('0x35')][_0xb317('0x4c')]){_0x4d82d2[_0xb317('0x4d')]=[{'all':!![]}];}return db[_0xb317('0x5f')][_0xb317('0x47')](_0x4d82d2);})[_0xb317('0x25')](function(_0x5b76c9){_0x1f097d[_0xb317('0x48')]=_0x5b76c9;return _0x1f097d;});}})['then'](respondWithFilteredResult(_0x43fc3a,_0x4d82d2))['catch'](handleError(_0x43fc3a,null));};function char(_0x3d44f8){return _0xb317('0x60')===typeof _0x3d44f8?String[_0xb317('0x61')]['apply'](null,arguments):_0x3d44f8;}function needsEncapsulation(_0x2a79bd){return!!_0x2a79bd&&(_0x2a79bd['toString']()[_0xb317('0x62')](char(0xd))>=0x0||_0x2a79bd[_0xb317('0x63')]()['indexOf'](char(0xa))>=0x0||_0x2a79bd[_0xb317('0x63')]()[_0xb317('0x62')](char(0x2c))>=0x0||_0x2a79bd[_0xb317('0x63')]()[_0xb317('0x62')](char(0x22))>=0x0);}function encapsulate(_0x27ca04){var _0xb01b4a=char(0x22),_0x438c40='\x5c'+char(0x22),_0x111d77=_0x27ca04[_0xb317('0x63')]()[_0xb317('0x64')](new RegExp(_0xb01b4a,'g'),_0x438c40);return _0xb01b4a+_0x111d77+_0xb01b4a;}exports[_0xb317('0x65')]=function(_0x12a2fb,_0x42b955,_0x5f0de1){var _0x5462ee,_0x41316d;var _0x19e634={'where':{'ProjectId':_0x12a2fb['params']['id']}};if(_0x12a2fb['query'][_0xb317('0x66')]){_0x19e634[_0xb317('0x3e')][_0xb317('0x67')]=JSON[_0xb317('0x68')](_0x12a2fb[_0xb317('0x35')][_0xb317('0x66')]);}return db['JscriptySessionReport'][_0xb317('0x47')](_0x19e634)[_0xb317('0x25')](handleEntityNotFound(_0x42b955,null))[_0xb317('0x25')](function(_0x50b722){if(_0x50b722){_0x5462ee=_0x50b722;return db[_0xb317('0x69')][_0xb317('0x47')]({'where':{'SessionId':{'$in':_['map'](_0x5462ee,'id')},'ProjectId':_0x12a2fb[_0xb317('0x4b')]['id']},'order':_0xb317('0x6a')});}})[_0xb317('0x25')](handleEntityNotFound(_0x42b955,null))['then'](function(_0x2b5a48){if(_0x2b5a48){_0x41316d=_0x2b5a48;var _0x48a10a={};for(var _0x2efedc=0x0,_0x5de23d=_0x41316d['length'];_0x2efedc<_0x5de23d;_0x2efedc++){if(!_0x48a10a[_0xb317('0x3a')](_0x41316d[_0x2efedc][_0xb317('0x6b')])){_0x48a10a[_0x41316d[_0x2efedc][_0xb317('0x6b')]]=needsEncapsulation(_0x41316d[_0x2efedc]['question'])?encapsulate(_0x41316d[_0x2efedc]['question']):_0x41316d[_0x2efedc][_0xb317('0x6c')];}}var _0x56af6b=[],_0x2c23d4={};for(var _0x5a1b21=0x0,_0x190520=_0x5462ee[_0xb317('0x39')];_0x5a1b21<_0x190520;_0x5a1b21++){_0x2c23d4={'ProjectId':_0x12a2fb[_0xb317('0x4b')]['id'],'SessionId':_0x5462ee[_0x5a1b21]['id'],'StartTime':moment(_0x5462ee[_0x5a1b21][_0xb317('0x67')])[_0xb317('0x6d')]('YYYY-MM-DD\x20HH:mm:ss')};for(var _0x3812d9=0x0,_0x2f2098=_0x41316d['length'];_0x3812d9<_0x2f2098;_0x3812d9++){if(_0x41316d[_0x3812d9]['SessionId']==_0x5462ee[_0x5a1b21]['id']&&_0x48a10a[_0xb317('0x3a')](_0x41316d[_0x3812d9]['questionId'])){_0x2c23d4[_0x48a10a[_0x41316d[_0x3812d9][_0xb317('0x6b')]]]=_0x41316d[_0x3812d9][_0xb317('0x6e')];}}for(var _0x1c35b7 in _0x48a10a){if(!_0x2c23d4[_0xb317('0x3a')](_0x48a10a[_0x1c35b7])){_0x2c23d4[_0x48a10a[_0x1c35b7]]=null;}}_0x56af6b['push'](_0x2c23d4);}return _0x56af6b;}})[_0xb317('0x25')](function(_0x40f1b0){if(!_['isEmpty'](_0x40f1b0)){var _0x4f8f5f=toCsv(_0x40f1b0);var _0x588c21=Date[_0xb317('0x6f')]();fs[_0xb317('0x70')](util[_0xb317('0x6d')]('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x12a2fb['params']['id'],_0x588c21),_0x4f8f5f);_0x42b955[_0xb317('0x71')](_0xb317('0x72'),_0xb317('0x73')+util[_0xb317('0x6d')](_0xb317('0x74'),_0x12a2fb['params']['id'],_0x588c21));_0x42b955[_0xb317('0x71')]('Content-type',_0xb317('0x75'));return _0x42b955[_0xb317('0x76')](util[_0xb317('0x6d')](_0xb317('0x77'),_0x12a2fb[_0xb317('0x4b')]['id'],_0x588c21));}else{return _0x42b955['sendStatus'](0xcc);}})['catch'](handleError(_0x42b955,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff