<?php
 
 /**
 * @package Spider Calendar
 * @author Web-Dorado
 * @copyright (C) 2011 Web-Dorado. All rights reserved.
 * @license GNU/GPLv3 http://www.gnu.org/licenses/gpl-3.0.html
 **/
defined( '_JEXEC' ) or die( 'Restricted access' );
require_once( JApplicationHelper::getPath( 'admin_html' ) );
JTable::addIncludePath(JPATH_ADMINISTRATOR.DS.'components'.DS.
'com_spidercalendar'.DS.'tables');

 $task	= JRequest::getCmd('task'); 
 $id = JRequest::getVar('id', 0, 'get', 'int');
switch($task){
	case 'add_event':
		addNote();
		break;
		
	case 'cancel_event';		
		cancelNote();
		break;
	
	case 'apply_event':	
	case 'save_event';		
		saveNote();
		break;
	
		
	case 'edit_event':
    	editNote();
    	break;
		
	case 'event':
		showNote(JRequest::getVar('calendar', 0, '', 'int'));
	break;
		
	case 'event_save_show':
		showNote(save_before_show());
	break;
	
	
		// This will work when you set task to 'remove
  	case 'remove_event':
   	 	removeNote();
  		break;
				
   case 'publish_event':
    	changeNote(1);
   		break;

   case 'unpublish_event':
    	changeNote(0);
    	break;				

////////////////CALENDAR////////////////////////////////////
	case 'add_calendar':
	case 'edit_calendar';
		edit_calendar();
		break;
	
	case 'save_calendar':
	case 'apply_calendar';
		save_calendar();
		break;
		
	case 'remove_calendar':
   	 	remove_calendar();
		remove_calendar_events();
  		break;
		
 	case 'publish_calendar':
   		change_calendar(1);
    	break;	 
			
	case 'unpublish_calendar':
	   	change_calendar(0);
	    break;	
	
////////////THEME////////////////
case 'add_theme':
case 'edit_theme';
		edit_theme();
		break;
case 'theme':
		show_theme();
		break;		

	case 'save_theme':
	case 'apply_theme';
		save_theme();
		break;	
	
	case 'cancel_theme';		
		cancel_theme();
		break;
	
	
	case 'remove_theme':
   	 	removeTheme();
  		break;
		
	case 'preview_theme':
   	    preview_theme();
  		break;
	
	case 'license':
	 license();
	 break;
	
	
	case 'plugin':
   	    plugin();
  		break;
	default:
		show_calendar();
		JSubMenuHelper::addEntry(JText::_('Calendar'), 'index.php?option=com_spidercalendar&task=calendar', true);
		JSubMenuHelper::addEntry(JText::_('Themes'), 'index.php?option=com_spidercalendar&task=theme' );
		JSubMenuHelper::addEntry(JText::_('Plugin Code Generator'), 'index.php?option=com_spidercalendar&task=plugin');
		JSubMenuHelper::addEntry(JText::_('Licensing'), 'index.php?option=com_spidercalendar&task=license' );
		break;

		
}
	if($task=='theme'){
	JSubMenuHelper::addEntry(JText::_('Calendar'), 'index.php?option=com_spidercalendar&task=calendar');
	JSubMenuHelper::addEntry(JText::_('Themes'), 'index.php?option=com_spidercalendar&task=theme', true );
	JSubMenuHelper::addEntry(JText::_('Plugin Code Generator'), 'index.php?option=com_spidercalendar&task=plugin');
	JSubMenuHelper::addEntry(JText::_('Licensing'), 'index.php?option=com_spidercalendar&task=license' );
	}
	
	if($task=='license'){
	JSubMenuHelper::addEntry(JText::_('Calendar'), 'index.php?option=com_spidercalendar&task=calendar');
	JSubMenuHelper::addEntry(JText::_('Themes'), 'index.php?option=com_spidercalendar&task=theme' );
	JSubMenuHelper::addEntry(JText::_('Plugin Code Generator'), 'index.php?option=com_spidercalendar&task=plugin');
	JSubMenuHelper::addEntry(JText::_('Licensing'), 'index.php?option=com_spidercalendar&task=license',true );
	}
	
	if($task=='plugin'){
	JSubMenuHelper::addEntry(JText::_('Calendar'), 'index.php?option=com_spidercalendar&task=calendar');
	JSubMenuHelper::addEntry(JText::_('Themes'), 'index.php?option=com_spidercalendar&task=theme');
	JSubMenuHelper::addEntry(JText::_('Plugin Code Generator'), 'index.php?option=com_spidercalendar&task=plugin', true );
	JSubMenuHelper::addEntry(JText::_('Licensing'), 'index.php?option=com_spidercalendar&task=license' );
	

	}	

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////// T H E M E ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

