Django SQL N-tables To List / Report

Hi there!

I am looking a simple operative example similar to:

- A report (xlsx, pdf, csv) from a SQL

- Obtained from a simple form: [data_start] [date_end] [client]

- Showing a simple list paginated.

[data_start] [date_end] [client]

buttom: list

buttom: report xlsx

buttom: report pdf

buttom: report csv

[____________columns_____________]

[____________data________________]

[<] [>]

If the example can use:

django-tables2

django-tables2-reports

will be ok, other standard packages are welcome too:

[Postgres]

CREATE TABLE [login to view URL] (

id serial4 NOT NULL,

client_code varchar (12) NOT NULL,

first_name varchar (100) NOT NULL,

last_name varchar (100) NOT NULL,

phone varchar (40) NOT NULL,

email varchar (100) NOT NULL,

CONSTRAINT client_pkey PRIMARY KEY (id)

CREATE TABLE public.order_header (

id serial4 NOT NULL,

order_date timestamptz NOT NULL,

phone varchar (40) NOT NULL,

email varchar (40) NOT NULL,

status_id int4 NOT NULL,

cliend_id_id int4 NOT NULL,

CONSTRAINT order_header_pkey PRIMARY KEY (id)

ALTER TABLE public.order_header ADD CONSTRAINT order_header_cliend_id_id_deafe7c7_fk_client_id FOREIGN KEY (cliend_id_id) REFERENCES [login to view URL] (id);

CREATE TABLE public.order_detail (

id serial4 NOT NULL,

quantity int4 NOT NULL,

net_price int4 NOT NULL,

discount_amount int4 NOT NULL,

dispatch_value int4 NOT NULL,

item_id_id int4 NOT NULL,

order_no_id int4 NOT NULL,

CONSTRAINT order_detail_pkey PRIMARY KEY (id)

ALTER TABLE public.order_detail ADD CONSTRAINT order_detail_item_id_id_d74dc24a_fk_item_id FOREIGN KEY (item_id_id) REFERENCES [login to view URL] (id);

ALTER TABLE public.order_detail ADD CONSTRAINT order_detail_order_no_id_b26d7218_fk_order_header_id FOREIGN KEY (order_no_id) REFERENCES public.order_header (id);

Greetings,