function pretake_update()
{
extract($_REQUEST);
pglib_transaction("BEGIN");
$page = page_number($offset);
if (isset($new) && $new) {
$sql = "DELETE FROM cubit.stock_take";
db_exec($sql) or errDie("Unable to remove old stock take.");
}
$sql = "SELECT stkid FROM cubit.stock \n\t\t\tORDER BY stkcod ASC LIMIT {$limit} OFFSET {$offset}";
$stock_rslt = db_exec($sql) or errDie("Unable to retrieve stock.");
while (list($stkid) = pg_fetch_array($stock_rslt)) {
$sql = "INSERT INTO cubit.stock_take (stkid, page)\n\t\t\t\tVALUES ('{$stkid}', '{$page}')";
db_exec($sql) or errDie("Unable to add to stock take.");
}
$sql = "SELECT stkid FROM cubit.stock\n\t\t\tORDER BY stkcod ASC LIMIT {$limit} OFFSET {$offset}";
db_exec($sql) or errDie("Unable to retrieve stock take.");
$next_page = $page + 1;
$next_offset = page_offset($next_page);
if ($next_page <= total_pages()) {
$button = "<input type='submit' value='Page {$next_page}' />";
} else {
$button = "\n\t\t<input type='button' value='Post Stock Take'\n\t\tonclick='javascript:move(\"stock_take_post.php\")' />";
}
pglib_transaction("COMMIT");
$OUTPUT = "\n\t<script>\n\t\tprinter(\"" . SELF . "?key=pretake_print&offset={$offset}&limit={$limit}\");\n\t</script>\n\t<center>\n\t<h3>Pre Stock Take</h3>\n\t<form method='post' action='" . SELF . "'>\n\t<input type='hidden' name='key' value='pretake_update' />\n\t<input type='hidden' name='limit' value='{$limit}' />\n\t<input type='hidden' name='offset' value='{$next_offset}' />\n\t{$button}\n\t</form>\n\t</center>";
return $OUTPUT;
}
<?php
if ($errors = input_errors()) {
echo $errors;
} else {
$rows_per_page = 100;
$url = htmlentities($_SERVER['REQUEST_URI']);
$sqlresult = build_runselect_sql($_GET);
$sql = $sqlresult['sql'];
$binds = $sqlresult['binds'];
$total_rows = count_rows($conn, $sql, $binds);
$sum_events = fetch_sum_events($sqlresult);
if ($total_rows == 0) {
echo "<h3>No results found.</h3>";
} else {
$total_pages = total_pages($total_rows, $rows_per_page);
// Set the page number
if (isset($_GET['page'])) {
$page = $_GET['page'];
}
if (!isset($_GET['page']) || !preg_match('/^[0-9]+$/', $_GET['page']) || $_GET['page'] < 1) {
$page = 1;
} else {
if ($_GET['page'] > $total_pages) {
$page = $total_pages;
}
}
$start_row = page_to_row($page, $rows_per_page);
$stmt =& paged_result($conn, $sql, $binds, $start_row, $rows_per_page);
$runselect_headers = get_runselect_headers();
$nruncols = count($runselect_headers);
if ($_GET['admin_data'] == 'history') {
$rs = vcn_report($common_filter, $opts);
}
//filter reports
if ($_GET['admin_data'] == 'customer') {
$rs = get_customers($common_filter, $opts);
}
//get filter customers
}
//segment
$totals = mysql_fetch_array($rs);
if (mysql_num_rows($rs)) {
mysql_data_seek($rs, 0);
}
//reset mysql
$total_pages = isset($totals['total_results']) ? total_pages($totals['total_results'], $num) : 0;
//get total pages
push_messages('Tìm thấy <b>' . (isset($totals['total_results']) ? $totals['total_results'] : 0) . '</b> kết quả.');
//result
$data['rs'] = $rs;
extract($data);
//show messages
show_messages();
if (is_resource($rs) && mysql_num_rows($rs)) {
$first = mysql_fetch_array($rs);
mysql_data_seek($rs, 0);
//reset
if (isset($first['today_trans'])) {
?>
<div>Ngày hôm naycó: <strong><?php
echo $first['today_trans'] ? $first['today_trans'] : 0;
<?php require_once "database.php"; require_once "models/functions.php"; $link = db_connect(); $page_count = 5; //количество переключателей страниц (нечетное!) $page_length = 10; //количество статей на странице $total_pages = total_pages($link, $page_length); //всего сформировано страниц $page = check_page($_GET['page'], $total_pages); $list_news = news_page($link, $page, $page_length); include "views/all_news.php";
public function has_next()
{
return $this->current_page < total_pages() ? true : false;
}
?>
</span></div>
</div>
<!--end post-->
<?php
}
?>
<div class="navigation">
<?php
next_posts_link('Previous Page');
?>
<span class="extralarge"><?php
echo $paged;
?>
of <?php
echo total_pages();
?>
</span> <?php
previous_posts_link('Next Page');
?>
</div>
<?php
} else {
?>
<?php
include TEMPLATEPATH . '/notfound.php';
?>
<?php
}
?>
</div>
