php - Novice purchasing, selling and inventory management design, please guide~

1. I am learning to develop a purchase, sales and inventory management system. Now I encounter a problem. How to count the quantities when making inventory reports? 2. Let me first list the several data tables I use ⑴ inventory table ⑵ warehouse table ⑶ warehouse-in slip ⑷ warehouse-out slip ⑸ exist...

怪我咯 2017-06-05 11:07:08 0  1  666

"Adding custom buttons to reduce inventory: Adding new functionality to Woocommerce admin orders"

Need help updating my product inventory on WooCommerce manage orders page. I currently have some code that works, but it removes inventory from the wrong product. Does anyone know why? add_action('woocommerce_after_order_itemmeta','action_woocommerce_order_item_add_button',10,2);functionaction_wooco...

P粉029057928 2023-09-09 11:58:57 0  1  521

php - How to implement shared product inventory between two mall projects?

There are two opencart shopping mall projects that need to share the inventory fields of the same product table. Other fields may be different. How to design the database?

怪我咯 2017-05-16 13:15:23 0  1  512

How to "connect" multiple products using their SKUs?

I want to merge the inventory of two or more products based on their SKU in WooCommerce. Example: (Two products sharing the same inventory) Clear phone case iPhone11-SKU12345 Personalized iPhone11 phone case-SKU56789 (Three or more products sharing the same inventory) iPhone12 clear phone case-SKU12...

P粉466909449 2024-04-05 08:53:52 0  1  3615

How does Thinkphp query the database in batches?

1. I have such a requirement: there are 4 kinds of inventory in the warehouse receipt. I want to query whether there is such inventory in the existing table. If there is, increase the quantity. If not, create new data. The where condition is an array. How should I query? 2. where condition {code...}...

天蓬老师 2017-05-27 17:42:03 0  4  654

Problem with adding database records using THINKPHP3?

if ($cart_info) { $data['num'] = intval($cart_info['num'])+intval($num); //Judge inventory if (intval($check_info['num'])<=$ data['num']) { echo json_encode(array(&#39

冥冥中有主宰 2018-12-25 15:55:11 0  0  1205

When querying data from MYSQL, using mysql_query() always returns false, but is there no problem with the SQL statement?

<?php//Create database connection $conn=mysql_connect("localhost","arvin","123"); //Determine whether the data inventory connection is normal if(!$conn) { die('Could

“Arvin 2018-11-22 22:57:45 0  1  1629

redis - How does PHP prevent multiple processes from operating the same resource at the same time?

How does PHP prevent multiple processes from operating the same resource at the same time? For example: flash sale products in the mall? Stock lock? Avoid oversold inventory? What is the principle?

滿天的星座 2017-05-16 13:18:57 0  4  748

Inventory issues regarding products with different configurations

Different computers have different configurations. Computers of the same model but with different configurations have different inventories. How to design such a data table?

小生我怕怕啊 2018-12-25 19:11:06 0  0  1042

In the individual product data options settings in WooCommerce admin, add content to custom tabs.

I created a custom tab on the product data options panel but don't know how to write content on it. I already have a code that uses add_action('woocommerce_product_options_sku','add_leadlovers_custom_fields') hook to print options (checkboxes, text, etc.) on the inventory tab.

P粉477369269 2023-07-21 15:47:05 0  1  432

PHP master looks at an array problem

{Code...} The data in the data inventory is like this ['7','2'] 7 represents the product id and 2 represents the quantity of the product purchased. Now how can I restore it to an array that can be used by PHP?

高洛峰 2017-06-08 11:01:38 0  7  836

javascript - input name is an array of variables, how to splice it?

$('input[name="cid[1]"]').val(data);//Assign display inventory code. This can be displayed normally, but it won't work if I modify the value in the array into a variable. $('input[name="cid[$i]"]').val(data);//It cannot be displayed here. How should $i be spliced ​​in?

PHPz 2017-05-27 17:42:39 0  1  609

Display inventory counters in multiple locations on the same page

This script works great as a stock countdown, but I can't display it in more than 1 position on the same page. For example, there are 4 or 5 products/plans on the same page, each product displays a different stock quantity, and the time when the quantity changes is also different. Shown on only 1 pr...

P粉038161873 2024-04-02 14:25:38 0  2  2646

I need to create an object using an object id from a MySQL database

I'm developing an inventory management system and I'm working on the final part of allowing users to update orders. This update requires items to be added or removed from the order. I'm working on adding the part now. I've tested the MySQL query that works in Workbench: INSERTINTOorder_items(item_qu...

P粉066224086 2024-03-28 17:41:00 0  1  371

PHP generates two-dimensional arrays for multiple products and clears inventory

$allPackGoods = array(   ['id'=>1,'stock'=>14,'num'=>6],   ['id'=>2,'stock'=>20,'num'=>6],   ['id

Cklein 2020-09-10 11:32:25 0  1  932

Font Awesome loading icon not showing in WooCommerce admin list

Updating inventory quantity in WooCommerce admin product list based on custom input field, this is my previous answer to one of my questions. The following code adds a custom button to the quantity column that when pressed updates the quantity and refreshes the current quantity. Tried adding a loadi...

P粉081360775 2024-02-17 21:07:05 0  1  397

Insert only enabled textbox into MySQL in VB.Net

I'm creating an inventory management system in VB.Net whose basic functionality is to process incoming invoices. I want to insert data into my remote MySQL database, but only if the textbox is considered enabled. I have no problem inserting data into the database when I want all fields to be inserte...

P粉043432210 2024-02-21 19:42:03 0  1  408

Master: How long does it take to learn to use PHP to make a purchase, sales and inventory, and what do you need to learn?

That's right, for a mediocre person like me, you are the masters. I am an office worker, working in a traditional manufacturing industry. I don’t work overtime. I have about 3 and a half hours a day after get off work to study, and I have a little basic knowledge of CSS. I have always wanted to make...

小星星 2017-11-17 16:00:29 0  2  1192

Ways to fix issue 2003 (HY000): Unable to connect to MySQL server 'db_mysql:3306' (111)

I recently tried to containerize my FastAPIPython server (also for replication/doubling purposes). Before, I had just a MySQL server in a Docker container and everything was fine, but when I also made my web server a service, it couldn't connect to the MySQL server, so now the application doesn't wo...

P粉178132828 2023-09-05 11:18:47 0  1  757

Experiment with sorting after query limit

So this is my first question here, please forgive me if something is wrong. I'm trying to make a sort query based on constraints. So there is a Customers table with 90 records. I want to first perform a query limited to 3 records, and then sort the results of this query by a column called ContactNam...

P粉237125700 2023-09-05 14:46:42 0  1  693