Since each student’s timesheet is formatted the same way, whether it is generated as a single timesheet or as part of multiple timesheets, I developed a class to create the timesheets.
Figure 1: A sample timesheet
In the class is a function called outputPDF which accepts one argument: an array of the timesheet values. Inside the function we begin creating the page.
function createPdf($app_data, $type, $begin, $end, $section=null)
{
// include and instantiate the fpdf library
include 'includes/fpdf.php';
$this->fpdf = new fpdfHelper();
// Call the FPDF page numbering function and create the first page:
$this->fpdf->AliasNbPages();
$this->fpdf->AddPage();
// Set the page title:
$this->fpdf->setTitle('Complete Payroll Report');
// check to see if the type is single and if so, generate the timesheet
if($type == 'single')
{
//set the begin period and end period dates
$app_data['begin_period'] = $begin;
$app_data['end_period'] = $end;
//create the timesheet
$data = $this->outputPdf($app_data);
//get the current date so we can put it in the file name of the timesheet
$date = date("m_d_Y");
//create the file name with the employee's name and the date
$name = $app_data['name']."_".$date.".pdf";
//send it to the browser
echo $this->fpdf->fpdfOutput($name, $destination = 'd');
}
// if the type isn't single check to see if it is multiple and if so, generate the timesheets
elseif($type == 'multiple')
{
//get the current date to use in the file name
$date = date("m_d_Y");
//do stuff to get all apps in pdf
$data = null; //create variable to hold the timesheets as we generate them
//loop through the data and create a timesheet for each employee
foreach ($app_data as $app)
{
//set up begin and end date variables for the pay period
$app['begin_period'] = $begin;
$app['end_period'] = $end;
//generate timesheet for the current employee and store it in the data variable
$data .= $this->outputPdf($app);
//create a new page
$data .= $this->fpdf->AddPage();
}
//create the file name and include the name of the department (section) in it
$name = "payroll_report_".$section."_".$date.".pdf";
//send it to the browser
echo $this->fpdf->fpdfOutput($name, $destination = 'd');
}
function createPdf($app_data, $type, $begin, $end, $section=null)
{
// include and instantiate the fpdf library
include 'includes/fpdf.php';
$this->fpdf = new fpdfHelper();
// Call the FPDF page numbering function and create the first page:
$this->fpdf->AliasNbPages();
$this->fpdf->AddPage();
// Set the page title:
$this->fpdf->setTitle('Complete Payroll Report');
// check to see if the type is single and if so, generate the timesheet
if($type == 'single')
{
//set the begin period and end period dates
$app_data['begin_period'] = $begin;
$app_data['end_period'] = $end;
//create the timesheet
$data = $this->outputPdf($app_data);
//get the current date so we can put it in the file name of the timesheet
$date = date("m_d_Y");
//create the file name with the employee's name and the date
$name = $app_data['name']."_".$date.".pdf";
//send it to the browser
echo $this->fpdf->fpdfOutput($name, $destination = 'd');
}
// if the type isn't single check to see if it is multiple and if so, generate the timesheets
elseif($type == 'multiple')
{
//get the current date to use in the file name
$date = date("m_d_Y");
//do stuff to get all apps in pdf
$data = null; //create variable to hold the timesheets as we generate them
//loop through the data and create a timesheet for each employee
foreach ($app_data as $app)
{
//set up begin and end date variables for the pay period
$app['begin_period'] = $begin;
$app['end_period'] = $end;
//generate timesheet for the current employee and store it in the data variable
$data .= $this->outputPdf($app);
//create a new page
$data .= $this->fpdf->AddPage();
}
//create the file name and include the name of the department (section) in it
$name = "payroll_report_".$section."_".$date.".pdf";
//send it to the browser
echo $this->fpdf->fpdfOutput($name, $destination = 'd');
}
One of the cool things about the timeclock is the ability to generate pdf timesheets on demand. The Hartman Union Building (HUB) administrative assistant is tasked with producing timesheets for approximately 100 student employees every two weeks.
Problem
The old time clock system generated arbitrary numbers for each student employee. At the end of each two week pay period the administrative assistant had to manually enter each employee’s time clock number, generate and print a timesheet report. As you can imagine, this was a tedious and time consuming task.
Problem Solved!
Before I began creating the timeclock I talked to the administrative assistant to identify what she liked and disliked about the current system. The problem outlined above was her greatest dislike. I created the new timeclock system to revolve around the unique student ID number issued to students upon their acceptance to the university. This allows the administrative assitant to select an employee by their name and generate a timesheet for that individual. Even better, I went one step further to reduce her workload: now she can generate a single pdf file with all employees’ timesheets ready to print. This takes only a few minutes instead of the entire afternoon!