import os
import time
import barcode
from barcode.writer import ImageWriter
from seatable_api import Base, context

api_token = context.api_token or "859ad340d9a2b11b067c11f43078992e14853af5"
server_url = context.server_url or "https://cloud.seatable.cn"

TEXT_COL = "PhoneNum"  # 需要轉換成條碼的列
BARCODE_IMAGE_COL = "BarcodeImage" # 圖片列， 存儲條碼
TABLE_NAME = 'Table1'
BARCODE_TYPE = 'code128'

CUSTOM_OPTIONS = {
    "module_width": 0.2,       # 單個條紋的最小寬度, mm
    "module_height": 15.0,     # 條紋帶的高度, mm
    "quiet_zone": 6.5,         # 圖片兩邊與首尾兩條紋之間的距離, mm
    "font_size": 10,           # 條紋底部文本的大小,pt
    "text_distance": 5.0,      # 條紋底部與條紋之間的距離, mm
}


CODE = barcode.get_barcode_class(BARCODE_TYPE)
base = Base(api_token, server_url)
base.auth()

def get_time_stamp():
    return str(int(time.time()*100000))

for row in base.list_rows(TABLE_NAME):
    # 如果圖片列中已有內容， 則跳過
    if row.get(BARCODE_IMAGE_COL):
        continue
    # 如果電話號碼列為空，則跳過
    if not row.get(TEXT_COL):
        continue

    try:
        row_id = row.get('_id')
        msg = str(row.get(TEXT_COL))

        # 生成條碼對象
        code_img = CODE(msg, writer=ImageWriter())
        save_name = "%s_%s" % (row_id, get_time_stamp())

        # 保存為圖片并暫存
        file_name = code_img.save("/tmp/%s" % save_name, options=CUSTOM_OPTIONS)

        # 將圖片上傳至 Base 表格
        info_dict = base.upload_local_file(file_name, name=None, file_type='image', replace=True)
        img_url = info_dict.get('url')
        row[BARCODE_IMAGE_COL] = [img_url]
        base.update_row('Table1', row_id, row)

        # 移除暫存文件
        os.remove(file_name)
    except Exception as error:
        print("error occured during barcode generate", error)
        continue