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 ('F325300747411','input','1',' MEH1 UB 34','TOKO','PM-H','H1E-YKBB-26-0','KL NORY ANAK UB 34 8K ','','1.010','1','100.00','1040000','0','0','15000','1040000','0','0','0','1040000','SIN','00378175','H1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YKBB-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='H1E-YKBB-26-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 ('F325300747411','2025-11-30','1.010','2025-11-30','07:47:42','PLG0025953','1040000','1040000','0','1040000','1040000','input','2025-11-30 07:47:41','F32530074741');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325300747411','2025-11-30','07:47:42','SIN','1040000','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-251130-0002','D','2025-11-30','07:47:42','input','PENJUALAN','F325300747411','926062000','1040000','927102000');
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 ('F325300748201','input','1',' MFD2F X LG','TOKO','PM-D','D2F-YFAD-278-0','LT X MODEL HURUF MATA LG M 8K ','','0.480','1','100.00','504000','0','0','15000','505000','0','0','0','505000','SIN','00357558','D2F','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2F-YFAD-278-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='D2F-YFAD-278-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 ('F325300748201','2025-11-30','0.480','2025-11-30','07:48:21','PLG0025954','505000','505000','0','505000','505000','input','2025-11-30 07:48:20','F32530074820');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325300748201','2025-11-30','07:48:21','SIN','505000','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-251130-0003','D','2025-11-30','07:48:21','input','PENJUALAN','F325300748201','927102000','505000','927607000');
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 ('F325300750001','input','1',' MFE2F X LG','TOKO','PM-E','E2F-XIAA-325-0','CC X BONEKA ANAK MT CAT LG 8K ','','0.470','1','100.00','493000','0','0','15000','495000','0','0','0','495000','FIT','00317082','E2F','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-XIAA-325-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='E2F-XIAA-325-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 ('F325300750001','2025-11-30','0.470','2025-11-30','07:50:00','PLG0025955','495000','495000','0','495000','495000','input','2025-11-30 07:50:00','F32530075000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325300750001','2025-11-30','07:50:00','FIT','495000','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-251130-0004','D','2025-11-30','07:50:00','input','PENJUALAN','F325300750001','927607000','495000','928102000');
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 ('F325300855051','input','1',' MGD1G X HW','TOKO','PM-D','D1G-YKAE-18-0','LT X SLOBOK CAT HITAM HW 8K ','','0.320','1','100.00','342000','0','0','15000','342000','0','0','0','342000','FIT','00377426','D1G','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YKAE-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='D1G-YKAE-18-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 ('F325300855051','2025-11-30','0.320','2025-11-30','08:55:06','PLG0025956','342000','342000','0','342000','342000','input','2025-11-30 08:55:05','F32530085505');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325300855051','2025-11-30','08:55:06','FIT','342000','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-251130-0005','D','2025-11-30','08:55:06','input','PENJUALAN','F325300855051','928102000','342000','928444000');
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 ('F325300855571','input','1',' MEH1 UB 34','TOKO','PM-H','H1E-YJBX-57-0','KL GUCCI ANAK UB 34 8K ','','1.070','1','100.00','1102000','0','0','15000','1103000','0','0','0','1103000','FIT','00373840','H1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJBX-57-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='H1E-YJBX-57-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 ('F325300855571','2025-11-30','1.070','2025-11-30','08:55:57','PLG0025957','1103000','1103000','0','1103000','1103000','input','2025-11-30 08:55:57','F32530085557');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325300855571','2025-11-30','08:55:57','FIT','1103000','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-251130-0006','D','2025-11-30','08:55:57','input','PENJUALAN','F325300855571','928444000','1103000','929547000');
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 ('F325300930191','input','1',' MDE2 YT 14','TOKO','PM-E','E2D-YCXE-124-0','CC MODEL MATA VAR YT 14 8K ','','0.850','1','100.00','858000','0','0','15000','860000','0','0','0','860000','SIN','00341929','E2D','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YCXE-124-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='E2D-YCXE-124-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 ('F325300930191','2025-11-30','0.850','2025-11-30','09:30:20','PLG0025958','860000','860000','0','860000','860000','input','2025-11-30 09:30:19','F32530093019');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325300930191','2025-11-30','09:30:20','SIN','860000','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-251130-0007','D','2025-11-30','09:30:20','input','PENJUALAN','F325300930191','929547000','860000','930407000');
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 ('F325300935271','input','1',' MDE1 CM 17','TOKO','PM-E','E1D-YIBB-130-0','CC MODEL SLEP VAR CM 17 8K ','','1.080','1','100.00','1091000','0','0','15000','1090000','0','0','0','1090000','FIT','00370178','E1D','0','0','-','1','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YIBB-130-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='E1D-YIBB-130-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 ('F325300935271','2025-11-30','1.080','2025-11-30','09:35:27','PLG0025959','1090000','1090000','0','1090000','1090000','input','2025-11-30 09:35:27','F32530093527');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325300935271','2025-11-30','09:35:27','FIT','1090000','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-251130-0008','D','2025-11-30','09:35:27','input','PENJUALAN','F325300935271','930407000','1090000','931497000');
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 ('F325300937371','input','1',' MDE2 CM 14','TOKO','PM-E','E2D-YKBH-101-0','CC MODEL DAUN MATA VAR CM 14 8K ','','1.070','1','100.00','1081000','0','0','15000','1081000','0','0','0','1081000','FIT','00378962','E2D','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YKBH-101-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='E2D-YKBH-101-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 ('F325300937371','2025-11-30','1.070','2025-11-30','09:37:38','PLG0025960','1081000','1081000','0','1081000','1081000','input','2025-11-30 09:37:37','F32530093737');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325300937371','2025-11-30','09:37:38','FIT','1081000','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-251130-0009','D','2025-11-30','09:37:38','input','PENJUALAN','F325300937371','931497000','1081000','932578000');
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 ('F325300939191','input','1',' MGD1G X HW','TOKO','PM-D','D1G-YFBH-26-0','LT X SLOBOK H CAT HITAM HW 8K ','','0.370','1','100.00','396000','0','0','15000','397000','0','5000','0','402000','FIT','00358734','D1G','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YFBH-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='D1G-YFBH-26-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 ('F325300939191','2025-11-30','0.370','2025-11-30','09:39:20','PLG0025961','397000','397000','5000','402000','402000','input','2025-11-30 09:39:19','F32530093919');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325300939191','2025-11-30','09:39:20','FIT','402000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251130-0010','D','2025-11-30','09:39:20','input','PENJUALAN','F325300939191','932578000','402000','932980000');
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 ('F325300939561','input','1',' MFA1 UB ','TOKO','PM-A','A1F-YGXB-157-0','AT HUGGIES KLIP HATI ARESO VAR UB 8K ','','1.000','1','100.00','1050000','0','0','15000','1050000','0','0','0','1050000','FIT','00359242','A1F','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YGXB-157-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='2025-11-30' AND kode_barang='A1F-YGXB-157-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325300939561','2025-11-30','1.000','2025-11-30','09:39:57','PLG0025962','1050000','1050000','0','1050000','1050000','input','2025-11-30 09:39:56','F32530093956');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325300939561','2025-11-30','09:39:57','FIT','1050000','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-251130-0011','D','2025-11-30','09:39:57','input','PENJUALAN','F325300939561','932980000','1050000','934030000');
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 ('F325300957591','input','1',' MEB1E X LG','TOKO','PM-B','B1E-YJBA-104-0','GW X MODEL RIBBON CAT HITAM LG PE 8K ','','0.520','1','100.00','536000','0','0','15000','535000','0','0','0','535000','SIN','00373981','B1E','0','0','-','1','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJBA-104-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='B1E-YJBA-104-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325300957591','2025-11-30','0.520','2025-11-30','09:57:59','PLG0025963','535000','535000','0','535000','535000','input','2025-11-30 09:57:59','F32530095759');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325300957591','2025-11-30','09:57:59','SIN','535000','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-251130-0012','D','2025-11-30','09:57:59','input','PENJUALAN','F325300957591','934030000','535000','934565000');
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 ('F325301041191','kasir','1',' MEA1 UB ','TOKO','PM-A','A1E-YKXC-481-0','AT MODEL ITALY PANJANG VAR UB 8K ','','0.850','1','100.00','875000','0','0','15000','875000','0','0','0','875000','FIT','00376411','A1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YKXC-481-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='A1E-YKXC-481-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325301041191','2025-11-30','0.850','2025-11-30','10:41:20','PLG0025964','875000','875000','0','875000','875000','kasir','2025-11-30 10:41:19','F32530104119');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325301041191','2025-11-30','10:41:20','FIT','875000','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-251130-0013','D','2025-11-30','10:41:20','kasir','PENJUALAN','F325301041191','934565000','875000','935440000');
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 ('F325301041471','kasir','1',' MEA1 BW ','TOKO','PM-A','A1E-YKAI-194-0','AT MODEL ITALY PANJANG VAR BW 8K ','','0.530','1','100.00','546000','0','0','15000','545000','0','0','0','545000','FIT','00378115','A1E','0','0','-','1','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YKAI-194-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='A1E-YKAI-194-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325301041471','2025-11-30','0.530','2025-11-30','10:41:48','PLG0025965','545000','545000','0','545000','545000','kasir','2025-11-30 10:41:47','F32530104147');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325301041471','2025-11-30','10:41:48','FIT','545000','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-251130-0014','D','2025-11-30','10:41:48','kasir','PENJUALAN','F325301041471','935440000','545000','935985000');
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 ('F325301045391','kasir','1',' MDA1D X CM','TOKO','PM-A','A1D-YDAH-111-0','AT X HUGGIES MATA VAR CM 8K ','','1.590','1','100.00','1606000','0','0','15000','1605000','0','0','0','1605000','SIN','00349735','A1D','0','0','-','1','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YDAH-111-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.590',berat_jual_asli=berat_jual_asli+'1.590',stock_jual='1',berat_akhir=berat_akhir-'1.590',berat_akhir_asli=berat_akhir_asli-'1.590',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='A1D-YDAH-111-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325301045391','2025-11-30','1.590','2025-11-30','10:45:40','PLG0025966','1605000','1605000','0','1605000','1605000','kasir','2025-11-30 10:45:39','F32530104539');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325301045391','2025-11-30','10:45:40','SIN','1605000','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-251130-0015','D','2025-11-30','10:45:40','kasir','PENJUALAN','F325301045391','935985000','1605000','937590000');
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 ('F325301046211','kasir','1',' MDE1 CM 24','TOKO','PM-E','E1D-YKAG-85-T','CC MODEL DAUN VAR CM 24 8K ','','1.230','1','100.00','1242000','0','0','15000','1243000','0','0','0','1243000','SIN','T0075088','E1D','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YKAG-85-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.230',berat_jual_asli=berat_jual_asli+'1.230',stock_jual='1',berat_akhir=berat_akhir-'1.230',berat_akhir_asli=berat_akhir_asli-'1.230',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='E1D-YKAG-85-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325301046211','2025-11-30','1.230','2025-11-30','10:46:22','PLG0025967','1243000','1243000','0','1243000','1243000','kasir','2025-11-30 10:46:21','F32530104621');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325301046211','2025-11-30','10:46:22','SIN','1243000','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-251130-0016','D','2025-11-30','10:46:22','kasir','PENJUALAN','F325301046211','937590000','1243000','938833000');
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 ('F325301111531','kasir','1',' MEH1 KH 35','TOKO','PM-H','H1E-YBXE-93-0','KL ANAK SANTA KH 35CM 8K ','','4.100','1','100.00','4223000','0','0','15000','4223000','0','0','0','4223000','FIT','00337735','H1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YBXE-93-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.100',berat_jual_asli=berat_jual_asli+'4.100',stock_jual='1',berat_akhir=berat_akhir-'4.100',berat_akhir_asli=berat_akhir_asli-'4.100',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='H1E-YBXE-93-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 ('F325301111531','2025-11-30','4.100','2025-11-30','11:11:54','PLG0025968','4223000','4223000','0','4223000','4223000','kasir','2025-11-30 11:11:53','F32530111153');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325301111531','2025-11-30','11:11:54','FIT','4223000','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-251130-0017','D','2025-11-30','11:11:54','kasir','PENJUALAN','F325301111531','938833000','4223000','943056000');
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 ('F325301155041','kasir','1',' MEE2 X NJ ','TOKO','PM-E','E2E-YKAA-295-0','CC X MODEL MATA HITAM NJ 16 8K ','','0.680','1','100.00','700000','0','0','15000','700000','0','0','0','700000','FIT','00377261','E2E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YKAA-295-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='E2E-YKAA-295-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 ('F325301155041','2025-11-30','0.680','2025-11-30','11:55:05','PLG0025969','700000','700000','0','700000','700000','kasir','2025-11-30 11:55:04','F32530115504');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325301155041','2025-11-30','11:55:05','FIT','700000','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-251130-0018','D','2025-11-30','11:55:05','kasir','PENJUALAN','F325301155041','943056000','700000','943756000');
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 ('F325301155301','kasir','1',' MDE1 CM 12','TOKO','PM-E','E1D-YKBB-41-0','CC MODEL DAUN SLEP CM 12 8K ','','0.830','1','100.00','838000','0','0','15000','838000','0','0','0','838000','FIT','00378190','E1D','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YKBB-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='E1D-YKBB-41-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 ('F325301155301','2025-11-30','0.830','2025-11-30','11:55:31','PLG0025970','838000','838000','0','838000','838000','kasir','2025-11-30 11:55:30','F32530115530');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325301155301','2025-11-30','11:55:31','FIT','838000','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-251130-0019','D','2025-11-30','11:55:31','kasir','PENJUALAN','F325301155301','943756000','838000','944594000');
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 ('F325301209221','kasir','1',' MEF3 LG ','TOKO','PM-F','F3E-YKAI-182-0','GL MODEL DAUN SLEP VAR LG 8K ','','4.710','1','100.00','4851000','0','0','15000','4850000','0','0','0','4850000','SIN','00378103','F3E','0','0','-','1','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKAI-182-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.710',berat_jual_asli=berat_jual_asli+'4.710',stock_jual='1',berat_akhir=berat_akhir-'4.710',berat_akhir_asli=berat_akhir_asli-'4.710',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='F3E-YKAI-182-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 ('F325301209221','2025-11-30','4.710','2025-11-30','12:09:22','PLG0025971','4850000','4850000','0','4850000','4850000','kasir','2025-11-30 12:09:22','F32530120922');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325301209221','2025-11-30','12:09:22','SIN','4850000','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-251130-0020','D','2025-11-30','12:09:22','kasir','PENJUALAN','F325301209221','944594000','4850000','949444000');
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 ('F325300101301','kasir','1',' MDA1D X LG','TOKO','PM-A','A1D-YHAI-19-0','AT X MODEL KLIP MATA LG 8K ','','0.980','1','100.00','990000','0','0','15000','990000','0','0','0','990000','SIN','00366050','A1D','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YHAI-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='A1D-YHAI-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325300101301','2025-11-30','0.980','2025-11-30','13:01:30','PLG0025972','990000','990000','0','990000','990000','kasir','2025-11-30 13:01:30','F32530010130');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325300101301','2025-11-30','13:01:30','SIN','990000','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-251130-0021','D','2025-11-30','13:01:30','kasir','PENJUALAN','F325300101301','949444000','990000','950434000');
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 ('F325300101521','kasir','1',' MDE1 CM 16','TOKO','PM-E','E1D-YKAG-87-T','CC MODEL DAUN VAR CM 16 8K','','1.300','1','100.00','1313000','0','0','15000','1313000','0','0','0','1313000','SIN','T0075090','E1D','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YKAG-87-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.300',berat_jual_asli=berat_jual_asli+'1.300',stock_jual='1',berat_akhir=berat_akhir-'1.300',berat_akhir_asli=berat_akhir_asli-'1.300',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='E1D-YKAG-87-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325300101521','2025-11-30','1.300','2025-11-30','13:01:52','PLG0025973','1313000','1313000','0','1313000','1313000','kasir','2025-11-30 13:01:52','F32530010152');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325300101521','2025-11-30','13:01:52','SIN','1313000','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-251130-0022','D','2025-11-30','13:01:52','kasir','PENJUALAN','F325300101521','950434000','1313000','951747000');
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 ('F325300151161','kasir','1',' MFB1 5K LG','TOKO','PM-B','B1F-YKAI-187-0','GW MODEL TOGE BONEKA CAT VAR LG 8K ','','0.550','1','100.00','577000','0','0','15000','578000','0','5000','0','583000','SIN','00378108','B1F','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YKAI-187-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='B1F-YKAI-187-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325300151161','2025-11-30','0.550','2025-11-30','13:51:17','PLG0025974','578000','578000','5000','583000','583000','kasir','2025-11-30 13:51:16','F32530015116');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325300151161','2025-11-30','13:51:17','SIN','583000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251130-0023','D','2025-11-30','13:51:17','kasir','PENJUALAN','F325300151161','951747000','583000','952330000');
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-00017568','X-00017568','GL COR M 8K','GR','---','F2E','BELI','BELI001','2070000','2025-11-30','3.000','1','kasir','2025-11-30 14:00:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00017568','X-00017568');
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-251130-0001','F323220834331','AAT','1','BELI','BELI001','F2E', 'X-00017568', 'GL COR M 8K','3.000','3.000','100.00','1360000','2070000','690000','1040000','1','2070000','2070000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.000',berat_beli_asli=berat_beli_asli+'3.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.000',berat_akhir_asli=berat_akhir_asli+'3.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-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-251130-0001','2025-11-30','2025-11-30','14:00:30','AAT','---','3.000','2070000','2070000','2070000','2070000','2070000','kasir','2025-11-30 14:00:31','FB-251130-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251130-0001','SAMIYEM','MIRI KISMANTORO','','','','kasir','2025-11-30 14:00:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251130-0024','K','2025-11-30','14:00:30','kasir','PEMBELIAN UMUM','FB-251130-0001','952330000','2070000','950260000');
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-00017569','X-00017569','CC COR T 8K','GR','---','E1E','BELI','BELI001','760000','2025-11-30','1.130','1','kasir','2025-11-30 14:02:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00017569','X-00017569');
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-251130-0002','F323211051251','AAT','1','BELI','BELI001','E1E', 'X-00017569', 'CC COR T 8K','1.130','1.130','100.00','527000','760000','672566','1040000','1','760000','760000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.130',berat_beli_asli=berat_beli_asli+'1.130',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.130',berat_akhir_asli=berat_akhir_asli+'1.130',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-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-251130-0002','2025-11-30','2025-11-30','14:02:27','AAT','---','1.130','760000','760000','760000','760000','760000','kasir','2025-11-30 14:02:28','FB-251130-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251130-0002','SAMIYEM','KISMANTORO','','','','kasir','2025-11-30 14:02:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251130-0025','K','2025-11-30','14:02:27','kasir','PEMBELIAN UMUM','FB-251130-0002','950260000','760000','949500000');
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 ('F325300209071','kasir','1',' MEH1 HW 34','TOKO','PM-H','H1E-YKBI-175-0','KL SANTA ANAK HW 34CM 8K ','','0.970','1','100.00','1009000','0','0','15000','1010000','0','0','0','1010000','AAT','00379141','H1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YKBI-175-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='H1E-YKBI-175-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 ('F325300209071','2025-11-30','0.970','2025-11-30','14:09:08','PLG0025975','1010000','1010000','0','1010000','1010000','kasir','2025-11-30 14:09:07','F32530020907');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325300209071','2025-11-30','14:09:08','AAT','1010000','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-251130-0026','D','2025-11-30','14:09:08','kasir','PENJUALAN','F325300209071','949500000','1010000','950510000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325300209071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325300209071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325300209071';
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 ('F325300214251','kasir','1',' MEH1 HW 34','TOKO','PM-H','H1E-YKBI-175-0','KL SANTA ANAK HW 34CM 8K ','','0.970','1','100.00','1009000','0','0','15000','1000000','0','0','0','1000000','AAT','00379141','H1E','0','0','-','1','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YKBI-175-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='H1E-YKBI-175-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 ('F325300214251','2025-11-30','0.970','2025-11-30','14:14:26','PLG0025976','1000000','1000000','0','1000000','1000000','kasir','2025-11-30 14:14:25','F32530021425');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325300214251','2025-11-30','14:14:26','AAT','1000000','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-251130-0028','D','2025-11-30','14:14:26','kasir','PENJUALAN','F325300214251','949500000','1000000','950500000');
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-00017570','X-00017570','GL X TIFF ANAK SLEP UB 8K','GR','---','F3E','BELI','BELI001','802000','2025-11-30','0.950','1','kasir','2025-11-30 14:22:27');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017570','X-00017570');
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-251130-0003','F325221041422','FIT','1','BELI','BELI001','F3E', 'X-00017570', 'GL X TIFF ANAK SLEP UB 8K','0.950','0.950','100.00','854000','802000','844211','1040000','1','802000','802000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.950',berat_beli_asli=berat_beli_asli+'0.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.950',berat_akhir_asli=berat_akhir_asli+'0.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-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-251130-0003','2025-11-30','2025-11-30','14:22:26','FIT','---','0.950','802000','802000','802000','802000','802000','kasir','2025-11-30 14:22:27','FB-251130-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251130-0003','DINAR','BULUKERTO','','','','kasir','2025-11-30 14:22:27');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251130-0029','K','2025-11-30','14:22:26','kasir','PEMBELIAN UMUM','FB-251130-0003','950500000','802000','949698000');
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-00017571','X-00017571','KL ANAK NORY UB 36CM 8K','GR','---','H1E','BELI','BELI001','730000','2025-11-30','1.050','1','kasir','2025-11-30 14:24:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00017571','X-00017571');
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-251130-0004','F325050158071','FIT','1','BELI','BELI001','H1E', 'X-00017571', 'KL ANAK NORY UB 36CM 8K','1.050','1.050','100.00','840000','730000','695238','1040000','1','730000','730000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251130-0004','2025-11-30','2025-11-30','14:24:42','FIT','---','1.050','730000','730000','730000','730000','730000','kasir','2025-11-30 14:24:43','FB-251130-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251130-0004','ZOLLA','BULUKERTO','','','','kasir','2025-11-30 14:24:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251130-0030','K','2025-11-30','14:24:42','kasir','PEMBELIAN UMUM','FB-251130-0004','949698000','730000','948968000');
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-00017572','X-00017572','KL X KOREA SLEP KH 44 9K','GR','---','H2I','BELI','BELI001','2005000','2025-11-30','2.000','1','kasir','2025-11-30 14:25:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00017572','X-00017572');
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-251130-0005','F325101248061','FIT','1','BELI','BELI001','H2I', 'X-00017572', 'KL X KOREA SLEP KH 44 9K','2.000','2.000','100.00','2160000','2005000','1002500','1120000','1','2005000','2005000','CUCI');
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 ='2025-11-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2I' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251130-0005','2025-11-30','2025-11-30','14:25:01','FIT','---','2.000','2005000','2005000','2005000','2005000','2005000','kasir','2025-11-30 14:25:02','FB-251130-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251130-0005','RIO','SAMPUNG','','','','kasir','2025-11-30 14:25:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251130-0031','K','2025-11-30','14:25:01','kasir','PEMBELIAN UMUM','FB-251130-0005','948968000','2005000','946963000');
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-00017573','X-00017573','CC X SOLITAIRE MATA CM 16 8K','GR','---','E2D','BELI','BELI001','800000','2025-11-30','1.100','1','kasir','2025-11-30 14:25:26');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017573','X-00017573');
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-251130-0006','F325241010002','FIT','1','BELI','BELI001','E2D', 'X-00017573', 'CC X SOLITAIRE MATA CM 16 8K','1.210','1.100','100.00','986000','800000','727273','1020000','1','800000','800000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.100',berat_beli_asli=berat_beli_asli+'1.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.100',berat_akhir_asli=berat_akhir_asli+'1.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-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-251130-0006','2025-11-30','2025-11-30','14:25:26','FIT','---','1.100','800000','800000','800000','800000','800000','kasir','2025-11-30 14:25:26','FB-251130-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251130-0006','INTAN ALYSTIANA','JERUK BANDAR','','','0838456006857','kasir','2025-11-30 14:25:26');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251130-0032','K','2025-11-30','14:25:26','kasir','PEMBELIAN UMUM','FB-251130-0006','946963000','800000','946163000');
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-00017574','X-00017574','LT COR M 8K','GR','---','D2E','BELI','BELI001','650000','2025-11-30','1.130','1','kasir','2025-11-30 14:26:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00017574','X-00017574');
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-251130-0007','F323171152352','AAT','1','BELI','BELI001','D2E', 'X-00017574', 'LT COR M 8K','1.130','1.130','100.00','507000','650000','575221','1040000','1','650000','650000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.130',berat_beli_asli=berat_beli_asli+'1.130',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.130',berat_akhir_asli=berat_akhir_asli+'1.130',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251130-0007','2025-11-30','2025-11-30','14:26:50','AAT','---','1.130','650000','650000','650000','650000','650000','kasir','2025-11-30 14:26:51','FB-251130-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251130-0007','JIHAN','PURWANTORO','','','','kasir','2025-11-30 14:26:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251130-0033','K','2025-11-30','14:26:50','kasir','PEMBELIAN UMUM','FB-251130-0007','946163000','650000','945513000');
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-00017575','X-00017575','KL POLOS 9K','GR','---','H2J','BELI','BELI001','2170000','2025-11-30','2.870','1','kasir','2025-11-30 14:29:40');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00017575','X-00017575');
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-251130-0008','F323171152351','AAT','1','BELI','BELI001','H2J', 'X-00017575', 'KL POLOS 9K','2.950','2.870','100.00','1470000','2170000','756098','1130000','1','2170000','2170000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.870',berat_beli_asli=berat_beli_asli+'2.870',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.870',berat_akhir_asli=berat_akhir_asli+'2.870',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-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-251130-0008','2025-11-30','2025-11-30','14:29:40','AAT','---','2.870','2170000','2170000','2170000','2170000','2170000','kasir','2025-11-30 14:29:40','FB-251130-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251130-0008','JIHAN','PURWANTORO','','','','kasir','2025-11-30 14:29:40');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251130-0034','K','2025-11-30','14:29:40','kasir','PEMBELIAN UMUM','FB-251130-0008','945513000','2170000','943343000');
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-00017576','X-00017576','CC MODEL DAUN SLEP UB 18 8K','GR','---','E1D','BELI','BELI001','802000','2025-11-30','1.000','1','kasir','2025-11-30 14:30:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00017576','X-00017576');
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-251130-0009','F325241113441','AAT','1','BELI','BELI001','E1D', 'X-00017576', 'CC MODEL DAUN SLEP UB 18 8K','1.000','1.000','100.00','987000','802000','802000','1020000','1','802000','802000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251130-0009','2025-11-30','2025-11-30','14:30:31','AAT','---','1.000','802000','802000','802000','802000','802000','kasir','2025-11-30 14:30:31','FB-251130-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251130-0009','BU NUR','PENGGUNG NAWANGAN','','','','kasir','2025-11-30 14:30:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251130-0035','K','2025-11-30','14:30:31','kasir','PEMBELIAN UMUM','FB-251130-0009','943343000','802000','942541000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251130-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251130-0009';
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-00017577','X-00017577','CC MODEL DAUN SLEP UB 18 8K','GR','---','E1D','BELI','BELI001','907000','2025-11-30','1.000','1','kasir','2025-11-30 14:34:26');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00017577','X-00017577');
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-251130-0009','F325241113441','AAT','1','BELI','BELI001','E1D', 'X-00017577', 'CC MODEL DAUN SLEP UB 18 8K','1.000','1.000','100.00','987000','907000','907000','1020000','1','907000','907000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251130-0009','2025-11-30','2025-11-30','14:34:26','AAT','---','1.000','907000','907000','907000','907000','907000','kasir','2025-11-30 14:34:26','FB-251130-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251130-0009','BU NUR','PENGGUNG NAWANGAN','','','','kasir','2025-11-30 14:34:26');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251130-0037','K','2025-11-30','14:34:26','kasir','PEMBELIAN UMUM','FB-251130-0009','943343000','907000','942436000');
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-00017578','X-00017578','KL POLOS 9K','GR','---','H2J','BELI','BELI001','3157000','2025-11-30','4.050','1','kasir','2025-11-30 14:37:11');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00017578','X-00017578');
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-251130-0010','F323271249101','FIT','1','BELI','BELI001','H2J', 'X-00017578', 'KL POLOS 9K','4.050','4.050','100.00','2160000','3157000','779506','1130000','1','3157000','3157000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.050',berat_beli_asli=berat_beli_asli+'4.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.050',berat_akhir_asli=berat_akhir_asli+'4.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-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-251130-0010','2025-11-30','2025-11-30','14:37:11','FIT','---','4.050','3157000','3157000','3157000','3157000','3157000','kasir','2025-11-30 14:37:11','FB-251130-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251130-0010','KURNIA','GELANG KENTENG','','','','kasir','2025-11-30 14:37:11');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251130-0038','K','2025-11-30','14:37:11','kasir','PEMBELIAN UMUM','FB-251130-0010','942436000','3157000','939279000');
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-00017579','X-00017579','LT COR M 8K','GR','---','D2E','BELI','BELI001','665000','2025-11-30','1.070','1','kasir','2025-11-30 14:39:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00017579','X-00017579');
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-251130-0011','F323271244111','FIT','1','BELI','BELI001','D2E', 'X-00017579', 'LT COR M 8K','1.070','1.070','100.00','517000','665000','621495','1040000','1','665000','665000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.070',berat_beli_asli=berat_beli_asli+'1.070',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.070',berat_akhir_asli=berat_akhir_asli+'1.070',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-30' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251130-0011','2025-11-30','2025-11-30','14:39:07','FIT','---','1.070','665000','665000','665000','665000','665000','kasir','2025-11-30 14:39:08','FB-251130-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251130-0011','KURNIA','GELANG KENTENG','','','','kasir','2025-11-30 14:39:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251130-0039','K','2025-11-30','14:39:07','kasir','PEMBELIAN UMUM','FB-251130-0011','939279000','665000','938614000');
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-00017580','X-00017580','GL X OVAL MATA UB 54 8K','GR','---','F2E','BELI','BELI001','3788000','2025-11-30','5.440','1','kasir','2025-11-30 14:41:53');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00017580','X-00017580');
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-251130-0012','F324031254291','FIT','1','BELI','BELI001','F2E', 'X-00017580', 'GL X OVAL MATA UB 54 8K','5.440','5.440','100.00','3237000','3788000','696324','1040000','1','3788000','3788000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.440',berat_beli_asli=berat_beli_asli+'5.440',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.440',berat_akhir_asli=berat_akhir_asli+'5.440',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-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-251130-0012','2025-11-30','2025-11-30','14:41:52','FIT','---','5.440','3788000','3788000','3788000','3788000','3788000','kasir','2025-11-30 14:41:53','FB-251130-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251130-0012','NIA','KENTENG','','','','kasir','2025-11-30 14:41:53');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251130-0040','K','2025-11-30','14:41:52','kasir','PEMBELIAN UMUM','FB-251130-0012','938614000','3788000','934826000');
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-00017581','X-00017581','CC MODEL BONEKA CAT MATA VAR LG 8K','GR','---','E1E','BELI','BELI001','702000','2025-11-30','1.080','1','kasir','2025-11-30 14:42:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00017581','X-00017581');
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-251130-0013','F324231013331','FIT','1','BELI','BELI001','E1E', 'X-00017581', 'CC MODEL BONEKA CAT MATA VAR LG 8K','1.080','1.080','100.00','718000','702000','650000','1040000','1','702000','702000','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 ='2025-11-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-251130-0013','2025-11-30','2025-11-30','14:42:47','FIT','---','1.080','702000','702000','702000','702000','702000','kasir','2025-11-30 14:42:47','FB-251130-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251130-0013','NIA','KENTENG','','','','kasir','2025-11-30 14:42:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-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-251130-0041','K','2025-11-30','14:42:47','kasir','PEMBELIAN UMUM','FB-251130-0013','934826000','702000','934124000');
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 ('F325300259241','kasir','1',' MDE2 X BM ','TOKO','PM-E','E2D-YHBX-81-0','CC X MODEL MATA BM 16 8K ','','0.970','1','100.00','980000','0','0','15000','980000','0','0','0','980000','FIT','00366359','E2D','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YHBX-81-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='E2D-YHBX-81-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 ('F325300259241','2025-11-30','0.970','2025-11-30','14:59:24','PLG0025977','980000','980000','0','980000','980000','kasir','2025-11-30 14:59:24','F32530025924');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325300259241','2025-11-30','14:59:24','FIT','980000','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-251130-0042','D','2025-11-30','14:59:24','kasir','PENJUALAN','F325300259241','934124000','980000','935104000');
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 ('F325300300221','kasir','1',' MDE2 X BM ','TOKO','PM-E','E2D-YIAC-108-0','CC X MODEL MATA BM 14 8K ','','1.280','1','100.00','1293000','0','0','15000','1293000','0','0','0','1293000','FIT','00369192','E2D','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIAC-108-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2025-11-30' AND kode_barang='E2D-YIAC-108-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 ('F325300300221','2025-11-30','1.280','2025-11-30','15:00:22','PLG0025978','1293000','1293000','0','1293000','1293000','kasir','2025-11-30 15:00:22','F32530030022');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-30','F325300300221','2025-11-30','15:00:22','FIT','1293000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251130-0043','D','2025-11-30','15:00:22','kasir','PENJUALAN','F325300300221','935104000','1293000','936397000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251130-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251130-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251130-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251130-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251130-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251130-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251130-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251130-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251130-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251130-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251130-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251130-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251130-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251130-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251130-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251130-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251130-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251130-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251130-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251130-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251130-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251130-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251130-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251130-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251130-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251130-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325300101301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325300101301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325300101301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325300101521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325300101521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325300101521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325300151161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325300151161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325300151161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325300214251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325300214251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325300214251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325300259241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325300259241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325300259241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325300300221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325300300221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325300300221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325300747411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325300747411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325300747411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325300748201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325300748201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325300748201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325300750001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325300750001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325300750001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325300855051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325300855051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325300855051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325300855571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325300855571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325300855571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325300930191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325300930191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325300930191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325300935271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325300935271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325300935271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325300937371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325300937371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325300937371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325300939191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325300939191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325300939191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325300939561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325300939561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325300939561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325300957591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325300957591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325300957591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325301041191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325301041191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325301041191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325301041471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325301041471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325301041471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325301045391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325301045391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325301045391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325301046211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325301046211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325301046211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325301111531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325301111531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325301111531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325301155041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325301155041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325301155041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325301155301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325301155301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325301155301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325301209221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325301209221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325301209221';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-01','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-31';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-30';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-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='2025-11-30' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-30';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-30';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-30';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-30';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-12-01' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-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-251201-0001','D','2025-12-01','15:32:25','SYSTEM','SALDO AWAL','SALDO AWAL','0','936397000','936397000');
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-251201-0001','D','2025-12-01','15:32:25','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251201-0001','D','2025-12-01','15:32:25','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-251201-0001','D','2025-12-01','15:32:25','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
UPDATE tp_system SET tgl_system='2025-12-01';