<?php

function countOrder(){
global $db;
$sql=$db->execute(prepare("SELECT * FROM o_talepleri WHERE durum = '0' ORDER BY id DESC"));
$sql->fetchColumn();
return $sql;
}

function odeme_list(){

global $db;

$sql=$db->prepare("SELECT * FROM o_talepleri ORDER BY id DESC");
$sql->execute();
$tr_list =NULL;
while($row=$sql->fetch(PDO::FETCH_ASSOC)){

$kat_id = $row['badi'];

$cat = $db->query("SELECT * FROM kategoriler WHERE id='{$kat_id}'")->fetch(PDO::FETCH_ASSOC);



if ($row['durum']=='0') {
$status = '<span class="badge badge-warning">Bekliyor</span>';
$btn = '
<button class="btn btn-danger btn-sm" type="button" role="payment" role-status="ret" role-id="'.$row['id'].'">Ret</button>
<button class="btn btn-success btn-sm" type="button" role="payment" role-status="success" role-id="'.$row['id'].'">Onayla</button>
';
} elseif ($row['durum']=='1') {
$status = '<span class="badge badge-success">Onaylandı</span>';
$btn = '';
}elseif ($row['durum']=='2') {
$status = '<span class="badge badge-danger">Onaylanmadı</span> <a rel="nofollow" href="sebep?detay='.$row['id'].'" class="badge badge-blue"><i class="fas fa-plus"></i> Sebep Ekle</a>';
$btn = '';
}





$tr_list.=
'
<tr>
<td>'.$row['id'].'</td>
<td>'.$row['gadi'].'</td>
<td>'.$cat['ismi'].'</td>
<td>'.$status.'</td>
<td>'.$btn.'</td>
</tr>
';
}

$warning = $db->query("SELECT SUM(gadi) AS gtutar FROM o_talepleri WHERE durum='0'")->fetch(PDO::FETCH_ASSOC);
$success = $db->query("SELECT SUM(gadi) AS gtutar FROM o_talepleri WHERE durum='1'")->fetch(PDO::FETCH_ASSOC);
$danger = $db->query("SELECT SUM(gadi) AS gtutar FROM o_talepleri WHERE durum='2'")->fetch(PDO::FETCH_ASSOC);

$temp=
'




<div class="row">
<div class="col-sm-12">
<div class="card shadow mb-3">
<div class="card-body" style="padding: 0;">
<div class="table-responsive">
<table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
<thead>
<tr>
<th scope="col">#</th>
<th scope="col">Kullanıcı Adı</th>
<th scope="col">Kategori Adı</th>
<th scope="col">Durum</th>
<th scope="col">İşlem</th>
</tr>
</thead>
<tbody>
'.$tr_list.'
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
';
return$temp;
}
if (!empty($_POST)){
echo countOrder();
} else {
echo odeme_list();
}
?>