mana_seri.php

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

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

if (isset($_REQUEST['vok'])) {
  $que = "select store_id,user_id from ".$xoopsDB->prefix("market_member")." where user_id=".$xoopsUser->uid()." limit 1";
  $res = $xoopsDB->query($que);
  list($s_id,$u_id) = $xoopsDB->fetchrow($res);
  $ins = "insert into ".$xoopsDB->prefix("market_seri");
  $ins.= " (bh,store_id,user_id,rdate,lsbh,spbm,spmc,sssl,qj,sj,zk,tcb,tcj)";
  $ins.= " values (0,";
  $ins.= "'".$s_id."',";
  $ins.= $xoopsUser->uid().",";
  $ins.= "now(),";
  $ins.= "'".$_REQUEST['lsbh0']."',";
  $ins.= "'".$_REQUEST['spbm0']."',";
  $ins.= "'".$_REQUEST['spmc0']."',";
  $ins.= "'".$_REQUEST['sssl0']."',";
  $ins.= "'".$_REQUEST['qj0']."',";
  $ins.= "'".$_REQUEST['sj0']."',";
  $ins.= "'".$_REQUEST['zk0']."',";
  $ins.= "'".$_REQUEST['tcb0']."',";
  $ins.= "'".$_REQUEST['tcj0']."'";
  $ins.= ")";
  $st0 = $xoopsDB->query($ins);
  if ($st0) echo "流水帐已经录入！";
}

$que = "select store_id,user_id,user_name from ".$xoopsDB->prefix("market_member");
$que .=" where user_id='".$xoopsUser->uid()."' limit 1";
$res = $xoopsDB->query($que);
list($s_id,$u_id,$u_name) = $xoopsDB->fetchrow($res);
/*
while ($row = $xoopsDB->fetchrow($res)) {
  ## echo "<option value='".$row[1].">".$row[0]."->".$row[1].":".$row[2]."</option>";
  echo "<option value='".$row[1]."' t_sid='".$row[0]."'>".$row[2]."</option>";
}
*/

?>
<form action="<?php echo $PHP_SELF; ?>" method="post" name="add_seri">
<table border="0" name="BB1" width="40%">
<tr><td width="72">门店号：</td><td width="100"><input type="text" name="store_id0" value="<?php echo $s_id; ?>" disabled="true" /></td><td></td></tr>
<tr><td width="72">用户代码：</td><td width="100"><input type="text" name="user_id0" value="<?php echo $u_id; ?>" readonly /></td><td></td></tr>
<tr><td width="72">流水编号：</td><td width="100"><input type="text" name="lsbh0" value="" /></td><td></td></tr>
<tr><td width="72">商品编码：</td><td width="100"><input type="text" name="spbm0" value="" readonly /></td>
<td>
<select name="sele_prod" size="1" onclick="javascript:spbm0.value=this.options[this.selectedIndex].value;spmc0.value=this.options[this.selectedIndex].text;qj0.value=this.options[this.selectedIndex].qj;">
<?php
$que = "select a.products_name,b.products_ean,b.products_price from ".$xoopsDB->prefix("osc_products_description")." a,";
$que.= $xoopsDB->prefix("osc_products")." b where a.products_id=b.products_id group by b.products_ean order by b.products_price desc";

$res = $xoopsDB->queryF($que);
## $rnu = $xoopsDB->getRowsNum($res);
while($row = $xoopsDB->fetchrow($res)) { 
  echo "<option value='".$row[1]."' qj='".$row[2]."'>".$row[0]."</option>\n";
}
?>
</select>
</td></tr>
<tr><td width="72">商品名称：</td><td width="100"><input type="text" name="spmc0" value="" readonly /></td><td></td></tr>
<tr><td width="72">销售数量：</td><td width="100"><input type="text" name="sssl0" value="1" onchange="javascript:sj0.value='';tcj0.value='';"/></td><td></td></tr>
<tr><td width="72">折前单价：</td><td width="100"><input type="text" name="qj0" value="" readonly /></td><td></td></tr>
<tr><td width="72">售价小计：</td><td width="100"><input type="text" name="sj0" value="" readonly /></td><td></td></tr>
<tr><td width="72">折扣：</td><td width="100"><input type="text" name="zk0" value="" readonly /></td>
<td>
<select name="sele_prod" size="1" onclick="javascript:sj0.value=this.options[this.selectedIndex].text*qj0.value*sssl0.value;zk0.value=this.options[this.selectedIndex].text;tcb0.value=this.options[this.selectedIndex].value;tcj0.value=this.options[this.selectedIndex].value*sj0.value;">
<?php
$que = "select zk,tc from ".$xoopsDB->prefix("market_tcjs")." where store_id='420102f278' order by zk desc";

$res = $xoopsDB->queryF($que);
## $rnu = $xoopsDB->getRowsNum($res);
while($row = $xoopsDB->fetchrow($res)) { 
  echo "<option value='".$row[1]."'>".$row[0]."</option>\n";
}
?>
</select>
</td></tr>
<tr><td width="72">提成比：</td><td width="100"><input type="text" name="tcb0" value="" readonly /></td><td></td></tr>
<tr><td width="72">提成小计：</td><td width="100"><input type="text" name="tcj0" value="" readonly /></td><td></td></tr>
<tr><td colspan="3"><p align="center">
<input type="hidden" name="vok" value="1" />
<input type="reset" name="R01" value="重填" />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="submit" name="S01" value="确认" />
</p></tr>
</table>
</form>

<?php
include_once '../../footer.php';
?>