📄 index.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
<?
include_once("inc/auth.php");
?>

<html>
<head>
<title>服务型产品管理 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
  function set_page()
{
 PAGE_START=PAGE_NUM.value;
 location="index.php?SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&CUR_PAGE="+PAGE_START;
}

  function delete_linkman(SERVICE_ID)
{
 msg='确认要删除该服务型产品信息？';
 if(window.confirm(msg))
 {
  URL="delete.php?SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&CUR_PAGE=<?=$CUR_PAGE?>&SERVICE_ID="+SERVICE_ID ;
  window.location=URL;
 }
}
function check_one(el)
{
   if(!el.checked)
      document.all("allbox").checked=false;
}
function check_all()
{
 for (i=0;i<document.all("email_select").length;i++)
 {
   if(document.all("allbox").checked)
      document.all("email_select").item(i).checked=true;
   else
      document.all("email_select").item(i).checked=false;
 }

 if(i==0)
 {
   if(document.all("allbox").checked)
      document.all("email_select").checked=true;
   else
      document.all("email_select").checked=false;
 }
}
function delete_mail()
{
  delete_str="";
  for(i=0;i<document.all("email_select").length;i++)
  {

      el=document.all("email_select").item(i);
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }

  if(i==0)
  {
      el=document.all("email_select");
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }

  if(delete_str=="")
  {
     alert("请至少选择其中一个服务产品。");
     return;
  }

  msg='确认要删除所选服务产品？';
  if(window.confirm(msg))
  {
    URL="delete.php?SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&CUR_PAGE=<?=$CUR_PAGE?>&delete_str="+delete_str ;
    window.location=URL;
  }
}

</script>
</head>
<body>
<div align="left">
<fieldset style="width:95%;padding-bottom:5px;">
	 <legend class="small" align=left>
      <b>快速查询</b>
  </legend>
<table cellspacing="1" class="small" align="left" cellpadding="3">
   <form action="index.php"  method="post" name="form1">
  <tr>
    <td nowrap class="TableData">&nbsp;&nbsp;服务提供商： </td>
    <td nowrap class="TableData">
    	  <input type="hidden" name="PROVIDER_ID" value="<?=$PROVIDER_ID?>">
        <input type="text" name="PROVIDER_NAME" class="SmallInput" size="15" maxlength="100">&nbsp;
    </td>
     <td nowrap class="TableData">&nbsp;&nbsp;服务名称： </td>
     <td nowrap class="TableData"colspan="3">
        <input type="text" name="SERVICE_NAME" class="SmallInput" size="20" maxlength="100">
     </td>
   </tr>
   <tr>
    <td nowrap class="TableData">&nbsp;&nbsp;服务描述： </td>
    <td nowrap class="TableData" colspan=5>
       <textarea cols=37 rows=2 name="SERVICE_DESC" class="SmallInput" wrap="yes"><?=$MEMO?></textarea>
       &nbsp;&nbsp;<input value="快速查询" type="submit" class="SmallButton" title="模糊查询" name="button">
    </td>
   </tr>
 </form>
</table>
</fieldset>
</div>
<br>
<br>
<?
//-----------先组织SQL语句-----------
  if($SERVICE_NAME!="")
 {
     if($WHERE_STR=="")
         $WHERE_STR.=" where SERVICE_NAME like '%".$SERVICE_NAME."%'";
     else
         $WHERE_STR.=" and SERVICE_NAME like '%".$SERVICE_NAME."%'";
 }
  if($SERVICE_DESC!="")
 {
     if($WHERE_STR=="")
         $WHERE_STR.=" where SERVICE_DESC like '%".$SERVICE_DESC."%'";
     else
         $WHERE_STR.=" and SERVICE_DESC like '%".$SERVICE_DESC."%'";
 }
if($PROVIDER_NAME!="")
   {
     if($WHERE_STR=="")
         $WHERE_STR.=" where PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
     else
         $WHERE_STR.=" and PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
   }

 $query="SELECT count(*) FROM `SERVICE` a
         LEFT OUTER JOIN PROVIDER c
         ON a.PROVIDER_ID = c.PROVIDER_ID";

 $query.=$WHERE_STR;
 //echo  $query;
 $cursor= exequery($connection,$query);
 $LINKMAN_COUNT=0;
 if($ROW=mysql_fetch_array($cursor))
    $LINKMAN_COUNT=$ROW[0];

 $PER_PAGE=10;
 $PAGE_COUNT=ceil($LINKMAN_COUNT/$PER_PAGE);
 if($CUR_PAGE<=0 || $CUR_PAGE=="")
    $CUR_PAGE=1;
 if($CUR_PAGE>$PAGE_COUNT)
    $CUR_PAGE=$PAGE_COUNT;
