public static function hours_fit_in_calculated_amount($projects_id, $activity_amount, $selected_date) { $database = $_SESSION['database']; $project_query = $database->query("SELECT projects_calculated_hours," . "(SELECT IFNULL(SUM(activities_amount),0) " . "FROM " . TABLE_ACTIVITIES . " " . "LEFT JOIN (" . TABLE_TIMESHEETS . "," . TABLE_TARIFFS . "," . TABLE_EMPLOYEES_ROLES . "," . TABLE_ROLES . ") " . "ON (" . TABLE_ACTIVITIES . ".timesheets_id=" . TABLE_TIMESHEETS . ".timesheets_id " . "AND " . TABLE_ACTIVITIES . ".tariffs_id=" . TABLE_TARIFFS . ".tariffs_id " . "AND " . TABLE_TARIFFS . ".employees_roles_id=" . TABLE_EMPLOYEES_ROLES . ".employees_roles_id " . "AND " . TABLE_EMPLOYEES_ROLES . ".roles_id=" . TABLE_ROLES . ".roles_id) " . "WHERE " . TABLE_TIMESHEETS . ".timesheets_start_date<='" . tep_strftime(DATE_FORMAT_DATABASE, $selected_date) . "' " . "AND " . TABLE_TIMESHEETS . ".timesheets_end_date>='" . tep_strftime(DATE_FORMAT_DATABASE, $selected_date) . "' " . "AND " . TABLE_ROLES . ".projects_id=" . TABLE_PROJECTS . ".projects_id) AS projects_calculated_hours_used " . "FROM " . TABLE_PROJECTS . " " . "WHERE projects_id=" . $projects_id . " " . "AND (projects_calculated_hours=0 " . "OR (projects_calculated_hours>0 " . "AND projects_calculated_hours_period='B')) " . "UNION " . "SELECT projects_calculated_hours," . "(SELECT IFNULL(SUM(activities_amount),0) " . "FROM " . TABLE_ACTIVITIES . " " . "LEFT JOIN (" . TABLE_TARIFFS . "," . TABLE_EMPLOYEES_ROLES . "," . TABLE_ROLES . ") " . "ON (" . TABLE_ACTIVITIES . ".tariffs_id=" . TABLE_TARIFFS . ".tariffs_id " . "AND " . TABLE_TARIFFS . ".employees_roles_id=" . TABLE_EMPLOYEES_ROLES . ".employees_roles_id " . "AND " . TABLE_EMPLOYEES_ROLES . ".roles_id=" . TABLE_ROLES . ".roles_id) " . "WHERE " . TABLE_ROLES . ".projects_id=" . TABLE_PROJECTS . ".projects_id) " . "FROM " . TABLE_PROJECTS . " " . "WHERE projects_id=" . $projects_id . " " . "AND projects_calculated_hours>0 " . "AND projects_calculated_hours_period='E' "); $project_result = $database->fetch_array($project_query); if (tep_not_null($project_result) && ($project_result['projects_calculated_hours'] == 0 || round($project_result['projects_calculated_hours'] - $project_result['projects_calculated_hours_used'] - $activity_amount, 2) >= 0)) { return true; } else { return false; } }
for ($index = 0; $index < sizeof($_SESSION['employee_role']->listing); $index++) { ?> <tr class="entryListing-<?php echo $odd_or_even; ?> " style="vertical-align:top"> <td class="entryListing-data"><?php echo $_SESSION['employee_role']->listing[$index]->role->name; ?> </td> <td class="entryListing-data"><?php echo $_SESSION['employee_role']->listing[$index]->employee->fullname; ?> </td> <td class="entryListing-data"><?php echo tep_strftime(DATE_FORMAT_SHORT, $_SESSION['employee_role']->listing[$index]->start_date) . '<br>' . ($_SESSION['employee_role']->listing[$index]->end_date != 0 ? tep_strftime(DATE_FORMAT_SHORT, $_SESSION['employee_role']->listing[$index]->end_date) : '∞'); ?> </td> <td class="entryListing-data" style="width:20px;text-align:center"> <?php echo tep_draw_form('edit_entry', tep_href_link(FILENAME_ADMINISTRATION_EMPLOYEES_ROLES)) . tep_create_parameters(array('action' => 'enter_data', 'employees_roles_id' => $_SESSION['employee_role']->listing[$index]->id, 'roles_id' => $_SESSION['employee_role']->listing[$index]->role->id, 'employees_id' => $_SESSION['employee_role']->listing[$index]->employee->id, 'employees_roles_start_date' => $_SESSION['employee_role']->listing[$index]->start_date, 'employees_roles_end_date' => $_SESSION['employee_role']->listing[$index]->end_date), array('mPath', 'projects_id'), 'hidden_field'); echo tep_image_submit('edit.gif', TEXT_ENTRY_EDIT, '', DIR_WS_IMAGES); echo '</form>'; ?> </td> <td class="entryListing-data" style="width:20px;text-align:center"> <?php echo tep_draw_form('delete_entry', tep_href_link(FILENAME_ADMINISTRATION_EMPLOYEES_ROLES)) . tep_create_parameters(array('action' => 'delete_entry', 'employees_roles_id' => $_SESSION['employee_role']->listing[$index]->id, 'roles_id' => $_SESSION['employee_role']->listing[$index]->role->id, 'employees_id' => $_SESSION['employee_role']->listing[$index]->employee->id, 'employees_roles_start_date' => $_SESSION['employee_role']->listing[$index]->start_date, 'employees_roles_end_date' => $_SESSION['employee_role']->listing[$index]->end_date), array('mPath', 'projects_id'), 'hidden_field'); echo tep_image_submit('delete.gif', TEXT_ENTRY_DELETE, '', DIR_WS_IMAGES); echo '</form>'; ?>
$projects_calculated_hours_used_percentage = $project_array[$index]['projects_calculated_hours'] != 0 ? round($project_array[$index]['projects_calculated_hours_used'] / $project_array[$index]['projects_calculated_hours'] * 100) . '%' : BODY_TEXT_NOT_APPLICABLE; ?> <tr class="projectListing-<?php echo $projects_calculated_hours_used_percentage >= 100 ? 'red' : ($projects_calculated_hours_used_percentage >= 75 ? 'orange' : 'green'); ?> "> <td class="projectListing-data"><?php echo $project_array[$index]['projects_name']; ?> </td> <td class="projectListing-data"><?php echo tep_strftime(DATE_FORMAT_SHORT, tep_datetouts('%Y-%m-%d', $project_array[$index]['projects_start_date'])); ?> </td> <td class="projectListing-data"><?php echo $project_array[$index]['projects_end_date'] != '2099-12-31' ? tep_strftime(DATE_FORMAT_SHORT, tep_datetouts('%Y-%m-%d', $project_array[$index]['projects_end_date'])) : BODY_TEXT_NOT_APPLICABLE; ?> </td> <td class="projectListing-data"><?php echo $project_array[$index]['projects_calculated_hours'] != 0 ? $project_array[$index]['projects_calculated_hours'] : BODY_TEXT_NOT_APPLICABLE; ?> </td> <td class="projectListing-data"><?php echo $project_array[$index]['projects_calculated_hours'] != 0 ? $PROJECTS_CALCULATED_HOURS_PERIOD[$project_array[$index]['projects_calculated_hours_period']] : BODY_TEXT_NOT_APPLICABLE; ?> </td> <td class="projectListing-data"><?php echo tep_number_db_to_user($project_array[$index]['projects_calculated_hours_used'], 2); ?> </td> <td class="projectListing-data"><?php
$periodstartdate = $database->prepare_input(tep_periodstartdate($_POST['period'])); $employees_query_string = 'SELECT ts.timesheets_start_date, ts.timesheets_end_date, cus.customers_id, cus.customers_name, cus.customers_billing_show_logo, bu.business_units_image, bu.business_units_image_position, pr.projects_id, pr.projects_name, rl.roles_id, rl.roles_name, rl.roles_mandatory_ticket_entry, act.activities_date, emp.employees_id, emp.employees_fullname, act.activities_amount, units.units_id, units.units_name, tar.tariffs_amount, act.activities_travel_distance, act.activities_expenses, act.activities_ticket_number, act.activities_expenses + (act.activities_amount * tar.tariffs_amount) AS total, act.activities_comment ' . 'FROM ' . TABLE_TIMESHEETS . ' AS ts ' . 'INNER JOIN (' . TABLE_EMPLOYEES . ' AS emp, ' . TABLE_ACTIVITIES . ' AS act, ' . TABLE_UNITS . ', ' . TABLE_TARIFFS . ' AS tar, ' . TABLE_EMPLOYEES_ROLES . ' AS er, ' . TABLE_ROLES . ' AS rl, ' . TABLE_PROJECTS . ' AS pr, ' . TABLE_CUSTOMERS . ' AS cus, ' . TABLE_BUSINESS_UNITS . ' AS bu) ' . 'ON (ts.employees_id = emp.employees_id ' . 'AND act.timesheets_id = ts.timesheets_id ' . 'AND act.tariffs_id = tar.tariffs_id ' . 'AND units.units_id = tar.units_id ' . 'AND er.employees_roles_id = tar.employees_roles_id ' . 'AND rl.roles_id = er.roles_id ' . 'AND pr.projects_id = rl.projects_id ' . 'AND cus.customers_id = pr.customers_id ' . 'AND bu.business_units_id = pr.business_units_id) ' . 'WHERE ts.timesheets_start_date = "' . $periodstartdate . '" ' . 'ORDER BY emp.employees_id, act.activities_date, cus.customers_id, pr.projects_id, rl.roles_id, units.units_id'; $employees_query = $database->query($employees_query_string); $employees_array = array(); $employees_id = ''; $table_header_set = false; while ($employees_result = $database->fetch_array($employees_query)) { if ($employees_id != $employees_result['employees_id']) { $employees_id = $employees_result['employees_id']; if ($table_header_set) { // A previous table exists, create a footer for that one $pdf->ConsolidatedProjectsTableFooter($total_amount, $total_value, $total_travel_distance, $total_expenses); $pdf->AddPage(); } // Create a new Employee header $pdf->ConsolidatedProjectsHeader(tep_strftime(DATE_FORMAT_SHORT, tep_datetouts('%Y-%m-%d', $employees_result['timesheets_start_date'])) . ' - ' . tep_strftime(DATE_FORMAT_SHORT, tep_datetouts('%Y-%m-%d', $employees_result['timesheets_end_date'])), '(' . $employees_result['employees_id'] . ') ' . $employees_result['employees_fullname']); // Create a new table header $pdf->ConsolidatedProjectsTableHeader(); $table_header_set = true; $total_amount = 0.0; $total_value = 0.0; $total_travel_distance = 0; $total_expenses = 0.0; } // And we're off creating the table contents $pdf->ConsolidatedProjectsTableContents(tep_datetouts('%Y-%m-%d', $employees_result['activities_date']), $employees_result['projects_name'], $employees_result['roles_name'], $employees_result['activities_amount'], $employees_result['units_name'], $employees_result['tariffs_amount'], $employees_result['total'], $employees_result['activities_travel_distance'], $employees_result['activities_expenses'], $employees_result['activities_ticket_number'], $employees_result['activities_comment']); $total_amount += $employees_result['activities_amount']; $total_value += $employees_result['total']; $total_travel_distance += $employees_result['activities_travel_distance']; $total_expenses += $employees_result['activities_expenses']; }
public function ConsolidatedProjectsTableContents($date, $project_name, $role_name, $activity_amount, $units_name, $tariff = 0.0, $total_value = 0.0, $travel_distance = 0, $expenses = 0.0, $ticket_number = '', $comment = '') { $this->SetFont('Arial', '', 10); $this->Cell(20, 5, tep_strftime(DATE_FORMAT_SHORT, $date), 0, 0, 'C'); $tempX = $this->GetX(); $tempY = $this->GetY(); $this->MultiCell(50, 5, $project_name . "\n" . $role_name, 0, 'L'); $tempX += 50; $tempYMax = $this->GetY(); $this->SetXY($tempX, $tempY); $this->Cell(15, 5, tep_number_db_to_user($activity_amount, 2), 0, 0, 'R'); $this->MultiCell(39, 5, $units_name, 0, 'L'); $tempX += 54; if ($this->GetY() > $tempYMax) { $tempYMax = $this->GetY(); } $this->SetXY($tempX, $tempY); if ($this->show_tariff) { $this->Cell(15, 5, tep_number_db_to_user($tariff, 2), 0, 0, 'R'); $this->Cell(22, 5, tep_number_db_to_user($total_value, 2), 0, 0, 'R'); } if ($this->show_travel_distance) { $this->Cell(15, 5, $travel_distance, 0, 0, 'R'); } if ($this->show_expenses) { $this->Cell(22, 5, tep_number_db_to_user($expenses, 2), 0, 0, 'R'); } if ($this->show_ticket_number) { $this->Cell(22, 5, $ticket_number, 0, 0, 'C'); } if ($this->show_comment) { $this->MultiCell(0, 5, $comment); } if ($this->GetY() < $tempYMax) { $this->SetY($tempYMax); } //$this->Ln(); }
public static function get_former_activity_id($employee_id, $selected_date = null) { $db_date = tep_strftime(DATE_FORMAT_DATABASE, $selected_date); $database = $_SESSION['database']; $activity_query = $database->query("SELECT a.activities_id, " . "a.tariffs_id " . "FROM " . TABLE_ACTIVITIES . " AS a, " . TABLE_TIMESHEETS . " AS t " . "WHERE a.timesheets_id = t.timesheets_id " . "AND t.employees_id = '" . $employee_id . "' " . "AND a.activities_date < '" . $db_date . "' " . "ORDER BY a.activities_date DESC, a.activities_id DESC;"); $activity_result = $database->fetch_array($activity_query); if (tep_not_null($activity_result)) { // There is a resultset, keep the activity_id for now and // check if the activity is valid for the given employee and date $former_activity_id = $activity_result['activities_id']; $tariffs_id = $activity_result['tariffs_id']; // The complicated way: check the entire tree for validation /* $activity_query = $database->query("SELECT 1" . " FROM " . TABLE_PROJECTS . " AS p, " . TABLE_ROLES . " AS r, " . TABLE_EMPLOYEES_ROLES . " AS er, " . TABLE_TARIFFS . " AS t" . " WHERE p.projects_id = r.projects_id" . " AND r.roles_id = er.roles_id" . " AND er.employees_roles_id = t.employees_roles_id" . " AND er.employees_id = '" . $employee_id . "'" . " AND t.tariffs_id = '" . $tariffs_id . "'" . " AND p.projects_start_date <= '" . $db_date . "'" . " AND p.projects_end_date >= '" . $db_date . "'" . " AND er.employees_roles_start_date <= '" . $db_date . "'" . " AND er.employees_roles_end_date >= '" . $db_date . "'" . " AND t.tariffs_start_date <= '" . $db_date . "'" . " AND t.tariffs_end_date >= '" . $db_date . "'"); */ // The easy way: just validate against the obtained tariffs_id $activity_query = $database->query("SELECT 1 " . "FROM " . TABLE_TARIFFS . " AS t " . "WHERE t.tariffs_id = '" . $tariffs_id . "' " . "AND t.tariffs_start_date <= '" . $db_date . "' " . "AND t.tariffs_end_date >= '" . $db_date . "';"); $activity_result = $database->fetch_array($activity_query); if (tep_not_null($activity_result)) { // Activity is valid for given employee and date return $former_activity_id; } else { // Activity is not valid for given employee and date return -1; } } else { // No former activity exists return 0; } }
<td align="right" class="infoBoxHeading"> <?php echo tep_image_submit('arrow_right.gif', TEXT_TIMEREGISTRATION_FORWARD, '', DIR_WS_IMAGES); ?> </td> </form> </tr> </table> </td> </tr> <tr> <td align="center"> <table border="0px" width="20%" cellspacing="0" cellpadding="3" class="infoBoxContents"> <tr> <td align="center" class="boxText"><?php echo tep_strftime(DATE_FORMAT_SHORT, tep_datetouts('%Y-%m-%d', $_SESSION['timesheet']->start_date)) . ' - ' . tep_strftime(DATE_FORMAT_SHORT, tep_datetouts('%Y-%m-%d', $_SESSION['timesheet']->end_date)); ?> </td> </tr> </table> </td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '20'); ?> </td> </tr> <tr> <td align="center" class="main"><?php echo TEXT_TIMEREGISTRATION_CALENDAR_DESCRIPTION;
public function has_duplicates($start_date, $end_date, $roles_id, $employees_id) { $database = $_SESSION['database']; $duplicates_query = $database->query("select 1 from " . TABLE_EMPLOYEES_ROLES . " where employees_roles_id != " . (tep_not_null($this->id) ? $this->id : 0) . " and roles_id = " . $roles_id . " and employees_id = " . $employees_id . " and employees_roles_start_date <= '" . ($end_date != 0 ? tep_strftime(DATE_FORMAT_DATABASE, $end_date) : '2099-12-31') . "'" . " and employees_roles_end_date >= '" . tep_strftime(DATE_FORMAT_DATABASE, $start_date) . "'"); $duplicates_result = $database->fetch_array($duplicates_query); return tep_not_null($duplicates_result); }
<td align="right" class="infoBoxHeading"> <?php echo tep_image_submit('arrow_right.gif', TEXT_ANALYSIS_FORWARD, '', DIR_WS_IMAGES); ?> </td> </form> </tr> </table> </td> </tr> <tr> <td align="center"> <table border="0px" width="20%" cellspacing="0" cellpadding="3" class="infoBoxContents"> <tr> <td align="center" class="boxText"><?php echo tep_strftime(DATE_FORMAT_SHORT, tep_datetouts('%Y-%m-%d', tep_periodstartdate($_POST['period']))) . ' - ' . tep_strftime(DATE_FORMAT_SHORT, tep_datetouts('%Y-%m-%d', tep_periodenddate($_POST['period']))); ?> </td> </tr> </table> </td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '20'); ?> </td> </tr> <tr> <td> <table border="0" cellspacing="0" cellpadding="0">
?> </td> </tr> <tr> <td width="50%" class="item_entry"><?php echo TEXT_ACTIVITY_TICKETNUMBER; ?> </td> <td colspan="2" width="50%" class="item_entry"><?php echo tep_draw_input_field('activity_ticket_number', '', 'size="1" maxlength="16" style="width: 100%"' . ($_POST['action'] == 'enter_data' || $_POST['action'] == 'save_data' ? '' : ' disabled')); ?> </td> <td width="22px" class="item_entry"> <?php if (ENABLE_TICKET_DATABASE_LOOKUPS && ($_POST['action'] == 'enter_data' || $_POST['action'] == 'save_data')) { echo tep_image_button('button_lookup.gif', TEXT_ACTIVITY_TICKETNUMBER_LOOKUP, 'onClick="fetchTicketNrAndDescription(\'' . tep_strftime('%Y-%m-%d', $_POST['selected_date']) . '\');"'); //echo tep_image(DIR_WS_LANGUAGES . $_SESSION['language'] . '/images/buttons/button_lookup.gif', '', '', '', 'onClick="fetchTicketNrAndDescription(\'' . tep_strftime('%Y-%m-%d', $_POST['selected_date']) . '\');"'); } else { echo tep_image(DIR_WS_LANGUAGES . $_SESSION['language'] . '/images/buttons/button_lookup_disabled.gif'); } ?> </td> </tr> </table> </td> </tr> <tr> <td class="item_entry"> <?php echo TEXT_ACTIVITY_COMMENT; ?>
public function save() { $database = $_SESSION['database']; // Insert a new benefit if one does not exist and retrieve the id if ($this->id == 0) { // The benefit does not exist $database->query("insert into " . TABLE_BENEFITS . " (benefits_start_date, benefits_end_date, benefits_credit, benefits_granted, benefits_comment, employees_id, roles_id) values ('" . tep_strftime(DATE_FORMAT_DATABASE, $this->start_date) . "', '" . ($this->end_date != 0 ? tep_strftime(DATE_FORMAT_DATABASE, $this->end_date) : '2099-12-31') . "', '" . $this->credit . "', '" . $this->granted . "', '" . $this->comment . "', '" . $this->employee->id . "', '" . $this->role->id . "')"); $this->id = $database->insert_id(); // The proper id is now known } else { // The benefit exists, update the contents $this->id = $database->prepare_input($this->id); $benefit_query = $database->query("update " . TABLE_BENEFITS . " set benefits_start_date='" . tep_strftime(DATE_FORMAT_DATABASE, $this->start_date) . "', benefits_end_date='" . ($this->end_date != 0 ? tep_strftime(DATE_FORMAT_DATABASE, $this->end_date) : '2099-12-31') . "', benefits_credit='" . $this->credit . "', benefits_granted='" . $this->granted . "', benefits_comment='" . $this->comment . "', employees_id='" . $this->employee->id . "', roles_id='" . $this->role->id . "' where benefits_id = '" . (int) $this->id . "'"); } }
require 'includes/application_top.php'; // CSV class require DIR_WS_CLASSES . 'csv.php'; // Check if user is logged in. If not, redirect to login page if (!tep_not_null($_SESSION['employee'])) { tep_redirect(tep_href_link(FILENAME_LOGIN)); } // Check if the user is allowed to view this page if (!$_SESSION['employee']->profile->right['analysis']) { tep_redirect(tep_href_link(FILENAME_DEFAULT)); } // Create a CSV object $csv = new CSV($_POST['action'] . '.csv', ';', ''); // Delimiters chosen to be ms-excel compatible switch ($_POST['action']) { case 'export_activities': $database = $_SESSION['database']; $periodstartdate = $database->prepare_input(tep_periodstartdate($_POST['period'])); $activities_query_string = 'SELECT cus.customers_id, cus.customers_name, cus.customers_id_external, ts.timesheets_start_date, ts.timesheets_end_date, pr.projects_name, bu.business_units_name, rl.roles_name, cat.categories_name, act.activities_date, emp.employees_id, emp.employees_fullname, act.activities_amount, units.units_name, tar.tariffs_amount, act.activities_travel_distance, act.activities_expenses, act.activities_ticket_number, act.activities_comment ' . 'FROM ' . TABLE_TIMESHEETS . ' AS ts ' . 'INNER JOIN (' . TABLE_EMPLOYEES . ' AS emp, ' . TABLE_ACTIVITIES . ' AS act, ' . TABLE_UNITS . ', ' . TABLE_TARIFFS . ' AS tar, ' . TABLE_EMPLOYEES_ROLES . ' AS er, ' . TABLE_ROLES . ' AS rl, ' . TABLE_CATEGORIES . ' AS cat, ' . TABLE_PROJECTS . ' AS pr, ' . TABLE_CUSTOMERS . ' AS cus, ' . TABLE_BUSINESS_UNITS . ' AS bu) ' . 'ON (ts.employees_id = emp.employees_id ' . 'AND act.timesheets_id = ts.timesheets_id ' . 'AND act.tariffs_id = tar.tariffs_id ' . 'AND units.units_id = tar.units_id ' . 'AND er.employees_roles_id = tar.employees_roles_id ' . 'AND rl.categories_id = cat.categories_id ' . 'AND rl.roles_id = er.roles_id ' . 'AND pr.projects_id = rl.projects_id ' . 'AND cus.customers_id = pr.customers_id ' . 'AND bu.business_units_id = pr.business_units_id) ' . 'WHERE ts.timesheets_start_date = "' . $periodstartdate . '" ' . 'ORDER BY cus.customers_id, pr.projects_id, rl.roles_id, act.activities_date, emp.employees_id, units.units_id'; $activities_query = $database->query($activities_query_string); $csv->addrow(array('customers_id', 'customers_name', 'customers_id_external', 'period_start_date', 'period_end_date', 'projects_name', 'business_units_name', 'roles_name', 'activities_date', 'employees_id', 'employees_fullname', 'amount', 'units_name', 'tariff', 'travel_distance', 'expenses', 'ticket_number', 'comment', 'categories_name')); while ($activities_result = $database->fetch_array($activities_query)) { $csv->addrow(array($activities_result['customers_id'], $activities_result['customers_name'], $activities_result['customers_id_external'], tep_strftime(DATE_FORMAT_SHORT, tep_datetouts('%Y-%m-%d', $activities_result['timesheets_start_date'])), tep_strftime(DATE_FORMAT_SHORT, tep_datetouts('%Y-%m-%d', $activities_result['timesheets_end_date'])), $activities_result['projects_name'], $activities_result['business_units_name'], $activities_result['roles_name'], tep_strftime(DATE_FORMAT_SHORT, tep_datetouts('%Y-%m-%d', $activities_result['activities_date'])), $activities_result['employees_id'], $activities_result['employees_fullname'], tep_number_db_to_user($activities_result['activities_amount'], 2), $activities_result['units_name'], tep_number_db_to_user($activities_result['tariffs_amount'], 2), $activities_result['activities_travel_distance'], tep_number_db_to_user($activities_result['activities_expenses'], 2), $activities_result['activities_ticket_number'], str_replace(";", ":", str_replace(array("\r\n", "\n", "\r"), "|", $activities_result['activities_comment'])), $activities_result['categories_name'])); } break; } // Get the show on the road $csv->output('D'); // <!-- application_bottom //--> require DIR_WS_INCLUDES . 'application_bottom.php'; // <!-- application_bottom_eof //-->
?> </td> <td class="entryListing-data" style="text-align:right"><?php echo tep_number_db_to_user($_SESSION['adm_benefits']->listing[$index]->credit + $_SESSION['adm_benefits']->listing[$index]->granted, 2); ?> </td> <td class="entryListing-data" style="text-align:right"><?php echo 'gebruikte hoeveelheid'; ?> </td> <td class="entryListing-data" style="text-align:right"><?php echo tep_number_db_to_user($_SESSION['adm_benefits']->listing[$index]->credit + $_SESSION['adm_benefits']->listing[$index]->granted, 2); ?> </td> <td class="entryListing-data"><?php echo tep_strftime(DATE_FORMAT_SHORT, $_SESSION['adm_benefits']->listing[$index]->start_date) . '<br>' . ($_SESSION['adm_benefits']->listing[$index]->end_date != 0 ? tep_strftime(DATE_FORMAT_SHORT, $_SESSION['adm_benefits']->listing[$index]->end_date) : '∞'); ?> </td> <td class="entryListing-data" style="width:20px;text-align:center"> <?php echo tep_draw_form('edit_entry', tep_href_link(FILENAME_ADMINISTRATION_BENEFITS)) . tep_create_parameters(array('action' => 'enter_data', 'benefits_id' => $_SESSION['adm_benefits']->listing[$index]->id, 'benefits_credit' => $_SESSION['adm_benefits']->listing[$index]->credit, 'benefits_granted' => $_SESSION['adm_benefits']->listing[$index]->granted, 'benefits_comment' => $_SESSION['adm_benefits']->listing[$index]->comment, 'roles_id' => $_SESSION['adm_benefits']->listing[$index]->role->id, 'benefits_start_date' => $_SESSION['adm_benefits']->listing[$index]->start_date, 'benefits_end_date' => $_SESSION['adm_benefits']->listing[$index]->end_date), array('mPath', 'employees_id'), 'hidden_field'); echo tep_image_submit('edit.gif', TEXT_ENTRY_EDIT, '', DIR_WS_IMAGES); echo '</form>'; ?> </td> <td class="entryListing-data" style="width:20px;text-align:center"> <?php echo tep_draw_form('delete_entry', tep_href_link(FILENAME_ADMINISTRATION_BENEFITS)) . tep_create_parameters(array('action' => 'delete_entry', 'benefits_id' => $_SESSION['adm_benefits']->listing[$index]->id, 'benefits_credit' => $_SESSION['adm_benefits']->listing[$index]->credit, 'benefits_granted' => $_SESSION['adm_benefits']->listing[$index]->granted, 'benefits_comment' => $_SESSION['adm_benefits']->listing[$index]->comment, 'roles_id' => $_SESSION['adm_benefits']->listing[$index]->role->id, 'benefits_start_date' => $_SESSION['adm_benefits']->listing[$index]->start_date, 'benefits_end_date' => $_SESSION['adm_benefits']->listing[$index]->end_date), array('mPath', 'employees_id'), 'hidden_field'); echo tep_image_submit('delete.gif', TEXT_ENTRY_DELETE, '', DIR_WS_IMAGES); echo '</form>'; ?>
/**************************************************************************** * CODE FILE : footer.php * Project : BitTS - BART it TimeSheet * Author(s) : Erwin Beukhof * Date : 14 april 2008 * Description : ..... * ..... * Framework: osCommerce, Open Source E-Commerce Solutions * http://www.oscommerce.com */ ?> <table border="0" width="100%" cellspacing="0" cellpadding="1"> <tr class="footer"> <td class="footer"> <?php echo tep_strftime(DATE_FORMAT_LONG); ?> </td> <td align="right" class="footer"> </td> </tr> </table> <br> <table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td align="center" class="smallText"><?php echo FOOTER_TEXT_BODY; ?> </td> </tr> </table> <br>
function tep_date_long($raw_date) { if ($raw_date == '0000-00-00 00:00:00' || $raw_date == '') { return false; } $year = (int) substr($raw_date, 0, 4); $month = (int) substr($raw_date, 5, 2); $day = (int) substr($raw_date, 8, 2); $hour = (int) substr($raw_date, 11, 2); $minute = (int) substr($raw_date, 14, 2); $second = (int) substr($raw_date, 17, 2); return tep_strftime(DATE_FORMAT_LONG, mktime($hour, $minute, $second, $month, $day, $year)); }