public function cawanganPost() { if (Cawangan::create(['nama' => strtoupper(Request::get('nama'))])) { Session::flash('success', 'Berjaya direkod.'); return Redirect::route('members.setup.cawangan'); } }
public function carian() { $cawangan = Cawangan::lists('nama', 'id'); $laporanstatus = Laporanstatus::lists('nama', 'id'); $tarikh = \Carbon\Carbon::now()->format('Y-m'); return View('members.admin.carian', compact('cawangan', 'laporanstatus', 'tarikh')); }
/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($id) { $aduan = Laporan::findOrFail($id); $cawangan = Cawangan::lists('nama', 'id'); $peralatan = Peralatan::orderBy('nama', 'asc')->lists('nama', 'id'); return View('members.user.laporanEdit', compact('aduan', 'cawangan', 'peralatan')); }
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 edit($id) { $user = User::findOrFail($id); $bahagian = Bahagian::lists('nama', 'id'); $cawangan = Cawangan::lists('nama', 'id'); $level = Level::lists('nama', 'id'); $unit = Unit::lists('nama', 'id'); return View('members.admin.pengguna', compact('user', 'bahagian', 'cawangan', 'level', 'unit')); }
/** * 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 laporan($cawangan) { $year = Carbon::now()->format('Y'); $data = []; for ($i = 1; $i <= 9; $i++) { for ($j = 1; $j <= 12; $j++) { $detail = Keluarmasuk::where('tarikh', 'like', $year . '-' . $j . '-%')->where('cawangan_id', $cawangan)->where('kesalahan', $i)->sum('jumlah'); array_push($data, [$i . '_' . $j => $detail]); } } $cawangan = Cawangan::find($cawangan)->nama; $jumlah = 1; return View('members.laporan.cetak', compact('data', 'jumlah', 'cawangan', 'year')); }
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(); }
public function tahunanXPpk() { $bil = 1; $counts = []; $wilayahs = Bahagian::where('nama', 'not like', 'wilayah%')->get(); foreach ($wilayahs as $wilayah) { $cawangans = Cawangan::where('bahagian_id', $wilayah->id)->where('nama', '!=', 'Wilayah')->get(); foreach ($cawangans as $cawangan) { $bilangan = 0; if (Auth::user()->level->id == 1) { $laporans = Laporan::where('cawangan_id', $cawangan->id)->where('tarikh', 'like', Request::get('year') . '%')->count(); $bilangan = $laporans; } else { $laporans = Laporan::where('cawangan_id', $cawangan->id)->where('tarikh', 'like', Request::get('year') . '%')->get(); foreach ($laporans as $laporan) { if ($laporan->peralatan->kategori->units->id == Auth::user()->units->id) { $bilangan++; } } } $data = ['ppk' => $cawangan->nama, 'bilangan' => $bilangan]; array_push($counts, $data); } } $jumlah = 0; foreach ($counts as $count) { $jumlah += $count['bilangan']; } return View('members.supervisor.laporan.tahunanXPpk', compact('bil', 'counts', 'jumlah')); }
public function kemaskini() { $laporan = Laporan::find(Request::get('id')); $cawangan = Cawangan::lists('nama', 'id'); $peralatan = Peralatan::lists('nama', 'id'); return View('members.supervisor.laporan.kemaskini', compact('laporan', 'cawangan', 'peralatan')); }
public function run() { // Table User User::create(["username" => "suhairi", "password" => \Hash::make('suhairi'), "nama" => "SUHAIRI ABDUL HAMID", "jawatan" => "PENOLONG PEGAWAI TEKNOLOGI MAKLUMAT", "cawangan_id" => 2, "level_id" => 1, "status" => 1, "unit" => 1]); User::create(["username" => "root", "password" => \Hash::make('suhairi'), "nama" => "SUHAIRI ABDUL HAMID", "jawatan" => "PENOLONG PEGAWAI TEKNOLOGI MAKLUMAT", "cawangan_id" => 2, "level_id" => 0, "status" => 1, "unit" => 1]); // Table Bahagian Bahagian::create(['id' => '13', 'nama' => 'Ibu Pejabat']); Bahagian::create(['id' => '1', 'nama' => 'Wilayah 1']); Bahagian::create(['id' => '3', 'nama' => 'Wilayah 3']); Bahagian::create(['id' => '4', 'nama' => 'Wilayah 4']); Bahagian::create(['id' => '2', 'nama' => 'Wilayah 2']); Bahagian::create(['id' => '5', 'nama' => 'Worksyop']); Bahagian::create(['id' => '6', 'nama' => 'KLM']); Bahagian::create(['id' => '7', 'nama' => 'EMPANGAN MUDA']); Bahagian::create(['id' => '8', 'nama' => 'EMPANGAN PEDU']); Bahagian::create(['id' => '9', 'nama' => 'EMPANGAN AH NING']); Bahagian::create(['id' => '11', 'nama' => 'PENGURUSAN WILAYAH']); Bahagian::create(['id' => '10', 'nama' => 'KILANG KORDIAL NAPOH']); Bahagian::where('id', '13')->update(['id' => '0']); // Table Cawangan Cawangan::create(['id' => '1', 'nama' => 'Khidmat Pengurusan', 'bahagian_id' => '0']); Cawangan::create(['id' => '2', 'nama' => 'Perancangan & Teknologi Maklumat', 'bahagian_id' => '0']); Cawangan::create(['id' => '3', 'nama' => 'Industri Padi', 'bahagian_id' => '0']); Cawangan::create(['id' => '4', 'nama' => 'Industri Asas Tani & Bukan Padi', 'bahagian_id' => '0']); Cawangan::create(['id' => '5', 'nama' => 'Pengurusan Wilayah', 'bahagian_id' => '0']); Cawangan::create(['id' => '6', 'nama' => 'Pengurusan Institusi Peladang', 'bahagian_id' => '0']); Cawangan::create(['id' => '7', 'nama' => 'Pengurusan Empangan & Sumber Air', 'bahagian_id' => '0']); Cawangan::create(['id' => '8', 'nama' => 'Mekanikal & Infrastruktur', 'bahagian_id' => '0']); Cawangan::create(['id' => '9', 'nama' => 'Perkhidmatan Pengairan & Saliran', 'bahagian_id' => '0']); Cawangan::create(['id' => '10', 'nama' => 'Wilayah', 'bahagian_id' => '1']); Cawangan::create(['id' => '11', 'nama' => 'A1 - Arau', 'bahagian_id' => '1']); Cawangan::create(['id' => '12', 'nama' => 'B1 - Kayang', 'bahagian_id' => '1']); Cawangan::create(['id' => '13', 'nama' => 'C1 - Kangar', 'bahagian_id' => '1']); Cawangan::create(['id' => '14', 'nama' => 'D1 - Tambun Tulang', 'bahagian_id' => '1']); Cawangan::create(['id' => '15', 'nama' => 'E1 - Simpang Empat', 'bahagian_id' => '1']); Cawangan::create(['id' => '16', 'nama' => 'Wilayah', 'bahagian_id' => '2']); Cawangan::create(['id' => '17', 'nama' => 'A2 - Kodiang', 'bahagian_id' => '2']); Cawangan::create(['id' => '18', 'nama' => 'B2 - Sanglang', 'bahagian_id' => '2']); Cawangan::create(['id' => '19', 'nama' => 'C2 - Kerpan', 'bahagian_id' => '2']); Cawangan::create(['id' => '20', 'nama' => 'D2 - Tunjang', 'bahagian_id' => '2']); Cawangan::create(['id' => '21', 'nama' => 'E2 - Kubang Sepat', 'bahagian_id' => '2']); Cawangan::create(['id' => '22', 'nama' => 'F2 - Jerlun', 'bahagian_id' => '2']); Cawangan::create(['id' => '23', 'nama' => 'G2 - Jitra', 'bahagian_id' => '2']); Cawangan::create(['id' => '24', 'nama' => 'H2 - Kepala Batas', 'bahagian_id' => '2']); Cawangan::create(['id' => '25', 'nama' => 'Wilayah', 'bahagian_id' => '3']); Cawangan::create(['id' => '26', 'nama' => 'A3 - Hutan Kampung', 'bahagian_id' => '3']); Cawangan::create(['id' => '27', 'nama' => 'B3 - Alor Senibong', 'bahagian_id' => '3']); Cawangan::create(['id' => '28', 'nama' => 'C3 - Tajar', 'bahagian_id' => '3']); Cawangan::create(['id' => '29', 'nama' => 'D3 - Titi Haji Idris', 'bahagian_id' => '3']); Cawangan::create(['id' => '30', 'nama' => 'E3 - Kokbah', 'bahagian_id' => '3']); Cawangan::create(['id' => '31', 'nama' => 'F3 - Pendang', 'bahagian_id' => '3']); Cawangan::create(['id' => '32', 'nama' => 'Wilayah', 'bahagian_id' => '4']); Cawangan::create(['id' => '33', 'nama' => 'A4 - Batas Paip', 'bahagian_id' => '4']); Cawangan::create(['id' => '34', 'nama' => 'B4 - Pengkalan Kundor', 'bahagian_id' => '4']); Cawangan::create(['id' => '35', 'nama' => 'C4 - Kangkong', 'bahagian_id' => '4']); Cawangan::create(['id' => '36', 'nama' => 'D4 - Permatang Buluh', 'bahagian_id' => '4']); Cawangan::create(['id' => '37', 'nama' => 'E4 - Bukit Besar', 'bahagian_id' => '4']); Cawangan::create(['id' => '38', 'nama' => 'F4 - Sungai Limau Dalam', 'bahagian_id' => '4']); Cawangan::create(['id' => '39', 'nama' => 'G4 - Guar Chempedak', 'bahagian_id' => '4']); Cawangan::create(['id' => '51', 'nama' => 'Worksyop', 'bahagian_id' => '5']); Cawangan::create(['id' => '42', 'nama' => 'I2 - Kuala Sungai', 'bahagian_id' => '2']); Cawangan::create(['id' => '43', 'nama' => 'KLM', 'bahagian_id' => '6']); Cawangan::create(['id' => '47', 'nama' => 'Empangan Muda', 'bahagian_id' => '7']); Cawangan::create(['id' => '48', 'nama' => 'Empangan Pedu', 'bahagian_id' => '8']); Cawangan::create(['id' => '49', 'nama' => 'Empangan Ahning', 'bahagian_id' => '9']); // Table Kategori Kategori::create(['id' => '2', 'nama' => 'PERISIAN', 'status' => 'active', 'unit' => '2']); Kategori::create(['id' => '3', 'nama' => 'VIRUS', 'status' => 'inactive', 'unit' => '2']); Kategori::create(['id' => '4', 'nama' => 'RANGKAIAN', 'status' => 'active', 'unit' => '3']); Kategori::create(['id' => '5', 'nama' => 'SISTEM', 'status' => 'active', 'unit' => '1']); Kategori::create(['id' => '1', 'nama' => 'PERKAKASAN', 'status' => 'active', 'unit' => '2']); Kategori::create(['id' => '9', 'nama' => 'BERKALA', 'status' => 'inactive', 'unit' => '2']); Kategori::create(['id' => '14', 'nama' => 'TEST 1', 'status' => 'inactive', 'unit' => '1']); Kategori::create(['id' => '15', 'nama' => 'TEST 2', 'status' => 'inactive', 'unit' => '2']); Kategori::create(['id' => '16', 'nama' => 'TEST 3', 'status' => 'inactive', 'unit' => '3']); // Table Level Level::create(['id' => '1', 'nama' => 'Admin']); Level::create(['id' => '2', 'nama' => 'Supervisor']); Level::create(['id' => '3', 'nama' => 'Technician']); Level::create(['id' => '4', 'nama' => 'User']); Level::create(['id' => '5', 'nama' => 'Data Entry']); Level::create(['id' => '0', 'nama' => 'Root']); Level::where('id', 6)->update(['id' => '0']); // Table Peralatan Peralatan::create(['id' => '10', 'nama' => 'MONITOR', 'kategori_id' => '1']); Peralatan::create(['id' => '13', 'nama' => 'PROFIL PELADANG', 'kategori_id' => '5']); Peralatan::create(['id' => '11', 'nama' => 'KEYBOARD', 'kategori_id' => '1']); Peralatan::create(['id' => '9', 'nama' => 'MICROSOFT OFFICE', 'kategori_id' => '2']); Peralatan::create(['id' => '52', 'nama' => 'CPU', 'kategori_id' => '1']); Peralatan::create(['id' => '36', 'nama' => 'OPERATING SYSTEM', 'kategori_id' => '2']); Peralatan::create(['id' => '12', 'nama' => 'INTERNET', 'kategori_id' => '4']); Peralatan::create(['id' => '14', 'nama' => 'GOE-EGDMS', 'kategori_id' => '5']); Peralatan::create(['id' => '15', 'nama' => 'SAGA', 'kategori_id' => '5']); Peralatan::create(['id' => '16', 'nama' => 'MYASSET', 'kategori_id' => '5']); Peralatan::create(['id' => '17', 'nama' => 'SUBSIDI', 'kategori_id' => '5']); Peralatan::create(['id' => '19', 'nama' => 'NOTEBOOK', 'kategori_id' => '1']); Peralatan::create(['id' => '20', 'nama' => 'SBPKP - SKIM BAJA PADI KERAJAAN PERSEKUTUAN', 'kategori_id' => '5']); Peralatan::create(['id' => '21', 'nama' => 'SPA - SISTEM PENGURUSAN AIR', 'kategori_id' => '5']); Peralatan::create(['id' => '22', 'nama' => 'SMP / PROJEK 10 TAN / SMP 10 TAN', 'kategori_id' => '5']); Peralatan::create(['id' => '39', 'nama' => 'UPS', 'kategori_id' => '1']); Peralatan::create(['id' => '24', 'nama' => 'HRMIS', 'kategori_id' => '5']); Peralatan::create(['id' => '25', 'nama' => 'SPPA - SISTEM PEMANTAUAN PENGURUSAN ASET', 'kategori_id' => '5']); Peralatan::create(['id' => '26', 'nama' => 'LAMAN WEB', 'kategori_id' => '5']); Peralatan::create(['id' => '86', 'nama' => 'VIRUS', 'kategori_id' => '1']); Peralatan::create(['id' => '28', 'nama' => 'PRIMARI PERTUBUHAN PELADANG', 'kategori_id' => '5']); Peralatan::create(['id' => '29', 'nama' => 'EMAIL', 'kategori_id' => '5']); Peralatan::create(['id' => '30', 'nama' => 'SISTEM MAKLUMAT USAHAWAN TANI', 'kategori_id' => '5']); Peralatan::create(['id' => '31', 'nama' => 'PENYELENGGARAAN', 'kategori_id' => '5']); Peralatan::create(['id' => '32', 'nama' => 'ADUAN', 'kategori_id' => '5']); Peralatan::create(['id' => '33', 'nama' => 'PERMOHONAN AHLI PPK', 'kategori_id' => '5']); Peralatan::create(['id' => '87', 'nama' => 'KOMPUTER', 'kategori_id' => '9']); Peralatan::create(['id' => '35', 'nama' => 'GIS', 'kategori_id' => '5']); Peralatan::create(['id' => '37', 'nama' => 'PRINTER', 'kategori_id' => '1']); Peralatan::create(['id' => '38', 'nama' => 'SCANNER', 'kategori_id' => '1']); Peralatan::create(['id' => '40', 'nama' => 'RAM', 'kategori_id' => '1']); Peralatan::create(['id' => '41', 'nama' => 'PLOTTER', 'kategori_id' => '1']); Peralatan::create(['id' => '42', 'nama' => 'AVR', 'kategori_id' => '1']); Peralatan::create(['id' => '43', 'nama' => 'MOUSE', 'kategori_id' => '1']); Peralatan::create(['id' => '44', 'nama' => 'VIRUS', 'kategori_id' => '3']); Peralatan::create(['id' => '45', 'nama' => 'UNINSTALL ANTI3', 'kategori_id' => '3']); Peralatan::create(['id' => '46', 'nama' => 'INSTALL ANTI3', 'kategori_id' => '3']); Peralatan::create(['id' => '47', 'nama' => 'PROJECTOR', 'kategori_id' => '1']); Peralatan::create(['id' => '48', 'nama' => 'SERVER', 'kategori_id' => '1']); Peralatan::create(['id' => '49', 'nama' => 'PENDRIVE', 'kategori_id' => '1']); Peralatan::create(['id' => '50', 'nama' => 'NETBOOK', 'kategori_id' => '1']); Peralatan::create(['id' => '51', 'nama' => 'AUTOCAD', 'kategori_id' => '2']); Peralatan::create(['id' => '53', 'nama' => 'PEMASANGAN PC BARU', 'kategori_id' => '1']); Peralatan::create(['id' => '54', 'nama' => 'PEMASANGAN PRINTER BARU', 'kategori_id' => '1']); Peralatan::create(['id' => '55', 'nama' => 'MOTHERBOARD', 'kategori_id' => '1']); Peralatan::create(['id' => '56', 'nama' => 'HARD DISK', 'kategori_id' => '1']); Peralatan::create(['id' => '57', 'nama' => 'BATERI CMOS', 'kategori_id' => '1']); Peralatan::create(['id' => '58', 'nama' => 'POWER SUPPLY', 'kategori_id' => '1']); Peralatan::create(['id' => '69', 'nama' => 'SOPPAN', 'kategori_id' => '5']); Peralatan::create(['id' => '68', 'nama' => 'DISK DEFRAGMENTATION', 'kategori_id' => '9']); Peralatan::create(['id' => '67', 'nama' => 'DISK CLEANUP', 'kategori_id' => '9']); Peralatan::create(['id' => '71', 'nama' => 'UPDATE ANTIVIRUS PATTERN', 'kategori_id' => '9']); Peralatan::create(['id' => '70', 'nama' => 'UPDATE SERVICE PATCH', 'kategori_id' => '9']); Peralatan::create(['id' => '72', 'nama' => 'UPDATE LICENCE ANTIVIRUS', 'kategori_id' => '9']); Peralatan::create(['id' => '73', 'nama' => 'ADAPTER', 'kategori_id' => '1']); Peralatan::create(['id' => '75', 'nama' => 'PREVENTIVE MAINTANANCE', 'kategori_id' => '9']); Peralatan::create(['id' => '84', 'nama' => '3 COM SWITCH', 'kategori_id' => '4']); Peralatan::create(['id' => '77', 'nama' => 'ADOBE', 'kategori_id' => '2']); Peralatan::create(['id' => '78', 'nama' => 'INTERNET EXPLORER', 'kategori_id' => '2']); Peralatan::create(['id' => '79', 'nama' => 'SHARING FOLDER & FAIL', 'kategori_id' => '4']); Peralatan::create(['id' => '80', 'nama' => 'MOUSE', 'kategori_id' => '1']); Peralatan::create(['id' => '81', 'nama' => 'MTS', 'kategori_id' => '5']); Peralatan::create(['id' => '85', 'nama' => 'BIOMETRIK', 'kategori_id' => '5']); User::create(['username' => 'saiful', 'password' => \Hash::make('password'), 'nama' => 'Shaiful Azlimi Abdullah', 'jawatan' => 'Juruteknik Komputer (F17)', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'fazli', 'password' => \Hash::make('password'), 'nama' => 'Mohd Fadzly Abd Ghani', 'jawatan' => 'Pembantu Tadbir (N17)', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'admin', 'password' => \Hash::make('password'), 'nama' => 'Mohd Alias Hj Said', 'jawatan' => 'Pegawai Teknologi Maklumat (F41)', 'cawangan_id' => '2', 'level_id' => '1', 'status' => '1', 'unit' => '0', 'remember_token' => '']); User::create(['username' => 'asmahan', 'password' => \Hash::make('password'), 'nama' => 'Cik Asmahan Sudin', 'jawatan' => 'Pembantu Tadbir (N17)', 'cawangan_id' => '2', 'level_id' => '4', 'status' => '0', 'unit' => '1', 'remember_token' => '']); User::create(['username' => 'lily', 'password' => \Hash::make('password'), 'nama' => 'Juliana Abd Sattar', 'jawatan' => 'Pembantu Tadbir (N17)', 'cawangan_id' => '2', 'level_id' => '4', 'status' => '1', 'unit' => '0', 'remember_token' => '']); User::create(['username' => 'cluster', 'password' => \Hash::make('password'), 'nama' => 'Cluster Teknologi (M) Sdn. Bhd.', 'jawatan' => 'Vendor', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'alias', 'password' => \Hash::make('password'), 'nama' => 'Mohd Alias Hj Said', 'jawatan' => 'Peg. Teknologi Maklumat (F41)', 'cawangan_id' => '2', 'level_id' => '2', 'status' => '1', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'anas', 'password' => \Hash::make('password'), 'nama' => 'Anas Mohd Reza Abd Aziz', 'jawatan' => 'Juruteknik Komputer (F17)', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'rohana', 'password' => \Hash::make('password'), 'nama' => 'Rohana Binti Saad', 'jawatan' => 'Pen. Peg. Teknologi Maklumat ', 'cawangan_id' => '2', 'level_id' => '2', 'status' => '1', 'unit' => '1', 'remember_token' => '']); User::create(['username' => 'robiah', 'password' => \Hash::make('password'), 'nama' => 'Robiah Bt Lazim', 'jawatan' => 'Pengarah', 'cawangan_id' => '2', 'level_id' => '1', 'status' => '1', 'unit' => '0', 'remember_token' => '']); User::create(['username' => 'afizan', 'password' => \Hash::make('password'), 'nama' => 'Mohd Afizan Fazlime Aminuddin', 'jawatan' => 'Pen. Peg. Teknologi Maklumat (F29)', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '3', 'remember_token' => '']); User::create(['username' => 'ont', 'password' => \Hash::make('password'), 'nama' => 'ONT SUCESS ENT.', 'jawatan' => 'Vendor', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'teliti', 'password' => \Hash::make('password'), 'nama' => 'Teliti', 'jawatan' => 'Vendor', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'lily1', 'password' => \Hash::make('password'), 'nama' => 'Juliana Abd Sattar', 'jawatan' => 'Pembantu Tadbir (N17)', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '0', 'unit' => '1', 'remember_token' => '']); User::create(['username' => 'asmahan1', 'password' => \Hash::make('password'), 'nama' => 'Cik Asmahan Sudin', 'jawatan' => 'Pembantu Tadbir (N17)', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '0', 'unit' => '1', 'remember_token' => '']); User::create(['username' => 'Soffyan1', 'password' => \Hash::make('password'), 'nama' => 'Soffyan Nadzri', 'jawatan' => 'Pen. Peg. Teknologi Maklumat (F29)', 'cawangan_id' => '2', 'level_id' => '2', 'status' => '1', 'unit' => '3', 'remember_token' => '']); User::create(['username' => 'marziani', 'password' => \Hash::make('password'), 'nama' => 'Marziani Mahmud', 'jawatan' => 'Pen. Peg. Teknologi Maklumat (F29)', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '1', 'remember_token' => '']); User::create(['username' => 'abuhafiz', 'password' => \Hash::make('password'), 'nama' => 'Muhamad Hafiz Ismail@Chik', 'jawatan' => 'Pembantu Tadbir (N17)', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'cheamah', 'password' => \Hash::make('password'), 'nama' => 'Che Amah Hussan', 'jawatan' => 'Pegawai Teknologi Maklumat (F48)', 'cawangan_id' => '2', 'level_id' => '1', 'status' => '0', 'unit' => '0', 'remember_token' => '']); User::create(['username' => 'shapari', 'password' => \Hash::make('password'), 'nama' => 'Shapari Abdul Halim', 'jawatan' => 'Pegawai Teknologi Maklumat (F44)', 'cawangan_id' => '2', 'level_id' => '1', 'status' => '1', 'unit' => '0', 'remember_token' => '']); User::create(['username' => 'salmah', 'password' => \Hash::make('password'), 'nama' => 'Salmah Hashim', 'jawatan' => 'Pen. Peg. Teknologi Maklumat (F29)', 'cawangan_id' => '2', 'level_id' => '1', 'status' => '0', 'unit' => '0', 'remember_token' => '']); User::create(['username' => 'asmahan2', 'password' => \Hash::make('password'), 'nama' => 'Cik Asmahan Sudin', 'jawatan' => 'Pembantu Tadbir (N17)', 'cawangan_id' => '2', 'level_id' => '2', 'status' => '0', 'unit' => '3', 'remember_token' => '']); User::create(['username' => 'azlinais', 'password' => \Hash::make('password'), 'nama' => 'Noor Azlina Ismail', 'jawatan' => 'Pegawai Teknologi Maklumat (F41)', 'cawangan_id' => '2', 'level_id' => '1', 'status' => '1', 'unit' => '1', 'remember_token' => '']); User::create(['username' => 'tech2', 'password' => \Hash::make('password'), 'nama' => 'Tech 2', 'jawatan' => 'Tech 2', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '0', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'subur', 'password' => \Hash::make('password'), 'nama' => 'Subur Teknologi (M) Sdn. Bhd.', 'jawatan' => 'Vendor', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'suzana', 'password' => \Hash::make('password'), 'nama' => 'Suzana', 'jawatan' => 'Pembantu Tadbir (N17)', 'cawangan_id' => '2', 'level_id' => '2', 'status' => '0', 'unit' => '0', 'remember_token' => '']); User::create(['username' => 'farid', 'password' => \Hash::make('password'), 'nama' => 'Ahmad Farid Bin Mohamad Ariff', 'jawatan' => 'Juruteknik Komputer (FT17)', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'suzanactm', 'password' => \Hash::make('password'), 'nama' => 'Suzana', 'jawatan' => 'Pembantu Tadbir (N17)', 'cawangan_id' => '2', 'level_id' => '4', 'status' => '0', 'unit' => '1', 'remember_token' => '']); User::create(['username' => 'soffyan', 'password' => \Hash::make('password'), 'nama' => 'Soffyan Nadzri', 'jawatan' => 'Pen. Peg. Teknologi Maklumat (F29)', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '3', 'remember_token' => '']); User::create(['username' => 'shaiful', 'password' => \Hash::make('password'), 'nama' => 'Shaiful Azlimi Abdullah', 'jawatan' => 'Juruteknik Kanan', 'cawangan_id' => '2', 'level_id' => '2', 'status' => '0', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'hpcentre', 'password' => \Hash::make('password'), 'nama' => 'HP Centre', 'jawatan' => 'Vendor', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'kulim', 'password' => \Hash::make('password'), 'nama' => 'Kulim Technology', 'jawatan' => 'Vendor', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'sonic', 'password' => \Hash::make('password'), 'nama' => 'Sonic Technology Sdn. Bhd.', 'jawatan' => 'Vendor', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'northen', 'password' => \Hash::make('password'), 'nama' => 'Northen System', 'jawatan' => 'Vendor', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'faxwell', 'password' => \Hash::make('password'), 'nama' => 'Faxwell IT Service', 'jawatan' => 'Vendor', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'rohana1', 'password' => \Hash::make('password'), 'nama' => 'ROHANA BT SAAD', 'jawatan' => 'Pen. Peg. Teknologi Maklumat ', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '1', 'remember_token' => '']); User::create(['username' => 'maizan', 'password' => \Hash::make('password'), 'nama' => 'Maizan Bt Abu Bakar', 'jawatan' => 'Pen. Peg Teknologi Maklumat', 'cawangan_id' => '2', 'level_id' => '2', 'status' => '1', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'maizan2', 'password' => \Hash::make('password'), 'nama' => 'Maizan Bt Abu Bakar', 'jawatan' => 'Pen. Peg Teknologi Maklumat', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'suhairi1', 'password' => \Hash::make('password'), 'nama' => 'Suhairi Abdul Hamid', 'jawatan' => 'Pen. Peg. Teknologi Maklumat (F29)', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '1', 'remember_token' => '']); User::create(['username' => 'test3', 'password' => \Hash::make('password'), 'nama' => 'Test 3', 'jawatan' => 'Test 3', 'cawangan_id' => '2', 'level_id' => '2', 'status' => '0', 'unit' => '3', 'remember_token' => '']); User::create(['username' => 'celestra', 'password' => \Hash::make('password'), 'nama' => 'Celestra Network Communications Sdn.Bhd', 'jawatan' => 'Vendor', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'test2', 'password' => \Hash::make('password'), 'nama' => 'Test 2', 'jawatan' => 'Test 2', 'cawangan_id' => '2', 'level_id' => '2', 'status' => '0', 'unit' => '2', 'remember_token' => '']); User::create(['username' => 'tech1', 'password' => \Hash::make('password'), 'nama' => 'Tech 1', 'jawatan' => 'Tech 1', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '0', 'unit' => '1', 'remember_token' => '']); User::create(['username' => 'akmal', 'password' => \Hash::make('password'), 'nama' => 'Mohd Akmal B Alias', 'jawatan' => 'Pen. Peg. Teknologi Maklumat (F29)', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '1', 'remember_token' => '']); User::create(['username' => 'test1', 'password' => \Hash::make('password'), 'nama' => 'Test1', 'jawatan' => 'Test1', 'cawangan_id' => '2', 'level_id' => '2', 'status' => '0', 'unit' => '1', 'remember_token' => '']); User::create(['username' => 'tech3', 'password' => \Hash::make('password'), 'nama' => 'Tech 3', 'jawatan' => 'Tech 3', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '0', 'unit' => '3', 'remember_token' => '']); User::create(['username' => 'azlina', 'password' => \Hash::make('password'), 'nama' => 'Noor Azlina Ismail', 'jawatan' => 'Pegawai Teknologi Maklumat (F41)', 'cawangan_id' => '2', 'level_id' => '2', 'status' => '1', 'unit' => '1', 'remember_token' => '']); User::create(['username' => 'ont1', 'password' => \Hash::make('password'), 'nama' => 'ONT SUCESS ENT.', 'jawatan' => 'Vendor', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '3', 'remember_token' => '']); User::create(['username' => 'teliti1', 'password' => \Hash::make('password'), 'nama' => 'Teliti', 'jawatan' => 'Vendor', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '3', 'remember_token' => '']); User::create(['username' => 'hpcentre1', 'password' => \Hash::make('password'), 'nama' => 'HP Centre', 'jawatan' => 'Vendor', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '3', 'remember_token' => '']); User::create(['username' => 'kulim1', 'password' => \Hash::make('password'), 'nama' => 'Kulim Technology', 'jawatan' => 'Vendor', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '3', 'remember_token' => '']); User::create(['username' => 'sonic1', 'password' => \Hash::make('password'), 'nama' => 'Sonic Technology Sdn. Bhd.', 'jawatan' => 'Vendor', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '3', 'remember_token' => '']); User::create(['username' => 'northen1', 'password' => \Hash::make('password'), 'nama' => 'Northen System', 'jawatan' => 'Vendor', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '3', 'remember_token' => '']); User::create(['username' => 'faxwell1', 'password' => \Hash::make('password'), 'nama' => 'Faxwell IT Service', 'jawatan' => 'Vendor', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '3', 'remember_token' => '']); User::create(['username' => 'azlina2', 'password' => \Hash::make('password'), 'nama' => 'Noor Azlina Ismail', 'jawatan' => 'Pegawai Teknologi Maklumat', 'cawangan_id' => '2', 'level_id' => '2', 'status' => '1', 'unit' => '3', 'remember_token' => '']); User::create(['username' => 'cluster1', 'password' => \Hash::make('password'), 'nama' => 'Cluster Teknologi (M) Sdn. Bhd.', 'jawatan' => 'Vendor', 'cawangan_id' => '2', 'level_id' => '3', 'status' => '1', 'unit' => '3', 'remember_token' => '']); Aduan::create(['username' => 'lily', 'complaint' => 'This is a test message... please reply with anything']); Userstatus::create(['id' => '1', 'nama' => 'AKTIF']); Userstatus::create(['id' => '0', 'nama' => 'TIDAK AKTIF']); Laporanstatus::create(['id' => '1', 'nama' => 'Closing']); Laporanstatus::create(['id' => '2', 'nama' => 'Dalam Pelaksanaan']); Laporanstatus::create(['id' => '3', 'nama' => 'KIV']); Laporanstatus::create(['id' => '4', 'nama' => 'Selesai']); Laporanstatus::create(['id' => '5', 'nama' => 'Belum Selesai']); Laporanstatus::where('id', 5)->update(['id' => '0']); Userstatus::where('id', 2)->update(['id' => '0']); Unit::create(['nama' => 'APLIKASI / SISTEM']); Unit::create(['nama' => 'PERKAKASAN / MAINTENANCE']); Unit::create(['nama' => 'SERVER / NETWORK']); Unit::create(['nama' => 'ADMINISTATOR']); Unit::where('id', 4)->update(['id' => '0']); }
/** * Run the database seeds. * * @return void */ public function run() { User::create(['name' => 'Mohd Najib b Ruslah', 'email' => '*****@*****.**', 'password' => \Hash::make('najib')]); User::create(['name' => 'admin', 'email' => '*****@*****.**', 'password' => \Hash::make('password')]); User::create(['name' => 'Suhairi Abdul Hamid', 'email' => '*****@*****.**', 'password' => \Hash::make('suhairi')]); Cawangan::create(['nama' => 'ALOR SETAR']); Cawangan::create(['nama' => 'POKOK SENA']); Cawangan::create(['nama' => 'SUNGAI PETANI']); Cawangan::create(['nama' => 'PAROL']); Warganegara::create(['nama' => 'WARGANEGARA']); Warganegara::create(['nama' => 'WARGA ASING']); Warganegara::create(['nama' => 'LAIN_LAIN']); Jantina::create(['nama' => 'LELAKI']); Jantina::create(['nama' => 'PEREMPUAN']); Bangsa::create(['nama' => 'MELAYU']); Bangsa::create(['nama' => 'CINA']); Bangsa::create(['nama' => 'INDIA']); Bangsa::create(['nama' => 'LAIN_LAIN']); Kategori::create(['nama' => 'SABITAN']); // ---> 1 Kategori::create(['nama' => 'BUKAN SABITAN']); // ---> 2 Kategori::create(['nama' => 'DADAH']); // ---> 3 Kategori::create(['nama' => 'MUDA']); // ---> 4 Kategori::create(['nama' => 'PAROL']); // ---> 5 Kategori::create(['nama' => 'KEM']); // ---> 6 // Kesalahan // Banduan Akhir -> 1 // B. Seumur Hayar -> 2 // B. Seumur Hidup -> 3 // T. Limpah Sultan-> 4 // H. Lama -> 5 // H. Singkat -> 6 ----> SABITAN // T. M. Tinggi -> 7 // T. M. Sesyen -> 8 // T. M. Rendah -> 9 // T. M. Rayuan -> 10 // T. M. R. S -> 11 // B. Dagang -> 12 ----> B. SABITAN // Dadah -> 13 // Muda -> 14 // Parol` -> 15 // KEM -> 16 Kesalahan::create(['nama' => 'BANDUAN AKHIR', 'kategori_id' => '1', 'kod' => 'BA']); Kesalahan::create(['nama' => 'BANDUAN SEUMUR HAYAT', 'kategori_id' => '1', 'kod' => 'SH']); Kesalahan::create(['nama' => 'BANDUAN SEUMUR HIDUP', 'kategori_id' => '1', 'kod' => 'BSH']); Kesalahan::create(['nama' => 'TAHANAN LIMPAH SULTAN', 'kategori_id' => '1', 'kod' => 'TLS']); Kesalahan::create(['nama' => 'HUKUMAN LAMA', 'kategori_id' => '1', 'kod' => 'HL']); Kesalahan::create(['nama' => 'HUKUMAN SINGKAT', 'kategori_id' => '1', 'kod' => 'HS']); Kesalahan::create(['nama' => 'TAHANAN MAHKAMAH TINGGI', 'kategori_id' => '2', 'kod' => 'TMT']); Kesalahan::create(['nama' => 'TAHANAN MAHKAMAH SESYEN', 'kategori_id' => '2', 'kod' => 'TMS']); Kesalahan::create(['nama' => 'TAHANAN MAHKAMAH RENDAH', 'kategori_id' => '2', 'kod' => 'TMR']); Kesalahan::create(['nama' => 'TAHANAN MAHKAMAH RAYUAN', 'kategori_id' => '2', 'kod' => 'TMR']); // KIV Kesalahan::create(['nama' => 'TAHANAN MAHKAMAH RENDAH SESYEN', 'kategori_id' => '2', 'kod' => 'TMRS']); Kesalahan::create(['nama' => 'BANDUAN DAGANG', 'kategori_id' => '2', 'kod' => 'BD']); Kesalahan::create(['nama' => 'DADAH', 'kategori_id' => '3', 'kod' => 'DADAH']); Kesalahan::create(['nama' => 'PAROL', 'kategori_id' => '4', 'kod' => 'PAROL']); Kesalahan::create(['nama' => 'MUDA', 'kategori_id' => '5', 'kod' => 'MUDA']); Kesalahan::create(['nama' => 'KEM', 'kategori_id' => '6', 'kod' => 'KEM']); Kesalahan::create(['nama' => 'POCA', 'kategori_id' => '6', 'kod' => 'KEM']); Pegawai::create(['nama' => 'NOOR HAZWAN B AB HAMID', 'pangkat' => 'KPL 15883']); }