Built motion from commit 936e8062.|2.5.33
[motion2.git] / server / api / squareOdbc / squareOdbc.controller.js
index 032e943..b6ad053 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x2323=['destroy','sendStatus','stack','name','map','SquareOdbc','model','query','intersection','fields','attributes','length','hasOwnProperty','nolimit','limit','sort','where','pick','filters','filter','merge','type','options','includeAll','include','findAll','rows','catch','show','rawAttributes','keys','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','test','dsn','closeSync','html-pdf','eml-format','rimraf','zip-dir','request-promise','mustache','path','sox','to-csv','ejs','squel','crypto','jsforce','desk.js','querystring','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/environment','../../config/license/util','end','status','json','count','offset','set','Content-Range','apply','save','update','then','get','ODBC','UserProfileResource'];(function(_0x172948,_0x4262cc){var _0x4aeaa9=function(_0x5ec4b3){while(--_0x5ec4b3){_0x172948['push'](_0x172948['shift']());}};_0x4aeaa9(++_0x4262cc);}(_0x2323,0xcd));var _0x3232=function(_0x119f7b,_0x204cc4){_0x119f7b=_0x119f7b-0x0;var _0x247400=_0x2323[_0x119f7b];return _0x247400;};'use strict';var pdf=require(_0x3232('0x0'));var emlformat=require(_0x3232('0x1'));var rimraf=require(_0x3232('0x2'));var zipdir=require(_0x3232('0x3'));var jsonpatch=require('fast-json-patch');var rp=require(_0x3232('0x4'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x3232('0x5'));var util=require('util');var path=require(_0x3232('0x6'));var sox=require(_0x3232('0x7'));var csv=require(_0x3232('0x8'));var ejs=require(_0x3232('0x9'));var fs=require('fs');var _=require('lodash');var squel=require(_0x3232('0xa'));var crypto=require(_0x3232('0xb'));var jsforce=require(_0x3232('0xc'));var deskjs=require(_0x3232('0xd'));var toCsv=require(_0x3232('0x8'));var querystring=require(_0x3232('0xe'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x3232('0xf'));var qs=require(_0x3232('0x10'));var as=require(_0x3232('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x3232('0x12'))('api');var utils=require('../../config/utils');var config=require(_0x3232('0x13'));var licenseUtil=require(_0x3232('0x14'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x4603ab,_0x497a8d){_0x497a8d=_0x497a8d||0xcc;return function(_0x1628ed){if(_0x1628ed){return _0x4603ab['sendStatus'](_0x497a8d);}return _0x4603ab['status'](_0x497a8d)[_0x3232('0x15')]();};}function respondWithResult(_0x2d3ca3,_0x25551a){_0x25551a=_0x25551a||0xc8;return function(_0x39790d){if(_0x39790d){return _0x2d3ca3[_0x3232('0x16')](_0x25551a)[_0x3232('0x17')](_0x39790d);}};}function respondWithFilteredResult(_0x202a8d,_0x1db426){return function(_0x7eefdb){if(_0x7eefdb){var _0x4ba333=_0x7eefdb[_0x3232('0x18')],_0x1ad92d=_0x1db426[_0x3232('0x19')],_0x3b8839=_0x1db426[_0x3232('0x19')]+_0x1db426['limit'],_0x153929;if(_0x3b8839>=_0x4ba333){_0x3b8839=_0x4ba333;_0x153929=0xc8;}else{_0x153929=0xce;}_0x202a8d[_0x3232('0x16')](_0x153929);return _0x202a8d[_0x3232('0x1a')](_0x3232('0x1b'),_0x1ad92d+'-'+_0x3b8839+'/'+_0x4ba333)[_0x3232('0x17')](_0x7eefdb);}return null;};}function patchUpdates(_0x5ec93d){return function(_0x4bc5b7){try{jsonpatch[_0x3232('0x1c')](_0x4bc5b7,_0x5ec93d,!![]);}catch(_0x36e03e){return BPromise['reject'](_0x36e03e);}return _0x4bc5b7[_0x3232('0x1d')]();};}function saveUpdates(_0x978bbc,_0x350d23){return function(_0x4a20c5){if(_0x4a20c5){return _0x4a20c5[_0x3232('0x1e')](_0x978bbc)[_0x3232('0x1f')](function(_0x3ef230){return _0x3ef230;});}return null;};}function removeEntity(_0x1a2209,_0x279ec3){return function(_0x12f271){if(_0x12f271){return _0x12f271['destroy']()[_0x3232('0x1f')](function(){var _0xec8479=_0x12f271[_0x3232('0x20')]({'plain':!![]});var _0x53ec37=_0x3232('0x21');return db[_0x3232('0x22')][_0x3232('0x23')]({'where':{'type':_0x53ec37,'resourceId':_0xec8479['id']}})[_0x3232('0x1f')](function(){return _0x12f271;});})[_0x3232('0x1f')](function(){_0x1a2209['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x2af6d7,_0x5e9182){return function(_0x359f57){if(!_0x359f57){_0x2af6d7[_0x3232('0x24')](0x194);}return _0x359f57;};}function handleError(_0x57180a,_0x313207){_0x313207=_0x313207||0x1f4;return function(_0x56d8b3){logger['error'](_0x56d8b3[_0x3232('0x25')]);if(_0x56d8b3[_0x3232('0x26')]){delete _0x56d8b3[_0x3232('0x26')];}_0x57180a[_0x3232('0x16')](_0x313207)['send'](_0x56d8b3);};}exports['index']=function(_0x340d56,_0x2362d2){var _0x55f67f={},_0x554d7b={},_0x3cbc42={'count':0x0,'rows':[]};var _0x20753d=_[_0x3232('0x27')](db[_0x3232('0x28')]['rawAttributes'],function(_0x312590){return{'name':_0x312590['fieldName'],'type':_0x312590['type']['key']};});_0x554d7b[_0x3232('0x29')]=_['map'](_0x20753d,_0x3232('0x26'));_0x554d7b['query']=_['keys'](_0x340d56[_0x3232('0x2a')]);_0x554d7b['filters']=_[_0x3232('0x2b')](_0x554d7b[_0x3232('0x29')],_0x554d7b[_0x3232('0x2a')]);_0x55f67f['attributes']=_[_0x3232('0x2b')](_0x554d7b[_0x3232('0x29')],qs['fields'](_0x340d56[_0x3232('0x2a')][_0x3232('0x2c')]));_0x55f67f[_0x3232('0x2d')]=_0x55f67f[_0x3232('0x2d')][_0x3232('0x2e')]?_0x55f67f[_0x3232('0x2d')]:_0x554d7b[_0x3232('0x29')];if(!_0x340d56[_0x3232('0x2a')][_0x3232('0x2f')](_0x3232('0x30'))){_0x55f67f[_0x3232('0x31')]=qs[_0x3232('0x31')](_0x340d56[_0x3232('0x2a')][_0x3232('0x31')]);_0x55f67f[_0x3232('0x19')]=qs['offset'](_0x340d56[_0x3232('0x2a')][_0x3232('0x19')]);}_0x55f67f['order']=qs[_0x3232('0x32')](_0x340d56[_0x3232('0x2a')][_0x3232('0x32')]);_0x55f67f[_0x3232('0x33')]=qs['filters'](_[_0x3232('0x34')](_0x340d56['query'],_0x554d7b[_0x3232('0x35')]),_0x20753d);if(_0x340d56[_0x3232('0x2a')][_0x3232('0x36')]){_0x55f67f[_0x3232('0x33')]=_[_0x3232('0x37')](_0x55f67f[_0x3232('0x33')],{'$or':_[_0x3232('0x27')](_0x20753d,function(_0x1309a1){if(_0x1309a1[_0x3232('0x38')]!=='VIRTUAL'){var _0x268335={};_0x268335[_0x1309a1[_0x3232('0x26')]]={'$like':'%'+_0x340d56[_0x3232('0x2a')][_0x3232('0x36')]+'%'};return _0x268335;}})});}_0x55f67f=_[_0x3232('0x37')]({},_0x55f67f,_0x340d56[_0x3232('0x39')]);var _0x1aa7a3={'where':_0x55f67f[_0x3232('0x33')]};return db[_0x3232('0x28')][_0x3232('0x18')](_0x1aa7a3)[_0x3232('0x1f')](function(_0x449748){_0x3cbc42[_0x3232('0x18')]=_0x449748;if(_0x340d56['query'][_0x3232('0x3a')]){_0x55f67f[_0x3232('0x3b')]=[{'all':!![]}];}return db[_0x3232('0x28')][_0x3232('0x3c')](_0x55f67f);})[_0x3232('0x1f')](function(_0x119b82){_0x3cbc42[_0x3232('0x3d')]=_0x119b82;return _0x3cbc42;})[_0x3232('0x1f')](respondWithFilteredResult(_0x2362d2,_0x55f67f))[_0x3232('0x3e')](handleError(_0x2362d2,null));};exports[_0x3232('0x3f')]=function(_0x13f7e6,_0x3e4011){var _0x18360f={'raw':!![],'where':{'id':_0x13f7e6['params']['id']}},_0x3830d6={};_0x3830d6['model']=_['keys'](db[_0x3232('0x28')][_0x3232('0x40')]);_0x3830d6[_0x3232('0x2a')]=_[_0x3232('0x41')](_0x13f7e6['query']);_0x3830d6[_0x3232('0x35')]=_[_0x3232('0x2b')](_0x3830d6['model'],_0x3830d6[_0x3232('0x2a')]);_0x18360f[_0x3232('0x2d')]=_[_0x3232('0x2b')](_0x3830d6[_0x3232('0x29')],qs['fields'](_0x13f7e6['query'][_0x3232('0x2c')]));_0x18360f['attributes']=_0x18360f['attributes'][_0x3232('0x2e')]?_0x18360f['attributes']:_0x3830d6[_0x3232('0x29')];if(_0x13f7e6[_0x3232('0x2a')]['includeAll']){_0x18360f[_0x3232('0x3b')]=[{'all':!![]}];}_0x18360f=_[_0x3232('0x37')]({},_0x18360f,_0x13f7e6[_0x3232('0x39')]);return db[_0x3232('0x28')][_0x3232('0x42')](_0x18360f)[_0x3232('0x1f')](handleEntityNotFound(_0x3e4011,null))['then'](respondWithResult(_0x3e4011,null))[_0x3232('0x3e')](handleError(_0x3e4011,null));};exports[_0x3232('0x43')]=function(_0x260e8c,_0x3c61ee){return db['SquareOdbc'][_0x3232('0x43')](_0x260e8c[_0x3232('0x44')],{})[_0x3232('0x1f')](function(_0xe4a0fb){var _0x44f8bd=_0x260e8c[_0x3232('0x45')][_0x3232('0x20')]({'plain':!![]});if(!_0x44f8bd)throw new Error(_0x3232('0x46'));if(_0x44f8bd[_0x3232('0x47')]===_0x3232('0x45')){var _0x2771cb=_0xe4a0fb[_0x3232('0x20')]({'plain':!![]});var _0x42b7a8=_0x3232('0x21');return db[_0x3232('0x48')]['find']({'where':{'name':_0x42b7a8,'userProfileId':_0x44f8bd[_0x3232('0x49')]},'raw':!![]})['then'](function(_0x50269c){if(_0x50269c&&_0x50269c[_0x3232('0x4a')]===0x0){return db[_0x3232('0x22')][_0x3232('0x43')]({'name':_0x2771cb[_0x3232('0x26')],'resourceId':_0x2771cb['id'],'type':_0x50269c[_0x3232('0x26')],'sectionId':_0x50269c['id']},{})[_0x3232('0x1f')](function(){return _0xe4a0fb;});}else{return _0xe4a0fb;}})[_0x3232('0x3e')](function(_0x33dbc3){logger['error'](_0x3232('0x4b'),_0x33dbc3);throw _0x33dbc3;});}return _0xe4a0fb;})[_0x3232('0x1f')](respondWithResult(_0x3c61ee,0xc9))[_0x3232('0x3e')](handleError(_0x3c61ee,null));};exports[_0x3232('0x1e')]=function(_0x1211ca,_0x462965){if(_0x1211ca[_0x3232('0x44')]['id']){delete _0x1211ca[_0x3232('0x44')]['id'];}return db[_0x3232('0x28')]['find']({'where':{'id':_0x1211ca[_0x3232('0x4c')]['id']}})[_0x3232('0x1f')](handleEntityNotFound(_0x462965,null))[_0x3232('0x1f')](saveUpdates(_0x1211ca['body'],null))['then'](respondWithResult(_0x462965,null))[_0x3232('0x3e')](handleError(_0x462965,null));};exports['destroy']=function(_0x5b9e03,_0x280cee){return db[_0x3232('0x28')][_0x3232('0x42')]({'where':{'id':_0x5b9e03[_0x3232('0x4c')]['id']}})['then'](handleEntityNotFound(_0x280cee,null))[_0x3232('0x1f')](removeEntity(_0x280cee,null))[_0x3232('0x3e')](handleError(_0x280cee,null));};exports[_0x3232('0x4d')]=function(_0x4cc1aa,_0x10b3e8,_0x29825c){var _0x215180;return db['SquareOdbc'][_0x3232('0x42')]({'where':{'id':_0x4cc1aa['params']['id']},'attributes':['id',_0x3232('0x4e')]})[_0x3232('0x1f')](handleEntityNotFound(_0x10b3e8,null))[_0x3232('0x1f')](function(_0x41929e){if(_0x41929e){var _0xca3937=require('odbc')();_0xca3937['openSync'](_0x41929e[_0x3232('0x4e')]);_0xca3937[_0x3232('0x4f')]();return _0x41929e;}})[_0x3232('0x1f')](respondWithResult(_0x10b3e8,null))[_0x3232('0x3e')](handleError(_0x10b3e8,null));};
\ No newline at end of file
+var _0xc9f0=['type','key','map','query','keys','model','attributes','fields','length','hasOwnProperty','order','sort','where','filters','pick','filter','VIRTUAL','merge','options','includeAll','include','findAll','rows','catch','show','params','create','body','user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','find','odbc','closeSync','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','ejs','fs-extra','squel','crypto','jsforce','desk.js','to-csv','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','undefined','limit','count','offset','set','Content-Range','reject','save','then','destroy','get','ODBC','UserProfileResource','stack','name','SquareOdbc','rawAttributes'];(function(_0x13c8f5,_0xf0fef9){var _0x20448e=function(_0x59976e){while(--_0x59976e){_0x13c8f5['push'](_0x13c8f5['shift']());}};_0x20448e(++_0xf0fef9);}(_0xc9f0,0x79));var _0x0c9f=function(_0x1f28b6,_0xd2d80a){_0x1f28b6=_0x1f28b6-0x0;var _0x349220=_0xc9f0[_0x1f28b6];return _0x349220;};'use strict';var emlformat=require('eml-format');var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0x0c9f('0x0'));var rp=require(_0x0c9f('0x1'));var moment=require(_0x0c9f('0x2'));var BPromise=require(_0x0c9f('0x3'));var Mustache=require(_0x0c9f('0x4'));var util=require(_0x0c9f('0x5'));var path=require(_0x0c9f('0x6'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x0c9f('0x7'));var fs=require('fs');var fs_extra=require(_0x0c9f('0x8'));var _=require('lodash');var squel=require(_0x0c9f('0x9'));var crypto=require(_0x0c9f('0xa'));var jsforce=require(_0x0c9f('0xb'));var deskjs=require(_0x0c9f('0xc'));var toCsv=require(_0x0c9f('0xd'));var querystring=require(_0x0c9f('0xe'));var Papa=require('papaparse');var Redis=require(_0x0c9f('0xf'));var authService=require(_0x0c9f('0x10'));var qs=require(_0x0c9f('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x0c9f('0x12'));var logger=require('../../config/logger')(_0x0c9f('0x13'));var utils=require(_0x0c9f('0x14'));var config=require(_0x0c9f('0x15'));var licenseUtil=require(_0x0c9f('0x16'));var db=require(_0x0c9f('0x17'))['db'];function respondWithStatusCode(_0x47e95c,_0x471532){_0x471532=_0x471532||0xcc;return function(_0x850c56){if(_0x850c56){return _0x47e95c[_0x0c9f('0x18')](_0x471532);}return _0x47e95c[_0x0c9f('0x19')](_0x471532)[_0x0c9f('0x1a')]();};}function respondWithResult(_0x4a1b73,_0x230f57){_0x230f57=_0x230f57||0xc8;return function(_0x46924e){if(_0x46924e){return _0x4a1b73['status'](_0x230f57)[_0x0c9f('0x1b')](_0x46924e);}};}function respondWithFilteredResult(_0x4516fe,_0x481f91){return function(_0x380e00){if(_0x380e00){var _0x3d5537=typeof _0x481f91['offset']===_0x0c9f('0x1c')&&typeof _0x481f91[_0x0c9f('0x1d')]===_0x0c9f('0x1c');var _0x202618=_0x380e00[_0x0c9f('0x1e')];var _0x14f680=_0x3d5537?0x0:_0x481f91[_0x0c9f('0x1f')];var _0xdd5185=_0x3d5537?_0x380e00[_0x0c9f('0x1e')]:_0x481f91['offset']+_0x481f91[_0x0c9f('0x1d')];var _0x1d6131;if(_0xdd5185>=_0x202618){_0xdd5185=_0x202618;_0x1d6131=0xc8;}else{_0x1d6131=0xce;}_0x4516fe[_0x0c9f('0x19')](_0x1d6131);return _0x4516fe[_0x0c9f('0x20')](_0x0c9f('0x21'),_0x14f680+'-'+_0xdd5185+'/'+_0x202618)[_0x0c9f('0x1b')](_0x380e00);}return null;};}function patchUpdates(_0x1cb1ee){return function(_0x1c4c1f){try{jsonpatch['apply'](_0x1c4c1f,_0x1cb1ee,!![]);}catch(_0x1fcf4d){return BPromise[_0x0c9f('0x22')](_0x1fcf4d);}return _0x1c4c1f[_0x0c9f('0x23')]();};}function saveUpdates(_0xde1744,_0x5119cd){return function(_0x55e9fc){if(_0x55e9fc){return _0x55e9fc['update'](_0xde1744)[_0x0c9f('0x24')](function(_0x49adaa){return _0x49adaa;});}return null;};}function removeEntity(_0x3738af,_0xa03bbd){return function(_0x30ec43){if(_0x30ec43){return _0x30ec43[_0x0c9f('0x25')]()['then'](function(){var _0x583b3e=_0x30ec43[_0x0c9f('0x26')]({'plain':!![]});var _0x2ee730=_0x0c9f('0x27');return db[_0x0c9f('0x28')][_0x0c9f('0x25')]({'where':{'type':_0x2ee730,'resourceId':_0x583b3e['id']}})[_0x0c9f('0x24')](function(){return _0x30ec43;});})[_0x0c9f('0x24')](function(){_0x3738af[_0x0c9f('0x19')](0xcc)['end']();});}};}function handleEntityNotFound(_0x4c9463,_0x2dc72){return function(_0x5f11a2){if(!_0x5f11a2){_0x4c9463[_0x0c9f('0x18')](0x194);}return _0x5f11a2;};}function handleError(_0x325b42,_0x1de0ab){_0x1de0ab=_0x1de0ab||0x1f4;return function(_0x382711){logger['error'](_0x382711[_0x0c9f('0x29')]);if(_0x382711[_0x0c9f('0x2a')]){delete _0x382711['name'];}_0x325b42['status'](_0x1de0ab)['send'](_0x382711);};}exports['index']=function(_0x16cdae,_0x49b924){var _0x44369e={},_0x189481={},_0x4a22c2={'count':0x0,'rows':[]};var _0x4ae933=_['map'](db[_0x0c9f('0x2b')][_0x0c9f('0x2c')],function(_0x44f72d){return{'name':_0x44f72d['fieldName'],'type':_0x44f72d[_0x0c9f('0x2d')][_0x0c9f('0x2e')]};});_0x189481['model']=_[_0x0c9f('0x2f')](_0x4ae933,'name');_0x189481[_0x0c9f('0x30')]=_[_0x0c9f('0x31')](_0x16cdae[_0x0c9f('0x30')]);_0x189481['filters']=_['intersection'](_0x189481[_0x0c9f('0x32')],_0x189481[_0x0c9f('0x30')]);_0x44369e[_0x0c9f('0x33')]=_['intersection'](_0x189481[_0x0c9f('0x32')],qs[_0x0c9f('0x34')](_0x16cdae['query'][_0x0c9f('0x34')]));_0x44369e[_0x0c9f('0x33')]=_0x44369e[_0x0c9f('0x33')][_0x0c9f('0x35')]?_0x44369e[_0x0c9f('0x33')]:_0x189481[_0x0c9f('0x32')];if(!_0x16cdae[_0x0c9f('0x30')][_0x0c9f('0x36')]('nolimit')){_0x44369e[_0x0c9f('0x1d')]=qs[_0x0c9f('0x1d')](_0x16cdae[_0x0c9f('0x30')][_0x0c9f('0x1d')]);_0x44369e['offset']=qs[_0x0c9f('0x1f')](_0x16cdae[_0x0c9f('0x30')][_0x0c9f('0x1f')]);}_0x44369e[_0x0c9f('0x37')]=qs[_0x0c9f('0x38')](_0x16cdae[_0x0c9f('0x30')]['sort']);_0x44369e[_0x0c9f('0x39')]=qs[_0x0c9f('0x3a')](_[_0x0c9f('0x3b')](_0x16cdae[_0x0c9f('0x30')],_0x189481['filters']),_0x4ae933);if(_0x16cdae['query'][_0x0c9f('0x3c')]){_0x44369e[_0x0c9f('0x39')]=_['merge'](_0x44369e[_0x0c9f('0x39')],{'$or':_[_0x0c9f('0x2f')](_0x4ae933,function(_0x2cbd54){if(_0x2cbd54[_0x0c9f('0x2d')]!==_0x0c9f('0x3d')){var _0x5a99c9={};_0x5a99c9[_0x2cbd54['name']]={'$like':'%'+_0x16cdae['query']['filter']+'%'};return _0x5a99c9;}})});}_0x44369e=_[_0x0c9f('0x3e')]({},_0x44369e,_0x16cdae[_0x0c9f('0x3f')]);var _0x308cca={'where':_0x44369e[_0x0c9f('0x39')]};return db['SquareOdbc'][_0x0c9f('0x1e')](_0x308cca)[_0x0c9f('0x24')](function(_0x55e34d){_0x4a22c2[_0x0c9f('0x1e')]=_0x55e34d;if(_0x16cdae[_0x0c9f('0x30')][_0x0c9f('0x40')]){_0x44369e[_0x0c9f('0x41')]=[{'all':!![]}];}return db['SquareOdbc'][_0x0c9f('0x42')](_0x44369e);})['then'](function(_0x150a25){_0x4a22c2[_0x0c9f('0x43')]=_0x150a25;return _0x4a22c2;})[_0x0c9f('0x24')](respondWithFilteredResult(_0x49b924,_0x44369e))[_0x0c9f('0x44')](handleError(_0x49b924,null));};exports[_0x0c9f('0x45')]=function(_0x2b7f0e,_0x44cf99){var _0x4e770b={'raw':!![],'where':{'id':_0x2b7f0e[_0x0c9f('0x46')]['id']}},_0x4d0e72={};_0x4d0e72['model']=_[_0x0c9f('0x31')](db[_0x0c9f('0x2b')][_0x0c9f('0x2c')]);_0x4d0e72[_0x0c9f('0x30')]=_[_0x0c9f('0x31')](_0x2b7f0e[_0x0c9f('0x30')]);_0x4d0e72['filters']=_['intersection'](_0x4d0e72[_0x0c9f('0x32')],_0x4d0e72[_0x0c9f('0x30')]);_0x4e770b[_0x0c9f('0x33')]=_['intersection'](_0x4d0e72[_0x0c9f('0x32')],qs[_0x0c9f('0x34')](_0x2b7f0e[_0x0c9f('0x30')][_0x0c9f('0x34')]));_0x4e770b[_0x0c9f('0x33')]=_0x4e770b[_0x0c9f('0x33')][_0x0c9f('0x35')]?_0x4e770b[_0x0c9f('0x33')]:_0x4d0e72[_0x0c9f('0x32')];if(_0x2b7f0e[_0x0c9f('0x30')][_0x0c9f('0x40')]){_0x4e770b['include']=[{'all':!![]}];}_0x4e770b=_['merge']({},_0x4e770b,_0x2b7f0e[_0x0c9f('0x3f')]);return db['SquareOdbc']['find'](_0x4e770b)[_0x0c9f('0x24')](handleEntityNotFound(_0x44cf99,null))[_0x0c9f('0x24')](respondWithResult(_0x44cf99,null))['catch'](handleError(_0x44cf99,null));};exports['create']=function(_0x2aee8f,_0x191402){return db[_0x0c9f('0x2b')][_0x0c9f('0x47')](_0x2aee8f[_0x0c9f('0x48')],{})[_0x0c9f('0x24')](function(_0xe2e59b){var _0x4d12a2=_0x2aee8f[_0x0c9f('0x49')]['get']({'plain':!![]});if(!_0x4d12a2)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x4d12a2[_0x0c9f('0x4a')]===_0x0c9f('0x49')){var _0x110c21=_0xe2e59b['get']({'plain':!![]});var _0x15c45d=_0x0c9f('0x27');return db[_0x0c9f('0x4b')]['find']({'where':{'name':_0x15c45d,'userProfileId':_0x4d12a2[_0x0c9f('0x4c')]},'raw':!![]})['then'](function(_0x2c55f9){if(_0x2c55f9&&_0x2c55f9[_0x0c9f('0x4d')]===0x0){return db[_0x0c9f('0x28')][_0x0c9f('0x47')]({'name':_0x110c21[_0x0c9f('0x2a')],'resourceId':_0x110c21['id'],'type':_0x2c55f9[_0x0c9f('0x2a')],'sectionId':_0x2c55f9['id']},{})[_0x0c9f('0x24')](function(){return _0xe2e59b;});}else{return _0xe2e59b;}})[_0x0c9f('0x44')](function(_0x6908a2){logger['error'](_0x0c9f('0x4e'),_0x6908a2);throw _0x6908a2;});}return _0xe2e59b;})[_0x0c9f('0x24')](respondWithResult(_0x191402,0xc9))[_0x0c9f('0x44')](handleError(_0x191402,null));};exports[_0x0c9f('0x4f')]=function(_0x1a0982,_0x4b9248){if(_0x1a0982['body']['id']){delete _0x1a0982[_0x0c9f('0x48')]['id'];}return db[_0x0c9f('0x2b')]['find']({'where':{'id':_0x1a0982[_0x0c9f('0x46')]['id']}})[_0x0c9f('0x24')](handleEntityNotFound(_0x4b9248,null))['then'](saveUpdates(_0x1a0982[_0x0c9f('0x48')],null))['then'](respondWithResult(_0x4b9248,null))[_0x0c9f('0x44')](handleError(_0x4b9248,null));};exports[_0x0c9f('0x25')]=function(_0x5fd357,_0x4cd30a){return db[_0x0c9f('0x2b')]['find']({'where':{'id':_0x5fd357['params']['id']}})[_0x0c9f('0x24')](handleEntityNotFound(_0x4cd30a,null))[_0x0c9f('0x24')](removeEntity(_0x4cd30a,null))['catch'](handleError(_0x4cd30a,null));};exports['test']=function(_0x1dc74e,_0x5d7697,_0x680f17){var _0x37cc24;return db[_0x0c9f('0x2b')][_0x0c9f('0x50')]({'where':{'id':_0x1dc74e[_0x0c9f('0x46')]['id']},'attributes':['id','dsn']})[_0x0c9f('0x24')](handleEntityNotFound(_0x5d7697,null))[_0x0c9f('0x24')](function(_0x47d7b3){if(_0x47d7b3){var _0x3cd8d3=require(_0x0c9f('0x51'))();_0x3cd8d3['openSync'](_0x47d7b3['dsn']);_0x3cd8d3[_0x0c9f('0x52')]();return _0x47d7b3;}})[_0x0c9f('0x24')](respondWithResult(_0x5d7697,null))[_0x0c9f('0x44')](handleError(_0x5d7697,null));};
\ No newline at end of file