public function postForm()
{
$inp = Input::except(array('_token', 'checkinhour', 'checkinminute', 'checkinampm', 'checkouthour', 'checkoutminute', 'checkoutampm', 'etah', 'etam', 'etdh', 'etdm'));
$validator = Validator::make($inp, array('guest1firstname' => 'required', 'guest1lastname' => 'required', 'guest1email' => 'required|email', 'company' => 'required', 'mobile' => 'required', 'occupancy' => 'required', 'smoking' => 'required', 'bed' => 'required', 'airportpickup' => 'required', 'checkindate' => 'required', 'checkoutdate' => 'required'));
if ($validator->passes()) {
$hb = new Hotelbooking();
$hb->eventname = $inp['event'];
$hb->guest1firstname = $inp['guest1firstname'];
$hb->guest1lastname = $inp['guest1lastname'];
$hb->company = $inp['company'];
$hb->guest1email = $inp['guest1email'];
$hb->mobile = $inp['mobile'];
$hb->guest2firstname = $inp['guest2firstname'];
$hb->guest2lastname = $inp['guest2lastname'];
$hb->guest2email = $inp['guest2email'];
$hb->occupancy = $inp['occupancy'];
$hb->checkindate = $inp['checkindate'];
$hb->checkintime = $inp['checkintime'];
$hb->checkoutdate = $inp['checkoutdate'];
$hb->checkoutime = $inp['checkouttime'];
$hb->noofnights = $inp['noofnights'];
$hb->smoking = $inp['smoking'];
$hb->bed = $inp['bed'];
$hb->modeofpayment = $inp['modeofpayment'];
$hb->flightdetails = $inp['flightdetails'];
$hb->eta = $inp['eta'];
$hb->etd = $inp['etd'];
$hb->airportpickup = $inp['airportpickup'];
$hb->save();
$data1 = array('name' => $hb->guest1firstname, 'event' => $hb->eventname);
Mail::send('hotelbooking.email', $data1, function ($message) use($hb) {
$message->to(array('*****@*****.**' => '*****@*****.**', '*****@*****.**' => '*****@*****.**'))->from('*****@*****.**')->subject($hb->guest1firstname . ', ' . $hb->eventname . '- hotel booking form completed');
});
return View::make('hotelbooking.thankyou');
}
return Redirect::to('hotelbookingform/form')->withErrors($validator)->withInput();
}
<?php
// require('http://localhost:8000/app/libs/excel/Classes/PHPExcel.php');
set_time_limit(1020);
require app_path() . '/libs/excel/Classes/PHPExcel.php';
$objPHPExcel = new PHPExcel();
// Set document properties
$objPHPExcel->getProperties()->setCreator("ideconnect.com")->setLastModifiedBy("ideconnect.com")->setTitle("Office 2007 XLSX Test Document")->setSubject("Office 2007 XLSX Test Document")->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")->setKeywords("office 2007 openxml php")->setCategory("Test result file");
// Add some data
//***************************************************************************************
$excelarr = array();
$hotelbookings = Hotelbooking::where('eventname', '=', $event)->get();
$headers = Schema::getColumnListing('hotelbookings');
foreach ($hotelbookings as $hotelbooking) {
$arr = array();
foreach ($hotelbooking['attributes'] as $key => $value) {
$arr[] = $value;
}
$excelarr[] = $arr;
}
array_unshift($excelarr, $headers);
$objPHPExcel->setActiveSheetIndex(0)->fromArray($excelarr, '', 'A1');
$objPHPExcel->getActiveSheet()->setTitle('DM');
$styleArray = array('font' => array('name' => 'Calibri', 'size' => '10', 'color' => array('rgb' => 'FFFFFF'), 'bold' => true), 'fill' => array('type' => PHPExcel_Style_Fill::FILL_SOLID, 'startcolor' => array('rgb' => '000000')));
// $styleArray2 = array(
// 'font' => array(
// 'name' => 'Calibri',
// 'size' => '10',
// 'color' => array(
// 'rgb' => '000000'
// ),
