utils.php

<?php
require_once('quoteitem.php');
require_once('quote.php');
/**
 * generateDropDownSQL($db, $table, $prefix)
 */
function generateDropDownSQL($db, $table, $prefix) {
  $table_name = str_replace($prefix,"",$table);
  switch ($table) {
    case $prefix.'animal':
      $unsecure_sql = "SELECT DISTINCT x.id, x.description, x.preselect";
      $unsecure_sql .= " FROM ".$prefix."transmitter as tx INNER JOIN ".$prefix."receiver as rec ON tx.receiver_id = rec.id";
      $unsecure_sql .= " INNER JOIN $table as x ON tx.".$table_name."_id=x.id WHERE tx.part_number!='' AND tx.enable=1";
      if ($_POST['system']!='none') {$unsecure_sql .= " AND rec.system_id=:system"; }
      $unsecure_sql .= " AND x.enable=1 ORDER BY x.description ASC";

      $prepared_sql = $db->prepare($unsecure_sql);
      if ($_POST['system']!='none') { $prepared_sql->bindParam(':system', $_POST['system']); }
      break;
    case $prefix.'biopotential':
      $unsecure_sql = "SELECT DISTINCT x.id, x.description, x.preselect";
      $unsecure_sql .= " FROM ".$prefix."transmitter as tx INNER JOIN ".$prefix."receiver as rec ON tx.receiver_id = rec.id";
      $unsecure_sql .= " INNER JOIN $table as x ON tx.".$table_name."_id=x.id WHERE tx.part_number!='' AND tx.enable=1";
      if ($_POST['system']!='none') {$unsecure_sql .= " AND rec.system_id=:system"; }
      $unsecure_sql .= " AND tx.animal_id=:animal";
      $unsecure_sql .= " AND x.enable=1 ORDER BY x.description ASC";

      $prepared_sql = $db->prepare($unsecure_sql);
      if ($_POST['system']!='none') { $prepared_sql->bindParam(':system', $_POST['system']); }
      $prepared_sql->bindParam(':animal', $_POST['animal']);
      break;
    case $prefix.'channels':
      $unsecure_sql = "SELECT DISTINCT x.id, x.description, x.preselect";
      $unsecure_sql .= " FROM ".$prefix."transmitter as tx INNER JOIN ".$prefix."receiver as rec ON tx.receiver_id = rec.id";
      $unsecure_sql .= " INNER JOIN $table as x ON tx.".$table_name."_id=x.id WHERE tx.part_number!='' AND tx.enable=1";
      if ($_POST['system']!='none') {$unsecure_sql .= " AND rec.system_id=:system"; }
      $unsecure_sql .= " AND tx.animal_id=:animal";
      $unsecure_sql .= " AND tx.biopotential_id=:biopotential";
      $unsecure_sql .= " AND x.enable=1 ORDER BY x.description ASC";
      
      $prepared_sql = $db->prepare($unsecure_sql);
      if ($_POST['system']!='none') { $prepared_sql->bindParam(':system', $_POST['system']); }
      $prepared_sql->bindParam(':animal', $_POST['animal']);
      $prepared_sql->bindParam(':biopotential', $_POST['biopotential']);
      break;
    case $prefix.'duration':
      $unsecure_sql = "SELECT DISTINCT x.id, x.description, x.preselect";
      $unsecure_sql .= " FROM ".$prefix."transmitter as tx INNER JOIN ".$prefix."receiver as rec ON tx.receiver_id = rec.id";
      $unsecure_sql .= " INNER JOIN $table as x ON tx.".$table_name."_id=x.id WHERE tx.part_number!='' AND tx.enable=1";
      if ($_POST['system']!='none') {$unsecure_sql .= " AND rec.system_id=:system"; }
      $unsecure_sql .= " AND tx.animal_id=:animal";
      $unsecure_sql .= " AND tx.biopotential_id=:biopotential";
      $unsecure_sql .= " AND tx.channels_id=:channels";
      $unsecure_sql .= " AND x.enable=1 ORDER BY x.description ASC";
      
      $prepared_sql = $db->prepare($unsecure_sql);
      if ($_POST['system']!='none') { $prepared_sql->bindParam(':system', $_POST['system']); }
      $prepared_sql->bindParam(':animal', $_POST['animal']);
      $prepared_sql->bindParam(':biopotential', $_POST['biopotential']);
      $prepared_sql->bindParam(':channels', $_POST['channels']);
      break;
    case $prefix.'dac':
      $unsecure_sql="SELECT id, description, preselect FROM $table WHERE enable=1 ORDER BY description DESC";

      $prepared_sql = $db->prepare($unsecure_sql);
      break;
    case $prefix.'system':
    default:
      $unsecure_sql="SELECT id, description, preselect FROM $table ORDER BY description ASC";

      $prepared_sql = $db->prepare($unsecure_sql);
      break;
  }

  return $prepared_sql;
}

