99 lines
4.8 KiB
PHP
99 lines
4.8 KiB
PHP
<fieldset>
|
|
<legend>alle offenen Posten</legend>
|
|
<form action="index.php?section=oposten" method="post">
|
|
<br/>
|
|
<input type="submit" class="button_over" name="formaction" value="overview" title="Übersicht über alle offenen Posten"/>
|
|
<input type="submit" class="button_pdf" name="formaction" value="view" title="Übersicht über alle offenen Posten als PDF speichern"/>
|
|
</form>
|
|
</fieldset>
|
|
|
|
<?php
|
|
$sql = "SELECT " . PREFIX . "_Rechnungen.Jahr, " . PREFIX . "_Rechnungen.ID, " . PREFIX . "_Kontakte.Firma, " . PREFIX . "_Kontakte.Nachname, " . PREFIX . "_Kontakte.Vorname, Preis FROM " . PREFIX . "_Rechnungen LEFT JOIN " . PREFIX . "_Kontakte ON " . PREFIX . "_Rechnungen.Kontakt_ID = " . PREFIX . "_Kontakte.ID WHERE (DATE_ADD(" . PREFIX . "_Rechnungen.Datum, INTERVAL 14 DAY) < CURDATE() AND Bezahlt = \"0\") ORDER BY " . PREFIX . "_Rechnungen.Jahr ASC, " . PREFIX . "_Rechnungen.ID ASC;";
|
|
$result = $db->query($sql);
|
|
?>
|
|
<fieldset>
|
|
<legend>Fälligkeiten</legend>
|
|
<form action="index.php?section=oposten" method="post">
|
|
<?php
|
|
echo "<select name=\"ID\">\n";
|
|
while ($nt = $result->fetch_assoc())
|
|
{
|
|
while (strlen($nt['ID']) < $_SESSION['Firma']['Stellen'])
|
|
{
|
|
$nt['ID'] = "0" . $nt['ID'];
|
|
}
|
|
echo " <option value=\"" . $nt['Jahr'] . "_" . $nt['ID'] . "\">" . $nt['Jahr'] . "_" . $nt['ID'] . ", ";
|
|
echo $nt['Nachname'] . ", " . $nt['Firma'];
|
|
echo "</option>\n";
|
|
}
|
|
echo "</select>\n";
|
|
?>
|
|
<br/>
|
|
<br/>
|
|
<input type="hidden" name="ueber" value="1"/>
|
|
<input type="submit" class="button_over" name="formaction" value="overview" title="Übersicht über alle Fälligkeiten"/>
|
|
<input type="submit" class="button_pdf" name="formaction" value="view" title="Übersicht über alle Fälligkeiten als PDF speichern"/>
|
|
<input type="submit" class="button_mahn" name="formaction" value="mahn" title="1. Mahnung generieren"/>
|
|
</form>
|
|
</fieldset>
|
|
|
|
<?php
|
|
$sql = "SELECT " . PREFIX . "_Mahnungen.Jahr, " . PREFIX . "_Mahnungen.ID, " . PREFIX . "_Kontakte.Firma, " . PREFIX . "_Kontakte.Nachname, " . PREFIX . "_Kontakte.Vorname FROM " . PREFIX . "_Mahnungen LEFT JOIN " . PREFIX . "_Kontakte ON " . PREFIX . "_Mahnungen.Kontakt_ID = " . PREFIX . "_Kontakte.ID WHERE Nr = \"1\" ORDER BY " . PREFIX . "_Mahnungen.Jahr ASC, " . PREFIX . "_Mahnungen.ID ASC;";
|
|
$result = $db->query($sql);
|
|
?>
|
|
<fieldset>
|
|
<legend>1. Mahnungen</legend>
|
|
<form action="index.php?section=oposten" method="post">
|
|
<?php
|
|
echo "<select name=\"ID\">\n";
|
|
while ($nt = $result->fetch_assoc())
|
|
{
|
|
while (strlen($nt['ID']) < $_SESSION['Firma']['Stellen'])
|
|
{
|
|
$nt['ID'] = "0" . $nt['ID'];
|
|
}
|
|
echo " <option value=\"" . $nt['Jahr'] . "_" . $nt['ID'] . "\">" . $nt['Jahr'] . "_" . $nt['ID'] . ", ";
|
|
echo $nt['Nachname'] . ", " . $nt['Firma'];
|
|
echo "</option>\n";
|
|
}
|
|
echo "</select>\n";
|
|
?>
|
|
<br/>
|
|
<br/>
|
|
<input type="hidden" name="mahnung" value="1"/>
|
|
<input type="submit" class="button_over" name="formaction" value="overview" title="Übersicht über alle ersten Mahnungen"/>
|
|
<input type="submit" class="button_edit" name="formaction" value="edit" title="1. Mahnung bearbeiten"/>
|
|
<input type="submit" class="button_view" name="formaction" value="view" title="1. Mahnung anzeigen"/>
|
|
<input type="submit" class="button_del" name="formaction" value="del" title="1. Mahnung löschen"/>
|
|
<input type="submit" class="button_mahn" name="formaction" value="mahn" title="2. Mahnung generieren"/>
|
|
</form>
|
|
</fieldset><?php
|
|
$sql = "SELECT " . PREFIX . "_Mahnungen.Jahr, " . PREFIX . "_Mahnungen.ID, " . PREFIX . "_Kontakte.Firma, " . PREFIX . "_Kontakte.Nachname, " . PREFIX . "_Kontakte.Vorname FROM " . PREFIX . "_Mahnungen LEFT JOIN " . PREFIX . "_Kontakte ON " . PREFIX . "_Mahnungen.Kontakt_ID = " . PREFIX . "_Kontakte.ID WHERE Nr = \"2\" ORDER BY " . PREFIX . "_Mahnungen.Jahr ASC, " . PREFIX . "_Mahnungen.ID ASC;";
|
|
$result = $db->query($sql);
|
|
?>
|
|
<fieldset>
|
|
<legend>2. Mahnungen</legend>
|
|
<form action="index.php?section=oposten" method="post">
|
|
<?php
|
|
echo "<select name=\"ID\">\n";
|
|
while ($nt = $result->fetch_assoc())
|
|
{
|
|
while (strlen($nt['ID']) < $_SESSION['Firma']['Stellen'])
|
|
{
|
|
$nt['ID'] = "0" . $nt['ID'];
|
|
}
|
|
echo " <option value=\"" . $nt['Jahr'] . "_" . $nt['ID'] . "\">" . $nt['Jahr'] . "_" . $nt['ID'] . ", ";
|
|
echo $nt['Nachname'] . ", " . $nt['Firma'];
|
|
echo "</option>\n";
|
|
}
|
|
echo "</select>\n";
|
|
?>
|
|
<br/>
|
|
<br/>
|
|
<input type="hidden" name="mahnung" value="2"/>
|
|
<input type="submit" class="button_over" name="formaction" value="overview" title="Übersicht über alle zweiten Mahnungen"/>
|
|
<input type="submit" class="button_edit" name="formaction" value="edit" title="2. Mahnung bearbeiten"/>
|
|
<input type="submit" class="button_view" name="formaction" value="view" title="2. Mahnung anzeigen"/>
|
|
<input type="submit" class="button_del" name="formaction" value="del" title="2. Mahnung löschen"/>
|
|
</form>
|
|
</fieldset>
|