function _make_html_table($table, $item, $urlPrefix, $n, &$data) { $dbh = getdbh(); //pagination $stmt = $dbh->query("SELECT count(OID) total FROM {$table}"); $total = $stmt->fetchColumn(); $limit = $GLOBALS['pagination']['per_page']; $data['body'][] = '<p>Showing records ' . ($n + 1) . ' to ' . min($total, $n + $limit) . ' of ' . $total . '</p>'; $data['body'][] = pagination::makePagination($n, $total, myUrl("{$urlPrefix}/manage"), $GLOBALS['pagination']); //table $fields = "URL,stationId,lastContact,debug"; $stmt = $dbh->query("SELECT OID,CID,{$fields} FROM {$table} LIMIT {$n},{$limit}"); if ($stmt === false) { var_dump($dbh->errorInfo()); return; } $tablearr[] = explode(',', $fields); while ($rs = $stmt->fetch(PDO::FETCH_ASSOC)) { $OID = $rs['OID']; $CID = $rs['CID']; $row = null; foreach ($tablearr[0] as $f) { $row[] = htmlspecialchars($rs[$f]); } $row[] = '<a href="' . myUrl("{$urlPrefix}/ops_reset/{$OID}/{$CID}") . '">Reset</a> | ' . '<a href="' . myUrl("{$urlPrefix}/ops_shutdown/{$OID}/{$CID}") . '">Shutdown</a> | ' . '<a href="' . myUrl("{$urlPrefix}/edit/{$OID}/{$CID}") . '">Edit</a> | ' . '<a href="javascript:jsconfirm(\'Really Delete ' . $item . '?\',\'' . myUrl("{$urlPrefix}/ops_delete/{$OID}/{$CID}") . '\')">Delete</a>'; $tablearr[] = $row; } $data['body'][] = table::makeTable($tablearr); $data['head'][] = '<script type="text/javascript" src="' . myUrl('js/jsconfirm.js') . '"></script>'; }
function _make_user_table($n, &$data) { $dbh = getdbh(); //pagination $stmt = $dbh->query('SELECT count(*) "total" FROM "users"'); $rs = $stmt->fetch(PDO::FETCH_ASSOC); $total = $rs['total']; $limit = $GLOBALS['pagination']['per_page']; $data['body'][] = '<p>Showing records ' . ($n + 1) . ' to ' . min($total, $n + $limit) . ' of ' . $total . '</p>'; $data['body'][] = pagination::makePagination($n, $total, myUrl('users/manage'), $GLOBALS['pagination']); //table $stmt = $dbh->query("SELECT * FROM \"users\" LIMIT {$n},{$limit}"); $tablearr[] = explode(',', 'uid,username,password,fullname,created_dt,Action'); while ($rs = $stmt->fetch(PDO::FETCH_ASSOC)) { $uid = $rs['uid']; $row = null; foreach ($rs as $k => $v) { $row[$k] = htmlspecialchars($v); } $row[] = '<a href="' . myUrl("users/edit/{$uid}") . '">Edit</a> | <a href="javascript:jsconfirm(\'Really Delete User?\',\'' . myUrl("users/ops_delete/{$uid}") . '\')">Delete</a>'; $tablearr[] = $row; } $data['body'][] = table::makeTable($tablearr); $data['head'][] = '<script type="text/javascript" src="' . myUrl('js/jsconfirm.js') . '"></script>'; }
function _make_html_table($n, &$data) { $dbh = getdbh(); //pagination $stmt = $dbh->query('SELECT count(OID) total FROM t_user'); $total = $stmt->fetchColumn(); $limit = $GLOBALS['pagination']['per_page']; $data['body'][] = '<p>Showing records ' . ($n + 1) . ' to ' . min($total, $n + $limit) . ' of ' . $total . '</p>'; $data['body'][] = pagination::makePagination($n, $total, myUrl('mgmt_user/manage'), $GLOBALS['pagination']); //table $stmt = $dbh->query("SELECT OID,CID,permissions,username,fullname FROM t_user LIMIT {$n},{$limit}"); $tablearr[] = explode(',', 'username,roll,fullname'); while ($rs = $stmt->fetch(PDO::FETCH_ASSOC)) { $OID = $rs['OID']; $CID = $rs['CID']; $row = null; $row['username'] = htmlspecialchars($rs['username']); $row['roll'] = htmlspecialchars(User::getPermissionsAsRollText($rs['permissions'])); $row['fullname'] = htmlspecialchars($rs['fullname']); $row[] = '<a href="' . myUrl("mgmt_user/edit/{$OID}/{$CID}") . '">Edit</a> | <a href="javascript:jsconfirm(\'Really Delete User?\',\'' . myUrl("mgmt_user/ops_delete/{$OID}/{$CID}") . '\')">Delete</a>'; $tablearr[] = $row; } $data['body'][] = table::makeTable($tablearr); $data['head'][] = '<script type="text/javascript" src="' . myUrl('js/jsconfirm.js') . '"></script>'; }
function _make_html_table($n, &$data) { $dbh = getdbh(); //pagination $stmt = $dbh->query('SELECT count(OID) total FROM t_event'); $total = $stmt->fetchColumn(); $limit = $GLOBALS['pagination']['per_page']; $data['body'][] = '<p>Showing records ' . ($n + 1) . ' to ' . min($total, $n + $limit) . ' of ' . $total . '</p>'; $data['body'][] = pagination::makePagination($n, $total, myUrl('mgmt_main/manage'), $GLOBALS['pagination']); //table $stmt = $dbh->query("SELECT created_dt,teamId,stationId,points,data FROM t_event LIMIT {$n},{$limit}"); $tablearr[] = explode(',', 'created_dt,teamId,stationId,points,data'); while ($rs = $stmt->fetch(PDO::FETCH_ASSOC)) { $row = null; foreach ($tablearr[0] as $f) { $row[] = htmlspecialchars($rs[$f]); } $tablearr[] = $row; } $data['body'][] = table::makeTable($tablearr); $data['body'][] = '<p><a href="' . myUrl("mgmt_main") . '">Back</a></p>'; $data['head'][] = '<script type="text/javascript" src="' . myUrl('js/jsconfirm.js') . '"></script>'; }
function _make_html_ext_table($view, $item, $urlPrefix, &$data) { $dbh = getdbh(); //view $fields = "Name,towerD,towerH,Duration,Score"; $stmt = $dbh->query("SELECT {$fields} FROM {$view}"); if ($stmt === false) { var_dump($dbh->errorInfo()); return; } $fields = explode(',', $fields); $tablearr[] = explode(',', "Name,Location Accuracy,Height Accuracy,Duration,Score"); while ($rs = $stmt->fetch(PDO::FETCH_ASSOC)) { $row = null; foreach ($fields as $f) { $row[] = htmlspecialchars($rs[$f]); } $tablearr[] = $row; } $data['head'][] = '<meta http-equiv="refresh" content="' . $GLOBALS['leaderBoardRefresh'] . '">'; $data['body'][] = table::makeTable($tablearr); }