function plugin()

{
	$db		=& JFactory::getDBO();

	
	
	
	$query = "SELECT id,title FROM #__spidercalendar_calendar";
	$db->setQuery($query);
	$calendars = $db->loadObjectList();


	HTML_contact::plugin($calendars);

}



function show_theme(){
	$option	= JRequest::getVar('option'); 
	global $mainframe;
    $db =& JFactory::getDBO();
	$filter_order= $mainframe-> getUserStateFromRequest( $option.'filter_order_theme', 'filter_order_theme','id','cmd' );
	//$filter_order='id';
	$filter_order_Dir= $mainframe-> getUserStateFromRequest( $option.'filter_order_Dir_theme', 'filter_order_Dir_theme','desc','word' );
	$search_theme = $mainframe-> getUserStateFromRequest( $option.'search_theme', 'search_theme','','string' );
	$search_theme = JString::strtolower( $search_theme );
	$limit= $mainframe-> getUserStateFromRequest('global.list.limit', 'limit', $mainframe->getCfg('list_limit'), 'int');
	$limitstart= $mainframe-> getUserStateFromRequest($option.'.limitstart', 'limitstart', 0, 'int');
	$where = array();
	
	if ( $search_theme ) {
		$where[] = 'title LIKE "%'.$db->getEscaped($search_theme).'%"';
	}	
	
	$where 		= ( count( $where ) ? ' WHERE ' . implode( ' AND ', $where ) : '' );
	if ($filter_order == 'id'){
		$orderby 	= ' ORDER BY id '.$filter_order_Dir;
	} else {
		$orderby 	= ' ORDER BY '. 
         $filter_order .' '. $filter_order_Dir .', id';
	}	
	
	
	// get the total number of records
	$query = "SELECT COUNT(*) FROM #__spidercalendar_theme". $where;

	$db->setQuery( $query );
	$total = $db->loadResult();
	jimport('joomla.html.pagination');
	$pageNav = new JPagination( $total, $limitstart, $limit );	
	
	$query = "SELECT * FROM #__spidercalendar_theme". $where. $orderby;
	$db->setQuery( $query, $pageNav->limitstart, $pageNav->limit );
	$rows = $db->loadObjectList();
	if($db->getErrorNum()){
		echo $db->stderr();
		return false;
	}
	
	// table ordering
	$lists['order_Dir']	= $filter_order_Dir;
	$lists['order']		= $filter_order;
		
	// search_calendar filter	
        $lists['search_theme']= $search_theme;	
	
    // display function
	
	
	
	HTML_contact::show_theme($rows, $pageNav, $lists);
}


function license()

{

?>
<p style="font-size: 13px;">This component is the non-commercial version of the Spider Event Calendar. Use of the calendar is free.
The only limitation is the use of the themes. If you want to use one of the 11 standard themes or create a new one that satisfies the needs of your web site, you are required to purchase a license.
Purchasing a license will add 11 standard themes and give possibility to edit the themes of the Spider Event Calendar.</p>


<a href="http://web-dorado.com/products/joomla-calendar.html" target="_blank" > 

<input style="width: 120px;height: 29px;"  type="button" value="Purchase a License">
</a>
<?php


}








