Press n or j to go to the next uncovered block, b, p or k for the previous block.
| 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 | 2x 2x 2x | // Member model
const { getOne, getAll, run } = require("./query");
const Member = {
async findById(memberId) {
return getOne("SELECT * FROM members WHERE member_id = ?", [memberId]);
},
async findByCode(memberCode) {
return getOne("SELECT * FROM members WHERE member_code = ?", [memberCode]);
},
async getAll() {
return getAll("SELECT * FROM members ORDER BY member_code");
},
async getActive() {
return getAll(
'SELECT * FROM members WHERE status = "active" ORDER BY member_code',
);
},
async create(memberCode, fullName, email, phone, memberType, maxBooks = 3) {
const registrationDate = new Date().toISOString().split("T")[0];
return run(
"INSERT INTO members (member_code, full_name, email, phone, member_type, registration_date, max_books) VALUES (?, ?, ?, ?, ?, ?, ?)",
[
memberCode,
fullName,
email,
phone,
memberType,
registrationDate,
maxBooks,
],
);
},
async update(memberId, fullName, email, phone, memberType, status, maxBooks) {
return run(
"UPDATE members SET full_name = ?, email = ?, phone = ?, member_type = ?, status = ?, max_books = ? WHERE member_id = ?",
[fullName, email, phone, memberType, status, maxBooks, memberId],
);
},
async updateStatus(memberId, status) {
return run("UPDATE members SET status = ? WHERE member_id = ?", [
status,
memberId,
]);
},
async delete(memberId) {
return run("DELETE FROM members WHERE member_id = ?", [memberId]);
},
async getBorrowingCount(memberId) {
const result = await getOne(
'SELECT COUNT(*) as count FROM borrowing WHERE member_id = ? AND (status = "borrowed" OR status = "overdue")',
[memberId],
);
return result ? result.count : 0;
},
};
module.exports = Member;
|