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 ('F326210853131','input','1',' TFF1 XX UB','TOKO','PT-F','F1TF-WLBF-121-T','GL XX OVAL BOLA PASIR UB D55 ','','4.650','1','100.00','9346000','0','0','15000','9207000','0','0','0','9207000','SIN','T0052782','F1TF','0','0','-','1','2010000');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TF-WLBF-121-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.650',berat_jual_asli=berat_jual_asli+'4.650',stock_jual='1',berat_akhir=berat_akhir-'4.650',berat_akhir_asli=berat_akhir_asli-'4.650',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='F1TF-WLBF-121-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326210853131','2026-06-21','4.650','2026-06-21','08:53:14','PLG0029889','9207000','9207000','0','9207000','9207000','input','2026-06-21 08:53:13','F32621085313');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','F326210853131','2026-06-21','08:53:14','SIN','9207000','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-260621-0002','D','2026-06-21','08:53:14','input','PENJUALAN','F326210853131','5781106000','9207000','5790313000');
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 ('F326210855571','input','1',' MEF3E X HW','TOKO','PM-F','F3E-XGXB-174-0','GL X FLIK VAR SLEP HW 8K ','','2.850','1','100.00','3092000','0','0','15000','3093000','0','0','0','3093000','FIT','00305436','F3E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-XGXB-174-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.850',berat_jual_asli=berat_jual_asli+'2.850',stock_jual='1',berat_akhir=berat_akhir-'2.850',berat_akhir_asli=berat_akhir_asli-'2.850',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='F3E-XGXB-174-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326210855571','2026-06-21','2.850','2026-06-21','08:55:58','PLG0029890','3093000','3093000','0','3093000','3093000','input','2026-06-21 08:55:57','F32621085557');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','F326210855571','2026-06-21','08:55:58','FIT','3093000','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-260621-0003','D','2026-06-21','08:55:58','input','PENJUALAN','F326210855571','5790313000','3093000','5793406000');
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 ('F326210909531','input','1',' MEF3E X YT','TOKO','PM-F','F3E-YLAG-49-0','GL X FLIK SLEP VAR YT 8K ','','1.970','1','100.00','2137000','0','0','15000','2138000','0','0','0','2138000','LIS','00381403','F3E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLAG-49-0' 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='2026-06-21' AND kode_barang='F3E-YLAG-49-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326210909531','2026-06-21','1.970','2026-06-21','09:09:53','PLG0029891','2138000','2138000','0','2138000','2138000','input','2026-06-21 09:09:53','F32621090953');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','F326210909531','2026-06-21','09:09:53','LIS','2138000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260621-0004','D','2026-06-21','09:09:53','input','PENJUALAN','F326210909531','5793406000','2138000','5795544000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2138000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326210909531' 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 ('F326210909532','input',' 1',' MDE2D BM 1','TOKO','PM-E','E2D-ZFXB-93-0','CC MODEL MATA SLEP BM 16 8K ','','1.610','1','100.00','1715000','0','0','15000','1715000','0','0','0','1715000','LIS','00406485','E2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFXB-93-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='2026-06-21' AND kode_barang='E2D-ZFXB-93-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326210909532','2026-06-21','1.610','2026-06-21','09:09:53','PLG0029892','1715000','1715000','0','1715000','1715000','input','2026-06-21 09:09:53','F32621090953');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','F326210909532','2026-06-21','09:09:53','LIS','1715000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260621-0005','D','2026-06-21','09:09:53','input','PENJUALAN','F326210909532','5795544000','1715000','5797259000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1715000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326210909532' 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 ('F326210927241','input','1',' TEF3 UB ','TOKO','PT-F','F3TE-YDBC-134-T','GL RANTAI HOLLOW SIRIP UB 17K ','','1.520','1','100.00','3025000','0','0','15000','3025000','0','0','0','3025000','SIN','T0068948','F3TE','0','0','-','0','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YDBC-134-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='F3TE-YDBC-134-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326210927241','2026-06-21','1.520','2026-06-21','09:27:25','PLG0029893','3025000','3025000','0','3025000','3025000','input','2026-06-21 09:27:24','F32621092724');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','F326210927241','2026-06-21','09:27:25','SIN','3025000','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-260621-0006','D','2026-06-21','09:27:25','input','PENJUALAN','F326210927241','5797259000','3025000','5800284000');
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 ('F326210958251','input','1',' MEE2 X MJ ','TOKO','PM-E','E2E-ZEBH-259-0','CC X SOLITAIRE MATA MJ 18 8K ','','0.680','1','100.00','738000','0','0','15000','738000','0','0','0','738000','AAT','00405477','E2E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZEBH-259-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='E2E-ZEBH-259-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326210958251','2026-06-21','0.680','2026-06-21','09:58:26','PLG0029894','738000','738000','0','738000','738000','input','2026-06-21 09:58:25','F32621095825');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','F326210958251','2026-06-21','09:58:26','AAT','738000','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-260621-0007','D','2026-06-21','09:58:26','input','PENJUALAN','F326210958251','5800284000','738000','5801022000');
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 ('F326211037291','input','1',' MEF1 X UB ','TOKO','PM-F','F1E-ZCBD-41-0','GL X BANGKOK TSUNAMI UB 58 8K ','','5.120','1','100.00','5555000','0','0','15000','5555000','0','0','0','5555000','LIS','00396521','F1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCBD-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.120',berat_jual_asli=berat_jual_asli+'5.120',stock_jual='1',berat_akhir=berat_akhir-'5.120',berat_akhir_asli=berat_akhir_asli-'5.120',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='F1E-ZCBD-41-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326211037291','2026-06-21','5.120','2026-06-21','10:37:29','PLG0029895','5555000','5555000','0','5555000','5555000','input','2026-06-21 10:37:29','F32621103729');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','F326211037291','2026-06-21','10:37:29','LIS','5555000','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-260621-0008','D','2026-06-21','10:37:29','input','PENJUALAN','F326211037291','5801022000','5555000','5806577000');
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 ('F326211038531','input','1',' MEF2 X YT ','TOKO','PM-F','F2E-YHBI-239-0','GL X OVAL MATA YT 56 8K ','','4.940','1','100.00','5360000','0','0','15000','5360000','0','0','0','5360000','LIS','00367480','F2E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YHBI-239-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.940',berat_jual_asli=berat_jual_asli+'4.940',stock_jual='1',berat_akhir=berat_akhir-'4.940',berat_akhir_asli=berat_akhir_asli-'4.940',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='F2E-YHBI-239-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326211038531','2026-06-21','4.940','2026-06-21','10:38:53','PLG0029896','5360000','5360000','0','5360000','5360000','input','2026-06-21 10:38:53','F32621103853');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','F326211038531','2026-06-21','10:38:53','LIS','5360000','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-260621-0009','D','2026-06-21','10:38:53','input','PENJUALAN','F326211038531','5806577000','5360000','5811937000');
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 ('F326211107391','input','1',' MEE1E LG 1','TOKO','PM-E','E1E-ZFXD-352-0','CC MODEL ISYANA SLEP LG 14 8K ','','0.550','1','100.00','597000','0','0','15000','598000','0','0','0','598000','SIN','00407232','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFXD-352-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='E1E-ZFXD-352-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326211107391','2026-06-21','0.550','2026-06-21','11:07:39','PLG0029897','598000','598000','0','598000','598000','input','2026-06-21 11:07:39','F32621110739');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','F326211107391','2026-06-21','11:07:39','SIN','598000','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-260621-0010','D','2026-06-21','11:07:39','input','PENJUALAN','F326211107391','5811937000','598000','5812535000');
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 ('F326211135321','input','1',' MEE2 X LG ','TOKO','PM-E','E2E-ZBXF-137-0','CC X MODEL MATA LG 12 8K ','','0.520','1','100.00','564000','0','0','15000','565000','0','0','0','565000','LIS','00388719','E2E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZBXF-137-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='2026-06-21' AND kode_barang='E2E-ZBXF-137-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326211135321','2026-06-21','0.520','2026-06-21','11:35:33','PLG0029898','565000','565000','0','565000','565000','input','2026-06-21 11:35:32','F32621113532');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','F326211135321','2026-06-21','11:35:33','LIS','565000','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-260621-0011','D','2026-06-21','11:35:33','input','PENJUALAN','F326211135321','5812535000','565000','5813100000');
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 ('F326211140161','input','1',' MEE1 CM 14','TOKO','PM-E','E1E-ZDBE-401-0','CC MODEL AUREL POLOS CM 14 ','','0.450','1','100.00','488000','0','0','15000','488000','0','0','0','488000','LIS','00401169','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBE-401-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='E1E-ZDBE-401-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326211140161','2026-06-21','0.450','2026-06-21','11:40:17','PLG0029899','488000','488000','0','488000','488000','input','2026-06-21 11:40:16','F32621114016');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','F326211140161','2026-06-21','11:40:17','LIS','488000','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-260621-0012','D','2026-06-21','11:40:17','input','PENJUALAN','F326211140161','5813100000','488000','5813588000');
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 ('F326211146351','input','1',' MEA1 5K CM','TOKO','PM-A','A1E-ZBAF-271-0','AT ANAK BONEKA CAT VAR CM 8K ','','0.530','1','100.00','575000','0','0','15000','575000','0','5000','0','580000','SIN','00390243','A1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZBAF-271-0' 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='2026-06-21' AND kode_barang='A1E-ZBAF-271-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326211146351','2026-06-21','0.530','2026-06-21','11:46:36','PLG0029900','575000','575000','5000','580000','580000','input','2026-06-21 11:46:35','F32621114635');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','F326211146351','2026-06-21','11:46:36','SIN','580000','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-260621-0013','D','2026-06-21','11:46:36','input','PENJUALAN','F326211146351','5813588000','580000','5814168000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='580000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326211146351' 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 ('F326211146352','input',' 1',' MEF1 LT D5','TOKO','PM-F','F1E-YKAE-166-0','GL OVAL MODEL SLEP VAR LT D58 8K ','','3.120','1','100.00','3385000','0','0','15000','3385000','0','0','0','3385000','SIN','00377574','F1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YKAE-166-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.120',berat_jual_asli=berat_jual_asli+'3.120',stock_jual='1',berat_akhir=berat_akhir-'3.120',berat_akhir_asli=berat_akhir_asli-'3.120',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='F1E-YKAE-166-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326211146352','2026-06-21','3.120','2026-06-21','11:46:36','PLG0029901','3385000','3385000','0','3385000','3385000','input','2026-06-21 11:46:35','F32621114635');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','F326211146352','2026-06-21','11:46:36','SIN','3385000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260621-0014','D','2026-06-21','11:46:36','input','PENJUALAN','F326211146352','5814168000','3385000','5817553000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3385000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326211146352' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019448','X-00019448','CC COR M 8K','GR','---','E2D','BELI','BELI001','1162000','2026-06-21','1.260','1','kasir','2026-06-21 12:15:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019448','X-00019448');
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-260621-0001','00377152','FIT','1','BELI','BELI001','E2D', 'X-00019448', 'CC COR M 8K','1.260','1.260','100.00','1265000','1162000','922222','1075000','1','1162000','1162000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.260',berat_beli_asli=berat_beli_asli+'1.260',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.260',berat_akhir_asli=berat_akhir_asli+'1.260',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-21' 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-260621-0001','2026-06-21','2026-06-21','12:15:17','FIT','---','1.260','1162000','1162000','1162000','1162000','1162000','kasir','2026-06-21 12:15:18','FB-260621-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260621-0001','VILA','BITING BADEGAN','','','','kasir','2026-06-21 12:15:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-21' 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-260621-0015','K','2026-06-21','12:15:17','kasir','PEMBELIAN UMUM','FB-260621-0001','5817553000','1162000','5816391000');
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-00019449','X-00019449','KL MILANO UB 40CM 8K','GR','---','H1E','BELI','BELI001','3142000','2026-06-21','3.120','1','kasir','2026-06-21 12:16:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00019449','X-00019449');
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-260621-0002','F326010900051','AAT','1','BELI','BELI001','H1E', 'X-00019449', 'KL MILANO UB 40CM 8K','3.120','3.120','100.00','3605000','3142000','1007051','1095000','1','3142000','3142000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.120',berat_beli_asli=berat_beli_asli+'3.120',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.120',berat_akhir_asli=berat_akhir_asli+'3.120',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' 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-260621-0002','2026-06-21','2026-06-21','12:16:44','AAT','---','3.120','3142000','3142000','3142000','3142000','3142000','kasir','2026-06-21 12:16:44','FB-260621-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260621-0002','MINEM','BITING','','','085230388675','kasir','2026-06-21 12:16:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-21' 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-260621-0016','K','2026-06-21','12:16:44','kasir','PEMBELIAN UMUM','FB-260621-0002','5816391000','3142000','5813249000');
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-00019450','X-00019450','CC WEDDING MATA CM 16 8K','GR','---','E2D','BELI','BELI001','1398000','2026-06-21','1.520','1','kasir','2026-06-21 12:16:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019450','X-00019450');
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-260621-0003','F325140244121','AAT','2','BELI','BELI001','E2D', 'X-00019450', 'CC WEDDING MATA CM 16 8K','1.520','1.520','100.00','1520000','1398000','919737','1075000','1','1398000','1398000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.520',berat_beli_asli=berat_beli_asli+'1.520',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.520',berat_akhir_asli=berat_akhir_asli+'1.520',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-21' 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-260621-0003','2026-06-21','2026-06-21','12:16:44','AAT','---','1.520','1398000','1398000','1398000','1398000','1398000','kasir','2026-06-21 12:16:44','FB-260621-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260621-0003','MINEM','BITING','','','','kasir','2026-06-21 12:16:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-21' 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-260621-0017','K','2026-06-21','12:16:44','kasir','PEMBELIAN UMUM','FB-260621-0003','5813249000','1398000','5811851000');
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-00019451','X-00019451','AT X GYPSY HATI ANAK LG 8K','GR','---','A1E','BELI','BELI001','517000','2026-06-21','0.550','1','kasir','2026-06-21 12:17:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00019451','X-00019451');
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-260621-0004','F325261103341','SIN','1','BELI','BELI001','A1E', 'X-00019451', 'AT X GYPSY HATI ANAK LG 8K','0.550','0.550','100.00','558000','517000','940000','1095000','1','517000','517000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-21' 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-260621-0004','2026-06-21','2026-06-21','12:17:06','SIN','---','0.550','517000','517000','517000','517000','517000','kasir','2026-06-21 12:17:06','FB-260621-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260621-0004','SULIS','PRONGKOL','','','088292172043','kasir','2026-06-21 12:17:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-21' 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-260621-0018','K','2026-06-21','12:17:06','kasir','PEMBELIAN UMUM','FB-260621-0004','5811851000','517000','5811334000');
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-00019452','X-00019452','GL PUTIH 8K','GR','---','PFG','BELI','BELI001','1328000','2026-06-21','2.410','1','kasir','2026-06-21 12:18:19');
DELETE FROM tp_barang WHERE kode_dept = 'X-PFG';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-PFG','X-00019452','X-00019452');
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-260621-0005','F323050238181','FIT','1','BELI','BELI001','PFG', 'X-00019452', 'GL PUTIH 8K','2.410','2.410','100.00','1133000','1328000','551037','1135000','1','1328000','1328000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.410',berat_beli_asli=berat_beli_asli+'2.410',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.410',berat_akhir_asli=berat_akhir_asli+'2.410',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='PFG' 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-260621-0005','2026-06-21','2026-06-21','12:18:18','FIT','---','2.410','1328000','1328000','1328000','1328000','1328000','kasir','2026-06-21 12:18:19','FB-260621-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260621-0005','OCHI MAGDALENA','KISMANTORO','','','','kasir','2026-06-21 12:18:19');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-21' 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-260621-0019','K','2026-06-21','12:18:18','kasir','PEMBELIAN UMUM','FB-260621-0005','5811334000','1328000','5810006000');
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 ('F326210155401','kasir','1',' MDE1 X YS ','TOKO','PM-E','E1D-ZCCA-138-0','CC X VELG KACA YS 10 8K ','','0.980','1','100.00','1044000','0','0','15000','1045000','0','0','0','1045000','AAT','00397361','E1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCCA-138-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='E1D-ZCCA-138-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326210155401','2026-06-21','0.980','2026-06-21','13:55:40','PLG0029902','1045000','1045000','0','1045000','1045000','kasir','2026-06-21 13:55:40','F32621015540');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','F326210155401','2026-06-21','13:55:40','AAT','1045000','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-260621-0020','D','2026-06-21','13:55:40','kasir','PENJUALAN','F326210155401','5810006000','1045000','5811051000');
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 ('F326210220491','kasir','1',' MEE1 LG 10','TOKO','PM-E','E1E-ZFAE-11-0','CC MODEL ISYANA SLEP LG 10 8K ','','0.450','1','100.00','488000','0','0','15000','488000','0','0','0','488000','SIN','00408719','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAE-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='E1E-ZFAE-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326210220491','2026-06-21','0.450','2026-06-21','14:20:49','PLG0029903','488000','488000','0','488000','488000','kasir','2026-06-21 14:20:49','F32621022049');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','F326210220491','2026-06-21','14:20:49','SIN','488000','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-260621-0021','D','2026-06-21','14:20:49','kasir','PENJUALAN','F326210220491','5811051000','488000','5811539000');
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-00019453','X-00019453','CC MODEL PETIR CM 14 8K','GR','---','E1D','BELI','BELI001','1215000','2026-06-21','1.230','1','kasir','2026-06-21 14:34:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019453','X-00019453');
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-260621-0006','F326130201581','SIN','1','BELI','BELI001','E1D', 'X-00019453', 'CC MODEL PETIR CM 14 8K','1.230','1.230','100.00','1335000','1215000','987805','1075000','1','1215000','1215000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.230',berat_beli_asli=berat_beli_asli+'1.230',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.230',berat_akhir_asli=berat_akhir_asli+'1.230',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260621-0006','2026-06-21','2026-06-21','14:34:29','SIN','---','1.230','1215000','1215000','1215000','1215000','1215000','kasir','2026-06-21 14:34:30','FB-260621-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260621-0006','MARTINI','SANGGRONG','','','','kasir','2026-06-21 14:34:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-21' 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-260621-0022','K','2026-06-21','14:34:29','kasir','PEMBELIAN UMUM','FB-260621-0006','5811539000','1215000','5810324000');
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 ('F326210240411','kasir','1',' MEF3E X PM','TOKO','PM-F','F3E-ZDBX-59-0','GL X HARLEY SISIK NAGA SLEP PM 8K ','','8.000','1','100.00','8680000','0','0','15000','8680000','0','0','0','8680000','LIS','00399994','F3E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBX-59-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'8.000',berat_jual_asli=berat_jual_asli+'8.000',stock_jual='1',berat_akhir=berat_akhir-'8.000',berat_akhir_asli=berat_akhir_asli-'8.000',stock_akhir='0' WHERE tanggal='2026-06-21' AND kode_barang='F3E-ZDBX-59-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326210240411','2026-06-21','8.000','2026-06-21','14:40:42','PLG0029904','8680000','8680000','0','8680000','8680000','kasir','2026-06-21 14:40:41','F32621024041');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-21','F326210240411','2026-06-21','14:40:42','LIS','8680000','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-260621-0023','D','2026-06-21','14:40:42','kasir','PENJUALAN','F326210240411','5810324000','8680000','5819004000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260621-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260621-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260621-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260621-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260621-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260621-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260621-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260621-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260621-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260621-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260621-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260621-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326210155401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326210155401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326210155401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326210220491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326210220491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326210220491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326210240411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326210240411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326210240411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326210853131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326210853131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326210853131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326210855571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326210855571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326210855571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326210909531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326210909531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326210909531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326210909532' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326210909532' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326210909532';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326210927241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326210927241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326210927241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326210958251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326210958251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326210958251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211037291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211037291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211037291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211038531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211038531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211038531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211107391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211107391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211107391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211135321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211135321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211135321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211140161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211140161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211140161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211146351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211146351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211146351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326211146352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326211146352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326211146352';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-22','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-22';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-21';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-21';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-06-21' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-21';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-21';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-21';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-21';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-22' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-21' 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-260622-0001','D','2026-06-22','15:16:23','SYSTEM','SALDO AWAL','SALDO AWAL','0','5819004000','5819004000');
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-260622-0001','D','2026-06-22','15:16:23','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260622-0001','D','2026-06-22','15:16:23','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260622-0001','D','2026-06-22','15:16:23','BCA','SALDO AWAL','SALDO AWAL','0','732522000','732522000');
UPDATE tp_system SET tgl_system='2026-06-22';