}
if (isset($_GET['status']) && $_GET['status'] != '') {
$status = $_GET['status'];
$sql2 = " AND od_status = '{$status}'";
$queryString = "&status={$status}";
} else {
$status = '';
$sql2 = '';
$queryString = '';
}
// for paging
// how many rows to show per page
$rowsPerPage = 10;
$sql = "SELECT o.od_id, o.od_shipping_first_name, od_shipping_last_name, od_date, od_status,\r\n SUM(pd_price * od_qty) + od_shipping_cost AS od_amount\r\n\t FROM tbl_order o, tbl_order_item oi, tbl_product p \r\n\t\tWHERE oi.pd_id = p.pd_id and o.od_id = oi.od_id {$sql2}\r\n\t\tGROUP BY od_id\r\n\t\tORDER BY od_id DESC";
$result = dbQuery(getPagingQuery($sql, $rowsPerPage));
$pagingLink = getPagingLink($sql, $rowsPerPage, $queryString);
$orderStatus = array('New', 'Paid', 'Shipped', 'Completed', 'Cancelled');
$orderOption = '';
foreach ($orderStatus as $stat) {
$orderOption .= "<option value=\"{$stat}\"";
if ($stat == $status) {
$orderOption .= " selected";
}
$orderOption .= ">{$stat}</option>\r\n";
}
?>
<p> </p>
<form action="processOrder.php" method="post" name="frmOrderList" id="frmOrderList">
<table width="100%" border="0" cellspacing="0" cellpadding="2" class="text">
<tr align="center">
function pagination($id)
{
return getPagingLink($id, 'pages', 5, '', 'page/index/');
}
<?php
if (!defined('WEB_ROOT')) {
exit;
}
$productsPerRow = 2;
$productsPerPage = 4;
//$productList = getProductList($catId);
$children = array_merge(array($catId), getChildCategories(NULL, $catId));
$children = ' (' . implode(', ', $children) . ')';
$sql = "SELECT pd_id, pd_name, pd_price, pd_thumbnail, pd_qty, c.cat_id\r\n\t\tFROM tbl_product pd, tbl_category c\r\n\t\tWHERE pd.cat_id = c.cat_id AND pd.cat_id IN {$children} \r\n\t\tORDER BY pd_name";
$result = dbQuery(getPagingQuery($sql, $productsPerPage));
$pagingLink = getPagingLink($sql, $productsPerPage, "c={$catId}");
$numProduct = dbNumRows($result);
// the product images are arranged in a table. to make sure
// each image gets equal space set the cell width here
$columnWidth = (int) (100 / $productsPerRow);
?>
<table width="100%" border="0" cellspacing="0" cellpadding="20">
<?php
if ($numProduct > 0) {
$i = 0;
while ($row = dbFetchAssoc($result)) {
extract($row);
if ($pd_thumbnail) {
$pd_thumbnail = WEB_ROOT . 'images/product/' . $pd_thumbnail;
} else {
$pd_thumbnail = WEB_ROOT . 'images/no-image-small.png';
}
if ($i % $productsPerRow == 0) {
echo '<tr>';
<?php
if (!defined('WEB_ROOT')) {
exit;
}
// for paging
// how many rows to show per page
$rowsPerPage = 100;
$sql = "SELECT topics.topic_id as tid, topics.name as tname,courses.name as cname,courses.course_id as cid FROM topics left join courses_topics on topics.topic_id=courses_topics.topic_id left join courses on courses.course_id=courses_topics.course_id ORDER BY topics.topic_id";
$result = dbQuery(getPagingQuery($sql, $rowsPerPage));
$pagingLink = getPagingLink($sql, $rowsPerPage, '');
?>
<p> </p>
<form action="processTopics.php?action=addTopic" method="post" name="frmListTopic" id="frmListTopic">
<table width="100%" border="0" cellspacing="0" cellpadding="2" class="text">
</table>
<br>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" class="text">
<tr align="center" id="listTableHeader">
<td>Topic Name</td>
<!-- <td width="75">Thumbnail</td>-->
<td width="275">Courses</td>
</tr>
<?php
$parentId = 0;
if (dbNumRows($result) > 0) {
$i = 0;
while ($row = dbFetchAssoc($result)) {
extract($row);
if ($i % 2) {
function pagination($id)
{
return getPagingLink($id, 'admin', 5, '', 'admins/index/');
}
