public static function insertEvent($frm_submitted, $current_user_id = '')
{
global $obj_db;
$arr_calendar = array();
if ($frm_submitted['cal_id'] > 0) {
$arr_calendar = Calendar::getCalendar($frm_submitted['cal_id']);
}
if (User::isLoggedIn() || $arr_calendar['share_type'] == 'public' && $arr_calendar['can_add']) {
if (empty($current_user_id)) {
$arr_user = User::getUser();
if (!empty($arr_user) && is_array($arr_user)) {
$current_user_id = $arr_user['user_id'];
}
}
if (IGNORE_TIMEZONE) {
$str_startdate = $frm_submitted['str_date_start'];
$str_enddate = $frm_submitted['str_date_end'];
$str_starttime = substr($frm_submitted['str_date_start'], 10);
$str_endtime = substr($frm_submitted['str_date_end'], 10);
} else {
$str_startdate = date('Y-m-d', $frm_submitted['date_start']);
$str_enddate = date('Y-m-d', $frm_submitted['date_end']);
$str_starttime = date('H:i:s', $frm_submitted['date_start']);
$str_endtime = date('H:i:s', $frm_submitted['date_end']);
}
$query = "select * from events where order_id=" . $frm_submitted['order_id'];
$assigned = mysqli_query($obj_db, $query);
if (!empty($assigned)) {
mysqli_query($obj_db, "delete from events where order_id=" . $frm_submitted['order_id']);
}
$str_query = 'INSERT INTO events ( title, description, calendar_id, location, phone, myurl, repeating_event_id, user_id, color, date_start, time_start, date_end, time_end, create_date, allday, order_id) ' . 'VALUES ("' . mysqli_real_escape_string($obj_db, $frm_submitted['title']) . '",' . '"' . mysqli_real_escape_string($obj_db, $frm_submitted['description']) . '",' . '"' . $frm_submitted['cal_id'] . '",' . '"' . mysqli_real_escape_string($obj_db, $frm_submitted['location']) . '",' . '"' . mysqli_real_escape_string($obj_db, $frm_submitted['phone']) . '",' . '"' . mysqli_real_escape_string($obj_db, $frm_submitted['myurl']) . '",' . (!empty($frm_submitted['rep_event_id']) ? $frm_submitted['rep_event_id'] : 0) . ',' . '"' . $current_user_id . '",' . '"' . $frm_submitted['color'] . '",' . '"' . $str_startdate . '",' . '"' . $str_starttime . '",' . '"' . $str_enddate . '",' . '"' . $str_endtime . '",' . '"' . date('Y-m-d H:i:s') . '"' . (date('H:i:s', $frm_submitted['date_start']) == '00:00:00' && date('H:i:s', $frm_submitted['date_end']) == '00:00:00' || $frm_submitted['allDay'] == 1 ? ' ,1' : ' ,0') . ',' . $frm_submitted['order_id'] . '' . ')';
$obj_result = mysqli_query($obj_db, $str_query);
if ($obj_result !== false) {
$str_query = 'SELECT *, event_id as id, concat_ws(" ",date_start,time_start) as start,concat_ws(" ",date_end,time_end) as end ' . 'FROM events WHERE event_id = ' . mysqli_insert_id($obj_db);
$obj_result2 = mysqli_query($obj_db, $str_query);
$arr_event = mysqli_fetch_array($obj_result2, MYSQLI_ASSOC);
if (empty($arr_calendar)) {
$arr_calendar = Calendar::getCalendar($arr_event['calendar_id']);
}
$arr_event['allDay'] = $arr_event['allDay'] == 0 ? false : true;
$arr_event['allowEdit'] = true;
// = User::canEdit($arr_event['user_id']);
$arr_event['editable'] = true;
//= User::canEdit($arr_event['user_id']);
$arr_event['deletable'] = User::canDelete($arr_event['user_id']);
$arr_event['canChangeColor'] = User::canChangeColor($arr_event['user_id'], $arr_event['calendar_id']);
$arr_event['canMail'] = Calendar::calCanMail($arr_calendar);
// notification mail to admin
if (Calendar::calMailEventModsToAdmin($arr_calendar)) {
$arr_user = User::getUserById($arr_event['user_id']);
$to_mail = Calendar::getCalendarAdminEmail($arr_calendar);
if (!empty($to_mail)) {
$bln_send = Utils::sendMail('mail_event', $to_mail, '', $frm_submitted, $arr_user);
}
}
} else {
return false;
}
return $arr_event;
} else {
return false;
}
}
