// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x98b7=['query','keys','filters','intersection','fields','attributes','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','findAll','rows','show','rawAttributes','length','includeAll','options','find','catch','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','get','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','params','include','omit','updatedAt','UserProfileSection','getSessions','findOne','JscriptySessionReport','getAnswers','JscriptyAnswerReport','ProjectId','number','fromCharCode','toString','indexOf','replace','getSummary','startTime','parse','JscriptyQuestionReport','-createdAt','questionId','question','starttime','YYYY-MM-DD\x20HH:mm:ss','SessionId','answer','push','now','writeFileSync','format','/tmp/Jscripty_Project_%d_Summary_%s.csv','Content-disposition','attachment;\x20filename=','setHeader','Content-type','text/csv','download','eml-format','rimraf','zip-dir','fast-json-patch','mustache','util','path','sox','to-csv','fs-extra','squel','crypto','jsforce','desk.js','papaparse','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','status','json','offset','undefined','limit','count','Content-Range','apply','reject','save','update','then','destroy','Projects','UserProfileResource','error','stack','name','index','map','JscriptyProject','fieldName','type','key','model'];(function(_0x39b595,_0x550331){var _0x4bfdef=function(_0x36952f){while(--_0x36952f){_0x39b595['push'](_0x39b595['shift']());}};_0x4bfdef(++_0x550331);}(_0x98b7,0xc1));var _0x798b=function(_0x20a584,_0xe384a5){_0x20a584=_0x20a584-0x0;var _0x4b41a8=_0x98b7[_0x20a584];return _0x4b41a8;};'use strict';var emlformat=require(_0x798b('0x0'));var rimraf=require(_0x798b('0x1'));var zipdir=require(_0x798b('0x2'));var jsonpatch=require(_0x798b('0x3'));var rp=require('request-promise');var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x798b('0x4'));var util=require(_0x798b('0x5'));var path=require(_0x798b('0x6'));var sox=require(_0x798b('0x7'));var csv=require(_0x798b('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x798b('0x9'));var _=require('lodash');var squel=require(_0x798b('0xa'));var crypto=require(_0x798b('0xb'));var jsforce=require(_0x798b('0xc'));var deskjs=require(_0x798b('0xd'));var toCsv=require(_0x798b('0x8'));var querystring=require('querystring');var Papa=require(_0x798b('0xe'));var Redis=require('ioredis');var authService=require(_0x798b('0xf'));var qs=require('../../components/parsers/qs');var as=require(_0x798b('0x10'));var hardwareService=require(_0x798b('0x11'));var logger=require(_0x798b('0x12'))('api');var utils=require('../../config/utils');var config=require(_0x798b('0x13'));var licenseUtil=require(_0x798b('0x14'));var db=require(_0x798b('0x15'))['db'];function respondWithStatusCode(_0x5455a7,_0x18057f){_0x18057f=_0x18057f||0xcc;return function(_0x53b5f1){if(_0x53b5f1){return _0x5455a7[_0x798b('0x16')](_0x18057f);}return _0x5455a7['status'](_0x18057f)[_0x798b('0x17')]();};}function respondWithResult(_0x2aacd7,_0x33cf2e){_0x33cf2e=_0x33cf2e||0xc8;return function(_0x213973){if(_0x213973){return _0x2aacd7[_0x798b('0x18')](_0x33cf2e)[_0x798b('0x19')](_0x213973);}};}function respondWithFilteredResult(_0x36425f,_0x5936fd){return function(_0x511dd3){if(_0x511dd3){var _0x1039fe=typeof _0x5936fd[_0x798b('0x1a')]===_0x798b('0x1b')&&typeof _0x5936fd[_0x798b('0x1c')]===_0x798b('0x1b');var _0x46c7c5=_0x511dd3[_0x798b('0x1d')];var _0x2fa3f6=_0x1039fe?0x0:_0x5936fd[_0x798b('0x1a')];var _0x1af73a=_0x1039fe?_0x511dd3[_0x798b('0x1d')]:_0x5936fd[_0x798b('0x1a')]+_0x5936fd[_0x798b('0x1c')];var _0x327312;if(_0x1af73a>=_0x46c7c5){_0x1af73a=_0x46c7c5;_0x327312=0xc8;}else{_0x327312=0xce;}_0x36425f[_0x798b('0x18')](_0x327312);return _0x36425f['set'](_0x798b('0x1e'),_0x2fa3f6+'-'+_0x1af73a+'/'+_0x46c7c5)[_0x798b('0x19')](_0x511dd3);}return null;};}function patchUpdates(_0x2c36d5){return function(_0x2cb76e){try{jsonpatch[_0x798b('0x1f')](_0x2cb76e,_0x2c36d5,!![]);}catch(_0x2cb7a5){return BPromise[_0x798b('0x20')](_0x2cb7a5);}return _0x2cb76e[_0x798b('0x21')]();};}function saveUpdates(_0x4c1817,_0x2de542){return function(_0x3babb5){if(_0x3babb5){return _0x3babb5[_0x798b('0x22')](_0x4c1817)[_0x798b('0x23')](function(_0x50f66c){return _0x50f66c;});}return null;};}function removeEntity(_0x397092,_0x32c926){return function(_0x36920a){if(_0x36920a){return _0x36920a[_0x798b('0x24')]()['then'](function(){var _0x325c3d=_0x36920a['get']({'plain':!![]});var _0x202398=_0x798b('0x25');return db[_0x798b('0x26')]['destroy']({'where':{'type':_0x202398,'resourceId':_0x325c3d['id']}})[_0x798b('0x23')](function(){return _0x36920a;});})[_0x798b('0x23')](function(){_0x397092[_0x798b('0x18')](0xcc)[_0x798b('0x17')]();});}};}function handleEntityNotFound(_0x2aa507,_0x251d8f){return function(_0x186f26){if(!_0x186f26){_0x2aa507['sendStatus'](0x194);}return _0x186f26;};}function handleError(_0x63c6ed,_0x5a7266){_0x5a7266=_0x5a7266||0x1f4;return function(_0x2ad7b8){logger[_0x798b('0x27')](_0x2ad7b8[_0x798b('0x28')]);if(_0x2ad7b8[_0x798b('0x29')]){delete _0x2ad7b8[_0x798b('0x29')];}_0x63c6ed['status'](_0x5a7266)['send'](_0x2ad7b8);};}exports[_0x798b('0x2a')]=function(_0x40b229,_0x228c44){var _0x1194e6={},_0x5832cc={},_0x27a40d={'count':0x0,'rows':[]};var _0x2c562b=_[_0x798b('0x2b')](db[_0x798b('0x2c')]['rawAttributes'],function(_0x1661e9){return{'name':_0x1661e9[_0x798b('0x2d')],'type':_0x1661e9[_0x798b('0x2e')][_0x798b('0x2f')]};});_0x5832cc[_0x798b('0x30')]=_[_0x798b('0x2b')](_0x2c562b,_0x798b('0x29'));_0x5832cc[_0x798b('0x31')]=_[_0x798b('0x32')](_0x40b229['query']);_0x5832cc[_0x798b('0x33')]=_[_0x798b('0x34')](_0x5832cc[_0x798b('0x30')],_0x5832cc[_0x798b('0x31')]);_0x1194e6['attributes']=_['intersection'](_0x5832cc[_0x798b('0x30')],qs[_0x798b('0x35')](_0x40b229[_0x798b('0x31')][_0x798b('0x35')]));_0x1194e6[_0x798b('0x36')]=_0x1194e6['attributes']['length']?_0x1194e6[_0x798b('0x36')]:_0x5832cc[_0x798b('0x30')];if(!_0x40b229[_0x798b('0x31')][_0x798b('0x37')](_0x798b('0x38'))){_0x1194e6[_0x798b('0x1c')]=qs[_0x798b('0x1c')](_0x40b229[_0x798b('0x31')][_0x798b('0x1c')]);_0x1194e6[_0x798b('0x1a')]=qs[_0x798b('0x1a')](_0x40b229[_0x798b('0x31')][_0x798b('0x1a')]);}_0x1194e6[_0x798b('0x39')]=qs[_0x798b('0x3a')](_0x40b229[_0x798b('0x31')][_0x798b('0x3a')]);_0x1194e6[_0x798b('0x3b')]=qs[_0x798b('0x33')](_[_0x798b('0x3c')](_0x40b229[_0x798b('0x31')],_0x5832cc[_0x798b('0x33')]),_0x2c562b);if(_0x40b229[_0x798b('0x31')][_0x798b('0x3d')]){_0x1194e6[_0x798b('0x3b')]=_[_0x798b('0x3e')](_0x1194e6[_0x798b('0x3b')],{'$or':_[_0x798b('0x2b')](_0x2c562b,function(_0xb63d9c){if(_0xb63d9c[_0x798b('0x2e')]!==_0x798b('0x3f')){var _0x1c34ef={};_0x1c34ef[_0xb63d9c[_0x798b('0x29')]]={'$like':'%'+_0x40b229['query'][_0x798b('0x3d')]+'%'};return _0x1c34ef;}})});}_0x1194e6=_[_0x798b('0x3e')]({},_0x1194e6,_0x40b229['options']);var _0x79daaa={'where':_0x1194e6[_0x798b('0x3b')]};return db[_0x798b('0x2c')]['count'](_0x79daaa)[_0x798b('0x23')](function(_0x2e6148){_0x27a40d[_0x798b('0x1d')]=_0x2e6148;if(_0x40b229[_0x798b('0x31')]['includeAll']){_0x1194e6['include']=[{'all':!![]}];}return db['JscriptyProject'][_0x798b('0x40')](_0x1194e6);})[_0x798b('0x23')](function(_0xdaaf91){_0x27a40d[_0x798b('0x41')]=_0xdaaf91;return _0x27a40d;})['then'](respondWithFilteredResult(_0x228c44,_0x1194e6))['catch'](handleError(_0x228c44,null));};exports[_0x798b('0x42')]=function(_0x4446bd,_0x113d57){var _0x51aa3f={'raw':![],'where':{'id':_0x4446bd['params']['id']}},_0x337c33={};_0x337c33['model']=_['keys'](db[_0x798b('0x2c')][_0x798b('0x43')]);_0x337c33[_0x798b('0x31')]=_['keys'](_0x4446bd[_0x798b('0x31')]);_0x337c33['filters']=_['intersection'](_0x337c33['model'],_0x337c33[_0x798b('0x31')]);_0x51aa3f[_0x798b('0x36')]=_['intersection'](_0x337c33[_0x798b('0x30')],qs[_0x798b('0x35')](_0x4446bd['query'][_0x798b('0x35')]));_0x51aa3f[_0x798b('0x36')]=_0x51aa3f[_0x798b('0x36')][_0x798b('0x44')]?_0x51aa3f['attributes']:_0x337c33[_0x798b('0x30')];if(_0x4446bd[_0x798b('0x31')][_0x798b('0x45')]){_0x51aa3f['include']=[{'all':!![]}];}_0x51aa3f=_[_0x798b('0x3e')]({},_0x51aa3f,_0x4446bd[_0x798b('0x46')]);return db[_0x798b('0x2c')][_0x798b('0x47')](_0x51aa3f)[_0x798b('0x23')](handleEntityNotFound(_0x113d57,null))[_0x798b('0x23')](respondWithResult(_0x113d57,null))[_0x798b('0x48')](handleError(_0x113d57,null));};exports[_0x798b('0x49')]=function(_0x457b60,_0x44007c){return db[_0x798b('0x2c')][_0x798b('0x49')](_0x457b60[_0x798b('0x4a')],{})['then'](function(_0x3451b4){var _0x4b6798=_0x457b60[_0x798b('0x4b')]['get']({'plain':!![]});if(!_0x4b6798)throw new Error(_0x798b('0x4c'));if(_0x4b6798[_0x798b('0x4d')]===_0x798b('0x4b')){var _0x47732f=_0x3451b4[_0x798b('0x4e')]({'plain':!![]});var _0x2c5ba5=_0x798b('0x25');return db['UserProfileSection'][_0x798b('0x47')]({'where':{'name':_0x2c5ba5,'userProfileId':_0x4b6798[_0x798b('0x4f')]},'raw':!![]})[_0x798b('0x23')](function(_0x5dbdd8){if(_0x5dbdd8&&_0x5dbdd8[_0x798b('0x50')]===0x0){return db['UserProfileResource'][_0x798b('0x49')]({'name':_0x47732f[_0x798b('0x29')],'resourceId':_0x47732f['id'],'type':_0x5dbdd8[_0x798b('0x29')],'sectionId':_0x5dbdd8['id']},{})[_0x798b('0x23')](function(){return _0x3451b4;});}else{return _0x3451b4;}})[_0x798b('0x48')](function(_0x45d178){logger[_0x798b('0x27')](_0x798b('0x51'),_0x45d178);throw _0x45d178;});}return _0x3451b4;})[_0x798b('0x23')](respondWithResult(_0x44007c,0xc9))[_0x798b('0x48')](handleError(_0x44007c,null));};exports[_0x798b('0x52')]=function(_0x3ba997,_0x38b576){var _0x16a7d7={'where':{'id':_0x3ba997[_0x798b('0x53')]['id']}},_0x577429={};_0x577429[_0x798b('0x30')]=_[_0x798b('0x32')](db[_0x798b('0x2c')][_0x798b('0x43')]);_0x16a7d7['attributes']=_[_0x798b('0x34')](_0x577429[_0x798b('0x30')],qs['fields'](_0x3ba997[_0x798b('0x31')]['fields']));_0x16a7d7[_0x798b('0x36')]=_0x16a7d7['attributes'][_0x798b('0x44')]?_0x16a7d7[_0x798b('0x36')]:_0x577429[_0x798b('0x30')];if(_0x3ba997[_0x798b('0x31')][_0x798b('0x45')]){_0x16a7d7[_0x798b('0x54')]=[{'all':!![]}];}_0x16a7d7=_[_0x798b('0x3e')]({},_0x16a7d7,_0x3ba997[_0x798b('0x46')]);return db['JscriptyProject'][_0x798b('0x47')](_0x16a7d7)['then'](handleEntityNotFound(_0x38b576,null))[_0x798b('0x23')](function(_0x2c49fe){if(_0x2c49fe){var _0x1f7e69=_0x2c49fe[_0x798b('0x4e')]({'plain':!![]});_0x1f7e69=qs[_0x798b('0x55')](_0x1f7e69,['id','createdAt',_0x798b('0x56')]);_0x3ba997['body']=_[_0x798b('0x55')](_0x3ba997[_0x798b('0x4a')],['id','createdAt','updatedAt']);return db[_0x798b('0x2c')]['create'](_[_0x798b('0x3e')](_0x1f7e69,_0x3ba997[_0x798b('0x4a')]),{'include':_0x3ba997[_0x798b('0x31')]['includeAll']?[{'all':!![]}]:undefined})[_0x798b('0x23')](function(_0x53ad6d){var _0x2ec2a6=_0x3ba997[_0x798b('0x4b')][_0x798b('0x4e')]({'plain':!![]});if(!_0x2ec2a6)throw new Error(_0x798b('0x4c'));if(_0x2ec2a6['role']===_0x798b('0x4b')){var _0x1ca33a=_0x53ad6d[_0x798b('0x4e')]({'plain':!![]});var _0x44a4a5='Projects';return db[_0x798b('0x57')][_0x798b('0x47')]({'where':{'name':_0x44a4a5,'userProfileId':_0x2ec2a6[_0x798b('0x4f')]},'raw':!![]})[_0x798b('0x23')](function(_0xadcf7c){if(_0xadcf7c&&_0xadcf7c[_0x798b('0x50')]===0x0){return db['UserProfileResource'][_0x798b('0x49')]({'name':_0x1ca33a[_0x798b('0x29')],'resourceId':_0x1ca33a['id'],'type':_0xadcf7c[_0x798b('0x29')],'sectionId':_0xadcf7c['id']},{})[_0x798b('0x23')](function(){return _0x53ad6d;});}else{return _0x53ad6d;}})[_0x798b('0x48')](function(_0x5b4986){logger[_0x798b('0x27')](_0x798b('0x51'),_0x5b4986);throw _0x5b4986;});}return _0x53ad6d;});}})[_0x798b('0x23')](respondWithResult(_0x38b576,0xc9))[_0x798b('0x48')](handleError(_0x38b576,null));};exports[_0x798b('0x22')]=function(_0x324308,_0x5d3559){if(_0x324308[_0x798b('0x4a')]['id']){delete _0x324308[_0x798b('0x4a')]['id'];}return db[_0x798b('0x2c')][_0x798b('0x47')]({'where':{'id':_0x324308['params']['id']}})[_0x798b('0x23')](handleEntityNotFound(_0x5d3559,null))[_0x798b('0x23')](saveUpdates(_0x324308['body'],null))[_0x798b('0x23')](respondWithResult(_0x5d3559,null))[_0x798b('0x48')](handleError(_0x5d3559,null));};exports[_0x798b('0x24')]=function(_0x1a95ef,_0xa422c){return db['JscriptyProject'][_0x798b('0x47')]({'where':{'id':_0x1a95ef[_0x798b('0x53')]['id']}})[_0x798b('0x23')](handleEntityNotFound(_0xa422c,null))['then'](removeEntity(_0xa422c,null))[_0x798b('0x48')](handleError(_0xa422c,null));};exports[_0x798b('0x58')]=function(_0x272a76,_0x100509,_0x57a8a1){var _0xcf57f={'raw':!![],'where':{}};var _0x5057fc={};var _0x140aa4={'count':0x0,'rows':[]};return db[_0x798b('0x2c')][_0x798b('0x59')]({'where':{'id':_0x272a76[_0x798b('0x53')]['id']}})[_0x798b('0x23')](handleEntityNotFound(_0x100509,null))['then'](function(_0x411bce){if(_0x411bce){_0x5057fc[_0x798b('0x30')]=_['keys'](db[_0x798b('0x5a')][_0x798b('0x43')]);_0x5057fc[_0x798b('0x31')]=_[_0x798b('0x32')](_0x272a76['query']);_0x5057fc[_0x798b('0x33')]=_[_0x798b('0x34')](_0x5057fc[_0x798b('0x30')],_0x5057fc['query']);_0xcf57f['attributes']=_['intersection'](_0x5057fc[_0x798b('0x30')],qs['fields'](_0x272a76['query'][_0x798b('0x35')]));_0xcf57f[_0x798b('0x36')]=_0xcf57f[_0x798b('0x36')][_0x798b('0x44')]?_0xcf57f[_0x798b('0x36')]:_0x5057fc['model'];if(!_0x272a76[_0x798b('0x31')][_0x798b('0x37')](_0x798b('0x38'))){_0xcf57f[_0x798b('0x1c')]=qs[_0x798b('0x1c')](_0x272a76[_0x798b('0x31')][_0x798b('0x1c')]);_0xcf57f[_0x798b('0x1a')]=qs[_0x798b('0x1a')](_0x272a76['query'][_0x798b('0x1a')]);}_0xcf57f[_0x798b('0x39')]=qs[_0x798b('0x3a')](_0x272a76[_0x798b('0x31')][_0x798b('0x3a')]);_0xcf57f[_0x798b('0x3b')]=qs[_0x798b('0x33')](_['pick'](_0x272a76[_0x798b('0x31')],_0x5057fc[_0x798b('0x33')]));_0xcf57f[_0x798b('0x3b')]['ProjectId']=_0x411bce['id'];if(_0x272a76[_0x798b('0x31')][_0x798b('0x3d')]){_0xcf57f['where']=_[_0x798b('0x3e')](_0xcf57f['where'],{'$or':_[_0x798b('0x2b')](_0xcf57f[_0x798b('0x36')],function(_0x5e191f){var _0x4c86d8={};_0x4c86d8[_0x5e191f]={'$like':'%'+_0x272a76['query'][_0x798b('0x3d')]+'%'};return _0x4c86d8;})});}_0xcf57f=_[_0x798b('0x3e')]({},_0xcf57f,_0x272a76[_0x798b('0x46')]);return db[_0x798b('0x5a')][_0x798b('0x1d')]({'where':_0xcf57f[_0x798b('0x3b')]})[_0x798b('0x23')](function(_0x754404){_0x140aa4[_0x798b('0x1d')]=_0x754404;if(_0x272a76['query']['includeAll']){_0xcf57f[_0x798b('0x54')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0x798b('0x40')](_0xcf57f);})[_0x798b('0x23')](function(_0x136595){_0x140aa4['rows']=_0x136595;return _0x140aa4;});}})[_0x798b('0x23')](respondWithFilteredResult(_0x100509,_0xcf57f))[_0x798b('0x48')](handleError(_0x100509,null));};exports[_0x798b('0x5b')]=function(_0x4b8752,_0x54d32e,_0x2f19da){var _0x1cf156={'raw':!![],'where':{}};var _0x437fbb={};var _0xb6abe5={'count':0x0,'rows':[]};return db[_0x798b('0x2c')][_0x798b('0x59')]({'where':{'id':_0x4b8752[_0x798b('0x53')]['id']}})[_0x798b('0x23')](handleEntityNotFound(_0x54d32e,null))['then'](function(_0x3ec70c){if(_0x3ec70c){_0x437fbb[_0x798b('0x30')]=_[_0x798b('0x32')](db[_0x798b('0x5c')][_0x798b('0x43')]);_0x437fbb['query']=_[_0x798b('0x32')](_0x4b8752['query']);_0x437fbb[_0x798b('0x33')]=_[_0x798b('0x34')](_0x437fbb[_0x798b('0x30')],_0x437fbb[_0x798b('0x31')]);_0x1cf156[_0x798b('0x36')]=_[_0x798b('0x34')](_0x437fbb['model'],qs[_0x798b('0x35')](_0x4b8752[_0x798b('0x31')]['fields']));_0x1cf156['attributes']=_0x1cf156['attributes'][_0x798b('0x44')]?_0x1cf156[_0x798b('0x36')]:_0x437fbb[_0x798b('0x30')];if(!_0x4b8752[_0x798b('0x31')][_0x798b('0x37')](_0x798b('0x38'))){_0x1cf156['limit']=qs[_0x798b('0x1c')](_0x4b8752['query'][_0x798b('0x1c')]);_0x1cf156[_0x798b('0x1a')]=qs['offset'](_0x4b8752[_0x798b('0x31')][_0x798b('0x1a')]);}_0x1cf156[_0x798b('0x39')]=qs[_0x798b('0x3a')](_0x4b8752[_0x798b('0x31')][_0x798b('0x3a')]);_0x1cf156[_0x798b('0x3b')]=qs[_0x798b('0x33')](_[_0x798b('0x3c')](_0x4b8752[_0x798b('0x31')],_0x437fbb[_0x798b('0x33')]));_0x1cf156[_0x798b('0x3b')][_0x798b('0x5d')]=_0x3ec70c['id'];if(_0x4b8752['query']['filter']){_0x1cf156[_0x798b('0x3b')]=_[_0x798b('0x3e')](_0x1cf156['where'],{'$or':_[_0x798b('0x2b')](_0x1cf156[_0x798b('0x36')],function(_0x3948af){var _0x3d4507={};_0x3d4507[_0x3948af]={'$like':'%'+_0x4b8752[_0x798b('0x31')][_0x798b('0x3d')]+'%'};return _0x3d4507;})});}_0x1cf156=_[_0x798b('0x3e')]({},_0x1cf156,_0x4b8752['options']);return db[_0x798b('0x5c')][_0x798b('0x1d')]({'where':_0x1cf156['where']})[_0x798b('0x23')](function(_0x33d0f2){_0xb6abe5[_0x798b('0x1d')]=_0x33d0f2;if(_0x4b8752['query'][_0x798b('0x45')]){_0x1cf156[_0x798b('0x54')]=[{'all':!![]}];}return db[_0x798b('0x5c')][_0x798b('0x40')](_0x1cf156);})['then'](function(_0x3826e6){_0xb6abe5['rows']=_0x3826e6;return _0xb6abe5;});}})['then'](respondWithFilteredResult(_0x54d32e,_0x1cf156))[_0x798b('0x48')](handleError(_0x54d32e,null));};function char(_0x32e9b9){return _0x798b('0x5e')===typeof _0x32e9b9?String[_0x798b('0x5f')][_0x798b('0x1f')](null,arguments):_0x32e9b9;}function needsEncapsulation(_0x4e3f1){return!!_0x4e3f1&&(_0x4e3f1[_0x798b('0x60')]()[_0x798b('0x61')](char(0xd))>=0x0||_0x4e3f1[_0x798b('0x60')]()['indexOf'](char(0xa))>=0x0||_0x4e3f1[_0x798b('0x60')]()[_0x798b('0x61')](char(0x2c))>=0x0||_0x4e3f1[_0x798b('0x60')]()['indexOf'](char(0x22))>=0x0);}function encapsulate(_0x4494cb){var _0x381c26=char(0x22),_0x344404='\x5c'+char(0x22),_0x19efc3=_0x4494cb[_0x798b('0x60')]()[_0x798b('0x62')](new RegExp(_0x381c26,'g'),_0x344404);return _0x381c26+_0x19efc3+_0x381c26;}exports[_0x798b('0x63')]=function(_0x12feca,_0x102490,_0x4fd5e9){var _0x51a08a,_0x57d60b;var _0x25d7f8={'where':{'ProjectId':_0x12feca[_0x798b('0x53')]['id']}};if(_0x12feca[_0x798b('0x31')][_0x798b('0x64')]){_0x25d7f8[_0x798b('0x3b')]['starttime']=JSON[_0x798b('0x65')](_0x12feca[_0x798b('0x31')][_0x798b('0x64')]);}return db[_0x798b('0x5a')]['findAll'](_0x25d7f8)[_0x798b('0x23')](handleEntityNotFound(_0x102490,null))[_0x798b('0x23')](function(_0x4cfe9f){if(_0x4cfe9f){_0x51a08a=_0x4cfe9f;return db[_0x798b('0x66')]['findAll']({'where':{'SessionId':{'$in':_['map'](_0x51a08a,'id')},'ProjectId':_0x12feca[_0x798b('0x53')]['id']},'order':_0x798b('0x67')});}})[_0x798b('0x23')](handleEntityNotFound(_0x102490,null))[_0x798b('0x23')](function(_0x53b0a1){if(_0x53b0a1){_0x57d60b=_0x53b0a1;var _0x5e96e4={};for(var _0x23e8c0=0x0,_0x566e55=_0x57d60b[_0x798b('0x44')];_0x23e8c0<_0x566e55;_0x23e8c0++){if(!_0x5e96e4[_0x798b('0x37')](_0x57d60b[_0x23e8c0][_0x798b('0x68')])){_0x5e96e4[_0x57d60b[_0x23e8c0][_0x798b('0x68')]]=needsEncapsulation(_0x57d60b[_0x23e8c0][_0x798b('0x69')])?encapsulate(_0x57d60b[_0x23e8c0][_0x798b('0x69')]):_0x57d60b[_0x23e8c0][_0x798b('0x69')];}}var _0x1ba649=[],_0x22013c={};for(var _0x37c068=0x0,_0x5cd286=_0x51a08a[_0x798b('0x44')];_0x37c068<_0x5cd286;_0x37c068++){_0x22013c={'ProjectId':_0x12feca[_0x798b('0x53')]['id'],'SessionId':_0x51a08a[_0x37c068]['id'],'StartTime':moment(_0x51a08a[_0x37c068][_0x798b('0x6a')])['format'](_0x798b('0x6b'))};for(var _0x210cac=0x0,_0x18dc4b=_0x57d60b[_0x798b('0x44')];_0x210cac<_0x18dc4b;_0x210cac++){if(_0x57d60b[_0x210cac][_0x798b('0x6c')]==_0x51a08a[_0x37c068]['id']&&_0x5e96e4[_0x798b('0x37')](_0x57d60b[_0x210cac][_0x798b('0x68')])){_0x22013c[_0x5e96e4[_0x57d60b[_0x210cac][_0x798b('0x68')]]]=_0x57d60b[_0x210cac][_0x798b('0x6d')];}}for(var _0x32165d in _0x5e96e4){if(!_0x22013c[_0x798b('0x37')](_0x5e96e4[_0x32165d])){_0x22013c[_0x5e96e4[_0x32165d]]=null;}}_0x1ba649[_0x798b('0x6e')](_0x22013c);}return _0x1ba649;}})[_0x798b('0x23')](function(_0x3b50c8){if(!_['isEmpty'](_0x3b50c8)){var _0x135051=toCsv(_0x3b50c8);var _0x26c312=Date[_0x798b('0x6f')]();fs[_0x798b('0x70')](util[_0x798b('0x71')](_0x798b('0x72'),_0x12feca[_0x798b('0x53')]['id'],_0x26c312),_0x135051);_0x102490['setHeader'](_0x798b('0x73'),_0x798b('0x74')+util[_0x798b('0x71')]('Jscripty_Project_%d_Summary_%s.csv',_0x12feca[_0x798b('0x53')]['id'],_0x26c312));_0x102490[_0x798b('0x75')](_0x798b('0x76'),_0x798b('0x77'));return _0x102490[_0x798b('0x78')](util['format'](_0x798b('0x72'),_0x12feca['params']['id'],_0x26c312));}else{return _0x102490[_0x798b('0x16')](0xcc);}})['catch'](handleError(_0x102490,null));};
\ No newline at end of file
+var _0x78e2=['rawAttributes','intersection','length','find','create','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','Projects','UserProfileSection','userProfileId','autoAssociation','clone','omit','createdAt','updatedAt','role','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','findOne','JscriptySessionReport','pick','ProjectId','include','getAnswers','JscriptyAnswerReport','order','number','toString','indexOf','getSummary','startTime','starttime','parse','JscriptyQuestionReport','-createdAt','questionId','question','YYYY-MM-DD\x20HH:mm:ss','SessionId','answer','push','isEmpty','now','writeFileSync','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','Content-disposition','format','Content-type','text/csv','download','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','status','offset','limit','undefined','count','set','Content-Range','json','apply','reject','save','update','then','destroy','UserProfileResource','sendStatus','error','stack','name','index','JscriptyProject','type','key','model','map','query','keys','filters','attributes','fields','hasOwnProperty','nolimit','sort','where','VIRTUAL','filter','merge','options','includeAll','findAll','rows','catch','show','params'];(function(_0x675c90,_0x20d7a9){var _0x5c495d=function(_0x377ba){while(--_0x377ba){_0x675c90['push'](_0x675c90['shift']());}};_0x5c495d(++_0x20d7a9);}(_0x78e2,0x1a8));var _0x278e=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0x78e2[_0x3dd15e];return _0x231fd0;};'use strict';var emlformat=require(_0x278e('0x0'));var rimraf=require(_0x278e('0x1'));var zipdir=require(_0x278e('0x2'));var jsonpatch=require(_0x278e('0x3'));var rp=require(_0x278e('0x4'));var moment=require('moment');var BPromise=require(_0x278e('0x5'));var Mustache=require('mustache');var util=require(_0x278e('0x6'));var path=require(_0x278e('0x7'));var sox=require(_0x278e('0x8'));var csv=require(_0x278e('0x9'));var ejs=require(_0x278e('0xa'));var fs=require('fs');var fs_extra=require(_0x278e('0xb'));var _=require(_0x278e('0xc'));var squel=require(_0x278e('0xd'));var crypto=require(_0x278e('0xe'));var jsforce=require(_0x278e('0xf'));var deskjs=require(_0x278e('0x10'));var toCsv=require(_0x278e('0x9'));var querystring=require(_0x278e('0x11'));var Papa=require(_0x278e('0x12'));var Redis=require(_0x278e('0x13'));var authService=require('../../components/auth/service');var qs=require(_0x278e('0x14'));var as=require(_0x278e('0x15'));var hardwareService=require(_0x278e('0x16'));var logger=require(_0x278e('0x17'))(_0x278e('0x18'));var utils=require(_0x278e('0x19'));var config=require(_0x278e('0x1a'));var licenseUtil=require('../../config/license/util');var db=require(_0x278e('0x1b'))['db'];function respondWithStatusCode(_0x3f2a66,_0x4fe711){_0x4fe711=_0x4fe711||0xcc;return function(_0x2bfe2b){if(_0x2bfe2b){return _0x3f2a66['sendStatus'](_0x4fe711);}return _0x3f2a66[_0x278e('0x1c')](_0x4fe711)['end']();};}function respondWithResult(_0x580b58,_0x4503ba){_0x4503ba=_0x4503ba||0xc8;return function(_0x108ce5){if(_0x108ce5){return _0x580b58['status'](_0x4503ba)['json'](_0x108ce5);}};}function respondWithFilteredResult(_0x43f659,_0x15be55){return function(_0x58f1ec){if(_0x58f1ec){var _0x1b6300=typeof _0x15be55[_0x278e('0x1d')]==='undefined'&&typeof _0x15be55[_0x278e('0x1e')]===_0x278e('0x1f');var _0x2cc807=_0x58f1ec['count'];var _0x381cc9=_0x1b6300?0x0:_0x15be55[_0x278e('0x1d')];var _0x58a511=_0x1b6300?_0x58f1ec[_0x278e('0x20')]:_0x15be55[_0x278e('0x1d')]+_0x15be55[_0x278e('0x1e')];var _0x4b66a9;if(_0x58a511>=_0x2cc807){_0x58a511=_0x2cc807;_0x4b66a9=0xc8;}else{_0x4b66a9=0xce;}_0x43f659[_0x278e('0x1c')](_0x4b66a9);return _0x43f659[_0x278e('0x21')](_0x278e('0x22'),_0x381cc9+'-'+_0x58a511+'/'+_0x2cc807)[_0x278e('0x23')](_0x58f1ec);}return null;};}function patchUpdates(_0x576470){return function(_0x380a10){try{jsonpatch[_0x278e('0x24')](_0x380a10,_0x576470,!![]);}catch(_0x5c0920){return BPromise[_0x278e('0x25')](_0x5c0920);}return _0x380a10[_0x278e('0x26')]();};}function saveUpdates(_0x2f4e73,_0x9562e3){return function(_0x461d37){if(_0x461d37){return _0x461d37[_0x278e('0x27')](_0x2f4e73)[_0x278e('0x28')](function(_0x30262f){return _0x30262f;});}return null;};}function removeEntity(_0x1dbc09,_0x269148){return function(_0x3c5de5){if(_0x3c5de5){return _0x3c5de5[_0x278e('0x29')]()['then'](function(){var _0x57054f=_0x3c5de5['get']({'plain':!![]});var _0x42bccd='Projects';return db[_0x278e('0x2a')][_0x278e('0x29')]({'where':{'type':_0x42bccd,'resourceId':_0x57054f['id']}})[_0x278e('0x28')](function(){return _0x3c5de5;});})[_0x278e('0x28')](function(){_0x1dbc09[_0x278e('0x1c')](0xcc)['end']();});}};}function handleEntityNotFound(_0x2b2f0b,_0x15b8e6){return function(_0x14fbc0){if(!_0x14fbc0){_0x2b2f0b[_0x278e('0x2b')](0x194);}return _0x14fbc0;};}function handleError(_0x50cc81,_0x370151){_0x370151=_0x370151||0x1f4;return function(_0x1b91d9){logger[_0x278e('0x2c')](_0x1b91d9[_0x278e('0x2d')]);if(_0x1b91d9[_0x278e('0x2e')]){delete _0x1b91d9[_0x278e('0x2e')];}_0x50cc81[_0x278e('0x1c')](_0x370151)['send'](_0x1b91d9);};}exports[_0x278e('0x2f')]=function(_0x319043,_0x302eec){var _0x3f3c79={},_0x47a14c={},_0x4c5dfd={'count':0x0,'rows':[]};var _0x48b0ad=_['map'](db[_0x278e('0x30')]['rawAttributes'],function(_0x307941){return{'name':_0x307941['fieldName'],'type':_0x307941[_0x278e('0x31')][_0x278e('0x32')]};});_0x47a14c[_0x278e('0x33')]=_[_0x278e('0x34')](_0x48b0ad,'name');_0x47a14c[_0x278e('0x35')]=_[_0x278e('0x36')](_0x319043[_0x278e('0x35')]);_0x47a14c[_0x278e('0x37')]=_['intersection'](_0x47a14c[_0x278e('0x33')],_0x47a14c[_0x278e('0x35')]);_0x3f3c79[_0x278e('0x38')]=_['intersection'](_0x47a14c['model'],qs['fields'](_0x319043[_0x278e('0x35')][_0x278e('0x39')]));_0x3f3c79[_0x278e('0x38')]=_0x3f3c79[_0x278e('0x38')]['length']?_0x3f3c79[_0x278e('0x38')]:_0x47a14c['model'];if(!_0x319043[_0x278e('0x35')][_0x278e('0x3a')](_0x278e('0x3b'))){_0x3f3c79[_0x278e('0x1e')]=qs[_0x278e('0x1e')](_0x319043['query'][_0x278e('0x1e')]);_0x3f3c79[_0x278e('0x1d')]=qs[_0x278e('0x1d')](_0x319043[_0x278e('0x35')][_0x278e('0x1d')]);}_0x3f3c79['order']=qs[_0x278e('0x3c')](_0x319043[_0x278e('0x35')][_0x278e('0x3c')]);_0x3f3c79[_0x278e('0x3d')]=qs[_0x278e('0x37')](_['pick'](_0x319043[_0x278e('0x35')],_0x47a14c[_0x278e('0x37')]),_0x48b0ad);if(_0x319043[_0x278e('0x35')]['filter']){_0x3f3c79[_0x278e('0x3d')]=_['merge'](_0x3f3c79['where'],{'$or':_[_0x278e('0x34')](_0x48b0ad,function(_0x546bda){if(_0x546bda[_0x278e('0x31')]!==_0x278e('0x3e')){var _0x1bb9b9={};_0x1bb9b9[_0x546bda['name']]={'$like':'%'+_0x319043[_0x278e('0x35')][_0x278e('0x3f')]+'%'};return _0x1bb9b9;}})});}_0x3f3c79=_[_0x278e('0x40')]({},_0x3f3c79,_0x319043[_0x278e('0x41')]);var _0x410259={'where':_0x3f3c79['where']};return db['JscriptyProject'][_0x278e('0x20')](_0x410259)['then'](function(_0x34b3ba){_0x4c5dfd['count']=_0x34b3ba;if(_0x319043[_0x278e('0x35')][_0x278e('0x42')]){_0x3f3c79['include']=[{'all':!![]}];}return db[_0x278e('0x30')][_0x278e('0x43')](_0x3f3c79);})[_0x278e('0x28')](function(_0x8d48f5){_0x4c5dfd[_0x278e('0x44')]=_0x8d48f5;return _0x4c5dfd;})[_0x278e('0x28')](respondWithFilteredResult(_0x302eec,_0x3f3c79))[_0x278e('0x45')](handleError(_0x302eec,null));};exports[_0x278e('0x46')]=function(_0x3cde01,_0x1e2d70){var _0x24d696={'raw':![],'where':{'id':_0x3cde01[_0x278e('0x47')]['id']}},_0x285490={};_0x285490[_0x278e('0x33')]=_[_0x278e('0x36')](db[_0x278e('0x30')][_0x278e('0x48')]);_0x285490[_0x278e('0x35')]=_['keys'](_0x3cde01['query']);_0x285490[_0x278e('0x37')]=_['intersection'](_0x285490[_0x278e('0x33')],_0x285490[_0x278e('0x35')]);_0x24d696[_0x278e('0x38')]=_[_0x278e('0x49')](_0x285490[_0x278e('0x33')],qs[_0x278e('0x39')](_0x3cde01[_0x278e('0x35')][_0x278e('0x39')]));_0x24d696[_0x278e('0x38')]=_0x24d696[_0x278e('0x38')][_0x278e('0x4a')]?_0x24d696[_0x278e('0x38')]:_0x285490[_0x278e('0x33')];if(_0x3cde01[_0x278e('0x35')][_0x278e('0x42')]){_0x24d696['include']=[{'all':!![]}];}_0x24d696=_[_0x278e('0x40')]({},_0x24d696,_0x3cde01[_0x278e('0x41')]);return db[_0x278e('0x30')][_0x278e('0x4b')](_0x24d696)[_0x278e('0x28')](handleEntityNotFound(_0x1e2d70,null))[_0x278e('0x28')](respondWithResult(_0x1e2d70,null))[_0x278e('0x45')](handleError(_0x1e2d70,null));};exports[_0x278e('0x4c')]=function(_0x12411f,_0x2e7c86){return db[_0x278e('0x30')][_0x278e('0x4c')](_0x12411f[_0x278e('0x4d')],{})[_0x278e('0x28')](function(_0x37cf1e){var _0x58b996=_0x12411f[_0x278e('0x4e')][_0x278e('0x4f')]({'plain':!![]});if(!_0x58b996)throw new Error(_0x278e('0x50'));if(_0x58b996['role']===_0x278e('0x4e')){var _0xd5a35b=_0x37cf1e[_0x278e('0x4f')]({'plain':!![]});var _0x4c2c43=_0x278e('0x51');return db[_0x278e('0x52')]['find']({'where':{'name':_0x4c2c43,'userProfileId':_0x58b996[_0x278e('0x53')]},'raw':!![]})['then'](function(_0x19d658){if(_0x19d658&&_0x19d658[_0x278e('0x54')]===0x0){return db['UserProfileResource'][_0x278e('0x4c')]({'name':_0xd5a35b['name'],'resourceId':_0xd5a35b['id'],'type':_0x19d658[_0x278e('0x2e')],'sectionId':_0x19d658['id']},{})['then'](function(){return _0x37cf1e;});}else{return _0x37cf1e;}})[_0x278e('0x45')](function(_0x115d7a){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x115d7a);throw _0x115d7a;});}return _0x37cf1e;})[_0x278e('0x28')](respondWithResult(_0x2e7c86,0xc9))[_0x278e('0x45')](handleError(_0x2e7c86,null));};exports[_0x278e('0x55')]=function(_0x32b77f,_0x2115dd){var _0x36a696={'where':{'id':_0x32b77f[_0x278e('0x47')]['id']}},_0x9dbc55={};_0x9dbc55['model']=_[_0x278e('0x36')](db[_0x278e('0x30')]['rawAttributes']);_0x36a696[_0x278e('0x38')]=_[_0x278e('0x49')](_0x9dbc55[_0x278e('0x33')],qs['fields'](_0x32b77f['query'][_0x278e('0x39')]));_0x36a696[_0x278e('0x38')]=_0x36a696[_0x278e('0x38')][_0x278e('0x4a')]?_0x36a696['attributes']:_0x9dbc55[_0x278e('0x33')];if(_0x32b77f[_0x278e('0x35')]['includeAll']){_0x36a696['include']=[{'all':!![]}];}_0x36a696=_[_0x278e('0x40')]({},_0x36a696,_0x32b77f[_0x278e('0x41')]);return db[_0x278e('0x30')][_0x278e('0x4b')](_0x36a696)[_0x278e('0x28')](handleEntityNotFound(_0x2115dd,null))[_0x278e('0x28')](function(_0x467bf2){if(_0x467bf2){var _0x292ecc=_0x467bf2[_0x278e('0x4f')]({'plain':!![]});_0x292ecc=qs[_0x278e('0x56')](_0x292ecc,['id',_0x278e('0x57'),'updatedAt']);_0x32b77f['body']=_['omit'](_0x32b77f[_0x278e('0x4d')],['id',_0x278e('0x57'),_0x278e('0x58')]);return db[_0x278e('0x30')][_0x278e('0x4c')](_[_0x278e('0x40')](_0x292ecc,_0x32b77f[_0x278e('0x4d')]),{'include':_0x32b77f[_0x278e('0x35')][_0x278e('0x42')]?[{'all':!![]}]:undefined})[_0x278e('0x28')](function(_0x11c639){var _0x3e6992=_0x32b77f[_0x278e('0x4e')][_0x278e('0x4f')]({'plain':!![]});if(!_0x3e6992)throw new Error(_0x278e('0x50'));if(_0x3e6992[_0x278e('0x59')]===_0x278e('0x4e')){var _0x28bfa3=_0x11c639[_0x278e('0x4f')]({'plain':!![]});var _0xf07224=_0x278e('0x51');return db[_0x278e('0x52')][_0x278e('0x4b')]({'where':{'name':_0xf07224,'userProfileId':_0x3e6992['userProfileId']},'raw':!![]})[_0x278e('0x28')](function(_0x46574a){if(_0x46574a&&_0x46574a['autoAssociation']===0x0){return db[_0x278e('0x2a')]['create']({'name':_0x28bfa3['name'],'resourceId':_0x28bfa3['id'],'type':_0x46574a['name'],'sectionId':_0x46574a['id']},{})[_0x278e('0x28')](function(){return _0x11c639;});}else{return _0x11c639;}})['catch'](function(_0x1152f6){logger[_0x278e('0x2c')](_0x278e('0x5a'),_0x1152f6);throw _0x1152f6;});}return _0x11c639;});}})['then'](respondWithResult(_0x2115dd,0xc9))[_0x278e('0x45')](handleError(_0x2115dd,null));};exports[_0x278e('0x27')]=function(_0x2ab62e,_0xe8e420){if(_0x2ab62e[_0x278e('0x4d')]['id']){delete _0x2ab62e[_0x278e('0x4d')]['id'];}return db[_0x278e('0x30')][_0x278e('0x4b')]({'where':{'id':_0x2ab62e[_0x278e('0x47')]['id']}})['then'](handleEntityNotFound(_0xe8e420,null))[_0x278e('0x28')](saveUpdates(_0x2ab62e[_0x278e('0x4d')],null))[_0x278e('0x28')](respondWithResult(_0xe8e420,null))[_0x278e('0x45')](handleError(_0xe8e420,null));};exports['destroy']=function(_0x9e9199,_0x231437){return db[_0x278e('0x30')][_0x278e('0x4b')]({'where':{'id':_0x9e9199[_0x278e('0x47')]['id']}})[_0x278e('0x28')](handleEntityNotFound(_0x231437,null))[_0x278e('0x28')](removeEntity(_0x231437,null))[_0x278e('0x45')](handleError(_0x231437,null));};exports['getSessions']=function(_0x28cee6,_0x473edf,_0x5d82c8){var _0x51fcd4={'raw':!![],'where':{}};var _0x3fa9b4={};var _0xf82bf6={'count':0x0,'rows':[]};return db['JscriptyProject'][_0x278e('0x5b')]({'where':{'id':_0x28cee6[_0x278e('0x47')]['id']}})[_0x278e('0x28')](handleEntityNotFound(_0x473edf,null))['then'](function(_0x3516b3){if(_0x3516b3){_0x3fa9b4[_0x278e('0x33')]=_[_0x278e('0x36')](db[_0x278e('0x5c')]['rawAttributes']);_0x3fa9b4[_0x278e('0x35')]=_[_0x278e('0x36')](_0x28cee6[_0x278e('0x35')]);_0x3fa9b4[_0x278e('0x37')]=_[_0x278e('0x49')](_0x3fa9b4[_0x278e('0x33')],_0x3fa9b4[_0x278e('0x35')]);_0x51fcd4[_0x278e('0x38')]=_[_0x278e('0x49')](_0x3fa9b4[_0x278e('0x33')],qs['fields'](_0x28cee6['query'][_0x278e('0x39')]));_0x51fcd4[_0x278e('0x38')]=_0x51fcd4[_0x278e('0x38')][_0x278e('0x4a')]?_0x51fcd4['attributes']:_0x3fa9b4['model'];if(!_0x28cee6[_0x278e('0x35')][_0x278e('0x3a')](_0x278e('0x3b'))){_0x51fcd4[_0x278e('0x1e')]=qs[_0x278e('0x1e')](_0x28cee6['query'][_0x278e('0x1e')]);_0x51fcd4[_0x278e('0x1d')]=qs['offset'](_0x28cee6[_0x278e('0x35')][_0x278e('0x1d')]);}_0x51fcd4['order']=qs['sort'](_0x28cee6[_0x278e('0x35')]['sort']);_0x51fcd4[_0x278e('0x3d')]=qs[_0x278e('0x37')](_[_0x278e('0x5d')](_0x28cee6[_0x278e('0x35')],_0x3fa9b4[_0x278e('0x37')]));_0x51fcd4[_0x278e('0x3d')][_0x278e('0x5e')]=_0x3516b3['id'];if(_0x28cee6['query'][_0x278e('0x3f')]){_0x51fcd4[_0x278e('0x3d')]=_[_0x278e('0x40')](_0x51fcd4['where'],{'$or':_[_0x278e('0x34')](_0x51fcd4[_0x278e('0x38')],function(_0x656864){var _0x304639={};_0x304639[_0x656864]={'$like':'%'+_0x28cee6[_0x278e('0x35')]['filter']+'%'};return _0x304639;})});}_0x51fcd4=_[_0x278e('0x40')]({},_0x51fcd4,_0x28cee6[_0x278e('0x41')]);return db[_0x278e('0x5c')][_0x278e('0x20')]({'where':_0x51fcd4[_0x278e('0x3d')]})[_0x278e('0x28')](function(_0x325681){_0xf82bf6[_0x278e('0x20')]=_0x325681;if(_0x28cee6[_0x278e('0x35')][_0x278e('0x42')]){_0x51fcd4[_0x278e('0x5f')]=[{'all':!![]}];}return db[_0x278e('0x5c')]['findAll'](_0x51fcd4);})['then'](function(_0x593b21){_0xf82bf6[_0x278e('0x44')]=_0x593b21;return _0xf82bf6;});}})[_0x278e('0x28')](respondWithFilteredResult(_0x473edf,_0x51fcd4))[_0x278e('0x45')](handleError(_0x473edf,null));};exports[_0x278e('0x60')]=function(_0x492382,_0x29be6f,_0x5a1c56){var _0x3f516a={'raw':!![],'where':{}};var _0x3f176e={};var _0xb3e777={'count':0x0,'rows':[]};return db[_0x278e('0x30')][_0x278e('0x5b')]({'where':{'id':_0x492382[_0x278e('0x47')]['id']}})[_0x278e('0x28')](handleEntityNotFound(_0x29be6f,null))['then'](function(_0x787373){if(_0x787373){_0x3f176e[_0x278e('0x33')]=_[_0x278e('0x36')](db[_0x278e('0x61')][_0x278e('0x48')]);_0x3f176e['query']=_['keys'](_0x492382['query']);_0x3f176e['filters']=_['intersection'](_0x3f176e[_0x278e('0x33')],_0x3f176e[_0x278e('0x35')]);_0x3f516a[_0x278e('0x38')]=_[_0x278e('0x49')](_0x3f176e[_0x278e('0x33')],qs[_0x278e('0x39')](_0x492382['query'][_0x278e('0x39')]));_0x3f516a[_0x278e('0x38')]=_0x3f516a[_0x278e('0x38')]['length']?_0x3f516a[_0x278e('0x38')]:_0x3f176e[_0x278e('0x33')];if(!_0x492382[_0x278e('0x35')][_0x278e('0x3a')](_0x278e('0x3b'))){_0x3f516a['limit']=qs['limit'](_0x492382[_0x278e('0x35')][_0x278e('0x1e')]);_0x3f516a[_0x278e('0x1d')]=qs[_0x278e('0x1d')](_0x492382[_0x278e('0x35')][_0x278e('0x1d')]);}_0x3f516a[_0x278e('0x62')]=qs[_0x278e('0x3c')](_0x492382['query'][_0x278e('0x3c')]);_0x3f516a[_0x278e('0x3d')]=qs['filters'](_[_0x278e('0x5d')](_0x492382['query'],_0x3f176e[_0x278e('0x37')]));_0x3f516a[_0x278e('0x3d')][_0x278e('0x5e')]=_0x787373['id'];if(_0x492382[_0x278e('0x35')]['filter']){_0x3f516a[_0x278e('0x3d')]=_[_0x278e('0x40')](_0x3f516a[_0x278e('0x3d')],{'$or':_[_0x278e('0x34')](_0x3f516a[_0x278e('0x38')],function(_0x17d9ca){var _0x43916d={};_0x43916d[_0x17d9ca]={'$like':'%'+_0x492382[_0x278e('0x35')][_0x278e('0x3f')]+'%'};return _0x43916d;})});}_0x3f516a=_[_0x278e('0x40')]({},_0x3f516a,_0x492382[_0x278e('0x41')]);return db[_0x278e('0x61')][_0x278e('0x20')]({'where':_0x3f516a[_0x278e('0x3d')]})['then'](function(_0x47e97d){_0xb3e777[_0x278e('0x20')]=_0x47e97d;if(_0x492382[_0x278e('0x35')]['includeAll']){_0x3f516a['include']=[{'all':!![]}];}return db[_0x278e('0x61')]['findAll'](_0x3f516a);})[_0x278e('0x28')](function(_0x1bbb9b){_0xb3e777[_0x278e('0x44')]=_0x1bbb9b;return _0xb3e777;});}})[_0x278e('0x28')](respondWithFilteredResult(_0x29be6f,_0x3f516a))[_0x278e('0x45')](handleError(_0x29be6f,null));};function char(_0x92281f){return _0x278e('0x63')===typeof _0x92281f?String['fromCharCode'][_0x278e('0x24')](null,arguments):_0x92281f;}function needsEncapsulation(_0x303287){return!!_0x303287&&(_0x303287[_0x278e('0x64')]()[_0x278e('0x65')](char(0xd))>=0x0||_0x303287[_0x278e('0x64')]()[_0x278e('0x65')](char(0xa))>=0x0||_0x303287[_0x278e('0x64')]()[_0x278e('0x65')](char(0x2c))>=0x0||_0x303287['toString']()[_0x278e('0x65')](char(0x22))>=0x0);}function encapsulate(_0x1e52a4){var _0x3ec15a=char(0x22),_0x13365c='\x5c'+char(0x22),_0x495bdc=_0x1e52a4[_0x278e('0x64')]()['replace'](new RegExp(_0x3ec15a,'g'),_0x13365c);return _0x3ec15a+_0x495bdc+_0x3ec15a;}exports[_0x278e('0x66')]=function(_0x379af8,_0x5f2a95,_0x30d91b){var _0x4bedd3,_0x1ce7e0;var _0x246a86={'where':{'ProjectId':_0x379af8[_0x278e('0x47')]['id']}};if(_0x379af8[_0x278e('0x35')][_0x278e('0x67')]){_0x246a86[_0x278e('0x3d')][_0x278e('0x68')]=JSON[_0x278e('0x69')](_0x379af8['query'][_0x278e('0x67')]);}return db[_0x278e('0x5c')][_0x278e('0x43')](_0x246a86)[_0x278e('0x28')](handleEntityNotFound(_0x5f2a95,null))[_0x278e('0x28')](function(_0x3c5b7e){if(_0x3c5b7e){_0x4bedd3=_0x3c5b7e;return db[_0x278e('0x6a')][_0x278e('0x43')]({'where':{'SessionId':{'$in':_['map'](_0x4bedd3,'id')},'ProjectId':_0x379af8[_0x278e('0x47')]['id']},'order':_0x278e('0x6b')});}})[_0x278e('0x28')](handleEntityNotFound(_0x5f2a95,null))[_0x278e('0x28')](function(_0x39d74c){if(_0x39d74c){_0x1ce7e0=_0x39d74c;var _0xbba205={};for(var _0x4ea066=0x0,_0x1db1b5=_0x1ce7e0[_0x278e('0x4a')];_0x4ea066<_0x1db1b5;_0x4ea066++){if(!_0xbba205[_0x278e('0x3a')](_0x1ce7e0[_0x4ea066][_0x278e('0x6c')])){_0xbba205[_0x1ce7e0[_0x4ea066]['questionId']]=needsEncapsulation(_0x1ce7e0[_0x4ea066][_0x278e('0x6d')])?encapsulate(_0x1ce7e0[_0x4ea066][_0x278e('0x6d')]):_0x1ce7e0[_0x4ea066][_0x278e('0x6d')];}}var _0x210320=[],_0x3ee6df={};for(var _0x919126=0x0,_0x1a41a0=_0x4bedd3[_0x278e('0x4a')];_0x919126<_0x1a41a0;_0x919126++){_0x3ee6df={'ProjectId':_0x379af8[_0x278e('0x47')]['id'],'SessionId':_0x4bedd3[_0x919126]['id'],'StartTime':moment(_0x4bedd3[_0x919126]['starttime'])['format'](_0x278e('0x6e'))};for(var _0x58a3b2=0x0,_0x25fcd2=_0x1ce7e0[_0x278e('0x4a')];_0x58a3b2<_0x25fcd2;_0x58a3b2++){if(_0x1ce7e0[_0x58a3b2][_0x278e('0x6f')]==_0x4bedd3[_0x919126]['id']&&_0xbba205[_0x278e('0x3a')](_0x1ce7e0[_0x58a3b2]['questionId'])){_0x3ee6df[_0xbba205[_0x1ce7e0[_0x58a3b2]['questionId']]]=_0x1ce7e0[_0x58a3b2][_0x278e('0x70')];}}for(var _0x47f567 in _0xbba205){if(!_0x3ee6df[_0x278e('0x3a')](_0xbba205[_0x47f567])){_0x3ee6df[_0xbba205[_0x47f567]]=null;}}_0x210320[_0x278e('0x71')](_0x3ee6df);}return _0x210320;}})[_0x278e('0x28')](function(_0x2386d1){if(!_[_0x278e('0x72')](_0x2386d1)){var _0x2c8768=toCsv(_0x2386d1);var _0x5d87e3=Date[_0x278e('0x73')]();fs[_0x278e('0x74')](util['format'](_0x278e('0x75'),_0x379af8[_0x278e('0x47')]['id'],_0x5d87e3),_0x2c8768);_0x5f2a95[_0x278e('0x76')](_0x278e('0x77'),'attachment;\x20filename='+util[_0x278e('0x78')]('Jscripty_Project_%d_Summary_%s.csv',_0x379af8['params']['id'],_0x5d87e3));_0x5f2a95['setHeader'](_0x278e('0x79'),_0x278e('0x7a'));return _0x5f2a95[_0x278e('0x7b')](util['format'](_0x278e('0x75'),_0x379af8['params']['id'],_0x5d87e3));}else{return _0x5f2a95[_0x278e('0x2b')](0xcc);}})[_0x278e('0x45')](handleError(_0x5f2a95,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff