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 ('F326110841281','input','1',' MEF3 LT ','TOKO','PM-F','F3E-YLCX-337-0','GL MODEL DAUN VAR LT 8K ','','2.660','1','100.00','3205000','0','0','15000','3205000','0','0','0','3205000','FIT','00383742','F3E','0','0','-','0','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLCX-337-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.660',berat_jual_asli=berat_jual_asli+'2.660',stock_jual='1',berat_akhir=berat_akhir-'2.660',berat_akhir_asli=berat_akhir_asli-'2.660',stock_akhir='0' WHERE tanggal='2026-03-11' AND kode_barang='F3E-YLCX-337-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 ('F326110841281','2026-03-11','2.660','2026-03-11','08:41:29','PLG0027566','3205000','3205000','0','3205000','3205000','input','2026-03-11 08:41:28','F32611084128');
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-03-11','F326110841281','2026-03-11','08:41:29','FIT','3205000','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-260311-0002','D','2026-03-11','08:41:29','input','PENJUALAN','F326110841281','2895278000','3205000','2898483000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3205000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110841281' 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 ('F326110841282','input',' 1',' MEE1 X UB ','TOKO','PM-E','E1E-YLAG-204-0','CC X MODEL DAUN SLEP UB 12 8K ','','0.660','1','100.00','795000','0','0','15000','795000','0','0','0','795000','FIT','00381558','E1E','0','0','-','0','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YLAG-204-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-03-11' AND kode_barang='E1E-YLAG-204-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 ('F326110841282','2026-03-11','0.660','2026-03-11','08:41:29','PLG0027567','795000','795000','0','795000','795000','input','2026-03-11 08:41:28','F32611084128');
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-03-11','F326110841282','2026-03-11','08:41:29','FIT','795000','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-260311-0003','D','2026-03-11','08:41:29','input','PENJUALAN','F326110841282','2898483000','795000','2899278000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='795000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110841282' 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 ('F326111020161','input','1',' MEE1 X CM ','TOKO','PM-E','E1E-ZCXI-76-0','CC X MODEL DAUN SLEP CM 14 8K ','','0.700','1','100.00','843000','0','0','15000','845000','0','0','0','845000','FIT','00392891','E1E','0','0','-','0','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCXI-76-0' 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-03-11' AND kode_barang='E1E-ZCXI-76-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 ('F326111020161','2026-03-11','0.700','2026-03-11','10:20:16','PLG0027568','845000','845000','0','845000','845000','input','2026-03-11 10:20:16','F32611102016');
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-03-11','F326111020161','2026-03-11','10:20:16','FIT','845000','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-260311-0004','D','2026-03-11','10:20:16','input','PENJUALAN','F326111020161','2899278000','845000','2900123000');
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-00018426','X-00018426','GW X ITALY ARESO SLEP UB 8K','GR','---','B1F','BELI','BELI001','350000','2026-03-11','0.400','1','kasir','2026-03-11 11:12:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00018426','X-00018426');
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-260311-0001','F325020956141','FIT','1','BELI','BELI001','B1F', 'X-00018426', 'GW X ITALY ARESO SLEP UB 8K','0.770','0.400','100.00','778000','350000','875000','1225000','1','350000','350000','RUSAK');
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-03-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-260311-0001','2026-03-11','2026-03-11','11:12:02','FIT','---','0.400','350000','350000','350000','350000','350000','kasir','2026-03-11 11:12:03','FB-260311-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260311-0001','ARI KRISTIYANTI','BANGSRI PURWANTORO','','','0882006667469','kasir','2026-03-11 11:12:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-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-260311-0005','K','2026-03-11','11:12:02','kasir','PEMBELIAN UMUM','FB-260311-0001','2900123000','350000','2899773000');
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-00018427','X-00018427','CC COR T 8K','GR','---','E1D','BELI','BELI001','860000','2026-03-11','1.080','1','kasir','2026-03-11 11:13:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00018427','X-00018427');
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-260311-0002','00338224','FIT','1','BELI','BELI001','E1D', 'X-00018427', 'CC COR T 8K','1.080','1.080','100.00','891000','860000','796296','1195000','1','860000','860000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.080',berat_beli_asli=berat_beli_asli+'1.080',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.080',berat_akhir_asli=berat_akhir_asli+'1.080',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-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-260311-0002','2026-03-11','2026-03-11','11:13:48','FIT','---','1.080','860000','860000','860000','860000','860000','kasir','2026-03-11 11:13:48','FB-260311-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260311-0002','ADITYA','PURWANTORO','','','','kasir','2026-03-11 11:13:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-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-260311-0006','K','2026-03-11','11:13:48','kasir','PEMBELIAN UMUM','FB-260311-0002','2899773000','860000','2898913000');
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-00018428','X-00018428','CC COR M 8K','GR','---','E2D','BELI','BELI001','1270000','2026-03-11','1.660','1','kasir','2026-03-11 11:13:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00018428','X-00018428');
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-260311-0003','00364237','FIT','2','BELI','BELI001','E2D', 'X-00018428', 'CC COR M 8K','1.660','1.660','100.00','1369000','1270000','765060','1195000','1','1270000','1270000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.660',berat_beli_asli=berat_beli_asli+'1.660',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.660',berat_akhir_asli=berat_akhir_asli+'1.660',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-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-260311-0003','2026-03-11','2026-03-11','11:13:48','FIT','---','1.660','1270000','1270000','1270000','1270000','1270000','kasir','2026-03-11 11:13:48','FB-260311-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260311-0003','ADITYA','PURWANTORO','','','','kasir','2026-03-11 11:13:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-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-260311-0007','K','2026-03-11','11:13:48','kasir','PEMBELIAN UMUM','FB-260311-0003','2898913000','1270000','2897643000');
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-00018429','X-00018429','GL COR T 8K','GR','---','F1E','BELI','BELI001','2135000','2026-03-11','2.800','1','kasir','2026-03-11 11:15:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00018429','X-00018429');
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-260311-0004','F323061035461','AAT','1','BELI','BELI001','F1E', 'X-00018429', 'GL COR T 8K','2.820','2.800','100.00','1315000','2135000','762500','1215000','1','2135000','2135000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.800',berat_beli_asli=berat_beli_asli+'2.800',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.800',berat_akhir_asli=berat_akhir_asli+'2.800',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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-260311-0004','2026-03-11','2026-03-11','11:15:10','AAT','---','2.800','2135000','2135000','2135000','2135000','2135000','kasir','2026-03-11 11:15:10','FB-260311-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260311-0004','DILA','KEPYAR','','','','kasir','2026-03-11 11:15:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-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-260311-0008','K','2026-03-11','11:15:10','kasir','PEMBELIAN UMUM','FB-260311-0004','2897643000','2135000','2895508000');
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-00018430','X-00018430','CC X MODEL DAUN MATA CM 11','GR','---','E2TE','BELI','BELI001','1715000','2026-03-11','1.260','1','kasir','2026-03-11 11:15:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00018430','X-00018430');
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-260311-0005','F322081229241','FIT','1','BELI','BELI001','E2TE', 'X-00018430', 'CC X MODEL DAUN MATA CM 11','1.260','1.260','100.00','950000','1715000','1361111','2190000','1','1715000','1715000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.260',berat_beli_asli=berat_beli_asli+'1.260',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.260',berat_akhir_asli=berat_akhir_asli+'1.260',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-260311-0005','2026-03-11','2026-03-11','11:15:43','FIT','---','1.260','1715000','1715000','1715000','1715000','1715000','kasir','2026-03-11 11:15:43','FB-260311-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260311-0005','ZAHIR','BULUKERTO','','','','kasir','2026-03-11 11:15:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-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-260311-0009','K','2026-03-11','11:15:43','kasir','PEMBELIAN UMUM','FB-260311-0005','2895508000','1715000','2893793000');
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-00018431','X-00018431','LT COR M 8K','GR','---','D2F','BELI','BELI001','295000','2026-03-11','0.470','1','kasir','2026-03-11 11:17:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2F','X-00018431','X-00018431');
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-260311-0006','F321190232482','FIT','1','BELI','BELI001','D2F', 'X-00018431', 'LT COR M 8K','0.470','0.470','100.00','200000','295000','627660','1225000','1','295000','295000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.470',berat_beli_asli=berat_beli_asli+'0.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.470',berat_akhir_asli=berat_akhir_asli+'0.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2F' 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-260311-0006','2026-03-11','2026-03-11','11:17:02','FIT','---','0.470','295000','295000','295000','295000','295000','kasir','2026-03-11 11:17:02','FB-260311-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260311-0006','ZAHIR','BULUKERTO','','','','kasir','2026-03-11 11:17:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-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-260311-0010','K','2026-03-11','11:17:02','kasir','PEMBELIAN UMUM','FB-260311-0006','2893793000','295000','2893498000');
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-00018432','X-00018432','CC WEDDING MATA CM 16 8K','GR','---','E2E','BELI','BELI001','1650000','2026-03-11','2.230','1','kasir','2026-03-11 11:17:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018432','X-00018432');
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-260311-0007','F324111255151','FIT','1','BELI','BELI001','E2E', 'X-00018432', 'CC WEDDING MATA CM 16 8K','2.250','2.230','100.00','1320000','1650000','739910','1215000','1','1650000','1650000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.230',berat_beli_asli=berat_beli_asli+'2.230',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.230',berat_akhir_asli=berat_akhir_asli+'2.230',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-260311-0007','2026-03-11','2026-03-11','11:17:42','FIT','---','2.230','1650000','1650000','1650000','1650000','1650000','kasir','2026-03-11 11:17:43','FB-260311-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260311-0007','SUKIR','GESING KISMANTORO','','','','kasir','2026-03-11 11:17:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-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-260311-0011','K','2026-03-11','11:17:42','kasir','PEMBELIAN UMUM','FB-260311-0007','2893498000','1650000','2891848000');
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 ('F326111133241','kasir','1',' MDA1 UB ','TOKO','PM-A','A1D-YKBI-178-0','AT MODEL ITALY PANJANG VAR UB 8K ','','0.950','1','100.00','1126000','0','0','15000','1126000','0','0','0','1126000','LIS','00379144','A1D','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YKBI-178-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-03-11' AND kode_barang='A1D-YKBI-178-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 ('F326111133241','2026-03-11','0.950','2026-03-11','11:33:25','PLG0027569','1126000','1126000','0','1126000','1126000','kasir','2026-03-11 11:33:24','F32611113324');
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-03-11','F326111133241','2026-03-11','11:33:25','LIS','1126000','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-260311-0012','D','2026-03-11','11:33:25','kasir','PENJUALAN','F326111133241','2891848000','1126000','2892974000');
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 ('F326111158281','kasir','1',' MJH2 X UB ','TOKO','PM-H','H2J-XIAH-37-0','KL X MILANO UB 44 9K ','','4.910','1','100.00','6408000','0','0','15000','6408000','0','0','0','6408000','SIN','00318003','H2J','0','0','-','0','1315000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-XIAH-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.910',berat_jual_asli=berat_jual_asli+'4.910',stock_jual='1',berat_akhir=berat_akhir-'4.910',berat_akhir_asli=berat_akhir_asli-'4.910',stock_akhir='0' WHERE tanggal='2026-03-11' AND kode_barang='H2J-XIAH-37-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 ('F326111158281','2026-03-11','4.910','2026-03-11','11:58:29','PLG0027570','6408000','6408000','0','6408000','6408000','kasir','2026-03-11 11:58:28','F32611115828');
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-03-11','F326111158281','2026-03-11','11:58:29','SIN','6408000','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-260311-0013','D','2026-03-11','11:58:29','kasir','PENJUALAN','F326111158281','2892974000','6408000','2899382000');
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 ('F326110107021','kasir','1',' MDB1 X CM ','TOKO','PM-B','B1D-YLBI-60-0','GW X PANJANG DAUN SLEP CM 8K ','','0.800','1','100.00','948000','0','0','15000','948000','0','0','0','948000','LIS','00383212','B1D','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-YLBI-60-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2026-03-11' AND kode_barang='B1D-YLBI-60-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110107021','2026-03-11','0.800','2026-03-11','13:07:03','PLG0027571','948000','948000','0','948000','948000','kasir','2026-03-11 13:07:02','F32611010702');
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-03-11','F326110107021','2026-03-11','13:07:03','LIS','948000','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-260311-0014','D','2026-03-11','13:07:03','kasir','PENJUALAN','F326110107021','2899382000','948000','2900330000');
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 ('F326110127051','kasir','1',' MEH1 UB 40','TOKO','PM-H','H1E-ZBXC-1-0','KL TIFF SLEP VAR UB 40 8K ','','1.090','1','100.00','1313000','0','0','15000','1313000','0','0','0','1313000','LIS','00387680','H1E','0','0','-','0','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBXC-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.090',berat_jual_asli=berat_jual_asli+'1.090',stock_jual='1',berat_akhir=berat_akhir-'1.090',berat_akhir_asli=berat_akhir_asli-'1.090',stock_akhir='0' WHERE tanggal='2026-03-11' AND kode_barang='H1E-ZBXC-1-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 ('F326110127051','2026-03-11','1.090','2026-03-11','13:27:05','PLG0027572','1313000','1313000','0','1313000','1313000','kasir','2026-03-11 13:27:05','F32611012705');
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-03-11','F326110127051','2026-03-11','13:27:05','LIS','1313000','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-260311-0015','D','2026-03-11','13:27:05','kasir','PENJUALAN','F326110127051','2900330000','1313000','2901643000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1313000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110127051' 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 ('F326110127052','kasir',' 1',' MDE2 X CM ','TOKO','PM-E','E2D-ZCXI-56-0','CC X SOLITAIRE MATA CM 12 8K ','','0.830','1','100.00','984000','0','0','15000','985000','0','10000','0','995000','LIS','00392871','E2D','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCXI-56-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2026-03-11' AND kode_barang='E2D-ZCXI-56-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 ('F326110127052','2026-03-11','0.830','2026-03-11','13:27:05','PLG0027573','985000','985000','10000','995000','995000','kasir','2026-03-11 13:27:05','F32611012705');
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-03-11','F326110127052','2026-03-11','13:27:05','LIS','995000','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-260311-0016','D','2026-03-11','13:27:05','kasir','PENJUALAN','F326110127052','2901643000','995000','2902638000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='995000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110127052' 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-00018433','X-00018433','GL FANCY SLEP LT 8K','GR','---','F3E','BELI','BELI001','1012000','2026-03-11','1.050','1','kasir','2026-03-11 14:02:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00018433','X-00018433');
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-260311-0008','F325141230211','AAT','1','BELI','BELI001','F3E', 'X-00018433', 'GL FANCY SLEP LT 8K','1.050','1.050','100.00','1100000','1012000','963810','1215000','1','1012000','1012000','CUCI');
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-03-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-260311-0008','2026-03-11','2026-03-11','14:02:28','AAT','---','1.050','1012000','1012000','1012000','1012000','1012000','kasir','2026-03-11 14:02:29','FB-260311-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260311-0008','TIANA','BADEGAN','','','','kasir','2026-03-11 14:02:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-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-260311-0017','K','2026-03-11','14:02:28','kasir','PEMBELIAN UMUM','FB-260311-0008','2902638000','1012000','2901626000');
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 ('F326110210361','kasir','1',' MDE2 CM 14','TOKO','PM-E','E2D-ZCAX-525-0','CC WEDDING MATA CM 14 8K ','','1.030','1','100.00','1231000','0','0','15000','1220000','0','0','0','1220000','SIN','00393502','E2D','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAX-525-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-03-11' AND kode_barang='E2D-ZCAX-525-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 ('F326110210361','2026-03-11','1.030','2026-03-11','14:10:37','PLG0027574','1220000','1220000','0','1220000','1220000','kasir','2026-03-11 14:10:36','F32611021036');
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-03-11','F326110210361','2026-03-11','14:10:37','SIN','1220000','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-260311-0018','D','2026-03-11','14:10:37','kasir','PENJUALAN','F326110210361','2901626000','1220000','2902846000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1220000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110210361' 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 ('F326110210362','kasir',' 1',' MDE1 X CM ','TOKO','PM-E','E1D-ZCXB-212-0','CC X WEDDING POLOS CM 21 8K ','','0.950','1','100.00','1126000','0','0','15000','1125000','0','0','0','1125000','SIN','00391635','E1D','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCXB-212-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-03-11' AND kode_barang='E1D-ZCXB-212-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 ('F326110210362','2026-03-11','0.950','2026-03-11','14:10:37','PLG0027575','1125000','1125000','0','1125000','1125000','kasir','2026-03-11 14:10:36','F32611021036');
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-03-11','F326110210362','2026-03-11','14:10:37','SIN','1125000','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-260311-0019','D','2026-03-11','14:10:37','kasir','PENJUALAN','F326110210362','2902846000','1125000','2903971000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1125000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110210362' 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 ('F326110214001','kasir','1',' MDE2 X UB ','TOKO','PM-E','E2D-XLAG-34-0','CC X MODEL MATA UB 18 8K ','','1.350','1','100.00','1600000','0','0','15000','1600000','0','0','0','1600000','AAT','00330200','E2D','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-XLAG-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2026-03-11' AND kode_barang='E2D-XLAG-34-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 ('F326110214001','2026-03-11','1.350','2026-03-11','14:14:01','PLG0027576','1600000','1600000','0','1600000','1600000','kasir','2026-03-11 14:14:00','F32611021400');
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-03-11','F326110214001','2026-03-11','14:14:01','AAT','1600000','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-260311-0020','D','2026-03-11','14:14:01','kasir','PENJUALAN','F326110214001','2903971000','1600000','2905571000');
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 ('F326110222541','kasir','1',' MEE2 CM 12','TOKO','PM-E','E2E-ZCAX-169-0','CC MODEL MATA VAR CM 12 8K','','0.680','1','100.00','826000','0','0','15000','820000','0','0','0','820000','FIT','00393141','E2E','0','0','-','1','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCAX-169-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-03-11' AND kode_barang='E2E-ZCAX-169-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 ('F326110222541','2026-03-11','0.680','2026-03-11','14:22:55','PLG0027577','820000','820000','0','820000','820000','kasir','2026-03-11 14:22:54','F32611022254');
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-03-11','F326110222541','2026-03-11','14:22:55','FIT','820000','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-260311-0021','D','2026-03-11','14:22:55','kasir','PENJUALAN','F326110222541','2905571000','820000','2906391000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='820000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110222541' 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 ('F326110222542','kasir',' 1',' MEE2 5K CM','TOKO','PM-E','E2E-ZCAX-168-0','CC MODEL MATA VAR CM 12 8K ','','0.810','1','100.00','984000','0','0','15000','975000','0','5000','0','980000','FIT','00393140','E2E','0','0','-','1','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCAX-168-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2026-03-11' AND kode_barang='E2E-ZCAX-168-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 ('F326110222542','2026-03-11','0.810','2026-03-11','14:22:55','PLG0027578','975000','975000','5000','980000','980000','kasir','2026-03-11 14:22:54','F32611022254');
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-03-11','F326110222542','2026-03-11','14:22:55','FIT','980000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260311-0022','D','2026-03-11','14:22:55','kasir','PENJUALAN','F326110222542','2906391000','980000','2907371000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='980000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110222542' 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 ('F326110240491','kasir','1',' MEH1 X KH ','TOKO','PM-H','H1E-ZCXG-230-0','KL X NORI SEMI KH 48 8K ','','1.900','1','100.00','2289000','0','0','15000','2290000','0','0','0','2290000','FIT','00392666','H1E','0','0','-','0','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCXG-230-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.900',berat_jual_asli=berat_jual_asli+'1.900',stock_jual='1',berat_akhir=berat_akhir-'1.900',berat_akhir_asli=berat_akhir_asli-'1.900',stock_akhir='0' WHERE tanggal='2026-03-11' AND kode_barang='H1E-ZCXG-230-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 ('F326110240491','2026-03-11','1.900','2026-03-11','14:40:49','PLG0027579','2290000','2290000','0','2290000','2290000','kasir','2026-03-11 14:40:49','F32611024049');
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-03-11','F326110240491','2026-03-11','14:40:49','FIT','2290000','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-260311-0023','D','2026-03-11','14:40:49','kasir','PENJUALAN','F326110240491','2907371000','2290000','2909661000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2290000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110240491' 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 ('F326110240492','kasir',' 1',' MED2E X CM','TOKO','PM-D','D2E-ZABH-51-0','LT X MODEL HURUF MATA CM R 8K ','','0.480','1','100.00','578000','0','0','15000','578000','0','0','0','578000','FIT','00386909','D2E','0','0','-','0','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZABH-51-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-03-11' AND kode_barang='D2E-ZABH-51-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326110240492','2026-03-11','0.480','2026-03-11','14:40:49','PLG0027580','578000','578000','0','578000','578000','kasir','2026-03-11 14:40:49','F32611024049');
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-03-11','F326110240492','2026-03-11','14:40:49','FIT','578000','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-260311-0024','D','2026-03-11','14:40:49','kasir','PENJUALAN','F326110240492','2909661000','578000','2910239000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='578000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110240492' 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 ('F326110240493','kasir',' 1',' MEB1 X BM ','TOKO','PM-B','B1E-ZBAA-93-0','GW X MODEL SLEP CAT BM PE 8K ','','0.500','1','100.00','602000','0','0','15000','602000','0','5000','0','607000','FIT','00389239','B1E','0','0','-','0','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZBAA-93-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-03-11' AND kode_barang='B1E-ZBAA-93-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110240493','2026-03-11','0.500','2026-03-11','14:40:49','PLG0027581','602000','602000','5000','607000','607000','kasir','2026-03-11 14:40:49','F32611024049');
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-03-11','F326110240493','2026-03-11','14:40:49','FIT','607000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260311-0025','D','2026-03-11','14:40:49','kasir','PENJUALAN','F326110240493','2910239000','607000','2910846000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='607000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110240493' 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 ('F326110240494','kasir',' 1',' MEB1 LG PE','TOKO','PM-B','B1E-YLBC-167-0','GW TUSUK MODEL MATA VAR LG PE 8K ','','0.550','1','100.00','663000','0','0','15000','663000','0','0','0','663000','FIT','00382610','B1E','0','0','-','0','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YLBC-167-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-03-11' AND kode_barang='B1E-YLBC-167-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110240494','2026-03-11','0.550','2026-03-11','14:40:49','PLG0027582','663000','663000','0','663000','663000','kasir','2026-03-11 14:40:49','F32611024049');
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-03-11','F326110240494','2026-03-11','14:40:49','FIT','663000','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-260311-0026','D','2026-03-11','14:40:49','kasir','PENJUALAN','F326110240494','2910846000','663000','2911509000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='663000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110240494' 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 ('F326110247451','kasir','1',' MEF3 UB ','TOKO','PM-F','F3E-ZACX-224-0','GL MODEL GENIA UB 8K ','','0.480','1','100.00','578000','0','0','15000','578000','0','0','0','578000','SIN','00387525','F3E','0','0','-','0','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZACX-224-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-03-11' AND kode_barang='F3E-ZACX-224-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 ('F326110247451','2026-03-11','0.480','2026-03-11','14:47:46','PLG0027583','578000','578000','0','578000','578000','kasir','2026-03-11 14:47:45','F32611024745');
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-03-11','F326110247451','2026-03-11','14:47:46','SIN','578000','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-260311-0027','D','2026-03-11','14:47:46','kasir','PENJUALAN','F326110247451','2911509000','578000','2912087000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='578000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110247451' 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 ('F326110247452','kasir',' 1',' MEE2 CM 12','TOKO','PM-E','E2E-ZCAX-180-0','CC MODEL MATA VAR CM 12 8K ','','0.400','1','100.00','486000','0','0','15000','482000','0','0','0','482000','SIN','00393152','E2E','0','0','-','1','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCAX-180-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-03-11' AND kode_barang='E2E-ZCAX-180-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 ('F326110247452','2026-03-11','0.400','2026-03-11','14:47:46','PLG0027584','482000','482000','0','482000','482000','kasir','2026-03-11 14:47:45','F32611024745');
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-03-11','F326110247452','2026-03-11','14:47:46','SIN','482000','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-260311-0028','D','2026-03-11','14:47:46','kasir','PENJUALAN','F326110247452','2912087000','482000','2912569000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='482000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110247452' 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 ('F326110247453','kasir',' 1',' MEE1 5K CM','TOKO','PM-E','E1E-ZCAX-146-0','CC MODEL BUNGA CAT VAR CM 12 8K ','','0.410','1','100.00','498000','0','0','15000','495000','0','5000','0','500000','SIN','00393117','E1E','0','0','-','1','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAX-146-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2026-03-11' AND kode_barang='E1E-ZCAX-146-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 ('F326110247453','2026-03-11','0.410','2026-03-11','14:47:46','PLG0027585','495000','495000','5000','500000','500000','kasir','2026-03-11 14:47:45','F32611024745');
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-03-11','F326110247453','2026-03-11','14:47:46','SIN','500000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260311-0029','D','2026-03-11','14:47:46','kasir','PENJUALAN','F326110247453','2912569000','500000','2913069000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='500000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110247453' 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 ('F326110258131','input','1',' MGS1G X DG','TOKO','PM-S','S1G-ZAAF-16-0','AS X EXTENTION DG 8K ','','0.360','1','100.00','448000','0','0','15000','448000','0','0','0','448000','AAT','00385467','S1G','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZAAF-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-03-11' AND kode_barang='S1G-ZAAF-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-S' 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 ('F326110258131','2026-03-11','0.360','2026-03-11','14:58:13','PLG0027586','448000','448000','0','448000','448000','input','2026-03-11 14:58:13','F32611025813');
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-03-11','F326110258131','2026-03-11','14:58:13','AAT','448000','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-260311-0030','D','2026-03-11','14:58:13','input','PENJUALAN','F326110258131','2913069000','448000','2913517000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='448000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110258131' 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 ('F326110258132','input',' 1',' MEF3E X HW','TOKO','PM-F','F3E-ZAXH-231-0','GL X CASTELI CAPELLA VAR HW 8K ','','2.670','1','100.00','3217000','0','0','15000','3217000','0','0','0','3217000','AAT','00384317','F3E','0','0','-','0','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZAXH-231-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.670',berat_jual_asli=berat_jual_asli+'2.670',stock_jual='1',berat_akhir=berat_akhir-'2.670',berat_akhir_asli=berat_akhir_asli-'2.670',stock_akhir='0' WHERE tanggal='2026-03-11' AND kode_barang='F3E-ZAXH-231-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 ('F326110258132','2026-03-11','2.670','2026-03-11','14:58:13','PLG0027587','3217000','3217000','0','3217000','3217000','input','2026-03-11 14:58:13','F32611025813');
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-03-11','F326110258132','2026-03-11','14:58:13','AAT','3217000','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-260311-0031','D','2026-03-11','14:58:13','input','PENJUALAN','F326110258132','2913517000','3217000','2916734000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3217000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110258132' 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 ('F326110258133','input',' 1',' MED2 X LG ','TOKO','PM-D','D2E-ZAAC-35-0','LT X MODEL HURUF MATA LG S 8K ','','0.550','1','100.00','663000','0','0','15000','663000','0','0','0','663000','AAT','00384942','D2E','0','0','-','0','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZAAC-35-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-03-11' AND kode_barang='D2E-ZAAC-35-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326110258133','2026-03-11','0.550','2026-03-11','14:58:13','PLG0027588','663000','663000','0','663000','663000','input','2026-03-11 14:58:13','F32611025813');
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-03-11','F326110258133','2026-03-11','14:58:13','AAT','663000','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-260311-0032','D','2026-03-11','14:58:13','input','PENJUALAN','F326110258133','2916734000','663000','2917397000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='663000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110258133' 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 ('F326110258134','input',' 1',' MEH1 X UB ','TOKO','PM-H','H1E-ZCXG-233-0','KL X GUCCI UB 42 8K ','','1.960','1','100.00','2362000','0','0','15000','2362000','0','0','0','2362000','AAT','00392669','H1E','0','0','-','0','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-03-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCXG-233-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-03-11' AND kode_barang='H1E-ZCXG-233-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 ('F326110258134','2026-03-11','1.960','2026-03-11','14:58:13','PLG0027589','2362000','2362000','0','2362000','2362000','input','2026-03-11 14:58:13','F32611025813');
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-03-11','F326110258134','2026-03-11','14:58:13','AAT','2362000','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-260311-0033','D','2026-03-11','14:58:13','input','PENJUALAN','F326110258134','2917397000','2362000','2919759000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2362000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110258134' 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-00018434','X-00018434','CC MODEL DAUN SLEP LT 18 8K','GR','---','E1D','BELI','BELI001','965000','2026-03-11','1.040','1','kasir','2026-03-11 15:12:05');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00018434','X-00018434');
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-260311-0009','F325100107201','SIN','1','BELI','BELI001','E1D', 'X-00018434', 'CC MODEL DAUN SLEP LT 18 8K','1.040','1.040','100.00','1048000','965000','927885','1195000','1','965000','965000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.040',berat_beli_asli=berat_beli_asli+'1.040',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.040',berat_akhir_asli=berat_akhir_asli+'1.040',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-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-260311-0009','2026-03-11','2026-03-11','15:12:05','SIN','---','1.040','965000','965000','965000','965000','965000','kasir','2026-03-11 15:12:05','FB-260311-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260311-0009','YATMI','KISMANTORO','','','085735853913','kasir','2026-03-11 15:12:05');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-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-260311-0034','K','2026-03-11','15:12:05','kasir','PEMBELIAN UMUM','FB-260311-0009','2919759000','965000','2918794000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110107021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110107021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110107021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110127051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110127051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110127051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110127052' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110127052' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110127052';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110210361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110210361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110210361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110210362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110210362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110210362';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110214001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110214001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110214001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110222541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110222541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110222541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110222542' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110222542' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110222542';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110240491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110240491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110240491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110240492' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110240492' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110240492';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110240493' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110240493' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110240493';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110240494' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110240494' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110240494';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110247451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110247451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110247451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110247452' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110247452' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110247452';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110247453' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110247453' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110247453';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110258131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110258131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110258131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110258132' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110258132' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110258132';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110258133' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110258133' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110258133';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110258134' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110258134' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110258134';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110841281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110841281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110841281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110841282' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110841282' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110841282';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111020161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111020161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111020161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111133241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111133241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111133241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111158281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111158281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111158281';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260311-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260311-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260311-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260311-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260311-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260311-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260311-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260311-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260311-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260311-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260311-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260311-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260311-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260311-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260311-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260311-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260311-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260311-0009';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-12','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-09';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-11';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-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-03-11' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-11';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-11';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-11';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-11';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-12' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-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-260312-0001','D','2026-03-12','15:42:11','SYSTEM','SALDO AWAL','SALDO AWAL','0','2918794000','2918794000');
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-260312-0001','D','2026-03-12','15:42:11','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260312-0001','D','2026-03-12','15:42:11','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260312-0001','D','2026-03-12','15:42:11','BCA','SALDO AWAL','SALDO AWAL','0','707186000','707186000');
UPDATE tp_system SET tgl_system='2026-03-12';