laravel 临时表查询
搜索空宿舍、空床
宿舍表id ,code, bed_number
床位表id, room_id, is_empty
$query1 = DB::table('dorm_bed')->select('room_id',DB::raw('convert(SUM(is_empty),SIGNED) as empty_number'))->groupBy('room_id');
$query = $roomModel->from('dorm_room as dr')
-&g..
原创
2021-09-03 11:06:55 ·
917 阅读 ·
0 评论