1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / digma /
Filename : .psql_history
back
select * from tb_penyimpanan_tokos where id = 52;
update tb_penyimpanan_tokos set jumlah = 5 where id = 52;
update m_gudang set nama_gudang = 'Etalase SDS' where id = 87;
update m_gudangs set nama_gudang = 'Etalase SDS' where id = 87;
select * from m_barangs where deleted_at is not null;
delete from m_barangs where id in (select id from m_barangs where deleted_at is not null);
delete from tb_penerimaans;
delete from m_barangs where id in (select id from m_barangs where deleted_at is not null);
select * from m_penerimaans where penerimaan_id = 101;
select * from m_barangs order by id desc limit 4;
select id, nama, kode from m_barangs order by id desc limit 4;
select * from m_penerimaans where penerimaan_id = 101;
select * from m_penerimaans where penerimaan_id = 102;
select * from m_barangs where deleted_at not null;
select * from m_barangs where deleted_at is not null;
delete from m_barangs where deleted_at is not null;
select id, email, karyawan_id from users where email = 'mitra@gmail.com';
update users set karyawan_id = 92 where id = 241;
select id, nama, kode from m_barangs order by id limit 10;
select id, nama, kode from m_barangs order by id desc limit 10;
select id, nama, kode from m_barangs order by id desc limit 20;
select id, nama, kode from m_barangs order by id desc limit 30;
delete from m_barangs where id between 2035 and 2093;
delete from tb_penerimaans;
delete from m_barangs where id between 2035 and 2093;
delete from tb_penerimaans;
select id, nama, kode from m_barangs order by id desc limit 30;
delete from m_barangs where id between 2094 and 2095;
update tb_penyimpanan_tokos set jumlah = 1 where id in (430,431);
select tanggal_cetak_faktur from tb_transaksis where tanggal_cetak_faktur is not null;
update tb_transaksis set tanggal_cetak_faktur = '2025-05-24 17:49:26' where id = 378;
delete from tb_transaksis;
delete from tb_penyimpanan_tokos;
delete from tb_barang_hilang_tokos;
delete from tb_penyimpanan_tokos;
delete from tb_barang_rusak_tokos;
delete from tb_penyimpanan_tokos;
delete from m_barangs;
delete from tb_penerimaans;
delete from m_barangs;
select id from tb_transaksis where no_invoice = 'SDS-K/250526/001';
select opsi_pengambilan, dipotong_outlet from tb_transaksi_pembayarans where transaksi_id = 382;
select opsi_pengambilan, dipotong_outlet from tb_transaksi_konsumen_infos where transaksi_id = 382;
select id,opsi_pengambilan, dipotong_outlet from tb_transaksi_konsumen_infos where transaksi_id = 382;
update tb_transaksi_konsumen_infos set opsi_pengambilan = 'diambil' where id = 190;
update tb_transaksi_konsumen_infos set dipotong_outlet = true where id = 190;
select * from m_tipe_konsumens;
delete from m_tipe_konsumens where id = 7;
select id, nominal, metode_bayar, keterangan from tb_transaksi_pembayarans where id = 205;
update tb_transaksi_pembayarans set keterangan = 'BCA' where id = 205;
select id, jumlah from tb_penyimpanan_tokos where id = 447;
select id, jumlah from tb_penyimpanan_tokos where id = 447;
select id, jumlah from tb_penyimpanan_tokos where id = 447;
select * from tb_penyimpanan_tokos where id = 447;
update tb_transaksis set status = 1 where id = 384;
select * from tb_penyimpanan_tokos where id = 447;
select COUNT(id) from tb_transaksis where kasir_id = 80;
\dt
\l
\q
\dr
\dt
\q
SELECT * FROM tb_po_rincian_barangs;
SELECT * FROM tb_po_membership;
SELECT * FROM tb_po_memberships;;
\q
\q
INSERT INTO TbSetPeriodeTanggal (hari, bulan, tahun)VALUES ('Sabtu', 8, '2025');
INSERT INTO tb_set_periode_tanggal (hari, bulan, tahun)VALUES ('Sabtu', 8, '2025');
INSERT INTO tb_set_periode_tanggal (hari, bulan, tahun)VALUES ('Sabtu', 8, '2025');
INSERT INTO tb_set_periode_tanggals (hari, bulan, tahun)VALUES ('Sabtu', 8, '2025');
update tb_po_payments set status = 'settlement' where order_id = 'BLJ-110825-3684';
update tb_po_payments set status = 'settlement' where order_id = 'BLJ-110825-7148';
update tb_po_payments set status = 'pending' where order_id = 'BLJ-110825-3684';
update tb_po_payments set status = 'pending' where order_id = 'BLJ-110825-7148';
select metadata
select order_id from tb_po_payments where metadata not null order by id desc;
select order_id from tb_po_payments where metadata is not null order by id desc;
select nama from m_barangs where id = 223;
select nama from m_barangs where id = 1845;
update m_barangs set nama = 'Agung Pratama' where id = 1835;
update m_barangs set nama = 'Agung Pratama' where id = 1845;