| S/N |
PCC Name |
Fellowship Date |
Fellowship Week |
Start Time |
End Time |
Total Attendees |
Total Workers |
Total 1st Timers |
Visited By |
Offering |
Full Offering |
Tithe |
Expenses |
Treasury Balance |
Date Submitted |
Report Status |
-1 AND `fellowship_date`>'2015-12-31'";
// $sql = "SELECT * FROM `pcc_report` WHERE `pcc_id` > -1 AND `fellowship_date`>'".$date_of_current_year."'";
$sql = "SELECT * FROM `pcc_report` WHERE `pcc_id` > -1 AND year(`fellowship_date`) = '".$currentYear."'";
$param = array();
if(isset($_POST['search']))
{
$sql = "SELECT * FROM `pcc_report` WHERE `pcc_id` > -1";
$searchtext = $_POST['search'];
$department = $_POST['department'];
$dateto = $_POST['dateto'];
$datefrom = $_POST['datefrom'];
$week = $_POST['week'];
if(strlen(trim($department)) > 0)
{
//$sql = "SELECT * FROM `pcc_report` WHERE `pcc_id` > -1 AND `fellowship_date` >'".$date_of_current_year."'";
//$sql .= " AND (`pccs_area` = :pccs_area)";
//$sql = "SELECT * FROM `pcc_report` WHERE `pcc_id` > -1 AND (`pccs_area` = :pccs_area)";
//$sql = "SELECT * FROM `pcc_report` WHERE `pcc_id` > -1 AND year(`fellowship_date`) ='".$currentYear."'";
$sql .= " AND (`pccs_area` = :pccs_area)";
$param[":pccs_area"] = $department;
}
if(strlen(trim($week)) > 0)
{
//$sql = "SELECT * FROM `pcc_report` WHERE `pcc_id` > -1 AND `fellowship_date` >'".$date_of_current_year."'";
//$sql .= " AND ( `fellowship_week` = :week)";
// $sql = "SELECT * FROM `pcc_report` WHERE `pcc_id` > -1 AND year(`fellowship_date`) = '".$currentYear."'";
$sql .= " AND ( `fellowship_week` = :week)";
$param[":week"] = $week;
}
if(strlen(trim($datefrom)) > 0)
{
$sql .= " AND (`fellowship_date` >= :datefrom)";
// $sql = "SELECT * FROM `pcc_report` WHERE `pcc_id` > -1 AND (`fellowship_date` >= :datefrom)";
$param[":datefrom"] = $datefrom;
}
if(strlen(trim($dateto)) > 0)
{
$sql .= " AND (`fellowship_date` <= :dateto)";
$param[":dateto"] = $dateto;
}
}
$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']);
$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
}
?>
|
|
|
|
pm |
pm |
|
|
|
|
N |
N |
N |
N |
N |
|
|
|
|
|
|
|
|
|
|
|
|
N |
N |
N |
N |
N |
|
|