protected void Report()
{
lblHeader.Text = Mi.Pt
+ "<br />"
+ "Laporan Kasir NUP"
;
System.Text.StringBuilder x = new System.Text.StringBuilder();
DateTime Tanggal1 = Db.SingleTime("SELECT FilterDari FROM " + Mi.DbPrefix + "MARKETINGJUAL..LapPDF WHERE AttachmentID = '" + AttachmentID + "'");
DateTime Tanggal2 = Db.SingleTime("SELECT FilterSampai FROM " + Mi.DbPrefix + "MARKETINGJUAL..LapPDF WHERE AttachmentID = '" + AttachmentID + "'");
x.Append("<br />Untuk tanggal : " + Cf.Day(Tanggal1) + " s/d " + Cf.Day(Tanggal2));
x.Append("<br />Untuk Project : " + Cf.Str(Project));
x.Append("<br />Untuk Kasir : " + Cf.Str(Kasir));
x.Append("<br /><span style='font-weight: normal;'>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today)
+ ", " + Cf.Date(DateTime.Now)
+ " dari workstation : " + Act.IP
+ " dan username : "******"</span>"
);
lblSubHeader.Text = x.ToString();
Fill();
}
private void Report()
{
param.Visible = false;
rpt.Visible = true;
lblHeader.Text = Mi.Pt
+ "<br />"
+ "Laporan NUP"
;
System.Text.StringBuilder x = new System.Text.StringBuilder();
string addStr = "Semua Admin";
string addStrTipe = "Semua Tipe";
if (admin.SelectedIndex != 0)
{
addStr = Db.SingleString("SELECT Nama FROM ISC064_SECURITY..USERNAME WHERE UserID='" + admin.SelectedValue + "'");
}
x.Append("<br />Untuk tanggal : " + Cf.Day(tglawal.Text) + " s/d " + Cf.Day(tglakhir.Text));
x.Append("<br />Untuk Admin : " + Cf.Str(addStr));
x.Append("<br />Untuk Tipe : " + Cf.Str(addStrTipe));
x.Append("<br /><span style='font-weight: normal;'>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today)
+ ", " + Cf.Date(DateTime.Now)
+ " dari workstation : " + Act.IP
+ " dan username : "******"</span>"
);
lblSubHeader.Text = x.ToString();
Fill();
}
protected void Report()
{
lblHeader.Text = Mi.Pt
+ "<br />"
+ "Laporan NUP"
;
System.Text.StringBuilder x = new System.Text.StringBuilder();
DateTime Tanggal1 = Db.SingleTime("SELECT FilterDari FROM " + Mi.DbPrefix + "MARKETINGJUAL..LapPDF WHERE AttachmentID = '" + AttachmentID + "'");
DateTime Tanggal2 = Db.SingleTime("SELECT FilterSampai FROM " + Mi.DbPrefix + "MARKETINGJUAL..LapPDF WHERE AttachmentID = '" + AttachmentID + "'");
string addStr = "Semua Admin";
if (Admin != "SEMUA")
{
addStr = Db.SingleString("SELECT Nama FROM ISC064_SECURITY..USERNAME WHERE UserID='" + Admin + "'");
}
x.Append("<br />Untuk tanggal : " + Cf.Day(Tanggal1) + " s/d " + Cf.Day(Tanggal2));
x.Append("<br />Untuk Project : " + Cf.Str(Project));
x.Append("<br />Untuk Admin : " + Cf.Str(addStr));
x.Append("<br />Untuk Tipe : " + Tipe);
x.Append("<br /><span style='font-weight: normal;'>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today)
+ ", " + Cf.Date(DateTime.Now)
+ " dari workstation : " + Act.IP
+ " dan username : "******"</span>"
);
lblSubHeader.Text = x.ToString();
Fill();
}
private void Fill()
{
btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=REF_KOMISI_OVER_LOG&Pk=" + SN + "'";
btndel.Attributes["onclick"] = "location.href='KomisiOverDel.aspx?SN=" + SN + "'";
overpro.Attributes["onfocus"] = "tempnum=CalcFocus(this);";
overpro.Attributes["onkeyup"] = "CalcType(this,tempnum);";
overpro.Attributes["onblur"] = "CalcBlur(this);";
overcross.Attributes["onfocus"] = "tempnum=CalcFocus(this);";
overcross.Attributes["onkeyup"] = "CalcType(this,tempnum);";
overcross.Attributes["onblur"] = "CalcBlur(this);";
string strSql = "SELECT * FROM REF_KOMISI_OVER WHERE SN = " + SN;
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else
{
jabatan.Text = rs.Rows[0]["Jabatan"].ToString();
overpro.Text = Cf.Num(rs.Rows[0]["Project"]);
overcross.Text = Cf.Num(rs.Rows[0]["CrossSelling"]);
tglInput.Text = Cf.Date(rs.Rows[0]["TglInput"]);
tglEdit.Text = Cf.Date(rs.Rows[0]["TglEdit"]);
}
}
private void Report()
{
param.Visible = false;
rpt.Visible = true;
lblHeader.Text = Mi.Pt
+ "<br />"
+ "Laporan Outstanding Tagihan"
+ "<br />"
+ "Per " + Cf.Day(tgl.Text)
;
System.Text.StringBuilder x = new System.Text.StringBuilder();
if (ddlAgent.SelectedIndex != 0)
{
x.Append("Sales: " + ddlAgent.SelectedValue);
}
else
{
x.Append("Sales: SEMUA");
}
string strPrincipal = "SEMUA";
System.Text.StringBuilder z = new System.Text.StringBuilder();
bool isFirst = true;
for (int i = 0; i < cblPrincipal.Items.Count; i++)
{
if (cblPrincipal.Items[i].Selected)
{
if (isFirst)
{
z.Append(cblPrincipal.Items[i].Text);
isFirst = false;
}
else
{
z.Append("," + cblPrincipal.Items[i].Text);
}
}
}
if (z.ToString() != "")
{
strPrincipal = z.ToString();
}
x.Append("<br />Principal: " + strPrincipal);
x.Append("<br /><span style='font-weight: normal;'>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today)
+ ", " + Cf.Date(DateTime.Now)
+ " dari workstation : " + Act.IP
+ " dan username : "******"</span>"
);
lblSubHeader.Text = x.ToString();
Fill();
}
private void Report2()
{
param.Visible = false;
rpt.Visible = true;
string tgl = "";
if (tglinput.Checked)
{
tgl = tglinput.Text;
}
DateTime Dari = Convert.ToDateTime(dari.Text);
DateTime Sampai = Convert.ToDateTime(sampai.Text);
lblHeader.Text = Mi.Pt
+ "<br />"
+ "Laporan Kasir NUP"
+ "<br />"
+ tgl + " : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text)
;
System.Text.StringBuilder x = new System.Text.StringBuilder();
x.Append("<br /><span style='font-weight: normal;'>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today)
+ ", " + Cf.Date(DateTime.Now)
+ " dari workstation : " + Act.IP
+ " dan username : "******"</span>"
);
lblSubHeader.Text = x.ToString();
Fill();
}
private void Fill()
{
string Project = Db.SingleString("SELECT Project FROM MS_UNIT WHERE NoStock = '" + NoStock + "'");
cancel.Attributes["onclick"] = "location.href = 'ReservasiDaftar2.aspx?NoStock=" + NoStock + "'";
btnbaru.Attributes["onclick"] = "location.href = 'CustomerDaftar.aspx?NoStock=" + NoStock + "&reserve=1&project=" + Project + "'";
DataTable rs = Db.Rs("SELECT Luas, LuasSG, LuasNett, PriceList, NoUnit, Lokasi FROM MS_UNIT WHERE NoStock = '" + NoStock + "'");
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else
{
nounit.Text = "<a href=\"javascript:popUnit('" + NoStock + "')\">"
+ rs.Rows[0]["NoUnit"].ToString() + "</a>";
luasbangunan.Text = Cf.Num(rs.Rows[0]["LuasNett"]);
luastanah.Text = Cf.Num(rs.Rows[0]["LuasSG"]);
pl.Text = Cf.Num(rs.Rows[0]["PriceList"]);
tgl.Text = Cf.Day(DateTime.Today);
string ParamID = "BatasReservasi";// + Project;
string ParamReserve = Db.SingleString("SELECT VALUE FROM " + Mi.DbPrefix + "SECURITY..REF_PARAM WHERE ParamID = '" + ParamID + "'");
if (!String.IsNullOrEmpty(ParamReserve))
{
string[] value = ParamReserve.Split(';');
int jarak = Convert.ToInt16(value[0]);
switch (value[1])
{
case "1": batas.Text = Cf.Date(DateTime.Now.AddMinutes(+jarak)); break;
case "2": batas.Text = Cf.Date(DateTime.Now.AddHours(+jarak)); break;
case "3": batas.Text = Cf.Date(DateTime.Now.AddDays(+jarak)); break;
default: batas.Text = Cf.Date(DateTime.Now.AddMinutes(+jarak)); break;
}
}
else
{
ok.Enabled = false;
batasc.Text = "Parameter batas reservasi belum ada. Silahkan hubungi admin terkait.";
}
}
lokasi.Items.Add(new ListItem("-"));
DataTable rs2 = Db.Rs("SELECT * FROM REF_LOKASI_KONTRAK WHERE Project = '" + Project + "' ORDER BY SN");
for (int i = 0; i < rs2.Rows.Count; i++)
{
lokasi.Items.Add(new ListItem(rs2.Rows[i]["Nama"].ToString(), rs2.Rows[i]["SN"].ToString()));
}
//string Lokasi = Db.SingleString("SELECT Nama FROM REF_LOKASI WHERE Lokasi = '" + rs.Rows[0]["Lokasi"].ToString() + "' AND Project = '" + Project + "'");
//lokasi.SelectedValue = Lokasi;
}
private void Fill()
{
string strSql = "SELECT *"
+ " FROM MS_RESERVASI_OBS"
+ " WHERE Reminder = 0"
+ " ORDER BY NoObs";
DataTable rs = Db.Rs(strSql);
Rpt.NoData(rpt, rs, "Reminder untuk topik diatas masih kosong.");
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
c = new TableCell();
c.Text = rs.Rows[i]["NoObs"].ToString().PadLeft(5, '0');
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NoUnit"].ToString()
+ "<br /><i>NUP: " + rs.Rows[i]["NoQueue"].ToString() + "</i>"
+ "<br /><strong><font style='font-size: 15pt;'>" + rs.Rows[i]["NoUrut"].ToString() + "</font></strong>"
;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Str(rs.Rows[i]["Customer"])
+ "<br />" + Cf.Str(rs.Rows[i]["Agent"])
;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Date(rs.Rows[i]["Tgl"])
+ "<br />" + Cf.Date(rs.Rows[i]["TglExpire"])
;
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Str(rs.Rows[i]["Skema"])
+ "<br />" + Cf.Num(rs.Rows[i]["Netto"])
;
r.Cells.Add(c);
c = new TableCell();
c.Text = "<a href='ReminderObsProses.aspx?NoObs=" + Cf.Pk(rs.Rows[i]["NoObs"]) + "' onclick=\"javascript:return confirm('Anda yakin ingin follow up?');\" />Follow up...</a>";
r.Cells.Add(c);
Rpt.Border(r);
rpt.Rows.Add(r);
}
}
private void FillRsv()
{
string strSql = "SELECT "
+ " NoUrut"
+ ",Tgl"
+ ",MS_CUSTOMER.Nama AS Cs"
+ ",NoUnit"
+ ",MS_RESERVASI.Status"
+ ",NoReservasi"
+ ",MS_RESERVASI.TglExpire"
+ " FROM MS_RESERVASI INNER JOIN MS_CUSTOMER ON MS_RESERVASI.NoCustomer = MS_CUSTOMER.NoCustomer"
+ " WHERE NoAgent = " + NoAgent
+ " ORDER BY NoUrut";
DataTable rs = Db.Rs(strSql);
for (int i = 0; i < rs.Rows.Count; i++)
{
if (!Response.IsClientConnected)
{
break;
}
TableRow r = new TableRow();
TableCell c;
c = new TableCell();
c.Text = rs.Rows[i]["NoReservasi"].ToString().PadLeft(5, '0');
c.Wrap = false;
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Status"].ToString();
r.Cells.Add(c);
c = new TableCell();
c.Text = Cf.Day(rs.Rows[i]["Tgl"]);
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["Cs"].ToString();
r.Cells.Add(c);
c = new TableCell();
c.Text = rs.Rows[i]["NoUnit"].ToString();
r.Cells.Add(c);
c = new TableCell();
c.Text = "W.List : " + rs.Rows[i]["NoUrut"]
+ ", " + Cf.Date(rs.Rows[i]["TglExpire"]);
c.Wrap = false;
r.Cells.Add(c);
Rpt.Border(r);
rpt.Rows.Add(r);
}
}
private void Report()
{
param.Visible = false;
rpt.Visible = true;
rptTotal.Visible = true;
lblHeader.Text = Mi.Pt
+ "<br />"
+ "Laporan Hasil Launching NUP"
;
System.Text.StringBuilder x = new System.Text.StringBuilder();
string addStrAktivasi = "Semua";
string addStrStatus = "Semua";
string addStrProject = "Semua Project";
//aktivasi
if (aktivasi.SelectedIndex == 1)
{
addStrAktivasi = " Aktif";
}
else if (aktivasi.SelectedIndex == 2)
{
addStrAktivasi = " Non Aktif";
}
//status
if (status.SelectedValue == "PilihUnit")
{
addStrStatus = " Pilih Unit";
}
else if (status.SelectedValue == "SudahClosing")
{
addStrStatus = " Sudah Closing";
}
else if (status.SelectedValue == "SudahBayar")
{
addStrStatus = " Sudah Bayar";
}
x.Append("<br />Tgl. Launching : " + Cf.Day(tglawal.Text) + " s/d " + Cf.Day(tglakhir.Text));
x.Append("<br />Untuk Aktivasi : " + Cf.Str(addStrAktivasi));
x.Append("<br />Untuk Status : " + Cf.Str(addStrStatus));
x.Append("<br />Untuk Project : " + Cf.Str(addStrProject));
x.Append("<br /><span style='font-weight: normal;'>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today)
+ ", " + Cf.Date(DateTime.Now)
+ " dari workstation : " + Act.IP
+ " dan username : "******"</span>"
);
lblSubHeader.Text = x.ToString();
Fill();
}
private void Header()
{
string header = "<h2>" + Mi.Pt + "</h2>";
header += "<h1 class='title'>LAPORAN PEMBATALAN</h1>";
header += "Periode : " + Cf.Day(Dari) + " s/d " + Cf.Day(Sampai);
header += "<br/> Laporan dihasilkan pada hari " + Cf.IndoWeek(DateTime.Today);
header += ", " + Cf.Date(DateTime.Now) + " dari workstation : eProperty Mobile oleh user " + UserID + "<br /><br />";
headReport.InnerHtml = header;
}
private void newHeader()
{
string header = "<h2>" + Mi.Pt + "</h2>";
header += "<h1>LAPORAN CUSTOM TAGIHAN</h1>";
header += "Periode : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text);
header += "<br/> Laporan dihasilkan pada hari " + Cf.IndoWeek(DateTime.Today);
header += ", " + Cf.Date(DateTime.Now) + " dari workstation " + Act.IP + " oleh user " + Act.UserID + "<br /><br />";
headJudul.Text = header;
}
private void newHeader()
{
string header = "<h2>" + Mi.Pt + "</h2>";
header += "<h1 class='title'>Laporan Pembatalan</h1>";
header += "<h4>Project : " + project.SelectedItem.Text + "</h4>";
header += "Periode : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text);
header += "<br/> Laporan dihasilkan pada hari " + Cf.IndoWeek(DateTime.Today);
header += ", " + Cf.Date(DateTime.Now) + " dari workstation " + Act.IP + " oleh user " + Act.UserID + "<br /><br />";
headJudul.Text = header;
}
private void newHeader()
{
string header = "<h2>" + Mi.Pt + "</h2>";
header += "<h1 class='title'>LAPORAN MASTER STOCK PER LANTAI</h1>";
header += "<h4>Lokasi : " + lokasi.SelectedItem.Text;
header += "<br>Project : " + project.SelectedItem.Text + "</h4>";
header += "Laporan dihasilkan pada hari " + Cf.IndoWeek(DateTime.Today);
header += ", " + Cf.Date(DateTime.Now) + " dari workstation " + Act.IP + " oleh user " + Act.UserID + "<br /><br />";
headJudul.Text = header;
}
private void newHeader()
{
string header = "<p>" + Mi.Pt + "</p>";
header += "<h1 class='title'>LAPORAN COLLECTION</h1>";
header += "Periode : " + Cf.Monthname(Convert.ToInt32(Dari)) + " s/d " + Cf.Monthname(Convert.ToInt32(Sampai)) + " " + Tahun;
header += "Project : " + Project;
header += "Perusahaan : " + Perusahaan;
header += "<br/> Laporan dihasilkan pada hari " + Cf.IndoWeek(DateTime.Today);
header += ", " + Cf.Date(DateTime.Now) + " dari workstation " + Act.IP + " oleh user " + Act.UserID + "<br /><br />";
headJudul.Text = header;
}
private void newHeader()
{
string header = "<p>" + Mi.Pt + "</p>";
header += "<h1 class='title'>LAPORAN PAJAK</h1>";
header += "Periode : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text) + "<br>";
header += "Project : " + project.SelectedValue + "<br>";
header += "Perusahaan : " + pers.SelectedItem.Text + "<br>";
header += "<br/> Laporan dihasilkan pada hari " + Cf.IndoWeek(DateTime.Today);
header += ", " + Cf.Date(DateTime.Now) + " dari workstation " + Act.IP + " oleh user " + Act.UserID + "<br />";
headJudul.Text = header;
//Response.Write(header);
}
private void newHeader()
{
DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
string header = "<p>" + Mi.Pt + "</p>";
header += "<h1 class='title'>LAPORAN PROYEKSI PENERIMAAN</h1>";
header += "Periode : " + Cf.Day(Dari) + " s/d " + Cf.Day(Sampai);
header += "<br/> Laporan dihasilkan pada hari " + Cf.IndoWeek(DateTime.Today);
header += ", " + Cf.Date(DateTime.Now) + " dari workstation " + Act.IP + " oleh user " + Act.UserID + "<br /><br />";
headJudul.Text = header;
}
private void Report()
{
DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
param.Visible = false;
rpt.Visible = true;
lblHeader.Text = "<p>" + Mi.Pt + "</p>"
+ "<h1 class='title'>Laporan Sales Performance</h1>"
;
System.Text.StringBuilder x = new System.Text.StringBuilder();
x.Append("Sales : " + nAgent);
string nstatussales = String.Empty;
if (StatusSales == "I")
{
nstatussales = "Inaktif";
}
else if (StatusSales == "A")
{
nstatussales = "Aktif";
}
else
{
nstatussales = "Semua";
}
x.Append("<br />Status Agent : " + nstatussales);
if (FilterTgl == "0")
{
x.Append("<br />Tgl Kontrak : " + Cf.Day(Dari) + " s/d " + Cf.Day(Sampai));
}
else
{
x.Append("<br />Tgl Kontrak : As Of : " + Cf.Day(TglAsOf));
}
x.Append("<br />Project : " + Project);
x.Append("<br /><br /><span style='font-weight: normal;'>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today)
+ ", " + Cf.Date(DateTime.Now)
+ " dari workstation : " + Act.IP
+ " dan username : "******"</span>"
);
lblSubHeader.Text = x.ToString();
Fill();
}
protected void Page_Load(object sender, System.EventArgs e)
{
Act.Pass();
Act.NoCache();
DataTable rs = Db.Rs("SELECT "
+ " LogID"
+ ",TglApprove"
+ ",ApprovedBy"
+ ",CASE WHEN Approve = 1 THEN 'Approved' WHEN Approve = 2 THEN 'Rejected' END AS Approve"
+ ",(SELECT Nama FROM " + Mi.DbPrefix + "SECURITY..USERNAME WHERE UserID = " + Tb + ".ApprovedBy) AS Nama"
+ ",NoKontrak"
+ ",Lvl"
+ ",CASE WHEN Tipe = 1 THEN 'Pengalihan Hak' WHEN Tipe = 2 THEN 'Pindah Unit' WHEN Tipe = 3 THEN 'Batal Kontrak' WHEN Tipe = 4 THEN 'Diskon' END AS Tipe"
+ ",CASE WHEN Finish = 1 THEN 'Selesai' ELSE 'Belum Selesai' END AS Finish"
+ ",Komentar FROM " + Tb + " WHERE LogID = " + LogID);
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else
{
sumber.Text = Request.QueryString["sumber"];
logid.Text = LogID;
tgl.Text = Cf.Date(rs.Rows[0]["TglApprove"]);
user.Text = rs.Rows[0]["ApprovedBy"].ToString();
//ip.Text = rs.Rows[0]["IP"].ToString();
//BindAktivitas(rs.Rows[0]["Approve"].ToString());
pk.Text = rs.Rows[0]["NoKontrak"].ToString();
//ket.Text = rs.Rows[0]["Ket"].ToString().Replace("<br>","\n");
ket.Text = "Tipe : " + rs.Rows[0]["Tipe"].ToString() + ", Action : " + rs.Rows[0]["Approve"].ToString() + ", Komentar : " + rs.Rows[0]["Komentar"].ToString() + ", Status :" + rs.Rows[0]["Finish"].ToString();
if (!Act.Sec("AL:" + Request.PhysicalPath))
{
ok.Enabled = false;
}
if ((string)rs.Rows[0]["Approve"] != "")
{
ok.Enabled = false;
approveinfo.Text = (string)rs.Rows[0]["Approve"];
}
}
BindButton();
}
protected void Header()
{
Label l;
l = new Label();
l.Text = Mi.Pt;
l.Text += "<h1 class='title'>Daily Report</h1>";
l.Text += "<h2>per " + Cf.Day(Tgl) + "</h2>";
l.Text += "Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today)
+ ", " + Cf.Date(DateTime.Now)
+ " dari workstation : eProperty Mobile"
+ " dan username : "******"<br /><br />";
rpt.Controls.Add(l);
}
private void newHeader()
{
string header = "<h2>" + Mi.Pt + "</h2>";
header += "<h1 class='title'>LAPORAN PENJUALAN TAHUNAN</h1>";
header += "Periode : " + thn1.SelectedValue + " s/d " + thn2.SelectedValue;
header += "<br/>Jenis : " + Rpt.inSql(jenis).Replace("'", "");
header += "<br/>Lokasi : " + lokasi.SelectedItem.Text;
header += "<br/>Principal : " + agent.SelectedItem.Text;
header += "<br/>Perusahaan : " + pers.SelectedValue;
header += "<br/>Project : " + project.SelectedValue;
header += "<br/> Laporan dihasilkan pada hari " + Cf.IndoWeek(DateTime.Today);
header += ", " + Cf.Date(DateTime.Now) + " dari workstation " + Act.IP + " oleh user " + Act.UserID + "<br /><br />";
headJudul.Text = header;
}
private void Fill()
{
btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=REF_KOMISI_CF_LOG&Pk=" + Lvl + "'";
btndel.Attributes["onclick"] = "location.href='KomisiCFDel.aspx?Lvl=" + Lvl + "'";
atas.Attributes["onfocus"] = "tempnum=CalcFocus(this);";
atas.Attributes["onkeyup"] = "CalcType(this,tempnum);";
atas.Attributes["onblur"] = "CalcBlur(this);";
bawah.Attributes["onfocus"] = "tempnum=CalcFocus(this);";
bawah.Attributes["onkeyup"] = "CalcType(this,tempnum);";
bawah.Attributes["onblur"] = "CalcBlur(this);";
gm.Attributes["onfocus"] = "tempnum=CalcFocus(this);";
gm.Attributes["onkeyup"] = "CalcType(this,tempnum);";
gm.Attributes["onblur"] = "CalcBlur(this);";
sm.Attributes["onfocus"] = "tempnum=CalcFocus(this);";
sm.Attributes["onkeyup"] = "CalcType(this,tempnum);";
sm.Attributes["onblur"] = "CalcBlur(this);";
manager.Attributes["onfocus"] = "tempnum=CalcFocus(this);";
manager.Attributes["onkeyup"] = "CalcType(this,tempnum);";
manager.Attributes["onblur"] = "CalcBlur(this);";
string strSql = "SELECT * FROM REF_KOMISI_CF WHERE Lvl ='" + Lvl + "'";
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else
{
ket.Text = rs.Rows[0]["Keterangan"].ToString();
atas.Text = Cf.Num(rs.Rows[0]["NilaiAtas"]);
bawah.Text = Cf.Num(rs.Rows[0]["NilaiBawah"]);
gm.Text = Cf.Num(rs.Rows[0]["NilaiGM"]);
sm.Text = Cf.Num(rs.Rows[0]["NilaiSM"]);
manager.Text = Cf.Num(rs.Rows[0]["NilaiM"]);
tglInput.Text = Cf.Date(rs.Rows[0]["TglInput"]);
tglEdit.Text = Cf.Date(rs.Rows[0]["TglEdit"]);
}
}
private void Report()
{
param.Visible = false;
rpt.Visible = true;
lblHeader.Text = "<p>" + Mi.Pt + "</p>"
+ "<h1 class='title'>Laporan Sales Performance</h1>"
;
System.Text.StringBuilder x = new System.Text.StringBuilder();
x.Append("Sales : " + ddlAgent.SelectedItem.Text);
x.Append("<br />Status Agent : " + status.SelectedItem.ToString());
if (filtertgl.SelectedValue.ToString() == "0")
{
x.Append("<br />Tgl Kontrak : " + Cf.Day(dari.Text) + " s/d " + Cf.Day(sampai.Text));
}
else
{
x.Append("<br />Tgl Kontrak : As Of : " + Cf.Day(tglasof.Text));
}
string hitung = "";
if (kuantitas.Checked)
{
hitung = kuantitas.Text;
}
if (rupiah.Checked)
{
hitung = rupiah.Text;
}
x.Append("<br />Perhitungan : " + hitung);
x.Append("<br />Project : " + project.SelectedItem.Text);
x.Append("<br /><br /><span style='font-weight: normal;'>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today)
+ ", " + Cf.Date(DateTime.Now)
+ " dari workstation : " + Act.IP
+ " dan username : "******"</span>"
);
lblSubHeader.Text = x.ToString();
Fill();
}
private void newHeader()
{
string tipe = "";
tipe = Tipe.Replace("-", ",");
string header = "<h2>" + Mi.Pt + "</h2>";
header += "<h1 class='title'>LAPORAN PENJUALAN TAHUNAN</h1>";
header += "Periode : " + Thn1 + " s/d " + Thn2;
header += "<br/>Jenis : " + tipe.Replace("%", " ");
header += "<br/>Lokasi : " + Lokasi;
header += "<br/>Principal : " + Agent;
header += "<br/>Perusahaan : " + Perusahaan;
header += "<br/>Project : " + Project;
header += "<br/> Laporan dihasilkan pada hari " + Cf.IndoWeek(DateTime.Today);
header += ", " + Cf.Date(DateTime.Now) + " dari workstation " + Act.IP + " oleh user " + Act.UserID + "<br /><br />";
headJudul.Text = header;
}
private void newHeader()
{
DateTime Dari = Db.SingleTime("SELECT FilterDari FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
DateTime Sampai = Db.SingleTime("SELECT FilterSampai FROM LapPDF WHERE AttachmentID='" + AttachmentID + "'");
string header = "<p>" + Mi.Pt + "</p>";
header += "<h1 class='title'>LAPORAN PAJAK</h1>";
header += "Periode : " + Cf.Day(Dari) + " s/d " + Cf.Day(Sampai) + "<br>";
header += "Project : " + Project + "<br>";
string pers = (Perusahaan == "SEMUA") ? "SEMUA" : Db.SingleString("SELECT Nama FROM " + Mi.DbPrefix + "SECURITY..REF_PERS WHERE Pers = '" + Perusahaan + "'");
header += "Perusahaan : " + pers + "<br>";
header += "<br/> Laporan dihasilkan pada hari " + Cf.IndoWeek(DateTime.Today);
header += ", " + Cf.Date(DateTime.Now) + " dari workstation " + Act.IP + " oleh user " + Act.UserID + "<br />";
headJudul.Text = header;
//Response.Write(header);
}
protected void Page_Load(object sender, System.EventArgs e)
{
Act.Pass();
Act.NoCache();
if (!Page.IsPostBack)
{
InitForm();
if (Request.QueryString["NoUnit"] != null)
{
unit.Text = Request.QueryString["NoUnit"];
nostock.Text = NoStock;
}
unit.Text = Db.SingleString(
"SELECT NoUnit FROM MS_UNIT WHERE NoStock = '" + NoStock + "'");
tglhold.Text = Cf.Day(DateTime.Today);
tglholdexp.Text = Cf.Date(DateTime.Now.AddMonths(1));
}
}
private void Report()
{
param.Visible = false;
rpt.Visible = true;
lblPT.Text = Mi.Pt;
lblHeader.Text = "Laporan Ganti Nama NUP";
System.Text.StringBuilder x = new System.Text.StringBuilder();
x.Append("<br /><span style='font-weight: normal;'>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today)
+ ", " + Cf.Date(DateTime.Now)
+ " dari workstation : " + Act.IP
+ " dan username : "******"</span>"
);
lblSubHeader.Text = x.ToString();
Fill();
}
private void Header()
{
System.Text.StringBuilder x = new System.Text.StringBuilder();
x.Append("Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today)
+ ", " + Cf.Date(DateTime.Now)
+ " dari workstation : " + Act.IP
+ " dan username : "******"<h3>" + Mi.Pt + "</h3>"
+ "<h1 class='title'>LAPORAN REALISASI SALES & CASH IN</h1>"
+ "Periode " + Cf.Monthname(Convert.ToInt32(BlnDari)) + " " + Convert.ToInt32(ThnDari)
+ " s/d " + Cf.Monthname(Convert.ToInt32(BlnSampai)) + " " + Convert.ToInt32(ThnSampai)
+ "<br />"
+ x
+ "<br />"
+ "<br />"
;
}
private void Fill()
{
aKey.HRef = "javascript:openModal('EditKey.aspx?UserID=" + UserID + "','350','150')";
btnlog.Attributes["onclick"] = "location.href='LogPk.aspx?Tb=USERNAME_LOG&Pk=" + UserID + "'";
btndel.Attributes["onclick"] = "location.href='DelUser.aspx?UserID=" + UserID + "'";
string strSql = "SELECT * FROM USERNAME WHERE UserID = '" + UserID + "'";
DataTable rs = Db.Rs(strSql);
if (rs.Rows.Count == 0)
{
Response.Redirect("/CustomError/Deleted.html");
}
else
{
userid.Text = rs.Rows[0]["UserID"].ToString();
nama.Text = rs.Rows[0]["Nama"].ToString();
email.Text = rs.Rows[0]["Email"].ToString();
seclevel.SelectedValue = rs.Rows[0]["SecLevel"].ToString();
agent.SelectedValue = rs.Rows[0]["NoAgent"].ToString();
gantipass.Checked = (bool)rs.Rows[0]["GantiPass"];
rotasipass.Text = rs.Rows[0]["RotasiPass"].ToString();
tglinput.Text = Cf.Date(rs.Rows[0]["TglInput"]);
tgllogin.Text = Cf.Date(rs.Rows[0]["TglLogin"]);
tglpass.Text = Cf.Date(rs.Rows[0]["TglPass"]);
if (rs.Rows[0]["Status"].ToString() == "A")
{
status.ForeColor = Color.Green;
status.Text = "Aktif";
}
else
{
status.ForeColor = Color.Red;
status.Text = "Blokir";
}
}
}
protected void Report()
{
lblHeader.Text = Mi.Pt
+ "<br />"
+ "Laporan Revisi NUP"
;
System.Text.StringBuilder x = new System.Text.StringBuilder();
x.Append("<br />Untuk Project : " + Cf.Str(Project));
x.Append("<br /><span style='font-weight: normal;'>Laporan dihasilkan pada hari : " + Cf.IndoWeek(DateTime.Today)
+ ", " + Cf.Date(DateTime.Now)
+ " dari workstation : " + Act.IP
+ " dan username : "******"</span>"
);
lblSubHeader.Text = x.ToString();
Fill();
}
