?? job_kf_info.php
字號:
<?php
session_start();
include "middle.php";
require_once "../MessageBox.php";
$Message = new MessageBox;
if ( !empty($_SESSION["userid"])) {
include "../datasource.inc.php";
$page = $_REQUEST['page'];
$id = $_REQUEST['id'];
$action = $_REQUEST['action'];
$job_body = str_replace("\n", "<BR>", $_REQUEST['job_body']);
$date = Date("Y-m-j");
if ($action == 'add') {
$sql = "insert into job_kf (id,userid,date,job_name,job_y,job_phone,job_address,job_email,job_qq,job_company,job_http,job_fl,job_body) values ('','$_SESSION[userid]','$date','$_REQUEST[job_name]','$_REQUEST[job_y]','$_REQUEST[job_phone]','$_REQUEST[job_address]','$_REQUEST[job_email]','$_REQUEST[job_qq]','$_REQUEST[job_company]','$_REQUEST[job_http]','$_REQUEST[job_fl]','$job_body');";
$result = mysql_query($sql);
$Message->setMessage("添加成功!","job_kf_info.php");
$Message->showMessage();
}
if ($_REQUEST['action'] == 'update') {
$sql = "update job_kf set date='$date',job_name='$_REQUEST[job_name]',job_y='$_REQUEST[job_y]',job_phone='$_REQUEST[job_phone]',job_address='$_REQUEST[job_address]',job_email='$_REQUEST[job_email]',job_qq='$_REQUEST[job_qq]',job_company='$_REQUEST[job_company]',job_http='$_REQUEST[job_http]',job_fl='$_REQUEST[job_fl]',job_body='$job_body' where id='$_REQUEST[id]';";
$result = mysql_query($sql);
$Message->setMessage("編輯成功!","job_kf_info.php");
$Message->showMessage();
}
?>
<link href="../css/a1.css" rel="stylesheet" type="text/css">
<body leftmargin="0" topmargin="0">
<table width="789" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2"><img src="../images/home_12.jpg" width="789" height="12"></td>
</tr>
<tr>
<td width="776" valign="top">
<table width="700" border="0" cellspacing="0" cellpadding="0">
<tr>
<TD vAlign=top><FONT color=#565656> <IMG height=14
src="../images/closedfold.gif" width=14> 您當前的位置<BR> <IMG
height=15 src="../images/bar.gif" width=15> <IMG height=14
src="../images/openfold.gif" width=14> 客戶跟蹤表</FONT></TD>
</tr>
</table>
<TABLE width=766 border=0 cellspacing=0 cellpadding=0 align="right">
<TR><TD width=766 height=1 bgcolor=#3494d4></TD></TR>
</TABLE>
<script language=javascript>
function check_input()
{
if (document.form.job_name.value=='') {
alert("請輸入客戶名稱!");
return false;
}
if (document.form.job_phone.value=='') {
alert("請輸入聯系電話!");
return false;
}
if (document.form.job_body.value=='') {
alert("請輸入備注內容!");
return false;
}
return true;
}
</script>
<?php
switch ($page){
case "add":
// if ($_SESSION["userid"]=="admin") {
?>
<center>
<form enctype="multipart/form-data" name=form method="post" action="job_kf_info.php" onsubmit="return check_input()">
<table border=0 cellpadding=0 cellspacing=1 bgcolor=#333333 width=766>
<tr>
<td width="15%" bgColor=#ffffff align=center>登記時間</td>
<td width="85%" bgcolor=ffffff>
<?php
echo "<input type=text size=30 name=job_date maxlength=8 height=24 value=$date>";
?> <font color=red>*</font> 號為必填項
</td>
</tr>
<tr>
<td width="15%" bgColor=#ffffff align=center>客戶名稱</td>
<td width="85%" bgcolor=ffffff>
<input type="text" size="30" name="job_name" maxlength="20" height=24> <font color=red>*</font>
</td>
</tr>
<tr>
<td width="15%" bgColor=#ffffff align=center>重點跟蹤</td>
<td width="85%" bgcolor=ffffff>
<select name="job_y">
<option value="一般">一般</option>
<option value="重點">重點</option>
<font color=red>*</font>
</td>
</tr>
<tr>
<td width="15%" bgColor=#ffffff align=center>聯系電話</td>
<td width="85%" bgcolor=ffffff>
<input type="text" size="30" name="job_phone" maxlength="40" height=24> <font color=red>*</font> 有多個電話、手機請用,分開
</td>
</tr>
<tr>
<td width="15%" bgColor=#ffffff align=center>聯系地址</td>
<td width="85%" bgcolor=ffffff>
<input type="text" size="30" name="job_address" maxlength="30" height=24>
</td>
</tr>
<tr>
<td width="15%" bgColor=#ffffff align=center>聯系EMAIL</td>
<td width="85%" bgcolor=ffffff>
<input type="text" size="30" name="job_email" maxlength="60" height=24>
</td>
</tr>
<tr>
<td width="15%" bgColor=#ffffff align=center>網絡通訊</td>
<td width="85%" bgcolor=ffffff>
<input type="text" size="30" name="job_qq" maxlength="40" height=24> 注：OICQ,MSN之類
</td>
</tr>
<tr>
<td width="15%" bgColor=#ffffff align=center>公司名稱</td>
<td width="85%" bgcolor=ffffff>
<input type="text" size="30" name="job_company" maxlength="30" height=24>
</td>
</tr>
<tr>
<td width="15%" bgColor=#ffffff align=center>公司網址</td>
<td width="85%" bgcolor=ffffff>
<input type="text" size="30" name="job_http" maxlength="40" height=24 value=http://>
</td>
</tr>
<tr>
<td width="15%" bgColor=#ffffff align=center>業務類型</td>
<td width="85%" bgcolor=ffffff>
<select name=job_fl>
<option value=網站建設>網站建設</option>
<option value=虛擬主機>虛擬主機</option>
<option value=數據庫>數據庫</option>
<option value=域名>域名</option>
<option value=主機租用>租用主機</option>
</select>
</td>
</tr>
<tr>
<td width="15%" bgColor=#ffffff align=center>備注(內容)</td>
<td width="85%" bgColor=#ffffff><textarea name="job_body" cols="60" rows="10">如：下個月需要做網站！</textarea> <font color=red>*</font></td>
</tr>
</table><br>
<input type="hidden" value="add" name="action">
<input type="hidden" name="MAX_FILE_SIZE" value="1000000">
<input type="submit" value="提 交" > <input type="reset" value="取 消">
</form>
</center>
<?
//}
break;
case "delete":
/*$sql = "select * from job_kf where id='$id';";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$dele = `rm $row['job_pic1']`;
$dele = `rm $row['job_pic2']`;
$dele = `rm $row['job_pic3']`;
$dele = `rm $row['job_pic4']`;
*/
$query = "delete from job_kf where id='$id';";
mysql_query($query);
$Message->setMessage("刪除成功!","job_kf_info.php");
$Message->showMessage();
break;
case "update":
$sql = "select * from job_kf where id='$id';";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$id = $row['id'];
$job_name = $row['job_name'];
$job_body = str_replace("<BR>", "\n", $row['job_body']);
?>
<form enctype="multipart/form-data" name=form method="post" action="job_kf_info.php" onsubmit="return check_input()">
<center>
<table border=0 cellpadding=0 cellspacing=0 width=776>
<tr><td width=10 bgcolor=#ffffff> </td>
<td><table border=0 cellpadding=0 cellspacing=1 bgcolor=#3494d4 width=766>
<tr>
<td width="15%" bgColor=#ffffff align=center>登記時間</td>
<td width="85%" bgcolor=ffffff>
<?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%" bgColor=#ffffff align=center>客戶名稱</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%" bgColor=#ffffff align=center>重點跟蹤</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>";
?>
<font color=red>*</font>
</td>
</tr>
<tr>
<td width="15%" bgColor=#ffffff align=center>聯系電話</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%" bgColor=#ffffff align=center>聯系地址</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%" bgColor=#ffffff align=center>聯系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%" bgColor=#ffffff align=center>網絡通訊</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%" bgColor=#ffffff align=center>公司名稱</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>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -