public function run()
{
$faker = Faker\Factory::create();
for ($id = 1; $id < 19; $id++) {
CommonId::create(['user_id' => $id, 'tin' => $faker->randomElement(['646933026598', '532069354265', '123465987567']), 'philhealth' => $faker->randomElement(['646945126330', '566265320695', '123596234567']), 'pagibig' => $faker->randomElement(['646365989330', '532365980695', '123365984567']), 'sss' => $faker->randomElement(['646933659830', '532063215695', '123365984567'])]);
}
}
public function postEditCommonid($id)
{
$user = User::find($id);
$comids = CommonId::where('user_id', $id)->first();
$validator = Validator::make(Input::all(), CommonId::$rules);
if ($validator->fails()) {
return Redirect::route('emp.edit-commonid', $comids->user_id)->withErrors($validator)->withInput();
}
$comids->update(['tin' => Input::get('tin'), 'philhealth' => Input::get('philhealth'), 'pagibig' => Input::get('pagibig'), 'sss' => Input::get('sss'), 'gsisbp' => Input::get('gsisbp'), 'gsispolicy' => Input::get('gsispolicy'), 'gsisoptional' => Input::get('gsisoptional'), 'educplan' => Input::get('educplan')]);
$audit = AuditTrail::create(['user_id' => Auth::id(), 'role' => 'Employee Management Admin', 'action' => 'edited ' . $user->firstname . ' ' . $user->lastname . '\'s Common ID information.']);
return Redirect::route('profile', $id)->with('alert', 'success|Common Ids have been updated.');
}
public function getUserPdf($id)
{
$user = User::find($id);
$comids = CommonId::where('user_id', $user->id)->first();
$cont = ContactInfo::where('user_id', $user->id)->first();
$parents = Parents::where('user_id', $user->id)->get();
$schools = School::where('user_id', $user->id)->first();
if ($user->gender == 'Male') {
$gender = 'his';
} else {
$gender = 'her';
}
$audit = AuditTrail::create(['user_id' => Auth::id(), 'role' => 'User', 'action' => 'printed ' . $gender . ' User Information']);
if (!$user) {
App::abort(404);
}
Fpdf::AddPage();
Fpdf::PageNo();
Fpdf::AliasNbPages('{nb}');
Fpdf::Image('img/dap.jpg', 10, 5, 150);
Fpdf::SetFont('Arial', 'B', 10);
Fpdf::Ln(25);
Fpdf::Cell(300, 10, 'Date Generated: ' . date("F j, Y"), 0, 2, 'C', 0);
Fpdf::SetFont('Arial', 'B', 18);
Fpdf::Ln(10);
Fpdf::Cell(190, 10, $user->formatName(':fn :ln'), 0, 2, 'C', 0);
Fpdf::SetFont('Arial', 'B', 9.5);
Fpdf::SetTextColor(0, 0, 0);
Fpdf::Cell(80, 10, 'Personal Information', 0, 0, 'C', 0);
Fpdf::Cell(80, 10, 'Common ID', 0, 1, 'C', 0);
Fpdf::SetTextColor(0, 0, 0);
Fpdf::SetFont('Arial', '', 8.5);
Fpdf::Cell(80, 10, 'Email: ' . $user->email, 0, 0, 'L', 0);
Fpdf::Cell(80, 10, 'TIN ID: ' . $comids->tin, 0, 1, 'L', 0);
Fpdf::Cell(80, 10, 'Username: '******'L', 0);
Fpdf::Cell(80, 10, 'Philhealth: ' . $comids->philhealth, 0, 1, 'L', 0);
Fpdf::Cell(80, 10, 'Birthday: ' . $user->birthday, 0, 0, 'L', 0);
Fpdf::Cell(80, 10, 'Pag IBIG: ' . $comids->pagibig, 0, 1, 'L', 0);
Fpdf::Cell(80, 10, 'Gender: ' . $user->gender, 0, 0, 'L', 0);
Fpdf::Cell(80, 10, 'SSS: ' . $comids->sss, 0, 1, 'L', 0);
Fpdf::Cell(80, 10, 'Department: ' . $user->department->name, 0, 0, 'L', 0);
//Fpdf::Cell(80,10,'Common ID',0,2,'C',0);
Fpdf::Ln(15);
Fpdf::SetFont('Arial', 'B', 9.5);
Fpdf::SetFillColor(90, 90, 90);
Fpdf::SetTextColor(0, 0, 0);
Fpdf::Cell(150, 10, 'Parents', 0, 1, 'C', 0);
foreach ($parents as $parent) {
if ($parent->parent_id == 1) {
Fpdf::SetFont('Arial', '', 8.5);
Fpdf::Cell(10, 10, 'Father', 0, 0, 'C', 0);
} else {
Fpdf::SetFont('Arial', '', 8.5);
Fpdf::Cell(10, 10, 'Mother', 0, 0, 'C', 0);
}
Fpdf::Cell(65, 10, 'Name: ' . $parent->firstname . " " . $parent->lastname, 0, 0, 'L', 0);
Fpdf::Cell(65, 10, 'Address: ' . $parent->address, 0, 1, 'L', 0);
}
Fpdf::Ln(15);
Fpdf::SetFont('Arial', 'B', 9.5);
Fpdf::Cell(150, 10, 'Contact Info', 0, 1, 'C', 0);
Fpdf::SetFont('Arial', '', 8.5);
Fpdf::Cell(80, 10, 'Home Number: ' . $cont->homenum, 0, 0, 'L', 0);
Fpdf::Cell(80, 10, 'Office Number: ' . $cont->officenum, 0, 1, 'L', 0);
Fpdf::Cell(80, 10, 'Mobile Number: ' . $cont->mobilenum, 0, 0, 'L', 0);
Fpdf::Cell(80, 10, 'Street: ' . $cont->street, 0, 1, 'L', 0);
Fpdf::Cell(80, 10, 'City: ' . $cont->city, 0, 0, 'L', 0);
Fpdf::Ln(5);
Fpdf::Ln(5);
Fpdf::SetFont('Arial', 'B', 9.5);
Fpdf::SetFillColor(90, 90, 90);
Fpdf::SetTextColor(0, 0, 0);
Fpdf::Cell(180, 10, 'School', 0, 1, 'C', 0);
Fpdf::SetTextColor(0, 0, 0);
Fpdf::SetFont('Arial', '', 8.5);
Fpdf::Cell(65, 10, 'Primary', 0, 0, 'C', 0);
Fpdf::Cell(65, 10, 'Secondary', 0, 0, 'C', 0);
Fpdf::Cell(65, 10, 'Tertiary', 0, 1, 'C', 0);
Fpdf::Cell(65, 10, 'School: ' . $schools->primary_name, 0, 0, 'L', 0);
Fpdf::Cell(70, 10, 'School: ' . $schools->secondary_name, 0, 0, 'L', 0);
Fpdf::Cell(70, 10, 'School: ' . $schools->tertiary_name, 0, 1, 'L', 0);
Fpdf::Cell(65, 10, 'Address: ' . $schools->primary_address, 0, 0, 'L', 0);
Fpdf::Cell(70, 10, 'Address: ' . $schools->secondary_address, 0, 0, 'L', 0);
Fpdf::Cell(70, 10, 'Address: ' . $schools->tertiary_address, 0, 1, 'L', 0);
Fpdf::Cell(65, 10, 'Years: ' . $schools->primary_years, 0, 0, 'L', 0);
Fpdf::Cell(70, 10, 'Years: ' . $schools->secondary_years, 0, 0, 'L', 0);
Fpdf::Cell(70, 10, 'Years: ' . $schools->tertiary_years, 0, 1, 'L', 0);
Fpdf::SetY(-30.5);
Fpdf::SetFont('Arial', 'I', 6);
Fpdf::SetTextColor(0, 0, 0);
Fpdf::Cell(0, 10, 'Page ' . Fpdf::PageNo() . "/{nb}", 0, 0, 'C');
Fpdf::Output();
exit;
}
