Folders and files
| Name | Name | Last commit date | ||
|---|---|---|---|---|
This is a PHP Library for direct access to Pohoda SQL database tables. Struct definitions are kept in sync with a live Pohoda SQL database (StwPh_12345678_2026 on SQL Server Express).
Use at your own risk!
| Class | Table | Description |
|---|---|---|
| Adresar | AD | Address book |
| BankovniVypis | BV | Bank statement |
| BankovniVypisPol | BVpol | Bank statement line item |
| CasoveRozliseni | CasRoz | Time resolution |
| CasoveRozliseniPol | CasRozPol | Time resolution line item |
| CiselnaRada | sCRady | Number series |
| DOC | DOC | Document attachments |
| Faktura | FA | Issued/received invoices |
| FakturaPolozka | FApol | Invoice line items |
| HotovostniOperace | HO | Cash document |
| HotovostniOperacePol | HOpol | Cash document line item |
| Majetek | IM | Fixed assets |
| MajetkoveOperace | IMpohyb | Asset movements |
| Nabidka | NAB | Offer |
| NabidkaPol | NABpol | Offer line item |
| ObjednavkaPrijata | OBJ | Received order |
| ObjednavkaPrijataPol | OBJpol | Received order line item |
| OdpisovyPlan | sIMO | Depreciation plans |
| Pokladna | PH | Cash register document |
| PokladnaPol | PHpol | Cash register line item |
| Predkontace | pPK | Pre-accounting |
| Predmet | IMpredm | Asset subjects |
| Uhrada | Uhrady | Payment |
| Zamestnanec | ZAM | Employee |
| Zasilka | Zasilky | Shipment |
| ZasilkaPol | ZasilkyPol | Shipment line item |
- PHP 7.2+
- php-sqlsrv
- php-ease-fluentpdo
composer require spojenet/pohoda-sqlPlease set up this constants or environment variables:
- DB_TYPE We use sqlsrv
- DB_HOST IP or Hostname machine with SQL Server
- DB_PORT default is 1433
- DB_DATABASE something like StwPh_01234567_2019
- DB_USERNAME sqlserver login
- DB_PASSWORD sqlserver pass
- DB_SETTINGS eg. encrypt=false
$addr = new Adresar(234);
echo $addr->getDataValue('Firma'); // company name$addr = new Adresar(['ICO' => '69438676']);
echo $addr->getDataValue('Email');$addr = new Adresar(234, ['database' => 'StwPh_01234567_2020']);$invoice = new Faktura(1001);
echo $invoice->getDataValue('Cislo'); // document number
echo $invoice->getDataValue('KcCelkem'); // total amount
$lines = new FakturaPolozka();
$rows = $lines->getColumnsFromSQL(['Nazev', 'Mnozstvi', 'KcCena'], ['RefAg' => 1001]);
foreach ($rows as $row) {
echo $row['Nazev'] . ' × ' . $row['Mnozstvi'] . ' = ' . $row['KcCena'] . PHP_EOL;
}$addr = new Adresar();
$rows = $addr->getColumnsFromSQL(['Cislo', 'Firma', 'ADKreditMax'], ['ADKreditMax>' => 0]);
foreach ($rows as $row) {
printf("%s %s (limit: %s)\n", $row['Cislo'], $row['Firma'], $row['ADKreditMax']);
}$bv = new BankovniVypis(['Cislo' => 'BV2024001']);
$pol = new BankovniVypisPol();
$items = $pol->getColumnsFromSQL(['KcCastka', 'VS', 'Datum'], ['RefBV' => $bv->getMyKey()]);$zasilky = new Zasilka();
$list = $zasilky->getColumnsFromSQL(['ID', 'Cislo', 'RefAD', 'DatOdeslani']);
foreach ($list as $z) {
echo $z['Cislo'] . ' – ' . $z['DatOdeslani'] . PHP_EOL;
}$zam = new Zamestnanec(['RodCisl' => '8001011234']);
echo $zam->getDataValue('Prijmeni') . ' ' . $zam->getDataValue('Jmeno');The DOC table stores document attachments for every agenda. Use urlAttachment() to link an external URL (e.g. a SharePoint file, a web invoice, a tracking page) to an existing record. The second argument is the Pohoda internal document ID; the agenda type is identified by one of the Agenda::* constants.
use SpojeNet\PohodaSQL\Agenda;
use SpojeNet\PohodaSQL\DOC;
// Attach a SharePoint link to a bank statement (agenda = Agenda::BANK = 28)
$doc = new DOC();
$doc->setDataValue('RelAgID', Agenda::BANK);
$doc->urlAttachment(
pohodaId: 303, // DOC.RelID – internal Pohoda record ID
url: 'https://sharepoint.example.com/statements/BV2024001.pdf',
name: 'BV2024001.pdf', // display name shown in Pohoda
);
// Attach a link to an issued invoice (agenda = Agenda::ISSUED_INVOICES = 2)
$doc = new DOC();
$doc->setDataValue('RelAgID', Agenda::ISSUED_INVOICES);
$doc->urlAttachment(1001, 'https://portal.example.com/invoice/1001', 'Invoice PDF');Available Agenda::* constants mirror the RelCrAg values from sCRady:
| Constant | Value | Agenda |
|---|---|---|
| Agenda::ISSUED_INVOICES | 2 | Issued invoices |
| Agenda::RECEIVED_INVOICES | 3 | Received invoices |
| Agenda::ORDERS_RECEIVED | 11 | Received orders |
| Agenda::CASH_REGISTER | 27 | Cash register |
| Agenda::BANK | 28 | Bank statements |
See https://github.com/VitexSoftware/php-ease-fluentpdo for more information.
also package for debian/ubuntu is availble:
wget -qO- https://repo.vitexsoftware.com/KEY.gpg | sudo tee /etc/apt/trusted.gpg.d/vitexsoftware.gpg
echo "deb [signed-by=/etc/apt/trusted.gpg.d/vitexsoftware.gpg] https://repo.vitexsoftware.com $(lsb_release -sc) main" | sudo tee /etc/apt/sources.list.d/vitexsoftware.list
sudo apt update
sudo apt install php-spojenet-pohoda-sql