[PHP] pobierz, plaintext 
<?php
 
class Cron_Controller extends Controller
{
 
	public function do_jobs( $hash )
	{
		if( $hash != Kohana::config('config.cron_hash') )
		throw new Exception("Błędny parametr hash");
 
		$this->_send_extend_emails();
	}
 
	private function _send_extend_emails()
	{
		$adverts = new Adverts_Model();
		$emails = new Emails_Model();
		$yesterday_expired = $adverts->getYesterdayExpired();
		//echo kohana::debug($yesterday_expired);
		//die();
		foreach( $yesterday_expired as $advert )
		{
			$data = (array) $advert;
			$emails->send($data['contact_email'],null, 'Wygaśnięcie ogłoszenia', View::factory('emails/expired')->bind('data',$data)->render() );			
		}
	}
 
 
 
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
public function getYesterdayExpired()
	{
		$yesterday = date('Y-m-d', mktime(0, 0, 0, date('m'), date('d')-1, date('Y')) );
		$this->db->where('expiry_date', $yesterday);
		$query = $this->db->get('advertisements');
		// die($query->last_query());
		return $query->as_array();
 
	}
[PHP] pobierz, plaintext