📄 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 + -