<?php global $user;
$uid = $user-?>uid;
$uzivatele = db_query("SELECT * FROM {users_roles} WHERE uid=$uid");
$povoleni = 0;
foreach ($uzivatele as $uzivatel){
if (($uzivatel->rid == 4)||($uzivatel->rid == 4)){
$povoleni = 1;
}
}
echo "
Seznam nevrácených výpůjček
";
$vypujcky= db_query("SELECT * FROM vypujcky WHERE termin_vyzvednuti IS NOT NULL AND termin_vraceni IS NULL ORDER BY termin_zacatku");
echo"
| Kdo | Co | Kolik | Odkdy | Dokdy | Vyzvednuto | Poznámka |
|---|
";
foreach ($vypujcky as $vypujcka){
echo "| ";
$users = user_load_multiple(array(), array('uid' => $vypujcka->idUzivatel));
$kdo= reset($users);
echo $kdo->name;
echo " | ";
$db_vec = db_query("SELECT * FROM sklad WHERE id=$vypujcka->idVec");
$vec = $db_vec->fetchObject();
echo $vec->druh.' ('.$vec->popis.')';
echo " | ";
echo $vypujcka->mnozstvi;
echo " | ";
echo date('d.m.y', $vypujcka->termin_zacatku);
echo " | ";
echo date('d.m.y', $vypujcka->termin_konce);
echo " | ";
echo date('d.m.y', $vypujcka->termin_vyzvednuti);
echo " | ";
echo $vypujcka->poznamka;
echo " | ";
if ($vypujcka->mnozstvi > 1){
echo '';
echo '';
echo '';
}
if ($povoleni){
echo " | ";
echo '';
echo '';
echo '';
}
echo " |
";
}
echo "
";
?>
Seznam možností práce se skladem
