php编程SQL语句unionall的使用编程
编程php信息
id分别是ishijian1,ishijian2,语句是
echo ' ';
?>
起始时间
截止时间
c_huizong.php
//订单查询
if ($_POST['1shijian1'])
{
echo "
document.getElementById('1shijian1').value='".$_POST['1shijian1'].
"';document.getElementById('1shijian2').value='".$_POST['1shijian2'].
"';cg1name();";
if ($_POST['1shijian1']<>NULL)
$shijian1=" and COPTC.TC003>=".$_POST['1shijian1'];
else
$shijian1="";
if ($_POST['1shijian2']<>NULL)
$shijian2=" and COPTC.TC003<=".$_POST['1shijian2'];
else
$shijian2="";
require_once('i_code/connect.php');
$query="select leixing,xifen,sewen,ddgm,bztdb,daba,SUM(TD008) AS TD008,SUM(TA015)TA015,SUM(RKZS)RKZS,SUM(D310)D310,SUM(D305)D305,SUM(D304)D304,SUM(D3023)D3023,SUM(TH008)TH008,SUM(TJ007)TJ007
FROM chaxun
LEFT JOIN DDTJMX ON MA003=leixing and xifen=XIFEN AND sewen=DDTJMX.UDF10 AND ddgm=DDGM and daba=XINGHAO
left join COPTC on TC001=DDTJMX.TD001 AND TC002=DDTJMX.TD002
where xifen<>'' and xifen<>'5050' and TC003>='20150110' AND TC003<='20150120'
GROUP BY leixing,xifen,sewen,ddgm,bztdb,daba
union all
select leixing,xifen,null as sewen,null as ddgm,bztdb,null as daba,SUM(TD008) AS TD008,SUM(TA015)TA015,SUM(RKZS)RKZS,SUM(D310)D310,SUM(D305)D305,SUM(D304)D304,SUM(D3023)D3023,SUM(TH008)TH008,SUM(TJ007)TJ007
FROM chaxun
LEFT JOIN DDTJMX ON MA003=leixing and xifen=XIFEN
left join COPTC on TC001=DDTJMX.TD001 AND TC002=DDTJMX.TD002
where xifen='5050' and TC003>='20150110' AND TC003<='20150120'
GROUP BY leixing,xifen,bztdb
union all
select leixing,null as xifen,null as sewen,null as ddgm,bztdb, null as daba,SUM(TD008) AS TD008,SUM(TA015)TA015,SUM(RKZS)RKZS,SUM(D310)D310,SUM(D305)D305,SUM(D304)D304,SUM(D3023)D3023,SUM(TH008)TH008,SUM(TJ007)TJ007
FROM chaxun
LEFT JOIN DDTJMX ON MA003=leixing
left join COPTC on TC001=DDTJMX.TD001 AND TC002=DDTJMX.TD002
where xifen='' and TC003>='20150110' AND TC003<='20150120'
GROUP BY leixing,bztdb".$shijian1.$shijian2;
$result=mssql_query($query);
$row_num=mssql_num_rows($result);
if ($row_num<=10000 && $row_num>0)
{
echo "
";
echo "类别 ;
细分 ;
色温 ;
订单规模 ;
标准投单比 ;
打靶 ;
订单量 ;
预计产量 ;
总入库数 ;
标准入库 ;
销货数量 ;
销退数量 ;
跟踪信息 ;
";while($row=mssql_fetch_assoc($result))
{
echo"
";echo"
".$row['leixing']." ";
echo"".$row['xifen']." ";
echo"".$row['sewen']." ";
echo"".$row['ddgm']." ";
echo"".$row['bztdb']." ";
echo"".$row['daba']." ";
echo"".number_format($row['TD008'],0)." ";
echo"".number_format($row['TA015'],0)." ";
echo"".number_format($row['RKZS'],0)." ";
echo"".number_format($row['D310'],0)." ";
echo"".number_format($row['TH008'],0)." ";
echo"".number_format($row['TJ007'],0)." ";
echo"跟踪信息 ";
//跟踪信息echo"
\n";}
echo"
";
echo'';}
mssql_close($conn);
}
?>
现在一运行语句是错的,是后面的语句里面的查询语句有错,求指正。
PHP之友评论