Built motion from commit bab6f49e.|2.6.17
[motion2.git] / server / api / jscriptySessionReport / jscriptySessionReport.controller.js
index a5e78bd..c3b296d 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0xe918=['json','count','offset','limit','Content-Range','apply','reject','save','update','then','destroy','error','name','index','map','JscriptySessionReport','rawAttributes','fieldName','type','key','query','keys','filters','model','attributes','fields','length','hasOwnProperty','order','sort','where','pick','filter','merge','VIRTUAL','includeAll','include','rows','catch','show','params','intersection','create','body','find','describe','JscriptyQuestionReport','nolimit','options','findAll','html-pdf','eml-format','fast-json-patch','request-promise','moment','util','path','sox','to-csv','ejs','lodash','squel','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','end','status'];(function(_0x300899,_0x9ad5b1){var _0x262dd0=function(_0x2597c5){while(--_0x2597c5){_0x300899['push'](_0x300899['shift']());}};_0x262dd0(++_0x9ad5b1);}(_0xe918,0x162));var _0x8e91=function(_0xfab439,_0x2a4f87){_0xfab439=_0xfab439-0x0;var _0x4dc112=_0xe918[_0xfab439];return _0x4dc112;};'use strict';var pdf=require(_0x8e91('0x0'));var emlformat=require(_0x8e91('0x1'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0x8e91('0x2'));var rp=require(_0x8e91('0x3'));var moment=require(_0x8e91('0x4'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0x8e91('0x5'));var path=require(_0x8e91('0x6'));var sox=require(_0x8e91('0x7'));var csv=require(_0x8e91('0x8'));var ejs=require(_0x8e91('0x9'));var fs=require('fs');var _=require(_0x8e91('0xa'));var squel=require(_0x8e91('0xb'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x8e91('0xc'));var toCsv=require(_0x8e91('0x8'));var querystring=require(_0x8e91('0xd'));var Papa=require(_0x8e91('0xe'));var Redis=require(_0x8e91('0xf'));var authService=require(_0x8e91('0x10'));var qs=require(_0x8e91('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require(_0x8e91('0x12'))(_0x8e91('0x13'));var utils=require(_0x8e91('0x14'));var config=require(_0x8e91('0x15'));var db=require(_0x8e91('0x16'))['db'];function respondWithStatusCode(_0x10690c,_0x54ff7f){_0x54ff7f=_0x54ff7f||0xcc;return function(_0x232a3c){if(_0x232a3c){return _0x10690c[_0x8e91('0x17')](_0x54ff7f);}return _0x10690c['status'](_0x54ff7f)[_0x8e91('0x18')]();};}function respondWithResult(_0xfdf99c,_0x5a15ce){_0x5a15ce=_0x5a15ce||0xc8;return function(_0x49c253){if(_0x49c253){return _0xfdf99c[_0x8e91('0x19')](_0x5a15ce)[_0x8e91('0x1a')](_0x49c253);}};}function respondWithFilteredResult(_0xa58188,_0x585074){return function(_0x4a1f80){if(_0x4a1f80){var _0x517960=_0x4a1f80[_0x8e91('0x1b')],_0x5b0bd7=_0x585074[_0x8e91('0x1c')],_0x3e26f1=_0x585074['offset']+_0x585074[_0x8e91('0x1d')],_0xc05237;if(_0x3e26f1>=_0x517960){_0x3e26f1=_0x517960;_0xc05237=0xc8;}else{_0xc05237=0xce;}_0xa58188[_0x8e91('0x19')](_0xc05237);return _0xa58188['set'](_0x8e91('0x1e'),_0x5b0bd7+'-'+_0x3e26f1+'/'+_0x517960)['json'](_0x4a1f80);}return null;};}function patchUpdates(_0x4c3caa){return function(_0x321b12){try{jsonpatch[_0x8e91('0x1f')](_0x321b12,_0x4c3caa,!![]);}catch(_0x36854a){return BPromise[_0x8e91('0x20')](_0x36854a);}return _0x321b12[_0x8e91('0x21')]();};}function saveUpdates(_0x242f75,_0x372cc1){return function(_0x2c105a){if(_0x2c105a){return _0x2c105a[_0x8e91('0x22')](_0x242f75)[_0x8e91('0x23')](function(_0x544889){return _0x544889;});}return null;};}function removeEntity(_0x16a9e8,_0x875441){return function(_0x5e5253){if(_0x5e5253){return _0x5e5253[_0x8e91('0x24')]()[_0x8e91('0x23')](function(){_0x16a9e8['status'](0xcc)[_0x8e91('0x18')]();});}};}function handleEntityNotFound(_0x304f7c,_0x2d1e8c){return function(_0x3a9f99){if(!_0x3a9f99){_0x304f7c[_0x8e91('0x17')](0x194);}return _0x3a9f99;};}function handleError(_0x5a7c0d,_0x438e57){_0x438e57=_0x438e57||0x1f4;return function(_0x5a064e){logger[_0x8e91('0x25')](_0x5a064e['stack']);if(_0x5a064e[_0x8e91('0x26')]){delete _0x5a064e[_0x8e91('0x26')];}_0x5a7c0d[_0x8e91('0x19')](_0x438e57)['send'](_0x5a064e);};}exports[_0x8e91('0x27')]=function(_0x4175a0,_0x58a814){var _0x338fbb={},_0x31f5ab={},_0x24fc3a={'count':0x0,'rows':[]};var _0x1fb669=_[_0x8e91('0x28')](db[_0x8e91('0x29')][_0x8e91('0x2a')],function(_0x955854){return{'name':_0x955854[_0x8e91('0x2b')],'type':_0x955854[_0x8e91('0x2c')][_0x8e91('0x2d')]};});_0x31f5ab['model']=_[_0x8e91('0x28')](_0x1fb669,'name');_0x31f5ab[_0x8e91('0x2e')]=_[_0x8e91('0x2f')](_0x4175a0[_0x8e91('0x2e')]);_0x31f5ab[_0x8e91('0x30')]=_['intersection'](_0x31f5ab[_0x8e91('0x31')],_0x31f5ab[_0x8e91('0x2e')]);_0x338fbb[_0x8e91('0x32')]=_['intersection'](_0x31f5ab[_0x8e91('0x31')],qs[_0x8e91('0x33')](_0x4175a0[_0x8e91('0x2e')][_0x8e91('0x33')]));_0x338fbb[_0x8e91('0x32')]=_0x338fbb[_0x8e91('0x32')][_0x8e91('0x34')]?_0x338fbb[_0x8e91('0x32')]:_0x31f5ab[_0x8e91('0x31')];if(!_0x4175a0['query'][_0x8e91('0x35')]('nolimit')){_0x338fbb[_0x8e91('0x1d')]=qs['limit'](_0x4175a0[_0x8e91('0x2e')]['limit']);_0x338fbb['offset']=qs[_0x8e91('0x1c')](_0x4175a0[_0x8e91('0x2e')][_0x8e91('0x1c')]);}_0x338fbb[_0x8e91('0x36')]=qs[_0x8e91('0x37')](_0x4175a0['query'][_0x8e91('0x37')]);_0x338fbb[_0x8e91('0x38')]=qs[_0x8e91('0x30')](_[_0x8e91('0x39')](_0x4175a0[_0x8e91('0x2e')],_0x31f5ab[_0x8e91('0x30')]));if(_0x4175a0[_0x8e91('0x2e')][_0x8e91('0x3a')]){_0x338fbb[_0x8e91('0x38')]=_[_0x8e91('0x3b')](_0x338fbb[_0x8e91('0x38')],{'$or':_[_0x8e91('0x28')](_0x1fb669,function(_0x1cf4e9){if(_0x1cf4e9[_0x8e91('0x2c')]!==_0x8e91('0x3c')){var _0x400d4b={};_0x400d4b[_0x1cf4e9[_0x8e91('0x26')]]={'$like':'%'+_0x4175a0['query'][_0x8e91('0x3a')]+'%'};return _0x400d4b;}})});}_0x338fbb=_[_0x8e91('0x3b')]({},_0x338fbb,_0x4175a0['options']);var _0x4a1771={'where':_0x338fbb[_0x8e91('0x38')]};return db['JscriptySessionReport']['count'](_0x4a1771)[_0x8e91('0x23')](function(_0x4ae6c1){_0x24fc3a[_0x8e91('0x1b')]=_0x4ae6c1;if(_0x4175a0[_0x8e91('0x2e')][_0x8e91('0x3d')]){_0x338fbb[_0x8e91('0x3e')]=[{'all':!![]}];}return db[_0x8e91('0x29')]['findAll'](_0x338fbb);})[_0x8e91('0x23')](function(_0x3278a){_0x24fc3a[_0x8e91('0x3f')]=_0x3278a;return _0x24fc3a;})[_0x8e91('0x23')](respondWithFilteredResult(_0x58a814,_0x338fbb))[_0x8e91('0x40')](handleError(_0x58a814,null));};exports[_0x8e91('0x41')]=function(_0x13f41d,_0xb43ffe){var _0x4ed135={'raw':!![],'where':{'id':_0x13f41d[_0x8e91('0x42')]['id']}},_0x328bbe={};_0x328bbe[_0x8e91('0x31')]=_[_0x8e91('0x2f')](db['JscriptySessionReport']['rawAttributes']);_0x328bbe[_0x8e91('0x2e')]=_[_0x8e91('0x2f')](_0x13f41d[_0x8e91('0x2e')]);_0x328bbe['filters']=_['intersection'](_0x328bbe[_0x8e91('0x31')],_0x328bbe['query']);_0x4ed135[_0x8e91('0x32')]=_[_0x8e91('0x43')](_0x328bbe[_0x8e91('0x31')],qs['fields'](_0x13f41d[_0x8e91('0x2e')][_0x8e91('0x33')]));_0x4ed135[_0x8e91('0x32')]=_0x4ed135[_0x8e91('0x32')]['length']?_0x4ed135[_0x8e91('0x32')]:_0x328bbe[_0x8e91('0x31')];if(_0x13f41d[_0x8e91('0x2e')][_0x8e91('0x3d')]){_0x4ed135[_0x8e91('0x3e')]=[{'all':!![]}];}_0x4ed135=_[_0x8e91('0x3b')]({},_0x4ed135,_0x13f41d['options']);return db[_0x8e91('0x29')]['find'](_0x4ed135)[_0x8e91('0x23')](handleEntityNotFound(_0xb43ffe,null))[_0x8e91('0x23')](respondWithResult(_0xb43ffe,null))['catch'](handleError(_0xb43ffe,null));};exports[_0x8e91('0x44')]=function(_0x2b0da9,_0x187c7a){return db[_0x8e91('0x29')][_0x8e91('0x44')](_0x2b0da9[_0x8e91('0x45')],{})['then'](respondWithResult(_0x187c7a,0xc9))[_0x8e91('0x40')](handleError(_0x187c7a,null));};exports['update']=function(_0x375d11,_0x4f7937){if(_0x375d11[_0x8e91('0x45')]['id']){delete _0x375d11[_0x8e91('0x45')]['id'];}return db[_0x8e91('0x29')][_0x8e91('0x46')]({'where':{'id':_0x375d11[_0x8e91('0x42')]['id']}})['then'](handleEntityNotFound(_0x4f7937,null))[_0x8e91('0x23')](saveUpdates(_0x375d11['body'],null))[_0x8e91('0x23')](respondWithResult(_0x4f7937,null))[_0x8e91('0x40')](handleError(_0x4f7937,null));};exports[_0x8e91('0x24')]=function(_0x6da270,_0x575a43){return db['JscriptySessionReport'][_0x8e91('0x46')]({'where':{'id':_0x6da270[_0x8e91('0x42')]['id']}})[_0x8e91('0x23')](handleEntityNotFound(_0x575a43,null))[_0x8e91('0x23')](removeEntity(_0x575a43,null))[_0x8e91('0x40')](handleError(_0x575a43,null));};exports[_0x8e91('0x47')]=function(_0x2b4fa3,_0xb11f77){return db[_0x8e91('0x29')]['describe']()[_0x8e91('0x23')](respondWithResult(_0xb11f77,null))[_0x8e91('0x40')](handleError(_0xb11f77,null));};exports['getQuestions']=function(_0x5c87a7,_0x27889f,_0x2b1b65){var _0x10a152={'raw':!![],'where':{}};var _0x34a937={};var _0x565ee4={'count':0x0,'rows':[]};return db[_0x8e91('0x29')]['findOne']({'where':{'id':_0x5c87a7[_0x8e91('0x42')]['id']}})[_0x8e91('0x23')](handleEntityNotFound(_0x27889f,null))[_0x8e91('0x23')](function(_0x4f9adf){if(_0x4f9adf){_0x34a937[_0x8e91('0x31')]=_[_0x8e91('0x2f')](db[_0x8e91('0x48')][_0x8e91('0x2a')]);_0x34a937['query']=_[_0x8e91('0x2f')](_0x5c87a7[_0x8e91('0x2e')]);_0x34a937['filters']=_[_0x8e91('0x43')](_0x34a937[_0x8e91('0x31')],_0x34a937[_0x8e91('0x2e')]);_0x10a152['attributes']=_[_0x8e91('0x43')](_0x34a937[_0x8e91('0x31')],qs[_0x8e91('0x33')](_0x5c87a7['query'][_0x8e91('0x33')]));_0x10a152['attributes']=_0x10a152['attributes'][_0x8e91('0x34')]?_0x10a152[_0x8e91('0x32')]:_0x34a937[_0x8e91('0x31')];if(!_0x5c87a7[_0x8e91('0x2e')][_0x8e91('0x35')](_0x8e91('0x49'))){_0x10a152[_0x8e91('0x1d')]=qs['limit'](_0x5c87a7[_0x8e91('0x2e')][_0x8e91('0x1d')]);_0x10a152[_0x8e91('0x1c')]=qs[_0x8e91('0x1c')](_0x5c87a7['query'][_0x8e91('0x1c')]);}_0x10a152['order']=qs[_0x8e91('0x37')](_0x5c87a7[_0x8e91('0x2e')][_0x8e91('0x37')]);_0x10a152[_0x8e91('0x38')]=qs[_0x8e91('0x30')](_[_0x8e91('0x39')](_0x5c87a7[_0x8e91('0x2e')],_0x34a937[_0x8e91('0x30')]));_0x10a152[_0x8e91('0x38')]['SessionId']=_0x4f9adf['id'];if(_0x5c87a7[_0x8e91('0x2e')][_0x8e91('0x3a')]){_0x10a152['where']=_[_0x8e91('0x3b')](_0x10a152[_0x8e91('0x38')],{'$or':_[_0x8e91('0x28')](_0x10a152[_0x8e91('0x32')],function(_0x26a06){var _0x8f84c={};_0x8f84c[_0x26a06]={'$like':'%'+_0x5c87a7[_0x8e91('0x2e')][_0x8e91('0x3a')]+'%'};return _0x8f84c;})});}_0x10a152=_[_0x8e91('0x3b')]({},_0x10a152,_0x5c87a7[_0x8e91('0x4a')]);return db[_0x8e91('0x48')][_0x8e91('0x1b')]({'where':_0x10a152[_0x8e91('0x38')]})['then'](function(_0x1fb64d){_0x565ee4[_0x8e91('0x1b')]=_0x1fb64d;if(_0x5c87a7[_0x8e91('0x2e')][_0x8e91('0x3d')]){_0x10a152[_0x8e91('0x3e')]=[{'all':!![]}];}return db[_0x8e91('0x48')][_0x8e91('0x4b')](_0x10a152);})[_0x8e91('0x23')](function(_0x570af8){_0x565ee4[_0x8e91('0x3f')]=_0x570af8;return _0x565ee4;});}})[_0x8e91('0x23')](respondWithFilteredResult(_0x27889f,_0x10a152))['catch'](handleError(_0x27889f,null));};
\ No newline at end of file
+var _0x04dd=['json','undefined','limit','count','offset','status','Content-Range','apply','reject','save','then','error','stack','name','index','map','rawAttributes','fieldName','type','key','model','keys','query','filters','attributes','fields','length','hasOwnProperty','nolimit','sort','where','pick','filter','VIRTUAL','merge','JscriptySessionReport','include','findAll','rows','show','intersection','includeAll','options','find','create','catch','update','body','params','describe','getQuestions','findOne','JscriptyQuestionReport','order','SessionId','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','ejs','lodash','squel','crypto','jsforce','desk.js','to-csv','querystring','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end'];(function(_0x40c99a,_0x56f60e){var _0x3d1d0a=function(_0xc203fd){while(--_0xc203fd){_0x40c99a['push'](_0x40c99a['shift']());}};_0x3d1d0a(++_0x56f60e);}(_0x04dd,0x1db));var _0xd04d=function(_0x2881e2,_0x341293){_0x2881e2=_0x2881e2-0x0;var _0x5c1e1f=_0x04dd[_0x2881e2];return _0x5c1e1f;};'use strict';var emlformat=require(_0xd04d('0x0'));var rimraf=require(_0xd04d('0x1'));var zipdir=require(_0xd04d('0x2'));var jsonpatch=require(_0xd04d('0x3'));var rp=require('request-promise');var moment=require(_0xd04d('0x4'));var BPromise=require(_0xd04d('0x5'));var Mustache=require(_0xd04d('0x6'));var util=require(_0xd04d('0x7'));var path=require(_0xd04d('0x8'));var sox=require(_0xd04d('0x9'));var csv=require('to-csv');var ejs=require(_0xd04d('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xd04d('0xb'));var squel=require(_0xd04d('0xc'));var crypto=require(_0xd04d('0xd'));var jsforce=require(_0xd04d('0xe'));var deskjs=require(_0xd04d('0xf'));var toCsv=require(_0xd04d('0x10'));var querystring=require(_0xd04d('0x11'));var Papa=require('papaparse');var Redis=require(_0xd04d('0x12'));var authService=require('../../components/auth/service');var qs=require(_0xd04d('0x13'));var as=require(_0xd04d('0x14'));var hardwareService=require(_0xd04d('0x15'));var logger=require(_0xd04d('0x16'))('api');var utils=require(_0xd04d('0x17'));var config=require(_0xd04d('0x18'));var licenseUtil=require(_0xd04d('0x19'));var db=require(_0xd04d('0x1a'))['db'];function respondWithStatusCode(_0x3d8501,_0x6159cf){_0x6159cf=_0x6159cf||0xcc;return function(_0x18f827){if(_0x18f827){return _0x3d8501[_0xd04d('0x1b')](_0x6159cf);}return _0x3d8501['status'](_0x6159cf)[_0xd04d('0x1c')]();};}function respondWithResult(_0x541654,_0x86f35c){_0x86f35c=_0x86f35c||0xc8;return function(_0x593f08){if(_0x593f08){return _0x541654['status'](_0x86f35c)[_0xd04d('0x1d')](_0x593f08);}};}function respondWithFilteredResult(_0x24a366,_0x4720fe){return function(_0x4624b8){if(_0x4624b8){var _0x4c1c4e=typeof _0x4720fe['offset']===_0xd04d('0x1e')&&typeof _0x4720fe[_0xd04d('0x1f')]==='undefined';var _0x501226=_0x4624b8['count'];var _0x5cbeca=_0x4c1c4e?0x0:_0x4720fe['offset'];var _0x5f3a26=_0x4c1c4e?_0x4624b8[_0xd04d('0x20')]:_0x4720fe[_0xd04d('0x21')]+_0x4720fe[_0xd04d('0x1f')];var _0x4d6d26;if(_0x5f3a26>=_0x501226){_0x5f3a26=_0x501226;_0x4d6d26=0xc8;}else{_0x4d6d26=0xce;}_0x24a366[_0xd04d('0x22')](_0x4d6d26);return _0x24a366['set'](_0xd04d('0x23'),_0x5cbeca+'-'+_0x5f3a26+'/'+_0x501226)['json'](_0x4624b8);}return null;};}function patchUpdates(_0x40fa23){return function(_0x115fd9){try{jsonpatch[_0xd04d('0x24')](_0x115fd9,_0x40fa23,!![]);}catch(_0x2e3306){return BPromise[_0xd04d('0x25')](_0x2e3306);}return _0x115fd9[_0xd04d('0x26')]();};}function saveUpdates(_0x412bc1,_0x47bae5){return function(_0x6a6de8){if(_0x6a6de8){return _0x6a6de8['update'](_0x412bc1)[_0xd04d('0x27')](function(_0x2e18ca){return _0x2e18ca;});}return null;};}function removeEntity(_0x422023,_0x575178){return function(_0x377294){if(_0x377294){return _0x377294['destroy']()[_0xd04d('0x27')](function(){_0x422023[_0xd04d('0x22')](0xcc)[_0xd04d('0x1c')]();});}};}function handleEntityNotFound(_0x20284f,_0x428de2){return function(_0x3e6e72){if(!_0x3e6e72){_0x20284f[_0xd04d('0x1b')](0x194);}return _0x3e6e72;};}function handleError(_0x45bd17,_0x2d764e){_0x2d764e=_0x2d764e||0x1f4;return function(_0x405605){logger[_0xd04d('0x28')](_0x405605[_0xd04d('0x29')]);if(_0x405605[_0xd04d('0x2a')]){delete _0x405605[_0xd04d('0x2a')];}_0x45bd17[_0xd04d('0x22')](_0x2d764e)['send'](_0x405605);};}exports[_0xd04d('0x2b')]=function(_0x1a98b1,_0x482063){var _0x449c5a={},_0x1a59a9={},_0x574979={'count':0x0,'rows':[]};var _0x576943=_[_0xd04d('0x2c')](db['JscriptySessionReport'][_0xd04d('0x2d')],function(_0x4a5215){return{'name':_0x4a5215[_0xd04d('0x2e')],'type':_0x4a5215[_0xd04d('0x2f')][_0xd04d('0x30')]};});_0x1a59a9[_0xd04d('0x31')]=_['map'](_0x576943,_0xd04d('0x2a'));_0x1a59a9['query']=_[_0xd04d('0x32')](_0x1a98b1[_0xd04d('0x33')]);_0x1a59a9[_0xd04d('0x34')]=_['intersection'](_0x1a59a9['model'],_0x1a59a9[_0xd04d('0x33')]);_0x449c5a[_0xd04d('0x35')]=_['intersection'](_0x1a59a9[_0xd04d('0x31')],qs[_0xd04d('0x36')](_0x1a98b1[_0xd04d('0x33')]['fields']));_0x449c5a[_0xd04d('0x35')]=_0x449c5a[_0xd04d('0x35')][_0xd04d('0x37')]?_0x449c5a[_0xd04d('0x35')]:_0x1a59a9[_0xd04d('0x31')];if(!_0x1a98b1[_0xd04d('0x33')][_0xd04d('0x38')](_0xd04d('0x39'))){_0x449c5a[_0xd04d('0x1f')]=qs['limit'](_0x1a98b1[_0xd04d('0x33')]['limit']);_0x449c5a[_0xd04d('0x21')]=qs['offset'](_0x1a98b1[_0xd04d('0x33')]['offset']);}_0x449c5a['order']=qs[_0xd04d('0x3a')](_0x1a98b1[_0xd04d('0x33')][_0xd04d('0x3a')]);_0x449c5a[_0xd04d('0x3b')]=qs[_0xd04d('0x34')](_[_0xd04d('0x3c')](_0x1a98b1[_0xd04d('0x33')],_0x1a59a9['filters']),_0x576943);if(_0x1a98b1[_0xd04d('0x33')][_0xd04d('0x3d')]){_0x449c5a[_0xd04d('0x3b')]=_['merge'](_0x449c5a[_0xd04d('0x3b')],{'$or':_[_0xd04d('0x2c')](_0x576943,function(_0x47d0d1){if(_0x47d0d1['type']!==_0xd04d('0x3e')){var _0x590de8={};_0x590de8[_0x47d0d1[_0xd04d('0x2a')]]={'$like':'%'+_0x1a98b1['query'][_0xd04d('0x3d')]+'%'};return _0x590de8;}})});}_0x449c5a=_[_0xd04d('0x3f')]({},_0x449c5a,_0x1a98b1['options']);var _0x177c38={'where':_0x449c5a[_0xd04d('0x3b')]};return db[_0xd04d('0x40')][_0xd04d('0x20')](_0x177c38)[_0xd04d('0x27')](function(_0x3ba382){_0x574979['count']=_0x3ba382;if(_0x1a98b1['query']['includeAll']){_0x449c5a[_0xd04d('0x41')]=[{'all':!![]}];}return db[_0xd04d('0x40')][_0xd04d('0x42')](_0x449c5a);})['then'](function(_0x4d1c23){_0x574979[_0xd04d('0x43')]=_0x4d1c23;return _0x574979;})[_0xd04d('0x27')](respondWithFilteredResult(_0x482063,_0x449c5a))['catch'](handleError(_0x482063,null));};exports[_0xd04d('0x44')]=function(_0x5d8f76,_0x45947a){var _0x3c6f43={'raw':!![],'where':{'id':_0x5d8f76['params']['id']}},_0x1cf1fd={};_0x1cf1fd['model']=_[_0xd04d('0x32')](db['JscriptySessionReport'][_0xd04d('0x2d')]);_0x1cf1fd['query']=_[_0xd04d('0x32')](_0x5d8f76[_0xd04d('0x33')]);_0x1cf1fd[_0xd04d('0x34')]=_[_0xd04d('0x45')](_0x1cf1fd['model'],_0x1cf1fd[_0xd04d('0x33')]);_0x3c6f43[_0xd04d('0x35')]=_[_0xd04d('0x45')](_0x1cf1fd[_0xd04d('0x31')],qs[_0xd04d('0x36')](_0x5d8f76['query'][_0xd04d('0x36')]));_0x3c6f43[_0xd04d('0x35')]=_0x3c6f43['attributes'][_0xd04d('0x37')]?_0x3c6f43[_0xd04d('0x35')]:_0x1cf1fd['model'];if(_0x5d8f76['query'][_0xd04d('0x46')]){_0x3c6f43[_0xd04d('0x41')]=[{'all':!![]}];}_0x3c6f43=_[_0xd04d('0x3f')]({},_0x3c6f43,_0x5d8f76[_0xd04d('0x47')]);return db[_0xd04d('0x40')][_0xd04d('0x48')](_0x3c6f43)[_0xd04d('0x27')](handleEntityNotFound(_0x45947a,null))['then'](respondWithResult(_0x45947a,null))['catch'](handleError(_0x45947a,null));};exports[_0xd04d('0x49')]=function(_0x58021f,_0x134af6){return db[_0xd04d('0x40')][_0xd04d('0x49')](_0x58021f['body'],{})[_0xd04d('0x27')](respondWithResult(_0x134af6,0xc9))[_0xd04d('0x4a')](handleError(_0x134af6,null));};exports[_0xd04d('0x4b')]=function(_0x2e54eb,_0x228c80){if(_0x2e54eb[_0xd04d('0x4c')]['id']){delete _0x2e54eb[_0xd04d('0x4c')]['id'];}return db[_0xd04d('0x40')][_0xd04d('0x48')]({'where':{'id':_0x2e54eb[_0xd04d('0x4d')]['id']}})[_0xd04d('0x27')](handleEntityNotFound(_0x228c80,null))['then'](saveUpdates(_0x2e54eb[_0xd04d('0x4c')],null))[_0xd04d('0x27')](respondWithResult(_0x228c80,null))['catch'](handleError(_0x228c80,null));};exports['destroy']=function(_0xf708be,_0x37306e){return db[_0xd04d('0x40')][_0xd04d('0x48')]({'where':{'id':_0xf708be[_0xd04d('0x4d')]['id']}})['then'](handleEntityNotFound(_0x37306e,null))[_0xd04d('0x27')](removeEntity(_0x37306e,null))[_0xd04d('0x4a')](handleError(_0x37306e,null));};exports[_0xd04d('0x4e')]=function(_0x4ff588,_0x547d05){return db[_0xd04d('0x40')][_0xd04d('0x4e')]()['then'](respondWithResult(_0x547d05,null))[_0xd04d('0x4a')](handleError(_0x547d05,null));};exports[_0xd04d('0x4f')]=function(_0x565360,_0x52ce26,_0x2d13ed){var _0x54cb36={'raw':!![],'where':{}};var _0x38d23a={};var _0x1b811e={'count':0x0,'rows':[]};return db[_0xd04d('0x40')][_0xd04d('0x50')]({'where':{'id':_0x565360[_0xd04d('0x4d')]['id']}})[_0xd04d('0x27')](handleEntityNotFound(_0x52ce26,null))[_0xd04d('0x27')](function(_0x34cbc2){if(_0x34cbc2){_0x38d23a[_0xd04d('0x31')]=_[_0xd04d('0x32')](db[_0xd04d('0x51')][_0xd04d('0x2d')]);_0x38d23a['query']=_[_0xd04d('0x32')](_0x565360['query']);_0x38d23a[_0xd04d('0x34')]=_[_0xd04d('0x45')](_0x38d23a[_0xd04d('0x31')],_0x38d23a[_0xd04d('0x33')]);_0x54cb36[_0xd04d('0x35')]=_['intersection'](_0x38d23a[_0xd04d('0x31')],qs[_0xd04d('0x36')](_0x565360[_0xd04d('0x33')][_0xd04d('0x36')]));_0x54cb36[_0xd04d('0x35')]=_0x54cb36['attributes']['length']?_0x54cb36['attributes']:_0x38d23a['model'];if(!_0x565360[_0xd04d('0x33')][_0xd04d('0x38')]('nolimit')){_0x54cb36[_0xd04d('0x1f')]=qs[_0xd04d('0x1f')](_0x565360[_0xd04d('0x33')][_0xd04d('0x1f')]);_0x54cb36[_0xd04d('0x21')]=qs['offset'](_0x565360[_0xd04d('0x33')]['offset']);}_0x54cb36[_0xd04d('0x52')]=qs[_0xd04d('0x3a')](_0x565360[_0xd04d('0x33')][_0xd04d('0x3a')]);_0x54cb36[_0xd04d('0x3b')]=qs[_0xd04d('0x34')](_['pick'](_0x565360['query'],_0x38d23a['filters']));_0x54cb36['where'][_0xd04d('0x53')]=_0x34cbc2['id'];if(_0x565360[_0xd04d('0x33')]['filter']){_0x54cb36[_0xd04d('0x3b')]=_[_0xd04d('0x3f')](_0x54cb36[_0xd04d('0x3b')],{'$or':_[_0xd04d('0x2c')](_0x54cb36[_0xd04d('0x35')],function(_0xb2dfe2){var _0xfafccc={};_0xfafccc[_0xb2dfe2]={'$like':'%'+_0x565360[_0xd04d('0x33')][_0xd04d('0x3d')]+'%'};return _0xfafccc;})});}_0x54cb36=_[_0xd04d('0x3f')]({},_0x54cb36,_0x565360[_0xd04d('0x47')]);return db['JscriptyQuestionReport'][_0xd04d('0x20')]({'where':_0x54cb36['where']})[_0xd04d('0x27')](function(_0x4adc23){_0x1b811e[_0xd04d('0x20')]=_0x4adc23;if(_0x565360[_0xd04d('0x33')]['includeAll']){_0x54cb36[_0xd04d('0x41')]=[{'all':!![]}];}return db[_0xd04d('0x51')][_0xd04d('0x42')](_0x54cb36);})[_0xd04d('0x27')](function(_0x6f4c65){_0x1b811e['rows']=_0x6f4c65;return _0x1b811e;});}})[_0xd04d('0x27')](respondWithFilteredResult(_0x52ce26,_0x54cb36))[_0xd04d('0x4a')](handleError(_0x52ce26,null));};
\ No newline at end of file