#
#2025/11/16 親の投稿
#

import mysql.connector
from openai import OpenAI
import sys
import time
import os

def chat_img( com , url ):
    key=os.getenv("OPENAPI_KEY_ARA")
    client = OpenAI(api_key=key)
    msg=[{"role": "system", "content": "あなたは親切なAIアシスタントです。"}]
    if url == "null":
        msg.append({"role": "user", "content":com})
    else:
        msg.append({"role": "user", "content": [{"type": "text", "text": com },
                                                 {"type": "image_url", "image_url": {"url": url }}
                                                ]})
    res = client.chat.completions.create(model="gpt-4o",messages=msg)
    return( res.choices[0].message.content )

#
# main
#   idd:格納されているtb01.ID  url="null" 画像なし

idd=sys.argv[1]
url=sys.argv[2]

cn=mysql.connector.connect(
    host='localhost',
    user='std',
    password='std',
    database='real_navi',
    charset='utf8mb4'
)
rs = cn.cursor(dictionary=True)
sql =f"SELECT LID,com,lat,lon FROM tb01 where tb01.ID={idd}"
rs.execute(sql)
dd = rs.fetchall()
lid=dd[0]['LID']
com=dd[0]['com']
lat=dd[0]['lat']
lon=dd[0]['lon']
flg=( lat is None )
if flg == False:
    com=f"{ com }  ここの緯度経度です。({ lat },{ lon })"
    
aa=chat_img( com , url )
aa=aa.replace("'", "\\'")
wtime=int(time.time())

sql="insert into tb01(LID,wtime,com,s_ID,flg,name) values(%s,%s,%s,%s,%s,%s)"

rs.execute(sql,(lid,wtime,aa,idd,1,'AI'))
cn.commit()
cn.close()