/** * Renderize the view. * * @return null */ public function render(array $providerCategories, Provider $provider) { ?> <p> <?php echo REQUIRED_FIELDS_TEXT; ?> </p> <form action="<?php echo $this->generateURL('provider', 'edit', $provider->getIdProvider()); ?> " method="post"> <fieldset> <div class="row"> <div class="col-md-6"> <div> <label for="id_provider_category"> Categoría <small>(*)</small> </label> <select name="id_provider_category" required> <option value=""> Seleccionar </option> <?php foreach ($providerCategories as $providerCategory) { if ($provider->getIdProviderCategory() === $providerCategory->getIdProviderCategory()) { ?> <option value="<?php echo $providerCategory->getIdProviderCategory(); ?> " selected> <?php echo $providerCategory->getCategoryName(); ?> </option> <?php } else { ?> <option value="<?php echo $providerCategory->getIdProviderCategory(); ?> "> <?php echo $providerCategory->getCategoryName(); ?> </option> <?php } } ?> </select> </div> <div> <label for="provider_name"> Nombre <small>(*)</small> </label> <input name="provider_name" type="text" required value="<?php echo $provider->getProviderName(); ?> " /> </div> <div> <label for="location"> Ubicación <small>(*)</small> </label> <input name="location" type="text" required value="<?php echo $provider->getLocation(); ?> " /> </div> </div> <div class="col-md-6"> <div> <label for="phone"> Teléfono <small>(*)</small> </label> <input name="phone" type="tel" required value="<?php echo $provider->getPhone(); ?> " /> </div> <div> <label for="website"> Sitio web </label> <input name="website" type="url" value="<?php echo $provider->getWebsite(); ?> " /> </div> <div> <input type="submit" value="Modificar" /> </div> </div> </div> </fieldset> </form> <?php }
/** * Modify a provider saved in the database. * * @param Provider $provider * @return integer */ public function editProvider(Provider $provider) { $sql = "UPDATE provider \n\t\t\tSET id_provider_category = '" . $provider->getIdProviderCategory() . "', provider_name = '" . replaceCharacters($provider->getProviderName()) . "', location = '" . replaceCharacters($provider->getLocation()) . "', phone = '" . $provider->getPhone() . "', website = '" . $provider->getWebsite() . "' WHERE id_provider = '" . $provider->getIdProvider() . "'"; return DB::query($sql); }