⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 job_kf_info.php

📁 开源的OA系统
💻 PHP
📖 第 1 页 / 共 2 页
字号:
    <td width="15%" bgColor=#ffffff align=center>公司网址</td>
    <td width="85%" bgcolor=ffffff> 
      &nbsp;<?php echo "<input type=text size=30 name=job_http maxlength=40 height=24 value=\"$row[job_http]\">"; ?>    	  	  	  	  	  
    </td>
  </tr> 
  <tr> 
    <td width="15%" bgColor=#ffffff align=center>业务类型</td>
    <td width="85%" bgcolor=ffffff> 
    &nbsp;<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%" bgColor=#ffffff align=center>备注(内容)</td>
    <td width="85%" bgColor=#ffffff>&nbsp;<textarea name="job_body" cols="60" rows="10">
	<?php echo "$job_body";?>
	</textarea>&nbsp;<font color=red>*</font></td>
  </tr> 
</table></td></table>
<br>
<input type="hidden" value="update" name="action">
<?php echo "<input type=hidden name=id  value=$id>"; ?>  
<input type="hidden" name="MAX_FILE_SIZE" value="1000000">
<input type="submit" name="submit" value=" 确&nbsp;定 ">&nbsp;&nbsp;<input type="reset" name="submit1" value=" 重&nbsp;置 ">
</form>
</center>
<?php
    break;

	case "text":
         $sql     = "select * from job_kf where id='$id';";
         $result  = mysql_query($sql);
         $row     = mysql_fetch_array($result);
		 $job_body         = str_replace("<BR>", "\n", $row['job_body']);
		 
?>
<br>
<center>
<table border=0 cellpadding=0 cellspacing=0 width=776>
 <tr><td width=10 bgcolor=#ffffff>&nbsp;</td> 
 <td><table border=0 cellpadding=0 cellspacing=1 bgcolor=#3494d4 width=766 height=400>
  <tr> 
    <td width="15%" bgColor=#ffffff align=center>填表时间</td>
    <td width="85%" bgcolor=ffffff> 
    &nbsp;<?php echo "$row[date]"; ?>
    </td>
  </tr>
  <tr> 
    <td width="15%" bgColor=#ffffff align=center>填表人</td>
    <td width="85%" bgcolor=ffffff> 
    &nbsp;<?php echo "$row[userid]"; ?>
    </td>
  </tr>
  <tr> 
    <td width="15%" bgColor=#ffffff align=center>客户名称</td>
    <td width="85%" bgcolor=ffffff> 
    &nbsp;<?php echo "$row[job_name]"; ?>
    </td>
  </tr>
  <tr> 
    <td width="15%" bgColor=#ffffff align=center>重点跟踪</td>
    <td width="85%" bgcolor=ffffff> 
    &nbsp;<?php echo "$row[job_y]"; ?>
    </td>
  </tr>
  
  <tr> 
    <td width="15%" bgColor=#ffffff align=center>联系电话</td>
    <td width="85%" bgcolor=ffffff> 
    &nbsp;<?php echo "$row[job_phone]"; ?>
    </td>
  </tr>
  <tr> 
    <td width="15%" bgColor=#ffffff align=center>联系地址</td>
    <td width="85%" bgcolor=ffffff> 
    &nbsp;<?php echo "$row[job_address]"; ?>
    </td>
  </tr>
  <tr> 
    <td width="15%" bgColor=#ffffff align=center>联系EMAIL</td>
    <td width="85%" bgcolor=ffffff> 
    &nbsp;<?php echo "$row[job_email]"; ?>
    </td>
  </tr>
  <tr> 
    <td width="15%" bgColor=#ffffff align=center>网络通讯</td>
    <td width="85%" bgcolor=ffffff> 
    &nbsp;<?php echo "$row[job_qq]"; ?>
    </td>
  </tr>  
  <tr> 
    <td width="15%" bgColor=#ffffff align=center>公司名称</td>
    <td width="85%" bgcolor=ffffff> 
    &nbsp;<?php echo "$row[job_company]"; ?>
    </td>
  </tr>
  <tr> 
    <td width="15%" bgColor=#ffffff align=center>公司网址</td>
    <td width="85%" bgcolor=ffffff> 
    &nbsp;<?php echo "$row[job_http]"; ?>
    </td>
  </tr> 
  <tr> 
    <td width="15%" bgColor=#ffffff align=center>业务类型</td>
    <td width="85%" bgcolor=ffffff> 
    &nbsp;<?php echo "$row[job_fl]"; ?>
	</td>
  </tr>
  <tr> 
    <td width="15%" bgColor=#ffffff align=center>备注(内容)</td>
    <td width="85%" bgColor=#ffffff>&nbsp;<?php echo "$job_body"; ?></td>
  </tr>  
</table></td></table>


