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();
