Laravel Türkiye Discord Kanalı Forumda kod paylaşılırken dikkat edilmesi gerekenler!Birlikte proje geliştirmek ister misiniz?

Laravel Excel Column

aghabalaguluzade

selam ben Maatwebsite Excel kullanıyorum ve


class InvoicesExport implements FromQuery
{
    use Exportable;

    public function query()
    {
        return DB::table('survey_responses')
    ->join('surveys', 'survey_responses.survey_id', '=', 'surveys.id')
    ->join('questions', 'survey_responses.questions_id', '=', 'questions.id')
    ->join('answers', 'survey_responses.answer_id', '=', 'answers.id')
    ->join('questionnaire', 'questions.questionnaire_id', '=', 'questionnaire.id')
    ->select(
        'surveys.name as Survey Name',
        'surveys.email as Survey Email',
        'questionnaire.title as Questionnaire Title',
        'questionnaire.purpose as Questionnaire Purpose',
        'questions.question as Question',
        'answers.answer as Answer'
    )
    ->orderByDesc('survey_responses.id');
    }
}

bana şöyle bir çıktı veriyor

https://prnt.sc/cH7FM61zn8cj

fakat benden istenen

https://prnt.sc/SLP2aJrF0XHh

şöyle veya

https://prnt.sc/5wSg2V-A6gH1

şöyle bir şey bunu yapabilmemin bir yolu var mı sizce

mgsmus

aghabalaguluzade Şu sayfaya bakın:
https://docs.laravel-excel.com/3.1/exports/from-view.html

Buradaki gibi, istediğiniz yapıda view oluşturup veriyi içeride foreach vs kullanarak istediğiniz şekle getirin.

aghabalaguluzade

mgsmus teşekkür ederim hocam bunu dokümentasyonda görmüştüm fakat benim istediğim

https://prnt.sc/nsJWdzjqfnB0

Name, Email, Title ve Purpose tekrar ediyor ve ben istiyorum ki tekrar ediyorsa olmasın boş gelsin

https://prnt.sc/zmG6qgE-xuJT

yani böyle

bu arada

public function headings(): array
    {
        return ["Name", "Email", "Title", "Purpose", "Question", "Answer"];
    }

burada Title ve Purpose başlıq altda gözüken ise survey title ismi ve purpose girdisi fakat ben rastgele yazdığım için title ve purpose diye kalmış

aghabalaguluzade

Çözümü şöyle

public function view(): View
    {
        $surveys = DB::table('survey_responses')
        ->join('surveys', 'survey_responses.survey_id', '=', 'surveys.id')
        ->join('questions', 'survey_responses.questions_id', '=', 'questions.id')
        ->join('answers', 'survey_responses.answer_id', '=', 'answers.id')
        ->join('questionnaire', 'questions.questionnaire_id', '=', 'questionnaire.id')
        ->select(
            'surveys.name as Survey Name',
            'surveys.email as Survey Email',
            'questionnaire.title as Questionnaire Title',
            'questionnaire.purpose as Questionnaire Purpose',
            'questions.question as Question',
            'answers.answer as Answer'
        )->orderByDesc('survey_responses.id')
        ->get();

        return view('exports.surveys', [
            'surveys' => $surveys
        ]);
    }

<table>
    <thead>
        <tr>
            <th>Name</th>
            <th>Email</th>
            <th>Title</th>
            <th>Purpose</th>
            <th>Question</th>
            <th>Answer</th>
        </tr>
    </thead>
    <tbody>
        @php
            $previousSurveyName = '';
            $previousSurveyEmail = '';
            $previousTitle = '';
            $previousPurpose = '';
        @endphp

        @foreach($surveys as $survey)
            <tr>
                <td>
                    @if ($survey->{'Survey Name'} === $previousSurveyName)
                    @else
                        {{ $previousSurveyName = $survey->{'Survey Name'} }}
                    @endif
                </td>
                <td>
                    @if ($survey->{'Survey Email'} === $previousSurveyEmail)
                    @else
                        {{ $previousSurveyEmail = $survey->{'Survey Email'} }}
                    @endif
                </td>
                <td>
                    @if ($survey->{'Questionnaire Title'} === $previousTitle)
                    @else
                        {{ $previousTitle = $survey->{'Questionnaire Title'} }}
                    @endif
                </td>
                <td>
                    @if ($survey->{'Questionnaire Purpose'} === $previousPurpose)
                    @else
                        {{ $previousPurpose = $survey->{'Questionnaire Purpose'} }}
                    @endif
                </td>
                <td>{{ $survey->Question }}</td>
                <td>{{ $survey->Answer }}</td>
            </tr>
        @endforeach
    </tbody>
</table>

Önce - https://prnt.sc/9RvMkoHps3r5
Sonra - https://prnt.sc/P1MDbdHCa-Tg