Built motion from commit ab870f9e.|2.5.44
[motion2.git] / server / api / jscriptySessionReport / jscriptySessionReport.controller.js
index 9b2d1e0..4baf11b 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0xafd7=['includeAll','include','findAll','show','params','find','catch','create','body','describe','getQuestions','JscriptyQuestionReport','nolimit','SessionId','rows','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','crypto','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','json','offset','undefined','limit','count','set','Content-Range','reject','save','update','destroy','then','stack','name','send','index','map','JscriptySessionReport','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','order','sort','where','pick','VIRTUAL','filter','merge','options'];(function(_0x1ff575,_0xdba21f){var _0x48fc9e=function(_0x51cf97){while(--_0x51cf97){_0x1ff575['push'](_0x1ff575['shift']());}};_0x48fc9e(++_0xdba21f);}(_0xafd7,0xb7));var _0x7afd=function(_0x321bb2,_0x202794){_0x321bb2=_0x321bb2-0x0;var _0x9c12ed=_0xafd7[_0x321bb2];return _0x9c12ed;};'use strict';var emlformat=require(_0x7afd('0x0'));var rimraf=require(_0x7afd('0x1'));var zipdir=require(_0x7afd('0x2'));var jsonpatch=require(_0x7afd('0x3'));var rp=require(_0x7afd('0x4'));var moment=require(_0x7afd('0x5'));var BPromise=require(_0x7afd('0x6'));var Mustache=require(_0x7afd('0x7'));var util=require(_0x7afd('0x8'));var path=require(_0x7afd('0x9'));var sox=require(_0x7afd('0xa'));var csv=require(_0x7afd('0xb'));var ejs=require(_0x7afd('0xc'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x7afd('0xd'));var squel=require('squel');var crypto=require(_0x7afd('0xe'));var jsforce=require('jsforce');var deskjs=require(_0x7afd('0xf'));var toCsv=require(_0x7afd('0xb'));var querystring=require('querystring');var Papa=require(_0x7afd('0x10'));var Redis=require(_0x7afd('0x11'));var authService=require(_0x7afd('0x12'));var qs=require(_0x7afd('0x13'));var as=require(_0x7afd('0x14'));var hardwareService=require(_0x7afd('0x15'));var logger=require(_0x7afd('0x16'))(_0x7afd('0x17'));var utils=require(_0x7afd('0x18'));var config=require(_0x7afd('0x19'));var licenseUtil=require(_0x7afd('0x1a'));var db=require(_0x7afd('0x1b'))['db'];function respondWithStatusCode(_0x3fe4da,_0x1ee0b3){_0x1ee0b3=_0x1ee0b3||0xcc;return function(_0x491063){if(_0x491063){return _0x3fe4da[_0x7afd('0x1c')](_0x1ee0b3);}return _0x3fe4da[_0x7afd('0x1d')](_0x1ee0b3)['end']();};}function respondWithResult(_0x26c507,_0x2fabda){_0x2fabda=_0x2fabda||0xc8;return function(_0x267ce7){if(_0x267ce7){return _0x26c507[_0x7afd('0x1d')](_0x2fabda)[_0x7afd('0x1e')](_0x267ce7);}};}function respondWithFilteredResult(_0x230993,_0x29c611){return function(_0x402bcd){if(_0x402bcd){var _0x3a8109=typeof _0x29c611[_0x7afd('0x1f')]===_0x7afd('0x20')&&typeof _0x29c611[_0x7afd('0x21')]==='undefined';var _0x14449c=_0x402bcd[_0x7afd('0x22')];var _0x365681=_0x3a8109?0x0:_0x29c611[_0x7afd('0x1f')];var _0x1da754=_0x3a8109?_0x402bcd[_0x7afd('0x22')]:_0x29c611[_0x7afd('0x1f')]+_0x29c611[_0x7afd('0x21')];var _0xd29df4;if(_0x1da754>=_0x14449c){_0x1da754=_0x14449c;_0xd29df4=0xc8;}else{_0xd29df4=0xce;}_0x230993[_0x7afd('0x1d')](_0xd29df4);return _0x230993[_0x7afd('0x23')](_0x7afd('0x24'),_0x365681+'-'+_0x1da754+'/'+_0x14449c)[_0x7afd('0x1e')](_0x402bcd);}return null;};}function patchUpdates(_0x233dbb){return function(_0x3f1bc5){try{jsonpatch['apply'](_0x3f1bc5,_0x233dbb,!![]);}catch(_0x5cf8ea){return BPromise[_0x7afd('0x25')](_0x5cf8ea);}return _0x3f1bc5[_0x7afd('0x26')]();};}function saveUpdates(_0x15295d,_0x33a61c){return function(_0x23486d){if(_0x23486d){return _0x23486d[_0x7afd('0x27')](_0x15295d)['then'](function(_0x776b67){return _0x776b67;});}return null;};}function removeEntity(_0x330d53,_0x29721f){return function(_0x48f364){if(_0x48f364){return _0x48f364[_0x7afd('0x28')]()[_0x7afd('0x29')](function(){_0x330d53[_0x7afd('0x1d')](0xcc)['end']();});}};}function handleEntityNotFound(_0x5a0ec3,_0x1df67d){return function(_0x41d318){if(!_0x41d318){_0x5a0ec3[_0x7afd('0x1c')](0x194);}return _0x41d318;};}function handleError(_0x2733f1,_0x4ad37d){_0x4ad37d=_0x4ad37d||0x1f4;return function(_0x5eba7f){logger['error'](_0x5eba7f[_0x7afd('0x2a')]);if(_0x5eba7f['name']){delete _0x5eba7f[_0x7afd('0x2b')];}_0x2733f1[_0x7afd('0x1d')](_0x4ad37d)[_0x7afd('0x2c')](_0x5eba7f);};}exports[_0x7afd('0x2d')]=function(_0x53a031,_0x41ecc4){var _0x1cab19={},_0xa748ff={},_0x3a8ad4={'count':0x0,'rows':[]};var _0x364958=_[_0x7afd('0x2e')](db[_0x7afd('0x2f')][_0x7afd('0x30')],function(_0x5d7b4b){return{'name':_0x5d7b4b[_0x7afd('0x31')],'type':_0x5d7b4b[_0x7afd('0x32')][_0x7afd('0x33')]};});_0xa748ff[_0x7afd('0x34')]=_[_0x7afd('0x2e')](_0x364958,_0x7afd('0x2b'));_0xa748ff[_0x7afd('0x35')]=_[_0x7afd('0x36')](_0x53a031[_0x7afd('0x35')]);_0xa748ff[_0x7afd('0x37')]=_[_0x7afd('0x38')](_0xa748ff['model'],_0xa748ff[_0x7afd('0x35')]);_0x1cab19[_0x7afd('0x39')]=_[_0x7afd('0x38')](_0xa748ff['model'],qs[_0x7afd('0x3a')](_0x53a031[_0x7afd('0x35')][_0x7afd('0x3a')]));_0x1cab19[_0x7afd('0x39')]=_0x1cab19[_0x7afd('0x39')][_0x7afd('0x3b')]?_0x1cab19[_0x7afd('0x39')]:_0xa748ff[_0x7afd('0x34')];if(!_0x53a031[_0x7afd('0x35')][_0x7afd('0x3c')]('nolimit')){_0x1cab19[_0x7afd('0x21')]=qs[_0x7afd('0x21')](_0x53a031[_0x7afd('0x35')][_0x7afd('0x21')]);_0x1cab19[_0x7afd('0x1f')]=qs[_0x7afd('0x1f')](_0x53a031['query'][_0x7afd('0x1f')]);}_0x1cab19[_0x7afd('0x3d')]=qs[_0x7afd('0x3e')](_0x53a031['query'][_0x7afd('0x3e')]);_0x1cab19[_0x7afd('0x3f')]=qs[_0x7afd('0x37')](_[_0x7afd('0x40')](_0x53a031[_0x7afd('0x35')],_0xa748ff[_0x7afd('0x37')]),_0x364958);if(_0x53a031[_0x7afd('0x35')]['filter']){_0x1cab19[_0x7afd('0x3f')]=_['merge'](_0x1cab19['where'],{'$or':_[_0x7afd('0x2e')](_0x364958,function(_0x52723f){if(_0x52723f[_0x7afd('0x32')]!==_0x7afd('0x41')){var _0x20cc43={};_0x20cc43[_0x52723f[_0x7afd('0x2b')]]={'$like':'%'+_0x53a031[_0x7afd('0x35')][_0x7afd('0x42')]+'%'};return _0x20cc43;}})});}_0x1cab19=_[_0x7afd('0x43')]({},_0x1cab19,_0x53a031[_0x7afd('0x44')]);var _0x161260={'where':_0x1cab19[_0x7afd('0x3f')]};return db[_0x7afd('0x2f')][_0x7afd('0x22')](_0x161260)['then'](function(_0x287de3){_0x3a8ad4['count']=_0x287de3;if(_0x53a031[_0x7afd('0x35')][_0x7afd('0x45')]){_0x1cab19[_0x7afd('0x46')]=[{'all':!![]}];}return db[_0x7afd('0x2f')][_0x7afd('0x47')](_0x1cab19);})[_0x7afd('0x29')](function(_0x344946){_0x3a8ad4['rows']=_0x344946;return _0x3a8ad4;})[_0x7afd('0x29')](respondWithFilteredResult(_0x41ecc4,_0x1cab19))['catch'](handleError(_0x41ecc4,null));};exports[_0x7afd('0x48')]=function(_0x31ec36,_0x37495){var _0x4f8062={'raw':!![],'where':{'id':_0x31ec36[_0x7afd('0x49')]['id']}},_0x499cf7={};_0x499cf7[_0x7afd('0x34')]=_[_0x7afd('0x36')](db[_0x7afd('0x2f')][_0x7afd('0x30')]);_0x499cf7['query']=_[_0x7afd('0x36')](_0x31ec36[_0x7afd('0x35')]);_0x499cf7[_0x7afd('0x37')]=_[_0x7afd('0x38')](_0x499cf7[_0x7afd('0x34')],_0x499cf7[_0x7afd('0x35')]);_0x4f8062['attributes']=_['intersection'](_0x499cf7[_0x7afd('0x34')],qs[_0x7afd('0x3a')](_0x31ec36['query'][_0x7afd('0x3a')]));_0x4f8062[_0x7afd('0x39')]=_0x4f8062[_0x7afd('0x39')]['length']?_0x4f8062[_0x7afd('0x39')]:_0x499cf7['model'];if(_0x31ec36[_0x7afd('0x35')]['includeAll']){_0x4f8062[_0x7afd('0x46')]=[{'all':!![]}];}_0x4f8062=_['merge']({},_0x4f8062,_0x31ec36['options']);return db[_0x7afd('0x2f')][_0x7afd('0x4a')](_0x4f8062)['then'](handleEntityNotFound(_0x37495,null))[_0x7afd('0x29')](respondWithResult(_0x37495,null))[_0x7afd('0x4b')](handleError(_0x37495,null));};exports[_0x7afd('0x4c')]=function(_0x5c296f,_0x16e768){return db[_0x7afd('0x2f')][_0x7afd('0x4c')](_0x5c296f[_0x7afd('0x4d')],{})[_0x7afd('0x29')](respondWithResult(_0x16e768,0xc9))['catch'](handleError(_0x16e768,null));};exports[_0x7afd('0x27')]=function(_0x28a6f8,_0x11aaef){if(_0x28a6f8[_0x7afd('0x4d')]['id']){delete _0x28a6f8[_0x7afd('0x4d')]['id'];}return db['JscriptySessionReport']['find']({'where':{'id':_0x28a6f8[_0x7afd('0x49')]['id']}})[_0x7afd('0x29')](handleEntityNotFound(_0x11aaef,null))[_0x7afd('0x29')](saveUpdates(_0x28a6f8['body'],null))['then'](respondWithResult(_0x11aaef,null))[_0x7afd('0x4b')](handleError(_0x11aaef,null));};exports[_0x7afd('0x28')]=function(_0x146726,_0x1ef03b){return db[_0x7afd('0x2f')][_0x7afd('0x4a')]({'where':{'id':_0x146726['params']['id']}})[_0x7afd('0x29')](handleEntityNotFound(_0x1ef03b,null))['then'](removeEntity(_0x1ef03b,null))[_0x7afd('0x4b')](handleError(_0x1ef03b,null));};exports[_0x7afd('0x4e')]=function(_0x396eaa,_0x1fe857){return db[_0x7afd('0x2f')]['describe']()['then'](respondWithResult(_0x1fe857,null))['catch'](handleError(_0x1fe857,null));};exports[_0x7afd('0x4f')]=function(_0x494883,_0xa03dfe,_0xd6c4dc){var _0x3c50f0={'raw':!![],'where':{}};var _0x286c51={};var _0x144ea8={'count':0x0,'rows':[]};return db[_0x7afd('0x2f')]['findOne']({'where':{'id':_0x494883['params']['id']}})[_0x7afd('0x29')](handleEntityNotFound(_0xa03dfe,null))[_0x7afd('0x29')](function(_0x10261d){if(_0x10261d){_0x286c51['model']=_[_0x7afd('0x36')](db[_0x7afd('0x50')]['rawAttributes']);_0x286c51[_0x7afd('0x35')]=_[_0x7afd('0x36')](_0x494883[_0x7afd('0x35')]);_0x286c51['filters']=_['intersection'](_0x286c51[_0x7afd('0x34')],_0x286c51['query']);_0x3c50f0['attributes']=_['intersection'](_0x286c51['model'],qs[_0x7afd('0x3a')](_0x494883[_0x7afd('0x35')][_0x7afd('0x3a')]));_0x3c50f0[_0x7afd('0x39')]=_0x3c50f0[_0x7afd('0x39')][_0x7afd('0x3b')]?_0x3c50f0[_0x7afd('0x39')]:_0x286c51['model'];if(!_0x494883[_0x7afd('0x35')]['hasOwnProperty'](_0x7afd('0x51'))){_0x3c50f0[_0x7afd('0x21')]=qs[_0x7afd('0x21')](_0x494883[_0x7afd('0x35')][_0x7afd('0x21')]);_0x3c50f0[_0x7afd('0x1f')]=qs['offset'](_0x494883['query'][_0x7afd('0x1f')]);}_0x3c50f0[_0x7afd('0x3d')]=qs[_0x7afd('0x3e')](_0x494883[_0x7afd('0x35')][_0x7afd('0x3e')]);_0x3c50f0['where']=qs[_0x7afd('0x37')](_[_0x7afd('0x40')](_0x494883['query'],_0x286c51[_0x7afd('0x37')]));_0x3c50f0['where'][_0x7afd('0x52')]=_0x10261d['id'];if(_0x494883[_0x7afd('0x35')][_0x7afd('0x42')]){_0x3c50f0[_0x7afd('0x3f')]=_[_0x7afd('0x43')](_0x3c50f0[_0x7afd('0x3f')],{'$or':_[_0x7afd('0x2e')](_0x3c50f0[_0x7afd('0x39')],function(_0x288e23){var _0x282be4={};_0x282be4[_0x288e23]={'$like':'%'+_0x494883[_0x7afd('0x35')]['filter']+'%'};return _0x282be4;})});}_0x3c50f0=_[_0x7afd('0x43')]({},_0x3c50f0,_0x494883[_0x7afd('0x44')]);return db[_0x7afd('0x50')]['count']({'where':_0x3c50f0[_0x7afd('0x3f')]})[_0x7afd('0x29')](function(_0x3a9803){_0x144ea8['count']=_0x3a9803;if(_0x494883[_0x7afd('0x35')]['includeAll']){_0x3c50f0['include']=[{'all':!![]}];}return db['JscriptyQuestionReport']['findAll'](_0x3c50f0);})[_0x7afd('0x29')](function(_0x1f8df1){_0x144ea8[_0x7afd('0x53')]=_0x1f8df1;return _0x144ea8;});}})[_0x7afd('0x29')](respondWithFilteredResult(_0xa03dfe,_0x3c50f0))[_0x7afd('0x4b')](handleError(_0xa03dfe,null));};
\ No newline at end of file
+var _0x3d81=['error','stack','name','send','index','map','JscriptySessionReport','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','VIRTUAL','options','includeAll','include','findAll','catch','show','params','attributes','merge','find','create','body','describe','findOne','JscriptyQuestionReport','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','mustache','util','path','ejs','lodash','crypto','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/environment','../../mysqldb','status','end','offset','undefined','limit','count','set','apply','reject','update','then','destroy','sendStatus'];(function(_0x3422bf,_0x21b1da){var _0x4de668=function(_0x271cce){while(--_0x271cce){_0x3422bf['push'](_0x3422bf['shift']());}};_0x4de668(++_0x21b1da);}(_0x3d81,0x76));var _0x13d8=function(_0xfd8522,_0x17712e){_0xfd8522=_0xfd8522-0x0;var _0x2bf81e=_0x3d81[_0xfd8522];return _0x2bf81e;};'use strict';var emlformat=require(_0x13d8('0x0'));var rimraf=require(_0x13d8('0x1'));var zipdir=require(_0x13d8('0x2'));var jsonpatch=require(_0x13d8('0x3'));var rp=require(_0x13d8('0x4'));var moment=require('moment');var BPromise=require(_0x13d8('0x5'));var Mustache=require(_0x13d8('0x6'));var util=require(_0x13d8('0x7'));var path=require(_0x13d8('0x8'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x13d8('0x9'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x13d8('0xa'));var squel=require('squel');var crypto=require(_0x13d8('0xb'));var jsforce=require('jsforce');var deskjs=require(_0x13d8('0xc'));var toCsv=require('to-csv');var querystring=require(_0x13d8('0xd'));var Papa=require(_0x13d8('0xe'));var Redis=require(_0x13d8('0xf'));var authService=require(_0x13d8('0x10'));var qs=require(_0x13d8('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x13d8('0x12'));var logger=require(_0x13d8('0x13'))(_0x13d8('0x14'));var utils=require('../../config/utils');var config=require(_0x13d8('0x15'));var licenseUtil=require('../../config/license/util');var db=require(_0x13d8('0x16'))['db'];function respondWithStatusCode(_0x4502f2,_0x2c9ef8){_0x2c9ef8=_0x2c9ef8||0xcc;return function(_0x26d5a1){if(_0x26d5a1){return _0x4502f2['sendStatus'](_0x2c9ef8);}return _0x4502f2[_0x13d8('0x17')](_0x2c9ef8)[_0x13d8('0x18')]();};}function respondWithResult(_0x45eeed,_0x375b2b){_0x375b2b=_0x375b2b||0xc8;return function(_0x4b221e){if(_0x4b221e){return _0x45eeed['status'](_0x375b2b)['json'](_0x4b221e);}};}function respondWithFilteredResult(_0x570206,_0x526b11){return function(_0x9f909){if(_0x9f909){var _0x2b9e97=typeof _0x526b11[_0x13d8('0x19')]===_0x13d8('0x1a')&&typeof _0x526b11[_0x13d8('0x1b')]==='undefined';var _0x850e4f=_0x9f909[_0x13d8('0x1c')];var _0x57a537=_0x2b9e97?0x0:_0x526b11[_0x13d8('0x19')];var _0x1cecbd=_0x2b9e97?_0x9f909[_0x13d8('0x1c')]:_0x526b11[_0x13d8('0x19')]+_0x526b11[_0x13d8('0x1b')];var _0x173280;if(_0x1cecbd>=_0x850e4f){_0x1cecbd=_0x850e4f;_0x173280=0xc8;}else{_0x173280=0xce;}_0x570206[_0x13d8('0x17')](_0x173280);return _0x570206[_0x13d8('0x1d')]('Content-Range',_0x57a537+'-'+_0x1cecbd+'/'+_0x850e4f)['json'](_0x9f909);}return null;};}function patchUpdates(_0x329ba5){return function(_0x599837){try{jsonpatch[_0x13d8('0x1e')](_0x599837,_0x329ba5,!![]);}catch(_0x193268){return BPromise[_0x13d8('0x1f')](_0x193268);}return _0x599837['save']();};}function saveUpdates(_0x1dd321,_0x34f507){return function(_0x1aee60){if(_0x1aee60){return _0x1aee60[_0x13d8('0x20')](_0x1dd321)[_0x13d8('0x21')](function(_0xf04b3){return _0xf04b3;});}return null;};}function removeEntity(_0x5920bb,_0x404534){return function(_0x53ffbb){if(_0x53ffbb){return _0x53ffbb[_0x13d8('0x22')]()['then'](function(){_0x5920bb['status'](0xcc)[_0x13d8('0x18')]();});}};}function handleEntityNotFound(_0x46dc98,_0x50f910){return function(_0x491bfb){if(!_0x491bfb){_0x46dc98[_0x13d8('0x23')](0x194);}return _0x491bfb;};}function handleError(_0x254663,_0x44e87d){_0x44e87d=_0x44e87d||0x1f4;return function(_0x24f8b8){logger[_0x13d8('0x24')](_0x24f8b8[_0x13d8('0x25')]);if(_0x24f8b8[_0x13d8('0x26')]){delete _0x24f8b8[_0x13d8('0x26')];}_0x254663[_0x13d8('0x17')](_0x44e87d)[_0x13d8('0x27')](_0x24f8b8);};}exports[_0x13d8('0x28')]=function(_0x5240d3,_0x48ab59){var _0x12e97c={},_0xa3893d={},_0x5092b0={'count':0x0,'rows':[]};var _0x36fe19=_[_0x13d8('0x29')](db[_0x13d8('0x2a')][_0x13d8('0x2b')],function(_0x168f30){return{'name':_0x168f30[_0x13d8('0x2c')],'type':_0x168f30[_0x13d8('0x2d')][_0x13d8('0x2e')]};});_0xa3893d[_0x13d8('0x2f')]=_['map'](_0x36fe19,_0x13d8('0x26'));_0xa3893d[_0x13d8('0x30')]=_[_0x13d8('0x31')](_0x5240d3[_0x13d8('0x30')]);_0xa3893d[_0x13d8('0x32')]=_[_0x13d8('0x33')](_0xa3893d[_0x13d8('0x2f')],_0xa3893d[_0x13d8('0x30')]);_0x12e97c['attributes']=_[_0x13d8('0x33')](_0xa3893d[_0x13d8('0x2f')],qs[_0x13d8('0x34')](_0x5240d3[_0x13d8('0x30')]['fields']));_0x12e97c['attributes']=_0x12e97c['attributes'][_0x13d8('0x35')]?_0x12e97c['attributes']:_0xa3893d[_0x13d8('0x2f')];if(!_0x5240d3[_0x13d8('0x30')][_0x13d8('0x36')](_0x13d8('0x37'))){_0x12e97c[_0x13d8('0x1b')]=qs[_0x13d8('0x1b')](_0x5240d3['query']['limit']);_0x12e97c[_0x13d8('0x19')]=qs[_0x13d8('0x19')](_0x5240d3[_0x13d8('0x30')]['offset']);}_0x12e97c[_0x13d8('0x38')]=qs['sort'](_0x5240d3['query'][_0x13d8('0x39')]);_0x12e97c[_0x13d8('0x3a')]=qs[_0x13d8('0x32')](_[_0x13d8('0x3b')](_0x5240d3['query'],_0xa3893d[_0x13d8('0x32')]),_0x36fe19);if(_0x5240d3[_0x13d8('0x30')][_0x13d8('0x3c')]){_0x12e97c[_0x13d8('0x3a')]=_['merge'](_0x12e97c[_0x13d8('0x3a')],{'$or':_['map'](_0x36fe19,function(_0x440423){if(_0x440423[_0x13d8('0x2d')]!==_0x13d8('0x3d')){var _0x5dd88c={};_0x5dd88c[_0x440423[_0x13d8('0x26')]]={'$like':'%'+_0x5240d3['query'][_0x13d8('0x3c')]+'%'};return _0x5dd88c;}})});}_0x12e97c=_['merge']({},_0x12e97c,_0x5240d3[_0x13d8('0x3e')]);var _0x406626={'where':_0x12e97c[_0x13d8('0x3a')]};return db[_0x13d8('0x2a')][_0x13d8('0x1c')](_0x406626)[_0x13d8('0x21')](function(_0x26d8a6){_0x5092b0[_0x13d8('0x1c')]=_0x26d8a6;if(_0x5240d3[_0x13d8('0x30')][_0x13d8('0x3f')]){_0x12e97c[_0x13d8('0x40')]=[{'all':!![]}];}return db['JscriptySessionReport'][_0x13d8('0x41')](_0x12e97c);})['then'](function(_0x37a3ed){_0x5092b0['rows']=_0x37a3ed;return _0x5092b0;})[_0x13d8('0x21')](respondWithFilteredResult(_0x48ab59,_0x12e97c))[_0x13d8('0x42')](handleError(_0x48ab59,null));};exports[_0x13d8('0x43')]=function(_0x2e3c9f,_0x3676d2){var _0x486023={'raw':!![],'where':{'id':_0x2e3c9f[_0x13d8('0x44')]['id']}},_0x216c13={};_0x216c13[_0x13d8('0x2f')]=_[_0x13d8('0x31')](db[_0x13d8('0x2a')][_0x13d8('0x2b')]);_0x216c13[_0x13d8('0x30')]=_['keys'](_0x2e3c9f['query']);_0x216c13[_0x13d8('0x32')]=_[_0x13d8('0x33')](_0x216c13[_0x13d8('0x2f')],_0x216c13['query']);_0x486023['attributes']=_['intersection'](_0x216c13[_0x13d8('0x2f')],qs[_0x13d8('0x34')](_0x2e3c9f[_0x13d8('0x30')]['fields']));_0x486023[_0x13d8('0x45')]=_0x486023[_0x13d8('0x45')][_0x13d8('0x35')]?_0x486023[_0x13d8('0x45')]:_0x216c13[_0x13d8('0x2f')];if(_0x2e3c9f[_0x13d8('0x30')][_0x13d8('0x3f')]){_0x486023[_0x13d8('0x40')]=[{'all':!![]}];}_0x486023=_[_0x13d8('0x46')]({},_0x486023,_0x2e3c9f[_0x13d8('0x3e')]);return db[_0x13d8('0x2a')][_0x13d8('0x47')](_0x486023)[_0x13d8('0x21')](handleEntityNotFound(_0x3676d2,null))['then'](respondWithResult(_0x3676d2,null))[_0x13d8('0x42')](handleError(_0x3676d2,null));};exports[_0x13d8('0x48')]=function(_0x4a2a89,_0x7d21f6){return db[_0x13d8('0x2a')][_0x13d8('0x48')](_0x4a2a89[_0x13d8('0x49')],{})[_0x13d8('0x21')](respondWithResult(_0x7d21f6,0xc9))[_0x13d8('0x42')](handleError(_0x7d21f6,null));};exports[_0x13d8('0x20')]=function(_0x52de60,_0x182c91){if(_0x52de60['body']['id']){delete _0x52de60[_0x13d8('0x49')]['id'];}return db[_0x13d8('0x2a')][_0x13d8('0x47')]({'where':{'id':_0x52de60[_0x13d8('0x44')]['id']}})[_0x13d8('0x21')](handleEntityNotFound(_0x182c91,null))[_0x13d8('0x21')](saveUpdates(_0x52de60[_0x13d8('0x49')],null))['then'](respondWithResult(_0x182c91,null))[_0x13d8('0x42')](handleError(_0x182c91,null));};exports[_0x13d8('0x22')]=function(_0x29f188,_0x2a177f){return db[_0x13d8('0x2a')][_0x13d8('0x47')]({'where':{'id':_0x29f188[_0x13d8('0x44')]['id']}})[_0x13d8('0x21')](handleEntityNotFound(_0x2a177f,null))['then'](removeEntity(_0x2a177f,null))[_0x13d8('0x42')](handleError(_0x2a177f,null));};exports[_0x13d8('0x4a')]=function(_0x1ee5fb,_0x2a9028){return db[_0x13d8('0x2a')][_0x13d8('0x4a')]()['then'](respondWithResult(_0x2a9028,null))['catch'](handleError(_0x2a9028,null));};exports['getQuestions']=function(_0x13b7fb,_0x5d5665,_0x1b4654){var _0x16086b={'raw':!![],'where':{}};var _0x5677b7={};var _0x3c41a2={'count':0x0,'rows':[]};return db[_0x13d8('0x2a')][_0x13d8('0x4b')]({'where':{'id':_0x13b7fb[_0x13d8('0x44')]['id']}})['then'](handleEntityNotFound(_0x5d5665,null))[_0x13d8('0x21')](function(_0x37e5cc){if(_0x37e5cc){_0x5677b7['model']=_['keys'](db[_0x13d8('0x4c')]['rawAttributes']);_0x5677b7['query']=_[_0x13d8('0x31')](_0x13b7fb[_0x13d8('0x30')]);_0x5677b7[_0x13d8('0x32')]=_[_0x13d8('0x33')](_0x5677b7[_0x13d8('0x2f')],_0x5677b7[_0x13d8('0x30')]);_0x16086b[_0x13d8('0x45')]=_[_0x13d8('0x33')](_0x5677b7[_0x13d8('0x2f')],qs['fields'](_0x13b7fb[_0x13d8('0x30')]['fields']));_0x16086b[_0x13d8('0x45')]=_0x16086b['attributes'][_0x13d8('0x35')]?_0x16086b[_0x13d8('0x45')]:_0x5677b7[_0x13d8('0x2f')];if(!_0x13b7fb[_0x13d8('0x30')][_0x13d8('0x36')](_0x13d8('0x37'))){_0x16086b[_0x13d8('0x1b')]=qs[_0x13d8('0x1b')](_0x13b7fb[_0x13d8('0x30')]['limit']);_0x16086b['offset']=qs[_0x13d8('0x19')](_0x13b7fb[_0x13d8('0x30')][_0x13d8('0x19')]);}_0x16086b[_0x13d8('0x38')]=qs['sort'](_0x13b7fb[_0x13d8('0x30')][_0x13d8('0x39')]);_0x16086b['where']=qs[_0x13d8('0x32')](_[_0x13d8('0x3b')](_0x13b7fb['query'],_0x5677b7[_0x13d8('0x32')]));_0x16086b['where']['SessionId']=_0x37e5cc['id'];if(_0x13b7fb[_0x13d8('0x30')][_0x13d8('0x3c')]){_0x16086b[_0x13d8('0x3a')]=_['merge'](_0x16086b['where'],{'$or':_[_0x13d8('0x29')](_0x16086b[_0x13d8('0x45')],function(_0x1a4a7c){var _0x456732={};_0x456732[_0x1a4a7c]={'$like':'%'+_0x13b7fb[_0x13d8('0x30')]['filter']+'%'};return _0x456732;})});}_0x16086b=_[_0x13d8('0x46')]({},_0x16086b,_0x13b7fb[_0x13d8('0x3e')]);return db[_0x13d8('0x4c')]['count']({'where':_0x16086b[_0x13d8('0x3a')]})['then'](function(_0x8465f9){_0x3c41a2[_0x13d8('0x1c')]=_0x8465f9;if(_0x13b7fb['query']['includeAll']){_0x16086b['include']=[{'all':!![]}];}return db[_0x13d8('0x4c')][_0x13d8('0x41')](_0x16086b);})['then'](function(_0x519b68){_0x3c41a2['rows']=_0x519b68;return _0x3c41a2;});}})['then'](respondWithFilteredResult(_0x5d5665,_0x16086b))[_0x13d8('0x42')](handleError(_0x5d5665,null));};
\ No newline at end of file