/**
 * createDropDown($db, $label, $select, $table, $prefix, $active, $tooltip, $none)
 */
function createDropDown($db, $label, $select, $table, $prefix, $active, $tooltip, $none) {
  // Open Select Tag
  echo "<div><label>$label:</label> <select name=\"$select\" id=\"$select\"";
  if (!$active) { echo " disabled"; }
  echo ">", PHP_EOL;

  // Generate Select Tag Options
  $prepared_sql = generateDropDownSQL($db, $table, $prefix);

  $prepared_sql->execute();

  echo "<option value=''>$label</option>";
  // "I need one!" option
  if ($none) {
    echo "<option value='none'";
    if (isset($_POST[$select])) {
      echo ($_POST[$select] == 'none') ? ' selected' : '';
    }
    echo ">I need one!</option>";
  }
  // List options from the database
  while ($row = $prepared_sql->fetch(PDO::FETCH_ASSOC)) {
     echo '<option value="'.$row['id'].'"';
     if (isset($_POST[$select]) && $row['id'] == $_POST[$select]) {
       echo ' selected';
     } elseif ($prepared_sql->rowCount() == 1) {
       // If there is only one option in the dropdown, select it
       echo ' selected';
       $_POST[$select] = $row['id'];
     }
     echo '>'.$row['description'].'</option>', PHP_EOL;
  }

  // Close Select Tag
  echo '</select>', PHP_EOL;

  // Create JS OnChange Event
  echo "<script>", PHP_EOL;
  echo "document.getElementById(\"$select\").onchange = function() {", PHP_EOL;
  echo "  if (document.getElementById(\"$select\").value !== \"\") {", PHP_EOL;
  echo "    document.getElementById(\"currentDropDown\").value = \"$select\";", PHP_EOL;
  echo "    document.getElementById(\"createSystem\").submit();", PHP_EOL;
  echo "  }", PHP_EOL;
  echo "}", PHP_EOL;
  echo "</script>", PHP_EOL;

  // Tooltip
  if (!is_null($tooltip)) { echo "<div class='tooltip'>[?] <span class='tooltiptext'>$tooltip</span></div>"; }

  // close form control group
  echo '</div>', PHP_EOL;

  return $prepared_sql->rowCount();
}

/**
 * showDropDowns($db, $prefix, $dropdowns)
 */
function showDropDowns($db, $prefix, $dropdowns) {
  advanceCurrentDropDown($dropdowns);
  // Create dropdowns
  $active = true;
  for ($row = 0; $row < sizeof($dropdowns); $row++) {
    // Allow "None" dropdown option for dac and system
    if ($dropdowns[$row][2] == "dac" || $dropdowns[$row][2] == "system") { $none = true; } else { $none = false; }

    if (!$active) { unset($_POST[$dropdowns[$row][2]]); }
    $count = createDropDown($db, $dropdowns[$row][1], $dropdowns[$row][2], $dropdowns[$row][3], $prefix, $active, $dropdowns[$row][4], $none);
    if ($count == 1 ) { advanceCurrentDropDown($dropdowns); }
    if ($dropdowns[$row][2] == "channels") { createGainDropdowns($db, $prefix, $active); } // Once channels have been selected, show the Gain Options
    if ($dropdowns[$row][2] == $_POST['currentDropDown']) {
      $active = false; // Disable all the select statements after the currentDropDown
      //break; // Hide inactive dropdowns
    }
  }
}

/**
 * showDropDowns($db, $prefix, $dropdowns)
 */
function showReOrderDropDowns($db, $prefix, $dropdowns) {
  advanceCurrentDropDown($dropdowns, 'system');
  // Create dropdowns
  $active = true;
  for ($row = 0; $row < sizeof($dropdowns); $row++) {
    // Do not allow "None" dropdown option
    $none = false;

    if (!$active) { unset($_POST[$dropdowns[$row][2]]); }
    $count = createDropDown($db, $dropdowns[$row][1], $dropdowns[$row][2], $dropdowns[$row][3], $prefix, $active, $dropdowns[$row][4], $none);
    if ($count == 1 ) { advanceCurrentDropDown($dropdowns, 'system'); }
    if ($dropdowns[$row][2] == "channels") { createGainDropdowns($db, $prefix, $active); } // Once channels have been selected, show the Gain Options
    if ($dropdowns[$row][2] == $_POST['currentDropDown']) {
      $active = false; // Disable all the select statements after the currentDropDown
      //break; // Hide inactive dropdowns
    }
  }
}

