#ifndef BASECOMMONAPI_H
#define BASECOMMONAPI_H

#include <QtSql>
#include <QDebug>
#include <QString>
#include <vector>
#include "QList"
#include "databaseconnection.h"
#include "id\IdWorker.h"




//部门任务
class Dept {
public:
   QString id;
   QString sample_name;
   QString sample_model;
   QString help_instruction;
   QString manufacture_no;
   QString manufacturer;
   QString customer_name;
   QString FULL_NAME;
   QDateTime require_over_time;
   QString is_urgent;
};
//我的任务
class  MyTask
{
public:
    QString id;
    QString sample_name;
    QString sample_model;
    QString help_instruction;
    QString manufacture_no;
    QString manufacturer;
    QString customer_name;
    QString FULL_NAME;
    QDateTime require_over_time;
    QString is_urgent;
};
//创建任务单-首页
class CreateTaskList
{
public:
    QString id;
    QString order_no;
    QString customer_name;
    QString DEPT_FULL_NAME;
    QDateTime require_over_time;
    QString deliverer;
    QString is_urgent;
};
//创建任务单-查看任务单
class CatTask
{
public:
    QString id;
    QString order_no;
    QString customer_name;
    QString DEPT_FULL_NAME;
    QDateTime require_over_time;
    QString deliverer;
    QString deliverer_tel;
    QString undertaker_name;
    QDateTime undertake_time;
    QString is_urgent;
    QString receive_illustrate;
};
//创建任务单-查看任务单-任务单列表
class  CatTaskList
{
public:
    QString id;
    QString sample_name;
    QString sample_model;
    QString manufacture_no;
    QString manufacturer;
    QString appendix_descn;
    QString special_require;
    QDateTime measure_complete_time;
    QString conclusion;
    QString limit_instruction;
};
//先查询 指定字段 即下拉框
class SelectSpecifyFields
{
public:
    QString id; //委托方名录表id和任务单 委托方id 对应
    QString customer_no;   //委托方编号
    QString customer_name; //委托方名称
    QString FULL_NAME; //使用部门 全称
};



//创建任务单
class InsertTask
{
public:
    QString id;
    QString order_no;  //  任务单编号
    QString customer_name; //委托方名称
    QString dept_name; // 使用部门
    QString require_over_time; //要求检完时间
    QString deliverer; //送检人
    QString deliverer_tel; //电话
    QString undertaker_name; //承接人
    QDateTime undertake_time; //承接时间
    QString is_urgent; //是否加急
    QString receive_illustrate; //接收说明
    QString customer_id;//委托人id
};
//新增任务单样品表
class OrderSampleRelation
{
public:
    QString id;
    QString order_id; //对应任务单id
    QString sample_id; //被检设备的id
    QString sample_name; //设备名称
    QString sample_model; // 型号规格
    QDateTime measure_complete_time; //检定完成时间
};
//创建任务单编辑
class UpdateTask
{
public:
    QString order_no;
    QString customer_name;
    QString require_over_time;
    QString deliverer;
    QString deliverer_tel;
    QDateTime undertake_time;
    QString is_urgent;
    QString receive_illustrate;
    QString customer_id;
};
//-------------------
//标准设备管理
class BizDevice
{
public:
    QString id;
    QString equipment_name;
    QString model;
    QString manufacture_no;
    QString manufacturer;
};
//标准设备管理-查看设备信息
class CatDeviceInfor
{
public:
   QString equipment_name;
   QString model;
   QString manufacture_no;
   QString measure_valid_date;
   QString product_country;
   QString manufacturer;
   QString produce_date;
   QString purchase_date;
   QString unit_price;
   QString usage_status;
   QString quality_status;
   QString dept_name;
   QString director_name;
   QString supplier_name;
   QString location;
   QString type;
   QString standard_type;
   QString category;
   QString level;
   QString measure_cycle;
   QString unpack_record_name;
   QString remark;

};
//标准设备管理-核查项目及核查点-直流稳压电源检定装置
class CheckDCPower
{
public:
    QString id;
    QString params;
    QString check_point;
    QString unit;
    QString resolution;
    QString urel;
    QString check_type;
    QString datum_point;
    QString cycle_number;
    QString resistance_value;
    QString resistance_value_unit;
    QString remark;
};
//---------------------

