332 lines
8.9 KiB
PHP
332 lines
8.9 KiB
PHP
<?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');
|
|
}
|
|
}
|
|
|
|
}
|