/**
* 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'));
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function end(Request $request, $id)
{
$output = new \Symfony\Component\Console\Output\ConsoleOutput(2);
$output->writeln("end");
$rules = array('id_barang' => 'required', 'waktu_selesai' => 'required');
$validator = Validator::make(Input::all(), $rules);
$output->writeln(Input::get('waktu_mulai'));
// process the store
if ($validator->fails()) {
return $validator->messages()->toJson();
} else {
$perbaikan = Perbaikan::find($id);
if (!$perbaikan) {
return "Not Found";
}
if (strtotime($perbaikan->waktu_selesai) != null) {
return "Perbaikan sudah diakhiri";
}
$waktu_mulai = strtotime($perbaikan->waktu_mulai);
if (!checkDateTime(Input::get('waktu_selesai'))) {
return "Waktu selesai tidak valid";
}
if ($waktu_mulai >= strtotime(Input::get('waktu_selesai'))) {
return "Waktu mulai > waktu selesai";
}
// store
$peralatan = Peralatan::find($id);
if (!$peralatan) {
return "ID peralatan tidak ditemukan";
}
$id_barang = $perbaikan->id_barang;
$perbaikan->waktu_selesai = Input::get('waktu_selesai');
//ubah status peralatan
$peralatan = Peralatan::find($id_barang);
if (!$peralatan) {
return "ID peralatan tidak ditemukan";
}
if (strcmp($peralatan->status, "Perbaikan") == 0) {
$peralatan->status = "Baik";
}
$peralatan->save();
$perbaikan->save();
return 1;
}
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function end(Request $request, $id)
{
// store
$transaksi = Transaksi::find($id);
if (!$transaksi) {
return "Not Found";
}
if (strtotime($transaksi->waktu_kembali) != null) {
return "Transaksi sudah diakhiri";
}
$waktu_pinjam = strtotime($transaksi->waktu_pinjam);
$now = Carbon::now()->addHours(7)->toDateTimeString();
$curTime = strtotime($now);
if ($curTime <= $waktu_pinjam) {
return "Waktu tidak valid";
}
$transaksi->waktu_kembali = $now;
$id_barang = $transaksi->id_barang;
$transaksi->save();
//ubah ketersediaan peralatan
$peralatan = Peralatan::find($id_barang);
if (!$peralatan) {
return "ID peralatan tidak ditemukan";
}
$peralatan->ketersediaan = "Tersedia";
$peralatan->save();
return 1;
}
public function allPeralatan()
{
return Peralatan::all();
}
public function bulananPpk()
{
if (Request::get('monthFrom') < 10) {
$dateFrom = Request::get('yearFrom') . '-0' . Request::get('monthFrom') . '-01';
} else {
$dateFrom = Request::get('yearFrom') . '-' . Request::get('monthFrom') . '-01';
}
if (Request::get('monthTo') < 10) {
$dateTo = Request::get('yearTo') . '-0' . Request::get('monthTo') . '-01';
} else {
$dateTo = Request::get('yearTo') . '-' . Request::get('monthTo') . '-01';
}
$counts = [];
$bil = 1;
$units = Unit::find(\Auth::user()->unit);
$kategoris = Kategori::where('unit', \Auth::user()->unit)->where('status', 'active')->get();
if (\Auth::user()->level->id == 1) {
$kategoris = Kategori::where('status', 'active')->get();
}
foreach ($kategoris as $kategori) {
$peralatans = Peralatan::where('kategori_id', $kategori->id)->get();
foreach ($peralatans as $peralatan) {
$count = Laporan::where('tarikh', '>=', $dateFrom)->where('tarikh', '<=', $dateTo)->where('peralatan_id', $peralatan->id)->count();
array_push($counts, ['kategori' => $kategori->nama, 'peralatan' => $peralatan->nama, 'count' => $count]);
}
}
$bil = 1;
$jumlah = 0;
foreach ($counts as $count) {
$jumlah += $count['count'];
}
// dd($counts);
return View('members.supervisor.laporan.bulananPenempatan', compact('bil', 'counts', 'units', 'kategoris', 'jumlah'));
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$rules = array('jenis_barang' => 'required', 'id_pembooking' => 'required|integer', 'waktu_booking_mulai' => 'required', 'waktu_booking_selesai' => 'required');
$validator = Validator::make(Input::all(), $rules);
if ($validator->fails()) {
return $validator->messages()->toJson();
} else {
if (!checkDateTime(Input::get('waktu_booking_mulai'))) {
return "Waktu booking mulai tidak valid";
}
if (!checkDateTime(Input::get('waktu_booking_selesai'))) {
return "Waktu booking selesai tidak valid";
}
if (strtotime(Input::get('waktu_booking_mulai')) >= strtotime(Input::get('waktu_booking_selesai'))) {
return "Waktu booking mulai > waktu booking selesai";
}
/* cek id pembooking */
$pengguna = Pengguna::find(Input::get('id_pembooking'));
if (!$pengguna) {
return "ID pengguna tidak ditemukan";
}
$booking = Booking::find($id);
if (!$booking) {
return "Not Found";
}
/* cek apakah jenis peralatan berubah
* jika berubah, cari alat baru
*/
$id_barang_old = $booking->id_barang;
$barang_old = Peralatan::find($id_barang_old);
$jenis_barang_old = $barang_old->jenis;
$selected_id = -1;
if (strcmp(Input::get('jenis_barang'), $jenis_barang_old) == 0) {
$selected_id = $id_barang_old;
} else {
//cari peralatan baru jika jenis berubah
$alat_sesuai_jenis = Peralatan::where('jenis', '=', Input::get('jenis_barang'))->get();
$input_booking_mulai_time = strtotime(Input::get('waktu_booking_mulai'));
$input_booking_selesai_time = strtotime(Input::get('waktu_booking_selesai'));
foreach ($alat_sesuai_jenis as $alat) {
$available = true;
/* Cek di tabel booking */
$booking_of_alat = Booking::where('id_barang', '=', $alat->id)->get();
foreach ($booking_of_alat as $booking) {
$booking_mulai_time = strtotime($booking->waktu_booking_mulai);
$booking_selesai_time = strtotime($booking->waktu_booking_selesai);
if ($input_booking_mulai_time > $booking_mulai_time && $input_booking_mulai_time < $booking_selesai_time || $input_booking_selesai_time > $booking_mulai_time && $input_booking_selesai_time < $booking_selesai_time || $booking_mulai_time > $input_booking_mulai_time && $booking_mulai_time < $input_booking_selesai_time || $booking_selesai_time > $input_booking_mulai_time && $booking_selesai_time < $input_booking_selesai_time) {
$available = false;
}
}
/* Cek di tabel transaksi */
if ($available) {
$transaksi_of_alat = Transaksi::where('id_barang', '=', $alat->id)->get();
foreach ($transaksi_of_alat as $transaksi) {
$transaksi_pinjam_time = $transaksi->waktu_pinjam;
$transaksi_rencana_kembali_time = $transaksi->waktu_rencana_kembali;
if ($input_booking_mulai_time > $transaksi_pinjam_time && $input_booking_mulai_time < $transaksi_rencana_kembali_time || $input_booking_selesai_time > $transaksi_pinjam_time && $input_booking_selesai_time < $transaksi_rencana_kembali_time || $transaksi_pinjam_time > $input_booking_mulai_time && $transaksi_pinjam_time < $input_booking_selesai_time || $transaksi_rencana_kembali_time > $input_booking_mulai_time && $transaksi_rencana_kembali_time < $input_booking_selesai_time) {
$available = false;
}
}
}
if ($available) {
$selected_id = $alat->id;
}
}
}
if ($selected_id < 1) {
return "Tidak ada alat tersedia";
} else {
/* cek tanggal */
if (strtotime(Input::get('waktu_booking_selesai')) <= strtotime(Input::get('waktu_booking_mulai'))) {
return "Tanggal tidak valid";
} else {
// store
$booking->id_barang = $selected_id;
$booking->id_pembooking = Input::get('id_pembooking');
$booking->waktu_booking_mulai = Input::get('waktu_booking_mulai');
$booking->waktu_booking_selesai = Input::get('waktu_booking_selesai');
$booking->save();
return $booking->id;
}
}
}
}
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']);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$peralatan = Peralatan::find($id);
if (!$peralatan) {
return "Not Found";
}
$inBooking = Booking::where('id_barang', '=', $id)->count();
$inTransaksi = Transaksi::where('id_barang', '=', $id)->count();
$inPerbaakan = Perbaikan::where('id_barang', '=', $id)->count();
if ($inBooking > 0 || $inTransaksi > 0 || $inPerbaakan > 0) {
return "Tidak dapat menghapus";
} else {
$peralatan->delete();
return 1;
}
}
