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 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()) { $message = "asd"; $usercheck = User::where('email', '=', Input::get('email'))->where('event', '=', Input::get('event'))->first(); $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 { //dd($salescheck); $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')->where('event', '=', Input::get('event'))->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 USER ACCOUNT CREATION */ $emaillists = Emaillist::where('event', '=', Input::get('event'))->first(); $emls = explode(',', $emaillists->emails); $adminemails = array(); foreach ($emls as $eml) { $adminemails[$eml] = ''; } // dd($adminemails); // $adminemails = array( // '*****@*****.**' => 'Ashwin', // //'*****@*****.**' => 'Ashwin', // //'*****@*****.**' => 'Suresh', // //'*****@*****.**' => 'Ravi', // //'*****@*****.**' => 'Ganesh', // //'*****@*****.**' => 'Sandhya', // //'*****@*****.**' => 'Bikash', // ); $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('admin/createuser')->with('createusermessage', $message); } return Redirect::to('admin/createuser')->with('createusermessage', 'User could not be created')->withErrors($validator)->withInput(); }
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!'); }