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 ('F326080836191','input','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZBXF-87-0','CC X MODEL MATA CM 14 8K ','','1.130','1','100.00','1356000','0','0','15000','1355000','0','0','0','1355000','FIT','00388669','E2D','0','0','-','1','1210000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZBXF-87-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='E2D-ZBXF-87-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 ('F326080836191','2026-03-08','1.130','2026-03-08','08:36:19','PLG0027495','1355000','1355000','0','1355000','1355000','input','2026-03-08 08:36:19','F32608083619');
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-03-08','F326080836191','2026-03-08','08:36:19','FIT','1355000','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-260308-0002','D','2026-03-08','08:36:19','input','PENJUALAN','F326080836191','2796764000','1355000','2798119000');
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 ('F326080838031','input','1',' MEF3E UB ','TOKO','PM-F','F3E-YLXC-5-0','GL KOREA SLEP UB 8K ','','1.170','1','100.00','1427000','0','0','15000','1428000','0','0','0','1428000','SIN','00379321','F3E','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLXC-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.170',berat_jual_asli=berat_jual_asli+'1.170',stock_jual='1',berat_akhir=berat_akhir-'1.170',berat_akhir_asli=berat_akhir_asli-'1.170',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='F3E-YLXC-5-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 ('F326080838031','2026-03-08','1.170','2026-03-08','08:38:04','PLG0027496','1428000','1428000','0','1428000','1428000','input','2026-03-08 08:38:03','F32608083803');
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-03-08','F326080838031','2026-03-08','08:38:04','SIN','1428000','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-260308-0003','D','2026-03-08','08:38:04','input','PENJUALAN','F326080838031','2798119000','1428000','2799547000');
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 ('F326080842411','input','1',' MEB1 5K CM','TOKO','PM-B','B1E-ZABA-167-0','GW TUSUK BUNGA CLOVER CAT CM PE 8K ','','0.500','1','100.00','610000','0','0','15000','610000','0','5000','0','615000','FIT','00386492','B1E','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZABA-167-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-03-08' AND kode_barang='B1E-ZABA-167-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 ('F326080842411','2026-03-08','0.500','2026-03-08','08:42:42','PLG0027497','610000','610000','5000','615000','615000','input','2026-03-08 08:42:41','F32608084241');
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-03-08','F326080842411','2026-03-08','08:42:42','FIT','615000','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-260308-0004','D','2026-03-08','08:42:42','input','PENJUALAN','F326080842411','2799547000','615000','2800162000');
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 ('F326080859241','input','1',' MDE2 X 10K','TOKO','PM-E','E2D-YKXC-56-0','CC X BONEKA ANAK CAT MATA LG 8K ','','0.960','1','100.00','1152000','0','0','15000','1143000','0','10000','0','1153000','LIS','00375977','E2D','0','0','-','1','1210000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YKXC-56-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='E2D-YKXC-56-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 ('F326080859241','2026-03-08','0.960','2026-03-08','08:59:25','PLG0027498','1143000','1143000','10000','1153000','1153000','input','2026-03-08 08:59:24','F32608085924');
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-03-08','F326080859241','2026-03-08','08:59:25','LIS','1153000','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-260308-0005','D','2026-03-08','08:59:25','input','PENJUALAN','F326080859241','2800162000','1153000','2801315000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1153000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080859241' 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 ('F326080859242','input',' 1',' MEE2E X LG','TOKO','PM-E','E2E-YLAE-144-0','CC X BONEKA ANAK CAT MATA LG 8K ','','0.500','1','100.00','610000','0','0','15000','605000','0','0','0','605000','LIS','00381122','E2E','0','0','-','1','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YLAE-144-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-03-08' AND kode_barang='E2E-YLAE-144-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 ('F326080859242','2026-03-08','0.500','2026-03-08','08:59:25','PLG0027499','605000','605000','0','605000','605000','input','2026-03-08 08:59:24','F32608085924');
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-03-08','F326080859242','2026-03-08','08:59:25','LIS','605000','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-260308-0006','D','2026-03-08','08:59:25','input','PENJUALAN','F326080859242','2801315000','605000','2801920000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='605000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080859242' 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 ('F326080901221','input','1',' MJH2 XX UB','TOKO','PM-H','H2J-ZCXB-370-0','KL XX MILANO UB 42 9K ','','2.090','1','100.00','2759000','0','0','15000','2696000','0','0','0','2696000','LIS','00391793','H2J','0','0','-','1','1330000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZCXB-370-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.090',berat_jual_asli=berat_jual_asli+'2.090',stock_jual='1',berat_akhir=berat_akhir-'2.090',berat_akhir_asli=berat_akhir_asli-'2.090',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='H2J-ZCXB-370-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 ('F326080901221','2026-03-08','2.090','2026-03-08','09:01:23','PLG0027500','2696000','2696000','0','2696000','2696000','input','2026-03-08 09:01:22','F32608090122');
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-03-08','F326080901221','2026-03-08','09:01:23','LIS','2696000','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-260308-0007','D','2026-03-08','09:01:23','input','PENJUALAN','F326080901221','2801920000','2696000','2804616000');
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 ('F326080903121','input','1',' MEE2 YT 16','TOKO','PM-E','E2E-YCXE-87-0','CC MODEL MATA VAR YT 16 8K ','','0.700','1','100.00','854000','0','0','15000','855000','0','0','0','855000','SIN','00341892','E2E','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YCXE-87-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='E2E-YCXE-87-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 ('F326080903121','2026-03-08','0.700','2026-03-08','09:03:13','PLG0027501','855000','855000','0','855000','855000','input','2026-03-08 09:03:12','F32608090312');
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-03-08','F326080903121','2026-03-08','09:03:13','SIN','855000','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-260308-0008','D','2026-03-08','09:03:13','input','PENJUALAN','F326080903121','2804616000','855000','2805471000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='855000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080903121' 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 ('F326080903122','input',' 1',' MEE2 UB 14','TOKO','PM-E','E2E-YJXD-58-T','CC MODEL PITA MATA VAR UB 14 8K ','','0.700','1','100.00','854000','0','0','15000','855000','0','0','0','855000','SIN','T0073872','E2E','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXD-58-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='E2E-YJXD-58-T' 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 ('F326080903122','2026-03-08','0.700','2026-03-08','09:03:13','PLG0027502','855000','855000','0','855000','855000','input','2026-03-08 09:03:12','F32608090312');
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-03-08','F326080903122','2026-03-08','09:03:13','SIN','855000','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-260308-0009','D','2026-03-08','09:03:13','input','PENJUALAN','F326080903122','2805471000','855000','2806326000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='855000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080903122' 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 ('F326080948421','input','1',' MEF3E X HW','TOKO','PM-F','F3E-ZCXB-271-0','GL X HARLEY DOBEL SLEP HW 8K ','','3.030','1','100.00','3697000','0','0','15000','3697000','0','0','0','3697000','LIS','00391694','F3E','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCXB-271-0' 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-03-08' AND kode_barang='F3E-ZCXB-271-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 ('F326080948421','2026-03-08','3.030','2026-03-08','09:48:43','PLG0027503','3697000','3697000','0','3697000','3697000','input','2026-03-08 09:48:42','F32608094842');
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-03-08','F326080948421','2026-03-08','09:48:43','LIS','3697000','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-260308-0010','D','2026-03-08','09:48:43','input','PENJUALAN','F326080948421','2806326000','3697000','2810023000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3697000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080948421' 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 ('F326080948422','input',' 1',' MGS1G X DG','TOKO','PM-S','S1G-ZAAF-18-0','AS X EXTENTION DG 8K ','','0.310','1','100.00','391000','0','0','15000','391000','0','0','0','391000','LIS','00385469','S1G','0','0','-','0','1270000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZAAF-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='S1G-ZAAF-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-S' 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 ('F326080948422','2026-03-08','0.310','2026-03-08','09:48:43','PLG0027504','391000','391000','0','391000','391000','input','2026-03-08 09:48:42','F32608094842');
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-03-08','F326080948422','2026-03-08','09:48:43','LIS','391000','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-260308-0011','D','2026-03-08','09:48:43','input','PENJUALAN','F326080948422','2810023000','391000','2810414000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='391000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080948422' 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 ('F326081008541','input','1',' MEF3E X YT','TOKO','PM-F','F3E-YLBI-161-0','GL X TIFF ARESO VAR YT 8K ','','2.000','1','100.00','2440000','0','0','15000','2440000','0','0','0','2440000','FIT','00383313','F3E','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLBI-161-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='F3E-YLBI-161-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 ('F326081008541','2026-03-08','2.000','2026-03-08','10:08:55','PLG0027505','2440000','2440000','0','2440000','2440000','input','2026-03-08 10:08:54','F32608100854');
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-03-08','F326081008541','2026-03-08','10:08:55','FIT','2440000','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-260308-0012','D','2026-03-08','10:08:55','input','PENJUALAN','F326081008541','2810414000','2440000','2812854000');
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 ('F326081017041','kasir','1',' MDA1 X 10K','TOKO','PM-A','A1D-YKAD-46-0','AT X MODEL BONEKA ANAK CAT VAR HW 8K ','','0.850','1','100.00','1020000','0','0','15000','1020000','0','10000','0','1030000','AAT','00377384','A1D','0','0','-','0','1210000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YKAD-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='A1D-YKAD-46-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 ('F326081017041','2026-03-08','0.850','2026-03-08','10:17:05','PLG0027506','1020000','1020000','10000','1030000','1030000','kasir','2026-03-08 10:17:04','F32608101704');
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-03-08','F326081017041','2026-03-08','10:17:05','AAT','1030000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260308-0013','D','2026-03-08','10:17:05','kasir','PENJUALAN','F326081017041','2812854000','1030000','2813884000');
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 ('F326081017441','kasir','1',' MDE1 X UB ','TOKO','PM-E','E1D-ZAAC-49-0','CC X WEDDING POLOS UB 22 8K ','','0.900','1','100.00','1080000','0','0','15000','1080000','0','0','0','1080000','SIN','00384956','E1D','0','0','-','0','1210000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAAC-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='E1D-ZAAC-49-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 ('F326081017441','2026-03-08','0.900','2026-03-08','10:17:44','PLG0027507','1080000','1080000','0','1080000','1080000','kasir','2026-03-08 10:17:44','F32608101744');
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-03-08','F326081017441','2026-03-08','10:17:44','SIN','1080000','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-260308-0014','D','2026-03-08','10:17:44','kasir','PENJUALAN','F326081017441','2813884000','1080000','2814964000');
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 ('F326081020241','kasir','1',' TEF3 X UB ','TOKO','PT-F','F3TE-WLBH-56-T','GL X FANCY MODEL HATI VAR UB ','','3.500','1','100.00','7735000','0','0','15000','7735000','0','0','0','7735000','FIT','T0052843','F3TE','0','0','-','0','2210000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-WLBH-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.500',berat_jual_asli=berat_jual_asli+'3.500',stock_jual='1',berat_akhir=berat_akhir-'3.500',berat_akhir_asli=berat_akhir_asli-'3.500',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='F3TE-WLBH-56-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 ('F326081020241','2026-03-08','3.500','2026-03-08','10:20:24','PLG0027508','7735000','7735000','0','7735000','7735000','kasir','2026-03-08 10:20:24','F32608102024');
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-03-08','F326081020241','2026-03-08','10:20:24','FIT','7735000','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-260308-0015','D','2026-03-08','10:20:24','kasir','PENJUALAN','F326081020241','2814964000','7735000','2822699000');
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 ('F326081052531','kasir','1',' MEF3E X UB','TOKO','PM-F','F3E-ZABH-93-0','GL X SANTA HATI MATA SERUT UB 8K ','','1.670','1','100.00','2037000','0','0','15000','2038000','0','0','0','2038000','LIS','00386951','F3E','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZABH-93-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.670',berat_jual_asli=berat_jual_asli+'1.670',stock_jual='1',berat_akhir=berat_akhir-'1.670',berat_akhir_asli=berat_akhir_asli-'1.670',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='F3E-ZABH-93-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 ('F326081052531','2026-03-08','1.670','2026-03-08','10:52:53','PLG0027509','2038000','2038000','0','2038000','2038000','kasir','2026-03-08 10:52:53','F32608105253');
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-03-08','F326081052531','2026-03-08','10:52:53','LIS','2038000','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-260308-0016','D','2026-03-08','10:52:53','kasir','PENJUALAN','F326081052531','2822699000','2038000','2824737000');
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 ('F326081101411','kasir','1',' MEH1 X UB ','TOKO','PM-H','H1E-ZAXH-282-0','KL X NORI UB 44 8K ','','1.430','1','100.00','1745000','0','0','15000','1745000','0','0','0','1745000','AAT','00384368','H1E','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZAXH-282-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.430',berat_jual_asli=berat_jual_asli+'1.430',stock_jual='1',berat_akhir=berat_akhir-'1.430',berat_akhir_asli=berat_akhir_asli-'1.430',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='H1E-ZAXH-282-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 ('F326081101411','2026-03-08','1.430','2026-03-08','11:01:41','PLG0027510','1745000','1745000','0','1745000','1745000','kasir','2026-03-08 11:01:41','F32608110141');
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-03-08','F326081101411','2026-03-08','11:01:41','AAT','1745000','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-260308-0017','D','2026-03-08','11:01:41','kasir','PENJUALAN','F326081101411','2824737000','1745000','2826482000');
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 ('F326081109281','kasir','1',' MEF1 X UB ','TOKO','PM-F','F1E-YJBA-177-0','GL X OVAL C SLEP UB 58 8K ','','2.300','1','100.00','2806000','0','0','15000','2806000','0','0','0','2806000','LIS','00374054','F1E','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YJBA-177-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.300',berat_jual_asli=berat_jual_asli+'2.300',stock_jual='1',berat_akhir=berat_akhir-'2.300',berat_akhir_asli=berat_akhir_asli-'2.300',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='F1E-YJBA-177-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 ('F326081109281','2026-03-08','2.300','2026-03-08','11:09:29','PLG0027511','2806000','2806000','0','2806000','2806000','kasir','2026-03-08 11:09:28','F32608110928');
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-03-08','F326081109281','2026-03-08','11:09:29','LIS','2806000','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-260308-0018','D','2026-03-08','11:09:29','kasir','PENJUALAN','F326081109281','2826482000','2806000','2829288000');
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 ('F326081113581','kasir','1',' MEH1 X YT ','TOKO','PM-H','H1E-YLBI-234-0','KL X TIFF SPECTRA HITAM YT 8K ','','2.530','1','100.00','3087000','0','0','15000','3087000','0','15000','0','3102000','SIN','00383386','H1E','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLBI-234-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.530',berat_jual_asli=berat_jual_asli+'2.530',stock_jual='1',berat_akhir=berat_akhir-'2.530',berat_akhir_asli=berat_akhir_asli-'2.530',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='H1E-YLBI-234-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 ('F326081113581','2026-03-08','2.530','2026-03-08','11:13:58','PLG0027512','3087000','3087000','15000','3102000','3102000','kasir','2026-03-08 11:13:58','F32608111358');
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-03-08','F326081113581','2026-03-08','11:13:58','SIN','3102000','15000');
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-260308-0019','D','2026-03-08','11:13:58','kasir','PENJUALAN','F326081113581','2829288000','3102000','2832390000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3102000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326081113581' 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 ('F326081113582','kasir',' 1',' MFF3F UB ','TOKO','PM-F','F3F-YJAE-9-0','GL SIEM COBRA UB 8K ','','1.020','1','100.00','1265000','0','0','15000','1265000','0','0','0','1265000','SIN','00373155','F3F','0','0','-','0','1240000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YJAE-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='F3F-YJAE-9-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 ('F326081113582','2026-03-08','1.020','2026-03-08','11:13:58','PLG0027513','1265000','1265000','0','1265000','1265000','kasir','2026-03-08 11:13:58','F32608111358');
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-03-08','F326081113582','2026-03-08','11:13:58','SIN','1265000','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-260308-0020','D','2026-03-08','11:13:58','kasir','PENJUALAN','F326081113582','2832390000','1265000','2833655000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1265000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326081113582' 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 ('F326081113583','kasir',' 1',' MEF3 LT ','TOKO','PM-F','F3E-ZCXB-377-0','GL ANAK RANTAI HOLLOW P3 SLEP LT 8K ','','1.060','1','100.00','1293000','0','0','15000','1293000','0','0','0','1293000','SIN','00391800','F3E','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCXB-377-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='F3E-ZCXB-377-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 ('F326081113583','2026-03-08','1.060','2026-03-08','11:13:58','PLG0027514','1293000','1293000','0','1293000','1293000','kasir','2026-03-08 11:13:58','F32608111358');
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-03-08','F326081113583','2026-03-08','11:13:58','SIN','1293000','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-260308-0021','D','2026-03-08','11:13:58','kasir','PENJUALAN','F326081113583','2833655000','1293000','2834948000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1293000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326081113583' 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 ('F326080117321','kasir','1',' MEH1 X KH ','TOKO','PM-H','H1E-ZBAD-233-0','KL X NORI KH 42 8K ','','2.040','1','100.00','2489000','0','0','15000','2490000','0','0','0','2490000','LIS','00389839','H1E','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBAD-233-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.040',berat_jual_asli=berat_jual_asli+'2.040',stock_jual='1',berat_akhir=berat_akhir-'2.040',berat_akhir_asli=berat_akhir_asli-'2.040',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='H1E-ZBAD-233-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 ('F326080117321','2026-03-08','2.040','2026-03-08','13:17:33','PLG0027515','2490000','2490000','0','2490000','2490000','kasir','2026-03-08 13:17:32','F32608011732');
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-03-08','F326080117321','2026-03-08','13:17:33','LIS','2490000','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-260308-0022','D','2026-03-08','13:17:33','kasir','PENJUALAN','F326080117321','2834948000','2490000','2837438000');
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='907500',harga_beli ='907500' WHERE kode_barcode='00102296' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2923500',harga_beli ='2923500' WHERE kode_barcode='00108862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2684000',harga_beli ='2684000' WHERE kode_barcode='00113960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2205000',harga_beli ='2205000' WHERE kode_barcode='00132203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='1676000',harga_beli ='1676000' WHERE kode_barcode='00174902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='1663500',harga_beli ='1663500' WHERE kode_barcode='00208920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='756000',harga_beli ='756000' WHERE kode_barcode='00210050' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='1021000',harga_beli ='1021000' WHERE kode_barcode='00216302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='1474500',harga_beli ='1474500' WHERE kode_barcode='00232855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='1462000',harga_beli ='1462000' WHERE kode_barcode='00232856' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='1197000',harga_beli ='1197000' WHERE kode_barcode='00239628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2533000',harga_beli ='2533000' WHERE kode_barcode='00261063' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='718500',harga_beli ='718500' WHERE kode_barcode='00263551' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='1449000',harga_beli ='1449000' WHERE kode_barcode='00267305' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='1260000',harga_beli ='1260000' WHERE kode_barcode='00285477' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2520000',harga_beli ='2520000' WHERE kode_barcode='00286942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2520000',harga_beli ='2520000' WHERE kode_barcode='00286945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2520000',harga_beli ='2520000' WHERE kode_barcode='00286946' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='605000',harga_beli ='605000' WHERE kode_barcode='00291047' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='630000',harga_beli ='630000' WHERE kode_barcode='00304304' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2495000',harga_beli ='2495000' WHERE kode_barcode='00311794' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2583000',harga_beli ='2583000' WHERE kode_barcode='00311795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='630000',harga_beli ='630000' WHERE kode_barcode='00314180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2432000',harga_beli ='2432000' WHERE kode_barcode='00314981' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2482500',harga_beli ='2482500' WHERE kode_barcode='00314982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2394000',harga_beli ='2394000' WHERE kode_barcode='00314985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2331000',harga_beli ='2331000' WHERE kode_barcode='00314990' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2457000',harga_beli ='2457000' WHERE kode_barcode='00314993' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2457000',harga_beli ='2457000' WHERE kode_barcode='00314994' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2394000',harga_beli ='2394000' WHERE kode_barcode='00314995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2407000',harga_beli ='2407000' WHERE kode_barcode='00314996' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='1449000',harga_beli ='1449000' WHERE kode_barcode='00314998' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='441000',harga_beli ='441000' WHERE kode_barcode='00320317' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='1701000',harga_beli ='1701000' WHERE kode_barcode='00321886' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2520000',harga_beli ='2520000' WHERE kode_barcode='00329723' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='265000',harga_beli ='265000' WHERE kode_barcode='00332676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='567000',harga_beli ='567000' WHERE kode_barcode='00335335' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='756000',harga_beli ='756000' WHERE kode_barcode='00335339' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='668000',harga_beli ='668000' WHERE kode_barcode='00336430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='1159500',harga_beli ='1159500' WHERE kode_barcode='00346067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='416000',harga_beli ='416000' WHERE kode_barcode='00348727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2444500',harga_beli ='2444500' WHERE kode_barcode='00361827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='391000',harga_beli ='391000' WHERE kode_barcode='00362873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='479000',harga_beli ='479000' WHERE kode_barcode='00367960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='580000',harga_beli ='580000' WHERE kode_barcode='00367961' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2533000',harga_beli ='2533000' WHERE kode_barcode='00368136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='378000',harga_beli ='378000' WHERE kode_barcode='00371050' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='479000',harga_beli ='479000' WHERE kode_barcode='00371893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2457000',harga_beli ='2457000' WHERE kode_barcode='00375487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='2482500',harga_beli ='2482500' WHERE kode_barcode='00375488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='479000',harga_beli ='479000' WHERE kode_barcode='00377047' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='3868500',harga_beli ='3868500' WHERE kode_barcode='00377372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='1928000',harga_beli ='1928000' WHERE kode_barcode='00378118' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='441000',harga_beli ='441000' WHERE kode_barcode='00381425' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='441000',harga_beli ='441000' WHERE kode_barcode='00381651' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='743500',harga_beli ='743500' WHERE kode_barcode='00382062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='454000',harga_beli ='454000' WHERE kode_barcode='00385467' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='403500',harga_beli ='403500' WHERE kode_barcode='00386169' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='403500',harga_beli ='403500' WHERE kode_barcode='00386529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='403500',harga_beli ='403500' WHERE kode_barcode='00386913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='416000',harga_beli ='416000' WHERE kode_barcode='00387503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='391000',harga_beli ='391000' WHERE kode_barcode='00387506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='403500',harga_beli ='403500' WHERE kode_barcode='00387512' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='441000',harga_beli ='441000' WHERE kode_barcode='00387691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='491500',harga_beli ='491500' WHERE kode_barcode='00387977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='378000',harga_beli ='378000' WHERE kode_barcode='00389717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='416000',harga_beli ='416000' WHERE kode_barcode='00391248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='403500',harga_beli ='403500' WHERE kode_barcode='00391890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='517000',harga_beli ='517000' WHERE kode_barcode='00391892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='416000',harga_beli ='416000' WHERE kode_barcode='00391911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='391000',harga_beli ='391000' WHERE kode_barcode='00392237' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='403500',harga_beli ='403500' WHERE kode_barcode='00392238' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='454000',harga_beli ='454000' WHERE kode_barcode='00392239' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='441000',harga_beli ='441000' WHERE kode_barcode='00392240' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='441000',harga_beli ='441000' WHERE kode_barcode='00392241' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='315000',harga_beli ='315000' WHERE kode_barcode='00392436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='466500',harga_beli ='466500' WHERE kode_barcode='00392555' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='378000',harga_beli ='378000' WHERE kode_barcode='00392757' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='378000',harga_beli ='378000' WHERE kode_barcode='00392758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1260000',harga_jual='479000',harga_beli ='479000' WHERE kode_barcode='00392769' LIMIT 1;
UPDATE tm_group SET harga='1260000' WHERE kode_group = 'MG' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MG','1260000','input','2026-03-08 14:10:17');
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 ('F326080211151','input','1',' MGE1 UB 12','TOKO','PM-E','E1G-ZCXG-333-0','CC MODEL LINEA VAR UB 12 8K ','','0.380','1','100.00','479000','0','0','15000','480000','0','0','0','480000','SIN','00392769','E1G','0','0','-','0','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-ZCXG-333-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='E1G-ZCXG-333-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326080211151','2026-03-08','0.380','2026-03-08','14:11:15','PLG0027516','480000','480000','0','480000','480000','input','2026-03-08 14:11:15','F32608021115');
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-03-08','F326080211151','2026-03-08','14:11:15','SIN','480000','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-260308-0023','D','2026-03-08','14:11:15','input','PENJUALAN','F326080211151','2837438000','480000','2837918000');
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 ('F326080226481','input','1',' MEF3 LT ','TOKO','PM-F','F3E-ZCXB-376-0','GL ANAK MODEL TRIXIE VAR LT 8K ','','1.020','1','100.00','1244000','0','0','15000','1245000','0','0','0','1245000','LIS','00391799','F3E','0','0','-','0','1230000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCXB-376-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='F3E-ZCXB-376-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 ('F326080226481','2026-03-08','1.020','2026-03-08','14:26:48','PLG0027517','1245000','1245000','0','1245000','1245000','input','2026-03-08 14:26:48','F32608022648');
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-03-08','F326080226481','2026-03-08','14:26:48','LIS','1245000','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-260308-0024','D','2026-03-08','14:26:48','input','PENJUALAN','F326080226481','2837918000','1245000','2839163000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1245000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080226481' 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 ('F326080226482','input',' 1',' MFE2 X LG ','TOKO','PM-E','E2F-XIXB-171-0','CC X ANAK BONEKA CAT MATA VAR LG 8K ','','0.480','1','100.00','595000','0','0','15000','595000','0','0','0','595000','LIS','00315522','E2F','0','0','-','0','1240000');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-XIXB-171-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-03-08' AND kode_barang='E2F-XIXB-171-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 ('F326080226482','2026-03-08','0.480','2026-03-08','14:26:48','PLG0027518','595000','595000','0','595000','595000','input','2026-03-08 14:26:48','F32608022648');
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-03-08','F326080226482','2026-03-08','14:26:48','LIS','595000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260308-0025','D','2026-03-08','14:26:48','input','PENJUALAN','F326080226482','2839163000','595000','2839758000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='595000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326080226482' 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-00018390','X-00018390','CC COR T 17K','GR','---','E1TE','BELI','BELI001','1700000','2026-03-08','1.030','1','kasir','2026-03-08 14:37:52');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1TE','X-00018390','X-00018390');
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-260308-0001','F323301150241','FIT','1','BELI','BELI001','E1TE', 'X-00018390', 'CC COR T 17K','1.030','1.030','100.00','870000','1700000','1650485','2210000','1','1700000','1700000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.030',berat_beli_asli=berat_beli_asli+'1.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.030',berat_akhir_asli=berat_akhir_asli+'1.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1TE' 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-260308-0001','2026-03-08','2026-03-08','14:37:51','FIT','---','1.030','1700000','1700000','1700000','1700000','1700000','kasir','2026-03-08 14:37:52','FB-260308-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260308-0001','YATMI','BAKALAN','','','','kasir','2026-03-08 14:37:52');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-08' 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-260308-0026','K','2026-03-08','14:37:51','kasir','PEMBELIAN UMUM','FB-260308-0001','2839758000','1700000','2838058000');
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-00018391','X-00018391','CC COR M 8K','GR','---','E2E','BELI','BELI001','845000','2026-03-08','1.110','1','kasir','2026-03-08 14:39:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018391','X-00018391');
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-260308-0002','00280931','AAT','1','BELI','BELI001','E2E', 'X-00018391', 'CC COR M 8K','1.120','1.110','100.00','585000','845000','761261','1230000','1','845000','845000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.110',berat_beli_asli=berat_beli_asli+'1.110',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.110',berat_akhir_asli=berat_akhir_asli+'1.110',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-260308-0002','2026-03-08','2026-03-08','14:39:32','AAT','---','1.110','845000','845000','845000','845000','845000','kasir','2026-03-08 14:39:33','FB-260308-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260308-0002','CILLA','BANDAR PACITAN','','','','kasir','2026-03-08 14:39:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-08' 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-260308-0027','K','2026-03-08','14:39:32','kasir','PEMBELIAN UMUM','FB-260308-0002','2838058000','845000','2837213000');
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-00018392','X-00018392','CC X BANGKOK BONEKA ANAK CAT LG 8K','GR','---','E1F','BELI','BELI001','395000','2026-03-08','0.550','1','kasir','2026-03-08 14:39:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1F','X-00018392','X-00018392');
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-260308-0003','F324071038181','AAT','2','BELI','BELI001','E1F', 'X-00018392', 'CC X BANGKOK BONEKA ANAK CAT LG 8K','0.550','0.550','100.00','360000','395000','718182','1240000','1','395000','395000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1F' 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-260308-0003','2026-03-08','2026-03-08','14:39:32','AAT','---','0.550','395000','395000','395000','395000','395000','kasir','2026-03-08 14:39:33','FB-260308-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260308-0003','SHEILA','BANDAR PACITAN','','','','kasir','2026-03-08 14:39:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-08' 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-260308-0028','K','2026-03-08','14:39:32','kasir','PEMBELIAN UMUM','FB-260308-0003','2837213000','395000','2836818000');
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-00018393','X-00018393','KL X NORY KH 42 8K','GR','---','H1E','BELI','BELI001','1985000','2026-03-08','2.080','1','kasir','2026-03-08 14:40:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00018393','X-00018393');
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-260308-0004','F325091147051','AAT','1','BELI','BELI001','H1E', 'X-00018393', 'KL X NORY KH 42 8K','2.080','2.080','100.00','2090000','1985000','954327','1230000','1','1985000','1985000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.080',berat_beli_asli=berat_beli_asli+'2.080',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.080',berat_akhir_asli=berat_akhir_asli+'2.080',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260308-0004','2026-03-08','2026-03-08','14:40:50','AAT','---','2.080','1985000','1985000','1985000','1985000','1985000','kasir','2026-03-08 14:40:51','FB-260308-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260308-0004','ALSYA','LEMAHBANG KISMANTORO','','','','kasir','2026-03-08 14:40:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-08' 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-260308-0029','K','2026-03-08','14:40:50','kasir','PEMBELIAN UMUM','FB-260308-0004','2836818000','1985000','2834833000');
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-00018394','X-00018394','GL X OVAL MODEL HATI MATA UB D56','GR','---','F2E','BELI','BELI001','2510000','2026-03-08','3.280','1','kasir','2026-03-08 14:41:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00018394','X-00018394');
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-260308-0005','F324311006432','LIS','1','BELI','BELI001','F2E', 'X-00018394', 'GL X OVAL MODEL HATI MATA UB D56','3.300','3.280','100.00','1799000','2510000','765244','1230000','1','2510000','2510000','RUSAK');
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-03-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2E' 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-260308-0005','2026-03-08','2026-03-08','14:41:37','LIS','---','3.280','2510000','2510000','2510000','2510000','2510000','kasir','2026-03-08 14:41:38','FB-260308-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260308-0005','REZA','PURWANTORO','','','','kasir','2026-03-08 14:41:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-08' 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-260308-0030','K','2026-03-08','14:41:37','kasir','PEMBELIAN UMUM','FB-260308-0005','2834833000','2510000','2832323000');
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-00018395','X-00018395','CC MODEL MATA SLEP VAR YT 21 8K','GR','---','E2D','BELI','BELI001','670000','2026-03-08','0.820','1','kasir','2026-03-08 14:42:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00018395','X-00018395');
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-260308-0006','F325140853231','LIS','1','BELI','BELI001','E2D', 'X-00018395', 'CC MODEL MATA SLEP VAR YT 21 8K','0.820','0.820','100.00','720000','670000','817073','1210000','1','670000','670000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.820',berat_beli_asli=berat_beli_asli+'0.820',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.820',berat_akhir_asli=berat_akhir_asli+'0.820',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-08' 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-260308-0006','2026-03-08','2026-03-08','14:42:02','LIS','---','0.820','670000','670000','670000','670000','670000','kasir','2026-03-08 14:42:03','FB-260308-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260308-0006','FIKA','KETONGGO BULUKERTO','','','081548449613','kasir','2026-03-08 14:42:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-08' 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-260308-0031','K','2026-03-08','14:42:02','kasir','PEMBELIAN UMUM','FB-260308-0006','2832323000','670000','2831653000');
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-00018396','X-00018396','AT COR 8K','GR','---','A1F','BELI','BELI001','660000','2026-03-08','0.900','1','kasir','2026-03-08 14:44:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00018396','X-00018396');
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-260308-0007','t0055487','AAT','1','BELI','BELI001','A1F', 'X-00018396', 'AT COR 8K','0.930','0.900','100.00','527000','660000','733333','1240000','1','660000','660000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' 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-260308-0007','2026-03-08','2026-03-08','14:44:34','AAT','---','0.900','660000','660000','660000','660000','660000','kasir','2026-03-08 14:44:34','FB-260308-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260308-0007','YULIANI','WONOGIRI','','','','kasir','2026-03-08 14:44:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-08' 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-260308-0032','K','2026-03-08','14:44:34','kasir','PEMBELIAN UMUM','FB-260308-0007','2831653000','660000','2830993000');
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-00018397','X-00018397','C X LISTERING MATA LG 16 8K','GR','---','E2D','BELI','BELI001','1275000','2026-03-08','1.270','1','kasir','2026-03-08 14:52:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00018397','X-00018397');
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-260308-0008','F325280231481','AAT','1','BELI','BELI001','E2D', 'X-00018397', 'C X LISTERING MATA LG 16 8K','1.270','1.270','100.00','1373000','1275000','1003937','1210000','1','1275000','1275000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.270',berat_beli_asli=berat_beli_asli+'1.270',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.270',berat_akhir_asli=berat_akhir_asli+'1.270',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-08' 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-260308-0008','2026-03-08','2026-03-08','14:52:56','AAT','---','1.270','1275000','1275000','1275000','1275000','1275000','kasir','2026-03-08 14:52:57','FB-260308-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260308-0008','DIANA','GROWONG PUHPELEM','','','0857636626147','kasir','2026-03-08 14:52:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-08' 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-260308-0033','K','2026-03-08','14:52:56','kasir','PEMBELIAN UMUM','FB-260308-0008','2830993000','1275000','2829718000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260308-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260308-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260308-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260308-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260308-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260308-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260308-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260308-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260308-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260308-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260308-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260308-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260308-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260308-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260308-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260308-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080117321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080117321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080117321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080211151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080211151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080211151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080226481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080226481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080226481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080226482' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080226482' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080226482';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080836191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080836191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080836191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080838031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080838031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080838031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080842411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080842411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080842411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080859241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080859241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080859241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080859242' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080859242' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080859242';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080901221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080901221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080901221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080903121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080903121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080903121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080903122' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080903122' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080903122';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080948421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080948421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080948421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326080948422' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326080948422' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326080948422';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081008541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081008541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081008541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081017041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081017041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081017041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081017441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081017441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081017441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081020241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081020241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081020241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081052531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081052531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081052531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081101411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081101411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081101411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081109281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081109281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081109281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081113581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081113581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081113581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081113582' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081113582' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081113582';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326081113583' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326081113583' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326081113583';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-09','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-06';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-08';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-08';
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-03-08' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-08';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-08';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-08';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-08';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-09' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-08' 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-260309-0001','D','2026-03-09','16:21:30','SYSTEM','SALDO AWAL','SALDO AWAL','0','2829718000','2829718000');
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-260309-0001','D','2026-03-09','16:21:30','BCA','SALDO AWAL','SALDO AWAL','0','707186000','707186000');
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-260309-0001','D','2026-03-09','16:21:30','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-260309-0001','D','2026-03-09','16:21:30','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-03-09';