<code>**Order** table .2**order_items** table 4.**products** tables
Want to create a Report page in Code Igniter. For that i have two tables in My Sql , want to select attributes from them and Display in a single tables.FOR PRODUCT WISE SALES REPORT AND PRODUCT WISE PROFIT.What is the best way to do this.
attributes:
1.order table: id,
bill_no,
date_time,
gross_amount,
service_charge_rate,
service_charge_amount,
gst_charge_rate,
gst_charge_amount,
discount,
net_amount,
user_id,
table_id,
paid_status,
store_id PRIMARY KEY (id
)
- Order_Item order_items
(
id,
order_id,
product_id,
qty,
rate,
amount, PRIMARY KEY (
id`) - Product Table: products
(
id,
category_id,
store_id,
name,
price,
description,
image,
active, PRIMARY KEY (
id`)