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";