//被检设备管理
class  TestedDevice
{
public:
    QString id;
    QString equipment_name;
    QString model;
    QString help_instruction;
    QString manufacture_no;
    QString manufacturer;
    QString FULL_NAME;
    QString customer_name;
    QString meter_identify;
    QString check_cycle;
    QString certificate_valid;
};
//被检设备管理-查看设备
class TestedCatDevice
{
public:
    QString equipment_name;
    QString model;
    QString help_instruction;
    QString manufacture_no;
    QString product_country;
    QString manufacturer;
    QString product_date;
    QString purchase_date;
    QString unit_price;
    QString usage_status;
    QString quality_condition;
    QString FULL_NAME;
    QString category;
    QString check_cycle;
    QString level;
    QString remark;
};
//判断 哪个 装置表
class  JudgeCalibrationTable
{
public:
    QString item_category_id;
    QString belong_standard_equipment;
};


//被检设备管理-检定项目及检定点-检定项多功能校准源
class VerMultiCal
{
public:
    QString id;
    QString params;
    QString capacity;
    QString unit;
    QString frequency;
    QString range_range;
    QString standard_value;
    QString resolution;
    QString maximum_error;
    QString error_param_a;
    QString error_param_b;
    QDateTime update_time;
};

//检定数据管理 首页
class  VerificationData
{
public:
QString id;
QString sample_name;
QString model;
QString help_instruction;
QString manufacture_no;
QString manufacturer;
QString customer_name;
QString FULL_NAME;
QString NAME;
QDate trace_date;
QDateTime measure_valid_date;
QString meter_identify;
QString restriction_instruction;
};
//检定数据管理-检定基本信息
class  VerificationBasicDataDetails
{
public:
QString sample_name;
QString model;
QString help_instruction;
QString manufacture_no;
QString manufacturer;
QString customer_name;
QString based_documents;
QDate trace_date;
QString temperature;
QString humidity;
QString measure_address;
QDateTime measure_valid_date;
QString NAME;
QString conclusion;
QString restriction_instruction;
};
//检定数据管理-检定结果信息
class VerificationResultData
{
public:
QString id;
QString params;
QString capacity;
QString unit;
QString frequency;
QString range_range;
QString standard_value;
QString resolution;
QString maximum_error;
QString error_param_a;
QString error_param_b;
QString other_outcome;
};

//核查数据管理 首页
class CheckData
{
public:
    QString id;
    QString equipment_name;
    QString model;
    QString manufacture_no;
    QString meter_standard_name;
    QString meter_standard_id;
    QString create_user_name;
    QDate check_date;
    QString dept_name;
};
//核查数据管理-核查基本信息
class CheckDataManageBasicInfo
{
public:
    QString equipment_name;
    QString model;
    QString manufacture_no;
    QString manufacturer;
    QString temperature;
    QString humidity;
    QDate check_date;
    QString check_address;
    QString create_user_name;
    QString conclusion;
};
//核查数据管理-核查结果信息-核查项多功能校准源数据
class CheckDataManageResultManageMult
{
public:
    QString id;
    QString check_type;
    QString params;
    QString unit;
    QString frequency;
    QString check_point;
    QDate check_date;
    QString urel;
    QString tfer;
    QString dccp;
    QString flit;
};

//技术文件
class Technique_File
{
public:
    QString id;
    QString file_distribute_no;
    QString file_name;
    QString version_no;
    QDateTime active_date;
    QString remark;
};
//--------------------------
//检定程序管理
class VerificationProgramInfo
{
public:
    QString id;
    QString program_name;
    QString create_name;
    QDateTime create_time;
    QString remark;
    QString img_path; //连接图片地址
    QString tested_device_id; //被检设备id
    QString standard_device_id; //标准设备id
    QDateTime update_time;//更新时间

};


