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 index()
{
$bil = 1;
$statuses = [];
$data[1] = $data[2] = $data[3] = $data[4] = 0;
$cawangans = Cawangan::all();
foreach ($cawangans as $cawangan) {
$details = Details::where('tarikh', 'like', Carbon::now()->format('Y-m-d') . '%')->where('cawangan_id', $cawangan->id)->get();
// dd($details);
if ($details->isEmpty()) {
array_push($statuses, ['cawangan' => $cawangan->nama, 'status' => 'BELUM DIREKOD']);
} 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" => "Jumlah Keseluruhan Hari ini");
$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.rekod.index', compact('bil', 'cawangans', 'statuses', 'yourFirstChart'));
}
/**
* 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
}
}
}
public function cawangan()
{
$bil = 1;
$datas = Cawangan::all();
return View('members.setup.cawangan', compact('bil', 'datas'));
}
