mardi 21 mai 2019

Database sql server with results but view is empty

something really strange is happening. So I have a table named Lactinfo_News with 1 row. I've created also a view called LACTINFO_VW_LatestNews which have "SELECT * FROM Lactinfo_News" and is returning the same 1 row.

enter image description here

I'm using Eloquent and In my news Manager I have,

public function GetLatestNews($rowsPerPage) {
        $list = DB::table('LACTINFO_VW_LatestNews')
            ->orderBy('RegistedDate', 'DESC')
            ->paginate($rowsPerPage);

        return $list;
    }

where $rowsPerPage = 30.

In my controller I have,

// >> current page
$page = '1';
if (! empty ( $request->query ( 'page' ) )) {
$page = $request->query ( 'page' );
}

// >> search
$nM = new NewsManager();
$list = $nM->GetLatestNews($page, $this->nbOfRowsPage);

return view ('admin.news.index', [
                'results' => compact($list),
                'page' => $page,
                'startDate' => $startDate,
                'endDate'=>$endDate 
        ] );
    }

And in my view,

<table id="news-results" class="hover responsive" style="margin-top: 20px;">
    <thead>
        <tr>
            <th scope="column">Título</th>          
            <th scope="column">Descrição</th>
            <th scope="column">Data Início</th>
            <th scope="column">Ficheiro</th>
            <th scope="column">Registada em</th>
            <th scope="column">Criada por</th>
        </tr>
    </thead>

    <tbody>
        @if (count($results) > 0) 
            @foreach ($results as $r)
                <tr>
                    <td></td>
                    <td></td>
                    <td></td> 
                    <td></td>
                    <td></td>     
                    <td></td>            
                </tr>
            @endforeach

        @else
            <tr><td colspan="11">Não existem notícias criadas</td></tr>
        @endif
    </tbody>
</table>

If I dump the $results var is empty..

What's happening? This is really strange :S I don't think I need to execute any artisan command because I've add a new function to my manager but I'm stuck with this problem for a few days...



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire