// //will be included in update processing
// }
// $conn->event->attach("beforeUpdate","my_update");
$conn->enable_log("temp.log");
$c_id = $_SESSION["login"];
$type = $_GET['type'];
$eid = $_GET['eid'];
// $conn->render_table("bookevent","event_id","start_date,end_date,event_name");
function insert_session($action)
{
$action->add_field("cid", $_SESSION["login"]);
$action->add_field("eid", $_GET["eid"]);
}
$conn->event->attach("beforeProcessing", "insert_session");
// $conn->event->attach("Select","select * from bookevent where c_id={c_id}");
// $conn->render_table("bookevent","event_id","start_date,end_date,event_name,cid");
// $conn->render_sql("select * from bookevent where c_id = ".$c_id." AND `start_date` >= '2015-07-08 00:00:00' AND `end_date` <= '2015-07-11 00:00:00' ","event_id","start_date,end_date,event_name,rec_type,event_pid,event_length,details,event_location,lat,lng");
if ($type == 1) {
// $conn->render_sql("select * from bookevent where c_id = ".$c_id." AND `start_date` >= '2015-07-08 00:00:00' AND `end_date` <= '2015-07-11 00:00:00' ","event_id","start_date,end_date,event_name,rec_type,event_pid,event_length,details,event_location,lat,lng");
} else {
$conn->sql->attach("Update", "UPDATE bookevent SET event_name='{event_name}',start_date='{start_date}',end_date='{end_date}' WHERE event_id={event_id}");
$conn->sql->attach("Delete", "DELETE FROM bookevent WHERE event_id={event_id}");
$conn->sql->attach("Insert", "INSERT INTO `calendar`.`bookevent` (`event_id`, `event_name`, `start_date`, `end_date` ,`cid`,`eid` ) \n\t\t\t\t\t\t\t\t\t\tVALUES (NULL, '{event_name}', '{start_date}', '{end_date}' , " . $c_id . " ," . $eid . ")");
// $conn->sql->attach("Select","SELECT * FROM bookevent WHERE eid=".$eid);
$conn->render_sql("SELECT * FROM bookevent WHERE eid=" . $eid, "event_id", "start_date,end_date,event_name,readonly,cid,eid", "", "");
// $conn->render_sql("SELECT bookevent.*,cus.c_id,cus.c_fname FROM bookevent INNER JOIN cus ON bookevent.c_id=cus.c_id INNER JOIN friends on friends.c_id_1= bookevent.c_id OR friends.c_id_2=bookevent.c_id WHERE bookevent.Privacy=2 or bookevent.c_id=".$c_id,"event_id","start_date,end_date,event_name,rec_type,event_pid,event_length,event_location,lat,lng,readonly,priority,Privacy,c_id,c_fname", "", "");
// $conn->render_table("bookevent","event_id","start_date,end_date,event_name,rec_type,event_pid,event_length,details,event_location,lat,lng,subject");
// $sql = "SELECT * FROM bookevent WHERE ( bookevent.c_id = 2) or bookevent.c_id=(SELECT c_id_2 FROM friends where c_id_1=2)";
// $conn->sql->attach("Select","Select * FROM bookevent ");
//SELECT * FROM bookevent WHERE `bookevent`.`c_id` = ".$c_id." or bookevent.c_id=(SELECT c_id_2 FROM friends where c_id_1=".$c_id." )
}
$details->configure("cus", "c_id", "c_id,c_fname");
$conn = new SchedulerConnector($res);
$conn->mix("cus", $details, array("c_id" => "c_id"));
// function my_update($data){
// $data->add_field("c_id",1);
// $data->set_value("c_id","10");
// //will be included in update processing
// }
// $conn->event->attach("beforeUpdate","my_update");
$conn->enable_log("temp.log");
$c_id = $_SESSION["login"];
$type = $_GET['type'];
// $conn->render_table("events","event_id","start_date,end_date,event_name");
// function insert_session($action){
// $action->add_field("c_id", $_SESSION["login"]);
// }
// $conn->event->attach("beforeProcessing", "insert_session");
// $conn->event->attach("Select","select * from events where c_id={c_id}");
// $conn->render_table("events","event_id","start_date,end_date,event_name,rec_type,event_pid,event_length,details,event_location,lat,lng");
// $conn->render_sql("select * from events where c_id = ".$c_id." AND `start_date` >= '2015-07-08 00:00:00' AND `end_date` <= '2015-07-11 00:00:00' ","event_id","start_date,end_date,event_name,rec_type,event_pid,event_length,details,event_location,lat,lng");
if ($type == 1) {
// $conn->render_sql("select * from events where c_id = ".$c_id." AND `start_date` >= '2015-07-08 00:00:00' AND `end_date` <= '2015-07-11 00:00:00' ","event_id","start_date,end_date,event_name,rec_type,event_pid,event_length,details,event_location,lat,lng");
} else {
$conn->sql->attach("Update", "Update events set event_name='{event_name}',start_date='{start_date}',end_date='{end_date}',rec_type='{rec_type}',event_pid='{event_pid}',event_length='{event_length}',event_location='{event_location}',lat='{lat}',lng='{lng}',readonly='{readonly}',priority='{priority}',Privacy='{Privacy}',c_id='{c_id}',priority='{priority}' where event_id={event_id}");
$conn->sql->attach("Delete", "DELETE FROM events WHERE event_id={event_id}");
$conn->sql->attach("Insert", "INSERT INTO `calendar`.`events` (`event_id`, `event_name`, `start_date`, `end_date`, `event_length`, `event_pid`, `rec_type`, `details`, `event_location`, `lat`, `lng`, `c_id`, `readonly`, `priority`, `Privacy`) \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tVALUES (NULL, '{event_name}', '{start_date}', '{end_date}', '{event_length}', '{event_pid}', '{rec_type}', '{details}', '{event_location}', '{lat}', '{lng}', '{c_id}', '{readonly}', '{priority}', '{Privacy}')");
$conn->render_sql("SELECT events.*,cus.c_id,cus.c_fname FROM events INNER JOIN cus ON events.c_id=cus.c_id INNER JOIN friends on friends.c_id_1= events.c_id OR friends.c_id_2=events.c_id WHERE events.Privacy=2 or events.c_id=" . $c_id, "event_id", "start_date,end_date,event_name,rec_type,event_pid,event_length,event_location,lat,lng,readonly,priority,Privacy,c_id,c_fname", "", "");
// $conn->render_table("events","event_id","start_date,end_date,event_name,rec_type,event_pid,event_length,details,event_location,lat,lng,subject");
// $sql = "SELECT * FROM events WHERE ( events.c_id = 2) or events.c_id=(SELECT c_id_2 FROM friends where c_id_1=2)";
//SELECT * FROM events WHERE `events`.`c_id` = ".$c_id." or events.c_id=(SELECT c_id_2 FROM friends where c_id_1=".$c_id." )
}
