/**
* Generates a sequential number for our invoices by getting the most recent invoice number in the database and adding 1 to it
* @return string
*/
public function generateInvNumber()
{
$dbConn = new DBConnection();
$i = new dbHandler($dbConn, 'inv_details');
$iNumber = $i->getResultsWhere('order by number DESC LIMIT 0, 1 ');
$pecahInv = explode("/", $iNumber[0]->number);
$thsekarang = date('Y');
$thInv = $pecahInv[3];
// Get current invoice number so we can add one to it.
// Do we have an invoice number to add 1 to? If not we are going to start at 0001
if (isset($iNumber[0]->number) != null or $thsekarang != $thInv) {
// Add one to the invoice number if exists
$newNumber = $pecahInv[0] + 1;
} else {
$newNumber = '1';
}
return $newNumber;
}
