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
Invoice No.
Invoice date
Due Date
Client
Amount
Balance
Status
Email Status
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 } if($approved == '1') { $invoice_approvestatus = '
Approved
'; } else { $invoice_approvestatus = ' '; } if($is_mail_send == '1') { $mailsend = '
E-Mail Sent
'; } else{ $mailsend = '
E-Mail not Sent
'; } 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?>
Rs. =$InvoiceTotalAmount?>
Rs. =$balance1?>
=$status?>
=$mailsend?>
Options
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
You can add multiple email id's seperated by comma
} ?>