BuildingRepository
extends BaseRepository
in package
implements
IBuildingRepository
Interfaces, Classes, Traits and Enums
Table of Contents
- $cache : RepositoryCache
- $configTable : string
- $db : IDatabase
- $params : array<string|int, mixed>
- $SQL : string
- $sql : string
- SQL statement
- $SQLlimit : string
- $SQLorder : string
- $SQLwhere : string
- $table : string
- Database table name
- $addressLoading : bool
- $addressRepository : IAddressRepository
- $imageRepository : IImageRepository
- $pagination : Pagination
- __construct() : mixed
- all() : array<string|int, Model>
- reads all results of query
- byId() : Model
- Reads specific object by provided id
- create() : int
- Creates new building
- delete() : void
- Deletes provided object
- one() : Model
- gets one item from collection
- orderBy() : IRepository
- Enables ordering on results
- save() : void
- Saves building state
- setDefaultImage() : void
- sets default image for building
- setPagination() : IRepository
- Sets pagination feature enabled
- where() : IRepository
- Builds WHERE clause of query with provided data of array
- withAddress() : IBuildingRepository
- enable address object loading
- executeQuery() : array<string|int, mixed>
- newItem() : Building
- Creates new Domain object from provided data
Properties
$cache
protected
RepositoryCache
$cache
$configTable
protected
string
$configTable
= '`configuration`'
$db
protected
IDatabase
$db
$params
protected
array<string|int, mixed>
$params
= []
$SQL
protected
string
$SQL
$sql
SQL statement
protected
string
$sql
= ' '
$SQLlimit
protected
string
$SQLlimit
= ''
$SQLorder
protected
string
$SQLorder
= ' ORDER BY `created` DESC'
$SQLwhere
protected
string
$SQLwhere
= ' WHERE 1=1'
$table
Database table name
protected
string
$table
= '`building`'
$addressLoading
private
bool
$addressLoading
= FALSE
$addressRepository
private
IAddressRepository
$addressRepository
$imageRepository
private
IImageRepository
$imageRepository
$pagination
private
Pagination
$pagination
Methods
__construct()
public
__construct(ContainerInterface $di, IImageRepository $imageRepository, IAddressRepository $addressRepository) : mixed
Parameters
- $di : ContainerInterface
- $imageRepository : IImageRepository
- $addressRepository : IAddressRepository
Return values
mixed —all()
reads all results of query
public
all() : array<string|int, Model>
Return values
array<string|int, Model> —byId()
Reads specific object by provided id
public
byId(int $id) : Model
Parameters
- $id : int
Return values
Model —create()
Creates new building
public
create(string $name, JsonDateTime $openTime, JsonDateTime $closeTime, int $addressId) : int
Parameters
- $name : string
- $openTime : JsonDateTime
- $closeTime : JsonDateTime
- $addressId : int
Return values
int —delete()
Deletes provided object
public
delete(Model $building) : void
Parameters
- $building : Model
Return values
void —one()
gets one item from collection
public
one() : Model
Return values
Model —orderBy()
Enables ordering on results
public
orderBy(string $name[, string $direction = 'DESC' ]) : IRepository
Parameters
- $name : string
- $direction : string = 'DESC'
Return values
IRepository —save()
Saves building state
public
save(Building $building) : void
Parameters
- $building : Building
Return values
void —setDefaultImage()
sets default image for building
public
setDefaultImage(Building $building) : void
Parameters
- $building : Building
Return values
void —setPagination()
Sets pagination feature enabled
public
setPagination(Pagination &$pagination) : IRepository
Parameters
- $pagination : Pagination
Return values
IRepository —where()
Builds WHERE clause of query with provided data of array
public
where(array<string|int, mixed> $searchParams) : IRepository
Parameters
- $searchParams : array<string|int, mixed>
Return values
IRepository —withAddress()
enable address object loading
public
withAddress() : IBuildingRepository
Return values
IBuildingRepository —executeQuery()
protected
executeQuery() : array<string|int, mixed>
Return values
array<string|int, mixed> —newItem()
Creates new Domain object from provided data
protected
newItem(array<string|int, mixed> $data) : Building
Parameters
- $data : array<string|int, mixed>