Built motion from commit da24aabd.|2.6.20
[motion2.git] / server / api / squareOdbc / squareOdbc.controller.js
index 22fae1f..179a775 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x12fb=['fs-extra','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','end','json','offset','undefined','limit','count','status','set','apply','reject','update','then','get','ODBC','UserProfileResource','destroy','sendStatus','stack','name','index','map','SquareOdbc','rawAttributes','fieldName','type','key','model','query','intersection','attributes','length','hasOwnProperty','nolimit','order','sort','where','filters','VIRTUAL','merge','includeAll','include','rows','catch','show','params','keys','fields','options','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','test','dsn','openSync','closeSync','eml-format','fast-json-patch','request-promise','mustache','util','to-csv','ejs'];(function(_0x1e4e1a,_0x3bdb4a){var _0x462e08=function(_0x4e3359){while(--_0x4e3359){_0x1e4e1a['push'](_0x1e4e1a['shift']());}};_0x462e08(++_0x3bdb4a);}(_0x12fb,0x145));var _0xb12f=function(_0x4709c0,_0x3396c7){_0x4709c0=_0x4709c0-0x0;var _0x13348b=_0x12fb[_0x4709c0];return _0x13348b;};'use strict';var emlformat=require(_0xb12f('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xb12f('0x1'));var rp=require(_0xb12f('0x2'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0xb12f('0x3'));var util=require(_0xb12f('0x4'));var path=require('path');var sox=require('sox');var csv=require(_0xb12f('0x5'));var ejs=require(_0xb12f('0x6'));var fs=require('fs');var fs_extra=require(_0xb12f('0x7'));var _=require('lodash');var squel=require('squel');var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0xb12f('0x8'));var toCsv=require(_0xb12f('0x5'));var querystring=require(_0xb12f('0x9'));var Papa=require(_0xb12f('0xa'));var Redis=require(_0xb12f('0xb'));var authService=require(_0xb12f('0xc'));var qs=require(_0xb12f('0xd'));var as=require(_0xb12f('0xe'));var hardwareService=require(_0xb12f('0xf'));var logger=require('../../config/logger')(_0xb12f('0x10'));var utils=require(_0xb12f('0x11'));var config=require(_0xb12f('0x12'));var licenseUtil=require(_0xb12f('0x13'));var db=require(_0xb12f('0x14'))['db'];function respondWithStatusCode(_0x2d4c22,_0x581719){_0x581719=_0x581719||0xcc;return function(_0xd9b32c){if(_0xd9b32c){return _0x2d4c22['sendStatus'](_0x581719);}return _0x2d4c22['status'](_0x581719)[_0xb12f('0x15')]();};}function respondWithResult(_0x236c81,_0x19a8ea){_0x19a8ea=_0x19a8ea||0xc8;return function(_0x2207da){if(_0x2207da){return _0x236c81['status'](_0x19a8ea)[_0xb12f('0x16')](_0x2207da);}};}function respondWithFilteredResult(_0xc4d94d,_0x327ac1){return function(_0x432c8d){if(_0x432c8d){var _0x12e3ab=typeof _0x327ac1[_0xb12f('0x17')]===_0xb12f('0x18')&&typeof _0x327ac1[_0xb12f('0x19')]===_0xb12f('0x18');var _0x2df201=_0x432c8d['count'];var _0x587eee=_0x12e3ab?0x0:_0x327ac1[_0xb12f('0x17')];var _0x44abef=_0x12e3ab?_0x432c8d[_0xb12f('0x1a')]:_0x327ac1[_0xb12f('0x17')]+_0x327ac1[_0xb12f('0x19')];var _0x57ad0d;if(_0x44abef>=_0x2df201){_0x44abef=_0x2df201;_0x57ad0d=0xc8;}else{_0x57ad0d=0xce;}_0xc4d94d[_0xb12f('0x1b')](_0x57ad0d);return _0xc4d94d[_0xb12f('0x1c')]('Content-Range',_0x587eee+'-'+_0x44abef+'/'+_0x2df201)[_0xb12f('0x16')](_0x432c8d);}return null;};}function patchUpdates(_0x31a78e){return function(_0x20ac5d){try{jsonpatch[_0xb12f('0x1d')](_0x20ac5d,_0x31a78e,!![]);}catch(_0x57bb3f){return BPromise[_0xb12f('0x1e')](_0x57bb3f);}return _0x20ac5d['save']();};}function saveUpdates(_0x24086c,_0x6c564){return function(_0x2d0d45){if(_0x2d0d45){return _0x2d0d45[_0xb12f('0x1f')](_0x24086c)[_0xb12f('0x20')](function(_0x2c9d5f){return _0x2c9d5f;});}return null;};}function removeEntity(_0x1569b4,_0x464576){return function(_0x1934ea){if(_0x1934ea){return _0x1934ea['destroy']()[_0xb12f('0x20')](function(){var _0x4820c9=_0x1934ea[_0xb12f('0x21')]({'plain':!![]});var _0x35a0f6=_0xb12f('0x22');return db[_0xb12f('0x23')][_0xb12f('0x24')]({'where':{'type':_0x35a0f6,'resourceId':_0x4820c9['id']}})[_0xb12f('0x20')](function(){return _0x1934ea;});})[_0xb12f('0x20')](function(){_0x1569b4[_0xb12f('0x1b')](0xcc)['end']();});}};}function handleEntityNotFound(_0xc49523,_0x5a00f7){return function(_0x459995){if(!_0x459995){_0xc49523[_0xb12f('0x25')](0x194);}return _0x459995;};}function handleError(_0x547ba5,_0x3c5bc7){_0x3c5bc7=_0x3c5bc7||0x1f4;return function(_0x435acc){logger['error'](_0x435acc[_0xb12f('0x26')]);if(_0x435acc[_0xb12f('0x27')]){delete _0x435acc['name'];}_0x547ba5[_0xb12f('0x1b')](_0x3c5bc7)['send'](_0x435acc);};}exports[_0xb12f('0x28')]=function(_0x3056a3,_0x202078){var _0x1bc5e7={},_0xed2df7={},_0x40752a={'count':0x0,'rows':[]};var _0x2b1749=_[_0xb12f('0x29')](db[_0xb12f('0x2a')][_0xb12f('0x2b')],function(_0x51ed6e){return{'name':_0x51ed6e[_0xb12f('0x2c')],'type':_0x51ed6e[_0xb12f('0x2d')][_0xb12f('0x2e')]};});_0xed2df7[_0xb12f('0x2f')]=_[_0xb12f('0x29')](_0x2b1749,_0xb12f('0x27'));_0xed2df7[_0xb12f('0x30')]=_['keys'](_0x3056a3[_0xb12f('0x30')]);_0xed2df7['filters']=_[_0xb12f('0x31')](_0xed2df7[_0xb12f('0x2f')],_0xed2df7[_0xb12f('0x30')]);_0x1bc5e7[_0xb12f('0x32')]=_[_0xb12f('0x31')](_0xed2df7[_0xb12f('0x2f')],qs['fields'](_0x3056a3[_0xb12f('0x30')]['fields']));_0x1bc5e7[_0xb12f('0x32')]=_0x1bc5e7[_0xb12f('0x32')][_0xb12f('0x33')]?_0x1bc5e7['attributes']:_0xed2df7[_0xb12f('0x2f')];if(!_0x3056a3[_0xb12f('0x30')][_0xb12f('0x34')](_0xb12f('0x35'))){_0x1bc5e7[_0xb12f('0x19')]=qs[_0xb12f('0x19')](_0x3056a3['query']['limit']);_0x1bc5e7[_0xb12f('0x17')]=qs[_0xb12f('0x17')](_0x3056a3[_0xb12f('0x30')]['offset']);}_0x1bc5e7[_0xb12f('0x36')]=qs[_0xb12f('0x37')](_0x3056a3[_0xb12f('0x30')][_0xb12f('0x37')]);_0x1bc5e7[_0xb12f('0x38')]=qs[_0xb12f('0x39')](_['pick'](_0x3056a3[_0xb12f('0x30')],_0xed2df7[_0xb12f('0x39')]),_0x2b1749);if(_0x3056a3['query']['filter']){_0x1bc5e7[_0xb12f('0x38')]=_['merge'](_0x1bc5e7[_0xb12f('0x38')],{'$or':_['map'](_0x2b1749,function(_0x5ce41b){if(_0x5ce41b[_0xb12f('0x2d')]!==_0xb12f('0x3a')){var _0x2818ff={};_0x2818ff[_0x5ce41b[_0xb12f('0x27')]]={'$like':'%'+_0x3056a3['query']['filter']+'%'};return _0x2818ff;}})});}_0x1bc5e7=_[_0xb12f('0x3b')]({},_0x1bc5e7,_0x3056a3['options']);var _0x164d78={'where':_0x1bc5e7[_0xb12f('0x38')]};return db['SquareOdbc'][_0xb12f('0x1a')](_0x164d78)[_0xb12f('0x20')](function(_0x2d73ed){_0x40752a[_0xb12f('0x1a')]=_0x2d73ed;if(_0x3056a3[_0xb12f('0x30')][_0xb12f('0x3c')]){_0x1bc5e7[_0xb12f('0x3d')]=[{'all':!![]}];}return db[_0xb12f('0x2a')]['findAll'](_0x1bc5e7);})[_0xb12f('0x20')](function(_0x358a49){_0x40752a[_0xb12f('0x3e')]=_0x358a49;return _0x40752a;})[_0xb12f('0x20')](respondWithFilteredResult(_0x202078,_0x1bc5e7))[_0xb12f('0x3f')](handleError(_0x202078,null));};exports[_0xb12f('0x40')]=function(_0x5a5f70,_0x58ae2e){var _0x594d00={'raw':!![],'where':{'id':_0x5a5f70[_0xb12f('0x41')]['id']}},_0x273fbb={};_0x273fbb[_0xb12f('0x2f')]=_[_0xb12f('0x42')](db[_0xb12f('0x2a')]['rawAttributes']);_0x273fbb[_0xb12f('0x30')]=_[_0xb12f('0x42')](_0x5a5f70[_0xb12f('0x30')]);_0x273fbb[_0xb12f('0x39')]=_[_0xb12f('0x31')](_0x273fbb[_0xb12f('0x2f')],_0x273fbb[_0xb12f('0x30')]);_0x594d00[_0xb12f('0x32')]=_[_0xb12f('0x31')](_0x273fbb[_0xb12f('0x2f')],qs['fields'](_0x5a5f70[_0xb12f('0x30')][_0xb12f('0x43')]));_0x594d00[_0xb12f('0x32')]=_0x594d00[_0xb12f('0x32')][_0xb12f('0x33')]?_0x594d00[_0xb12f('0x32')]:_0x273fbb[_0xb12f('0x2f')];if(_0x5a5f70[_0xb12f('0x30')][_0xb12f('0x3c')]){_0x594d00[_0xb12f('0x3d')]=[{'all':!![]}];}_0x594d00=_[_0xb12f('0x3b')]({},_0x594d00,_0x5a5f70[_0xb12f('0x44')]);return db['SquareOdbc'][_0xb12f('0x45')](_0x594d00)[_0xb12f('0x20')](handleEntityNotFound(_0x58ae2e,null))[_0xb12f('0x20')](respondWithResult(_0x58ae2e,null))[_0xb12f('0x3f')](handleError(_0x58ae2e,null));};exports[_0xb12f('0x46')]=function(_0x5933dd,_0x2d9997){return db[_0xb12f('0x2a')][_0xb12f('0x46')](_0x5933dd['body'],{})[_0xb12f('0x20')](function(_0x395880){var _0x4d515c=_0x5933dd[_0xb12f('0x47')]['get']({'plain':!![]});if(!_0x4d515c)throw new Error(_0xb12f('0x48'));if(_0x4d515c[_0xb12f('0x49')]==='user'){var _0xff74de=_0x395880[_0xb12f('0x21')]({'plain':!![]});var _0x310e79=_0xb12f('0x22');return db[_0xb12f('0x4a')]['find']({'where':{'name':_0x310e79,'userProfileId':_0x4d515c[_0xb12f('0x4b')]},'raw':!![]})[_0xb12f('0x20')](function(_0x1c0bfd){if(_0x1c0bfd&&_0x1c0bfd[_0xb12f('0x4c')]===0x0){return db['UserProfileResource'][_0xb12f('0x46')]({'name':_0xff74de[_0xb12f('0x27')],'resourceId':_0xff74de['id'],'type':_0x1c0bfd[_0xb12f('0x27')],'sectionId':_0x1c0bfd['id']},{})['then'](function(){return _0x395880;});}else{return _0x395880;}})[_0xb12f('0x3f')](function(_0x2c243b){logger['error'](_0xb12f('0x4d'),_0x2c243b);throw _0x2c243b;});}return _0x395880;})['then'](respondWithResult(_0x2d9997,0xc9))['catch'](handleError(_0x2d9997,null));};exports[_0xb12f('0x1f')]=function(_0x2ac5f9,_0x53b509){if(_0x2ac5f9['body']['id']){delete _0x2ac5f9[_0xb12f('0x4e')]['id'];}return db[_0xb12f('0x2a')][_0xb12f('0x45')]({'where':{'id':_0x2ac5f9[_0xb12f('0x41')]['id']}})[_0xb12f('0x20')](handleEntityNotFound(_0x53b509,null))[_0xb12f('0x20')](saveUpdates(_0x2ac5f9[_0xb12f('0x4e')],null))['then'](respondWithResult(_0x53b509,null))[_0xb12f('0x3f')](handleError(_0x53b509,null));};exports[_0xb12f('0x24')]=function(_0x447c6d,_0x42a317){return db['SquareOdbc']['find']({'where':{'id':_0x447c6d[_0xb12f('0x41')]['id']}})['then'](handleEntityNotFound(_0x42a317,null))[_0xb12f('0x20')](removeEntity(_0x42a317,null))[_0xb12f('0x3f')](handleError(_0x42a317,null));};exports[_0xb12f('0x4f')]=function(_0x228b45,_0x312822,_0x3f615a){var _0x107cfb;return db[_0xb12f('0x2a')][_0xb12f('0x45')]({'where':{'id':_0x228b45[_0xb12f('0x41')]['id']},'attributes':['id',_0xb12f('0x50')]})[_0xb12f('0x20')](handleEntityNotFound(_0x312822,null))[_0xb12f('0x20')](function(_0x29d867){if(_0x29d867){var _0x447f7d=require('odbc')();_0x447f7d[_0xb12f('0x51')](_0x29d867[_0xb12f('0x50')]);_0x447f7d[_0xb12f('0x52')]();return _0x29d867;}})['then'](respondWithResult(_0x312822,null))['catch'](handleError(_0x312822,null));};
\ No newline at end of file
+var _0xd772=['where','pick','merge','name','filter','options','includeAll','include','findAll','rows','show','params','catch','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','find','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','openSync','dsn','closeSync','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','util','sox','ejs','fs-extra','lodash','crypto','to-csv','querystring','papaparse','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','end','status','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','then','destroy','get','error','stack','map','SquareOdbc','rawAttributes','fieldName','type','key','model','keys','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','sort'];(function(_0x2797c5,_0x1eed11){var _0x18b956=function(_0x54464b){while(--_0x54464b){_0x2797c5['push'](_0x2797c5['shift']());}};_0x18b956(++_0x1eed11);}(_0xd772,0x67));var _0x2d77=function(_0x5b2907,_0x91946c){_0x5b2907=_0x5b2907-0x0;var _0x5f40e1=_0xd772[_0x5b2907];return _0x5f40e1;};'use strict';var emlformat=require(_0x2d77('0x0'));var rimraf=require(_0x2d77('0x1'));var zipdir=require(_0x2d77('0x2'));var jsonpatch=require(_0x2d77('0x3'));var rp=require(_0x2d77('0x4'));var moment=require('moment');var BPromise=require(_0x2d77('0x5'));var Mustache=require('mustache');var util=require(_0x2d77('0x6'));var path=require('path');var sox=require(_0x2d77('0x7'));var csv=require('to-csv');var ejs=require(_0x2d77('0x8'));var fs=require('fs');var fs_extra=require(_0x2d77('0x9'));var _=require(_0x2d77('0xa'));var squel=require('squel');var crypto=require(_0x2d77('0xb'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x2d77('0xc'));var querystring=require(_0x2d77('0xd'));var Papa=require(_0x2d77('0xe'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0x2d77('0xf'));var hardwareService=require(_0x2d77('0x10'));var logger=require('../../config/logger')(_0x2d77('0x11'));var utils=require(_0x2d77('0x12'));var config=require(_0x2d77('0x13'));var licenseUtil=require('../../config/license/util');var db=require(_0x2d77('0x14'))['db'];function respondWithStatusCode(_0x1e4269,_0x4fbb71){_0x4fbb71=_0x4fbb71||0xcc;return function(_0x3786c0){if(_0x3786c0){return _0x1e4269[_0x2d77('0x15')](_0x4fbb71);}return _0x1e4269['status'](_0x4fbb71)[_0x2d77('0x16')]();};}function respondWithResult(_0x3754c0,_0x547c05){_0x547c05=_0x547c05||0xc8;return function(_0x3e3d45){if(_0x3e3d45){return _0x3754c0[_0x2d77('0x17')](_0x547c05)[_0x2d77('0x18')](_0x3e3d45);}};}function respondWithFilteredResult(_0x27b213,_0x3c44a9){return function(_0x558193){if(_0x558193){var _0x35e37d=typeof _0x3c44a9[_0x2d77('0x19')]===_0x2d77('0x1a')&&typeof _0x3c44a9[_0x2d77('0x1b')]===_0x2d77('0x1a');var _0x459143=_0x558193[_0x2d77('0x1c')];var _0x3902fe=_0x35e37d?0x0:_0x3c44a9['offset'];var _0x238cf3=_0x35e37d?_0x558193[_0x2d77('0x1c')]:_0x3c44a9['offset']+_0x3c44a9[_0x2d77('0x1b')];var _0x30cd60;if(_0x238cf3>=_0x459143){_0x238cf3=_0x459143;_0x30cd60=0xc8;}else{_0x30cd60=0xce;}_0x27b213[_0x2d77('0x17')](_0x30cd60);return _0x27b213[_0x2d77('0x1d')](_0x2d77('0x1e'),_0x3902fe+'-'+_0x238cf3+'/'+_0x459143)[_0x2d77('0x18')](_0x558193);}return null;};}function patchUpdates(_0x54a6e9){return function(_0x3250bc){try{jsonpatch[_0x2d77('0x1f')](_0x3250bc,_0x54a6e9,!![]);}catch(_0x303efb){return BPromise[_0x2d77('0x20')](_0x303efb);}return _0x3250bc[_0x2d77('0x21')]();};}function saveUpdates(_0x449639,_0x5c94ba){return function(_0x404f9e){if(_0x404f9e){return _0x404f9e[_0x2d77('0x22')](_0x449639)[_0x2d77('0x23')](function(_0x276488){return _0x276488;});}return null;};}function removeEntity(_0x342a2b,_0x15601f){return function(_0x2a1a60){if(_0x2a1a60){return _0x2a1a60[_0x2d77('0x24')]()[_0x2d77('0x23')](function(){var _0x4e410e=_0x2a1a60[_0x2d77('0x25')]({'plain':!![]});var _0x3e7f32='ODBC';return db['UserProfileResource'][_0x2d77('0x24')]({'where':{'type':_0x3e7f32,'resourceId':_0x4e410e['id']}})['then'](function(){return _0x2a1a60;});})[_0x2d77('0x23')](function(){_0x342a2b[_0x2d77('0x17')](0xcc)[_0x2d77('0x16')]();});}};}function handleEntityNotFound(_0x19dad5,_0x36d48b){return function(_0x5da109){if(!_0x5da109){_0x19dad5['sendStatus'](0x194);}return _0x5da109;};}function handleError(_0x406550,_0x20280e){_0x20280e=_0x20280e||0x1f4;return function(_0x328fac){logger[_0x2d77('0x26')](_0x328fac[_0x2d77('0x27')]);if(_0x328fac['name']){delete _0x328fac['name'];}_0x406550['status'](_0x20280e)['send'](_0x328fac);};}exports['index']=function(_0x5ac10d,_0xd46861){var _0x5c36a7={},_0x2c6c91={},_0x5bf779={'count':0x0,'rows':[]};var _0x5cad74=_[_0x2d77('0x28')](db[_0x2d77('0x29')][_0x2d77('0x2a')],function(_0x44a349){return{'name':_0x44a349[_0x2d77('0x2b')],'type':_0x44a349[_0x2d77('0x2c')][_0x2d77('0x2d')]};});_0x2c6c91[_0x2d77('0x2e')]=_[_0x2d77('0x28')](_0x5cad74,'name');_0x2c6c91['query']=_[_0x2d77('0x2f')](_0x5ac10d[_0x2d77('0x30')]);_0x2c6c91[_0x2d77('0x31')]=_[_0x2d77('0x32')](_0x2c6c91[_0x2d77('0x2e')],_0x2c6c91['query']);_0x5c36a7[_0x2d77('0x33')]=_[_0x2d77('0x32')](_0x2c6c91[_0x2d77('0x2e')],qs[_0x2d77('0x34')](_0x5ac10d[_0x2d77('0x30')]['fields']));_0x5c36a7['attributes']=_0x5c36a7[_0x2d77('0x33')][_0x2d77('0x35')]?_0x5c36a7['attributes']:_0x2c6c91[_0x2d77('0x2e')];if(!_0x5ac10d[_0x2d77('0x30')][_0x2d77('0x36')](_0x2d77('0x37'))){_0x5c36a7['limit']=qs['limit'](_0x5ac10d[_0x2d77('0x30')][_0x2d77('0x1b')]);_0x5c36a7['offset']=qs['offset'](_0x5ac10d[_0x2d77('0x30')][_0x2d77('0x19')]);}_0x5c36a7['order']=qs[_0x2d77('0x38')](_0x5ac10d[_0x2d77('0x30')][_0x2d77('0x38')]);_0x5c36a7[_0x2d77('0x39')]=qs[_0x2d77('0x31')](_[_0x2d77('0x3a')](_0x5ac10d['query'],_0x2c6c91['filters']),_0x5cad74);if(_0x5ac10d[_0x2d77('0x30')]['filter']){_0x5c36a7[_0x2d77('0x39')]=_[_0x2d77('0x3b')](_0x5c36a7[_0x2d77('0x39')],{'$or':_[_0x2d77('0x28')](_0x5cad74,function(_0x552c16){if(_0x552c16[_0x2d77('0x2c')]!=='VIRTUAL'){var _0x34c7bb={};_0x34c7bb[_0x552c16[_0x2d77('0x3c')]]={'$like':'%'+_0x5ac10d[_0x2d77('0x30')][_0x2d77('0x3d')]+'%'};return _0x34c7bb;}})});}_0x5c36a7=_[_0x2d77('0x3b')]({},_0x5c36a7,_0x5ac10d[_0x2d77('0x3e')]);var _0x3ad04f={'where':_0x5c36a7[_0x2d77('0x39')]};return db[_0x2d77('0x29')][_0x2d77('0x1c')](_0x3ad04f)[_0x2d77('0x23')](function(_0x2b2e2b){_0x5bf779[_0x2d77('0x1c')]=_0x2b2e2b;if(_0x5ac10d[_0x2d77('0x30')][_0x2d77('0x3f')]){_0x5c36a7[_0x2d77('0x40')]=[{'all':!![]}];}return db[_0x2d77('0x29')][_0x2d77('0x41')](_0x5c36a7);})[_0x2d77('0x23')](function(_0x357023){_0x5bf779[_0x2d77('0x42')]=_0x357023;return _0x5bf779;})[_0x2d77('0x23')](respondWithFilteredResult(_0xd46861,_0x5c36a7))['catch'](handleError(_0xd46861,null));};exports[_0x2d77('0x43')]=function(_0x192894,_0x117a5f){var _0x58d844={'raw':!![],'where':{'id':_0x192894[_0x2d77('0x44')]['id']}},_0x2eb803={};_0x2eb803[_0x2d77('0x2e')]=_[_0x2d77('0x2f')](db[_0x2d77('0x29')][_0x2d77('0x2a')]);_0x2eb803[_0x2d77('0x30')]=_[_0x2d77('0x2f')](_0x192894['query']);_0x2eb803['filters']=_[_0x2d77('0x32')](_0x2eb803[_0x2d77('0x2e')],_0x2eb803[_0x2d77('0x30')]);_0x58d844['attributes']=_[_0x2d77('0x32')](_0x2eb803[_0x2d77('0x2e')],qs[_0x2d77('0x34')](_0x192894['query']['fields']));_0x58d844[_0x2d77('0x33')]=_0x58d844[_0x2d77('0x33')][_0x2d77('0x35')]?_0x58d844[_0x2d77('0x33')]:_0x2eb803[_0x2d77('0x2e')];if(_0x192894['query'][_0x2d77('0x3f')]){_0x58d844[_0x2d77('0x40')]=[{'all':!![]}];}_0x58d844=_[_0x2d77('0x3b')]({},_0x58d844,_0x192894[_0x2d77('0x3e')]);return db[_0x2d77('0x29')]['find'](_0x58d844)[_0x2d77('0x23')](handleEntityNotFound(_0x117a5f,null))[_0x2d77('0x23')](respondWithResult(_0x117a5f,null))[_0x2d77('0x45')](handleError(_0x117a5f,null));};exports[_0x2d77('0x46')]=function(_0x2be34c,_0x2bbd8b){return db[_0x2d77('0x29')][_0x2d77('0x46')](_0x2be34c['body'],{})['then'](function(_0x10f3e8){var _0x19ceb9=_0x2be34c[_0x2d77('0x47')][_0x2d77('0x25')]({'plain':!![]});if(!_0x19ceb9)throw new Error(_0x2d77('0x48'));if(_0x19ceb9[_0x2d77('0x49')]==='user'){var _0x2f9a93=_0x10f3e8[_0x2d77('0x25')]({'plain':!![]});var _0x3983aa='ODBC';return db['UserProfileSection'][_0x2d77('0x4a')]({'where':{'name':_0x3983aa,'userProfileId':_0x19ceb9['userProfileId']},'raw':!![]})['then'](function(_0xdae7a8){if(_0xdae7a8&&_0xdae7a8['autoAssociation']===0x0){return db['UserProfileResource']['create']({'name':_0x2f9a93[_0x2d77('0x3c')],'resourceId':_0x2f9a93['id'],'type':_0xdae7a8[_0x2d77('0x3c')],'sectionId':_0xdae7a8['id']},{})['then'](function(){return _0x10f3e8;});}else{return _0x10f3e8;}})[_0x2d77('0x45')](function(_0x3ee162){logger['error'](_0x2d77('0x4b'),_0x3ee162);throw _0x3ee162;});}return _0x10f3e8;})[_0x2d77('0x23')](respondWithResult(_0x2bbd8b,0xc9))[_0x2d77('0x45')](handleError(_0x2bbd8b,null));};exports[_0x2d77('0x22')]=function(_0x783537,_0x127b0d){if(_0x783537['body']['id']){delete _0x783537['body']['id'];}return db['SquareOdbc'][_0x2d77('0x4a')]({'where':{'id':_0x783537[_0x2d77('0x44')]['id']}})['then'](handleEntityNotFound(_0x127b0d,null))[_0x2d77('0x23')](saveUpdates(_0x783537[_0x2d77('0x4c')],null))[_0x2d77('0x23')](respondWithResult(_0x127b0d,null))[_0x2d77('0x45')](handleError(_0x127b0d,null));};exports[_0x2d77('0x24')]=function(_0xe8271f,_0x3ca8a0){return db[_0x2d77('0x29')][_0x2d77('0x4a')]({'where':{'id':_0xe8271f[_0x2d77('0x44')]['id']}})[_0x2d77('0x23')](handleEntityNotFound(_0x3ca8a0,null))[_0x2d77('0x23')](removeEntity(_0x3ca8a0,null))['catch'](handleError(_0x3ca8a0,null));};exports['test']=function(_0x2effc8,_0x404c33,_0x3a3b8b){var _0x347016;return db[_0x2d77('0x29')]['find']({'where':{'id':_0x2effc8['params']['id']},'attributes':['id','dsn']})[_0x2d77('0x23')](handleEntityNotFound(_0x404c33,null))[_0x2d77('0x23')](function(_0x573e1a){if(_0x573e1a){var _0x52436d=require('odbc')();_0x52436d[_0x2d77('0x4d')](_0x573e1a[_0x2d77('0x4e')]);_0x52436d[_0x2d77('0x4f')]();return _0x573e1a;}})[_0x2d77('0x23')](respondWithResult(_0x404c33,null))[_0x2d77('0x45')](handleError(_0x404c33,null));};
\ No newline at end of file