PHP-Calendar日程安排程序.7z

<?php /* * Copyright 2012 Sean Proctor * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ require_once("$phpc_includes_path/phpccalendar.class.php"); require_once("$phpc_includes_path/phpcevent.class.php"); require_once("$phpc_includes_path/phpcoccurrence.class.php"); require_once("$phpc_includes_path/phpcuser.class.php"); class PhpcDatabase { var $dbh; var $calendars; function __construct($host, $username, $passwd, $dbname, $port) { // Make the database connection. $this->dbh = new mysqli($host, $username, $passwd, $dbname, $port); if(mysqli_connect_errno()) { soft_error("Database connect failed (" . mysqli_connect_errno() . "): " . mysqli_connect_error()); } $this->dbh->set_charset("utf8"); } function __destruct() { $this->dbh->close(); } private function get_event_fields() { $events_table = SQL_PREFIX . "events"; $cats_table = SQL_PREFIX . "categories"; $fields = array('subject', 'description', 'owner', 'eid', 'cid', 'readonly', 'catid', 'ctime', 'mtime'); return "`$cats_table`.`gid`, `$events_table`.`" . implode("`, `$events_table`.`", $fields) . "`\n"; } private function get_occurrence_fields() { return $this->get_event_fields() . ", `time_type`, `oid`, " . "UNIX_TIMESTAMP(`start_ts`) AS `start_ts`, " . "DATE_FORMAT(`start_date`, '%Y%m%d') AS `start_date`, " . "UNIX_TIMESTAMP(`end_ts`) AS `end_ts`, " . "DATE_FORMAT(`end_date`, '%Y%m%d') AS `end_date`\n"; } private function get_user_fields() { $users_table = SQL_PREFIX . "users"; return "`$users_table`.`uid`, `username`, `password`, `$users_table`.`admin`, `password_editable`, `timezone`, `language`"; } // returns all the events for a particular day // $from and $to are timestamps only significant to the date. // an event that happens later in the day of $to is included function get_occurrences_by_date_range($cid, $from, $to) { $from_date = date('Y-m-d', $from); $to_date = date('Y-m-d', $to); $events_table = SQL_PREFIX . "events"; $occurrences_table = SQL_PREFIX . "occurrences"; $users_table = SQL_PREFIX . 'users'; $cats_table = SQL_PREFIX . 'categories'; $query = "SELECT " . $this->get_occurrence_fields() .", `username`, `name`, `bg_color`, `text_color`\n" ."FROM `$events_table`\n" ."INNER JOIN `$occurrences_table` USING (`eid`)\n" ."LEFT JOIN `$users_table` ON `uid` = `owner`\n" ."LEFT JOIN `$cats_table` ON `$events_table`.`catid` " ."= `$cats_table`.`catid`\n" ."WHERE `$events_table`.`cid` = '$cid'\n" ." AND IF(`start_ts`, DATE(`start_ts`), `start_date`) <= DATE('$to_date')\n" ." AND IF(`end_ts`, DATE(`end_ts`), `end_date`) >= DATE('$from_date')\n" ." ORDER BY `start_ts`, `start_date`, `oid`"; $results = $this->dbh->query($query) or $this->db_error(__('Error in get_occurrences_by_date_range'), $query); return $results; } /* if category is visible to user id */ function is_cat_visible($uid, $catid) { $users_table = SQL_PREFIX . 'users'; $user_groups_table = SQL_PREFIX . 'user_groups'; $cats_table = SQL_PREFIX . 'categories'; if (is_admin()) return true; $query = "SELECT * FROM `$users_table` u\n" ."JOIN `$user_groups_table` ug USING (`uid`)\n" ."JOIN `$cats_table` c ON c.`gid`=ug.`gid`\n" ."WHERE c.`catid`='$catid' AND u.`uid`='$uid'"; $results = $this->dbh->query($query); if(!$results) return false; return $results->num_rows>0; } // returns all the events for a particular day function get_occurrences_by_date($cid, $year, $month, $day) { $stamp = mktime(0, 0, 0, $month, $day, $year); return $this->get_occurrences_by_date_range($cid, $stamp, $stamp); } // returns the event that corresponds to eid function get_event_by_eid($eid) { $events_table = SQL_PREFIX . 'events'; $users_table = SQL_PREFIX . 'users'; $cats_table = SQL_PREFIX . 'categories'; $query = "SELECT " . $this->get_event_fields() .", `username`, `name`, `bg_color`, `text_color`\n" ."FROM `$events_table`\n" ."LEFT JOIN `$users_table` ON `uid` = `owner`\n" ."LEFT JOIN `$cats_table` USING (`catid`)\n" ."WHERE `eid` = '$eid'\n"; $sth = $this->dbh->query($query) or $this->db_error(__('Error in get_event_by_eid'), $query); $result = $sth->fetch_assoc() or soft_error(__("Event doesn't exist") . ": $eid"); return $result; } // returns the event that corresponds to oid function get_event_by_oid($oid) { $events_table = SQL_PREFIX . 'events'; $occurrences_table = SQL_PREFIX . 'occurrences'; $users_table = SQL_PREFIX . 'users'; $cats_table = SQL_PREFIX . 'categories'; $query = "SELECT " . $this->get_event_fields() .", `username`, `name`, `bg_color`, `text_color`\n" ."FROM `$events_table`\n" ."LEFT JOIN `$occurrences_table` USING (`eid`)\n" ."LEFT JOIN `$users_table` ON `uid` = `owner`\n" ."LEFT JOIN `$cats_table` USING (`catid`)\n" ."WHERE `oid` = '$oid'\n"; $sth = $this->dbh->query($query) or $this->db_error(__('Error in get_event_by_oid'), $query); $result = $sth->fetch_assoc() or soft_error(__("Event doesn't exist with oid") . ": $oid"); return $result; } // returns the category that corresponds to $catid function get_category($catid) { $cats_table = SQL_PREFIX . 'categories'; $groups_table = SQL_PREFIX . 'groups'; $query = "SELECT `$cats_table`.`name` AS `name`, `text_color`, " ."`bg_color`, `$cats_table`.`cid` AS `cid`, " ."`$cats_table`.`gid`, `catid`, " ."`$groups_table`.`name` AS `group_name`\n" ."FROM `$cats_table`\n" ."LEFT JOIN `$groups_table` USING (`gid`)\n" ."WHERE `catid` = $catid"; $sth = $this->dbh->query($query) or $this->db_error(__('Error in get_category'), $query); $result = $sth->fetch_assoc() or soft_error(__("Category doesn't exist with catid") . ": $catid"); return $result; } function get_group($gid) { $groups_table = SQL_PREFIX . 'groups'; $query = "SELECT `name`, `gid`, `cid`\n" ."FROM `$groups_table`\n" ."WHERE `gid` = $gid"; $sth = $this->dbh->query($query) or $this->db_error(__('Error in get_group'), $query); $result = $sth->fetch_assoc() or soft_error(__("Group doesn't exist with gid") . ": $gid"); return $result; } function get_groups($cid = false) { $groups_table = SQL_PREFIX . 'groups'; $query = "SELECT `gid`, `name`, `cid`\n" ."FROM `$groups_table`\n"; if($cid !== false) $query .= "WHERE `cid` = $cid"; $sth = $this->dbh->query($query) or $this->db_error(__('Error in get_groups'), $query); $groups = array(); while($row = $sth->fetch_assoc()) { $groups[] = $row; } return $groups; } function get_user_groups($uid) { $groups_table = SQL_PREFIX . 'groups'; $user_groups_table = SQL_PREFIX . 'user_groups'; $query = "SELECT `gid`, `cid`, `name`\n" ."FROM `$groups_table`\n" ."INNER JOIN `$user_groups_table` USING (`gid`)\n" ."WHERE `uid` = $uid"; $sth = $this->dbh->query($query) or $this->db_error(__('Error in get_user_groups'), $query); $groups = array(); while($row = $sth->fetch_assoc()) { $groups[] = $row; } return $groups; } // returns the categories for calendar $cid function get_categories($cid = false) { $cats_table = SQL_PREFIX . 'categories'; $groups_table = SQL_PREFIX . 'groups'; if($cid) $where = "WHERE `$cats_table`.`cid` = '$cid'\n"; else $where = "WHERE