}
//set the new sort mechanism
$session->set_variable('pet_order_by', $new_sort);
//redirect back
redirect_head(file_name_without_get());
}
//grab the set of pets to display
$sql = "SELECT `p`.* FROM `pet` AS `p` ";
$sql .= "INNER JOIN `pet_wish_list` AS `w` ON `w`.`pet_wk` = `p`.`pet_wk` ";
$sql .= "INNER JOIN `breed` AS `b` ON `b`.`breed_wk` = `p`.`breed_wk` ";
$sql .= "INNER JOIN `pet_type` AS `pt` ON `pt`.`pet_type_wk` = `b`.`pet_type_wk` ";
$sql .= "INNER JOIN `status` AS `s` ON `s`.`status_wk` = `p`.`status_wk` ";
$sql .= "INNER JOIN `color` AS `c` ON `c`.`color_wk` = `p`.`color_wk` ";
$sql .= "WHERE `p`.`is_deleted` = 0 ";
$sql .= "AND `w`.`user_wk` = " . $session->user_wk . " ";
$sql .= generate_pet_order_by() . " ";
$sql .= ";";
// display the pet blocks
$page->body = display_pet_blog($sql, true);
// include the header
require_once "../requires/template/header.php";
// temporary messages section
echo "<p id=\"ajax_message\" style=\"color: red; font-family: courier;\"></p>";
// display the page
echo "<section class=\"container\"><div class=\"row\"><div class=\"col-xs-9\">";
echo $page->body;
echo "</div></div></section>";
// remove the message
$session->unset_variable('message');
//footer template
require_once "../requires/template/footer.php";
$session->set_variable('pet_order_by', $new_sort);
//redirect back
redirect_head(file_name_without_get());
}
//grab the set of pets to display
$sql = "SELECT `p`.* FROM `pet` AS `p` ";
$sql .= "INNER JOIN `breed` AS `b` ON `b`.`breed_wk` = `p`.`breed_wk` ";
$sql .= "INNER JOIN `pet_type` AS `pt` ON `pt`.`pet_type_wk` = `b`.`pet_type_wk` ";
$sql .= "INNER JOIN `status` AS `s` ON `s`.`status_wk` = `p`.`status_wk` ";
$sql .= "INNER JOIN `color` AS `c` ON `c`.`color_wk` = `p`.`color_wk` ";
$sql .= "WHERE `p`.`is_deleted` = 0 ";
$sql .= generate_pet_where() . " ";
$sql .= generate_pet_order_by() . " ";
$sql .= ";";
//grab the body of pets
$page->body = display_pet_blog($sql);
//page body object
//$pageObj = find_by_sql($sql);
//include the header
require_once "../requires/template/header.php";
// temporary messages section
echo "<p id=\"ajax_message\" style=\"color: red; font-family: courier;\"></p>";
?>
<script type="text/javascript" src="http://www.google.com/jsapi"></script>
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js" charset="utf-8"></script>
<script>
google.charts.load("current", {packages: ["corechart"]});
google.charts.setOnLoadCallback(displayReports);
function displayReports(){
try{
