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 68 69 70 71 | 4x 1x 1x 1x 1x 1x 1x 1x 1x 1x | import db from './index';
const { Lot } = db;
async function findLot(query, opts = {}) {
return Lot.findOne({
where: query,
...opts,
});
}
async function findLots(query, opts = {}) {
return Lot.findAll({
where: query,
...opts,
});
}
async function findAndCountLots(query, opts = {}) {
return Lot.findAndCountAll({
where: query,
...opts,
});
}
async function createLots(lots, opts = {}) {
return Lot.bulkCreate(lots, opts);
}
async function createLot(lot) {
return Lot.create(lot);
}
async function updateLot(query, queryUpd, opts = {}) {
return Lot.update(queryUpd, {
where: query,
...opts,
});
}
async function deleteLot(query, opts = {}) {
return Lot.destroy({
where: query,
...opts,
});
}
async function getLastLot(branchCode) {
return Lot.max('code', {
where: {
branchCode
}
})
}
async function getLastLotWithoutBranchCode() {
return await Lot.max('code')
}
export default {
findLot,
findLots,
findAndCountLots,
createLot,
createLots,
updateLot,
deleteLot,
getLastLot,
getLastLotWithoutBranchCode,
}
|