function listCalendar($day, $type)
{
$phpTime = js2PhpTime($day);
// echo $phpTime . "+" . $type;
switch ($type) {
case "month":
$st = mktime(0, 0, 0, date("m", $phpTime), 1, date("Y", $phpTime));
$et = mktime(0, 0, -1, date("m", $phpTime) + 1, 1, date("Y", $phpTime));
$cnt = 50;
break;
case "week":
// suppose first day of a week is monday
$monday = date("d", $phpTime) - date('N', $phpTime) + 1;
// echo date('N', $phpTime);
$st = mktime(0, 0, 0, date("m", $phpTime), $monday, date("Y", $phpTime));
$et = mktime(0, 0, -1, date("m", $phpTime), $monday + 7, date("Y", $phpTime));
$cnt = 20;
break;
case "day":
$st = mktime(0, 0, 0, date("m", $phpTime), date("d", $phpTime), date("Y", $phpTime));
$et = mktime(0, 0, -1, date("m", $phpTime), date("d", $phpTime) + 1, date("Y", $phpTime));
$cnt = 5;
break;
}
// echo $st . "--" . $et;
return listCalendarByRange($st, $et, $cnt);
}
function updateDetailedCalendar($id, $st, $et, $sub, $ade, $dscr, $loc, $color, $tz)
{
$ret = array();
try {
$db = new DBConnection();
$db->getConnection();
$sql = "update `jqcalendar` set" . " `starttime`='" . php2MySqlTime(js2PhpTime($st)) . "', " . " `endtime`='" . php2MySqlTime(js2PhpTime($et)) . "', " . " `subject`='" . mysql_real_escape_string($sub) . "', " . " `isalldayevent`='" . mysql_real_escape_string($ade) . "', " . " `description`='" . mysql_real_escape_string($dscr) . "', " . " `location`='" . mysql_real_escape_string($loc) . "', " . " `color`='" . mysql_real_escape_string($color) . "' " . "where `id`=" . $id;
//echo $sql;
if (mysql_query($sql) == false) {
$ret['IsSuccess'] = false;
$ret['Msg'] = mysql_error();
} else {
$ret['IsSuccess'] = true;
$ret['Msg'] = 'Succefully';
}
} catch (Exception $e) {
$ret['IsSuccess'] = false;
$ret['Msg'] = $e->getMessage();
}
return $ret;
}
function updateDetailedCalendar($id, $st, $et, $sub, $ade, $dscr, $loc, $color, $tz, $id_sekolah, $id_kelas, $id_mengajar)
{
$ret = array();
try {
$db = new DBConnection();
$db->getConnection();
$qnamapelajaran = mysql_query('SELECT ap.nama, apg.nama as nama_pegawai FROM ak_pelajaran ap JOIN ak_mengajar am JOIN ak_pegawai apg ON ap.id=am.id_pelajaran AND am.id_pegawai=apg.id WHERE am.id=' . $id_mengajar . '');
$namamapel = mysql_fetch_array($qnamapelajaran);
$namsubject = "" . $namamapel['nama'] . " (" . $namamapel['nama_pegawai'] . ")";
$sql = "update `ak_jadwal` set" . " `id_sekolah`='" . $id_sekolah . "', " . " `id_kelas`='" . $id_kelas . "', " . " `id_mengajar`='" . $id_mengajar . "', " . " `starttime`='" . php2MySqlTime(js2PhpTime($st)) . "', " . " `endtime`='" . php2MySqlTime(js2PhpTime($et)) . "', " . " `subject`='" . mysql_real_escape_string($namsubject) . "', " . " `isalldayevent`='" . mysql_real_escape_string($ade) . "', " . " `description`='" . mysql_real_escape_string($dscr) . "', " . " `location`='" . mysql_real_escape_string($loc) . "', " . " `color`='" . mysql_real_escape_string($color) . "' " . "where `id`=" . $id;
//echo $sql;die();
if (mysql_query($sql) == false) {
$ret['IsSuccess'] = false;
$ret['Msg'] = mysql_error();
} else {
$ret['IsSuccess'] = true;
$ret['Msg'] = 'Succefully';
}
} catch (Exception $e) {
$ret['IsSuccess'] = false;
$ret['Msg'] = $e->getMessage();
}
return $ret;
}
* IP Address: 67.79.165.254
*/
$calendar_id = isset($_GET['calendar_id']) ? (int) $_GET['calendar_id'] : 0;
$calendar = module_calendar::get_calendar($calendar_id);
if (!$calendar_id || !isset($calendar['calendar_id']) || $calendar['calendar_id'] != $calendar_id) {
$calendar_id = $calendar['calendar_id'] = 0;
if (isset($_REQUEST['customer_id']) && $_REQUEST['customer_id']) {
$calendar['customer_id'] = (int) $_REQUEST['customer_id'];
}
// if the user only has access to a single customer, add that customer id in here by default.
if (isset($_POST['start_date_time']) && $_POST['start_date_time']) {
$start_time = js2PhpTime($_POST['start_date_time']);
$calendar['start'] = $start_time;
}
if (isset($_POST['end_date_time']) && $_POST['end_date_time']) {
$end_time = js2PhpTime($_POST['end_date_time']);
$calendar['end'] = $end_time;
}
if (isset($_POST['is_all_day']) && $_POST['is_all_day']) {
$calendar['is_all_day'] = $_POST['is_all_day'];
}
if (isset($_POST['title']) && $_POST['title']) {
$calendar['subject'] = $_POST['title'];
}
}
if ($calendar_id && module_calendar::can_i('edit', 'Calendar') || !$calendar_id && module_calendar::can_i('create', 'Calendar')) {
// perms are good to go!
} else {
die('Permission denied');
}
?>
function updateCalendar($id, $st, $et)
{
$ret = array();
try {
$calendar_id = update_insert('calendar_id', $id, 'calendar', array('start' => js2PhpTime($st), 'end' => js2PhpTime($et)));
if ($calendar_id) {
$ret['IsSuccess'] = true;
$ret['Msg'] = _l('Change success');
$ret['Data'] = $calendar_id;
} else {
$ret['IsSuccess'] = false;
$ret['Msg'] = _l('Change failed');
}
} catch (Exception $e) {
$ret['IsSuccess'] = false;
$ret['Msg'] = $e->getMessage();
}
return $ret;
}
function updateDetailedCalendar($id, $st, $et, $sub, $ade, $dscr, $loc, $color, $tz)
{
$ret = array();
try {
$event = Events::model()->findByPk($id);
$event->title = mysql_real_escape_string($sub);
$event->starttime = php2MySqlTime(js2PhpTime($st));
$event->endtime = php2MySqlTime(js2PhpTime($et));
$event->isalldayevent = mysql_real_escape_string($ade);
$event->description = mysql_real_escape_string($dscr);
$event->location = mysql_real_escape_string($loc);
$event->color = mysql_real_escape_string($color);
if ($event->save() == false) {
$ret['IsSuccess'] = false;
$ret['Msg'] = $event->error();
} else {
$ret['IsSuccess'] = true;
$ret['Msg'] = 'Succefully';
}
} catch (Exception $e) {
$ret['IsSuccess'] = false;
$ret['Msg'] = $e->getMessage();
}
return $ret;
}
*
**/
defined('_JEXEC') or die('Restricted access');
require_once JPATH_COMPONENT . '/DC_MultiViewCal/php/functions.php';
require_once JPATH_BASE . '/components/com_multicalendar/DC_MultiViewCal/php/list.inc.php';
$db =& JFactory::getDBO();
header('Content-type:text/javascript;charset=UTF-8');
$method = JRequest::getVar('method');
$calid = JRequest::getVar('calid');
switch ($method) {
case "add":
$ret = addCalendar($calid, JRequest::getVar("CalendarStartTime"), JRequest::getVar("CalendarEndTime"), JRequest::getVar("CalendarTitle"), JRequest::getVar("IsAllDayEvent"), JRequest::getVar("location"));
break;
case "list":
$d1 = js2PhpTime(JRequest::getVar("startdate"));
$d2 = js2PhpTime(JRequest::getVar("enddate"));
$d1 = mktime(0, 0, 0, date("m", $d1), date("d", $d1), date("Y", $d1));
$d2 = mktime(0, 0, 0, date("m", $d2), date("d", $d2), date("Y", $d2)) + 24 * 60 * 60 - 1;
$ret = listCalendarByRange($calid, $d1, $d2);
break;
case "update":
$ret = updateCalendar(JRequest::getVar("calendarId"), JRequest::getVar("CalendarStartTime"), JRequest::getVar("CalendarEndTime"));
break;
case "remove":
$ret = removeCalendar(JRequest::getVar("calendarId"), JRequest::getVar("rruleType"));
break;
case "adddetails":
$st = JRequest::getVar("stpartdatelast") . " " . JRequest::getVar("stparttimelast");
$et = JRequest::getVar("etpartdatelast") . " " . JRequest::getVar("etparttimelast");
if (JRequest::getVar("id") != "") {
$ret = updateDetailedCalendar(JRequest::getVar("id"), $st, $et, JRequest::getVar("Subject"), JRequest::getVar("IsAllDayEvent") == 1 ? 1 : 0, JRequest::getVar('Description', null, 'default', 'none', JREQUEST_ALLOWHTML), JRequest::getVar("Location"), JRequest::getVar("colorvalue"), JRequest::getVar("rrule"), JRequest::getVar("rruleType"), JRequest::getVar("timezone"));
