/**
* Modify a index saved in the database.
*
* @param Index $index
* @return integer
*/
public function editIndex(Index $index)
{
$sql = "UPDATE cindex \n\t\t\tSET month = '" . $index->getMonth() . "', price = '" . $index->getPrice() . "', main_index = '" . $index->getMainIndex() . "', variation = '" . $index->getVariation() . "' WHERE id_index = '" . $index->getIdIndex() . "'";
return DB::query($sql);
}
/**
* Renderize the view.
*
* @return null
*/
public function render(Index $index)
{
?>
<p>
<?php
echo REQUIRED_FIELDS_TEXT;
?>
</p>
<form action="<?php
echo $this->generateURL('index', 'edit', $index->getIdIndex());
?>
" method="post">
<fieldset>
<div class="row">
<div class="col-md-6">
<div>
<label for="month">
Mes <small>(*)</small>
</label>
<input name="month" type="text" required value="<?php
echo $index->getMonth();
?>
" />
</div>
<div>
<label for="price">
$/m² <small>(*)</small>
</label>
<input name="price" type="text" required value="<?php
echo $index->getPrice();
?>
" />
</div>
</div>
<div class="col-md-6">
<div>
<label for="main_index">
Índice de la <br> construcción <small>(*)</small>
</label>
<input name="main_index" type="text" required value="<?php
echo $index->getMainIndex();
?>
" />
</div>
<div>
<label for="variation">
Variación con respecto <br> del mes anterior <small>(*)</small>
</label>
<input name="variation" type="text" required value="<?php
echo $index->getVariation();
?>
" />
</div>
<div>
<input type="submit" value="Modificar" />
</div>
</div>
</div>
</fieldset>
</form>
<?php
}
