public function postExporttopdf()
{
$validator = Validator::make(Input::all(), array('delid' => 'required'));
$event = Session::get('tempevenname');
//dd(Session::get('tempevenname'));
if ($validator->passes()) {
$uid1 = Input::get('delid');
$username = User::find(Input::get('delid'))->name;
$page1data = Question::where('event', '=', $event)->where('page', '=', 1)->orderBy('order')->with('choices')->with(array('answers' => function ($query) {
$query->where('user_id', '=', Input::get('delid'));
}))->get();
$page2data = Question::where('event', '=', $event)->where('page', '=', 2)->orderBy('order')->with('choices')->with(array('answers' => function ($query) {
$query->where('user_id', '=', Input::get('delid'));
}))->get();
$page3data = Question::where('event', '=', $event)->where('page', '=', 3)->orderBy('order')->with('choices')->with(array('answers' => function ($query) {
$query->where('user_id', '=', Input::get('delid'));
}))->get();
$page4data = Question::where('event', '=', $event)->where('page', '=', 4)->orderBy('order')->with('choices')->with(array('answers' => function ($query) {
$query->where('user_id', '=', Input::get('delid'));
}))->get();
$categoryvendoranswers = Categoryvendoranswer::where('user_id', '=', Input::get('delid'))->with('categoryvendor')->get();
$vendorsstring = '';
if (!$categoryvendoranswers->isEmpty()) {
foreach ($categoryvendoranswers as $cva) {
if ($cva->answer == 'yes') {
$vendorsstring = $vendorsstring . $cva->categoryvendor->vendorname . ', ';
// dd($vendorsstring);
}
}
}
//dd($vendorsstring);
// // dd($page1data);
// $html = View::make('reviewsendpdf')->with(array(
// 'page1data'=>$page1data,
// 'page2data'=>$page2data,
// 'page3data'=>$page3data,
// 'page4data'=>$page4data,
// 'event'=>$event,
// 'vendorsstring'=>$vendorsstring
// ));
if ($event == 'Healthscape series 2016') {
$html22 = View::make('forms.healthcare.reviewsendpdf')->with(array('page1data' => $page1data, 'page2data' => $page2data, 'page3data' => $page3data, 'page4data' => $page4data, 'event' => $event));
} else {
$html22 = View::make('reviewsendpdf')->with(array('page1data' => $page1data, 'page2data' => $page2data, 'page3data' => $page3data, 'page4data' => $page4data));
}
require_once app_path() . '/libs/html2pdf/html2pdf.class.php';
$html2pdf = new HTML2PDF('P', 'A4', 'en', true, 'UTF-8', array(0, 0, 0, 0));
$html2pdf->pdf->SetDisplayMode('fullpage');
$html2pdf->WriteHTML($html22);
ob_end_clean();
$html2pdf->Output($username . '_questionnaire.pdf', 'D');
} else {
return Redirect::to('admin/exporttopdf')->with('message', 'Select a user and event');
}
}
public function getThankyou()
{
// $page1data = Question::where('event','=',Session::get('event'))->where('page','=',1)->orderBy('order')->with('choices')
// ->with(array('answers'=>function($query){
// $query->where('user_id','=',Session::get('userid'));
// }))->get();
// $page2data = Question::where('event','=',Session::get('event'))->where('page','=',2)->orderBy('order')->with('choices')
// ->with(array('answers'=>function($query){
// $query->where('user_id','=',Session::get('userid'));
// }))->get();
// $page3data = Question::where('event','=',Session::get('event'))->where('page','=',3)->orderBy('order')->orderBy('question_group')->with('choices')
// ->with(array('answers'=>function($query){
// $query->where('user_id','=',Session::get('userid'));
// }))->get();
// $page4data = Question::where('event','=',Session::get('event'))->where('page','=',4)->orderBy('order')->with('choices')
// ->with(array('answers'=>function($query){
// $query->where('user_id','=',Session::get('userid'));
// }))->get();
$page1data = Question::where('page', '=', 1)->orderBy('order')->with('choices')->with(array('answers' => function ($query) {
$query->where('user_id', '=', Session::get('userid'));
}))->get();
$page2data = Question::where('page', '=', 2)->orderBy('order')->with('choices')->with(array('answers' => function ($query) {
$query->where('user_id', '=', Session::get('userid'));
}))->get();
$page3data = Question::where('page', '=', 3)->orderBy('order')->orderBy('question_group')->with('choices')->with(array('answers' => function ($query) {
$query->where('user_id', '=', Session::get('userid'));
}))->get();
$page4data = Question::where('page', '=', 4)->orderBy('order')->with('choices')->with(array('answers' => function ($query) {
$query->where('user_id', '=', Session::get('userid'));
}))->get();
$categoryvendoranswers = Categoryvendoranswer::where('user_id', '=', Session::get('userid'))->with('categoryvendor')->get();
$vendorsstring = '';
if (!$categoryvendoranswers->isEmpty()) {
foreach ($categoryvendoranswers as $cva) {
if ($cva->answer == 'yes') {
$vendorsstring = $vendorsstring . $cva->categoryvendor->vendorname . ', ';
// dd($vendorsstring);
}
}
}
// $pdf = PDF::loadView('reviewsendpdf',$data)->setPaper('a4')->setWarnings(false);
// return $pdf->download('test.pdf');
$html22 = View::make('reviewsendpdf')->with(array('page1data' => $page1data, 'page2data' => $page2data, 'page3data' => $page3data, 'page4data' => $page4data, 'vendorsstring' => $vendorsstring));
$html1 = "<h1>adsfadsfasdf</h1>";
// dd($html22);
require_once app_path() . '/libs/html2pdf/html2pdf.class.php';
$html2pdf = new HTML2PDF('P', 'A4', 'en', true, 'UTF-8', array(0, 0, 0, 0));
$html2pdf->pdf->SetDisplayMode('fullpage');
$html2pdf->WriteHTML($html22);
$htmltosend = $html2pdf->Output('', 'S');
// dd($htmltosend);
/* EMAIL NOTIFICATION FOR FILLED QUESTIONNAIRES */
$emaillists = Emaillist::where('event', '=', Auth::user()->event)->first();
$emls = explode(',', $emaillists->emails);
$emails = array();
foreach ($emls as $eml) {
$emails[$eml] = '';
}
// $emails = array(
// '*****@*****.**' => 'Ashwin',
// //'*****@*****.**' => 'Ashwin',
// //'*****@*****.**' => 'Suresh',
// //'*****@*****.**' => 'Ravi',
// //'*****@*****.**' => 'Ganesh',
// //'*****@*****.**' => 'Sandhya',
// //'*****@*****.**' => 'Bikash',
// );
$data1 = array('asdf' => '');
Mail::send('emails.questionnairefilled', $data1, function ($message) use($htmltosend, $emails) {
$message->to($emails)->from('*****@*****.**')->subject(Auth::user()->name . ', ' . Auth::user()->event . '- Questionnaire completed')->attachData($htmltosend, Auth::user()->name . '_questionnaire.pdf', array('mime' => 'application/pdf', 'Content-Disposition' => 'attachment'));
});
/*******************************************/
// $pdf = App::make('dompdf');
// $pdf->loadHTML($html)->setPaper('a4')->setWarnings(false);
// return $pdf->stream();
return View::make('forms.thankyou');
}
public function postExporttopdf()
{
$validator = Validator::make(Input::all(), array('delid' => 'required'));
$event = Session::get('tempevenname');
/* Check if Sales login user has access to posted event*/
$currsalesuser = User::where('id', '=', Auth::user()->id)->with('salesloginevent')->get();
foreach ($currsalesuser as $sl) {
if ($sl->salesloginevent->isEmpty()) {
return Redirect::to('sales/exporttopdfpre')->with('createusermessage', 'You cannot view users for this event');
} else {
$chec = '';
foreach ($sl->salesloginevent as $sle) {
if ($event == $sle->event) {
$chec = 'ok';
}
}
}
if ($chec != 'ok') {
return Redirect::to('sales/exporttopdfpre')->with('createusermessage', 'You cannot view users for this event');
}
}
/********************************************************/
if ($validator->passes()) {
$uid1 = Input::get('delid');
$username = User::find(Input::get('delid'))->name;
$page1data = Question::where('page', '=', 1)->orderBy('order')->with('choices')->with(array('answers' => function ($query) {
$query->where('user_id', '=', Input::get('delid'));
}))->get();
$page2data = Question::where('page', '=', 2)->orderBy('order')->with('choices')->with(array('answers' => function ($query) {
$query->where('user_id', '=', Input::get('delid'));
}))->get();
$page3data = Question::where('page', '=', 3)->orderBy('order')->with('choices')->with(array('answers' => function ($query) {
$query->where('user_id', '=', Input::get('delid'));
}))->get();
$page4data = Question::where('page', '=', 4)->orderBy('order')->with('choices')->with(array('answers' => function ($query) {
$query->where('user_id', '=', Input::get('delid'));
}))->get();
//dd($page2data);
$categoryvendoranswers = Categoryvendoranswer::where('user_id', '=', Input::get('delid'))->with('categoryvendor')->get();
$vendorsstring = '';
if (!$categoryvendoranswers->isEmpty()) {
foreach ($categoryvendoranswers as $cva) {
if ($cva->answer == 'yes') {
$vendorsstring = $vendorsstring . $cva->categoryvendor->vendorname . ', ';
// dd($vendorsstring);
}
}
}
//dd($vendorsstring);
$html = View::make('reviewsendpdf')->with(array('page1data' => $page1data, 'page2data' => $page2data, 'page3data' => $page3data, 'page4data' => $page4data, 'event' => $event, 'vendorsstring' => $vendorsstring));
require_once app_path() . '/libs/html2pdf/html2pdf.class.php';
$html2pdf = new HTML2PDF('P', 'A4', 'en', true, 'UTF-8', array(0, 0, 0, 0));
$html2pdf->pdf->SetDisplayMode('fullpage');
$html2pdf->WriteHTML($html);
$html2pdf->Output($username . '_questionnaire.pdf', 'D');
} else {
return Redirect::to('sales/exporttopdf')->with('message', 'Select a user and event');
}
}
