/** * @author coster * checks if the parent has the same reservation * as the child room * */ function hasParentSameReservation($reservierungs_id) { global $unterkunft_id; global $link; global $root; include_once $root . "/include/zimmerFunctions.php"; $zi_id = getZimmerID($reservierungs_id, $link); if (!hasRoomParentRooms($zi_id)) { return false; } $gast = getIDFromGast($reservierungs_id, $link); $datum_von = getDatumVon($reservierungs_id, $link); $datum_bis = getDatumBis($reservierungs_id, $link); $status = getState($reservierungs_id, $link); $query = "SELECT\t\t \n\t\t\t r.PK_ID\n\t\t\t FROM\n\t\t\t Rezervi_Reservierung r, Rezervi_Zimmer z\n\t\t\t WHERE\t\t\t\t\n\t\t\t FK_GAST_ID = '{$gast}' and" . " r.Datum_von = '{$datum_von}' and" . " r.Datum_bis = '{$datum_bis}' and" . " r.Status = '{$status}' and\n\t\t\t\t\tz.Parent_ID is null and \n\t\t\t\t\tr.FK_Zimmer_ID = z.PK_ID "; $res = mysqli_query($link, $query); if (!$res) { echo "die Anfrage scheitert"; echo "<br/>" . mysqli_error(); } else { $d = mysqli_fetch_array($res); $id = $d["PK_ID"]; if (!empty($id)) { return true; } } return false; }
function removeChildRooms($zimmer_ids) { $newArr = array(); //is room with child rooms in array? $parentInArray = false; foreach ($zimmer_ids as $id) { if (hasChildRooms($id)) { $parentInArray = true; } } if ($parentInArray) { foreach ($zimmer_ids as $id) { if (hasRoomParentRooms($id) && in_array($id, $zimmer_ids)) { //tu nix } else { $newArr[] = $id; } } return $newArr; } return $zimmer_ids; }