?? job_kf.php
字號:
echo "<input type=text size=30 name=job_date maxlength=8 height=24 value=$row[date]>";
?>
<font color=red>*</font> 號為必填項
</td>
<tr>
<td width="15%" align=center bgColor=#ffffff>公司名稱</td>
<td width="85%" bgcolor=ffffff>
<?php echo "<input type=text size=30 name=job_name maxlength=20 height=24 value=\"$row[job_name]\">" ?> <font color=red>*</font>
</td>
</tr>
<tr>
<td width="15%" align=center bgColor=#ffffff>跟蹤情況</td>
<td width="85%" bgcolor=ffffff>
<select name="job_y">
<?php
echo "<option value=\"$row[job_y]\">$row[job_y]</option>";
echo "<option value=\"重點\">重點</option>";
echo "<option value=\"一般\">一般</option>";
?></select>
<font color=red>*</font>
</td>
</tr>
<tr>
<td width="15%" align=center bgColor=#ffffff>聯系人</td>
<td width="85%" bgcolor=ffffff>
<?php echo "<input type=text size=30 name=job_company maxlength=30 height=24 value=\"$row[job_company]\">"; ?>
</td>
</tr>
<tr>
<td width="15%" align=center bgColor=#ffffff>聯系電話</td>
<td width="85%" bgcolor=ffffff>
<?php echo "<input type=text size=30 name=job_phone maxlength=40 height=24 value=\"$row[job_phone]\">" ?> <font color=red>*</font> 有多個電話、手機請用,分開
</td>
</tr>
<tr>
<td width="15%" align=center bgColor=#ffffff>聯系地址</td>
<td width="85%" bgcolor=ffffff>
<?php echo "<input type=text size=30 name=job_address maxlength=30 height=24 value=\"$row[job_address]\">"; ?>
</td>
</tr>
<tr>
<td width="15%" align=center bgColor=#ffffff>聯系EMAIL</td>
<td width="85%" bgcolor=ffffff>
<?php echo "<input type=text size=30 name=job_email maxlength=60 height=24 value=\"$row[job_email]\">"; ?>
</td>
</tr>
<tr>
<td width="15%" align=center bgColor=#ffffff>網絡通訊</td>
<td width="85%" bgcolor=ffffff>
<?php echo "<input type=text size=30 name=job_qq maxlength=30 height=24 value=\"$row[job_qq]\">"; ?> 注：OICQ,MSN之類
</td>
</tr>
<tr>
<td width="15%" align=center bgColor=#ffffff>公司網址</td>
<td width="85%" bgcolor=ffffff>
<?php echo "<input type=text size=30 name=job_http maxlength=40 height=24 value=\"$row[job_http]\">"; ?>
</td>
</tr>
<tr>
<td width="15%" align=center bgColor=#ffffff>業務類型</td>
<td width="85%" bgcolor=ffffff>
<select name=job_fl>
<?php echo "<option value=$row[job_fl]>$row[job_fl]</option>"; ?>
<option value=網站、推廣>網站、推廣</option>
<option value=主機、郵局>主機、郵局</option>
<option value=域名、數據庫>域名、數據庫</option>
<option value=主機租用、托管>主機租用、托管</option>
<option value=其他業務>其他業務</option>
</select>
</td>
</tr>
<tr>
<td width="15%" align=center bgColor=#ffffff>備注(內容)</td>
<td width="85%" bgColor=#ffffff> <textarea name="job_body" cols="60" rows="6">
<?php echo "$job_body";?>
</textarea> <font color=red>*</font></td>
</tr>
</table></td></tr></table>
<br>
<input type="hidden" value="update" name="action">
<?php echo "<input type=hidden name=id value=$id>"; ?>
<?php echo "<input type=hidden name=department value=$_SESSION[department]>"; ?>
<input type="hidden" name="MAX_FILE_SIZE" value="1000000">
<input type="submit" name="submit" value=" 確 定 "> <input type="reset" name="submit1" value=" 重 置 ">
</form>
</center>
<?php
break;
default:
echo "<center>";
echo "<form action=job_kf.php method=post>";
echo "<table border=0 width=776 cellpadding=0 cellspacing=0>";
echo "<tr>";
echo "<td width=10> </td>";
echo "<td bgColor=#ffffff align=left>";
echo "按客戶名稱查詢：<input type=text size=20 name=search maxlength=20>";
echo " 跟蹤: <select name=\"job_y\"><option value=\"重點\">重點</option><option value=\"一般\">一般</option></select> <input type=submit value=搜索>";
echo "</td>";
echo "</tr>";
echo "</table>";
echo "</form>";
if ($_SESSION["userjs"] == "2"){
if ($_REQUEST['search']){
$sql = "select * from job_kf where (job_name like '%$_REQUEST[search]%') and (userid='$_SESSION[userid]') and (job_y='$_REQUEST[job_y]') and (department='$_SESSION[department]')order by id desc;";
} else {
if ( $_REQUEST['job_y'] ){
$sql = "select * from job_kf where department='$_SESSION[department]' and job_y='$_REQUEST[job_y]' order by id desc;";
} else {
$sql = "select * from job_kf where department='$_SESSION[department]' order by id desc;";
}
}
} else {
if ($_REQUEST['search']){
$sql = "select * from job_kf where (job_name like '%$_REQUEST[search]%') and (userid='$_SESSION[userid]') and (job_y='$_REQUEST[job_y]') order by id desc;";
} else {
if ( $_REQUEST['job_y']){
$sql = "select * from job_kf where userid='$_SESSION[userid]' and job_y='$_REQUEST[job_y]' order by id desc;";
} else {
$sql = "select * from job_kf where userid='$_SESSION[userid]' order by id desc;";
}
}
}
$result = mysql_query($sql);
$num = mysql_num_rows($result);
if ( $num>0 ){
$last = intval(($num-1)/40)+1;
if ( $page < 1 ) $page=1;
if ( $page > $last ) $page=$last;
mysql_data_seek($result,($page-1)*40);
echo "<table border=0 cellpadding=0 cellspacing=0 width=776>";
echo "<tr><td width=10 bgcolor=#ffffff> </td>";
echo "<td><table boder=0 cellpadding=0 cellspacing=1 bgColor=#3494d4 width=766>";
echo "<tr height=24>";
//echo "<table boder=0 bgcolor=#ffffff cellpadding=0 cellspacing=1 width=766>";
echo "<td width=120 bgColor=#3494d4 align=center><font color=#ffffff><b>填表時間</b></font></td>";
echo "<td width=120 bgColor=#3494d4 align=center><font color=#ffffff><b>跟蹤情況</b></font></td>";
echo "<td width=120 bgColor=#3494d4 align=center><font color=#ffffff><b>業務類型</b></font></td>";
echo "<td width=200 bgColor=#3494d4 align=center><font color=#ffffff><b>公司名稱</b></font></td>";
echo "<td width=200 bgColor=#3494d4 align=center><font color=#ffffff><b>聯系電話</b></font></td>";
echo "<td width=100 bgColor=#3494d4 align=center><font color=#ffffff><b>查看</b></font></td>";
echo "<td width=40 bgColor=#3494d4 align=center><font color=#ffffff><b>編輯</b></font></td>";
echo "<td width=40 bgColor=#3494d4 align=center><font color=#ffffff><b>刪除</b></font></td>";
echo "</tr>";
//echo "<tr><table border=0 cellpadding=0 cellspacing=1 bgcolor=#3494d4 width=766>";
for ( $i=0;$i<40;$i++ ) {
$row = mysql_fetch_array($result);
$id = $row['id'];
if ( $id ) {
echo "<tr bgColor=#ffffff>";
echo "<td width=120 height=20 bgColor=#ffffff><div align=center>$row[date]</div></td>";
if ( $row['job_y'] == "重點" ) {
echo "<td width=120 height=20 bgColor=#ffffff><div align=center>$row[job_y]</div></td>";
} else {
echo "<td width=120 height=20 bgColor=#ffffff><div align=center>$row[job_y]</div></td>";
}
echo "<td width=120 height=20 bgColor=#ffffff><div align=center>$row[job_fl]</div></td>";
echo "<td width=200 height=20 bgColor=#ffffff><div align=center>$row[job_name]</div></td>";
echo "<td width=200 height=20 bgColor=#ffffff><div align=center>$row[job_phone]</div></td>";
echo "<td width=100 height=20 bgColor=#ffffff><div align=center><a href=# onClick=\"window.open('job_kf_show.php?id=$row[id]',1,'top=50,left=50,height=450,width=450,scrollbars=yes')\">查看</a></div></td>";
echo "<td width=40 height=20 bgColor=#ffffff><div align=center><a title=點擊編輯內容 href=job_kf.php?page=update&id=$row[id]><img src=../images/editicon.gif border=0></a></div></td>";
echo "<td width=40 height=20 bgColor=#ffffff><div align=center><a title=點擊刪除內容 href=job_kf.php?page=delete&id=$row[id] onclick=\"return confirm('是否確定刪除此記錄')\"><img src=../images/clearicon.gif border=0></a></div></td>";
echo "</tr>";
}
}
echo "</table></td></table><br>";
echo "<table width=500 border=0 cellspacing=0 cellpadding=0 height=24>";
echo "<tbody>";
echo "<tr><td><center>";
echo "總共找到<font color=red>$num</font>條記錄,第<font color=red>$page</font>頁,共<font color=red>$last</font>頁。";
echo "</center></td></tr><tr>";
if ( $page <> 1 ) {
echo "<td align=center> <a href=job_kf.php?page=1>第一頁</a></td>";
echo "<td align=center><a href=job_kf.php?page=".($page-1).">上一頁</a></td>";
}
if ( $page <> $last ) {
echo "<td align=center><a href=job_kf.php?page=".($page+1).">下一頁</a></td>";
echo "<td align=center><a href=job_kf.php?page=$last>最后一頁</a></td>";
}
echo "</tbody>";
echo "</tr>";
echo "</table><br>";
echo "</center>";
} else {
echo "<center>對不起，您還沒有添加記錄,<a href=job_kf.php?page=add>我要添加</a>!</center>";
}
break;
}
} else {
$Message->setMessage("對不起，您沒有權限進入后臺管理!","index.php");
$Message->showMessage();
}
?>
</td>
<td width="13" align="right" background="../images/home_16.jpg" height="457"> </td>
</tr>
<tr>
<td height="8" colspan="2" valign="top"><img src="../images/home_24.jpg" width="789" height="8"></td>
</tr>
</table>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -