Diagnostic: Check Voucher Tables

1. Check Table 'vouchers'

✓ Table 'vouchers' EXISTS

Table Structure:

Field	Type	Null	Key	Default	Extra
id	int	NO	PRI		auto_increment
license_id	int	NO	MUL
code	varchar(50)	NO	UNI
discount_type	enum('percentage','fixed')	NO
discount_value	decimal(10,2)	NO
min_purchase	decimal(10,2)	YES		0.00
max_discount	decimal(10,2)	YES
usage_limit	int	YES
used_count	int	YES		0
valid_from	datetime	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED
valid_until	datetime	YES
is_active	tinyint(1)	YES		1
created_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED

Total vouchers: 2

2. Check Table 'voucher_usage'

✓ Table 'voucher_usage' EXISTS

Table Structure:

Field	Type	Null	Key	Default	Extra
id	int	NO	PRI		auto_increment
voucher_id	int	NO	MUL
order_id	int	NO	MUL
discount_amount	decimal(10,2)	NO
used_at	timestamp	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED

Total usage records: 0

3. Database Connection Info

Setting	Value
Database Host	localhost
Database Name	gobotix_ichibana
Database User	gobotix_selfservicelab
Connection Status	Connected

4. Test INSERT Query

Sample INSERT query yang akan dijalankan bila save voucher:

INSERT INTO vouchers (license_id, code, discount_type, discount_value, min_purchase, max_discount, usage_limit, valid_until, is_active)
VALUES (1, 'TEST10', 'percentage', 10.00, 0.00, NULL, NULL, NULL, 1)

LANGKAH PENYELESAIAN:

Buka phpMyAdmin di cPanel
Pilih database: gobotix_ichibana
Klik tab 'SQL'
Copy & paste semua SQL dari file voucher_system_simple.sql
Klik 'Go' untuk execute
Refresh page ini untuk check semula

🔄 Refresh Check

Kembali ke Vouchers