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