www/prod_edit.php

Sat, 01 Dec 2018 22:24:46 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Sat, 01 Dec 2018 22:24:46 +0100
changeset 119
ae5e8d740173
parent 115
ad31f4bd4036
child 121
875aeb365e1c
permissions
-rw-r--r--

Renamed some fields in prod_main to prevent ambigous names with the join. Delete product also deletes the corresponding recipe. Fixed equipment load and save. Read data from the product main joined with prod_recipes completed. The brewday page is now almost complete, the calculations must be added.

<?php
require_once($_SERVER['DOCUMENT_ROOT'].'/includes/global.inc.php');
page_header('Brouw overzicht', 'prod_edit');
?>

   <div id='jqxTabs'>
    <ul>
     <li style="margin-left: 30px;">Algemeen</li>
     <li>Apparatuur</li>
     <li>Brouwdag</li>
    </ul>

    <div>
     <div style="overflow: hidden;">
      <table style="width: 100%;">
       <tr>
        <td style="vertical-align: top;">
         <table>
          <tr>
           <td style="vertical-align: top; float: right; padding: 3px;">Brouw naam:</td>
           <td align="left" colspan="5" style="vertical-align: top; padding: 3px;"><input id="pname" /></td>
          </tr>
          <tr>
           <td style="vertical-align: top; float: right; padding: 3px;">Brouw code:</td>
           <td align="left" style="vertical-align: top; padding: 3px;"><input id="code" /></td>
           <td style="vertical-align: top; float: right; padding: 3px;">Start planning:</td>
           <td align="left" style="vertical-align: top;"><div id="birth"></div></td>
           <td style="vertical-align: top; float: right; padding: 3px;">Brouw fase:</td>
	   <td align="left" style="vertical-align: top; padding: 3px;"><input id="stage" readonly /></td>
          </tr>
          <tr>
           <td align="right" style="vertical-align: top;">Brouw log:</td>
           <td align="left"><div id="log_brew"></div></td>
           <td align="right" style="vertical-align: top;">Vergisting log:</td>
           <td align="left"><div id="log_fermentation"></div></td>
           <td align="right" style="vertical-align: top;">Ingredienten afgeboekt:</td>
	   <td align="left"><div id="inventory_reduced"></div></td>
          </tr>
          <tr>
           <td align="right" style="vertical-align: top;">Afgesloten:</td>
	   <td align="left" colspan="5" ><div id="plocked"></div></td>
          </tr>
          <tr>
           <td style="vertical-align: top; float: right; padding: 3px;">Opmerkingen:</td>
           <td colspan="5" style="padding: 3px;"><textarea id="pnotes"></textarea></td>
          </tr>
         </table>
        </td>
        <td style="vertical-align: top;">
         <table>
          <tr><td style="padding: 5px;"><input style="margin-right: 10px;" type="button" id="rec_edit" value="Recept" /></td></tr>
          <tr><td style="padding: 5px;"><input style="margin-right: 10px;" type="button" id="brew_log"  value="Brouw log" /></td></tr>
          <tr><td style="padding: 5px;"><input style="margin-right: 10px;" type="button" id="ferment_log"  value="Vergisting log" /></td></tr>
         </table>
        </td>
       </tr>
      </table>
      <div style="float: right; margin-top: 30px; margin-bottom: 10px;">
       <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: 410px;" type="button" id="Cancel" value="Cancel" />
      </div>
     </div>
     <div id="hintBase" class="hint">
     </div>
    </div>

    <div> <!-- Tab 2 -->
     <div style="overflow: hidden;">
      <table style="width: 100%;">
       <tr>
        <td align="right" style="vertical-align: top;">Kies apparatuur:</td>
        <td align="left" colspan="3"><div id="equipmentSelect">Apparatuur</div></td>
       </tr>
       <tr>
        <td style="vertical-align: top; float: right; padding: 3px;">Installatie naam:</td>
	<td align="left" style="vertical-align: top; padding: 3px;"><input id="eq_name" readonly /></td>
        <td align="right" style="vertical-align: top;">Bereken kookvolume:</td>
        <td align="left"><div id="eq_calc_boil_volume"></div></td>
       </tr>
       <tr>
        <td style="vertical-align: top; float: right; padding: 3px;">Opmerkingen:</td>
        <td colspan="5" style="padding: 3px;"><textarea id="eq_notes" readonly></textarea></td>
       </tr>
       <tr>
        <th style="text-align: center;" colspan="2">Maischen</th>
        <th style="text-align: center;" colspan="2">Koken</th>
       </tr>
       <tr>
        <td style="vertical-align: top; float: right;">Maischkuip volume l:</td>
        <td><div id="eq_tun_volume"></div></td>
        <td style="vertical-align: top; float: right;">Kookketel volume l:</td>
        <td><div id="eq_kettle_volume"></div></td>
       </tr>
       <tr>
        <td style="vertical-align: top; float: right;">Maischkuip hoogte cm:</td>
        <td><div id="eq_tun_height"></div></td>
        <td style="vertical-align: top; float: right;">Kookketel hoogte cm:</td>
        <td><div id="eq_kettle_height"></div></td>
       </tr>
       <tr>
        <td style="vertical-align: top; float: right;">Maischkuip gewicht kg:</td>
        <td><div id="eq_tun_weight"></div></td>
        <td style="vertical-align: top; float: right;">Kook volume l:</td>
        <td><div id="eq_boil_size"></div></td>
       </tr>
       <tr>
	<td style="vertical-align: top; float: right;">Maischkuip materiaal:</td>
        <td style="padding: 3px;"><input id="eq_tun_material" readonly /></td>
        <td style="vertical-align: top; float: right;">Verdamping per uur l:</td>
        <td><div id="eq_evap_rate"></div></td>
       </tr>
       <tr>
        <td style="vertical-align: top; float: right;">Maischkuip specific heat:</td>
        <td><div id="eq_tun_specific_heat"></div></td>
        <td style="vertical-align: top; float: right;">Kooktijd in minuten:</td>
        <td><div id="eq_boil_time"></div></td>
       </tr>
       <tr>
        <td style="vertical-align: top; float: right;">Maischwater l:</td>
        <td><div id="eq_mash_volume"></div></td>
        <td style="vertical-align: top; float: right;">Extra water bij koken l:</td>
        <td><div id="eq_top_up_kettle"></div></td>
       </tr>
       <tr>
        <th style="text-align: center;" colspan="2">Filteren</th>
        <td style="vertical-align: top; float: right;">Hopfactor %:</td>
        <td><div id="eq_hop_utilization"></div></td>
       </tr>
       <tr>
        <td style="vertical-align: top; float: right;">Filter volume l:</td>
        <td><div id="eq_lauter_volume"></div></td>
        <td style="vertical-align: top; float: right;">Volume eind koken l:</td>
        <td><div id="eq_batch_size"></div></td>
       </tr>
       <tr>
        <td style="vertical-align: top; float: right;">Filterkuip hoogte cm:</td>
        <td><div id="eq_lauter_height"></div></td>
        <th style="text-align: center;" colspan="2">Koelen</th>
       </tr>
       <tr>
        <td style="vertical-align: top; float: right;">Filterkuip verlies l:</td>
        <td><div id="eq_lauter_deadspace"></div></td>
        <td style="vertical-align: top; float: right;">Trub verlies kookketel l:</td>
        <td><div id="eq_trub_chiller_loss"></div></td>
       </tr>
       <tr>
        <td style="vertical-align: top; float: right;">Brouwzaalrendement %:</td>
        <td><div id="eq_efficiency"></div></td>
        <td style="vertical-align: top; float: right;">Extra water in gistvatl:</td>
        <td><div id="eq_top_up_water"></div></td>
       </tr>
      </table>
     </div>
    </div>

    <div> <!-- Brewday -->
     <table style="width: 100%;">
      <tr>
       <td style="vertical-align: top; float: right; padding: 3px;">Brouwdag start:</td>
       <td align="left" colspan="2" style="vertical-align: top;"><div id="brew_date_start"></div></td>
       <td style="vertical-align: top; float: right; padding: 3px;">Brouwdag eind:</td>
       <td align="left" colspan="2" style="vertical-align: top;"><div id="brew_date_end"></div></td>
      </tr>
      <tr>
       <td colspan="6"> </td>
      </tr>
      <tr>
       <th style="text-align: center;" colspan="2">Maischen</th>
       <th style="text-align: center;" colspan="4">Koken</th>
      </tr>
      <tr>
       <td style="vertical-align: top; float: right;">Maisch pH:</td>
       <td><div id="brew_mash_ph"></div></td>
       <td style="vertical-align: top; float: right;">pH voor koken:</td>
       <td><div id="brew_preboil_ph"></div></td>
       <td style="vertical-align: top; float: right;">pH na koken:</td>
       <td><div id="brew_aboil_ph"></div></td>
      </tr>
      <tr>
       <td style="vertical-align: top; float: right;">Maisch SG:</td>
       <td><div id="brew_mash_sg"></div></td>
       <td style="vertical-align: top; float: right;">SG voor koken:</td>
       <td><div id="brew_preboil_sg"></div></td>
       <td style="vertical-align: top; float: right;">SG na koken:</td>
       <td><div id="brew_aboil_sg"></div></td>
      </tr>
      <tr>
       <td style="vertical-align: top; float: right;">Maisch rendement:</td>
       <td><div id="brew_mash_efficiency"></div></td>
       <td style="vertical-align: top; float: right;">Volume voor koken:</td>
       <td><div id="brew_preboil_volume"></div></td>
       <td style="vertical-align: top; float: right;">Volume na koken:</td>
       <td><div id="brew_aboil_volume"></div></td>
      </tr>
      <tr>
       <td colspan="2"> </td>
       <td style="vertical-align: top; float: right;">Rendement voor koken:</td>
       <td><div id="brew_preboil_efficiency"></div></td>
       <td style="vertical-align: top; float: right;">Rendement na koken:</td>
       <td><div id="brew_aboil_efficiency"></div></td>
      </tr>
      <tr>
       <th style="text-align: center;" colspan="2">Spoelen en filteren</th>
       <td colspan="4"> </td>
      </tr>
      <tr>
       <td style="vertical-align: top; float: right;">Spoelwater temperatuur:</td>
       <td><div id="brew_sparge_temperature"></div></td>
       <th style="text-align: center;" colspan="4">Koelen en whirlpoolen</th>
      </tr>
      <tr>
       <td style="vertical-align: top; float: right;">Spoelwater volume:</td>
       <td><div id="brew_sparge_volume"></div></td>
       <td style="vertical-align: top; float: right;">Whirlpool 85..100&deg;C:</td>
       <td><div id="brew_whirlpool9"></div></td>
       <td style="vertical-align: top; float: right;">Koelen tot:</td>
       <td><div id="brew_cooling_to"></div></td>
      </tr>
      <tr>
       <td style="vertical-align: top; float: right;">Spoelwater pH:</td>
       <td><div id="brew_sparge_ph"></div></td>
       <td style="vertical-align: top; float: right;">Whirlpool 72..79&deg;C:</td>
       <td><div id="brew_whirlpool7"></div></td>
       <td style="vertical-align: top; float: right;">Koelen met:</td>
       <td><div id="brew_cooling_method"></div></td>
      </tr>
      <tr>
       <td colspan="2"></td>
       <td style="vertical-align: top; float: right;">Whirlpool 60..66&deg;C:</td>
       <td><div id="brew_whirlpool6"></div></td>
       <td style="vertical-align: top; float: right;">Koelen tijd:</td>
       <td><div id="brew_cooling_time"></div></td>
      </tr>
      <tr>
       <th style="text-align: center;" colspan="2">Beluchten</th>
       <td style="vertical-align: top; float: right;">Whirlpool koud:</td>
       <td><div id="brew_whirlpool2"></div></td>
       <td colspan="2"> </td>
      </tr>
      <tr>
       <td style="vertical-align: top; float: right;">Beluchten met:</td>
       <td><div id="brew_aeration_type"></div></td>
       <td colspan="4"> </td>
      </tr>
      <tr>
       <td style="vertical-align: top; float: right;">Beluchten tijd:</td>
       <td><div id="brew_aeration_time"></div></td>
       <th style="text-align: center;" colspan="4">Naar gistvat</th>
      </tr>
      <tr>
       <td style="vertical-align: top; float: right;">Beluchten snelheid:</td>
       <td><div id="brew_aeration_speed"></div></td>
       <td style="vertical-align: top; float: right;">Volume naar gistvat:</td>
       <td><div id="brew_fermenter_volume"></div></td>
       <td style="vertical-align: top; float: right;">Extra water:</td>
       <td><div id="brew_fermenter_extrawater"></div></td>
      </tr>
      <tr>
       <td colspan="2"> </td>
       <td style="vertical-align: top; float: right;">SG in gistvat:</td>
       <td><div id="brew_fermenter_sg"></div></td>
       <td style="vertical-align: top; float: right;">Extra suiker:</td>
       <td><div id="brew_fermenter_extrasugar"></div></td>
      </tr>
      <tr>
       <td colspan="2"> </td>
       <td style="vertical-align: top; float: right;">IBU in gistvat:</td>
       <td><div id="brew_fermenter_ibu"></div></td>
       <td style="vertical-align: top; float: right;">Kleur in gistvat:</td>
       <td><div id="brew_fermenter_color"></div></td>
      </tr>
     </table>
    </div>

   </div> <!-- Tabs -->

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

mercurial