acc_drczcz.php

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

<?php
////////////////////////////////////////////////////////
// Author by Shuweich
// Date : 2007.11.13
// 建站支持: http://www.shuweich.net
// 作者: Shuweich
// QQ: 1502384
// ICQ: 190492112
// MSN: [e-mail]
// E-mail: [e-mail]
// E-mail: [e-mail]
////////////////////////////////////////////////////////
// 模块管理 by txdyz
// For 查询当日流水
////////////////////////////////////////////////////////
include_once '../../mainfile.php';
$title='当日错帐冲正';
include_once 'head_inc.php';

include_once 'head_win.php';
$que = "select sdbh,date_q,user_disc,user_card,sum(spzkj) jexj,rz_user_id,store_id ";
$que.= " from ".$xoopsDB->prefix("market_mdseri");
$que.= " where store_id='".$_REQUEST['s_id0']."' and zy='mdxs' and shbz!='2' group by sdbh order by sdbh";
## echo "<hr />$que<hr />\n";
$res = $xoopsDB->query($que);
echo "<center>销售流水帐<font style='font-size:24px;color:#f99;'>冲正</font>\n";
echo "<form name='fo01' method='post' action='".$_SERVER['PHP_SELF']."?s_id0=".$_REQUEST['s_id0']."'>\n";
echo "<table border='1'>\n";
echo "<tr class='v'><th>№</th><th>时间</th><th>会员折</th><th>会员卡号</th><th>金额</th><th>操作员</th></tr>\n";
$kll = $xoopsDB->getRowsNum($res);
while ( $row = $xoopsDB->fetchrow($res) ) {
  echo "<tr style='background-color:#ccf;' onclick='javascript:if ( confirm(\"流水号：".$row[0]."；确认要冲正（删除）这笔帐吗？\") ) { window.showModelessDialog(\"acc_sc.php?s_id0=".$_REQUEST['s_id0']."&sdbh0=".$row[0]."&user_card0=".$row[3]."&user_tach0=".$row[4]."\");setTimeout(\"document.fo01.submit();\",3000); } else { alert(\"放弃(".$row[0].")!\"); }'>";
  echo "<td>$row[0]</td><td>".substr($row[1],11)."</td><td align='right'>$row[2]％</td><td>$row[3]</td><td align='right'>$row[4]</td><td>$row[5]</td></tr>\n";
}
echo "</table>\n";
## 
echo "<hr /><center>其它交易<font style='font-size:24px;color:#f99;'>冲正</font>\n";
$que = "select sdbh,date_q,zy,user_card,sum(spzkj) jexj,rz_user_id,store_id ";
$que.= " from ".$xoopsDB->prefix("market_mdseri");
$que.= " where store_id='".$_REQUEST['s_id0']."' and zy!='mdxs' and shbz!='2' group by sdbh order by sdbh";
$res = $xoopsDB->query($que);
echo "<table border='1'>\n";
echo "<tr class='v'><th>№</th><th>时间</th><th>交易</th><th>对象</th><th>金额</th><th>操作员</th></tr>\n";
while ( $row = $xoopsDB->fetchrow($res) ) {
  $_Nf = $_ZY[$row[2]];
  echo "<tr style='background-color:#ccf;' onclick='javascript:if ( confirm(\"流水号：".$row[0]."；确认要冲正（删除）这笔帐吗？\") ) { window.showModelessDialog(\"acc_sc.php?s_id0=".$_REQUEST['s_id0']."&sdbh0=".$row[0]."&user_card0=".$row[3]."&user_tach0=".$row[4]."\");setTimeout(\"document.fo01.submit();\",3000); } else { alert(\"放弃(".$row[0].")!\"); }'>";
  echo "<td>$row[0]</td><td>".substr($row[1],11)."</td><td align='right'>$_Nf</td><td>$row[3]</td><td align='right'>$row[4]</td><td>$row[5]</td></tr>\n";
}
echo "</table>\n";



echo "</form>\n";
/*
$kll = $xoopsDB->getRowsNum($res);
$que = "select sum(spzkj) xsje ";
$que.= " from ".$xoopsDB->prefix("market_mdseri");
$que.= " where store_id='".$_REQUEST['s_id0']."' and shbz!='2' and zy='mdxs'";
$res = $xoopsDB->query($que);
$row = $xoopsDB->fetchrow($res);
echo "今日客流：".$kll."人；&nbsp;&nbsp;销售小计：".$row[0];
 */
echo "<hr /><input type='button' value='关闭窗口' onclick='returnValue=1;window.close();' />\n";
echo "&nbsp;&nbsp;&nbsp;&nbsp;<input type='button' value='刷新显示' onclick='returnValue=1;document.fo01.submit();' />\n";
include_once '../../footer.php';
?>