/**
* Renderize the view.
*
* @return null
*/
public function render(array $clients, Work $work)
{
?>
<p>
<?php
echo REQUIRED_FIELDS_TEXT;
?>
</p>
<form action="<?php
echo $this->generateURL('work', 'edit', $work->getIdWork());
?>
" method="post">
<fieldset>
<div class="row">
<div class="col-md-6">
<div>
<label for="id_client">
Socio <small>(*)</small>
</label>
<select name="id_client" required>
<option value="">
Seleccionar
</option>
<?php
foreach ($clients as $client) {
if ($client->getIdClient() === $work->getIdClient()) {
?>
<option value="<?php
echo $client->getIdClient();
?>
" selected>
<?php
echo $client->getClientName();
?>
</option>
<?php
} else {
?>
<option value="<?php
echo $client->getIdClient();
?>
">
<?php
echo $client->getClientName();
?>
</option>
<?php
}
}
?>
</select>
</div>
<div>
<label for="work_name">
Nombre <small>(*)</small>
</label>
<input name="work_name" type="text" required value="<?php
echo $work->getWorkName();
?>
" />
</div>
</div>
<div class="col-md-6">
<div>
<label for="location">
Ubicación <small>(*)</small>
</label>
<input name="location" type="text" required value="<?php
echo $work->getLocation();
?>
" />
</div>
<div>
<label for="principal">
Comitente <small>(*)</small>
</label>
<input name="principal" type="text" required value="<?php
echo $work->getPrincipal();
?>
" />
</div>
<div>
<input type="submit" value="Modificar" />
</div>
</div>
</div>
</fieldset>
</form>
<?php
}
/**
* Modify a work saved in the database.
*
* @param Work $work
* @return integer
*/
public function editWork(Work $work)
{
$sql = "UPDATE work \n\t\t\tSET id_work = '" . $work->getIdWork() . "', id_client = '" . $work->getIdClient() . "', work_name = '" . replaceCharacters($work->getWorkName()) . "', location = '" . replaceCharacters($work->getLocation()) . "', principal = '" . replaceCharacters($work->getPrincipal()) . "', date = '" . $work->getDate() . "' WHERE id_work = '" . $work->getIdWork() . "'";
return DB::query($sql);
}
/**
* Renderize the view.
*
* @return null
*/
public function render(array $clients, Work $work)
{
?>
<!-- JQUERY UI -->
<link type="text/css" rel="stylesheet" href="<?php
echo APP_PATH;
?>
/css/jquery-ui.min.css">
<link type="text/css" rel="stylesheet" href="<?php
echo APP_PATH;
?>
/css/jquery-ui.theme.min.css">
<script type="text/javascript" src="<?php
echo APP_PATH;
?>
/js/jquery-ui.min.js"></script>
<script type="text/javascript">
$(function(){
$("#date").datepicker({dateFormat: "yy-mm-dd"});
});
</script>
<p>
<?php
echo REQUIRED_FIELDS_TEXT;
?>
</p>
<form action="<?php
echo $this->generateURL('work', 'edit', $work->getIdWork());
?>
" method="post">
<fieldset>
<div class="row">
<div class="col-md-6">
<div>
<label for="id_client">
Socio <small>(*)</small>
</label>
<select name="id_client" required>
<option value="">
Seleccionar
</option>
<?php
foreach ($clients as $client) {
if ($client->getIdClient() === $work->getIdClient()) {
?>
<option value="<?php
echo $client->getIdClient();
?>
" selected>
<?php
echo $client->getClientName();
?>
</option>
<?php
} else {
?>
<option value="<?php
echo $client->getIdClient();
?>
">
<?php
echo $client->getClientName();
?>
</option>
<?php
}
}
?>
</select>
</div>
<div>
<label for="work_name">
Nombre <small>(*)</small>
</label>
<input name="work_name" type="text" required value="<?php
echo $work->getWorkName();
?>
" />
</div>
</div>
<div class="col-md-6">
<div>
<label for="location">
Ubicación <small>(*)</small>
</label>
<input name="location" type="text" required value="<?php
echo $work->getLocation();
?>
" />
</div>
<div>
<label for="principal">
Comitente <small>(*)</small>
</label>
<input name="principal" type="text" required value="<?php
echo $work->getPrincipal();
?>
" />
</div>
<div>
<label for="date">
Fecha <small>(*)</small>
</label>
<input id="date" name="date" type="text" required value="<?php
echo $work->getDate();
?>
" />
</div>
<div>
<input type="submit" value="Modificar" />
</div>
</div>
</div>
</fieldset>
</form>
<?php
}
