function MusteriDoktorGunGoster($tarih, $id)
{
$musteriList = array();
try {
$sutunlar = "id,musteriAd,musteriSoyad,email,tel,randevuTarihi,mesaj,saat_id,doktor_id,randevuOnay";
$baglanti = new VeriTabaniBaglanti();
$conn = $baglanti->pdo_baglanti();
$tarihSorgu = $conn->query("select {$sutunlar} from musteri where randevuTarihi='{$tarih}' and doktor_id={$id} and CURDATE()<=randevuTarihi ");
$rows = $tarihSorgu->fetchAll(PDO::FETCH_CLASS);
foreach ($rows as $row) {
$musteri = new Musteri();
$musteri->setMusteriId($row->id);
$musteri->setAd($row->musteriAd);
$musteri->setSoyad($row->musteriSoyad);
$musteri->setEmail($row->email);
$musteri->setTel($row->tel);
$musteri->setRandevuTarihi($row->randevuTarihi);
$musteri->setSaatId($row->saat_id);
$musteri->setMesaj($row->mesaj);
$musteri->setDoktorId($row->doktor_id);
array_push($musteriList, $musteri);
}
} catch (Exception $ex) {
die($ex->getMessage());
} finally {
if ($conn != null) {
$conn = $baglanti->pdo_sonlandir();
}
}
return $musteriList;
}
function DoktorMusteri(Doktor $doktor)
{
$id = $doktor->getDoktorId();
$musteriList = array();
try {
$baglanti = new VeriTabaniBaglanti();
$conn = $baglanti->pdo_baglanti();
$sorgu = $conn->query("Select *from musteri where doktor_id={$id} and randevuOnay=1");
$rows = $sorgu->fetchAll(PDO::FETCH_CLASS);
foreach ($rows as $row) {
$musteri = new Musteri();
$musteri->setAd($row->musteriAd);
$musteri->setSoyad($row->musteriSoyad);
$musteri->setRandevuTarihi($row->randevuTarihi);
$musteri->setSaatId($row->saat_id);
$musteri->setEmail($row->email);
$musteri->setTel($row->tel);
array_push($musteriList, $musteri);
}
} catch (Exception $ex) {
die($ex->getMessage());
} finally {
if ($conn != null) {
$conn = $baglanti->pdo_sonlandir();
}
}
return $musteriList;
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Doktor Müşteri</title>
<?php
$bootstrap = new Bootstrap();
$bootstrap->controller_vb();
?>
</head>
<body>
<?php
if ($_POST) {
$header = new Header();
$header->kokSayfa_header();
$musteri = new Musteri();
$musteri->setAd(trim($_POST['ad']));
$musteri->setSoyad(trim($_POST['soyad']));
$musteri->setEmail(trim($_POST['email']));
$musteri->setTel(trim($_POST['tel']));
$musteri->setRandevuTarihi(trim($_POST['randevuTarihi']));
$musteri->setSaatId(trim($_POST['saat']));
$musteri->setMesaj($_POST['mesaj']);
$musteridao = new MusteriDAO();
$musteridao->musteriEkle($musteri);
}
?>
</body>
</html>