SELECT '2021-09-13' AS date
     , IF(wpi.document_id <> '', wi.supplier_id, i.supplier_id) AS supplier_id
     , IF(wpi.invoice_id <> -1, i.supplier_contract_id, -1) AS supplier_contract_id
     , IF(wpi.invoice_id <> -1, i.storage_id, -1) AS storage_id
     , IF(wpi.invoice_id <> -1, wpi.invoice_pa_id, wpi.pa_id) AS pa_id
     , IFNULL(wpi.name, '') AS name
     , SUM(IF(wpi.document_id <> '', 1, 0)) AS wms_amount
     , SUM(IF(wpi.invoice_id <> -1, 1, 0)) AS invoice_amount
     , 'regular' AS type
FROM wms.wms_product_in wpi
LEFT JOIN wms.wms_in wi ON wi.document_id = wpi.document_id
LEFT JOIN fin.invoice i ON i.id = wpi.invoice_id
LEFT JOIN wms.income_invoice_check iic ON iic.income_wms_product_in_id = wpi.id
    AND iic.type = 'ignore'
WHERE (wpi.active = 1 OR iic.active = 1)
  AND wpi.id IN (56406,55773)
#   AND ((LENGTH(wpi.document_id) > 0) + (wpi.invoice_id <> -1)) = 1
  AND DATE_FORMAT(IF(wi.id IS NOT NULL, wi.create_date, i.date_received), '%Y-%m-%d') = '2021-09-13'
GROUP BY supplier_id
       , supplier_contract_id
       , storage_id
       , pa_id