Add js helper function "isString" to StringHelpers

application/config/search.php

@@ -26,10 +26,6 @@ $config['person'] = [
 			'comparison' => 'similar',
 			'field' => 'nachname'
 		],
-		'wahlname' => [
-			'comparison' => 'similar',
-			'field' => 'wahlname'
-		],
 		'name' => [
 			'comparison' => 'similar',
 			'field' => "(vorname || ' ' || nachname)"
@@ -72,7 +68,7 @@ $config['person'] = [
 	'resultfields' => [
 		"ARRAY( SELECT uid FROM public.tbl_benutzer WHERE person_id = p.person_id ) AS uids",
 		"p.person_id",
-		"CASE WHEN p.wahlname IS NOT NULL THEN (p.wahlname || ' ' || p.nachname) ELSE (p.vorname || ' ' || p.nachname) END AS name",
+		"(p.vorname || ' ' || p.nachname) AS name",
 		"ARRAY( SELECT kontakt FROM public.tbl_kontakt WHERE kontakttyp = 'email' AND person_id=p.person_id ) AS email",
 		"CASE
 			WHEN p.foto IS NOT NULL THEN 'data:image/jpeg' || CONVERT_FROM(DECODE('3b','hex'), 'UTF8') || 'base64,' || p.foto
@@ -121,20 +117,6 @@ $config['student'] = [
 				]
 			]
 		],
-		'wahlname' => [
-			'comparison' => 'similar',
-			'field' => 'wahlname',
-			'join' => [
-				[
-					'table' => "public.tbl_prestudent",
-					'using' => "prestudent_id"
-				],
-				[
-					'table' => "public.tbl_person",
-					'using' => "person_id"
-				]
-			]
-		],
 		'name' => [
 			'comparison' => 'similar',
 			'field' => "(vorname || ' ' || nachname)",
@@ -214,7 +196,7 @@ $config['student'] = [
 		"s.student_uid AS uid",
 		"s.matrikelnr",
 		"p.person_id",
-		"CASE WHEN p.wahlname IS NOT NULL THEN (p.wahlname || ' ' || p.nachname) ELSE (p.vorname || ' ' || p.nachname) END AS name",
+		"(p.vorname || ' ' || p.nachname) AS name",
 		"(s.student_uid || '@" . DOMAIN . "') || ARRAY( SELECT kontakt FROM public.tbl_kontakt WHERE kontakttyp = 'email' AND person_id=p.person_id ) AS email",
 		"CASE
 			WHEN p.foto IS NOT NULL THEN 'data:image/jpeg' || CONVERT_FROM(DECODE('3b','hex'), 'UTF8') || 'base64,' || p.foto
@@ -275,14 +257,6 @@ $config['prestudent'] = [
 				'using' => "person_id"
 			]
 		],
-		'wahlname' => [
-			'comparison' => 'similar',
-			'field' => 'wahlname',
-			'join' => [
-				'table' => "public.tbl_person",
-				'using' => "person_id"
-			]
-		],
 		'name' => [
 			'comparison' => 'similar',
 			'field' => "(vorname || ' ' || nachname)",
@@ -340,7 +314,7 @@ $config['prestudent'] = [
 		"s.matrikelnr",
 		"p.person_id",
 		"b.uid",
-		"CASE WHEN p.wahlname IS NOT NULL THEN (p.wahlname || ' ' || p.nachname) ELSE (p.vorname || ' ' || p.nachname) END AS name",
+		"(p.vorname || ' ' || p.nachname) AS name",
 		"(b.uid || '@" . DOMAIN . "') || ARRAY( SELECT kontakt FROM public.tbl_kontakt WHERE kontakttyp = 'email' AND person_id=p.person_id ) AS email",
 		"CASE
 			WHEN p.foto IS NOT NULL THEN 'data:image/jpeg' || CONVERT_FROM(DECODE('3b','hex'), 'UTF8') || 'base64,' || p.foto
@@ -416,20 +390,6 @@ $config['employee'] = [
 				]
 			]
 		],
-		'wahlname' => [
-			'comparison' => 'similar',
-			'field' => "wahlname",
-			'join' => [
-				[
-					'table' => "public.tbl_benutzer",
-					'on' => "uid = mitarbeiter_uid"
-				],
-				[
-					'table' => "public.tbl_person",
-					'using' => "person_id"
-				]
-			]
-		],
 		'name' => [
 			'comparison' => 'similar',
 			'field' => "(vorname || ' ' || nachname)",
@@ -512,7 +472,7 @@ $config['employee'] = [
 	'resultfields' => [
 		"b.uid",
 		"p.person_id",
-		"CASE WHEN p.wahlname IS NOT NULL THEN (p.wahlname || ' ' || p.nachname) ELSE (p.vorname || ' ' || p.nachname) END AS name",
+		"(p.vorname || ' ' || p.nachname) AS name",
 		"ARRAY(
 			SELECT
 				'[' || ot.bezeichnung || '] ' || o.bezeichnung AS bezeichnung

application/config/searchcis.php

@@ -25,7 +25,7 @@ $config['student']['resultfields'] = [
 	"s.matrikelnr AS personenkennzeichen",
 	"p.person_id",
 	"p.matr_nr AS matrikelnummer",
-	"CASE WHEN p.wahlname IS NOT NULL THEN (p.wahlname || ' ' || p.nachname) ELSE (p.vorname || ' ' || p.nachname) END AS name",
+	"(p.vorname || ' ' || p.nachname) AS name",
 	"ARRAY[s.student_uid || '@' || '" . DOMAIN . "'] AS email",
 	"CASE
 		WHEN (p.foto_sperre = false AND p.foto IS NOT NULL) THEN 'data:image/jpeg' || CONVERT_FROM(DECODE('3b','hex'), 'UTF8') || 'base64,' || p.foto

application/controllers/api/frontend/v1/Cis4FhcApi.php

@@ -50,7 +50,6 @@ class Cis4FhcApi extends FHCAPI_Controller
 		$viewData = array(
 			'uid' => getAuthUID(),
 			'name' => $personData->vorname,
-			'wahlname' => $personData->wahlname,
 			'person_id' => $personData->person_id,
 			'timezone' => $this->config->item('timezone'),
 		);

application/controllers/api/frontend/v1/OtherLvPlan.php

@@ -62,7 +62,6 @@ class OtherLvPlan extends FHCAPI_Controller
 				"foto" => $profileData->data->foto,
 				"vorname" => $profileData->data->vorname,
 				"nachname" => $profileData->data->nachname,
-				"wahlname" => $profileData->data->wahlname,
 				"titel" => $profileData->data->titel,
 				"postnomen" => $profileData->data->postnomen,
 			],

application/libraries/ProfilLib.php

@@ -329,7 +329,7 @@ class ProfilLib{
 	private function getPersonInfo($uid, $geburtsInfo = null)
 	{
 		$this->ci->load->model("person/Benutzer_model","BenutzerModel");
-		$selectClause = ["foto", "foto_sperre", "anrede", "titelpost as postnomen", "titelpre as titel", "vorname", "nachname", "wahlname"];
+		$selectClause = ["foto", "foto_sperre", "anrede", "titelpost as postnomen", "titelpre as titel", "vorname", "nachname"];
 		/** @param integer $geburtsInfo */
 		if ($geburtsInfo) {
 			array_push($selectClause, "gebort");

application/models/person/Person_model.php

@@ -245,7 +245,7 @@ class Person_model extends DB_Model
 	 */
 	public function getByUid($uid)
 	{
-		$this->addSelect('vorname, nachname, wahlname, gebdatum, person_id, bpk, matr_nr, foto');
+		$this->addSelect('vorname, nachname, gebdatum, person_id, bpk, matr_nr, foto');
 		$this->addJoin('tbl_benutzer', 'person_id');
 
 		return $this->loadWhere(array('uid' => $uid));

cis/private/pers_in_grp.php

@@ -179,8 +179,7 @@ echo '	<title>' . $p->t('mailverteiler/personenImVerteiler') . '</title>
 <body id="inhalt">';
 
 $qry = "SELECT
-				uid, vorname, nachname, wahlname, geschlecht, fixangestellt,
-				CASE WHEN wahlname IS NOT NULL THEN wahlname ELSE vorname END AS orderVorname
+				uid, vorname, nachname, geschlecht, fixangestellt
 			FROM
 				campus.vw_benutzer
 			JOIN
@@ -203,7 +202,7 @@ $qry = "SELECT
 			}
 
 			$qry .= " ORDER BY
-				nachname, orderVorname";
+				nachname, vorname";
 
 echo '<p>'.$p->t('mailverteiler/anleitungstextMailPersInGroup').'<p>';
 echo '<a class="buttongreen" href="#" onclick="SendMail()" id="mailSendButton">' . $p->t('mailverteiler/mailAnAlleSenden') . '</a>';
@@ -237,7 +236,7 @@ if ($result = $db->db_query($qry))
 		echo '<tr>';
 		echo '	<td style="text-align: center"><input type="checkbox" class="chkbox" id="checkbox_'.$row->uid.'" name="checkbox['.$row->uid.']"></td>';
 		echo '	<td>'.$row->nachname.'</td>';
-		echo '	<td>'. ($row->wahlname ? $row->wahlname : $row->vorname) .'</td>';
+		echo '	<td>'.$row->vorname.'</td>';
 		echo '	<td>'.strtoupper($row->geschlecht).'</td>';
 		echo '	<td>'.($row->fixangestellt != '' ? ($row->fixangestellt == 't' ? 'Ja' : 'Nein') :'-').'</td>';
 		echo '	<td class="clm_email"><a href="mailto:'.$row->uid.'@' . DOMAIN . '" class="Item">'.$row->uid .'@' . DOMAIN . '</a></td>';

cis/private/profile/index.php

@@ -256,9 +256,7 @@ echo '
 		'.$p->t('global/anrede').': '.$user->anrede.'<br>
 		'.$p->t('global/titel').': '.$user->titelpre.' <br>';
 
-if ($user->wahlname)
-	echo $p->t('global/vorname').': '.$user->wahlname.'  <br>';
-else if (!$ansicht)
+if (!$ansicht)
 	echo $p->t('global/vorname').': '.$user->vorname.'  '.$user->vornamen.'<br>';
 else
 	echo $p->t('global/vorname').': '.$user->vorname.'  <br>';

cis/private/stud_in_grp.php

@@ -162,8 +162,7 @@ if (!isset($_GET['kz']))
 if (isset($_GET['all']))
 {
 	$qry = "SELECT
-				vorname, nachname, wahlname, uid, geschlecht,
-				CASE WHEN wahlname IS NOT NULL THEN wahlname ELSE vorname END AS orderVorname
+				vorname, nachname, uid, geschlecht
 			FROM
 				campus.vw_student
 			WHERE
@@ -171,13 +170,12 @@ if (isset($_GET['all']))
 				AND studiengang_kz=".$db->db_add_param($_GET['kz'])."
 				AND semester<10
 				AND semester>0
-			ORDER BY nachname, orderVorname";
+			ORDER BY nachname, vorname";
 }
 else
 {
 	$qry = "SELECT
-				vorname, nachname, wahlname, uid, geschlecht,
-				CASE WHEN wahlname IS NOT NULL THEN wahlname ELSE vorname END AS orderVorname
+				vorname, nachname, uid, geschlecht
 			FROM
 				campus.vw_student
 			WHERE
@@ -193,7 +191,7 @@ else
 	if (isset($_GET['grp']))
 		$qry.=" AND gruppe=".$db->db_add_param($_GET['grp']);
 
-	$qry.= ' ORDER BY nachname, orderVorname';
+	$qry.= ' ORDER BY nachname, vorname';
 }
 echo '<p>'.$p->t('mailverteiler/anleitungstextMailPersInGroup').'<p>';
 echo '<a class="buttongreen" href="#" onclick="SendMail()" id="mailSendButton">' . $p->t('mailverteiler/mailAnAlleSenden') . '</a>';
@@ -225,7 +223,7 @@ if ($result = $db->db_query($qry))
 		echo "<tr>";
 		echo '	<td style="text-align: center"><input type="checkbox" class="chkbox" id="checkbox_'.$row->uid.'" name="checkbox['.$row->uid.']"></td>';
 		echo "  <td>$row->nachname</td>";
-		echo "  <td>" . ($row->wahlname ? $row->wahlname : $row->vorname) . "</td>";
+		echo "  <td>$row->vorname</td>";
 		echo '	<td>'.strtoupper($row->geschlecht).'</td>';
 		echo '	<td class="clm_email"><a href="mailto:'.$row->uid.'@' . DOMAIN . '" class="Item">'.$row->uid .'@' . DOMAIN . '</a></td>';
 		echo "</tr>";

cis/private/tools/suche.php

@@ -180,7 +180,7 @@ function searchPerson($searchItems)
 			echo '<td>',$row->anrede,'</td>';
 
 			if ($row->wahlname)
-				echo '<td>',$row->wahlname,'</td>';
+				echo '<td>',$row->wahlname, ' ' ,$row->vorname, '</td>';
 			else
 					echo '<td>',$row->vorname, '</td>';
 

public/js/components/Cis/LvPlan/OtherLvPlan.js

@@ -213,7 +213,7 @@ export default {
 			this.isOtherPersonStudent = !!viewData?.user_data?.is_student;
 			let fullNameWithTitleFragments = [
 				viewData?.user_data?.titel,
-				viewData?.user_data?.wahlname ?? viewData?.user_data?.vorname,
+				viewData?.user_data?.vorname,
 				viewData?.user_data?.nachname,
 				viewData?.user_data?.postnomen,
 			];

public/js/components/Cis/Profil/MitarbeiterProfil.js

@@ -274,7 +274,7 @@ export default {
 			}
 
 			return {
-				Vorname: this.data.wahlname ?? this.data.vorname,
+				Vorname: this.data.vorname,
 				Nachname: this.data.nachname,
 				Username: this.data.username,
 				Anrede: this.data.anrede,

public/js/components/Cis/Profil/MitarbeiterViewProfil.js

@@ -160,7 +160,7 @@ export default {
 			}
 
 			return {
-				Vorname: this.data.wahlname ?? this.data.vorname,
+				Vorname: this.data.vorname,
 				Nachname: this.data.nachname,
 				Username: this.data.username,
 				Anrede: this.data.anrede,

public/js/components/Cis/Profil/StudentProfil.js

@@ -204,7 +204,7 @@ export default {
 			}
 
 			return {
-				Vorname: this.data.wahlname ?? this.data.vorname,
+				Vorname: this.data.vorname,
 				Nachname: this.data.nachname,
 				Username: this.data.username,
 				Anrede: this.data.anrede,

public/js/components/Cis/Profil/StudentViewProfil.js

@@ -33,7 +33,7 @@ export default {
 			}
 
 			return {
-				Vorname: this.data.wahlname ?? this.data.vorname,
+				Vorname: this.data.vorname,
 				Nachname: this.data.nachname,
 				Username: this.data.username,
 				Anrede: this.data.anrede,

public/js/components/Dashboard/Admin/Presets.js

@@ -22,7 +22,7 @@ export default {
 	},
 	computed: {
 		pickerWidgets() {
-			return this.widgets.filter(widget => widget.allowed);
+			return this.widgets.filter(widget => widget.allowed).map(widget => ({ ...widget, permitted: true }));
 		},
 		sizeLimits() {
 			return Object.fromEntries(this.widgets.map(({ setup, widget_id: type }) => {

public/js/components/Dashboard/Dashboard.js

@@ -184,7 +184,7 @@ export default {
 			let viewDataResult = await this.$api.call(ApiDashboard.getViewData());
 			const viewData = viewDataResult.data;
 			this.timezone = viewData?.timezone;
-			this.userFirstName = viewData?.wahlname ?? viewData?.name;
+			this.userFirstName = viewData?.name;
 		}
 	},
 	async created() {

public/js/components/Dashboard/Widget/Picker.js

@@ -6,10 +6,16 @@ export default {
 		BsModal,
 		WidgetIcon,
 	},
-	props: [
-		"widgets",
-		"hiddenWidgets"
-	],
+	props: {
+		widgets: {
+			type: [ Array, null ],
+			required: true
+		},
+		hiddenWidgets: {
+			type: Array,
+			default: []
+		}
+	},
 	data: () => ({
 		callbacks: {}
 	}),

public/js/helpers/StringHelpers.js

@@ -47,3 +47,7 @@ function splitWordsInCamelCase(string) {
 	splitWords.push(string.slice(lastUpperCaseLetterIndex));
 	return splitWords;
 }
+
+export function isString(str) {
+	return typeof str === 'string' || str instanceof String;
+}

system/phrasesupdate.php

@@ -50474,7 +50474,7 @@ array(
 	'phrases' => array(
 		array(
 			'sprache' => 'German',
-			'text' => 'Wahlvorname',
+			'text' => 'Wahlname',
 			'description' => '',
 			'insertvon' => 'system'
 		),