📄 emaillist.class.inc.php
字号:
<?php
/**
* GentleSource Temporary E-mail - emaillist.class.inc.php
*
* @copyright (C) Ralf Stadtaus , {@link http://www.gentlesource.com/}
*
*/
require_once 'list.class.inc.php';
/**
* Generate comment list
*/
class t12l_email_list extends t12l_list
{
/**
* Database fields to be selected
*/
var $fields = array('mail_id',
'mail_from',
'mail_subject',
'mail_excerpt',
'mail_timestamp',
);
/**
* Columns that can be sorted
*/
var $order_columns = array('mail_timestamp');
/**
* Identifier to tell different list settings in session apart
*/
var $identifier = 'maillist';
/**
* Default order direction for SQL statement
* Possible values: ascending|descending
*/
var $default_order_direction = 'descending';
/**
* Default order field for SQL statement
*/
var $default_order_field = 'tm.mail_timestamp';
//------------------------------------------------------------------------------
/**
* Constructor
*/
function t12l_email_list($use_session, $setup = array())
{
global $t12l;
// Configuration and setup
if ($use_session == true) {
$this->use_session = true;
}
$this->t12l_list($setup);
}
//------------------------------------------------------------------------------
/**
* Get mail list
*/
function get_list($address_id)
{
global $t12l;
list($where, $data) = $this->where();
$sql = "SELECT " . t12l_database::fields('tm', $this->fields) . "
FROM (" . T12L_MAIL_TABLE . " AS tm)
" . $where . "
AND tm.mail_address_id = ?
ORDER BY " . $this->order_field . " " . $this->order_direction;
t12l_system_debug::add_message('SQL Statement get_list()', $sql, 'debug');
$list = array();
if ($res = $this->query($sql, array($address_id))) {
// Mail number
if ($this->order_direction == 'ASC') {
$mail_number = 0;
} else {
$mail_number = $this->num_results;
}
// Fetch mails
while ($row = $res->fetchRow())
{
t12l_clean_output($row);
// Mail number
if ($this->order_direction == 'ASC') {
$mail_number++;
} else {
$mail_number--;
}
// Enhance user data
$enhance = array(
'frontend_date' => t12l_time::format_date($row['mail_timestamp']),
'frontend_time' => t12l_time::format_time($row['mail_timestamp']),
'frontend_text' => htmlentities(strip_tags(str_replace("\n", ' ', str_replace("\r", ' ', trim($row['mail_excerpt']))))),
'frontend_number' => $mail_number
);
$row['frontend_subject'] = htmlentities(strip_tags($row['mail_subject']));
$row['frontend_from'] = htmlentities($row['mail_from']);
$final = array_merge(
$row,
$enhance
);
t12l_module::call_module('frontend_content', $final, $t12l['module_additional']);
$list[] = $final;
}
}
return $list;
}
//------------------------------------------------------------------------------
}
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -