// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x8814=['../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','status','end','offset','limit','undefined','json','apply','reject','save','destroy','then','get','UserProfileResource','error','stack','name','index','map','JscriptyProject','fieldName','type','model','query','keys','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filters','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','show','intersection','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','Projects','find','userProfileId','catch','clone','params','rawAttributes','omit','createdAt','UserProfileSection','autoAssociation','update','getSessions','JscriptySessionReport','ProjectId','count','JscriptyAnswerReport','number','fromCharCode','indexOf','toString','replace','startTime','starttime','parse','JscriptyQuestionReport','questionId','question','format','YYYY-MM-DD\x20HH:mm:ss','SessionId','answer','push','isEmpty','now','writeFileSync','/tmp/Jscripty_Project_%d_Summary_%s.csv','setHeader','Content-disposition','attachment;\x20filename=','Jscripty_Project_%d_Summary_%s.csv','text/csv','eml-format','fast-json-patch','moment','bluebird','mustache','util','sox','to-csv','ejs','fs-extra','squel','jsforce','desk.js','querystring','ioredis','../../components/auth/service'];(function(_0x1339fe,_0x5bb1c9){var _0x2aa6cc=function(_0x5edc40){while(--_0x5edc40){_0x1339fe['push'](_0x1339fe['shift']());}};_0x2aa6cc(++_0x5bb1c9);}(_0x8814,0x1b8));var _0x4881=function(_0x164af1,_0x3cf772){_0x164af1=_0x164af1-0x0;var _0x5d81a2=_0x8814[_0x164af1];return _0x5d81a2;};'use strict';var emlformat=require(_0x4881('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0x4881('0x1'));var rp=require('request-promise');var moment=require(_0x4881('0x2'));var BPromise=require(_0x4881('0x3'));var Mustache=require(_0x4881('0x4'));var util=require(_0x4881('0x5'));var path=require('path');var sox=require(_0x4881('0x6'));var csv=require(_0x4881('0x7'));var ejs=require(_0x4881('0x8'));var fs=require('fs');var fs_extra=require(_0x4881('0x9'));var _=require('lodash');var squel=require(_0x4881('0xa'));var crypto=require('crypto');var jsforce=require(_0x4881('0xb'));var deskjs=require(_0x4881('0xc'));var toCsv=require(_0x4881('0x7'));var querystring=require(_0x4881('0xd'));var Papa=require('papaparse');var Redis=require(_0x4881('0xe'));var authService=require(_0x4881('0xf'));var qs=require('../../components/parsers/qs');var as=require(_0x4881('0x10'));var hardwareService=require(_0x4881('0x11'));var logger=require(_0x4881('0x12'))(_0x4881('0x13'));var utils=require(_0x4881('0x14'));var config=require(_0x4881('0x15'));var licenseUtil=require('../../config/license/util');var db=require(_0x4881('0x16'))['db'];function respondWithStatusCode(_0x1aa300,_0x42454b){_0x42454b=_0x42454b||0xcc;return function(_0x2794fe){if(_0x2794fe){return _0x1aa300['sendStatus'](_0x42454b);}return _0x1aa300[_0x4881('0x17')](_0x42454b)[_0x4881('0x18')]();};}function respondWithResult(_0x20357a,_0x44b25b){_0x44b25b=_0x44b25b||0xc8;return function(_0x1b409f){if(_0x1b409f){return _0x20357a[_0x4881('0x17')](_0x44b25b)['json'](_0x1b409f);}};}function respondWithFilteredResult(_0x4bdffa,_0x527762){return function(_0x5ad538){if(_0x5ad538){var _0x22df92=typeof _0x527762[_0x4881('0x19')]==='undefined'&&typeof _0x527762[_0x4881('0x1a')]===_0x4881('0x1b');var _0x3e1b6c=_0x5ad538['count'];var _0x4f7f4e=_0x22df92?0x0:_0x527762['offset'];var _0x333305=_0x22df92?_0x5ad538['count']:_0x527762[_0x4881('0x19')]+_0x527762[_0x4881('0x1a')];var _0x513bd1;if(_0x333305>=_0x3e1b6c){_0x333305=_0x3e1b6c;_0x513bd1=0xc8;}else{_0x513bd1=0xce;}_0x4bdffa['status'](_0x513bd1);return _0x4bdffa['set']('Content-Range',_0x4f7f4e+'-'+_0x333305+'/'+_0x3e1b6c)[_0x4881('0x1c')](_0x5ad538);}return null;};}function patchUpdates(_0x543c5e){return function(_0x4dc126){try{jsonpatch[_0x4881('0x1d')](_0x4dc126,_0x543c5e,!![]);}catch(_0x20bc72){return BPromise[_0x4881('0x1e')](_0x20bc72);}return _0x4dc126[_0x4881('0x1f')]();};}function saveUpdates(_0x347b35,_0x33b74a){return function(_0x5a514d){if(_0x5a514d){return _0x5a514d['update'](_0x347b35)['then'](function(_0x15aebc){return _0x15aebc;});}return null;};}function removeEntity(_0x2727c4,_0xb965c9){return function(_0x470df9){if(_0x470df9){return _0x470df9[_0x4881('0x20')]()[_0x4881('0x21')](function(){var _0x4cf5c3=_0x470df9[_0x4881('0x22')]({'plain':!![]});var _0x383c70='Projects';return db[_0x4881('0x23')][_0x4881('0x20')]({'where':{'type':_0x383c70,'resourceId':_0x4cf5c3['id']}})[_0x4881('0x21')](function(){return _0x470df9;});})[_0x4881('0x21')](function(){_0x2727c4[_0x4881('0x17')](0xcc)['end']();});}};}function handleEntityNotFound(_0x658ec9,_0x2bf637){return function(_0x41b83f){if(!_0x41b83f){_0x658ec9['sendStatus'](0x194);}return _0x41b83f;};}function handleError(_0x339600,_0xcd1152){_0xcd1152=_0xcd1152||0x1f4;return function(_0x5bcb74){logger[_0x4881('0x24')](_0x5bcb74[_0x4881('0x25')]);if(_0x5bcb74[_0x4881('0x26')]){delete _0x5bcb74[_0x4881('0x26')];}_0x339600[_0x4881('0x17')](_0xcd1152)['send'](_0x5bcb74);};}exports[_0x4881('0x27')]=function(_0x3de7c2,_0x373c7e){var _0x42fc74={},_0x1bfd97={},_0x144c63={'count':0x0,'rows':[]};var _0xa21343=_[_0x4881('0x28')](db[_0x4881('0x29')]['rawAttributes'],function(_0x5ad603){return{'name':_0x5ad603[_0x4881('0x2a')],'type':_0x5ad603[_0x4881('0x2b')]['key']};});_0x1bfd97[_0x4881('0x2c')]=_[_0x4881('0x28')](_0xa21343,'name');_0x1bfd97[_0x4881('0x2d')]=_[_0x4881('0x2e')](_0x3de7c2[_0x4881('0x2d')]);_0x1bfd97['filters']=_['intersection'](_0x1bfd97[_0x4881('0x2c')],_0x1bfd97[_0x4881('0x2d')]);_0x42fc74[_0x4881('0x2f')]=_['intersection'](_0x1bfd97[_0x4881('0x2c')],qs[_0x4881('0x30')](_0x3de7c2[_0x4881('0x2d')]['fields']));_0x42fc74[_0x4881('0x2f')]=_0x42fc74[_0x4881('0x2f')][_0x4881('0x31')]?_0x42fc74[_0x4881('0x2f')]:_0x1bfd97[_0x4881('0x2c')];if(!_0x3de7c2['query'][_0x4881('0x32')](_0x4881('0x33'))){_0x42fc74['limit']=qs[_0x4881('0x1a')](_0x3de7c2[_0x4881('0x2d')][_0x4881('0x1a')]);_0x42fc74[_0x4881('0x19')]=qs[_0x4881('0x19')](_0x3de7c2['query'][_0x4881('0x19')]);}_0x42fc74[_0x4881('0x34')]=qs['sort'](_0x3de7c2[_0x4881('0x2d')][_0x4881('0x35')]);_0x42fc74[_0x4881('0x36')]=qs['filters'](_[_0x4881('0x37')](_0x3de7c2[_0x4881('0x2d')],_0x1bfd97[_0x4881('0x38')]),_0xa21343);if(_0x3de7c2[_0x4881('0x2d')][_0x4881('0x39')]){_0x42fc74['where']=_[_0x4881('0x3a')](_0x42fc74[_0x4881('0x36')],{'$or':_['map'](_0xa21343,function(_0x52a198){if(_0x52a198['type']!==_0x4881('0x3b')){var _0x5dc0e6={};_0x5dc0e6[_0x52a198[_0x4881('0x26')]]={'$like':'%'+_0x3de7c2['query'][_0x4881('0x39')]+'%'};return _0x5dc0e6;}})});}_0x42fc74=_[_0x4881('0x3a')]({},_0x42fc74,_0x3de7c2[_0x4881('0x3c')]);var _0x1808c4={'where':_0x42fc74['where']};return db[_0x4881('0x29')]['count'](_0x1808c4)[_0x4881('0x21')](function(_0x497baa){_0x144c63['count']=_0x497baa;if(_0x3de7c2[_0x4881('0x2d')][_0x4881('0x3d')]){_0x42fc74[_0x4881('0x3e')]=[{'all':!![]}];}return db[_0x4881('0x29')][_0x4881('0x3f')](_0x42fc74);})[_0x4881('0x21')](function(_0x3b06ad){_0x144c63[_0x4881('0x40')]=_0x3b06ad;return _0x144c63;})[_0x4881('0x21')](respondWithFilteredResult(_0x373c7e,_0x42fc74))['catch'](handleError(_0x373c7e,null));};exports[_0x4881('0x41')]=function(_0x1df1a9,_0x40bb4b){var _0x3b5f2a={'raw':![],'where':{'id':_0x1df1a9['params']['id']}},_0x352ab7={};_0x352ab7[_0x4881('0x2c')]=_['keys'](db[_0x4881('0x29')]['rawAttributes']);_0x352ab7['query']=_[_0x4881('0x2e')](_0x1df1a9[_0x4881('0x2d')]);_0x352ab7[_0x4881('0x38')]=_[_0x4881('0x42')](_0x352ab7[_0x4881('0x2c')],_0x352ab7[_0x4881('0x2d')]);_0x3b5f2a[_0x4881('0x2f')]=_['intersection'](_0x352ab7['model'],qs[_0x4881('0x30')](_0x1df1a9['query']['fields']));_0x3b5f2a[_0x4881('0x2f')]=_0x3b5f2a[_0x4881('0x2f')]['length']?_0x3b5f2a[_0x4881('0x2f')]:_0x352ab7[_0x4881('0x2c')];if(_0x1df1a9[_0x4881('0x2d')][_0x4881('0x3d')]){_0x3b5f2a[_0x4881('0x3e')]=[{'all':!![]}];}_0x3b5f2a=_[_0x4881('0x3a')]({},_0x3b5f2a,_0x1df1a9['options']);return db[_0x4881('0x29')]['find'](_0x3b5f2a)[_0x4881('0x21')](handleEntityNotFound(_0x40bb4b,null))[_0x4881('0x21')](respondWithResult(_0x40bb4b,null))['catch'](handleError(_0x40bb4b,null));};exports['create']=function(_0x18bb78,_0x58f9ac){return db[_0x4881('0x29')][_0x4881('0x43')](_0x18bb78[_0x4881('0x44')],{})[_0x4881('0x21')](function(_0xfdc77c){var _0x9b18cb=_0x18bb78[_0x4881('0x45')][_0x4881('0x22')]({'plain':!![]});if(!_0x9b18cb)throw new Error(_0x4881('0x46'));if(_0x9b18cb[_0x4881('0x47')]===_0x4881('0x45')){var _0x4186bb=_0xfdc77c[_0x4881('0x22')]({'plain':!![]});var _0x3baa84=_0x4881('0x48');return db['UserProfileSection'][_0x4881('0x49')]({'where':{'name':_0x3baa84,'userProfileId':_0x9b18cb[_0x4881('0x4a')]},'raw':!![]})['then'](function(_0x553819){if(_0x553819&&_0x553819['autoAssociation']===0x0){return db['UserProfileResource'][_0x4881('0x43')]({'name':_0x4186bb[_0x4881('0x26')],'resourceId':_0x4186bb['id'],'type':_0x553819['name'],'sectionId':_0x553819['id']},{})[_0x4881('0x21')](function(){return _0xfdc77c;});}else{return _0xfdc77c;}})[_0x4881('0x4b')](function(_0x3c05ab){logger[_0x4881('0x24')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x3c05ab);throw _0x3c05ab;});}return _0xfdc77c;})[_0x4881('0x21')](respondWithResult(_0x58f9ac,0xc9))[_0x4881('0x4b')](handleError(_0x58f9ac,null));};exports[_0x4881('0x4c')]=function(_0x252736,_0x1042eb){var _0x540e1e={'where':{'id':_0x252736[_0x4881('0x4d')]['id']}},_0x4612b9={};_0x4612b9['model']=_[_0x4881('0x2e')](db[_0x4881('0x29')][_0x4881('0x4e')]);_0x540e1e[_0x4881('0x2f')]=_[_0x4881('0x42')](_0x4612b9[_0x4881('0x2c')],qs[_0x4881('0x30')](_0x252736[_0x4881('0x2d')]['fields']));_0x540e1e[_0x4881('0x2f')]=_0x540e1e[_0x4881('0x2f')][_0x4881('0x31')]?_0x540e1e[_0x4881('0x2f')]:_0x4612b9['model'];if(_0x252736['query'][_0x4881('0x3d')]){_0x540e1e[_0x4881('0x3e')]=[{'all':!![]}];}_0x540e1e=_[_0x4881('0x3a')]({},_0x540e1e,_0x252736[_0x4881('0x3c')]);return db[_0x4881('0x29')][_0x4881('0x49')](_0x540e1e)[_0x4881('0x21')](handleEntityNotFound(_0x1042eb,null))[_0x4881('0x21')](function(_0x121262){if(_0x121262){var _0x3480a2=_0x121262[_0x4881('0x22')]({'plain':!![]});_0x3480a2=qs[_0x4881('0x4f')](_0x3480a2,['id',_0x4881('0x50'),'updatedAt']);_0x252736[_0x4881('0x44')]=_[_0x4881('0x4f')](_0x252736[_0x4881('0x44')],['id',_0x4881('0x50'),'updatedAt']);return db[_0x4881('0x29')][_0x4881('0x43')](_[_0x4881('0x3a')](_0x3480a2,_0x252736[_0x4881('0x44')]),{'include':_0x252736[_0x4881('0x2d')]['includeAll']?[{'all':!![]}]:undefined})[_0x4881('0x21')](function(_0x4dedea){var _0x4dc903=_0x252736[_0x4881('0x45')][_0x4881('0x22')]({'plain':!![]});if(!_0x4dc903)throw new Error(_0x4881('0x46'));if(_0x4dc903['role']===_0x4881('0x45')){var _0x4f33fe=_0x4dedea['get']({'plain':!![]});var _0x3254a0=_0x4881('0x48');return db[_0x4881('0x51')]['find']({'where':{'name':_0x3254a0,'userProfileId':_0x4dc903[_0x4881('0x4a')]},'raw':!![]})[_0x4881('0x21')](function(_0x212f0d){if(_0x212f0d&&_0x212f0d[_0x4881('0x52')]===0x0){return db[_0x4881('0x23')][_0x4881('0x43')]({'name':_0x4f33fe[_0x4881('0x26')],'resourceId':_0x4f33fe['id'],'type':_0x212f0d[_0x4881('0x26')],'sectionId':_0x212f0d['id']},{})['then'](function(){return _0x4dedea;});}else{return _0x4dedea;}})[_0x4881('0x4b')](function(_0x3b112c){logger[_0x4881('0x24')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x3b112c);throw _0x3b112c;});}return _0x4dedea;});}})['then'](respondWithResult(_0x1042eb,0xc9))['catch'](handleError(_0x1042eb,null));};exports[_0x4881('0x53')]=function(_0x3b6e17,_0x422623){if(_0x3b6e17[_0x4881('0x44')]['id']){delete _0x3b6e17[_0x4881('0x44')]['id'];}return db['JscriptyProject'][_0x4881('0x49')]({'where':{'id':_0x3b6e17[_0x4881('0x4d')]['id']}})[_0x4881('0x21')](handleEntityNotFound(_0x422623,null))[_0x4881('0x21')](saveUpdates(_0x3b6e17['body'],null))[_0x4881('0x21')](respondWithResult(_0x422623,null))[_0x4881('0x4b')](handleError(_0x422623,null));};exports[_0x4881('0x20')]=function(_0x499a61,_0x5a0688){return db[_0x4881('0x29')][_0x4881('0x49')]({'where':{'id':_0x499a61[_0x4881('0x4d')]['id']}})[_0x4881('0x21')](handleEntityNotFound(_0x5a0688,null))[_0x4881('0x21')](removeEntity(_0x5a0688,null))['catch'](handleError(_0x5a0688,null));};exports[_0x4881('0x54')]=function(_0x2e9e65,_0x4a6d56,_0x300cf6){var _0x316ed1={'raw':!![],'where':{}};var _0x567f56={};var _0x694c67={'count':0x0,'rows':[]};return db[_0x4881('0x29')]['findOne']({'where':{'id':_0x2e9e65['params']['id']}})['then'](handleEntityNotFound(_0x4a6d56,null))[_0x4881('0x21')](function(_0x2b1b59){if(_0x2b1b59){_0x567f56[_0x4881('0x2c')]=_[_0x4881('0x2e')](db[_0x4881('0x55')]['rawAttributes']);_0x567f56[_0x4881('0x2d')]=_[_0x4881('0x2e')](_0x2e9e65[_0x4881('0x2d')]);_0x567f56[_0x4881('0x38')]=_[_0x4881('0x42')](_0x567f56[_0x4881('0x2c')],_0x567f56[_0x4881('0x2d')]);_0x316ed1['attributes']=_[_0x4881('0x42')](_0x567f56['model'],qs[_0x4881('0x30')](_0x2e9e65['query']['fields']));_0x316ed1['attributes']=_0x316ed1[_0x4881('0x2f')][_0x4881('0x31')]?_0x316ed1[_0x4881('0x2f')]:_0x567f56[_0x4881('0x2c')];if(!_0x2e9e65['query'][_0x4881('0x32')](_0x4881('0x33'))){_0x316ed1['limit']=qs[_0x4881('0x1a')](_0x2e9e65[_0x4881('0x2d')][_0x4881('0x1a')]);_0x316ed1[_0x4881('0x19')]=qs[_0x4881('0x19')](_0x2e9e65[_0x4881('0x2d')]['offset']);}_0x316ed1[_0x4881('0x34')]=qs[_0x4881('0x35')](_0x2e9e65[_0x4881('0x2d')]['sort']);_0x316ed1[_0x4881('0x36')]=qs[_0x4881('0x38')](_[_0x4881('0x37')](_0x2e9e65[_0x4881('0x2d')],_0x567f56[_0x4881('0x38')]));_0x316ed1['where'][_0x4881('0x56')]=_0x2b1b59['id'];if(_0x2e9e65[_0x4881('0x2d')]['filter']){_0x316ed1['where']=_['merge'](_0x316ed1[_0x4881('0x36')],{'$or':_[_0x4881('0x28')](_0x316ed1[_0x4881('0x2f')],function(_0x246c4a){var _0x43872d={};_0x43872d[_0x246c4a]={'$like':'%'+_0x2e9e65[_0x4881('0x2d')][_0x4881('0x39')]+'%'};return _0x43872d;})});}_0x316ed1=_[_0x4881('0x3a')]({},_0x316ed1,_0x2e9e65[_0x4881('0x3c')]);return db[_0x4881('0x55')]['count']({'where':_0x316ed1['where']})[_0x4881('0x21')](function(_0x51fbd6){_0x694c67[_0x4881('0x57')]=_0x51fbd6;if(_0x2e9e65[_0x4881('0x2d')][_0x4881('0x3d')]){_0x316ed1[_0x4881('0x3e')]=[{'all':!![]}];}return db['JscriptySessionReport']['findAll'](_0x316ed1);})['then'](function(_0x549ae0){_0x694c67['rows']=_0x549ae0;return _0x694c67;});}})[_0x4881('0x21')](respondWithFilteredResult(_0x4a6d56,_0x316ed1))[_0x4881('0x4b')](handleError(_0x4a6d56,null));};exports['getAnswers']=function(_0xf557a4,_0x1fcb57,_0x599fa1){var _0x1e1574={'raw':!![],'where':{}};var _0x362acf={};var _0x12064d={'count':0x0,'rows':[]};return db[_0x4881('0x29')]['findOne']({'where':{'id':_0xf557a4[_0x4881('0x4d')]['id']}})['then'](handleEntityNotFound(_0x1fcb57,null))[_0x4881('0x21')](function(_0x567b15){if(_0x567b15){_0x362acf['model']=_['keys'](db[_0x4881('0x58')][_0x4881('0x4e')]);_0x362acf['query']=_[_0x4881('0x2e')](_0xf557a4[_0x4881('0x2d')]);_0x362acf[_0x4881('0x38')]=_[_0x4881('0x42')](_0x362acf[_0x4881('0x2c')],_0x362acf['query']);_0x1e1574[_0x4881('0x2f')]=_[_0x4881('0x42')](_0x362acf[_0x4881('0x2c')],qs[_0x4881('0x30')](_0xf557a4[_0x4881('0x2d')][_0x4881('0x30')]));_0x1e1574[_0x4881('0x2f')]=_0x1e1574[_0x4881('0x2f')][_0x4881('0x31')]?_0x1e1574['attributes']:_0x362acf['model'];if(!_0xf557a4['query'][_0x4881('0x32')](_0x4881('0x33'))){_0x1e1574[_0x4881('0x1a')]=qs[_0x4881('0x1a')](_0xf557a4[_0x4881('0x2d')]['limit']);_0x1e1574[_0x4881('0x19')]=qs[_0x4881('0x19')](_0xf557a4['query'][_0x4881('0x19')]);}_0x1e1574['order']=qs[_0x4881('0x35')](_0xf557a4[_0x4881('0x2d')]['sort']);_0x1e1574[_0x4881('0x36')]=qs[_0x4881('0x38')](_[_0x4881('0x37')](_0xf557a4[_0x4881('0x2d')],_0x362acf[_0x4881('0x38')]));_0x1e1574[_0x4881('0x36')][_0x4881('0x56')]=_0x567b15['id'];if(_0xf557a4[_0x4881('0x2d')][_0x4881('0x39')]){_0x1e1574[_0x4881('0x36')]=_[_0x4881('0x3a')](_0x1e1574['where'],{'$or':_[_0x4881('0x28')](_0x1e1574['attributes'],function(_0x540ba7){var _0x4d4fb4={};_0x4d4fb4[_0x540ba7]={'$like':'%'+_0xf557a4['query'][_0x4881('0x39')]+'%'};return _0x4d4fb4;})});}_0x1e1574=_[_0x4881('0x3a')]({},_0x1e1574,_0xf557a4[_0x4881('0x3c')]);return db[_0x4881('0x58')][_0x4881('0x57')]({'where':_0x1e1574['where']})[_0x4881('0x21')](function(_0x4f786c){_0x12064d[_0x4881('0x57')]=_0x4f786c;if(_0xf557a4[_0x4881('0x2d')]['includeAll']){_0x1e1574[_0x4881('0x3e')]=[{'all':!![]}];}return db['JscriptyAnswerReport'][_0x4881('0x3f')](_0x1e1574);})[_0x4881('0x21')](function(_0x2b2bf7){_0x12064d[_0x4881('0x40')]=_0x2b2bf7;return _0x12064d;});}})[_0x4881('0x21')](respondWithFilteredResult(_0x1fcb57,_0x1e1574))['catch'](handleError(_0x1fcb57,null));};function char(_0x2023d8){return _0x4881('0x59')===typeof _0x2023d8?String[_0x4881('0x5a')][_0x4881('0x1d')](null,arguments):_0x2023d8;}function needsEncapsulation(_0xc4d47){return!!_0xc4d47&&(_0xc4d47['toString']()['indexOf'](char(0xd))>=0x0||_0xc4d47['toString']()[_0x4881('0x5b')](char(0xa))>=0x0||_0xc4d47[_0x4881('0x5c')]()[_0x4881('0x5b')](char(0x2c))>=0x0||_0xc4d47[_0x4881('0x5c')]()[_0x4881('0x5b')](char(0x22))>=0x0);}function encapsulate(_0x1cf802){var _0x22bbbc=char(0x22),_0x2ea108='\x5c'+char(0x22),_0xdeaf0a=_0x1cf802[_0x4881('0x5c')]()[_0x4881('0x5d')](new RegExp(_0x22bbbc,'g'),_0x2ea108);return _0x22bbbc+_0xdeaf0a+_0x22bbbc;}exports['getSummary']=function(_0x20abef,_0x5547e2,_0x2ae93f){var _0x356dc7,_0x14268b;var _0x2a522e={'where':{'ProjectId':_0x20abef[_0x4881('0x4d')]['id']}};if(_0x20abef[_0x4881('0x2d')][_0x4881('0x5e')]){_0x2a522e['where'][_0x4881('0x5f')]=JSON[_0x4881('0x60')](_0x20abef['query'][_0x4881('0x5e')]);}return db['JscriptySessionReport'][_0x4881('0x3f')](_0x2a522e)['then'](handleEntityNotFound(_0x5547e2,null))[_0x4881('0x21')](function(_0x1b97db){if(_0x1b97db){_0x356dc7=_0x1b97db;return db[_0x4881('0x61')][_0x4881('0x3f')]({'where':{'SessionId':{'$in':_[_0x4881('0x28')](_0x356dc7,'id')},'ProjectId':_0x20abef['params']['id']},'order':'-createdAt'});}})[_0x4881('0x21')](handleEntityNotFound(_0x5547e2,null))['then'](function(_0x19fc94){if(_0x19fc94){_0x14268b=_0x19fc94;var _0x1b0192={};for(var _0x2543d1=0x0,_0x36f86f=_0x14268b[_0x4881('0x31')];_0x2543d1<_0x36f86f;_0x2543d1++){if(!_0x1b0192[_0x4881('0x32')](_0x14268b[_0x2543d1]['questionId'])){_0x1b0192[_0x14268b[_0x2543d1][_0x4881('0x62')]]=needsEncapsulation(_0x14268b[_0x2543d1][_0x4881('0x63')])?encapsulate(_0x14268b[_0x2543d1][_0x4881('0x63')]):_0x14268b[_0x2543d1][_0x4881('0x63')];}}var _0x47abca=[],_0x1f669e={};for(var _0x164654=0x0,_0x27cb8a=_0x356dc7['length'];_0x164654<_0x27cb8a;_0x164654++){_0x1f669e={'ProjectId':_0x20abef[_0x4881('0x4d')]['id'],'SessionId':_0x356dc7[_0x164654]['id'],'StartTime':moment(_0x356dc7[_0x164654][_0x4881('0x5f')])[_0x4881('0x64')](_0x4881('0x65'))};for(var _0xfa66b2=0x0,_0x48325d=_0x14268b[_0x4881('0x31')];_0xfa66b2<_0x48325d;_0xfa66b2++){if(_0x14268b[_0xfa66b2][_0x4881('0x66')]==_0x356dc7[_0x164654]['id']&&_0x1b0192[_0x4881('0x32')](_0x14268b[_0xfa66b2]['questionId'])){_0x1f669e[_0x1b0192[_0x14268b[_0xfa66b2][_0x4881('0x62')]]]=_0x14268b[_0xfa66b2][_0x4881('0x67')];}}for(var _0x4399d7 in _0x1b0192){if(!_0x1f669e['hasOwnProperty'](_0x1b0192[_0x4399d7])){_0x1f669e[_0x1b0192[_0x4399d7]]=null;}}_0x47abca[_0x4881('0x68')](_0x1f669e);}return _0x47abca;}})[_0x4881('0x21')](function(_0x47c459){if(!_[_0x4881('0x69')](_0x47c459)){var _0x397b46=toCsv(_0x47c459);var _0xe01fbf=Date[_0x4881('0x6a')]();fs[_0x4881('0x6b')](util[_0x4881('0x64')](_0x4881('0x6c'),_0x20abef[_0x4881('0x4d')]['id'],_0xe01fbf),_0x397b46);_0x5547e2[_0x4881('0x6d')](_0x4881('0x6e'),_0x4881('0x6f')+util[_0x4881('0x64')](_0x4881('0x70'),_0x20abef['params']['id'],_0xe01fbf));_0x5547e2[_0x4881('0x6d')]('Content-type',_0x4881('0x71'));return _0x5547e2['download'](util[_0x4881('0x64')](_0x4881('0x6c'),_0x20abef[_0x4881('0x4d')]['id'],_0xe01fbf));}else{return _0x5547e2['sendStatus'](0xcc);}})[_0x4881('0x4b')](handleError(_0x5547e2,null));};
\ No newline at end of file
+var _0x98b7=['query','keys','filters','intersection','fields','attributes','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','findAll','rows','show','rawAttributes','length','includeAll','options','find','catch','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','get','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','params','include','omit','updatedAt','UserProfileSection','getSessions','findOne','JscriptySessionReport','getAnswers','JscriptyAnswerReport','ProjectId','number','fromCharCode','toString','indexOf','replace','getSummary','startTime','parse','JscriptyQuestionReport','-createdAt','questionId','question','starttime','YYYY-MM-DD\x20HH:mm:ss','SessionId','answer','push','now','writeFileSync','format','/tmp/Jscripty_Project_%d_Summary_%s.csv','Content-disposition','attachment;\x20filename=','setHeader','Content-type','text/csv','download','eml-format','rimraf','zip-dir','fast-json-patch','mustache','util','path','sox','to-csv','fs-extra','squel','crypto','jsforce','desk.js','papaparse','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','status','json','offset','undefined','limit','count','Content-Range','apply','reject','save','update','then','destroy','Projects','UserProfileResource','error','stack','name','index','map','JscriptyProject','fieldName','type','key','model'];(function(_0x57869f,_0xc43df4){var _0x4fa1bc=function(_0xb5d076){while(--_0xb5d076){_0x57869f['push'](_0x57869f['shift']());}};_0x4fa1bc(++_0xc43df4);}(_0x98b7,0xc1));var _0x798b=function(_0x20a584,_0xe384a5){_0x20a584=_0x20a584-0x0;var _0x4b41a8=_0x98b7[_0x20a584];return _0x4b41a8;};'use strict';var emlformat=require(_0x798b('0x0'));var rimraf=require(_0x798b('0x1'));var zipdir=require(_0x798b('0x2'));var jsonpatch=require(_0x798b('0x3'));var rp=require('request-promise');var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x798b('0x4'));var util=require(_0x798b('0x5'));var path=require(_0x798b('0x6'));var sox=require(_0x798b('0x7'));var csv=require(_0x798b('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x798b('0x9'));var _=require('lodash');var squel=require(_0x798b('0xa'));var crypto=require(_0x798b('0xb'));var jsforce=require(_0x798b('0xc'));var deskjs=require(_0x798b('0xd'));var toCsv=require(_0x798b('0x8'));var querystring=require('querystring');var Papa=require(_0x798b('0xe'));var Redis=require('ioredis');var authService=require(_0x798b('0xf'));var qs=require('../../components/parsers/qs');var as=require(_0x798b('0x10'));var hardwareService=require(_0x798b('0x11'));var logger=require(_0x798b('0x12'))('api');var utils=require('../../config/utils');var config=require(_0x798b('0x13'));var licenseUtil=require(_0x798b('0x14'));var db=require(_0x798b('0x15'))['db'];function respondWithStatusCode(_0x5455a7,_0x18057f){_0x18057f=_0x18057f||0xcc;return function(_0x53b5f1){if(_0x53b5f1){return _0x5455a7[_0x798b('0x16')](_0x18057f);}return _0x5455a7['status'](_0x18057f)[_0x798b('0x17')]();};}function respondWithResult(_0x2aacd7,_0x33cf2e){_0x33cf2e=_0x33cf2e||0xc8;return function(_0x213973){if(_0x213973){return _0x2aacd7[_0x798b('0x18')](_0x33cf2e)[_0x798b('0x19')](_0x213973);}};}function respondWithFilteredResult(_0x36425f,_0x5936fd){return function(_0x511dd3){if(_0x511dd3){var _0x1039fe=typeof _0x5936fd[_0x798b('0x1a')]===_0x798b('0x1b')&&typeof _0x5936fd[_0x798b('0x1c')]===_0x798b('0x1b');var _0x46c7c5=_0x511dd3[_0x798b('0x1d')];var _0x2fa3f6=_0x1039fe?0x0:_0x5936fd[_0x798b('0x1a')];var _0x1af73a=_0x1039fe?_0x511dd3[_0x798b('0x1d')]:_0x5936fd[_0x798b('0x1a')]+_0x5936fd[_0x798b('0x1c')];var _0x327312;if(_0x1af73a>=_0x46c7c5){_0x1af73a=_0x46c7c5;_0x327312=0xc8;}else{_0x327312=0xce;}_0x36425f[_0x798b('0x18')](_0x327312);return _0x36425f['set'](_0x798b('0x1e'),_0x2fa3f6+'-'+_0x1af73a+'/'+_0x46c7c5)[_0x798b('0x19')](_0x511dd3);}return null;};}function patchUpdates(_0x2c36d5){return function(_0x2cb76e){try{jsonpatch[_0x798b('0x1f')](_0x2cb76e,_0x2c36d5,!![]);}catch(_0x2cb7a5){return BPromise[_0x798b('0x20')](_0x2cb7a5);}return _0x2cb76e[_0x798b('0x21')]();};}function saveUpdates(_0x4c1817,_0x2de542){return function(_0x3babb5){if(_0x3babb5){return _0x3babb5[_0x798b('0x22')](_0x4c1817)[_0x798b('0x23')](function(_0x50f66c){return _0x50f66c;});}return null;};}function removeEntity(_0x397092,_0x32c926){return function(_0x36920a){if(_0x36920a){return _0x36920a[_0x798b('0x24')]()['then'](function(){var _0x325c3d=_0x36920a['get']({'plain':!![]});var _0x202398=_0x798b('0x25');return db[_0x798b('0x26')]['destroy']({'where':{'type':_0x202398,'resourceId':_0x325c3d['id']}})[_0x798b('0x23')](function(){return _0x36920a;});})[_0x798b('0x23')](function(){_0x397092[_0x798b('0x18')](0xcc)[_0x798b('0x17')]();});}};}function handleEntityNotFound(_0x2aa507,_0x251d8f){return function(_0x186f26){if(!_0x186f26){_0x2aa507['sendStatus'](0x194);}return _0x186f26;};}function handleError(_0x63c6ed,_0x5a7266){_0x5a7266=_0x5a7266||0x1f4;return function(_0x2ad7b8){logger[_0x798b('0x27')](_0x2ad7b8[_0x798b('0x28')]);if(_0x2ad7b8[_0x798b('0x29')]){delete _0x2ad7b8[_0x798b('0x29')];}_0x63c6ed['status'](_0x5a7266)['send'](_0x2ad7b8);};}exports[_0x798b('0x2a')]=function(_0x40b229,_0x228c44){var _0x1194e6={},_0x5832cc={},_0x27a40d={'count':0x0,'rows':[]};var _0x2c562b=_[_0x798b('0x2b')](db[_0x798b('0x2c')]['rawAttributes'],function(_0x1661e9){return{'name':_0x1661e9[_0x798b('0x2d')],'type':_0x1661e9[_0x798b('0x2e')][_0x798b('0x2f')]};});_0x5832cc[_0x798b('0x30')]=_[_0x798b('0x2b')](_0x2c562b,_0x798b('0x29'));_0x5832cc[_0x798b('0x31')]=_[_0x798b('0x32')](_0x40b229['query']);_0x5832cc[_0x798b('0x33')]=_[_0x798b('0x34')](_0x5832cc[_0x798b('0x30')],_0x5832cc[_0x798b('0x31')]);_0x1194e6['attributes']=_['intersection'](_0x5832cc[_0x798b('0x30')],qs[_0x798b('0x35')](_0x40b229[_0x798b('0x31')][_0x798b('0x35')]));_0x1194e6[_0x798b('0x36')]=_0x1194e6['attributes']['length']?_0x1194e6[_0x798b('0x36')]:_0x5832cc[_0x798b('0x30')];if(!_0x40b229[_0x798b('0x31')][_0x798b('0x37')](_0x798b('0x38'))){_0x1194e6[_0x798b('0x1c')]=qs[_0x798b('0x1c')](_0x40b229[_0x798b('0x31')][_0x798b('0x1c')]);_0x1194e6[_0x798b('0x1a')]=qs[_0x798b('0x1a')](_0x40b229[_0x798b('0x31')][_0x798b('0x1a')]);}_0x1194e6[_0x798b('0x39')]=qs[_0x798b('0x3a')](_0x40b229[_0x798b('0x31')][_0x798b('0x3a')]);_0x1194e6[_0x798b('0x3b')]=qs[_0x798b('0x33')](_[_0x798b('0x3c')](_0x40b229[_0x798b('0x31')],_0x5832cc[_0x798b('0x33')]),_0x2c562b);if(_0x40b229[_0x798b('0x31')][_0x798b('0x3d')]){_0x1194e6[_0x798b('0x3b')]=_[_0x798b('0x3e')](_0x1194e6[_0x798b('0x3b')],{'$or':_[_0x798b('0x2b')](_0x2c562b,function(_0xb63d9c){if(_0xb63d9c[_0x798b('0x2e')]!==_0x798b('0x3f')){var _0x1c34ef={};_0x1c34ef[_0xb63d9c[_0x798b('0x29')]]={'$like':'%'+_0x40b229['query'][_0x798b('0x3d')]+'%'};return _0x1c34ef;}})});}_0x1194e6=_[_0x798b('0x3e')]({},_0x1194e6,_0x40b229['options']);var _0x79daaa={'where':_0x1194e6[_0x798b('0x3b')]};return db[_0x798b('0x2c')]['count'](_0x79daaa)[_0x798b('0x23')](function(_0x2e6148){_0x27a40d[_0x798b('0x1d')]=_0x2e6148;if(_0x40b229[_0x798b('0x31')]['includeAll']){_0x1194e6['include']=[{'all':!![]}];}return db['JscriptyProject'][_0x798b('0x40')](_0x1194e6);})[_0x798b('0x23')](function(_0xdaaf91){_0x27a40d[_0x798b('0x41')]=_0xdaaf91;return _0x27a40d;})['then'](respondWithFilteredResult(_0x228c44,_0x1194e6))['catch'](handleError(_0x228c44,null));};exports[_0x798b('0x42')]=function(_0x4446bd,_0x113d57){var _0x51aa3f={'raw':![],'where':{'id':_0x4446bd['params']['id']}},_0x337c33={};_0x337c33['model']=_['keys'](db[_0x798b('0x2c')][_0x798b('0x43')]);_0x337c33[_0x798b('0x31')]=_['keys'](_0x4446bd[_0x798b('0x31')]);_0x337c33['filters']=_['intersection'](_0x337c33['model'],_0x337c33[_0x798b('0x31')]);_0x51aa3f[_0x798b('0x36')]=_['intersection'](_0x337c33[_0x798b('0x30')],qs[_0x798b('0x35')](_0x4446bd['query'][_0x798b('0x35')]));_0x51aa3f[_0x798b('0x36')]=_0x51aa3f[_0x798b('0x36')][_0x798b('0x44')]?_0x51aa3f['attributes']:_0x337c33[_0x798b('0x30')];if(_0x4446bd[_0x798b('0x31')][_0x798b('0x45')]){_0x51aa3f['include']=[{'all':!![]}];}_0x51aa3f=_[_0x798b('0x3e')]({},_0x51aa3f,_0x4446bd[_0x798b('0x46')]);return db[_0x798b('0x2c')][_0x798b('0x47')](_0x51aa3f)[_0x798b('0x23')](handleEntityNotFound(_0x113d57,null))[_0x798b('0x23')](respondWithResult(_0x113d57,null))[_0x798b('0x48')](handleError(_0x113d57,null));};exports[_0x798b('0x49')]=function(_0x457b60,_0x44007c){return db[_0x798b('0x2c')][_0x798b('0x49')](_0x457b60[_0x798b('0x4a')],{})['then'](function(_0x3451b4){var _0x4b6798=_0x457b60[_0x798b('0x4b')]['get']({'plain':!![]});if(!_0x4b6798)throw new Error(_0x798b('0x4c'));if(_0x4b6798[_0x798b('0x4d')]===_0x798b('0x4b')){var _0x47732f=_0x3451b4[_0x798b('0x4e')]({'plain':!![]});var _0x2c5ba5=_0x798b('0x25');return db['UserProfileSection'][_0x798b('0x47')]({'where':{'name':_0x2c5ba5,'userProfileId':_0x4b6798[_0x798b('0x4f')]},'raw':!![]})[_0x798b('0x23')](function(_0x5dbdd8){if(_0x5dbdd8&&_0x5dbdd8[_0x798b('0x50')]===0x0){return db['UserProfileResource'][_0x798b('0x49')]({'name':_0x47732f[_0x798b('0x29')],'resourceId':_0x47732f['id'],'type':_0x5dbdd8[_0x798b('0x29')],'sectionId':_0x5dbdd8['id']},{})[_0x798b('0x23')](function(){return _0x3451b4;});}else{return _0x3451b4;}})[_0x798b('0x48')](function(_0x45d178){logger[_0x798b('0x27')](_0x798b('0x51'),_0x45d178);throw _0x45d178;});}return _0x3451b4;})[_0x798b('0x23')](respondWithResult(_0x44007c,0xc9))[_0x798b('0x48')](handleError(_0x44007c,null));};exports[_0x798b('0x52')]=function(_0x3ba997,_0x38b576){var _0x16a7d7={'where':{'id':_0x3ba997[_0x798b('0x53')]['id']}},_0x577429={};_0x577429[_0x798b('0x30')]=_[_0x798b('0x32')](db[_0x798b('0x2c')][_0x798b('0x43')]);_0x16a7d7['attributes']=_[_0x798b('0x34')](_0x577429[_0x798b('0x30')],qs['fields'](_0x3ba997[_0x798b('0x31')]['fields']));_0x16a7d7[_0x798b('0x36')]=_0x16a7d7['attributes'][_0x798b('0x44')]?_0x16a7d7[_0x798b('0x36')]:_0x577429[_0x798b('0x30')];if(_0x3ba997[_0x798b('0x31')][_0x798b('0x45')]){_0x16a7d7[_0x798b('0x54')]=[{'all':!![]}];}_0x16a7d7=_[_0x798b('0x3e')]({},_0x16a7d7,_0x3ba997[_0x798b('0x46')]);return db['JscriptyProject'][_0x798b('0x47')](_0x16a7d7)['then'](handleEntityNotFound(_0x38b576,null))[_0x798b('0x23')](function(_0x2c49fe){if(_0x2c49fe){var _0x1f7e69=_0x2c49fe[_0x798b('0x4e')]({'plain':!![]});_0x1f7e69=qs[_0x798b('0x55')](_0x1f7e69,['id','createdAt',_0x798b('0x56')]);_0x3ba997['body']=_[_0x798b('0x55')](_0x3ba997[_0x798b('0x4a')],['id','createdAt','updatedAt']);return db[_0x798b('0x2c')]['create'](_[_0x798b('0x3e')](_0x1f7e69,_0x3ba997[_0x798b('0x4a')]),{'include':_0x3ba997[_0x798b('0x31')]['includeAll']?[{'all':!![]}]:undefined})[_0x798b('0x23')](function(_0x53ad6d){var _0x2ec2a6=_0x3ba997[_0x798b('0x4b')][_0x798b('0x4e')]({'plain':!![]});if(!_0x2ec2a6)throw new Error(_0x798b('0x4c'));if(_0x2ec2a6['role']===_0x798b('0x4b')){var _0x1ca33a=_0x53ad6d[_0x798b('0x4e')]({'plain':!![]});var _0x44a4a5='Projects';return db[_0x798b('0x57')][_0x798b('0x47')]({'where':{'name':_0x44a4a5,'userProfileId':_0x2ec2a6[_0x798b('0x4f')]},'raw':!![]})[_0x798b('0x23')](function(_0xadcf7c){if(_0xadcf7c&&_0xadcf7c[_0x798b('0x50')]===0x0){return db['UserProfileResource'][_0x798b('0x49')]({'name':_0x1ca33a[_0x798b('0x29')],'resourceId':_0x1ca33a['id'],'type':_0xadcf7c[_0x798b('0x29')],'sectionId':_0xadcf7c['id']},{})[_0x798b('0x23')](function(){return _0x53ad6d;});}else{return _0x53ad6d;}})[_0x798b('0x48')](function(_0x5b4986){logger[_0x798b('0x27')](_0x798b('0x51'),_0x5b4986);throw _0x5b4986;});}return _0x53ad6d;});}})[_0x798b('0x23')](respondWithResult(_0x38b576,0xc9))[_0x798b('0x48')](handleError(_0x38b576,null));};exports[_0x798b('0x22')]=function(_0x324308,_0x5d3559){if(_0x324308[_0x798b('0x4a')]['id']){delete _0x324308[_0x798b('0x4a')]['id'];}return db[_0x798b('0x2c')][_0x798b('0x47')]({'where':{'id':_0x324308['params']['id']}})[_0x798b('0x23')](handleEntityNotFound(_0x5d3559,null))[_0x798b('0x23')](saveUpdates(_0x324308['body'],null))[_0x798b('0x23')](respondWithResult(_0x5d3559,null))[_0x798b('0x48')](handleError(_0x5d3559,null));};exports[_0x798b('0x24')]=function(_0x1a95ef,_0xa422c){return db['JscriptyProject'][_0x798b('0x47')]({'where':{'id':_0x1a95ef[_0x798b('0x53')]['id']}})[_0x798b('0x23')](handleEntityNotFound(_0xa422c,null))['then'](removeEntity(_0xa422c,null))[_0x798b('0x48')](handleError(_0xa422c,null));};exports[_0x798b('0x58')]=function(_0x272a76,_0x100509,_0x57a8a1){var _0xcf57f={'raw':!![],'where':{}};var _0x5057fc={};var _0x140aa4={'count':0x0,'rows':[]};return db[_0x798b('0x2c')][_0x798b('0x59')]({'where':{'id':_0x272a76[_0x798b('0x53')]['id']}})[_0x798b('0x23')](handleEntityNotFound(_0x100509,null))['then'](function(_0x411bce){if(_0x411bce){_0x5057fc[_0x798b('0x30')]=_['keys'](db[_0x798b('0x5a')][_0x798b('0x43')]);_0x5057fc[_0x798b('0x31')]=_[_0x798b('0x32')](_0x272a76['query']);_0x5057fc[_0x798b('0x33')]=_[_0x798b('0x34')](_0x5057fc[_0x798b('0x30')],_0x5057fc['query']);_0xcf57f['attributes']=_['intersection'](_0x5057fc[_0x798b('0x30')],qs['fields'](_0x272a76['query'][_0x798b('0x35')]));_0xcf57f[_0x798b('0x36')]=_0xcf57f[_0x798b('0x36')][_0x798b('0x44')]?_0xcf57f[_0x798b('0x36')]:_0x5057fc['model'];if(!_0x272a76[_0x798b('0x31')][_0x798b('0x37')](_0x798b('0x38'))){_0xcf57f[_0x798b('0x1c')]=qs[_0x798b('0x1c')](_0x272a76[_0x798b('0x31')][_0x798b('0x1c')]);_0xcf57f[_0x798b('0x1a')]=qs[_0x798b('0x1a')](_0x272a76['query'][_0x798b('0x1a')]);}_0xcf57f[_0x798b('0x39')]=qs[_0x798b('0x3a')](_0x272a76[_0x798b('0x31')][_0x798b('0x3a')]);_0xcf57f[_0x798b('0x3b')]=qs[_0x798b('0x33')](_['pick'](_0x272a76[_0x798b('0x31')],_0x5057fc[_0x798b('0x33')]));_0xcf57f[_0x798b('0x3b')]['ProjectId']=_0x411bce['id'];if(_0x272a76[_0x798b('0x31')][_0x798b('0x3d')]){_0xcf57f['where']=_[_0x798b('0x3e')](_0xcf57f['where'],{'$or':_[_0x798b('0x2b')](_0xcf57f[_0x798b('0x36')],function(_0x5e191f){var _0x4c86d8={};_0x4c86d8[_0x5e191f]={'$like':'%'+_0x272a76['query'][_0x798b('0x3d')]+'%'};return _0x4c86d8;})});}_0xcf57f=_[_0x798b('0x3e')]({},_0xcf57f,_0x272a76[_0x798b('0x46')]);return db[_0x798b('0x5a')][_0x798b('0x1d')]({'where':_0xcf57f[_0x798b('0x3b')]})[_0x798b('0x23')](function(_0x754404){_0x140aa4[_0x798b('0x1d')]=_0x754404;if(_0x272a76['query']['includeAll']){_0xcf57f[_0x798b('0x54')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0x798b('0x40')](_0xcf57f);})[_0x798b('0x23')](function(_0x136595){_0x140aa4['rows']=_0x136595;return _0x140aa4;});}})[_0x798b('0x23')](respondWithFilteredResult(_0x100509,_0xcf57f))[_0x798b('0x48')](handleError(_0x100509,null));};exports[_0x798b('0x5b')]=function(_0x4b8752,_0x54d32e,_0x2f19da){var _0x1cf156={'raw':!![],'where':{}};var _0x437fbb={};var _0xb6abe5={'count':0x0,'rows':[]};return db[_0x798b('0x2c')][_0x798b('0x59')]({'where':{'id':_0x4b8752[_0x798b('0x53')]['id']}})[_0x798b('0x23')](handleEntityNotFound(_0x54d32e,null))['then'](function(_0x3ec70c){if(_0x3ec70c){_0x437fbb[_0x798b('0x30')]=_[_0x798b('0x32')](db[_0x798b('0x5c')][_0x798b('0x43')]);_0x437fbb['query']=_[_0x798b('0x32')](_0x4b8752['query']);_0x437fbb[_0x798b('0x33')]=_[_0x798b('0x34')](_0x437fbb[_0x798b('0x30')],_0x437fbb[_0x798b('0x31')]);_0x1cf156[_0x798b('0x36')]=_[_0x798b('0x34')](_0x437fbb['model'],qs[_0x798b('0x35')](_0x4b8752[_0x798b('0x31')]['fields']));_0x1cf156['attributes']=_0x1cf156['attributes'][_0x798b('0x44')]?_0x1cf156[_0x798b('0x36')]:_0x437fbb[_0x798b('0x30')];if(!_0x4b8752[_0x798b('0x31')][_0x798b('0x37')](_0x798b('0x38'))){_0x1cf156['limit']=qs[_0x798b('0x1c')](_0x4b8752['query'][_0x798b('0x1c')]);_0x1cf156[_0x798b('0x1a')]=qs['offset'](_0x4b8752[_0x798b('0x31')][_0x798b('0x1a')]);}_0x1cf156[_0x798b('0x39')]=qs[_0x798b('0x3a')](_0x4b8752[_0x798b('0x31')][_0x798b('0x3a')]);_0x1cf156[_0x798b('0x3b')]=qs[_0x798b('0x33')](_[_0x798b('0x3c')](_0x4b8752[_0x798b('0x31')],_0x437fbb[_0x798b('0x33')]));_0x1cf156[_0x798b('0x3b')][_0x798b('0x5d')]=_0x3ec70c['id'];if(_0x4b8752['query']['filter']){_0x1cf156[_0x798b('0x3b')]=_[_0x798b('0x3e')](_0x1cf156['where'],{'$or':_[_0x798b('0x2b')](_0x1cf156[_0x798b('0x36')],function(_0x3948af){var _0x3d4507={};_0x3d4507[_0x3948af]={'$like':'%'+_0x4b8752[_0x798b('0x31')][_0x798b('0x3d')]+'%'};return _0x3d4507;})});}_0x1cf156=_[_0x798b('0x3e')]({},_0x1cf156,_0x4b8752['options']);return db[_0x798b('0x5c')][_0x798b('0x1d')]({'where':_0x1cf156['where']})[_0x798b('0x23')](function(_0x33d0f2){_0xb6abe5[_0x798b('0x1d')]=_0x33d0f2;if(_0x4b8752['query'][_0x798b('0x45')]){_0x1cf156[_0x798b('0x54')]=[{'all':!![]}];}return db[_0x798b('0x5c')][_0x798b('0x40')](_0x1cf156);})['then'](function(_0x3826e6){_0xb6abe5['rows']=_0x3826e6;return _0xb6abe5;});}})['then'](respondWithFilteredResult(_0x54d32e,_0x1cf156))[_0x798b('0x48')](handleError(_0x54d32e,null));};function char(_0x32e9b9){return _0x798b('0x5e')===typeof _0x32e9b9?String[_0x798b('0x5f')][_0x798b('0x1f')](null,arguments):_0x32e9b9;}function needsEncapsulation(_0x4e3f1){return!!_0x4e3f1&&(_0x4e3f1[_0x798b('0x60')]()[_0x798b('0x61')](char(0xd))>=0x0||_0x4e3f1[_0x798b('0x60')]()['indexOf'](char(0xa))>=0x0||_0x4e3f1[_0x798b('0x60')]()[_0x798b('0x61')](char(0x2c))>=0x0||_0x4e3f1[_0x798b('0x60')]()['indexOf'](char(0x22))>=0x0);}function encapsulate(_0x4494cb){var _0x381c26=char(0x22),_0x344404='\x5c'+char(0x22),_0x19efc3=_0x4494cb[_0x798b('0x60')]()[_0x798b('0x62')](new RegExp(_0x381c26,'g'),_0x344404);return _0x381c26+_0x19efc3+_0x381c26;}exports[_0x798b('0x63')]=function(_0x12feca,_0x102490,_0x4fd5e9){var _0x51a08a,_0x57d60b;var _0x25d7f8={'where':{'ProjectId':_0x12feca[_0x798b('0x53')]['id']}};if(_0x12feca[_0x798b('0x31')][_0x798b('0x64')]){_0x25d7f8[_0x798b('0x3b')]['starttime']=JSON[_0x798b('0x65')](_0x12feca[_0x798b('0x31')][_0x798b('0x64')]);}return db[_0x798b('0x5a')]['findAll'](_0x25d7f8)[_0x798b('0x23')](handleEntityNotFound(_0x102490,null))[_0x798b('0x23')](function(_0x4cfe9f){if(_0x4cfe9f){_0x51a08a=_0x4cfe9f;return db[_0x798b('0x66')]['findAll']({'where':{'SessionId':{'$in':_['map'](_0x51a08a,'id')},'ProjectId':_0x12feca[_0x798b('0x53')]['id']},'order':_0x798b('0x67')});}})[_0x798b('0x23')](handleEntityNotFound(_0x102490,null))[_0x798b('0x23')](function(_0x53b0a1){if(_0x53b0a1){_0x57d60b=_0x53b0a1;var _0x5e96e4={};for(var _0x23e8c0=0x0,_0x566e55=_0x57d60b[_0x798b('0x44')];_0x23e8c0<_0x566e55;_0x23e8c0++){if(!_0x5e96e4[_0x798b('0x37')](_0x57d60b[_0x23e8c0][_0x798b('0x68')])){_0x5e96e4[_0x57d60b[_0x23e8c0][_0x798b('0x68')]]=needsEncapsulation(_0x57d60b[_0x23e8c0][_0x798b('0x69')])?encapsulate(_0x57d60b[_0x23e8c0][_0x798b('0x69')]):_0x57d60b[_0x23e8c0][_0x798b('0x69')];}}var _0x1ba649=[],_0x22013c={};for(var _0x37c068=0x0,_0x5cd286=_0x51a08a[_0x798b('0x44')];_0x37c068<_0x5cd286;_0x37c068++){_0x22013c={'ProjectId':_0x12feca[_0x798b('0x53')]['id'],'SessionId':_0x51a08a[_0x37c068]['id'],'StartTime':moment(_0x51a08a[_0x37c068][_0x798b('0x6a')])['format'](_0x798b('0x6b'))};for(var _0x210cac=0x0,_0x18dc4b=_0x57d60b[_0x798b('0x44')];_0x210cac<_0x18dc4b;_0x210cac++){if(_0x57d60b[_0x210cac][_0x798b('0x6c')]==_0x51a08a[_0x37c068]['id']&&_0x5e96e4[_0x798b('0x37')](_0x57d60b[_0x210cac][_0x798b('0x68')])){_0x22013c[_0x5e96e4[_0x57d60b[_0x210cac][_0x798b('0x68')]]]=_0x57d60b[_0x210cac][_0x798b('0x6d')];}}for(var _0x32165d in _0x5e96e4){if(!_0x22013c[_0x798b('0x37')](_0x5e96e4[_0x32165d])){_0x22013c[_0x5e96e4[_0x32165d]]=null;}}_0x1ba649[_0x798b('0x6e')](_0x22013c);}return _0x1ba649;}})[_0x798b('0x23')](function(_0x3b50c8){if(!_['isEmpty'](_0x3b50c8)){var _0x135051=toCsv(_0x3b50c8);var _0x26c312=Date[_0x798b('0x6f')]();fs[_0x798b('0x70')](util[_0x798b('0x71')](_0x798b('0x72'),_0x12feca[_0x798b('0x53')]['id'],_0x26c312),_0x135051);_0x102490['setHeader'](_0x798b('0x73'),_0x798b('0x74')+util[_0x798b('0x71')]('Jscripty_Project_%d_Summary_%s.csv',_0x12feca[_0x798b('0x53')]['id'],_0x26c312));_0x102490[_0x798b('0x75')](_0x798b('0x76'),_0x798b('0x77'));return _0x102490[_0x798b('0x78')](util['format'](_0x798b('0x72'),_0x12feca['params']['id'],_0x26c312));}else{return _0x102490[_0x798b('0x16')](0xcc);}})['catch'](handleError(_0x102490,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff