function get_confidential_time_entry_elements($func_args)
{
foreach ($func_args as $key => $value) {
${$key} = $value;
}
$week_dates = week_dates($date, $format = 'm/d/Y');
foreach ($week_dates as $day => $date) {
$row_count = count($date_data[date("Y-m-d", strtotime($date))]);
echo '<ul data-role="listview" data-inset="true" class="confidential-time-entry" >';
echo '<li data-role="list-divider">' . $day . '<span class="ui-li-count">' . $date . '</span></li>';
echo '<li class="' . $day . '-li">';
echo '<a href="#" class="ui-btn ui-icon-plus ui-btn-icon-right add-time" date="' . date("Y-m-d", strtotime($date)) . '" day="' . $day . '" row-count="' . $row_count . '" >Add Time</a><br style="clear:both;" />';
for ($row_num = 0; $row_num < $row_count; $row_num++) {
$func_args = array("day" => $day, "row_num" => $row_num, "date" => date("Y-m-d", strtotime($date)), "date_data" => $date_data[date("Y-m-d", strtotime($date))][$row_num], "is_signed" => $date_data[date("Y-m-d", strtotime($date))][$row_num]['is_signed']);
get_confidential_time_entry_row($func_args);
}
echo '</li>';
echo '</ul>';
}
}
if ($dateJour == $nbJour) {
$dateJour = 1;
if ($dateMois == 12) {
$dateMois = 1;
$dateAnnee++;
} else {
$dateMois++;
}
} else {
$dateJour++;
}
}
$temps = mktime(0, 0, 0, $dateMois, $dateJour, $dateAnnee);
/*********************/
$typeRepas = array('MIDI', 'SOIR');
$lundiSemaine = week_dates(strftime("%U", $temps), date('Y', $temps));
$requete = new requete();
$requete->select('regime', 'r');
// echo $requete->requete_complete().'<br><br>';
$requete->executer_requete();
$liste = $requete->resultat;
$erreur = array_merge($erreur, $requete->liste_erreurs);
unset($requete);
if ($liste) {
$retour['resultat'] = '<table><caption>Menus - SEMAINE n°' . strftime("%U", $temps) . ' du ' . date('d/m/Y', $lundiSemaine) . ' au ' . date('d/m/Y', strtotime("+6 day", $lundiSemaine)) . '</caption>';
$thead = '<tr><th colspan="2"> </th>';
foreach ($liste as $regime) {
$regime['couleur'] = empty($regime['couleur']) ? 'FFFFFF' : $regime['couleur'];
$thead .= '<th style="background-color:#' . $regime['couleur'] . ';color:#' . couleur_inverse($regime['couleur']) . ';">' . $regime['nom'] . '</th>';
}
$thead .= '</tr>';
$dateJour++;
}
}
$temps = mktime(0, 0, 0, $dateMois, $dateJour, $dateAnnee);
/*********************/
$requete = new requete();
$requete->select('regime', 'r');
$requete->where(array('r' => array('nom' => 'NORMAL')));
// echo $requete->requete_complete().'<br><br>';
$requete->executer_requete();
$liste = $requete->resultat;
$erreur = array_merge($erreur, $requete->liste_erreurs);
unset($requete);
if ($liste) {
$typeRepas = array('MIDI', 'SOIR');
$temp = week_dates(strftime("%U"), date('Y'));
$retour['resultat'] = '';
foreach ($liste as $regime) {
$lundiSemaine = $temp;
$retour['resultat'] .= '<table><caption>Menus ' . $regime['nom'] . ' - SEMAINE n°' . strftime("%U") . ' du ' . date('d/m/Y', $lundiSemaine) . ' au ' . date('d/m/Y', strtotime("+6 day", $lundiSemaine)) . '</caption><thead><tr><th>LUNDI</th><th>MARDI</th><th>MERCREDI</th><th>JEUDI</th><th>VENDREDI</th><th>SAMEDI</th><th>DIMANCHE</th></tr></thead><tbody>';
foreach ($typeRepas as $type) {
$retour['resultat'] .= '<tr><th colspan="7">' . $type . '</th></tr><tr>';
for ($i = 0; $i < 7; $i++) {
$timestampJour = $lundiSemaine + $i * 86400;
$requete = new requete();
$requete->select(array('calendrier' => 'id'), 'c');
$requete->where(array('c' => array('jour' => date('d', $timestampJour), 'mois' => date('m', $timestampJour), 'annee' => date('Y', $timestampJour), 'typeCalendrier' => $type)));
// echo $requete->requete_complete().'<br><br>';
$requete->grand_tableau = false;
$requete->executer_requete();
$result = $requete->resultat;
$numSemaine = strftime("%U", $temps);
// $numSemaine = date("W", $temps);
$menuSeul = isset($_REQUEST['menuSeul']) ? true : false;
$nbTotal = array();
$requete = new requete();
$requete->select('regime', 'r');
$requete->where(array('r' => array('nom' => 'REMPLACEMENT')));
$requete->executer_requete();
$liste = $requete->resultat;
$tempRegime[$liste[0]['id']] = 0;
foreach ($_GET as $reg => $val) {
if (substr($reg, 0, 4) == 'reg_' && $val > 0) {
$tempRegime[substr($reg, 4)] = $val;
}
}
$temp = week_dates($numSemaine, $dateAnnee);
foreach ($tempRegime as $reg => $val) {
$requete = new requete();
$requete->select('regime', 'r');
$requete->where(array('r' => array('id' => $reg)));
// echo $requete->requete_complete().'<br><br>';
$requete->executer_requete();
$liste = $requete->resultat;
$typeRepas = array('MIDI', 'SOIR');
$retour['resultat'] = '';
foreach ($liste as $regime) {
$lundiSemaine = $temp;
$tabRegime[$regime['nom']] = array('id' => $regime['id'], 'nom' => $regime['nom'], 'nomComplet' => $regime['nomComplet']);
foreach ($typeRepas as $type) {
for ($i = 0; $i < 7; $i++) {
$timestampJour = $lundiSemaine + $i * 86400;
public function get_inactiveemployeesreport($date)
{
$format = 'Y-m-d';
$date_range = x_week_range($date, $format);
$week_days = week_dates($date, $format);
// Get union data
$this->get_union_data();
include 'db.config.php';
$mysqli = new mysqli($operations_dbhost, $operations_dbuser, $operations_dbpass, $operations_dbname);
// check connection
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit;
}
// Employees with time entries for the specified week
$query = '
SELECT distinct id, employee_code, firstname, lastname FROM ' . $system_dbname . '.vwEmployeesAndTimeEntries
WHERE (
((date >= "' . $date_range[0] . '") and (date <= "' . $date_range[1] . '"))
and (NOT isnull(hours) and (hours > "0" ))
and (disabled = "N"))
order by employee_code
';
$result = $mysqli->query($query);
while ($row_data = $result->fetch_assoc()) {
$employees_with_time[] = $row_data;
$employees_with_time_id[] = $row_data['id'];
}
// All employees
$query = '
SELECT distinct id, employee_code, code, firstname, lastname, title, union_code, issalaried FROM ' . $system_dbname . '.user
WHERE disabled = "N"
AND employee_code > "0"
';
$result = $mysqli->query($query);
while ($row_data = $result->fetch_assoc()) {
$employees[] = $row_data;
$employees_ids[] = $row_data['id'];
}
foreach ($employees_ids as $key => $employee_id) {
foreach ($employees_with_time_id as $employee_with_time) {
if ($employee_with_time == $employee_id) {
unset($employees[$key]);
}
}
}
$report .= '<div class="report-wrapper" ><span><strong>Weekly Inactive Employees</strong><br />
</span><span><strong>Pay Period: ' . $date_range[0] . ' - ' . $date_range[1] . '</strong></span>';
$report .= '<table cellspacing="5" cellpadding="0" >';
$report .= '<thead><tr>';
$report .= '<th>Emp #</th>';
$report .= '<th>Code</th>';
$report .= '<th>Emp Name</th>';
$report .= '<th>Title</th>';
$report .= '<th>Union</th>';
$report .= '<th>Salaried</th>';
$report .= '</tr></thead>';
foreach ($employees as $employee) {
$employee['union_code'] = $employee['union_code'] != 0 || $employee['union_code'] == NULL ? substr($employee['union_code'], 0, 3) : "";
// Report Line Items
$report .= '<tr>';
$report .= '<td>' . $employee['employee_code'] . '</td>';
$report .= '<td>' . $employee['code'] . '</td>';
$report .= '<td style="white-space:nowrap;">';
$report .= $this->get_user_role() < 2 ? '<a href="employees.php?id=' . $employee['id'] . '" target="_blank" >' . ucwords(strtolower(trim($employee['firstname'] . ' ' . $employee['lastname']))) . '</a>' : '<strong>' . ucwords(strtolower(trim($employee['firstname'] . ' ' . $employee['lastname']))) . '</strong>';
$report .= '</td>';
$report .= '<td style="white-space:nowrap;">' . $employee['title'] . '</td>';
$report .= '<td>' . substr($employee['union_code'], 0, 3) . '</td>';
$report .= '<td>' . $employee['issalaried'] . '</td>';
$report .= '</tr>';
}
$report .= '</table></div>';
$mysqli->close();
return $report;
}
