Invoices
All
Search options
DATE RANGE
From Date
To Date
Cancel
QUICK DATES
Today: =$today_date?>
Yesterday: =$Yesterday_date?>
Last 7 days
Last 30 days
This month: =$This_monthname?>
Last month: =$Last_monthname?>
This quarter: (=$This_monthname?>,=$This_quter_monthname2?>,=$This_quter_monthname3?>)
Last quarter: (=$Last_quter_monthname3?>,=$Last_quter_monthname2?>,=$Last_monthname?>)
All time
+ New
Download GSTR1
' >
Download GST-3B
' >
Inv No.
Inv date
Due Date
Client
Amount
Balance
Status
Mail Sent
Options
for($i=0;$i<$rowcount;$i++) { $memberinvoicesid = $sqllist[$i]['memberinvoicesid']; $companyid = $sqllist[$i]['billed_membercompanyid']; $billing_membercompanyid = $sqllist[$i]['billing_membercompanyid']; $statusdata = $sqllist[$i]['status']; $invoiceno = $sqllist[$i]['invoiceno']; $InvoiceTotalAmount = $sqllist[$i]['InvoiceTotalAmount']; $invoicedate = date("j M Y",strtotime($sqllist[$i]['invoicedate'])); //date("M jS, Y", strtotime("2011-01-05")); $duedate = date("j M Y",strtotime($sqllist[$i]['duedate'])); $billed_membername = $sqllist[$i]['billed_membername']; $TotalAmount = $sqllist[$i]['TotalAmount']; //total payment by that invoice id $approved = $sqllist[$i]['approved']; //Invoice approve status $is_mail_send = $sqllist[$i]['is_mail_send']; $balance1 = $InvoiceTotalAmount - $TotalAmount; $paid_total_amount = $sqllist[$i]['paid_total_amount']; if($paid_total_amount == '0') { $balance1 = $InvoiceTotalAmount - $TotalAmount; } else { $balance1 = $InvoiceTotalAmount - $paid_total_amount; } $todays = (date("d-m-Y")) ; $approvelink =''; $editlink =''; $InvoiceNo =''; $client =''; if($balance1 == '0') { $status = '
Paid
'; //payment status } elseif($balance1 > '0' && strtotime($duedate) > strtotime($todays)) { $status = '
Pending
'; //payment status } elseif($balance1 > '0' && $paid_total_amount > '0' && strtotime($duedate) <= strtotime($todays)) { $status = '
Partially Paid
'; //payment status } elseif($balance1 > '0' && strtotime($duedate) <= strtotime($todays)) { $status = '
Overdue
'; //payment status } if($approved == '1') { $invoice_approvestatus = '
Approved
'; } else { $invoice_approvestatus = ' '; } if($is_mail_send == '1') { $mailsend = '
Yes
'; } else{ $mailsend = '
No
'; } if($approved == '0' && $balance1 != '0') { $editlink="
Edit
"; $invoice_approvelink ='
Approve
'; } else { $editlink =" "; $invoice_approvelink =''; } if($balance1 == '0') { $paymentlink = ''; } else { $paymentlink = "
ADD Payment
"; } if($balance1 == '0'){ $InvoiceNo="
".$invoiceno."
"; $client="
".$billed_membername."
"; } else{ $InvoiceNo="
".$invoiceno."
"; $client="
".$billed_membername."
"; } ?>
=$InvoiceNo?>
=$invoicedate?>
=$duedate?>
=$client?>
=format_number($InvoiceTotalAmount)?>
=format_number($balance1)?>
=$status?>
=$mailsend?>
View
=$editlink?>
Delete
=$paymentlink?> =$invoice_approvelink?>
Send Invoice mail
} ?>
for($i=0;$i<$rowcount;$i++) { $memberinvoicesid = $sqllist[$i]['memberinvoicesid']; $companyid = $sqllist[$i]['billed_membercompanyid']; $head_Email = $sqllist[$i]['head_Email']; ?>
Email this Invoice
×
To
=$head_Email?>
cc
} ?>