<?php session_start();

//ini_set('display_errors','1');
mysql_connect('192.168.100.244', 'debxadmin', 'f0V2:c#z9j15') or
//mysql_connect('localhost', 'root', '') or
    die("Could not connect: " . mysql_error());
mysql_select_db("debx");
//mysql_select_db("debtors");

$result = mysql_query("SELECT * FROM manual_transactions WHERE status =1 order by manual_transaction_id ");//m.trading_close_date >= NOW() && 
?>
<h1 style="text-align:center;">Transactions</h1>
<p>Type: 1- Payment by Debtor, 2- Payment by Originator</p>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr class="grays_bg">
  <td>S.No</td>
  <td>Type</td>

   	<td> Debtor ID </td>
    <td> Debtor Name</td>
    <td>Trade ID</td>
    
    <td>Amount</td>
    <td>Date</td>
  </tr>
  

<?php
$i=0;
while ($row = mysql_fetch_assoc($result)) {
	
	$id = explode(",",$row['reference_to']);
	
	if(count($id) >0){
		$values = implode(",",array_filter($id));
	}else{
		$values = 0;	
	}

	$result1 = mysql_query("select trade_reference_id from invoice_master WHERE invoice_id IN (".$values.")");
	$trades = array();
	while ($row1 = mysql_fetch_assoc($result1)) {
			$trades[] = $row1['trade_reference_id'];
	}
	
	$result2 = mysql_query("select debtor_name, debtor_reference_id from debtors_detail WHERE debtor_id IN ('".$row['debtors']."')");
	
	$row2 = mysql_fetch_assoc($result2);
	
	if($i%2 ==0){
		$class="2";	
	}else{
		$class="1";	
	}
	
	$i++;
	echo '<tr class="row'.$class.'">
			<td>'.$i.'</td>
			<td>'.$row['transaction_type'].'</td>
			<td>'.$row2['debtor_reference_id'].'</td>
			<td>'.$row2['debtor_name'].'</td>

			<td>'.implode(", ",$trades).'</td>
			
			<td>'.$row['amount'].'</td>
			<td>'.$row['transaction_date'].'</td>
		  </tr>';

}

?>
</table>
<style>
.row1 td {
    background:#FFFFFF;
}
.row2 td {
    background:#F5F5F5;
}
td{
	font-size: 12px;
    line-height: 18px;
    padding: 3px 10px;
	font-family:Arial, Helvetica, sans-serif;
    border-bottom: 1px solid #E5E5E5;
}
.grays_bg td {
    background:#C0C0C0;
    padding: 5px 10px;
	font-weight:bold;
}
</style>