Ejen Kesediaan Tuaian

import pandas as pd
from datetime import datetime

def readiness_score(field_id):
    crop = pd.read_sql("SELECT * FROM crop_status WHERE field_id = ?", field_id)
    days_planted = (datetime.now() - crop['planting_date']).days
    maturity = crop['maturity_days']
    ratio = days_planted / maturity
    if ratio >= 1.0: return 100, 'Ready'
    elif ratio >= 0.85: return 80, 'Almost Ready'
    elif ratio >= 0.7: return 60, 'Maturing'
    else: return 30, 'Growing'