[KOHANA]zebranie wszystkich rekordów w tablicy i odpowiednie wyświetlenie. Opcje

[dominick]

Witam, chciałbym aby email wysyłał wszystkie opcje, które spełniają warunek. Teraz wysyła każdą opcję osobno.
oto kod:

[PHP] pobierz, plaintext 
public function action_expiring()
	{ 
 
 
		$announcements = ORM::factory('Announcement')
				->with('user')
				->where(Db::expr('DATEDIFF(announcement.annoucement_availability, NOW())'), '=', 7)
				->find_all();
 
		$i = 0;
 
		foreach ($announcements as $a)
		{
 
				$email = Model_Email::email_by_alias('annoucements_expiring_registered');
 
				$renew_url = Route::url('site_announcements/profile/announcements/renew', array(
					'id' => $a->annoucement_id,
				), 'http');
 
				$email->set_tags(array(
					'%renew_url%' => $renew_url,
					'%renew_link%'	=> HTML::anchor(
						$renew_url, 
						___('announcements.expiring.registered.renew_btn')
					),
					'%annoucement_link%' => HTML::anchor(announcements::url($a, 'http'), $a->annoucement_title),
				));
				$email->send($a->user->user_email);
			}
			$i++;
 
	}
[PHP] pobierz, plaintext 

Nie mam pomysłu jak do tego podejść.

[dominick]

Wrzucam cały kontroler przetwarzany przez crona czy tak to powinno wyglądać? (nie mam możliwości sprawdzenia bo cron działa raz dziennie o 00:00)

[PHP] pobierz, plaintext 
class Controller_Cron_Announcements extends Controller_Cron_Main {
 
	public function action_expiring()
	{ 
 
 
		$announcements = ORM::factory('Announcement')
				->with('user')
				->where(Db::expr('DATEDIFF(announcement.annoucement_availability, NOW())'), '=', 7)
				->find_all();
 
 
 
		foreach ($announcements as $a)
		{
 
				$renew_url = Route::url('site_announcements/profile/announcements/renew', array('id' => $a->annoucement_id,), 'http');
 
    $annoucments[] = array(
        '%renew_url%' => $renew_url, 
        '%renew_link%' => HTML::anchor($renew_url, ___('announcements.expiring.registered.renew_btn')), 
		'%annoucement_link%' => HTML::anchor(announcements::url($a, 'http'), $a->annoucement_title),
 
    );
	$annoucments['%annoucement_link%'] = implode('<br>',$annoucments['%annoucement_link%']);
	$email = Model_Email::email_by_alias('annoucements_expiring_registered');
    $email->set_tags($annoucments);
    $email->send($a->user->user_email);
			}
}
[PHP] pobierz, plaintext