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 = { getCallerIds: function () { return new Promise((resolve, reject) => { let query = "select id, callerid from caller_ids where status =2 order by id desc"; pool.query(query, (err, results, fields) => { try { if (err) { throw err; } else { log.info( "[CALLER ID], [MODEL], [ALLCallerIds], CID [" + results[0] + "]" ); return resolve(results); } } catch (err) { log.info( "[CALLER ID], [MODEL], [getCallerIds], [error], [" + err + "]" ); return reject(err); } }); }); }, getApprovedCallerIds: function (userId) { return new Promise((resolve, reject) => { let query = "select id, callerid from caller_ids where status = 2 order by id desc"; const data = [userId]; pool.query(query, data, (err, results, fields) => { try { if (err) { throw err; } else { return resolve(results); } } catch (err) { log.info( "[CALLER ID], [MODEL], [getApprovedCallerIds], [error], [" + err + "]" ); return reject(err); } }); }); }, getCallerIdById: function (id) { return new Promise((resolve, reject) => { let query = "select id, callerid from caller_ids where id = ? order by id desc"; const data = [id]; pool.query(query, data, (err, results, fields) => { try { if (err) { throw err; } else { var numRows = results.length; if (numRows > 0) { return resolve(results[0]); } else { return resolve(false); } } } catch (err) { log.info( "[CALLER ID], [MODEL], [getCallerIdById], [error], [" + err + "]" ); return reject(err); } }); }); }, getPendingCallerIdCount: function () { return new Promise((resolve, reject) => { let query = "select count(*) as total from caller_ids where status=1"; pool.query(query, (err, results, fields) => { try { if (err) { throw err; } else { var numRows = results.length; if (numRows > 0) { return resolve(results[0]); } else { return resolve(false); } } } catch (err) { log.info( "[CALLER ID], [MODEL], [getPendingCallerIdCount], [error], [" + err + "]" ); return reject(err); } }); }); }, };