﻿from lk import *
from schema import *
s = load_state(); B = s["base_token"]; T = s["tables"]
WEEKLY = {"资阳":[2,3,2,2],"德阳":[2,3,2,2],"周边陈博":[2,3,2,2],"绵阳":[2,3,1,2],"南遂":[2,3,1,2],"前置":[2,3,1,2],
 "乐山":[2,3,1,1],"周边陈良":[2,2,1,2],"攀西":[1,3,1,2],"广元":[1,2,1,1],"仁雅":[1,2,1,1],"巴中":[1,1,1,1],"眉山":[1,1,1,1]}
assert [sum(v[i] for v in WEEKLY.values()) for i in range(4)] == [21,32,16,21]
own = [o[0] for o in OFFICES if o[1] == "自有渠道"]
rows = []
def row(off, typ, ptype, pname, w1, w2, req=None):
    r = {"办事处": [off], "活动类型": [typ], "周期类型": [ptype], "周期名称": pname, "开始周次": [w1], "结束周次": [w2]}
    if req is not None: r["要求场次"] = req
    rows.append(r)
for i, w in enumerate(WEEKS):
    for off in OFFICE_NAMES:
        req = WEEKLY[off][i] if (off in WEEKLY and i < 4) else None
        row(off, "合计", "周", w, w, w, req)
for off in OFFICE_NAMES:
    row(off, "合计", "月", "11月", "W45", "W48"); row(off, "合计", "月", "12月", "W49", "W53")
for off in OFFICE_NAMES:
    row(off, "合计", "累计", "11-12月累计", "W45", "W53")
for off in own:
    row(off, "小区运营", "月", "11月", "W45", "W48", 1); row(off, "小区运营", "月", "12月", "W49", "W53", 1)
for off in own:
    row(off, "培训订货会", "累计", "11-12月累计", "W45", "W53", 1)
for off, n in [("京东五星", 3), ("苏宁", 2), ("家福来", 1)]:
    row(off, "璀璨新风品鉴会", "月", "11月", "W45", "W48", n); row(off, "璀璨新风品鉴会", "月", "12月", "W49", "W53", n)
print("rows", len(rows), "with req", sum(1 for r in rows if "要求场次" in r))
if not s["seeded"].get("任务表"):
    ids = []
    for k in range(0, len(rows), 150):
        r = lk("base", "+record-batch-create", "--base-token", B, "--table-id", T["任务表"], "--json", payload({"create_records": rows[k:k+150]}))
        got = r["data"].get("record_id_list") or []
        ids += got; print("batch", k, len(got))
    s["seeded"]["任务表"] = ids; save_state(s)
