[Phoneorder-commits] SF.net SVN: phoneorder: [44] trunk/src/orderwidget.ui.h

[<hur...@us...>]

Revision: 44
Author:   hurikhan
Date:     2006-05-13 08:12:50 -0700 (Sat, 13 May 2006)
ViewCVS:  http://svn.sourceforge.net/phoneorder/?rev=44&view=rev

Log Message:
-----------
Implemented FS#49: Invoice Numbers

Modified Paths:
--------------
    trunk/src/orderwidget.ui.h
Modified: trunk/src/orderwidget.ui.h
===================================================================
--- trunk/src/orderwidget.ui.h	2006-03-18 00:36:59 UTC (rev 43)
+++ trunk/src/orderwidget.ui.h	2006-05-13 15:12:50 UTC (rev 44)
@@ -17,6 +17,7 @@
 #include <qpaintdevicemetrics.h>
 #include <qsimplerichtext.h>
 #include <qsettings.h>
+#include <qdatetime.h>
 
 #include "mainform.h"
 
@@ -645,6 +646,23 @@
 	double marginTop = settings.readDoubleEntry ("/PrintMarginTop", marginSize);
 	double marginBottom = settings.readDoubleEntry ("/PrintMarginBottom", marginSize);
 
+	QString day = QDate::currentDate ().toString ("yyyyMMdd"); // FS#49
+	int number = 0;
+	QSqlQuery query = QSqlQuery (QString ("SELECT MAX(number) FROM invoices WHERE day = '%1'") .arg (day));
+	if (query.first ())
+	{
+		qDebug ("QSqlQuery( \"%s\" )", query.executedQuery ().ascii ());
+		number = query.value (0).toInt ();
+	}
+	number += 1;
+	query = QSqlQuery (QString ("REPLACE INTO invoices SET number = '%1', day = '%2'") .arg (number) .arg (day));
+	if (query.isActive ())
+		qDebug ("QSqlQuery( \"%s\" )", query.executedQuery ().ascii ());
+	else
+		qFatal ("QSqlQuery( \"%s\" )", query.executedQuery ().ascii ());
+	QString invoiceNumber;
+	invoiceNumber.sprintf ("RN%8s-%04d", day.ascii (), number);
+
 	int fontSize = settings.readNumEntry ("/FontSize", 10);
 	settings.endGroup ();
 
@@ -668,8 +686,8 @@
 			"<table width='100%' cellpadding='0' cellspacing='0'>"
 				"<tr>"
 					"<td rowspan='2' valign='top'>"
+						"<font size='+3'><%custnum%>&nbsp;&nbsp;<%name%></font><br>"
 						"<nobr>"
-							"<font size='+3'><%custnum%>&nbsp;&nbsp;<%name%></font><br>"
 							"<font size='+2'><%street%><br><%city%><br></font>"
 							"Telefon: <%phone%>"
 						"</nobr>"
@@ -694,6 +712,7 @@
 				"<tr>"
 					"<td colspan='2' align='right' valign='bottom'>" // FS#29
 						"<font size='+3'>Rechnung</font><br>"
+						"<nobr><%invoicenumber%></nobr><br>" // FS#49
 						"<nobr><%date%></nobr>"
 					"</td>"
 				"</tr>"
@@ -712,6 +731,7 @@
 	document.replace ("<%companycity%>", companyCity);
 	document.replace ("<%companyphone%>", companyPhone);
 	document.replace ("<%companyfax%>", companyFax);
+	document.replace ("<%invoicenumber%>", invoiceNumber); // FS#49
 
 	if (custNotes->text ().isEmpty ())
 		document.replace ("<%notes%>", QString::null);


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.