连接数据库失败');
}
$id = $_GET['id'];
$dz_time = time();
$cr_time = time();
$note = "下级订单结算，平台返佣￥" . $proxy_prices;
$notes = "下级订单结算，平台返佣￥" . $proxy_pricess;
// 查询revenue表中的数据
$query = "SELECT * FROM revenue WHERE id = $id";
$result = mysqli_query($con, $query);
$row = mysqli_fetch_assoc($result);
// 提取字段值为变量
$account = $row['account'];
$orderid = $row['oderid'];
$name = $row['name'];
$price = $row['price'];
$proxy_upid = $row['proxy_upid'];
$proxy_prices = $row['proxy_prices'];
$proxy_upids = $row['proxy_upids'];
$proxy_pricess = $row['proxy_pricess'];
$note = "下级订单完成，平台返佣￥" . $proxy_prices;
$notes = "下级订单完成，平台返佣￥" . $proxy_pricess;
// 处理第一种情况：只有account和price有值
if (!empty($account) && !empty($price) && empty($proxy_upid) && empty($proxy_prices) && empty($proxy_upids) && empty($proxy_pricess)) {
// 查询proxy表中proxy_acc = account的数据，并给字段proxy_balance的值加上price
$updateQuery = "UPDATE proxy SET proxy_balance = proxy_balance + $price WHERE proxy_acc = '$account'";
$updateResult = mysqli_query($con, $updateQuery);
if (!$updateResult) {
echo '';
exit;
}
// 更新revenue表中的数据
$updateQuery = "UPDATE revenue SET state = 2, type = 0, dz_time = $dz_time WHERE id = $id";
$updateResult = mysqli_query($con, $updateQuery);
if (!$updateResult) {
echo '';
exit;
}
echo '';
}
// 处理第二种情况：account、price、proxy_upid和proxy_prices有值
if (!empty($account) && !empty($price) && !empty($proxy_upid) && !empty($proxy_prices) && empty($proxy_upids) && empty($proxy_pricess)) {
// 使用第一种方式更新完成后，查询proxy表中proxy_acc = proxy_upid的数据，并给字段proxy_balance的值加上proxy_prices
$updateQuery = "UPDATE proxy SET proxy_balance = proxy_balance + $price WHERE proxy_acc = '$account'";
$updateResult = mysqli_query($con, $updateQuery);
if (!$updateResult) {
echo '';
exit;
}
// 更新revenue表中的数据
$updateQuery = "UPDATE revenue SET state = 2, type = 0, dz_time = $dz_time WHERE id = $id";
$updateResult = mysqli_query($con, $updateQuery);
if (!$updateResult) {
echo '';
exit;
}
$updateQuery = "UPDATE proxy SET proxy_balance = proxy_balance + $proxy_prices WHERE proxy_acc = '$proxy_upid'";
$updateResult = mysqli_query($con, $updateQuery);
if (!$updateResult) {
echo '';
exit;
}
// 在revenue表中插入一条数据
$insertQuery = "INSERT INTO revenue (account, oderid, name, price,oder_sta , state, type, dz_time, cr_time, beizhu) VALUES ('$proxy_upid', '$orderid', '$name', $proxy_prices,3, 2, 0, $dz_time, $cr_time, '$note')";
$insertResult = mysqli_query($con, $insertQuery);
if (!$insertResult) {
// echo '';
echo "Error updating record: " . $con->error;
exit;
}
echo '';
}
// 处理第三种情况：account、price、proxy_upid、proxy_prices、proxy_upids和proxy_pricess都有值
if (!empty($account) && !empty($price) && !empty($proxy_upid) && !empty($proxy_prices) && !empty($proxy_upids) && !empty($proxy_pricess)) {
// 使用第一种方式和第二种方式执行完后，查询proxy表中proxy_acc = proxy_upids的数据，并给字段proxy_balance的值加上proxy_pricess
$updateQuery = "UPDATE proxy SET proxy_balance = proxy_balance + $price WHERE proxy_acc = '$account'";
$updateResult = mysqli_query($con, $updateQuery);
if (!$updateResult) {
echo '';
exit;
}
// 更新revenue表中的数据
$updateQuery = "UPDATE revenue SET state = 2, type = 0, dz_time = $dz_time WHERE id = $id";
$updateResult = mysqli_query($con, $updateQuery);
if (!$updateResult) {
echo '';
exit;
}
$updateQuery = "UPDATE proxy SET proxy_balance = proxy_balance + $proxy_prices WHERE proxy_acc = '$proxy_upid'";
$updateResult = mysqli_query($con, $updateQuery);
if (!$updateResult) {
echo '';
exit;
}
// 在revenue表中插入一条数据
$insertQuery = "INSERT INTO revenue (account, oderid, name, price,oder_sta , state, type, dz_time, cr_time, beizhu) VALUES ('$proxy_upid', '$orderid', '$name', $proxy_prices,3, 2, 0, $dz_time, $cr_time, '$note')";
$insertResult = mysqli_query($con, $insertQuery);
if (!$insertResult) {
// echo '';
echo "Error updating record: " . $con->error;
exit;
}
$updateQuery = "UPDATE proxy SET proxy_balance = proxy_balance + $proxy_pricess WHERE proxy_acc = '$proxy_upids'";
$updateResult = mysqli_query($con, $updateQuery);
if (!$updateResult) {
echo '';
exit;
}
// 在revenue表中插入一条数据
$insertQuery = "INSERT INTO revenue (account, oderid, name, price, oder_sta, state, type, dz_time, cr_time, beizhu) VALUES ('$proxy_upids', '$orderid', '$name', $proxy_pricess,3, 2, 0, $dz_time, $cr_time, '$notes')";
$insertResult = mysqli_query($con, $insertQuery);
if (!$insertResult) {
echo '';
exit;
}
echo '';
}
mysqli_close($con);
?>