// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x2679=['rawAttributes','model','query','dateStart','dateEnd','keys','filters','intersection','attributes','fields','length','hasOwnProperty','limit','sort','where','pick','add','day','merge','filter','map','options','includeAll','include','JscriptyProject','findAll','rows','catch','show','params','find','create','clone','omit','createdAt','updatedAt','body','findOne','JscriptySessionReport','order','ProjectId','getAnswers','JscriptyAnswerReport','nolimit','toString','indexOf','replace','JscriptyQuestionReport','-createdAt','questionId','question','starttime','format','YYYY-MM-DD\x20HH:mm:ss','SessionId','answer','now','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','zip-dir','request-promise','moment','bluebird','util','path','sox','ejs','lodash','squel','jsforce','desk.js','to-csv','querystring','papaparse','../../components/parsers/qs','api','../../config/utils','../../config/environment','../../mysqldb','status','end','json','count','offset','set','apply','reject','save','update','then','destroy','sendStatus','error','stack','name','send'];(function(_0x71290e,_0x1c5c87){var _0x102650=function(_0x4ac5be){while(--_0x4ac5be){_0x71290e['push'](_0x71290e['shift']());}};_0x102650(++_0x1c5c87);}(_0x2679,0x1ea));var _0x9267=function(_0x320296,_0x245139){_0x320296=_0x320296-0x0;var _0x31d05a=_0x2679[_0x320296];return _0x31d05a;};'use strict';var pdf=require(_0x9267('0x0'));var emlformat=require(_0x9267('0x1'));var rimraf=require(_0x9267('0x2'));var zipdir=require(_0x9267('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0x9267('0x4'));var moment=require(_0x9267('0x5'));var BPromise=require(_0x9267('0x6'));var Mustache=require('mustache');var util=require(_0x9267('0x7'));var path=require(_0x9267('0x8'));var sox=require(_0x9267('0x9'));var csv=require('to-csv');var ejs=require(_0x9267('0xa'));var fs=require('fs');var _=require(_0x9267('0xb'));var squel=require(_0x9267('0xc'));var crypto=require('crypto');var jsforce=require(_0x9267('0xd'));var deskjs=require(_0x9267('0xe'));var toCsv=require(_0x9267('0xf'));var querystring=require(_0x9267('0x10'));var Papa=require(_0x9267('0x11'));var qs=require(_0x9267('0x12'));var logger=require('../../config/logger')(_0x9267('0x13'));var utils=require(_0x9267('0x14'));var config=require(_0x9267('0x15'));var db=require(_0x9267('0x16'))['db'];function respondWithStatusCode(_0x53b14f,_0x2050c0){_0x2050c0=_0x2050c0||0xcc;return function(_0x53ed72){if(_0x53ed72){return _0x53b14f['sendStatus'](_0x2050c0);}return _0x53b14f[_0x9267('0x17')](_0x2050c0)[_0x9267('0x18')]();};}function respondWithResult(_0x28e9aa,_0xe971e6){_0xe971e6=_0xe971e6||0xc8;return function(_0x3fa85a){if(_0x3fa85a){return _0x28e9aa[_0x9267('0x17')](_0xe971e6)[_0x9267('0x19')](_0x3fa85a);}};}function respondWithFilteredResult(_0x36c370,_0xdc7f8d){return function(_0x40c051){if(_0x40c051){var _0x34f435=_0x40c051[_0x9267('0x1a')],_0x1ed6b0=_0xdc7f8d[_0x9267('0x1b')],_0x36c4e9=_0xdc7f8d[_0x9267('0x1b')]+_0xdc7f8d['limit'],_0x4e05fb;if(_0x36c4e9>=_0x34f435){_0x36c4e9=_0x34f435;_0x4e05fb=0xc8;}else{_0x4e05fb=0xce;}_0x36c370[_0x9267('0x17')](_0x4e05fb);return _0x36c370[_0x9267('0x1c')]('Content-Range',_0x1ed6b0+'-'+_0x36c4e9+'/'+_0x34f435)['json'](_0x40c051);}return null;};}function patchUpdates(_0x903e4f){return function(_0x537294){try{jsonpatch[_0x9267('0x1d')](_0x537294,_0x903e4f,!![]);}catch(_0x18f462){return BPromise[_0x9267('0x1e')](_0x18f462);}return _0x537294[_0x9267('0x1f')]();};}function saveUpdates(_0x1cadbe,_0x336412){return function(_0x377e11){if(_0x377e11){return _0x377e11[_0x9267('0x20')](_0x1cadbe)[_0x9267('0x21')](function(_0x4dab98){return _0x4dab98;});}return null;};}function removeEntity(_0x271e45,_0x4b9dec){return function(_0x307847){if(_0x307847){return _0x307847[_0x9267('0x22')]()[_0x9267('0x21')](function(){_0x271e45[_0x9267('0x17')](0xcc)[_0x9267('0x18')]();});}};}function handleEntityNotFound(_0x2d1b34,_0x31481e){return function(_0x60fa1c){if(!_0x60fa1c){_0x2d1b34[_0x9267('0x23')](0x194);}return _0x60fa1c;};}function handleError(_0xb3d865,_0x266445){_0x266445=_0x266445||0x1f4;return function(_0x39e8ae){logger[_0x9267('0x24')](_0x39e8ae[_0x9267('0x25')]);if(_0x39e8ae[_0x9267('0x26')]){delete _0x39e8ae[_0x9267('0x26')];}_0xb3d865[_0x9267('0x17')](_0x266445)[_0x9267('0x27')](_0x39e8ae);};}exports['index']=function(_0x97dbfa,_0x164d71){var _0xfc2b24={},_0x5c1064={},_0x1dd410={'count':0x0,'rows':[]};var _0xa5e499=db['JscriptyProject'][_0x9267('0x28')];_0x5c1064[_0x9267('0x29')]=_['keys'](_0xa5e499);var _0x17bb86={'dateStart':_0x97dbfa[_0x9267('0x2a')][_0x9267('0x2b')],'dateEnd':_0x97dbfa[_0x9267('0x2a')][_0x9267('0x2c')]};delete _0x97dbfa['query']['dateStart'];delete _0x97dbfa['query']['dateEnd'];_0x5c1064[_0x9267('0x2a')]=_[_0x9267('0x2d')](_0x97dbfa[_0x9267('0x2a')]);_0x5c1064[_0x9267('0x2e')]=_[_0x9267('0x2f')](_0x5c1064['model'],_0x5c1064['query']);_0xfc2b24[_0x9267('0x30')]=_[_0x9267('0x2f')](_0x5c1064[_0x9267('0x29')],qs[_0x9267('0x31')](_0x97dbfa[_0x9267('0x2a')][_0x9267('0x31')]));_0xfc2b24[_0x9267('0x30')]=_0xfc2b24['attributes'][_0x9267('0x32')]?_0xfc2b24[_0x9267('0x30')]:_0x5c1064['model'];if(!_0x97dbfa[_0x9267('0x2a')][_0x9267('0x33')]('nolimit')){_0xfc2b24[_0x9267('0x34')]=qs[_0x9267('0x34')](_0x97dbfa[_0x9267('0x2a')]['limit']);_0xfc2b24[_0x9267('0x1b')]=qs[_0x9267('0x1b')](_0x97dbfa[_0x9267('0x2a')][_0x9267('0x1b')]);}_0xfc2b24['order']=qs[_0x9267('0x35')](_0x97dbfa['query'][_0x9267('0x35')]);_0xfc2b24[_0x9267('0x36')]=qs[_0x9267('0x2e')](_[_0x9267('0x37')](_0x97dbfa['query'],_0x5c1064[_0x9267('0x2e')]));if(_0x17bb86['dateStart']){if(_0x17bb86[_0x9267('0x2c')]){_0x17bb86[_0x9267('0x2c')]=moment(_0x17bb86[_0x9267('0x2c')])[_0x9267('0x38')](0x1,_0x9267('0x39'));}else{_0x17bb86[_0x9267('0x2c')]=moment(_0x17bb86['dateStart'])[_0x9267('0x38')](0x1,'day');}_[_0x9267('0x3a')](_0xfc2b24[_0x9267('0x36')],{'createdAt':{'$gte':_0x17bb86[_0x9267('0x2b')],'$lte':_0x17bb86['dateEnd']}});}if(_0x97dbfa[_0x9267('0x2a')][_0x9267('0x3b')]){_0xfc2b24['where']=_[_0x9267('0x3a')](_0xfc2b24[_0x9267('0x36')],{'$or':_[_0x9267('0x3c')](_0xfc2b24['attributes'],function(_0x380280){var _0x20920e={};_0x20920e[_0x380280]={'$like':'%'+_0x97dbfa['query'][_0x9267('0x3b')]+'%'};return _0x20920e;})});}_0xfc2b24=_[_0x9267('0x3a')]({},_0xfc2b24,_0x97dbfa[_0x9267('0x3d')]);var _0x3784da={'where':_0xfc2b24[_0x9267('0x36')]};return db['JscriptyProject'][_0x9267('0x1a')](_0x3784da)[_0x9267('0x21')](function(_0x29a34c){_0x1dd410[_0x9267('0x1a')]=_0x29a34c;if(_0x97dbfa['query'][_0x9267('0x3e')]){_0xfc2b24[_0x9267('0x3f')]=[{'all':!![]}];}return db[_0x9267('0x40')][_0x9267('0x41')](_0xfc2b24);})['then'](function(_0x5b48f3){_0x1dd410[_0x9267('0x42')]=_0x5b48f3;return _0x1dd410;})[_0x9267('0x21')](respondWithFilteredResult(_0x164d71,_0xfc2b24))[_0x9267('0x43')](handleError(_0x164d71,null));};exports[_0x9267('0x44')]=function(_0x5eb268,_0x16161c){var _0x129984={'raw':![],'where':{'id':_0x5eb268[_0x9267('0x45')]['id']}},_0x5a9cec={};_0x5a9cec[_0x9267('0x29')]=_[_0x9267('0x2d')](db[_0x9267('0x40')]['rawAttributes']);_0x5a9cec[_0x9267('0x2a')]=_['keys'](_0x5eb268['query']);_0x5a9cec[_0x9267('0x2e')]=_[_0x9267('0x2f')](_0x5a9cec[_0x9267('0x29')],_0x5a9cec['query']);_0x129984[_0x9267('0x30')]=_[_0x9267('0x2f')](_0x5a9cec[_0x9267('0x29')],qs[_0x9267('0x31')](_0x5eb268[_0x9267('0x2a')]['fields']));_0x129984[_0x9267('0x30')]=_0x129984[_0x9267('0x30')]['length']?_0x129984[_0x9267('0x30')]:_0x5a9cec[_0x9267('0x29')];if(_0x5eb268[_0x9267('0x2a')]['includeAll']){_0x129984['include']=[{'all':!![]}];}_0x129984=_[_0x9267('0x3a')]({},_0x129984,_0x5eb268[_0x9267('0x3d')]);return db['JscriptyProject'][_0x9267('0x46')](_0x129984)[_0x9267('0x21')](handleEntityNotFound(_0x16161c,null))[_0x9267('0x21')](respondWithResult(_0x16161c,null))['catch'](handleError(_0x16161c,null));};exports['create']=function(_0x272c2e,_0x313dae){return db[_0x9267('0x40')][_0x9267('0x47')](_0x272c2e['body'],{})[_0x9267('0x21')](respondWithResult(_0x313dae,0xc9))[_0x9267('0x43')](handleError(_0x313dae,null));};exports[_0x9267('0x48')]=function(_0x20b016,_0x55af8f){var _0x4973c0={'raw':![],'where':{'id':_0x20b016['params']['id']}},_0x3722b6={};_0x3722b6[_0x9267('0x29')]=_[_0x9267('0x2d')](db['JscriptyProject'][_0x9267('0x28')]);_0x4973c0[_0x9267('0x30')]=_[_0x9267('0x2f')](_0x3722b6[_0x9267('0x29')],qs[_0x9267('0x31')](_0x20b016['query']['fields']));_0x4973c0['attributes']=_0x4973c0[_0x9267('0x30')][_0x9267('0x32')]?_0x4973c0['attributes']:_0x3722b6[_0x9267('0x29')];if(_0x20b016[_0x9267('0x2a')]['includeAll']){_0x4973c0['include']=[{'all':!![]}];}_0x4973c0=_[_0x9267('0x3a')]({},_0x4973c0,_0x20b016[_0x9267('0x3d')]);return db[_0x9267('0x40')][_0x9267('0x46')](_0x4973c0)[_0x9267('0x21')](handleEntityNotFound(_0x55af8f,null))[_0x9267('0x21')](function(_0x1d18a6){if(_0x1d18a6){var _0x5d3ab5=_0x1d18a6['get']({'plain':!![]});_0x5d3ab5=qs[_0x9267('0x49')](_0x5d3ab5,['id',_0x9267('0x4a'),_0x9267('0x4b')]);_0x20b016[_0x9267('0x4c')]=_[_0x9267('0x49')](_0x20b016['body'],['id','createdAt',_0x9267('0x4b')]);return db['JscriptyProject']['create'](_[_0x9267('0x3a')](_0x5d3ab5,_0x20b016[_0x9267('0x4c')]),{'include':_0x20b016[_0x9267('0x2a')]['includeAll']?[{'all':!![]}]:undefined});}})['then'](respondWithResult(_0x55af8f,0xc9))[_0x9267('0x43')](handleError(_0x55af8f,null));};exports[_0x9267('0x20')]=function(_0x55ff2a,_0x3e57b2){if(_0x55ff2a['body']['id']){delete _0x55ff2a[_0x9267('0x4c')]['id'];}return db[_0x9267('0x40')][_0x9267('0x46')]({'where':{'id':_0x55ff2a[_0x9267('0x45')]['id']}})[_0x9267('0x21')](handleEntityNotFound(_0x3e57b2,null))[_0x9267('0x21')](saveUpdates(_0x55ff2a[_0x9267('0x4c')],null))[_0x9267('0x21')](respondWithResult(_0x3e57b2,null))[_0x9267('0x43')](handleError(_0x3e57b2,null));};exports[_0x9267('0x22')]=function(_0x4fca19,_0x1cd58c){return db[_0x9267('0x40')][_0x9267('0x46')]({'where':{'id':_0x4fca19['params']['id']}})['then'](handleEntityNotFound(_0x1cd58c,null))[_0x9267('0x21')](removeEntity(_0x1cd58c,null))[_0x9267('0x43')](handleError(_0x1cd58c,null));};exports['getSessions']=function(_0x2f6d81,_0x33cf68,_0x48a911){var _0x9c167d={'raw':!![],'where':{}};var _0xf44441={};var _0x458142={'count':0x0,'rows':[]};return db[_0x9267('0x40')][_0x9267('0x4d')]({'where':{'id':_0x2f6d81[_0x9267('0x45')]['id']}})[_0x9267('0x21')](handleEntityNotFound(_0x33cf68,null))[_0x9267('0x21')](function(_0x45a340){if(_0x45a340){_0xf44441['model']=_[_0x9267('0x2d')](db[_0x9267('0x4e')][_0x9267('0x28')]);_0xf44441[_0x9267('0x2a')]=_[_0x9267('0x2d')](_0x2f6d81[_0x9267('0x2a')]);_0xf44441['filters']=_[_0x9267('0x2f')](_0xf44441[_0x9267('0x29')],_0xf44441[_0x9267('0x2a')]);_0x9c167d[_0x9267('0x30')]=_[_0x9267('0x2f')](_0xf44441[_0x9267('0x29')],qs['fields'](_0x2f6d81[_0x9267('0x2a')]['fields']));_0x9c167d['attributes']=_0x9c167d[_0x9267('0x30')][_0x9267('0x32')]?_0x9c167d[_0x9267('0x30')]:_0xf44441[_0x9267('0x29')];if(!_0x2f6d81[_0x9267('0x2a')][_0x9267('0x33')]('nolimit')){_0x9c167d[_0x9267('0x34')]=qs[_0x9267('0x34')](_0x2f6d81[_0x9267('0x2a')]['limit']);_0x9c167d[_0x9267('0x1b')]=qs[_0x9267('0x1b')](_0x2f6d81[_0x9267('0x2a')][_0x9267('0x1b')]);}_0x9c167d[_0x9267('0x4f')]=qs[_0x9267('0x35')](_0x2f6d81['query'][_0x9267('0x35')]);_0x9c167d[_0x9267('0x36')]=qs[_0x9267('0x2e')](_[_0x9267('0x37')](_0x2f6d81[_0x9267('0x2a')],_0xf44441[_0x9267('0x2e')]));_0x9c167d[_0x9267('0x36')][_0x9267('0x50')]=_0x45a340['id'];if(_0x2f6d81[_0x9267('0x2a')][_0x9267('0x3b')]){_0x9c167d[_0x9267('0x36')]=_[_0x9267('0x3a')](_0x9c167d[_0x9267('0x36')],{'$or':_[_0x9267('0x3c')](_0x9c167d[_0x9267('0x30')],function(_0x2d55d8){var _0x1ade4b={};_0x1ade4b[_0x2d55d8]={'$like':'%'+_0x2f6d81[_0x9267('0x2a')][_0x9267('0x3b')]+'%'};return _0x1ade4b;})});}_0x9c167d=_['merge']({},_0x9c167d,_0x2f6d81['options']);return db[_0x9267('0x4e')][_0x9267('0x1a')]({'where':_0x9c167d[_0x9267('0x36')]})[_0x9267('0x21')](function(_0x43a743){_0x458142[_0x9267('0x1a')]=_0x43a743;if(_0x2f6d81[_0x9267('0x2a')]['includeAll']){_0x9c167d[_0x9267('0x3f')]=[{'all':!![]}];}return db[_0x9267('0x4e')][_0x9267('0x41')](_0x9c167d);})['then'](function(_0x57204e){_0x458142[_0x9267('0x42')]=_0x57204e;return _0x458142;});}})[_0x9267('0x21')](respondWithFilteredResult(_0x33cf68,_0x9c167d))['catch'](handleError(_0x33cf68,null));};exports[_0x9267('0x51')]=function(_0x2acd1a,_0x11359b,_0x5504c0){var _0x769445={'raw':!![],'where':{}};var _0x172b0e={};var _0x4f1ac6={'count':0x0,'rows':[]};var _0x14b9d3={'dateStart':_0x2acd1a[_0x9267('0x2a')][_0x9267('0x2b')],'dateEnd':_0x2acd1a[_0x9267('0x2a')][_0x9267('0x2c')]};delete _0x2acd1a[_0x9267('0x2a')][_0x9267('0x2b')];delete _0x2acd1a['query'][_0x9267('0x2c')];return db[_0x9267('0x40')]['findOne']({'where':{'id':_0x2acd1a[_0x9267('0x45')]['id']}})[_0x9267('0x21')](handleEntityNotFound(_0x11359b,null))[_0x9267('0x21')](function(_0xff260b){if(_0xff260b){_0x172b0e[_0x9267('0x29')]=_['keys'](db[_0x9267('0x52')]['rawAttributes']);_0x172b0e[_0x9267('0x2a')]=_['keys'](_0x2acd1a[_0x9267('0x2a')]);_0x172b0e[_0x9267('0x2e')]=_['intersection'](_0x172b0e[_0x9267('0x29')],_0x172b0e[_0x9267('0x2a')]);_0x769445['attributes']=_[_0x9267('0x2f')](_0x172b0e[_0x9267('0x29')],qs[_0x9267('0x31')](_0x2acd1a[_0x9267('0x2a')][_0x9267('0x31')]));_0x769445[_0x9267('0x30')]=_0x769445[_0x9267('0x30')][_0x9267('0x32')]?_0x769445[_0x9267('0x30')]:_0x172b0e['model'];if(!_0x2acd1a['query'][_0x9267('0x33')](_0x9267('0x53'))){_0x769445[_0x9267('0x34')]=qs[_0x9267('0x34')](_0x2acd1a[_0x9267('0x2a')][_0x9267('0x34')]);_0x769445['offset']=qs[_0x9267('0x1b')](_0x2acd1a['query'][_0x9267('0x1b')]);}_0x769445[_0x9267('0x4f')]=qs[_0x9267('0x35')](_0x2acd1a['query'][_0x9267('0x35')]);_0x769445[_0x9267('0x36')]=qs['filters'](_[_0x9267('0x37')](_0x2acd1a[_0x9267('0x2a')],_0x172b0e[_0x9267('0x2e')]));_0x769445['where']['ProjectId']=_0xff260b['id'];if(_0x14b9d3[_0x9267('0x2b')]){if(_0x14b9d3['dateEnd']){_0x14b9d3[_0x9267('0x2c')]=moment(_0x14b9d3[_0x9267('0x2c')])[_0x9267('0x38')](0x1,_0x9267('0x39'));}else{_0x14b9d3[_0x9267('0x2c')]=moment(_0x14b9d3['dateStart'])['add'](0x1,_0x9267('0x39'));}_['merge'](_0x769445[_0x9267('0x36')],{'createdAt':{'$gte':_0x14b9d3[_0x9267('0x2b')],'$lte':_0x14b9d3[_0x9267('0x2c')]}});}if(_0x2acd1a[_0x9267('0x2a')]['filter']){_0x769445['where']=_['merge'](_0x769445[_0x9267('0x36')],{'$or':_[_0x9267('0x3c')](_0x769445['attributes'],function(_0x231e3b){var _0x18ce85={};_0x18ce85[_0x231e3b]={'$like':'%'+_0x2acd1a[_0x9267('0x2a')][_0x9267('0x3b')]+'%'};return _0x18ce85;})});}_0x769445=_[_0x9267('0x3a')]({},_0x769445,_0x2acd1a[_0x9267('0x3d')]);return db[_0x9267('0x52')][_0x9267('0x1a')]({'where':_0x769445[_0x9267('0x36')]})[_0x9267('0x21')](function(_0x129fbc){_0x4f1ac6['count']=_0x129fbc;if(_0x2acd1a['query'][_0x9267('0x3e')]){_0x769445[_0x9267('0x3f')]=[{'all':!![]}];}return db[_0x9267('0x52')]['findAll'](_0x769445);})[_0x9267('0x21')](function(_0x18f9f3){_0x4f1ac6[_0x9267('0x42')]=_0x18f9f3;return _0x4f1ac6;});}})['then'](respondWithFilteredResult(_0x11359b,_0x769445))['catch'](handleError(_0x11359b,null));};function char(_0x4035e9){return'number'===typeof _0x4035e9?String['fromCharCode'][_0x9267('0x1d')](null,arguments):_0x4035e9;}function needsEncapsulation(_0x5f1930){return!!_0x5f1930&&(_0x5f1930[_0x9267('0x54')]()['indexOf'](char(0xd))>=0x0||_0x5f1930['toString']()[_0x9267('0x55')](char(0xa))>=0x0||_0x5f1930['toString']()[_0x9267('0x55')](char(0x2c))>=0x0||_0x5f1930[_0x9267('0x54')]()[_0x9267('0x55')](char(0x22))>=0x0);}function encapsulate(_0x24fada){var _0x189ea1=char(0x22),_0x1efed8='\x5c'+char(0x22),_0x2bcfbc=_0x24fada[_0x9267('0x54')]()[_0x9267('0x56')](new RegExp(_0x189ea1,'g'),_0x1efed8);return _0x189ea1+_0x2bcfbc+_0x189ea1;}exports['getSummary']=function(_0x5c18b0,_0x41560f,_0x503107){var _0x47698f,_0x167ea9;var _0xfef286={'dateStart':_0x5c18b0[_0x9267('0x2a')][_0x9267('0x2b')],'dateEnd':_0x5c18b0[_0x9267('0x2a')][_0x9267('0x2c')]};delete _0x5c18b0[_0x9267('0x2a')]['dateStart'];delete _0x5c18b0[_0x9267('0x2a')][_0x9267('0x2c')];if(_0xfef286[_0x9267('0x2b')]){if(_0xfef286['dateEnd']){_0xfef286[_0x9267('0x2c')]=moment(_0xfef286[_0x9267('0x2c')])['add'](0x1,_0x9267('0x39'));}else{_0xfef286['dateEnd']=moment(_0xfef286['dateStart'])[_0x9267('0x38')](0x1,_0x9267('0x39'));}}return db[_0x9267('0x4e')][_0x9267('0x41')]({'where':{'ProjectId':_0x5c18b0[_0x9267('0x45')]['id'],'starttime':{'$gte':_0xfef286['dateStart'],'$lte':_0xfef286['dateEnd']}}})['then'](handleEntityNotFound(_0x41560f,null))[_0x9267('0x21')](function(_0x3aebc3){if(_0x3aebc3){_0x47698f=_0x3aebc3;return db[_0x9267('0x57')]['findAll']({'where':{'SessionId':{'$in':_[_0x9267('0x3c')](_0x47698f,'id')},'ProjectId':_0x5c18b0[_0x9267('0x45')]['id']},'order':_0x9267('0x58')});}})[_0x9267('0x21')](handleEntityNotFound(_0x41560f,null))['then'](function(_0x31a6b3){if(_0x31a6b3){_0x167ea9=_0x31a6b3;var _0x1e093a={};for(var _0x303687=0x0,_0x1786a3=_0x167ea9['length'];_0x303687<_0x1786a3;_0x303687++){if(!_0x1e093a[_0x9267('0x33')](_0x167ea9[_0x303687][_0x9267('0x59')])){_0x1e093a[_0x167ea9[_0x303687][_0x9267('0x59')]]=needsEncapsulation(_0x167ea9[_0x303687]['question'])?encapsulate(_0x167ea9[_0x303687][_0x9267('0x5a')]):_0x167ea9[_0x303687][_0x9267('0x5a')];}}var _0x5d186e=[],_0x4d8562={};for(var _0x2259a9=0x0,_0x1c3d85=_0x47698f[_0x9267('0x32')];_0x2259a9<_0x1c3d85;_0x2259a9++){_0x4d8562={'ProjectId':_0x5c18b0['params']['id'],'SessionId':_0x47698f[_0x2259a9]['id'],'StartTime':moment(_0x47698f[_0x2259a9][_0x9267('0x5b')])[_0x9267('0x5c')](_0x9267('0x5d'))};for(var _0x2eb88c=0x0,_0x21b123=_0x167ea9['length'];_0x2eb88c<_0x21b123;_0x2eb88c++){if(_0x167ea9[_0x2eb88c][_0x9267('0x5e')]==_0x47698f[_0x2259a9]['id']&&_0x1e093a['hasOwnProperty'](_0x167ea9[_0x2eb88c][_0x9267('0x59')])){_0x4d8562[_0x1e093a[_0x167ea9[_0x2eb88c][_0x9267('0x59')]]]=_0x167ea9[_0x2eb88c][_0x9267('0x5f')];}}for(var _0x1a891c in _0x1e093a){if(!_0x4d8562[_0x9267('0x33')](_0x1e093a[_0x1a891c])){_0x4d8562[_0x1e093a[_0x1a891c]]=null;}}_0x5d186e['push'](_0x4d8562);}return _0x5d186e;}})[_0x9267('0x21')](function(_0x2b81cb){if(!_['isEmpty'](_0x2b81cb)){var _0x254236=toCsv(_0x2b81cb);var _0x4e5717=Date[_0x9267('0x60')]();fs[_0x9267('0x61')](util['format'](_0x9267('0x62'),_0x5c18b0[_0x9267('0x45')]['id'],_0x4e5717),_0x254236);_0x41560f[_0x9267('0x63')](_0x9267('0x64'),_0x9267('0x65')+util[_0x9267('0x5c')](_0x9267('0x66'),_0x5c18b0[_0x9267('0x45')]['id'],_0x4e5717));_0x41560f['setHeader'](_0x9267('0x67'),_0x9267('0x68'));return _0x41560f[_0x9267('0x69')](util['format'](_0x9267('0x62'),_0x5c18b0[_0x9267('0x45')]['id'],_0x4e5717));}else{return _0x41560f[_0x9267('0x23')](0xcc);}})[_0x9267('0x43')](handleError(_0x41560f,null));};
\ No newline at end of file
+var _0x32ed=['fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','add','merge','filter','map','options','count','includeAll','include','findAll','catch','show','find','create','body','clone','get','createdAt','updatedAt','omit','params','getSessions','findOne','JscriptySessionReport','ProjectId','getAnswers','JscriptyAnswerReport','day','fromCharCode','toString','indexOf','replace','getSummary','JscriptyQuestionReport','questionId','question','starttime','format','YYYY-MM-DD\x20HH:mm:ss','answer','isEmpty','now','writeFileSync','/tmp/Jscripty_Project_%d_Summary_%s.csv','Content-disposition','Jscripty_Project_%d_Summary_%s.csv','setHeader','text/csv','download','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','sox','ejs','lodash','squel','crypto','jsforce','desk.js','to-csv','querystring','papaparse','../../components/parsers/qs','../../config/logger','../../config/utils','../../config/environment','sendStatus','status','end','offset','limit','set','Content-Range','apply','reject','save','update','destroy','then','error','stack','name','index','JscriptyProject','rawAttributes','model','keys','dateStart','query','dateEnd','filters','intersection'];(function(_0x25e839,_0xd7f934){var _0x2cf882=function(_0x261dab){while(--_0x261dab){_0x25e839['push'](_0x25e839['shift']());}};_0x2cf882(++_0xd7f934);}(_0x32ed,0x177));var _0xd32e=function(_0x5701a8,_0x497706){_0x5701a8=_0x5701a8-0x0;var _0x2e1012=_0x32ed[_0x5701a8];return _0x2e1012;};'use strict';var pdf=require(_0xd32e('0x0'));var emlformat=require(_0xd32e('0x1'));var rimraf=require(_0xd32e('0x2'));var zipdir=require(_0xd32e('0x3'));var jsonpatch=require(_0xd32e('0x4'));var rp=require('request-promise');var moment=require(_0xd32e('0x5'));var BPromise=require(_0xd32e('0x6'));var Mustache=require(_0xd32e('0x7'));var util=require(_0xd32e('0x8'));var path=require('path');var sox=require(_0xd32e('0x9'));var csv=require('to-csv');var ejs=require(_0xd32e('0xa'));var fs=require('fs');var _=require(_0xd32e('0xb'));var squel=require(_0xd32e('0xc'));var crypto=require(_0xd32e('0xd'));var jsforce=require(_0xd32e('0xe'));var deskjs=require(_0xd32e('0xf'));var toCsv=require(_0xd32e('0x10'));var querystring=require(_0xd32e('0x11'));var Papa=require(_0xd32e('0x12'));var qs=require(_0xd32e('0x13'));var logger=require(_0xd32e('0x14'))('api');var utils=require(_0xd32e('0x15'));var config=require(_0xd32e('0x16'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x142190,_0x31b56c){_0x31b56c=_0x31b56c||0xcc;return function(_0x3c0bee){if(_0x3c0bee){return _0x142190[_0xd32e('0x17')](_0x31b56c);}return _0x142190[_0xd32e('0x18')](_0x31b56c)[_0xd32e('0x19')]();};}function respondWithResult(_0x52a94a,_0x500cfd){_0x500cfd=_0x500cfd||0xc8;return function(_0x530dc6){if(_0x530dc6){return _0x52a94a['status'](_0x500cfd)['json'](_0x530dc6);}};}function respondWithFilteredResult(_0x52ab69,_0x2df434){return function(_0x2ef0ff){if(_0x2ef0ff){var _0x5d4465=_0x2ef0ff['count'],_0x5eae38=_0x2df434[_0xd32e('0x1a')],_0x3db993=_0x2df434['offset']+_0x2df434[_0xd32e('0x1b')],_0x253190;if(_0x3db993>=_0x5d4465){_0x3db993=_0x5d4465;_0x253190=0xc8;}else{_0x253190=0xce;}_0x52ab69[_0xd32e('0x18')](_0x253190);return _0x52ab69[_0xd32e('0x1c')](_0xd32e('0x1d'),_0x5eae38+'-'+_0x3db993+'/'+_0x5d4465)['json'](_0x2ef0ff);}return null;};}function patchUpdates(_0x547c5e){return function(_0x26660d){try{jsonpatch[_0xd32e('0x1e')](_0x26660d,_0x547c5e,!![]);}catch(_0x2ae807){return BPromise[_0xd32e('0x1f')](_0x2ae807);}return _0x26660d[_0xd32e('0x20')]();};}function saveUpdates(_0x20be6d,_0x7b9b2c){return function(_0x5a387a){if(_0x5a387a){return _0x5a387a[_0xd32e('0x21')](_0x20be6d)['then'](function(_0x5c9e3b){return _0x5c9e3b;});}return null;};}function removeEntity(_0x4a5973,_0x482ab2){return function(_0x4adbfc){if(_0x4adbfc){return _0x4adbfc[_0xd32e('0x22')]()[_0xd32e('0x23')](function(){_0x4a5973[_0xd32e('0x18')](0xcc)[_0xd32e('0x19')]();});}};}function handleEntityNotFound(_0x28d523,_0x599930){return function(_0x4667b0){if(!_0x4667b0){_0x28d523['sendStatus'](0x194);}return _0x4667b0;};}function handleError(_0x58339c,_0x2faeb8){_0x2faeb8=_0x2faeb8||0x1f4;return function(_0x5e07c5){logger[_0xd32e('0x24')](_0x5e07c5[_0xd32e('0x25')]);if(_0x5e07c5[_0xd32e('0x26')]){delete _0x5e07c5['name'];}_0x58339c['status'](_0x2faeb8)['send'](_0x5e07c5);};}exports[_0xd32e('0x27')]=function(_0x5c7227,_0x6e061d){var _0x4a3035={},_0xcc6d1a={},_0x738d71={'count':0x0,'rows':[]};var _0xd44aef=db[_0xd32e('0x28')][_0xd32e('0x29')];_0xcc6d1a[_0xd32e('0x2a')]=_[_0xd32e('0x2b')](_0xd44aef);var _0x18fd23={'dateStart':_0x5c7227['query'][_0xd32e('0x2c')],'dateEnd':_0x5c7227[_0xd32e('0x2d')][_0xd32e('0x2e')]};delete _0x5c7227[_0xd32e('0x2d')][_0xd32e('0x2c')];delete _0x5c7227[_0xd32e('0x2d')]['dateEnd'];_0xcc6d1a[_0xd32e('0x2d')]=_[_0xd32e('0x2b')](_0x5c7227[_0xd32e('0x2d')]);_0xcc6d1a[_0xd32e('0x2f')]=_[_0xd32e('0x30')](_0xcc6d1a[_0xd32e('0x2a')],_0xcc6d1a[_0xd32e('0x2d')]);_0x4a3035['attributes']=_[_0xd32e('0x30')](_0xcc6d1a[_0xd32e('0x2a')],qs[_0xd32e('0x31')](_0x5c7227[_0xd32e('0x2d')]['fields']));_0x4a3035[_0xd32e('0x32')]=_0x4a3035['attributes'][_0xd32e('0x33')]?_0x4a3035[_0xd32e('0x32')]:_0xcc6d1a[_0xd32e('0x2a')];if(!_0x5c7227[_0xd32e('0x2d')][_0xd32e('0x34')](_0xd32e('0x35'))){_0x4a3035['limit']=qs[_0xd32e('0x1b')](_0x5c7227[_0xd32e('0x2d')][_0xd32e('0x1b')]);_0x4a3035[_0xd32e('0x1a')]=qs['offset'](_0x5c7227[_0xd32e('0x2d')][_0xd32e('0x1a')]);}_0x4a3035[_0xd32e('0x36')]=qs['sort'](_0x5c7227['query'][_0xd32e('0x37')]);_0x4a3035[_0xd32e('0x38')]=qs[_0xd32e('0x2f')](_[_0xd32e('0x39')](_0x5c7227[_0xd32e('0x2d')],_0xcc6d1a[_0xd32e('0x2f')]));if(_0x18fd23[_0xd32e('0x2c')]){if(_0x18fd23[_0xd32e('0x2e')]){_0x18fd23[_0xd32e('0x2e')]=moment(_0x18fd23['dateEnd'])[_0xd32e('0x3a')](0x1,'day');}else{_0x18fd23[_0xd32e('0x2e')]=moment(_0x18fd23[_0xd32e('0x2c')])[_0xd32e('0x3a')](0x1,'day');}_[_0xd32e('0x3b')](_0x4a3035['where'],{'createdAt':{'$gte':_0x18fd23[_0xd32e('0x2c')],'$lte':_0x18fd23[_0xd32e('0x2e')]}});}if(_0x5c7227[_0xd32e('0x2d')][_0xd32e('0x3c')]){_0x4a3035['where']=_[_0xd32e('0x3b')](_0x4a3035[_0xd32e('0x38')],{'$or':_[_0xd32e('0x3d')](_0x4a3035[_0xd32e('0x32')],function(_0x503172){var _0x55d04d={};_0x55d04d[_0x503172]={'$like':'%'+_0x5c7227[_0xd32e('0x2d')]['filter']+'%'};return _0x55d04d;})});}_0x4a3035=_[_0xd32e('0x3b')]({},_0x4a3035,_0x5c7227[_0xd32e('0x3e')]);var _0x59abdd={'where':_0x4a3035[_0xd32e('0x38')]};return db[_0xd32e('0x28')][_0xd32e('0x3f')](_0x59abdd)[_0xd32e('0x23')](function(_0x47f91d){_0x738d71[_0xd32e('0x3f')]=_0x47f91d;if(_0x5c7227['query'][_0xd32e('0x40')]){_0x4a3035[_0xd32e('0x41')]=[{'all':!![]}];}return db[_0xd32e('0x28')][_0xd32e('0x42')](_0x4a3035);})['then'](function(_0x38d23b){_0x738d71['rows']=_0x38d23b;return _0x738d71;})[_0xd32e('0x23')](respondWithFilteredResult(_0x6e061d,_0x4a3035))[_0xd32e('0x43')](handleError(_0x6e061d,null));};exports[_0xd32e('0x44')]=function(_0x2a12b0,_0x366e21){var _0x225d08={'raw':![],'where':{'id':_0x2a12b0['params']['id']}},_0x420038={};_0x420038['model']=_['keys'](db[_0xd32e('0x28')]['rawAttributes']);_0x420038['query']=_[_0xd32e('0x2b')](_0x2a12b0[_0xd32e('0x2d')]);_0x420038[_0xd32e('0x2f')]=_['intersection'](_0x420038['model'],_0x420038[_0xd32e('0x2d')]);_0x225d08['attributes']=_[_0xd32e('0x30')](_0x420038[_0xd32e('0x2a')],qs[_0xd32e('0x31')](_0x2a12b0['query'][_0xd32e('0x31')]));_0x225d08[_0xd32e('0x32')]=_0x225d08[_0xd32e('0x32')][_0xd32e('0x33')]?_0x225d08['attributes']:_0x420038['model'];if(_0x2a12b0[_0xd32e('0x2d')][_0xd32e('0x40')]){_0x225d08[_0xd32e('0x41')]=[{'all':!![]}];}_0x225d08=_['merge']({},_0x225d08,_0x2a12b0[_0xd32e('0x3e')]);return db['JscriptyProject'][_0xd32e('0x45')](_0x225d08)[_0xd32e('0x23')](handleEntityNotFound(_0x366e21,null))[_0xd32e('0x23')](respondWithResult(_0x366e21,null))[_0xd32e('0x43')](handleError(_0x366e21,null));};exports[_0xd32e('0x46')]=function(_0x174a8e,_0x937451){return db['JscriptyProject'][_0xd32e('0x46')](_0x174a8e[_0xd32e('0x47')],{})['then'](respondWithResult(_0x937451,0xc9))[_0xd32e('0x43')](handleError(_0x937451,null));};exports[_0xd32e('0x48')]=function(_0x3a07ee,_0x316584){var _0x4dd304={'raw':![],'where':{'id':_0x3a07ee['params']['id']}},_0x5c1520={};_0x5c1520[_0xd32e('0x2a')]=_[_0xd32e('0x2b')](db[_0xd32e('0x28')]['rawAttributes']);_0x4dd304[_0xd32e('0x32')]=_[_0xd32e('0x30')](_0x5c1520['model'],qs[_0xd32e('0x31')](_0x3a07ee['query'][_0xd32e('0x31')]));_0x4dd304['attributes']=_0x4dd304[_0xd32e('0x32')][_0xd32e('0x33')]?_0x4dd304[_0xd32e('0x32')]:_0x5c1520[_0xd32e('0x2a')];if(_0x3a07ee[_0xd32e('0x2d')]['includeAll']){_0x4dd304[_0xd32e('0x41')]=[{'all':!![]}];}_0x4dd304=_['merge']({},_0x4dd304,_0x3a07ee[_0xd32e('0x3e')]);return db[_0xd32e('0x28')][_0xd32e('0x45')](_0x4dd304)[_0xd32e('0x23')](handleEntityNotFound(_0x316584,null))[_0xd32e('0x23')](function(_0x388eba){if(_0x388eba){var _0x5ad03a=_0x388eba[_0xd32e('0x49')]({'plain':!![]});_0x5ad03a=qs['omit'](_0x5ad03a,['id',_0xd32e('0x4a'),_0xd32e('0x4b')]);_0x3a07ee['body']=_[_0xd32e('0x4c')](_0x3a07ee[_0xd32e('0x47')],['id',_0xd32e('0x4a'),_0xd32e('0x4b')]);return db[_0xd32e('0x28')][_0xd32e('0x46')](_['merge'](_0x5ad03a,_0x3a07ee[_0xd32e('0x47')]),{'include':_0x3a07ee[_0xd32e('0x2d')][_0xd32e('0x40')]?[{'all':!![]}]:undefined});}})[_0xd32e('0x23')](respondWithResult(_0x316584,0xc9))[_0xd32e('0x43')](handleError(_0x316584,null));};exports[_0xd32e('0x21')]=function(_0x646cb9,_0x470e91){if(_0x646cb9[_0xd32e('0x47')]['id']){delete _0x646cb9['body']['id'];}return db[_0xd32e('0x28')][_0xd32e('0x45')]({'where':{'id':_0x646cb9[_0xd32e('0x4d')]['id']}})[_0xd32e('0x23')](handleEntityNotFound(_0x470e91,null))[_0xd32e('0x23')](saveUpdates(_0x646cb9[_0xd32e('0x47')],null))[_0xd32e('0x23')](respondWithResult(_0x470e91,null))[_0xd32e('0x43')](handleError(_0x470e91,null));};exports['destroy']=function(_0x71e646,_0x5dee71){return db[_0xd32e('0x28')][_0xd32e('0x45')]({'where':{'id':_0x71e646[_0xd32e('0x4d')]['id']}})[_0xd32e('0x23')](handleEntityNotFound(_0x5dee71,null))[_0xd32e('0x23')](removeEntity(_0x5dee71,null))[_0xd32e('0x43')](handleError(_0x5dee71,null));};exports[_0xd32e('0x4e')]=function(_0x2ff3df,_0x52ee6b,_0x4264f4){var _0x2882a0={'raw':!![],'where':{}};var _0x543183={};var _0x360fd0={'count':0x0,'rows':[]};return db[_0xd32e('0x28')][_0xd32e('0x4f')]({'where':{'id':_0x2ff3df[_0xd32e('0x4d')]['id']}})[_0xd32e('0x23')](handleEntityNotFound(_0x52ee6b,null))[_0xd32e('0x23')](function(_0x39cd55){if(_0x39cd55){_0x543183[_0xd32e('0x2a')]=_[_0xd32e('0x2b')](db[_0xd32e('0x50')][_0xd32e('0x29')]);_0x543183['query']=_['keys'](_0x2ff3df[_0xd32e('0x2d')]);_0x543183['filters']=_[_0xd32e('0x30')](_0x543183[_0xd32e('0x2a')],_0x543183['query']);_0x2882a0[_0xd32e('0x32')]=_[_0xd32e('0x30')](_0x543183['model'],qs['fields'](_0x2ff3df['query'][_0xd32e('0x31')]));_0x2882a0[_0xd32e('0x32')]=_0x2882a0[_0xd32e('0x32')][_0xd32e('0x33')]?_0x2882a0[_0xd32e('0x32')]:_0x543183[_0xd32e('0x2a')];if(!_0x2ff3df[_0xd32e('0x2d')][_0xd32e('0x34')]('nolimit')){_0x2882a0[_0xd32e('0x1b')]=qs[_0xd32e('0x1b')](_0x2ff3df[_0xd32e('0x2d')][_0xd32e('0x1b')]);_0x2882a0['offset']=qs[_0xd32e('0x1a')](_0x2ff3df[_0xd32e('0x2d')][_0xd32e('0x1a')]);}_0x2882a0['order']=qs['sort'](_0x2ff3df[_0xd32e('0x2d')][_0xd32e('0x37')]);_0x2882a0['where']=qs[_0xd32e('0x2f')](_[_0xd32e('0x39')](_0x2ff3df[_0xd32e('0x2d')],_0x543183[_0xd32e('0x2f')]));_0x2882a0[_0xd32e('0x38')][_0xd32e('0x51')]=_0x39cd55['id'];if(_0x2ff3df[_0xd32e('0x2d')]['filter']){_0x2882a0[_0xd32e('0x38')]=_[_0xd32e('0x3b')](_0x2882a0['where'],{'$or':_[_0xd32e('0x3d')](_0x2882a0[_0xd32e('0x32')],function(_0x3ca1c5){var _0x8c5e82={};_0x8c5e82[_0x3ca1c5]={'$like':'%'+_0x2ff3df[_0xd32e('0x2d')][_0xd32e('0x3c')]+'%'};return _0x8c5e82;})});}_0x2882a0=_['merge']({},_0x2882a0,_0x2ff3df['options']);return db[_0xd32e('0x50')][_0xd32e('0x3f')]({'where':_0x2882a0[_0xd32e('0x38')]})[_0xd32e('0x23')](function(_0x347da4){_0x360fd0[_0xd32e('0x3f')]=_0x347da4;if(_0x2ff3df[_0xd32e('0x2d')][_0xd32e('0x40')]){_0x2882a0[_0xd32e('0x41')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0xd32e('0x42')](_0x2882a0);})[_0xd32e('0x23')](function(_0x3528a4){_0x360fd0['rows']=_0x3528a4;return _0x360fd0;});}})[_0xd32e('0x23')](respondWithFilteredResult(_0x52ee6b,_0x2882a0))[_0xd32e('0x43')](handleError(_0x52ee6b,null));};exports[_0xd32e('0x52')]=function(_0xb8aca6,_0x47876c,_0x4e423b){var _0x64fd54={'raw':!![],'where':{}};var _0x5c8a86={};var _0xdc9f3c={'count':0x0,'rows':[]};var _0x38ec7c={'dateStart':_0xb8aca6['query'][_0xd32e('0x2c')],'dateEnd':_0xb8aca6['query']['dateEnd']};delete _0xb8aca6['query'][_0xd32e('0x2c')];delete _0xb8aca6[_0xd32e('0x2d')][_0xd32e('0x2e')];return db[_0xd32e('0x28')][_0xd32e('0x4f')]({'where':{'id':_0xb8aca6['params']['id']}})[_0xd32e('0x23')](handleEntityNotFound(_0x47876c,null))[_0xd32e('0x23')](function(_0x20e7ef){if(_0x20e7ef){_0x5c8a86[_0xd32e('0x2a')]=_[_0xd32e('0x2b')](db[_0xd32e('0x53')][_0xd32e('0x29')]);_0x5c8a86[_0xd32e('0x2d')]=_[_0xd32e('0x2b')](_0xb8aca6[_0xd32e('0x2d')]);_0x5c8a86['filters']=_[_0xd32e('0x30')](_0x5c8a86['model'],_0x5c8a86['query']);_0x64fd54[_0xd32e('0x32')]=_[_0xd32e('0x30')](_0x5c8a86[_0xd32e('0x2a')],qs[_0xd32e('0x31')](_0xb8aca6[_0xd32e('0x2d')][_0xd32e('0x31')]));_0x64fd54[_0xd32e('0x32')]=_0x64fd54[_0xd32e('0x32')][_0xd32e('0x33')]?_0x64fd54[_0xd32e('0x32')]:_0x5c8a86[_0xd32e('0x2a')];if(!_0xb8aca6[_0xd32e('0x2d')][_0xd32e('0x34')]('nolimit')){_0x64fd54[_0xd32e('0x1b')]=qs[_0xd32e('0x1b')](_0xb8aca6['query'][_0xd32e('0x1b')]);_0x64fd54[_0xd32e('0x1a')]=qs['offset'](_0xb8aca6[_0xd32e('0x2d')][_0xd32e('0x1a')]);}_0x64fd54['order']=qs[_0xd32e('0x37')](_0xb8aca6['query'][_0xd32e('0x37')]);_0x64fd54[_0xd32e('0x38')]=qs[_0xd32e('0x2f')](_[_0xd32e('0x39')](_0xb8aca6[_0xd32e('0x2d')],_0x5c8a86[_0xd32e('0x2f')]));_0x64fd54['where'][_0xd32e('0x51')]=_0x20e7ef['id'];if(_0x38ec7c['dateStart']){if(_0x38ec7c[_0xd32e('0x2e')]){_0x38ec7c[_0xd32e('0x2e')]=moment(_0x38ec7c[_0xd32e('0x2e')])[_0xd32e('0x3a')](0x1,_0xd32e('0x54'));}else{_0x38ec7c[_0xd32e('0x2e')]=moment(_0x38ec7c['dateStart'])[_0xd32e('0x3a')](0x1,_0xd32e('0x54'));}_[_0xd32e('0x3b')](_0x64fd54['where'],{'createdAt':{'$gte':_0x38ec7c[_0xd32e('0x2c')],'$lte':_0x38ec7c['dateEnd']}});}if(_0xb8aca6['query'][_0xd32e('0x3c')]){_0x64fd54[_0xd32e('0x38')]=_[_0xd32e('0x3b')](_0x64fd54['where'],{'$or':_[_0xd32e('0x3d')](_0x64fd54[_0xd32e('0x32')],function(_0x5d1072){var _0x32aa51={};_0x32aa51[_0x5d1072]={'$like':'%'+_0xb8aca6[_0xd32e('0x2d')][_0xd32e('0x3c')]+'%'};return _0x32aa51;})});}_0x64fd54=_[_0xd32e('0x3b')]({},_0x64fd54,_0xb8aca6[_0xd32e('0x3e')]);return db['JscriptyAnswerReport'][_0xd32e('0x3f')]({'where':_0x64fd54['where']})[_0xd32e('0x23')](function(_0x2254d9){_0xdc9f3c['count']=_0x2254d9;if(_0xb8aca6[_0xd32e('0x2d')][_0xd32e('0x40')]){_0x64fd54['include']=[{'all':!![]}];}return db['JscriptyAnswerReport'][_0xd32e('0x42')](_0x64fd54);})[_0xd32e('0x23')](function(_0x5a8719){_0xdc9f3c['rows']=_0x5a8719;return _0xdc9f3c;});}})[_0xd32e('0x23')](respondWithFilteredResult(_0x47876c,_0x64fd54))[_0xd32e('0x43')](handleError(_0x47876c,null));};function char(_0x5f41b0){return'number'===typeof _0x5f41b0?String[_0xd32e('0x55')]['apply'](null,arguments):_0x5f41b0;}function needsEncapsulation(_0x4cd192){return!!_0x4cd192&&(_0x4cd192[_0xd32e('0x56')]()['indexOf'](char(0xd))>=0x0||_0x4cd192[_0xd32e('0x56')]()[_0xd32e('0x57')](char(0xa))>=0x0||_0x4cd192[_0xd32e('0x56')]()[_0xd32e('0x57')](char(0x2c))>=0x0||_0x4cd192['toString']()['indexOf'](char(0x22))>=0x0);}function encapsulate(_0x9585a3){var _0x299c15=char(0x22),_0x313410='\x5c'+char(0x22),_0x102d6e=_0x9585a3[_0xd32e('0x56')]()[_0xd32e('0x58')](new RegExp(_0x299c15,'g'),_0x313410);return _0x299c15+_0x102d6e+_0x299c15;}exports[_0xd32e('0x59')]=function(_0x22dd1d,_0x4a30ee,_0x22fd88){var _0x5d174e,_0xde9205;var _0x2b693d={'dateStart':_0x22dd1d['query'][_0xd32e('0x2c')],'dateEnd':_0x22dd1d[_0xd32e('0x2d')][_0xd32e('0x2e')]};delete _0x22dd1d[_0xd32e('0x2d')][_0xd32e('0x2c')];delete _0x22dd1d[_0xd32e('0x2d')][_0xd32e('0x2e')];if(_0x2b693d['dateStart']){if(_0x2b693d['dateEnd']){_0x2b693d[_0xd32e('0x2e')]=moment(_0x2b693d[_0xd32e('0x2e')])[_0xd32e('0x3a')](0x1,'day');}else{_0x2b693d[_0xd32e('0x2e')]=moment(_0x2b693d[_0xd32e('0x2c')])[_0xd32e('0x3a')](0x1,_0xd32e('0x54'));}}return db[_0xd32e('0x50')]['findAll']({'where':{'ProjectId':_0x22dd1d[_0xd32e('0x4d')]['id'],'starttime':{'$gte':_0x2b693d[_0xd32e('0x2c')],'$lte':_0x2b693d['dateEnd']}}})['then'](handleEntityNotFound(_0x4a30ee,null))[_0xd32e('0x23')](function(_0x27f444){if(_0x27f444){_0x5d174e=_0x27f444;return db[_0xd32e('0x5a')][_0xd32e('0x42')]({'where':{'SessionId':{'$in':_[_0xd32e('0x3d')](_0x5d174e,'id')},'ProjectId':_0x22dd1d['params']['id']},'order':'-createdAt'});}})[_0xd32e('0x23')](handleEntityNotFound(_0x4a30ee,null))[_0xd32e('0x23')](function(_0x6cfa4b){if(_0x6cfa4b){_0xde9205=_0x6cfa4b;var _0x4e36be={};for(var _0x1a6ded=0x0,_0x1a6b0e=_0xde9205[_0xd32e('0x33')];_0x1a6ded<_0x1a6b0e;_0x1a6ded++){if(!_0x4e36be['hasOwnProperty'](_0xde9205[_0x1a6ded][_0xd32e('0x5b')])){_0x4e36be[_0xde9205[_0x1a6ded]['questionId']]=needsEncapsulation(_0xde9205[_0x1a6ded][_0xd32e('0x5c')])?encapsulate(_0xde9205[_0x1a6ded][_0xd32e('0x5c')]):_0xde9205[_0x1a6ded][_0xd32e('0x5c')];}}var _0x2a99b9=[],_0x4210f3={};for(var _0x26c311=0x0,_0x538085=_0x5d174e['length'];_0x26c311<_0x538085;_0x26c311++){_0x4210f3={'ProjectId':_0x22dd1d[_0xd32e('0x4d')]['id'],'SessionId':_0x5d174e[_0x26c311]['id'],'StartTime':moment(_0x5d174e[_0x26c311][_0xd32e('0x5d')])[_0xd32e('0x5e')](_0xd32e('0x5f'))};for(var _0x57ccbe=0x0,_0x1514fd=_0xde9205[_0xd32e('0x33')];_0x57ccbe<_0x1514fd;_0x57ccbe++){if(_0xde9205[_0x57ccbe]['SessionId']==_0x5d174e[_0x26c311]['id']&&_0x4e36be[_0xd32e('0x34')](_0xde9205[_0x57ccbe]['questionId'])){_0x4210f3[_0x4e36be[_0xde9205[_0x57ccbe]['questionId']]]=_0xde9205[_0x57ccbe][_0xd32e('0x60')];}}for(var _0x50f396 in _0x4e36be){if(!_0x4210f3['hasOwnProperty'](_0x4e36be[_0x50f396])){_0x4210f3[_0x4e36be[_0x50f396]]=null;}}_0x2a99b9['push'](_0x4210f3);}return _0x2a99b9;}})[_0xd32e('0x23')](function(_0xec2c76){if(!_[_0xd32e('0x61')](_0xec2c76)){var _0x5bafdd=toCsv(_0xec2c76);var _0x44a903=Date[_0xd32e('0x62')]();fs[_0xd32e('0x63')](util[_0xd32e('0x5e')](_0xd32e('0x64'),_0x22dd1d['params']['id'],_0x44a903),_0x5bafdd);_0x4a30ee['setHeader'](_0xd32e('0x65'),'attachment;\x20filename='+util['format'](_0xd32e('0x66'),_0x22dd1d['params']['id'],_0x44a903));_0x4a30ee[_0xd32e('0x67')]('Content-type',_0xd32e('0x68'));return _0x4a30ee[_0xd32e('0x69')](util[_0xd32e('0x5e')](_0xd32e('0x64'),_0x22dd1d['params']['id'],_0x44a903));}else{return _0x4a30ee[_0xd32e('0x17')](0xcc);}})[_0xd32e('0x43')](handleError(_0x4a30ee,null));};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff