Mercurial > bms / file revision

www/rec_edit.php@2ac491548d8d

www/rec_edit.php

Tue, 22 Jan 2019 20:27:45 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Tue, 22 Jan 2019 20:27:45 +0100
changeset 195
2ac491548d8d
parent 175
da16371538c3
child 220
14e349ff2a10
permissions
-rw-r--r--

Fermentables database bool to int types. Dropdown lists are using tables with indexes. Dropdown lists display in Dutch. Save and delete in the database now use POST instead of GET. Added the added and dissolved_protein fields. Removed the ibu_gal_per_lb field. Redesigned the web page. Code cleanup.

<?php
require_once($_SERVER['DOCUMENT_ROOT'].'/includes/global.inc.php');
page_header('Recept wijzigen', 'rec_edit');
// met POST commando's record ophalen.
?>

   <!-- Editor tabs. -->
   <div id="jqxTabs">
     <ul>
      <li>Algemeen</li>
      <li>Vergistbaar</li>
      <li>Hoppen</li>
      <li>Diversen</li>
      <li>Gist</li>
      <li>Maischen</li>
      <li>Water</li>
     </ul>

     <div> <!-- tab algemeen -->
      <div style="overflow: hidden;">
       <table style="width: 100%;">
        <tr>
         <td style="vertical-align: top; float: right; padding: 3px;">Recept naam:</td>
	 <td align="left" colspan="3" style="vertical-align: top; padding: 3px;"><input id="name" /></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Alleen lezen:</td>
         <td align="left" style="padding: 3px;"><div id="locked"></div></td>
        </tr>
        <tr>
         <td style="vertical-align: top; float: right; padding: 3px;">Opmerkingen:</td>
         <td colspan="5" style="padding: 3px;"><textarea id="notes"></textarea></td>
	</tr>
        <tr>
	 <td style="vertical-align: top; float: right; padding: 3px;">Brouw type:</td>
	 <td align="left" style="padding: 3px;"><div id="type"></div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Brouwzaal rendement:</td>
         <td colspan="3" style="padding: 3px;"><div id="efficiency"></div></td>
        </tr>
        <tr>
         <td style="vertical-align: top; float: right; padding: 3px;">Brouw volume:</td>
         <td style="padding: 3px;"><div id="batch_size"></div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Kooktijd minuten:</td>
	 <td style="padding: 3px;"><div id="boil_time"></div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Kook volume:</td>
         <td style="padding: 3px;"><div id="boil_size"></div></td>
	</tr>
        <tr>
         <td colspan="6"><hr></td>
        </tr>
	<tr>
         <td></td>
	 <th>Bierstijl gegevens</th>
         <td></td>
         <td align="left" colspan="3"><div id="styleSelect">Stylenlijst</div></td>
        </tr>
        <tr>
         <td style="vertical-align: top; float: right; padding: 3px;">Stijlgids:</td>
         <td align="left" style="vertical-align: top; padding: 3px;"><input readonly="1" id="st_guide" /></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Bier stijl:</td>
         <td align="left" style="vertical-align: top; padding: 3px;"><input readonly="1" id="st_name" /></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Bier groep:</td>
         <td align="left" style="vertical-align: top; padding: 3px;"><input readonly="1" id="st_letter" /></td>
        </tr>
        <tr>
         <td style="vertical-align: top; float: right; padding: 3px;">Stijl type:</td>
         <td align="left" style="vertical-align: top; padding: 3px;"><input readonly="1"  id="st_type" /></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Categorie:</td>
         <td align="left" style="vertical-align: top; padding: 3px;"><input readonly="1" id="st_category" /></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Categorie nr:</td>
         <td style="padding: 3px;"><div id="st_category_number"></div></td>
        </tr>
	<tr>
         <td style="vertical-align: top; float: right; padding: 3px;">Start SG:</td>
         <td style="padding: 3px;"><div style="float: left;" id="est_og"></div><div style="float: left; margin-left: 15px;" id="st_og_min"></div><div style="float: left; margin-left: 5px;" id="st_og_max"></div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Eind SG:</td>
	 <td style="padding: 3px;"><div style="float: left;" id="est_fg"></div><div style="float: left; margin-left: 15px;" id="st_fg_min"></div><div style="float: left; margin-left: 5px;" id="st_fg_max"></div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Alcohol vol%:</td>
         <td style="padding: 3px;"><div style="float: left;" id="est_abv"></div><div style="float: left; margin-left: 15px;" id="st_abv_min"></div><div style="float: left; margin-left: 5px;" id="st_abv_max"></div></td>
	</tr>
        <tr>
         <td style="vertical-align: top; float: right; padding: 3px;">Kleur:</td>
         <td style="padding: 3px;"><div style="float: left;" id="est_color"></div><div style="float: left; margin-left: 15px;" id="st_color_min"></div><div style="float: left; margin-left: 5px;" id="st_color_max"></div><div id="bcolor" class='ebccolor'> </div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Kleur methode:</td>
	 <td style="padding: 3px;"><div style="float: left;" id="color_method"></div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Koolzuur vol:</td>
         <td style="padding: 3px;"><div style="float: left;" id="est_carb"></div><div style="float: left; margin-left: 15px;" id="st_carb_min"></div><div style="float: left; margin-left: 5px;" id="st_carb_max"></div></td>
	</tr>
        <tr>
         <td style="vertical-align: top; float: right; padding: 3px;">Bitterheid:</td>
         <td style="padding: 3px;"><div style="float: left;" id="est_ibu"></div><div style="float: left; margin-left: 15px;" id="st_ibu_min"></div><div style="float: left; margin-left: 5px;" id="st_ibu_max"></div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Bitterheid methode:</td>
         <td style="padding: 3px;"><div style="float: left;" id="ibu_method"></div></td>
         <td></td>
         <td></td>
        </tr>
       </table>
       <div style="float: right; margin-top: 30px; margin-bottom: 10px;">
	<input style="margin-right: 100px;" type="button" id="Print"  value="Print" />
        <input style="margin-right: 100px;" type="button" id="Export" value="Export" />
        <input style="margin-right: 100px;" type="button" id="Delete" value="Delete" />
        <input style="margin-right: 100px;" type="button" id="Save"   value="Save" />
        <input style="margin-right: 230px;" type="button" id="Cancel" value="Cancel" />
       </div>
      </div>
     </div> <!-- tab algemeen -->

     <div> <!-- tab vergistbaar -->
      <div style="overflow: hidden;">
       <table style="width: 100%;">
        <tr>
         <td style="vertical-align: top; float: right; padding: 3px;">Kleur:</td>
         <td style="padding: 3px;"><div style="float: left;" id="est_color2"></div><div id="bcolor2" class='ebccolor'> </div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Percentage moutstort:</td>
         <td style="padding: 3px;"><div style="float: left;" id="perc_malts"></div></td>
	</tr>
        <tr>
         <td style="vertical-align: top; float: right; padding: 3px;">Begin SG:</td>
         <td style="padding: 3px;"><div style="float: left;" id="est_og2"></div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Percentage suiker:</td>
         <td style="padding: 3px;"><div style="float: left;" id="perc_sugars"></div></td>
        </tr>
	<tr>
         <td colspan="2"></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Percentage cara:</td>
         <td style="padding: 3px;"><div style="float: left;" id="perc_cara"></div></td>
        </tr>
        <tr>
         <td colspan="4"><div id="fermentableGrid"></div></td>
        </tr>
       </table>
      </div>
     </div> <!-- tab vergistbaar -->

     <div> <!-- tab hoppen -->
      <div style="overflow: hidden;">
       <table style="width: 100%;">
        <tr> 
	 <td style="vertical-align: top; float: right; padding: 3px;">Bitterheid IBU:</td>
	 <td style="padding: 3px;"><div id="est_ibu2"></div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Smaak bijdrage:</td>
         <td style="padding: 3px;"><div id="hop_flavour"></div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Aroma bijdrage:</td>
         <td style="padding: 3px;"><div id="hop_aroma"></div></td>
        </tr>
        <tr>
         <td align="right" style="vertical-align: top;">Hoppen:</td>
         <td align="left" colspan="5"><div id="hopGrid"></div></td>
        </tr>
       </table>
      </div>
     </div> <!-- tab hoppen -->

     <div> <!-- tab misc -->
      <div style="overflow: hidden;">
       <table style="width: 100%;">
        <tr>
         <td align="right" style="vertical-align: top;">Diversen:</td>
         <td align="left" colspan="3"><div id="miscGrid">Graat</div></td>
        </tr>
       </table>
      </div>
     </div> <!-- tab misc -->

     <div> <!-- tab gisten -->
      <div style="overflow: hidden;">
       <table style="width: 100%;">
        <tr>
         <td align="right" style="vertical-align: top;">Gisten:</td>
         <td align="left" colspan="3"><div id="yeastGrid">Graat</div></td>
        </tr>
       </table>
      </div>
     </div> <!-- tab gisten -->

     <div> <!-- tab maischen -->
      <div style="overflow: hidden;">
       <table style="width: 100%;">
        <tr>
         <td style="vertical-align: top; float: right; padding: 3px;">Maischchema:</td>
         <td align="left" colspan="5" style="vertical-align: top; padding: 3px;"><input id="mash_name" /></td>
        </tr>
        <tr>
         <td align="right" style="vertical-align: top; padding: 3px;">Stappen:</td>
         <td align="left" colspan="5" style="padding: 3px;"><div id="mashGrid">Graat</div></td>
        </tr>
       </table>
      </div>
     </div> <!-- tab maischen -->

     <div> <!-- tab water -->
      <div style="overflow: hidden;">
       <table style="width: 100%;">
        <tr>
         <td style="vertical-align: top; float: right; padding: 3px;">Bitterheidsindex:</td>
         <td style="padding: 3px;" colspan="2"><div id="tgt_bu"></div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Richtgetal Cl/SO4:</td>
         <td style="padding: 3px;" colspan="2"><div id="tgt_cl_so4"></div></td>
        </tr>
        <tr>
         <td></td>
         <td align="left" colspan="5">
          <div id='water_totals'>
 	   <table style="width: 100%;">
            <caption>Water overzicht</caption>
	    <tr>
             <td align="left" style="vertical-align: top; padding: 3px;">Water profiel</td>
             <td style="width: 97px; padding: 3px;">Volume</td>
             <td style="width: 77px; padding: 3px;">Ca</td>
             <td style="width: 77px; padding: 3px;">Mg</td>
             <td style="width: 77px; padding: 3px;">Na</td>
             <td style="width: 77px; padding: 3px;">CaCO3</td>
             <td style="width: 77px; padding: 3px;">Cl</td>
	     <td style="width: 77px; padding: 3px;">SO4</td>
             <td style="width: 77px; padding: 3px;">pH</td>
	    </tr>
	    <tr>
             <td><div id="w1_name"></div></td>
             <td><div id="w1_amount"></div></td>
             <td><div id="w1_calcium"></div></td>
             <td><div id="w1_magnesium"></div></td>
             <td><div id="w1_sodium"></div></td>
             <td><div id="w1_total_alkalinity"></div></td>
             <td><div id="w1_chloride"></div></td>
             <td><div id="w1_sulfate"></div></td>
             <td><div id="w1_ph"></div></td>
            </tr>
	    <tr>
             <td><div id="w2_name"></div></td>
             <td><div id="w2_amount"></div></td>
             <td><div id="w2_calcium"></div></td>
             <td><div id="w2_magnesium"></div></td>
             <td><div id="w2_sodium"></div></td>
             <td><div id="w2_total_alkalinity"></div></td>
             <td><div id="w2_chloride"></div></td>
             <td><div id="w2_sulfate"></div></td>
             <td><div id="w2_ph"></div></td>
            </tr>
            <tr>
	     <td style="vertical-align: top; padding: 3px; float: left;">Gemengd water:</td>
             <td><div id="wg_amount"></div></td>
             <td><div id="wg_calcium"></div></td>
             <td><div id="wg_magnesium"></div></td>
             <td><div id="wg_sodium"></div></td>
             <td><div id="wg_total_alkalinity"></div></td>
             <td><div id="wg_chloride"></div></td>
	     <td><div id="wg_sulfate"></div></td>
             <td><div id="wg_ph"></div></td>
            </tr>
            <tr>
	     <td style="vertical-align: top; padding: 3px; float: left;">Behandeld water:</td>
             <td><div></div></td>
             <td><div id="wb_calcium"></div></td>
             <td><div id="wb_magnesium"></div></td>
             <td><div id="wb_sodium"></div></td>
             <td><div id="wb_total_alkalinity"></div></td>
             <td><div id="wb_chloride"></div></td>
	     <td><div id="wb_sulfate"></div></td>
             <td><div id="wb_ph"></div></td>
	    </tr>
            <tr>
             <td style="vertical-align: top; padding: 3px; float: left;">Resultaat:</td>
             <td><div></div></td>
             <td><div id="wr_calcium"></div></td>
             <td><div id="wr_magnesium"></div></td>
             <td><div id="wr_sodium"></div></td>
             <td><div id="wr_total_alkalinity"></div></td>
             <td><div id="wr_chloride"></div></td>
             <td><div id="wr_sulfate"></div></td>
             <td><div id="wr_ph"></div></td>
            </tr>
	    <tr>
             <td><div id="pr_name"></div></td>
             <td><div></div></td>
             <td><div id="pr_calcium"></div></td>
             <td><div id="pr_magnesium"></div></td>
             <td><div id="pr_sodium"></div></td>
             <td><div id="pr_total_alkalinity"></div></td>
             <td><div id="pr_chloride"></div></td>
             <td><div id="pr_sulfate"></div></td>
             <td></td>
            </tr>
           </table>
	  </div>
         </td>
	</tr>
        <tr>
         <td style="vertical-align: top; float: right; padding: 3px;">Calciumchloride (CaCl2):</td>
	 <td style="padding: 3px;"><div id="wa_cacl2"></div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Maish pH:</td>
         <td style="padding: 3px;"><div id="mash_ph"></div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Spoelwater volume:</td>
         <td style="padding: 3px;"><div id="sparge_volume"></div></td>
        </tr>
        <tr>
         <td style="vertical-align: top; float: right; padding: 3px;">Gips (CaSO4):</td>
	 <td style="padding: 3px;"><div id="wa_caso4"></div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">pH Automatisch:</td>
	 <td style="padding: 3px;"><div id="calc_acid"></div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Spoelwater temp:</td>
         <td style="padding: 3px;"><div id="sparge_temp"></div></td>
        </tr>
        <tr>
         <td style="vertical-align: top; float: right; padding: 3px;">Epsom zout (MgSO4):</td>
	 <td style="padding: 3px;"><div id="wa_mgso4"></div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Ontzuren met:</td>
         <td style="padding: 3px;"><div style="float: left;" id="wa_base_name"></div><div style="float: left; margin-left: 15px;" id="wa_base"></div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Spoelwater bron:</td>
         <td style="padding: 3px;"><div id="sparge_source"></div></td>
	</tr>
        <tr>
         <td style="vertical-align: top; float: right; padding: 3px;">Keukenzout (NaCl):</td>
	 <td style="padding: 3px;"><div id="wa_nacl"></div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Aanzuren met:</td>
	 <td style="padding: 3px;"><div style="float: left;" id="wa_acid_name"></div><div style="float: left; margin-left: 15px;" id="wa_acid"></div><div style="float: left; margin-left: 15px;" id="wa_acid_perc"></div></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Spoelwater pH:</td>
         <td style="padding: 3px;"><div id="sparge_ph"></div></td>
	</tr>
        <tr>
         <td colspan="4"></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Aanzuren met:</td>
	 <td style="padding: 3px;"><div id="sparge_acid_type"></div></td>
        </tr>
        <tr>
         <td colspan="4"></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Percentage:</td>
         <td style="padding: 3px;"><div id="sparge_acid_perc"></div></td>
        </tr>
        <tr>
         <td colspan="4"></td>
         <td style="vertical-align: top; float: right; padding: 3px;">Hoeveelheid:</td>
         <td style="padding: 3px;"><div id="sparge_acid_amount"></div></td>
        </tr>
       </table>
      </div>
     </div> <!-- tab water -->

   </div> <!-- jqxTabs -->

<?php
confirm_delete();
page_footer();
?>

Mercurial Repository: bms

mercurial