function edit_theme(){	
	$db		=& JFactory::getDBO();
	$cid 	= JRequest::getVar('cid', array(0), '', 'array');
	JArrayHelper::toInteger($cid, array(0));

	$id 	= $cid[0];
	$row =& JTable::getInstance('spidercalendar_theme', 'Table');
	// load the row from the db table
	$row->load( $id);
$lists = array();


	 //title_font Select List
  $title_font = array(''=>'- Select Font -','Arial'=>'Arial','Courier New'=>'Courier New','Georgia'=>'Georgia','Tahoma'=>'Tahoma','Verdana'=>'Verdana','Impact'=>'Impact');
  $title_fontOptions = array();
  foreach($title_font as $key=>$value) 
    	$title_fontOptions[] = JHTML::_('select.option',$key, $value);
 //end
  
  
  //title_style Select List
  $title_style = array('normal'=>'Normal','bold'=>'Bold','italic'=>'Italic','bold/italic'=>'Bold and Italic');
  $title_styleOptions = array();
  foreach($title_style as $key=>$value) 
    	$title_styleOptions[] = JHTML::_('select.option',$key, $value);
 //end
 
 
 
 
 
 //date_font Select List
  $date_font = array(''=>'- Select Font -','Arial'=>'Arial','Courier New'=>'Courier New','Georgia'=>'Georgia','Tahoma'=>'Tahoma','Verdana'=>'Verdana','Impact'=>'Impact');
  $date_fontOptions = array();
  foreach($date_font as $key=>$value) 
    	$date_fontOptions[] = JHTML::_('select.option',$key, $value);
 //end
  
  
  //date_style Select List
  $date_style = array('normal'=>'Normal','bold'=>'Bold','italic'=>'Italic','bold/italic'=>'Bold and Italic');
  $date_styleOptions = array();
  foreach($date_style as $key=>$value) 
    	$date_styleOptions[] = JHTML::_('select.option',$key, $value);
 //end

 //week_start_day Select List
  $week_start_day = array('mo'=>'Monday','su'=>'Sunday');
  $week_start_dayOptions = array();
  foreach($week_start_day as $key=>$value) 
    	$week_start_dayOptions[] = JHTML::_('select.option',$key, $value);
 //end
 
 //month_type Select List
  $month_type = array(1=>'Previous,current,next',2=>'Current');
  $month_typeOptions = array();
  foreach($month_type as $key=>$value) 
    	$month_typeOptions[] = JHTML::_('select.option',$key, $value);
 //end
 
	
	if($row->show_time!='')
	$lists['show_time'] = JHTML::_('select.booleanlist', 'show_time' , 'class="inputbox"',$row->show_time  );
	else
	$lists['show_time'] = JHTML::_('select.booleanlist', 'show_time' , 'class="inputbox"',1  );
	
	if($row->show_repeat!='')
	$lists['show_repeat'] = JHTML::_('select.booleanlist', 'show_repeat' , 'class="inputbox"',$row->show_repeat  );
	else
	$lists['show_repeat'] = JHTML::_('select.booleanlist', 'show_repeat' , 'class="inputbox"',1  );

	$lists['title_style'] = JHTML::_('select.genericlist', $title_styleOptions, 'title_style', 'class="inputbox"', 'value', 'text', $row->title_style);
	$lists['title_font'] = JHTML::_('select.genericlist', $title_fontOptions, 'title_font', 'class="inputbox"', 'value', 'text', $row->title_font);
	
	$lists['week_start_day'] = JHTML::_('select.genericlist', $week_start_dayOptions, 'week_start_day', 'class="inputbox"', 'value', 'text', $row->week_start_day);

	$lists['date_style'] = JHTML::_('select.genericlist', $date_styleOptions, 'date_style', 'class="inputbox"', 'value', 'text', $row->date_style);
	$lists['date_font'] = JHTML::_('select.genericlist', $date_fontOptions, 'date_font', 'class="inputbox"', 'value', 'text', $row->date_font);
	
	$lists['month_type'] = JHTML::_('select.genericlist', $month_typeOptions, 'month_type', 'class="inputbox"', 'value', 'text', $row->month_type);

	// display function 
	HTML_contact::edit_theme($row,$lists);
}

function save_theme(){
	global $mainframe;
	$row =& JTable::getInstance('spidercalendar_theme', 'Table');
	

	if(!$row->bind(JRequest::get('post')))
	{
		JError::raiseError(500, $row->getError() );
	}
	$task		= JRequest::getCmd( 'task' );
	


	
	if(!$row->store()){
		JError::raiseError(500, $row->getError() );
	}
	
	switch ($task)
		{
			case 'apply_theme' :
				$msg = JText::sprintf('Changes to calendar saved');
				$mainframe->redirect('index.php?option=com_spidercalendar&task=edit_theme&cid[]='.$row->id, $msg);
				break;

			case 'save_theme' :
			
				$msg = JText::sprintf('calendar Saved');
				$mainframe->redirect('index.php?option=com_spidercalendar&task=theme', $msg);
				break;
			
		}
	
	
	
	$mainframe->redirect($link, $msg);
}

function cancel_theme(){
  global $mainframe;
  $mainframe->redirect( 'index.php?option=com_spidercalendar&task=theme' );
}

