Implement trip logger

[Mineshafter61]

maybe implement it as a thing within Iciwi's SQL?

[Mineshafter61]

Ok im changing things up a bit and implementing this as a CSV

Which format do you prefer:

• id, action: enter/exit, username, card/ticket type, card/ticket number, starting station, price, fare class, transfer reference ID
• id, action: enter/exit, username, card/ticket type, card/ticket number, starting station, price, fare class, TRF, (same thing again for every transfer)

The first will be easier to code but harder to read, the second will be harder to code but can get very long.

Also should fare gates log every entry and exit, or only on exit?

[Mineshafter61]

Enhancement: the trip logger should update its stats onto a webpage as well

[Mineshafter61]

Instead of fumbling around with formats, I think it'll be better if I listed every single type of transaction here and see how to sort them.

Each entry will have a unique key made up of the timestamp and username, and each access point to the list (each entry will be stored in a huge list) will need to call this unique key. Therefore each access point is their own list of these keys.

Ticket machines

New ticket

• Timestamp
• Username
• Card Serial
• Card New (Current) Value

Top Up

• Timestamp
• Username
• Card
• • Serial
• • Railpass List
• • • Name
• • • Cost
• • • Discount Percentage
• • • Start Time
• • • Duration
• • • Company
• • Card New (Current) Value
• Card Old Value

Refund

• Timestamp
• Username
• Card
• • Serial
• • Railpasses
• • • Name
• • • Cost
• • • Discount Percentage
• • • Start Time
• • • Duration
• • • Company
• • Card Current Value

New Railpass

• Timestamp
• Username
• Card
• • Serial
• • Railpass List
• • • Name
• • • Cost
• • • Discount Percentage
• • • Start Time
• • • Duration
• • • Company
• • Card Current Value
• New Railpass
• • Name
• • Cost
• • Discount Percentage
• • Start Time
• • Duration
• • Company

New Ticket

• Timestamp
• Username
• Ticket Cost
• Company Payment Table
• • Company Paid
• • Value of payment
• Start Station
• End Station
• Fare class

Faregates

Entry (normal, card)

• Timestamp
• Username
• Sign coords
• Station
• Card
• • Serial
• • Railpass List
• • • Name
• • • Cost
• • • Discount Percentage
• • • Start Time
• • • Duration
• • • Company
• • Card Current Value

Exit (normal, card)

• Timestamp
• Username
• Sign coords
• Station
• Card
• • Serial
• • Railpass List
• • • Name
• • • Cost
• • • Discount Percentage
• • • Start Time
• • • Duration
• • • Company
• • Card Current Value
• Journey
• • Entry
• • • Timestamp
• • • Station
• • Exit
• • • Timestamp
• • • Station
• • Fare class
• • Transaction
• • • Original Fare
• • • Railpasses Used
• • • • Name
• • • • Cost
• • • • Discount Percentage
• • • • Start Time
• • • • Duration
• • • • Company
• • • Final Fare

Entry (transfer, card)

• Timestamp
• Username
• Sign coords
• Station
• Card
• • Serial
• • Railpass List
• • • Name
• • • Cost
• • • Discount Percentage
• • • Start Time
• • • Duration
• • • Company
• • Card Current Value
• Previous Journey
• • Entry
• • • Timestamp
• • • Station
• • Exit
• • • Timestamp
• • • Station
• • Fare class
• • Transaction
• • • Original Fare
• • • Railpasses Used
• • • • Name
• • • • Cost
• • • • Discount Percentage
• • • • Start Time
• • • • Duration
• • • • Company
• • • Final Fare

Exit (transfer, card)

• Timestamp
• Username
• Sign coords
• Station
• Card
• • Serial
• • Railpass List
• • • Name
• • • Cost
• • • Discount Percentage
• • • Start Time
• • • Duration
• • • Company
• • Card Current Value
• Journey
• • Entry
• • • Timestamp
• • • Station
• • Exit
• • • Timestamp
• • • Station
• • Fare class
• • Transaction
• • • Original Fare for this leg
• • • Amended Fare
• • • • Start Station
• • • • End Station
• • • • Class
• • • • Fare Value
• • • Railpasses Used
• • • • Name
• • • • Cost
• • • • Discount Percentage
• • • • Start Time
• • • • Duration
• • • • Company
• • • Final Fare
• Previous Journey
• • Entry
• • • Timestamp
• • • Station
• • Exit
• • • Timestamp
• • • Station
• • Fare class
• • Transaction
• • • Original Fare
• • • Railpasses Used
• • • • Name
• • • • Cost
• • • • Discount Percentage
• • • • Start Time
• • • • Duration
• • • • Company
• • • Final Fare

Entry (ticket)

• Timestamp
• Username
• Sign coords
• Station
• Ticket
• • Start
• • End
• • Class

Exit (ticket)

• Timestamp
• Username
• Sign coords
• Station
• Ticket
• • Start
• • End
• • Class
• Journey
• • Entry
• • • Timestamp
• • • Station
• • Exit
• • • Timestamp
• • • Station
• • Fare class
• • Transaction
• • • Original Fare
• • • Railpasses Used (none)
• • • • Name
• • • • Cost
• • • • Discount Percentage
• • • • Start Time
• • • • Duration
• • • • Company
• • • Final Fare

[winsanmwtv]

In case if buy ticket for other person? (like keyable username if 1-time tickets)

[Mineshafter61]

@Phongsiri33013Winsan2020TH if you buy a ticket for another person it'll still be counted as your purchase, but if they used the ticket their faregate entry will have their name listed.

[Mineshafter61]

I think one feature we can consider is adding serial numbers to tickets

[muffinbarde]

@Mineshafter61 If you could send simple website pings imaginethisisawebsite.com/somerandompath/?i=[and here information in a format you decide] I could do the website overview for you - for me it currently is hard to do something in-game (laptop only) but web dev I can do - let me know if you would want something like this or not

[Mineshafter61]

@muffinbarde that would greatly help, thanks!

BTW i also only have a laptop but Vim is my go-to IDE, therefore I'm not affected by performance just as much when coding. If you're open to IDE suggestions, I suggest trying out Helix.

[muffinbarde]

@Mineshafter61 Thx for the suggestions; for me it's rather that I can't not try out what I coded without a mouse because playing the game without it is soo difficult and unpleasent. So I still have to wait for my mouse to arrive. Just write me on Discord once you need my help.

[Mineshafter61]

Milestones:

• [x] table creation
• [x] fare gate logging
• [x] ticket machine logging