| S/N |
PCC Name |
Fellowship Date |
Fellowship Week |
Total Attendees |
Visited By |
Offering |
Tithe |
Expenses |
Treasury Balance |
Date Submitted |
Report Status |
-1 ";
$param = array();
if(isset($_POST['search']))
{
$searchtext = $_POST['search'];
$department = $_POST['department'];
if(strlen(trim($department)) > 0)
{
$sql .= " AND (`pccs_area` = :pccs_area)";
$param[":pccs_area"] = $department;
}
}
if(isset($_POST['searchdate']))
{
$searchtext = $_POST['search'];
//$department = $_POST['department'];
$start =$_POST['from_searchdate'];
$end = $_POST['to_searchdate'];
if(strlen(trim($start)) > 0)
{
$sql .= " AND (`fellowship_date` >= :start and fellowship_date <= :end)";
$param[":start"] = $start;
$param[":end"] = $end;
}
}
if(isset($_POST['searchweek']))
{
$searchtext = $_POST['search'];
//$department = $_POST['department'];
$week = $_POST['week'];
if(strlen(trim($week)) > 0)
{
$sql .= " AND (`fellowship_week` = :week)";
$param[":week"] = $week;
}
}
$myrec = $mycon->prepare($sql);
$myrec->execute($param);
$pos = 0;
while($row = $myrec->fetch(PDO::FETCH_ASSOC))
{
$fd = $row['fellowship_date'];
$ds = date("Y-m-d", $row['date_submitted']);
//echo $ds;
$date1 = date_create(date("d-m-Y", strtotime($fd)));
$date2 = date_create(date("d-m-Y", strtotime($ds)));
$interval=date_diff($date1,$date2);
$diff = $interval->format('%R%a');
$time_submitted = date('H', $row['date_submitted']);
//echo $time_submitted."
";
if($diff <= 1)
{
$flag = "On time"; //green flag
}
else
{
$flag = "Late"; // red flag
}
?>
|
|
|
|
|
|
N |
N |
N |
N |
|
|
|
|
|
|
|
|
N |
N |
N |
N |
|
|