if ($_POST['1shijian1']NULL) $shijian1=" and COPTC.TC003>=".$_POST['1shijian1']; else $shijian1="";
if ($_POST['1shijian2']NULL) $shijian2=" and COPTC.TC003 else $shijian2="";
require_once('i_code/connect.php');
$query="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=''".$shijian1.$shijian2." GROUP BY leixing,bztdb 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' ".$shijian1.$shijian2." GROUP BY leixing,xifen,bztdb union all 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'".$shijian1.$shijian2." GROUP BY leixing,xifen,sewen,ddgm,bztdb,daba order by xifen,sewen,daba";
$querydd="select DDGM1.TD001,DDGM1.TD002,DDGM1.TD003,COPTD.TD004,COPTD.TD005,COPTD.TD016,MA003,DDGM1.UDF10,XINGHAO,XIFEN,DDGM,DDGM1.TD008,COPTD.UDF03,MOCTA.TA001,MOCTA.TA002,DDZS.TA015,MOCTA.TA011,MOCTA.UDF06,TDB, CASE WHEN DDGM1.TD008=0 THEN 0 WHEN DDGM1.TD0080 THEN convert(decimal(18,3),DDZS.TA015/DDGM1.TD008) END AS SJB,DDZS.RKZS,D310, CASE WHEN DDGM1.TD008=0 THEN 0 WHEN DDGM1.TD0080 THEN convert(decimal(18,3),D310/DDGM1.TD008) END AS DDDCL,D305,D304,D3023,TH008,TJ007 FROM DDGM1 LEFT JOIN DDZS ON DDZS.TD001=DDGM1.TD001 AND DDZS.TD002=DDGM1.TD002 AND DDZS.TD003=DDGM1.TD003 LEFT JOIN COPTC ON COPTC.TC001=DDGM1.TD001 AND COPTC.TC002=DDGM1.TD002 left join MOCTA ON TA026=DDZS.TD001 AND TA027=DDZS.TD002 AND TA028=DDZS.TD003 left join COPTD ON COPTD.TD001=DDGM1.TD001 AND COPTD.TD002=DDGM1.TD002 AND COPTD.TD003=DDGM1.TD003 where XIFEN LIKE ".$_GET['n1']." and XINGHAO LIKE ".$_GET['n2'];
$resultdd=mssql_query($querydd); $row_numdd=mssql_num_rows($resultdd); if ($row_numdd>0) { echo "