/**
 * showQuotes($db, $prefix, $TxOnly)
 */
function showQuotes($db, $prefix, $TxOnly=false) {
  global $locale;

  if (isset($_POST['currentDropDown']) && $_POST['currentDropDown'] == 'duration' && isset($_POST['duration'])) {
    $quotes = getQuotes($db, $prefix, $TxOnly);
    $count = 1;
    foreach ($quotes as $quote) {
      echo '<br /><br />';
      echo "<h3>".$locale['RESULT_HEADER'].$count."</h3>";
      echo $quote->getHTML();
      $count++;
    }
  }
}


/**
 * getDefaultGain($biopotential, $animal)
 */
function getDefaultGain($biopotential, $animal) {
  // Adult EEG 2mV±
  // Pup EEG 1mV±
  // EMG 5mV±
  // ECG 2mV±
  $default_gain = 0;

  if (strpos($animal, 'pup') == false) {
    // adult
    switch ($biopotential) {
      case 'emg':
        $default_gain = 5;
        break;
      case 'ecg':
      case 'eeg':
      default:
        $default_gain = 2;
        break;
    }
  } else {
    // pup
    $default_gain = 1;
  }

  return $default_gain;
}

/**
 * createGainDropdowns($db, $prefix, $active)
 */
function createGainDropdowns($db, $prefix, $active) {
  global $locale;

  // Set Default Differential Gains
  $biopotentials = explode("-", $_POST['biopotential']);
  for ($i = 1; $i <= sizeof($biopotentials); $i++) {
    if (!isset($_POST["transmitter_gain_$i"])) {
      $_POST["transmitter_gain_$i"] = getDefaultGain($biopotentials[$i-1], $_POST['animal']);
    }
  }

  // Create a Sensor Gain Dropdown for each channel
  if (isset($_POST['channels'])) {
    for ($i = 1; $i <= $_POST['channels']; $i++) {
      // Set Default Common Gains
      if (strlen($_POST['biopotential'])==3) {
        if (!isset($_POST["transmitter_gain_$i"])) {
          $_POST["transmitter_gain_$i"] = getDefaultGain($_POST['biopotential'], $_POST['animal']);
        }
      }

      createDropDown($db, "Channel $i Gain", "transmitter_gain_$i", $prefix.'transmitter_gain', $prefix, $active, $locale['GAIN_TOOLTIP'], false);
    }
  }

}

/**
 * getGainCombinationKey($db, $prefix)
 */
function getGainCombinationKey($db, $prefix) {
  $gain_desc = "";
  for ($i = 1; $i <= 6; $i++) {
    if (isset($_POST["transmitter_gain_$i"])) {
      $gain_desc .= "-".sprintf("%02d", $_POST["transmitter_gain_$i"]);
    } else {
      $gain_desc .= "-00";
    }
  }
  $unsecure_sql = "SELECT id from ".$prefix."gains WHERE description=:gain_desc";

  $prepared_sql = $db->prepare($unsecure_sql);
  $prepared_sql->bindParam(':gain_desc', $gain_desc);
  $prepared_sql->execute();

  if ($prepared_sql->rowCount()>0) {
    while ($row = $prepared_sql->fetch(PDO::FETCH_ASSOC)) {
      return $row['id'];
    }
  }
  return "ERROR";
}

/**
 * getGainCombinationValue($db, $prefix, $id)
 */
function getGainCombinationValue($db, $prefix, $id) {
  global $locale;

  $unsecure_sql = "SELECT description from ".$prefix."gains WHERE id=:id";

  $prepared_sql = $db->prepare($unsecure_sql);
  $prepared_sql->bindParam(':id', $id);
  $prepared_sql->execute();

  if ($prepared_sql->rowCount()>0) {
    while ($row = $prepared_sql->fetch(PDO::FETCH_ASSOC)) {
      return $row['description'];
    }
  }
  return "ERROR";
}

/**
 * getDAQ($db)
 */
function getDAQ($db) {
  global $locale;

  // BIOPAC DAQ
  $daq = new QuoteItem(null, null, null, null, null, null);

  switch ($_POST['dac']) {
    case 'none':
      $daq = new QuoteItem($locale['DAQ'], 1, 'MP160', 'https://www.biopac.com/product/mp150-data-acquisition-systems/', null, null);
      break;
  }

  return $daq;
}

/**
 * getActivator()
 */
