for($i=0;$i<$rowcount_invoice;$i++)
{
$memberinvoicesid = $sql_invoice_list[$i]['memberinvoicesid'];
$companyid = $sql_invoice_list[$i]['billed_membercompanyid'];
$billing_membercompanyid = $sql_invoice_list[$i]['billing_membercompanyid'];
$statusdata = $sql_invoice_list[$i]['status'];
$invoiceno = $sql_invoice_list[$i]['invoiceno'];
$InvoiceTotalAmount = $sql_invoice_list[$i]['InvoiceTotalAmount'];
$invoicedate = date("d-m-Y",strtotime($sql_invoice_list[$i]['invoicedate']));
$duedate = date("d-m-Y",strtotime($sql_invoice_list[$i]['duedate']));
$billed_membername = $sql_invoice_list[$i]['billed_membername'];
$TotalAmount = $sql_invoice_list[$i]['TotalAmount'];
$balance = $InvoiceTotalAmount - $TotalAmount;
$todays = (date("d-m-Y")) ;
if($balance == '0')
{
$status = 'Paid';
}
elseif($balance > '0' && strtotime($duedate) > strtotime($todays))
{
$status = 'Pending';
}
elseif($balance > '0' && strtotime($duedate) <= strtotime($todays))
{
$status = 'Overdue';
}
?>
=$status?> |
=$invoicedate?> |
=$invoiceno?> |
=$billed_membername?> |
Rs.=format_number($InvoiceTotalAmount)?> |
Rs.=format_number($balance)?> |
} ?>