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,
• Hi
• Do you need classes?
• Do you need help in your Quiz, Assignment or Exam?
• If "YES" then you are at right place.
• DW Solution Online is providing online classes for all grades and subjects with highly qualified Experts. We are also solving your problems, assignments quizzes and FYP. Our trial is always free. If you need any kind of help then contact us.
• We have the best experts team in Biology, Chemistry, Accounting, Statistics, Mathematics, Software(AutoCAD, Microsoft, Programming) and the Medical and Engineering Field. We're providing a free Online trial class.
• Our goal is to encourage and motivate students.
• We're appreciating the ability to maintain skills, discipline and deal with challenging behaviour.
• We have a full plan to improve your skills. We have the best collection of syllabus books, assignments and quizzes that will help you to improve your classes. We have a record to prepare Our students for the best one in their career. We have flexible timing for you.
• Feel free to contact us.