INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326160852051','input','1',' MEA1E LG ','TOKO','PM-A','A1E-ZFBX-520-0','AT MODEL SLEP VAR LG 8K ','','0.480','1','100.00','519000','0','0','15000','520000','0','0','0','520000','FIT','00409537','A1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZFBX-520-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='A1E-ZFBX-520-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326160852051','2026-08-16','0.480','2026-08-16','08:52:06','PLG0030823','520000','520000','0','520000','520000','input','2026-08-16 08:52:05','F32616085205');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326160852051','2026-08-16','08:52:06','FIT','520000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260816-0002','D','2026-08-16','08:52:06','input','PENJUALAN','F326160852051','6901466000','520000','6901986000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326160926241','input','1',' MEH1 X 15K','TOKO','PM-H','H1E-YLAH-60-0','KL X NORI BONEKA ANAK CAT VAR UB 34 8K ','','2.130','1','100.00','2305000','0','0','15000','2305000','0','15000','0','2320000','LIS','00381721','H1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLAH-60-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.130',berat_jual_asli=berat_jual_asli+'2.130',stock_jual='1',berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='H1E-YLAH-60-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326160926241','2026-08-16','2.130','2026-08-16','09:26:25','PLG0030824','2305000','2305000','15000','2320000','2320000','input','2026-08-16 09:26:24','F32616092624');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326160926241','2026-08-16','09:26:25','LIS','2320000','15000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260816-0003','D','2026-08-16','09:26:25','input','PENJUALAN','F326160926241','6901986000','2320000','6904306000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326161007301','kasir','1',' MEB1 CM PE','TOKO','PM-B','B1E-ZGXF-9-0','GW MODEL SLEP CM PE 8K ','','0.600','1','100.00','649000','0','0','15000','650000','0','0','0','650000','FIT','00412390','B1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGXF-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='B1E-ZGXF-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326161007301','2026-08-16','0.600','2026-08-16','10:07:31','PLG0030825','650000','650000','0','650000','650000','kasir','2026-08-16 10:07:30','F32616100730');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326161007301','2026-08-16','10:07:31','FIT','650000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260816-0004','D','2026-08-16','10:07:31','kasir','PENJUALAN','F326161007301','6904306000','650000','6904956000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='650000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161007301' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326161007302','kasir',' 1',' MEF3E PM ','TOKO','PM-F','F3E-ZHXH-411-0','GL KREPYAK VERONA SLEP PM 8K ','','3.110','1','100.00','3365000','0','0','15000','3365000','0','0','0','3365000','FIT','00418141','F3E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHXH-411-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.110',berat_jual_asli=berat_jual_asli+'3.110',stock_jual='1',berat_akhir=berat_akhir-'3.110',berat_akhir_asli=berat_akhir_asli-'3.110',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='F3E-ZHXH-411-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326161007302','2026-08-16','3.110','2026-08-16','10:07:31','PLG0030826','3365000','3365000','0','3365000','3365000','kasir','2026-08-16 10:07:30','F32616100730');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326161007302','2026-08-16','10:07:31','FIT','3365000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260816-0005','D','2026-08-16','10:07:31','kasir','PENJUALAN','F326161007302','6904956000','3365000','6908321000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3365000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161007302' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326161019211','kasir','1',' MKPHK X KH','TOKO','PM-P','PHK-ZBXC-218-0','KL X WG SANTA KH 42 9K ','','2.000','1','100.00','2404000','0','0','15000','2405000','0','0','0','2405000','AAT','00387897','PHK','0','0','-','0','1202000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PHK-ZBXC-218-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='PHK-ZBXC-218-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326161019211','2026-08-16','2.000','2026-08-16','10:19:21','PLG0030827','2405000','2405000','0','2405000','2405000','kasir','2026-08-16 10:19:21','F32616101921');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326161019211','2026-08-16','10:19:21','AAT','2405000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260816-0006','D','2026-08-16','10:19:21','kasir','PENJUALAN','F326161019211','6908321000','2405000','6910726000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2405000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161019211' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326161019212','kasir',' 1',' MFPE X UB ','TOKO','PM-P','PEF-YLAH-117-0','CC X WG MODEL TINJU UB 14 8K ','','0.450','1','100.00','496000','0','0','15000','496000','0','0','0','496000','AAT','00381778','PEF','0','0','-','0','1102000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PEF-YLAH-117-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='PEF-YLAH-117-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326161019212','2026-08-16','0.450','2026-08-16','10:19:21','PLG0030828','496000','496000','0','496000','496000','kasir','2026-08-16 10:19:21','F32616101921');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326161019212','2026-08-16','10:19:21','AAT','496000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260816-0007','D','2026-08-16','10:19:21','kasir','PENJUALAN','F326161019212','6910726000','496000','6911222000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='496000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161019212' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326161019213','kasir',' 1',' MGD1G HW ','TOKO','PM-P','D1G-ZFBE-160-0','LT WG SPECTRA SLEP HW 8K ','','0.470','1','100.00','527000','0','0','15000','527000','0','0','0','527000','AAT','00410438','D1G','0','0','-','0','1122000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZFBE-160-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='D1G-ZFBE-160-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326161019213','2026-08-16','0.470','2026-08-16','10:19:21','PLG0030829','527000','527000','0','527000','527000','kasir','2026-08-16 10:19:21','F32616101921');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326161019213','2026-08-16','10:19:21','AAT','527000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260816-0008','D','2026-08-16','10:19:21','kasir','PENJUALAN','F326161019213','6911222000','527000','6911749000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='527000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161019213' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326161023011','kasir','1',' MDE2 X 5K ','TOKO','PM-E','E2D-ZGAD-15-0','CC X BONEKA ANAK CAT SLEP LG 8K ','','0.950','1','100.00','1009000','0','0','15000','1010000','0','5000','0','1015000','FIT','00413462','E2D','0','0','-','0','1072000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGAD-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='E2D-ZGAD-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326161023011','2026-08-16','0.950','2026-08-16','10:23:02','PLG0030830','1010000','1010000','5000','1015000','1015000','kasir','2026-08-16 10:23:01','F32616102301');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326161023011','2026-08-16','10:23:02','FIT','1015000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260816-0009','D','2026-08-16','10:23:02','kasir','PENJUALAN','F326161023011','6911749000','1015000','6912764000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1015000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161023011' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326161023012','kasir',' 1',' MDE1 X CM ','TOKO','PM-E','E1D-ZEBH-280-0','CC X MODEL SLEP CM 18 8K ','','1.510','1','100.00','1604000','0','0','15000','1605000','0','0','0','1605000','FIT','00405498','E1D','0','0','-','0','1072000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEBH-280-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='E1D-ZEBH-280-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326161023012','2026-08-16','1.510','2026-08-16','10:23:02','PLG0030831','1605000','1605000','0','1605000','1605000','kasir','2026-08-16 10:23:01','F32616102301');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326161023012','2026-08-16','10:23:02','FIT','1605000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260816-0010','D','2026-08-16','10:23:02','kasir','PENJUALAN','F326161023012','6912764000','1605000','6914369000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1605000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161023012' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326161028541','kasir','1',' MEA1E UB ','TOKO','PM-A','A1E-ZHXF-341-0','AT HUGGIES C SLEP UB 8K ','','0.650','1','100.00','703000','0','0','15000','705000','0','0','0','705000','AAT','00417399','A1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZHXF-341-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='A1E-ZHXF-341-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326161028541','2026-08-16','0.650','2026-08-16','10:28:54','PLG0030832','705000','705000','0','705000','705000','kasir','2026-08-16 10:28:54','F32616102854');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326161028541','2026-08-16','10:28:54','AAT','705000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260816-0011','D','2026-08-16','10:28:54','kasir','PENJUALAN','F326161028541','6914369000','705000','6915074000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='705000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161028541' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326161028542','kasir',' 1',' MEB1 X LG ','TOKO','PM-B','B1E-YLXF-178-0','GW X MODEL HURUF MATA LG PE P 8K ','','0.530','1','100.00','573000','0','0','15000','575000','0','0','0','575000','AAT','00379994','B1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YLXF-178-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='B1E-YLXF-178-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326161028542','2026-08-16','0.530','2026-08-16','10:28:54','PLG0030833','575000','575000','0','575000','575000','kasir','2026-08-16 10:28:54','F32616102854');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326161028542','2026-08-16','10:28:54','AAT','575000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260816-0012','D','2026-08-16','10:28:54','kasir','PENJUALAN','F326161028542','6915074000','575000','6915649000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='575000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161028542' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326161046351','kasir','1',' TAE0 X DW ','TOKO','PT-E','E0TA-WLBF-117-T','CC X BANGKOK SLEP DW 10 ','','1.010','1','100.00','1919000','0','0','15000','1919000','0','0','0','1919000','AAT','T0052778','E0TA','0','0','-','0','1900000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0TA-WLBF-117-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='E0TA-WLBF-117-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326161046351','2026-08-16','1.010','2026-08-16','10:46:36','PLG0030834','1919000','1919000','0','1919000','1919000','kasir','2026-08-16 10:46:35','F32616104635');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326161046351','2026-08-16','10:46:36','AAT','1919000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260816-0013','D','2026-08-16','10:46:36','kasir','PENJUALAN','F326161046351','6915649000','1919000','6917568000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161046351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161046351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161046351';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019924','X-00019924','GW COR 8K','GR','---','B1E','BELI','BELI001','555000','2026-08-16','0.830','1','kasir','2026-08-16 10:54:05');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00019924','X-00019924');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260816-0001','00201316','AAT','1','BELI','BELI001','B1E', 'X-00019924', 'GW COR 8K','0.830','0.830','100.00','355000','555000','668675','1092000','1','555000','555000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.830',berat_beli_asli=berat_beli_asli+'0.830',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.830',berat_akhir_asli=berat_akhir_asli+'0.830',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260816-0001','2026-08-16','2026-08-16','10:54:04','AAT','---','0.830','555000','555000','555000','555000','555000','kasir','2026-08-16 10:54:05','FB-260816-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260816-0001','LINDA','JL TAMRIN','','','','kasir','2026-08-16 10:54:05');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-16' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260816-0015','K','2026-08-16','10:54:04','kasir','PEMBELIAN UMUM','FB-260816-0001','6915649000','555000','6915094000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019925','X-00019925','CC MODEL PITA PASIR CM 12 8K','GR','---','E1E','BELI','BELI001','652000','2026-08-16','0.650','1','kasir','2026-08-16 10:54:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019925','X-00019925');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260816-0002','F326290954041','FIT','1','BELI','BELI001','E1E', 'X-00019925', 'CC MODEL PITA PASIR CM 12 8K','0.650','0.650','100.00','735000','652000','1003077','1092000','1','652000','652000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.650',berat_beli_asli=berat_beli_asli+'0.650',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.650',berat_akhir_asli=berat_akhir_asli+'0.650',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260816-0002','2026-08-16','2026-08-16','10:54:33','FIT','---','0.650','652000','652000','652000','652000','652000','kasir','2026-08-16 10:54:33','FB-260816-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260816-0002','IKA','BAKALAN','','','085226148300','kasir','2026-08-16 10:54:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-16' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260816-0016','K','2026-08-16','10:54:33','kasir','PEMBELIAN UMUM','FB-260816-0002','6915094000','652000','6914442000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019926','X-00019926','GW TUSUK DAISY MATA LG 8K','GR','---','B1G','BELI','BELI001','305000','2026-08-16','0.300','1','kasir','2026-08-16 10:54:49');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1G','X-00019926','X-00019926');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260816-0003','F326180850081','FIT','1','BELI','BELI001','B1G', 'X-00019926', 'GW TUSUK DAISY MATA LG 8K','0.300','0.300','100.00','375000','305000','1016667','1122000','1','305000','305000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.300',berat_beli_asli=berat_beli_asli+'0.300',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.300',berat_akhir_asli=berat_akhir_asli+'0.300',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1G' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260816-0003','2026-08-16','2026-08-16','10:54:48','FIT','---','0.300','305000','305000','305000','305000','305000','kasir','2026-08-16 10:54:49','FB-260816-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260816-0003','IKA','BAKALAN','','','085226148300','kasir','2026-08-16 10:54:49');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-16' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260816-0017','K','2026-08-16','10:54:48','kasir','PEMBELIAN UMUM','FB-260816-0003','6914442000','305000','6914137000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019927','X-00019927','CC X MODEL MATA UB 14 8K','GR','---','E2D','BELI','BELI001','1640000','2026-08-16','1.730','1','kasir','2026-08-16 10:55:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019927','X-00019927');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260816-0004','F326220133541','FIT','1','BELI','BELI001','E2D', 'X-00019927', 'CC X MODEL MATA UB 14 8K','1.730','1.730','100.00','1765000','1640000','947977','1072000','1','1640000','1640000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.730',berat_beli_asli=berat_beli_asli+'1.730',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.730',berat_akhir_asli=berat_akhir_asli+'1.730',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260816-0004','2026-08-16','2026-08-16','10:55:46','FIT','---','1.730','1640000','1640000','1640000','1640000','1640000','kasir','2026-08-16 10:55:46','FB-260816-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260816-0004','VINA','TEGALREJO','','','','kasir','2026-08-16 10:55:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-16' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260816-0018','K','2026-08-16','10:55:46','kasir','PEMBELIAN UMUM','FB-260816-0004','6914137000','1640000','6912497000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019928','X-00019928','GL XX OVAL C GELOMBANG SLEP YT 54 8K','GR','---','F1E','BELI','BELI001','3212000','2026-08-16','3.350','1','kasir','2026-08-16 10:55:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00019928','X-00019928');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260816-0005','F326081221551','FIT','2','BELI','BELI001','F1E', 'X-00019928', 'GL XX OVAL C GELOMBANG SLEP YT 54 8K','3.350','3.350','100.00','3383000','3212000','958806','1092000','1','3212000','3212000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.350',berat_beli_asli=berat_beli_asli+'3.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.350',berat_akhir_asli=berat_akhir_asli+'3.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260816-0005','2026-08-16','2026-08-16','10:55:46','FIT','---','3.350','3212000','3212000','3212000','3212000','3212000','kasir','2026-08-16 10:55:46','FB-260816-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260816-0005','FINA','TEGALREJO','','','','kasir','2026-08-16 10:55:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-16' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260816-0019','K','2026-08-16','10:55:46','kasir','PEMBELIAN UMUM','FB-260816-0005','6912497000','3212000','6909285000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019929','X-00019929','AT BABY TINDIK SLEP DG 8K','GR','---','A1H','BELI','BELI001','237000','2026-08-16','0.250','1','kasir','2026-08-16 10:56:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1H';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1H','X-00019929','X-00019929');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260816-0006','F325121209381','AAT','1','BELI','BELI001','A1H', 'X-00019929', 'AT BABY TINDIK SLEP DG 8K','0.250','0.250','100.00','265000','237000','948000','1142000','1','237000','237000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.250',berat_beli_asli=berat_beli_asli+'0.250',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.250',berat_akhir_asli=berat_akhir_asli+'0.250',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1H' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260816-0006','2026-08-16','2026-08-16','10:56:02','AAT','---','0.250','237000','237000','237000','237000','237000','kasir','2026-08-16 10:56:02','FB-260816-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260816-0006','BETTI','BULUKERTO','','','','kasir','2026-08-16 10:56:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-16' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260816-0020','K','2026-08-16','10:56:02','kasir','PEMBELIAN UMUM','FB-260816-0006','6909285000','237000','6909048000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019930','X-00019930','GL OVAL MODEL C TD D56 8K','GR','---','F1E','BELI','BELI001','3815000','2026-08-16','4.880','1','kasir','2026-08-16 10:56:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00019930','X-00019930');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260816-0007','F325290208521','LIS','1','BELI','BELI001','F1E', 'X-00019930', 'GL OVAL MODEL C TD D56 8K','4.880','4.880','100.00','4173000','3815000','781762','1092000','1','3815000','3815000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.880',berat_beli_asli=berat_beli_asli+'4.880',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.880',berat_akhir_asli=berat_akhir_asli+'4.880',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260816-0007','2026-08-16','2026-08-16','10:56:22','LIS','---','4.880','3815000','3815000','3815000','3815000','3815000','kasir','2026-08-16 10:56:23','FB-260816-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260816-0007','TYAS','KENTHENG','','','','kasir','2026-08-16 10:56:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-16' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260816-0021','K','2026-08-16','10:56:22','kasir','PEMBELIAN UMUM','FB-260816-0007','6909048000','3815000','6905233000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019931','X-00019931','KL SIEM COBRA KH 44 8K','GR','---','H1E','BELI','BELI001','1960000','2026-08-16','2.020','1','kasir','2026-08-16 10:57:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00019931','X-00019931');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260816-0008','F326261242301','AAT','1','BELI','BELI001','H1E', 'X-00019931', 'KL SIEM COBRA KH 44 8K','2.020','2.020','100.00','2132000','1960000','970297','1092000','1','1960000','1960000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.020',berat_beli_asli=berat_beli_asli+'2.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.020',berat_akhir_asli=berat_akhir_asli+'2.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260816-0008','2026-08-16','2026-08-16','10:57:17','AAT','---','2.020','1960000','1960000','1960000','1960000','1960000','kasir','2026-08-16 10:57:18','FB-260816-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260816-0008','MUNA','SUMBER GALIH','','','','kasir','2026-08-16 10:57:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-16' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260816-0022','K','2026-08-16','10:57:17','kasir','PEMBELIAN UMUM','FB-260816-0008','6905233000','1960000','6903273000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326161058241','kasir','1',' MDE2 X LG ','TOKO','PM-E','E2D-ZGBI-65-0','CC X MODEL CAT MATA LG 12 8K ','','1.070','1','100.00','1136000','0','0','15000','1136000','0','10000','0','1146000','FIT','00415825','E2D','0','0','-','0','1072000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGBI-65-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='E2D-ZGBI-65-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326161058241','2026-08-16','1.070','2026-08-16','10:58:25','PLG0030835','1136000','1136000','10000','1146000','1146000','kasir','2026-08-16 10:58:24','F32616105824');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326161058241','2026-08-16','10:58:25','FIT','1146000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260816-0023','D','2026-08-16','10:58:25','kasir','PENJUALAN','F326161058241','6903273000','1146000','6904419000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326161100031','kasir','1',' MEF2 10K L','TOKO','PM-F','F2E-ZGBC-274-0','GL PIPA ANAK MATA CAT LG 36 8K ','','2.020','1','100.00','2186000','0','0','15000','2186000','0','10000','0','2196000','LIS','00415347','F2E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZGBC-274-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='F2E-ZGBC-274-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326161100031','2026-08-16','2.020','2026-08-16','11:00:03','PLG0030836','2186000','2186000','10000','2196000','2196000','kasir','2026-08-16 11:00:03','F32616110003');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326161100031','2026-08-16','11:00:03','LIS','2196000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260816-0024','D','2026-08-16','11:00:03','kasir','PENJUALAN','F326161100031','6904419000','2196000','6906615000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2196000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161100031' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326161100032','kasir',' 1',' MEF2 10K L','TOKO','PM-F','F2E-ZFXA-118-0','GL BONEKA ANAK CAT MATA LG 36 8K ','','2.000','1','100.00','2164000','0','0','15000','2164000','0','10000','0','2174000','LIS','00406286','F2E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZFXA-118-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='F2E-ZFXA-118-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326161100032','2026-08-16','2.000','2026-08-16','11:00:03','PLG0030837','2164000','2164000','10000','2174000','2174000','kasir','2026-08-16 11:00:03','F32616110003');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326161100032','2026-08-16','11:00:03','LIS','2174000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260816-0025','D','2026-08-16','11:00:03','kasir','PENJUALAN','F326161100032','6906615000','2174000','6908789000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2174000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161100032' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019932','X-00019932','GL X FANCY SLEP LT 8K','GR','---','F3E','BELI','BELI001','1975000','2026-08-16','2.050','1','kasir','2026-08-16 11:05:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019932','X-00019932');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260816-0009','F326310900451','AAT','1','BELI','BELI001','F3E', 'X-00019932', 'GL X FANCY SLEP LT 8K','2.050','2.050','100.00','2123000','1975000','963415','1092000','1','1975000','1975000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.050',berat_beli_asli=berat_beli_asli+'2.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.050',berat_akhir_asli=berat_akhir_asli+'2.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260816-0009','2026-08-16','2026-08-16','11:05:22','AAT','---','2.050','1975000','1975000','1975000','1975000','1975000','kasir','2026-08-16 11:05:23','FB-260816-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260816-0009','GIBRAN','JOHO PURWANTORO','','','','kasir','2026-08-16 11:05:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-16' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260816-0026','K','2026-08-16','11:05:22','kasir','PEMBELIAN UMUM','FB-260816-0009','6908789000','1975000','6906814000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019933','X-00019933','GL X BANGKOK C ANAK SLEP TD 34 8K','GR','---','F1E','BELI','BELI001','1550000','2026-08-16','2.000','1','kasir','2026-08-16 11:25:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00019933','X-00019933');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260816-0010','F325071220556','LIS','1','BELI','BELI001','F1E', 'X-00019933', 'GL X BANGKOK C ANAK SLEP TD 34 8K','2.020','2.000','100.00','1670000','1550000','775000','1092000','1','1550000','1550000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.000',berat_beli_asli=berat_beli_asli+'2.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.000',berat_akhir_asli=berat_akhir_asli+'2.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260816-0010','2026-08-16','2026-08-16','11:25:16','LIS','---','2.000','1550000','1550000','1550000','1550000','1550000','kasir','2026-08-16 11:25:17','FB-260816-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260816-0010','ASRI','MIRI KISMANTORO','','','','kasir','2026-08-16 11:25:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-16' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260816-0027','K','2026-08-16','11:25:16','kasir','PEMBELIAN UMUM','FB-260816-0010','6906814000','1550000','6905264000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019934','X-00019934','GL ANAK BANGKOK MODEL C TD D35 8K','GR','---','F1E','BELI','BELI001','1495000','2026-08-16','1.930','1','kasir','2026-08-16 11:25:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00019934','X-00019934');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260816-0011','F325071220555','LIS','2','BELI','BELI001','F1E', 'X-00019934', 'GL ANAK BANGKOK MODEL C TD D35 8K','1.960','1.930','100.00','1620000','1495000','774611','1092000','1','1495000','1495000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.930',berat_beli_asli=berat_beli_asli+'1.930',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.930',berat_akhir_asli=berat_akhir_asli+'1.930',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260816-0011','2026-08-16','2026-08-16','11:25:16','LIS','---','1.930','1495000','1495000','1495000','1495000','1495000','kasir','2026-08-16 11:25:17','FB-260816-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260816-0011','ASRI','MIRI KISMANTORO','','','','kasir','2026-08-16 11:25:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-16' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260816-0028','K','2026-08-16','11:25:16','kasir','PEMBELIAN UMUM','FB-260816-0011','6905264000','1495000','6903769000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019935','X-00019935','GW TUSUK MODEL MATA VAR LG PE 8K','GR','---','B1E','BELI','BELI001','245000','2026-08-16','0.290','1','kasir','2026-08-16 11:25:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00019935','X-00019935');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260816-0012','F326030913081','LIS','3','BELI','BELI001','B1E', 'X-00019935', 'GW TUSUK MODEL MATA VAR LG PE 8K','0.550','0.290','100.00','585000','245000','844828','1092000','1','245000','245000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.290',berat_beli_asli=berat_beli_asli+'0.290',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.290',berat_akhir_asli=berat_akhir_asli+'0.290',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260816-0012','2026-08-16','2026-08-16','11:25:16','LIS','---','0.290','245000','245000','245000','245000','245000','kasir','2026-08-16 11:25:17','FB-260816-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260816-0012','ASRI','MIRI KISMANTORO','','','','kasir','2026-08-16 11:25:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-16' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260816-0029','K','2026-08-16','11:25:16','kasir','PEMBELIAN UMUM','FB-260816-0012','6903769000','245000','6903524000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326161130351','kasir','1',' MFB1F LG ','TOKO','PM-B','B1F-ZHXD-71-T','GW TOUGE HATI SLEP LG 8K ','','0.400','1','100.00','441000','0','0','15000','441000','0','0','0','441000','LIS','T0081909','B1F','0','0','-','0','1102000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-ZHXD-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='B1F-ZHXD-71-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326161130351','2026-08-16','0.400','2026-08-16','11:30:36','PLG0030838','441000','441000','0','441000','441000','kasir','2026-08-16 11:30:35','F32616113035');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326161130351','2026-08-16','11:30:36','LIS','441000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260816-0030','D','2026-08-16','11:30:36','kasir','PENJUALAN','F326161130351','6903524000','441000','6903965000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='441000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161130351' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326161130352','kasir',' 1',' MEE2 5K LG','TOKO','PM-E','E2E-ZGBC-270-0','CC BONEKA ANAK CAT MATA LG 8K ','','0.500','1','100.00','541000','0','0','15000','541000','0','5000','0','546000','LIS','00415343','E2E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGBC-270-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='E2E-ZGBC-270-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326161130352','2026-08-16','0.500','2026-08-16','11:30:36','PLG0030839','541000','541000','5000','546000','546000','kasir','2026-08-16 11:30:35','F32616113035');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326161130352','2026-08-16','11:30:36','LIS','546000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260816-0031','D','2026-08-16','11:30:36','kasir','PENJUALAN','F326161130352','6903965000','546000','6904511000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='546000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161130352' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019936','X-00019936','CC X BANGKOK POLOS DW 15','GR','---','E0TA','BELI','BELI001','1440000','2026-08-16','1.000','1','kasir','2026-08-16 12:04:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-E0TA';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E0TA','X-00019936','X-00019936');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260816-0013','F322261235241','FIT','1','BELI','BELI001','E0TA', 'X-00019936', 'CC X BANGKOK POLOS DW 15','1.000','1.000','100.00','720000','1440000','1440000','1900000','1','1440000','1440000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E0TA' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260816-0013','2026-08-16','2026-08-16','12:04:03','FIT','---','1.000','1440000','1440000','1440000','1440000','1440000','kasir','2026-08-16 12:04:03','FB-260816-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260816-0013','BOINEM','KENTENG','','','','kasir','2026-08-16 12:04:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-16' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260816-0032','K','2026-08-16','12:04:03','kasir','PEMBELIAN UMUM','FB-260816-0013','6904511000','1440000','6903071000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326161248331','kasir','1',' MEA1E X LG','TOKO','PM-A','A1E-ZGXG-57-0','AT X GYPSY MATA VAR ANAK LG 8K ','','0.550','1','100.00','595000','0','0','15000','595000','0','0','0','595000','AAT','00412458','A1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZGXG-57-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='A1E-ZGXG-57-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326161248331','2026-08-16','0.550','2026-08-16','12:48:33','PLG0030840','595000','595000','0','595000','595000','kasir','2026-08-16 12:48:33','F32616124833');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326161248331','2026-08-16','12:48:33','AAT','595000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260816-0033','D','2026-08-16','12:48:33','kasir','PENJUALAN','F326161248331','6903071000','595000','6903666000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326161250291','kasir','1',' MEF1 XX YT','TOKO','PM-F','F1E-ZFCX-41-0','GL XX OVAL C SLEP YT 56 8K ','','3.000','1','100.00','3246000','0','0','15000','3157000','0','0','0','3157000','FIT','00411248','F1E','0','0','-','1','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFCX-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='F1E-ZFCX-41-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326161250291','2026-08-16','3.000','2026-08-16','12:50:30','PLG0030841','3157000','3157000','0','3157000','3157000','kasir','2026-08-16 12:50:29','F32616125029');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326161250291','2026-08-16','12:50:30','FIT','3157000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260816-0034','D','2026-08-16','12:50:30','kasir','PENJUALAN','F326161250291','6903666000','3157000','6906823000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326160101221','kasir','1',' MEE1E CM 1','TOKO','PM-E','E1E-ZFBE-142-0','CC MODEL SLEP CM 14 8K ','','0.660','1','100.00','714000','0','0','15000','715000','0','0','0','715000','AAT','00410419','E1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBE-142-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='E1E-ZFBE-142-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326160101221','2026-08-16','0.660','2026-08-16','13:01:22','PLG0030842','715000','715000','0','715000','715000','kasir','2026-08-16 13:01:22','F32616010122');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326160101221','2026-08-16','13:01:22','AAT','715000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260816-0035','D','2026-08-16','13:01:22','kasir','PENJUALAN','F326160101221','6906823000','715000','6907538000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326160113261','kasir','1',' TEE2 HTM 1','TOKO','PT-E','E2TE-YEBA-78-T','CC PIPA MODEL MATA VAR HTM 12 17K ','','0.600','1','100.00','1194000','0','0','15000','1195000','0','0','0','1195000','AAT','T0069499','E2TE','0','0','-','0','1990000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-YEBA-78-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='E2TE-YEBA-78-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326160113261','2026-08-16','0.600','2026-08-16','13:13:26','PLG0030843','1195000','1195000','0','1195000','1195000','kasir','2026-08-16 13:13:26','F32616011326');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326160113261','2026-08-16','13:13:26','AAT','1195000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260816-0036','D','2026-08-16','13:13:26','kasir','PENJUALAN','F326160113261','6907538000','1195000','6908733000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019937','X-00019937','AT COR 8K','GR','---','A1E','BELI','BELI001','595000','2026-08-16','0.900','1','kasir','2026-08-16 13:20:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00019937','X-00019937');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260816-0014','F323080904091','AAT','1','BELI','BELI001','A1E', 'X-00019937', 'AT COR 8K','0.900','0.900','100.00','405000','595000','661111','1092000','1','595000','595000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260816-0014','2026-08-16','2026-08-16','13:20:58','AAT','---','0.900','595000','595000','595000','595000','595000','kasir','2026-08-16 13:20:59','FB-260816-0014');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260816-0014','YANA','KARANGLO','','','','kasir','2026-08-16 13:20:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-16' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260816-0037','K','2026-08-16','13:20:58','kasir','PEMBELIAN UMUM','FB-260816-0014','6908733000','595000','6908138000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019938','X-00019938','GL OVAL MODEL C SLEP UB D54 8K','GR','---','F1E','BELI','BELI001','2070000','2026-08-16','2.230','1','kasir','2026-08-16 13:22:52');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00019938','X-00019938');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260816-0015','F326231039101','AAT','1','BELI','BELI001','F1E', 'X-00019938', 'GL OVAL MODEL C SLEP UB D54 8K','2.230','2.230','100.00','2553000','2070000','928251','1092000','1','2070000','2070000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.230',berat_beli_asli=berat_beli_asli+'2.230',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.230',berat_akhir_asli=berat_akhir_asli+'2.230',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260816-0015','2026-08-16','2026-08-16','13:22:51','AAT','---','2.230','2070000','2070000','2070000','2070000','2070000','kasir','2026-08-16 13:22:52','FB-260816-0015');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260816-0015','YANA','KARANGLO','','','082328228050','kasir','2026-08-16 13:22:52');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-16' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260816-0038','K','2026-08-16','13:22:51','kasir','PEMBELIAN UMUM','FB-260816-0015','6908138000','2070000','6906068000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326160125521','kasir','1',' MDE2 X UB ','TOKO','PM-E','E2D-ZBXF-100-0','CC X MODEL MATA UB 18 8K ','','1.350','1','100.00','1434000','0','0','15000','1435000','0','10000','0','1445000','FIT','00388682','E2D','0','0','-','0','1072000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZBXF-100-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='E2D-ZBXF-100-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326160125521','2026-08-16','1.350','2026-08-16','13:25:52','PLG0030844','1435000','1435000','10000','1445000','1445000','kasir','2026-08-16 13:25:52','F32616012552');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326160125521','2026-08-16','13:25:52','FIT','1445000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260816-0039','D','2026-08-16','13:25:52','kasir','PENJUALAN','F326160125521','6906068000','1445000','6907513000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326160128021','kasir','1',' MEH1 X KH ','TOKO','PM-H','H1E-ZDAX-49-0','KL X NORI ANAK KH 38 8K ','','2.060','1','100.00','2229000','0','0','15000','2230000','0','0','0','2230000','LIS','00398819','H1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDAX-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='H1E-ZDAX-49-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326160128021','2026-08-16','2.060','2026-08-16','13:28:02','PLG0030845','2230000','2230000','0','2230000','2230000','kasir','2026-08-16 13:28:02','F32616012802');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326160128021','2026-08-16','13:28:02','LIS','2230000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260816-0040','D','2026-08-16','13:28:02','kasir','PENJUALAN','F326160128021','6907513000','2230000','6909743000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019939','X-00019939','GL PUTIH 8K','GR','---','PFF','BELI','BELI001','1472000','2026-08-16','1.800','1','kasir','2026-08-16 13:31:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-PFF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-PFF','X-00019939','X-00019939');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260816-0016','00381700','FIT','1','BELI','BELI001','PFF', 'X-00019939', 'GL PUTIH 8K','1.930','1.800','100.00','2220000','1472000','817778','1102000','1','1472000','1472000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.800',berat_beli_asli=berat_beli_asli+'1.800',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.800',berat_akhir_asli=berat_akhir_asli+'1.800',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='PFF' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260816-0016','2026-08-16','2026-08-16','13:31:18','FIT','---','1.800','1472000','1472000','1472000','1472000','1472000','kasir','2026-08-16 13:31:18','FB-260816-0016');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260816-0016','NATASYA','KISMANTORO','','','','kasir','2026-08-16 13:31:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-16' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260816-0041','K','2026-08-16','13:31:18','kasir','PEMBELIAN UMUM','FB-260816-0016','6909743000','1472000','6908271000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326160137241','kasir','1',' MFE2 KH 10','TOKO','PM-E','E2F-ZHAX-332-0','CC MODEL PAKU MATA KH 10 8K ','','0.380','1','100.00','419000','0','0','15000','420000','0','0','0','420000','LIS','00418477','E2F','0','0','-','0','1102000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZHAX-332-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='E2F-ZHAX-332-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326160137241','2026-08-16','0.380','2026-08-16','13:37:25','PLG0030846','420000','420000','0','420000','420000','kasir','2026-08-16 13:37:24','F32616013724');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326160137241','2026-08-16','13:37:25','LIS','420000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260816-0042','D','2026-08-16','13:37:25','kasir','PENJUALAN','F326160137241','6908271000','420000','6908691000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326160153291','kasir','1',' MDE2 CM 22','TOKO','PM-E','E2D-ZHAX-333-0','CC WEDDING MATA CM 22 8K ','','1.180','1','100.00','1253000','0','0','15000','1255000','0','0','0','1255000','FIT','00418478','E2D','0','0','-','0','1072000');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZHAX-333-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.180',berat_jual_asli=berat_jual_asli+'1.180',stock_jual='1',berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='E2D-ZHAX-333-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326160153291','2026-08-16','1.180','2026-08-16','13:53:29','PLG0030847','1255000','1255000','0','1255000','1255000','kasir','2026-08-16 13:53:29','F32616015329');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','F326160153291','2026-08-16','13:53:29','FIT','1255000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260816-0043','D','2026-08-16','13:53:29','kasir','PENJUALAN','F326160153291','6908691000','1255000','6909946000');