//检定程序管理-检定配置查询
//class VerificationProgramConfig
//{
//public:
//    QString id;
//    QString verification_id; //检定程序id
//    QString img_path; //连接图片地址
//    QString tested_device_id; //被检设备id
//    QString standard_device_id; //标准设备id
//    QString equipment_name;//设备名称
//    QString model; //型号规格
//    QString help_instruction; //辅助字段
//    QString manufacture_no; //出厂编号
//    QString manufacturer; //生产厂家
//};

//检定程序管理-检定配置设备通信接口查询
class VerificationProgramConfigInterface
{
public:
    QString id;
    QString device_id;//设备id
    QString communication_type;//通讯类型
    QString serial_port;//串口
    QString visa;//visa
    QDateTime create_time;
    QDateTime update_time;
};
//指令库
class   InstructionLib
{
public:
    QString id;
    QString device_id;
    QString device_name;
    QString instruct_config;
    QString instruct_read;
    QString type;
    QString belong_vername;
    QString belong_checkname;
    QDateTime create_time;
    QDateTime update_time;
};
//自动检定-结果保存-biz_business_device_measure_info 基本信息表
class SaveDeviceMeasureInfo
{
public:
    QString id; //id
    QString data_no; //数据编号     jdsj+年月+当天顺序自动生成编号 例如：jdsj202310020001、jdsj202310020002
    QString order_id;//任务单id
    QString sample_id;//受检设备id
    QString item_id;//具体检定项表的id   例如：多功能校准源检定项的id
    QDate trace_date;//测试、校准或检定日期
    QDateTime measure_valid_date;//检定有效期
    QString measure_address;//测试、校准或检定地址
    QString temperature; //温度
    QString humidity;//湿度
    QString data_source; //数据来源(自动检定系统/计量业务系统)
    QString outcome; //结果(合格/不合格)
    QDateTime create_time;
    QDateTime update_time;
};
//自动检定-结果保存-检定数据管理多功能校准源数据(自动检定输出或业务创建)
class SaveDeviceMeasureCalibrator
{
public:
    QString id;
    QString indicating_value;//示值(输出字段,特殊:指针式万用表输入字段)
    QString absolute_error;//绝对误差
    QDateTime update_time;//更新时间
    QString remark;//输出备注
};

//-----------------------------------------------------
//核查程序管理
class CheckProgramManage
{
public:
    QString id;//id
    QString check_name;//核查程序名称
    QString create_name;//创建人
    QDateTime create_time;//创建时间
    QString remark; //说明
    QString img_path;//图片路径
    QString standard_device_id;//标准设备id
    QString verification_documents_id;//核查件设备id
    QDateTime update_time;//更新时间
};






using namespace Jiawa::Core;
class BaseCommonApi
{
public:
    BaseCommonApi();


    static QList<QStringList> Search_CalibrationTable(QString DeiverId,QStringList *HeadList);
    //部门任务 废弃
//    static QList<Dept> getAllData();


