public function savepage3data() { $aa = Input::except(array('_token', 'back', 'save', 'next')); //dd($aa); foreach ($aa as $key => $value) { $ids = explode("|", $key); if (isset($ids[0]) && $ids[0] != "catven") { if (isset($ids[1]) && $ids[1] != "") { $ans = Answer::find($ids[1]); $ans->answer_text = $value; $ans->save(); } else { $ans = new Answer(); $ans->question_id = $ids[0]; if (isset($ids[2]) && $ids[2] != "") { $ans->choice_id = $ids[2]; } $ans->user_id = Session::get('userid'); $ans->answer_text = $value; $ans->save(); } } else { // dd($value); if (isset($ids[2]) && $ids[2] != "") { $catvenans = Categoryvendoranswer::find($ids[2]); $catvenans->answer = $value; $catvenans->save(); } else { $catvenans = new Categoryvendoranswer(); $catvenans->categoryvendor_id = $ids[1]; $catvenans->user_id = Session::get('userid'); $catvenans->answer = $value; $catvenans->save(); } } } }
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 savepage3data() { $aa = Input::except(array('_token', 'back', 'save', 'next')); foreach ($aa as $key => $value) { $ids = explode("|", $key); //var_dump($ids); if (isset($ids[0]) && $ids[0] != "catven" && $ids[0] != "file") { if (isset($ids[1]) && $ids[1] != "") { $ans = Answer::find($ids[1]); $ans->answer_text = $value; $ans->save(); } else { $ans = new Answer(); $ans->question_id = $ids[0]; if (isset($ids[2]) && $ids[2] != "") { $ans->choice_id = $ids[2]; } $ans->user_id = Session::get('userid'); $ans->answer_text = $value; $ans->save(); } } else { if (isset($ids[0]) && $ids[0] == "catven") { if (isset($ids[2]) && $ids[2] != "") { $catvenans = Categoryvendoranswer::find($ids[2]); $catvenans->answer = $value; $catvenans->save(); } else { $catvenans = new Categoryvendoranswer(); $catvenans->categoryvendor_id = $ids[1]; $catvenans->user_id = Session::get('userid'); $catvenans->answer = $value; $catvenans->save(); } } } if (isset($ids[0]) && $ids[0] == "file") { $userid = Session::get('userid'); $event = Session::get('event'); $fileTblObj = new fileHandler(); $ans = Answer::find($ids[2]); if (isset($aa[$key])) { if (Input::file($key)->isValid()) { $destinationPath = 'app/uploads/' . $event . '/' . $userid . '/3'; // upload path $extension = Input::file($key)->getClientOriginalExtension(); // getting image extension $name = Input::file($key)->getClientOriginalName(); $curFilesize = Input::file($key)->getClientSize(); $mime = Input::file($key)->getMimeType(); // dd($mime); //$fileName = $name; // renameing image //$exstFileSize = Input::file($destinationPath, $fileName); if (!File::exists($destinationPath . "/boq-" . $name)) { //creating details for saving inthe file_handler Table $fileTblObj->user_id = $userid; $fileTblObj->eventName = $event; $fileTblObj->fileName = "boq-" . $name; $fileTblObj->formPage = 3; $fileTblObj->filePath = $destinationPath . "/"; $fileTblObj->mime = $mime; $ans->answer_text = 'Yes'; Input::file($key)->move($destinationPath, "boq-" . $name); // uploading file to given path //Input::file($key)->move($boqPath, $boqname); // uploading file to given path //Save filedetails $fileTblObj->save(); $ans->save(); Session::flash('success', 'Upload successfully'); } else { if (File::size($destinationPath . "/" . $name) != $curFilesize) { $fileDtls = $fileTblObj->where('uid', $userid)->where('fileName', $name)->where('formPage', 3)->first(); Input::file($key)->move($destinationPath, $name); $ans->answer_text = 'Yes'; $ans->save(); $fileTblObj->where('id', $fileDtls->id)->update(array('updated_at' => date("Y-m-d h:m:s", time()))); } } //return Redirect::to('upload'); } } else { if ($ans->answer_text == '') { $ans->answer_text = 'No'; $ans->save(); } } } } }
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'); } }