$selectsqlpage="select yjbh,yjnr,new,yjtype,zhuti,fjlj,fjm,yjsj,fsname from youjian where $timebw and yjtype=1 and jsname='$_SESSION[username]' and cgbz='0' order by yjsj desc limit $offset,$pageSize";
// echo $selectsqlpage;
$rs1 = mysql_query($selectsqlpage);
if (@mysql_num_rows($rs1) > 0) {
$scbz=1;
while($r1 = mysql_fetch_array($rs1)) {
$fjlj=$r1['fjlj'];
if ($fjlj=="") {
$img='052n';
$fjbz="无附件";
}else{
$img='052';
$fjbz="有附件";
}
$new=$r1['new']==1?"new_email":"email";
$bb=$r1['new']==1?"color:#000;font-weight:normal":"color:#666";
if((time()-strtotime($r1['yjsj']))<=86400) {//小于今天
if ($scbz==1) {
echo "<tr><td colspan='7' style='background:#fff;border-bottom:1px solid #ccc;color:#445494;'><b>今日邮件:</b></td></tr>";
$scbz=2;
}
}else{
if((time()-strtotime($r1['yjsj']))<=604800 && (time()-strtotime($r1['yjsj']))>86400) {//小于7天
if ($scbz==1 || $scbz==2) {//2种可能2个值
echo "<tr><td colspan='7' style='background:#fff;border-bottom:1px solid #ccc;color:#445494;'><b>7日内邮件:</b></td>< /tr>";
$scbz=3;
}
}else{
if((time()-strtotime($r1['yjsj']))>=604800) {//其他可能
if ($scbz==1 || $scbz==2 || $scbz==3) {//4种可能3个值
echo "<tr><td colspan='7' style='background:#fff;border-bottom:1px solid #ccc;color:#445494;'><b>更早邮件:</b></td></tr>";
$scbz=4;
}
}
}
}
echo "<tr><td><input type=\"checkbox\" value=\"$r1[yjbh]\" name='checkdel[]'></td><td id=\"setId\" style=\"$bb\"><img style=\"vertical-align: middle; margin-left:6px;\" width=\"15px\" height=\"14px\" src=\"/skin/images/$new.png\"></td><td style=\"$bb\" >$r1[fsname]</td><td><a href=\"/action/del.php?action=shehzi&bh=$r1[yjbh]\" style=\"$bb\" title=\"$r1[zhuti]\">".mb_substr($r1['zhuti'],0,23,'utf-8')."</a></td>";
echo "<td style=\"$bb\" >".mb_substr($r1['yjsj'],0,16,'utf-8')."</td><td><a href=\"/email/emailLogin_xie1.php?bh=$r1[yjbh]\"><img style='vertical-align: middle;' src=\"/images/051.gif\" title='回信'></a><a href=\"/email/emailLogin_xie1.php?zfbh=$r1[yjbh]\" ><img style='vertical-align: middle;' src=\"/images/056.gif\" title='转发'></a><a href=\"/action/del.php?action=shehzi&bh=$r1[yjbh]\" ><img style='vertical-align: middle;' src=\"/images/".$img.".png\" title='".$fjbz."'></a><a href=\"/action/shanchu.php?bh=$r1[yjbh]\" ><img style='vertical-align: middle;padding-right:5px;' src=\"/images/053.gif\" title='删除'></a></td><td><span style='display:inline-block;width:98%; height:25px;overflow: hidden; color:#666'>$r1[yjnr]</span></td></tr>";
}
}