1. 项目背景与需求概述

针对"某用户每天时刻都在吐痰"这一高频、持续、强需求场景，本文设计一套完整的吐痰行为管理系统（Spit Management System, SMS）。系统覆盖记录、分析、健康、社交、硬件联动等九大模块，帮助用户科学管理吐痰行为，辅助健康监测。

1.1 核心痛点

1.2 系统架构总览

2. 核心吐痰记录模块

2.1 功能清单

2.2 数据表设计

CREATETABLEspit_records(idBIGINTPRIMARYKEYAUTO_INCREMENT,user_idBIGINTNOTNULL,spit_timeDATETIMENOTNULL,spit_typeENUM('dry','wet','bloody','foamy','thick','thin')NOTNULL,spit_colorENUM('white','yellow','green','gray_black','blood_streaked'),spit_volumeENUM('small','medium','large'),volume_mlDECIMAL(5,2),location_latDECIMAL(10,6),location_lngDECIMAL(10,6),postureENUM('standing','sitting','lying','walking'),duration_secondsINT,remarkTEXT,created_atTIMESTAMPDEFAULTCURRENT_TIMESTAMP,INDEXidx_user_time(user_id,spit_time));

2.3 记录界面示例

publicclassSpitRecordActivityextendsAppCompatActivity{privateSpitRepositoryrepository;privateSensorManagersensorManager;@OverrideprotectedvoidonCreate(BundlesavedInstanceState){super.onCreate(savedInstanceState);setContentView(R.layout.activity_spit_record);repository=newSpitRepository(this);initSensors();initVoiceWakeup();}privatevoidinitSensors(){sensorManager=(SensorManager)getSystemService(SENSOR_SERVICE);Sensoraccelerometer=sensorManager.getDefaultSensor(Sensor.TYPE_ACCELEROMETER);sensorManager.registerListener(this,accelerometer,SensorManager.SENSOR_DELAY_NORMAL);}}

3. 频率与节律分析模块

3.1 分析维度

3.2 频率统计SQL

SELECTDATE(spit_time)ASspit_date,COUNT(*)ASdaily_count,AVG(duration_seconds)ASavg_duration,MIN(TIMESTAMPDIFF(MINUTE,LAG(spit_time)OVER(ORDERBYspit_time),spit_time))ASmin_interval_minutesFROMspit_recordsWHEREuser_id=?GROUPBYDATE(spit_time)ORDERBYspit_dateDESC;

3.3 热力图数据示例

4. 健康监测与预警模块

4.1 健康评分体系

4.2 预警规则引擎

defevaluate_health_risk(spit_record):risk_score=0ifspit_record.colorin['gray_black','blood_streaked']:risk_score+=40ifspit_record.type=='thick':risk_score+=20ifspit_record.volume=='large':risk_score+=15ifspit_record.duration>30:risk_score+=10ifrisk_score>=60:return"HIGH_RISK","建议立即就医"elifrisk_score>=30:return"MEDIUM_RISK","建议观察并咨询医生"else:return"LOW_RISK","正常范围"

4.3 就医报告生成

publicclassMedicalReportGenerator{publicvoidgenerateReport(Useruser,List<SpitRecord>records){PDFDocumentdoc=newPDFDocument();doc.addSection("患者基本信息");doc.addSection("吐痰频率统计");doc.addSection("颜色分布分析");doc.addSection("健康评分趋势");doc.addSection("异常记录明细");doc.save("medical_report_"+user.getId()+".pdf");}}

5. 习惯养成与干预模块

5.1 干预策略对比

5.2 成就徽章体系

6. 社交与分享模块

6.1 社交功能矩阵

6.2 排行榜数据表

CREATETABLEleaderboard(idBIGINTPRIMARYKEYAUTO_INCREMENT,user_idBIGINTNOTNULL,periodENUM('daily','weekly','monthly')NOTNULL,spit_countINTDEFAULT0,reduction_rateDECIMAL(5,2)DEFAULT0,rankINT,updated_atTIMESTAMPDEFAULTCURRENT_TIMESTAMP,UNIQUEKEYuk_user_period(user_id,period));

7. 硬件与智能联动模块

7.1 硬件设备联动

7.2 硬件数据接入

publicclassHardwareIntegrationService{privatefinalBleManagerbleManager;privatefinalMqttClientmqttClient;publicvoidprocessSpitDetection(SpitDetectionEventevent){// 硬件触发记录SpitRecordrecord=newSpitRecord();record.setUserId(event.getUserId());record.setSpitTime(newDate());record.setSource(event.getDeviceType());record.setVolumeMl(event.getWeight()*1.05);// 同步到云端mqttClient.publish("spit/records",record.toJson());}}

8. 数据管理与隐私模块

8.1 数据管理功能

8.2 数据加密实现

fromcryptography.fernetimportFernetimportbase64classDataEncryption:def__init__(self):self.key=Fernet.generate_key()self.cipher=Fernet(self.key)defencrypt_record(self,record_data):encrypted=self.cipher.encrypt(record_data.encode())returnbase64.urlsafe_b64encode(encrypted).decode()defdecrypt_record(self,encrypted_data):decoded=base64.urlsafe_b64decode(encrypted_data)returnself.cipher.decrypt(decoded).decode()

9. 趣味与心理模块

9.1 趣味功能设计

9.2 虚拟宠物系统

publicclassVirtualPetSystem{privatePetpet;privateintfeedingCount;publicvoidfeedPet(SpitRecordrecord){feedingCount++;pet.setEnergy(pet.getEnergy()+10);pet.setMood(pet.getMood()+5);if(feedingCount%10==0){pet.evolve();sendAchievementNotification("宠物进化成功！");}}}

10. 系统管理模块

10.1 权限管理

10.2 API开放平台

fromfastapiimportFastAPI,Depends,HTTPExceptionfromtypingimportList app=FastAPI()@app.get("/api/v1/spit-records")asyncdefget_spit_records(user_id:int,start_date:str,end_date:str,api_key:str=Depends(verify_api_key)):records=awaitquery_records(user_id,start_date,end_date)return{"status":"success","data":records,"total":len(records)}

11. 总结与展望

11.1 系统功能统计

11.2 技术架构演进

本系统通过九大模块的协同设计，实现了从吐痰记录到健康管理的全链路闭环。未来将引入更先进的AI算法，实现吐痰行为的精准预测与个性化干预建议。