Location: PHPKode > projects > ConPortal > conportal/inc/weekview/db.php
<?php
/*
 *  ConPortal - Pomona College ITS & Bucknell University ISR scheduling appplication
 *  Copyright (C) 2005-2007  Pomona College, Bucknell University
 *
 *  This program is free software; you can redistribute it and/or modify
 *  it under the terms of version 2 of the GNU General Public License
 *  as published by the Free Software Foundation.
 *
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  along with this program; if not, write to the Free Software
 *  Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
 */

/*
Implemented in this file
	
	getShiftsForWeek
	

 */



function getShiftsForWeek($startDate)
{
	$endDate = strtotime("+6 days", $startDate);
	
	$result = safeQuery("SELECT first, last, users.pid AS userpid, start_time, end_time, " .
			"start_date, end_date, day_of_week, position FROM shifts LEFT JOIN users ON " .
			"owner = users.pid WHERE start_date <= FROM_UNIXTIME(%d) AND " .
			"end_date >= FROM_UNIXTIME(%d) ORDER BY day_of_week, position, start_time",
			$endDate, $startDate);

	$a = array();
	$i= 0;
	while ($row = mysql_fetch_assoc($result))
	{
			$a[$i]= $row;
			$i++;
	}
	return $a;
}
	

?>
Return current item: ConPortal