This raises havoc with my css grid forcing a null column (thus screwing up my justify-content), but appears to be the least painful. And, alas, it does require repeating my database query after the post.
Don't put the hidden field in a span tag, the input maybe hidden, but the span isn't.
This is an application for a construction contractor. The prices are set (sans change orders and extras) in the contract. Billing occurs at specific points in the project.
You're falling into the realms of accountancy: what is eventually billed (for the whole job) doesn't matter, what is quoted doesn't matter, what is actually billed and when it is billed does matter. Tax and end of year depend on when the invoice is issued. What you make on a specific job is another thing, accountants don't care (as such) all that they are interested in is what was invoiced (sales and purchase), any equipment purchases (they depreciate and are held as capital) etc.. during your year start to year end so that they can work out what you need to pay the government.
Keep in mind that the invoicing and job specific profits are completely separate, you have a tax year and a job life; some jobs can last hours and others can go on for years; your invoice relates to one specific time period, the year end profits and losses relate to a time period; invoices were invented so that your government get their taxes.
I wanted to avoid hitting the database again
That's what they are for and perfect for keeping tabs on what is what and creating views (invoice, profit and loss sheet etc.. all from the same data without have to enter anything else)
Another way of thinking of this is to create a work sheet which keeps details of what is done, then at the end of the month / quarter, you can generate an invoice based on the dates entered on the work sheet?
I hope that I have been clear, I know that accounts can seem unnecessarily complicated (sounds like programming
) it's so easy to get mixed up. Keep the idea of the invoice as a separate thing and not a part of something bigger [the job]. The something bigger is your quote and daily work sheets from site, keep them separate and you will find it easier to tackle.