How Many Hashes


setLink(“how-many-hashes?page=%s”);
$pagination->setPage($page);
$pagination->setSize($size);
?>

Number of hashes run (excluding weekend events)

Minimum 40 runs

= 451
and `Hash Name` is null
and ( locate(‘ ‘,Name) <> 2 and locate(‘ ‘,Name) <> 0)
group by 1
having (count(a.`Run Number`) + add_runs) >= 40
union
select
`Hasher ID`,
r.Name,
count(a.`Run Number`) + ifnull(r.`Missing Runs`,0) + ifnull(r.`Runs Before 9/2/1987`,0),
max(`Run Number`),
date(max(rlist.`rdate`)),
+ ifnull(r.`Missing Runs`,0) + ifnull(r.`Runs Before 9/2/1987`,0) as add_runs
from attendance a
inner join register r on a.`Hasher ID` = r.ID
join rlist on rlist.num = a.`Run Number`
where a.`Run Number` >= 451
and `Hash Name` is null
and (( locate(‘ ‘,Name) = 2 or locate(‘ ‘,Name) = 0))
group by 1
having (count(a.`Run Number`) + add_runs) >= 40
union
select
`Hasher ID`,
concat(`Hash Name`,’ (‘, left(Name, locate(‘ ‘,Name)-1), ‘)’),
count(a.`Run Number`) + ifnull(r.`Missing Runs`,0) + ifnull(r.`Runs Before 9/2/1987`,0),
max(`Run Number`),
date(max(rlist.`rdate`)),
+ ifnull(r.`Missing Runs`,0) + ifnull(r.`Runs Before 9/2/1987`,0) as add_runs
from attendance a
inner join register r on a.`Hasher ID` = r.ID
join rlist on rlist.num = a.`Run Number`
where a.`Run Number` >= 451
and `Hash Name` is not null
group by 1
having (count(a.`Run Number`) + add_runs) >= 40
order by 3 desc, 4 desc, 2 asc; “;

$result = mysqli2_query ($query, $conn);
if (!$result) {
die(‘Invalid query: ‘ . mysqli_error());
}
$pagination->setTotalRecords(mysqli2_num_rows($result));

mysqli_free_result($result);

$query = “select
`Hasher ID`,
left(r.Name, locate(‘ ‘,r.Name)+1) as Name,
count(a.`Run Number`) + ifnull(r.`Missing Runs`,0) + ifnull(r.`Runs Before 9/2/1987`,0) as ‘Runs’,
max(`Run Number`) as ‘LastRun’,
date(max(rlist.`rdate`)) as ‘LastRunDate’,
+ ifnull(r.`Missing Runs`,0) + ifnull(r.`Runs Before 9/2/1987`,0) as ‘add_runs’
from attendance a
inner join register r on a.`Hasher ID` = r.ID
join rlist on rlist.num = a.`Run Number`
where a.`Run Number` >= 451
and `Hash Name` is null
and ( locate(‘ ‘,Name) <> 2 and locate(‘ ‘,Name) <> 0)
group by 1
having (count(a.`Run Number`) + add_runs) >= 40
union
select
`Hasher ID`,
r.Name,
count(a.`Run Number`) + ifnull(r.`Missing Runs`,0) + ifnull(r.`Runs Before 9/2/1987`,0),
max(`Run Number`),
date(max(rlist.`rdate`)),
+ ifnull(r.`Missing Runs`,0) + ifnull(r.`Runs Before 9/2/1987`,0) as add_runs
from attendance a
inner join register r on a.`Hasher ID` = r.ID
join rlist on rlist.num = a.`Run Number`
where a.`Run Number` >= 451
and `Hash Name` is null
and (( locate(‘ ‘,Name) = 2 or locate(‘ ‘,Name) = 0))
group by 1
having (count(a.`Run Number`) + add_runs) >= 40
union
select
`Hasher ID`,
concat(`Hash Name`,’ (‘, left(Name, locate(‘ ‘,Name)-1), ‘)’),
count(a.`Run Number`) + ifnull(r.`Missing Runs`,0) + ifnull(r.`Runs Before 9/2/1987`,0),
max(`Run Number`),
date(max(rlist.`rdate`)),
+ ifnull(r.`Missing Runs`,0) + ifnull(r.`Runs Before 9/2/1987`,0) as add_runs
from attendance a
inner join register r on a.`Hasher ID` = r.ID
join rlist on rlist.num = a.`Run Number`
where a.`Run Number` >= 451
and `Hash Name` is not null
group by 1
having (count(a.`Run Number`) + add_runs) >= 40
order by 3 desc, 4 desc, 2 asc “.$pagination->getLimitSql();

$result = mysqli2_query ($query, $conn);
if (!$result) {
die(‘Invalid query: ‘ . mysqli_error());
}

echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo “Name”.”
“;
echo “Runs”.”
“;
echo “Last Run Date and Number”.”

“;

while ($resultrow= mysqli2_fetch_assoc($result)) {
$rdate_array_split=explode(” “,$resultrow[“LastRunDate”]);
$rdate_array = explode(“-“,$rdate_array_split[0]);
$rdate = $rdate_array[1].”/”.$rdate_array[2].”/”.$rdate_array[0];
$rdate_dsp = $rdate_array[2].”/”.$rdate_array[1].”/”.$rdate_array[0];
$name = $resultrow[“Name”];
$runs = $resultrow[“Runs”];
$lastrun = $resultrow[“LastRun”];

echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo ”

“;
echo $name.”
“;
echo $runs.”
“;
echo $rdate_dsp.”
“;
echo $lastrun.”
“;
echo “

“;
}
mysqli_free_result($result);
?>