Documentation

InvoiceMapper extends DataMapper
in package

The DataMapper is used to retrieve and store DataObjects from and to the Database

A DataMapper implementation has to provide the methods for interaction
But There should be find(ByXYZ) methods to retreive \VeruA\DataObjects and insert/update methods to store the data to the Database

Table of Contents

COLUMNS  = ['rechnung' => ['id', 'id_klient', 'id_vers', 'id_arzt', 'id_owner', 'id_organisation', 'id_kanton', 'gesamt_min', 'gesamt_taxp', 'r_betrag', 'diff', 'tp_wert', 'monat', 'jahr', 'von_monat', 'von_jahr', 'geschickt', 'geld_erhalten', 'rech_datum', 'schreiben', 'vers_nr', 'grund', 'status', 'berechnung', 'gesetz', 'material', 'preis_material', 'preis_ft', 'ea_erstellt', 'spitex', 'abrech_kv', 'exportiert', 'exportiert_cag', 'exportiert_ceesv', 'exportiert_billcare', 'exportiert_abacus', 'rkosten_anzeigen', 'geschlossen', 'covid19'], 'rechnung_ea' => ['anteil_ea', 'anteil_gemeinde', 'anteil_kanton'], 'klient' => VeruADataMapperClientMapper::COLUMNS['klient'], 'personen' => VeruADataMapperClientMapper::COLUMNS['personen'], 'adressen' => VeruADataMapperClientMapper::COLUMNS['adressen']]
JOINS  = ['LEFT JOIN klient ON rechnung.id_klient=klient.id', 'LEFT JOIN personen ON id_pers=personen.id', 'LEFT JOIN adressen ON personen.id_adr=adressen.id']
TABLE  = 'rechnung'
WHERE  = ['rechnung.del=0']
$dbc  : mixed
__construct()  : mixed
find()  : mixed
findOutstanding()  : mixed
sqlColumns()  : mixed
sqlSelectQuery()  : mixed

Constants

COLUMNS

public mixed COLUMNS = ['rechnung' => ['id', 'id_klient', 'id_vers', 'id_arzt', 'id_owner', 'id_organisation', 'id_kanton', 'gesamt_min', 'gesamt_taxp', 'r_betrag', 'diff', 'tp_wert', 'monat', 'jahr', 'von_monat', 'von_jahr', 'geschickt', 'geld_erhalten', 'rech_datum', 'schreiben', 'vers_nr', 'grund', 'status', 'berechnung', 'gesetz', 'material', 'preis_material', 'preis_ft', 'ea_erstellt', 'spitex', 'abrech_kv', 'exportiert', 'exportiert_cag', 'exportiert_ceesv', 'exportiert_billcare', 'exportiert_abacus', 'rkosten_anzeigen', 'geschlossen', 'covid19'], 'rechnung_ea' => ['anteil_ea', 'anteil_gemeinde', 'anteil_kanton'], 'klient' => VeruADataMapperClientMapper::COLUMNS['klient'], 'personen' => VeruADataMapperClientMapper::COLUMNS['personen'], 'adressen' => VeruADataMapperClientMapper::COLUMNS['adressen']]

JOINS

public mixed JOINS = ['LEFT JOIN klient ON rechnung.id_klient=klient.id', 'LEFT JOIN personen ON id_pers=personen.id', 'LEFT JOIN adressen ON personen.id_adr=adressen.id']

Properties

$dbc

protected mixed $dbc

A database Connection Object

Methods

__construct()

public __construct(mixed $dbc) : mixed
Parameters
$dbc : mixed

The database Connection Object

Return values
mixed —

find()

public find(int $id[, string $receiver = 'KV' ]) : mixed
Parameters
$id : int
$receiver : string = 'KV'
Return values
mixed —

findOutstanding()

public findOutstanding(int $id_owner[, string $receiver = 'KV' ]) : mixed
Parameters
$id_owner : int
$receiver : string = 'KV'
Return values
mixed —

sqlColumns()

protected sqlColumns(array<string|int, mixed> $tableColumns) : mixed
Parameters
$tableColumns : array<string|int, mixed>

[$table => [ $column, ... ], ...]

Return values
mixed —

sqlSelectQuery()

protected sqlSelectQuery(mixed $columns, mixed $table, mixed $joins, mixed $where) : mixed
Parameters
$columns : mixed
$table : mixed
$joins : mixed
$where : mixed
Return values
mixed —

Search results