Built motion from commit b0a9a629.|2.6.33
[motion2.git] / server / api / squareOdbc / squareOdbc.controller.js
index f788917..1dfb45f 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x6957=['get','user','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','destroy','dsn','odbc','openSync','closeSync','eml-format','rimraf','zip-dir','request-promise','moment','mustache','util','path','sox','to-csv','fs-extra','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','end','json','limit','offset','count','set','Content-Range','apply','reject','save','then','ODBC','UserProfileResource','error','stack','name','send','map','SquareOdbc','rawAttributes','fieldName','key','model','query','keys','intersection','fields','attributes','length','hasOwnProperty','nolimit','sort','where','filters','merge','type','VIRTUAL','filter','options','includeAll','findAll','rows','params','include','find','catch','create','body'];(function(_0x583b14,_0x59fe86){var _0x8214dc=function(_0x5954a2){while(--_0x5954a2){_0x583b14['push'](_0x583b14['shift']());}};_0x8214dc(++_0x59fe86);}(_0x6957,0x1c4));var _0x7695=function(_0x4a917a,_0x26796a){_0x4a917a=_0x4a917a-0x0;var _0x368330=_0x6957[_0x4a917a];return _0x368330;};'use strict';var emlformat=require(_0x7695('0x0'));var rimraf=require(_0x7695('0x1'));var zipdir=require(_0x7695('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x7695('0x3'));var moment=require(_0x7695('0x4'));var BPromise=require('bluebird');var Mustache=require(_0x7695('0x5'));var util=require(_0x7695('0x6'));var path=require(_0x7695('0x7'));var sox=require(_0x7695('0x8'));var csv=require(_0x7695('0x9'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x7695('0xa'));var _=require('lodash');var squel=require(_0x7695('0xb'));var crypto=require(_0x7695('0xc'));var jsforce=require(_0x7695('0xd'));var deskjs=require(_0x7695('0xe'));var toCsv=require('to-csv');var querystring=require(_0x7695('0xf'));var Papa=require(_0x7695('0x10'));var Redis=require(_0x7695('0x11'));var authService=require(_0x7695('0x12'));var qs=require(_0x7695('0x13'));var as=require(_0x7695('0x14'));var hardwareService=require(_0x7695('0x15'));var logger=require('../../config/logger')(_0x7695('0x16'));var utils=require(_0x7695('0x17'));var config=require('../../config/environment');var licenseUtil=require(_0x7695('0x18'));var db=require(_0x7695('0x19'))['db'];function respondWithStatusCode(_0x14d693,_0x518957){_0x518957=_0x518957||0xcc;return function(_0x173517){if(_0x173517){return _0x14d693[_0x7695('0x1a')](_0x518957);}return _0x14d693[_0x7695('0x1b')](_0x518957)[_0x7695('0x1c')]();};}function respondWithResult(_0x122250,_0x30abc6){_0x30abc6=_0x30abc6||0xc8;return function(_0xedc539){if(_0xedc539){return _0x122250[_0x7695('0x1b')](_0x30abc6)[_0x7695('0x1d')](_0xedc539);}};}function respondWithFilteredResult(_0x5b80c4,_0x40e033){return function(_0x3cd17b){if(_0x3cd17b){var _0x513d78=typeof _0x40e033['offset']==='undefined'&&typeof _0x40e033[_0x7695('0x1e')]==='undefined';var _0x824b53=_0x3cd17b['count'];var _0xdacb0b=_0x513d78?0x0:_0x40e033[_0x7695('0x1f')];var _0x14e033=_0x513d78?_0x3cd17b[_0x7695('0x20')]:_0x40e033[_0x7695('0x1f')]+_0x40e033[_0x7695('0x1e')];var _0x3a0d63;if(_0x14e033>=_0x824b53){_0x14e033=_0x824b53;_0x3a0d63=0xc8;}else{_0x3a0d63=0xce;}_0x5b80c4['status'](_0x3a0d63);return _0x5b80c4[_0x7695('0x21')](_0x7695('0x22'),_0xdacb0b+'-'+_0x14e033+'/'+_0x824b53)[_0x7695('0x1d')](_0x3cd17b);}return null;};}function patchUpdates(_0x16cf04){return function(_0x2938f2){try{jsonpatch[_0x7695('0x23')](_0x2938f2,_0x16cf04,!![]);}catch(_0x101e5c){return BPromise[_0x7695('0x24')](_0x101e5c);}return _0x2938f2[_0x7695('0x25')]();};}function saveUpdates(_0x2d4582,_0x147467){return function(_0xa3624e){if(_0xa3624e){return _0xa3624e['update'](_0x2d4582)['then'](function(_0x24a811){return _0x24a811;});}return null;};}function removeEntity(_0x3a6615,_0x544d1c){return function(_0x4f7b41){if(_0x4f7b41){return _0x4f7b41['destroy']()[_0x7695('0x26')](function(){var _0x526016=_0x4f7b41['get']({'plain':!![]});var _0x565437=_0x7695('0x27');return db[_0x7695('0x28')]['destroy']({'where':{'type':_0x565437,'resourceId':_0x526016['id']}})[_0x7695('0x26')](function(){return _0x4f7b41;});})[_0x7695('0x26')](function(){_0x3a6615[_0x7695('0x1b')](0xcc)[_0x7695('0x1c')]();});}};}function handleEntityNotFound(_0x1cf6c8,_0x4eb4bc){return function(_0xa4177d){if(!_0xa4177d){_0x1cf6c8['sendStatus'](0x194);}return _0xa4177d;};}function handleError(_0x2a31fe,_0x2a70ac){_0x2a70ac=_0x2a70ac||0x1f4;return function(_0x4444fa){logger[_0x7695('0x29')](_0x4444fa[_0x7695('0x2a')]);if(_0x4444fa[_0x7695('0x2b')]){delete _0x4444fa[_0x7695('0x2b')];}_0x2a31fe[_0x7695('0x1b')](_0x2a70ac)[_0x7695('0x2c')](_0x4444fa);};}exports['index']=function(_0x5d4476,_0x5a385c){var _0x3ff9f1={},_0x3d2266={},_0x4668e4={'count':0x0,'rows':[]};var _0x2cb407=_[_0x7695('0x2d')](db[_0x7695('0x2e')][_0x7695('0x2f')],function(_0x20b403){return{'name':_0x20b403[_0x7695('0x30')],'type':_0x20b403['type'][_0x7695('0x31')]};});_0x3d2266[_0x7695('0x32')]=_['map'](_0x2cb407,'name');_0x3d2266[_0x7695('0x33')]=_[_0x7695('0x34')](_0x5d4476[_0x7695('0x33')]);_0x3d2266['filters']=_[_0x7695('0x35')](_0x3d2266[_0x7695('0x32')],_0x3d2266[_0x7695('0x33')]);_0x3ff9f1['attributes']=_[_0x7695('0x35')](_0x3d2266['model'],qs[_0x7695('0x36')](_0x5d4476[_0x7695('0x33')]['fields']));_0x3ff9f1[_0x7695('0x37')]=_0x3ff9f1[_0x7695('0x37')][_0x7695('0x38')]?_0x3ff9f1[_0x7695('0x37')]:_0x3d2266['model'];if(!_0x5d4476[_0x7695('0x33')][_0x7695('0x39')](_0x7695('0x3a'))){_0x3ff9f1[_0x7695('0x1e')]=qs[_0x7695('0x1e')](_0x5d4476[_0x7695('0x33')]['limit']);_0x3ff9f1[_0x7695('0x1f')]=qs[_0x7695('0x1f')](_0x5d4476[_0x7695('0x33')][_0x7695('0x1f')]);}_0x3ff9f1['order']=qs[_0x7695('0x3b')](_0x5d4476['query']['sort']);_0x3ff9f1[_0x7695('0x3c')]=qs[_0x7695('0x3d')](_['pick'](_0x5d4476[_0x7695('0x33')],_0x3d2266[_0x7695('0x3d')]),_0x2cb407);if(_0x5d4476[_0x7695('0x33')]['filter']){_0x3ff9f1[_0x7695('0x3c')]=_[_0x7695('0x3e')](_0x3ff9f1[_0x7695('0x3c')],{'$or':_[_0x7695('0x2d')](_0x2cb407,function(_0x44882a){if(_0x44882a[_0x7695('0x3f')]!==_0x7695('0x40')){var _0x5e1d40={};_0x5e1d40[_0x44882a['name']]={'$like':'%'+_0x5d4476[_0x7695('0x33')][_0x7695('0x41')]+'%'};return _0x5e1d40;}})});}_0x3ff9f1=_[_0x7695('0x3e')]({},_0x3ff9f1,_0x5d4476[_0x7695('0x42')]);var _0x163830={'where':_0x3ff9f1[_0x7695('0x3c')]};return db[_0x7695('0x2e')][_0x7695('0x20')](_0x163830)[_0x7695('0x26')](function(_0x2ed799){_0x4668e4[_0x7695('0x20')]=_0x2ed799;if(_0x5d4476[_0x7695('0x33')][_0x7695('0x43')]){_0x3ff9f1['include']=[{'all':!![]}];}return db['SquareOdbc'][_0x7695('0x44')](_0x3ff9f1);})[_0x7695('0x26')](function(_0x40d000){_0x4668e4[_0x7695('0x45')]=_0x40d000;return _0x4668e4;})['then'](respondWithFilteredResult(_0x5a385c,_0x3ff9f1))['catch'](handleError(_0x5a385c,null));};exports['show']=function(_0x150b51,_0x3c16b0){var _0x10bb77={'raw':!![],'where':{'id':_0x150b51[_0x7695('0x46')]['id']}},_0x31f493={};_0x31f493[_0x7695('0x32')]=_[_0x7695('0x34')](db[_0x7695('0x2e')][_0x7695('0x2f')]);_0x31f493[_0x7695('0x33')]=_[_0x7695('0x34')](_0x150b51[_0x7695('0x33')]);_0x31f493['filters']=_[_0x7695('0x35')](_0x31f493[_0x7695('0x32')],_0x31f493[_0x7695('0x33')]);_0x10bb77[_0x7695('0x37')]=_[_0x7695('0x35')](_0x31f493[_0x7695('0x32')],qs[_0x7695('0x36')](_0x150b51['query'][_0x7695('0x36')]));_0x10bb77[_0x7695('0x37')]=_0x10bb77[_0x7695('0x37')]['length']?_0x10bb77[_0x7695('0x37')]:_0x31f493[_0x7695('0x32')];if(_0x150b51['query']['includeAll']){_0x10bb77[_0x7695('0x47')]=[{'all':!![]}];}_0x10bb77=_[_0x7695('0x3e')]({},_0x10bb77,_0x150b51['options']);return db[_0x7695('0x2e')][_0x7695('0x48')](_0x10bb77)[_0x7695('0x26')](handleEntityNotFound(_0x3c16b0,null))[_0x7695('0x26')](respondWithResult(_0x3c16b0,null))[_0x7695('0x49')](handleError(_0x3c16b0,null));};exports[_0x7695('0x4a')]=function(_0xd01c7c,_0x550dbb){return db['SquareOdbc'][_0x7695('0x4a')](_0xd01c7c[_0x7695('0x4b')],{})[_0x7695('0x26')](function(_0x22738f){var _0x524779=_0xd01c7c['user'][_0x7695('0x4c')]({'plain':!![]});if(!_0x524779)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x524779['role']===_0x7695('0x4d')){var _0xa0d070=_0x22738f['get']({'plain':!![]});var _0x317c04=_0x7695('0x27');return db[_0x7695('0x4e')]['find']({'where':{'name':_0x317c04,'userProfileId':_0x524779[_0x7695('0x4f')]},'raw':!![]})['then'](function(_0x40634d){if(_0x40634d&&_0x40634d[_0x7695('0x50')]===0x0){return db[_0x7695('0x28')][_0x7695('0x4a')]({'name':_0xa0d070['name'],'resourceId':_0xa0d070['id'],'type':_0x40634d['name'],'sectionId':_0x40634d['id']},{})[_0x7695('0x26')](function(){return _0x22738f;});}else{return _0x22738f;}})[_0x7695('0x49')](function(_0x48e538){logger[_0x7695('0x29')](_0x7695('0x51'),_0x48e538);throw _0x48e538;});}return _0x22738f;})['then'](respondWithResult(_0x550dbb,0xc9))['catch'](handleError(_0x550dbb,null));};exports[_0x7695('0x52')]=function(_0x61adb5,_0x5b5968){if(_0x61adb5[_0x7695('0x4b')]['id']){delete _0x61adb5[_0x7695('0x4b')]['id'];}return db[_0x7695('0x2e')][_0x7695('0x48')]({'where':{'id':_0x61adb5[_0x7695('0x46')]['id']}})[_0x7695('0x26')](handleEntityNotFound(_0x5b5968,null))[_0x7695('0x26')](saveUpdates(_0x61adb5[_0x7695('0x4b')],null))[_0x7695('0x26')](respondWithResult(_0x5b5968,null))[_0x7695('0x49')](handleError(_0x5b5968,null));};exports[_0x7695('0x53')]=function(_0x1a5ca6,_0x3c877f){return db['SquareOdbc']['find']({'where':{'id':_0x1a5ca6[_0x7695('0x46')]['id']}})[_0x7695('0x26')](handleEntityNotFound(_0x3c877f,null))['then'](removeEntity(_0x3c877f,null))[_0x7695('0x49')](handleError(_0x3c877f,null));};exports['test']=function(_0x16a7a8,_0x18e17b,_0x3c64b6){var _0x1b7585;return db[_0x7695('0x2e')][_0x7695('0x48')]({'where':{'id':_0x16a7a8[_0x7695('0x46')]['id']},'attributes':['id',_0x7695('0x54')]})['then'](handleEntityNotFound(_0x18e17b,null))[_0x7695('0x26')](function(_0x399e90){if(_0x399e90){var _0x5325e8=require(_0x7695('0x55'))();_0x5325e8[_0x7695('0x56')](_0x399e90[_0x7695('0x54')]);_0x5325e8[_0x7695('0x57')]();return _0x399e90;}})['then'](respondWithResult(_0x18e17b,null))[_0x7695('0x49')](handleError(_0x18e17b,null));};
\ No newline at end of file
+var _0x2a2e=['then','destroy','ODBC','UserProfileResource','error','name','map','SquareOdbc','rawAttributes','fieldName','type','key','model','query','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','VIRTUAL','filter','merge','options','includeAll','include','findAll','rows','catch','show','params','keys','find','create','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','dsn','openSync','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','end','json','undefined','limit','offset','count','set','Content-Range','reject','update'];(function(_0x476b5f,_0x1f9952){var _0x5a23d8=function(_0x50b464){while(--_0x50b464){_0x476b5f['push'](_0x476b5f['shift']());}};_0x5a23d8(++_0x1f9952);}(_0x2a2e,0x1e5));var _0xe2a2=function(_0x214cbb,_0x40c21f){_0x214cbb=_0x214cbb-0x0;var _0x1495c1=_0x2a2e[_0x214cbb];return _0x1495c1;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xe2a2('0x0'));var zipdir=require(_0xe2a2('0x1'));var jsonpatch=require(_0xe2a2('0x2'));var rp=require(_0xe2a2('0x3'));var moment=require(_0xe2a2('0x4'));var BPromise=require(_0xe2a2('0x5'));var Mustache=require('mustache');var util=require(_0xe2a2('0x6'));var path=require(_0xe2a2('0x7'));var sox=require(_0xe2a2('0x8'));var csv=require(_0xe2a2('0x9'));var ejs=require(_0xe2a2('0xa'));var fs=require('fs');var fs_extra=require(_0xe2a2('0xb'));var _=require(_0xe2a2('0xc'));var squel=require(_0xe2a2('0xd'));var crypto=require('crypto');var jsforce=require(_0xe2a2('0xe'));var deskjs=require(_0xe2a2('0xf'));var toCsv=require(_0xe2a2('0x9'));var querystring=require(_0xe2a2('0x10'));var Papa=require('papaparse');var Redis=require(_0xe2a2('0x11'));var authService=require(_0xe2a2('0x12'));var qs=require(_0xe2a2('0x13'));var as=require(_0xe2a2('0x14'));var hardwareService=require(_0xe2a2('0x15'));var logger=require('../../config/logger')('api');var utils=require(_0xe2a2('0x16'));var config=require('../../config/environment');var licenseUtil=require(_0xe2a2('0x17'));var db=require(_0xe2a2('0x18'))['db'];function respondWithStatusCode(_0x4cf55d,_0x5ca3d7){_0x5ca3d7=_0x5ca3d7||0xcc;return function(_0xa03ec7){if(_0xa03ec7){return _0x4cf55d[_0xe2a2('0x19')](_0x5ca3d7);}return _0x4cf55d[_0xe2a2('0x1a')](_0x5ca3d7)[_0xe2a2('0x1b')]();};}function respondWithResult(_0xa7a693,_0x5cc133){_0x5cc133=_0x5cc133||0xc8;return function(_0x2a217f){if(_0x2a217f){return _0xa7a693[_0xe2a2('0x1a')](_0x5cc133)[_0xe2a2('0x1c')](_0x2a217f);}};}function respondWithFilteredResult(_0x4bf7fc,_0x555410){return function(_0x24534f){if(_0x24534f){var _0x567a7c=typeof _0x555410['offset']===_0xe2a2('0x1d')&&typeof _0x555410[_0xe2a2('0x1e')]===_0xe2a2('0x1d');var _0x557fa2=_0x24534f['count'];var _0x332e19=_0x567a7c?0x0:_0x555410[_0xe2a2('0x1f')];var _0x478472=_0x567a7c?_0x24534f[_0xe2a2('0x20')]:_0x555410['offset']+_0x555410[_0xe2a2('0x1e')];var _0x1c7d7d;if(_0x478472>=_0x557fa2){_0x478472=_0x557fa2;_0x1c7d7d=0xc8;}else{_0x1c7d7d=0xce;}_0x4bf7fc[_0xe2a2('0x1a')](_0x1c7d7d);return _0x4bf7fc[_0xe2a2('0x21')](_0xe2a2('0x22'),_0x332e19+'-'+_0x478472+'/'+_0x557fa2)[_0xe2a2('0x1c')](_0x24534f);}return null;};}function patchUpdates(_0x52adfa){return function(_0xe462c8){try{jsonpatch['apply'](_0xe462c8,_0x52adfa,!![]);}catch(_0x19bca8){return BPromise[_0xe2a2('0x23')](_0x19bca8);}return _0xe462c8['save']();};}function saveUpdates(_0x1efa66,_0x177eab){return function(_0x2b725a){if(_0x2b725a){return _0x2b725a[_0xe2a2('0x24')](_0x1efa66)[_0xe2a2('0x25')](function(_0x11c881){return _0x11c881;});}return null;};}function removeEntity(_0x4e93f6,_0x3e40f0){return function(_0xe94a9b){if(_0xe94a9b){return _0xe94a9b[_0xe2a2('0x26')]()['then'](function(){var _0x7f634=_0xe94a9b['get']({'plain':!![]});var _0x5f673d=_0xe2a2('0x27');return db[_0xe2a2('0x28')]['destroy']({'where':{'type':_0x5f673d,'resourceId':_0x7f634['id']}})[_0xe2a2('0x25')](function(){return _0xe94a9b;});})['then'](function(){_0x4e93f6[_0xe2a2('0x1a')](0xcc)[_0xe2a2('0x1b')]();});}};}function handleEntityNotFound(_0x5aa89f,_0x2c0952){return function(_0x3e75b9){if(!_0x3e75b9){_0x5aa89f[_0xe2a2('0x19')](0x194);}return _0x3e75b9;};}function handleError(_0x14e6e5,_0x642c39){_0x642c39=_0x642c39||0x1f4;return function(_0x186463){logger[_0xe2a2('0x29')](_0x186463['stack']);if(_0x186463[_0xe2a2('0x2a')]){delete _0x186463[_0xe2a2('0x2a')];}_0x14e6e5[_0xe2a2('0x1a')](_0x642c39)['send'](_0x186463);};}exports['index']=function(_0x52e2a8,_0xa4de39){var _0x1a6c7b={},_0x5b9455={},_0x25f3ca={'count':0x0,'rows':[]};var _0x1303af=_[_0xe2a2('0x2b')](db[_0xe2a2('0x2c')][_0xe2a2('0x2d')],function(_0x537ee9){return{'name':_0x537ee9[_0xe2a2('0x2e')],'type':_0x537ee9[_0xe2a2('0x2f')][_0xe2a2('0x30')]};});_0x5b9455[_0xe2a2('0x31')]=_[_0xe2a2('0x2b')](_0x1303af,_0xe2a2('0x2a'));_0x5b9455[_0xe2a2('0x32')]=_['keys'](_0x52e2a8[_0xe2a2('0x32')]);_0x5b9455['filters']=_[_0xe2a2('0x33')](_0x5b9455[_0xe2a2('0x31')],_0x5b9455[_0xe2a2('0x32')]);_0x1a6c7b[_0xe2a2('0x34')]=_[_0xe2a2('0x33')](_0x5b9455['model'],qs[_0xe2a2('0x35')](_0x52e2a8[_0xe2a2('0x32')][_0xe2a2('0x35')]));_0x1a6c7b[_0xe2a2('0x34')]=_0x1a6c7b['attributes'][_0xe2a2('0x36')]?_0x1a6c7b[_0xe2a2('0x34')]:_0x5b9455[_0xe2a2('0x31')];if(!_0x52e2a8['query'][_0xe2a2('0x37')](_0xe2a2('0x38'))){_0x1a6c7b['limit']=qs[_0xe2a2('0x1e')](_0x52e2a8[_0xe2a2('0x32')][_0xe2a2('0x1e')]);_0x1a6c7b['offset']=qs[_0xe2a2('0x1f')](_0x52e2a8[_0xe2a2('0x32')][_0xe2a2('0x1f')]);}_0x1a6c7b[_0xe2a2('0x39')]=qs[_0xe2a2('0x3a')](_0x52e2a8[_0xe2a2('0x32')][_0xe2a2('0x3a')]);_0x1a6c7b[_0xe2a2('0x3b')]=qs[_0xe2a2('0x3c')](_[_0xe2a2('0x3d')](_0x52e2a8[_0xe2a2('0x32')],_0x5b9455['filters']),_0x1303af);if(_0x52e2a8[_0xe2a2('0x32')]['filter']){_0x1a6c7b['where']=_['merge'](_0x1a6c7b['where'],{'$or':_[_0xe2a2('0x2b')](_0x1303af,function(_0x502a50){if(_0x502a50[_0xe2a2('0x2f')]!==_0xe2a2('0x3e')){var _0x5c7948={};_0x5c7948[_0x502a50['name']]={'$like':'%'+_0x52e2a8[_0xe2a2('0x32')][_0xe2a2('0x3f')]+'%'};return _0x5c7948;}})});}_0x1a6c7b=_[_0xe2a2('0x40')]({},_0x1a6c7b,_0x52e2a8[_0xe2a2('0x41')]);var _0x442a4c={'where':_0x1a6c7b[_0xe2a2('0x3b')]};return db[_0xe2a2('0x2c')][_0xe2a2('0x20')](_0x442a4c)[_0xe2a2('0x25')](function(_0xc2257){_0x25f3ca[_0xe2a2('0x20')]=_0xc2257;if(_0x52e2a8[_0xe2a2('0x32')][_0xe2a2('0x42')]){_0x1a6c7b[_0xe2a2('0x43')]=[{'all':!![]}];}return db[_0xe2a2('0x2c')][_0xe2a2('0x44')](_0x1a6c7b);})[_0xe2a2('0x25')](function(_0x2709c9){_0x25f3ca[_0xe2a2('0x45')]=_0x2709c9;return _0x25f3ca;})['then'](respondWithFilteredResult(_0xa4de39,_0x1a6c7b))[_0xe2a2('0x46')](handleError(_0xa4de39,null));};exports[_0xe2a2('0x47')]=function(_0x18599c,_0x294892){var _0x44fc53={'raw':!![],'where':{'id':_0x18599c[_0xe2a2('0x48')]['id']}},_0x349164={};_0x349164[_0xe2a2('0x31')]=_['keys'](db['SquareOdbc'][_0xe2a2('0x2d')]);_0x349164['query']=_[_0xe2a2('0x49')](_0x18599c[_0xe2a2('0x32')]);_0x349164[_0xe2a2('0x3c')]=_[_0xe2a2('0x33')](_0x349164['model'],_0x349164[_0xe2a2('0x32')]);_0x44fc53[_0xe2a2('0x34')]=_[_0xe2a2('0x33')](_0x349164['model'],qs[_0xe2a2('0x35')](_0x18599c[_0xe2a2('0x32')][_0xe2a2('0x35')]));_0x44fc53['attributes']=_0x44fc53[_0xe2a2('0x34')]['length']?_0x44fc53[_0xe2a2('0x34')]:_0x349164[_0xe2a2('0x31')];if(_0x18599c[_0xe2a2('0x32')][_0xe2a2('0x42')]){_0x44fc53[_0xe2a2('0x43')]=[{'all':!![]}];}_0x44fc53=_[_0xe2a2('0x40')]({},_0x44fc53,_0x18599c[_0xe2a2('0x41')]);return db['SquareOdbc'][_0xe2a2('0x4a')](_0x44fc53)[_0xe2a2('0x25')](handleEntityNotFound(_0x294892,null))[_0xe2a2('0x25')](respondWithResult(_0x294892,null))['catch'](handleError(_0x294892,null));};exports[_0xe2a2('0x4b')]=function(_0x36518c,_0x5a9ab7){return db[_0xe2a2('0x2c')][_0xe2a2('0x4b')](_0x36518c[_0xe2a2('0x4c')],{})[_0xe2a2('0x25')](function(_0x454bfa){var _0x41bb6d=_0x36518c[_0xe2a2('0x4d')][_0xe2a2('0x4e')]({'plain':!![]});if(!_0x41bb6d)throw new Error(_0xe2a2('0x4f'));if(_0x41bb6d[_0xe2a2('0x50')]===_0xe2a2('0x4d')){var _0x120835=_0x454bfa[_0xe2a2('0x4e')]({'plain':!![]});var _0x9035b6='ODBC';return db[_0xe2a2('0x51')][_0xe2a2('0x4a')]({'where':{'name':_0x9035b6,'userProfileId':_0x41bb6d[_0xe2a2('0x52')]},'raw':!![]})[_0xe2a2('0x25')](function(_0x48d081){if(_0x48d081&&_0x48d081[_0xe2a2('0x53')]===0x0){return db['UserProfileResource'][_0xe2a2('0x4b')]({'name':_0x120835[_0xe2a2('0x2a')],'resourceId':_0x120835['id'],'type':_0x48d081[_0xe2a2('0x2a')],'sectionId':_0x48d081['id']},{})['then'](function(){return _0x454bfa;});}else{return _0x454bfa;}})[_0xe2a2('0x46')](function(_0x7f01dd){logger[_0xe2a2('0x29')](_0xe2a2('0x54'),_0x7f01dd);throw _0x7f01dd;});}return _0x454bfa;})[_0xe2a2('0x25')](respondWithResult(_0x5a9ab7,0xc9))[_0xe2a2('0x46')](handleError(_0x5a9ab7,null));};exports['update']=function(_0x189ac0,_0x288a61){if(_0x189ac0[_0xe2a2('0x4c')]['id']){delete _0x189ac0[_0xe2a2('0x4c')]['id'];}return db['SquareOdbc'][_0xe2a2('0x4a')]({'where':{'id':_0x189ac0['params']['id']}})['then'](handleEntityNotFound(_0x288a61,null))[_0xe2a2('0x25')](saveUpdates(_0x189ac0[_0xe2a2('0x4c')],null))[_0xe2a2('0x25')](respondWithResult(_0x288a61,null))['catch'](handleError(_0x288a61,null));};exports[_0xe2a2('0x26')]=function(_0x55f1dc,_0x6c2d9){return db[_0xe2a2('0x2c')][_0xe2a2('0x4a')]({'where':{'id':_0x55f1dc[_0xe2a2('0x48')]['id']}})[_0xe2a2('0x25')](handleEntityNotFound(_0x6c2d9,null))[_0xe2a2('0x25')](removeEntity(_0x6c2d9,null))[_0xe2a2('0x46')](handleError(_0x6c2d9,null));};exports['test']=function(_0x7788f1,_0x37de97,_0x4a7680){var _0x5cbb72;return db[_0xe2a2('0x2c')][_0xe2a2('0x4a')]({'where':{'id':_0x7788f1['params']['id']},'attributes':['id',_0xe2a2('0x55')]})[_0xe2a2('0x25')](handleEntityNotFound(_0x37de97,null))['then'](function(_0x43d908){if(_0x43d908){var _0x66bf98=require('odbc')();_0x66bf98[_0xe2a2('0x56')](_0x43d908[_0xe2a2('0x55')]);_0x66bf98['closeSync']();return _0x43d908;}})[_0xe2a2('0x25')](respondWithResult(_0x37de97,null))[_0xe2a2('0x46')](handleError(_0x37de97,null));};
\ No newline at end of file