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 "
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn