sp_tcjs.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";

echo "<pre>\n";
if ( isset($_REQUEST[modify_gl]) ) {
  while(list($k,$v)=each($_POST[modi_tc])){ 
    $upd = "update ".$xoopsDB->prefix("market_tcjs")." set zk=".$_REQUEST[zk0][$k].",tc=".$_REQUEST[tc0][$k]." where bh=".$k;
    ## echo $upd."\n";
    $up0 = $xoopsDB->queryF($upd);
  }
  echo "<hr />";
  while(list($k,$v)=each($_POST[modi_gl])){ 
    $upd = "update ".$xoopsDB->prefix("market_glj")." set gltc=".$_REQUEST[gltc0][$k]." where bh=".$k;
    ## echo $upd."\n";
    $up0 = $xoopsDB->queryF($upd);
  }
}
echo "</pre>\n";

echo "<form name='modi_gl' action='".$PHP_SELF."' method='post'>\n";
echo "<table border='0'>\n";
$xh=0;
echo "<tr><th colspan='5' align='center'>提成与折扣变更</th></tr>\n";
if ( $xh %2 ==0 ) $tdsp='odd'; else $tdsp='even'; $xh++;
echo "<tr class='$tdsp'><td>门店号</td><td>序号</td><td>折扣率</td><td>提成率</td><td>修改</td></tr>\n";
$que = "select bh,store_id,jb,zk,tc from ".$xoopsDB->prefix("market_tcjs")." order by bh";
$res = $xoopsDB->query($que);
while ( $row = $xoopsDB->fetchrow($res) ) {
  if ( $xh %2 ==0 ) $tdsp='odd'; else $tdsp='even'; $xh++;
  echo "<tr class='$tdsp'>";
  echo "<td>".$row[1]."</td>";
  echo "<td>".$row[2]."</td>\n";
  echo "<td><input type='text' name='zk0[".$row[0]."]' value='".$row[3]."' /></td>\n";
  echo "<td><input type='text' name='tc0[".$row[0]."]' value='".$row[4]."' /></td>\n";
  echo "<td><input type='checkbox' name='modi_tc[".$row[0]."]' value='1' /></td></tr>\n";		## 修改

}
if ( $xh %2 ==0 ) $tdsp='odd'; else $tdsp='even'; $xh++;
echo "<tr class='$tdsp'><td>门店号</td><td>序号</td><td>折扣率</td><td>提成率</td><td>修改</td></tr>\n";
## echo "<tr><th>门店号</th><th>序号</th><th>折扣率</th><th>提成率</th><th>修改</th></tr>\n";
echo "</table>\n";
echo "<hr />\n";
echo "<table border='0'>\n";
echo "<tr><th colspan='4' align='center'>管理奖变更</th></tr>\n";
if ( $xh %2 ==0 ) $tdsp='odd'; else $tdsp='even'; $xh++;
echo "<tr class='$tdsp'><td>门店号</td><td>序号</td><td>管理奖</td><td>修改</td></tr>\n";
$que = "select bh,store_id,jb,gltc from ".$xoopsDB->prefix("market_glj")." order by bh";
$res = $xoopsDB->query($que);
while ( $row = $xoopsDB->fetchrow($res) ) {
  if ( $xh %2 ==0 ) $tdsp='odd'; else $tdsp='even'; $xh++;
  echo "<tr class='$tdsp'>";
  echo "<td>".$row[1]."</td>";
  echo "<td>".$row[2]."</td>\n";
  echo "<td><input type='text' name='gltc0[".$row[0]."]' value='".$row[3]."' /></td>\n";
  echo "<td><input type='checkbox' name='modi_gl[".$row[0]."]' value='1' /></td></tr>\n";		## 修改

}
if ( $xh %2 ==0 ) $tdsp='odd'; else $tdsp='even'; $xh++;
## echo "<tr><th>门店号</th><th>序号</th><th>管理奖</th><th>修改</th></tr>\n";
echo "<tr class='$tdsp'><td>门店号</td><td>序号</td><td>管理奖</td><td>修改</td></tr>\n";
echo "</table>\n";
echo "<input type='hidden' name='modify_gl' value='1' />\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();
?>