主页 / user-466863

young_protokaa42's questions

Martin Hope
young_protokaa42
Asked: 2022-12-30 00:01:52 +0800 CST
  • 5

Laravel 9. 无法在日期类型字段上设置表连接条件。我的代码：

$result['rooms'] = Room::select('rooms.real_num')
    ->leftJoin('bookings', function ($join) {
        $join->on('rooms.id', '=', 'bookings.room_id')
            ->where('bookings.date_start', '>=', strtotime($data['start']));
    })
    ->get();

我没有找到任何新的解决方案，官方文档没有具体描述带有日期的列的情况

php
Martin Hope
young_protokaa42
Asked: 2022-12-05 18:50:56 +0800 CST
  • 4

帮助建立一个请求。
以下是表格：

属性

代码 用户代码 属性代码 属性值
一 24 八 一
2个 24 四 一
3个 24 3个 一
四 24 2个 一

用户

代码 姓名
24 博洛佳

这个请求

select * from Users join Attr on Users.code = Attr.user_code 
where Users.code = 24 and Attr.attr_code = 8;

仅当 attr 表具有 attr_code = 8 和 user_code = 24 的条目时才会提供所需的字符串。无论如何，我需要显示 Users 表中的字段，并且仅当存在 attr_code = 8 的条目时才需要显示 Attr 中的字段（如果没有 - 代替这些字段的将只是空洞）。

mysql
Martin Hope
young_protokaa42
Asked: 2022-07-29 15:20:27 +0800 CST
  • 0

Android Studio中的模拟器不会以任何方式启动。处理器amd athlon silver 3050u 与 radeon 图形。
日志：

2022-07-29 12:00:53,239 [5636174]   INFO -       Emulator: Pixel 5 API 31 - C:\Sdk\emulator\emulator.exe -netdelay none -netspeed full -avd Pixel_5_API_31 -qt-hide-window -grpc-use-token -idle-grpc-timeout 300 
2022-07-29 12:00:53,479 [5636414]   INFO -       Emulator: Pixel 5 API 31 - PANIC: Broken AVD system path. Check your ANDROID_SDK_ROOT value [C:\Android\sdk]! 
2022-07-29 12:00:53,480 [5636415]   INFO -       Emulator: Pixel 5 API 31 - Android emulator version 31.2.10.0 (build_id 8420304) (CL:N/A) 
2022-07-29 12:00:53,482 [5636417]   INFO -       Emulator: Pixel 5 API 31 - Process finished with exit code 1

文件位置：
C:\Android C:\Sdk Windows

环境变量：

ANDROID_AVD_HOME    C:\Users\Андрей\.android\avd
ANDROID_HOME        C:\Sdk
ANDROID_SDK_ROOT    C:\Sdk

已安装的 SDK：

Android SDK Build-Tools 33
Android Emulator
Android Emulator Hypervizor Driver for AMD Processors (installer)
Android SDK Platform-Tools
Android SDK Tools
Google Play services

我尝试重新安装android模拟器。有足够的可用磁盘空间。SDK 管理器中的 Android SDK 位置设置正确。处理器虚拟化已启用。管理程序驱动程序已安装并正在运行。
UPDATE
稍微更改了文件的位置并更改了环境变量： 窗口环境变量

新日志：

2022-08-01 17:04:53,519 [ 416150]   INFO -       Emulator: Pixel 5 API 29 - C:\Soft\SDK_Android\emulator\emulator.exe -netdelay none -netspeed full -avd Pixel_5_API_29 -qt-hide-window -grpc-use-token -idle-grpc-timeout 300 
2022-08-01 17:04:53,816 [ 416447]   INFO -       Emulator: Pixel 5 API 29 - PANIC: Avd's CPU Architecture 'arm64' is not supported by the QEMU2 emulator on x86_64 host. 
2022-08-01 17:04:53,816 [ 416447]   INFO -       Emulator: Pixel 5 API 29 - Android emulator version 31.2.10.0 (build_id 8420304) (CL:N/A) 
2022-08-01 17:04:53,819 [ 416450]   INFO -       Emulator: Pixel 5 API 29 - Process finished with exit code 1 
2022-08-01 17:04:53,821 [ 416452]  ERROR -       Emulator: Pixel 5 API 29 - Emulator terminated with exit code 1 
java.lang.Throwable: Emulator terminated with exit code 1
2022-08-01 17:04:53,822 [ 416453]  ERROR -       Emulator: Pixel 5 API 29 - Android Studio Chipmunk | 2021.2.1 Patch 1  Build #AI-212.5712.43.2112.8609683 
2022-08-01 17:04:53,822 [ 416453]  ERROR -       Emulator: Pixel 5 API 29 - JDK: 11.0.12; VM: OpenJDK 64-Bit Server VM; Vendor: Oracle Corporation 
2022-08-01 17:04:53,822 [ 416453]  ERROR -       Emulator: Pixel 5 API 29 - OS: Windows 10 
2022-08-01 17:04:53,822 [ 416453]  ERROR -       Emulator: Pixel 5 API 29 - Last Action:  
2022-08-01 17:04:57,634 [ 420265]   INFO - rationStore.ComponentStoreImpl - Saving Project(name=My Application, containerState=COMPONENT_CREATED, componentStore=C:\projectAndr)RunManager took 46 ms, ToolWindowManager took 18 ms, XDebuggerManager took 24 ms
android android-studio
Martin Hope
young_protokaa42
Asked: 2022-06-11 20:03:33 +0800 CST
  • 0