<br><a href="job_kf_info.php">返回</a>
</center>
<?php
	break;
	default:
    echo "<center>";
	echo "<form action=job_kf_info.php method=post>";
    echo "<table border=0 width=776 cellpadding=0 cellspacing=0>";
    echo "<tr>";
	echo "<td width=10 bgcolor=#ffffff>&nbsp;</td>";
    echo "<td bgColor=#ffffff align=left>";
	echo "按客户名称查询:<input type=text size=20 name=search maxlength=20>";
    echo "&nbsp;&nbsp;跟踪:&nbsp;<select name=\"job_y\"><option value=\"重点\">重点</option><option value=\"一般\">一般</option></select>&nbsp;&nbsp;<input type=submit value=搜索>";
	echo "</td>";
    echo "</tr>";
    echo "</table>";
    echo "</form>";
	if ($_REQUEST['search']){
	    if ( $_SESSION["userjs"]=='0'  ) {
            $sql    = "select * from job_kf where job_name like '%$_REQUEST[search]%' and job_y='$_REQUEST[job_y]' order by date desc;";		
		} else {
		    $sql    = "select * from job_kf where (job_name like '%$_REQUEST[search]%') and (userid='$_SESSION[userid]') and (job_y='$_REQUEST[job_y]') order by date desc;";
		}
	} else {
	    if ( $_SESSION["userjs"]=='0'  ) {
		    if ( $_REQUEST['job_y']) {
			    $sql    = "select * from job_kf where job_y='$_REQUEST[job_y]' order by date desc;";	
			} else {
			   $sql    = "select * from job_kf order by date desc;";	
			}
		    
		} else {
		    if ( $_REQUEST['job_y']) {
 		       $sql    = "select * from job_kf where userid='$_SESSION[userid]' and job_y='$_REQUEST[job_y]' order by date desc;";	
			} else {
 		       $sql    = "select * from job_kf where userid='$_SESSION[userid]' order by date 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>&nbsp;</td>";
	echo "<td><table border=0 cellpadding=0 cellspacing=1 bgcolor=#3494d4 width=766>";
    echo "<tr>";
    echo "<td width=120 height=18 bgColor=#3494d4 align=center><div align=center><b><font color=#ffffff>填表时间</font></b></div></td>";    			
    echo "<td width=120 height=18 bgColor=#3494d4 align=center><div align=center><b><font color=#ffffff>重点跟踪</font></b></div></td>";	
    echo "<td width=120 height=18 bgColor=#3494d4 align=center><div align=center><b><font color=#ffffff>业务类型</font></b></div></td>";    		
    echo "<td width=200 height=18 bgColor=#3494d4 align=center><div align=center><b><font color=#ffffff>客户名称</font></b></div></td>";    	
	echo "<td width=200 height=18 bgColor=#3494d4 align=center><div align=center><b><font color=#ffffff>联系电话</font></b></div></td>";
    if ($_SESSION["userjs"]=='0' ) {
	    echo "<td width=100 height=18 bgColor=#3494d4 align=center><div align=center><b><font color=#ffffff>填表人</font></b></div></td>";
	}	
	echo "<td width=100 height=18 bgColor=#3494d4 align=center><div align=center><b><font color=#ffffff>查看</font></b></div></td>";	
    echo "<td width=40 height=18 bgColor=#3494d4 align=center><div align=center><b><font color=#ffffff>编辑</font></b></div></td>";	
    echo "<td width=40 height=18 bgColor=#3494d4 align=center><div align=center><b><font color=#ffffff>删除</font></b></div></td>";		 		 	 		 
    echo "</tr>"; 		 	
	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=18 bgColor=#ffffff><div align=center>$row[date]</div></td>";			 			 
			 if ( $row['job_y'] == "重点" ) {
			     echo "<td width=120 height=18 bgColor=#ffffff><div align=center>$row[job_y]</div></td>";
			 } else {
			     echo "<td width=120 height=18 bgColor=#ffffff><div align=center>$row[job_y]</div></td>";			 
			 }
			 
			 echo "<td width=120 height=18 bgColor=#ffffff><div align=center>$row[job_fl]</div></td>";			 
			 echo "<td width=200 height=18 bgColor=#ffffff><div align=center>$row[job_name]</div></td>";
			 echo "<td width=200 height=18 bgColor=#ffffff><div align=center>$row[job_phone]</div></td>";
             if ($_SESSION["userjs"]=='0' ) {
	             echo "<td width=100 height=18 bgColor=#ffffff><div align=center>$row[userid]</div></td>";
	         }	
			 echo "<td width=100 height=18 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=18 bgColor=#ffffff><div align=center><a title=点击编辑内容 href=job_kf_info.php?page=update&id=$row[id]><img src=../images/editicon.gif border=0></a></div></td>";			 
             echo "<td width=40 height=18 bgColor=#ffffff><div align=center><a title=点击删除内容 href=job_kf_info.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 colspan=4><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>&nbsp;&nbsp;&nbsp;<a href=job_kf_info.php?page=1>第一页</a></td>";
              echo "<td align=center><a href=job_kf_info.php?page=".($page-1).">上一页</a></td>";
          }
          if ( $page <> $last ) {
              echo "<td align=center><a href=job_kf_info.php?page=".($page+1).">下一页</a></td>";
              echo "<td align=center><a href=job_kf_info.php?page=$last>最后一页</a></td>";
          }
          echo "</tbody>";
          echo "</tr>";
          echo "</table><br>";
		  echo "</center>";
   } else {
      echo "<center>对不起,您还没有添加记录,<a href=job_kf_info.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">&nbsp;</td>
  </tr>
  <tr>
    <td height="8" colspan="2" valign="top"><img src="../images/home_24.jpg" width="789"></td>
  </tr>
</table>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -