function CapNhat($maThuoc)
{
include "../db.inc";
$loaiThuoc = $_POST['cbLoaiThuoc'];
$cachDung = $_REQUEST['cbCachDung'];
$ngaySX = ChangeFormatDate($_REQUEST['txtNgaySX']);
$ngayHH = ChangeFormatDate($_REQUEST['txtNgayHetHan']);
$tenThuoc = $_REQUEST["txtTenThuoc"];
$gia = $_REQUEST["txtGia"];
$query = "Update Thuoc set TenThuoc='{$tenThuoc}',MaLoaiThuoc={$loaiThuoc},MaCachSD={$cachDung},NgaySX='{$ngaySX}',NgayHetHan='{$ngayHH}',Gia={$gia} " . "where MaThuoc={$maThuoc}";
$result = mysql_query($query, $link);
header('Location:DMThuoc_CapNhat.php?id=' . $maThuoc);
}
function ThemPhieuNhap()
{
include "../../db.inc";
if ($_REQUEST['maphieu'] == 0) {
$ngayNhan = $_REQUEST['ngayNhan'];
$ngayNhan = ChangeFormatDate($ngayNhan);
$query = "insert into PhieuNhapKho(NgayNhap) values('{$ngayNhan}')";
mysql_query($query, $link);
// get current id
$query = "select MaPhieuNhap from PhieuNhapKho order by MaPhieuNhap desc limit 0,1";
$result = mysql_query($query, $link);
$row = mysql_fetch_row($result);
$maPhieuNhap = $row[0];
mysql_close($link);
} else {
$maPhieuNhap = $_REQUEST['maphieu'];
}
return $maPhieuNhap;
}
function KhoangThoiGian($tuNgay, $denNgay)
{
include "../../db.inc";
$tuNgay = ChangeFormatDate($tuNgay);
$denNgay = ChangeFormatDate($denNgay);
$query = "SELECT count(*) as soluongbn,sum((ct.SoLuong * th.Gia)) AS DoanhThu " . " from ChiTietToaThuoc ct,ToaThuoc toa,Thuoc th,LoaiThuoc lt,phieukcb phieu,benhnhan bn " . " where ct.MaToaThuoc=toa.MaToaThuoc and th.MaThuoc=ct.MaThuoc and lt.MaLoaiThuoc=th.MaLoaiThuoc " . " and phieu.maphieukcb=toa.maphieukcb and bn.mabn=phieu.mabn " . " and toa.NgayLap>='{$tuNgay}' and toa.NgayLap<='{$denNgay}' ";
$result = mysql_query($query, $link);
$row = mysql_fetch_array($result, MYSQL_BOTH);
echo "<table>";
echo "<tr>";
echo "<td>Số Lượng Bệnh Nhân</td>";
echo "<td>Doanh Thu</td>";
echo "</tr>";
echo "<tr>";
echo "<td>" . $row['soluongbn'] . "</td>";
echo "<td>" . $row['DoanhThu'] . "</td>";
echo "</tr>";
echo "</table>";
}
<?php
include "../utility.php";
$tuNgay = ChangeFormatDate($_REQUEST['tuNgay']);
$denNgay = ChangeFormatDate($_REQUEST['denNgay']);
ThongKe($tuNgay, $denNgay);
function ThongKe($tuNgay, $denNgay)
{
include "../../db.inc";
$query = "SELECT th.TenThuoc, lt.TenLoaiThuoc, ct.SoLuong, th.Gia, toa.NgayLap,(ct.SoLuong * th.Gia) AS Tong " . " from ChiTietToaThuoc ct,ToaThuoc toa,Thuoc th,LoaiThuoc lt " . " where ct.MaToaThuoc=toa.MaToaThuoc and th.MaThuoc=ct.MaThuoc and lt.MaLoaiThuoc=th.MaLoaiThuoc " . " and toa.NgayLap>='{$tuNgay}' and toa.NgayLap<='{$denNgay}' " . " order by toa.NgayLap asc ";
$result = mysql_query($query, $link);
echo "<table width=\"100%\" >";
echo "<tr style=\"font-weight:bold;\" >";
echo "<td>Tên Thuốc</td>";
echo "<td>Loại Thuốc</td>";
echo "<td>Số Lượng</td>";
echo "<td>Ngày Bán</td>";
echo "<td align='right'>Giá</td>";
echo "<td align='right'>Tổng</td>";
echo "</tr>";
$tong = 0;
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
echo "<tr>";
echo "<td>" . $row["TenThuoc"] . "</td>";
echo "<td>" . $row["TenLoaiThuoc"] . "</td>";
echo "<td>" . $row["SoLuong"] . "</td>";
echo "<td>" . $row["NgayLap"] . "</td>";
echo "<td align='right'>" . $row["Gia"] . "</td>";
echo "<td align='right'>" . $row["Tong"] . "</td>";
$tong += $row["Tong"];
echo "</tr>";
