IQM: comparison fhiiqm/form/vertragmf

equal deleted inserted replaced

-:45c139f74ea4
+:4ce411ed28b6
 <select name="vertrag[cpers][]" size="7" multiple="multiple">
 <?php
 $select = null;
 if (is_array($vtr['cpers'])) $select = in_array( "-1", $vtr['cpers'] ) ? ' selected' : null;
 echo "<option $select value=\"-1\"></option>\n";
-$sql = "SELECT persknr, CONCAT (nachname, ', ',vorname,' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as pname FROM fhiiqm.Mitarbeiter WHERE aktiv < 2 ORDER BY 2";
+$sql = "SELECT persknr, CONCAT (nachname, ', ',IFNULL(vorname,''),' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as pname FROM fhiiqm.Mitarbeiter WHERE aktiv < 2 ORDER BY 2";
 if ($result = $dbc->queryObjectArray($sql))
 {
 foreach ($result as $row)
 {
 if (is_array($vtr['cpers'])) $select = in_array( $row->persknr, $vtr['cpers'] ) ? ' selected' : null;