<html>
<body>
<?php
echo
"<input type='button' id='anniu' style='width:250px;height:25px;font-weight:bold;font-size:14px' onclick=\"window.location='demo1.php'\" value='查询逾期无吨位车辆信息' />"
;
echo
"<input type='button' style='width:250px;height:25px;font-weight:bold;font-size:14px'onclick=\"window.location='huizong.php'\" value='查询汇总信息' />"
;
$mysql_server_name
=
"localhost"
;
$mysql_username
=
"root"
;
$mysql_password
=
"123456"
;
$mysql_database
=
"td_oa"
;
$conn
=mysql_connect(
$mysql_server_name
,
$mysql_username
,
$mysql_password
);
mysql_query(
"SET NAMES 'UTF8'"
);
mysql_query(
"SET CHARACTER SET UTF8"
);
mysql_query(
"SET CHARACTER_SET_RESULTS=UTF8'"
);
$strsql
="select a.field4
as
'车号',a.field8
as
'任务号',a.field5
as
'装货日期' ,a.field6
as
'供应商名称',a.field7
as
'采购价格' from `crm_storage` a left join `crm_order` b on a.field4=b.field2
and
a.field8=b.field16
where (b.field8=0
or
b.field8 is null)
and
DATE_ADD(a.field5,INTERVAL 4 day)<CURDATE()";
$result
=mysql_db_query(
$mysql_database
,
$strsql
,
$conn
);
$row
=mysql_fetch_row(
$result
);
if
(
empty
(
$row
)){
$have
=0;
}
else
{
$have
=1;
}
?>
<script type=
"text/javascript"
>
window.onload=
function
()
{
have=<?php
echo
$have
;?>;
if
(have>0){
document.getElementById(
"anniu"
).style.backgroundColor=
"red"
;
}
}
</script>
</body>
</html>