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 ('F326110810491','input','1',' MEF1 X TD ','TOKO','PM-F','F1E-YLAE-59-0','GL X OVAL C SLEP TD 58 8K ','','3.380','1','100.00','3752000','0','0','15000','3750000','0','0','0','3750000','AAT','00381037','F1E','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLAE-59-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.380',berat_jual_asli=berat_jual_asli+'3.380',stock_jual='1',berat_akhir=berat_akhir-'3.380',berat_akhir_asli=berat_akhir_asli-'3.380',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='F1E-YLAE-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 ('F326110810491','2026-01-11','3.380','2026-01-11','08:10:49','PLG0026679','3750000','3750000','0','3750000','3750000','input','2026-01-11 08:10:49','F32611081049');
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-01-11','F326110810491','2026-01-11','08:10:49','AAT','3750000','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-260111-0002','D','2026-01-11','08:10:49','input','PENJUALAN','F326110810491','1780473000','3750000','1784223000');
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 ('F326110816441','input','1',' MIF4I X UB','TOKO','PM-F','F4I-YLBX-228-0','GL X KOREA SLEP UB 9K ','','2.090','1','100.00','2487000','0','0','15000','2465000','0','0','0','2465000','SIN','00382108','F4I','0','0','-','1','1190000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F4I-YLBX-228-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.090',berat_jual_asli=berat_jual_asli+'2.090',stock_jual='1',berat_akhir=berat_akhir-'2.090',berat_akhir_asli=berat_akhir_asli-'2.090',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='F4I-YLBX-228-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 ('F326110816441','2026-01-11','2.090','2026-01-11','08:16:45','PLG0026680','2465000','2465000','0','2465000','2465000','input','2026-01-11 08:16:44','F32611081644');
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-01-11','F326110816441','2026-01-11','08:16:45','SIN','2465000','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-260111-0003','D','2026-01-11','08:16:45','input','PENJUALAN','F326110816441','1784223000','2465000','1786688000');
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 ('F326110921421','input','1',' MDE2X 10K ','TOKO','PM-E','E2D-YKAE-138-0','CC X WEDDING MATA CM 12 8K ','','2.130','1','100.00','2322000','0','0','15000','2322000','0','10000','0','2332000','FIT','00377546','E2D','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YKAE-138-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.130',berat_jual_asli=berat_jual_asli+'2.130',stock_jual='1',berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='E2D-YKAE-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 ('F326110921421','2026-01-11','2.130','2026-01-11','09:21:42','PLG0026681','2322000','2322000','10000','2332000','2332000','input','2026-01-11 09:21:42','F32611092142');
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-01-11','F326110921421','2026-01-11','09:21:42','FIT','2332000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260111-0004','D','2026-01-11','09:21:42','input','PENJUALAN','F326110921421','1786688000','2332000','1789020000');
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 ('F326111004281','input','1',' MDE1 CM 12','TOKO','PM-E','E1D-YKBB-40-0','CC MODEL DAUN SLEP CM 12 8K ','','0.910','1','100.00','992000','0','0','15000','993000','0','0','0','993000','SIN','00378189','E1D','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YKBB-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='E1D-YKBB-40-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 ('F326111004281','2026-01-11','0.910','2026-01-11','10:04:28','PLG0026682','993000','993000','0','993000','993000','input','2026-01-11 10:04:28','F32611100428');
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-01-11','F326111004281','2026-01-11','10:04:28','SIN','993000','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-260111-0005','D','2026-01-11','10:04:28','input','PENJUALAN','F326111004281','1789020000','993000','1790013000');
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 ('F326111008101','input','1',' TEF2 XX UB','TOKO','PT-F','F2TE-XEAA-71-T','GL XX OVAL MODEL MATA VAR UB D58 17K','','8.200','1','100.00','16482000','0','0','15000','16235000','0','0','0','16235000','FIT','T0057155','F2TE','0','0','-','1','2010000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2TE-XEAA-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'8.200',berat_jual_asli=berat_jual_asli+'8.200',stock_jual='1',berat_akhir=berat_akhir-'8.200',berat_akhir_asli=berat_akhir_asli-'8.200',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='F2TE-XEAA-71-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 ('F326111008101','2026-01-11','8.200','2026-01-11','10:08:11','PLG0026683','16235000','16235000','0','16235000','16235000','input','2026-01-11 10:08:10','F32611100810');
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-01-11','F326111008101','2026-01-11','10:08:11','FIT','16235000','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-260111-0006','D','2026-01-11','10:08:11','input','PENJUALAN','F326111008101','1790013000','16235000','1806248000');
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 ('F326111015121','input','1',' MDE2 CM 20','TOKO','PM-E','E2D-YGXA-31-0','CC MODEL MATA SLEP VAR CM 20 8K ','','1.310','1','100.00','1428000','0','0','15000','1428000','0','0','0','1428000','FIT','00359041','E2D','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YGXA-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.310',berat_jual_asli=berat_jual_asli+'1.310',stock_jual='1',berat_akhir=berat_akhir-'1.310',berat_akhir_asli=berat_akhir_asli-'1.310',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='E2D-YGXA-31-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 ('F326111015121','2026-01-11','1.310','2026-01-11','10:15:13','PLG0026684','1428000','1428000','0','1428000','1428000','input','2026-01-11 10:15:12','F32611101512');
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-01-11','F326111015121','2026-01-11','10:15:13','FIT','1428000','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-260111-0007','D','2026-01-11','10:15:13','input','PENJUALAN','F326111015121','1806248000','1428000','1807676000');
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 ('F326111052451','input','1',' MDA1 XXX U','TOKO','PM-A','A1D-YLAA-23-0','AT XXX ITALY SLEP VAR UB 8K ','','0.950','1','100.00','1035000','0','0','15000','1007000','0','0','0','1007000','SIN','00380605','A1D','0','0','-','1','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YLAA-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='A1D-YLAA-23-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 ('F326111052451','2026-01-11','0.950','2026-01-11','10:52:46','PLG0026685','1007000','1007000','0','1007000','1007000','input','2026-01-11 10:52:45','F32611105245');
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-01-11','F326111052451','2026-01-11','10:52:46','SIN','1007000','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-260111-0008','D','2026-01-11','10:52:46','input','PENJUALAN','F326111052451','1807676000','1007000','1808683000');
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 ('F326111111051','input','1',' MEF3E X KH','TOKO','PM-F','F3E-XKXB-228-0','GL X TIFF PLAT VAR SLEP KH 8K ','','3.300','1','100.00','3663000','0','0','15000','3663000','0','0','0','3663000','FIT','00324824','F3E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-XKXB-228-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.300',berat_jual_asli=berat_jual_asli+'3.300',stock_jual='1',berat_akhir=berat_akhir-'3.300',berat_akhir_asli=berat_akhir_asli-'3.300',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='F3E-XKXB-228-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 ('F326111111051','2026-01-11','3.300','2026-01-11','11:11:06','PLG0026686','3663000','3663000','0','3663000','3663000','input','2026-01-11 11:11:05','F32611111105');
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-01-11','F326111111051','2026-01-11','11:11:06','FIT','3663000','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-260111-0009','D','2026-01-11','11:11:06','input','PENJUALAN','F326111111051','1808683000','3663000','1812346000');
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 ('F326111133131','input','1',' MEH1 X KH ','TOKO','PM-H','H1E-YLBE-114-0','KL X NORI KH 42 8K ','','1.620','1','100.00','1798000','0','0','15000','1798000','0','0','0','1798000','FIT','00383134','H1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLBE-114-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.620',berat_jual_asli=berat_jual_asli+'1.620',stock_jual='1',berat_akhir=berat_akhir-'1.620',berat_akhir_asli=berat_akhir_asli-'1.620',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='H1E-YLBE-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 ('F326111133131','2026-01-11','1.620','2026-01-11','11:33:14','PLG0026687','1798000','1798000','0','1798000','1798000','input','2026-01-11 11:33:13','F32611113313');
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-01-11','F326111133131','2026-01-11','11:33:14','FIT','1798000','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-260111-0010','D','2026-01-11','11:33:14','input','PENJUALAN','F326111133131','1812346000','1798000','1814144000');
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 ('F326111136211','input','1',' MJF4J X KH','TOKO','PM-F','F4J-YJBA-257-0','GL X JEDAR KH 9K ','','0.600','1','100.00','726000','0','0','15000','725000','0','0','0','725000','AAT','00374134','F4J','0','0','-','1','1210000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F4J-YJBA-257-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='F4J-YJBA-257-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 ('F326111136211','2026-01-11','0.600','2026-01-11','11:36:21','PLG0026688','725000','725000','0','725000','725000','input','2026-01-11 11:36:21','F32611113621');
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-01-11','F326111136211','2026-01-11','11:36:21','AAT','725000','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-260111-0011','D','2026-01-11','11:36:21','input','PENJUALAN','F326111136211','1814144000','725000','1814869000');
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 ('F326111202471','input','1',' MDE1 CM 14','TOKO','PM-E','E1D-YLXC-245-0','CC MODEL DAUN SLEP CM 14 8K ','','0.910','1','100.00','992000','0','0','15000','983000','0','0','0','983000','FIT','00379561','E1D','0','0','-','1','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YLXC-245-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='E1D-YLXC-245-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 ('F326111202471','2026-01-11','0.910','2026-01-11','12:02:48','PLG0026689','983000','983000','0','983000','983000','input','2026-01-11 12:02:47','F32611120247');
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-01-11','F326111202471','2026-01-11','12:02:48','FIT','983000','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-260111-0012','D','2026-01-11','12:02:48','input','PENJUALAN','F326111202471','1814869000','983000','1815852000');
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 ('F326111215021','input','1',' MEF1 X YT ','TOKO','PM-F','F1E-XHBB-122-0','GL X OVAL C GELOMBANG YT 54 8K ','','3.280','1','100.00','3641000','0','0','15000','3641000','0','0','0','3641000','SIN','00313273','F1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-XHBB-122-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.280',berat_jual_asli=berat_jual_asli+'3.280',stock_jual='1',berat_akhir=berat_akhir-'3.280',berat_akhir_asli=berat_akhir_asli-'3.280',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='F1E-XHBB-122-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 ('F326111215021','2026-01-11','3.280','2026-01-11','12:15:03','PLG0026690','3641000','3641000','0','3641000','3641000','input','2026-01-11 12:15:02','F32611121502');
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-01-11','F326111215021','2026-01-11','12:15:03','SIN','3641000','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-260111-0013','D','2026-01-11','12:15:03','input','PENJUALAN','F326111215021','1815852000','3641000','1819493000');
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 ('F326111215331','input','1',' MEF1 X YT ','TOKO','PM-F','F1E-ZAXH-201-0','GL XXX OVAL C GELOMBANG YT 52 8K ','','3.130','1','100.00','3474000','0','0','15000','3474000','0','0','0','3474000','SIN','00384287','F1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZAXH-201-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.130',berat_jual_asli=berat_jual_asli+'3.130',stock_jual='1',berat_akhir=berat_akhir-'3.130',berat_akhir_asli=berat_akhir_asli-'3.130',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='F1E-ZAXH-201-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 ('F326111215331','2026-01-11','3.130','2026-01-11','12:15:33','PLG0026691','3474000','3474000','0','3474000','3474000','input','2026-01-11 12:15:33','F32611121533');
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-01-11','F326111215331','2026-01-11','12:15:33','SIN','3474000','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-260111-0014','D','2026-01-11','12:15:33','input','PENJUALAN','F326111215331','1819493000','3474000','1822967000');
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 ('F326111238081','input','1',' MEH1 XXX U','TOKO','PM-H','H1E-YLBI-248-0','KL XXX MILANO UB 44 8K ','','3.000','1','100.00','3330000','0','0','15000','3240000','0','0','0','3240000','SIN','00383400','H1E','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLBI-248-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='H1E-YLBI-248-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 ('F326111238081','2026-01-11','3.000','2026-01-11','12:38:09','PLG0026692','3240000','3240000','0','3240000','3240000','input','2026-01-11 12:38:08','F32611123808');
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-01-11','F326111238081','2026-01-11','12:38:09','SIN','3240000','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-260111-0015','D','2026-01-11','12:38:09','input','PENJUALAN','F326111238081','1822967000','3240000','1826207000');
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 ('F326111238511','input','1',' TEF3 X HW ','TOKO','PT-F','F3TE-WEXD-60-T','GL X HARLEY POLOS HW ','','5.020','1','100.00','10090000','0','0','15000','10090000','0','0','0','10090000','SIN','T0044032','F3TE','0','0','-','0','2010000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-WEXD-60-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.020',berat_jual_asli=berat_jual_asli+'5.020',stock_jual='1',berat_akhir=berat_akhir-'5.020',berat_akhir_asli=berat_akhir_asli-'5.020',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='F3TE-WEXD-60-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 ('F326111238511','2026-01-11','5.020','2026-01-11','12:38:51','PLG0026693','10090000','10090000','0','10090000','10090000','input','2026-01-11 12:38:51','F32611123851');
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-01-11','F326111238511','2026-01-11','12:38:51','SIN','10090000','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-260111-0016','D','2026-01-11','12:38:51','input','PENJUALAN','F326111238511','1826207000','10090000','1836297000');
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 ('F326111250231','kasir','1',' TED2 LG S ','TOKO','PT-D','D2TE-YGBD-76-T','LT MODEL HURUF MATA LG S 17K ','','0.700','1','100.00','1407000','0','0','15000','1408000','0','0','0','1408000','FIT','T0071504','D2TE','0','0','-','0','2010000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2TE-YGBD-76-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='D2TE-YGBD-76-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326111250231','2026-01-11','0.700','2026-01-11','12:50:24','PLG0026694','1408000','1408000','0','1408000','1408000','kasir','2026-01-11 12:50:23','F32611125023');
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-01-11','F326111250231','2026-01-11','12:50:24','FIT','1408000','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-260111-0017','D','2026-01-11','12:50:24','kasir','PENJUALAN','F326111250231','1836297000','1408000','1837705000');
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 ('F326110106141','kasir','1',' MEF1 PM 42','TOKO','PM-F','F1E-YLAA-125-0','GL BANGKOK ANAK KACA PM 42 8K ','','2.130','1','100.00','2364000','0','0','15000','2365000','0','0','0','2365000','FIT','00380707','F1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLAA-125-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.130',berat_jual_asli=berat_jual_asli+'2.130',stock_jual='1',berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='F1E-YLAA-125-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 ('F326110106141','2026-01-11','2.130','2026-01-11','13:06:14','PLG0026695','2365000','2365000','0','2365000','2365000','kasir','2026-01-11 13:06:14','F32611010614');
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-01-11','F326110106141','2026-01-11','13:06:14','FIT','2365000','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-260111-0018','D','2026-01-11','13:06:14','kasir','PENJUALAN','F326110106141','1837705000','2365000','1840070000');
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 ('F326110106491','kasir','1',' MEH1 UB 34','TOKO','PM-H','H1E-YLXE-130-0','KL GUCCI ANAK UB 34 8K ','','2.020','1','100.00','2242000','0','0','15000','2243000','0','0','0','2243000','FIT','00379800','H1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLXE-130-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='H1E-YLXE-130-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 ('F326110106491','2026-01-11','2.020','2026-01-11','13:06:49','PLG0026696','2243000','2243000','0','2243000','2243000','kasir','2026-01-11 13:06:49','F32611010649');
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-01-11','F326110106491','2026-01-11','13:06:49','FIT','2243000','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-260111-0019','D','2026-01-11','13:06:49','kasir','PENJUALAN','F326110106491','1840070000','2243000','1842313000');
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 ('F326110111311','kasir','1',' MDE2 5K LG','TOKO','PM-E','E2D-YDAX-295-0','CC OSROT ANAK EROPA MATA LG 8K ','','1.000','1','100.00','1090000','0','0','15000','1090000','0','5000','0','1095000','FIT','00348781','E2D','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YDAX-295-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='E2D-YDAX-295-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 ('F326110111311','2026-01-11','1.000','2026-01-11','13:11:32','PLG0026697','1090000','1090000','5000','1095000','1095000','kasir','2026-01-11 13:11:31','F32611011131');
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-01-11','F326110111311','2026-01-11','13:11:32','FIT','1095000','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-260111-0020','D','2026-01-11','13:11:32','kasir','PENJUALAN','F326110111311','1842313000','1095000','1843408000');
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 ('F326110127231','kasir','1',' MEF1 X TD ','TOKO','PM-F','F1E-YLBX-218-0','GL X BANGKOK C SLEP TD 54 8K ','','3.020','1','100.00','3352000','0','0','15000','3353000','0','0','0','3353000','FIT','00382098','F1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLBX-218-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.020',berat_jual_asli=berat_jual_asli+'3.020',stock_jual='1',berat_akhir=berat_akhir-'3.020',berat_akhir_asli=berat_akhir_asli-'3.020',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='F1E-YLBX-218-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 ('F326110127231','2026-01-11','3.020','2026-01-11','13:27:24','PLG0026698','3353000','3353000','0','3353000','3353000','kasir','2026-01-11 13:27:23','F32611012723');
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-01-11','F326110127231','2026-01-11','13:27:24','FIT','3353000','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-260111-0021','D','2026-01-11','13:27:24','kasir','PENJUALAN','F326110127231','1843408000','3353000','1846761000');
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 ('F326110128071','kasir','1',' TED1 X BM ','TOKO','PT-D','D1TE-UDXE-66-T','LT X HURUF SLEP BM N ','','1.420','1','100.00','2854000','0','0','15000','2855000','0','0','0','2855000','FIT','T0003180','D1TE','0','0','-','0','2010000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1TE-UDXE-66-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.420',berat_jual_asli=berat_jual_asli+'1.420',stock_jual='1',berat_akhir=berat_akhir-'1.420',berat_akhir_asli=berat_akhir_asli-'1.420',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='D1TE-UDXE-66-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110128071','2026-01-11','1.420','2026-01-11','13:28:08','PLG0026699','2855000','2855000','0','2855000','2855000','kasir','2026-01-11 13:28:07','F32611012807');
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-01-11','F326110128071','2026-01-11','13:28:08','FIT','2855000','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-260111-0022','D','2026-01-11','13:28:08','kasir','PENJUALAN','F326110128071','1846761000','2855000','1849616000');
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-00017916','X-00017916','GW TOGE MODEL MATA VAR LG 8K','GR','---','B1F','BELI','BELI001','380000','2026-01-11','0.480','1','kasir','2026-01-11 13:34:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00017916','X-00017916');
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-260111-0001','F325110225352','AAT','1','BELI','BELI001','B1F', 'X-00017916', 'GW TOGE MODEL MATA VAR LG 8K','0.480','0.480','100.00','410000','380000','791667','1130000','1','380000','380000','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-01-11' 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-260111-0001','2026-01-11','2026-01-11','13:34:27','AAT','---','0.480','380000','380000','380000','380000','380000','kasir','2026-01-11 13:34:28','FB-260111-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260111-0001','MAHREEN','JERUK BANDAR PACITAN','','','','kasir','2026-01-11 13:34:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-11' 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-260111-0023','K','2026-01-11','13:34:27','kasir','PEMBELIAN UMUM','FB-260111-0001','1849616000','380000','1849236000');
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-00017917','X-00017917','GL XX CAPELLA CD VAR HW 8K','GR','---','F3E','BELI','BELI001','1600000','2026-01-11','1.600','1','kasir','2026-01-11 13:35:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017917','X-00017917');
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-260111-0002','F325250750401','FIT','1','BELI','BELI001','F3E', 'X-00017917', 'GL XX CAPELLA CD VAR HW 8K','1.600','1.600','100.00','1688000','1600000','1000000','1120000','1','1600000','1600000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.600',berat_beli_asli=berat_beli_asli+'1.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.600',berat_akhir_asli=berat_akhir_asli+'1.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-11' 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-260111-0002','2026-01-11','2026-01-11','13:35:06','FIT','---','1.600','1600000','1600000','1600000','1600000','1600000','kasir','2026-01-11 13:35:06','FB-260111-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260111-0002','ANIS','BULUKERTO WONOGIRI','','','','kasir','2026-01-11 13:35:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-11' 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-260111-0024','K','2026-01-11','13:35:06','kasir','PEMBELIAN UMUM','FB-260111-0002','1849236000','1600000','1847636000');
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-00017918','X-00017918','GL KREPYAK VERONA SLEP PM 8K','GR','---','F3E','BELI','BELI001','7150000','2026-01-11','6.930','1','kasir','2026-01-11 13:35:27');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017918','X-00017918');
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-260111-0003','F326051017251','FIT','1','BELI','BELI001','F3E', 'X-00017918', 'GL KREPYAK VERONA SLEP PM 8K','6.930','6.930','100.00','7450000','7150000','1031746','1120000','1','7150000','7150000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'6.930',berat_beli_asli=berat_beli_asli+'6.930',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'6.930',berat_akhir_asli=berat_akhir_asli+'6.930',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-11' 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-260111-0003','2026-01-11','2026-01-11','13:35:26','FIT','---','6.930','7150000','7150000','7150000','7150000','7150000','kasir','2026-01-11 13:35:27','FB-260111-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260111-0003','WIWIN','PURWANTORO','','','085701487262','kasir','2026-01-11 13:35:27');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-11' 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-260111-0025','K','2026-01-11','13:35:26','kasir','PEMBELIAN UMUM','FB-260111-0003','1847636000','7150000','1840486000');
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-00017919','X-00017919','GL LEMES 8K','GR','---','F3E','BELI','BELI001','2295000','2026-01-11','2.950','1','kasir','2026-01-11 13:39:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017919','X-00017919');
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-260111-0004','F323040835001','SIN','1','BELI','BELI001','F3E', 'X-00017919', 'GL LEMES 8K','2.950','2.950','100.00','1313000','2295000','777966','1120000','1','2295000','2295000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.950',berat_beli_asli=berat_beli_asli+'2.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.950',berat_akhir_asli=berat_akhir_asli+'2.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-11' 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-260111-0004','2026-01-11','2026-01-11','13:39:28','SIN','---','2.950','2295000','2295000','2295000','2295000','2295000','kasir','2026-01-11 13:39:29','FB-260111-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260111-0004','SATINI','JATEN NGROTO','','','','kasir','2026-01-11 13:39:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-11' 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-260111-0026','K','2026-01-11','13:39:28','kasir','PEMBELIAN UMUM','FB-260111-0004','1840486000','2295000','1838191000');
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-00017920','X-00017920','AT X ITALY SLEP UB 8K','GR','---','A1F','BELI','BELI001','1077000','2026-01-11','1.160','1','kasir','2026-01-11 13:39:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00017920','X-00017920');
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-260111-0005','F325081207381','SIN','1','BELI','BELI001','A1F', 'X-00017920', 'AT X ITALY SLEP UB 8K','1.180','1.160','100.00','1190000','1077000','928448','1130000','1','1077000','1077000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.160',berat_beli_asli=berat_beli_asli+'1.160',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.160',berat_akhir_asli=berat_akhir_asli+'1.160',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' 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-260111-0005','2026-01-11','2026-01-11','13:39:49','SIN','---','1.160','1077000','1077000','1077000','1077000','1077000','kasir','2026-01-11 13:39:50','FB-260111-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260111-0005','NDARI','SAMPUNG','','','','kasir','2026-01-11 13:39:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-11' 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-260111-0027','K','2026-01-11','13:39:49','kasir','PEMBELIAN UMUM','FB-260111-0005','1838191000','1077000','1837114000');
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-00017921','X-00017921','CC X MODEL MATA CM 12 8K','GR','---','E2D','BELI','BELI001','612000','2026-01-11','0.800','1','kasir','2026-01-11 13:40:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017921','X-00017921');
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-260111-0006','F325121223012','FIT','1','BELI','BELI001','E2D', 'X-00017921', 'CC X MODEL MATA CM 12 8K','0.800','0.800','100.00','653000','612000','765000','1100000','1','612000','612000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.800',berat_beli_asli=berat_beli_asli+'0.800',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.800',berat_akhir_asli=berat_akhir_asli+'0.800',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-11' 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-260111-0006','2026-01-11','2026-01-11','13:40:09','FIT','---','0.800','612000','612000','612000','612000','612000','kasir','2026-01-11 13:40:10','FB-260111-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260111-0006','TIA','JETAK','','','','kasir','2026-01-11 13:40:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-11' 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-260111-0028','K','2026-01-11','13:40:09','kasir','PEMBELIAN UMUM','FB-260111-0006','1837114000','612000','1836502000');
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-00017922','X-00017922','CC BONEKA ANAK MT CAT LG','GR','---','E2F','BELI','BELI001','370000','2026-01-11','0.550','1','kasir','2026-01-11 13:40:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2F','X-00017922','X-00017922');
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-260111-0007','F322121212252','FIT','1','BELI','BELI001','E2F', 'X-00017922', 'CC BONEKA ANAK MT CAT LG','0.550','0.550','100.00','242000','370000','672727','1130000','1','370000','370000','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-01-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2F' 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-260111-0007','2026-01-11','2026-01-11','13:40:46','FIT','---','0.550','370000','370000','370000','370000','370000','kasir','2026-01-11 13:40:47','FB-260111-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260111-0007','IKA','JATEN KISMANTORO','','','','kasir','2026-01-11 13:40:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-11' 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-260111-0029','K','2026-01-11','13:40:46','kasir','PEMBELIAN UMUM','FB-260111-0007','1836502000','370000','1836132000');
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-00017923','X-00017923','CC BUNGA CLOVER CAT VAR CM 12 8K','GR','---','E1E','BELI','BELI001','370000','2026-01-11','0.510','1','kasir','2026-01-11 13:42:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00017923','X-00017923');
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-260111-0008','F324030253301','FIT','1','BELI','BELI001','E1E', 'X-00017923', 'CC BUNGA CLOVER CAT VAR CM 12 8K','0.510','0.510','100.00','310000','370000','725490','1120000','1','370000','370000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-260111-0008','2026-01-11','2026-01-11','13:42:41','FIT','---','0.510','370000','370000','370000','370000','370000','kasir','2026-01-11 13:42:41','FB-260111-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260111-0008','IKA','JETAK','','','','kasir','2026-01-11 13:42:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-11' 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-260111-0030','K','2026-01-11','13:42:41','kasir','PEMBELIAN UMUM','FB-260111-0008','1836132000','370000','1835762000');
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-00017924','X-00017924','CC MODEL SLEP HW 15 8K','GR','---','E1D','BELI','BELI001','747000','2026-01-11','0.800','1','kasir','2026-01-11 13:42:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00017924','X-00017924');
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-260111-0009','F325271040241','AAT','1','BELI','BELI001','E1D', 'X-00017924', 'CC MODEL SLEP HW 15 8K','0.800','0.800','100.00','795000','747000','933750','1100000','1','747000','747000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.800',berat_beli_asli=berat_beli_asli+'0.800',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.800',berat_akhir_asli=berat_akhir_asli+'0.800',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-11' 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-260111-0009','2026-01-11','2026-01-11','13:42:56','AAT','---','0.800','747000','747000','747000','747000','747000','kasir','2026-01-11 13:42:57','FB-260111-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260111-0009','SUSANTI','TENGGAR BULUKERTO','','','','kasir','2026-01-11 13:42:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-11' 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-260111-0031','K','2026-01-11','13:42:56','kasir','PEMBELIAN UMUM','FB-260111-0009','1835762000','747000','1835015000');
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-00017925','X-00017925','CC WG WEDDING POLOS CM 18 8K','GR','---','PEG','BELI','BELI001','1557000','2026-01-11','1.980','1','kasir','2026-01-11 13:43:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-PEG';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-PEG','X-00017925','X-00017925');
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-260111-0010','F324080846203','AAT','1','BELI','BELI001','PEG', 'X-00017925', 'CC WG WEDDING POLOS CM 18 8K','1.980','1.980','100.00','1330000','1557000','786364','1150000','1','1557000','1557000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.980',berat_beli_asli=berat_beli_asli+'1.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.980',berat_akhir_asli=berat_akhir_asli+'1.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-01-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='PEG' 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-260111-0010','2026-01-11','2026-01-11','13:43:21','AAT','---','1.980','1557000','1557000','1557000','1557000','1557000','kasir','2026-01-11 13:43:21','FB-260111-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260111-0010','WAHYU SAFITRI','GIRIHARJO PUHPELEM','','','','kasir','2026-01-11 13:43:21');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-11' 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-260111-0032','K','2026-01-11','13:43:21','kasir','PEMBELIAN UMUM','FB-260111-0010','1835015000','1557000','1833458000');
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 ('F326110230211','input','1',' MEF2 X UB ','TOKO','PM-F','F2E-YKAE-101-0','GL X PIPA MATA UB 54 8K ','','2.960','1','100.00','3286000','0','0','15000','3285000','0','0','0','3285000','FIT','00377509','F2E','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-01-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YKAE-101-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.960',berat_jual_asli=berat_jual_asli+'2.960',stock_jual='1',berat_akhir=berat_akhir-'2.960',berat_akhir_asli=berat_akhir_asli-'2.960',stock_akhir='0' WHERE tanggal='2026-01-11' AND kode_barang='F2E-YKAE-101-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 ('F326110230211','2026-01-11','2.960','2026-01-11','14:30:22','PLG0026700','3285000','3285000','0','3285000','3285000','input','2026-01-11 14:30:21','F32611023021');
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-01-11','F326110230211','2026-01-11','14:30:22','FIT','3285000','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-260111-0033','D','2026-01-11','14:30:22','input','PENJUALAN','F326110230211','1833458000','3285000','1836743000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260111-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260111-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260111-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260111-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260111-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260111-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260111-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260111-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260111-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260111-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260111-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260111-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260111-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260111-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260111-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260111-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260111-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260111-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260111-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260111-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110106141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110106141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110106141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110106491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110106491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110106491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110111311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110111311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110111311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110127231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110127231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110127231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110128071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110128071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110128071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110230211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110230211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110230211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110810491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110810491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110810491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110816441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110816441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110816441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110921421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110921421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110921421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111004281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111004281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111004281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111008101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111008101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111008101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111015121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111015121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111015121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111052451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111052451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111052451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111111051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111111051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111111051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111133131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111133131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111133131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111136211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111136211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111136211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111202471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111202471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111202471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111215021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111215021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111215021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111215331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111215331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111215331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111238081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111238081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111238081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111238511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111238511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111238511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111250231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111250231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111250231';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-12','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-12';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-11';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-11';
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-01-11' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-11';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-11';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-11';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-11';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202600 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
UPDATE tt_barang_saldo SET tanggal= '2026-01-12' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-11' 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-260112-0001','D','2026-01-12','15:13:52','SYSTEM','SALDO AWAL','SALDO AWAL','0','1836743000','1836743000');
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-260112-0001','D','2026-01-12','15:13:52','BCA','SALDO AWAL','SALDO AWAL','0','705914000','705914000');
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-260112-0001','D','2026-01-12','15:13:52','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-260112-0001','D','2026-01-12','15:13:52','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-01-12';