CITY CHARGES HISTORY: no rhyme or reason

Nizaris

Subject pretty much says it all. Now, a demonstration:

8 Aeg 605: Kaevan : 2877 : Laid the charge of blah with a fine of 20000 and a term of 3.

8 Aeg 600: Thaumas : 0 : Enemied with reason: blah

8 Aeg 600: Thaumas : 2432 : Laid the charge of blah with a fine of 5000 and a term of 1.

7 Pha 627: Milenka : 4133 : Laid the charge of blah with a fine of 20000 and a term of 2.

7 Pha 627: Milenka : 4133 : This is an anonymized note.

7 Pha 627: Milenka : 0 : Enemied with reason: blah

24 Val 602: Thaumas : 0 : Enemied with reason: blah

24 Aeg 600: Thaumas : 2432 : Dropped charge 2432 because: Dropped because of unenemying..

24 Aeg 600: Thaumas : 0 : Unenemied with reason: blah

17 Mir 634: Carmain : 0 : Unenemied with reason: blah

17 Mir 634: Carmain : 4316 : Dropped charge 4316 because: Dropped because of unenemying..

17 Mir 634: Carmain : 4317 : Dropped charge 4317 because: Dropped because of unenemying..

16 Aeg 633: Hasar : 0 : Enemied with reason: blah

16 Aeg 633: Hasar : 4317 : Laid the charge of blah with a fine of 5000 and a term of 0.

So far as I can tell, there is no logic to the way that these are laid out. It is difficult to gather the full chronological story on what's happened, as this is not lain out chronologically. This is especially difficult in cases like this one where the subject has been enemied and unenemied multiple times; therefore, it is difficult to tell if they are still an enemy.

Proposed output:

8 Aeg 600:   Thaumas : 0 : Enemied with reason: blah.

8 Aeg 600:   Thaumas : 2432 : Laid the charge of blah with a fine of 5000 and a term of 1.

24 Aeg 600:  Thaumas : 2432 : Dropped charge 2432 because: Dropped because of unenemying..

24 Aeg 600:  Thaumas : 0 : Unenemied with reason: blah

24 Val 602:  Thaumas : 0 : Enemied with reason: blah

1 Lup 602:   Thaumas : 2799 : Laid the charge of blah with a fine of 10000 and a term of 2.

14 Chr 611:  Cain    : 2799 : Dropped charge 2799 because: Dropped because of unenemying..

1 Lup 602:   Thaumas : 2800 : Laid the charge of blah with a fine of 20000 and a term of 3.

14 Chr 611:  Cain    : 2800 : Dropped charge 2800 because: Dropped because of unenemying..

8 Aeg 605:   Kaevan  : 2877 : Laid the charge of blah with a fine of 20000 and a term of 3.

14 Chr 611:  Cain    : 2877 : Dropped charge 2877 because: Dropped because of unenemying..

14 Chr 611:  Cain    : 0 : Unenemied with reason: fine paid, time served.

7 Pha 627:   Milenka : 0 : Enemied with reason: blah

7 Pha 627:   Milenka : 4133 : Laid the charge of blah with a fine of 20000 and a term of 2.

7 Pha 627:   Milenka : 4133 : This is a note: blah

11 Chr 630:  Milenka : 4133 : Dropped charge 4133 because: Dropped because of unenemying..

11 Chr 630:  Milenka : 0 : Unenemied with reason: Time served, fine paid.

16 Aeg 633:  Hasar   : 0 : Enemied with reason: blah

16 Aeg 633:  Hasar   : 4316 : Laid the charge of blah with a fine of 5000 and a term of 0.

17 Mir 634:  Carmain : 4316 : Dropped charge 4316 because: Dropped because of unenemying..

16 Aeg 633:  Hasar   : 4317 : Laid the charge of blah with a fine of 5000 and a term of 0.

17 Mir 634:  Carmain : 4317 : Dropped charge 4317 because: Dropped because of unenemying..

17 Mir 634:  Carmain : 0 : Unenemied with reason: penance served, fine paid..

So, logic rules:

(1) CITY CHARGES HISTORY should be listed chronologically, except for rule (2) below.

(2) Dropped charge notes should be listed underneath the note for when the charge is lain, and also under all other notes attached to that charge, as in #4133 above. (Optional. It's nice to have the entire charge's history in one spot, but it does break rule (1) above).

(3) Formatting would be helpful. Columns, similar to above, and also colour highlights for keywords.

Thanks!