<?php
/*Secured user only page*/
include '../includes/constant/config.inc.php';
secure_page();
return_meta("Golf Club Entries");
include '../includes/constant/nav.inc.php';
?>
<h1>Golf Clubs</h1>
<?php
$query_for_table = mysql_query("SELECT * FROM " . TABLE_PRODUCTS . " ORDER BY club ASC;") or die(mysql_error());
//constant/config.inc.php line 393
generate_html_table();
include '../includes/constant/footer.inc.php';
$PAGE->set_title($page_title);
$PAGE->set_heading($page_heading);
$PAGE->navbar->add("AE Reports", $index_url);
$PAGE->navbar->add("Time on Task", $this_url);
echo $OUTPUT->header();
echo '<script src="//code.jquery.com/jquery-1.10.2.js"></script>';
echo '<script src="//code.jquery.com/ui/1.11.1/jquery-ui.js"></script>';
if (sizeof($user_data) > 0) {
if ($debug) {
var_dump($where_items);
var_dump($usersinfo_sql);
var_dump($query_arr);
var_dump($user_data);
} else {
echo html_writer::start_tag('div', array('id' => 'ae_reports_display'));
//echo html_writer::start_tag('div',array('class' => 'ae_reports_view'));
echo html_writer::nonempty_tag('h3', "Teacher Time on Task: {$group_heading}");
echo html_writer::nonempty_tag('h5', "{$subj_heading}{$start_heading}{$end_heading}");
echo generate_html_table($user_data, "id");
//echo html_writer::nonempty_tag('p',"<strong>Reported Users</strong>: ".sizeof($user_data));
echo html_writer::nonempty_tag('p', "<strong>Time on Task</strong>: " . gmdate("H:i:s", $avg_seconds));
echo html_writer::link(new moodle_url($this_url, array('g' => $groupid, 'type' => 'csv')), "Download CSV");
//echo html_writer::end_tag('div');
echo html_writer::end_tag('div');
}
} else {
echo "No records found.";
}
echo $OUTPUT->footer();
break;
}
$add_attributes = $sdb->batch_put_attributes($domain, array('Item_01' => array('Category' => 'Clothes', 'Subcategory' => 'Sweater', 'Name' => 'Cathair Sweater', 'Color' => 'Siamese', 'Size' => array('Small', 'Medium', 'Large')), 'Item_02' => array('Category' => 'Clothes', 'Subcategory' => 'Pants', 'Name' => 'Designer Jeans', 'Color' => 'Paisley Acid Wash', 'Size' => array('30x32', '32x32', '32x34')), 'Item_03' => array('Category' => 'Clothes', 'Subcategory' => 'Pants', 'Name' => 'Sweatpants', 'Color' => array('Blue', 'Yellow', 'Pink'), 'Size' => 'Large', 'Year' => array('2006', '2007')), 'Item_04' => array('Category' => 'Car Parts', 'Subcategory' => 'Engine', 'Name' => 'Turbos', 'Make' => 'Audi', 'Model' => 'S4', 'Year' => array('2000', '2001', '2002')), 'Item_05' => array('Category' => 'Car Parts', 'Subcategory' => 'Emissions', 'Name' => 'O2 Sensor', 'Make' => 'Audi', 'Model' => 'S4', 'Year' => array('2000', '2001', '2002'))));
// Were the attributes added successfully?
if ($add_attributes->isOK()) {
// Add an additional size to Item_01
$append_attributes = $sdb->put_attributes($domain, 'Item_01', array('Size' => 'Extra Large'));
// Were the new attributes appended successfully?
if ($append_attributes->isOK()) {
// Use a SELECT expression to query the data.
// Notice the use of backticks around the domain name.
$results = $sdb->select("SELECT * FROM `{$domain}` WHERE Category = 'Clothes'");
// Get all of the <Item> nodes in the response
$items = $results->body->Item();
// Re-structure the data so access is easier (see helper function below)
$data = reorganize_data($items);
// Generate <table> HTML from the data (see helper function below)
$html = generate_html_table($data);
}
}
}
/*%******************************************************************************************%*/
// HELPER FUNCTIONS
function reorganize_data($items)
{
// Collect rows and columns
$rows = array();
$columns = array();
// Loop through each of the items
foreach ($items as $item) {
// Let's append to a new row
$row = array();
$row['id'] = (string) $item->Name;
