// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x6b47=['Content-disposition','Jscripty_Project_%d_Summary_%s.csv','Content-type','text/csv','download','rimraf','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','count','limit','set','apply','reject','update','then','destroy','UserProfileResource','error','name','send','index','map','JscriptyProject','rawAttributes','fieldName','key','keys','intersection','model','fields','query','length','attributes','nolimit','order','sort','filters','pick','filter','where','merge','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','params','find','create','body','user','get','role','UserProfileSection','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','createdAt','updatedAt','autoAssociation','getSessions','findOne','JscriptySessionReport','hasOwnProperty','ProjectId','getAnswers','JscriptyAnswerReport','fromCharCode','toString','indexOf','replace','startTime','starttime','parse','JscriptyQuestionReport','questionId','question','format','YYYY-MM-DD\x20HH:mm:ss','push','isEmpty','now','setHeader'];(function(_0x542d80,_0x150561){var _0x1f4492=function(_0x542215){while(--_0x542215){_0x542d80['push'](_0x542d80['shift']());}};_0x1f4492(++_0x150561);}(_0x6b47,0xe9));var _0x76b4=function(_0x1c101f,_0x52141d){_0x1c101f=_0x1c101f-0x0;var _0xe02ee4=_0x6b47[_0x1c101f];return _0xe02ee4;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x76b4('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0x76b4('0x1'));var rp=require(_0x76b4('0x2'));var moment=require(_0x76b4('0x3'));var BPromise=require(_0x76b4('0x4'));var Mustache=require('mustache');var util=require(_0x76b4('0x5'));var path=require(_0x76b4('0x6'));var sox=require(_0x76b4('0x7'));var csv=require(_0x76b4('0x8'));var ejs=require(_0x76b4('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x76b4('0xa'));var squel=require(_0x76b4('0xb'));var crypto=require(_0x76b4('0xc'));var jsforce=require(_0x76b4('0xd'));var deskjs=require(_0x76b4('0xe'));var toCsv=require(_0x76b4('0x8'));var querystring=require(_0x76b4('0xf'));var Papa=require(_0x76b4('0x10'));var Redis=require(_0x76b4('0x11'));var authService=require(_0x76b4('0x12'));var qs=require(_0x76b4('0x13'));var as=require(_0x76b4('0x14'));var hardwareService=require(_0x76b4('0x15'));var logger=require('../../config/logger')(_0x76b4('0x16'));var utils=require(_0x76b4('0x17'));var config=require('../../config/environment');var licenseUtil=require(_0x76b4('0x18'));var db=require(_0x76b4('0x19'))['db'];function respondWithStatusCode(_0xf62e19,_0x5c7cb6){_0x5c7cb6=_0x5c7cb6||0xcc;return function(_0x4dddac){if(_0x4dddac){return _0xf62e19[_0x76b4('0x1a')](_0x5c7cb6);}return _0xf62e19[_0x76b4('0x1b')](_0x5c7cb6)[_0x76b4('0x1c')]();};}function respondWithResult(_0x94f8e7,_0x389092){_0x389092=_0x389092||0xc8;return function(_0xada02b){if(_0xada02b){return _0x94f8e7[_0x76b4('0x1b')](_0x389092)[_0x76b4('0x1d')](_0xada02b);}};}function respondWithFilteredResult(_0x3f10d6,_0x3a0508){return function(_0x507542){if(_0x507542){var _0x5ebc74=typeof _0x3a0508[_0x76b4('0x1e')]===_0x76b4('0x1f')&&typeof _0x3a0508['limit']==='undefined';var _0x12efb4=_0x507542[_0x76b4('0x20')];var _0x2bf42a=_0x5ebc74?0x0:_0x3a0508[_0x76b4('0x1e')];var _0x19feeb=_0x5ebc74?_0x507542['count']:_0x3a0508[_0x76b4('0x1e')]+_0x3a0508[_0x76b4('0x21')];var _0xe074f9;if(_0x19feeb>=_0x12efb4){_0x19feeb=_0x12efb4;_0xe074f9=0xc8;}else{_0xe074f9=0xce;}_0x3f10d6[_0x76b4('0x1b')](_0xe074f9);return _0x3f10d6[_0x76b4('0x22')]('Content-Range',_0x2bf42a+'-'+_0x19feeb+'/'+_0x12efb4)[_0x76b4('0x1d')](_0x507542);}return null;};}function patchUpdates(_0x4ee840){return function(_0x5c9a79){try{jsonpatch[_0x76b4('0x23')](_0x5c9a79,_0x4ee840,!![]);}catch(_0x1e8e95){return BPromise[_0x76b4('0x24')](_0x1e8e95);}return _0x5c9a79['save']();};}function saveUpdates(_0x35956a,_0x56bfcd){return function(_0x43ccf7){if(_0x43ccf7){return _0x43ccf7[_0x76b4('0x25')](_0x35956a)[_0x76b4('0x26')](function(_0xc7b013){return _0xc7b013;});}return null;};}function removeEntity(_0x41b614,_0x40e25a){return function(_0x1d263b){if(_0x1d263b){return _0x1d263b[_0x76b4('0x27')]()['then'](function(){var _0x1ffb52=_0x1d263b['get']({'plain':!![]});var _0x458b60='Projects';return db[_0x76b4('0x28')]['destroy']({'where':{'type':_0x458b60,'resourceId':_0x1ffb52['id']}})[_0x76b4('0x26')](function(){return _0x1d263b;});})[_0x76b4('0x26')](function(){_0x41b614['status'](0xcc)[_0x76b4('0x1c')]();});}};}function handleEntityNotFound(_0x173edb,_0x6887ae){return function(_0x56b805){if(!_0x56b805){_0x173edb[_0x76b4('0x1a')](0x194);}return _0x56b805;};}function handleError(_0x7d687,_0x3e8b9a){_0x3e8b9a=_0x3e8b9a||0x1f4;return function(_0x5f0443){logger[_0x76b4('0x29')](_0x5f0443['stack']);if(_0x5f0443[_0x76b4('0x2a')]){delete _0x5f0443[_0x76b4('0x2a')];}_0x7d687[_0x76b4('0x1b')](_0x3e8b9a)[_0x76b4('0x2b')](_0x5f0443);};}exports[_0x76b4('0x2c')]=function(_0x3f8d87,_0x316a2a){var _0x1330b5={},_0xc7e753={},_0x455b4a={'count':0x0,'rows':[]};var _0x4e6b42=_[_0x76b4('0x2d')](db[_0x76b4('0x2e')][_0x76b4('0x2f')],function(_0x5ba568){return{'name':_0x5ba568[_0x76b4('0x30')],'type':_0x5ba568['type'][_0x76b4('0x31')]};});_0xc7e753['model']=_[_0x76b4('0x2d')](_0x4e6b42,_0x76b4('0x2a'));_0xc7e753['query']=_[_0x76b4('0x32')](_0x3f8d87['query']);_0xc7e753['filters']=_[_0x76b4('0x33')](_0xc7e753[_0x76b4('0x34')],_0xc7e753['query']);_0x1330b5['attributes']=_[_0x76b4('0x33')](_0xc7e753[_0x76b4('0x34')],qs[_0x76b4('0x35')](_0x3f8d87[_0x76b4('0x36')][_0x76b4('0x35')]));_0x1330b5['attributes']=_0x1330b5['attributes'][_0x76b4('0x37')]?_0x1330b5[_0x76b4('0x38')]:_0xc7e753['model'];if(!_0x3f8d87[_0x76b4('0x36')]['hasOwnProperty'](_0x76b4('0x39'))){_0x1330b5[_0x76b4('0x21')]=qs[_0x76b4('0x21')](_0x3f8d87[_0x76b4('0x36')]['limit']);_0x1330b5[_0x76b4('0x1e')]=qs[_0x76b4('0x1e')](_0x3f8d87[_0x76b4('0x36')][_0x76b4('0x1e')]);}_0x1330b5[_0x76b4('0x3a')]=qs[_0x76b4('0x3b')](_0x3f8d87[_0x76b4('0x36')][_0x76b4('0x3b')]);_0x1330b5['where']=qs[_0x76b4('0x3c')](_[_0x76b4('0x3d')](_0x3f8d87[_0x76b4('0x36')],_0xc7e753['filters']),_0x4e6b42);if(_0x3f8d87['query'][_0x76b4('0x3e')]){_0x1330b5[_0x76b4('0x3f')]=_[_0x76b4('0x40')](_0x1330b5['where'],{'$or':_['map'](_0x4e6b42,function(_0x5e368c){if(_0x5e368c['type']!==_0x76b4('0x41')){var _0xe6bdda={};_0xe6bdda[_0x5e368c[_0x76b4('0x2a')]]={'$like':'%'+_0x3f8d87[_0x76b4('0x36')][_0x76b4('0x3e')]+'%'};return _0xe6bdda;}})});}_0x1330b5=_['merge']({},_0x1330b5,_0x3f8d87[_0x76b4('0x42')]);var _0x3d65c7={'where':_0x1330b5[_0x76b4('0x3f')]};return db[_0x76b4('0x2e')][_0x76b4('0x20')](_0x3d65c7)['then'](function(_0x536fd6){_0x455b4a['count']=_0x536fd6;if(_0x3f8d87['query'][_0x76b4('0x43')]){_0x1330b5[_0x76b4('0x44')]=[{'all':!![]}];}return db[_0x76b4('0x2e')][_0x76b4('0x45')](_0x1330b5);})[_0x76b4('0x26')](function(_0x31f3ce){_0x455b4a[_0x76b4('0x46')]=_0x31f3ce;return _0x455b4a;})[_0x76b4('0x26')](respondWithFilteredResult(_0x316a2a,_0x1330b5))[_0x76b4('0x47')](handleError(_0x316a2a,null));};exports[_0x76b4('0x48')]=function(_0xbea460,_0x145c1f){var _0x4ba841={'raw':![],'where':{'id':_0xbea460[_0x76b4('0x49')]['id']}},_0x1cbf07={};_0x1cbf07[_0x76b4('0x34')]=_['keys'](db[_0x76b4('0x2e')][_0x76b4('0x2f')]);_0x1cbf07[_0x76b4('0x36')]=_[_0x76b4('0x32')](_0xbea460['query']);_0x1cbf07[_0x76b4('0x3c')]=_[_0x76b4('0x33')](_0x1cbf07['model'],_0x1cbf07[_0x76b4('0x36')]);_0x4ba841[_0x76b4('0x38')]=_[_0x76b4('0x33')](_0x1cbf07['model'],qs['fields'](_0xbea460['query'][_0x76b4('0x35')]));_0x4ba841['attributes']=_0x4ba841[_0x76b4('0x38')][_0x76b4('0x37')]?_0x4ba841[_0x76b4('0x38')]:_0x1cbf07[_0x76b4('0x34')];if(_0xbea460[_0x76b4('0x36')][_0x76b4('0x43')]){_0x4ba841['include']=[{'all':!![]}];}_0x4ba841=_[_0x76b4('0x40')]({},_0x4ba841,_0xbea460[_0x76b4('0x42')]);return db[_0x76b4('0x2e')][_0x76b4('0x4a')](_0x4ba841)[_0x76b4('0x26')](handleEntityNotFound(_0x145c1f,null))[_0x76b4('0x26')](respondWithResult(_0x145c1f,null))[_0x76b4('0x47')](handleError(_0x145c1f,null));};exports[_0x76b4('0x4b')]=function(_0x7e3be1,_0x2bc1e8){return db[_0x76b4('0x2e')]['create'](_0x7e3be1[_0x76b4('0x4c')],{})['then'](function(_0x60cbb){var _0x27c0e8=_0x7e3be1[_0x76b4('0x4d')][_0x76b4('0x4e')]({'plain':!![]});if(!_0x27c0e8)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x27c0e8[_0x76b4('0x4f')]==='user'){var _0x27150d=_0x60cbb[_0x76b4('0x4e')]({'plain':!![]});var _0x3a6931='Projects';return db[_0x76b4('0x50')][_0x76b4('0x4a')]({'where':{'name':_0x3a6931,'userProfileId':_0x27c0e8[_0x76b4('0x51')]},'raw':!![]})[_0x76b4('0x26')](function(_0x34ce1b){if(_0x34ce1b&&_0x34ce1b['autoAssociation']===0x0){return db[_0x76b4('0x28')]['create']({'name':_0x27150d[_0x76b4('0x2a')],'resourceId':_0x27150d['id'],'type':_0x34ce1b[_0x76b4('0x2a')],'sectionId':_0x34ce1b['id']},{})[_0x76b4('0x26')](function(){return _0x60cbb;});}else{return _0x60cbb;}})[_0x76b4('0x47')](function(_0xfc2e7f){logger[_0x76b4('0x29')](_0x76b4('0x52'),_0xfc2e7f);throw _0xfc2e7f;});}return _0x60cbb;})[_0x76b4('0x26')](respondWithResult(_0x2bc1e8,0xc9))[_0x76b4('0x47')](handleError(_0x2bc1e8,null));};exports['clone']=function(_0x201fc4,_0x3ab37a){var _0x3899f6={'where':{'id':_0x201fc4[_0x76b4('0x49')]['id']}},_0x5b38de={};_0x5b38de['model']=_[_0x76b4('0x32')](db[_0x76b4('0x2e')][_0x76b4('0x2f')]);_0x3899f6[_0x76b4('0x38')]=_[_0x76b4('0x33')](_0x5b38de[_0x76b4('0x34')],qs['fields'](_0x201fc4[_0x76b4('0x36')][_0x76b4('0x35')]));_0x3899f6[_0x76b4('0x38')]=_0x3899f6['attributes'][_0x76b4('0x37')]?_0x3899f6[_0x76b4('0x38')]:_0x5b38de[_0x76b4('0x34')];if(_0x201fc4[_0x76b4('0x36')][_0x76b4('0x43')]){_0x3899f6[_0x76b4('0x44')]=[{'all':!![]}];}_0x3899f6=_['merge']({},_0x3899f6,_0x201fc4[_0x76b4('0x42')]);return db[_0x76b4('0x2e')]['find'](_0x3899f6)[_0x76b4('0x26')](handleEntityNotFound(_0x3ab37a,null))[_0x76b4('0x26')](function(_0x32bbec){if(_0x32bbec){var _0x3e1663=_0x32bbec[_0x76b4('0x4e')]({'plain':!![]});_0x3e1663=qs['omit'](_0x3e1663,['id',_0x76b4('0x53'),_0x76b4('0x54')]);_0x201fc4['body']=_['omit'](_0x201fc4[_0x76b4('0x4c')],['id','createdAt',_0x76b4('0x54')]);return db[_0x76b4('0x2e')]['create'](_[_0x76b4('0x40')](_0x3e1663,_0x201fc4[_0x76b4('0x4c')]),{'include':_0x201fc4[_0x76b4('0x36')][_0x76b4('0x43')]?[{'all':!![]}]:undefined})[_0x76b4('0x26')](function(_0x2a4429){var _0x3d695f=_0x201fc4[_0x76b4('0x4d')]['get']({'plain':!![]});if(!_0x3d695f)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x3d695f[_0x76b4('0x4f')]==='user'){var _0x58f75a=_0x2a4429[_0x76b4('0x4e')]({'plain':!![]});var _0x53a80c='Projects';return db[_0x76b4('0x50')][_0x76b4('0x4a')]({'where':{'name':_0x53a80c,'userProfileId':_0x3d695f[_0x76b4('0x51')]},'raw':!![]})[_0x76b4('0x26')](function(_0x5a8508){if(_0x5a8508&&_0x5a8508[_0x76b4('0x55')]===0x0){return db[_0x76b4('0x28')][_0x76b4('0x4b')]({'name':_0x58f75a['name'],'resourceId':_0x58f75a['id'],'type':_0x5a8508[_0x76b4('0x2a')],'sectionId':_0x5a8508['id']},{})[_0x76b4('0x26')](function(){return _0x2a4429;});}else{return _0x2a4429;}})['catch'](function(_0x318d08){logger[_0x76b4('0x29')](_0x76b4('0x52'),_0x318d08);throw _0x318d08;});}return _0x2a4429;});}})[_0x76b4('0x26')](respondWithResult(_0x3ab37a,0xc9))[_0x76b4('0x47')](handleError(_0x3ab37a,null));};exports['update']=function(_0x3e4a85,_0x295368){if(_0x3e4a85[_0x76b4('0x4c')]['id']){delete _0x3e4a85[_0x76b4('0x4c')]['id'];}return db[_0x76b4('0x2e')][_0x76b4('0x4a')]({'where':{'id':_0x3e4a85[_0x76b4('0x49')]['id']}})[_0x76b4('0x26')](handleEntityNotFound(_0x295368,null))[_0x76b4('0x26')](saveUpdates(_0x3e4a85['body'],null))[_0x76b4('0x26')](respondWithResult(_0x295368,null))[_0x76b4('0x47')](handleError(_0x295368,null));};exports['destroy']=function(_0x4f3bea,_0x57520c){return db[_0x76b4('0x2e')]['find']({'where':{'id':_0x4f3bea[_0x76b4('0x49')]['id']}})[_0x76b4('0x26')](handleEntityNotFound(_0x57520c,null))[_0x76b4('0x26')](removeEntity(_0x57520c,null))[_0x76b4('0x47')](handleError(_0x57520c,null));};exports[_0x76b4('0x56')]=function(_0x9848eb,_0x55ba3b,_0x31105e){var _0x5d4b70={'raw':!![],'where':{}};var _0x22baeb={};var _0x3d66ae={'count':0x0,'rows':[]};return db[_0x76b4('0x2e')][_0x76b4('0x57')]({'where':{'id':_0x9848eb[_0x76b4('0x49')]['id']}})[_0x76b4('0x26')](handleEntityNotFound(_0x55ba3b,null))[_0x76b4('0x26')](function(_0x2d3601){if(_0x2d3601){_0x22baeb[_0x76b4('0x34')]=_[_0x76b4('0x32')](db[_0x76b4('0x58')][_0x76b4('0x2f')]);_0x22baeb[_0x76b4('0x36')]=_[_0x76b4('0x32')](_0x9848eb[_0x76b4('0x36')]);_0x22baeb[_0x76b4('0x3c')]=_[_0x76b4('0x33')](_0x22baeb[_0x76b4('0x34')],_0x22baeb[_0x76b4('0x36')]);_0x5d4b70['attributes']=_[_0x76b4('0x33')](_0x22baeb[_0x76b4('0x34')],qs[_0x76b4('0x35')](_0x9848eb[_0x76b4('0x36')]['fields']));_0x5d4b70[_0x76b4('0x38')]=_0x5d4b70[_0x76b4('0x38')][_0x76b4('0x37')]?_0x5d4b70[_0x76b4('0x38')]:_0x22baeb[_0x76b4('0x34')];if(!_0x9848eb[_0x76b4('0x36')][_0x76b4('0x59')]('nolimit')){_0x5d4b70[_0x76b4('0x21')]=qs[_0x76b4('0x21')](_0x9848eb['query']['limit']);_0x5d4b70[_0x76b4('0x1e')]=qs[_0x76b4('0x1e')](_0x9848eb[_0x76b4('0x36')][_0x76b4('0x1e')]);}_0x5d4b70[_0x76b4('0x3a')]=qs[_0x76b4('0x3b')](_0x9848eb[_0x76b4('0x36')][_0x76b4('0x3b')]);_0x5d4b70[_0x76b4('0x3f')]=qs[_0x76b4('0x3c')](_['pick'](_0x9848eb[_0x76b4('0x36')],_0x22baeb[_0x76b4('0x3c')]));_0x5d4b70[_0x76b4('0x3f')][_0x76b4('0x5a')]=_0x2d3601['id'];if(_0x9848eb[_0x76b4('0x36')][_0x76b4('0x3e')]){_0x5d4b70[_0x76b4('0x3f')]=_['merge'](_0x5d4b70[_0x76b4('0x3f')],{'$or':_[_0x76b4('0x2d')](_0x5d4b70[_0x76b4('0x38')],function(_0x4a8559){var _0x450d9c={};_0x450d9c[_0x4a8559]={'$like':'%'+_0x9848eb[_0x76b4('0x36')][_0x76b4('0x3e')]+'%'};return _0x450d9c;})});}_0x5d4b70=_[_0x76b4('0x40')]({},_0x5d4b70,_0x9848eb[_0x76b4('0x42')]);return db[_0x76b4('0x58')][_0x76b4('0x20')]({'where':_0x5d4b70[_0x76b4('0x3f')]})[_0x76b4('0x26')](function(_0x51b218){_0x3d66ae[_0x76b4('0x20')]=_0x51b218;if(_0x9848eb[_0x76b4('0x36')]['includeAll']){_0x5d4b70['include']=[{'all':!![]}];}return db[_0x76b4('0x58')][_0x76b4('0x45')](_0x5d4b70);})['then'](function(_0x39f441){_0x3d66ae[_0x76b4('0x46')]=_0x39f441;return _0x3d66ae;});}})[_0x76b4('0x26')](respondWithFilteredResult(_0x55ba3b,_0x5d4b70))[_0x76b4('0x47')](handleError(_0x55ba3b,null));};exports[_0x76b4('0x5b')]=function(_0x1400ef,_0x346f2b,_0x1d03dd){var _0x2fad4d={'raw':!![],'where':{}};var _0x5145c1={};var _0x4f5e41={'count':0x0,'rows':[]};return db['JscriptyProject'][_0x76b4('0x57')]({'where':{'id':_0x1400ef['params']['id']}})[_0x76b4('0x26')](handleEntityNotFound(_0x346f2b,null))[_0x76b4('0x26')](function(_0x2a7d27){if(_0x2a7d27){_0x5145c1['model']=_[_0x76b4('0x32')](db[_0x76b4('0x5c')][_0x76b4('0x2f')]);_0x5145c1[_0x76b4('0x36')]=_[_0x76b4('0x32')](_0x1400ef[_0x76b4('0x36')]);_0x5145c1[_0x76b4('0x3c')]=_[_0x76b4('0x33')](_0x5145c1['model'],_0x5145c1[_0x76b4('0x36')]);_0x2fad4d['attributes']=_[_0x76b4('0x33')](_0x5145c1['model'],qs[_0x76b4('0x35')](_0x1400ef[_0x76b4('0x36')][_0x76b4('0x35')]));_0x2fad4d['attributes']=_0x2fad4d[_0x76b4('0x38')][_0x76b4('0x37')]?_0x2fad4d['attributes']:_0x5145c1[_0x76b4('0x34')];if(!_0x1400ef[_0x76b4('0x36')][_0x76b4('0x59')](_0x76b4('0x39'))){_0x2fad4d['limit']=qs[_0x76b4('0x21')](_0x1400ef[_0x76b4('0x36')][_0x76b4('0x21')]);_0x2fad4d[_0x76b4('0x1e')]=qs[_0x76b4('0x1e')](_0x1400ef[_0x76b4('0x36')][_0x76b4('0x1e')]);}_0x2fad4d[_0x76b4('0x3a')]=qs['sort'](_0x1400ef[_0x76b4('0x36')]['sort']);_0x2fad4d['where']=qs['filters'](_['pick'](_0x1400ef[_0x76b4('0x36')],_0x5145c1['filters']));_0x2fad4d[_0x76b4('0x3f')][_0x76b4('0x5a')]=_0x2a7d27['id'];if(_0x1400ef[_0x76b4('0x36')][_0x76b4('0x3e')]){_0x2fad4d[_0x76b4('0x3f')]=_[_0x76b4('0x40')](_0x2fad4d[_0x76b4('0x3f')],{'$or':_[_0x76b4('0x2d')](_0x2fad4d[_0x76b4('0x38')],function(_0x3cf0dc){var _0x5a3b6f={};_0x5a3b6f[_0x3cf0dc]={'$like':'%'+_0x1400ef[_0x76b4('0x36')][_0x76b4('0x3e')]+'%'};return _0x5a3b6f;})});}_0x2fad4d=_[_0x76b4('0x40')]({},_0x2fad4d,_0x1400ef[_0x76b4('0x42')]);return db[_0x76b4('0x5c')][_0x76b4('0x20')]({'where':_0x2fad4d[_0x76b4('0x3f')]})['then'](function(_0x40c85e){_0x4f5e41[_0x76b4('0x20')]=_0x40c85e;if(_0x1400ef[_0x76b4('0x36')][_0x76b4('0x43')]){_0x2fad4d['include']=[{'all':!![]}];}return db[_0x76b4('0x5c')][_0x76b4('0x45')](_0x2fad4d);})[_0x76b4('0x26')](function(_0x31832c){_0x4f5e41[_0x76b4('0x46')]=_0x31832c;return _0x4f5e41;});}})['then'](respondWithFilteredResult(_0x346f2b,_0x2fad4d))['catch'](handleError(_0x346f2b,null));};function char(_0x197a57){return'number'===typeof _0x197a57?String[_0x76b4('0x5d')]['apply'](null,arguments):_0x197a57;}function needsEncapsulation(_0x1f81c6){return!!_0x1f81c6&&(_0x1f81c6[_0x76b4('0x5e')]()[_0x76b4('0x5f')](char(0xd))>=0x0||_0x1f81c6['toString']()[_0x76b4('0x5f')](char(0xa))>=0x0||_0x1f81c6['toString']()[_0x76b4('0x5f')](char(0x2c))>=0x0||_0x1f81c6[_0x76b4('0x5e')]()[_0x76b4('0x5f')](char(0x22))>=0x0);}function encapsulate(_0x1da363){var _0x4c5c8e=char(0x22),_0x111082='\x5c'+char(0x22),_0xe1ce07=_0x1da363[_0x76b4('0x5e')]()[_0x76b4('0x60')](new RegExp(_0x4c5c8e,'g'),_0x111082);return _0x4c5c8e+_0xe1ce07+_0x4c5c8e;}exports['getSummary']=function(_0x4eb451,_0x3598c5,_0x1c3b5c){var _0x401104,_0x5e17cf;var _0x4bd08e={'where':{'ProjectId':_0x4eb451[_0x76b4('0x49')]['id']}};if(_0x4eb451[_0x76b4('0x36')][_0x76b4('0x61')]){_0x4bd08e['where'][_0x76b4('0x62')]=JSON[_0x76b4('0x63')](_0x4eb451[_0x76b4('0x36')][_0x76b4('0x61')]);}return db[_0x76b4('0x58')]['findAll'](_0x4bd08e)[_0x76b4('0x26')](handleEntityNotFound(_0x3598c5,null))['then'](function(_0x345c12){if(_0x345c12){_0x401104=_0x345c12;return db[_0x76b4('0x64')][_0x76b4('0x45')]({'where':{'SessionId':{'$in':_[_0x76b4('0x2d')](_0x401104,'id')},'ProjectId':_0x4eb451[_0x76b4('0x49')]['id']},'order':'-createdAt'});}})['then'](handleEntityNotFound(_0x3598c5,null))[_0x76b4('0x26')](function(_0x41fd33){if(_0x41fd33){_0x5e17cf=_0x41fd33;var _0x1bb269={};for(var _0x2f13fe=0x0,_0x45dff3=_0x5e17cf['length'];_0x2f13fe<_0x45dff3;_0x2f13fe++){if(!_0x1bb269[_0x76b4('0x59')](_0x5e17cf[_0x2f13fe]['questionId'])){_0x1bb269[_0x5e17cf[_0x2f13fe][_0x76b4('0x65')]]=needsEncapsulation(_0x5e17cf[_0x2f13fe][_0x76b4('0x66')])?encapsulate(_0x5e17cf[_0x2f13fe][_0x76b4('0x66')]):_0x5e17cf[_0x2f13fe][_0x76b4('0x66')];}}var _0x1b5f30=[],_0xd716fb={};for(var _0x1b4c81=0x0,_0x3d80aa=_0x401104['length'];_0x1b4c81<_0x3d80aa;_0x1b4c81++){_0xd716fb={'ProjectId':_0x4eb451[_0x76b4('0x49')]['id'],'SessionId':_0x401104[_0x1b4c81]['id'],'StartTime':moment(_0x401104[_0x1b4c81][_0x76b4('0x62')])[_0x76b4('0x67')](_0x76b4('0x68'))};for(var _0x5e8bcc=0x0,_0x12074b=_0x5e17cf[_0x76b4('0x37')];_0x5e8bcc<_0x12074b;_0x5e8bcc++){if(_0x5e17cf[_0x5e8bcc]['SessionId']==_0x401104[_0x1b4c81]['id']&&_0x1bb269[_0x76b4('0x59')](_0x5e17cf[_0x5e8bcc]['questionId'])){_0xd716fb[_0x1bb269[_0x5e17cf[_0x5e8bcc][_0x76b4('0x65')]]]=_0x5e17cf[_0x5e8bcc]['answer'];}}for(var _0xcfa709 in _0x1bb269){if(!_0xd716fb[_0x76b4('0x59')](_0x1bb269[_0xcfa709])){_0xd716fb[_0x1bb269[_0xcfa709]]=null;}}_0x1b5f30[_0x76b4('0x69')](_0xd716fb);}return _0x1b5f30;}})[_0x76b4('0x26')](function(_0x49e122){if(!_[_0x76b4('0x6a')](_0x49e122)){var _0x27ad0a=toCsv(_0x49e122);var _0x538f66=Date[_0x76b4('0x6b')]();fs['writeFileSync'](util[_0x76b4('0x67')]('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x4eb451[_0x76b4('0x49')]['id'],_0x538f66),_0x27ad0a);_0x3598c5[_0x76b4('0x6c')](_0x76b4('0x6d'),'attachment;\x20filename='+util['format'](_0x76b4('0x6e'),_0x4eb451['params']['id'],_0x538f66));_0x3598c5['setHeader'](_0x76b4('0x6f'),_0x76b4('0x70'));return _0x3598c5[_0x76b4('0x71')](util['format']('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x4eb451['params']['id'],_0x538f66));}else{return _0x3598c5[_0x76b4('0x1a')](0xcc);}})[_0x76b4('0x47')](handleError(_0x3598c5,null));};
\ No newline at end of file
+var _0x4eb5=['user','find','userProfileId','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','updatedAt','body','Projects','UserProfileSection','getSessions','JscriptySessionReport','pick','ProjectId','getAnswers','findOne','JscriptyAnswerReport','hasOwnProperty','number','fromCharCode','toString','indexOf','starttime','JscriptyQuestionReport','-createdAt','questionId','question','YYYY-MM-DD\x20HH:mm:ss','SessionId','answer','push','now','writeFileSync','format','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','Content-type','text/csv','download','eml-format','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','to-csv','ejs','fs-extra','lodash','squel','crypto','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','status','end','json','offset','limit','count','set','apply','update','then','destroy','UserProfileResource','sendStatus','stack','name','send','index','map','rawAttributes','fieldName','model','keys','query','intersection','attributes','fields','nolimit','order','sort','filters','where','merge','type','VIRTUAL','filter','options','JscriptyProject','include','findAll','rows','catch','show','params','length','includeAll','create','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role'];(function(_0x4f2c3a,_0x6bde90){var _0x17d91c=function(_0xaaf630){while(--_0xaaf630){_0x4f2c3a['push'](_0x4f2c3a['shift']());}};_0x17d91c(++_0x6bde90);}(_0x4eb5,0x19a));var _0x54eb=function(_0x549614,_0x4ffebb){_0x549614=_0x549614-0x0;var _0x1f7fbc=_0x4eb5[_0x549614];return _0x1f7fbc;};'use strict';var emlformat=require(_0x54eb('0x0'));var rimraf=require(_0x54eb('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x54eb('0x2'));var rp=require(_0x54eb('0x3'));var moment=require(_0x54eb('0x4'));var BPromise=require(_0x54eb('0x5'));var Mustache=require(_0x54eb('0x6'));var util=require(_0x54eb('0x7'));var path=require(_0x54eb('0x8'));var sox=require('sox');var csv=require(_0x54eb('0x9'));var ejs=require(_0x54eb('0xa'));var fs=require('fs');var fs_extra=require(_0x54eb('0xb'));var _=require(_0x54eb('0xc'));var squel=require(_0x54eb('0xd'));var crypto=require(_0x54eb('0xe'));var jsforce=require(_0x54eb('0xf'));var deskjs=require(_0x54eb('0x10'));var toCsv=require(_0x54eb('0x9'));var querystring=require(_0x54eb('0x11'));var Papa=require(_0x54eb('0x12'));var Redis=require(_0x54eb('0x13'));var authService=require(_0x54eb('0x14'));var qs=require(_0x54eb('0x15'));var as=require(_0x54eb('0x16'));var hardwareService=require(_0x54eb('0x17'));var logger=require(_0x54eb('0x18'))(_0x54eb('0x19'));var utils=require('../../config/utils');var config=require(_0x54eb('0x1a'));var licenseUtil=require(_0x54eb('0x1b'));var db=require(_0x54eb('0x1c'))['db'];function respondWithStatusCode(_0x87391,_0x21c9bc){_0x21c9bc=_0x21c9bc||0xcc;return function(_0x3c14b3){if(_0x3c14b3){return _0x87391['sendStatus'](_0x21c9bc);}return _0x87391[_0x54eb('0x1d')](_0x21c9bc)[_0x54eb('0x1e')]();};}function respondWithResult(_0x3bdff3,_0x37e41a){_0x37e41a=_0x37e41a||0xc8;return function(_0x175d6b){if(_0x175d6b){return _0x3bdff3['status'](_0x37e41a)[_0x54eb('0x1f')](_0x175d6b);}};}function respondWithFilteredResult(_0x2b15ae,_0x58b082){return function(_0x574518){if(_0x574518){var _0x2f9dcc=typeof _0x58b082[_0x54eb('0x20')]==='undefined'&&typeof _0x58b082[_0x54eb('0x21')]==='undefined';var _0x2c742a=_0x574518[_0x54eb('0x22')];var _0x26e281=_0x2f9dcc?0x0:_0x58b082['offset'];var _0x35911c=_0x2f9dcc?_0x574518[_0x54eb('0x22')]:_0x58b082[_0x54eb('0x20')]+_0x58b082[_0x54eb('0x21')];var _0x4fc699;if(_0x35911c>=_0x2c742a){_0x35911c=_0x2c742a;_0x4fc699=0xc8;}else{_0x4fc699=0xce;}_0x2b15ae['status'](_0x4fc699);return _0x2b15ae[_0x54eb('0x23')]('Content-Range',_0x26e281+'-'+_0x35911c+'/'+_0x2c742a)['json'](_0x574518);}return null;};}function patchUpdates(_0x484b91){return function(_0x357b91){try{jsonpatch[_0x54eb('0x24')](_0x357b91,_0x484b91,!![]);}catch(_0x833d79){return BPromise['reject'](_0x833d79);}return _0x357b91['save']();};}function saveUpdates(_0x56c1ef,_0x3370d1){return function(_0x28c8e6){if(_0x28c8e6){return _0x28c8e6[_0x54eb('0x25')](_0x56c1ef)[_0x54eb('0x26')](function(_0x41274e){return _0x41274e;});}return null;};}function removeEntity(_0x45c2c8,_0x3dd1d5){return function(_0x28eb4f){if(_0x28eb4f){return _0x28eb4f[_0x54eb('0x27')]()[_0x54eb('0x26')](function(){var _0x3018f6=_0x28eb4f['get']({'plain':!![]});var _0x470add='Projects';return db[_0x54eb('0x28')][_0x54eb('0x27')]({'where':{'type':_0x470add,'resourceId':_0x3018f6['id']}})[_0x54eb('0x26')](function(){return _0x28eb4f;});})[_0x54eb('0x26')](function(){_0x45c2c8[_0x54eb('0x1d')](0xcc)['end']();});}};}function handleEntityNotFound(_0x5c0955,_0x3a85e1){return function(_0x3689e8){if(!_0x3689e8){_0x5c0955[_0x54eb('0x29')](0x194);}return _0x3689e8;};}function handleError(_0x43f85b,_0x267f6d){_0x267f6d=_0x267f6d||0x1f4;return function(_0x1e934d){logger['error'](_0x1e934d[_0x54eb('0x2a')]);if(_0x1e934d[_0x54eb('0x2b')]){delete _0x1e934d[_0x54eb('0x2b')];}_0x43f85b[_0x54eb('0x1d')](_0x267f6d)[_0x54eb('0x2c')](_0x1e934d);};}exports[_0x54eb('0x2d')]=function(_0x1c875f,_0x7aa3d){var _0x4ca2fe={},_0xf041e8={},_0x4b81f4={'count':0x0,'rows':[]};var _0x2c7739=_[_0x54eb('0x2e')](db['JscriptyProject'][_0x54eb('0x2f')],function(_0x2c6919){return{'name':_0x2c6919[_0x54eb('0x30')],'type':_0x2c6919['type']['key']};});_0xf041e8[_0x54eb('0x31')]=_[_0x54eb('0x2e')](_0x2c7739,'name');_0xf041e8['query']=_[_0x54eb('0x32')](_0x1c875f[_0x54eb('0x33')]);_0xf041e8['filters']=_[_0x54eb('0x34')](_0xf041e8[_0x54eb('0x31')],_0xf041e8[_0x54eb('0x33')]);_0x4ca2fe[_0x54eb('0x35')]=_[_0x54eb('0x34')](_0xf041e8[_0x54eb('0x31')],qs[_0x54eb('0x36')](_0x1c875f[_0x54eb('0x33')]['fields']));_0x4ca2fe[_0x54eb('0x35')]=_0x4ca2fe['attributes']['length']?_0x4ca2fe['attributes']:_0xf041e8[_0x54eb('0x31')];if(!_0x1c875f[_0x54eb('0x33')]['hasOwnProperty'](_0x54eb('0x37'))){_0x4ca2fe[_0x54eb('0x21')]=qs[_0x54eb('0x21')](_0x1c875f[_0x54eb('0x33')][_0x54eb('0x21')]);_0x4ca2fe[_0x54eb('0x20')]=qs['offset'](_0x1c875f[_0x54eb('0x33')][_0x54eb('0x20')]);}_0x4ca2fe[_0x54eb('0x38')]=qs[_0x54eb('0x39')](_0x1c875f[_0x54eb('0x33')][_0x54eb('0x39')]);_0x4ca2fe['where']=qs[_0x54eb('0x3a')](_['pick'](_0x1c875f[_0x54eb('0x33')],_0xf041e8['filters']),_0x2c7739);if(_0x1c875f[_0x54eb('0x33')]['filter']){_0x4ca2fe[_0x54eb('0x3b')]=_[_0x54eb('0x3c')](_0x4ca2fe[_0x54eb('0x3b')],{'$or':_[_0x54eb('0x2e')](_0x2c7739,function(_0x4309c8){if(_0x4309c8[_0x54eb('0x3d')]!==_0x54eb('0x3e')){var _0x5f4724={};_0x5f4724[_0x4309c8[_0x54eb('0x2b')]]={'$like':'%'+_0x1c875f[_0x54eb('0x33')][_0x54eb('0x3f')]+'%'};return _0x5f4724;}})});}_0x4ca2fe=_[_0x54eb('0x3c')]({},_0x4ca2fe,_0x1c875f[_0x54eb('0x40')]);var _0x521810={'where':_0x4ca2fe['where']};return db[_0x54eb('0x41')][_0x54eb('0x22')](_0x521810)[_0x54eb('0x26')](function(_0x1b69ed){_0x4b81f4[_0x54eb('0x22')]=_0x1b69ed;if(_0x1c875f[_0x54eb('0x33')]['includeAll']){_0x4ca2fe[_0x54eb('0x42')]=[{'all':!![]}];}return db[_0x54eb('0x41')][_0x54eb('0x43')](_0x4ca2fe);})[_0x54eb('0x26')](function(_0x171610){_0x4b81f4[_0x54eb('0x44')]=_0x171610;return _0x4b81f4;})[_0x54eb('0x26')](respondWithFilteredResult(_0x7aa3d,_0x4ca2fe))[_0x54eb('0x45')](handleError(_0x7aa3d,null));};exports[_0x54eb('0x46')]=function(_0x1a1543,_0x5e3f91){var _0x1d1886={'raw':![],'where':{'id':_0x1a1543[_0x54eb('0x47')]['id']}},_0x4ff89f={};_0x4ff89f[_0x54eb('0x31')]=_[_0x54eb('0x32')](db[_0x54eb('0x41')][_0x54eb('0x2f')]);_0x4ff89f[_0x54eb('0x33')]=_[_0x54eb('0x32')](_0x1a1543[_0x54eb('0x33')]);_0x4ff89f[_0x54eb('0x3a')]=_[_0x54eb('0x34')](_0x4ff89f[_0x54eb('0x31')],_0x4ff89f[_0x54eb('0x33')]);_0x1d1886[_0x54eb('0x35')]=_[_0x54eb('0x34')](_0x4ff89f['model'],qs[_0x54eb('0x36')](_0x1a1543[_0x54eb('0x33')]['fields']));_0x1d1886['attributes']=_0x1d1886[_0x54eb('0x35')][_0x54eb('0x48')]?_0x1d1886[_0x54eb('0x35')]:_0x4ff89f['model'];if(_0x1a1543[_0x54eb('0x33')][_0x54eb('0x49')]){_0x1d1886[_0x54eb('0x42')]=[{'all':!![]}];}_0x1d1886=_[_0x54eb('0x3c')]({},_0x1d1886,_0x1a1543[_0x54eb('0x40')]);return db[_0x54eb('0x41')]['find'](_0x1d1886)[_0x54eb('0x26')](handleEntityNotFound(_0x5e3f91,null))['then'](respondWithResult(_0x5e3f91,null))[_0x54eb('0x45')](handleError(_0x5e3f91,null));};exports[_0x54eb('0x4a')]=function(_0x3c50ce,_0x100d3c){return db[_0x54eb('0x41')]['create'](_0x3c50ce['body'],{})[_0x54eb('0x26')](function(_0x1f3122){var _0xbb0b26=_0x3c50ce['user'][_0x54eb('0x4b')]({'plain':!![]});if(!_0xbb0b26)throw new Error(_0x54eb('0x4c'));if(_0xbb0b26[_0x54eb('0x4d')]===_0x54eb('0x4e')){var _0x32dbcf=_0x1f3122[_0x54eb('0x4b')]({'plain':!![]});var _0x5690ba='Projects';return db['UserProfileSection'][_0x54eb('0x4f')]({'where':{'name':_0x5690ba,'userProfileId':_0xbb0b26[_0x54eb('0x50')]},'raw':!![]})[_0x54eb('0x26')](function(_0x3751ce){if(_0x3751ce&&_0x3751ce[_0x54eb('0x51')]===0x0){return db[_0x54eb('0x28')][_0x54eb('0x4a')]({'name':_0x32dbcf['name'],'resourceId':_0x32dbcf['id'],'type':_0x3751ce[_0x54eb('0x2b')],'sectionId':_0x3751ce['id']},{})['then'](function(){return _0x1f3122;});}else{return _0x1f3122;}})['catch'](function(_0xf5dfb4){logger[_0x54eb('0x52')](_0x54eb('0x53'),_0xf5dfb4);throw _0xf5dfb4;});}return _0x1f3122;})['then'](respondWithResult(_0x100d3c,0xc9))[_0x54eb('0x45')](handleError(_0x100d3c,null));};exports[_0x54eb('0x54')]=function(_0x4e0dbc,_0x49841d){var _0x31042f={'where':{'id':_0x4e0dbc['params']['id']}},_0x14b1f2={};_0x14b1f2['model']=_[_0x54eb('0x32')](db[_0x54eb('0x41')][_0x54eb('0x2f')]);_0x31042f[_0x54eb('0x35')]=_[_0x54eb('0x34')](_0x14b1f2['model'],qs[_0x54eb('0x36')](_0x4e0dbc['query'][_0x54eb('0x36')]));_0x31042f['attributes']=_0x31042f[_0x54eb('0x35')]['length']?_0x31042f['attributes']:_0x14b1f2[_0x54eb('0x31')];if(_0x4e0dbc[_0x54eb('0x33')]['includeAll']){_0x31042f['include']=[{'all':!![]}];}_0x31042f=_['merge']({},_0x31042f,_0x4e0dbc[_0x54eb('0x40')]);return db[_0x54eb('0x41')]['find'](_0x31042f)[_0x54eb('0x26')](handleEntityNotFound(_0x49841d,null))[_0x54eb('0x26')](function(_0xe6d254){if(_0xe6d254){var _0x21f9fd=_0xe6d254[_0x54eb('0x4b')]({'plain':!![]});_0x21f9fd=qs[_0x54eb('0x55')](_0x21f9fd,['id',_0x54eb('0x56'),_0x54eb('0x57')]);_0x4e0dbc[_0x54eb('0x58')]=_[_0x54eb('0x55')](_0x4e0dbc[_0x54eb('0x58')],['id',_0x54eb('0x56'),_0x54eb('0x57')]);return db[_0x54eb('0x41')]['create'](_['merge'](_0x21f9fd,_0x4e0dbc[_0x54eb('0x58')]),{'include':_0x4e0dbc['query'][_0x54eb('0x49')]?[{'all':!![]}]:undefined})['then'](function(_0x1438a4){var _0x3457d8=_0x4e0dbc[_0x54eb('0x4e')][_0x54eb('0x4b')]({'plain':!![]});if(!_0x3457d8)throw new Error(_0x54eb('0x4c'));if(_0x3457d8['role']===_0x54eb('0x4e')){var _0x472617=_0x1438a4[_0x54eb('0x4b')]({'plain':!![]});var _0x5bec17=_0x54eb('0x59');return db[_0x54eb('0x5a')][_0x54eb('0x4f')]({'where':{'name':_0x5bec17,'userProfileId':_0x3457d8[_0x54eb('0x50')]},'raw':!![]})['then'](function(_0x1bfff1){if(_0x1bfff1&&_0x1bfff1['autoAssociation']===0x0){return db['UserProfileResource']['create']({'name':_0x472617[_0x54eb('0x2b')],'resourceId':_0x472617['id'],'type':_0x1bfff1['name'],'sectionId':_0x1bfff1['id']},{})[_0x54eb('0x26')](function(){return _0x1438a4;});}else{return _0x1438a4;}})[_0x54eb('0x45')](function(_0x40e750){logger[_0x54eb('0x52')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x40e750);throw _0x40e750;});}return _0x1438a4;});}})[_0x54eb('0x26')](respondWithResult(_0x49841d,0xc9))['catch'](handleError(_0x49841d,null));};exports[_0x54eb('0x25')]=function(_0x12c0a9,_0xa11860){if(_0x12c0a9[_0x54eb('0x58')]['id']){delete _0x12c0a9[_0x54eb('0x58')]['id'];}return db[_0x54eb('0x41')][_0x54eb('0x4f')]({'where':{'id':_0x12c0a9[_0x54eb('0x47')]['id']}})['then'](handleEntityNotFound(_0xa11860,null))[_0x54eb('0x26')](saveUpdates(_0x12c0a9['body'],null))['then'](respondWithResult(_0xa11860,null))[_0x54eb('0x45')](handleError(_0xa11860,null));};exports[_0x54eb('0x27')]=function(_0x2b49b1,_0x2712c2){return db[_0x54eb('0x41')][_0x54eb('0x4f')]({'where':{'id':_0x2b49b1[_0x54eb('0x47')]['id']}})[_0x54eb('0x26')](handleEntityNotFound(_0x2712c2,null))[_0x54eb('0x26')](removeEntity(_0x2712c2,null))[_0x54eb('0x45')](handleError(_0x2712c2,null));};exports[_0x54eb('0x5b')]=function(_0xfe3063,_0x356180,_0x252f47){var _0x32d6b6={'raw':!![],'where':{}};var _0x1dd66b={};var _0x34fbc9={'count':0x0,'rows':[]};return db[_0x54eb('0x41')]['findOne']({'where':{'id':_0xfe3063[_0x54eb('0x47')]['id']}})[_0x54eb('0x26')](handleEntityNotFound(_0x356180,null))['then'](function(_0x6d3c96){if(_0x6d3c96){_0x1dd66b[_0x54eb('0x31')]=_[_0x54eb('0x32')](db[_0x54eb('0x5c')][_0x54eb('0x2f')]);_0x1dd66b[_0x54eb('0x33')]=_[_0x54eb('0x32')](_0xfe3063[_0x54eb('0x33')]);_0x1dd66b[_0x54eb('0x3a')]=_[_0x54eb('0x34')](_0x1dd66b[_0x54eb('0x31')],_0x1dd66b[_0x54eb('0x33')]);_0x32d6b6[_0x54eb('0x35')]=_['intersection'](_0x1dd66b[_0x54eb('0x31')],qs[_0x54eb('0x36')](_0xfe3063[_0x54eb('0x33')][_0x54eb('0x36')]));_0x32d6b6[_0x54eb('0x35')]=_0x32d6b6['attributes'][_0x54eb('0x48')]?_0x32d6b6[_0x54eb('0x35')]:_0x1dd66b[_0x54eb('0x31')];if(!_0xfe3063[_0x54eb('0x33')]['hasOwnProperty'](_0x54eb('0x37'))){_0x32d6b6['limit']=qs[_0x54eb('0x21')](_0xfe3063[_0x54eb('0x33')][_0x54eb('0x21')]);_0x32d6b6[_0x54eb('0x20')]=qs['offset'](_0xfe3063[_0x54eb('0x33')]['offset']);}_0x32d6b6[_0x54eb('0x38')]=qs['sort'](_0xfe3063['query'][_0x54eb('0x39')]);_0x32d6b6[_0x54eb('0x3b')]=qs[_0x54eb('0x3a')](_[_0x54eb('0x5d')](_0xfe3063[_0x54eb('0x33')],_0x1dd66b[_0x54eb('0x3a')]));_0x32d6b6[_0x54eb('0x3b')][_0x54eb('0x5e')]=_0x6d3c96['id'];if(_0xfe3063[_0x54eb('0x33')][_0x54eb('0x3f')]){_0x32d6b6[_0x54eb('0x3b')]=_['merge'](_0x32d6b6['where'],{'$or':_[_0x54eb('0x2e')](_0x32d6b6[_0x54eb('0x35')],function(_0x4833ac){var _0x45047c={};_0x45047c[_0x4833ac]={'$like':'%'+_0xfe3063[_0x54eb('0x33')]['filter']+'%'};return _0x45047c;})});}_0x32d6b6=_['merge']({},_0x32d6b6,_0xfe3063[_0x54eb('0x40')]);return db['JscriptySessionReport'][_0x54eb('0x22')]({'where':_0x32d6b6[_0x54eb('0x3b')]})[_0x54eb('0x26')](function(_0x1fdb81){_0x34fbc9['count']=_0x1fdb81;if(_0xfe3063[_0x54eb('0x33')][_0x54eb('0x49')]){_0x32d6b6[_0x54eb('0x42')]=[{'all':!![]}];}return db[_0x54eb('0x5c')][_0x54eb('0x43')](_0x32d6b6);})['then'](function(_0x34d4df){_0x34fbc9['rows']=_0x34d4df;return _0x34fbc9;});}})[_0x54eb('0x26')](respondWithFilteredResult(_0x356180,_0x32d6b6))['catch'](handleError(_0x356180,null));};exports[_0x54eb('0x5f')]=function(_0x102d76,_0x10aee1,_0x7a79e5){var _0x36e879={'raw':!![],'where':{}};var _0x19bbd5={};var _0x1e59e4={'count':0x0,'rows':[]};return db['JscriptyProject'][_0x54eb('0x60')]({'where':{'id':_0x102d76[_0x54eb('0x47')]['id']}})[_0x54eb('0x26')](handleEntityNotFound(_0x10aee1,null))['then'](function(_0x3a33cd){if(_0x3a33cd){_0x19bbd5[_0x54eb('0x31')]=_['keys'](db[_0x54eb('0x61')][_0x54eb('0x2f')]);_0x19bbd5[_0x54eb('0x33')]=_[_0x54eb('0x32')](_0x102d76['query']);_0x19bbd5[_0x54eb('0x3a')]=_[_0x54eb('0x34')](_0x19bbd5['model'],_0x19bbd5[_0x54eb('0x33')]);_0x36e879['attributes']=_[_0x54eb('0x34')](_0x19bbd5[_0x54eb('0x31')],qs['fields'](_0x102d76[_0x54eb('0x33')][_0x54eb('0x36')]));_0x36e879[_0x54eb('0x35')]=_0x36e879['attributes'][_0x54eb('0x48')]?_0x36e879[_0x54eb('0x35')]:_0x19bbd5[_0x54eb('0x31')];if(!_0x102d76['query'][_0x54eb('0x62')](_0x54eb('0x37'))){_0x36e879[_0x54eb('0x21')]=qs[_0x54eb('0x21')](_0x102d76[_0x54eb('0x33')][_0x54eb('0x21')]);_0x36e879[_0x54eb('0x20')]=qs[_0x54eb('0x20')](_0x102d76[_0x54eb('0x33')]['offset']);}_0x36e879[_0x54eb('0x38')]=qs[_0x54eb('0x39')](_0x102d76[_0x54eb('0x33')]['sort']);_0x36e879[_0x54eb('0x3b')]=qs['filters'](_['pick'](_0x102d76[_0x54eb('0x33')],_0x19bbd5[_0x54eb('0x3a')]));_0x36e879[_0x54eb('0x3b')][_0x54eb('0x5e')]=_0x3a33cd['id'];if(_0x102d76[_0x54eb('0x33')][_0x54eb('0x3f')]){_0x36e879['where']=_[_0x54eb('0x3c')](_0x36e879['where'],{'$or':_[_0x54eb('0x2e')](_0x36e879['attributes'],function(_0x4cea51){var _0x3b391e={};_0x3b391e[_0x4cea51]={'$like':'%'+_0x102d76[_0x54eb('0x33')][_0x54eb('0x3f')]+'%'};return _0x3b391e;})});}_0x36e879=_[_0x54eb('0x3c')]({},_0x36e879,_0x102d76[_0x54eb('0x40')]);return db[_0x54eb('0x61')][_0x54eb('0x22')]({'where':_0x36e879['where']})[_0x54eb('0x26')](function(_0x128d08){_0x1e59e4[_0x54eb('0x22')]=_0x128d08;if(_0x102d76[_0x54eb('0x33')][_0x54eb('0x49')]){_0x36e879[_0x54eb('0x42')]=[{'all':!![]}];}return db[_0x54eb('0x61')][_0x54eb('0x43')](_0x36e879);})[_0x54eb('0x26')](function(_0x12cf3a){_0x1e59e4[_0x54eb('0x44')]=_0x12cf3a;return _0x1e59e4;});}})['then'](respondWithFilteredResult(_0x10aee1,_0x36e879))[_0x54eb('0x45')](handleError(_0x10aee1,null));};function char(_0x883b99){return _0x54eb('0x63')===typeof _0x883b99?String[_0x54eb('0x64')]['apply'](null,arguments):_0x883b99;}function needsEncapsulation(_0x296ae4){return!!_0x296ae4&&(_0x296ae4[_0x54eb('0x65')]()['indexOf'](char(0xd))>=0x0||_0x296ae4[_0x54eb('0x65')]()[_0x54eb('0x66')](char(0xa))>=0x0||_0x296ae4[_0x54eb('0x65')]()[_0x54eb('0x66')](char(0x2c))>=0x0||_0x296ae4['toString']()['indexOf'](char(0x22))>=0x0);}function encapsulate(_0x5cd82c){var _0x3bac0c=char(0x22),_0x340946='\x5c'+char(0x22),_0x563b33=_0x5cd82c[_0x54eb('0x65')]()['replace'](new RegExp(_0x3bac0c,'g'),_0x340946);return _0x3bac0c+_0x563b33+_0x3bac0c;}exports['getSummary']=function(_0x2d0374,_0x2b0e6f,_0x42d85a){var _0x2e61ff,_0x2dde3f;var _0x421829={'where':{'ProjectId':_0x2d0374[_0x54eb('0x47')]['id']}};if(_0x2d0374[_0x54eb('0x33')]['startTime']){_0x421829['where'][_0x54eb('0x67')]=JSON['parse'](_0x2d0374['query']['startTime']);}return db[_0x54eb('0x5c')][_0x54eb('0x43')](_0x421829)[_0x54eb('0x26')](handleEntityNotFound(_0x2b0e6f,null))[_0x54eb('0x26')](function(_0x55cd17){if(_0x55cd17){_0x2e61ff=_0x55cd17;return db[_0x54eb('0x68')][_0x54eb('0x43')]({'where':{'SessionId':{'$in':_[_0x54eb('0x2e')](_0x2e61ff,'id')},'ProjectId':_0x2d0374[_0x54eb('0x47')]['id']},'order':_0x54eb('0x69')});}})[_0x54eb('0x26')](handleEntityNotFound(_0x2b0e6f,null))[_0x54eb('0x26')](function(_0x8e4eae){if(_0x8e4eae){_0x2dde3f=_0x8e4eae;var _0x5a3dbd={};for(var _0x430d59=0x0,_0x26b1e6=_0x2dde3f['length'];_0x430d59<_0x26b1e6;_0x430d59++){if(!_0x5a3dbd[_0x54eb('0x62')](_0x2dde3f[_0x430d59][_0x54eb('0x6a')])){_0x5a3dbd[_0x2dde3f[_0x430d59]['questionId']]=needsEncapsulation(_0x2dde3f[_0x430d59][_0x54eb('0x6b')])?encapsulate(_0x2dde3f[_0x430d59][_0x54eb('0x6b')]):_0x2dde3f[_0x430d59][_0x54eb('0x6b')];}}var _0x3b194f=[],_0x175890={};for(var _0x26548f=0x0,_0x168325=_0x2e61ff[_0x54eb('0x48')];_0x26548f<_0x168325;_0x26548f++){_0x175890={'ProjectId':_0x2d0374[_0x54eb('0x47')]['id'],'SessionId':_0x2e61ff[_0x26548f]['id'],'StartTime':moment(_0x2e61ff[_0x26548f][_0x54eb('0x67')])['format'](_0x54eb('0x6c'))};for(var _0x24a7c4=0x0,_0x5b3dc6=_0x2dde3f[_0x54eb('0x48')];_0x24a7c4<_0x5b3dc6;_0x24a7c4++){if(_0x2dde3f[_0x24a7c4][_0x54eb('0x6d')]==_0x2e61ff[_0x26548f]['id']&&_0x5a3dbd[_0x54eb('0x62')](_0x2dde3f[_0x24a7c4]['questionId'])){_0x175890[_0x5a3dbd[_0x2dde3f[_0x24a7c4][_0x54eb('0x6a')]]]=_0x2dde3f[_0x24a7c4][_0x54eb('0x6e')];}}for(var _0xca7924 in _0x5a3dbd){if(!_0x175890[_0x54eb('0x62')](_0x5a3dbd[_0xca7924])){_0x175890[_0x5a3dbd[_0xca7924]]=null;}}_0x3b194f[_0x54eb('0x6f')](_0x175890);}return _0x3b194f;}})['then'](function(_0x205693){if(!_['isEmpty'](_0x205693)){var _0x10abc4=toCsv(_0x205693);var _0x57adb6=Date[_0x54eb('0x70')]();fs[_0x54eb('0x71')](util[_0x54eb('0x72')](_0x54eb('0x73'),_0x2d0374['params']['id'],_0x57adb6),_0x10abc4);_0x2b0e6f[_0x54eb('0x74')]('Content-disposition',_0x54eb('0x75')+util[_0x54eb('0x72')](_0x54eb('0x76'),_0x2d0374['params']['id'],_0x57adb6));_0x2b0e6f['setHeader'](_0x54eb('0x77'),_0x54eb('0x78'));return _0x2b0e6f[_0x54eb('0x79')](util['format']('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x2d0374[_0x54eb('0x47')]['id'],_0x57adb6));}else{return _0x2b0e6f[_0x54eb('0x29')](0xcc);}})[_0x54eb('0x45')](handleError(_0x2b0e6f,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff