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 ('F326301016541','input','1',' MJH2 X UB ','TOKO','PM-H','H2J-ZGCA-43-0','KL X GUCCI UB 44 9K ','','1.980','1','100.00','2277000','0','0','15000','2278000','0','0','0','2278000','LIS','00416129','H2J','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZGCA-43-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='H2J-ZGCA-43-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 ('F326301016541','2026-08-30','1.980','2026-08-30','10:16:54','PLG0031048','2278000','2278000','0','2278000','2278000','input','2026-08-30 10:16:54','F32630101654');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326301016541','2026-08-30','10:16:54','LIS','2278000','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-260830-0002','D','2026-08-30','10:16:54','input','PENJUALAN','F326301016541','7093839000','2278000','7096117000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
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 ('F326301020441','kasir','1',' MJH2 X UB ','TOKO','PM-H','H2J-ZGCA-43-0','KL X GUCCI UB 44 9K ','','1.980','1','100.00','2277000','0','0','15000','2278000','0','0','0','2278000','LIS','00416129','H2J','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZGCA-43-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='H2J-ZGCA-43-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 ('F326301020441','2026-08-30','1.980','2026-08-30','10:20:45','PLG0031049','2278000','2278000','0','2278000','2278000','kasir','2026-08-30 10:20:44','F32630102044');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326301020441','2026-08-30','10:20:45','LIS','2278000','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-260830-0004','D','2026-08-30','10:20:45','kasir','PENJUALAN','F326301020441','7093839000','2278000','7096117000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326301020441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326301020441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326301020441';
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 ('F326301023481','kasir','1',' MJH2 X UB ','TOKO','PM-H','H2J-ZGCA-43-0','KL X GUCCI UB 44 9K ','','1.980','1','100.00','2277000','0','0','15000','2278000','0','0','0','2278000','LIS','00416129','H2J','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZGCA-43-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='H2J-ZGCA-43-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 ('F326301023481','2026-08-30','1.980','2026-08-30','10:23:49','PLG0031050','2278000','2278000','0','2278000','2278000','kasir','2026-08-30 10:23:48','F32630102348');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326301023481','2026-08-30','10:23:49','LIS','2278000','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-260830-0006','D','2026-08-30','10:23:49','kasir','PENJUALAN','F326301023481','7093839000','2278000','7096117000');
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 ('F326301112231','kasir','1',' MDE2D X LG','TOKO','PM-E','E2D-ZHAE-99-0','CC X METRO MATA LG 20 8K ','','1.000','1','100.00','1030000','0','0','15000','1030000','0','0','0','1030000','SIN','00419120','E2D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZHAE-99-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='E2D-ZHAE-99-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 ('F326301112231','2026-08-30','1.000','2026-08-30','11:12:24','PLG0031051','1030000','1030000','0','1030000','1030000','kasir','2026-08-30 11:12:23','F32630111223');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326301112231','2026-08-30','11:12:24','SIN','1030000','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-260830-0007','D','2026-08-30','11:12:24','kasir','PENJUALAN','F326301112231','7096117000','1030000','7097147000');
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-00020058','X-00020058','GL MODEL CAPELA VAR HW 8K','GR','---','F3E','BELI','BELI001','1457000','2026-08-30','1.970','1','kasir','2026-08-30 11:13:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020058','X-00020058');
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-260830-0001','F325070815211','AAT','1','BELI','BELI001','F3E', 'X-00020058', 'GL MODEL CAPELA VAR HW 8K','1.970','1.970','100.00','1555000','1457000','739594','1060000','1','1457000','1457000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.970',berat_beli_asli=berat_beli_asli+'1.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.970',berat_akhir_asli=berat_akhir_asli+'1.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260830-0001','2026-08-30','2026-08-30','11:13:29','AAT','---','1.970','1457000','1457000','1457000','1457000','1457000','kasir','2026-08-30 11:13:29','FB-260830-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260830-0001','LESTARI','NGAGLIK BULUKERTO','','','','kasir','2026-08-30 11:13:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-30' 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-260830-0008','K','2026-08-30','11:13:29','kasir','PEMBELIAN UMUM','FB-260830-0001','7097147000','1457000','7095690000');
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-00020059','X-00020059','CC MODEL HATI POLOS LG 14 8K','GR','---','E1G','BELI','BELI001','315000','2026-08-30','0.320','1','kasir','2026-08-30 11:13:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1G','X-00020059','X-00020059');
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-260830-0002','F326041044022','AAT','1','BELI','BELI001','E1G', 'X-00020059', 'CC MODEL HATI POLOS LG 14 8K','0.320','0.320','100.00','385000','315000','984375','1090000','1','315000','315000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.320',berat_beli_asli=berat_beli_asli+'0.320',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.320',berat_akhir_asli=berat_akhir_asli+'0.320',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1G' 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-260830-0002','2026-08-30','2026-08-30','11:13:50','AAT','---','0.320','315000','315000','315000','315000','315000','kasir','2026-08-30 11:13:51','FB-260830-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260830-0002','DEWI','BADEGAN PONOROGO','','','085755700708','kasir','2026-08-30 11:13:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-30' 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-260830-0009','K','2026-08-30','11:13:50','kasir','PEMBELIAN UMUM','FB-260830-0002','7095690000','315000','7095375000');
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-00020060','X-00020060','GL PIPA ANAK CAT MATA LG 38 8K','GR','---','F2E','BELI','BELI001','1692000','2026-08-30','2.000','1','kasir','2026-08-30 11:14:12');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00020060','X-00020060');
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-260830-0003','F326131035121','LIS','1','BELI','BELI001','F2E', 'X-00020060', 'GL PIPA ANAK CAT MATA LG 38 8K','2.060','2.000','100.00','2380000','1692000','846000','1060000','1','1692000','1692000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.000',berat_beli_asli=berat_beli_asli+'2.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.000',berat_akhir_asli=berat_akhir_asli+'2.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-30' 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-260830-0003','2026-08-30','2026-08-30','11:14:11','LIS','---','2.000','1692000','1692000','1692000','1692000','1692000','kasir','2026-08-30 11:14:12','FB-260830-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260830-0003','UUL','LEMAHBANG KISMANTORO','','','081328378646','kasir','2026-08-30 11:14:12');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-30' 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-260830-0010','K','2026-08-30','11:14:11','kasir','PEMBELIAN UMUM','FB-260830-0003','7095375000','1692000','7093683000');
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-00020061','X-00020061','CC WEDDING MATA CM 20 8K','GR','---','E2D','BELI','BELI001','1002000','2026-08-30','1.080','1','kasir','2026-08-30 11:55:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020061','X-00020061');
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-260830-0004','F326170234232','LIS','1','BELI','BELI001','E2D', 'X-00020061', 'CC WEDDING MATA CM 20 8K','1.080','1.080','100.00','1090000','1002000','927778','1040000','1','1002000','1002000','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-08-30' 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-260830-0004','2026-08-30','2026-08-30','11:55:46','LIS','---','1.080','1002000','1002000','1002000','1002000','1002000','kasir','2026-08-30 11:55:47','FB-260830-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260830-0004','TISA','BULUKERTO','','','085735526421','kasir','2026-08-30 11:55:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-30' 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-260830-0011','K','2026-08-30','11:55:46','kasir','PEMBELIAN UMUM','FB-260830-0004','7093683000','1002000','7092681000');
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-00020062','X-00020062','CC WEDDING MATA CM 20 8K','GR','---','E2D','BELI','BELI001','900000','2026-08-30','0.970','1','kasir','2026-08-30 11:55:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020062','X-00020062');
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-260830-0005','F326170234233','LIS','2','BELI','BELI001','E2D', 'X-00020062', 'CC WEDDING MATA CM 20 8K','0.970','0.970','100.00','978000','900000','927835','1040000','1','900000','900000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.970',berat_beli_asli=berat_beli_asli+'0.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.970',berat_akhir_asli=berat_akhir_asli+'0.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-30' 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-260830-0005','2026-08-30','2026-08-30','11:55:46','LIS','---','0.970','900000','900000','900000','900000','900000','kasir','2026-08-30 11:55:47','FB-260830-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260830-0005','TISA','BULUKERTO','','','085735526421','kasir','2026-08-30 11:55:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-30' 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-260830-0012','K','2026-08-30','11:55:46','kasir','PEMBELIAN UMUM','FB-260830-0005','7092681000','900000','7091781000');
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-00020063','X-00020063','CC MODEL ISYANA SLEP LG 18 8K','GR','---','E1E','BELI','BELI001','500000','2026-08-30','0.530','1','kasir','2026-08-30 11:55:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020063','X-00020063');
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-260830-0006','F326170234234','LIS','3','BELI','BELI001','E1E', 'X-00020063', 'CC MODEL ISYANA SLEP LG 18 8K','0.530','0.530','100.00','545000','500000','943396','1060000','1','500000','500000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260830-0006','2026-08-30','2026-08-30','11:55:46','LIS','---','0.530','500000','500000','500000','500000','500000','kasir','2026-08-30 11:55:47','FB-260830-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260830-0006','TISA','BULUKERTO','','','085735526421','kasir','2026-08-30 11:55:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-30' 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-260830-0013','K','2026-08-30','11:55:46','kasir','PEMBELIAN UMUM','FB-260830-0006','7091781000','500000','7091281000');
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-00020064','X-00020064','GL OVAL TINJU SLEP UB 56 8K','GR','---','F1E','BELI','BELI001','1930000','2026-08-30','2.040','1','kasir','2026-08-30 11:55:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020064','X-00020064');
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-260830-0007','F326170234231','LIS','4','BELI','BELI001','F1E', 'X-00020064', 'GL OVAL TINJU SLEP UB 56 8K','2.040','2.040','100.00','2098000','1930000','946078','1060000','1','1930000','1930000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.040',berat_beli_asli=berat_beli_asli+'2.040',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.040',berat_akhir_asli=berat_akhir_asli+'2.040',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260830-0007','2026-08-30','2026-08-30','11:55:46','LIS','---','2.040','1930000','1930000','1930000','1930000','1930000','kasir','2026-08-30 11:55:47','FB-260830-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260830-0007','TISA','BULUKERTO','','','085735526421','kasir','2026-08-30 11:55:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-30' 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-260830-0014','K','2026-08-30','11:55:46','kasir','PEMBELIAN UMUM','FB-260830-0007','7091281000','1930000','7089351000');
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 ('F326301210021','kasir','1',' MEF1 X YT ','TOKO','PM-F','F1E-ZFCX-53-0','GL X OVAL C SLEP YT 52 8K ','','3.470','1','100.00','3643000','0','0','15000','3644000','0','0','0','3644000','SIN','00411260','F1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFCX-53-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.470',berat_jual_asli=berat_jual_asli+'3.470',stock_jual='1',berat_akhir=berat_akhir-'3.470',berat_akhir_asli=berat_akhir_asli-'3.470',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='F1E-ZFCX-53-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 ('F326301210021','2026-08-30','3.470','2026-08-30','12:10:02','PLG0031052','3644000','3644000','0','3644000','3644000','kasir','2026-08-30 12:10:02','F32630121002');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326301210021','2026-08-30','12:10:02','SIN','3644000','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-260830-0015','D','2026-08-30','12:10:02','kasir','PENJUALAN','F326301210021','7089351000','3644000','7092995000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3644000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326301210021' 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 ('F326301210022','kasir',' 1',' MEF3E HW ','TOKO','PM-F','F3E-ZHXH-413-0','GL TIFF VERONA VAR SLEP HW 8K ','','1.730','1','100.00','1816000','0','0','15000','1817000','0','0','0','1817000','SIN','00418143','F3E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHXH-413-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.730',berat_jual_asli=berat_jual_asli+'1.730',stock_jual='1',berat_akhir=berat_akhir-'1.730',berat_akhir_asli=berat_akhir_asli-'1.730',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='F3E-ZHXH-413-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 ('F326301210022','2026-08-30','1.730','2026-08-30','12:10:02','PLG0031053','1817000','1817000','0','1817000','1817000','kasir','2026-08-30 12:10:02','F32630121002');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326301210022','2026-08-30','12:10:02','SIN','1817000','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-260830-0016','D','2026-08-30','12:10:02','kasir','PENJUALAN','F326301210022','7092995000','1817000','7094812000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1817000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326301210022' 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 ('F326301210023','kasir',' 1',' MDE2 X CM ','TOKO','PM-E','E2D-ZFXI-10-0','CC X MODEL MATA CM 18 8K ','','1.310','1','100.00','1349000','0','0','15000','1349000','0','0','0','1349000','SIN','00408077','E2D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFXI-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.310',berat_jual_asli=berat_jual_asli+'1.310',stock_jual='1',berat_akhir=berat_akhir-'1.310',berat_akhir_asli=berat_akhir_asli-'1.310',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='E2D-ZFXI-10-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 ('F326301210023','2026-08-30','1.310','2026-08-30','12:10:02','PLG0031054','1349000','1349000','0','1349000','1349000','kasir','2026-08-30 12:10:02','F32630121002');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326301210023','2026-08-30','12:10:02','SIN','1349000','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-260830-0017','D','2026-08-30','12:10:02','kasir','PENJUALAN','F326301210023','7094812000','1349000','7096161000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1349000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326301210023' 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 ('F326301210024','kasir',' 1',' MDE2 X BM ','TOKO','PM-E','E2D-ZAAF-95-0','CC X MODEL CAT MATA BM 18 8K ','','1.800','1','100.00','1854000','0','0','15000','1854000','0','0','0','1854000','SIN','00385546','E2D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZAAF-95-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.800',berat_jual_asli=berat_jual_asli+'1.800',stock_jual='1',berat_akhir=berat_akhir-'1.800',berat_akhir_asli=berat_akhir_asli-'1.800',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='E2D-ZAAF-95-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 ('F326301210024','2026-08-30','1.800','2026-08-30','12:10:02','PLG0031055','1854000','1854000','0','1854000','1854000','kasir','2026-08-30 12:10:02','F32630121002');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326301210024','2026-08-30','12:10:02','SIN','1854000','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-260830-0018','D','2026-08-30','12:10:02','kasir','PENJUALAN','F326301210024','7096161000','1854000','7098015000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1854000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326301210024' 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 ('F326301239401','kasir','1',' MEE2 LG 12','TOKO','PM-E','E2E-ZEBI-67-0','CC MODEL ISYANA SLEP LG 12 8K ','','0.420','1','100.00','441000','0','0','15000','440000','0','0','0','440000','LIS','00405724','E2E','0','0','-','1','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZEBI-67-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='E2E-ZEBI-67-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 ('F326301239401','2026-08-30','0.420','2026-08-30','12:39:41','PLG0031056','440000','440000','0','440000','440000','kasir','2026-08-30 12:39:40','F32630123940');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326301239401','2026-08-30','12:39:41','LIS','440000','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-260830-0019','D','2026-08-30','12:39:41','kasir','PENJUALAN','F326301239401','7098015000','440000','7098455000');
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-00020065','X-00020065','GL XX OVAL C SLEP UB 54 8K','GR','---','F1E','BELI','BELI001','1330000','2026-08-30','1.350','1','kasir','2026-08-30 13:01:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020065','X-00020065');
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-260830-0008','F326240238151','SIN','1','BELI','BELI001','F1E', 'X-00020065', 'GL XX OVAL C SLEP UB 54 8K','1.350','1.350','100.00','1515000','1330000','985185','1060000','1','1330000','1330000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.350',berat_beli_asli=berat_beli_asli+'1.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.350',berat_akhir_asli=berat_akhir_asli+'1.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260830-0008','2026-08-30','2026-08-30','13:01:36','SIN','---','1.350','1330000','1330000','1330000','1330000','1330000','kasir','2026-08-30 13:01:37','FB-260830-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260830-0008','DIAN','MIRI KISMANTORO','','','','kasir','2026-08-30 13:01:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-30' 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-260830-0020','K','2026-08-30','13:01:36','kasir','PEMBELIAN UMUM','FB-260830-0008','7098455000','1330000','7097125000');
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 ('F326300112031','kasir','1',' MEF3E HW ','TOKO','PM-F','F3E-ZHBA-217-0','GL FANCY VAR SLEP HW 8K ','','1.560','1','100.00','1638000','0','0','15000','1638000','0','0','0','1638000','LIS','00419796','F3E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHBA-217-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.560',berat_jual_asli=berat_jual_asli+'1.560',stock_jual='1',berat_akhir=berat_akhir-'1.560',berat_akhir_asli=berat_akhir_asli-'1.560',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='F3E-ZHBA-217-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 ('F326300112031','2026-08-30','1.560','2026-08-30','13:12:04','PLG0031057','1638000','1638000','0','1638000','1638000','kasir','2026-08-30 13:12:03','F32630011203');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326300112031','2026-08-30','13:12:04','LIS','1638000','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-260830-0021','D','2026-08-30','13:12:04','kasir','PENJUALAN','F326300112031','7097125000','1638000','7098763000');
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 ('F326300142441','input','1',' MJH2 X KH ','TOKO','PM-H','H2J-ZHXH-141-0','KL X MILANO KH 44 9K ','','4.030','1','100.00','4634000','0','0','15000','4635000','0','0','0','4635000','FIT','00417870','H2J','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZHXH-141-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.030',berat_jual_asli=berat_jual_asli+'4.030',stock_jual='1',berat_akhir=berat_akhir-'4.030',berat_akhir_asli=berat_akhir_asli-'4.030',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='H2J-ZHXH-141-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 ('F326300142441','2026-08-30','4.030','2026-08-30','13:42:44','PLG0031058','4635000','4635000','0','4635000','4635000','input','2026-08-30 13:42:44','F32630014244');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326300142441','2026-08-30','13:42:44','FIT','4635000','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-260830-0022','D','2026-08-30','13:42:44','input','PENJUALAN','F326300142441','7098763000','4635000','7103398000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4635000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326300142441' 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 ('F326300142442','input',' 1',' MED2E X LG','TOKO','PM-D','D2E-ZEBG-70-0','LT X MODEL MATA LG 8K ','','0.500','1','100.00','525000','0','0','15000','525000','0','0','0','525000','FIT','00405068','D2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZEBG-70-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='D2E-ZEBG-70-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326300142442','2026-08-30','0.500','2026-08-30','13:42:44','PLG0031059','525000','525000','0','525000','525000','input','2026-08-30 13:42:44','F32630014244');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326300142442','2026-08-30','13:42:44','FIT','525000','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-260830-0023','D','2026-08-30','13:42:44','input','PENJUALAN','F326300142442','7103398000','525000','7103923000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='525000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326300142442' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326300142441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326300142441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326300142441';
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 ('F326300145261','kasir','1',' MJH2 X KH ','TOKO','PM-H','H2J-ZHXH-141-0','KL X MILANO KH 44 9K ','','4.030','1','100.00','4634000','0','0','15000','4635000','0','0','0','4635000','FIT','00417870','H2J','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZHXH-141-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.030',berat_jual_asli=berat_jual_asli+'4.030',stock_jual='1',berat_akhir=berat_akhir-'4.030',berat_akhir_asli=berat_akhir_asli-'4.030',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='H2J-ZHXH-141-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 ('F326300145261','2026-08-30','4.030','2026-08-30','13:45:26','PLG0031060','4635000','4635000','0','4635000','4635000','kasir','2026-08-30 13:45:26','F32630014526');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326300145261','2026-08-30','13:45:26','FIT','4635000','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-260830-0025','D','2026-08-30','13:45:26','kasir','PENJUALAN','F326300145261','7099288000','4635000','7103923000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326300145261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326300145261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326300145261';
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 ('F326300148181','kasir','1',' MJH2 X KH ','TOKO','PM-H','H2J-ZHXH-141-0','KL X MILANO KH 44 9K ','','4.030','1','100.00','4634000','0','0','15000','4635000','0','0','0','4635000','FIT','00417870','H2J','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZHXH-141-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.030',berat_jual_asli=berat_jual_asli+'4.030',stock_jual='1',berat_akhir=berat_akhir-'4.030',berat_akhir_asli=berat_akhir_asli-'4.030',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='H2J-ZHXH-141-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 ('F326300148181','2026-08-30','4.030','2026-08-30','13:48:19','PLG0031061','4635000','4635000','0','4635000','4635000','kasir','2026-08-30 13:48:18','F32630014818');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326300148181','2026-08-30','13:48:19','FIT','4635000','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-260830-0027','D','2026-08-30','13:48:19','kasir','PENJUALAN','F326300148181','7099288000','4635000','7103923000');
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-00020066','X-00020066','KL X MILANO KH 44 9K','GR','---','H2J','BELI','BELI001','4110000','2026-08-30','4.020','1','kasir','2026-08-30 13:53:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00020066','X-00020066');
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-260830-0009','F325100117523','SIN','1','BELI','BELI001','H2J', 'X-00020066', 'KL X MILANO KH 44 9K','4.020','4.020','100.00','4420000','4110000','1022388','1150000','1','4110000','4110000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.020',berat_beli_asli=berat_beli_asli+'4.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.020',berat_akhir_asli=berat_akhir_asli+'4.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2J' 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-260830-0009','2026-08-30','2026-08-30','13:53:24','SIN','---','4.020','4110000','4110000','4110000','4110000','4110000','kasir','2026-08-30 13:53:24','FB-260830-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260830-0009','LINA','BANDAR PACITAN','','','+601139457836','kasir','2026-08-30 13:53:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-30' 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-260830-0028','K','2026-08-30','13:53:24','kasir','PEMBELIAN UMUM','FB-260830-0009','7103923000','4110000','7099813000');
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 ('F326300218461','kasir','1',' MEH1 X YT ','TOKO','PM-H','H1E-ZHBF-110-0','KLX TIFF SPECTRA VAR YT 42 8K ','','1.750','1','100.00','1837000','0','0','15000','1838000','0','15000','0','1853000','AAT','00420482','H1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHBF-110-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.750',berat_jual_asli=berat_jual_asli+'1.750',stock_jual='1',berat_akhir=berat_akhir-'1.750',berat_akhir_asli=berat_akhir_asli-'1.750',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='H1E-ZHBF-110-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 ('F326300218461','2026-08-30','1.750','2026-08-30','14:18:46','PLG0031062','1838000','1838000','15000','1853000','1853000','kasir','2026-08-30 14:18:46','F32630021846');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326300218461','2026-08-30','14:18:46','AAT','1853000','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-260830-0029','D','2026-08-30','14:18:46','kasir','PENJUALAN','F326300218461','7099813000','1853000','7101666000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1853000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326300218461' 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 ('F326300218462','kasir',' 1',' MEF3E X HW','TOKO','PM-F','F3E-ZHAD-80-0','GL X CASTELLI VAR SLEEP HW 8K ','','1.620','1','100.00','1701000','0','0','15000','1702000','0','0','0','1702000','AAT','00418965','F3E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHAD-80-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.620',berat_jual_asli=berat_jual_asli+'1.620',stock_jual='1',berat_akhir=berat_akhir-'1.620',berat_akhir_asli=berat_akhir_asli-'1.620',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='F3E-ZHAD-80-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 ('F326300218462','2026-08-30','1.620','2026-08-30','14:18:46','PLG0031063','1702000','1702000','0','1702000','1702000','kasir','2026-08-30 14:18:46','F32630021846');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326300218462','2026-08-30','14:18:46','AAT','1702000','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-260830-0030','D','2026-08-30','14:18:46','kasir','PENJUALAN','F326300218462','7101666000','1702000','7103368000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1702000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326300218462' 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-00020067','X-00020067','GL RANTAI HOLLOW P3 SLEP KH 8K','GR','---','F3E','BELI','BELI001','1480000','2026-08-30','2.030','1','kasir','2026-08-30 14:22:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020067','X-00020067');
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-260830-0010','F324020137012','SIN','1','BELI','BELI001','F3E', 'X-00020067', 'GL RANTAI HOLLOW P3 SLEP KH 8K','2.030','2.030','100.00','1120000','1480000','729064','1060000','1','1480000','1480000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.030',berat_beli_asli=berat_beli_asli+'2.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.030',berat_akhir_asli=berat_akhir_asli+'2.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260830-0010','2026-08-30','2026-08-30','14:22:38','SIN','---','2.030','1480000','1480000','1480000','1480000','1480000','kasir','2026-08-30 14:22:38','FB-260830-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260830-0010','YENNI','JOHO PURWANTORO','','','','kasir','2026-08-30 14:22:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-30' 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-260830-0031','K','2026-08-30','14:22:38','kasir','PEMBELIAN UMUM','FB-260830-0010','7103368000','1480000','7101888000');
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-00020068','X-00020068','GL SANTA SERUT MODEL DAUN PM 8K','GR','---','F3E','BELI','BELI001','1960000','2026-08-30','2.010','1','kasir','2026-08-30 14:22:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020068','X-00020068');
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-260830-0011','F326260827201','SIN','2','BELI','BELI001','F3E', 'X-00020068', 'GL SANTA SERUT MODEL DAUN PM 8K','2.010','2.010','100.00','2270000','1960000','975124','1060000','1','1960000','1960000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.010',berat_beli_asli=berat_beli_asli+'2.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.010',berat_akhir_asli=berat_akhir_asli+'2.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260830-0011','2026-08-30','2026-08-30','14:22:38','SIN','---','2.010','1960000','1960000','1960000','1960000','1960000','kasir','2026-08-30 14:22:38','FB-260830-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260830-0011','YENI','JOHO','','','','kasir','2026-08-30 14:22:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-30' 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-260830-0032','K','2026-08-30','14:22:38','kasir','PEMBELIAN UMUM','FB-260830-0011','7101888000','1960000','7099928000');
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 ('F326300226561','kasir','1',' MEE1 KH 10','TOKO','PM-E','E1E-ZHXF-338-0','CC MODEL SPIRAL ARESO SLEP KH 10 8K ','','0.410','1','100.00','430000','0','0','15000','430000','0','0','0','430000','LIS','00417396','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHXF-338-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='E1E-ZHXF-338-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 ('F326300226561','2026-08-30','0.410','2026-08-30','14:26:56','PLG0031064','430000','430000','0','430000','430000','kasir','2026-08-30 14:26:56','F32630022656');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326300226561','2026-08-30','14:26:56','LIS','430000','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-260830-0033','D','2026-08-30','14:26:56','kasir','PENJUALAN','F326300226561','7099928000','430000','7100358000');
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-00020069','X-00020069','GL LEMES 8K','GR','---','F3E','BELI','BELI001','4070000','2026-08-30','5.110','1','kasir','2026-08-30 14:43:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020069','X-00020069');
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-260830-0012','00363733','SIN','1','BELI','BELI001','F3E', 'X-00020069', 'GL LEMES 8K','5.110','5.110','100.00','4330000','4070000','796477','1060000','1','4070000','4070000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.110',berat_beli_asli=berat_beli_asli+'5.110',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.110',berat_akhir_asli=berat_akhir_asli+'5.110',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260830-0012','2026-08-30','2026-08-30','14:43:37','SIN','---','5.110','4070000','4070000','4070000','4070000','4070000','kasir','2026-08-30 14:43:38','FB-260830-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260830-0012','CRISTIN','PO','','','','kasir','2026-08-30 14:43:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-30' 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-260830-0034','K','2026-08-30','14:43:37','kasir','PEMBELIAN UMUM','FB-260830-0012','7100358000','4070000','7096288000');
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-00020070','X-00020070','GL LEMES 8K','GR','---','F3E','BELI','BELI001','6685000','2026-08-30','8.240','1','kasir','2026-08-30 14:43:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020070','X-00020070');
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-260830-0013','00366601','SIN','2','BELI','BELI001','F3E', 'X-00020070', 'GL LEMES 8K','8.240','8.240','100.00','7268000','6685000','811286','1060000','1','6685000','6685000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'8.240',berat_beli_asli=berat_beli_asli+'8.240',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'8.240',berat_akhir_asli=berat_akhir_asli+'8.240',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260830-0013','2026-08-30','2026-08-30','14:43:37','SIN','---','8.240','6685000','6685000','6685000','6685000','6685000','kasir','2026-08-30 14:43:38','FB-260830-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260830-0013','JUNA','PURBOSUMAN','','','','kasir','2026-08-30 14:43:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-30' 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-260830-0035','K','2026-08-30','14:43:37','kasir','PEMBELIAN UMUM','FB-260830-0013','7096288000','6685000','7089603000');
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 ('F326300254291','kasir','1',' MEH1E UB 4','TOKO','PM-H','H1E-ZHBA-235-0','KL SANTA BOLA ARESO VAR SLEP UB 42 8K ','','2.550','1','100.00','2677000','0','0','15000','2678000','0','0','0','2678000','LIS','00419814','H1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHBA-235-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.550',berat_jual_asli=berat_jual_asli+'2.550',stock_jual='1',berat_akhir=berat_akhir-'2.550',berat_akhir_asli=berat_akhir_asli-'2.550',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='H1E-ZHBA-235-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 ('F326300254291','2026-08-30','2.550','2026-08-30','14:54:29','PLG0031065','2678000','2678000','0','2678000','2678000','kasir','2026-08-30 14:54:29','F32630025429');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326300254291','2026-08-30','14:54:29','LIS','2678000','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-260830-0036','D','2026-08-30','14:54:29','kasir','PENJUALAN','F326300254291','7089603000','2678000','7092281000');
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 ('F326300301301','kasir','1',' MEH1 15K U','TOKO','PM-H','H1E-YLXC-3-0','KL SANTA ANAK BONEKA CAT VAR UB 34 8K ','','2.570','1','100.00','2698000','0','0','15000','2698000','0','15000','0','2713000','SIN','00379319','H1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLXC-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.570',berat_jual_asli=berat_jual_asli+'2.570',stock_jual='1',berat_akhir=berat_akhir-'2.570',berat_akhir_asli=berat_akhir_asli-'2.570',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='H1E-YLXC-3-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 ('F326300301301','2026-08-30','2.570','2026-08-30','15:01:30','PLG0031066','2698000','2698000','15000','2713000','2713000','kasir','2026-08-30 15:01:30','F32630030130');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326300301301','2026-08-30','15:01:30','SIN','2713000','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-260830-0037','D','2026-08-30','15:01:30','kasir','PENJUALAN','F326300301301','7092281000','2713000','7094994000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2713000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326300301301' 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 ('F326300301302','kasir',' 1',' MEF1E PM 3','TOKO','PM-F','F1E-ZHBE-328-0','GL ANAK BANGKOK KACA SLEP PM 38 8K ','','1.580','1','100.00','1659000','0','0','15000','1659000','0','0','0','1659000','SIN','00420370','F1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZHBE-328-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.580',berat_jual_asli=berat_jual_asli+'1.580',stock_jual='1',berat_akhir=berat_akhir-'1.580',berat_akhir_asli=berat_akhir_asli-'1.580',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='F1E-ZHBE-328-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 ('F326300301302','2026-08-30','1.580','2026-08-30','15:01:30','PLG0031067','1659000','1659000','0','1659000','1659000','kasir','2026-08-30 15:01:30','F32630030130');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326300301302','2026-08-30','15:01:30','SIN','1659000','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-260830-0038','D','2026-08-30','15:01:30','kasir','PENJUALAN','F326300301302','7094994000','1659000','7096653000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1659000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326300301302' 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 ('F326300302141','kasir','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZDBX-290-0','CC X MODEL MATA CM 18 8K ','','1.190','1','100.00','1226000','0','0','15000','1225000','0','0','0','1225000','AAT','00400227','E2D','0','0','-','1','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDBX-290-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.190',berat_jual_asli=berat_jual_asli+'1.190',stock_jual='1',berat_akhir=berat_akhir-'1.190',berat_akhir_asli=berat_akhir_asli-'1.190',stock_akhir='0' WHERE tanggal='2026-08-30' AND kode_barang='E2D-ZDBX-290-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 ('F326300302141','2026-08-30','1.190','2026-08-30','15:02:15','PLG0031068','1225000','1225000','0','1225000','1225000','kasir','2026-08-30 15:02:14','F32630030214');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-30','F326300302141','2026-08-30','15:02:15','AAT','1225000','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-260830-0039','D','2026-08-30','15:02:15','kasir','PENJUALAN','F326300302141','7096653000','1225000','7097878000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260830-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260830-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260830-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260830-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260830-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260830-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260830-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260830-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260830-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260830-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260830-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260830-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260830-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260830-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260830-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260830-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260830-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260830-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260830-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260830-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260830-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260830-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260830-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260830-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260830-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260830-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326300112031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326300112031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326300112031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326300142442' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326300142442' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326300142442';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326300148181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326300148181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326300148181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326300218461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326300218461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326300218461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326300218462' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326300218462' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326300218462';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326300226561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326300226561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326300226561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326300254291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326300254291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326300254291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326300301301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326300301301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326300301301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326300301302' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326300301302' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326300301302';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326300302141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326300302141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326300302141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326301023481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326301023481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326301023481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326301112231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326301112231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326301112231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326301210021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326301210021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326301210021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326301210022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326301210022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326301210022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326301210023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326301210023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326301210023';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326301210024' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326301210024' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326301210024';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326301239401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326301239401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326301239401';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-31','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-31';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-30';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-30';
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-08-30' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-30';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-30';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-30';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-30';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-08-31' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-30' 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-260831-0001','D','2026-08-31','15:22:10','SYSTEM','SALDO AWAL','SALDO AWAL','0','7097878000','7097878000');
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-260831-0001','D','2026-08-31','15:22:10','BCA','SALDO AWAL','SALDO AWAL','0','740659000','740659000');
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-260831-0001','D','2026-08-31','15:22:10','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-260831-0001','D','2026-08-31','15:22:10','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-08-31';