Subversion Repositories Applications.bazar

<?php

/*

 * phpMyEdit - instant MySQL table editor and code generator

 *

 * extensions/phpMyEdit-report.class.php - phpMyEdit report extension

 * ____________________________________________________________

 *

 * 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-report.class.php,v 1.12 2006-01-22 21:44:23 nepto Exp $ */

/* Extension TODO:

   - allow user to enable/disable particular field in reporting (maybe 'X' flag

     for indicating that field is forbidden is good idea)

   - support for ['help'] in select fields screen

   - make extension's option for selecting "Select fields" link or button

 */

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

class phpMyEdit_report extends phpMyEdit

{

	function phpMyEdit_report($opts) /* {{{ */

	{

		$opts['options'] = 'L';

		$execute = 1;

		isset($opts['execute']) && $execute = $opts['execute'];

		$opts['execute'] = 0;

		parent::phpMyEdit($opts);

		$execute && $this->execute();

	} /* }}} */

	function make_language_labels($language) /* {{{ */

	{

		$ret = parent::make_language_labels($language);

		strlen($ret['Make report'])        <= 0 && $ret['Make report']        = 'Make report';

		strlen($ret['Select fields'])      <= 0 && $ret['Select fields']      = 'Select fields';

		strlen($ret['Records per screen']) <= 0 && $ret['Records per screen'] = 'Records per screen';

		return $ret;

	} /* }}} */

	function get_cgi_cookie_var($name, $default_value = null) /* {{{ */

	{

		$ret = $this->get_cgi_var($name, null);

		if ($ret === null) {

			global $HTTP_COOKIE_VARS;

			$ret = @$HTTP_COOKIE_VARS[$name.'_'.$this->tb.'_cookie'];

			if (! isset($ret)) {

				$ret = $default_value;

			}

		}

		return $ret;

	} /* }}} */

	function display_list_table_buttons($total_recs, $position) /* {{{ */

	{	/* This is mostly copy/paste from core class. */

		$listall = $this->inc <= 0; // Are we doing a listall?

		echo '<table class="',$this->getCSSclass('navigation', $position),'">',"\n";

		echo '<tr class="',$this->getCSSclass('navigation', $position),'">',"\n";

		echo '<td class="',$this->getCSSclass('buttons', $position),'">',"\n";

		echo '<input class="',$this->getCSSclass('fields-select', $position);

		echo '" type="submit" name="fields_select" value="',$this->labels['Select fields'],'"> ';

		// Note that <input disabled isn't valid HTML, but most browsers support it

		$disabled = ($this->fm > 0 && ! $listall) ? '' : ' disabled';

		echo '<input',$disabled,' class="',$this->getCSSclass('prev', $position);

		echo '" type="submit" name="',ltrim($disabled),'prev" value="',$this->labels['Prev'],'"> ';

		$disabled = ($this->fm + $this->inc < $total_recs && ! $listall) ? '' : ' disabled';

		echo '<input',$disabled,' class="',$this->getCSSclass('next', $position);

		echo '" type="submit" name="',ltrim($disabled),'next" value="',$this->labels['Next'],'">';

		// Message is now written here

		echo '</td>',"\n";

		if (strlen(@$this->message) > 0) {

			echo '<td class="',$this->getCSSclass('message', $position),'">',$this->message,'</td>',"\n";

		}

		// Display page and records statistics

		echo '<td class="',$this->getCSSclass('stats', $position),'">',"\n";

		if ($listall) {

			echo $this->labels['Page'],': 1 ',$this->labels['of'],' 1';

		} else {

			echo $this->labels['Page'],': ',($this->fm / $this->inc) + 1;

			echo ' ',$this->labels['of'],' ',max(1, ceil($total_recs / abs($this->inc)));

		}

		echo '  ',$this->labels['Records'],': ',$total_recs;

		echo '</td></tr></table>',"\n";

	} /* }}} */

	function display_report_selection_buttons($position) /* {{{ */

	{

		echo '<table class="',$this->getCSSclass('navigation', $position),'">',"\n";

		echo '<tr class="',$this->getCSSclass('navigation', $position),'">',"\n";

		echo '<td class="',$this->getCSSclass('buttons', $position),'">',"\n";

		echo '<input class="',$this->getCSSclass('make-report', $position);

		echo '" type="submit" name="prepare_filter" value="',$this->labels['Make report'],'">',"\n";

		echo '</td></tr></table>',"\n";

	} /* }}} */

