[ZF][ZendFramework][ZF1.8] Wyswietlicz rekordy w petli foreach z dwoch tabel Opcje

[lucwebdesigntom]

Witam
Dopiero zaczynam przygode z ZF1.8 i moze jest to proste rozwiazanie ale prosilbym o pomoc)
Posiadam tabele:

1. Client


2. Message ktora pobiera rekordy za pomoca SELECT przy dodawaniu zamowienia:


W rezultacje mamy taki wynik:


Moje pytanie brzmi:
Jak moge zastapic 'day_id' 6 Days, 5 Days .... pelnymi wyrazeniami:
np.

6 Day : 1 a chce zeby bylo - 6 Day : Day message 1

Plik : list.phtml

[PHP] pobierz, plaintext 
<div class="client_element">
        <div class="tmp">
            <div class="plynna">
<?php
	foreach($this->paginator as $client) {
 
		$edit = "<a href='".$this->url(array('action' => 'edit', 'controller' =>'index', 'id' => $client['client_id']), 'default', true)."'>Edit</a>";
		$delete = "<a href='".$this->url(array('action' => 'delete', 'controller' =>'index', 'id' => $client['client_id']), 'default', true)."'>Delete</a>";
		$done = "<a href='".$this->url(array('action' => 'done', 'controller' =>'index', 'id' => $client['client_id']), 'default', true)."'>Done</a>";
 
		$result = 'Address: ' .$client['address'] . '<br> Town: ' .$client['town'] . '<br> Postcode: ' .$client['postocde'] . '<br> Make: ' .$client['make'] . '<br> Model: ' .$client['model'] . '<br> Color: ' .$client['colour']
				.'<br> Registration: ' .$client['registration'] . '<br> Delivery: ' .$client['delivery'] . '<br> Message 1: ' .$client['message_one'] . '<br> Message 2: ' .$client['message_two'] . '<br> Message 3: ' .$client['message_three']
				.'<br> 6 Days: ' .$client['six_days'] . '<br> 5 Days: ' .$client['five_days'] . '<br> 4 Days: ' .$client['four_days'] . '<br> 3 Days: ' .$client['three_days'] . '<br> 2 Days: ' .$client['two_days'] . '<br> 1 Day: ' .$client['one_day']
				.'<br> Today: ' .$client['today'] . '<br><br>' .$edit . '  ' .$delete . '  ' .$done . '<br><br>';
 
 
		echo $this->accordionPane('clients',
								$result,
								array('title' => 'ORDER ID' .$client['client_id']. ' - ' .$client['name'].' '.$client['surname']));
 
	}
 
	echo $this->accordionContainer('clients',
									array('active' => 'none', 'collapsible' => true));
 
?>
 
</div>
</div>
</div>
[PHP] pobierz, plaintext 

Plik controller.php

[PHP] pobierz, plaintext 
public function listAction()
	{
		 $DbTable = new $this->_db_table_class;
		 $this->view->objects = $DbTable->fetchAll();
 
	   $clientList = new My_ListClients();
	   $clientList = $clientList->listClients();
 
	   $paginator = new Zend_Paginator(new Zend_Paginator_Adapter_DbSelect($clientList));
	   $paginator->setItemCountPerPage(2)
				 ->setCurrentPageNumber($this->_getParam('page', 1));
 
		$this->view->paginator = $paginator;
 
		$DbTable = new Application_Model_DbTable_Client();
        $this->view->clienci = $DbTable->fetchAll();
 
 
	}
[PHP] pobierz, plaintext 

Dzieki wszystkim za pomoc
Lukasz

Ten post edytował lucwebdesigntom 24.08.2017, 11:31:20