/**
* 获取数据表中字段与默认值
*
* @return array
*/
public static function getTableAttribute()
{
$data = array();
foreach (Local::fetchAll('DESC z_accounts') as $k => $v) {
$data[$v['Field']] = $v['Default'] == null ? '' : $v['Default'];
}
return $data;
}
/**
* 进行数据更新
*
* @param array $data 要更新的数据
* @param int $id 要更新的用户
*
* @return void
*/
public static function update($data, $id)
{
$sql = 'UPDATE z_users SET ';
$inputParams = array();
foreach ($data as $k => $v) {
$sql .= "{$k}=:{$k},";
$inputParams[':' . $k] = $v;
}
$sql = substr($sql, 0, strlen($sql) - 1) . ' WHERE user_id=:user_id';
$inputParams[':user_id'] = $id;
$statement = Local::query($sql, $inputParams);
$statement->closeCursor();
}
/**
* 获取easyui格式的数据
*
* @return string
*/
public static function getEasyUITreeData()
{
$catData = Local::fetchAll('SELECT * FROM z_account_cats WHERE cat_status=1');
return self::getCatTree(0, $catData);
}
