Docs Goabase

PartySQL
in package
uses TraitCountry, TraitGeoSQL, TraitUser

Table of Contents

Properties

$env  : array<string|int, mixed>
$geoSQL  : GeoSQL
$user  : User

Methods

__construct()  : mixed
getCountryInstance()  : Country
getGeoSQLInstance()  : GeoSQL
getIdIn()  : string
getSQL()  : array{0: string, 1: string, 2: string, 3: string}
Generates 4 different SQL statements for the parties
getUserInstance()  : User
getFromDateSince()  : string
getFromDateStart()  : string
getLocationFilter()  : string
getSearchDate()  : string
getSearchFilter()  : string
getSQLDistinctIDs()  : string
getSub()  : string
getSubCountry()  : string
getSubUser()  : string

Properties

$env

private array<string|int, mixed> $env

Methods

__construct()

public __construct() : mixed

getIdIn()

public getIdIn(string $strSQLAndIdIn[, string $strTable = '' ]) : string
Parameters
$strSQLAndIdIn : string
$strTable : string = ''
Return values
string

getSQL()

Generates 4 different SQL statements for the parties

public getSQL(array<string|int, mixed> $saAtt[, int $nPos = 0 ][, int $bPast = 0 ]) : array{0: string, 1: string, 2: string, 3: string}
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 [0]: count, [1] standard with limit, [2] no limit, [3] where only
Tags
throws
DateMalformedStringException
throws
RandomException
Return values
array{0: string, 1: string, 2: string, 3: string}

getFromDateSince()

private getFromDateSince(array<string|int, mixed> $saAtt, string $strWhereDate) : string
Parameters
$saAtt : array<string|int, mixed>
$strWhereDate : string
Return values
string

getFromDateStart()

private getFromDateStart(array<string|int, mixed> $saAtt, string $strWhereDate) : string
Parameters
$saAtt : array<string|int, mixed>
$strWhereDate : string
Return values
string

getLocationFilter()

private getLocationFilter(array<string|int, mixed> $saAtt, int $nPos, int $bPast) : string
Parameters
$saAtt : array<string|int, mixed>
$nPos : int
$bPast : int
Tags
throws
DateMalformedStringException
throws
RandomException
Return values
string

getSearchDate()

private getSearchDate([string $strSearchDate = '' ]) : string
Parameters
$strSearchDate : string = ''
Tags
throws
DateMalformedStringException
throws
DateMalformedStringException
Return values
string

getSearchFilter()

private getSearchFilter(array<string|int, mixed> $saAtt) : string
Parameters
$saAtt : array<string|int, mixed>
Tags
throws
RandomException
Return values
string

getSQLDistinctIDs()

private getSQLDistinctIDs(string $tblKey) : string
Parameters
$tblKey : string
Return values
string

getSub()

private getSub([array<string|int, mixed> $saAtt = [] ]) : string
Parameters
$saAtt : array<string|int, mixed> = []
Return values
string

getSubCountry()

private getSubCountry(string $country) : string
Parameters
$country : string
Return values
string

getSubUser()

private getSubUser(array<string|int, mixed> $saAtt, int $nUserID) : string
Parameters
$saAtt : array<string|int, mixed>
$nUserID : int
Return values
string 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results