public static function factory(Storage $storage, $row)
{
$role = new Role($storage);
$role->setRoleID($row["roleid"]);
$role->setLabel($row["label"]);
$role->setDescription($row["description"]);
return $role;
}
function parseRoleFormular($session, &$role = null)
{
$label = $session->getVariable("label");
$description = $session->getVariable("description");
if ($role == null) {
$role = new Role($session->getStorage());
}
$role->setLabel($label);
$role->setDescription($description);
$role->save();
}
public function executeProcessNewOrgRoleForm(sfWebRequest $request)
{
$o = Doctrine::getTable('Organization')->find($request->getParameter('id'));
$this->forward404Unless($o->isMy());
$r = new Role();
$r->setName($request->getParameter("name"));
$r->setOrganizationId($o->getId());
$r->setDescription($request->getParameter("description"));
$r->save();
$this->redirect("show/index?id=" . $o->getId());
}
function insertRole($data)
{
$connection = connect();
$role = new Role();
echo dump($data);
$role->setRole(mysqli_real_escape_string($connection, $data['role']));
$role->setDescription(mysqli_real_escape_string($connection, $data['description']));
$query = "insert into role (";
$query .= " role,description ";
$query .= ") values( ";
$query .= " '{$role->getRole()}','{$role->getDescription()}'";
$query .= ")";
$result = mysqli_query($connection, $query);
if ($result) {
$id = mysqli_insert_id($connection);
return $id;
}
colse_connection($connection);
return null;
}
public function setDescription($description)
{
$this->_load();
return parent::setDescription($description);
}
/**
* Function adds a role to database
*
* @param sfWebRequest $request
* @return <type>
*/
public function executeAddRole(sfWebRequest $request) {
$data = $request->getPostParameters();
if(count($data) > 2) { // some rights are set
unset($data['userrole_title_name']);
unset($data['hiddenfield']);
$values = array_keys($data);
$roleObj = new Role();
$roleObj->setDescription($request->getParameter('userrole_title_name'));
$roleObj->save();
$id = $roleObj->getId();
foreach($values as $item) {
$rolecredObj = new CredentialRole();
$rolecredObj->setRoleId($id);
$rolecredObj->setCredentialId($item);
$rolecredObj->save();
}
}
else { // Only Userrole is written in textfield, nothing else
$obj = new Role();
$obj->setDescription($request->getParameter('userrole_title_name'));
$obj->save();
}
$this->renderText('{success:true}');
return sfView::NONE;
}
