<h1>Nová faktura</h1>
<form method="POST">
<table width="93%" style="border-collapse: collapse;" class="new_faktura">
<tr><td width="195" style="font-weight: bold;">Název faktury:</td><td><input type="text" name="nazev" class="pole" size="37"></td></tr>
<tr><td style="font-weight: bold;">Dodavatel:</td><td><select name="dodavatel" class="pole">
<option>Vyber dodavatele
<?
$get_dod = mysql_query("SELECT * FROM dodavatetel ORDER BY nazev ASC");
while($dod = mysql_fetch_assoc($get_dod)) {
echo '<option value="'.$dod['id'].'">'.$dod['nazev'];
}
?>
</select></td></tr>
<tr><td style="font-weight: bold;">Stávající odběratel:</td><td><select name="stavajici" class="pole" id="stavajici">
<option value="0">Vyber odběratele
<?
$get_odb = mysql_query("SELECT * FROM odberatele ORDER BY nazev ASC");
while($odb = mysql_fetch_assoc($get_odb)) {
echo '<option value="'.$odb['id'].'">'.$odb['nazev'];
}
?>
</select></td></tr>
<tr><td colspan="2"><img src="/img/blank.png" border="0" title="Nový odběratel" class="novy_odberatel" onclick="new_odb();"></td></tr>
</table>
<div id="novy_odberatel" style="display: none; background-color: #dedede; border-radius: 5px; -moz-border-radius: 5px; width: 95%; text-align: left; padding-left: 20px;">
<table width="93%" style="border-collapse: collapse;" class="new_faktura">
<tr><td style="font-weight: bold;">Název:</td><td><input type="text" name="odberatel_nazev" class="pole" size="37"></td></tr>
<tr><td width="195" style="font-weight: bold;">Ulice a č.p.:</td><td><input type="text" name="ulice" class="pole" size="22"><input type="text" name="cp" class="pole" size="7"></td></tr>
<tr><td style="font-weight: bold;">Město a PSČ:</td><td><input type="text" name="mesto" class="pole" size="22"><input type="text" name="psc" class="pole" size="7"></td></tr>
<tr><td style="font-weight: bold;">IČO:</td><td><input type="text" name="ico" class="pole" size="37"></td></tr>
<tr><td style="font-weight: bold;">DIČ:</td><td><input type="text" name="dic" class="pole" size="37"></td></tr>
<tr><td style="font-weight: bold;">E-mail:</td><td><input type="text" name="email" class="pole" size="37"></td></tr>
<tr><td style="font-weight: bold;">Telefon:</td><td><input type="text" name="telefon" class="pole" size="37"></td></tr>
</table>
</div>
<table width="93%" style="border-collapse: collapse;" class="new_faktura">
<tr><td width="195" style="font-weight: bold;">Datum vystavení:</td><td><select name="den" class="pole">
<?
for($d=1;$d<=31;$d++) {
echo '<option value="'.$d.'">'.$d;
}
?>
</select>
<select name="mesic" class="pole">
<?
for($m=1;$m<=12;$m++) {
if($m == 1) {$mesic = 'leden';}
elseif($m == 2) {$mesic = 'únor';}
elseif($m == 3) {$mesic = 'březen';}
elseif($m == 4) {$mesic = 'duben';}
elseif($m == 5) {$mesic = 'květen';}
elseif($m == 6) {$mesic = 'červen';}
elseif($m == 7) {$mesic = 'červenec';}
elseif($m == 8) {$mesic = 'srpen';}
elseif($m == 9) {$mesic = 'září';}
elseif($m == 10) {$mesic = 'říjen';}
elseif($m == 11) {$mesic = 'listopad';}
elseif($m == 12) {$mesic = 'prosinec';}
echo '<option value="'.$m.'">'.$mesic;
}
?>
</select>
<select name="rok" class="pole">
<?
$rok = date("Y");
for($r=$rok;$r>=1990;$r--) {
echo '<option value="'.$r.'">'.$r;
}
?>
</select></td></tr>
<tr><td style="font-weight: bold;">Datum splatnosti:</td><td><select name="den2" class="pole">
<?
for($d=1;$d<=31;$d++) {
echo '<option value="'.$d.'">'.$d;
}
?>
</select>
<select name="mesic2" class="pole">
<?
for($m=1;$m<=12;$m++) {
if($m == 1) {$mesic = 'leden';}
elseif($m == 2) {$mesic = 'únor';}
elseif($m == 3) {$mesic = 'březen';}
elseif($m == 4) {$mesic = 'duben';}
elseif($m == 5) {$mesic = 'květen';}
elseif($m == 6) {$mesic = 'červen';}
elseif($m == 7) {$mesic = 'červenec';}
elseif($m == 8) {$mesic = 'srpen';}
elseif($m == 9) {$mesic = 'září';}
elseif($m == 10) {$mesic = 'říjen';}
elseif($m == 11) {$mesic = 'listopad';}
elseif($m == 12) {$mesic = 'prosinec';}
echo '<option value="'.$m.'">'.$mesic;
}
?>
</select>
<select name="rok2" class="pole">
<?
$rok = date("Y");
$rokk = $rok+5;
for($r=$rokk;$r>=1990;$r--) {
echo '<option value="'.$r.'">'.$r;
}
?>
</select></td></tr>
<tr><td style="font-weight: bold;">Variabilní symbol:</td><td><input type="text" name="variabilni" class="pole" size="37"></td></tr>
<tr><td style="font-weight: bold;">Způsob uhrazení:</td><td>bankovním převodem <input type="radio" name="uhrazeni" value="1" checked> hotově <input type="radio" name="uhrazeni" value="0"></td></tr>
<tr style="border-bottom: 1px solid #ccc;"><td style="font-weight: bold; padding-bottom: 10px;">Zaplaceno:</td><td>ano <input type="radio" name="zaplaceno" value="1"> ne <input type="radio" name="zaplaceno" value="0" checked></td></tr>
</table>
<br>
<table width="93%" style="border-collapse: collapse;" class="new_faktura" id="radky">
<tr style="background-image: url(/img/tr_bg.png); height: 39px; background-repeat: repeat-x; font-weight: bold;">
<td style="padding-left: 15px; padding-right: 5px; border-right: 1px solid #717171;">Popis položky</td>
<td width="60" style="text-align: center; padding-left: 5px; padding-right: 5px; border-right: 1px solid #717171;">Počet</td>
<td width="140" style="text-align: right; padding-left: 5px; padding-right: 15px;">Cena za jednotku</td></tr>
<tr class="row_to_clone">
<td style="padding-left: 15px; padding-right: 5px;"><input type="text" name="popis_polozky[]" class="pole" size="85" value=""></td>
<td width="60" style="text-align: center; padding-left: 5px; padding-right: 5px;"><select name="pocet[]" class="pole">
<?
for($p=1;$p<=12;$p++) {
echo '<option value="'.$p.'">'.$p;
}
?>
</select></td>
<td width="140" style="text-align: right; padding-left: 5px; padding-right: 15px;"><input type="text" name="cena_jednotky[]" value="" class="pole" size="7" style="text-align: right;"> Kč</td></tr>
</table>
<p align="left" style="margin-left: 40px;">
<img src="/img/blank.png" border="0" title="Přidat polozku" class="dalsi" onclick="addRow(); return false;">
</p>
<br><br>
<input type="submit" name="ulozit" class="ulozit_fakturu" value="">
</form>

