便条 v3

搜索:

登陆后可以记录私有便条！

	13864 funnyfav		图片	admin	分数: 0 (0 次)	创建： 2021-10-17 22:13:34 更新： 2022-03-23 17:28:00
jm 统计个数 $id=(int)$Product_ID; $sql="select Warehouse_ID,Base_Product_ID From funny_product where id=$id "; $Warehouse_ID=sql_read($db,$sql,"Warehouse_ID"); $Base_Product_ID=sql_read($db,$sql,"Base_Product_ID"); $sql="select sum(a.Count) From funny_order_item a where Product_ID=$id AND Deleted=0 AND Fake=0"; echo $sql; echo "<br>\n"; $Sell_Count=(int)sql_count($db,$sql);//卖出去个数 echo "<font color=blue>卖出去个数=$Sell_Count </font><br>\n"; $sql="select sum(a.Count) From funny_order_purchase_item a left join funny_order_purchase b on (a.order_id=b.id) where a.Product_ID=$id AND a.Deleted=0 AND b.Audit=1"; echo $sql; echo "<br>\n"; $Buy_Count=(int)sql_count($db,$sql);//买进来个数 echo "<font color=blue>买进来个数=$Buy_Count </font><br>\n"; $sql="select sum(a.Count) From funny_order_move_item a join funny_order_move b on (a.Order_ID=b.ID) where a.Product_ID=$Base_Product_ID AND a.Deleted=0 AND b.Warehouse_ID=$Warehouse_ID AND b.Audit=1"; echo $sql; echo "<br>\n"; $Sell_Count2=(int)sql_count($db,$sql);//卖出去个数 echo "<font color=blue>（调货）出去个数=$Sell_Count2 </font><br>\n"; $sql="select sum(a.Count) From funny_order_move_item a join funny_order_move b on (a.Order_ID=b.ID) where a.Product_ID=$Base_Product_ID AND a.Deleted=0 AND b.Warehouse2_ID=$Warehouse_ID AND b.Audit=1 AND b.Audit_Receive=1 "; echo $sql; echo "<br>\n"; $Buy_Count2=(int)sql_count($db,$sql); echo "<font color=blue>（调货）进来个数=$Buy_Count2 </font> <br>\n"; $sql="update funny_product set Count_Now=Count+$Buy_Count+$Buy_Count2-$Sell_Count-$Sell_Count2 Where ID=$id "; sql_run($db,$sql,1); echo $sql;