Блог

Это мой запрос на поиск itemset1 , как найти itemset2 ?

 public function ajaxList()
    {
        $penjualan = Penjualan::select(DB::raw('TIDList as TIDList, material as material'))->groupBy('material')->get();
        $data = array();
        foreach($penjualan as $row)
        {
            $tidlist = DB::table('penjualans')
                        ->select(DB::raw('TIDList as TIDList'), 'material')
                        ->where('material', $row->material)
                        ->get();
            $data2 = array();
            foreach($tidlist as $line)
            {
                $data2[] = $line->TIDList;
            }

            $data[] = [
                'material' => $row->material,
                'TIDList' => implode(', ', $data2)
            ];
        }
        $datatables = DataTables::of($data);
        return $datatables->addIndexColumn()
            ->make(true);
    }
}