function removeTheme()
{

  global $mainframe;
  // Initialize variables	
  $db =& JFactory::getDBO();
  // Define cid array variable
  $cid = JRequest::getVar( 'cid' , array() , '' , 'array' );
  // Make sure cid array variable content integer format
  JArrayHelper::toInteger($cid);

  // If any item selected
  if (count( $cid )) {
    // Prepare sql statement, if cid array more than one, 
    // will be "cid1, cid2, ..."
    $cids = implode( ',', $cid );
    // Create sql statement
    $query = 'DELETE FROM #__spidercalendar_theme'
    . ' WHERE id IN ( '. $cids .' )'
    ;
    // Execute query
    $db->setQuery( $query );
    if (!$db->query()) {
      echo "<script> alert('".$db->getErrorMsg(true)."'); 
      window.history.go(-1); </script>\n";
    }
  }

  // After all, redirect again to frontpage
  $mainframe->redirect( "index.php?option=com_spidercalendar&task=theme");
}

function  preview_theme()
{

HTML_contact::preview_theme();

}

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////// E V E N T ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

function back(){
	global $mainframe;
	$link = 'index.php?option=com_spidercalendar';
	$mainframe->redirect($link);

}


function save_before_show(){
    $db =& JFactory::getDBO();

	$row =& JTable::getInstance('spidercalendar_calendar', 'Table');
	if(!$row->bind(JRequest::get('post')))
	{
		JError::raiseError(500, $row->getError() );
	}
	if(!$row->store()){
		JError::raiseError(500, $row->getError() );
	}
	return $row->id;
	
}



function saveNote(){
	global $mainframe;
	$date=JRequest::getVar( 'date');
	$date_end=JRequest::getVar( 'date_end');
	$row =& JTable::getInstance('spidercalendar_event', 'Table');
	$task=JRequest::getCmd('task');
	$db =& JFactory::getDBO();
	$query = "SELECT * from #__spidercalendar_event where date=".$db->getEscaped($date)." and id<>".$db->getEscaped(JRequest::getVar( 'id'));
	$db->setQuery( $query );
	$total = $db->loadResult();
	if(count($total)>0)
		$mainframe->redirect('index.php?option=com_spidercalendar&task=event', 'This record already exists');
	
	if(!$row->bind(JRequest::get('post')))
	{
		JError::raiseError(500, $row->getError() );
	}
	
	
	$row->date =$date;
	$row->date_end =JRequest::getVar( 'date_end');
	if(JRequest::getVar( 'selhour_from'))
	{
	if(JRequest::getVar( 'selhour_to'))
		$row->time = JRequest::getVar( 'selhour_from').':'.JRequest::getVar( 'selminute_from').' - '.JRequest::getVar( 'selhour_to').':'.JRequest::getVar( 'selminute_to');
	else
		$row->time = JRequest::getVar( 'selhour_from').':'.JRequest::getVar( 'selminute_from');
	}
	else
	$row->time ="";
	
	$row->text_for_date = JRequest::getVar( 'text_for_date', '','post', 'string', JREQUEST_ALLOWRAW );
	$row->title = JRequest::getVar( 'title', '','post', 'string', JREQUEST_ALLOWRAW );
	
	
	
	if(!$row->store()){
		JError::raiseError(500, $row->getError() );
	}
	
	
	switch ($task)
	{
		case 'apply_event':
			$msg ='Changes to event saved';		
			$link ='index.php?option=com_spidercalendar&task=edit_event&cid[]='.$row->id;
			break;
		
		case 'save_event':
		default:
			$msg = 'event Saved';
			$link = 'index.php?option=com_spidercalendar&task=event&calendar='.$row->calendar;
			break;
	}	
	
	$mainframe->redirect($link, $msg);	
	
}

