ClientMapper
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 = 'klient.id, id_pers, id_adr, vname, nname, anrede, str, plz, ort, ' . 'ahv, geb, staatsang, tel, natel, email'
- $dbc : mixed
- $findStatement : mixed
- __construct() : mixed
- find() : mixed
- findByAHV() : mixed
Constants
COLUMNS
public
mixed
COLUMNS
= 'klient.id, id_pers, id_adr, vname, nname, anrede, str, plz, ort, ' . 'ahv, geb, staatsang, tel, natel, email'
Properties
$dbc
protected
mixed
$dbc
$findStatement
protected
mixed
$findStatement
= 'SELECT ' . self::COLUMNS . ' FROM klient ' . 'LEFT JOIN personen ON id_pers=personen.id ' . 'LEFT JOIN adressen ON personen.id_adr=adressen.id ' . 'WHERE klient.del=0'
Methods
__construct()
public
__construct(mixed $dbc) : mixed
Parameters
- $dbc : mixed
-
The database Connection Object
Return values
mixed —find()
public
find([mixed $id = null ]) : mixed
Parameters
- $id : mixed = null
Return values
mixed —findByAHV()
public
findByAHV(string $ahv[, mixed $idOwner = null ]) : mixed
Parameters
- $ahv : string
- $idOwner : mixed = null