admin_viewplant.php

<?php
include 'tpl/auth.php';
include 'tpl/sql.php';
include 'phpqrcode.php';

if (isset($_GET['p'])) {
        $plant = $_GET['p'];
        }
else if (isset($_POST['p'])){
        $plant = $_POST['p'];
        }
else if (isset($_POST['plant_uniqueid'])){
	// We've come from the plant scanner
	$plant = $_POST['plant_uniqueid'];
	}
else if (isset($_POST['plantid'])){
	// Using this in the admin_moveplant
	$plant = $_POST['plantid'];
	}
else {
	//No plant set, show an empty screen. Check isset($plant) later
	echo "Much failure - No plant set! Contact your administrator and tell them how you managed to do this so it can be fixed plzkthx";
	exit();
        }

// We set the date at the start here coz there's a fair to high chance we'll need it for our SQL
$date = date('Y-m-d');

// Check to see if we've got notes to save
$newnotes = filter_var($_POST['newnotes'], FILTER_SANITIZE_STRING);
if (strlen($newnotes > 3)) {
	// We've got something submitted, so check the length of newnotes
	$sql="INSERT INTO plant_notes (plant_uniqueid, note_date, notes) VALUES ('$plant', '$date', '$newnotes')";
	if ($result = mysqli_query($con, $sql)) {
		// echo "Returned rows are: " . mysqli_num_rows($result);
		// Free result set
		//mysqli_free_result($result);
		$savesuccess = 'true';
		}
	else {
		$savesuccess = 'failed';
		}
	}

// Check to see if we've set a new location and need to save it
if (isset($_POST['new_location'])) {
	$new_location = $_POST['new_location'];
	// First we update the inventory location
	$sql="UPDATE inventory SET where_is_it_now='$new_location',date_of_lastmove='$date' WHERE plant_uniqueid='$plant'";
        if ($result = mysqli_query($con, $sql)) {
		$savesuccess = 'true';
                }

	// Second we add a note to the history of the plant
	$sql="INSERT INTO plant_notes (plant_uniqueid, note_date, notes) VALUES ('$plant', '$date', 'Plant moved to $new_location')";
        if ($result = mysqli_query($con, $sql)) {
		$savesuccess = 'true';
                }
	}

// Now we look up the *latest* data (just in case we've updated it)
$sql = "SELECT * from inventory where plant_uniqueid = '$plant'";
$result = mysqli_query($con,$sql);
$plantresults = mysqli_fetch_all($result, MYSQLI_ASSOC);

// Update the cultivar
$cultivar = $plantresults[0]["cultivar"];

// Calculate days-old and the language to describe it
$date_of_spawn = $plantresults[0]['date_of_spawn'];
$datetime1 = date_create($plantresults[0]['date_of_spawn']);
if (strlen($plantresults[0]['date_of_harvest'] > 1)) {
	// If the plant was harvested ages ago we don't wanna use todays date
	$date_of_harvest = $plantresults[0]['date_of_harvest'];
	$datetime2 = date_create($plantresults[0]['date_of_harvest']);
	$age_language = " at harvest";
	}
else if (strlen($plantresults[0]['date_of_disposal'] > 1)) {
	// If it was disposed of we wanna know that too
	$date_of_disposal = $plantresults[0]['date_of_disposal'];
	$datetime2 = date_create($plantresults[0]['date_of_disposal']);
	$age_language = " at disposal";
	}
else {
	// But if it wasn't harvested then show todays date
	$datetime2 = date_create("now",timezone_open("Pacific/Auckland"));
	$age_language = " old";
	}
$daysold = date_diff($datetime1, $datetime2);

// Also see if we've got a date of when it was last moved
if (isset($plantresults[0]['date_of_lastmove'])) {
	$date_of_lastmove = $plantresults[0]['date_of_lastmove'];
	}
else {
	$date_of_lastmove = "Never moved";
	}

// Check if the QR code exists given we don't have all the seasons with them yet
// I'm not sure why I'm doing this in an if statement but will come back and look later
if (isset($plant)) {
$fileName = $plant . ".png";
                $pngAbsoluteFilePath = 'qrcodes/' . $fileName;
                if (!file_exists($pngAbsoluteFilePath)) {
                        QRcode::png($plant, $pngAbsoluteFilePath);
                //echo 'File generated!';
                } else {
                //echo 'File already generated! We can use this cached file to speed up site on common codes!';
                }
	}

