# MS_zjer **Repository Path**: iLester/ms_zjer ## Basic Information - **Project Name**: MS_zjer - **Description**: No description available - **Primary Language**: Unknown - **License**: Not specified - **Default Branch**: master - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 0 - **Forks**: 0 - **Created**: 2025-09-07 - **Last Updated**: 2026-02-06 ## Categories & Tags **Categories**: Uncategorized **Tags**: None ## README # MS ZJER Tools A comprehensive collection of Python utilities for managing master studio operations within the Zhejiang Provincial Basic Education Master Teacher Network Studio system. The tools facilitate automated certificate generation, report creation, and monthly log analysis for educational studios. ## Features ### 1. CertificatesGenerator A robust certificate generation system with both GUI and CLI interfaces: - **GenCertificates**: Command-line interface for batch certificate generation - **GenCertificates_GUI**: Graphical user interface with enhanced usability - Features: - Batch processing from Excel data files - Customizable certificate templates with background images and seals - Support for supplementary certificates (补打 functionality) - Automatic file organization by studio name - Integration with Windows fonts (SimHei support) - Tracking of print dates and counts ### 2. ReportGenerator An automated report generation system that creates detailed studio evaluation reports: - **GenReport_DOC**: Generates Word documents with comprehensive analysis - **GenReport_PDF**: PDF report generation capabilities - Features: - Radar chart visualization comparing studio performance against segment and overall averages - AI-powered evaluation and recommendations using LLM integration - Detailed performance metrics across multiple dimensions (application value, special projects, qualified rates, etc.) - Professional formatting with standardized templates - Automatic report organization with hyperlinked Excel tracking ### 3. MonthlyLogAnalyzer A comprehensive analytics suite for processing monthly studio activity logs: - **1-综合统计数据分析**: Statistical data analysis and cleaning - **2-教研活动日志分析**: Teaching research activity log analysis - **3-直播数据分析**: Live streaming data analysis - Features: - Data cleaning and normalization from raw logs - Calculation of key metrics (visits, member counts, resource creation) - Performance efficiency calculations - Cross-studio comparison analytics ### 4. Utilities and Scripts Additional tools and utilities: - **File Renaming Script**: Batch file renaming with mapping - **Common Utilities**: Shared components and helper functions ## Project Structure ``` ms_zjer/ ├── .gitignore # Git忽略配置 ├── .qwen/ # Qwen Code配置和技能 │ ├── settings.json # Qwen Code设置 │ └── skills/ # Qwen Code技能定义 ├── .trae/ # Trae规则和技能 ├── README.md # 项目说明文档 ├── PROJECT_STRUCTURE.md # 项目结构说明 ├── requirements.txt # 项目依赖 ├── common/ # 公共组件和工具 ├── config/ # 配置文件 ├── resources/ # 资源文件(模板、图片等) ├── utils/ # 实用工具 │ └── File_renaming_script/ # 文件重命名工具 ├── ref/ # 参考资料 │ └── skills/ # 技能参考资料 ├── tests/ # 测试文件 ├── CertificatesGenerator/ # 证书生成器(主要实现) │ ├── GenCertificates/ # 命令行版本 │ └── GenCertificates_GUI/ # 图形界面版本 ├── ReportGenerator/ # 报告生成器(主要实现) │ ├── GenReport_DOC/ # Word报告生成 │ ├── GenReport_PDF/ # PDF报告生成 │ └── gen_StudioSummaries/ # 工作室汇总 └── MonthlyLogAnalyzer/ # 月度日志分析器(主要实现) ├── 1-综合统计数据分析/ ├── 2-教研活动日志分析/ └── 3-直播数据分析/ ``` ## Requirements - Python 3.6+ - Core libraries: pandas, openpyxl, python-docx, reportlab, matplotlib - GUI: tkinter - Networking: requests - PDF generation: reportlab - Excel processing: pandas with openpyxl engine ## Installation ### Option 1: Using pip ```bash pip install -r requirements.txt ``` ### Option 2: Using virtual environment (Recommended) ```bash # Create virtual environment python -m venv venv # Activate virtual environment # On Windows: venv\Scripts\activate # On macOS/Linux: source venv/bin/activate # Install dependencies pip install -r requirements.txt ``` ### Option 3: Using provided activation scripts for different terminals ```bash # For Command Prompt (Windows) activate_venv.bat # For PowerShell (Windows) # Method 1: Using the activation script .\activate_venv.ps1 # Method 2: Direct activation (recommended for PowerShell) & '.\venv\Scripts\Activate.ps1' # For Git Bash (Windows) ./activate_venv.sh ``` ## Development For development, it's recommended to always use the virtual environment to ensure consistent dependencies. The virtual environment contains all required packages for the project. ### Terminal-Specific Instructions #### VS Codium with PowerShell 1. Open VS Codium 2. Open a new terminal (Terminal -> New Terminal) 3. If PowerShell is your default, run: ```powershell .\activate_venv.ps1 ``` #### VS Codium with Git Bash 1. Open VS Codium 2. Open a new terminal (Terminal -> New Terminal) 3. Change the terminal type to Git Bash if needed 4. Run: ```bash ./activate_venv.sh ``` #### Command Line Interface 1. Open Command Prompt or PowerShell 2. Navigate to the project directory 3. Run the appropriate activation script based on your terminal: - For CMD: `activate_venv.bat` - For PowerShell: `.\activate_venv.ps1` - For Git Bash: `./activate_venv.sh` ### Running Python Scripts in Virtual Environment Instead of activating the virtual environment each time, you can use the convenience scripts: ```bash # For Command Prompt run_in_venv.bat your_script.py # For PowerShell .\run_in_venv.ps1 your_script.py # For Git Bash # (Simply activate the environment and run python your_script.py) source venv/Scripts/activate && python your_script.py ``` These scripts will automatically detect if the virtual environment is active, activate it if needed, and then run your Python script. ## Usage ### Certificate Generation ```bash # CLI version cd CertificatesGenerator/GenCertificates python generate_certificates.py # GUI version cd CertificatesGenerator/GenCertificates_GUI python gui_main.py ``` ### Report Generation ```bash # Generate DOCX reports cd ReportGenerator/GenReport_DOC python generate_reports_DOC.py ``` ### Log Analysis ```bash # Data cleaning cd MonthlyLogAnalyzer/1-综合统计数据分析 python Step1_data_cleaning.py # Data analysis python Step2_data_analysis.py ``` ### Utility Scripts ```bash # File renaming cd utils/File_renaming_script python file_renamer.py ``` ## SKILL Interface This project supports integration with SKILL systems. See the `.qwen/skills/` directory for available integrations and examples. ## Contributing Please read [CONTRIBUTING.md](CONTRIBUTING.md) for details on our code of conduct and the process for submitting pull requests. ## Version History See [CHANGELOG.md](CHANGELOG.md) for details of changes in each version. ## Authors - Original Author: Lester - Project Maintainers: [Maintainer Names] ## License This project is licensed under the MIT License - see the [LICENSE.md](LICENSE.md) file for details. ## Acknowledgments - Hat tip to anyone whose code was used - Inspiration from similar educational tools - Thanks to the Zhejiang Provincial Education Department for the opportunity to contribute to education technology