public function category(News $news, $kat_id)
{
$title = Kategori::where('id', $kat_id)->first()->nama_kategori;
$stories = $news->orderBy('created_at', 'DESC')->where('kategori_id', $kat_id)->paginate(10);
$headers = null;
$sidebar = $news->orderBy('dibaca', 'DESC')->limit(5)->get();
return view('sowindows.home', compact(['stories', 'title', 'headers', 'sidebar']));
}
public function postHapus(Request $request)
{
$id = $request->id;
$id = explode(",", $id);
foreach ($id as $val) {
Kategori::where('id', $val)->delete();
}
}
public function kategori($slug)
{
$data['LinkPage'] = "{$slug}?page=";
$data['all_kategori'] = Kategori::all();
$data['kategori'] = Kategori::where('slug', $slug)->first();
$data['blogs'] = DB::table('site_blog')->join('site_blog_kategori', 'site_blog.id', '=', 'site_blog_kategori.id_blog')->join('site_kategori', 'site_kategori.id', '=', 'site_blog_kategori.id_kategori')->where('site_kategori.slug', $slug)->where('site_blog.draft', 0)->where('site_blog.arsip', 0)->select('site_blog.*', 'site_kategori.nama_kategori')->orderBy('site_blog.id', 'desc')->paginate($this->Perpage);
$data['populer'] = $this->BlogLainnya(4);
return view('front.blog.kategori', $data);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($jenis, $id)
{
if ($jenis == "artikel") {
$data = Artikel::find($id);
$data->delete();
return redirect('/bos/artikel');
}
if ($jenis == "kategori") {
$data = Kategori::find($id);
$data->delete();
return redirect('/bos/kategori');
}
}
public function kesalahan()
{
$bil = 1;
$datas = Kesalahan::orderBy('kategori_id', 'asc')->get();
$datas2 = Kategori::all();
return View('members.setup.kesalahan', compact('bil', 'datas', 'datas2'));
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function postSimpan(Request $request)
{
$jenis = $request->tipe;
$Max_urut = Menu::where('parent_id', $request->parent_id)->where('lokasi', $request->lokasi)->max('urutan');
$urutan = $Max_urut + 1;
$id_arr = [];
$judul_arr = [];
$link_arr = [];
if ($jenis == "Kategori" || $jenis == "Halaman") {
foreach ($request->arr_value as $Val) {
if ($jenis == "Kategori") {
$Data = Kategori::find($Val);
$link = url('/blog/Kategori') . "/" . $Data->slug;
$judul = $Data->nama_kategori;
$judul_arr[] = $judul;
$link_arr[] = $link;
} else {
$Data = Page::find($Val);
$link = url('/page') . "/" . $Data->slug;
$judul = $Data->judul;
$judul_arr[] = $judul;
$link_arr[] = $link;
}
$Menu = new Menu();
$Menu->judul = $judul;
$Menu->link = $link;
$Menu->parent_id = $request->parent_id;
$Menu->urutan = $urutan;
$Menu->lokasi = $request->lokasi;
$Menu->jenis = $jenis;
$Menu->save();
$id_arr[] = $Menu->id;
}
} else {
$Menu = new Menu();
$Menu->judul = $request->judul;
$Menu->link = $request->link;
$Menu->parent_id = $request->parent_id;
$Menu->urutan = $urutan;
$Menu->lokasi = $request->lokasi;
$Menu->jenis = $jenis;
$Menu->save();
$id_arr[] = $Menu->id;
}
?>
<?php
$no = 0;
?>
<?php
foreach ($id_arr as $id) {
?>
<?php
$judul_ = $jenis == "Kategori" || $jenis == "Halaman" ? $judul_arr[$no] : $request->judul;
?>
<?php
$link_ = $jenis == "Kategori" || $jenis == "Halaman" ? $link_arr[$no] : $request->link;
?>
<?php
$selector_id = $request->parent_id == 0 ? "" : "2";
?>
<div class="panel panel-default" id="arrayOrder<?php
echo $selector_id;
?>
-<?php
echo $id;
?>
" style="margin-bottom:5px;color:#000">
<div class="panel-heading" style="border:none;background:#eee;">
<h4 class="panel-title">
<a data-toggle="collapse" data-parent="#primary-menu" href="#menu-<?php
echo $id;
?>
">
<span class='judul'><?php
echo $judul_;
?>
<?php
echo $request->parent_id == 0 ? "" : "<small> Sub Menu</small>";
?>
</span>
<label class="pull-right">
<small><?php
echo $jenis;
?>
</small>
</label>
</a>
</h4>
</div>
<div id="menu-<?php
echo $id;
?>
" class="panel-collapse collapse">
<div class="panel-body" style="background:#fff;height:auto;max-height:200px;overflow-y:scroll;color:#444">
<input type="hidden" name="id" value="<?php
echo $id;
?>
">
<?php
if ($jenis == "Kategori" || $jenis == "Halaman") {
?>
<label>Nama Menu</label>
<input type="text" class="form-control" name="nama_menu" value="<?php
echo $judul_;
?>
">
<input type="hidden" name="link" value="<?php
echo $link_;
?>
">
<?php
} else {
?>
<label>Nama Menu</label>
<input type="text" class="form-control" name="nama_menu" value="<?php
echo $judul_;
?>
">
<br>
<label>Link/Url</label>
<input type="text" class="form-control" name="link" value="<?php
echo $link_;
?>
">
<?php
}
?>
<br>
<a href="javascript:;" class="update-menu-item" style="color:green">Simpan</a>
<label class="pull-right">
<a href="javascript:;" class="hapus-menu-item" style="color:#a00">Hapus</a>
</label>
</div>
</div>
</div>
<?php
$no++;
?>
<?php
}
?>
<?php
}
public function store()
{
Kategori::create(Request::all());
return response()->json(array('success' => true));
}
/**
* Show the form for creating a new resource.
*
* @return Response
*/
public function create($id_1)
{
if (Auth::user()->role_id == 1 || Auth::user()->role_id == 2) {
if (Request::isMethod('get')) {
$this->data = array();
$this->data['kategori'] = Kategori::find($id_1);
return View::make('admin.article.create', $this->data);
} else {
if (Request::isMethod('post')) {
$data = Input::all();
date_default_timezone_set('Asia/Jakarta');
// CDT
$current_date = date('Y-m-d');
$name = $_FILES['imginp']['name'];
$test = pathinfo($name, PATHINFO_FILENAME);
$target_dir = "artikel/";
$original_name = $test;
$imageFileType = pathinfo($name, PATHINFO_EXTENSION);
//$target_file = $target_dir . basename($_FILES["imginp"]["name"]);
$uploadOk = 1;
// Check if image file is a actual image or fake image
if (isset($_POST["submit"])) {
$check = getimagesize($_FILES["imginp"]["tmp_name"]);
if ($check !== false) {
echo "File is an image - " . $check["mime"] . ".";
$uploadOk = 1;
} else {
echo "File is not an image.";
$uploadOk = 0;
}
}
if ($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg" && $imageFileType != "gif") {
echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";
$uploadOk = 0;
}
// Check if file already exists
$i = 1;
while (file_exists($target_dir . $test . "." . $imageFileType)) {
$test = (string) $original_name . $i;
$name = $test . "." . $imageFileType;
$i++;
}
$target_file = $target_dir . $name;
// Check file size
if ($_FILES["imginp"]["size"] > 500000) {
echo "Sorry, your file is too large.";
$uploadOk = 0;
}
// Allow certain file formats
// Check if $uploadOk is set to 0 by an error
if ($uploadOk == 0) {
echo "Sorry, your file was not uploaded.";
// if everything is ok, try to upload file
} else {
if (move_uploaded_file($_FILES["imginp"]["tmp_name"], $target_file)) {
echo "The file " . basename($_FILES["imginp"]["name"]) . " has been uploaded.";
} else {
echo "Sorry, there was an error uploading your file.";
}
}
$target_file_final = "../../" . $target_file;
Artikel::insertGetId(array('judul' => $data['judul'], 'konten' => $data['konten'], 'tanggal' => $current_date, 'gambar' => $target_file_final, 'users_id' => Auth::user()->id, 'kategori_id' => $id_1));
return redirect('admin/artikel/' . $id_1);
}
}
}
}
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'));
}
public function buatPengaduan()
{
$listKategori = Kategori::getListKategori();
return view('pages.buat_pengaduan', compact('listKategori'));
}
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']);
}
public function getKategoriEdit($id_blog)
{
$Kategori = Kategori::all();
$BlogKategori = BlogKategori::where('id_blog', $id_blog)->get();
return view('admin.layout.inc.getkategoriedit', ['Kategori' => $Kategori, 'BlogKategori' => $BlogKategori]);
}
