页面table

如上，视频背景上期已发布，这期讲讲页面自定义表格，后端是php，使用tp5框架。

html：

<table  width="90%" border="1" style="border:1px solid gold;border-collapse:collapse;margin:0px auto;" >
  <tr >
    <td  align="center" colspan="1">SiteName</td>
    <td  align="center" colspan="21">{$shopname}</td>
  </tr>
  <tr >
    <td  align="center" colspan="1">City</td>
    <td  align="center" colspan="21">上海</td>
  </tr>
  <tr >
    <td  align="center" colspan="1">Address</td>
    <td  align="center" colspan="21">{$address}</td>
  </tr>
   <!--Date-->
  <tr >
    <td  align="center"  colspan="1">Date</td>
    {volist name="data.date" id="vo"}
       <td  align="center"  colspan="3">{$vo.cdate}</td>
    {/volist}
  </tr>
  <tr >
    <td  align="center"  colspan="1">{$data.period}天</td>
    {volist name="data.zhou" id="vo"}
    <td  align="center"  colspan="3">{$vo}</td>
    {/volist}
  </tr>
  <tr >
    <td  align="center"  colspan="1">Time</td>
    {volist name="data.date" id="vo"}
    <td  align="center"  colspan="3">{$stet}</td>
    {/volist}
  </tr>
  <!--类别-->
  <tr >
    <td  align="center"  colspan="1">类别</td>
    {volist name="data.date" id="vo"}
    <td  align="center"  colspan="1">店内人流</td>
    <td  align="center"  colspan="1">总客流</td>
    <td  align="center"  colspan="1">入店率</td>
    {/volist}
  </tr>
  <!--数据-->
  {volist name="data.hour" id="vo" }
  <tr >
    <td  align="center"  colspan="1">{$vo.chour}:00-{$vo.chour+1}:00</td>
    {volist name="data['evehour'][$vo['chour']]" id="vo2"}
    <td  align="center"  colspan="1">{$vo2.in}</td>
    <td  align="center"  colspan="1">{$vo2.out}</td>
    <td  align="center"  colspan="1">{$vo2.per}</td>
    {/volist}
  </tr>
  {/volist}

  <tr >
    <td  align="center"  colspan="1">Day Total</td>
    {volist name="data.daydata" id="vo" }
     {if  condition="$i%2==0"}
    <td  align="center"  colspan="1">{$vo.num+$data.daydata[$i-2]['num']}</td>
    <td style="display: none;">{$dd=$vo.num+$data.daydata[$i-2]['num']}</td>
    <td  align="center"  colspan="1" >{$data.daydata[$i-2]['num']*100/$dd|round=2}%</td>
     {else/}
    <td  align="center"  colspan="1">{$vo.num}</td>
     {/if}
    {/volist}
  </tr>
  <tr >
    <td  align="center" colspan="1">Weekly Total</td>
    <td  align="center" colspan="21">{$data.sumall}</td>
  </tr>
</table>

php之模板变量赋值：

$model=Promodel::getInstance();
$shopname=$model->shopName($pid);
$this->assign('shopname',$shopname[0]['shop_name']);
$this->assign('address',$shopname[0]['address']);
//excel数据
$data=$model->excData($pid);
$this->assign('data',$data);
//始末时间段
$this->assign('stet',$data['hour'][0]['chour'].':00'.'-'.$data['hour'][count($data['hour'])-1]['chour'].':00');

model不便透露，此篇提供参考思路，下篇提供phpexcel导出。