= %d", $ip, $ip); //$sth = $dbh->prepare($query); //$sth->execute(); //$user_id_country = $sth->fetch(); //echo "
USER ID COUNTRY:
"; print_r($user_id_country); echo "
"; if (!empty($_GET['id_company'])) { //$where_OLD = sprintf(" AND (hot_opportunity_company.id_company = %d OR hot_opportunity.id_hot_opportunity NOT IN(SELECT id_hot_opportunity FROM hot_opportunity_company))",$_GET['id_company']); //$where = sprintf(" AND (news_company.id_company = %d OR news.id_news NOT IN(SELECT id_news FROM news_company))", $_GET['id_company']); } else $where = ''; if (!empty($_GET['program'])){ $where = sprintf(" AND news_program.id_program = %d", $_GET['program']); } /* $where .= ' AND ( ( news.start_date <= NOW() AND news.stop_date >= NOW() AND (news.repeat_every_year = 0 OR news.repeat_every_year IS NULL) ) OR ( MONTH(news.start_date) <= MONTH(NOW()) AND MONTH(news.stop_date) >= MONTH(NOW()) AND news.repeat_every_year = 1 ) ) '; */ /* POSSIBILITIES: 1. start date >= now & stop date >= now REPEAT YEARLY = TRUE: 2. repeat every year & current year start date <= now & current year stop date <= now 3. repeat every year & start date month >= stop date month & next year start date >= now & current year stop date <= now 4. repeat every year & start date month >= stop date month & current year stop date >= now */ $where .= " AND ( ( news.start_date <= now() AND stop_date >= now() ) OR ( news.repeat_every_year = 1 AND STR_TO_DATE( CONCAT(YEAR(now()),'-',MONTH(news.start_date),'-',DAY(news.start_date)),'%Y-%m-%d' ) <= now() AND STR_TO_DATE( CONCAT(YEAR(now()),'-',MONTH(news.stop_date),'-',DAY(news.stop_date)),'%Y-%m-%d' ) >= now() ) OR ( news.repeat_every_year = 1 AND MONTH(news.start_date) >= MONTH(news.stop_date) AND ( ( STR_TO_DATE( CONCAT(YEAR(now())+1,'-',MONTH(news.start_date),'-',DAY(news.start_date)),'%Y-%m-%d' ) >= now() AND STR_TO_DATE( CONCAT( YEAR( now() ),'-',MONTH(news.stop_date),'-',DAY(news.stop_date) ),'%Y-%m-%d' ) <= now() ) OR ( STR_TO_DATE( CONCAT(YEAR(now()),'-',MONTH(news.stop_date),'-',DAY(news.stop_date)),'%Y-%m-%d' ) >= now() ) ) ) ) "; if (!empty($user_id_country)){ //$where_OLD .= " AND ( hot_opportunity.id_hot_opportunity IN ( SELECT id_hot_opportunity FROM hot_opportunity_country WHERE id_country = $user_id_country )"; //$where .= " AND ( news.id_news IN ( SELECT id_news FROM news_country WHERE id_country = $user_id_country )"; //$where_OLD .= " OR hot_opportunity.id_hot_opportunity NOT IN ( SELECT id_hot_opportunity FROM hot_opportunity_country ) )"; //$where .= " OR news.id_news NOT IN ( SELECT id_news FROM news_country ) )"; } $query = "SELECT DISTINCT news.id_news, news.short_description, news.link, program.program_name FROM news LEFT OUTER JOIN news_company ON news.id_news = news_company.id_news LEFT OUTER JOIN company ON news_company.id_company = company.id_company LEFT OUTER JOIN news_country ON news_country.id_news = news.id_news LEFT OUTER JOIN country ON news_country.id_country = country.id_country LEFT OUTER JOIN news_program ON news.id_news = news_program.id_news LEFT OUTER JOIN program ON program.id_program = news_program.id_program WHERE news.active = 1 $where ORDER BY news.id_news DESC"; //echo $query; $sth = $dbh->prepare($query); $sth->execute(); $opportunities = $sth->fetchAll(PDO::FETCH_ASSOC); $query = "SELECT id_program, program_name FROM program WHERE id_company = 1 AND program_active = 1 ORDER BY program_name"; $sth = $dbh->prepare($query); $sth->execute(); $programs = $sth->fetchAll(PDO::FETCH_ASSOC); if((isset($_SERVER['REMOTE_ADDR']) and $_SERVER['REMOTE_ADDR'] == '96.33.234.18')) { //echo "
"; print_r($programs); echo "
"; } ?> Hot Opportunities
CAEP EVs
We put learning to work!

Hot Opportunities

Hot Opportunities - CAEP Programs



FINAL PLACEMENT OPPORTUNITIES:

  • Swine:

    Year-long positions, applications accepted now.

  • Dairy:

    Year-long positions, applications accepted now.

  • Ranch/Beef:

    Cattle ranch placements starting in February. Application deadline TBD.

Field Crops:

  • Placements starting in March/April.
    Application Deadline: January.
  • Harvest placements starting in July.
    Application Deadline: May.

Custom Harvesting:

  • Placements starting in April.
    Application Deadline: January.

Animal Production

  • Apiculture:

    Starting in October.
    Application deadline: June.

  • Swine:

    Year-long positions, applications accepted on a rolling basis.

  • Dairy:

    Year-long positions, applications accepted on a rolling basis.

  • Ranch/Beef:

    Cattle ranch placements starting in February.
    Application deadline: November

Vegetable Production

  • Vegetable Operations:

    Starting in April.
    Application deadline: January.

Horticulture

  • Potted Plants:

    Beginning in January.
    Application deadline: October.

  • Tomato Greenhouses:

    Year-long positions starting in January and June.
    Application Deadline: July and October.

  • Landscaping:

    Starting in February.
    Application deadline: TBD.

  • Tree Nursery:

    Beginning in March/April.
    Application deadline: January.

Winery Positions:

  • Cellar:

    Starting in July/August.
    Application Deadline: June.

  • Lab Assistant:

    Starting in August/September.
    • Application Deadline: June.

  • Viticulture:

    Starting in February.

    • Application Deadline: November.

Equine

  • Year-long placements accepted all year.

Note: Missed the deadline? Email caep@caep.org for placement availability.





Apply Now!