﻿OFFICES = [
 ("仁雅","自有渠道","关涛"),("广元","自有渠道","许阳"),("眉山","自有渠道","沈岭"),("巴中","自有渠道","王涛"),
 ("德阳","自有渠道","刘安礼"),("攀西","自有渠道","李丽容"),("周边陈博","自有渠道","陈博"),("资阳","自有渠道","杨番淞"),
 ("周边陈良","自有渠道","陈良"),("绵阳","自有渠道","李强"),("南遂","自有渠道","金川"),("前置","自有渠道","罗维"),
 ("乐山","自有渠道","朱允峰"),("周边睢航","自有渠道","睢航"),("家福来","KA渠道","王勇"),("京东五星","KA渠道","黄美珠"),
 ("苏宁","KA渠道","唐杰"),("工程办","工程渠道","刘佳琳"),("下沉","下沉渠道","徐晨阳"),
]
OFFICE_NAMES = [o[0] for o in OFFICES]
OPERATORS = [
 ("雷德","四川雷德巨幕科技有限公司","陈博"),("汇智骁能","四川汇智骁能环境科技有限公司","陈博"),
 ("欣兴互利","四川欣兴互利商贸有限公司","陈良"),("智汇星辰","四川智汇星辰商贸有限公司","吴林洪"),
 ("续晨","仁寿县续晨电器有限公司","关涛"),("海龙天适","成都海龙天适家居科技有限公司","罗维"),
 ("鑫伟舒适","成都鑫伟舒适家暖通设备有限公司","罗维"),("仟骏","乐山市仟骏商贸有限公司","朱允峰"),
 ("德盛","简阳市德盛商厦有限公司","杨番淞"),("薄利嘉恒","巴中市薄利嘉恒商贸有限公司","王涛"),
 ("兴盛和","四川兴盛和商贸有限公司","沈岭"),("新鸿瀚晟","四川新鸿瀚晟家电有限公司","吴林洪"),
 ("智家通达","四川智家通达商贸有限公司","李强"),("新超越","雅安新超越电器有限责任公司","关涛"),
 ("天石","凉山州天石商贸有限公司","李丽容"),("鼎信","德阳鼎信电器销售有限公司","刘安礼"),
 ("新成利","广元新成利贸易有限公司","许阳"),("黄勇","攀枝花市黄勇商贸有限公司","李丽容"),
 ("七方","四川恒晟恒七方贸易有限公司","睢航"),("家福来","四川家福来供应链管理有限公司","王勇"),
 ("京东五星","京东五星电器集团有限公司","黄美珠"),("苏宁","苏宁易购集团股份有限公司","唐杰"),
]
WEEKS = [f"W{n}" for n in range(45, 54)]
TYPES = ["门店主推活动","抖音直播活动","异业联动","政企活动","小区运营","家博会","璀璨新风品鉴会","培训订货会","其他"]
SOURCES = ["页面提交","历史导入","人工修正"]
HUES = ["Blue","Orange","Green","Purple","Turquoise","Carmine","Yellow","Lime","Wathet","Red","Gray"]

def sel(name, opts, hues=None):
    o = []
    for i, n in enumerate(opts):
        o.append({"name": n, "hue": (hues[i] if hues else HUES[i % len(HUES)])})
    return {"type": "select", "name": name, "multiple": False, "options": o}

def num(name, p=0):
    return {"type": "number", "name": name, "style": {"type": "plain", "precision": p}}

def txt(name): return {"type": "text", "name": name}
def date(name): return {"type": "datetime", "name": name, "style": {"format": "yyyy-MM-dd"}}
def dtm(name): return {"type": "datetime", "name": name, "style": {"format": "yyyy-MM-dd HH:mm"}}

OFFICE_SEL = lambda: sel("办事处", OFFICE_NAMES)
WEEK_SEL = lambda n="周次": sel(n, WEEKS)
TYPE_SEL = lambda: sel("活动类型", TYPES)
SOURCE_SEL = lambda: sel("数据来源", SOURCES, ["Blue","Gray","Orange"])

ACTIVITY_INFO = lambda: [OFFICE_SEL(), WEEK_SEL(), txt("活动名称"), TYPE_SEL(), txt("其他类型名称"),
    date("开始日期"), date("结束日期"), txt("门店全称"), txt("商家全称")]

TABLES = {
 "运营商表": [txt("简称"), txt("运营商全称"), txt("产品经理"), num("排序")],
 "周次表": [txt("周次"), num("周序号"), date("周一"), date("周日"), txt("日期范围"),
           sel("所属月份", ["11月","12月"], ["Orange","Blue"]), dtm("提报截止"), dtm("反馈截止")],
 "活动表": [{"type": "auto_number", "name": "活动编号", "style": {"rules": [{"type": "text", "text": "HD"}, {"type": "incremental_number", "length": 4}]}}]
          + ACTIVITY_INFO()
          + [num("销额目标（万）", 2), num("销量目标（套）"), num("新风三柜三挂目标（套）"), txt("备注"), txt("填报人"),
             SOURCE_SEL(), dtm("提交时间修正"), {"type": "created_at", "name": "创建时间", "style": {"format": "yyyy-MM-dd HH:mm"}}],
 "反馈表": [{"type": "auto_number", "name": "反馈编号", "style": {"rules": [{"type": "text", "text": "FK"}, {"type": "incremental_number", "length": 4}]}},
           sel("反馈类型", ["已提报活动","临时加场"], ["Blue","Orange"]),
           {"type": "link", "name": "关联活动", "link_table": "活动表", "bidirectional": True, "bidirectional_link_field_name": "反馈记录"}]
          + ACTIVITY_INFO()
          + [txt("填报人"), sel("是否如期举办", ["是","否"], ["Green","Red"]), txt("未举办原因"),
             num("销额实际（万）", 2), num("销量实际（套）"), num("新风三柜三挂完成（套）"), num("到场户数"),
             {"type": "attachment", "name": "现场照片"}, txt("活动总结"),
             num("邀约户数"), num("交定金户数"), num("意向户数"),
             sel("承接运营商", [o[0] for o in OPERATORS]), num("参会人数"), num("邀请客户数"), num("分销产出（万）", 2),
             num("系统销额（万）", 2), num("系统销量（套）"), num("系统三柜三挂（套）"),
             SOURCE_SEL(), dtm("提交时间修正"), {"type": "created_at", "name": "创建时间", "style": {"format": "yyyy-MM-dd HH:mm"}}],
 "任务表": [txt("任务名称"), OFFICE_SEL(), sel("活动类型", ["合计"] + TYPES),
           sel("周期类型", ["周","月","累计","自定义"], ["Blue","Orange","Purple","Gray"]), txt("周期名称"),
           WEEK_SEL("开始周次"), WEEK_SEL("结束周次"), num("要求场次"), txt("备注")],
}
