14650

php design question - will a Helper help here?

I have to list several elements that are coming from a database source A and they are: team_id, team_name and team_score (translated for explanation sake).

I need to loop over them, and display that information.

So, I have, on the DAO side:

public function listOfTeams() { $select = $this->select() ->from(array('t'=>'teams'), array('cod_team','name','score')); return $this->fetchAll($select); }

On my team controller:

public function listAction() { $teamsDao = new TeamsDao(); $this->view->infoTeam = $teamsDao->listOfTeams(); }

And at the view:

<?php for($i = 0; $i < 30; $i++): ?> <?php if(isset($this->infoTeam[$i])): ?>

Now, the thing is, on each of those listed items, I need to add more information.

That information doesn't come directly from a database, but it's a result of some calculations.

Take for example the percentage of games done. (translated);

$totalGamesNumber > 0 ? ($gamesDone*100)/$totalGamesNumber : 0);

So, I need to grab the total games number from the database, then, for each team, I need to have the number of games done, so that I can have the percentage to be displayed.

The $gamesDone are obtained by:

$gameTeamDao->countGamesPerTeam($gameVo, $teamVo);

I'm stuck here, because I cannot see where/how should I call and make the method for calculating the percentage, in order to allow the percentage of games completed to be presented along with the other data.

Can I have some help out of this mud ?

If you had to write a helper for this, more or less, how will it looked like?

Thanks in advance, MEM

PS - If you need more detailed information. I can provide. I could be forgeting something that for me is taken, but that, for those who want to help it isn't. So, just let me know. Thanks a lot again.

Update: translated all post to English for help sake.

Answer1:

Since you are using ZF, you could make all this computations in the table row's class. Here's how. Let's say your teams class is called Application_Model_DbTable_Teams.

class Application_Model_DbTable_Teams extends Zend_Db_Table_Abstract { protected $_name = 'teams'; // table name protected $_id = 'teamId'; // table primary key // rows returned by fetchAll() will be of this class protected $_rowClass = 'Application_Model_DbRow_Teams'; }

Then you need to create the Application_Model_DbRow_Teams class where you will put the extra calculations

class Application_Model_DbRow_Teams extends Zend_Db_Table_Row_Abstract { public $percentGamesDone; public function init() { // This method gets called automatically by ZF when you instantiate a new // object from this class // This is where you will put your extra calculations, // like percentage games done, etc $this->percentGamesDone = $this->getPercentGames(); } public function getPercentGames() { $calculation = 3; // replace this with real data return $calculation; } }

Once you've done this, you can simply use any of the row's declared properties (like percentGameDone) directly from the view as they will be calculated right when you instanciate the rows.

Recommend

  • Matlab code optimization and removing loops [closed]
  • Pivot table calculated Field from count of values
  • Ordering of eigenvectors when calculating eigenvectors using LAPACK's ssteqr
  • html/css: how to create a hexagonal image-placeholder
  • how to use asyncio with boost.python?
  • longest common subsequence: why is this wrong?
  • Put percent labels next to legend instead of in the slice
  • Encode string to match encoded form field name in PHP POST array
  • array_search() in Session Array
  • Can I update/select from a table in one query?
  • Tools for understanding HTML layout
  • Cypher - matching two different possible paths and return both
  • How to make R's read_csv2() recognise the text characters properly
  • Android Activity.onWindowFocusChanged doesn't get called from within TabHost
  • ListItem.Attributes.Add not working
  • TextToSpeech.setEngineByPackageName() triggers NullPointerException
  • revitapi ironpython ToRoom returns “indexer # object”
  • Access variable of ScriptContext using Nashorn JavaScript Engine (Java 8)
  • App restarts from wrong activity
  • Needing to do .toArray() to get output of mongodb .find() on key name not value
  • CakePHP 2.0.4 - findBy magic methods with conditions
  • PHP - How to update data to MySQL when click a radio button
  • Is possible to count alias result on mysql
  • How to redirect a user to a different server and include HTTP basic authentication credentials?
  • Fill an image in a square container while keeping aspect ratio
  • what is the difference between the asp.net mvc application and asp.net web application
  • Upload files with Ajax and Jquery
  • Delete MySQLi record without showing the id in the URL
  • Apache 2.4 - remove | delete | uninstall
  • Numpy divide by zero. Why?
  • php design question - will a Helper help here?
  • AngularJs get employee from factory
  • Angular 2 constructor injection vs direct access
  • Java static initializers and reflection
  • Android Google Maps API OnLocationChanged only called once
  • IndexOutOfRangeException on multidimensional array despite using GetLength check
  • Authorize attributes not working in MVC 4
  • UserPrincipal.Current returns apppool on IIS
  • jQuery Masonry / Isotope and fluid images: Momentary overlap on window resize
  • How do I use LINQ to get all the Items that have a particular SubItem?