接上面:
case ("yang_ts"): // CTO -> TS Yang
$wstatall = "True";
$wshowall = "True";
$wviewSH = "False";
$wviewSZ = "False";
$wviewWH = "False";
break;
case ("chen_sm"): // DCC Leader -> Sue-Mei Chen
$wstatall = "True";
$wshowall = "True";
$wviewSH = "False";
$wviewSZ = "False";
$wviewWH = "False";
break;
case ("chung_hc"): // Assistant -> H.C. Chung
$wstatall = "True";
$wshowall = "True";
$wviewSH = "False";
$wviewSZ = "False";
$wviewWH = "False";
break;
default:
$wstatall = "False";
$wshowall = "False";
$wviewSH = "False";
$wviewSZ = "False";
$wviewWH = "False";
break;
}
switch ($wreader)
{
case ("liu_hy"): // 刘汉尧 $whyperlink = "False";
break;
case ("li_hc"): // 李欣洁 $whyperlink = "False";
break;
default: // Initial Everyone
$whyperlink = "True";
break;
}
//if ($whyperlink=="False"){ $wshowall = "True"; }
// Get All Project Leader data from MS SQL database
$link = mssql_connect("XXX.XXX.XXX.XXX", "", "");
mssql_select_db("", $link); $strSQL0 = "SELECT DISTINCT ltrim(rtrim(A.resan003)) AS resak001, ltrim(rtrim(B.resak002)) AS resak002, ";
$strSQL0.= "ltrim(rtrim(B.resak004)) AS resan004 FROM resan A JOIN [resak] AS B ";
$strSQL0.= "ON A.resan003=B.resak001 AND right(ltrim(rtrim(A.resan001)),2)='PL' ORDER BY 3,2,1"; $PLresult = mssql_query($strSQL0, $link);
$PLrowcnt = mssql_num_rows($PLresult); $strSQL1 = "SELECT ltrim(rtrim(resan003)),left(ltrim(rtrim(resan001)),len(ltrim(rtrim(resan001)))-4) ";
$strSQL1.= " FROM resan WHERE right(ltrim(rtrim(resan001)),2)='PL' ";
case ("yang_ts"): // CTO -> TS Yang
$wstatall = "True";
$wshowall = "True";
$wviewSH = "False";
$wviewSZ = "False";
$wviewWH = "False";
break;
case ("chen_sm"): // DCC Leader -> Sue-Mei Chen
$wstatall = "True";
$wshowall = "True";
$wviewSH = "False";
$wviewSZ = "False";
$wviewWH = "False";
break;
case ("chung_hc"): // Assistant -> H.C. Chung
$wstatall = "True";
$wshowall = "True";
$wviewSH = "False";
$wviewSZ = "False";
$wviewWH = "False";
break;
default:
$wstatall = "False";
$wshowall = "False";
$wviewSH = "False";
$wviewSZ = "False";
$wviewWH = "False";
break;
}
switch ($wreader)
{
case ("liu_hy"): // 刘汉尧 $whyperlink = "False";
break;
case ("li_hc"): // 李欣洁 $whyperlink = "False";
break;
default: // Initial Everyone
$whyperlink = "True";
break;
}
//if ($whyperlink=="False"){ $wshowall = "True"; }
// Get All Project Leader data from MS SQL database
$link = mssql_connect("XXX.XXX.XXX.XXX", "", "");
mssql_select_db("", $link); $strSQL0 = "SELECT DISTINCT ltrim(rtrim(A.resan003)) AS resak001, ltrim(rtrim(B.resak002)) AS resak002, ";
$strSQL0.= "ltrim(rtrim(B.resak004)) AS resan004 FROM resan A JOIN [resak] AS B ";
$strSQL0.= "ON A.resan003=B.resak001 AND right(ltrim(rtrim(A.resan001)),2)='PL' ORDER BY 3,2,1"; $PLresult = mssql_query($strSQL0, $link);
$PLrowcnt = mssql_num_rows($PLresult); $strSQL1 = "SELECT ltrim(rtrim(resan003)),left(ltrim(rtrim(resan001)),len(ltrim(rtrim(resan001)))-4) ";
$strSQL1.= " FROM resan WHERE right(ltrim(rtrim(resan001)),2)='PL' ";
{
$strSQL1.= " AND resan003=$wleader";
}else{
$strSQL1.= " AND 1=2";
} $PLresult1= mssql_query($strSQL1, $link);
$PLrowcnt1= mssql_num_rows($PLresult1);
for ($rcnt=0; $rcnt<$PLrowcnt1; $rcnt++)
{
$PLrow = mssql_fetch_array($PLresult1);
$PLowner[$rcnt] = $PLrow[0];
$PLprojno[$rcnt] = $PLrow[1];
}
mssql_free_result($PLresult1); // Get belong to login user's project
if ($whyperlink=="True")
{
$strSQL2 = "select distinct substring(resan001,1,6) AS projectno, substring(resan001,7,2) AS version, resak001, resak002 from resan, resak ";
$strSQL2.= "where resan003=resak001 and resak004='$wviewer' and len(ltrim(rtrim(resan001)))=10 and ISNULL(resak898,0)=0 order by 1, 2";
$OwnerResult = mssql_query($strSQL2, $link);
$OwnerRowcnt = mssql_num_rows($OwnerResult);
$OwnerProj = array();
$OwnerVers = array();
for ($row=0; $row<$OwnerRowcnt; $row++)
{
$OwnerRow = mssql_fetch_array($OwnerResult);
$OwnerProj[$row] = $OwnerRow[0];
$OwnerVers[$row] = $OwnerRow[1];
}
}else{
$strSQL2 = "select distinct substring(resan001,1,6) AS projectno, substring(resan001,7,2) AS version, resak001, resak002 from resan, resak ";
$strSQL2.= "where resan003=resak001 and resak001='$wleader' and len(ltrim(rtrim(resan001)))=10 and ISNULL(resak898,0)=0 order by 1, 2";
$OwnerResult = mssql_query($strSQL2, $link);
$OwnerRowcnt = mssql_num_rows($OwnerResult);
$OwnerProj = array();
$OwnerVers = array();
for ($row=0; $row<$OwnerRowcnt; $row++)
{
$OwnerRow = mssql_fetch_array($OwnerResult);
$OwnerProj[$row] = $OwnerRow[0];
$OwnerVers[$row] = $OwnerRow[1];
}
}
mssql_free_result($OwnerResult);
// Get All Project data from pdms_home
$connpdmdb = mysql_pconnect("localhost", "", "");
mysql_select_db("pdmdb", $connpdmdb);
$rowsql = "select serialno,line,phase,trim(projectno),trim(productno),trim(description),trim(version),";
$rowsql.= "date_format(initialtime,'%Y/%m/%e'),date_format(updatetime,'%Y/%m/%e'), trim(oldprojectno) ";
if ($wstatus=="ALLRows")
{
$rowsql.= " from pdms_home where 1=1 ";
}else{
$rowsql.= " from pdms_home where activateyn='1' and ";
}
if ($wstatus!="ALLRows")
{
if ($wstatus=="ALL")
{
$rowsql.= " 1=1";
}else{
if (strlen($wstatus)>0)
{
$rowsql.= " trim(status)='$wstatus'";
}else{
$rowsql.= " (trim(status)='Active' OR trim(status)='On-hold')";
}
}
}
if ($wstatus=="ALLRows")
{
if (strlen(trim($wcenter))>0)
{
$rowsql.= " and trim(center)='$wcenter'";
}
}else{
if (strlen(trim($wcenter))>0)
{
$rowsql.= " and trim(center)='$wcenter'";
}
} $rowsql.= " and historylog='1' ";
if ($wviewSZ=="True")
{
$rowsql.= " and trim(center)='SZ' ";
}
if ($wviewSH=="True")
{
$rowsql.= " and trim(center)='SH' ";
}
if ($wviewWH=="True")
{
$rowsql.= " and trim(center)='WH' ";
}
$rowsql.= " order by $wsort, 4";
$result = mysql_query($rowsql, $connpdmdb);
if (!$result) {
printf("Query data error %s : %s",mysql_errno(),mysql_error());
exit;
} $rowcnt = mysql_num_rows($result);
if ($rowcnt==0){
$wsubmit = "Insert";
}else{
$wsubmit="Update";
} switch ($wcenter)
{
case ("TWN"):
$wSeleCN[0]="";
$wSeleCN[1]="selected";
$wSeleCN[2]="";
$wSeleCN[3]="";
$wSeleCN[4]="";
$wSeleCN[5]="";
$wSeleCN[6]="";
break;
case ("USA"):
$wSeleCN[0]="";
$wSeleCN[1]="";
$wSeleCN[2]="selected";
$wSeleCN[3]="";
$wSeleCN[4]="";
$wSeleCN[5]="";
$wSeleCN[6]="";
break;
case ("SH"):
$wSeleCN[0]="";
$wSeleCN[1]="";
$wSeleCN[2]="";
$wSeleCN[3]="selected";
$wSeleCN[4]="";
$wSeleCN[5]="";
$wSeleCN[6]="";
break;
case ("SZ"):
$wSeleCN[0]="";
$wSeleCN[1]="";
$wSeleCN[2]="";
$wSeleCN[3]="";
$wSeleCN[4]="selected";
$wSeleCN[5]="";
$wSeleCN[6]="";
break;
case ("WH"):
$wSeleCN[0]="";
$wSeleCN[1]="";
$wSeleCN[2]="";
$wSeleCN[3]="";
$wSeleCN[4]="";
$wSeleCN[5]="selected";
$wSeleCN[6]="";
break;
case ("XN"):
$wSeleCN[0]="";
$wSeleCN[1]="";
$wSeleCN[2]="";
$wSeleCN[3]="";
$wSeleCN[4]="";
$wSeleCN[5]="";
$wSeleCN[6]="selected";
break;
default:
$wSeleCN[0]="selected";
$wSeleCN[1]="";
$wSeleCN[2]="";
$wSeleCN[3]="";
$wSeleCN[4]="";
$wSeleCN[5]="";
$wSeleCN[6]="";
break;
} $wlastip = $_SERVER['X_FORWARDED_FOR']?$_SERVER['X_FORWARDED_FOR']:$_SERVER['REMOTE_ADDR'];
?>
<html>
<head>
<title>Welcome to PDMS website</title>
<meta name="description" content="Project Development Management System--PDMS">
<meta name="keywords" content="PLM, PDM, PDMS">
<meta http-equiv="Content-Type" content="text/html; charset=big5">
<style>
a { font-family: "Tahoma", "Verdana", "sans-serif"; font-size: 10pt; color: #330000; ; text-decoration: none; background-color: #CC9999}
.a1 { font-family: "Tahoma", "Verdana", "sans-serif"; font-size: 10pt; color: #FFFF02; ; text-decoration: none; background-color: #43504B}
a:hover { font-family: "Tahoma", "Verdana", "sans-serif"; font-size: 10pt; color: #FFFFFF; background-color: #6C6CB7}
.Header {font-family: "Tahoma", "Verdana", "sans-serif"; font-size: 10pt; background: #43504B; color: #FFFF02; font-weight: 200}
.Title {font-family: "Tahoma", "Verdana", "sans-serif"; font-size: 12pt; color: #FFFFFF; background-color: #666699}
.Text {font-family: "Tahoma", "Verdana", "sans-serif"; font-size: 10pt; color: #000000; font-weight: normal}
.Status {font-family: "Tahoma", "Verdana", "sans-serif"; font-size: 10pt; ; color: #000000; font-weight: normal}
#6C6CB7}
<script language="JavaScript">
<!--
if (parent.location.href != window.location.href)
{
parent.location.href=window.location.href;
}
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
function GoQueryStatus() { //Goto query status
var status = document.queryForm.m_status[document.queryForm.m_status.selectedIndex].value;
var center = document.queryForm.m_center[document.queryForm.m_center.selectedIndex].value;
var leader = document.queryForm.m_leader[document.queryForm.m_leader.selectedIndex].value;
var URLs = "pdms_home.php?sort=<?php echo $wsort;?>&status="+status+"¢er="+center+"&leader="+leader+"&viewer=<?php echo $wviewer;?>";
window.location.href = URLs;
}
function GoQueryCenter() { //Goto query center
var status = document.queryForm.m_status[document.queryForm.m_status.selectedIndex].value;
var center = document.queryForm.m_center[document.queryForm.m_center.selectedIndex].value;
var leader = document.queryForm.m_leader[document.queryForm.m_leader.selectedIndex].value;
var URLs = "pdms_home.php?sort=<?php echo $wsort;?>&status="+status+"¢er="+center+"&leader="+leader+"&viewer=<?php echo $wviewer;?>";
window.location.href = URLs;
}
function GoQueryLeader() { //Goto query leader
var status = document.queryForm.m_status[document.queryForm.m_status.selectedIndex].value;
var center = document.queryForm.m_center[document.queryForm.m_center.selectedIndex].value;
var leader = document.queryForm.m_leader[document.queryForm.m_leader.selectedIndex].value;
var URLs = "pdms_home.php?sort=<?php echo $wsort;?>&status="+status+"¢er="+center+"&leader="+leader+"&viewer=<?php echo $wviewer;?>";
window.location.href = URLs;
}
// -->
</script>
</head>
<body bgcolor="#ffffff" leftmargin="0" marginheight="0" marginwidth="0" topmargin="0">
<table width="100%">
<?php
echo "<form name=\"queryForm\">";
if (($rowcnt > 20))
{
echo "<tr align=\"center\">";
echo "<td colspan=\"5\" align=\"left\">";
if ($wshowall=="True")
{
echo "<a href=\"pdms_home_edit.php?evid=0\">Add New Project</a> ";
}else{
echo " ";
} echo "<select name=\"m_status\" class=\"Status\" onChange=\"GoQueryStatus()\">";
echo "<option value=\"\" $wselected>Select status</option>";
echo "<option value=\"Active\" $wactive>Active</option>";
echo "<option value=\"MP\" $wmp>MP</option>";
echo "<option value=\"Pending\" $wpend>Pending</option>";
echo "<option value=\"Pending(need procedure)\" $wpendnp>Pending(need procedure)</option>";
echo "<option value=\"Cancelled\" $wcancel>Cancelled</option>";
echo "<option value=\"Cancelled(need procedure)\" $wcancelnp>Cancelled(need procedure)</option>";
echo "<option value=\"Closed\" $wclose>Closed</option>";
echo "<option value=\"End of Life\" $weof>End of Life</option>";
echo "<option value=\"ALL\" $wall>ALL</option>";
if ($wshowall=="True")
{
echo "<option value=\"ALLRows\" $wallrows>ALLRows</option>";
}
echo "</select>";
echo "<select name=\"m_center\" class=\"Status\" onChange=\"GoQueryCenter()\">";
echo "<option value=\"\" $wSeleCN[0]>Select center</option>";
echo "<option value=\"TWN\" $wSeleCN[1]>TW</option>";
echo "<option value=\"USA\" $wSeleCN[2]>US</option>";
echo "<option value=\"SH\" $wSeleCN[3]>SH</option>";
echo "<option value=\"SZ\" $wSeleCN[4]>SZ</option>";
echo "<option value=\"WH\" $wSeleCN[5]>WH</option>";
echo "<option value=\"XN\" $wSeleCN[6]>XN</option>";
echo "</select>"; echo "<select name=\"m_leader\" class=\"Status\" onChange=\"GoQueryLeader()\">";
if (strlen($wleader)>0)
{
echo "<option value=\"\">Project Leader</option>";
}else{
echo "<option value=\"\" selected>Project Leader</option>";
}
for ($cnt=0; $cnt<$PLrowcnt; $cnt++)
{
$rowfields = mssql_fetch_row($PLresult);
if ($wleader==$rowfields[0])
{
echo "<option value=\"$rowfields[0]\" selected>$rowfields[2]$rowfields[1]</option>";
}else{
echo "<option value=\"$rowfields[0]\">$rowfields[2]$rowfields[1]</option>";
}
}
mssql_free_result($PLresult);
mssql_close($link);
echo "</select>"; echo "</td>";
echo "<td align=\"left\"><font class=\"Title\">PDMS Home</font></td>";
echo "</tr>";
}else{
echo "<tr align=\"center\">";
echo "<td colspan=\"5\" align=\"left\">";
if ($wshowall=="True")
{
echo "<a href=\"pdms_home_edit.php?evid=0&status=$wstatus¢er=$wcenter&leader=$wleader&type=a&viewer=$wviewer\">Add New Project</a> ";
}else{
echo " ";
}
echo "<select name=\"m_status\" class=\"Status\" onChange=\"GoQueryStatus()\">";
echo "<option value=\"\" $wselected>Select status</option>";
echo "<option value=\"Active\" $wactive>Active</option>";
echo "<option value=\"MP\" $wmp>MP</option>";
echo "<option value=\"Pending\" $wpend>Pending</option>";
echo "<option value=\"Pending(need procedure)\" $wpendnp>Pending(need procedure)</option>";
echo "<option value=\"Cancelled\" $wcancel>Cancelled</option>";
echo "<option value=\"Cancelled(need procedure)\" $wcancelnp>Cancelled(need procedure)</option>";
echo "<option value=\"Closed\" $wclose>Closed</option>";
echo "<option value=\"End of Life\" $weof>End of Life</option>";
{
echo "<option value=\"ALLRows\" $wallrows>ALLRows</option>";
}
echo "</select>";
echo "<select name=\"m_center\" class=\"Status\" onChange=\"GoQueryCenter()\">";
echo "<option value=\"\" $wSeleCN[0]>Select center</option>";
echo "<option value=\"TWN\" $wSeleCN[1]>TW</option>";
echo "<option value=\"USA\" $wSeleCN[2]>US</option>";
echo "<option value=\"SH\" $wSeleCN[3]>SH</option>";
echo "<option value=\"SZ\" $wSeleCN[4]>SZ</option>";
echo "<option value=\"WH\" $wSeleCN[5]>WH</option>";
echo "<option value=\"XN\" $wSeleCN[6]>XN</option>";
echo "</select>"; echo "<select name=\"m_leader\" class=\"Status\" onChange=\"GoQueryLeader()\">";
if (strlen($wleader)>0)
{
echo "<option value=\"\">Project Leader</option>";
}else{
echo "<option value=\"\" selected>Project Leader</option>";
}
for ($cnt=0; $cnt<$PLrowcnt; $cnt++)
{
$rowfields = mssql_fetch_row($PLresult);
if ($wleader==$rowfields[0])
{
echo "<option value=\"$rowfields[0]\" selected>$rowfields[2]$rowfields[1]</option>";
}else{
echo "<option value=\"$rowfields[0]\">$rowfields[2]$rowfields[1]</option>";
}
}
mssql_free_result($PLresult);
mssql_close($link); echo "</select>";
echo "</td>";
echo "<td align=\"left\"><font class=\"Title\">PDMS Home</font></td>";
echo "</tr>";
}
echo "</form>";
?>
<td width="10%"><font face="Arial, Helvetica, sans-serif"><a href="pdms_home.php?sort=2&status=<?php echo $wstatus;?>¢er=<?php echo $wcenter;?>&leader=<?php echo $wleader;?>&viewer=<?php echo $wviewer;?>" class="a1">Line</a></font></td> <td width="5%"><font face="Arial, Helvetica, sans-serif"><a href="pdms_home.php?sort=7&status=<?php echo $wstatus;?>¢er=<?php echo $wcenter;?>&leader=<?php echo $wleader;?>&viewer=<?php echo $wviewer;?>" class="a1">Version</a></font></td>
<td width="22%"><font face="Arial, Helvetica, sans-serif"><a href="pdms_home.php?sort=5&status=<?php echo $wstatus;?>¢er=<?php echo $wcenter;?>&leader=<?php echo $wleader;?>&viewer=<?php echo $wviewer;?>" class="a1">Product</a></font></td>
<td width="45%"><font face="Arial, Helvetica, sans-serif">Description</font></td>
</tr>
<?php
while (list($w00,$w01,$w02,$w03,$w04,$w05,$w06,$w07,$w08,$w09)=mysql_fetch_row($result)) {
$woldpjno = "";
$str_wodsod = "";
$wodsodSQL = "SELECT date_format(milestone_wod_ed,'%Y/%m/%d'), date_format(milestone_wod_cd,'%Y/%m/%d'), ";
$wodsodSQL.= " date_format(milestone_sod_ed,'%Y/%m/%d'), date_format(milestone_sod_cd,'%Y/%m/%d') ";
$wodsodSQL.= "FROM pdms_sche_details WHERE activateyn='1' AND ";
$wodsodSQL.= " trim(projectno)='$w03' AND trim(productno)='$w04' AND trim(version)='$w06'";
$wodsodResult = mysql_query($wodsodSQL, $connpdmdb);
$wodsodCount= mysql_num_rows($wodsodResult);
$wodsodRows = mysql_fetch_array($wodsodResult);
if ($wodsodCount>0)
{
if ($wodsodRows[0]=="0000/00/00"){$wodsodRows[0]="N/A";}
if ($wodsodRows[1]=="0000/00/00"){$wodsodRows[1]="N/A";}
if ($wodsodRows[2]=="0000/00/00"){$wodsodRows[2]="N/A";}
if ($wodsodRows[3]=="0000/00/00"){$wodsodRows[3]="N/A";}
if ($wodsodRows[2]=="N/A" && $wodsodRows[3]=="N/A")
{
$str_wodsod = "<img src=\"img/waferout.jpg\" width=\"13\" height=\"13\" align=\"absmiddle\" alt=\"" . "WOD->" . $wodsodRows[0] . ":" . $wodsodRows[1] . "\">";
}else{
$str_wodsod = "<img src=\"img/sample.gif\" width=\"13\" height=\"13\" align=\"absmiddle\" alt=\"" . "WOD->" . $wodsodRows[0] . ":" . $wodsodRows[1] . " SOD->" . $wodsodRows[2] . ":" . $wodsodRows[3] . "\">";
}
}
mysql_free_result($wodsodResult); if (strlen($w09)>0){$woldpjno="(".$w09.")";}
if ($whyperlink=="True")
{ if (in_array("$w03", $OwnerProj) || ($wstatall=="True"))
{
$LineSQL = "SELECT TRIM(line01) AS line01, TRIM(line02) AS line02 FROM pdms_line WHERE TRIM(line01)='$w01'";
$retLine = mysql_query($LineSQL, $connpdmdb);
$arrLine = mysql_fetch_array($retLine);
mysql_free_result($retLine);
if (isset($PLowner) && count($PLowner)>0)
{
if (in_array("$w03", $PLprojno))
{
echo "<tr>";
echo "<td class=\"Text\" width=\"10%\" align=\"center\">" . $arrLine[1] . "</td>";
echo "<td class=\"Text\" width=\"5%\" align=\"center\">" . $w02 . $str_wodsod ."</td>";
echo "<td class=\"Text\" width=\"13%\" align=\"center\"><a href=\"pdms_projecthome.php?evid=$w00&status=$wstatus¢er=$wcenter&leader=$wleader&viewer=$wviewer\">" . $w03 . "</a>$woldpjno</td>";
if ($wshowall=="True")
{
echo "<td class=\"Text\" width=\"5%\" align=\"center\"><a href=\"pdms_versionlog.php?evid=$w00&status=$wstatus¢er=$wcenter&leader=$wleader&viewer=$wviewer\">" . $w06 . "</a></td>";
}else{
echo "<td class=\"Text\" width=\"5%\" align=\"center\">" . $w06 . "</td>";
}
echo "<td class=\"Text\" width=\"22%\" align=\"left\"><a href=\"pdms_projecthome.php?evid=$w00&status=$wstatus¢er=$wcenter&leader=$wleader&viewer=$wviewer\">" . $w04 . "</a></td>";
if ($wshowall=="True")
{
echo "<td class=\"Text\" width=\"45%\" align=\"left\">" . addslashes($w05) . "<a href=\"pdms_home_edit.php?evid=$w00&status=$status¢er=$wcenter&leader=$wleader&type=e&viewer=$wviewer\"><img src=\"img/edit00.jpg\" width=\"15\" height=\"11\" border=\"0\" alt=\"Edit Elements\"></a> <a href=\"pdms_home_edit.php?evid=$w00&status=$status¢er=$wcenter&leader=$wleader&type=q&viewer=$wviewer\"><img src=\"img/delete.png\" width=\"13\" height=\"13\" border=\"0\" alt=\"Delete Elements\"></a></td>";
}else{
echo "<td class=\"Text\" width=\"45%\" align=\"left\">" . addslashes($w05) . "</td>";
}
echo "</tr>";
}
}else{
echo "<tr>";
echo "<td class=\"Text\" width=\"10%\" align=\"center\">" . $arrLine[1] . "</td>";
echo "<td class=\"Text\" width=\"5%\" align=\"center\">" . $w02 . $str_wodsod ."</td>";
echo "<td class=\"Text\" width=\"13%\" align=\"center\"><a href=\"pdms_projecthome.php?evid=$w00&status=$wstatus¢er=$wcenter&leader=$wleader&viewer=$wviewer\">" . $w03 . "</a>$woldpjno</td>";
if ($wshowall=="True")
{
echo "<td class=\"Text\" width=\"5%\" align=\"center\"><a href=\"pdms_versionlog.php?evid=$w00&status=$wstatus¢er=$wcenter&leader=$wleader&viewer=$wviewer\">" . $w06 . "</a></td>";
}else{
echo "<td class=\"Text\" width=\"5%\" align=\"center\">" . $w06 . "</td>";
}
echo "<td class=\"Text\" width=\"22%\" align=\"left\"><a href=\"pdms_projecthome.php?evid=$w00&status=$wstatus¢er=$wcenter&leader=$wleader&viewer=$wviewer\">" . $w04 . "</a></td>";
if ($wshowall=="True")
{
echo "<td class=\"Text\" width=\"45%\" align=\"left\">" . addslashes($w05) . "<a href=\"pdms_home_edit.php?evid=$w00&status=$status¢er=$wcenter&leader=$wleader&type=e&viewer=$wviewer\"><img src=\"img/edit00.jpg\" width=\"15\" height=\"11\" border=\"0\" alt=\"Edit Elements\"></a> <a href=\"pdms_home_edit.php?evid=$w00&status=$status¢er=$wcenter&leader=$wleader&type=q&viewer=$wviewer\"><img src=\"img/delete.png\" width=\"13\" height=\"13\" border=\"0\" alt=\"Delete Elements\"></a></td>";
}else{
echo "<td class=\"Text\" width=\"45%\" align=\"left\">" . addslashes($w05) . "</td>";
}
echo "</tr>";
}
}
}else{
if ($wleader=="")
{
$LineSQL = "SELECT TRIM(line01) AS line01, TRIM(line02) AS line02 FROM pdms_line WHERE TRIM(line01)='$w01'";
$retLine = mysql_query($LineSQL, $connpdmdb);
$arrLine = mysql_fetch_array($retLine);
mysql_free_result($retLine);
echo "<tr>";
echo "<td class=\"Text\" width=\"10%\" align=\"center\">" . $arrLine[1] . "</td>";
echo "</tr>";
}else{
if (in_array("$w03", $OwnerProj))
{
$LineSQL = "SELECT TRIM(line01) AS line01, TRIM(line02) AS line02 FROM pdms_line WHERE TRIM(line01)='$w01'";
$retLine = mysql_query($LineSQL, $connpdmdb);
$arrLine = mysql_fetch_array($retLine);
mysql_free_result($retLine);
echo "<tr>";
echo "<td class=\"Text\" width=\"10%\" align=\"center\">" . $arrLine[1] . "</td>";
echo "<td class=\"Text\" width=\"5%\" align=\"center\">" . $w02 . $str_wodsod ."</td>";
echo "<td class=\"Text\" width=\"13%\" align=\"center\">" . $w03 . $woldpjno . "</td>";
echo "<td class=\"Text\" width=\"5%\" align=\"center\">" . $w06 . "</td>";
echo "<td class=\"Text\" width=\"22%\" align=\"left\">" . $w04 . "</td>";
echo "<td class=\"Text\" width=\"45%\" align=\"left\">" . addslashes($w05) . "</td>";
echo "</tr>";
}
}
}
}
mysql_free_result($result);
mysql_close($connpdmdb);
?>
</table>
</body>
</html>
如果整个系统都有的话就
mail:[email protected]
单个文件就不要了
我给你发了,你看看
邮件已经收到;看了一下
其实与一般的管理系统结构差不多1、pdms_home.php : 前台用来显示现有工程列表(包括工程的名称、描述、版本等);
3、pdms_home_edit_exec.php :完成添加新项到数据库中或更新数据库中某一项,并发送邮件给(pdms_home_edit.php)列表框中的收件人。