// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xc2e1=['filter','merge','where','map','VIRTUAL','findAll','show','params','include','options','find','catch','create','body','user','UserProfileSection','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','includeAll','omit','createdAt','updatedAt','role','getSessions','findOne','JscriptySessionReport','ProjectId','rows','getAnswers','JscriptyAnswerReport','number','fromCharCode','apply','toString','indexOf','replace','getSummary','starttime','parse','-createdAt','questionId','question','format','answer','push','isEmpty','writeFileSync','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','Content-disposition','attachment;\x20filename=','Content-type','text/csv','html-pdf','eml-format','rimraf','fast-json-patch','moment','mustache','util','path','sox','to-csv','ejs','squel','crypto','desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','sendStatus','end','json','count','offset','limit','status','set','Content-Range','save','update','destroy','then','get','Projects','UserProfileResource','error','stack','name','send','index','JscriptyProject','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','pick'];(function(_0x397e5f,_0x454c8f){var _0x5302b8=function(_0x1a29ef){while(--_0x1a29ef){_0x397e5f['push'](_0x397e5f['shift']());}};_0x5302b8(++_0x454c8f);}(_0xc2e1,0xa8));var _0x1c2e=function(_0x1ef310,_0x3ce18a){_0x1ef310=_0x1ef310-0x0;var _0x5e966c=_0xc2e1[_0x1ef310];return _0x5e966c;};'use strict';var pdf=require(_0x1c2e('0x0'));var emlformat=require(_0x1c2e('0x1'));var rimraf=require(_0x1c2e('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0x1c2e('0x3'));var rp=require('request-promise');var moment=require(_0x1c2e('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x1c2e('0x5'));var util=require(_0x1c2e('0x6'));var path=require(_0x1c2e('0x7'));var sox=require(_0x1c2e('0x8'));var csv=require(_0x1c2e('0x9'));var ejs=require(_0x1c2e('0xa'));var fs=require('fs');var _=require('lodash');var squel=require(_0x1c2e('0xb'));var crypto=require(_0x1c2e('0xc'));var jsforce=require('jsforce');var deskjs=require(_0x1c2e('0xd'));var toCsv=require(_0x1c2e('0x9'));var querystring=require(_0x1c2e('0xe'));var Papa=require(_0x1c2e('0xf'));var Redis=require('ioredis');var authService=require(_0x1c2e('0x10'));var qs=require(_0x1c2e('0x11'));var as=require(_0x1c2e('0x12'));var hardwareService=require(_0x1c2e('0x13'));var logger=require(_0x1c2e('0x14'))('api');var utils=require('../../config/utils');var config=require('../../config/environment');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x3380c0,_0x127fde){_0x127fde=_0x127fde||0xcc;return function(_0x49fda0){if(_0x49fda0){return _0x3380c0[_0x1c2e('0x15')](_0x127fde);}return _0x3380c0['status'](_0x127fde)[_0x1c2e('0x16')]();};}function respondWithResult(_0x388775,_0x4ea3ed){_0x4ea3ed=_0x4ea3ed||0xc8;return function(_0x2e4b5c){if(_0x2e4b5c){return _0x388775['status'](_0x4ea3ed)[_0x1c2e('0x17')](_0x2e4b5c);}};}function respondWithFilteredResult(_0x3bab40,_0x387792){return function(_0x4553e2){if(_0x4553e2){var _0x1b9c3b=_0x4553e2[_0x1c2e('0x18')],_0x3e2ecd=_0x387792[_0x1c2e('0x19')],_0x3b1f8f=_0x387792[_0x1c2e('0x19')]+_0x387792[_0x1c2e('0x1a')],_0x75fce6;if(_0x3b1f8f>=_0x1b9c3b){_0x3b1f8f=_0x1b9c3b;_0x75fce6=0xc8;}else{_0x75fce6=0xce;}_0x3bab40[_0x1c2e('0x1b')](_0x75fce6);return _0x3bab40[_0x1c2e('0x1c')](_0x1c2e('0x1d'),_0x3e2ecd+'-'+_0x3b1f8f+'/'+_0x1b9c3b)[_0x1c2e('0x17')](_0x4553e2);}return null;};}function patchUpdates(_0x5338f0){return function(_0xcebdac){try{jsonpatch['apply'](_0xcebdac,_0x5338f0,!![]);}catch(_0x1a5384){return BPromise['reject'](_0x1a5384);}return _0xcebdac[_0x1c2e('0x1e')]();};}function saveUpdates(_0x1eb128,_0x145d3e){return function(_0x196f22){if(_0x196f22){return _0x196f22[_0x1c2e('0x1f')](_0x1eb128)['then'](function(_0x222f9f){return _0x222f9f;});}return null;};}function removeEntity(_0x3df53c,_0x552b87){return function(_0xea5cc){if(_0xea5cc){return _0xea5cc[_0x1c2e('0x20')]()[_0x1c2e('0x21')](function(){var _0x35877e=_0xea5cc[_0x1c2e('0x22')]({'plain':!![]});var _0x3df998=_0x1c2e('0x23');return db[_0x1c2e('0x24')][_0x1c2e('0x20')]({'where':{'type':_0x3df998,'resourceId':_0x35877e['id']}})['then'](function(){return _0xea5cc;});})[_0x1c2e('0x21')](function(){_0x3df53c[_0x1c2e('0x1b')](0xcc)[_0x1c2e('0x16')]();});}};}function handleEntityNotFound(_0x49771e,_0x4e32f7){return function(_0x1c0917){if(!_0x1c0917){_0x49771e[_0x1c2e('0x15')](0x194);}return _0x1c0917;};}function handleError(_0x32a9a7,_0x2ac459){_0x2ac459=_0x2ac459||0x1f4;return function(_0x5db027){logger[_0x1c2e('0x25')](_0x5db027[_0x1c2e('0x26')]);if(_0x5db027[_0x1c2e('0x27')]){delete _0x5db027[_0x1c2e('0x27')];}_0x32a9a7[_0x1c2e('0x1b')](_0x2ac459)[_0x1c2e('0x28')](_0x5db027);};}exports[_0x1c2e('0x29')]=function(_0x3013d6,_0x43349a){var _0x3b09c5={},_0x2eaa70={},_0x11716b={'count':0x0,'rows':[]};var _0xbe5cec=_['map'](db[_0x1c2e('0x2a')][_0x1c2e('0x2b')],function(_0xbb546c){return{'name':_0xbb546c[_0x1c2e('0x2c')],'type':_0xbb546c[_0x1c2e('0x2d')][_0x1c2e('0x2e')]};});_0x2eaa70[_0x1c2e('0x2f')]=_['map'](_0xbe5cec,_0x1c2e('0x27'));_0x2eaa70[_0x1c2e('0x30')]=_[_0x1c2e('0x31')](_0x3013d6['query']);_0x2eaa70[_0x1c2e('0x32')]=_[_0x1c2e('0x33')](_0x2eaa70[_0x1c2e('0x2f')],_0x2eaa70[_0x1c2e('0x30')]);_0x3b09c5[_0x1c2e('0x34')]=_['intersection'](_0x2eaa70[_0x1c2e('0x2f')],qs[_0x1c2e('0x35')](_0x3013d6[_0x1c2e('0x30')]['fields']));_0x3b09c5['attributes']=_0x3b09c5['attributes'][_0x1c2e('0x36')]?_0x3b09c5[_0x1c2e('0x34')]:_0x2eaa70[_0x1c2e('0x2f')];if(!_0x3013d6[_0x1c2e('0x30')][_0x1c2e('0x37')](_0x1c2e('0x38'))){_0x3b09c5[_0x1c2e('0x1a')]=qs['limit'](_0x3013d6[_0x1c2e('0x30')]['limit']);_0x3b09c5[_0x1c2e('0x19')]=qs[_0x1c2e('0x19')](_0x3013d6[_0x1c2e('0x30')][_0x1c2e('0x19')]);}_0x3b09c5[_0x1c2e('0x39')]=qs[_0x1c2e('0x3a')](_0x3013d6[_0x1c2e('0x30')][_0x1c2e('0x3a')]);_0x3b09c5['where']=qs[_0x1c2e('0x32')](_[_0x1c2e('0x3b')](_0x3013d6[_0x1c2e('0x30')],_0x2eaa70['filters']));if(_0x3013d6[_0x1c2e('0x30')][_0x1c2e('0x3c')]){_0x3b09c5['where']=_[_0x1c2e('0x3d')](_0x3b09c5[_0x1c2e('0x3e')],{'$or':_[_0x1c2e('0x3f')](_0xbe5cec,function(_0xe0e56f){if(_0xe0e56f[_0x1c2e('0x2d')]!==_0x1c2e('0x40')){var _0x4d8eba={};_0x4d8eba[_0xe0e56f[_0x1c2e('0x27')]]={'$like':'%'+_0x3013d6[_0x1c2e('0x30')][_0x1c2e('0x3c')]+'%'};return _0x4d8eba;}})});}_0x3b09c5=_[_0x1c2e('0x3d')]({},_0x3b09c5,_0x3013d6['options']);var _0x4ad3a3={'where':_0x3b09c5[_0x1c2e('0x3e')]};return db[_0x1c2e('0x2a')]['count'](_0x4ad3a3)['then'](function(_0xb85e77){_0x11716b[_0x1c2e('0x18')]=_0xb85e77;if(_0x3013d6['query']['includeAll']){_0x3b09c5['include']=[{'all':!![]}];}return db[_0x1c2e('0x2a')][_0x1c2e('0x41')](_0x3b09c5);})[_0x1c2e('0x21')](function(_0x25d029){_0x11716b['rows']=_0x25d029;return _0x11716b;})[_0x1c2e('0x21')](respondWithFilteredResult(_0x43349a,_0x3b09c5))['catch'](handleError(_0x43349a,null));};exports[_0x1c2e('0x42')]=function(_0x307709,_0x242233){var _0x48255d={'raw':![],'where':{'id':_0x307709[_0x1c2e('0x43')]['id']}},_0x522500={};_0x522500[_0x1c2e('0x2f')]=_['keys'](db['JscriptyProject']['rawAttributes']);_0x522500['query']=_[_0x1c2e('0x31')](_0x307709[_0x1c2e('0x30')]);_0x522500['filters']=_[_0x1c2e('0x33')](_0x522500['model'],_0x522500['query']);_0x48255d[_0x1c2e('0x34')]=_[_0x1c2e('0x33')](_0x522500[_0x1c2e('0x2f')],qs[_0x1c2e('0x35')](_0x307709['query']['fields']));_0x48255d[_0x1c2e('0x34')]=_0x48255d[_0x1c2e('0x34')][_0x1c2e('0x36')]?_0x48255d['attributes']:_0x522500['model'];if(_0x307709['query']['includeAll']){_0x48255d[_0x1c2e('0x44')]=[{'all':!![]}];}_0x48255d=_[_0x1c2e('0x3d')]({},_0x48255d,_0x307709[_0x1c2e('0x45')]);return db[_0x1c2e('0x2a')][_0x1c2e('0x46')](_0x48255d)[_0x1c2e('0x21')](handleEntityNotFound(_0x242233,null))[_0x1c2e('0x21')](respondWithResult(_0x242233,null))[_0x1c2e('0x47')](handleError(_0x242233,null));};exports[_0x1c2e('0x48')]=function(_0x4f244d,_0x5bc1a4){return db[_0x1c2e('0x2a')][_0x1c2e('0x48')](_0x4f244d[_0x1c2e('0x49')],{})['then'](function(_0x3b991f){var _0x51746a=_0x4f244d[_0x1c2e('0x4a')][_0x1c2e('0x22')]({'plain':!![]});if(!_0x51746a)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x51746a['role']===_0x1c2e('0x4a')){var _0x2230da=_0x3b991f[_0x1c2e('0x22')]({'plain':!![]});var _0x13b323=_0x1c2e('0x23');return db[_0x1c2e('0x4b')][_0x1c2e('0x46')]({'where':{'name':_0x13b323,'userProfileId':_0x51746a[_0x1c2e('0x4c')]},'raw':!![]})[_0x1c2e('0x21')](function(_0x4df436){if(_0x4df436&&_0x4df436['autoAssociation']===0x0){return db[_0x1c2e('0x24')][_0x1c2e('0x48')]({'name':_0x2230da[_0x1c2e('0x27')],'resourceId':_0x2230da['id'],'type':_0x4df436[_0x1c2e('0x27')],'sectionId':_0x4df436['id']},{})[_0x1c2e('0x21')](function(){return _0x3b991f;});}else{return _0x3b991f;}})[_0x1c2e('0x47')](function(_0xb2375f){logger['error'](_0x1c2e('0x4d'),_0xb2375f);throw _0xb2375f;});}return _0x3b991f;})[_0x1c2e('0x21')](respondWithResult(_0x5bc1a4,0xc9))[_0x1c2e('0x47')](handleError(_0x5bc1a4,null));};exports[_0x1c2e('0x4e')]=function(_0x24a328,_0x300ad8){var _0x30a126={'where':{'id':_0x24a328[_0x1c2e('0x43')]['id']}},_0x4836ff={};_0x4836ff['model']=_[_0x1c2e('0x31')](db[_0x1c2e('0x2a')][_0x1c2e('0x2b')]);_0x30a126[_0x1c2e('0x34')]=_[_0x1c2e('0x33')](_0x4836ff['model'],qs[_0x1c2e('0x35')](_0x24a328[_0x1c2e('0x30')]['fields']));_0x30a126[_0x1c2e('0x34')]=_0x30a126[_0x1c2e('0x34')][_0x1c2e('0x36')]?_0x30a126[_0x1c2e('0x34')]:_0x4836ff[_0x1c2e('0x2f')];if(_0x24a328[_0x1c2e('0x30')][_0x1c2e('0x4f')]){_0x30a126[_0x1c2e('0x44')]=[{'all':!![]}];}_0x30a126=_[_0x1c2e('0x3d')]({},_0x30a126,_0x24a328[_0x1c2e('0x45')]);return db[_0x1c2e('0x2a')][_0x1c2e('0x46')](_0x30a126)[_0x1c2e('0x21')](handleEntityNotFound(_0x300ad8,null))['then'](function(_0x5b1a88){if(_0x5b1a88){var _0x85ac08=_0x5b1a88[_0x1c2e('0x22')]({'plain':!![]});_0x85ac08=qs[_0x1c2e('0x50')](_0x85ac08,['id',_0x1c2e('0x51'),_0x1c2e('0x52')]);_0x24a328[_0x1c2e('0x49')]=_['omit'](_0x24a328[_0x1c2e('0x49')],['id',_0x1c2e('0x51'),_0x1c2e('0x52')]);return db[_0x1c2e('0x2a')][_0x1c2e('0x48')](_[_0x1c2e('0x3d')](_0x85ac08,_0x24a328[_0x1c2e('0x49')]),{'include':_0x24a328[_0x1c2e('0x30')][_0x1c2e('0x4f')]?[{'all':!![]}]:undefined})['then'](function(_0x35ad5e){var _0x30e8ba=_0x24a328[_0x1c2e('0x4a')]['get']({'plain':!![]});if(!_0x30e8ba)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x30e8ba[_0x1c2e('0x53')]==='user'){var _0x594082=_0x35ad5e[_0x1c2e('0x22')]({'plain':!![]});var _0x127e2b=_0x1c2e('0x23');return db[_0x1c2e('0x4b')]['find']({'where':{'name':_0x127e2b,'userProfileId':_0x30e8ba['userProfileId']},'raw':!![]})[_0x1c2e('0x21')](function(_0xab5b0b){if(_0xab5b0b&&_0xab5b0b['autoAssociation']===0x0){return db[_0x1c2e('0x24')][_0x1c2e('0x48')]({'name':_0x594082[_0x1c2e('0x27')],'resourceId':_0x594082['id'],'type':_0xab5b0b['name'],'sectionId':_0xab5b0b['id']},{})[_0x1c2e('0x21')](function(){return _0x35ad5e;});}else{return _0x35ad5e;}})[_0x1c2e('0x47')](function(_0x22d3a4){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x22d3a4);throw _0x22d3a4;});}return _0x35ad5e;});}})['then'](respondWithResult(_0x300ad8,0xc9))[_0x1c2e('0x47')](handleError(_0x300ad8,null));};exports['update']=function(_0x4eb73d,_0x50e3e0){if(_0x4eb73d['body']['id']){delete _0x4eb73d[_0x1c2e('0x49')]['id'];}return db['JscriptyProject'][_0x1c2e('0x46')]({'where':{'id':_0x4eb73d[_0x1c2e('0x43')]['id']}})[_0x1c2e('0x21')](handleEntityNotFound(_0x50e3e0,null))[_0x1c2e('0x21')](saveUpdates(_0x4eb73d[_0x1c2e('0x49')],null))[_0x1c2e('0x21')](respondWithResult(_0x50e3e0,null))[_0x1c2e('0x47')](handleError(_0x50e3e0,null));};exports[_0x1c2e('0x20')]=function(_0x22d40f,_0x590075){return db['JscriptyProject'][_0x1c2e('0x46')]({'where':{'id':_0x22d40f['params']['id']}})[_0x1c2e('0x21')](handleEntityNotFound(_0x590075,null))[_0x1c2e('0x21')](removeEntity(_0x590075,null))[_0x1c2e('0x47')](handleError(_0x590075,null));};exports[_0x1c2e('0x54')]=function(_0x4b7439,_0x1d6d56,_0x46d2c9){var _0x1ccc09={'raw':!![],'where':{}};var _0x1341ac={};var _0x3e9ceb={'count':0x0,'rows':[]};return db[_0x1c2e('0x2a')][_0x1c2e('0x55')]({'where':{'id':_0x4b7439[_0x1c2e('0x43')]['id']}})[_0x1c2e('0x21')](handleEntityNotFound(_0x1d6d56,null))[_0x1c2e('0x21')](function(_0x4d68b1){if(_0x4d68b1){_0x1341ac['model']=_[_0x1c2e('0x31')](db[_0x1c2e('0x56')][_0x1c2e('0x2b')]);_0x1341ac[_0x1c2e('0x30')]=_[_0x1c2e('0x31')](_0x4b7439[_0x1c2e('0x30')]);_0x1341ac['filters']=_['intersection'](_0x1341ac[_0x1c2e('0x2f')],_0x1341ac[_0x1c2e('0x30')]);_0x1ccc09[_0x1c2e('0x34')]=_['intersection'](_0x1341ac[_0x1c2e('0x2f')],qs[_0x1c2e('0x35')](_0x4b7439['query'][_0x1c2e('0x35')]));_0x1ccc09[_0x1c2e('0x34')]=_0x1ccc09[_0x1c2e('0x34')][_0x1c2e('0x36')]?_0x1ccc09[_0x1c2e('0x34')]:_0x1341ac[_0x1c2e('0x2f')];if(!_0x4b7439[_0x1c2e('0x30')][_0x1c2e('0x37')](_0x1c2e('0x38'))){_0x1ccc09[_0x1c2e('0x1a')]=qs[_0x1c2e('0x1a')](_0x4b7439[_0x1c2e('0x30')][_0x1c2e('0x1a')]);_0x1ccc09['offset']=qs['offset'](_0x4b7439[_0x1c2e('0x30')][_0x1c2e('0x19')]);}_0x1ccc09['order']=qs[_0x1c2e('0x3a')](_0x4b7439[_0x1c2e('0x30')][_0x1c2e('0x3a')]);_0x1ccc09[_0x1c2e('0x3e')]=qs[_0x1c2e('0x32')](_[_0x1c2e('0x3b')](_0x4b7439[_0x1c2e('0x30')],_0x1341ac[_0x1c2e('0x32')]));_0x1ccc09[_0x1c2e('0x3e')][_0x1c2e('0x57')]=_0x4d68b1['id'];if(_0x4b7439[_0x1c2e('0x30')][_0x1c2e('0x3c')]){_0x1ccc09[_0x1c2e('0x3e')]=_[_0x1c2e('0x3d')](_0x1ccc09[_0x1c2e('0x3e')],{'$or':_[_0x1c2e('0x3f')](_0x1ccc09[_0x1c2e('0x34')],function(_0x530ded){var _0x446685={};_0x446685[_0x530ded]={'$like':'%'+_0x4b7439[_0x1c2e('0x30')][_0x1c2e('0x3c')]+'%'};return _0x446685;})});}_0x1ccc09=_[_0x1c2e('0x3d')]({},_0x1ccc09,_0x4b7439[_0x1c2e('0x45')]);return db[_0x1c2e('0x56')][_0x1c2e('0x18')]({'where':_0x1ccc09[_0x1c2e('0x3e')]})[_0x1c2e('0x21')](function(_0x4dd570){_0x3e9ceb[_0x1c2e('0x18')]=_0x4dd570;if(_0x4b7439[_0x1c2e('0x30')][_0x1c2e('0x4f')]){_0x1ccc09['include']=[{'all':!![]}];}return db[_0x1c2e('0x56')]['findAll'](_0x1ccc09);})[_0x1c2e('0x21')](function(_0x306a01){_0x3e9ceb[_0x1c2e('0x58')]=_0x306a01;return _0x3e9ceb;});}})[_0x1c2e('0x21')](respondWithFilteredResult(_0x1d6d56,_0x1ccc09))[_0x1c2e('0x47')](handleError(_0x1d6d56,null));};exports[_0x1c2e('0x59')]=function(_0xd01f09,_0x37a2eb,_0x4218c8){var _0x46f88f={'raw':!![],'where':{}};var _0x4ceac1={};var _0x51a6ee={'count':0x0,'rows':[]};return db[_0x1c2e('0x2a')][_0x1c2e('0x55')]({'where':{'id':_0xd01f09['params']['id']}})[_0x1c2e('0x21')](handleEntityNotFound(_0x37a2eb,null))[_0x1c2e('0x21')](function(_0x3ca734){if(_0x3ca734){_0x4ceac1['model']=_[_0x1c2e('0x31')](db[_0x1c2e('0x5a')][_0x1c2e('0x2b')]);_0x4ceac1[_0x1c2e('0x30')]=_[_0x1c2e('0x31')](_0xd01f09[_0x1c2e('0x30')]);_0x4ceac1[_0x1c2e('0x32')]=_[_0x1c2e('0x33')](_0x4ceac1[_0x1c2e('0x2f')],_0x4ceac1[_0x1c2e('0x30')]);_0x46f88f[_0x1c2e('0x34')]=_[_0x1c2e('0x33')](_0x4ceac1[_0x1c2e('0x2f')],qs[_0x1c2e('0x35')](_0xd01f09[_0x1c2e('0x30')]['fields']));_0x46f88f[_0x1c2e('0x34')]=_0x46f88f['attributes'][_0x1c2e('0x36')]?_0x46f88f[_0x1c2e('0x34')]:_0x4ceac1[_0x1c2e('0x2f')];if(!_0xd01f09[_0x1c2e('0x30')][_0x1c2e('0x37')]('nolimit')){_0x46f88f[_0x1c2e('0x1a')]=qs[_0x1c2e('0x1a')](_0xd01f09[_0x1c2e('0x30')][_0x1c2e('0x1a')]);_0x46f88f[_0x1c2e('0x19')]=qs[_0x1c2e('0x19')](_0xd01f09[_0x1c2e('0x30')][_0x1c2e('0x19')]);}_0x46f88f[_0x1c2e('0x39')]=qs[_0x1c2e('0x3a')](_0xd01f09[_0x1c2e('0x30')][_0x1c2e('0x3a')]);_0x46f88f[_0x1c2e('0x3e')]=qs[_0x1c2e('0x32')](_[_0x1c2e('0x3b')](_0xd01f09[_0x1c2e('0x30')],_0x4ceac1[_0x1c2e('0x32')]));_0x46f88f[_0x1c2e('0x3e')][_0x1c2e('0x57')]=_0x3ca734['id'];if(_0xd01f09['query'][_0x1c2e('0x3c')]){_0x46f88f[_0x1c2e('0x3e')]=_[_0x1c2e('0x3d')](_0x46f88f[_0x1c2e('0x3e')],{'$or':_[_0x1c2e('0x3f')](_0x46f88f['attributes'],function(_0x38f4f4){var _0x1d6d2a={};_0x1d6d2a[_0x38f4f4]={'$like':'%'+_0xd01f09[_0x1c2e('0x30')][_0x1c2e('0x3c')]+'%'};return _0x1d6d2a;})});}_0x46f88f=_[_0x1c2e('0x3d')]({},_0x46f88f,_0xd01f09[_0x1c2e('0x45')]);return db[_0x1c2e('0x5a')]['count']({'where':_0x46f88f[_0x1c2e('0x3e')]})[_0x1c2e('0x21')](function(_0x7f66f6){_0x51a6ee['count']=_0x7f66f6;if(_0xd01f09[_0x1c2e('0x30')][_0x1c2e('0x4f')]){_0x46f88f[_0x1c2e('0x44')]=[{'all':!![]}];}return db[_0x1c2e('0x5a')][_0x1c2e('0x41')](_0x46f88f);})[_0x1c2e('0x21')](function(_0x40ce7d){_0x51a6ee[_0x1c2e('0x58')]=_0x40ce7d;return _0x51a6ee;});}})[_0x1c2e('0x21')](respondWithFilteredResult(_0x37a2eb,_0x46f88f))['catch'](handleError(_0x37a2eb,null));};function char(_0x4ad57b){return _0x1c2e('0x5b')===typeof _0x4ad57b?String[_0x1c2e('0x5c')][_0x1c2e('0x5d')](null,arguments):_0x4ad57b;}function needsEncapsulation(_0xc2d277){return!!_0xc2d277&&(_0xc2d277[_0x1c2e('0x5e')]()[_0x1c2e('0x5f')](char(0xd))>=0x0||_0xc2d277[_0x1c2e('0x5e')]()['indexOf'](char(0xa))>=0x0||_0xc2d277[_0x1c2e('0x5e')]()[_0x1c2e('0x5f')](char(0x2c))>=0x0||_0xc2d277['toString']()['indexOf'](char(0x22))>=0x0);}function encapsulate(_0x2e2924){var _0x24c0ae=char(0x22),_0x4539df='\x5c'+char(0x22),_0xc59ccb=_0x2e2924[_0x1c2e('0x5e')]()[_0x1c2e('0x60')](new RegExp(_0x24c0ae,'g'),_0x4539df);return _0x24c0ae+_0xc59ccb+_0x24c0ae;}exports[_0x1c2e('0x61')]=function(_0x2a963b,_0xf3958b,_0x27f594){var _0xbe9aff,_0x56418e;var _0x5816b3={'where':{'ProjectId':_0x2a963b['params']['id']}};if(_0x2a963b[_0x1c2e('0x30')]['startTime']){_0x5816b3[_0x1c2e('0x3e')][_0x1c2e('0x62')]=JSON[_0x1c2e('0x63')](_0x2a963b[_0x1c2e('0x30')]['startTime']);}return db[_0x1c2e('0x56')][_0x1c2e('0x41')](_0x5816b3)[_0x1c2e('0x21')](handleEntityNotFound(_0xf3958b,null))[_0x1c2e('0x21')](function(_0x12bf26){if(_0x12bf26){_0xbe9aff=_0x12bf26;return db['JscriptyQuestionReport']['findAll']({'where':{'SessionId':{'$in':_[_0x1c2e('0x3f')](_0xbe9aff,'id')},'ProjectId':_0x2a963b[_0x1c2e('0x43')]['id']},'order':_0x1c2e('0x64')});}})[_0x1c2e('0x21')](handleEntityNotFound(_0xf3958b,null))[_0x1c2e('0x21')](function(_0x1d1f3b){if(_0x1d1f3b){_0x56418e=_0x1d1f3b;var _0x5f4ce7={};for(var _0x401fb0=0x0,_0x1215e3=_0x56418e[_0x1c2e('0x36')];_0x401fb0<_0x1215e3;_0x401fb0++){if(!_0x5f4ce7[_0x1c2e('0x37')](_0x56418e[_0x401fb0][_0x1c2e('0x65')])){_0x5f4ce7[_0x56418e[_0x401fb0]['questionId']]=needsEncapsulation(_0x56418e[_0x401fb0]['question'])?encapsulate(_0x56418e[_0x401fb0][_0x1c2e('0x66')]):_0x56418e[_0x401fb0][_0x1c2e('0x66')];}}var _0x296d2d=[],_0x3c8436={};for(var _0x179153=0x0,_0x58214d=_0xbe9aff['length'];_0x179153<_0x58214d;_0x179153++){_0x3c8436={'ProjectId':_0x2a963b[_0x1c2e('0x43')]['id'],'SessionId':_0xbe9aff[_0x179153]['id'],'StartTime':moment(_0xbe9aff[_0x179153]['starttime'])[_0x1c2e('0x67')]('YYYY-MM-DD\x20HH:mm:ss')};for(var _0x49fdbb=0x0,_0x36fec3=_0x56418e[_0x1c2e('0x36')];_0x49fdbb<_0x36fec3;_0x49fdbb++){if(_0x56418e[_0x49fdbb]['SessionId']==_0xbe9aff[_0x179153]['id']&&_0x5f4ce7[_0x1c2e('0x37')](_0x56418e[_0x49fdbb]['questionId'])){_0x3c8436[_0x5f4ce7[_0x56418e[_0x49fdbb][_0x1c2e('0x65')]]]=_0x56418e[_0x49fdbb][_0x1c2e('0x68')];}}for(var _0x2276fc in _0x5f4ce7){if(!_0x3c8436[_0x1c2e('0x37')](_0x5f4ce7[_0x2276fc])){_0x3c8436[_0x5f4ce7[_0x2276fc]]=null;}}_0x296d2d[_0x1c2e('0x69')](_0x3c8436);}return _0x296d2d;}})[_0x1c2e('0x21')](function(_0x48a5ff){if(!_[_0x1c2e('0x6a')](_0x48a5ff)){var _0x3a3d37=toCsv(_0x48a5ff);var _0x140c5f=Date['now']();fs[_0x1c2e('0x6b')](util['format'](_0x1c2e('0x6c'),_0x2a963b['params']['id'],_0x140c5f),_0x3a3d37);_0xf3958b[_0x1c2e('0x6d')](_0x1c2e('0x6e'),_0x1c2e('0x6f')+util[_0x1c2e('0x67')]('Jscripty_Project_%d_Summary_%s.csv',_0x2a963b['params']['id'],_0x140c5f));_0xf3958b[_0x1c2e('0x6d')](_0x1c2e('0x70'),_0x1c2e('0x71'));return _0xf3958b['download'](util['format'](_0x1c2e('0x6c'),_0x2a963b['params']['id'],_0x140c5f));}else{return _0xf3958b[_0x1c2e('0x15')](0xcc);}})[_0x1c2e('0x47')](handleError(_0xf3958b,null));};
\ No newline at end of file
+var _0x36b5=['starttime','questionId','question','YYYY-MM-DD\x20HH:mm:ss','SessionId','answer','isEmpty','now','writeFileSync','format','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','Content-disposition','Jscripty_Project_%d_Summary_%s.csv','Content-type','download','html-pdf','rimraf','zip-dir','request-promise','mustache','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','sendStatus','status','end','count','offset','limit','Content-Range','json','apply','save','update','then','Projects','UserProfileResource','destroy','error','name','index','map','JscriptyProject','key','keys','query','filters','intersection','attributes','model','fields','length','hasOwnProperty','order','sort','where','filter','type','VIRTUAL','includeAll','include','catch','rawAttributes','find','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','create','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','params','merge','options','createdAt','updatedAt','findOne','nolimit','ProjectId','JscriptySessionReport','findAll','rows','JscriptyAnswerReport','fromCharCode','toString','indexOf','getSummary','startTime'];(function(_0xb5aa11,_0x51e72f){var _0x3592b1=function(_0x38c73d){while(--_0x38c73d){_0xb5aa11['push'](_0xb5aa11['shift']());}};_0x3592b1(++_0x51e72f);}(_0x36b5,0x154));var _0x536b=function(_0x239875,_0x52a793){_0x239875=_0x239875-0x0;var _0x55a8d6=_0x36b5[_0x239875];return _0x55a8d6;};'use strict';var pdf=require(_0x536b('0x0'));var emlformat=require('eml-format');var rimraf=require(_0x536b('0x1'));var zipdir=require(_0x536b('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x536b('0x3'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x536b('0x4'));var util=require('util');var path=require(_0x536b('0x5'));var sox=require(_0x536b('0x6'));var csv=require(_0x536b('0x7'));var ejs=require(_0x536b('0x8'));var fs=require('fs');var _=require(_0x536b('0x9'));var squel=require(_0x536b('0xa'));var crypto=require(_0x536b('0xb'));var jsforce=require(_0x536b('0xc'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0x536b('0xd'));var Papa=require(_0x536b('0xe'));var Redis=require(_0x536b('0xf'));var authService=require(_0x536b('0x10'));var qs=require('../../components/parsers/qs');var as=require(_0x536b('0x11'));var hardwareService=require(_0x536b('0x12'));var logger=require(_0x536b('0x13'))(_0x536b('0x14'));var utils=require(_0x536b('0x15'));var config=require(_0x536b('0x16'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x4929ba,_0x5aa655){_0x5aa655=_0x5aa655||0xcc;return function(_0x36f6c4){if(_0x36f6c4){return _0x4929ba[_0x536b('0x17')](_0x5aa655);}return _0x4929ba[_0x536b('0x18')](_0x5aa655)[_0x536b('0x19')]();};}function respondWithResult(_0x572af6,_0x255fd1){_0x255fd1=_0x255fd1||0xc8;return function(_0x1bc643){if(_0x1bc643){return _0x572af6[_0x536b('0x18')](_0x255fd1)['json'](_0x1bc643);}};}function respondWithFilteredResult(_0x33c429,_0x59e1b2){return function(_0x766ff6){if(_0x766ff6){var _0x42e25e=_0x766ff6[_0x536b('0x1a')],_0x339c5d=_0x59e1b2[_0x536b('0x1b')],_0x5a7ae9=_0x59e1b2[_0x536b('0x1b')]+_0x59e1b2[_0x536b('0x1c')],_0x2c9db7;if(_0x5a7ae9>=_0x42e25e){_0x5a7ae9=_0x42e25e;_0x2c9db7=0xc8;}else{_0x2c9db7=0xce;}_0x33c429[_0x536b('0x18')](_0x2c9db7);return _0x33c429['set'](_0x536b('0x1d'),_0x339c5d+'-'+_0x5a7ae9+'/'+_0x42e25e)[_0x536b('0x1e')](_0x766ff6);}return null;};}function patchUpdates(_0x35df17){return function(_0x545eb3){try{jsonpatch[_0x536b('0x1f')](_0x545eb3,_0x35df17,!![]);}catch(_0x4a77a2){return BPromise['reject'](_0x4a77a2);}return _0x545eb3[_0x536b('0x20')]();};}function saveUpdates(_0x14217d,_0x2873b8){return function(_0x5bf377){if(_0x5bf377){return _0x5bf377[_0x536b('0x21')](_0x14217d)[_0x536b('0x22')](function(_0x527b63){return _0x527b63;});}return null;};}function removeEntity(_0x4283ff,_0x1d4229){return function(_0x475abd){if(_0x475abd){return _0x475abd['destroy']()[_0x536b('0x22')](function(){var _0x5c4711=_0x475abd['get']({'plain':!![]});var _0x9c3f0e=_0x536b('0x23');return db[_0x536b('0x24')][_0x536b('0x25')]({'where':{'type':_0x9c3f0e,'resourceId':_0x5c4711['id']}})[_0x536b('0x22')](function(){return _0x475abd;});})[_0x536b('0x22')](function(){_0x4283ff[_0x536b('0x18')](0xcc)[_0x536b('0x19')]();});}};}function handleEntityNotFound(_0x47d201,_0x350191){return function(_0x3cf4b6){if(!_0x3cf4b6){_0x47d201['sendStatus'](0x194);}return _0x3cf4b6;};}function handleError(_0x479c0b,_0x34625b){_0x34625b=_0x34625b||0x1f4;return function(_0x4e43ea){logger[_0x536b('0x26')](_0x4e43ea['stack']);if(_0x4e43ea[_0x536b('0x27')]){delete _0x4e43ea[_0x536b('0x27')];}_0x479c0b['status'](_0x34625b)['send'](_0x4e43ea);};}exports[_0x536b('0x28')]=function(_0x56d54f,_0x1975ab){var _0x1ca94f={},_0x2718a3={},_0x2e8a3d={'count':0x0,'rows':[]};var _0x141bd5=_[_0x536b('0x29')](db[_0x536b('0x2a')]['rawAttributes'],function(_0x5031a2){return{'name':_0x5031a2['fieldName'],'type':_0x5031a2['type'][_0x536b('0x2b')]};});_0x2718a3['model']=_[_0x536b('0x29')](_0x141bd5,_0x536b('0x27'));_0x2718a3['query']=_[_0x536b('0x2c')](_0x56d54f[_0x536b('0x2d')]);_0x2718a3[_0x536b('0x2e')]=_[_0x536b('0x2f')](_0x2718a3['model'],_0x2718a3['query']);_0x1ca94f[_0x536b('0x30')]=_['intersection'](_0x2718a3[_0x536b('0x31')],qs[_0x536b('0x32')](_0x56d54f['query'][_0x536b('0x32')]));_0x1ca94f[_0x536b('0x30')]=_0x1ca94f[_0x536b('0x30')][_0x536b('0x33')]?_0x1ca94f[_0x536b('0x30')]:_0x2718a3[_0x536b('0x31')];if(!_0x56d54f[_0x536b('0x2d')][_0x536b('0x34')]('nolimit')){_0x1ca94f[_0x536b('0x1c')]=qs['limit'](_0x56d54f[_0x536b('0x2d')][_0x536b('0x1c')]);_0x1ca94f['offset']=qs[_0x536b('0x1b')](_0x56d54f[_0x536b('0x2d')][_0x536b('0x1b')]);}_0x1ca94f[_0x536b('0x35')]=qs[_0x536b('0x36')](_0x56d54f[_0x536b('0x2d')][_0x536b('0x36')]);_0x1ca94f[_0x536b('0x37')]=qs[_0x536b('0x2e')](_['pick'](_0x56d54f[_0x536b('0x2d')],_0x2718a3[_0x536b('0x2e')]));if(_0x56d54f['query'][_0x536b('0x38')]){_0x1ca94f[_0x536b('0x37')]=_['merge'](_0x1ca94f[_0x536b('0x37')],{'$or':_[_0x536b('0x29')](_0x141bd5,function(_0x565824){if(_0x565824[_0x536b('0x39')]!==_0x536b('0x3a')){var _0x16b77c={};_0x16b77c[_0x565824['name']]={'$like':'%'+_0x56d54f['query'][_0x536b('0x38')]+'%'};return _0x16b77c;}})});}_0x1ca94f=_['merge']({},_0x1ca94f,_0x56d54f['options']);var _0x25e7f1={'where':_0x1ca94f[_0x536b('0x37')]};return db[_0x536b('0x2a')]['count'](_0x25e7f1)['then'](function(_0x1c2802){_0x2e8a3d['count']=_0x1c2802;if(_0x56d54f[_0x536b('0x2d')][_0x536b('0x3b')]){_0x1ca94f[_0x536b('0x3c')]=[{'all':!![]}];}return db[_0x536b('0x2a')]['findAll'](_0x1ca94f);})[_0x536b('0x22')](function(_0x7b459d){_0x2e8a3d['rows']=_0x7b459d;return _0x2e8a3d;})[_0x536b('0x22')](respondWithFilteredResult(_0x1975ab,_0x1ca94f))[_0x536b('0x3d')](handleError(_0x1975ab,null));};exports['show']=function(_0x285a44,_0x253bd2){var _0x3f6356={'raw':![],'where':{'id':_0x285a44['params']['id']}},_0x52e861={};_0x52e861[_0x536b('0x31')]=_[_0x536b('0x2c')](db[_0x536b('0x2a')][_0x536b('0x3e')]);_0x52e861[_0x536b('0x2d')]=_[_0x536b('0x2c')](_0x285a44['query']);_0x52e861['filters']=_['intersection'](_0x52e861[_0x536b('0x31')],_0x52e861[_0x536b('0x2d')]);_0x3f6356[_0x536b('0x30')]=_[_0x536b('0x2f')](_0x52e861[_0x536b('0x31')],qs[_0x536b('0x32')](_0x285a44[_0x536b('0x2d')][_0x536b('0x32')]));_0x3f6356['attributes']=_0x3f6356[_0x536b('0x30')][_0x536b('0x33')]?_0x3f6356[_0x536b('0x30')]:_0x52e861['model'];if(_0x285a44[_0x536b('0x2d')][_0x536b('0x3b')]){_0x3f6356[_0x536b('0x3c')]=[{'all':!![]}];}_0x3f6356=_['merge']({},_0x3f6356,_0x285a44['options']);return db[_0x536b('0x2a')][_0x536b('0x3f')](_0x3f6356)[_0x536b('0x22')](handleEntityNotFound(_0x253bd2,null))[_0x536b('0x22')](respondWithResult(_0x253bd2,null))[_0x536b('0x3d')](handleError(_0x253bd2,null));};exports['create']=function(_0x3eeb26,_0x43034a){return db[_0x536b('0x2a')]['create'](_0x3eeb26[_0x536b('0x40')],{})[_0x536b('0x22')](function(_0x11b70){var _0x62f9e5=_0x3eeb26[_0x536b('0x41')][_0x536b('0x42')]({'plain':!![]});if(!_0x62f9e5)throw new Error(_0x536b('0x43'));if(_0x62f9e5[_0x536b('0x44')]===_0x536b('0x41')){var _0x33d1ba=_0x11b70[_0x536b('0x42')]({'plain':!![]});var _0x2e03a3=_0x536b('0x23');return db[_0x536b('0x45')]['find']({'where':{'name':_0x2e03a3,'userProfileId':_0x62f9e5[_0x536b('0x46')]},'raw':!![]})[_0x536b('0x22')](function(_0x59a6b0){if(_0x59a6b0&&_0x59a6b0[_0x536b('0x47')]===0x0){return db[_0x536b('0x24')][_0x536b('0x48')]({'name':_0x33d1ba['name'],'resourceId':_0x33d1ba['id'],'type':_0x59a6b0[_0x536b('0x27')],'sectionId':_0x59a6b0['id']},{})[_0x536b('0x22')](function(){return _0x11b70;});}else{return _0x11b70;}})['catch'](function(_0x3caaaa){logger[_0x536b('0x26')](_0x536b('0x49'),_0x3caaaa);throw _0x3caaaa;});}return _0x11b70;})[_0x536b('0x22')](respondWithResult(_0x43034a,0xc9))[_0x536b('0x3d')](handleError(_0x43034a,null));};exports[_0x536b('0x4a')]=function(_0x4541f5,_0x16aaa0){var _0x1bc2c3={'where':{'id':_0x4541f5[_0x536b('0x4b')]['id']}},_0x3febec={};_0x3febec[_0x536b('0x31')]=_['keys'](db[_0x536b('0x2a')][_0x536b('0x3e')]);_0x1bc2c3[_0x536b('0x30')]=_[_0x536b('0x2f')](_0x3febec[_0x536b('0x31')],qs['fields'](_0x4541f5['query'][_0x536b('0x32')]));_0x1bc2c3[_0x536b('0x30')]=_0x1bc2c3[_0x536b('0x30')][_0x536b('0x33')]?_0x1bc2c3[_0x536b('0x30')]:_0x3febec['model'];if(_0x4541f5[_0x536b('0x2d')][_0x536b('0x3b')]){_0x1bc2c3['include']=[{'all':!![]}];}_0x1bc2c3=_[_0x536b('0x4c')]({},_0x1bc2c3,_0x4541f5[_0x536b('0x4d')]);return db[_0x536b('0x2a')]['find'](_0x1bc2c3)[_0x536b('0x22')](handleEntityNotFound(_0x16aaa0,null))[_0x536b('0x22')](function(_0x2cdc96){if(_0x2cdc96){var _0x301981=_0x2cdc96[_0x536b('0x42')]({'plain':!![]});_0x301981=qs['omit'](_0x301981,['id',_0x536b('0x4e'),_0x536b('0x4f')]);_0x4541f5[_0x536b('0x40')]=_['omit'](_0x4541f5[_0x536b('0x40')],['id',_0x536b('0x4e'),'updatedAt']);return db['JscriptyProject'][_0x536b('0x48')](_[_0x536b('0x4c')](_0x301981,_0x4541f5[_0x536b('0x40')]),{'include':_0x4541f5[_0x536b('0x2d')][_0x536b('0x3b')]?[{'all':!![]}]:undefined})[_0x536b('0x22')](function(_0x3d8253){var _0x22f4f9=_0x4541f5['user'][_0x536b('0x42')]({'plain':!![]});if(!_0x22f4f9)throw new Error(_0x536b('0x43'));if(_0x22f4f9['role']===_0x536b('0x41')){var _0x38b4ad=_0x3d8253[_0x536b('0x42')]({'plain':!![]});var _0x1329ec=_0x536b('0x23');return db[_0x536b('0x45')][_0x536b('0x3f')]({'where':{'name':_0x1329ec,'userProfileId':_0x22f4f9[_0x536b('0x46')]},'raw':!![]})['then'](function(_0x34fbc6){if(_0x34fbc6&&_0x34fbc6['autoAssociation']===0x0){return db[_0x536b('0x24')][_0x536b('0x48')]({'name':_0x38b4ad[_0x536b('0x27')],'resourceId':_0x38b4ad['id'],'type':_0x34fbc6[_0x536b('0x27')],'sectionId':_0x34fbc6['id']},{})[_0x536b('0x22')](function(){return _0x3d8253;});}else{return _0x3d8253;}})['catch'](function(_0x3be32f){logger[_0x536b('0x26')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x3be32f);throw _0x3be32f;});}return _0x3d8253;});}})['then'](respondWithResult(_0x16aaa0,0xc9))[_0x536b('0x3d')](handleError(_0x16aaa0,null));};exports['update']=function(_0x52b9cc,_0x52fbd1){if(_0x52b9cc[_0x536b('0x40')]['id']){delete _0x52b9cc[_0x536b('0x40')]['id'];}return db[_0x536b('0x2a')][_0x536b('0x3f')]({'where':{'id':_0x52b9cc[_0x536b('0x4b')]['id']}})['then'](handleEntityNotFound(_0x52fbd1,null))[_0x536b('0x22')](saveUpdates(_0x52b9cc['body'],null))[_0x536b('0x22')](respondWithResult(_0x52fbd1,null))[_0x536b('0x3d')](handleError(_0x52fbd1,null));};exports[_0x536b('0x25')]=function(_0x479cb0,_0x4b3349){return db[_0x536b('0x2a')][_0x536b('0x3f')]({'where':{'id':_0x479cb0[_0x536b('0x4b')]['id']}})[_0x536b('0x22')](handleEntityNotFound(_0x4b3349,null))[_0x536b('0x22')](removeEntity(_0x4b3349,null))[_0x536b('0x3d')](handleError(_0x4b3349,null));};exports['getSessions']=function(_0x5cc974,_0x5ba65a,_0x7c84bf){var _0x1b86cc={'raw':!![],'where':{}};var _0x23935d={};var _0x4f76e9={'count':0x0,'rows':[]};return db[_0x536b('0x2a')][_0x536b('0x50')]({'where':{'id':_0x5cc974[_0x536b('0x4b')]['id']}})[_0x536b('0x22')](handleEntityNotFound(_0x5ba65a,null))[_0x536b('0x22')](function(_0x56a62c){if(_0x56a62c){_0x23935d[_0x536b('0x31')]=_[_0x536b('0x2c')](db['JscriptySessionReport'][_0x536b('0x3e')]);_0x23935d[_0x536b('0x2d')]=_[_0x536b('0x2c')](_0x5cc974[_0x536b('0x2d')]);_0x23935d[_0x536b('0x2e')]=_['intersection'](_0x23935d[_0x536b('0x31')],_0x23935d[_0x536b('0x2d')]);_0x1b86cc['attributes']=_[_0x536b('0x2f')](_0x23935d[_0x536b('0x31')],qs[_0x536b('0x32')](_0x5cc974[_0x536b('0x2d')]['fields']));_0x1b86cc['attributes']=_0x1b86cc[_0x536b('0x30')]['length']?_0x1b86cc['attributes']:_0x23935d[_0x536b('0x31')];if(!_0x5cc974[_0x536b('0x2d')][_0x536b('0x34')](_0x536b('0x51'))){_0x1b86cc['limit']=qs[_0x536b('0x1c')](_0x5cc974[_0x536b('0x2d')]['limit']);_0x1b86cc[_0x536b('0x1b')]=qs[_0x536b('0x1b')](_0x5cc974[_0x536b('0x2d')][_0x536b('0x1b')]);}_0x1b86cc[_0x536b('0x35')]=qs['sort'](_0x5cc974[_0x536b('0x2d')][_0x536b('0x36')]);_0x1b86cc[_0x536b('0x37')]=qs[_0x536b('0x2e')](_['pick'](_0x5cc974[_0x536b('0x2d')],_0x23935d[_0x536b('0x2e')]));_0x1b86cc[_0x536b('0x37')][_0x536b('0x52')]=_0x56a62c['id'];if(_0x5cc974['query'][_0x536b('0x38')]){_0x1b86cc['where']=_[_0x536b('0x4c')](_0x1b86cc[_0x536b('0x37')],{'$or':_[_0x536b('0x29')](_0x1b86cc[_0x536b('0x30')],function(_0x5338c4){var _0x1c45fd={};_0x1c45fd[_0x5338c4]={'$like':'%'+_0x5cc974['query'][_0x536b('0x38')]+'%'};return _0x1c45fd;})});}_0x1b86cc=_[_0x536b('0x4c')]({},_0x1b86cc,_0x5cc974['options']);return db['JscriptySessionReport'][_0x536b('0x1a')]({'where':_0x1b86cc[_0x536b('0x37')]})['then'](function(_0x439473){_0x4f76e9['count']=_0x439473;if(_0x5cc974['query'][_0x536b('0x3b')]){_0x1b86cc['include']=[{'all':!![]}];}return db[_0x536b('0x53')][_0x536b('0x54')](_0x1b86cc);})[_0x536b('0x22')](function(_0x452a43){_0x4f76e9[_0x536b('0x55')]=_0x452a43;return _0x4f76e9;});}})['then'](respondWithFilteredResult(_0x5ba65a,_0x1b86cc))[_0x536b('0x3d')](handleError(_0x5ba65a,null));};exports['getAnswers']=function(_0x20cfee,_0x456ccb,_0x116d8d){var _0x14a946={'raw':!![],'where':{}};var _0x2b3b10={};var _0x1dbd42={'count':0x0,'rows':[]};return db[_0x536b('0x2a')]['findOne']({'where':{'id':_0x20cfee[_0x536b('0x4b')]['id']}})[_0x536b('0x22')](handleEntityNotFound(_0x456ccb,null))['then'](function(_0x4cd8bd){if(_0x4cd8bd){_0x2b3b10[_0x536b('0x31')]=_[_0x536b('0x2c')](db[_0x536b('0x56')]['rawAttributes']);_0x2b3b10[_0x536b('0x2d')]=_[_0x536b('0x2c')](_0x20cfee['query']);_0x2b3b10[_0x536b('0x2e')]=_[_0x536b('0x2f')](_0x2b3b10[_0x536b('0x31')],_0x2b3b10[_0x536b('0x2d')]);_0x14a946[_0x536b('0x30')]=_[_0x536b('0x2f')](_0x2b3b10[_0x536b('0x31')],qs[_0x536b('0x32')](_0x20cfee[_0x536b('0x2d')][_0x536b('0x32')]));_0x14a946[_0x536b('0x30')]=_0x14a946[_0x536b('0x30')]['length']?_0x14a946['attributes']:_0x2b3b10['model'];if(!_0x20cfee[_0x536b('0x2d')]['hasOwnProperty'](_0x536b('0x51'))){_0x14a946[_0x536b('0x1c')]=qs[_0x536b('0x1c')](_0x20cfee['query'][_0x536b('0x1c')]);_0x14a946['offset']=qs['offset'](_0x20cfee[_0x536b('0x2d')][_0x536b('0x1b')]);}_0x14a946[_0x536b('0x35')]=qs[_0x536b('0x36')](_0x20cfee[_0x536b('0x2d')][_0x536b('0x36')]);_0x14a946[_0x536b('0x37')]=qs[_0x536b('0x2e')](_['pick'](_0x20cfee[_0x536b('0x2d')],_0x2b3b10['filters']));_0x14a946[_0x536b('0x37')]['ProjectId']=_0x4cd8bd['id'];if(_0x20cfee[_0x536b('0x2d')][_0x536b('0x38')]){_0x14a946[_0x536b('0x37')]=_[_0x536b('0x4c')](_0x14a946['where'],{'$or':_['map'](_0x14a946['attributes'],function(_0x2a6878){var _0x1ee4ea={};_0x1ee4ea[_0x2a6878]={'$like':'%'+_0x20cfee[_0x536b('0x2d')][_0x536b('0x38')]+'%'};return _0x1ee4ea;})});}_0x14a946=_[_0x536b('0x4c')]({},_0x14a946,_0x20cfee[_0x536b('0x4d')]);return db['JscriptyAnswerReport']['count']({'where':_0x14a946[_0x536b('0x37')]})['then'](function(_0x17fbf3){_0x1dbd42[_0x536b('0x1a')]=_0x17fbf3;if(_0x20cfee['query'][_0x536b('0x3b')]){_0x14a946['include']=[{'all':!![]}];}return db[_0x536b('0x56')][_0x536b('0x54')](_0x14a946);})[_0x536b('0x22')](function(_0x1efca0){_0x1dbd42['rows']=_0x1efca0;return _0x1dbd42;});}})[_0x536b('0x22')](respondWithFilteredResult(_0x456ccb,_0x14a946))[_0x536b('0x3d')](handleError(_0x456ccb,null));};function char(_0x5b18f5){return'number'===typeof _0x5b18f5?String[_0x536b('0x57')][_0x536b('0x1f')](null,arguments):_0x5b18f5;}function needsEncapsulation(_0x5d9d0b){return!!_0x5d9d0b&&(_0x5d9d0b[_0x536b('0x58')]()[_0x536b('0x59')](char(0xd))>=0x0||_0x5d9d0b[_0x536b('0x58')]()[_0x536b('0x59')](char(0xa))>=0x0||_0x5d9d0b[_0x536b('0x58')]()['indexOf'](char(0x2c))>=0x0||_0x5d9d0b[_0x536b('0x58')]()[_0x536b('0x59')](char(0x22))>=0x0);}function encapsulate(_0x112343){var _0x4acc82=char(0x22),_0x311f64='\x5c'+char(0x22),_0x692de=_0x112343[_0x536b('0x58')]()['replace'](new RegExp(_0x4acc82,'g'),_0x311f64);return _0x4acc82+_0x692de+_0x4acc82;}exports[_0x536b('0x5a')]=function(_0x19704,_0x4ac1c1,_0xe18009){var _0x492b64,_0x34e812;var _0x144f3f={'where':{'ProjectId':_0x19704[_0x536b('0x4b')]['id']}};if(_0x19704[_0x536b('0x2d')][_0x536b('0x5b')]){_0x144f3f[_0x536b('0x37')][_0x536b('0x5c')]=JSON['parse'](_0x19704['query']['startTime']);}return db[_0x536b('0x53')][_0x536b('0x54')](_0x144f3f)[_0x536b('0x22')](handleEntityNotFound(_0x4ac1c1,null))[_0x536b('0x22')](function(_0x7e549){if(_0x7e549){_0x492b64=_0x7e549;return db['JscriptyQuestionReport'][_0x536b('0x54')]({'where':{'SessionId':{'$in':_['map'](_0x492b64,'id')},'ProjectId':_0x19704[_0x536b('0x4b')]['id']},'order':'-createdAt'});}})[_0x536b('0x22')](handleEntityNotFound(_0x4ac1c1,null))[_0x536b('0x22')](function(_0x4fcec7){if(_0x4fcec7){_0x34e812=_0x4fcec7;var _0xb41ead={};for(var _0x3887c5=0x0,_0x793740=_0x34e812['length'];_0x3887c5<_0x793740;_0x3887c5++){if(!_0xb41ead[_0x536b('0x34')](_0x34e812[_0x3887c5][_0x536b('0x5d')])){_0xb41ead[_0x34e812[_0x3887c5]['questionId']]=needsEncapsulation(_0x34e812[_0x3887c5][_0x536b('0x5e')])?encapsulate(_0x34e812[_0x3887c5]['question']):_0x34e812[_0x3887c5]['question'];}}var _0x2577f0=[],_0x5686ea={};for(var _0x2935e8=0x0,_0x542ccc=_0x492b64[_0x536b('0x33')];_0x2935e8<_0x542ccc;_0x2935e8++){_0x5686ea={'ProjectId':_0x19704[_0x536b('0x4b')]['id'],'SessionId':_0x492b64[_0x2935e8]['id'],'StartTime':moment(_0x492b64[_0x2935e8]['starttime'])['format'](_0x536b('0x5f'))};for(var _0x3b4ef0=0x0,_0x1efdfd=_0x34e812['length'];_0x3b4ef0<_0x1efdfd;_0x3b4ef0++){if(_0x34e812[_0x3b4ef0][_0x536b('0x60')]==_0x492b64[_0x2935e8]['id']&&_0xb41ead[_0x536b('0x34')](_0x34e812[_0x3b4ef0]['questionId'])){_0x5686ea[_0xb41ead[_0x34e812[_0x3b4ef0][_0x536b('0x5d')]]]=_0x34e812[_0x3b4ef0][_0x536b('0x61')];}}for(var _0x1bb98c in _0xb41ead){if(!_0x5686ea[_0x536b('0x34')](_0xb41ead[_0x1bb98c])){_0x5686ea[_0xb41ead[_0x1bb98c]]=null;}}_0x2577f0['push'](_0x5686ea);}return _0x2577f0;}})[_0x536b('0x22')](function(_0x4b72c2){if(!_[_0x536b('0x62')](_0x4b72c2)){var _0x3bc8f9=toCsv(_0x4b72c2);var _0x29e35f=Date[_0x536b('0x63')]();fs[_0x536b('0x64')](util[_0x536b('0x65')](_0x536b('0x66'),_0x19704[_0x536b('0x4b')]['id'],_0x29e35f),_0x3bc8f9);_0x4ac1c1[_0x536b('0x67')](_0x536b('0x68'),'attachment;\x20filename='+util[_0x536b('0x65')](_0x536b('0x69'),_0x19704[_0x536b('0x4b')]['id'],_0x29e35f));_0x4ac1c1[_0x536b('0x67')](_0x536b('0x6a'),'text/csv');return _0x4ac1c1[_0x536b('0x6b')](util[_0x536b('0x65')]('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x19704['params']['id'],_0x29e35f));}else{return _0x4ac1c1[_0x536b('0x17')](0xcc);}})[_0x536b('0x3d')](handleError(_0x4ac1c1,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff