Table Action Not Working

 protected function getTableQuery(): Builder
    {
        $partnerId = $this->ownerRecord->id;


        $CURRENT_DATE = Carbon::today()->format('Y-m-d');

        $query = PlanPartnerPayment::withTrashed()
            ->selectRaw('CC.*, @cumulative_balance:=@cumulative_balance + CC.credit-CC.debit AS balance')
            ->fromRaw('(
            SELECT -1 as id, -1 as plan_partner_id, -1 as plan_id, partner_id, DATE_SUB(\'' . $CURRENT_DATE . '\', INTERVAL 1 YEAR) as date,
            CASE WHEN SUM(credit)-SUM(debit) < 0 THEN SUM(credit)-SUM(debit) ELSE 0 END as debit,
            CASE WHEN SUM(credit)-SUM(debit) >= 0 THEN SUM(credit)-SUM(debit) ELSE 0 END as credit
            FROM plan_partner_payments
            WHERE partner_id = ' . $partnerId . ' AND date < DATE_SUB(\'' . $CURRENT_DATE . '\', INTERVAL 1 YEAR)
            UNION ALL
            SELECT id, plan_partner_id, plan_id, partner_id, date, debit, credit
            FROM plan_partner_payments
            WHERE partner_id = ' . $partnerId . ' AND date >= DATE_SUB(\'' . $CURRENT_DATE . '\', INTERVAL 1 YEAR)
        ) CC
        JOIN (SELECT @cumulative_balance:=0) r
    ')->orderBy('CC.date');

        return $query;
    }

 protected function getTableQuery(): Builder
    {
        $partnerId = $this->ownerRecord->id;


        $CURRENT_DATE = Carbon::today()->format('Y-m-d');

        $query = PlanPartnerPayment::withTrashed()
            ->selectRaw('CC.*, @cumulative_balance:=@cumulative_balance + CC.credit-CC.debit AS balance')
            ->fromRaw('(
            SELECT -1 as id, -1 as plan_partner_id, -1 as plan_id, partner_id, DATE_SUB(\'' . $CURRENT_DATE . '\', INTERVAL 1 YEAR) as date,
            CASE WHEN SUM(credit)-SUM(debit) < 0 THEN SUM(credit)-SUM(debit) ELSE 0 END as debit,
            CASE WHEN SUM(credit)-SUM(debit) >= 0 THEN SUM(credit)-SUM(debit) ELSE 0 END as credit
            FROM plan_partner_payments
            WHERE partner_id = ' . $partnerId . ' AND date < DATE_SUB(\'' . $CURRENT_DATE . '\', INTERVAL 1 YEAR)
            UNION ALL
            SELECT id, plan_partner_id, plan_id, partner_id, date, debit, credit
            FROM plan_partner_payments
            WHERE partner_id = ' . $partnerId . ' AND date >= DATE_SUB(\'' . $CURRENT_DATE . '\', INTERVAL 1 YEAR)
        ) CC
        JOIN (SELECT @cumulative_balance:=0) r
    ')->orderBy('CC.date');

        return $query;
    }

  Tables\Actions\EditAction::make('payment')
                    ->label(__('Payment'))
                    ->successNotification(null)
                    ->closeModalByClickingAway(false)
                    ->recordTitle('Payment')

  Tables\Actions\EditAction::make('payment')
                    ->label(__('Payment'))
                    ->successNotification(null)
                    ->closeModalByClickingAway(false)
                    ->recordTitle('Payment')

  protected function getTableQuery(): Builder
    {
        $partnerId = $this->ownerRecord->id;


        $CURRENT_DATE = Carbon::today()->format('Y-m-d');

        $query = PlanPartnerPayment::withTrashed()
            ->selectRaw('plan_partner_payments.*, @cumulative_balance:=@cumulative_balance + plan_partner_payments.credit-plan_partner_payments.debit AS balance')
            ->fromRaw('(
            SELECT -1 as id, -1 as plan_partner_id, -1 as plan_id, partner_id, DATE_SUB(\'' . $CURRENT_DATE . '\', INTERVAL 1 YEAR) as date,
            CASE WHEN SUM(credit)-SUM(debit) < 0 THEN SUM(credit)-SUM(debit) ELSE 0 END as debit,
            CASE WHEN SUM(credit)-SUM(debit) >= 0 THEN SUM(credit)-SUM(debit) ELSE 0 END as credit
            FROM plan_partner_payments
            WHERE partner_id = ' . $partnerId . ' AND date < DATE_SUB(\'' . $CURRENT_DATE . '\', INTERVAL 1 YEAR)
            UNION ALL
            SELECT id, plan_partner_id, plan_id, partner_id, date, debit, credit
            FROM plan_partner_payments
            WHERE partner_id = ' . $partnerId . ' AND date >= DATE_SUB(\'' . $CURRENT_DATE . '\', INTERVAL 1 YEAR)
        ) plan_partner_payments
        JOIN (SELECT @cumulative_balance:=0) r
    ')->orderBy('plan_partner_payments.date');

        return $query;
    }

  protected function getTableQuery(): Builder
    {
        $partnerId = $this->ownerRecord->id;


        $CURRENT_DATE = Carbon::today()->format('Y-m-d');

        $query = PlanPartnerPayment::withTrashed()
            ->selectRaw('plan_partner_payments.*, @cumulative_balance:=@cumulative_balance + plan_partner_payments.credit-plan_partner_payments.debit AS balance')
            ->fromRaw('(
            SELECT -1 as id, -1 as plan_partner_id, -1 as plan_id, partner_id, DATE_SUB(\'' . $CURRENT_DATE . '\', INTERVAL 1 YEAR) as date,
            CASE WHEN SUM(credit)-SUM(debit) < 0 THEN SUM(credit)-SUM(debit) ELSE 0 END as debit,
            CASE WHEN SUM(credit)-SUM(debit) >= 0 THEN SUM(credit)-SUM(debit) ELSE 0 END as credit
            FROM plan_partner_payments
            WHERE partner_id = ' . $partnerId . ' AND date < DATE_SUB(\'' . $CURRENT_DATE . '\', INTERVAL 1 YEAR)
            UNION ALL
            SELECT id, plan_partner_id, plan_id, partner_id, date, debit, credit
            FROM plan_partner_payments
            WHERE partner_id = ' . $partnerId . ' AND date >= DATE_SUB(\'' . $CURRENT_DATE . '\', INTERVAL 1 YEAR)
        ) plan_partner_payments
        JOIN (SELECT @cumulative_balance:=0) r
    ')->orderBy('plan_partner_payments.date');

        return $query;
    }