SELECT '2021-09-14' 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
     , COUNT(IF(wpi.document_id <> '', 1, 0)) AS wms_amount
     , COUNT(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
WHERE wpi.active = 1
  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-14'
GROUP BY supplier_id
       , supplier_contract_id
       , storage_id
       , pa_id
;