InvoiceMapper
extends AbstractMapper
in package
The AbstractMapper is used to retrieve and store DomainObjects 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\DomainObjects and insert/update methods
to store the data to the Database
Table of Contents
- COLUMNS = [self::TABLE => ['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']]
- TABLE = 'rechnung'
- WHERE = ['rechnung.del=0']
- JOINS = ['rechnung_ea' => ['INNER JOIN', 'rechnung_ea', 'rechnung.id=rechnung_ea.id_rech', ['anteil_ea', 'anteil_gemeinde', 'anteil_kanton']], 'client' => ['INNER JOIN', \VeruA\DataMapper\ClientMapper::TABLE, 'rechnung.id_klient=`client`.id', \VeruA\DataMapper\ClientMapper::COLUMNS[\VeruA\DataMapper\ClientMapper::TABLE]], 'client.person' => ['INNER JOIN', \VeruA\DataMapper\PersonMapper::TABLE, 'id_pers=`client.person`.id', \VeruA\DataMapper\PersonMapper::COLUMNS[\VeruA\DataMapper\PersonMapper::TABLE]], 'client.person.address' => ['INNER JOIN', \VeruA\DataMapper\AddressMapper::TABLE, '`client.person`.id_adr=`client.person.address`.id', \VeruA\DataMapper\AddressMapper::COLUMNS[\VeruA\DataMapper\AddressMapper::TABLE]], 'insurance' => ['INNER JOIN', \VeruA\DataMapper\OrganisationMapper::TABLE, '`insurance`.id=rechnung.id_vers', \VeruA\DataMapper\OrganisationMapper::COLUMNS[\VeruA\DataMapper\OrganisationMapper::TABLE]]]
- $dbc : mysqli
- $fieldMap : array<string|int, mixed>
- $map : array<string|int, mixed>
- __construct() : mixed
- find() : mixed
- get Invoice by id like 'KV_123' or 'KT_456'
- findByReceiver() : mixed
- findMany() : DomainObjectCollection
- findOutstanding() : DomainObjectCollection
- Returns all open invoices for a given owner
- insert() : mixed
- invoiceQuery() : mixed
- load() : DomainObject
- loadGhost() : void
- mapValues() : mixed
- Map DomainObjectValues to database column values
- sqlWhere() : mixed
- store() : mixed
- storeMany() : mixed
- update() : mixed
- updateAll() : mixed
- abstractCreateGhost() : DomainObject
- abstractFind() : DomainObject
- Executes an sql select statement
- createGhost() : mixed
- doLoad() : Invoice
- insertQuery() : IQuery
- Returns a new INSERT Query Instance
- query() : IQuery
- Returns a new SELECT Query Instance
- sqlColumns() : string
- sqlInsertQuery() : string
- sqlJoins() : string
- sqlSelectQuery() : string
- sqlUpdateQuery() : string
- updateQuery() : IQuery
- Returns a new UPDATE Query Instance
Constants
COLUMNS
public
mixed
COLUMNS
= [self::TABLE => ['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']]
TABLE
public
mixed
TABLE
= 'rechnung'
WHERE
public
mixed
WHERE
= ['rechnung.del=0']
JOINS
protected
mixed
JOINS
= ['rechnung_ea' => ['INNER JOIN', 'rechnung_ea', 'rechnung.id=rechnung_ea.id_rech', ['anteil_ea', 'anteil_gemeinde', 'anteil_kanton']], 'client' => ['INNER JOIN', \VeruA\DataMapper\ClientMapper::TABLE, 'rechnung.id_klient=`client`.id', \VeruA\DataMapper\ClientMapper::COLUMNS[\VeruA\DataMapper\ClientMapper::TABLE]], 'client.person' => ['INNER JOIN', \VeruA\DataMapper\PersonMapper::TABLE, 'id_pers=`client.person`.id', \VeruA\DataMapper\PersonMapper::COLUMNS[\VeruA\DataMapper\PersonMapper::TABLE]], 'client.person.address' => ['INNER JOIN', \VeruA\DataMapper\AddressMapper::TABLE, '`client.person`.id_adr=`client.person.address`.id', \VeruA\DataMapper\AddressMapper::COLUMNS[\VeruA\DataMapper\AddressMapper::TABLE]], 'insurance' => ['INNER JOIN', \VeruA\DataMapper\OrganisationMapper::TABLE, '`insurance`.id=rechnung.id_vers', \VeruA\DataMapper\OrganisationMapper::COLUMNS[\VeruA\DataMapper\OrganisationMapper::TABLE]]]
Properties
$dbc
protected
mysqli
$dbc
A database Connection Object
$fieldMap
protected
array<string|int, mixed>
$fieldMap
= []
Map DomainObjects field names to database column names
Tags
$map
protected
static array<string|int, mixed>
$map
Identity Map of Invoice Objects
Methods
__construct()
public
__construct(mysqli $dbc) : mixed
Parameters
- $dbc : mysqli
-
The database Connection Object
Return values
mixed —find()
get Invoice by id like 'KV_123' or 'KT_456'
public
find(string $id) : mixed
Parameters
- $id : string
Return values
mixed —findByReceiver()
public
findByReceiver(mixed $id[, string $receiver = 'KV' ]) : mixed
Parameters
- $id : mixed
- $receiver : string = 'KV'
Return values
mixed —findMany()
public
findMany(IQuery $query) : DomainObjectCollection
Parameters
- $query : IQuery
Return values
DomainObjectCollection —findOutstanding()
Returns all open invoices for a given owner
public
findOutstanding(int $id_owner[, string $receiver = 'KV' ]) : DomainObjectCollection
Parameters
- $id_owner : int
- $receiver : string = 'KV'
Return values
DomainObjectCollection —insert()
public
insert(DomainObject $dmo) : mixed
Parameters
- $dmo : DomainObject
Return values
mixed —invoiceQuery()
public
invoiceQuery(string $receiver[, array<string|int, mixed>|null $joinedTables = null ]) : mixed
Parameters
- $receiver : string
- $joinedTables : array<string|int, mixed>|null = null
Return values
mixed —load()
public
load(IResultSet $rs) : DomainObject
Parameters
- $rs : IResultSet
Return values
DomainObject —loadGhost()
public
loadGhost(DomainObject $ghost) : void
Parameters
- $ghost : DomainObject
Return values
void —mapValues()
Map DomainObjectValues to database column values
public
mapValues(array<string|int, mixed> $values) : mixed
Parameters
- $values : array<string|int, mixed>
Return values
mixed —sqlWhere()
public
sqlWhere(array<string|int, mixed> $where) : mixed
Parameters
- $where : array<string|int, mixed>
Return values
mixed —store()
public
store(DomainObject $dmo) : mixed
Parameters
- $dmo : DomainObject
Return values
mixed —storeMany()
public
storeMany(mixed $dmos) : mixed
Parameters
- $dmos : mixed
Return values
mixed —update()
public
update(DomainObject $dmo) : mixed
Parameters
- $dmo : DomainObject
Return values
mixed —updateAll()
public
updateAll(DomainObject $dmo) : mixed
Parameters
- $dmo : DomainObject
Return values
mixed —abstractCreateGhost()
protected
abstractCreateGhost(DomainObject $dmo) : DomainObject
Parameters
- $dmo : DomainObject
Return values
DomainObject —abstractFind()
Executes an sql select statement
protected
abstractFind(string|Varchar|int $id, IQuery $query) : DomainObject
checks if object is already in the identity map and returns it, if not it executes the sql.
Parameters
- $id : string|Varchar|int
-
The Primary Key
- $query : IQuery
Tags
Return values
DomainObject —createGhost()
protected
abstract createGhost(Key $id) : mixed
Parameters
- $id : Key
Return values
mixed —doLoad()
protected
static doLoad(mixed $id, IResultSet $rs) : Invoice
Parameters
- $id : mixed
- $rs : IResultSet
Return values
Invoice —insertQuery()
Returns a new INSERT Query Instance
protected
insertQuery() : IQuery
Return values
IQuery —query()
Returns a new SELECT Query Instance
protected
query() : IQuery
Return values
IQuery —sqlColumns()
protected
sqlColumns(array<string|int, mixed> $tableColumns) : string
Parameters
- $tableColumns : array<string|int, mixed>
-
[$table => [ $column, ... ], ...]
Return values
string —sqlInsertQuery()
protected
sqlInsertQuery(array<string|int, mixed> $columns, string $table, array<string|int, mixed> $values) : string
Parameters
- $columns : array<string|int, mixed>
-
[$table => [ $column, ... ], ...]
- $table : string
- $values : array<string|int, mixed>
-
array a row of values in the same order and count of $columns
Return values
string —sqlJoins()
protected
sqlJoins(array<string|int, mixed> $joins) : string
Parameters
- $joins : array<string|int, mixed>
Return values
string —sqlSelectQuery()
protected
sqlSelectQuery(array<string|int, mixed> $columns, string $table, array<string|int, mixed> $joins, array<string|int, mixed> $where) : string
Parameters
- $columns : array<string|int, mixed>
-
[$table => [ $column, ... ], ...]
- $table : string
- $joins : array<string|int, mixed>
-
array of sql joins
- $where : array<string|int, mixed>
-
array of where clauses joined with AND
Return values
string —sqlUpdateQuery()
protected
sqlUpdateQuery(array<string|int, mixed> $values, string $table, string $where) : string
Parameters
- $values : array<string|int, mixed>
-
[$field => $value, ...]
- $table : string
- $where : string
-
condition
Return values
string —updateQuery()
Returns a new UPDATE Query Instance
protected
updateQuery() : IQuery