本文整理匯總了PHP中table_sql::set_sql方法的典型用法代碼示例。如果您正苦於以下問題：PHP table_sql::set_sql方法的具體用法？PHP table_sql::set_sql怎麽用？PHP table_sql::set_sql使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類table_sql的用法示例。
在下文中一共展示了table_sql::set_sql方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: render
/**
* Display the general status log table.
*
* @param int $pagesize
* @param bool $useinitialsbar
*/
public function render($pagesize, $useinitialsbar = true)
{
$columns = array('owner', 'for_user_email', 'senddate', 'enrolperiod', 'submission_code', 'course', 'cohorts', 'groups', 'issend');
if ($this->filter === self::UNUSED) {
$columns[] = 'action';
}
$this->define_table_columns($columns);
// Generate SQL.
$fields = 'c.*, ' . get_all_user_name_fields(true, 'u');
if ($this->filter === self::UNUSED) {
$fields .= ', NULL as action';
}
$from = '{block_coupon} c LEFT JOIN {user} u ON c.ownerid=u.id';
$where = array();
$params = array();
if ($this->ownerid > 0) {
$where[] = 'c.ownerid = ?';
$params[] = $this->ownerid;
}
switch ($this->filter) {
case self::USED:
$where[] = 'c.userid IS NOT NULL AND c.userid <> 0';
break;
case self::UNUSED:
$where[] = 'c.userid IS NULL';
break;
case self::ALL:
// Has no extra where clause.
break;
}
parent::set_sql($fields, $from, implode(' AND ', $where), $params);
$this->out($pagesize, $useinitialsbar);
}