Subversion Repositories eFlore/Applications.cel

<?php

/*
 * phpMyEdit - instant MySQL table editor and code generator
 *
 * extensions/phpMyEdit-slide.class.php - slide show extension for phpMyEdit
 * ____________________________________________________________
 *
 * Developed by Ondrej Jombik <nepto@platon.sk>
 * Copyright (c) 2002-2006 Platon Group, http://platon.sk/
 * All rights reserved.
 *
 * See README file for more information about this software.
 * See COPYING file for license information.
 *
 * Download the latest version from
 * http://platon.sk/projects/phpMyEdit/
 */

/* $Platon: phpMyEdit/extensions/phpMyEdit-slide.class.php,v 1.10 2006-01-22 21:44:24 nepto Exp $ */

/*
 * Coding elapsed time: from 8:30 to 10:30 at 30th October 2002
 * with heavy patching phpMyEdit core class.
 *
 * Music used: E-Type (Campione, This is the Way and others)
 */

require_once dirname(__FILE__).'/../phpMyEdit.class.php';

class phpMyEdit_slide extends phpMyEdit
{
        // Extension options array
        var $ext;

        function phpMyEdit_slide($opts) /* {{{ */
        {
                $execute = 1;
                isset($opts['execute']) && $execute = $opts['execute'];
                $opts['execute'] = 0;
                parent::phpMyEdit($opts);

                $this->ext = $opts['ext'];

                $execute && $this->execute($opts);
        } /* }}} */

        function display_record_buttons() /* {{{ */
        {
                // TODO: classify this table and cells
                echo '<table border=0 cellpadding=0 cellspacing=0 width="100%" style="border:0;padding:0;">';
                echo '<tr><td align=left style="text-align:left;border:0;padding:0;" nowrap>' . "\n";
                if ($this->change_operation()) {
                        echo '<input type="submit" name="savechange" value="'.$this->labels['Save'].'" />'."\n";
                        echo '<input type="submit" name="morechange" value="'.$this->labels['Apply'].'" />'."\n";
                        echo '<input type="button" name="cancel" value="'.$this->labels['Cancel'].'" onClick="form.submit();" />'."\n";
                        echo '<input type="hidden" name="rec_change" value="1">';
                } elseif ($this->view_operation()) {
                        if ($this->change_enabled()) {
                                echo '<input type="submit" name="operation" value="'.$this->labels['Change'].'" />'."\n";
                        }
                        echo '<input type="submit" name="cancel" value="'.$this->labels['Cancel'].'" />'."\n";
                }

                if (! $this->ext['prev_disable']) {
                        $disabled = $this->ext['prev'] ? '' : ' disabled';
                        echo '<input'.$disabled.' type="submit" name="'.ltrim($disabled).'prev" value="'
                                .$this->labels['Prev'].'">&nbsp;';
                        echo '<input type="hidden" name="rec_prev" value="'.$this->ext['prev'].'">';
                }
                if (! $this->ext['next_disable']) {
                        $disabled = $this->ext['next'] ? '' : ' disabled';
                        echo '<input'.$disabled.' type="submit" name="'.ltrim($disabled).'next" value="'
                                .$this->labels['Next'].'">';
                        echo '<input type="hidden" name="rec_next" value="'.$this->ext['next'].'">';
                }
                echo '</td></tr></table>'."\n";
        } /* }}} */

        function execute($opts) /* {{{ */
        {
                if ($this->get_cgi_var('rec_change')
                                && ($this->next_operation() || $this->prev_operation())) {
                        $this->operation = $this->labels['Change'];
                }
                if (! $this->change_operation()) {
                        $this->operation = $this->labels['View'];
                }
                if ($this->prev_operation()) {
                        ! $this->ext['prev_disabled'] && $this->rec = $this->get_cgi_var('rec_prev');
                        $this->prev = '';
                }
                if ($this->next_operation()) {
                        ! $this->ext['next_disabled'] && $this->rec = $this->get_cgi_var('rec_next');
                        $this->next = '';
                }
                if (! $this->rec) {
                        $this->rec = $this->ext['rec'];
                }

                if (! $this->rec
                                || (! $this->ext['prev_disable'] && ! $this->ext['prev'])
                                || (! $this->ext['next_disable'] && ! $this->ext['next'])) {
                        if ($this->connect() == false) {
                                return false;
                        }
                        $query_parts = array(
                                        'type'   => 'select',
                                        // XXX FIXME - simplify query
                                        'select' => 'PMEtable0.'.$this->key,
                                        'from'   => $this->get_SQL_join_clause(),
                                        'where'  => $this->get_SQL_where_from_query_opts());
                        // TODO: order by clausule according to default sort order options
                        $res = $this->myquery($this->get_SQL_query($query_parts), __LINE__);
                        $ids = array();
                        while (($row = @mysql_fetch_array($res, MYSQL_NUM)) !== false) {
                                $ids[] = $row[0];
                        }
                        @mysql_free_result($res);
                        if ($this->rec) {
                                $idx = array_search($this->rec, $ids);
                                $idx === false && $idx = 0;
                        } else {
                                $idx = 0;
                        }

                        $this->rec = $ids[$idx];
                        ! $this->ext['prev'] && $this->ext['prev'] = $ids[$idx - 1];
                        ! $this->ext['next'] && $this->ext['next'] = $ids[$idx + 1];
                }
        
                $this->recreate_fdd();
                $this->recreate_displayed();
                parent::execute();
        } /* }}} */

}

/* Modeline for ViM {{{
 * vim:set ts=4:
 * vim600:fdm=marker fdl=0 fdc=0:
 * }}} */

?>