// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x63c6=['stack','name','send','JscriptyProject','model','map','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','type','VIRTUAL','filter','merge','include','findAll','show','params','includeAll','options','find','catch','body','user','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','omit','updatedAt','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','getSessions','findOne','rawAttributes','pick','ProjectId','JscriptyAnswerReport','rows','number','toString','indexOf','replace','getSummary','startTime','starttime','parse','JscriptySessionReport','JscriptyQuestionReport','-createdAt','questionId','question','format','answer','push','isEmpty','now','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','Content-type','text/csv','download','eml-format','rimraf','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','update','then','destroy','get','Projects','UserProfileResource','error'];(function(_0x1d5c73,_0x12211c){var _0x5dc06d=function(_0x42bc3d){while(--_0x42bc3d){_0x1d5c73['push'](_0x1d5c73['shift']());}};_0x5dc06d(++_0x12211c);}(_0x63c6,0xbb));var _0x663c=function(_0x2336d5,_0x31aeb2){_0x2336d5=_0x2336d5-0x0;var _0x4ae1b1=_0x63c6[_0x2336d5];return _0x4ae1b1;};'use strict';var emlformat=require(_0x663c('0x0'));var rimraf=require(_0x663c('0x1'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x663c('0x2'));var moment=require(_0x663c('0x3'));var BPromise=require(_0x663c('0x4'));var Mustache=require(_0x663c('0x5'));var util=require(_0x663c('0x6'));var path=require(_0x663c('0x7'));var sox=require(_0x663c('0x8'));var csv=require(_0x663c('0x9'));var ejs=require(_0x663c('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x663c('0xb'));var squel=require(_0x663c('0xc'));var crypto=require(_0x663c('0xd'));var jsforce=require(_0x663c('0xe'));var deskjs=require('desk.js');var toCsv=require(_0x663c('0x9'));var querystring=require('querystring');var Papa=require(_0x663c('0xf'));var Redis=require('ioredis');var authService=require(_0x663c('0x10'));var qs=require(_0x663c('0x11'));var as=require(_0x663c('0x12'));var hardwareService=require(_0x663c('0x13'));var logger=require(_0x663c('0x14'))(_0x663c('0x15'));var utils=require(_0x663c('0x16'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0x663c('0x17'))['db'];function respondWithStatusCode(_0xe80d02,_0x588da1){_0x588da1=_0x588da1||0xcc;return function(_0x20038d){if(_0x20038d){return _0xe80d02[_0x663c('0x18')](_0x588da1);}return _0xe80d02[_0x663c('0x19')](_0x588da1)[_0x663c('0x1a')]();};}function respondWithResult(_0x5ef6af,_0xa119a1){_0xa119a1=_0xa119a1||0xc8;return function(_0x165454){if(_0x165454){return _0x5ef6af['status'](_0xa119a1)[_0x663c('0x1b')](_0x165454);}};}function respondWithFilteredResult(_0x523322,_0x44ffaa){return function(_0xb1e1bf){if(_0xb1e1bf){var _0x2a7b0d=typeof _0x44ffaa[_0x663c('0x1c')]===_0x663c('0x1d')&&typeof _0x44ffaa[_0x663c('0x1e')]===_0x663c('0x1d');var _0x41cc9d=_0xb1e1bf[_0x663c('0x1f')];var _0x3c87fe=_0x2a7b0d?0x0:_0x44ffaa['offset'];var _0x2fd707=_0x2a7b0d?_0xb1e1bf[_0x663c('0x1f')]:_0x44ffaa[_0x663c('0x1c')]+_0x44ffaa['limit'];var _0x137670;if(_0x2fd707>=_0x41cc9d){_0x2fd707=_0x41cc9d;_0x137670=0xc8;}else{_0x137670=0xce;}_0x523322[_0x663c('0x19')](_0x137670);return _0x523322[_0x663c('0x20')](_0x663c('0x21'),_0x3c87fe+'-'+_0x2fd707+'/'+_0x41cc9d)[_0x663c('0x1b')](_0xb1e1bf);}return null;};}function patchUpdates(_0x54fa2f){return function(_0xcf6ced){try{jsonpatch[_0x663c('0x22')](_0xcf6ced,_0x54fa2f,!![]);}catch(_0x319224){return BPromise[_0x663c('0x23')](_0x319224);}return _0xcf6ced['save']();};}function saveUpdates(_0x5a9e96,_0x2ac148){return function(_0x34135d){if(_0x34135d){return _0x34135d[_0x663c('0x24')](_0x5a9e96)[_0x663c('0x25')](function(_0x352a21){return _0x352a21;});}return null;};}function removeEntity(_0x53986f,_0x4984dc){return function(_0x4b7213){if(_0x4b7213){return _0x4b7213[_0x663c('0x26')]()[_0x663c('0x25')](function(){var _0x35842e=_0x4b7213[_0x663c('0x27')]({'plain':!![]});var _0x5e6b45=_0x663c('0x28');return db[_0x663c('0x29')][_0x663c('0x26')]({'where':{'type':_0x5e6b45,'resourceId':_0x35842e['id']}})[_0x663c('0x25')](function(){return _0x4b7213;});})[_0x663c('0x25')](function(){_0x53986f['status'](0xcc)[_0x663c('0x1a')]();});}};}function handleEntityNotFound(_0x594a49,_0x5ae88d){return function(_0x5ead23){if(!_0x5ead23){_0x594a49['sendStatus'](0x194);}return _0x5ead23;};}function handleError(_0x34cd8c,_0x502921){_0x502921=_0x502921||0x1f4;return function(_0x16f30b){logger[_0x663c('0x2a')](_0x16f30b[_0x663c('0x2b')]);if(_0x16f30b[_0x663c('0x2c')]){delete _0x16f30b[_0x663c('0x2c')];}_0x34cd8c[_0x663c('0x19')](_0x502921)[_0x663c('0x2d')](_0x16f30b);};}exports['index']=function(_0x61ebd3,_0x29f074){var _0x43ad67={},_0x248345={},_0x3b3d39={'count':0x0,'rows':[]};var _0x242ba7=_['map'](db[_0x663c('0x2e')]['rawAttributes'],function(_0x1cacb6){return{'name':_0x1cacb6['fieldName'],'type':_0x1cacb6['type']['key']};});_0x248345[_0x663c('0x2f')]=_[_0x663c('0x30')](_0x242ba7,'name');_0x248345[_0x663c('0x31')]=_[_0x663c('0x32')](_0x61ebd3['query']);_0x248345[_0x663c('0x33')]=_[_0x663c('0x34')](_0x248345[_0x663c('0x2f')],_0x248345[_0x663c('0x31')]);_0x43ad67[_0x663c('0x35')]=_['intersection'](_0x248345[_0x663c('0x2f')],qs[_0x663c('0x36')](_0x61ebd3[_0x663c('0x31')]['fields']));_0x43ad67[_0x663c('0x35')]=_0x43ad67[_0x663c('0x35')][_0x663c('0x37')]?_0x43ad67[_0x663c('0x35')]:_0x248345['model'];if(!_0x61ebd3[_0x663c('0x31')][_0x663c('0x38')](_0x663c('0x39'))){_0x43ad67[_0x663c('0x1e')]=qs['limit'](_0x61ebd3['query'][_0x663c('0x1e')]);_0x43ad67[_0x663c('0x1c')]=qs['offset'](_0x61ebd3[_0x663c('0x31')][_0x663c('0x1c')]);}_0x43ad67[_0x663c('0x3a')]=qs[_0x663c('0x3b')](_0x61ebd3['query'][_0x663c('0x3b')]);_0x43ad67[_0x663c('0x3c')]=qs['filters'](_['pick'](_0x61ebd3[_0x663c('0x31')],_0x248345[_0x663c('0x33')]),_0x242ba7);if(_0x61ebd3[_0x663c('0x31')]['filter']){_0x43ad67[_0x663c('0x3c')]=_['merge'](_0x43ad67[_0x663c('0x3c')],{'$or':_['map'](_0x242ba7,function(_0x130354){if(_0x130354[_0x663c('0x3d')]!==_0x663c('0x3e')){var _0x52ab93={};_0x52ab93[_0x130354[_0x663c('0x2c')]]={'$like':'%'+_0x61ebd3[_0x663c('0x31')][_0x663c('0x3f')]+'%'};return _0x52ab93;}})});}_0x43ad67=_[_0x663c('0x40')]({},_0x43ad67,_0x61ebd3['options']);var _0x1ff218={'where':_0x43ad67[_0x663c('0x3c')]};return db[_0x663c('0x2e')][_0x663c('0x1f')](_0x1ff218)['then'](function(_0x1ce911){_0x3b3d39[_0x663c('0x1f')]=_0x1ce911;if(_0x61ebd3[_0x663c('0x31')]['includeAll']){_0x43ad67[_0x663c('0x41')]=[{'all':!![]}];}return db[_0x663c('0x2e')][_0x663c('0x42')](_0x43ad67);})['then'](function(_0x14f55f){_0x3b3d39['rows']=_0x14f55f;return _0x3b3d39;})[_0x663c('0x25')](respondWithFilteredResult(_0x29f074,_0x43ad67))['catch'](handleError(_0x29f074,null));};exports[_0x663c('0x43')]=function(_0x443842,_0x188e12){var _0x53e821={'raw':![],'where':{'id':_0x443842[_0x663c('0x44')]['id']}},_0x31f0a5={};_0x31f0a5[_0x663c('0x2f')]=_['keys'](db[_0x663c('0x2e')]['rawAttributes']);_0x31f0a5[_0x663c('0x31')]=_[_0x663c('0x32')](_0x443842[_0x663c('0x31')]);_0x31f0a5['filters']=_[_0x663c('0x34')](_0x31f0a5[_0x663c('0x2f')],_0x31f0a5[_0x663c('0x31')]);_0x53e821[_0x663c('0x35')]=_[_0x663c('0x34')](_0x31f0a5[_0x663c('0x2f')],qs[_0x663c('0x36')](_0x443842[_0x663c('0x31')][_0x663c('0x36')]));_0x53e821['attributes']=_0x53e821[_0x663c('0x35')][_0x663c('0x37')]?_0x53e821[_0x663c('0x35')]:_0x31f0a5[_0x663c('0x2f')];if(_0x443842[_0x663c('0x31')][_0x663c('0x45')]){_0x53e821[_0x663c('0x41')]=[{'all':!![]}];}_0x53e821=_['merge']({},_0x53e821,_0x443842[_0x663c('0x46')]);return db[_0x663c('0x2e')][_0x663c('0x47')](_0x53e821)[_0x663c('0x25')](handleEntityNotFound(_0x188e12,null))[_0x663c('0x25')](respondWithResult(_0x188e12,null))[_0x663c('0x48')](handleError(_0x188e12,null));};exports['create']=function(_0x3396b1,_0x685df3){return db[_0x663c('0x2e')]['create'](_0x3396b1[_0x663c('0x49')],{})['then'](function(_0x4320cc){var _0x3330c0=_0x3396b1[_0x663c('0x4a')][_0x663c('0x27')]({'plain':!![]});if(!_0x3330c0)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x3330c0['role']===_0x663c('0x4a')){var _0x1d4619=_0x4320cc[_0x663c('0x27')]({'plain':!![]});var _0x3d8c62=_0x663c('0x28');return db[_0x663c('0x4b')][_0x663c('0x47')]({'where':{'name':_0x3d8c62,'userProfileId':_0x3330c0[_0x663c('0x4c')]},'raw':!![]})[_0x663c('0x25')](function(_0x1754d8){if(_0x1754d8&&_0x1754d8[_0x663c('0x4d')]===0x0){return db[_0x663c('0x29')]['create']({'name':_0x1d4619['name'],'resourceId':_0x1d4619['id'],'type':_0x1754d8[_0x663c('0x2c')],'sectionId':_0x1754d8['id']},{})[_0x663c('0x25')](function(){return _0x4320cc;});}else{return _0x4320cc;}})['catch'](function(_0x44794d){logger[_0x663c('0x2a')](_0x663c('0x4e'),_0x44794d);throw _0x44794d;});}return _0x4320cc;})['then'](respondWithResult(_0x685df3,0xc9))['catch'](handleError(_0x685df3,null));};exports['clone']=function(_0x4d26e5,_0x2511e5){var _0x47b37a={'where':{'id':_0x4d26e5[_0x663c('0x44')]['id']}},_0x154f11={};_0x154f11['model']=_[_0x663c('0x32')](db[_0x663c('0x2e')]['rawAttributes']);_0x47b37a['attributes']=_[_0x663c('0x34')](_0x154f11['model'],qs[_0x663c('0x36')](_0x4d26e5[_0x663c('0x31')]['fields']));_0x47b37a[_0x663c('0x35')]=_0x47b37a[_0x663c('0x35')][_0x663c('0x37')]?_0x47b37a[_0x663c('0x35')]:_0x154f11[_0x663c('0x2f')];if(_0x4d26e5[_0x663c('0x31')][_0x663c('0x45')]){_0x47b37a[_0x663c('0x41')]=[{'all':!![]}];}_0x47b37a=_[_0x663c('0x40')]({},_0x47b37a,_0x4d26e5[_0x663c('0x46')]);return db[_0x663c('0x2e')][_0x663c('0x47')](_0x47b37a)[_0x663c('0x25')](handleEntityNotFound(_0x2511e5,null))[_0x663c('0x25')](function(_0x5a1e34){if(_0x5a1e34){var _0x4df741=_0x5a1e34[_0x663c('0x27')]({'plain':!![]});_0x4df741=qs[_0x663c('0x4f')](_0x4df741,['id','createdAt',_0x663c('0x50')]);_0x4d26e5[_0x663c('0x49')]=_[_0x663c('0x4f')](_0x4d26e5[_0x663c('0x49')],['id','createdAt',_0x663c('0x50')]);return db['JscriptyProject']['create'](_[_0x663c('0x40')](_0x4df741,_0x4d26e5[_0x663c('0x49')]),{'include':_0x4d26e5[_0x663c('0x31')]['includeAll']?[{'all':!![]}]:undefined})[_0x663c('0x25')](function(_0x4050c5){var _0x2eee6c=_0x4d26e5[_0x663c('0x4a')][_0x663c('0x27')]({'plain':!![]});if(!_0x2eee6c)throw new Error(_0x663c('0x51'));if(_0x2eee6c[_0x663c('0x52')]===_0x663c('0x4a')){var _0x392887=_0x4050c5[_0x663c('0x27')]({'plain':!![]});var _0x13ef62='Projects';return db[_0x663c('0x4b')][_0x663c('0x47')]({'where':{'name':_0x13ef62,'userProfileId':_0x2eee6c[_0x663c('0x4c')]},'raw':!![]})[_0x663c('0x25')](function(_0x1b8208){if(_0x1b8208&&_0x1b8208['autoAssociation']===0x0){return db[_0x663c('0x29')]['create']({'name':_0x392887['name'],'resourceId':_0x392887['id'],'type':_0x1b8208[_0x663c('0x2c')],'sectionId':_0x1b8208['id']},{})['then'](function(){return _0x4050c5;});}else{return _0x4050c5;}})['catch'](function(_0x3df0ae){logger[_0x663c('0x2a')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x3df0ae);throw _0x3df0ae;});}return _0x4050c5;});}})[_0x663c('0x25')](respondWithResult(_0x2511e5,0xc9))[_0x663c('0x48')](handleError(_0x2511e5,null));};exports['update']=function(_0x5034d7,_0x170fcb){if(_0x5034d7[_0x663c('0x49')]['id']){delete _0x5034d7[_0x663c('0x49')]['id'];}return db[_0x663c('0x2e')][_0x663c('0x47')]({'where':{'id':_0x5034d7[_0x663c('0x44')]['id']}})[_0x663c('0x25')](handleEntityNotFound(_0x170fcb,null))['then'](saveUpdates(_0x5034d7[_0x663c('0x49')],null))['then'](respondWithResult(_0x170fcb,null))[_0x663c('0x48')](handleError(_0x170fcb,null));};exports[_0x663c('0x26')]=function(_0x381f84,_0x562ef5){return db[_0x663c('0x2e')][_0x663c('0x47')]({'where':{'id':_0x381f84[_0x663c('0x44')]['id']}})[_0x663c('0x25')](handleEntityNotFound(_0x562ef5,null))[_0x663c('0x25')](removeEntity(_0x562ef5,null))[_0x663c('0x48')](handleError(_0x562ef5,null));};exports[_0x663c('0x53')]=function(_0x197866,_0x2bea07,_0x3c7a3a){var _0x1b63d1={'raw':!![],'where':{}};var _0x14fc19={};var _0x38efea={'count':0x0,'rows':[]};return db[_0x663c('0x2e')][_0x663c('0x54')]({'where':{'id':_0x197866['params']['id']}})[_0x663c('0x25')](handleEntityNotFound(_0x2bea07,null))[_0x663c('0x25')](function(_0xbb6324){if(_0xbb6324){_0x14fc19['model']=_[_0x663c('0x32')](db['JscriptySessionReport'][_0x663c('0x55')]);_0x14fc19['query']=_[_0x663c('0x32')](_0x197866['query']);_0x14fc19[_0x663c('0x33')]=_[_0x663c('0x34')](_0x14fc19[_0x663c('0x2f')],_0x14fc19[_0x663c('0x31')]);_0x1b63d1[_0x663c('0x35')]=_[_0x663c('0x34')](_0x14fc19[_0x663c('0x2f')],qs[_0x663c('0x36')](_0x197866[_0x663c('0x31')]['fields']));_0x1b63d1[_0x663c('0x35')]=_0x1b63d1['attributes'][_0x663c('0x37')]?_0x1b63d1[_0x663c('0x35')]:_0x14fc19[_0x663c('0x2f')];if(!_0x197866['query'][_0x663c('0x38')](_0x663c('0x39'))){_0x1b63d1['limit']=qs[_0x663c('0x1e')](_0x197866[_0x663c('0x31')]['limit']);_0x1b63d1[_0x663c('0x1c')]=qs[_0x663c('0x1c')](_0x197866[_0x663c('0x31')][_0x663c('0x1c')]);}_0x1b63d1[_0x663c('0x3a')]=qs[_0x663c('0x3b')](_0x197866[_0x663c('0x31')][_0x663c('0x3b')]);_0x1b63d1[_0x663c('0x3c')]=qs['filters'](_[_0x663c('0x56')](_0x197866[_0x663c('0x31')],_0x14fc19['filters']));_0x1b63d1[_0x663c('0x3c')][_0x663c('0x57')]=_0xbb6324['id'];if(_0x197866[_0x663c('0x31')][_0x663c('0x3f')]){_0x1b63d1['where']=_[_0x663c('0x40')](_0x1b63d1[_0x663c('0x3c')],{'$or':_[_0x663c('0x30')](_0x1b63d1[_0x663c('0x35')],function(_0x49b88a){var _0x13e40a={};_0x13e40a[_0x49b88a]={'$like':'%'+_0x197866[_0x663c('0x31')]['filter']+'%'};return _0x13e40a;})});}_0x1b63d1=_['merge']({},_0x1b63d1,_0x197866[_0x663c('0x46')]);return db['JscriptySessionReport'][_0x663c('0x1f')]({'where':_0x1b63d1[_0x663c('0x3c')]})[_0x663c('0x25')](function(_0x592c4f){_0x38efea[_0x663c('0x1f')]=_0x592c4f;if(_0x197866[_0x663c('0x31')]['includeAll']){_0x1b63d1[_0x663c('0x41')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0x663c('0x42')](_0x1b63d1);})[_0x663c('0x25')](function(_0x2253e6){_0x38efea['rows']=_0x2253e6;return _0x38efea;});}})['then'](respondWithFilteredResult(_0x2bea07,_0x1b63d1))[_0x663c('0x48')](handleError(_0x2bea07,null));};exports['getAnswers']=function(_0x1e8ecc,_0x67c1a0,_0x310839){var _0x582a9e={'raw':!![],'where':{}};var _0x51a63a={};var _0x5cb07b={'count':0x0,'rows':[]};return db[_0x663c('0x2e')]['findOne']({'where':{'id':_0x1e8ecc[_0x663c('0x44')]['id']}})[_0x663c('0x25')](handleEntityNotFound(_0x67c1a0,null))[_0x663c('0x25')](function(_0x166051){if(_0x166051){_0x51a63a[_0x663c('0x2f')]=_[_0x663c('0x32')](db['JscriptyAnswerReport']['rawAttributes']);_0x51a63a[_0x663c('0x31')]=_[_0x663c('0x32')](_0x1e8ecc[_0x663c('0x31')]);_0x51a63a[_0x663c('0x33')]=_['intersection'](_0x51a63a[_0x663c('0x2f')],_0x51a63a['query']);_0x582a9e[_0x663c('0x35')]=_['intersection'](_0x51a63a['model'],qs['fields'](_0x1e8ecc[_0x663c('0x31')][_0x663c('0x36')]));_0x582a9e[_0x663c('0x35')]=_0x582a9e['attributes'][_0x663c('0x37')]?_0x582a9e[_0x663c('0x35')]:_0x51a63a[_0x663c('0x2f')];if(!_0x1e8ecc['query']['hasOwnProperty'](_0x663c('0x39'))){_0x582a9e[_0x663c('0x1e')]=qs[_0x663c('0x1e')](_0x1e8ecc['query'][_0x663c('0x1e')]);_0x582a9e[_0x663c('0x1c')]=qs[_0x663c('0x1c')](_0x1e8ecc[_0x663c('0x31')][_0x663c('0x1c')]);}_0x582a9e[_0x663c('0x3a')]=qs[_0x663c('0x3b')](_0x1e8ecc[_0x663c('0x31')][_0x663c('0x3b')]);_0x582a9e[_0x663c('0x3c')]=qs[_0x663c('0x33')](_[_0x663c('0x56')](_0x1e8ecc[_0x663c('0x31')],_0x51a63a['filters']));_0x582a9e[_0x663c('0x3c')][_0x663c('0x57')]=_0x166051['id'];if(_0x1e8ecc['query']['filter']){_0x582a9e[_0x663c('0x3c')]=_['merge'](_0x582a9e['where'],{'$or':_['map'](_0x582a9e['attributes'],function(_0xf18f13){var _0x1fe5f9={};_0x1fe5f9[_0xf18f13]={'$like':'%'+_0x1e8ecc[_0x663c('0x31')][_0x663c('0x3f')]+'%'};return _0x1fe5f9;})});}_0x582a9e=_['merge']({},_0x582a9e,_0x1e8ecc[_0x663c('0x46')]);return db['JscriptyAnswerReport']['count']({'where':_0x582a9e[_0x663c('0x3c')]})[_0x663c('0x25')](function(_0xc228c8){_0x5cb07b[_0x663c('0x1f')]=_0xc228c8;if(_0x1e8ecc['query'][_0x663c('0x45')]){_0x582a9e['include']=[{'all':!![]}];}return db[_0x663c('0x58')][_0x663c('0x42')](_0x582a9e);})[_0x663c('0x25')](function(_0x50bbab){_0x5cb07b[_0x663c('0x59')]=_0x50bbab;return _0x5cb07b;});}})['then'](respondWithFilteredResult(_0x67c1a0,_0x582a9e))[_0x663c('0x48')](handleError(_0x67c1a0,null));};function char(_0x2f9162){return _0x663c('0x5a')===typeof _0x2f9162?String['fromCharCode'][_0x663c('0x22')](null,arguments):_0x2f9162;}function needsEncapsulation(_0x3c78db){return!!_0x3c78db&&(_0x3c78db[_0x663c('0x5b')]()[_0x663c('0x5c')](char(0xd))>=0x0||_0x3c78db['toString']()[_0x663c('0x5c')](char(0xa))>=0x0||_0x3c78db[_0x663c('0x5b')]()[_0x663c('0x5c')](char(0x2c))>=0x0||_0x3c78db[_0x663c('0x5b')]()[_0x663c('0x5c')](char(0x22))>=0x0);}function encapsulate(_0x68fbfd){var _0xa01edc=char(0x22),_0x4f6d6a='\x5c'+char(0x22),_0xa1481f=_0x68fbfd[_0x663c('0x5b')]()[_0x663c('0x5d')](new RegExp(_0xa01edc,'g'),_0x4f6d6a);return _0xa01edc+_0xa1481f+_0xa01edc;}exports[_0x663c('0x5e')]=function(_0x4feb24,_0x19d2de,_0x3605ef){var _0x1e80ad,_0x44c255;var _0x4a4840={'where':{'ProjectId':_0x4feb24[_0x663c('0x44')]['id']}};if(_0x4feb24[_0x663c('0x31')][_0x663c('0x5f')]){_0x4a4840['where'][_0x663c('0x60')]=JSON[_0x663c('0x61')](_0x4feb24[_0x663c('0x31')][_0x663c('0x5f')]);}return db[_0x663c('0x62')]['findAll'](_0x4a4840)['then'](handleEntityNotFound(_0x19d2de,null))[_0x663c('0x25')](function(_0x46dcc8){if(_0x46dcc8){_0x1e80ad=_0x46dcc8;return db[_0x663c('0x63')]['findAll']({'where':{'SessionId':{'$in':_[_0x663c('0x30')](_0x1e80ad,'id')},'ProjectId':_0x4feb24[_0x663c('0x44')]['id']},'order':_0x663c('0x64')});}})[_0x663c('0x25')](handleEntityNotFound(_0x19d2de,null))[_0x663c('0x25')](function(_0x21b85c){if(_0x21b85c){_0x44c255=_0x21b85c;var _0xa51dfb={};for(var _0xc662d8=0x0,_0x3dce88=_0x44c255[_0x663c('0x37')];_0xc662d8<_0x3dce88;_0xc662d8++){if(!_0xa51dfb[_0x663c('0x38')](_0x44c255[_0xc662d8][_0x663c('0x65')])){_0xa51dfb[_0x44c255[_0xc662d8][_0x663c('0x65')]]=needsEncapsulation(_0x44c255[_0xc662d8][_0x663c('0x66')])?encapsulate(_0x44c255[_0xc662d8][_0x663c('0x66')]):_0x44c255[_0xc662d8][_0x663c('0x66')];}}var _0xd8e286=[],_0x2c51b1={};for(var _0x4c2b73=0x0,_0x477821=_0x1e80ad[_0x663c('0x37')];_0x4c2b73<_0x477821;_0x4c2b73++){_0x2c51b1={'ProjectId':_0x4feb24[_0x663c('0x44')]['id'],'SessionId':_0x1e80ad[_0x4c2b73]['id'],'StartTime':moment(_0x1e80ad[_0x4c2b73][_0x663c('0x60')])[_0x663c('0x67')]('YYYY-MM-DD\x20HH:mm:ss')};for(var _0x1c2ee7=0x0,_0x474862=_0x44c255[_0x663c('0x37')];_0x1c2ee7<_0x474862;_0x1c2ee7++){if(_0x44c255[_0x1c2ee7]['SessionId']==_0x1e80ad[_0x4c2b73]['id']&&_0xa51dfb[_0x663c('0x38')](_0x44c255[_0x1c2ee7]['questionId'])){_0x2c51b1[_0xa51dfb[_0x44c255[_0x1c2ee7][_0x663c('0x65')]]]=_0x44c255[_0x1c2ee7][_0x663c('0x68')];}}for(var _0x5f26bc in _0xa51dfb){if(!_0x2c51b1[_0x663c('0x38')](_0xa51dfb[_0x5f26bc])){_0x2c51b1[_0xa51dfb[_0x5f26bc]]=null;}}_0xd8e286[_0x663c('0x69')](_0x2c51b1);}return _0xd8e286;}})['then'](function(_0x3dc753){if(!_[_0x663c('0x6a')](_0x3dc753)){var _0x27fca4=toCsv(_0x3dc753);var _0x31e476=Date[_0x663c('0x6b')]();fs['writeFileSync'](util[_0x663c('0x67')](_0x663c('0x6c'),_0x4feb24[_0x663c('0x44')]['id'],_0x31e476),_0x27fca4);_0x19d2de[_0x663c('0x6d')]('Content-disposition',_0x663c('0x6e')+util[_0x663c('0x67')](_0x663c('0x6f'),_0x4feb24[_0x663c('0x44')]['id'],_0x31e476));_0x19d2de[_0x663c('0x6d')](_0x663c('0x70'),_0x663c('0x71'));return _0x19d2de[_0x663c('0x72')](util[_0x663c('0x67')](_0x663c('0x6c'),_0x4feb24[_0x663c('0x44')]['id'],_0x31e476));}else{return _0x19d2de[_0x663c('0x18')](0xcc);}})[_0x663c('0x48')](handleError(_0x19d2de,null));};
\ No newline at end of file
+var _0xefe3=['/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','Content-disposition','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','Content-type','download','eml-format','request-promise','moment','bluebird','mustache','path','to-csv','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','count','limit','set','Content-Range','apply','reject','save','then','destroy','get','Projects','UserProfileResource','error','name','map','rawAttributes','fieldName','key','query','attributes','model','fields','length','hasOwnProperty','nolimit','sort','where','pick','filters','merge','type','VIRTUAL','filter','options','JscriptyProject','includeAll','include','rows','catch','show','params','intersection','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','keys','updatedAt','omit','body','createdAt','update','getSessions','findOne','order','ProjectId','JscriptySessionReport','findAll','getAnswers','JscriptyAnswerReport','number','fromCharCode','toString','indexOf','getSummary','startTime','-createdAt','questionId','question','starttime','format','YYYY-MM-DD\x20HH:mm:ss','answer','push','isEmpty','now','writeFileSync'];(function(_0x24482d,_0x3a5def){var _0x7ce70=function(_0x21fe28){while(--_0x21fe28){_0x24482d['push'](_0x24482d['shift']());}};_0x7ce70(++_0x3a5def);}(_0xefe3,0xf5));var _0x3efe=function(_0x122ef9,_0x451d2a){_0x122ef9=_0x122ef9-0x0;var _0x42fba0=_0xefe3[_0x122ef9];return _0x42fba0;};'use strict';var emlformat=require(_0x3efe('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0x3efe('0x1'));var moment=require(_0x3efe('0x2'));var BPromise=require(_0x3efe('0x3'));var Mustache=require(_0x3efe('0x4'));var util=require('util');var path=require(_0x3efe('0x5'));var sox=require('sox');var csv=require(_0x3efe('0x6'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x3efe('0x7'));var _=require(_0x3efe('0x8'));var squel=require(_0x3efe('0x9'));var crypto=require(_0x3efe('0xa'));var jsforce=require(_0x3efe('0xb'));var deskjs=require(_0x3efe('0xc'));var toCsv=require('to-csv');var querystring=require(_0x3efe('0xd'));var Papa=require('papaparse');var Redis=require(_0x3efe('0xe'));var authService=require(_0x3efe('0xf'));var qs=require(_0x3efe('0x10'));var as=require(_0x3efe('0x11'));var hardwareService=require(_0x3efe('0x12'));var logger=require(_0x3efe('0x13'))('api');var utils=require('../../config/utils');var config=require(_0x3efe('0x14'));var licenseUtil=require(_0x3efe('0x15'));var db=require(_0x3efe('0x16'))['db'];function respondWithStatusCode(_0x3ad584,_0x11b9b4){_0x11b9b4=_0x11b9b4||0xcc;return function(_0x3778ec){if(_0x3778ec){return _0x3ad584[_0x3efe('0x17')](_0x11b9b4);}return _0x3ad584[_0x3efe('0x18')](_0x11b9b4)[_0x3efe('0x19')]();};}function respondWithResult(_0x44bdbf,_0x2dd99f){_0x2dd99f=_0x2dd99f||0xc8;return function(_0x49f4ff){if(_0x49f4ff){return _0x44bdbf[_0x3efe('0x18')](_0x2dd99f)[_0x3efe('0x1a')](_0x49f4ff);}};}function respondWithFilteredResult(_0x1e1ce9,_0x230785){return function(_0x4a3d0d){if(_0x4a3d0d){var _0x219ecf=typeof _0x230785[_0x3efe('0x1b')]===_0x3efe('0x1c')&&typeof _0x230785['limit']==='undefined';var _0x3adf52=_0x4a3d0d[_0x3efe('0x1d')];var _0x26a8c4=_0x219ecf?0x0:_0x230785[_0x3efe('0x1b')];var _0x433c53=_0x219ecf?_0x4a3d0d[_0x3efe('0x1d')]:_0x230785['offset']+_0x230785[_0x3efe('0x1e')];var _0x30b3fb;if(_0x433c53>=_0x3adf52){_0x433c53=_0x3adf52;_0x30b3fb=0xc8;}else{_0x30b3fb=0xce;}_0x1e1ce9[_0x3efe('0x18')](_0x30b3fb);return _0x1e1ce9[_0x3efe('0x1f')](_0x3efe('0x20'),_0x26a8c4+'-'+_0x433c53+'/'+_0x3adf52)[_0x3efe('0x1a')](_0x4a3d0d);}return null;};}function patchUpdates(_0x41cfcd){return function(_0x2b2c09){try{jsonpatch[_0x3efe('0x21')](_0x2b2c09,_0x41cfcd,!![]);}catch(_0x49392e){return BPromise[_0x3efe('0x22')](_0x49392e);}return _0x2b2c09[_0x3efe('0x23')]();};}function saveUpdates(_0x3403ce,_0x3b6464){return function(_0x4a3fdb){if(_0x4a3fdb){return _0x4a3fdb['update'](_0x3403ce)[_0x3efe('0x24')](function(_0x2891b1){return _0x2891b1;});}return null;};}function removeEntity(_0x5d9601,_0x5c8b1d){return function(_0x2aec5c){if(_0x2aec5c){return _0x2aec5c[_0x3efe('0x25')]()[_0x3efe('0x24')](function(){var _0x252c27=_0x2aec5c[_0x3efe('0x26')]({'plain':!![]});var _0x39fc88=_0x3efe('0x27');return db[_0x3efe('0x28')][_0x3efe('0x25')]({'where':{'type':_0x39fc88,'resourceId':_0x252c27['id']}})['then'](function(){return _0x2aec5c;});})[_0x3efe('0x24')](function(){_0x5d9601['status'](0xcc)[_0x3efe('0x19')]();});}};}function handleEntityNotFound(_0x21c15d,_0x5cbe1a){return function(_0x25bf85){if(!_0x25bf85){_0x21c15d[_0x3efe('0x17')](0x194);}return _0x25bf85;};}function handleError(_0x331a83,_0x4cedac){_0x4cedac=_0x4cedac||0x1f4;return function(_0xdedd1c){logger[_0x3efe('0x29')](_0xdedd1c['stack']);if(_0xdedd1c[_0x3efe('0x2a')]){delete _0xdedd1c[_0x3efe('0x2a')];}_0x331a83[_0x3efe('0x18')](_0x4cedac)['send'](_0xdedd1c);};}exports['index']=function(_0x2e2d68,_0x34229c){var _0x423056={},_0x1f08e2={},_0x45d873={'count':0x0,'rows':[]};var _0x1f271b=_[_0x3efe('0x2b')](db['JscriptyProject'][_0x3efe('0x2c')],function(_0x574d53){return{'name':_0x574d53[_0x3efe('0x2d')],'type':_0x574d53['type'][_0x3efe('0x2e')]};});_0x1f08e2['model']=_[_0x3efe('0x2b')](_0x1f271b,'name');_0x1f08e2['query']=_['keys'](_0x2e2d68[_0x3efe('0x2f')]);_0x1f08e2['filters']=_['intersection'](_0x1f08e2['model'],_0x1f08e2[_0x3efe('0x2f')]);_0x423056[_0x3efe('0x30')]=_['intersection'](_0x1f08e2[_0x3efe('0x31')],qs[_0x3efe('0x32')](_0x2e2d68[_0x3efe('0x2f')][_0x3efe('0x32')]));_0x423056[_0x3efe('0x30')]=_0x423056[_0x3efe('0x30')][_0x3efe('0x33')]?_0x423056[_0x3efe('0x30')]:_0x1f08e2[_0x3efe('0x31')];if(!_0x2e2d68[_0x3efe('0x2f')][_0x3efe('0x34')](_0x3efe('0x35'))){_0x423056[_0x3efe('0x1e')]=qs[_0x3efe('0x1e')](_0x2e2d68[_0x3efe('0x2f')][_0x3efe('0x1e')]);_0x423056[_0x3efe('0x1b')]=qs[_0x3efe('0x1b')](_0x2e2d68[_0x3efe('0x2f')][_0x3efe('0x1b')]);}_0x423056['order']=qs[_0x3efe('0x36')](_0x2e2d68[_0x3efe('0x2f')]['sort']);_0x423056[_0x3efe('0x37')]=qs['filters'](_[_0x3efe('0x38')](_0x2e2d68[_0x3efe('0x2f')],_0x1f08e2[_0x3efe('0x39')]),_0x1f271b);if(_0x2e2d68[_0x3efe('0x2f')]['filter']){_0x423056['where']=_[_0x3efe('0x3a')](_0x423056['where'],{'$or':_[_0x3efe('0x2b')](_0x1f271b,function(_0x398cf2){if(_0x398cf2[_0x3efe('0x3b')]!==_0x3efe('0x3c')){var _0x1448ce={};_0x1448ce[_0x398cf2[_0x3efe('0x2a')]]={'$like':'%'+_0x2e2d68['query'][_0x3efe('0x3d')]+'%'};return _0x1448ce;}})});}_0x423056=_[_0x3efe('0x3a')]({},_0x423056,_0x2e2d68[_0x3efe('0x3e')]);var _0xd26138={'where':_0x423056[_0x3efe('0x37')]};return db[_0x3efe('0x3f')]['count'](_0xd26138)[_0x3efe('0x24')](function(_0xf2622c){_0x45d873[_0x3efe('0x1d')]=_0xf2622c;if(_0x2e2d68['query'][_0x3efe('0x40')]){_0x423056[_0x3efe('0x41')]=[{'all':!![]}];}return db['JscriptyProject']['findAll'](_0x423056);})['then'](function(_0x4640db){_0x45d873[_0x3efe('0x42')]=_0x4640db;return _0x45d873;})['then'](respondWithFilteredResult(_0x34229c,_0x423056))[_0x3efe('0x43')](handleError(_0x34229c,null));};exports[_0x3efe('0x44')]=function(_0x4de5f8,_0x838267){var _0x5b79f4={'raw':![],'where':{'id':_0x4de5f8[_0x3efe('0x45')]['id']}},_0x2718dc={};_0x2718dc[_0x3efe('0x31')]=_['keys'](db[_0x3efe('0x3f')][_0x3efe('0x2c')]);_0x2718dc[_0x3efe('0x2f')]=_['keys'](_0x4de5f8[_0x3efe('0x2f')]);_0x2718dc[_0x3efe('0x39')]=_['intersection'](_0x2718dc[_0x3efe('0x31')],_0x2718dc[_0x3efe('0x2f')]);_0x5b79f4[_0x3efe('0x30')]=_[_0x3efe('0x46')](_0x2718dc[_0x3efe('0x31')],qs[_0x3efe('0x32')](_0x4de5f8[_0x3efe('0x2f')][_0x3efe('0x32')]));_0x5b79f4[_0x3efe('0x30')]=_0x5b79f4[_0x3efe('0x30')][_0x3efe('0x33')]?_0x5b79f4['attributes']:_0x2718dc['model'];if(_0x4de5f8[_0x3efe('0x2f')][_0x3efe('0x40')]){_0x5b79f4[_0x3efe('0x41')]=[{'all':!![]}];}_0x5b79f4=_[_0x3efe('0x3a')]({},_0x5b79f4,_0x4de5f8['options']);return db[_0x3efe('0x3f')][_0x3efe('0x47')](_0x5b79f4)['then'](handleEntityNotFound(_0x838267,null))[_0x3efe('0x24')](respondWithResult(_0x838267,null))[_0x3efe('0x43')](handleError(_0x838267,null));};exports[_0x3efe('0x48')]=function(_0x2abf19,_0x4da22d){return db[_0x3efe('0x3f')][_0x3efe('0x48')](_0x2abf19['body'],{})[_0x3efe('0x24')](function(_0x608c6){var _0xaa87c0=_0x2abf19[_0x3efe('0x49')][_0x3efe('0x26')]({'plain':!![]});if(!_0xaa87c0)throw new Error(_0x3efe('0x4a'));if(_0xaa87c0[_0x3efe('0x4b')]===_0x3efe('0x49')){var _0x2e8c07=_0x608c6[_0x3efe('0x26')]({'plain':!![]});var _0x4dbe67='Projects';return db[_0x3efe('0x4c')]['find']({'where':{'name':_0x4dbe67,'userProfileId':_0xaa87c0[_0x3efe('0x4d')]},'raw':!![]})[_0x3efe('0x24')](function(_0x596418){if(_0x596418&&_0x596418[_0x3efe('0x4e')]===0x0){return db[_0x3efe('0x28')][_0x3efe('0x48')]({'name':_0x2e8c07[_0x3efe('0x2a')],'resourceId':_0x2e8c07['id'],'type':_0x596418[_0x3efe('0x2a')],'sectionId':_0x596418['id']},{})['then'](function(){return _0x608c6;});}else{return _0x608c6;}})[_0x3efe('0x43')](function(_0x52db49){logger[_0x3efe('0x29')](_0x3efe('0x4f'),_0x52db49);throw _0x52db49;});}return _0x608c6;})[_0x3efe('0x24')](respondWithResult(_0x4da22d,0xc9))[_0x3efe('0x43')](handleError(_0x4da22d,null));};exports[_0x3efe('0x50')]=function(_0x9ab635,_0x306b42){var _0x40c1f3={'where':{'id':_0x9ab635[_0x3efe('0x45')]['id']}},_0xb74ca={};_0xb74ca['model']=_[_0x3efe('0x51')](db['JscriptyProject'][_0x3efe('0x2c')]);_0x40c1f3[_0x3efe('0x30')]=_[_0x3efe('0x46')](_0xb74ca[_0x3efe('0x31')],qs[_0x3efe('0x32')](_0x9ab635[_0x3efe('0x2f')][_0x3efe('0x32')]));_0x40c1f3[_0x3efe('0x30')]=_0x40c1f3[_0x3efe('0x30')]['length']?_0x40c1f3[_0x3efe('0x30')]:_0xb74ca[_0x3efe('0x31')];if(_0x9ab635[_0x3efe('0x2f')][_0x3efe('0x40')]){_0x40c1f3[_0x3efe('0x41')]=[{'all':!![]}];}_0x40c1f3=_[_0x3efe('0x3a')]({},_0x40c1f3,_0x9ab635['options']);return db[_0x3efe('0x3f')][_0x3efe('0x47')](_0x40c1f3)['then'](handleEntityNotFound(_0x306b42,null))[_0x3efe('0x24')](function(_0x31ccd4){if(_0x31ccd4){var _0x1e314b=_0x31ccd4['get']({'plain':!![]});_0x1e314b=qs['omit'](_0x1e314b,['id','createdAt',_0x3efe('0x52')]);_0x9ab635['body']=_[_0x3efe('0x53')](_0x9ab635[_0x3efe('0x54')],['id',_0x3efe('0x55'),_0x3efe('0x52')]);return db[_0x3efe('0x3f')]['create'](_[_0x3efe('0x3a')](_0x1e314b,_0x9ab635[_0x3efe('0x54')]),{'include':_0x9ab635[_0x3efe('0x2f')][_0x3efe('0x40')]?[{'all':!![]}]:undefined})[_0x3efe('0x24')](function(_0x59dba9){var _0x481870=_0x9ab635[_0x3efe('0x49')][_0x3efe('0x26')]({'plain':!![]});if(!_0x481870)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x481870[_0x3efe('0x4b')]==='user'){var _0x5be3d7=_0x59dba9[_0x3efe('0x26')]({'plain':!![]});var _0x3eee6e='Projects';return db['UserProfileSection'][_0x3efe('0x47')]({'where':{'name':_0x3eee6e,'userProfileId':_0x481870['userProfileId']},'raw':!![]})[_0x3efe('0x24')](function(_0x4a909c){if(_0x4a909c&&_0x4a909c[_0x3efe('0x4e')]===0x0){return db[_0x3efe('0x28')][_0x3efe('0x48')]({'name':_0x5be3d7['name'],'resourceId':_0x5be3d7['id'],'type':_0x4a909c[_0x3efe('0x2a')],'sectionId':_0x4a909c['id']},{})['then'](function(){return _0x59dba9;});}else{return _0x59dba9;}})['catch'](function(_0x4ce223){logger[_0x3efe('0x29')](_0x3efe('0x4f'),_0x4ce223);throw _0x4ce223;});}return _0x59dba9;});}})[_0x3efe('0x24')](respondWithResult(_0x306b42,0xc9))[_0x3efe('0x43')](handleError(_0x306b42,null));};exports[_0x3efe('0x56')]=function(_0x554854,_0x5ebd01){if(_0x554854['body']['id']){delete _0x554854['body']['id'];}return db[_0x3efe('0x3f')][_0x3efe('0x47')]({'where':{'id':_0x554854['params']['id']}})['then'](handleEntityNotFound(_0x5ebd01,null))['then'](saveUpdates(_0x554854[_0x3efe('0x54')],null))[_0x3efe('0x24')](respondWithResult(_0x5ebd01,null))[_0x3efe('0x43')](handleError(_0x5ebd01,null));};exports['destroy']=function(_0x575580,_0x3dc3c7){return db[_0x3efe('0x3f')][_0x3efe('0x47')]({'where':{'id':_0x575580[_0x3efe('0x45')]['id']}})[_0x3efe('0x24')](handleEntityNotFound(_0x3dc3c7,null))[_0x3efe('0x24')](removeEntity(_0x3dc3c7,null))[_0x3efe('0x43')](handleError(_0x3dc3c7,null));};exports[_0x3efe('0x57')]=function(_0x1daa11,_0x54fd9f,_0x185da1){var _0x4cb191={'raw':!![],'where':{}};var _0x4586ae={};var _0x45235d={'count':0x0,'rows':[]};return db[_0x3efe('0x3f')][_0x3efe('0x58')]({'where':{'id':_0x1daa11[_0x3efe('0x45')]['id']}})[_0x3efe('0x24')](handleEntityNotFound(_0x54fd9f,null))[_0x3efe('0x24')](function(_0x4ee844){if(_0x4ee844){_0x4586ae[_0x3efe('0x31')]=_['keys'](db['JscriptySessionReport']['rawAttributes']);_0x4586ae[_0x3efe('0x2f')]=_['keys'](_0x1daa11[_0x3efe('0x2f')]);_0x4586ae[_0x3efe('0x39')]=_[_0x3efe('0x46')](_0x4586ae[_0x3efe('0x31')],_0x4586ae['query']);_0x4cb191['attributes']=_['intersection'](_0x4586ae[_0x3efe('0x31')],qs['fields'](_0x1daa11['query'][_0x3efe('0x32')]));_0x4cb191[_0x3efe('0x30')]=_0x4cb191[_0x3efe('0x30')][_0x3efe('0x33')]?_0x4cb191['attributes']:_0x4586ae[_0x3efe('0x31')];if(!_0x1daa11[_0x3efe('0x2f')]['hasOwnProperty']('nolimit')){_0x4cb191[_0x3efe('0x1e')]=qs[_0x3efe('0x1e')](_0x1daa11[_0x3efe('0x2f')][_0x3efe('0x1e')]);_0x4cb191[_0x3efe('0x1b')]=qs[_0x3efe('0x1b')](_0x1daa11['query'][_0x3efe('0x1b')]);}_0x4cb191[_0x3efe('0x59')]=qs[_0x3efe('0x36')](_0x1daa11[_0x3efe('0x2f')][_0x3efe('0x36')]);_0x4cb191[_0x3efe('0x37')]=qs[_0x3efe('0x39')](_[_0x3efe('0x38')](_0x1daa11['query'],_0x4586ae[_0x3efe('0x39')]));_0x4cb191[_0x3efe('0x37')][_0x3efe('0x5a')]=_0x4ee844['id'];if(_0x1daa11[_0x3efe('0x2f')]['filter']){_0x4cb191[_0x3efe('0x37')]=_[_0x3efe('0x3a')](_0x4cb191['where'],{'$or':_[_0x3efe('0x2b')](_0x4cb191[_0x3efe('0x30')],function(_0xe5653){var _0x3f7412={};_0x3f7412[_0xe5653]={'$like':'%'+_0x1daa11[_0x3efe('0x2f')]['filter']+'%'};return _0x3f7412;})});}_0x4cb191=_[_0x3efe('0x3a')]({},_0x4cb191,_0x1daa11[_0x3efe('0x3e')]);return db[_0x3efe('0x5b')][_0x3efe('0x1d')]({'where':_0x4cb191[_0x3efe('0x37')]})['then'](function(_0x371354){_0x45235d[_0x3efe('0x1d')]=_0x371354;if(_0x1daa11[_0x3efe('0x2f')][_0x3efe('0x40')]){_0x4cb191['include']=[{'all':!![]}];}return db[_0x3efe('0x5b')][_0x3efe('0x5c')](_0x4cb191);})[_0x3efe('0x24')](function(_0x4fdf8a){_0x45235d['rows']=_0x4fdf8a;return _0x45235d;});}})['then'](respondWithFilteredResult(_0x54fd9f,_0x4cb191))[_0x3efe('0x43')](handleError(_0x54fd9f,null));};exports[_0x3efe('0x5d')]=function(_0xb94458,_0x3b823d,_0x4f9a8e){var _0x599b6b={'raw':!![],'where':{}};var _0x113995={};var _0x31c47d={'count':0x0,'rows':[]};return db[_0x3efe('0x3f')][_0x3efe('0x58')]({'where':{'id':_0xb94458['params']['id']}})[_0x3efe('0x24')](handleEntityNotFound(_0x3b823d,null))[_0x3efe('0x24')](function(_0x56dc49){if(_0x56dc49){_0x113995[_0x3efe('0x31')]=_[_0x3efe('0x51')](db[_0x3efe('0x5e')][_0x3efe('0x2c')]);_0x113995[_0x3efe('0x2f')]=_['keys'](_0xb94458[_0x3efe('0x2f')]);_0x113995['filters']=_['intersection'](_0x113995[_0x3efe('0x31')],_0x113995['query']);_0x599b6b[_0x3efe('0x30')]=_[_0x3efe('0x46')](_0x113995['model'],qs[_0x3efe('0x32')](_0xb94458[_0x3efe('0x2f')][_0x3efe('0x32')]));_0x599b6b['attributes']=_0x599b6b[_0x3efe('0x30')][_0x3efe('0x33')]?_0x599b6b[_0x3efe('0x30')]:_0x113995[_0x3efe('0x31')];if(!_0xb94458[_0x3efe('0x2f')]['hasOwnProperty'](_0x3efe('0x35'))){_0x599b6b[_0x3efe('0x1e')]=qs[_0x3efe('0x1e')](_0xb94458[_0x3efe('0x2f')][_0x3efe('0x1e')]);_0x599b6b[_0x3efe('0x1b')]=qs[_0x3efe('0x1b')](_0xb94458[_0x3efe('0x2f')][_0x3efe('0x1b')]);}_0x599b6b[_0x3efe('0x59')]=qs[_0x3efe('0x36')](_0xb94458[_0x3efe('0x2f')][_0x3efe('0x36')]);_0x599b6b['where']=qs[_0x3efe('0x39')](_[_0x3efe('0x38')](_0xb94458[_0x3efe('0x2f')],_0x113995[_0x3efe('0x39')]));_0x599b6b['where']['ProjectId']=_0x56dc49['id'];if(_0xb94458[_0x3efe('0x2f')]['filter']){_0x599b6b[_0x3efe('0x37')]=_[_0x3efe('0x3a')](_0x599b6b[_0x3efe('0x37')],{'$or':_['map'](_0x599b6b['attributes'],function(_0x330b95){var _0x325de1={};_0x325de1[_0x330b95]={'$like':'%'+_0xb94458[_0x3efe('0x2f')][_0x3efe('0x3d')]+'%'};return _0x325de1;})});}_0x599b6b=_[_0x3efe('0x3a')]({},_0x599b6b,_0xb94458[_0x3efe('0x3e')]);return db[_0x3efe('0x5e')][_0x3efe('0x1d')]({'where':_0x599b6b[_0x3efe('0x37')]})[_0x3efe('0x24')](function(_0x2014b8){_0x31c47d[_0x3efe('0x1d')]=_0x2014b8;if(_0xb94458[_0x3efe('0x2f')][_0x3efe('0x40')]){_0x599b6b[_0x3efe('0x41')]=[{'all':!![]}];}return db[_0x3efe('0x5e')]['findAll'](_0x599b6b);})['then'](function(_0x55dad0){_0x31c47d[_0x3efe('0x42')]=_0x55dad0;return _0x31c47d;});}})[_0x3efe('0x24')](respondWithFilteredResult(_0x3b823d,_0x599b6b))[_0x3efe('0x43')](handleError(_0x3b823d,null));};function char(_0x1a8596){return _0x3efe('0x5f')===typeof _0x1a8596?String[_0x3efe('0x60')]['apply'](null,arguments):_0x1a8596;}function needsEncapsulation(_0x123f07){return!!_0x123f07&&(_0x123f07[_0x3efe('0x61')]()[_0x3efe('0x62')](char(0xd))>=0x0||_0x123f07[_0x3efe('0x61')]()['indexOf'](char(0xa))>=0x0||_0x123f07[_0x3efe('0x61')]()[_0x3efe('0x62')](char(0x2c))>=0x0||_0x123f07[_0x3efe('0x61')]()[_0x3efe('0x62')](char(0x22))>=0x0);}function encapsulate(_0x41bf53){var _0x28f7c1=char(0x22),_0x64e52='\x5c'+char(0x22),_0x17e10e=_0x41bf53[_0x3efe('0x61')]()['replace'](new RegExp(_0x28f7c1,'g'),_0x64e52);return _0x28f7c1+_0x17e10e+_0x28f7c1;}exports[_0x3efe('0x63')]=function(_0x5c3089,_0x3c330e,_0x50e696){var _0xe8dac0,_0x28efb3;var _0x7ecaa4={'where':{'ProjectId':_0x5c3089['params']['id']}};if(_0x5c3089['query'][_0x3efe('0x64')]){_0x7ecaa4[_0x3efe('0x37')]['starttime']=JSON['parse'](_0x5c3089['query']['startTime']);}return db[_0x3efe('0x5b')][_0x3efe('0x5c')](_0x7ecaa4)['then'](handleEntityNotFound(_0x3c330e,null))[_0x3efe('0x24')](function(_0x21bcb9){if(_0x21bcb9){_0xe8dac0=_0x21bcb9;return db['JscriptyQuestionReport'][_0x3efe('0x5c')]({'where':{'SessionId':{'$in':_[_0x3efe('0x2b')](_0xe8dac0,'id')},'ProjectId':_0x5c3089['params']['id']},'order':_0x3efe('0x65')});}})['then'](handleEntityNotFound(_0x3c330e,null))[_0x3efe('0x24')](function(_0x47034a){if(_0x47034a){_0x28efb3=_0x47034a;var _0x400613={};for(var _0x104c8a=0x0,_0x20f5f4=_0x28efb3[_0x3efe('0x33')];_0x104c8a<_0x20f5f4;_0x104c8a++){if(!_0x400613[_0x3efe('0x34')](_0x28efb3[_0x104c8a][_0x3efe('0x66')])){_0x400613[_0x28efb3[_0x104c8a][_0x3efe('0x66')]]=needsEncapsulation(_0x28efb3[_0x104c8a][_0x3efe('0x67')])?encapsulate(_0x28efb3[_0x104c8a][_0x3efe('0x67')]):_0x28efb3[_0x104c8a][_0x3efe('0x67')];}}var _0x1def6d=[],_0x51a9d3={};for(var _0x4f18e9=0x0,_0x479ec9=_0xe8dac0[_0x3efe('0x33')];_0x4f18e9<_0x479ec9;_0x4f18e9++){_0x51a9d3={'ProjectId':_0x5c3089[_0x3efe('0x45')]['id'],'SessionId':_0xe8dac0[_0x4f18e9]['id'],'StartTime':moment(_0xe8dac0[_0x4f18e9][_0x3efe('0x68')])[_0x3efe('0x69')](_0x3efe('0x6a'))};for(var _0xa582f2=0x0,_0x5278e2=_0x28efb3[_0x3efe('0x33')];_0xa582f2<_0x5278e2;_0xa582f2++){if(_0x28efb3[_0xa582f2]['SessionId']==_0xe8dac0[_0x4f18e9]['id']&&_0x400613['hasOwnProperty'](_0x28efb3[_0xa582f2][_0x3efe('0x66')])){_0x51a9d3[_0x400613[_0x28efb3[_0xa582f2]['questionId']]]=_0x28efb3[_0xa582f2][_0x3efe('0x6b')];}}for(var _0x2ba3a0 in _0x400613){if(!_0x51a9d3[_0x3efe('0x34')](_0x400613[_0x2ba3a0])){_0x51a9d3[_0x400613[_0x2ba3a0]]=null;}}_0x1def6d[_0x3efe('0x6c')](_0x51a9d3);}return _0x1def6d;}})[_0x3efe('0x24')](function(_0x2244fc){if(!_[_0x3efe('0x6d')](_0x2244fc)){var _0x62e067=toCsv(_0x2244fc);var _0x5d3475=Date[_0x3efe('0x6e')]();fs[_0x3efe('0x6f')](util[_0x3efe('0x69')](_0x3efe('0x70'),_0x5c3089[_0x3efe('0x45')]['id'],_0x5d3475),_0x62e067);_0x3c330e[_0x3efe('0x71')](_0x3efe('0x72'),_0x3efe('0x73')+util['format'](_0x3efe('0x74'),_0x5c3089[_0x3efe('0x45')]['id'],_0x5d3475));_0x3c330e[_0x3efe('0x71')](_0x3efe('0x75'),'text/csv');return _0x3c330e[_0x3efe('0x76')](util[_0x3efe('0x69')]('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x5c3089[_0x3efe('0x45')]['id'],_0x5d3475));}else{return _0x3c330e[_0x3efe('0x17')](0xcc);}})[_0x3efe('0x43')](handleError(_0x3c330e,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff