$string = isset($tipo_auto_cota) ? $tipo_auto_cota : '';
$numbers = [];
if (!empty($string)) {
$numbers = explode(',', $string);
};
$cotas_reservadas = count($numbers);
if (substr($string, -1) == ',') {
$cotas_reservadas--;
}
$paid_and_pending = $pending_numbers + $paid_numbers;
$total_reservadas = $paid_numbers;
if ($status_auto_cota == 0) {
$cotas_reservadas = 0;
}
$available = (int) $qty_numbers - $paid_and_pending - $cotas_reservadas;
$percent = (($paid_and_pending + $cotas_reservadas) * 100) / $qty_numbers;
$enable_share = $_settings->info('enable_share');
$enable_groups = $_settings->info('enable_groups');
$telegram_group_url = $_settings->info('telegram_group_url');
$whatsapp_group_url = $_settings->info('whatsapp_group_url');
$support_number = $_settings->info('phone');
$theme = $_settings->info('theme');
$bgTheme = "";
$textTheme = "";
if ($theme == 1) {
$bgTheme = "bg-white";
$textTheme = "text-dark";
} else if ($theme == 2) {
$bgTheme = "bg-dark";
$textTheme = "text-light";
} else if ($theme == 3) {
$bgTheme = "bg-secondary";
$textTheme = "text-light";
} else if ($theme == 4) {
$bgTheme = "bg-primary-custom";
$textTheme = "text-light";
} else if ($theme == 5) {
$bgTheme = "bg-dark";
$textTheme = "text-light";
}
$max_discount = 0;
if ($available < $min_purchase) {
$min_purchase = $available;
}
$enable_cpf = $_settings->info('enable_cpf');
if ($enable_cpf == 1) {
$search_type = 'search_orders_by_cpf';
} else {
$search_type = 'search_orders_by_phone';
}
$major = [];
$minor = [];
// Prepare the base SQL query
$sql = 'SELECT * FROM order_list WHERE product_id = ?';
// Prepare and execute the query
$stmt = $conn->prepare($sql);
$stmt->bind_param('s', $id);
$stmt->execute();
$result = $stmt->get_result();
// Loop through the results and calculate the major and minor values
while ($row = $result->fetch_assoc()) {
$order_numbers .= $row['order_numbers'] . ',';
}
if (!empty($order_numbers)) {
$order_numbers = rtrim($order_numbers, ',');
$order_numbers = explode(',', $order_numbers);
$order_numbers = array_filter($order_numbers);
$stmt = $conn->prepare('SELECT o.customer_id, c.firstname, c.lastname, o.date_created,c.phone
FROM order_list o
INNER JOIN customer_list c ON o.customer_id = c.id
WHERE FIND_IN_SET(?, order_numbers) AND product_id = ? AND status = 2');
$order_number = max($order_numbers); // Ensure $order_numbers is an array or list
$stmt->bind_param('si', $order_number, $id);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();
if ($row) {
// Check if a row is fetched
$major['cota'] = $order_number;
$major['winner'] = $row['firstname'] . ' ' . $row['lastname'];
$major['date_created'] = date('d/m/Y H:i:s', strtotime($row['date_created']));
$major['phone'] = $row['phone'];
}
$stmt = $conn->prepare('SELECT o.customer_id, c.firstname, c.lastname, o.date_created, c.phone
FROM order_list o
INNER JOIN customer_list c ON o.customer_id = c.id
WHERE FIND_IN_SET(?, order_numbers) AND product_id = ? AND status = 2');
$order_number = min($order_numbers); // Ensure $order_numbers is an array or list
$stmt->bind_param('si', $order_number, $id);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();
if ($row) {
// Check if a row is fetched
$minor['cota'] = $order_number;
$minor['winner'] = $row['firstname'] . ' ' . $row['lastname'];
$minor['date_created'] = date('d/m/Y H:i:s', strtotime($row['date_created']));
$minor['phone'] = $row['phone'];
}
}
// Close the statement and connection
$stmt->close();
?>
Estamos gerando seu pedido, aguarde...
Peto Grau vem com mais uma ação!! Valendo R$ 1000milzão no P!X;
e agora com prêmios das roletas premiadas .
Usuário não autenticado
Você está adquirindo cotas da ação entre amigos 1000Milzão No P!X , seus números serão gerados assim que concluir a compra.
Faça login para ter seu link de indicao, e ganhe at 0,00% de créditos nas compras aprovadas!
Quase lá!
Compartilhe seu link com todo mundo!
