php /* departments $Id: view.php,v 1.1.1.1 2005/10/19 10:47:30 soulis Exp $ */ require_once "../common/classes/mime_icons.php"; $deptuser_id = intval( dPgetParam( $_GET, "deptuser_id", 0 ) ); $user_id = intval( dPgetParam( $_GET, "user_id", 0 ) ); $frmname = ($_GET['frmname'] != '' ? $_GET['frmname'] : ($_POST['frmname'] != '' ? $_POST['frmname'] : '')); $filter = ($_GET['filter'] != '' ? $_GET['filter'] : ($_POST['filter'] != '' ? $_POST['filter'] : '')); $keyword = ($_GET['keyword'] != '' ? $_GET['keyword'] : ($_POST['keyword'] != '' ? $_POST['keyword'] : '')); $sort = ($_GET['sort'] != '' ? $_GET['sort'] : ($_POST['sort'] != '' ? $_POST['sort'] : '')); $status = ($_GET['status'] != '' ? $_GET['status'] : ($_POST['status'] != '' ? $_POST['status'] : '')); $up = ($_GET['up'] != '' ? $_GET['up'] : ($_POST['up'] != '' ? $_POST['up'] : '')); $page = ($_GET['page'] != '' ? $_GET['page'] : ($_POST['page'] != '' ? $_POST['page'] : '')); $perpage = ($_GET['perpage'] != '' ? $_GET['perpage'] : ($_POST['perpage'] != '' ? $_POST['perpage'] : '')); $mode = ($_GET['mode'] != '' ? $_GET['mode'] : ($_POST['mode'] != '' ? $_POST['mode'] : '')); // get the prefered date format $df = $AppUI->getPref('SHDATEFORMAT'); // check permissions for this record $canRead = $u ? !getDenyRead( $u, $deptuser_id ) : !getDenyRead( $m, $deptuser_id ); $canEdit = $u ? !getDenyEdit( $u, $deptuser_id ) : !getDenyEdit( $m, $deptuser_id ); if (!$canRead) { $AppUI->redirect( "p=$p&m=lib&u=misc&a=access_denied" ); } // retrieve any state parameters if (isset( $_GET['tab'] )) { $AppUI->setState( 'departmentsVwTab', $_GET['tab'] ); } $tab = $AppUI->getState( 'departmentsVwTab' ) !== NULL ? $AppUI->getState( 'departmentsVwTab' ) : 0; // check if this record has dependancies to prevent deletion $msg = ''; $obj = new CDeptuser(); $canDelete = $obj->canDelete( $msg, $deptuser_id ); // load the record data $sql = " SELECT department_user.* FROM department_user WHERE department_user.deptuser_id = $deptuser_id "; $obj = null; if (!db_loadObject( $sql, $obj )) { $AppUI->setMsg( 'Deptuser' ); $AppUI->setMsg( "invalidID", UI_MSG_ERROR, true ); $AppUI->redirect(); } else { $AppUI->savePlace(); } // create Date objects from the datetime fields $sql = 'select dept_id, dept_name from departments order by dept_name'; $_deptuser_department_id = arrayMerge( array( '0'=>'' ), db_loadHashList( $sql ) ); $sql = 'select user_id, CONCAT_WS(" ", user_last_name, user_first_name) from users order by user_last_name'; $_deptuser_user_id = arrayMerge( array( '0'=>'' ), db_loadHashList( $sql ) ); // load the @defaultval@ types // setup the title block $titleBlock = new CTitleBlock( 'View deptuser', '', $m, $u, "$m.$a" ); if ($canEdit) { $titleBlock->addCell(); } if ($canEdit) { $titleBlock->addCrumb( "?p=$p&m=users&u=departments&a=addedit&deptuser_id=$deptuser_id&user_id=$user_id", "Edit this deptuser" ); if ($canEdit) { $titleBlock->addCrumbDelete( 'Delete deptuser', $canDelete, $msg ); } } $titleBlock->show(); ?>