    //部门任务  参数登录用户的部门id和状态
    static QList<Dept> getAllData(QString deptId,QString status);
    //我的任务
    static QList<MyTask> getMyTasks(QString id,QString status);
    //获取创建任务首页数据
    static QList<CreateTaskList>getCreateTaskList(QString id);
    //创建任务-查看任务单顶部
    static QList<CatTask>getCatTask(QString orderNo);
    //创建任务-查看任务列表底部
    static QList<CatTaskList>getCatTaskList(QString orderId);
    //查询指定下拉框的字段
    static QList<SelectSpecifyFields> getSelectSpecifyFields();
    //插入任务单基本信息
   static bool InsertTaskBasic(InsertTask insertTask);
    //插入任务单 新增任务单样品表
    static bool InsertOrderSampleRelation(OrderSampleRelation orderSample);
    //更新任务单 编辑
    static bool UpdateTask(InsertTask updateTask);
    //删除任务单
    static bool DeleteTask(QString id);
    //获取标准设备管理 首页
    static QList<BizDevice>getBizDeviceManage();
    //标准设备管理-设备基本信息
    static QList<CatDeviceInfor>getCatDeviceInfor(QString id);
    //判断是哪个核查项
    static  QString  getApparatus(QString id);
    //直流稳压电源检定装置
    static QList<CheckDCPower>getCheckDCPower(QString item_category_id,QStringList *headList);
    //获取被检设备管理首页数据
    static QList<TestedDevice> getTestedDevice();
    // 被检设备管理查看设备信息
    static QList<TestedCatDevice> getTestedCatDevice(QString id);
    //判断 哪个 装置表 传参 设备id  返回itemId
    static QList<JudgeCalibrationTable> getJudgeCalibrationTable(QString id);
    //被检设备管理-检定项目及检定点-多功能校准源
    static QList<QStringList> getVerMultiCal(QString itemId,QStringList *headList);
    // 获取检定数据管理 首页
    static QList<VerificationData> getVerificationData();
    // 检定数据管理-检定基本信息
    static QList<VerificationBasicDataDetails> getVerificationBasicDataDetails(QString id);
    //检定数据管理-检定结果信息
    static QList<VerificationResultData> getVerificationResultData(QString sampleId);
    //核查数据管理-首页
    static QList<CheckData> getCheckData();
    // 核查数据管理-基本信息
    static QList<CheckDataManageBasicInfo> getCheckDataManageBasicInfo(QString id);
    //核查数据管理-核查结果信息-核查项多功能校准源数据
    static QList<CheckDataManageResultManageMult> getCheckDataManageResultManageMult(QString equipment_id);
    //技术文件
    static QList<Technique_File> getTechnique_File();
    //检定程序管理首页查询
    static   QList<VerificationProgramInfo> getVerificationProgramInfoMain();
    //检定程序管理 编辑
    static VerificationProgramInfo getVerificationProgramInfo(QString id);
    //查询设备通信接口
    static QList<VerificationProgramConfigInterface> getVerificationProgramConfigInterface(QString deviceId);
    //新建检定程序
    static bool InsertVerificationProgramInfo(VerificationProgramInfo verInfo);
    //查询指令库
    static QList<InstructionLib> getInstructionLib(QString device_id);
    //新增指令库
    static bool InsertInstructionLib(InstructionLib instructionLib);
    //删除指令库
    static bool DeleteInstructionLib(QString device_id);
    //更新指令库
    static bool UpdateInstructionLib(InstructionLib instructionLib);

    //新增通讯接口
    static bool InsertVerificationProgramConfigInterface(VerificationProgramConfigInterface configInterdace);
    //更新检定程序
    static bool UpdateVerificationProgramInfo(VerificationProgramInfo verInfo);
    //更新通讯接口
    static bool UpdateVerificationProgramConfigInterface(VerificationProgramConfigInterface configInterdace);
    //删除检定程序
    static bool DeleteVerificationProgramInfo(QString id);
    // 雪花id生成工具
    qint64 generateId();
    //雪花算法生成id
    IdWorker &idWorker = Singleton<IdWorker>::instance();
    //自动检定-结果保存-基本信息
    static bool InsertSaveDeviceMeasureInfo(SaveDeviceMeasureInfo saveInfo);
    //自动检定-结果保存-更新检定结果信息-多功能校准源检定装置  只更新 示值和绝对误差
    static bool UpdateVerMultiCal(SaveDeviceMeasureCalibrator measureCalibrator);
   // 核查程序管理首页查询
    static  QList<CheckProgramManage> getCheckProgramManage();
    //核查程序管理-编辑查询单个
    static CheckProgramManage getCheckProgramManageById(QString id);
};


#endif // BASECOMMONAPI_H