w5i+ DdZddlmZddlZddlZddlmZddlZddlm Z ddl m Z m Z ddl mZddlmZdd lmZdd lmZdd lmZdd lmZej2ej4d d,dZej9ej:ddddej dej:ddddej:ddddej ej:ddd !ej:d"ej dd#$ d-d%Zej9ej:ddddej dd.d&Zej9ej:ddddej dd.d'Z ej9ej:dddd(ej d/d)Z!d,d*Z"e#d+k(re"yy)0z$PlanitAI KPI - Main CLI entry point.) annotationsN)Path)Config)GoogleSheetsClientMockSheetsClient)KPITree) KPICalculator) KPIAnalyzer) GeminiClient) AIAnalyzer)HTMLReportGeneratorz0.1.0)versioncy)z,PlanitAI KPI - AI-powered KPI analysis tool.Nr]/var/www/tkim.planitai.co.jp/gemegg/20251207-make-pdf-report/project/planitai-kpi/src/main.pyclirs rz--configz-cz config.yamlzPath to configuration file.T)exists)defaulthelptypez--periodz-pu4Analysis period (e.g., '2024-11' or '2024年11月').)requiredrz--outputz-oz./outputzOutput directory for reports.z --skip-aiz'Skip AI analysis (faster, for testing).)is_flagrz --mock-dataz6Use mock data from JSON file instead of Google Sheets.)rrc tjdtjdtjd tj|}|j |xs t |}|r6|D]}tjd|dt jdtjd tjd  |rgt|5} tj| } d d d  jd i} | jdi} tjd|ntj} |jj j"r[|jj j$|jj j&|jj j(|jj j*|jj j,|jj j.|jj j0|jj j2|jj j4d }| j7|jj8|jj:d|\} } nh| j7|jj8|jj:|jj<|jj>\} } tjdtA| d|| vr\tjd|tjdtC| jEt jdtjd tGjHjJ}|jM || vr|jO| ||j }|r|D]}tjd|tjdtA|jPdtjd tS}|jU}tjdtA|d|jV}|jXV|jZ}|rd |d!d"nd}tjd#|j\d$|jXd%d&|j^|i}|stjd( j`stjd)ntc|j`}te|}tjd*|jg||d+<tjd,|ji|d-<tjd.|jk||d/<tjd0ntjd3tjd4 tm}|jo|||d5|6}tjd7|tjdtjd9tjd:d;y #t$r:}tjd |dt jdYd }~Nd }~wwxYw#1swYxYw#t$r:}tjd|dt jdYd }~d }~wwxYw#t$r:}tjd|dt jdYd }~/d }~wwxYw#t$r:}tjd'|dt jdYd }~d }~wwxYw#t$r8}tjd1|tjd2Yd }~d }~wwxYw#t$r:}tjd8|dt jdYd }~d }~wwxYw)%% FG ,S-?-? @ (=  67-8-G-G-O * ;<2=2Q2Q2S / BC8C8^8^_e8f !45 78  <= JJ*+ ') ((-!&* )   -k];<  JJrN JJ'( JJ+&JKLW  21#6DA   $ $T  1!54@  &  1!54@  $  04$?  4 > JJ6qc: ; JJ< = = >&  6qc:E  sB[ \%%\;K\%B(]+B+^1C_7;`; \/\\\"\%% ](./]##](+ ^.4/^))^.1 _4:/_//_47 `8-`33`8; a>/a99a>c~tjd tj|}|j }|rJtjd|D]}tjd|t j dytjdtjdt|jdtjd|jjdd d y#t$r9}tjd |d t j dYd}~yd}~wwxYw)zValidate configuration file.u 🔍 Validating configuration...u❌ Validation failed:z - ru✅ Configuration is valid!z KPI nodes definedz - Sheet ID: Nz...u❌ Failed to load config: Tr) r:r;rr<r=r?r@rKr5rGr+rA)r]r`rarbrcs rr=r=s JJ12v&  JJ/ 0 , U5'?+ , HHQK JJ4 5 JJs388}o-?@ A JJ););CR)@(AE F  04$?  sA0C:A1C:: D</D77D<c tj|}tj|j}t j dt j dt j |jy#t$r9}t j d|dtjdYd}~yd}~wwxYw)zDisplay KPI tree structure.u🌳 KPI Tree Structure:ru ❌ Failed: TrrN) rr<rrNr5r:r;to_textrAr?r@)r]r`kpi_treercs rr5r5s v&&&sxx0 -. 2 8##%&  \!%40  sBB C /CCzOutput file path.cd}t|}|jr/tjd|dstjdyt |dd5}|j |dddtjd |tjd tjd tjd tjd tjdtjdtjd tjdy#1swYxYw)z"Create example configuration file.u# PlanitAI KPI Configuration # Google Sheets Settings sheet: sheet_id: "YOUR_SHEET_ID_HERE" data_range: "Sheet1!A1:Z100" target_range: "Targets!A1:Z100" # Optional period_column: "period" # Gemini API Key (use environment variable) gemini_api_key: "${GEMINI_API_KEY}" # Output Settings output_path: "./output" language: "ja" # Credentials file for Google Sheets credentials_path: "credentials.json" # KPI Tree Definition tree: # KGI (Key Goal Indicator) - Top level - id: revenue name: 月間売上 type: kgi formula: "{contracts} * {avg_price}" unit: 円 category: finance children: [contracts, avg_price] # KPI (Key Performance Indicator) - Calculated metrics - id: contracts name: 契約数 type: kpi formula: "{meetings} * {close_rate}" unit: 件 category: sales children: [meetings, close_rate] - id: meetings name: 商談数 type: kpi formula: "{leads} * {meeting_rate}" unit: 件 category: sales children: [leads, meeting_rate] # INPUT - Leaf nodes (manually entered values) - id: avg_price name: 平均単価 type: input unit: 円 category: finance - id: close_rate name: 成約率 type: input unit: "%" category: sales - id: leads name: リード数 type: input unit: 件 category: marketing - id: meeting_rate name: 商談化率 type: input unit: "%" category: marketing 'z' already exists. Overwrite?z Cancelled.Nwzutf-8)encodingu#✅ Created example configuration: rz Next steps:z1 1. Update 'sheet_id' with your Google Sheets IDz, 2. Set GEMINI_API_KEY environment variablez; 3. Place your 'credentials.json' (Google service account)z- 4. Customize the KPI tree for your businessz+Then run: planitai-kpi analyze -p '2024-11')rrr:confirmr;rBwrite)r^example_configpathrds rinitrsGNR  JJrN JJ} JJBC JJ=> JJLM JJ>? JJrN JJ<=  s D66D?cty)zMain entry point.N)rrrrmainrusEr__main__)returnNone) r]strr7rr^rrr>r_z str | Nonerr)r]rrr)r^rrr)$__doc__ __future__rrCr?pathlibrr: src.configrsrc.sheets.clientrr src.kpi.treersrc.kpi.calculatorr src.kpi.analyzerr src.ai.clientr src.ai.analyzerr src.output.htmlr groupversion_optionrcommandoptionrrr=r5rr__name__rrrrsl*"  B ,(&&/ g& '    & 4    ?   (     2  4 A `M `M `M `M `M  `M  `M     8`MF   & 4   .   & 4          \> \>~  zFr