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 ('F325190742371','input','1',' MEA1 LG ','TOKO','PM-A','A1E-YJXD-289-0','AT GYPSY MRICAN VAR LG 8K ','','0.550','1','100.00','586000','0','0','15000','585000','0','0','0','585000','FIT','00372269','A1E','0','0','-','1','1070000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXD-289-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-10-19' AND kode_barang='A1E-YJXD-289-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 ('F325190742371','2025-10-19','0.550','2025-10-19','07:42:38','PLG0025312','585000','585000','0','585000','585000','input','2025-10-19 07:42:37','F32519074237');
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-10-19','F325190742371','2025-10-19','07:42:38','FIT','585000','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-251019-0002','D','2025-10-19','07:42:38','input','PENJUALAN','F325190742371','385086000','585000','385671000');
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 ('F325190805141','input','1',' MFB1F X LG','TOKO','PM-B','B1F-XIBE-123-0','GW X TIFF MATA LG 8K ','','0.570','1','100.00','618000','0','0','15000','620000','0','0','0','620000','AAT','00318813','B1F','0','0','-','0','1090000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-XIBE-123-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2025-10-19' AND kode_barang='B1F-XIBE-123-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 ('F325190805141','2025-10-19','0.570','2025-10-19','08:05:14','PLG0025313','620000','620000','0','620000','620000','input','2025-10-19 08:05:14','F32519080514');
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-10-19','F325190805141','2025-10-19','08:05:14','AAT','620000','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-251019-0003','D','2025-10-19','08:05:14','input','PENJUALAN','F325190805141','385671000','620000','386291000');
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 ('F325190826191','input','1',' MFH1 15K U','TOKO','PM-H','H1F-YJAF-174-0','KL SANTA BONEKA ANAK CAT UB 34 8K ','','2.490','1','100.00','2702000','0','0','15000','2700000','0','15000','0','2715000','AAT','00373491','H1F','0','0','-','1','1090000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YJAF-174-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.490',berat_jual_asli=berat_jual_asli+'2.490',stock_jual='1',berat_akhir=berat_akhir-'2.490',berat_akhir_asli=berat_akhir_asli-'2.490',stock_akhir='0' WHERE tanggal='2025-10-19' AND kode_barang='H1F-YJAF-174-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 ('F325190826191','2025-10-19','2.490','2025-10-19','08:26:20','PLG0025314','2700000','2700000','15000','2715000','2715000','input','2025-10-19 08:26:19','F32519082619');
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-10-19','F325190826191','2025-10-19','08:26:20','AAT','2715000','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-251019-0004','D','2025-10-19','08:26:20','input','PENJUALAN','F325190826191','386291000','2715000','389006000');
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 ('F325190829461','input','1',' TDE1 16 CM','TOKO','PT-E','E1TD-YJXC-43-T','CC MODEL SLEP VAR 16 CM 17K ','','1.660','1','100.00','3146000','0','0','15000','3145000','0','0','0','3145000','SIN','T0073764','E1TD','0','0','-','1','1895000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YJXC-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.660',berat_jual_asli=berat_jual_asli+'1.660',stock_jual='1',berat_akhir=berat_akhir-'1.660',berat_akhir_asli=berat_akhir_asli-'1.660',stock_akhir='0' WHERE tanggal='2025-10-19' AND kode_barang='E1TD-YJXC-43-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 ('F325190829461','2025-10-19','1.660','2025-10-19','08:29:46','PLG0025315','3145000','3145000','0','3145000','3145000','input','2025-10-19 08:29:46','F32519082946');
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-10-19','F325190829461','2025-10-19','08:29:46','SIN','3145000','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-251019-0005','D','2025-10-19','08:29:46','input','PENJUALAN','F325190829461','389006000','3145000','392151000');
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 ('F325190836261','input','1',' MDE1 CM 12','TOKO','PM-E','E1D-YJXF-50-0','CC MODEL DAUN VAR CM 12 8K ','','0.860','1','100.00','899000','0','0','15000','900000','0','0','0','900000','FIT','00372347','E1D','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJXF-50-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2025-10-19' AND kode_barang='E1D-YJXF-50-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 ('F325190836261','2025-10-19','0.860','2025-10-19','08:36:27','PLG0025316','900000','900000','0','900000','900000','input','2025-10-19 08:36:26','F32519083626');
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-10-19','F325190836261','2025-10-19','08:36:27','FIT','900000','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-251019-0006','D','2025-10-19','08:36:27','input','PENJUALAN','F325190836261','392151000','900000','393051000');
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 ('F325191016181','input','1',' TEF3 LT ','TOKO','PT-F','F3TE-YFAA-84-T','GL ANAK MODEL VERONA VAR LT 17K ','','2.020','1','100.00','3868000','0','0','15000','3870000','0','0','0','3870000','FIT','T0069935','F3TE','0','0','-','0','1915000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YFAA-84-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2025-10-19' AND kode_barang='F3TE-YFAA-84-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 ('F325191016181','2025-10-19','2.020','2025-10-19','10:16:19','PLG0025317','3870000','3870000','0','3870000','3870000','input','2025-10-19 10:16:18','F32519101618');
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-10-19','F325191016181','2025-10-19','10:16:19','FIT','3870000','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-251019-0007','D','2025-10-19','10:16:19','input','PENJUALAN','F325191016181','393051000','3870000','396921000');
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 ('F325191019091','input','1',' MDE2 10K Y','TOKO','PM-E','E2D-YJAF-180-0','CC MODEL MATA YT 14 8K ','','2.360','1','100.00','2466000','0','0','15000','2465000','0','10000','0','2475000','AAT','00373497','E2D','0','0','-','1','1050000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJAF-180-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.360',berat_jual_asli=berat_jual_asli+'2.360',stock_jual='1',berat_akhir=berat_akhir-'2.360',berat_akhir_asli=berat_akhir_asli-'2.360',stock_akhir='0' WHERE tanggal='2025-10-19' AND kode_barang='E2D-YJAF-180-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 ('F325191019091','2025-10-19','2.360','2025-10-19','10:19:10','PLG0025318','2465000','2465000','10000','2475000','2475000','input','2025-10-19 10:19:09','F32519101909');
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-10-19','F325191019091','2025-10-19','10:19:10','AAT','2475000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251019-0008','D','2025-10-19','10:19:10','input','PENJUALAN','F325191019091','396921000','2475000','399396000');
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 ('F325191047471','input','1',' MJH2 X UB ','TOKO','PM-H','H2J-YGAG-167-0','KL X GUCCI ANAK UB 34 9K ','','1.100','1','100.00','1281000','0','0','15000','1280000','0','0','0','1280000','SIN','00361252','H2J','0','0','-','1','1190000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YGAG-167-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2025-10-19' AND kode_barang='H2J-YGAG-167-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 ('F325191047471','2025-10-19','1.100','2025-10-19','10:47:48','PLG0025319','1280000','1280000','0','1280000','1280000','input','2025-10-19 10:47:47','F32519104747');
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-10-19','F325191047471','2025-10-19','10:47:48','SIN','1280000','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-251019-0009','D','2025-10-19','10:47:48','input','PENJUALAN','F325191047471','399396000','1280000','400676000');
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 ('F325191055021','input','1',' MEF1 X YT ','TOKO','PM-F','F1E-YEAI-58-0','GL X OVAL SLEP YT 62 8K ','','3.250','1','100.00','3461000','0','0','15000','3460000','0','0','0','3460000','AAT','00354542','F1E','0','0','-','1','1070000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YEAI-58-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.250',berat_jual_asli=berat_jual_asli+'3.250',stock_jual='1',berat_akhir=berat_akhir-'3.250',berat_akhir_asli=berat_akhir_asli-'3.250',stock_akhir='0' WHERE tanggal='2025-10-19' AND kode_barang='F1E-YEAI-58-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 ('F325191055021','2025-10-19','3.250','2025-10-19','10:55:02','PLG0025320','3460000','3460000','0','3460000','3460000','input','2025-10-19 10:55:02','F32519105502');
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-10-19','F325191055021','2025-10-19','10:55:02','AAT','3460000','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-251019-0010','D','2025-10-19','10:55:02','input','PENJUALAN','F325191055021','400676000','3460000','404136000');
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 ('F325191058291','input','1',' MED2E X LG','TOKO','PM-D','D2E-YJXA-66-0','LT X MODEL HURUF MATA LG A 8K ','','0.580','1','100.00','618000','0','0','15000','618000','0','0','0','618000','FIT','00371311','D2E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YJXA-66-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2025-10-19' AND kode_barang='D2E-YJXA-66-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 ('F325191058291','2025-10-19','0.580','2025-10-19','10:58:29','PLG0025321','618000','618000','0','618000','618000','input','2025-10-19 10:58:29','F32519105829');
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-10-19','F325191058291','2025-10-19','10:58:29','FIT','618000','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-251019-0011','D','2025-10-19','10:58:29','input','PENJUALAN','F325191058291','404136000','618000','404754000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='618000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325191058291' 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 ('F325191058292','input',' 1',' MED1 5K YT','TOKO','PM-D','D1E-YJXD-309-0','LT MODEL BONEKA CAT VAR YT 8K ','','0.620','1','100.00','660000','0','0','15000','660000','0','5000','0','665000','FIT','00372289','D1E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJXD-309-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='2025-10-19' AND kode_barang='D1E-YJXD-309-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 ('F325191058292','2025-10-19','0.620','2025-10-19','10:58:29','PLG0025322','660000','660000','5000','665000','665000','input','2025-10-19 10:58:29','F32519105829');
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-10-19','F325191058292','2025-10-19','10:58:29','FIT','665000','5000');
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-251019-0012','D','2025-10-19','10:58:29','input','PENJUALAN','F325191058292','404754000','665000','405419000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='665000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325191058292' 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 ('F325191058293','input',' 1',' MDE2 CM 10','TOKO','PM-E','E2D-YIBI-148-0','CC MODEL MATA VAR CM 10 8K ','','0.900','1','100.00','940000','0','0','15000','940000','0','0','0','940000','FIT','00371019','E2D','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIBI-148-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2025-10-19' AND kode_barang='E2D-YIBI-148-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 ('F325191058293','2025-10-19','0.900','2025-10-19','10:58:29','PLG0025323','940000','940000','0','940000','940000','input','2025-10-19 10:58:29','F32519105829');
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-10-19','F325191058293','2025-10-19','10:58:29','FIT','940000','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-251019-0013','D','2025-10-19','10:58:29','input','PENJUALAN','F325191058293','405419000','940000','406359000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='940000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325191058293' 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 ('F325191058294','input',' 1',' MEE2 CM 12','TOKO','PM-E','E2E-YJAF-183-0','CC MODEL MATA CM 12 8K ','','0.680','1','100.00','724000','0','0','15000','725000','0','0','0','725000','FIT','00373500','E2E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJAF-183-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-10-19' AND kode_barang='E2E-YJAF-183-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 ('F325191058294','2025-10-19','0.680','2025-10-19','10:58:29','PLG0025324','725000','725000','0','725000','725000','input','2025-10-19 10:58:29','F32519105829');
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-10-19','F325191058294','2025-10-19','10:58:29','FIT','725000','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-251019-0014','D','2025-10-19','10:58:29','input','PENJUALAN','F325191058294','406359000','725000','407084000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='725000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325191058294' 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 ('F325191058295','input',' 1',' MIH2 X KH ','TOKO','PM-H','H2I-YFAC-55-0','KL X SANTA KH 44 9K ','','3.030','1','100.00','3469000','0','0','15000','3470000','0','0','0','3470000','FIT','00357170','H2I','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YFAC-55-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.030',berat_jual_asli=berat_jual_asli+'3.030',stock_jual='1',berat_akhir=berat_akhir-'3.030',berat_akhir_asli=berat_akhir_asli-'3.030',stock_akhir='0' WHERE tanggal='2025-10-19' AND kode_barang='H2I-YFAC-55-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 ('F325191058295','2025-10-19','3.030','2025-10-19','10:58:29','PLG0025325','3470000','3470000','0','3470000','3470000','input','2025-10-19 10:58:29','F32519105829');
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-10-19','F325191058295','2025-10-19','10:58:29','FIT','3470000','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-251019-0015','D','2025-10-19','10:58:29','input','PENJUALAN','F325191058295','407084000','3470000','410554000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3470000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325191058295' 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 ('F325191058296','input',' 1',' MIH2 X KH ','TOKO','PM-H','H2I-YIAE-292-0','KL X FLAMINGGO KH 44 9K ','','2.030','1','100.00','2324000','0','0','15000','2325000','0','0','0','2325000','FIT','00369743','H2I','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YIAE-292-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='2025-10-19' AND kode_barang='H2I-YIAE-292-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 ('F325191058296','2025-10-19','2.030','2025-10-19','10:58:29','PLG0025326','2325000','2325000','0','2325000','2325000','input','2025-10-19 10:58:29','F32519105829');
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-10-19','F325191058296','2025-10-19','10:58:29','FIT','2325000','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-251019-0016','D','2025-10-19','10:58:29','input','PENJUALAN','F325191058296','410554000','2325000','412879000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2325000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325191058296' 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 ('F325191127521','input','1',' MEF3E X UB','TOKO','PM-F','F3E-YIAE-225-0','GL X TIFF SPECTRA HITAM SERUT UB 8K ','','1.610','1','100.00','1715000','0','0','15000','1715000','0','10000','0','1725000','FIT','00369676','F3E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIAE-225-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2025-10-19' AND kode_barang='F3E-YIAE-225-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 ('F325191127521','2025-10-19','1.610','2025-10-19','11:27:53','PLG0025327','1715000','1715000','10000','1725000','1725000','input','2025-10-19 11:27:52','F32519112752');
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-10-19','F325191127521','2025-10-19','11:27:53','FIT','1725000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251019-0017','D','2025-10-19','11:27:53','input','PENJUALAN','F325191127521','412879000','1725000','414604000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1725000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325191127521' 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 ('F325191127522','input',' 1',' MEF3E X LT','TOKO','PM-F','F3E-YJXA-270-0','GL X FANCY HATI SLEP LT 8K ','','1.050','1','100.00','1118000','0','0','15000','1118000','0','0','0','1118000','FIT','00371515','F3E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJXA-270-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2025-10-19' AND kode_barang='F3E-YJXA-270-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 ('F325191127522','2025-10-19','1.050','2025-10-19','11:27:53','PLG0025328','1118000','1118000','0','1118000','1118000','input','2025-10-19 11:27:52','F32519112752');
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-10-19','F325191127522','2025-10-19','11:27:53','FIT','1118000','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-251019-0018','D','2025-10-19','11:27:53','input','PENJUALAN','F325191127522','414604000','1118000','415722000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1118000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325191127522' 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 ('F325191127523','input',' 1',' MEF3E X UB','TOKO','PM-F','F3E-YIBD-198-0','GL X TIFF SLEP UB 8K ','','1.030','1','100.00','1097000','0','0','15000','1097000','0','0','0','1097000','FIT','00370619','F3E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIBD-198-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2025-10-19' AND kode_barang='F3E-YIBD-198-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 ('F325191127523','2025-10-19','1.030','2025-10-19','11:27:53','PLG0025329','1097000','1097000','0','1097000','1097000','input','2025-10-19 11:27:52','F32519112752');
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-10-19','F325191127523','2025-10-19','11:27:53','FIT','1097000','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-251019-0019','D','2025-10-19','11:27:53','input','PENJUALAN','F325191127523','415722000','1097000','416819000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1097000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325191127523' 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 ('F325191210251','input','1',' MEE2 5K LG','TOKO','PM-E','E2E-YJAH-44-0','CC BONEKA ANAK MATA CAT LG 8K ','','0.470','1','100.00','503000','0','0','15000','500000','0','5000','0','505000','AAT','00373739','E2E','0','0','-','1','1070000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJAH-44-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-10-19' AND kode_barang='E2E-YJAH-44-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 ('F325191210251','2025-10-19','0.470','2025-10-19','12:10:26','PLG0025330','500000','500000','5000','505000','505000','input','2025-10-19 12:10:25','F32519121025');
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-10-19','F325191210251','2025-10-19','12:10:26','AAT','505000','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-251019-0020','D','2025-10-19','12:10:26','input','PENJUALAN','F325191210251','416819000','505000','417324000');
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 ('F325191252491','input','1',' MEE2 CM 16','TOKO','PM-E','E2E-YGXA-24-0','CC MODEL MATA VAR CM 16 8K ','','0.900','1','100.00','958000','0','0','15000','960000','0','0','0','960000','FIT','00359034','E2E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YGXA-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2025-10-19' AND kode_barang='E2E-YGXA-24-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 ('F325191252491','2025-10-19','0.900','2025-10-19','12:52:49','PLG0025331','960000','960000','0','960000','960000','input','2025-10-19 12:52:49','F32519125249');
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-10-19','F325191252491','2025-10-19','12:52:49','FIT','960000','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-251019-0021','D','2025-10-19','12:52:49','input','PENJUALAN','F325191252491','417324000','960000','418284000');
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 ('F325190134071','input','1',' MEH1 X KH ','TOKO','PM-H','H1E-YIXE-131-0','KL X NORY ANAK KH 34 8K ','','1.650','1','100.00','1757000','0','0','15000','1758000','0','0','0','1758000','AAT','00368146','H1E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YIXE-131-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.650',berat_jual_asli=berat_jual_asli+'1.650',stock_jual='1',berat_akhir=berat_akhir-'1.650',berat_akhir_asli=berat_akhir_asli-'1.650',stock_akhir='0' WHERE tanggal='2025-10-19' AND kode_barang='H1E-YIXE-131-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 ('F325190134071','2025-10-19','1.650','2025-10-19','13:34:08','PLG0025332','1758000','1758000','0','1758000','1758000','input','2025-10-19 13:34:07','F32519013407');
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-10-19','F325190134071','2025-10-19','13:34:08','AAT','1758000','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-251019-0022','D','2025-10-19','13:34:08','input','PENJUALAN','F325190134071','418284000','1758000','420042000');
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 ('F325190207531','input','1',' MEE2 YT 20','TOKO','PM-E','E2E-YJXF-40-0','CC MODEL HATI MATA VAR YT 20 8K ','','0.760','1','100.00','809000','0','0','15000','810000','0','0','0','810000','AAT','00372337','E2E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2025-10-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXF-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2025-10-19' AND kode_barang='E2E-YJXF-40-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 ('F325190207531','2025-10-19','0.760','2025-10-19','14:07:54','PLG0025333','810000','810000','0','810000','810000','input','2025-10-19 14:07:53','F32519020753');
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-10-19','F325190207531','2025-10-19','14:07:54','AAT','810000','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-251019-0023','D','2025-10-19','14:07:54','input','PENJUALAN','F325190207531','420042000','810000','420852000');
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-00017261','X-00017261','AT X HUGGIES MATA VAR UB 8K','GR','---','A1D','BELI','BELI001','825000','2025-10-19','1.100','1','kasir','2025-10-19 14:31:12');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00017261','X-00017261');
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-251019-0001','F325271037151','FIT','1','BELI','BELI001','A1D', 'X-00017261', 'AT X HUGGIES MATA VAR UB 8K','1.100','1.100','100.00','888000','825000','750000','1050000','1','825000','825000','CUCI');
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-10-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' 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-251019-0001','2025-10-19','2025-10-19','14:31:12','FIT','---','1.100','825000','825000','825000','825000','825000','kasir','2025-10-19 14:31:12','FB-251019-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251019-0001','SANTI','NGANDONG KEPYAR','','','','kasir','2025-10-19 14:31:12');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-19' 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-251019-0024','K','2025-10-19','14:31:12','kasir','PEMBELIAN UMUM','FB-251019-0001','420852000','825000','420027000');
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-00017262','X-00017262','KL ANAK MILANO UB 32CM 8K','GR','---','H1F','BELI','BELI001','1455000','2025-10-19','2.000','1','kasir','2025-10-19 14:32:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1F','X-00017262','X-00017262');
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-251019-0002','F325250203231','SIN','1','BELI','BELI001','H1F', 'X-00017262', 'KL ANAK MILANO UB 32CM 8K','2.000','2.000','100.00','1714000','1455000','727500','1090000','1','1455000','1455000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.000',berat_beli_asli=berat_beli_asli+'2.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.000',berat_akhir_asli=berat_akhir_asli+'2.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1F' 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-251019-0002','2025-10-19','2025-10-19','14:32:32','SIN','---','2.000','1455000','1455000','1455000','1455000','1455000','kasir','2025-10-19 14:32:33','FB-251019-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251019-0002','DENA','JERUK','','','087757332105','kasir','2025-10-19 14:32:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-19' 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-251019-0025','K','2025-10-19','14:32:32','kasir','PEMBELIAN UMUM','FB-251019-0002','420027000','1455000','418572000');
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-00017263','X-00017263','GL SANTA SERUT MODEL DAUN VAR YT 8K','GR','---','F3E','BELI','BELI001','1840000','2025-10-19','1.990','1','kasir','2025-10-19 14:33:12');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017263','X-00017263');
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-251019-0003','F325121120411','AAT','1','BELI','BELI001','F3E', 'X-00017263', 'GL SANTA SERUT MODEL DAUN VAR YT 8K','1.990','1.990','100.00','2000000','1840000','924623','1070000','1','1840000','1840000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.990',berat_beli_asli=berat_beli_asli+'1.990',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.990',berat_akhir_asli=berat_akhir_asli+'1.990',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-19' 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-251019-0003','2025-10-19','2025-10-19','14:33:11','AAT','---','1.990','1840000','1840000','1840000','1840000','1840000','kasir','2025-10-19 14:33:12','FB-251019-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251019-0003','NARTI','SAMPUNG PONOROGO','','','','kasir','2025-10-19 14:33:12');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-19' 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-251019-0026','K','2025-10-19','14:33:11','kasir','PEMBELIAN UMUM','FB-251019-0003','418572000','1840000','416732000');
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-00017264','X-00017264','LT X MODEL HURUF MATA LG D 8K','GR','---','D2D','BELI','BELI001','910000','2025-10-19','1.040','1','kasir','2025-10-19 14:33:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2D','X-00017264','X-00017264');
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-251019-0004','F325300948441','AAT','1','BELI','BELI001','D2D', 'X-00017264', 'LT X MODEL HURUF MATA LG D 8K','1.040','1.040','100.00','980000','910000','875000','1050000','1','910000','910000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.040',berat_beli_asli=berat_beli_asli+'1.040',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.040',berat_akhir_asli=berat_akhir_asli+'1.040',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2D' 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-251019-0004','2025-10-19','2025-10-19','14:33:49','AAT','---','1.040','910000','910000','910000','910000','910000','kasir','2025-10-19 14:33:50','FB-251019-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251019-0004','DIAH','TEGALREJO','','','','kasir','2025-10-19 14:33:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-19' 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-251019-0027','K','2025-10-19','14:33:49','kasir','PEMBELIAN UMUM','FB-251019-0004','416732000','910000','415822000');
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-00017265','X-00017265','CC X BANGKOK BONEKA ANAK CAT LG 8K','GR','---','E1F','BELI','BELI001','365000','2025-10-19','0.560','1','kasir','2025-10-19 14:34:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1F','X-00017265','X-00017265');
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-251019-0005','F325090930571','AAT','1','BELI','BELI001','E1F', 'X-00017265', 'CC X BANGKOK BONEKA ANAK CAT LG 8K','0.560','0.560','100.00','408000','365000','651786','1090000','1','365000','365000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.560',berat_beli_asli=berat_beli_asli+'0.560',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.560',berat_akhir_asli=berat_akhir_asli+'0.560',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251019-0005','2025-10-19','2025-10-19','14:34:37','AAT','---','0.560','365000','365000','365000','365000','365000','kasir','2025-10-19 14:34:37','FB-251019-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251019-0005','FITRI','GONDANG BULUKERTO','','','','kasir','2025-10-19 14:34:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-19' 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-251019-0028','K','2025-10-19','14:34:37','kasir','PEMBELIAN UMUM','FB-251019-0005','415822000','365000','415457000');
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-00017266','X-00017266','AT COR 8K','GR','---','A1E','BELI','BELI001','355000','2025-10-19','0.500','1','kasir','2025-10-19 14:59:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00017266','X-00017266');
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-251019-0006','00328416','FIT','1','BELI','BELI001','A1E', 'X-00017266', 'AT COR 8K','0.500','0.500','100.00','355000','355000','710000','1070000','1','355000','355000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-19' 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-251019-0006','2025-10-19','2025-10-19','14:59:43','FIT','---','0.500','355000','355000','355000','355000','355000','kasir','2025-10-19 14:59:43','FB-251019-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251019-0006','DIMAS','JL VETERAN','','','','kasir','2025-10-19 14:59:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-19' 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-251019-0029','K','2025-10-19','14:59:43','kasir','PEMBELIAN UMUM','FB-251019-0006','415457000','355000','415102000');
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-00017267','X-00017267','GW COR 8K','GR','---','B1F','BELI','BELI001','250000','2025-10-19','0.420','1','kasir','2025-10-19 15:01:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00017267','X-00017267');
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-251019-0007','F323261047391','AAT','1','BELI','BELI001','B1F', 'X-00017267', 'GW COR 8K','0.420','0.420','100.00','205000','250000','595238','1090000','1','250000','250000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.420',berat_beli_asli=berat_beli_asli+'0.420',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.420',berat_akhir_asli=berat_akhir_asli+'0.420',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1F' 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-251019-0007','2025-10-19','2025-10-19','15:01:25','AAT','---','0.420','250000','250000','250000','250000','250000','kasir','2025-10-19 15:01:25','FB-251019-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251019-0007','HAYYIN','MIRI KISMANTORO','','','','kasir','2025-10-19 15:01:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-19' 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-251019-0030','K','2025-10-19','15:01:25','kasir','PEMBELIAN UMUM','FB-251019-0007','415102000','250000','414852000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190134071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190134071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190134071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190207531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190207531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190207531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190742371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190742371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190742371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190805141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190805141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190805141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190826191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190826191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190826191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190829461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190829461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190829461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325190836261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325190836261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325190836261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191016181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191016181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191016181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191019091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191019091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191019091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191047471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191047471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191047471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191055021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191055021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191055021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191058291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191058291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191058291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191058292' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191058292' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191058292';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191058293' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191058293' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191058293';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191058294' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191058294' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191058294';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191058295' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191058295' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191058295';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191058296' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191058296' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191058296';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191127521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191127521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191127521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191127522' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191127522' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191127522';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191127523' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191127523' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191127523';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191210251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191210251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191210251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325191252491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325191252491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325191252491';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251019-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251019-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251019-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251019-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251019-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251019-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251019-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251019-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251019-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251019-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251019-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251019-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251019-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251019-0007';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-20','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-19';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-19';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-19';
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-10-19' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-19';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-19';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-19';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-19';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-20' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-19' 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-251020-0001','D','2025-10-20','15:34:30','SYSTEM','SALDO AWAL','SALDO AWAL','0','414852000','414852000');
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-251020-0001','D','2025-10-20','15:34:30','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251020-0001','D','2025-10-20','15:34:30','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-251020-0001','D','2025-10-20','15:34:30','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
UPDATE tp_system SET tgl_system='2025-10-20';