def generate_header(self, output="Exam", instructor="Vaccaro", section="English", test_name="Final Exam", version=1): header = PageStyle("header") with header.create(Head("C")): header.append(instructor) header.append(LineBreak()) with header.create(Head("L")): header.append(section) header.append(LineBreak()) header.append(test_name + str(version) if output != 'key' else test_name) with header.create(Head("R")): if (output == "exam"): header.append("Student: _____________") elif (output == "answers"): header.append("Answers v" + str(version)) else: header.append("Key") with header.create(Foot("R")): header.append(simple_page_number()) return header
def add_header(self): header_text = 'Analysis of ' + self.analysis.analysis_name header = PageStyle('header') with header.create(Head('L')): header.append(header_text) header.append(LineBreak()) with header.create(Foot('R')): header.append(simple_page_number()) self.doc.preamble.append(header) self.doc.change_document_style('header')
def _export_pdf(self, fname: str): geometry_options = {"margin": "1in"} doc = pylatex.Document(geometry_options=geometry_options) header = pylatex.PageStyle("header") with doc.create(pylatex.MiniPage(align="c")): doc.append( pylatex.HugeText(pylatex.utils.bold("Practice Sessions"))) doc.append(pylatex.LineBreak()) with header.create(pylatex.Foot("L")): header.append("@2019 Musicavis") with header.create(pylatex.Foot("R")): header.append(pylatex.simple_page_number()) doc.preamble.append(header) doc.change_document_style("header") for practice in self.practices: with doc.create( pylatex.Section( f"{practice.instrument.name.title()} ({practice.date:%a, %B %m %Y})" )): self._add_list_itemize_latex(doc, "Goals", practice.goals.all()) with doc.create(pylatex.Subsection("Exercises")): with doc.create(pylatex.Itemize()) as itemize: for x in practice.exercises.all(): itemize.add_item( f"{x.name} at {x.bpm_start}-{x.bpm_end}bpm for {x.minutes}m" ) self._add_list_itemize_latex(doc, "Improvements", practice.improvements.all()) self._add_list_itemize_latex(doc, "Positives", practice.positives.all()) with doc.create(pylatex.Subsection("Notes:")): if practice.notes: for note in practice.notes.split("\r\n"): doc.append(note) if note else doc.append( pylatex.NewLine()) doc.generate_pdf(fname.split(".pdf")[0], clean=True)
def dumps(self): # Clear the old data self.clear() assessment = self.assessment if hasattr(self.assessment, 'course'): course = self.assessment.course else: course = None if course: # Create left header with self.create(Head('L')): self.append(course.name) self.append(LineBreak()) self.append(SmallText(course.kind)) self.append(self.padding) # Create center header with self.create(Head('C')): self.append(NoEscape(r'\ifbool{instructorKey}{')) self.append(SmallText(bold('FOR INSTRUCTORS ONLY'))) self.append(LineBreak()) self.append(SmallText(bold(f'(Max. of {assessment.maxpoints} points)'))) self.append(NoEscape(r'}{}')) self.append(self.padding) # Create right header with self.create(Head('R')): self.append(f'{assessment.kind} {assessment.number}.{assessment.version} - {assessment.fullpoints} Points') self.append(LineBreak()) self.append(SmallText(f'Assessing Period: {assessment.period}')) self.append(self.padding) if course: # Create left footer with self.create(Foot('L')): self.append(course.term) # Create center footer with self.create(Foot('C')): now = datetime.now().strftime('%Y%m%d%H%M') self.append(FootnoteText(now)) # Create right footer with self.create(Foot('R')): self.append(simple_page_number()) return super().dumps()
def gera_cabecalho(self, json_ppra): header = PageStyle("header") # Create left header with header.create(Head("L")) as header_left: logo_file = os.path.join(os.path.dirname(__file__), 'logo.png') header_left.append( StandAloneGraphic(image_options="width=3cm", filename=logo_file)) # Create center header with header.create(Head("C")) as header_center: header_center.append("PPRA 2018") header_center.append(LineBreak()) header_center.append(json_ppra['nomeEmpresa']) header_center.append(LineBreak()) header_center.append(json_ppra['nomeFilial']) # Create right header with header.create(Head("R")) as header_right: header_right.append(simple_page_number()) header_right.append(LineBreak()) header_right.append("Novembro/2018") self.preamble.append(header)
def write_header(self, doc): # def write_header(self): # Add document header header = PageStyle("header") # Create left header with header.create(Head("L")): header.append( "Center for Reflected Text Analytics (CRETA)\nUniversity of Stuttgart" ) # header.append(LineBreak()) # header.append("R3") ## Create center header # with header.create(Head("C")): # header.append("Company") # Create right header with header.create(Head("R")): header.append(NoEscape(r'\today')) ## Create left footer # with header.create(Foot("L")): # header.append("Left Footer") ## Create center footer with header.create(Foot("C")): header.append(simple_page_number()) ## Create right footer # with header.create(Foot("R")): # header.append("Right Footer") doc.preamble.append(header) doc.change_document_style("header") # Add Heading with doc.create(MiniPage(align='c')): doc.append(LargeText(bold("rCAT v0.1"))) doc.append(LineBreak()) doc.append(MediumText(bold("Relational Character Analysis Tool"))) return doc
def generate_header(): geometry_options = {"margin": "0.7in"} doc = Document(geometry_options=geometry_options) # Add document header header = PageStyle("header") # Create left header with header.create(Head("L")): header.append("__") header.append(LineBreak()) header.append("_") # Create center header with header.create(Head("C")): header.append("____") # Create right header with header.create(Head("R")): header.append(simple_page_number()) # Create left footer with header.create(Foot("L")): header.append("Left Footer") # Create center footer with header.create(Foot("C")): header.append("Center Footer") # Create right footer with header.create(Foot("R")): header.append("Right Footer") doc.preamble.append(header) doc.change_document_style("header") # Add Heading with doc.create(MiniPage(align='l')): doc.append(LargeText(bold("INVESTMENT PROPERTY - BUY & HOLD"))) doc.append(LineBreak()) doc.append(MediumText(bold(" "))) doc.generate_pdf("header", clean_tex=False) return print('nice')
def generate_header(): geometry_options = {"margin": "0.7in"} doc = Document(geometry_options=geometry_options) # Add document header header = PageStyle("header") # Create left header with header.create(Head("L")): header.append("Page date: ") header.append(LineBreak()) header.append("R3") # Create center header with header.create(Head("C")): header.append("Company") # Create right header with header.create(Head("R")): header.append(simple_page_number()) # Create left footer with header.create(Foot("L")): header.append("Left Footer") # Create center footer with header.create(Foot("C")): header.append("Center Footer") # Create right footer with header.create(Foot("R")): header.append("Right Footer") doc.preamble.append(header) doc.change_document_style("header") # Add Heading with doc.create(MiniPage(align='c')): doc.append(LargeText(bold("Title"))) doc.append(LineBreak()) doc.append(MediumText(bold("As at:"))) doc.generate_pdf("header", clean_tex=False)
def generate_unique(): geometry_options = { "head": "40pt", "margin": "0.5in", "bottom": "0.6in", "includeheadfoot": True } doc = Document(geometry_options=geometry_options) # Generating first page style first_page = PageStyle("firstpage") # Header image with first_page.create(Head("L")) as header_left: with header_left.create(MiniPage(width=NoEscape(r"0.49\textwidth"), pos='c')) as logo_wrapper: logo_file = os.path.join(os.path.dirname(__file__), 'sample-logo.png') logo_wrapper.append(StandAloneGraphic(image_options="width=120px", filename=logo_file)) # Add document title with first_page.create(Head("R")) as right_header: with right_header.create(MiniPage(width=NoEscape(r"0.49\textwidth"), pos='c', align='r')) as title_wrapper: title_wrapper.append(LargeText(bold("Bank Account Statement"))) title_wrapper.append(LineBreak()) title_wrapper.append(MediumText(bold("Date"))) # Add footer with first_page.create(Foot("C")) as footer: message = "Important message please read" with footer.create(Tabularx( "X X X X", arguments=NoEscape(r"\textwidth"))) as footer_table: footer_table.add_row( [MultiColumn(4, align='l', data=TextColor("blue", message))]) footer_table.add_hline(color="blue") footer_table.add_empty_row() branch_address = MiniPage( width=NoEscape(r"0.25\textwidth"), pos='t') branch_address.append("960 - 22nd street east") branch_address.append("\n") branch_address.append("Saskatoon, SK") document_details = MiniPage(width=NoEscape(r"0.25\textwidth"), pos='t', align='r') document_details.append("1000") document_details.append(LineBreak()) document_details.append(simple_page_number()) footer_table.add_row([branch_address, branch_address, branch_address, document_details]) doc.preamble.append(first_page) # End first page style # Add customer information with doc.create(Tabu("X[l] X[r]")) as first_page_table: customer = MiniPage(width=NoEscape(r"0.49\textwidth"), pos='h') customer.append("Verna Volcano") customer.append("\n") customer.append("For some Person") customer.append("\n") customer.append("Address1") customer.append("\n") customer.append("Address2") customer.append("\n") customer.append("Address3") # Add branch information branch = MiniPage(width=NoEscape(r"0.49\textwidth"), pos='t!', align='r') branch.append("Branch no.") branch.append(LineBreak()) branch.append(bold("1181...")) branch.append(LineBreak()) branch.append(bold("TIB Cheque")) first_page_table.add_row([customer, branch]) first_page_table.add_empty_row() doc.change_document_style("firstpage") doc.add_color(name="lightgray", model="gray", description="0.80") # Add statement table with doc.create(LongTabu("X[l] X[2l] X[r] X[r] X[r]", row_height=1.5)) as data_table: data_table.add_row(["date", "description", "debits($)", "credits($)", "balance($)"], mapper=bold, color="lightgray") data_table.add_empty_row() data_table.add_hline() row = ["2016-JUN-01", "Test", "$100", "$1000", "-$900"] for i in range(30): if (i % 2) == 0: data_table.add_row(row, color="lightgray") else: data_table.add_row(row) doc.append(NewPage()) # Add cheque images with doc.create(LongTabu("X[c] X[c]")) as cheque_table: cheque_file = os.path.join(os.path.dirname(__file__), 'chequeexample.png') cheque = StandAloneGraphic(cheque_file, image_options="width=200px") for i in range(0, 20): cheque_table.add_row([cheque, cheque]) doc.generate_pdf("complex_report", clean_tex=False)
def details(): if __name__ == '__main__': image_filename = os.path.join(os.path.dirname(__file__), 'kitten.jpg') logo_file = os.path.join(os.path.dirname(__file__),'sample-logo.png') geometry_options = {"tmargin": "1cm", "lmargin": "3cm"} doc = Document(geometry_options=geometry_options) header = PageStyle("header") with header.create(Head("R")): header.append(simple_page_number()) with header.create(Foot("C")): header.append("Center Footer") first_page = PageStyle("firstpage") with first_page.create(Head("L")) as header_left: with header_left.create(MiniPage(width=NoEscape(r"0.49\textwidth"),pos='c')) as logo_wrapper with doc.create(MiniPage(align='l')): doc.append(LargeText(bold("INVESTMENT PROPERTY - BUY & HOLD"))) doc.append(LineBreak()) doc.append(MediumText(bold(" "))) logo_wrapper.append(StandAloneGraphic(image_options="width=120px", filename=logo_file)) with doc.create(Section('Home Adress')): doc.append('Some regular text and some') doc.append(italic('italic text. ')) doc.append('\nAlso some crazy characters: $&#{}') with doc.create(Subsection('Math that is incorrect')): doc.append(Math(data=['2*3', '=', 9])) with doc.create(Subsection('Table of something')): with doc.create(Tabular('rc|cl')) as table: table.add_hline() table.add_row((1, 2, 3, 4)) table.add_hline(1, 2) table.add_empty_row() table.add_row((4, 5, 6, 7)) a = np.array([[100, 10, 20]]).T M = np.matrix([[2, 3, 4], [0, 0, 1], [0, 0, 2]]) with doc.create(Section('The fancy stuff')): with doc.create(Subsection('Correct matrix equations')): doc.append(Math(data=[Matrix(M), Matrix(a), '=', Matrix(M * a)])) with doc.create(Subsection('Alignat math environment')): with doc.create(Alignat(numbering=False, escape=False)) as agn: agn.append(r'\frac{a}{b} &= 0 \\') agn.extend([Matrix(M), Matrix(a), '&=', Matrix(M * a)]) with doc.create(Subsection('Beautiful graphs')): with doc.create(TikZ()): plot_options = 'height=4cm, width=6cm, grid=major' with doc.create(Axis(options=plot_options)) as plot: plot.append(Plot(name='model', func='-x^5 - 242')) coordinates = [ (-4.77778, 2027.60977), (-3.55556, 347.84069), (-2.33333, 22.58953), (-1.11111, -493.50066), (0.11111, 46.66082), (1.33333, -205.56286), (2.55556, -341.40638), (3.77778, -1169.24780), (5.00000, -3269.56775), ] plot.append(Plot(name='estimate', coordinates=coordinates)) with doc.create(Subsection('Cute kitten pictures')): with doc.create(Figure(position='h!')) as kitten_pic: kitten_pic.add_image(image_filename, width='120px') kitten_pic.add_caption('Look it\'s on its back') doc.generate_pdf('full', clean_tex=False)
def get_document(document_title='Report', author='Entail AS', fig_ext=u'.pdf', header_logofilename='entail.pdf', logo_image_option_header="width=250px", workflow_ID=0): global _fig_ext _fig_ext = fig_ext geometry_options = { "head": "70pt", "margin": "1.5cm", "bottom": "1.5cm", "includeheadfoot": True } document_options = ['a4paper'] doc = Document(geometry_options=geometry_options, document_options=document_options) # packages doc.packages.append(Package('booktabs')) doc.packages.append(Package('chngcntr')) doc.packages.append(Package('longtable')) doc.packages.append(Package('titlepic')) doc.packages.append(Package('float')) # page style first_page = PageStyle("firstpage") # Header image with first_page.create(Head("L")) as header_left: with header_left.create( MiniPage(width=NoEscape(r"0.25\textwidth"), pos='c')) as logo_wrapper: logo_file = os.path.join( os.path.dirname(os.path.abspath(__file__)), header_logofilename).replace('\\', '/') logo_wrapper.append( StandAloneGraphic(image_options="width=80px", filename=logo_file)) # Add document title with first_page.create(Head("R")) as right_header: with right_header.create( MiniPage(width=NoEscape(r"0.75\textwidth"), pos='c', align='r')) as title_wrapper: title_wrapper.append(LargeText(bold(document_title))) title_wrapper.append(LineBreak()) title_wrapper.append(MediumText(bold(NoEscape(r'\today')))) # Add footer with first_page.create(Foot("C")) as center_footer: center_footer.append(simple_page_number()) with first_page.create(Foot("R")) as right_footer: with right_footer.create( MiniPage(width=NoEscape(r"0.15\textwidth"), pos='r')) as logo_wrapper: logo_file = os.path.join( os.path.dirname(os.path.abspath(__file__)), 'tailor.png').replace('\\', '/') logo_wrapper.append( StandAloneGraphic(image_options="width=50px", filename=logo_file)) doc.preamble.append(first_page) doc.change_document_style("firstpage") doc.preamble.append(Command('title', document_title)) logo_file = os.path.join(os.path.dirname(os.path.abspath(__file__)), header_logofilename).replace('\\', '/') doc.preamble.append( Command( 'titlepic', StandAloneGraphic(image_options=logo_image_option_header, filename=logo_file))) # doc.preamble.append(Command('author', author)) doc.preamble.append(Command('date', NoEscape(r'\today'))) doc.preamble.append( Command( 'hypersetup', arguments= 'colorlinks, citecolor=black, filecolor=black, linkcolor=black, urlcolor=black', packages=[Package('hyperref')])) doc.preamble.append(NoEscape(r'\counterwithin{figure}{section}')) doc.append(NoEscape(r'\maketitle')) # Add disclaimer doc.append(NewPage()) doc.append(NoEscape(r'\textbf{Disclaimer}')) doc.append(NoEscape(r'\newline')) doc.append(NoEscape(r'\vspace{0.2in}')) temptext = f'This is in automatically generated report. ' if workflow_ID == 0: temptext += f'The report was generated ' else: temptext += f'The results are extracted from Workflow ID {workflow_ID} ' temptext += f'on the {datetime.datetime.now().strftime("%m/%d/%Y at %H:%M:%S")}. ' temptext += f'Errors may occur and it is the user’s responsibility to interpret the reported data ' temptext += f'with sound engineering judgement.' doc.append(temptext) doc.append(NewPage()) doc.append(Command('tableofcontents')) doc.append(NewPage()) return doc
def generate_unique(): geometry_options = { "head": "40pt", "margin": "0.5in", "bottom": "0.6in", "includeheadfoot": True } doc = Document(geometry_options=geometry_options) # Generating first page style first_page = PageStyle("firstpage") # Header image with first_page.create(Head("C")) as header_center: with header_center.create( MiniPage(width=NoEscape(r"0.50\textwidth"), pos='c')) as logo_wrapper: logo_file = os.path.join(os.path.dirname(__file__), 'sample-logo.png') logo_wrapper.append( StandAloneGraphic(image_options="width=300px", filename=logo_file)) # Add document title # Add footer with first_page.create(Foot("C")) as footer: message = "Important message please read" with footer.create( Tabularx( "X X X X", width_argument=NoEscape(r"\textwidth"))) as footer_table: branch_address = MiniPage(width=NoEscape(r"0.25\textwidth"), pos='t') document_details = MiniPage(width=NoEscape(r"0.25\textwidth"), pos='t', align='r') document_details.append(LineBreak()) document_details.append(simple_page_number()) footer_table.add_row([ branch_address, branch_address, branch_address, document_details ]) doc.preamble.append(first_page) # End first page style # Add customer information with doc.create(Tabu("X[l] X[r]")) as first_page_table: customer = MiniPage(width=NoEscape(r"0.49\textwidth"), pos='h') # Add branch information branch = MiniPage(width=NoEscape(r"0.49\textwidth"), pos='t!', align='r') first_page_table.add_row([customer, branch]) first_page_table.add_empty_row() doc.change_document_style("firstpage") doc.add_color(name="lightgray", model="gray", description="0.80") print("Enter the Region") R = input(str) with doc.create(MiniPage(align='c')): doc.append(LargeText(bold("\n\n\n\n\n\n" + R))) doc.append(LineBreak()) print("Enter the adress of home ") A = input(str) image_filename = os.path.join(os.path.dirname(__file__), 'home.jpg') with doc.create(Section('Example : ' + A)): with doc.create(Figure(position='h!')) as home_pic: home_pic.add_image(image_filename, width='490px') with doc.create(Section('Property information :')): with doc.create(Itemize()) as itemize: print("enter property type") x = input(str) itemize.add_item(bold("Property type : " + x)) print("How many bedrooms ?") y = input(int) itemize.add_item(bold("Bedroom : " + y)) print("How many bathrooms?") z = input(float) itemize.add_item(bold("Bathroom : " + z)) print('Enter the year of built please:') a = input(int) itemize.add_item(bold("Year built : " + a)) print('Enter the finished sqft :') b = input(int) itemize.add_item(bold("Finished sqft : " + b)) print("Enter the estimate price") p1 = input(float) print('enter the estimate rent') p2 = input(float) doc.append(LineBreak()) table1 = Tabular('|c|c|') table1.add_hline() table1.add_row(('Estimate price', 'Estimate rent')) table1.add_hline() table1.add_row((p1 + '$', p2 + '$')) table1.add_hline() doc.append(table1) with doc.create(Section('Financing')): with doc.create(Itemize()) as itemize: print('Enter type of loan') lo = input(str) itemize.add_item(bold("Loan Type: " + lo)) print("Enter loan amount") la = input(float) itemize.add_item(bold("Loan Amount: " + la)) print("enter the interest rate with %") IR = input(float) itemize.add_item(bold("Interest Rate: " + IR + "%")) print("enter LTV") LTV = input(float) itemize.add_item(bold("Loan to Value (LTV): " + LTV + "%")) print("enter loan term") LT = input(int) itemize.add_item(bold("Loan Term: " + LT + "years")) print("enter loan payment monthly") LPM = input(int) print("enter loan payment yearly") LPY = input(int) itemize.add_item( bold("Loan Payment: " + LPM + "(monthly), " + LPY + "(yearly)")) with doc.create(Section('Assumptions')): with doc.create(Itemize()) as itemize: print("enter vacancy rate") vr = input(float) itemize.add_item(bold('Vacancy Rate' + vr)) print("property managment") pr = input(float) itemize.add_item(bold('Property Managment' + pr)) print("yearly expense") yex = input(float) itemize.add_item(bold('Yearly Expense incr' + yex)) print("yearly rent") yr = input(float) itemize.add_item(bold('Yearly Rent incr' + yr)) print("yearly equity") ye = input(float) itemize.add_item(bold('Yearly Equity incr' + ye)) print("land value") lv = input(float) itemize.add_item(bold('Land Value' + lv)) section = Section('Financial projection and expences analysis') test1 = Subsection(bold('Financial Projection')) test2 = Subsection(bold('Expences')) table2 = Tabular('|c|c|c|c|c|c|c|c|c|c|') table2.add_hline() table2.add_row(("Type", "Year 1", "Year 2", "Year 3", "Year 4", "Year 5", "Year 10", "Year 15", "Year 20", "Year 30")) table2.add_hline() table2.add_row(("Total Annuel Income", 6, 7, 8, 8, 8, 8, 8, 8, 8)) table2.add_hline() table2.add_row(("Total Annuel Expenses", 6, 7, 8, 8, 8, 8, 8, 8, 8)) table2.add_hline() table2.add_row( ("Total Annuel Operating Expenses", 6, 7, 8, 8, 8, 8, 8, 8, 8)) table2.add_hline() table2.add_row(("Total Annual Cash Flow", 6, 7, 8, 8, 8, 8, 8, 8, 8)) table2.add_hline() table2.add_row(("Property Value", 6, 7, 8, 8, 8, 8, 8, 8, 8)) table2.add_hline() table2.add_row(("Cash on Cash ROI", 6, 7, 8, 8, 8, 8, 8, 8, 8)) table2.add_hline() table2.add_row(("Loan Balance", 6, 7, 8, 8, 8, 8, 8, 8, 8)) table2.add_hline() table2.add_row(("Cumulative Cash Flow", 6, 7, 8, 8, 8, 8, 8, 8, 8)) table2.add_hline() table2.add_row(("Equity", 6, 7, 8, 8, 8, 8, 8, 8, 8)) table2.add_hline() table3 = Tabular('|c|c|c|') table3.add_hline() table3.add_row((" ", "Monthly", "Annually")) table3.add_hline() table3.add_row(("Repair Cost", 6, 7)) table3.add_hline() table3.add_row(("Vacancy", 6, 7)) table3.add_hline() table3.add_row(("Insurance", 6, 7)) table3.add_hline() table3.add_row(("Taxes", 6, 7)) table3.add_hline() table3.add_row(("hoe", 6, 7)) table3.add_hline() table3.add_row(("Capital Expenditures", 6, 7)) table3.add_hline() table3.add_row(("Property Managment", 6, 7)) table3.add_hline() table3.add_row(("Other Expences", 6, 7)) table3.add_hline() table3.add_row((LargeText(bold("Total")), 6, 7)) table3.add_hline() test1.append(table2) test2.append(table3) section.append(test1) section.append(test2) doc.append(section) doc.append(LineBreak) print('Cap Rate') cap = input() print('Cash on Cash Return') cac = input() print('Retur on investment') roi = input() doc.append( LargeText( bold('Cap Rate :' + cap + '\n\n' + "Cash on Cash Return" + cac + "\n\n" + "Return on Investment" + roi))) doc.generate_pdf("complex_report", clean_tex=False)
def generate_unique(sectors_notirradiated, hv_notirradiated, spark_notirradiated, irradatgif): geometry_options = { "head": "40pt", "margin": "0.5in", "bottom": "1.0in", "includeheadfoot": True } doc = Document(indent=False,geometry_options=geometry_options) # Generating first page style first_page = PageStyle("firstpage") # Header image with first_page.create(Head("L")) as header_left: with header_left.create(MiniPage(width=NoEscape(r"0.49\textwidth"), pos='c')) as logo_wrapper: logo_file = os.path.join(os.path.dirname(__file__), '../cernlogo.png') logo_wrapper.append(StandAloneGraphic(image_options="width=80px", filename=logo_file)) # Add document title with first_page.create(Head("R")) as right_header: with right_header.create(MiniPage(width=NoEscape(r"0.49\textwidth"), pos='c', align='r')) as title_wrapper: title_wrapper.append(LargeText(bold("ATLAS New Small Wheel"))) title_wrapper.append(LineBreak()) title_wrapper.append(bold("Integration Tests")) title_wrapper.append(LineBreak()) title_wrapper.append(bold(now.strftime("%d-%m-%Y"))) title_wrapper.append(LineBreak()) title_wrapper.append("\n") title_wrapper.append(LargeText(bold("Chamber: "+str(chambername)))) title_wrapper.append(LineBreak()) title_wrapper.append("ID: "+str(ID)) title_wrapper.append(LineBreak()) # Add footer with first_page.create(Foot("C")) as footer: with footer.create(Tabularx( "X X X ", width_argument=NoEscape(r"\textwidth"))) as footer_table: footer_table.add_empty_row() footer_table.add_hline(color="blue") branch_address1 = MiniPage( width=NoEscape(r"0.25\textwidth"), pos='t') branch_address1.append("Lorenzo Pezzotti") branch_address1.append("\n") branch_address1.append("*****@*****.**") branch_address2 = MiniPage( width=NoEscape(r"0.25\textwidth"), pos='t') branch_address2.append("Alan Peyaud") branch_address2.append("\n") branch_address2.append("*****@*****.**") branch_address3 = MiniPage( width=NoEscape(r"0.25\textwidth"), pos='t') branch_address3.append("Ivan Gnesi") branch_address3.append("\n") branch_address3.append("*****@*****.**") document_details = MiniPage(width=NoEscape(r"0.2\textwidth"), pos='t', align='r') document_details.append(" ") document_details.append(LineBreak()) document_details.append(simple_page_number()) footer_table.add_row([branch_address1, branch_address2, branch_address3]) doc.append(first_page) # End first page style redcircle = glob.glob("redcircle.png") redcircle = StandAloneGraphic(redcircle, image_options="width=220px") # Add customer information with doc.create(Tabu("X[r]")) as first_page_table: ''' # Add branch information branch = MiniPage(width=NoEscape(r"0.49\textwidth"), pos='t!', align='r') branch.append("Chamber name: ") branch.append(LineBreak()) branch.append("ID: ") branch.append(LineBreak()) first_page_table.add_row([branch]) ''' first_page_table.add_empty_row() doc.change_document_style("firstpage") doc.add_color(name="lightgray", model="gray", description="0.85") doc.add_color(name="lightgray2", model="gray", description="0.6") if irradatgif == "y": title = "HV irradiated" else: title = "HV not irradiated" with doc.create(Section(title, numbering=False)): # Add statement table doc.append("\n") doc.append(timeslot) doc.append(LineBreak()) doc.append(str(deltatime/60)+str("_min")) doc.append(LineBreak()) doc.append("Spike_treshold_0.2_uA") doc.append(LineBreak()) with doc.create(LongTabu("|X[l]|X[r]|X[r]|X[r]|X[r]|", row_height=1.5)) as data_table: data_table.add_hline() data_table.add_row(["Sector", "HV", "spark/min", "Efficiency", "Flag"], mapper=bold, color="lightgray2") data_table.add_hline() data_table.end_table_header() data_table.add_hline() row = ["sector", "hv","spark", "efficiency", "0 or 1"] acceptedlist = [] not_acc_counter = 0 pscolor = "blue" for i in range(len(hv_notirradiated)): if (i % 2) == 0: ''' if int(hv_notirradiated[i]) > 567.9 and spark_notirradiated[i]<1.0: accepted = 1 acceptedlist.append(accepted) else: accepted = 0 acceptedlist.append(accepted) ''' if int(hv_notirradiated[i]) > 567.9: hvcolor = "black" if 548.0 < int(hv_notirradiated[i]) < 567.9: hvcolor = "orange" if int(hv_notirradiated[i])< 548.0: hvcolor = "red" if spark_notirradiated[i] > 6.0: sparkcolor = "red" if spark_notirradiated[i] == 6.0: sparkcolor = "orange" if spark_notirradiated[i] < 6.0: sparkcolor = "black" if efficiency[i] < 80.0: effcolor = "red" if efficiency[i] > 80.0: effcolor = "black" if efficiency == 80.0: effcolor = "orange" if sparkcolor == "red" or hvcolor == "red" or effcolor == "red": acceptedcolor = "red" accepted = 0 acceptedlist.append(accepted) not_acc_counter = not_acc_counter+1 else: acceptedcolor = "black" accepted = 1 acceptedlist.append(accepted) data_table.add_row([str(sectors_notirradiated[i]), TextColor(hvcolor,str(int(hv_notirradiated[i]))), TextColor(sparkcolor, str(round(spark_notirradiated[i],2))), TextColor(effcolor, str(round(efficiency[i],1))), TextColor(acceptedcolor, "V")]) data_table.add_hline() else: ''' if int(hv_notirradiated[i]) > 567.9 and spark_notirradiated[i]<1.0: accepted = 1 acceptedlist.append(accepted) else: accepted = 0 acceptedlist.append(accepted) ''' if int(hv_notirradiated[i]) > 567.9: hvcolor = "black" if 548.0 < int(hv_notirradiated[i]) < 567.9: hvcolor = "orange" if int(hv_notirradiated[i])< 548.0: hvcolor = "red" if spark_notirradiated[i] > 6.0: sparkcolor = "red" if spark_notirradiated[i] == 6.0: sparkcolor = "orange" if spark_notirradiated[i] < 6.0: sparkcolor = "black" if efficiency[i] < 80.0: effcolor = "red" if efficiency[i] > 80.0: effcolor = "black" if efficiency == 80.0: effcolor = "orange" if sparkcolor == "red" or hvcolor == "red" or effcolor == "red": acceptedcolor = "red" accepted = 0 acceptedlist.append(accepted) not_acc_counter = not_acc_counter+1 else: acceptedcolor = "black" accepted = 1 acceptedlist.append(accepted) data_table.add_row([str(sectors_notirradiated[i]), TextColor(hvcolor,str(int(hv_notirradiated[i]))), TextColor(sparkcolor, str(round(spark_notirradiated[i],2))), TextColor(effcolor, str(round(efficiency[i],1))), TextColor(acceptedcolor, "V")], color="lightgray") data_table.add_hline() data_table.add_hline() data_table.add_row("Out of spec", str(len([x for x in hv_notirradiated if x < 548.0])), str(len([x for x in spark_notirradiated if x > 6.0])), str(len([x for x in efficiency if x < 80.0])), str(not_acc_counter)) data_table.add_empty_row() data_table.add_hline() data_table.add_row("Chamber efficiency", "","", "", str(round(total_efficiency))) data_table.add_hline() if "LM2" in chambername: newefficiency = efficiency newefficiency.pop(4) newefficiency.pop(4) newefficiency.pop(8) newefficiency.pop(8) data_table.add_row("Efficiency no LE8", "","", "", str(round(np.mean(newefficiency)))) data_table.add_hline() doc.append(NoEscape('\\clearpage')) with doc.create(Section('Summary', numbering=False)): piecart.create_pie([acceptedlist.count(1), acceptedlist.count(0)], "piechart.pdf") # Add cheque images with doc.create(LongTabu("X[c]")) as summary1_table: pie = glob.iglob("piechart.pdf") #png_list = [StandAloneGraphic(x, image_options="width=120px") for x in png_list] pienew = [StandAloneGraphic(x, image_options="width=220px") for x in pie] summary1_table.add_row([pienew[0]]) #here I have sectors_notirradiated, hv_notirradiated, spark_notirradiated, acceptedlist SM1channels = ["L1","R1","L2","R2","L3","R3","L4","R4","L5","R5"] SM2channels = ["L6","R6","L7","R7","L8","R8"] badresultsall = [] badresultseta = [] badresultsstereo = [] if chambername[0:3] == "SM1": channels = SM1channels if chambername[0:3] == "SM2": channels = SM2channels if chambername[0:3] == "LM1": channels = SM1channels if chambername[0:3] == "LM2": channels = SM2channels for channel in channels: cntall = sum(1 for x, sector in enumerate(sectors_notirradiated) if sector[2:4] == channel and acceptedlist[x] == 1) cnteta = sum(1 for x, sector in enumerate(sectors_notirradiated) if sector[2:4] == channel and (sector[1:2] == "1" or sector[1:2] == "2") and acceptedlist[x] == 1) cntstereo = sum(1 for x, sector in enumerate(sectors_notirradiated) if sector[2:4] == channel and (sector[1:2] == "3" or sector[1:2] == "4") and acceptedlist[x] == 1) badresultsall.append(4-int(cntall)) badresultseta.append(2-int(cnteta)) badresultsstereo.append(2-int(cntstereo)) #doc.append(NewPage()) with doc.create(LongTabu("X[l] X[r] X[r] X[r]", row_height=1.5)) as data_table2: data_table2.add_row(["Sector overimposed (from eta side)", "Eta", "Stereo", "Eta+Stereo"], mapper=bold, color="lightgray2") data_table2.add_empty_row() data_table2.add_hline() row = ["Sector (all layers)", "Out of spec (Eta)", "Out of spec (Stereo)", "Out of spec (E+S)"] for i in range(len(channels)): if (i % 2) == 0: data_table2.add_row([str(channels[i]), str(int(badresultseta[i])), str(badresultsstereo[i]), badresultsall[i]], color="lightgray") else: data_table2.add_row([str(channels[i]), str(int(badresultseta[i])), str(badresultsstereo[i]), badresultsall[i]]) with doc.create(LongTabu("X[l] X[r]", row_height=1.5)) as data_table3: data_table3.add_row(["Layer", "Mean Efficiency"], mapper=bold, color="lightgray2") data_table3.add_empty_row() data_table3.add_hline() row = ["layers", "efficiency"] channelsT3 = ["L1", "L2", "L3", "L4"] for i in range(len(layers_efficiency)): if (i % 2) == 0: data_table3.add_row([str(channelsT3[i]), str(round(layers_efficiency[i],1))], color="lightgray") else: data_table3.add_row([str(channelsT3[i]), str(round(layers_efficiency[i],1))]) doc.append(NewPage()) if irradatgif == "y": title = "Current with irradiation" else: title = "Current with no irradiation" with doc.create(Section(title, numbering=False)): # Add cheque images with doc.create(LongTabu("X[c] X[c] X[c] X[c]")) as cheque_table: png_list = glob.glob('BB5-i*.pdf') png_list.sort(key=os.path.getmtime) png_list = [StandAloneGraphic(x, image_options="width=120px") for x in png_list] print len(png_list) row_image = [] i = 0 for image in png_list: row_image.append(image) i = i +1 if i==4: cheque_table.add_row([row_image[0], row_image[1], row_image[2], row_image[3]]) row_image = [] i=0 png_list = [] doc.generate_pdf("complex_report", clean_tex=False, compiler='pdflatex')
def report(context, json_report, json_varreport, rulegraph_img): config = json_report sample_config = json.load(open(json_report)) var_config = json.load(open(get_config(json_varreport))) tex_path = os.path.abspath( os.path.join(sample_config["analysis"]["analysis_dir"], "delivery_report")) if not rulegraph_img: rulegraph_img = sample_config['analysis']['dag'] os.makedirs(tex_path, exist_ok=True) geometry_options = { "head": "40pt", "headheight": "130pt", "headsep": "1cm", "margin": "1.5cm", "bottom": "1.5cm", "includeheadfoot": True } doc = Document(geometry_options=geometry_options) doc.packages.append(Package('lscape')) doc.packages.append(Package('longtable')) doc.packages.append(Package('float')) doc.packages.append(Package('caption', options='labelfont=bf')) doc.append( NoEscape( r'\captionsetup[table]{labelsep=space, justification=raggedright, singlelinecheck=off}' )) #Add first page style first_page = PageStyle("header", header_thickness=1) #Add Header with first_page.create(Head("C")) as mid_header: with mid_header.create( MiniPage(width=NoEscape(r"0.2\textwidth"), pos='c')) as logo_wrapper: logo_file = os.path.join(os.path.dirname(__file__), '..', 'assests/cg.png') logo_wrapper.append( StandAloneGraphic(image_options="width=50px", filename=logo_file)) with mid_header.create( Tabularx( "p{3cm} p{2cm} X X p{4cm} p{3cm}", width_argument=NoEscape(r"0.8\textwidth"))) as mid_table: mid_table.add_row( [MultiColumn(6, align='r', data=simple_page_number())]) mid_table.add_row([ MultiColumn(6, align='c', data=MediumText("Molecular report on")) ]) mid_table.add_row([ MultiColumn(6, align='c', data=MediumText(get_sample_name(config))) ]) mid_table.add_empty_row() mid_table.add_row([ 'gender', "NA", " ", " ", 'Sample recieved:', sample_config['analysis']['date']['sample_received'] ]) mid_table.add_row([ 'tumor type', "NA", " ", " ", 'Analysis completion:', sample_config['analysis']['date']['analysis_finish'] ]) mid_table.add_row([ 'analysis type', "NA", " ", " ", 'PDF Report date:', datetime.now().strftime("%Y-%m-%d %H:%M") ]) mid_table.add_row( ['sample type', "NA", " ", " ", 'Delivery date', "NA"]) mid_table.add_row([ 'sample origin', "NA", " ", " ", 'Analysis:', r'BALSAMIC v' + sample_config['analysis']['BALSAMIC'] ]) doc.preamble.append(first_page) #End First page # doc.preamble.append( # Command( # 'title', # NoEscape(r'BALSAMIC v' + sample_config["analysis"]["BALSAMIC"] + # r'\\ \large Developer Report'))) # doc.preamble.append( # Command('author', 'Patient ID: ' + get_sample_name(config))) # doc.preamble.append(Command('date', NoEscape(r'\today'))) # doc.append(NoEscape(r'\maketitle')) doc.change_document_style("header") with doc.create(Section(title='Analysis report', numbering=True)): with doc.create( Subsection('Summary of variants and variant callers', numbering=True)): doc.append( "Placeholder for text about BAM alignment metrics and variant callers. Here comes the info on reads, " + "QC metrics, align metrics, and general sample information. preferabily in table format." ) doc.append("\n") summary_tables = ["TMB", "VarClass", "VarCaller", "VarCallerClass"] for i in summary_tables: shellcmd = [ os.path.join(os.path.dirname(os.path.abspath(__file__)), "..", "..", "scripts/VariantReport.R") ] shellcmd.extend([ "--infile", sample_config["vcf"]["merged"]["SNV"], "--genomeSize", sample_config["bed"]["genome_size"], "--type", "latex", "--mode", i, "--outfile", os.path.join(tex_path, sample_config['analysis']['sample_id']) ]) print(" ".join(shellcmd)) outTab = subprocess.check_output(shellcmd) doc.append( NoEscape( outTab.decode('utf-8').replace("\\centering", "\\small"))) doc.append(NoEscape(r'\normalsize')) doc.append(NewPage()) with doc.create(Subsection("Summary of MVL report", numbering=True)): doc.append( "Placeholder for general description of MVL settings. A mention to summary " + "pipeline, summary of MVL settings. Gene coverage for identified genes should go here. Figures!" ) outCov = dict() cmd_param = defaultdict(list) J = defaultdict(list) for i in var_config["filters"]: cmd_param["TUMOR_DP"].append( var_config["filters"][i]["TUMOR"]["DP"]) cmd_param["TUMOR_AD"].append( var_config["filters"][i]["TUMOR"]["AD"]) cmd_param["TUMOR_AFmax"].append( var_config["filters"][i]["TUMOR"]["AF_max"]) cmd_param["TUMOR_AFmin"].append( var_config["filters"][i]["TUMOR"]["AF_min"]) cmd_param["TUMOR_inMVL"].append( var_config["filters"][i]["in_mvl"]) cmd_param["var_type"].append(",".join( ["SNP", "INDEL", "MNP", "OTHER"])) cmd_param["varcaller"].append(",".join( var_config["filters"][i]["variantcaller"])) cmd_param["ann"].append( ",".join(var_config["filters"][i]["annotation"]["SNV"]) + "," + ",".join(var_config["filters"][i]["annotation"]["INDEL"])) cmd_param["name"].append(i.replace("_", "\_")) cmd_param["outfile_tex"].append(tex_path + "/" + i + ".tex") cmd_param["outfile_gene"].append(tex_path + "/" + i + ".genelist") for i in cmd_param: J[i] = ";".join(cmd_param[i]) shellcmd = [ os.path.join(os.path.dirname(os.path.abspath(__file__)), "..", "..", "scripts/VariantReport.R") ] shellcmd.extend([ "--infile", "'" + sample_config["vcf"]["merged"]["SNV"] + "'", "--dp", "'" + J["TUMOR_DP"] + "'", "--tumorad", "'" + J["TUMOR_AD"] + "'", "--afmax", "'" + J["TUMOR_AFmax"] + "'", "--afmin", "'" + J["TUMOR_AFmin"] + "'", "--inMVL", "'" + J["TUMOR_inMVL"] + "'", "--exclusiveSets", "TRUE", "--vartype", "'" + J["var_type"] + "'", "--varcaller", "'" + J["varcaller"] + "'", "--ann", "'" + J["ann"] + "'", "--name", "'" + J["name"] + "'", "--type", "latex" ]) subprocess.check_output( " ".join(shellcmd + ["--outfile", "'" + J["outfile_tex"] + "'"]), shell=True) print(" ".join(shellcmd + ["--outfile", "'" + J["outfile_tex"] + "'"])) subprocess.check_output(" ".join(shellcmd + [ "--outfile", "'" + J["outfile_gene"] + "'", "--exportGene", "T" ]), shell=True) for c, i in enumerate(var_config["filters"]): with doc.create( Subsubsection(var_config["filters"][i]["name"], numbering=True)): print(cmd_param["outfile_tex"]) fname = cmd_param["outfile_tex"][c] if os.stat(fname).st_size > 10: #get gene list with open(cmd_param["outfile_gene"][c]) as myfile: genes = myfile.read().replace('\n', '') with open(fname, 'r') as myfile: data = myfile.read() #.replace('\n', '') #doc.append(NoEscape(r'\begin{landscape}')) #longtable instead of tabular makes the table span multiple pages, but the header doesn't span. Occasionally #the alignment also is messed up. There must be a hidden package conflict OR general alignment issues. #doc.append(NoEscape(varreport.replace("{tabular}","{longtable}"))) doc.append( NoEscape( data.replace("\\centering", "\\scriptsize"))) for s in sample_config["bed"]["exon_cov"]: shellcmd = [ os.path.join( os.path.dirname(os.path.abspath(__file__)), "..", "scripts/CoverageRep.R") ] shellcmd.extend([ "--infile", sample_config["bed"]["exon_cov"][s], "--genename", genes, "--name", s.replace("_", "\_"), "--type", "latex" ]) outCov = subprocess.check_output(shellcmd) doc.append( NoEscape( outCov.decode('utf-8').replace( "\\centering", "\\scriptsize"))) #doc.append(NoEscape(r'\end{landscape}')) else: doc.append("No variants were found for this filter") # doc.append(NoEscape(r'\normalsize')) doc.append(NewPage()) with doc.create(Subsection('Coverage report')): for s in sample_config["bed"]["target_cov"]: with doc.create(Figure(position='h!')) as cov_img: covplot = ".".join( [os.path.join(tex_path, s), "Coverage.pdf"]) shellcmd = [ os.path.join( os.path.dirname(os.path.abspath(__file__)), "..", "..", "scripts/CoveragePlot.R") ] shellcmd.extend([ "--infile", sample_config["bed"]["target_cov"][s], "--outfile", covplot, "--title", s.replace("_", "\_") ]) subprocess.check_output(shellcmd) cov_img.add_image(covplot, width='450px') cov_img.add_caption('Coverage report for sample ' + s.replace("_", "\_")) doc.append(NewPage()) with doc.create(Subsection('Analysis pipeline')): with doc.create(Figure(position='h!')) as pipeline_img: pipeline_img.add_image(rulegraph_img, width='450px') pipeline_img.add_caption('BALSAMIC pipeline') doc.append(NewPage()) with doc.create(Section(title="Appendix", numbering=True)): with doc.create(Subsection("MVL settings", numbering=True)): fmt = "p{3cm}" * (len(var_config["filters"]) + 1) with doc.create(Tabular(fmt)) as data_table: header_row1 = [""] for i in var_config["filters"]: header_row1.append(var_config["filters"][i]["name"]) data_table.add_hline() data_table.add_row(header_row1, mapper=[bold], color="lightgray") data_table.add_hline() data_table.add_empty_row() column = list(var_config["filters"][next( iter(var_config["filters"]))]["TUMOR"].keys()) for i in column: row = [i] for j in var_config["filters"]: row.append(var_config["filters"][j]["TUMOR"][i]) data_table.add_row(row) row = ["MVL"] for i in var_config["filters"]: row.append(var_config["filters"][i]["in_mvl"]) row = ["Variantcallers"] for i in var_config["filters"]: row.append("\n".join( var_config["filters"][i]["variantcaller"])) data_table.add_row(row) data_table.add_hline() with doc.create( Subsection("Bioinformatic tool in pipeline", numbering=True)): doc.append( "The following Bioinformatic tools were used in the analysis:\n\n" ) with doc.create(Tabular("p{4cm}p{4cm}")) as data_table: data_table.add_hline() conda_env = glob.glob( os.path.join(os.path.dirname(os.path.abspath(__file__)), "..", "..", "conda_yaml/*.yaml")) pkgs = get_package_split(conda_env) data_table.add_row(["Package", "Version"], color="lightgray") data_table.add_hline() data_table.add_row( ["BALSAMIC", sample_config['analysis']['BALSAMIC']]) for k, v in pkgs.items(): data_table.add_row([k, v]) doc.append(NewPage()) print(tex_path) doc.generate_tex(os.path.join(tex_path, get_sample_name(config))) # doc.generate_pdf( # os.path.join(tex_path, get_sample_name(config)), clean_tex=False) shellcmd = [ "pdflatex", "-output-directory=" + tex_path, os.path.join(tex_path, get_sample_name(config)) + ".tex", "1>", "/dev/null" ] #generate_pdf doesn't run AUX files properly and ends up with incorrect total page numbers. So subprocess for #pdflatex is called twice instead. print(" ".join(shellcmd)) subprocess.run(" ".join(shellcmd), shell=True) subprocess.run(" ".join(shellcmd), shell=True)
def generate_unique(): geometry_options = { "head": "40pt", "margin": "0.5in", "bottom": "0.6in", "includeheadfoot": True } doc = Document(geometry_options=geometry_options) # Generating first page style first_page = PageStyle("firstpage") # Header image with first_page.create(Head("L")) as header_left: with header_left.create( MiniPage(width=NoEscape(r"0.49\textwidth"), pos='c')) as logo_wrapper: logo_file = os.path.join(os.path.dirname(__file__), 'sample-logo.png') logo_wrapper.append( StandAloneGraphic(image_options="width=120px", filename=logo_file)) # Add document title with first_page.create(Head("R")) as right_header: with right_header.create( MiniPage(width=NoEscape(r"0.49\textwidth"), pos='c', align='r')) as title_wrapper: title_wrapper.append(LargeText(bold("Bank Account Statement"))) title_wrapper.append(LineBreak()) title_wrapper.append(MediumText(bold("Date"))) # Add footer with first_page.create(Foot("C")) as footer: message = "Important message please read" with footer.create( Tabularx( "X X X X", width_argument=NoEscape(r"\textwidth"))) as footer_table: footer_table.add_row( [MultiColumn(4, align='l', data=TextColor("blue", message))]) footer_table.add_hline(color="blue") footer_table.add_empty_row() branch_address = MiniPage(width=NoEscape(r"0.25\textwidth"), pos='t') branch_address.append("960 - 22nd street east") branch_address.append("\n") branch_address.append("Saskatoon, SK") document_details = MiniPage(width=NoEscape(r"0.25\textwidth"), pos='t', align='r') document_details.append("1000") document_details.append(LineBreak()) document_details.append(simple_page_number()) footer_table.add_row([ branch_address, branch_address, branch_address, document_details ]) doc.preamble.append(first_page) # End first page style # Add customer information with doc.create(Tabu("X[l] X[r]")) as first_page_table: customer = MiniPage(width=NoEscape(r"0.49\textwidth"), pos='h') customer.append("Verna Volcano") customer.append("\n") customer.append("For some Person") customer.append("\n") customer.append("Address1") customer.append("\n") customer.append("Address2") customer.append("\n") customer.append("Address3") # Add branch information branch = MiniPage(width=NoEscape(r"0.49\textwidth"), pos='t!', align='r') branch.append("Branch no.") branch.append(LineBreak()) branch.append(bold("1181...")) branch.append(LineBreak()) branch.append(bold("TIB Cheque")) first_page_table.add_row([customer, branch]) first_page_table.add_empty_row() doc.change_document_style("firstpage") doc.add_color(name="lightgray", model="gray", description="0.80") # Add statement table with doc.create(LongTabu("X[l] X[2l] X[r] X[r] X[r]", row_height=1.5)) as data_table: data_table.add_row( ["date", "description", "debits($)", "credits($)", "balance($)"], mapper=bold, color="lightgray") data_table.add_empty_row() data_table.add_hline() row = ["2016-JUN-01", "Test", "$100", "$1000", "-$900"] for i in range(30): if (i % 2) == 0: data_table.add_row(row, color="lightgray") else: data_table.add_row(row) doc.append(NewPage()) # Add cheque images with doc.create(LongTabu("X[c] X[c]")) as cheque_table: cheque_file = os.path.join(os.path.dirname(__file__), 'chequeexample.png') cheque = StandAloneGraphic(cheque_file, image_options="width=200px") for i in range(0, 20): cheque_table.add_row([cheque, cheque]) doc.generate_pdf("complex_report", clean_tex=False)
def generate_unique_dw(final_hvs1, final_hvs2, hl1_ch1, hl2_ch1, hl1_ch2, hl2_ch2, sectors): geometry_options = { "head": "40pt", "margin": "0.5in", "bottom": "1.0in", "includeheadfoot": True } doc = Document(indent=False, geometry_options=geometry_options) # Generating first page style first_page = PageStyle("firstpage") # Header image with first_page.create(Head("L")) as header_left: with header_left.create( MiniPage(width=NoEscape(r"0.49\textwidth"), pos='c')) as logo_wrapper: logo_file = os.path.join(os.path.dirname(__file__), '../cernlogo.png') logo_wrapper.append( StandAloneGraphic(image_options="width=80px", filename=logo_file)) # Add document title with first_page.create(Head("R")) as right_header: with right_header.create( MiniPage(width=NoEscape(r"0.49\textwidth"), pos='c', align='r')) as title_wrapper: title_wrapper.append(LargeText(bold("ATLAS New Small Wheel"))) title_wrapper.append(LineBreak()) title_wrapper.append(bold("Integration Tests")) title_wrapper.append(LineBreak()) title_wrapper.append(bold(now.strftime("%d-%m-%Y"))) title_wrapper.append(LineBreak()) title_wrapper.append("\n") title_wrapper.append( LargeText(bold("Double Wedge: " + str(DW_name)))) title_wrapper.append(LineBreak()) # Add footer with first_page.create(Foot("C")) as footer: with footer.create( Tabularx( "X X X ", width_argument=NoEscape(r"\textwidth"))) as footer_table: footer_table.add_empty_row() footer_table.add_hline(color="blue") branch_address1 = MiniPage(width=NoEscape(r"0.25\textwidth"), pos='t') branch_address1.append("Lorenzo Pezzotti") branch_address1.append("\n") branch_address1.append("*****@*****.**") branch_address2 = MiniPage(width=NoEscape(r"0.25\textwidth"), pos='t') branch_address2.append("Alan Peyaud") branch_address2.append("\n") branch_address2.append("*****@*****.**") branch_address3 = MiniPage(width=NoEscape(r"0.25\textwidth"), pos='t') branch_address3.append("Ivan Gnesi") branch_address3.append("\n") branch_address3.append("*****@*****.**") document_details = MiniPage(width=NoEscape(r"0.2\textwidth"), pos='t', align='r') document_details.append(" ") document_details.append(LineBreak()) document_details.append(simple_page_number()) footer_table.add_row( [branch_address1, branch_address2, branch_address3]) doc.append(first_page) # End first page style redcircle = glob.glob("redcircle.png") redcircle = StandAloneGraphic(redcircle, image_options="width=220px") # Add customer information with doc.create(Tabu("X[r]")) as first_page_table: first_page_table.add_empty_row() doc.change_document_style("firstpage") doc.add_color(name="lightgray", model="gray", description="0.80") doc.append("\n") doc.append(timeslot) doc.append(LineBreak()) # IP with doc.create(Section('IP SIDE', numbering=False)): # first chamber # Verify if its SM1, LM1, SM1 or LM2 if chambername1IP[0:3] == "SM1" or chambername2HO[0:3] == "LM1": limit = 10 else: limit = 6 with doc.create( Subsection("Chambers: " + chambername1IP + " + " + chambername2IP, numbering=False)): with doc.create(Subsection(chambername1IP, numbering=False)): with doc.create( LongTabu("|X[l]|X[r]|X[r]|X[r]|X[r]|X[r]|X[r]|", row_height=1.5)) as data_table: data_table.add_hline() data_table.add_row( ["Sector", "L1", "L2", "L3", "L4", "HL1", "HL2"], mapper=bold, color="lightgray") data_table.add_hline() row = ["blank", "l1", "l2", "l3", "l4", "hl1", "hl2"] for i, hv in enumerate(final_hvs1[0]): hl1_str = "" hl2_str = "" l1 = "" l2 = "" l3 = "" l4 = "" # assign each sector to a line if hv == hl1_ch1: hl1_str = str(hl1_ch1) elif hv == hl2_ch1: hl2_str = str(hl2_ch1) elif i > limit - 1 + limit * 2: l4 = "570" elif i > limit - 1 + limit: l3 = "570" elif i > limit - 1: l2 = "570" else: l1 = "570" if (i % 2) == 0: data_table.add_row([ str(sectors[0][i]), l1, l2, l3, l4, hl1_str, hl2_str ]) else: data_table.add_row([ str(sectors[0][i]), l1, l2, l3, l4, hl1_str, hl2_str ], color="lightgray") data_table.add_hline() # second chamber if chambername2IP[0:3] == "SM1" or chambername2HO[0:3] == "LM1": limit = 10 else: limit = 6 with doc.create(Subsection(chambername2IP, numbering=False)): with doc.create( LongTabu("|X[l]|X[r]|X[r]|X[r]|X[r]|X[r]|X[r]|", row_height=1.5)) as data_table2: data_table2.add_hline() data_table2.add_row( ["Sector", "L1", "L2", "L3", "L4", "HL1", "HL2"], mapper=bold, color="lightgray") data_table2.add_hline() row = ["blank", "l1", "l2", "l3", "l4", "hl1", "hl2"] for i, hv in enumerate(final_hvs1[1]): hl1_str = "" hl2_str = "" l1 = "" l2 = "" l3 = "" l4 = "" # assign each sector to a line if hv == hl1_ch1: hl1_str = str(hl1_ch1) elif hv == hl2_ch1: hl2_str = str(hl2_ch1) elif i > limit - 1 + limit * 2: l4 = "570" elif i > limit - 1 + limit: l3 = "570" elif i > limit - 1: l2 = "570" else: l1 = "570" if (i % 2) == 0: data_table2.add_row([ str(sectors[1][i]), l1, l2, l3, l4, hl1_str, hl2_str ]) else: data_table2.add_row([ str(sectors[1][i]), l1, l2, l3, l4, hl1_str, hl2_str ], color="lightgray") data_table2.add_hline() # HO # Swap R an L final_hvs2[0] = swap(final_hvs2[0]) final_hvs2[1] = swap(final_hvs2[1]) if chambername1HO[0:3] == "SM1" or chambername2HO[0:3] == "LM1": limit = 10 else: limit = 6 doc.append(NewPage()) with doc.create(Section('HO SIDE', numbering=False)): # first chamber with doc.create( Subsection("Chambers: " + chambername1HO + " + " + chambername2HO, numbering=False)): with doc.create(Subsection(chambername1HO, numbering=False)): with doc.create( LongTabu("|X[l]|X[r]|X[r]|X[r]|X[r]|X[r]|X[r]|", row_height=1.5)) as data_table3: data_table3.add_hline() data_table3.add_row( ["Sector", "L1", "L2", "L3", "L4", "HL1", "HL2"], mapper=bold, color="lightgray") data_table3.add_hline() row = ["blank", "l1", "l2", "l3", "l4", "hl1", "hl2"] for i, hv in enumerate(final_hvs2[0]): hl1_str = "" hl2_str = "" l1 = "" l2 = "" l3 = "" l4 = "" # assign each sector to a line if hv == hl1_ch2: hl1_str = str(hl1_ch2) elif hv == hl2_ch2: hl2_str = str(hl2_ch2) elif i > limit - 1 + limit * 2: l4 = "570" elif i > limit - 1 + limit: l3 = "570" elif i > limit - 1: l2 = "570" else: l1 = "570" if (i % 2) == 0: data_table3.add_row([ str(sectors[2][i]), l1, l2, l3, l4, hl1_str, hl2_str ]) else: data_table3.add_row([ str(sectors[2][i]), l1, l2, l3, l4, hl1_str, hl2_str ], color="lightgray") data_table3.add_hline() # second chamber if chambername2HO[0:3] == "SM1" or chambername2HO[0:3] == "LM1": limit = 10 else: limit = 6 with doc.create(Subsection(chambername2HO, numbering=False)): with doc.create( LongTabu("|X[l]|X[r]|X[r]|X[r]|X[r]|X[r]|X[r]|", row_height=1.5)) as data_table4: data_table4.add_hline() data_table4.add_row( ["Sector", "L1", "L2", "L3", "L4", "HL1", "HL2"], mapper=bold, color="lightgray") data_table4.add_hline() row = ["blank", "l1", "l2", "l3", "l4", "hl1", "hl2"] for i, hv in enumerate(final_hvs2[1]): hl1_str = "" hl2_str = "" l1 = "" l2 = "" l3 = "" l4 = "" # assign each sector to a line if hv == hl1_ch2: hl1_str = str(hl1_ch2) elif hv == hl2_ch2: hl2_str = str(hl2_ch2) elif i > limit - 1 + limit * 2: l4 = "570" elif i > limit - 1 + limit: l3 = "570" elif i > limit - 1: l2 = "570" else: l1 = "570" if (i % 2) == 0: data_table4.add_row([ str(sectors[3][i]), l1, l2, l3, l4, hl1_str, hl2_str ]) else: data_table4.add_row([ str(sectors[3][i]), l1, l2, l3, l4, hl1_str, hl2_str ], color="lightgray") data_table4.add_hline() doc.generate_pdf("complex_report_DW", clean_tex=False, compiler='pdflatex')
def generate_report(main_title, name, title, email, payroll): # For saving the report in the Desktop folder dir_output=os.path.join( '~', 'Desktop', 'absconbest_payroll', 'output' ) dir_output=os.path.expanduser(dir_output) geometry_options = { "head": "40pt", "margin": "0.5in", "bottom": "0.6in", "includeheadfoot": True } doc = Document(geometry_options=geometry_options) # Generating # first page style first_page = PageStyle("firstpage") # Header image with first_page.create(Head("L")) as header_left: with header_left.create( MiniPage(width=NoEscape(r"0.49\textwidth"), pos='c') ) as logo_wrapper: logo_file = 'logo.png' logo_wrapper.append( StandAloneGraphic( image_options="width=120px", filename=logo_file ) ) # Add document title with first_page.create(Head("R")) as right_header: with right_header.create(MiniPage( width=NoEscape(r"0.49\textwidth"), pos='c', align='r') ) as title_wrapper: title_wrapper.append(LargeText(bold('Payroll Report'))) title_wrapper.append(LineBreak()) title_wrapper.append(MediumText(bold(main_title))) # Add footer with first_page.create(Foot("C")): first_page.append(simple_page_number()) doc.preamble.append(first_page) #Add employee information with doc.create(Tabu("X[l] X[r]")) as first_page_table: employee = MiniPage(width=NoEscape(r"0.49\textwidth"), pos='h') employee.append(name) employee.append("\n") employee.append(title) employee.append("\n") employee.append(email) #Dummy table branch = MiniPage(width=NoEscape(r"0.49\textwidth"), pos='t!', align='r') # branch.append(bold("1181...")) # branch.append(LineBreak()) # branch.append(bold("TIB Cheque")) first_page_table.add_row([employee, branch]) first_page_table.add_empty_row() doc.change_document_style("firstpage") doc.add_color(name="lightgray", model="gray", description="0.80") #Add payroll table with doc.create(LongTabu("X[l] X[c] X[c] X[c] X[r]", row_height=1.5)) as data_table: data_table.add_row(['Work', 'Rate Per Hour ($)', 'Time in Minutes', 'Time in Hours', 'Wage ($)'], mapper=bold, color="lightgray") data_table.add_empty_row() data_table.add_hline() #Following Pandas' API payroll=payroll.reset_index() for i in range(len(payroll.index)): try: row = [payroll['Work'][i], round(payroll['Rate Per Hour'][i],0), round(payroll['TIM'][i],0), round(payroll['TIH'][i],3), round(payroll['Wage'][i],1)] except TypeError: row = [payroll['Work'][i], 'n/a', round(payroll['TIM'][i],0), round(payroll['TIH'][i],3), round(payroll['Wage'][i],1)] if (i%2)==0: data_table.add_row(row, color="lightgray") else: data_table.add_row(row) # data_table.add_row([payroll['Work'][l_p], # round(payroll['TIM'][l_p],0), # round(payroll['TIH'][l_p],3), # '', # round(payroll['Wage'][l_p],1)] # ) doc.append(NewPage()) doc.generate_pdf( filepath=os.path.join( dir_output, main_title.lower().replace(" ","_").replace(",",""), ), clean_tex=True, clean=True, )