	function get_select_fields_link() /* {{{ */

	{

		$link = '<a href="'.htmlspecialchars($this->page_name).'?fields_select=1';

		for ($i = 0; $i < count($table_cols); $i++) {

			$varname = 'qf'.$i;

			$value   = $this->get_cgi_cookie_var($varname);

			if (! empty($value)) {

				$link .= htmlspecialchars(

						'&'.rawurlencode($varname).

						'='.rawurlencode($value));

			}

		}

		$link .= htmlspecialchars($this->cgi['persist']);

		$link .= '">'.$this->labels['Select fields'].'</a>';

		return $link;

	} /* }}} */

	function execute() /* {{{ */

	{

		global $HTTP_GET_VARS;

		global $HTTP_POST_VARS;

		/*

		 * Extracting field names

		 */

		$table_cols     = array();

		$all_table_cols = array();

		if ($this->connect() == false) {

			return false;

		}

		$query_parts = array(

				'type'   => 'select',

				'select' => '*',

				'from'   => $this->tb,

				'limit'  => '1');

		$result = $this->myquery($this->get_SQL_query($query_parts), __LINE__);

		$all_table_cols = array_keys(@mysql_fetch_array($result, MYSQL_ASSOC));

		if (count($all_table_cols) <= 0) {

			$this->error('database fetch error');

			return false;

		}

		foreach (array_keys($this->fdd) as $field_name) {

			if (preg_match('/^\d*$/', $field_name))

				continue;

			if (($idx = array_search($field_name, $all_table_cols)) !== false)

				$table_cols[$field_name] = mysql_field_len($result, $idx);

		}

		@mysql_free_result($result);

		unset($all_table_cols);

		/*

		 * Preparing variables

		 */

		$fields_select  = $this->get_cgi_var('fields_select');

		$filter         = $this->get_cgi_var('filter');

		$prepare_filter = $this->get_cgi_var('prepare_filter');

		$this->inc      = intval($this->get_cgi_cookie_var('inc'));

		$force_select   = true;

		$none_displayed = true;

		$expire_time    = time() + (3600 * 24 * 30 * 12 * 5); // five years

		$headers_sent   = @headers_sent();

		foreach (array_merge(array('@inc'), array_keys($table_cols)) as $col) {

			$varname = ($col[0] == '@' ? substr($col, 1) : 'have_'.$col);

			if (isset($HTTP_POST_VARS[$varname]) || isset($HTTP_GET_VARS[$varname])) {

				$value = $HTTP_POST_VARS[$varname];

				if (isset($HTTP_GET_VARS[$varname])) {

					$value = $HTTP_GET_VARS[$varname];

				}

				if ($varname != 'inc' && ! empty($value)) {

					$force_select = false;

				}

				$headers_sent || setcookie($varname.'_'.$this->tb.'_cookie', $value, $expire_time);

				$this->cgi['persist'] .= '&'.urlencode($varname);

				$this->cgi['persist'] .= '='.urlencode($value);

			} else {

				$headers_sent || setcookie($varname.'_'.$this->tb.'_cookie', '', time() - 10000);

			}

		}

		$i = -1;

		foreach (array_keys($this->fdd) as $key) {

			$i++;

			if (preg_match('/^\d*$/', $key))

				continue;

			$varname = 'have_'.$key;

			$value   = @$this->get_cgi_cookie_var($varname, '');

			$options = @$value ? 'LV' : '';

			$this->fdd[$i]['options']   = $options;

			$this->fdd[$key]['options'] = $options;

			$this->displayed[$i] = @$value ? true : false;

			$value && $none_displayed = false;

		}

		/*

		 * Redirecting when neccessary

		 * (hackity hack with unregistering/unchecking fields)

		 */

		if ($prepare_filter && ! $headers_sent) {

			$this->execute_redirect();

			exit;

		}

		/*

		 * Check if field selection report screen has to be displayed

		 */

		if (isset($fields_select) || $force_select || $none_displayed) {

			$this->execute_report_screen($table_cols);

			return true;

		}

		if (0) {

			$this->message .= $this->get_select_fields_link();

		}

		// parent class call

		return parent::execute();

	} /* }}} */

	function execute_redirect() /* {{{ */

