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 ('F225270845211','kasir','1',' MDA1D X CM','TOKO','SMBK-A','A1D-YKAA-17-0','AT X MODEL MATA VAR CM 8K ','','0.970','1','100.00','975000','0','0','15000','975000','0','0','0','975000','RHM','00376983','A1D','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YKAA-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='A1D-YKAA-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225270845211','2025-11-27','0.970','2025-11-27','08:45:22','PLG0075129','975000','975000','0','975000','975000','kasir','2025-11-27 08:45:21','F22527084521');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-27','F225270845211','2025-11-27','08:45:22','RHM','975000','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-251127-0002','D','2025-11-27','08:45:22','kasir','PENJUALAN','F225270845211','3120564000','975000','3121539000');
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 ('F225270945031','kasir','1',' MDE2 X BM ','TOKO','SMBK-E','E2D-YKAG-122-0','CC X SOLITAIRE MATA BM 14 8K ','OL','1.710','1','100.00','1719000','0','0','15000','1768000','0','10000','0','1778000','RTA','00377698','E2D','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YKAG-122-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.710',berat_jual_asli=berat_jual_asli+'1.710',stock_jual='1',berat_akhir=berat_akhir-'1.710',berat_akhir_asli=berat_akhir_asli-'1.710',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='E2D-YKAG-122-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225270945031','2025-11-27','1.710','2025-11-27','09:45:03','PLG0075130','1768000','1768000','10000','1778000','1778000','kasir','2025-11-27 09:45:03','F22527094503');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-27','F225270945031','2025-11-27','09:45:03','RTA','1778000','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-251127-0003','D','2025-11-27','09:45:03','kasir','PENJUALAN','F225270945031','3121539000','1778000','3123317000');
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 ('F225271036061','kasir','1',' MEB1 CM PE','TOKO','SMBK-B','B1E-YGAH-30-T','GW TUSUK MODEL HATI VAR CM PE 8K ','OL','0.620','1','100.00','635000','0','0','15000','645000','0','5000','0','650000','RTA','T0071061','B1E','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YGAH-30-T' 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-11-27' AND kode_barang='B1E-YGAH-30-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225271036061','2025-11-27','0.620','2025-11-27','10:36:06','PLG0075131','645000','645000','5000','650000','650000','kasir','2025-11-27 10:36:06','F22527103606');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-27','F225271036061','2025-11-27','10:36:06','RTA','650000','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-251127-0004','D','2025-11-27','10:36:06','kasir','PENJUALAN','F225271036061','3123317000','650000','3123967000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='650000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225271036061' 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 ('F225271036062','kasir',' 1',' MFB1 LG PE','TOKO','SMBK-B','B1F-XJBA-7-T','GW TUSUK ALPABETH LG PE S 8K ','OL','0.530','1','100.00','554000','0','0','15000','551000','0','5000','0','556000','RTA','T0063294','B1F','0','0','-','1','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-XJBA-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='B1F-XJBA-7-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225271036062','2025-11-27','0.530','2025-11-27','10:36:06','PLG0075132','551000','551000','5000','556000','556000','kasir','2025-11-27 10:36:06','F22527103606');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-27','F225271036062','2025-11-27','10:36:06','RTA','556000','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-251127-0005','D','2025-11-27','10:36:06','kasir','PENJUALAN','F225271036062','3123967000','556000','3124523000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='556000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225271036062' 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 ('F225271036063','kasir',' 1',' MEB1 CM PE','TOKO','SMBK-B','B1E-YKAI-69-T','GW TUSUK MODEL KELINCI VAR CM PE 8K ','OL','0.600','1','100.00','615000','0','0','15000','624000','0','5000','0','629000','RTA','T0075170','B1E','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YKAI-69-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='B1E-YKAI-69-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225271036063','2025-11-27','0.600','2025-11-27','10:36:06','PLG0075133','624000','624000','5000','629000','629000','kasir','2025-11-27 10:36:06','F22527103606');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-27','F225271036063','2025-11-27','10:36:06','RTA','629000','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-251127-0006','D','2025-11-27','10:36:06','kasir','PENJUALAN','F225271036063','3124523000','629000','3125152000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='629000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225271036063' 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 ('F225271036064','kasir',' 1',' MEB1 CM PE','TOKO','SMBK-B','B1E-YKAI-70-T','GW TUSUK MODEL KELINCI VAR CM PE 8K ','OL','0.610','1','100.00','625000','0','0','15000','634000','0','5000','0','639000','RTA','T0075171','B1E','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YKAI-70-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='B1E-YKAI-70-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225271036064','2025-11-27','0.610','2025-11-27','10:36:06','PLG0075134','634000','634000','5000','639000','639000','kasir','2025-11-27 10:36:06','F22527103606');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-27','F225271036064','2025-11-27','10:36:06','RTA','639000','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-251127-0007','D','2025-11-27','10:36:06','kasir','PENJUALAN','F225271036064','3125152000','639000','3125791000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='639000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225271036064' 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 ('F225271042491','kasir','1',' MJH2 KH 42','TOKO','SMBK-H','H2J-YIBI-92-T','KL BORSALINO KH 42CM 9K ','','1.100','1','100.00','1237000','0','0','15000','1238000','0','0','0','1238000','RHM','T0073405','H2J','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YIBI-92-T' 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-11-27' AND kode_barang='H2J-YIBI-92-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225271042491','2025-11-27','1.100','2025-11-27','10:42:49','PLG0075135','1238000','1238000','0','1238000','1238000','kasir','2025-11-27 10:42:49','F22527104249');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-27','F225271042491','2025-11-27','10:42:49','RHM','1238000','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-251127-0008','D','2025-11-27','10:42:49','kasir','PENJUALAN','F225271042491','3125791000','1238000','3127029000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1238000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225271042491' 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 ('F225271042492','kasir',' 1',' MED2 SB ','TOKO','SMBK-D','D2E-YHBH-197-T','LT MODEL PITA MATA VAR SB 8K ','','0.650','1','100.00','666000','0','0','15000','666000','0','0','0','666000','RHM','T0072693','D2E','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YHBH-197-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='D2E-YHBH-197-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225271042492','2025-11-27','0.650','2025-11-27','10:42:49','PLG0075136','666000','666000','0','666000','666000','kasir','2025-11-27 10:42:49','F22527104249');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-27','F225271042492','2025-11-27','10:42:49','RHM','666000','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-251127-0009','D','2025-11-27','10:42:49','kasir','PENJUALAN','F225271042492','3127029000','666000','3127695000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='666000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225271042492' 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 ('F225270101171','kasir','1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YJXB-49-T','GW TUSUK MODEL PITA LG PE 8K ','OL','0.460','1','100.00','471000','0','0','15000','476000','0','5000','0','481000','TIN','T0073629','B1E','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJXB-49-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='B1E-YJXB-49-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225270101171','2025-11-27','0.460','2025-11-27','13:01:18','PLG0075137','476000','476000','5000','481000','481000','kasir','2025-11-27 13:01:17','F22527010117');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-27','F225270101171','2025-11-27','13:01:18','TIN','481000','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-251127-0010','D','2025-11-27','13:01:18','kasir','PENJUALAN','F225270101171','3127695000','481000','3128176000');
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 ('F225270148031','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YJAA-36-0','CC X SOLITAIRE MATA CM 16 8K ','OL','1.810','1','100.00','1819000','0','0','15000','1863000','0','10000','0','1873000','TIN','00372574','E2D','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJAA-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.810',berat_jual_asli=berat_jual_asli+'1.810',stock_jual='1',berat_akhir=berat_akhir-'1.810',berat_akhir_asli=berat_akhir_asli-'1.810',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='E2D-YJAA-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225270148031','2025-11-27','1.810','2025-11-27','13:48:04','PLG0075138','1863000','1863000','10000','1873000','1873000','kasir','2025-11-27 13:48:03','F22527014803');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-27','F225270148031','2025-11-27','13:48:04','TIN','1873000','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-251127-0011','D','2025-11-27','13:48:04','kasir','PENJUALAN','F225270148031','3128176000','1873000','3130049000');
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 ('F225270211491','kasir','1',' MEE1 X 5K ','TOKO','SMBK-E','E1E-YJCA-55-T','CC X MODEL BUNGA CLOVER CAT CM 10 8K ','OL','0.550','1','100.00','564000','0','0','15000','569000','0','5000','0','574000','TIN','T0074786','E1E','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJCA-55-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='E1E-YJCA-55-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225270211491','2025-11-27','0.550','2025-11-27','14:11:50','PLG0075139','569000','569000','5000','574000','0','kasir','2025-11-27 14:11:49','F22527021149');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-27','F225270211491','2025-11-27','14:11:50','TIN','574000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251127-0001','2025-11-27','2025-11-27 14:11:49','PENJUALAN : F225270211491','234564567856','BCA','574000','574000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251127-0002','D','2025-11-27','14:11:50','BCA','PENJUALAN','F225270211491','4164122888','574000','4164696888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('234564567856','WAWAN');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225270211491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225270211491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225270211491';
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-00004871','X-00004871','CC X RING POLOS UB 8 8K','GR','---','E1G','BELI','BELI001','342000','2025-11-27','0.430','1','kasir','2025-11-27 14:52:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1G','X-00004871','X-00004871');
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-251127-0001','F225100228081','RTA','1','BELI','BELI001','E1G', 'X-00004871', 'CC X RING POLOS UB 8 8K','0.430','0.430','100.00','372000','342000','795349','1065000','1','342000','342000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.430',berat_beli_asli=berat_beli_asli+'0.430',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.430',berat_akhir_asli=berat_akhir_asli+'0.430',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1G' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251127-0001','2025-11-27','2025-11-27','14:52:59','RTA','---','0.430','342000','342000','342000','342000','342000','kasir','2025-11-27 14:52:59','FB-251127-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251127-0001','ANING DWI','SBY','','','','kasir','2025-11-27 14:52:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-27' 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-251127-0012','K','2025-11-27','14:52:59','kasir','PEMBELIAN UMUM','FB-251127-0001','3130049000','342000','3129707000');
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-00004872','X-00004872','LT MODEL HURUF MATA LG A','GR','---','D2TE','BELI','BELI001','1370000','2025-11-27','0.890','1','kasir','2025-11-27 14:54:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2TE','X-00004872','X-00004872');
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-251127-0002','F223271028221','RTA','1','BELI','BELI001','D2TE', 'X-00004872', 'LT MODEL HURUF MATA LG A','1.060','0.890','100.00','878000','1370000','1539326','1850000','1','1370000','1370000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.890',berat_beli_asli=berat_beli_asli+'0.890',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.890',berat_akhir_asli=berat_akhir_asli+'0.890',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2TE' 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-251127-0002','2025-11-27','2025-11-27','14:54:43','RTA','---','0.890','1370000','1370000','1370000','1370000','1370000','kasir','2025-11-27 14:54:44','FB-251127-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251127-0002','FATKHUL','-','','','','kasir','2025-11-27 14:54:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-27' 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-251127-0013','K','2025-11-27','14:54:43','kasir','PEMBELIAN UMUM','FB-251127-0002','3129707000','1370000','3128337000');
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-00004873','X-00004873','CC X WEDDING MATA MT 18','GR','---','E2TE','BELI','BELI001','3040000','2025-11-27','2.000','1','kasir','2025-11-27 14:56:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00004873','X-00004873');
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-251127-0003','F223171126301','RHM','1','BELI','BELI001','E2TE', 'X-00004873', 'CC X WEDDING MATA MT 18','2.120','2.000','100.00','1675000','3040000','1520000','1850000','1','3040000','3040000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.000',berat_beli_asli=berat_beli_asli+'2.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.000',berat_akhir_asli=berat_akhir_asli+'2.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-251127-0003','2025-11-27','2025-11-27','14:56:36','RHM','---','2.000','3040000','3040000','3040000','3040000','3040000','kasir','2025-11-27 14:56:37','FB-251127-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251127-0003','PUJI RAHAYU','BLONDRANG SAWOO','','','082137840053','kasir','2025-11-27 14:56:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-27' 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-251127-0014','K','2025-11-27','14:56:36','kasir','PEMBELIAN UMUM','FB-251127-0003','3128337000','3040000','3125297000');
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-00004874','X-00004874','CC MODEL HATI MATA CM 16 8K','GR','---','E2E','BELI','BELI001','540000','2025-11-27','0.600','1','kasir','2025-11-27 14:57:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00004874','X-00004874');
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-251127-0004','F225300118501','TIN','1','BELI','BELI001','E2E', 'X-00004874', 'CC MODEL HATI MATA CM 16 8K','0.600','0.600','100.00','600000','540000','900000','1025000','1','540000','540000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.600',berat_beli_asli=berat_beli_asli+'0.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.600',berat_akhir_asli=berat_akhir_asli+'0.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-27' 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-251127-0004','2025-11-27','2025-11-27','14:57:02','TIN','---','0.600','540000','540000','540000','540000','540000','kasir','2025-11-27 14:57:03','FB-251127-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251127-0004','ZEKA','GELANG KULON. SAMPUNG','','','085732397403','kasir','2025-11-27 14:57:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-27' 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-251127-0015','K','2025-11-27','14:57:02','kasir','PEMBELIAN UMUM','FB-251127-0004','3125297000','540000','3124757000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225270101171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225270101171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225270101171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225270148031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225270148031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225270148031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225270845211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225270845211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225270845211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225270945031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225270945031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225270945031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225271036061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225271036061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225271036061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225271036062' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225271036062' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225271036062';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225271036063' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225271036063' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225271036063';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225271036064' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225271036064' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225271036064';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225271042491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225271042491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225271042491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225271042492' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225271042492' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225271042492';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251127-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251127-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251127-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251127-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251127-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251127-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251127-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251127-0004';
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 ('F225270317241','kasir','1',' MDE2 CM 12','TOKO','SMBK-E','E2D-YJXA-51-T','CC MODEL MATA VAR CM 12 8K ','','0.900','1','100.00','904000','0','0','15000','905000','0','0','0','905000','RHM','T0073543','E2D','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJXA-51-T' 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-11-27' AND kode_barang='E2D-YJXA-51-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225270317241','2025-11-27','0.900','2025-11-27','15:17:24','PLG0075140','905000','905000','0','905000','905000','kasir','2025-11-27 15:17:24','F22527031724');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-27','F225270317241','2025-11-27','15:17:24','RHM','905000','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-251127-0016','D','2025-11-27','15:17:24','kasir','PENJUALAN','F225270317241','3124757000','905000','3125662000');
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 ('F225270328441','kasir','1',' MEH1E UB 4','TOKO','SMBK-H','H1E-YJBD-115-T','KL GUCCI UB 42CM 8K ','','1.100','1','100.00','1127000','0','0','15000','1128000','0','0','0','1128000','RTA','T0074465','H1E','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJBD-115-T' 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-11-27' AND kode_barang='H1E-YJBD-115-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225270328441','2025-11-27','1.100','2025-11-27','15:28:45','PLG0075141','1128000','1128000','0','1128000','1128000','kasir','2025-11-27 15:28:44','F22527032844');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-27','F225270328441','2025-11-27','15:28:45','RTA','1128000','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-251127-0017','D','2025-11-27','15:28:45','kasir','PENJUALAN','F225270328441','3125662000','1128000','3126790000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1128000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225270328441' 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 ('F225270328442','kasir',' 1',' MEE2 X LG ','TOKO','SMBK-E','E2E-YKBD-239-0','CC X MODEL MATA LG 13 8K ','','0.500','1','100.00','512000','0','0','15000','513000','0','0','0','513000','RTA','00378648','E2E','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YKBD-239-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='E2E-YKBD-239-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225270328442','2025-11-27','0.500','2025-11-27','15:28:45','PLG0075142','513000','513000','0','513000','513000','kasir','2025-11-27 15:28:44','F22527032844');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-27','F225270328442','2025-11-27','15:28:45','RTA','513000','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-251127-0018','D','2025-11-27','15:28:45','kasir','PENJUALAN','F225270328442','3126790000','513000','3127303000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='513000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225270328442' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00004875','X-00004875','LT SLOBOK BOLA KRAWANG BG 8K','GR','---','D1H','BELI','BELI001','217000','2025-11-27','0.240','1','kasir','2025-11-27 15:35:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1H';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1H','X-00004875','X-00004875');
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-251127-0005','F225230338371','RHM','1','BELI','BELI001','D1H', 'X-00004875', 'LT SLOBOK BOLA KRAWANG BG 8K','0.240','0.240','100.00','241000','217000','904167','1085000','1','217000','217000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.240',berat_beli_asli=berat_beli_asli+'0.240',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.240',berat_akhir_asli=berat_akhir_asli+'0.240',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1H' 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-251127-0005','2025-11-27','2025-11-27','15:35:17','RHM','---','0.240','217000','217000','217000','217000','217000','kasir','2025-11-27 15:35:17','FB-251127-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251127-0005','ALFI','PLALANGAN JENANGAN','','','','kasir','2025-11-27 15:35:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-27' 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-251127-0019','K','2025-11-27','15:35:17','kasir','PEMBELIAN UMUM','FB-251127-0005','3127303000','217000','3127086000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225270317241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225270317241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225270317241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225270328441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225270328441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225270328441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225270328442' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225270328442' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225270328442';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251127-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251127-0005';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-28','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-28';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-27';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-27';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-11-27' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-27';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-27';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-27';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-27';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-28' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-27' 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-251128-0001','D','2025-11-28','16:04:23','SYSTEM','SALDO AWAL','SALDO AWAL','0','3127086000','3127086000');
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-251128-0001','D','2025-11-28','16:04:23','BCA','SALDO AWAL','SALDO AWAL','0','4164696888','4164696888');
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-251128-0001','D','2025-11-28','16:04:23','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
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-251128-0001','D','2025-11-28','16:04:23','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-251128-0001','D','2025-11-28','16:04:23','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-251128-0001','D','2025-11-28','16:04:23','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2025-11-28';