EasyGBS录像计划查询通道列表添加通道及设备名称搜索功能

dbclient = dbclient.Table(channelTableName).Select(fmt.Sprintf(`%s.id,%s.device_id,
       %s.name,%s.name as device_name,record_plan_switch`, channelTableName, channelTableName, channelTableName, deviceTableName))
if q != "" {
       wherestr := fmt.Sprintf(`%s.device_id like ? or %s.id like ? or %s.name like ? `, channelTableName, channelTableName, deviceTableName)
       dbclient = dbclient.Where(wherestr, "%"+q+"%", "%"+q+"%", "%"+q+"%")
}

if pagesize != 0 {
       orderstr := fmt.Sprintf(`%s.update_time desc`, channelTableName)
       dbclient.Joins(fmt.Sprintf(`left join %s ON %s.id = %s.device_id`, deviceTableName, deviceTableName, channelTableName)).Limit(pagesize).Offset(pagesize * pageindex).Scan(&dataList).Order(orderstr)
}