public function edit($id)
{
$product = Product::find($id);
$productTypes = ProductType::listSelect();
$units = Unit::orderBy('id', 'desc')->lists('name', 'id');
return view('products.edit', compact('product', 'productTypes', 'units'));
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
$categories = Category::forLoggedInUser()->lists('name', 'id');
$units = Unit::forLoggedInUser()->lists('name', 'id');
$sources = Source::forLoggedInUser()->lists('name', 'id');
return view('books.create', compact('categories', 'units', 'sources'));
}
public function index()
{
$types = Type::All();
$units = Unit::All();
$formulas = Formula::All();
return compact('types', 'units', 'formulas');
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Unit::create(['name' => 'PCS']);
Unit::create(['name' => 'EA']);
Unit::create(['name' => 'SET']);
Unit::create(['name' => 'MT']);
}
/**
* Get the response for a forbidden operation.
*
* @return \Illuminate\Http\Response
*/
public function forbiddenResponse()
{
$total = Unit::findOrFail($this->get('unit_id'))->evaluations->sum('value');
$message = trans('messages.the_maximum_value_of_evaluation', ['value' => 100 - $total]);
Flash::info($message);
return redirect()->route('teacher.evaluations.create')->withInput();
}
public function run()
{
$units = [["symbol" => "PA88", "description" => "An ninh chính trị tư tưởng", "block" => "AN"], ["symbol" => "PA92", "description" => "xxxxxxxxx", "block" => "AN"], ["symbol" => "PC45", "description" => "Phòng chống mà túy", "block" => "CS"]];
foreach ($units as $unit) {
Unit::create($unit);
}
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$unit = Unit::find($id);
if (isset($unit)) {
$unit->delete();
}
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show(Order $order)
{
$user = Sentinel::findById($order->user_id);
$unit = Unit::all();
$baskets = $user->baskets->where('order_id', $order->id);
return view('cart.history', compact('order', 'baskets', 'unit'));
}
/**
* Show the form for creating a new resource.
*
* @param Request $request
* @return $this
*/
public function create(Request $request)
{
if ($request->has('unit')) {
$units = Unit::findOrFail($request->get('unit'))->course->units->lists('title', 'id');
} else {
$units = Unit::where('user_id', Auth::user()->id)->lists('title', 'id');
}
return view('teacher.questions.create')->with('units', $units)->with('title', trans('titles.create_new_question'));
}
public function edit($id)
{
$user = User::findOrFail($id);
$bahagian = Bahagian::lists('nama', 'id');
$cawangan = Cawangan::lists('nama', 'id');
$level = Level::lists('nama', 'id');
$unit = Unit::lists('nama', 'id');
return View('members.admin.pengguna', compact('user', 'bahagian', 'cawangan', 'level', 'unit'));
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
DB::table('units')->delete();
$units = array(['name' => 'Feet'], ['name' => 'Inches'], ['name' => 'Each'], ['name' => 'Ounces'], ['name' => 'Square Foot']);
foreach ($units as $u) {
Unit::create($u);
}
Model::reguard();
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$totalprice = 0;
$user = Sentinel::getUser();
$num = $user->baskets->where('order_id', 0)->count();
$items = Basket::select(DB::raw('products.name,products.pic,baskets.id,baskets.count,baskets.unit_id,baskets.price,baskets.product_id, baskets.price*baskets.count as total'))->join('products', 'products.id', '=', 'baskets.product_id')->where('baskets.user_id', '=', $user->id)->where('baskets.order_id', 0)->get();
foreach ($items as $item) {
$totalprice += $item->total;
}
return response()->json(['result' => true, 'count' => $num, 'cartdata' => view('cart', array('items' => $items, 'total' => $totalprice, 'unit' => Unit::all()))->render()]);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy(Request $request, $id)
{
$response = Unit::deleteByCondition($id);
if ($request->ajax()) {
return $response;
}
if ($response['status']) {
flash()->success(trans('unit.label.name'), $response['message']);
} else {
flash()->success(trans('unit.label.name'), $response['message']);
}
return redirect('/units');
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$product = Product::find($id);
if (!$product) {
$product = Product::where('alias', $id)->first();
}
if ($product) {
$unit = Unit::find($product->unit_id);
$category = ProductCategory::find($product->product_category_id);
return view('product', ['categories' => $this->categories, 'selectedCategory' => $category, 'product' => $product, 'unit' => $unit, 'title' => LANG . '_title', 'description' => LANG . '_description', 'tech_description' => LANG . '_tech_description', 'text' => LANG . '_text', 'color' => LANG . '_color', 'unit_title' => LANG . '_unit', 'file' => LANG . '_file', 'seo_title' => LANG . '_seo_title', 'seo_description' => LANG . '_seo_description', 'seo_keywords' => LANG . '_seo_keywords']);
}
return redirect('catalog');
}
public function storeData(Request $request)
{
$parameter = $request->input('parameter');
$local = $request->input('local');
$data = json_decode($request->input('data'));
$local = Local::where('name', '=', $local)->get();
switch ($parameter) {
case 'device':
$device = new Device();
$device->id = (int) $data->id + (int) $local[0]->constant;
$device->name = $data->name;
$device->location = $data->location;
$device->interval = $data->interval;
$device->local_id = $local[0]->id;
$device->save();
break;
case 'mapping':
$mapping = new Mapping();
$mapping->id = (int) $data->id + (int) $local[0]->constant;
$mapping->device_id = (int) $data->device_id + (int) $local[0]->constant;
$mapping->type_id = $data->type_id;
$mapping->unit_id = $data->unit_id;
$mapping->min_threshold = $data->min_threshold;
$mapping->max_threshold = $data->max_threshold;
$mapping->save();
break;
case 'data':
$mapping_id = (int) $data->mapping_id + (int) $local[0]->constant;
$mapping = Mapping::where('id', '=', $mapping_id)->get();
$device_id = $mapping[0]->device_id;
$type_id = $mapping[0]->type_id;
$unit = Unit::find($mapping[0]->unit_id)->unit;
$convert = new Convert();
$convert->device_id = $device_id;
$convert->type_id = $type_id;
$convert->value = $this->convert($data->value, $type_id, $unit);
$convert->timestamp = $data->timestamp;
$convert->save();
break;
default:
break;
}
return 'true';
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
//dd($id);
//
//
$brands = Brand::all();
$categories = Category::all();
$product = Product::with('description')->find($id);
$prices = $product->prices;
//$mrps = Mrp::with('unit')->where('product_id', $id)->get();
//dd($mrp);
$images = $product->images;
$units = Unit::all();
return view('admin/product/edit', compact('product', 'categories', 'brands', 'images', 'units', 'prices'));
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$object = Model::find($id);
if ($object) {
$params = $request->only('img', 'slider_img', 'ru_slider', 'en_slider', 'ua_slider', 'product_category_id', 'unit_id', 'ru_title', 'ru_description', 'ru_file', 'ru_seo_title', 'ru_seo_keywords', 'ru_seo_description', 'en_title', 'en_description', 'en_file', 'en_seo_title', 'en_seo_keywords', 'en_seo_description', 'ua_title', 'ua_description', 'ua_file', 'ua_seo_title', 'ua_seo_keywords', 'ua_seo_description');
$filter = $object->validator($params, ['ru_title' => 'required|min:2|max:150|unique:products,ru_title,' . $id, 'en_title' => 'required|min:2|max:150|unique:products,en_title,' . $id, 'ua_title' => 'required|min:2|max:150|unique:products,ua_title,' . $id]);
if ($filter->fails()) {
if ($request->ajax()) {
return $this->responseAnswer(true, $params, $filter->errors());
} else {
$error = $filter->errors()->toArray();
$params['id'] = $id;
$params['img'] = $object->img;
$categories = ProductCategory::all();
$units = Unit::all();
$options = $object->options();
return view('admin.product.edit', ['input' => $params, 'error' => $error, 'categories' => $categories, 'units' => $units, 'options' => $options]);
}
}
if ($request->hasFile('img')) {
$params['img'] = $this->upload('img');
if ($object->img && file_exists(public_path() . DS . 'uploads' . DS . 'product' . DS . $object->img)) {
unlink(public_path() . DS . 'uploads' . DS . 'product' . DS . $object->img);
}
} else {
unset($params['img']);
}
if ($request->hasFile('slider_img')) {
$params['slider_img'] = $this->upload('slider_img');
if ($object->slider_img && file_exists(public_path() . DS . 'uploads' . DS . 'product' . DS . $object->slider_img)) {
unlink(public_path() . DS . 'uploads' . DS . 'product' . DS . $object->slider_img);
}
} else {
unset($params['slider_img']);
}
if ($request->hasFile('ru_file')) {
$params['ru_file'] = $this->uploadPdf('ru_file');
if ($object->ru_file && file_exists(public_path() . DS . 'uploads' . DS . 'product' . DS . 'pdfs' . DS . $object->ru_file)) {
unlink(public_path() . DS . 'uploads' . DS . 'product' . DS . 'pdfs' . DS . $object->ru_file);
}
} else {
unset($params['ru_file']);
}
if ($request->hasFile('en_file')) {
$params['en_file'] = $this->uploadPdf('en_file');
if ($object->en_file && file_exists(public_path() . DS . 'uploads' . DS . 'product' . DS . 'pdfs' . DS . $object->en_file)) {
unlink(public_path() . DS . 'uploads' . DS . 'product' . DS . 'pdfs' . DS . $object->en_file);
}
} else {
unset($params['en_file']);
}
if ($request->hasFile('ua_file')) {
$params['ua_file'] = $this->uploadPdf('ua_file');
if ($object->ua_file && file_exists(public_path() . DS . 'uploads' . DS . 'product' . DS . 'pdfs' . DS . $object->ua_file)) {
unlink(public_path() . DS . 'uploads' . DS . 'product' . DS . 'pdfs' . DS . $object->ua_file);
}
} else {
unset($params['ua_file']);
}
$params['on_top'] = $request->has('on_top');
$params['alias'] = $this->makeAlias($params['ru_title']);
$object->fill($params);
$object->save();
if ($request->ajax()) {
return $this->responseAnswer(false, $object);
} else {
$categories = ProductCategory::all();
return redirect('admin/product/' . $object->id . '/edit');
}
}
if ($request->ajax()) {
return $this->responseAnswer(true, $params, null, trans('product.bad_product'));
} else {
return redirect('admin/products');
}
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$Unit = new Unit();
return $Unit->getUnit();
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$object = Model::find($id);
if ($object) {
$object->delete();
}
return redirect()->back();
}
public function destroy($id)
{
$unit = Unit::find($id);
if ($unit != null) {
$unit->delete();
}
return back();
}
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']);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//
return Unit::all();
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
Unit::destroy($id);
return redirect(route('admin.unit.index'));
}
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'));
}
/**
* Remove the specified resource from storage.
*
* @param $id
* @return \Illuminate\Http\RedirectResponse
*/
public function destroy($id)
{
$unit = Unit::findOrFail($id);
$unit->delete();
$message = trans('messages.unit_successfully_removed');
Flash::info($message);
return redirect()->route('teacher.courses.show', $unit->course);
}
/**
* @param Route $route
*/
public function __construct(Route $route)
{
$this->route = $route;
$this->course = Unit::findOrFail($route->getParameter('units'))->course->id;
}
/**
* Display the specified resource.
*
* @param int $id
* @param ShowUnitRequest|Request $request
* @return Response
*/
public function show($id, ShowUnitRequest $request)
{
$unit = Unit::findOrFail($id);
return view('units.show')->with('unit', $unit)->with('title', $unit->title);
}
public function getAvailableUnits($id)
{
$file = file_get_contents("units.txt");
$units = json_decode($file, true);
$position = Position::find($id);
$x = $position->x;
$y = $position->y;
$position = Position::where('y', $y)->where('x', $x)->get()->lists('id');
$city = City::whereIn('position_id', $position)->get();
if (count($city) == 0) {
return $city;
} else {
switch ($city[0]->tier) {
case 1:
$txt = 'tier1';
break;
case 2:
$txt = 'tier2';
break;
}
$units = Unit::whereIn('Id', $units[$txt])->with('resource')->get();
return \App\CityEffectApplier::modifyUnitPricesByCity($units, $city[0]);
}
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$units = Unit::with('resource')->get();
return $units;
}
