File: /www/exchange2/exchange/trade_approved.php
<?php session_start();
$conn = mysql_connect('192.168.100.244', 'debxadmin', 'f0V2:c#z9j15') or
//mysql_connect('localhost', 'root', '') or
die("Could not connect: " . mysql_error());
mysql_set_charset('utf8',$conn);
mysql_select_db("debx",$conn);
//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_trade_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_limit, cc.currency_symbol
FROM
`temp_registration` as t, `organisation_details` as org, `debtor_relation` as r, `debtors_detail` as d ,
`invoice_master` as m , debtors_master as dm, currencies as cc
WHERE m.invoice_id = m.invoice_id && m.draft = 0 && m.root_invoice_id > 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 && m.invoice_status = 1 && m.log_status = 1 &&
t.user_id = m.user_id && cc.currency_id = d.currency_id
group by m.invoice_id");//m.trading_close_date >= NOW() &&
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<h1 style="text-align:center;">Trade All Approved</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>Invoice Ref.</td>
<td>Trade 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'];
}
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['invoice_no'].'</td>
<td>'.$row['trade_reference_id'].'</td>
<td>'.$row['currency_symbol'].number_format($row['face_value'],2,'.',',').'</td>
<td>ETR</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>
</body>
</html>