TYPO3 Forum & Portal - Einzelnen Beitrag anzeigen

farid1399 · #7 21.06.08, 11:09

Ja bestimmt sonst wovon soll es kommen ;-)
Ich weiss nicht wo genau soll ich änderen.
Steht nicht eine normale SQL-befehle, der die Daten von Datenbank ausgibt.
Ich schick dir meine php-datei "class.tx_.....", kannst du mir bitte genau sagen wo und was soll ich änderen. wäre ich sehr dankbar

Hier ist php-code ( + die rote plus nur um zu erleichteren wo die wo man änderen soll. denke ich )

<?php
/***************************************************************
* Copyright notice
*
* (c) 2008
* All rights reserved
*
* This script is part of the TYPO3 project. The TYPO3 project 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.
*
* The GNU General Public License can be found at
* The GNU General Public License - GNU Project - Free Software Foundation (FSF).
*
* This script 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.
*
* This copyright notice MUST APPEAR in all copies of the script!
***************************************************************/
require_once(PATH_tslib.'class.tslib_pibase.php');

/**
* Plugin 'Mitarbeiter-Verzeichnis' for the 'tk_mitarbeiter' extension.
*
* @package TYPO3
* @subpackage tx_tkmitarbeiter
*/
class tx_tkmitarbeiter_pi1 extends tslib_pibase {
var $prefixId = 'tx_tkmitarbeiter_pi1'; // Same as class name
var $scriptRelPath = 'pi1/class.tx_tkmitarbeiter_pi1.php'; // Path to this script relative to the extension dir.
var $extKey = 'tk_mitarbeiter'; // The extension key.
var $pi_checkCHash = true;

/**
* Main method of your PlugIn
*
* @param string $content: The content of the PlugIn
* @param array $conf: The PlugIn Configuration
* @return The content that should be displayed on the website
*/
function main($content,$conf) {
switch((string)$conf['CMD']) {
case 'singleView':
list($t) = explode(':',$this->cObj->currentRecord);
$this->internal['currentTable']=$t;
$this->internal['currentRow']=$this->cObj->data;
return $this->pi_wrapInBaseClass($this->singleView($content,$conf));
break;
default:
if (strstr($this->cObj->currentRecord,'tt_content')) {
$conf['pidList'] = $this->cObj->data['pages'];
$conf['recursive'] = $this->cObj->data['recursive'];
}
return $this->pi_wrapInBaseClass($this->listView($content,$conf));
break;
}
}

/**
* Shows a list of database entries
*
* @param string $content: content of the PlugIn
* @param array $conf: PlugIn Configuration
* @return HTML list of table entries
*/
function listView($content,$conf) {
$this->conf=$conf; // Setting the TypoScript passed to this function in $this->conf
$this->pi_setPiVarDefaults();
$this->pi_loadLL(); // Loading the LOCAL_LANG values

$lConf = $this->conf['listView.']; // Local settings for the listView function

if ($this->piVars['showUid']) { // If a single element should be displayed:
$this->internal['currentTable'] = 'tx_tkmitarbeiter_personen';
$this->internal['currentRow'] = $this->pi_getRecord('tx_tkmitarbeiter_personen',$this->piVars['showUid']);

$content = $this->singleView($content,$conf);
return $content;
} else {
$items=array(
'1'=> $this->pi_getLL('list_mode_1','Mode 1'),
'2'=> $this->pi_getLL('list_mode_2','Mode 2'),
'3'=> $this->pi_getLL('list_mode_3','Mode 3'),
);
if (!isset($this->piVars['pointer'])) $this->piVars['pointer']=0;
if (!isset($this->piVars['mode'])) $this->piVars['mode']=1;

// Initializing the query parameters:
list($this->internal['orderBy'],$this->internal['descFlag']) = explode(':',$this->piVars['sort']);
$this->internal['results_at_a_time']=t3lib_div::intInRange($lConf['results_at_a_time'],0,1000,3); // Number of results to show in a listing.
$this->internal['maxPages']=t3lib_div::intInRange($lConf['maxPages'],0,1000,2);; // The maximum number of "pages" in the browse-box: "Page 1", "Page 2", etc.
$this->internal['searchFieldList']='name,vorname,strassehausnr,plz,telefone';
$this->internal['orderByList']='uid,name,vorname,strassehausnr,plz,telefone';

+// Get number of records:
+$res = $this->pi_exec_query('tx_tkmitarbeiter_personen',1);
+list($this->internal['res_count']) = $GLOBALS['TYPO3_DB']->sql_fetch_row($res);

// Make listing query, pass query to SQL database:
+$res = $this->pi_exec_query('tx_tkmitarbeiter_personen');
+$this->internal['currentTable'] = 'tx_tkmitarbeiter_personen';

// Put the whole list together:
$fullTable=''; // Clear var;
# $fullTable.=t3lib_div::view_array($this->piVars); // DEBUG: Output the content of $this->piVars for debug purposes. REMEMBER to comment out the IP-lock in the debug() function in t3lib/config_default.php if nothing happens when you un-comment this line!

// Adds the mode selector.
# $fullTable.=$this->pi_list_modeSelector($items);

// Adds the whole list table
$fullTable.=$this->pi_list_makelist($res);

// Adds the search box:
$fullTable.=$this->pi_list_searchBox();

// Adds the result browser:
$fullTable.=$this->pi_list_browseresults();

// Returns the content from the plugin.
return $fullTable;
}
}
/**
* Display a single item from the database
*
* @param string $content: The PlugIn content
* @param array $conf: The PlugIn configuration
* @return HTML of a single database entry
*/
function singleView($content,$conf) {
$this->conf=$conf;
$this->pi_setPiVarDefaults();
$this->pi_loadLL();

// This sets the title of the page for use in indexed search results:
if ($this->internal['currentRow']['title']) $GLOBALS['TSFE']->indexedDocTitle=$this->internal['currentRow']['title'];

$content='<div'.$this->pi_classParam('singleView').'>
<H2>Record "'.$this->internal['currentRow']['uid'].'" from table "'.$this->internal['currentTable'].'":</H2>
<table>
<tr>
<td nowrap="nowrap" valign="top"'.$this->pi_classParam('singleView-HCell').'>'.$this->getFieldHeader('name').'</td>
<td valign="top">'.$this->getFieldContent('name').'</td>
</tr>
<tr>
<td nowrap="nowrap" valign="top"'.$this->pi_classParam('singleView-HCell').'>'.$this->getFieldHeader('vorname').'</td>
<td valign="top">'.$this->getFieldContent('vorname').'</td>
</tr>
<tr>
<td nowrap="nowrap" valign="top"'.$this->pi_classParam('singleView-HCell').'>'.$this->getFieldHeader('strassehausnr').'</td>
<td valign="top">'.$this->getFieldContent('strassehausnr').'</td>
</tr>
<tr>
<td nowrap="nowrap" valign="top"'.$this->pi_classParam('singleView-HCell').'>'.$this->getFieldHeader('plz').'</td>
<td valign="top">'.$this->getFieldContent('plz').'</td>
</tr>
<tr>
<td nowrap="nowrap" valign="top"'.$this->pi_classParam('singleView-HCell').'>'.$this->getFieldHeader('telefone').'</td>
<td valign="top">'.$this->getFieldContent('telefone').'</td>
</tr>
<tr>
<td nowrap'.$this->pi_classParam('singleView-HCell').'>Last updated:</td>
<td valign="top">'.date('d-m-Y H:i',$this->internal['currentRow']['tstamp']).'</td>
</tr>
<tr>
<td nowrap'.$this->pi_classParam('singleView-HCell').'>Created:</td>
<td valign="top">'.date('d-m-Y H:i',$this->internal['currentRow']['crdate']).'</td>
</tr>
</table>
'.$this->pi_list_linkSingle($this->pi_getLL('back','Back'),0).'</div>'.
$this->pi_getEditPanel();

return $content;
}
/**
* Returns a single table row for list view
*
* @param integer $c: Counter for odd / even behavior
* @return A HTML table row
*/
function pi_list_row($c) {
$editPanel = $this->pi_getEditPanel();
if ($editPanel) $editPanel='<TD>'.$editPanel.'</TD>';

return '<tr'.($c%2 ? $this->pi_classParam('listrow-odd') : '').'>
<td>'.$this->getFieldContent('uid').'</td>
<td valign="top">'.$this->getFieldContent('name').'</td>
<td valign="top">'.$this->getFieldContent('vorname').'</td>
<td valign="top">'.$this->getFieldContent('strassehausnr').'</td>
<td valign="top">'.$this->getFieldContent('plz').'</td>
<td valign="top">'.$this->getFieldContent('telefone').'</td>
</tr>';
}
/**
* Returns a table row with column names of the table
*
* @return A HTML table row
*/
function pi_list_header() {
return '<tr'.$this->pi_classParam('listrow-header').'>
<td>'.$this->getFieldHeader_sortLink('uid').'</td>
<td>'.$this->getFieldHeader_sortLink('name').'</td>
<td>'.$this->getFieldHeader_sortLink('vorname').'</td>
<td>'.$this->getFieldHeader_sortLink('strassehausnr').'</td>
<td>'.$this->getFieldHeader_sortLink('plz').'</td>
<td>'.$this->getFieldHeader_sortLink('telefone').'</td>
</tr>';
}
/**
* Returns the content of a given field
*
* @param string $fN: name of table field
* @return Value of the field
*/
function getFieldContent($fN) {
switch($fN) {
case 'uid':
return $this->pi_list_linkSingle($this->internal['currentRow'][$fN],$this->internal['currentRow']['uid'],1); // The "1" means that the display of single items is CACHED! Set to zero to disable caching.
break;

default:
return $this->internal['currentRow'][$fN];
break;
}
}
/**
* Returns the label for a fieldname from local language array
*
* @param [type] $fN: ...
* @return [type] ...
*/
function getFieldHeader($fN) {
switch($fN) {

default:
return $this->pi_getLL('listFieldHeader_'.$fN,'['.$fN.']');
break;
}
}

/**
* Returns a sorting link for a column header
*
* @param string $fN: Fieldname
* @return The fieldlabel wrapped in link that contains sorting vars
*/
function getFieldHeader_sortLink($fN) {
return $this->pi_linkTP_keepPIvars($this->getFieldHeader($fN),array('sort'=>$fN.':'.($this->internal['descFlag']?0:1)));
}
}

if (defined('TYPO3_MODE') && $TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['ext/tk_mitarbeiter/pi1/class.tx_tkmitarbeiter_pi1.php']) {
include_once($TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['ext/tk_mitarbeiter/pi1/class.tx_tkmitarbeiter_pi1.php']);
}
?>