#include "basecommonapi.h"

BaseCommonApi::BaseCommonApi()
{

}

//获取部门任务数据
QList<Dept> BaseCommonApi::getAllData() {
    QList<Dept> result;

    DatabaseConnection *Conn=DatabaseConnection::getInstance();
    QSqlQuery query(Conn->getDatabase());
    //QSqlQuery query;

    query.exec("SELECT  bi.id ,br.sample_name , br.sample_model ,ei.help_instruction ,ei.manufacture_no ,ei.manufacturer ,bi.customer_name ,dept.FULL_NAME,bi.require_over_time ,bi.is_urgent FROM biz_business_order_info bi LEft JOIN biz_business_order_sample_relation br ON bi.id = br.order_id LEft JOIN eqpt_equipment_info ei ON br.sample_no = ei.equipment_no LEft JOIN sys_dept dept ON ei.dept_id = dept.ID LEft JOIN sys_user user ON user.ID = bi.create_user_id");

    while (query.next()) {
        Dept Dept;
        Dept.id = query.value("id").toString();
        Dept.sample_name = query.value("sample_name").toString();
        Dept.sample_model = query.value("sample_model").toString();
        Dept.help_instruction = query.value("help_instruction").toString();
        Dept.manufacture_no = query.value("manufacture_no").toString();
        Dept.manufacturer = query.value("manufacturer").toString();
        Dept.customer_name = query.value("customer_name").toString();
        Dept.FULL_NAME = query.value("FULL_NAME").toString();
        Dept.require_over_time = query.value("require_over_time").toString();
        Dept.is_urgent = query.value("is_urgent").toString();
        result.append(Dept);
    }

    return result;
}

//  被检设备管理
QList<TestedDevice> BaseCommonApi::getTestedDevice()
{
    QList<TestedDevice> result;
    QSqlQuery query;
    query.exec("SELECT eei.equipment_name ,eei.model ,eei.help_instruction ,eei.manufacture_no ,eei.product_country ,eei.manufacturer ,eei.product_date ,eei.purchase_date ,eei.unit_price ,eei.usage_status ,eei.quality_condition ,sys_dept.FULL_NAME ,"
               "eei.category , eei.check_cycle ,eei.level , eei.remark  from eqpt_equipment_info eei LEFT JOIN sys_dept ON sys_dept.ID = eei.dept_id WHERE eei.id = :id ");
    if (query.exec()) {
        while (query.next()) {
            TestedDevice testedDevice;
            testedDevice.id = query.value("id").toString();
            testedDevice.equipment_name = query.value("equipment_name").toString();
            testedDevice.model = query.value("model").toString();
            testedDevice.help_instruction = query.value("help_instruction").toString();
            testedDevice.manufacture_no = query.value("manufacture_no").toString();
            testedDevice.manufacturer = query.value("manufacturer").toString();
            testedDevice.FULL_NAME = query.value("FULL_NAME").toString();
            testedDevice.meter_identify = query.value("meter_identify").toString();
            testedDevice.check_cycle = query.value("check_cycle").toString();
            testedDevice.certificate_valid = query.value("certificate_valid").toString();

            result.append(testedDevice);
        }
    } else {
        qDebug() << "Query execution failed: " << query.lastError().text();
    }

    return result;
}