How does php + mysql achieve Weighted average unit price of inventory? Urgent !!! Online.

Source: Internet
Author: User
Dear colleagues! Please help to achieve the weighted average unit price of inventory using PHP + MYSQL. I need to request the inventory unit price for the current month, and the inventory unit price for the current month (actual amount of inventory at the beginning of the month + (actual unit price for the current month * number of purchases this month )) (inventory quantity at the beginning of the month + number of purchases this month ). the following are three tables, one is the product table cxh_product (id, code, p_name), and the other is the storage table (product_id, qty, price, total, stockage_date ), one is the stockout table (product_id, qty, stockout _... mysqlphp

Experts:
Hello everyone! Please help to achieve the weighted average unit price of inventory using PHP + MYSQL. I now need to request the inventory unit price for the current month, the inventory unit price for the current month = (actual amount of inventory at the beginning of the month + (actual unit price for the current month * number of purchases this month )) /(inventory quantity at the beginning of the month + number of purchases this month ). the following are three tables, one is the product table cxh_product (id, code, p_name), and the other is the storage table (product_id, qty, price, total, stockage_date ), one is the warehouse picking table.
Stockout (product_id, qty, stockout_date ).

Please help solve the problem. urgent...

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.