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