dongping4461 2019-02-02 14:01
浏览 45

从DataTable中的每个数组元素的另一个表中获取数据

I am working on a Laravel DataTable. I have an array of the field customer. I want to fetch the data from the other table using a foreach loop. How can I fetch data from another table in my for each element of the array?

$quotations = $this->quotationRepository->getAll()
    ->where([
        ['status', '!=', 'Draft Quotation']
    ])
    ->where('deleted', '=', '0')
    ->with('user', 'customer')
    ->get()
    ->map(function ($quotation) use ($dateFormat) {
        return [
            'id' => $quotation->id,
            'quotations_number' => $quotation->quotations_number,
            //'customer' => $cl,
            'customer' => unserialize($quotation->customer_id),
            'final_price' => $quotation->final_price,
            'date' => date($dateFormat, strtotime($quotation->date)),
            'exp_date' => date($dateFormat, strtotime($quotation->exp_date)),
            'payment_term' => $quotation->payment_term,
            'status' => $quotation->status
        ];
    });
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥100 set_link_state
    • ¥15 虚幻5 UE美术毛发渲染
    • ¥15 CVRP 图论 物流运输优化
    • ¥15 Tableau online 嵌入ppt失败
    • ¥100 支付宝网页转账系统不识别账号
    • ¥15 基于单片机的靶位控制系统
    • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度