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 ('F225240914371','kasir','1',' TEF3 UB ','TOKO','TBK-F','F3TE-YGBI-130-T','GL MODEL FANCY CAPELA VAR UB 17K ','','2.600','1','100.00','5200000','0','0','15000','5175000','0','0','0','5175000','RTA','T0071663','F3TE','0','0','-','1','2000000');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YGBI-130-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.600',berat_jual_asli=berat_jual_asli+'2.600',stock_jual='1',berat_akhir=berat_akhir-'2.600',berat_akhir_asli=berat_akhir_asli-'2.600',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='F3TE-YGBI-130-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 ('F225240914371','2025-12-24','2.600','2025-12-24','09:14:37','PLG0075914','5175000','5175000','0','5175000','5175000','kasir','2025-12-24 09:14:37','F22524091437');
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-24','F225240914371','2025-12-24','09:14:37','RTA','5175000','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-251224-0002','D','2025-12-24','09:14:37','kasir','PENJUALAN','F225240914371','4134197000','5175000','4139372000');
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 ('F225240915581','kasir','1',' MEA1E X LG','TOKO','SMBK-A','A1E-YLXC-73-0','AT X BANGKOK KLIP SLEP LG 8K ','OL','0.560','1','100.00','612000','0','0','15000','626000','0','5000','0','631000','TIN','00379389','A1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLXC-73-0' 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-24' AND kode_barang='A1E-YLXC-73-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 ('F225240915581','2025-12-24','0.560','2025-12-24','09:15:58','PLG0075915','626000','626000','5000','631000','631000','kasir','2025-12-24 09:15:58','F22524091558');
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-24','F225240915581','2025-12-24','09:15:58','TIN','631000','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-251224-0003','D','2025-12-24','09:15:58','kasir','PENJUALAN','F225240915581','4139372000','631000','4140003000');
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 ('F225240924121','kasir','1',' MEH1E HW 4','TOKO','SMBK-H','H1E-YLBX-12-T','KL SANTA BOLA SLEP HW 42 8K ','OL','1.870','1','100.00','2070000','0','0','15000','2085000','0','9000','0','2094000','RHM','T0075997','H1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLBX-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.870',berat_jual_asli=berat_jual_asli+'1.870',stock_jual='1',berat_akhir=berat_akhir-'1.870',berat_akhir_asli=berat_akhir_asli-'1.870',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='H1E-YLBX-12-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 ('F225240924121','2025-12-24','1.870','2025-12-24','09:24:13','PLG0075916','2085000','2085000','9000','2094000','2094000','kasir','2025-12-24 09:24:12','F22524092412');
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-24','F225240924121','2025-12-24','09:24:13','RHM','2094000','9000');
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-251224-0004','D','2025-12-24','09:24:13','kasir','PENJUALAN','F225240924121','4140003000','2094000','4142097000');
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 ('F225240958171','kasir','1',' MGD2 UB ','TOKO','SMBK-D','D2G-YHXE-30-T','LT MODEL HATI MATA VAR UB 8K ','OL','0.350','1','100.00','401000','0','0','15000','406000','0','5000','0','411000','NS','T0071819','D2G','0','0','-','0','1147000');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2G-YHXE-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='D2G-YHXE-30-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 ('F225240958171','2025-12-24','0.350','2025-12-24','09:58:18','PLG0075917','406000','406000','5000','411000','411000','kasir','2025-12-24 09:58:17','F22524095817');
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-24','F225240958171','2025-12-24','09:58:18','NS','411000','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-251224-0005','D','2025-12-24','09:58:18','kasir','PENJUALAN','F225240958171','4142097000','411000','4142508000');
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 ('F225241125511','kasir','1',' MEE1E CM 1','TOKO','SMBK-E','E1E-YLBX-47-T','CC MODEL SLEP CM 15 8K ','OL','0.670','1','100.00','742000','0','0','15000','750000','0','5000','0','755000','NS','T0076032','E1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YLBX-47-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='E1E-YLBX-47-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 ('F225241125511','2025-12-24','0.670','2025-12-24','11:25:51','PLG0075918','750000','750000','5000','755000','755000','kasir','2025-12-24 11:25:51','F22524112551');
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-24','F225241125511','2025-12-24','11:25:51','NS','755000','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-251224-0006','D','2025-12-24','11:25:51','kasir','PENJUALAN','F225241125511','4142508000','755000','4143263000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='755000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225241125511' 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 ('F225241125512','kasir',' 1',' MEE1E CM 1','TOKO','SMBK-E','E1E-YLBX-50-T','CC MODEL SLEP CM 15 8K ','OL','0.660','1','100.00','731000','0','0','15000','740000','0','5000','0','745000','NS','T0076035','E1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YLBX-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='E1E-YLBX-50-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 ('F225241125512','2025-12-24','0.660','2025-12-24','11:25:51','PLG0075919','740000','740000','5000','745000','745000','kasir','2025-12-24 11:25:51','F22524112551');
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-24','F225241125512','2025-12-24','11:25:51','NS','745000','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-251224-0007','D','2025-12-24','11:25:51','kasir','PENJUALAN','F225241125512','4143263000','745000','4144008000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='745000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225241125512' 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 ('F225241126301','kasir','1',' MEH1E UB 4','TOKO','SMBK-H','H1E-YLBX-11-T','KL TIFF MATA VAR UB 42 8K ','OL','1.690','1','100.00','1871000','0','0','15000','1885000','0','8000','0','1893000','NS','T0075996','H1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLBX-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.690',berat_jual_asli=berat_jual_asli+'1.690',stock_jual='1',berat_akhir=berat_akhir-'1.690',berat_akhir_asli=berat_akhir_asli-'1.690',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='H1E-YLBX-11-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 ('F225241126301','2025-12-24','1.690','2025-12-24','11:26:30','PLG0075920','1885000','1885000','8000','1893000','1893000','kasir','2025-12-24 11:26:30','F22524112630');
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-24','F225241126301','2025-12-24','11:26:30','NS','1893000','8000');
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-251224-0008','D','2025-12-24','11:26:30','kasir','PENJUALAN','F225241126301','4144008000','1893000','4145901000');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D2E-YLBD-1-T','T0076163','MED2 LG S ','LT MODEL MATA HURUF S LG 8K ','','GR','---','ME','D2E','TOKO','01-SEM','579000','2025-12-24','579000','0.530','100.00','8','0','1092000.00','1','0.04', 'input','2025-12-24 12:01:05','0.530','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D2E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D2E','D2E-YLBD-1-T','T0076163');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-24','D2E-YLBD-1-T','D2E','TOKO','01-SEM','100.00','0.530','0.530','1','0.530','0.530','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1D-YLBD-2-T','T0076164','MDD1 LT ','LT MODEL FG SLEP LT 8K ','','GR','---','MD','D1D','TOKO','01-SEM','1446000','2025-12-24','1446000','1.330','100.00','8','0','1087000.00','1','0.04', 'input','2025-12-24 12:02:32','1.330','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1D','D1D-YLBD-2-T','T0076164');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-24','D1D-YLBD-2-T','D1D','TOKO','01-SEM','100.00','1.330','1.330','1','1.330','1.330','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1D-YLBD-3-T','T0076165','MDD1 LT ','LT MODEL FG SLEP LT 8K ','','GR','---','MD','D1D','TOKO','01-SEM','1598000','2025-12-24','1598000','1.470','100.00','8','','1087000.00','1','0.04', 'input','2025-12-24 12:02:56','1.470','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1D','D1D-YLBD-3-T','T0076165');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-24','D1D-YLBD-3-T','D1D','TOKO','01-SEM','100.00','1.470','1.470','1','1.470','1.470','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('D1D-YLBD-4-T','T0076166','MDD1 LT ','LT MODEL FG SLEP LT 8K ','','GR','---','MD','D1D','TOKO','01-SEM','1467500','2025-12-24','1467500','1.350','100.00','8','','1087000.00','1','0.04', 'input','2025-12-24 12:03:32','1.350','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1D','D1D-YLBD-4-T','T0076166');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-24','D1D-YLBD-4-T','D1D','TOKO','01-SEM','100.00','1.350','1.350','1','1.350','1.350','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251224-0001','1','D1D-YLBD-2-T','1','1.33','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1D-YLBD-2-T' AND kode_lokasi_toko = '01-SEM';
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-24','TOKO','SMBK-D','D1D','D1D-YLBD-2-T' , '1','1.33','1.33', '1','1.33','1.33','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.33',berat_out_asli=berat_out_asli+'1.33',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1D-YLBD-2-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251224-0001','2','D1D-YLBD-3-T','1','1.47','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1D-YLBD-3-T' AND kode_lokasi_toko = '01-SEM';
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-24','TOKO','SMBK-D','D1D','D1D-YLBD-3-T' , '1','1.47','1.47', '1','1.47','1.47','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.47',berat_out_asli=berat_out_asli+'1.47',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1D-YLBD-3-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251224-0001','3','D1D-YLBD-4-T','1','1.35','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1D-YLBD-4-T' AND kode_lokasi_toko = '01-SEM';
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-24','TOKO','SMBK-D','D1D','D1D-YLBD-4-T' , '1','1.35','1.35', '1','1.35','1.35','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.35',berat_out_asli=berat_out_asli+'1.35',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1D-YLBD-4-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251224-0001','4','D2E-YLBD-1-T','1','0.53','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D2E-YLBD-1-T' AND kode_lokasi_toko = '01-SEM';
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-24','TOKO','SMBK-D','D2E','D2E-YLBD-1-T' , '1','0.53','0.53', '1','0.53','0.53','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.53',berat_out_asli=berat_out_asli+'0.53',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D2E-YLBD-1-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-251224-0001','2025-12-24','2025-12-24','12:06','4.68','input','2025-12-24 12:06:43');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YLBD-5-T','T0076167','MEH1 KH 42 ','KL SIEM COBRA VAR 42 KH 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2064000','2025-12-24','2064000','1.890','100.00','8','0','1092000.00','1','0.04', 'input','2025-12-24 12:10:36','1.890','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YLBD-5-T','T0076167');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-24','H1E-YLBD-5-T','H1E','TOKO','01-SEM','100.00','1.890','1.890','1','1.890','1.890','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YLBD-6-T','T0076168','MEH1 KH 42 ','KL SIEM COBRA MATA VAR 42 KH 8K ','','GR','---','ME','H1E','TOKO','01-SEM','1977000','2025-12-24','1977000','1.810','100.00','8','','1092000.00','1','0.04', 'input','2025-12-24 12:11:55','1.810','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YLBD-6-T','T0076168');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-24','H1E-YLBD-6-T','H1E','TOKO','01-SEM','100.00','1.810','1.810','1','1.810','1.810','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YLBD-7-T','T0076169','MEH1 KH 42 ','KL SIEM COBRA MATA VAR 42 KH 8K ','','GR','---','ME','H1E','TOKO','01-SEM','1977000','2025-12-24','1977000','1.810','100.00','8','','1092000.00','1','0.04', 'input','2025-12-24 12:12:48','1.810','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YLBD-7-T','T0076169');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-24','H1E-YLBD-7-T','H1E','TOKO','01-SEM','100.00','1.810','1.810','1','1.810','1.810','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 ('F225241213101','kasir','1',' MEF1 TD 54','TOKO','SMBK-F','F1E-YLAX-52-T','GL COR OVAL MODEL C DM 54 TD 8K','','3.210','1','100.00','3553000','0','0','15000','3547000','0','0','0','3547000','TIN','T0075636','F1E','0','0','-','1','1092000');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLAX-52-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.210',berat_jual_asli=berat_jual_asli+'3.210',stock_jual='1',berat_akhir=berat_akhir-'3.210',berat_akhir_asli=berat_akhir_asli-'3.210',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='F1E-YLAX-52-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 ('F225241213101','2025-12-24','3.210','2025-12-24','12:13:11','PLG0075921','3547000','3547000','0','3547000','3547000','kasir','2025-12-24 12:13:10','F22524121310');
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-24','F225241213101','2025-12-24','12:13:11','TIN','3547000','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-251224-0009','D','2025-12-24','12:13:11','kasir','PENJUALAN','F225241213101','4145901000','3547000','4149448000');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YLBD-8-T','T0076170','MEH1 UB 39 ','KL MODEL TIFF VAR 39 UB 8K ','','GR','---','ME','H1E','TOKO','01-SEM','1824000','2025-12-24','1824000','1.670','100.00','8','0','1092000.00','1','0.04', 'input','2025-12-24 12:14:22','1.670','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YLBD-8-T','T0076170');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-24','H1E-YLBD-8-T','H1E','TOKO','01-SEM','100.00','1.670','1.670','1','1.670','1.670','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251224-0002','1','H1E-YLBD-5-T','1','1.89','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YLBD-5-T' AND kode_lokasi_toko = '01-SEM';
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-24','TOKO','SMBK-H','H1E','H1E-YLBD-5-T' , '1','1.89','1.89', '1','1.89','1.89','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.89',berat_out_asli=berat_out_asli+'1.89',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YLBD-5-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251224-0002','2','H1E-YLBD-6-T','1','1.81','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YLBD-6-T' AND kode_lokasi_toko = '01-SEM';
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-24','TOKO','SMBK-H','H1E','H1E-YLBD-6-T' , '1','1.81','1.81', '1','1.81','1.81','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.81',berat_out_asli=berat_out_asli+'1.81',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YLBD-6-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251224-0002','3','H1E-YLBD-7-T','1','1.81','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YLBD-7-T' AND kode_lokasi_toko = '01-SEM';
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-24','TOKO','SMBK-H','H1E','H1E-YLBD-7-T' , '1','1.81','1.81', '1','1.81','1.81','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.81',berat_out_asli=berat_out_asli+'1.81',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YLBD-7-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251224-0002','4','H1E-YLBD-8-T','1','1.67','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YLBD-8-T' AND kode_lokasi_toko = '01-SEM';
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-24','TOKO','SMBK-H','H1E','H1E-YLBD-8-T' , '1','1.67','1.67', '1','1.67','1.67','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.67',berat_out_asli=berat_out_asli+'1.67',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YLBD-8-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-251224-0002','2025-12-24','2025-12-24','12:14','7.18','input','2025-12-24 12:15:03');
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 ('F225241252251','kasir','1',' MDE1 X BM ','TOKO','SMBK-E','E1D-YJBC-173-0','CC X VELG C SLEP BM 12 8K ','OL','1.030','1','100.00','1120000','0','0','15000','1123000','0','5000','0','1128000','TIN','00374491','E1D','0','0','-','0','1087000');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJBC-173-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='E1D-YJBC-173-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225241252251','2025-12-24','1.030','2025-12-24','12:52:26','PLG0075922','1123000','1123000','5000','1128000','1128000','kasir','2025-12-24 12:52:25','F22524125225');
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-24','F225241252251','2025-12-24','12:52:26','TIN','1128000','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-251224-0010','D','2025-12-24','12:52:26','kasir','PENJUALAN','F225241252251','4149448000','1128000','4150576000');
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 ('F225241259191','kasir','1',' MDA1D X UB','TOKO','SMBK-A','A1D-YIBD-99-0','AT X HUGGIES MATA VAR UB 8K ','OL','1.180','1','100.00','1283000','0','0','15000','1310000','0','6000','0','1316000','NS','00370520','A1D','0','0','-','0','1087000');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YIBD-99-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.180',berat_jual_asli=berat_jual_asli+'1.180',stock_jual='1',berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='A1D-YIBD-99-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 ('F225241259191','2025-12-24','1.180','2025-12-24','12:59:19','PLG0075923','1310000','1310000','6000','1316000','1316000','kasir','2025-12-24 12:59:19','F22524125919');
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-24','F225241259191','2025-12-24','12:59:19','NS','1316000','6000');
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-251224-0011','D','2025-12-24','12:59:19','kasir','PENJUALAN','F225241259191','4150576000','1316000','4151892000');
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 ('F225241259531','kasir','1',' MEA1 BW ','TOKO','SMBK-A','A1E-YLBC-65-T','AT MODEL ITALY PANJANG VAR BW 8K ','OL','0.550','1','100.00','609000','0','0','15000','613000','0','5000','0','618000','NS','T0076127','A1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLBC-65-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='A1E-YLBC-65-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 ('F225241259531','2025-12-24','0.550','2025-12-24','12:59:53','PLG0075924','613000','613000','5000','618000','618000','kasir','2025-12-24 12:59:53','F22524125953');
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-24','F225241259531','2025-12-24','12:59:53','NS','618000','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-251224-0012','D','2025-12-24','12:59:53','kasir','PENJUALAN','F225241259531','4151892000','618000','4152510000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='618000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225241259531' 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 ('F225241259532','kasir',' 1',' MEF3E UB 1','TOKO','SMBK-F','F3E-YLBX-14-T','GL TIFF SPECTRA HITAM SERUT UB 8K','OL','2.090','1','100.00','2314000','0','0','15000','2320000','0','10000','0','2330000','NS','T0075999','F3E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLBX-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.090',berat_jual_asli=berat_jual_asli+'2.090',stock_jual='1',berat_akhir=berat_akhir-'2.090',berat_akhir_asli=berat_akhir_asli-'2.090',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='F3E-YLBX-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 ('F225241259532','2025-12-24','2.090','2025-12-24','12:59:53','PLG0075925','2320000','2320000','10000','2330000','2330000','kasir','2025-12-24 12:59:53','F22524125953');
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-24','F225241259532','2025-12-24','12:59:53','NS','2330000','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-251224-0013','D','2025-12-24','12:59:53','kasir','PENJUALAN','F225241259532','4152510000','2330000','4154840000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2330000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225241259532' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225241259531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225241259531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225241259531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225241259532' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225241259532' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225241259532';
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 ('F225240122291','kasir','1',' MEH1 10K Y','TOKO','SMBK-H','H1E-YLBC-6-T','KL TRIXIE MODEL BUNGA CLOVER VAR YT 8K','OL','1.810','1','100.00','2004000','0','0','15000','2017000','0','10000','0','2027000','RTA','T0076068','H1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLBC-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.810',berat_jual_asli=berat_jual_asli+'1.810',stock_jual='1',berat_akhir=berat_akhir-'1.810',berat_akhir_asli=berat_akhir_asli-'1.810',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='H1E-YLBC-6-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 ('F225240122291','2025-12-24','1.810','2025-12-24','13:22:29','PLG0075926','2017000','2017000','10000','2027000','2027000','kasir','2025-12-24 13:22:29','F22524012229');
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-24','F225240122291','2025-12-24','13:22:29','RTA','2027000','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-251224-0014','D','2025-12-24','13:22:29','kasir','PENJUALAN','F225240122291','4154840000','2027000','4156867000');
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 ('F225240204381','kasir','1',' MEH1E KH 4','TOKO','SMBK-H','H1E-YLBX-1-T','KL SANTA MATA VAR KH 42 8K','OL TW','2.680','1','100.00','2967000','0','0','15000','2976000','0','27000','0','3003000','NS','T0075986','H1E','0','0','-','0','1092000');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLBX-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.680',berat_jual_asli=berat_jual_asli+'2.680',stock_jual='1',berat_akhir=berat_akhir-'2.680',berat_akhir_asli=berat_akhir_asli-'2.680',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='H1E-YLBX-1-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 ('F225240204381','2025-12-24','2.680','2025-12-24','14:04:38','PLG0075927','2976000','2976000','27000','3003000','3003000','kasir','2025-12-24 14:04:38','F22524020438');
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-24','F225240204381','2025-12-24','14:04:38','NS','3003000','27000');
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-251224-0015','D','2025-12-24','14:04:38','kasir','PENJUALAN','F225240204381','4156867000','3003000','4159870000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3003000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225240204381' 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 ('F225240204382','kasir',' 1',' MDD1 LT ','TOKO','SMBK-D','D1D-YLAH-34-T','LT MODEL FG SLEP LT 8K ','OL TW','1.360','1','100.00','1478000','0','0','15000','1483000','0','14000','0','1497000','NS','T0075963','D1D','0','0','-','0','1087000');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-YLAH-34-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.360',berat_jual_asli=berat_jual_asli+'1.360',stock_jual='1',berat_akhir=berat_akhir-'1.360',berat_akhir_asli=berat_akhir_asli-'1.360',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='D1D-YLAH-34-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 ('F225240204382','2025-12-24','1.360','2025-12-24','14:04:38','PLG0075928','1483000','1483000','14000','1497000','1497000','kasir','2025-12-24 14:04:38','F22524020438');
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-24','F225240204382','2025-12-24','14:04:38','NS','1497000','14000');
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-251224-0016','D','2025-12-24','14:04:38','kasir','PENJUALAN','F225240204382','4159870000','1497000','4161367000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1497000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225240204382' 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 ('F225240221141','kasir','1',' MEE2 X HW ','TOKO','SMBK-E','E2E-YLXH-180-0','CC X MODEL MATA HW 15 8K ','','0.710','1','100.00','786000','0','0','15000','785000','0','0','0','785000','TIN','00380302','E2E','0','0','-','1','1092000');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YLXH-180-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.710',berat_jual_asli=berat_jual_asli+'0.710',stock_jual='1',berat_akhir=berat_akhir-'0.710',berat_akhir_asli=berat_akhir_asli-'0.710',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='E2E-YLXH-180-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225240221141','2025-12-24','0.710','2025-12-24','14:21:14','PLG0075929','785000','785000','0','785000','785000','kasir','2025-12-24 14:21:14','F22524022114');
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-24','F225240221141','2025-12-24','14:21:14','TIN','785000','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-251224-0017','D','2025-12-24','14:21:14','kasir','PENJUALAN','F225240221141','4161367000','785000','4162152000');
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-00004941','X-00004941','GL SANTA SERUT MODEL INFINITY MATA VAR HW 17K','GR','---','F3TG','BELI','BELI001','3680000','2025-12-24','2.300','1','kasir','2025-12-24 15:23:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3TG';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3TG','X-00004941','X-00004941');
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-251224-0001','F225071005381','RTA','1','BELI','BELI001','F3TG', 'X-00004941', 'GL SANTA SERUT MODEL INFINITY MATA VAR HW 17K','2.740','2.300','100.00','4039000','3680000','1600000','2040000','1','3680000','3680000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.300',berat_beli_asli=berat_beli_asli+'2.300',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.300',berat_akhir_asli=berat_akhir_asli+'2.300',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3TG' 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-251224-0001','2025-12-24','2025-12-24','15:23:47','RTA','---','2.300','3680000','3680000','3680000','3680000','3680000','kasir','2025-12-24 15:23:47','FB-251224-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251224-0001','AMEL','JL BANJARREJO 1 TRISONO','','','085755970631','kasir','2025-12-24 15:23:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-24' 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-251224-0018','K','2025-12-24','15:23:47','kasir','PEMBELIAN UMUM','FB-251224-0001','4162152000','3680000','4158472000');
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-00004942','X-00004942','GL KREPYAK MODEL MATA VAR KH 8K','GR','---','F3E','BELI','BELI001','3070000','2025-12-24','3.790','1','kasir','2025-12-24 15:24:32');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00004942','X-00004942');
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-251224-0002','F225230919461','TIN','1','BELI','BELI001','F3E', 'X-00004942', 'GL KREPYAK MODEL MATA VAR KH 8K','3.990','3.790','100.00','2769000','3070000','810026','1092000','1','3070000','3070000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.790',berat_beli_asli=berat_beli_asli+'3.790',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.790',berat_akhir_asli=berat_akhir_asli+'3.790',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-24' 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-251224-0002','2025-12-24','2025-12-24','15:24:31','TIN','---','3.790','3070000','3070000','3070000','3070000','3070000','kasir','2025-12-24 15:24:32','FB-251224-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251224-0002','LINA','','','','','kasir','2025-12-24 15:24:32');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-24' 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-251224-0019','K','2025-12-24','15:24:31','kasir','PEMBELIAN UMUM','FB-251224-0002','4158472000','3070000','4155402000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225240122291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225240122291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225240122291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225240204381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225240204381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225240204381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225240204382' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225240204382' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225240204382';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225240221141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225240221141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225240221141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225240914371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225240914371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225240914371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225240915581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225240915581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225240915581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225240924121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225240924121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225240924121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225240958171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225240958171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225240958171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225241125511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225241125511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225241125511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225241125512' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225241125512' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225241125512';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225241126301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225241126301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225241126301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225241213101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225241213101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225241213101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225241252251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225241252251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225241252251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225241259191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225241259191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225241259191';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251224-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251224-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251224-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251224-0002';
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 ('F225240335011','kasir','1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YJBI-32-T','GW TUSUK MODEL MATA LG PE 8K ','','0.550','1','100.00','609000','0','0','15000','608000','0','0','0','608000','RTA','T0074592','B1E','0','0','-','1','1092000');
UPDATE tm_barang SET tgl_last_jual='2025-12-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJBI-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-12-24' AND kode_barang='B1E-YJBI-32-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 ('F225240335011','2025-12-24','0.550','2025-12-24','15:35:01','PLG0075930','608000','608000','0','608000','608000','kasir','2025-12-24 15:35:01','F22524033501');
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-24','F225240335011','2025-12-24','15:35:01','RTA','608000','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-251224-0020','D','2025-12-24','15:35:01','kasir','PENJUALAN','F225240335011','4155402000','608000','4156010000');
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-00004943','X-00004943','AT COR 17K','GR','---','A1TF','BELI','BELI001','393000','2025-12-24','0.250','1','kasir','2025-12-24 15:40:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1TF','X-00004943','X-00004943');
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-251224-0003','F221170318011','NS','1','BELI','BELI001','A1TF', 'X-00004943', 'AT COR 17K','0.550','0.250','100.00','394000','393000','1572000','2020000','1','393000','393000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.250',berat_beli_asli=berat_beli_asli+'0.250',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.250',berat_akhir_asli=berat_akhir_asli+'0.250',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-24' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1TF' 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-251224-0003','2025-12-24','2025-12-24','15:40:01','NS','---','0.250','393000','393000','393000','393000','393000','kasir','2025-12-24 15:40:02','FB-251224-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251224-0003','BANDI','SLAHUNG','','','','kasir','2025-12-24 15:40:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-24' 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-251224-0021','K','2025-12-24','15:40:01','kasir','PEMBELIAN UMUM','FB-251224-0003','4156010000','393000','4155617000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225240335011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225240335011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225240335011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251224-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251224-0003';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-25','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-24';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-24';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-24';
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-24' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-24';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-24';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-24';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-24';
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-25' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-24' 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-251225-0001','D','2025-12-25','16:05:38','SYSTEM','SALDO AWAL','SALDO AWAL','0','4155617000','4155617000');
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-251225-0001','D','2025-12-25','16:05:38','BCA','SALDO AWAL','SALDO AWAL','0','4214325888','4214325888');
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-251225-0001','D','2025-12-25','16:05:38','','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-251225-0001','D','2025-12-25','16:05:38','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-251225-0001','D','2025-12-25','16:05:38','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-251225-0001','D','2025-12-25','16:05:38','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2025-12-25';
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-20251225-0001','1','E2E-YLXC-241-0','1','0.550','0.550','TOKO','SBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YLXC-241-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YLXC-241-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-12-25 16:44:18' WHERE kode_barang='E2E-YLXC-241-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YLXC-241-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-25 16:44:18','TOKO','SMBK-E','E2E','E2E-YLXC-241-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' 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='E2E-YLXC-241-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YLXC-241-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-20251225-0001','1','E1F-YLAH-118-0','1','0.480','0.480','TOKO','SBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-YLAH-118-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-YLAH-118-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-12-25 16:44:18' WHERE kode_barang='E1F-YLAH-118-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-YLAH-118-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-25 16:44:18','TOKO','SMBK-E','E1F','E1F-YLAH-118-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-YLAH-118-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-YLAH-118-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251225-0001','2025-12-25','16:44','1.030','input','2025-12-24 16:44:17');