}
// add new breed
$new_breed = new Breed();
$new_breed->name = $_POST["new_breed"];
$new_breed->pet_type_wk = $type->pet_type_wk;
if ($new_breed->save()) {
$session->message($session->message . "Breed " . $new_breed->name . " was successfully added!<br />");
} else {
$session->message($session->message . "Breed " . $new_breed->name . " cannot be added at this time.<br />");
}
}
redirect_head(ROOT_URL . "admin/manage_breeds.php");
}
/* If Pet_Type is being added */
if (isset($_POST["add_pet_type"])) {
$new_pet_type = new Pet_Type();
$new_pet_type->name = $_POST["name"];
if ($new_pet_type->save()) {
// get the new pet type's wk
$new_wk = $database->insert_id();
$session->message($session->message . "The new pet type {$new_pet_type->name} was successfully created!<br />");
// create an undefined breed for the new pet type
$undefined_breed = new Breed();
$undefined_breed->name = "undefined";
$undefined_breed->pet_type_wk = $new_wk;
if ($undefined_breed->save()) {
$session->message($session->message . "New undefined breed created for new pet type.<br />");
} else {
//die($database->last_error);
$session->message($session->message . "Creation of undefined breed for new pet type was unsuccessful.<br />");
}
<div class="container"><div class="row"><div class="col-xs-3">
<!-- form to limit search criteria -->
<form action="<?php
echo file_name_without_get();
?>
" method="post">
<fieldset>
<legend>Filter</legend>
Pet Type <br /><?php
//we need to display all available items
//do a concatenation of the pet type and the breed
$sql = "SELECT DISTINCT `pt`.* FROM `breed` AS `b` ";
$sql .= "INNER JOIN `pet_type` AS `pt` ON `pt`.`pet_type_wk` = `b`.`pet_type_wk` ";
$sql .= "INNER JOIN `pet` AS `p` ON `p`.`breed_wk` = `b`.`breed_wk` AND `p`.`is_deleted` = 0 ";
$sql .= "ORDER BY `pt`.`name` ASC;";
$to_display = Pet_Type::find_by_sql($sql);
//loop through all items
foreach ($to_display as $value) {
echo "<input style=\"margin-left: 1.5em;\" type=\"checkbox\" name=\"pet_type[]\" value=\"" . $value->pet_type_wk . "\"";
//this will determine whether or not this item is checked
if (isset($session->pet_where)) {
if (isset($session->pet_where['pet_type'])) {
if (in_array($value->pet_type_wk, $session->pet_where['pet_type'])) {
echo ' checked';
}
}
}
echo "> " . $value->name . "<br />";
}
echo '</select>';
?>