	{

		global $HTTP_SERVER_VARS;

		global $HTTP_GET_VARS;

		global $HTTP_POST_VARS;

		$redirect_url = 'http://'.$HTTP_SERVER_VARS['HTTP_HOST'].$HTTP_SERVER_VARS['SCRIPT_NAME'];

		$delim = '?';

		foreach ($HTTP_POST_VARS + $HTTP_GET_VARS as $cgi_var_name => $cgi_var_value) {

			$cgi_var_name == 'prepare_filter' && $cgi_var_name = 'filter';

			$redirect_url .= $delim;

			$redirect_url .= rawurlencode($cgi_var_name).'='.rawurlencode($cgi_var_value);

			$delim == '?' && $delim = '&';

		}

		$redirect_url .= $this->cgi['persist'];

		header('Location: '.$redirect_url);

		exit;

	} /* }}} */

	function execute_report_screen($table_cols) /* {{{ */

	{

		echo '<form class="',$this->getCSSclass('form'),'" action="';

		echo htmlspecialchars($this->page_name),'" method="POST">',"\n";

		if ($this->nav_up()) {

			$this->display_report_selection_buttons('up');

			echo '<hr class="',$this->getCSSclass('hr', 'up'),'">',"\n";

		}

		echo '<table class="',$this->getCSSclass('main'),'" summary="',$this->tb,'">',"\n";

		$i = 0;

		foreach ($table_cols as $key => $val) {

			$css_postfix    = @$this->fdd[$key]['css']['postfix'];

			$css_class_name = $this->getCSSclass('input', null, true, $css_postfix);

			$varname        = 'have_'.$key;

			$value          = $this->get_cgi_cookie_var($varname);

			$checked        = @$value ? ' checked' : '';

			echo '<tr class="',$this->getCSSclass('row', null, 'next', $css_postfix),'">',"\n";

			echo '<td class="',$this->getCSSclass('key', null, true, $css_postfix),'">';

			echo $this->fdd[$i]['name'],'</td>',"\n";

			echo '<td class="',$this->getCSSclass('check', null, true, $css_postfix),'">';

			echo '<input class="',$css_class_name,'" type="checkbox" name="';

			echo htmlspecialchars($varname),'"',$checked,'>';

			echo '</td>',"\n";

			echo '<td class="',$this->getCSSclass('value', null, true, $css_postfix),'"';

			echo $this->getColAttributes($key),">\n";

			$varname = 'qf'.$i;

			$value   = $this->get_cgi_cookie_var($varname);

			if ($this->fdd[$key]['select'] == 'D' || $this->fdd[$key]['select'] == 'M') {

				$from_table = ! $this->col_has_values($key) || isset($this->fdd[$key]['values']['table']);

				$selected   = $value;

				$value      = $this->set_values($key, array('*' => '*'), null, $from_table);

				$multiple   = $this->col_has_multiple_select($key);

				$multiple  |= $this->fdd[$key]['select'] == 'M';

				$readonly   = false;

				$strip_tags = true;

				$escape     = true;

				echo $this->htmlSelect($varname.'_id', $css_class_name, $value, $selected,

						$multiple, $readonly, $strip_tags, $escape);

			} else {

				echo '<input class="',$css_class_name,'" type=text name="';

				echo htmlspecialchars($varname),'" value="',htmlspecialchars($value),'" size="';

				echo min(40, $val),'" maxlength="',min(40, max(10, $val)),'">';

			}

			echo '</td>',"\n",'</tr>',"\n";

			$i++;

		}

		echo '<tr class="',$this->getCSSclass('row', null, 'next', $css_postfix),'">',"\n";

		echo '<td class="',$this->getCSSclass('key', null, true, $css_postfix),'" colspan="2">';

		echo $this->labels['Records per screen'],'</td>';

		echo '<td class="',$this->getCSSclass('value', null, true, $css_postfix),'">';

		echo '<input class="',$css_class_name,'" type="text" name="inc" value="',$this->inc.'">';

		echo '</td></tr>',"\n";

		echo '</table>',"\n";

		if ($this->nav_down()) {

			echo '<hr class="',$this->getCSSclass('hr', 'down'),'">',"\n";

			$this->display_report_selection_buttons('down');

		}

		echo '</form>';

	} /* }}} */

}

/* Modeline for ViM {{{

 * vim:set ts=4:

 * vim600:fdm=marker fdl=0 fdc=0:

 * }}} */

?>