public function getCurrentLevel($code, $id)
{
$user = User::find($code);
$level = Level::where('role_id', $id)->get();
return view('html.block.level', compact('level', 'user'));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$position = Position::where('active', 1)->get();
// if is Leader
// if staff edit != dev or yourself => denied
if (Gate::allows('check-leader')) {
$staff = Staff::find($id)->level->role;
if ($staff->name != "Developer" && $id != Auth::user()->id) {
return redirect()->route('admin.staff.index')->with('message', 'Access is denied');
} else {
$level = Level::where('role_id', 4)->get();
$department = Department::where('id', Auth::user()->department_id)->where('active', 1)->get()->first();
}
} else {
if (Gate::allows('check-admin')) {
$staff = Staff::find($id)->level->role;
if ($staff->name == "Developer" && $id != Auth::user()->id) {
return redirect()->route('admin.staff.index')->with('message', 'Access is denied');
} else {
$department = Department::where('active', 1)->get();
$level = Level::where(['role_id' => 2, 'active' => 1])->orWhere(['role_id' => 3, 'active' => 1])->get();
}
} else {
if (Gate::allows('check-manager')) {
$staff = Staff::find($id)->level->role;
if ($staff->name == "Manager" && $id != Auth::user()->id) {
return redirect()->route('admin.staff.index')->with('message', 'Access is denied');
} else {
$level = Level::where('role_id', 3)->orWhere('role_id', 4)->get();
if ($id == Auth::user()->id) {
$department = '';
}
$department = Department::where('active', 1)->get();
}
} else {
$staff_id = Auth::user()->id;
if ($staff_id != $id) {
return redirect()->route('admin.staff.index')->with('message', 'Access is denied');
} else {
$position = Position::where('id', Auth::user()->position_id)->where('active', 1)->get();
$level = Level::where('id', Auth::user()->level_id)->where('active', 1)->get();
$department = Department::where('id', Auth::user()->department_id)->where('active', 1)->get()->first();
}
}
}
}
if ($id == Auth::user()->id) {
$check_account = 1;
} else {
$check_account = 0;
}
$staff = Staff::find($id);
return view('admin.staff.update', compact('id', 'staff', 'position', 'level', 'department', 'check_account'));
}
public function getLevel($id, User $staff)
{
$level = Level::where('role_id', $id)->get();
return view('html.level', compact('level', 'staff'));
}
public function index()
{
$level = Level::where('role_id', '!=', 1)->get();
$role = Role::where('name', '!=', 'SystemAdmin')->get();
return view('admin.level.list', compact('level', 'role'));
}
/**
* Persist a building level to the database
* @param $request
* @param $id
*/
public function persist($request, $id)
{
$building = $this->building->findOrFail($id);
$building->levels()->create(['building_id' => $id, 'level_id' => $request->levelName, 'levelName' => $this->level->where('id', '=', $request->levelName)->first()->levelName]);
$this->updateLevels($building);
}
public function scopeUplevel($query, $level)
{
$query->quiz()->whereDifficultyId(Difficulty::select('id')->orderBy('difficulty', 'asc')->first()->id)->wherein('skill_id', Skill::select('id')->whereLevelId(Level::where('level', '>', $level)->orderBy('level', 'asc')->select('id')->first()->id)->groupBy('track_id')->get())->groupBy('skill_id')->get();
}
public function importEMP($destfile)
{
Excel::load($destfile, function ($reader) {
$rules = ['number' => 'required|unique:employees', 'company_id' => 'required|exists:companies,id', 'department_id' => 'required|exists:departments,id', 'bank_account' => 'required|unique:employees'];
$sheetsCount = $reader->getSheetCount();
for ($i = 0; $i < $sheetsCount; $i++) {
$sheets = $reader->getSheet($i)->toArray();
$company_name = $reader->getSheet($i)->getTitle();
$dept['company_id'] = Company::where('name', $company_name)->value('id');
$sheetCount = count($sheets);
for ($j = 6; $j < $sheetCount; $j++) {
// Get Department ID;
$dept['name'] = $sheets[$j][1];
$dept['costcenter'] = $sheets[$j][10];
$employee['company_id'] = $dept['company_id'];
$employee['department_id'] = Department::where('name', $dept['name'])->where('company_id', $dept['company_id'])->where('costcenter', $dept['costcenter'])->value('id');
$employee['name'] = $sheets[$j][2];
$employee['number'] = $sheets[$j][3];
$employee['level_id'] = Level::where('credit', 400)->value('id');
$employee['category_id'] = Category::where('code', 1)->value('id');
$employee['status_id'] = Status::where('code', 1)->value('id');
$employee['telephone'] = $sheets[$j][4];
$employee['bank_account'] = $sheets[$j][8];
$emp_v = \Validator::make($employee, $rules);
if ($emp_v->fails()) {
} else {
Employee::create($employee);
}
}
}
//END
});
}
public function getFormlevel()
{
$risk = 0;
$risk = Input::get('risk');
$level = Level::where('level', '=', Input::get('level'));
$assets = array();
reset($assets);
$assets = DB::Select(DB::raw("SELECT a.*,level.description as level_desc,\n\t\t\t\tm1.name as create_name,m2.name as update_name,t.description as type,\n c.description as category\n FROM asset_registers a\n\t\t\t\tLEFT JOIN level\n\t\t\t\tON a.level = level.level\n\t\t\t\tLEFT JOIN members m1\n\t\t\t\tON a.created_by = m1.id\n\t\t\t\tLEFT JOIN members m2\n\t\t\t\tON a.updated_by = m2.id\n LEFT JOIN ref_types t\n ON a.type_id = t.id\n LEFT JOIN ref_categories c\n ON a.cat_id = c.id\n\t\t\t\tWHERE a.active = 1\n\t\t\t\tAND a.id = " . Input::get('id') . "\n\t\t"))[0];
// Query ดึงข้อมูลรายละเอียดของแต่ละ node
$unders = array();
$unders = DB::Select(DB::raw("\n \tSELECT ag.*,l.type_name FROM asset_registers ag\n \tLEFT JOIN level l\n \tON ag.level = l.level\n\t\t\tWHERE ag.level > " . Input::get('level') . "\n\t\t\tAND ag.id > " . Input::get('id') . " AND ag.active = 1\n\t\t\tAND ag.project_id = " . Session::get('project_id') . "\n\t\t\tORDER BY ag.parent asc"));
if (Input::get('level') == 3) {
$com_detail = array();
$complex_detail = array();
$color = array();
$bss_unit = array();
$bss_unit = DB::Select(DB::raw("select * from asset_registers where active = 1 and id = " . $assets->parent))[0];
$business_unit = $bss_unit->business_unit_type_colums;
$color = DB::Select(DB::raw("SELECT * FROM complex_detail_default WHERE active = 1 and type = 5 GROUP BY description"));
$com_detail = DB::Select(DB::raw("\n\t\t\t\tselect ac.id,ac.node,ac.complex_id,c.name as 'complex_name'\n\t\t\t\tfrom asset_complex_detail ac\n\t\t\t\tleft join complex c\n\t\t\t\ton ac.complex_id = c.id\n\t\t\t\twhere ac.active = 1\n\t\t\t\tand ac.project_id = " . Session::get('project_id') . "\n\t\t\t\tand ac.node = " . Input::get('id')));
$status = 0;
if (!empty($com_detail)) {
//Status = 1 ต่อเมื่อ มีการบันทึกค่า ลง asset_complex_detail แล้ว
$status = 1;
$complex_detail = DB::Select(DB::raw("\n\t\t\t\tselect ac.id,ac.node,ac.complex_id,c.name as 'complex_name'\n\t\t\t\tfrom asset_complex_detail ac\n\t\t\t\tleft join complex c\n\t\t\t\ton ac.complex_id = c.id\n\t\t\t\twhere ac.active = 1\n\t\t\t\tand ac.project_id = " . Session::get('project_id') . "\n\t\t\t\tand ac.node = " . Input::get('id')))[0];
}
foreach (Complex::where('active', '=', 1)->get() as $com) {
$complexs[$com->id] = $com->name;
}
return View::make('asset_register.level_three')->with(compact('complexs'))->with(compact('assets'))->with(compact('complex_detail'))->with('status', $status)->with('color', $color)->with('business_unit', $business_unit)->with('node', Input::get('id'));
} elseif (Input::get('level') == 8) {
$category = array();
$cat = DB::Select(DB::raw("SELECT be.id,be.category_id,c.description,be.type_id,be.part_id\n\t\t\t\t\tFROM basic_equipments be\n\t\t\t\t\tLEFT JOIN ref_categories c\n\t\t\t\t\tON be.category_id = c.id\n\t\t\t\t\tWHERE be.active = 1\n\t\t\t\t\tAND be.project_id = " . Session::get('project_id')));
foreach ($cat as $c) {
$category[$c->category_id] = $c->description;
}
$asset_basic_failure = array();
$asset_basic_failure = DB::Select(DB::raw("SELECT * FROM asset_basic_failure\n\t\t\t\t\tWHERE active = 1 AND project_id = " . Session::get('project_id')));
// $parantdata = array();
// $parantdata = DB::Select(DB::raw("
// SELECT * FROM asset_registers WHERE active = 1
// AND level = 7 AND id = ".$assets->parent."
// AND project_id = ".Session::get('project_id')
// ))[0];
$equip_part = array();
$equip = array();
$equip = DB::Select(DB::raw("\n\t\t\t\tselect e.*,c.description from basic_equipments e\n\t\t\t\tleft join ref_parts c\n\t\t\t\ton e.part_id = c.id\n\t\t\t\twhere e.active = 1 AND e.category_id = " . $assets->cat_id . "\n\t\t\t\tAND e.type_id = " . $assets->type_id . " AND\n\t\t\t\te.project_id = " . Session::get('project_id')));
foreach ($equip as $c) {
$equip_part[$c->part_id] = $c->description;
}
$failuremode = array();
$mode = DB::Select(DB::raw("select fm.id,fm.cause_id,fm.mode_id,m.description from basic_failures fm\n\t\t\t\tleft join ref_failure_mode m\n\t\t\t\ton fm.mode_id=m.id\n\t\t\t\twhere fm.active = 1\n\t\t\t\tAND fm.project_id = " . Session::get('project_id')));
foreach ($mode as $c) {
$failuremode[$c->mode_id] = $c->description;
}
return View::make('asset_register.level_eight')->with('asset_basic_failure', $asset_basic_failure)->with('node_id', Input::get('id'))->with(compact('equip_part'))->with(compact('failuremode'))->with(compact('assets'))->with(compact('category'));
} elseif (Input::get('level') == 7) {
$unders = array();
$unders = DB::table('asset_registers')->select('*')->where('id', '>', Input::get('id'))->where('level', '>', Input::get('level'))->where('active', '=', 1)->where('project_id', '=', Session::get('project_id'))->orderBy('parent', 'asc')->get();
return View::make('asset_register.level_seven')->with('unders', $unders)->with(compact('assets'));
} else {
return View::make('asset_register.form_other')->with('unders', $unders)->with(compact('assets'));
}
}
public function supprimer()
{
if (\Request::ajax()) {
$numbers = substr(\Input::get('boxes'), 0, -1);
$ids = explode(',', $numbers);
$ids = array_unique($ids);
foreach ($ids as $id) {
$b = Level::where('user_id', \Auth::user()->id)->where('id', $id)->first();
$b->delete();
}
}
}
public function getBranchWhenLevelIsChosen()
{
if (\Request::ajax()) {
$niveau_id = \Input::get('niveau_id');
$level = Level::where('user_id', \Auth::user()->id)->where('id', $niveau_id)->first();
foreach ($level->HasManyBranches as $branch) {
echo '<option value="' . $branch->id . '">' . $branch->nom_branche . '</option>';
}
}
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update(Request $request, $level)
{
$name = Level::where('level', $level)->first()->name;
$level = Level::where('level', $request->level)->first();
$msg = 'Level ' . $level->level . ': ';
$msg .= $level->name != $request->name ? 'Renamed "' . $name . '" -> "' . $request->name . '". ' : '';
$msg .= $level->infos != $request->infos ? 'Modified information' : '';
$level->update(['name' => $request->name, 'infos' => $request->infos]);
makeModification('levels', $msg);
Flash::success('Level modifié avec succès !');
return redirect('admin/levels');
}
public static function AddGradesAndLevels($user_id, $school_year_id)
{
$admin = User::where('id', $user_id)->where('type', 'ecole')->first();
if ($admin) {
$creche = new Grade();
$creche->name = 'Crèche';
$creche->user_id = $user_id;
$creche->school_year_id = $school_year_id;
$creche->save();
if ($creche->id) {
$niveau = new Level();
$niveau->niveau = 'Crèche';
$niveau->user_id = $user_id;
$niveau->grade_id = $creche->id;
$niveau->school_year_id = $school_year_id;
$niveau->save();
}
$mater = new Grade();
$mater->name = 'Maternelle';
$mater->user_id = $user_id;
$mater->school_year_id = $school_year_id;
$mater->save();
if ($mater) {
$niveau = new Level();
$niveau->niveau = 'Petite Section';
$niveau->user_id = $user_id;
$niveau->grade_id = $mater->id;
$niveau->school_year_id = $school_year_id;
$niveau->save();
$niveau = new Level();
$niveau->niveau = 'Moyenne Section';
$niveau->user_id = $user_id;
$niveau->grade_id = $mater->id;
$niveau->school_year_id = $school_year_id;
$niveau->save();
$niveau = new Level();
$niveau->niveau = 'Grande Section';
$niveau->user_id = $user_id;
$niveau->grade_id = $mater->id;
$niveau->school_year_id = $school_year_id;
$niveau->save();
}
$sc = new Grade();
$sc->name = 'Primaire';
$sc->user_id = $user_id;
$sc->school_year_id = $school_year_id;
$sc->save();
if ($sc) {
for ($i = 1; $i <= 6; $i++) {
$niveau = new Level();
$niveau->niveau = 'CE' . $i;
$niveau->user_id = $user_id;
$niveau->grade_id = $sc->id;
$niveau->school_year_id = $school_year_id;
$niveau->save();
}
}
$col = new Grade();
$col->name = 'Collège';
$col->user_id = $user_id;
$col->school_year_id = $school_year_id;
$col->save();
if ($col) {
for ($i = 1; $i <= 3; $i++) {
if ($i == 1) {
$niveau = new Level();
$niveau->niveau = '1ère année Collège';
$niveau->user_id = $user_id;
$niveau->grade_id = $col->id;
$niveau->school_year_id = $school_year_id;
$niveau->save();
} elseif ($i > 1) {
$niveau = new Level();
$niveau->niveau = $i . 'ème année Collège';
$niveau->user_id = $user_id;
$niveau->grade_id = $col->id;
$niveau->school_year_id = $school_year_id;
$niveau->save();
}
}
}
$lyc = new Grade();
$lyc->name = 'Lycée';
$lyc->user_id = $user_id;
$lyc->school_year_id = $school_year_id;
$lyc->save();
if ($lyc) {
$niveau = new Level();
$niveau->niveau = 'Tronc Commun';
$niveau->user_id = $user_id;
$niveau->grade_id = $lyc->id;
$niveau->school_year_id = $school_year_id;
$niveau->save();
if ($niveau->id) {
$l = Level::where('id', $niveau->id)->where('user_id', $user_id)->first();
$branchesTc = ['Tronc Commun Sciences', 'Tronc Commun Lettres et sciences humaines', 'Tronc Commun Technologique', 'Tronc Commun Enseignement Originel'];
foreach ($branchesTc as $br) {
$branche = new Branch();
$branche->nom_branche = $br;
$branche->code_branche = "";
$branche->user_id = $user_id;
$branche->level_id = $niveau->id;
$branche->school_year_id = $school_year_id;
$branche->save();
if ($branche->id) {
$l->onbranches()->attach([$branche->id]);
}
}
}
$niveau = new Level();
$niveau->niveau = '1ère Baccalauréat';
$niveau->user_id = $user_id;
$niveau->grade_id = $lyc->id;
$niveau->school_year_id = $school_year_id;
$niveau->save();
if ($niveau->id) {
$l = Level::where('id', $niveau->id)->where('user_id', $user_id)->first();
$branches1Bac = ['Sciences mathématiques', 'Sciences expérimentales', 'Bac Sciences et Technologies Electriques', 'Bac Sciences et Technologies Mecaniques', 'Arts appliqués', 'Sciences économiques et gestion', 'Lettres et sciences humaines', 'Langue Arabe', 'Sciences de la Chariaa'];
foreach ($branches1Bac as $br) {
$branche = new Branch();
$branche->nom_branche = $br;
$branche->code_branche = "";
$branche->user_id = $user_id;
$branche->level_id = $niveau->id;
$branche->school_year_id = $school_year_id;
$branche->save();
if ($branche->id) {
$l->onbranches()->attach([$branche->id]);
}
}
}
$niveau = new Level();
$niveau->niveau = 'Baccalaureat';
$niveau->user_id = $user_id;
$niveau->grade_id = $lyc->id;
$niveau->school_year_id = $school_year_id;
$niveau->save();
if ($niveau->id) {
$l = Level::where('id', $niveau->id)->where('user_id', $user_id)->first();
$branchesBac = ['Bac Sciences mathématiques A', 'Bac Sciences Mathématiques B', 'Bac Sciences Physiques', 'SVT Bac', 'Bac Sciences Agronomiques', 'Bac Sciences et Technologies Electriques', 'Bac Sciences et Technologies Mecaniques', 'Arts appliqués', 'Bac Sciences économiques', 'Bac Techniques de gestion et comptabilité', 'Bac Lettres', 'Sciences humaines', 'Langue Arabe', 'Sciences de la Chariaa'];
foreach ($branchesBac as $br) {
$branche = new Branch();
$branche->nom_branche = $br;
$branche->code_branche = "";
$branche->user_id = $user_id;
$branche->level_id = $niveau->id;
$branche->school_year_id = $school_year_id;
$branche->save();
if ($branche->id) {
$l->onbranches()->attach([$branche->id]);
}
}
}
}
}
}
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']);
}
public function getClassWhenLevelid()
{
if (\Request::ajax()) {
$nextYearId = \Input::get('nextYearId');
$level_id = \Input::get('level_id');
$level = Level::where('id', $level_id)->where('user_id', \Auth::user()->id)->first();
foreach ($level->classrooms()->where('school_year_id', $nextYearId)->get() as $cr) {
echo '<option value="' . $cr->id . '"> ' . $cr->nom_classe . ' ( ' . $cr->schoolYear->ann_scol . ' ) ' . '</option>';
}
foreach ($level->lesClasses()->where('school_year_id', $nextYearId)->get() as $cr) {
echo '<option value="' . $cr->id . '"> ' . $cr->nom_classe . ' ( ' . $cr->schoolYear->ann_scol . ' ) ' . '</option>';
}
}
}
