Built motion from commit (unavailable).|2.6.0
[motion2.git] / server / api / squareOdbc / squareOdbc.controller.js
index 8e09be6..cb8b09e 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x5f5d=['type','key','model','query','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','includeAll','rows','catch','show','params','keys','include','find','create','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','test','dsn','openSync','closeSync','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','sox','to-csv','ejs','lodash','squel','crypto','jsforce','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../mysqldb','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','destroy','then','ODBC','UserProfileResource','sendStatus','error','stack','name','send','index','map','SquareOdbc','rawAttributes','fieldName'];(function(_0x40c611,_0x13febe){var _0x126bc0=function(_0x671904){while(--_0x671904){_0x40c611['push'](_0x40c611['shift']());}};_0x126bc0(++_0x13febe);}(_0x5f5d,0xd5));var _0xd5f5=function(_0x1cbe27,_0x39d008){_0x1cbe27=_0x1cbe27-0x0;var _0x1bb6bc=_0x5f5d[_0x1cbe27];return _0x1bb6bc;};'use strict';var emlformat=require(_0xd5f5('0x0'));var rimraf=require(_0xd5f5('0x1'));var zipdir=require(_0xd5f5('0x2'));var jsonpatch=require(_0xd5f5('0x3'));var rp=require('request-promise');var moment=require(_0xd5f5('0x4'));var BPromise=require(_0xd5f5('0x5'));var Mustache=require(_0xd5f5('0x6'));var util=require(_0xd5f5('0x7'));var path=require('path');var sox=require(_0xd5f5('0x8'));var csv=require(_0xd5f5('0x9'));var ejs=require(_0xd5f5('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xd5f5('0xb'));var squel=require(_0xd5f5('0xc'));var crypto=require(_0xd5f5('0xd'));var jsforce=require(_0xd5f5('0xe'));var deskjs=require('desk.js');var toCsv=require(_0xd5f5('0x9'));var querystring=require(_0xd5f5('0xf'));var Papa=require(_0xd5f5('0x10'));var Redis=require('ioredis');var authService=require(_0xd5f5('0x11'));var qs=require(_0xd5f5('0x12'));var as=require(_0xd5f5('0x13'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xd5f5('0x14'))(_0xd5f5('0x15'));var utils=require(_0xd5f5('0x16'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0xd5f5('0x17'))['db'];function respondWithStatusCode(_0x4ff006,_0x5717fc){_0x5717fc=_0x5717fc||0xcc;return function(_0x581f12){if(_0x581f12){return _0x4ff006['sendStatus'](_0x5717fc);}return _0x4ff006[_0xd5f5('0x18')](_0x5717fc)[_0xd5f5('0x19')]();};}function respondWithResult(_0x2991ed,_0x56a7b1){_0x56a7b1=_0x56a7b1||0xc8;return function(_0xe5ec83){if(_0xe5ec83){return _0x2991ed[_0xd5f5('0x18')](_0x56a7b1)[_0xd5f5('0x1a')](_0xe5ec83);}};}function respondWithFilteredResult(_0x1bb516,_0x474fcc){return function(_0x3eb49a){if(_0x3eb49a){var _0x16bf5b=typeof _0x474fcc[_0xd5f5('0x1b')]===_0xd5f5('0x1c')&&typeof _0x474fcc[_0xd5f5('0x1d')]===_0xd5f5('0x1c');var _0x2b0d2b=_0x3eb49a[_0xd5f5('0x1e')];var _0x1e3eae=_0x16bf5b?0x0:_0x474fcc[_0xd5f5('0x1b')];var _0x31720a=_0x16bf5b?_0x3eb49a[_0xd5f5('0x1e')]:_0x474fcc[_0xd5f5('0x1b')]+_0x474fcc[_0xd5f5('0x1d')];var _0x14ad33;if(_0x31720a>=_0x2b0d2b){_0x31720a=_0x2b0d2b;_0x14ad33=0xc8;}else{_0x14ad33=0xce;}_0x1bb516['status'](_0x14ad33);return _0x1bb516[_0xd5f5('0x1f')](_0xd5f5('0x20'),_0x1e3eae+'-'+_0x31720a+'/'+_0x2b0d2b)[_0xd5f5('0x1a')](_0x3eb49a);}return null;};}function patchUpdates(_0x16ef2d){return function(_0x57cee3){try{jsonpatch[_0xd5f5('0x21')](_0x57cee3,_0x16ef2d,!![]);}catch(_0x1e8e90){return BPromise[_0xd5f5('0x22')](_0x1e8e90);}return _0x57cee3[_0xd5f5('0x23')]();};}function saveUpdates(_0x314a42,_0x42afa){return function(_0x547bdf){if(_0x547bdf){return _0x547bdf[_0xd5f5('0x24')](_0x314a42)['then'](function(_0x252a82){return _0x252a82;});}return null;};}function removeEntity(_0x23a1e3,_0x503163){return function(_0x4383da){if(_0x4383da){return _0x4383da[_0xd5f5('0x25')]()[_0xd5f5('0x26')](function(){var _0x28ed51=_0x4383da['get']({'plain':!![]});var _0x2d49e4=_0xd5f5('0x27');return db[_0xd5f5('0x28')]['destroy']({'where':{'type':_0x2d49e4,'resourceId':_0x28ed51['id']}})[_0xd5f5('0x26')](function(){return _0x4383da;});})[_0xd5f5('0x26')](function(){_0x23a1e3['status'](0xcc)[_0xd5f5('0x19')]();});}};}function handleEntityNotFound(_0x524f60,_0x15d486){return function(_0x196fbd){if(!_0x196fbd){_0x524f60[_0xd5f5('0x29')](0x194);}return _0x196fbd;};}function handleError(_0x22fe01,_0x5a6032){_0x5a6032=_0x5a6032||0x1f4;return function(_0xe81a8e){logger[_0xd5f5('0x2a')](_0xe81a8e[_0xd5f5('0x2b')]);if(_0xe81a8e[_0xd5f5('0x2c')]){delete _0xe81a8e['name'];}_0x22fe01['status'](_0x5a6032)[_0xd5f5('0x2d')](_0xe81a8e);};}exports[_0xd5f5('0x2e')]=function(_0x535aa2,_0x5432b1){var _0x283156={},_0x1eb182={},_0x31f9a6={'count':0x0,'rows':[]};var _0x25423f=_[_0xd5f5('0x2f')](db[_0xd5f5('0x30')][_0xd5f5('0x31')],function(_0x393e8b){return{'name':_0x393e8b[_0xd5f5('0x32')],'type':_0x393e8b[_0xd5f5('0x33')][_0xd5f5('0x34')]};});_0x1eb182[_0xd5f5('0x35')]=_[_0xd5f5('0x2f')](_0x25423f,_0xd5f5('0x2c'));_0x1eb182[_0xd5f5('0x36')]=_['keys'](_0x535aa2[_0xd5f5('0x36')]);_0x1eb182[_0xd5f5('0x37')]=_['intersection'](_0x1eb182[_0xd5f5('0x35')],_0x1eb182['query']);_0x283156['attributes']=_[_0xd5f5('0x38')](_0x1eb182[_0xd5f5('0x35')],qs[_0xd5f5('0x39')](_0x535aa2[_0xd5f5('0x36')][_0xd5f5('0x39')]));_0x283156['attributes']=_0x283156[_0xd5f5('0x3a')][_0xd5f5('0x3b')]?_0x283156[_0xd5f5('0x3a')]:_0x1eb182[_0xd5f5('0x35')];if(!_0x535aa2[_0xd5f5('0x36')][_0xd5f5('0x3c')](_0xd5f5('0x3d'))){_0x283156[_0xd5f5('0x1d')]=qs[_0xd5f5('0x1d')](_0x535aa2[_0xd5f5('0x36')][_0xd5f5('0x1d')]);_0x283156['offset']=qs[_0xd5f5('0x1b')](_0x535aa2[_0xd5f5('0x36')][_0xd5f5('0x1b')]);}_0x283156[_0xd5f5('0x3e')]=qs[_0xd5f5('0x3f')](_0x535aa2[_0xd5f5('0x36')]['sort']);_0x283156[_0xd5f5('0x40')]=qs['filters'](_[_0xd5f5('0x41')](_0x535aa2[_0xd5f5('0x36')],_0x1eb182[_0xd5f5('0x37')]),_0x25423f);if(_0x535aa2['query'][_0xd5f5('0x42')]){_0x283156[_0xd5f5('0x40')]=_[_0xd5f5('0x43')](_0x283156['where'],{'$or':_[_0xd5f5('0x2f')](_0x25423f,function(_0x1fb363){if(_0x1fb363['type']!=='VIRTUAL'){var _0x5d471d={};_0x5d471d[_0x1fb363[_0xd5f5('0x2c')]]={'$like':'%'+_0x535aa2[_0xd5f5('0x36')][_0xd5f5('0x42')]+'%'};return _0x5d471d;}})});}_0x283156=_[_0xd5f5('0x43')]({},_0x283156,_0x535aa2['options']);var _0x1594c9={'where':_0x283156['where']};return db[_0xd5f5('0x30')][_0xd5f5('0x1e')](_0x1594c9)[_0xd5f5('0x26')](function(_0x1f24db){_0x31f9a6['count']=_0x1f24db;if(_0x535aa2[_0xd5f5('0x36')][_0xd5f5('0x44')]){_0x283156['include']=[{'all':!![]}];}return db[_0xd5f5('0x30')]['findAll'](_0x283156);})['then'](function(_0x7ff9f0){_0x31f9a6[_0xd5f5('0x45')]=_0x7ff9f0;return _0x31f9a6;})[_0xd5f5('0x26')](respondWithFilteredResult(_0x5432b1,_0x283156))[_0xd5f5('0x46')](handleError(_0x5432b1,null));};exports[_0xd5f5('0x47')]=function(_0xcb417c,_0x322658){var _0x4bb521={'raw':!![],'where':{'id':_0xcb417c[_0xd5f5('0x48')]['id']}},_0x172171={};_0x172171[_0xd5f5('0x35')]=_['keys'](db[_0xd5f5('0x30')]['rawAttributes']);_0x172171['query']=_[_0xd5f5('0x49')](_0xcb417c['query']);_0x172171[_0xd5f5('0x37')]=_[_0xd5f5('0x38')](_0x172171['model'],_0x172171[_0xd5f5('0x36')]);_0x4bb521[_0xd5f5('0x3a')]=_[_0xd5f5('0x38')](_0x172171[_0xd5f5('0x35')],qs[_0xd5f5('0x39')](_0xcb417c[_0xd5f5('0x36')][_0xd5f5('0x39')]));_0x4bb521[_0xd5f5('0x3a')]=_0x4bb521[_0xd5f5('0x3a')][_0xd5f5('0x3b')]?_0x4bb521[_0xd5f5('0x3a')]:_0x172171['model'];if(_0xcb417c['query'][_0xd5f5('0x44')]){_0x4bb521[_0xd5f5('0x4a')]=[{'all':!![]}];}_0x4bb521=_['merge']({},_0x4bb521,_0xcb417c['options']);return db[_0xd5f5('0x30')][_0xd5f5('0x4b')](_0x4bb521)[_0xd5f5('0x26')](handleEntityNotFound(_0x322658,null))[_0xd5f5('0x26')](respondWithResult(_0x322658,null))[_0xd5f5('0x46')](handleError(_0x322658,null));};exports[_0xd5f5('0x4c')]=function(_0x10bd7e,_0x1466d8){return db['SquareOdbc']['create'](_0x10bd7e['body'],{})[_0xd5f5('0x26')](function(_0x4377f6){var _0x479190=_0x10bd7e[_0xd5f5('0x4d')][_0xd5f5('0x4e')]({'plain':!![]});if(!_0x479190)throw new Error(_0xd5f5('0x4f'));if(_0x479190[_0xd5f5('0x50')]==='user'){var _0x4bdc5c=_0x4377f6[_0xd5f5('0x4e')]({'plain':!![]});var _0x3c1a1e='ODBC';return db['UserProfileSection']['find']({'where':{'name':_0x3c1a1e,'userProfileId':_0x479190['userProfileId']},'raw':!![]})['then'](function(_0x3ee0d4){if(_0x3ee0d4&&_0x3ee0d4[_0xd5f5('0x51')]===0x0){return db[_0xd5f5('0x28')]['create']({'name':_0x4bdc5c[_0xd5f5('0x2c')],'resourceId':_0x4bdc5c['id'],'type':_0x3ee0d4[_0xd5f5('0x2c')],'sectionId':_0x3ee0d4['id']},{})[_0xd5f5('0x26')](function(){return _0x4377f6;});}else{return _0x4377f6;}})[_0xd5f5('0x46')](function(_0x39767b){logger[_0xd5f5('0x2a')](_0xd5f5('0x52'),_0x39767b);throw _0x39767b;});}return _0x4377f6;})[_0xd5f5('0x26')](respondWithResult(_0x1466d8,0xc9))['catch'](handleError(_0x1466d8,null));};exports[_0xd5f5('0x24')]=function(_0x334e9d,_0xf2bb40){if(_0x334e9d[_0xd5f5('0x53')]['id']){delete _0x334e9d['body']['id'];}return db[_0xd5f5('0x30')][_0xd5f5('0x4b')]({'where':{'id':_0x334e9d[_0xd5f5('0x48')]['id']}})[_0xd5f5('0x26')](handleEntityNotFound(_0xf2bb40,null))[_0xd5f5('0x26')](saveUpdates(_0x334e9d[_0xd5f5('0x53')],null))[_0xd5f5('0x26')](respondWithResult(_0xf2bb40,null))['catch'](handleError(_0xf2bb40,null));};exports['destroy']=function(_0x1fd29c,_0x189960){return db[_0xd5f5('0x30')][_0xd5f5('0x4b')]({'where':{'id':_0x1fd29c[_0xd5f5('0x48')]['id']}})[_0xd5f5('0x26')](handleEntityNotFound(_0x189960,null))['then'](removeEntity(_0x189960,null))[_0xd5f5('0x46')](handleError(_0x189960,null));};exports[_0xd5f5('0x54')]=function(_0x5fdbec,_0x36865c,_0x31a3ae){var _0x97cd92;return db[_0xd5f5('0x30')][_0xd5f5('0x4b')]({'where':{'id':_0x5fdbec['params']['id']},'attributes':['id',_0xd5f5('0x55')]})[_0xd5f5('0x26')](handleEntityNotFound(_0x36865c,null))[_0xd5f5('0x26')](function(_0x4ccd8d){if(_0x4ccd8d){var _0x4916c8=require('odbc')();_0x4916c8[_0xd5f5('0x56')](_0x4ccd8d[_0xd5f5('0x55')]);_0x4916c8[_0xd5f5('0x57')]();return _0x4ccd8d;}})[_0xd5f5('0x26')](respondWithResult(_0x36865c,null))['catch'](handleError(_0x36865c,null));};
\ No newline at end of file
+var _0x1725=['update','then','destroy','get','UserProfileResource','error','name','send','map','type','model','query','filters','intersection','attributes','fields','nolimit','order','sort','pick','filter','merge','where','options','includeAll','include','SquareOdbc','findAll','rows','catch','show','rawAttributes','keys','length','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','odbc','openSync','closeSync','eml-format','rimraf','zip-dir','bluebird','mustache','path','sox','to-csv','fs-extra','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save'];(function(_0x422be2,_0x1c439e){var _0x1b820e=function(_0x513cc8){while(--_0x513cc8){_0x422be2['push'](_0x422be2['shift']());}};_0x1b820e(++_0x1c439e);}(_0x1725,0x88));var _0x5172=function(_0x1c31f4,_0x8e8aeb){_0x1c31f4=_0x1c31f4-0x0;var _0x5a3f66=_0x1725[_0x1c31f4];return _0x5a3f66;};'use strict';var emlformat=require(_0x5172('0x0'));var rimraf=require(_0x5172('0x1'));var zipdir=require(_0x5172('0x2'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x5172('0x3'));var Mustache=require(_0x5172('0x4'));var util=require('util');var path=require(_0x5172('0x5'));var sox=require(_0x5172('0x6'));var csv=require(_0x5172('0x7'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x5172('0x8'));var _=require(_0x5172('0x9'));var squel=require('squel');var crypto=require(_0x5172('0xa'));var jsforce=require(_0x5172('0xb'));var deskjs=require(_0x5172('0xc'));var toCsv=require(_0x5172('0x7'));var querystring=require(_0x5172('0xd'));var Papa=require(_0x5172('0xe'));var Redis=require(_0x5172('0xf'));var authService=require('../../components/auth/service');var qs=require(_0x5172('0x10'));var as=require(_0x5172('0x11'));var hardwareService=require(_0x5172('0x12'));var logger=require('../../config/logger')(_0x5172('0x13'));var utils=require(_0x5172('0x14'));var config=require('../../config/environment');var licenseUtil=require(_0x5172('0x15'));var db=require(_0x5172('0x16'))['db'];function respondWithStatusCode(_0x3c0e15,_0x5de304){_0x5de304=_0x5de304||0xcc;return function(_0x1d7119){if(_0x1d7119){return _0x3c0e15[_0x5172('0x17')](_0x5de304);}return _0x3c0e15[_0x5172('0x18')](_0x5de304)[_0x5172('0x19')]();};}function respondWithResult(_0x10aca0,_0x23fdb4){_0x23fdb4=_0x23fdb4||0xc8;return function(_0x34b920){if(_0x34b920){return _0x10aca0[_0x5172('0x18')](_0x23fdb4)[_0x5172('0x1a')](_0x34b920);}};}function respondWithFilteredResult(_0x2af59f,_0x162964){return function(_0x2f9238){if(_0x2f9238){var _0x2712ef=typeof _0x162964[_0x5172('0x1b')]===_0x5172('0x1c')&&typeof _0x162964[_0x5172('0x1d')]==='undefined';var _0x50d4c1=_0x2f9238[_0x5172('0x1e')];var _0x5a944b=_0x2712ef?0x0:_0x162964[_0x5172('0x1b')];var _0x54b95b=_0x2712ef?_0x2f9238[_0x5172('0x1e')]:_0x162964['offset']+_0x162964[_0x5172('0x1d')];var _0x2cf88b;if(_0x54b95b>=_0x50d4c1){_0x54b95b=_0x50d4c1;_0x2cf88b=0xc8;}else{_0x2cf88b=0xce;}_0x2af59f[_0x5172('0x18')](_0x2cf88b);return _0x2af59f[_0x5172('0x1f')](_0x5172('0x20'),_0x5a944b+'-'+_0x54b95b+'/'+_0x50d4c1)[_0x5172('0x1a')](_0x2f9238);}return null;};}function patchUpdates(_0x50d3fe){return function(_0x356c07){try{jsonpatch[_0x5172('0x21')](_0x356c07,_0x50d3fe,!![]);}catch(_0x3ebfd8){return BPromise[_0x5172('0x22')](_0x3ebfd8);}return _0x356c07[_0x5172('0x23')]();};}function saveUpdates(_0x49f017,_0x7b0976){return function(_0x391646){if(_0x391646){return _0x391646[_0x5172('0x24')](_0x49f017)[_0x5172('0x25')](function(_0x46b378){return _0x46b378;});}return null;};}function removeEntity(_0x202f01,_0x257320){return function(_0x303aad){if(_0x303aad){return _0x303aad[_0x5172('0x26')]()[_0x5172('0x25')](function(){var _0x4a8a1d=_0x303aad[_0x5172('0x27')]({'plain':!![]});var _0x4511e7='ODBC';return db[_0x5172('0x28')][_0x5172('0x26')]({'where':{'type':_0x4511e7,'resourceId':_0x4a8a1d['id']}})[_0x5172('0x25')](function(){return _0x303aad;});})[_0x5172('0x25')](function(){_0x202f01[_0x5172('0x18')](0xcc)[_0x5172('0x19')]();});}};}function handleEntityNotFound(_0x4afa6b,_0x5f1db8){return function(_0x3505d7){if(!_0x3505d7){_0x4afa6b[_0x5172('0x17')](0x194);}return _0x3505d7;};}function handleError(_0x2817cd,_0x581c49){_0x581c49=_0x581c49||0x1f4;return function(_0x287be2){logger[_0x5172('0x29')](_0x287be2['stack']);if(_0x287be2[_0x5172('0x2a')]){delete _0x287be2['name'];}_0x2817cd[_0x5172('0x18')](_0x581c49)[_0x5172('0x2b')](_0x287be2);};}exports['index']=function(_0xf3a0c5,_0x57eb65){var _0x17bf2a={},_0x27bf35={},_0x5f387b={'count':0x0,'rows':[]};var _0x44f917=_[_0x5172('0x2c')](db['SquareOdbc']['rawAttributes'],function(_0x4dee2f){return{'name':_0x4dee2f['fieldName'],'type':_0x4dee2f[_0x5172('0x2d')]['key']};});_0x27bf35[_0x5172('0x2e')]=_[_0x5172('0x2c')](_0x44f917,_0x5172('0x2a'));_0x27bf35[_0x5172('0x2f')]=_['keys'](_0xf3a0c5[_0x5172('0x2f')]);_0x27bf35[_0x5172('0x30')]=_[_0x5172('0x31')](_0x27bf35['model'],_0x27bf35[_0x5172('0x2f')]);_0x17bf2a[_0x5172('0x32')]=_[_0x5172('0x31')](_0x27bf35['model'],qs['fields'](_0xf3a0c5[_0x5172('0x2f')][_0x5172('0x33')]));_0x17bf2a['attributes']=_0x17bf2a[_0x5172('0x32')]['length']?_0x17bf2a[_0x5172('0x32')]:_0x27bf35['model'];if(!_0xf3a0c5[_0x5172('0x2f')]['hasOwnProperty'](_0x5172('0x34'))){_0x17bf2a[_0x5172('0x1d')]=qs['limit'](_0xf3a0c5[_0x5172('0x2f')][_0x5172('0x1d')]);_0x17bf2a['offset']=qs['offset'](_0xf3a0c5[_0x5172('0x2f')][_0x5172('0x1b')]);}_0x17bf2a[_0x5172('0x35')]=qs[_0x5172('0x36')](_0xf3a0c5[_0x5172('0x2f')][_0x5172('0x36')]);_0x17bf2a['where']=qs['filters'](_[_0x5172('0x37')](_0xf3a0c5[_0x5172('0x2f')],_0x27bf35[_0x5172('0x30')]),_0x44f917);if(_0xf3a0c5[_0x5172('0x2f')][_0x5172('0x38')]){_0x17bf2a['where']=_[_0x5172('0x39')](_0x17bf2a[_0x5172('0x3a')],{'$or':_[_0x5172('0x2c')](_0x44f917,function(_0x4fde5b){if(_0x4fde5b[_0x5172('0x2d')]!=='VIRTUAL'){var _0x5d3950={};_0x5d3950[_0x4fde5b['name']]={'$like':'%'+_0xf3a0c5[_0x5172('0x2f')]['filter']+'%'};return _0x5d3950;}})});}_0x17bf2a=_[_0x5172('0x39')]({},_0x17bf2a,_0xf3a0c5[_0x5172('0x3b')]);var _0x5511c0={'where':_0x17bf2a[_0x5172('0x3a')]};return db['SquareOdbc'][_0x5172('0x1e')](_0x5511c0)['then'](function(_0x382ebd){_0x5f387b[_0x5172('0x1e')]=_0x382ebd;if(_0xf3a0c5[_0x5172('0x2f')][_0x5172('0x3c')]){_0x17bf2a[_0x5172('0x3d')]=[{'all':!![]}];}return db[_0x5172('0x3e')][_0x5172('0x3f')](_0x17bf2a);})['then'](function(_0x5e6415){_0x5f387b[_0x5172('0x40')]=_0x5e6415;return _0x5f387b;})[_0x5172('0x25')](respondWithFilteredResult(_0x57eb65,_0x17bf2a))[_0x5172('0x41')](handleError(_0x57eb65,null));};exports[_0x5172('0x42')]=function(_0x4b5d3b,_0xe2ed6){var _0x18aa59={'raw':!![],'where':{'id':_0x4b5d3b['params']['id']}},_0x49ac5a={};_0x49ac5a[_0x5172('0x2e')]=_['keys'](db[_0x5172('0x3e')][_0x5172('0x43')]);_0x49ac5a[_0x5172('0x2f')]=_[_0x5172('0x44')](_0x4b5d3b[_0x5172('0x2f')]);_0x49ac5a[_0x5172('0x30')]=_['intersection'](_0x49ac5a['model'],_0x49ac5a[_0x5172('0x2f')]);_0x18aa59[_0x5172('0x32')]=_['intersection'](_0x49ac5a[_0x5172('0x2e')],qs[_0x5172('0x33')](_0x4b5d3b[_0x5172('0x2f')][_0x5172('0x33')]));_0x18aa59['attributes']=_0x18aa59['attributes'][_0x5172('0x45')]?_0x18aa59[_0x5172('0x32')]:_0x49ac5a[_0x5172('0x2e')];if(_0x4b5d3b[_0x5172('0x2f')][_0x5172('0x3c')]){_0x18aa59[_0x5172('0x3d')]=[{'all':!![]}];}_0x18aa59=_[_0x5172('0x39')]({},_0x18aa59,_0x4b5d3b[_0x5172('0x3b')]);return db[_0x5172('0x3e')][_0x5172('0x46')](_0x18aa59)[_0x5172('0x25')](handleEntityNotFound(_0xe2ed6,null))[_0x5172('0x25')](respondWithResult(_0xe2ed6,null))[_0x5172('0x41')](handleError(_0xe2ed6,null));};exports['create']=function(_0x18e17e,_0x33babc){return db['SquareOdbc'][_0x5172('0x47')](_0x18e17e[_0x5172('0x48')],{})[_0x5172('0x25')](function(_0x32b562){var _0x2d8125=_0x18e17e[_0x5172('0x49')]['get']({'plain':!![]});if(!_0x2d8125)throw new Error(_0x5172('0x4a'));if(_0x2d8125[_0x5172('0x4b')]===_0x5172('0x49')){var _0x36e919=_0x32b562[_0x5172('0x27')]({'plain':!![]});var _0x3c6708='ODBC';return db[_0x5172('0x4c')]['find']({'where':{'name':_0x3c6708,'userProfileId':_0x2d8125[_0x5172('0x4d')]},'raw':!![]})[_0x5172('0x25')](function(_0x16899e){if(_0x16899e&&_0x16899e[_0x5172('0x4e')]===0x0){return db[_0x5172('0x28')][_0x5172('0x47')]({'name':_0x36e919['name'],'resourceId':_0x36e919['id'],'type':_0x16899e[_0x5172('0x2a')],'sectionId':_0x16899e['id']},{})[_0x5172('0x25')](function(){return _0x32b562;});}else{return _0x32b562;}})[_0x5172('0x41')](function(_0x1f3326){logger[_0x5172('0x29')](_0x5172('0x4f'),_0x1f3326);throw _0x1f3326;});}return _0x32b562;})[_0x5172('0x25')](respondWithResult(_0x33babc,0xc9))[_0x5172('0x41')](handleError(_0x33babc,null));};exports[_0x5172('0x24')]=function(_0x523846,_0x3ee542){if(_0x523846['body']['id']){delete _0x523846['body']['id'];}return db[_0x5172('0x3e')]['find']({'where':{'id':_0x523846[_0x5172('0x50')]['id']}})['then'](handleEntityNotFound(_0x3ee542,null))[_0x5172('0x25')](saveUpdates(_0x523846[_0x5172('0x48')],null))[_0x5172('0x25')](respondWithResult(_0x3ee542,null))[_0x5172('0x41')](handleError(_0x3ee542,null));};exports['destroy']=function(_0x292461,_0x3f75fa){return db[_0x5172('0x3e')]['find']({'where':{'id':_0x292461[_0x5172('0x50')]['id']}})[_0x5172('0x25')](handleEntityNotFound(_0x3f75fa,null))['then'](removeEntity(_0x3f75fa,null))[_0x5172('0x41')](handleError(_0x3f75fa,null));};exports[_0x5172('0x51')]=function(_0x472163,_0x88494d,_0xdb5829){var _0x8fd20e;return db[_0x5172('0x3e')][_0x5172('0x46')]({'where':{'id':_0x472163[_0x5172('0x50')]['id']},'attributes':['id',_0x5172('0x52')]})[_0x5172('0x25')](handleEntityNotFound(_0x88494d,null))[_0x5172('0x25')](function(_0x353425){if(_0x353425){var _0x9570fb=require(_0x5172('0x53'))();_0x9570fb[_0x5172('0x54')](_0x353425['dsn']);_0x9570fb[_0x5172('0x55')]();return _0x353425;}})[_0x5172('0x25')](respondWithResult(_0x88494d,null))[_0x5172('0x41')](handleError(_0x88494d,null));};
\ No newline at end of file