// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xcd55=['set','Content-Range','apply','reject','save','update','then','destroy','get','Projects','name','send','map','rawAttributes','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filter','VIRTUAL','merge','options','JscriptyProject','includeAll','include','findAll','catch','show','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','params','createdAt','updatedAt','omit','body','getSessions','findOne','JscriptySessionReport','pick','ProjectId','JscriptyAnswerReport','number','fromCharCode','toString','indexOf','getSummary','startTime','parse','JscriptyQuestionReport','-createdAt','question','starttime','format','YYYY-MM-DD\x20HH:mm:ss','questionId','push','isEmpty','now','setHeader','Content-disposition','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','Content-type','text/csv','/tmp/Jscripty_Project_%d_Summary_%s.csv','html-pdf','eml-format','rimraf','zip-dir','moment','bluebird','path','sox','to-csv','ejs','lodash','squel','crypto','desk.js','querystring','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','end','status','json','count','offset','limit'];(function(_0x102881,_0x58d723){var _0x5c63d0=function(_0x955c59){while(--_0x955c59){_0x102881['push'](_0x102881['shift']());}};_0x5c63d0(++_0x58d723);}(_0xcd55,0x1b2));var _0x5cd5=function(_0x25e7cb,_0x3579b7){_0x25e7cb=_0x25e7cb-0x0;var _0x375d92=_0xcd55[_0x25e7cb];return _0x375d92;};'use strict';var pdf=require(_0x5cd5('0x0'));var emlformat=require(_0x5cd5('0x1'));var rimraf=require(_0x5cd5('0x2'));var zipdir=require(_0x5cd5('0x3'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0x5cd5('0x4'));var BPromise=require(_0x5cd5('0x5'));var Mustache=require('mustache');var util=require('util');var path=require(_0x5cd5('0x6'));var sox=require(_0x5cd5('0x7'));var csv=require(_0x5cd5('0x8'));var ejs=require(_0x5cd5('0x9'));var fs=require('fs');var _=require(_0x5cd5('0xa'));var squel=require(_0x5cd5('0xb'));var crypto=require(_0x5cd5('0xc'));var jsforce=require('jsforce');var deskjs=require(_0x5cd5('0xd'));var toCsv=require(_0x5cd5('0x8'));var querystring=require(_0x5cd5('0xe'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x5cd5('0xf'));var qs=require(_0x5cd5('0x10'));var as=require(_0x5cd5('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x5cd5('0x12'))(_0x5cd5('0x13'));var utils=require(_0x5cd5('0x14'));var config=require(_0x5cd5('0x15'));var db=require(_0x5cd5('0x16'))['db'];function respondWithStatusCode(_0x59d75f,_0x33d01b){_0x33d01b=_0x33d01b||0xcc;return function(_0x2eb782){if(_0x2eb782){return _0x59d75f[_0x5cd5('0x17')](_0x33d01b);}return _0x59d75f['status'](_0x33d01b)[_0x5cd5('0x18')]();};}function respondWithResult(_0x23a2dc,_0x181262){_0x181262=_0x181262||0xc8;return function(_0x294ced){if(_0x294ced){return _0x23a2dc[_0x5cd5('0x19')](_0x181262)[_0x5cd5('0x1a')](_0x294ced);}};}function respondWithFilteredResult(_0x5ee61,_0x37147b){return function(_0x2a1cd4){if(_0x2a1cd4){var _0x1162ea=_0x2a1cd4[_0x5cd5('0x1b')],_0x5e52bc=_0x37147b['offset'],_0x4aa28a=_0x37147b[_0x5cd5('0x1c')]+_0x37147b[_0x5cd5('0x1d')],_0x26c695;if(_0x4aa28a>=_0x1162ea){_0x4aa28a=_0x1162ea;_0x26c695=0xc8;}else{_0x26c695=0xce;}_0x5ee61[_0x5cd5('0x19')](_0x26c695);return _0x5ee61[_0x5cd5('0x1e')](_0x5cd5('0x1f'),_0x5e52bc+'-'+_0x4aa28a+'/'+_0x1162ea)['json'](_0x2a1cd4);}return null;};}function patchUpdates(_0x39e248){return function(_0x3befd4){try{jsonpatch[_0x5cd5('0x20')](_0x3befd4,_0x39e248,!![]);}catch(_0x42261f){return BPromise[_0x5cd5('0x21')](_0x42261f);}return _0x3befd4[_0x5cd5('0x22')]();};}function saveUpdates(_0x46cb15,_0x14062c){return function(_0x550208){if(_0x550208){return _0x550208[_0x5cd5('0x23')](_0x46cb15)[_0x5cd5('0x24')](function(_0x5af52b){return _0x5af52b;});}return null;};}function removeEntity(_0x3a6f74,_0x317193){return function(_0x12813a){if(_0x12813a){return _0x12813a[_0x5cd5('0x25')]()[_0x5cd5('0x24')](function(){var _0x558190=_0x12813a[_0x5cd5('0x26')]({'plain':!![]});var _0x2a391c=_0x5cd5('0x27');return db['UserProfileResource']['destroy']({'where':{'type':_0x2a391c,'resourceId':_0x558190['id']}})[_0x5cd5('0x24')](function(){return _0x12813a;});})[_0x5cd5('0x24')](function(){_0x3a6f74[_0x5cd5('0x19')](0xcc)[_0x5cd5('0x18')]();});}};}function handleEntityNotFound(_0x19c00a,_0x10b92e){return function(_0x8430b6){if(!_0x8430b6){_0x19c00a[_0x5cd5('0x17')](0x194);}return _0x8430b6;};}function handleError(_0x203537,_0xdac8f8){_0xdac8f8=_0xdac8f8||0x1f4;return function(_0x974d3d){logger['error'](_0x974d3d['stack']);if(_0x974d3d[_0x5cd5('0x28')]){delete _0x974d3d['name'];}_0x203537['status'](_0xdac8f8)[_0x5cd5('0x29')](_0x974d3d);};}exports['index']=function(_0x1ce93a,_0x596d5d){var _0x48c26d={},_0x5baf8a={},_0x48a7cb={'count':0x0,'rows':[]};var _0x469b02=_[_0x5cd5('0x2a')](db['JscriptyProject'][_0x5cd5('0x2b')],function(_0x4e296e){return{'name':_0x4e296e['fieldName'],'type':_0x4e296e[_0x5cd5('0x2c')][_0x5cd5('0x2d')]};});_0x5baf8a[_0x5cd5('0x2e')]=_[_0x5cd5('0x2a')](_0x469b02,_0x5cd5('0x28'));_0x5baf8a[_0x5cd5('0x2f')]=_[_0x5cd5('0x30')](_0x1ce93a[_0x5cd5('0x2f')]);_0x5baf8a[_0x5cd5('0x31')]=_[_0x5cd5('0x32')](_0x5baf8a[_0x5cd5('0x2e')],_0x5baf8a[_0x5cd5('0x2f')]);_0x48c26d[_0x5cd5('0x33')]=_[_0x5cd5('0x32')](_0x5baf8a[_0x5cd5('0x2e')],qs[_0x5cd5('0x34')](_0x1ce93a[_0x5cd5('0x2f')][_0x5cd5('0x34')]));_0x48c26d[_0x5cd5('0x33')]=_0x48c26d[_0x5cd5('0x33')][_0x5cd5('0x35')]?_0x48c26d[_0x5cd5('0x33')]:_0x5baf8a[_0x5cd5('0x2e')];if(!_0x1ce93a[_0x5cd5('0x2f')][_0x5cd5('0x36')](_0x5cd5('0x37'))){_0x48c26d['limit']=qs[_0x5cd5('0x1d')](_0x1ce93a[_0x5cd5('0x2f')][_0x5cd5('0x1d')]);_0x48c26d[_0x5cd5('0x1c')]=qs['offset'](_0x1ce93a[_0x5cd5('0x2f')]['offset']);}_0x48c26d[_0x5cd5('0x38')]=qs[_0x5cd5('0x39')](_0x1ce93a[_0x5cd5('0x2f')][_0x5cd5('0x39')]);_0x48c26d[_0x5cd5('0x3a')]=qs[_0x5cd5('0x31')](_['pick'](_0x1ce93a[_0x5cd5('0x2f')],_0x5baf8a['filters']),_0x469b02);if(_0x1ce93a['query'][_0x5cd5('0x3b')]){_0x48c26d['where']=_['merge'](_0x48c26d[_0x5cd5('0x3a')],{'$or':_[_0x5cd5('0x2a')](_0x469b02,function(_0x2435c5){if(_0x2435c5[_0x5cd5('0x2c')]!==_0x5cd5('0x3c')){var _0x498677={};_0x498677[_0x2435c5[_0x5cd5('0x28')]]={'$like':'%'+_0x1ce93a[_0x5cd5('0x2f')][_0x5cd5('0x3b')]+'%'};return _0x498677;}})});}_0x48c26d=_[_0x5cd5('0x3d')]({},_0x48c26d,_0x1ce93a[_0x5cd5('0x3e')]);var _0x22d783={'where':_0x48c26d['where']};return db[_0x5cd5('0x3f')][_0x5cd5('0x1b')](_0x22d783)['then'](function(_0x4e35d2){_0x48a7cb[_0x5cd5('0x1b')]=_0x4e35d2;if(_0x1ce93a[_0x5cd5('0x2f')][_0x5cd5('0x40')]){_0x48c26d[_0x5cd5('0x41')]=[{'all':!![]}];}return db[_0x5cd5('0x3f')][_0x5cd5('0x42')](_0x48c26d);})[_0x5cd5('0x24')](function(_0x426378){_0x48a7cb['rows']=_0x426378;return _0x48a7cb;})['then'](respondWithFilteredResult(_0x596d5d,_0x48c26d))[_0x5cd5('0x43')](handleError(_0x596d5d,null));};exports[_0x5cd5('0x44')]=function(_0x246399,_0x3624e5){var _0x2edebc={'raw':![],'where':{'id':_0x246399['params']['id']}},_0x390544={};_0x390544[_0x5cd5('0x2e')]=_[_0x5cd5('0x30')](db[_0x5cd5('0x3f')][_0x5cd5('0x2b')]);_0x390544[_0x5cd5('0x2f')]=_[_0x5cd5('0x30')](_0x246399[_0x5cd5('0x2f')]);_0x390544[_0x5cd5('0x31')]=_[_0x5cd5('0x32')](_0x390544[_0x5cd5('0x2e')],_0x390544[_0x5cd5('0x2f')]);_0x2edebc['attributes']=_[_0x5cd5('0x32')](_0x390544[_0x5cd5('0x2e')],qs[_0x5cd5('0x34')](_0x246399[_0x5cd5('0x2f')][_0x5cd5('0x34')]));_0x2edebc[_0x5cd5('0x33')]=_0x2edebc[_0x5cd5('0x33')][_0x5cd5('0x35')]?_0x2edebc[_0x5cd5('0x33')]:_0x390544[_0x5cd5('0x2e')];if(_0x246399[_0x5cd5('0x2f')][_0x5cd5('0x40')]){_0x2edebc[_0x5cd5('0x41')]=[{'all':!![]}];}_0x2edebc=_[_0x5cd5('0x3d')]({},_0x2edebc,_0x246399[_0x5cd5('0x3e')]);return db['JscriptyProject'][_0x5cd5('0x45')](_0x2edebc)[_0x5cd5('0x24')](handleEntityNotFound(_0x3624e5,null))[_0x5cd5('0x24')](respondWithResult(_0x3624e5,null))['catch'](handleError(_0x3624e5,null));};exports[_0x5cd5('0x46')]=function(_0x4f7590,_0x3fa58b){return db[_0x5cd5('0x3f')]['create'](_0x4f7590['body'],{})[_0x5cd5('0x24')](function(_0x5db939){var _0x133064=_0x4f7590[_0x5cd5('0x47')][_0x5cd5('0x26')]({'plain':!![]});if(!_0x133064)throw new Error(_0x5cd5('0x48'));if(_0x133064[_0x5cd5('0x49')]===_0x5cd5('0x47')){var _0x2fca64=_0x5db939[_0x5cd5('0x26')]({'plain':!![]});var _0x497cf0='Projects';return db[_0x5cd5('0x4a')]['find']({'where':{'name':_0x497cf0,'userProfileId':_0x133064[_0x5cd5('0x4b')]},'raw':!![]})[_0x5cd5('0x24')](function(_0x4320c7){if(_0x4320c7&&_0x4320c7[_0x5cd5('0x4c')]===0x0){return db[_0x5cd5('0x4d')][_0x5cd5('0x46')]({'name':_0x2fca64['name'],'resourceId':_0x2fca64['id'],'type':_0x4320c7[_0x5cd5('0x28')],'sectionId':_0x4320c7['id']},{})[_0x5cd5('0x24')](function(){return _0x5db939;});}else{return _0x5db939;}})['catch'](function(_0x5a4109){logger[_0x5cd5('0x4e')](_0x5cd5('0x4f'),_0x5a4109);throw _0x5a4109;});}return _0x5db939;})[_0x5cd5('0x24')](respondWithResult(_0x3fa58b,0xc9))[_0x5cd5('0x43')](handleError(_0x3fa58b,null));};exports[_0x5cd5('0x50')]=function(_0x1e1642,_0x15bf16){var _0x1b72ed={'where':{'id':_0x1e1642[_0x5cd5('0x51')]['id']}},_0x461729={};_0x461729[_0x5cd5('0x2e')]=_[_0x5cd5('0x30')](db['JscriptyProject'][_0x5cd5('0x2b')]);_0x1b72ed[_0x5cd5('0x33')]=_[_0x5cd5('0x32')](_0x461729[_0x5cd5('0x2e')],qs[_0x5cd5('0x34')](_0x1e1642['query'][_0x5cd5('0x34')]));_0x1b72ed[_0x5cd5('0x33')]=_0x1b72ed[_0x5cd5('0x33')][_0x5cd5('0x35')]?_0x1b72ed[_0x5cd5('0x33')]:_0x461729[_0x5cd5('0x2e')];if(_0x1e1642['query'][_0x5cd5('0x40')]){_0x1b72ed[_0x5cd5('0x41')]=[{'all':!![]}];}_0x1b72ed=_[_0x5cd5('0x3d')]({},_0x1b72ed,_0x1e1642[_0x5cd5('0x3e')]);return db[_0x5cd5('0x3f')][_0x5cd5('0x45')](_0x1b72ed)[_0x5cd5('0x24')](handleEntityNotFound(_0x15bf16,null))[_0x5cd5('0x24')](function(_0x16efad){if(_0x16efad){var _0x3f290d=_0x16efad[_0x5cd5('0x26')]({'plain':!![]});_0x3f290d=qs['omit'](_0x3f290d,['id',_0x5cd5('0x52'),_0x5cd5('0x53')]);_0x1e1642['body']=_[_0x5cd5('0x54')](_0x1e1642['body'],['id',_0x5cd5('0x52'),_0x5cd5('0x53')]);return db[_0x5cd5('0x3f')][_0x5cd5('0x46')](_[_0x5cd5('0x3d')](_0x3f290d,_0x1e1642[_0x5cd5('0x55')]),{'include':_0x1e1642[_0x5cd5('0x2f')]['includeAll']?[{'all':!![]}]:undefined})[_0x5cd5('0x24')](function(_0x37b6ad){var _0x236080=_0x1e1642['user']['get']({'plain':!![]});if(!_0x236080)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x236080[_0x5cd5('0x49')]===_0x5cd5('0x47')){var _0x2d14a9=_0x37b6ad[_0x5cd5('0x26')]({'plain':!![]});var _0xb7393c=_0x5cd5('0x27');return db[_0x5cd5('0x4a')][_0x5cd5('0x45')]({'where':{'name':_0xb7393c,'userProfileId':_0x236080['userProfileId']},'raw':!![]})['then'](function(_0x50edaa){if(_0x50edaa&&_0x50edaa[_0x5cd5('0x4c')]===0x0){return db['UserProfileResource'][_0x5cd5('0x46')]({'name':_0x2d14a9[_0x5cd5('0x28')],'resourceId':_0x2d14a9['id'],'type':_0x50edaa[_0x5cd5('0x28')],'sectionId':_0x50edaa['id']},{})[_0x5cd5('0x24')](function(){return _0x37b6ad;});}else{return _0x37b6ad;}})['catch'](function(_0x40fef1){logger[_0x5cd5('0x4e')](_0x5cd5('0x4f'),_0x40fef1);throw _0x40fef1;});}return _0x37b6ad;});}})[_0x5cd5('0x24')](respondWithResult(_0x15bf16,0xc9))[_0x5cd5('0x43')](handleError(_0x15bf16,null));};exports[_0x5cd5('0x23')]=function(_0x47fb36,_0x9d2293){if(_0x47fb36[_0x5cd5('0x55')]['id']){delete _0x47fb36['body']['id'];}return db['JscriptyProject'][_0x5cd5('0x45')]({'where':{'id':_0x47fb36[_0x5cd5('0x51')]['id']}})[_0x5cd5('0x24')](handleEntityNotFound(_0x9d2293,null))[_0x5cd5('0x24')](saveUpdates(_0x47fb36['body'],null))[_0x5cd5('0x24')](respondWithResult(_0x9d2293,null))[_0x5cd5('0x43')](handleError(_0x9d2293,null));};exports[_0x5cd5('0x25')]=function(_0x509c28,_0x4201b4){return db[_0x5cd5('0x3f')]['find']({'where':{'id':_0x509c28[_0x5cd5('0x51')]['id']}})[_0x5cd5('0x24')](handleEntityNotFound(_0x4201b4,null))[_0x5cd5('0x24')](removeEntity(_0x4201b4,null))[_0x5cd5('0x43')](handleError(_0x4201b4,null));};exports[_0x5cd5('0x56')]=function(_0x38db0c,_0x21be44,_0x3001db){var _0x39d9da={'raw':!![],'where':{}};var _0x81ce04={};var _0x3d8c70={'count':0x0,'rows':[]};return db[_0x5cd5('0x3f')][_0x5cd5('0x57')]({'where':{'id':_0x38db0c['params']['id']}})['then'](handleEntityNotFound(_0x21be44,null))[_0x5cd5('0x24')](function(_0x356f7c){if(_0x356f7c){_0x81ce04[_0x5cd5('0x2e')]=_[_0x5cd5('0x30')](db[_0x5cd5('0x58')]['rawAttributes']);_0x81ce04[_0x5cd5('0x2f')]=_['keys'](_0x38db0c[_0x5cd5('0x2f')]);_0x81ce04[_0x5cd5('0x31')]=_['intersection'](_0x81ce04['model'],_0x81ce04['query']);_0x39d9da[_0x5cd5('0x33')]=_['intersection'](_0x81ce04['model'],qs[_0x5cd5('0x34')](_0x38db0c['query'][_0x5cd5('0x34')]));_0x39d9da['attributes']=_0x39d9da['attributes'][_0x5cd5('0x35')]?_0x39d9da[_0x5cd5('0x33')]:_0x81ce04[_0x5cd5('0x2e')];if(!_0x38db0c[_0x5cd5('0x2f')]['hasOwnProperty'](_0x5cd5('0x37'))){_0x39d9da['limit']=qs[_0x5cd5('0x1d')](_0x38db0c[_0x5cd5('0x2f')]['limit']);_0x39d9da[_0x5cd5('0x1c')]=qs[_0x5cd5('0x1c')](_0x38db0c[_0x5cd5('0x2f')][_0x5cd5('0x1c')]);}_0x39d9da[_0x5cd5('0x38')]=qs['sort'](_0x38db0c[_0x5cd5('0x2f')]['sort']);_0x39d9da[_0x5cd5('0x3a')]=qs[_0x5cd5('0x31')](_[_0x5cd5('0x59')](_0x38db0c[_0x5cd5('0x2f')],_0x81ce04['filters']));_0x39d9da[_0x5cd5('0x3a')][_0x5cd5('0x5a')]=_0x356f7c['id'];if(_0x38db0c[_0x5cd5('0x2f')][_0x5cd5('0x3b')]){_0x39d9da['where']=_['merge'](_0x39d9da['where'],{'$or':_[_0x5cd5('0x2a')](_0x39d9da['attributes'],function(_0x2ebab9){var _0x3efb5c={};_0x3efb5c[_0x2ebab9]={'$like':'%'+_0x38db0c[_0x5cd5('0x2f')][_0x5cd5('0x3b')]+'%'};return _0x3efb5c;})});}_0x39d9da=_[_0x5cd5('0x3d')]({},_0x39d9da,_0x38db0c[_0x5cd5('0x3e')]);return db[_0x5cd5('0x58')][_0x5cd5('0x1b')]({'where':_0x39d9da[_0x5cd5('0x3a')]})[_0x5cd5('0x24')](function(_0x3da774){_0x3d8c70[_0x5cd5('0x1b')]=_0x3da774;if(_0x38db0c[_0x5cd5('0x2f')][_0x5cd5('0x40')]){_0x39d9da['include']=[{'all':!![]}];}return db['JscriptySessionReport']['findAll'](_0x39d9da);})['then'](function(_0x42cfc8){_0x3d8c70['rows']=_0x42cfc8;return _0x3d8c70;});}})[_0x5cd5('0x24')](respondWithFilteredResult(_0x21be44,_0x39d9da))['catch'](handleError(_0x21be44,null));};exports['getAnswers']=function(_0x7796ee,_0x55bc55,_0x1f2eb2){var _0x28ddb6={'raw':!![],'where':{}};var _0x5740e9={};var _0x1f32a6={'count':0x0,'rows':[]};return db['JscriptyProject'][_0x5cd5('0x57')]({'where':{'id':_0x7796ee[_0x5cd5('0x51')]['id']}})[_0x5cd5('0x24')](handleEntityNotFound(_0x55bc55,null))['then'](function(_0x715686){if(_0x715686){_0x5740e9[_0x5cd5('0x2e')]=_[_0x5cd5('0x30')](db[_0x5cd5('0x5b')][_0x5cd5('0x2b')]);_0x5740e9['query']=_['keys'](_0x7796ee[_0x5cd5('0x2f')]);_0x5740e9['filters']=_[_0x5cd5('0x32')](_0x5740e9[_0x5cd5('0x2e')],_0x5740e9[_0x5cd5('0x2f')]);_0x28ddb6['attributes']=_[_0x5cd5('0x32')](_0x5740e9[_0x5cd5('0x2e')],qs[_0x5cd5('0x34')](_0x7796ee[_0x5cd5('0x2f')][_0x5cd5('0x34')]));_0x28ddb6['attributes']=_0x28ddb6[_0x5cd5('0x33')][_0x5cd5('0x35')]?_0x28ddb6[_0x5cd5('0x33')]:_0x5740e9[_0x5cd5('0x2e')];if(!_0x7796ee[_0x5cd5('0x2f')]['hasOwnProperty'](_0x5cd5('0x37'))){_0x28ddb6[_0x5cd5('0x1d')]=qs['limit'](_0x7796ee[_0x5cd5('0x2f')][_0x5cd5('0x1d')]);_0x28ddb6[_0x5cd5('0x1c')]=qs['offset'](_0x7796ee['query'][_0x5cd5('0x1c')]);}_0x28ddb6[_0x5cd5('0x38')]=qs[_0x5cd5('0x39')](_0x7796ee[_0x5cd5('0x2f')][_0x5cd5('0x39')]);_0x28ddb6[_0x5cd5('0x3a')]=qs[_0x5cd5('0x31')](_[_0x5cd5('0x59')](_0x7796ee[_0x5cd5('0x2f')],_0x5740e9[_0x5cd5('0x31')]));_0x28ddb6['where'][_0x5cd5('0x5a')]=_0x715686['id'];if(_0x7796ee[_0x5cd5('0x2f')][_0x5cd5('0x3b')]){_0x28ddb6[_0x5cd5('0x3a')]=_[_0x5cd5('0x3d')](_0x28ddb6['where'],{'$or':_[_0x5cd5('0x2a')](_0x28ddb6['attributes'],function(_0x16cfe2){var _0x3b5870={};_0x3b5870[_0x16cfe2]={'$like':'%'+_0x7796ee[_0x5cd5('0x2f')]['filter']+'%'};return _0x3b5870;})});}_0x28ddb6=_[_0x5cd5('0x3d')]({},_0x28ddb6,_0x7796ee['options']);return db[_0x5cd5('0x5b')][_0x5cd5('0x1b')]({'where':_0x28ddb6[_0x5cd5('0x3a')]})['then'](function(_0x4eefd2){_0x1f32a6['count']=_0x4eefd2;if(_0x7796ee['query'][_0x5cd5('0x40')]){_0x28ddb6[_0x5cd5('0x41')]=[{'all':!![]}];}return db[_0x5cd5('0x5b')][_0x5cd5('0x42')](_0x28ddb6);})['then'](function(_0x345d40){_0x1f32a6['rows']=_0x345d40;return _0x1f32a6;});}})['then'](respondWithFilteredResult(_0x55bc55,_0x28ddb6))[_0x5cd5('0x43')](handleError(_0x55bc55,null));};function char(_0x29b3a8){return _0x5cd5('0x5c')===typeof _0x29b3a8?String[_0x5cd5('0x5d')][_0x5cd5('0x20')](null,arguments):_0x29b3a8;}function needsEncapsulation(_0x2abe6){return!!_0x2abe6&&(_0x2abe6['toString']()['indexOf'](char(0xd))>=0x0||_0x2abe6[_0x5cd5('0x5e')]()['indexOf'](char(0xa))>=0x0||_0x2abe6[_0x5cd5('0x5e')]()[_0x5cd5('0x5f')](char(0x2c))>=0x0||_0x2abe6['toString']()[_0x5cd5('0x5f')](char(0x22))>=0x0);}function encapsulate(_0x1b7ccd){var _0x7981d0=char(0x22),_0xfe39fb='\x5c'+char(0x22),_0x439435=_0x1b7ccd[_0x5cd5('0x5e')]()['replace'](new RegExp(_0x7981d0,'g'),_0xfe39fb);return _0x7981d0+_0x439435+_0x7981d0;}exports[_0x5cd5('0x60')]=function(_0x1ac908,_0x37c8d4,_0xf809c1){var _0x48af5f,_0x4d6874;var _0x3bb026={'where':{'ProjectId':_0x1ac908[_0x5cd5('0x51')]['id']}};if(_0x1ac908[_0x5cd5('0x2f')][_0x5cd5('0x61')]){_0x3bb026[_0x5cd5('0x3a')]['starttime']=JSON[_0x5cd5('0x62')](_0x1ac908[_0x5cd5('0x2f')]['startTime']);}return db['JscriptySessionReport']['findAll'](_0x3bb026)[_0x5cd5('0x24')](handleEntityNotFound(_0x37c8d4,null))[_0x5cd5('0x24')](function(_0x3ea06b){if(_0x3ea06b){_0x48af5f=_0x3ea06b;return db[_0x5cd5('0x63')]['findAll']({'where':{'SessionId':{'$in':_[_0x5cd5('0x2a')](_0x48af5f,'id')},'ProjectId':_0x1ac908[_0x5cd5('0x51')]['id']},'order':_0x5cd5('0x64')});}})[_0x5cd5('0x24')](handleEntityNotFound(_0x37c8d4,null))[_0x5cd5('0x24')](function(_0x37c189){if(_0x37c189){_0x4d6874=_0x37c189;var _0x26e1fb={};for(var _0x1397ff=0x0,_0x5602cd=_0x4d6874[_0x5cd5('0x35')];_0x1397ff<_0x5602cd;_0x1397ff++){if(!_0x26e1fb['hasOwnProperty'](_0x4d6874[_0x1397ff]['questionId'])){_0x26e1fb[_0x4d6874[_0x1397ff]['questionId']]=needsEncapsulation(_0x4d6874[_0x1397ff][_0x5cd5('0x65')])?encapsulate(_0x4d6874[_0x1397ff]['question']):_0x4d6874[_0x1397ff]['question'];}}var _0x396800=[],_0x1387d6={};for(var _0x3171e1=0x0,_0x392d2d=_0x48af5f[_0x5cd5('0x35')];_0x3171e1<_0x392d2d;_0x3171e1++){_0x1387d6={'ProjectId':_0x1ac908[_0x5cd5('0x51')]['id'],'SessionId':_0x48af5f[_0x3171e1]['id'],'StartTime':moment(_0x48af5f[_0x3171e1][_0x5cd5('0x66')])[_0x5cd5('0x67')](_0x5cd5('0x68'))};for(var _0x158ca9=0x0,_0x3c7f69=_0x4d6874[_0x5cd5('0x35')];_0x158ca9<_0x3c7f69;_0x158ca9++){if(_0x4d6874[_0x158ca9]['SessionId']==_0x48af5f[_0x3171e1]['id']&&_0x26e1fb[_0x5cd5('0x36')](_0x4d6874[_0x158ca9][_0x5cd5('0x69')])){_0x1387d6[_0x26e1fb[_0x4d6874[_0x158ca9][_0x5cd5('0x69')]]]=_0x4d6874[_0x158ca9]['answer'];}}for(var _0x429e50 in _0x26e1fb){if(!_0x1387d6[_0x5cd5('0x36')](_0x26e1fb[_0x429e50])){_0x1387d6[_0x26e1fb[_0x429e50]]=null;}}_0x396800[_0x5cd5('0x6a')](_0x1387d6);}return _0x396800;}})['then'](function(_0x5eedf0){if(!_[_0x5cd5('0x6b')](_0x5eedf0)){var _0x1235dd=toCsv(_0x5eedf0);var _0x3053db=Date[_0x5cd5('0x6c')]();fs['writeFileSync'](util['format']('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x1ac908[_0x5cd5('0x51')]['id'],_0x3053db),_0x1235dd);_0x37c8d4[_0x5cd5('0x6d')](_0x5cd5('0x6e'),_0x5cd5('0x6f')+util['format'](_0x5cd5('0x70'),_0x1ac908[_0x5cd5('0x51')]['id'],_0x3053db));_0x37c8d4[_0x5cd5('0x6d')](_0x5cd5('0x71'),_0x5cd5('0x72'));return _0x37c8d4['download'](util['format'](_0x5cd5('0x73'),_0x1ac908[_0x5cd5('0x51')]['id'],_0x3053db));}else{return _0x37c8d4[_0x5cd5('0x17')](0xcc);}})[_0x5cd5('0x43')](handleError(_0x37c8d4,null));};
\ No newline at end of file
+var _0xcc0e=['JscriptySessionReport','nolimit','ProjectId','getAnswers','JscriptyAnswerReport','number','toString','indexOf','replace','getSummary','startTime','parse','JscriptyQuestionReport','-createdAt','questionId','question','starttime','format','SessionId','answer','push','isEmpty','writeFileSync','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','Content-disposition','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','Content-type','text/csv','download','html-pdf','eml-format','rimraf','fast-json-patch','request-promise','bluebird','util','sox','to-csv','ejs','squel','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','sendStatus','status','end','json','offset','set','Content-Range','apply','then','destroy','get','UserProfileResource','error','stack','name','send','index','map','JscriptyProject','rawAttributes','fieldName','type','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','limit','order','sort','where','pick','filter','merge','VIRTUAL','options','count','includeAll','findAll','rows','catch','params','include','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Projects','UserProfileSection','find','userProfileId','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','omit','updatedAt','autoAssociation','update','getSessions','findOne'];(function(_0x4565bf,_0x5ad9d6){var _0x5610ba=function(_0x170988){while(--_0x170988){_0x4565bf['push'](_0x4565bf['shift']());}};_0x5610ba(++_0x5ad9d6);}(_0xcc0e,0x178));var _0xecc0=function(_0x7f9e63,_0x2aab08){_0x7f9e63=_0x7f9e63-0x0;var _0x361f7b=_0xcc0e[_0x7f9e63];return _0x361f7b;};'use strict';var pdf=require(_0xecc0('0x0'));var emlformat=require(_0xecc0('0x1'));var rimraf=require(_0xecc0('0x2'));var zipdir=require('zip-dir');var jsonpatch=require(_0xecc0('0x3'));var rp=require(_0xecc0('0x4'));var moment=require('moment');var BPromise=require(_0xecc0('0x5'));var Mustache=require('mustache');var util=require(_0xecc0('0x6'));var path=require('path');var sox=require(_0xecc0('0x7'));var csv=require(_0xecc0('0x8'));var ejs=require(_0xecc0('0x9'));var fs=require('fs');var _=require('lodash');var squel=require(_0xecc0('0xa'));var crypto=require('crypto');var jsforce=require(_0xecc0('0xb'));var deskjs=require(_0xecc0('0xc'));var toCsv=require(_0xecc0('0x8'));var querystring=require(_0xecc0('0xd'));var Papa=require(_0xecc0('0xe'));var Redis=require(_0xecc0('0xf'));var authService=require('../../components/auth/service');var qs=require(_0xecc0('0x10'));var as=require(_0xecc0('0x11'));var hardwareService=require(_0xecc0('0x12'));var logger=require(_0xecc0('0x13'))(_0xecc0('0x14'));var utils=require('../../config/utils');var config=require('../../config/environment');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x6ff669,_0xaf0e2b){_0xaf0e2b=_0xaf0e2b||0xcc;return function(_0xd9a824){if(_0xd9a824){return _0x6ff669[_0xecc0('0x15')](_0xaf0e2b);}return _0x6ff669[_0xecc0('0x16')](_0xaf0e2b)[_0xecc0('0x17')]();};}function respondWithResult(_0x590ac6,_0x4cd90d){_0x4cd90d=_0x4cd90d||0xc8;return function(_0x5b67a1){if(_0x5b67a1){return _0x590ac6[_0xecc0('0x16')](_0x4cd90d)[_0xecc0('0x18')](_0x5b67a1);}};}function respondWithFilteredResult(_0x31d146,_0x236ae6){return function(_0x41805e){if(_0x41805e){var _0x1d084d=_0x41805e['count'],_0x5dcb2c=_0x236ae6[_0xecc0('0x19')],_0x32c31c=_0x236ae6[_0xecc0('0x19')]+_0x236ae6['limit'],_0x54ebc1;if(_0x32c31c>=_0x1d084d){_0x32c31c=_0x1d084d;_0x54ebc1=0xc8;}else{_0x54ebc1=0xce;}_0x31d146[_0xecc0('0x16')](_0x54ebc1);return _0x31d146[_0xecc0('0x1a')](_0xecc0('0x1b'),_0x5dcb2c+'-'+_0x32c31c+'/'+_0x1d084d)[_0xecc0('0x18')](_0x41805e);}return null;};}function patchUpdates(_0x32584d){return function(_0x19b0e8){try{jsonpatch[_0xecc0('0x1c')](_0x19b0e8,_0x32584d,!![]);}catch(_0x296b74){return BPromise['reject'](_0x296b74);}return _0x19b0e8['save']();};}function saveUpdates(_0x1d60b9,_0x570267){return function(_0x43f195){if(_0x43f195){return _0x43f195['update'](_0x1d60b9)[_0xecc0('0x1d')](function(_0x10b13a){return _0x10b13a;});}return null;};}function removeEntity(_0x4bb3ac,_0x5962ed){return function(_0x416702){if(_0x416702){return _0x416702[_0xecc0('0x1e')]()['then'](function(){var _0x25ebbb=_0x416702[_0xecc0('0x1f')]({'plain':!![]});var _0x235647='Projects';return db[_0xecc0('0x20')][_0xecc0('0x1e')]({'where':{'type':_0x235647,'resourceId':_0x25ebbb['id']}})[_0xecc0('0x1d')](function(){return _0x416702;});})[_0xecc0('0x1d')](function(){_0x4bb3ac[_0xecc0('0x16')](0xcc)['end']();});}};}function handleEntityNotFound(_0x2c169d,_0x2ebdfe){return function(_0x402bd8){if(!_0x402bd8){_0x2c169d['sendStatus'](0x194);}return _0x402bd8;};}function handleError(_0x104aaa,_0x47940f){_0x47940f=_0x47940f||0x1f4;return function(_0x328804){logger[_0xecc0('0x21')](_0x328804[_0xecc0('0x22')]);if(_0x328804[_0xecc0('0x23')]){delete _0x328804[_0xecc0('0x23')];}_0x104aaa['status'](_0x47940f)[_0xecc0('0x24')](_0x328804);};}exports[_0xecc0('0x25')]=function(_0x213c76,_0x103a82){var _0x86bcd3={},_0x2644c9={},_0x42e15d={'count':0x0,'rows':[]};var _0x4d880e=_[_0xecc0('0x26')](db[_0xecc0('0x27')][_0xecc0('0x28')],function(_0x22fa6f){return{'name':_0x22fa6f[_0xecc0('0x29')],'type':_0x22fa6f[_0xecc0('0x2a')]['key']};});_0x2644c9[_0xecc0('0x2b')]=_[_0xecc0('0x26')](_0x4d880e,_0xecc0('0x23'));_0x2644c9[_0xecc0('0x2c')]=_[_0xecc0('0x2d')](_0x213c76[_0xecc0('0x2c')]);_0x2644c9[_0xecc0('0x2e')]=_[_0xecc0('0x2f')](_0x2644c9['model'],_0x2644c9['query']);_0x86bcd3[_0xecc0('0x30')]=_[_0xecc0('0x2f')](_0x2644c9['model'],qs['fields'](_0x213c76[_0xecc0('0x2c')][_0xecc0('0x31')]));_0x86bcd3[_0xecc0('0x30')]=_0x86bcd3[_0xecc0('0x30')][_0xecc0('0x32')]?_0x86bcd3['attributes']:_0x2644c9['model'];if(!_0x213c76[_0xecc0('0x2c')][_0xecc0('0x33')]('nolimit')){_0x86bcd3[_0xecc0('0x34')]=qs[_0xecc0('0x34')](_0x213c76[_0xecc0('0x2c')][_0xecc0('0x34')]);_0x86bcd3[_0xecc0('0x19')]=qs[_0xecc0('0x19')](_0x213c76[_0xecc0('0x2c')]['offset']);}_0x86bcd3[_0xecc0('0x35')]=qs[_0xecc0('0x36')](_0x213c76['query'][_0xecc0('0x36')]);_0x86bcd3[_0xecc0('0x37')]=qs[_0xecc0('0x2e')](_[_0xecc0('0x38')](_0x213c76[_0xecc0('0x2c')],_0x2644c9[_0xecc0('0x2e')]),_0x4d880e);if(_0x213c76[_0xecc0('0x2c')][_0xecc0('0x39')]){_0x86bcd3['where']=_[_0xecc0('0x3a')](_0x86bcd3[_0xecc0('0x37')],{'$or':_[_0xecc0('0x26')](_0x4d880e,function(_0x35a019){if(_0x35a019['type']!==_0xecc0('0x3b')){var _0x1879fb={};_0x1879fb[_0x35a019[_0xecc0('0x23')]]={'$like':'%'+_0x213c76[_0xecc0('0x2c')][_0xecc0('0x39')]+'%'};return _0x1879fb;}})});}_0x86bcd3=_[_0xecc0('0x3a')]({},_0x86bcd3,_0x213c76[_0xecc0('0x3c')]);var _0x407ba7={'where':_0x86bcd3[_0xecc0('0x37')]};return db[_0xecc0('0x27')][_0xecc0('0x3d')](_0x407ba7)[_0xecc0('0x1d')](function(_0x1b6621){_0x42e15d[_0xecc0('0x3d')]=_0x1b6621;if(_0x213c76[_0xecc0('0x2c')][_0xecc0('0x3e')]){_0x86bcd3['include']=[{'all':!![]}];}return db['JscriptyProject'][_0xecc0('0x3f')](_0x86bcd3);})['then'](function(_0x36307a){_0x42e15d[_0xecc0('0x40')]=_0x36307a;return _0x42e15d;})['then'](respondWithFilteredResult(_0x103a82,_0x86bcd3))[_0xecc0('0x41')](handleError(_0x103a82,null));};exports['show']=function(_0x1c1747,_0x5a015a){var _0x257df0={'raw':![],'where':{'id':_0x1c1747[_0xecc0('0x42')]['id']}},_0x2610ae={};_0x2610ae[_0xecc0('0x2b')]=_[_0xecc0('0x2d')](db['JscriptyProject'][_0xecc0('0x28')]);_0x2610ae['query']=_['keys'](_0x1c1747[_0xecc0('0x2c')]);_0x2610ae[_0xecc0('0x2e')]=_[_0xecc0('0x2f')](_0x2610ae[_0xecc0('0x2b')],_0x2610ae[_0xecc0('0x2c')]);_0x257df0[_0xecc0('0x30')]=_[_0xecc0('0x2f')](_0x2610ae[_0xecc0('0x2b')],qs[_0xecc0('0x31')](_0x1c1747['query']['fields']));_0x257df0[_0xecc0('0x30')]=_0x257df0[_0xecc0('0x30')][_0xecc0('0x32')]?_0x257df0[_0xecc0('0x30')]:_0x2610ae[_0xecc0('0x2b')];if(_0x1c1747[_0xecc0('0x2c')][_0xecc0('0x3e')]){_0x257df0[_0xecc0('0x43')]=[{'all':!![]}];}_0x257df0=_[_0xecc0('0x3a')]({},_0x257df0,_0x1c1747[_0xecc0('0x3c')]);return db[_0xecc0('0x27')]['find'](_0x257df0)[_0xecc0('0x1d')](handleEntityNotFound(_0x5a015a,null))[_0xecc0('0x1d')](respondWithResult(_0x5a015a,null))[_0xecc0('0x41')](handleError(_0x5a015a,null));};exports[_0xecc0('0x44')]=function(_0x1cb10e,_0x60faad){return db[_0xecc0('0x27')][_0xecc0('0x44')](_0x1cb10e[_0xecc0('0x45')],{})[_0xecc0('0x1d')](function(_0x577e9e){var _0x56010e=_0x1cb10e[_0xecc0('0x46')][_0xecc0('0x1f')]({'plain':!![]});if(!_0x56010e)throw new Error(_0xecc0('0x47'));if(_0x56010e[_0xecc0('0x48')]===_0xecc0('0x46')){var _0x47590d=_0x577e9e[_0xecc0('0x1f')]({'plain':!![]});var _0x2dd344=_0xecc0('0x49');return db[_0xecc0('0x4a')][_0xecc0('0x4b')]({'where':{'name':_0x2dd344,'userProfileId':_0x56010e[_0xecc0('0x4c')]},'raw':!![]})['then'](function(_0x1d7267){if(_0x1d7267&&_0x1d7267['autoAssociation']===0x0){return db['UserProfileResource']['create']({'name':_0x47590d[_0xecc0('0x23')],'resourceId':_0x47590d['id'],'type':_0x1d7267[_0xecc0('0x23')],'sectionId':_0x1d7267['id']},{})[_0xecc0('0x1d')](function(){return _0x577e9e;});}else{return _0x577e9e;}})['catch'](function(_0x5e7974){logger[_0xecc0('0x21')](_0xecc0('0x4d'),_0x5e7974);throw _0x5e7974;});}return _0x577e9e;})[_0xecc0('0x1d')](respondWithResult(_0x60faad,0xc9))[_0xecc0('0x41')](handleError(_0x60faad,null));};exports['clone']=function(_0x38274c,_0x2cbb30){var _0x590d11={'where':{'id':_0x38274c['params']['id']}},_0xe07a6c={};_0xe07a6c[_0xecc0('0x2b')]=_[_0xecc0('0x2d')](db[_0xecc0('0x27')][_0xecc0('0x28')]);_0x590d11[_0xecc0('0x30')]=_[_0xecc0('0x2f')](_0xe07a6c[_0xecc0('0x2b')],qs['fields'](_0x38274c['query'][_0xecc0('0x31')]));_0x590d11[_0xecc0('0x30')]=_0x590d11[_0xecc0('0x30')][_0xecc0('0x32')]?_0x590d11['attributes']:_0xe07a6c['model'];if(_0x38274c[_0xecc0('0x2c')][_0xecc0('0x3e')]){_0x590d11[_0xecc0('0x43')]=[{'all':!![]}];}_0x590d11=_[_0xecc0('0x3a')]({},_0x590d11,_0x38274c[_0xecc0('0x3c')]);return db['JscriptyProject'][_0xecc0('0x4b')](_0x590d11)['then'](handleEntityNotFound(_0x2cbb30,null))['then'](function(_0x398cbf){if(_0x398cbf){var _0x355632=_0x398cbf['get']({'plain':!![]});_0x355632=qs[_0xecc0('0x4e')](_0x355632,['id','createdAt',_0xecc0('0x4f')]);_0x38274c[_0xecc0('0x45')]=_[_0xecc0('0x4e')](_0x38274c[_0xecc0('0x45')],['id','createdAt',_0xecc0('0x4f')]);return db[_0xecc0('0x27')]['create'](_[_0xecc0('0x3a')](_0x355632,_0x38274c[_0xecc0('0x45')]),{'include':_0x38274c[_0xecc0('0x2c')]['includeAll']?[{'all':!![]}]:undefined})[_0xecc0('0x1d')](function(_0x532086){var _0x4d8995=_0x38274c[_0xecc0('0x46')][_0xecc0('0x1f')]({'plain':!![]});if(!_0x4d8995)throw new Error(_0xecc0('0x47'));if(_0x4d8995[_0xecc0('0x48')]==='user'){var _0x44a2b7=_0x532086[_0xecc0('0x1f')]({'plain':!![]});var _0x43cda5=_0xecc0('0x49');return db['UserProfileSection'][_0xecc0('0x4b')]({'where':{'name':_0x43cda5,'userProfileId':_0x4d8995['userProfileId']},'raw':!![]})[_0xecc0('0x1d')](function(_0x459326){if(_0x459326&&_0x459326[_0xecc0('0x50')]===0x0){return db['UserProfileResource']['create']({'name':_0x44a2b7['name'],'resourceId':_0x44a2b7['id'],'type':_0x459326['name'],'sectionId':_0x459326['id']},{})[_0xecc0('0x1d')](function(){return _0x532086;});}else{return _0x532086;}})[_0xecc0('0x41')](function(_0x22dd58){logger[_0xecc0('0x21')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x22dd58);throw _0x22dd58;});}return _0x532086;});}})[_0xecc0('0x1d')](respondWithResult(_0x2cbb30,0xc9))[_0xecc0('0x41')](handleError(_0x2cbb30,null));};exports[_0xecc0('0x51')]=function(_0x25e600,_0x214122){if(_0x25e600[_0xecc0('0x45')]['id']){delete _0x25e600[_0xecc0('0x45')]['id'];}return db[_0xecc0('0x27')][_0xecc0('0x4b')]({'where':{'id':_0x25e600['params']['id']}})['then'](handleEntityNotFound(_0x214122,null))['then'](saveUpdates(_0x25e600['body'],null))[_0xecc0('0x1d')](respondWithResult(_0x214122,null))[_0xecc0('0x41')](handleError(_0x214122,null));};exports['destroy']=function(_0x2a0f58,_0x1efdb6){return db['JscriptyProject'][_0xecc0('0x4b')]({'where':{'id':_0x2a0f58['params']['id']}})[_0xecc0('0x1d')](handleEntityNotFound(_0x1efdb6,null))[_0xecc0('0x1d')](removeEntity(_0x1efdb6,null))[_0xecc0('0x41')](handleError(_0x1efdb6,null));};exports[_0xecc0('0x52')]=function(_0x2b29ef,_0x3710e8,_0x228f52){var _0xed1961={'raw':!![],'where':{}};var _0x5eebfd={};var _0x4c3a9c={'count':0x0,'rows':[]};return db[_0xecc0('0x27')][_0xecc0('0x53')]({'where':{'id':_0x2b29ef[_0xecc0('0x42')]['id']}})[_0xecc0('0x1d')](handleEntityNotFound(_0x3710e8,null))[_0xecc0('0x1d')](function(_0x1c40a8){if(_0x1c40a8){_0x5eebfd[_0xecc0('0x2b')]=_[_0xecc0('0x2d')](db[_0xecc0('0x54')]['rawAttributes']);_0x5eebfd[_0xecc0('0x2c')]=_['keys'](_0x2b29ef[_0xecc0('0x2c')]);_0x5eebfd[_0xecc0('0x2e')]=_[_0xecc0('0x2f')](_0x5eebfd['model'],_0x5eebfd[_0xecc0('0x2c')]);_0xed1961[_0xecc0('0x30')]=_[_0xecc0('0x2f')](_0x5eebfd[_0xecc0('0x2b')],qs[_0xecc0('0x31')](_0x2b29ef[_0xecc0('0x2c')][_0xecc0('0x31')]));_0xed1961[_0xecc0('0x30')]=_0xed1961[_0xecc0('0x30')][_0xecc0('0x32')]?_0xed1961[_0xecc0('0x30')]:_0x5eebfd[_0xecc0('0x2b')];if(!_0x2b29ef[_0xecc0('0x2c')]['hasOwnProperty'](_0xecc0('0x55'))){_0xed1961['limit']=qs[_0xecc0('0x34')](_0x2b29ef[_0xecc0('0x2c')][_0xecc0('0x34')]);_0xed1961['offset']=qs[_0xecc0('0x19')](_0x2b29ef[_0xecc0('0x2c')][_0xecc0('0x19')]);}_0xed1961['order']=qs[_0xecc0('0x36')](_0x2b29ef[_0xecc0('0x2c')][_0xecc0('0x36')]);_0xed1961[_0xecc0('0x37')]=qs[_0xecc0('0x2e')](_[_0xecc0('0x38')](_0x2b29ef['query'],_0x5eebfd[_0xecc0('0x2e')]));_0xed1961[_0xecc0('0x37')][_0xecc0('0x56')]=_0x1c40a8['id'];if(_0x2b29ef[_0xecc0('0x2c')]['filter']){_0xed1961['where']=_[_0xecc0('0x3a')](_0xed1961[_0xecc0('0x37')],{'$or':_['map'](_0xed1961['attributes'],function(_0x270866){var _0x56696b={};_0x56696b[_0x270866]={'$like':'%'+_0x2b29ef['query']['filter']+'%'};return _0x56696b;})});}_0xed1961=_['merge']({},_0xed1961,_0x2b29ef['options']);return db[_0xecc0('0x54')][_0xecc0('0x3d')]({'where':_0xed1961['where']})[_0xecc0('0x1d')](function(_0x165962){_0x4c3a9c['count']=_0x165962;if(_0x2b29ef[_0xecc0('0x2c')][_0xecc0('0x3e')]){_0xed1961[_0xecc0('0x43')]=[{'all':!![]}];}return db[_0xecc0('0x54')]['findAll'](_0xed1961);})[_0xecc0('0x1d')](function(_0x3ce60f){_0x4c3a9c[_0xecc0('0x40')]=_0x3ce60f;return _0x4c3a9c;});}})[_0xecc0('0x1d')](respondWithFilteredResult(_0x3710e8,_0xed1961))[_0xecc0('0x41')](handleError(_0x3710e8,null));};exports[_0xecc0('0x57')]=function(_0x146a2c,_0xf49e3f,_0x39571f){var _0x5a41b0={'raw':!![],'where':{}};var _0x59c65f={};var _0x1d7a82={'count':0x0,'rows':[]};return db[_0xecc0('0x27')][_0xecc0('0x53')]({'where':{'id':_0x146a2c['params']['id']}})[_0xecc0('0x1d')](handleEntityNotFound(_0xf49e3f,null))[_0xecc0('0x1d')](function(_0x2a96ab){if(_0x2a96ab){_0x59c65f['model']=_[_0xecc0('0x2d')](db['JscriptyAnswerReport'][_0xecc0('0x28')]);_0x59c65f[_0xecc0('0x2c')]=_[_0xecc0('0x2d')](_0x146a2c[_0xecc0('0x2c')]);_0x59c65f[_0xecc0('0x2e')]=_[_0xecc0('0x2f')](_0x59c65f[_0xecc0('0x2b')],_0x59c65f[_0xecc0('0x2c')]);_0x5a41b0['attributes']=_[_0xecc0('0x2f')](_0x59c65f[_0xecc0('0x2b')],qs[_0xecc0('0x31')](_0x146a2c[_0xecc0('0x2c')][_0xecc0('0x31')]));_0x5a41b0[_0xecc0('0x30')]=_0x5a41b0[_0xecc0('0x30')]['length']?_0x5a41b0[_0xecc0('0x30')]:_0x59c65f[_0xecc0('0x2b')];if(!_0x146a2c[_0xecc0('0x2c')][_0xecc0('0x33')](_0xecc0('0x55'))){_0x5a41b0[_0xecc0('0x34')]=qs['limit'](_0x146a2c[_0xecc0('0x2c')][_0xecc0('0x34')]);_0x5a41b0['offset']=qs[_0xecc0('0x19')](_0x146a2c[_0xecc0('0x2c')][_0xecc0('0x19')]);}_0x5a41b0[_0xecc0('0x35')]=qs[_0xecc0('0x36')](_0x146a2c[_0xecc0('0x2c')][_0xecc0('0x36')]);_0x5a41b0[_0xecc0('0x37')]=qs[_0xecc0('0x2e')](_[_0xecc0('0x38')](_0x146a2c[_0xecc0('0x2c')],_0x59c65f['filters']));_0x5a41b0['where'][_0xecc0('0x56')]=_0x2a96ab['id'];if(_0x146a2c[_0xecc0('0x2c')]['filter']){_0x5a41b0[_0xecc0('0x37')]=_['merge'](_0x5a41b0[_0xecc0('0x37')],{'$or':_[_0xecc0('0x26')](_0x5a41b0['attributes'],function(_0x540940){var _0x23aceb={};_0x23aceb[_0x540940]={'$like':'%'+_0x146a2c['query'][_0xecc0('0x39')]+'%'};return _0x23aceb;})});}_0x5a41b0=_[_0xecc0('0x3a')]({},_0x5a41b0,_0x146a2c['options']);return db['JscriptyAnswerReport'][_0xecc0('0x3d')]({'where':_0x5a41b0[_0xecc0('0x37')]})['then'](function(_0x3437d3){_0x1d7a82[_0xecc0('0x3d')]=_0x3437d3;if(_0x146a2c[_0xecc0('0x2c')][_0xecc0('0x3e')]){_0x5a41b0['include']=[{'all':!![]}];}return db[_0xecc0('0x58')]['findAll'](_0x5a41b0);})['then'](function(_0x4f5f2d){_0x1d7a82[_0xecc0('0x40')]=_0x4f5f2d;return _0x1d7a82;});}})[_0xecc0('0x1d')](respondWithFilteredResult(_0xf49e3f,_0x5a41b0))[_0xecc0('0x41')](handleError(_0xf49e3f,null));};function char(_0x613a54){return _0xecc0('0x59')===typeof _0x613a54?String['fromCharCode'][_0xecc0('0x1c')](null,arguments):_0x613a54;}function needsEncapsulation(_0x557269){return!!_0x557269&&(_0x557269[_0xecc0('0x5a')]()['indexOf'](char(0xd))>=0x0||_0x557269['toString']()[_0xecc0('0x5b')](char(0xa))>=0x0||_0x557269[_0xecc0('0x5a')]()['indexOf'](char(0x2c))>=0x0||_0x557269['toString']()['indexOf'](char(0x22))>=0x0);}function encapsulate(_0x4af946){var _0x104419=char(0x22),_0x245804='\x5c'+char(0x22),_0x5e413a=_0x4af946[_0xecc0('0x5a')]()[_0xecc0('0x5c')](new RegExp(_0x104419,'g'),_0x245804);return _0x104419+_0x5e413a+_0x104419;}exports[_0xecc0('0x5d')]=function(_0x4b651f,_0x173076,_0x5d9d42){var _0x39b937,_0x29935f;var _0x36a1d8={'where':{'ProjectId':_0x4b651f[_0xecc0('0x42')]['id']}};if(_0x4b651f[_0xecc0('0x2c')][_0xecc0('0x5e')]){_0x36a1d8[_0xecc0('0x37')]['starttime']=JSON[_0xecc0('0x5f')](_0x4b651f['query'][_0xecc0('0x5e')]);}return db[_0xecc0('0x54')][_0xecc0('0x3f')](_0x36a1d8)[_0xecc0('0x1d')](handleEntityNotFound(_0x173076,null))[_0xecc0('0x1d')](function(_0x51ddf4){if(_0x51ddf4){_0x39b937=_0x51ddf4;return db[_0xecc0('0x60')][_0xecc0('0x3f')]({'where':{'SessionId':{'$in':_[_0xecc0('0x26')](_0x39b937,'id')},'ProjectId':_0x4b651f[_0xecc0('0x42')]['id']},'order':_0xecc0('0x61')});}})[_0xecc0('0x1d')](handleEntityNotFound(_0x173076,null))['then'](function(_0x4ca4cd){if(_0x4ca4cd){_0x29935f=_0x4ca4cd;var _0x218c58={};for(var _0x49d766=0x0,_0x6741e8=_0x29935f[_0xecc0('0x32')];_0x49d766<_0x6741e8;_0x49d766++){if(!_0x218c58['hasOwnProperty'](_0x29935f[_0x49d766][_0xecc0('0x62')])){_0x218c58[_0x29935f[_0x49d766][_0xecc0('0x62')]]=needsEncapsulation(_0x29935f[_0x49d766]['question'])?encapsulate(_0x29935f[_0x49d766][_0xecc0('0x63')]):_0x29935f[_0x49d766][_0xecc0('0x63')];}}var _0x1a4982=[],_0x394b2a={};for(var _0x35e208=0x0,_0x97fabe=_0x39b937['length'];_0x35e208<_0x97fabe;_0x35e208++){_0x394b2a={'ProjectId':_0x4b651f[_0xecc0('0x42')]['id'],'SessionId':_0x39b937[_0x35e208]['id'],'StartTime':moment(_0x39b937[_0x35e208][_0xecc0('0x64')])[_0xecc0('0x65')]('YYYY-MM-DD\x20HH:mm:ss')};for(var _0x2a8db9=0x0,_0x202b4c=_0x29935f[_0xecc0('0x32')];_0x2a8db9<_0x202b4c;_0x2a8db9++){if(_0x29935f[_0x2a8db9][_0xecc0('0x66')]==_0x39b937[_0x35e208]['id']&&_0x218c58['hasOwnProperty'](_0x29935f[_0x2a8db9][_0xecc0('0x62')])){_0x394b2a[_0x218c58[_0x29935f[_0x2a8db9]['questionId']]]=_0x29935f[_0x2a8db9][_0xecc0('0x67')];}}for(var _0x5823c9 in _0x218c58){if(!_0x394b2a[_0xecc0('0x33')](_0x218c58[_0x5823c9])){_0x394b2a[_0x218c58[_0x5823c9]]=null;}}_0x1a4982[_0xecc0('0x68')](_0x394b2a);}return _0x1a4982;}})[_0xecc0('0x1d')](function(_0x38d2ee){if(!_[_0xecc0('0x69')](_0x38d2ee)){var _0x2e9c41=toCsv(_0x38d2ee);var _0x346e19=Date['now']();fs[_0xecc0('0x6a')](util['format'](_0xecc0('0x6b'),_0x4b651f[_0xecc0('0x42')]['id'],_0x346e19),_0x2e9c41);_0x173076[_0xecc0('0x6c')](_0xecc0('0x6d'),_0xecc0('0x6e')+util[_0xecc0('0x65')](_0xecc0('0x6f'),_0x4b651f['params']['id'],_0x346e19));_0x173076[_0xecc0('0x6c')](_0xecc0('0x70'),_0xecc0('0x71'));return _0x173076[_0xecc0('0x72')](util['format'](_0xecc0('0x6b'),_0x4b651f[_0xecc0('0x42')]['id'],_0x346e19));}else{return _0x173076[_0xecc0('0x15')](0xcc);}})['catch'](handleError(_0x173076,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff