public static void CreateFilePDF(string pdffilename, string myHtml, byte orientationpage, string Tipe,
bool DefaultReport, string nama)
{
string FolderPDF = Param.FolderPDF + Tipe;
LibApi.CreateFolderPDF(FolderPDF);
string save = FolderPDF + "\\" + pdffilename;
string link = Param.IPAddress + "pdf/" + Tipe + "/" + pdffilename;
Process p = new System.Diagnostics.Process();
p.StartInfo.Arguments = "--orientation " + (orientationpage == 1 ? "portrait" : "landscape") + " --page-width 21cm --page-height 29.7cm --margin-left 1cm --margin-right 1cm --margin-top 1cm --margin-bottom 1cm " + myHtml + " " + save;
p.StartInfo.FileName = Param.GeneratorPDF;
p.Start();
p.WaitForExit(60000);
Db.Execute("INSERT INTO ISC064_SECURITY..REPORT "
+ " (Tipe, DefaultReport, Nama, Path, Link, TglGenerate) "
+ " VALUES ("
+ " '" + Tipe + "'"
+ ",'" + Convert.ToBoolean(DefaultReport) + "'"
+ ",'" + nama + "'"
+ ",'" + save + "'"
+ ",'" + link + "'"
+ ",'" + DateTime.Now + "'"
+ " )"
);
}
public static void CreateFilePDFManagementReport(DateTime Tgl, string UserID, string Project, bool DefaultReport)
{
string Tipe = TipeReport(4);
string nama = Tgl.Day + " " + NamaBln(Tgl.Month) + " " + Tgl.Year; //nama tampilan
string pdffilename = "MR-" + Tgl.Day + NamaBln(Tgl.Month) + Tgl.Year + "-" + GetRandomPdfFileName() + ".pdf";
string myHtml = Param.IPAddress + "LaporanApi/LapManagementReportApi.aspx?Tgl=" + LibApi.Tgl(Tgl) + "&UserID=" + UserID + "&Project=" + Project;
LibApi.CreateFilePDF(pdffilename, myHtml, 1, Tipe, DefaultReport, nama);
}
public static void CreateFilePDFLapBatalKontrak(string UserID, string LokasiID, string TipeID, DateTime Dari,
DateTime Sampai, string Project, bool DefaultReport)
{
string Tipe = TipeReport(3);
string nama = TglNamaBln(Dari.Month, false) + " " + Dari.Year; //nama tampilan
string pdffilename = "BK-" + NamaBln(Dari.Month) + Dari.Year + "-" + GetRandomPdfFileName() + ".pdf";
string myHtml = Param.IPAddress + "LaporanApi/LapBatalKontrakApi.aspx?tipe=" + TipeID + "&lokasi=" + LokasiID + "&userid=" + UserID + "&dari=" + LibApi.Tgl(Dari) + "&sampai=" + LibApi.Tgl(Sampai) + "&project=" + Project;
LibApi.CreateFilePDF(pdffilename, myHtml, 0, Tipe, DefaultReport, nama);
}
public static void CreateFilePDFLapPenjualan(string UserID, string LokasiID, string TipeID, string AgentID,
DateTime Dari, DateTime Sampai, string Project, bool DefaultReport)
{
string Tipe = TipeReport(2);
string nama = TglNamaBln(Dari.Month, false) + " " + Dari.Year; //nama tampilan
string pdffilename = "Penjualan-" + NamaBln(Dari.Month) + Dari.Year + "-" + GetRandomPdfFileName() + ".pdf";
string myHtml = Param.IPAddress + "LaporanApi/LapPenjualanApi.aspx?tipe=" + TipeID + "&lokasi=" + LokasiID + "&agent=" + AgentID + "&titipjual=SEMUA&tipepro=SEMUA&userid=" + UserID + "&dari=" + LibApi.Tgl(Dari) + "&sampai=" + LibApi.Tgl(Sampai) + "&project=" + Project;
//http://localhost:8030/LaporanApi/LapPenjualanApi.aspx?id=&tipe=SEMUA&lokasi=SEMUA&agent=SEMUA&titipjual=SEMUA&tipepro=SEMUA&userid=TES&dari=2018-02-01&sampai=2018-02-28
LibApi.CreateFilePDF(pdffilename, myHtml, 0, Tipe, DefaultReport, nama);
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable rs = Db.Rs("SELECT * FROM REF_PROJECT");
//Daily Report
LibApi.DeleteReport(LibApi.TipeReport(1));
LibApi.DeleteFolderPDF(Param.FolderPDF + LibApi.TipeReport(1));
//Laporan Penjualan
LibApi.DeleteReport(LibApi.TipeReport(2));
LibApi.DeleteFolderPDF(Param.FolderPDF + LibApi.TipeReport(2));
//Laporan Batal Kontrak
LibApi.DeleteReport(LibApi.TipeReport(3));
LibApi.DeleteFolderPDF(Param.FolderPDF + LibApi.TipeReport(3));
//Management Report
LibApi.DeleteReport(LibApi.TipeReport(4));
LibApi.DeleteFolderPDF(Param.FolderPDF + LibApi.TipeReport(4));
for (int i = 0; i < rs.Rows.Count; i++)
{
string project = Cf.Str(rs.Rows[i]["Project"]).ToString();
//Daily Report
LibApi.CreateFilePDFDailyReport(DateTime.Today.AddDays(-1), "server", project, true);
//Laporan Penjualan
LibApi.CreateFilePDFLapPenjualan("server", "SEMUA", "SEMUA", "SEMUA", Cf.AwalBulan(), Cf.AkhirBulan(), project, true);
//Laporan Batal Kontrak
LibApi.CreateFilePDFLapBatalKontrak("server", "SEMUA", "SEMUA", Cf.AwalBulan(), Cf.AkhirBulan(), project, true);
//Management Report
LibApi.CreateFilePDFManagementReport(DateTime.Today.AddDays(-1), "server", project, true);
}
}
