在larave admin如何把两个主键关联的数据插入到导出的数据
//导出
<?php
class FinanceExporter2 extends ExcelExporter implements WithMapping
{
protected $fileName = '订单明细.xlsx';
protected $columns = [
'JDorderCode' => '订单号',
'orderproductid' => '小票号',
'JDSKU' => '产品编码',
'ProductName' => '产品名',
'PhotoNum' => '照片数量',
'username' => '客户名',
'phone' => '手机',
'Adress' => '地址',
'HandleName' => '渠道',
'OrderTime' => '下单时间',
'Tb_ShippingOrder.ShippingNo' => '物流单号',
];
public function map($Finance) : array
{
return [
$Finance->JDorderCode,
$Finance->orderproductid,
$Finance->JDSKU,
$Finance->ProductName,
$Finance->PhotoNum,
$Finance->username,
$Finance->phone,
$Finance->Adress,
$Finance->HandleName,
$Finance->OrderTime,
data_get($Finance, 'Tb_ShippingOrder.ShippingNo'),
];
}
}
$price = PartnerPrice::where('sku', $sku)->where('handlename', $handlename)->value('price');
$totalprice = (float)PartnerPrice::where('sku', $sku)->where('handlename', $handlename)->value('price')*(int)$PhotoNum;
3. 您期望得到的结果?
如何把$price和$totalprice插入到导出的表格里面
推荐文章: