*/ /** * Script to merge or transfer courses. * Two columns are shown with courses that matches the filter. * Mark the course on the left side, that will be merged with the one on the right side. */ require_once('../../config/vilesci.config.inc.php'); require_once('../../include/basis_db.class.php'); //require_once('../../include/person.class.php'); require_once('../../include/functions.inc.php'); require_once('../../include/benutzerberechtigung.class.php'); require_once('../../include/studiengang.class.php'); require_once('../../include/organisationsform.class.php'); require_once('../../include/studienplan.class.php'); require_once('../../include/studiensemester.class.php'); require_once('../../include/lehrveranstaltung.class.php'); require_once('../../include/lehrtyp.class.php'); require_once('../../include/log.class.php'); if (!$db = new basis_db()) die('Es konnte keine Verbindung zum Server aufgebaut werden.'); $uid = get_uid(); $rechte = new benutzerberechtigung(); $rechte->getBerechtigungen($uid); if(!$rechte->isBerechtigt('lehre/lehrveranstaltung')) die($rechte->errormsg); $activeAddons = array_filter(explode(";", ACTIVE_ADDONS)); $msg=''; $input_text_left = isset($_REQUEST['input_text_left'])?$_REQUEST['input_text_left']:''; $input_text_right = isset($_REQUEST['input_text_right'])?$_REQUEST['input_text_right']:''; $select_stg_kz_left = isset($_REQUEST['select_stg_kz_left'])?$_REQUEST['select_stg_kz_left']:''; $select_stg_kz_right = isset($_REQUEST['select_stg_kz_right'])?$_REQUEST['select_stg_kz_right']:''; $select_semester_left = isset($_REQUEST['select_semester_left'])?$_REQUEST['select_semester_left']:'-1'; $select_semester_right = isset($_REQUEST['select_semester_right'])?$_REQUEST['select_semester_right']:'-1'; $select_orgform_left = isset($_REQUEST['select_orgform_left'])?$_REQUEST['select_orgform_left']:''; $select_orgform_right = isset($_REQUEST['select_orgform_right'])?$_REQUEST['select_orgform_right']:''; $select_studienplan_left = isset($_REQUEST['select_studienplan_left'])?$_REQUEST['select_studienplan_left']:''; $select_studienplan_right = isset($_REQUEST['select_studienplan_right'])?$_REQUEST['select_studienplan_right']:''; $select_lehrtyp_left = isset($_REQUEST['select_lehrtyp_left'])?$_REQUEST['select_lehrtyp_left']:''; $select_lehrtyp_right = isset($_REQUEST['select_lehrtyp_right'])?$_REQUEST['select_lehrtyp_right']:''; $courseLeft = isset($_REQUEST['courseLeft'])?$_REQUEST['courseLeft']:'-1'; $courseRight = isset($_REQUEST['courseRight'])?$_REQUEST['courseRight']:'-1'; $stsem = new studiensemester(); $stsem_default = $stsem->getakt(); $studiensemester_kurzbz = isset($_REQUEST['studiensemester_kurzbz'])?$_REQUEST['studiensemester_kurzbz']:$stsem_default; //echo $courseLeft.'
'; //echo $courseRight.'
'; if (isset($_REQUEST['compare'])) { if ($courseLeft!=$courseRight && $courseLeft!='-1' && $courseRight!='-1') { // Define an array of attributes, that are NOT to be compared $deleteValues = array( 'new' => null, 'ext_id' => null, 'insertamum' => null, 'insertvon' => null, 'updateamum' => null, 'updatevon' => null, 'bezeichnung_arr' => null, 'lehrveranstaltungen' => null, 'errormsg' => null ); $lv1 = new lehrveranstaltung(); $lv1->load($courseLeft); $lv1_arr = get_object_vars($lv1); $lv1_arr = array_diff_key($lv1_arr, $deleteValues); $lv2 = new lehrveranstaltung(); $lv2->load($courseRight); $lv2_arr = get_object_vars($lv2); $lv2_arr = array_diff_key($lv2_arr, $deleteValues); $lv_diff1 = array_diff_assoc($lv1_arr, $lv2_arr); $lv_diff2 = array_diff_assoc($lv2_arr, $lv1_arr); $msg = 'Differences in courses (only columns with differences are shown)'; $msg .= ''; foreach ($lv_diff1 as $key => $value) { $msg .= ''; } $msg .= ''; foreach ($lv_diff1 as $key => $value) { if (is_bool($value)) $msg .= ''; elseif ($key == 'farbe') $msg .= ''; else $msg .= ''; } $msg .= ''; foreach ($lv_diff2 as $key => $value) { if (is_bool($value)) $msg .= ''; elseif ($key == 'farbe') $msg .= ''; else $msg .= ''; } $msg .= '
'.StringCut($key,10,false,'...').'
'.($value?'true':'false').''.$value.'     '.$value.'
'.($value?'true':'false').''.$value.'     '.$value.'
'; } else $msg="Please select 2 different courses"; } if((isset($_REQUEST['transfer']) || isset($_REQUEST['mergeDelete'])) && isset($courseLeft) && isset($courseRight) && $courseLeft>=0 && $courseRight>=0) { if($courseLeft==$courseRight) { $msg="The courses may not have the same ID"; } else { if(!$rechte->isBerechtigt('lehre/lehrveranstaltung', NULL, 'sui')) die($rechte->errormsg); $msg=''; $update_qry="BEGIN;"; if (isset($_REQUEST['transfer'])) { $update_qry.="UPDATE campus.tbl_benutzerlvstudiensemester SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER)." AND studiensemester_kurzbz=".$db->db_add_param($studiensemester_kurzbz).";"; $update_qry.="UPDATE campus.tbl_lvgesamtnote SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER)." AND studiensemester_kurzbz=".$db->db_add_param($studiensemester_kurzbz).";"; // Updates for Pruefungsverwaltung $update_qry.="UPDATE campus.tbl_lehrveranstaltung_pruefung SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER)." AND pruefung_id IN (SELECT pruefung_id FROM campus.tbl_pruefung WHERE studiensemester_kurzbz=".$db->db_add_param($studiensemester_kurzbz).");"; $update_qry.="UPDATE campus.tbl_pruefungsanmeldung SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER)." AND pruefungstermin_id IN (SELECT pruefungstermin_id FROM campus.tbl_pruefungstermin JOIN campus.tbl_pruefung USING (pruefung_id) WHERE studiensemester_kurzbz=".$db->db_add_param($studiensemester_kurzbz).");"; // LV-Infos will be copied if $courseRight has none and $courseLeft has some $lvinfo_qry_right = "SELECT * FROM campus.tbl_lvinfo WHERE lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER).";"; $result_right = $db->db_query($lvinfo_qry_right); $lvinfo_qry_left = "SELECT * FROM campus.tbl_lvinfo WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $result_left = $db->db_query($lvinfo_qry_left); // Check if $courseRight has lvinfos if ($db->db_affected_rows($result_right)==0) { if ($db->db_affected_rows($result_left)>0) { while($row = $db->db_fetch_object($result_left)) { $update_qry.=" INSERT INTO campus.tbl_lvinfo (lehrveranstaltung_id, sprache, titel, lehrziele, lehrinhalte, methodik, voraussetzungen, unterlagen, pruefungsordnung, anmerkung, kurzbeschreibung, genehmigt, aktiv, updateamum, updatevon, insertamum, insertvon, anwesenheit) SELECT ".$db->db_add_param($courseRight, FHC_INTEGER).", ".$db->db_add_param($row->sprache).", titel, lehrziele, lehrinhalte, methodik, voraussetzungen, unterlagen, pruefungsordnung, anmerkung, kurzbeschreibung, genehmigt, aktiv, NULL, NULL, now(), ".$db->db_add_param($uid).", anwesenheit FROM campus.tbl_lvinfo WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER)." AND sprache=".$db->db_add_param($row->sprache).";"; } } } $update_qry.="/*
*/"; $update_qry.="UPDATE lehre.tbl_lehreinheit SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER)." AND studiensemester_kurzbz=".$db->db_add_param($studiensemester_kurzbz).";"; // If lerhfach_id was the same as the old lehrveranstaltung_id, it will be changed to $update_qry.="UPDATE lehre.tbl_lehreinheit SET lehrfach_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrfach_id=".$db->db_add_param($courseLeft, FHC_INTEGER)." AND lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." AND studiensemester_kurzbz=".$db->db_add_param($studiensemester_kurzbz).";"; $update_qry.="UPDATE lehre.tbl_zeugnisnote SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER)." AND studiensemester_kurzbz=".$db->db_add_param($studiensemester_kurzbz).";"; $update_qry.="UPDATE lehre.tbl_lvangebot SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER)." AND studiensemester_kurzbz=".$db->db_add_param($studiensemester_kurzbz).";"; // Notenschluesselzuordnung will be copied if $courseRight has none and $courseLeft has some $notenschluessel_qry_right = "SELECT * FROM lehre.tbl_notenschluesselzuordnung WHERE lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER).";"; $result_notenschluessel_right = $db->db_query($notenschluessel_qry_right); $notenschluessel_qry_left = "SELECT * FROM lehre.tbl_notenschluesselzuordnung WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $result_notenschluessel_left = $db->db_query($notenschluessel_qry_left); // Check if $courseRight has notenschluesselzuordnung if ($db->db_affected_rows($result_notenschluessel_right)==0) { if ($db->db_affected_rows($result_notenschluessel_left)>0) { while($row = $db->db_fetch_object($result_notenschluessel_left)) { $update_qry.=" INSERT INTO lehre.tbl_notenschluesselzuordnung (notenschluessel_kurzbz, lehrveranstaltung_id, studienplan_id, oe_kurzbz, studiensemester_kurzbz) SELECT notenschluessel_kurzbz, ".$db->db_add_param($courseRight, FHC_INTEGER).", studienplan_id, oe_kurzbz, studiensemester_kurzbz FROM lehre.tbl_notenschluesselzuordnung WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; } } } $update_qry.="/*
*/"; $update_qry.="UPDATE public.tbl_preincoming_lehrveranstaltung SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="/*
Addons
*/"; //addon lvevaluierung if (in_array('lvevaluierung', $activeAddons)) { $update_qry.="UPDATE addon.tbl_lvevaluierung SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER)." AND studiensemester_kurzbz=".$db->db_add_param($studiensemester_kurzbz).";"; } //addon moodle if (in_array('moodle', $activeAddons)) { $update_qry.="UPDATE addon.tbl_moodle SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER)." AND studiensemester_kurzbz=".$db->db_add_param($studiensemester_kurzbz).";"; } //addon lvinfo if (in_array('lvinfo', $activeAddons)) { $update_qry.="UPDATE addon.tbl_lvinfo SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER)." AND studiensemester_kurzbz=".$db->db_add_param($studiensemester_kurzbz).";"; } } if (isset($_REQUEST['mergeDelete'])) { if(!$rechte->isBerechtigt('lehre/lehrveranstaltung', NULL, 'suid')) die($rechte->errormsg); $update_qry.="UPDATE campus.tbl_benutzerlvstudiensemester SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="UPDATE campus.tbl_feedback SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="UPDATE campus.tbl_lehrveranstaltung_pruefung SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="UPDATE campus.tbl_lvgesamtnote SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="UPDATE campus.tbl_lvinfo SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="UPDATE campus.tbl_pruefungsanmeldung SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="/*
*/"; $update_qry.="UPDATE lehre.tbl_anrechnung SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="UPDATE lehre.tbl_anrechnung SET lehrveranstaltung_id_kompatibel=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id_kompatibel=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="UPDATE lehre.tbl_lehreinheit SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="UPDATE lehre.tbl_lehreinheit SET lehrfach_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrfach_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="UPDATE lehre.tbl_lehrveranstaltung_kompatibel SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="UPDATE lehre.tbl_lehrveranstaltung_kompatibel SET lehrveranstaltung_id_kompatibel=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id_kompatibel=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="UPDATE lehre.tbl_lvangebot SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="UPDATE lehre.tbl_lvregel SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="UPDATE lehre.tbl_lvregel SET studienplan_lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE studienplan_lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="UPDATE lehre.tbl_notenschluesselzuordnung SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="UPDATE lehre.tbl_studienplan_lehrveranstaltung SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="UPDATE lehre.tbl_studienplan_lehrveranstaltung SET studienplan_lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE studienplan_lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="UPDATE lehre.tbl_studienplan_lehrveranstaltung SET studienplan_lehrveranstaltung_id_parent=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE studienplan_lehrveranstaltung_id_parent=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="UPDATE lehre.tbl_vertrag SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="UPDATE lehre.tbl_zeugnisnote SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="/*
*/"; $update_qry.="UPDATE public.tbl_preincoming_lehrveranstaltung SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="/*
Addons
*/"; //addon lvevaluierung if (in_array('lvevaluierung', $activeAddons)) { $update_qry.="UPDATE addon.tbl_lvevaluierung SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; } //addon moodle if (in_array('moodle', $activeAddons)) { $update_qry.="UPDATE addon.tbl_moodle SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; } //addon lvinfo if (in_array('lvinfo', $activeAddons)) { $update_qry.="UPDATE addon.tbl_lvinfo SET lehrveranstaltung_id=".$db->db_add_param($courseRight, FHC_INTEGER)." WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; } $update_qry.="/*
*/"; $update_qry.="DELETE FROM lehre.tbl_lehrveranstaltung WHERE lehrveranstaltung_id=".$db->db_add_param($courseLeft, FHC_INTEGER).";"; $update_qry.="/*

*/"; } //$msg = "Merged successfully
"; //$msg .= "
".mb_eregi_replace(';',';
',$update_qry); if($db->db_query($update_qry)) { $msg = "Merged successfully
"; $msg_qry = mb_eregi_replace(';',';
',$update_qry); $msg_qry = str_replace('/*', '', $msg_qry); $msg_qry = str_replace('*/', '', $msg_qry); $msg .= "
".$msg_qry; $db->db_query("COMMIT;"); //Log schreiben $log = new log(); $log->new = true; $log->sql = $update_qry; $log->sqlundo = 'No undo statement implemented yet'; $log->executetime = date('Y-m-d H:i:s'); $log->mitarbeiter_uid = $uid; if (isset($_REQUEST['transfer'])) $log->beschreibung = "lv_merge.php: Merge of course $courseLeft to $courseRight"; elseif (isset($_REQUEST['mergeDelete'])) $log->beschreibung = "lv_merge.php: Deletion of course $courseLeft. Merged with $courseRight"; if(!$log->save()) { $msg .= "Error while writing log-file
"; } } else { $msg = $db->errormsg; $msg .= "An error occured while updating data. No changes were made
"; $db->db_query("ROLLBACK;"); $msg_qry = mb_eregi_replace(';',';
',$update_qry); $msg_qry = str_replace('/*', '', $msg_qry); $msg_qry = str_replace('*/', '', $msg_qry); $msg.= "
".$msg_qry."ROLLBACK"; } //$courseLeft=0; //$courseRight=0; } } /*if((isset($courseLeft) && !isset($courseRight))||(!isset($courseLeft) && isset($courseRight)) || ($courseLeft<0 || $courseRight<0)) { $msg="Please select a radio-button from each table"; }*/ ?> LV-Merge/Transfer

