index.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 847 行 · 第 1/2 页

PHP
847 行
字号
12
<?
  function getalldate ($CODE)
  {
    global $connection;
    $query = (((''.'SELECT * from SYS_CODE where PARENT_NO=\'').$CODE).'\'');
    $cursor = exequery ($connection, $query);
    echo '<option value= ></option>';
    while ($ROW = mysql_fetch_array ($cursor))
    {
      $CODE_NO = $ROW['CODE_NO'];
      $CODE_NAME = $ROW['CODE_NAME'];
      echo (((('<option value='.$CODE_NO).'>').$CODE_NAME).'</option>');
    }
  }
  include_once 'inc/auth.php';
  echo '
<html>
<head>
<title>产品管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
  function set_page()
{
 PAGE_START=PAGE_NUM.value;
 location="index.php?PRODUCT_NAME=';
  echo $PRODUCT_NAME;
  echo '&PRODUCT_TYPE=';
  echo $PRODUCT_TYPE;
  echo '&PRODUCT_DESC=';
  echo $PRODUCT_DESC;
  echo '&PRODUCT_MODE=';
  echo $PRODUCT_MODE;
  echo '&ORDERFIELD=';
  echo $ORDERFIELD;
  echo '&ORDERTYPE=';
  echo $ORDERTYPE;
  echo '&PROVIDER_NAME=';
  echo $PROVIDER_NAME;
  echo '&CUR_PAGE="+PAGE_START;
}
  function delete_linkman(PRODUCT_ID)
{
 msg=\'确认要删除该产品信息？\';
 if(window.confirm(msg))
 {
  URL="delete.php?PRODUCT_NAME=';
  echo $PRODUCT_NAME;
  echo '&PRODUCT_TYPE=';
  echo $PRODUCT_TYPE;
  echo '&PRODUCT_DESC=';
  echo $PRODUCT_DESC;
  echo '&PRODUCT_MODE=';
  echo $PRODUCT_MODE;
  echo '&PROVIDER_NAME=';
  echo $PROVIDER_NAME;
  echo '&ORDERFIELD=';
  echo $ORDERFIELD;
  echo '&ORDERTYPE=';
  echo $ORDERTYPE;
  echo '&CUR_PAGE=';
  echo $CUR_PAGE;
  echo '&PRODUCT_ID="+PRODUCT_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;
';
  echo '
 }
 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+=va';
  echo 'l + ",";
      }
  }
  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?PRODUCT_NAME=';
  echo $PRODUCT_NAME;
  echo '&PRODUCT_TYPE=';
  echo $PRODUCT_TYPE;
  echo '&PRODUCT_DESC=';
  echo $PRODUCT_DESC;
  echo '&PRODUCT_MODE=';
  echo $PRODUCT_MODE;
  echo '&PROVIDER_NAME=';
  echo $PROVIDER_NAME;
  echo '&ORDERFIELD=';
  echo $ORDERFIELD;
  echo '&ORDERTYPE=';
  echo $ORDERTYPE;
  echo '&CUR_PAGE=';
  echo $CUR_PAGE;
  echo '&delete_str="+delete_str ;
    window.location=URL;
  }
}
function view_photo(PHOTO)
{
  URL="view_photo.php?PHOTO="+PHOTO;
  myleft=(screen.availWidth-650)/2;
  window.open(URL,"view_photo","height=300,width=550,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
</script>
</head>
<body>
<div align="left">
<fieldset style="width:95%;p';
  echo 'adding-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="text" name="PROVIDER_NAME" class="SmallInput" size="15" maxlength';
  echo '="100">&nbsp;
    </td>
     <td nowrap class="TableData">产品名称： </td>
    <td nowrap class="TableData">
        <input type="text" name="PRODUCT_NAME" class="SmallInput" size="15" maxlength="100">
    </td>
   <td nowrap class="TableData">产品型号： </td>
    <td nowrap class="TableData">
        <input type="text" name="PRODUCT_TYPE" class="SmallInput" size="15" maxlength="100">
    </td>
   ';
  echo ' <td nowrap class="TableData">	&nbsp;&nbsp;	&nbsp;&nbsp;
    	 </td>
   </tr>
    <tr>
    <td nowrap class="TableData">&nbsp;&nbsp;产品类别：</td>
    <td nowrap class="TableData">
      ';
  echo '<s';
  echo 'elect name="PRODUCT_MODE" class="SmallSelect">
';
  getalldate ('PRODUCT_MODE');
  echo '      </select>
    </td>
    <td nowrap class="TableData">产品描述： </td>
    <td nowrap class="TableData" colspan=4>
       <textarea cols=37 rows=2 name="PRODUCT_DESC" class="SmallInput" wrap="yes">';
  echo $MEMO;
  echo '</textarea>
    	&nbsp;&nbsp;<input value="快速查询" type="submit" class="SmallButton" title="模糊查询" name="button">
    </td>
   </tr>
 </form>
</table>
</fieldset>
</div>
<br>
';
  if (($PRODUCT_NAME != ''))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where PRODUCT_NAME like \'%'.$PRODUCT_NAME).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and PRODUCT_NAME like \'%'.$PRODUCT_NAME).'%\''));
    }
  }
  if (($PRODUCT_TYPE != ''))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where PRODUCT_TYPE like \'%'.$PRODUCT_TYPE).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and PRODUCT_TYPE like \'%'.$PRODUCT_TYPE).'%\''));
    }
  }
  if (($PRODUCT_DESC != ''))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where PRODUCT_DESC like \'%'.$PRODUCT_DESC).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and PRODUCT_DESC like \'%'.$PRODUCT_DESC).'%\''));
    }
  }
  if (($PRODUCT_MODE != ''))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= (((''.' where PRODUCT_MODE =\'').$PRODUCT_MODE).'\''));
    }
    else
    {
      ($WHERE_STR .= (((''.' and PRODUCT_MODE =\'').$PRODUCT_MODE).'\''));
    }
  }
  if (($PROVIDER_NAME != ''))
  {
    if (($WHERE_STR == ''))
    {
      ($WHERE_STR .= ((' where PROVIDER_NAME like \'%'.$PROVIDER_NAME).'%\''));
    }
    else
    {
      ($WHERE_STR .= ((' and PROVIDER_NAME like \'%'.$PROVIDER_NAME).'%\''));
    }
  }
  if (($ORDERFIELD != ''))
  {
    if (($ORDERSIGN == 'DOWN'))
    {
      $ORDERTYPE = 'ASC';
    }
    if (($ORDERSIGN == 'UP'))
    {
      $ORDERTYPE = 'DESC';
    }
    $OREDERBY = (((' ORDER BY '.$ORDERFIELD).' ').$ORDERTYPE);
  }
  $query = 'SELECT count(*) FROM `PRODUCT` a LEFT OUTER JOIN SYS_CODE b
        ON a.PRODUCT_MODE = b.CODE_NO AND b.PARENT_NO = \'PRODUCT_MODE\'
        LEFT OUTER JOIN PROVIDER c
        ON a.PROVIDER_ID = c.PROVIDER_ID';
  ($query .= $WHERE_STR);
  $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) OR ($CUR_PAGE == '')))
  {
    $CUR_PAGE = 1;
  }
  if (($PAGE_COUNT < $CUR_PAGE))
  {
    $CUR_PAGE = $PAGE_COUNT;
  }
  $query1 = (('SELECT * FROM PRODUCT a LEFT OUTER JOIN SYS_CODE b
        ON a.PRODUCT_MODE = b.CODE_NO AND b.PARENT_NO = \'PRODUCT_MODE\'
        LEFT OUTER JOIN PROVIDER c
        ON a.PROVIDER_ID = c.PROVIDER_ID'.$WHERE_STR).$OREDERBY);
  $offest = (($CUR_PAGE - 1) * 10);
  if (($offest < 0))
  {
    $offest = 0;
  }
  $query1 = (((($query1.' LIMIT ').$offest).' ,').$PER_PAGE);
  $cursor1 = exequery ($connection, $query1);
  if (($LINKMAN_COUNT == 0))
  {
    message ('<br>提示', '没有符合条件的产品');
    echo '<br>
';
    exit ();
  }
  else
  {
    echo '
<table border="0" cellspacing="1" width="95%" class="small"  cellpadding="3">
  <tr>
    <td align="left">
        <a href="index.php?CUR_PAGE=1&PRODUCT_NAME=';
    echo $PRODUCT_NAME;
    echo '&PRODUCT_TYPE=';
    echo $PRODUCT_TYPE;
    echo '&PRODUCT_DESC=';
    echo $PRODUCT_DESC;
    echo '&PRODUCT_MODE=';
    echo $PRODUCT_MODE;
    echo '&PROVIDER_NAME=';
    echo $PROVIDER_NAME;
    echo '&ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '"><img src=\'/images/first02.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'首页\'></a>
        <a href="index.php?CUR_PAGE=';
    echo ($CUR_PAGE - 1);
    echo '&PRODUCT_NAME=';
    echo $PRODUCT_NAME;
    echo '&PRODUCT_TYPE=';
    echo $PRODUCT_TYPE;
    echo '&PRODUCT_DESC=';
    echo $PRODUCT_DESC;
    echo '&PRODUCT_MODE=';
    echo $PRODUCT_MODE;
    echo '&PROVIDER_NAME=';
    echo $PROVIDER_NAME;
    echo '&ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '"><img src=\'/images/first01.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'上一页\'></a>
        <a href="index.php?CUR_PAGE=';
    echo ($CUR_PAGE + 1);
    echo '&PRODUCT_NAME=';
    echo $PRODUCT_NAME;
    echo '&PRODUCT_TYPE=';
    echo $PRODUCT_TYPE;
    echo '&PRODUCT_DESC=';
    echo $PRODUCT_DESC;
    echo '&PRODUCT_MODE=';
    echo $PRODUCT_MODE;
    echo '&PROVIDER_NAME=';
    echo $PROVIDER_NAME;
    echo '&ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '"><img src=\'/images/last01.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'下一页\' style="cursor:hand"></a>
        <a href="index.php?CUR_PAGE=';
    echo $PAGE_COUNT;
    echo '&PRODUCT_NAME=';
    echo $PRODUCT_NAME;
    echo '&PRODUCT_TYPE=';
    echo $PRODUCT_TYPE;
    echo '&PRODUCT_DESC=';
    echo $PRODUCT_DESC;
    echo '&PRODUCT_MODE=';
    echo $PRODUCT_MODE;
    echo '&PROVIDER_NAME=';
    echo $PROVIDER_NAME;
    echo '&ORDERFIELD=';
    echo $ORDERFIELD;
    echo '&ORDERTYPE=';
    echo $ORDERTYPE;
    echo '"><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">
      ';
    echo $CUR_PAGE;
    echo '/';
    echo $PAGE_COUNT;
    echo '页&nbsp;共&nbsp;';
    echo $LINKMAN_COUNT;
    echo '&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;
      $PRODUCT_ID1 = $ROW['PRODUCT_ID'];
      $PRODUCT_NAME1 = $ROW['PRODUCT_NAME'];
      $PRODUCT_CODE1 = $ROW['PRODUCT_CODE'];
      $PRODUCT_TYPE1 = $ROW['PRODUCT_TYPE'];
      $CODE_NAME1 = $ROW['CODE_NAME'];
      $MEASURE_UNIT1 = $ROW['MEASURE_UNIT'];
      $COST_PRICE1 = $ROW['COST_PRICE'];
      $STANDARD_PRICE1 = $ROW['STANDARD_PRICE'];
      $PROVIDER_NAME1 = $ROW['PROVIDER_NAME'];
      $PHOTO1 = $ROW['PHOTO'];
      if ((($LINKMAN_COUNT % 2) == 1))
      {
        $TableLine = 'TableLine1';
      }
      else
      {
        $TableLine = 'TableLine2';
      }
      echo '
    <tr class="';
      echo $TableLine;
      echo '">
    	<td>&nbsp;<input type="checkbox" name="email_select" value="';
      echo $PRODUCT_ID1;
      echo '" onClick="check_one(self);"></td>
    	 <td nowrap align="center"><a href=#this onclick="view_photo(\'';
12

index.php - 源码说明

本页面展示了「通达OA2007SE源代码 非常好的」中的 index.php 源码文件，采用 PHP 编程语言编写，共 847 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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