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); } }