Built motion from commit 449495f6.|2.6.27
[motion2.git] / server / api / squareOdbc / squareOdbc.controller.js
index b3070a9..ebfc8dd 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-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
+var _0x8d1a=['userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','dsn','openSync','closeSync','eml-format','rimraf','zip-dir','request-promise','bluebird','mustache','util','path','to-csv','fs-extra','lodash','squel','crypto','jsforce','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../mysqldb','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','then','get','ODBC','UserProfileResource','destroy','sendStatus','error','stack','name','send','map','SquareOdbc','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','nolimit','order','sort','where','pick','merge','VIRTUAL','filter','options','include','rows','show','params','includeAll','find','catch','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role'];(function(_0x266ddc,_0x45aa52){var _0x39c1d7=function(_0x4cd07c){while(--_0x4cd07c){_0x266ddc['push'](_0x266ddc['shift']());}};_0x39c1d7(++_0x45aa52);}(_0x8d1a,0x1ba));var _0xa8d1=function(_0x1859c3,_0x175a95){_0x1859c3=_0x1859c3-0x0;var _0x4557ad=_0x8d1a[_0x1859c3];return _0x4557ad;};'use strict';var emlformat=require(_0xa8d1('0x0'));var rimraf=require(_0xa8d1('0x1'));var zipdir=require(_0xa8d1('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xa8d1('0x3'));var moment=require('moment');var BPromise=require(_0xa8d1('0x4'));var Mustache=require(_0xa8d1('0x5'));var util=require(_0xa8d1('0x6'));var path=require(_0xa8d1('0x7'));var sox=require('sox');var csv=require(_0xa8d1('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xa8d1('0x9'));var _=require(_0xa8d1('0xa'));var squel=require(_0xa8d1('0xb'));var crypto=require(_0xa8d1('0xc'));var jsforce=require(_0xa8d1('0xd'));var deskjs=require('desk.js');var toCsv=require(_0xa8d1('0x8'));var querystring=require(_0xa8d1('0xe'));var Papa=require(_0xa8d1('0xf'));var Redis=require(_0xa8d1('0x10'));var authService=require(_0xa8d1('0x11'));var qs=require(_0xa8d1('0x12'));var as=require(_0xa8d1('0x13'));var hardwareService=require(_0xa8d1('0x14'));var logger=require(_0xa8d1('0x15'))(_0xa8d1('0x16'));var utils=require('../../config/utils');var config=require(_0xa8d1('0x17'));var licenseUtil=require('../../config/license/util');var db=require(_0xa8d1('0x18'))['db'];function respondWithStatusCode(_0x47ed76,_0x4ffea7){_0x4ffea7=_0x4ffea7||0xcc;return function(_0x139d5a){if(_0x139d5a){return _0x47ed76['sendStatus'](_0x4ffea7);}return _0x47ed76[_0xa8d1('0x19')](_0x4ffea7)[_0xa8d1('0x1a')]();};}function respondWithResult(_0x1b3932,_0x206b8c){_0x206b8c=_0x206b8c||0xc8;return function(_0xa53382){if(_0xa53382){return _0x1b3932['status'](_0x206b8c)[_0xa8d1('0x1b')](_0xa53382);}};}function respondWithFilteredResult(_0x2202e9,_0x4707a3){return function(_0x5b1345){if(_0x5b1345){var _0x44347a=typeof _0x4707a3[_0xa8d1('0x1c')]===_0xa8d1('0x1d')&&typeof _0x4707a3[_0xa8d1('0x1e')]===_0xa8d1('0x1d');var _0x4c5292=_0x5b1345[_0xa8d1('0x1f')];var _0x5da8da=_0x44347a?0x0:_0x4707a3['offset'];var _0xd71d33=_0x44347a?_0x5b1345[_0xa8d1('0x1f')]:_0x4707a3[_0xa8d1('0x1c')]+_0x4707a3[_0xa8d1('0x1e')];var _0x4177ff;if(_0xd71d33>=_0x4c5292){_0xd71d33=_0x4c5292;_0x4177ff=0xc8;}else{_0x4177ff=0xce;}_0x2202e9[_0xa8d1('0x19')](_0x4177ff);return _0x2202e9[_0xa8d1('0x20')](_0xa8d1('0x21'),_0x5da8da+'-'+_0xd71d33+'/'+_0x4c5292)[_0xa8d1('0x1b')](_0x5b1345);}return null;};}function patchUpdates(_0x464669){return function(_0x1d4eb4){try{jsonpatch[_0xa8d1('0x22')](_0x1d4eb4,_0x464669,!![]);}catch(_0x330993){return BPromise['reject'](_0x330993);}return _0x1d4eb4['save']();};}function saveUpdates(_0x32d7c5,_0x454788){return function(_0x2c4ef7){if(_0x2c4ef7){return _0x2c4ef7['update'](_0x32d7c5)[_0xa8d1('0x23')](function(_0x3c5337){return _0x3c5337;});}return null;};}function removeEntity(_0x5b5cd4,_0x214a66){return function(_0x20f1db){if(_0x20f1db){return _0x20f1db['destroy']()['then'](function(){var _0x234953=_0x20f1db[_0xa8d1('0x24')]({'plain':!![]});var _0x7d1b90=_0xa8d1('0x25');return db[_0xa8d1('0x26')][_0xa8d1('0x27')]({'where':{'type':_0x7d1b90,'resourceId':_0x234953['id']}})[_0xa8d1('0x23')](function(){return _0x20f1db;});})['then'](function(){_0x5b5cd4[_0xa8d1('0x19')](0xcc)[_0xa8d1('0x1a')]();});}};}function handleEntityNotFound(_0x1a52db,_0x1ebd96){return function(_0x5aefbf){if(!_0x5aefbf){_0x1a52db[_0xa8d1('0x28')](0x194);}return _0x5aefbf;};}function handleError(_0x301522,_0x2c236c){_0x2c236c=_0x2c236c||0x1f4;return function(_0x2d396d){logger[_0xa8d1('0x29')](_0x2d396d[_0xa8d1('0x2a')]);if(_0x2d396d[_0xa8d1('0x2b')]){delete _0x2d396d[_0xa8d1('0x2b')];}_0x301522[_0xa8d1('0x19')](_0x2c236c)[_0xa8d1('0x2c')](_0x2d396d);};}exports['index']=function(_0x5325a5,_0x122dd7){var _0x4094ca={},_0x3dc1ea={},_0x546deb={'count':0x0,'rows':[]};var _0x38b934=_[_0xa8d1('0x2d')](db[_0xa8d1('0x2e')][_0xa8d1('0x2f')],function(_0x1a0dcc){return{'name':_0x1a0dcc[_0xa8d1('0x30')],'type':_0x1a0dcc[_0xa8d1('0x31')][_0xa8d1('0x32')]};});_0x3dc1ea[_0xa8d1('0x33')]=_[_0xa8d1('0x2d')](_0x38b934,_0xa8d1('0x2b'));_0x3dc1ea[_0xa8d1('0x34')]=_[_0xa8d1('0x35')](_0x5325a5[_0xa8d1('0x34')]);_0x3dc1ea[_0xa8d1('0x36')]=_[_0xa8d1('0x37')](_0x3dc1ea[_0xa8d1('0x33')],_0x3dc1ea['query']);_0x4094ca[_0xa8d1('0x38')]=_[_0xa8d1('0x37')](_0x3dc1ea[_0xa8d1('0x33')],qs[_0xa8d1('0x39')](_0x5325a5[_0xa8d1('0x34')]['fields']));_0x4094ca[_0xa8d1('0x38')]=_0x4094ca[_0xa8d1('0x38')][_0xa8d1('0x3a')]?_0x4094ca[_0xa8d1('0x38')]:_0x3dc1ea[_0xa8d1('0x33')];if(!_0x5325a5[_0xa8d1('0x34')]['hasOwnProperty'](_0xa8d1('0x3b'))){_0x4094ca[_0xa8d1('0x1e')]=qs['limit'](_0x5325a5[_0xa8d1('0x34')][_0xa8d1('0x1e')]);_0x4094ca[_0xa8d1('0x1c')]=qs[_0xa8d1('0x1c')](_0x5325a5['query'][_0xa8d1('0x1c')]);}_0x4094ca[_0xa8d1('0x3c')]=qs['sort'](_0x5325a5[_0xa8d1('0x34')][_0xa8d1('0x3d')]);_0x4094ca[_0xa8d1('0x3e')]=qs[_0xa8d1('0x36')](_[_0xa8d1('0x3f')](_0x5325a5[_0xa8d1('0x34')],_0x3dc1ea[_0xa8d1('0x36')]),_0x38b934);if(_0x5325a5['query']['filter']){_0x4094ca[_0xa8d1('0x3e')]=_[_0xa8d1('0x40')](_0x4094ca[_0xa8d1('0x3e')],{'$or':_[_0xa8d1('0x2d')](_0x38b934,function(_0x4ac0c3){if(_0x4ac0c3[_0xa8d1('0x31')]!==_0xa8d1('0x41')){var _0x4d6514={};_0x4d6514[_0x4ac0c3[_0xa8d1('0x2b')]]={'$like':'%'+_0x5325a5[_0xa8d1('0x34')][_0xa8d1('0x42')]+'%'};return _0x4d6514;}})});}_0x4094ca=_[_0xa8d1('0x40')]({},_0x4094ca,_0x5325a5[_0xa8d1('0x43')]);var _0x305ef9={'where':_0x4094ca['where']};return db[_0xa8d1('0x2e')]['count'](_0x305ef9)['then'](function(_0x584172){_0x546deb[_0xa8d1('0x1f')]=_0x584172;if(_0x5325a5[_0xa8d1('0x34')]['includeAll']){_0x4094ca[_0xa8d1('0x44')]=[{'all':!![]}];}return db[_0xa8d1('0x2e')]['findAll'](_0x4094ca);})['then'](function(_0x286053){_0x546deb[_0xa8d1('0x45')]=_0x286053;return _0x546deb;})[_0xa8d1('0x23')](respondWithFilteredResult(_0x122dd7,_0x4094ca))['catch'](handleError(_0x122dd7,null));};exports[_0xa8d1('0x46')]=function(_0x43a040,_0x3ef864){var _0x392fed={'raw':!![],'where':{'id':_0x43a040[_0xa8d1('0x47')]['id']}},_0xe12bf1={};_0xe12bf1[_0xa8d1('0x33')]=_[_0xa8d1('0x35')](db[_0xa8d1('0x2e')][_0xa8d1('0x2f')]);_0xe12bf1[_0xa8d1('0x34')]=_[_0xa8d1('0x35')](_0x43a040[_0xa8d1('0x34')]);_0xe12bf1[_0xa8d1('0x36')]=_[_0xa8d1('0x37')](_0xe12bf1['model'],_0xe12bf1[_0xa8d1('0x34')]);_0x392fed['attributes']=_['intersection'](_0xe12bf1['model'],qs[_0xa8d1('0x39')](_0x43a040[_0xa8d1('0x34')]['fields']));_0x392fed['attributes']=_0x392fed['attributes'][_0xa8d1('0x3a')]?_0x392fed[_0xa8d1('0x38')]:_0xe12bf1[_0xa8d1('0x33')];if(_0x43a040[_0xa8d1('0x34')][_0xa8d1('0x48')]){_0x392fed[_0xa8d1('0x44')]=[{'all':!![]}];}_0x392fed=_[_0xa8d1('0x40')]({},_0x392fed,_0x43a040[_0xa8d1('0x43')]);return db[_0xa8d1('0x2e')][_0xa8d1('0x49')](_0x392fed)[_0xa8d1('0x23')](handleEntityNotFound(_0x3ef864,null))[_0xa8d1('0x23')](respondWithResult(_0x3ef864,null))[_0xa8d1('0x4a')](handleError(_0x3ef864,null));};exports[_0xa8d1('0x4b')]=function(_0x5251f4,_0x33b401){return db['SquareOdbc']['create'](_0x5251f4[_0xa8d1('0x4c')],{})[_0xa8d1('0x23')](function(_0x4dedd1){var _0x397cfe=_0x5251f4[_0xa8d1('0x4d')]['get']({'plain':!![]});if(!_0x397cfe)throw new Error(_0xa8d1('0x4e'));if(_0x397cfe[_0xa8d1('0x4f')]==='user'){var _0x564973=_0x4dedd1['get']({'plain':!![]});var _0x15231b=_0xa8d1('0x25');return db['UserProfileSection'][_0xa8d1('0x49')]({'where':{'name':_0x15231b,'userProfileId':_0x397cfe[_0xa8d1('0x50')]},'raw':!![]})[_0xa8d1('0x23')](function(_0x257aa1){if(_0x257aa1&&_0x257aa1[_0xa8d1('0x51')]===0x0){return db['UserProfileResource'][_0xa8d1('0x4b')]({'name':_0x564973['name'],'resourceId':_0x564973['id'],'type':_0x257aa1['name'],'sectionId':_0x257aa1['id']},{})[_0xa8d1('0x23')](function(){return _0x4dedd1;});}else{return _0x4dedd1;}})['catch'](function(_0x4c5d41){logger['error'](_0xa8d1('0x52'),_0x4c5d41);throw _0x4c5d41;});}return _0x4dedd1;})[_0xa8d1('0x23')](respondWithResult(_0x33b401,0xc9))[_0xa8d1('0x4a')](handleError(_0x33b401,null));};exports[_0xa8d1('0x53')]=function(_0x49c313,_0x3ef8cc){if(_0x49c313[_0xa8d1('0x4c')]['id']){delete _0x49c313['body']['id'];}return db[_0xa8d1('0x2e')]['find']({'where':{'id':_0x49c313[_0xa8d1('0x47')]['id']}})['then'](handleEntityNotFound(_0x3ef8cc,null))[_0xa8d1('0x23')](saveUpdates(_0x49c313[_0xa8d1('0x4c')],null))[_0xa8d1('0x23')](respondWithResult(_0x3ef8cc,null))['catch'](handleError(_0x3ef8cc,null));};exports['destroy']=function(_0x52474f,_0x21d41e){return db['SquareOdbc']['find']({'where':{'id':_0x52474f[_0xa8d1('0x47')]['id']}})[_0xa8d1('0x23')](handleEntityNotFound(_0x21d41e,null))[_0xa8d1('0x23')](removeEntity(_0x21d41e,null))['catch'](handleError(_0x21d41e,null));};exports['test']=function(_0x3514d5,_0x818f3e,_0x2ec2ef){var _0x481764;return db[_0xa8d1('0x2e')][_0xa8d1('0x49')]({'where':{'id':_0x3514d5[_0xa8d1('0x47')]['id']},'attributes':['id',_0xa8d1('0x54')]})['then'](handleEntityNotFound(_0x818f3e,null))[_0xa8d1('0x23')](function(_0x171647){if(_0x171647){var _0x3439ed=require('odbc')();_0x3439ed[_0xa8d1('0x55')](_0x171647[_0xa8d1('0x54')]);_0x3439ed[_0xa8d1('0x56')]();return _0x171647;}})[_0xa8d1('0x23')](respondWithResult(_0x818f3e,null))[_0xa8d1('0x4a')](handleError(_0x818f3e,null));};
\ No newline at end of file