Reoccuring Calendar events

  
		$ccdlookupwhere  = " object_id = " . $DBConnection1->ToSQL($cal_object_booking->object_id->GetValue(), ccsInteger);  
		$ccdlookupwhere .= " and (date_from >=". $DBConnection1->ToSQL($cal_object_booking->date_from->GetValue(),ccsDate) ;  
		$ccdlookupwhere .= " and date_from < ". $DBConnection1->ToSQL($cal_object_booking->date_to->GetValue(),ccsDate) . ")" ;   
        if (CCGetFromGet(booking_id,""))  
		    $ccdlookupwhere .= " and booking_id <> " .  CCGetFromGet(booking_id,"");  
  
		$result = CCDLookup("count(*)", "cal_calendar", $ccdlookupwhere, $DBConnection1);  
		if ($result) {  
			$cal_object_booking->{Errors}->addError($CCSLocales->GetText('Period_not_available'));	  
		}  
  

  
//End cal_object_booking_ds_AfterExecuteInsert  
  
//Custom Code @16-2A29BDB7  
// -------------------------  
    // Write your own code here.  
// -------------------------  
 $LastBookingID = mysql_insert_id();  
 Insert_Calendar($LastBookingID);  
//End Custom Code  

  
//End cal_object_booking_ds_AfterExecuteDelete  
  
//Custom Code @17-2A29BDB7  
// -------------------------  
    // Write your own code here.  
// -------------------------  
 $db = new clsDBConnection1;  
 Delete_Calendar(CCGetFromGet(booking_id,""));  
//End Custom Code  

  
//End cal_object_booking_ds_AfterExecuteUpdate  
  
//Custom Code @18-2A29BDB7  
// -------------------------  
    // Write your own code here.  
// -------------------------  
 $Booking_id = CCGetFromGet(booking_id);  
 Delete_Calendar( $Booking_id );  
 Insert_Calendar( $Booking_id );  
  
//End Custom Code  
  

  
function Delete_Calendar($booking_id)  
{  
 $db = new clsDBConnection1;  
    $SQL="DELETE from cal_calendar WHERE booking_id =". $booking_id;  
    $db->query($SQL);  
    $db->close();  
}  
  
function Insert_Calendar($booking_id)  
{  
    $db = new clsDBConnection1;  
  $object_id =   
CCDLookup("object_id","cal_object_booking","booking_id=".$booking_id, $db);  
  $DateFrom  =   
CCDLookup("date_from","cal_object_booking","booking_id=".$booking_id, $db);  
  $DateTo    =   
CCDLookup("date_to","cal_object_booking","booking_id=".$booking_id, $db);  
  $status_id =   
CCDLookup("status_id","cal_object_booking","booking_id=".$booking_id, $db);  
  
// date is in yyyy-mm-dd format, php substring position 0 is the first   
character of the string  
    $year  = substr($DateFrom, 0, 4);  
    $month = substr($DateFrom, 5, 2);  
    $day   = substr($DateFrom, 8, 2);  
    $t1    = mktime(0, 0, 0, $month, $day, $year); // is the given date_from   
in seconds since epoch()  
    $year  = substr($DateTo, 0, 4);  
    $month = substr($DateTo, 5, 2);  
    $day   = substr($DateTo, 8, 2);  
    $t2    = mktime(0, 0, 0, $month, $day, $year); // is the given date_to   
in seconds since epoch()  
/*    this is for debug only  
echo $DateFrom;  
echo "<br>". $year;  
echo "<br>". $month;  
echo "<br>". $day;  
echo "<br>". $t1;  
echo "<br>". $t2;  
*/  
  
    While ($t1 < $t2) {                                    // $t1 is   
manipulated within the following lines thus changing, incrementing  
     $SQL = "INSERT INTO cal_calendar ("  
          . "booking_id, "  
             . "object_id, "  
             . "date_from, "  
             . "status_id "  
           . ") VALUES ("  
           . $db->ToSQL($booking_id, ccsInteger) . ", "  
           . $db->ToSQL($object_id, ccsInteger) . ", "  
           . $db->ToSQL(Date("Y-m-d",$t1), ccsDate) . ", "  
           . $db->ToSQL($status_id, ccsInteger) . ")";  
//  echo $SQL . "<br>"; //debug  
      $db->query($SQL);  
  
     $t1 = mktime(  
           date('h', $t1),  
              date('i', $t1),  
              date('s', $t1),  
              date('m', $t1),  
              date('d', $t1) + 1,        // this is where one day is added   
and month and year automaically increment when needed  
              date('Y', $t1)  
              );  
 } // end WHILE  
  
}  
  
  
?>