/**
* @return void
* @desc Displays a table of the workers
*/
function display_workers()
{
global $db;
for ($i = 0, $n = count($db); $i < $n; $i++) {
$worker_data = $db[$i];
$worker_name = $worker_data[0];
$worker_address = $worker_data[1];
$worker_phone = $worker_data[2];
print "<tr bgcolor=\"" . row_color($i) . "\">\n";
print "<td>{$worker_name}</td>\n";
print "<td>{$worker_address}</td>\n";
print "<td>{$worker_phone}</td>\n";
print "</tr>\n";
}
}
function getFiles()
{
$OBJ =& get_instance();
global $go;
$s = '';
$rs = $OBJ->db->fetchArray("SELECT * FROM " . PX . "media \n WHERE media_ref_id = '0' \n AND media_obj_type = '' \n ORDER by media_uploaded DESC");
if (!$rs) {
$s = 'No files yet';
} else {
foreach ($rs as $a) {
// fake 'mime', actually
$mime = array_pop(explode('.', $a['media_file']));
$use = span(filesManagerType($mime, $a['media_file'], $a['media_x'], $a['media_y'], $a['media_caption']), "class='p-action'");
$edit = span(href("<img src='asset/img/files-edit.gif' />", "?a={$go['a']}&q=editfile&id={$a['media_id']}"), "class='p-action'");
$url = BASEURL . '/files/' . $a['media_file'];
$s .= div($use . $edit . span(href($a['media_file'], $url, "target='show'"), "class='p-name'"), row_color("class='row-color'"));
}
}
return $s;
}
function page_hits()
{
global $go;
// default/validate $_GET
$go['page'] = getURI('page', 0, 'digit', 5);
$this->template->location = $this->lang->word('main');
// sub-locations
$this->template->sub_location[] = array($this->lang->word('referrers'), "?a={$go['a']}&q=refer");
$this->template->sub_location[] = array($this->lang->word('main'), "?a={$go['a']}");
load_module_helper('files', $go['a']);
$today = convertToStamp(getNow());
$day = substr($today, 6, 2);
$mn = substr($today, 4, 2);
$yr = substr($today, 0, 4);
$thirtydays = date('Y-m-d', mktime('00', '00', '00', $mn - 1, $day, $yr));
$rs = $this->db->fetchArray("SELECT hit_page, \n COUNT(hit_page) AS 'total' \n FROM " . PX . "stats \n GROUP by hit_page \n ORDER BY total DESC");
// ++++++++++++++++++++++++++++++++++++++++++++++++++++
// table for all our results
$body = "<table cellpadding='0' cellspacing='0' border='0'>\n";
$body .= "<tr class='top'>\n";
$body .= "<th width='90%' class='toptext'><strong>" . $this->lang->word('page') . "</strong></th>\n";
$body .= "<th width='10%' class='toptext'><strong>" . $this->lang->word('visits') . "</strong></th>\n";
$body .= "</tr>\n";
$body .= "</table>\n";
// dynamic output for table
$body .= "<table cellpadding='0' cellspacing='0' border='0'>\n";
if (!$rs) {
$body .= tr(td('No hits yet', "colspan='2'"));
} else {
foreach ($rs as $ar) {
$body .= tr(td($ar['hit_page'], "width='90%' class='cell-doc'") . td($ar['total'], "width='10%' class='cell-mid'"), row_color(" class='color'"));
}
}
// end dynamic rows output
$body .= "</table>\n";
$this->template->body = $body;
return;
}