function addNote(){
	
	 $db =& JFactory::getDBO();
	
	$calendar=JRequest::getVar('calendar', 0, '', 'int');
	$query = 'SELECT title'.' FROM #__spidercalendar_calendar WHERE id='. $db->getEscaped($calendar)	;
	$db->setQuery( $query );
	$calendar_name = $db->loadResult();

	$lists['calendar'] = $calendar;
	$lists['calendar_name'] = $calendar_name;
	
	$lists['published'] = JHTML::_('select.booleanlist', 'published' , 'class="inputbox"', 1 );
	
	 //monthly_list Select List
  $monthly_list = array(1=>'First',8=>'Second',15=>'Third',22=>'Fourth','last'=>'Last');
  $monthly_listOptions = array();
  foreach($monthly_list as $key=>$value) 
    	$monthly_listOptions[] = JHTML::_('select.option',$key, $value);
 //end
 
 //month_week Select List
  $month_week = array('Mon'=>'Monday','Tue'=>'Tuesday','Wed'=>'Wednesday','Thu'=>'Thursday','Fri'=>'Friday','Sat'=>'Saturday','Sun'=>'Sunday');
  $month_weekOptions = array();
  foreach($month_week as $key=>$value) 
    	$month_weekOptions[] = JHTML::_('select.option',$key, $value);
 //end
 
 //year_month Select List
  $year_month = array(1=>'January',2=>'February',3=>'March',4=>'April',5=>'May',6=>'June',7=>'July',8=>'August',9=>'September',10=>'October',11=>'November',12=>'December');
  $year_monthOptions = array();
  foreach($year_month as $key=>$value) 
    	$year_monthOptions[] = JHTML::_('select.option',$key, $value);
 //end
	
	
	$lists['monthly_list'] = JHTML::_('select.genericlist', $monthly_listOptions, 'monthly_list', 'class="inputbox"', 'value', 'text');
	$lists['month_week'] = JHTML::_('select.genericlist', $month_weekOptions, 'month_week', 'class="inputbox"', 'value', 'text');
	$lists['year_month'] = JHTML::_('select.genericlist', $year_monthOptions, 'year_month', 'class="inputbox"', 'value', 'text');



// display function
	HTML_contact::addNote($lists);
}

function showNote($calendar){
	$option= JRequest::getVar( 'option');
	global $mainframe;
	
    $db =& JFactory::getDBO();
	
	$query = 'SELECT title'.' FROM #__spidercalendar_calendar WHERE id='. $db->getEscaped($calendar)	;
	$db->setQuery( $query );
	$calendar_name = $db->loadResult();

	// get calendar id ↑
	
	$filter_order= $mainframe->getUserStateFromRequest( $option.'filter_order','filter_order','id','cmd' );
	$filter_order_Dir= $mainframe->getUserStateFromRequest( $option.'filter_order_Dir',	'filter_order_Dir','','word' );
	$filter_state = $mainframe->getUserStateFromRequest( $option.'filter_state', 	'filter_state', '','word' );
	
	
	$search = $mainframe->getUserStateFromRequest( $option.'search','search','','string' );
	$search = JString::strtolower( $search );
	$limit= $mainframe-> getUserStateFromRequest('global.list.limit',  'limit', $mainframe->getCfg('list_limit'), 'int');
	$limitstart= $mainframe-> getUserStateFromRequest($option.'.limitstart', 'limitstart', 0, 'int');
	
	$lists = array();
	$where = array();
$lists['search']= $mainframe->getUserStateFromRequest( $option.'search','search','','string' );
$lists['search']= JString::strtolower($lists['search']);
$lists['startdate']= JRequest::getVar('startdate', "");
$lists['enddate']= JRequest::getVar('enddate', "");
if ( $lists['search'] ) {
		$where[] = ' title LIKE "%'.$db->getEscaped($search).'%"';
	}	
 if($lists['startdate']!='')
$where[] ="  `date`>='".$db->getEscaped($lists['startdate'])."' ";
  if($lists['enddate']!='')
$where[] ="  `date`<='".$db->getEscaped($lists['enddate'])."' ";

$filter='';
$filter=( count( $where ) ? 'WHERE' . implode( ' AND ', $where ) : '' );
if(count( $where )==0)
{
$filter.=' WHERE calendar='.$db->getEscaped($calendar);
}
	
	
	if ($filter_order == 'id'){
		$orderby 	= ' ORDER BY id '. $filter_order_Dir;
	} else {
		$orderby 	= ' ORDER BY '. 
         $filter_order .' '. $filter_order_Dir .', id';
	}	
	
	// get the total number of records
	$query = 'SELECT COUNT(*)'
	. ' FROM #__spidercalendar_event '
	. $filter
	;
	$db->setQuery( $query );
	$total = $db->loadResult();

	jimport('joomla.html.pagination');
	$pageNav = new JPagination( $total, $limitstart, $limit );	
	
	
	$query = "SELECT * FROM #__spidercalendar_event    $filter $orderby ";
	$db->setQuery( $query, $pageNav->limitstart, $pageNav->limit );
	$rows = $db->loadObjectList();
	if($db->getErrorNum()){
		echo $db->stderr();
		return false;
	}
	
	// table ordering
	$lists['order_Dir']	= $filter_order_Dir;
	$lists['order']		= $filter_order;	

	// search filter	
        $lists['search']= $search;	
		$lists['calendar']= $calendar;	
		$lists['calendar_name']= $calendar_name;
    // display function
	
	
	
	

	
	HTML_contact::showNote($rows, $pageNav, $lists,$option);
}

