public function test()
{
$output = '<table>';
foreach (Centre::all() as $centre) {
$output .= '<tr><td>' . $centre->name . '</td><td>' . $centre->address . '</td><td>' . $centre->city->name . '</td><td>' . $centre->city->state->name . '</td><td>' . $centre->pincode . '</td></tr>';
}
$output .= '</table>';
return $output;
return PDF::loadView('admin.certi')->stream('certi_final.pdf');
// return View::make('admin.centrecerti');
// $pdf = PDF::loadView('admin.centrecerti');
// return $pdf->stream('certi.pdf');
$out = '<table>';
$out .= '<tr><td>Name</td><td>Address</td><td>City</td><td>Pincode</td></tr>';
$count = 0;
foreach (Centre::orderBy('city_id')->get() as $centre) {
$out .= '<tr><td>' . $centre->name . '</td><td>' . $centre->address . '</td><td>' . $centre->city->name . '</td><td>' . $centre->pincode . '</td></tr>';
}
// foreach (DB::table('results_2015')->where('rank','<','51')->where('kv',1)->get() as $user)
// {
// if(User::where('roll',$user->roll)->count()) {
// $users = User::where('roll',$user->roll)->first();
// if($users->status == 3 || $users->status == 5) {
//// dd($users);
// $out .= '<tr><td>'.$user->rank.'</td><td>'.$user->roll.'</td><td>'.$user->mobile.'</td><td>'.$users->name1.'</td><td>'.$users->name2.'</td><td>'.$user->path.'</td><td></td><td></td><td></td><td></td><td></td><td></td><td>'.$users->squad.'</td></tr>';
// }
// else {
// try {
// $out .= '<tr><td>'.$user->rank.'</td><td>'.$user->roll.'</td><td>'.$user->mobile.'</td><td>'.$users->name1.'</td><td>'.$users->name2.'</td><td>'.$users->school->name.'</td><td>'.$users->city->name.'</td><td>'.$users->school->address.'</td><td>'.$users->school->pincode.'</td><td>'.$users->school->contact.'</td><td>'.$users->contact1.'</td><td>'.$users->contact2.'</td><td>'.$users->squad.'</td></tr>';
// }catch (Exception $e) {
// return var_dump($users);
// }
// }
//// $count++;
// }
// }
// return $count;
return $out . '</table>';
$pdf = PDF::loadView('admin.certi');
return $pdf->stream('certi.pdf');
$det = '<table>';
foreach (City::orderBy('state_id')->get() as $city) {
$count = User::whereCityId($city->id)->count();
if ($count) {
$det .= '<tr><td>' . $city->name . '</td><td>' . $city->state->name . '</td><td>' . $count . '</td></tr>';
}
}
$det .= '</table>';
return $det;
// $list = '<table>';
// foreach(DB::table('results_2015')->where('rank','<','27')->where('kv','!=',1)->where('roll','LIKE',"H%")->get() as $res)
// {
// $user = User::whereRoll($res->roll)->first();
// if(!$user) {
// $name1 = 'User1';
// $name2 = 'User2';
// }
// else {
// $name1 = $user->name1;
// $name2 = $user->name2;
// }
// $list .= '<tr><td>'.$res->rank.'</td><td>'.$res->roll.'</td><td>'.$name1.'</td><td>'.$name2.'</td><td>'.$res->mobile.'</td><td>'.$res->path.'</td></tr>';
// }
// $list .= '</table>';
// return $list;
// $rolls = array('HE53600040','HE53600004','HE53600027','HE53600022','HE53600023','HE53600002','HE53600005','HE53600003','HE53600006','HE53600034','HE53600033','HE53600037','HE53600001','HE53600039','HE53600038','HE53600018','HE53600011','HE53600010','HE53600009','HE53600008','HE53600007','HE53600025','HE53600026','HE53600020','HE53600019','HE53600016','HE53600017','HE53600015','HE53600014','HE53600013','HE53600012');
// $list = '';
// foreach($rolls as $roll)
// {
// $old = User::whereRoll($roll)->first();
// $user = $old->replicate();
// $user->squad = 'JUNIOR';
// $lastroll = User::withTrashed()->where('roll', 'LIKE', "%JE5360%")->count();
// $roll = 'JE5360'.str_pad(strval($lastroll + 1), 4, "0", STR_PAD_LEFT);
// $user->roll = $roll;
// $user->comments = 'Change squad';
// $user->push();
// $list .= $old->roll.' '.$user->roll.'<br>';
// }
// return $list;
$user = User::whereRoll('HE52530018')->first();
return $user->roll . '<br>' . Crypt::decrypt($user->result_pass) . '<br>' . $user->name1 . '<br>' . $user->name2;
foreach (User::where('city_id', 21)->where('paid', 1)->get() as $user) {
$password = str_random(6);
$school = $user->school;
$user->password = Hash::make($password);
$user->save();
if ($user->email1 !== "") {
Queue::push(function ($job) use($user, $password, $school) {
Mail::send('emails.offline', array('user' => $user, 'school' => $school, 'password' => $password, 'name' => $user->name1), function ($message) use($user) {
$message->to($user->email1, $user->name1)->subject('Technothlon Registration Details');
});
$job->delete;
});
}
if ($user->email1 !== "") {
Queue::push(function ($job) use($user, $password, $school) {
Mail::send('emails.offline', array('user' => $user, 'school' => $school, 'password' => $password, 'name' => $user->name2), function ($message) use($user) {
$message->to($user->email2, $user->name2)->subject('Technothlon Registration Details');
});
$job->delete;
});
}
}
return View::make('emails.kvroll');
return $pdf = PDF::loadView('technopedia.onlineadmitcard')->stream('admit-cards/users/' . Auth::user()->get()->roll . '.pdf');
return View::make('technopedia.onlineadmitcard');
$schools = '';
foreach (Centre::all() as $centre) {
$count = User::where('centre_id', $centre->id)->count();
$schools .= $count . ' ' . ($centre->strength - $centre->left) . ' ' . $centre->id;
}
return $schools;
foreach (School::where('verified', 2)->get() as $school) {
$junior = User::where('school_id', $school->id)->where('squad', 'JUNIOR')->count();
$hauts = User::where('school_id', $school->id)->where('squad', 'HAUTS')->count();
$schools .= $school->name . '<br>' . $school->address . '<br>' . $school->city->name . ' Pin: ' . $school->pincode . '<br>' . $school->city->state->name . '<br>Ph.: ' . $school->contact . '<br>Junior:' . $junior . ' Hauts: ' . $hauts . '<br><br>';
}
return $schools;
// return View::make('admin.test');
}