Database->select('FinanceBills', '*', 'Id='.$BillId); $Bill = $DbResult->fetch_assoc(); $DbResult = $this->Database->select('Subject', '*', 'Id='.$Bill['Subject']); $Subject = $DbResult->fetch_assoc(); $Dodavka = array(); $DbResult = $this->Database->select('FinanceBillsItems', '*', 'Bill='.$BillId); while($Item = $DbResult->fetch_assoc()) { $Dodavka[$Item['Id']] = $Item; } $PaymentType = array('převodem', 'hotově'); switch($Bill['Type']) { case 'invoice': $Output = ''. ''. ''. ''. ''. ''. '

'. ' Faktura - daňový doklad '. '
Dodavatel: '. 'Ing. Jiří Hajda '. 'Zděchov 208 '. '75607 Zděchov '. 'IČ: 75904535 '. 'DIČ: CZ8303255884 '. 'Účet: 218098370 / 0300 '. 'Neplátce DPH '. '	'. 'Odběratel: '. $Subject['Name'].' '. $Subject['AddressStreet'].' '. $Subject['AddressPSC'].' '.$Subject['AddressTown'].' '; if($Subject['IC'] != 0) $Output .= 'IČ: '.$Subject['IC'].' '; if($Subject['DIC'] != '') $Output .= 'DIČ: '.$Subject['DIC'].' '; $Output .= '
'. 'Platební podmínky: '. 'Číslo dokladu: '.$Bill['BillCode'].' '. 'Variabilní symbol: '.$Subject['Id'].' '. 'Specifický symbol: '.$this->SpecificSymbol.' '. 'Konstantní symbol: '. 'Způsob úhrady: '.$PaymentType[$Bill['Cash']]. '	'. ' '. 'Datum vystavení: '.HumanDate($Bill['TimeCreate']).' '. 'Datum zdanitel. plnění: '.HumanDate($Bill['TimeCreate']).' '. 'Datum splatnosti: '.HumanDate($Bill['TimeDue']).' '; $Output .= '
'. ' '. ' '. ''. ''. ''; $Total = 0; foreach($Dodavka as $Polozka) { $Output .= ''; $Total += ($Polozka['Quantity'] * $Polozka['Price']); } $Output .= ''; $Output .= ' Dodávka Množství Cena/MJ Celkem '.$Polozka['Description'].' '.$Polozka['Quantity'].' '.$Polozka['Price'].' Kč '.($Polozka['Quantity'] * $Polozka['Price']).' Kč Celkem '.$Total.' Kč '. '

'; break; case 'income': $Output = ''. ''. ''. ''. ''; $Output .= '

'. 'Firma: '. 'Ing. Jiří Hajda '. 'Zděchov 208 '. '75607 Zděchov '. 'IČ: 75904535 '. 'DIČ: CZ8303255884 '. 'Účet: 218098370 / 0300 '. 'Neplátce DPH	'. 'PŘÍJMOVÝ POKLADNÍ DOKLAD '. 'Číslo dokladu: '.$Bill['BillCode'].' '. 'Datum vystavení: '.HumanDate($Bill['TimeCreate']).' '. '
Přijato od: '. $Subject['Name'].' '. $Subject['AddressStreet'].' '. $Subject['AddressPSC'].' '.$Subject['AddressTown'].' '; if($Subject['IC'] != 0) $Output .= 'IČ: '.$Subject['IC'].' '; if($Subject['DIC'] != '') $Output .= 'DIČ: '.$Subject['DIC'].' '; $Total = 0; $Description = ''; foreach($Dodavka as $Polozka) { $Description .= $Polozka['Description'].' '; $Total += ($Polozka['Quantity'] * $Polozka['Price']); } $Output .= '
Částka: '.$Total.' Kč '. '
Účel platby: '.$Description.'
Podpis příjemce:	Podpis pokladníka:

'; break; } return($Output); } function CreateBill($SubjectId, $Items, $TimeCreate, $TimeDue, $BillCode = '', $Type = 'invoice') { $this->Database->insert('FinanceBills', array('TimeCreate' => TimeToMysqlDateTime($TimeCreate), 'Subject' => $SubjectId, 'TimeDue' => TimeToMysqlDateTime($TimeDue), 'BillCode' => $BillCode, 'Type' => $Type)); $BillId = $this->Database->insert_id; foreach($Items as $Item) { $this->Database->insert('FinanceBillsItems', array('Bill' => $BillId, 'Description' => $Item['Description'], 'Price' => $Item['Price'], 'Quantity' => $Item['Quantity'])); } //Header('Content-Type: application/pdf'); $PdfData = $this->HtmlToPdf($this->GenerateBill($BillId)); //echo($PdfData); file_put_contents($this->FileFolder.'/'.$this->FileNamePrefix.$BillId.'.pdf', $PdfData); //$this->Database->query('UPDATE finance_bills SET pdf = 0x'.bin2hex($PdfData).' WHERE id='.$BillId); return($BillId); } function CreateIncomeBill($SubjectId, $Description, $Price, $BillCode) { $this->Database->insert('FinanceBills', array('TimeCreate' => TimeToMysqlDateTime(time()), 'Subject' => $SubjectId, 'BillCode' => $BillCode, 'Type' => 'income')); $BillId = $this->Database->insert_id; $this->Database->insert('FinanceBillsItems', array('Bill' => $BillId, 'Description' => $Description, 'Price' => $Price, 'Quantity' => 1)); //Header('Content-Type: application/pdf'); $PdfData = $this->HtmlToPdf($this->GenerateBill($BillId)); //echo($PdfData); file_put_contents($this->FileFolder.'/'.$this->FileNamePrefix.$BillId.'.pdf', $PdfData); //$this->Database->query('UPDATE finance_bills SET pdf = 0x'.bin2hex($PdfData).' WHERE id='.$BillId); return($BillId); } function RegeneratePDF($BillId) { global $Database; $PdfData = $this->HtmlToPdf($this->GenerateBill($BillId)); //echo($this->FileFolder.'/'.$this->FileNamePrefix.$BillId.'.pdf'); echo(file_put_contents($this->FileFolder.'/'.$this->FileNamePrefix.$BillId.'.pdf', $PdfData)); //$this->Database->query('UPDATE finance_bills SET pdf = 0x'.bin2hex($PdfData).' WHERE id='.$BillId); } function ShowStoredBill($BillId) { global $Database; //$DbResult = $this->Database->select('finance_bills', 'pdf', 'id='.$BillId); //if($DbResult->num_rows == 1) //{ // $DbRow = $DbResult->fetch_array(); $FileName = $this->FileFolder.'/'.$this->FileNamePrefix.$BillId.'.pdf'; if(file_exists($FileName)) { Header('Content-Type: application/pdf'); Header('Content-Disposition: attachment; filename="'.$this->FileNamePrefix.$BillId.'.pdf"'); echo(file_get_contents($FileName)); } else echo('Faktura nenalezena'); } function ShowGeneratedBill($BillId) { global $Database; Header('Content-Type: application/pdf'); Header('Content-Disposition: attachment; filename="'.$this->FileNamePrefix.$BillId.'.pdf"'); echo($this->HtmlToPdf($this->GenerateBill($BillId))); } function HasPDFFile($BillId) { return(file_exists($this->FileFolder.'/'.$this->FileNamePrefix.$BillId.'.pdf')); } function HtmlToPdf($HtmlCode) { $Output = shell_exec('echo "'.addslashes(FromUTF8($HtmlCode)).'"|htmldoc --no-numbered --webpage --charset 8859-2 -t pdf -'); return($Output); } function CustomGenerate() { global $Database; $DbResult = $this->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']."
\n"); $Time = MysqlDateToTime($Row['date']); $BillId = $this->CreateBill($Row['user'], array(array('Description' => 'Poplatek za připojení k síti', 'Price' => (-$Row['money']), 'Quantity' => 1)), $Time, $Time + (date("t", time()) - 1) * 24 * 3600); $this->Database->update('finance_operations', 'id='.$Row['id'], array('bill_id' => $BillId)); } } function ShowPage() { global $Database; if(array_key_exists('subject', $_GET)) { $DbResult = $this->Database->select('FinanceBills', '*', 'Subject='.$_GET['subject']); while($Item = $DbResult->fetch_array()) { echo('faktura '.$Item['Id'].' Uložené PDF Generované PDF Přegenerovat
'); } } else if(array_key_exists('billpdf', $_GET)) { $this->ShowStoredBill($_GET['billpdf']); } else if(array_key_exists('billpdf2', $_GET)) { $this->ShowGeneratedBill($_GET['billpdf2']); } else if(array_key_exists('regenerate', $_GET)) { $this->RegeneratePDF($_GET['regenerate']); } else if(array_key_exists('bill', $_GET)) { echo($this->GenerateBill($_GET['bill'])); } else if(array_key_exists('generate', $_GET)) { $this->CreateBill(1, array(array('Description' => 'Poplatek za připojení k síti', 'Price' => 1000, 'Quantity' => 1)), time(), time()); } else { ShowHeader('Doklady', 'Doklady'); echo('Faktury:
'); $DbResult = $this->Database->select('Subject', '*', '1 ORDER BY Name'); while($Subject = $DbResult->fetch_assoc()) { echo(''.$Subject['Name'].'
'); } ShowFooter(); } } } ?>