public function indexAction()
{
$daugia = $this->view->info = App_Models_DaugiaModel::getInstance();
$idpage = $_SESSION['idpage'];
$ShowAllPhienDauKetThuc = $daugia->ShowAllPhienDauKetThuc($idpage);
$this->view->ShowAllPhienDauKetThuc = $ShowAllPhienDauKetThuc;
}
public function capnhatphiendauAction()
{
$daugia = App_Models_DaugiaModel::getInstance();
$idPD = @$_POST["idpd"];
$tenPD = @$_POST["tenpd"];
$idSP = @$_POST["idsp"];
$GiaBan = @$_POST["giaban"];
$GiaKhoiDiem = @$_POST["giakhoidiem"];
$BuocGia = @$_POST["buocgia"];
$NgayBatDau = @$_POST["ngaybatdau"];
$GioBatDau = @$_POST["giobatdau"];
$PhutBatDau = @$_POST["phutbatdau"];
$NgayKetThuc = @$_POST["ngayketthuc"];
$GioKetThuc = @$_POST["gioketthuc"];
$PhutKetThuc = @$_POST["phutketthuc"];
$ThoiGianBatDau = $daugia->GomThoiGian($NgayBatDau, $GioBatDau, $PhutBatDau, '00');
$ThoiGianKetThuc = $daugia->GomThoiGian($NgayKetThuc, $GioKetThuc, $PhutKetThuc, '59');
$sql = "Update ishali_bid_phiendau Set ";
$sql .= "idsp = '" . $idSP . "', ";
$sql .= "tenpd = '" . $tenPD . "', ";
$sql .= "giaban = '" . $GiaBan . "', ";
$sql .= "giakhoidiem = '" . $GiaKhoiDiem . "', ";
$sql .= "buocgia = '" . $BuocGia . "', ";
$sql .= "tgbatdau = '" . $ThoiGianBatDau . "', ";
$sql .= "tgketthuc = '" . $ThoiGianKetThuc . "' ";
$sql .= "Where idpd = '" . $idPD . "'";
$data = $daugia->InsertDeleteUpdateQuery($sql);
if ($data == 1) {
echo "<script>ThongBaoDongY('Lưu Thành Công.', taaa.appdomain+'/admin/phiendauchinhsua?st=1&idpd={$idPD}');</script>";
} else {
echo "<script>ThongBaoDongY('Lưu không thành công<br/>Vui Lòng thực hiện lại thao tác.', taaa.appdomain+'/admin/phiendauchinhsua?st=1&idpd={$idPD}');</script>";
}
}
public function taophiendauAction()
{
$this->_helper->viewRenderer->setNoRender(true);
$this->_helper->layout->disableLayout();
$daugia = App_Models_DaugiaModel::getInstance();
echo 'Tao phien dau';
}
public function xulytaophiendaugiaAction()
{
$daugia = App_Models_DaugiaModel::getInstance();
$idpage = $_SESSION['idpage'];
$tenPD = @$_POST["tenpd"];
$idSP = @$_POST["idsp"];
$GiaBan = @$_POST["giaban"];
$GiaKhoiDiem = @$_POST["giakhoidiem"];
$BuocGia = @$_POST["buocgia"];
$NgayBatDau = @$_POST["ngaybatdau"];
$GioBatDau = @$_POST["giobatdau"];
$PhutBatDau = @$_POST["phutbatdau"];
$NgayKetThuc = @$_POST["ngayketthuc"];
$GioKetThuc = @$_POST["gioketthuc"];
$PhutKetThuc = @$_POST["phutketthuc"];
$ThoiGianBatDau = $daugia->GomThoiGian($NgayBatDau, $GioBatDau, $PhutBatDau, '00');
$ThoiGianKetThuc = $daugia->GomThoiGian($NgayKetThuc, $GioKetThuc, $PhutKetThuc, '59');
$sql = "Insert into ishali_bid_phiendau ";
$sql .= "(idsp, tenpd, giaban, giakhoidiem, buocgia, tgbatdau, tgketthuc, idpage) Values (";
$sql .= "'" . $idSP . "', ";
$sql .= "'" . $tenPD . "', ";
$sql .= "'" . $GiaBan . "', ";
$sql .= "'" . $GiaKhoiDiem . "', ";
$sql .= "'" . $BuocGia . "', ";
$sql .= "'" . $ThoiGianBatDau . "', ";
$sql .= "'" . $ThoiGianKetThuc . "', ";
$sql .= "'" . $idpage . "') ";
$kq = $daugia->InsertDeleteUpdateQuery($sql);
//header("Location: ../taophiendaugia?result=1");
if ($kq == 1) {
echo "<script>ThongBaoDongY('Lưu Thành Công.', taaa.appdomain+'/admin/taophiendaugia');</script>";
} else {
echo "<script>ThongBaoDongY('Lưu không thành công<br/>Vui Lòng thực hiện lại thao tác.', taaa.appdomain+'/admin/taophiendaugia');</script>";
}
}
public function indexAction()
{
$this->_helper->viewRenderer->setNoRender(true);
$this->_helper->layout->disableLayout();
$daugia = App_Models_DaugiaModel::getInstance();
$data = $daugia->GetInfoUserByIdUserFB('100002151254254');
print_r($data);
}
public static function getInstance()
{
if (self::$_instance == NULL) {
self::$_instance = new App_Models_DaugiaModel();
self::$_instance->_db = App_Storage_Mysql_Connector::getInstance();
}
return self::$_instance;
}
public function xoaphiendaucuAction()
{
$this->_helper->viewRenderer->setNoRender(true);
$this->_helper->layout->disableLayout();
$daugia = App_Models_DaugiaModel::getInstance();
$idpd = $_GET["idpd"];
$sql = "Delete from ishali_bid_phiendau where idpd = '" . $idpd . "'";
$daugia->ThucThiTruyVan($sql);
header("Location: ../phiendauketthuc?result=3");
}
public function xoanguoidauAction()
{
$this->_helper->viewRenderer->setNoRender(true);
$this->_helper->layout->disableLayout();
$daugia = App_Models_DaugiaModel::getInstance();
$idDG = @$_GET["iddg"];
$idPD = @$_GET["idpd"];
$sql = "Delete from ishali_bid_daugia where iddg = '" . $idDG . "'";
$daugia->ThucThiTruyVan($sql);
header("Location: ../quanlydaugia?result=3&idpd=" . $idPD);
}
public function deleteAction()
{
$this->_helper->viewRenderer->setNoRender(true);
$this->_helper->layout->disableLayout();
$daugia = App_Models_DaugiaModel::getInstance();
$idUser = @$_GET["iduser"];
$sql = "Delete from ishali_bid_user where iduser = '******'";
$user = $daugia->ThucThiTruyVan($sql);
$this->view->user = $user;
header("Location: ../user?result=3");
}
public function indexAction()
{
$daugia = $this->view->info = App_Models_DaugiaModel::getInstance();
$idpage = $_SESSION['idpage'];
$sql = "Select baiviet from ishali_bid_baiviet where idbv = 1 and idpage = '" . $idpage . "'";
$data = $daugia->ThucThiTruyVan($sql);
if (count($data) > 0) {
$this->view->dieule = $data[0]["baiviet"];
} else {
$this->view->dieule = "";
}
}
public function indexAction()
{
if (!isset($this->_SESSION->iduseradmin)) {
$link = APP_DOMAIN . '/admin/loginadmin';
header("Location:{$link}");
}
$daugia = App_Models_DaugiaModel::getInstance();
$idSP = @$_GET["idsp"];
$sql = "Select * from ishali_bid_sanpham where idsp = " . $idSP;
$data = $daugia->ThucThiTruyVan($sql);
$this->view->sanphamchitiet = $data;
}
public function indexAction()
{
$idpage = $_SESSION['idpage'];
$idPD = $_GET["idPD"];
$daugia = App_Models_DaugiaModel::getInstance();
$ShowPhienDau = $daugia->ShowPhienDau($idPD);
$NguoiDauCaoNhat = $daugia->NguoiDauCaoNhat($idPD);
$this->view->ShowPhienDau = $ShowPhienDau;
$this->view->NguoiDauCaoNhat = $NguoiDauCaoNhat;
//print_r($ShowPhienDau);
//'2013-06-08 20:00:00';
$datebd = $ShowPhienDau[0]['tgbatdau'];
$datekt = $ShowPhienDau[0]['tgketthuc'];
$data = $daugia->KhoangGiay($datebd, $datekt);
$TimeCountDown = $daugia->DoiGiayRaNgay($data['khoanggiay']);
$this->view->TimeCountDown = $TimeCountDown;
$this->view->LoaiPhienDau = $data['flag'];
$sql = "select donvitien, thongtinsp, menuthongtinsp, link_page from ishali_config where idpage = '" . $idpage . "'";
$data = $daugia->SelectQuery($sql);
//Thay doi don vi tien
if ($data[0]['donvitien'] == "") {
$donvitien = "VNĐ";
} else {
$donvitien = $data[0]['donvitien'];
}
$this->view->donvitien = $donvitien;
//Link Page de gan vao Plugin Like
if ($data[0]['link_page'] != "") {
$this->view->link_page = $data[0]['link_page'];
} else {
$this->view->link_page = 'http://www.facebook.com/AgencySocialMediaMarketing';
}
//KT xem co tuy chon mo tab menu thong tin san pham
if ($data[0]['thongtinsp'] == 1) {
$menu = $data[0]['menuthongtinsp'];
$list_menu = explode(";", $menu);
$this->view->list_menu = $list_menu;
for ($i = 0; $i < count($list_menu); $i++) {
$idsp = $ShowPhienDau[0]['idsp'];
$sql = "select noidung from ishali_thongtinsp where idsp = '" . $idsp . "' and keytab = '" . ($i + 1) . "'";
$data = $daugia->SelectQuery($sql);
if (count($data) > 0) {
$noidung[$i] = $data[0]['noidung'];
} else {
$noidung[$i] = "";
}
}
$this->view->noidung = $noidung;
} else {
$this->view->list_menu = "";
}
}
public function xulyloginAction()
{
$this->_helper->viewRenderer->setNoRender(true);
$this->_helper->layout->disableLayout();
$daugia = App_Models_DaugiaModel::getInstance();
$UserAdmin = $_POST["useradmin"];
$PasswordAdmin = sha1($_POST["passadmin"]);
$sql = "Select iduser, hoten From ishali_bid_useradmin where useradmin = '" . $UserAdmin . "' and password = '******'";
$data = $daugia->ThucThiTruyVan($sql);
$this->_SESSION->iduseradmin = $data[0]["iduser"];
$this->_SESSION->hotenadmin = $data[0]["hoten"];
echo count($data);
}
public function xoasanphamAction()
{
$this->_helper->viewRenderer->setNoRender(true);
$this->_helper->layout->disableLayout();
$daugia = App_Models_DaugiaModel::getInstance();
$idSP = $_GET["idsp"];
$sql = "Select urlhinh from ishali_bid_sanpham where idsp = '" . $idSP . "'";
$data = $daugia->ThucThiTruyVan($sql);
$UrlHinh = $data[0]["urlhinh"];
$UrlHinh2 = APPLICATION_PATH . "/layouts/tmpdaugia/images/upload/images/" . $UrlHinh;
if (file_exists($UrlHinh2)) {
unlink($UrlHinh2);
}
$sql = "Delete from ishali_bid_sanpham where idsp = '" . $idSP . "'";
$daugia->ThucThiTruyVan($sql);
header("Location: ../sanphamdaugia?result=3");
}
public function preDispatch()
{
$facebook = new Ishali_Facebook();
$daugia = App_Models_DaugiaModel::getInstance();
$config = Zend_Registry::get(APPLICATION_CONFIG);
if ($facebook->getpageid() != "") {
$idpage = $facebook->getpageid();
$_SESSION['idpage'] = $idpage;
}
$userFB = $facebook->getuserfbid();
if ($userFB == 0) {
$infoPage = $daugia->thongTinTrang($idpage);
$linkPage = $infoPage[0]['link_page'];
$appId = $config->facebook->appid;
$linkPageApp = $linkPage . '/app_' . $appId;
$facebook->userlogin($linkPageApp);
}
}
public function chinhsuagioithieuAction()
{
$daugia = App_Models_DaugiaModel::getInstance();
$idpage = $_SESSION['idpage'];
$Gioithieu = @$_POST["gioithieu"];
$sql = "Select 1 from ishali_bid_baiviet where idbv = 3 and idpage = '" . $idpage . "'";
$data = $daugia->SelectQuery($sql);
if (count($data) > 0) {
$sql = "Update ishali_bid_baiviet Set baiviet = '{$Gioithieu}' Where idbv = 3 and idpage = '" . $idpage . "'";
} else {
$sql = "Insert into ishali_bid_baiviet(idbv, baiviet, idpage) value ('3', '" . $Gioithieu . "', '" . $idpage . "')";
}
//echo $sql;
$data = $daugia->InsertDeleteUpdateQuery($sql);
if ($data == 1) {
echo "<script>ThongBaoDongY('Lưu Thành Công.', taaa.appdomain+'/admin/gioithieu');</script>";
} else {
echo "<script>ThongBaoDongY('Lưu không thành công<br/>Vui Lòng thực hiện lại thao tác.', taaa.appdomain+'/admin/gioithieu');</script>";
}
}
public function indexAction()
{
$facebook = new Ishali_Facebook();
if ($facebook->getParameterUrl() != null) {
$idPD = $facebook->getParameterUrl();
$host = APP_DOMAIN;
header("location: {$host}/product?idPD={$idPD}");
}
$idpage = $_SESSION['idpage'];
$daugia = $this->view->info = App_Models_DaugiaModel::getInstance();
$ShowAllPhienDau = $daugia->ShowAllPhienDau($idpage);
$this->view->ShowAllPhienDau = $ShowAllPhienDau;
$sql = "Select baiviet From ishali_bid_baiviet where idbv = 4 and idpage = '" . $idpage . "'";
$data = $daugia->ThucThiTruyVan($sql);
if (count($data) > 0) {
$this->view->tinthongbao = $data[0]["baiviet"];
} else {
$this->view->tinthongbao = "";
}
}
public function chinhsuasanphamAction()
{
$daugia = App_Models_DaugiaModel::getInstance();
$idSP = $_POST["idsp"];
$TenSP = $_POST["tensp"];
$GiaBan = $_POST["giaban"];
$TitleFB = @$_POST["titlefb"];
$MetaFB = @$_POST["metafb"];
$file = @$_FILES["uploadhinhanh"];
if ($file["name"] != "") {
$UrlHinh = @$file['name'];
$UrlHinh2 = APPLICATION_PATH . "/layouts/tmpdaugia/images/upload/images/" . $UrlHinh;
move_uploaded_file($file['tmp_name'], $UrlHinh2);
$sql = "Update ishali_bid_sanpham Set ";
$sql .= "tensp = '" . $TenSP . "', ";
$sql .= "gia = '" . $GiaBan . "', ";
$sql .= "urlhinh = '" . $UrlHinh . "', ";
$sql .= "titlechiase = '" . $TitleFB . "', ";
$sql .= "motachiase = '" . $MetaFB . "' ";
$sql .= "Where idsp = '" . $idSP . "'";
$sqlha = "Select urlhinh from ishali_bid_sanpham where idsp = '" . $idSP . "'";
$ha = $daugia->ThucThiTruyVan($sqlha);
$UrlHinhOld = APPLICATION_PATH . "/layouts/tmpdaugia/images/upload/images/" . $ha[0]["urlhinh"];
if (file_exists($UrlHinhOld)) {
unlink($UrlHinhOld);
}
} else {
$sql = "Update ishali_bid_sanpham Set ";
$sql .= "tensp = '" . $TenSP . "', ";
$sql .= "gia = '" . $GiaBan . "', ";
$sql .= "titlechiase = '" . $TitleFB . "', ";
$sql .= "motachiase = '" . $MetaFB . "' ";
$sql .= "Where idsp = '" . $idSP . "'";
}
$data = $daugia->InsertDeleteUpdateQuery($sql);
if ($data == 1) {
echo "<script>ThongBaoDongY('Lưu Thành Công.', taaa.appdomain+'/admin/sanphamdaugia');</script>";
} else {
echo "<script>ThongBaoDongY('Lưu không thành công<br/>Vui Lòng thực hiện lại thao tác.', taaa.appdomain+'/admin/sanphamdaugia');</script>";
}
}
public function installpageAction()
{
//$store = $this->view->info = App_Models_StoreModel::getInstance();
$bid = $this->view->info = App_Models_DaugiaModel::getInstance();
$pageid = $_GET['pageid'];
$pagename = $_GET['pagename'];
$userid = $_GET['userid'];
$appid = $_GET['appid'];
$status = $_GET['status'];
$facebook = new Ishali_Facebook();
$linkpage = $facebook->getLinkPage($pageid);
if ($status == 1) {
$sql = "Select 1 from ishali_pages where id_fb_page = '" . $pageid . "' and id_fb = '" . $userid . "'";
$data = $bid->SelectQuery($sql);
if (count($data) > 0) {
echo "<script>ThongBaoDongY('Fanpage <u>{$pagename}</u><br/>Đã được cài thành công vào ứng dụng.', '" . ROOT_DOMAIN . "/admin');</script>";
} else {
$link = "http://www.facebook.com/add.php?api_key={$appid}&pages=1&page={$pageid}";
echo "<script>customerLoadWindow('{$link}', '', '540', '400');</script>";
$sql = "Insert into ishali_pages(id_fb_page, page_name, id_fb, link_page, templates) value(";
$sql .= "'" . $pageid . "', ";
$sql .= "'" . $pagename . "', ";
$sql .= "'" . $userid . "', ";
$sql .= "'" . $linkpage . "', ";
$sql .= "'tmpdaugia') ";
$data = $bid->InsertDeleteUpdateQuery($sql);
if ($data == 1) {
echo "<script>ThongBaoDongY('Sau khi cài ứng dụng lên FanPage thành công,<br/>Hãy nhấn nút Đóng', '" . ROOT_DOMAIN . "/admin');</script>";
} else {
echo "<script>ThongBaoDongY('Cài ứng dụng không thành công<br/>Vui Lòng thực hiện lại thao tác.', '" . ROOT_DOMAIN . "/admin');</script>";
}
}
} else {
$link = "http://www.facebook.com/add.php?api_key={$appid}&pages=1&page={$pageid}";
echo "<script>customerLoadWindow('{$link}', '', '540', '400');</script>";
echo "<script>ThongBaoDongY('Sau khi cài ứng dụng lên FanPage thành công,<br/>Hãy nhấn nút Đóng', '" . ROOT_DOMAIN . "/admin');</script>";
}
}
public function thongtinsanphamxulyAction()
{
$daugia = $this->view->info = App_Models_DaugiaModel::getInstance();
$idsp = $_POST['idsp'];
$keytab = $_POST['keytab'];
$noidung = $_POST['noidung'];
$sql = "Select 1 from ishali_thongtinsp where idsp = '" . $idsp . "' and keytab = '" . $keytab . "'";
$data = $daugia->SelectQuery($sql);
if (count($data) == 0) {
$sql = "Insert into ishali_thongtinsp(idsp, keytab, noidung) value(";
$sql .= "'" . $idsp . "', '" . $keytab . "', '" . $noidung . "') ";
} else {
$sql = "Update ishali_thongtinsp set ";
$sql .= "noidung = N'" . $noidung . "' ";
$sql .= "where idsp = '" . $idsp . "' and keytab = '" . $keytab . "'";
}
$data = $daugia->InsertDeleteUpdateQuery($sql);
if ($data == 1) {
echo "<script>ThongBaoDongY('Lưu Thành Công.', '" . ROOT_DOMAIN . "/admin/thongtinsanpham?idsp=" . $idsp . "&keytab=" . $keytab . "');</script>";
} else {
echo "<script>ThongBaoDongY('Lưu không thành công<br/>Vui Lòng thực hiện lại thao tác.', '" . ROOT_DOMAIN . "/admin/thongtinsanpham?idsp=" . $idsp . "&keytab=" . $keytab . "');</script>";
}
}
public function indexAction()
{
$daugia = App_Models_DaugiaModel::getInstance();
if (!isset($this->_SESSION->iduseradmin)) {
$link = APP_DOMAIN . '/admin/loginadmin';
header("Location:{$link}");
}
$_SESSION['list_page'] = 1;
if ($this->_request->getParam("idpage") != "") {
$idpagee = $this->_request->getParam("idpage");
$_SESSION['idpage'] = $idpagee;
}
@($idpage = $_SESSION['idpage']);
$checkSessionIdpage = $daugia->KiemTraSessionIdPage($idpage);
if ($checkSessionIdpage == 0) {
$this->view->checkSessionIdpage = $checkSessionIdpage;
} else {
$sql = "Select * From ishali_bid_user where idpage = '" . $idpage . "' order by iduser desc";
$user = $daugia->ThucThiTruyVan($sql);
$this->view->user = $user;
$this->view->checkSessionIdpage = $checkSessionIdpage;
}
}
public function xulyconfigAction()
{
$daugia = $this->view->info = App_Models_DaugiaModel::getInstance();
$idpage = $_SESSION['idpage'];
$banner = "";
@($file = $_FILES['banner']);
if ($file['name'] != "") {
$banner = time() . '_' . $file['name'];
move_uploaded_file($file['tmp_name'], 'public/images/banner/' . $banner);
}
$footer = $_POST['footer'];
$donvitien = $_POST['donvitien'];
$linkpage = $_POST['linkpage'];
if (@$_POST['thongtinsp'] != "") {
$thongtinsp = @$_POST['thongtinsp'];
} else {
$thongtinsp = 0;
}
$menuthongtinsp = $_POST['menuthongtinsp'];
if ($menuthongtinsp == "") {
$thongtinsp = 0;
}
$sql = "Select 1 from ishali_config where idpage = '" . $idpage . "'";
$data = $daugia->SelectQuery($sql);
if (count($data) == 0) {
if ($banner == "") {
$sql = "insert into ishali_config(idpage, footer, donvitien, thongtinsp, menuthongtinsp, link_page) ";
$sql .= "value('{$idpage}', '{$footer}', '{$donvitien}', '{$thongtinsp}', '{$menuthongtinsp}', '{$linkpage}')";
} else {
$sql = "insert into ishali_config(idpage, banner, footer, donvitien, thongtinsp, menuthongtinsp, link_page) ";
$sql .= "value('{$idpage}', '{$banner}', '{$footer}', '{$donvitien}', '{$thongtinsp}', '{$menuthongtinsp}', '{$linkpage}')";
}
} else {
if ($banner == "") {
$sql = "Update ishali_config set ";
$sql .= "footer = '" . $footer . "', ";
$sql .= "donvitien = '" . $donvitien . "', ";
$sql .= "thongtinsp = '" . $thongtinsp . "', ";
$sql .= "menuthongtinsp = '" . $menuthongtinsp . "', ";
$sql .= "link_page = '" . $linkpage . "' ";
$sql .= "where idpage = '" . $idpage . "'";
} else {
$sql = "Select banner from ishali_config where idpage = '" . $idpage . "'";
$bn = $daugia->SelectQuery($sql);
if ($bn[0]['banner'] != "") {
$banner_old = $bn[0]['banner'];
if (file_exists('public/images/banner/' . $banner_old)) {
unlink('public/images/banner/' . $banner_old);
}
}
$sql = "Update ishali_config set ";
$sql .= "banner = '" . $banner . "', ";
$sql .= "footer = '" . $footer . "', ";
$sql .= "donvitien = '" . $donvitien . "', ";
$sql .= "thongtinsp = '" . $thongtinsp . "', ";
$sql .= "menuthongtinsp = '" . $menuthongtinsp . "', ";
$sql .= "link_page = '" . $linkpage . "' ";
$sql .= "where idpage = '" . $idpage . "'";
}
}
//echo $sql;
$config = $daugia->InsertDeleteUpdateQuery($sql);
if ($config == 1) {
echo "<script>ThongBaoDongY('Lưu Thành Công.', taaa.appdomain+'/admin/config');</script>";
} else {
echo "<script>ThongBaoDongY('Lưu không thành công<br/>Vui Lòng thực hiện lại thao tác.', taaa.appdomain+'/admin/config');</script>";
}
}
public function thaydoimatkhauAction()
{
$this->_helper->viewRenderer->setNoRender(true);
$this->_helper->layout->disableLayout();
$daugia = App_Models_DaugiaModel::getInstance();
$iduserfb = $_POST['iduserfb'];
$oldpass = sha1($_POST['oldpass']);
$newpass = sha1($_POST['newpass']);
$idpage = $_SESSION['idpage'];
$sql = "Select 1 from ishali_bid_user where iduserFB = '" . $iduserfb . "' and `password` = '" . $oldpass . "' and idpage ='" . $idpage . "'";
$data = $daugia->ThucThiTruyVan($sql);
if (count($data) > 0) {
$sql = "Update ishali_bid_user set `password` = '" . $newpass . "' where iduserFB = '" . $iduserfb . "'";
$data = $daugia->ThucThiTruyVan($sql);
echo 1;
} else {
echo 0;
}
}
