Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function getMuSend(req, res, next) {
- res.charSet('utf-8');
- // 1. подключаемся к базе
- fb.attach({
- host: '10.80.0.23',
- database: '/var/db/firebird/data/API/kmiac-api.fdb',
- user: 'SYSDBA',
- password: 'masterkey'
- }, function(err, dataBase) {
- if (err) {
- res.json({
- success: false,
- msg: err.message
- });
- return next(err);
- }
- var where = '', params = [];
- if (req.params.idmuReceive) {
- where += 'where e.idmu_p = ?';
- params.push(req.params.idmuReceive);
- }
- var sql = 'select distinct m.idmu, m.mu from epicrisis e left join mu m on m.idmu = e.idmu_send ' + where;
- dataBase.query(sql, params, function(err, result) {
- if (err) {
- res.json({
- success: false,
- msg: err.message
- });
- } else {
- res.json({
- success: true,
- data: result
- });
- }
- // 3. отключаемся от базы
- dataBase.detach(
- function() {
- return next(err);
- }
- );
- });
- });
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement