// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x52de=['hasOwnProperty','number','apply','toString','indexOf','replace','getSummary','startTime','starttime','parse','JscriptyQuestionReport','questionId','question','YYYY-MM-DD\x20HH:mm:ss','answer','push','isEmpty','now','writeFileSync','format','setHeader','Content-disposition','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','Content-type','download','/tmp/Jscripty_Project_%d_Summary_%s.csv','html-pdf','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','path','sox','to-csv','ejs','jsforce','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','count','offset','set','Content-Range','reject','save','update','then','error','stack','name','send','map','JscriptyProject','rawAttributes','fieldName','key','model','query','keys','filters','intersection','fields','attributes','length','limit','sort','where','pick','filter','VIRTUAL','merge','options','includeAll','findAll','rows','params','include','find','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Projects','userProfileId','autoAssociation','create','catch','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','updatedAt','omit','createdAt','UserProfileSection','UserProfileResource','findOne','JscriptySessionReport','order','ProjectId','getAnswers','JscriptyAnswerReport'];(function(_0x19950b,_0x53d0d7){var _0x3c6b41=function(_0x3924ad){while(--_0x3924ad){_0x19950b['push'](_0x19950b['shift']());}};_0x3c6b41(++_0x53d0d7);}(_0x52de,0x1e7));var _0xe52d=function(_0x321bb2,_0x202794){_0x321bb2=_0x321bb2-0x0;var _0x9c12ed=_0x52de[_0x321bb2];return _0x9c12ed;};'use strict';var pdf=require(_0xe52d('0x0'));var emlformat=require('eml-format');var rimraf=require(_0xe52d('0x1'));var zipdir=require(_0xe52d('0x2'));var jsonpatch=require(_0xe52d('0x3'));var rp=require(_0xe52d('0x4'));var moment=require('moment');var BPromise=require(_0xe52d('0x5'));var Mustache=require(_0xe52d('0x6'));var util=require(_0xe52d('0x7'));var path=require(_0xe52d('0x8'));var sox=require(_0xe52d('0x9'));var csv=require(_0xe52d('0xa'));var ejs=require(_0xe52d('0xb'));var fs=require('fs');var _=require('lodash');var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0xe52d('0xc'));var deskjs=require('desk.js');var toCsv=require(_0xe52d('0xa'));var querystring=require(_0xe52d('0xd'));var Papa=require('papaparse');var Redis=require(_0xe52d('0xe'));var authService=require(_0xe52d('0xf'));var qs=require(_0xe52d('0x10'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0xe52d('0x11'))(_0xe52d('0x12'));var utils=require('../../config/utils');var config=require(_0xe52d('0x13'));var licenseUtil=require(_0xe52d('0x14'));var db=require(_0xe52d('0x15'))['db'];function respondWithStatusCode(_0x4b7996,_0x593041){_0x593041=_0x593041||0xcc;return function(_0x5e5081){if(_0x5e5081){return _0x4b7996[_0xe52d('0x16')](_0x593041);}return _0x4b7996[_0xe52d('0x17')](_0x593041)[_0xe52d('0x18')]();};}function respondWithResult(_0x193b75,_0x2bbf72){_0x2bbf72=_0x2bbf72||0xc8;return function(_0x5aea25){if(_0x5aea25){return _0x193b75[_0xe52d('0x17')](_0x2bbf72)[_0xe52d('0x19')](_0x5aea25);}};}function respondWithFilteredResult(_0x3528e5,_0x33a2a7){return function(_0x3c7374){if(_0x3c7374){var _0x30dc5d=_0x3c7374[_0xe52d('0x1a')],_0x4ec9fd=_0x33a2a7[_0xe52d('0x1b')],_0x4d93cb=_0x33a2a7[_0xe52d('0x1b')]+_0x33a2a7['limit'],_0x3a8375;if(_0x4d93cb>=_0x30dc5d){_0x4d93cb=_0x30dc5d;_0x3a8375=0xc8;}else{_0x3a8375=0xce;}_0x3528e5['status'](_0x3a8375);return _0x3528e5[_0xe52d('0x1c')](_0xe52d('0x1d'),_0x4ec9fd+'-'+_0x4d93cb+'/'+_0x30dc5d)[_0xe52d('0x19')](_0x3c7374);}return null;};}function patchUpdates(_0xed15a7){return function(_0x344b0c){try{jsonpatch['apply'](_0x344b0c,_0xed15a7,!![]);}catch(_0xb39682){return BPromise[_0xe52d('0x1e')](_0xb39682);}return _0x344b0c[_0xe52d('0x1f')]();};}function saveUpdates(_0x566cb0,_0x267390){return function(_0x5bdba5){if(_0x5bdba5){return _0x5bdba5[_0xe52d('0x20')](_0x566cb0)[_0xe52d('0x21')](function(_0x26a073){return _0x26a073;});}return null;};}function removeEntity(_0x436d30,_0x4491a4){return function(_0x4bf5a8){if(_0x4bf5a8){return _0x4bf5a8['destroy']()[_0xe52d('0x21')](function(){var _0x3e0e4d=_0x4bf5a8['get']({'plain':!![]});var _0x567326='Projects';return db['UserProfileResource']['destroy']({'where':{'type':_0x567326,'resourceId':_0x3e0e4d['id']}})['then'](function(){return _0x4bf5a8;});})[_0xe52d('0x21')](function(){_0x436d30[_0xe52d('0x17')](0xcc)[_0xe52d('0x18')]();});}};}function handleEntityNotFound(_0x5f1291,_0x260fa8){return function(_0x4c28ca){if(!_0x4c28ca){_0x5f1291[_0xe52d('0x16')](0x194);}return _0x4c28ca;};}function handleError(_0x231112,_0x35f3da){_0x35f3da=_0x35f3da||0x1f4;return function(_0x3243e6){logger[_0xe52d('0x22')](_0x3243e6[_0xe52d('0x23')]);if(_0x3243e6['name']){delete _0x3243e6[_0xe52d('0x24')];}_0x231112[_0xe52d('0x17')](_0x35f3da)[_0xe52d('0x25')](_0x3243e6);};}exports['index']=function(_0xdb86ea,_0x124708){var _0xf5f68d={},_0x33e86c={},_0x26ad04={'count':0x0,'rows':[]};var _0x332b5e=_[_0xe52d('0x26')](db[_0xe52d('0x27')][_0xe52d('0x28')],function(_0x3e03d3){return{'name':_0x3e03d3[_0xe52d('0x29')],'type':_0x3e03d3['type'][_0xe52d('0x2a')]};});_0x33e86c[_0xe52d('0x2b')]=_['map'](_0x332b5e,_0xe52d('0x24'));_0x33e86c[_0xe52d('0x2c')]=_[_0xe52d('0x2d')](_0xdb86ea[_0xe52d('0x2c')]);_0x33e86c[_0xe52d('0x2e')]=_[_0xe52d('0x2f')](_0x33e86c[_0xe52d('0x2b')],_0x33e86c['query']);_0xf5f68d['attributes']=_[_0xe52d('0x2f')](_0x33e86c[_0xe52d('0x2b')],qs[_0xe52d('0x30')](_0xdb86ea[_0xe52d('0x2c')][_0xe52d('0x30')]));_0xf5f68d[_0xe52d('0x31')]=_0xf5f68d[_0xe52d('0x31')][_0xe52d('0x32')]?_0xf5f68d[_0xe52d('0x31')]:_0x33e86c[_0xe52d('0x2b')];if(!_0xdb86ea['query']['hasOwnProperty']('nolimit')){_0xf5f68d['limit']=qs[_0xe52d('0x33')](_0xdb86ea[_0xe52d('0x2c')][_0xe52d('0x33')]);_0xf5f68d['offset']=qs[_0xe52d('0x1b')](_0xdb86ea[_0xe52d('0x2c')][_0xe52d('0x1b')]);}_0xf5f68d['order']=qs['sort'](_0xdb86ea['query'][_0xe52d('0x34')]);_0xf5f68d[_0xe52d('0x35')]=qs[_0xe52d('0x2e')](_[_0xe52d('0x36')](_0xdb86ea['query'],_0x33e86c[_0xe52d('0x2e')]),_0x332b5e);if(_0xdb86ea['query'][_0xe52d('0x37')]){_0xf5f68d['where']=_['merge'](_0xf5f68d[_0xe52d('0x35')],{'$or':_['map'](_0x332b5e,function(_0x261b3b){if(_0x261b3b['type']!==_0xe52d('0x38')){var _0x32f5a3={};_0x32f5a3[_0x261b3b[_0xe52d('0x24')]]={'$like':'%'+_0xdb86ea['query'][_0xe52d('0x37')]+'%'};return _0x32f5a3;}})});}_0xf5f68d=_[_0xe52d('0x39')]({},_0xf5f68d,_0xdb86ea[_0xe52d('0x3a')]);var _0xcf63c7={'where':_0xf5f68d[_0xe52d('0x35')]};return db[_0xe52d('0x27')][_0xe52d('0x1a')](_0xcf63c7)['then'](function(_0x1ac32e){_0x26ad04['count']=_0x1ac32e;if(_0xdb86ea[_0xe52d('0x2c')][_0xe52d('0x3b')]){_0xf5f68d['include']=[{'all':!![]}];}return db[_0xe52d('0x27')][_0xe52d('0x3c')](_0xf5f68d);})[_0xe52d('0x21')](function(_0x16a94a){_0x26ad04[_0xe52d('0x3d')]=_0x16a94a;return _0x26ad04;})['then'](respondWithFilteredResult(_0x124708,_0xf5f68d))['catch'](handleError(_0x124708,null));};exports['show']=function(_0x51e1f3,_0x837664){var _0x3e17ff={'raw':![],'where':{'id':_0x51e1f3[_0xe52d('0x3e')]['id']}},_0x49bc25={};_0x49bc25['model']=_[_0xe52d('0x2d')](db['JscriptyProject']['rawAttributes']);_0x49bc25[_0xe52d('0x2c')]=_[_0xe52d('0x2d')](_0x51e1f3['query']);_0x49bc25['filters']=_[_0xe52d('0x2f')](_0x49bc25[_0xe52d('0x2b')],_0x49bc25['query']);_0x3e17ff['attributes']=_[_0xe52d('0x2f')](_0x49bc25['model'],qs[_0xe52d('0x30')](_0x51e1f3[_0xe52d('0x2c')]['fields']));_0x3e17ff[_0xe52d('0x31')]=_0x3e17ff[_0xe52d('0x31')][_0xe52d('0x32')]?_0x3e17ff['attributes']:_0x49bc25[_0xe52d('0x2b')];if(_0x51e1f3['query'][_0xe52d('0x3b')]){_0x3e17ff[_0xe52d('0x3f')]=[{'all':!![]}];}_0x3e17ff=_[_0xe52d('0x39')]({},_0x3e17ff,_0x51e1f3[_0xe52d('0x3a')]);return db[_0xe52d('0x27')][_0xe52d('0x40')](_0x3e17ff)[_0xe52d('0x21')](handleEntityNotFound(_0x837664,null))[_0xe52d('0x21')](respondWithResult(_0x837664,null))['catch'](handleError(_0x837664,null));};exports['create']=function(_0x201048,_0x581893){return db[_0xe52d('0x27')]['create'](_0x201048[_0xe52d('0x41')],{})[_0xe52d('0x21')](function(_0x25ccf5){var _0x269088=_0x201048[_0xe52d('0x42')][_0xe52d('0x43')]({'plain':!![]});if(!_0x269088)throw new Error(_0xe52d('0x44'));if(_0x269088[_0xe52d('0x45')]===_0xe52d('0x42')){var _0x15f5ee=_0x25ccf5[_0xe52d('0x43')]({'plain':!![]});var _0x1b0b96=_0xe52d('0x46');return db['UserProfileSection'][_0xe52d('0x40')]({'where':{'name':_0x1b0b96,'userProfileId':_0x269088[_0xe52d('0x47')]},'raw':!![]})[_0xe52d('0x21')](function(_0x60d35){if(_0x60d35&&_0x60d35[_0xe52d('0x48')]===0x0){return db['UserProfileResource'][_0xe52d('0x49')]({'name':_0x15f5ee[_0xe52d('0x24')],'resourceId':_0x15f5ee['id'],'type':_0x60d35[_0xe52d('0x24')],'sectionId':_0x60d35['id']},{})[_0xe52d('0x21')](function(){return _0x25ccf5;});}else{return _0x25ccf5;}})[_0xe52d('0x4a')](function(_0x571776){logger[_0xe52d('0x22')](_0xe52d('0x4b'),_0x571776);throw _0x571776;});}return _0x25ccf5;})[_0xe52d('0x21')](respondWithResult(_0x581893,0xc9))[_0xe52d('0x4a')](handleError(_0x581893,null));};exports[_0xe52d('0x4c')]=function(_0x1c1228,_0x4160ce){var _0x2f8549={'where':{'id':_0x1c1228['params']['id']}},_0x4398bb={};_0x4398bb['model']=_[_0xe52d('0x2d')](db[_0xe52d('0x27')]['rawAttributes']);_0x2f8549[_0xe52d('0x31')]=_[_0xe52d('0x2f')](_0x4398bb[_0xe52d('0x2b')],qs['fields'](_0x1c1228['query'][_0xe52d('0x30')]));_0x2f8549[_0xe52d('0x31')]=_0x2f8549[_0xe52d('0x31')]['length']?_0x2f8549[_0xe52d('0x31')]:_0x4398bb[_0xe52d('0x2b')];if(_0x1c1228[_0xe52d('0x2c')][_0xe52d('0x3b')]){_0x2f8549[_0xe52d('0x3f')]=[{'all':!![]}];}_0x2f8549=_['merge']({},_0x2f8549,_0x1c1228[_0xe52d('0x3a')]);return db[_0xe52d('0x27')][_0xe52d('0x40')](_0x2f8549)[_0xe52d('0x21')](handleEntityNotFound(_0x4160ce,null))[_0xe52d('0x21')](function(_0x4fbb0b){if(_0x4fbb0b){var _0x3a6a05=_0x4fbb0b[_0xe52d('0x43')]({'plain':!![]});_0x3a6a05=qs['omit'](_0x3a6a05,['id','createdAt',_0xe52d('0x4d')]);_0x1c1228['body']=_[_0xe52d('0x4e')](_0x1c1228[_0xe52d('0x41')],['id',_0xe52d('0x4f'),_0xe52d('0x4d')]);return db[_0xe52d('0x27')][_0xe52d('0x49')](_[_0xe52d('0x39')](_0x3a6a05,_0x1c1228['body']),{'include':_0x1c1228[_0xe52d('0x2c')][_0xe52d('0x3b')]?[{'all':!![]}]:undefined})[_0xe52d('0x21')](function(_0x3e4f3){var _0x4796b7=_0x1c1228[_0xe52d('0x42')][_0xe52d('0x43')]({'plain':!![]});if(!_0x4796b7)throw new Error(_0xe52d('0x44'));if(_0x4796b7['role']==='user'){var _0x5547cb=_0x3e4f3['get']({'plain':!![]});var _0x4861c4=_0xe52d('0x46');return db[_0xe52d('0x50')][_0xe52d('0x40')]({'where':{'name':_0x4861c4,'userProfileId':_0x4796b7[_0xe52d('0x47')]},'raw':!![]})['then'](function(_0x4b18fb){if(_0x4b18fb&&_0x4b18fb[_0xe52d('0x48')]===0x0){return db[_0xe52d('0x51')][_0xe52d('0x49')]({'name':_0x5547cb[_0xe52d('0x24')],'resourceId':_0x5547cb['id'],'type':_0x4b18fb[_0xe52d('0x24')],'sectionId':_0x4b18fb['id']},{})[_0xe52d('0x21')](function(){return _0x3e4f3;});}else{return _0x3e4f3;}})[_0xe52d('0x4a')](function(_0x1a9833){logger['error'](_0xe52d('0x4b'),_0x1a9833);throw _0x1a9833;});}return _0x3e4f3;});}})[_0xe52d('0x21')](respondWithResult(_0x4160ce,0xc9))[_0xe52d('0x4a')](handleError(_0x4160ce,null));};exports[_0xe52d('0x20')]=function(_0xe78785,_0x3d624c){if(_0xe78785[_0xe52d('0x41')]['id']){delete _0xe78785[_0xe52d('0x41')]['id'];}return db[_0xe52d('0x27')][_0xe52d('0x40')]({'where':{'id':_0xe78785[_0xe52d('0x3e')]['id']}})[_0xe52d('0x21')](handleEntityNotFound(_0x3d624c,null))[_0xe52d('0x21')](saveUpdates(_0xe78785[_0xe52d('0x41')],null))[_0xe52d('0x21')](respondWithResult(_0x3d624c,null))['catch'](handleError(_0x3d624c,null));};exports['destroy']=function(_0x3e3e21,_0x21746a){return db[_0xe52d('0x27')][_0xe52d('0x40')]({'where':{'id':_0x3e3e21[_0xe52d('0x3e')]['id']}})[_0xe52d('0x21')](handleEntityNotFound(_0x21746a,null))[_0xe52d('0x21')](removeEntity(_0x21746a,null))[_0xe52d('0x4a')](handleError(_0x21746a,null));};exports['getSessions']=function(_0xe60e4a,_0x4d98a9,_0xc2d6a5){var _0x748ff5={'raw':!![],'where':{}};var _0x589959={};var _0x338639={'count':0x0,'rows':[]};return db['JscriptyProject'][_0xe52d('0x52')]({'where':{'id':_0xe60e4a[_0xe52d('0x3e')]['id']}})[_0xe52d('0x21')](handleEntityNotFound(_0x4d98a9,null))['then'](function(_0x34d420){if(_0x34d420){_0x589959[_0xe52d('0x2b')]=_['keys'](db[_0xe52d('0x53')]['rawAttributes']);_0x589959['query']=_[_0xe52d('0x2d')](_0xe60e4a[_0xe52d('0x2c')]);_0x589959[_0xe52d('0x2e')]=_[_0xe52d('0x2f')](_0x589959[_0xe52d('0x2b')],_0x589959[_0xe52d('0x2c')]);_0x748ff5['attributes']=_[_0xe52d('0x2f')](_0x589959[_0xe52d('0x2b')],qs['fields'](_0xe60e4a[_0xe52d('0x2c')][_0xe52d('0x30')]));_0x748ff5[_0xe52d('0x31')]=_0x748ff5[_0xe52d('0x31')]['length']?_0x748ff5[_0xe52d('0x31')]:_0x589959[_0xe52d('0x2b')];if(!_0xe60e4a['query']['hasOwnProperty']('nolimit')){_0x748ff5[_0xe52d('0x33')]=qs[_0xe52d('0x33')](_0xe60e4a[_0xe52d('0x2c')][_0xe52d('0x33')]);_0x748ff5[_0xe52d('0x1b')]=qs[_0xe52d('0x1b')](_0xe60e4a[_0xe52d('0x2c')]['offset']);}_0x748ff5[_0xe52d('0x54')]=qs['sort'](_0xe60e4a[_0xe52d('0x2c')][_0xe52d('0x34')]);_0x748ff5['where']=qs['filters'](_[_0xe52d('0x36')](_0xe60e4a[_0xe52d('0x2c')],_0x589959[_0xe52d('0x2e')]));_0x748ff5[_0xe52d('0x35')][_0xe52d('0x55')]=_0x34d420['id'];if(_0xe60e4a[_0xe52d('0x2c')][_0xe52d('0x37')]){_0x748ff5[_0xe52d('0x35')]=_[_0xe52d('0x39')](_0x748ff5[_0xe52d('0x35')],{'$or':_[_0xe52d('0x26')](_0x748ff5['attributes'],function(_0x171aa6){var _0x418605={};_0x418605[_0x171aa6]={'$like':'%'+_0xe60e4a[_0xe52d('0x2c')][_0xe52d('0x37')]+'%'};return _0x418605;})});}_0x748ff5=_[_0xe52d('0x39')]({},_0x748ff5,_0xe60e4a['options']);return db['JscriptySessionReport'][_0xe52d('0x1a')]({'where':_0x748ff5[_0xe52d('0x35')]})[_0xe52d('0x21')](function(_0x504d7a){_0x338639[_0xe52d('0x1a')]=_0x504d7a;if(_0xe60e4a['query'][_0xe52d('0x3b')]){_0x748ff5[_0xe52d('0x3f')]=[{'all':!![]}];}return db[_0xe52d('0x53')][_0xe52d('0x3c')](_0x748ff5);})[_0xe52d('0x21')](function(_0x416f7f){_0x338639['rows']=_0x416f7f;return _0x338639;});}})[_0xe52d('0x21')](respondWithFilteredResult(_0x4d98a9,_0x748ff5))['catch'](handleError(_0x4d98a9,null));};exports[_0xe52d('0x56')]=function(_0x109bf7,_0x368a0f,_0x412893){var _0x3221cd={'raw':!![],'where':{}};var _0x53aec7={};var _0x3bb267={'count':0x0,'rows':[]};return db[_0xe52d('0x27')][_0xe52d('0x52')]({'where':{'id':_0x109bf7[_0xe52d('0x3e')]['id']}})[_0xe52d('0x21')](handleEntityNotFound(_0x368a0f,null))['then'](function(_0x2b872a){if(_0x2b872a){_0x53aec7[_0xe52d('0x2b')]=_[_0xe52d('0x2d')](db[_0xe52d('0x57')][_0xe52d('0x28')]);_0x53aec7[_0xe52d('0x2c')]=_[_0xe52d('0x2d')](_0x109bf7['query']);_0x53aec7[_0xe52d('0x2e')]=_[_0xe52d('0x2f')](_0x53aec7[_0xe52d('0x2b')],_0x53aec7[_0xe52d('0x2c')]);_0x3221cd['attributes']=_['intersection'](_0x53aec7['model'],qs[_0xe52d('0x30')](_0x109bf7[_0xe52d('0x2c')]['fields']));_0x3221cd['attributes']=_0x3221cd[_0xe52d('0x31')][_0xe52d('0x32')]?_0x3221cd['attributes']:_0x53aec7[_0xe52d('0x2b')];if(!_0x109bf7[_0xe52d('0x2c')][_0xe52d('0x58')]('nolimit')){_0x3221cd[_0xe52d('0x33')]=qs['limit'](_0x109bf7[_0xe52d('0x2c')]['limit']);_0x3221cd[_0xe52d('0x1b')]=qs[_0xe52d('0x1b')](_0x109bf7[_0xe52d('0x2c')][_0xe52d('0x1b')]);}_0x3221cd['order']=qs[_0xe52d('0x34')](_0x109bf7[_0xe52d('0x2c')][_0xe52d('0x34')]);_0x3221cd['where']=qs['filters'](_[_0xe52d('0x36')](_0x109bf7['query'],_0x53aec7[_0xe52d('0x2e')]));_0x3221cd[_0xe52d('0x35')][_0xe52d('0x55')]=_0x2b872a['id'];if(_0x109bf7['query'][_0xe52d('0x37')]){_0x3221cd[_0xe52d('0x35')]=_[_0xe52d('0x39')](_0x3221cd[_0xe52d('0x35')],{'$or':_[_0xe52d('0x26')](_0x3221cd[_0xe52d('0x31')],function(_0x21b8b2){var _0x504fe6={};_0x504fe6[_0x21b8b2]={'$like':'%'+_0x109bf7[_0xe52d('0x2c')][_0xe52d('0x37')]+'%'};return _0x504fe6;})});}_0x3221cd=_[_0xe52d('0x39')]({},_0x3221cd,_0x109bf7[_0xe52d('0x3a')]);return db['JscriptyAnswerReport'][_0xe52d('0x1a')]({'where':_0x3221cd[_0xe52d('0x35')]})[_0xe52d('0x21')](function(_0x441320){_0x3bb267['count']=_0x441320;if(_0x109bf7[_0xe52d('0x2c')][_0xe52d('0x3b')]){_0x3221cd[_0xe52d('0x3f')]=[{'all':!![]}];}return db['JscriptyAnswerReport'][_0xe52d('0x3c')](_0x3221cd);})[_0xe52d('0x21')](function(_0x221e43){_0x3bb267[_0xe52d('0x3d')]=_0x221e43;return _0x3bb267;});}})[_0xe52d('0x21')](respondWithFilteredResult(_0x368a0f,_0x3221cd))[_0xe52d('0x4a')](handleError(_0x368a0f,null));};function char(_0x465938){return _0xe52d('0x59')===typeof _0x465938?String['fromCharCode'][_0xe52d('0x5a')](null,arguments):_0x465938;}function needsEncapsulation(_0x2ad57a){return!!_0x2ad57a&&(_0x2ad57a[_0xe52d('0x5b')]()['indexOf'](char(0xd))>=0x0||_0x2ad57a[_0xe52d('0x5b')]()[_0xe52d('0x5c')](char(0xa))>=0x0||_0x2ad57a[_0xe52d('0x5b')]()[_0xe52d('0x5c')](char(0x2c))>=0x0||_0x2ad57a['toString']()[_0xe52d('0x5c')](char(0x22))>=0x0);}function encapsulate(_0x483ebb){var _0x2278c2=char(0x22),_0x259f04='\x5c'+char(0x22),_0x47e3c2=_0x483ebb[_0xe52d('0x5b')]()[_0xe52d('0x5d')](new RegExp(_0x2278c2,'g'),_0x259f04);return _0x2278c2+_0x47e3c2+_0x2278c2;}exports[_0xe52d('0x5e')]=function(_0xc66489,_0x45d599,_0x329ba8){var _0x2eab7b,_0x7a6a8f;var _0x2aedc1={'where':{'ProjectId':_0xc66489['params']['id']}};if(_0xc66489[_0xe52d('0x2c')][_0xe52d('0x5f')]){_0x2aedc1[_0xe52d('0x35')][_0xe52d('0x60')]=JSON[_0xe52d('0x61')](_0xc66489['query'][_0xe52d('0x5f')]);}return db['JscriptySessionReport'][_0xe52d('0x3c')](_0x2aedc1)[_0xe52d('0x21')](handleEntityNotFound(_0x45d599,null))[_0xe52d('0x21')](function(_0x4ba0d8){if(_0x4ba0d8){_0x2eab7b=_0x4ba0d8;return db[_0xe52d('0x62')][_0xe52d('0x3c')]({'where':{'SessionId':{'$in':_[_0xe52d('0x26')](_0x2eab7b,'id')},'ProjectId':_0xc66489[_0xe52d('0x3e')]['id']},'order':'-createdAt'});}})[_0xe52d('0x21')](handleEntityNotFound(_0x45d599,null))['then'](function(_0x46534e){if(_0x46534e){_0x7a6a8f=_0x46534e;var _0x4de4cb={};for(var _0x1e55c2=0x0,_0x2f6194=_0x7a6a8f[_0xe52d('0x32')];_0x1e55c2<_0x2f6194;_0x1e55c2++){if(!_0x4de4cb[_0xe52d('0x58')](_0x7a6a8f[_0x1e55c2][_0xe52d('0x63')])){_0x4de4cb[_0x7a6a8f[_0x1e55c2][_0xe52d('0x63')]]=needsEncapsulation(_0x7a6a8f[_0x1e55c2][_0xe52d('0x64')])?encapsulate(_0x7a6a8f[_0x1e55c2][_0xe52d('0x64')]):_0x7a6a8f[_0x1e55c2][_0xe52d('0x64')];}}var _0x9ec816=[],_0x4331e9={};for(var _0x3454cf=0x0,_0x8aa48d=_0x2eab7b['length'];_0x3454cf<_0x8aa48d;_0x3454cf++){_0x4331e9={'ProjectId':_0xc66489[_0xe52d('0x3e')]['id'],'SessionId':_0x2eab7b[_0x3454cf]['id'],'StartTime':moment(_0x2eab7b[_0x3454cf][_0xe52d('0x60')])['format'](_0xe52d('0x65'))};for(var _0x20ac66=0x0,_0x5bc98e=_0x7a6a8f[_0xe52d('0x32')];_0x20ac66<_0x5bc98e;_0x20ac66++){if(_0x7a6a8f[_0x20ac66]['SessionId']==_0x2eab7b[_0x3454cf]['id']&&_0x4de4cb['hasOwnProperty'](_0x7a6a8f[_0x20ac66][_0xe52d('0x63')])){_0x4331e9[_0x4de4cb[_0x7a6a8f[_0x20ac66][_0xe52d('0x63')]]]=_0x7a6a8f[_0x20ac66][_0xe52d('0x66')];}}for(var _0xcff65c in _0x4de4cb){if(!_0x4331e9[_0xe52d('0x58')](_0x4de4cb[_0xcff65c])){_0x4331e9[_0x4de4cb[_0xcff65c]]=null;}}_0x9ec816[_0xe52d('0x67')](_0x4331e9);}return _0x9ec816;}})['then'](function(_0x29cab2){if(!_[_0xe52d('0x68')](_0x29cab2)){var _0xe1f7e=toCsv(_0x29cab2);var _0x36a078=Date[_0xe52d('0x69')]();fs[_0xe52d('0x6a')](util[_0xe52d('0x6b')]('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0xc66489[_0xe52d('0x3e')]['id'],_0x36a078),_0xe1f7e);_0x45d599[_0xe52d('0x6c')](_0xe52d('0x6d'),_0xe52d('0x6e')+util[_0xe52d('0x6b')](_0xe52d('0x6f'),_0xc66489[_0xe52d('0x3e')]['id'],_0x36a078));_0x45d599['setHeader'](_0xe52d('0x70'),'text/csv');return _0x45d599[_0xe52d('0x71')](util[_0xe52d('0x6b')](_0xe52d('0x72'),_0xc66489[_0xe52d('0x3e')]['id'],_0x36a078));}else{return _0x45d599['sendStatus'](0xcc);}})[_0xe52d('0x4a')](handleError(_0x45d599,null));};
\ No newline at end of file
+var _0x1e2c=['lodash','crypto','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','count','offset','limit','set','Content-Range','json','apply','save','update','then','get','Projects','UserProfileResource','destroy','error','name','index','map','JscriptyProject','rawAttributes','fieldName','model','keys','filters','intersection','query','fields','attributes','length','nolimit','order','sort','where','pick','filter','merge','type','options','findAll','rows','catch','show','includeAll','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','userProfileId','autoAssociation','clone','include','omit','createdAt','updatedAt','UserProfileSection','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','getSessions','findOne','hasOwnProperty','ProjectId','JscriptySessionReport','getAnswers','JscriptyAnswerReport','number','toString','indexOf','replace','getSummary','starttime','parse','JscriptyQuestionReport','-createdAt','questionId','question','format','SessionId','answer','push','now','/tmp/Jscripty_Project_%d_Summary_%s.csv','Content-disposition','attachment;\x20filename=','Content-type','download','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','ejs'];(function(_0x123dd0,_0x59473c){var _0x2df37f=function(_0x471ef0){while(--_0x471ef0){_0x123dd0['push'](_0x123dd0['shift']());}};_0x2df37f(++_0x59473c);}(_0x1e2c,0x69));var _0xc1e2=function(_0x2efae9,_0x36818d){_0x2efae9=_0x2efae9-0x0;var _0x585ffe=_0x1e2c[_0x2efae9];return _0x585ffe;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0xc1e2('0x0'));var rimraf=require(_0xc1e2('0x1'));var zipdir=require(_0xc1e2('0x2'));var jsonpatch=require(_0xc1e2('0x3'));var rp=require(_0xc1e2('0x4'));var moment=require(_0xc1e2('0x5'));var BPromise=require(_0xc1e2('0x6'));var Mustache=require(_0xc1e2('0x7'));var util=require(_0xc1e2('0x8'));var path=require(_0xc1e2('0x9'));var sox=require(_0xc1e2('0xa'));var csv=require('to-csv');var ejs=require(_0xc1e2('0xb'));var fs=require('fs');var _=require(_0xc1e2('0xc'));var squel=require('squel');var crypto=require(_0xc1e2('0xd'));var jsforce=require(_0xc1e2('0xe'));var deskjs=require(_0xc1e2('0xf'));var toCsv=require(_0xc1e2('0x10'));var querystring=require(_0xc1e2('0x11'));var Papa=require(_0xc1e2('0x12'));var Redis=require(_0xc1e2('0x13'));var authService=require(_0xc1e2('0x14'));var qs=require(_0xc1e2('0x15'));var as=require(_0xc1e2('0x16'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xc1e2('0x17'))('api');var utils=require(_0xc1e2('0x18'));var config=require(_0xc1e2('0x19'));var licenseUtil=require('../../config/license/util');var db=require(_0xc1e2('0x1a'))['db'];function respondWithStatusCode(_0xe8b660,_0x69c1ec){_0x69c1ec=_0x69c1ec||0xcc;return function(_0x2aba6a){if(_0x2aba6a){return _0xe8b660[_0xc1e2('0x1b')](_0x69c1ec);}return _0xe8b660[_0xc1e2('0x1c')](_0x69c1ec)[_0xc1e2('0x1d')]();};}function respondWithResult(_0x38f747,_0x5fa130){_0x5fa130=_0x5fa130||0xc8;return function(_0x26c1e8){if(_0x26c1e8){return _0x38f747['status'](_0x5fa130)['json'](_0x26c1e8);}};}function respondWithFilteredResult(_0x2f4b6a,_0xf61a4d){return function(_0x17c12c){if(_0x17c12c){var _0x551710=_0x17c12c[_0xc1e2('0x1e')],_0x3b833a=_0xf61a4d['offset'],_0xc36f1c=_0xf61a4d[_0xc1e2('0x1f')]+_0xf61a4d[_0xc1e2('0x20')],_0x2828ff;if(_0xc36f1c>=_0x551710){_0xc36f1c=_0x551710;_0x2828ff=0xc8;}else{_0x2828ff=0xce;}_0x2f4b6a[_0xc1e2('0x1c')](_0x2828ff);return _0x2f4b6a[_0xc1e2('0x21')](_0xc1e2('0x22'),_0x3b833a+'-'+_0xc36f1c+'/'+_0x551710)[_0xc1e2('0x23')](_0x17c12c);}return null;};}function patchUpdates(_0x37eab8){return function(_0x348b49){try{jsonpatch[_0xc1e2('0x24')](_0x348b49,_0x37eab8,!![]);}catch(_0x14b078){return BPromise['reject'](_0x14b078);}return _0x348b49[_0xc1e2('0x25')]();};}function saveUpdates(_0x4a3eaa,_0x11ae40){return function(_0x94ab43){if(_0x94ab43){return _0x94ab43[_0xc1e2('0x26')](_0x4a3eaa)['then'](function(_0x318434){return _0x318434;});}return null;};}function removeEntity(_0x3d7b22,_0x23b98d){return function(_0x53bb82){if(_0x53bb82){return _0x53bb82['destroy']()[_0xc1e2('0x27')](function(){var _0x8d0e5b=_0x53bb82[_0xc1e2('0x28')]({'plain':!![]});var _0x398bfc=_0xc1e2('0x29');return db[_0xc1e2('0x2a')][_0xc1e2('0x2b')]({'where':{'type':_0x398bfc,'resourceId':_0x8d0e5b['id']}})['then'](function(){return _0x53bb82;});})['then'](function(){_0x3d7b22[_0xc1e2('0x1c')](0xcc)[_0xc1e2('0x1d')]();});}};}function handleEntityNotFound(_0x1ff7b5,_0x26d4b1){return function(_0x465cbf){if(!_0x465cbf){_0x1ff7b5['sendStatus'](0x194);}return _0x465cbf;};}function handleError(_0x3ee3d4,_0x34afdb){_0x34afdb=_0x34afdb||0x1f4;return function(_0x30eb8a){logger[_0xc1e2('0x2c')](_0x30eb8a['stack']);if(_0x30eb8a[_0xc1e2('0x2d')]){delete _0x30eb8a[_0xc1e2('0x2d')];}_0x3ee3d4['status'](_0x34afdb)['send'](_0x30eb8a);};}exports[_0xc1e2('0x2e')]=function(_0x2e67b9,_0x31c626){var _0x177159={},_0x506bf4={},_0xf5c546={'count':0x0,'rows':[]};var _0x5211fd=_[_0xc1e2('0x2f')](db[_0xc1e2('0x30')][_0xc1e2('0x31')],function(_0x24c333){return{'name':_0x24c333[_0xc1e2('0x32')],'type':_0x24c333['type']['key']};});_0x506bf4[_0xc1e2('0x33')]=_['map'](_0x5211fd,'name');_0x506bf4['query']=_[_0xc1e2('0x34')](_0x2e67b9['query']);_0x506bf4[_0xc1e2('0x35')]=_[_0xc1e2('0x36')](_0x506bf4[_0xc1e2('0x33')],_0x506bf4[_0xc1e2('0x37')]);_0x177159['attributes']=_[_0xc1e2('0x36')](_0x506bf4[_0xc1e2('0x33')],qs[_0xc1e2('0x38')](_0x2e67b9['query'][_0xc1e2('0x38')]));_0x177159[_0xc1e2('0x39')]=_0x177159['attributes'][_0xc1e2('0x3a')]?_0x177159[_0xc1e2('0x39')]:_0x506bf4[_0xc1e2('0x33')];if(!_0x2e67b9[_0xc1e2('0x37')]['hasOwnProperty'](_0xc1e2('0x3b'))){_0x177159[_0xc1e2('0x20')]=qs[_0xc1e2('0x20')](_0x2e67b9[_0xc1e2('0x37')]['limit']);_0x177159[_0xc1e2('0x1f')]=qs[_0xc1e2('0x1f')](_0x2e67b9[_0xc1e2('0x37')][_0xc1e2('0x1f')]);}_0x177159[_0xc1e2('0x3c')]=qs[_0xc1e2('0x3d')](_0x2e67b9[_0xc1e2('0x37')][_0xc1e2('0x3d')]);_0x177159[_0xc1e2('0x3e')]=qs[_0xc1e2('0x35')](_[_0xc1e2('0x3f')](_0x2e67b9['query'],_0x506bf4[_0xc1e2('0x35')]),_0x5211fd);if(_0x2e67b9['query'][_0xc1e2('0x40')]){_0x177159[_0xc1e2('0x3e')]=_[_0xc1e2('0x41')](_0x177159[_0xc1e2('0x3e')],{'$or':_[_0xc1e2('0x2f')](_0x5211fd,function(_0x473688){if(_0x473688[_0xc1e2('0x42')]!=='VIRTUAL'){var _0x3f733a={};_0x3f733a[_0x473688[_0xc1e2('0x2d')]]={'$like':'%'+_0x2e67b9[_0xc1e2('0x37')][_0xc1e2('0x40')]+'%'};return _0x3f733a;}})});}_0x177159=_[_0xc1e2('0x41')]({},_0x177159,_0x2e67b9[_0xc1e2('0x43')]);var _0x5e3368={'where':_0x177159[_0xc1e2('0x3e')]};return db[_0xc1e2('0x30')][_0xc1e2('0x1e')](_0x5e3368)[_0xc1e2('0x27')](function(_0x1da7a4){_0xf5c546[_0xc1e2('0x1e')]=_0x1da7a4;if(_0x2e67b9[_0xc1e2('0x37')]['includeAll']){_0x177159['include']=[{'all':!![]}];}return db[_0xc1e2('0x30')][_0xc1e2('0x44')](_0x177159);})[_0xc1e2('0x27')](function(_0x4a0826){_0xf5c546[_0xc1e2('0x45')]=_0x4a0826;return _0xf5c546;})[_0xc1e2('0x27')](respondWithFilteredResult(_0x31c626,_0x177159))[_0xc1e2('0x46')](handleError(_0x31c626,null));};exports[_0xc1e2('0x47')]=function(_0x31dc46,_0xcd28d3){var _0x4035f1={'raw':![],'where':{'id':_0x31dc46['params']['id']}},_0x26a1bf={};_0x26a1bf[_0xc1e2('0x33')]=_[_0xc1e2('0x34')](db[_0xc1e2('0x30')][_0xc1e2('0x31')]);_0x26a1bf[_0xc1e2('0x37')]=_['keys'](_0x31dc46[_0xc1e2('0x37')]);_0x26a1bf[_0xc1e2('0x35')]=_['intersection'](_0x26a1bf[_0xc1e2('0x33')],_0x26a1bf['query']);_0x4035f1['attributes']=_[_0xc1e2('0x36')](_0x26a1bf['model'],qs[_0xc1e2('0x38')](_0x31dc46['query']['fields']));_0x4035f1[_0xc1e2('0x39')]=_0x4035f1[_0xc1e2('0x39')][_0xc1e2('0x3a')]?_0x4035f1[_0xc1e2('0x39')]:_0x26a1bf[_0xc1e2('0x33')];if(_0x31dc46[_0xc1e2('0x37')][_0xc1e2('0x48')]){_0x4035f1['include']=[{'all':!![]}];}_0x4035f1=_[_0xc1e2('0x41')]({},_0x4035f1,_0x31dc46['options']);return db['JscriptyProject'][_0xc1e2('0x49')](_0x4035f1)[_0xc1e2('0x27')](handleEntityNotFound(_0xcd28d3,null))[_0xc1e2('0x27')](respondWithResult(_0xcd28d3,null))[_0xc1e2('0x46')](handleError(_0xcd28d3,null));};exports[_0xc1e2('0x4a')]=function(_0x4800ee,_0x2eada6){return db['JscriptyProject'][_0xc1e2('0x4a')](_0x4800ee[_0xc1e2('0x4b')],{})[_0xc1e2('0x27')](function(_0x3fe7d6){var _0x4ed320=_0x4800ee[_0xc1e2('0x4c')][_0xc1e2('0x28')]({'plain':!![]});if(!_0x4ed320)throw new Error(_0xc1e2('0x4d'));if(_0x4ed320[_0xc1e2('0x4e')]===_0xc1e2('0x4c')){var _0x5930a8=_0x3fe7d6['get']({'plain':!![]});var _0x2d28c7='Projects';return db['UserProfileSection']['find']({'where':{'name':_0x2d28c7,'userProfileId':_0x4ed320[_0xc1e2('0x4f')]},'raw':!![]})[_0xc1e2('0x27')](function(_0x1ccf1e){if(_0x1ccf1e&&_0x1ccf1e[_0xc1e2('0x50')]===0x0){return db[_0xc1e2('0x2a')][_0xc1e2('0x4a')]({'name':_0x5930a8[_0xc1e2('0x2d')],'resourceId':_0x5930a8['id'],'type':_0x1ccf1e[_0xc1e2('0x2d')],'sectionId':_0x1ccf1e['id']},{})[_0xc1e2('0x27')](function(){return _0x3fe7d6;});}else{return _0x3fe7d6;}})[_0xc1e2('0x46')](function(_0x40282d){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x40282d);throw _0x40282d;});}return _0x3fe7d6;})[_0xc1e2('0x27')](respondWithResult(_0x2eada6,0xc9))[_0xc1e2('0x46')](handleError(_0x2eada6,null));};exports[_0xc1e2('0x51')]=function(_0x400807,_0x377b4d){var _0x267361={'where':{'id':_0x400807['params']['id']}},_0x39c4c8={};_0x39c4c8[_0xc1e2('0x33')]=_[_0xc1e2('0x34')](db[_0xc1e2('0x30')][_0xc1e2('0x31')]);_0x267361[_0xc1e2('0x39')]=_[_0xc1e2('0x36')](_0x39c4c8[_0xc1e2('0x33')],qs[_0xc1e2('0x38')](_0x400807[_0xc1e2('0x37')][_0xc1e2('0x38')]));_0x267361[_0xc1e2('0x39')]=_0x267361[_0xc1e2('0x39')][_0xc1e2('0x3a')]?_0x267361['attributes']:_0x39c4c8[_0xc1e2('0x33')];if(_0x400807[_0xc1e2('0x37')][_0xc1e2('0x48')]){_0x267361[_0xc1e2('0x52')]=[{'all':!![]}];}_0x267361=_[_0xc1e2('0x41')]({},_0x267361,_0x400807[_0xc1e2('0x43')]);return db[_0xc1e2('0x30')][_0xc1e2('0x49')](_0x267361)[_0xc1e2('0x27')](handleEntityNotFound(_0x377b4d,null))[_0xc1e2('0x27')](function(_0x59190d){if(_0x59190d){var _0x1f8609=_0x59190d[_0xc1e2('0x28')]({'plain':!![]});_0x1f8609=qs['omit'](_0x1f8609,['id','createdAt','updatedAt']);_0x400807[_0xc1e2('0x4b')]=_[_0xc1e2('0x53')](_0x400807['body'],['id',_0xc1e2('0x54'),_0xc1e2('0x55')]);return db['JscriptyProject'][_0xc1e2('0x4a')](_[_0xc1e2('0x41')](_0x1f8609,_0x400807['body']),{'include':_0x400807[_0xc1e2('0x37')][_0xc1e2('0x48')]?[{'all':!![]}]:undefined})['then'](function(_0x3c53c9){var _0x3b3696=_0x400807[_0xc1e2('0x4c')]['get']({'plain':!![]});if(!_0x3b3696)throw new Error(_0xc1e2('0x4d'));if(_0x3b3696[_0xc1e2('0x4e')]===_0xc1e2('0x4c')){var _0x5a68de=_0x3c53c9['get']({'plain':!![]});var _0x2595f0=_0xc1e2('0x29');return db[_0xc1e2('0x56')][_0xc1e2('0x49')]({'where':{'name':_0x2595f0,'userProfileId':_0x3b3696[_0xc1e2('0x4f')]},'raw':!![]})[_0xc1e2('0x27')](function(_0x5f8a59){if(_0x5f8a59&&_0x5f8a59[_0xc1e2('0x50')]===0x0){return db[_0xc1e2('0x2a')][_0xc1e2('0x4a')]({'name':_0x5a68de[_0xc1e2('0x2d')],'resourceId':_0x5a68de['id'],'type':_0x5f8a59[_0xc1e2('0x2d')],'sectionId':_0x5f8a59['id']},{})[_0xc1e2('0x27')](function(){return _0x3c53c9;});}else{return _0x3c53c9;}})['catch'](function(_0x19a992){logger[_0xc1e2('0x2c')](_0xc1e2('0x57'),_0x19a992);throw _0x19a992;});}return _0x3c53c9;});}})['then'](respondWithResult(_0x377b4d,0xc9))[_0xc1e2('0x46')](handleError(_0x377b4d,null));};exports['update']=function(_0x2792ff,_0x195680){if(_0x2792ff[_0xc1e2('0x4b')]['id']){delete _0x2792ff[_0xc1e2('0x4b')]['id'];}return db[_0xc1e2('0x30')][_0xc1e2('0x49')]({'where':{'id':_0x2792ff['params']['id']}})[_0xc1e2('0x27')](handleEntityNotFound(_0x195680,null))['then'](saveUpdates(_0x2792ff[_0xc1e2('0x4b')],null))[_0xc1e2('0x27')](respondWithResult(_0x195680,null))['catch'](handleError(_0x195680,null));};exports[_0xc1e2('0x2b')]=function(_0x794b76,_0x1800f9){return db['JscriptyProject'][_0xc1e2('0x49')]({'where':{'id':_0x794b76[_0xc1e2('0x58')]['id']}})[_0xc1e2('0x27')](handleEntityNotFound(_0x1800f9,null))[_0xc1e2('0x27')](removeEntity(_0x1800f9,null))[_0xc1e2('0x46')](handleError(_0x1800f9,null));};exports[_0xc1e2('0x59')]=function(_0x2538da,_0x45c152,_0x25dc61){var _0x2e0c52={'raw':!![],'where':{}};var _0x4d978f={};var _0x51a603={'count':0x0,'rows':[]};return db['JscriptyProject'][_0xc1e2('0x5a')]({'where':{'id':_0x2538da[_0xc1e2('0x58')]['id']}})['then'](handleEntityNotFound(_0x45c152,null))[_0xc1e2('0x27')](function(_0x5c4996){if(_0x5c4996){_0x4d978f[_0xc1e2('0x33')]=_[_0xc1e2('0x34')](db['JscriptySessionReport']['rawAttributes']);_0x4d978f[_0xc1e2('0x37')]=_[_0xc1e2('0x34')](_0x2538da[_0xc1e2('0x37')]);_0x4d978f[_0xc1e2('0x35')]=_[_0xc1e2('0x36')](_0x4d978f[_0xc1e2('0x33')],_0x4d978f[_0xc1e2('0x37')]);_0x2e0c52[_0xc1e2('0x39')]=_['intersection'](_0x4d978f[_0xc1e2('0x33')],qs[_0xc1e2('0x38')](_0x2538da[_0xc1e2('0x37')][_0xc1e2('0x38')]));_0x2e0c52[_0xc1e2('0x39')]=_0x2e0c52['attributes']['length']?_0x2e0c52['attributes']:_0x4d978f[_0xc1e2('0x33')];if(!_0x2538da[_0xc1e2('0x37')][_0xc1e2('0x5b')](_0xc1e2('0x3b'))){_0x2e0c52[_0xc1e2('0x20')]=qs['limit'](_0x2538da[_0xc1e2('0x37')][_0xc1e2('0x20')]);_0x2e0c52[_0xc1e2('0x1f')]=qs['offset'](_0x2538da[_0xc1e2('0x37')]['offset']);}_0x2e0c52[_0xc1e2('0x3c')]=qs['sort'](_0x2538da[_0xc1e2('0x37')][_0xc1e2('0x3d')]);_0x2e0c52[_0xc1e2('0x3e')]=qs[_0xc1e2('0x35')](_['pick'](_0x2538da[_0xc1e2('0x37')],_0x4d978f[_0xc1e2('0x35')]));_0x2e0c52[_0xc1e2('0x3e')][_0xc1e2('0x5c')]=_0x5c4996['id'];if(_0x2538da[_0xc1e2('0x37')]['filter']){_0x2e0c52[_0xc1e2('0x3e')]=_[_0xc1e2('0x41')](_0x2e0c52[_0xc1e2('0x3e')],{'$or':_['map'](_0x2e0c52[_0xc1e2('0x39')],function(_0x218150){var _0x5ac124={};_0x5ac124[_0x218150]={'$like':'%'+_0x2538da[_0xc1e2('0x37')]['filter']+'%'};return _0x5ac124;})});}_0x2e0c52=_[_0xc1e2('0x41')]({},_0x2e0c52,_0x2538da['options']);return db[_0xc1e2('0x5d')]['count']({'where':_0x2e0c52['where']})[_0xc1e2('0x27')](function(_0x5723a1){_0x51a603['count']=_0x5723a1;if(_0x2538da[_0xc1e2('0x37')][_0xc1e2('0x48')]){_0x2e0c52[_0xc1e2('0x52')]=[{'all':!![]}];}return db[_0xc1e2('0x5d')][_0xc1e2('0x44')](_0x2e0c52);})[_0xc1e2('0x27')](function(_0x3c9eeb){_0x51a603[_0xc1e2('0x45')]=_0x3c9eeb;return _0x51a603;});}})[_0xc1e2('0x27')](respondWithFilteredResult(_0x45c152,_0x2e0c52))['catch'](handleError(_0x45c152,null));};exports[_0xc1e2('0x5e')]=function(_0x1843e2,_0x36ac09,_0xd87dc4){var _0x3ffde4={'raw':!![],'where':{}};var _0x360e0a={};var _0x4f2cc8={'count':0x0,'rows':[]};return db[_0xc1e2('0x30')]['findOne']({'where':{'id':_0x1843e2[_0xc1e2('0x58')]['id']}})[_0xc1e2('0x27')](handleEntityNotFound(_0x36ac09,null))[_0xc1e2('0x27')](function(_0x18b9dd){if(_0x18b9dd){_0x360e0a[_0xc1e2('0x33')]=_[_0xc1e2('0x34')](db['JscriptyAnswerReport']['rawAttributes']);_0x360e0a[_0xc1e2('0x37')]=_[_0xc1e2('0x34')](_0x1843e2[_0xc1e2('0x37')]);_0x360e0a[_0xc1e2('0x35')]=_['intersection'](_0x360e0a[_0xc1e2('0x33')],_0x360e0a[_0xc1e2('0x37')]);_0x3ffde4['attributes']=_[_0xc1e2('0x36')](_0x360e0a[_0xc1e2('0x33')],qs[_0xc1e2('0x38')](_0x1843e2[_0xc1e2('0x37')]['fields']));_0x3ffde4['attributes']=_0x3ffde4[_0xc1e2('0x39')][_0xc1e2('0x3a')]?_0x3ffde4[_0xc1e2('0x39')]:_0x360e0a[_0xc1e2('0x33')];if(!_0x1843e2[_0xc1e2('0x37')][_0xc1e2('0x5b')](_0xc1e2('0x3b'))){_0x3ffde4[_0xc1e2('0x20')]=qs[_0xc1e2('0x20')](_0x1843e2[_0xc1e2('0x37')]['limit']);_0x3ffde4['offset']=qs['offset'](_0x1843e2['query'][_0xc1e2('0x1f')]);}_0x3ffde4[_0xc1e2('0x3c')]=qs[_0xc1e2('0x3d')](_0x1843e2['query']['sort']);_0x3ffde4[_0xc1e2('0x3e')]=qs[_0xc1e2('0x35')](_['pick'](_0x1843e2[_0xc1e2('0x37')],_0x360e0a['filters']));_0x3ffde4['where'][_0xc1e2('0x5c')]=_0x18b9dd['id'];if(_0x1843e2[_0xc1e2('0x37')][_0xc1e2('0x40')]){_0x3ffde4[_0xc1e2('0x3e')]=_['merge'](_0x3ffde4[_0xc1e2('0x3e')],{'$or':_[_0xc1e2('0x2f')](_0x3ffde4[_0xc1e2('0x39')],function(_0x38eef9){var _0xeaa155={};_0xeaa155[_0x38eef9]={'$like':'%'+_0x1843e2['query'][_0xc1e2('0x40')]+'%'};return _0xeaa155;})});}_0x3ffde4=_[_0xc1e2('0x41')]({},_0x3ffde4,_0x1843e2[_0xc1e2('0x43')]);return db['JscriptyAnswerReport'][_0xc1e2('0x1e')]({'where':_0x3ffde4[_0xc1e2('0x3e')]})['then'](function(_0x45ec55){_0x4f2cc8[_0xc1e2('0x1e')]=_0x45ec55;if(_0x1843e2[_0xc1e2('0x37')][_0xc1e2('0x48')]){_0x3ffde4[_0xc1e2('0x52')]=[{'all':!![]}];}return db[_0xc1e2('0x5f')][_0xc1e2('0x44')](_0x3ffde4);})[_0xc1e2('0x27')](function(_0x53971c){_0x4f2cc8[_0xc1e2('0x45')]=_0x53971c;return _0x4f2cc8;});}})[_0xc1e2('0x27')](respondWithFilteredResult(_0x36ac09,_0x3ffde4))[_0xc1e2('0x46')](handleError(_0x36ac09,null));};function char(_0xabdef3){return _0xc1e2('0x60')===typeof _0xabdef3?String['fromCharCode']['apply'](null,arguments):_0xabdef3;}function needsEncapsulation(_0x42ba70){return!!_0x42ba70&&(_0x42ba70[_0xc1e2('0x61')]()[_0xc1e2('0x62')](char(0xd))>=0x0||_0x42ba70[_0xc1e2('0x61')]()['indexOf'](char(0xa))>=0x0||_0x42ba70['toString']()[_0xc1e2('0x62')](char(0x2c))>=0x0||_0x42ba70[_0xc1e2('0x61')]()[_0xc1e2('0x62')](char(0x22))>=0x0);}function encapsulate(_0xffdee3){var _0x259248=char(0x22),_0x588731='\x5c'+char(0x22),_0x3e0907=_0xffdee3[_0xc1e2('0x61')]()[_0xc1e2('0x63')](new RegExp(_0x259248,'g'),_0x588731);return _0x259248+_0x3e0907+_0x259248;}exports[_0xc1e2('0x64')]=function(_0x3dad79,_0x83a128,_0x47a248){var _0x380e5c,_0xf5fe6a;var _0x3b47e1={'where':{'ProjectId':_0x3dad79[_0xc1e2('0x58')]['id']}};if(_0x3dad79[_0xc1e2('0x37')]['startTime']){_0x3b47e1['where'][_0xc1e2('0x65')]=JSON[_0xc1e2('0x66')](_0x3dad79[_0xc1e2('0x37')]['startTime']);}return db[_0xc1e2('0x5d')][_0xc1e2('0x44')](_0x3b47e1)['then'](handleEntityNotFound(_0x83a128,null))['then'](function(_0x38ef76){if(_0x38ef76){_0x380e5c=_0x38ef76;return db[_0xc1e2('0x67')]['findAll']({'where':{'SessionId':{'$in':_[_0xc1e2('0x2f')](_0x380e5c,'id')},'ProjectId':_0x3dad79[_0xc1e2('0x58')]['id']},'order':_0xc1e2('0x68')});}})[_0xc1e2('0x27')](handleEntityNotFound(_0x83a128,null))['then'](function(_0x2ce6ff){if(_0x2ce6ff){_0xf5fe6a=_0x2ce6ff;var _0x20ad9b={};for(var _0x5d68cf=0x0,_0x2123fe=_0xf5fe6a[_0xc1e2('0x3a')];_0x5d68cf<_0x2123fe;_0x5d68cf++){if(!_0x20ad9b[_0xc1e2('0x5b')](_0xf5fe6a[_0x5d68cf][_0xc1e2('0x69')])){_0x20ad9b[_0xf5fe6a[_0x5d68cf]['questionId']]=needsEncapsulation(_0xf5fe6a[_0x5d68cf]['question'])?encapsulate(_0xf5fe6a[_0x5d68cf][_0xc1e2('0x6a')]):_0xf5fe6a[_0x5d68cf][_0xc1e2('0x6a')];}}var _0x5eadf7=[],_0x40db7b={};for(var _0x39d283=0x0,_0x2e8d82=_0x380e5c['length'];_0x39d283<_0x2e8d82;_0x39d283++){_0x40db7b={'ProjectId':_0x3dad79[_0xc1e2('0x58')]['id'],'SessionId':_0x380e5c[_0x39d283]['id'],'StartTime':moment(_0x380e5c[_0x39d283][_0xc1e2('0x65')])[_0xc1e2('0x6b')]('YYYY-MM-DD\x20HH:mm:ss')};for(var _0x4e5df1=0x0,_0x4fc24f=_0xf5fe6a[_0xc1e2('0x3a')];_0x4e5df1<_0x4fc24f;_0x4e5df1++){if(_0xf5fe6a[_0x4e5df1][_0xc1e2('0x6c')]==_0x380e5c[_0x39d283]['id']&&_0x20ad9b[_0xc1e2('0x5b')](_0xf5fe6a[_0x4e5df1]['questionId'])){_0x40db7b[_0x20ad9b[_0xf5fe6a[_0x4e5df1][_0xc1e2('0x69')]]]=_0xf5fe6a[_0x4e5df1][_0xc1e2('0x6d')];}}for(var _0xb49196 in _0x20ad9b){if(!_0x40db7b[_0xc1e2('0x5b')](_0x20ad9b[_0xb49196])){_0x40db7b[_0x20ad9b[_0xb49196]]=null;}}_0x5eadf7[_0xc1e2('0x6e')](_0x40db7b);}return _0x5eadf7;}})[_0xc1e2('0x27')](function(_0x12619d){if(!_['isEmpty'](_0x12619d)){var _0x5b6dc3=toCsv(_0x12619d);var _0x92eff=Date[_0xc1e2('0x6f')]();fs['writeFileSync'](util[_0xc1e2('0x6b')](_0xc1e2('0x70'),_0x3dad79[_0xc1e2('0x58')]['id'],_0x92eff),_0x5b6dc3);_0x83a128['setHeader'](_0xc1e2('0x71'),_0xc1e2('0x72')+util[_0xc1e2('0x6b')]('Jscripty_Project_%d_Summary_%s.csv',_0x3dad79[_0xc1e2('0x58')]['id'],_0x92eff));_0x83a128['setHeader'](_0xc1e2('0x73'),'text/csv');return _0x83a128[_0xc1e2('0x74')](util[_0xc1e2('0x6b')](_0xc1e2('0x70'),_0x3dad79[_0xc1e2('0x58')]['id'],_0x92eff));}else{return _0x83a128[_0xc1e2('0x1b')](0xcc);}})['catch'](handleError(_0x83a128,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff