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('input_type', 'checkbox')->where('page', '=', 2)->orderBy('order')->with('choices')->with(array('answers' => function ($query) {
$query->where('user_id', '=', Session::get('userid'));
}))->get();
foreach ($page2data as $x) {
$project_checkbox_group[$x->question_group] = array();
foreach ($x->answers as $answer) {
$a = $answer->answer_text;
$aid = $answer->id;
}
array_push($project_checkbox_group[$x->question_group], $a);
}
//dd($project_checkbox_group);
$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();
$page5data = 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();
$page6data = 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();
$vendorsstring = '';
// $pdf = PDF::loadView('reviewsendpdf',$data)->setPaper('a4')->setWarnings(false);
// return $pdf->download('test.pdf');
if (Session::get('event') == 'Healthscape series 2015') {
$html22 = View::make('forms.healthcare.reviewsendpdf')->with(array('page1data' => $page1data, 'page2data' => $page2data, 'page3data' => $page3data, 'page4data' => $page4data, 'page5data' => $page4data, 'page6data' => $page4data));
} else {
$html22 = View::make('reviewsendpdf')->with(array('page1data' => $page1data, 'page2data' => $page2data, 'page3data' => $page3data, 'page4data' => $page4data, 'page5data' => $page4data, 'page6data' => $page4data));
}
$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] = '';
}
//dd(Session::get('userid'));
$fileTblObj = fileHandler::where('user_id', '=', Session::get('userid'))->where('formPage', '=', 3)->first();
if ($fileTblObj != NULL) {
$p3path = $fileTblObj->filePath . $fileTblObj->fileName;
} else {
$p3path = NULL;
}
$fileTblObj4 = fileHandler::where('user_id', '=', Session::get('userid'))->where('formPage', '=', 4)->get();
$filesp4 = array();
foreach ($fileTblObj4 as $val) {
$filesp4[] = $val->filePath . $val->fileName;
}
//$files = File::get($p3path);
//dd($p3path);
// $emails = array(
// '*****@*****.**' => 'Ashwin',
// //'*****@*****.**' => 'Ashwin',
// //'*****@*****.**' => 'Suresh',
// //'*****@*****.**' => 'Ravi',
// //'*****@*****.**' => 'Ganesh',
// //'*****@*****.**' => 'Sandhya',
// //'*****@*****.**' => 'Bikash',
// );
$data1 = array('asdf' => '');
Mail::send('emails.questionnairefilled', $data1, function ($message) use($htmltosend, $emails, $filesp4, $p3path) {
$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'));
if ($p3path != NULL) {
$message->attach($p3path);
}
if (count($filesp4) > 0) {
foreach ($filesp4 as $val) {
$message->attach($val);
}
}
});
// Mail::send('emails.questionnairefilled', $data1 , function($message) use ( $htmltosend, $emails, $filesp4, $p3path) {
// $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'))
// ->attach($p3path);
// foreach($filesp4 as $val)
// $message->attach($val);
// });
/*******************************************/
// $pdf = App::make('dompdf');
// $pdf->loadHTML($html)->setPaper('a4')->setWarnings(false);
// return $pdf->stream();
return View::make('forms.thankyou');
}
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 postIndex()
{
$aa = Input::except(array('_token', 'save', '/' . Request::segment(1) . '/rankingform'));
foreach ($aa as $key => $value) {
$ids = explode("|", $key);
if (isset($ids[1]) && $ids[1] != "") {
$ans = Supplierrank::find($ids[1]);
$ans->rank = $value;
$ans->save();
} else {
$ans = new Supplierrank();
$ans->supplierid = $ids[0];
$ans->userid = Session::get('userid');
$ans->rank = $value;
$ans->save();
}
}
/* EMAIL NOTIFICATION FOR FILLED Ranking form */
$dels = Auth::user();
function emaildata($delid)
{
$arr = array();
$ansarr = array();
$curruser = '';
$firstpass = true;
$usersandranking = Supplierrank::where('userid', '=', $delid)->with('supplier')->with('user')->orderBy('userid')->orderBy('rank')->get();
foreach ($usersandranking as $userrank) {
if ($curruser != $userrank->user->name) {
$arr[] = array();
$arr[] = array('Buyer Company Name', 'Vendor Company Name', 'Buyer Person Name', 'Buyer person designation', 'Rank');
}
$answerstable = Question::where('page', '=', 1)->with(array('answers' => function ($query) use($userrank) {
$query->where('user_id', '=', $userrank->user->id);
}))->get();
foreach ($answerstable as $answer) {
$a = '';
foreach ($answer->answers as $ans) {
$a = $ans->answer_text;
}
$ansarr[$answer->question_text] = $a;
}
$arr[] = array($ansarr['Company Name'], $userrank->supplier->name, $userrank->user->name, $ansarr['Job Title'], $userrank->rank);
$curruser = $userrank->user->name;
}
return $arr;
}
$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('rankingdata' => emaildata($dels->id));
Mail::queue('emails.rankingformfilled', $data1, function ($message) use($emails) {
$message->to($emails)->from('*****@*****.**')->subject(Auth::user()->name . ', ' . Auth::user()->event . '- Ranking form completed');
});
/*******************************************/
return Redirect::to(Request::segment(1) . '/rankingform')->with('message', 'Email Sent!');
}
public function postEmaillists()
{
$xx = Input::except(array('_token', 'save', '/admin/emaillists'));
// dd($xx);
foreach ($xx as $key => $value) {
// dd($value);
$r = Emaillist::find($key);
// dd($r);
$r->emails = $value;
$r->save();
}
return Redirect::to('admin/emaillists')->with('message', 'Saved');
}
public function postCreateuser()
{
$rules = array('name' => 'required', 'email' => 'required|email', 'password' => 'required|min:4', 'event' => 'required');
$validator = Validator::make(Input::all(), $rules);
// $u = Input::except('_token');
if ($validator->passes()) {
/* 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/createuser')->with('createusermessage', 'You cannot create a user for this event');
} else {
$chec = '';
foreach ($sl->salesloginevent as $sle) {
if (Input::get('event') == $sle->event) {
$chec = 'ok';
}
}
}
if ($chec != 'ok') {
return Redirect::to('sales/createuser')->with('createusermessage', 'You cannot create a user for this event');
}
}
/***************************************************/
$message = "asd";
$usercheck = User::where('email', '=', Input::get('email'))->where('event', '=', Input::get('event'))->first();
// dd($usercheck);
$salescheck = User::where('email', '=', Input::get('email'))->where('role', '=', 'sales_dd')->first();
//dd($salescheck->email);
if (isset($salescheck->email)) {
$message = 'User ' . Input::get('email') . ' for ' . Input::get('event') . ' already exists as Admin';
} else {
if (isset($usercheck->email)) {
$message = 'User ' . Input::get('email') . ' for ' . Input::get('event') . ' already exists';
} else {
$user = new User();
$user->email = Input::get('email');
$user->name = Input::get('name');
$user->event = Input::get('event');
$user->password = Hash::make(Input::get('password'));
$user->save();
$message = 'User created';
//Populate blanks in answers table
$qids = Question::where('id', '!=', 'dfd')->get();
$us = $user->id;
foreach ($qids as $q) {
$ta = new Answer();
$ta->question_id = $q->id;
$ta->user_id = $us;
$ta->save();
}
/* EMAIL NOTIFICATION FOR FILLED QUESTIONNAIRES */
$emaillists = Emaillist::where('event', '=', Input::get('event'))->first();
$emls = explode(',', $emaillists->emails);
$adminemails = array();
foreach ($emls as $eml) {
$adminemails[$eml] = '';
}
// $adminemails = array(
// '*****@*****.**' => 'Ashwin',
// //'*****@*****.**' => 'Ashwin',
// //'*****@*****.**' => 'Suresh',
// //'*****@*****.**' => 'Ravi',
// //'*****@*****.**' => 'Ganesh',
// //'*****@*****.**' => 'Sandhya',
// //'*****@*****.**' => 'Bikash',
// );
$adminemails[Auth::user()->email] = Auth::user()->value;
$data = array('event' => Input::get('event'), 'username' => Input::get('email'), 'password' => Input::get('password'), 'name' => Input::get('name'));
Mail::queue('emails.usercreated', $data, function ($message) use($adminemails, $data) {
$message->to($adminemails)->from('*****@*****.**')->subject(Input::get('name') . ', ' . $data['event'] . '- Account Created');
});
$data1 = array('event' => Input::get('event'), 'username' => Input::get('email'), 'password' => Input::get('password'), 'name' => Input::get('name'));
$delegate = array('email' => Input::get('email'), 'name' => Input::get('name'), 'event' => Input::get('event'));
Mail::queue('emails.welcome', $data1, function ($message) use($delegate) {
$message->to($delegate['email'], $delegate['name'])->from('*****@*****.**')->subject('Welcome to ' . $delegate['event']);
});
}
}
return Redirect::to('sales/createuser')->with('createusermessage', $message);
}
return Redirect::to('sales/createuser')->with('createusermessage', 'User could not be created')->withErrors($validator)->withInput();
}
