<br><br><div class="gmail_quote">On Thu, Jun 17, 2010 at 9:15 PM, Klaas Freitag <span dir="ltr"><<a href="mailto:freitag@kde.org">freitag@kde.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi Mukesh,<br>
<div class="im">><br>
> I have written some initial code of the Database class which will handle<br>
> all Sqlite database related operations for the alkimia Dbus service.<br>
> The initial code contains methods for inserting and updating a record in<br>
> the database.<br>
</div>Great. Does that mean that we do not use Akonadi now but a Sqlite DB?<br>
<div class="im"><br>
> Now i need a help regarding the possible query methods.The available fields<br>
> are transaction id,source application name,memo,amount,status and date.<br>
</div>Please also add a "ident number" or "document id" which is important for<br>
identifying invoices for example. Also you probably want to add the currency.<br>
<br>
What we discussed on the sprint was also that the amount could be split up<br>
to a net amount and a list of tax amounts, but I am not really sure about<br>
that. Maybe Thomas can help.<br>
<br>
For invoices we also wanted to store a DueDate to implement scheduling of<br>
payment reminders.<br>
<div class="im"><br>
> Also tell me what are the other methods that could become a part of the<br>
> code.<br>
</div>AFAIR we were mentioning the following methods as part as the interface<br>
that your code should offer to the applications via DBUS:<br>
<br>
registerTransactions: general method to register transactions<br>
<br>
registerInvoice: high level method to register a sent out invoice<br>
registerExpense: register expense<br>
registerPayment: register incoming payment<br>
<br>
basically all these methods take the parameters listed above.<br></blockquote><div><br>What would be the difference between all these methods from the storage point of view.<br>Do we need to add any other fields(apart from ident number) or the current fields will do. ?<br>
Can you please elaborate a little about how each method .<br> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
What I do not know is how we realise the list of valid transactions for<br>
the registerTransactions method. Are we all ok to maintain a list of<br>
transactions in Alkimia?<br>
<br>
For queries, I can think of these query interface methods:<br>
<br>
to get all bookings against a specific transaction or a list of:<br>
queryTransaction( transactionID )<br>
queryTransactions( TransactionList )<br>
<br>
to query bookings within a timeframe:<br>
queryTransactionBookings( fromDate, toDate )<br>
queryExpenses( fromDate, toDate )<br>
queryPayments( fromDate, toDate )<br>
<br>
and some high level methods like<br>
queryExpectedPayments<br>
queryPaymentStatus( document identifier )<br></blockquote><div><br> How do we return the result of each query. a list of records ?</div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
Just a few ideas, I am sure the others have more ideas,<br>
<br>
Klaas<br>
_______________________________________________<br>
Kde-finance-apps mailing list<br>
<a href="mailto:Kde-finance-apps@kde.org">Kde-finance-apps@kde.org</a><br>
<a href="https://mail.kde.org/mailman/listinfo/kde-finance-apps" target="_blank">https://mail.kde.org/mailman/listinfo/kde-finance-apps</a><br>
</blockquote></div><br>