// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xd958=['filters','intersection','attributes','fields','length','nolimit','sort','pick','filter','where','merge','VIRTUAL','options','JscriptyProject','includeAll','include','rows','show','params','find','catch','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','UserProfileSection','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','createdAt','updatedAt','omit','autoAssociation','error','update','getSessions','JscriptySessionReport','hasOwnProperty','order','ProjectId','findAll','getAnswers','findOne','JscriptyAnswerReport','number','fromCharCode','toString','indexOf','replace','getSummary','startTime','starttime','parse','-createdAt','questionId','question','format','YYYY-MM-DD\x20HH:mm:ss','SessionId','writeFileSync','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','Content-disposition','Jscripty_Project_%d_Summary_%s.csv','Content-type','text/csv','download','eml-format','rimraf','request-promise','bluebird','mustache','util','path','sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../config/license/hardware','../../config/logger','api','../../config/environment','../../mysqldb','sendStatus','end','json','offset','undefined','limit','count','status','Content-Range','apply','save','destroy','then','get','Projects','UserProfileResource','stack','name','send','index','map','rawAttributes','type','key','model','keys','query'];(function(_0x967533,_0x1c89d2){var _0x9ad562=function(_0x4d8b1a){while(--_0x4d8b1a){_0x967533['push'](_0x967533['shift']());}};_0x9ad562(++_0x1c89d2);}(_0xd958,0xb8));var _0x8d95=function(_0x2db12b,_0x30ab1d){_0x2db12b=_0x2db12b-0x0;var _0x20990b=_0xd958[_0x2db12b];return _0x20990b;};'use strict';var emlformat=require(_0x8d95('0x0'));var rimraf=require(_0x8d95('0x1'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x8d95('0x2'));var moment=require('moment');var BPromise=require(_0x8d95('0x3'));var Mustache=require(_0x8d95('0x4'));var util=require(_0x8d95('0x5'));var path=require(_0x8d95('0x6'));var sox=require(_0x8d95('0x7'));var csv=require(_0x8d95('0x8'));var ejs=require(_0x8d95('0x9'));var fs=require('fs');var fs_extra=require(_0x8d95('0xa'));var _=require('lodash');var squel=require(_0x8d95('0xb'));var crypto=require(_0x8d95('0xc'));var jsforce=require(_0x8d95('0xd'));var deskjs=require(_0x8d95('0xe'));var toCsv=require(_0x8d95('0x8'));var querystring=require('querystring');var Papa=require(_0x8d95('0xf'));var Redis=require(_0x8d95('0x10'));var authService=require(_0x8d95('0x11'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x8d95('0x12'));var logger=require(_0x8d95('0x13'))(_0x8d95('0x14'));var utils=require('../../config/utils');var config=require(_0x8d95('0x15'));var licenseUtil=require('../../config/license/util');var db=require(_0x8d95('0x16'))['db'];function respondWithStatusCode(_0x10b0f1,_0x501dda){_0x501dda=_0x501dda||0xcc;return function(_0x3f8f73){if(_0x3f8f73){return _0x10b0f1[_0x8d95('0x17')](_0x501dda);}return _0x10b0f1['status'](_0x501dda)[_0x8d95('0x18')]();};}function respondWithResult(_0x1dca52,_0x37ef50){_0x37ef50=_0x37ef50||0xc8;return function(_0x31d0ef){if(_0x31d0ef){return _0x1dca52['status'](_0x37ef50)[_0x8d95('0x19')](_0x31d0ef);}};}function respondWithFilteredResult(_0x43d4fc,_0x4e0740){return function(_0x57a2cc){if(_0x57a2cc){var _0x11f4fd=typeof _0x4e0740[_0x8d95('0x1a')]===_0x8d95('0x1b')&&typeof _0x4e0740[_0x8d95('0x1c')]===_0x8d95('0x1b');var _0x3717c8=_0x57a2cc[_0x8d95('0x1d')];var _0x475042=_0x11f4fd?0x0:_0x4e0740[_0x8d95('0x1a')];var _0x4d6577=_0x11f4fd?_0x57a2cc['count']:_0x4e0740[_0x8d95('0x1a')]+_0x4e0740[_0x8d95('0x1c')];var _0x544f65;if(_0x4d6577>=_0x3717c8){_0x4d6577=_0x3717c8;_0x544f65=0xc8;}else{_0x544f65=0xce;}_0x43d4fc[_0x8d95('0x1e')](_0x544f65);return _0x43d4fc['set'](_0x8d95('0x1f'),_0x475042+'-'+_0x4d6577+'/'+_0x3717c8)[_0x8d95('0x19')](_0x57a2cc);}return null;};}function patchUpdates(_0x5e93d2){return function(_0x591466){try{jsonpatch[_0x8d95('0x20')](_0x591466,_0x5e93d2,!![]);}catch(_0x5ca91e){return BPromise['reject'](_0x5ca91e);}return _0x591466[_0x8d95('0x21')]();};}function saveUpdates(_0x104ef4,_0x3c700e){return function(_0x1ad861){if(_0x1ad861){return _0x1ad861['update'](_0x104ef4)['then'](function(_0x2992f2){return _0x2992f2;});}return null;};}function removeEntity(_0x42b6e6,_0x5007be){return function(_0x1b4e1c){if(_0x1b4e1c){return _0x1b4e1c[_0x8d95('0x22')]()[_0x8d95('0x23')](function(){var _0x1b01b5=_0x1b4e1c[_0x8d95('0x24')]({'plain':!![]});var _0x24d13c=_0x8d95('0x25');return db[_0x8d95('0x26')]['destroy']({'where':{'type':_0x24d13c,'resourceId':_0x1b01b5['id']}})[_0x8d95('0x23')](function(){return _0x1b4e1c;});})[_0x8d95('0x23')](function(){_0x42b6e6[_0x8d95('0x1e')](0xcc)[_0x8d95('0x18')]();});}};}function handleEntityNotFound(_0x44cb0b,_0x231437){return function(_0x39c47e){if(!_0x39c47e){_0x44cb0b[_0x8d95('0x17')](0x194);}return _0x39c47e;};}function handleError(_0x436f5a,_0xe3c6d){_0xe3c6d=_0xe3c6d||0x1f4;return function(_0xf87282){logger['error'](_0xf87282[_0x8d95('0x27')]);if(_0xf87282[_0x8d95('0x28')]){delete _0xf87282['name'];}_0x436f5a[_0x8d95('0x1e')](_0xe3c6d)[_0x8d95('0x29')](_0xf87282);};}exports[_0x8d95('0x2a')]=function(_0x16fd40,_0x4bbc04){var _0xf7fff={},_0xf536a0={},_0x2f9d2e={'count':0x0,'rows':[]};var _0x33ef61=_[_0x8d95('0x2b')](db['JscriptyProject'][_0x8d95('0x2c')],function(_0x46fd8e){return{'name':_0x46fd8e['fieldName'],'type':_0x46fd8e[_0x8d95('0x2d')][_0x8d95('0x2e')]};});_0xf536a0[_0x8d95('0x2f')]=_[_0x8d95('0x2b')](_0x33ef61,'name');_0xf536a0['query']=_[_0x8d95('0x30')](_0x16fd40[_0x8d95('0x31')]);_0xf536a0[_0x8d95('0x32')]=_[_0x8d95('0x33')](_0xf536a0['model'],_0xf536a0['query']);_0xf7fff[_0x8d95('0x34')]=_['intersection'](_0xf536a0[_0x8d95('0x2f')],qs[_0x8d95('0x35')](_0x16fd40[_0x8d95('0x31')]['fields']));_0xf7fff[_0x8d95('0x34')]=_0xf7fff[_0x8d95('0x34')][_0x8d95('0x36')]?_0xf7fff[_0x8d95('0x34')]:_0xf536a0[_0x8d95('0x2f')];if(!_0x16fd40[_0x8d95('0x31')]['hasOwnProperty'](_0x8d95('0x37'))){_0xf7fff[_0x8d95('0x1c')]=qs[_0x8d95('0x1c')](_0x16fd40[_0x8d95('0x31')][_0x8d95('0x1c')]);_0xf7fff[_0x8d95('0x1a')]=qs[_0x8d95('0x1a')](_0x16fd40[_0x8d95('0x31')][_0x8d95('0x1a')]);}_0xf7fff['order']=qs[_0x8d95('0x38')](_0x16fd40[_0x8d95('0x31')][_0x8d95('0x38')]);_0xf7fff['where']=qs['filters'](_[_0x8d95('0x39')](_0x16fd40['query'],_0xf536a0[_0x8d95('0x32')]),_0x33ef61);if(_0x16fd40[_0x8d95('0x31')][_0x8d95('0x3a')]){_0xf7fff[_0x8d95('0x3b')]=_[_0x8d95('0x3c')](_0xf7fff[_0x8d95('0x3b')],{'$or':_[_0x8d95('0x2b')](_0x33ef61,function(_0x1a949d){if(_0x1a949d['type']!==_0x8d95('0x3d')){var _0x2631d2={};_0x2631d2[_0x1a949d[_0x8d95('0x28')]]={'$like':'%'+_0x16fd40[_0x8d95('0x31')]['filter']+'%'};return _0x2631d2;}})});}_0xf7fff=_[_0x8d95('0x3c')]({},_0xf7fff,_0x16fd40[_0x8d95('0x3e')]);var _0x49ad7c={'where':_0xf7fff[_0x8d95('0x3b')]};return db[_0x8d95('0x3f')][_0x8d95('0x1d')](_0x49ad7c)[_0x8d95('0x23')](function(_0xe52194){_0x2f9d2e['count']=_0xe52194;if(_0x16fd40['query'][_0x8d95('0x40')]){_0xf7fff[_0x8d95('0x41')]=[{'all':!![]}];}return db['JscriptyProject']['findAll'](_0xf7fff);})[_0x8d95('0x23')](function(_0x12b322){_0x2f9d2e[_0x8d95('0x42')]=_0x12b322;return _0x2f9d2e;})[_0x8d95('0x23')](respondWithFilteredResult(_0x4bbc04,_0xf7fff))['catch'](handleError(_0x4bbc04,null));};exports[_0x8d95('0x43')]=function(_0x58bbe6,_0x33aabd){var _0xb79351={'raw':![],'where':{'id':_0x58bbe6[_0x8d95('0x44')]['id']}},_0x57b791={};_0x57b791['model']=_[_0x8d95('0x30')](db[_0x8d95('0x3f')]['rawAttributes']);_0x57b791[_0x8d95('0x31')]=_[_0x8d95('0x30')](_0x58bbe6[_0x8d95('0x31')]);_0x57b791[_0x8d95('0x32')]=_[_0x8d95('0x33')](_0x57b791[_0x8d95('0x2f')],_0x57b791[_0x8d95('0x31')]);_0xb79351['attributes']=_['intersection'](_0x57b791[_0x8d95('0x2f')],qs[_0x8d95('0x35')](_0x58bbe6[_0x8d95('0x31')][_0x8d95('0x35')]));_0xb79351[_0x8d95('0x34')]=_0xb79351['attributes'][_0x8d95('0x36')]?_0xb79351[_0x8d95('0x34')]:_0x57b791[_0x8d95('0x2f')];if(_0x58bbe6[_0x8d95('0x31')][_0x8d95('0x40')]){_0xb79351[_0x8d95('0x41')]=[{'all':!![]}];}_0xb79351=_[_0x8d95('0x3c')]({},_0xb79351,_0x58bbe6['options']);return db[_0x8d95('0x3f')][_0x8d95('0x45')](_0xb79351)['then'](handleEntityNotFound(_0x33aabd,null))[_0x8d95('0x23')](respondWithResult(_0x33aabd,null))[_0x8d95('0x46')](handleError(_0x33aabd,null));};exports[_0x8d95('0x47')]=function(_0xb9240c,_0x37a5bb){return db[_0x8d95('0x3f')][_0x8d95('0x47')](_0xb9240c[_0x8d95('0x48')],{})['then'](function(_0x217d67){var _0x3ca088=_0xb9240c[_0x8d95('0x49')][_0x8d95('0x24')]({'plain':!![]});if(!_0x3ca088)throw new Error(_0x8d95('0x4a'));if(_0x3ca088['role']===_0x8d95('0x49')){var _0x4f3aa2=_0x217d67[_0x8d95('0x24')]({'plain':!![]});var _0x16b4a8=_0x8d95('0x25');return db[_0x8d95('0x4b')][_0x8d95('0x45')]({'where':{'name':_0x16b4a8,'userProfileId':_0x3ca088[_0x8d95('0x4c')]},'raw':!![]})['then'](function(_0x117ddf){if(_0x117ddf&&_0x117ddf['autoAssociation']===0x0){return db[_0x8d95('0x26')][_0x8d95('0x47')]({'name':_0x4f3aa2[_0x8d95('0x28')],'resourceId':_0x4f3aa2['id'],'type':_0x117ddf[_0x8d95('0x28')],'sectionId':_0x117ddf['id']},{})[_0x8d95('0x23')](function(){return _0x217d67;});}else{return _0x217d67;}})[_0x8d95('0x46')](function(_0x47b85b){logger['error'](_0x8d95('0x4d'),_0x47b85b);throw _0x47b85b;});}return _0x217d67;})[_0x8d95('0x23')](respondWithResult(_0x37a5bb,0xc9))[_0x8d95('0x46')](handleError(_0x37a5bb,null));};exports[_0x8d95('0x4e')]=function(_0x2d18bd,_0x1264d2){var _0x5e6683={'where':{'id':_0x2d18bd['params']['id']}},_0x51cf45={};_0x51cf45[_0x8d95('0x2f')]=_[_0x8d95('0x30')](db['JscriptyProject'][_0x8d95('0x2c')]);_0x5e6683[_0x8d95('0x34')]=_[_0x8d95('0x33')](_0x51cf45[_0x8d95('0x2f')],qs['fields'](_0x2d18bd[_0x8d95('0x31')][_0x8d95('0x35')]));_0x5e6683[_0x8d95('0x34')]=_0x5e6683[_0x8d95('0x34')][_0x8d95('0x36')]?_0x5e6683['attributes']:_0x51cf45[_0x8d95('0x2f')];if(_0x2d18bd[_0x8d95('0x31')]['includeAll']){_0x5e6683['include']=[{'all':!![]}];}_0x5e6683=_[_0x8d95('0x3c')]({},_0x5e6683,_0x2d18bd['options']);return db[_0x8d95('0x3f')]['find'](_0x5e6683)[_0x8d95('0x23')](handleEntityNotFound(_0x1264d2,null))['then'](function(_0x2fb4be){if(_0x2fb4be){var _0x4b0bd9=_0x2fb4be[_0x8d95('0x24')]({'plain':!![]});_0x4b0bd9=qs['omit'](_0x4b0bd9,['id',_0x8d95('0x4f'),_0x8d95('0x50')]);_0x2d18bd[_0x8d95('0x48')]=_[_0x8d95('0x51')](_0x2d18bd['body'],['id',_0x8d95('0x4f'),'updatedAt']);return db[_0x8d95('0x3f')][_0x8d95('0x47')](_[_0x8d95('0x3c')](_0x4b0bd9,_0x2d18bd[_0x8d95('0x48')]),{'include':_0x2d18bd[_0x8d95('0x31')][_0x8d95('0x40')]?[{'all':!![]}]:undefined})[_0x8d95('0x23')](function(_0x3bf409){var _0x43d33d=_0x2d18bd['user'][_0x8d95('0x24')]({'plain':!![]});if(!_0x43d33d)throw new Error(_0x8d95('0x4a'));if(_0x43d33d['role']===_0x8d95('0x49')){var _0x4b45ae=_0x3bf409[_0x8d95('0x24')]({'plain':!![]});var _0x173efc=_0x8d95('0x25');return db['UserProfileSection'][_0x8d95('0x45')]({'where':{'name':_0x173efc,'userProfileId':_0x43d33d[_0x8d95('0x4c')]},'raw':!![]})[_0x8d95('0x23')](function(_0x1d68ce){if(_0x1d68ce&&_0x1d68ce[_0x8d95('0x52')]===0x0){return db[_0x8d95('0x26')][_0x8d95('0x47')]({'name':_0x4b45ae[_0x8d95('0x28')],'resourceId':_0x4b45ae['id'],'type':_0x1d68ce[_0x8d95('0x28')],'sectionId':_0x1d68ce['id']},{})[_0x8d95('0x23')](function(){return _0x3bf409;});}else{return _0x3bf409;}})[_0x8d95('0x46')](function(_0x4d05f3){logger[_0x8d95('0x53')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x4d05f3);throw _0x4d05f3;});}return _0x3bf409;});}})[_0x8d95('0x23')](respondWithResult(_0x1264d2,0xc9))[_0x8d95('0x46')](handleError(_0x1264d2,null));};exports[_0x8d95('0x54')]=function(_0x2e227f,_0x4f6368){if(_0x2e227f[_0x8d95('0x48')]['id']){delete _0x2e227f[_0x8d95('0x48')]['id'];}return db[_0x8d95('0x3f')]['find']({'where':{'id':_0x2e227f['params']['id']}})['then'](handleEntityNotFound(_0x4f6368,null))[_0x8d95('0x23')](saveUpdates(_0x2e227f['body'],null))[_0x8d95('0x23')](respondWithResult(_0x4f6368,null))[_0x8d95('0x46')](handleError(_0x4f6368,null));};exports[_0x8d95('0x22')]=function(_0x286a08,_0x36b6cd){return db['JscriptyProject'][_0x8d95('0x45')]({'where':{'id':_0x286a08[_0x8d95('0x44')]['id']}})[_0x8d95('0x23')](handleEntityNotFound(_0x36b6cd,null))[_0x8d95('0x23')](removeEntity(_0x36b6cd,null))['catch'](handleError(_0x36b6cd,null));};exports[_0x8d95('0x55')]=function(_0x1655eb,_0x320cc4,_0x85e1a2){var _0x5ec515={'raw':!![],'where':{}};var _0x599099={};var _0x422286={'count':0x0,'rows':[]};return db[_0x8d95('0x3f')]['findOne']({'where':{'id':_0x1655eb['params']['id']}})['then'](handleEntityNotFound(_0x320cc4,null))['then'](function(_0x3fb5b8){if(_0x3fb5b8){_0x599099[_0x8d95('0x2f')]=_[_0x8d95('0x30')](db[_0x8d95('0x56')][_0x8d95('0x2c')]);_0x599099[_0x8d95('0x31')]=_['keys'](_0x1655eb[_0x8d95('0x31')]);_0x599099[_0x8d95('0x32')]=_[_0x8d95('0x33')](_0x599099[_0x8d95('0x2f')],_0x599099['query']);_0x5ec515[_0x8d95('0x34')]=_[_0x8d95('0x33')](_0x599099[_0x8d95('0x2f')],qs[_0x8d95('0x35')](_0x1655eb[_0x8d95('0x31')][_0x8d95('0x35')]));_0x5ec515[_0x8d95('0x34')]=_0x5ec515['attributes'][_0x8d95('0x36')]?_0x5ec515[_0x8d95('0x34')]:_0x599099[_0x8d95('0x2f')];if(!_0x1655eb['query'][_0x8d95('0x57')]('nolimit')){_0x5ec515[_0x8d95('0x1c')]=qs[_0x8d95('0x1c')](_0x1655eb[_0x8d95('0x31')][_0x8d95('0x1c')]);_0x5ec515[_0x8d95('0x1a')]=qs['offset'](_0x1655eb[_0x8d95('0x31')][_0x8d95('0x1a')]);}_0x5ec515[_0x8d95('0x58')]=qs[_0x8d95('0x38')](_0x1655eb[_0x8d95('0x31')][_0x8d95('0x38')]);_0x5ec515[_0x8d95('0x3b')]=qs[_0x8d95('0x32')](_[_0x8d95('0x39')](_0x1655eb[_0x8d95('0x31')],_0x599099[_0x8d95('0x32')]));_0x5ec515[_0x8d95('0x3b')][_0x8d95('0x59')]=_0x3fb5b8['id'];if(_0x1655eb['query']['filter']){_0x5ec515['where']=_['merge'](_0x5ec515[_0x8d95('0x3b')],{'$or':_[_0x8d95('0x2b')](_0x5ec515[_0x8d95('0x34')],function(_0x1937d1){var _0x4d67ee={};_0x4d67ee[_0x1937d1]={'$like':'%'+_0x1655eb[_0x8d95('0x31')][_0x8d95('0x3a')]+'%'};return _0x4d67ee;})});}_0x5ec515=_[_0x8d95('0x3c')]({},_0x5ec515,_0x1655eb['options']);return db['JscriptySessionReport'][_0x8d95('0x1d')]({'where':_0x5ec515[_0x8d95('0x3b')]})['then'](function(_0xe3f2b2){_0x422286['count']=_0xe3f2b2;if(_0x1655eb['query'][_0x8d95('0x40')]){_0x5ec515[_0x8d95('0x41')]=[{'all':!![]}];}return db[_0x8d95('0x56')][_0x8d95('0x5a')](_0x5ec515);})[_0x8d95('0x23')](function(_0x565827){_0x422286['rows']=_0x565827;return _0x422286;});}})[_0x8d95('0x23')](respondWithFilteredResult(_0x320cc4,_0x5ec515))[_0x8d95('0x46')](handleError(_0x320cc4,null));};exports[_0x8d95('0x5b')]=function(_0xd4ea46,_0x3695be,_0xc3344){var _0xb59cd5={'raw':!![],'where':{}};var _0x54b9b8={};var _0x19d45f={'count':0x0,'rows':[]};return db[_0x8d95('0x3f')][_0x8d95('0x5c')]({'where':{'id':_0xd4ea46[_0x8d95('0x44')]['id']}})[_0x8d95('0x23')](handleEntityNotFound(_0x3695be,null))[_0x8d95('0x23')](function(_0x168f2e){if(_0x168f2e){_0x54b9b8[_0x8d95('0x2f')]=_[_0x8d95('0x30')](db['JscriptyAnswerReport'][_0x8d95('0x2c')]);_0x54b9b8[_0x8d95('0x31')]=_[_0x8d95('0x30')](_0xd4ea46[_0x8d95('0x31')]);_0x54b9b8[_0x8d95('0x32')]=_[_0x8d95('0x33')](_0x54b9b8[_0x8d95('0x2f')],_0x54b9b8['query']);_0xb59cd5[_0x8d95('0x34')]=_[_0x8d95('0x33')](_0x54b9b8[_0x8d95('0x2f')],qs[_0x8d95('0x35')](_0xd4ea46[_0x8d95('0x31')]['fields']));_0xb59cd5[_0x8d95('0x34')]=_0xb59cd5[_0x8d95('0x34')][_0x8d95('0x36')]?_0xb59cd5[_0x8d95('0x34')]:_0x54b9b8[_0x8d95('0x2f')];if(!_0xd4ea46[_0x8d95('0x31')][_0x8d95('0x57')](_0x8d95('0x37'))){_0xb59cd5[_0x8d95('0x1c')]=qs[_0x8d95('0x1c')](_0xd4ea46[_0x8d95('0x31')][_0x8d95('0x1c')]);_0xb59cd5['offset']=qs[_0x8d95('0x1a')](_0xd4ea46[_0x8d95('0x31')][_0x8d95('0x1a')]);}_0xb59cd5['order']=qs[_0x8d95('0x38')](_0xd4ea46[_0x8d95('0x31')][_0x8d95('0x38')]);_0xb59cd5['where']=qs[_0x8d95('0x32')](_['pick'](_0xd4ea46['query'],_0x54b9b8['filters']));_0xb59cd5[_0x8d95('0x3b')][_0x8d95('0x59')]=_0x168f2e['id'];if(_0xd4ea46['query'][_0x8d95('0x3a')]){_0xb59cd5['where']=_[_0x8d95('0x3c')](_0xb59cd5[_0x8d95('0x3b')],{'$or':_['map'](_0xb59cd5['attributes'],function(_0x54e764){var _0x1b2aed={};_0x1b2aed[_0x54e764]={'$like':'%'+_0xd4ea46[_0x8d95('0x31')][_0x8d95('0x3a')]+'%'};return _0x1b2aed;})});}_0xb59cd5=_[_0x8d95('0x3c')]({},_0xb59cd5,_0xd4ea46[_0x8d95('0x3e')]);return db[_0x8d95('0x5d')]['count']({'where':_0xb59cd5[_0x8d95('0x3b')]})['then'](function(_0x4061fe){_0x19d45f[_0x8d95('0x1d')]=_0x4061fe;if(_0xd4ea46['query'][_0x8d95('0x40')]){_0xb59cd5[_0x8d95('0x41')]=[{'all':!![]}];}return db['JscriptyAnswerReport']['findAll'](_0xb59cd5);})['then'](function(_0x402ad4){_0x19d45f['rows']=_0x402ad4;return _0x19d45f;});}})[_0x8d95('0x23')](respondWithFilteredResult(_0x3695be,_0xb59cd5))[_0x8d95('0x46')](handleError(_0x3695be,null));};function char(_0x3d2767){return _0x8d95('0x5e')===typeof _0x3d2767?String[_0x8d95('0x5f')][_0x8d95('0x20')](null,arguments):_0x3d2767;}function needsEncapsulation(_0x1cbdff){return!!_0x1cbdff&&(_0x1cbdff[_0x8d95('0x60')]()[_0x8d95('0x61')](char(0xd))>=0x0||_0x1cbdff[_0x8d95('0x60')]()[_0x8d95('0x61')](char(0xa))>=0x0||_0x1cbdff[_0x8d95('0x60')]()[_0x8d95('0x61')](char(0x2c))>=0x0||_0x1cbdff[_0x8d95('0x60')]()[_0x8d95('0x61')](char(0x22))>=0x0);}function encapsulate(_0x87120e){var _0x599f73=char(0x22),_0x526932='\x5c'+char(0x22),_0x41d462=_0x87120e[_0x8d95('0x60')]()[_0x8d95('0x62')](new RegExp(_0x599f73,'g'),_0x526932);return _0x599f73+_0x41d462+_0x599f73;}exports[_0x8d95('0x63')]=function(_0x5d0841,_0x3b3f2c,_0x35cc08){var _0x185c5b,_0x528470;var _0x1a8aec={'where':{'ProjectId':_0x5d0841[_0x8d95('0x44')]['id']}};if(_0x5d0841[_0x8d95('0x31')][_0x8d95('0x64')]){_0x1a8aec['where'][_0x8d95('0x65')]=JSON[_0x8d95('0x66')](_0x5d0841[_0x8d95('0x31')][_0x8d95('0x64')]);}return db[_0x8d95('0x56')][_0x8d95('0x5a')](_0x1a8aec)[_0x8d95('0x23')](handleEntityNotFound(_0x3b3f2c,null))[_0x8d95('0x23')](function(_0x45903d){if(_0x45903d){_0x185c5b=_0x45903d;return db['JscriptyQuestionReport'][_0x8d95('0x5a')]({'where':{'SessionId':{'$in':_[_0x8d95('0x2b')](_0x185c5b,'id')},'ProjectId':_0x5d0841[_0x8d95('0x44')]['id']},'order':_0x8d95('0x67')});}})['then'](handleEntityNotFound(_0x3b3f2c,null))[_0x8d95('0x23')](function(_0x43dac8){if(_0x43dac8){_0x528470=_0x43dac8;var _0x565397={};for(var _0x19208c=0x0,_0x1fce09=_0x528470['length'];_0x19208c<_0x1fce09;_0x19208c++){if(!_0x565397[_0x8d95('0x57')](_0x528470[_0x19208c][_0x8d95('0x68')])){_0x565397[_0x528470[_0x19208c]['questionId']]=needsEncapsulation(_0x528470[_0x19208c][_0x8d95('0x69')])?encapsulate(_0x528470[_0x19208c][_0x8d95('0x69')]):_0x528470[_0x19208c][_0x8d95('0x69')];}}var _0x14f473=[],_0x4041c0={};for(var _0x5831f6=0x0,_0x10b14d=_0x185c5b['length'];_0x5831f6<_0x10b14d;_0x5831f6++){_0x4041c0={'ProjectId':_0x5d0841[_0x8d95('0x44')]['id'],'SessionId':_0x185c5b[_0x5831f6]['id'],'StartTime':moment(_0x185c5b[_0x5831f6][_0x8d95('0x65')])[_0x8d95('0x6a')](_0x8d95('0x6b'))};for(var _0x2a9d59=0x0,_0x4b67fd=_0x528470[_0x8d95('0x36')];_0x2a9d59<_0x4b67fd;_0x2a9d59++){if(_0x528470[_0x2a9d59][_0x8d95('0x6c')]==_0x185c5b[_0x5831f6]['id']&&_0x565397[_0x8d95('0x57')](_0x528470[_0x2a9d59][_0x8d95('0x68')])){_0x4041c0[_0x565397[_0x528470[_0x2a9d59][_0x8d95('0x68')]]]=_0x528470[_0x2a9d59]['answer'];}}for(var _0x285596 in _0x565397){if(!_0x4041c0['hasOwnProperty'](_0x565397[_0x285596])){_0x4041c0[_0x565397[_0x285596]]=null;}}_0x14f473['push'](_0x4041c0);}return _0x14f473;}})[_0x8d95('0x23')](function(_0x59c8b2){if(!_['isEmpty'](_0x59c8b2)){var _0x11fc75=toCsv(_0x59c8b2);var _0x1db5df=Date['now']();fs[_0x8d95('0x6d')](util[_0x8d95('0x6a')](_0x8d95('0x6e'),_0x5d0841[_0x8d95('0x44')]['id'],_0x1db5df),_0x11fc75);_0x3b3f2c[_0x8d95('0x6f')](_0x8d95('0x70'),'attachment;\x20filename='+util[_0x8d95('0x6a')](_0x8d95('0x71'),_0x5d0841['params']['id'],_0x1db5df));_0x3b3f2c[_0x8d95('0x6f')](_0x8d95('0x72'),_0x8d95('0x73'));return _0x3b3f2c[_0x8d95('0x74')](util[_0x8d95('0x6a')](_0x8d95('0x6e'),_0x5d0841[_0x8d95('0x44')]['id'],_0x1db5df));}else{return _0x3b3f2c[_0x8d95('0x17')](0xcc);}})[_0x8d95('0x46')](handleError(_0x3b3f2c,null));};
\ No newline at end of file
+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(_0x514b05,_0x2e44be){var _0x3be88c=function(_0x5185ba){while(--_0x5185ba){_0x514b05['push'](_0x514b05['shift']());}};_0x3be88c(++_0x2e44be);}(_0xceab,0x106));var _0xbcea=function(_0x363199,_0x59f967){_0x363199=_0x363199-0x0;var _0x1edbe8=_0xceab[_0x363199];return _0x1edbe8;};'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
git://repos.xcallymotion.com / motion2.git / blobdiff