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 ('F326180939081','input','1',' MEF1 X LG ','TOKO','PM-F','F1E-XFAI-60-0','GL X OSROT BONEKA ANAK CAT LG 8K ','','1.560','1','100.00','1774000','0','0','15000','1775000','0','0','0','1775000','AAT','00303154','F1E','0','0','-','0','1147000');
UPDATE tm_barang SET tgl_last_jual='2026-01-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-XFAI-60-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.560',berat_jual_asli=berat_jual_asli+'1.560',stock_jual='1',berat_akhir=berat_akhir-'1.560',berat_akhir_asli=berat_akhir_asli-'1.560',stock_akhir='0' WHERE tanggal='2026-01-18' AND kode_barang='F1E-XFAI-60-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 ('F326180939081','2026-01-18','1.560','2026-01-18','09:39:09','PLG0026776','1775000','1775000','0','1775000','1775000','input','2026-01-18 09:39:08','F32618093908');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-18','F326180939081','2026-01-18','09:39:09','AAT','1775000','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-260118-0002','D','2026-01-18','09:39:09','input','PENJUALAN','F326180939081','1899189000','1775000','1900964000');
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 ('F326181049091','input','1',' MEF3E X LT','TOKO','PM-F','F3E-YLBI-169-0','GL X GHENIA SLEP LT 8K ','','1.070','1','100.00','1217000','0','0','15000','1217000','0','0','0','1217000','FIT','00383321','F3E','0','0','-','0','1147000');
UPDATE tm_barang SET tgl_last_jual='2026-01-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLBI-169-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='2026-01-18' AND kode_barang='F3E-YLBI-169-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 ('F326181049091','2026-01-18','1.070','2026-01-18','10:49:09','PLG0026777','1217000','1217000','0','1217000','1217000','input','2026-01-18 10:49:09','F32618104909');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-18','F326181049091','2026-01-18','10:49:09','FIT','1217000','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-260118-0003','D','2026-01-18','10:49:09','input','PENJUALAN','F326181049091','1900964000','1217000','1902181000');
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 ('F326181109341','input','1',' MEF2 X HA ','TOKO','PM-F','F2E-YDAB-128-0','GL X PIPA MATA HA 54 8K ','','3.010','1','100.00','3422000','0','0','15000','3422000','0','0','0','3422000','AAT','00349277','F2E','0','0','-','0','1147000');
UPDATE tm_barang SET tgl_last_jual='2026-01-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YDAB-128-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.010',berat_jual_asli=berat_jual_asli+'3.010',stock_jual='1',berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010',stock_akhir='0' WHERE tanggal='2026-01-18' AND kode_barang='F2E-YDAB-128-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 ('F326181109341','2026-01-18','3.010','2026-01-18','11:09:35','PLG0026778','3422000','3422000','0','3422000','3422000','input','2026-01-18 11:09:34','F32618110934');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-18','F326181109341','2026-01-18','11:09:35','AAT','3422000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260118-0004','D','2026-01-18','11:09:35','input','PENJUALAN','F326181109341','1902181000','3422000','1905603000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3422000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326181109341' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326181109342','input',' 1',' MHB1H AV ','TOKO','PM-B','B1H-YLAE-161-0','GW TUSUK MRICAN SLEP AV 8K ','','0.270','1','100.00','323000','0','0','15000','323000','0','0','0','323000','AAT','00381139','B1H','0','0','-','0','1197000');
UPDATE tm_barang SET tgl_last_jual='2026-01-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-YLAE-161-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2026-01-18' AND kode_barang='B1H-YLAE-161-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 ('F326181109342','2026-01-18','0.270','2026-01-18','11:09:35','PLG0026779','323000','323000','0','323000','323000','input','2026-01-18 11:09:34','F32618110934');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-18','F326181109342','2026-01-18','11:09:35','AAT','323000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260118-0005','D','2026-01-18','11:09:35','input','PENJUALAN','F326181109342','1905603000','323000','1905926000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='323000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326181109342' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326181114421','input','1',' MHA1H X DG','TOKO','PM-A','A1H-YLBX-158-0','AT X BABY PLAT DG 8K ','','0.230','1','100.00','275000','0','0','15000','275000','0','0','0','275000','FIT','00382038','A1H','0','0','-','0','1197000');
UPDATE tm_barang SET tgl_last_jual='2026-01-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1H-YLBX-158-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.230',berat_jual_asli=berat_jual_asli+'0.230',stock_jual='1',berat_akhir=berat_akhir-'0.230',berat_akhir_asli=berat_akhir_asli-'0.230',stock_akhir='0' WHERE tanggal='2026-01-18' AND kode_barang='A1H-YLBX-158-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 ('F326181114421','2026-01-18','0.230','2026-01-18','11:14:43','PLG0026780','275000','275000','0','275000','275000','input','2026-01-18 11:14:42','F32618111442');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-18','F326181114421','2026-01-18','11:14:43','FIT','275000','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-260118-0006','D','2026-01-18','11:14:43','input','PENJUALAN','F326181114421','1905926000','275000','1906201000');
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 ('F326181209131','input','1',' MEF3E X UB','TOKO','PM-F','F3E-YAAG-260-0','GL X SANTA SERUT VAR UB 8K ','','2.030','1','100.00','2308000','0','0','15000','2308000','0','0','0','2308000','SIN','00334827','F3E','0','0','-','0','1147000');
UPDATE tm_barang SET tgl_last_jual='2026-01-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YAAG-260-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-01-18' AND kode_barang='F3E-YAAG-260-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 ('F326181209131','2026-01-18','2.030','2026-01-18','12:09:14','PLG0026781','2308000','2308000','0','2308000','2308000','input','2026-01-18 12:09:13','F32618120913');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-18','F326181209131','2026-01-18','12:09:14','SIN','2308000','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-260118-0007','D','2026-01-18','12:09:14','input','PENJUALAN','F326181209131','1906201000','2308000','1908509000');
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 ('F326181221551','input','1',' TEF3 X UB ','TOKO','PT-F','F3TE-WEXI-94-T','GL X RANTAI HOLLOW PLAT UB ','','5.050','1','100.00','10428000','0','0','15000','10430000','0','0','0','10430000','FIT','T0044195','F3TE','0','0','-','0','2065000');
UPDATE tm_barang SET tgl_last_jual='2026-01-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-WEXI-94-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.050',berat_jual_asli=berat_jual_asli+'5.050',stock_jual='1',berat_akhir=berat_akhir-'5.050',berat_akhir_asli=berat_akhir_asli-'5.050',stock_akhir='0' WHERE tanggal='2026-01-18' AND kode_barang='F3TE-WEXI-94-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326181221551','2026-01-18','5.050','2026-01-18','12:21:55','PLG0026782','10430000','10430000','0','10430000','10430000','input','2026-01-18 12:21:55','F32618122155');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-18','F326181221551','2026-01-18','12:21:55','FIT','10430000','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-260118-0008','D','2026-01-18','12:21:55','input','PENJUALAN','F326181221551','1908509000','10430000','1918939000');
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 ('F326181228111','input','1',' MDE2 X NJ ','TOKO','PM-E','E2D-YIAC-107-0','CC X MODEL MATA NJ 14 8K ','','0.800','1','100.00','894000','0','0','15000','895000','0','0','0','895000','SIN','00369191','E2D','0','0','-','0','1127000');
UPDATE tm_barang SET tgl_last_jual='2026-01-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIAC-107-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2026-01-18' AND kode_barang='E2D-YIAC-107-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 ('F326181228111','2026-01-18','0.800','2026-01-18','12:28:12','PLG0026783','895000','895000','0','895000','895000','input','2026-01-18 12:28:11','F32618122811');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-18','F326181228111','2026-01-18','12:28:12','SIN','895000','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-260118-0009','D','2026-01-18','12:28:12','input','PENJUALAN','F326181228111','1918939000','895000','1919834000');
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 ('F326181242111','input','1',' MEE2 X CM ','TOKO','PM-E','E2E-YLXH-87-0','CC X MODEL MATA CM 16 8K ','','0.620','1','100.00','705000','0','0','15000','705000','0','0','0','705000','FIT','00380209','E2E','0','0','-','0','1147000');
UPDATE tm_barang SET tgl_last_jual='2026-01-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YLXH-87-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2026-01-18' AND kode_barang='E2E-YLXH-87-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326181242111','2026-01-18','0.620','2026-01-18','12:42:12','PLG0026784','705000','705000','0','705000','705000','input','2026-01-18 12:42:11','F32618124211');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-18','F326181242111','2026-01-18','12:42:12','FIT','705000','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-260118-0010','D','2026-01-18','12:42:12','input','PENJUALAN','F326181242111','1919834000','705000','1920539000');
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-00017985','X-00017985','GL MODEL PAPERLINA YT 8K','GR','---','F3E','BELI','BELI001','955000','2026-01-18','1.210','1','kasir','2026-01-18 12:55:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017985','X-00017985');
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-260118-0001','F325221207291','FIT','1','BELI','BELI001','F3E', 'X-00017985', 'GL MODEL PAPERLINA YT 8K','1.210','1.210','100.00','925000','955000','789256','1147000','1','955000','955000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.210',berat_beli_asli=berat_beli_asli+'1.210',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.210',berat_akhir_asli=berat_akhir_asli+'1.210',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-18' 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-260118-0001','2026-01-18','2026-01-18','12:55:57','FIT','---','1.210','955000','955000','955000','955000','955000','kasir','2026-01-18 12:55:57','FB-260118-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260118-0001','HANA','SAWAHAN 4/3 PLOSO','','','','kasir','2026-01-18 12:55:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-18' 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-260118-0011','K','2026-01-18','12:55:57','kasir','PEMBELIAN UMUM','FB-260118-0001','1920539000','955000','1919584000');
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-00017986','X-00017986','CC MODEL MATA CAT VAR CM 14 8K','GR','---','E2E','BELI','BELI001','580000','2026-01-18','0.790','1','kasir','2026-01-18 12:55:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00017986','X-00017986');
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-260118-0002','F325231008432','FIT','2','BELI','BELI001','E2E', 'X-00017986', 'CC MODEL MATA CAT VAR CM 14 8K','0.790','0.790','100.00','603000','580000','734177','1147000','1','580000','580000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.790',berat_beli_asli=berat_beli_asli+'0.790',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.790',berat_akhir_asli=berat_akhir_asli+'0.790',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260118-0002','2026-01-18','2026-01-18','12:55:57','FIT','---','0.790','580000','580000','580000','580000','580000','kasir','2026-01-18 12:55:57','FB-260118-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260118-0002','HANA','SAWAHAN PLOSO 4/3','','','','kasir','2026-01-18 12:55:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-18' 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-260118-0012','K','2026-01-18','12:55:57','kasir','PEMBELIAN UMUM','FB-260118-0002','1919584000','580000','1919004000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260118-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260118-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260118-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260118-0001';
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 ('F326181258491','kasir','1',' MEE2 X LG ','TOKO','PM-E','E2E-YHXB-224-0','CC X MODEL MATA LG 13 8K ','','0.440','1','100.00','500000','0','0','15000','500000','0','0','0','500000','SIN','00363634','E2E','0','0','-','0','1147000');
UPDATE tm_barang SET tgl_last_jual='2026-01-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YHXB-224-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.440',berat_jual_asli=berat_jual_asli+'0.440',stock_jual='1',berat_akhir=berat_akhir-'0.440',berat_akhir_asli=berat_akhir_asli-'0.440',stock_akhir='0' WHERE tanggal='2026-01-18' AND kode_barang='E2E-YHXB-224-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 ('F326181258491','2026-01-18','0.440','2026-01-18','12:58:50','PLG0026785','500000','500000','0','500000','500000','kasir','2026-01-18 12:58:49','F32618125849');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-18','F326181258491','2026-01-18','12:58:50','SIN','500000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260118-0015','D','2026-01-18','12:58:50','kasir','PENJUALAN','F326181258491','1920539000','500000','1921039000');
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-00017987','X-00017987','GL MODEL PAPERLINA YT 8K','GR','---','F3E','BELI','BELI001','955000','2026-01-18','1.210','1','kasir','2026-01-18 13:00:01');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017987','X-00017987');
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-260118-0001','F325221207291','FIT','1','BELI','BELI001','F3E', 'X-00017987', 'GL MODEL PAPERLINA YT 8K','1.210','1.210','100.00','925000','955000','789256','1147000','1','955000','955000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.210',berat_beli_asli=berat_beli_asli+'1.210',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.210',berat_akhir_asli=berat_akhir_asli+'1.210',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-18' 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-260118-0001','2026-01-18','2026-01-18','13:00:01','FIT','---','1.210','955000','955000','955000','955000','955000','kasir','2026-01-18 13:00:01','FB-260118-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260118-0001','HANA','SAWAHAN 4/3 PLOSO','','','','kasir','2026-01-18 13:00:01');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-18' 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-260118-0016','K','2026-01-18','13:00:01','kasir','PEMBELIAN UMUM','FB-260118-0001','1921039000','955000','1920084000');
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-00017988','X-00017988','CC MODEL MATA CAT VAR CM 14 8K','GR','---','E2E','BELI','BELI001','580000','2026-01-18','0.790','1','kasir','2026-01-18 13:00:01');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00017988','X-00017988');
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-260118-0002','F325231008432','FIT','2','BELI','BELI001','E2E', 'X-00017988', 'CC MODEL MATA CAT VAR CM 14 8K','0.790','0.790','100.00','603000','580000','734177','1147000','1','580000','580000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.790',berat_beli_asli=berat_beli_asli+'0.790',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.790',berat_akhir_asli=berat_akhir_asli+'0.790',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260118-0002','2026-01-18','2026-01-18','13:00:01','FIT','---','0.790','580000','580000','580000','580000','580000','kasir','2026-01-18 13:00:01','FB-260118-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260118-0002','HANA','SAWAHAN PLOSO 4/3','','','','kasir','2026-01-18 13:00:01');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-18' 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-260118-0017','K','2026-01-18','13:00:01','kasir','PEMBELIAN UMUM','FB-260118-0002','1920084000','580000','1919504000');
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-00017989','X-00017989','KL X SIEM COBRA KH 44 9K','GR','---','H2J','BELI','BELI001','1115000','2026-01-18','1.260','1','kasir','2026-01-18 13:00:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00017989','X-00017989');
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-260118-0003','F325150135101','SIN','1','BELI','BELI001','H2J', 'X-00017989', 'KL X SIEM COBRA KH 44 9K','1.260','1.260','100.00','1175000','1115000','884921','1247000','1','1115000','1115000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.260',berat_beli_asli=berat_beli_asli+'1.260',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.260',berat_akhir_asli=berat_akhir_asli+'1.260',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-18' 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-260118-0003','2026-01-18','2026-01-18','13:00:28','SIN','---','1.260','1115000','1115000','1115000','1115000','1115000','kasir','2026-01-18 13:00:28','FB-260118-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260118-0003','MARTINA','BONDALEM SLOGOHIMO','','','','kasir','2026-01-18 13:00:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-18' 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-260118-0018','K','2026-01-18','13:00:28','kasir','PEMBELIAN UMUM','FB-260118-0003','1919504000','1115000','1918389000');
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-00017990','X-00017990','CC X MODEL MATA LG 12 8K','GR','---','E2E','BELI','BELI001','550000','2026-01-18','0.510','1','kasir','2026-01-18 13:00:49');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00017990','X-00017990');
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-260118-0004','F326140928361','AAT','1','BELI','BELI001','E2E', 'X-00017990', 'CC X MODEL MATA LG 12 8K','0.510','0.510','100.00','580000','550000','1078431','1147000','1','550000','550000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260118-0004','2026-01-18','2026-01-18','13:00:48','AAT','---','0.510','550000','550000','550000','550000','550000','kasir','2026-01-18 13:00:49','FB-260118-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260118-0004','PUTRI','TENGGER PUHPELEM','','','','kasir','2026-01-18 13:00:49');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-18' 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-260118-0019','K','2026-01-18','13:00:48','kasir','PEMBELIAN UMUM','FB-260118-0004','1918389000','550000','1917839000');
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-00017991','X-00017991','AT COR 8K','GR','---','A1E','BELI','BELI001','640000','2026-01-18','0.930','1','kasir','2026-01-18 13:02:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00017991','X-00017991');
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-260118-0005','F323240953011','SIN','1','BELI','BELI001','A1E', 'X-00017991', 'AT COR 8K','0.930','0.930','100.00','455000','640000','688172','1147000','1','640000','640000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.930',berat_beli_asli=berat_beli_asli+'0.930',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.930',berat_akhir_asli=berat_akhir_asli+'0.930',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' 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-260118-0005','2026-01-18','2026-01-18','13:02:23','SIN','---','0.930','640000','640000','640000','640000','640000','kasir','2026-01-18 13:02:23','FB-260118-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260118-0005','TITIK','JETAK','','','','kasir','2026-01-18 13:02:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-18' 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-260118-0020','K','2026-01-18','13:02:23','kasir','PEMBELIAN UMUM','FB-260118-0005','1917839000','640000','1917199000');
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-00017992','X-00017992','AT X HUGGIES ARESO SLEP UB','GR','---','A1F','BELI','BELI001','500000','2026-01-18','0.660','1','kasir','2026-01-18 13:02:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00017992','X-00017992');
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-260118-0006','F322300153341','AAT','1','BELI','BELI001','A1F', 'X-00017992', 'AT X HUGGIES ARESO SLEP UB','0.660','0.660','100.00','295000','500000','757576','1167000','1','500000','500000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.660',berat_beli_asli=berat_beli_asli+'0.660',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.660',berat_akhir_asli=berat_akhir_asli+'0.660',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260118-0006','2026-01-18','2026-01-18','13:02:45','AAT','---','0.660','500000','500000','500000','500000','500000','kasir','2026-01-18 13:02:46','FB-260118-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260118-0006','LINA','WOTGALIH','','','','kasir','2026-01-18 13:02:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-18' 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-260118-0021','K','2026-01-18','13:02:45','kasir','PEMBELIAN UMUM','FB-260118-0006','1917199000','500000','1916699000');
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-00017993','X-00017993','GL RANTAI HOLLOW MODEL MATA VAR UB 8K','GR','---','F3E','BELI','BELI001','3815000','2026-01-18','4.760','1','kasir','2026-01-18 13:03:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017993','X-00017993');
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-260118-0007','F325110208381','AAT','1','BELI','BELI001','F3E', 'X-00017993', 'GL RANTAI HOLLOW MODEL MATA VAR UB 8K','4.760','4.760','100.00','4000000','3815000','801471','1147000','1','3815000','3815000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.760',berat_beli_asli=berat_beli_asli+'4.760',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.760',berat_akhir_asli=berat_akhir_asli+'4.760',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-18' 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-260118-0007','2026-01-18','2026-01-18','13:03:21','AAT','---','4.760','3815000','3815000','3815000','3815000','3815000','kasir','2026-01-18 13:03:21','FB-260118-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260118-0007','NANING','BULUKERTO','','','088238818340','kasir','2026-01-18 13:03:21');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-18' 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-260118-0022','K','2026-01-18','13:03:21','kasir','PEMBELIAN UMUM','FB-260118-0007','1916699000','3815000','1912884000');
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-00017994','X-00017994','GL PITON JEDAR 2LAYER 2C VAR KH 8K','GR','---','F3F','BELI','BELI001','1225000','2026-01-18','1.550','1','kasir','2026-01-18 13:03:58');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00017994','X-00017994');
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-260118-0008','F325200229221','FIT','1','BELI','BELI001','F3F', 'X-00017994', 'GL PITON JEDAR 2LAYER 2C VAR KH 8K','1.600','1.550','100.00','1115000','1225000','790323','1167000','1','1225000','1225000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.550',berat_beli_asli=berat_beli_asli+'1.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.550',berat_akhir_asli=berat_akhir_asli+'1.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3F' 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-260118-0008','2026-01-18','2026-01-18','13:03:58','FIT','---','1.550','1225000','1225000','1225000','1225000','1225000','kasir','2026-01-18 13:03:58','FB-260118-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260118-0008','DESI','KEPYAR','','','','kasir','2026-01-18 13:03:58');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-18' 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-260118-0023','K','2026-01-18','13:03:58','kasir','PEMBELIAN UMUM','FB-260118-0008','1912884000','1225000','1911659000');
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-00017995','X-00017995','CC X MODEL MATA CM 13 8K','GR','---','E2D','BELI','BELI001','1235000','2026-01-18','1.250','1','kasir','2026-01-18 13:04:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017995','X-00017995');
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-260118-0009','F325170226492','SIN','1','BELI','BELI001','E2D', 'X-00017995', 'CC X MODEL MATA CM 13 8K','1.250','1.250','100.00','1330000','1235000','988000','1127000','1','1235000','1235000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.250',berat_beli_asli=berat_beli_asli+'1.250',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.250',berat_akhir_asli=berat_akhir_asli+'1.250',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-18' 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-260118-0009','2026-01-18','2026-01-18','13:04:23','SIN','---','1.250','1235000','1235000','1235000','1235000','1235000','kasir','2026-01-18 13:04:23','FB-260118-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260118-0009','SUYATMI','PUHPELEM','','','082187508337','kasir','2026-01-18 13:04:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-18' 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-260118-0024','K','2026-01-18','13:04:23','kasir','PEMBELIAN UMUM','FB-260118-0009','1911659000','1235000','1910424000');
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-00017996','X-00017996','CC X BONEKA ANAK MT CAT LG','GR','---','E2E','BELI','BELI001','675000','2026-01-18','0.970','1','kasir','2026-01-18 13:04:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00017996','X-00017996');
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-260118-0010','F324080942461','SIN','1','BELI','BELI001','E2E', 'X-00017996', 'CC X BONEKA ANAK MT CAT LG','0.970','0.970','100.00','583000','675000','695876','1147000','1','675000','675000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.970',berat_beli_asli=berat_beli_asli+'0.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.970',berat_akhir_asli=berat_akhir_asli+'0.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260118-0010','2026-01-18','2026-01-18','13:04:50','SIN','---','0.970','675000','675000','675000','675000','675000','kasir','2026-01-18 13:04:51','FB-260118-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260118-0010','FELICIA','TENGKLIK BULUKERTO','','','','kasir','2026-01-18 13:04:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-18' 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-260118-0025','K','2026-01-18','13:04:50','kasir','PEMBELIAN UMUM','FB-260118-0010','1910424000','675000','1909749000');
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-00017997','X-00017997','LT COR T 8K','GR','---','D1F','BELI','BELI001','370000','2026-01-18','0.480','1','kasir','2026-01-18 13:06:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1F','X-00017997','X-00017997');
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-260118-0011','F323071128581','FIT','1','BELI','BELI001','D1F', 'X-00017997', 'LT COR T 8K','0.480','0.480','100.00','220000','370000','770833','1167000','1','370000','370000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.480',berat_beli_asli=berat_beli_asli+'0.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.480',berat_akhir_asli=berat_akhir_asli+'0.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1F' 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-260118-0011','2026-01-18','2026-01-18','13:06:16','FIT','---','0.480','370000','370000','370000','370000','370000','kasir','2026-01-18 13:06:16','FB-260118-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260118-0011','WARSINI','WOTGALIH BAKALAN','','','','kasir','2026-01-18 13:06:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-18' 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-260118-0026','K','2026-01-18','13:06:16','kasir','PEMBELIAN UMUM','FB-260118-0011','1909749000','370000','1909379000');
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 ('F326180139131','kasir','1',' MEF3E X YT','TOKO','PM-F','F3E-ZAAE-77-0','GL X TIFF SPECTRA VAR SERUT YT 8K ','','2.520','1','100.00','2865000','0','0','15000','2865000','0','15000','0','2880000','SIN','00385326','F3E','0','0','-','0','1147000');
UPDATE tm_barang SET tgl_last_jual='2026-01-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZAAE-77-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.520',berat_jual_asli=berat_jual_asli+'2.520',stock_jual='1',berat_akhir=berat_akhir-'2.520',berat_akhir_asli=berat_akhir_asli-'2.520',stock_akhir='0' WHERE tanggal='2026-01-18' AND kode_barang='F3E-ZAAE-77-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 ('F326180139131','2026-01-18','2.520','2026-01-18','13:39:13','PLG0026786','2865000','2865000','15000','2880000','2880000','kasir','2026-01-18 13:39:13','F32618013913');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-18','F326180139131','2026-01-18','13:39:13','SIN','2880000','15000');
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-260118-0027','D','2026-01-18','13:39:13','kasir','PENJUALAN','F326180139131','1909379000','2880000','1912259000');
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 ('F326180141351','kasir','1',' TFE2 X MT ','TOKO','PT-E','E2TF-VHBE-57-T','CC X WEDDING MATA MT 22 ','','1.870','1','100.00','3899000','0','0','15000','3900000','0','0','0','3900000','FIT','T0037241','E2TF','0','0','-','0','2085000');
UPDATE tm_barang SET tgl_last_jual='2026-01-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TF-VHBE-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.870',berat_jual_asli=berat_jual_asli+'1.870',stock_jual='1',berat_akhir=berat_akhir-'1.870',berat_akhir_asli=berat_akhir_asli-'1.870',stock_akhir='0' WHERE tanggal='2026-01-18' AND kode_barang='E2TF-VHBE-57-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326180141351','2026-01-18','1.870','2026-01-18','13:41:36','PLG0026787','3900000','3900000','0','3900000','3900000','kasir','2026-01-18 13:41:35','F32618014135');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-18','F326180141351','2026-01-18','13:41:36','FIT','3900000','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-260118-0028','D','2026-01-18','13:41:36','kasir','PENJUALAN','F326180141351','1912259000','3900000','1916159000');
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 ('F326180154501','kasir','1',' MEF1 X UB ','TOKO','PM-F','F1E-ZAAC-102-0','GL X OVAL C SLEP UB 52 8K ','','2.050','1','100.00','2351000','0','0','15000','2330000','0','0','0','2330000','SIN','00385009','F1E','0','0','-','1','1147000');
UPDATE tm_barang SET tgl_last_jual='2026-01-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZAAC-102-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-01-18' AND kode_barang='F1E-ZAAC-102-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 ('F326180154501','2026-01-18','2.050','2026-01-18','13:54:50','PLG0026788','2330000','2330000','0','2330000','2330000','kasir','2026-01-18 13:54:50','F32618015450');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-18','F326180154501','2026-01-18','13:54:50','SIN','2330000','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-260118-0029','D','2026-01-18','13:54:50','kasir','PENJUALAN','F326180154501','1916159000','2330000','1918489000');
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-00017998','X-00017998','CC VELG POLOS CM 22 8K','GR','---','E1D','BELI','BELI001','1320000','2026-01-18','1.500','1','kasir','2026-01-18 13:59:32');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00017998','X-00017998');
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-260118-0012','F325251015092','FIT','1','BELI','BELI001','E1D', 'X-00017998', 'CC VELG POLOS CM 22 8K','1.500','1.500','100.00','1553000','1320000','880000','1127000','1','1320000','1320000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.500',berat_beli_asli=berat_beli_asli+'1.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.500',berat_akhir_asli=berat_akhir_asli+'1.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-18' 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-260118-0012','2026-01-18','2026-01-18','13:59:31','FIT','---','1.500','1320000','1320000','1320000','1320000','1320000','kasir','2026-01-18 13:59:32','FB-260118-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260118-0012','TASYA','BUGELAN KISMANTORO','','','085878169686','kasir','2026-01-18 13:59:32');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-18' 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-260118-0030','K','2026-01-18','13:59:31','kasir','PEMBELIAN UMUM','FB-260118-0012','1918489000','1320000','1917169000');
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 ('F326180217001','kasir','1',' MGS1 5K DG','TOKO','PM-S','S1G-YLXF-17-0','AS EXTENTION DG 8K ','','0.280','1','100.00','330000','0','0','15000','330000','0','5000','0','335000','SIN','00379833','S1G','0','0','-','0','1187000');
UPDATE tm_barang SET tgl_last_jual='2026-01-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-YLXF-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.280',berat_jual_asli=berat_jual_asli+'0.280',stock_jual='1',berat_akhir=berat_akhir-'0.280',berat_akhir_asli=berat_akhir_asli-'0.280',stock_akhir='0' WHERE tanggal='2026-01-18' AND kode_barang='S1G-YLXF-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326180217001','2026-01-18','0.280','2026-01-18','14:17:01','PLG0026789','330000','330000','5000','335000','335000','kasir','2026-01-18 14:17:00','F32618021700');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-01-18','F326180217001','2026-01-18','14:17:01','SIN','335000','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-260118-0031','D','2026-01-18','14:17:01','kasir','PENJUALAN','F326180217001','1917169000','335000','1917504000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260118-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260118-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260118-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260118-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260118-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260118-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260118-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260118-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260118-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260118-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260118-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260118-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260118-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260118-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260118-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260118-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260118-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260118-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260118-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260118-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260118-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260118-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260118-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260118-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180139131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180139131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180139131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180141351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180141351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180141351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180154501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180154501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180154501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180217001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180217001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180217001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326180939081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326180939081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326180939081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181049091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181049091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181049091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181109341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181109341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181109341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181109342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181109342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181109342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181114421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181114421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181114421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181209131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181209131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181209131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181221551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181221551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181221551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181228111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181228111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181228111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181242111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181242111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181242111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326181258491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326181258491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326181258491';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-19','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-19';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-18';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-18';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-01-18' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-18';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-18';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-18';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-18';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202600 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
UPDATE tt_barang_saldo SET tanggal= '2026-01-19' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-18' 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-260119-0001','D','2026-01-19','15:30:32','SYSTEM','SALDO AWAL','SALDO AWAL','0','1917504000','1917504000');
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-260119-0001','D','2026-01-19','15:30:32','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-260119-0001','D','2026-01-19','15:30:32','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-260119-0001','D','2026-01-19','15:30:32','BCA','SALDO AWAL','SALDO AWAL','0','707186000','707186000');
UPDATE tp_system SET tgl_system='2026-01-19';