Esempio n. 1
0
<?php

include "../includes/db.php";
include "../includes/functions.php";
$dateFrom = "";
// date
$csv = '"Date';
$sqlDate = "SELECT * FROM fieldtripdates WHERE ID={$_POST['date']}";
$resultsDate = mysql_query($sqlDate);
$row = mysql_fetch_array($resultsDate);
if ($row['dateFrom'] == $row['dateTo']) {
    $csv .= '",' . dateMD($row['dateFrom']);
} else {
    $csv .= '",' . dateMD($row['dateFrom']) . ' - ' . dateMD($row['dateTo']);
}
$dateFrom = $row['dateFrom'];
$csv .= "\n\n";
// bus
$csv .= "Bus\n";
// name and section
$csv .= '#,Last Name,First Name,Section' . "\n";
// print last, first and section
$sqlBusPeople = "SELECT \r\n\t\t\t\t\t\t\t\tfieldtrippeople.firstName, \r\n\t\t\t\t\t\t\t\tfieldtrippeople.lastName, \r\n\t\t\t\t\t\t\t\tfieldtriplabs.section \r\n\t\t\t\t\t\t\tFROM ((\r\n\t\t\t\t\t\t\t\tfieldtrippeople \r\n\t\t\t\t\t\t\t\t\tJOIN \r\n\t\t\t\t\t\t\t\tfieldtripdates \r\n\t\t\t\t\t\t\t\t\tON \r\n\t\t\t\t\t\t\t\t\t\tfieldtrippeople.datePreffered=fieldtripdates.ID) \r\n\t\t\t\t\t\t\t\t\t\t\tJOIN \r\n\t\t\t\t\t\t\t\t\t\tfieldtriptransportation \r\n\t\t\t\t\t\t\t\t\t\t\tON \r\n\t\t\t\t\t\t\t\t\t\t\t\tfieldtrippeople.transportation=fieldtriptransportation.ID)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tJOIN \r\n\t\t\t\t\t\t\t\t\t\t\t\tfieldtriplabs \r\n\t\t\t\t\t\t\t\t\t\t\t\t\tON \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tfieldtriplabs.ID=fieldtrippeople.section \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE (fieldtripdates.ID={$_POST['date']} && fieldtriptransportation.ID='1' && fieldtrippeople.status='accepted') ORDER BY fieldtrippeople.lastName";
$resultsBusPeople = mysql_query($sqlBusPeople);
$count = 1;
while ($row = mysql_fetch_array($resultsBusPeople)) {
    $csv .= "{$count},{$row['lastName']},{$row['firstName']},{$row['section']}\n";
    $count++;
}
// car
$csv .= "Car\n";
    $sqlCount = "SELECT * FROM fieldtrippeople JOIN fieldtripdates ON fieldtrippeople.datePreffered=fieldtripdates.ID WHERE fieldtripdates.dateFrom='{$row['dateFrom']}'";
    $resultsCount = mysql_query($sqlCount);
    $count = 0;
    while ($rowCount = mysql_fetch_array($resultsCount)) {
        $count++;
    }
    if ($count < 46) {
        echo '<option';
        if (!isset($success_message) && isset($_POST['datePreffered']) && $_POST['datePreffered'] == $row['ID']) {
            echo ' selected ';
        }
        echo ' value="' . $row['ID'] . '">';
        if ($row['dateFrom'] == $row['dateTo']) {
            echo dateMD($row['dateFrom']);
        } else {
            echo dateMD($row['dateFrom']) . ' - ' . dateMD($row['dateTo']);
        }
        echo '</option>';
    }
}
?>
                            </select>
                        </td>
                        <td valign="top" width="175" rowspan="9">
                        	
                        	
                        <table class="availability">
                        <?php 
$datesID = array();
$tempCount = 0;
$sqlDatesArray = "SELECT * FROM fieldtripdates WHERE dateFrom>CURDATE() ORDER BY dateFrom";
Esempio n. 3
0
?>
        </select>
        
        
        <select class="button white" name="fieldDates" onchange="this.form.submit();">
        	<?php 
$sql = "SELECT * FROM events WHERE (date_from={$_POST['years']} && type='fieldcamp' && status='approved') ORDER BY date_from DESC";
$results = mysql_query($sql) or die("Unable to execute:" . mysql_error());
while ($row = mysql_fetch_array($results)) {
    echo '<option ';
    echo 'value="' . dateInUS($row['date_from']) . '" ';
    if (isset($_POST['fieldDates']) && $_POST['fieldDates'] == dateInUS($row['date_from'])) {
        echo " selected";
    }
    echo '>';
    echo dateMD($row['date_from']) . ' - ' . dateMD($row['date_to']);
    echo '</option>';
    if (isset($_POST['fieldDates']) && $_POST['fieldDates'] == dateInUS($row['date_from'])) {
        $ID = $row['ID'];
    }
}
?>
        </select>  
        
        
        <input class="button white" name="info" type="submit" value="INFO" />
        
        <?php 
$sql_photos_button = "SELECT * FROM events WHERE ID={$ID}";
$results_photos_button = mysql_query($sql_photos_button) or die("Unable to execute:" . mysql_error());
$row_photos_button = mysql_fetch_array($results_photos_button);
    echo $bCount;
    ?>
" />
                            <input name="cCount" type="hidden" value="<?php 
    echo $cCount;
    ?>
" />
                            	<tr height="30" >
                                	<td colspan="4">
                                    	<strong><span class="bottom_border"><?php 
    if ($row['dateFrom'] == $row['dateTo']) {
        //echo dateInUS($row['dateFrom']);
        if ($row['dateFrom'] == '2013-10-05') {
            echo 'TBA';
        } else {
            echo dateMD($row['dateFrom']);
        }
    } else {
        echo dateMONDD($row['dateFrom']) . ' - ' . dateMONDD($row['dateTo']);
    }
    ?>
</span></strong>
                                    </td>
                                </tr>
                                <tr height="30">
                                	<td width="25%">
                                    	Bus
                                    </td>
                                    <td width="25%">
                                    	 <div class="<?php 
    ///////