/** * 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; }