Q 语言技术项目干系人管理与沟通计划实现
在Q语言技术项目中，干系人管理与沟通计划是确保项目顺利进行的关键因素。本文将围绕这一主题，通过代码实现一个简单的干系人管理与沟通计划系统，旨在帮助项目管理者有效管理项目干系人，并确保信息流畅、及时地传递给所有相关方。
系统设计
系统架构
本系统采用前后端分离的架构，前端使用HTML、CSS和JavaScript实现用户界面，后端使用Python的Flask框架进行数据处理和业务逻辑实现。
功能模块
1. 干系人管理：包括干系人信息的录入、修改、删除和查询。
2. 沟通计划管理：包括沟通计划的制定、修改、删除和查询。
3. 消息通知：根据沟通计划自动发送消息通知给相关干系人。
后端实现
数据库设计
使用SQLite数据库存储干系人和沟通计划数据。
python
import sqlite3
创建数据库连接
conn = sqlite3.connect('q_project.db')
cursor = conn.cursor()
创建干系人表
cursor.execute('''
CREATE TABLE IF NOT EXISTS stakeholders (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
role TEXT NOT NULL,
email TEXT NOT NULL
)
''')
创建沟通计划表
cursor.execute('''
CREATE TABLE IF NOT EXISTS communication_plans (
id INTEGER PRIMARY KEY AUTOINCREMENT,
stakeholder_id INTEGER,
message TEXT NOT NULL,
send_time TEXT NOT NULL,
FOREIGN KEY (stakeholder_id) REFERENCES stakeholders (id)
)
''')
提交事务
conn.commit()
关闭连接
conn.close()
干系人管理
python
from flask import Flask, request, jsonify
app = Flask(__name__)
添加干系人
@app.route('/add_stakeholder', methods=['POST'])
def add_stakeholder():
data = request.json
cursor = conn.cursor()
cursor.execute('''
INSERT INTO stakeholders (name, role, email) VALUES (?, ?, ?)
''', (data['name'], data['role'], data['email']))
conn.commit()
return jsonify({'status': 'success', 'id': cursor.lastrowid})
修改干系人
@app.route('/update_stakeholder', methods=['PUT'])
def update_stakeholder():
data = request.json
cursor = conn.cursor()
cursor.execute('''
UPDATE stakeholders SET name = ?, role = ?, email = ? WHERE id = ?
''', (data['name'], data['role'], data['email'], data['id']))
conn.commit()
return jsonify({'status': 'success'})
删除干系人
@app.route('/delete_stakeholder', methods=['DELETE'])
def delete_stakeholder():
data = request.json
cursor = conn.cursor()
cursor.execute('DELETE FROM stakeholders WHERE id = ?', (data['id'],))
conn.commit()
return jsonify({'status': 'success'})
查询干系人
@app.route('/get_stakeholders', methods=['GET'])
def get_stakeholders():
cursor = conn.cursor()
cursor.execute('SELECT FROM stakeholders')
stakeholders = cursor.fetchall()
return jsonify(stakeholders)
if __name__ == '__main__':
app.run(debug=True)
沟通计划管理
python
添加沟通计划
@app.route('/add_communication_plan', methods=['POST'])
def add_communication_plan():
data = request.json
cursor = conn.cursor()
cursor.execute('''
INSERT INTO communication_plans (stakeholder_id, message, send_time) VALUES (?, ?, ?)
''', (data['stakeholder_id'], data['message'], data['send_time']))
conn.commit()
return jsonify({'status': 'success', 'id': cursor.lastrowid})
修改沟通计划
@app.route('/update_communication_plan', methods=['PUT'])
def update_communication_plan():
data = request.json
cursor = conn.cursor()
cursor.execute('''
UPDATE communication_plans SET stakeholder_id = ?, message = ?, send_time = ? WHERE id = ?
''', (data['stakeholder_id'], data['message'], data['send_time'], data['id']))
conn.commit()
return jsonify({'status': 'success'})
删除沟通计划
@app.route('/delete_communication_plan', methods=['DELETE'])
def delete_communication_plan():
data = request.json
cursor = conn.cursor()
cursor.execute('DELETE FROM communication_plans WHERE id = ?', (data['id'],))
conn.commit()
return jsonify({'status': 'success'})
查询沟通计划
@app.route('/get_communication_plans', methods=['GET'])
def get_communication_plans():
cursor = conn.cursor()
cursor.execute('SELECT FROM communication_plans')
communication_plans = cursor.fetchall()
return jsonify(communication_plans)
消息通知
python
import smtplib
from email.mime.text import MIMEText
from email.header import Header
def send_email(stakeholder_email, message):
sender = 'your_email@example.com'
password = 'your_password'
receiver = stakeholder_email
smtp_server = 'smtp.example.com'
msg = MIMEText(message, 'plain', 'utf-8')
msg['From'] = Header("Project Manager", 'utf-8')
msg['To'] = Header("Stakeholder", 'utf-8')
msg['Subject'] = Header("Communication Plan", 'utf-8')
try:
smtp_obj = smtplib.SMTP_SSL(smtp_server, 465)
smtp_obj.login(sender, password)
smtp_obj.sendmail(sender, [receiver], msg.as_string())
smtp_obj.quit()
print("Email sent successfully")
except smtplib.SMTPException as e:
print("Error: unable to send email", e)
@app.route('/send_notification', methods=['POST'])
def send_notification():
data = request.json
cursor = conn.cursor()
cursor.execute('SELECT email FROM stakeholders WHERE id = ?', (data['stakeholder_id'],))
stakeholder_email = cursor.fetchone()[0]
send_email(stakeholder_email, data['message'])
return jsonify({'status': 'success'})
前端实现
HTML界面
html
Q Project Stakeholder Management
Q Project Stakeholder Management
Add Stakeholder
Add
Comments NOTHING