[kas] alter 2022-06-21

CREATE TABLE `rm_purchasing_req` (
  `rm_purchasing_req_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rm_purchasing_req_code` varchar(50) NOT NULL,
  `rm_purchasing_req_delivery_address` text,
  `rm_purchasing_req_date` date NOT NULL,
  `rm_purchasing_req_note` text,
  `rm_purchasing_req_status` enum('closed','open') NOT NULL DEFAULT 'open' COMMENT 'penanda data request yang muncul ketika create po',
  `rm_purchasing_req_input_datetime` datetime NOT NULL,
  `rm_purchasing_req_input_admin_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`rm_purchasing_req_id`),
  UNIQUE KEY `rm_purchasing_req_code` (`rm_purchasing_req_code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='tabel request pembelian barang';

CREATE TABLE `rm_purchasing_req_detail` (
  `rm_purchasing_req_detail_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rm_purchasing_req_detail_rm_purchasing_req_id` int(10) unsigned NOT NULL,
  `rm_purchasing_req_detail_raw_material_id` int(10) unsigned NOT NULL,
  `rm_purchasing_req_detail_raw_material_code` varchar(20) NOT NULL,
  `rm_purchasing_req_detail_raw_material_name` varchar(255) DEFAULT NULL,
  `rm_purchasing_req_detail_raw_material_unit` varchar(20) DEFAULT NULL,
  `rm_purchasing_req_detail_quantity` decimal(15,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`rm_purchasing_req_detail_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='tabel request detail pembelian barang';

ALTER TABLE `rm_purchasing`
ADD `rm_purcashing_rm_purchasing_req_id` INT(10)  UNSIGNED  NOT NULL  COMMENT 'id request pembelian'  AFTER `rm_purchasing_id`,
ADD `rm_purchasing_extra_discount_type` ENUM('percent','value')  NULL  DEFAULT NULL  AFTER `rm_purchasing_total_price`,
ADD `rm_purchasing_extra_discount_percent` DECIMAL(5,2)  NOT NULL  DEFAULT '0.00'  AFTER `rm_purchasing_extra_discount_type`,
CHANGE `rm_purchasing_extra_discount` `rm_purchasing_extra_discount_value` DECIMAL(15,2)  NOT NULL  DEFAULT '0.00';

ALTER TABLE `rm_purchasing_detail`
ADD `rm_purchasing_detail_subtotal_price` DECIMAL(15,2)  NOT NULL  DEFAULT '0.00'  AFTER `rm_purchasing_detail_unit_price`,
ADD `rm_purchasing_detail_discount_type` ENUM('percent','value')  NULL  DEFAULT NULL  AFTER `rm_purchasing_detail_subtotal_price`,
ADD `rm_purchasing_detail_discount_percent` DECIMAL(5,2)  NOT NULL  DEFAULT '0.00'  AFTER `rm_purchasing_detail_discount_type`,
ADD `rm_purchasing_detail_discount_value` DECIMAL(15,2)  NOT NULL  DEFAULT '0.00'  AFTER `rm_purchasing_detail_discount_percent`,
ADD `rm_purchasing_detail_subtotal_nett_price` DECIMAL(15,2)  NOT NULL  DEFAULT '0.00'  AFTER `rm_purchasing_detail_discount_value`;


CREATE TABLE `rm_purchasing_config` (
  `rm_purchasing_config_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rm_purchasing_config_admin_group_id` int(10) unsigned NOT NULL,
  `rm_purchasing_config_value_min` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT 'nilai minimal data muncul, jika nol maka tidak ada batas minimal',
  `rm_purchasing_config_value_max` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT 'nilai maksimal data muncul, jika nol maka tidak ada batas maksimal',
  PRIMARY KEY (`rm_purchasing_config_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='tabel konfigurasi approval pembelian barang berdasarkan nilai pembelian';