function getActivator() {
  global $locale;

  // Activator
  $activator = new QuoteItem(null, null, null, null, null, null);
  if ($_POST['system']!="classic" ) {
    $activator = new QuoteItem($locale['EPOCH_SENSOR_ACTIVATOR'], 1, 'EPOCH-ACTI', $locale['EPOCH_SENSOR_ACTIVATOR_URL'], '10029', $locale['ONE_PER_LAB']);
  } elseif ($_POST['system']=="classic" && $_POST['duration']=="reusable" ) {
    $activator = new QuoteItem($locale['EPOCH_SENSOR_ACTIVATOR'], 1, 'EPOCH-ACTI', $locale['EPOCH_SENSOR_ACTIVATOR_URL'], '10029', $locale['ONE_PER_LAB'].'  '.$locale['EPOCH_SENSOR_ACTIVATOR_WARNING']);
  }
  return $activator;
}

/**
 * getCables()
 */
function getCables() {
  global $locale;

  // BIOPAC cables
  $cables = array();

  switch ($_POST['dac']) {
    case 'none':
    case 'mp160':
      $cables[] = new QuoteItem($locale['BIOPAC_CABLE'], $_POST['channels'], 'CBL123', 'https://www.biopac.com/product/interface-cables/?attribute_pa_size=unisolated-rj11-to-bnc-male', null, $locale['ONE_PER_CHANNEL']);
      break;
    case 'mp36':
    case 'mp36r':
      $cables[] = new QuoteItem($locale['BIOPAC_CABLE'], $_POST['channels'], 'CBL125', 'https://www.biopac.com/product/interface-cables/?attribute_pa_size=cbl-bnc-male-to-bnc-male-2-m', null, $locale['ONE_PER_CHANNEL']);
      $cables[] = new QuoteItem($locale['BIOPAC_CABLE'], $_POST['channels'], 'SS9LA', 'https://www.biopac.com/product/input-adapters-bnc/?attribute_pa_size=input-adapter-unisolated-bnc-mp36-mp35-mp45', null, $locale['ONE_PER_CHANNEL']);
      break;
    case 'mp100':
    case 'mp150':
      $cables[] = new QuoteItem($locale['BIOPAC_CABLE'], $_POST['channels'], 'CBL102', 'https://www.biopac.com/product/interface-cables/?attribute_pa_size=cbl-3-5mm-to-bnc-m-2-m', null, $locale['ONE_PER_CHANNEL']);
      break;
  }

  return $cables;
}

/**
 * getDescription($db, $id, $table, $prefix)
 */
function getDescription($db, $id, $table, $prefix) {
  $description = null;
  $unsecure_sql = "SELECT description from $prefix.$table where id='$id'";
  //TODO
  $prepared_sql = $db->prepare($unsecure_sql);
  $prepared_sql->execute();

  if ($prepared_sql->rowCount()>0) {
    while ($row = $prepared_sql->fetch(PDO::FETCH_ASSOC)) {
      $description = $row['description'];
      break;
    }
  }
  return $description;
}

/**
 * getQuotes($db, $prefix, $TxOnly)
 */
