<?php
defined('BASEPATH') or exit('No direct script access allowed');

class ManageSku extends CI_Controller
{
	function __construct()
	{
		parent::__construct();
		$this->load->model('ModelSku', 'MSku');
		$this->load->model('ModelBeli', 'MBeli');
		$this->load->model('ModelProcessor', 'MProcessor');
		$this->load->model('ModelRam', 'MRam');
		$this->load->model('ModelHarddisk', 'MHarddisk');
		$this->load->model('ModelSsd', 'MSsd');
		$this->load->model('ModelVga', 'MVga');
		$this->load->model('ModelOs', 'MOs');
		$this->load->model('ModelDvd', 'MDvd');
		$this->load->model('ModelSp', 'MSp');
		$this->load->model('ModelKeyMou', 'MKeyMou');
		$this->load->model('ModelWarna', 'MWarna');
		$this->load->model('ModelRaid', 'MRaid');
		$this->load->library(['datatables', 'form_validation']);
		$this->form_validation->set_error_delimiters('', '');
	}
	public function output_json($data, $encode = true)
	{
		if ($encode) $data = json_encode($data);
		$this->output->set_content_type('application/json')->set_output($data);
	}
	public function index()
	{
		$username = $this->session->userdata('username');
		$jabatan = $this->session->userdata('jabatan');
		if ($username == null) {
			redirect("Action");
		} elseif ($jabatan != "ADMIN") {
			redirect("Action");
		}
		
		$datSku	= $this->MSku->getDataSku();

		$data = [
			'sidebar'	=> "data proses sku",
			'navChild'	=> "data proses skuinput",
			'sku' 		=> $datSku
		];

		$this->load->view('master/Sku', $data);
	}
	
	public function addPWA()
	{
		$username = $this->session->userdata('username');
		if ($username == null) {
			redirect("Login");
		}
		$datSku			= $this->MSku->getDataSku();
		$datBeli 		= $this->MBeli->getDataBeliPWA();
		$datProcessor 	= $this->MProcessor->getDataProcessor();
		$datRam 		= $this->MRam->getDataRam();
		$datHarddisk 	= $this->MHarddisk->getDataHarddisk();
		$datSsd 		= $this->MSsd->getDataSsd();
		$datVga 		= $this->MVga->getDataVga();
		$datOs 			= $this->MOs->getDataOs();
		$datDvd		 	= $this->MDvd->getDataDvd();
		$datSp	 		= $this->MSp->getDataSp();
		$datKeyMou 		= $this->MKeyMou->getDataKeyMou();
		$data = [
			'sidebar'	=> "data proses sku",
			'navChild'	=> "data proses skuinput",
			'sku'		=> $datSku,
			'beli' 		=> $datBeli,
			'processor' => $datProcessor,
			'ram' 		=> $datRam,
			'hdd' 		=> $datHarddisk,
			'ssd' 		=> $datSsd,
			'vga' 		=> $datVga,
			'os' 		=> $datOs,
			'dvd'		=> $datDvd,
			'sp'		=> $datSp,
			'keymou' 	=> $datKeyMou
		];
		//var_dump($data);
		$this->load->view('proses/TambahSkuPWA', $data);
	}
	
	public function addNB()
	{
		$username = $this->session->userdata('username');
		if ($username == null) {
			redirect("Login");
		}
		$datSku			= $this->MSku->getDataSku();
		$datBeli 		= $this->MBeli->getDataBeliNB();
		$datProcessor 	= $this->MProcessor->getDataProcessor();
		$datRam 		= $this->MRam->getDataRam();
		$datHarddisk 	= $this->MHarddisk->getDataHarddisk();
		$datSsd 		= $this->MSsd->getDataSsd();
		$datVga 		= $this->MVga->getDataVga();
		$datOs 			= $this->MOs->getDataOs();
		$datDvd		 	= $this->MDvd->getDataDvd();
		$datWarna 		= $this->MWarna->getDataWarna();
		$data = [
			'sidebar'	=> "data proses sku",
			'navChild'	=> "data proses skuinput",
			'sku'		=> $datSku,
			'beli' 		=> $datBeli,
			'processor' => $datProcessor,
			'ram' 		=> $datRam,
			'hdd' 		=> $datHarddisk,
			'ssd' 		=> $datSsd,
			'vga' 		=> $datVga,
			'os' 		=> $datOs,
			'dvd'		=> $datDvd,
			'warna' 	=> $datWarna
		];
		//var_dump($data);
		$this->load->view('proses/TambahSkuNotebook', $data);
	}

