时间:2021-07-01 10:21:17 帮助过:19人阅读
$orderQuery = "select sum(`goods`.goods_nums) goods_nums,goods.goods_id,goods.goods_array,goods.product_id,goods.goods_price
from iwebshop_order `order`
join iwebshop_order_goods `goods`
on `order`.id = `goods`.order_id
where `order`.status = '5'
and unix_timestamp(`order`.create_time)
between '".$begin."' and '".$end."'
group by `goods`.goods_id";
$njhl = new MYSQL("127.0.0.1","root","","test1");
$orderResult = $njhl->query($orderQuery,'select');
if($orderResult)
{
foreach($orderResult as $item)
{
$goodsQuery = "select goods_no,huo_no from goods where id = ".$stock['goods_id'];
$goodsResult = $njhl->query($goodsQuery,'select');
if($goodsResult)
{
foreach($goodsResult as $goods)
{
$goods_no = trim($goods['goods_no']);
$goods_huo = trim($goods['huo_no']);
$where;
if($goods_no)
{
$goods_no = strlen($goods_no)<10?str_pad($goods_no, 10,'0',STR_PAD_LEFT):$goods_no;
$where = "info.item_no = '".$goods_no."'";
}
else
{
$goods_huo = strlen($goods_huo)<5?str_pad($goods_huo, 5,'0',STR_PAD_LEFT):$goods_huo;
$where = "info.item_huo = '".$goods_huo."'";
}
$stockQuery = "select * from info join stock on stock.item_no = info.item_no where ".$where;
$hsh = new MYSQL("127.0.0.1","root","","test2");
$stockResult = $hsh->query($stockQuery,'select');
var_dump($stockResult);
}
}
}
}
查询是有多条数据的!
$orderQuery = "select sum(`goods`.goods_nums) goods_nums,goods.goods_id,goods.goods_array,goods.product_id,goods.goods_price
from iwebshop_order `order`
join iwebshop_order_goods `goods`
on `order`.id = `goods`.order_id
where `order`.status = '5'
and unix_timestamp(`order`.create_time)
between '".$begin."' and '".$end."'
group by `goods`.goods_id";
$njhl = new MYSQL("127.0.0.1","root","","test1");
$orderResult = $njhl->query($orderQuery,'select');
if($orderResult)
{
foreach($orderResult as $item)
{
$goodsQuery = "select goods_no,huo_no from goods where id = ".$stock['goods_id'];
$goodsResult = $njhl->query($goodsQuery,'select');
if($goodsResult)
{
foreach($goodsResult as $goods)
{
$goods_no = trim($goods['goods_no']);
$goods_huo = trim($goods['huo_no']);
$where;
if($goods_no)
{
$goods_no = strlen($goods_no)<10?str_pad($goods_no, 10,'0',STR_PAD_LEFT):$goods_no;
$where = "info.item_no = '".$goods_no."'";
}
else
{
$goods_huo = strlen($goods_huo)<5?str_pad($goods_huo, 5,'0',STR_PAD_LEFT):$goods_huo;
$where = "info.item_huo = '".$goods_huo."'";
}
$stockQuery = "select * from info join stock on stock.item_no = info.item_no where ".$where;
$hsh = new MYSQL("127.0.0.1","root","","test2");
$stockResult = $hsh->query($stockQuery,'select');
var_dump($stockResult);
}
}
}
}
查询是有多条数据的!