Dienstplan
in package
All methods for the module dienstplan
Table of Contents
Methods
- checkRelationsDienst() : array<string|int, mixed>
- check relations bevor deleting dienst with del=1 on tables tp_event, tp_visit and tp_visitDays
- del_Dienst() : mixed
- del_MA_Dienst() : mixed
- del_MA_dienst_byWeekDay() : mixed
- del_VG_dienst_Daten() : mixed
- set del = 1 in table dp_vorgaben for given id
- delTageMaByDienst() : mixed
- get_All_Bereiche_nachMA_Aktiv_kurz() : mixed
- get_All_MA_Aktiv() : mysqli_query
- get all employee data with given parameters
- get_All_MA_Aktiv_kurz() : mixed
- get_All_VG() : mixed
- get_All_VG_Schicht() : mixed
- get_bereichDIenst_byIDD() : mixed
- get all data from table ma_vg_bereich by id
- get_Bereiche_MA() : mixed
- get_Besuche_ByDate_Dienst() : mixed
- get_Dienst_byID() : mixed
- get_dienstByMonthYearMA() : mysqli_result
- returns all dienste of an employee in selected month / year
- get_dienste_ByKwJahr() : mixed
- get_SumAZ_ByID_DP_Schicht() : mixed
- get_Tage_ByID_DP_Dienst() : mixed
- get_VG_ByID() : mixed
- getAllDiensteMaDay() : mixed
- getIdsDienst() : mixed
- is_dienst_overlapping() : mixed
- save_new_Dienst() : mixed
- save_VG_dienst() : mixed
- selDelFurtherEntriesMa() : mysqli_num_rows
- check or delete all all future entries for given employee
- update_VG_dienst_Daten() : mixed
- updateVgImage() : mixed
Methods
checkRelationsDienst()
check relations bevor deleting dienst with del=1 on tables tp_event, tp_visit and tp_visitDays
public
checkRelationsDienst(int $idDienst, date $dateCheck, int $mod_tourenplan) : array<string|int, mixed>
Parameters
- $idDienst : int
-
id of selected dienst, ref to id of table dp_vorgaben
- $dateCheck : date
-
startdate of check, format YYYY-mm-dd
- $mod_tourenplan : int
-
check if modul tourenplan is activated
Return values
array<string|int, mixed> —$foundEntries
number of mysqli_num_rows on affected data
del_Dienst()
public
del_Dienst(mixed $id_dienst) : mixed
Parameters
- $id_dienst : mixed
del_MA_Dienst()
public
del_MA_Dienst(mixed $id_tag, mixed $id_ma) : mixed
Parameters
- $id_tag : mixed
- $id_ma : mixed
del_MA_dienst_byWeekDay()
public
del_MA_dienst_byWeekDay(mixed $id_ma, mixed $id_bereich, mixed $id_dienst, mixed $wd) : mixed
Parameters
- $id_ma : mixed
- $id_bereich : mixed
- $id_dienst : mixed
- $wd : mixed
del_VG_dienst_Daten()
set del = 1 in table dp_vorgaben for given id
public
del_VG_dienst_Daten(int $id) : mixed
Parameters
- $id : int
-
id of setting dienst in table dp_vorgaben
delTageMaByDienst()
public
delTageMaByDienst(mixed $month, mixed $year, mixed $selMa) : mixed
Parameters
- $month : mixed
- $year : mixed
- $selMa : mixed
get_All_Bereiche_nachMA_Aktiv_kurz()
public
get_All_Bereiche_nachMA_Aktiv_kurz() : mixed
get_All_MA_Aktiv()
get all employee data with given parameters
public
get_All_MA_Aktiv([int $idBereich = null ][, int $idMa = null ][, int $month = null ][, int $year = null ][, int $planned = 0 ]) : mysqli_query
Parameters
- $idBereich : int = null
-
default null - if > 0 select by bereich
- $idMa : int = null
-
default null - if > 0 select by id of owner (employee)
- $month : int = null
-
default null - if > 0 select by v_begin (begin contract)
- $year : int = null
-
default null - if > 0 select by v_begin (begin of contract)
- $planned : int = 0
-
default 0: get only employee with mod_dp > 0 - if 1: get all planned employee
Return values
mysqli_query —result-set
get_All_MA_Aktiv_kurz()
public
get_All_MA_Aktiv_kurz() : mixed
get_All_VG()
public
get_All_VG([int $blocking = null ][, int $tourenplan = null ][, int $sortOrder = null ][, int $idDienst = null ]) : mixed
Parameters
- $blocking : int = null
-
null = do not filter, 0 = no blocking, 1 = all who are blocking other dienste
- $tourenplan : int = null
-
null = do not filter, 0 = wihtout tour, 1 = with tour
- $sortOrder : int = null
-
null = do not filter, 1 = first Order BY tour, 2 order by von in table dp_vorgaben
- $idDienst : int = null
-
null = do not filter, > 0 get entry wiht id = $idDIenst from dp_vorgaben
get_All_VG_Schicht()
public
get_All_VG_Schicht() : mixed
get_bereichDIenst_byIDD()
get all data from table ma_vg_bereich by id
public
get_bereichDIenst_byIDD(int $idBereich) : mixed
Parameters
- $idBereich : int
-
idBereich from table dp_vorgaben
get_Bereiche_MA()
public
get_Bereiche_MA([mixed $id_ma = null ]) : mixed
Parameters
- $id_ma : mixed = null
get_Besuche_ByDate_Dienst()
public
get_Besuche_ByDate_Dienst(mixed $id_dienst, mixed $date) : mixed
Parameters
- $id_dienst : mixed
- $date : mixed
get_Dienst_byID()
public
get_Dienst_byID(mixed $id_dienst) : mixed
Parameters
- $id_dienst : mixed
get_dienstByMonthYearMA()
returns all dienste of an employee in selected month / year
public
get_dienstByMonthYearMA(int $month, int $year, int $id_ma) : mysqli_result
Parameters
- $month : int
-
format mm
- $year : int
-
format yyyy
- $id_ma : int
-
ref to id in table owner
Return values
mysqli_result —all relevant data
get_dienste_ByKwJahr()
public
get_dienste_ByKwJahr(mixed $kw, mixed $jahr[, mixed $id_vg_dienst = null ]) : mixed
Parameters
- $kw : mixed
- $jahr : mixed
- $id_vg_dienst : mixed = null
get_SumAZ_ByID_DP_Schicht()
public
get_SumAZ_ByID_DP_Schicht(mixed $kw, mixed $jahr, mixed $id_ma) : mixed
Parameters
- $kw : mixed
- $jahr : mixed
- $id_ma : mixed
get_Tage_ByID_DP_Dienst()
public
get_Tage_ByID_DP_Dienst(mixed $id_dienst) : mixed
Parameters
- $id_dienst : mixed
get_VG_ByID()
public
get_VG_ByID(int $id) : mixed
Parameters
- $id : int
-
id of table dp_vorgaben
getAllDiensteMaDay()
public
getAllDiensteMaDay(int $idMa, int $day, int $kw, int $jahr[, int $tour = 0 ]) : mixed
Parameters
- $idMa : int
- $day : int
-
as one number 0 - 6 for mo - so german weekday
- $kw : int
- $jahr : int
- $tour : int = 0
getIdsDienst()
public
getIdsDienst(mixed $month, mixed $year) : mixed
Parameters
- $month : mixed
- $year : mixed
is_dienst_overlapping()
public
is_dienst_overlapping(mixed $id_ma, mixed $kw, mixed $year, string $day, mixed $von, mixed $bis) : mixed
Parameters
- $id_ma : mixed
- $kw : mixed
- $year : mixed
- $day : string
-
as two character german weekday
- $von : mixed
- $bis : mixed
save_new_Dienst()
public
save_new_Dienst(mixed $kw, mixed $jahr, mixed $id_vg_dienst, mixed $id_owner) : mixed
Parameters
- $kw : mixed
- $jahr : mixed
- $id_vg_dienst : mixed
- $id_owner : mixed
save_VG_dienst()
public
save_VG_dienst(mixed $name, mixed $kuerzel, mixed $von, mixed $bis, mixed $arbeitszeit, mixed $pause, mixed $art_pause, mixed $tourenplan, mixed $blocking, mixed $days_planning, mixed $driving_time, mixed $anzMa, mixed $idBereich) : mixed
Parameters
- $name : mixed
- $kuerzel : mixed
- $von : mixed
- $bis : mixed
- $arbeitszeit : mixed
- $pause : mixed
- $art_pause : mixed
- $tourenplan : mixed
- $blocking : mixed
- $days_planning : mixed
- $driving_time : mixed
- $anzMa : mixed
- $idBereich : mixed
selDelFurtherEntriesMa()
check or delete all all future entries for given employee
public
selDelFurtherEntriesMa(int $cw, int $year, int $id_ma, int $type) : mysqli_num_rows
Parameters
- $cw : int
-
first calendar-week
- $year : int
-
start year - format yyyy
- $id_ma : int
-
ref to id in table owner
- $type : int
-
$type=1 : select all entries - $type=2 : delete all entries
Return values
mysqli_num_rows —for select or mysqli_affected_rows after deleting
update_VG_dienst_Daten()
public
update_VG_dienst_Daten(mixed $id, mixed $name, mixed $kuerzel, mixed $von, mixed $bis, mixed $arbeitszeit, mixed $pause, mixed $art_pause, mixed $tourenplan, mixed $blocking, mixed $days_planning, mixed $driving_time, mixed $anzMa, mixed $idBereich, mixed $check_assignment) : mixed
Parameters
- $id : mixed
- $name : mixed
- $kuerzel : mixed
- $von : mixed
- $bis : mixed
- $arbeitszeit : mixed
- $pause : mixed
- $art_pause : mixed
- $tourenplan : mixed
- $blocking : mixed
- $days_planning : mixed
- $driving_time : mixed
- $anzMa : mixed
- $idBereich : mixed
- $check_assignment : mixed
updateVgImage()
public
updateVgImage(mixed $id, mixed $bild) : mixed
Parameters
- $id : mixed
- $bild : mixed