<?php
require_once("config.php");

$mycon = databaseConnect();

//get the counts
$year = date("Y");
if(isset($_POST['year']) && $_POST['year'] != "")
{
	$newyear = $_POST['year'];
	if(is_numeric($newyear) && strlen($newyear) == 4) $year = $newyear;
}
$sql = "SELECT `worker_id`, (SELECT COUNT(`card_id`) FROM `cards` WHERE `carddate` LIKE '$year-01%') AS card1,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `carddate` LIKE '$year-02%') AS card2,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `carddate` LIKE '$year-03%') AS card3,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `carddate` LIKE '$year-04%') AS card4,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `carddate` LIKE '$year-05%') AS card5,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `carddate` LIKE '$year-06%') AS card6,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `carddate` LIKE '$year-07%') AS card7,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `carddate` LIKE '$year-08%') AS card8,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `carddate` LIKE '$year-09%') AS card9,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `carddate` LIKE '$year-10%') AS card10,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `carddate` LIKE '$year-11%') AS card11,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `carddate` LIKE '$year-12%') AS card12,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `carddate` LIKE '$year-%') AS cardtotal,

							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Male' AND `carddate` LIKE '$year-01%') AS male1,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Male' AND `carddate` LIKE '$year-02%') AS male2,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Male' AND `carddate` LIKE '$year-03%') AS male3,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Male' AND `carddate` LIKE '$year-04%') AS male4,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Male' AND `carddate` LIKE '$year-05%') AS male5,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Male' AND `carddate` LIKE '$year-06%') AS male6,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Male' AND `carddate` LIKE '$year-07%') AS male7,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Male' AND `carddate` LIKE '$year-08%') AS male8,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Male' AND `carddate` LIKE '$year-09%') AS male9,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Male' AND `carddate` LIKE '$year-10%') AS male10,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Male' AND `carddate` LIKE '$year-11%') AS male11,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Male' AND `carddate` LIKE '$year-12%') AS male12,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Male' AND `carddate` LIKE '$year-%') AS maletotal,

							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Female' AND `carddate` LIKE '$year-01%') AS female1,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Female' AND `carddate` LIKE '$year-02%') AS female2,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Female' AND `carddate` LIKE '$year-03%') AS female3,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Female' AND `carddate` LIKE '$year-04%') AS female4,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Female' AND `carddate` LIKE '$year-05%') AS female5,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Female' AND `carddate` LIKE '$year-06%') AS female6,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Female' AND `carddate` LIKE '$year-07%') AS female7,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Female' AND `carddate` LIKE '$year-08%') AS female8,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Female' AND `carddate` LIKE '$year-09%') AS female9,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Female' AND `carddate` LIKE '$year-10%') AS female10,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Female' AND `carddate` LIKE '$year-11%') AS female11,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Female' AND `carddate` LIKE '$year-12%') AS female12,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `gender` = 'Female' AND `carddate` LIKE '$year-%') AS femaletotal,

							(SELECT COUNT(`card_id`) FROM `members` WHERE `carddate` LIKE '$year-01%') AS membership1,
							(SELECT COUNT(`card_id`) FROM `members` WHERE `carddate` LIKE '$year-02%') AS membership2,
							(SELECT COUNT(`card_id`) FROM `members` WHERE `carddate` LIKE '$year-03%') AS membership3,
							(SELECT COUNT(`card_id`) FROM `members` WHERE `carddate` LIKE '$year-04%') AS membership4,
							(SELECT COUNT(`card_id`) FROM `members` WHERE `carddate` LIKE '$year-05%') AS membership5,
							(SELECT COUNT(`card_id`) FROM `members` WHERE `carddate` LIKE '$year-06%') AS membership6,
							(SELECT COUNT(`card_id`) FROM `members` WHERE `carddate` LIKE '$year-07%') AS membership7,
							(SELECT COUNT(`card_id`) FROM `members` WHERE `carddate` LIKE '$year-08%') AS membership8,
							(SELECT COUNT(`card_id`) FROM `members` WHERE `carddate` LIKE '$year-09%') AS membership9,
							(SELECT COUNT(`card_id`) FROM `members` WHERE `carddate` LIKE '$year-10%') AS membership10,
							(SELECT COUNT(`card_id`) FROM `members` WHERE `carddate` LIKE '$year-11%') AS membership11,
							(SELECT COUNT(`card_id`) FROM `members` WHERE `carddate` LIKE '$year-12%') AS membership12,
							(SELECT COUNT(`card_id`) FROM `members` WHERE `carddate` LIKE '$year-%') AS membershiptotal,

							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Rededication' AND `carddate` LIKE '$year-01%') AS rededication1,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Rededication' AND `carddate` LIKE '$year-02%') AS rededication2,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Rededication' AND `carddate` LIKE '$year-03%') AS rededication3,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Rededication' AND `carddate` LIKE '$year-04%') AS rededication4,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Rededication' AND `carddate` LIKE '$year-05%') AS rededication5,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Rededication' AND `carddate` LIKE '$year-06%') AS rededication6,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Rededication' AND `carddate` LIKE '$year-07%') AS rededication7,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Rededication' AND `carddate` LIKE '$year-08%') AS rededication8,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Rededication' AND `carddate` LIKE '$year-09%') AS rededication9,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Rededication' AND `carddate` LIKE '$year-10%') AS rededication10,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Rededication' AND `carddate` LIKE '$year-11%') AS rededication11,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Rededication' AND `carddate` LIKE '$year-12%') AS rededication12,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Rededication' AND `carddate` LIKE '$year-%') AS rededicationtotal,

							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Holy Ghost baptism' AND `carddate` LIKE '$year-01%') AS baptism1,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Holy Ghost baptism' AND `carddate` LIKE '$year-02%') AS baptism2,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Holy Ghost baptism' AND `carddate` LIKE '$year-03%') AS baptism3,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Holy Ghost baptism' AND `carddate` LIKE '$year-04%') AS baptism4,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Holy Ghost baptism' AND `carddate` LIKE '$year-05%') AS baptism5,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Holy Ghost baptism' AND `carddate` LIKE '$year-06%') AS baptism6,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Holy Ghost baptism' AND `carddate` LIKE '$year-07%') AS baptism7,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Holy Ghost baptism' AND `carddate` LIKE '$year-08%') AS baptism8,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Holy Ghost baptism' AND `carddate` LIKE '$year-09%') AS baptism9,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Holy Ghost baptism' AND `carddate` LIKE '$year-10%') AS baptism10,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Holy Ghost baptism' AND `carddate` LIKE '$year-11%') AS baptism11,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Holy Ghost baptism' AND `carddate` LIKE '$year-12%') AS baptism12,
							(SELECT COUNT(`card_id`) FROM `cards` WHERE `spiritualneeds` = 'Holy Ghost baptism' AND `carddate` LIKE '$year-%') AS baptismtotal,

							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `service` LIKE '%vangelism%' AND `carddate` LIKE '$year-01%') AS evangelism1,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `service` LIKE '%vangelism%' AND `carddate` LIKE '$year-02%') AS evangelism2,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `service` LIKE '%vangelism%' AND `carddate` LIKE '$year-03%') AS evangelism3,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `service` LIKE '%vangelism%' AND `carddate` LIKE '$year-04%') AS evangelism4,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `service` LIKE '%vangelism%' AND `carddate` LIKE '$year-05%') AS evangelism5,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `service` LIKE '%vangelism%' AND `carddate` LIKE '$year-06%') AS evangelism6,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `service` LIKE '%vangelism%' AND `carddate` LIKE '$year-07%') AS evangelism7,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `service` LIKE '%vangelism%' AND `carddate` LIKE '$year-08%') AS evangelism8,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `service` LIKE '%vangelism%' AND `carddate` LIKE '$year-09%') AS evangelism9,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `service` LIKE '%vangelism%' AND `carddate` LIKE '$year-10%') AS evangelism10,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `service` LIKE '%vangelism%' AND `carddate` LIKE '$year-11%') AS evangelism11,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `service` LIKE '%vangelism%' AND `carddate` LIKE '$year-12%') AS evangelism12,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `service` LIKE '%vangelism%' AND `carddate` LIKE '$year-%') AS evangelismtotal,

							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `carddate` LIKE '$year-01%') AS convert1,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `carddate` LIKE '$year-02%') AS convert2,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `carddate` LIKE '$year-03%') AS convert3,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `carddate` LIKE '$year-04%') AS convert4,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `carddate` LIKE '$year-05%') AS convert5,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `carddate` LIKE '$year-06%') AS convert6,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `carddate` LIKE '$year-07%') AS convert7,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `carddate` LIKE '$year-08%') AS convert8,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `carddate` LIKE '$year-09%') AS convert9,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `carddate` LIKE '$year-10%') AS convert10,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `carddate` LIKE '$year-11%') AS convert11,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `carddate` LIKE '$year-12%') AS convert12,
							(SELECT COUNT(`convert_id`) FROM `converts` WHERE `carddate` LIKE '$year-%') AS converttotal


							FROM `workers` LIMIT 1";