function getQuotes($db, $prefix, $TxOnly) {
  global $locale;

  $quote = [];

  $unsecure_sql = "SELECT tx.part_number as transmitter_pn, tx.biopac_id as biopac_transmitter_pn, tx.biopac_url as biopac_transmitter_url, rec.biopac_id as biopac_receiver_pn, rec.biopac_url as biopac_receiver_url, rec.notes as receiver_notes, tx.notes as transmitter_notes, tx.receiver_id as receiver_pn, tx.biopotential_id as biopotential, tx.channels_id as channels";
  $unsecure_sql .= " FROM ".$prefix."transmitter as tx INNER JOIN ".$prefix."receiver as rec ON tx.receiver_id = rec.id";
  $unsecure_sql .= " WHERE tx.animal_id=:animal";
  $unsecure_sql .= " AND tx.biopotential_id=:biopotential";
  $unsecure_sql .= " AND tx.channels_id=:channels";
  $unsecure_sql .= " AND tx.duration_id=:duration";
  if ($_POST['system']!="none") {
    $unsecure_sql .= " AND rec.system_id=:system";
  } else {
   // Allow everything EXCEPT Classic
   $unsecure_sql .= " AND rec.enable=1";
  }

  $prepared_sql = $db->prepare($unsecure_sql);
  $prepared_sql->bindParam(':animal', $_POST['animal']);
  $prepared_sql->bindParam(':biopotential', $_POST['biopotential']);
  $prepared_sql->bindParam(':channels', $_POST['channels']);
  $prepared_sql->bindParam(':duration', $_POST['duration']);
  if ($_POST['system']!='none') { $prepared_sql->bindParam(':system', $_POST['system']); }
  $prepared_sql->execute();

  if ($prepared_sql->rowCount()>0) {
   // Loop through the query results, outputing the options one by one
   $option = 1;
   while ($row = $prepared_sql->fetch(PDO::FETCH_ASSOC)) {
     if (!empty($row['transmitter_pn'])) {
       $key = getGainCombinationKey($db, $prefix);
       if (!$TxOnly) {
         $daq = getDAQ($db);
	 $cables = getCables();
       } else {
	 $daq = null;
       }
       if ($_POST['system']=="none") {
	 if (!$TxOnly ) {
	   $receiver = new QuoteItem($locale["EPOCH_RECEIVER_TRAY"], 1, $row['biopac_receiver_pn'], $row['biopac_receiver_url'], $row['receiver_pn'], $row['receiver_notes']);
	   $cables = getCables();
	 } else {
	   $receiver = null;
	 }
         if ($_POST['duration'] == "reusable" ) {
           $transmitter = new QuoteItem($locale["EPOCH_SENSOR"], 1, $row['biopac_transmitter_pn']."-".sprintf("%05d", $key), $row['biopac_transmitter_url'], $row['transmitter_pn'].getGainCombinationValue($db, $prefix, $key), $locale["ONE_COMPLIMENTARY_SENSOR"].$row['transmitter_notes']);
         } else {
           $transmitter = new QuoteItem($locale["EPOCH_SENSOR"], 2, $row['biopac_transmitter_pn']."-".sprintf("%05d", $key), $row['biopac_transmitter_url'], $row['transmitter_pn'].getGainCombinationValue($db, $prefix, $key), $locale["TWO_COMPLIMENTARY_SENSORS"].$row['transmitter_notes'], null);
         }
       } else {
	 $receiver = null;
         $transmitter = new QuoteItem($locale["EPOCH_SENSOR"], 1, $row['biopac_transmitter_pn']."-".sprintf("%05d", $key), $row['biopac_transmitter_url'], $row['transmitter_pn'].getGainCombinationValue($db, $prefix, $key), $row['transmitter_notes']);
       }
       $activator = getActivator();
       $quote[] = new Quote($daq, $receiver, $transmitter, $cables, $activator, $locale);
       $option++;
     }
   }
 }
 return $quote;
}

/**
 * checkDefaultDropdown()
 */
function checkDefaultDropdown() {
  // CHEAT: gain dropdowns are not in the $dropdowns array, so consider them channels.
  if (isset($_POST['currentDropDown']) && strpos($_POST['currentDropDown'], 'transmitter_gain_') !== false) {
    $_POST['currentDropDown'] = "channels";
  }
}

/**
 * resetForm()
 */
function resetForm() {
  unset($_POST['currentDropDown']);
  unset($_POST['dac']);
  unset($_POST['system']);
  unset($_POST['animal']);
  unset($_POST['biopotential']);
  unset($_POST['channels']);
  unset($_POST['transmitter_gain_1']);
  unset($_POST['transmitter_gain_2']);
  unset($_POST['transmitter_gain_3']);
  unset($_POST['transmitter_gain_4']);
  unset($_POST['transmitter_gain_5']);
  unset($_POST['transmitter_gain_6']);
  unset($_POST['duration']);
}

/**
 * advanceCurrentDropDown($dropdowns)
 */
function advanceCurrentDropDown($dropdowns, $reset='dac') {
  checkDefaultDropdown();
  // Enable the next dropdown in the $dropdowns array, unless it is the last one or blank.
  if (!isset($_POST['currentDropDown']) || $_POST['currentDropDown']=="") {
    resetForm();
    $_POST['currentDropDown'] = $reset;
  } else {
    for ($row = 0; $row < sizeof($dropdowns); $row++) {
      if ($dropdowns[$row][2] == $_POST['currentDropDown'] && $_POST['currentDropDown'] != 'duration' && $_POST[$reset]) {
        unset($_POST[$dropdowns[$row+1][2]]);
        $_POST['currentDropDown'] = $dropdowns[$row+1][2];
        break;
      }
    }
  }
}

/**
 * getHiddenCurrentDropDown()
 */
function getHiddenCurrentDropDown() {
  return "<input type='hidden' id='currentDropDown' name='currentDropDown' value='".$_POST['currentDropDown']."'>";
}

/**
 * showPOST
 */
function showPOST() {
  echo "<pre>"; print_r($_POST); echo "</pre>";
}
 ?>