$query1="SELECT * FROM SERVICE a
         LEFT OUTER JOIN PROVIDER c
         ON a.PROVIDER_ID = c.PROVIDER_ID".$WHERE_STR;
$offest=($CUR_PAGE-1)*10;
$query1=$query1." LIMIT ". $offest." ,".$PER_PAGE;

$cursor1 = exequery($connection, $query1);

  if($LINKMAN_COUNT==0)
  {
     Message("<br>提示","没有符合条件的服务型产品信息");
?>
<br>

<?
     exit;
  }
  else
  {
?>

<table border="0" cellspacing="1" width="95%" class="small"  cellpadding="3">
  <tr>
    <td align="left">
        <a href="index.php?CUR_PAGE=1&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>"><img src='/images/first02.gif' width='24' border='0' height='15' alt='首页'></a>
        <a href="index.php?CUR_PAGE=<?=$CUR_PAGE-1?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>"><img src='/images/first01.gif' width='24' border='0' height='15' alt='上一页'></a>
        <a href="index.php?CUR_PAGE=<?=$CUR_PAGE+1?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>"><img src='/images/last01.gif' width='24' border='0' height='15' alt='下一页' style="cursor:hand"></a>
        <a href="index.php?CUR_PAGE=<?=$PAGE_COUNT?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>"><img src='/images/last02.gif'  width='24' border='0' height='15' alt='末页' style="cursor:hand"></a>

      到
      <input type="text" name="PAGE_NUM" size="3" maxlength="4"  class="SmallInput">
      页
      <img id="btnGotoPage" src="/images/menu/book.gif" onclick="set_page()" border="0" WIDTH="19" HEIGHT="17" style="cursor:hand" alt="转到相应页面">
    </td>
    <td align="right">
      <?=$CUR_PAGE?>/<?=$PAGE_COUNT?>页&nbsp;共&nbsp;<?=$LINKMAN_COUNT?>&nbsp;条
    </td>
  </tr>
</table>


<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">

<?
  $LINKMAN_COUNT = 0;
  while($ROW=mysql_fetch_array($cursor1))
  {
    $LINKMAN_COUNT++;
    $SERVICE_ID1=$ROW["SERVICE_ID"];
    $SERVICE_NAME1=$ROW["SERVICE_NAME"];
    $PROVIDER_ID1=$ROW["PROVIDER_ID"];
    $SERVICE_DESC1=$ROW["SERVICE_DESC"];
    $STANDARD_PRICE1=$ROW["STANDARD_PRICE"];
    $PROVIDER_NAME1=$ROW["PROVIDER_NAME"];
   if($LINKMAN_COUNT%2==1)
     $TableLine="TableLine1";
   else
     $TableLine="TableLine2";

?>

    <tr class="<?=$TableLine?>">
    	<td>&nbsp;<input type="checkbox" name="email_select" value="<?=$SERVICE_ID1?>" onClick="check_one(self);"></td>
    	 <td nowrap align="center"><?=$SERVICE_NAME1?></td>
      <td nowrap align="center"><?=$SERVICE_DESC1?></td>
       <td nowrap align="center"><?=$STANDARD_PRICE1?></td>
      <td nowrap align="center"><?=$PROVIDER_NAME1?></td>
      <td nowrap align="center" width="80">

    <a href="edit.php?SERVICE_ID=<?=$SERVICE_ID1?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&CUR_PAGE=<?=$CUR_PAGE?>"> 编辑</a>&nbsp;&nbsp;
        <a href="javascript:delete_linkman(<?=$SERVICE_ID1?>);"> 删除 </a>
      </td>
    </tr>
<?
  }
}
?>
 <tr class="TableControl">
 <td colspan="10">
 	   &nbsp;<input type="checkbox" name="allbox" id="allbox_for" onClick="check_all();">
      <label for="allbox_for">全选</label> &nbsp;
      <input type="button"  value="批量删除" class="SmallButton" onClick="delete_mail();" title="删除所选客户"> &nbsp;
 </td>
</tr>
  <thead class="TableHeader">
      <td nowrap align="center">选择</td>
      <td nowrap align="center">服务名称</td>
      <td nowrap align="center">服务描述</td>
      <td nowrap align="center">服务收费标准</td>
      <td nowrap align="center">供应商</td>
      <td nowrap align="center">操作</td>
  </thead>
</table>
</body>
</html>
💿 文件大小 24085 K
👤 上传用户 happy_christina
📂 所属分类 OA系统
🏷️ 相关标签

#Automation #Office #3.0 #100
⌨️ 快捷键说明

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