INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-26 ','08:11:33');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20250926-0001','1','CKPRE-YIBE-1-0','1','5.220','5.220','TOKO','PER','TOKO','PERAK');
DELETE FROM tm_barang WHERE kode_barang='CKPRE-YIBE-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPRE-YIBE-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKPRE-YIBE-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPRE-YIBE-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PERAK',tgl_last_beli='2025-09-26 08:11:52' WHERE kode_barang='CKPRE-YIBE-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKPRE-YIBE-1-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-09-26 08:11:52','TOKO','PERAK','CKPRE','CKPRE-YIBE-1-0','1','5.220','5.220','1','5.220','5.220','100.00');
DELETE FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPRE-YIBE-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YIBE-1-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-26' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20250926-0001','1','CKPRE-YIBE-2-0','1','4.930','4.930','TOKO','PER','TOKO','PERAK');
DELETE FROM tm_barang WHERE kode_barang='CKPRE-YIBE-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPRE-YIBE-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKPRE-YIBE-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPRE-YIBE-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PERAK',tgl_last_beli='2025-09-26 08:11:52' WHERE kode_barang='CKPRE-YIBE-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKPRE-YIBE-2-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-09-26 08:11:52','TOKO','PERAK','CKPRE','CKPRE-YIBE-2-0','1','4.930','4.930','1','4.930','4.930','100.00');
DELETE FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPRE-YIBE-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YIBE-2-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-26' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20250926-0001','1','CKPRE-YIBE-3-0','1','4.500','4.500','TOKO','PER','TOKO','PERAK');
DELETE FROM tm_barang WHERE kode_barang='CKPRE-YIBE-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='CKPRE-YIBE-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKPRE-YIBE-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='CKPRE-YIBE-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PERAK',tgl_last_beli='2025-09-26 08:11:53' WHERE kode_barang='CKPRE-YIBE-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='CKPRE-YIBE-3-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-09-26 08:11:53','TOKO','PERAK','CKPRE','CKPRE-YIBE-3-0','1','4.500','4.500','1','4.500','4.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='CKPRE-YIBE-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-YIBE-3-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-26' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250926-0001','2025-09-26','08:11','14.650','kasir','2025-09-26 08:11:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-09-26 ','08:25:22');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-26 ','11:01:31');
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-00008740','X-00008740','GELANG GBRE-00649','GR','---','GBRE','BELI','BELI001','6200000','2025-09-26','1.630','1','kasir','2025-09-26 13:14:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-GBRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-GBRE','X-00008740','X-00008740');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-250926-0001','FE-250527-0002','admin','1','BELI','BELI001','GBRE', 'X-00008740', 'GELANG GBRE-00649','1.630','1.630','75.00','8000000','6200000','3803681','1','6200000','6200000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.630',berat_beli_asli=berat_beli_asli+'1.630',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.630',berat_akhir_asli=berat_akhir_asli+'1.630',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='GBRE' 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,status_valid,type_bayar) VALUES ('BE-250926-0001','2025-09-26','2025-09-26','13:14:49','admin','---','1.630','6200000','6200000','6200000','6200000','6200000','kasir','2025-09-26 13:14:50','BE-250926-0001','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-250926-0001','GITTA','JKT','','','/','kasir','2025-09-26 13:14:50');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250926-0001','2025-09-26','2025-09-26 13:14:50','PEMBELIAN UMUM : BE-250926-0001','-','TBC','6200000','6200000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-250926-0002','K','2025-09-26','13:14:49','TBC','PEMBELIAN UMUM','BE-250926-0001','92294200220','6200000','92288000220','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','');
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-00008741','X-00008741','GBRE00335','GR','---','GBR','BELI','BELI001','7600000','2025-09-26','5.520','1','kasir','2025-09-26 13:16:11');
DELETE FROM tp_barang WHERE kode_dept = 'X-GBR';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-GBR','X-00008741','X-00008741');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-250926-0002','00008407','FAISAL','1','BELI','BELI001','GBR', 'X-00008741', 'GBRE00335','5.520','5.520','75.00','9500000','7600000','1376812','1','7600000','7600000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.520',berat_beli_asli=berat_beli_asli+'5.520',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.520',berat_akhir_asli=berat_akhir_asli+'5.520',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='GBR' 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,status_valid,type_bayar) VALUES ('BE-250926-0002','2025-09-26','2025-09-26','13:16:11','FAISAL','---','5.520','7600000','7600000','7600000','7600000','7600000','kasir','2025-09-26 13:16:11','BE-250926-0002','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-250926-0002','NOVIAN','JKT','','JKT','','kasir','2025-09-26 13:16:11');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250926-0002','2025-09-26','2025-09-26 13:16:11','PEMBELIAN UMUM : BE-250926-0002','-','TBC','7600000','7600000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-250926-0003','K','2025-09-26','13:16:11','TBC','PEMBELIAN UMUM','BE-250926-0002','92288000220','7600000','92280400220','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-250926-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-250926-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-250926-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-250926-0002';
UPDATE tm_credit_card SET nama_customer='-',no_ktp='-',alamat1=' - ' ,alamat2=' - ' ,kota= ' - ' ,no_telp='-',tgl_valid_until='-',tgl_last_gesek='2025-09-26 13:31:08' WHERE id_card = '-';
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,potong_rp,keterangan) VALUES ('FE-250926-0001','kasir','1',' ABRE-01930','TOKO','ABR','ABRE-YABA-7-0','ANTING ABRE-01930','','2.380','1','103.00','10636000','4357000','264','16500','11700000','0','0','0','11700000','NANA','00033465','ABRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='ABRE-YABA-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.380',berat_jual_asli=berat_jual_asli+'2.380',stock_jual='1',berat_akhir=berat_akhir-'2.380',berat_akhir_asli=berat_akhir_asli-'2.380',stock_akhir='0' WHERE tanggal='2025-09-26' AND kode_barang='ABRE-YABA-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='ABR' 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,no_persekot,dp_pesanan) VALUES ('FE-250926-0001','2025-09-26','2.380','2025-09-26','13:31:13','PLG0026966','11700000','11700000','0','11700000','0','kasir','2025-09-26 13:31:11','FE-250926-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-26','FE-250926-0001','2025-09-26','13:31:13','NANA','11700000','0');
INSERT INTO tt_card(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,card_rp,card_fee_rp) VALUES ('CC-250926-0001','2025-09-26','2025-09-26 13:31:11','PENJUALAN : FE-250926-0001','','BCK','11700000','11700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250926-0002','D','2025-09-26','13:31:13','BCK','PENJUALAN BERLIAN','FE-250926-0001','15809684978.088','11700000','15821384978.088','CARD');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='11700000',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FE-250926-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-250926-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-250926-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-250926-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-09-26 ','14:39:17');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-09-26 ','14:50:42');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-09-26 ','15:28:13');
DELETE FROM tm_berlian WHERE kode_barang='PSBRE-YIXC-1-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('PSBRE-YIXC-1-0','PSBRE-YIXC-1-0','00038506','RD','1','0.100','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('PSBRE-YIXC-1-0','00038506','RD','1','0.100','620','62')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('PSBRE-YIXC-1-0','00038506','00038506','CINCIN BERLIAN','CINCIN BERLIAN','','','7499500','7499500',' 0','0','spv','2025-09-26 15:30:08');
UPDATE tm_barang SET nama_barang='CINCIN BERLIAN' ,nama_atribut='' ,kode_intern='DP-02863 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 12',total_usd_ext='PSN02863',total_usd='62' WHERE kode_barang='PSBRE-YIXC-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSBRE-YIXC-1-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('PSBRE-YIXC-1-0','PSBRE-YIXC-1-0','00038506','RD','1','0.100','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('PSBRE-YIXC-1-0','00038506','RD','1','0.100','620','62')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('PSBRE-YIXC-1-0','00038506','00038506','CINCIN BERLIAN','CINCIN BERLIAN','','','7499500','7499500',' 0','0','spv','2025-09-26 15:31:09');
UPDATE tm_barang SET nama_barang='CINCIN BERLIAN' ,nama_atribut='' ,kode_intern='DP-02863 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 12',total_usd_ext='PSN02863',total_usd='62' WHERE kode_barang='PSBRE-YIXC-1-0' LIMIT 1;
UPDATE tm_credit_card SET nama_customer='.',no_ktp='.',alamat1=' . ' ,alamat2=' ' ,kota= ' . ' ,no_telp='.',tgl_valid_until='.',tgl_last_gesek='2025-09-26 16:26:29' WHERE id_card = '.';
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,potong_rp,keterangan) VALUES ('FE-250926-0002','kasir','1',' GBRE-00203','TOKO','GBR','GBRE-YEXF-18-0','GELANG GBRE-00203 ','','4.960','1','103.00','13116000','1730500','105','16500','14600000','0','0','0','14600000','BARY','00035475','GBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='GBRE-YEXF-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.960',berat_jual_asli=berat_jual_asli+'4.960',stock_jual='1',berat_akhir=berat_akhir-'4.960',berat_akhir_asli=berat_akhir_asli-'4.960',stock_akhir='0' WHERE tanggal='2025-09-26' AND kode_barang='GBRE-YEXF-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='GBR' 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,no_persekot,dp_pesanan) VALUES ('FE-250926-0002','2025-09-26','4.960','2025-09-26','16:26:33','PLG0026967','14600000','14600000','0','14600000','0','kasir','2025-09-26 16:26:31','FE-250926-0002','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-26','FE-250926-0002','2025-09-26','16:26:33','BARY','14600000','0');
INSERT INTO tt_card(no_trx,tgl_system,tgl_trx,deskripsi,id_card,kode_bank,jml_cash_rp,card_rp,card_fee_rp) VALUES ('CC-250926-0002','2025-09-26','2025-09-26 16:26:31','PENJUALAN : FE-250926-0002','.','BCK','14600000','14600000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250926-0003','D','2025-09-26','16:26:33','BCK','PENJUALAN BERLIAN','FE-250926-0002','15821384978.088','14600000','15835984978.088','CARD');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='14600000',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FE-250926-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-250926-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-250926-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-250926-0002';
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-00008742','X-00008742','GELANG GBRE-01113','GR','---','GBRE','BELI','BELI001','32800000','2025-09-26','12.570','1','kasir','2025-09-26 17:03:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-GBRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-GBRE','X-00008742','X-00008742');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-250926-0003','FE-230710-0004','NANA','1','BELI','BELI001','GBRE', 'X-00008742', 'GELANG GBRE-01113','12.570','12.570','85.00','41000000','32800000','2609387','1','32800000','32800000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'12.570',berat_beli_asli=berat_beli_asli+'12.570',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'12.570',berat_akhir_asli=berat_akhir_asli+'12.570',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='GBRE' 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,status_valid,type_bayar) VALUES ('BE-250926-0003','2025-09-26','2025-09-26','17:03:59','NANA','---','12.570','32800000','32800000','32800000','32800000','32800000','kasir','2025-09-26 17:03:59','BE-250926-0003','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-250926-0003','CANDY AMELIA','JKT','','','-','kasir','2025-09-26 17:03:59');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250926-0003','2025-09-26','2025-09-26 17:03:59','PEMBELIAN UMUM : BE-250926-0003','.','TBC','32800000','32800000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-250926-0004','K','2025-09-26','17:03:59','TBC','PEMBELIAN UMUM','BE-250926-0003','92280400220','32800000','92247600220','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
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-00008743','X-00008743','CINCIN CBRE-06113','GR','---','CBRE','BELI','BELI001','8240000','2025-09-26','2.730','1','kasir','2025-09-26 17:04:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-CBRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBRE','X-00008743','X-00008743');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-250926-0004','FE-240118-0003','NANA','1','BELI','BELI001','CBRE', 'X-00008743', 'CINCIN CBRE-06113','2.730','2.730','83.00','10300000','8240000','3018315','1','8240000','8240000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.730',berat_beli_asli=berat_beli_asli+'2.730',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.730',berat_akhir_asli=berat_akhir_asli+'2.730',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CBRE' 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,status_valid,type_bayar) VALUES ('BE-250926-0004','2025-09-26','2025-09-26','17:04:42','NANA','---','2.730','8240000','8240000','8240000','8240000','8240000','kasir','2025-09-26 17:04:42','BE-250926-0004','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-250926-0004','HUSNUL KHOTIMAH','-','','','0','kasir','2025-09-26 17:04:42');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250926-0004','2025-09-26','2025-09-26 17:04:42','PEMBELIAN UMUM : BE-250926-0004','.','TBC','8240000','8240000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-250926-0005','K','2025-09-26','17:04:42','TBC','PEMBELIAN UMUM','BE-250926-0004','92247600220','8240000','92239360220','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-250926-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-250926-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-250926-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-250926-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-26 ','17:06:50');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-26 17:07:05');
CREATE TABLE th_20250926_170705 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250926_170705_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='AMP' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '17:10:42',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-XCBF-23-0' AND kode_barcode='00027767';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-XCBF-23-0','00027767','2025-09-26',' 17:10:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-34' AND kode_barcode='A0000542';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-34','A0000542','2025-09-26',' 17:11:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-XLBG-38-0' AND kode_barcode='00032998';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-XLBG-38-0','00032998','2025-09-26',' 17:11:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMR-YCXE-117-0' AND kode_barcode='00034620';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMR-YCXE-117-0','00034620','2025-09-26',' 17:12:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-UCBD-10' AND kode_barcode='00005108';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-UCBD-10','00005108','2025-09-26',' 17:12:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXG-11' AND kode_barcode='A0000444';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXG-11','A0000444','2025-09-26',' 17:12:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-13' AND kode_barcode='A0000521';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-13','A0000521','2025-09-26',' 17:13:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-YBBE-34-0' AND kode_barcode='00034387';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-YBBE-34-0','00034387','2025-09-26',' 17:13:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXG-24' AND kode_barcode='A0000488';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXG-24','A0000488','2025-09-26',' 17:14:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-WGXE-6-0' AND kode_barcode='00022746';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-WGXE-6-0','00022746','2025-09-26',' 17:14:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-44' AND kode_barcode='A0000552';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-44','A0000552','2025-09-26',' 17:14:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-29' AND kode_barcode='A0000537';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-29','A0000537','2025-09-26',' 17:15:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-YHBF-3-0' AND kode_barcode='00038301';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-YHBF-3-0','00038301','2025-09-26',' 17:15:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-XIXF-48-0' AND kode_barcode='00031168';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-XIXF-48-0','00031168','2025-09-26',' 17:15:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-8' AND kode_barcode='A0000516';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-8','A0000516','2025-09-26',' 17:15:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMR-YCXE-74-0' AND kode_barcode='00034577';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMR-YCXE-74-0','00034577','2025-09-26',' 17:15:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-17' AND kode_barcode='A0000525';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-17','A0000525','2025-09-26',' 17:16:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMR-ULAD-137-0' AND kode_barcode='00011050';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMR-ULAD-137-0','00011050','2025-09-26',' 17:16:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMR-ULAD-133-0' AND kode_barcode='00011046';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMR-ULAD-133-0','00011046','2025-09-26',' 17:16:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-42' AND kode_barcode='A0000550';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-42','A0000550','2025-09-26',' 17:16:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-UCBD-6' AND kode_barcode='00005104';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-UCBD-6','00005104','2025-09-26',' 17:17:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-26' AND kode_barcode='A0000534';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-26','A0000534','2025-09-26',' 17:17:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-45' AND kode_barcode='A0000553';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-45','A0000553','2025-09-26',' 17:17:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-XCBF-21-0' AND kode_barcode='00027765';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-XCBF-21-0','00027765','2025-09-26',' 17:17:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-UEXA-1' AND kode_barcode='00006343';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-UEXA-1','00006343','2025-09-26',' 17:17:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-XCBF-20-0' AND kode_barcode='00027764';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-XCBF-20-0','00027764','2025-09-26',' 17:17:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-UCBD-2' AND kode_barcode='00005100';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-UCBD-2','00005100','2025-09-26',' 17:18:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-35' AND kode_barcode='A0000543';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-35','A0000543','2025-09-26',' 17:18:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMR-YCXE-71-0' AND kode_barcode='00034574';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMR-YCXE-71-0','00034574','2025-09-26',' 17:18:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-XKXG-11-0' AND kode_barcode='00032078';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-XKXG-11-0','00032078','2025-09-26',' 17:18:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-YAXB-22-0' AND kode_barcode='00033172';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-YAXB-22-0','00033172','2025-09-26',' 17:19:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMR-ULAD-142-0' AND kode_barcode='00011055';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMR-ULAD-142-0','00011055','2025-09-26',' 17:19:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMR-YCXE-119-0' AND kode_barcode='00034622';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMR-YCXE-119-0','00034622','2025-09-26',' 17:19:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMR-XAAH-53-0' AND kode_barcode='00025976';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMR-XAAH-53-0','00025976','2025-09-26',' 17:19:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMR-YCXE-116-0' AND kode_barcode='00034619';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMR-YCXE-116-0','00034619','2025-09-26',' 17:19:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMR-ULAD-29-0' AND kode_barcode='00010942';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMR-ULAD-29-0','00010942','2025-09-26',' 17:20:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-XKXD-9-0' AND kode_barcode='00032041';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-XKXD-9-0','00032041','2025-09-26',' 17:20:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TJBH-1' AND kode_barcode='00002037';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TJBH-1','00002037','2025-09-26',' 17:21:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXG-21' AND kode_barcode='A0000485';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXG-21','A0000485','2025-09-26',' 17:21:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXF-9' AND kode_barcode='A0000404';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXF-9','A0000404','2025-09-26',' 17:21:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-39' AND kode_barcode='A0000547';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-39','A0000547','2025-09-26',' 17:21:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMR-ULAD-134-0' AND kode_barcode='00011047';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMR-ULAD-134-0','00011047','2025-09-26',' 17:21:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMR-ULAD-124-0' AND kode_barcode='00011037';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMR-ULAD-124-0','00011037','2025-09-26',' 17:21:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMR-ULAD-136-0' AND kode_barcode='00011049';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMR-ULAD-136-0','00011049','2025-09-26',' 17:22:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-UCBD-48' AND kode_barcode='00005187';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-UCBD-48','00005187','2025-09-26',' 17:22:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-YBBE-27-0' AND kode_barcode='00034380';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-YBBE-27-0','00034380','2025-09-26',' 17:22:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-5' AND kode_barcode='A0000513';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-5','A0000513','2025-09-26',' 17:22:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-27' AND kode_barcode='A0000535';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-27','A0000535','2025-09-26',' 17:22:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMR-YHBF-5-0' AND kode_barcode='00038303';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMR-YHBF-5-0','00038303','2025-09-26',' 17:22:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-33' AND kode_barcode='A0000541';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-33','A0000541','2025-09-26',' 17:23:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-YDAF-18-0' AND kode_barcode='00035023';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-YDAF-18-0','00035023','2025-09-26',' 17:23:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-PKBB-22-0' AND kode_barcode='00018580';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-PKBB-22-0','00018580','2025-09-26',' 17:23:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-23' AND kode_barcode='A0000531';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-23','A0000531','2025-09-26',' 17:23:36','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-YHAE-119-0' AND kode_barcode='00038161';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-YHAE-119-0','00038161','2025-09-26',' 17:23:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMR-ULAD-131-0' AND kode_barcode='00011044';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMR-ULAD-131-0','00011044','2025-09-26',' 17:23:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXG-8' AND kode_barcode='A0000441';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXG-8','A0000441','2025-09-26',' 17:24:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMR-ULAD-132-0' AND kode_barcode='00011045';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMR-ULAD-132-0','00011045','2025-09-26',' 17:24:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-YIAX-14-0' AND kode_barcode='00038680';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-YIAX-14-0','00038680','2025-09-26',' 17:24:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-UCBD-33' AND kode_barcode='00005136';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-UCBD-33','00005136','2025-09-26',' 17:24:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-30' AND kode_barcode='A0000538';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-30','A0000538','2025-09-26',' 17:24:36','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-3' AND kode_barcode='A0000511';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-3','A0000511','2025-09-26',' 17:24:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXG-15' AND kode_barcode='A0000479';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXG-15','A0000479','2025-09-26',' 17:24:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMR-YCXE-118-0' AND kode_barcode='00034621';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMR-YCXE-118-0','00034621','2025-09-26',' 17:25:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-XLBG-59-0' AND kode_barcode='00033019';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-XLBG-59-0','00033019','2025-09-26',' 17:25:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-YHXA-1-0' AND kode_barcode='00037824';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-YHXA-1-0','00037824','2025-09-26',' 17:25:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-24' AND kode_barcode='A0000532';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-24','A0000532','2025-09-26',' 17:25:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXG-13' AND kode_barcode='A0000446';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXG-13','A0000446','2025-09-26',' 17:25:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-22' AND kode_barcode='A0000530';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-22','A0000530','2025-09-26',' 17:25:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXF-4' AND kode_barcode='A0000399';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXF-4','A0000399','2025-09-26',' 17:25:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXG-10' AND kode_barcode='A0000443';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXG-10','A0000443','2025-09-26',' 17:26:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXF-12' AND kode_barcode='A0000407';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXF-12','A0000407','2025-09-26',' 17:26:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMR-ULAD-30-0' AND kode_barcode='00010943';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMR-ULAD-30-0','00010943','2025-09-26',' 17:26:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-UCBD-22' AND kode_barcode='00005120';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-UCBD-22','00005120','2025-09-26',' 17:26:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-XLBG-39-0' AND kode_barcode='00032999';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-XLBG-39-0','00032999','2025-09-26',' 17:26:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXF-11' AND kode_barcode='A0000406';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXF-11','A0000406','2025-09-26',' 17:26:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-43' AND kode_barcode='A0000551';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-43','A0000551','2025-09-26',' 17:26:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXF-8' AND kode_barcode='A0000403';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXF-8','A0000403','2025-09-26',' 17:27:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-YFBD-22-0' AND kode_barcode='00036685';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-YFBD-22-0','00036685','2025-09-26',' 17:27:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-UCBD-41' AND kode_barcode='00005144';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-UCBD-41','00005144','2025-09-26',' 17:27:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-51' AND kode_barcode='A0000559';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-51','A0000559','2025-09-26',' 17:27:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-14' AND kode_barcode='A0000522';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-14','A0000522','2025-09-26',' 17:27:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-YHBF-4-0' AND kode_barcode='00038302';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-YHBF-4-0','00038302','2025-09-26',' 17:27:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMP-TDXH-31' AND kode_barcode='A0000539';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMP-TDXH-31','A0000539','2025-09-26',' 17:28:07','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-26 17:30:08');
CREATE TABLE th_20250926_173008 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250926_173008_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-26 17:30:10');
CREATE TABLE th_20250926_173010 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250926_173010_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='AMK' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '17:30:19',input_by='kasir';
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='AMK' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '17:30:47',input_by='kasir';
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='AMK' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '17:31:17',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXH-16' AND kode_barcode='A0000578';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXH-16','A0000578','2025-09-26',' 17:31:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXI-20' AND kode_barcode='A0000600';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXI-20','A0000600','2025-09-26',' 17:31:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXI-31' AND kode_barcode='A0000611';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXI-31','A0000611','2025-09-26',' 17:31:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXH-2' AND kode_barcode='A0000564';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXH-2','A0000564','2025-09-26',' 17:31:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-UCBD-16' AND kode_barcode='00005166';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-UCBD-16','00005166','2025-09-26',' 17:32:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-UCBD-21' AND kode_barcode='00005171';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-UCBD-21','00005171','2025-09-26',' 17:32:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDAX-10' AND kode_barcode='A0000650';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDAX-10','A0000650','2025-09-26',' 17:32:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXI-1' AND kode_barcode='A0000581';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXI-1','A0000581','2025-09-26',' 17:32:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXI-53' AND kode_barcode='A0000633';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXI-53','A0000633','2025-09-26',' 17:32:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDAX-1' AND kode_barcode='A0000641';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDAX-1','A0000641','2025-09-26',' 17:32:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-VCBI-27-0' AND kode_barcode='00013692';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-VCBI-27-0','00013692','2025-09-26',' 17:32:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXI-41' AND kode_barcode='A0000621';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXI-41','A0000621','2025-09-26',' 17:32:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXI-2' AND kode_barcode='A0000582';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXI-2','A0000582','2025-09-26',' 17:33:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-UCBD-53' AND kode_barcode='00005205';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-UCBD-53','00005205','2025-09-26',' 17:33:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-XLBF-22-0' AND kode_barcode='00032911';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-XLBF-22-0','00032911','2025-09-26',' 17:33:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-UEXE-1' AND kode_barcode='00006376';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-UEXE-1','00006376','2025-09-26',' 17:33:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TJAX-1' AND kode_barcode='00001845';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TJAX-1','00001845','2025-09-26',' 17:33:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-WLAH-12-0' AND kode_barcode='00025385';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-WLAH-12-0','00025385','2025-09-26',' 17:33:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXI-49' AND kode_barcode='A0000629';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXI-49','A0000629','2025-09-26',' 17:34:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TJBC-1' AND kode_barcode='00002009';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TJBC-1','00002009','2025-09-26',' 17:34:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDAX-26' AND kode_barcode='A0000666';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDAX-26','A0000666','2025-09-26',' 17:34:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXI-15' AND kode_barcode='A0000595';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXI-15','A0000595','2025-09-26',' 17:34:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-UCBD-61' AND kode_barcode='00005213';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-UCBD-61','00005213','2025-09-26',' 17:35:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-XBAI-78-0' AND kode_barcode='00026730';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-XBAI-78-0','00026730','2025-09-26',' 17:35:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-VDBF-37-0' AND kode_barcode='00014435';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-VDBF-37-0','00014435','2025-09-26',' 17:35:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-XBAC-28-0' AND kode_barcode='00026609';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-XBAC-28-0','00026609','2025-09-26',' 17:35:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXI-6' AND kode_barcode='A0000586';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXI-6','A0000586','2025-09-26',' 17:36:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-UCBD-40' AND kode_barcode='00005191';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-UCBD-40','00005191','2025-09-26',' 17:36:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-UCBD-42' AND kode_barcode='00005194';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-UCBD-42','00005194','2025-09-26',' 17:36:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXI-60' AND kode_barcode='A0000640';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXI-60','A0000640','2025-09-26',' 17:36:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDAX-22' AND kode_barcode='A0000662';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDAX-22','A0000662','2025-09-26',' 17:37:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDAX-2' AND kode_barcode='A0000642';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDAX-2','A0000642','2025-09-26',' 17:37:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-UCBD-56' AND kode_barcode='00005208';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-UCBD-56','00005208','2025-09-26',' 17:37:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDAX-4' AND kode_barcode='A0000644';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDAX-4','A0000644','2025-09-26',' 17:37:36','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-UCBD-27' AND kode_barcode='00005177';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-UCBD-27','00005177','2025-09-26',' 17:37:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDAX-16' AND kode_barcode='A0000656';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDAX-16','A0000656','2025-09-26',' 17:38:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-XBAE-11-0' AND kode_barcode='00026622';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-XBAE-11-0','00026622','2025-09-26',' 17:38:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDAX-5' AND kode_barcode='A0000645';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDAX-5','A0000645','2025-09-26',' 17:38:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDAX-3' AND kode_barcode='A0000643';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDAX-3','A0000643','2025-09-26',' 17:39:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-UCBD-1' AND kode_barcode='00005151';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-UCBD-1','00005151','2025-09-26',' 17:39:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXI-32' AND kode_barcode='A0000612';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXI-32','A0000612','2025-09-26',' 17:39:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDAX-12' AND kode_barcode='A0000652';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDAX-12','A0000652','2025-09-26',' 17:39:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-UCBD-30' AND kode_barcode='00005180';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-UCBD-30','00005180','2025-09-26',' 17:39:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-WHXC-3-0' AND kode_barcode='00023293';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-WHXC-3-0','00023293','2025-09-26',' 17:40:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXH-12' AND kode_barcode='A0000574';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXH-12','A0000574','2025-09-26',' 17:40:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXI-51' AND kode_barcode='A0000631';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXI-51','A0000631','2025-09-26',' 17:40:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-UCBD-4' AND kode_barcode='00005154';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-UCBD-4','00005154','2025-09-26',' 17:40:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-UCBD-25' AND kode_barcode='00005175';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-UCBD-25','00005175','2025-09-26',' 17:40:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-UCBD-24' AND kode_barcode='00005174';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-UCBD-24','00005174','2025-09-26',' 17:40:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXH-6' AND kode_barcode='A0000568';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXH-6','A0000568','2025-09-26',' 17:40:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXI-37' AND kode_barcode='A0000617';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXI-37','A0000617','2025-09-26',' 17:41:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDAX-7' AND kode_barcode='A0000647';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDAX-7','A0000647','2025-09-26',' 17:41:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-UCBD-48' AND kode_barcode='00005200';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-UCBD-48','00005200','2025-09-26',' 17:42:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDAX-21' AND kode_barcode='A0000661';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDAX-21','A0000661','2025-09-26',' 17:42:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-YDBI-39-0' AND kode_barcode='00035332';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-YDBI-39-0','00035332','2025-09-26',' 17:42:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXI-39' AND kode_barcode='A0000619';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXI-39','A0000619','2025-09-26',' 17:42:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-UCBD-18' AND kode_barcode='00005168';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-UCBD-18','00005168','2025-09-26',' 17:42:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-PHBE-32-0' AND kode_barcode='00016826';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-PHBE-32-0','00016826','2025-09-26',' 17:42:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXH-15' AND kode_barcode='A0000577';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXH-15','A0000577','2025-09-26',' 17:42:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXH-8' AND kode_barcode='A0000570';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXH-8','A0000570','2025-09-26',' 17:42:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-UCBD-15' AND kode_barcode='00005165';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-UCBD-15','00005165','2025-09-26',' 17:43:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDAX-27' AND kode_barcode='A0000667';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDAX-27','A0000667','2025-09-26',' 17:43:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXH-5' AND kode_barcode='A0000567';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXH-5','A0000567','2025-09-26',' 17:43:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-PFBG-37-0' AND kode_barcode='00015626';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-PFBG-37-0','00015626','2025-09-26',' 17:43:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDXH-13' AND kode_barcode='A0000575';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDXH-13','A0000575','2025-09-26',' 17:43:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-TDAX-8' AND kode_barcode='A0000648';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-TDAX-8','A0000648','2025-09-26',' 17:44:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-UCBD-60' AND kode_barcode='00005212';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-UCBD-60','00005212','2025-09-26',' 17:44:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='AMK-VDBF-36-0' AND kode_barcode='00014434';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('AMK-VDBF-36-0','00014434','2025-09-26',' 17:44:22','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-26 17:47:04');
CREATE TABLE th_20250926_174704 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250926_174704_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-26 17:47:09');
CREATE TABLE th_20250926_174709 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250926_174709_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='LBR' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '17:47:17',input_by='kasir';
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='KMP' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '17:47:28',input_by='kasir';
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='KMP' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '17:47:41',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-XFXG-9-0' AND kode_barcode='00028920';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-XFXG-9-0','00028920','2025-09-26',' 17:47:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-WKAD-1-0' AND kode_barcode='00024855';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-WKAD-1-0','00024855','2025-09-26',' 17:47:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-WEXD-7-0' AND kode_barcode='00021451';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-WEXD-7-0','00021451','2025-09-26',' 17:49:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-YIAX-18-0' AND kode_barcode='00038684';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-YIAX-18-0','00038684','2025-09-26',' 17:49:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-WGAD-18-0' AND kode_barcode='00022925';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-WGAD-18-0','00022925','2025-09-26',' 17:49:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-PJBD-2-0' AND kode_barcode='00018025';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-PJBD-2-0','00018025','2025-09-26',' 17:49:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-PFAH-12-0' AND kode_barcode='00015298';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-PFAH-12-0','00015298','2025-09-26',' 17:49:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-VAXH-25-0' AND kode_barcode='00011594';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-VAXH-25-0','00011594','2025-09-26',' 17:50:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-VAXH-54-0' AND kode_barcode='00011623';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-VAXH-54-0','00011623','2025-09-26',' 17:50:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-XAAH-68-0' AND kode_barcode='00025991';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-XAAH-68-0','00025991','2025-09-26',' 17:50:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-XLBF-67-0' AND kode_barcode='00032956';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-XLBF-67-0','00032956','2025-09-26',' 17:50:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-XIXC-17-0' AND kode_barcode='00031051';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-XIXC-17-0','00031051','2025-09-26',' 17:50:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-PJBI-3-0' AND kode_barcode='00018154';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-PJBI-3-0','00018154','2025-09-26',' 17:50:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMA-UIBG-93-0' AND kode_barcode='00009176';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMA-UIBG-93-0','00009176','2025-09-26',' 17:51:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-XDXC-10-0' AND kode_barcode='00027938';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-XDXC-10-0','00027938','2025-09-26',' 17:51:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-UDBB-4' AND kode_barcode='00006125';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-UDBB-4','00006125','2025-09-26',' 17:51:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMA-UIBG-92-0' AND kode_barcode='00009175';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMA-UIBG-92-0','00009175','2025-09-26',' 17:51:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-XLBF-52-0' AND kode_barcode='00032941';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-XLBF-52-0','00032941','2025-09-26',' 17:51:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-WEXD-8-0' AND kode_barcode='00021452';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-WEXD-8-0','00021452','2025-09-26',' 17:52:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-XIXC-19-0' AND kode_barcode='00031053';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-XIXC-19-0','00031053','2025-09-26',' 17:52:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-PGBG-22-0' AND kode_barcode='00016331';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-PGBG-22-0','00016331','2025-09-26',' 17:52:41','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-UCBX-1' AND kode_barcode='00005043';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-UCBX-1','00005043','2025-09-26',' 17:52:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-XIXF-13-0' AND kode_barcode='00031133';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-XIXF-13-0','00031133','2025-09-26',' 17:53:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-UCBE-1' AND kode_barcode='00005257';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-UCBE-1','00005257','2025-09-26',' 17:54:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-ULAD-52-0' AND kode_barcode='00010965';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-ULAD-52-0','00010965','2025-09-26',' 17:54:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-XAAH-30-0' AND kode_barcode='00025953';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-XAAH-30-0','00025953','2025-09-26',' 17:55:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-XLBF-55-0' AND kode_barcode='00032944';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-XLBF-55-0','00032944','2025-09-26',' 17:55:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-XAAH-38-0' AND kode_barcode='00025961';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-XAAH-38-0','00025961','2025-09-26',' 17:55:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-XAAH-35-0' AND kode_barcode='00025958';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-XAAH-35-0','00025958','2025-09-26',' 17:55:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-XAAH-34-0' AND kode_barcode='00025957';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-XAAH-34-0','00025957','2025-09-26',' 17:55:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-XAAH-32-0' AND kode_barcode='00025955';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-XAAH-32-0','00025955','2025-09-26',' 17:56:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-XIXF-14-0' AND kode_barcode='00031134';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-XIXF-14-0','00031134','2025-09-26',' 17:56:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-XLBD-29-0' AND kode_barcode='00032847';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-XLBD-29-0','00032847','2025-09-26',' 17:57:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-XAAH-33-0' AND kode_barcode='00025956';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-XAAH-33-0','00025956','2025-09-26',' 17:57:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-XLBF-54-0' AND kode_barcode='00032943';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-XLBF-54-0','00032943','2025-09-26',' 17:57:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-UIBG-98-0' AND kode_barcode='00009181';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-UIBG-98-0','00009181','2025-09-26',' 17:58:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-XIXF-26-0' AND kode_barcode='00031146';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-XIXF-26-0','00031146','2025-09-26',' 17:58:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-PHCA-26-0' AND kode_barcode='00016929';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-PHCA-26-0','00016929','2025-09-26',' 17:59:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-XLBG-72-0' AND kode_barcode='00033032';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-XLBG-72-0','00033032','2025-09-26',' 17:59:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-YHBE-45-0' AND kode_barcode='00038290';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-YHBE-45-0','00038290','2025-09-26',' 17:59:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TDXC-22' AND kode_barcode='A0000130';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TDXC-22','A0000130','2025-09-26',' 17:59:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-XJXH-17-0' AND kode_barcode='00031649';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-XJXH-17-0','00031649','2025-09-26',' 17:59:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMA-UIBG-108-0' AND kode_barcode='00009191';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMA-UIBG-108-0','00009191','2025-09-26',' 18:00:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-VDAB-28-0' AND kode_barcode='00014022';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-VDAB-28-0','00014022','2025-09-26',' 18:00:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-XLBF-51-0' AND kode_barcode='00032940';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-XLBF-51-0','00032940','2025-09-26',' 18:00:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-WJAI-9-0' AND kode_barcode='00024568';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-WJAI-9-0','00024568','2025-09-26',' 18:00:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-XAAH-31-0' AND kode_barcode='00025954';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-XAAH-31-0','00025954','2025-09-26',' 18:00:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-XIXC-21-0' AND kode_barcode='00031055';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-XIXC-21-0','00031055','2025-09-26',' 18:00:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-XLBF-50-0' AND kode_barcode='00032939';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-XLBF-50-0','00032939','2025-09-26',' 18:01:34','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-26 18:03:41');
CREATE TABLE th_20250926_180341 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250926_180341_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-26 18:03:44');
CREATE TABLE th_20250926_180344 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250926_180344_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='KMK' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '18:03:52',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-YHAE-130-0' AND kode_barcode='00038172';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-YHAE-130-0','00038172','2025-09-26',' 18:04:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-UCBE-40' AND kode_barcode='00005330';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-UCBE-40','00005330','2025-09-26',' 18:04:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-UCBE-3' AND kode_barcode='00005284';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-UCBE-3','00005284','2025-09-26',' 18:04:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-UCBE-1' AND kode_barcode='00005282';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-UCBE-1','00005282','2025-09-26',' 18:04:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-PFAH-51-0' AND kode_barcode='00015337';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-PFAH-51-0','00015337','2025-09-26',' 18:04:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-TDXC-11' AND kode_barcode='A0000099';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-TDXC-11','A0000099','2025-09-26',' 18:04:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-UCBE-30' AND kode_barcode='00005320';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-UCBE-30','00005320','2025-09-26',' 18:05:07','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-TFAB-3' AND kode_barcode='00000753';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-TFAB-3','00000753','2025-09-26',' 18:05:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-UCBE-25' AND kode_barcode='00005315';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-UCBE-25','00005315','2025-09-26',' 18:05:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-PGAF-14-0' AND kode_barcode='00016141';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-PGAF-14-0','00016141','2025-09-26',' 18:05:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-UDAF-1' AND kode_barcode='00005879';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-UDAF-1','00005879','2025-09-26',' 18:05:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-VBAX-31-0' AND kode_barcode='00012474';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-VBAX-31-0','00012474','2025-09-26',' 18:05:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-UKAG-8-0' AND kode_barcode='00010406';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-UKAG-8-0','00010406','2025-09-26',' 18:06:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-PFAH-54-0' AND kode_barcode='00015340';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-PFAH-54-0','00015340','2025-09-26',' 18:06:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-UCBE-5' AND kode_barcode='00005286';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-UCBE-5','00005286','2025-09-26',' 18:06:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-UCBE-4' AND kode_barcode='00005285';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-UCBE-4','00005285','2025-09-26',' 18:06:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-XAAA-10-0' AND kode_barcode='00025770';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-XAAA-10-0','00025770','2025-09-26',' 18:06:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-VABF-34-0' AND kode_barcode='00012052';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-VABF-34-0','00012052','2025-09-26',' 18:07:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-TDXC-6' AND kode_barcode='A0000094';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-TDXC-6','A0000094','2025-09-26',' 18:07:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-PFAH-62-0' AND kode_barcode='00015348';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-PFAH-62-0','00015348','2025-09-26',' 18:07:14','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-26 18:09:17');
CREATE TABLE th_20250926_180917 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250926_180917_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-26 18:09:20');
CREATE TABLE th_20250926_180920 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250926_180920_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='KLD' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '18:09:31',input_by='kasir';
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='KLD' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '18:09:48',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TDXF-22' AND kode_barcode='A0000371';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TDXF-22','A0000371','2025-09-26',' 18:09:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TDXF-10' AND kode_barcode='A0000359';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TDXF-10','A0000359','2025-09-26',' 18:09:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-TDXF-3' AND kode_barcode='A0000375';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-TDXF-3','A0000375','2025-09-26',' 18:10:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TDXF-28' AND kode_barcode='A0000381';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TDXF-28','A0000381','2025-09-26',' 18:10:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TDXF-8' AND kode_barcode='A0000357';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TDXF-8','A0000357','2025-09-26',' 18:10:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TDXF-2' AND kode_barcode='A0000351';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TDXF-2','A0000351','2025-09-26',' 18:10:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TDXF-9' AND kode_barcode='A0000358';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TDXF-9','A0000358','2025-09-26',' 18:10:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TDXF-11' AND kode_barcode='A0000360';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TDXF-11','A0000360','2025-09-26',' 18:10:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TDXF-6' AND kode_barcode='A0000355';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TDXF-6','A0000355','2025-09-26',' 18:10:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TDXF-20' AND kode_barcode='A0000369';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TDXF-20','A0000369','2025-09-26',' 18:11:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TDXF-13' AND kode_barcode='A0000362';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TDXF-13','A0000362','2025-09-26',' 18:11:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TDXF-12' AND kode_barcode='A0000361';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TDXF-12','A0000361','2025-09-26',' 18:11:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KDRG-UCBE-3' AND kode_barcode='00005261';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KDRG-UCBE-3','00005261','2025-09-26',' 18:11:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TDXF-15' AND kode_barcode='A0000364';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TDXF-15','A0000364','2025-09-26',' 18:11:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-TDXF-4' AND kode_barcode='A0000376';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-TDXF-4','A0000376','2025-09-26',' 18:11:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TDXF-24' AND kode_barcode='A0000377';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TDXF-24','A0000377','2025-09-26',' 18:12:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TDXF-23' AND kode_barcode='A0000372';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TDXF-23','A0000372','2025-09-26',' 18:12:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMPN-TFBD-5' AND kode_barcode='00000442';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMPN-TFBD-5','00000442','2025-09-26',' 18:13:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KDRG-WAXD-5-0' AND kode_barcode='00019531';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KDRG-WAXD-5-0','00019531','2025-09-26',' 18:13:27','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KDRG-UCBE-7' AND kode_barcode='00005267';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KDRG-UCBE-7','00005267','2025-09-26',' 18:13:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KDK-UCBE-2' AND kode_barcode='00005336';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KDK-UCBE-2','00005336','2025-09-26',' 18:13:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KDK-UCBE-3' AND kode_barcode='00005337';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KDK-UCBE-3','00005337','2025-09-26',' 18:13:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KDK-UCBE-1' AND kode_barcode='00005335';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KDK-UCBE-1','00005335','2025-09-26',' 18:14:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KDK-UCBE-5' AND kode_barcode='00005339';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KDK-UCBE-5','00005339','2025-09-26',' 18:14:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMR-TJAI-1' AND kode_barcode='00001920';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMR-TJAI-1','00001920','2025-09-26',' 18:14:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TDXF-1' AND kode_barcode='A0000350';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TDXF-1','A0000350','2025-09-26',' 18:14:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMKN-TFBD-1' AND kode_barcode='00000437';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMKN-TFBD-1','00000437','2025-09-26',' 18:15:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMK-TDXF-2' AND kode_barcode='A0000374';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMK-TDXF-2','A0000374','2025-09-26',' 18:15:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KDRG-UCBE-5' AND kode_barcode='00005263';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KDRG-UCBE-5','00005263','2025-09-26',' 18:16:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMKN-TFBD-2' AND kode_barcode='00000438';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMKN-TFBD-2','00000438','2025-09-26',' 18:16:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TFBE-1' AND kode_barcode='00000951';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TFBE-1','00000951','2025-09-26',' 18:16:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KDRG-UCBE-1' AND kode_barcode='00005259';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KDRG-UCBE-1','00005259','2025-09-26',' 18:16:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KDRG-UCBE-8' AND kode_barcode='00005268';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KDRG-UCBE-8','00005268','2025-09-26',' 18:16:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KDRG-UCBE-10' AND kode_barcode='00005270';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KDRG-UCBE-10','00005270','2025-09-26',' 18:17:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KDRG-UCBE-4' AND kode_barcode='00005262';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KDRG-UCBE-4','00005262','2025-09-26',' 18:17:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMPN-TFBD-4' AND kode_barcode='00000440';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMPN-TFBD-4','00000440','2025-09-26',' 18:17:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TDXF-18' AND kode_barcode='A0000367';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TDXF-18','A0000367','2025-09-26',' 18:17:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TDXF-27' AND kode_barcode='A0000380';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TDXF-27','A0000380','2025-09-26',' 18:18:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TDXF-25' AND kode_barcode='A0000378';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TDXF-25','A0000378','2025-09-26',' 18:18:11','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-26 18:22:30');
CREATE TABLE th_20250926_182230 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250926_182230_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='KLP' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '18:22:42',input_by='kasir';
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='KLP' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '18:22:59',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='KPK-TDXF-3' AND kode_barcode='A0000346';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KPK-TDXF-3','A0000346','2025-09-26',' 18:23:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KPP-TDXC-4' AND kode_barcode='A0000081';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KPP-TDXC-4','A0000081','2025-09-26',' 18:23:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KPP-WLXH-18-0' AND kode_barcode='00025297';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KPP-WLXH-18-0','00025297','2025-09-26',' 18:23:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KLPP-XABC-37-0' AND kode_barcode='00026225';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KLPP-XABC-37-0','00026225','2025-09-26',' 18:23:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KMP-TGAG-2' AND kode_barcode='00001126';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KMP-TGAG-2','00001126','2025-09-26',' 18:23:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KPK-TDXF-4' AND kode_barcode='A0000347';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KPK-TDXF-4','A0000347','2025-09-26',' 18:23:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='KPK-TDXC-3' AND kode_barcode='A0000087';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('KPK-TDXC-3','A0000087','2025-09-26',' 18:23:39','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-26 18:25:20');
CREATE TABLE th_20250926_182520 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250926_182520_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='LM' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '18:25:28',input_by='kasir';
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='LM' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '18:26:07',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='LGM5-YIBC-36-0' AND kode_barcode='00038868';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LGM5-YIBC-36-0','00038868','2025-09-26',' 18:26:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LGM5-YIBC-34-0' AND kode_barcode='00038866';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LGM5-YIBC-34-0','00038866','2025-09-26',' 18:26:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LGM5-YIBC-37-0' AND kode_barcode='00038869';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LGM5-YIBC-37-0','00038869','2025-09-26',' 18:26:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LGM5-YIBC-38-0' AND kode_barcode='00038870';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LGM5-YIBC-38-0','00038870','2025-09-26',' 18:26:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LGM25-YIBC-39-0' AND kode_barcode='00038871';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LGM25-YIBC-39-0','00038871','2025-09-26',' 18:26:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LGM50-YIBC-33-0' AND kode_barcode='00038865';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LGM50-YIBC-33-0','00038865','2025-09-26',' 18:26:47','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-26 18:29:38');
CREATE TABLE th_20250926_182938 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250926_182938_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='LMP' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '18:29:52',input_by='kasir';
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='KMP' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '18:30:02',input_by='kasir';
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='LMP' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '18:30:56',input_by='kasir';
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='LMP' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '18:31:24',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBG-88-0' AND kode_barcode='00033048';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBG-88-0','00033048','2025-09-26',' 18:32:43','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBG-87-0' AND kode_barcode='00033047';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBG-87-0','00033047','2025-09-26',' 18:32:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-TDXD-6' AND kode_barcode='A0000137';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-TDXD-6','A0000137','2025-09-26',' 18:32:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBG-86-0' AND kode_barcode='00033046';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBG-86-0','00033046','2025-09-26',' 18:33:05','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-UCBF-20' AND kode_barcode='00005412';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-UCBF-20','00005412','2025-09-26',' 18:33:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBG-89-0' AND kode_barcode='00033049';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBG-89-0','00033049','2025-09-26',' 18:33:21','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-YCXE-108-0' AND kode_barcode='00034611';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-YCXE-108-0','00034611','2025-09-26',' 18:33:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XAAI-5-0' AND kode_barcode='00026028';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XAAI-5-0','00026028','2025-09-26',' 18:33:36','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBG-77-0' AND kode_barcode='00033037';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBG-77-0','00033037','2025-09-26',' 18:33:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XAAH-59-0' AND kode_barcode='00025982';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XAAH-59-0','00025982','2025-09-26',' 18:33:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-YCXE-103-0' AND kode_barcode='00034606';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-YCXE-103-0','00034606','2025-09-26',' 18:33:57','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-YCXE-101-0' AND kode_barcode='00034604';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-YCXE-101-0','00034604','2025-09-26',' 18:34:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-YCXE-102-0' AND kode_barcode='00034605';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-YCXE-102-0','00034605','2025-09-26',' 18:34:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-TDXD-16' AND kode_barcode='A0000147';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-TDXD-16','A0000147','2025-09-26',' 18:34:26','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-YCXE-104-0' AND kode_barcode='00034607';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-YCXE-104-0','00034607','2025-09-26',' 18:34:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-YCAX-3-0' AND kode_barcode='00034660';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-YCAX-3-0','00034660','2025-09-26',' 18:34:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBG-81-0' AND kode_barcode='00033041';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBG-81-0','00033041','2025-09-26',' 18:34:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XAAH-98-0' AND kode_barcode='00026021';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XAAH-98-0','00026021','2025-09-26',' 18:35:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-TLAD-1' AND kode_barcode='00002919';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-TLAD-1','00002919','2025-09-26',' 18:35:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-UCBF-10' AND kode_barcode='00005402';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-UCBF-10','00005402','2025-09-26',' 18:35:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XEBD-22-0' AND kode_barcode='00028608';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XEBD-22-0','00028608','2025-09-26',' 18:35:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-YCXE-105-0' AND kode_barcode='00034608';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-YCXE-105-0','00034608','2025-09-26',' 18:36:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-TDXD-27' AND kode_barcode='A0000158';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-TDXD-27','A0000158','2025-09-26',' 18:36:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMR-ULAD-41-0' AND kode_barcode='00010954';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMR-ULAD-41-0','00010954','2025-09-26',' 18:36:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-TDXD-35' AND kode_barcode='A0000166';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-TDXD-35','A0000166','2025-09-26',' 18:36:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMK-TDXD-20' AND kode_barcode='A0000189';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMK-TDXD-20','A0000189','2025-09-26',' 18:36:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-TDXD-39' AND kode_barcode='A0000236';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-TDXD-39','A0000236','2025-09-26',' 18:37:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-UCBF-11' AND kode_barcode='00005403';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-UCBF-11','00005403','2025-09-26',' 18:37:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-YCXE-106-0' AND kode_barcode='00034609';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-YCXE-106-0','00034609','2025-09-26',' 18:37:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-TDXD-15' AND kode_barcode='A0000146';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-TDXD-15','A0000146','2025-09-26',' 18:37:41','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-YBXD-9-0' AND kode_barcode='00033888';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-YBXD-9-0','00033888','2025-09-26',' 18:37:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMK-TDXD-23' AND kode_barcode='A0000192';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMK-TDXD-23','A0000192','2025-09-26',' 18:38:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-UDXF-7' AND kode_barcode='00005631';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-UDXF-7','00005631','2025-09-26',' 18:38:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-UDXF-12' AND kode_barcode='00005636';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-UDXF-12','00005636','2025-09-26',' 18:38:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-UDXF-1' AND kode_barcode='00005625';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-UDXF-1','00005625','2025-09-26',' 18:38:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMK-TDXD-24' AND kode_barcode='A0000193';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMK-TDXD-24','A0000193','2025-09-26',' 18:39:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMK-TDXD-21' AND kode_barcode='A0000190';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMK-TDXD-21','A0000190','2025-09-26',' 18:39:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMR-WKAG-11-0' AND kode_barcode='00024979';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMR-WKAG-11-0','00024979','2025-09-26',' 18:39:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-UDXF-3' AND kode_barcode='00005627';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-UDXF-3','00005627','2025-09-26',' 18:39:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMK-UCBF-19' AND kode_barcode='00005379';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMK-UCBF-19','00005379','2025-09-26',' 18:39:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XCXF-28-0' AND kode_barcode='00027173';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XCXF-28-0','00027173','2025-09-26',' 18:40:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMK-TDXD-8' AND kode_barcode='A0000177';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMK-TDXD-8','A0000177','2025-09-26',' 18:40:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-TDXD-29' AND kode_barcode='A0000160';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-TDXD-29','A0000160','2025-09-26',' 18:40:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-TDXD-10' AND kode_barcode='A0000141';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-TDXD-10','A0000141','2025-09-26',' 18:40:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBG-82-0' AND kode_barcode='00033042';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBG-82-0','00033042','2025-09-26',' 18:41:11','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-UDXF-6' AND kode_barcode='00005630';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-UDXF-6','00005630','2025-09-26',' 18:41:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-UCBF-15' AND kode_barcode='00005407';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-UCBF-15','00005407','2025-09-26',' 18:41:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMK-UCBF-24' AND kode_barcode='00005385';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMK-UCBF-24','00005385','2025-09-26',' 18:41:35','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-TDXD-28' AND kode_barcode='A0000159';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-TDXD-28','A0000159','2025-09-26',' 18:41:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-UDXF-9' AND kode_barcode='00005633';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-UDXF-9','00005633','2025-09-26',' 18:41:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMR-ULAD-40-0' AND kode_barcode='00010953';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMR-ULAD-40-0','00010953','2025-09-26',' 18:41:55','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-TDXD-30' AND kode_barcode='A0000161';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-TDXD-30','A0000161','2025-09-26',' 18:42:15','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMK-TDXD-17' AND kode_barcode='A0000186';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMK-TDXD-17','A0000186','2025-09-26',' 18:42:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XJXH-16-0' AND kode_barcode='00031648';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XJXH-16-0','00031648','2025-09-26',' 18:42:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMK-TDXD-30' AND kode_barcode='A0000199';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMK-TDXD-30','A0000199','2025-09-26',' 18:42:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-UDXF-10' AND kode_barcode='00005634';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-UDXF-10','00005634','2025-09-26',' 18:43:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-UDXF-5' AND kode_barcode='00005629';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-UDXF-5','00005629','2025-09-26',' 18:43:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMK-THBX-1' AND kode_barcode='00001358';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMK-THBX-1','00001358','2025-09-26',' 18:43:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMK-UHAH-8-0' AND kode_barcode='00008103';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMK-UHAH-8-0','00008103','2025-09-26',' 18:43:45','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMK-TDXD-25' AND kode_barcode='A0000194';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMK-TDXD-25','A0000194','2025-09-26',' 18:43:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-TDXD-22' AND kode_barcode='A0000153';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-TDXD-22','A0000153','2025-09-26',' 18:44:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMR-YCXE-109-0' AND kode_barcode='00034612';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMR-YCXE-109-0','00034612','2025-09-26',' 18:44:41','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XIXF-12-0' AND kode_barcode='00031132';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XIXF-12-0','00031132','2025-09-26',' 18:44:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMK-TDXD-28' AND kode_barcode='A0000197';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMK-TDXD-28','A0000197','2025-09-26',' 18:44:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-TDXD-17' AND kode_barcode='A0000148';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-TDXD-17','A0000148','2025-09-26',' 18:45:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-VAAG-35-0' AND kode_barcode='00011798';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-VAAG-35-0','00011798','2025-09-26',' 18:45:09','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-UDXF-11' AND kode_barcode='00005635';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-UDXF-11','00005635','2025-09-26',' 18:45:16','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-TDXD-37' AND kode_barcode='A0000168';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-TDXD-37','A0000168','2025-09-26',' 18:45:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XDXC-24-0' AND kode_barcode='00027952';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XDXC-24-0','00027952','2025-09-26',' 18:45:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBG-90-0' AND kode_barcode='00033050';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBG-90-0','00033050','2025-09-26',' 18:45:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XAAI-8-0' AND kode_barcode='00026031';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XAAI-8-0','00026031','2025-09-26',' 18:45:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBG-83-0' AND kode_barcode='00033043';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBG-83-0','00033043','2025-09-26',' 18:45:50','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-PHBF-4-0' AND kode_barcode='00016830';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-PHBF-4-0','00016830','2025-09-26',' 18:45:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-UDXF-2' AND kode_barcode='00005626';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-UDXF-2','00005626','2025-09-26',' 18:46:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMR-ULAD-42-0' AND kode_barcode='00010955';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMR-ULAD-42-0','00010955','2025-09-26',' 18:46:10','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-WIXF-12-0' AND kode_barcode='00023853';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-WIXF-12-0','00023853','2025-09-26',' 18:46:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMK-WJBF-12-0' AND kode_barcode='00024636';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMK-WJBF-12-0','00024636','2025-09-26',' 18:46:30','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMK-TDXD-14' AND kode_barcode='A0000183';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMK-TDXD-14','A0000183','2025-09-26',' 18:46:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-TDXD-5' AND kode_barcode='A0000136';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-TDXD-5','A0000136','2025-09-26',' 18:46:53','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-TDXD-3' AND kode_barcode='A0000134';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-TDXD-3','A0000134','2025-09-26',' 18:47:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBG-73-0' AND kode_barcode='00033033';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBG-73-0','00033033','2025-09-26',' 18:47:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBG-76-0' AND kode_barcode='00033036';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBG-76-0','00033036','2025-09-26',' 18:47:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBG-74-0' AND kode_barcode='00033034';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBG-74-0','00033034','2025-09-26',' 18:47:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBG-78-0' AND kode_barcode='00033038';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBG-78-0','00033038','2025-09-26',' 18:47:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBG-75-0' AND kode_barcode='00033035';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBG-75-0','00033035','2025-09-26',' 18:47:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBG-85-0' AND kode_barcode='00033045';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBG-85-0','00033045','2025-09-26',' 18:47:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBF-48-0' AND kode_barcode='00032937';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBF-48-0','00032937','2025-09-26',' 18:47:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBG-80-0' AND kode_barcode='00033040';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBG-80-0','00033040','2025-09-26',' 18:48:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBG-79-0' AND kode_barcode='00033039';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBG-79-0','00033039','2025-09-26',' 18:48:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBF-36-0' AND kode_barcode='00032925';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBF-36-0','00032925','2025-09-26',' 18:48:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBF-35-0' AND kode_barcode='00032924';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBF-35-0','00032924','2025-09-26',' 18:48:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBF-46-0' AND kode_barcode='00032935';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBF-46-0','00032935','2025-09-26',' 18:48:34','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBF-40-0' AND kode_barcode='00032929';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBF-40-0','00032929','2025-09-26',' 18:48:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBF-43-0' AND kode_barcode='00032932';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBF-43-0','00032932','2025-09-26',' 18:48:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBF-38-0' AND kode_barcode='00032927';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBF-38-0','00032927','2025-09-26',' 18:48:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBF-44-0' AND kode_barcode='00032933';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBF-44-0','00032933','2025-09-26',' 18:48:59','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBF-42-0' AND kode_barcode='00032931';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBF-42-0','00032931','2025-09-26',' 18:49:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBF-41-0' AND kode_barcode='00032930';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBF-41-0','00032930','2025-09-26',' 18:49:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBF-37-0' AND kode_barcode='00032926';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBF-37-0','00032926','2025-09-26',' 18:49:18','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBF-39-0' AND kode_barcode='00032928';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBF-39-0','00032928','2025-09-26',' 18:49:22','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='LMP-XLBF-45-0' AND kode_barcode='00032934';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMP-XLBF-45-0','00032934','2025-09-26',' 18:49:27','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-26 18:51:37');
CREATE TABLE th_20250926_185137 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250926_185137_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='LMK' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '18:51:48',input_by='kasir';
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='LMK' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '18:52:10',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='LMK-YHAE-131-0' AND kode_barcode='00038173';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('LMK-YHAE-131-0','00038173','2025-09-26',' 18:52:15','1','kasir');
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,potong_rp,keterangan) VALUES ('FE-250926-0003','kasir','1',' CBRE-02261','TOKO','CBR','CBRE-YIAG-19-0','CBRE-02261 GIA 1349539899 ','','1.900','1','75.00','9176000','5498000','333','16500','11500000','0','0','0','11500000','FIR','00038781','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-YIAG-19-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='2025-09-26' AND kode_barang='CBRE-YIAG-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' 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,no_persekot,dp_pesanan) VALUES ('FE-250926-0003','2025-09-26','1.900','2025-09-26','18:52:33','PLG0026968','11500000','11500000','0','11500000','0','kasir','2025-09-26 18:52:33','FE-250926-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-26','FE-250926-0003','2025-09-26','18:52:33','FIR','11500000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250926-0005','2025-09-26','2025-09-26 18:52:33','PENJUALAN : FE-250926-0003','.','TBC','11500000','11500000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-250926-0006','D','2025-09-26','18:52:33','TBC','PENJUALAN BERLIAN','FE-250926-0003','92239360220','11500000','92250860220','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='11500000' WHERE no_faktur_jual='FE-250926-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-250926-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-250926-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-250926-0003';
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-26 18:54:22');
CREATE TABLE th_20250926_185422 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250926_185422_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='CKPDE' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '18:54:36',input_by='kasir';
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='CKPDE' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '18:55:13',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='CKPDE-WFXE-26-0' AND kode_barcode='00022208';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPDE-WFXE-26-0','00022208','2025-09-26',' 18:55:17','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CKPDE-YGAF-2-0' AND kode_barcode='00037221';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPDE-YGAF-2-0','00037221','2025-09-26',' 18:55:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CKPDE-YHAE-104-' AND kode_barcode='00038146';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPDE-YHAE-104-','00038146','2025-09-26',' 18:55:24','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CKPDE-YEXI-10-0' AND kode_barcode='00035515';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPDE-YEXI-10-0','00035515','2025-09-26',' 18:55:33','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CKPDE-YEAC-7-0' AND kode_barcode='00035552';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPDE-YEAC-7-0','00035552','2025-09-26',' 18:55:37','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CKPDE-YHAE-103-' AND kode_barcode='00038145';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPDE-YHAE-103-','00038145','2025-09-26',' 18:55:49','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CKPDE-YEXI-12-0' AND kode_barcode='00035517';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPDE-YEXI-12-0','00035517','2025-09-26',' 18:56:05','1','kasir');
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='CKPDE' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '18:57:26',input_by='kasir';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-07761','FIR','1','CBR02261','RESIZE KE 14 5 CRUM FULL PUTIH HARGA KONFIRMASI','1.900','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-07761','2025-09-26','2025-09-26','18:59:03','PLG0026969','kasir','2025-09-30','kasir','2025-09-26 18:59:03','1.900','0','0','0','0','0','0','0','0');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-26 19:11:03');
CREATE TABLE th_20250926_191103 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250926_191103_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-26 19:11:11');
CREATE TABLE th_20250926_191111 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250926_191111_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='CMK' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '19:11:55',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TDXG-7' AND kode_barcode='A0000414';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TDXG-7','A0000414','2025-09-26',' 19:12:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-ULAF-17-0' AND kode_barcode='00011110';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-ULAF-17-0','00011110','2025-09-26',' 19:12:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-UCXH-20' AND kode_barcode='00004671';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-UCXH-20','00004671','2025-09-26',' 19:12:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-WKBA-8-0' AND kode_barcode='00025007';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-WKBA-8-0','00025007','2025-09-26',' 19:12:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TDXD-19' AND kode_barcode='A0000314';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TDXD-19','A0000314','2025-09-26',' 19:12:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TDXD-27' AND kode_barcode='A0000322';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TDXD-27','A0000322','2025-09-26',' 19:12:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TDXD-35' AND kode_barcode='A0000330';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TDXD-35','A0000330','2025-09-26',' 19:13:01','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TDXD-24' AND kode_barcode='A0000319';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TDXD-24','A0000319','2025-09-26',' 19:13:06','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TDXD-32' AND kode_barcode='A0000327';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TDXD-32','A0000327','2025-09-26',' 19:13:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-UCXH-43' AND kode_barcode='00004695';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-UCXH-43','00004695','2025-09-26',' 19:13:20','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-WLBG-10-0' AND kode_barcode='00025504';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-WLBG-10-0','00025504','2025-09-26',' 19:13:28','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TDXD-31' AND kode_barcode='A0000326';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TDXD-31','A0000326','2025-09-26',' 19:13:38','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-UCXH-42' AND kode_barcode='00004694';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-UCXH-42','00004694','2025-09-26',' 19:13:44','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-YHAE-120-0' AND kode_barcode='00038162';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-YHAE-120-0','00038162','2025-09-26',' 19:13:52','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-WHAI-11-0' AND kode_barcode='00023530';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-WHAI-11-0','00023530','2025-09-26',' 19:14:00','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TDXG-1' AND kode_barcode='A0000408';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TDXG-1','A0000408','2025-09-26',' 19:14:08','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-VLBA-38-0' AND kode_barcode='00019301';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-VLBA-38-0','00019301','2025-09-26',' 19:14:19','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-PHBG-19-0' AND kode_barcode='00016866';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-PHBG-19-0','00016866','2025-09-26',' 19:14:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TDXD-6' AND kode_barcode='A0000301';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TDXD-6','A0000301','2025-09-26',' 19:14:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-UCXH-13' AND kode_barcode='00004664';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-UCXH-13','00004664','2025-09-26',' 19:14:39','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TDXG-9' AND kode_barcode='A0000432';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TDXG-9','A0000432','2025-09-26',' 19:14:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TDXD-30' AND kode_barcode='A0000325';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TDXD-30','A0000325','2025-09-26',' 19:14:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TDXD-5' AND kode_barcode='A0000300';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TDXD-5','A0000300','2025-09-26',' 19:15:03','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TFBB-1' AND kode_barcode='00000884';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TFBB-1','00000884','2025-09-26',' 19:15:14','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-UFXG-1' AND kode_barcode='00006709';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-UFXG-1','00006709','2025-09-26',' 19:15:23','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TDXD-22' AND kode_barcode='A0000317';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TDXD-22','A0000317','2025-09-26',' 19:15:29','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-UCXH-16' AND kode_barcode='00004667';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-UCXH-16','00004667','2025-09-26',' 19:15:48','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TKAH-1' AND kode_barcode='00002420';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TKAH-1','00002420','2025-09-26',' 19:15:56','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-UCXH-44' AND kode_barcode='00004696';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-UCXH-44','00004696','2025-09-26',' 19:16:04','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TDXD-37' AND kode_barcode='A0000332';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TDXD-37','A0000332','2025-09-26',' 19:16:13','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-WFAF-9-0' AND kode_barcode='00022439';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-WFAF-9-0','00022439','2025-09-26',' 19:16:25','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-YGAE-37-0' AND kode_barcode='00037217';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-YGAE-37-0','00037217','2025-09-26',' 19:16:32','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-YEAC-19-0' AND kode_barcode='00035564';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-YEAC-19-0','00035564','2025-09-26',' 19:16:40','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TDXD-23' AND kode_barcode='A0000318';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TDXD-23','A0000318','2025-09-26',' 19:16:47','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-PFBG-38-0' AND kode_barcode='00015627';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-PFBG-38-0','00015627','2025-09-26',' 19:16:54','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TDXF-2' AND kode_barcode='A0000394';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TDXF-2','A0000394','2025-09-26',' 19:17:02','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TDXD-11' AND kode_barcode='A0000306';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TDXD-11','A0000306','2025-09-26',' 19:17:12','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TDXD-36' AND kode_barcode='A0000331';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TDXD-36','A0000331','2025-09-26',' 19:17:17','1','kasir');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2025-09-26 ','19:17:17');
DELETE FROM tt_barang_stock WHERE kode_barang='CMK-TDXD-1' AND kode_barcode='A0000296';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CMK-TDXD-1','A0000296','2025-09-26',' 19:17:25','1','kasir');
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-26 19:18:49');
CREATE TABLE th_20250926_191849 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250926_191849_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
INSERT INTO th_stock_kosong(user_id,input_date) VALUES ('kasir','2025-09-26 19:18:55');
CREATE TABLE th_20250926_191855 SELECT * FROM tt_barang_stock;
CREATE TABLE th_20250926_191855_lebih SELECT * FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock;
DELETE FROM tt_barang_stock_lebih;
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='CKPDE' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '19:20:37',input_by='kasir';
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='CKPDE' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '19:20:46',input_by='kasir';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2025-09-26 ','19:22:33');
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='CKPDE' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '19:23:29',input_by='Nagatech';
DELETE FROM tt_barang_stock WHERE kode_barang='CKPDE-YHAE-103-0' AND kode_barcode='00038145';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPDE-YHAE-103-0','00038145','2025-09-26',' 19:23:45','1','Nagatech');
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='CKPDE' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '19:25:19',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='CKPDE-YHAE-103-' AND kode_barcode='00038145';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPDE-YHAE-103-','00038145','2025-09-26',' 19:25:31','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CKPDE-YHAE-104-' AND kode_barcode='00038146';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPDE-YHAE-104-','00038146','2025-09-26',' 19:29:40','1','kasir');
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='CKPDE' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '19:30:46',input_by='kasir';
DELETE FROM tt_barang_stock WHERE kode_barang='CKPDE-YEXI-10-0' AND kode_barcode='00035515';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPDE-YEXI-10-0','00035515','2025-09-26',' 19:31:42','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CKPDE-YEXI-12-0' AND kode_barcode='00035517';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPDE-YEXI-12-0','00035517','2025-09-26',' 19:31:46','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CKPDE-WFXE-26-0' AND kode_barcode='00022208';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPDE-WFXE-26-0','00022208','2025-09-26',' 19:31:51','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CKPDE-YEAC-7-0' AND kode_barcode='00035552';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPDE-YEAC-7-0','00035552','2025-09-26',' 19:31:58','1','kasir');
DELETE FROM tt_barang_stock WHERE kode_barang='CKPDE-YGAF-2-0' AND kode_barcode='00037221';
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,tgl_taking,jam_taking,stock_fisik,input_by) VALUES('CKPDE-YGAF-2-0','00037221','2025-09-26',' 19:32:04','1','kasir');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-26 ','19:34:24');
DELETE FROM tt_barang_stock WHERE stock_fisik*1=0;
INSERT INTO tt_barang_stock(kode_barang,kode_barcode,stock_fisik) SELECT kode_barang,kode_barcode,stock_on_hand*0 FROM tm_barang WHERE kode_barang NOT IN (SELECT kode_barang FROM tt_barang_stock) AND kode_lokasi_toko ='CKPDE' AND stock_on_hand*1 =1 AND harga_jual*1 > 0;
UPDATE tt_barang_stock SET tgl_taking= '2025-09-26',jam_taking= '19:39:53',input_by='kasir';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-26 ','19:46:11');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-26 ','19:46:45');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2025-09-26 ','19:50:36');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2025-09-26 ','19:52:48');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2025-09-26 ','19:58:09');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-26 ','20:15:52');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-27','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-27';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-26';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-26';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-09-26' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-26';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-26';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-26';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-26';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-27' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-26' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
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-250927-0001','D','2025-09-27','20:16:03','TBC','SALDO AWAL','SALDO AWAL','0','92250860220','92250860220');
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-250927-0001','D','2025-09-27','20:16:03','BCK','SALDO AWAL','SALDO AWAL','0','15835984978.088','15835984978.088');
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-250927-0001','D','2025-09-27','20:16:03','KET','SALDO AWAL','SALDO AWAL','0','130069250','130069250');
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-250927-0001','D','2025-09-27','20:16:03','','SALDO AWAL','SALDO AWAL','0','13818500','13818500');
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-250927-0001','D','2025-09-27','20:16:03','BCD','SALDO AWAL','SALDO AWAL','0','14828019700','14828019700');
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-250927-0001','D','2025-09-27','20:16:03','SHO','SALDO AWAL','SALDO AWAL','0','2741005684','2741005684');
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-250927-0001','D','2025-09-27','20:16:03','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581');
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-250927-0001','D','2025-09-27','20:16:03','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450');
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-250927-0001','D','2025-09-27','20:16:03','6000000','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-250927-0001','D','2025-09-27','20:16:03','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000');
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-250927-0001','D','2025-09-27','20:16:03','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000');
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-250927-0001','D','2025-09-27','20:16:03','BCA','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-250927-0001','D','2025-09-27','20:16:03','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092');
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-250927-0001','D','2025-09-27','20:16:03','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000');
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-250927-0001','D','2025-09-27','20:16:03','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000');
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-250927-0001','D','2025-09-27','20:16:03','3450000','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-250927-0001','D','2025-09-27','20:16:03','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000');
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-250927-0001','D','2025-09-27','20:16:03','4000000','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-250927-0001','D','2025-09-27','20:16:03','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000');
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-250927-0001','D','2025-09-27','20:16:03','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000');
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-250927-0001','D','2025-09-27','20:16:03','BNI','SALDO AWAL','SALDO AWAL','0','79502900','79502900');
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-250927-0001','D','2025-09-27','20:16:03','TMR','SALDO AWAL','SALDO AWAL','0','8166083779','8166083779');
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-250927-0001','D','2025-09-27','20:16:03','DPE','SALDO AWAL','SALDO AWAL','0','285586800','285586800');
UPDATE tp_system SET tgl_system='2025-09-27';