function print_option($sql)
{
$kq = mysql_query($sql);
while ($r = mysql_fetch_array($kq)) {
$ngay = ConvertDate_time_db($r["ngaydat"]);
echo "<option value={$r['0']}> {$ngay} </option>";
}
}
$sql = "select hoadon.*,sanpham.* from hoadon,sanpham where hoadon.id=sanpham.id and hoadon.tinhtrang='dathang' order by ngaydat DESC limit {$k},{$pagesize}";
//echo "$sql";
$kq = mysql_query($sql);
if (!$kq) {
echo "";
} else {
while ($r = mysql_fetch_array($kq)) {
$id = $r["id"];
$id_hoadon = $r["id_hoadon"];
$hinhanh = $r["hinh"];
$hoten = $r["hoten"];
$tensp = $r["tensp"];
$gia = $r["gia"];
$gia2 = number_format($gia, 0, '', '.');
$soluong = $r["soluong"];
$ngaydat = ConvertDate_time_db($r["ngaydat"]);
$diachi = $r["diachi"];
$email = $r["email"];
$dt = $r["dienthoai"];
$str_dt = strlen($dt);
if ($str_dt == 9) {
$t = "0" . $dt;
} else {
$t = "" . $dt;
}
?>
<tr height="30">
<td align="center" width="50" style="border-left:1px solid #333;border-right:1px solid #333;border-bottom:1px solid #333;"><strong>
<input type="checkbox" name="chon[]" value="<?php
echo "{$id_hoadon}";
?>
$curpage = $pagecount;
}
//Xác định số phân đoạn của trang
$numseg = $pagecount % $segsize == 0 ? $pagecount / $segsize : (int) ($pagecount / $segsize + 1);
//Xác định phân đoạn hiện hành của trang
$curseg = $curpage % $segsize == 0 ? $curpage / $segsize : (int) ($curpage / $segsize + 1);
$k = ($curpage - 1) * $pagesize;
//******************************** Nội Dung *********************************//
$sql3 = "select * from lienhe order by ngaylienhe DESC limit {$k},{$pagesize}";
$kq3 = mysql_query($sql3);
if (!$kq3) {
echo "";
} else {
while ($r3 = mysql_fetch_array($kq3)) {
$idlh = $r3["id_lienhe"];
$ngaylh = ConvertDate_time_db($r3["ngaylienhe"]);
$hoten = $r3["hoten"];
$diachi = $r3["diachi"];
$email = $r3["email"];
$dt = $r3["dienthoai"];
$fax = $r3["fax"];
$cty = $r3["cty"];
$noidung = $r3["noidung"];
$str_dt = strlen($dt);
if ($str_dt == 9) {
$t = "0" . $dt;
} else {
$t = "" . $dt;
}
$str_fax = strlen($fax);
if ($str_fax == 9) {
$curpage = $pagecount;
}
//Xác định số phân đoạn của trang
$numseg = $pagecount % $segsize == 0 ? $pagecount / $segsize : (int) ($pagecount / $segsize + 1);
//Xác định phân đoạn hiện hành của trang
$curseg = $curpage % $segsize == 0 ? $curpage / $segsize : (int) ($curpage / $segsize + 1);
$k = ($curpage - 1) * $pagesize;
//******************************** Nội Dung ********************************//
$sql3 = "select hoten,ngaydat,sum(tongtien) as tongtien from hoadon where tinhtrang='damua' group by hoten,ngaydat limit {$k},{$pagesize}";
$kq3 = mysql_query($sql3);
if (!$kq3) {
echo "";
} else {
while ($r3 = mysql_fetch_array($kq3)) {
$ngaydat = $r3["ngaydat"];
$day = ConvertDate_time_db($ngaydat);
$user3 = $r3["hoten"];
$tongtien3 = $r3["tongtien"];
$tt3 = number_format($tongtien3, 0, '', '.');
?>
<tr height="30">
<td align="center" width="200" style="border-bottom:1px solid #333; border-left:1px solid #333;border-right:1px solid #333;"><strong><?php
echo "{$day}";
?>
</strong></td>
<td align="center" width="200" style="border-right:1px solid #333; border-bottom:1px solid #333;"><strong><?php
echo "{$user3}";
?>
</strong></td>
<td align="center" width="265" style="border-right:1px solid #333; border-bottom:1px solid #333;"><strong><?php
echo "{$tt3} VND";
