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');
}
}
