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

📄 list.php

📁 通达OA28 部分程序源码
💻 PHP
字号:
🔍 
<?
include_once("inc/auth.php");
$PAGE_SIZE=10;
?>

<html>
<head>
<title>销售记录查询结果 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function delete_HISTORY(HISTORY_ID)
{
 msg='确认要删除该销售记录么？';
 if(window.confirm(msg))
 {
  URL="delete.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&PRODUCT_ID=<?=$PRODUCT_ID?>&PROVIDER_ID=<?=$PROVIDER_ID?>&DATE=<?=$DATE?>&AMT=<?=$AMT?>&PRICE=<?=$PRICE?>&DISCOUNT=<?=$DISCOUNT?>&SALESMAN=<?=$SALESMAN?>&MEMO=<?=$MEMO?>&PAGE_START=<?=$PAGE_START?>&HISTORY_ID=" + HISTORY_ID;
  window.location=URL;
 }
}

function set_page()
{
 PAGE_START=(PAGE_NUM.value-1)*<?=$PAGE_SIZE?>+1;
 location="list.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&PRODUCT_ID=<?=$PRODUCT_ID?>&PROVIDER_ID=<?=$PROVIDER_ID?>&DATE=<?=$DATE?>&AMT=<?=$AMT?>&PRICE=<?=$PRICE?>&DISCOUNT=<?=$DISCOUNT?>&SALESMAN=<?=$SALESMAN?>&MEMO=<?=$MEMO?>&PAGE_START="+PAGE_START;
}

