/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$menu = Menu::where('tipe', Sentry::getUser()->last_name)->get();
$school = School::where('user_id', Sentry::getUser()->id)->first();
$profile = School::find($school->id);
return View::make('profile.index', compact('profile'))->withTitle('Profile')->with('menu', $menu);
}
protected static function boot()
{
parent::boot();
static::creating(function ($model) {
$data = array('municipality_id' => $model->municipality_id, 'name' => $model->name);
$rules = array('municipality_id' => 'required|integer|min:1|max:300000', 'name' => 'required|min:3|max:50');
$validator = Validator::make($data, $rules);
if ($validator->fails()) {
throw new ValidationException(null, null, null, $validator->messages());
} else {
return $model->validate();
}
});
static::updating(function ($model) {
$data = array('municipality_id' => $model->municipality_id, 'name' => $model->name);
$rules = array('municipality_id' => 'required|integer|min:1|max:300000', 'name' => 'required|min:3|max:50');
$validator = Validator::make($data, $rules);
if ($validator->fails()) {
throw new ValidationException(null, null, null, $validator->messages());
} else {
return true;
}
});
static::deleting(function ($model) {
$schools = School::where('city_id', '=', $model->id)->get();
foreach ($schools as $school) {
$school = School::find($school->id)->delete();
}
return true;
});
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store($schoolName, $surveyName, $groupName)
{
if (Auth::check()) {
$user = Auth::user();
} else {
return Redirect::back();
}
if ($user->group->name != $groupName) {
return Redirect::back();
}
$school = School::where('name', '=', $schoolName)->first();
$survey = $school->surveys()->where('name', $surveyName)->first();
$group = $survey->groups()->where('name', $groupName)->first();
if (strtotime($group->pivot->close_time) < time()) {
return Redirect::back()->with('state', 'error')->with('error', 'You can no longer edit and save your answers. The survey has closed and your edits have been discarded.');
}
//Store a filled out survey. This is when the user clicks the submit button.
foreach (Input::all() as $origMark => $answer) {
$answers[$origMark] = $answer;
}
unset($answers['_token']);
$path = app_path() . "/answers/{$user->id}.ans";
if (File::exists($path)) {
$answerStore = json_decode(File::get($path), true);
}
$answerStore[$user->id] = $answers;
File::put($path, json_encode($answerStore));
return Redirect::back();
}
<section class="content">
@if(isset($schools))
<div class="row">
<div class="col-sm-3">
<h4>Offline: {{ User::where('city_id',$city)->where('paid',1)->count() }}</h4>
</div>
<div class="col-sm-3">
<h4>Online: {{ User::where('centre_city',$city.'0')->where('paid',0)->count() }}</h4>
</div>
<div class="col-sm-3">
<h4>Collected in Summer: {{ User::where('city_id',$city)->where('paid',1)->where('status',1)->count() }}</h4>
</div>
</div>
@foreach($schools as $school_id)
<?php
$school = School::where('id', $school_id['school_id'])->first();
?>
<div class="row">
<div class="col-md-12">
<div class="box box-default collapsed-box">
<div class="box-header">
<h3 class="box-title">{{ $school->name }} (Regs: {{ User::where('school_id',$school->id)->where('paid',1)->count() }})</h3>
<div class="box-tools pull-right">
<button class="btn btn-box-tool" data-widget="collapse"><i class="fa fa-plus"></i></button>
</div>
</div>
<div class="box-body table-responsive" style="display: none">
<table id="{{ $school->id }}" class="table table-bordered table-striped table-hover dataTable school">
<thead>
<tr>
<th>Name 1</th>
public function loadSchools($name)
{
$schools = School::where('name', 'like', "%{$name}%")->take(5)->get();
return $schools->toJson();
}
public function invoice()
{
$jenjang = Sentry::getUser()->last_name;
$cost = Setting::first();
$school = School::where('user_id', Sentry::getUser()->id)->first();
$payment = Payment::where('user_id', Sentry::getUser()->id)->where(DB::raw('year'), '=', date('Y'))->first();
if ($jenjang === 'SMA') {
$runpas = Contest::where('nocontest', 'Lari 100m pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$runpis = Contest::where('nocontest', 'Lari 100m pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ljpas = Contest::where('nocontest', 'Lompat Jauh pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ljpis = Contest::where('nocontest', 'Lompat Jauh pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$tppas = Contest::where('nocontest', 'Tolak Peluru pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$tppis = Contest::where('nocontest', 'Tolak Peluru pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ltpas = Contest::where('nocontest', 'Lompat Tinggi pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ltpis = Contest::where('nocontest', 'Lompat Tinggi pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$sertatl = Contest::where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->whereNotNull('nodada')->where('sertifikat', 1)->count();
$sertoff = Officer::where('user_id', Sentry::getUser()->id)->where(DB::raw('YEAR(created_at)'), '=', date('Y'))->where('sertifikat', 1)->count();
$book = Docbook::where('user_id', Sentry::getUser()->id)->where(DB::raw('YEAR(created_at)'), '=', date('Y'))->where('docbook', 1)->count();
$jrunpas = $runpas * $cost->moneyreg;
$jrunpis = $runpis * $cost->moneyreg;
$jljpas = $ljpas * $cost->moneyreg;
$jljpis = $ljpis * $cost->moneyreg;
$jtppas = $tppas * $cost->moneyreg;
$jtppis = $tppis * $cost->moneyreg;
$jltpas = $ltpas * $cost->moneyreg;
$jltpis = $ltpis * $cost->moneyreg;
$jsertatl = $sertatl * $cost->moneysertatl;
$jsertoff = $sertoff * $cost->moneysertoff;
$jbook = $book * $cost->moneydocbook;
$jtotal = $jrunpas + $jrunpis + $jljpas + $jljpis + $jtppas + $jtppis + $jltpas + $jltpis + $jsertatl + $jsertoff + $jbook;
return View::make('costs.invoice2')->with('runpas', $runpas)->with('runpis', $runpis)->with('ljpas', $ljpas)->with('ljpis', $ljpis)->with('tppas', $tppas)->with('tppis', $tppis)->with('ltpas', $ltpas)->with('ltpis', $ltpis)->with('sertatl', $sertatl)->with('sertoff', $sertoff)->with('book', $book)->with('jrunpas', $jrunpas)->with('jrunpis', $jrunpis)->with('jljpas', $jljpas)->with('jljpis', $jljpis)->with('jtppas', $jtppas)->with('jtppis', $jtppis)->with('jltpas', $jltpas)->with('jltpis', $jltpis)->with('jsertatl', $jsertatl)->with('jsertoff', $jsertoff)->with('jbook', $jbook)->with('jtotal', $jtotal)->with('cost', $cost)->with('school', $school)->with('payment', $payment);
} elseif ($jenjang === 'SMP') {
$runpas = Contest::where('nocontest', 'Lari 60m pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$runpis = Contest::where('nocontest', 'Lari 60m pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ljpas = Contest::where('nocontest', 'Lompat Jauh pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ljpis = Contest::where('nocontest', 'Lompat Jauh pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$tppas = Contest::where('nocontest', 'Tolak Peluru pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$tppis = Contest::where('nocontest', 'Tolak Peluru pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ltpas = Contest::where('nocontest', 'Lompat Tinggi pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ltpis = Contest::where('nocontest', 'Lompat Tinggi pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$sertatl = Contest::where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->whereNotNull('nodada')->where('sertifikat', 1)->count();
$sertoff = Officer::where('user_id', Sentry::getUser()->id)->where(DB::raw('YEAR(created_at)'), '=', date('Y'))->where('sertifikat', 1)->count();
$book = Docbook::where('user_id', Sentry::getUser()->id)->where(DB::raw('YEAR(created_at)'), '=', date('Y'))->where('docbook', 1)->count();
$jrunpas = $runpas * $cost->moneyreg;
$jrunpis = $runpis * $cost->moneyreg;
$jljpas = $ljpas * $cost->moneyreg;
$jljpis = $ljpis * $cost->moneyreg;
$jtppas = $tppas * $cost->moneyreg;
$jtppis = $tppis * $cost->moneyreg;
$jltpas = $ltpas * $cost->moneyreg;
$jltpis = $ltpis * $cost->moneyreg;
$jsertatl = $sertatl * $cost->moneysertatl;
$jsertoff = $sertoff * $cost->moneysertoff;
$jbook = $book * $cost->moneydocbook;
$jtotal = $jrunpas + $jrunpis + $jljpas + $jljpis + $jtppas + $jtppis + $jltpas + $jltpis + $jsertatl + $jsertoff + $jbook;
return View::make('costs.invoice2')->with('runpas', $runpas)->with('runpis', $runpis)->with('ljpas', $ljpas)->with('ljpis', $ljpis)->with('tppas', $tppas)->with('tppis', $tppis)->with('ltpas', $ltpas)->with('ltpis', $ltpis)->with('sertatl', $sertatl)->with('sertoff', $sertoff)->with('book', $book)->with('jrunpas', $jrunpas)->with('jrunpis', $jrunpis)->with('jljpas', $jljpas)->with('jljpis', $jljpis)->with('jtppas', $jtppas)->with('jtppis', $jtppis)->with('jltpas', $jltpas)->with('jltpis', $jltpis)->with('jsertatl', $jsertatl)->with('jsertoff', $jsertoff)->with('jbook', $jbook)->with('jtotal', $jtotal)->with('cost', $cost)->with('school', $school)->with('payment', $payment);
} elseif ($jenjang === 'SD') {
$runpas = Contest::where('nocontest', 'Lari 50m pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$runpis = Contest::where('nocontest', 'Lari 50m pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ljpas = Contest::where('nocontest', 'Lompat Jauh pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$ljpis = Contest::where('nocontest', 'Lompat Jauh pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$lbpas = Contest::where('nocontest', 'Lempar Bola pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$lbpis = Contest::where('nocontest', 'Lempar Bola pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$lespa = Contest::where('nocontest', 'Lari Estafet pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$lespi = Contest::where('nocontest', 'Lari Estafet pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->count();
$sertatl = Contest::where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->where('verifikasi', 1)->whereNotNull('nodada')->where('sertifikat', 1)->count();
$sertoff = Officer::where('user_id', Sentry::getUser()->id)->where(DB::raw('YEAR(created_at)'), '=', date('Y'))->where('sertifikat', 1)->count();
$book = Docbook::where('user_id', Sentry::getUser()->id)->where(DB::raw('YEAR(created_at)'), '=', date('Y'))->where('docbook', 1)->count();
$jrunpas = $runpas * $cost->moneyreg;
$jrunpis = $runpis * $cost->moneyreg;
$jljpas = $ljpas * $cost->moneyreg;
$jljpis = $ljpis * $cost->moneyreg;
$jlbpas = $lbpas * $cost->moneyreg;
$jlbpis = $lbpis * $cost->moneyreg;
if ($lespa % 8 == 0) {
$lespa = $lespa / 8;
$jlespa = $lespa * $cost->moneyregest;
} else {
$lespa = 0;
$jlespa = $lespa * $cost->moneyregest;
}
if ($lespi % 8 == 0) {
$lespi = $lespi / 8;
$jlespi = $lespi * $cost->moneyregest;
} else {
$lespi = 0;
$jlespi = $lespi * $cost->moneyregest;
}
$jsertatl = $sertatl * $cost->moneysertatl;
$jsertoff = $sertoff * $cost->moneysertoff;
$jbook = $book * $cost->moneydocbook;
$jtotal = $jrunpas + $jrunpis + $jljpas + $jljpis + $jlbpas + $jlbpis + $jlespa + $jlespi + $jsertatl + $jsertoff + $jbook;
return View::make('costs.invoice2')->with('runpas', $runpas)->with('runpis', $runpis)->with('ljpas', $ljpas)->with('ljpis', $ljpis)->with('lbpas', $lbpas)->with('lbpis', $lbpis)->with('lespa', $lespa)->with('lespi', $lespi)->with('sertatl', $sertatl)->with('sertoff', $sertoff)->with('book', $book)->with('jrunpas', $jrunpas)->with('jrunpis', $jrunpis)->with('jljpas', $jljpas)->with('jljpis', $jljpis)->with('jlbpas', $jlbpas)->with('jlbpis', $jlbpis)->with('jlespa', $jlespa)->with('jlespi', $jlespi)->with('jsertatl', $jsertatl)->with('jsertoff', $jsertoff)->with('jbook', $jbook)->with('jtotal', $jtotal)->with('cost', $cost)->with('school', $school)->with('payment', $payment);
}
}
/**
* Remove the specified school from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$sekolah = School::where('id', $id)->first();
// User::where('id', $sekolah->user_id)->delete($id);
$data['activated'] = 0;
User::where('id', $sekolah->user_id)->update($data);
School::destroy($id);
return Redirect::route('admin.daftarsekolah')->with('successMessage', 'Sekolah berhasil dihapus');
}
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');
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($schoolName, $surveyName)
{
if (!Auth::check() || Auth::user()->group->name != "Admin") {
return Redirect::back();
}
//We need to figure out what kind of post we are getting.
$school = School::where('name', '=', $schoolName)->first();
$survey = $school->surveys()->where('name', $surveyName)->first();
$name = Input::get('name');
$questions = Input::get('questions');
$rules = array('name' => 'required|alpha_num');
$fields['questions'] = NULL;
$validator;
if (Input::has('changeName')) {
$fields['name'] = $name;
$validator = Validator::make($fields, $rules);
if (!$validator->fails()) {
if (is_null($school->surveys()->where('name', $fields['name'])->first())) {
$survey->name = $fields['name'];
$survey->save();
return Redirect::to("/schools/{$school->name}/{$survey->name}")->withInput(array('questions' => $questions));
} else {
$fields['name'] = "{$fields['name']} already exists under {$school->name}.";
}
}
} else {
if (Input::has('changeQuestions')) {
$fields['questions'] = Survey::parseQuestionStore($questions, $school->id);
if ($fields['questions'][0]) {
File::put(app_path() . "/questions/{$survey->id}.qs", $questions);
}
$validator = Validator::make(array('name' => 'present'), $rules);
} else {
$fields = array('time' => 'Default');
$rules = array('time' => 'required');
$submitName = '';
$fieldName = '';
$group = NULL;
foreach ($school->groups as $potentialGroup) {
if (Input::has("{$potentialGroup->name}ChangeOpen")) {
$submitName = 'ChangeOpen';
$fieldName = 'openTime';
$group = $potentialGroup;
break;
} else {
if (Input::has("{$potentialGroup->name}OpenNow")) {
$submitName = 'OpenNow';
$group = $potentialGroup;
break;
} else {
if (Input::has("{$potentialGroup->name}ChangeClose")) {
$submitName = 'ChangeClose';
$fieldName = 'closingTime';
$group = $potentialGroup;
break;
} else {
if (Input::has("{$potentialGroup->name}CloseNow")) {
$submitName = 'CloseNow';
$group = $potentialGroup;
break;
}
}
}
}
}
if (strpos($submitName, 'Change') === 0) {
$fields['time'] = Input::get("{$fieldName}{$group->name}");
$rules['time'] = 'required|date_format:Y-m-d H:i:s';
} else {
$now = date("Y-m-d H:i:s");
$later = date("Y-m-d H:i:s", time() + 365 * 24 * 60 * 60);
}
$validator = Validator::make($fields, $rules);
if ($validator->fails()) {
$fields['time'] = "{$fieldName}{$group->name}";
} else {
if (!$group->surveys->contains($survey->id)) {
$group->surveys()->attach($survey->id);
}
$group = $survey->groups()->where('group_id', $group->id)->first();
switch ($submitName) {
case 'ChangeOpen':
$group->pivot->open_time = $fields['time'];
break;
case 'ChangeClose':
$group->pivot->close_time = $fields['time'];
break;
case 'OpenNow':
$group->pivot->open_time = $now;
$group->pivot->close_time = $later;
break;
case 'CloseNow':
$group->pivot->open_time = $later;
$group->pivot->close_time = $now;
break;
default:
throw new Exception('Error in submission, not a valid submit type.');
}
$group->pivot->save();
}
}
}
return Redirect::back()->withInput(array('questions' => $questions, 'name' => $name))->withErrors($validator)->with('fields', $fields);
}
public function postEditSchool($id)
{
$user = User::find($id);
$schools = School::where('user_id', $id)->first();
$schools->update(['primary_name' => Input::get('primary_name'), 'primary_address' => Input::get('primary_address'), 'primary_years' => Input::get('primary_years'), 'secondary_name' => Input::get('secondary_name'), 'secondary_address' => Input::get('secondary_address'), 'secondary_years' => Input::get('secondary_years'), 'tertiary_name' => Input::get('tertiary_name'), 'tertiary_address' => Input::get('tertiary_address'), 'tertiary_years' => Input::get('tertiary_years')]);
$audit = AuditTrail::create(['user_id' => Auth::id(), 'role' => 'Employee Management Admin', 'action' => 'edited ' . $user->firstname . ' ' . $user->lastname . '\'s School Information.']);
return Redirect::route('profile', $id)->with('alert', 'success|School Information has been updated.');
}
public function test2()
{
$error = "";
$regs = DB::table('registration')->get();
foreach ($regs as $reg) {
$user = new User();
$user->name1 = strtoupper($reg->name1);
$user->name2 = strtoupper($reg->name2);
$user->email1 = $reg->email1;
$user->email2 = $reg->email2;
$user->contact1 = $reg->contact1;
$user->contact2 = $reg->contact2;
$user->squad = $reg->squad;
$user->language = $reg->language;
$school = strtoupper($reg->school);
$city_name = ucwords(strtolower($reg->city));
if (School::where('name', $school)->count() && City::where('name', $city_name)->count()) {
$cityid = City::where('name', $city_name)->first();
$school_name = School::where('name', $school)->where('city_id', $cityid->id)->first();
$user->school_id = $school_name->id;
$user->city_id = $cityid->id;
$user->centre_city = $cityid->id * 10;
$roll = "";
if ($reg->squad === 'JUNIOR') {
$roll = "J";
} else {
$roll = "H";
}
if ($reg->language === 'en') {
$roll .= "E";
} else {
$roll .= "H";
}
$roll .= strval($cityid->code) . '0';
$lastroll = User::withTrashed()->where('roll', 'LIKE', "%{$roll}%")->count();
$roll .= str_pad(strval($lastroll + 1), 4, "0", STR_PAD_LEFT);
$user->roll = $roll;
$user->year = 2015;
$user->paid = true;
$user->comments = $reg->comments;
$user->save();
} else {
if (School::where('name', $school)->count()) {
$error .= $city_name . '<br>';
} elseif (City::where('name', $city_name)->count()) {
$error .= $school . '<br>';
} else {
$error .= $school . ' ' . $city_name;
}
}
}
// Auth::logout();
return View::make('layouts.test3')->with('error', $error);
}
public function postEditOwnSchool($id)
{
$audit = AuditTrail::create(['user_id' => Auth::id(), 'role' => 'User', 'action' => 'edited School Information']);
$schools = School::where('user_id', $id)->first();
$schools->update(['primary_name' => Input::get('primary_name'), 'primary_address' => Input::get('primary_address'), 'primary_years' => Input::get('primary_years'), 'secondary_name' => Input::get('secondary_name'), 'secondary_address' => Input::get('secondary_address'), 'secondary_years' => Input::get('secondary_years'), 'tertiary_name' => Input::get('tertiary_name'), 'tertiary_address' => Input::get('tertiary_address'), 'tertiary_years' => Input::get('tertiary_years')]);
return Redirect::route('profile', $id)->with('alert', 'success|School Information has been updated.');
}
public function getBySchoolBoard($board_id)
{
return School::where('schoolboard_id', '=', $board_id)->orderBy('school_name')->get();
}
