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 ·
846 阅读 ·
0 评论