Database design

Self-Hosted | v5
1

I found something like:

[{“quantity”:0,“cost”:0,“product_key”:“”,“notes”:“”,“discount”:0,“is_amount_discount”:true,“tax_name1”:“”,“tax_rate1”:0,“tax_name2”:“”,“tax_rate2”:0,“tax_name3”:“”,“tax_rate3”:0,“custom_value1”:“”,“custom_value2”:“”,“custom_value3”:“”,“custom_value4”:“”,“type_id”:“1”,“tax_id”:“1”,“product_cost”:0,“sort_id”:“0”,“line_total”:0,“gross_line_total”:0,“tax_amount”:0,“date”:“”,“task_id”:“”,“expense_id”:“”,“unit_code”:“C62”}]

for invoice.line-items. And I am wondering why you fill up the database with nothing?

select from …
if line_item = empty, create json:
[{“quantity”:0,“cost”:0,“product_key”:“”,“notes”:“”,“discount”:0,“is_amount_discount”:true,“tax_name1”:“”,“tax_rate1”:0,“tax_name2”:“”,“tax_rate2”:0,“tax_name3”:“”,“tax_rate3”:0,“custom_value1”:“”,“custom_value2”:“”,“custom_value3”:“”,“custom_value4”:“”,“type_id”:“1”,“tax_id”:“1”,“product_cost”:0,“sort_id”:“0”,“line_total”:0,“gross_line_total”:0,“tax_amount”:0,“date”:“”,“task_id”:“”,“expense_id”:“”,“unit_code”:“C62”}]

Now you have it without filling so much stuff in your table.

Is there any secret reason, why do you do that in this way, please?

2

Hi,

Was the invoice created in the web or desktop app?

3

I have imported clients, products and invoices.
Unfortunately, there is no table for positions, and also nobody cares for export/import positions.
I have imported the needed tables to MySQL and written some small scripts to copy data and do the JSON for invoices. Finally, after ten hours of fighting, everything is copied and running.

What i miss now is:
Mark some invoices as paid. Most customers pay around the end of the months; it is nice to check the bank app and just click checkboxes next to invoices, instead of uncheck one by one.

Is it possible with the api to show a page with the last 20 unpaid invoices?
Then use checkboxes and send?

4

The blank data may have been caused by the import.

I’m not sure I understand your question. The app uses the API, anything which can be done with the app can be done with the API. You can use the network tab in the browser console to see the API requests.

5

Show invoices:
See checkbox and invoice data line by line.

Everyone will try to use the checkboxes, then click left top to mark them as paid.
But there is no function for this. But this is the place where it should be.

6

I’m not sure, this is supported. Can you please post a screenshot?