SELECT SUM(SELECT people_num FROM bo_reception_process_record WHERE attend = 2) attend, SUM(SELECT people_num FROM bo_reception_process_record WHERE attend = 1) unattend, sum(SELECT people_num FROM bo_reception_process_record WHERE status = 10) consumerEntryNumber, sum(SELECT people_num FROM bo_reception_process_record WHERE status = 20) logisticsEntryNumber FROM `bo_reception_process_record` pr WHERE pr.delete_time = 0 AND pr.process_id = 1664162709840809986 请帮我修改成可执行sql

好的，以下是修改后的 SQL 语句：

SELECT 
  SUM(CASE WHEN attend = 2 THEN people_num ELSE 0 END) AS attend,
  SUM(CASE WHEN attend = 1 THEN people_num ELSE 0 END) AS unattend,
  SUM(CASE WHEN status = 10 THEN people_num ELSE 0 END) AS consumerEntryNumber,
  SUM(CASE WHEN status = 20 THEN people_num ELSE 0 END) AS logisticsEntryNumber
FROM 
  bo_reception_process_record
WHERE 
  delete_time = 0 AND process_id = '1664162709840809986';

以上 SQL 语句中，使用了 `CASE WHEN` 函数对 `people_num` 进行了分类求和，分别计算了 `attend = 2`，`attend = 1`，`status = 10`，`status = 20` 四种情况下的总人数。同时，增加了 `delete_time = 0` 和 `process_id = '1664162709840809986'` 的筛选条件。您只需要将 `1664162709840809986` 替换成您想要筛选的 `process_id` 即可。

相关问题

bo_reception_process_record表中有process_id，attend，status，people_num字段，现在想根据process_id筛选出来的数据，获取到attend = 2和attend = 1和status = 10和status = 20不同状态下，计算people_num的总数，请帮我写一个sql

好的，以下是根据您的要求写的 SQL 语句：

SELECT 
  SUM(IF(attend = 1 AND status = 10, people_num, 0)) AS attend_1_status_10_num,
  SUM(IF(attend = 1 AND status = 20, people_num, 0)) AS attend_1_status_20_num,
  SUM(IF(attend = 2 AND status = 10, people_num, 0)) AS attend_2_status_10_num,
  SUM(IF(attend = 2 AND status = 20, people_num, 0)) AS attend_2_status_20_num
FROM 
  bo_reception_process_record
WHERE 
  process_id = 'your_process_id';

以上 SQL 语句中，使用了 `IF` 函数对 `people_num` 进行了分类求和，分别计算了 `attend = 1` 且 `status = 10`，`attend = 1` 且 `status = 20`，`attend = 2` 且 `status = 10`，`attend = 2` 且 `status = 20` 四种情况下的总人数。您只需要将 `your_process_id` 替换成您想要筛选的 `process_id` 即可。

HAL_UARTEx_ReceiveToIdle_DMA示例

以下是HAL_UARTEx_ReceiveToIdle_DMA的示例代码：

/* Includes ------------------------------------------------------------------*/
#include "main.h"
#include "stm32f4xx_hal.h"

/* Private variables ---------------------------------------------------------*/
UART_HandleTypeDef huart2;
DMA_HandleTypeDef hdma_usart2_rx;

/* Private function prototypes -----------------------------------------------*/
void SystemClock_Config(void);
static void MX_GPIO_Init(void);
static void MX_DMA_Init(void);
static void MX_USART2_UART_Init(void);

/* Private functions ---------------------------------------------------------*/

/**
  * @brief  The application entry point.
  * @retval int
  */
int main(void)
{
  HAL_Init();

  /* Configure the system clock */
  SystemClock_Config();

  /* Initialize all configured peripherals */
  MX_GPIO_Init();
  MX_DMA_Init();
  MX_USART2_UART_Init();

  uint8_t buffer[100] = {0};
  uint32_t rx_size;

  while (1)
  {
    // Start UART reception in DMA mode until idle
    HAL_UARTEx_ReceiveToIdle_DMA(&huart2, buffer, sizeof(buffer));

    // Wait until idle
    while (HAL_UARTEx_GetRxIdleness(&huart2) != RESET);

    // Get received data size
    rx_size = sizeof(buffer) - __HAL_DMA_GET_COUNTER(&hdma_usart2_rx);

    // Process received data
    // ...

    // Clear buffer
    memset(buffer, 0, sizeof(buffer));
  }
}

/**
  * @brief System Clock Configuration
  * @retval None
  */