$myrec = $mycon->query($sql);
$reportdetails = $myrec->fetch(PDO::FETCH_ASSOC);

?>


<!DOCTYPE HTML>
<!-- Website Template by freewebsitetemplates.com -->
<html>
<head>
	<meta charset="UTF-8">
	<title><?php echo pageTitle() ?></title>
	<link rel="stylesheet" href="css/style.css" type="text/css">
	<!--[if lt IE 9]>
		<link rel="stylesheet" type="text/css" href="css/ie.css">
	<![endif]-->
</head>
<body>
	<?php require_once("inc_top.php") ?>
	<div id="body">
<div class="content">
			<div class="section">
				<div class="breadcrumb">
					<span>You are here:</span>
					<ul>
						<li>
							<a href="index.html">home</a>
						</li>
						<li>
							<a href="reports.php">Reports</a>
						</li>
						<li>
							<a href="#">CFN Score Card</a>
						</li>
					</ul>
				</div>
				<div class="company">

					<form name="form1" method="post" action="">
					  <h2>CFN SCORE CARD REPORT FOR <input name="year" type="text" id="year" value="<?php echo $year ?>">
			          <input type="submit" name="button" id="button" value="Go!">
				  </h2>
				  </form>
<div style="clear:both; height:10px"></div>
					<table width="100%" border="0">
					  <tr>
					    <td><table width="100%" border="0">
					      <tr>
					        <td height="25">&nbsp;</td>
					        <td><strong>JAN</strong></td>
					        <td bgcolor="#F3F3F3"><strong>FEB</strong></td>
					        <td><strong>MAR</strong></td>
					        <td bgcolor="#F3F3F3"><strong>APR</strong></td>
					        <td><strong>MAY</strong></td>
					        <td bgcolor="#F3F3F3"><strong>JUN</strong></td>
					        <td><strong>JUL</strong></td>
					        <td bgcolor="#F3F3F3"><strong>AUG</strong></td>
					        <td><strong>SEP</strong></td>
					        <td bgcolor="#F3F3F3"><strong>OCT</strong></td>
					        <td><strong>NOV</strong></td>
					        <td bgcolor="#F3F3F3"><strong>DEC</strong></td>
					        <td><strong>TOTAL</strong></td>
				          </tr>
					      <tr>
					        <td height="31"><strong>Total 1st Timers</strong></td>
					        <td><?php echo number_format($reportdetails['card1'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['card2'],0) ?></td>
					        <td><?php echo number_format($reportdetails['card3'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['card4'],0) ?></td>
					        <td><?php echo number_format($reportdetails['card5'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['card6'],0) ?></td>
					        <td><?php echo number_format($reportdetails['card7'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['card8'],0) ?></td>
					        <td><?php echo number_format($reportdetails['card9'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['card10'],0) ?></td>
					        <td><?php echo number_format($reportdetails['card11'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['card12'],0) ?></td>
					        <td><strong><?php echo number_format($reportdetails['cardtotal'],0) ?></strong></td>
				          </tr>
					      <tr>
					        <td height="31"><strong>Total Males</strong></td>
					        <td><?php echo number_format($reportdetails['male1'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['male2'],0) ?></td>
					        <td><?php echo number_format($reportdetails['male3'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['male4'],0) ?></td>
					        <td><?php echo number_format($reportdetails['male5'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['male6'],0) ?></td>
					        <td><?php echo number_format($reportdetails['male7'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['male8'],0) ?></td>
					        <td><?php echo number_format($reportdetails['male9'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['male10'],0) ?></td>
					        <td><?php echo number_format($reportdetails['male11'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['male12'],0) ?></td>
					        <td><strong><?php echo number_format($reportdetails['maletotal'],0) ?></strong></td>
				          </tr>
					      <tr>
					        <td height="31"><strong>Total Females</strong></td>
					        <td><?php echo number_format($reportdetails['female1'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['female2'],0) ?></td>
					        <td><?php echo number_format($reportdetails['female3'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['female4'],0) ?></td>
					        <td><?php echo number_format($reportdetails['female5'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['female6'],0) ?></td>
					        <td><?php echo number_format($reportdetails['female7'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['female8'],0) ?></td>
					        <td><?php echo number_format($reportdetails['female9'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['female10'],0) ?></td>
					        <td><?php echo number_format($reportdetails['female11'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['female12'],0) ?></td>
					        <td><strong><?php echo number_format($reportdetails['femaletotal'],0) ?></strong></td>
				          </tr>
					      <tr>
					        <td height="31">&nbsp;</td>
					        <td>&nbsp;</td>
					        <td bgcolor="#F3F3F3">&nbsp;</td>
					        <td>&nbsp;</td>
					        <td bgcolor="#F3F3F3">&nbsp;</td>
					        <td>&nbsp;</td>
					        <td bgcolor="#F3F3F3">&nbsp;</td>
					        <td>&nbsp;</td>
					        <td bgcolor="#F3F3F3">&nbsp;</td>
					        <td>&nbsp;</td>
					        <td bgcolor="#F3F3F3">&nbsp;</td>
					        <td>&nbsp;</td>
					        <td bgcolor="#F3F3F3">&nbsp;</td>
					        <td>&nbsp;</td>
				          </tr>
					      <tr>
					        <td height="31"><strong>Indicated Membership</strong></td>
					        <td><?php echo number_format($reportdetails['membership1'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['membership2'],0) ?></td>
					        <td><?php echo number_format($reportdetails['membership3'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['membership4'],0) ?></td>
					        <td><?php echo number_format($reportdetails['membership5'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['membership6'],0) ?></td>
					        <td><?php echo number_format($reportdetails['membership7'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['membership8'],0) ?></td>
					        <td><?php echo number_format($reportdetails['membership9'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['membership10'],0) ?></td>
					        <td><?php echo number_format($reportdetails['membership11'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['membership12'],0) ?></td>
					        <td><strong><?php echo number_format($reportdetails['membershiptotal'],0) ?></strong></td>
				          </tr>
					      <tr>
					        <td height="31"><strong>Re-dedications</strong></td>
					        <td><?php echo number_format($reportdetails['rededication1'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['rededication2'],0) ?></td>
					        <td><?php echo number_format($reportdetails['rededication3'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['rededication4'],0) ?></td>
					        <td><?php echo number_format($reportdetails['rededication5'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['rededication6'],0) ?></td>
					        <td><?php echo number_format($reportdetails['rededication7'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['rededication8'],0) ?></td>
					        <td><?php echo number_format($reportdetails['rededication9'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['rededication10'],0) ?></td>
					        <td><?php echo number_format($reportdetails['rededication11'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['rededication12'],0) ?></td>
					        <td><strong><?php echo number_format($reportdetails['rededicationtotal'],0) ?></strong></td>
				          </tr>
					      <tr>
					        <td height="31"><strong>New Converts</strong></td>
					        <td><?php echo number_format($reportdetails['convert1'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['convert2'],0) ?></td>
					        <td><?php echo number_format($reportdetails['convert3'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['convert4'],0) ?></td>
					        <td><?php echo number_format($reportdetails['convert5'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['convert6'],0) ?></td>
					        <td><?php echo number_format($reportdetails['convert7'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['convert8'],0) ?></td>
					        <td><?php echo number_format($reportdetails['convert9'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['convert10'],0) ?></td>
					        <td><?php echo number_format($reportdetails['convert11'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['convert12'],0) ?></td>
					        <td><strong><?php echo number_format($reportdetails['converttotal'],0) ?></strong></td>
				          </tr>
					      <tr>
					        <td height="31"><strong>Baptism of the Holy Spirit</strong></td>
					        <td><?php echo number_format($reportdetails['baptism1'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['baptism2'],0) ?></td>
					        <td><?php echo number_format($reportdetails['baptism3'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['baptism4'],0) ?></td>
					        <td><?php echo number_format($reportdetails['baptism5'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['baptism6'],0) ?></td>
					        <td><?php echo number_format($reportdetails['baptism7'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['baptism8'],0) ?></td>
					        <td><?php echo number_format($reportdetails['baptism9'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['baptism10'],0) ?></td>
					        <td><?php echo number_format($reportdetails['baptism11'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['baptism12'],0) ?></td>
					        <td><strong><?php echo number_format($reportdetails['baptismtotal'],0) ?></strong></td>
				          </tr>
					      <tr>
					        <td height="31"><strong>Evangelism</strong></td>
					        <td><?php echo number_format($reportdetails['evangelism1'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['evangelism2'],0) ?></td>
					        <td><?php echo number_format($reportdetails['evangelism3'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['evangelism4'],0) ?></td>
					        <td><?php echo number_format($reportdetails['evangelism5'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['evangelism6'],0) ?></td>
					        <td><?php echo number_format($reportdetails['evangelism7'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['evangelism8'],0) ?></td>
					        <td><?php echo number_format($reportdetails['evangelism9'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['evangelism10'],0) ?></td>
					        <td><?php echo number_format($reportdetails['evangelism11'],0) ?></td>
					        <td bgcolor="#F3F3F3"><?php echo number_format($reportdetails['evangelism12'],0) ?></td>
					        <td><strong><?php echo number_format($reportdetails['evangelismtotal'],0) ?></strong></td>
				          </tr>
					      <tr>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
				          </tr>
					      <tr>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
					        <td>&nbsp;</td>
				          </tr>
				        </table></td>
				      </tr>
					  <tr>
					    <td>
					      <form action="reports_scorecards_export.php" method="post" name="form2" target="actionframe" id="form3">
					        <input type="submit" name="button3" id="button3" value="Export to Excel" onclick="javscript: exportReport(this.form,'csv') " />
					        <input name="year" type="hidden" id="year" value="<?php echo $year ?>" />
					      </form>
					    </td>
				      </tr>
			      </table>
					<p>&nbsp;</p>
				</div>
			</div>
		</div>
        </div>
	<?php require_once("inc_footer.php") ?>
</body>
</html>