public static function ThemDoiTuong($tenDoiTuong)
{
$result = TRUE;
$identity = 0;
try {
if (!ConnectDB::OpenConnection()) {
throw new Exception("Không thể kết nối với cơ sở dữ liệu.\n", $code);
return FALSE;
}
//$strSQL =sprintf("CALL spThemDoiTuong('%s')", $tenDoiTuong);
//$result = mysql_query($strSQL, ConnectDB::$mLink);
$strSQL = "insert into doi_tuong(`MaDoiTuong`, `TenDoiTuong`) values ('','{$tenDoiTuong}')";
//echo $strSQL;
$result = mysql_query($strSQL, ConnectDB::$mLink);
$identity = mysql_insert_id();
ConnectDB::CloseConnection();
} catch (Exception $e) {
$result = FALSE;
}
if ($strSQL) {
return $identity;
// trả về dòng đối tượng vừa được insert vào
} else {
$result = false;
return $result;
// nếu thực thi hok được thì trả về false
}
}
public static function CapNhatLoaiSP($tenLoaiSP, $maLoaiSP)
{
$result = true;
ConnectDB::OpenConnection();
try {
if (!ConnectDB::OpenConnection()) {
return false;
}
$strSQL = "UPDATE `loai_san_pham` SET `TenLoaiSP`= '{$tenLoaiSP}'\r\n\t\t\t\t\t\tWHERE `MaLoaiSP` = {$maLoaiSP} ";
$result = mysql_query($strSQL, ConnectDB::$mLink);
ConnectDB::CloseConnection();
} catch (Exception $e) {
$result = false;
}
return $result;
}
public static function LayDSLoaiNguoiDung()
{
$lstLoaiNguoiDung = array();
try {
if (!ConnectDB::OpenConnection()) {
return null;
}
$strSql = "SELECT * FROM `loai_nguoi_dung`;";
$result = mysql_query($strSql, ConnectDB::$mLink);
if ($result == false) {
return null;
}
while ($row = mysql_fetch_array($result)) {
$LoaiNDDto = new LoaiNguoiDungDTO();
$LoaiNDDto->MaLoaiND = $row["MaLoaiND"];
$LoaiNDDto->LoaiNguoiDung = $row["LoaiNguoiDung"];
array_push($lstLoaiNguoiDung, $LoaiNDDto);
}
ConnectDB::CloseConnection();
} catch (Exception $e) {
$lstLoaiNguoiDung = null;
}
return $lstLoaiNguoiDung;
}
/**
* Lấy ds sự kiện trong khoảng thời gian
* Edit by Thu Hà 20/6/2011
*/
public static function LayDanhSachSuKienTrongKhoangThoiGian($thoiGianBD, $thoiGianKT)
{
$lstSuKien = array();
try {
if (!ConnectDB::OpenConnection()) {
return false;
}
$strSQL = "SELECT * FROM su_kien \r\n\t\t\t\t\t\tWHERE DATEDIFF(su_kien.NgayBatDau,{$thoiGianBD})<=0 \r\n\t\t\t\t\t\tand DATEDIFF(su_kien.NgayKetThuc,{$thoiGianKT}) >=0\r\n\t\t\t\t\t\tAND su_kien.DaXoa = 0;";
$result = mysql_query($strSQL, ConnectDB::$mLink);
if (!$result) {
return null;
}
while ($row = mysql_fetch_array($result)) {
$suKienDto = new SuKienDTO();
$suKienDto->MaSuKien = $row["MaSuKien"];
$suKienDto->MaGianHang = $row["MaGianHang"];
$suKienDto->TenSuKien = $row["TenSuKien"];
$suKienDto->HinhAnh = $row["HinhAnh"];
$suKienDto->NoiDungSuKien = $row["NoiDungSuKien"];
$suKienDto->NgayTao = $row["NgayTao"];
$suKienDto->NgayBatDau = $row["NgayBatDau"];
$suKienDto->NgayKetThuc = $row["NgayKetThuc"];
$suKienDto->NgayCapNhat = $row["NgayCapNhat"];
$suKienDto->NguoiCapNhat = $row["NguoiCapNhat"];
$suKienDto->NgayXoa = $row["NgayXoa"];
$suKienDto->NguoiXoa = $row["NguoiXoa"];
$suKienDto->DaXoa = $row["DaXoa"];
array_push($lstSuKien, $sanPhamDto);
}
ConnectDB::CloseConnection();
} catch (Exception $e) {
$lstSuKien = null;
}
return $lstSuKien;
}
public static function TinhSoSaoTBCuaMotDoiTuong($maDoiTuong)
{
$soSaoTB = 0;
try {
if (!ConnectDB::OpenConnection()) {
return false;
}
$strSQL = "select * from Likes where MaDoiTuong = {$maDoiTuong};";
$result = mysql_query($strSQL, ConnectDB::$mLink);
if (!$result || mysql_num_rows($result) <= 0) {
return 0;
}
$numRow = mysql_num_rows($result);
$tongSoSao = 0;
while ($row = mysql_fetch_array($result)) {
$tongSoSao = $tongSoSao + $row["SoSao"];
}
ConnectDB::CloseConnection();
$soSaoTB = $tongSoSao / $numRow;
} catch (Exception $e) {
$soSaoTB = 0;
}
return $soSaoTB;
}
/**
* Xóa gian hàng
* Edit by Thu Hà 20/11/2011
*/
public static function XoaGianHang($maGianHang, $maNguoiDung)
{
$result = true;
try {
if (!ConnectDB::OpenConnection()) {
return FALSE;
}
$strSQL = "\tUPDATE `gian_hang` \r\n\t\t\t\t\t\tSET `DaXoa` = 1, `NguoiXoa` = {$maNguoiDung}, `NgayXoa` = now()\r\n\t\t\t\t\t\tWHERE `MaGianHang` = {$maGianHang};";
$result = mysql_query($strSQL, ConnectDB::$mLink);
ConnectDB::CloseConnection();
} catch (Exception $e) {
$result = FALSE;
}
return $result;
}
/**
* Lấy bình luận theo mã bình luận
* Edit Ngọc Hà 16/6/2011
* Edit by Thu Hà 20/6/2011: nếu không tồn tại thì trả về null
*/
public static function LayBinhLuanTheoMaBL($maBL)
{
$binhLuanDto = new BinhLuanDAO();
try {
if (!ConnectDB::OpenConnection()) {
return false;
}
$strSQL = "select * from binh_luan bl where bl.MaBL = {$maBL};";
$result = mysql_query($strSQL, ConnectDB::$mLink);
if ($result == false || mysql_num_rows($result) != 1) {
return null;
}
$row = mysql_fetch_array($result);
$binhLuanDto->MaBL = $row["MaBL"];
$binhLuanDto->NoiDungBL = $row["NoiDungBL"];
$binhLuanDto->NguoiBL = $row["NguoiBL"];
$binhLuanDto->NgayBL = $row["NgayBL"];
$binhLuanDto->DaXoa = $row["DaXoa"];
$binhLuanDto->NgayXoa = $row["NgayXoa"];
$binhLuanDto->NguoiXoa = $row["NguoiXoa"];
$binhLuanDto->DoiTuongBL = $row["DoiTuongBL"];
ConnectDB::CloseConnection();
} catch (Exception $e) {
$binhLuanDto = null;
}
return $binhLuanDto;
}
public static function KiemTraDangNhap($tenTaiKhoan, $matKhau)
{
$res = false;
try {
if (!ConnectDB::OpenConnection()) {
return false;
}
$strSQL = "select * from `nguoi_dung` where `UserName` = '{$tenTaiKhoan}' AND `MatKhau` = '{$matKhau}'";
//echo $strSQL;
$result = mysql_query($strSQL, ConnectDB::$mLink);
if (!$result || mysql_num_rows($result) <= 0) {
$res = false;
}
if (mysql_num_rows($result) == 1) {
$res = true;
}
ConnectDB::CloseConnection();
} catch (Exception $e) {
$res = false;
}
return $res;
}
/**
* Lấy ds DDH của một gian hàng, sắp theo thứ tự thời gian giảm dần
* tùy chọn $trangThai: 1-chờ xử lý, 2-đã liên hệ, 3-đã hoàn tất, 4-hủy, 0- lấy tất cả
* Thu Hà 20/6/2011
*/
public static function LayDSDDHTheoMaDDH_TrangThai($maGianHang, $trangThai)
{
$dsDDH = true;
try {
if (!ConnectDB::OpenConnection()) {
return false;
}
$strSql = "SELECT * FROM `don_dat_hang` \r\n\t\t\t\t\t WHERE `MaGianHang`= {$maGianHang}";
if ($trangThai == 0) {
$strSql = ";";
} else {
$strSql = "AND TrangThai = {$trangThai};";
}
$result = mysql_query($strSql, ConnectDB::$mLink);
if (!$result) {
return null;
}
while ($row = mysql_fetch_array($result)) {
$donDatHangDto = new DonDatHangDTO();
$donDatHangDto->MaDDH = $row["MaDDH"];
$donDatHangDto->MaGianHang = $row["MaGianHang"];
$donDatHangDto->MaNguoiDung = $row["MaNguoiDung"];
$donDatHangDto->TrangThai = $row["TrangThai"];
$donDatHangDto->GhiChu = $row["GhiChu"];
$donDatHangDto->NgayDat = $row["NgayDat"];
$donDatHangDto->NgayHuy = $row["NgayHuy"];
array_push($dsDDH, $donDatHangDto);
}
ConnectDB::CloseConnection();
} catch (Exception $e) {
$dsDDH = null;
}
return $dsDDH;
}
/**
* Lấy DS Chi Tiết Sự Kiện Theo Mã Sản Phẩm
*/
public static function LayDSChiTietSuKien_TheoMaSP($maSanPham)
{
$dsSuKien = array();
try {
if (!ConnectDB::OpenConnection()) {
return false;
}
$strSQL = "SELECT * FROM chi_tiet_su_kien WHERE Ma = {$maSanPham};";
$result = mysql_query($strSQL, ConnectDB::$mLink);
if ($result == false) {
return null;
}
while ($row = mysql_fetch_array($result)) {
$chiTietSuKienDto = new ChiTietSuKienDTO();
$chiTietSuKienDto->MaSuKien = $row["MaSuKien"];
$chiTietSuKienDto->Ma = $row["Ma"];
$chiTietSuKienDto->PhanTram_GiaGiam = $row["PhanTramGiamGia"];
$chiTietSuKienDto->QuaTang = $row["QuaTang"];
array_push($dsSuKien, $chiTietSuKienDto);
}
ConnectDB::CloseConnection();
} catch (Exception $e) {
$dsSuKien = null;
}
return $dsSuKien;
}
public static function TinhTongSotienTheoMaDDH($maDDH)
{
$sum = 0;
try {
if (!ConnectDB::OpenConnection()) {
return false;
}
$strSql = "SELECT SUM(`ThanhTien`) as TongSoTien FROM `chi_tiet_dat_hang` WHERE `MaDDH` = {$maDDH};";
$result = mysql_query($strSql, ConnectDB::$mLink);
if (!$result || mysql_num_rows($result) != 1) {
return 0;
}
$row = mysql_fetch_array($result);
$sum = $row["TongSoTien"];
ConnectDB::CloseConnection();
} catch (Exception $e) {
$sum = 0;
}
return $sum;
}
/**
* Ngọc Hà 12/6/2011
* Lấy danh mã gian hàng của sản phẩm
* Enter description here ...
*/
public static function LayMaGianHangCuaSanPham($maSanPham)
{
$res = 0;
ConnectDB::OpenConnection();
try {
if (!ConnectDB::OpenConnection()) {
return;
} else {
$strSQL = "\tSELECT lsp.MaGianHang\r\n\t\t\t\t\t\t\tFROM san_pham sp, loai_san_pham lsp\r\n\t\t\t\t\t\t\tWHERE sp.Ma = {$maSanPham} AND sp.MaLoaiSP = lsp.MaLoaiSP and sp.DaXoa = 0;";
$result = mysql_query($strSQL);
$row = mysql_fetch_array($result);
$res = $row["MaGianHang"];
if (!$result) {
$res = 0;
}
}
ConnectDB::CloseConnection();
} catch (Exception $e) {
$res = 0;
}
return $res;
}
