package controllers import ( "Cold_Api/Nats/NatsServer" "Cold_Api/conf" "Cold_Api/controllers/lib" "Cold_Api/models/Admin" "Cold_Api/models/Device" "Cold_Api/models/System" "fmt" beego "github.com/beego/beego/v2/server/web" "github.com/xuri/excelize/v2" "math" "strconv" "strings" "time" ) //Handle type DeviceController struct { beego.Controller } // 列表 - func (c *DeviceController) Device_html() { // 验证登录 b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"} c.ServeJSON() return } c.Data["Admin_r"] = admin_r c.Data["Admin_Power"], _ = Admin.Read_AdminPower_ById(admin_r.Admin_power) var Device_lite_r []Device.R_Device page, _ := c.GetInt("page") println(page) if page < 1 { page = 1 } page_z := 4 Class_1 := c.GetString("Class_1") Name := c.GetString("Name") T_sn := c.GetString("T_sn") c.Data["Class_1"] = Class_1 c.Data["Name"] = Name c.Data["T_sn"] = T_sn var cnt int64 Device_lite, cnt := Device.Read_Device_ALL_bind_1(admin_r, page, page_z, T_sn, Name, Class_1, "", "") for _, v := range Device_lite { r_Device := Device.R_Device{} r_Device.T_sn = v.T_sn r_Device.T_MSISDN = v.T_MSISDN r_Device.T_devName = v.T_devName r_Device.T_give = v.T_give r_Device.T_online = v.T_online r_Device.T_online_4g = v.T_online_4g r_Device.T_monitor = v.T_monitor r_Device.T_Dattery = v.T_Dattery r_Device.T_sensor_list, r_Device.T_sensor = Device.Read_DeviceSensor_ByTsn(v.T_sn) Device_lite_r = append(Device_lite_r, r_Device) } c.Data["Device_lite"] = Device_lite_r page_size := math.Ceil(float64(cnt) / float64(page_z)) c.Data["Page"] = page c.Data["Page_size"] = page_size c.Data["Pages"] = lib.Func_page(int64(page), int64(page_size)) c.Data["cnt"] = cnt c.TplName = "Device/Device.html" } func (c *DeviceController) Device_() { id, _ := c.GetInt("id") c.Data["id"] = id if id > 0 { c.Data["Date"] = Device.Read_Device_ById(id) //c.Data["FormulaList"] = Formula.ReadFormulaListByid_List(id) } c.Data["DeviceSnOld_List"] = Device.Read_DeviceSnOld_1() c.TplName = "Device/Device-.html" } func (c *DeviceController) Device_Parameter_html() { // 验证登录 b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Ctx.Redirect(302, "Login") return } c.Data["Admin_Power"], _ = Admin.Read_AdminPower_ById(admin_r.Admin_power) c.Data["Admin"] = admin_r Sn := c.GetString("Sn") DeviceParameter_lite := Device.Read_DeviceParameter_SN(Sn) if len(DeviceParameter_lite) > 0 { c.Data["DeviceParameter"] = DeviceParameter_lite[0] } else { NatsServer.Read_DeviceParameter(Sn) } c.Data["DeviceParameter_lite_z"] = len(DeviceParameter_lite) c.Data["DeviceParameter_lite_SendState_z"] = len(Device.Read_DeviceParameter_SN_T_SendState_0(Sn)) DeviceParameter_lite_s_1 := Device.Read_DeviceParameter_SN_T_State_1(Sn) c.Data["DeviceParameter_lite"] = DeviceParameter_lite_s_1 c.Data["Device"], _ = Device.Read_Device_ByT_sn(Sn) c.TplName = "Device/Device_Parameter-.html" } func (c *DeviceController) DeviceSensor_List_html() { // 验证登录 b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Ctx.Redirect(302, "Login") return } c.Data["Admin_Power"], _ = Admin.Read_AdminPower_ById(admin_r.Admin_power) Sn := c.GetString("Sn") Id, _ := c.GetInt("Id") // //c.Data["Device_lite"] = Device.Read_DeviceParameter_SN(Sn) c.Data["DeviceSensor"], _ = Device.Read_DeviceSensor_ByTsn_Tid(Sn, Id) DeviceSensorParameter_list := Device.Read_DeviceSensorParameter_SN_T_id(Sn, Id) c.Data["DeviceSensorParameter_lite"] = DeviceSensorParameter_list c.Data["DeviceSensorParameter_T_SendState_0"] = 0 if len(DeviceSensorParameter_list) > 0 { if DeviceSensorParameter_list[0].T_SendState == 0 { c.Data["DeviceSensorParameter_T_SendState_0"] = 1 } } c.Data["Device"], _ = Device.Read_Device_ByT_sn(Sn) c.TplName = "Device/Device_Sensor-.html" } func (c *DeviceController) Device_Parameter_Del_Device() { // 验证登录 b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Ctx.Redirect(302, "Login") return } Sn := c.GetString("Sn") Id, _ := c.GetInt("Id") System.Add_UserLogs_T(admin_r.Admin_uuid, "设备管理", "传感器 删除操作", "SN:"+Sn+" ["+strconv.Itoa(Id)+"]") //c.Data["Device_lite"] = Device.Read_DeviceParameter_SN(Sn) Device.Delete_DeviceSensor_ById(Sn, Id) NatsServer.Del_DeviceSensor(Device.DeviceSensor_Del{ T_sn: Sn, T_id: Id, }) c.Data["json"] = lib.JSONS{Code: 200, Msg: "OK"} c.ServeJSON() return } func (c *DeviceController) Device_Parameter_Del() { // 验证登录 b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Ctx.Redirect(302, "Login") return } Sn := c.GetString("Sn") Id, _ := c.GetInt("Id") System.Add_UserLogs_T(admin_r.Admin_uuid, "设备管理", "传感器 删除操作", "SN:"+Sn+" ["+strconv.Itoa(Id)+"]") //c.Data["Device_lite"] = Device.Read_DeviceParameter_SN(Sn) Device.Delete_DeviceSensor_ById(Sn, Id) c.Data["json"] = lib.JSONS{Code: 200, Msg: "OK"} c.ServeJSON() return } func (c *DeviceController) UpDeviceSensor_Tsort() { // 验证登录 b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Ctx.Redirect(302, "Login") return } Sn := c.GetString("Sn") Id, _ := c.GetInt("Id") T_sort, _ := c.GetInt("T_sort") DeviceSensor, is := Device.Read_DeviceSensor_ByT_sn(Sn, Id) if !is { c.Data["json"] = lib.JSONS{Code: 201, Msg: "信息错误!"} c.ServeJSON() return } DeviceSensor.T_sort = T_sort //c.Data["Device_lite"] = Device.Read_DeviceParameter_SN(Sn) Device.Update_DeviceSensor(DeviceSensor, "T_sort") System.Add_UserLogs_T(admin_r.Admin_uuid, "设备管理", "传感器 排序操作", "SN:"+Sn+" ["+strconv.Itoa(Id)+"]"+strconv.Itoa(T_sort)) c.Data["json"] = lib.JSONS{Code: 200, Msg: "OK"} c.ServeJSON() return } func (c *DeviceController) UpDeviceSensor_T_datashow() { // 验证登录 b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Ctx.Redirect(302, "Login") return } Sn := c.GetString("Sn") Id, _ := c.GetInt("Id") T_datashow, _ := c.GetInt("T_datashow") DeviceSensor, is := Device.Read_DeviceSensor_ByT_sn(Sn, Id) if !is { c.Data["json"] = lib.JSONS{Code: 201, Msg: "信息错误!"} c.ServeJSON() return } DeviceSensor.T_datashow = T_datashow Device.Update_DeviceSensor(DeviceSensor, "T_datashow") System.Add_UserLogs_T(admin_r.Admin_uuid, "设备管理", "传感器 数据展示(0 屏蔽数据展示 1 正常数据展示)", "SN:"+Sn+" ["+strconv.Itoa(Id)+"]"+strconv.Itoa(T_datashow)) c.Data["json"] = lib.JSONS{Code: 200, Msg: "OK"} c.ServeJSON() return } func (c *DeviceController) Device_Post() { /// 验证登录 b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Ctx.Redirect(302, "Login") return } var err error T_sn := c.GetString("T_sn") T_MSISDN := c.GetString("T_MSISDN") var_ := Device.Device{ T_sn: T_sn, T_MSISDN: T_MSISDN, T_Bind: "U" + strconv.Itoa(admin_r.Id) + "|", T_l_p: 0, T_give: 1, T_monitor: 1, T_State: 1, } if len(T_sn) < 8 { c.Data["json"] = lib.JSONS{Code: 303, Msg: "SN 太短 必须8个字符以上"} c.ServeJSON() return } if !(strings.Contains(T_sn, "KF") || strings.Contains(T_sn, "YD")) { c.Data["json"] = lib.JSONS{Code: 303, Msg: "必须包含 KF或YD!"} c.ServeJSON() return } _, err = Device.Read_Device_ByT_sn(T_sn) if err == nil { c.Data["json"] = lib.JSONS{Code: 303, Msg: "重复SN!"} c.ServeJSON() return } var_.T_devName = "等待设备上线.." // 创建数据库 if !Device.CREATE_DeviceData(T_sn) { c.Data["json"] = lib.JSONS{Code: 302, Msg: "添加失败!"} c.ServeJSON() return } _, err = Device.Add_Device(var_) if err != nil { c.Data["json"] = lib.JSONS{Code: 301, Msg: "添加失败!"} c.ServeJSON() return } System.Add_UserLogs_T(admin_r.Admin_uuid, "设备管理", "设备添加", var_) //MqttServer.Get_Device_Realtime(T_sn) // 更新传感器 !!! c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"} c.ServeJSON() return } func (c *DeviceController) Device_Del() { // 验证登录 b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"} c.ServeJSON() return } if admin_r.Id != 1 { c.Data["json"] = lib.JSONS{Code: 201, Msg: "没有权限!"} c.ServeJSON() return } T_sn := c.GetString("T_sn") Device_r, err := Device.Read_Device_ByT_sn(T_sn) if err != nil { c.Data["json"] = lib.JSONS{Code: 201, Msg: "T_sn Err!"} c.ServeJSON() return } Device.Delete_Device(Device_r) DeviceSensor_list, _ := Device.Read_DeviceSensor_ByTsn(Device_r.T_sn) for _, v := range DeviceSensor_list { Device.Delete_DeviceSensor_ById(Device_r.T_sn, v.T_id) } Device.DELETE_DeviceSensor(Device_r.T_sn) Device.DELETE_DeviceDatar(Device_r.T_sn) Device.DELETE_DeviceParameter(Device_r.T_sn) Device.DELETE_DeviceSensorParameter(Device_r.T_sn) System.Add_UserLogs(admin_r.Admin_uuid, "设备管理", "设备删除", T_sn) c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"} c.ServeJSON() return } // 设备弃用 func (c *DeviceController) Device_Give() { // 验证登录 b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"} c.ServeJSON() return } if admin_r.Admin_master != 1 { c.Data["json"] = lib.JSONS{Code: 201, Msg: "没有权限!"} c.ServeJSON() return } T_sn := c.GetString("T_sn") Device_r, err := Device.Read_Device_ByT_sn(T_sn) if err != nil { c.Data["json"] = lib.JSONS{Code: 201, Msg: "T_sn Err!"} c.ServeJSON() return } if Device_r.T_give == 0 { Device_r.T_give = 1 System.Add_UserLogs(admin_r.Admin_uuid, "设备管理", "设备开启", T_sn) } else { Device_r.T_give = 0 System.Add_UserLogs(admin_r.Admin_uuid, "设备管理", "设备弃用", T_sn) } Device.Update_Device(Device_r, "T_give") c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"} c.ServeJSON() return } //------------------------------- func (c *DeviceController) Device_List() { // 验证登录 b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"} c.ServeJSON() return } type R_JSONS struct { //必须的大写开头 Device_lite []Device.R_Device Num int Page int Page_size int Pages []lib.Page_T } var r_jsons R_JSONS page, _ := c.GetInt("page") println(page) if page < 1 { page = 1 } Class_1 := c.GetString("Class_1") Name := c.GetString("Name") T_sn := c.GetString("T_sn") T_online := c.GetString("T_online") // //c.Data["Class_1"] = Class_1 //c.Data["T_sn"] = T_sn //c.Data["Class_List"] = Device.Read_Class_All_1() Device_r, err := Device.Read_Device_ByT_sn(T_sn) if err != nil { c.Data["json"] = lib.JSONS{Code: 206, Msg: "T_sn Err!"} c.ServeJSON() return } if !strings.Contains(Device_r.T_Bind, "U"+strconv.Itoa(admin_r.Id)+"|") && admin_r.Admin_master != 0 { c.Data["json"] = lib.JSONS{Code: 202, Msg: "! U" + strconv.Itoa(admin_r.Id)} c.ServeJSON() return } var cnt int64 Device_lite, cnt := Device.Read_Device_ALL_bind_1(admin_r, page, 0, T_sn, Name, Class_1, "", T_online) for _, v := range Device_lite { r_Device := Device.R_Device{} r_Device.T_sn = v.T_sn r_Device.T_MSISDN = v.T_MSISDN r_Device.T_devName = v.T_devName r_Device.T_give = v.T_give r_Device.T_online = v.T_online r_Device.T_monitor = v.T_monitor r_Device.T_Dattery = v.T_Dattery r_Device.T_sensor_list, r_Device.T_sensor = Device.Read_DeviceSensor_ByTsn(v.T_sn) r_jsons.Device_lite = append(r_jsons.Device_lite, r_Device) } page_size := math.Ceil(float64(cnt) / float64(conf.Page_size)) r_jsons.Page = int(page) r_jsons.Page_size = int(page_size) r_jsons.Pages = lib.Func_page(int64(page), int64(page_size)) r_jsons.Num = int(cnt) c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!", Data: r_jsons} c.ServeJSON() return } func (c *DeviceController) DeviceSensor_List() { // 验证登录 b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"} c.ServeJSON() return } type R_JSONS struct { //必须的大写开头 DeviceSensor_lite []Device.DeviceSensor_R Num int Page int Page_size int Pages []lib.Page_T } var r_jsons R_JSONS page, _ := c.GetInt("page") println(page) if page < 1 { page = 1 } page_z, _ := c.GetInt("page_z") if page_z == 0 { page_z = conf.Page_size } T_sn := c.GetString("Sn") Device_r, err := Device.Read_Device_ByT_sn(T_sn) if err != nil { c.Data["json"] = lib.JSONS{Code: 206, Msg: "T_sn Err!"} c.ServeJSON() return } if admin_r.Admin_master > 1 { if !strings.Contains(Device_r.T_Bind, "U"+strconv.Itoa(admin_r.Id)+"|") && admin_r.Admin_master != 0 { c.Data["json"] = lib.JSONS{Code: 202, Msg: "! U" + strconv.Itoa(admin_r.Id)} c.ServeJSON() return } } //c.Data["Class_List"] = Device.Read_Class_All_1() var cnt int64 r_jsons.DeviceSensor_lite, cnt = Device.Read_DeviceSensor_ALL_T_sn(T_sn, page, page_z) page_size := math.Ceil(float64(cnt) / float64(page_z)) r_jsons.Page = int(page) r_jsons.Page_size = int(page_size) r_jsons.Pages = lib.Func_page(int64(page), int64(page_size)) r_jsons.Num = int(cnt) c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!", Data: r_jsons} c.ServeJSON() return } // ------------------------------------------ func (c *DeviceController) Read_DeviceParameter() { // 验证登录 b_, _ := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"} c.ServeJSON() return } T_SN := c.GetString("SN") //Device_r, err := Device.Read_Device_ByT_sn(T_SN) //if err != nil { // c.Data["json"] = lib.JSONS{Code: 206, Msg: "T_sn Err!"} // c.ServeJSON() // return //} ////if !strings.Contains(Device_r.T_Bind, "U"+strconv.Itoa(r_admin.Id)) { //// c.Data["json"] = lib.JSONS{Code: 202, Msg: "! U" + strconv.Itoa(r_admin.Id)} //// c.ServeJSON() //// return ////} NatsServer.Read_DeviceParameter(T_SN) c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"} c.ServeJSON() return } func (c *DeviceController) Read_DeviceSensorParameter() { // 验证登录 b_, _ := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"} c.ServeJSON() return } T_SN := c.GetString("SN") //Device_r, err := Device.Read_Device_ByT_sn(T_SN) //if err != nil { // c.Data["json"] = lib.JSONS{Code: 206, Msg: "T_sn Err!"} // c.ServeJSON() // return //} ////if !strings.Contains(Device_r.T_Bind, "U"+strconv.Itoa(r_admin.Id)) { //// c.Data["json"] = lib.JSONS{Code: 202, Msg: "! U" + strconv.Itoa(r_admin.Id)} //// c.ServeJSON() //// return ////} NatsServer.Read_DeviceSensorParameter(T_SN) c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"} c.ServeJSON() return } // func (c *DeviceController) Pu_DeviceParameter() { // 验证登录 b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"} c.ServeJSON() return } T_SN := c.GetString("SN") T_devName := c.GetString("T_devName") T_saveTime, _ := c.GetInt("T_saveTime") T_overrunSave, _ := c.GetInt("T_overrunSave") T_overrunAlarm, _ := c.GetInt("T_overrunAlarm") T_outageAlarm, _ := c.GetInt("T_outageAlarm") T_warningDelay, _ := c.GetInt("T_warningDelay") T_lostAlarm, _ := c.GetInt("T_lostAlarm") T_batteryLimit, _ := c.GetInt("T_batteryLimit") T_warningTime, _ := c.GetInt("T_warningTime") T_tempPre, _ := c.GetFloat("T_tempPre") T_humPre, _ := c.GetFloat("T_humPre") T_enwarning, _ := c.GetInt("T_enwarning") T_decTotal, _ := c.GetInt("T_decTotal") T_chDecTotal := c.GetString("T_chDecTotal") T_company := c.GetString("T_company") T_btname := c.GetString("T_btname") T_btserverID, _ := c.GetInt("T_btserverID") T_btchar, _ := c.GetInt("T_btchar") Device_r, err := Device.Read_Device_ByT_sn(T_SN) if err != nil { c.Data["json"] = lib.JSONS{Code: 206, Msg: "T_sn Err!"} c.ServeJSON() return } Admin_Power_, _ := Admin.Read_AdminPower_ById(admin_r.Admin_power) if Admin_Power_.Power_DeviceSensor_Compensate_e == 0 { c.Data["json"] = lib.JSONS{Code: 202, Msg: "! U" + strconv.Itoa(admin_r.Id)} c.ServeJSON() return } Deviceparameter := Device.DeviceParameter{ T_uuid: admin_r.Admin_uuid, T_SendState: 0, T_State: 2, T_sn: T_SN, T_devName: T_devName, T_saveTime: T_saveTime, T_overrunSave: T_overrunSave, T_overrunAlarm: T_overrunAlarm, T_outageAlarm: T_outageAlarm, T_lostAlarm: T_lostAlarm, T_warningTime: T_warningTime, T_warningDelay: T_warningDelay, T_batteryLimit: T_batteryLimit, T_tempPre: float32(T_tempPre), T_humPre: float32(T_humPre), T_chDecTotal: T_chDecTotal, T_decTotal: strconv.Itoa(T_decTotal), T_enwarning: T_enwarning, T_company: T_company, T_btname: T_btname, T_btserverID: strconv.Itoa(T_btserverID), T_btchar: strconv.Itoa(T_btchar), } Deviceparameter, is := Device.Add_DeviceParameter(Deviceparameter) if !is { c.Data["json"] = lib.JSONS{Code: 203, Msg: "Add_DeviceParameter ERR"} c.ServeJSON() return } System.Add_UserLogs_T(admin_r.Admin_uuid, "设备管理", "设备参数操作", Deviceparameter) NatsServer.Pu_DeviceParameter(Deviceparameter) Device_r.T_devName = Deviceparameter.T_devName Device.Update_Device(Device_r, "T_devName") c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"} c.ServeJSON() return } // func (c *DeviceController) Pu_DeviceParameter_T_l_p() { // 验证登录 b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"} c.ServeJSON() return } T_SN := c.GetString("SN") T_l_p, _ := c.GetInt("T_l_p") Device_r, err := Device.Read_Device_ByT_sn(T_SN) if err != nil { c.Data["json"] = lib.JSONS{Code: 206, Msg: "T_sn Err!"} c.ServeJSON() return } // // 1物流端 2药店端 Device_r.T_l_p = T_l_p Device.Update_Device(Device_r, "T_l_p") Device.DeviceSensor_T_l_p_ALL(T_SN, T_l_p) System.Add_UserLogs(admin_r.Admin_uuid, "设备管理", "设备参数操作", "类型选择(1物流端 2药店端):"+string(T_l_p)) c.Data["json"] = lib.JSONS{Code: 222, Msg: "ok!"} c.ServeJSON() return } // func (c *DeviceController) Pu_DeviceParameter_T_give() { // 验证登录 b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"} c.ServeJSON() return } T_SN := c.GetString("SN") T_give, _ := c.GetInt("T_give") Device_r, err := Device.Read_Device_ByT_sn(T_SN) if err != nil { c.Data["json"] = lib.JSONS{Code: 206, Msg: "T_sn Err!"} c.ServeJSON() return } // // 1物流端 2药店端 Device_r.T_give = T_give Device.Update_Device(Device_r, "T_give") Device.DeviceSensor_t_give_ALL(T_SN, T_give) System.Add_UserLogs(admin_r.Admin_uuid, "设备管理", "设备丢弃参数操作", "设备丢弃( 0 丢弃 1 正常):"+string(T_give)) c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"} c.ServeJSON() return } // //func (c *DeviceController) Pu_DeviceParameter_Sensor_() { // // 验证登录 // b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) // if !b_ { // c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"} // c.ServeJSON() // return // } // // T_SN := c.GetString("SN") // _, err := Device.Read_Device_ByT_sn(T_SN) // if err != nil { // c.Data["json"] = lib.JSONS{Code: 206, Msg: "T_sn Err!"} // c.ServeJSON() // return // } // Admin_Power_, _ := Admin.Read_AdminPower_ById(admin_r.Admin_power) // if Admin_Power_.Power_DeviceSensor_Compensate_e == 0 { // c.Data["json"] = lib.JSONS{Code: 202, Msg: "! U" + strconv.Itoa(admin_r.Id)} // c.ServeJSON() // return // } // // T_sensor_list := c.GetString("T_sensor_list") // jsonStu_map_ := strings.Replace(string(T_sensor_list), "\"{", "{", -1) // jsonStu_map_ = strings.Replace(jsonStu_map_, "}\"", "}", -1) // jsonStu_map_ = strings.Replace(jsonStu_map_, "\\\"", "\"", -1) // println("jsonStu_map_:", jsonStu_map_) // var Rt_parameter_sensor_ []MqttServer.Rt_Parameter_Sensor_ // err = json.Unmarshal([]byte(jsonStu_map_), &Rt_parameter_sensor_) // if err != nil { // c.Data["json"] = lib.JSONS{Code: 204, Msg: "T_sensor_list Err!"} // c.ServeJSON() // return // } // // Handle.Pu_DeviceParameter_Sensor(admin_r.Admin_uuid, T_SN, Rt_parameter_sensor_) // System.Add_UserLogs(admin_r.Admin_uuid,"设备管理", "传感器参数操作", jsonStu_map_) // // DeviceSensor,is := Device.Read_DeviceSensor_ByT_sn(T_SN, Rt_parameter_sensor_[0].T_id) // if is { // DeviceSensor.T_name = Rt_parameter_sensor_[0].T_name // Device.Update_TDeviceSensor(DeviceSensor,"T_name") // } // // // c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"} // c.ServeJSON() // return // //} // func (c *DeviceController) Pu_DeviceParameter_Sensor() { // 验证登录 b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"} c.ServeJSON() return } T_SN := c.GetString("T_SN") T_name := c.GetString("T_name") T_id, _ := c.GetInt("T_id") T_Tlower, _ := c.GetFloat("T_Tlower") T_Tupper, _ := c.GetFloat("T_Tupper") T_RHlower, _ := c.GetFloat("T_RHlower") T_RHupper, _ := c.GetFloat("T_RHupper") T_en, _ := c.GetInt("T_en") T_free, _ := c.GetInt("T_free") // 权限 过滤 Admin_Power_, _ := Admin.Read_AdminPower_ById(admin_r.Admin_power) if Admin_Power_.Power_DeviceSensor_Compensate_e == 0 { c.Data["json"] = lib.JSONS{Code: 202, Msg: "! U" + strconv.Itoa(admin_r.Id)} c.ServeJSON() return } _, err := Device.Read_Device_ByT_sn(T_SN) if err != nil { c.Data["json"] = lib.JSONS{Code: 206, Msg: "T_sn Err!"} c.ServeJSON() return } DeviceSensor, is := Device.Read_DeviceSensor_ByT_sn(T_SN, T_id) if !is { c.Data["json"] = lib.JSONS{Code: 208, Msg: "T_sn T_id Err!"} c.ServeJSON() return } Devicesensorparameter := Device.DeviceSensorParameter{ T_sn: T_SN, T_id: T_id, T_name: T_name, T_Tlower: float32(T_Tlower), T_Tupper: float32(T_Tupper), T_RHlower: float32(T_RHlower), T_RHupper: float32(T_RHupper), T_en: T_en, T_free: T_free, T_uuid: admin_r.Admin_uuid, T_SendState: 0, T_State: 2, } dsp_id, is := Device.Add_DeviceSensorParameter(Devicesensorparameter) if !is { c.Data["json"] = lib.JSONS{Code: 209, Msg: "添加失败!"} c.ServeJSON() return } Devicesensorparameter.Id = int(dsp_id) // 更新名称 DeviceSensor.T_name = T_name Device.Update_DeviceSensor(DeviceSensor, "T_name") System.Add_UserLogs_T(admin_r.Admin_uuid, "设备管理", "传感器参数操作", Devicesensorparameter) NatsServer.Pu_DeviceParameter_Sensor(Devicesensorparameter) c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"} c.ServeJSON() return } //// //func (c *DeviceController) Pu_DeviceParameter_Sensor_Cache() { // // 验证登录 // b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) // if !b_ { // c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"} // c.ServeJSON() // return // } // // T_SN := c.GetString("SN") // T_id := c.GetString("T_id") // _, err := Device.Read_Device_ByT_sn(T_SN) // if err != nil { // c.Data["json"] = lib.JSONS{Code: 206, Msg: "T_sn Err!"} // c.ServeJSON() // return // } // Admin_Power_, _ := Admin.Read_AdminPower_ById(admin_r.Admin_power) // if Admin_Power_.Power_DeviceSensor_Compensate_e == 0 { // c.Data["json"] = lib.JSONS{Code: 202, Msg: "! U" + strconv.Itoa(admin_r.Id)} // c.ServeJSON() // return // } // // T_sensor_list := c.GetString("T_sensor_list") // jsonStu_map_ := strings.Replace(string(T_sensor_list), "\"{", "{", -1) // jsonStu_map_ = strings.Replace(jsonStu_map_, "}\"", "}", -1) // jsonStu_map_ = strings.Replace(jsonStu_map_, "\\\"", "\"", -1) // println("jsonStu_map_:", jsonStu_map_) // var Rt_parameter_sensor_ []MqttServer.Rt_Parameter_Sensor_ // err = json.Unmarshal([]byte(jsonStu_map_), &Rt_parameter_sensor_) // if err != nil { // c.Data["json"] = lib.JSONS{Code: 204, Msg: "T_sensor_list Err!"} // c.ServeJSON() // return // } // DeviceSensor,is := Device.Read_DeviceSensor_ByT_sn(T_SN, Rt_parameter_sensor_[0].T_id) // if is { // DeviceSensor.T_name = Rt_parameter_sensor_[0].T_name // Device.Update_TDeviceSensor(DeviceSensor,"T_name") // } // // Device.Redis_DeviceSensorParameterCache_Set(T_SN+"_"+T_id,jsonStu_map_) // //Handle.Pu_DeviceParameter_Sensor(admin_r.Admin_uuid, T_SN, Rt_parameter_sensor_) // System.Add_UserLogs(admin_r.Admin_uuid,"设备管理", "传感器参数操作-离线操作", jsonStu_map_) // c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!"} // c.ServeJSON() // return // //} // 列表 - func (c *DeviceController) DeviceWarning_List_html() { // 验证登录 b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"} c.ServeJSON() return } c.Data["Admin_r"] = admin_r page, _ := c.GetInt("page") println(page) if page < 1 { page = 1 } c.Data["Admin_r"] = admin_r T_Name := c.GetString("T_Name") //T_sn := c.GetString("T_sn") Time_start := c.GetString("Time_start") Time_end := c.GetString("Time_end") if len(Time_start) == 0 && len(Time_end) == 0 { Time_start = time.Now().Format("2006-01-02") + " 00:00:00" Time_end = time.Now().Format("2006-01-02") + " 23:59:59" } c.Data["Time_start"] = Time_start c.Data["Time_end"] = Time_end c.Data["T_Name"] = T_Name //c.Data["Class_List"] = Device.Read_DeviceWarningList_All_1() //T_Title := "" //if Class_1 > 0 { // T_Title = Device.Read_DeviceWarningList_ById(Class_1).T_name //} var cnt int64 DeviceWarning_List, cnt := Device.Read_DeviceWarning_1(admin_r, page, "", T_Name, Time_start, Time_end) //for i, v := range DeviceWarning_List { // DeviceWarning_List[i].T_State = 0 // if strings.Contains(v.T_sn, "YD") { // DeviceWarning_List[i].T_State = 1 // } //} c.Data["List"] = DeviceWarning_List page_size := math.Ceil(float64(cnt) / float64(conf.Page_size)) c.Data["Page"] = page c.Data["Page_size"] = page_size c.Data["Pages"] = lib.Func_page(int64(page), int64(page_size)) c.Data["cnt"] = cnt c.TplName = "Device/DeviceWarning.html" } // 列表 - func (c *DeviceController) DeviceWarning_List() { // 验证登录 b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"} c.ServeJSON() return } type R_JSONS struct { //必须的大写开头 DeviceWarning []Device.DeviceWarning //DeviceWarningclass []Device.DeviceWarningList Num int Page int Page_size int Pages []lib.Page_T } var r_jsons R_JSONS page, _ := c.GetInt("page") println(page) if page < 1 { page = 1 } T_sn := c.GetString("T_sn") //T_sn := c.GetString("Sn") //Class_1, _ := c.GetInt("Class_1") T_Name := c.GetString("T_Name") Time_start := c.GetString("Time_start") Time_end := c.GetString("Time_end") //r_jsons.DeviceWarningclass = Device.Read_DeviceWarningList_All_1() //T_Title := "" //if Class_1 > 0 { // T_Title = Device.Read_DeviceWarningList_ById(Class_1).T_name //} var cnt int64 r_jsons.DeviceWarning, cnt = Device.Read_DeviceWarning_1(admin_r, page, T_sn, T_Name, Time_start, Time_end) page_size := math.Ceil(float64(cnt) / float64(conf.Page_size)) r_jsons.Page = int(page) r_jsons.Page_size = int(page_size) r_jsons.Pages = lib.Func_page(int64(page), int64(page_size)) r_jsons.Num = int(cnt) c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!", Data: r_jsons} c.ServeJSON() return } // 列表 - func (c *DeviceController) DeviceWarning_Data_Excel() { // 验证登录 b_, admin_r := lib.Verification(c.Ctx.GetCookie("User_tokey"), c.GetString("User_tokey")) if !b_ { c.Data["json"] = lib.JSONS{Code: 201, Msg: "User_tokey Err!"} c.ServeJSON() return } //T_sn := c.GetString("T_sn") Class_1, _ := c.GetInt("Class_1") T_Name := c.GetString("T_Name") Time_start := c.GetString("Time_start") Time_end := c.GetString("Time_end") c.Data["Class_1"] = Class_1 if len(Time_start) == 0 && len(Time_end) == 0 { Time_start = time.Now().Format("2006-01-02") + " 00:00:00" Time_end = time.Now().Format("2006-01-02") + " 23:59:59" } // //T_Title := "" //if Class_1 > 0 { // T_Title = Device.Read_DeviceWarningList_ById(Class_1).T_name //} Device_data, _ := Device.Read_DeviceWarning_1(admin_r, 9999, "", T_Name, Time_start, Time_end) f := excelize.NewFile() // 设置单元格的值 // 这里设置表头 f.SetCellValue("Sheet1", "A1", "报警类型") f.SetCellValue("Sheet1", "B1", "Sn") f.SetCellValue("Sheet1", "C1", "设备名称") f.SetCellValue("Sheet1", "D1", "传感器") f.SetCellValue("Sheet1", "E1", "温度℃") f.SetCellValue("Sheet1", "F1", "湿度%") f.SetCellValue("Sheet1", "G1", "报警内容") f.SetCellValue("Sheet1", "H1", "记录时间") f.SetCellValue("Sheet1", "I1", "处理") f.SetCellValue("Sheet1", "J1", "处理时间") // 设置列宽 f.SetColWidth("Sheet1", "A", "A", 20) f.SetColWidth("Sheet1", "B", "B", 25) f.SetColWidth("Sheet1", "C", "C", 30) f.SetColWidth("Sheet1", "D", "D", 30) f.SetColWidth("Sheet1", "E", "E", 10) f.SetColWidth("Sheet1", "F", "F", 10) f.SetColWidth("Sheet1", "G", "G", 30) f.SetColWidth("Sheet1", "H", "H", 15) f.SetColWidth("Sheet1", "I", "I", 30) f.SetColWidth("Sheet1", "J", "J", 15) line := 1 // 循环写入数据 for _, v := range Device_data { line++ f.SetCellValue("Sheet1", fmt.Sprintf("A%d", line), v.T_Title) f.SetCellValue("Sheet1", fmt.Sprintf("B%d", line), v.T_sn+"["+strconv.Itoa(v.T_Id)+"]") f.SetCellValue("Sheet1", fmt.Sprintf("C%d", line), v.T_Addr) f.SetCellValue("Sheet1", fmt.Sprintf("D%d", line), v.T_Name) f.SetCellValue("Sheet1", fmt.Sprintf("E%d", line), v.T_T) f.SetCellValue("Sheet1", fmt.Sprintf("F%d", line), v.T_RH) f.SetCellValue("Sheet1", fmt.Sprintf("G%d", line), v.T_Remark) f.SetCellValue("Sheet1", fmt.Sprintf("H%d", line), v.T_Ut) f.SetCellValue("Sheet1", fmt.Sprintf("I%d", line), v.T_Text) f.SetCellValue("Sheet1", fmt.Sprintf("J%d", line), v.UpdateTime) } timeStr := time.Now().Format("20060102150405") // 保存文件 if err := f.SaveAs("ofile/" + timeStr + ".xlsx"); err != nil { fmt.Println(err) } url, is := NatsServer.Qiniu_UploadFile(lib.GetCurrentDirectory()+"ofile/"+timeStr+".xlsx", "ofile/"+timeStr+".xlsx") if !is { c.Data["json"] = lib.JSONS{Code: 203, Msg: "oss!"} c.ServeJSON() return } //删除目录 //err := os.Remove("ofile/" + timeStr + ".xlsx") //if err != nil { // fmt.Println(err) //} c.Data["json"] = lib.JSONS{Code: 200, Msg: "ok!", Data: url} c.ServeJSON() return } func (c *DeviceController) DeviceWarning_() { id, _ := c.GetInt("id") c.Data["T"] = Device.Read_DeviceWarning_ById(id) c.Data["id"] = id c.TplName = "Device/DeviceWarning-.html" } func (c *DeviceController) DeviceWarning_log() { id, _ := c.GetInt("id") T_Log := Device.Read_DeviceWarning_ById(id).T_Log T_Log = strings.Replace(T_Log, "\n", "