public Modul_Penjualan_PembayaranPiutang(Modul_Penjualan_DaftarPiutang daftarPiutang, DataGridViewRow dgvRow)
{
/*kodesupplier
namasupplier
faktur
tanggal faktur
saldo hutang
*/
InitializeComponent();
this.daftarPiutang = daftarPiutang;
this.dgvRow = dgvRow;
fakturTxt.Text = dgvRow.Cells[2].Value.ToString();
kodeCustomerTextBox.Text = dgvRow.Cells[0].Value.ToString();
namaCustomerTextBox.Text = dgvRow.Cells[1].Value.ToString();
pembayaranTxt.Text = "0" ;
sisaPiutangTxt.Text = allfunc.digit_separated(dgvRow.Cells[3].Value.ToString());
SqlDataReader sdr = dbo.get_single_data(new string[]{"NO_Bukti","TJT"},"FAKTUR",dgvRow.Cells[2].Value.ToString()+"' AND LOWER(posisiperkiraan) = 'debit","piutang");
while(sdr.Read())
{
tJTDateTimePicker.Value = (DateTime)sdr["TJT"];
noBuktiTxt.Text = (string)sdr["NO_Bukti"];
}
DbObject db1 = new DbObject();
SqlDataReader sdr1 = db1.get_single_data(new string[] { "JumlahPenjualan" }, "nobon", fakturTxt.Text, "jual");
while (sdr1.Read())
{
nominalTextBox.Text = allfunc.digit_separated(Convert.ToString((double)sdr1["JumlahPenjualan"]));
}
if(sisaPiutangTxt.Text.CompareTo("0")==0)
{
bayarBtn.Enabled = false;
}
}
public Modul_Ganti_Operator_Laporan(Modul_POS pos,Modul_POS_Resep_Dokter resep, Login login)
{
InitializeComponent();
if (pos!=null)
{
this.pos = pos;
}
else if(resep !=null)
{
this.resep = resep;
}
this.login = login;
DbObject dbo = new DbObject();
SqlDataReader sdr = null;
namaOperatorTxt.Text = login.username;
SqlDataReader sdr0 = dbo.get_single_data(new string[]{"JamMulai"},"Username",login.username,"login");
while (sdr0.Read())
{
DateTime jamMulai = (DateTime)sdr0["JamMulai"];
jamMulaiDateTimePicker.Value = Convert.ToDateTime(jamMulai.ToString("HH:mm"));
}
jamSelesaiDateTimePicker.Value = Convert.ToDateTime(DateTime.Now.ToString("HH:mm"));
var timeDiff = new TimeSpan(jamSelesaiDateTimePicker.Value.Ticks - jamMulaiDateTimePicker.Value.Ticks);
lamaBertugasTxt.Text = timeDiff.Hours.ToString();
sdr = tbLogin.getPendapatanObat(DateTime.Today, login.username);
if (sdr.HasRows)
{
while ( sdr.Read())
{
if (sdr["JumlahOmset"]!=DBNull.Value)
{
setDataGrid(new string[] { (string)sdr["NamaKelompok"], allfunc.digit_separated(Convert.ToString((double)sdr["JumlahOmset"])) });
}
else
{
setDataGrid(new string[] { (string)sdr["NamaKelompok"], "0" });
}
}
}
SqlDataReader sdr1 = null;
sdr1 = tbLogin.getPendapatanJasa(DateTime.Today, login.username);
if (sdr1.HasRows)
{
while (sdr1.Read())
{
if (sdr1["JumlahOmset"] != DBNull.Value)
{
setDataGrid(new string[] { (string)sdr1["NamaKelompok"], allfunc.digit_separated(Convert.ToString((double)sdr1["JumlahOmset"])) });
}
else
{
setDataGrid(new string[] { (string)sdr1["NamaKelompok"], "0" });
}
}
}
SqlDataReader sdr2 = null;
sdr2 = tbLogin.getPendapatanResep(DateTime.Today, login.username);
if (sdr2.HasRows)
{
while (sdr2.Read())
{
if (sdr2["JumlahOmset"] != DBNull.Value)
{
setDataGrid(new string[] { (string)sdr2["NamaKelompok"], allfunc.digit_separated(Convert.ToString((double)sdr2["JumlahOmset"])) });
}
else
{
setDataGrid(new string[] { (string)sdr2["NamaKelompok"], "0" });
}
}
}
SqlDataReader sdr3 = null;
sdr3 = tbLogin.getPendapatanPiutang(DateTime.Today, login.username);
if (sdr3.HasRows)
{
while (sdr3.Read())
{
if (sdr3["JumlahOmset"] != DBNull.Value)
{
setDataGridPiutang(new string[] { (string)sdr3["NamaPelanggan"], allfunc.digit_separated(Convert.ToString((double)sdr3["JumlahOmset"])) });
}
else
{
setDataGridPiutang(new string[] { (string)sdr3["NamaPelanggan"], "0" });
}
}
}
SqlDataReader sdr4 = null;
sdr4 = tbLogin.getPendapatanAll(DateTime.Today, login.username);
if (sdr4.HasRows)
{
while (sdr4.Read())
{
if (sdr4["TotalOmset"] != DBNull.Value)
{
totalOmsetTxt.Text = allfunc.digit_separated(Convert.ToString((double)sdr4["TotalOmset"]));
}
else
{
totalOmsetTxt.Text = "0";
}
}
}
}
private void SimpanBtn_Click(object sender, EventArgs e)
{
/* SubObj, kas/Utang */
string kodePelanggan = kodePelangganTextBox.Text;
string noBon = noBonTextBox.Text;
SqlDataReader sdr = retJual.InsertRow(DateTime.Today, "", noBon, "",0, 0, 0, 0,"");//RetJual
string noBuktiRetur = "";
while (sdr.Read())
{
noBuktiRetur = (string)sdr["result"];
}
SqlDataReader sdr1 = ju.InsertRow(DateTime.Today, noBuktiRetur, "Retur Penjualan No.Bukti : " + noBuktiRetur); //JurnalUmum
string noBuktiJurnalUmum = "";
while (sdr1.Read())
{
noBuktiJurnalUmum = (string)sdr1["result"];
}
double subJurnalUmumGrandTotal = 0.0;
DataGridView dgv = null;
if (view_subJual_stockDataGridView.RowCount > 0)
{
dgv = view_subJual_stockDataGridView;
}
else if(view_racikan_stock_dokterDataGridView.RowCount >0)
{
dgv = view_racikan_stock_dokterDataGridView;
}
for (int i = 0; i < dgv.RowCount; i++)
{
string kodeStock = dgv.Rows[i].Cells[0].Value.ToString();
double qtyRetur = 0;
if (dgv.Rows[i].Cells[4].Value != null)
{
qtyRetur = Convert.ToDouble(dgv.Rows[i].Cells[4].Value.ToString());
}
string satuan = dgv.Rows[i].Cells[3].Value.ToString();
double hargaBeli = Convert.ToDouble(dgv.Rows[i].Cells[5].Value.ToString());
double discPers = Convert.ToDouble(dgv.Rows[i].Cells[6].Value.ToString());
if (qtyRetur > 0)
{
double subTotal = qtyRetur * hargaBeli;
double disc = subTotal * discPers / 100;
double ppn = 0;
//double ppn = (subTotal - disc) * ppnPers / 100;
double grandTotal = subTotal - disc + ppn;
retSubJual.InsertRow(noBuktiRetur, (float)qtyRetur, kodeStock, (float)hargaBeli, (float)discPers, (float)disc, (float)subTotal, (float)grandTotal);
stock.TambahJumlah(kodeStock, (float)qtyRetur);//stock
subJurnalUmumGrandTotal += grandTotal;
}
}
if (subJurnalUmumGrandTotal == 0)
{
retJual.DeleteRow(noBuktiRetur);
ju.DeleteRow(noBuktiJurnalUmum);
MessageBox.Show("Pencatatan Retur Gagal.");
}
else
{
sju.setDebitSystem(noBuktiJurnalUmum, "11311", "Persediaan Barang Dagang", (float)subJurnalUmumGrandTotal);
//kas atau piutang
if (pembayaranComboBox.Text.ToLower().CompareTo("t") == 0)
{
sju.setKreditSystem(noBuktiJurnalUmum, "11111", "Kas Keluar Retur Penjualan : " + noBuktiRetur, (float)subJurnalUmumGrandTotal);
kas.InsertRowKredit(DateTime.Today, noBuktiRetur, "Kas Keluar Retur Penjualan : " + noBuktiRetur, (float)subJurnalUmumGrandTotal);
}
else
{
DbObject dbo = new DbObject();
SqlDataReader sdr2 = dbo.get_single_data(new string[] { "Saldo" }, "FAKTUR", noBon, "view_piutang_faktur");
double saldoPiutangFaktur = 0;
while (sdr2.Read())
{
saldoPiutangFaktur = (double)sdr2["Saldo"];
}
if (saldoPiutangFaktur == 0)
{
sju.setKreditSystem(noBuktiJurnalUmum, "11111", "Kas Keluar Retur Penjualan : " + noBuktiRetur, (float)subJurnalUmumGrandTotal);
kas.InsertRowKredit(DateTime.Today, noBuktiRetur, "Kas Keluar Retur Penjualan : " + noBuktiRetur, (float)subJurnalUmumGrandTotal);
}
else
{
sju.setKreditSystem(noBuktiJurnalUmum, "11211", "Piutang Usaha", (float)subJurnalUmumGrandTotal);
piutang.InsertRowKredit(DateTime.Today, noBon, kodePelanggan, "TOKO", "TOKO", 0, (float)(subJurnalUmumGrandTotal * -1), DateTime.Today, "", 0);
}
}
MessageBox.Show("Pencatatan Retur Berhasil.");
refreshDataGrid();
tabControl1.SelectedIndex = 2;
}
}
private void stockSelectedHandler()
{
String kodeStock = stockDataGridView.Rows[stockDataGridView.CurrentCell.RowIndex].Cells[0].Value.ToString();
String namaStock = stockDataGridView.Rows[stockDataGridView.CurrentCell.RowIndex].Cells[1].Value.ToString();
String satuan = stockDataGridView.Rows[stockDataGridView.CurrentCell.RowIndex].Cells[2].Value.ToString();
//String jmlStockLama = stockDataGridView.Rows[stockDataGridView.CurrentCell.RowIndex].Cells[3].Value.ToString();
//String hargaStockLama = stockDataGridView.Rows[stockDataGridView.CurrentCell.RowIndex].Cells[4].Value.ToString();
String barcode = stockDataGridView.Rows[stockDataGridView.CurrentCell.RowIndex].Cells[16].Value.ToString();
String hargaBeli = stockDataGridView.Rows[stockDataGridView.CurrentCell.RowIndex].Cells[3].Value.ToString();
String jmlStockLama = "";
String hargaStockLama = "";
String[] row = new String[] { kodeStock, namaStock, "", satuan,jmlStockLama,hargaStockLama };
if (formBarangPemindahan != null)
{
String[] row1 = new String[] { barcode ,kodeStock, namaStock, "0",satuan };
this.formBarangPemindahan.mutasiStockdataGridView.Rows.Add(row1);
}
else if (inputBarangPopup !=null )
{
this.inputBarangPopup.setForm(row);
}
else if(modulPO != null)
{
row = new String[] { kodeStock, namaStock, satuan, hargaBeli };
this.modulPO.setItemDataGrid(row);
}
else if (modulPOS != null)
{
String hargaJual1 = stockDataGridView.Rows[stockDataGridView.CurrentCell.RowIndex].Cells[6].Value.ToString();
String hargaJual2 = stockDataGridView.Rows[stockDataGridView.CurrentCell.RowIndex].Cells[7].Value.ToString();
String hargaJual3 = stockDataGridView.Rows[stockDataGridView.CurrentCell.RowIndex].Cells[8].Value.ToString();
String jumlahStock = stockDataGridView.Rows[stockDataGridView.CurrentCell.RowIndex].Cells[3].Value.ToString();
String[] item = new String[] {kodeStock,namaStock,satuan,hargaJual1,hargaJual2,hargaJual3,jumlahStock};
modulPOS.setItem(item);
}
else if (modulPOSResepDokter != null)
{
String hargaJual1 = stockDataGridView.Rows[stockDataGridView.CurrentCell.RowIndex].Cells[6].Value.ToString();
String hargaJual2 = stockDataGridView.Rows[stockDataGridView.CurrentCell.RowIndex].Cells[7].Value.ToString();
String hargaJual3 = stockDataGridView.Rows[stockDataGridView.CurrentCell.RowIndex].Cells[8].Value.ToString();
String jumlahStock = stockDataGridView.Rows[stockDataGridView.CurrentCell.RowIndex].Cells[3].Value.ToString();
String[] item = new String[] { kodeStock, namaStock, satuan, hargaJual1, hargaJual2, hargaJual3, jumlahStock };
modulPOSResepDokter.setItem(item);
}
else if(modulSO != null)
{
DbObject dbo = new DbObject();
SqlDataReader sdr = dbo.get_single_data(new String[] { "saldo_akhir" }, "KodeStock", kodeStock, "view_saldo_stock_akhir");
while (sdr.Read())
{
row = new String[] { barcode, kodeStock, namaStock, ((double)sdr["saldo_akhir"]).ToString(),"0", satuan };
this.modulSO.setItemDataGrid(row);
}
}
close();
}
private void SimpanBtn_Click(object sender, EventArgs e)
{
/* SubObj, kas/Utang */
string kodeSupplier = kodeSupplierTextBox.Text;
string noSJ = nomorFakturTextBox.Text;
SqlDataReader sdr = retBeli.InsertRow(DateTime.Today,kodeSupplier,noSJ,0,0,0,0); //RetBeli
string noBuktiRetur = "";
while(sdr.Read())
{
noBuktiRetur = (string)sdr["result"];
}
SqlDataReader sdr1 = ju.InsertRow(DateTime.Today, noBuktiRetur, "Retur Pembelian No.Bukti : " + noBuktiRetur); //JurnalUmum
string noBuktiJurnalUmum = "";
while (sdr1.Read())
{
noBuktiJurnalUmum = (string)sdr1["result"];
}
double subJurnalUmumGrandTotal = 0.0;
for (int i = 0; i < itemStockDataGridView.RowCount;i++ )
{
string kodeStock = itemStockDataGridView.Rows[i].Cells[0].Value.ToString();
double qtyRetur = 0;
if (itemStockDataGridView.Rows[i].Cells[4].Value != null)
{
qtyRetur = Convert.ToDouble(itemStockDataGridView.Rows[i].Cells[4].Value.ToString());
}
string satuan = itemStockDataGridView.Rows[i].Cells[3].Value.ToString();
double hargaBeli = Convert.ToDouble(itemStockDataGridView.Rows[i].Cells[5].Value.ToString());
double discPers = Convert.ToDouble(itemStockDataGridView.Rows[i].Cells[7].Value.ToString());
double ppnPers = Convert.ToDouble(itemStockDataGridView.Rows[i].Cells[9].Value.ToString());
double pembulatan = Convert.ToDouble(itemStockDataGridView.Rows[i].Cells[11].Value.ToString());
//double = Convert.ToDouble(itemStockDataGridView.Rows[i].Cells[5].Value.ToString());
if(qtyRetur > 0)
{
double subTotal = qtyRetur * hargaBeli;
double disc = subTotal * discPers/100;
double ppn = (subTotal - disc)*ppnPers/100;
double grandTotal = subTotal - disc + ppn;
retSubBeli.InsertRow(noBuktiRetur,(float)qtyRetur, satuan, kodeStock, (float)hargaBeli, (float)discPers, (float)disc, (float)subTotal, (float)grandTotal);//retsubbeli
//stock.UpdateJumlahTerjual(kodeStock, (float)qtyRetur, "-");//stock
subJurnalUmumGrandTotal += grandTotal;
}
}
if (subJurnalUmumGrandTotal == 0)
{
retBeli.DeleteRow(noBuktiRetur);
ju.DeleteRow(noBuktiJurnalUmum);
MessageBox.Show("Pencatatan Retur Gagal.");
}
else
{
sju.setKreditSystem(noBuktiJurnalUmum, "11311", "Persediaan Barang Dagang", (float)subJurnalUmumGrandTotal);
//kas atau piutang
if (statusPembelianComboBox.Text.ToLower().CompareTo("t") == 0)
{
sju.setDebitSystem(noBuktiJurnalUmum, "11111", "Kas Masuk Retur Pembelian : " + noBuktiRetur, (float)subJurnalUmumGrandTotal);
kas.InsertRowDebit(DateTime.Today, noBuktiRetur, "Kas Masuk Retur Pembelian : " + noBuktiRetur, (float)subJurnalUmumGrandTotal);
}
else
{
DbObject dbo = new DbObject();
SqlDataReader sdr2 = dbo.get_single_data(new string[] { "Saldo" }, "Faktur", noSJ, "View_Utang_all");
double saldoUtangFaktur = 0;
while (sdr2.Read())
{
saldoUtangFaktur = (double)sdr2["Saldo"];
}
if (saldoUtangFaktur == 0)
{
sju.setDebitSystem(noBuktiJurnalUmum, "11111", "Kas Masuk Retur Pembelian : " + noBuktiRetur, (float)subJurnalUmumGrandTotal);
kas.InsertRowDebit(DateTime.Today, noBuktiRetur, "Kas Masuk Retur Pembelian : " + noBuktiRetur, (float)subJurnalUmumGrandTotal);
}
else
{
sju.setDebitSystem(noBuktiJurnalUmum, "21111", "Utang Usaha", (float)subJurnalUmumGrandTotal);
utang.InsertRowDebit(DateTime.Today, noBuktiRetur, kodeSupplier, (float)(subJurnalUmumGrandTotal * -1), 0, DateTime.Today, "Retur Pembelian", tglTransaksiDateTimePicker.Value);
}
}
MessageBox.Show("Pencatatan Retur Berhasil.");
print_laporan(noBuktiRetur);
refreshDataGrid();
tabControl1.SelectedIndex = 2;
}
}
