sh_seri.php

自己实现一个实用的商店应用系统

<?php
////////////////////////////////////////////////////////
// Author by Shuweich
// Date : 2007.07.27
// 建站支持: http://www.shuweich.net
// 作者: Shuweich
// QQ: 1502384
// ICQ: 190492112
// MSN: [e-mail]
// E-mail: [e-mail]
// E-mail: [e-mail]
// CMS交流站点: http://www.shuweich.net
////////////////////////////////////////////////////////
// 模块管理 by market
// For 系统管理员(站长及经理)
////////////////////////////////////////////////////////
include '../../../include/cp_header.php';
xoops_cp_header();
include 'admhead.php';

## echo "<span style='font-size:18px;color:#8dff8d;'>流水审核</span><br />\n";
while(list($k,$v)=each($_POST['sh_seri'])){ 
  $upd = "update ".$xoopsDB->prefix("market_seri")." set shbz='1',sh_user_id=".$xoopsUser->uid()." where bh=".$k;
  $st0 = $xoopsDB->queryF($upd);
}

echo "<span style='font-size:18px;color:#88ff88;'>流水帐审核:-:</span>\n";
$que = "select store_id,user_id,user_name from ";
$que .=$xoopsDB->prefix("market_member")." order by store_id,user_id";
$res = $xoopsDB->query($que);

?>

<select name='get_member' size='1' onclick="javascript:window.document.location=this.options[this.selectedIndex].lochref;">
<?php
while ( $row = $xoopsDB->fetchrow($res) ) {
  echo "<option lochref='".$PHP_SELF."?u_id=".$row[1]."' value='".$row[1]."'";
  if ( $row[1] == $_REQUEST['u_id'] ) echo " selected ";
  echo ">".$row[0]."::".$row[2]."</option>";
}
?>
</select>

<form action="<?php echo $PHP_SELF; ?>" method="post" name="sh_ser">
<?php

if ( isset($_REQUEST['u_id']) ) {
  $que = "select user_name from ".$xoopsDB->prefix("market_member")." where user_id=".$_REQUEST['u_id']." limit 1";
  $res = $xoopsDB->query($que);
  list($u_name) = $xoopsDB->fetchrow($res);
  echo ">>>>".$u_name."======> ";
}
$que = "select a.store_id,b.user_name,a.user_id,a.rdate,a.lsbh,a.spbm,";
$que .="a.spmc,a.sssl,a.qj,a.zk,a.sj,a.tcj,a.bh from ";
$que .=$xoopsDB->prefix("market_seri")." a,".$xoopsDB->prefix("market_member");
$que .=" b where a.shbz!='1' and a.user_id=b.user_id ";
if ( isset($_REQUEST['u_id']) ) $que .= " and a.user_id=".$_REQUEST['u_id'];
$que .=" order by store_id,user_id,rdate,lsbh";
$res = $xoopsDB->query($que);
echo "<table border='0'>\n";
echo "<tr><th>门店</th>";
if ( !isset($_REQUEST['u_id']) ) echo "<th width='45'>会员</th>";
echo "<th>日期</th><th>流水号</th><th>商品码</th><th>商品名</th><th>数量</th><th>原价</th><th>折扣</th><th>售价</th><th>提成</th><th>审核</th></tr>";
$xh=0;
while ( $row = $xoopsDB->fetchrow($res) ) {
  echo "<tr ";
  if ($xh % 2 == 0) echo "class='odd'";
  else echo "class='even'";
  echo " >";		$xh++;
  echo "\n<td>$row[0]</td>";			## 门店
if ( !isset($_REQUEST['u_id']) )   echo "\n<td>$row[1]</td>";	## 会员
  echo "\n<td>$row[3]</td>";			## 日期
  echo "\n<td>$row[4]</td>";			## 流水号
  echo "\n<td>".substr($row[5],7)."</td>";	## 商品码
  echo "\n<td>$row[6]</td>";			## 商品名
  echo "\n<td>$row[7]</td>";			## 数量
  echo "\n<td align='right'>$row[8]</td>";					## 原价
  echo "\n<td style='background-color:#b2cfba;'>$row[9]</td>";			## 折扣
  echo "\n<td align='right'>$row[10]</td>";					## 售价
  echo "\n<td style='background-color:#ccccff;' align='right'>$row[11]</td>";	## 提成
  echo "\n<td><input type='checkbox' name='sh_seri[".$row[12]."]' value='1' /></td>";		## 审核
  echo "</tr>\n";
}
echo "<tr><th>门店</th>";
if ( !isset($_REQUEST['u_id']) ) echo "<th width='45'>会员</th>";
echo "<th>日期</th><th>流水号</th><th>商品码</th><th>商品名</th><th>数量</th><th>原价</th><th>折扣</th><th>售价</th><th>提成</th><th>审核</th></tr>";
echo "</table>\n";
echo "<hr />\n";
echo "<input type='reset' name='R01' value='重选' />";
echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
echo "<input type='submit' name='S01' value='确认' />";
echo "</form>\n";

xoops_cp_footer();
?>