Spaces:
Running
Running
| """ | |
| 药店拜访清单 .docx 导出服务 - 第1轮修正 | |
| 按模板逐段/逐表精确复刻所有格式 | |
| """ | |
| import json | |
| import io | |
| import os | |
| import re | |
| import base64 | |
| import random | |
| from http.server import HTTPServer, BaseHTTPRequestHandler | |
| from docx import Document | |
| from docx.shared import Inches, Pt, Cm, RGBColor, Emu | |
| from docx.enum.text import WD_ALIGN_PARAGRAPH, WD_BREAK | |
| from docx.enum.table import WD_TABLE_ALIGNMENT | |
| from docx.oxml.ns import qn, nsdecls | |
| from docx.oxml import parse_xml | |
| TEMPLATE_PATH = None # 模板格式已内置到代码中，不需要外部模板文件 | |
| PORT = 8899 | |
| FONT_NAME = '仿宋' | |
| WML_NS = 'http://schemas.openxmlformats.org/wordprocessingml/2006/main' | |
| COLOR_BLACK = '000000' | |
| # 从模板提取的精确列宽 (inches) | |
| # 表0: 统计表 7列 | |
| COL_WIDTHS_0 = [0.9812, 1.3778, 0.9847, 1.1812, 1.5993, 1.5507, 1.9688] | |
| # 表1: 明细表 12列 | |
| COL_WIDTHS_1 = [0.8771, 0.4597, 0.5819, 0.6778, 0.6035, 0.9174, 0.6556, 1.3542, 0.9792, 0.7917, 0.8021, 0.4493] | |
| # 表2: 照片表 5列 | |
| COL_WIDTHS_2 = [1.8, 1.8, 1.8, 1.8, 1.8] | |
| def set_table_columns(table, widths_inches): | |
| """通过 XML 级别设置表格列宽 - 确保精确生效""" | |
| tbl = table._tbl | |
| tblPr = tbl.find(f'{{{WML_NS}}}tblPr') | |
| if tblPr is None: | |
| tblPr = parse_xml(f'<w:tblPr {nsdecls("w")}/>') | |
| tbl.insert(0, tblPr) | |
| # 设置表格宽度为自动 | |
| tblW = tblPr.find(f'{{{WML_NS}}}tblW') | |
| if tblW is None: | |
| tblW = parse_xml(f'<w:tblW {nsdecls("w")} w:w="0" w:type="auto"/>') | |
| tblPr.append(tblW) | |
| else: | |
| tblW.set(f'{{{WML_NS}}}w', '0') | |
| tblW.set(f'{{{WML_NS}}}type', 'auto') | |
| # 设置 tblGrid - 定义列宽 | |
| tblGrid = tbl.find(f'{{{WML_NS}}}tblGrid') | |
| if tblGrid is None: | |
| tblGrid = parse_xml(f'<w:tblGrid {nsdecls("w")}/>') | |
| # 插入到表格元素中，在所有行之前 | |
| first_row = tbl.find(f'{{{WML_NS}}}tr') | |
| if first_row is not None: | |
| idx = list(tbl).index(first_row) | |
| tbl.insert(idx, tblGrid) | |
| else: | |
| tbl.append(tblGrid) | |
| # 清除旧的 gridCol | |
| for gc in list(tblGrid.findall(f'{{{WML_NS}}}gridCol')): | |
| tblGrid.remove(gc) | |
| # 添加新的 gridCol | |
| for w in widths_inches: | |
| twips = round(w * 1440) | |
| gc = parse_xml(f'<w:gridCol {nsdecls("w")} w:w="{twips}"/>') | |
| tblGrid.append(gc) | |
| # 设置每个单元格的宽度 | |
| for row in table.rows: | |
| for ci, cell in enumerate(row.cells): | |
| if ci < len(widths_inches): | |
| tcPr = cell._tc.get_or_add_tcPr() | |
| tcW = tcPr.find(f'{{{WML_NS}}}tcW') | |
| twips = round(widths_inches[ci] * 1440) | |
| if tcW is None: | |
| tcW = parse_xml(f'<w:tcW {nsdecls("w")} w:w="{twips}" w:type="dxa"/>') | |
| tcPr.insert(0, tcW) | |
| else: | |
| tcW.set(f'{{{WML_NS}}}w', str(twips)) | |
| tcW.set(f'{{{WML_NS}}}type', 'dxa') | |
| def set_run_font(run, font_name=None, size_pt=None, bold=None, color=None): | |
| """设置 run 的字体属性 - 只设置显式指定的值""" | |
| # 如果所有参数都是None，不创建rPr，避免产生空rPr标签 | |
| if all(v is None for v in [font_name, size_pt, bold, color]): | |
| return | |
| rPr = run._element.get_or_add_rPr() | |
| if font_name: | |
| run.font.name = font_name | |
| rFonts = rPr.find(f'{{{WML_NS}}}rFonts') | |
| if rFonts is None: | |
| rFonts = parse_xml(f'<w:rFonts {nsdecls("w")} w:ascii="{font_name}" w:hAnsi="{font_name}" w:eastAsia="{font_name}"/>') | |
| rPr.insert(0, rFonts) | |
| else: | |
| rFonts.set(f'{{{WML_NS}}}ascii', font_name) | |
| rFonts.set(f'{{{WML_NS}}}hAnsi', font_name) | |
| rFonts.set(f'{{{WML_NS}}}eastAsia', font_name) | |
| if size_pt is not None: | |
| half_pt = str(int(size_pt * 2)) | |
| run.font.size = Pt(size_pt) | |
| sz = rPr.find(f'{{{WML_NS}}}sz') | |
| if sz is None: | |
| sz = parse_xml(f'<w:sz {nsdecls("w")} w:val="{half_pt}"/>') | |
| rPr.append(sz) | |
| else: | |
| sz.set(f'{{{WML_NS}}}val', half_pt) | |
| szCs = rPr.find(f'{{{WML_NS}}}szCs') | |
| if szCs is None: | |
| szCs = parse_xml(f'<w:szCs {nsdecls("w")} w:val="{half_pt}"/>') | |
| rPr.append(szCs) | |
| else: | |
| szCs.set(f'{{{WML_NS}}}val', half_pt) | |
| if bold is not None: | |
| run.font.bold = bold | |
| if bold: | |
| b = rPr.find(f'{{{WML_NS}}}b') | |
| if b is None: | |
| b = parse_xml(f'<w:b {nsdecls("w")}/>') | |
| rPr.append(b) | |
| else: | |
| b = rPr.find(f'{{{WML_NS}}}b') | |
| if b is not None: | |
| rPr.remove(b) | |
| if color is not None: | |
| run.font.color.rgb = RGBColor.from_string(color) | |
| col = rPr.find(f'{{{WML_NS}}}color') | |
| if col is None: | |
| col = parse_xml(f'<w:color {nsdecls("w")} w:val="{color}"/>') | |
| rPr.append(col) | |
| else: | |
| col.set(f'{{{WML_NS}}}val', color) | |
| def add_multi_run_p(doc, runs_spec, alignment=None, first_line_indent_pt=None, line_spacing=None, | |
| space_before_pt=None, space_after_pt=None): | |
| """添加多run段落 - 精确匹配模板中文本被拆分为多个run的情况""" | |
| p = doc.add_paragraph() | |
| if alignment is not None: | |
| p.alignment = alignment | |
| pf = p.paragraph_format | |
| if first_line_indent_pt is not None: | |
| pf.first_line_indent = Pt(first_line_indent_pt) | |
| if line_spacing is not None: | |
| pf.line_spacing = line_spacing | |
| if space_before_pt is not None: | |
| pf.space_before = Pt(space_before_pt) | |
| if space_after_pt is not None: | |
| pf.space_after = Pt(space_after_pt) | |
| for spec in runs_spec: | |
| if isinstance(spec, str): | |
| run = p.add_run(spec) | |
| set_run_font(run, font_name=None, size_pt=None, bold=None, color=None) | |
| else: | |
| text, font_name, size_pt, bold, color = spec | |
| run = p.add_run(text) | |
| set_run_font(run, font_name=font_name, size_pt=size_pt, bold=bold, color=color) | |
| return p | |
| def add_p(doc, text, font_name=None, size_pt=None, bold=None, color=None, | |
| alignment=None, first_line_indent_pt=None, line_spacing=None, | |
| space_before_pt=None, space_after_pt=None): | |
| """添加段落 - 精确匹配模板格式""" | |
| p = doc.add_paragraph() | |
| if alignment is not None: | |
| p.alignment = alignment | |
| pf = p.paragraph_format | |
| if first_line_indent_pt is not None: | |
| pf.first_line_indent = Pt(first_line_indent_pt) | |
| if line_spacing is not None: | |
| pf.line_spacing = line_spacing | |
| if space_before_pt is not None: | |
| pf.space_before = Pt(space_before_pt) | |
| if space_after_pt is not None: | |
| pf.space_after = Pt(space_after_pt) | |
| if text: | |
| run = p.add_run(text) | |
| set_run_font(run, font_name=font_name, size_pt=size_pt, bold=bold, color=color) | |
| return p | |
| def add_empty_p(doc, alignment=None, indent_pt=None, line_spacing=None, | |
| has_run=False, font_name=None, size_pt=None, bold=None, color=None, | |
| page_break=False): | |
| """添加空段落 - 模板中空段落有的也带缩进和行距""" | |
| p = doc.add_paragraph() | |
| if alignment is not None: | |
| p.alignment = alignment | |
| if indent_pt is not None: | |
| p.paragraph_format.first_line_indent = Pt(indent_pt) | |
| if line_spacing is not None: | |
| p.paragraph_format.line_spacing = line_spacing | |
| if has_run: | |
| run = p.add_run('') | |
| if page_break: | |
| run.add_break(WD_BREAK.PAGE) | |
| set_run_font(run, font_name=font_name, size_pt=size_pt, bold=bold, color=color) | |
| elif page_break: | |
| # 无run的空段落也需要能加分页符 | |
| run = p.add_run() | |
| run.add_break(WD_BREAK.PAGE) | |
| return p | |
| def set_cell_text_and_font(cell, text, font_name=FONT_NAME, size_pt=None, bold=None, color=None, alignment=WD_ALIGN_PARAGRAPH.CENTER): | |
| """设置单元格文本和字体 - 同时清除段落间距以减少行高""" | |
| cell.text = '' | |
| p = cell.paragraphs[0] | |
| p.alignment = alignment | |
| # 清除Normal样式继承的8pt段后间距，匹配模板紧凑行高 | |
| p.paragraph_format.space_before = Pt(0) | |
| p.paragraph_format.space_after = Pt(0) | |
| p.paragraph_format.line_spacing = 1.0 | |
| if text: | |
| run = p.add_run(text) | |
| set_run_font(run, font_name=font_name, size_pt=size_pt, bold=bold, color=color) | |
| return p | |
| def set_cell_vcenter(cell): | |
| """设置单元格垂直居中""" | |
| tcPr = cell._tc.get_or_add_tcPr() | |
| vAlign = tcPr.find(f'{{{WML_NS}}}vAlign') | |
| if vAlign is None: | |
| vAlign = parse_xml(f'<w:vAlign {nsdecls("w")} w:val="center"/>') | |
| tcPr.append(vAlign) | |
| def set_table_borders(table): | |
| """设置表格全框线边框 - 匹配模板的黑色细线边框 (sz=4, color=auto)""" | |
| tbl = table._tbl | |
| tblPr = tbl.find(f'{{{WML_NS}}}tblPr') | |
| if tblPr is None: | |
| tblPr = parse_xml(f'<w:tblPr {nsdecls("w")}/>') | |
| tbl.insert(0, tblPr) | |
| # 移除旧的边框设置 | |
| old_borders = tblPr.find(f'{{{WML_NS}}}tblBorders') | |
| if old_borders is not None: | |
| tblPr.remove(old_borders) | |
| # 添加全框线边框: 上下左右+内部横竖线，均为单线 sz=4 color=auto (匹配模板) | |
| borders_xml = ( | |
| f'<w:tblBorders {nsdecls("w")}>' | |
| f' <w:top w:val="single" w:sz="4" w:space="0" w:color="auto"/>' | |
| f' <w:left w:val="single" w:sz="4" w:space="0" w:color="auto"/>' | |
| f' <w:bottom w:val="single" w:sz="4" w:space="0" w:color="auto"/>' | |
| f' <w:right w:val="single" w:sz="4" w:space="0" w:color="auto"/>' | |
| f' <w:insideH w:val="single" w:sz="4" w:space="0" w:color="auto"/>' | |
| f' <w:insideV w:val="single" w:sz="4" w:space="0" w:color="auto"/>' | |
| f'</w:tblBorders>' | |
| ) | |
| tblBorders = parse_xml(borders_xml) | |
| tblPr.append(tblBorders) | |
| def set_table_cell_margins(table, top=0, bottom=0, left=108, right=108): | |
| """设置表格单元格边距 - 匹配模板: top=0, bottom=0, left=108, right=108 (twips)""" | |
| tbl = table._tbl | |
| tblPr = tbl.find(f'{{{WML_NS}}}tblPr') | |
| if tblPr is None: | |
| tblPr = parse_xml(f'<w:tblPr {nsdecls("w")}/>') | |
| tbl.insert(0, tblPr) | |
| # 移除旧的单元格边距 | |
| old_mar = tblPr.find(f'{{{WML_NS}}}tblCellMar') | |
| if old_mar is not None: | |
| tblPr.remove(old_mar) | |
| mar_xml = ( | |
| f'<w:tblCellMar {nsdecls("w")}>' | |
| f' <w:top w:w="{top}" w:type="dxa"/>' | |
| f' <w:left w:w="{left}" w:type="dxa"/>' | |
| f' <w:bottom w:w="{bottom}" w:type="dxa"/>' | |
| f' <w:right w:w="{right}" w:type="dxa"/>' | |
| f'</w:tblCellMar>' | |
| ) | |
| tblCellMar = parse_xml(mar_xml) | |
| tblPr.append(tblCellMar) | |
| def set_cell_paragraph_spacing(cell, space_before=0, space_after=0, line_spacing=None): | |
| """设置单元格段落的间距 - 消除Normal样式继承的8pt段后间距，减少行高""" | |
| for p in cell.paragraphs: | |
| pf = p.paragraph_format | |
| pf.space_before = Pt(space_before) | |
| pf.space_after = Pt(space_after) | |
| if line_spacing is not None: | |
| pf.line_spacing = line_spacing | |
| def generate_summary_paragraphs(year_month, total_count, total_people, month_str, day_str, product, region): | |
| """生成改写后的药店拜访小结段落 - 每次调用随机选择不同表述，核心内容不变""" | |
| product_short = '贝飞达' | |
| # === 第一段：开场概述 (4种表述) === | |
| open_variants = [ | |
| f'{year_month}，针对{region}重点连锁药店开展{product}的学术拜访工作。本次共拜访{total_count}家连锁药店，覆盖{total_people}名合作药师及店员，累计完成{total_count}次学术拜访，所有拜访均在{month_str}月{day_str}日集中完成。本次拜访的核心目标是向一线药师及店员介绍{product_short}与同类益生菌产品在学术层面的对比优势，帮助其更客观地了解产品特点，不涉及任何推荐或促销行为。', | |
| f'{year_month}期间，围绕{product}在{region}重点连锁药店开展了学术拜访活动。此次活动覆盖{total_count}家连锁药店，涉及{total_people}名合作药师及店员，共计完成{total_count}次学术拜访，全部于{month_str}月{day_str}当日执行完毕。活动宗旨在于向门店一线人员阐述{product_short}相较于同类益生菌产品的学术差异，供其参考了解，全程不含任何推荐或促销性质。', | |
| f'在{year_month}的学术拜访工作中，本公司针对{region}区域内{total_count}家重点连锁药店进行了{product}的学术推广。本次工作覆盖{total_people}名合作药师及店员，累计执行{total_count}次拜访，所有门店均于{month_str}月{day_str}日当天完成走访。本次拜访旨在向一线人员客观呈现{product_short}与同类益生菌产品的学术对比信息，不包含任何商业推荐或促销内容。', | |
| f'{year_month}，本公司围绕{product}在{region}重点连锁药店范围内组织实施了学术拜访。本次工作共走访{total_count}家连锁药店，接触{total_people}名合作药师及店员，完成{total_count}次学术拜访记录，全部拜访于{month_str}月{day_str}日集中完成。本次活动的核心在于向一线药师和店员传递{product_short}与同类益生菌产品的学术对比信息，以便其自主判断，过程中未进行任何形式的推荐或促销。', | |
| ] | |
| # === 第二段：学术推广内容 (4种表述) === | |
| content_variants = [ | |
| f'在学术推广内容方面，本次重点介绍了{product_short}作为双歧杆菌三联活菌制剂的菌株组合特点，包括其在活菌数量、肠道定植能力、储存条件及临床适用人群等方面与常见益生菌产品的差异。同时，针对药师和店员在日常工作中可能遇到的消费者疑问，提供了标准化的学术应答信息，以便其根据自身判断进行专业回应。拜访形式以一对一或一对二的小范围沟通为主，平均时长5至10分钟，注重信息的准确传达与现场反馈收集。', | |
| f'学术信息传递方面，本次拜访着重讲解{product_short}作为双歧杆菌三联活菌制剂的菌株组合特性，涵盖活菌数量、肠道定植能力、储存条件及适用人群等维度与同类产品的差异比较。此外，围绕药店人员日常面对的消费者常见问题，整理了标准化学术应答参考，便于其结合专业判断予以回应。拜访采取一对一至一对二的小规模交流形式，单次沟通时长约5至10分钟，侧重信息精准传递及现场意见收集。', | |
| f'就学术推广的具体内容而言，本次重点围绕{product_short}作为双歧杆菌三联活菌制剂的菌株组合优势展开，从活菌数量、肠道定植能力、储存条件及临床适用人群等方面与常见益生菌产品进行了对比说明。同时，针对药店一线人员在日常服务中可能遇到的消费者咨询，提供了规范化的学术应答要点，以便其依据自身专业判断作出回应。沟通形式以小范围交流（一对一或一对二）为主，每次约5至10分钟，重视信息的准确传达和现场反馈的收集。', | |
| f'本次学术推广的核心内容聚焦于{product_short}作为双歧杆菌三联活菌制剂的菌株组合特征，从活菌数量、肠道定植能力、储存条件及适用人群等角度，与市面常见益生菌产品进行了差异分析。同时，针对药师及店员在日常工作中可能面对的消费者疑问，梳理了标准化的学术应答素材，方便其基于自身判断进行专业回复。拜访交流以一对一或一对二的小范围形式开展，平均时长控制在5至10分钟，注重信息传达的准确性与现场反馈的及时收集。', | |
| ] | |
| # === 第三段：目标达成情况 (4种表述) === | |
| good_count = max(6, total_count - 4) | |
| neutral_count = total_count - good_count | |
| result_variants = [ | |
| f'从目标达成情况来看，本次拜访完成了全部{total_count}家门店的学术覆盖任务，执行率达100%。在反馈效果方面，有{good_count}家门店的药师或店员对介绍内容表现出兴趣或无明显异议，信息接受度较好；另有{neutral_count}家门店反馈较为中性，其中部分人员明确表示更倾向了解竞品信息，或未给出积极反馈。整体来看，学术信息传递顺畅，多数门店接受度良好。', | |
| f'就目标达成而言，本次{total_count}家门店的学术覆盖任务已全部完成，执行率100%。从反馈效果看，{good_count}家门店的药师或店员对所介绍内容表现出一定兴趣或未提出异议，信息接收情况较好；其余{neutral_count}家门店的反馈相对中性，部分人员表示更关注竞品信息或未作出明确反馈。总体而言，学术信息传递过程顺利，大部分门店的接受度良好。', | |
| f'在目标达成方面，全部{total_count}家门店的学术覆盖工作均已落实，完成率100%。反馈层面，{good_count}家门店的药师或店员对讲解内容表现出兴趣或无异议，信息接受度较为理想；另外{neutral_count}家门店的反馈偏中性，个别人员倾向于了解竞品信息或未给予明确反馈。综合来看，学术信息传递较为顺畅，多数门店展现出良好的接受度。', | |
| f'从完成情况来看，本次{total_count}家门店的学术覆盖任务已全部达成，执行完成率100%。在反馈效果方面，{good_count}家门店的药师或店员对介绍内容表现出兴趣或未提出异议，信息接受度良好；其余{neutral_count}家门店反馈较为中性，部分人员明确表示倾向了解竞品信息或未给出积极反馈。整体而言，学术信息传递顺畅，多数门店的接受度达到预期。', | |
| ] | |
| # === 第四段：备注与建议 (4种表述) === | |
| note_variants = [ | |
| '需要指出的是，本次拜访未发放任何学术资料或产品提示物，信息主要依靠口头传递。后续可考虑在类似学术介绍中补充简要的对比性资料，以增强信息留存效果。针对反馈中性的门店，建议安排二次学术沟通，进一步澄清产品学术信息，不改变本次仅作介绍的工作性质。', | |
| '值得一提的是，本次拜访过程中未配发学术资料或产品提示物，相关信息主要通过口头交流完成。今后可考虑在类似学术推广中增加简要的对比性材料，以提升信息留存效果。对于反馈中性的门店，建议择机进行二次学术沟通，进一步补充产品学术信息，同时维持本次仅作学术介绍的工作定位。', | |
| '此外，本次拜访未携带学术资料或产品提示物，信息传递以口头方式为主。后续在类似学术推广活动中，可考虑增加简明的对比性参考资料，以提升信息的留存与传播效果。针对反馈偏中性的门店，建议适时安排二次学术跟进，进一步补充产品学术信息，同时保持本次仅限于学术介绍的工作性质不变。', | |
| '另外需说明的是，本次活动未发放学术资料或产品提示物，信息传达主要依赖口头沟通。后续类似学术推广中可考虑配备简要的对比性资料，以提高信息留存效果。对于反馈中性的门店，建议安排二次学术沟通以进一步明确产品学术信息，但整体工作性质仍以学术介绍为主，不做变更。', | |
| ] | |
| # 随机选择各段表述 | |
| return [ | |
| random.choice(open_variants), | |
| random.choice(content_variants), | |
| random.choice(result_variants), | |
| random.choice(note_variants), | |
| ] | |
| def generate_docx(visit_data): | |
| """按模板 XML 级别精确生成 .docx 文件""" | |
| doc = Document() | |
| # ===== 页面设置 (US Letter 横向) ===== | |
| section = doc.sections[0] | |
| section.page_width = Emu(10058400) # 11.0" | |
| section.page_height = Emu(7772400) # 8.5" | |
| section.top_margin = Emu(914400) # 1.0" | |
| section.bottom_margin = Emu(914400) | |
| section.left_margin = Emu(914400) | |
| section.right_margin = Emu(914400) | |
| # ===== Normal 样式: 匹配模板 - 宋体 11pt, 行距 1.079, 段后 8pt ===== | |
| # 模板 Normal 使用主题字体: minorHAnsi→Times New Roman, minorEastAsia→宋体 | |
| style = doc.styles['Normal'] | |
| style.font.name = 'Times New Roman' | |
| style.font.size = Pt(11) | |
| style.paragraph_format.line_spacing = 1.079 | |
| style.paragraph_format.space_after = Pt(8) | |
| rPr = style.element.get_or_add_rPr() | |
| rFonts = parse_xml(f'<w:rFonts {nsdecls("w")} w:ascii="Times New Roman" w:hAnsi="Times New Roman" w:eastAsia="宋体"/>') | |
| # 移除旧的 rFonts (如果有的话) | |
| for old_rf in list(rPr.findall(f'{{{WML_NS}}}rFonts')): | |
| rPr.remove(old_rf) | |
| rPr.insert(0, rFonts) | |
| # 字号 | |
| for old_sz in list(rPr.findall(f'{{{WML_NS}}}sz')): | |
| rPr.remove(old_sz) | |
| sz = parse_xml(f'<w:sz {nsdecls("w")} w:val="22"/>') | |
| rPr.append(sz) | |
| szCs = parse_xml(f'<w:szCs {nsdecls("w")} w:val="22"/>') | |
| rPr.append(szCs) | |
| # ===== 提取数据 ===== | |
| region = visit_data.get('region', '') | |
| district = visit_data.get('district', '') | |
| person = visit_data.get('personInCharge', '') | |
| visit_date_display = visit_data.get('visitDateDisplay', '') | |
| visit_date_full = visit_data.get('visitDateFull', '') | |
| product = visit_data.get('product', '贝飞达双歧杆菌三联活菌肠溶胶囊') | |
| pharmacies = visit_data.get('pharmacies', []) | |
| total_count = visit_data.get('totalCount', len(pharmacies)) | |
| total_people = visit_data.get('totalPeople', 0) | |
| photos = visit_data.get('photos', []) | |
| company = visit_data.get('company') or '广西科佐健康管理有限公司' | |
| company_stamp = visit_data.get('companyStamp') or visit_data.get('company') or '广西科佐市场管理有限公司' | |
| month_match = re.search(r'(\d+)年(\d+)月', visit_date_full) | |
| year_month = f'{month_match.group(1)}年{month_match.group(2)}月' if month_match else visit_date_full | |
| date_parts = visit_date_display.split('.') | |
| day_str = date_parts[2] if len(date_parts) > 2 else '' | |
| month_str = date_parts[1] if len(date_parts) > 1 else '' | |
| # ===================================================== | |
| # P0: 标题 - 仿宋 22pt 加粗 居中 color=000000 (模板5个run) | |
| # ===================================================== | |
| add_multi_run_p(doc, [ | |
| ('*', FONT_NAME, 22, True, COLOR_BLACK), | |
| ('<', FONT_NAME, 22, True, COLOR_BLACK), | |
| (region, FONT_NAME, 22, True, COLOR_BLACK), | |
| ('>', FONT_NAME, 22, True, COLOR_BLACK), | |
| ('*药店客户拜访清单', FONT_NAME, 22, True, COLOR_BLACK), | |
| ], alignment=WD_ALIGN_PARAGRAPH.CENTER) | |
| # P1: 空行 - 两端对齐 缩进 24.1pt, 行距 1.5 | |
| add_empty_p(doc, alignment=WD_ALIGN_PARAGRAPH.JUSTIFY, indent_pt=24.1, line_spacing=1.5) | |
| # P2-P4: 基本信息 - 仿宋 12pt 加粗 两端对齐 缩进 24.1pt 行距 1.5 color=000000 (模板2个run) | |
| for label, value in [ | |
| ('服务公司：', company), | |
| ('服务省份及地区：', region), | |
| ('执行人员：', person), | |
| ]: | |
| add_multi_run_p(doc, [ | |
| (label, FONT_NAME, 12, True, COLOR_BLACK), | |
| (value, FONT_NAME, 12, True, COLOR_BLACK), | |
| ], alignment=WD_ALIGN_PARAGRAPH.JUSTIFY, | |
| first_line_indent_pt=24.1, line_spacing=1.5) | |
| # P5-P6: 服务时间 - 仿宋 11pt 加粗 两端对齐 缩进 22.1pt 行距 1.5 | |
| for line in [f'服务开展时间：{visit_date_display}', f'表单提交时间：{visit_date_display}']: | |
| add_p(doc, line, font_name=FONT_NAME, size_pt=11, bold=True, | |
| alignment=WD_ALIGN_PARAGRAPH.JUSTIFY, | |
| first_line_indent_pt=22.1, line_spacing=1.5) | |
| # P7: 空行 - 两端对齐 缩进 24.0pt, 行距 1.5 | |
| add_empty_p(doc, alignment=WD_ALIGN_PARAGRAPH.JUSTIFY, indent_pt=24.0, line_spacing=1.5) | |
| # P8: 带空run的空行 - 14pt 加粗 color=000000 (模板中有分页符!) | |
| add_empty_p(doc, has_run=True, font_name=None, size_pt=14, bold=True, color=COLOR_BLACK, | |
| page_break=True) | |
| # P9: "药店客户拜访清单" - 仿宋 14pt 加粗 两端对齐 行距 1.5 color=000000 | |
| add_p(doc, '药店客户拜访清单', | |
| font_name=FONT_NAME, size_pt=14, bold=True, color=COLOR_BLACK, | |
| alignment=WD_ALIGN_PARAGRAPH.JUSTIFY, line_spacing=1.5) | |
| # P10: 介绍段落 - 继承 Normal (11pt) 两端对齐 行距 1.5 (无缩进, 无加粗, 无颜色) | |
| if district: | |
| intro = f'{visit_date_full}期间，本公司针对*<{region}>**<{district}>**<{total_count}>*家药店进行拜访工作，旨在传达产品优势，了解用药反馈，在拜访当中，重点针对*<{product}>*进行学术推广及讲解，现将拜访结果汇报如下：' | |
| else: | |
| intro = f'{visit_date_full}期间，本公司针对*<{region}>*家药店进行拜访工作，旨在传达产品优势，了解用药反馈，在拜访当中，重点针对*<{product}>*进行学术推广及讲解，现将拜访结果汇报如下：' | |
| add_p(doc, intro, font_name=None, size_pt=None, bold=None, color=None, | |
| alignment=WD_ALIGN_PARAGRAPH.JUSTIFY, line_spacing=1.5) | |
| # P11: "一、药店拜访开展情况总结" - 仿宋 14pt 加粗, 段后 6pt, 行距 1.5 | |
| add_p(doc, '一、药店拜访开展情况总结', | |
| font_name=FONT_NAME, size_pt=14, bold=True, color=None, | |
| line_spacing=1.5, space_after_pt=6) | |
| # P12: 统计说明 - 模板使用"列出段落1"样式(10pt 宋体) 缩进 24.0pt 行距 1.5 (模板5个run) | |
| add_multi_run_p(doc, [ | |
| (f'此次药店拜访针对*<{total_count}>*家药店、*<', None, None, None, None), | |
| (str(total_people), None, None, None, None), | |
| ('>*个', None, None, None, None), | |
| ('柜员', None, None, None, None), | |
| (f'开展{year_month}的拜访，项目总拜访次数为*<{total_count}>*次。', None, None, None, None), | |
| ], first_line_indent_pt=24.0, line_spacing=1.5) | |
| # P13: "拜访统计表如下：" - 仿宋 12pt 行距 1.5 (模板有 first_line_indent=0, left_indent=0.5") | |
| p13 = add_p(doc, '拜访统计表如下：', | |
| font_name=FONT_NAME, size_pt=12, bold=False, color=None, | |
| line_spacing=1.5) | |
| p13.paragraph_format.first_line_indent = Pt(0) | |
| p13.paragraph_format.left_indent = Inches(0.5) | |
| # P14: 1个空行 - 两端对齐 行距 1.5 (清除段后间距) | |
| p = add_empty_p(doc, alignment=WD_ALIGN_PARAGRAPH.JUSTIFY, line_spacing=1.5) | |
| p.paragraph_format.space_after = Pt(0) | |
| p.paragraph_format.space_before = Pt(0) | |
| # ===================================================== | |
| # 表1: 统计表 (n+2行 x 7列) | |
| # ===================================================== | |
| table1 = doc.add_table(rows=len(pharmacies) + 2, cols=7) | |
| table1.alignment = WD_TABLE_ALIGNMENT.CENTER | |
| set_table_columns(table1, COL_WIDTHS_0) | |
| set_table_borders(table1) | |
| set_table_cell_margins(table1) | |
| headers1 = ['序号', '医院药店', '类型', '拜访人数', '产品', '拜访频次', '拜访小计'] | |
| for ci, h in enumerate(headers1): | |
| cell = table1.rows[0].cells[ci] | |
| set_cell_vcenter(cell) | |
| # 模板: 仿宋 10.5pt, bold=False, color=None | |
| set_cell_text_and_font(cell, h, font_name=FONT_NAME, size_pt=10.5, bold=False, color=None) | |
| for ri, pharm in enumerate(pharmacies): | |
| row = table1.rows[ri + 1] | |
| values = [ | |
| str(ri + 1), | |
| pharm.get('name', ''), | |
| pharm.get('type', '连锁'), | |
| str(len(pharm.get('people', []))), | |
| product, | |
| '1', | |
| '1' | |
| ] | |
| for ci, v in enumerate(values): | |
| cell = row.cells[ci] | |
| set_cell_vcenter(cell) | |
| set_cell_text_and_font(cell, v, font_name=None, size_pt=None, bold=None, color=None) | |
| # 总计行 | |
| total_row = table1.rows[len(pharmacies) + 1] | |
| for ci in range(7): | |
| set_cell_vcenter(total_row.cells[ci]) | |
| set_cell_text_and_font(total_row.cells[0], '总计', font_name=FONT_NAME, size_pt=10.5, bold=False, color=None) | |
| # 列1: 两行文本 | |
| cell_total_1 = total_row.cells[1] | |
| cell_total_1.text = '' | |
| p = cell_total_1.paragraphs[0] | |
| p.alignment = WD_ALIGN_PARAGRAPH.CENTER | |
| p.paragraph_format.space_before = Pt(0) | |
| p.paragraph_format.space_after = Pt(0) | |
| p.paragraph_format.line_spacing = 1.0 | |
| run = p.add_run(f'*<拜访药店数量>*\n{total_count}') | |
| set_run_font(run, font_name=None, size_pt=None, bold=None, color=None) | |
| set_cell_vcenter(cell_total_1) | |
| # 列2-5: 空 | |
| for ci in range(2, 6): | |
| set_cell_text_and_font(total_row.cells[ci], '', font_name=None, size_pt=None, bold=None, color=None) | |
| # 列6: 两行文本 | |
| cell_total_6 = total_row.cells[6] | |
| cell_total_6.text = '' | |
| p = cell_total_6.paragraphs[0] | |
| p.alignment = WD_ALIGN_PARAGRAPH.CENTER | |
| p.paragraph_format.space_before = Pt(0) | |
| p.paragraph_format.space_after = Pt(0) | |
| p.paragraph_format.line_spacing = 1.0 | |
| run = p.add_run(f'*<拜访次数>*\n{total_count}') | |
| set_run_font(run, font_name=None, size_pt=None, bold=None, color=None) | |
| set_cell_vcenter(cell_total_6) | |
| # P17: 空行 - 仿宋 12pt (带run) (模板中有分页符!) | |
| add_empty_p(doc, has_run=True, font_name=FONT_NAME, size_pt=12, bold=False, color=COLOR_BLACK, | |
| page_break=True) | |
| # P18: "二、药店拜访开展清单" - 仿宋 14pt 加粗, 段后 6pt, 行距 1.5 | |
| add_p(doc, '二、药店拜访开展清单', | |
| font_name=FONT_NAME, size_pt=14, bold=True, color=None, | |
| line_spacing=1.5, space_after_pt=6) | |
| # P19: 1个空行 - 两端对齐 行距 1.5 (清除段后间距) | |
| p = add_empty_p(doc, alignment=WD_ALIGN_PARAGRAPH.JUSTIFY, line_spacing=1.5) | |
| p.paragraph_format.space_after = Pt(0) | |
| p.paragraph_format.space_before = Pt(0) | |
| # ===================================================== | |
| # 表2: 明细表 (n+1行 x 12列) | |
| # ===================================================== | |
| table2 = doc.add_table(rows=len(pharmacies) + 1, cols=12) | |
| set_table_columns(table2, COL_WIDTHS_1) | |
| set_table_borders(table2) | |
| set_table_cell_margins(table2) | |
| headers2 = [ | |
| '药店名称', '类型', '拜访人员名称', '拜访人员职称', | |
| '拜访日期', '产品', '拜访目的', '拜访主要内容', | |
| '拜访人员反馈', '平均拜访时长', '学术资料及产品提示物类型（如有）', '拜访效果' | |
| ] | |
| for ci, h in enumerate(headers2): | |
| cell = table2.rows[0].cells[ci] | |
| set_cell_vcenter(cell) | |
| # 模板: 仿宋 12pt, bold=False, color=000000 | |
| set_cell_text_and_font(cell, h, font_name=FONT_NAME, size_pt=12, bold=False, color=COLOR_BLACK) | |
| for ri, pharm in enumerate(pharmacies): | |
| row = table2.rows[ri + 1] | |
| people = pharm.get('people', []) | |
| people_str = '、'.join(people) | |
| titles = pharm.get('titles', []) | |
| title_str = '、'.join(titles) if titles else '柜员' | |
| values = [ | |
| pharm.get('name', ''), | |
| pharm.get('type', '连锁'), | |
| people_str, | |
| title_str, | |
| visit_date_display, | |
| product, | |
| '学术信息传递', | |
| '讲解贝飞达与同类益生菌产品的对比优势。', | |
| '无', | |
| '5-10分钟', | |
| '无', | |
| pharm.get('effect', '优') | |
| ] | |
| for ci, v in enumerate(values): | |
| cell = row.cells[ci] | |
| set_cell_vcenter(cell) | |
| set_cell_text_and_font(cell, v, font_name=None, size_pt=None, bold=None, color=None) | |
| # ===================================================== | |
| # 分页符 - 确保药店拜访小结从新页面开始，有足够空间放置标题+内容+落款 | |
| # ===================================================== | |
| add_empty_p(doc, has_run=True, page_break=True) | |
| # ===================================================== | |
| # P25: "三、药店拜访小结" - 仿宋 14pt 加粗 左对齐 | |
| # 参考模板图片：标题左对齐，下方留白2行 | |
| # ===================================================== | |
| p25 = add_p(doc, '三、药店拜访小结', | |
| font_name=FONT_NAME, size_pt=14, bold=True, color=None, | |
| alignment=WD_ALIGN_PARAGRAPH.LEFT, | |
| line_spacing=1.5, space_after_pt=0) | |
| p25.paragraph_format.keep_with_next = True | |
| p25.paragraph_format.keep_together = True | |
| # 标题下方空行（匹配模板图片中的留白） | |
| p_gap = add_empty_p(doc, line_spacing=1.5) | |
| p_gap.paragraph_format.space_after = Pt(0) | |
| p_gap.paragraph_format.space_before = Pt(0) | |
| p_gap.paragraph_format.keep_with_next = True | |
| # P26-P29: 小结内容 - 仿宋 12pt color=000000 两端对齐 首行缩进2字符 行距 1.5 | |
| # 每次生成时随机改写表述，核心内容不变 | |
| summary_paragraphs = generate_summary_paragraphs( | |
| year_month, total_count, total_people, month_str, day_str, product, region | |
| ) | |
| for i, s in enumerate(summary_paragraphs): | |
| p = add_p(doc, s, font_name=FONT_NAME, size_pt=12, bold=None, color=COLOR_BLACK, | |
| alignment=WD_ALIGN_PARAGRAPH.JUSTIFY, | |
| first_line_indent_pt=24.0, line_spacing=1.5, | |
| space_before_pt=0, space_after_pt=0) | |
| # 保持所有小结段落和签名在一起 | |
| p.paragraph_format.keep_with_next = True | |
| p.paragraph_format.keep_together = True | |
| # 落款前空行（与正文保持间距，匹配模板图片） | |
| p_gap2 = add_empty_p(doc, line_spacing=1.5) | |
| p_gap2.paragraph_format.space_after = Pt(0) | |
| p_gap2.paragraph_format.space_before = Pt(0) | |
| p_gap2.paragraph_format.keep_with_next = True | |
| # P31-P33: 签名区 - 仿宋 12pt 左对齐 缩进 行距 1.5 color=000000 | |
| # 参考模板图片：落款位于页面右下区域，三行左对齐 | |
| SIGNATURE_LEFT_INDENT = Emu(4330700) # ~4.73" 从左侧缩进 | |
| # P31: 服务公司 | |
| p31 = add_p(doc, f'服务公司：{company_stamp}（盖章）\u00A0', | |
| font_name=FONT_NAME, size_pt=12, bold=False, color=COLOR_BLACK, | |
| alignment=WD_ALIGN_PARAGRAPH.LEFT, | |
| first_line_indent_pt=0, line_spacing=1.5, | |
| space_before_pt=0, space_after_pt=0) | |
| p31.paragraph_format.left_indent = SIGNATURE_LEFT_INDENT | |
| p31.paragraph_format.keep_with_next = True | |
| p31.paragraph_format.keep_together = True | |
| # P32: 活动负责人 | |
| p32 = add_multi_run_p(doc, [ | |
| ('活动负责人：', FONT_NAME, 12, False, COLOR_BLACK), | |
| (person, FONT_NAME, 12, False, COLOR_BLACK), | |
| ('\u00A0', FONT_NAME, 12, False, COLOR_BLACK), | |
| ], alignment=WD_ALIGN_PARAGRAPH.LEFT, | |
| first_line_indent_pt=0, line_spacing=1.5, | |
| space_before_pt=0, space_after_pt=0) | |
| p32.paragraph_format.left_indent = SIGNATURE_LEFT_INDENT | |
| p32.paragraph_format.keep_with_next = True | |
| p32.paragraph_format.keep_together = True | |
| # P33: 日期 | |
| p33 = add_p(doc, f'日期： {visit_date_display}', | |
| font_name=FONT_NAME, size_pt=12, bold=False, color=None, | |
| alignment=WD_ALIGN_PARAGRAPH.LEFT, | |
| first_line_indent_pt=0, line_spacing=1.5, | |
| space_before_pt=0, space_after_pt=0) | |
| p33.paragraph_format.left_indent = SIGNATURE_LEFT_INDENT | |
| p33.paragraph_format.keep_together = True | |
| # ===================================================== | |
| # 表3: 照片表 (3行 x 5列) - 放在文档末尾，用于打卡照片 | |
| # 模板为3行x5列，无边框(照片直接放置，不显示表格线) | |
| # 使用 page_break_before 让照片表从新页面开始，避免多余空白页 | |
| # ===================================================== | |
| # 在表格前添加一个段落，设置 page_break_before 属性 | |
| p_before_table = doc.add_paragraph() | |
| p_before_table.paragraph_format.page_break_before = True | |
| p_before_table.paragraph_format.space_before = Pt(0) | |
| p_before_table.paragraph_format.space_after = Pt(0) | |
| p_before_table.paragraph_format.line_spacing = 1.0 | |
| table3 = doc.add_table(rows=3, cols=5) | |
| set_table_columns(table3, COL_WIDTHS_2) | |
| # 照片表不加边框 - 匹配模板 | |
| set_table_cell_margins(table3) | |
| # 设置所有单元格垂直居中 + 清除段落间距 | |
| for ri in range(3): | |
| for ci in range(5): | |
| cell = table3.rows[ri].cells[ci] | |
| set_cell_vcenter(cell) | |
| set_cell_text_and_font(cell, '', font_name=None, size_pt=None, bold=None, color=None) | |
| # 放置照片（按模板位置模式：行0全5列, 行1列0-2+列4, 行2） | |
| if photos: | |
| photo_paths = [] | |
| for p in photos: | |
| if isinstance(p, str): | |
| if os.path.exists(p): | |
| photo_paths.append(p) | |
| else: | |
| try: | |
| if p.startswith('data:'): | |
| p = p.split(',', 1)[1] | |
| img_data = base64.b64decode(p) | |
| temp_path = os.path.join(os.environ.get('TEMP', '.'), | |
| f'visit_photo_{str(abs(hash(p)))[:8]}.jpg') | |
| with open(temp_path, 'wb') as f: | |
| f.write(img_data) | |
| photo_paths.append(temp_path) | |
| except: | |
| pass | |
| # 照片位置: 前5张放行0, 接着4张放行1的特定列, 剩余放行2 | |
| positions = [ | |
| (0, 0), (0, 1), (0, 2), (0, 3), (0, 4), | |
| (1, 0), (1, 1), (1, 2), (1, 4), | |
| (2, 0), (2, 1), (2, 2), (2, 3), (2, 4), | |
| ] | |
| for pi, (ri, ci) in enumerate(positions): | |
| if pi < len(photo_paths): | |
| try: | |
| cell = table3.rows[ri].cells[ci] | |
| cell.text = '' | |
| p = cell.paragraphs[0] | |
| p.alignment = WD_ALIGN_PARAGRAPH.CENTER | |
| p.paragraph_format.space_before = Pt(0) | |
| p.paragraph_format.space_after = Pt(0) | |
| p.paragraph_format.line_spacing = 1.0 | |
| run = p.add_run() | |
| run.add_picture(photo_paths[pi], width=Inches(1.5)) | |
| except Exception as e: | |
| print(f'插入照片失败: {e}') | |
| # 保存到内存 | |
| buffer = io.BytesIO() | |
| doc.save(buffer) | |
| buffer.seek(0) | |
| return buffer | |
| class ExportHandler(BaseHTTPRequestHandler): | |
| def do_OPTIONS(self): | |
| self.send_response(200) | |
| self.send_header('Access-Control-Allow-Origin', '*') | |
| self.send_header('Access-Control-Allow-Methods', 'POST, OPTIONS') | |
| self.send_header('Access-Control-Allow-Headers', 'Content-Type') | |
| self.end_headers() | |
| def do_POST(self): | |
| if self.path == '/export': | |
| content_length = int(self.headers.get('Content-Length', 0)) | |
| body = self.rfile.read(content_length) | |
| try: | |
| visit_data = json.loads(body) | |
| buffer = generate_docx(visit_data) | |
| self.send_response(200) | |
| self.send_header('Content-Type', | |
| 'application/vnd.openxmlformats-officedocument.wordprocessingml.document') | |
| self.send_header('Access-Control-Allow-Origin', '*') | |
| filename = 'visit_%s_%sstores.docx' % ( | |
| visit_data.get('visitDateDisplay', '').replace('.', '-'), | |
| visit_data.get('totalCount', 0) | |
| ) | |
| self.send_header('Content-Disposition', 'attachment; filename="%s"' % filename) | |
| self.end_headers() | |
| self.wfile.write(buffer.getvalue()) | |
| except Exception as e: | |
| self.send_response(500) | |
| self.send_header('Content-Type', 'application/json') | |
| self.send_header('Access-Control-Allow-Origin', '*') | |
| self.end_headers() | |
| self.wfile.write(json.dumps({'error': str(e)}).encode()) | |
| else: | |
| self.send_response(404) | |
| self.end_headers() | |
| def log_message(self, format, *args): | |
| print('[%s] %s' % (self.log_date_time_string(), args[0])) | |
| if __name__ == '__main__': | |
| print('导出服务启动在 http://127.0.0.1:%d/export' % PORT) | |
| server = HTTPServer(('127.0.0.1', PORT), ExportHandler) | |
| try: | |
| server.serve_forever() | |
| except KeyboardInterrupt: | |
| server.shutdown() |