mana_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";
if (isset($_REQUEST['vok'])) {
$ins = "insert into ".$xoopsDB->prefix("market_seri");
$ins.= " (bh,store_id,user_id,rdate,lsbh,spbm,spmc,sssl,qj,sj,zk,tcb,tcj,shbz,sh_user_id)";
$ins.= " values (0,";
$ins.= "'".$_REQUEST['store_id0']."',";
$ins.= "'".$_REQUEST['user_id0']."',";
$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.= "'0',";
$ins.= $xoopsUser->uid();
$ins.= ")";
$st0 = $xoopsDB->queryF($ins);
}

?>

<form action="<?php echo $PHP_SELF; ?>" method="post" name="add_seri">
<table border="0" name="BB1">
<tr><td>门店号：</td><td><input type="text" name="store_id0" value="" readonly /></td>
<td>
<select name="sele_user" size="1" onclick="javascript:store_id0.value=this.options[this.selectedIndex].t_sid;user_id0.value=this.options[this.selectedIndex].value;">
<?php
$que = "select store_id,user_id,user_name from ".$xoopsDB->prefix("market_member");
$res = $xoopsDB->query($que);
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>";
}

?>
</select>
</td></tr>
<tr><td>用户代码：</td><td><input type="text" name="user_id0" value="" readonly /></td><td></td></tr>
<tr><td>流水编号：</td><td><input type="text" name="lsbh0" value="" /></td><td></td></tr>
<tr><td>商品编码：</td><td><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>";
}
?>
</select>
</td></tr>
<tr><td>商品名称：</td><td><input type="text" name="spmc0" value="" readonly /></td><td></td></tr>
<tr><td>销售数量：</td><td><input type="text" name="sssl0" value="1" onchange="javascript:sj0.value='';tcj0.value='';"/></td><td></td></tr>
<tr><td>折前单价：</td><td><input type="text" name="qj0" value="" readonly /></td><td></td></tr>
<tr><td>售价小计：</td><td><input type="text" name="sj0" value="" readonly /></td><td></td></tr>
<tr><td>折扣：</td><td><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>";
}
?>
</select>
</td></tr>
<tr><td>提成比：</td><td><input type="text" name="tcb0" value="" readonly /></td><td></td></tr>
<tr><td>提成金小计：</td><td><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
xoops_cp_footer();
?>