基于温州地区实习管理系统的商标技术实现与应用

class Trademark:

def __init__(self, name, registration_number, owner, status):

self.name = name

self.registration_number = registration_number

self.owner = owner

self.status = status

def update_status(self, new_status):

self.status = new_status

def display_info(self):

print(f"商标名称: {self.name}")

print(f"注册号: {self.registration_number}")

print(f"所有人: {self.owner}")

print(f"状态: {self.status}")

# 示例：创建一个商标对象

trademark1 = Trademark("温商科技", "TM20240501", "温州大学", "有效")

trademark1.display_info()

CREATE TABLE trademarks (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(255) NOT NULL,

registration_number VARCHAR(100) NOT NULL UNIQUE,

owner VARCHAR(255),

status VARCHAR(50)

);

import mysql.connector

def get_trademark_by_registration_number(registration_number):

conn = mysql.connector.connect(

host="localhost",

user="root",

password="password",

database="internship_system"

)

cursor = conn.cursor()

query = "SELECT * FROM trademarks WHERE registration_number = %s"

cursor.execute(query, (registration_number,))

result = cursor.fetchone()

cursor.close()

conn.close()

if result:

return {

"name": result[1],

"registration_number": result[2],

"owner": result[3],

"status": result[4]

}

else:

return None

# 示例：查询某个商标

trademark_info = get_trademark_by_registration_number("TM20240501")

if trademark_info:

print("查询到商标信息：")

for key, value in trademark_info.items():

print(f"{key}: {value}")

else:

print("未找到该商标信息。")

from celery import Celery

from datetime import datetime, timedelta

app = Celery('tasks', broker='redis://localhost:6379/0')

@app.task

def send_reminder(trademark_id):

# 这里模拟发送邮件或短信

print(f"提醒：商标ID {trademark_id} 即将到期")

# 设置定时任务，每天检查商标状态

def check_trademarks():

# 获取所有商标

trademarks = get_all_trademarks() # 假设有一个获取所有商标的函数

for trademark in trademarks:

if trademark['status'] == '有效':

# 计算距离到期的时间

expiry_date = datetime.strptime(trademark['expiry_date'], "%Y-%m-%d")

days_left = (expiry_date - datetime.now()).days

if days_left <= 30:

send_reminder.delay(trademark['id'])

# 每天凌晨执行一次

if __name__ == "__main__":

check_trademarks()