// Is the plant alive or dead? If it's dead, show a warning coz... well they shouldn't be changing stuff
if ($plantresults[0]['is_alive'] == '1') {
	$isalive = "Yes";
	}
else {
	$isalive = "No";
	}

// Hopefully by now we are done and are ready to show what's on the web page!
?>
<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <title>growTENT :: View plant details</title>

    <!-- Sets initial viewport load and disables zooming  -->
    <meta name="viewport" content="initial-scale=1, maximum-scale=1">

    <!-- Makes your prototype chrome-less once bookmarked to your phone's home screen -->
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">

    <!-- Include the compiled Ratchet CSS -->
    <link rel="stylesheet" href="ratchet-theme-ios.min.css">
    <link rel="stylesheet" href="ratchet.min.css">
    <link rel="stylesheet" href="app.css">

    <!-- Include the compiled Ratchet JS -->
    <!-- <script src="ratchet.js"></script> -->
  </head>
  <body>

    <!-- Make sure all your bars are the first things in your <body> -->
    <header class="bar bar-nav">
     <a href="admin.php"><button class="btn btn-link btn-nav pull-left">
       <span class="icon icon-home"></span>
       Home
     </button></a>

      <h1 class="title">View plant</h1>
    </header>

    <!-- Wrap all non-bar HTML in the .content div (this is actually what scrolls) -->
    <div class="content">
      <p class="content-padded">View plant details and update individual values</p>
      <?php if($savesuccess=='true'){ echo "<p class='content-padded' align='center'><font color='green'>Plant saved successfully</font></p>";} ?>
      <?php if($isalive=='No'){ echo "<p class='content-padded' align='center'><font color='red'><strong>This plant is not alive. Changes disabled.</strong></font></p>";} ?>
      <?php //if (isset ($plant)) { QRcode::png('some'); } ?>
      <div class="card">
	<form action='admin_viewplant.php' method='post' class='input-group'>
	 <div class="input-row">
	  <label>Cultivar: </label>
	  <input type="text" placeholder="Cultivar" name="cultivar" readonly value="<?php if (isset($plant)) { echo $cultivar; } ?>">
	 </div>
         <div class="input-row">
          <label>Spawn date: </label>
          <input type="text" placeholder="Date of spawn" name="date_of_spawn" readonly value="<?php echo $plantresults[0]['date_of_spawn'] . " (" . $daysold->format('%a days') . $age_language . ")";   ?>">
	 </div>
         <div class="input-row">
          <label>Last moved: </label>
          <input type="text" placeholder="Never moved" name="date_of_lastmove" readonly value="<?php echo $date_of_lastmove ?>">
         </div>
         <div class="input-row">
          <label>Location: </label>
          <input type="text" placeholder="Current location" name="where_is_it_now" readonly value="<?php echo $plantresults[0]['where_is_it_now'];?>">
	 </div>

         <div class="input-row">
          <label>Season: </label>
          <input type="text" placeholder="Season" name="season" value="<?php echo $plantresults[0]['season_id'];?>">
         </div>
         <div class="input-row">
          <label>Plant #: </label>
          <input type="text" placeholder="Plant number" name="plant_num" value="<?php echo $plantresults[0]['plant_num'];?>">
         </div>
         <div class="input-row">
          <label>Facility: </label>
          <input type="text" placeholder="Facility of cultivation" name="facilityname" readonly value="<?php echo $plantresults[0]['facilityname'];?>">
         </div>
         <div class="input-row">
          <label>Plant UID: </label>
          <input type="text" placeholder="Plant Unique ID" name="plant_uniqueid" readonly value="<?php echo $plantresults[0]['plant_uniqueid'];?>">
         </div>
         <div class="input-row">
          <label>Plant alive? </label>
          <input type="text" placeholder="Is the plant still alive" name="is_alive" readonly <?php if (isset($plant)) { echo "value='"; if ($plantresults[0]['is_alive'] == '1') {echo "Yes";} else {echo "No";} echo "'"; } ?> >
         </div>
         <div class="input-row">
          <label>Current state: </label>
          <input type="text" placeholder="Current state of plant" name="current_state" value="<?php echo $plantresults[0]['current_state'];?>">
         </div>
