o <5ig @sdZddlZddlmZddlmZddlmZmZddlmZddl m Z dd l m Z    dd e d ed edefddZ   dd e d ed edefddZddZddZedkr_edSdS)a? Money Forward Style Financial Report Generator Usage: python -m src.main html # Generate HTML report (recommended) python -m src.main html --output report.html python -m src.main pdf # Generate PDF report python -m src.main list # List sheets N)Path)datetime) OUTPUT_DIR COMPANY_INFO) sheets_client)fetch_comparison_data)build_financial_reportF target_month output_path open_afterreturnc Csddlm}tdtdt}|stdtdt|dtd|p-td }t |t d t d t d |d }tdt|j dt|j dtd|duretd}t d|d}|jjddd|||}|td|td|jdddtd|rddl} ddl} | dkr| dt|g|S| d kr| jd!t|gdd"|S| d#t|g|S)$zGenerate HTML report Args: target_month: Target month (e.g., '2025-10') output_path: Output path open_after: Open after generation Returns: Generated HTML path r)HTMLReportGeneratoru*📊 Financial Report Generation (HTML)...z+ [1/3] Fetching data from Google Sheets...No data found in spreadsheet. → rows fetchedz [2/3] Parsing data... %Y年%m月name fiscal_yearperiodraw_dataZ company_namerrr  KPIs, P/L itemsz! [3/3] Generating HTML report...N %Y%m%d_%H%M%Sfinancial_report_z.htmlTparentsexist_oku ✅ HTML Report generated:  File size: .1f KBu< 💡 Tip: Open in browser and print (Ctrl+P) to save as PDFrDarwinopenWindowsstartshellxdg-open)Zhtml.generatorrprintr ValueErrorlenrnowstrftimer r annual_kpispl_itemsrparentmkdirgeneratestatst_size subprocessplatformsystemrunstr) r r r rrtarget report_data timestamp generatorr6r7r?P/var/www/tkim.planitai.co.jp/gemegg/20251207-make-pdf-report/project/src/main.pygenerate_html_reportsL "   rAc Csddlm}tdtdtdt}|stdtdt|dtd |p1td }t |t d t d t d |d}tdt|j dt|j dtd|duritd}t d|d}|jjddd|||}|td|jdtdtd|td|jddd|rddl} ddl} | d kr| d!t|g|S| d"kr| jd#t|gdd$|S| d%t|g|S)&z*Generate PDF report (may have font issues)r)ReportGeneratoru)📊 Financial Report Generation (PDF)...u>⚠️ Note: PDF may have font issues for Japanese charactersz+ [1/4] Fetching data from Google Sheets...rrrz [2/4] Parsing data...rrrrrrrz [3/4] Generating PDF...Nrrz.pdfTrz pages generatedz [4/4] Saved!u ✅ PDF generated: rr r!r"rr#r$r%r&r'r))Z pdf.generatorrBr*rr+r,rr-r.r rr/r0rr1r2r3Z total_pagesr4r5r6r7r8r9r:) r r r rBrr;r<r=r>r6r7r?r?r@generate_pdf_report^sP "   rCcCs<tdt}|D]}td|dd|ddq dS)zList spreadsheet sheetsu📋 Spreadsheet Sheets:z - titlez (gid: Zsheet_id)N)r*rZget_all_sheets)ZsheetsZsheetr?r?r@ list_sheetss  rFcCstjdd}|jddd}|jddd}|jd d d dd |jd dtddd|jdddd|jddd}|jd d d dd |jd dtddd|jdddd|jddd|jddd}|jddddgddd|jd d d dd |jd dtddd|jdddd|}|jdkrt|j |j |j ddS|jdkrt |j |j |j ddS|jdkr|j dkrt |j |j |j ddSt|j |j |j ddS|jdkrtdS|td dS)!Nz.Money Forward Style Financial Report Generator)Z descriptioncommandZCommands)ZdesthelpZhtmlz"Generate HTML report (recommended))rHz--monthz-mzTarget month (e.g., 2025-10))rHdefaultz--outputz-ozOutput file path)typerHrIz--openZ store_truezOpen after generation)actionrHZpdfzGenerate PDF reportlistz List sheetsr3z"Generate report (defaults to HTML)z--formatz-fzOutput format (default: html))ZchoicesrIrH)r r r u* 📌 Recommended: python -m src.main html)argparseZArgumentParserZadd_subparsersZ add_parserZ add_argumentrZ parse_argsrGrAZmonthoutputr$rCformatrFZ print_helpr*)ZparserZ subparsersZ html_parserZ pdf_parserZ gen_parserargsr?r?r@mains        rQ__main__)NNF)__doc__rMZpathlibrrZconfigrrrZ data_fetcherrZ data_parserr r:boolrArCrFrQ__name__r?r?r?r@sJ      J Dk