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