Download the PHP package spojenet/pohoda-sql without Composer

On this page you can find all versions of the php package spojenet/pohoda-sql. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Example code of spojenet/pohoda-sql

Informations about the package pohoda-sql

PohodaSQL

PHP Version CodeRabbit Pull Request Reviews License Composer Debian Package Latest Stable Version Total Downloads Latest Unstable Version License PHP Version Require

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!

Available Classes

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

Requirements

Composer

Configuration

Please set up this constants or environment variables:

Usage

Load a record by ID

Load by a field value

Override the database at instantiation

Read invoice header and its line items

List all addresses with a credit limit

Work with bank statements

Iterate shipments

Access employees

Attach a URL link to a Pohoda document

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.

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.

Debian Package

also package for debian/ubuntu is availble:

`

All versions of pohoda-sql with dependencies

PHP Build Version
Package Version
Requires vitexsoftware/ease-fluentpdo Version ^1.4
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package spojenet/pohoda-sql contains the following files

Loading the files please wait ...