Invoice sheet work #54

New issue

Closed

opened 2022-12-18 18:55:06 -08:00 by kzrl · 6 comments

kzrl commented

2022-12-18 18:55:06 -08:00

(Migrated from gitlab.com)

Untitled_19122022_133053-1.pdf

[Untitled_19122022_133053-1.pdf](/uploads/e14bd1847762c0757681cec202d80425/Untitled_19122022_133053-1.pdf)

kzrl commented

2023-01-05 15:35:46 -08:00

(Migrated from gitlab.com)

Will need to rebuild the invoice index to implement this.

select issue_date, due_date, paid, payment_received_date, title, job_id, enquiry_id, customer_id from invoices;

Will need to rebuild the invoice index to implement this. ``` select issue_date, due_date, paid, payment_received_date, title, job_id, enquiry_id, customer_id from invoices; ```

kzrl commented

2023-01-05 15:39:54 -08:00

(Migrated from gitlab.com)

select i.issue_date, i.due_date, i.paid, i.payment_received_date, i.title, i.job_id, j.title, i.enquiry_id, e.title, i.customer_id, c.name from invoices i JOIN jobs j, customers c, enquiries e WHERE i.job_id = j.id AND i.customer_id = c.id AND i.enquiry_id = e.id;

``` select i.issue_date, i.due_date, i.paid, i.payment_received_date, i.title, i.job_id, j.title, i.enquiry_id, e.title, i.customer_id, c.name from invoices i JOIN jobs j, customers c, enquiries e WHERE i.job_id = j.id AND i.customer_id = c.id AND i.enquiry_id = e.id; ```

kzrl commented

2023-03-21 03:54:17 -07:00

(Migrated from gitlab.com)

Some progress!

Some progress! ![Screenshot_2023-03-21_at_21-52-37_CMC_Invoices](/uploads/ee7b21a5f08861c73597f17f6f462335/Screenshot_2023-03-21_at_21-52-37_CMC_Invoices.png)

kzrl commented

2023-03-21 04:14:25 -07:00

(Migrated from gitlab.com)

mentioned in commit daec410797

mentioned in commit daec410797297c36f4ccfad4a706ead832c4a5ef

kzrl commented

2023-03-26 22:46:14 -07:00

(Migrated from gitlab.com)

mentioned in commit b8b894a5f9

mentioned in commit b8b894a5f94ddc03ef9095157b56477d8872c8af

kzrl (Migrated from gitlab.com) closed this issue

2023-03-26 23:44:50 -07:00