CREATE DEFINER=CURRENT_USER PROCEDURE `daily_summary_salesrpt`(IN `start_date` DATE, IN `end_date` DATE)
BEGIN
SET @sql = NULL;

SELECT
  GROUP_CONCAT(DISTINCT
    CONCAT(
      'format(SUM(CASE WHEN payment_method = ''',
      payments.payment_method,
      ''' THEN payment ELSE 0 END),2) AS `',
      acc_payment_types.name, '`'
    )
  ) INTO @sql
FROM payments
join acc_payment_types on acc_payment_types.id = payments.payment_method;

SET @sql = CONCAT('SELECT date(payments.created_at) as Date,acc_currencies.name, ', @sql, ' FROM payments join acc_currencies on acc_currencies.id = payments.currency 
 where  payments.status <> "Refund" and  date(payments.created_at) between "',start_date,'" and "',end_date,'" GROUP BY date(payments.created_at),currency  ');

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

END