Merge/Transfer courses

'.$msg.'
'; echo '
'; echo '
'; ////////// // FILTER LEFT SIDE ////////// // Degree Program DropDown $studiengang = new studiengang(); $studiengang->getAll('typ, kurzbz'); //echo 'Degree Program '; echo ''; $typ = ''; $maxsemester = array(); foreach ($studiengang->result as $stg) { if ($typ != $stg->typ || $typ=='') { if ($typ!='') echo ''; echo ''; } echo ''; $maxsemester[$stg->studiengang_kz] = $stg->max_semester; $typ = $stg->typ; } echo '
or '; // Input text or ID //echo ''; echo ''; echo '
'; // Semester DropDown echo 'Semester
'; // Orgform DropDown echo ' Orgform
'; // Studienplan DropDown echo ' Studienplan
'; // Type DropDown echo ' Type
'; echo ''; echo '

'; echo ''; echo '
'; echo '
'; ////////// // FILTER RIGHT SIDE ////////// // Degree Program DropDown $studiengang = new studiengang(); $studiengang->getAll('typ, kurzbz'); //echo 'Degree Program '; echo ''; $typ = ''; $maxsemester = array(); foreach ($studiengang->result as $stg) { if ($typ != $stg->typ || $typ=='') { if ($typ!='') echo ''; echo ''; } echo ''; $maxsemester[$stg->studiengang_kz] = $stg->max_semester; $typ = $stg->typ; } echo '
or '; // Input text or ID //echo ''; echo ''; echo '
'; // Semester DropDown echo 'Semester
'; // Orgform DropDown echo ' Orgform
'; // Studienplan DropDown echo ' Studienplan
'; // Type DropDown echo ' Type
'; echo ''; echo '

