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; }
public function postDeleteuser() { $userid = Input::get('id'); $user = User::find($userid); $event = Input::get('event'); $useranswers = Answer::where('user_id', '=', $userid)->get(); $userranks = Supplierrank::where('userid', '=', $userid)->get(); if ($event == "Rescom Summit Bangalore 2016") { $qid1 = "3124"; } if ($event == "Design Mission Turkey 2016") { $qid1 = "5707"; } if ($event == "Design Mission South West 2016") { $qid1 = "5197"; } if ($event == "Design Mission South Africa 2016") { $qid1 = "4687"; } if ($event == "Design Mission Saudi Arabia 2016") { $qid1 = "3667"; } if ($event == "Design Mission North East 2016") { $qid1 = "4177"; } if ($event == "Design Mission Asia 2016") { $qid1 = "6217"; } if ($event == "Healthscape Series 2016") { $qid1 = "6727"; } if ($event == "Hotelier Summit Africa 2016") { $qid1 = "7205"; } if ($event == "Design Mission Middle East 2016") { $qid1 = "7654"; } if ($event == "Hotelier Summit India Ose 2016") { $qid1 = "8103"; } if ($event == "Hotelier Summit India Ffe 2016") { $qid1 = "8552"; } foreach ($userranks as $rank) { $rank->delete(); } foreach ($useranswers as $answer) { $answer->delete(); } $user->delete(); $users = User::where('event', '=', $event)->orderby('name')->with(array('answer' => function ($q) use($qid1) { $q->where('question_id', '=', $qid1)->orWhere('question_id', '=', $qid1 + 1); }))->get(); return Redirect::to('admin/listuser')->with(array('liusers' => $users, 'liev' => $event, 'createusermessage' => 'User records Deleted')); }
<?php // require('http://localhost:8000/app/libs/excel/Classes/PHPExcel.php'); require app_path() . '/libs/excel/Classes/PHPExcel.php'; $objPHPExcel = new PHPExcel(); // Set document properties $objPHPExcel->getProperties()->setCreator("ideonline.com")->setLastModifiedBy("ideonline.com")->setTitle("Office 2007 XLSX Test Document")->setSubject("Office 2007 XLSX Test Document")->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")->setKeywords("office 2007 openxml php")->setCategory("Test result file"); // Add some data //*************************************************************************************** $arr = array(); $ansarr = array(); $curruser = ''; $firstpass = true; //$usersandranking = User::where('event','=',$exceleve)->with('userandrank')->get(); $usersandranking = Supplierrank::where('userid', '=', $delid)->with('supplier')->with('user')->orderBy('userid')->orderBy('rank')->get(); foreach ($usersandranking as $userrank) { //dd($userrank); // $arr[]=array('Buyer Company Name','Vendor Company Name','Buyer Person Name','Buyer person designation','Rank',); 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 = ''; //dd($answer->question_text); // dd($answer->answers); foreach ($answer->answers as $ans) { // dd($ans->answer_text);
// require('http://localhost:8000/app/libs/excel/Classes/PHPExcel.php'); require app_path() . '/libs/excel/Classes/PHPExcel.php'; $objPHPExcel = new PHPExcel(); // Set document properties $objPHPExcel->getProperties()->setCreator("ideonline.com")->setLastModifiedBy("ideonline.com")->setTitle("Office 2007 XLSX Test Document")->setSubject("Office 2007 XLSX Test Document")->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")->setKeywords("office 2007 openxml php")->setCategory("Test result file"); // Add some data //*************************************************************************************** $arr = array(); $ansarr = array(); $curruser = ''; $firstpass = true; $users = User::where('event', '=', $exceleve)->get(); //$usersandranking = User::where('event','=',$exceleve)->with('userandrank')->get(); // $usersandranking=Supplierrank::with('supplier')->with('user')->orderBy('userid')->orderBy('rank')->get(); $usersandranking = Supplierrank::with('supplier')->with(array('user' => function ($query) use($exceleve) { $query->where('event', '=', $exceleve); }))->orderBy('userid')->orderBy('rank')->get(); // dd($usersandranking); foreach ($usersandranking as $userrank) { if (is_null($userrank) || is_null($userrank->user) || is_null($userrank->supplier)) { } else { //dd($userrank); // $arr[]=array('Buyer Company Name','Vendor Company Name','Buyer Person Name','Buyer person designation','Rank',); 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('event', '=', $exceleve)->where('page', '=', 1)->with(array('answers' => function ($query) use($userrank) { $query->where('user_id', '=', $userrank->user->id); }))->get();