public static function getUserById($uid)
{
$uid = (int) $uid;
if ($uid <= 0) {
return '';
}
$sql = "SELECT * FROM `user` WHERE `id` = '" . $uid . "'";
return DBMysqli::getInstance()->getRow($sql);
}
/**
*
* @brief 分页
* @param unknown_type $model
* @param unknown_type $pageSize
* @param unknown_type $map
* @param unknown_type $order
* @param unknown_type $join
* @param unknown_type $field
*/
public static function showPage($majory, $order = 'puid', $limit = 30)
{
$field = self::_getFields();
$where = "`majory_id` = {$majory['id']}";
$sqlCount = "SELECT count(*) as count FROM " . self::$TABLE_DIARY . " WHERE {$where}";
$page = HttpNamespace::getGET('p', 1);
$offset = ($page - 1) * $limit;
$sql = "SELECT " . implode(',', $field) . " FROM " . self::$TABLE_DIARY . " WHERE {$where} ORDER BY `" . $order . "` desc LIMIT {$offset},{$limit}";
$num = DBMysqli::getInstance()->getRow($sqlCount);
$page = new Page($num['count'], $limit);
$result[] = $page->show();
$result[] = DBMysqli::getInstance()->getAll($sql);
return $result;
}
public function defaultAction()
{
$content = addslashes(HttpNamespace::getPOST('content'));
$puid = HttpNamespace::getPOST('puid');
$backUrl = UrlNamespace::detailUrl(self::$MAJORY['id'], $puid);
if (empty(self::$CATEGORY)) {
$error = ErrorConfig::EMPTY_VALUE;
if (strpos($backUrl, '?') === false) {
$backUrl .= '?error=' . $error;
}
$backUrl .= '&error=' . $error;
HttpNamespace::redirect($backUrl);
}
if (empty($content)) {
//error = 1
$error = ErrorConfig::EMPTY_VALUE;
if (strpos($backUrl, '?') === false) {
$backUrl .= '?error=' . $error;
}
$backUrl .= '&error=' . $error;
HttpNamespace::redirect($backUrl);
}
if (isset($_SESSION['login']) && $_SESSION['login']) {
$userId = $_SESSION['user']['id'];
$nick_name = addslashes($_SESSION['user']['nick_name']);
} else {
$userId = 0;
$nick_name = '匿名用户';
}
$ua = 0;
$sql = "INSERT INTO " . self::$CATEGORY['table'] . "_comment (`puid`,`user_id`,\n `nick_name`,`content`,`times`,`ua`)VALUES({$puid},{$userId},'" . $nick_name . "',\n '" . $content . "'," . time() . ",{$ua})";
if (DBMysqli::getInstance()->execute($sql) > 0) {
$sql = "UPDATE " . self::$CATEGORY['table'] . " set comment_times=comment_times+1,weight=weight+1 WHERE puid={$puid}";
DBMysqli::getInstance()->execute($sql);
}
HttpNamespace::redirect($backUrl);
}
public static function getNameById($id)
{
$sql = "SELECT * FROM `image` WHERE `id`={$id}";
return DBMysqli::getInstance()->getRow($sql);
}
private function _getHospitalById($id)
{
$sql = "SELECT * FROM hospital_post WHERE `id` = " . $id;
return DBMysqli::getInstance()->getRow($sql);
}
private function _getDistrictById($districtId)
{
$sql = "SELECT * FROM district WHERE `district_id` = " . $districtId;
return DBMysqli::getInstance()->getRow($sql);
}
