public function updateAccessories($accessories, $materialId) { Accessorie::where('fk_mastermaterial', '=', $materialId)->orwhere('fk_slavematerial', '=', $materialId)->delete(); $insertValues = array(); foreach ($accessories as $accessorie) { $insertValues[] = array('fk_mastermaterial' => $materialId, 'fk_slavematerial' => $accessorie); $insertValues[] = array('fk_mastermaterial' => $accessorie, 'fk_slavematerial' => $materialId); } Accessorie::insert($insertValues); }
public function deleteMaterial($id) { DB::table('materialcategories')->where('fk_materialsid', '=', $id)->delete(); Accessorie::where('fk_mastermaterial', '=', $id)->orwhere('fk_slavematerial', '=', $id)->delete(); Material::where('id', '=', $id)->delete(); }