question

samtech avatar image
samtech asked

Generate Report using Ajax in CodeIgniter MYSQL

<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)

  1. Order_Item order_items( id, order_id, product_id, qty, rate, amount, PRIMARY KEY (id`)
  2. Product Table: products( id, category_id, store_id, name, price, description, image, active, PRIMARY KEY (id`)
mysql
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.