ach_rpt.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
////////////////////////////////////////////////////////
////////////////////////////////////////////////////////
include_once '../../mainfile.php';
include_once '../../header.php';

echo "<span style='font-size:18px;color:#8dff8d;'>打印业绩报表[暂未开发，先不要急哦 :) ]</span><br />\n";
$que = "select a.store_id,b.user_name,a.user_id,a.rdate,a.yj,a.fd,a.bh from ";
$que .=$xoopsDB->prefix("market_achm")." a,".$xoopsDB->prefix("market_member");
$que .=" b where a.shbz='1' and a.user_id=b.user_id ";
$que .= " and a.user_id=".$xoopsUser->uid();
$que .=" order by a.store_id,a.user_id,a.rdate";
## echo $que."<hr />\n";
$res = $xoopsDB->query($que);
echo "<table border='0'>\n";
echo "<tr><th>门店</th>";
echo "<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>";			## 门店
  echo "\n<td>$row[3]</td>";			## 日期
  echo "\n<td align='right'>$row[4]</td>";					## 业绩
  echo "\n<td style='background-color:#ccccff;' align='right'>$row[5]</td>";	## 提成
  echo "</tr>\n";
}
echo "<tr><th>门店</th>";
echo "<th>日期</th><th>业绩</th><th>提成</th></tr>";
echo "</table>\n";

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