Mercurial Mercurial > IQM / comparison
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fhiiqm/form/vertrag_form.inc.php
changeset 39 4ce411ed28b6
parent 31 0a1eb975fbd9
equal deleted inserted replaced
38:45c139f74ea4 39:4ce411ed28b6 
   284             <select name="vertrag[cpers][]" size="7" multiple="multiple">
 
   284             <select name="vertrag[cpers][]" size="7" multiple="multiple">
 
   285                 <?php
 
   285                 <?php
 
   286                     $select = null;
 
   286                     $select = null;
 
   287                     if (is_array($vtr['cpers'])) $select = in_array( "-1", $vtr['cpers'] ) ? ' selected' : null;
 
   287                     if (is_array($vtr['cpers'])) $select = in_array( "-1", $vtr['cpers'] ) ? ' selected' : null;
 
   288                     echo "<option $select value=\"-1\"></option>\n";
 
   288                     echo "<option $select value=\"-1\"></option>\n";
 
   289                     $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";
 
   289                     $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";
 
   290                     if ($result = $dbc->queryObjectArray($sql))
 
   290                     if ($result = $dbc->queryObjectArray($sql))
 
   291                     {
 
   291                     {
 
   292                         foreach ($result as $row)
 
   292                         foreach ($result as $row)
 
   293                         {
 
   293                         {
 
   294                             if (is_array($vtr['cpers'])) $select = in_array( $row->persknr, $vtr['cpers'] ) ? ' selected' : null;
 
   294                             if (is_array($vtr['cpers'])) $select = in_array( $row->persknr, $vtr['cpers'] ) ? ' selected' : null;
IQM