<?php

/*

Copyright (c) 2005-2008, Alex Tingle.

This program is free software; you can redistribute it and/or

modify it under the terms of the GNU General Public License

as published by the Free Software Foundation; either version 2

of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

GNU General Public License for more details.

You should have received a copy of the GNU General Public License

along with this program; if not, write to the Free Software

Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.

*/

class ec3_Admin

{

  function filter_admin_head()

  {

    global $ec3;

    // Turn OFF advanced mode when we're in the admin screens.

    $ec3->advanced=false;

    ?>

    <!-- Added by eventcalendar3/admin.php -->

    <style type='text/css' media='screen'>

    @import url(<?php echo $ec3->myfiles; ?>/admin.css);

    </style>

    <!-- These scripts are only needed by edit_form screens. -->

    <script type='text/javascript' src='<?php echo $ec3->myfiles; ?>/addEvent.js'></script>

    <script type='text/javascript' src='<?php echo $ec3->myfiles; ?>/edit_form.js'></script>

    <script type='text/javascript'><!--

    Ec3EditForm.event_cat_id='<?php echo $ec3->wp_in_category.$ec3->event_category; ?>';

    Ec3EditForm.start_of_week=<?php echo intval( get_option('start_of_week') ); ?>;

    // --></script>

    <!-- jscalendar 1.0 JavaScripts and css locations --> 

    <style type="text/css">@import url(<?php echo $ec3->myfiles; ?>/css/calendar-blue.css);</style>

    <script type="text/javascript" src="<?php echo $ec3->myfiles; ?>/js/calendar.js"></script>

    <script type="text/javascript" src="<?php echo $ec3->myfiles; ?>/js/calendar-en.js"></script>

    <script type="text/javascript" src="<?php echo $ec3->myfiles; ?>/js/calendar-setup.js"></script>

    <?php

  }

  //

  // EDIT FORM

  //

  /** Only for pre WP2.5. Inserts the Event Editor into the Write Post page. */

  function filter_edit_form()

  { ?>

    <!-- Build the user interface for Event Calendar. -->

    <div class="dbx-b-ox-wrapper">

    <fieldset id='ec3_schedule_editor' class="dbx-box">

    <div class="dbx-h-andle-wrapper">

    <h3 class="dbx-handle"><?php _e('Event Editor','ec3'); ?></h3>

    </div>

    <div class="dbx-c-ontent-wrapper">

    <div class="dbx-content">

    <?php $this->event_editor_box() ?>

    </div>

    </div>

    </fieldset>

    </div>

    <?php

  }

  function event_editor_box()