<?php
// We wanna add some details of the harvest IF it's available
if (isset($plantresults[0]['harvest_ww'])) {
	$ww = $plantresults[0]['harvest_ww'];
	echo "         <div class='input-row'>
          <label>Wet weight (g): </label>
          <input type='text' placeholder='0g' name='wet_weight' value='$ww'>
         </div>";
	}
if (isset($plantresults[0]['harvest_dw'])) {
        $dw = $plantresults[0]['harvest_dw'];
	if ($dw > 1) {
	// This means the dry-weight is set and ready to be shown
	        echo "         <div class='input-row'>
	          <label>Dry weight (g): </label>
	          <input type='text' placeholder='0g' name='dry_weight' value='$dw'>
	         </div>";
		}
	else {
	// This means the dry-weight is pending still so show a button to set it
                echo "         <div class='input-row'>
                  <label>Dry weight (g): </label>
                  <a href='admin_harvest_dw.php'><button class='btn btn-primary' style='margin-top: 3px;'>Submit dry weight</button></a></li>
                </div>";

		}
        }

?>
	  <input type="hidden" name="plant_uniqueid" value="<?php echo $plant; ?>">
          <div class='content-padded'><label>Add more notes: </label>
	  <textarea name="newnotes" id="newnotes" maxlength="2048" rows="3"></textarea></div>
	  <button class="btn btn-positive btn-block" type="submit" name="savenotes" value="savenotes">Save notes</button>
	</form>
<?php
if($isalive=='Yes'){
	// Plant is alive so give the option to move, take cuttings, dispose of, or harvest it
	echo "<table width='100%'><tbody width='100%'><tr width='100%'>
	<td width='50%' style='padding: 10px;'>
		<button class='btn btn-positive btn-block' type='submit' name='adjustseason' value='adjustseason'>Adjust season / Plant</button></td>
	<td width='50%' style='padding: 10px;'>
		<form action='admin_takecuttings_print.php' method='post' class='input-group'>
			<input type='hidden' name='plantid' value='$plant'>
			<button class='btn btn-primary btn-block' type='submit' name='reprint' value='reprint'>Reprint label</button>
		</form>
	</td>
 	</tr></tbody></table>
	
	<table width='100%'><tbody width='100%'><tr width='100%'>
	<td width='50%' style='padding: 10px;'><form action='admin_moveplant.php' method='post' class='input-group'>
          <input type='hidden' name='plantid' value='$plant'>
          <button class='btn btn-positive btn-block' type='submit' name='moveplant' value='moveplant'>Move plant</button>
        </form>
	<td width='50%' style='padding: 10px;'><form action='admin_takecuttings.php' method='post' class='input-group'>
          <input type='hidden' name='mother_plantid' value='$plant'>
          <input type='hidden' name='cultivar' value='$cultivar'>
          <button class='btn btn-positive btn-block' type='submit' name='takecuttings' value='takecuttings'>Take cuttings</button>
        </form>
	</tr></tbody></table>

	<table width='100%'><tbody width='100%'><tr width='100%'>
	<td width='50%' style='padding: 10px;'><form action='admin_dispose.php' method='post' class='input-group'>
                <input type='hidden' name='plantid' value='$plant'>
		<button class='btn btn-negative btn-block'>Dispose of plant</button></form>
	</td>
	<td width='50%' style='padding: 10px;'><form action='admin_harvest.php' method='post' class='input-group'>
		<input type='hidden' name='plantid' value='$plant'>
		<button class='btn btn-negative btn-block' type='submit' name='harvestplant' value='harvestplant'>Harvest plant</button></form>
	</td>
	</tr></tbody></table>";
	}
?>

	<?php
	// Why did I put this in an if statement? There must have been a reason - Come back to it later
	if (isset($plant)) {
	$sql="SELECT * from plant_notes where plant_uniqueid='$plant' order by id desc";
	$result = mysqli_query($con,$sql);
	$row = mysqli_fetch_all($result, MYSQLI_ASSOC);
	foreach($row as $currentrow) {
		echo "<div class='content-padded'><p><strong>" . $currentrow['note_date'] . ":</strong> " . nl2br($currentrow['notes']) . "</p></div>\n";
		}
	}
?>
      </div>
    </div>
  </body>
</html>