<?php

namespace Modules\RechercheArticles\Repository;

use Modules\RechercheArticles\Repository\Requete;

class RequeteCont extends Requete
{
    protected function getRequeteArticleByRank() : string
    {
        return "Oxaproc_CatArtContRankDes";
    }

    protected function getRequeteListePannel() : string
    {
        return "Oxaproc_ChercheCatArtContNav";
    }

    protected function getRequeteListeCarSelect() : string
    {
        return "Oxaproc_CarselectCatArtContNav";
    }

    protected function getRequeteCountArticle() : string
    {
        return "Oxaproc_CountCatArtContRankDes";
    }

    protected function getRequeteArticleGenerique() : string
    {
        return "Oxaproc_GenArtContRankDes";
    }

    protected function getRequeteCountArticleGenerique() : string
    {
        return "Oxaproc_CountGenArtContRankDes";
    }

    protected function getJoinFilter(string $table) : string
    {
        return "INNER JOIN CONTAINSTABLE (dbo.$table,'{$this->listeColonne}', '{$this->recherche}') AS d ON a.ROW_COMPTEUR = d.[KEY]";
    }
}
