PK!A7��nvar sql = require("mysql"); var pool = require("../db"); const opts = { errorEventName: "error", logDirectory: "logs", fileNamePattern: "log-.log", dateFormat: "YYYY-MM-DD", }; const log = require("simple-node-logger").createRollingFileLogger(opts); module.exports = { getPlansDB: function (type) { return new Promise((resolve, reject) => { let data = [type]; let query = "select id,name, type, unit, per_unit_price from plans where status=1 and type=1 order by unit asc"; pool.query(query, data, (err, results, fields) => { try { if (err) { log.info("[PLANS], [MODEL], [getPlansDB], [error], [" + err + "]"); throw err; } else { var numRows = results.length; if (numRows > 0) { return resolve(results); } else { return resolve(false); } } } catch (err) { log.info("[PLANS], [MODEL], [getPlansDB], [error], [" + err + "]"); return reject(err); } }); }); }, getPlansById: function (planId) { return new Promise((resolve, reject) => { let data = [planId]; let query = "select name,unit, per_unit_price from plans where id=? and status=1 and type=1 order by unit asc"; pool.query(query, data, (err, results, fields) => { try { if (err) { log.info("[PLANS], [MODEL], [getPlansDB], [error], [" + err + "]"); throw err; } else { var numRows = results.length; if (numRows > 0) { return resolve(results[0]); } else { return resolve(false); } } } catch (err) { log.info("[PLANS], [MODEL], [getPlansDB], [error], [" + err + "]"); return reject(err); } }); }); }, };