/**
* 根据账户ID获取单条数据记录
*
* @param int $account_id 账户ID主键
* @param string $field 检索的字段
*
* @return array
*/
public static function getAccountById($account_id, $field = '*')
{
return Local::fetchOne('SELECT a.' . $field . ',c.cat_title FROM z_accounts a LEFT JOIN z_account_cats c ON a.account_cat=c.cat_id WHERE account_id=:account_id LIMIT 1', array(':account_id' => $account_id));
}
/**
* 通过用户名来获取用户信息
*
* @param string $field 查询的字段
* @param string $username 登录系统的用户名
*
* @return array
*/
public static function getUserDataByUsername($field, $username)
{
return Local::fetchOne('SELECT ' . $field . ' FROM z_users WHERE user_name=:user_name LIMIT 1', array(':user_name' => $username));
}
/**
* 根据分类ID获取分类数据
*
* @param int $cid 分类ID
* @param string $field 要检索的字段
*
* @return array
*/
public static function getCatsDataById($cid, $field = '*')
{
$catData = Local::fetchOne('SELECT ' . $field . ' FROM z_account_cats WHERE cat_id=:cat_id LIMIT 1', array(':cat_id' => $cid));
return $catData;
}
