public function get($id)
{
$sql = "SELECT * FROM role WHERE id=:id";
$params[':id'] = $id;
$role = $this->daoTemplate->queryForObject($sql, new RoleRowMapper(), $params);
$sql = "SELECT code_right FROM role_right WHERE id_role=:id";
$role->listRight = $this->daoTemplate->simpleQueryToArray($sql, $params);
return $role;
}
public function checkFieldIsUnique($fieldName, $value, $currentId)
{
//$fieldName = $this->daoTemplate->escapeString($fieldName);
$sql = "SELECT id FROM user where {$fieldName} = :value AND id<>:id";
$params[':id'] = $currentId;
$params[':value'] = $value;
$result = $this->daoTemplate->simpleQueryToArray($sql, $params);
if (sizeof($result) > 0) {
return false;
}
return true;
}