function detail(HISTORY_ID)
{
 URL="detail.php?HISTORY_ID="+HISTORY_ID;
 myleft=(screen.availWidth-500)/2;
 window.open(URL,"read_notify","height=260,width=500,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
</script>
</head>

<body class="bodycolor" topmargin="5" >
<?
//-----------先组织SQL语句-----------


 if($CUSTOMER_ID!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where CUSTOMER_ID='".$CUSTOMER_ID."'";
     else
         $WHERE_STR.=" and CUSTOMER_ID='".$CUSTOMER_ID."'";

 if($PRODUCT_ID!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where PRODUCT_ID like '%".$PRODUCT_ID."%'";
     else
         $WHERE_STR.=" and PRODUCT_ID like '%".$PRODUCT_ID."%'";

 if($PROVIDER_ID!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where PROVIDER_ID like '%".$PROVIDER_ID."%'";
     else
         $WHERE_STR.=" and PROVIDER_ID like '%".$PROVIDER_ID."%'";

 if($DATE!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where DATE like '%".$DATE."%'";
     else
         $WHERE_STR.=" and DATE like '%".$DATE."%'";

 if($AMT!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where AMT like '%".$AMT."%'";
     else
         $WHERE_STR.=" and AMT like '%".$AMT."%'";

 if($PRICE!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where PRICE like '%".$PRICE."%'";
     else
         $WHERE_STR.=" and PRICE like '%".$PRICE."%'";

 if($DISCOUNT!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where DISCOUNT like '%".$DISCOUNT."%'";
     else
         $WHERE_STR.=" and DISCOUNT like '%".$DISCOUNT."%'";

 if($SALESMAN!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where SALESMAN like '%".$SALESMAN."%'";
     else
         $WHERE_STR.=" and SALESMAN like '%".$SALESMAN."%'";

 if($MEMO!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where MEMO like '%".$MEMO."%'";
     else
         $WHERE_STR.=" and MEMO like '%".$MEMO."%'";

 if($WHERE_STR!="")
     $query="SELECT count(*) from SALE_HISTORY ".$WHERE_STR." order by DATE desc";
 else
     $query="SELECT count(*) from SALE_HISTORY order by DATE desc";

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

 $PAGE_TOTAL=$HISTORY_COUNT/$PAGE_SIZE;
 $PAGE_TOTAL=ceil($PAGE_TOTAL);

 //--- 计算,末页 ---
 if($HISTORY_COUNT<=$PAGE_SIZE)
    $LAST_PAGE_START=1;
 else if($HISTORY_COUNT%$PAGE_SIZE==0)
    $LAST_PAGE_START=$HISTORY_COUNT-$PAGE_SIZE+1;
 else
    $LAST_PAGE_START=$HISTORY_COUNT-$HISTORY_COUNT%$PAGE_SIZE+1;

 //--- 智能分页 ---
 //-- 页首 --
 if($PAGE_START=="")
    $PAGE_START=1;

 if($PAGE_START>$HISTORY_COUNT)
    $PAGE_START=$LAST_PAGE_START;

 if($PAGE_START<1)
    $PAGE_START=1;

 //-- 页尾 --
 $PAGE_END=$PAGE_START+$PAGE_SIZE-1;

 if($PAGE_END>$HISTORY_COUNT)
    $PAGE_END=$HISTORY_COUNT;

 //--- 计算当前页 ---
 $PAGE_NUM=($PAGE_START-1)/$PAGE_SIZE+1;

    $query1=str_replace("count(*)","*",$query);
  $cursor1 = exequery($connection, $query1);

  if($HISTORY_COUNT==0)
  {
     Message("<br>提示","没有符合条件的销售记录");
     exit;
  }

?>

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_open.gif" align="absmiddle"><span class="big3"> 销售记录查询结果 </span>
    </td>
    <td valign="bottom">
    <span class="small1">当前为第<b><?=$PAGE_START?></b>至<b><?=$PAGE_END?></b>条 (第<?=$PAGE_NUM?>页，共<?=$PAGE_TOTAL?>页，每页最多<?=$PAGE_SIZE?>条)</small>
    </td>
    </tr>
</table>

<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
  <tr 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>
      <td nowrap align="center">发货员</td>
      <td nowrap align="center">备注</td>
      <td nowrap align="center">操作</td>
  </tr>

<?
  $HISTORY_COUNT = 0;
  while($ROW=mysql_fetch_array($cursor1))
  {
    $HISTORY_COUNT++;

    if($HISTORY_COUNT<$PAGE_START)
       continue;
    else if($HISTORY_COUNT>$PAGE_END)
       break;

        $HISTORY_ID=$ROW["HISTORY_ID"];
    $CUSTOMER_ID1=$ROW["CUSTOMER_ID"];
    $PRODUCT_ID1=$ROW["PRODUCT_ID"];
    $PROVIDER_ID1=$ROW["PROVIDER_ID"];
    $DATE1=$ROW["DATE"];
    $AMT1=$ROW["AMT"];
    $PRICE1=$ROW["PRICE"];
    $DISCOUNT1=$ROW["DISCOUNT"];
    $SALESMAN1=$ROW["SALESMAN"];
    $MEMO1=$ROW["MEMO"];

        $query = "SELECT CUSTOMER_NAME from CUSTOMER where CUSTOMER_ID=$CUSTOMER_ID1";
      $cursor= exequery($connection,$query);
    if($ROW=mysql_fetch_array($cursor))
        {
             $CUSTOMER_NAME=$ROW["CUSTOMER_NAME"];
    }

        $query = "SELECT PRODUCT_NAME,PRODUCT_TYPE from PRODUCT where PRODUCT_ID=$PRODUCT_ID1";
      $cursor= exequery($connection,$query);
    if($ROW=mysql_fetch_array($cursor))
    {
         $PRODUCT_NAME=$ROW["PRODUCT_NAME"];
          $PRODUCT_TYPE=$ROW["PRODUCT_TYPE"];

          if($PRODUCT_TYPE!="")
            $PRODUCT_NAME_TYPE=$PRODUCT_NAME."（".$PRODUCT_TYPE."）";
          else
            $PRODUCT_NAME_TYPE=$PRODUCT_NAME;
    }

    if($HISTORY_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";

?>

    <tr class="<?=$TableLine?>">
      <td nowrap align="center" width="150"><?=$CUSTOMER_NAME?></td>
      <td nowrap align="center"><?=$PRODUCT_NAME_TYPE?></td>
      <td nowrap align="center"><?=$DATE1?></td>
      <td nowrap align="center"><?=$AMT1?></td>
      <td nowrap align="center"><?=$PRICE1?></td>
      <td nowrap align="center"><?=$DISCOUNT1?></td>
      <td nowrap align="center"><?=$SALESMAN1?></td>
      <td nowrap align="center"><?=$MEMO1?></td>
      <td nowrap align="center" width="80">
        <a href="javascript:detail('<?=$HISTORY_ID?>');">详情 </a>
      </td>
    </tr>

<?
    $CUSTOMER_ID1="";
    $PRODUCT_ID1="";
    $PROVIDER_ID1="";
    $DATE1="";
    $AMT1="";
    $PRICE1="";
    $DISCOUNT1="";
    $SALESMAN1="";
    $MEMO1="";
    $CUSTOMER_NAME="";
    $PRODUCT_NAME_TYPE="";
    $PROVIDER_NAME="";
  }
?>
  <tr class="TableControl">
  <td colspan="10" align="right">
     <input type="button"  value="首页" class="SmallButton"  <?if($PAGE_START==1)echo "disabled";?> onclick="location='list.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&PRODUCT_ID=<?=$PRODUCT_ID?>&PROVIDER_ID=<?=$PROVIDER_ID?>&DATE=<?=$DATE?>&AMT=<?=$AMT?>&PRICE=<?=$PRICE?>&DISCOUNT=<?=$DISCOUNT?>&SALESMAN=<?=$SALESMAN?>&MEMO=<?=$MEMO?>'"> &nbsp;&nbsp;
     <input type="button"  value="上一页" class="SmallButton" <?if($PAGE_START==1)echo "disabled";?> onclick="location='list.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&PRODUCT_ID=<?=$PRODUCT_ID?>&PROVIDER_ID=<?=$PROVIDER_ID?>&DATE=<?=$DATE?>&AMT=<?=$AMT?>&PRICE=<?=$PRICE?>&DISCOUNT=<?=$DISCOUNT?>&SALESMAN=<?=$SALESMAN?>&MEMO=<?=$MEMO?>&PAGE_START=<?=($PAGE_START-$PAGE_SIZE)?>'"> &nbsp;&nbsp;
     <input type="button"  value="下一页" class="SmallButton" <?if($PAGE_END>=$HISTORY_COUNT)echo "disabled";?> onclick="location='list.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&PRODUCT_ID=<?=$PRODUCT_ID?>&PROVIDER_ID=<?=$PROVIDER_ID?>&DATE=<?=$DATE?>&AMT=<?=$AMT?>&PRICE=<?=$PRICE?>&DISCOUNT=<?=$DISCOUNT?>&SALESMAN=<?=$SALESMAN?>&MEMO=<?=$MEMO?>&PAGE_START=<?=($PAGE_END+1)?>'"> &nbsp;&nbsp;
     <input type="button"  value="末页" class="SmallButton"  <?if($PAGE_END>=$HISTORY_COUNT)echo "disabled";?> onclick="location='list.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&PRODUCT_ID=<?=$PRODUCT_ID?>&PROVIDER_ID=<?=$PROVIDER_ID?>&DATE=<?=$DATE?>&AMT=<?=$AMT?>&PRICE=<?=$PRICE?>&DISCOUNT=<?=$DISCOUNT?>&SALESMAN=<?=$SALESMAN?>&MEMO=<?=$MEMO?>&PAGE_START=<?=$LAST_PAGE_START?>'"> &nbsp;&nbsp;
     页数
     <input type="text" name="PAGE_NUM" value="<?=$PAGE_NUM?>" class="SmallInput" size="2"> <input type="button"  value="转到" class="SmallButton" onclick="set_page();" title="转到指定的页面">&nbsp;&nbsp;
  </td>
  </tr>
</table>

<br>
<div align="center">
  <input type="button" value="关闭" class="BigButton" onClick="javascript:window.close();">
</div>

</body>
</html>

⌨️ 快捷键说明

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