该程序犁了几分钟，中断并给出错误。错误代码：

panic: runtime error: invalid memory address or nil pointer dereference
[signal SIGSEGV: segmentation violation code=0x1 addr=0x50 pc=0x5d8063]

goroutine 35 [running]:
main.getStatistics({0xc000190040, 0x9})
        C:/Program Files/xampp/server/server.go:71 +0xc3
created by main.main
        C:/Program Files/xampp/server/server.go:62 +0x3b9

程序逻辑： 1）我们从mysql中获取所有设备的ip地址 2）在无限循环中，我们为每个ip调用一个函数并在goroutine中运行它 3）在函数中，我们向所有设备发送一组字节通过tcp并听答案 4）我们从接收到的数据中收集答案并写入redis

func main() {
    db, err := sql.Open("mysql", "test:@/test")
    if err != nil {
        panic(err)
    }

    rows, err := db.Query("select * from inclunometers")
    if err != nil {
        panic(err)
    }

    inclunometers := []inclunometer{}
    for rows.Next() {
        p := inclunometer{}
        err := rows.Scan(&p.id, &p.Type, &p.accuracy, &p.ip, &p.rs485_address, &p.side_id)
        if err != nil {
            fmt.Println(err)
            continue
        }
        inclunometers = append(inclunometers, p)
    }

    defer rows.Close()
    defer db.Close()

    for _, element := range inclunometers {
        for {
            go getStatistics(element.ip)
            time.Sleep(500 * time.Millisecond)
        }
    }
}

以前，我每 8 秒调用一次该函数，并且一切都稳定运行了至少几天，但需要每秒调用两次。

func getStatistics(ip string) {
    conn, _ := net.Dial("tcp", string(ip+":50"))

    _, err := conn.Write([]byte{0x01, 0x03, 0x00, 0x00, 0x00, 0x02, 0xC4, 0x0B})
    if err != nil {
        panic(err)
    }

    windSpeedStatistics := make([]byte, 10)
    message, _ := bufio.NewReader(conn).Read(windSpeedStatistics)
    if message == 0 {
        panic("can`t get wind stats")
    }
    windSpeed := (float64(binary.BigEndian.Uint16(windSpeedStatistics[3:5]) / 100))

    _, err = conn.Write([]byte{0x01, 0x03, 0x00, 0x01, 0x00, 0x02, 0x95, 0xCB})
    if err != nil {
        panic(err)
    }

    windDirection := make([]byte, 10)
    message, _ = bufio.NewReader(conn).Read(windDirection)
    if message == 0 {
        panic("can`t get wind stats")
    }
    direction := (float64(binary.BigEndian.Uint16(windDirection[3:5])) / 100)

    prepareJson := jsonStatistics{Date.Format("2006-01-02 15:04:05"), ip, direction, windSpeed}
    jsonDecode, err := json.Marshal(prepareJson)
    if err != nil {
        panic(err)
    }

    /*REDIS*/
    redisKey := "ip:" + ip
    currUnix := time.Now().Unix()
    redisConn, err := redis.Dial("tcp", "localhost:6379")
    if err != nil {
        panic(err)
    }

    v, err := redisConn.Do("ZADD", redisKey, int(currUnix), jsonDecode)
    if v == 0 || err != nil {
        panic(err)
    }
    /*REDIS*/

    defer conn.Close()
    defer redisConn.Close()
    return windSpeed, direction
}
sql