public function update(Terrain $terrain)
{
$query = $this->_db->prepare('
UPDATE t_terrain SET prix=:prix, vendeur=:vendeur, fraisAchat=:fraisAchat, superficie=:superficie,
emplacement=:emplacement, updated=:updated, updatedBy=:updatedBy WHERE id=:idTerrain') or die(print_r($this->_db->errorInfo()));
$query->bindValue(':idTerrain', $terrain->id());
$query->bindValue(':prix', $terrain->prix());
$query->bindValue(':vendeur', $terrain->vendeur());
$query->bindValue(':fraisAchat', $terrain->fraisAchat());
$query->bindValue(':superficie', $terrain->superficie());
$query->bindValue(':emplacement', $terrain->emplacement());
$query->bindValue(':updated', $terrain->updated());
$query->bindValue(':updatedBy', $terrain->updatedBy());
$query->execute();
$query->closeCursor();
}
public function update(Terrain $terrain)
{
$query = $this->_db->prepare(' UPDATE t_terrain SET
numeroTitre=:numeroTitre,nom=:nom,superficie=:superficie,surplan=:surplan,emplacement=:emplacement,prix=:prix
WHERE id=:id') or die(print_r($this->_db->errorInfo()));
$query->bindValue(':id', $terrain->id());
$query->bindValue(':numeroTitre', $terrain->numeroTitre());
$query->bindValue(':nom', $terrain->nom());
$query->bindValue(':superficie', $terrain->superficie());
$query->bindValue(':surplan', $terrain->surplan());
$query->bindValue(':emplacement', $terrain->emplacement());
$query->bindValue(':prix', $terrain->prix());
$query->execute();
$query->closeCursor();
}
$oStr .= "Column: " . $this->col . "<br/>";
$oStr .= "Row: " . $this->row . "<br/>";
$oStr .= "tdId: " . $this->tdId . "<br/>";
$oStr .= "canvasId: " . $this->canvasId . "<br/>";
return $oStr;
}
}
/* Create an array of terrain pieces */
foreach ($_POST as $key => $value) {
/*echo "Key($key): $value <br/>";*/
/* Only count terrain pieces from $_POST! */
if ($value && preg_match('#^t([A-Z].*)#', $key, $match)) {
$totalTerrainPieces += $value;
/* Create a Terrain object for each one */
for ($i = 0; $i < $value; $i++) {
$terrainPiece = new Terrain();
$terrainPiece->setId($p++);
$terrainPiece->setType($match[1]);
$terrainArray[] = $terrainPiece;
}
}
}
/* randomize the terrain pieces */
shuffle($terrainArray);
$pieceCount = 1;
$plotArray = array();
$terrainLocations = array();
foreach ($terrainArray as $piece) {
/*echo "<br/>----------------[" . $pieceCount . "] of [" . $terrainPiecesInThisMap . "]------------------<br/>";*/
do {
/* Make sure we aren't stacking pieces */
