PHP가 개발한 쇼핑몰의 A/S 평가 및 불만 처리에 대한 논의

<?php
// 创建评价表的数据库表
CREATE TABLE `evaluations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `goods_id` int(11) NOT NULL,
  `rate` int(11) NOT NULL,
  `content` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
);

// 用户评价商品
public function evaluateGoods($user_id, $order_id, $goods_id, $rate, $content) {
  $sql = "INSERT INTO `evaluations` (`user_id`, `order_id`, `goods_id`, `rate`, `content`) VALUES (?, ?, ?, ?, ?)";
  $stmt = $this->db->prepare($sql);
  $stmt->bind_param("iiiss", $user_id, $order_id, $goods_id, $rate, $content);
  $stmt->execute();
  $stmt->close();
}

// 获取商品评价列表
public function getGoodsEvaluations($goods_id) {
  $sql = "SELECT * FROM `evaluations` WHERE `goods_id` = ?";
  $stmt = $this->db->prepare($sql);
  $stmt->bind_param("i", $goods_id);
  $stmt->execute();
  $result = $stmt->get_result();
  $evaluations = $result->fetch_all(MYSQLI_ASSOC);
  $stmt->close();
  return $evaluations;
}
?>

<?php
// 创建投诉表的数据库表
CREATE TABLE `complaints` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `content` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
);

// 用户提交投诉
public function submitComplaint($user_id, $order_id, $content) {
  $sql = "INSERT INTO `complaints` (`user_id`, `order_id`, `content`) VALUES (?, ?, ?)";
  $stmt = $this->db->prepare($sql);
  $stmt->bind_param("iis", $user_id, $order_id, $content);
  $stmt->execute();
  $stmt->close();
}

// 获取投诉列表
public function getComplaints() {
  $sql = "SELECT * FROM `complaints`";
  $result = $this->db->query($sql);
  $complaints = $result->fetch_all(MYSQLI_ASSOC);
  return $complaints;
}

// 处理投诉
public function handleComplaint($complaint_id, $handle_result) {
  $sql = "UPDATE `complaints` SET `handle_result` = ? WHERE `id` = ?";
  $stmt = $this->db->prepare($sql);
  $stmt->bind_param("si", $handle_result, $complaint_id);
  $stmt->execute();
  $stmt->close();
}
?>