	public function addSRV()
	{
		$username = $this->session->userdata('username');
		if ($username == null) {
			redirect("Login");
		}
		$datSku			= $this->MSku->getDataSku();
		$datBeli		= $this->MBeli->getDataBeliServer();
		$datProcessor 	= $this->MProcessor->getDataProcessor();
		$datRam 		= $this->MRam->getDataRam();
		$datHarddisk 	= $this->MHarddisk->getDataHarddisk();
		$datSsd 		= $this->MSsd->getDataSsd();
		$datVga 		= $this->MVga->getDataVga();
		$datOs 			= $this->MOs->getDataOs();
		$datDvd		 	= $this->MDvd->getDataDvd();
		$datKeyMou 		= $this->MKeyMou->getDataKeyMou();
		$datRaid 		= $this->MRaid->getDataRaid();
		$data = [
			'sidebar'	=> "data proses sku",
			'navChild'	=> "data proses skuinput",
			'sku'		=> $datSku,
			'beli'		=> $datBeli,
			'processor' => $datProcessor,
			'ram' 		=> $datRam,
			'hdd' 		=> $datHarddisk,
			'ssd' 		=> $datSsd,
			'vga' 		=> $datVga,
			'os' 		=> $datOs,
			'dvd'		=> $datDvd,
			'keymou' 	=> $datKeyMou,
			'raid' 		=> $datRaid
		];
		//var_dump($data);
		$this->load->view('proses/TambahSkuServer', $data);
	}
	
	public function savePWA()
	{
		$method 	= $this->input->post('method');
		$id_sku		= $this->input->post('id');
		$nama_sku	= $this->input->post('nama_sku');
		$beli	 	= $this->input->post('BELI');
		$processor 	= $this->input->post('PROCESSOR');
		$ram 		= $this->input->post('RAM');
		$hdd 		= $this->input->post('HDD');
		$ssd 		= $this->input->post('SSD');
		$vga 		= $this->input->post('VGA');
		$os 		= $this->input->post('OS');
		$dvd 		= $this->input->post('DVD');
		$sp 		= $this->input->post('SP');
		$keymou 	= $this->input->post('KEYMOU');
		
		$input = [
			'NAMA_SKU'		=> $nama_sku,
			'PROCESSOR_ID'	=> $processor,
			'RAM_ID'		=> $ram,
			'HDD_ID'		=> $hdd,
			'SSD_ID'		=> $ssd,
			'VGA_ID'		=> $vga,
			'OS_ID'			=> $os,
			'DVD_ID'		=> $dvd,
			'SP_ID'			=> $sp,
			'KEYMOU_ID'		=> $keymou,
			'RAID_ID'		=> '1',
			'WARNA_ID'		=> '1'
		];
		
		$action = $this->MSku->create('sku', $input);
		
		$datID	= $this->MBeli->getDataBeliSKU($beli);
		
		if (is_array($datID)||is_object($$datID)) {	
			
			$datSkuID	= $this->MSku->getDataSkuID($nama_sku);
			
			$input2 = [
			'SKU_ID'	=> $datSkuID[0]['ID_SKU']
			];			
			
			$action2 = $this->MSku->update('beli', $input2, 'ID_BELI',$datID[0]['ID_BELI']);
		}
			
		if ($action) {
			$this->session->set_flashdata('flash', 'ditambah');
			redirect('ManageSku');
		} else {
			$this->session->set_flashdata('flashgagal', 'ditambah');
			redirect('ManageSku');
		}
		
	}
	
