我有 2 个有关系的表。我想添加 where 子句,但该 where 子句位于另一个表中。我的桌子是这样的:
pencairan
+----+------------+------------+------------+
| id | induk_id | qty | harga
+----+------------+------------+------------+
| 1 | 1 | 10 | 1000
+----+------------+------------+------------+
| 2 | 1 | 20 | 3000
+----+------------+------------+------------+
| 3 | 3 | 10 | 1500
+----+------------+------------+------------+
induk_pencairan
+----+------------+------------+------------+
| id | rek_id | name | address
+----+------------+------------+------------+
| 1 | 1 | somedata| somedata
+----+------------+------------+------------+
| 2 | 1 | somedata| somedata
+----+------------+------------+------------+
| 3 | 3 | somedata| somedata
+----+------------+------------+------------+
| 4 | 3 | somedata| somedata
+----+------------+------------+------------+
所以我想这样做:
$pencairan = IndukPencairan::with('turunan_belanja')->findOrFail($id);
if (!$pencairan)
abort(404);
$id = $pencairan->id;
$rek = $pencairan->rek_id;
$digunakan = Pencairan::with('induk_pencairan')
->where('induk_pencairan.rek_id' ,$rek)
->whereNotIn('induk_id ', [$id])->sum(DB::raw('harga*qty'));
但我收到错误
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'induk_pencairan.rek_id' in 'where clause'
(SQL: select sum(harga*qty) as aggregate from `pencairan` where `induk_pencairan`.`rek_id` = 2 and `induk_id` not in (2))
有人可以帮忙吗?
#更新我在两张桌子上的模型
关于除霜型号
public function induk_pencairan()
{
return $this->belongsTo(\App\Models\IndukPencairan::class ,'induk_id');
}
慕姐8265434
开心每一天1111