gistfile1.php

<?php
/**
 * Archive jobs after the end date
 *
 * @return void
 * @access private
 * @since  2.0
 */
private function _archiveJobs()
{
    $end_date = strtotime('-30 days');
    $this->db->setQuery('SELECT * FROM `#__jobline_jobs` WHERE `published` = 1');
    $items = $this->db->loadObjectList();
    foreach($items as $item) {
        if(strtotime($item->start_date) < $end_date) {
            $this->db->setQuery('UPDATE `#__jobline_jobs` SET `published` = 0 WHERE `id` = '.$item->id);
            $this->db->query();
        }
    }
}
?>