Skip to content
TheChatArchiveThe Chat Archive
gpt-4-0314· OpenAIAi2 WildChat-4.8M (AI2)

Write a TCP server for road transport office in Tamilnadu. The traffic police officer on…

  1. User

    Write a TCP server for road transport office in Tamilnadu. The traffic police officer on the road connects to the TCP server and send the Vehicle register number such as TN03HJ4509. The server looks in the database for road tax paid, traffic offences. It computes the fine and send the data to the traffic police officer. The traffic police officer collect fine and send the reference number in format YYYYDDMMregisternumber-4digitsequence-amount and current time to server. The server replies with same reference number without the amount (YYYYDDMMregisternumber-4digitsequence) and current date, time. There is additional fine of Rs. 2400/- for vehical of other other state such as KA07UI9800.

  2. Assistant

    Below is a simple Python code of a TCP server for the described scenario. Please note that this is a basic implementation and may need further improvements based on your requirement.

    import socket
    import sqlite3
    import datetime
    
    # Constants
    HOST = '127.0.0.1'  
    PORT = 65432
    OTHER_STATE_FINE = 2400
    
    # SQLite DB setup
    conn = sqlite3.connect('tn_traffic_database.db')
    cursor = conn.cursor()
    cursor.execute('''CREATE TABLE IF NOT EXISTS fines
                     (reference_number TEXT, vehicle_number TEXT, fine_amount REAL, timestamp TEXT)''')
    conn.commit()
    
    def process_vehicle_number(vehicle_number):
        cursor.execute("SELECT * FROM fines WHERE vehicle_number=?", (vehicle_number,))
        data = cursor.fetchone()
    
        fine_amount = 0
        if vehicle_number[:2] not in ['TN']:
            fine_amount += OTHER_STATE_FINE
    
        if data:
            fine_amount += data[2]
    
        return fine_amount
    
    def process_payment_info(payment_info):
        data = payment_info.split('-')
        reference_number = f'{data[0]}-{data[1]}'
        vehicle_number = data[0][8:]
        amount = data[2]
    
        timestamp = datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')
        cursor.execute("INSERT INTO fines (reference_number, vehicle_number, fine_amount, timestamp) VALUES (?, ?, ?, ?)",
                       (reference_number, vehicle_number, amount, timestamp))
        conn.commit()
    
        return reference_number, timestamp
    
    # TCP Server
    with socket.socket(socket.AF_INET, socket.SOCK_STREAM) as s:
        s.bind((HOST, PORT))
        s.listen()
        print("Server started. Waiting for clients...")
        conn, addr = s.accept()
        with conn:
            print('Connected by', addr)
            while True:
                data = conn.recv(1024).decode('utf-8')
                if not data:
                    break
    
                if data.startswith('TXN'):
                    reference_no, timestamp = process_payment_info(data)
                    response = f"{reference_no} - Payment successful on {timestamp}"
                else:
                    fine = process_vehicle_number(data)
                    response = f"Fines for vehicle {data}: Rs. {fine}"
    
                conn.sendall(response.encode('utf-8'))
    conn.close()
    

    Traffic police officer can use a simple TCP client to connect to this server and send vehicle registration numbers or payment reference numbers as specified.