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 ('F326270903401','input','1',' MEE2E KH 1','TOKO','PM-E','E2E-ZHBI-127-0','CC MODEL SNAKE MATA SLEP KH 14 8K ','','0.490','1','100.00','512000','0','0','15000','513000','0','0','0','513000','LIS','00421251','E2E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHBI-127-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.490',berat_jual_asli=berat_jual_asli+'0.490',stock_jual='1',berat_akhir=berat_akhir-'0.490',berat_akhir_asli=berat_akhir_asli-'0.490',stock_akhir='0' WHERE tanggal='2026-09-27' AND kode_barang='E2E-ZHBI-127-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 ('F326270903401','2026-09-27','0.490','2026-09-27','09:03:41','PLG0031541','513000','513000','0','513000','513000','input','2026-09-27 09:03:40','F32627090340');
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-09-27','F326270903401','2026-09-27','09:03:41','LIS','513000','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-260927-0002','D','2026-09-27','09:03:41','input','PENJUALAN','F326270903401','7635532000','513000','7636045000');
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 ('F326270906391','input','1',' MEA1 LG ','TOKO','PM-A','A1E-ZEAE-219-0','AT MODEL DAUN MATA VAR LG 8K ','','0.480','1','100.00','502000','0','0','15000','503000','0','0','0','503000','FIT','00403697','A1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZEAE-219-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-09-27' AND kode_barang='A1E-ZEAE-219-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 ('F326270906391','2026-09-27','0.480','2026-09-27','09:06:39','PLG0031542','503000','503000','0','503000','503000','input','2026-09-27 09:06:39','F32627090639');
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-09-27','F326270906391','2026-09-27','09:06:39','FIT','503000','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-260927-0003','D','2026-09-27','09:06:39','input','PENJUALAN','F326270906391','7636045000','503000','7636548000');
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 ('F326270914121','input','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZHBF-141-0','CC X MODEL MATA SLEP VAR CM 16 8K ','','0.830','1','100.00','851000','0','0','15000','850000','0','0','0','850000','LIS','00420513','E2D','0','0','-','1','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZHBF-141-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2026-09-27' AND kode_barang='E2D-ZHBF-141-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 ('F326270914121','2026-09-27','0.830','2026-09-27','09:14:12','PLG0031543','850000','850000','0','850000','850000','input','2026-09-27 09:14:12','F32627091412');
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-09-27','F326270914121','2026-09-27','09:14:12','LIS','850000','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-260927-0004','D','2026-09-27','09:14:12','input','PENJUALAN','F326270914121','7636548000','850000','7637398000');
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 ('F326270936121','input','1',' TEE2 KH 18','TOKO','PT-E','E2TE-ZIAG-101-T','CC MODEL PAKU MATA VAR KH 18 17K ','','0.580','1','100.00','1114000','0','0','15000','1114000','0','0','0','1114000','SIN','T0084004','E2TE','0','0','-','0','1920000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-ZIAG-101-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-09-27' AND kode_barang='E2TE-ZIAG-101-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 ('F326270936121','2026-09-27','0.580','2026-09-27','09:36:13','PLG0031544','1114000','1114000','0','1114000','1114000','input','2026-09-27 09:36:12','F32627093612');
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-09-27','F326270936121','2026-09-27','09:36:13','SIN','1114000','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-260927-0005','D','2026-09-27','09:36:13','input','PENJUALAN','F326270936121','7637398000','1114000','7638512000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1114000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326270936121' 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 ('F326270936122','input',' 1',' TEF3 UB ','TOKO','PT-F','F3TE-ZGAG-61-T','GL RANTAI HOLLOW SLEP UB 17K ','','0.530','1','100.00','1018000','0','0','15000','1018000','0','0','0','1018000','SIN','T0081284','F3TE','0','0','-','0','1920000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-ZGAG-61-T' 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-09-27' AND kode_barang='F3TE-ZGAG-61-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326270936122','2026-09-27','0.530','2026-09-27','09:36:13','PLG0031545','1018000','1018000','0','1018000','1018000','input','2026-09-27 09:36:12','F32627093612');
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-09-27','F326270936122','2026-09-27','09:36:13','SIN','1018000','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-260927-0006','D','2026-09-27','09:36:13','input','PENJUALAN','F326270936122','7638512000','1018000','7639530000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1018000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326270936122' 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 ('F326270940281','input','1',' MEH1 XX HW','TOKO','PM-H','H1E-ZAXH-289-0','KL X SANTA AUREL MATA HW 42 8K ','','2.460','1','100.00','2571000','0','0','15000','2495000','0','0','0','2495000','AAT','00384375','H1E','0','0','-','1','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZAXH-289-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.460',berat_jual_asli=berat_jual_asli+'2.460',stock_jual='1',berat_akhir=berat_akhir-'2.460',berat_akhir_asli=berat_akhir_asli-'2.460',stock_akhir='0' WHERE tanggal='2026-09-27' AND kode_barang='H1E-ZAXH-289-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 ('F326270940281','2026-09-27','2.460','2026-09-27','09:40:29','PLG0031546','2495000','2495000','0','2495000','2495000','input','2026-09-27 09:40:28','F32627094028');
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-09-27','F326270940281','2026-09-27','09:40:29','AAT','2495000','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-260927-0007','D','2026-09-27','09:40:29','input','PENJUALAN','F326270940281','7639530000','2495000','7642025000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2495000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326270940281' 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 ('F326270940282','input',' 1',' MEF1 X KH ','TOKO','PM-F','F1E-ZIAD-69-0','GL X OVAL C SLEP KH 58 8K ','','3.270','1','100.00','3417000','0','0','15000','3418000','0','0','0','3418000','AAT','00423429','F1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZIAD-69-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.270',berat_jual_asli=berat_jual_asli+'3.270',stock_jual='1',berat_akhir=berat_akhir-'3.270',berat_akhir_asli=berat_akhir_asli-'3.270',stock_akhir='0' WHERE tanggal='2026-09-27' AND kode_barang='F1E-ZIAD-69-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 ('F326270940282','2026-09-27','3.270','2026-09-27','09:40:29','PLG0031547','3418000','3418000','0','3418000','3418000','input','2026-09-27 09:40:28','F32627094028');
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-09-27','F326270940282','2026-09-27','09:40:29','AAT','3418000','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-260927-0008','D','2026-09-27','09:40:29','input','PENJUALAN','F326270940282','7642025000','3418000','7645443000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3418000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326270940282' 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 ('F326270940283','input',' 1',' MDE2 10K C','TOKO','PM-E','E2D-ZCCX-506-0','CC WEDDING MATA CM 10 8K ','','1.080','1','100.00','1107000','0','0','15000','1107000','0','10000','0','1117000','AAT','00397160','E2D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCCX-506-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-09-27' AND kode_barang='E2D-ZCCX-506-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 ('F326270940283','2026-09-27','1.080','2026-09-27','09:40:29','PLG0031548','1107000','1107000','10000','1117000','1117000','input','2026-09-27 09:40:28','F32627094028');
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-09-27','F326270940283','2026-09-27','09:40:29','AAT','1117000','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-260927-0009','D','2026-09-27','09:40:29','input','PENJUALAN','F326270940283','7645443000','1117000','7646560000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1117000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326270940283' 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 ('F326271000461','input','1',' MFE1 KH 18','TOKO','PM-E','E1F-ZIAE-272-0','CC MODEL MRICAN POLOS VAR KH 18 8K ','','0.330','1','100.00','351000','0','0','15000','352000','0','0','0','352000','LIS','00423807','E1F','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIAE-272-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2026-09-27' AND kode_barang='E1F-ZIAE-272-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 ('F326271000461','2026-09-27','0.330','2026-09-27','10:00:47','PLG0031549','352000','352000','0','352000','352000','input','2026-09-27 10:00:46','F32627100046');
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-09-27','F326271000461','2026-09-27','10:00:47','LIS','352000','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-260927-0010','D','2026-09-27','10:00:47','input','PENJUALAN','F326271000461','7646560000','352000','7646912000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='352000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326271000461' 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 ('F326271000462','input',' 1',' MFE2F KH 1','TOKO','PM-E','E2F-ZIBA-293-0','CC MODEL PAKU MATA SLEP KH 18 8K ','','0.400','1','100.00','426000','0','0','15000','426000','0','0','0','426000','LIS','00424837','E2F','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZIBA-293-0' 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-09-27' AND kode_barang='E2F-ZIBA-293-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 ('F326271000462','2026-09-27','0.400','2026-09-27','10:00:47','PLG0031550','426000','426000','0','426000','426000','input','2026-09-27 10:00:46','F32627100046');
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-09-27','F326271000462','2026-09-27','10:00:47','LIS','426000','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-260927-0011','D','2026-09-27','10:00:47','input','PENJUALAN','F326271000462','7646912000','426000','7647338000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='426000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326271000462' 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 ('F326271009401','input','1',' MEF3E LT ','TOKO','PM-F','F3E-ZHAX-351-0','GL CAPELLA ANAK SLEP LT 8K ','','1.530','1','100.00','1599000','0','0','15000','1600000','0','0','0','1600000','SIN','00418496','F3E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHAX-351-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-09-27' AND kode_barang='F3E-ZHAX-351-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 ('F326271009401','2026-09-27','1.530','2026-09-27','10:09:41','PLG0031551','1600000','1600000','0','1600000','1600000','input','2026-09-27 10:09:40','F32627100940');
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-09-27','F326271009401','2026-09-27','10:09:41','SIN','1600000','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-260927-0012','D','2026-09-27','10:09:41','input','PENJUALAN','F326271009401','7647338000','1600000','7648938000');
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 ('F326271017541','input','1',' MEB1 HW ','TOKO','PM-B','B1E-ZIBB-92-0','GW ITALY PANJANG HATI MATA VAR HW 8K ','','0.630','1','100.00','658000','0','0','15000','660000','0','0','0','660000','FIT','00425100','B1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZIBB-92-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2026-09-27' AND kode_barang='B1E-ZIBB-92-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 ('F326271017541','2026-09-27','0.630','2026-09-27','10:17:54','PLG0031552','660000','660000','0','660000','660000','input','2026-09-27 10:17:54','F32627101754');
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-09-27','F326271017541','2026-09-27','10:17:54','FIT','660000','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-260927-0013','D','2026-09-27','10:17:54','input','PENJUALAN','F326271017541','7648938000','660000','7649598000');
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 ('F326271025521','input','1',' MEE2E KH 1','TOKO','PM-E','E2E-ZHBA-201-0','CC MODEL PAKU MATA SLEP KH 17 8K ','','0.500','1','100.00','522000','0','0','15000','522000','0','0','0','522000','SIN','00419780','E2E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHBA-201-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-09-27' AND kode_barang='E2E-ZHBA-201-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 ('F326271025521','2026-09-27','0.500','2026-09-27','10:25:53','PLG0031553','522000','522000','0','522000','522000','input','2026-09-27 10:25:52','F32627102552');
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-09-27','F326271025521','2026-09-27','10:25:53','SIN','522000','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-260927-0014','D','2026-09-27','10:25:53','input','PENJUALAN','F326271025521','7649598000','522000','7650120000');
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 ('F326271031401','input','1',' MDA1D X HW','TOKO','PM-A','A1D-ZCAI-103-0','AT X ITALY SLEP VAR HW 8K ','','1.210','1','100.00','1240000','0','0','15000','1240000','0','0','0','1240000','AAT','00395499','A1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZCAI-103-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.210',berat_jual_asli=berat_jual_asli+'1.210',stock_jual='1',berat_akhir=berat_akhir-'1.210',berat_akhir_asli=berat_akhir_asli-'1.210',stock_akhir='0' WHERE tanggal='2026-09-27' AND kode_barang='A1D-ZCAI-103-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 ('F326271031401','2026-09-27','1.210','2026-09-27','10:31:40','PLG0031554','1240000','1240000','0','1240000','1240000','input','2026-09-27 10:31:40','F32627103140');
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-09-27','F326271031401','2026-09-27','10:31:40','AAT','1240000','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-260927-0015','D','2026-09-27','10:31:40','input','PENJUALAN','F326271031401','7650120000','1240000','7651360000');
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 ('F326271034551','input','1',' MEF3 KH ','TOKO','PM-F','F3E-ZDAC-92-0','GL MODEL FANCY VAR KH 8K ','','1.580','1','100.00','1651000','0','0','15000','1650000','0','0','0','1650000','LIS','00399262','F3E','0','0','-','1','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDAC-92-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.580',berat_jual_asli=berat_jual_asli+'1.580',stock_jual='1',berat_akhir=berat_akhir-'1.580',berat_akhir_asli=berat_akhir_asli-'1.580',stock_akhir='0' WHERE tanggal='2026-09-27' AND kode_barang='F3E-ZDAC-92-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 ('F326271034551','2026-09-27','1.580','2026-09-27','10:34:56','PLG0031555','1650000','1650000','0','1650000','1650000','input','2026-09-27 10:34:55','F32627103455');
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-09-27','F326271034551','2026-09-27','10:34:56','LIS','1650000','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-260927-0016','D','2026-09-27','10:34:56','input','PENJUALAN','F326271034551','7651360000','1650000','7653010000');
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-00020337','X-00020337','GL CASTELI ARESO VAR HW 8K','GR','---','F3E','BELI','BELI001','2077000','2026-09-27','2.140','1','kasir','2026-09-27 10:39:26');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020337','X-00020337');
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-260927-0001','F326251037501','AAT','1','BELI','BELI001','F3E', 'X-00020337', 'GL CASTELI ARESO VAR HW 8K','2.140','2.140','100.00','2375000','2077000','970561','1055000','1','2077000','2077000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.140',berat_beli_asli=berat_beli_asli+'2.140',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.140',berat_akhir_asli=berat_akhir_asli+'2.140',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-27' 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-260927-0001','2026-09-27','2026-09-27','10:39:26','AAT','---','2.140','2077000','2077000','2077000','2077000','2077000','kasir','2026-09-27 10:39:26','FB-260927-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260927-0001','LRONI','KRANDEGAN BULUKERTO','','','085288460259','kasir','2026-09-27 10:39:26');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-27' 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-260927-0017','K','2026-09-27','10:39:26','kasir','PEMBELIAN UMUM','FB-260927-0001','7653010000','2077000','7650933000');
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-00020338','X-00020338','GL MODEL DAUN SLEP VAR PM 8K','GR','---','F3E','BELI','BELI001','2815000','2026-09-27','3.140','1','kasir','2026-09-27 10:45:45');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020338','X-00020338');
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-260927-0002','F325061000201','FIT','1','BELI','BELI001','F3E', 'X-00020338', 'GL MODEL DAUN SLEP VAR PM 8K','3.140','3.140','100.00','3061000','2815000','896497','1055000','1','2815000','2815000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.140',berat_beli_asli=berat_beli_asli+'3.140',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.140',berat_akhir_asli=berat_akhir_asli+'3.140',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-27' 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-260927-0002','2026-09-27','2026-09-27','10:45:44','FIT','---','3.140','2815000','2815000','2815000','2815000','2815000','kasir','2026-09-27 10:45:45','FB-260927-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260927-0002','NUR HALIMAH','MBONGGI KISMANTORO','','','','kasir','2026-09-27 10:45:45');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-27' 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-260927-0018','K','2026-09-27','10:45:44','kasir','PEMBELIAN UMUM','FB-260927-0002','7650933000','2815000','7648118000');
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-00020339','X-00020339','LT X MODEL MATA LG 8K','GR','---','D2E','BELI','BELI001','515000','2026-09-27','0.530','1','kasir','2026-09-27 10:47:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00020339','X-00020339');
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-260927-0003','F326060924112','LIS','1','BELI','BELI001','D2E', 'X-00020339', 'LT X MODEL MATA LG 8K','0.530','0.530','100.00','554000','515000','971698','1055000','1','515000','515000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' 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-260927-0003','2026-09-27','2026-09-27','10:47:08','LIS','---','0.530','515000','515000','515000','515000','515000','kasir','2026-09-27 10:47:09','FB-260927-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260927-0003','ARLITA','TENGGER PUGPELEM','','','087812296654','kasir','2026-09-27 10:47:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-27' 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-260927-0019','K','2026-09-27','10:47:08','kasir','PEMBELIAN UMUM','FB-260927-0003','7648118000','515000','7647603000');
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-00020340','X-00020340','GL OVAL C GELOMBANG YT D56','GR','---','F1E','BELI','BELI001','2505000','2026-09-27','3.290','1','kasir','2026-09-27 10:49:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020340','X-00020340');
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-260927-0004','F322300226532','FIT','1','BELI','BELI001','F1E', 'X-00020340', 'GL OVAL C GELOMBANG YT D56','3.290','3.290','100.00','1431000','2505000','761398','1055000','1','2505000','2505000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.290',berat_beli_asli=berat_beli_asli+'3.290',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.290',berat_akhir_asli=berat_akhir_asli+'3.290',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-27' 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-260927-0004','2026-09-27','2026-09-27','10:49:21','FIT','---','3.290','2505000','2505000','2505000','2505000','2505000','kasir','2026-09-27 10:49:21','FB-260927-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260927-0004','NUR','TALESAN','','','','kasir','2026-09-27 10:49:21');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-27' 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-260927-0020','K','2026-09-27','10:49:21','kasir','PEMBELIAN UMUM','FB-260927-0004','7647603000','2505000','7645098000');
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-00020341','X-00020341','GL OVAL C YT 56','GR','---','F1E','BELI','BELI001','2495000','2026-09-27','3.280','1','kasir','2026-09-27 10:51:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020341','X-00020341');
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-260927-0005','F322300226533','FIT','1','BELI','BELI001','F1E', 'X-00020341', 'GL OVAL C YT 56','3.280','3.280','100.00','1430000','2495000','760671','1055000','1','2495000','2495000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.280',berat_beli_asli=berat_beli_asli+'3.280',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.280',berat_akhir_asli=berat_akhir_asli+'3.280',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-27' 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-260927-0005','2026-09-27','2026-09-27','10:51:44','FIT','---','3.280','2495000','2495000','2495000','2495000','2495000','kasir','2026-09-27 10:51:44','FB-260927-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260927-0005','NUR','TALESAN','','','','kasir','2026-09-27 10:51:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-27' 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-260927-0021','K','2026-09-27','10:51:44','kasir','PEMBELIAN UMUM','FB-260927-0005','7645098000','2495000','7642603000');
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 ('F326271053551','kasir','1',' MFE1 X KH ','TOKO','PM-E','E1F-ZIXH-71-0','CC X MODEL SPECTRA SLEP KH 14 8K ','','0.350','1','100.00','373000','0','0','15000','372000','0','0','0','372000','AAT','00422338','E1F','0','0','-','1','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIXH-71-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-09-27' AND kode_barang='E1F-ZIXH-71-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 ('F326271053551','2026-09-27','0.350','2026-09-27','10:53:56','PLG0031556','372000','372000','0','372000','372000','kasir','2026-09-27 10:53:55','F32627105355');
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-09-27','F326271053551','2026-09-27','10:53:56','AAT','372000','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-260927-0022','D','2026-09-27','10:53:56','kasir','PENJUALAN','F326271053551','7642603000','372000','7642975000');
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-00020342','X-00020342','GL X OVAL C GELOMBANG YT 54','GR','---','F1E','BELI','BELI001','2480000','2026-09-27','3.260','1','kasir','2026-09-27 10:57:12');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020342','X-00020342');
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-260927-0006','F322300226531','FIT','1','BELI','BELI001','F1E', 'X-00020342', 'GL X OVAL C GELOMBANG YT 54','3.260','3.260','100.00','1419000','2480000','760736','1055000','1','2480000','2480000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.260',berat_beli_asli=berat_beli_asli+'3.260',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.260',berat_akhir_asli=berat_akhir_asli+'3.260',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-27' 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-260927-0006','2026-09-27','2026-09-27','10:57:11','FIT','---','3.260','2480000','2480000','2480000','2480000','2480000','kasir','2026-09-27 10:57:12','FB-260927-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260927-0006','NUR','TALESAN','','','','kasir','2026-09-27 10:57:12');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-27' 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-260927-0023','K','2026-09-27','10:57:11','kasir','PEMBELIAN UMUM','FB-260927-0006','7642975000','2480000','7640495000');
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-00020343','X-00020343','GL X OVAL C GELOMBANG SLEP YT 54 8K','GR','---','F1E','BELI','BELI001','2330000','2026-09-27','3.070','1','kasir','2026-09-27 11:00:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020343','X-00020343');
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-260927-0007','F324031048001','FIT','1','BELI','BELI001','F1E', 'X-00020343', 'GL X OVAL C GELOMBANG SLEP YT 54 8K','3.070','3.070','100.00','1898000','2330000','758958','1055000','1','2330000','2330000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.070',berat_beli_asli=berat_beli_asli+'3.070',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.070',berat_akhir_asli=berat_akhir_asli+'3.070',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-27' 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-260927-0007','2026-09-27','2026-09-27','11:00:15','FIT','---','3.070','2330000','2330000','2330000','2330000','2330000','kasir','2026-09-27 11:00:16','FB-260927-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260927-0007','NUR','NGLOROK TALESAN','','','','kasir','2026-09-27 11:00:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-27' 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-260927-0024','K','2026-09-27','11:00:15','kasir','PEMBELIAN UMUM','FB-260927-0007','7640495000','2330000','7638165000');
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-00020344','X-00020344','GL COR T 8K','GR','---','F1E','BELI','BELI001','2400000','2026-09-27','3.160','1','kasir','2026-09-27 11:02:58');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020344','X-00020344');
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-260927-0008','F323121021141','FIT','1','BELI','BELI001','F1E', 'X-00020344', 'GL COR T 8K','3.160','3.160','100.00','1416000','2400000','759494','1055000','1','2400000','2400000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.160',berat_beli_asli=berat_beli_asli+'3.160',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.160',berat_akhir_asli=berat_akhir_asli+'3.160',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-27' 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-260927-0008','2026-09-27','2026-09-27','11:02:58','FIT','---','3.160','2400000','2400000','2400000','2400000','2400000','kasir','2026-09-27 11:02:58','FB-260927-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260927-0008','MBAK NUR','JAJAR TALESAAN','','','','kasir','2026-09-27 11:02:58');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-27' 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-260927-0025','K','2026-09-27','11:02:58','kasir','PEMBELIAN UMUM','FB-260927-0008','7638165000','2400000','7635765000');
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-00020345','X-00020345','KL X SANTA ANAK KH 34 9K','GR','---','H2I','BELI','BELI001','1940000','2026-09-27','1.950','1','kasir','2026-09-27 11:03:19');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00020345','X-00020345');
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-260927-0009','F325020837591','LIS','1','BELI','BELI001','H2I', 'X-00020345', 'KL X SANTA ANAK KH 34 9K','1.950','1.950','100.00','2085000','1940000','994872','1125000','1','1940000','1940000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.950',berat_beli_asli=berat_beli_asli+'1.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.950',berat_akhir_asli=berat_akhir_asli+'1.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2I' 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-260927-0009','2026-09-27','2026-09-27','11:03:18','LIS','---','1.950','1940000','1940000','1940000','1940000','1940000','kasir','2026-09-27 11:03:19','FB-260927-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260927-0009','DIAN','NDARJO WNOGIRI','','','0895800844100','kasir','2026-09-27 11:03:19');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-27' 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-260927-0026','K','2026-09-27','11:03:18','kasir','PEMBELIAN UMUM','FB-260927-0009','7635765000','1940000','7633825000');
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-00020346','X-00020346','GW TUSUK BUNGA CAT VAR LG PE 8K','GR','---','B1E','BELI','BELI001','247000','2026-09-27','0.310','1','kasir','2026-09-27 11:10:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00020346','X-00020346');
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-260927-0010','F326081100261','AAT','1','BELI','BELI001','B1E', 'X-00020346', 'GW TUSUK BUNGA CAT VAR LG PE 8K','0.480','0.310','100.00','500000','247000','796774','1055000','1','247000','247000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.310',berat_beli_asli=berat_beli_asli+'0.310',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.310',berat_akhir_asli=berat_akhir_asli+'0.310',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-27' 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-260927-0010','2026-09-27','2026-09-27','11:10:16','AAT','---','0.310','247000','247000','247000','247000','247000','kasir','2026-09-27 11:10:16','FB-260927-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260927-0010','AQILA','PUHPELEM','','','','kasir','2026-09-27 11:10:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-27' 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-260927-0027','K','2026-09-27','11:10:16','kasir','PEMBELIAN UMUM','FB-260927-0010','7633825000','247000','7633578000');
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-00020347','X-00020347','CC X VELG KACA SLEP YS 10 8K','GR','---','E1D','BELI','BELI001','942000','2026-09-27','0.980','1','kasir','2026-09-27 11:10:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00020347','X-00020347');
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-260927-0011','F326200223031','AAT','2','BELI','BELI001','E1D', 'X-00020347', 'CC X VELG KACA SLEP YS 10 8K','0.980','0.980','100.00','1013000','942000','961224','1035000','1','942000','942000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.980',berat_beli_asli=berat_beli_asli+'0.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.980',berat_akhir_asli=berat_akhir_asli+'0.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' 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-260927-0011','2026-09-27','2026-09-27','11:10:16','AAT','---','0.980','942000','942000','942000','942000','942000','kasir','2026-09-27 11:10:16','FB-260927-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260927-0011','HANA','SAWAHANPLOSO','','','','kasir','2026-09-27 11:10:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-27' 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-260927-0028','K','2026-09-27','11:10:16','kasir','PEMBELIAN UMUM','FB-260927-0011','7633578000','942000','7632636000');
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 ('F326271123121','kasir','1',' MFE1 KH 14','TOKO','PM-E','E1F-ZIAE-276-0','CC BUNGA CLOVER SLEP KH 14 8K ','','0.360','1','100.00','383000','0','0','15000','384000','0','0','0','384000','AAT','00423812','E1F','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIAE-276-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-09-27' AND kode_barang='E1F-ZIAE-276-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 ('F326271123121','2026-09-27','0.360','2026-09-27','11:23:12','PLG0031557','384000','384000','0','384000','384000','kasir','2026-09-27 11:23:12','F32627112312');
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-09-27','F326271123121','2026-09-27','11:23:12','AAT','384000','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-260927-0029','D','2026-09-27','11:23:12','kasir','PENJUALAN','F326271123121','7632636000','384000','7633020000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='384000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326271123121' 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 ('F326271123122','kasir',' 1',' MFE1F KH 1','TOKO','PM-E','E1F-ZIBA-283-0','CC MODEL SPECTRA SLEP KH 18 8K ','','0.400','1','100.00','426000','0','0','15000','426000','0','0','0','426000','AAT','00424827','E1F','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIBA-283-0' 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-09-27' AND kode_barang='E1F-ZIBA-283-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 ('F326271123122','2026-09-27','0.400','2026-09-27','11:23:12','PLG0031558','426000','426000','0','426000','426000','kasir','2026-09-27 11:23:12','F32627112312');
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-09-27','F326271123122','2026-09-27','11:23:12','AAT','426000','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-260927-0030','D','2026-09-27','11:23:12','kasir','PENJUALAN','F326271123122','7633020000','426000','7633446000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='426000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326271123122' 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-00020348','X-00020348','CC X MODEL MATA VAR LG 7 17K','GR','---','E2TE','BELI','BELI001','1350000','2026-09-27','0.950','1','kasir','2026-09-27 12:07:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00020348','X-00020348');
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-260927-0012','F324231144051','SIN','1','BELI','BELI001','E2TE', 'X-00020348', 'CC X MODEL MATA VAR LG 7 17K','0.950','0.950','100.00','1012000','1350000','1421053','1920000','1','1350000','1350000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.950',berat_beli_asli=berat_beli_asli+'0.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.950',berat_akhir_asli=berat_akhir_asli+'0.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-260927-0012','2026-09-27','2026-09-27','12:07:10','SIN','---','0.950','1350000','1350000','1350000','1350000','1350000','kasir','2026-09-27 12:07:10','FB-260927-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260927-0012','WINOPA','NGROMO PACITAN','','','','kasir','2026-09-27 12:07:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-27' 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-260927-0031','K','2026-09-27','12:07:10','kasir','PEMBELIAN UMUM','FB-260927-0012','7633446000','1350000','7632096000');
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 ('F326271239121','kasir','1',' MEE1 KH 16','TOKO','PM-E','E1E-ZIBF-354-0','CC PIPA MODEL HATI SLEP VAR KH 16 8K ','','0.610','1','100.00','644000','0','0','15000','638000','0','0','0','638000','FIT','00425973','E1E','0','0','-','1','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZIBF-354-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-09-27' AND kode_barang='E1E-ZIBF-354-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 ('F326271239121','2026-09-27','0.610','2026-09-27','12:39:12','PLG0031559','638000','638000','0','638000','638000','kasir','2026-09-27 12:39:12','F32627123912');
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-09-27','F326271239121','2026-09-27','12:39:12','FIT','638000','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-260927-0032','D','2026-09-27','12:39:12','kasir','PENJUALAN','F326271239121','7632096000','638000','7632734000');
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 ('F326270124061','kasir','1',' MEH1 KH 44','TOKO','PM-H','H1E-ZGBC-280-0','KL KOREA KH 44 8K ','','2.100','1','100.00','2194000','0','0','15000','2195000','0','0','0','2195000','AAT','00415353','H1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGBC-280-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-09-27' AND kode_barang='H1E-ZGBC-280-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 ('F326270124061','2026-09-27','2.100','2026-09-27','13:24:07','PLG0031560','2195000','2195000','0','2195000','2195000','kasir','2026-09-27 13:24:06','F32627012406');
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-09-27','F326270124061','2026-09-27','13:24:07','AAT','2195000','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-260927-0033','D','2026-09-27','13:24:07','kasir','PENJUALAN','F326270124061','7632734000','2195000','7634929000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2195000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326270124061' 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 ('F326270124062','kasir',' 1',' MEF1 10K L','TOKO','PM-F','F1E-ZBAI-293-0','GL ANAK OSROT MODEL CAT VAR LG 8K ','','1.080','1','100.00','1129000','0','0','15000','1130000','0','10000','0','1140000','AAT','00390965','F1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZBAI-293-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-09-27' AND kode_barang='F1E-ZBAI-293-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 ('F326270124062','2026-09-27','1.080','2026-09-27','13:24:07','PLG0031561','1130000','1130000','10000','1140000','1140000','kasir','2026-09-27 13:24:06','F32627012406');
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-09-27','F326270124062','2026-09-27','13:24:07','AAT','1140000','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-260927-0034','D','2026-09-27','13:24:07','kasir','PENJUALAN','F326270124062','7634929000','1140000','7636069000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1140000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326270124062' 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 ('F326270124063','kasir',' 1',' MDD2 X LG ','TOKO','PM-D','D2D-YJBB-235-0','LT X MODEL HURUF MATA LG N 8K ','','1.050','1','100.00','1076000','0','0','15000','1075000','0','0','0','1075000','AAT','00374298','D2D','0','0','-','1','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-YJBB-235-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-09-27' AND kode_barang='D2D-YJBB-235-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' 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 ('F326270124063','2026-09-27','1.050','2026-09-27','13:24:07','PLG0031562','1075000','1075000','0','1075000','1075000','kasir','2026-09-27 13:24:06','F32627012406');
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-09-27','F326270124063','2026-09-27','13:24:07','AAT','1075000','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-260927-0035','D','2026-09-27','13:24:07','kasir','PENJUALAN','F326270124063','7636069000','1075000','7637144000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1075000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326270124063' 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 ('F326270139031','input','1',' MEF3 XX LT','TOKO','PM-F','F3E-ZIBB-98-0','GL XX RANTAI HOLLOW P3 SLEP LT 8K ','','1.960','1','100.00','2048000','0','0','15000','1990000','0','0','0','1990000','SIN','00425106','F3E','0','0','-','1','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-09-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIBB-98-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.960',berat_jual_asli=berat_jual_asli+'1.960',stock_jual='1',berat_akhir=berat_akhir-'1.960',berat_akhir_asli=berat_akhir_asli-'1.960',stock_akhir='0' WHERE tanggal='2026-09-27' AND kode_barang='F3E-ZIBB-98-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 ('F326270139031','2026-09-27','1.960','2026-09-27','13:39:04','PLG0031563','1990000','1990000','0','1990000','1990000','input','2026-09-27 13:39:03','F32627013903');
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-09-27','F326270139031','2026-09-27','13:39:04','SIN','1990000','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-260927-0036','D','2026-09-27','13:39:04','input','PENJUALAN','F326270139031','7637144000','1990000','7639134000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260927-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260927-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260927-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260927-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260927-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260927-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260927-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260927-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260927-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260927-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260927-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260927-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260927-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260927-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260927-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260927-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260927-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260927-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260927-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260927-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260927-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260927-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260927-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260927-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326270124061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326270124061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326270124061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326270124062' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326270124062' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326270124062';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326270124063' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326270124063' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326270124063';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326270139031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326270139031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326270139031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326270903401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326270903401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326270903401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326270906391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326270906391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326270906391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326270914121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326270914121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326270914121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326270936121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326270936121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326270936121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326270936122' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326270936122' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326270936122';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326270940281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326270940281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326270940281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326270940282' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326270940282' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326270940282';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326270940283' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326270940283' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326270940283';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326271000461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326271000461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326271000461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326271000462' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326271000462' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326271000462';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326271009401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326271009401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326271009401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326271017541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326271017541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326271017541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326271025521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326271025521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326271025521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326271031401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326271031401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326271031401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326271034551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326271034551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326271034551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326271053551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326271053551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326271053551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326271123121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326271123121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326271123121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326271123122' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326271123122' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326271123122';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326271239121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326271239121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326271239121';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-28','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-28';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-27';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-27';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-09-27' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-27';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-27';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-27';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-27';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-28' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-27' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
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-260928-0001','D','2026-09-28','15:10:46','SYSTEM','SALDO AWAL','SALDO AWAL','0','7639134000','7639134000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260928-0001','D','2026-09-28','15:10:46','BCA','SALDO AWAL','SALDO AWAL','0','743627000','743627000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260928-0001','D','2026-09-28','15:10:46','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260928-0001','D','2026-09-28','15:10:46','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-09-28';