Sid Gifari File Manager Pro v10.0.3

📂 / (Root) / home / orkouolp / node_js / orkofarms.com / api

📍 /home/orkouolp/node_js/orkofarms.com/api

✏️ Editing: getMilkSales.js Writable

const firebase = require('../firebase'), con = require('../mysql').con;
const logger = require('../log4js').logger;
// const MilkSale = require('../models/milkSale.model');

const getMilkSales = async (req, res) => { let query = {}; //id = 0;
  console.log('GET /get-milk-sales'); //+req.params.compId+"?"+req.query.year);
  logger.debug('GET /get-milk-sales');
  // MilkSale.find(query)
  // .then(async (milkSales) => { let due = 0; //console.log('milkSales:', milkSales);
  //   const docs = (await firebase.db.collection('settings').get()).docs; //console.log('docs:', docs);
  //   if(docs.length>0) due = docs[0].data().due;
  //   res.send({milkSales, due});
  // })
  // .catch(err => console.log(err));

return con.query('SELECT * FROM milk_sales', async (err, rows) => {
    if(err) {
      logger.debug('Database Connection Error: ')+err.toString();
      throw err;
    }
    logger.debug('Database Connection active for getting milk sale! rows: '+rows.toString());
    let due = 0; //console.log('rows:', rows);
    const docs = (await firebase.db.collection('settings').get()).docs; //console.log('docs:', docs);
    if(docs.length>0) due = docs[0].data().due;
    logger.debug('sending milkSales...');
    res.send({ milkSales: rows, due });
  });

// res.send({ milkSales: [], due: 0 });
}

module.exports = getMilkSales;

Sid Gifari File Manager Pro v10.0.3

📂 / (Root) / home / orkouolp / node_js / orkofarms.com / api

📍 /home/orkouolp/node_js/orkofarms.com/api

✏️ Editing: getMilkSales.js Writable

const firebase = require('../firebase'), con = require('../mysql').con;
const logger = require('../log4js').logger;
// const MilkSale = require('../models/milkSale.model');

const getMilkSales = async (req, res) => { let query = {}; //id = 0;
  console.log('GET /get-milk-sales'); //+req.params.compId+"?"+req.query.year);
  logger.debug('GET /get-milk-sales');
  // MilkSale.find(query)
  // .then(async (milkSales) => { let due = 0; //console.log('milkSales:', milkSales);
  //   const docs = (await firebase.db.collection('settings').get()).docs; //console.log('docs:', docs);
  //   if(docs.length>0) due = docs[0].data().due;
  //   res.send({milkSales, due});
  // })
  // .catch(err => console.log(err));

return con.query('SELECT * FROM milk_sales', async (err, rows) => {
    if(err) {
      logger.debug('Database Connection Error: ')+err.toString();
      throw err;
    }
    logger.debug('Database Connection active for getting milk sale! rows: '+rows.toString());
    let due = 0; //console.log('rows:', rows);
    const docs = (await firebase.db.collection('settings').get()).docs; //console.log('docs:', docs);
    if(docs.length>0) due = docs[0].data().due;
    logger.debug('sending milkSales...');
    res.send({ milkSales: rows, due });
  });

// res.send({ milkSales: [], due: 0 });
}

module.exports = getMilkSales;