<?
if(isset($_POST['ulozit'])) {
if($_POST['nazev']!='' AND $_POST['variabilni']!='') {
if($_POST['odberatel_nazev']!='' AND $_POST['ulice']!='' AND $_POST['cp']!='' AND $_POST['mesto']!='' AND $_POST['psc']!='' AND $_POST['ico']!='' AND $_POST['dic']!='' AND $_POST['email']!='') {
mysql_query("INSERT INTO odberatele (`nazev`, `ulice`, `cp`, `mesto`, `psc`, `ico`, `dic`, `email`, `telefon`) VALUES ('".$_POST['odberatel_nazev']."', '".$_POST['ulice']."', '".$_POST['cp']."', '".$_POST['mesto']."', '".$_POST['psc']."', '".$_POST['ico']."', '".$_POST['dic']."', '".$_POST['email']."', '".$_POST['telefon']."');");
$odbira = mysql_insert_id();
} else {
$odbira = $_POST['stavajici'];
}
$vystaveni = $_POST['rok'].'-'.$_POST['mesic'].'-'.$_POST['den'];
$splatnost = $_POST['rok2'].'-'.$_POST['mesic2'].'-'.$_POST['den2'];
mysql_query("INSERT INTO faktury (`dodavatel`, `odberatel`, `vystaveni`, `splatnost`, `variabilni`, `uhrazeni`, `zaplaceno`) VALUES ('".$_POST['dodavatel']."', '".$odbira."', '".$vystaveni."', '".$splatnost."', '".$_POST['variabilni']."', '".$_POST['uhrazeni']."', '".$_POST['zaplaceno']."')");
$hash = mysql_insert_id();
$hashni = md5($hash);
mysql_query("UPDATE faktury SET hash = '".$hashni."' WHERE id = '".$hash."'");


$pocet_poleidc=count($_POST['popis_polozky']);
for ($pom=0;$pom<$pocet_poleidc;$pom++) {
mysql_query("INSERT INTO polozky (`popis`, `pocet`, `cena`, `faktura`) VALUES ('".$_POST['popis_polozky'][$pom]."', '".$_POST['pocet'][$pom]."', '".$_POST['cena_jednotky'][$pom]."', '".$hash."')");
}
header("Location: ".$_SERVER['REQUEST_URI']."");
}
}
?>