/** * 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 }