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 ('F326260858241','input','1',' MEF1 X UB ','TOKO','PM-F','F1E-ZCBX-102-0','GL X SHOGUN POLOS UB 56 8K ','','4.940','1','100.00','5113000','0','0','15000','5113000','0','0','0','5113000','SIN','00396304','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCBX-102-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-07-26' AND kode_barang='F1E-ZCBX-102-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 ('F326260858241','2026-07-26','4.940','2026-07-26','08:58:24','PLG0030498','5113000','5113000','0','5113000','5113000','input','2026-07-26 08:58:24','F32626085824');
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-07-26','F326260858241','2026-07-26','08:58:24','SIN','5113000','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-260726-0002','D','2026-07-26','08:58:24','input','PENJUALAN','F326260858241','6474242000','5113000','6479355000');
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 ('F326260927351','input','1',' MEA1E X LG','TOKO','PM-A','A1E-YHXB-19-0','AT X MODEL MATA VAR LG 8K ','','0.450','1','100.00','466000','0','0','15000','465000','0','0','0','465000','LIS','00363429','A1E','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YHXB-19-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-07-26' AND kode_barang='A1E-YHXB-19-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 ('F326260927351','2026-07-26','0.450','2026-07-26','09:27:36','PLG0030499','465000','465000','0','465000','465000','input','2026-07-26 09:27:35','F32626092735');
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-07-26','F326260927351','2026-07-26','09:27:36','LIS','465000','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-260726-0003','D','2026-07-26','09:27:36','input','PENJUALAN','F326260927351','6479355000','465000','6479820000');
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 ('F326261001101','input','1',' MEE1 CM 14','TOKO','PM-E','E1E-ZGXA-311-0','CC MODEL GELOMBANG SLEP CM 14 8K ','','0.660','1','100.00','683000','0','0','15000','683000','0','0','0','683000','FIT','00411835','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXA-311-0' 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='2026-07-26' AND kode_barang='E1E-ZGXA-311-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 ('F326261001101','2026-07-26','0.660','2026-07-26','10:01:10','PLG0030500','683000','683000','0','683000','683000','input','2026-07-26 10:01:10','F32626100110');
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-07-26','F326261001101','2026-07-26','10:01:10','FIT','683000','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-260726-0004','D','2026-07-26','10:01:10','input','PENJUALAN','F326261001101','6479820000','683000','6480503000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='683000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261001101' 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 ('F326261001102','input',' 1',' MEF1 XX YT','TOKO','PM-F','F1E-ZCBX-97-0','GL XX OVAL C SLEP YT 54 8K ','','4.230','1','100.00','4378000','0','0','15000','4252000','0','0','0','4252000','FIT','00396299','F1E','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCBX-97-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.230',berat_jual_asli=berat_jual_asli+'4.230',stock_jual='1',berat_akhir=berat_akhir-'4.230',berat_akhir_asli=berat_akhir_asli-'4.230',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='F1E-ZCBX-97-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 ('F326261001102','2026-07-26','4.230','2026-07-26','10:01:10','PLG0030501','4252000','4252000','0','4252000','4252000','input','2026-07-26 10:01:10','F32626100110');
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-07-26','F326261001102','2026-07-26','10:01:10','FIT','4252000','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-260726-0005','D','2026-07-26','10:01:10','input','PENJUALAN','F326261001102','6480503000','4252000','6484755000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4252000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261001102' 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 ('F326261018381','input','1',' MDA1D X LG','TOKO','PM-A','A1D-YKAG-25-0','AT X GYPSY SLEP LG 8K ','','1.060','1','100.00','1076000','0','0','15000','1075000','0','0','0','1075000','AAT','00377601','A1D','0','0','-','1','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YKAG-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='A1D-YKAG-25-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 ('F326261018381','2026-07-26','1.060','2026-07-26','10:18:38','PLG0030502','1075000','1075000','0','1075000','1075000','input','2026-07-26 10:18:38','F32626101838');
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-07-26','F326261018381','2026-07-26','10:18:38','AAT','1075000','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-260726-0006','D','2026-07-26','10:18:38','input','PENJUALAN','F326261018381','6484755000','1075000','6485830000');
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 ('F326261021471','input','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZGBA-171-0','CC X MODEL SLEP CM 24 8K ','','1.230','1','100.00','1248000','0','0','15000','1248000','0','0','0','1248000','LIS','00414653','E1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGBA-171-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.230',berat_jual_asli=berat_jual_asli+'1.230',stock_jual='1',berat_akhir=berat_akhir-'1.230',berat_akhir_asli=berat_akhir_asli-'1.230',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='E1D-ZGBA-171-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 ('F326261021471','2026-07-26','1.230','2026-07-26','10:21:47','PLG0030503','1248000','1248000','0','1248000','1248000','input','2026-07-26 10:21:47','F32626102147');
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-07-26','F326261021471','2026-07-26','10:21:47','LIS','1248000','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-260726-0007','D','2026-07-26','10:21:47','input','PENJUALAN','F326261021471','6485830000','1248000','6487078000');
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 ('F326261036361','input','1',' MEF1 XX YT','TOKO','PM-F','F1E-ZFCX-40-0','GL XX OVAL C SLEP YT 54 8K ','','2.900','1','100.00','3001000','0','0','15000','2915000','0','0','0','2915000','FIT','00411247','F1E','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFCX-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.900',berat_jual_asli=berat_jual_asli+'2.900',stock_jual='1',berat_akhir=berat_akhir-'2.900',berat_akhir_asli=berat_akhir_asli-'2.900',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='F1E-ZFCX-40-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 ('F326261036361','2026-07-26','2.900','2026-07-26','10:36:37','PLG0030504','2915000','2915000','0','2915000','2915000','input','2026-07-26 10:36:36','F32626103636');
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-07-26','F326261036361','2026-07-26','10:36:37','FIT','2915000','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-260726-0008','D','2026-07-26','10:36:37','input','PENJUALAN','F326261036361','6487078000','2915000','6489993000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2915000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261036361' 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 ('F326261036362','input',' 1',' MEF2 10K L','TOKO','PM-F','F2E-ZFBC-58-0','GL PIPA BONEKA ANAK MATA CAT SLEP LG 36 8K ','','1.960','1','100.00','2029000','0','0','15000','2030000','0','10000','0','2040000','FIT','00409932','F2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZFBC-58-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.960',berat_jual_asli=berat_jual_asli+'1.960',stock_jual='1',berat_akhir=berat_akhir-'1.960',berat_akhir_asli=berat_akhir_asli-'1.960',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='F2E-ZFBC-58-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326261036362','2026-07-26','1.960','2026-07-26','10:36:37','PLG0030505','2030000','2030000','10000','2040000','2040000','input','2026-07-26 10:36:36','F32626103636');
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-07-26','F326261036362','2026-07-26','10:36:37','FIT','2040000','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-260726-0009','D','2026-07-26','10:36:37','input','PENJUALAN','F326261036362','6489993000','2040000','6492033000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2040000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261036362' 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 ('F326261039271','input','1',' MEE1 X LG ','TOKO','PM-E','E1E-ZGXA-207-0','CC X MODEL DAUN SLEP LG 14 8K ','','0.520','1','100.00','538000','0','0','15000','540000','0','0','0','540000','AAT','00411731','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXA-207-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-07-26' AND kode_barang='E1E-ZGXA-207-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 ('F326261039271','2026-07-26','0.520','2026-07-26','10:39:27','PLG0030506','540000','540000','0','540000','540000','input','2026-07-26 10:39:27','F32626103927');
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-07-26','F326261039271','2026-07-26','10:39:27','AAT','540000','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-260726-0010','D','2026-07-26','10:39:27','input','PENJUALAN','F326261039271','6492033000','540000','6492573000');
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 ('F326261040271','input','1',' MEA1E X LG','TOKO','PM-A','A1E-ZDAX-105-0','AT X GYPSY MRICAN SLEP LG 8K ','','0.550','1','100.00','569000','0','0','15000','570000','0','0','0','570000','SIN','00398875','A1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZDAX-105-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-07-26' AND kode_barang='A1E-ZDAX-105-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 ('F326261040271','2026-07-26','0.550','2026-07-26','10:40:27','PLG0030507','570000','570000','0','570000','570000','input','2026-07-26 10:40:27','F32626104027');
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-07-26','F326261040271','2026-07-26','10:40:27','SIN','570000','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-260726-0011','D','2026-07-26','10:40:27','input','PENJUALAN','F326261040271','6492573000','570000','6493143000');
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 ('F326261041361','input','1',' MEH1 X KH ','TOKO','PM-H','H1E-ZGXI-138-0','KL X SIEM COBRA KH 42 8K ','','1.250','1','100.00','1294000','0','0','15000','1295000','0','0','0','1295000','LIS','00412857','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGXI-138-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.250',berat_jual_asli=berat_jual_asli+'1.250',stock_jual='1',berat_akhir=berat_akhir-'1.250',berat_akhir_asli=berat_akhir_asli-'1.250',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='H1E-ZGXI-138-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326261041361','2026-07-26','1.250','2026-07-26','10:41:36','PLG0030508','1295000','1295000','0','1295000','1295000','input','2026-07-26 10:41:36','F32626104136');
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-07-26','F326261041361','2026-07-26','10:41:36','LIS','1295000','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-260726-0012','D','2026-07-26','10:41:36','input','PENJUALAN','F326261041361','6493143000','1295000','6494438000');
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 ('F326261109561','input','1',' MCE0 X DG ','TOKO','PM-E','E0C-XHBG-90-0','CC X STEMPEL DG 27 8K ','','5.000','1','100.00','4975000','0','0','15000','4975000','0','0','0','4975000','AAT','00314021','E0C','0','0','-','0','995000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0C-XHBG-90-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.000',berat_jual_asli=berat_jual_asli+'5.000',stock_jual='1',berat_akhir=berat_akhir-'5.000',berat_akhir_asli=berat_akhir_asli-'5.000',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='E0C-XHBG-90-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 ('F326261109561','2026-07-26','5.000','2026-07-26','11:09:56','PLG0030509','4975000','4975000','0','4975000','4975000','input','2026-07-26 11:09:56','F32626110956');
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-07-26','F326261109561','2026-07-26','11:09:56','AAT','4975000','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-260726-0013','D','2026-07-26','11:09:56','input','PENJUALAN','F326261109561','6494438000','4975000','6499413000');
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 ('F326261112421','input','1',' MEF1 X UB ','TOKO','PM-F','F1E-YLAF-160-0','GL X SHOGUN POLOS UB 56 8K ','','7.880','1','100.00','8156000','0','0','15000','8156000','0','0','0','8156000','FIT','00381344','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLAF-160-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'7.880',berat_jual_asli=berat_jual_asli+'7.880',stock_jual='1',berat_akhir=berat_akhir-'7.880',berat_akhir_asli=berat_akhir_asli-'7.880',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='F1E-YLAF-160-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 ('F326261112421','2026-07-26','7.880','2026-07-26','11:12:42','PLG0030510','8156000','8156000','0','8156000','8156000','input','2026-07-26 11:12:42','F32626111242');
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-07-26','F326261112421','2026-07-26','11:12:42','FIT','8156000','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-260726-0014','D','2026-07-26','11:12:42','input','PENJUALAN','F326261112421','6499413000','8156000','6507569000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='8156000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261112421' 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 ('F326261112422','input',' 1',' MEF1 X UB ','TOKO','PM-F','F1E-ZFXH-14-0','GL X OVAL ISYANA SLEP UB 54 8K ','','5.680','1','100.00','5879000','0','0','15000','5879000','0','0','0','5879000','FIT','00407875','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFXH-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.680',berat_jual_asli=berat_jual_asli+'5.680',stock_jual='1',berat_akhir=berat_akhir-'5.680',berat_akhir_asli=berat_akhir_asli-'5.680',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='F1E-ZFXH-14-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 ('F326261112422','2026-07-26','5.680','2026-07-26','11:12:42','PLG0030511','5879000','5879000','0','5879000','5879000','input','2026-07-26 11:12:42','F32626111242');
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-07-26','F326261112422','2026-07-26','11:12:42','FIT','5879000','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-260726-0015','D','2026-07-26','11:12:42','input','PENJUALAN','F326261112422','6507569000','5879000','6513448000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5879000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261112422' 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 ('F326261112423','input',' 1',' MDE2D X UB','TOKO','PM-E','E2D-ZFBI-61-0','CC X MODEL MATA UB 14 8K ','','2.310','1','100.00','2345000','0','0','15000','2345000','0','0','0','2345000','FIT','00411053','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFBI-61-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.310',berat_jual_asli=berat_jual_asli+'2.310',stock_jual='1',berat_akhir=berat_akhir-'2.310',berat_akhir_asli=berat_akhir_asli-'2.310',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='E2D-ZFBI-61-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 ('F326261112423','2026-07-26','2.310','2026-07-26','11:12:42','PLG0030512','2345000','2345000','0','2345000','2345000','input','2026-07-26 11:12:42','F32626111242');
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-07-26','F326261112423','2026-07-26','11:12:42','FIT','2345000','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-260726-0016','D','2026-07-26','11:12:42','input','PENJUALAN','F326261112423','6513448000','2345000','6515793000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2345000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261112423' 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 ('F326261135211','input','1',' MEF2 XXX P','TOKO','PM-F','F2E-ZFAG-42-0','GL XXX PIPA MATA PM 54 8K ','','4.000','1','100.00','4140000','0','0','15000','4020000','0','0','0','4020000','FIT','00408865','F2E','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZFAG-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.000',berat_jual_asli=berat_jual_asli+'4.000',stock_jual='1',berat_akhir=berat_akhir-'4.000',berat_akhir_asli=berat_akhir_asli-'4.000',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='F2E-ZFAG-42-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 ('F326261135211','2026-07-26','4.000','2026-07-26','11:35:21','PLG0030513','4020000','4020000','0','4020000','4020000','input','2026-07-26 11:35:21','F32626113521');
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-07-26','F326261135211','2026-07-26','11:35:21','FIT','4020000','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-260726-0017','D','2026-07-26','11:35:21','input','PENJUALAN','F326261135211','6515793000','4020000','6519813000');
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 ('F326261144431','input','1',' MEF1 X YT ','TOKO','PM-F','F1E-ZFXH-8-0','GL X OVAL C SLEP YT 60 8K ','','3.250','1','100.00','3364000','0','0','15000','3364000','0','0','0','3364000','SIN','00407869','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFXH-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.250',berat_jual_asli=berat_jual_asli+'3.250',stock_jual='1',berat_akhir=berat_akhir-'3.250',berat_akhir_asli=berat_akhir_asli-'3.250',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='F1E-ZFXH-8-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 ('F326261144431','2026-07-26','3.250','2026-07-26','11:44:44','PLG0030514','3364000','3364000','0','3364000','3364000','input','2026-07-26 11:44:43','F32626114443');
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-07-26','F326261144431','2026-07-26','11:44:44','SIN','3364000','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-260726-0018','D','2026-07-26','11:44:44','input','PENJUALAN','F326261144431','6519813000','3364000','6523177000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3364000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261144431' 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 ('F326261144432','input',' 1',' MEF1E UB 6','TOKO','PM-F','F1E-ZGAA-72-0','GL OVAL C SLEP UB 60 8K ','','2.350','1','100.00','2432000','0','0','15000','2432000','0','0','0','2432000','SIN','00413251','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGAA-72-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.350',berat_jual_asli=berat_jual_asli+'2.350',stock_jual='1',berat_akhir=berat_akhir-'2.350',berat_akhir_asli=berat_akhir_asli-'2.350',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='F1E-ZGAA-72-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 ('F326261144432','2026-07-26','2.350','2026-07-26','11:44:44','PLG0030515','2432000','2432000','0','2432000','2432000','input','2026-07-26 11:44:43','F32626114443');
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-07-26','F326261144432','2026-07-26','11:44:44','SIN','2432000','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-260726-0019','D','2026-07-26','11:44:44','input','PENJUALAN','F326261144432','6523177000','2432000','6525609000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2432000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326261144432' 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 ('F326261150071','input','1',' MGA1G X LG','TOKO','PM-A','A1G-ZFAB-133-0','AT X DAKOCAN LG 8K ','','0.300','1','100.00','322000','0','0','15000','323000','0','0','0','323000','LIS','00408602','A1G','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZFAB-133-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='A1G-ZFAB-133-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 ('F326261150071','2026-07-26','0.300','2026-07-26','11:50:08','PLG0030516','323000','323000','0','323000','323000','input','2026-07-26 11:50:07','F32626115007');
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-07-26','F326261150071','2026-07-26','11:50:08','LIS','323000','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-260726-0020','D','2026-07-26','11:50:08','input','PENJUALAN','F326261150071','6525609000','323000','6525932000');
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-00019742','X-00019742','KL X WG SANTA KH 44 9K','GR','---','PHK','BELI','BELI001','2970000','2026-07-26','2.900','1','kasir','2026-07-26 12:07:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-PHK';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-PHK','X-00019742','X-00019742');
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-260726-0001','F325071113451','SIN','1','BELI','BELI001','PHK', 'X-00019742', 'KL X WG SANTA KH 44 9K','2.900','2.900','100.00','3195000','2970000','1024138','1155000','1','2970000','2970000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.900',berat_beli_asli=berat_beli_asli+'2.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.900',berat_akhir_asli=berat_akhir_asli+'2.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='PHK' 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-260726-0001','2026-07-26','2026-07-26','12:07:37','SIN','---','2.900','2970000','2970000','2970000','2970000','2970000','kasir','2026-07-26 12:07:37','FB-260726-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260726-0001','EDI','TENGGER PUHPELEM','','','','kasir','2026-07-26 12:07:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-26' 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-260726-0021','K','2026-07-26','12:07:37','kasir','PEMBELIAN UMUM','FB-260726-0001','6525932000','2970000','6522962000');
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-00019743','X-00019743','GW X MODEL SLEP LG PE 8K','GR','---','B1E','BELI','BELI001','465000','2026-07-26','0.480','1','kasir','2026-07-26 12:08:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00019743','X-00019743');
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-260726-0002','F326241030241','LIS','1','BELI','BELI001','B1E', 'X-00019743', 'GW X MODEL SLEP LG PE 8K','0.480','0.480','100.00','526000','465000','968750','1045000','1','465000','465000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.480',berat_beli_asli=berat_beli_asli+'0.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.480',berat_akhir_asli=berat_akhir_asli+'0.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' 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-260726-0002','2026-07-26','2026-07-26','12:08:37','LIS','---','0.480','465000','465000','465000','465000','465000','kasir','2026-07-26 12:08:37','FB-260726-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260726-0002','ANA','SLOGOHIMO','','','082257627291','kasir','2026-07-26 12:08:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-26' 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-260726-0022','K','2026-07-26','12:08:37','kasir','PEMBELIAN UMUM','FB-260726-0002','6522962000','465000','6522497000');
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-00019744','X-00019744','AT HUGGIES KLIP MODEL PITA CAT VAR LG 8K','GR','---','A1D','BELI','BELI001','725000','2026-07-26','1.050','1','kasir','2026-07-26 12:09:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00019744','X-00019744');
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-260726-0003','F325021107091','AAT','1','BELI','BELI001','A1D', 'X-00019744', 'AT HUGGIES KLIP MODEL PITA CAT VAR LG 8K','1.050','1.050','100.00','758000','725000','690476','1025000','1','725000','725000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260726-0003','2026-07-26','2026-07-26','12:09:02','AAT','---','1.050','725000','725000','725000','725000','725000','kasir','2026-07-26 12:09:03','FB-260726-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260726-0003','SITI HANDAYANI','KARANG GONDANG 01/02PURWANTORO','','','08889027477','kasir','2026-07-26 12:09:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-26' 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-260726-0023','K','2026-07-26','12:09:02','kasir','PEMBELIAN UMUM','FB-260726-0003','6522497000','725000','6521772000');
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-00019745','X-00019745','GW X ITALY SLEP UB 8K','GR','---','B1F','BELI','BELI001','630000','2026-07-26','0.700','1','kasir','2026-07-26 12:09:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00019745','X-00019745');
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-260726-0004','F325020256531','AAT','1','BELI','BELI001','B1F', 'X-00019745', 'GW X ITALY SLEP UB 8K','0.700','0.700','100.00','740000','630000','900000','1065000','1','630000','630000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.700',berat_beli_asli=berat_beli_asli+'0.700',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.700',berat_akhir_asli=berat_akhir_asli+'0.700',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260726-0004','2026-07-26','2026-07-26','12:09:35','AAT','---','0.700','630000','630000','630000','630000','630000','kasir','2026-07-26 12:09:35','FB-260726-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260726-0004','SITI HANDAYANI','TANGERANG','','','','kasir','2026-07-26 12:09:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-26' 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-260726-0024','K','2026-07-26','12:09:35','kasir','PEMBELIAN UMUM','FB-260726-0004','6521772000','630000','6521142000');
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-00019746','X-00019746','GL LEMES 8K','GR','---','F3E','BELI','BELI001','1152000','2026-07-26','1.200','1','kasir','2026-07-26 12:11:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019746','X-00019746');
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-260726-0005','00402472','SIN','1','BELI','BELI001','F3E', 'X-00019746', 'GL LEMES 8K','1.200','1.200','100.00','1353000','1152000','960000','1045000','1','1152000','1152000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.200',berat_beli_asli=berat_beli_asli+'1.200',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.200',berat_akhir_asli=berat_akhir_asli+'1.200',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-26' 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-260726-0005','2026-07-26','2026-07-26','12:11:34','SIN','---','1.200','1152000','1152000','1152000','1152000','1152000','kasir','2026-07-26 12:11:34','FB-260726-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260726-0005','YULIS','BANDARALIM BADEGAN','','','','kasir','2026-07-26 12:11:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-26' 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-260726-0025','K','2026-07-26','12:11:34','kasir','PEMBELIAN UMUM','FB-260726-0005','6521142000','1152000','6519990000');
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-00019747','X-00019747','GL X RANTAI HOLLOW P3 SLEP ANAK LT 8K','GR','---','F3E','BELI','BELI001','927000','2026-07-26','1.020','1','kasir','2026-07-26 12:13:12');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019747','X-00019747');
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-260726-0006','F325140159401','LIS','1','BELI','BELI001','F3E', 'X-00019747', 'GL X RANTAI HOLLOW P3 SLEP ANAK LT 8K','1.020','1.020','100.00','1068000','927000','908824','1045000','1','927000','927000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.020',berat_beli_asli=berat_beli_asli+'1.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.020',berat_akhir_asli=berat_akhir_asli+'1.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-26' 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-260726-0006','2026-07-26','2026-07-26','12:13:11','LIS','---','1.020','927000','927000','927000','927000','927000','kasir','2026-07-26 12:13:12','FB-260726-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260726-0006','NUNIT','TANJUNG BULUKERTO','','','','kasir','2026-07-26 12:13:12');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-26' 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-260726-0026','K','2026-07-26','12:13:11','kasir','PEMBELIAN UMUM','FB-260726-0006','6519990000','927000','6519063000');
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-00019748','X-00019748','GW TOUGE MODEL MATA VAR HK 8K','GR','---','B1F','BELI','BELI001','250000','2026-07-26','0.500','1','kasir','2026-07-26 12:13:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00019748','X-00019748');
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-260726-0007','F324270956182','SIN','1','BELI','BELI001','B1F', 'X-00019748', 'GW TOUGE MODEL MATA VAR HK 8K','0.500','0.500','100.00','268000','250000','500000','1065000','1','250000','250000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260726-0007','2026-07-26','2026-07-26','12:13:43','SIN','---','0.500','250000','250000','250000','250000','250000','kasir','2026-07-26 12:13:43','FB-260726-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260726-0007','MADA','GAMBIRANOM KISMANTORO','','','','kasir','2026-07-26 12:13:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-26' 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-260726-0027','K','2026-07-26','12:13:43','kasir','PEMBELIAN UMUM','FB-260726-0007','6519063000','250000','6518813000');
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-00019749','X-00019749','GL SIEM COBRA UB 8K','GR','---','F3F','BELI','BELI001','1000000','2026-07-26','1.020','1','kasir','2026-07-26 12:14:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00019749','X-00019749');
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-260726-0008','F326081113582','SIN','1','BELI','BELI001','F3F', 'X-00019749', 'GL SIEM COBRA UB 8K','1.020','1.020','100.00','1265000','1000000','980392','1065000','1','1000000','1000000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.020',berat_beli_asli=berat_beli_asli+'1.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.020',berat_akhir_asli=berat_akhir_asli+'1.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260726-0008','2026-07-26','2026-07-26','12:14:13','SIN','---','1.020','1000000','1000000','1000000','1000000','1000000','kasir','2026-07-26 12:14:14','FB-260726-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260726-0008','LESTARI','BANDAR PACITAN','','','082145807686','kasir','2026-07-26 12:14:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-26' 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-260726-0028','K','2026-07-26','12:14:13','kasir','PEMBELIAN UMUM','FB-260726-0008','6518813000','1000000','6517813000');
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-00019750','X-00019750','CC X RING GELOMBANG SLEP HW 15 8K','GR','---','E1F','BELI','BELI001','390000','2026-07-26','0.400','1','kasir','2026-07-26 12:14:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1F','X-00019750','X-00019750');
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-260726-0009','F326091259581','SIN','1','BELI','BELI001','E1F', 'X-00019750', 'CC X RING GELOMBANG SLEP HW 15 8K','0.400','0.400','100.00','456000','390000','975000','1065000','1','390000','390000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.400',berat_beli_asli=berat_beli_asli+'0.400',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.400',berat_akhir_asli=berat_akhir_asli+'0.400',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260726-0009','2026-07-26','2026-07-26','12:14:46','SIN','---','0.400','390000','390000','390000','390000','390000','kasir','2026-07-26 12:14:46','FB-260726-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260726-0009','FELICIA','BANDAR PACITAN','','','082145807686','kasir','2026-07-26 12:14:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-26' 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-260726-0029','K','2026-07-26','12:14:46','kasir','PEMBELIAN UMUM','FB-260726-0009','6517813000','390000','6517423000');
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-00019751','X-00019751','LT X MODEL MATA LG 8K','GR','---','D2E','BELI','BELI001','425000','2026-07-26','0.500','1','kasir','2026-07-26 12:15:39');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00019751','X-00019751');
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-260726-0010','F325160953451','AAT','1','BELI','BELI001','D2E', 'X-00019751', 'LT X MODEL MATA LG 8K','0.500','0.500','100.00','453000','425000','850000','1045000','1','425000','425000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' 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-260726-0010','2026-07-26','2026-07-26','12:15:38','AAT','---','0.500','425000','425000','425000','425000','425000','kasir','2026-07-26 12:15:39','FB-260726-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260726-0010','SUDARSI','TRITIS TEGALREJO','','','','kasir','2026-07-26 12:15:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-26' 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-260726-0030','K','2026-07-26','12:15:38','kasir','PEMBELIAN UMUM','FB-260726-0010','6517423000','425000','6516998000');
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 ('F326260124111','kasir','1',' MIH2 X KH ','TOKO','PM-H','H2I-WDBA-224-0','KL X KOREA KH 44 ','','15.010','1','100.00','16736000','0','0','15000','16735000','0','0','0','16735000','SIN','00228173','H2I','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-WDBA-224-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'15.010',berat_jual_asli=berat_jual_asli+'15.010',stock_jual='1',berat_akhir=berat_akhir-'15.010',berat_akhir_asli=berat_akhir_asli-'15.010',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='H2I-WDBA-224-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326260124111','2026-07-26','15.010','2026-07-26','13:24:12','PLG0030517','16735000','16735000','0','16735000','16735000','kasir','2026-07-26 13:24:11','F32626012411');
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-07-26','F326260124111','2026-07-26','13:24:12','SIN','16735000','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-260726-0031','D','2026-07-26','13:24:12','kasir','PENJUALAN','F326260124111','6516998000','16735000','6533733000');
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 ('F326260131151','kasir','1',' MEH1 UB 32','TOKO','PM-H','H1E-ZDXH-114-0','KL MILANO ANAK 32 CM UB 8K ','','2.060','1','100.00','2132000','0','0','15000','2133000','0','0','0','2133000','LIS','00398566','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDXH-114-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='H1E-ZDXH-114-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326260131151','2026-07-26','2.060','2026-07-26','13:31:15','PLG0030518','2133000','2133000','0','2133000','2133000','kasir','2026-07-26 13:31:15','F32626013115');
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-07-26','F326260131151','2026-07-26','13:31:15','LIS','2133000','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-260726-0032','D','2026-07-26','13:31:15','kasir','PENJUALAN','F326260131151','6533733000','2133000','6535866000');
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 ('F326260234511','input','1',' MIF4I X KH','TOKO','PM-F','F4I-ZDBB-32-0','GL X RANTAI HOLLOW KH 9K ','','3.070','1','100.00','3423000','0','0','15000','3423000','0','0','0','3423000','LIS','00400642','F4I','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F4I-ZDBB-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.070',berat_jual_asli=berat_jual_asli+'3.070',stock_jual='1',berat_akhir=berat_akhir-'3.070',berat_akhir_asli=berat_akhir_asli-'3.070',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='F4I-ZDBB-32-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 ('F326260234511','2026-07-26','3.070','2026-07-26','14:34:51','PLG0030519','3423000','3423000','0','3423000','3423000','input','2026-07-26 14:34:51','F32626023451');
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-07-26','F326260234511','2026-07-26','14:34:51','LIS','3423000','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-260726-0033','D','2026-07-26','14:34:51','input','PENJUALAN','F326260234511','6535866000','3423000','6539289000');
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 ('F326260246351','input','1',' MDE2 CM 10','TOKO','PM-E','E2D-ZFAE-8-0','CC WEDDING MATA CM 10 8K ','','0.870','1','100.00','883000','0','0','15000','885000','0','0','0','885000','FIT','00408716','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFAE-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.870',berat_jual_asli=berat_jual_asli+'0.870',stock_jual='1',berat_akhir=berat_akhir-'0.870',berat_akhir_asli=berat_akhir_asli-'0.870',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='E2D-ZFAE-8-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 ('F326260246351','2026-07-26','0.870','2026-07-26','14:46:35','PLG0030520','885000','885000','0','885000','885000','input','2026-07-26 14:46:35','F32626024635');
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-07-26','F326260246351','2026-07-26','14:46:35','FIT','885000','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-260726-0034','D','2026-07-26','14:46:35','input','PENJUALAN','F326260246351','6539289000','885000','6540174000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='885000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326260246351' 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 ('F326260246352','input',' 1',' MDE2 CM 16','TOKO','PM-E','E2D-ZGAH-135-0','CC COR MODEL MATA CM 16 8K ','','0.880','1','100.00','893000','0','0','15000','895000','0','0','0','895000','FIT','00414196','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGAH-135-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.880',berat_jual_asli=berat_jual_asli+'0.880',stock_jual='1',berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='E2D-ZGAH-135-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 ('F326260246352','2026-07-26','0.880','2026-07-26','14:46:35','PLG0030521','895000','895000','0','895000','895000','input','2026-07-26 14:46:35','F32626024635');
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-07-26','F326260246352','2026-07-26','14:46:35','FIT','895000','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-260726-0035','D','2026-07-26','14:46:35','input','PENJUALAN','F326260246352','6540174000','895000','6541069000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='895000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326260246352' 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-00019752','X-00019752','GL X TIFF HATI SERUT UB 8K','GR','---','F3E','BELI','BELI001','1417000','2026-07-26','1.460','1','kasir','2026-07-26 14:50:58');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019752','X-00019752');
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-260726-0011','F326031050011','SIN','1','BELI','BELI001','F3E', 'X-00019752', 'GL X TIFF HATI SERUT UB 8K','1.460','1.460','100.00','1570000','1417000','970548','1045000','1','1417000','1417000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.460',berat_beli_asli=berat_beli_asli+'1.460',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.460',berat_akhir_asli=berat_akhir_asli+'1.460',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-26' 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-260726-0011','2026-07-26','2026-07-26','14:50:57','SIN','---','1.460','1417000','1417000','1417000','1417000','1417000','kasir','2026-07-26 14:50:58','FB-260726-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260726-0011','SINTYA','BUTUH WARU SLG','','','082135503516','kasir','2026-07-26 14:50:58');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-26' 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-260726-0036','K','2026-07-26','14:50:57','kasir','PEMBELIAN UMUM','FB-260726-0011','6541069000','1417000','6539652000');
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 ('F326260255021','kasir','1',' TDE1 CM 18','TOKO','PT-E','E1TD-ZGAG-49-T','CC VELG POLOS SLEP CM 18 17K ','','1.030','1','100.00','1926000','0','0','15000','1925000','0','0','0','1925000','LIS','T0081272','E1TD','0','0','-','1','1870000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-ZGAG-49-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='E1TD-ZGAG-49-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326260255021','2026-07-26','1.030','2026-07-26','14:55:03','PLG0030522','1925000','1925000','0','1925000','1925000','kasir','2026-07-26 14:55:02','F32626025502');
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-07-26','F326260255021','2026-07-26','14:55:03','LIS','1925000','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-260726-0037','D','2026-07-26','14:55:03','kasir','PENJUALAN','F326260255021','6539652000','1925000','6541577000');
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 ('F326260258051','kasir','1',' MEA1 X 5K ','TOKO','PM-A','A1E-ZGAD-29-0','AT X BONEKA ANAK CAT LG 8K ','','0.580','1','100.00','600000','0','0','15000','600000','0','5000','0','605000','FIT','00413476','A1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZGAD-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-07-26' AND kode_barang='A1E-ZGAD-29-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 ('F326260258051','2026-07-26','0.580','2026-07-26','14:58:05','PLG0030523','600000','600000','5000','605000','605000','kasir','2026-07-26 14:58:05','F32626025805');
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-07-26','F326260258051','2026-07-26','14:58:05','FIT','605000','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-260726-0038','D','2026-07-26','14:58:05','kasir','PENJUALAN','F326260258051','6541577000','605000','6542182000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260726-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260726-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260726-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260726-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260726-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260726-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260726-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260726-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260726-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260726-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260726-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260726-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260726-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260726-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260726-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260726-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260726-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260726-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260726-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260726-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260726-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260726-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260124111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260124111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260124111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260131151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260131151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260131151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260234511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260234511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260234511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260246351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260246351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260246351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260246352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260246352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260246352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260255021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260255021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260255021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260258051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260258051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260258051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260858241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260858241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260858241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260927351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260927351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260927351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261001101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261001101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261001101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261001102' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261001102' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261001102';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261018381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261018381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261018381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261021471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261021471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261021471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261036361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261036361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261036361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261036362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261036362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261036362';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261039271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261039271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261039271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261040271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261040271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261040271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261041361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261041361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261041361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261109561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261109561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261109561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261112421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261112421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261112421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261112422' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261112422' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261112422';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261112423' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261112423' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261112423';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261135211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261135211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261135211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261144431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261144431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261144431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261144432' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261144432' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261144432';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261150071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261150071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261150071';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-27','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-26';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-26';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-26';
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-07-26' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-26';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-26';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-26';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-26';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-27' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-26' 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-260727-0001','D','2026-07-27','15:27:37','SYSTEM','SALDO AWAL','SALDO AWAL','0','6542182000','6542182000');
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-260727-0001','D','2026-07-27','15:27:37','BCA','SALDO AWAL','SALDO AWAL','0','738685000','738685000');
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-260727-0001','D','2026-07-27','15:27:37','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-260727-0001','D','2026-07-27','15:27:37','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-07-27';