[Vtigercrm-developers] extra functionality for invoices

[J.P.C. Spiekman]

Hello,

I don't know if this is the right way to send you my contribution for future
releases vtiger, but i hope that someone who is 'responsible' for the
releases can pick it up and implement/use it in future releases.

first, the change request.
- I needed a way to generate invoice numbers in a way that every year a
counter starts at zero, and every new invoice has an ascending invoice ID,
without gaps. eg; 20070001, 20070002, 20070003, 20070004, and so on.

I have implemented this on the following way, using the subject field in
Invoice.

//Append in EditView.php after line 40 ($rate = $rate_symbol['rate'];)

$invoice_number = getInvoiceNumber();
$focus->column_fields['subject'] = $invoice_number;

//Place the function below in CommonUtils.php:
 
// Extra function to create unique invoice_number
function getInvoiceNumber() {
	global $adb;
	$sql="select max(subject) as aantal from vtiger_invoice where
Year(invoicedate) = year(now())";
	$result = $adb->query($sql);
  $invoice_subject=  $adb->query_result($result,0,"aantal");
// strip off year from invoice_number/subject
   $invoice_subject = substr($invoice_subject,4,4);
// raise last invoice_number of invoice with 1
	$invoice_count = $invoice_subject + 1;
	$invoice_count = str_repeat("0",4-strlen($invoice_count)).$invoice_count;
	$invoice_year = date("Y");
	$invoice_number= $invoice_year.$invoice_count;
	return $invoice_number;
}



Best Regards,

Pieter

________________________________________________
Message sent using UebiMiau 2.7.10