const express = require('express');
const mysql = require('mysql2');

const router = express.Router();
const db = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: '',
  database: 'ecommerce'
});

// เพิ่มสินค้า
router.post('/add', (req, res) => {
  const { name, description, price, quantity } = req.body;
  const query = 'INSERT INTO products (name, description, price, quantity) VALUES (?, ?, ?, ?)';
  db.query(query, [name, description, price, quantity], (err, result) => {
    if (err) {
      return res.status(500).json({ message: 'Error adding product' });
    }
    res.status(201).json({ message: 'Product added successfully' });
  });
});

// แก้ไขสินค้า
router.put('/update/:id', (req, res) => {
  const { id } = req.params;
  const { name, description, price, quantity } = req.body;
  const query = 'UPDATE products SET name = ?, description = ?, price = ?, quantity = ? WHERE product_id = ?';
  db.query(query, [name, description, price, quantity, id], (err, result) => {
    if (err) {
      return res.status(500).json({ message: 'Error updating product' });
    }
    res.status(200).json({ message: 'Product updated successfully' });
  });
});

// ลบสินค้า
router.delete('/delete/:id', (req, res) => {
  const { id } = req.params;
  const query = 'DELETE FROM products WHERE product_id = ?';
  db.query(query, [id], (err, result) => {
    if (err) {
      return res.status(500).json({ message: 'Error deleting product' });
    }
    res.status(200).json({ message: 'Product deleted successfully' });
  });
});

// ค้นหาสินค้า
router.get('/search', (req, res) => {
  const { query } = req.query;
  const searchQuery = `SELECT * FROM products WHERE name LIKE ?`;
  db.query(searchQuery, [`%${query}%`], (err, results) => {
    if (err) {
      return res.status(500).json({ message: 'Error searching products' });
    }
    res.status(200).json(results);
  });
});

module.exports = router;