INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-07-12 ','08:29:51');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-12','133','0','-129350000','133','0','-129350000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-11';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-11';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-11';
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-07-11' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-11';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-11';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-11';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-11';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-12' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-11' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
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-260712-0001','D','2026-07-12','08:30:05','','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-260712-0001','D','2026-07-12','08:30:05','BCA','SALDO AWAL','SALDO AWAL','0','1851467755','1851467755');
UPDATE tp_system SET tgl_system='2026-07-12';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-07-12 ','08:30:29');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-07-12 ','08:52:21');
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,potong_rp) VALUES ('FJ-260712-0001','sales','1',' JD ','TOKO','BTATMT','MTAT-YDCX-56-0','AT JODHA BT BTR SHB ','JODHA','2.100','1','100.00','3843000','0','0','0','3948000','105000','0','0','3948000','2502','00024545','MTAT','220000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-YDCX-56-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-07-12' AND kode_barang='MTAT-YDCX-56-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMT' 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 ('FJ-260712-0001','2026-07-12','2.100','2026-07-12','10:07:08','PLG0019148','3948000','3948000','0','3948000','1900000','sales','2026-07-12 10:07:07','FJ-260712-0001');
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-07-12','FJ-260712-0001','2026-07-12','10:07:08','2502','3948000','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-260712-0002','D','2026-07-12','10:07:08','sales','PENJUALAN','FJ-260712-0001','129608150','1900000','131508150','OPEN');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260712-0001','2026-07-12','2026-07-12 10:07:07','PENJUALAN : FJ-260712-0001','bri','BCA','2048000','2048000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260712-0002','D','2026-07-12','10:07:08','BCA','PENJUALAN','FJ-260712-0001','1851467755','2048000','1853515755','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bri','ACHMAD');
UPDATE tt_jual_head SET dibayar_rp='1900000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2048000' WHERE no_faktur_jual='FJ-260712-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260712-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260712-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260712-0001';
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-00009637','X-00009637','AT ITALY BT SHB','GR','---','MDAT','BELI','BELI001','1054500','2026-07-12','1.110','1','sales','2026-07-12 10:46:57');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDAT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDAT','X-00009637','X-00009637');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260712-0001','FJ-260607-0006','2106','1','BELI','BELI001','MDAT', 'X-00009637', 'AT ITALY BT SHB','1.110','1.110','100.00','1276500','1054500','950000','1','1054500','1054500','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-07-12','BELI','BELI001','MDAT','MDAT','100.00','1.110','1.110','1','1.110','1.110','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,status_valid) VALUES ('FB-260712-0001','2026-07-12','2026-07-12','10:46:56','2106','---','1.110','1054500','1054500','1054500','1054500','1054500','sales','2026-07-12 10:46:57','FB-260712-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260712-0001','ROHMA','TANJUNG KARANG BARU 32','','SBY','','sales','2026-07-12 10:46:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-12' 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,status_valid) VALUES ('KK-260712-0003','K','2026-07-12','10:46:56','sales','PEMBELIAN UMUM','FB-260712-0001','131508150','1054500','130453650','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260712-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260712-0001';
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-00009638','X-00009638','GW COR TDK BT SHB','GR','---','MTGW','BELI','BELI001','2508000','2026-07-12','1.730','1','sales','2026-07-12 12:17:09');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTGW';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTGW','X-00009638','X-00009638');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260712-0002','FJ-240914-0002','2502','1','BELI','BELI001','MTGW', 'X-00009638', 'GW COR TDK BT SHB','1.780','1.730','100.00','1735500','2508000','1449711','1','2508000','2508000','RONGSOK');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-07-12','BELI','BELI001','MTGW','MTGW','100.00','1.730','1.730','1','1.730','1.730','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,status_valid) VALUES ('FB-260712-0002','2026-07-12','2026-07-12','12:17:09','2502','---','1.730','2508000','2508000','2508000','2508000','2508000','sales','2026-07-12 12:17:09','FB-260712-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260712-0002','BU ITO','BLK JAYA 4/57','','','087819340122','sales','2026-07-12 12:17:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-12' 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,status_valid) VALUES ('KK-260712-0004','K','2026-07-12','12:17:09','sales','PEMBELIAN UMUM','FB-260712-0002','130453650','2508000','127945650','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260712-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260712-0002';
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,potong_rp) VALUES ('FJ-260712-0002','sales','1',' EX ','TOKO','BTGLMT','MTGL-ZFXB-100-0','GL COR CAT 18CM KKT S YT ','','13.330','1','100.00','24394000','0','0','0','24394000','0','0','0','24394000','2403','00029891','MTGL','220000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGL-ZFXB-100-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'13.330',berat_jual_asli=berat_jual_asli+'13.330',stock_jual='1',berat_akhir=berat_akhir-'13.330',berat_akhir_asli=berat_akhir_asli-'13.330',stock_akhir='0' WHERE tanggal='2026-07-12' AND kode_barang='MTGL-ZFXB-100-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMT' 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 ('FJ-260712-0002','2026-07-12','13.330','2026-07-12','12:20:24','PLG0019149','24394000','24394000','0','24394000','0','sales','2026-07-12 12:20:23','FJ-260712-0002');
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-07-12','FJ-260712-0002','2026-07-12','12:20:24','2403','24394000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260712-0002','2026-07-12','2026-07-12 12:20:23','PENJUALAN : FJ-260712-0002','bca','BCA','24394000','24394000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260712-0003','D','2026-07-12','12:20:24','BCA','PENJUALAN','FJ-260712-0002','1853515755','24394000','1877909755','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','SUAIDI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='24394000' WHERE no_faktur_jual='FJ-260712-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260712-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260712-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260712-0002';
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,potong_rp) VALUES ('FJ-260712-0003','sales','1',' ','TOKO','BTGLMD','MDGL-ZBAH-76-0','GL PIPA ANK BT LC2 ','','2.060','1','100.00','2276500','0','0','0','2276500','0','0','0','2276500','2402','00028319','MDGL','155000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZBAH-76-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-07-12' AND kode_barang='MDGL-ZBAH-76-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' 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 ('FJ-260712-0003','2026-07-12','2.060','2026-07-12','12:30:28','PLG0019150','2276500','2276500','0','2276500','0','sales','2026-07-12 12:30:27','FJ-260712-0003');
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-07-12','FJ-260712-0003','2026-07-12','12:30:28','2402','2276500','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260712-0003','2026-07-12','2026-07-12 12:30:27','PENJUALAN : FJ-260712-0003','mandiri','BCA','2276500','2276500','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260712-0004','D','2026-07-12','12:30:28','BCA','PENJUALAN','FJ-260712-0003','1877909755','2276500','1880186255','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('mandiri','SOFIYUDDIN');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2276500' WHERE no_faktur_jual='FJ-260712-0003' 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-00009639','X-00009639','GW COR TDK BT LC2','GR','---','MDGW','BELI','BELI001','627000','2026-07-12','0.660','1','sales','2026-07-12 12:32:15');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDGW';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDGW','X-00009639','X-00009639');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260712-0003','FJ-260630-0002','2502','1','BELI','BELI001','MDGW', 'X-00009639', 'GW COR TDK BT LC2','0.660','0.660','100.00','736000','627000','950000','1','627000','627000','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-07-12','BELI','BELI001','MDGW','MDGW','100.00','0.660','0.660','1','0.660','0.660','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,status_valid) VALUES ('FB-260712-0003','2026-07-12','2026-07-12','12:32:14','2502','---','0.660','627000','627000','627000','627000','627000','sales','2026-07-12 12:32:15','FB-260712-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260712-0003','MARHATI','SIDODADI 1','','','','sales','2026-07-12 12:32:15');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-12' 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,status_valid) VALUES ('KK-260712-0005','K','2026-07-12','12:32:14','sales','PEMBELIAN UMUM','FB-260712-0003','127945650','627000','127318650','OPEN');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260712-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260712-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260712-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260712-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260712-0003';
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,potong_rp) VALUES ('FJ-260712-0004','sales','1',' PM ','TOKO','BTKLMD','MDKL-ZBXI-14-0','KL ITALY ST VAR BT 42CM KKT PER UBS ','PM','2.170','1','100.00','2398000','0','0','0','2507000','109000','0','0','2507000','2401','00027828','MDKL','155000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDKL-ZBXI-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.170',berat_jual_asli=berat_jual_asli+'2.170',stock_jual='1',berat_akhir=berat_akhir-'2.170',berat_akhir_asli=berat_akhir_asli-'2.170',stock_akhir='0' WHERE tanggal='2026-07-12' AND kode_barang='MDKL-ZBXI-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMD' 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 ('FJ-260712-0004','2026-07-12','2.170','2026-07-12','12:36:39','PLG0019151','2507000','2507000','0','2507000','2507000','sales','2026-07-12 12:36:39','FJ-260712-0004');
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-07-12','FJ-260712-0004','2026-07-12','12:36:39','2401','2507000','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-260712-0006','D','2026-07-12','12:36:39','sales','PENJUALAN','FJ-260712-0004','127318650','2507000','129825650');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260712-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260712-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260712-0004';
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-00009640','X-00009640','CN ANAK COR BT SHB','GR','---','MTCN','BELI','BELI001','1320000','2026-07-12','0.820','1','sales','2026-07-12 12:50:32');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00009640','X-00009640');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260712-0004','FJ-251225-0001','2106','1','BELI','BELI001','MTCN', 'X-00009640', 'CN ANAK COR BT SHB','0.820','0.820','100.00','1496500','1320000','1609756','1','1320000','1320000','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-07-12','BELI','BELI001','MTCN','MTCN','100.00','0.820','0.820','1','0.820','0.820','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,status_valid) VALUES ('FB-260712-0004','2026-07-12','2026-07-12','12:50:32','2106','---','0.820','1320000','1320000','1320000','1320000','1320000','sales','2026-07-12 12:50:32','FB-260712-0004','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260712-0004','AIDA','SAWAHPULO 27','','','082264302614','sales','2026-07-12 12:50:32');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-12' 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,status_valid) VALUES ('KK-260712-0007','K','2026-07-12','12:50:32','sales','PEMBELIAN UMUM','FB-260712-0004','129825650','1320000','128505650','OPEN');
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-00009641','X-00009641','KL ITALY ST BT BLT BTR 41CM KKT PER BLT SHB','GR','---','MTKL','BELI','BELI001','4060000','2026-07-12','2.800','1','sales','2026-07-12 12:50:32');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTKL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTKL','X-00009641','X-00009641');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260712-0005','FJ-211030-0001','2106','2','BELI','BELI001','MTKL', 'X-00009641', 'KL ITALY ST BT BLT BTR 41CM KKT PER BLT SHB','3.080','2.800','100.00','2048500','4060000','1450000','1','4060000','4060000','RONGSOK');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-07-12','BELI','BELI001','MTKL','MTKL','100.00','2.800','2.800','1','2.800','2.800','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,status_valid) VALUES ('FB-260712-0005','2026-07-12','2026-07-12','12:50:32','2106','---','2.800','4060000','4060000','4060000','4060000','4060000','sales','2026-07-12 12:50:32','FB-260712-0004','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260712-0005','SAROH','SAWAHPULO NO 27','','SBY','','sales','2026-07-12 12:50:32');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-12' 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,status_valid) VALUES ('KK-260712-0008','K','2026-07-12','12:50:32','sales','PEMBELIAN UMUM','FB-260712-0005','128505650','4060000','124445650','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260712-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260712-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260712-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260712-0005';