Laravel Json列的关系定义。
型号:税款
<table>
<tr>
<th>id</th>
<th>name</th>
</tr>
<tr>
<td>1</td>
<td>CGST</td>
</tr>
<tr>
<td>2</td>
<td>SGST</td>
</tr>
<tr>
<td>3</td>
<td>IGST</td>
</tr>
<tr>
<td>4</td>
<td>UGST</td>
</tr>
</table>
型号:TaxGroup
<table>
<tr>
<th>id</th>
<th>group_name</th>
<th>tax_values</th>
</tr>
<tr>
<td>1</td>
<td>Standard</td>
<td>[{"tax_id":1,"tax_rate":0},{"tax_id":2,"tax_rate":0}] </td>
</tr>
<tr>
<td>1</td>
<td>Custom</td>
<td>[{"tax_id":1,"tax_rate":0}] </td>
</tr>
</table>
已尝试
在TaxGroup模型中定义此关系
public function tax() {
return $this->hasMany(Tax::class,'tax_values->tax_id','_id');
}
因此,期望值是与TaxGroup一起获取Tax记录
为此需要Json Relationships。
预期结果
TaxGroupCollection : {
0 : {
id : 1,group_name: Standard,tax_values : [
{"tax_id":1,"tax_rate":0,"tax":{here tax collection}},"tax":{here tax collection}}
]
}
}