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 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 indexAction() { $daugia = $this->view->info = App_Models_DaugiaModel::getInstance(); $idpage = $_SESSION['idpage']; $ShowAllPhienDauKetThuc = $daugia->ShowAllPhienDauKetThuc($idpage); $this->view->ShowAllPhienDauKetThuc = $ShowAllPhienDauKetThuc; }
public function taophiendauAction() { $this->_helper->viewRenderer->setNoRender(true); $this->_helper->layout->disableLayout(); $daugia = App_Models_DaugiaModel::getInstance(); echo 'Tao phien dau'; }
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 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 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; } }
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>"; } }