public function getPage3()
 {
     $userdetails = array('name' => Session::get('username'), 'event' => Session::get('event'));
     // $questions = Question::where('event','=',Session::get('event'))->where('page','=',3)->orderBy('order')->with('choices')
     // ->with(array('answers'=>function($query){
     // 		$query->where('user_id','=',Session::get('userid'));
     // }))->get();
     $questions = Question::where('page', '=', 3)->orderBy('order')->with('choices')->with(array('answers' => function ($query) {
         $query->where('user_id', '=', Session::get('userid'));
     }))->get();
     $categoryvendors = Categoryvendor::where('event', '=', Session::get('event'))->with(array('categoryvendoranswer' => function ($q) {
         $q->where('user_id', '=', Session::get('userid'));
     }))->get();
     return View::make('forms.page3')->with(array('userdetails' => $userdetails, 'questions' => $questions, 'categoryvendors' => $categoryvendors));
     // return View::make('forms.page3')->with(array('userdetails'=>$userdetails,'questions'=>$questions));
 }
 public function postCategoryvendorsbulk()
 {
     /*
     		$rules = array(
     	'vendorname'=>'required',
     	'event'=>'required',
     	'categoryname'=>'required',
     
     );
     */
     $rules = array('vendorname' => 'required', 'categoryname' => 'required', 'logo' => 'required');
     $validator = Validator::make(Input::all(), $rules);
     /*	if($validator->passes()){
     				foreach(Input::get('event') as $event){
     					foreach(Input::get('categoryname') as $category){
     						$cv = new Categoryvendor();
     						$cv->categoryname = $category;
     						$cv->vendorname = Input::get('vendorname');
     						$cv->event = $event;
     						$cv->save();
     					}
     				}
     
     				return Redirect::to('admin/categoryvendorsbulk')->with('message', 'Category Vendor Added');
     			} */
     if ($validator->passes()) {
         //foreach(Input::get('vendorname') as $vendor){
         foreach (Input::get('categoryname') as $category) {
             $cv = new Categoryvendor();
             $cv->categoryname = $category;
             $cv->vendorname = Input::get('vendorname');
             $cv->url = Input::get('url');
             $image1 = Input::file('logo');
             $filename = date('Y-m-d-hh-mm-ss') . '-' . $image1->getClientOriginalName();
             $path = public_path('/images/admin/categoryvendors/' . $filename);
             Image::make($image1->getRealPath())->resize(100, 100)->save($path);
             $cv->imgpath = 'images/admin/categoryvendors/' . $filename;
             $cv->save();
         }
         //}
         return Redirect::to('admin/categoryvendorsbulk')->with('message', 'Category Vendor Added');
     }
     return Redirect::to('admin/categoryvendorsbulk')->with('message', 'Could not Add - Please mention vendor name/logo/web url & select events / categories.');
 }
        $tempansarr[$ansobj->question_id] = $ansobj->answer_text;
    }
    foreach ($usa->categoryvendoranswer as $catansobj) {
        $tempcatansarr[$catansobj->categoryvendor_id] = $catansobj->answer;
    }
    $useransarr[$usa->id]['login'] = $usa->email;
    $useransarr[$usa->id]['id'] = $usa->id;
    $useransarr[$usa->id]['answers'] = $tempansarr;
    $useransarr[$usa->id]['catanswers'] = $tempcatansarr;
    // dd($useransarr[]);
}
//dd($userswithanswers);
// $questions = Question::all();
// $users = User::whereIn('id', $user_ids)->get();
$questions = Question::orderBy('page')->where('event', '=', $exceleve)->where('page', '!=', 0)->orderBy('order')->get();
$categoryvendors = Categoryvendor::all();
// HEADER ROW FOR FOR EXCEL
$header1 = array();
$header1[] = '';
$header2 = array();
$header2[] = 'Login';
$preprojectnumber = '';
foreach ($questions as $header) {
    /*echo $header->class_name."<br>";
    	echo $header->question_group."<br>";*/
    if ($header->class_name != 'projects checkbox group') {
        //echo "1";
        $header1[] = $header->question_group;
        $header2[] = $header->question_text;
    } else {
        if ($header->question_group != $preprojectnumber) {