//edit note

function editNote()
{
	$db		=& JFactory::getDBO();

	$cid 	= JRequest::getVar('cid', array(0), '', 'array');
	JArrayHelper::toInteger($cid, array(0));
	
	$id 	= $cid[0];

	$row =& JTable::getInstance('spidercalendar_event', 'Table');
	// load the row from the db table

	$row->load( $id);

	
	
	$calendar=$row->calendar;
	$query = 'SELECT title'.' FROM #__spidercalendar_calendar WHERE id='. $db->getEscaped($calendar)	;
	$db->setQuery( $query );
	$calendar_name = $db->loadResult();
	
	
	$lists = array();
	$lists['calendar'] = $calendar;
	$lists['calendar_name'] = $calendar_name;
	$lists['published'] = JHTML::_('select.booleanlist', 'published' , 'class="inputbox"', $row->published);
	
	 //monthly_list Select List
  $monthly_list = array(1=>'First',8=>'Second',15=>'Third',22=>'Fourth','last'=>'Last');
  $monthly_listOptions = array();
  foreach($monthly_list as $key=>$value) 
    	$monthly_listOptions[] = JHTML::_('select.option',$key, $value);
 //end
 
 //month_week Select List
  $month_week = array('Mon'=>'Monday','Tue'=>'Tuesday','Wed'=>'Wednesday','Thu'=>'Thursday','Fri'=>'Friday','Sat'=>'Saturday','Sun'=>'Sunday');
  $month_weekOptions = array();
  foreach($month_week as $key=>$value) 
    	$month_weekOptions[] = JHTML::_('select.option',$key, $value);
 //end
 
 //year_month Select List
  $year_month = array(1=>'January',2=>'February',3=>'March',4=>'April',5=>'May',6=>'June',7=>'July',8=>'August',9=>'September',10=>'October',11=>'November',12=>'December');
  $year_monthOptions = array();
  foreach($year_month as $key=>$value) 
    	$year_monthOptions[] = JHTML::_('select.option',$key, $value);
 //end
	
	
	$lists['monthly_list'] = JHTML::_('select.genericlist', $monthly_listOptions, 'monthly_list', 'class="inputbox"', 'value', 'text', $row->monthly_list);
	$lists['month_week'] = JHTML::_('select.genericlist', $month_weekOptions, 'month_week', 'class="inputbox"', 'value', 'text', $row->month_week);
	$lists['year_month'] = JHTML::_('select.genericlist', $year_monthOptions, 'year_month', 'class="inputbox"', 'value', 'text', $row->year_month);

	// display function 
	HTML_contact::editNote($lists, $row);
}

function removeNote()
{

  global $mainframe;
  // Initialize variables	
  $db =& JFactory::getDBO();
  // Define cid array variable
  $cid = JRequest::getVar( 'cid' , array() , '' , 'array' );
  // Make sure cid array variable content integer format
  JArrayHelper::toInteger($cid);

  // If any item selected
  if (count( $cid )) {
    // Prepare sql statement, if cid array more than one, 
    // will be "cid1, cid2, ..."
    $cids = implode( ',', $cid );
    // Create sql statement
    $query = 'DELETE FROM #__spidercalendar_event'
    . ' WHERE id IN ( '. $cids .' )'
    ;
    // Execute query
    $db->setQuery( $query );
    if (!$db->query()) {
      echo "<script> alert('".$db->getErrorMsg(true)."'); 
      window.history.go(-1); </script>\n";
    }
  }

  // After all, redirect again to frontpage
  $mainframe->redirect( "index.php?option=com_spidercalendar&task=event&calendar=".JRequest::getVar('calendar') );
}