  {

    global $ec3,$wp_version,$wpdb,$post_ID;

    if(isset($post_ID))

      $schedule = $wpdb->get_results(

        "SELECT

           sched_id,

           DATE_FORMAT(start,'%Y-%m-%d %H:%i') AS start,

           DATE_FORMAT(end,'%Y-%m-%d %H:%i') AS end,

           allday,

           rpt

         FROM $ec3->schedule WHERE post_id=$post_ID ORDER BY start");

    else

      $schedule = false;

    if(function_exists('wp_create_nonce'))

    {

      echo '<input type="hidden" name="ec3_nonce" id="ec3_nonce" value="' . 

        wp_create_nonce( plugin_basename(__FILE__) ) . '" />';

    }

    ?>

    <!-- Event Calendar: Event Editor -->

    <table width="100%" cellspacing="2" cellpadding="5" class="editform">

     <thead><tr>

      <th><?php _e('Start','ec3'); ?></th>

      <th><?php _e('End','ec3'); ?></th>

      <th style="text-align:center"><?php _e('All Day','ec3'); ?></th>

      <!-- th><?php _e('Repeat','ec3'); ?></th -->

      <th></th>

     </tr></thead>

     <tbody>

    <?php

      $ec3_rows=0;

      if($schedule)

      {

        foreach($schedule as $s)

            $this->schedule_row(

              $s->start,$s->end,$s->sched_id,'update',$s->allday

            );

        $ec3_rows=count($schedule);

      }

      $default=ec3_strftime('%Y-%m-%d %H:00',3600+time());

      $this->schedule_row($default,$default,'_','create',False);

    ?>

      <tr> 

       <td colspan="4" style="text-align:left">

        <p style="margin:0;padding:0;text-align:left">

         <input type="button" name="ec3_new_row" value=" + "

          title="<?php _e('Add a new event','ec3'); ?>"

          onclick="Ec3EditForm.add_row()" />

         <input type="hidden" id="ec3_rows" name="ec3_rows"

          value="<?php echo $ec3_rows; ?>" />

        </p>

       </td>

      </tr> 

     </tbody>

    </table>

    <?php

  }

  /** Utility function called by event_editor_box(). */

  function schedule_row($start,$end,$sid,$action,$allday)

  {

    $s="ec3_start_$sid";

    $e="ec3_end_$sid";

    ?>

      <tr class="ec3_schedule_row" valign="middle"<?php

       if('create'==$action){ echo ' style="display:none"'; } ?>>

       <td>

        <input type="hidden" name="ec3_action_<?php echo $sid;

         ?>" value="<?php echo $action; ?>" />

        <input type="text" name="<?php echo $s;

         if('update'==$action){ echo "\" id=\"$s"; }

         ?>" value="<?php echo $start; ?>" />

        <button type="reset" id="trigger_<?php echo $s; ?>">&hellip;</button>

       </td>

       <td>

        <input type="text" name="<?php echo $e;

         if('update'==$action){ echo "\" id=\"$e"; }

         ?>" value="<?php echo $end; ?>" />

        <button type="reset" id="trigger_<?php echo $e; ?>">&hellip;</button>

       </td>

       <td style="text-align:center">

        <input type="checkbox" name="ec3_allday_<?php echo $sid;

         ?>" value="1"<?php if($allday){ echo ' checked="checked"'; } ?> />

       </td>

       <!-- td>

        <input type="text" name="ec3_repeat_<?php echo $sid; ?>" value="<?php echo $s->rpt; ?>" />

       </td -->

       <td>

        <p style="margin:0;padding:0">

         <input type="button" name="ec3_del_row_<?php echo $sid;

          ?>" value=" — "

          title="<?php _e('Delete this event','ec3'); ?>"

          onclick="Ec3EditForm.del_row(this)" />

        </p>

       </td>

      </tr> 

    <?php

  }

  function action_save_post($post_ID)

  {

    if(!$_POST)

        return;

    if(function_exists('wp_verify_nonce'))

    {

      if(!wp_verify_nonce($_POST['ec3_nonce'], plugin_basename(__FILE__) ))

          return;

    }

//   if(function_exists('current_user_can'))

//   {

//     if(!current_user_can('edit_post',$post_id))

//         return;

//   }

    // Ensure that we only save each post once.

    if(isset($this->save_post_called) && $this->save_post_called[$post_ID])

        return;

    if(!isset($this->save_post_called))

       $this->save_post_called=array();

    $this->save_post_called[$post_ID]=true;

    global $ec3,$wpdb;

    // Use this to check the DB before DELETE/UPDATE. Should use

    // ...IGNORE, but some people insist on using ancient version of MySQL.

    $count_where="SELECT COUNT(0) FROM $ec3->schedule WHERE";

    // If this post is no longer an event, then purge all schedule records.

    if(isset($_POST['ec3_rows']) && '0'==$_POST['ec3_rows'])

    {

      if($wpdb->get_var("$count_where post_id=$post_ID"))

         $wpdb->query("DELETE FROM $ec3->schedule WHERE post_id=$post_ID");

      return;

    }

    // Find all of our parameters

    $sched_entries=array();

    $fields =array('start','end','allday','rpt');

    foreach($_POST as $k => $v)

    {

      if(preg_match('/^ec3_(action|'.implode('|',$fields).')_(_?)([0-9]+)$/',$k,$match))

      {

        $sid=intval($match[3]);

        if(!isset( $sched_entries[$sid] ))

            $sched_entries[ $sid ]=array('allday' => 0);

        $sched_entries[ $sid ][ $match[1] ] = $v;

      }

    }

    foreach($sched_entries as $sid => $vals)

    {

      // Bail out if the input data looks suspect.

      if(!array_key_exists('action',$vals) || count($vals)<3)

        continue;

      // Save the value of 'action' and remove it. Leave just the column vals.

      $action=$vals['action'];

      unset($vals['action']);

      // Reformat the column values for SQL:

      foreach($vals as $k => $v)

          if('allday'==$k)

              $vals[$k]=intval($v);

          else

              $vals[$k]="'".$wpdb->escape($v)."'";

      $sid_ok=$wpdb->get_var("$count_where post_id=$post_ID AND sched_id=$sid");

      // Execute the SQL.

      if($action=='delete' && $sid>0 && $sid_ok):

        $wpdb->query(

         "DELETE FROM $ec3->schedule

          WHERE post_id=$post_ID

            AND sched_id=$sid"

        );

      elseif($action=='update' && $sid>0 && $sid_ok):

        $wpdb->query(

         "UPDATE $ec3->schedule

          SET ".$this->implode_assoc(', ',$vals)."

          WHERE post_id=$post_ID

            AND sched_id=$sid"

        );

      elseif($action=='create'):

        $wpdb->query(

         "INSERT INTO $ec3->schedule

          (post_id, ".implode(', ',array_keys($vals)).")

          VALUES ($post_ID,".implode(', ',array_values($vals)).")"

        );

      endif;

    }

    // Force all end dates to be >= start dates.

    $wpdb->query("UPDATE $ec3->schedule SET end=start WHERE end<start");

  } // end function action_save_post()

  /** Utility function called by action_save_post(). */

  function implode_assoc($glue,$arr)

  {

    $result=array();

    foreach($arr as $key=>$value)

        $result[]=$key."=".$value;

    return implode($glue,$result);

  }

  //

  // OPTIONS

  //

  /** Upgrade the installation, if necessary. */

  function upgrade_database()

  {

    global $ec3,$wpdb;

    // Check version - return if no upgrade required.

    $installed_version=get_option('ec3_version');

    if($installed_version==$ec3->version)

      return;

    $v0=$this->ec3_version($installed_version);

    $v1=$this->ec3_version($ec3->version);

    for($i=0; $i<min(count($v0),count($v1)); $i++)

    {

      if( $v0[$i] > $v1[$i] )

          return; // Installed version later than this one ?!?!

      if( $v0[$i] < $v1[$i] )

          break;  // Installed version earlier than this one.

    }

    // Upgrade.

    $tables=$wpdb->get_results('SHOW TABLES',ARRAY_N);

    if(!$tables)

      die(__('Error upgrading database for EventCalendar plugin.','ec3'));

    $table_exists=false;

    foreach($tables as $t)

        if(preg_match("/$ec3->schedule/",$t[0]))

            $table_exists=true;

    if(!$table_exists)

    {

      $wpdb->query(

        "CREATE TABLE $ec3->schedule (

           sched_id BIGINT(20) AUTO_INCREMENT,

           post_id  BIGINT(20),

           start    DATETIME,

           end      DATETIME,

           allday   BOOL,

           rpt      VARCHAR(64),

           PRIMARY KEY(sched_id)

         )");

      // Force the special upgrade page if we are coming from v3.0

      if( $ec3->event_category &&

          ( empty($v0) || $v0[0]<3 || ($v0[0]==3 && $v0[1]==0) ) )

      {

        update_option('ec3_upgrade_posts',1);

      }

    } // end if(!$table_exists)

    // Record the new version number

    update_option('ec3_version',$ec3->version);

    echo '<div id="message" class="updated fade"><p><strong>'

       . sprintf(

           __('Upgraded database to EventCalendar Version %s','ec3'),

           $ec3->version

         );

    if($table_exists)

        echo '<br />('.__('Table already existed','ec3').')';

    echo ".</strong></p></div>\n";

  } // end function upgrade_database();

  /** Utility function used by upgrade_database().

   *  Breaks apart a version string into an array of comparable parts. */

  function ec3_version($str)

  {

    $s=preg_replace('/([a-z])([0-9])/','\1.\2',$str);

    $v=explode('.',$s);

    $result=array();

    foreach($v as $i)

    {

      if(preg_match('/^[0-9]+$/',$i))

          $result[]=intval($i);

      elseif(empty($i))

          $result[]=0;

      else

          $result[]=$i;

    }

    return $result;

  }

  function action_admin_menu()

  {

    global $ec3;

    add_options_page(

      __('Event Calendar Options','ec3'),

      'EventCalendar',

      6,

      'ec3_admin',

      'ec3_options_subpanel'

    );

    if(empty($ec3->event_category))

      return; // Until EC is properly configured, only show the options page.

    if(function_exists('add_meta_box'))

    {

      add_meta_box(

        'ec3_schedule_editor',   // HTML id for container div

        __('Event Editor','ec3'),

        'ec3_event_editor_box',  // callback function

        'post',                  // page type

        'advanced',              // context

        'high'                   // priority

      );

    }

    else

    {

      // Old (pre WP2.5) functionality.

      add_filter('simple_edit_form',    array(&$ec3_admin,'filter_edit_form'));

      if($ec3->wp_have_dbx)

        add_filter('dbx_post_advanced', array(&$ec3_admin,'filter_edit_form'));

      else

        add_filter('edit_form_advanced',array(&$ec3_admin,'filter_edit_form'));

    }

  }

  function options_subpanel()

  {

    global $ec3;

    if(isset($_POST['info_update']))

    {

      echo '<div id="message" class="updated fade"><p><strong>';

      if(isset($_POST['ec3_event_category']))

          $ec3->set_event_category( intval($_POST['ec3_event_category']) );

      if(isset($_POST['ec3_num_months']))

          $ec3->set_num_months( intval($_POST['ec3_num_months']) );

      if(isset($_POST['ec3_show_only_events']))

          $ec3->set_show_only_events( intval($_POST['ec3_show_only_events']) );