public function index()
{
// $this->layout->content =
if (Sentry::getUser()->hasPermission('admin')) {
return View::make('dashboard.indexadmin')->withtitle("Dashboard Admin");
} elseif (Sentry::getUser()->hasPermission('panitia')) {
return View::make('dashboard.indexadmin')->withtitle("Dashboard Panitia");
} elseif (Sentry::getUser()->hasPermission('user')) {
$menu = Menu::where('tipe', Sentry::getUser()->last_name)->get();
$jenjang = Sentry::getUser()->last_name;
if ($jenjang === 'SMA') {
$runpas = Contest::where('nocontest', 'Lari 100m pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$runpis = Contest::where('nocontest', 'Lari 100m pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$ljpas = Contest::where('nocontest', 'Lompat Jauh pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$ljpis = Contest::where('nocontest', 'Lompat Jauh pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$tppas = Contest::where('nocontest', 'Tolak Peluru pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$tppis = Contest::where('nocontest', 'Tolak Peluru pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$ltpas = Contest::where('nocontest', 'Lompat Tinggi pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$ltpis = Contest::where('nocontest', 'Lompat Tinggi pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$juma = Contest::where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$jumpa = $runpas + $ljpas + $tppas + $ltpas;
$jumpi = $runpis + $ljpis + $tppis + $ltpis;
return View::make('dashboard.indexuser')->withtitle("Dashboard User")->with('menu', $menu)->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('juma', $juma)->with('jumpa', $jumpa)->with('jumpi', $jumpi);
} elseif ($jenjang === 'SMP') {
$runpas = Contest::where('nocontest', 'Lari 60m pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$runpis = Contest::where('nocontest', 'Lari 60m pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$ljpas = Contest::where('nocontest', 'Lompat Jauh pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$ljpis = Contest::where('nocontest', 'Lompat Jauh pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$tppas = Contest::where('nocontest', 'Tolak Peluru pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$tppis = Contest::where('nocontest', 'Tolak Peluru pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$ltpas = Contest::where('nocontest', 'Lompat Tinggi pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$ltpis = Contest::where('nocontest', 'Lompat Tinggi pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$juma = Contest::where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$jumpa = $runpas + $ljpas + $tppas + $ltpas;
$jumpi = $runpis + $ljpis + $tppis + $ltpis;
return View::make('dashboard.indexuser')->withtitle("Dashboard User")->with('menu', $menu)->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('juma', $juma)->with('jumpa', $jumpa)->with('jumpi', $jumpi);
} elseif ($jenjang === 'SD') {
$runpas = Contest::where('nocontest', 'Lari 50m pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$runpis = Contest::where('nocontest', 'Lari 50m pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$ljpas = Contest::where('nocontest', 'Lompat Jauh pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$ljpis = Contest::where('nocontest', 'Lompat Jauh pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$lbpas = Contest::where('nocontest', 'Lempar Bola pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$lbpis = Contest::where('nocontest', 'Lempar Bola pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$lespa = Contest::where('nocontest', 'Lari Estafet pa')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$lespi = Contest::where('nocontest', 'Lari Estafet pi')->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$juma = Contest::where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', date('Y'))->count();
$jumpa = $runpas + $ljpas + $lbpas + $lespa;
$jumpi = $runpis + $ljpis + $lbpis + $lespi;
return View::make('dashboard.indexuser')->withtitle("Dashboard User")->with('menu', $menu)->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('juma', $juma)->with('jumpa', $jumpa)->with('jumpi', $jumpi);
}
}
}
public function create2($id)
{
$menu = Menu::where('tipe', Sentry::getUser()->last_name)->get();
$menus = Menu::find($id);
$date = \Carbon\Carbon::now();
$thn = date('Y');
$tgl = new DateTime(date('Y-m-d'));
$limit = Setting::first();
$limitdtstart = new DateTime($limit->startdayreg);
$limitdtend = new DateTime($limit->enddayreg);
$limitstart = $limitdtstart->diff($tgl)->format('%R%a');
$limitend = $limitdtend->diff($tgl)->format('%R%a');
$contest = Contest::where('nocontest', $menus->menu)->where('user_id', Sentry::getUser()->id)->where(DB::raw('tahun'), '=', $thn)->count();
// dd($limitend);
if ($limitstart < 0) {
return Redirect::route('user.contests.index')->with('errorMessage', trans('Pendaftaran Lomba Belum Dibuka.'));
}
if ($limitend > 0) {
return Redirect::route('user.contests.index')->with('errorMessage', trans('Pendaftaran Lomba Sudah Ditutup.'));
}
if ($contest < 2) {
return View::make('contests.create')->withTitle('Estafet')->with('menu', $menu)->with('menus', $menus);
} else {
if ($menus->menu == 'Lari Estafet pa' and $contest < 8) {
return View::make('contests.create')->withTitle('Estafet')->with('menu', $menu)->with('menus', $menus);
} else {
if ($menus->menu == 'Lari Estafet pi' and $contest < 8) {
return View::make('contests.create')->withTitle('Estafet')->with('menu', $menu)->with('menus', $menus);
} else {
return Redirect::route('user.contests.index')->with('errorMessage', trans('Lomba sudah penuh.'));
}
}
}
}
public function exportseratlet()
{
Session::put('sattahun', Input::get('tahun'));
Session::put('satjenjang', Input::get('jenjang'));
$seratlets = Contest::where('tahun', Session::get('sattahun'))->where('jenjang', Session::get('satjenjang'))->where('verifikasi', '1')->where('nodada', '!=', '')->where('sertifikat', '1')->orderBy('user_id', 'asc')->get();
return $this->exportExcelseratlet($seratlets);
}
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);
}
}
public function validasi($id)
{
//Start - update status validasi
$payment = Payment::findOrFail($id);
$data['verifikasi'] = 1;
$payment->update($data);
//End - upate status validasi
//Start - ambil data atlit yang sudah terverifikasi berdasarkan tahun
$getatlit = Contest::where('user_id', $payment->user_id)->where('tahun', date('Y'))->where('verifikasi', '1')->get();
//End - ambil data atlit yang sudah terverifikasi berdasarkan tahun
//Start - ambil jumlah data atlit yang sudah terverifikasi berdasarkan tahun
$getsumatlit = Contest::where('user_id', $payment->user_id)->where('tahun', date('Y'))->where('verifikasi', '1')->count();
//End - ambil jumlah data atlit yang sudah terverifikasi berdasarkan tahun
//Start - lihat jenjang dari bukti pembayaran
$jenjang = Payment::where('id', $id)->with('Akun')->first();
//End - lihat jenjang dari bukti pembayaran
for ($i = 0; $i < $getsumatlit; $i++) {
//Start - Ambil urutan nomor dada sesuai jenjang
$posno = Sequent::where('jenjang', $jenjang->Akun->last_name)->first();
$nodadanow = $posno->number + 1;
//End - Ambil urutan nomor dada sesuai jenjang
//Start - Ambil 1 altit yang akan diberikan nomor dengan mengambil id
$getatlit = Contest::where('user_id', $payment->user_id)->where('tahun', date('Y'))->where('verifikasi', '1')->skip($i)->take(1)->first();
$getidatlit = $getatlit->id;
//End - Ambil 1 altit yang akan diberikan nomor dengan mengambil id
//Start - Update atlit dengan memberi nomor dada
$contest = Contest::findOrFail($getidatlit);
$nodada['nodada'] = str_pad($nodadanow, 3, '0', STR_PAD_LEFT);
$contest->update($nodada);
//End - Update atlit dengan memberi nomor dada
//Start - Update nomer pada table sequent
$sequent = Sequent::findOrFail($posno->id);
$datano['number'] = $nodadanow;
$sequent->update($datano);
//End - Update nomer pada table sequent
}
return Redirect::to('admin/valid' . '?statvalid=' . Session::get('statusvalid'))->with("successMessage", "Berhasil divalidasi");
}
