<?php

  $sql = "select * from tb_number where acc_id='$acc_id' and num_type='d' and num_clear='No'"; 
  $Query = mysqli_query($link,$sql);
  $num_rows = mysqli_num_rows($Query);
    
  $count = 0;
  $sum_n2 = 0;

  if($num_rows){

?>
<i><b>ประเภทเลขใบ</b></i><hr>
  <table class="table table-bordered">
    <thead>
      <tr>
        <th><center>ลำดับ</th>
        <th><center>ตัวเลข</th>
        <th><center>เลขบน</th>
        <th><center>เลขล่าง</th>
        <th><center>วันที่ซื้อ</th>
        <th><center>ผลรางวัล</th>
        <th><center>คิดเป็นเงิน</th>
      </tr>
    </thead>
    <tbody>

	<?php

  // ตารางรวมเลข 3 ตัว

  $payment_status = "ไม่มีข้อมูล";

	while($Result = mysqli_fetch_array($Query)){
	$num_id = $Result['num_id'];
	$num_buy = $Result['num_buy'];
	$num_one = $Result['num_one'];
	$num_two = $Result['num_two'];
  $num_type = $Result['num_type'];
  $num_payment = $Result['num_payment'];
  $num_clear = $Result['num_clear'];
	$num_created = $Result['num_created'];

  $n1 = "-";
  $n2 = "-";

  if($num_payment == 'No'){
    $payment_status = "<a href='payment_save.php?id=$acc_id&type=d&status=pay' class='btn btn-danger btn-xs'><span class='glyphicon glyphicon-usd'></span> ยังไม่ชำระเงิน</a>

    <a href='payment_save.php?id=$acc_id&type=d&status=next' class='btn btn-warning btn-xs'><span class='glyphicon glyphicon-remove'></span> ข้าม</a>
    ";
  }
  elseif($num_payment == 'Yes'){
    $payment_status = "<a href='payment_save.php?id=$acc_id&type=d&status=unpay' class='btn btn-success btn-xs'><span class='glyphicon glyphicon-usd'></span> ชำระเงินแล้ว</a>";
  }
  elseif($num_payment == 'Next'){
    $payment_status = "<a href='payment_save.php?id=$acc_id&type=d&status=unpay' class='btn btn-warning btn-xs'><span class='glyphicon glyphicon-remove'></span> ข้ามแล้ว</a>";
  }


  if($num_one != 0){

  $count = $count+1;

  if($def_info == 'On'){
    
    if($awa_n6 == $num_buy){
      $n1 = "ถูกรางวัล";
      $n2 = ($num_one*$rate4)-($num_one*12);
      $sum_n2 = $n2+$sum_n2;
      $n2 = number_format($n2);
      $n2 = "<font color='green'>$n2</font>";

    }
    else{
      $n1 = "ไม่ถูกรางวัล";
      $n2 = -($num_one*12);
      $sum_n2 = $n2+$sum_n2;
      $n2 = number_format($n2);
      $n2 = "<font color='red'>$n2</font>";
    }

  }
  else{

  }

    echo"<tr>
        <td align='center'>$count</td>
        <td align='center'>$num_buy</td>
        <td align='center'>$num_one</td>
        <td align='center'>-</td>
        <td align='center'>$num_created</td>
        <td align='center'>$n1</td>
        <td align='center'>$n2</td>
      </tr>";

  }

  if($num_two != 0){

  $count = $count+1;

  if($def_info == 'On'){
    
    if($awa_2 == $num_buy){
      $n1 = "ถูกรางวัล";
      $n2 = ($num_two*$rate4)-($num_two*12);
      $sum_n2 = $n2+$sum_n2;
      $n2 = number_format($n2);
      $n2 = "<font color='green'>$n2</font>";

    }
    else{
      $n1 = "ไม่ถูกรางวัล";
      $n2 = -($num_two*12);
      $sum_n2 = $n2+$sum_n2;
      $n2 = number_format($n2);
      $n2 = "<font color='red'>$n2</font>";
    }

  }

    echo"<tr>
        <td align='center'>$count</td>
        <td align='center'>$num_buy</td>
        <td align='center'>-</td>
        <td align='center'>$num_two</td>
        <td align='center'>$num_created</td>
        <td align='center'>$n1</td>
        <td align='center'>$n2</td>
      </tr>";

  }

  if( $num_one == 0 && $num_two == 0 && $num_buy != 0){

    $count = $count+1;

    echo"<tr>
        <td align='center' bgcolor='#ff6666'>$count</td>
        <td align='center' bgcolor='#ff6666'>$num_buy</td>
        <td align='center' bgcolor='#ff6666'>-</td>
        <td align='center' bgcolor='#ff6666'>-</td>
        <td align='center' bgcolor='#ff6666'>$num_created</td>
        <td align='center' bgcolor='#ff6666'>-</td>
        <td align='center' bgcolor='#ff6666'>-</td>
      </tr>";

  }

	}

  $sum_n2 = number_format($sum_n2);

  echo"<tr>
        <td align='center'></td>
        <td align='center'></td>
        <td align='center'></td>
        <td align='center'></td>
        <td align='center'>$payment_status</td>
        <td align='center'><b>ยอดรวม</b></td>
        <td align='center'><b>$sum_n2</b></td>
      </tr>";

    } // if $num_rows

	?>

    </tbody>
  </table>