Built motion from commit 97153652.|2.6.26
[motion2.git] / server / api / squareOdbc / squareOdbc.controller.js
index 1769f6d..b3070a9 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0xbb00=['name','send','map','rawAttributes','type','key','model','query','filters','intersection','attributes','fields','hasOwnProperty','order','sort','where','filter','merge','SquareOdbc','includeAll','include','findAll','rows','catch','show','params','keys','length','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','ODBC','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','test','dsn','odbc','openSync','closeSync','eml-format','fast-json-patch','request-promise','moment','bluebird','util','sox','ejs','fs-extra','lodash','squel','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','status','json','undefined','limit','offset','count','set','Content-Range','apply','reject','save','update','then','get','UserProfileResource','destroy','end','sendStatus','error'];(function(_0x2f4f07,_0x554421){var _0x58721c=function(_0x270f72){while(--_0x270f72){_0x2f4f07['push'](_0x2f4f07['shift']());}};_0x58721c(++_0x554421);}(_0xbb00,0x1d9));var _0x0bb0=function(_0x46a38b,_0x16ffb5){_0x46a38b=_0x46a38b-0x0;var _0x346e75=_0xbb00[_0x46a38b];return _0x346e75;};'use strict';var emlformat=require(_0x0bb0('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0x0bb0('0x1'));var rp=require(_0x0bb0('0x2'));var moment=require(_0x0bb0('0x3'));var BPromise=require(_0x0bb0('0x4'));var Mustache=require('mustache');var util=require(_0x0bb0('0x5'));var path=require('path');var sox=require(_0x0bb0('0x6'));var csv=require('to-csv');var ejs=require(_0x0bb0('0x7'));var fs=require('fs');var fs_extra=require(_0x0bb0('0x8'));var _=require(_0x0bb0('0x9'));var squel=require(_0x0bb0('0xa'));var crypto=require('crypto');var jsforce=require(_0x0bb0('0xb'));var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require(_0x0bb0('0xc'));var Papa=require(_0x0bb0('0xd'));var Redis=require(_0x0bb0('0xe'));var authService=require(_0x0bb0('0xf'));var qs=require(_0x0bb0('0x10'));var as=require(_0x0bb0('0x11'));var hardwareService=require(_0x0bb0('0x12'));var logger=require(_0x0bb0('0x13'))(_0x0bb0('0x14'));var utils=require(_0x0bb0('0x15'));var config=require(_0x0bb0('0x16'));var licenseUtil=require(_0x0bb0('0x17'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x866313,_0x4ec80c){_0x4ec80c=_0x4ec80c||0xcc;return function(_0x1147fa){if(_0x1147fa){return _0x866313['sendStatus'](_0x4ec80c);}return _0x866313['status'](_0x4ec80c)['end']();};}function respondWithResult(_0xfa5237,_0x33eff2){_0x33eff2=_0x33eff2||0xc8;return function(_0x162f75){if(_0x162f75){return _0xfa5237[_0x0bb0('0x18')](_0x33eff2)[_0x0bb0('0x19')](_0x162f75);}};}function respondWithFilteredResult(_0x21d0e7,_0xde7f57){return function(_0x2ba398){if(_0x2ba398){var _0x14a8ac=typeof _0xde7f57['offset']===_0x0bb0('0x1a')&&typeof _0xde7f57[_0x0bb0('0x1b')]===_0x0bb0('0x1a');var _0x456743=_0x2ba398['count'];var _0x3ad870=_0x14a8ac?0x0:_0xde7f57[_0x0bb0('0x1c')];var _0x15b218=_0x14a8ac?_0x2ba398[_0x0bb0('0x1d')]:_0xde7f57[_0x0bb0('0x1c')]+_0xde7f57['limit'];var _0x54da55;if(_0x15b218>=_0x456743){_0x15b218=_0x456743;_0x54da55=0xc8;}else{_0x54da55=0xce;}_0x21d0e7[_0x0bb0('0x18')](_0x54da55);return _0x21d0e7[_0x0bb0('0x1e')](_0x0bb0('0x1f'),_0x3ad870+'-'+_0x15b218+'/'+_0x456743)[_0x0bb0('0x19')](_0x2ba398);}return null;};}function patchUpdates(_0x2dd964){return function(_0xc4b506){try{jsonpatch[_0x0bb0('0x20')](_0xc4b506,_0x2dd964,!![]);}catch(_0x23b55b){return BPromise[_0x0bb0('0x21')](_0x23b55b);}return _0xc4b506[_0x0bb0('0x22')]();};}function saveUpdates(_0x4c2aca,_0x1fc3fa){return function(_0x408218){if(_0x408218){return _0x408218[_0x0bb0('0x23')](_0x4c2aca)[_0x0bb0('0x24')](function(_0x382f0f){return _0x382f0f;});}return null;};}function removeEntity(_0x5b2b81,_0x3de61a){return function(_0xd88286){if(_0xd88286){return _0xd88286['destroy']()[_0x0bb0('0x24')](function(){var _0x5402fe=_0xd88286[_0x0bb0('0x25')]({'plain':!![]});var _0x2c30a6='ODBC';return db[_0x0bb0('0x26')][_0x0bb0('0x27')]({'where':{'type':_0x2c30a6,'resourceId':_0x5402fe['id']}})[_0x0bb0('0x24')](function(){return _0xd88286;});})['then'](function(){_0x5b2b81[_0x0bb0('0x18')](0xcc)[_0x0bb0('0x28')]();});}};}function handleEntityNotFound(_0x579654,_0x1eac73){return function(_0x32a92a){if(!_0x32a92a){_0x579654[_0x0bb0('0x29')](0x194);}return _0x32a92a;};}function handleError(_0x6d1240,_0xe0d216){_0xe0d216=_0xe0d216||0x1f4;return function(_0x1258f6){logger[_0x0bb0('0x2a')](_0x1258f6['stack']);if(_0x1258f6[_0x0bb0('0x2b')]){delete _0x1258f6['name'];}_0x6d1240['status'](_0xe0d216)[_0x0bb0('0x2c')](_0x1258f6);};}exports['index']=function(_0x81bd11,_0x4aec35){var _0x262666={},_0x1c4063={},_0x4867a5={'count':0x0,'rows':[]};var _0x5056b1=_[_0x0bb0('0x2d')](db['SquareOdbc'][_0x0bb0('0x2e')],function(_0x5737e4){return{'name':_0x5737e4['fieldName'],'type':_0x5737e4[_0x0bb0('0x2f')][_0x0bb0('0x30')]};});_0x1c4063[_0x0bb0('0x31')]=_[_0x0bb0('0x2d')](_0x5056b1,_0x0bb0('0x2b'));_0x1c4063[_0x0bb0('0x32')]=_['keys'](_0x81bd11[_0x0bb0('0x32')]);_0x1c4063[_0x0bb0('0x33')]=_[_0x0bb0('0x34')](_0x1c4063[_0x0bb0('0x31')],_0x1c4063['query']);_0x262666[_0x0bb0('0x35')]=_[_0x0bb0('0x34')](_0x1c4063[_0x0bb0('0x31')],qs[_0x0bb0('0x36')](_0x81bd11[_0x0bb0('0x32')][_0x0bb0('0x36')]));_0x262666[_0x0bb0('0x35')]=_0x262666[_0x0bb0('0x35')]['length']?_0x262666[_0x0bb0('0x35')]:_0x1c4063[_0x0bb0('0x31')];if(!_0x81bd11[_0x0bb0('0x32')][_0x0bb0('0x37')]('nolimit')){_0x262666[_0x0bb0('0x1b')]=qs['limit'](_0x81bd11['query'][_0x0bb0('0x1b')]);_0x262666['offset']=qs[_0x0bb0('0x1c')](_0x81bd11[_0x0bb0('0x32')][_0x0bb0('0x1c')]);}_0x262666[_0x0bb0('0x38')]=qs[_0x0bb0('0x39')](_0x81bd11[_0x0bb0('0x32')][_0x0bb0('0x39')]);_0x262666[_0x0bb0('0x3a')]=qs[_0x0bb0('0x33')](_['pick'](_0x81bd11[_0x0bb0('0x32')],_0x1c4063['filters']),_0x5056b1);if(_0x81bd11['query'][_0x0bb0('0x3b')]){_0x262666[_0x0bb0('0x3a')]=_['merge'](_0x262666[_0x0bb0('0x3a')],{'$or':_[_0x0bb0('0x2d')](_0x5056b1,function(_0x36d776){if(_0x36d776[_0x0bb0('0x2f')]!=='VIRTUAL'){var _0x347836={};_0x347836[_0x36d776[_0x0bb0('0x2b')]]={'$like':'%'+_0x81bd11[_0x0bb0('0x32')]['filter']+'%'};return _0x347836;}})});}_0x262666=_[_0x0bb0('0x3c')]({},_0x262666,_0x81bd11['options']);var _0x4a405c={'where':_0x262666[_0x0bb0('0x3a')]};return db[_0x0bb0('0x3d')][_0x0bb0('0x1d')](_0x4a405c)['then'](function(_0x5c0574){_0x4867a5['count']=_0x5c0574;if(_0x81bd11[_0x0bb0('0x32')][_0x0bb0('0x3e')]){_0x262666[_0x0bb0('0x3f')]=[{'all':!![]}];}return db['SquareOdbc'][_0x0bb0('0x40')](_0x262666);})[_0x0bb0('0x24')](function(_0x1961a3){_0x4867a5[_0x0bb0('0x41')]=_0x1961a3;return _0x4867a5;})[_0x0bb0('0x24')](respondWithFilteredResult(_0x4aec35,_0x262666))[_0x0bb0('0x42')](handleError(_0x4aec35,null));};exports[_0x0bb0('0x43')]=function(_0x42ba36,_0x40acb1){var _0x4e4ebb={'raw':!![],'where':{'id':_0x42ba36[_0x0bb0('0x44')]['id']}},_0x19692c={};_0x19692c[_0x0bb0('0x31')]=_[_0x0bb0('0x45')](db[_0x0bb0('0x3d')]['rawAttributes']);_0x19692c[_0x0bb0('0x32')]=_[_0x0bb0('0x45')](_0x42ba36[_0x0bb0('0x32')]);_0x19692c['filters']=_[_0x0bb0('0x34')](_0x19692c[_0x0bb0('0x31')],_0x19692c[_0x0bb0('0x32')]);_0x4e4ebb[_0x0bb0('0x35')]=_[_0x0bb0('0x34')](_0x19692c[_0x0bb0('0x31')],qs[_0x0bb0('0x36')](_0x42ba36[_0x0bb0('0x32')][_0x0bb0('0x36')]));_0x4e4ebb['attributes']=_0x4e4ebb[_0x0bb0('0x35')][_0x0bb0('0x46')]?_0x4e4ebb[_0x0bb0('0x35')]:_0x19692c['model'];if(_0x42ba36[_0x0bb0('0x32')][_0x0bb0('0x3e')]){_0x4e4ebb[_0x0bb0('0x3f')]=[{'all':!![]}];}_0x4e4ebb=_[_0x0bb0('0x3c')]({},_0x4e4ebb,_0x42ba36['options']);return db[_0x0bb0('0x3d')][_0x0bb0('0x47')](_0x4e4ebb)[_0x0bb0('0x24')](handleEntityNotFound(_0x40acb1,null))['then'](respondWithResult(_0x40acb1,null))[_0x0bb0('0x42')](handleError(_0x40acb1,null));};exports[_0x0bb0('0x48')]=function(_0x35b863,_0x5e1f56){return db[_0x0bb0('0x3d')][_0x0bb0('0x48')](_0x35b863[_0x0bb0('0x49')],{})[_0x0bb0('0x24')](function(_0x4ad79d){var _0x455a88=_0x35b863[_0x0bb0('0x4a')][_0x0bb0('0x25')]({'plain':!![]});if(!_0x455a88)throw new Error(_0x0bb0('0x4b'));if(_0x455a88['role']==='user'){var _0x4c081d=_0x4ad79d['get']({'plain':!![]});var _0x21e1b9=_0x0bb0('0x4c');return db[_0x0bb0('0x4d')][_0x0bb0('0x47')]({'where':{'name':_0x21e1b9,'userProfileId':_0x455a88[_0x0bb0('0x4e')]},'raw':!![]})[_0x0bb0('0x24')](function(_0x2e2e4f){if(_0x2e2e4f&&_0x2e2e4f[_0x0bb0('0x4f')]===0x0){return db['UserProfileResource']['create']({'name':_0x4c081d[_0x0bb0('0x2b')],'resourceId':_0x4c081d['id'],'type':_0x2e2e4f[_0x0bb0('0x2b')],'sectionId':_0x2e2e4f['id']},{})[_0x0bb0('0x24')](function(){return _0x4ad79d;});}else{return _0x4ad79d;}})['catch'](function(_0x37b7c4){logger[_0x0bb0('0x2a')](_0x0bb0('0x50'),_0x37b7c4);throw _0x37b7c4;});}return _0x4ad79d;})[_0x0bb0('0x24')](respondWithResult(_0x5e1f56,0xc9))['catch'](handleError(_0x5e1f56,null));};exports[_0x0bb0('0x23')]=function(_0x543ab2,_0x537e6d){if(_0x543ab2[_0x0bb0('0x49')]['id']){delete _0x543ab2['body']['id'];}return db[_0x0bb0('0x3d')][_0x0bb0('0x47')]({'where':{'id':_0x543ab2[_0x0bb0('0x44')]['id']}})[_0x0bb0('0x24')](handleEntityNotFound(_0x537e6d,null))[_0x0bb0('0x24')](saveUpdates(_0x543ab2['body'],null))[_0x0bb0('0x24')](respondWithResult(_0x537e6d,null))[_0x0bb0('0x42')](handleError(_0x537e6d,null));};exports[_0x0bb0('0x27')]=function(_0x26ff9a,_0x5ed5cb){return db[_0x0bb0('0x3d')][_0x0bb0('0x47')]({'where':{'id':_0x26ff9a[_0x0bb0('0x44')]['id']}})['then'](handleEntityNotFound(_0x5ed5cb,null))['then'](removeEntity(_0x5ed5cb,null))['catch'](handleError(_0x5ed5cb,null));};exports[_0x0bb0('0x51')]=function(_0x165183,_0x3b8093,_0x50dd84){var _0x4bfb4c;return db[_0x0bb0('0x3d')][_0x0bb0('0x47')]({'where':{'id':_0x165183[_0x0bb0('0x44')]['id']},'attributes':['id',_0x0bb0('0x52')]})[_0x0bb0('0x24')](handleEntityNotFound(_0x3b8093,null))[_0x0bb0('0x24')](function(_0x2a6b34){if(_0x2a6b34){var _0x3e22d0=require(_0x0bb0('0x53'))();_0x3e22d0[_0x0bb0('0x54')](_0x2a6b34[_0x0bb0('0x52')]);_0x3e22d0[_0x0bb0('0x55')]();return _0x2a6b34;}})[_0x0bb0('0x24')](respondWithResult(_0x3b8093,null))[_0x0bb0('0x42')](handleError(_0x3b8093,null));};
\ No newline at end of file
+var _0x6934=['VIRTUAL','options','includeAll','include','findAll','rows','catch','show','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','ODBC','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','test','dsn','closeSync','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','sox','to-csv','ejs','fs-extra','squel','crypto','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','sendStatus','status','json','offset','undefined','count','limit','Content-Range','apply','reject','save','update','destroy','then','get','UserProfileResource','end','error','stack','name','index','map','SquareOdbc','rawAttributes','fieldName','type','key','model','query','keys','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','merge'];(function(_0x478414,_0xcf142d){var _0x5eb6b9=function(_0x10e6fe){while(--_0x10e6fe){_0x478414['push'](_0x478414['shift']());}};_0x5eb6b9(++_0xcf142d);}(_0x6934,0x17a));var _0x4693=function(_0x20244e,_0xfdbcb2){_0x20244e=_0x20244e-0x0;var _0x4fa6de=_0x6934[_0x20244e];return _0x4fa6de;};'use strict';var emlformat=require(_0x4693('0x0'));var rimraf=require(_0x4693('0x1'));var zipdir=require(_0x4693('0x2'));var jsonpatch=require(_0x4693('0x3'));var rp=require('request-promise');var moment=require(_0x4693('0x4'));var BPromise=require(_0x4693('0x5'));var Mustache=require(_0x4693('0x6'));var util=require(_0x4693('0x7'));var path=require('path');var sox=require(_0x4693('0x8'));var csv=require(_0x4693('0x9'));var ejs=require(_0x4693('0xa'));var fs=require('fs');var fs_extra=require(_0x4693('0xb'));var _=require('lodash');var squel=require(_0x4693('0xc'));var crypto=require(_0x4693('0xd'));var jsforce=require('jsforce');var deskjs=require(_0x4693('0xe'));var toCsv=require(_0x4693('0x9'));var querystring=require('querystring');var Papa=require(_0x4693('0xf'));var Redis=require(_0x4693('0x10'));var authService=require(_0x4693('0x11'));var qs=require(_0x4693('0x12'));var as=require(_0x4693('0x13'));var hardwareService=require(_0x4693('0x14'));var logger=require(_0x4693('0x15'))(_0x4693('0x16'));var utils=require(_0x4693('0x17'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x53402f,_0x1fcd34){_0x1fcd34=_0x1fcd34||0xcc;return function(_0x41a1f9){if(_0x41a1f9){return _0x53402f[_0x4693('0x18')](_0x1fcd34);}return _0x53402f['status'](_0x1fcd34)['end']();};}function respondWithResult(_0x3d45b2,_0x179dee){_0x179dee=_0x179dee||0xc8;return function(_0x3109c7){if(_0x3109c7){return _0x3d45b2[_0x4693('0x19')](_0x179dee)[_0x4693('0x1a')](_0x3109c7);}};}function respondWithFilteredResult(_0x350f13,_0x516e04){return function(_0x4c408f){if(_0x4c408f){var _0x1c780a=typeof _0x516e04[_0x4693('0x1b')]===_0x4693('0x1c')&&typeof _0x516e04['limit']===_0x4693('0x1c');var _0x2be0f9=_0x4c408f[_0x4693('0x1d')];var _0x29eb6d=_0x1c780a?0x0:_0x516e04[_0x4693('0x1b')];var _0x191d51=_0x1c780a?_0x4c408f[_0x4693('0x1d')]:_0x516e04[_0x4693('0x1b')]+_0x516e04[_0x4693('0x1e')];var _0x2f25f3;if(_0x191d51>=_0x2be0f9){_0x191d51=_0x2be0f9;_0x2f25f3=0xc8;}else{_0x2f25f3=0xce;}_0x350f13[_0x4693('0x19')](_0x2f25f3);return _0x350f13['set'](_0x4693('0x1f'),_0x29eb6d+'-'+_0x191d51+'/'+_0x2be0f9)[_0x4693('0x1a')](_0x4c408f);}return null;};}function patchUpdates(_0x8d7b26){return function(_0x148a6c){try{jsonpatch[_0x4693('0x20')](_0x148a6c,_0x8d7b26,!![]);}catch(_0x444490){return BPromise[_0x4693('0x21')](_0x444490);}return _0x148a6c[_0x4693('0x22')]();};}function saveUpdates(_0x1d831e,_0x552f35){return function(_0x9d171){if(_0x9d171){return _0x9d171[_0x4693('0x23')](_0x1d831e)['then'](function(_0x3f13ec){return _0x3f13ec;});}return null;};}function removeEntity(_0x137829,_0x3cd922){return function(_0x2fed8b){if(_0x2fed8b){return _0x2fed8b[_0x4693('0x24')]()[_0x4693('0x25')](function(){var _0x13018c=_0x2fed8b[_0x4693('0x26')]({'plain':!![]});var _0x2ab6b5='ODBC';return db[_0x4693('0x27')][_0x4693('0x24')]({'where':{'type':_0x2ab6b5,'resourceId':_0x13018c['id']}})[_0x4693('0x25')](function(){return _0x2fed8b;});})[_0x4693('0x25')](function(){_0x137829['status'](0xcc)[_0x4693('0x28')]();});}};}function handleEntityNotFound(_0x4068b0,_0x4ac231){return function(_0x21adf6){if(!_0x21adf6){_0x4068b0[_0x4693('0x18')](0x194);}return _0x21adf6;};}function handleError(_0x430a8c,_0x5319bb){_0x5319bb=_0x5319bb||0x1f4;return function(_0x7f28f0){logger[_0x4693('0x29')](_0x7f28f0[_0x4693('0x2a')]);if(_0x7f28f0[_0x4693('0x2b')]){delete _0x7f28f0[_0x4693('0x2b')];}_0x430a8c['status'](_0x5319bb)['send'](_0x7f28f0);};}exports[_0x4693('0x2c')]=function(_0x1a2f6a,_0x341739){var _0x32dcb1={},_0x378c6b={},_0x42d5e6={'count':0x0,'rows':[]};var _0x1c6a1d=_[_0x4693('0x2d')](db[_0x4693('0x2e')][_0x4693('0x2f')],function(_0x1b1d8a){return{'name':_0x1b1d8a[_0x4693('0x30')],'type':_0x1b1d8a[_0x4693('0x31')][_0x4693('0x32')]};});_0x378c6b[_0x4693('0x33')]=_[_0x4693('0x2d')](_0x1c6a1d,_0x4693('0x2b'));_0x378c6b[_0x4693('0x34')]=_[_0x4693('0x35')](_0x1a2f6a[_0x4693('0x34')]);_0x378c6b['filters']=_[_0x4693('0x36')](_0x378c6b[_0x4693('0x33')],_0x378c6b[_0x4693('0x34')]);_0x32dcb1['attributes']=_[_0x4693('0x36')](_0x378c6b[_0x4693('0x33')],qs[_0x4693('0x37')](_0x1a2f6a[_0x4693('0x34')][_0x4693('0x37')]));_0x32dcb1['attributes']=_0x32dcb1[_0x4693('0x38')][_0x4693('0x39')]?_0x32dcb1[_0x4693('0x38')]:_0x378c6b['model'];if(!_0x1a2f6a[_0x4693('0x34')][_0x4693('0x3a')](_0x4693('0x3b'))){_0x32dcb1[_0x4693('0x1e')]=qs[_0x4693('0x1e')](_0x1a2f6a['query']['limit']);_0x32dcb1[_0x4693('0x1b')]=qs[_0x4693('0x1b')](_0x1a2f6a['query'][_0x4693('0x1b')]);}_0x32dcb1[_0x4693('0x3c')]=qs[_0x4693('0x3d')](_0x1a2f6a['query']['sort']);_0x32dcb1[_0x4693('0x3e')]=qs[_0x4693('0x3f')](_[_0x4693('0x40')](_0x1a2f6a[_0x4693('0x34')],_0x378c6b[_0x4693('0x3f')]),_0x1c6a1d);if(_0x1a2f6a['query'][_0x4693('0x41')]){_0x32dcb1['where']=_[_0x4693('0x42')](_0x32dcb1[_0x4693('0x3e')],{'$or':_[_0x4693('0x2d')](_0x1c6a1d,function(_0x368f6b){if(_0x368f6b[_0x4693('0x31')]!==_0x4693('0x43')){var _0x3445a5={};_0x3445a5[_0x368f6b['name']]={'$like':'%'+_0x1a2f6a[_0x4693('0x34')][_0x4693('0x41')]+'%'};return _0x3445a5;}})});}_0x32dcb1=_[_0x4693('0x42')]({},_0x32dcb1,_0x1a2f6a[_0x4693('0x44')]);var _0x2c4dd0={'where':_0x32dcb1['where']};return db[_0x4693('0x2e')][_0x4693('0x1d')](_0x2c4dd0)[_0x4693('0x25')](function(_0x423f26){_0x42d5e6['count']=_0x423f26;if(_0x1a2f6a[_0x4693('0x34')][_0x4693('0x45')]){_0x32dcb1[_0x4693('0x46')]=[{'all':!![]}];}return db[_0x4693('0x2e')][_0x4693('0x47')](_0x32dcb1);})['then'](function(_0x1511f5){_0x42d5e6[_0x4693('0x48')]=_0x1511f5;return _0x42d5e6;})[_0x4693('0x25')](respondWithFilteredResult(_0x341739,_0x32dcb1))[_0x4693('0x49')](handleError(_0x341739,null));};exports[_0x4693('0x4a')]=function(_0x970454,_0x2e46d6){var _0x58c2e8={'raw':!![],'where':{'id':_0x970454['params']['id']}},_0x5ccea0={};_0x5ccea0[_0x4693('0x33')]=_['keys'](db[_0x4693('0x2e')][_0x4693('0x2f')]);_0x5ccea0[_0x4693('0x34')]=_['keys'](_0x970454['query']);_0x5ccea0[_0x4693('0x3f')]=_[_0x4693('0x36')](_0x5ccea0[_0x4693('0x33')],_0x5ccea0[_0x4693('0x34')]);_0x58c2e8['attributes']=_[_0x4693('0x36')](_0x5ccea0[_0x4693('0x33')],qs[_0x4693('0x37')](_0x970454['query']['fields']));_0x58c2e8[_0x4693('0x38')]=_0x58c2e8['attributes']['length']?_0x58c2e8[_0x4693('0x38')]:_0x5ccea0[_0x4693('0x33')];if(_0x970454[_0x4693('0x34')][_0x4693('0x45')]){_0x58c2e8[_0x4693('0x46')]=[{'all':!![]}];}_0x58c2e8=_[_0x4693('0x42')]({},_0x58c2e8,_0x970454[_0x4693('0x44')]);return db[_0x4693('0x2e')][_0x4693('0x4b')](_0x58c2e8)[_0x4693('0x25')](handleEntityNotFound(_0x2e46d6,null))[_0x4693('0x25')](respondWithResult(_0x2e46d6,null))[_0x4693('0x49')](handleError(_0x2e46d6,null));};exports[_0x4693('0x4c')]=function(_0x4db94c,_0x25c923){return db[_0x4693('0x2e')]['create'](_0x4db94c[_0x4693('0x4d')],{})['then'](function(_0xc7a031){var _0x919558=_0x4db94c[_0x4693('0x4e')][_0x4693('0x26')]({'plain':!![]});if(!_0x919558)throw new Error(_0x4693('0x4f'));if(_0x919558[_0x4693('0x50')]===_0x4693('0x4e')){var _0x449717=_0xc7a031[_0x4693('0x26')]({'plain':!![]});var _0x34c110=_0x4693('0x51');return db['UserProfileSection'][_0x4693('0x4b')]({'where':{'name':_0x34c110,'userProfileId':_0x919558[_0x4693('0x52')]},'raw':!![]})[_0x4693('0x25')](function(_0xb93840){if(_0xb93840&&_0xb93840[_0x4693('0x53')]===0x0){return db[_0x4693('0x27')]['create']({'name':_0x449717[_0x4693('0x2b')],'resourceId':_0x449717['id'],'type':_0xb93840[_0x4693('0x2b')],'sectionId':_0xb93840['id']},{})['then'](function(){return _0xc7a031;});}else{return _0xc7a031;}})[_0x4693('0x49')](function(_0x13da59){logger[_0x4693('0x29')](_0x4693('0x54'),_0x13da59);throw _0x13da59;});}return _0xc7a031;})[_0x4693('0x25')](respondWithResult(_0x25c923,0xc9))['catch'](handleError(_0x25c923,null));};exports['update']=function(_0xcaddbd,_0x50780d){if(_0xcaddbd[_0x4693('0x4d')]['id']){delete _0xcaddbd[_0x4693('0x4d')]['id'];}return db[_0x4693('0x2e')][_0x4693('0x4b')]({'where':{'id':_0xcaddbd[_0x4693('0x55')]['id']}})[_0x4693('0x25')](handleEntityNotFound(_0x50780d,null))[_0x4693('0x25')](saveUpdates(_0xcaddbd[_0x4693('0x4d')],null))[_0x4693('0x25')](respondWithResult(_0x50780d,null))['catch'](handleError(_0x50780d,null));};exports[_0x4693('0x24')]=function(_0x108459,_0x25395f){return db[_0x4693('0x2e')][_0x4693('0x4b')]({'where':{'id':_0x108459['params']['id']}})[_0x4693('0x25')](handleEntityNotFound(_0x25395f,null))[_0x4693('0x25')](removeEntity(_0x25395f,null))['catch'](handleError(_0x25395f,null));};exports[_0x4693('0x56')]=function(_0x44f473,_0x419e2b,_0x5170dc){var _0x534f96;return db['SquareOdbc']['find']({'where':{'id':_0x44f473['params']['id']},'attributes':['id','dsn']})[_0x4693('0x25')](handleEntityNotFound(_0x419e2b,null))[_0x4693('0x25')](function(_0x911ae){if(_0x911ae){var _0x2cfe31=require('odbc')();_0x2cfe31['openSync'](_0x911ae[_0x4693('0x57')]);_0x2cfe31[_0x4693('0x58')]();return _0x911ae;}})[_0x4693('0x25')](respondWithResult(_0x419e2b,null))[_0x4693('0x49')](handleError(_0x419e2b,null));};
\ No newline at end of file