'; echo ''; echo '
'; echo '
'; echo '
'; $stg_arr = new studiengang(); $stg_arr->getAll(null,false); foreach ($stg_arr->result as $row) $studiengang_arr[$row->studiengang_kz] = $row->kurzbzlang; ////////// // COURSES LEFT SIDE ////////// echo '
'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; if($rechte->isBerechtigt('lehre/lehrveranstaltung', NULL, 'sui')) { echo ' '; echo ' | '; } if($rechte->isBerechtigt('lehre/lehrveranstaltung', NULL, 'suid')) echo ' | '; echo ' '; echo '
'; // Left table echo 'Select course to be deleted or copied from'; echo ''; echo ""; echo ""; echo ""; if ($select_stg_kz_left=='') echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //if ((substr($input_text_left,0,1)=='#' || ($input_text_left!='' && strlen($input_text_left)>=3)) || $select_studienplan_left!='' || $select_stg_kz_left!='') if ((is_numeric($input_text_left) || ($input_text_left!='' && strlen($input_text_left)>=3)) || $select_studienplan_left!='' || $select_stg_kz_left!='') { $qry_left = "SELECT DISTINCT * FROM lehre.tbl_lehrveranstaltung "; /*if ($input_text_left!='') { if (substr($input_text_left,0,1)=='#') $qry_left .= " WHERE lehrveranstaltung_id=".$db->db_add_param(substr($input_text_left,1), FHC_INTEGER); else $qry_left .= " WHERE lower(bezeichnung) LIKE LOWER('%".$db->db_escape($input_text_left)."%')"; } else*/ { if ($select_studienplan_left!='') $qry_left .= " JOIN lehre.tbl_studienplan_lehrveranstaltung USING (lehrveranstaltung_id)"; $qry_left .= " WHERE 1=1"; if ($select_stg_kz_left!='') $qry_left .= " AND studiengang_kz=".$db->db_add_param($select_stg_kz_left); if (is_numeric($input_text_left)) $qry_left .= " AND lehrveranstaltung_id=".$db->db_add_param($input_text_left, FHC_INTEGER); elseif ($input_text_left!='' && strlen($input_text_left)>=3) $qry_left .= " AND lower(bezeichnung) LIKE LOWER('%".$db->db_escape($input_text_left)."%')"; if ($select_studienplan_left!='') $qry_left .= " AND studienplan_id=".$db->db_add_param($select_studienplan_left, FHC_INTEGER); if ($select_semester_left!='-1') $qry_left .= " AND tbl_lehrveranstaltung.semester=".$db->db_add_param($select_semester_left, FHC_INTEGER); if ($select_orgform_left!='') $qry_left .= " AND orgform_kurzbz=".$db->db_add_param($select_orgform_left); if ($select_lehrtyp_left!='') $qry_left .= " AND lehrtyp_kurzbz=".$db->db_add_param($select_lehrtyp_left); } $qry_left .= " ORDER BY bezeichnung;"; //echo $qry_left.'
'; if($db->db_query($qry_left)) { while($row = $db->db_fetch_object()) { echo ''; echo ''; echo ''; echo ''; if ($select_stg_kz_left=='') echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ""; } } } echo "
IDNameTypeDPSemesterLanguageECTSLVSALVSSWSLVPLS 
'.$row->lehrveranstaltung_id.''.$row->bezeichnung.''.strtoupper($row->lehrtyp_kurzbz).''.$studiengang_arr[$row->studiengang_kz].''.$row->semester.''.$row->sprache.''.$row->ects.''.$row->lvs.''.$row->alvs.''.$row->sws.''.$row->lvps.'lehrveranstaltung_id)?'checked':'').' onclick="enableRadio(\'courseLeft\'); disableRadio(\'courseRight_'.$row->lehrveranstaltung_id.'\')">
"; ////////// // COURSES RIGHT SIDE ////////// echo '
'; // Right table echo 'Select course to remain or transfer to'; echo ''; echo ""; echo ""; echo ""; echo ""; if ($select_stg_kz_right=='') echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //if ((substr($input_text_right,0,1)=='#' || ($input_text_right!='' && strlen($input_text_right)>=3)) || $select_studienplan_right!='' || $select_stg_kz_right!='') if ((is_numeric($input_text_right) || ($input_text_right!='' && strlen($input_text_right)>=3)) || $select_studienplan_right!='' || $select_stg_kz_right!='') { $qry_right = "SELECT DISTINCT * FROM lehre.tbl_lehrveranstaltung "; /*if ($input_text_right!='') { if (substr($input_text_right,0,1)=='#') $qry_right .= " WHERE lehrveranstaltung_id=".$db->db_add_param(substr($input_text_right,1), FHC_INTEGER); else $qry_right .= " WHERE lower(bezeichnung) LIKE LOWER ('%".$db->db_escape($input_text_right)."%')"; } else*/ { if ($select_studienplan_right!='') $qry_right .= " JOIN lehre.tbl_studienplan_lehrveranstaltung USING (lehrveranstaltung_id)"; $qry_right .= " WHERE 1=1"; if ($select_stg_kz_right!='') $qry_right .= " AND studiengang_kz=".$db->db_add_param($select_stg_kz_right); if (is_numeric($input_text_right)) $qry_right .= " AND lehrveranstaltung_id=".$db->db_add_param($input_text_right, FHC_INTEGER); elseif ($input_text_right!='' && strlen($input_text_right)>=3) $qry_right .= " AND lower(bezeichnung) LIKE LOWER('%".$db->db_escape($input_text_right)."%')"; if ($select_studienplan_right!='') $qry_right .= " AND studienplan_id=".$db->db_add_param($select_studienplan_right, FHC_INTEGER); if ($select_semester_right!='-1') $qry_right .= " AND tbl_lehrveranstaltung.semester=".$db->db_add_param($select_semester_right, FHC_INTEGER); if ($select_orgform_right!='') $qry_right .= " AND orgform_kurzbz=".$db->db_add_param($select_orgform_right); if ($select_lehrtyp_right!='') $qry_right .= " AND lehrtyp_kurzbz=".$db->db_add_param($select_lehrtyp_right); } $qry_right .= " ORDER BY bezeichnung;"; //echo $qry_right.'
'; if($db->db_query($qry_right)) { while($row = $db->db_fetch_object()) { echo ''; echo ''; echo ''; echo ''; echo ''; if ($select_stg_kz_right=='') echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ""; } } } echo "
 IDNameTypeDPSemesterLanguageECTSLVSALVSSWSLVPLS
lehrveranstaltung_id)?'checked':'').' onclick="enableRadio(\'courseRight\'); disableRadio(\'courseLeft_'.$row->lehrveranstaltung_id.'\')">'.$row->lehrveranstaltung_id.''.$row->bezeichnung.''.strtoupper($row->lehrtyp_kurzbz).''.$studiengang_arr[$row->studiengang_kz].''.$row->semester.''.$row->sprache.''.$row->ects.''.$row->lvs.''.$row->alvs.''.$row->sws.''.$row->lvps.'
"; echo '
'; echo '
'; exit; ?>