void SystemClock_Config(void)
{
  RCC_OscInitTypeDef RCC_OscInitStruct = {0};
  RCC_ClkInitTypeDef RCC_ClkInitStruct = {0};

  /** Initializes the RCC Oscillators according to the specified parameters
  * in the RCC_OscInitTypeDef structure.
  */
  RCC_OscInitStruct.OscillatorType = RCC_OSCILLATORTYPE_HSI;
  RCC_OscInitStruct.HSIState = RCC_HSI_ON;
  RCC_OscInitStruct.HSICalibrationValue = RCC_HSICALIBRATION_DEFAULT;
  RCC_OscInitStruct.PLL.PLLState = RCC_PLL_NONE;
  if (HAL_RCC_OscConfig(&RCC_OscInitStruct) != HAL_OK)
  {
    Error_Handler();
  }
  /** Initializes the CPU, AHB and APB buses clocks
  */
  RCC_ClkInitStruct.ClockType = RCC_CLOCKTYPE_HCLK|RCC_CLOCKTYPE_SYSCLK
                              |RCC_CLOCKTYPE_PCLK1|RCC_CLOCKTYPE_PCLK2;
  RCC_ClkInitStruct.SYSCLKSource = RCC_SYSCLKSOURCE_HSI;
  RCC_ClkInitStruct.AHBCLKDivider = RCC_SYSCLK_DIV1;
  RCC_ClkInitStruct.APB1CLKDivider = RCC_HCLK_DIV1;
  RCC_ClkInitStruct.APB2CLKDivider = RCC_HCLK_DIV1;

  if (HAL_RCC_ClockConfig(&RCC_ClkInitStruct, FLASH_LATENCY_0) != HAL_OK)
  {
    Error_Handler();
  }
}

/**
  * @brief USART2 Initialization Function
  * @param None
  * @retval None
  */
static void MX_USART2_UART_Init(void)
{
  huart2.Instance = USART2;
  huart2.Init.BaudRate = 115200;
  huart2.Init.WordLength = UART_WORDLENGTH_8B;
  huart2.Init.StopBits = UART_STOPBITS_1;
  huart2.Init.Parity = UART_PARITY_NONE;
  huart2.Init.Mode = UART_MODE_TX_RX;
  huart2.Init.HwFlowCtl = UART_HWCONTROL_NONE;
  huart2.Init.OverSampling = UART_OVERSAMPLING_16;
  huart2.Init.OneBitSampling = UART_ONE_BIT_SAMPLE_DISABLE;
  huart2.Init.ClockPrescaler = UART_PRESCALER_DIV1;
  huart2.AdvancedInit.AdvFeatureInit = UART_ADVFEATURE_NO_INIT;
  if (HAL_UART_Init(&huart2) != HAL_OK)
  {
    Error_Handler();
  }
}

/**
  * Enable DMA controller clock
  */
static void MX_DMA_Init(void)
{
  /* DMA controller clock enable */
  __HAL_RCC_DMA1_CLK_ENABLE();

  /* DMA interrupt init */
  /* DMA1_Stream5_IRQn interrupt configuration */
  HAL_NVIC_SetPriority(DMA1_Stream5_IRQn, 0, 0);
  HAL_NVIC_EnableIRQ(DMA1_Stream5_IRQn);
}

/**
  * @brief GPIO Initialization Function
  * @param None
  * @retval None
  */
static void MX_GPIO_Init(void)
{
  /* GPIO Ports Clock Enable */
  __HAL_RCC_GPIOH_CLK_ENABLE();
  __HAL_RCC_GPIOA_CLK_ENABLE();
  __HAL_RCC_GPIOD_CLK_ENABLE();
}

/**
  * @brief  This function is executed in case of error occurrence.
  * @retval None
  */
void Error_Handler(void)
{
  /* User may add here some code to deal with this error */
  while(1)
  {
  }
}

/**
  * @brief  This function is executed in case of DMA interrupt occurrence.
  * @retval None
  */
void DMA1_Stream5_IRQHandler(void)
{
  HAL_DMA_IRQHandler(&hdma_usart2_rx);
}

/**
  * @brief  This function is executed when DMA reception is completed.
  * @param  huart: UART handle
  * @retval None
  */
void HAL_UARTEx_RxEventCallback(UART_HandleTypeDef *huart)
{
  if (huart->Instance == USART2)
  {
    // DMA reception completed, do something if needed
  }
}

在此示例代码中，我们使用STM32Cube HAL库实现了UART的DMA接收，使用了HAL_UARTEx_ReceiveToIdle_DMA函数。在主循环中，我们不断调用该函数以启动DMA接收，然后等待DMA接收完成。一旦接收完成，我们就可以对接收到的数据进行处理。注意，在处理完数据后，我们需要清空接收缓冲区，以便下一次接收。