| S/N |
PCC Name |
Fellowship Date |
Fellowship Week |
Offering |
Tithe |
Expenses |
Expenses Type |
Full Offering |
Treasury Adjustment |
Treasury Balance |
Date Submitted |
Report Status |
'2015-12-31'";
$sql = "SELECT * FROM `pcc_report` WHERE `pcc_id` = '$currentuserid' AND `fellowship_date`>'".$date_of_current_year."'";
$param = array();
if(isset($_POST['searchdate']))
{
$searchtext = $_POST['from_searchdate'];
//$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)";
$sql = "SELECT * FROM `pcc_report` WHERE `pcc_id` = '$currentuserid' AND (`fellowship_date` >= :start and fellowship_date <= :end)";
$param[":start"] = $start;
$param[":end"] = $end;
}
}
if(isset($_POST['searchexpensetype']))
{
$searchtext = $_POST['expense_type'];
//$department = $_POST['department'];
$expense_type = $_POST['expense_type'];
if(strlen(trim($expense_type)) > 0)
{
$sql .= " AND (`expense_type` = '$expense_type')";
//$sql .= " AND (`expense_type` = :expense_type)";
$param[":expense_type"] = $expense_type;
}
}
$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
}
?>
|
|
|
|
N |
N |
N |
|
N |
N |
N |
|
|
|
|
|
|
N |
N |
N |
|
N |
N |
N |
|
|
|