INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-29','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-28';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-28';
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-12-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-28';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-28' 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-251229-0001','D','2025-12-29','08:05:11','SYSTEM','SALDO AWAL','SALDO AWAL','0','4306534000','4306534000');
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-251229-0001','D','2025-12-29','08:05:11','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
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-251229-0001','D','2025-12-29','08:05:11','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-251229-0001','D','2025-12-29','08:05:11','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-251229-0001','D','2025-12-29','08:05:11','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-251229-0001','D','2025-12-29','08:05:11','BCA','SALDO AWAL','SALDO AWAL','0','4218285888','4218285888');
UPDATE tp_system SET tgl_system='2025-12-29';
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 ('F225290853421','kasir','1',' MED1 HW ','TOKO','SMBK-D','D1E-YKAG-37-T','LT LETTERA PANJANG HW 8K ','OLSB6K9G','0.750','1','100.00','832000','0','0','15000','829000','0','106000','0','935000','TIN','T0075040','D1E','0','0','-','1','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YKAG-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='D1E-YKAG-37-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 ('F225290853421','2025-12-29','0.750','2025-12-29','08:53:43','PLG0076017','829000','829000','106000','935000','935000','kasir','2025-12-29 08:53:42','F22529085342');
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-12-29','F225290853421','2025-12-29','08:53:43','TIN','935000','106000');
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-251229-0002','D','2025-12-29','08:53:43','kasir','PENJUALAN','F225290853421','4306534000','935000','4307469000');
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 ('F225290912001','kasir','1',' MEA1 BW ','TOKO','SMBK-A','A1E-YLBC-66-T','AT MODEL ITALY PANJANG VAR BW 8K ','OL','0.560','1','100.00','622000','0','0','15000','630000','0','5000','0','635000','NS','T0076128','A1E','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLBC-66-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='A1E-YLBC-66-T' 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 ('F225290912001','2025-12-29','0.560','2025-12-29','09:12:00','PLG0076018','630000','630000','5000','635000','635000','kasir','2025-12-29 09:12:00','F22529091200');
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-12-29','F225290912001','2025-12-29','09:12:00','NS','635000','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-251229-0003','D','2025-12-29','09:12:00','kasir','PENJUALAN','F225290912001','4307469000','635000','4308104000');
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 ('F225290921291','kasir','1',' TEF3 HW ','TOKO','TBK-F','F3TE-YLAE-6-T','GL CASTELA SLEP VAR HW 17K ','','1.970','1','100.00','3940000','0','0','15000','3940000','0','0','0','3940000','RHM','T0075803','F3TE','0','0','-','0','1990000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YLAE-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='F3TE-YLAE-6-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225290921291','2025-12-29','1.970','2025-12-29','09:21:29','PLG0076019','3940000','3940000','0','3940000','3940000','kasir','2025-12-29 09:21:29','F22529092129');
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-12-29','F225290921291','2025-12-29','09:21:29','RHM','3940000','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-251229-0004','D','2025-12-29','09:21:29','kasir','PENJUALAN','F225290921291','4308104000','3940000','4312044000');
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 ('F225290936561','kasir','1',' MEF2 UB D5','TOKO','SMBK-F','F2E-YKAE-19-T','GL PIPA MODEL MATA VAR UB D56 8K ','OL ','4.950','1','100.00','5494000','0','0','15000','5519000','0','25000','0','5544000','RHM','T0074977','F2E','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YKAE-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.950',berat_jual_asli=berat_jual_asli+'4.950',stock_jual='1',berat_akhir=berat_akhir-'4.950',berat_akhir_asli=berat_akhir_asli-'4.950',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='F2E-YKAE-19-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225290936561','2025-12-29','4.950','2025-12-29','09:36:57','PLG0076020','5519000','5519000','25000','5544000','5544000','kasir','2025-12-29 09:36:56','F22529093656');
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-12-29','F225290936561','2025-12-29','09:36:57','RHM','5544000','25000');
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-251229-0005','D','2025-12-29','09:36:57','kasir','PENJUALAN','F225290936561','4312044000','5544000','4317588000');
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 ('F225291002041','kasir','1',' MEE1E CM 1','TOKO','SMBK-E','E1E-YLBX-48-T','CC MODEL SLEP CM 15 8K ','OL','0.530','1','100.00','588000','0','0','15000','596000','0','5000','0','601000','RTA','T0076033','E1E','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YLBX-48-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-12-29' AND kode_barang='E1E-YLBX-48-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 ('F225291002041','2025-12-29','0.530','2025-12-29','10:02:05','PLG0076021','596000','596000','5000','601000','601000','kasir','2025-12-29 10:02:04','F22529100204');
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-12-29','F225291002041','2025-12-29','10:02:05','RTA','601000','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-251229-0006','D','2025-12-29','10:02:05','kasir','PENJUALAN','F225291002041','4317588000','601000','4318189000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='601000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225291002041' 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 ('F225291002042','kasir',' 1',' MEE1E CM 1','TOKO','SMBK-E','E1E-YLBX-46-T','CC MODEL SLEP CM 15 8K ','OL','0.680','1','100.00','755000','0','0','15000','765000','0','5000','0','770000','RTA','T0076031','E1E','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YLBX-46-T' 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-12-29' AND kode_barang='E1E-YLBX-46-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 ('F225291002042','2025-12-29','0.680','2025-12-29','10:02:05','PLG0076022','765000','765000','5000','770000','770000','kasir','2025-12-29 10:02:04','F22529100204');
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-12-29','F225291002042','2025-12-29','10:02:05','RTA','770000','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-251229-0007','D','2025-12-29','10:02:05','kasir','PENJUALAN','F225291002042','4318189000','770000','4318959000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='770000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225291002042' 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 ('F225291002043','kasir',' 1',' MEE1E HT 1','TOKO','SMBK-E','E2E-YLBX-37-T','CC BANGKOK MATA SLEP HT 12 8K','OL','0.520','1','100.00','577000','0','0','15000','585000','0','5000','0','590000','RTA','T0076022','E2E','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YLBX-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='E2E-YLBX-37-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 ('F225291002043','2025-12-29','0.520','2025-12-29','10:02:05','PLG0076023','585000','585000','5000','590000','590000','kasir','2025-12-29 10:02:04','F22529100204');
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-12-29','F225291002043','2025-12-29','10:02:05','RTA','590000','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-251229-0008','D','2025-12-29','10:02:05','kasir','PENJUALAN','F225291002043','4318959000','590000','4319549000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='590000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225291002043' LIMIT 1;
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251229-0001','1','A1E-YLBD-124-0','1','0.600','0.600','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YLBD-124-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YLBD-124-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2025-12-29 10:06:43' WHERE kode_barang='A1E-YLBD-124-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YLBD-124-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-29 10:06:43','TOKO','SMBK-A','A1E','A1E-YLBD-124-0','1','0.600','0.600','1','0.600','0.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-YLBD-124-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YLBD-124-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251229-0001','2025-12-29','10:06','0.600','input','2025-12-29 10:06:43');
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 ('F225291010111','kasir','1',' MDE1D CM 1','TOKO','SMBK-E','E1D-YLAF-71-T','CC VELG POLOS SLEP CM 12 8K ','OL ','1.030','1','100.00','1123000','0','0','15000','1128000','0','5000','0','1133000','RHM','T0075891','E1D','0','0','-','0','1090000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YLAF-71-T' 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-12-29' AND kode_barang='E1D-YLAF-71-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 ('F225291010111','2025-12-29','1.030','2025-12-29','10:10:12','PLG0076024','1128000','1128000','5000','1133000','1133000','kasir','2025-12-29 10:10:11','F22529101011');
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-12-29','F225291010111','2025-12-29','10:10:12','RHM','1133000','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-251229-0009','D','2025-12-29','10:10:12','kasir','PENJUALAN','F225291010111','4319549000','1133000','4320682000');
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 ('F225291046471','kasir','1',' MEH1 HW ','TOKO','SMBK-H','H1E-YKBI-3-T','KL RANTAI HOLLOW MODEL CD VAR HW 8K ','OL','2.010','1','100.00','2231000','0','0','15000','2251000','0','10000','0','2261000','NS','T0075372','H1E','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YKBI-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='H1E-YKBI-3-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 ('F225291046471','2025-12-29','2.010','2025-12-29','10:46:47','PLG0076025','2251000','2251000','10000','2261000','2261000','kasir','2025-12-29 10:46:47','F22529104647');
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-12-29','F225291046471','2025-12-29','10:46:47','NS','2261000','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-251229-0010','D','2025-12-29','10:46:47','kasir','PENJUALAN','F225291046471','4320682000','2261000','4322943000');
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 ('F225291048441','kasir','1',' MEA1E LG ','TOKO','SMBK-A','A1E-YLBD-124-0','AT BANGKOK KLIP SLEP LG 8K ','OLSQWGA4','0.600','1','100.00','666000','0','0','15000','660000','0','43000','0','703000','TIN','00382859','A1E','0','0','-','1','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLBD-124-0' 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-12-29' AND kode_barang='A1E-YLBD-124-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 ('F225291048441','2025-12-29','0.600','2025-12-29','10:48:44','PLG0076026','660000','660000','43000','703000','703000','kasir','2025-12-29 10:48:44','F22529104844');
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-12-29','F225291048441','2025-12-29','10:48:44','TIN','703000','43000');
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-251229-0011','D','2025-12-29','10:48:44','kasir','PENJUALAN','F225291048441','4322943000','703000','4323646000');
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 ('F225291059471','kasir','1',' MEA1E X DG','TOKO','SMBK-A','A1E-YLBX-155-0','AT X BABY TINDIK DG 8K ','','0.520','1','100.00','577000','0','0','15000','577000','0','0','0','577000','TIN','00382035','A1E','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLBX-155-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='A1E-YLBX-155-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 ('F225291059471','2025-12-29','0.520','2025-12-29','10:59:47','PLG0076027','577000','577000','0','577000','577000','kasir','2025-12-29 10:59:47','F22529105947');
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-12-29','F225291059471','2025-12-29','10:59:47','TIN','577000','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-251229-0012','D','2025-12-29','10:59:47','kasir','PENJUALAN','F225291059471','4323646000','577000','4324223000');
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 ('F225291107451','kasir','1',' MDE1 CM 18','TOKO','SMBK-E','E1D-YDXI-23-T','CC MODEL C CM 18 8K ','OL','1.040','1','100.00','1134000','0','0','15000','1139000','0','5000','0','1144000','TIN','T0068546','E1D','0','0','-','0','1090000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YDXI-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='E1D-YDXI-23-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 ('F225291107451','2025-12-29','1.040','2025-12-29','11:07:46','PLG0076028','1139000','1139000','5000','1144000','1144000','kasir','2025-12-29 11:07:45','F22529110745');
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-12-29','F225291107451','2025-12-29','11:07:46','TIN','1144000','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-251229-0013','D','2025-12-29','11:07:46','kasir','PENJUALAN','F225291107451','4324223000','1144000','4325367000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1144000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225291107451' 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 ('F225291107452','kasir',' 1',' MDE2 AY 18','TOKO','SMBK-E','E2D-YHXE-71-T','CC MODEL PAKU MATA VAR AY 18 8K ','OL','1.250','1','100.00','1362000','0','0','15000','1369000','0','6000','0','1375000','TIN','T0071860','E2D','0','0','-','0','1090000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YHXE-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.250',berat_jual_asli=berat_jual_asli+'1.250',stock_jual='1',berat_akhir=berat_akhir-'1.250',berat_akhir_asli=berat_akhir_asli-'1.250',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='E2D-YHXE-71-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 ('F225291107452','2025-12-29','1.250','2025-12-29','11:07:46','PLG0076029','1369000','1369000','6000','1375000','1375000','kasir','2025-12-29 11:07:45','F22529110745');
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-12-29','F225291107452','2025-12-29','11:07:46','TIN','1375000','6000');
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-251229-0014','D','2025-12-29','11:07:46','kasir','PENJUALAN','F225291107452','4325367000','1375000','4326742000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1375000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225291107452' 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 ('F225291114491','kasir','1',' MFD1F BG 5','TOKO','SMBK-D','D1F-YLBX-71-T','LT MODEL BALET SLEP BG 8K','OL','0.560','1','100.00','633000','0','0','15000','641000','0','5000','0','646000','RTA','T0076056','D1F','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YLBX-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='D1F-YLBX-71-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 ('F225291114491','2025-12-29','0.560','2025-12-29','11:14:50','PLG0076030','641000','641000','5000','646000','646000','kasir','2025-12-29 11:14:49','F22529111449');
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-12-29','F225291114491','2025-12-29','11:14:50','RTA','646000','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-251229-0015','D','2025-12-29','11:14:50','kasir','PENJUALAN','F225291114491','4326742000','646000','4327388000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='646000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225291114491' 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 ('F225291114492','kasir',' 1',' MDD1 LT ','TOKO','SMBK-D','D1D-YLBD-2-T','LT MODEL FG SLEP LT 8K ','OL','1.330','1','100.00','1450000','0','0','15000','1463000','0','7000','0','1470000','RTA','T0076164','D1D','0','0','-','0','1090000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-YLBD-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.330',berat_jual_asli=berat_jual_asli+'1.330',stock_jual='1',berat_akhir=berat_akhir-'1.330',berat_akhir_asli=berat_akhir_asli-'1.330',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='D1D-YLBD-2-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 ('F225291114492','2025-12-29','1.330','2025-12-29','11:14:50','PLG0076031','1463000','1463000','7000','1470000','1470000','kasir','2025-12-29 11:14:49','F22529111449');
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-12-29','F225291114492','2025-12-29','11:14:50','RTA','1470000','7000');
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-251229-0016','D','2025-12-29','11:14:50','kasir','PENJUALAN','F225291114492','4327388000','1470000','4328858000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1470000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225291114492' 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 ('F225291114493','kasir',' 1',' MEF3 LT ','TOKO','SMBK-F','F3E-YLBC-19-T','GL TRIXIE MODEL HATI VAR LT 8K ','OL','1.160','1','100.00','1288000','0','0','15000','1299000','0','6000','0','1305000','RTA','T0076081','F3E','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLBC-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.160',berat_jual_asli=berat_jual_asli+'1.160',stock_jual='1',berat_akhir=berat_akhir-'1.160',berat_akhir_asli=berat_akhir_asli-'1.160',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='F3E-YLBC-19-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225291114493','2025-12-29','1.160','2025-12-29','11:14:50','PLG0076032','1299000','1299000','6000','1305000','1305000','kasir','2025-12-29 11:14:49','F22529111449');
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-12-29','F225291114493','2025-12-29','11:14:50','RTA','1305000','6000');
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-251229-0017','D','2025-12-29','11:14:50','kasir','PENJUALAN','F225291114493','4328858000','1305000','4330163000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1305000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225291114493' 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 ('F225291114494','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-YLAH-14-T','GL SANTA SERUT VAR HW 8K ','OL','1.800','1','100.00','1998000','0','0','15000','2016000','0','9000','0','2025000','RTA','T0075943','F3E','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLAH-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.800',berat_jual_asli=berat_jual_asli+'1.800',stock_jual='1',berat_akhir=berat_akhir-'1.800',berat_akhir_asli=berat_akhir_asli-'1.800',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='F3E-YLAH-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225291114494','2025-12-29','1.800','2025-12-29','11:14:50','PLG0076033','2016000','2016000','9000','2025000','2025000','kasir','2025-12-29 11:14:49','F22529111449');
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-12-29','F225291114494','2025-12-29','11:14:50','RTA','2025000','9000');
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-251229-0018','D','2025-12-29','11:14:50','kasir','PENJUALAN','F225291114494','4330163000','2025000','4332188000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2025000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225291114494' 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 ('F225291114495','kasir',' 1',' MEH1E KH 4','TOKO','SMBK-H','H1E-YLBX-29-T','KL RANTAI HOLLOW KH 42 8K ','OL','2.050','1','100.00','2275000','0','0','15000','2296000','0','10000','0','2306000','RTA','T0076014','H1E','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLBX-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='H1E-YLBX-29-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 ('F225291114495','2025-12-29','2.050','2025-12-29','11:14:50','PLG0076034','2296000','2296000','10000','2306000','2306000','kasir','2025-12-29 11:14:49','F22529111449');
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-12-29','F225291114495','2025-12-29','11:14:50','RTA','2306000','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-251229-0019','D','2025-12-29','11:14:50','kasir','PENJUALAN','F225291114495','4332188000','2306000','4334494000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2306000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225291114495' 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 ('F225291114496','kasir',' 1',' MDA1 HW ','TOKO','SMBK-A','A1D-YLAX-2-T','AT MODEL ITALY VAR HW 8K ','OL','1.170','1','100.00','1275000','0','0','15000','1287000','0','6000','0','1293000','RTA','T0075586','A1D','0','0','-','0','1090000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YLAX-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.170',berat_jual_asli=berat_jual_asli+'1.170',stock_jual='1',berat_akhir=berat_akhir-'1.170',berat_akhir_asli=berat_akhir_asli-'1.170',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='A1D-YLAX-2-T' 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 ('F225291114496','2025-12-29','1.170','2025-12-29','11:14:50','PLG0076035','1287000','1287000','6000','1293000','1293000','kasir','2025-12-29 11:14:49','F22529111449');
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-12-29','F225291114496','2025-12-29','11:14:50','RTA','1293000','6000');
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-251229-0020','D','2025-12-29','11:14:50','kasir','PENJUALAN','F225291114496','4334494000','1293000','4335787000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1293000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225291114496' 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 ('F225291115551','kasir','1',' MDE1 HW 15','TOKO','SMBK-E','E1D-YGBB-138-T','CC MODEL SLEP VAR HW 15 8K ','','1.010','1','100.00','1101000','0','0','15000','1101000','0','0','0','1101000','TIN','T0071410','E1D','0','0','-','0','1090000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YGBB-138-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='E1D-YGBB-138-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 ('F225291115551','2025-12-29','1.010','2025-12-29','11:15:55','PLG0076036','1101000','1101000','0','1101000','1101000','kasir','2025-12-29 11:15:55','F22529111555');
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-12-29','F225291115551','2025-12-29','11:15:55','TIN','1101000','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-251229-0021','D','2025-12-29','11:15:55','kasir','PENJUALAN','F225291115551','4335787000','1101000','4336888000');
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 ('F225291119031','kasir','1',' MEE1 X 50K','TOKO','SMBK-E','E1E-YLBC-73-T','CC X CERAMIC GOLD MODEL UB 14 8K ','OL','0.480','1','100.00','533000','0','0','15000','540000','0','55000','0','595000','TIN','T0076135','E1E','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YLBC-73-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='E1E-YLBC-73-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 ('F225291119031','2025-12-29','0.480','2025-12-29','11:19:03','PLG0076037','540000','540000','55000','595000','595000','kasir','2025-12-29 11:19:03','F22529111903');
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-12-29','F225291119031','2025-12-29','11:19:03','TIN','595000','55000');
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-251229-0022','D','2025-12-29','11:19:03','kasir','PENJUALAN','F225291119031','4336888000','595000','4337483000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='595000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225291119031' 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 ('F225291119032','kasir',' 1',' MEF3 LT ','TOKO','SMBK-F','F3E-YKBH-13-T','GL MODEL VERONA VAR LT 8K ','OL','1.080','1','100.00','1199000','0','0','15000','1210000','0','5000','0','1215000','TIN','T0075245','F3E','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKBH-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='F3E-YKBH-13-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225291119032','2025-12-29','1.080','2025-12-29','11:19:03','PLG0076038','1210000','1210000','5000','1215000','1215000','kasir','2025-12-29 11:19:03','F22529111903');
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-12-29','F225291119032','2025-12-29','11:19:03','TIN','1215000','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-251229-0023','D','2025-12-29','11:19:03','kasir','PENJUALAN','F225291119032','4337483000','1215000','4338698000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1215000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225291119032' 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 ('F225291119033','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-YLXD-30-T','GL RANTE LEMES HW 8K ','OL','1.450','1','100.00','1609000','0','0','15000','1624000','0','7000','0','1631000','TIN','T0075498','F3E','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLXD-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='F3E-YLXD-30-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225291119033','2025-12-29','1.450','2025-12-29','11:19:03','PLG0076039','1624000','1624000','7000','1631000','1631000','kasir','2025-12-29 11:19:03','F22529111903');
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-12-29','F225291119033','2025-12-29','11:19:03','TIN','1631000','7000');
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-251229-0024','D','2025-12-29','11:19:03','kasir','PENJUALAN','F225291119033','4338698000','1631000','4340329000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1631000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225291119033' 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 ('F225291124391','kasir','1',' MHH1 UB 42','TOKO','SMBK-H','H1H-YJCX-22-T','KL LONG LING UB 42CM 8K ','OL','2.070','1','100.00','2422000','0','0','15000','2443000','0','10000','0','2453000','NS','T0074726','H1H','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1H-YJCX-22-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='H1H-YJCX-22-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 ('F225291124391','2025-12-29','2.070','2025-12-29','11:24:39','PLG0076040','2443000','2443000','10000','2453000','2453000','kasir','2025-12-29 11:24:39','F22529112439');
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-12-29','F225291124391','2025-12-29','11:24:39','NS','2453000','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-251229-0025','D','2025-12-29','11:24:39','kasir','PENJUALAN','F225291124391','4340329000','2453000','4342782000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2453000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225291124391' 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 ('F225291124392','kasir',' 1',' MFD1F BG 5','TOKO','SMBK-D','D1F-YLAF-107-T','LT MODEL SLEP PASIR BG 8K ','OL','0.800','1','100.00','904000','0','0','15000','916000','0','5000','0','921000','NS','T0075927','D1F','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YLAF-107-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='D1F-YLAF-107-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 ('F225291124392','2025-12-29','0.800','2025-12-29','11:24:39','PLG0076041','916000','916000','5000','921000','921000','kasir','2025-12-29 11:24:39','F22529112439');
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-12-29','F225291124392','2025-12-29','11:24:39','NS','921000','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-251229-0026','D','2025-12-29','11:24:39','kasir','PENJUALAN','F225291124392','4342782000','921000','4343703000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='921000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225291124392' 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 ('F225291156021','kasir','1',' MEE1 HTM 1','TOKO','SMBK-E','E1E-YKBI-24-T','CC PIPA MODEL PITA VAR HTM 13 8K ','','0.530','1','100.00','588000','0','0','15000','588000','0','0','0','588000','RTA','T0075393','E1E','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YKBI-24-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-12-29' AND kode_barang='E1E-YKBI-24-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 ('F225291156021','2025-12-29','0.530','2025-12-29','11:56:03','PLG0076042','588000','588000','0','588000','588000','kasir','2025-12-29 11:56:02','F22529115602');
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-12-29','F225291156021','2025-12-29','11:56:03','RTA','588000','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-251229-0027','D','2025-12-29','11:56:03','kasir','PENJUALAN','F225291156021','4343703000','588000','4344291000');
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 ('F225291157501','kasir','1',' MFD1F BG 5','TOKO','SMBK-D','D1F-YLAF-105-T','LT MODEL SLEP PASIR BG 8K ','OL','0.800','1','100.00','904000','0','0','15000','916000','0','5000','0','921000','NS','T0075925','D1F','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YLAF-105-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='D1F-YLAF-105-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 ('F225291157501','2025-12-29','0.800','2025-12-29','11:57:50','PLG0076043','916000','916000','5000','921000','921000','kasir','2025-12-29 11:57:50','F22529115750');
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-12-29','F225291157501','2025-12-29','11:57:50','NS','921000','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-251229-0028','D','2025-12-29','11:57:50','kasir','PENJUALAN','F225291157501','4344291000','921000','4345212000');
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 ('F225291159501','kasir','1',' MFH1 X YT ','TOKO','SMBK-H','H1F-YJXA-337-0','KL X TRIXIE NAGITA HURUF Y YT 8K ','OL','1.610','1','100.00','1819000','0','0','15000','1833000','0','10000','0','1843000','TIN','00371582','H1F','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YJXA-337-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-12-29' AND kode_barang='H1F-YJXA-337-0' 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 ('F225291159501','2025-12-29','1.610','2025-12-29','11:59:50','PLG0076044','1833000','1833000','10000','1843000','1843000','kasir','2025-12-29 11:59:50','F22529115950');
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-12-29','F225291159501','2025-12-29','11:59:50','TIN','1843000','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-251229-0029','D','2025-12-29','11:59:50','kasir','PENJUALAN','F225291159501','4345212000','1843000','4347055000');
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 ('F225291209271','kasir','1',' TDE1 UB 11','TOKO','TBK-E','E1TD-YHBG-9-T','CC MODEL HATI SLEP VAR UB 11 17K ','OL','1.020','1','100.00','2020000','0','0','15000','2028000','0','7000','0','2035000','RTA','T0072601','E1TD','0','0','-','0','1980000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YHBG-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='E1TD-YHBG-9-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225291209271','2025-12-29','1.020','2025-12-29','12:09:28','PLG0076045','2028000','2028000','7000','2035000','2035000','kasir','2025-12-29 12:09:27','F22529120927');
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-12-29','F225291209271','2025-12-29','12:09:28','RTA','2035000','7000');
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-251229-0030','D','2025-12-29','12:09:28','kasir','PENJUALAN','F225291209271','4347055000','2035000','4349090000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2035000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225291209271' 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 ('F225291209272','kasir',' 1',' TGH1 UB 42','TOKO','TBK-H','H1TG-YHBG-39-T','KL MILANO UB 42CM 17K ','OL','2.930','1','100.00','5977000','0','0','15000','6000000','0','21000','0','6021000','RTA','T0072631','H1TG','0','0','-','0','2040000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TG-YHBG-39-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.930',berat_jual_asli=berat_jual_asli+'2.930',stock_jual='1',berat_akhir=berat_akhir-'2.930',berat_akhir_asli=berat_akhir_asli-'2.930',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='H1TG-YHBG-39-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225291209272','2025-12-29','2.930','2025-12-29','12:09:28','PLG0076046','6000000','6000000','21000','6021000','6021000','kasir','2025-12-29 12:09:27','F22529120927');
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-12-29','F225291209272','2025-12-29','12:09:28','RTA','6021000','21000');
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-251229-0031','D','2025-12-29','12:09:28','kasir','PENJUALAN','F225291209272','4349090000','6021000','4355111000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='6021000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225291209272' 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 ('F225291209273','kasir',' 1',' TDD2 X CM ','TOKO','TBK-D','D2TD-YIXD-57-T','LT X MODEL MATA VAR CM 17K ','OL','1.280','1','100.00','2534000','0','0','15000','2544000','0','10000','0','2554000','RTA','T0072909','D2TD','0','0','-','0','1980000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2TD-YIXD-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='D2TD-YIXD-57-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225291209273','2025-12-29','1.280','2025-12-29','12:09:28','PLG0076047','2544000','2544000','10000','2554000','2554000','kasir','2025-12-29 12:09:27','F22529120927');
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-12-29','F225291209273','2025-12-29','12:09:28','RTA','2554000','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-251229-0032','D','2025-12-29','12:09:28','kasir','PENJUALAN','F225291209273','4355111000','2554000','4357665000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2554000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225291209273' 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 ('F225291210441','kasir','1',' MFB1 LG ','TOKO','SMBK-B','B1F-YJXD-67-T','GW TOGE MODEL MATA VAR LG 8K ','OL','0.510','1','100.00','576000','0','0','15000','584000','0','5000','0','589000','RTA','T0073881','B1F','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YJXD-67-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='B1F-YJXD-67-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 ('F225291210441','2025-12-29','0.510','2025-12-29','12:10:44','PLG0076048','584000','584000','5000','589000','589000','kasir','2025-12-29 12:10:44','F22529121044');
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-12-29','F225291210441','2025-12-29','12:10:44','RTA','589000','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-251229-0033','D','2025-12-29','12:10:44','kasir','PENJUALAN','F225291210441','4357665000','589000','4358254000');
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 ('F225291227161','kasir','1',' TDE2 X LG ','TOKO','TBK-E','E2TD-YLAA-37-T','CC X COR MODEL MATA 14 LG 17K ','OL','0.850','1','100.00','1683000','0','0','15000','1692000','0','7000','0','1699000','RTA','T0075695','E2TD','0','0','-','0','1980000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YLAA-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='E2TD-YLAA-37-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225291227161','2025-12-29','0.850','2025-12-29','12:27:16','PLG0076049','1692000','1692000','7000','1699000','1699000','kasir','2025-12-29 12:27:16','F22529122716');
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-12-29','F225291227161','2025-12-29','12:27:16','RTA','1699000','7000');
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-251229-0034','D','2025-12-29','12:27:16','kasir','PENJUALAN','F225291227161','4358254000','1699000','4359953000');
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 ('F225290206291','kasir','1',' MEH1 10K Y','TOKO','SMBK-H','H1E-YLBC-7-T','KL TRIXIE MODEL BUNGA CLOVER VAR YT 8K','OL','1.800','1','100.00','1998000','0','0','15000','2015000','0','10000','0','2025000','RTA','T0076069','H1E','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLBC-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.800',berat_jual_asli=berat_jual_asli+'1.800',stock_jual='1',berat_akhir=berat_akhir-'1.800',berat_akhir_asli=berat_akhir_asli-'1.800',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='H1E-YLBC-7-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 ('F225290206291','2025-12-29','1.800','2025-12-29','14:06:29','PLG0076050','2015000','2015000','10000','2025000','2025000','kasir','2025-12-29 14:06:29','F22529020629');
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-12-29','F225290206291','2025-12-29','14:06:29','RTA','2025000','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-251229-0035','D','2025-12-29','14:06:29','kasir','PENJUALAN','F225290206291','4359953000','2025000','4361978000');
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 ('F225290224341','kasir','1',' MEE2E HT 1','TOKO','SMBK-E','E2E-YLBX-32-T','CC BANGKOK MATA SLEP HT 14 8K ','OL','0.510','1','100.00','566000','0','0','15000','574000','0','5000','0','579000','RTA','T0076017','E2E','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YLBX-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='E2E-YLBX-32-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 ('F225290224341','2025-12-29','0.510','2025-12-29','14:24:34','PLG0076051','574000','574000','5000','579000','579000','kasir','2025-12-29 14:24:34','F22529022434');
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-12-29','F225290224341','2025-12-29','14:24:34','RTA','579000','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-251229-0036','D','2025-12-29','14:24:34','kasir','PENJUALAN','F225290224341','4361978000','579000','4362557000');
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 ('F225290230451','kasir','1',' MEF1 UB D5','TOKO','SMBK-F','F1E-YLBC-41-T','GL OVAL MODEL C UB D54 8K ','OL','2.230','1','100.00','2475000','0','0','15000','2498000','0','11000','0','2509000','TIN','T0076103','F1E','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLBC-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.230',berat_jual_asli=berat_jual_asli+'2.230',stock_jual='1',berat_akhir=berat_akhir-'2.230',berat_akhir_asli=berat_akhir_asli-'2.230',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='F1E-YLBC-41-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225290230451','2025-12-29','2.230','2025-12-29','14:30:46','PLG0076052','2498000','2498000','11000','2509000','2509000','kasir','2025-12-29 14:30:45','F22529023045');
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-12-29','F225290230451','2025-12-29','14:30:46','TIN','2509000','11000');
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-251229-0037','D','2025-12-29','14:30:46','kasir','PENJUALAN','F225290230451','4362557000','2509000','4365066000');
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-00004958','X-00004958','AT MODEL MATA VAR LG 8K','GR','---','A1E','BELI','BELI001','145000','2025-12-29','0.180','1','kasir','2025-12-29 14:54:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00004958','X-00004958');
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-251229-0001','F224241056041','NS','1','BELI','BELI001','A1E', 'X-00004958', 'AT MODEL MATA VAR LG 8K','0.560','0.180','100.00','330000','145000','805556','1110000','1','145000','145000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.180',berat_beli_asli=berat_beli_asli+'0.180',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.180',berat_akhir_asli=berat_akhir_asli+'0.180',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-29' 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-251229-0001','2025-12-29','2025-12-29','14:54:42','NS','---','0.180','145000','145000','145000','145000','145000','kasir','2025-12-29 14:54:42','FB-251229-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251229-0001','LESTA','DS SOOKO 2/1','','','08570641260','kasir','2025-12-29 14:54:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-29' 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-251229-0038','K','2025-12-29','14:54:42','kasir','PEMBELIAN UMUM','FB-251229-0001','4365066000','145000','4364921000');
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-00004959','X-00004959','CC X MODEL MATA KH 18 8K','GR','---','E2D','BELI','BELI001','1472000','2025-12-29','2.000','1','kasir','2025-12-29 14:54:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00004959','X-00004959');
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-251229-0002','F225301035041','NS','2','BELI','BELI001','E2D', 'X-00004959', 'CC X MODEL MATA KH 18 8K','2.000','2.000','100.00','1600000','1472000','736000','1090000','1','1472000','1472000','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-12-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251229-0002','2025-12-29','2025-12-29','14:54:42','NS','---','2.000','1472000','1472000','1472000','1472000','1472000','kasir','2025-12-29 14:54:42','FB-251229-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251229-0002','BU SRI HANDAYANI','PIJERAN. SIMAN','','','082234784488','kasir','2025-12-29 14:54:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-29' 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-251229-0039','K','2025-12-29','14:54:42','kasir','PEMBELIAN UMUM','FB-251229-0002','4364921000','1472000','4363449000');
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-00004960','X-00004960','GL HARLEY ANAK PLAT BONEKA CAT HW','GR','---','F3TE','BELI','BELI001','4880000','2025-12-29','2.950','1','kasir','2025-12-29 14:57:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3TE','X-00004960','X-00004960');
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-251229-0003','F223190310421','NS','1','BELI','BELI001','F3TE', 'X-00004960', 'GL HARLEY ANAK PLAT BONEKA CAT HW','3.230','2.950','100.00','2600000','4880000','1654237','1990000','1','4880000','4880000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.950',berat_beli_asli=berat_beli_asli+'2.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.950',berat_akhir_asli=berat_akhir_asli+'2.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3TE' 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-251229-0003','2025-12-29','2025-12-29','14:57:40','NS','---','2.950','4880000','4880000','4880000','4880000','4880000','kasir','2025-12-29 14:57:41','FB-251229-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251229-0003','ADIBAH','NGADIROJO PLOSO','','','087751871360','kasir','2025-12-29 14:57:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-29' 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-251229-0040','K','2025-12-29','14:57:40','kasir','PEMBELIAN UMUM','FB-251229-0003','4363449000','4880000','4358569000');
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-00004961','X-00004961','AT MODEL GYPSY SLEP LG','GR','---','A1TE','BELI','BELI001','810000','2025-12-29','0.490','1','kasir','2025-12-29 14:57:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1TE','X-00004961','X-00004961');
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-251229-0004','F222081216571','NS','2','BELI','BELI001','A1TE', 'X-00004961', 'AT MODEL GYPSY SLEP LG','1.080','0.490','100.00','790000','810000','1653061','1990000','1','810000','810000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.490',berat_beli_asli=berat_beli_asli+'0.490',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.490',berat_akhir_asli=berat_akhir_asli+'0.490',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1TE' 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-251229-0004','2025-12-29','2025-12-29','14:57:40','NS','---','0.490','810000','810000','810000','810000','810000','kasir','2025-12-29 14:57:41','FB-251229-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251229-0004','ADIBA','NGADIROJO','','','','kasir','2025-12-29 14:57:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-29' 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-251229-0041','K','2025-12-29','14:57:40','kasir','PEMBELIAN UMUM','FB-251229-0004','4358569000','810000','4357759000');
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-00004962','X-00004962','AT KLIP MODEL MATA VAR LG 17K','GR','---','A1TE','BELI','BELI001','1340000','2025-12-29','0.810','1','kasir','2025-12-29 14:59:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1TE','X-00004962','X-00004962');
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-251229-0005','F224140313441','RHM','1','BELI','BELI001','A1TE', 'X-00004962', 'AT KLIP MODEL MATA VAR LG 17K','1.010','0.810','100.00','1040000','1340000','1654321','1990000','1','1340000','1340000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.810',berat_beli_asli=berat_beli_asli+'0.810',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.810',berat_akhir_asli=berat_akhir_asli+'0.810',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1TE' 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-251229-0005','2025-12-29','2025-12-29','14:59:22','RHM','---','0.810','1340000','1340000','1340000','1340000','1340000','kasir','2025-12-29 14:59:23','FB-251229-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251229-0005','ENI SUSANTI','MAGETAN','','','','kasir','2025-12-29 14:59:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-29' 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-251229-0042','K','2025-12-29','14:59:22','kasir','PEMBELIAN UMUM','FB-251229-0005','4357759000','1340000','4356419000');
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-00004963','X-00004963','CC X MODEL SOLITAIRE CM 14 8K','GR','---','E2D','BELI','BELI001','767000','2025-12-29','0.820','1','kasir','2025-12-29 15:00:22');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00004963','X-00004963');
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-251229-0006','F225230253442','TIN','1','BELI','BELI001','E2D', 'X-00004963', 'CC X MODEL SOLITAIRE CM 14 8K','0.820','0.820','100.00','853000','767000','935366','1090000','1','767000','767000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.820',berat_beli_asli=berat_beli_asli+'0.820',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.820',berat_akhir_asli=berat_akhir_asli+'0.820',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251229-0006','2025-12-29','2025-12-29','15:00:21','TIN','---','0.820','767000','767000','767000','767000','767000','kasir','2025-12-29 15:00:22','FB-251229-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251229-0006','RATNA','BULU 1/1 SAMBIT','','','','kasir','2025-12-29 15:00:22');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-29' 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-251229-0043','K','2025-12-29','15:00:21','kasir','PEMBELIAN UMUM','FB-251229-0006','4356419000','767000','4355652000');
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-00004964','X-00004964','GL JEDAR SERUT BUNGA ARESO VAR HW 8K','GR','---','F3F','BELI','BELI001','1449000','2025-12-29','1.470','1','kasir','2025-12-29 15:00:22');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00004964','X-00004964');
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-251229-0007','F225200233062','TIN','2','BELI','BELI001','F3F', 'X-00004964', 'GL JEDAR SERUT BUNGA ARESO VAR HW 8K','1.470','1.470','100.00','1610000','1449000','985714','1130000','1','1449000','1449000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.470',berat_beli_asli=berat_beli_asli+'1.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.470',berat_akhir_asli=berat_akhir_asli+'1.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251229-0007','2025-12-29','2025-12-29','15:00:21','TIN','---','1.470','1449000','1449000','1449000','1449000','1449000','kasir','2025-12-29 15:00:22','FB-251229-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251229-0007','YAYUK','NDURU 1/1 SAMBIT','','','','kasir','2025-12-29 15:00:22');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-29' 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-251229-0044','K','2025-12-29','15:00:21','kasir','PEMBELIAN UMUM','FB-251229-0007','4355652000','1449000','4354203000');
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-00004965','X-00004965','GL RANTRAI HOLLOW PLAT SLEP HW 8K','GR','---','F3E','BELI','BELI001','1764000','2025-12-29','1.940','1','kasir','2025-12-29 15:00:22');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00004965','X-00004965');
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-251229-0008','F225090236591','TIN','3','BELI','BELI001','F3E', 'X-00004965', 'GL RANTRAI HOLLOW PLAT SLEP HW 8K','1.940','1.940','100.00','1960000','1764000','909278','1110000','1','1764000','1764000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.940',berat_beli_asli=berat_beli_asli+'1.940',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.940',berat_akhir_asli=berat_akhir_asli+'1.940',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-29' 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-251229-0008','2025-12-29','2025-12-29','15:00:21','TIN','---','1.940','1764000','1764000','1764000','1764000','1764000','kasir','2025-12-29 15:00:22','FB-251229-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251229-0008','RATNA','BULU 1/1 SAMBIT','','','085230772032','kasir','2025-12-29 15:00:22');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-29' 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-251229-0045','K','2025-12-29','15:00:21','kasir','PEMBELIAN UMUM','FB-251229-0008','4354203000','1764000','4352439000');
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-00004966','X-00004966','GL TIFF MODEL SLEP BG 8K','GR','---','F3F','BELI','BELI001','2061000','2025-12-29','2.120','1','kasir','2025-12-29 15:00:22');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00004966','X-00004966');
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-251229-0009','F225250259111','TIN','4','BELI','BELI001','F3F', 'X-00004966', 'GL TIFF MODEL SLEP BG 8K','2.120','2.120','100.00','2290000','2061000','972170','1130000','1','2061000','2061000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.120',berat_beli_asli=berat_beli_asli+'2.120',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.120',berat_akhir_asli=berat_akhir_asli+'2.120',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251229-0009','2025-12-29','2025-12-29','15:00:21','TIN','---','2.120','2061000','2061000','2061000','2061000','2061000','kasir','2025-12-29 15:00:22','FB-251229-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251229-0009','RATNA','SAMBIT','','','','kasir','2025-12-29 15:00:22');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-29' 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-251229-0046','K','2025-12-29','15:00:21','kasir','PEMBELIAN UMUM','FB-251229-0009','4352439000','2061000','4350378000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225290206291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225290206291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225290206291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225290224341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225290224341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225290224341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225290230451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225290230451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225290230451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225290853421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225290853421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225290853421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225290912001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225290912001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225290912001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225290921291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225290921291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225290921291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225290936561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225290936561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225290936561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291002041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291002041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291002041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291002042' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291002042' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291002042';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291002043' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291002043' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291002043';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291010111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291010111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291010111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291046471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291046471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291046471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291048441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291048441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291048441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291059471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291059471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291059471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291107451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291107451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291107451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291107452' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291107452' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291107452';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291114491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291114491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291114491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291114492' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291114492' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291114492';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291114493' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291114493' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291114493';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291114494' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291114494' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291114494';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291114495' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291114495' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291114495';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291114496' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291114496' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291114496';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291115551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291115551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291115551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291119031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291119031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291119031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291119032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291119032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291119032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291119033' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291119033' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291119033';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291124391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291124391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291124391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291124392' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291124392' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291124392';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291156021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291156021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291156021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291157501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291157501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291157501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291159501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291159501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291159501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291209271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291209271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291209271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291209272' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291209272' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291209272';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291209273' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291209273' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291209273';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291210441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291210441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291210441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225291227161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225291227161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225291227161';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251229-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251229-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251229-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251229-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251229-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251229-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251229-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251229-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251229-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251229-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251229-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251229-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251229-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251229-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251229-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251229-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251229-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251229-0009';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00004967','X-00004967','GL HARLEY ANAK PLAT BONEKA CAT HW','GR','---','F2TE','BELI','BELI001','4882000','2025-12-29','2.950','1','kasir','2025-12-29 15:05:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2TE','X-00004967','X-00004967');
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-251229-0010','F223190310421','NS','1','BELI','BELI001','F2TE', 'X-00004967', 'GL HARLEY ANAK PLAT BONEKA CAT HW','3.230','2.950','100.00','2600000','4882000','1654915','1990000','1','4882000','4882000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.950',berat_beli_asli=berat_beli_asli+'2.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.950',berat_akhir_asli=berat_akhir_asli+'2.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2TE' 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-251229-0010','2025-12-29','2025-12-29','15:05:47','NS','---','2.950','4882000','4882000','4882000','4882000','4882000','kasir','2025-12-29 15:05:48','FB-251229-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251229-0010','ADIBAH','NGADIROJO PLOSO','','','087751871360','kasir','2025-12-29 15:05:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-29' 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-251229-0048','K','2025-12-29','15:05:47','kasir','PEMBELIAN UMUM','FB-251229-0010','4355258000','4882000','4350376000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251229-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251229-0010';
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 ('F225290351111','kasir','1',' MEH1E KH 4','TOKO','SMBK-H','H1E-YLBX-27-T','KL SANTA KH 42 8K ','','3.050','1','100.00','3385000','0','0','15000','3386000','0','0','0','3386000','RTA','T0076012','H1E','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2025-12-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLBX-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2025-12-29' AND kode_barang='H1E-YLBX-27-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 ('F225290351111','2025-12-29','3.050','2025-12-29','15:51:12','PLG0076053','3386000','3386000','0','3386000','3386000','kasir','2025-12-29 15:51:11','F22529035111');
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-12-29','F225290351111','2025-12-29','15:51:12','RTA','3386000','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-251229-0049','D','2025-12-29','15:51:12','kasir','PENJUALAN','F225290351111','4350376000','3386000','4353762000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225290351111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225290351111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225290351111';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-30','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-29';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-29';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-29';
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-12-29' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-29';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-29';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-29';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-29';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-30' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-29' 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-251230-0001','D','2025-12-30','16:15:33','SYSTEM','SALDO AWAL','SALDO AWAL','0','4353762000','4353762000');
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-251230-0001','D','2025-12-30','16:15:33','BCA','SALDO AWAL','SALDO AWAL','0','4218285888','4218285888');
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-251230-0001','D','2025-12-30','16:15:33','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-251230-0001','D','2025-12-30','16:15:33','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-251230-0001','D','2025-12-30','16:15:33','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-251230-0001','D','2025-12-30','16:15:33','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2025-12-30';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251230-0001','1','E1E-YLXH-152-0','1','0.530','0.530','TOKO','SBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YLXH-152-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YLXH-152-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-12-30 16:35:33' WHERE kode_barang='E1E-YLXH-152-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YLXH-152-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-30 16:35:33','TOKO','SMBK-E','E1E','E1E-YLXH-152-0','1','0.530','0.530','1','0.530','0.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-YLXH-152-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YLXH-152-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251230-0001','1','E1E-YLXH-153-0','1','0.530','0.530','TOKO','SBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YLXH-153-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YLXH-153-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-12-30 16:35:33' WHERE kode_barang='E1E-YLXH-153-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YLXH-153-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-30 16:35:33','TOKO','SMBK-E','E1E','E1E-YLXH-153-0','1','0.530','0.530','1','0.530','0.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-YLXH-153-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YLXH-153-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251230-0001','2025-12-30','16:35','1.060','input','2025-12-29 16:35:33');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251230-0001','1','A1E-YLBI-17-0','1','0.560','0.560','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YLBI-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YLBI-17-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2025-12-30 17:34:15' WHERE kode_barang='A1E-YLBI-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YLBI-17-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-30 17:34:15','TOKO','SMBK-A','A1E','A1E-YLBI-17-0','1','0.560','0.560','1','0.560','0.560','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-YLBI-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YLBI-17-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251230-0001','1','A1E-YLBI-26-0','1','0.570','0.570','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YLBI-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YLBI-26-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2025-12-30 17:34:15' WHERE kode_barang='A1E-YLBI-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YLBI-26-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-30 17:34:15','TOKO','SMBK-A','A1E','A1E-YLBI-26-0','1','0.570','0.570','1','0.570','0.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-YLBI-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YLBI-26-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251230-0001','1','A1D-YLBI-31-0','1','0.950','0.950','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-YLBI-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-YLBI-31-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2025-12-30 17:34:15' WHERE kode_barang='A1D-YLBI-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-YLBI-31-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-30 17:34:15','TOKO','SMBK-A','A1D','A1D-YLBI-31-0','1','0.950','0.950','1','0.950','0.950','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-YLBI-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-YLBI-31-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251230-0001','1','A1D-YLBI-34-0','1','1.110','1.110','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-YLBI-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-YLBI-34-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2025-12-30 17:34:15' WHERE kode_barang='A1D-YLBI-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-YLBI-34-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-30 17:34:15','TOKO','SMBK-A','A1D','A1D-YLBI-34-0','1','1.110','1.110','1','1.110','1.110','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-YLBI-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-YLBI-34-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251230-0001','2025-12-30','17:34','3.190','input','2025-12-29 17:34:14');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251230-0001','1','B1E-YLBI-52-0','1','0.570','0.570','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-YLBI-52-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-YLBI-52-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-12-30 17:34:29' WHERE kode_barang='B1E-YLBI-52-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-YLBI-52-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-30 17:34:29','TOKO','SMBK-B','B1E','B1E-YLBI-52-0','1','0.570','0.570','1','0.570','0.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-YLBI-52-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-YLBI-52-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251230-0001','2025-12-30','17:34','0.570','input','2025-12-29 17:34:29');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251230-0001','1','D2E-YLBI-102-0','1','0.500','0.500','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-YLBI-102-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-YLBI-102-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-12-30 17:34:41' WHERE kode_barang='D2E-YLBI-102-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-YLBI-102-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-30 17:34:41','TOKO','SMBK-D','D2E','D2E-YLBI-102-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-YLBI-102-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-YLBI-102-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251230-0001','1','D2E-YLBI-103-0','1','0.530','0.530','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-YLBI-103-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-YLBI-103-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-12-30 17:34:41' WHERE kode_barang='D2E-YLBI-103-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-YLBI-103-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-30 17:34:41','TOKO','SMBK-D','D2E','D2E-YLBI-103-0','1','0.530','0.530','1','0.530','0.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-YLBI-103-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-YLBI-103-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251230-0001','2025-12-30','17:34','1.030','input','2025-12-29 17:34:41');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251230-0001','1','F3E-YLBI-185-0','1','1.700','1.700','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YLBI-185-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YLBI-185-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2025-12-30 17:34:54' WHERE kode_barang='F3E-YLBI-185-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YLBI-185-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-30 17:34:54','TOKO','SMBK-F','F3E','F3E-YLBI-185-0','1','1.700','1.700','1','1.700','1.700','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-YLBI-185-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YLBI-185-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251230-0001','1','F3E-YLBI-186-0','1','1.720','1.720','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YLBI-186-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YLBI-186-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2025-12-30 17:34:54' WHERE kode_barang='F3E-YLBI-186-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YLBI-186-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-30 17:34:54','TOKO','SMBK-F','F3E','F3E-YLBI-186-0','1','1.720','1.720','1','1.720','1.720','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-YLBI-186-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YLBI-186-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251230-0001','2025-12-30','17:34','3.420','input','2025-12-29 17:34:53');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251230-0001','1','H1E-YLBI-244-0','1','2.320','2.320','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YLBI-244-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YLBI-244-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-12-30 17:35:08' WHERE kode_barang='H1E-YLBI-244-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YLBI-244-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-30 17:35:08','TOKO','SMBK-H','H1E','H1E-YLBI-244-0','1','2.320','2.320','1','2.320','2.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-YLBI-244-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YLBI-244-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251230-0001','1','H1E-YLBI-245-0','1','2.040','2.040','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YLBI-245-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YLBI-245-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-12-30 17:35:08' WHERE kode_barang='H1E-YLBI-245-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YLBI-245-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-30 17:35:08','TOKO','SMBK-H','H1E','H1E-YLBI-245-0','1','2.040','2.040','1','2.040','2.040','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-YLBI-245-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YLBI-245-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251230-0001','1','H3J-YLBI-246-0','1','2.800','2.800','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H3J-YLBI-246-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H3J-YLBI-246-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-12-30 17:35:08' WHERE kode_barang='H3J-YLBI-246-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H3J-YLBI-246-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-30 17:35:08','TOKO','SMBK-H','H3J','H3J-YLBI-246-0','1','2.800','2.800','1','2.800','2.800','100.00');
DELETE FROM tm_dept WHERE kode_dept='H3J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H3J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H3J-YLBI-246-0';
DELETE FROM tm_barang_export WHERE kode_barang='H3J-YLBI-246-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251230-0001','2025-12-30','17:35','7.160','input','2025-12-29 17:35:07');