dashboard

// Transaction
        $data["jukir_sum_transaction_payment"] = Cache::remember('dashboard-jukir-sum-today-transaction-payment', 10, function () use ($date) {
            return TransactionDetail::where("end_date", $date)->where('payment_type', '=', 4)->count();
        });

        $data["jukir_sum_transaction_payment_month"] = Cache::remember('dashboard-jukir-sum-month-transaction-payment', 10, function () use ($month) {
            return TransactionDetail::where("end_date", "LIKE", $month."%")->where('payment_type', '=', 4)->count();
        });

        $data["jukir_sum_transaction_payment_last_month"] = Cache::remember('dashboard-jukir-sum-last-month-transaction-payment', 3600, function () use ($month2) {
            return TransactionDetail::where("end_date", "LIKE", $month2."%")->where('payment_type', '=', 4)->count();
        });

        // Revenue
        $data["jukir_sum_revenue_payment"] = Cache::remember('dashboard-jukir-sum-rev-today-transaction-payment', 10, function () use ($date) {
            $total = TransactionDetail::select(DB::raw("sum(total) AS total"))->where("end_date", "=", $date)->where('payment_type', '=', 4)->first();

            return @$total->total;
        });

        $data["jukir_sum_revenue_payment_month"] = Cache::remember('dashboard-jukir-sum-rev-month-transaction-payment', 10, function () use ($month) {
            return TransactionDetail::select(DB::raw("sum(total)AS total"))->where("end_date", "like", $month. "%")->where('payment_type', '=', 4)->first()->total;
        });

        $data["jukir_sum_revenue_payment_last_month"] = Cache::remember('dashboard-jukir-sum-rev-last-month-transaction-payment', 10, function () use ($month2) {
            return TransactionDetail::select(DB::raw("sum(total)AS total"))->where("end_date", "like", $month2. "%")->first()->total;
        });


// Revenue Control
    public function getPerHari(){
        $date = date("Y-m-d");
        $month = date("Y-m");
        $month2 = date("Y-m", strtotime("previous month"));
        $data1 = Cache::remember("Cp_data_1", $this->minutes, function() use ($month){
            return DB::table("tb_transaction")
                ->join('tb_transaction_detail', 'tb_transaction_detail.transaction_id', '=', 'tb_transaction.id')
                ->where('tb_transaction_detail.payment_type', '=', 4)
                ->where("tb_transaction.date_transaction", "LIKE", $month."%")
                ->groupBy("tb_transaction.date_transaction")
                ->select(DB::raw("SUM(tb_transaction.amount) as jumlah"), "tb_transaction.date_transaction as end_date")
                ->get();
        });

        $data2 = Cache::remember("Cp_data_2", $this->minutes, function() use ($month2){
            return DB::table("tb_transaction")
                ->join('tb_transaction_detail', 'tb_transaction_detail.transaction_id', '=', 'tb_transaction.id')
                ->where('tb_transaction_detail.payment_type', '=', 4)
                ->where("tb_transaction.date_transaction", "LIKE", $month2."%")
                ->groupBy("tb_transaction.date_transaction")
                ->select(DB::raw("SUM(tb_transaction.amount) as jumlah"), "tb_transaction.date_transaction as end_date")
                ->get();
        });

        $re = array();
        $tmp = "";

        foreach ($data2 as $ke) {
            foreach ($data1 as $key) {
                $tmp = null;
                //samain tanggal
                if ($this->getDate($key->end_date) == $this->getDate($ke->end_date)) {
                    //masukan kedalam this_month
                    $tmp = $key->jumlah;
                    break;
                }
            }

            //buat json baru
            $re[] =[
                "date" => $ke->end_date,
                "this_month" => $tmp,
                "prev_month" => $ke->jumlah,
            ];
        }

        return json_encode($re);
    }

    private function getDate($D){
        $aD = explode("-",$D);
        return $aD[2];
    }