search

cchow32 / LHF-Tracking-System

0 stars 0 forks source link

Add Project - Installment entries not saved correctly #27

Open cchow32 opened 11 years ago

cchow32 commented 11 years ago

Information entered in Actual Installment Date, Actual Amount and Remark fields are not being saved to the database correctly. I entered the information as such:

image

but after saving, the information appears as such:

image

If it press save again, the actual amount entries are modified as well! (To match the est. amount entry on that row)

image

cchow32 commented 11 years ago

The "Actual Installment" entries also got inputted into the "Actual Report Date" fields on the reports tab, which should not happen.

image

jasonpolaris commented 11 years ago

First of all, let me explain the installment saving method.

Actually in the old (original) design, there is no matching on which est. installment => map to => which actual installment. Only number of payment and when is that payment is paid. If you need the mapping, database structure must have to be redo and also, seqno must have to added to the DB table design. However, you might not be able insert the payment seq in the middle in this design. Please let me know if you really need this mapping and this take extra time.

For other two problem it should be fixed, please close it or comment. Thanks.

jasonpolaris commented 11 years ago

Comment field is added for installment. Please check. Thanks.

cchow32 commented 11 years ago

Apologies Jason. Have checked this issue but posted the update in another github issue. I have verified the addition of the remark column for estimated installments. Are estimated and actual installments linked now? Please provide more details explaining the database table structure and how entries in related columns are handled.

In addition the sorting is still not correct. The system sorts correctly by estimated installment date first, but when estimated installment dates are the same, it should further sort alphabetically based on estimated remark and this is not functioning.

image

jasonpolaris commented 11 years ago

Clifford,

Not linked row as mentioned before. Link row is a major amendment and complete redesign, not discussed before. Sorting will be fixed tonight.

Jason.

On Tue, Aug 6, 2013 at 5:23 PM, cchow32 notifications@github.com wrote:

Apologies Jason. Have checked this issue but posted the update in another github issue. I have verified the addition of the remark column for estimated installments. Are estimated and actual installments linked now? Please provide more details explaining the database table structure and how entries in related columns are handled.

In addition the sorting is still not correct. The system sorts correctly by estimated installment date first, but when estimated installment dates are the same, it should further sort alphabetically based on estimated remark and this is not functioning.

[image: image]https://f.cloud.github.com/assets/4972536/915770/0abf92a2-fe78-11e2-9dc8-f6f3e08eb94c.png

— Reply to this email directly or view it on GitHubhttps://github.com/cchow32/LHF-Tracking-System/issues/27#issuecomment-22167191 .

cchow32 commented 11 years ago

OK noted that estimated and actual installments table are separated. In addition will you please provide DB Table schema tonight? Thank you