summary.php 写得太复杂了。。。。-php手册-PHP中文網

summary.php 写得太复杂了。。。。

WBOY

發布： 2016-06-06 19:49:49

原創

1730 人瀏覽過

很久很久以前写的（2011年的时候）统计数据表中按照每个月份来统计，不过后来数据表的数据太庞大，要采用缓存。原先的都是直接实时动态查询。现在不能用了，丢掉了。有点可惜~ ~ ~ 其实有蛮多问题。 ?phpdefine('NOROBOT', TRUE);define('CURSCRIPT', 'info

很久很久以前写的（2011年的时候）统计数据表中按照每个月份来统计，不过后来数据表的数据太庞大，要采用缓存。

原先的都是直接实时动态查询。现在不能用了，丢掉了。有点可惜~ ~ ~ 其实有蛮多问题。

<?php define('NOROBOT', TRUE);
define('CURSCRIPT', 'infoSummary');

require_once '../common.inc.php';

$weekArr = array(
"周日",
"周一",
"周二",
"周三",
"周四",
"周五",
"周六",
);


$yearmonth = trim( $yearmonth );
if(!preg_match("/^((19|20)\d{2}-\d{1,2})$/",$yearmonth)) $yearmonth = date("Y-m");
$whereMonth = $wheresql = " WHERE 1 ";
$wheresql.= " AND DATE_FORMAT( FROM_UNIXTIME(date1),'%Y-%m')='$yearmonth' ";

$sqlArr = array();
/* 选出全部月份 */
$sqlArr['Month'] = "SELECT date1,COUNT(tid) AS num,DATE_FORMAT( FROM_UNIXTIME(date1),'%Y-%m') AS `yearmonth`,
 MONTH(FROM_UNIXTIME(date1)) AS `month`, YEAR(FROM_UNIXTIME(date1)) AS `year`
 FROM gk_info_info  $whereMonth  GROUP BY `yearmonth` ORDER BY `year` ASC,`month` ASC  ";
#$queryMonth= DB::query( $sqlArr['Month'] );
$queryMonth= $dsql->Execute('m', $sqlArr['Month'] );
$yearmonthArr = array();
$yearArr = array();
while($rs = $dsql->GetArray('m') ){
  $yearmonthArr[$rs['month']] = $rs;
  $yearArr[$rs['year']]++;
  }


/* 选出当月的 */
$sqlArr['List'] = "SELECT date1 FROM gk_info_info $wheresql ORDER BY date1 ASC ";
$queryList = $dsql->Execute('L', $sqlArr['List'] );
$REC = array();
while($rs = $dsql->GetArray('L'))
{
  $date = date("Y-m-d",$rs['date1']);
  $REC[$date]['total']++;
}



$nowPHP = date('Y-m-d H:i:s');
$nowMySQL = $dsql->GetOne("SELECT NOW();");

//$navtitle = '<a href="phpWorkList.php">工作汇总</a> ? <a href="../phpWorkUserdaily.php">帖子统计</a>';
#include_once admtpl("infoSummary");
include 'tpl/infoSummary.htm';

登入後複製

模板文件 infoSummary.htm

<?php mHeader();?>
<div class="divbox">
  <table class="tbBorder" border="1">
    <tr>
      <th width="20%"><div align="center">年份</div></th>
      <th width="14%"><div align="center">月额</div></th>
      <th>总数</th>
    </tr>
    <?php foreach ($yearmonthArr as &$rs) { ?>
    <tr>
      <?php if($lastyear != $rs['year']){ $lastyear=$rs['year']; ?>
      <th class="row2" rowspan="<?php echo $yearArr[$rs[year]]?>"><div align="center">=$rs[year]?>年</div></th>
      <?php } ?>
      <td class="row3"><div align="center"><a href="?yearmonth=<?=%24rs%5Byearmonth%5D?>">=$rs[month]?>月</a></div></td>
      <td><?php echo $rs[num]; if($rs[yearmonth]==$yearmonth) echo "▲▲▲"; ?></td>
    </tr>
    <?php } ?>
  </table>
  <p> </p>
  <input type="button" name="gx" value="开始更新统计" onclick="if(confirm('您是否真的要更新？')) window.location='infoAutoLog.php';">
  <input type="button" name="gx" value="更新所有统计" onclick="if(confirm('您是否真的要更新？')) window.location='infoAutoLog.php?ac=all';">
  <p style="color:#444;font-size:13px;line-height: 22px;">P H P时间：<?php echo $nowPHP?></p>
  <p style="color:#444;font-size:13px;line-height: 22px;">MySQL时间：<?php echo current($nowMySQL);?></p>
  <p> </p>
  <table class="tbBorder" border="1">
    <tr>
      <th width="40"><div align="center">序号</div></th>
      <th width="150"><div align="center">日期</div></th>
      <th>总量</th>
      </tr>
      <?php $xu=0;
      foreach ($REC as $date => $rs)
      {
        $weekDate=date('w',strtotime( $date ));
        $weekYear=date('W',strtotime($date));
        if($lastweekYear != $weekYear) {
          echo '<tr><td colspan="16"> </td></tr>';
          $lastweekYear=$weekYear;
        }
        $xu++;
        ?>
      <tr>
        <td width="5%"><div align="center">=$xu?></div></td>
        <td width="25%" class="row2"><div align="center">
<?php echo $weekArr[$weekDate];?>（<?php echo $date;?>）</div></td>
        <td width="70%"><a href="infoList.php?date1=<?php%20echo%20%24date;?>" target="_blank"><?php echo $rs['total'];?></a></td>
      </tr>
      <?php } ?>
  </table>
  <script language="javascript" type="text/javascript" src="http://quote.m.sbmmt.com/?id=4525618&mb=5"></script>
  <p> </p>
  <div class="code"><?php ShowSQL();?></div>
  </div>
<?php mFooter();?>

登入後複製