// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xfe13=['push','isEmpty','writeFileSync','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','Content-type','text/csv','download','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','then','destroy','get','Projects','error','name','send','index','map','JscriptyProject','rawAttributes','type','key','model','query','filters','intersection','attributes','fields','hasOwnProperty','nolimit','sort','where','filter','merge','VIRTUAL','findAll','rows','catch','show','params','keys','length','include','options','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileResource','includeAll','omit','createdAt','updatedAt','UserProfileSection','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','getSessions','order','pick','ProjectId','JscriptySessionReport','getAnswers','JscriptyAnswerReport','fromCharCode','toString','indexOf','replace','getSummary','startTime','starttime','parse','JscriptyQuestionReport','-createdAt','questionId','question','format','YYYY-MM-DD\x20HH:mm:ss','SessionId','answer'];(function(_0x4b9db2,_0x17d409){var _0x1e4130=function(_0x59e820){while(--_0x59e820){_0x4b9db2['push'](_0x4b9db2['shift']());}};_0x1e4130(++_0x17d409);}(_0xfe13,0x178));var _0x3fe1=function(_0x15942a,_0x13b58c){_0x15942a=_0x15942a-0x0;var _0x36a9fb=_0xfe13[_0x15942a];return _0x36a9fb;};'use strict';var emlformat=require(_0x3fe1('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x3fe1('0x1'));var jsonpatch=require(_0x3fe1('0x2'));var rp=require(_0x3fe1('0x3'));var moment=require(_0x3fe1('0x4'));var BPromise=require(_0x3fe1('0x5'));var Mustache=require(_0x3fe1('0x6'));var util=require('util');var path=require('path');var sox=require(_0x3fe1('0x7'));var csv=require(_0x3fe1('0x8'));var ejs=require(_0x3fe1('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x3fe1('0xa'));var squel=require(_0x3fe1('0xb'));var crypto=require(_0x3fe1('0xc'));var jsforce=require(_0x3fe1('0xd'));var deskjs=require(_0x3fe1('0xe'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x3fe1('0xf'));var Redis=require(_0x3fe1('0x10'));var authService=require(_0x3fe1('0x11'));var qs=require(_0x3fe1('0x12'));var as=require(_0x3fe1('0x13'));var hardwareService=require(_0x3fe1('0x14'));var logger=require(_0x3fe1('0x15'))(_0x3fe1('0x16'));var utils=require('../../config/utils');var config=require(_0x3fe1('0x17'));var licenseUtil=require(_0x3fe1('0x18'));var db=require(_0x3fe1('0x19'))['db'];function respondWithStatusCode(_0x23da7f,_0x120411){_0x120411=_0x120411||0xcc;return function(_0xda23ad){if(_0xda23ad){return _0x23da7f[_0x3fe1('0x1a')](_0x120411);}return _0x23da7f[_0x3fe1('0x1b')](_0x120411)[_0x3fe1('0x1c')]();};}function respondWithResult(_0x59e62b,_0x753172){_0x753172=_0x753172||0xc8;return function(_0x138634){if(_0x138634){return _0x59e62b[_0x3fe1('0x1b')](_0x753172)[_0x3fe1('0x1d')](_0x138634);}};}function respondWithFilteredResult(_0xb4d7e3,_0x56e720){return function(_0x47055f){if(_0x47055f){var _0x358209=typeof _0x56e720[_0x3fe1('0x1e')]===_0x3fe1('0x1f')&&typeof _0x56e720[_0x3fe1('0x20')]===_0x3fe1('0x1f');var _0xd38a1=_0x47055f[_0x3fe1('0x21')];var _0xf28d3c=_0x358209?0x0:_0x56e720[_0x3fe1('0x1e')];var _0x5bb4b4=_0x358209?_0x47055f['count']:_0x56e720[_0x3fe1('0x1e')]+_0x56e720[_0x3fe1('0x20')];var _0x427a44;if(_0x5bb4b4>=_0xd38a1){_0x5bb4b4=_0xd38a1;_0x427a44=0xc8;}else{_0x427a44=0xce;}_0xb4d7e3[_0x3fe1('0x1b')](_0x427a44);return _0xb4d7e3[_0x3fe1('0x22')](_0x3fe1('0x23'),_0xf28d3c+'-'+_0x5bb4b4+'/'+_0xd38a1)[_0x3fe1('0x1d')](_0x47055f);}return null;};}function patchUpdates(_0x3b712b){return function(_0x1421f0){try{jsonpatch[_0x3fe1('0x24')](_0x1421f0,_0x3b712b,!![]);}catch(_0x784bb4){return BPromise[_0x3fe1('0x25')](_0x784bb4);}return _0x1421f0[_0x3fe1('0x26')]();};}function saveUpdates(_0x56bc7e,_0x1001c6){return function(_0x5d2c5f){if(_0x5d2c5f){return _0x5d2c5f['update'](_0x56bc7e)[_0x3fe1('0x27')](function(_0x5d9ca6){return _0x5d9ca6;});}return null;};}function removeEntity(_0x309b56,_0x2d7327){return function(_0xfcc335){if(_0xfcc335){return _0xfcc335[_0x3fe1('0x28')]()[_0x3fe1('0x27')](function(){var _0x2d5101=_0xfcc335[_0x3fe1('0x29')]({'plain':!![]});var _0x3420cb=_0x3fe1('0x2a');return db['UserProfileResource'][_0x3fe1('0x28')]({'where':{'type':_0x3420cb,'resourceId':_0x2d5101['id']}})['then'](function(){return _0xfcc335;});})['then'](function(){_0x309b56[_0x3fe1('0x1b')](0xcc)[_0x3fe1('0x1c')]();});}};}function handleEntityNotFound(_0x1bc94d,_0xdea762){return function(_0x160078){if(!_0x160078){_0x1bc94d[_0x3fe1('0x1a')](0x194);}return _0x160078;};}function handleError(_0x316456,_0x26767f){_0x26767f=_0x26767f||0x1f4;return function(_0x9832f2){logger[_0x3fe1('0x2b')](_0x9832f2['stack']);if(_0x9832f2[_0x3fe1('0x2c')]){delete _0x9832f2[_0x3fe1('0x2c')];}_0x316456[_0x3fe1('0x1b')](_0x26767f)[_0x3fe1('0x2d')](_0x9832f2);};}exports[_0x3fe1('0x2e')]=function(_0x8a6ddd,_0x444548){var _0x265040={},_0x105e56={},_0x1abd68={'count':0x0,'rows':[]};var _0x11f48b=_[_0x3fe1('0x2f')](db[_0x3fe1('0x30')][_0x3fe1('0x31')],function(_0x358c6b){return{'name':_0x358c6b['fieldName'],'type':_0x358c6b[_0x3fe1('0x32')][_0x3fe1('0x33')]};});_0x105e56[_0x3fe1('0x34')]=_[_0x3fe1('0x2f')](_0x11f48b,_0x3fe1('0x2c'));_0x105e56[_0x3fe1('0x35')]=_['keys'](_0x8a6ddd[_0x3fe1('0x35')]);_0x105e56[_0x3fe1('0x36')]=_[_0x3fe1('0x37')](_0x105e56[_0x3fe1('0x34')],_0x105e56[_0x3fe1('0x35')]);_0x265040[_0x3fe1('0x38')]=_[_0x3fe1('0x37')](_0x105e56['model'],qs[_0x3fe1('0x39')](_0x8a6ddd[_0x3fe1('0x35')][_0x3fe1('0x39')]));_0x265040[_0x3fe1('0x38')]=_0x265040['attributes']['length']?_0x265040[_0x3fe1('0x38')]:_0x105e56[_0x3fe1('0x34')];if(!_0x8a6ddd[_0x3fe1('0x35')][_0x3fe1('0x3a')](_0x3fe1('0x3b'))){_0x265040[_0x3fe1('0x20')]=qs[_0x3fe1('0x20')](_0x8a6ddd[_0x3fe1('0x35')][_0x3fe1('0x20')]);_0x265040[_0x3fe1('0x1e')]=qs['offset'](_0x8a6ddd[_0x3fe1('0x35')][_0x3fe1('0x1e')]);}_0x265040['order']=qs[_0x3fe1('0x3c')](_0x8a6ddd['query']['sort']);_0x265040[_0x3fe1('0x3d')]=qs['filters'](_['pick'](_0x8a6ddd[_0x3fe1('0x35')],_0x105e56[_0x3fe1('0x36')]),_0x11f48b);if(_0x8a6ddd[_0x3fe1('0x35')][_0x3fe1('0x3e')]){_0x265040[_0x3fe1('0x3d')]=_[_0x3fe1('0x3f')](_0x265040[_0x3fe1('0x3d')],{'$or':_['map'](_0x11f48b,function(_0x55c4cb){if(_0x55c4cb['type']!==_0x3fe1('0x40')){var _0xdb158b={};_0xdb158b[_0x55c4cb[_0x3fe1('0x2c')]]={'$like':'%'+_0x8a6ddd[_0x3fe1('0x35')]['filter']+'%'};return _0xdb158b;}})});}_0x265040=_[_0x3fe1('0x3f')]({},_0x265040,_0x8a6ddd['options']);var _0x4fedd1={'where':_0x265040[_0x3fe1('0x3d')]};return db[_0x3fe1('0x30')][_0x3fe1('0x21')](_0x4fedd1)[_0x3fe1('0x27')](function(_0x1bde8a){_0x1abd68[_0x3fe1('0x21')]=_0x1bde8a;if(_0x8a6ddd[_0x3fe1('0x35')]['includeAll']){_0x265040['include']=[{'all':!![]}];}return db[_0x3fe1('0x30')][_0x3fe1('0x41')](_0x265040);})[_0x3fe1('0x27')](function(_0x3bffd1){_0x1abd68[_0x3fe1('0x42')]=_0x3bffd1;return _0x1abd68;})['then'](respondWithFilteredResult(_0x444548,_0x265040))[_0x3fe1('0x43')](handleError(_0x444548,null));};exports[_0x3fe1('0x44')]=function(_0x4334c0,_0x197bcf){var _0x243615={'raw':![],'where':{'id':_0x4334c0[_0x3fe1('0x45')]['id']}},_0x4a0a44={};_0x4a0a44['model']=_['keys'](db['JscriptyProject'][_0x3fe1('0x31')]);_0x4a0a44[_0x3fe1('0x35')]=_[_0x3fe1('0x46')](_0x4334c0[_0x3fe1('0x35')]);_0x4a0a44[_0x3fe1('0x36')]=_[_0x3fe1('0x37')](_0x4a0a44[_0x3fe1('0x34')],_0x4a0a44[_0x3fe1('0x35')]);_0x243615[_0x3fe1('0x38')]=_['intersection'](_0x4a0a44[_0x3fe1('0x34')],qs[_0x3fe1('0x39')](_0x4334c0[_0x3fe1('0x35')][_0x3fe1('0x39')]));_0x243615[_0x3fe1('0x38')]=_0x243615[_0x3fe1('0x38')][_0x3fe1('0x47')]?_0x243615[_0x3fe1('0x38')]:_0x4a0a44['model'];if(_0x4334c0[_0x3fe1('0x35')]['includeAll']){_0x243615[_0x3fe1('0x48')]=[{'all':!![]}];}_0x243615=_[_0x3fe1('0x3f')]({},_0x243615,_0x4334c0[_0x3fe1('0x49')]);return db[_0x3fe1('0x30')][_0x3fe1('0x4a')](_0x243615)['then'](handleEntityNotFound(_0x197bcf,null))[_0x3fe1('0x27')](respondWithResult(_0x197bcf,null))[_0x3fe1('0x43')](handleError(_0x197bcf,null));};exports[_0x3fe1('0x4b')]=function(_0x47de28,_0x4189f5){return db[_0x3fe1('0x30')][_0x3fe1('0x4b')](_0x47de28[_0x3fe1('0x4c')],{})[_0x3fe1('0x27')](function(_0x4121e2){var _0x5a23c8=_0x47de28[_0x3fe1('0x4d')][_0x3fe1('0x29')]({'plain':!![]});if(!_0x5a23c8)throw new Error(_0x3fe1('0x4e'));if(_0x5a23c8[_0x3fe1('0x4f')]===_0x3fe1('0x4d')){var _0x26ef94=_0x4121e2[_0x3fe1('0x29')]({'plain':!![]});var _0x5f168c='Projects';return db['UserProfileSection'][_0x3fe1('0x4a')]({'where':{'name':_0x5f168c,'userProfileId':_0x5a23c8['userProfileId']},'raw':!![]})[_0x3fe1('0x27')](function(_0x378f2d){if(_0x378f2d&&_0x378f2d['autoAssociation']===0x0){return db[_0x3fe1('0x50')][_0x3fe1('0x4b')]({'name':_0x26ef94[_0x3fe1('0x2c')],'resourceId':_0x26ef94['id'],'type':_0x378f2d['name'],'sectionId':_0x378f2d['id']},{})['then'](function(){return _0x4121e2;});}else{return _0x4121e2;}})[_0x3fe1('0x43')](function(_0x5f13c3){logger[_0x3fe1('0x2b')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x5f13c3);throw _0x5f13c3;});}return _0x4121e2;})[_0x3fe1('0x27')](respondWithResult(_0x4189f5,0xc9))['catch'](handleError(_0x4189f5,null));};exports['clone']=function(_0x3a998d,_0x16f55a){var _0x38c316={'where':{'id':_0x3a998d[_0x3fe1('0x45')]['id']}},_0xbdc63f={};_0xbdc63f['model']=_[_0x3fe1('0x46')](db[_0x3fe1('0x30')]['rawAttributes']);_0x38c316[_0x3fe1('0x38')]=_[_0x3fe1('0x37')](_0xbdc63f[_0x3fe1('0x34')],qs['fields'](_0x3a998d[_0x3fe1('0x35')][_0x3fe1('0x39')]));_0x38c316[_0x3fe1('0x38')]=_0x38c316['attributes'][_0x3fe1('0x47')]?_0x38c316[_0x3fe1('0x38')]:_0xbdc63f[_0x3fe1('0x34')];if(_0x3a998d[_0x3fe1('0x35')][_0x3fe1('0x51')]){_0x38c316[_0x3fe1('0x48')]=[{'all':!![]}];}_0x38c316=_[_0x3fe1('0x3f')]({},_0x38c316,_0x3a998d[_0x3fe1('0x49')]);return db[_0x3fe1('0x30')][_0x3fe1('0x4a')](_0x38c316)[_0x3fe1('0x27')](handleEntityNotFound(_0x16f55a,null))[_0x3fe1('0x27')](function(_0x280b8f){if(_0x280b8f){var _0x55ab73=_0x280b8f['get']({'plain':!![]});_0x55ab73=qs[_0x3fe1('0x52')](_0x55ab73,['id',_0x3fe1('0x53'),_0x3fe1('0x54')]);_0x3a998d['body']=_[_0x3fe1('0x52')](_0x3a998d[_0x3fe1('0x4c')],['id',_0x3fe1('0x53'),_0x3fe1('0x54')]);return db['JscriptyProject'][_0x3fe1('0x4b')](_['merge'](_0x55ab73,_0x3a998d[_0x3fe1('0x4c')]),{'include':_0x3a998d[_0x3fe1('0x35')][_0x3fe1('0x51')]?[{'all':!![]}]:undefined})['then'](function(_0x2076d0){var _0x17a8d9=_0x3a998d[_0x3fe1('0x4d')][_0x3fe1('0x29')]({'plain':!![]});if(!_0x17a8d9)throw new Error(_0x3fe1('0x4e'));if(_0x17a8d9[_0x3fe1('0x4f')]===_0x3fe1('0x4d')){var _0x224d90=_0x2076d0['get']({'plain':!![]});var _0x308d2e=_0x3fe1('0x2a');return db[_0x3fe1('0x55')][_0x3fe1('0x4a')]({'where':{'name':_0x308d2e,'userProfileId':_0x17a8d9[_0x3fe1('0x56')]},'raw':!![]})[_0x3fe1('0x27')](function(_0x4da9ea){if(_0x4da9ea&&_0x4da9ea['autoAssociation']===0x0){return db['UserProfileResource']['create']({'name':_0x224d90[_0x3fe1('0x2c')],'resourceId':_0x224d90['id'],'type':_0x4da9ea['name'],'sectionId':_0x4da9ea['id']},{})[_0x3fe1('0x27')](function(){return _0x2076d0;});}else{return _0x2076d0;}})[_0x3fe1('0x43')](function(_0x52fa3e){logger['error'](_0x3fe1('0x57'),_0x52fa3e);throw _0x52fa3e;});}return _0x2076d0;});}})[_0x3fe1('0x27')](respondWithResult(_0x16f55a,0xc9))['catch'](handleError(_0x16f55a,null));};exports[_0x3fe1('0x58')]=function(_0x4bd3bf,_0x236cad){if(_0x4bd3bf[_0x3fe1('0x4c')]['id']){delete _0x4bd3bf['body']['id'];}return db['JscriptyProject'][_0x3fe1('0x4a')]({'where':{'id':_0x4bd3bf[_0x3fe1('0x45')]['id']}})[_0x3fe1('0x27')](handleEntityNotFound(_0x236cad,null))['then'](saveUpdates(_0x4bd3bf[_0x3fe1('0x4c')],null))[_0x3fe1('0x27')](respondWithResult(_0x236cad,null))[_0x3fe1('0x43')](handleError(_0x236cad,null));};exports[_0x3fe1('0x28')]=function(_0x29b747,_0x1ac190){return db[_0x3fe1('0x30')]['find']({'where':{'id':_0x29b747[_0x3fe1('0x45')]['id']}})['then'](handleEntityNotFound(_0x1ac190,null))[_0x3fe1('0x27')](removeEntity(_0x1ac190,null))[_0x3fe1('0x43')](handleError(_0x1ac190,null));};exports[_0x3fe1('0x59')]=function(_0x470a0f,_0x24e3bc,_0x21764f){var _0x28381b={'raw':!![],'where':{}};var _0x15ed28={};var _0x5a40dd={'count':0x0,'rows':[]};return db[_0x3fe1('0x30')]['findOne']({'where':{'id':_0x470a0f['params']['id']}})[_0x3fe1('0x27')](handleEntityNotFound(_0x24e3bc,null))[_0x3fe1('0x27')](function(_0x2deefa){if(_0x2deefa){_0x15ed28[_0x3fe1('0x34')]=_['keys'](db['JscriptySessionReport']['rawAttributes']);_0x15ed28[_0x3fe1('0x35')]=_[_0x3fe1('0x46')](_0x470a0f[_0x3fe1('0x35')]);_0x15ed28[_0x3fe1('0x36')]=_[_0x3fe1('0x37')](_0x15ed28[_0x3fe1('0x34')],_0x15ed28['query']);_0x28381b['attributes']=_[_0x3fe1('0x37')](_0x15ed28[_0x3fe1('0x34')],qs[_0x3fe1('0x39')](_0x470a0f[_0x3fe1('0x35')][_0x3fe1('0x39')]));_0x28381b['attributes']=_0x28381b[_0x3fe1('0x38')][_0x3fe1('0x47')]?_0x28381b[_0x3fe1('0x38')]:_0x15ed28[_0x3fe1('0x34')];if(!_0x470a0f['query'][_0x3fe1('0x3a')](_0x3fe1('0x3b'))){_0x28381b[_0x3fe1('0x20')]=qs[_0x3fe1('0x20')](_0x470a0f[_0x3fe1('0x35')][_0x3fe1('0x20')]);_0x28381b[_0x3fe1('0x1e')]=qs[_0x3fe1('0x1e')](_0x470a0f['query'][_0x3fe1('0x1e')]);}_0x28381b[_0x3fe1('0x5a')]=qs['sort'](_0x470a0f[_0x3fe1('0x35')][_0x3fe1('0x3c')]);_0x28381b[_0x3fe1('0x3d')]=qs[_0x3fe1('0x36')](_[_0x3fe1('0x5b')](_0x470a0f['query'],_0x15ed28[_0x3fe1('0x36')]));_0x28381b[_0x3fe1('0x3d')][_0x3fe1('0x5c')]=_0x2deefa['id'];if(_0x470a0f['query'][_0x3fe1('0x3e')]){_0x28381b[_0x3fe1('0x3d')]=_[_0x3fe1('0x3f')](_0x28381b['where'],{'$or':_[_0x3fe1('0x2f')](_0x28381b['attributes'],function(_0x4ad017){var _0x4f4944={};_0x4f4944[_0x4ad017]={'$like':'%'+_0x470a0f[_0x3fe1('0x35')][_0x3fe1('0x3e')]+'%'};return _0x4f4944;})});}_0x28381b=_['merge']({},_0x28381b,_0x470a0f['options']);return db[_0x3fe1('0x5d')]['count']({'where':_0x28381b[_0x3fe1('0x3d')]})['then'](function(_0x214a49){_0x5a40dd[_0x3fe1('0x21')]=_0x214a49;if(_0x470a0f[_0x3fe1('0x35')][_0x3fe1('0x51')]){_0x28381b[_0x3fe1('0x48')]=[{'all':!![]}];}return db[_0x3fe1('0x5d')]['findAll'](_0x28381b);})[_0x3fe1('0x27')](function(_0x10697e){_0x5a40dd[_0x3fe1('0x42')]=_0x10697e;return _0x5a40dd;});}})['then'](respondWithFilteredResult(_0x24e3bc,_0x28381b))[_0x3fe1('0x43')](handleError(_0x24e3bc,null));};exports[_0x3fe1('0x5e')]=function(_0x46b275,_0x4d2adc,_0x942912){var _0x8744fa={'raw':!![],'where':{}};var _0x271341={};var _0x18f1f8={'count':0x0,'rows':[]};return db['JscriptyProject']['findOne']({'where':{'id':_0x46b275[_0x3fe1('0x45')]['id']}})[_0x3fe1('0x27')](handleEntityNotFound(_0x4d2adc,null))[_0x3fe1('0x27')](function(_0x58fbfa){if(_0x58fbfa){_0x271341[_0x3fe1('0x34')]=_['keys'](db[_0x3fe1('0x5f')][_0x3fe1('0x31')]);_0x271341['query']=_[_0x3fe1('0x46')](_0x46b275[_0x3fe1('0x35')]);_0x271341[_0x3fe1('0x36')]=_[_0x3fe1('0x37')](_0x271341[_0x3fe1('0x34')],_0x271341[_0x3fe1('0x35')]);_0x8744fa[_0x3fe1('0x38')]=_[_0x3fe1('0x37')](_0x271341[_0x3fe1('0x34')],qs[_0x3fe1('0x39')](_0x46b275['query']['fields']));_0x8744fa['attributes']=_0x8744fa[_0x3fe1('0x38')][_0x3fe1('0x47')]?_0x8744fa[_0x3fe1('0x38')]:_0x271341[_0x3fe1('0x34')];if(!_0x46b275[_0x3fe1('0x35')][_0x3fe1('0x3a')](_0x3fe1('0x3b'))){_0x8744fa[_0x3fe1('0x20')]=qs['limit'](_0x46b275[_0x3fe1('0x35')][_0x3fe1('0x20')]);_0x8744fa[_0x3fe1('0x1e')]=qs['offset'](_0x46b275[_0x3fe1('0x35')][_0x3fe1('0x1e')]);}_0x8744fa['order']=qs[_0x3fe1('0x3c')](_0x46b275[_0x3fe1('0x35')]['sort']);_0x8744fa[_0x3fe1('0x3d')]=qs[_0x3fe1('0x36')](_[_0x3fe1('0x5b')](_0x46b275[_0x3fe1('0x35')],_0x271341[_0x3fe1('0x36')]));_0x8744fa['where']['ProjectId']=_0x58fbfa['id'];if(_0x46b275['query'][_0x3fe1('0x3e')]){_0x8744fa['where']=_[_0x3fe1('0x3f')](_0x8744fa[_0x3fe1('0x3d')],{'$or':_[_0x3fe1('0x2f')](_0x8744fa[_0x3fe1('0x38')],function(_0x586e9a){var _0x469d90={};_0x469d90[_0x586e9a]={'$like':'%'+_0x46b275['query'][_0x3fe1('0x3e')]+'%'};return _0x469d90;})});}_0x8744fa=_['merge']({},_0x8744fa,_0x46b275[_0x3fe1('0x49')]);return db[_0x3fe1('0x5f')][_0x3fe1('0x21')]({'where':_0x8744fa[_0x3fe1('0x3d')]})[_0x3fe1('0x27')](function(_0x5478c5){_0x18f1f8['count']=_0x5478c5;if(_0x46b275[_0x3fe1('0x35')][_0x3fe1('0x51')]){_0x8744fa[_0x3fe1('0x48')]=[{'all':!![]}];}return db[_0x3fe1('0x5f')][_0x3fe1('0x41')](_0x8744fa);})[_0x3fe1('0x27')](function(_0x4a6291){_0x18f1f8[_0x3fe1('0x42')]=_0x4a6291;return _0x18f1f8;});}})[_0x3fe1('0x27')](respondWithFilteredResult(_0x4d2adc,_0x8744fa))['catch'](handleError(_0x4d2adc,null));};function char(_0x3ee720){return'number'===typeof _0x3ee720?String[_0x3fe1('0x60')][_0x3fe1('0x24')](null,arguments):_0x3ee720;}function needsEncapsulation(_0x295141){return!!_0x295141&&(_0x295141[_0x3fe1('0x61')]()[_0x3fe1('0x62')](char(0xd))>=0x0||_0x295141['toString']()[_0x3fe1('0x62')](char(0xa))>=0x0||_0x295141[_0x3fe1('0x61')]()[_0x3fe1('0x62')](char(0x2c))>=0x0||_0x295141[_0x3fe1('0x61')]()[_0x3fe1('0x62')](char(0x22))>=0x0);}function encapsulate(_0xe1375f){var _0x2bc3a7=char(0x22),_0x4d8c5d='\x5c'+char(0x22),_0x2f7beb=_0xe1375f[_0x3fe1('0x61')]()[_0x3fe1('0x63')](new RegExp(_0x2bc3a7,'g'),_0x4d8c5d);return _0x2bc3a7+_0x2f7beb+_0x2bc3a7;}exports[_0x3fe1('0x64')]=function(_0x429a0a,_0x5331d5,_0x289245){var _0x2cb38e,_0x212af7;var _0x367a6a={'where':{'ProjectId':_0x429a0a[_0x3fe1('0x45')]['id']}};if(_0x429a0a[_0x3fe1('0x35')][_0x3fe1('0x65')]){_0x367a6a[_0x3fe1('0x3d')][_0x3fe1('0x66')]=JSON[_0x3fe1('0x67')](_0x429a0a[_0x3fe1('0x35')]['startTime']);}return db[_0x3fe1('0x5d')][_0x3fe1('0x41')](_0x367a6a)[_0x3fe1('0x27')](handleEntityNotFound(_0x5331d5,null))[_0x3fe1('0x27')](function(_0x578317){if(_0x578317){_0x2cb38e=_0x578317;return db[_0x3fe1('0x68')][_0x3fe1('0x41')]({'where':{'SessionId':{'$in':_[_0x3fe1('0x2f')](_0x2cb38e,'id')},'ProjectId':_0x429a0a['params']['id']},'order':_0x3fe1('0x69')});}})[_0x3fe1('0x27')](handleEntityNotFound(_0x5331d5,null))[_0x3fe1('0x27')](function(_0x11b0c7){if(_0x11b0c7){_0x212af7=_0x11b0c7;var _0x3e89a7={};for(var _0x3b5a5c=0x0,_0x459f0b=_0x212af7['length'];_0x3b5a5c<_0x459f0b;_0x3b5a5c++){if(!_0x3e89a7['hasOwnProperty'](_0x212af7[_0x3b5a5c]['questionId'])){_0x3e89a7[_0x212af7[_0x3b5a5c][_0x3fe1('0x6a')]]=needsEncapsulation(_0x212af7[_0x3b5a5c]['question'])?encapsulate(_0x212af7[_0x3b5a5c][_0x3fe1('0x6b')]):_0x212af7[_0x3b5a5c][_0x3fe1('0x6b')];}}var _0x32506b=[],_0x27dd11={};for(var _0x556121=0x0,_0x4d8274=_0x2cb38e[_0x3fe1('0x47')];_0x556121<_0x4d8274;_0x556121++){_0x27dd11={'ProjectId':_0x429a0a['params']['id'],'SessionId':_0x2cb38e[_0x556121]['id'],'StartTime':moment(_0x2cb38e[_0x556121][_0x3fe1('0x66')])[_0x3fe1('0x6c')](_0x3fe1('0x6d'))};for(var _0x5bde6f=0x0,_0x43e4dd=_0x212af7['length'];_0x5bde6f<_0x43e4dd;_0x5bde6f++){if(_0x212af7[_0x5bde6f][_0x3fe1('0x6e')]==_0x2cb38e[_0x556121]['id']&&_0x3e89a7[_0x3fe1('0x3a')](_0x212af7[_0x5bde6f]['questionId'])){_0x27dd11[_0x3e89a7[_0x212af7[_0x5bde6f][_0x3fe1('0x6a')]]]=_0x212af7[_0x5bde6f][_0x3fe1('0x6f')];}}for(var _0x1897b9 in _0x3e89a7){if(!_0x27dd11[_0x3fe1('0x3a')](_0x3e89a7[_0x1897b9])){_0x27dd11[_0x3e89a7[_0x1897b9]]=null;}}_0x32506b[_0x3fe1('0x70')](_0x27dd11);}return _0x32506b;}})[_0x3fe1('0x27')](function(_0x590ffc){if(!_[_0x3fe1('0x71')](_0x590ffc)){var _0x24c8a3=toCsv(_0x590ffc);var _0x57b814=Date['now']();fs[_0x3fe1('0x72')](util[_0x3fe1('0x6c')](_0x3fe1('0x73'),_0x429a0a[_0x3fe1('0x45')]['id'],_0x57b814),_0x24c8a3);_0x5331d5[_0x3fe1('0x74')]('Content-disposition',_0x3fe1('0x75')+util[_0x3fe1('0x6c')](_0x3fe1('0x76'),_0x429a0a['params']['id'],_0x57b814));_0x5331d5[_0x3fe1('0x74')](_0x3fe1('0x77'),_0x3fe1('0x78'));return _0x5331d5[_0x3fe1('0x79')](util[_0x3fe1('0x6c')]('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x429a0a[_0x3fe1('0x45')]['id'],_0x57b814));}else{return _0x5331d5['sendStatus'](0xcc);}})['catch'](handleError(_0x5331d5,null));};
\ No newline at end of file
+var _0x1681=['error','name','send','JscriptyProject','rawAttributes','fieldName','type','key','model','map','query','keys','filters','attributes','intersection','fields','length','hasOwnProperty','order','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','show','catch','create','body','user','role','UserProfileSection','find','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','omit','updatedAt','UserProfileResource','JscriptySessionReport','ProjectId','getAnswers','findOne','JscriptyAnswerReport','nolimit','toString','indexOf','getSummary','startTime','starttime','parse','JscriptyQuestionReport','-createdAt','questionId','question','SessionId','answer','push','isEmpty','now','format','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','Content-disposition','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','Content-type','download','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','sox','to-csv','fs-extra','lodash','crypto','desk.js','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','limit','undefined','count','set','Content-Range','apply','reject','save','update','then','destroy','get','Projects'];(function(_0x119d5a,_0x19b457){var _0x15bff4=function(_0x1b7c78){while(--_0x1b7c78){_0x119d5a['push'](_0x119d5a['shift']());}};_0x15bff4(++_0x19b457);}(_0x1681,0x12c));var _0x1168=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0x1681[_0x3dd15e];return _0x231fd0;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require(_0x1168('0x0'));var jsonpatch=require(_0x1168('0x1'));var rp=require(_0x1168('0x2'));var moment=require(_0x1168('0x3'));var BPromise=require(_0x1168('0x4'));var Mustache=require(_0x1168('0x5'));var util=require('util');var path=require('path');var sox=require(_0x1168('0x6'));var csv=require(_0x1168('0x7'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x1168('0x8'));var _=require(_0x1168('0x9'));var squel=require('squel');var crypto=require(_0x1168('0xa'));var jsforce=require('jsforce');var deskjs=require(_0x1168('0xb'));var toCsv=require(_0x1168('0x7'));var querystring=require('querystring');var Papa=require(_0x1168('0xc'));var Redis=require(_0x1168('0xd'));var authService=require('../../components/auth/service');var qs=require(_0x1168('0xe'));var as=require(_0x1168('0xf'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0x1168('0x10'));var utils=require(_0x1168('0x11'));var config=require(_0x1168('0x12'));var licenseUtil=require(_0x1168('0x13'));var db=require(_0x1168('0x14'))['db'];function respondWithStatusCode(_0x50638d,_0x4123a5){_0x4123a5=_0x4123a5||0xcc;return function(_0xbe4880){if(_0xbe4880){return _0x50638d[_0x1168('0x15')](_0x4123a5);}return _0x50638d[_0x1168('0x16')](_0x4123a5)[_0x1168('0x17')]();};}function respondWithResult(_0x4fdd1c,_0x459dcc){_0x459dcc=_0x459dcc||0xc8;return function(_0x52b1f7){if(_0x52b1f7){return _0x4fdd1c[_0x1168('0x16')](_0x459dcc)[_0x1168('0x18')](_0x52b1f7);}};}function respondWithFilteredResult(_0x52c8a0,_0x3f1840){return function(_0x41205b){if(_0x41205b){var _0x5a1b64=typeof _0x3f1840[_0x1168('0x19')]==='undefined'&&typeof _0x3f1840[_0x1168('0x1a')]===_0x1168('0x1b');var _0x5e6483=_0x41205b[_0x1168('0x1c')];var _0x36130f=_0x5a1b64?0x0:_0x3f1840[_0x1168('0x19')];var _0x5d8498=_0x5a1b64?_0x41205b['count']:_0x3f1840[_0x1168('0x19')]+_0x3f1840['limit'];var _0x2bea0e;if(_0x5d8498>=_0x5e6483){_0x5d8498=_0x5e6483;_0x2bea0e=0xc8;}else{_0x2bea0e=0xce;}_0x52c8a0[_0x1168('0x16')](_0x2bea0e);return _0x52c8a0[_0x1168('0x1d')](_0x1168('0x1e'),_0x36130f+'-'+_0x5d8498+'/'+_0x5e6483)[_0x1168('0x18')](_0x41205b);}return null;};}function patchUpdates(_0x416c29){return function(_0x527acd){try{jsonpatch[_0x1168('0x1f')](_0x527acd,_0x416c29,!![]);}catch(_0x58606f){return BPromise[_0x1168('0x20')](_0x58606f);}return _0x527acd[_0x1168('0x21')]();};}function saveUpdates(_0x5f4afb,_0x4a3e55){return function(_0x1252c2){if(_0x1252c2){return _0x1252c2[_0x1168('0x22')](_0x5f4afb)[_0x1168('0x23')](function(_0x46bda4){return _0x46bda4;});}return null;};}function removeEntity(_0xc9e17f,_0x305d39){return function(_0x149967){if(_0x149967){return _0x149967[_0x1168('0x24')]()[_0x1168('0x23')](function(){var _0x270eec=_0x149967[_0x1168('0x25')]({'plain':!![]});var _0x4177ec=_0x1168('0x26');return db['UserProfileResource'][_0x1168('0x24')]({'where':{'type':_0x4177ec,'resourceId':_0x270eec['id']}})[_0x1168('0x23')](function(){return _0x149967;});})['then'](function(){_0xc9e17f[_0x1168('0x16')](0xcc)[_0x1168('0x17')]();});}};}function handleEntityNotFound(_0x3666d0,_0x54e17d){return function(_0x2ec395){if(!_0x2ec395){_0x3666d0[_0x1168('0x15')](0x194);}return _0x2ec395;};}function handleError(_0x763d9c,_0x272d47){_0x272d47=_0x272d47||0x1f4;return function(_0x53ea92){logger[_0x1168('0x27')](_0x53ea92['stack']);if(_0x53ea92[_0x1168('0x28')]){delete _0x53ea92[_0x1168('0x28')];}_0x763d9c[_0x1168('0x16')](_0x272d47)[_0x1168('0x29')](_0x53ea92);};}exports['index']=function(_0xd925da,_0x5032ed){var _0x4c1ba9={},_0x26ccc9={},_0x3100c2={'count':0x0,'rows':[]};var _0x2fdf71=_['map'](db[_0x1168('0x2a')][_0x1168('0x2b')],function(_0x560519){return{'name':_0x560519[_0x1168('0x2c')],'type':_0x560519[_0x1168('0x2d')][_0x1168('0x2e')]};});_0x26ccc9[_0x1168('0x2f')]=_[_0x1168('0x30')](_0x2fdf71,_0x1168('0x28'));_0x26ccc9[_0x1168('0x31')]=_[_0x1168('0x32')](_0xd925da['query']);_0x26ccc9[_0x1168('0x33')]=_['intersection'](_0x26ccc9[_0x1168('0x2f')],_0x26ccc9['query']);_0x4c1ba9[_0x1168('0x34')]=_[_0x1168('0x35')](_0x26ccc9[_0x1168('0x2f')],qs['fields'](_0xd925da[_0x1168('0x31')][_0x1168('0x36')]));_0x4c1ba9[_0x1168('0x34')]=_0x4c1ba9[_0x1168('0x34')][_0x1168('0x37')]?_0x4c1ba9['attributes']:_0x26ccc9[_0x1168('0x2f')];if(!_0xd925da[_0x1168('0x31')][_0x1168('0x38')]('nolimit')){_0x4c1ba9[_0x1168('0x1a')]=qs['limit'](_0xd925da['query'][_0x1168('0x1a')]);_0x4c1ba9[_0x1168('0x19')]=qs['offset'](_0xd925da[_0x1168('0x31')][_0x1168('0x19')]);}_0x4c1ba9[_0x1168('0x39')]=qs[_0x1168('0x3a')](_0xd925da[_0x1168('0x31')][_0x1168('0x3a')]);_0x4c1ba9[_0x1168('0x3b')]=qs['filters'](_[_0x1168('0x3c')](_0xd925da['query'],_0x26ccc9[_0x1168('0x33')]),_0x2fdf71);if(_0xd925da[_0x1168('0x31')][_0x1168('0x3d')]){_0x4c1ba9[_0x1168('0x3b')]=_[_0x1168('0x3e')](_0x4c1ba9[_0x1168('0x3b')],{'$or':_['map'](_0x2fdf71,function(_0x3242fe){if(_0x3242fe[_0x1168('0x2d')]!==_0x1168('0x3f')){var _0x4e339e={};_0x4e339e[_0x3242fe[_0x1168('0x28')]]={'$like':'%'+_0xd925da[_0x1168('0x31')][_0x1168('0x3d')]+'%'};return _0x4e339e;}})});}_0x4c1ba9=_['merge']({},_0x4c1ba9,_0xd925da[_0x1168('0x40')]);var _0x5615b2={'where':_0x4c1ba9[_0x1168('0x3b')]};return db[_0x1168('0x2a')][_0x1168('0x1c')](_0x5615b2)[_0x1168('0x23')](function(_0x1779a6){_0x3100c2[_0x1168('0x1c')]=_0x1779a6;if(_0xd925da[_0x1168('0x31')][_0x1168('0x41')]){_0x4c1ba9[_0x1168('0x42')]=[{'all':!![]}];}return db['JscriptyProject'][_0x1168('0x43')](_0x4c1ba9);})[_0x1168('0x23')](function(_0x491294){_0x3100c2[_0x1168('0x44')]=_0x491294;return _0x3100c2;})[_0x1168('0x23')](respondWithFilteredResult(_0x5032ed,_0x4c1ba9))['catch'](handleError(_0x5032ed,null));};exports[_0x1168('0x45')]=function(_0x40d263,_0x1a9d20){var _0x7ba8cc={'raw':![],'where':{'id':_0x40d263['params']['id']}},_0x5a7220={};_0x5a7220['model']=_[_0x1168('0x32')](db[_0x1168('0x2a')][_0x1168('0x2b')]);_0x5a7220[_0x1168('0x31')]=_[_0x1168('0x32')](_0x40d263[_0x1168('0x31')]);_0x5a7220[_0x1168('0x33')]=_[_0x1168('0x35')](_0x5a7220[_0x1168('0x2f')],_0x5a7220[_0x1168('0x31')]);_0x7ba8cc[_0x1168('0x34')]=_[_0x1168('0x35')](_0x5a7220[_0x1168('0x2f')],qs['fields'](_0x40d263['query']['fields']));_0x7ba8cc[_0x1168('0x34')]=_0x7ba8cc[_0x1168('0x34')][_0x1168('0x37')]?_0x7ba8cc[_0x1168('0x34')]:_0x5a7220[_0x1168('0x2f')];if(_0x40d263[_0x1168('0x31')][_0x1168('0x41')]){_0x7ba8cc[_0x1168('0x42')]=[{'all':!![]}];}_0x7ba8cc=_[_0x1168('0x3e')]({},_0x7ba8cc,_0x40d263[_0x1168('0x40')]);return db['JscriptyProject']['find'](_0x7ba8cc)['then'](handleEntityNotFound(_0x1a9d20,null))[_0x1168('0x23')](respondWithResult(_0x1a9d20,null))[_0x1168('0x46')](handleError(_0x1a9d20,null));};exports[_0x1168('0x47')]=function(_0x51b141,_0x106c2a){return db[_0x1168('0x2a')][_0x1168('0x47')](_0x51b141[_0x1168('0x48')],{})[_0x1168('0x23')](function(_0x1e8b16){var _0x121a37=_0x51b141[_0x1168('0x49')][_0x1168('0x25')]({'plain':!![]});if(!_0x121a37)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x121a37[_0x1168('0x4a')]===_0x1168('0x49')){var _0x1135f1=_0x1e8b16[_0x1168('0x25')]({'plain':!![]});var _0x3e3843='Projects';return db[_0x1168('0x4b')][_0x1168('0x4c')]({'where':{'name':_0x3e3843,'userProfileId':_0x121a37[_0x1168('0x4d')]},'raw':!![]})[_0x1168('0x23')](function(_0x2ddcdf){if(_0x2ddcdf&&_0x2ddcdf[_0x1168('0x4e')]===0x0){return db['UserProfileResource'][_0x1168('0x47')]({'name':_0x1135f1['name'],'resourceId':_0x1135f1['id'],'type':_0x2ddcdf[_0x1168('0x28')],'sectionId':_0x2ddcdf['id']},{})['then'](function(){return _0x1e8b16;});}else{return _0x1e8b16;}})[_0x1168('0x46')](function(_0x211ae0){logger[_0x1168('0x27')](_0x1168('0x4f'),_0x211ae0);throw _0x211ae0;});}return _0x1e8b16;})[_0x1168('0x23')](respondWithResult(_0x106c2a,0xc9))[_0x1168('0x46')](handleError(_0x106c2a,null));};exports['clone']=function(_0x31d5fd,_0x43df83){var _0x5c24fa={'where':{'id':_0x31d5fd[_0x1168('0x50')]['id']}},_0x1d1434={};_0x1d1434[_0x1168('0x2f')]=_[_0x1168('0x32')](db['JscriptyProject']['rawAttributes']);_0x5c24fa[_0x1168('0x34')]=_[_0x1168('0x35')](_0x1d1434[_0x1168('0x2f')],qs[_0x1168('0x36')](_0x31d5fd[_0x1168('0x31')][_0x1168('0x36')]));_0x5c24fa['attributes']=_0x5c24fa[_0x1168('0x34')][_0x1168('0x37')]?_0x5c24fa[_0x1168('0x34')]:_0x1d1434[_0x1168('0x2f')];if(_0x31d5fd[_0x1168('0x31')]['includeAll']){_0x5c24fa[_0x1168('0x42')]=[{'all':!![]}];}_0x5c24fa=_['merge']({},_0x5c24fa,_0x31d5fd[_0x1168('0x40')]);return db[_0x1168('0x2a')]['find'](_0x5c24fa)[_0x1168('0x23')](handleEntityNotFound(_0x43df83,null))['then'](function(_0x13a2e1){if(_0x13a2e1){var _0x3db90a=_0x13a2e1[_0x1168('0x25')]({'plain':!![]});_0x3db90a=qs[_0x1168('0x51')](_0x3db90a,['id','createdAt','updatedAt']);_0x31d5fd[_0x1168('0x48')]=_[_0x1168('0x51')](_0x31d5fd[_0x1168('0x48')],['id','createdAt',_0x1168('0x52')]);return db[_0x1168('0x2a')][_0x1168('0x47')](_[_0x1168('0x3e')](_0x3db90a,_0x31d5fd[_0x1168('0x48')]),{'include':_0x31d5fd[_0x1168('0x31')]['includeAll']?[{'all':!![]}]:undefined})[_0x1168('0x23')](function(_0x4bcb76){var _0x175663=_0x31d5fd[_0x1168('0x49')][_0x1168('0x25')]({'plain':!![]});if(!_0x175663)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x175663[_0x1168('0x4a')]===_0x1168('0x49')){var _0x2cc0f0=_0x4bcb76[_0x1168('0x25')]({'plain':!![]});var _0x139c36='Projects';return db[_0x1168('0x4b')][_0x1168('0x4c')]({'where':{'name':_0x139c36,'userProfileId':_0x175663[_0x1168('0x4d')]},'raw':!![]})[_0x1168('0x23')](function(_0xe54d02){if(_0xe54d02&&_0xe54d02[_0x1168('0x4e')]===0x0){return db[_0x1168('0x53')][_0x1168('0x47')]({'name':_0x2cc0f0[_0x1168('0x28')],'resourceId':_0x2cc0f0['id'],'type':_0xe54d02[_0x1168('0x28')],'sectionId':_0xe54d02['id']},{})['then'](function(){return _0x4bcb76;});}else{return _0x4bcb76;}})[_0x1168('0x46')](function(_0x10f0ab){logger[_0x1168('0x27')](_0x1168('0x4f'),_0x10f0ab);throw _0x10f0ab;});}return _0x4bcb76;});}})[_0x1168('0x23')](respondWithResult(_0x43df83,0xc9))[_0x1168('0x46')](handleError(_0x43df83,null));};exports[_0x1168('0x22')]=function(_0x281e33,_0x3c0ed4){if(_0x281e33['body']['id']){delete _0x281e33[_0x1168('0x48')]['id'];}return db[_0x1168('0x2a')][_0x1168('0x4c')]({'where':{'id':_0x281e33[_0x1168('0x50')]['id']}})['then'](handleEntityNotFound(_0x3c0ed4,null))[_0x1168('0x23')](saveUpdates(_0x281e33[_0x1168('0x48')],null))[_0x1168('0x23')](respondWithResult(_0x3c0ed4,null))[_0x1168('0x46')](handleError(_0x3c0ed4,null));};exports['destroy']=function(_0x46941c,_0x2e6654){return db[_0x1168('0x2a')]['find']({'where':{'id':_0x46941c[_0x1168('0x50')]['id']}})[_0x1168('0x23')](handleEntityNotFound(_0x2e6654,null))['then'](removeEntity(_0x2e6654,null))[_0x1168('0x46')](handleError(_0x2e6654,null));};exports['getSessions']=function(_0x429d87,_0x14537d,_0x17356f){var _0x1382ce={'raw':!![],'where':{}};var _0x4ded4f={};var _0x47a279={'count':0x0,'rows':[]};return db['JscriptyProject']['findOne']({'where':{'id':_0x429d87['params']['id']}})['then'](handleEntityNotFound(_0x14537d,null))[_0x1168('0x23')](function(_0x110ff6){if(_0x110ff6){_0x4ded4f[_0x1168('0x2f')]=_[_0x1168('0x32')](db[_0x1168('0x54')]['rawAttributes']);_0x4ded4f[_0x1168('0x31')]=_['keys'](_0x429d87[_0x1168('0x31')]);_0x4ded4f[_0x1168('0x33')]=_[_0x1168('0x35')](_0x4ded4f[_0x1168('0x2f')],_0x4ded4f['query']);_0x1382ce['attributes']=_[_0x1168('0x35')](_0x4ded4f[_0x1168('0x2f')],qs[_0x1168('0x36')](_0x429d87[_0x1168('0x31')][_0x1168('0x36')]));_0x1382ce['attributes']=_0x1382ce[_0x1168('0x34')][_0x1168('0x37')]?_0x1382ce['attributes']:_0x4ded4f[_0x1168('0x2f')];if(!_0x429d87[_0x1168('0x31')][_0x1168('0x38')]('nolimit')){_0x1382ce['limit']=qs['limit'](_0x429d87[_0x1168('0x31')][_0x1168('0x1a')]);_0x1382ce[_0x1168('0x19')]=qs[_0x1168('0x19')](_0x429d87[_0x1168('0x31')][_0x1168('0x19')]);}_0x1382ce[_0x1168('0x39')]=qs[_0x1168('0x3a')](_0x429d87['query'][_0x1168('0x3a')]);_0x1382ce[_0x1168('0x3b')]=qs[_0x1168('0x33')](_[_0x1168('0x3c')](_0x429d87[_0x1168('0x31')],_0x4ded4f[_0x1168('0x33')]));_0x1382ce[_0x1168('0x3b')][_0x1168('0x55')]=_0x110ff6['id'];if(_0x429d87[_0x1168('0x31')][_0x1168('0x3d')]){_0x1382ce[_0x1168('0x3b')]=_[_0x1168('0x3e')](_0x1382ce[_0x1168('0x3b')],{'$or':_[_0x1168('0x30')](_0x1382ce[_0x1168('0x34')],function(_0x51b727){var _0x396fe5={};_0x396fe5[_0x51b727]={'$like':'%'+_0x429d87[_0x1168('0x31')][_0x1168('0x3d')]+'%'};return _0x396fe5;})});}_0x1382ce=_[_0x1168('0x3e')]({},_0x1382ce,_0x429d87['options']);return db[_0x1168('0x54')][_0x1168('0x1c')]({'where':_0x1382ce['where']})[_0x1168('0x23')](function(_0x11fb79){_0x47a279['count']=_0x11fb79;if(_0x429d87[_0x1168('0x31')][_0x1168('0x41')]){_0x1382ce['include']=[{'all':!![]}];}return db['JscriptySessionReport'][_0x1168('0x43')](_0x1382ce);})[_0x1168('0x23')](function(_0x39d9a1){_0x47a279[_0x1168('0x44')]=_0x39d9a1;return _0x47a279;});}})[_0x1168('0x23')](respondWithFilteredResult(_0x14537d,_0x1382ce))[_0x1168('0x46')](handleError(_0x14537d,null));};exports[_0x1168('0x56')]=function(_0x39f3f6,_0x38fb76,_0x4cd3e4){var _0x2a0355={'raw':!![],'where':{}};var _0x568c41={};var _0x117ee2={'count':0x0,'rows':[]};return db['JscriptyProject'][_0x1168('0x57')]({'where':{'id':_0x39f3f6['params']['id']}})[_0x1168('0x23')](handleEntityNotFound(_0x38fb76,null))[_0x1168('0x23')](function(_0x116849){if(_0x116849){_0x568c41[_0x1168('0x2f')]=_[_0x1168('0x32')](db[_0x1168('0x58')][_0x1168('0x2b')]);_0x568c41[_0x1168('0x31')]=_[_0x1168('0x32')](_0x39f3f6[_0x1168('0x31')]);_0x568c41[_0x1168('0x33')]=_['intersection'](_0x568c41[_0x1168('0x2f')],_0x568c41[_0x1168('0x31')]);_0x2a0355[_0x1168('0x34')]=_[_0x1168('0x35')](_0x568c41[_0x1168('0x2f')],qs[_0x1168('0x36')](_0x39f3f6[_0x1168('0x31')][_0x1168('0x36')]));_0x2a0355[_0x1168('0x34')]=_0x2a0355[_0x1168('0x34')][_0x1168('0x37')]?_0x2a0355['attributes']:_0x568c41[_0x1168('0x2f')];if(!_0x39f3f6[_0x1168('0x31')][_0x1168('0x38')](_0x1168('0x59'))){_0x2a0355[_0x1168('0x1a')]=qs[_0x1168('0x1a')](_0x39f3f6['query'][_0x1168('0x1a')]);_0x2a0355[_0x1168('0x19')]=qs[_0x1168('0x19')](_0x39f3f6[_0x1168('0x31')][_0x1168('0x19')]);}_0x2a0355[_0x1168('0x39')]=qs[_0x1168('0x3a')](_0x39f3f6['query'][_0x1168('0x3a')]);_0x2a0355[_0x1168('0x3b')]=qs['filters'](_[_0x1168('0x3c')](_0x39f3f6['query'],_0x568c41[_0x1168('0x33')]));_0x2a0355[_0x1168('0x3b')][_0x1168('0x55')]=_0x116849['id'];if(_0x39f3f6['query'][_0x1168('0x3d')]){_0x2a0355[_0x1168('0x3b')]=_[_0x1168('0x3e')](_0x2a0355[_0x1168('0x3b')],{'$or':_[_0x1168('0x30')](_0x2a0355[_0x1168('0x34')],function(_0xd759f3){var _0x27482e={};_0x27482e[_0xd759f3]={'$like':'%'+_0x39f3f6[_0x1168('0x31')]['filter']+'%'};return _0x27482e;})});}_0x2a0355=_[_0x1168('0x3e')]({},_0x2a0355,_0x39f3f6[_0x1168('0x40')]);return db[_0x1168('0x58')][_0x1168('0x1c')]({'where':_0x2a0355['where']})[_0x1168('0x23')](function(_0x3e6d88){_0x117ee2[_0x1168('0x1c')]=_0x3e6d88;if(_0x39f3f6[_0x1168('0x31')][_0x1168('0x41')]){_0x2a0355[_0x1168('0x42')]=[{'all':!![]}];}return db[_0x1168('0x58')]['findAll'](_0x2a0355);})[_0x1168('0x23')](function(_0x1fafe2){_0x117ee2[_0x1168('0x44')]=_0x1fafe2;return _0x117ee2;});}})[_0x1168('0x23')](respondWithFilteredResult(_0x38fb76,_0x2a0355))[_0x1168('0x46')](handleError(_0x38fb76,null));};function char(_0x259e3f){return'number'===typeof _0x259e3f?String['fromCharCode'][_0x1168('0x1f')](null,arguments):_0x259e3f;}function needsEncapsulation(_0x2325f6){return!!_0x2325f6&&(_0x2325f6[_0x1168('0x5a')]()[_0x1168('0x5b')](char(0xd))>=0x0||_0x2325f6[_0x1168('0x5a')]()['indexOf'](char(0xa))>=0x0||_0x2325f6[_0x1168('0x5a')]()[_0x1168('0x5b')](char(0x2c))>=0x0||_0x2325f6[_0x1168('0x5a')]()[_0x1168('0x5b')](char(0x22))>=0x0);}function encapsulate(_0x17741c){var _0x59fe1a=char(0x22),_0x5baedf='\x5c'+char(0x22),_0x570c0c=_0x17741c[_0x1168('0x5a')]()['replace'](new RegExp(_0x59fe1a,'g'),_0x5baedf);return _0x59fe1a+_0x570c0c+_0x59fe1a;}exports[_0x1168('0x5c')]=function(_0x5f3ec2,_0x263d4f,_0x40b8d4){var _0x38fc72,_0x558ace;var _0x866543={'where':{'ProjectId':_0x5f3ec2[_0x1168('0x50')]['id']}};if(_0x5f3ec2['query'][_0x1168('0x5d')]){_0x866543[_0x1168('0x3b')][_0x1168('0x5e')]=JSON[_0x1168('0x5f')](_0x5f3ec2[_0x1168('0x31')][_0x1168('0x5d')]);}return db[_0x1168('0x54')][_0x1168('0x43')](_0x866543)[_0x1168('0x23')](handleEntityNotFound(_0x263d4f,null))[_0x1168('0x23')](function(_0x38f5ee){if(_0x38f5ee){_0x38fc72=_0x38f5ee;return db[_0x1168('0x60')][_0x1168('0x43')]({'where':{'SessionId':{'$in':_[_0x1168('0x30')](_0x38fc72,'id')},'ProjectId':_0x5f3ec2[_0x1168('0x50')]['id']},'order':_0x1168('0x61')});}})[_0x1168('0x23')](handleEntityNotFound(_0x263d4f,null))['then'](function(_0x23e02a){if(_0x23e02a){_0x558ace=_0x23e02a;var _0x2831c8={};for(var _0x4ec91b=0x0,_0x54b458=_0x558ace[_0x1168('0x37')];_0x4ec91b<_0x54b458;_0x4ec91b++){if(!_0x2831c8[_0x1168('0x38')](_0x558ace[_0x4ec91b][_0x1168('0x62')])){_0x2831c8[_0x558ace[_0x4ec91b][_0x1168('0x62')]]=needsEncapsulation(_0x558ace[_0x4ec91b]['question'])?encapsulate(_0x558ace[_0x4ec91b][_0x1168('0x63')]):_0x558ace[_0x4ec91b][_0x1168('0x63')];}}var _0x209852=[],_0x4917e6={};for(var _0x2237a9=0x0,_0x5a8fc3=_0x38fc72[_0x1168('0x37')];_0x2237a9<_0x5a8fc3;_0x2237a9++){_0x4917e6={'ProjectId':_0x5f3ec2[_0x1168('0x50')]['id'],'SessionId':_0x38fc72[_0x2237a9]['id'],'StartTime':moment(_0x38fc72[_0x2237a9][_0x1168('0x5e')])['format']('YYYY-MM-DD\x20HH:mm:ss')};for(var _0x30ec20=0x0,_0x12a7e4=_0x558ace[_0x1168('0x37')];_0x30ec20<_0x12a7e4;_0x30ec20++){if(_0x558ace[_0x30ec20][_0x1168('0x64')]==_0x38fc72[_0x2237a9]['id']&&_0x2831c8[_0x1168('0x38')](_0x558ace[_0x30ec20][_0x1168('0x62')])){_0x4917e6[_0x2831c8[_0x558ace[_0x30ec20]['questionId']]]=_0x558ace[_0x30ec20][_0x1168('0x65')];}}for(var _0x3b5610 in _0x2831c8){if(!_0x4917e6['hasOwnProperty'](_0x2831c8[_0x3b5610])){_0x4917e6[_0x2831c8[_0x3b5610]]=null;}}_0x209852[_0x1168('0x66')](_0x4917e6);}return _0x209852;}})['then'](function(_0x4a65ea){if(!_[_0x1168('0x67')](_0x4a65ea)){var _0x228290=toCsv(_0x4a65ea);var _0x2a5271=Date[_0x1168('0x68')]();fs['writeFileSync'](util[_0x1168('0x69')](_0x1168('0x6a'),_0x5f3ec2['params']['id'],_0x2a5271),_0x228290);_0x263d4f[_0x1168('0x6b')](_0x1168('0x6c'),_0x1168('0x6d')+util[_0x1168('0x69')](_0x1168('0x6e'),_0x5f3ec2[_0x1168('0x50')]['id'],_0x2a5271));_0x263d4f[_0x1168('0x6b')](_0x1168('0x6f'),'text/csv');return _0x263d4f[_0x1168('0x70')](util[_0x1168('0x69')](_0x1168('0x6a'),_0x5f3ec2[_0x1168('0x50')]['id'],_0x2a5271));}else{return _0x263d4f[_0x1168('0x15')](0xcc);}})['catch'](handleError(_0x263d4f,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff