// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xb2a6=['question','starttime','format','YYYY-MM-DD\x20HH:mm:ss','SessionId','questionId','answer','now','writeFileSync','/tmp/Jscripty_Project_%d_Summary_%s.csv','Jscripty_Project_%d_Summary_%s.csv','setHeader','text/csv','download','eml-format','rimraf','fast-json-patch','moment','bluebird','mustache','util','path','fs-extra','lodash','squel','crypto','jsforce','desk.js','to-csv','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','json','limit','undefined','count','offset','Content-Range','reject','update','destroy','then','get','Projects','UserProfileResource','stack','name','send','index','map','fieldName','type','query','keys','filters','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','sort','where','pick','filter','merge','JscriptyProject','include','rows','params','rawAttributes','includeAll','options','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','UserProfileSection','autoAssociation','catch','error','clone','omit','createdAt','body','role','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','getSessions','findOne','JscriptySessionReport','order','findAll','JscriptyAnswerReport','ProjectId','number','apply','toString','indexOf','replace','getSummary','startTime'];(function(_0x49783e,_0x1e1733){var _0x47290e=function(_0x31c8f4){while(--_0x31c8f4){_0x49783e['push'](_0x49783e['shift']());}};_0x47290e(++_0x1e1733);}(_0xb2a6,0xf0));var _0x6b2a=function(_0x3140a9,_0xc24b35){_0x3140a9=_0x3140a9-0x0;var _0x32ac53=_0xb2a6[_0x3140a9];return _0x32ac53;};'use strict';var emlformat=require(_0x6b2a('0x0'));var rimraf=require(_0x6b2a('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x6b2a('0x2'));var rp=require('request-promise');var moment=require(_0x6b2a('0x3'));var BPromise=require(_0x6b2a('0x4'));var Mustache=require(_0x6b2a('0x5'));var util=require(_0x6b2a('0x6'));var path=require(_0x6b2a('0x7'));var sox=require('sox');var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x6b2a('0x8'));var _=require(_0x6b2a('0x9'));var squel=require(_0x6b2a('0xa'));var crypto=require(_0x6b2a('0xb'));var jsforce=require(_0x6b2a('0xc'));var deskjs=require(_0x6b2a('0xd'));var toCsv=require(_0x6b2a('0xe'));var querystring=require(_0x6b2a('0xf'));var Papa=require('papaparse');var Redis=require(_0x6b2a('0x10'));var authService=require(_0x6b2a('0x11'));var qs=require(_0x6b2a('0x12'));var as=require(_0x6b2a('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x6b2a('0x14'))(_0x6b2a('0x15'));var utils=require(_0x6b2a('0x16'));var config=require(_0x6b2a('0x17'));var licenseUtil=require('../../config/license/util');var db=require(_0x6b2a('0x18'))['db'];function respondWithStatusCode(_0x2e8f05,_0x57047a){_0x57047a=_0x57047a||0xcc;return function(_0x461c95){if(_0x461c95){return _0x2e8f05[_0x6b2a('0x19')](_0x57047a);}return _0x2e8f05[_0x6b2a('0x1a')](_0x57047a)[_0x6b2a('0x1b')]();};}function respondWithResult(_0xb6c388,_0x246f92){_0x246f92=_0x246f92||0xc8;return function(_0x1ad2b1){if(_0x1ad2b1){return _0xb6c388['status'](_0x246f92)[_0x6b2a('0x1c')](_0x1ad2b1);}};}function respondWithFilteredResult(_0x261727,_0x20c428){return function(_0xd8c0f3){if(_0xd8c0f3){var _0x1f4d73=typeof _0x20c428['offset']==='undefined'&&typeof _0x20c428[_0x6b2a('0x1d')]===_0x6b2a('0x1e');var _0x3579a0=_0xd8c0f3[_0x6b2a('0x1f')];var _0x10b26e=_0x1f4d73?0x0:_0x20c428[_0x6b2a('0x20')];var _0x5c0788=_0x1f4d73?_0xd8c0f3['count']:_0x20c428[_0x6b2a('0x20')]+_0x20c428['limit'];var _0xfe576e;if(_0x5c0788>=_0x3579a0){_0x5c0788=_0x3579a0;_0xfe576e=0xc8;}else{_0xfe576e=0xce;}_0x261727[_0x6b2a('0x1a')](_0xfe576e);return _0x261727['set'](_0x6b2a('0x21'),_0x10b26e+'-'+_0x5c0788+'/'+_0x3579a0)[_0x6b2a('0x1c')](_0xd8c0f3);}return null;};}function patchUpdates(_0x9a61d8){return function(_0x180726){try{jsonpatch['apply'](_0x180726,_0x9a61d8,!![]);}catch(_0x166662){return BPromise[_0x6b2a('0x22')](_0x166662);}return _0x180726['save']();};}function saveUpdates(_0x32fa10,_0x5ebf6a){return function(_0x2fbfd8){if(_0x2fbfd8){return _0x2fbfd8[_0x6b2a('0x23')](_0x32fa10)['then'](function(_0x3b4bd3){return _0x3b4bd3;});}return null;};}function removeEntity(_0x373d24,_0x5b669f){return function(_0x30e47c){if(_0x30e47c){return _0x30e47c[_0x6b2a('0x24')]()[_0x6b2a('0x25')](function(){var _0x1d92ad=_0x30e47c[_0x6b2a('0x26')]({'plain':!![]});var _0x2284a3=_0x6b2a('0x27');return db[_0x6b2a('0x28')][_0x6b2a('0x24')]({'where':{'type':_0x2284a3,'resourceId':_0x1d92ad['id']}})[_0x6b2a('0x25')](function(){return _0x30e47c;});})[_0x6b2a('0x25')](function(){_0x373d24[_0x6b2a('0x1a')](0xcc)[_0x6b2a('0x1b')]();});}};}function handleEntityNotFound(_0x193e5a,_0xd01fdc){return function(_0x1b51f0){if(!_0x1b51f0){_0x193e5a[_0x6b2a('0x19')](0x194);}return _0x1b51f0;};}function handleError(_0x5acbbf,_0x97b9b2){_0x97b9b2=_0x97b9b2||0x1f4;return function(_0x470684){logger['error'](_0x470684[_0x6b2a('0x29')]);if(_0x470684['name']){delete _0x470684[_0x6b2a('0x2a')];}_0x5acbbf[_0x6b2a('0x1a')](_0x97b9b2)[_0x6b2a('0x2b')](_0x470684);};}exports[_0x6b2a('0x2c')]=function(_0x321103,_0x16e871){var _0xbd7951={},_0x9faacb={},_0x2e768a={'count':0x0,'rows':[]};var _0x13b0df=_[_0x6b2a('0x2d')](db['JscriptyProject']['rawAttributes'],function(_0x14879b){return{'name':_0x14879b[_0x6b2a('0x2e')],'type':_0x14879b[_0x6b2a('0x2f')]['key']};});_0x9faacb['model']=_[_0x6b2a('0x2d')](_0x13b0df,_0x6b2a('0x2a'));_0x9faacb[_0x6b2a('0x30')]=_[_0x6b2a('0x31')](_0x321103[_0x6b2a('0x30')]);_0x9faacb[_0x6b2a('0x32')]=_[_0x6b2a('0x33')](_0x9faacb[_0x6b2a('0x34')],_0x9faacb[_0x6b2a('0x30')]);_0xbd7951[_0x6b2a('0x35')]=_[_0x6b2a('0x33')](_0x9faacb[_0x6b2a('0x34')],qs[_0x6b2a('0x36')](_0x321103[_0x6b2a('0x30')][_0x6b2a('0x36')]));_0xbd7951['attributes']=_0xbd7951[_0x6b2a('0x35')][_0x6b2a('0x37')]?_0xbd7951[_0x6b2a('0x35')]:_0x9faacb['model'];if(!_0x321103[_0x6b2a('0x30')][_0x6b2a('0x38')](_0x6b2a('0x39'))){_0xbd7951['limit']=qs[_0x6b2a('0x1d')](_0x321103[_0x6b2a('0x30')][_0x6b2a('0x1d')]);_0xbd7951['offset']=qs['offset'](_0x321103['query']['offset']);}_0xbd7951['order']=qs[_0x6b2a('0x3a')](_0x321103['query'][_0x6b2a('0x3a')]);_0xbd7951[_0x6b2a('0x3b')]=qs[_0x6b2a('0x32')](_[_0x6b2a('0x3c')](_0x321103['query'],_0x9faacb[_0x6b2a('0x32')]),_0x13b0df);if(_0x321103[_0x6b2a('0x30')][_0x6b2a('0x3d')]){_0xbd7951[_0x6b2a('0x3b')]=_[_0x6b2a('0x3e')](_0xbd7951['where'],{'$or':_['map'](_0x13b0df,function(_0x486ce9){if(_0x486ce9[_0x6b2a('0x2f')]!=='VIRTUAL'){var _0x2d38de={};_0x2d38de[_0x486ce9[_0x6b2a('0x2a')]]={'$like':'%'+_0x321103[_0x6b2a('0x30')]['filter']+'%'};return _0x2d38de;}})});}_0xbd7951=_['merge']({},_0xbd7951,_0x321103['options']);var _0x5e9b37={'where':_0xbd7951[_0x6b2a('0x3b')]};return db[_0x6b2a('0x3f')][_0x6b2a('0x1f')](_0x5e9b37)['then'](function(_0x4a83e3){_0x2e768a[_0x6b2a('0x1f')]=_0x4a83e3;if(_0x321103['query']['includeAll']){_0xbd7951[_0x6b2a('0x40')]=[{'all':!![]}];}return db[_0x6b2a('0x3f')]['findAll'](_0xbd7951);})[_0x6b2a('0x25')](function(_0x18e96f){_0x2e768a[_0x6b2a('0x41')]=_0x18e96f;return _0x2e768a;})[_0x6b2a('0x25')](respondWithFilteredResult(_0x16e871,_0xbd7951))['catch'](handleError(_0x16e871,null));};exports['show']=function(_0x5f3cb2,_0x593ab3){var _0x2bd678={'raw':![],'where':{'id':_0x5f3cb2[_0x6b2a('0x42')]['id']}},_0x4db482={};_0x4db482['model']=_[_0x6b2a('0x31')](db[_0x6b2a('0x3f')][_0x6b2a('0x43')]);_0x4db482[_0x6b2a('0x30')]=_[_0x6b2a('0x31')](_0x5f3cb2['query']);_0x4db482[_0x6b2a('0x32')]=_[_0x6b2a('0x33')](_0x4db482[_0x6b2a('0x34')],_0x4db482[_0x6b2a('0x30')]);_0x2bd678[_0x6b2a('0x35')]=_[_0x6b2a('0x33')](_0x4db482[_0x6b2a('0x34')],qs[_0x6b2a('0x36')](_0x5f3cb2[_0x6b2a('0x30')][_0x6b2a('0x36')]));_0x2bd678[_0x6b2a('0x35')]=_0x2bd678[_0x6b2a('0x35')]['length']?_0x2bd678[_0x6b2a('0x35')]:_0x4db482[_0x6b2a('0x34')];if(_0x5f3cb2[_0x6b2a('0x30')][_0x6b2a('0x44')]){_0x2bd678['include']=[{'all':!![]}];}_0x2bd678=_[_0x6b2a('0x3e')]({},_0x2bd678,_0x5f3cb2[_0x6b2a('0x45')]);return db[_0x6b2a('0x3f')][_0x6b2a('0x46')](_0x2bd678)[_0x6b2a('0x25')](handleEntityNotFound(_0x593ab3,null))[_0x6b2a('0x25')](respondWithResult(_0x593ab3,null))['catch'](handleError(_0x593ab3,null));};exports[_0x6b2a('0x47')]=function(_0x123a25,_0x2818eb){return db[_0x6b2a('0x3f')][_0x6b2a('0x47')](_0x123a25['body'],{})[_0x6b2a('0x25')](function(_0x23ae55){var _0x2fb896=_0x123a25[_0x6b2a('0x48')][_0x6b2a('0x26')]({'plain':!![]});if(!_0x2fb896)throw new Error(_0x6b2a('0x49'));if(_0x2fb896['role']===_0x6b2a('0x48')){var _0x5474b6=_0x23ae55[_0x6b2a('0x26')]({'plain':!![]});var _0x4560b6='Projects';return db[_0x6b2a('0x4a')][_0x6b2a('0x46')]({'where':{'name':_0x4560b6,'userProfileId':_0x2fb896['userProfileId']},'raw':!![]})[_0x6b2a('0x25')](function(_0x7c59cc){if(_0x7c59cc&&_0x7c59cc[_0x6b2a('0x4b')]===0x0){return db[_0x6b2a('0x28')][_0x6b2a('0x47')]({'name':_0x5474b6[_0x6b2a('0x2a')],'resourceId':_0x5474b6['id'],'type':_0x7c59cc['name'],'sectionId':_0x7c59cc['id']},{})['then'](function(){return _0x23ae55;});}else{return _0x23ae55;}})[_0x6b2a('0x4c')](function(_0x47e192){logger[_0x6b2a('0x4d')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x47e192);throw _0x47e192;});}return _0x23ae55;})[_0x6b2a('0x25')](respondWithResult(_0x2818eb,0xc9))[_0x6b2a('0x4c')](handleError(_0x2818eb,null));};exports[_0x6b2a('0x4e')]=function(_0x523551,_0x58f45d){var _0x9f1d88={'where':{'id':_0x523551[_0x6b2a('0x42')]['id']}},_0x6bc801={};_0x6bc801['model']=_[_0x6b2a('0x31')](db[_0x6b2a('0x3f')][_0x6b2a('0x43')]);_0x9f1d88[_0x6b2a('0x35')]=_[_0x6b2a('0x33')](_0x6bc801['model'],qs[_0x6b2a('0x36')](_0x523551[_0x6b2a('0x30')][_0x6b2a('0x36')]));_0x9f1d88[_0x6b2a('0x35')]=_0x9f1d88[_0x6b2a('0x35')][_0x6b2a('0x37')]?_0x9f1d88[_0x6b2a('0x35')]:_0x6bc801[_0x6b2a('0x34')];if(_0x523551[_0x6b2a('0x30')]['includeAll']){_0x9f1d88[_0x6b2a('0x40')]=[{'all':!![]}];}_0x9f1d88=_[_0x6b2a('0x3e')]({},_0x9f1d88,_0x523551[_0x6b2a('0x45')]);return db[_0x6b2a('0x3f')][_0x6b2a('0x46')](_0x9f1d88)[_0x6b2a('0x25')](handleEntityNotFound(_0x58f45d,null))[_0x6b2a('0x25')](function(_0x1e8a80){if(_0x1e8a80){var _0x273843=_0x1e8a80[_0x6b2a('0x26')]({'plain':!![]});_0x273843=qs[_0x6b2a('0x4f')](_0x273843,['id',_0x6b2a('0x50'),'updatedAt']);_0x523551[_0x6b2a('0x51')]=_['omit'](_0x523551['body'],['id',_0x6b2a('0x50'),'updatedAt']);return db['JscriptyProject']['create'](_[_0x6b2a('0x3e')](_0x273843,_0x523551['body']),{'include':_0x523551[_0x6b2a('0x30')]['includeAll']?[{'all':!![]}]:undefined})[_0x6b2a('0x25')](function(_0x4131c9){var _0x342caa=_0x523551[_0x6b2a('0x48')]['get']({'plain':!![]});if(!_0x342caa)throw new Error(_0x6b2a('0x49'));if(_0x342caa[_0x6b2a('0x52')]==='user'){var _0x454cdb=_0x4131c9[_0x6b2a('0x26')]({'plain':!![]});var _0x5965cb='Projects';return db[_0x6b2a('0x4a')]['find']({'where':{'name':_0x5965cb,'userProfileId':_0x342caa[_0x6b2a('0x53')]},'raw':!![]})[_0x6b2a('0x25')](function(_0x3a31b2){if(_0x3a31b2&&_0x3a31b2[_0x6b2a('0x4b')]===0x0){return db['UserProfileResource'][_0x6b2a('0x47')]({'name':_0x454cdb[_0x6b2a('0x2a')],'resourceId':_0x454cdb['id'],'type':_0x3a31b2[_0x6b2a('0x2a')],'sectionId':_0x3a31b2['id']},{})[_0x6b2a('0x25')](function(){return _0x4131c9;});}else{return _0x4131c9;}})[_0x6b2a('0x4c')](function(_0xb458a2){logger[_0x6b2a('0x4d')](_0x6b2a('0x54'),_0xb458a2);throw _0xb458a2;});}return _0x4131c9;});}})[_0x6b2a('0x25')](respondWithResult(_0x58f45d,0xc9))[_0x6b2a('0x4c')](handleError(_0x58f45d,null));};exports[_0x6b2a('0x23')]=function(_0x550d80,_0x925c89){if(_0x550d80[_0x6b2a('0x51')]['id']){delete _0x550d80[_0x6b2a('0x51')]['id'];}return db[_0x6b2a('0x3f')][_0x6b2a('0x46')]({'where':{'id':_0x550d80[_0x6b2a('0x42')]['id']}})[_0x6b2a('0x25')](handleEntityNotFound(_0x925c89,null))['then'](saveUpdates(_0x550d80[_0x6b2a('0x51')],null))[_0x6b2a('0x25')](respondWithResult(_0x925c89,null))[_0x6b2a('0x4c')](handleError(_0x925c89,null));};exports[_0x6b2a('0x24')]=function(_0x36a29b,_0x414612){return db[_0x6b2a('0x3f')][_0x6b2a('0x46')]({'where':{'id':_0x36a29b['params']['id']}})[_0x6b2a('0x25')](handleEntityNotFound(_0x414612,null))['then'](removeEntity(_0x414612,null))[_0x6b2a('0x4c')](handleError(_0x414612,null));};exports[_0x6b2a('0x55')]=function(_0x33c024,_0x5cd3f6,_0xd5b529){var _0x29c092={'raw':!![],'where':{}};var _0x324982={};var _0x367366={'count':0x0,'rows':[]};return db[_0x6b2a('0x3f')][_0x6b2a('0x56')]({'where':{'id':_0x33c024[_0x6b2a('0x42')]['id']}})['then'](handleEntityNotFound(_0x5cd3f6,null))[_0x6b2a('0x25')](function(_0x5b3e87){if(_0x5b3e87){_0x324982[_0x6b2a('0x34')]=_[_0x6b2a('0x31')](db[_0x6b2a('0x57')]['rawAttributes']);_0x324982[_0x6b2a('0x30')]=_[_0x6b2a('0x31')](_0x33c024[_0x6b2a('0x30')]);_0x324982[_0x6b2a('0x32')]=_[_0x6b2a('0x33')](_0x324982[_0x6b2a('0x34')],_0x324982['query']);_0x29c092[_0x6b2a('0x35')]=_['intersection'](_0x324982[_0x6b2a('0x34')],qs[_0x6b2a('0x36')](_0x33c024['query']['fields']));_0x29c092[_0x6b2a('0x35')]=_0x29c092[_0x6b2a('0x35')][_0x6b2a('0x37')]?_0x29c092['attributes']:_0x324982['model'];if(!_0x33c024[_0x6b2a('0x30')][_0x6b2a('0x38')](_0x6b2a('0x39'))){_0x29c092[_0x6b2a('0x1d')]=qs[_0x6b2a('0x1d')](_0x33c024[_0x6b2a('0x30')][_0x6b2a('0x1d')]);_0x29c092[_0x6b2a('0x20')]=qs[_0x6b2a('0x20')](_0x33c024[_0x6b2a('0x30')][_0x6b2a('0x20')]);}_0x29c092[_0x6b2a('0x58')]=qs[_0x6b2a('0x3a')](_0x33c024[_0x6b2a('0x30')]['sort']);_0x29c092[_0x6b2a('0x3b')]=qs['filters'](_[_0x6b2a('0x3c')](_0x33c024[_0x6b2a('0x30')],_0x324982['filters']));_0x29c092[_0x6b2a('0x3b')]['ProjectId']=_0x5b3e87['id'];if(_0x33c024['query']['filter']){_0x29c092['where']=_['merge'](_0x29c092[_0x6b2a('0x3b')],{'$or':_[_0x6b2a('0x2d')](_0x29c092[_0x6b2a('0x35')],function(_0xd984f9){var _0xd6ac23={};_0xd6ac23[_0xd984f9]={'$like':'%'+_0x33c024[_0x6b2a('0x30')][_0x6b2a('0x3d')]+'%'};return _0xd6ac23;})});}_0x29c092=_[_0x6b2a('0x3e')]({},_0x29c092,_0x33c024[_0x6b2a('0x45')]);return db['JscriptySessionReport'][_0x6b2a('0x1f')]({'where':_0x29c092[_0x6b2a('0x3b')]})[_0x6b2a('0x25')](function(_0x1babf4){_0x367366[_0x6b2a('0x1f')]=_0x1babf4;if(_0x33c024[_0x6b2a('0x30')][_0x6b2a('0x44')]){_0x29c092['include']=[{'all':!![]}];}return db[_0x6b2a('0x57')][_0x6b2a('0x59')](_0x29c092);})[_0x6b2a('0x25')](function(_0x5b3919){_0x367366[_0x6b2a('0x41')]=_0x5b3919;return _0x367366;});}})[_0x6b2a('0x25')](respondWithFilteredResult(_0x5cd3f6,_0x29c092))['catch'](handleError(_0x5cd3f6,null));};exports['getAnswers']=function(_0x116519,_0x3624ed,_0x47317f){var _0x2cfaf5={'raw':!![],'where':{}};var _0x1a5810={};var _0x3dc7a1={'count':0x0,'rows':[]};return db[_0x6b2a('0x3f')]['findOne']({'where':{'id':_0x116519[_0x6b2a('0x42')]['id']}})['then'](handleEntityNotFound(_0x3624ed,null))[_0x6b2a('0x25')](function(_0x2335dc){if(_0x2335dc){_0x1a5810[_0x6b2a('0x34')]=_[_0x6b2a('0x31')](db[_0x6b2a('0x5a')][_0x6b2a('0x43')]);_0x1a5810[_0x6b2a('0x30')]=_[_0x6b2a('0x31')](_0x116519[_0x6b2a('0x30')]);_0x1a5810[_0x6b2a('0x32')]=_[_0x6b2a('0x33')](_0x1a5810['model'],_0x1a5810[_0x6b2a('0x30')]);_0x2cfaf5[_0x6b2a('0x35')]=_[_0x6b2a('0x33')](_0x1a5810[_0x6b2a('0x34')],qs[_0x6b2a('0x36')](_0x116519[_0x6b2a('0x30')]['fields']));_0x2cfaf5[_0x6b2a('0x35')]=_0x2cfaf5['attributes'][_0x6b2a('0x37')]?_0x2cfaf5[_0x6b2a('0x35')]:_0x1a5810['model'];if(!_0x116519['query'][_0x6b2a('0x38')]('nolimit')){_0x2cfaf5['limit']=qs[_0x6b2a('0x1d')](_0x116519[_0x6b2a('0x30')][_0x6b2a('0x1d')]);_0x2cfaf5[_0x6b2a('0x20')]=qs[_0x6b2a('0x20')](_0x116519[_0x6b2a('0x30')][_0x6b2a('0x20')]);}_0x2cfaf5['order']=qs['sort'](_0x116519[_0x6b2a('0x30')][_0x6b2a('0x3a')]);_0x2cfaf5[_0x6b2a('0x3b')]=qs[_0x6b2a('0x32')](_['pick'](_0x116519[_0x6b2a('0x30')],_0x1a5810[_0x6b2a('0x32')]));_0x2cfaf5[_0x6b2a('0x3b')][_0x6b2a('0x5b')]=_0x2335dc['id'];if(_0x116519[_0x6b2a('0x30')]['filter']){_0x2cfaf5[_0x6b2a('0x3b')]=_[_0x6b2a('0x3e')](_0x2cfaf5['where'],{'$or':_[_0x6b2a('0x2d')](_0x2cfaf5[_0x6b2a('0x35')],function(_0x1895a5){var _0x1509ca={};_0x1509ca[_0x1895a5]={'$like':'%'+_0x116519['query']['filter']+'%'};return _0x1509ca;})});}_0x2cfaf5=_[_0x6b2a('0x3e')]({},_0x2cfaf5,_0x116519[_0x6b2a('0x45')]);return db['JscriptyAnswerReport'][_0x6b2a('0x1f')]({'where':_0x2cfaf5[_0x6b2a('0x3b')]})[_0x6b2a('0x25')](function(_0x20992c){_0x3dc7a1[_0x6b2a('0x1f')]=_0x20992c;if(_0x116519['query'][_0x6b2a('0x44')]){_0x2cfaf5[_0x6b2a('0x40')]=[{'all':!![]}];}return db[_0x6b2a('0x5a')][_0x6b2a('0x59')](_0x2cfaf5);})['then'](function(_0x1a8790){_0x3dc7a1[_0x6b2a('0x41')]=_0x1a8790;return _0x3dc7a1;});}})[_0x6b2a('0x25')](respondWithFilteredResult(_0x3624ed,_0x2cfaf5))[_0x6b2a('0x4c')](handleError(_0x3624ed,null));};function char(_0x13979d){return _0x6b2a('0x5c')===typeof _0x13979d?String['fromCharCode'][_0x6b2a('0x5d')](null,arguments):_0x13979d;}function needsEncapsulation(_0x342d55){return!!_0x342d55&&(_0x342d55[_0x6b2a('0x5e')]()['indexOf'](char(0xd))>=0x0||_0x342d55[_0x6b2a('0x5e')]()[_0x6b2a('0x5f')](char(0xa))>=0x0||_0x342d55[_0x6b2a('0x5e')]()[_0x6b2a('0x5f')](char(0x2c))>=0x0||_0x342d55[_0x6b2a('0x5e')]()['indexOf'](char(0x22))>=0x0);}function encapsulate(_0x2b7e83){var _0x14f42f=char(0x22),_0x1363a0='\x5c'+char(0x22),_0x4db402=_0x2b7e83[_0x6b2a('0x5e')]()[_0x6b2a('0x60')](new RegExp(_0x14f42f,'g'),_0x1363a0);return _0x14f42f+_0x4db402+_0x14f42f;}exports[_0x6b2a('0x61')]=function(_0x541d71,_0x224691,_0x1a681b){var _0x54ce29,_0x3bc69e;var _0x5292de={'where':{'ProjectId':_0x541d71[_0x6b2a('0x42')]['id']}};if(_0x541d71[_0x6b2a('0x30')][_0x6b2a('0x62')]){_0x5292de['where']['starttime']=JSON['parse'](_0x541d71['query']['startTime']);}return db['JscriptySessionReport'][_0x6b2a('0x59')](_0x5292de)['then'](handleEntityNotFound(_0x224691,null))[_0x6b2a('0x25')](function(_0x43aa74){if(_0x43aa74){_0x54ce29=_0x43aa74;return db['JscriptyQuestionReport'][_0x6b2a('0x59')]({'where':{'SessionId':{'$in':_['map'](_0x54ce29,'id')},'ProjectId':_0x541d71['params']['id']},'order':'-createdAt'});}})[_0x6b2a('0x25')](handleEntityNotFound(_0x224691,null))[_0x6b2a('0x25')](function(_0xfe59f7){if(_0xfe59f7){_0x3bc69e=_0xfe59f7;var _0x14e4bb={};for(var _0xd3f372=0x0,_0x32e52e=_0x3bc69e[_0x6b2a('0x37')];_0xd3f372<_0x32e52e;_0xd3f372++){if(!_0x14e4bb[_0x6b2a('0x38')](_0x3bc69e[_0xd3f372]['questionId'])){_0x14e4bb[_0x3bc69e[_0xd3f372]['questionId']]=needsEncapsulation(_0x3bc69e[_0xd3f372][_0x6b2a('0x63')])?encapsulate(_0x3bc69e[_0xd3f372][_0x6b2a('0x63')]):_0x3bc69e[_0xd3f372][_0x6b2a('0x63')];}}var _0x1b94f0=[],_0xbb57a0={};for(var _0x5b2e2f=0x0,_0x2c18c7=_0x54ce29[_0x6b2a('0x37')];_0x5b2e2f<_0x2c18c7;_0x5b2e2f++){_0xbb57a0={'ProjectId':_0x541d71[_0x6b2a('0x42')]['id'],'SessionId':_0x54ce29[_0x5b2e2f]['id'],'StartTime':moment(_0x54ce29[_0x5b2e2f][_0x6b2a('0x64')])[_0x6b2a('0x65')](_0x6b2a('0x66'))};for(var _0x338ce6=0x0,_0x32c000=_0x3bc69e[_0x6b2a('0x37')];_0x338ce6<_0x32c000;_0x338ce6++){if(_0x3bc69e[_0x338ce6][_0x6b2a('0x67')]==_0x54ce29[_0x5b2e2f]['id']&&_0x14e4bb[_0x6b2a('0x38')](_0x3bc69e[_0x338ce6][_0x6b2a('0x68')])){_0xbb57a0[_0x14e4bb[_0x3bc69e[_0x338ce6][_0x6b2a('0x68')]]]=_0x3bc69e[_0x338ce6][_0x6b2a('0x69')];}}for(var _0x3be469 in _0x14e4bb){if(!_0xbb57a0[_0x6b2a('0x38')](_0x14e4bb[_0x3be469])){_0xbb57a0[_0x14e4bb[_0x3be469]]=null;}}_0x1b94f0['push'](_0xbb57a0);}return _0x1b94f0;}})[_0x6b2a('0x25')](function(_0x283048){if(!_['isEmpty'](_0x283048)){var _0x3610b9=toCsv(_0x283048);var _0x1c7d7d=Date[_0x6b2a('0x6a')]();fs[_0x6b2a('0x6b')](util[_0x6b2a('0x65')](_0x6b2a('0x6c'),_0x541d71[_0x6b2a('0x42')]['id'],_0x1c7d7d),_0x3610b9);_0x224691['setHeader']('Content-disposition','attachment;\x20filename='+util[_0x6b2a('0x65')](_0x6b2a('0x6d'),_0x541d71['params']['id'],_0x1c7d7d));_0x224691[_0x6b2a('0x6e')]('Content-type',_0x6b2a('0x6f'));return _0x224691[_0x6b2a('0x70')](util[_0x6b2a('0x65')]('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x541d71[_0x6b2a('0x42')]['id'],_0x1c7d7d));}else{return _0x224691[_0x6b2a('0x19')](0xcc);}})['catch'](handleError(_0x224691,null));};
\ No newline at end of file
+var _0x2964=['indexOf','replace','getSummary','startTime','parse','JscriptyQuestionReport','-createdAt','questionId','question','format','YYYY-MM-DD\x20HH:mm:ss','answer','push','isEmpty','now','writeFileSync','/tmp/Jscripty_Project_%d_Summary_%s.csv','Content-disposition','Jscripty_Project_%d_Summary_%s.csv','setHeader','Content-type','download','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','status','json','offset','limit','undefined','count','set','Content-Range','apply','save','then','get','UserProfileResource','name','send','index','map','type','key','model','query','keys','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','JscriptyProject','includeAll','include','rows','catch','params','rawAttributes','find','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','Projects','UserProfileSection','userProfileId','omit','updatedAt','createdAt','autoAssociation','update','destroy','findOne','ProjectId','JscriptySessionReport','findAll','getAnswers','JscriptyAnswerReport','number','fromCharCode','toString'];(function(_0x6a5d4b,_0x4f4e6){var _0x1cad4c=function(_0x299be9){while(--_0x299be9){_0x6a5d4b['push'](_0x6a5d4b['shift']());}};_0x1cad4c(++_0x4f4e6);}(_0x2964,0x108));var _0x4296=function(_0x673ec4,_0x274a45){_0x673ec4=_0x673ec4-0x0;var _0xa3e21e=_0x2964[_0x673ec4];return _0xa3e21e;};'use strict';var emlformat=require(_0x4296('0x0'));var rimraf=require(_0x4296('0x1'));var zipdir=require(_0x4296('0x2'));var jsonpatch=require(_0x4296('0x3'));var rp=require(_0x4296('0x4'));var moment=require(_0x4296('0x5'));var BPromise=require(_0x4296('0x6'));var Mustache=require(_0x4296('0x7'));var util=require(_0x4296('0x8'));var path=require('path');var sox=require(_0x4296('0x9'));var csv=require(_0x4296('0xa'));var ejs=require(_0x4296('0xb'));var fs=require('fs');var fs_extra=require(_0x4296('0xc'));var _=require(_0x4296('0xd'));var squel=require(_0x4296('0xe'));var crypto=require('crypto');var jsforce=require(_0x4296('0xf'));var deskjs=require(_0x4296('0x10'));var toCsv=require(_0x4296('0xa'));var querystring=require(_0x4296('0x11'));var Papa=require(_0x4296('0x12'));var Redis=require(_0x4296('0x13'));var authService=require(_0x4296('0x14'));var qs=require(_0x4296('0x15'));var as=require(_0x4296('0x16'));var hardwareService=require(_0x4296('0x17'));var logger=require(_0x4296('0x18'))(_0x4296('0x19'));var utils=require('../../config/utils');var config=require(_0x4296('0x1a'));var licenseUtil=require(_0x4296('0x1b'));var db=require(_0x4296('0x1c'))['db'];function respondWithStatusCode(_0x367c95,_0x23ba5a){_0x23ba5a=_0x23ba5a||0xcc;return function(_0x676674){if(_0x676674){return _0x367c95[_0x4296('0x1d')](_0x23ba5a);}return _0x367c95['status'](_0x23ba5a)[_0x4296('0x1e')]();};}function respondWithResult(_0x350b4b,_0x3574da){_0x3574da=_0x3574da||0xc8;return function(_0x56b6d7){if(_0x56b6d7){return _0x350b4b[_0x4296('0x1f')](_0x3574da)[_0x4296('0x20')](_0x56b6d7);}};}function respondWithFilteredResult(_0x3f4699,_0x53af4b){return function(_0x182910){if(_0x182910){var _0x2e63c4=typeof _0x53af4b[_0x4296('0x21')]==='undefined'&&typeof _0x53af4b[_0x4296('0x22')]===_0x4296('0x23');var _0x8c0539=_0x182910[_0x4296('0x24')];var _0x7a226f=_0x2e63c4?0x0:_0x53af4b['offset'];var _0x2decf5=_0x2e63c4?_0x182910[_0x4296('0x24')]:_0x53af4b[_0x4296('0x21')]+_0x53af4b['limit'];var _0x13f40f;if(_0x2decf5>=_0x8c0539){_0x2decf5=_0x8c0539;_0x13f40f=0xc8;}else{_0x13f40f=0xce;}_0x3f4699[_0x4296('0x1f')](_0x13f40f);return _0x3f4699[_0x4296('0x25')](_0x4296('0x26'),_0x7a226f+'-'+_0x2decf5+'/'+_0x8c0539)[_0x4296('0x20')](_0x182910);}return null;};}function patchUpdates(_0x336894){return function(_0x4ca11f){try{jsonpatch[_0x4296('0x27')](_0x4ca11f,_0x336894,!![]);}catch(_0x2243ee){return BPromise['reject'](_0x2243ee);}return _0x4ca11f[_0x4296('0x28')]();};}function saveUpdates(_0x3de482,_0x257f51){return function(_0x3c899f){if(_0x3c899f){return _0x3c899f['update'](_0x3de482)['then'](function(_0x2fb2b4){return _0x2fb2b4;});}return null;};}function removeEntity(_0x3902b5,_0x4ce761){return function(_0x179e5d){if(_0x179e5d){return _0x179e5d['destroy']()[_0x4296('0x29')](function(){var _0xd620fa=_0x179e5d[_0x4296('0x2a')]({'plain':!![]});var _0x3d2028='Projects';return db[_0x4296('0x2b')]['destroy']({'where':{'type':_0x3d2028,'resourceId':_0xd620fa['id']}})[_0x4296('0x29')](function(){return _0x179e5d;});})['then'](function(){_0x3902b5['status'](0xcc)[_0x4296('0x1e')]();});}};}function handleEntityNotFound(_0x38a83c,_0x2a2903){return function(_0x4ce4ed){if(!_0x4ce4ed){_0x38a83c[_0x4296('0x1d')](0x194);}return _0x4ce4ed;};}function handleError(_0x3aa23e,_0x5015ce){_0x5015ce=_0x5015ce||0x1f4;return function(_0x30fa22){logger['error'](_0x30fa22['stack']);if(_0x30fa22[_0x4296('0x2c')]){delete _0x30fa22[_0x4296('0x2c')];}_0x3aa23e[_0x4296('0x1f')](_0x5015ce)[_0x4296('0x2d')](_0x30fa22);};}exports[_0x4296('0x2e')]=function(_0x2f9dcd,_0x33df03){var _0x9ac120={},_0x599a74={},_0x1a9b51={'count':0x0,'rows':[]};var _0x584ca4=_[_0x4296('0x2f')](db['JscriptyProject']['rawAttributes'],function(_0x1afd71){return{'name':_0x1afd71['fieldName'],'type':_0x1afd71[_0x4296('0x30')][_0x4296('0x31')]};});_0x599a74[_0x4296('0x32')]=_[_0x4296('0x2f')](_0x584ca4,_0x4296('0x2c'));_0x599a74[_0x4296('0x33')]=_[_0x4296('0x34')](_0x2f9dcd[_0x4296('0x33')]);_0x599a74[_0x4296('0x35')]=_[_0x4296('0x36')](_0x599a74[_0x4296('0x32')],_0x599a74['query']);_0x9ac120['attributes']=_[_0x4296('0x36')](_0x599a74[_0x4296('0x32')],qs[_0x4296('0x37')](_0x2f9dcd[_0x4296('0x33')]['fields']));_0x9ac120['attributes']=_0x9ac120[_0x4296('0x38')][_0x4296('0x39')]?_0x9ac120[_0x4296('0x38')]:_0x599a74[_0x4296('0x32')];if(!_0x2f9dcd['query'][_0x4296('0x3a')](_0x4296('0x3b'))){_0x9ac120['limit']=qs['limit'](_0x2f9dcd['query'][_0x4296('0x22')]);_0x9ac120[_0x4296('0x21')]=qs['offset'](_0x2f9dcd[_0x4296('0x33')][_0x4296('0x21')]);}_0x9ac120[_0x4296('0x3c')]=qs[_0x4296('0x3d')](_0x2f9dcd[_0x4296('0x33')][_0x4296('0x3d')]);_0x9ac120[_0x4296('0x3e')]=qs[_0x4296('0x35')](_[_0x4296('0x3f')](_0x2f9dcd[_0x4296('0x33')],_0x599a74[_0x4296('0x35')]),_0x584ca4);if(_0x2f9dcd[_0x4296('0x33')][_0x4296('0x40')]){_0x9ac120['where']=_[_0x4296('0x41')](_0x9ac120[_0x4296('0x3e')],{'$or':_[_0x4296('0x2f')](_0x584ca4,function(_0x2d153c){if(_0x2d153c[_0x4296('0x30')]!==_0x4296('0x42')){var _0x552bdc={};_0x552bdc[_0x2d153c[_0x4296('0x2c')]]={'$like':'%'+_0x2f9dcd[_0x4296('0x33')][_0x4296('0x40')]+'%'};return _0x552bdc;}})});}_0x9ac120=_['merge']({},_0x9ac120,_0x2f9dcd[_0x4296('0x43')]);var _0x53a825={'where':_0x9ac120[_0x4296('0x3e')]};return db[_0x4296('0x44')][_0x4296('0x24')](_0x53a825)[_0x4296('0x29')](function(_0x344eb5){_0x1a9b51[_0x4296('0x24')]=_0x344eb5;if(_0x2f9dcd['query'][_0x4296('0x45')]){_0x9ac120[_0x4296('0x46')]=[{'all':!![]}];}return db['JscriptyProject']['findAll'](_0x9ac120);})[_0x4296('0x29')](function(_0x3fffd3){_0x1a9b51[_0x4296('0x47')]=_0x3fffd3;return _0x1a9b51;})[_0x4296('0x29')](respondWithFilteredResult(_0x33df03,_0x9ac120))[_0x4296('0x48')](handleError(_0x33df03,null));};exports['show']=function(_0x504227,_0x456c19){var _0x28a74b={'raw':![],'where':{'id':_0x504227[_0x4296('0x49')]['id']}},_0x2d86a1={};_0x2d86a1[_0x4296('0x32')]=_[_0x4296('0x34')](db[_0x4296('0x44')][_0x4296('0x4a')]);_0x2d86a1[_0x4296('0x33')]=_['keys'](_0x504227[_0x4296('0x33')]);_0x2d86a1[_0x4296('0x35')]=_[_0x4296('0x36')](_0x2d86a1['model'],_0x2d86a1[_0x4296('0x33')]);_0x28a74b[_0x4296('0x38')]=_['intersection'](_0x2d86a1['model'],qs[_0x4296('0x37')](_0x504227[_0x4296('0x33')][_0x4296('0x37')]));_0x28a74b['attributes']=_0x28a74b['attributes']['length']?_0x28a74b[_0x4296('0x38')]:_0x2d86a1[_0x4296('0x32')];if(_0x504227[_0x4296('0x33')]['includeAll']){_0x28a74b['include']=[{'all':!![]}];}_0x28a74b=_[_0x4296('0x41')]({},_0x28a74b,_0x504227[_0x4296('0x43')]);return db[_0x4296('0x44')][_0x4296('0x4b')](_0x28a74b)[_0x4296('0x29')](handleEntityNotFound(_0x456c19,null))[_0x4296('0x29')](respondWithResult(_0x456c19,null))[_0x4296('0x48')](handleError(_0x456c19,null));};exports[_0x4296('0x4c')]=function(_0x598292,_0x419cab){return db[_0x4296('0x44')][_0x4296('0x4c')](_0x598292[_0x4296('0x4d')],{})[_0x4296('0x29')](function(_0x42de58){var _0x5ac423=_0x598292['user']['get']({'plain':!![]});if(!_0x5ac423)throw new Error(_0x4296('0x4e'));if(_0x5ac423[_0x4296('0x4f')]===_0x4296('0x50')){var _0x33a02b=_0x42de58['get']({'plain':!![]});var _0x2ac96d=_0x4296('0x51');return db[_0x4296('0x52')][_0x4296('0x4b')]({'where':{'name':_0x2ac96d,'userProfileId':_0x5ac423[_0x4296('0x53')]},'raw':!![]})[_0x4296('0x29')](function(_0x218136){if(_0x218136&&_0x218136['autoAssociation']===0x0){return db[_0x4296('0x2b')]['create']({'name':_0x33a02b['name'],'resourceId':_0x33a02b['id'],'type':_0x218136[_0x4296('0x2c')],'sectionId':_0x218136['id']},{})[_0x4296('0x29')](function(){return _0x42de58;});}else{return _0x42de58;}})['catch'](function(_0x17e212){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x17e212);throw _0x17e212;});}return _0x42de58;})[_0x4296('0x29')](respondWithResult(_0x419cab,0xc9))[_0x4296('0x48')](handleError(_0x419cab,null));};exports['clone']=function(_0x4faac4,_0x4691b4){var _0x2b82b1={'where':{'id':_0x4faac4[_0x4296('0x49')]['id']}},_0x57e01f={};_0x57e01f[_0x4296('0x32')]=_['keys'](db[_0x4296('0x44')][_0x4296('0x4a')]);_0x2b82b1['attributes']=_[_0x4296('0x36')](_0x57e01f[_0x4296('0x32')],qs[_0x4296('0x37')](_0x4faac4[_0x4296('0x33')][_0x4296('0x37')]));_0x2b82b1[_0x4296('0x38')]=_0x2b82b1['attributes'][_0x4296('0x39')]?_0x2b82b1[_0x4296('0x38')]:_0x57e01f[_0x4296('0x32')];if(_0x4faac4[_0x4296('0x33')]['includeAll']){_0x2b82b1['include']=[{'all':!![]}];}_0x2b82b1=_[_0x4296('0x41')]({},_0x2b82b1,_0x4faac4[_0x4296('0x43')]);return db['JscriptyProject'][_0x4296('0x4b')](_0x2b82b1)[_0x4296('0x29')](handleEntityNotFound(_0x4691b4,null))[_0x4296('0x29')](function(_0x45673f){if(_0x45673f){var _0x467a14=_0x45673f['get']({'plain':!![]});_0x467a14=qs[_0x4296('0x54')](_0x467a14,['id','createdAt',_0x4296('0x55')]);_0x4faac4['body']=_[_0x4296('0x54')](_0x4faac4[_0x4296('0x4d')],['id',_0x4296('0x56'),_0x4296('0x55')]);return db[_0x4296('0x44')][_0x4296('0x4c')](_[_0x4296('0x41')](_0x467a14,_0x4faac4[_0x4296('0x4d')]),{'include':_0x4faac4['query'][_0x4296('0x45')]?[{'all':!![]}]:undefined})[_0x4296('0x29')](function(_0x128f96){var _0x40dbcc=_0x4faac4['user'][_0x4296('0x2a')]({'plain':!![]});if(!_0x40dbcc)throw new Error(_0x4296('0x4e'));if(_0x40dbcc[_0x4296('0x4f')]===_0x4296('0x50')){var _0xd84151=_0x128f96[_0x4296('0x2a')]({'plain':!![]});var _0x309389=_0x4296('0x51');return db[_0x4296('0x52')][_0x4296('0x4b')]({'where':{'name':_0x309389,'userProfileId':_0x40dbcc[_0x4296('0x53')]},'raw':!![]})[_0x4296('0x29')](function(_0x3841c1){if(_0x3841c1&&_0x3841c1[_0x4296('0x57')]===0x0){return db[_0x4296('0x2b')]['create']({'name':_0xd84151[_0x4296('0x2c')],'resourceId':_0xd84151['id'],'type':_0x3841c1[_0x4296('0x2c')],'sectionId':_0x3841c1['id']},{})[_0x4296('0x29')](function(){return _0x128f96;});}else{return _0x128f96;}})[_0x4296('0x48')](function(_0x6e3e2e){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x6e3e2e);throw _0x6e3e2e;});}return _0x128f96;});}})[_0x4296('0x29')](respondWithResult(_0x4691b4,0xc9))[_0x4296('0x48')](handleError(_0x4691b4,null));};exports[_0x4296('0x58')]=function(_0x24054b,_0x36aee5){if(_0x24054b[_0x4296('0x4d')]['id']){delete _0x24054b[_0x4296('0x4d')]['id'];}return db['JscriptyProject']['find']({'where':{'id':_0x24054b['params']['id']}})[_0x4296('0x29')](handleEntityNotFound(_0x36aee5,null))[_0x4296('0x29')](saveUpdates(_0x24054b[_0x4296('0x4d')],null))['then'](respondWithResult(_0x36aee5,null))[_0x4296('0x48')](handleError(_0x36aee5,null));};exports[_0x4296('0x59')]=function(_0x281628,_0x1753d4){return db['JscriptyProject'][_0x4296('0x4b')]({'where':{'id':_0x281628[_0x4296('0x49')]['id']}})[_0x4296('0x29')](handleEntityNotFound(_0x1753d4,null))['then'](removeEntity(_0x1753d4,null))[_0x4296('0x48')](handleError(_0x1753d4,null));};exports['getSessions']=function(_0x912d9b,_0x538228,_0x5b76e8){var _0x3147da={'raw':!![],'where':{}};var _0x522a45={};var _0x171ffb={'count':0x0,'rows':[]};return db[_0x4296('0x44')][_0x4296('0x5a')]({'where':{'id':_0x912d9b[_0x4296('0x49')]['id']}})[_0x4296('0x29')](handleEntityNotFound(_0x538228,null))[_0x4296('0x29')](function(_0x7984a8){if(_0x7984a8){_0x522a45['model']=_[_0x4296('0x34')](db['JscriptySessionReport'][_0x4296('0x4a')]);_0x522a45['query']=_['keys'](_0x912d9b[_0x4296('0x33')]);_0x522a45['filters']=_[_0x4296('0x36')](_0x522a45['model'],_0x522a45['query']);_0x3147da[_0x4296('0x38')]=_[_0x4296('0x36')](_0x522a45['model'],qs[_0x4296('0x37')](_0x912d9b[_0x4296('0x33')]['fields']));_0x3147da[_0x4296('0x38')]=_0x3147da[_0x4296('0x38')]['length']?_0x3147da[_0x4296('0x38')]:_0x522a45[_0x4296('0x32')];if(!_0x912d9b[_0x4296('0x33')][_0x4296('0x3a')](_0x4296('0x3b'))){_0x3147da[_0x4296('0x22')]=qs['limit'](_0x912d9b[_0x4296('0x33')][_0x4296('0x22')]);_0x3147da[_0x4296('0x21')]=qs[_0x4296('0x21')](_0x912d9b[_0x4296('0x33')][_0x4296('0x21')]);}_0x3147da[_0x4296('0x3c')]=qs['sort'](_0x912d9b[_0x4296('0x33')][_0x4296('0x3d')]);_0x3147da[_0x4296('0x3e')]=qs[_0x4296('0x35')](_[_0x4296('0x3f')](_0x912d9b[_0x4296('0x33')],_0x522a45[_0x4296('0x35')]));_0x3147da[_0x4296('0x3e')][_0x4296('0x5b')]=_0x7984a8['id'];if(_0x912d9b[_0x4296('0x33')][_0x4296('0x40')]){_0x3147da['where']=_[_0x4296('0x41')](_0x3147da[_0x4296('0x3e')],{'$or':_[_0x4296('0x2f')](_0x3147da[_0x4296('0x38')],function(_0x4a901b){var _0x26754f={};_0x26754f[_0x4a901b]={'$like':'%'+_0x912d9b['query'][_0x4296('0x40')]+'%'};return _0x26754f;})});}_0x3147da=_[_0x4296('0x41')]({},_0x3147da,_0x912d9b[_0x4296('0x43')]);return db['JscriptySessionReport']['count']({'where':_0x3147da[_0x4296('0x3e')]})['then'](function(_0x515193){_0x171ffb[_0x4296('0x24')]=_0x515193;if(_0x912d9b[_0x4296('0x33')][_0x4296('0x45')]){_0x3147da[_0x4296('0x46')]=[{'all':!![]}];}return db[_0x4296('0x5c')][_0x4296('0x5d')](_0x3147da);})[_0x4296('0x29')](function(_0x4eea76){_0x171ffb['rows']=_0x4eea76;return _0x171ffb;});}})[_0x4296('0x29')](respondWithFilteredResult(_0x538228,_0x3147da))[_0x4296('0x48')](handleError(_0x538228,null));};exports[_0x4296('0x5e')]=function(_0x8f0bd6,_0x532980,_0x294dc7){var _0x33d0fa={'raw':!![],'where':{}};var _0x21b0e7={};var _0x1dadb6={'count':0x0,'rows':[]};return db['JscriptyProject'][_0x4296('0x5a')]({'where':{'id':_0x8f0bd6[_0x4296('0x49')]['id']}})[_0x4296('0x29')](handleEntityNotFound(_0x532980,null))[_0x4296('0x29')](function(_0x43316b){if(_0x43316b){_0x21b0e7[_0x4296('0x32')]=_[_0x4296('0x34')](db[_0x4296('0x5f')][_0x4296('0x4a')]);_0x21b0e7[_0x4296('0x33')]=_[_0x4296('0x34')](_0x8f0bd6[_0x4296('0x33')]);_0x21b0e7[_0x4296('0x35')]=_[_0x4296('0x36')](_0x21b0e7[_0x4296('0x32')],_0x21b0e7[_0x4296('0x33')]);_0x33d0fa[_0x4296('0x38')]=_[_0x4296('0x36')](_0x21b0e7[_0x4296('0x32')],qs[_0x4296('0x37')](_0x8f0bd6[_0x4296('0x33')][_0x4296('0x37')]));_0x33d0fa['attributes']=_0x33d0fa['attributes']['length']?_0x33d0fa[_0x4296('0x38')]:_0x21b0e7[_0x4296('0x32')];if(!_0x8f0bd6['query'][_0x4296('0x3a')](_0x4296('0x3b'))){_0x33d0fa[_0x4296('0x22')]=qs[_0x4296('0x22')](_0x8f0bd6['query'][_0x4296('0x22')]);_0x33d0fa[_0x4296('0x21')]=qs['offset'](_0x8f0bd6[_0x4296('0x33')][_0x4296('0x21')]);}_0x33d0fa['order']=qs[_0x4296('0x3d')](_0x8f0bd6[_0x4296('0x33')][_0x4296('0x3d')]);_0x33d0fa['where']=qs[_0x4296('0x35')](_[_0x4296('0x3f')](_0x8f0bd6[_0x4296('0x33')],_0x21b0e7[_0x4296('0x35')]));_0x33d0fa[_0x4296('0x3e')]['ProjectId']=_0x43316b['id'];if(_0x8f0bd6[_0x4296('0x33')][_0x4296('0x40')]){_0x33d0fa['where']=_[_0x4296('0x41')](_0x33d0fa[_0x4296('0x3e')],{'$or':_['map'](_0x33d0fa['attributes'],function(_0x12d001){var _0x46a875={};_0x46a875[_0x12d001]={'$like':'%'+_0x8f0bd6['query']['filter']+'%'};return _0x46a875;})});}_0x33d0fa=_[_0x4296('0x41')]({},_0x33d0fa,_0x8f0bd6['options']);return db['JscriptyAnswerReport'][_0x4296('0x24')]({'where':_0x33d0fa['where']})[_0x4296('0x29')](function(_0x5e0cdb){_0x1dadb6[_0x4296('0x24')]=_0x5e0cdb;if(_0x8f0bd6[_0x4296('0x33')]['includeAll']){_0x33d0fa[_0x4296('0x46')]=[{'all':!![]}];}return db[_0x4296('0x5f')][_0x4296('0x5d')](_0x33d0fa);})[_0x4296('0x29')](function(_0x2c4917){_0x1dadb6[_0x4296('0x47')]=_0x2c4917;return _0x1dadb6;});}})[_0x4296('0x29')](respondWithFilteredResult(_0x532980,_0x33d0fa))[_0x4296('0x48')](handleError(_0x532980,null));};function char(_0x3cfdac){return _0x4296('0x60')===typeof _0x3cfdac?String[_0x4296('0x61')]['apply'](null,arguments):_0x3cfdac;}function needsEncapsulation(_0x14b928){return!!_0x14b928&&(_0x14b928[_0x4296('0x62')]()['indexOf'](char(0xd))>=0x0||_0x14b928[_0x4296('0x62')]()[_0x4296('0x63')](char(0xa))>=0x0||_0x14b928[_0x4296('0x62')]()[_0x4296('0x63')](char(0x2c))>=0x0||_0x14b928[_0x4296('0x62')]()['indexOf'](char(0x22))>=0x0);}function encapsulate(_0x158102){var _0x4f0aa3=char(0x22),_0x50fb34='\x5c'+char(0x22),_0x2823d6=_0x158102[_0x4296('0x62')]()[_0x4296('0x64')](new RegExp(_0x4f0aa3,'g'),_0x50fb34);return _0x4f0aa3+_0x2823d6+_0x4f0aa3;}exports[_0x4296('0x65')]=function(_0x834988,_0x34f748,_0x53c8f0){var _0x466c75,_0x58b411;var _0x59fbc3={'where':{'ProjectId':_0x834988[_0x4296('0x49')]['id']}};if(_0x834988[_0x4296('0x33')][_0x4296('0x66')]){_0x59fbc3['where']['starttime']=JSON[_0x4296('0x67')](_0x834988[_0x4296('0x33')]['startTime']);}return db[_0x4296('0x5c')][_0x4296('0x5d')](_0x59fbc3)['then'](handleEntityNotFound(_0x34f748,null))['then'](function(_0x1f7ff8){if(_0x1f7ff8){_0x466c75=_0x1f7ff8;return db[_0x4296('0x68')][_0x4296('0x5d')]({'where':{'SessionId':{'$in':_[_0x4296('0x2f')](_0x466c75,'id')},'ProjectId':_0x834988['params']['id']},'order':_0x4296('0x69')});}})[_0x4296('0x29')](handleEntityNotFound(_0x34f748,null))['then'](function(_0x29f3a7){if(_0x29f3a7){_0x58b411=_0x29f3a7;var _0x4e8540={};for(var _0x1dfd3a=0x0,_0x465ce2=_0x58b411[_0x4296('0x39')];_0x1dfd3a<_0x465ce2;_0x1dfd3a++){if(!_0x4e8540['hasOwnProperty'](_0x58b411[_0x1dfd3a]['questionId'])){_0x4e8540[_0x58b411[_0x1dfd3a][_0x4296('0x6a')]]=needsEncapsulation(_0x58b411[_0x1dfd3a][_0x4296('0x6b')])?encapsulate(_0x58b411[_0x1dfd3a][_0x4296('0x6b')]):_0x58b411[_0x1dfd3a][_0x4296('0x6b')];}}var _0x912ddf=[],_0x3c50dc={};for(var _0x859b54=0x0,_0x4487bc=_0x466c75['length'];_0x859b54<_0x4487bc;_0x859b54++){_0x3c50dc={'ProjectId':_0x834988[_0x4296('0x49')]['id'],'SessionId':_0x466c75[_0x859b54]['id'],'StartTime':moment(_0x466c75[_0x859b54]['starttime'])[_0x4296('0x6c')](_0x4296('0x6d'))};for(var _0x47af12=0x0,_0x14d612=_0x58b411[_0x4296('0x39')];_0x47af12<_0x14d612;_0x47af12++){if(_0x58b411[_0x47af12]['SessionId']==_0x466c75[_0x859b54]['id']&&_0x4e8540[_0x4296('0x3a')](_0x58b411[_0x47af12]['questionId'])){_0x3c50dc[_0x4e8540[_0x58b411[_0x47af12][_0x4296('0x6a')]]]=_0x58b411[_0x47af12][_0x4296('0x6e')];}}for(var _0x4b5fa0 in _0x4e8540){if(!_0x3c50dc[_0x4296('0x3a')](_0x4e8540[_0x4b5fa0])){_0x3c50dc[_0x4e8540[_0x4b5fa0]]=null;}}_0x912ddf[_0x4296('0x6f')](_0x3c50dc);}return _0x912ddf;}})[_0x4296('0x29')](function(_0x404174){if(!_[_0x4296('0x70')](_0x404174)){var _0xb5e199=toCsv(_0x404174);var _0x404703=Date[_0x4296('0x71')]();fs[_0x4296('0x72')](util['format'](_0x4296('0x73'),_0x834988[_0x4296('0x49')]['id'],_0x404703),_0xb5e199);_0x34f748['setHeader'](_0x4296('0x74'),'attachment;\x20filename='+util['format'](_0x4296('0x75'),_0x834988[_0x4296('0x49')]['id'],_0x404703));_0x34f748[_0x4296('0x76')](_0x4296('0x77'),'text/csv');return _0x34f748[_0x4296('0x78')](util[_0x4296('0x6c')](_0x4296('0x73'),_0x834988[_0x4296('0x49')]['id'],_0x404703));}else{return _0x34f748[_0x4296('0x1d')](0xcc);}})['catch'](handleError(_0x34f748,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff