📄 index.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?
include_once("inc/auth.php");
$query = "select * from SALE_MANAGER where MANAGER_ID=1";
$cursor=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
   $MANAGER_ID=$ROW["MANAGER_ID"];
   $MANAGERS=$ROW["MANAGERS"];
   $DELETE_FLAG=$ROW["DELETE_FLAG"];
}
?>

<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?PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&CUR_PAGE="+PAGE_START;
}

  function delete_linkman(PRODUCT_ID)
{
 msg='确认要删除该产品信息？';
 if(window.confirm(msg))
 {
  URL="delete.php?PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>&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;
 }

 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?PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>&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");
}

function excel_import()
{
  URL="import/";
  window.location=URL;
}

function excel_export()
{
  URL="excel/";
  window.location=URL;
}
  
 function show_detail(PRODUCT_ID)
  {
    URL="showdetail.php?PRODUCT_ID="+PRODUCT_ID;
    myleft=(screen.availWidth-650)/2;
    window.open(URL,"formul_edit","height=300,width=500,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
  } 
</script>
</head>
<body topmargin="5" class="bodycolor">
<div align="left">
<fieldset style="width:95%;padding-bottom:5px;">
	 <legend class="small" align=left>
      <b>快速查询</b>
  </legend>
<table class="TableList" align="left" width="100%">
   <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="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>
    <td nowrap class="TableData">	&nbsp;&nbsp;	&nbsp;&nbsp;
    	 </td>
   </tr>

    <tr>
    <td nowrap class="TableData">&nbsp;&nbsp;产品类别：</td>
    <td nowrap class="TableData">
      <select name="PRODUCT_MODE" class="SmallSelect">
<?
         GETALLDATE("PRODUCT_MODE");
?>
      </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"><?=$MEMO?></textarea>
    </td>
   </tr>
 <tr>
 	<td nowrap class="TableData"  colspan="7" >
    	&nbsp;&nbsp;<input value="快速查询" type="submit" class="SmallButton" title="模糊查询" name="button">
		<input value="产品导入" type="button" class="SmallButton" title="产品资料导入" name="button1" onClick="excel_import();">
		<input value="产品导出" type="button" class="SmallButton" title="产品资料导出" name="button1" onClick="excel_export();">
  </td>
 </tr>
 </form>
</table>
</fieldset>
</div>
<br>
<?
//-----------先组织SQL语句-----------
 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=="")
12 下一页
⌨️ 快捷键说明

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