arambalakjian / dataobject-as-page-filter Goto Github PK

SELECT DISTINCT "DataObjectAsPage"."ClassName", "DataObjectAsPage"."Created", "DataObjectAsPage"."LastEdited", "DataObjectAsPage"."URLSegment", "DataObjectAsPage"."Title", "DataObjectAsPage"."MetaTitle", "DataObjectAsPage"."MetaDescription", "DataObjectAsPage"."Content", "Job"."JobTeaser", "Job"."CompanyShort", "Job"."JobDesc", "Job"."CompanyDesc", "Job"."Adressat", "Job"."JobListingPageID", "Job"."UnternehmenID", "Job"."JobBildID", "Job"."TeamPicID", "DataObjectAsPage"."ID", 
CASE WHEN "DataObjectAsPage"."ClassName" IS NOT NULL 
THEN "DataObjectAsPage"."ClassName" 
ELSE 'DataObjectAsPage' 
END AS "RecordClassName" FROM "DataObjectAsPage" 
LEFT JOIN "Job" ON "Job"."ID" = "DataObjectAsPage"."ID" 
WHERE ("filter" IN ('Array')) AND ("DataObjectAsPage"."ClassName" IN ('Job')) 
ORDER BY "DataObjectAsPage"."Title" ASC 
Unknown column 'filter' in 'where clause' 

SELECT DISTINCT count(DISTINCT DataObjectAsPage.ID) AS "0" FROM DataObjectAsPage 
LEFT JOIN Job ON Job.ID = DataObjectAsPage.ID 
INNER JOIN Job_Kriterien ON Job_Kriterien.JobID = DataObjectAsPage.ID 
LEFT JOIN DataObjectAsPageCategory ON Job_Branchen.BrancheID = DataObjectAsPageCategory.ID 
LEFT JOIN Kriterium ON Job_Kriterien.KriteriumID = Kriterium.ID 
INNER JOIN Job_Branchen ON Job_Branchen.JobID = DataObjectAsPage.ID 
WHERE (Kriterium.ID IN ('4')) 
AND (DataObjectAsPageCategory.ID IN ('19')) 
AND (DataObjectAsPage.ClassName IN ('Job'));
ERROR 1054 (42S22): Unknown column 'Job_Branchen.BrancheID' in 'on clause'

SELECT DISTINCT count(DISTINCT DataObjectAsPage.ID) AS "0" FROM DataObjectAsPage 
LEFT JOIN Job ON Job.ID = DataObjectAsPage.ID 
INNER JOIN Job_Kriterien ON Job_Kriterien.JobID = DataObjectAsPage.ID 
LEFT JOIN Kriterium ON Job_Kriterien.KriteriumID = Kriterium.ID 
INNER JOIN Job_Branchen ON Job_Branchen.JobID = DataObjectAsPage.ID 
LEFT JOIN DataObjectAsPageCategory ON Job_Branchen.BrancheID = DataObjectAsPageCategory.ID 
WHERE (Kriterium.ID IN ('4')) 
AND (DataObjectAsPageCategory.ID IN ('19')) 
AND (DataObjectAsPage.ClassName IN ('Job'));
+---+
| 0 |
+---+
| 1 |
+---+
1 row in set (0.85 sec)

<?php

class FilteredJobListingPage extends FilteredListingPage{


}

class FilteredJobListingPage_Controller extends FilteredListingPage_Controller
{
    //Layout template to use to when AJAX is enabled (ignore if AJAX disabled)
    private static $ajax_template = 'FilteredJobListingPage';

    //This needs to know be the Class of the DataObject you want this page to list
    private static $item_class = 'Job';

    //Set the sort for the items (defaults to Created DESC)
    private static $item_sort = 'Title ASC';

    //Disable AJAX filtering and reload the page when filtering (defaults to true)
    private static $ajax_filter = true;

    private static $filter_settings = array(
        'Kriterien' => array(
            'Title' => 'Kriterium auswählen',
            'ClassName' => 'Kriterium',
            'Preposition' => 'mit',
            'MultiSelect' => false,
            'MatchAll' => false
        ),
        'Branchen' => array(
            'Title' => 'Branche auswählen',
            'ClassName' => 'Branche',
            'Preposition' => 'mit',
            'MultiSelect' => false,
            'MatchAll' => false
        )
    );
}