コード例 #1
0
ファイル: subscribe.php プロジェクト: annickvdp/Chamilo1.9.10
		} else {
			$from_till = "";
			$min_timepicker = 1;
			//een reservatieperiode moet toch wel minimum 1 minuut zijn
		}

		$res_start_at = $reservation[0][5];
		$res_end_at = $reservation[0][6];
		//echo time()."-".$res_start_at;
		if (time() > Rsys :: mysql_datetime_to_timestamp($res_start_at)) {
			$time_start = time();
		} else {
			$time_start = Rsys :: mysql_datetime_to_timestamp($res_start_at);
		}

		$sql = "SELECT start_at, end_at FROM ".Rsys :: getTable('subscription')."
				WHERE reservation_id='".$reservationid."' and end_at > NOW() ORDER BY start_at";
		$result = Database::query($sql);
		if (Database::num_rows($result) != 0){
			$start_end = "<ul>";
			while ($array = Database::fetch_array($result)) {
				//print_r($array);
				if (time() < Rsys :: mysql_datetime_to_timestamp($array["start_at"]))
				{
					if (((Rsys :: mysql_datetime_to_timestamp($array["start_at"]) - $time_start) >= ($min_timepicker*60)) && ($time_start < Rsys :: mysql_datetime_to_timestamp($array["start_at"])))
					{
						$start_end .= "<li>".Rsys :: timestamp_to_datetime($time_start)." en ".$array["start_at"]."</li>";
					}
				}
				$time_start = Rsys :: mysql_datetime_to_timestamp($array["end_at"]);
				$end_time_last_block = $array["end_at"];
コード例 #2
0
ファイル: rsys.php プロジェクト: ilosada/chamilo-lms-icpna
 function get_item_id($item_name)
 {
     $item_name = Database::escape_string($item_name);
     $sql = "SELECT id FROM " . Rsys::getTable('item') . " WHERE name='" . $item_name . "'";
     $result = Database::query($sql);
     $result_array = Database::fetch_array($result);
     return $result_array['id'];
 }
コード例 #3
0
         $from_till = "van " . $min_timepicker_show . " tot " . $max_timepicker_show;
     }
 } else {
     $from_till = "";
     $min_timepicker = 1;
     //een reservatieperiode moet toch wel minimum 1 minuut zijn
 }
 $res_start_at = $reservation[0][5];
 $res_end_at = $reservation[0][6];
 //echo time()."-".$res_start_at;
 if (time() > Rsys::mysql_datetime_to_timestamp($res_start_at)) {
     $time_start = time();
 } else {
     $time_start = Rsys::mysql_datetime_to_timestamp($res_start_at);
 }
 $sql = "SELECT start_at, end_at FROM " . Rsys::getTable('subscription') . "\n\t\t\t\tWHERE reservation_id='" . $reservationid . "' and end_at > NOW() ORDER BY start_at";
 $result = Database::query($sql);
 if (Database::num_rows($result) != 0) {
     $start_end = "<ul>";
     while ($array = Database::fetch_array($result)) {
         //print_r($array);
         if (time() < Rsys::mysql_datetime_to_timestamp($array["start_at"])) {
             if (Rsys::mysql_datetime_to_timestamp($array["start_at"]) - $time_start >= $min_timepicker * 60 && $time_start < Rsys::mysql_datetime_to_timestamp($array["start_at"])) {
                 $start_end .= "<li>" . Rsys::timestamp_to_datetime($time_start) . " en " . $array["start_at"] . "</li>";
             }
         }
         $time_start = Rsys::mysql_datetime_to_timestamp($array["end_at"]);
         $end_time_last_block = $array["end_at"];
     }
     if (Rsys::mysql_datetime_to_timestamp($res_end_at) - Rsys::mysql_datetime_to_timestamp($end_time_last_block) >= $min_timepicker * 60) {
         $start_end .= "<li>" . $end_time_last_block . " en " . $res_end_at . "</li>";