$_W['uid'])); $new_id = intval($new_id); $notices = pdo_fetchall('SELECT id FROM ' . tablename('article_notice') . ' WHERE is_display = 1 AND id > :id', array(':id' => $new_id)); if(!empty($notices)) { foreach($notices as &$notice) { $insert = array( 'uid' => $_W['uid'], 'notice_id' => $notice['id'], 'is_new' => 1, ); pdo_insert('article_unread_notice', $insert); } } $total = 0; $notreads = array(); $total = pdo_fetchcolumn('SELECT COUNT(*) FROM' . tablename('article_unread_notice') . ' WHERE uid = :uid AND is_new = 1', array(':uid' => $_W['uid'])); $categorys = pdo_fetchall('SELECT id,title FROM ' . tablename('article_category') . ' WHERE type = :type', array(':type' => 'notice'), 'id'); if($total > 0) { $notreads = pdo_fetchall('SELECT id,title,createtime,cateid FROM ' . tablename('article_notice') . ' WHERE is_display = 1 AND id IN (SELECT notice_id FROM '. tablename('article_unread_notice') . ' WHERE uid = :uid AND is_new = 1) ORDER BY displayorder DESC, id DESC LIMIT 5', array(':uid' => $_W['uid']), 'id'); foreach($notreads as &$notread) { $notread['catename'] = $categorys[$notread['cateid']]['title']; $notread['is_new'] = 1; } } if($total < 5) { $limit = 5 - $total; $notices = pdo_fetchall('SELECT id,title,createtime,cateid FROM ' . tablename('article_notice') . ' WHERE is_display = 1 ORDER BY displayorder DESC, id DESC LIMIT ' . $limit, array(), 'id'); foreach($notices as &$notice) { $notice['catename'] = $categorys[$notice['cateid']]['title']; $notice['is_new'] = 0; } } $notices = array_merge($notreads, $notices); $html = ''; if(!empty($notices)) { foreach($notices as $row) { $class = 'new'; if(!$row['is_new']) { $class = 'old'; } $html .= '

' . '' . '

' . $row['title'] . '

' . '

' . date('Y-m-d', $row['createtime']) . '

' . '

'. $row['catename'] .'

' . '' . '

'; } } $data = array( 'total' => $total, 'notices' => $html ); exit(json_encode($data));