function changeNote( $state=0 )
{
  global $mainframe;

  // Initialize variables
  $db 	=& JFactory::getDBO();

  // define variable $cid from GET
  $cid = JRequest::getVar( 'cid' , array() , '' , 'array' );	
  JArrayHelper::toInteger($cid);

  // Check there is/are item that will be changed. 
  //If not, show the error.
  if (count( $cid ) < 1) {
    $action = $state ? 'publish' : 'unpublish';
    JError::raiseError(500, JText::_( 'Select an item 
    to' .$action, true ) );
  }

  // Prepare sql statement, if cid more than one, 
  // it will be "cid1, cid2, cid3, ..."
  $cids = implode( ',', $cid );

  $query = 'UPDATE #__spidercalendar_event'
  . ' SET published = ' . (int) $state
  . ' WHERE id IN ( '. $cids .' )'
  ;
  // Execute query
  $db->setQuery( $query );
  if (!$db->query()) {
    JError::raiseError(500, $db->getErrorMsg() );
  }

  if (count( $cid ) == 1) {
    $row =& JTable::getInstance('spidercalendar_event', 'Table');
    $row->checkin( intval( $cid[0] ) );
  }

  // After all, redirect to front page
  $mainframe->redirect( 'index.php?option=com_spidercalendar&task=event&calendar='.JRequest::getVar('calendar') );
}



function cancelNote()
{
  global $mainframe;
  $mainframe->redirect( 'index.php?option=com_spidercalendar&task=event&calendar='.JRequest::getVar('calendar') );

}

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////// C A L E N D A R ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////



function show_calendar(){
	$option	= JRequest::getVar('option'); 
	global $mainframe;
    $db =& JFactory::getDBO();
	$filter_order= $mainframe-> getUserStateFromRequest( $option.'filter_order_calendar', 'filter_order_calendar','id','cmd' );
	//$filter_order='id';
	$filter_order_Dir= $mainframe-> getUserStateFromRequest( $option.'filter_order_Dir_calendar', 'filter_order_Dir_calendar','desc','word' );
	$search_calendar = $mainframe-> getUserStateFromRequest( $option.'search_calendar', 'search_calendar','','string' );
	$search_calendar = JString::strtolower( $search_calendar );
	$limit= $mainframe-> getUserStateFromRequest('global.list.limit', 'limit', $mainframe->getCfg('list_limit'), 'int');
	$limitstart= $mainframe-> getUserStateFromRequest($option.'.limitstart', 'limitstart', 0, 'int');
	$where = array();
	
	if ( $search_calendar ) {
		$where[] = 'title LIKE "%'.$db->getEscaped($search_calendar).'%"';
	}	
	
	$where 		= ( count( $where ) ? ' WHERE ' . implode( ' AND ', $where ) : '' );
	if ($filter_order == 'id'){
		$orderby 	= ' ORDER BY id '.$filter_order_Dir;
	} else {
		$orderby 	= ' ORDER BY '. 
         $filter_order .' '. $filter_order_Dir .', id';
	}	
	
	
	// get the total number of records
	$query = "SELECT COUNT(*) FROM #__spidercalendar_calendar". $where;

	$db->setQuery( $query );
	$total = $db->loadResult();
	jimport('joomla.html.pagination');
	$pageNav = new JPagination( $total, $limitstart, $limit );	
	
	$query = "SELECT * FROM #__spidercalendar_calendar". $where. $orderby;
	$db->setQuery( $query, $pageNav->limitstart, $pageNav->limit );
	$rows = $db->loadObjectList();
	if($db->getErrorNum()){
		echo $db->stderr();
		return false;
	}
	
	
	// table ordering
	$lists['order_Dir']	= $filter_order_Dir;
	$lists['order']		= $filter_order;
		
	// search_calendar filter	
        $lists['search_calendar']= $search_calendar;	
	
    // display function
	
	
	
	HTML_contact::show_calendar($rows, $pageNav, $lists);
}


function edit_calendar(){	
	$db		=& JFactory::getDBO();
	$cid 	= JRequest::getVar('cid', array(0), '', 'array');
	JArrayHelper::toInteger($cid, array(0));

	$id 	= $cid[0];
	$row =& JTable::getInstance('spidercalendar_calendar', 'Table');
	// load the row from the db table
	$row->load( $id);
	
	$lists = array();
	if($row->published=='')
	$row->published=1;
	$lists['published'] = JHTML::_('select.booleanlist', 'published' , 'class="inputbox"', $row->published);
	
	$lists['allow_publish'] = JHTML::_('select.booleanlist', 'allow_publish' , 'class="inputbox"', $row->allow_publish);
				$lists['time_format'] = JHTML::_('select.booleanlist', 'time_format' , 'class="inputbox"', $row->time_format);

	$user 		=& JUser::getInstance();
	$acl		=& JFactory::getACL();
	
	$gtree = 	$acl->get_group_children_tree( null, 'USERS', false );
	$no_one= new stdClass;
	$no_one->value='200';
	$no_one->text='No One';
	$no_one->disable='';
	
	$gtree=array_reverse($gtree);
	array_push($gtree,$no_one);
	$gtree=array_reverse($gtree);
	$gtree[1]->disable='yes';
	$gtree[6]->disable='yes';
	
	//def_month Select List
  $def_month = array(''=>'Current',1=>'January',2=>'February',3=>'March',4=>'April',5=>'May',6=>'June',7=>'July',8=>'August',9=>'September',10=>'October',11=>'November',12=>'December');
  $def_monthOptions = array();
  foreach($def_month as $key=>$value) 
    	$def_monthOptions[] = JHTML::_('select.option',$key, $value);
 //end
	
	
	$lists['def_month'] = JHTML::_('select.genericlist', $def_monthOptions, 'def_month', 'class="inputbox"', 'value', 'text', $row->def_month);
	
	
	$lists['gid'] 	= JHTML::_('select.genericlist',   $gtree, 'gid', 'class="inputbox"', 'value', 'text', $row->get('gid') );

	// display function 
	HTML_contact::edit_calendar($lists, $row, $themes);
}

function save_calendar(){
	global $mainframe;
	$row =& JTable::getInstance('spidercalendar_calendar', 'Table');
	

	if(!$row->bind(JRequest::get('post')))
	{
		JError::raiseError(500, $row->getError() );
	}
	$task		= JRequest::getCmd( 'task' );
	


	
	if(!$row->store()){
		JError::raiseError(500, $row->getError() );
	}
	
	switch ($task)
		{
			case 'apply_calendar' :
				$msg = JText::sprintf('Changes to calendar saved');
				$mainframe->redirect('index.php?option=com_spidercalendar&task=edit_calendar&cid[]='.$row->id, $msg);
				break;

			case 'save_calendar' :
			
				$msg = JText::sprintf('calendar Saved');
				$mainframe->redirect('index.php?option=com_spidercalendar', $msg);
				break;
			
		}
	
	
	
	$mainframe->redirect($link, $msg);
}

function remove_calendar(){
  global $mainframe;
  // Initialize variables	
  $db =& JFactory::getDBO();
  // Define cid array variable
  $cid = JRequest::getVar( 'cid' , array() , '' , 'array' );
  // Make sure cid array variable content integer format
  JArrayHelper::toInteger($cid);
  
  // If any item selected
  if (count( $cid )) {
    // Prepare sql statement, if cid array more than one, 
    // will be "cid1, cid2, ..."
    $cids = implode( ',', $cid );
    // Create sql statement

    $query = 'DELETE FROM #__spidercalendar_calendar'.' WHERE id IN ( '. $cids .' )';
    // Execute query
    
    // Execute query
    $db->setQuery( $query );
    if (!$db->query()) {
      echo "<script> alert('".$db->getErrorMsg(true)."'); 
      window.history.go(-1); </script>\n";
	  
    }
	
	
	
  }
  // After all, redirect again to frontpage
  $mainframe->redirect( "index.php?option=com_spidercalendar");
}




function change_calendar($state=0){
  global $mainframe;
  // Initialize variables
  $db 	=& JFactory::getDBO();
  // define variable $cid from GET
  $cid = JRequest::getVar( 'cid' , array() , '' , 'array' );	
  JArrayHelper::toInteger($cid);
  // Check there is/are item that will be changed. 
  //If not, show the error.
  if (count( $cid ) < 1) {
    $action = $state ? 'publish_calendar' : 'unpublish_calendar';
    JError::raiseError(500, JText::_( 'Select an item to' .$action, true ) );
  }
  // Prepare sql statement, if cid more than one, 
  // it will be "cid1, cid2, cid3, ..."
  $cids = implode( ',', $cid );
  $query = 'UPDATE #__spidercalendar_calendar' . ' SET published = '.(int) $state .' WHERE id IN ( '. $cids .' )'  ;
  // Execute query
  $db->setQuery( $query );
  if (!$db->query()) {
    JError::raiseError(500, $db->getErrorMsg() );
  }
  if (count( $cid ) == 1) {
    $row =& JTable::getInstance('spidercalendar_calendar', 'Table');
    $row->checkin( intval( $cid[0] ) );
  }
  // After all, redirect to front page
  $mainframe->redirect( 'index.php?option=com_spidercalendar' );
}

function cancel_calendar(){
  global $mainframe;
  $mainframe->redirect( 'index.php?option=com_spidercalendar' );
}





?>