本文整理汇总了PHP中splitPageResults类的典型用法代码示例。如果您正苦于以下问题：PHP splitPageResults类的具体用法？PHP splitPageResults怎么用？PHP splitPageResults使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了splitPageResults类的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: build_main_html
function build_main_html()
{
global $db, $messageStack;
// Build heading bar
$output = '<table border="0" width="100%" cellspacing="0" cellpadding="1">' . chr(10);
$output .= ' <tr class="dataTableHeadingRow" valign="top">' . chr(10);
$heading_array = array('countries_name' => SETUP_INFO_COUNTRY_NAME, 'countries_iso_code_2' => SETUP_INFO_COUNTRY_CODE_2, 'countries_iso_code_3' => SETUP_INFO_COUNTRY_CODE_3);
$result = html_heading_bar($heading_array, $_GET['list_order']);
$output .= $result['html_code'];
$disp_order = $result['disp_order'];
$output .= ' </tr>' . chr(10);
// Build field data
$query_raw = "select countries_id, countries_name, countries_iso_code_2, countries_iso_code_3 \r\n from " . $this->db_table . " order by {$disp_order}";
$page_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $query_raw, $query_numrows);
$result = $db->Execute($query_raw);
while (!$result->EOF) {
$output .= ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">' . chr(10);
$output .= ' <td class="dataTableContent" onclick="loadPopUp(\'edit\', ' . $result->fields['countries_id'] . ')">' . htmlspecialchars($result->fields['countries_name']) . '</td>' . chr(10);
$output .= ' <td class="dataTableContent" onclick="loadPopUp(\'edit\', ' . $result->fields['countries_id'] . ')">' . $result->fields['countries_iso_code_2'] . '</td>' . chr(10);
$output .= ' <td class="dataTableContent" onclick="loadPopUp(\'edit\', ' . $result->fields['countries_id'] . ')">' . $result->fields['countries_iso_code_3'] . '</td>' . chr(10);
$output .= ' <td class="dataTableContent" align="right">' . chr(10);
if ($this->security_id > 1) {
$output .= html_icon('actions/edit-find-replace.png', TEXT_EDIT, 'small', 'onclick="loadPopUp(\'edit\', ' . $result->fields['countries_id'] . ')"') . chr(10);
}
if ($this->security_id > 3) {
$output .= html_icon('emblems/emblem-unreadable.png', TEXT_DELETE, 'small', 'onclick="if (confirm(\'' . SETUP_COUNTRY_DELETE_INTRO . '\')) submitSeq(' . $result->fields['countries_id'] . ', \'delete\')"') . chr(10);
}
$output .= ' </td>' . chr(10);
$output .= ' </tr>' . chr(10);
$result->MoveNext();
}
$output .= '</table>' . chr(10);
$output .= '<div class="page_count_right">' . $page_split->display_links($query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page']) . '</div>' . chr(10);
$output .= '<div class="page_count">' . $page_split->display_count($query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_COUNTRIES) . '</div>' . chr(10);
return $output;
}示例2: where
?>
</td>
<td class="dataTableHeadingContent" align="right"><?php
echo TABLE_HEADING_RELEASED;
?>
</td>
<td class="dataTableHeadingContent" align="right"><?php
echo TABLE_HEADING_ACTION;
?>
</td>
</tr>
<?php
// $gv_query_raw = "select c.customers_firstname, c.customers_lastname, gv.unique_id, gv.date_created, gv.amount, gv.order_id from " . TABLE_CUSTOMERS . " c, " . TABLE_COUPON_GV_QUEUE . " gv where (gv.customer_id = c.customers_id and gv.release_flag = 'N')";
$gv_query_raw = "select c.customers_firstname, c.customers_lastname, gv.unique_id, gv.date_created, gv.amount, gv.order_id, gv.release_flag, gv.release_date from " . TABLE_CUSTOMERS . " c, " . TABLE_COUPON_GV_QUEUE . " gv where (gv.customer_id = c.customers_id " . $filter . ") order by gv.release_flag, gv.order_id";
$gv_query = tep_db_query($gv_query_raw);
$gv_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $gv_query_raw, $gv_query_numrows);
while ($gv_list = tep_db_fetch_array($gv_query)) {
if ((!$_GET['gid'] || @$_GET['gid'] == $gv_list['unique_id']) && !$gInfo) {
$gInfo = new objectInfo($gv_list);
}
if (is_object($gInfo) && $gv_list['unique_id'] == $gInfo->unique_id) {
echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="document.location.href=\'' . tep_href_link('gv_queue.php', tep_get_all_get_params(array('gid', 'action')) . 'gid=' . $gInfo->unique_id . '&action=edit') . '\'">' . "\n";
} else {
echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="document.location.href=\'' . tep_href_link('gv_queue.php', tep_get_all_get_params(array('gid', 'action')) . 'gid=' . $gv_list['unique_id']) . '\'">' . "\n";
}
?>
<td class="dataTableContent"><?php
echo $gv_list['customers_firstname'] . ' ' . $gv_list['customers_lastname'];
?>
</td>
<td class="dataTableContent" align="center"><?php 示例3: splitPageResults
<td class="dataTableHeadingContent"><?php
echo TABLE_HEADING_COUNTRY_NAME;
?>
</td>
<td class="dataTableHeadingContent" align="center" colspan="2"><?php
echo TABLE_HEADING_COUNTRY_CODES;
?>
</td>
<td class="dataTableHeadingContent" align="right"><?php
echo TABLE_HEADING_ACTION;
?>
</td>
</tr>
<?php
$countries_query_raw = "select countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id from " . TABLE_COUNTRIES . " order by countries_name";
$countries_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $countries_query_raw, $countries_query_numrows);
$countries_query = tep_db_query($countries_query_raw);
while ($countries = tep_db_fetch_array($countries_query)) {
if ((!isset($HTTP_GET_VARS['cID']) || isset($HTTP_GET_VARS['cID']) && $HTTP_GET_VARS['cID'] == $countries['countries_id']) && !isset($cInfo) && substr($action, 0, 3) != 'new') {
$cInfo = new objectInfo($countries);
}
if (isset($cInfo) && is_object($cInfo) && $countries['countries_id'] == $cInfo->countries_id) {
echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link('countries.php', 'page=' . $HTTP_GET_VARS['page'] . '&cID=' . $cInfo->countries_id . '&action=edit') . '\'">' . "\n";
} else {
echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link('countries.php', 'page=' . $HTTP_GET_VARS['page'] . '&cID=' . $countries['countries_id']) . '\'">' . "\n";
}
?>
<td class="dataTableContent"><?php
echo $countries['countries_name'];
?>
</td>示例4: intval
?>
</td>
<td class="dataTableHeadingContent" align="center"><?php
echo TABLE_HEADING_DATE_EXPECTED;
?>
</td>
<td class="dataTableHeadingContent" align="right"><?php
echo TABLE_HEADING_ACTION;
?>
</td>
</tr>
<?php
$productstable = $oostable['products'];
$products_descriptiontable = $oostable['products_description'];
$products_result_raw = "SELECT pd.products_id, pd.products_name, p.products_date_available\n FROM {$products_descriptiontable} pd,\n {$productstable} p\n WHERE p.products_id = pd.products_id AND\n p.products_date_available != '' AND\n pd.products_languages_id = '" . intval($_SESSION['language_id']) . "'\n ORDER BY p.products_date_available DESC";
$products_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $products_result_raw, $products_result_numrows);
$products_result = $dbconn->Execute($products_result_raw);
while ($products = $products_result->fields) {
if ((!isset($_GET['pID']) || isset($_GET['pID']) && $_GET['pID'] == $products['products_id']) && !isset($pInfo)) {
$pInfo = new objectInfo($products);
}
if (isset($pInfo) && is_object($pInfo) && $products['products_id'] == $pInfo->products_id) {
echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="document.location.href=\'' . oos_href_link_admin($aFilename['categories'], 'pID=' . $products['products_id'] . '&action=new_product') . '\'">' . "\n";
} else {
echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="document.location.href=\'' . oos_href_link_admin($aFilename['products_expected'], 'page=' . $_GET['page'] . '&pID=' . $products['products_id']) . '\'">' . "\n";
}
?>
<td class="dataTableContent"><?php
echo $products['products_name'];
?>
</td>示例5: splitPageResults
<td class="dataTableHeadingContent"><?php
echo TABLE_HEADING_NAME;
?>
</td>
<td class="dataTableHeadingContent" align="center"><?php
echo TABLE_HEADING_DIRECTORY;
?>
</td>
<td class="dataTableHeadingContent" align="right"><?php
echo TABLE_HEADING_ACTION;
?>
</td>
</tr>
<?php
$template_query_raw = "select * from " . TABLE_TEMPLATE_SELECT;
$template_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $template_query_raw, $template_query_numrows);
$templates = $db->Execute($template_query_raw);
while (!$templates->EOF) {
if ((!isset($_GET['tID']) || isset($_GET['tID']) && $_GET['tID'] == $templates->fields['template_id']) && !isset($tInfo) && substr($action, 0, 3) != 'new') {
$tInfo = new objectInfo($templates->fields);
}
if (isset($tInfo) && is_object($tInfo) && $templates->fields['template_id'] == $tInfo->template_id) {
echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . zen_href_link(FILENAME_TEMPLATE_SELECT, 'page=' . $_GET['page'] . '&tID=' . $tInfo->template_id . '&action=edit') . '\'">' . "\n";
} else {
echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . zen_href_link(FILENAME_TEMPLATE_SELECT, 'page=' . $_GET['page'] . '&tID=' . $templates->fields['template_id']) . '\'">' . "\n";
}
if ($templates->fields['template_language'] == 0) {
$template_language = "Default(All)";
} else {
$ln = $db->Execute("select name\n from " . TABLE_LANGUAGES . "\n where languages_id = '" . $templates->fields['template_language'] . "'");
$template_language = $ln->fields['name'];示例6: array
$where = array();
if (is_numeric($_SESSION['quick_updates']['products_status'])) {
$where[] = "p.products_status = '" . (int) $_SESSION['quick_updates']['products_status'] . "'";
}
if ($current_category_id > 0) {
$where[] = "p2c.categories_id = '" . $current_category_id . "'";
}
if ($manufacturer) {
$where[] = "p.manufacturers_id = '" . (int) $manufacturer . "'";
}
if (sizeof($where) > 0) {
$products_query_raw .= " where " . implode(' and ', $where);
}
$products_query_raw .= " " . $sort_by;
//// page splitter and display each products info
$products_split = new splitPageResults($split_page, MAX_DISPLAY_ROW_BY_PAGE, $products_query_raw, $products_query_numrows);
$products = $db->Execute($products_query_raw);
// eof get products data from db
// Let's start displaying page with forms
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php
echo HTML_PARAMS;
?>
>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php
echo CHARSET;
?>
">
<title><?php 示例7: Copyright
<?php
/*
$Id: product_listing.php,v 1.44 2003/06/09 22:49:59 hpdl Exp $
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
Released under the GNU General Public License
*/
?>
<?php
$listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_SEARCH_RESULTS, 'rt.room_type_categories');
$flag1 = 0;
if ($listing_split->number_of_rows > 0 && (PREV_NEXT_BAR_LOCATION == '1' || PREV_NEXT_BAR_LOCATION == '2')) {
}
$list_box_contents = array();
for ($col = 0, $n = sizeof($column_list); $col < $n; $col++) {
switch ($column_list[$col]) {
case 'PRODUCT_LIST_IMAGE':
$lc_text = "Hình ảnh";
$lc_align = '';
break;
case 'PRODUCT_LIST_NAME':
$lc_text = 'Loại phòng';
$lc_align = '';
break;
case 'PRODUCT_LIST_PRICE':示例8: IF
require 'includes/oos_system.php';
if (!isset($option)) {
require 'includes/info_message.php';
require 'includes/oos_blocks.php';
}
if (USE_CACHE == '1' && !SID) {
$oSmarty->caching = 2;
$oSmarty->cache_lifetime = 6 * 3600;
}
if (!$oSmarty->is_cached($aOption['template_main'], $contents_cache_id)) {
$productstable = $oostable['products'];
$specialsstable = $oostable['specials'];
$manufacturersstable = $oostable['manufacturers'];
$products_descriptiontable = $oostable['products_description'];
$top_viewed_result_raw = "SELECT p.products_id, pd.products_name, p.products_image, p.products_price,\n p.products_base_price, p.products_base_unit, p.products_units_id,\n p.products_discount_allowed, p.products_tax_class_id, p.products_units_id,\n IF(s.status, s.specials_new_products_price, NULL) AS specials_new_products_price,\n p.products_date_added, m.manufacturers_name\n FROM {$productstable} p LEFT JOIN\n {$manufacturersstable} m ON p.manufacturers_id = m.manufacturers_id LEFT JOIN\n {$products_descriptiontable} pd ON p.products_id = pd.products_id AND pd.products_languages_id = '" . intval($nLanguageID) . "' LEFT JOIN\n {$specialsstable} s ON p.products_id = s.products_id\n WHERE p.products_status >= '1'\n AND (p.products_access = '0' OR p.products_access = '" . intval($nGroupID) . "')\n ORDER BY p.products_date_added DESC, pd.products_name";
$top_viewed_split = new splitPageResults($nCurrentPageNumber, MAX_DISPLAY_PRODUCTS_NEW, $top_viewed_result_raw, $top_viewed_numrows);
$top_viewed_result = $dbconn->Execute($top_viewed_result_raw);
$top_viewed_array = array();
while ($top_viewed = $top_viewed_result->fields) {
$new_product_price = '';
$new_product_special_price = '';
$new_max_product_discount = 0;
$new_special_price = '';
$new_product_discount_price = '';
$new_base_product_price = '';
$new_base_product_special_price = '';
$new_product_units = UNITS_DELIMITER . $products_units[$top_viewed['products_units_id']];
$new_product_price = $oCurrencies->display_price($top_viewed['products_price'], oos_get_tax_rate($top_viewed['products_tax_class_id']));
if (isset($top_viewed['specials_new_products_price'])) {
$new_special_price = $top_viewed['specials_new_products_price'];
$new_product_special_price = $oCurrencies->display_price($new_special_price, oos_get_tax_rate($top_viewed['products_tax_class_id']));示例9: Project
based on:
(c) 2000-2001 The Exchange Project (earlier name of osCommerce)
(c) 2002-2003 osCommerce(reviews.php,v 1.48 2003/05/27); www.oscommerce.com
(c) 2003 nextcommerce (reviews.php,v 1.12 2003/08/17); www.nextcommerce.org
(c) 2004 XT - Commerce; www.xt-commerce.com
Released under the GNU General Public License
---------------------------------------------------------------------------------------*/
include 'includes/application_top.php';
// include needed functions
require_once DIR_FS_INC . 'olc_word_count.inc.php';
require_once DIR_FS_INC . 'olc_date_long.inc.php';
$breadcrumb->add(NAVBAR_TITLE_REVIEWS, olc_href_link(FILENAME_REVIEWS));
require DIR_WS_INCLUDES . 'header.php';
$reviews_query_raw = "\nselect r.reviews_id,\nleft(rd.reviews_text, 250) as reviews_text,\nr.reviews_rating,\nr.date_added,\np.products_id,\npd.products_name,\np.products_image,\nr.customers_name\nfrom " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd\nwhere\np.products_status = 1 and\np.products_id = r.products_id and\nr.reviews_id = rd.reviews_id and\np.products_id = pd.products_id and\npd.language_id = " . SESSION_LANGUAGE_ID . " and\nrd.languages_id = " . SESSION_LANGUAGE_ID . "\norder by r.reviews_id DESC";
$reviews_split = new splitPageResults($reviews_query_raw, $_GET['page'], MAX_DISPLAY_NEW_REVIEWS);
if ($reviews_split->number_of_rows > 0 && (PREV_NEXT_BAR_LOCATION == '1' || PREV_NEXT_BAR_LOCATION == '3')) {
$smarty->assign('NAVBAR', '
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td class="smallText">' . $reviews_split->display_count(TEXT_DISPLAY_NUMBER_OF_REVIEWS) . '</td>
<td align="right" class="smallText">' . TEXT_RESULT_PAGE . BLANK . $reviews_split->display_links(MAX_DISPLAY_PAGE_LINKS, olc_get_all_get_params(array('page', 'info', 'x', 'y'))) . '</td>
</tr>
</table>
');
}
$module_data = array();
if ($reviews_split->number_of_rows > 0) {
$reviews_query = olc_db_query($reviews_split->sql_query);
while ($reviews = olc_db_fetch_array($reviews_query)) {
$module_data[] = array('PRODUCTS_IMAGE' => DIR_WS_THUMBNAIL_IMAGES . $reviews['products_image'], $reviews['products_name'], 'PRODUCTS_LINK' => olc_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $reviews['products_id'] . '&reviews_id=' . $reviews['reviews_id']), 'PRODUCTS_NAME' => $reviews['products_name'], 'AUTHOR' => $reviews['customers_name'], 'TEXT' => sprintf(TEXT_REVIEW_WORD_COUNT, olc_word_count($reviews['reviews_text'], BLANK)) . ')<br/>' . htmlspecialchars($reviews['reviews_text']) . '..', 'RATING' => olc_image(DIR_WS_IMAGES . 'stars_' . $reviews['reviews_rating'] . '.gif', sprintf(BOX_REVIEWS_TEXT_OF_5_STARS, $reviews['reviews_rating'])));示例10: splitPageResults
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr class="dataTableHeadingRow">
<td class="dataTableHeadingContent"><?php
echo TABLE_HEADING_BLACKLIST;
?>
</td>
<td class="dataTableHeadingContent" align="right"><?php
echo TABLE_HEADING_ACTION;
?>
</td>
</tr>
<?php
$blacklist_query_raw = "select blacklist_id, blacklist_card_number, date_added, last_modified from " . TABLE_BLACKLIST . " order by blacklist_id";
$blacklist_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $blacklist_query_raw, $blacklist_query_numrows);
$blacklist_query = olc_db_query($blacklist_query_raw);
while ($blacklist = olc_db_fetch_array($blacklist_query)) {
if ((!$_GET['bID'] || @$_GET['bID'] == $blacklist['blacklist_id']) && !$bInfo && substr($_GET['action'], 0, 3) != 'new') {
$blacklist_numbers_query = olc_db_query("select count(*) as blacklist_count from " . TABLE_BLACKLIST . " where blacklist_id = '" . $blacklist['blacklist_id'] . APOS);
$blacklist_numbers = olc_db_fetch_array($blacklist_numbers_query);
$bInfo_array = olc_array_merge($blacklist, $blacklist_numbers);
$bInfo = new objectInfo($bInfo_array);
}
if (is_object($bInfo) && $blacklist['blacklist_id'] == $bInfo->blacklist_id) {
echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="javascript:' . olc_onclick_link(FILENAME_BLACKLIST, 'page=' . $_GET['page'] . '&bID=' . $blacklist['blacklist_id'] . '&action=edit') . '">' . NEW_LINE;
} else {
echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="javascript:' . olc_onclick_link(FILENAME_BLACKLIST, 'page=' . $_GET['page'] . '&bID=' . $blacklist['blacklist_id']) . '">' . NEW_LINE;
}
?>
<td class="dataTableContent"><?php 示例11: splitPageResults
<td class="dataTableHeadingContent"><?php
echo TABLE_HEADING_PRODUCTS;
?>
</td>
<td class="dataTableHeadingContent" align="center"><?php
echo TABLE_HEADING_VIEWED;
?>
</td>
</tr>
<?php
if (isset($_GET['page']) && $_GET['page'] > 1) {
$rows = $_GET['page'] * MAX_DISPLAY_SEARCH_RESULTS_REPORTS - MAX_DISPLAY_SEARCH_RESULTS_REPORTS;
}
$rows = 0;
$products_query_raw = "select p.`products_id`, pd.`products_name`, p.`products_quantity`, p.`products_type` from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.`products_id` = pd.`products_id` and pd.`language_id`='" . $_SESSION['languages_id'] . "' order by p.`products_quantity`, pd.`products_name`";
$products_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS_REPORTS, $products_query_raw, $products_query_numrows);
$products = $gBitDb->Execute($products_query_raw);
while (!$products->EOF) {
// only show low stock on products that can be added to the cart
if ($zc_products->get_allow_add_to_cart($products->fields['products_id']) == 'Y') {
$rows++;
if (strlen($rows) < 2) {
$rows = '0' . $rows;
}
$type_handler = $zc_products->get_admin_handler($products->fields['products_type']);
$cPath = zen_get_product_path($products->fields['products_id']);
?>
<tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href='<?php
echo zen_href_link_admin($type_handler, '&product_type=' . $products->fields['products_type'] . '&cPath=' . $cPath . '&pID=' . $products->fields['products_id'] . '&action=new_product');
?>
'">示例12: splitPageResults
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr class="dataTableHeadingRow">
<td class="dataTableHeadingContent"><?php
echo TABLE_HEADING_TAX_CLASSES;
?>
</td>
<td class="dataTableHeadingContent" align="right"><?php
echo TABLE_HEADING_ACTION;
?>
</td>
</tr>
<?php
$classes_query_raw = "select tax_class_id, tax_class_title, tax_class_description, last_modified, date_added from " . TABLE_TAX_CLASS . " order by tax_class_title";
$classes_split = new splitPageResults($_GET['page'], '20', $classes_query_raw, $classes_query_numrows);
$classes_query = xtc_db_query($classes_query_raw);
while ($classes = xtc_db_fetch_array($classes_query)) {
if ((!$_GET['tID'] || @$_GET['tID'] == $classes['tax_class_id']) && !$tcInfo && substr($_GET['action'], 0, 3) != 'new') {
$tcInfo = new objectInfo($classes);
}
if (is_object($tcInfo) && $classes['tax_class_id'] == $tcInfo->tax_class_id) {
echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'pointer\'" onclick="document.location.href=\'' . xtc_href_link(FILENAME_TAX_CLASSES, 'page=' . $_GET['page'] . '&tID=' . $tcInfo->tax_class_id . '&action=edit') . '\'">' . "\n";
} else {
echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'pointer\'" onmouseout="this.className=\'dataTableRow\'" onclick="document.location.href=\'' . xtc_href_link(FILENAME_TAX_CLASSES, 'page=' . $_GET['page'] . '&tID=' . $classes['tax_class_id']) . '\'">' . "\n";
}
?>
<td class="dataTableContent"><?php
echo $classes['tax_class_title'];
?>
</td>示例13: splitPageResults
<td class="dataTableHeadingContent" align="right"><?php
echo TABLE_HEADING_RATING;
?>
</td>
<td class="dataTableHeadingContent" align="right"><?php
echo TABLE_HEADING_DATE_ADDED;
?>
</td>
<td class="dataTableHeadingContent" align="right"><?php
echo TABLE_HEADING_ACTION;
?>
</td>
</tr>
<?php
$reviews_query_raw = "select reviews_id, products_id, date_added, last_modified, reviews_rating from " . TABLE_REVIEWS . " where store_id = '" . $store_id . "' order by date_added DESC";
$reviews_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $reviews_query_raw, $reviews_query_numrows);
$reviews_query = smn_db_query($reviews_query_raw);
while ($reviews = smn_db_fetch_array($reviews_query)) {
if ((!isset($_GET['rID']) || isset($_GET['rID']) && $_GET['rID'] == $reviews['reviews_id']) && !isset($rInfo)) {
$reviews_text_query = smn_db_query("select r.reviews_read, r.customers_name, length(rd.reviews_text) as reviews_text_size from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd where r.reviews_id = '" . (int) $reviews['reviews_id'] . "' and r.reviews_id = rd.reviews_id and r.store_id = rd.store_id");
$reviews_text = smn_db_fetch_array($reviews_text_query);
$products_image_query = smn_db_query("select products_image from " . TABLE_PRODUCTS . " where products_id = '" . (int) $reviews['products_id'] . "'");
$products_image = smn_db_fetch_array($products_image_query);
$products_name_query = smn_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int) $reviews['products_id'] . "' and language_id = '" . (int) $languages_id . "'");
$products_name = smn_db_fetch_array($products_name_query);
$reviews_average_query = smn_db_query("select (avg(reviews_rating) / 5 * 100) as average_rating from " . TABLE_REVIEWS . " where products_id = '" . (int) $reviews['products_id'] . "'");
$reviews_average = smn_db_fetch_array($reviews_average_query);
$review_info = array_merge($reviews_text, $reviews_average, $products_name);
$rInfo_array = array_merge($reviews, $review_info, $products_image);
$rInfo = new objectInfo($rInfo_array);
}示例14: oos_db_input
</td>
<td class="dataTableHeadingContent" align="right"><?php
echo TABLE_HEADING_ACTION;
?>
</td>
</tr>
<?php
if (isset($_GET['page']) && $_GET['page'] > 1) {
$rows = $_GET['page'] * 20 - 20;
}
if ($status != '*') {
$cc_result_raw = "SELECT\n coupon_id, coupon_code, coupon_amount, coupon_type, coupon_start_date,\n coupon_expire_date, uses_per_user, uses_per_coupon, restrict_to_products,\n restrict_to_categories, date_created,date_modified\n FROM\n " . $oostable['coupons'] . "\n WHERE\n coupon_active='" . oos_db_input($status) . "' AND\n coupon_type != 'G'";
} else {
$cc_result_raw = "SELECT\n coupon_id, coupon_code, coupon_amount, coupon_type, coupon_start_date,\n coupon_expire_date, uses_per_user, uses_per_coupon, restrict_to_products,\n restrict_to_categories, date_created,date_modified\n FROM\n " . $oostable['coupons'] . "\n WHERE\n coupon_type != 'G'";
}
$cc_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $cc_result_raw, $cc_result_numrows);
$cc_result = $dbconn->Execute($cc_result_raw);
while ($cc_list = $cc_result->fields) {
$rows++;
if (strlen($rows) < 2) {
$rows = '0' . $rows;
}
if ((!isset($_GET['cID']) || isset($_GET['cID']) && $_GET['cID'] == $cc_list['coupon_id']) && !isset($cInfo)) {
$cInfo = new objectInfo($cc_list);
}
if (isset($cInfo) && is_object($cInfo) && $cc_list['coupon_id'] == $cInfo->coupon_id) {
echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="document.location.href=\'' . oos_href_link_admin($aFilename['coupon_admin'], oos_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->coupon_id . '&action=edit') . '\'">' . "\n";
} else {
echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="document.location.href=\'' . oos_href_link_admin($aFilename['coupon_admin'], oos_get_all_get_params(array('cID', 'action')) . 'cID=' . $cc_list['coupon_id']) . '\'">' . "\n";
}
$coupon_description_result = $dbconn->Execute("SELECT coupon_name\n FROM " . $oostable['coupons_description'] . "\n WHERE coupon_id = '" . $cc_list['coupon_id'] . "'\n AND coupon_languages_id = '" . intval($_SESSION['language_id']) . "'");示例15: while
$check_count = 1;
if ($check_page->RecordCount() > MAX_DISPLAY_SEARCH_RESULTS_CUSTOMER) {
while (!$check_page->EOF) {
if ($check_page->fields['customers_id'] == $_GET['cID']) {
break;
}
$check_count++;
$check_page->MoveNext();
}
$_GET['page'] = round($check_count / MAX_DISPLAY_SEARCH_RESULTS_CUSTOMER + (fmod($check_count, MAX_DISPLAY_SEARCH_RESULTS_CUSTOMER) != 0 ? 0.5 : 0), 0);
// zen_redirect(zen_href_link(FILENAME_LINKPOINT_REVIEW, 'cID=' . $_GET['cID'] . (isset($_GET['page']) ? '&page=' . $_GET['page'] : ''), 'NONSSL'));
} else {
$_GET['page'] = 1;
}
}
$customers_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS_CUSTOMER, $customers_query_raw, $customers_query_numrows);
$customers = $db->Execute($customers_query_raw);
while (!$customers->EOF) {
$info = $db->Execute("select customers_info_date_account_created as date_account_created,\n customers_info_date_account_last_modified as date_account_last_modified,\n customers_info_date_of_last_logon as date_last_logon,\n customers_info_number_of_logons as number_of_logons\n from " . TABLE_CUSTOMERS_INFO . "\n where customers_info_id = '" . $customers->fields['customers_id'] . "'");
if ((!isset($_GET['cID']) || isset($_GET['cID']) && $_GET['cID'] == $customers->fields['customers_id']) && !isset($cInfo)) {
$country = $db->Execute("select countries_name\n from " . TABLE_COUNTRIES . "\n where countries_id = '" . (int) $customers->fields['entry_country_id'] . "'");
if (!is_array($country->fields)) {
$country->fields = array();
}
$customer_info = array_merge($country->fields, $info->fields);
$cInfo_array = array_merge($customers->fields, $customer_info);
$cInfo = new objectInfo($cInfo_array);
}
$group_query = $db->Execute("select group_name, group_percentage from " . TABLE_GROUP_PRICING . " where\n group_id = '" . $customers->fields['customers_group_pricing'] . "'");
if ($group_query->RecordCount() < 1) {
$group_name_entry = TEXT_NONE;