bk_bgcsm
11-14-2005, 07:26 PM
SCRIPT BACKGROUND:
I have been developing a reporting process for Boys & Girls Clubs of Southern Maryland. Here is the generall process: One table (mrps_programs) holds all of the programs kids can participate in, they fit in 5 core areas: ECD, CLD, HLS, SFR, & TA.
The other table holds all of the calendars. The system is setup so when a unit director logs into our intranet they can fill in attendance records.At the beginning of the month they have to check off what programs they plan to run and mrps_build.php builds a blank calendar with the programs they checked off. During the month they can update the numbers.
mrps_build.php retreives which programs are available by querying the mrps_programs table.
THE PROBLEM:
mrps_build.php is building all of the records in the same core area: ECD.
Please help! If I can give you anymore information please let me know!
THE CODE:
mrps_build.php (lists the available programs for unit directors to check off, then it builds blank records (the ones the director checks off) for the month.
<?php
include("mrps_db_connect.php");
$_GET['build'];
$_GET['unit'];
$_GET['year'];
$_GET['month'];
if ($build==yes){
$last_day_of_month = date( "d", mktime(0, 0, 0, $month + 1, 0, $year) ) ;
include("mrps_db_connect.php");
for($i=0; $i<=count($_POST['program_to_build']); $i++) {
$core_area = $_POST['core_area'][$i];
$club = $_POST['program_to_build'][$i];
// CHECK TO MAKE SURE PROGRAM ISN'T BEING DUPLICATED
$query="SELECT * FROM `monthly_reporting_program_statistics` WHERE `year` = $year AND `month` = $month AND `unit` = $unit AND `program` = '$club'";
$result=mysql_query($query);
$num=mysql_numrows($result);
echo "$club of $core_area";
// IF RECORDS EXIST CREATE ERROR
if ($num>=1){
echo "<center><font color=red>The program <b>$club in $core_area</b> already exists. The records for $club were not built to prevent duplication. <br> For more information, contact the Technology Coordinator at the Main Office. <br></font><b>INCIDENT DETAILS:</b> Unit: $unit - Month: $month - Year: $year - Program: $club <br>";
} ELSE {
if (!empty($club)) {
if ($last_day_of_month==28) {
$query = "INSERT INTO `monthly_reporting_program_statistics` (`id`, `unit`, `core_area`, `program`, `date`, `attendance`, `year`, `month`, `day`) VALUES
('', '$unit', '$core_area', '$club', '$year.$month.01', '00', '$year', '$month', '01'),
('', '$unit', '$core_area', '$club', '$year.$month.02', '00', '$year', '$month', '02'),
('', '$unit', '$core_area', '$club', '$year.$month.03', '00', '$year', '$month', '03'),
('', '$unit', '$core_area', '$club', '$year.$month.04', '00', '$year', '$month', '04'),
('', '$unit', '$core_area', '$club', '$year.$month.05', '00', '$year', '$month', '05'),
('', '$unit', '$core_area', '$club', '$year.$month.06', '00', '$year', '$month', '06'),
('', '$unit', '$core_area', '$club', '$year.$month.07', '00', '$year', '$month', '07'),
('', '$unit', '$core_area', '$club', '$year.$month.08', '00', '$year', '$month', '08'),
('', '$unit', '$core_area', '$club', '$year.$month.09', '00', '$year', '$month', '09'),
('', '$unit', '$core_area', '$club', '$year.$month.10', '00', '$year', '$month', '10'),
('', '$unit', '$core_area', '$club', '$year.$month.11', '00', '$year', '$month', '11'),
('', '$unit', '$core_area', '$club', '$year.$month.12', '00', '$year', '$month', '12'),
('', '$unit', '$core_area', '$club', '$year.$month.13', '00', '$year', '$month', '13'),
('', '$unit', '$core_area', '$club', '$year.$month.14', '00', '$year', '$month', '14'),
('', '$unit', '$core_area', '$club', '$year.$month.15', '00', '$year', '$month', '15'),
('', '$unit', '$core_area', '$club', '$year.$month.16', '00', '$year', '$month', '16'),
('', '$unit', '$core_area', '$club', '$year.$month.17', '00', '$year', '$month', '17'),
('', '$unit', '$core_area', '$club', '$year.$month.18', '00', '$year', '$month', '18'),
('', '$unit', '$core_area', '$club', '$year.$month.19', '00', '$year', '$month', '19'),
('', '$unit', '$core_area', '$club', '$year.$month.20', '00', '$year', '$month', '20'),
('', '$unit', '$core_area', '$club', '$year.$month.21', '00', '$year', '$month', '21'),
('', '$unit', '$core_area', '$club', '$year.$month.22', '00', '$year', '$month', '22'),
('', '$unit', '$core_area', '$club', '$year.$month.23', '00', '$year', '$month', '23'),
('', '$unit', '$core_area', '$club', '$year.$month.24', '00', '$year', '$month', '24'),
('', '$unit', '$core_area', '$club', '$year.$month.25', '00', '$year', '$month', '25'),
('', '$unit', '$core_area', '$club', '$year.$month.26', '00', '$year', '$month', '26'),
('', '$unit', '$core_area', '$club', '$year.$month.27', '00', '$year', '$month', '27'),
('', '$unit', '$core_area', '$club', '$year.$month.28', '00', '$year', '$month', '28')";
}
if ($last_day_of_month==29) {
$query = "INSERT INTO `monthly_reporting_program_statistics` (`id`, `unit`, `core_area`, `program`, `date`, `attendance`, `year`, `month`, `day`) VALUES
('', '$unit', '$core_area', '$club', '$year.$month.01', '00', '$year', '$month', '01'),
('', '$unit', '$core_area', '$club', '$year.$month.02', '00', '$year', '$month', '02'),
('', '$unit', '$core_area', '$club', '$year.$month.03', '00', '$year', '$month', '03'),
('', '$unit', '$core_area', '$club', '$year.$month.04', '00', '$year', '$month', '04'),
('', '$unit', '$core_area', '$club', '$year.$month.05', '00', '$year', '$month', '05'),
('', '$unit', '$core_area', '$club', '$year.$month.06', '00', '$year', '$month', '06'),
('', '$unit', '$core_area', '$club', '$year.$month.07', '00', '$year', '$month', '07'),
('', '$unit', '$core_area', '$club', '$year.$month.08', '00', '$year', '$month', '08'),
('', '$unit', '$core_area', '$club', '$year.$month.09', '00', '$year', '$month', '09'),
('', '$unit', '$core_area', '$club', '$year.$month.10', '00', '$year', '$month', '10'),
('', '$unit', '$core_area', '$club', '$year.$month.11', '00', '$year', '$month', '11'),
('', '$unit', '$core_area', '$club', '$year.$month.12', '00', '$year', '$month', '12'),
('', '$unit', '$core_area', '$club', '$year.$month.13', '00', '$year', '$month', '13'),
('', '$unit', '$core_area', '$club', '$year.$month.14', '00', '$year', '$month', '14'),
('', '$unit', '$core_area', '$club', '$year.$month.15', '00', '$year', '$month', '15'),
('', '$unit', '$core_area', '$club', '$year.$month.16', '00', '$year', '$month', '16'),
('', '$unit', '$core_area', '$club', '$year.$month.17', '00', '$year', '$month', '17'),
('', '$unit', '$core_area', '$club', '$year.$month.18', '00', '$year', '$month', '18'),
('', '$unit', '$core_area', '$club', '$year.$month.19', '00', '$year', '$month', '19'),
('', '$unit', '$core_area', '$club', '$year.$month.20', '00', '$year', '$month', '20'),
('', '$unit', '$core_area', '$club', '$year.$month.21', '00', '$year', '$month', '21'),
('', '$unit', '$core_area', '$club', '$year.$month.22', '00', '$year', '$month', '22'),
('', '$unit', '$core_area', '$club', '$year.$month.23', '00', '$year', '$month', '23'),
('', '$unit', '$core_area', '$club', '$year.$month.24', '00', '$year', '$month', '24'),
('', '$unit', '$core_area', '$club', '$year.$month.25', '00', '$year', '$month', '25'),
('', '$unit', '$core_area', '$club', '$year.$month.26', '00', '$year', '$month', '26'),
('', '$unit', '$core_area', '$club', '$year.$month.27', '00', '$year', '$month', '27'),
('', '$unit', '$core_area', '$club', '$year.$month.28', '00', '$year', '$month', '28'),
('', '$unit', '$core_area', '$club', '$year.$month.28', '00', '$year', '$month', '29')";
}
if ($last_day_of_month==30) {
$query = "INSERT INTO `monthly_reporting_program_statistics` (`id`, `unit`, `core_area`, `program`, `date`, `attendance`, `year`, `month`, `day`) VALUES
('', '$unit', '$core_area', '$club', '$year.$month.01', '00', '$year', '$month', '01'),
('', '$unit', '$core_area', '$club', '$year.$month.02', '00', '$year', '$month', '02'),
('', '$unit', '$core_area', '$club', '$year.$month.03', '00', '$year', '$month', '03'),
('', '$unit', '$core_area', '$club', '$year.$month.04', '00', '$year', '$month', '04'),
('', '$unit', '$core_area', '$club', '$year.$month.05', '00', '$year', '$month', '05'),
('', '$unit', '$core_area', '$club', '$year.$month.06', '00', '$year', '$month', '06'),
('', '$unit', '$core_area', '$club', '$year.$month.07', '00', '$year', '$month', '07'),
('', '$unit', '$core_area', '$club', '$year.$month.08', '00', '$year', '$month', '08'),
('', '$unit', '$core_area', '$club', '$year.$month.09', '00', '$year', '$month', '09'),
('', '$unit', '$core_area', '$club', '$year.$month.10', '00', '$year', '$month', '10'),
('', '$unit', '$core_area', '$club', '$year.$month.11', '00', '$year', '$month', '11'),
('', '$unit', '$core_area', '$club', '$year.$month.12', '00', '$year', '$month', '12'),
('', '$unit', '$core_area', '$club', '$year.$month.13', '00', '$year', '$month', '13'),
('', '$unit', '$core_area', '$club', '$year.$month.14', '00', '$year', '$month', '14'),
('', '$unit', '$core_area', '$club', '$year.$month.15', '00', '$year', '$month', '15'),
('', '$unit', '$core_area', '$club', '$year.$month.16', '00', '$year', '$month', '16'),
('', '$unit', '$core_area', '$club', '$year.$month.17', '00', '$year', '$month', '17'),
('', '$unit', '$core_area', '$club', '$year.$month.18', '00', '$year', '$month', '18'),
('', '$unit', '$core_area', '$club', '$year.$month.19', '00', '$year', '$month', '19'),
('', '$unit', '$core_area', '$club', '$year.$month.20', '00', '$year', '$month', '20'),
('', '$unit', '$core_area', '$club', '$year.$month.21', '00', '$year', '$month', '21'),
('', '$unit', '$core_area', '$club', '$year.$month.22', '00', '$year', '$month', '22'),
('', '$unit', '$core_area', '$club', '$year.$month.23', '00', '$year', '$month', '23'),
('', '$unit', '$core_area', '$club', '$year.$month.24', '00', '$year', '$month', '24'),
('', '$unit', '$core_area', '$club', '$year.$month.25', '00', '$year', '$month', '25'),
('', '$unit', '$core_area', '$club', '$year.$month.26', '00', '$year', '$month', '26'),
('', '$unit', '$core_area', '$club', '$year.$month.27', '00', '$year', '$month', '27'),
('', '$unit', '$core_area', '$club', '$year.$month.28', '00', '$year', '$month', '28'),
('', '$unit', '$core_area', '$club', '$year.$month.29', '00', '$year', '$month', '29'),
('', '$unit', '$core_area', '$club', '$year.$month.30', '00', '$year', '$month', '30')";
}
if ($last_day_of_month==31) {
$query = "INSERT INTO `monthly_reporting_program_statistics` (`id`, `unit`, `core_area`, `program`, `date`, `attendance`, `year`, `month`, `day`) VALUES
('', '$unit', '$core_area', '$club', '$year.$month.01', '00', '$year', '$month', '01'),
('', '$unit', '$core_area', '$club', '$year.$month.02', '00', '$year', '$month', '02'),
('', '$unit', '$core_area', '$club', '$year.$month.03', '00', '$year', '$month', '03'),
('', '$unit', '$core_area', '$club', '$year.$month.04', '00', '$year', '$month', '04'),
('', '$unit', '$core_area', '$club', '$year.$month.05', '00', '$year', '$month', '05'),
('', '$unit', '$core_area', '$club', '$year.$month.06', '00', '$year', '$month', '06'),
('', '$unit', '$core_area', '$club', '$year.$month.07', '00', '$year', '$month', '07'),
('', '$unit', '$core_area', '$club', '$year.$month.08', '00', '$year', '$month', '08'),
('', '$unit', '$core_area', '$club', '$year.$month.09', '00', '$year', '$month', '09'),
('', '$unit', '$core_area', '$club', '$year.$month.10', '00', '$year', '$month', '10'),
('', '$unit', '$core_area', '$club', '$year.$month.11', '00', '$year', '$month', '11'),
('', '$unit', '$core_area', '$club', '$year.$month.12', '00', '$year', '$month', '12'),
('', '$unit', '$core_area', '$club', '$year.$month.13', '00', '$year', '$month', '13'),
('', '$unit', '$core_area', '$club', '$year.$month.14', '00', '$year', '$month', '14'),
('', '$unit', '$core_area', '$club', '$year.$month.15', '00', '$year', '$month', '15'),
('', '$unit', '$core_area', '$club', '$year.$month.16', '00', '$year', '$month', '16'),
('', '$unit', '$core_area', '$club', '$year.$month.17', '00', '$year', '$month', '17'),
('', '$unit', '$core_area', '$club', '$year.$month.18', '00', '$year', '$month', '18'),
('', '$unit', '$core_area', '$club', '$year.$month.19', '00', '$year', '$month', '19'),
('', '$unit', '$core_area', '$club', '$year.$month.20', '00', '$year', '$month', '20'),
('', '$unit', '$core_area', '$club', '$year.$month.21', '00', '$year', '$month', '21'),
('', '$unit', '$core_area', '$club', '$year.$month.22', '00', '$year', '$month', '22'),
('', '$unit', '$core_area', '$club', '$year.$month.23', '00', '$year', '$month', '23'),
('', '$unit', '$core_area', '$club', '$year.$month.24', '00', '$year', '$month', '24'),
('', '$unit', '$core_area', '$club', '$year.$month.25', '00', '$year', '$month', '25'),
('', '$unit', '$core_area', '$club', '$year.$month.26', '00', '$year', '$month', '26'),
('', '$unit', '$core_area', '$club', '$year.$month.27', '00', '$year', '$month', '27'),
('', '$unit', '$core_area', '$club', '$year.$month.28', '00', '$year', '$month', '28'),
('', '$unit', '$core_area', '$club', '$year.$month.29', '00', '$year', '$month', '29'),
('', '$unit', '$core_area', '$club', '$year.$month.30', '00', '$year', '$month', '30'),
('', '$unit', '$core_area', '$club', '$year.$month.31', '00', '$year', '$month', '31')";
}
mysql_query($query) or die(mysql_error());
echo "<center>$club in $core_area added for Unit $unit, month of $month $year.</center>";
}
}
}
include("http://www.bgcsm.net/staff/mrps.php?unit=$unit&month=$month&year=$year");
mysql_close();
} else {
require("mrps_header.php");
?>
<form method="POST" action="mrps_build.php">
<p style="margin-top: 0; margin-bottom: 0" align="center"><font size="2"><b>
BUILD RECORDS FOR</b></font></p>
<p style="margin-top: 0; margin-bottom: 0" align="center"> </p>
<center>
<?php if (empty($unit) or empty($month) or empty($year)) { ?>
<center>
<?php
if (empty($unit)){
?>
<p align="center">
<select size="1" name="unit" style="border: 1px solid #000080" class="listbox">
<option value="02">02 Appeal Unit</option>
<option value="03">03 Bayside Unit</option>
<option value="04">04 Carver</option>
<option value="05">05 Green Holly Unit</option>
<option value="06">06 Lexington Park Unit</option>
<option value="07">07 Park Hall Unit</option>
<option value="09">09 Lusby Teen Center</option>
<option value="11">11 Spring Ridge Unit</option></select> <br><br>
<?php } else { ?>
<input type=hidden name="unit" value="<?php echo "$unit"; ?>">
Unit: <?php echo "$unit"; ?>
<br>
<? }
if (empty($month)){ ?>
<select size="1" name="month" style="border: 1px solid #000080" class="listbox">
<option value="01">Jan</option>
<option value="02">Feb</option>
<option value="03">Mar</option>
<option value="04">Apr</option>
<option value="05">May</option>
<option value="06">Jun</option>
<option value="07">Jul</option>
<option value="08">Aug</option>
<option value="09">Sep</option>
<option value="10">Oct</option>
<option value="11">Nov</option>
<option value="12">Dec</option>
</select>
<?php } else { ?>
<input type=hidden name="month" value="<?php echo "$month"; ?>">
Month: <?php echo "$month"; ?>
<br>
<? } if (empty($year)){
?>
<select size="1" name="year" style="border: 1px solid #000080" class="listbox">
<option>2005</option>
<option>2006</option>
<option>2007</option>
<option>2008</option>
<option>2010</option>
<option>2011</option>
<option>2012</option>
<option>2013</option>
<option>2014</option>
<option>2015</option>
</select><br><br>
<?php } else { ?>
<input type=hidden name="year" value="<?php echo "$year"; ?>">
Year: <?php echo "$year"; ?>
<br>
<?php } ?>
<?php } ?>
<div align="center">
<table border="1" width="851" id="table1" style="border-width: 0px" class="maintable" cellspacing="1">
<tr>
<td valign="top" style="border-style: none; border-width: medium" colspan="5" class="tableh2">
<p style="margin-top: 0; margin-bottom: 0" align="center">Select the
programs you plan to run for the above month.</p>
</td>
</tr>
<tr>
<td valign="top" style="border-style: none; border-width: medium" class="tablec" width="170">
<b><font size="1">Character & Leadership Development</font></b></td>
<td valign="top" style="border-style: none; border-width: medium" class="tablec" width="170">
<b><font size="1">Education & Career Development</font></b></td>
<td valign="top" style="border-style: none; border-width: medium" class="tablec" width="170">
<p style="margin-top: 0; margin-bottom: 0"><b><font size="1">Health
& Life Skills</font></b></p>
</td>
<td valign="top" style="border-style: none; border-width: medium" class="tablec" width="170">
<b><font size="1">Sports,
Fitness, & Recreation</font></b></td>
<td valign="top" style="border-style: none; border-width: medium" class="tablec" width="170">
<b><font size="1">The Arts</font></b></td>
</tr><tr valign=top><td style="border-style: none; border-width: medium" class=tableb>
<?PHP
$query="SELECT * FROM `mrps_programs` ORDER BY `core_area` ASC";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$core_area_var=0;
$i=0;
while ($i < $num) {
$program=mysql_result($result,$i,"program");
$core_area=mysql_result($result,$i,"core_area");
if ($core_area_var != $core_area) {
echo "</td><td style=\"border-style: none; border-width: medium\" class=tableb>";
}
echo "<input type=\"hidden\" name=\"core_area[]\" value=\"$core_area\"><input type=\"checkbox\" name=\"program_to_build[]\" value=\"$program\"> $program<br>";
$core_area_var = $core_area;
$i++;
}
?>
</td>
<tr>
<td valign="top" style="border-style: none; border-width: medium" width="838" class="tableb" colspan="5">
<p align="center"><a href="mrps_add_program.php">- ADD PROGRAM TO LIST -</a></td>
</tr>
<tr>
<td valign="top" style="border-style: none; border-width: medium" width="838" class="tablec" colspan="5">
<p style="text-align: center">
<input type="reset" value="Clear Checkboxes" name="B2" class="button">
<input type="submit" value="Build Records >>" name="B1" class="button">
</td>
</tr>
</table>
</div>
<p style="margin-top: 0; margin-bottom: 0"> </p>
<p align="center">
<input type=hidden name=build value=yes>
<p align="center"> </p>
</form>
<?php } ?>
I have been developing a reporting process for Boys & Girls Clubs of Southern Maryland. Here is the generall process: One table (mrps_programs) holds all of the programs kids can participate in, they fit in 5 core areas: ECD, CLD, HLS, SFR, & TA.
The other table holds all of the calendars. The system is setup so when a unit director logs into our intranet they can fill in attendance records.At the beginning of the month they have to check off what programs they plan to run and mrps_build.php builds a blank calendar with the programs they checked off. During the month they can update the numbers.
mrps_build.php retreives which programs are available by querying the mrps_programs table.
THE PROBLEM:
mrps_build.php is building all of the records in the same core area: ECD.
Please help! If I can give you anymore information please let me know!
THE CODE:
mrps_build.php (lists the available programs for unit directors to check off, then it builds blank records (the ones the director checks off) for the month.
<?php
include("mrps_db_connect.php");
$_GET['build'];
$_GET['unit'];
$_GET['year'];
$_GET['month'];
if ($build==yes){
$last_day_of_month = date( "d", mktime(0, 0, 0, $month + 1, 0, $year) ) ;
include("mrps_db_connect.php");
for($i=0; $i<=count($_POST['program_to_build']); $i++) {
$core_area = $_POST['core_area'][$i];
$club = $_POST['program_to_build'][$i];
// CHECK TO MAKE SURE PROGRAM ISN'T BEING DUPLICATED
$query="SELECT * FROM `monthly_reporting_program_statistics` WHERE `year` = $year AND `month` = $month AND `unit` = $unit AND `program` = '$club'";
$result=mysql_query($query);
$num=mysql_numrows($result);
echo "$club of $core_area";
// IF RECORDS EXIST CREATE ERROR
if ($num>=1){
echo "<center><font color=red>The program <b>$club in $core_area</b> already exists. The records for $club were not built to prevent duplication. <br> For more information, contact the Technology Coordinator at the Main Office. <br></font><b>INCIDENT DETAILS:</b> Unit: $unit - Month: $month - Year: $year - Program: $club <br>";
} ELSE {
if (!empty($club)) {
if ($last_day_of_month==28) {
$query = "INSERT INTO `monthly_reporting_program_statistics` (`id`, `unit`, `core_area`, `program`, `date`, `attendance`, `year`, `month`, `day`) VALUES
('', '$unit', '$core_area', '$club', '$year.$month.01', '00', '$year', '$month', '01'),
('', '$unit', '$core_area', '$club', '$year.$month.02', '00', '$year', '$month', '02'),
('', '$unit', '$core_area', '$club', '$year.$month.03', '00', '$year', '$month', '03'),
('', '$unit', '$core_area', '$club', '$year.$month.04', '00', '$year', '$month', '04'),
('', '$unit', '$core_area', '$club', '$year.$month.05', '00', '$year', '$month', '05'),
('', '$unit', '$core_area', '$club', '$year.$month.06', '00', '$year', '$month', '06'),
('', '$unit', '$core_area', '$club', '$year.$month.07', '00', '$year', '$month', '07'),
('', '$unit', '$core_area', '$club', '$year.$month.08', '00', '$year', '$month', '08'),
('', '$unit', '$core_area', '$club', '$year.$month.09', '00', '$year', '$month', '09'),
('', '$unit', '$core_area', '$club', '$year.$month.10', '00', '$year', '$month', '10'),
('', '$unit', '$core_area', '$club', '$year.$month.11', '00', '$year', '$month', '11'),
('', '$unit', '$core_area', '$club', '$year.$month.12', '00', '$year', '$month', '12'),
('', '$unit', '$core_area', '$club', '$year.$month.13', '00', '$year', '$month', '13'),
('', '$unit', '$core_area', '$club', '$year.$month.14', '00', '$year', '$month', '14'),
('', '$unit', '$core_area', '$club', '$year.$month.15', '00', '$year', '$month', '15'),
('', '$unit', '$core_area', '$club', '$year.$month.16', '00', '$year', '$month', '16'),
('', '$unit', '$core_area', '$club', '$year.$month.17', '00', '$year', '$month', '17'),
('', '$unit', '$core_area', '$club', '$year.$month.18', '00', '$year', '$month', '18'),
('', '$unit', '$core_area', '$club', '$year.$month.19', '00', '$year', '$month', '19'),
('', '$unit', '$core_area', '$club', '$year.$month.20', '00', '$year', '$month', '20'),
('', '$unit', '$core_area', '$club', '$year.$month.21', '00', '$year', '$month', '21'),
('', '$unit', '$core_area', '$club', '$year.$month.22', '00', '$year', '$month', '22'),
('', '$unit', '$core_area', '$club', '$year.$month.23', '00', '$year', '$month', '23'),
('', '$unit', '$core_area', '$club', '$year.$month.24', '00', '$year', '$month', '24'),
('', '$unit', '$core_area', '$club', '$year.$month.25', '00', '$year', '$month', '25'),
('', '$unit', '$core_area', '$club', '$year.$month.26', '00', '$year', '$month', '26'),
('', '$unit', '$core_area', '$club', '$year.$month.27', '00', '$year', '$month', '27'),
('', '$unit', '$core_area', '$club', '$year.$month.28', '00', '$year', '$month', '28')";
}
if ($last_day_of_month==29) {
$query = "INSERT INTO `monthly_reporting_program_statistics` (`id`, `unit`, `core_area`, `program`, `date`, `attendance`, `year`, `month`, `day`) VALUES
('', '$unit', '$core_area', '$club', '$year.$month.01', '00', '$year', '$month', '01'),
('', '$unit', '$core_area', '$club', '$year.$month.02', '00', '$year', '$month', '02'),
('', '$unit', '$core_area', '$club', '$year.$month.03', '00', '$year', '$month', '03'),
('', '$unit', '$core_area', '$club', '$year.$month.04', '00', '$year', '$month', '04'),
('', '$unit', '$core_area', '$club', '$year.$month.05', '00', '$year', '$month', '05'),
('', '$unit', '$core_area', '$club', '$year.$month.06', '00', '$year', '$month', '06'),
('', '$unit', '$core_area', '$club', '$year.$month.07', '00', '$year', '$month', '07'),
('', '$unit', '$core_area', '$club', '$year.$month.08', '00', '$year', '$month', '08'),
('', '$unit', '$core_area', '$club', '$year.$month.09', '00', '$year', '$month', '09'),
('', '$unit', '$core_area', '$club', '$year.$month.10', '00', '$year', '$month', '10'),
('', '$unit', '$core_area', '$club', '$year.$month.11', '00', '$year', '$month', '11'),
('', '$unit', '$core_area', '$club', '$year.$month.12', '00', '$year', '$month', '12'),
('', '$unit', '$core_area', '$club', '$year.$month.13', '00', '$year', '$month', '13'),
('', '$unit', '$core_area', '$club', '$year.$month.14', '00', '$year', '$month', '14'),
('', '$unit', '$core_area', '$club', '$year.$month.15', '00', '$year', '$month', '15'),
('', '$unit', '$core_area', '$club', '$year.$month.16', '00', '$year', '$month', '16'),
('', '$unit', '$core_area', '$club', '$year.$month.17', '00', '$year', '$month', '17'),
('', '$unit', '$core_area', '$club', '$year.$month.18', '00', '$year', '$month', '18'),
('', '$unit', '$core_area', '$club', '$year.$month.19', '00', '$year', '$month', '19'),
('', '$unit', '$core_area', '$club', '$year.$month.20', '00', '$year', '$month', '20'),
('', '$unit', '$core_area', '$club', '$year.$month.21', '00', '$year', '$month', '21'),
('', '$unit', '$core_area', '$club', '$year.$month.22', '00', '$year', '$month', '22'),
('', '$unit', '$core_area', '$club', '$year.$month.23', '00', '$year', '$month', '23'),
('', '$unit', '$core_area', '$club', '$year.$month.24', '00', '$year', '$month', '24'),
('', '$unit', '$core_area', '$club', '$year.$month.25', '00', '$year', '$month', '25'),
('', '$unit', '$core_area', '$club', '$year.$month.26', '00', '$year', '$month', '26'),
('', '$unit', '$core_area', '$club', '$year.$month.27', '00', '$year', '$month', '27'),
('', '$unit', '$core_area', '$club', '$year.$month.28', '00', '$year', '$month', '28'),
('', '$unit', '$core_area', '$club', '$year.$month.28', '00', '$year', '$month', '29')";
}
if ($last_day_of_month==30) {
$query = "INSERT INTO `monthly_reporting_program_statistics` (`id`, `unit`, `core_area`, `program`, `date`, `attendance`, `year`, `month`, `day`) VALUES
('', '$unit', '$core_area', '$club', '$year.$month.01', '00', '$year', '$month', '01'),
('', '$unit', '$core_area', '$club', '$year.$month.02', '00', '$year', '$month', '02'),
('', '$unit', '$core_area', '$club', '$year.$month.03', '00', '$year', '$month', '03'),
('', '$unit', '$core_area', '$club', '$year.$month.04', '00', '$year', '$month', '04'),
('', '$unit', '$core_area', '$club', '$year.$month.05', '00', '$year', '$month', '05'),
('', '$unit', '$core_area', '$club', '$year.$month.06', '00', '$year', '$month', '06'),
('', '$unit', '$core_area', '$club', '$year.$month.07', '00', '$year', '$month', '07'),
('', '$unit', '$core_area', '$club', '$year.$month.08', '00', '$year', '$month', '08'),
('', '$unit', '$core_area', '$club', '$year.$month.09', '00', '$year', '$month', '09'),
('', '$unit', '$core_area', '$club', '$year.$month.10', '00', '$year', '$month', '10'),
('', '$unit', '$core_area', '$club', '$year.$month.11', '00', '$year', '$month', '11'),
('', '$unit', '$core_area', '$club', '$year.$month.12', '00', '$year', '$month', '12'),
('', '$unit', '$core_area', '$club', '$year.$month.13', '00', '$year', '$month', '13'),
('', '$unit', '$core_area', '$club', '$year.$month.14', '00', '$year', '$month', '14'),
('', '$unit', '$core_area', '$club', '$year.$month.15', '00', '$year', '$month', '15'),
('', '$unit', '$core_area', '$club', '$year.$month.16', '00', '$year', '$month', '16'),
('', '$unit', '$core_area', '$club', '$year.$month.17', '00', '$year', '$month', '17'),
('', '$unit', '$core_area', '$club', '$year.$month.18', '00', '$year', '$month', '18'),
('', '$unit', '$core_area', '$club', '$year.$month.19', '00', '$year', '$month', '19'),
('', '$unit', '$core_area', '$club', '$year.$month.20', '00', '$year', '$month', '20'),
('', '$unit', '$core_area', '$club', '$year.$month.21', '00', '$year', '$month', '21'),
('', '$unit', '$core_area', '$club', '$year.$month.22', '00', '$year', '$month', '22'),
('', '$unit', '$core_area', '$club', '$year.$month.23', '00', '$year', '$month', '23'),
('', '$unit', '$core_area', '$club', '$year.$month.24', '00', '$year', '$month', '24'),
('', '$unit', '$core_area', '$club', '$year.$month.25', '00', '$year', '$month', '25'),
('', '$unit', '$core_area', '$club', '$year.$month.26', '00', '$year', '$month', '26'),
('', '$unit', '$core_area', '$club', '$year.$month.27', '00', '$year', '$month', '27'),
('', '$unit', '$core_area', '$club', '$year.$month.28', '00', '$year', '$month', '28'),
('', '$unit', '$core_area', '$club', '$year.$month.29', '00', '$year', '$month', '29'),
('', '$unit', '$core_area', '$club', '$year.$month.30', '00', '$year', '$month', '30')";
}
if ($last_day_of_month==31) {
$query = "INSERT INTO `monthly_reporting_program_statistics` (`id`, `unit`, `core_area`, `program`, `date`, `attendance`, `year`, `month`, `day`) VALUES
('', '$unit', '$core_area', '$club', '$year.$month.01', '00', '$year', '$month', '01'),
('', '$unit', '$core_area', '$club', '$year.$month.02', '00', '$year', '$month', '02'),
('', '$unit', '$core_area', '$club', '$year.$month.03', '00', '$year', '$month', '03'),
('', '$unit', '$core_area', '$club', '$year.$month.04', '00', '$year', '$month', '04'),
('', '$unit', '$core_area', '$club', '$year.$month.05', '00', '$year', '$month', '05'),
('', '$unit', '$core_area', '$club', '$year.$month.06', '00', '$year', '$month', '06'),
('', '$unit', '$core_area', '$club', '$year.$month.07', '00', '$year', '$month', '07'),
('', '$unit', '$core_area', '$club', '$year.$month.08', '00', '$year', '$month', '08'),
('', '$unit', '$core_area', '$club', '$year.$month.09', '00', '$year', '$month', '09'),
('', '$unit', '$core_area', '$club', '$year.$month.10', '00', '$year', '$month', '10'),
('', '$unit', '$core_area', '$club', '$year.$month.11', '00', '$year', '$month', '11'),
('', '$unit', '$core_area', '$club', '$year.$month.12', '00', '$year', '$month', '12'),
('', '$unit', '$core_area', '$club', '$year.$month.13', '00', '$year', '$month', '13'),
('', '$unit', '$core_area', '$club', '$year.$month.14', '00', '$year', '$month', '14'),
('', '$unit', '$core_area', '$club', '$year.$month.15', '00', '$year', '$month', '15'),
('', '$unit', '$core_area', '$club', '$year.$month.16', '00', '$year', '$month', '16'),
('', '$unit', '$core_area', '$club', '$year.$month.17', '00', '$year', '$month', '17'),
('', '$unit', '$core_area', '$club', '$year.$month.18', '00', '$year', '$month', '18'),
('', '$unit', '$core_area', '$club', '$year.$month.19', '00', '$year', '$month', '19'),
('', '$unit', '$core_area', '$club', '$year.$month.20', '00', '$year', '$month', '20'),
('', '$unit', '$core_area', '$club', '$year.$month.21', '00', '$year', '$month', '21'),
('', '$unit', '$core_area', '$club', '$year.$month.22', '00', '$year', '$month', '22'),
('', '$unit', '$core_area', '$club', '$year.$month.23', '00', '$year', '$month', '23'),
('', '$unit', '$core_area', '$club', '$year.$month.24', '00', '$year', '$month', '24'),
('', '$unit', '$core_area', '$club', '$year.$month.25', '00', '$year', '$month', '25'),
('', '$unit', '$core_area', '$club', '$year.$month.26', '00', '$year', '$month', '26'),
('', '$unit', '$core_area', '$club', '$year.$month.27', '00', '$year', '$month', '27'),
('', '$unit', '$core_area', '$club', '$year.$month.28', '00', '$year', '$month', '28'),
('', '$unit', '$core_area', '$club', '$year.$month.29', '00', '$year', '$month', '29'),
('', '$unit', '$core_area', '$club', '$year.$month.30', '00', '$year', '$month', '30'),
('', '$unit', '$core_area', '$club', '$year.$month.31', '00', '$year', '$month', '31')";
}
mysql_query($query) or die(mysql_error());
echo "<center>$club in $core_area added for Unit $unit, month of $month $year.</center>";
}
}
}
include("http://www.bgcsm.net/staff/mrps.php?unit=$unit&month=$month&year=$year");
mysql_close();
} else {
require("mrps_header.php");
?>
<form method="POST" action="mrps_build.php">
<p style="margin-top: 0; margin-bottom: 0" align="center"><font size="2"><b>
BUILD RECORDS FOR</b></font></p>
<p style="margin-top: 0; margin-bottom: 0" align="center"> </p>
<center>
<?php if (empty($unit) or empty($month) or empty($year)) { ?>
<center>
<?php
if (empty($unit)){
?>
<p align="center">
<select size="1" name="unit" style="border: 1px solid #000080" class="listbox">
<option value="02">02 Appeal Unit</option>
<option value="03">03 Bayside Unit</option>
<option value="04">04 Carver</option>
<option value="05">05 Green Holly Unit</option>
<option value="06">06 Lexington Park Unit</option>
<option value="07">07 Park Hall Unit</option>
<option value="09">09 Lusby Teen Center</option>
<option value="11">11 Spring Ridge Unit</option></select> <br><br>
<?php } else { ?>
<input type=hidden name="unit" value="<?php echo "$unit"; ?>">
Unit: <?php echo "$unit"; ?>
<br>
<? }
if (empty($month)){ ?>
<select size="1" name="month" style="border: 1px solid #000080" class="listbox">
<option value="01">Jan</option>
<option value="02">Feb</option>
<option value="03">Mar</option>
<option value="04">Apr</option>
<option value="05">May</option>
<option value="06">Jun</option>
<option value="07">Jul</option>
<option value="08">Aug</option>
<option value="09">Sep</option>
<option value="10">Oct</option>
<option value="11">Nov</option>
<option value="12">Dec</option>
</select>
<?php } else { ?>
<input type=hidden name="month" value="<?php echo "$month"; ?>">
Month: <?php echo "$month"; ?>
<br>
<? } if (empty($year)){
?>
<select size="1" name="year" style="border: 1px solid #000080" class="listbox">
<option>2005</option>
<option>2006</option>
<option>2007</option>
<option>2008</option>
<option>2010</option>
<option>2011</option>
<option>2012</option>
<option>2013</option>
<option>2014</option>
<option>2015</option>
</select><br><br>
<?php } else { ?>
<input type=hidden name="year" value="<?php echo "$year"; ?>">
Year: <?php echo "$year"; ?>
<br>
<?php } ?>
<?php } ?>
<div align="center">
<table border="1" width="851" id="table1" style="border-width: 0px" class="maintable" cellspacing="1">
<tr>
<td valign="top" style="border-style: none; border-width: medium" colspan="5" class="tableh2">
<p style="margin-top: 0; margin-bottom: 0" align="center">Select the
programs you plan to run for the above month.</p>
</td>
</tr>
<tr>
<td valign="top" style="border-style: none; border-width: medium" class="tablec" width="170">
<b><font size="1">Character & Leadership Development</font></b></td>
<td valign="top" style="border-style: none; border-width: medium" class="tablec" width="170">
<b><font size="1">Education & Career Development</font></b></td>
<td valign="top" style="border-style: none; border-width: medium" class="tablec" width="170">
<p style="margin-top: 0; margin-bottom: 0"><b><font size="1">Health
& Life Skills</font></b></p>
</td>
<td valign="top" style="border-style: none; border-width: medium" class="tablec" width="170">
<b><font size="1">Sports,
Fitness, & Recreation</font></b></td>
<td valign="top" style="border-style: none; border-width: medium" class="tablec" width="170">
<b><font size="1">The Arts</font></b></td>
</tr><tr valign=top><td style="border-style: none; border-width: medium" class=tableb>
<?PHP
$query="SELECT * FROM `mrps_programs` ORDER BY `core_area` ASC";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$core_area_var=0;
$i=0;
while ($i < $num) {
$program=mysql_result($result,$i,"program");
$core_area=mysql_result($result,$i,"core_area");
if ($core_area_var != $core_area) {
echo "</td><td style=\"border-style: none; border-width: medium\" class=tableb>";
}
echo "<input type=\"hidden\" name=\"core_area[]\" value=\"$core_area\"><input type=\"checkbox\" name=\"program_to_build[]\" value=\"$program\"> $program<br>";
$core_area_var = $core_area;
$i++;
}
?>
</td>
<tr>
<td valign="top" style="border-style: none; border-width: medium" width="838" class="tableb" colspan="5">
<p align="center"><a href="mrps_add_program.php">- ADD PROGRAM TO LIST -</a></td>
</tr>
<tr>
<td valign="top" style="border-style: none; border-width: medium" width="838" class="tablec" colspan="5">
<p style="text-align: center">
<input type="reset" value="Clear Checkboxes" name="B2" class="button">
<input type="submit" value="Build Records >>" name="B1" class="button">
</td>
</tr>
</table>
</div>
<p style="margin-top: 0; margin-bottom: 0"> </p>
<p align="center">
<input type=hidden name=build value=yes>
<p align="center"> </p>
</form>
<?php } ?>