	public function saveNB()
	{
		$method 	= $this->input->post('method');
		$id_sku		= $this->input->post('id');
		$nama_sku	= $this->input->post('nama_sku');
		$beli		= $this->input->post('BELI');
		$processor 	= $this->input->post('PROCESSOR');
		$ram 		= $this->input->post('RAM');
		$hdd 		= $this->input->post('HDD');
		$ssd 		= $this->input->post('SSD');
		$vga 		= $this->input->post('VGA');
		$os 		= $this->input->post('OS');
		$dvd 		= $this->input->post('DVD');
		$warna 		= $this->input->post('WARNA');
		
		$input = [
			'NAMA_SKU'		=> $nama_sku,
			'PROCESSOR_ID'	=> $processor,
			'RAM_ID'		=> $ram,
			'HDD_ID'		=> $hdd,
			'SSD_ID'		=> $ssd,
			'VGA_ID'		=> $vga,
			'OS_ID'			=> $os,
			'DVD_ID'		=> $dvd,
			'WARNA_ID'		=> $warna,
			'SP_ID'			=> '1',
			'KEYMOU_ID'		=> '1',
			'RAID_ID'		=> '1'	
		];
		
		$action = $this->MSku->create('sku', $input);
		
		$datID	= $this->MBeli->getDataBeliSKU($beli);
		
		if (is_array($datID)||is_object($$datID)) {	
			
			$datSkuID	= $this->MSku->getDataSkuID($nama_sku);
			
			$input2 = [
			'SKU_ID'	=> $datSkuID[0]['ID_SKU']
			];			
			
			$action2 = $this->MSku->update('beli', $input2, 'ID_BELI',$datID[0]['ID_BELI']);
		}
			
		if ($action) {
			$this->session->set_flashdata('flash', 'ditambah');
			redirect('ManageSku');
		} else {
			$this->session->set_flashdata('flashgagal', 'ditambah');
			redirect('ManageSku');
		}
	}
	
	public function saveSRV()
	{
		$method 	= $this->input->post('method');
		$id_sku		= $this->input->post('id');
		$nama_sku	= $this->input->post('nama_sku');
		$beli	 	= $this->input->post('BELI');
		$processor 	= $this->input->post('PROCESSOR');
		$ram 		= $this->input->post('RAM');
		$hdd 		= $this->input->post('HDD');
		$ssd 		= $this->input->post('SSD');
		$vga 		= $this->input->post('VGA');
		$os 		= $this->input->post('OS');
		$dvd 		= $this->input->post('DVD');
		$raid 		= $this->input->post('RAID');
		$keymou 	= $this->input->post('KEYMOU');
				
		$input = [
			'NAMA_SKU'		=> $nama_sku,
			'PROCESSOR_ID'	=> $processor,
			'RAM_ID'		=> $ram,
			'HDD_ID'		=> $hdd,
			'SSD_ID'		=> $ssd,
			'VGA_ID'		=> $vga,
			'OS_ID'			=> $os,
			'DVD_ID'		=> $dvd,
			'KEYMOU_ID'		=> $keymou,
			'RAID_ID'		=> $raid,
			'WARNA_ID'		=> '1',
			'SP_ID'			=> '1'		
		];
		
		$action = $this->MSku->create('sku', $input);
		
		$datID	= $this->MBeli->getDataBeliSKU($beli);
		
		if (is_array($datID)||is_object($$datID)) {	
			
			$datSkuID	= $this->MSku->getDataSkuID($nama_sku);
			
			$input2 = [
			'SKU_ID'	=> $datSkuID[0]['ID_SKU']
			];			
			
			$action2 = $this->MSku->update('beli', $input2, 'ID_BELI',$datID[0]['ID_BELI']);
		}
			
		if ($action) {
			$this->session->set_flashdata('flash', 'ditambah');
			redirect('ManageSku');
		} else {
			$this->session->set_flashdata('flashgagal', 'ditambah');
			redirect('ManageSku');
		}
	}

	public function hapus()
	{
		$id = $this->input->post('id');
		if ($this->MSku->delete('sku', $id, 'ID_SKU')) {
			$this->session->set_flashdata('flash', 'dihapus');
			redirect('ManageSku');
		}
	}

}