// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x866a=['../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','sendStatus','end','status','json','offset','undefined','limit','count','set','apply','reject','save','update','then','destroy','get','Projects','UserProfileResource','stack','name','send','index','map','JscriptyProject','rawAttributes','type','key','keys','query','filters','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','include','rows','show','params','find','catch','create','user','role','UserProfileSection','userProfileId','autoAssociation','error','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','clone','omit','createdAt','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','getSessions','findOne','JscriptySessionReport','ProjectId','JscriptyAnswerReport','findAll','number','toString','indexOf','replace','getSummary','startTime','starttime','parse','JscriptyQuestionReport','-createdAt','questionId','question','YYYY-MM-DD\x20HH:mm:ss','now','writeFileSync','format','setHeader','Content-disposition','Jscripty_Project_%d_Summary_%s.csv','Content-type','text/csv','download','/tmp/Jscripty_Project_%d_Summary_%s.csv','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','querystring','ioredis'];(function(_0x3c11c3,_0x54d977){var _0x326f75=function(_0x4fe3b6){while(--_0x4fe3b6){_0x3c11c3['push'](_0x3c11c3['shift']());}};_0x326f75(++_0x54d977);}(_0x866a,0x156));var _0xa866=function(_0xb04f6b,_0x1ade6){_0xb04f6b=_0xb04f6b-0x0;var _0x571dcb=_0x866a[_0xb04f6b];return _0x571dcb;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xa866('0x0'));var zipdir=require(_0xa866('0x1'));var jsonpatch=require(_0xa866('0x2'));var rp=require(_0xa866('0x3'));var moment=require(_0xa866('0x4'));var BPromise=require('bluebird');var Mustache=require(_0xa866('0x5'));var util=require(_0xa866('0x6'));var path=require(_0xa866('0x7'));var sox=require('sox');var csv=require(_0xa866('0x8'));var ejs=require(_0xa866('0x9'));var fs=require('fs');var fs_extra=require(_0xa866('0xa'));var _=require(_0xa866('0xb'));var squel=require(_0xa866('0xc'));var crypto=require(_0xa866('0xd'));var jsforce=require(_0xa866('0xe'));var deskjs=require(_0xa866('0xf'));var toCsv=require(_0xa866('0x8'));var querystring=require(_0xa866('0x10'));var Papa=require('papaparse');var Redis=require(_0xa866('0x11'));var authService=require(_0xa866('0x12'));var qs=require(_0xa866('0x13'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xa866('0x14'));var logger=require(_0xa866('0x15'))(_0xa866('0x16'));var utils=require(_0xa866('0x17'));var config=require(_0xa866('0x18'));var licenseUtil=require(_0xa866('0x19'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0xda40fb,_0xcf9adb){_0xcf9adb=_0xcf9adb||0xcc;return function(_0x82a87d){if(_0x82a87d){return _0xda40fb[_0xa866('0x1a')](_0xcf9adb);}return _0xda40fb['status'](_0xcf9adb)[_0xa866('0x1b')]();};}function respondWithResult(_0x54d726,_0x30a560){_0x30a560=_0x30a560||0xc8;return function(_0x5ad0a2){if(_0x5ad0a2){return _0x54d726[_0xa866('0x1c')](_0x30a560)[_0xa866('0x1d')](_0x5ad0a2);}};}function respondWithFilteredResult(_0x1b0ea6,_0x5d4fd1){return function(_0x251095){if(_0x251095){var _0x1afbe4=typeof _0x5d4fd1[_0xa866('0x1e')]===_0xa866('0x1f')&&typeof _0x5d4fd1[_0xa866('0x20')]===_0xa866('0x1f');var _0x34ca55=_0x251095[_0xa866('0x21')];var _0x440de5=_0x1afbe4?0x0:_0x5d4fd1['offset'];var _0x2aca7b=_0x1afbe4?_0x251095[_0xa866('0x21')]:_0x5d4fd1[_0xa866('0x1e')]+_0x5d4fd1[_0xa866('0x20')];var _0x1bd7c0;if(_0x2aca7b>=_0x34ca55){_0x2aca7b=_0x34ca55;_0x1bd7c0=0xc8;}else{_0x1bd7c0=0xce;}_0x1b0ea6[_0xa866('0x1c')](_0x1bd7c0);return _0x1b0ea6[_0xa866('0x22')]('Content-Range',_0x440de5+'-'+_0x2aca7b+'/'+_0x34ca55)[_0xa866('0x1d')](_0x251095);}return null;};}function patchUpdates(_0x48ae31){return function(_0x5d105c){try{jsonpatch[_0xa866('0x23')](_0x5d105c,_0x48ae31,!![]);}catch(_0x5075da){return BPromise[_0xa866('0x24')](_0x5075da);}return _0x5d105c[_0xa866('0x25')]();};}function saveUpdates(_0x22de43,_0x597b3b){return function(_0x5d9af5){if(_0x5d9af5){return _0x5d9af5[_0xa866('0x26')](_0x22de43)[_0xa866('0x27')](function(_0x48b66c){return _0x48b66c;});}return null;};}function removeEntity(_0x2a6940,_0x31ed99){return function(_0x118f1b){if(_0x118f1b){return _0x118f1b[_0xa866('0x28')]()['then'](function(){var _0x218ce8=_0x118f1b[_0xa866('0x29')]({'plain':!![]});var _0x35a83d=_0xa866('0x2a');return db[_0xa866('0x2b')][_0xa866('0x28')]({'where':{'type':_0x35a83d,'resourceId':_0x218ce8['id']}})['then'](function(){return _0x118f1b;});})[_0xa866('0x27')](function(){_0x2a6940[_0xa866('0x1c')](0xcc)['end']();});}};}function handleEntityNotFound(_0x4b3a6c,_0x243a3d){return function(_0x25f236){if(!_0x25f236){_0x4b3a6c['sendStatus'](0x194);}return _0x25f236;};}function handleError(_0x4a54b9,_0x2dd560){_0x2dd560=_0x2dd560||0x1f4;return function(_0x1e27ed){logger['error'](_0x1e27ed[_0xa866('0x2c')]);if(_0x1e27ed[_0xa866('0x2d')]){delete _0x1e27ed[_0xa866('0x2d')];}_0x4a54b9['status'](_0x2dd560)[_0xa866('0x2e')](_0x1e27ed);};}exports[_0xa866('0x2f')]=function(_0x92f73b,_0x408015){var _0x11ec00={},_0x4b3d81={},_0x4eb663={'count':0x0,'rows':[]};var _0x1ad800=_[_0xa866('0x30')](db[_0xa866('0x31')][_0xa866('0x32')],function(_0x42e9cb){return{'name':_0x42e9cb['fieldName'],'type':_0x42e9cb[_0xa866('0x33')][_0xa866('0x34')]};});_0x4b3d81['model']=_[_0xa866('0x30')](_0x1ad800,_0xa866('0x2d'));_0x4b3d81['query']=_[_0xa866('0x35')](_0x92f73b[_0xa866('0x36')]);_0x4b3d81[_0xa866('0x37')]=_[_0xa866('0x38')](_0x4b3d81[_0xa866('0x39')],_0x4b3d81[_0xa866('0x36')]);_0x11ec00[_0xa866('0x3a')]=_[_0xa866('0x38')](_0x4b3d81[_0xa866('0x39')],qs[_0xa866('0x3b')](_0x92f73b['query']['fields']));_0x11ec00[_0xa866('0x3a')]=_0x11ec00[_0xa866('0x3a')][_0xa866('0x3c')]?_0x11ec00[_0xa866('0x3a')]:_0x4b3d81[_0xa866('0x39')];if(!_0x92f73b['query'][_0xa866('0x3d')](_0xa866('0x3e'))){_0x11ec00[_0xa866('0x20')]=qs[_0xa866('0x20')](_0x92f73b['query'][_0xa866('0x20')]);_0x11ec00[_0xa866('0x1e')]=qs[_0xa866('0x1e')](_0x92f73b['query'][_0xa866('0x1e')]);}_0x11ec00[_0xa866('0x3f')]=qs[_0xa866('0x40')](_0x92f73b[_0xa866('0x36')]['sort']);_0x11ec00[_0xa866('0x41')]=qs['filters'](_[_0xa866('0x42')](_0x92f73b[_0xa866('0x36')],_0x4b3d81[_0xa866('0x37')]),_0x1ad800);if(_0x92f73b[_0xa866('0x36')][_0xa866('0x43')]){_0x11ec00[_0xa866('0x41')]=_[_0xa866('0x44')](_0x11ec00[_0xa866('0x41')],{'$or':_['map'](_0x1ad800,function(_0x27ebb4){if(_0x27ebb4['type']!==_0xa866('0x45')){var _0x738e33={};_0x738e33[_0x27ebb4[_0xa866('0x2d')]]={'$like':'%'+_0x92f73b[_0xa866('0x36')][_0xa866('0x43')]+'%'};return _0x738e33;}})});}_0x11ec00=_[_0xa866('0x44')]({},_0x11ec00,_0x92f73b[_0xa866('0x46')]);var _0x561f6a={'where':_0x11ec00[_0xa866('0x41')]};return db[_0xa866('0x31')][_0xa866('0x21')](_0x561f6a)['then'](function(_0x2a7735){_0x4eb663['count']=_0x2a7735;if(_0x92f73b[_0xa866('0x36')][_0xa866('0x47')]){_0x11ec00[_0xa866('0x48')]=[{'all':!![]}];}return db['JscriptyProject']['findAll'](_0x11ec00);})[_0xa866('0x27')](function(_0x688523){_0x4eb663[_0xa866('0x49')]=_0x688523;return _0x4eb663;})[_0xa866('0x27')](respondWithFilteredResult(_0x408015,_0x11ec00))['catch'](handleError(_0x408015,null));};exports[_0xa866('0x4a')]=function(_0x24f33a,_0xc9d96c){var _0x24d862={'raw':![],'where':{'id':_0x24f33a[_0xa866('0x4b')]['id']}},_0x265905={};_0x265905['model']=_[_0xa866('0x35')](db[_0xa866('0x31')][_0xa866('0x32')]);_0x265905[_0xa866('0x36')]=_[_0xa866('0x35')](_0x24f33a[_0xa866('0x36')]);_0x265905['filters']=_[_0xa866('0x38')](_0x265905[_0xa866('0x39')],_0x265905[_0xa866('0x36')]);_0x24d862[_0xa866('0x3a')]=_[_0xa866('0x38')](_0x265905[_0xa866('0x39')],qs['fields'](_0x24f33a[_0xa866('0x36')][_0xa866('0x3b')]));_0x24d862[_0xa866('0x3a')]=_0x24d862[_0xa866('0x3a')][_0xa866('0x3c')]?_0x24d862[_0xa866('0x3a')]:_0x265905[_0xa866('0x39')];if(_0x24f33a['query'][_0xa866('0x47')]){_0x24d862[_0xa866('0x48')]=[{'all':!![]}];}_0x24d862=_['merge']({},_0x24d862,_0x24f33a[_0xa866('0x46')]);return db[_0xa866('0x31')][_0xa866('0x4c')](_0x24d862)[_0xa866('0x27')](handleEntityNotFound(_0xc9d96c,null))[_0xa866('0x27')](respondWithResult(_0xc9d96c,null))[_0xa866('0x4d')](handleError(_0xc9d96c,null));};exports[_0xa866('0x4e')]=function(_0x4ac15b,_0x4b3e14){return db[_0xa866('0x31')]['create'](_0x4ac15b['body'],{})['then'](function(_0x321ad2){var _0x304622=_0x4ac15b[_0xa866('0x4f')][_0xa866('0x29')]({'plain':!![]});if(!_0x304622)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x304622[_0xa866('0x50')]===_0xa866('0x4f')){var _0x1d0782=_0x321ad2[_0xa866('0x29')]({'plain':!![]});var _0x13ffd2='Projects';return db[_0xa866('0x51')][_0xa866('0x4c')]({'where':{'name':_0x13ffd2,'userProfileId':_0x304622[_0xa866('0x52')]},'raw':!![]})[_0xa866('0x27')](function(_0x2392cd){if(_0x2392cd&&_0x2392cd[_0xa866('0x53')]===0x0){return db[_0xa866('0x2b')]['create']({'name':_0x1d0782[_0xa866('0x2d')],'resourceId':_0x1d0782['id'],'type':_0x2392cd[_0xa866('0x2d')],'sectionId':_0x2392cd['id']},{})[_0xa866('0x27')](function(){return _0x321ad2;});}else{return _0x321ad2;}})[_0xa866('0x4d')](function(_0x60c4af){logger[_0xa866('0x54')](_0xa866('0x55'),_0x60c4af);throw _0x60c4af;});}return _0x321ad2;})['then'](respondWithResult(_0x4b3e14,0xc9))[_0xa866('0x4d')](handleError(_0x4b3e14,null));};exports[_0xa866('0x56')]=function(_0x2562e8,_0x1868d5){var _0xa92f71={'where':{'id':_0x2562e8[_0xa866('0x4b')]['id']}},_0x5536b2={};_0x5536b2[_0xa866('0x39')]=_[_0xa866('0x35')](db['JscriptyProject'][_0xa866('0x32')]);_0xa92f71[_0xa866('0x3a')]=_['intersection'](_0x5536b2['model'],qs[_0xa866('0x3b')](_0x2562e8[_0xa866('0x36')]['fields']));_0xa92f71[_0xa866('0x3a')]=_0xa92f71[_0xa866('0x3a')][_0xa866('0x3c')]?_0xa92f71['attributes']:_0x5536b2['model'];if(_0x2562e8['query'][_0xa866('0x47')]){_0xa92f71[_0xa866('0x48')]=[{'all':!![]}];}_0xa92f71=_[_0xa866('0x44')]({},_0xa92f71,_0x2562e8[_0xa866('0x46')]);return db['JscriptyProject'][_0xa866('0x4c')](_0xa92f71)['then'](handleEntityNotFound(_0x1868d5,null))[_0xa866('0x27')](function(_0x32705){if(_0x32705){var _0x1d8b8b=_0x32705[_0xa866('0x29')]({'plain':!![]});_0x1d8b8b=qs[_0xa866('0x57')](_0x1d8b8b,['id',_0xa866('0x58'),'updatedAt']);_0x2562e8[_0xa866('0x59')]=_[_0xa866('0x57')](_0x2562e8[_0xa866('0x59')],['id',_0xa866('0x58'),'updatedAt']);return db[_0xa866('0x31')][_0xa866('0x4e')](_['merge'](_0x1d8b8b,_0x2562e8[_0xa866('0x59')]),{'include':_0x2562e8['query'][_0xa866('0x47')]?[{'all':!![]}]:undefined})[_0xa866('0x27')](function(_0x46ee5c){var _0x490e99=_0x2562e8['user'][_0xa866('0x29')]({'plain':!![]});if(!_0x490e99)throw new Error(_0xa866('0x5a'));if(_0x490e99[_0xa866('0x50')]==='user'){var _0x9a40c=_0x46ee5c[_0xa866('0x29')]({'plain':!![]});var _0x4b6e7f=_0xa866('0x2a');return db[_0xa866('0x51')][_0xa866('0x4c')]({'where':{'name':_0x4b6e7f,'userProfileId':_0x490e99['userProfileId']},'raw':!![]})[_0xa866('0x27')](function(_0x1343c0){if(_0x1343c0&&_0x1343c0[_0xa866('0x53')]===0x0){return db[_0xa866('0x2b')][_0xa866('0x4e')]({'name':_0x9a40c[_0xa866('0x2d')],'resourceId':_0x9a40c['id'],'type':_0x1343c0['name'],'sectionId':_0x1343c0['id']},{})['then'](function(){return _0x46ee5c;});}else{return _0x46ee5c;}})[_0xa866('0x4d')](function(_0xd61be6){logger[_0xa866('0x54')](_0xa866('0x55'),_0xd61be6);throw _0xd61be6;});}return _0x46ee5c;});}})[_0xa866('0x27')](respondWithResult(_0x1868d5,0xc9))[_0xa866('0x4d')](handleError(_0x1868d5,null));};exports[_0xa866('0x26')]=function(_0x5ea510,_0x25d143){if(_0x5ea510[_0xa866('0x59')]['id']){delete _0x5ea510[_0xa866('0x59')]['id'];}return db[_0xa866('0x31')][_0xa866('0x4c')]({'where':{'id':_0x5ea510[_0xa866('0x4b')]['id']}})[_0xa866('0x27')](handleEntityNotFound(_0x25d143,null))['then'](saveUpdates(_0x5ea510['body'],null))['then'](respondWithResult(_0x25d143,null))[_0xa866('0x4d')](handleError(_0x25d143,null));};exports['destroy']=function(_0x24de2a,_0x13a2a4){return db[_0xa866('0x31')][_0xa866('0x4c')]({'where':{'id':_0x24de2a[_0xa866('0x4b')]['id']}})[_0xa866('0x27')](handleEntityNotFound(_0x13a2a4,null))[_0xa866('0x27')](removeEntity(_0x13a2a4,null))[_0xa866('0x4d')](handleError(_0x13a2a4,null));};exports[_0xa866('0x5b')]=function(_0x3fcaeb,_0x482c33,_0x2bed8c){var _0x249181={'raw':!![],'where':{}};var _0x58fda0={};var _0x321e45={'count':0x0,'rows':[]};return db[_0xa866('0x31')][_0xa866('0x5c')]({'where':{'id':_0x3fcaeb['params']['id']}})[_0xa866('0x27')](handleEntityNotFound(_0x482c33,null))[_0xa866('0x27')](function(_0x5520eb){if(_0x5520eb){_0x58fda0[_0xa866('0x39')]=_['keys'](db[_0xa866('0x5d')][_0xa866('0x32')]);_0x58fda0[_0xa866('0x36')]=_['keys'](_0x3fcaeb[_0xa866('0x36')]);_0x58fda0[_0xa866('0x37')]=_[_0xa866('0x38')](_0x58fda0[_0xa866('0x39')],_0x58fda0[_0xa866('0x36')]);_0x249181[_0xa866('0x3a')]=_[_0xa866('0x38')](_0x58fda0[_0xa866('0x39')],qs[_0xa866('0x3b')](_0x3fcaeb[_0xa866('0x36')]['fields']));_0x249181[_0xa866('0x3a')]=_0x249181[_0xa866('0x3a')][_0xa866('0x3c')]?_0x249181[_0xa866('0x3a')]:_0x58fda0['model'];if(!_0x3fcaeb[_0xa866('0x36')]['hasOwnProperty'](_0xa866('0x3e'))){_0x249181[_0xa866('0x20')]=qs[_0xa866('0x20')](_0x3fcaeb['query'][_0xa866('0x20')]);_0x249181[_0xa866('0x1e')]=qs[_0xa866('0x1e')](_0x3fcaeb[_0xa866('0x36')]['offset']);}_0x249181[_0xa866('0x3f')]=qs[_0xa866('0x40')](_0x3fcaeb[_0xa866('0x36')][_0xa866('0x40')]);_0x249181['where']=qs[_0xa866('0x37')](_['pick'](_0x3fcaeb[_0xa866('0x36')],_0x58fda0[_0xa866('0x37')]));_0x249181[_0xa866('0x41')][_0xa866('0x5e')]=_0x5520eb['id'];if(_0x3fcaeb[_0xa866('0x36')][_0xa866('0x43')]){_0x249181[_0xa866('0x41')]=_[_0xa866('0x44')](_0x249181[_0xa866('0x41')],{'$or':_[_0xa866('0x30')](_0x249181['attributes'],function(_0x170259){var _0x1e959b={};_0x1e959b[_0x170259]={'$like':'%'+_0x3fcaeb['query'][_0xa866('0x43')]+'%'};return _0x1e959b;})});}_0x249181=_[_0xa866('0x44')]({},_0x249181,_0x3fcaeb['options']);return db[_0xa866('0x5d')]['count']({'where':_0x249181[_0xa866('0x41')]})['then'](function(_0x2fc5f2){_0x321e45[_0xa866('0x21')]=_0x2fc5f2;if(_0x3fcaeb[_0xa866('0x36')][_0xa866('0x47')]){_0x249181[_0xa866('0x48')]=[{'all':!![]}];}return db[_0xa866('0x5d')]['findAll'](_0x249181);})[_0xa866('0x27')](function(_0x18c213){_0x321e45['rows']=_0x18c213;return _0x321e45;});}})[_0xa866('0x27')](respondWithFilteredResult(_0x482c33,_0x249181))[_0xa866('0x4d')](handleError(_0x482c33,null));};exports['getAnswers']=function(_0xaf190f,_0x2219f4,_0x51e6dc){var _0x3fca14={'raw':!![],'where':{}};var _0x3e7559={};var _0x45232e={'count':0x0,'rows':[]};return db[_0xa866('0x31')][_0xa866('0x5c')]({'where':{'id':_0xaf190f[_0xa866('0x4b')]['id']}})['then'](handleEntityNotFound(_0x2219f4,null))['then'](function(_0x1cb317){if(_0x1cb317){_0x3e7559[_0xa866('0x39')]=_[_0xa866('0x35')](db[_0xa866('0x5f')][_0xa866('0x32')]);_0x3e7559['query']=_['keys'](_0xaf190f[_0xa866('0x36')]);_0x3e7559['filters']=_[_0xa866('0x38')](_0x3e7559['model'],_0x3e7559[_0xa866('0x36')]);_0x3fca14[_0xa866('0x3a')]=_[_0xa866('0x38')](_0x3e7559[_0xa866('0x39')],qs[_0xa866('0x3b')](_0xaf190f[_0xa866('0x36')][_0xa866('0x3b')]));_0x3fca14[_0xa866('0x3a')]=_0x3fca14['attributes']['length']?_0x3fca14[_0xa866('0x3a')]:_0x3e7559[_0xa866('0x39')];if(!_0xaf190f[_0xa866('0x36')]['hasOwnProperty']('nolimit')){_0x3fca14['limit']=qs['limit'](_0xaf190f['query'][_0xa866('0x20')]);_0x3fca14[_0xa866('0x1e')]=qs[_0xa866('0x1e')](_0xaf190f[_0xa866('0x36')][_0xa866('0x1e')]);}_0x3fca14[_0xa866('0x3f')]=qs['sort'](_0xaf190f[_0xa866('0x36')]['sort']);_0x3fca14[_0xa866('0x41')]=qs[_0xa866('0x37')](_[_0xa866('0x42')](_0xaf190f['query'],_0x3e7559[_0xa866('0x37')]));_0x3fca14[_0xa866('0x41')][_0xa866('0x5e')]=_0x1cb317['id'];if(_0xaf190f['query'][_0xa866('0x43')]){_0x3fca14[_0xa866('0x41')]=_[_0xa866('0x44')](_0x3fca14[_0xa866('0x41')],{'$or':_[_0xa866('0x30')](_0x3fca14[_0xa866('0x3a')],function(_0x5237e2){var _0x218cb3={};_0x218cb3[_0x5237e2]={'$like':'%'+_0xaf190f[_0xa866('0x36')]['filter']+'%'};return _0x218cb3;})});}_0x3fca14=_[_0xa866('0x44')]({},_0x3fca14,_0xaf190f[_0xa866('0x46')]);return db['JscriptyAnswerReport'][_0xa866('0x21')]({'where':_0x3fca14[_0xa866('0x41')]})['then'](function(_0x332c5f){_0x45232e['count']=_0x332c5f;if(_0xaf190f[_0xa866('0x36')][_0xa866('0x47')]){_0x3fca14['include']=[{'all':!![]}];}return db[_0xa866('0x5f')][_0xa866('0x60')](_0x3fca14);})[_0xa866('0x27')](function(_0x14742a){_0x45232e[_0xa866('0x49')]=_0x14742a;return _0x45232e;});}})['then'](respondWithFilteredResult(_0x2219f4,_0x3fca14))[_0xa866('0x4d')](handleError(_0x2219f4,null));};function char(_0x28352c){return _0xa866('0x61')===typeof _0x28352c?String['fromCharCode'][_0xa866('0x23')](null,arguments):_0x28352c;}function needsEncapsulation(_0x326e3b){return!!_0x326e3b&&(_0x326e3b[_0xa866('0x62')]()['indexOf'](char(0xd))>=0x0||_0x326e3b[_0xa866('0x62')]()[_0xa866('0x63')](char(0xa))>=0x0||_0x326e3b[_0xa866('0x62')]()['indexOf'](char(0x2c))>=0x0||_0x326e3b[_0xa866('0x62')]()[_0xa866('0x63')](char(0x22))>=0x0);}function encapsulate(_0x2678a3){var _0x27b360=char(0x22),_0x472f73='\x5c'+char(0x22),_0x9bc8a3=_0x2678a3['toString']()[_0xa866('0x64')](new RegExp(_0x27b360,'g'),_0x472f73);return _0x27b360+_0x9bc8a3+_0x27b360;}exports[_0xa866('0x65')]=function(_0x2ce4cf,_0x32380e,_0x21aeba){var _0x1f5c14,_0x50c7f0;var _0x22188b={'where':{'ProjectId':_0x2ce4cf[_0xa866('0x4b')]['id']}};if(_0x2ce4cf[_0xa866('0x36')][_0xa866('0x66')]){_0x22188b[_0xa866('0x41')][_0xa866('0x67')]=JSON[_0xa866('0x68')](_0x2ce4cf[_0xa866('0x36')]['startTime']);}return db[_0xa866('0x5d')][_0xa866('0x60')](_0x22188b)[_0xa866('0x27')](handleEntityNotFound(_0x32380e,null))['then'](function(_0x51931c){if(_0x51931c){_0x1f5c14=_0x51931c;return db[_0xa866('0x69')][_0xa866('0x60')]({'where':{'SessionId':{'$in':_[_0xa866('0x30')](_0x1f5c14,'id')},'ProjectId':_0x2ce4cf[_0xa866('0x4b')]['id']},'order':_0xa866('0x6a')});}})['then'](handleEntityNotFound(_0x32380e,null))[_0xa866('0x27')](function(_0x169358){if(_0x169358){_0x50c7f0=_0x169358;var _0x4ee6d8={};for(var _0x4e2c44=0x0,_0x26876d=_0x50c7f0[_0xa866('0x3c')];_0x4e2c44<_0x26876d;_0x4e2c44++){if(!_0x4ee6d8['hasOwnProperty'](_0x50c7f0[_0x4e2c44][_0xa866('0x6b')])){_0x4ee6d8[_0x50c7f0[_0x4e2c44][_0xa866('0x6b')]]=needsEncapsulation(_0x50c7f0[_0x4e2c44]['question'])?encapsulate(_0x50c7f0[_0x4e2c44]['question']):_0x50c7f0[_0x4e2c44][_0xa866('0x6c')];}}var _0x2a24d0=[],_0x133d37={};for(var _0x5ac28c=0x0,_0x835077=_0x1f5c14[_0xa866('0x3c')];_0x5ac28c<_0x835077;_0x5ac28c++){_0x133d37={'ProjectId':_0x2ce4cf[_0xa866('0x4b')]['id'],'SessionId':_0x1f5c14[_0x5ac28c]['id'],'StartTime':moment(_0x1f5c14[_0x5ac28c][_0xa866('0x67')])['format'](_0xa866('0x6d'))};for(var _0x56e528=0x0,_0x15ecb7=_0x50c7f0['length'];_0x56e528<_0x15ecb7;_0x56e528++){if(_0x50c7f0[_0x56e528]['SessionId']==_0x1f5c14[_0x5ac28c]['id']&&_0x4ee6d8[_0xa866('0x3d')](_0x50c7f0[_0x56e528][_0xa866('0x6b')])){_0x133d37[_0x4ee6d8[_0x50c7f0[_0x56e528][_0xa866('0x6b')]]]=_0x50c7f0[_0x56e528]['answer'];}}for(var _0x57a6f7 in _0x4ee6d8){if(!_0x133d37[_0xa866('0x3d')](_0x4ee6d8[_0x57a6f7])){_0x133d37[_0x4ee6d8[_0x57a6f7]]=null;}}_0x2a24d0['push'](_0x133d37);}return _0x2a24d0;}})[_0xa866('0x27')](function(_0xb47da0){if(!_['isEmpty'](_0xb47da0)){var _0x5e47da=toCsv(_0xb47da0);var _0x571fc2=Date[_0xa866('0x6e')]();fs[_0xa866('0x6f')](util[_0xa866('0x70')]('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x2ce4cf[_0xa866('0x4b')]['id'],_0x571fc2),_0x5e47da);_0x32380e[_0xa866('0x71')](_0xa866('0x72'),'attachment;\x20filename='+util[_0xa866('0x70')](_0xa866('0x73'),_0x2ce4cf[_0xa866('0x4b')]['id'],_0x571fc2));_0x32380e[_0xa866('0x71')](_0xa866('0x74'),_0xa866('0x75'));return _0x32380e[_0xa866('0x76')](util[_0xa866('0x70')](_0xa866('0x77'),_0x2ce4cf[_0xa866('0x4b')]['id'],_0x571fc2));}else{return _0x32380e[_0xa866('0x1a')](0xcc);}})['catch'](handleError(_0x32380e,null));};
\ No newline at end of file
+var _0x3f7c=['attributes','length','order','sort','where','filters','filter','merge','type','VIRTUAL','options','include','findAll','catch','show','params','fields','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','includeAll','updatedAt','body','createdAt','JscriptySessionReport','nolimit','ProjectId','getAnswers','JscriptyAnswerReport','hasOwnProperty','pick','rows','toString','indexOf','replace','startTime','parse','JscriptyQuestionReport','questionId','question','YYYY-MM-DD\x20HH:mm:ss','SessionId','answer','now','writeFileSync','Content-disposition','attachment;\x20filename=','format','Content-type','text/csv','/tmp/Jscripty_Project_%d_Summary_%s.csv','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/environment','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','then','destroy','get','Projects','UserProfileResource','error','stack','name','index','map','JscriptyProject','rawAttributes','fieldName','key','model','query','keys','intersection'];(function(_0x24f31b,_0x44b8f3){var _0x488401=function(_0x204caf){while(--_0x204caf){_0x24f31b['push'](_0x24f31b['shift']());}};_0x488401(++_0x44b8f3);}(_0x3f7c,0xaa));var _0xc3f7=function(_0x45b4e7,_0x431709){_0x45b4e7=_0x45b4e7-0x0;var _0x141c49=_0x3f7c[_0x45b4e7];return _0x141c49;};'use strict';var emlformat=require(_0xc3f7('0x0'));var rimraf=require(_0xc3f7('0x1'));var zipdir=require(_0xc3f7('0x2'));var jsonpatch=require(_0xc3f7('0x3'));var rp=require(_0xc3f7('0x4'));var moment=require('moment');var BPromise=require(_0xc3f7('0x5'));var Mustache=require('mustache');var util=require(_0xc3f7('0x6'));var path=require(_0xc3f7('0x7'));var sox=require(_0xc3f7('0x8'));var csv=require(_0xc3f7('0x9'));var ejs=require(_0xc3f7('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xc3f7('0xb'));var squel=require(_0xc3f7('0xc'));var crypto=require(_0xc3f7('0xd'));var jsforce=require(_0xc3f7('0xe'));var deskjs=require(_0xc3f7('0xf'));var toCsv=require(_0xc3f7('0x9'));var querystring=require(_0xc3f7('0x10'));var Papa=require(_0xc3f7('0x11'));var Redis=require(_0xc3f7('0x12'));var authService=require('../../components/auth/service');var qs=require(_0xc3f7('0x13'));var as=require(_0xc3f7('0x14'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xc3f7('0x15'))('api');var utils=require('../../config/utils');var config=require(_0xc3f7('0x16'));var licenseUtil=require('../../config/license/util');var db=require(_0xc3f7('0x17'))['db'];function respondWithStatusCode(_0x3b5638,_0xeb5db4){_0xeb5db4=_0xeb5db4||0xcc;return function(_0x45a43f){if(_0x45a43f){return _0x3b5638[_0xc3f7('0x18')](_0xeb5db4);}return _0x3b5638[_0xc3f7('0x19')](_0xeb5db4)[_0xc3f7('0x1a')]();};}function respondWithResult(_0x3f004f,_0x2c0e79){_0x2c0e79=_0x2c0e79||0xc8;return function(_0x1cdf8c){if(_0x1cdf8c){return _0x3f004f['status'](_0x2c0e79)[_0xc3f7('0x1b')](_0x1cdf8c);}};}function respondWithFilteredResult(_0x52f8eb,_0x2f8b2d){return function(_0x4b7b97){if(_0x4b7b97){var _0x43d5bb=typeof _0x2f8b2d[_0xc3f7('0x1c')]===_0xc3f7('0x1d')&&typeof _0x2f8b2d[_0xc3f7('0x1e')]===_0xc3f7('0x1d');var _0x3f7c60=_0x4b7b97[_0xc3f7('0x1f')];var _0x2b82fd=_0x43d5bb?0x0:_0x2f8b2d[_0xc3f7('0x1c')];var _0x46c343=_0x43d5bb?_0x4b7b97[_0xc3f7('0x1f')]:_0x2f8b2d[_0xc3f7('0x1c')]+_0x2f8b2d[_0xc3f7('0x1e')];var _0x539214;if(_0x46c343>=_0x3f7c60){_0x46c343=_0x3f7c60;_0x539214=0xc8;}else{_0x539214=0xce;}_0x52f8eb[_0xc3f7('0x19')](_0x539214);return _0x52f8eb[_0xc3f7('0x20')](_0xc3f7('0x21'),_0x2b82fd+'-'+_0x46c343+'/'+_0x3f7c60)[_0xc3f7('0x1b')](_0x4b7b97);}return null;};}function patchUpdates(_0x48c8c9){return function(_0x5743a2){try{jsonpatch[_0xc3f7('0x22')](_0x5743a2,_0x48c8c9,!![]);}catch(_0xb92b42){return BPromise[_0xc3f7('0x23')](_0xb92b42);}return _0x5743a2[_0xc3f7('0x24')]();};}function saveUpdates(_0xcd4042,_0x194399){return function(_0x86b1f0){if(_0x86b1f0){return _0x86b1f0[_0xc3f7('0x25')](_0xcd4042)[_0xc3f7('0x26')](function(_0x5125ee){return _0x5125ee;});}return null;};}function removeEntity(_0x132a7f,_0x4f514b){return function(_0x1ddc26){if(_0x1ddc26){return _0x1ddc26[_0xc3f7('0x27')]()[_0xc3f7('0x26')](function(){var _0x3cc75b=_0x1ddc26[_0xc3f7('0x28')]({'plain':!![]});var _0xf2482b=_0xc3f7('0x29');return db[_0xc3f7('0x2a')]['destroy']({'where':{'type':_0xf2482b,'resourceId':_0x3cc75b['id']}})[_0xc3f7('0x26')](function(){return _0x1ddc26;});})[_0xc3f7('0x26')](function(){_0x132a7f[_0xc3f7('0x19')](0xcc)[_0xc3f7('0x1a')]();});}};}function handleEntityNotFound(_0x4799f6,_0x2d2b72){return function(_0x24d241){if(!_0x24d241){_0x4799f6['sendStatus'](0x194);}return _0x24d241;};}function handleError(_0x267520,_0xe20399){_0xe20399=_0xe20399||0x1f4;return function(_0x585c65){logger[_0xc3f7('0x2b')](_0x585c65[_0xc3f7('0x2c')]);if(_0x585c65[_0xc3f7('0x2d')]){delete _0x585c65['name'];}_0x267520['status'](_0xe20399)['send'](_0x585c65);};}exports[_0xc3f7('0x2e')]=function(_0x3d9253,_0x1bef3c){var _0x1a8f5a={},_0x28b14e={},_0x2d9326={'count':0x0,'rows':[]};var _0x22ad6e=_[_0xc3f7('0x2f')](db[_0xc3f7('0x30')][_0xc3f7('0x31')],function(_0x171106){return{'name':_0x171106[_0xc3f7('0x32')],'type':_0x171106['type'][_0xc3f7('0x33')]};});_0x28b14e[_0xc3f7('0x34')]=_[_0xc3f7('0x2f')](_0x22ad6e,_0xc3f7('0x2d'));_0x28b14e[_0xc3f7('0x35')]=_[_0xc3f7('0x36')](_0x3d9253['query']);_0x28b14e['filters']=_[_0xc3f7('0x37')](_0x28b14e['model'],_0x28b14e['query']);_0x1a8f5a[_0xc3f7('0x38')]=_[_0xc3f7('0x37')](_0x28b14e[_0xc3f7('0x34')],qs['fields'](_0x3d9253[_0xc3f7('0x35')]['fields']));_0x1a8f5a[_0xc3f7('0x38')]=_0x1a8f5a[_0xc3f7('0x38')][_0xc3f7('0x39')]?_0x1a8f5a[_0xc3f7('0x38')]:_0x28b14e[_0xc3f7('0x34')];if(!_0x3d9253[_0xc3f7('0x35')]['hasOwnProperty']('nolimit')){_0x1a8f5a[_0xc3f7('0x1e')]=qs[_0xc3f7('0x1e')](_0x3d9253[_0xc3f7('0x35')][_0xc3f7('0x1e')]);_0x1a8f5a[_0xc3f7('0x1c')]=qs['offset'](_0x3d9253[_0xc3f7('0x35')][_0xc3f7('0x1c')]);}_0x1a8f5a[_0xc3f7('0x3a')]=qs['sort'](_0x3d9253[_0xc3f7('0x35')][_0xc3f7('0x3b')]);_0x1a8f5a[_0xc3f7('0x3c')]=qs[_0xc3f7('0x3d')](_['pick'](_0x3d9253[_0xc3f7('0x35')],_0x28b14e['filters']),_0x22ad6e);if(_0x3d9253[_0xc3f7('0x35')][_0xc3f7('0x3e')]){_0x1a8f5a[_0xc3f7('0x3c')]=_[_0xc3f7('0x3f')](_0x1a8f5a[_0xc3f7('0x3c')],{'$or':_[_0xc3f7('0x2f')](_0x22ad6e,function(_0x1bedda){if(_0x1bedda[_0xc3f7('0x40')]!==_0xc3f7('0x41')){var _0x30c00f={};_0x30c00f[_0x1bedda[_0xc3f7('0x2d')]]={'$like':'%'+_0x3d9253[_0xc3f7('0x35')]['filter']+'%'};return _0x30c00f;}})});}_0x1a8f5a=_[_0xc3f7('0x3f')]({},_0x1a8f5a,_0x3d9253[_0xc3f7('0x42')]);var _0xc8a21d={'where':_0x1a8f5a[_0xc3f7('0x3c')]};return db[_0xc3f7('0x30')][_0xc3f7('0x1f')](_0xc8a21d)[_0xc3f7('0x26')](function(_0x22f109){_0x2d9326[_0xc3f7('0x1f')]=_0x22f109;if(_0x3d9253[_0xc3f7('0x35')]['includeAll']){_0x1a8f5a[_0xc3f7('0x43')]=[{'all':!![]}];}return db['JscriptyProject'][_0xc3f7('0x44')](_0x1a8f5a);})[_0xc3f7('0x26')](function(_0x358879){_0x2d9326['rows']=_0x358879;return _0x2d9326;})['then'](respondWithFilteredResult(_0x1bef3c,_0x1a8f5a))[_0xc3f7('0x45')](handleError(_0x1bef3c,null));};exports[_0xc3f7('0x46')]=function(_0x543652,_0x36b5be){var _0x20feff={'raw':![],'where':{'id':_0x543652[_0xc3f7('0x47')]['id']}},_0xef6b33={};_0xef6b33[_0xc3f7('0x34')]=_[_0xc3f7('0x36')](db['JscriptyProject'][_0xc3f7('0x31')]);_0xef6b33['query']=_[_0xc3f7('0x36')](_0x543652[_0xc3f7('0x35')]);_0xef6b33[_0xc3f7('0x3d')]=_[_0xc3f7('0x37')](_0xef6b33[_0xc3f7('0x34')],_0xef6b33[_0xc3f7('0x35')]);_0x20feff['attributes']=_['intersection'](_0xef6b33[_0xc3f7('0x34')],qs[_0xc3f7('0x48')](_0x543652[_0xc3f7('0x35')][_0xc3f7('0x48')]));_0x20feff['attributes']=_0x20feff[_0xc3f7('0x38')]['length']?_0x20feff['attributes']:_0xef6b33[_0xc3f7('0x34')];if(_0x543652[_0xc3f7('0x35')]['includeAll']){_0x20feff[_0xc3f7('0x43')]=[{'all':!![]}];}_0x20feff=_[_0xc3f7('0x3f')]({},_0x20feff,_0x543652[_0xc3f7('0x42')]);return db[_0xc3f7('0x30')][_0xc3f7('0x49')](_0x20feff)[_0xc3f7('0x26')](handleEntityNotFound(_0x36b5be,null))['then'](respondWithResult(_0x36b5be,null))[_0xc3f7('0x45')](handleError(_0x36b5be,null));};exports[_0xc3f7('0x4a')]=function(_0x1bf4f3,_0x188503){return db[_0xc3f7('0x30')]['create'](_0x1bf4f3['body'],{})['then'](function(_0x5c3cc2){var _0x214da9=_0x1bf4f3[_0xc3f7('0x4b')][_0xc3f7('0x28')]({'plain':!![]});if(!_0x214da9)throw new Error(_0xc3f7('0x4c'));if(_0x214da9[_0xc3f7('0x4d')]==='user'){var _0x339c20=_0x5c3cc2['get']({'plain':!![]});var _0x2be2a0=_0xc3f7('0x29');return db[_0xc3f7('0x4e')][_0xc3f7('0x49')]({'where':{'name':_0x2be2a0,'userProfileId':_0x214da9[_0xc3f7('0x4f')]},'raw':!![]})['then'](function(_0x12e5e3){if(_0x12e5e3&&_0x12e5e3[_0xc3f7('0x50')]===0x0){return db['UserProfileResource'][_0xc3f7('0x4a')]({'name':_0x339c20['name'],'resourceId':_0x339c20['id'],'type':_0x12e5e3[_0xc3f7('0x2d')],'sectionId':_0x12e5e3['id']},{})['then'](function(){return _0x5c3cc2;});}else{return _0x5c3cc2;}})[_0xc3f7('0x45')](function(_0xd5759f){logger[_0xc3f7('0x2b')](_0xc3f7('0x51'),_0xd5759f);throw _0xd5759f;});}return _0x5c3cc2;})[_0xc3f7('0x26')](respondWithResult(_0x188503,0xc9))['catch'](handleError(_0x188503,null));};exports['clone']=function(_0x39fdfc,_0x130756){var _0x317da9={'where':{'id':_0x39fdfc[_0xc3f7('0x47')]['id']}},_0x34727e={};_0x34727e[_0xc3f7('0x34')]=_[_0xc3f7('0x36')](db[_0xc3f7('0x30')][_0xc3f7('0x31')]);_0x317da9[_0xc3f7('0x38')]=_['intersection'](_0x34727e[_0xc3f7('0x34')],qs[_0xc3f7('0x48')](_0x39fdfc[_0xc3f7('0x35')][_0xc3f7('0x48')]));_0x317da9[_0xc3f7('0x38')]=_0x317da9[_0xc3f7('0x38')]['length']?_0x317da9['attributes']:_0x34727e[_0xc3f7('0x34')];if(_0x39fdfc[_0xc3f7('0x35')][_0xc3f7('0x52')]){_0x317da9[_0xc3f7('0x43')]=[{'all':!![]}];}_0x317da9=_['merge']({},_0x317da9,_0x39fdfc[_0xc3f7('0x42')]);return db[_0xc3f7('0x30')][_0xc3f7('0x49')](_0x317da9)[_0xc3f7('0x26')](handleEntityNotFound(_0x130756,null))[_0xc3f7('0x26')](function(_0xdb1c22){if(_0xdb1c22){var _0x3c1f86=_0xdb1c22['get']({'plain':!![]});_0x3c1f86=qs['omit'](_0x3c1f86,['id','createdAt',_0xc3f7('0x53')]);_0x39fdfc[_0xc3f7('0x54')]=_['omit'](_0x39fdfc['body'],['id',_0xc3f7('0x55'),_0xc3f7('0x53')]);return db['JscriptyProject']['create'](_[_0xc3f7('0x3f')](_0x3c1f86,_0x39fdfc[_0xc3f7('0x54')]),{'include':_0x39fdfc[_0xc3f7('0x35')]['includeAll']?[{'all':!![]}]:undefined})[_0xc3f7('0x26')](function(_0x545962){var _0x8eefee=_0x39fdfc[_0xc3f7('0x4b')][_0xc3f7('0x28')]({'plain':!![]});if(!_0x8eefee)throw new Error(_0xc3f7('0x4c'));if(_0x8eefee[_0xc3f7('0x4d')]===_0xc3f7('0x4b')){var _0xc1273a=_0x545962[_0xc3f7('0x28')]({'plain':!![]});var _0x5d510f=_0xc3f7('0x29');return db[_0xc3f7('0x4e')][_0xc3f7('0x49')]({'where':{'name':_0x5d510f,'userProfileId':_0x8eefee[_0xc3f7('0x4f')]},'raw':!![]})['then'](function(_0x5b7426){if(_0x5b7426&&_0x5b7426[_0xc3f7('0x50')]===0x0){return db[_0xc3f7('0x2a')][_0xc3f7('0x4a')]({'name':_0xc1273a[_0xc3f7('0x2d')],'resourceId':_0xc1273a['id'],'type':_0x5b7426[_0xc3f7('0x2d')],'sectionId':_0x5b7426['id']},{})[_0xc3f7('0x26')](function(){return _0x545962;});}else{return _0x545962;}})[_0xc3f7('0x45')](function(_0x59bd7c){logger['error'](_0xc3f7('0x51'),_0x59bd7c);throw _0x59bd7c;});}return _0x545962;});}})[_0xc3f7('0x26')](respondWithResult(_0x130756,0xc9))['catch'](handleError(_0x130756,null));};exports[_0xc3f7('0x25')]=function(_0x2dbcd1,_0x3de292){if(_0x2dbcd1[_0xc3f7('0x54')]['id']){delete _0x2dbcd1[_0xc3f7('0x54')]['id'];}return db[_0xc3f7('0x30')][_0xc3f7('0x49')]({'where':{'id':_0x2dbcd1[_0xc3f7('0x47')]['id']}})[_0xc3f7('0x26')](handleEntityNotFound(_0x3de292,null))[_0xc3f7('0x26')](saveUpdates(_0x2dbcd1[_0xc3f7('0x54')],null))[_0xc3f7('0x26')](respondWithResult(_0x3de292,null))[_0xc3f7('0x45')](handleError(_0x3de292,null));};exports['destroy']=function(_0x53d7da,_0x5449f3){return db[_0xc3f7('0x30')]['find']({'where':{'id':_0x53d7da[_0xc3f7('0x47')]['id']}})[_0xc3f7('0x26')](handleEntityNotFound(_0x5449f3,null))[_0xc3f7('0x26')](removeEntity(_0x5449f3,null))[_0xc3f7('0x45')](handleError(_0x5449f3,null));};exports['getSessions']=function(_0x34216f,_0x1c2d58,_0x36f3e8){var _0x7ce90c={'raw':!![],'where':{}};var _0x3d078e={};var _0x33c8b2={'count':0x0,'rows':[]};return db['JscriptyProject']['findOne']({'where':{'id':_0x34216f[_0xc3f7('0x47')]['id']}})[_0xc3f7('0x26')](handleEntityNotFound(_0x1c2d58,null))[_0xc3f7('0x26')](function(_0x238f35){if(_0x238f35){_0x3d078e['model']=_[_0xc3f7('0x36')](db[_0xc3f7('0x56')]['rawAttributes']);_0x3d078e[_0xc3f7('0x35')]=_[_0xc3f7('0x36')](_0x34216f[_0xc3f7('0x35')]);_0x3d078e[_0xc3f7('0x3d')]=_[_0xc3f7('0x37')](_0x3d078e[_0xc3f7('0x34')],_0x3d078e['query']);_0x7ce90c['attributes']=_[_0xc3f7('0x37')](_0x3d078e[_0xc3f7('0x34')],qs['fields'](_0x34216f[_0xc3f7('0x35')][_0xc3f7('0x48')]));_0x7ce90c[_0xc3f7('0x38')]=_0x7ce90c[_0xc3f7('0x38')][_0xc3f7('0x39')]?_0x7ce90c[_0xc3f7('0x38')]:_0x3d078e[_0xc3f7('0x34')];if(!_0x34216f[_0xc3f7('0x35')]['hasOwnProperty'](_0xc3f7('0x57'))){_0x7ce90c['limit']=qs[_0xc3f7('0x1e')](_0x34216f[_0xc3f7('0x35')][_0xc3f7('0x1e')]);_0x7ce90c['offset']=qs[_0xc3f7('0x1c')](_0x34216f[_0xc3f7('0x35')]['offset']);}_0x7ce90c['order']=qs[_0xc3f7('0x3b')](_0x34216f[_0xc3f7('0x35')][_0xc3f7('0x3b')]);_0x7ce90c[_0xc3f7('0x3c')]=qs[_0xc3f7('0x3d')](_['pick'](_0x34216f[_0xc3f7('0x35')],_0x3d078e[_0xc3f7('0x3d')]));_0x7ce90c[_0xc3f7('0x3c')][_0xc3f7('0x58')]=_0x238f35['id'];if(_0x34216f[_0xc3f7('0x35')][_0xc3f7('0x3e')]){_0x7ce90c[_0xc3f7('0x3c')]=_['merge'](_0x7ce90c[_0xc3f7('0x3c')],{'$or':_['map'](_0x7ce90c[_0xc3f7('0x38')],function(_0x12df7f){var _0x201f80={};_0x201f80[_0x12df7f]={'$like':'%'+_0x34216f[_0xc3f7('0x35')][_0xc3f7('0x3e')]+'%'};return _0x201f80;})});}_0x7ce90c=_[_0xc3f7('0x3f')]({},_0x7ce90c,_0x34216f[_0xc3f7('0x42')]);return db['JscriptySessionReport'][_0xc3f7('0x1f')]({'where':_0x7ce90c['where']})[_0xc3f7('0x26')](function(_0x2f46b3){_0x33c8b2[_0xc3f7('0x1f')]=_0x2f46b3;if(_0x34216f[_0xc3f7('0x35')][_0xc3f7('0x52')]){_0x7ce90c[_0xc3f7('0x43')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0xc3f7('0x44')](_0x7ce90c);})[_0xc3f7('0x26')](function(_0x5ce2ed){_0x33c8b2['rows']=_0x5ce2ed;return _0x33c8b2;});}})[_0xc3f7('0x26')](respondWithFilteredResult(_0x1c2d58,_0x7ce90c))['catch'](handleError(_0x1c2d58,null));};exports[_0xc3f7('0x59')]=function(_0x81ce9c,_0x47885d,_0x53db6b){var _0x443ac5={'raw':!![],'where':{}};var _0x3f31e0={};var _0x540228={'count':0x0,'rows':[]};return db['JscriptyProject']['findOne']({'where':{'id':_0x81ce9c[_0xc3f7('0x47')]['id']}})[_0xc3f7('0x26')](handleEntityNotFound(_0x47885d,null))[_0xc3f7('0x26')](function(_0x27172b){if(_0x27172b){_0x3f31e0[_0xc3f7('0x34')]=_[_0xc3f7('0x36')](db[_0xc3f7('0x5a')][_0xc3f7('0x31')]);_0x3f31e0[_0xc3f7('0x35')]=_[_0xc3f7('0x36')](_0x81ce9c[_0xc3f7('0x35')]);_0x3f31e0[_0xc3f7('0x3d')]=_['intersection'](_0x3f31e0[_0xc3f7('0x34')],_0x3f31e0[_0xc3f7('0x35')]);_0x443ac5['attributes']=_['intersection'](_0x3f31e0[_0xc3f7('0x34')],qs[_0xc3f7('0x48')](_0x81ce9c['query']['fields']));_0x443ac5[_0xc3f7('0x38')]=_0x443ac5[_0xc3f7('0x38')][_0xc3f7('0x39')]?_0x443ac5[_0xc3f7('0x38')]:_0x3f31e0[_0xc3f7('0x34')];if(!_0x81ce9c[_0xc3f7('0x35')][_0xc3f7('0x5b')](_0xc3f7('0x57'))){_0x443ac5[_0xc3f7('0x1e')]=qs['limit'](_0x81ce9c[_0xc3f7('0x35')][_0xc3f7('0x1e')]);_0x443ac5[_0xc3f7('0x1c')]=qs[_0xc3f7('0x1c')](_0x81ce9c[_0xc3f7('0x35')][_0xc3f7('0x1c')]);}_0x443ac5[_0xc3f7('0x3a')]=qs['sort'](_0x81ce9c['query'][_0xc3f7('0x3b')]);_0x443ac5[_0xc3f7('0x3c')]=qs[_0xc3f7('0x3d')](_[_0xc3f7('0x5c')](_0x81ce9c[_0xc3f7('0x35')],_0x3f31e0[_0xc3f7('0x3d')]));_0x443ac5[_0xc3f7('0x3c')][_0xc3f7('0x58')]=_0x27172b['id'];if(_0x81ce9c['query']['filter']){_0x443ac5['where']=_[_0xc3f7('0x3f')](_0x443ac5[_0xc3f7('0x3c')],{'$or':_[_0xc3f7('0x2f')](_0x443ac5[_0xc3f7('0x38')],function(_0x2259aa){var _0x1bc32d={};_0x1bc32d[_0x2259aa]={'$like':'%'+_0x81ce9c[_0xc3f7('0x35')][_0xc3f7('0x3e')]+'%'};return _0x1bc32d;})});}_0x443ac5=_[_0xc3f7('0x3f')]({},_0x443ac5,_0x81ce9c[_0xc3f7('0x42')]);return db[_0xc3f7('0x5a')][_0xc3f7('0x1f')]({'where':_0x443ac5[_0xc3f7('0x3c')]})['then'](function(_0x9462e6){_0x540228['count']=_0x9462e6;if(_0x81ce9c[_0xc3f7('0x35')]['includeAll']){_0x443ac5['include']=[{'all':!![]}];}return db['JscriptyAnswerReport'][_0xc3f7('0x44')](_0x443ac5);})['then'](function(_0x18f4c8){_0x540228[_0xc3f7('0x5d')]=_0x18f4c8;return _0x540228;});}})[_0xc3f7('0x26')](respondWithFilteredResult(_0x47885d,_0x443ac5))[_0xc3f7('0x45')](handleError(_0x47885d,null));};function char(_0x3059d1){return'number'===typeof _0x3059d1?String['fromCharCode'][_0xc3f7('0x22')](null,arguments):_0x3059d1;}function needsEncapsulation(_0x20008d){return!!_0x20008d&&(_0x20008d[_0xc3f7('0x5e')]()['indexOf'](char(0xd))>=0x0||_0x20008d[_0xc3f7('0x5e')]()[_0xc3f7('0x5f')](char(0xa))>=0x0||_0x20008d[_0xc3f7('0x5e')]()[_0xc3f7('0x5f')](char(0x2c))>=0x0||_0x20008d[_0xc3f7('0x5e')]()[_0xc3f7('0x5f')](char(0x22))>=0x0);}function encapsulate(_0xfacf0e){var _0x3cb02c=char(0x22),_0x857938='\x5c'+char(0x22),_0x42ce86=_0xfacf0e[_0xc3f7('0x5e')]()[_0xc3f7('0x60')](new RegExp(_0x3cb02c,'g'),_0x857938);return _0x3cb02c+_0x42ce86+_0x3cb02c;}exports['getSummary']=function(_0x24daf5,_0x390676,_0x477084){var _0x4bc5b8,_0x1bcc31;var _0x12f1d3={'where':{'ProjectId':_0x24daf5[_0xc3f7('0x47')]['id']}};if(_0x24daf5[_0xc3f7('0x35')][_0xc3f7('0x61')]){_0x12f1d3[_0xc3f7('0x3c')]['starttime']=JSON[_0xc3f7('0x62')](_0x24daf5[_0xc3f7('0x35')][_0xc3f7('0x61')]);}return db[_0xc3f7('0x56')][_0xc3f7('0x44')](_0x12f1d3)[_0xc3f7('0x26')](handleEntityNotFound(_0x390676,null))['then'](function(_0x351389){if(_0x351389){_0x4bc5b8=_0x351389;return db[_0xc3f7('0x63')][_0xc3f7('0x44')]({'where':{'SessionId':{'$in':_[_0xc3f7('0x2f')](_0x4bc5b8,'id')},'ProjectId':_0x24daf5['params']['id']},'order':'-createdAt'});}})[_0xc3f7('0x26')](handleEntityNotFound(_0x390676,null))[_0xc3f7('0x26')](function(_0x12ff8d){if(_0x12ff8d){_0x1bcc31=_0x12ff8d;var _0x34cc3f={};for(var _0xa68fea=0x0,_0x161ebe=_0x1bcc31['length'];_0xa68fea<_0x161ebe;_0xa68fea++){if(!_0x34cc3f[_0xc3f7('0x5b')](_0x1bcc31[_0xa68fea][_0xc3f7('0x64')])){_0x34cc3f[_0x1bcc31[_0xa68fea][_0xc3f7('0x64')]]=needsEncapsulation(_0x1bcc31[_0xa68fea][_0xc3f7('0x65')])?encapsulate(_0x1bcc31[_0xa68fea][_0xc3f7('0x65')]):_0x1bcc31[_0xa68fea][_0xc3f7('0x65')];}}var _0x1e38f1=[],_0x4a9910={};for(var _0x2d7864=0x0,_0x40e4f8=_0x4bc5b8[_0xc3f7('0x39')];_0x2d7864<_0x40e4f8;_0x2d7864++){_0x4a9910={'ProjectId':_0x24daf5['params']['id'],'SessionId':_0x4bc5b8[_0x2d7864]['id'],'StartTime':moment(_0x4bc5b8[_0x2d7864]['starttime'])['format'](_0xc3f7('0x66'))};for(var _0x123a80=0x0,_0x4e8706=_0x1bcc31[_0xc3f7('0x39')];_0x123a80<_0x4e8706;_0x123a80++){if(_0x1bcc31[_0x123a80][_0xc3f7('0x67')]==_0x4bc5b8[_0x2d7864]['id']&&_0x34cc3f[_0xc3f7('0x5b')](_0x1bcc31[_0x123a80][_0xc3f7('0x64')])){_0x4a9910[_0x34cc3f[_0x1bcc31[_0x123a80][_0xc3f7('0x64')]]]=_0x1bcc31[_0x123a80][_0xc3f7('0x68')];}}for(var _0x775800 in _0x34cc3f){if(!_0x4a9910[_0xc3f7('0x5b')](_0x34cc3f[_0x775800])){_0x4a9910[_0x34cc3f[_0x775800]]=null;}}_0x1e38f1['push'](_0x4a9910);}return _0x1e38f1;}})[_0xc3f7('0x26')](function(_0x4b1750){if(!_['isEmpty'](_0x4b1750)){var _0x2e9191=toCsv(_0x4b1750);var _0x287ae7=Date[_0xc3f7('0x69')]();fs[_0xc3f7('0x6a')](util['format']('/tmp/Jscripty_Project_%d_Summary_%s.csv',_0x24daf5[_0xc3f7('0x47')]['id'],_0x287ae7),_0x2e9191);_0x390676['setHeader'](_0xc3f7('0x6b'),_0xc3f7('0x6c')+util[_0xc3f7('0x6d')]('Jscripty_Project_%d_Summary_%s.csv',_0x24daf5[_0xc3f7('0x47')]['id'],_0x287ae7));_0x390676['setHeader'](_0xc3f7('0x6e'),_0xc3f7('0x6f'));return _0x390676['download'](util[_0xc3f7('0x6d')](_0xc3f7('0x70'),_0x24daf5[_0xc3f7('0x47')]['id'],_0x287ae7));}else{return _0x390676[_0xc3f7('0x18')](0xcc);}})[_0xc3f7('0x45')](handleError(_0x390676,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff