<?php

if($yetki->musteri_yonetimi != 1){
header('refresh: 0; url='.$site.'yetkisiz-erisim');
die();
}

$_title = 'Müşteri Yönetimi';

checkDemoMode($demo);


if($_POST){

if(!isset($_POST['sms_izin'])){ $_POST['sms_izin'] = 0 ;} else { $_POST['sms_izin'] = $_POST['sms_izin']; }
if(!isset($_POST['eposta_izin'])){ $_POST['eposta_izin'] = 0; } else { $_POST['eposta_izin'] = $_POST['eposta_izin']; }

if(isset($_GET['duzenle'])){
$islem = $db->prepare("UPDATE musteriler SET musteri_adi = ?, musteri_tipi = ?, musteri_adres = ?, musteri_telefon = ?, musteri_mail = ?, sms_izin = ?, eposta_izin = ? WHERE id = ? LIMIT 1");
$islem = $islem->execute(array($_POST['musteri_adi'],$_POST['musteri_tipi'],$_POST['musteri_adres'], $_POST['musteri_telefon'],$_POST['musteri_mail'],$_POST['sms_izin'], $_POST['eposta_izin'], $_GET['duzenle']));
}else{
$islem = $db->prepare("INSERT INTO musteriler SET musteri_adi = ?, musteri_tipi = ?, musteri_adres = ?, musteri_telefon = ?, musteri_mail = ?, kayit_tarihi = ?, sms_izin = ?, eposta_izin = ? ");
$islem = $islem->execute(array($_POST['musteri_adi'],$_POST['musteri_tipi'],$_POST['musteri_adres'], $_POST['musteri_telefon'],$_POST['musteri_mail'],time(),$_POST['sms_izin'], $_POST['eposta_izin']));
}

echo $islem ? basari() : hata();
}

if(isset($_GET['duzenle'])){
$getir = $db->query("SELECT * FROM musteriler WHERE id = '{$_GET['duzenle']}' LIMIT 1")->fetch(PDO::FETCH_ASSOC);
}


if(isset($_GET['sil'])){
$db->exec("DELETE FROM musteriler WHERE id = '{$_GET['sil']}' LIMIT 1");
}
?>

<div class="col-md-7 mt-3">
<div class="card box-shadow-0">
<div class="card-header">
<h4 class="card-title mb-1">Ekleme ve Güncelleme Formu</h4>
<p class="mb-2">Bu sayfada yeni veri ekleyebilir, güncelleyebilir veya silebilirsiniz.</p>
</div>
<div class="card-body pt-0">
<div class="table-responsive">
<table class="table table-bordered border text-nowrap mb-0" id="myTable">
<thead>
<tr>
<th>İşlemler</th>
<th>Müşteri Ad Soyad</th>
<th>Müşteri Tipi</th>
<th>Müşteri Telefon</th>
<th>Müşteri E-Posta</th>
<th>Müşteri Adres</th>
</tr>
</thead>
<tbody>
<?php
$query = $db->query("SELECT * FROM musteriler ORDER BY id DESC", PDO::FETCH_ASSOC);
if($query->rowCount()){
foreach($query as $row){

$tip = ($row['musteri_tipi']== 1 ) ? 'Potansiyel' : 'Gerçek';
echo '
<tr>
<td style="width: 100px">
<div class="btn-list">
<a href="'.$sayfa.'/duzenle/'.$row['id'].'?tip='.$row['musteri_tipi'].'" class="btn btn-sm btn-primary">
<span class="fe fe-edit"></span>
</a>
<button data-sil="'.$sayfa.'/sil/'.$row['id'].'" class="btn btn-sm btn-danger">
<span class="fe fe-trash-2"></span>
</button>
</div>
</td>
<td>'.$row['musteri_adi'].'</td>
<td>'.$tip.'</td>
<td>'.$row['musteri_telefon'].'</td>
<td>'.$row['musteri_mail'].'</td>
<td>'.$row['musteri_adres'].'</td>

</tr>
';
}
}else{
echo '<tr><td colspan="3">'.veri_yok().'</td></tr>';
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>

<div class="col-md-5 mt-3">
<div class="card box-shadow-0">
<div class="card-header">
<h4 class="card-title mb-1">Müşteri Ekleme ve Güncelleme Formu</h4>
</div>
<div class="card-body pt-0">
<form action="" method="post">
<div class="table-responsive">
<table class="form-table table table-bordered mg-b-0 text-md-nowrap">
<tr>
<th colspan="1">
<span>Müşteri Ad Soyad</span>
<input type="text" name="musteri_adi" class="form-control" value="<?php echo @$getir['musteri_adi']; ?>" placeholder="Müşteri Ad Soyad" required>
</th>
<th colspan="1">
<span>Müşteri Tipi</span>
<select name="musteri_tipi" class="form-control">
<option value="2" <?php if($_GET['tip'] == 2){ echo 'selected'; } ?>>Gerçek</option>
<option value="1" <?php if($_GET['tip'] == 1){ echo 'selected'; } ?>>Potansiyel</option>

</select>
</th>
</tr>
<tr>
<th colspan="1">
<span>Müşteri Telefon</span>
<input type="text" name="musteri_telefon" class="form-control" value="<?php echo @$getir['musteri_telefon']; ?>" placeholder="Müşteri Telefon">
</th>
<th colspan="1">
<span>Müşteri E-Posta</span>
<input type="email" name="musteri_mail" class="form-control" value="<?php echo @$getir['musteri_mail']; ?>" placeholder="Müşteri E-Posta">
</th>
</tr>
<tr>
<th colspan="2">
<span>Müşteri Adres</span>
<input type="text" name="musteri_adres" class="form-control" value="<?php echo @$getir['musteri_adres']; ?>" placeholder="Müşteri Adres" >
</th>
</tr>
<tr>
<th colspan="2">
<div class="checkbox m-r-10">
<label>
<input name="sms_izin" type="checkbox" value="1" <?php if($getir['sms_izin']==1){ echo "checked"; } ?> > SMS Gönderilebilir
</label> &nbsp;&nbsp;
<label>
<input name="eposta_izin" type="checkbox" value="1" <?php if($getir['eposta_izin']==1){ echo "checked"; } ?> > E-Posta Gönderilebilir
</label>
</div>
</th>
</tr>
</table>
<div class="form-group mb-0 mt-3">
<center>
<button type="submit" class="btn btn-success-gradient" style="width: 150px;">Kaydet</button>
</center>
</div>
</div>
</form>

</div>
</div>
</div>