public function carianPost()
{
$tarikh = Request::get('tarikh');
$bil = 1;
$statuses = [];
$data[1] = $data[2] = $data[3] = $data[4] = 0;
$cawangans = Cawangan::all();
foreach ($cawangans as $cawangan) {
$details = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan->id)->get();
// dd($details);
if ($details->isEmpty()) {
array_push($statuses, ['cawangan' => $cawangan->nama, 'status' => 'BELUM DIREKOD']);
Session::flash('error', 'Tiada data.');
} else {
array_push($statuses, ['cawangan' => $cawangan->nama, 'status' => 'TELAH DIREKOD']);
$jumlah = 0;
foreach ($details as $detail) {
$jumlah += $detail->jumlah;
}
$data[$cawangan->id] = $jumlah;
}
}
$yourFirstChart["chart"] = array("type" => "bar");
$yourFirstChart["title"] = array("text" => "Tarikh : " . Carbon::parse($tarikh)->format('d-m-Y'));
$yourFirstChart["xAxis"] = array("categories" => ['Alor Setar', 'Pokok Sena', 'Sungai Petani', 'Parol']);
$yourFirstChart["yAxis"] = array("title" => array("text" => "Bilangan Banduan / Tahanan"));
$yourFirstChart["series"] = [array("name" => "JUMLAH KESELURUHAN", "data" => [$data[1], $data[2], $data[3], $data[4]])];
return View('members.carian.result', compact('bil', 'cawangans', 'statuses', 'yourFirstChart'));
}
public function parol($cawangan, $tarikh)
{
$cawangan_id = Cawangan::where('nama', $cawangan)->first();
$cawangan_id = $cawangan_id->id;
$flag = false;
$details = Details::where('cawangan_id', $cawangan_id)->where('tarikh', 'like', $tarikh . '%')->get();
$datas = [];
if (!$details->isEmpty()) {
$flag = true;
for ($kesalahan = 17; $kesalahan <= 23; $kesalahan++) {
for ($bangsa = 1; $bangsa <= 3; $bangsa++) {
for ($jantina = 1; $jantina <= 2; $jantina++) {
$detail = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', 4)->where('warganegara_id', 1)->where('bangsa_id', $bangsa)->where('kesalahan_id', $kesalahan)->where('jantina_id', $jantina)->first();
array_push($datas, ['1_' . $bangsa . '_' . $kesalahan . '_' . $jantina => $detail->jumlah]);
}
}
}
}
return View('members.rekod.cetak.details_parol_cetak', compact('tarikh', 'cawangan', 'flag', 'datas'));
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$cawangans = Cawangan::all();
for ($day = 15; $day <= 20; $day++) {
if ($day < 10) {
$days = '0' . $day;
} else {
$days = $day;
}
$tarikh = '2015-10-' . $days;
foreach ($cawangans as $cawangan) {
if ($cawangan->id == 1) {
$count = 16;
} else {
$count = 14;
}
for ($kesalahan = 1; $kesalahan <= $count; $kesalahan++) {
// Warganegara
for ($warga = 1; $warga <= 3; $warga++) {
if ($warga == 1) {
for ($jantina = 1; $jantina <= 2; $jantina++) {
for ($bangsa = 1; $bangsa <= 3; $bangsa++) {
Details::create(['tarikh' => $tarikh, 'cawangan_id' => $cawangan->id, 'warganegara_id' => $warga, 'bangsa_id' => $bangsa, 'kesalahan_id' => $kesalahan, 'jantina_id' => $jantina, 'jumlah' => rand(0, 30)]);
}
}
} else {
for ($bangsa = 4; $bangsa <= 4; $bangsa++) {
for ($jantina = 1; $jantina <= 2; $jantina++) {
Details::create(['tarikh' => $tarikh, 'cawangan_id' => $cawangan->id, 'warganegara_id' => $warga, 'bangsa_id' => $bangsa, 'kesalahan_id' => $kesalahan, 'jantina_id' => $jantina, 'jumlah' => rand(0, 123)]);
}
}
}
// end if else warga
}
// end warga
}
//end kesalahan
}
}
}
protected function getRingkasan4($date, $cawangan)
{
$tarikh = $date;
$data = [];
// ALOR SETAR - Melayu Lelaki
$count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('bangsa_id', 1)->where('jantina_id', 1)->sum('jumlah');
array_push($data, ['jumlah' => $count]);
// Melayu - Perempuan
$count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('bangsa_id', 1)->where('jantina_id', 2)->sum('jumlah');
array_push($data, ['jumlah' => $count]);
// ALOR SETAR - Cina Lelaki
$count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('bangsa_id', 2)->where('jantina_id', 1)->sum('jumlah');
array_push($data, ['jumlah' => $count]);
// Cina - Perempuan
$count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('bangsa_id', 2)->where('jantina_id', 2)->sum('jumlah');
array_push($data, ['jumlah' => $count]);
// ALOR SETAR - India Lelaki
$count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('bangsa_id', 3)->where('jantina_id', 1)->sum('jumlah');
array_push($data, ['jumlah' => $count]);
// India - Perempuan
$count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('bangsa_id', 3)->where('jantina_id', 2)->sum('jumlah');
array_push($data, ['jumlah' => $count]);
// B. Warga Lelaki
$count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('warganegara_id', 2)->where('jantina_id', 1)->sum('jumlah');
array_push($data, ['jumlah' => $count]);
// B. Warga Perempuan
$count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('warganegara_id', 2)->where('jantina_id', 2)->sum('jumlah');
array_push($data, ['jumlah' => $count]);
// Lain-lain Lelaki
$count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('warganegara_id', 3)->where('jantina_id', 1)->sum('jumlah');
array_push($data, ['jumlah' => $count]);
// Lain-lain Perempuan
$count = Details::where('tarikh', 'like', $tarikh . '%')->where('cawangan_id', $cawangan)->where('warganegara_id', 3)->where('jantina_id', 2)->sum('jumlah');
array_push($data, ['jumlah' => $count]);
return $data;
}
public function detailsUpdate()
{
$tarikh = Request::get('tarikh');
$cawangan = Request::get('cawangan');
$cawangan_id = Cawangan::where('nama', $cawangan)->first()->id;
if ($cawangan_id == 1 || $cawangan_id == 2) {
$count = 16;
} else {
$count = 14;
}
// Kesalahan
for ($kesalahan = 1; $kesalahan <= $count; $kesalahan++) {
// Warganegara
for ($warga = 1; $warga <= 3; $warga++) {
if ($warga == 1) {
for ($jantina = 1; $jantina <= 2; $jantina++) {
for ($bangsa = 1; $bangsa <= 3; $bangsa++) {
$details = Details::where('tarikh', 'like', Request::get('tarikh') . '%')->where('cawangan_id', $cawangan_id)->where('warganegara_id', $warga)->where('bangsa_id', $bangsa)->where('kesalahan_id', $kesalahan)->where('jantina_id', $jantina)->update(['jumlah' => Request::get($warga . '_' . $bangsa . '_' . $kesalahan . '_' . $jantina)]);
}
}
} else {
for ($bangsa = 4; $bangsa <= 4; $bangsa++) {
for ($jantina = 1; $jantina <= 2; $jantina++) {
$details = Details::where('tarikh', 'like', Request::get('tarikh') . '%')->where('cawangan_id', $cawangan_id)->where('warganegara_id', $warga)->where('bangsa_id', $bangsa)->where('kesalahan_id', $kesalahan)->where('jantina_id', $jantina)->update(['jumlah' => Request::get($warga . '_' . $bangsa . '_' . $kesalahan . '_' . $jantina)]);
}
}
}
// end if else warga
}
// end warga
}
//end kesalahan
// Update Keluarmasuk
for ($i = 1; $i <= 9; $i++) {
if (Request::get($i . '_melayu')) {
$bangsa = 'melayu';
Keluarmasuk::where('tarikh', $tarikh)->where('cawangan_id', $cawangan_id)->where('kesalahan', $i)->where('bangsa', 'melayu')->update(['jumlah' => Request::get($i . '_' . $bangsa)]);
}
if (Request::get($i . '_cina')) {
$bangsa = 'cina';
Keluarmasuk::where('tarikh', $tarikh)->where('cawangan_id', $cawangan_id)->where('kesalahan', $i)->where('bangsa', 'cina')->update(['jumlah' => Request::get($i . '_' . $bangsa)]);
}
if (Request::get($i . '_india')) {
$bangsa = 'india';
Keluarmasuk::where('tarikh', $tarikh)->where('cawangan_id', $cawangan_id)->where('kesalahan', $i)->where('bangsa', 'india')->update(['jumlah' => Request::get($i . '_' . $bangsa)]);
}
if (Request::get($i . '_singh')) {
$bangsa = 'singh';
Keluarmasuk::where('tarikh', $tarikh)->where('cawangan_id', $cawangan_id)->where('kesalahan', $i)->where('bangsa', 'singh')->update(['jumlah' => Request::get($i . '_' . $bangsa)]);
}
if (Request::get($i . '_pathan')) {
$bangsa = 'pathan';
Keluarmasuk::where('tarikh', $tarikh)->where('cawangan_id', $cawangan_id)->where('kesalahan', $i)->where('bangsa', 'pathan')->update(['jumlah' => Request::get($i . '_' . $bangsa)]);
}
if (Request::get($i . '_ptetap')) {
$bangsa = 'ptetap';
Keluarmasuk::where('tarikh', $tarikh)->where('cawangan_id', $cawangan_id)->where('kesalahan', $i)->where('bangsa', 'ptetap')->update(['jumlah' => Request::get($i . '_' . $bangsa)]);
}
if (Request::get($i . '_llb')) {
$bangsa = 'llb';
Keluarmasuk::where('tarikh', $tarikh)->where('cawangan_id', $cawangan_id)->where('kesalahan', $i)->where('bangsa', 'llb')->update(['jumlah' => Request::get($i . '_' . $bangsa)]);
}
if (Request::get($i . '_wanita')) {
$bangsa = 'wanita';
Keluarmasuk::where('tarikh', $tarikh)->where('cawangan_id', $cawangan_id)->where('kesalahan', $i)->where('bangsa', 'wanita')->update(['jumlah' => Request::get($i . '_' . $bangsa)]);
}
}
return Redirect::back();
}
