PartySQL
in package
uses
TraitData, TraitGeoSQL, TraitUser
FinalYes
Table of Contents
Properties
Methods
- __construct() : mixed
- getDataInstance() : Data
- getGeoSQLInstance() : GeoSQL
- getSQL() : array<string|int, mixed>
- Generates 4 different SQL statements for the parties
- getUserInstance() : User
- getDateCondition() : array<string|int, mixed>
- getFromDateSince() : array<string|int, mixed>
- getFromDateStart() : array<string|int, mixed>
- getIdIn() : string
- getLocationFilter() : array<string|int, mixed>
- getSearchDate() : array<string|int, mixed>
- getSearchFilter() : array<string|int, mixed>
- getSQLDistinctIDs() : array<string|int, mixed>
- getStatus() : array<string|int, mixed>
- getSub() : array<string|int, mixed>
- getSubCountry() : array<string|int, mixed>
- getSubUser() : array<string|int, mixed>
- processAttributes() : array<string|int, mixed>
Properties
$att
public
array<string|int, mixed>
$att
$data
private
Data
$data
$env
private
array<string|int, mixed>
$env
$user
private
User
$user
Methods
__construct()
public
__construct() : mixed
getDataInstance()
public
getDataInstance() : Data
Return values
DatagetGeoSQLInstance()
public
getGeoSQLInstance() : GeoSQL
Return values
GeoSQLgetSQL()
Generates 4 different SQL statements for the parties
public
getSQL(array<string|int, mixed> $saAtt[, int $nPos = 0 ][, int $bPast = 0 ]) : array<string|int, mixed>
Parameters
- $saAtt : array<string|int, mixed>
-
- searchdate, date_since, geoloc,photos, reports, meetings, lifts, field, search, report_puid, meeting_puid, lift_puid, flyer, member_puid, tag, mystyle, inout, status, country, new_entries
- $nPos : int = 0
-
- Counter
- $bPast : int = 0
-
- 0: present, 1: past
Tags
Return values
array<string|int, mixed>getUserInstance()
public
getUserInstance() : User
Return values
UsergetDateCondition()
private
getDateCondition(string $strOperator) : array<string|int, mixed>
Parameters
- $strOperator : string
Return values
array<string|int, mixed>getFromDateSince()
private
getFromDateSince(array<string|int, mixed> $whereDate) : array<string|int, mixed>
Parameters
- $whereDate : array<string|int, mixed>
Return values
array<string|int, mixed>getFromDateStart()
private
getFromDateStart(array<string|int, mixed> $whereDate) : array<string|int, mixed>
Parameters
- $whereDate : array<string|int, mixed>
Return values
array<string|int, mixed>getIdIn()
private
getIdIn(string $strSQLIn[, string $strTable = '' ]) : string
Parameters
- $strSQLIn : string
- $strTable : string = ''
Return values
stringgetLocationFilter()
private
getLocationFilter() : array<string|int, mixed>
Return values
array<string|int, mixed>getSearchDate()
private
getSearchDate() : array<string|int, mixed>
Return values
array<string|int, mixed>getSearchFilter()
private
getSearchFilter() : array<string|int, mixed>
Return values
array<string|int, mixed>getSQLDistinctIDs()
private
getSQLDistinctIDs(string $tableName) : array<string|int, mixed>
Parameters
- $tableName : string
Return values
array<string|int, mixed>getStatus()
private
getStatus(string $strOperator) : array<string|int, mixed>
Parameters
- $strOperator : string
Return values
array<string|int, mixed>getSub()
private
getSub() : array<string|int, mixed>
Return values
array<string|int, mixed>getSubCountry()
private
getSubCountry() : array<string|int, mixed>
Return values
array<string|int, mixed>getSubUser()
private
getSubUser() : array<string|int, mixed>
Return values
array<string|int, mixed>processAttributes()
private
processAttributes(array<string|int, mixed> $saAtt) : array<string|int, mixed>
Parameters
- $saAtt : array<string|int, mixed>