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 ('F226270940461','kasir','1',' MEF1 CM ','TOKO','SMBK-F','F1E-ZAXH-147-T','GL ANAK OSROT CM 8K','OL','1.180','1','100.00','1481000','0','0','15000','1487000','0','6000','0','1493000','TIN','T0076470','F1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZAXH-147-T' 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-02-27' AND kode_barang='F1E-ZAXH-147-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226270940461','2026-02-27','1.180','2026-02-27','09:40:47','PLG0077683','1487000','1487000','6000','1493000','1493000','kasir','2026-02-27 09:40:46','F22627094046');
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-02-27','F226270940461','2026-02-27','09:40:47','TIN','1493000','6000');
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-260227-0002','D','2026-02-27','09:40:47','kasir','PENJUALAN','F226270940461','6527162000','1493000','6528655000');
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 ('F226271106421','kasir','1',' MEE2 X CM ','TOKO','SMBK-E','E2E-YKXH-170-0','CC X MODEL MATA CM 11 8K ','','0.770','1','100.00','966000','0','0','15000','963000','0','0','0','963000','RHM','00376953','E2E','0','0','-','1','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YKXH-170-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2026-02-27' AND kode_barang='E2E-YKXH-170-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226271106421','2026-02-27','0.770','2026-02-27','11:06:42','PLG0077684','963000','963000','0','963000','963000','kasir','2026-02-27 11:06:42','F22627110642');
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-02-27','F226271106421','2026-02-27','11:06:42','RHM','963000','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-260227-0003','D','2026-02-27','11:06:42','kasir','PENJUALAN','F226271106421','6528655000','963000','6529618000');
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 ('F226271152371','kasir','1',' MED2 X LG ','TOKO','SMBK-D','D2E-ZBAD-134-0','LT X MODEL HURUF MATA LG E 8K ','OLS 25X25','0.550','1','100.00','690000','0','0','15000','702000','0','90000','0','792000','RHM','00389740','D2E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZBAD-134-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-02-27' AND kode_barang='D2E-ZBAD-134-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226271152371','2026-02-27','0.550','2026-02-27','11:52:37','PLG0077685','702000','702000','90000','792000','792000','kasir','2026-02-27 11:52:37','F22627115237');
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-02-27','F226271152371','2026-02-27','11:52:37','RHM','792000','90000');
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-260227-0004','D','2026-02-27','11:52:37','kasir','PENJUALAN','F226271152371','6529618000','792000','6530410000');
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 ('F226271153521','kasir','1',' MEH1 KH 42','TOKO','SMBK-H','H1E-ZACX-131-T','KL SANTA KH 42CM 8K ','OLS DYKBP','3.030','1','100.00','3803000','0','0','15000','3818000','0','210000','0','4028000','RHM','T0077045','H1E','0','0','-','0','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZACX-131-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.030',berat_jual_asli=berat_jual_asli+'3.030',stock_jual='1',berat_akhir=berat_akhir-'3.030',berat_akhir_asli=berat_akhir_asli-'3.030',stock_akhir='0' WHERE tanggal='2026-02-27' AND kode_barang='H1E-ZACX-131-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226271153521','2026-02-27','3.030','2026-02-27','11:53:52','PLG0077686','3818000','3818000','210000','4028000','4028000','kasir','2026-02-27 11:53:52','F22627115352');
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-02-27','F226271153521','2026-02-27','11:53:52','RHM','4028000','210000');
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-260227-0005','D','2026-02-27','11:53:52','kasir','PENJUALAN','F226271153521','6530410000','4028000','6534438000');
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 ('F226271155541','kasir','1',' MHB1 LG ','TOKO','SMBK-B','B1H-ZBAF-58-T','GW TUSUK MRICAN POLOS LG 8K ','OL','0.260','1','100.00','342000','0','0','15000','343000','0','5000','0','348000','RTA','T0077437','B1H','0','0','-','0','1315000');
UPDATE tm_barang SET tgl_last_jual='2026-02-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZBAF-58-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-02-27' AND kode_barang='B1H-ZBAF-58-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226271155541','2026-02-27','0.260','2026-02-27','11:55:55','PLG0077687','343000','343000','5000','348000','348000','kasir','2026-02-27 11:55:54','F22627115554');
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-02-27','F226271155541','2026-02-27','11:55:55','RTA','348000','5000');
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-260227-0006','D','2026-02-27','11:55:55','kasir','PENJUALAN','F226271155541','6534438000','348000','6534786000');
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 ('F226271228201','kasir','1',' MEE2E CM 1','TOKO','SMBK-E','E2E-ZBAC-44-T','CC WEDDING MATA CM 10 8K ','','1.090','1','100.00','1368000','0','0','15000','1363000','0','0','0','1363000','RTA','T0077253','E2E','0','0','-','1','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZBAC-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.090',berat_jual_asli=berat_jual_asli+'1.090',stock_jual='1',berat_akhir=berat_akhir-'1.090',berat_akhir_asli=berat_akhir_asli-'1.090',stock_akhir='0' WHERE tanggal='2026-02-27' AND kode_barang='E2E-ZBAC-44-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226271228201','2026-02-27','1.090','2026-02-27','12:28:21','PLG0077688','1363000','1363000','0','1363000','1363000','kasir','2026-02-27 12:28:20','F22627122820');
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-02-27','F226271228201','2026-02-27','12:28:21','RTA','1363000','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-260227-0007','D','2026-02-27','12:28:21','kasir','PENJUALAN','F226271228201','6534786000','1363000','6536149000');
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 ('F226270152471','kasir','1',' MED1 BW ','TOKO','SMBK-D','D1E-ZABA-64-T','LT MODEL LETTERA PLAT BW 8K ','','0.400','1','100.00','502000','0','0','15000','500000','0','0','0','500000','NS','T0076837','D1E','0','0','-','1','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZABA-64-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-02-27' AND kode_barang='D1E-ZABA-64-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226270152471','2026-02-27','0.400','2026-02-27','13:52:48','PLG0077689','500000','500000','0','500000','500000','kasir','2026-02-27 13:52:47','F22627015247');
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-02-27','F226270152471','2026-02-27','13:52:48','NS','500000','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-260227-0008','D','2026-02-27','13:52:48','kasir','PENJUALAN','F226270152471','6536149000','500000','6536649000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='500000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270152471' 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 ('F226270152472','kasir',' 1',' MEF1 TD D3','TOKO','SMBK-F','F1E-ZBAI-84-T','GL ANAK BANGKOK MODEL C TD D36 8K ','','2.000','1','100.00','2510000','0','0','15000','2500000','0','0','0','2500000','NS','T0077616','F1E','0','0','-','1','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZBAI-84-T' 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-02-27' AND kode_barang='F1E-ZBAI-84-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226270152472','2026-02-27','2.000','2026-02-27','13:52:48','PLG0077690','2500000','2500000','0','2500000','2500000','kasir','2026-02-27 13:52:47','F22627015247');
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-02-27','F226270152472','2026-02-27','13:52:48','NS','2500000','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-260227-0009','D','2026-02-27','13:52:48','kasir','PENJUALAN','F226270152472','6536649000','2500000','6539149000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2500000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270152472' 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 ('F226270223461','kasir','1',' MEE2E CM 1','TOKO','SMBK-E','E2E-ZBAC-40-T','CC WEDDING MATA CM 14 8K ','','1.040','1','100.00','1305000','0','0','15000','1300000','0','0','0','1300000','RTA','T0077249','E2E','0','0','-','1','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZBAC-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2026-02-27' AND kode_barang='E2E-ZBAC-40-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226270223461','2026-02-27','1.040','2026-02-27','14:23:46','PLG0077691','1300000','1300000','0','1300000','1300000','kasir','2026-02-27 14:23:46','F22627022346');
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-02-27','F226270223461','2026-02-27','14:23:46','RTA','1300000','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-260227-0010','D','2026-02-27','14:23:46','kasir','PENJUALAN','F226270223461','6539149000','1300000','6540449000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1300000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270223461' 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 ('F226270223462','kasir',' 1',' MEB1 HW ','TOKO','SMBK-B','B1E-YLXD-16-T','GW MODEL ITALY VAR HW 8K','','0.770','1','100.00','966000','0','0','15000','963000','0','0','0','963000','RTA','T0075484','B1E','0','0','-','1','1250000');
UPDATE tm_barang SET tgl_last_jual='2026-02-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YLXD-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2026-02-27' AND kode_barang='B1E-YLXD-16-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226270223462','2026-02-27','0.770','2026-02-27','14:23:46','PLG0077692','963000','963000','0','963000','963000','kasir','2026-02-27 14:23:46','F22627022346');
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-02-27','F226270223462','2026-02-27','14:23:46','RTA','963000','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-260227-0011','D','2026-02-27','14:23:46','kasir','PENJUALAN','F226270223462','6540449000','963000','6541412000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='963000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226270223462' 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 ('F226270240081','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZBAH-47-T','LT SLOBOK BULAT HURUF BG N 8K ','','0.620','1','100.00','790000','0','0','15000','787000','0','5000','0','792000','NS','T0077492','D1F','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-02-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZBAH-47-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2026-02-27' AND kode_barang='D1F-ZBAH-47-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226270240081','2026-02-27','0.620','2026-02-27','14:40:09','PLG0077693','787000','787000','5000','792000','792000','kasir','2026-02-27 14:40:08','F22627024008');
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-02-27','F226270240081','2026-02-27','14:40:09','NS','792000','5000');
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-260227-0012','D','2026-02-27','14:40:09','kasir','PENJUALAN','F226270240081','6541412000','792000','6542204000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270152471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270152471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270152471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270152472' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270152472' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270152472';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270223461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270223461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270223461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270223462' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270223462' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270223462';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270240081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270240081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270240081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226270940461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226270940461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226270940461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271106421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271106421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271106421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271152371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271152371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271152371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271153521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271153521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271153521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271155541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271155541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271155541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226271228201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226271228201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226271228201';
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-00005144','X-00005144','AS EXTENSION LG 8K','GR','---','S1G','BELI','BELI001','210000','2026-02-27','0.200','1','kasir','2026-02-27 15:20:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-S1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-S1G','X-00005144','X-00005144');
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-260227-0001','F226121100191','NS','1','BELI','BELI001','S1G', 'X-00005144', 'AS EXTENSION LG 8K','0.200','0.200','100.00','264000','210000','1050000','1290000','1','210000','210000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.200',berat_beli_asli=berat_beli_asli+'0.200',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.200',berat_akhir_asli=berat_akhir_asli+'0.200',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='S1G' 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-260227-0001','2026-02-27','2026-02-27','15:20:50','NS','---','0.200','210000','210000','210000','210000','210000','kasir','2026-02-27 15:20:50','FB-260227-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260227-0001','NINDIA','KENITEN','','','','kasir','2026-02-27 15:20:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-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-260227-0013','K','2026-02-27','15:20:50','kasir','PEMBELIAN UMUM','FB-260227-0001','6542204000','210000','6541994000');
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-00005145','X-00005145','CC WEDDING MATA CM 16 8K','GR','---','E2D','BELI','BELI001','858000','2026-02-27','1.080','1','kasir','2026-02-27 15:20:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00005145','X-00005145');
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-260227-0002','F225121053131','NS','2','BELI','BELI001','E2D', 'X-00005145', 'CC WEDDING MATA CM 16 8K','1.080','1.080','100.00','954000','858000','794444','1230000','1','858000','858000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.080',berat_beli_asli=berat_beli_asli+'1.080',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.080',berat_akhir_asli=berat_akhir_asli+'1.080',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-02-27' 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-260227-0002','2026-02-27','2026-02-27','15:20:50','NS','---','1.080','858000','858000','858000','858000','858000','kasir','2026-02-27 15:20:50','FB-260227-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260227-0002','SHINDIA','NGRAYUN PONOROGO','','','081216205879','kasir','2026-02-27 15:20:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-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-260227-0014','K','2026-02-27','15:20:50','kasir','PEMBELIAN UMUM','FB-260227-0002','6541994000','858000','6541136000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260227-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260227-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260227-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260227-0002';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-28','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-28';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-27';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-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-02-27' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-27';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-27';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-27';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-27';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202601 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
UPDATE tt_barang_saldo SET tanggal= '2026-02-28' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-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-260228-0001','D','2026-02-28','16:03:29','SYSTEM','SALDO AWAL','SALDO AWAL','0','6541136000','6541136000');
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-260228-0001','D','2026-02-28','16:03:29','BCA','SALDO AWAL','SALDO AWAL','0','4288430888','4288430888');
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-260228-0001','D','2026-02-28','16:03:29','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
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-260228-0001','D','2026-02-28','16:03:29','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-260228-0001','D','2026-02-28','16:03:29','DLL','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-260228-0001','D','2026-02-28','16:03:29','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2026-02-28';