<?php

JFactory::getApplication('site')->initialise();

$user = JFactory::getUser();
$useridgv = $user->id;

global $fiscdate;
global $datevarS;
global $datevarE;
global $eventtype;
global $acid;
global $acmnthhrs;
global $acfyhrs;
global $acttlnmcs;
global $acfynmcs;
global $acmnthnmcs;
global $groupid;
global $locid;

/*echo 'gid ' . $groupid . ' lid ' . $locid . ' acid ' . $acid . ' evtype ' . $eventtype;*/

$db = JFactory::getDBO();
$query = "
SELECT COALESCE(SUM(STATUS.input_metric_a),0) AS grandttlhrs FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id 
WHERE STATUS.input_event_date <= '$datevarE' AND STATUS.input_tail_number = $acid AND STATUS.input_event_type != 'History' AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acttlhrs = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_a),0) AS grandttlhrs FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id 
WHERE (STATUS.input_event_date >= '$fiscdate' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acfyhrs = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_a),0) AS grandttlhrs FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id 
WHERE (STATUS.input_event_date >= '$datevarS' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acmnthhrs = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_b),0) AS grandttllndgs FROM `wzg_chronoforms_data_AirframeStatusDetails`STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id 
WHERE (STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid)  AND STATUS.input_event_type != 'History' AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acttllndgs = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_b),0) AS grandttllndgs FROM `wzg_chronoforms_data_AirframeStatusDetails`STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$fiscdate') AND (STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acfylndgs = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_b),0) AS grandttllndgs FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$datevarS' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acmnthlndgs = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_c),0) AS grandttlfs FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND STATUS.input_event_type != 'History' AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acttlfs = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_c),0) AS grandttlfs FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$fiscdate' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acfyfs = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_c),0) AS grandttlfs FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$datevarS' AND STATUS.input_event_date <= '$datevarE')  AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acmnthfs = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_d),0) AS grandttltg FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND STATUS.input_event_type != 'History'  AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acttltgs = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_d),0) AS grandttltg FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$fiscdate' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acfytgs = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_d),0) AS grandttltg FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$datevarS' AND STATUS.input_event_date <= '$datevarE')  AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acmnthtgs = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_e),0) AS grandttlapu FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date <= '$datevarE' AND STATUS.input_tail_number = $acid) AND STATUS.input_event_type != 'History' AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acttlapu = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_e),0) AS grandttlapu FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$fiscdate' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acfyapu = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_e),0) AS grandttlapu FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$datevarS' AND STATUS.input_event_date <= '$datevarE')  AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acmnthapu = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_f),0) AS grandttlmas FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND STATUS.input_event_type != 'History' AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acttlmas = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_f),0) AS grandttlmas FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$fiscdate' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acfymas = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_f),0) AS grandttlmas FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$datevarS' AND STATUS.input_event_date <= '$datevarE')  AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acmnthmas = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_g),0) AS grandttldly FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND STATUS.input_event_type != 'History' AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acttldly = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_g),0) AS grandttldly FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$fiscdate' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acfydly = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_g),0) AS grandttldly FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$datevarS' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acmnthdly = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_h),0) AS grandttllbr FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND STATUS.input_event_type != 'History'  AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$ttllabor = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_i),0) AS grandttlcst FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND STATUS.input_event_type != 'History'  AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$ttlcost = $row['0'];

$query = "
SELECT COALESCE(SUM(input_metric_1),0) AS grandttlNRT FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acttlnrt = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_1),0) AS grandttlNRT FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$fiscdate' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acfynrt = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_1),0) AS grandttlNRT FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$datevarS' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acmnthnrt = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_2),0) AS grandttlNMCM FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND STATUS.input_event_type != 'History' AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acttlnmcm = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_2),0) AS grandttlNMCM FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$fiscdate' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acfynmcm = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_2),0) AS grandttlNMCM FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$datevarS' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acmnthnmcm = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_3),0) AS grandttlNMCS FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND STATUS.input_event_type != 'History' AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acttlnmcs = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_3),0) AS grandttlNMCS FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$fiscdate' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acfynmcs = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_3),0) AS grandttlNMCS FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$datevarS' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acmnthnmcs = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_4),0) AS grandttlPMCM FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id 
WHERE (STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND STATUS.input_event_type != 'History' AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acttlpmcm = $row['0'];


$query = "
SELECT COALESCE(SUM(STATUS.input_metric_4),0) AS grandttlPMCM FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$fiscdate' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acfypmcm = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_4),0) AS grandttlPMCM FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$datevarS' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid)  AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acmnthpmcm = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_5),0) AS grandttlPMCS FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND STATUS.input_event_type != 'History' AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acttlpmcs = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_5),0) AS grandttlPMCS FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$fiscdate' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acfypmcs = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_5),0) AS grandttlPMCS FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$datevarS' AND STATUS.input_event_date <= '$datevarE')  AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acmnthpmcs = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_6),0) AS grandttlPMCB FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND STATUS.input_event_type != 'History' AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acttlpmcb = $row['0'];


$query = "
SELECT COALESCE(SUM(STATUS.input_metric_6),0) AS grandttlPMCB FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$fiscdate' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acfypmcb = $row['0'];

$query = "
SELECT COALESCE(SUM(STATUS.input_metric_6),0) AS grandttlPMCB FROM `wzg_chronoforms_data_AirframeStatusDetails` STATUS 
JOIN `wzg_chronoforms_data_ACAircraft` AC ON STATUS.input_tail_number=AC.cf_id
WHERE (STATUS.input_event_date >= '$datevarS' AND STATUS.input_event_date <= '$datevarE') AND (STATUS.input_tail_number = $acid) AND (AC.input_location) = '$locid' AND AC.input_group = '$groupid' $eventtype
";
$db->setQuery($query);
$row = $db->loadRow();
$acmnthpmcb = $row['0'];

$query = "
SELECT input_FMC_Min FROM `wzg_chronoforms_data_ACContractPerformanceMinimums` 
";
$db->setQuery($query);
$row = $db->loadRow();
$fmcmin = $row['0'];
?>