Projekt

"; //echo "

";

/*
 while (($row = oci_fetch_array($stid, OCI_ASSOC + OCI_RETURN_NULLS)) != false) {
 
print_r($row);
}

echo "

"; */ while (($row = oci_fetch_array($stid, OCI_ASSOC + OCI_RETURN_NULLS)) != false) { $uuidX=$row['KINGNAME']; global $theuid; $query = db_select('users', '') ->condition('uuid', "$uuidX", '=') ->fields('users', array('uid', 'uuid','name', 'status', 'created', 'access')) ->range(0, 10); $aresult = $query->execute(); foreach ($aresult as $record) { $theuid=$record->uid; } $i=$i+1; if($row['HEADPERSON']==1){ $headpeople[] = "" . $row['BEFORENAME'] ." ".$row['FIRSTNAME']. " " . $row['LASTNAME'] . " " . $row['AFTERNAME'] . " "; } else{ $people[] = "" . $row['BEFORENAME'] ." ".$row['FIRSTNAME']. " " . $row['LASTNAME'] . " " . $row['AFTERNAME'] . ""; } if($i==1) {$newrow=$row;} } } //echo "

";
//var_dump($newrow);
$kodprac=$newrow['KODPRAC'];
//echo $kodprac[0];
switch ($kodprac[0])
{
    case 1:
	$prac='Fakulta filozofická';
    break;
    case 2:
	$prac='Fakulta restaurování';
    break;
    case 3:
	$prac='Fakulta chemicko-technologická';
    break;
    case 4:
	$prac='Fakulta ekonomicko-správní';
    break;
    case 5:
	$prac='Dopravní fakulta Jana Pernera';
    break;
    case 6:
	$prac='Fakulta elektrotechniky a informatiky';
    break;
    case 7:
	$prac='Fakulta zdravotnických studií';
    break;
    case 8:
	$prac='Kolej a Menza';
    break;
    case 9:
	$prac='Rektorátní a celouniverzitní útvary';
    break;
}
//echo "

"; echo "\n"; echo "

".$newrow['PROJECTNAME']."

"; echo "\n"; echo "Poskytovatel:".$newrow['COMPANYNAME']. "\n"; echo "Program:".$newrow['PROGRAMNAME'] . "\n"; echo "Trvání:". $newrow['STARTDATE'] . " - " . $newrow['ENDDATE'] . "\n"; echo "\n"; echo "Pracoviště: ". $prac.""; echo "\n"; echo "Řešitel:"; foreach ($headpeople as $arrayItem) { echo $arrayItem; echo "
"; } echo ""; if(count($people)>0) { echo "Interní spoluřešitelé:"; foreach ($people as $arrayItem) { echo $arrayItem; echo "
"; } echo ""; } echo "

".$newrow['DESCRIPTION']->read(200000)."

"; echo ""; unset($query); unset($row); unset($stid); unset($conn); unset($newrow);