#include "orderrepository.h" #include "../db/databasemanager.h" #include #include #include #include namespace { bool ensureOpen(QString *error) { return DatabaseManager::instance().open(error); } void setError(const QSqlQuery &query, QString *error) { if (error) { *error = query.lastError().text(); } } Order readOrder(QSqlQuery &query) { Order order; order.id = query.value("id").toInt(); order.no = query.value("no").toString(); order.productionNo = query.value("production_no").toString(); order.drawingNo = query.value("drawing_no").toString(); order.batchNo = query.value("batch_no").toString(); order.planNum = query.value("plan_num").toInt(); order.qualified = query.value("qualified").toInt(); order.unqualified = query.value("unqualified").toInt(); order.status = query.value("status").toString(); order.inspectionMode = query.value("inspection_mode").toString(); order.startTrayNo = query.value("start_tray_no").toInt(); order.startSlotNo = query.value("start_slot_no").toInt(); order.beginTime = query.value("begin_time").toDateTime(); order.endTime = query.value("end_time").toDateTime(); order.remark = query.value("remark").toString(); order.createdAt = query.value("created_at").toDateTime(); order.updatedAt = query.value("updated_at").toDateTime(); return order; } } QList OrderRepository::listOrders(QString *error, int limit) { QList orders; if (!ensureOpen(error)) { return orders; } QSqlQuery query(DatabaseManager::instance().database()); query.prepare("select id, no, production_no, drawing_no, batch_no, plan_num, " "qualified, unqualified, status, inspection_mode, start_tray_no, " "start_slot_no, begin_time, end_time, remark, " "created_at, updated_at " "from orders order by id desc limit :limit"); query.bindValue(":limit", limit); if (!query.exec()) { setError(query, error); return orders; } while (query.next()) { orders.append(readOrder(query)); } return orders; } bool OrderRepository::findOrder(int id, Order *order, QString *error) { if (!order || !ensureOpen(error)) { return false; } QSqlQuery query(DatabaseManager::instance().database()); query.prepare("select id, no, production_no, drawing_no, batch_no, plan_num, " "qualified, unqualified, status, inspection_mode, start_tray_no, " "start_slot_no, begin_time, end_time, remark, " "created_at, updated_at from orders where id = :id"); query.bindValue(":id", id); if (!query.exec()) { setError(query, error); return false; } if (!query.next()) { if (error) { *error = QString("Order not found: %1").arg(id); } return false; } *order = readOrder(query); return true; } bool OrderRepository::findOrderForUpdate(int id, Order *order, QString *error) { if (!order || !ensureOpen(error)) { return false; } QSqlQuery query(DatabaseManager::instance().database()); query.prepare("select id, no, production_no, drawing_no, batch_no, plan_num, " "qualified, unqualified, status, inspection_mode, start_tray_no, " "start_slot_no, begin_time, end_time, remark, " "created_at, updated_at from orders where id = :id for update"); query.bindValue(":id", id); if (!query.exec()) { setError(query, error); return false; } if (!query.next()) { if (error) { *error = QString("Order not found: %1").arg(id); } return false; } *order = readOrder(query); return true; } bool OrderRepository::findUnfinishedOrder(Order *order, QString *error) { if (!order || !ensureOpen(error)) { return false; } QSqlQuery query(DatabaseManager::instance().database()); query.prepare("select id, no, production_no, drawing_no, batch_no, plan_num, " "qualified, unqualified, status, inspection_mode, start_tray_no, " "start_slot_no, begin_time, end_time, remark, created_at, updated_at " "from orders " "where status in ('NOT_START', 'RUNNING', 'PAUSED') " "order by id desc limit 1"); if (!query.exec()) { setError(query, error); return false; } if (!query.next()) { *order = Order(); return true; } *order = readOrder(query); return true; } bool OrderRepository::insertOrder(Order *order, QString *error) { if (!order || !ensureOpen(error)) { return false; } const QSqlDatabase database = DatabaseManager::instance().database(); const bool sqlite = DatabaseManager::instance().config().driverName == "QSQLITE"; QSqlQuery query(database); query.prepare("insert into orders " "(no, production_no, drawing_no, batch_no, plan_num, qualified, " "unqualified, status, inspection_mode, start_tray_no, start_slot_no, " "begin_time, end_time, remark) " "values (:no, :production_no, :drawing_no, :batch_no, :plan_num, " ":qualified, :unqualified, :status, :inspection_mode, " ":start_tray_no, :start_slot_no, :begin_time, :end_time, :remark)" + (sqlite ? QString() : QString(" returning id"))); query.bindValue(":no", order->no); query.bindValue(":production_no", order->productionNo); query.bindValue(":drawing_no", order->drawingNo); query.bindValue(":batch_no", order->batchNo); query.bindValue(":plan_num", order->planNum); query.bindValue(":qualified", order->qualified); query.bindValue(":unqualified", order->unqualified); query.bindValue(":status", order->status.isEmpty() ? "NOT_START" : order->status); query.bindValue(":inspection_mode", order->inspectionMode); query.bindValue(":start_tray_no", order->startTrayNo); query.bindValue(":start_slot_no", order->startSlotNo); query.bindValue(":begin_time", order->beginTime.isValid() ? QVariant(order->beginTime) : QVariant(QVariant::DateTime)); query.bindValue(":end_time", order->endTime.isValid() ? QVariant(order->endTime) : QVariant(QVariant::DateTime)); query.bindValue(":remark", order->remark); if (!query.exec()) { setError(query, error); return false; } if (sqlite) { order->id = query.lastInsertId().toInt(); } else { if (!query.next()) { setError(query, error); return false; } order->id = query.value(0).toInt(); } return true; } bool OrderRepository::updateOrderStatus(int id, const QString &status, QString *error) { if (!ensureOpen(error)) { return false; } QSqlQuery query(DatabaseManager::instance().database()); query.prepare("update orders set status = :status, updated_at = now() where id = :id"); query.bindValue(":status", status); query.bindValue(":id", id); if (!query.exec()) { setError(query, error); return false; } return true; } bool OrderRepository::updateOrderLifecycle(int id, const QString &status, const QDateTime &beginTime, const QDateTime &endTime, QString *error) { if (!ensureOpen(error)) { return false; } QSqlQuery query(DatabaseManager::instance().database()); query.prepare("update orders set status = :status, begin_time = :begin_time, " "end_time = :end_time, updated_at = now() where id = :id"); query.bindValue(":status", status); query.bindValue(":begin_time", beginTime.isValid() ? QVariant(beginTime) : QVariant(QVariant::DateTime)); query.bindValue(":end_time", endTime.isValid() ? QVariant(endTime) : QVariant(QVariant::DateTime)); query.bindValue(":id", id); if (!query.exec()) { setError(query, error); return false; } return query.numRowsAffected() == 1; } bool OrderRepository::refreshProgress(int id, QString *error) { if (!ensureOpen(error)) { return false; } QSqlQuery query(DatabaseManager::instance().database()); query.prepare("update orders set " "qualified = (select count(*) from workpieces " "where order_id = :id and state = 'OK'), " "unqualified = (select count(*) from workpieces " "where order_id = :id and state = 'NG'), " "updated_at = now() where id = :id"); query.bindValue(":id", id); if (!query.exec()) { setError(query, error); return false; } return query.numRowsAffected() == 1; } bool OrderRepository::removeOrder(int id, QString *error) { if (!ensureOpen(error)) { return false; } const QStringList statements = QStringList() << "delete from workpiece_process_records where order_id = :id" << "delete from production_state_history where order_id = :id" << "delete from production_runs where order_id = :id" << "delete from alarm_records where order_id = :id" << "delete from orders where id = :id"; for (const QString &statement : statements) { QSqlQuery query(DatabaseManager::instance().database()); query.prepare(statement); query.bindValue(":id", id); if (!query.exec()) { setError(query, error); return false; } } return true; }