本文整理汇总了PHP中PbModel::setOrderby方法的典型用法代码示例。如果您正苦于以下问题:PHP PbModel::setOrderby方法的具体用法?PHP PbModel::setOrderby怎么用?PHP PbModel::setOrderby使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类PbModel
的用法示例。
在下文中一共展示了PbModel::setOrderby方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: smarty_block_getdata
//.........这里部分代码省略.........
if (isset($params['include'])) {
$conditions[] = $M->getIncludeIds($params['include']);
}
if (isset($params['orderby'])) {
$orderbys[] = trim($params['orderby']);
}
if (!empty($row) && $row != 'all' && $row != -1) {
$M->setLimitOffset($offset, $limit);
$mysql_limit = $M->getLimitOffset();
}
if (!empty($params['limit'])) {
$mysql_limit = " " . trim($params['limit']);
}
if (!empty($_GET['producttypeid'])) {
$conditions[] = "type_id=" . intval($_GET['producttypeid']);
}
if (!empty($params['companyid'])) {
$conditions[] = "company_id=" . intval($params['companyid']);
}
if (!empty($params['industryid'])) {
$conditions[] = "industry_id=" . intval($params['industryid']);
}
if (!empty($params['typeid'])) {
if ($_table == 'adses') {
$conditions[] = "adzone_id=" . intval($params['typeid']);
} else {
$conditions[] = "type_id=" . intval($params['typeid']);
}
}
if (empty($sTemplate->block_data[$iTags])) {
# ************************************************************************
# Main content
$M->setCondition($conditions);
$M->setOrderby($orderbys);
$sql = sprintf("SELECT * FROM %s%s %s %s %s", $M->table_prefix, $C->pluralize($_table), $M->getCondition(), $M->getOrderby(), $mysql_limit);
$sTemplate->block_data[$iTags] = $M->GetArray($sql);
//如果没有数据,那就不用再执行了(repeat)
if (!$sTemplate->block_data[$iTags]) {
return $repeat = false;
}
if (isset($stat)) {
$_total_count = $M->dbstuff->GetOne(sprintf("SELECT count(*) FROM %s%s %s", $M->table_prefix, $C->pluralize($_table), $M->getCondition()));
$sTemplate->assign('total_count', $_total_count);
$sTemplate->assign("paging", array('total' => $_total_count));
}
# End main content
# ************************************************************************
}
if (!$sTemplate->block_data[$iTags]) {
$repeat = false;
return '';
}
if (!function_exists("smarty_function_the_url")) {
require "function.the_url.php";
}
$counts = count($sTemplate->block_data[$iTags]);
if (list($key, $item) = each($sTemplate->block_data[$iTags])) {
$_title = $_title_full = $_content = $_content_full = '';
$item['rownum'] = $key;
$item['iteration'] = ++$key;
if (!empty($item['url'])) {
$url = $item['url'];
} else {
$url = smarty_function_the_url(array("do" => $module, "id" => $item['id'], "action" => 'detail'));
}
if ($module == "company") {