Avtoraqamlar onlayn savdo tizimini o'rgatuvchi dasturiy ta'minot ishlab chiqish
![3-jadval
maydon
nomi ma’lumot turi tavsif
sale_id INT PRIMARY
KEY Savdo identifikatori
user_id INT Foydalanuvchi identifikatori
(xorijiy kalit)
plate_id INT Avtoraqam identifikatori
(xorijiy kalit)
sale_date DATETIME Savdo sanasi
amount DECIMAL(10,2) To'langan summa
2. Dasturiy kodlar misollari (Python + Flask)
Foydalanuvchi ro‘yxatdan o‘tishi (registration) kodi
from flask import Flask, request, jsonify
from werkzeug.security import generate_password_hash
import sqlite3
app = Flask(__name__)
def get_db_connection():
conn = sqlite3.connect('database.db')
conn.row_factory = sqlite3.Row
return conn
@app.route('/register', methods=['POST'])
def register():
data = request.json
username = data['username']
email = data['email']
41](https://docx.uz/documents/81ef087d-0720-4e7e-9714-2b2c49f902de/page_41.png?v=1)
![password = data['password']
hashed_password = generate_password_hash(password)
conn = get_db_connection()
cursor = conn.cursor()
cursor.execute("INSERT INTO users (username, email, password_hash,
role) VALUES (?, ?, ?, ?)",
(username, email, hashed_password, 'user'))
conn.commit()
conn.close()
return jsonify({'message': 'Foydalanuvchi muvaffaqiyatli ro‘yxatdan o‘tdi.'}),
201
if __name__ == '__main__':
app.run(debug=True)
Avtoraqamlar ro‘yxatini olish (GET so‘rovi)
@app.route('/plates', methods=['GET'])
def get_plates():
conn = get_db_connection()
plates = conn.execute('SELECT * FROM license_plates WHERE status =
"available"').fetchall()
conn.close()
plates_list = []
for plate in plates:
plates_list.append({
'id': plate['id'],
'plate_number': plate['plate_number'],
'price': plate['price'],
'description': plate['description']
42](https://docx.uz/documents/81ef087d-0720-4e7e-9714-2b2c49f902de/page_42.png?v=1)
![})
return jsonify(plates_list)
Savdo jarayonini amalga oshirish (POST so‘rovi)
from datetime import datetime
@app.route('/buy', methods=['POST'])
def buy_plate():
data = request.json
user_id = data['user_id']
plate_id = data['plate_id']
conn = get_db_connection()
cursor = conn.cursor()
# Raqam mavjudligini va mavjudligini tekshirish
plate = cursor.execute("SELECT * FROM license_plates WHERE id = ?
AND status = 'available'", (plate_id,)).fetchone()
if plate is None:
return jsonify({'message': 'Avtoraqam mavjud emas yoki sotilgan'}), 400
# Savdo yozuvini qo'shish
cursor.execute("INSERT INTO sales (user_id, plate_id, sale_date, amount)
VALUES (?, ?, ?, ?)",
(user_id, plate_id, datetime.now(), plate['price']))
# Avtoraqam holatini yangilash
cursor.execute("UPDATE license_plates SET status = 'sold' WHERE id = ?",
(plate_id,))
conn.commit()
conn.close()
return jsonify({'message': 'Avtoraqam muvaffaqiyatli sotib olindi.'}), 20
43](https://docx.uz/documents/81ef087d-0720-4e7e-9714-2b2c49f902de/page_43.png?v=1)
Avtoraqamlar onlayn savdo tizimini o'rgatuvchi dasturiy ta'minot ishlab chiqish