Support
in package
Table of Contents
Methods
- __construct() : mixed
- aktiviereKompl() : mixed
- bugfix_flexTarif_v718() : mixed
- changeMainDataOwnerOrg() : bool
- change main data for new owner-entry
- changeMod() : mixed
- changeQR() : mixed
- changeSettingsMatFpp() : mixed
- change settings mod_pop in table owner
- changeSettingsPopFpp() : mixed
- change settings mod_pop in table owner
- changeSettingsWbettFpp() : mixed
- change settings mod_wochenbett in table owner
- checkIsSpitex() : mixed
- Check if business is FPP or ORG without session
- checkLogin() : mixed
- checkOwnerSettings() : mixed
- Check and update mod_xml with the given ownerId
- deaktiviereKompl() : mixed
- del_rechnungen_BS() : mixed
- deleteWrongLogs() : mysqli_affected_rows
- delete wrong log-messages from table changes wiht type = 7 if FPP
- exceuteSqlSatement() : int
- get_ALL_Monat_Jahr_Export_EA() : mixed
- get_data_owner() : mixed
- get all data from table owner
- get_data_spitex() : mixed
- getAllLoginData() : result
- get all data from table accessSupportteam wiht del = 0
- getCantonWithCangedTariffs() : mysql
- get all date from taxwert, where tariffs_canton affected by tariff update
- getExportierte_RE_ByOwner() : mixed
- getExportierte_RE_Spitex() : mixed
- getMonat_Jahr_Export_EA() : mixed
- getOffeneRE_ByMonJahr_EA() : mixed
- getOffeneRE_ByMonJahr_EA_ALL() : mixed
- getOffeneRE_ByMonJahr_KT_BS() : object|null
- getOffeneRE_ByMonJahr_KT_BS_Spitex() : type
- rechnungen_BS_eintragen() : mixed
- getResultsOrDie() : object|void
Methods
__construct()
public
__construct() : mixed
aktiviereKompl()
public
aktiviereKompl(mixed $id_owner) : mixed
Parameters
- $id_owner : mixed
bugfix_flexTarif_v718()
public
bugfix_flexTarif_v718() : mixed
changeMainDataOwnerOrg()
change main data for new owner-entry
public
changeMainDataOwnerOrg(string $sqlUpdate) : bool
Parameters
- $sqlUpdate : string
-
sql-query to update owner-data
Return values
boolchangeMod()
public
changeMod(mixed $kind, mixed $state, mixed $userLicence, mixed $arrMa) : mixed
Parameters
- $kind : mixed
- $state : mixed
- $userLicence : mixed
- $arrMa : mixed
changeQR()
public
changeQR(mixed $table, mixed $user, mixed $mod_qr, mixed $ea, mixed $kan, mixed $gem) : mixed
Parameters
- $table : mixed
- $user : mixed
- $mod_qr : mixed
- $ea : mixed
- $kan : mixed
- $gem : mixed
changeSettingsMatFpp()
change settings mod_pop in table owner
public
changeSettingsMatFpp(int $ownerId, int $state) : mixed
Parameters
- $ownerId : int
-
change settings for given owner
- $state : int
-
0: deactivate mod mat - 1: activate mod mat
Tags
changeSettingsPopFpp()
change settings mod_pop in table owner
public
changeSettingsPopFpp(int $ownerId, int $state) : mixed
Parameters
- $ownerId : int
-
change settings for given owner
- $state : int
-
0: deactivate mod pop - 1: activate mod pop
Tags
changeSettingsWbettFpp()
change settings mod_wochenbett in table owner
public
changeSettingsWbettFpp(int $ownerId, int $state) : mixed
Parameters
- $ownerId : int
-
change settings for given owner
- $state : int
-
0: deactivate mod; 1: activate mod
Tags
checkIsSpitex()
Check if business is FPP or ORG without session
public
checkIsSpitex() : mixed
Tags
checkLogin()
public
checkLogin(mixed $user, mixed $pwd) : mixed
Parameters
- $user : mixed
- $pwd : mixed
checkOwnerSettings()
Check and update mod_xml with the given ownerId
public
checkOwnerSettings([int $ownerId = null ]) : mixed
If $ownerId is not given, check for spitex.
Parameters
- $ownerId : int = null
-
The id of the owner
deaktiviereKompl()
public
deaktiviereKompl() : mixed
del_rechnungen_BS()
public
del_rechnungen_BS(mixed $monat, mixed $jahr) : mixed
Parameters
- $monat : mixed
- $jahr : mixed
deleteWrongLogs()
delete wrong log-messages from table changes wiht type = 7 if FPP
public
deleteWrongLogs([int $type = 7 ]) : mysqli_affected_rows
Parameters
- $type : int = 7
-
changes.type - default = 7, changes on pd_eintrag if business is ORG
Return values
mysqli_affected_rows —or false
exceuteSqlSatement()
public
exceuteSqlSatement(string $insertSql, int $kind) : int
Parameters
- $insertSql : string
-
insert-sql-string
- $kind : int
-
defines the type of query: 1 = add new owner to db, 2 = execute query
Return values
int —$insertId or 0
get_ALL_Monat_Jahr_Export_EA()
public
get_ALL_Monat_Jahr_Export_EA() : mixed
get_data_owner()
get all data from table owner
public
get_data_owner([string $orderBy = "ORDER BY nname, vname" ][, int $del = 0 ]) : mixed
Parameters
- $orderBy : string = "ORDER BY nname, vname"
-
order of mysqli-result set, default: "ORDER BY nname, vname"
- $del : int = 0
-
select by state - 0: all active (default), 1: all inaktive, 2: all data
get_data_spitex()
public
get_data_spitex(mixed $id) : mixed
Parameters
- $id : mixed
getAllLoginData()
get all data from table accessSupportteam wiht del = 0
public
getAllLoginData() : result
Return values
result —of mysqli_query
getCantonWithCangedTariffs()
get all date from taxwert, where tariffs_canton affected by tariff update
public
getCantonWithCangedTariffs(string $queryAbbreviations[, string $queryIvUv = "" ]) : mysql
Parameters
- $queryAbbreviations : string
-
list of all canton abbreviations for which there are changes to the billing - tariffs klv
- $queryIvUv : string = ""
-
if needed search for tariffs iv / uv too
Return values
mysql —query result set OR false
getExportierte_RE_ByOwner()
public
getExportierte_RE_ByOwner(mixed $id_owner) : mixed
Parameters
- $id_owner : mixed
getExportierte_RE_Spitex()
public
getExportierte_RE_Spitex() : mixed
getMonat_Jahr_Export_EA()
public
getMonat_Jahr_Export_EA() : mixed
getOffeneRE_ByMonJahr_EA()
public
getOffeneRE_ByMonJahr_EA(mixed $monat, mixed $jahr, mixed $id_owner) : mixed
Parameters
- $monat : mixed
- $jahr : mixed
- $id_owner : mixed
getOffeneRE_ByMonJahr_EA_ALL()
public
getOffeneRE_ByMonJahr_EA_ALL(mixed $monat, mixed $jahr, mixed $id_owner) : mixed
Parameters
- $monat : mixed
- $jahr : mixed
- $id_owner : mixed
getOffeneRE_ByMonJahr_KT_BS()
public
getOffeneRE_ByMonJahr_KT_BS(int $month, int $year, int $id) : object|null
Parameters
- $month : int
- $year : int
- $id : int
Return values
object|nullgetOffeneRE_ByMonJahr_KT_BS_Spitex()
public
getOffeneRE_ByMonJahr_KT_BS_Spitex(int $month, int $year) : type
Parameters
- $month : int
- $year : int
Return values
typerechnungen_BS_eintragen()
public
rechnungen_BS_eintragen(mixed $r_nr) : mixed
Parameters
- $r_nr : mixed
getResultsOrDie()
protected
getResultsOrDie(string $query, string $methodName) : object|void
Parameters
- $query : string
- $methodName : string