<?php
// DO NOT EDIT THIS FILE.
// This file was generated by searchgen.
// If you need to customize this file, please edit the corresponding
// yaml file in the gencfg directory, and then re-generate this file
// by running searchgen, passing in the table name.
if (isset($command) && $command == 'loadAppuser') {
header('Content-Type: application/json');
$db = ConnectionFactory::getConnection();
$appuserDAO = new AppuserDAO($db);
$approleDAO = new ApproleDAO($db);
$id = isset($params['id']) ? (int) trim($params['id']) : 0;
if ($id <= 0) {
$rows = array(Appuser::createDefault());
} else {
$sql = <<<EOF
select * from appuser pri where pri.id = ?
EOF;
$ps = new PreparedStatement($sql, 0, 1);
$ps->setInt($id);
$rows = $appuserDAO->findWithPreparedStatement($ps);
}
$ps1 = new PreparedStatement(<<<EOF
select distinct r.* from appuserrole u_r inner join approle r on r.role_name = u_r.role_name where u_r.user_id = ? order by r.sort_order, r.role_name
EOF
, 0, 0);
foreach ($rows as &$row) {
$ps1->clearParams();
$ps1->setInt($row->id);
$row->roles = $id <= 0 ? array() : $approleDAO->findWithPreparedStatement($ps1);
}
}
if (returnToSearchMode) {
parent.setMode(parent.SEARCH_MODE, false);
}
<?php
}
?>
</script></body></html>
<?php
exit;
case 'deleteApprole':
$db = ConnectionFactory::getConnection();
$db->beginTransaction();
$committed = false;
$approleDAO = new ApproleDAO($db);
$result = createMsgResultObj();
$id = isset($_POST['id']) ? (int) trim($_POST['id']) : 0;
if ($approleDAO->load($id) === false) {
$result->errorMsg .= sprintf(_t('crud.idNotFoundRowNotDeleted'), _t('crud.approle.tableDescription', 'Role'), $id) . "\n";
} else {
if (function_exists('deleteCheckHook')) {
deleteCheckHook();
}
if ($result->errorMsg == '' && empty($result->fieldErrors)) {
if (function_exists('preDeleteHook')) {
preDeleteHook();
}
try {
$success = $approleDAO->delete($id);
} catch (Exception $ex) {
function deleteUserRoles()
{
global $db, $id;
$approleDAO = new ApproleDAO($db);
if ($role = $approleDAO->load($id)) {
$appuserroleDAO = new AppuserroleDAO($db);
foreach ($appuserroleDAO->findByRole_name($role->role_name) as $permrow) {
$appuserroleDAO->delete($permrow->id);
}
}
}
<?php
// DO NOT EDIT THIS FILE.
// This file was generated by searchgen.
// If you need to customize this file, please edit the corresponding
// yaml file in the gencfg directory, and then re-generate this file
// by running searchgen, passing in the table name.
if (isset($command) && $command == 'loadApprole') {
header('Content-Type: application/json');
$db = ConnectionFactory::getConnection();
$approleDAO = new ApproleDAO($db);
$apppermDAO = new ApppermDAO($db);
$id = isset($params['id']) ? (int) trim($params['id']) : 0;
if ($id <= 0) {
$rows = array(Approle::createDefault());
} else {
$sql = <<<EOF
select * from approle pri where pri.id = ?
EOF;
$ps = new PreparedStatement($sql, 0, 1);
$ps->setInt($id);
$rows = $approleDAO->findWithPreparedStatement($ps);
}
$ps1 = new PreparedStatement(<<<EOF
select distinct p.* from approleperm r_p inner join appperm p on p.perm_name = r_p.perm_name where r_p.role_name = ? order by p.perm_name
EOF
, 0, 0);
foreach ($rows as &$row) {
$ps1->clearParams();
$ps1->setString($row->role_name);
$row->perms = $id <= 0 ? array() : $apppermDAO->findWithPreparedStatement($ps1);
function saveRoles($user_id)
{
global $db, $row, $MAX_RESERVED_ID;
if ($row->id > 0 && $row->id <= $MAX_RESERVED_ID) {
return;
}
$appuserroleDAO = new AppuserroleDAO($db);
$approleDAO = new ApproleDAO($db);
$roles = array();
foreach ($approleDAO->findAll('sort_order, role_name') as $role) {
$valname = 'role_nameSelected_' . $role->role_name;
if (isset($_POST[$valname]) && (int) $_POST[$valname] != 0) {
$obj = new stdClass();
$obj->user_id = $user_id;
$obj->role_name = $role->role_name;
$roles[] = $obj;
}
}
ChildRowUpdater::updateChildRows($db, 'Appuserrole', $roles, array('user_id' => $user_id), array('user_id', 'role_name'));
}
