| '.
' Faktura - daňový doklad '.
'
|
'.
'Dodavatel:
'.
'Ing. Jiří Hajda
'.
'Zděchov 208
'.
'75607 Zděchov
'.
'IČO: 75904535
'.
'DIČ: CZ8303255884
'.
'Účet: 218098370 / 0300
'.
'Nejsem plátce DPH
'.
' | '.
'Odběratel:
'.
$User['fullname'].'
'.
$User['street'].'
'.
$User['psc'].' '.$User['town'].'
';
if($User['ico'] != 0) $Output .= 'IČO: '.$User['ico'].'
';
$Output .=
' |
'.
'
|
'.
''.
'Platební podmínky:
'.
'Číslo dokladu: '.$Bill['id'].'
'.
'Variabilní symbol: '.$User['id'].'
'.
'Specifický symbol: '.$this->SpecificSymbol.'
'.
'Konstantní symbol:
'.
'Způsob úhrady: převodem'.
' | '.
'
'.
'Datum vystavení: '.HumanDate($Bill['time_create']).'
'.
'Datum splatnosti: '.HumanDate($Bill['time_due']).'
'.
'Fakturované období: '.HumanDate($Bill['time_from']).' - '.HumanDate($Bill['time_to']).'
'.
' |
'.
''.
'
'.
'
'.
''.
'| Dodávka | Množství | Cena/MJ | Celkem |
|---|
'.
'
| ';
$Total = 0;
foreach($Dodavka as $Polozka)
{
$Output .= '| '.$Polozka['description'].' | '.$Polozka['quantity'].' | '.$Polozka['price'].' Kč | '.($Polozka['quantity'] * $Polozka['price']).' Kč | ';
$Total += ($Polozka['quantity'] * $Polozka['price']);
}
$Output .= '| Celkem | '.$Total.' Kč |
|---|
';
$Output .= ' '.
' |
'.
'
|
'.
'
';
return($Output);
}
function CreateBill($UserId, $Items, $TimeFrom, $TimeTo)
{
global $Database;
$Database->insert('finance_bills', array('time_create' => TimeToMysqlDateTime($TimeFrom), 'user_id' => $UserId, 'time_from' => TimeToMysqlDateTime($TimeFrom), 'time_to' => TimeToMysqlDateTime($TimeTo), 'time_due' => TimeToMysqlDateTime($TimeFrom + 15*24*3600)));
$BillId = $Database->insert_id;
foreach($Items as $Item)
{
$Database->insert('finance_bills_items', array('bill_id' => $BillId, 'description' => $Item['description'], 'price' => $Item['price'], 'quantity' => $Item['quantity']));
}
//Header('Content-Type: application/pdf');
$PdfData = $this->HtmlToPdf($this->GenerateBill($BillId));
//echo($PdfData);
$Database->query('UPDATE finance_bills SET pdf = 0x'.bin2hex($PdfData).' WHERE id='.$BillId);
return($BillId);
}
function ShowStoredBill($BillId)
{
global $Database;
$DbResult = $Database->select('finance_bills', 'pdf', 'id='.$BillId);
if($DbResult->num_rows == 1)
{
$DbRow = $DbResult->fetch_array();
Header('Content-Type: application/pdf');
Header('Content-Disposition: attachment; filename="faktura-'.$BillId.'.pdf"');
echo($DbRow['pdf']);
} else echo('Faktura nenalezena');
}
function ShowGeneratedBill($BillId)
{
global $Database;
Header('Content-Type: application/pdf');
Header('Content-Disposition: attachment; filename="faktura-'.$BillId.'.pdf"');
echo($this->HtmlToPdf($this->GenerateBill($BillId)));
}
function HtmlToPdf($HtmlCode)
{
$Output = shell_exec('echo "'.addslashes(from_utf8($HtmlCode)).'"|htmldoc --no-numbered --webpage --charset 8859-2 -t pdf -');
return($Output);
}
function CustomGenerate()
{
global $Database;
$DbResult = $Database->select('finance_operations', '*', '(date="2008-02-01" AND comment="Poplatek za měsíc Únor") OR '.
'(date="2008-01-01" AND comment="Poplatek za měsíc Leden") OR (date="2007-12-01" AND comment="Poplatek za měsíc Prosinec") AND (bill_id = 0)');
while($Row = $DbResult->fetch_array())
{
echo($Row['id']."