<?php session_start();


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  
		
		org.organisation_limit AS  limits, org.organisation_risk AS risks,
		
		m.*, 
		d.debtor_name as dname, d.trade_name as tname,
		d.debtor_reference_id, dm.debtor_master_id, dm.debtor_name,dm.debtor_risk,dm.debtor_limit,dm.nace_id as d_nace_id,dm.nace_group_id as d_nace_group_id,
		t.doj, 
		org.nace_id as t_nace_id,org.nace_group_id as t_nace_group_id, 
		DATE(m.expected_date) as expected_date ,
		DATE( m.trading_close_date) AS trading_close_date, 
		 
		org.organisation_name , org.organisation_reference_id , org.organisation_risk, org.organisation_limit, org.organisation_jurisdiction, 
		c.country_name , (select min_advance from invoice_bidding where invoice_id = m.invoice_id order by min_advance desc limit 1) as bid_min_case , (select max_thirty_reserve from invoice_bidding where invoice_id = m.invoice_id order by max_thirty_reserve asc limit 1) as bid_max_case
	 
		
		FROM 
		`temp_registration` as t, `organisation_details` as org, `debtor_relation` as r, `debtors_detail` as d , 
		`invoice_master` as m , address_details as a , country_mas as c , debtors_master as dm
		WHERE   m.invoice_id = m.invoice_id && m.draft = 0  && 
		d.debtor_id = m.debtor_id && r.debtor_id = d.debtor_id && dm.debtor_master_id = d.parent_id && org.organisation_id =  r.organisation_id &&
		t.user_id = m.user_id && m.root_invoice_id =0 &&  
		a.address_id = t.organization_address_id && c.country_id = a.address_country   
		group by m.invoice_id");//m.trading_close_date >= NOW() && 
?>

<h1 style="text-align:center;">RSA Trades</h1>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr class="grays_bg">
  <td>S.No</td>
   <td>Originator ID</td>
   	<td> Debtor ID </td>
    <td> Debtor Name</td>
    <td>Master Debtor NAME</td>
    <td>RSA ID</td>
    
    <!--<td>Face Value</td>
    <td>Sales Type</td>
    <td>Expected</td>
    <td>Closed Date</td>
    <td>Trade Approved Date</td>-->
  </tr>
  

<?php
$i=0;
while ($row = mysql_fetch_assoc($result)) {
	
	if($row['sales_type'] =="1"){
		$sales_type ='O';
	}else if($row['sales_type'] =="2"){
		$sales_type ='M';
	}else{
		$sales_type ='P';
	}
	if($i%2 ==0){
		$class="2";	
	}else{
		$class="1";	
	}
	
	if($row['tname'] !=''){
		
		$row['dname'] = '<b>'.$row['tname'].'</b> - '.$row['dname'];
	}else{
		$row['dname'] = '<b>'.$row['dname'].'</b>' ;
	}
	
	if($row['debtor_trade_name'] !=''){
		
		$row['debtor_name'] = '<b>'.$row['debtor_trade_name'].'</b> - '.$row['debtor_name'];
	}
	
	$i++;
	echo '<tr class="row'.$class.'">
			<td>'.$i.'</td>
			<td>'.$row['organisation_reference_id'].'</td>
			<td>'.$row['debtor_reference_id'].'</td>
			
			<td>'.$row['dname'].'</td>
			<td>'.$row['debtor_name'].'</td>
			<td>'.$row['trade_reference_id'].'</td>
			
			<!--<td>'.$row['face_value'].'</td>
			<td>RSA</td>
			<td>'.$row['expected_date'].'</td>
			<td>'.$row['trading_close_date'].'</td>
			<td>'.$row['actual_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>