public function get_data_report_daily($date_start, $date_end)
{
$results = PaymentHistory::whereBetween('payment_histories.created_at', [$date_start, $date_end])->join('transactions', 'payment_histories.transaction_id', '=', 'transactions.id')->join('customers', 'transactions.customer_id', '=', 'customers.id')->join('status', 'transactions.status_id', '=', 'status.id')->select('payment_histories.amount as amount_payment', 'payment_histories.description as desc_payment', 'payment_histories.created_at as created_at_payment', 'transactions.invoice_number', 'transactions.date_checkout', 'transactions.discount', 'status.name as status_trans', 'transactions.date_order', 'customers.name as customer_name', 'customers.address as customer_address')->get();
return $results;
}
