<?php

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 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;
}

echo odeme_list();
?>