public function show(){
$m = new Model();
$sql = "select *,FROM_UNIXTIME(created,'%Y-%m-%d') as created from table1 group by created ORDER BY created desc";
$result = $m->query($sql);
$sql2 = "select distinct FROM_UNIXTIME(created'%Y-%m-%d') as created from table2 group by created ORDER BY created desc;";
$result2 = $m->query($sql2);
return array('result'=>$result,'result2'=>$result2);
}
public function getUsers(){
$user = M("user", 'test_');
return $user->getField('id,real_name');
}
public function show(){
$aApi = new AApi();
$list = $aApi->show();
$new_list = array();
foreach($list['result2'] as $key2=>$value2){
foreach($list['result'] as $key1=>$value1){
if($value2['created'] == $value1['created']){
$new_list[$value2['created']][] = $value1;
}
}
}
$users = $aApi->getUsers();
$this->assign('users',$users);
$this->assign('list',$new_list);
$this->display('/show_account');
}
<foreach name="list" item="vo">
<for start="0" end="count($vo)">
<?php $count=count($vo); ?>
<tr>
<if condition="$i eq 0">
<td rowspan="{$count}">{$vo[$i].created}</td>
</if>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].b}</td>
<td>{$vo[$i].c}</td>
<td>{$vo[$i].d}</td>
<td>{$vo[$i].e}</td>
<td>{$vo[$i].f}</td>
<td>{$vo[$i].g}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$users[$vo[$i]['uid']]}</td>
</tr>
</for>
</foreach>
$m = new Model();
$sql = "select *,FROM_UNIXTIME(created,'%Y-%m-%d') as created from table1 group by created ORDER BY created desc";
$result = $m->query($sql);
$sql2 = "select distinct FROM_UNIXTIME(created'%Y-%m-%d') as created from table2 group by created ORDER BY created desc;";
$result2 = $m->query($sql2);
return array('result'=>$result,'result2'=>$result2);
}
public function getUsers(){
$user = M("user", 'test_');
return $user->getField('id,real_name');
}
public function show(){
$aApi = new AApi();
$list = $aApi->show();
$new_list = array();
foreach($list['result2'] as $key2=>$value2){
foreach($list['result'] as $key1=>$value1){
if($value2['created'] == $value1['created']){
$new_list[$value2['created']][] = $value1;
}
}
}
$users = $aApi->getUsers();
$this->assign('users',$users);
$this->assign('list',$new_list);
$this->display('/show_account');
}
<foreach name="list" item="vo">
<for start="0" end="count($vo)">
<?php $count=count($vo); ?>
<tr>
<if condition="$i eq 0">
<td rowspan="{$count}">{$vo[$i].created}</td>
</if>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].b}</td>
<td>{$vo[$i].c}</td>
<td>{$vo[$i].d}</td>
<td>{$vo[$i].e}</td>
<td>{$vo[$i].f}</td>
<td>{$vo[$i].g}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$vo[$i].a}</td>
<td>{$users[$vo[$i]['uid']]}</td>
</tr>
</for>
</foreach>