Home . Extensions . Repository
Sponsors
Extension Repository
The official extension repository only consists of freely available extensions. New documentation is rendered once a day.
Partner Management
-
- Icon
- Title
- Partner Management
- Extension key
- ( partner )
- State
- beta, Not reviewed!
- Extension Details
-
- Author
- David Bruehlmeier
- Category
- be
- Version
- 0.5.21
- Manual
- Read online
- Downloads (total / this version)
- 5536 / 394
- Rating
- none
-
- Updated
- 25.05.2009
- Upload comment
- * Fixed issue when using extension FPDF > 0.2.0 * Fixed issue #3280
-
- Description
- This extension includes everything you need to manage partners (persons and organisations). You can save everything from addresses to occupations, from legal forms to birth dates. Unlimited contact information records (e.g. phone numbers) can be managed f
- Extension Details
-
- Dependencies
-
- depends on php 3.0.0-0.0.0
- depends on typo3 3.8.1-0.0.0
- depends on static_info_tables
- Reverse dependencies
The following extension versions depend on this extension:
-
- Version history
- 0.5.20: Migrated the locallang*.php files to xml files. Thanks to Fabien Udriot for his contribution!
- 0.5.19: Minor code-level improvements (no new features)
- 0.5.18: Bugfix in birthday list.
- 0.5.17: Bugfix (telephone extension '0' was not displayed)
- 0.5.16: Added support for mm-fields in reports
-
- Download extension
-
Preview for file partner-0.5.21-class__ext_update__php:Filename Size View Date Download class.ext_update.php 6.2 K View 01.04.2009 Download constants.txt 1.6 K View 01.04.2009 Download ext_conf_template.txt 1.4 K View 01.04.2009 Download ext_icon.gif 0.9 K View 01.04.2009 Download ext_localconf.php 5.5 K View 20.04.2009 Download ext_php_api.dat 48 K 01.04.2009 Download ext_tables.php 14.0 K View 20.04.2009 Download ext_tables.sql 12.2 K View 01.04.2009 Download flexform_ds.xml 18.4 K View 20.04.2009 Download locallang_db.xml 63 K View 20.04.2009 Download tca.php 54 K View 20.04.2009 Download api/class.tx_partner_contact_info.php 3.6 K View 01.04.2009 Download api/class.tx_partner_div.php 42 K View 19.05.2009 Download api/class.tx_partner_lang.php 2.9 K View 20.04.2009 Download api/class.tx_partner_main.php 6.8 K View 01.04.2009 Download api/class.tx_partner_query.php 36 K View 01.04.2009 Download api/class.tx_partner_relationship.php 10.9 K View 01.04.2009 Download cli/conf.php 182 View 01.04.2009 Download cli/create_report.php 3.1 K View 01.04.2009 Download csh/locallang_csh_MOD_partner.xml 6.8 K View 20.04.2009 Download csh/locallang_csh_tx_partner_contact_info.xml 5.1 K View 20.04.2009 Download csh/locallang_csh_tx_partner_main.xml 30 K View 20.04.2009 Download csh/locallang_csh_tx_partner_relationships.xml 4.9 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_contact_permissions.xml 9.3 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_courses.xml 9.3 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_hobbies.xml 9.2 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_legal_forms.xml 9.9 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_marital_status.xml 9.3 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_occupations.xml 9.3 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_org_types.xml 9.3 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_rel_types.xml 12.3 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_religions.xml 9.3 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_status.xml 10.0 K View 20.04.2009 Download csh/locallang_csh_tx_partner_val_titles.xml 10.5 K View 20.04.2009 Download csh/img/field_visibility_default_settings.png 6.2 K View 01.04.2009 Download doc/TODO.txt 9.6 K View 01.04.2009 Download doc/TODO_new_ext.txt 1.1 K View 01.04.2009 Download doc/empty_partner_tables.sql 732 View 01.04.2009 Download doc/manual.sxw 191 K 25.05.2009 Download doc/partner_demo_data.sql 40 K View 01.04.2009 Download icons/icon_tx_partner_contact_info.gif 887 View 01.04.2009 Download icons/icon_tx_partner_contact_info_email.gif 877 View 01.04.2009 Download icons/icon_tx_partner_contact_info_fax.gif 893 View 01.04.2009 Download icons/icon_tx_partner_contact_info_mobile.gif 884 View 01.04.2009 Download icons/icon_tx_partner_contact_info_phone.gif 887 View 01.04.2009 Download icons/icon_tx_partner_contact_info_url.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_main.gif 864 View 01.04.2009 Download icons/icon_tx_partner_main_organisation.gif 145 View 01.04.2009 Download icons/icon_tx_partner_main_person.gif 164 View 01.04.2009 Download icons/icon_tx_partner_relationships.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_contact_permissions.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_courses.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_hobbies.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_legal_forms.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_marital_status.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_occupations.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_org_types.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_rel_types.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_religions.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_status.gif 0.9 K View 01.04.2009 Download icons/icon_tx_partner_val_titles.gif 0.9 K View 01.04.2009 Download icons/icon_web_txpartnerM1.gif 880 View 01.04.2009 Download icons/selicon_tx_partner_contact_info_type_0.gif 0.9 K View 01.04.2009 Download icons/selicon_tx_partner_contact_info_type_1.gif 0.9 K View 01.04.2009 Download icons/selicon_tx_partner_contact_info_type_2.gif 0.9 K View 01.04.2009 Download icons/selicon_tx_partner_contact_info_type_3.gif 0.9 K View 01.04.2009 Download icons/selicon_tx_partner_contact_info_type_4.gif 0.9 K View 01.04.2009 Download icons/selicon_tx_partner_default.gif 878 View 01.04.2009 Download icons/selicon_tx_partner_main_type_0.gif 0.9 K View 01.04.2009 Download icons/selicon_tx_partner_main_type_1.gif 0.9 K View 01.04.2009 Download inc/class.tx_partner_download_report.php 10.8 K View 20.04.2009 Download inc/class.tx_partner_format.php 39 K View 20.05.2009 Download inc/class.tx_partner_select.php 4.8 K View 20.04.2009 Download inc/class.tx_partner_tce_user.php 27 K View 20.04.2009 Download inc/class.tx_partner_tcemainprocdm.php 12.7 K View 01.04.2009 Download inc/class.tx_partner_user_fields.php 3.7 K View 01.04.2009 Download inc/class.ux_sc_mod_tools_em_index.php 1.2 K View 01.04.2009 Download inc/class.ux_t3lib_tcemain.php 10.5 K View 01.04.2009 Download mod1/clear.gif 46 View 01.04.2009 Download mod1/conf.php 1.4 K View 20.04.2009 Download mod1/index.php 9.0 K View 20.04.2009 Download modfunc1/class.tx_partner_reports.php 7.2 K View 20.04.2009 Download modfunc1/class.tx_partner_reports_birthdaylist.php 4.9 K View 20.04.2009 Download modfunc1/class.tx_partner_reports_email.php 7.9 K View 20.04.2009 Download modfunc1/class.tx_partner_reports_relationships.php 8.2 K View 19.05.2009 Download modfunc1/class.tx_partner_search.php 9.4 K View 20.04.2009 Download modfunc1/class.tx_partner_tools.php 3.3 K View 01.04.2009 Download modfunc1/class.tx_partner_tools_assignfeusers.php 13.6 K View 20.04.2009 Download modfunc1/class.tx_partner_tools_massrelationships.php 35 K View 20.04.2009 Download modfunc1/class.tx_partner_tools_reportdesigner.php 4.3 K View 20.04.2009 Download <?php
/***************************************************************
* Copyright notice
*
* (c) 2005 David Bruehlmeier (typo3@bruehlmeier.com)
* 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
* http://www.gnu.org/copyleft/gpl.html.
*
* 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!
***************************************************************/
/**
* Class for updating tx_partner_val_types from tx_partner_val_rel_types
*
* @author David Bruehlmeier <typo3@bruehlmeier.com>
* @package TYPO3
* @subpackage tx_partner
*/
class ext_update {
/**
* Main function, returning the HTML content of the module
*
* @return string HTML
*/
function main() {
$out = '';
$records = $this->getRecords();
if (!t3lib_div::GPvar('do_update')) {
$onClick = "document.location='".t3lib_div::linkThisScript(array('do_update' => 1))."'; return false;";
$out = 'There are '.count($records['tx_partner_val_rel_subtypes']).' relationship subtype records which must be migrated to the new relationship type table (tx_partner_val_rel_types).<br />
There are '.count($records['tx_partner_relationships']).' relationship records where the \'subtype\' field must be migrated into the \'type\' field.';
$out.= $GLOBALS['TBE_TEMPLATE']->spacer(10);
$out.= '<strong><span class="typo3-red">BEWARE!</span></strong><br />';
$out.= 'This action <span class="typo3-red">will change</span> your old data in the tx_partner_relationships table. It will <span class="typo3-red">remove</span> the table tx_partner_val_rel_subtypes and it will <span class="typo3-red">remove</span> the field \'subtype\' from tx_partner_relationships!<br /><br />';
$out.= 'Make sure you have made a <span class="typo3-red"><strong>COMPLETE BACKUP</strong></span> of your data before proceeding!';
$out.= $GLOBALS['TBE_TEMPLATE']->spacer(10);
$out.= 'Do you want to perform the action now?<br />';
$out.= '<form action=""><input type="submit" value="UPDATE" onclick="'.htmlspecialchars($onClick).'"></form>';
} else {
foreach ($records['tx_partner_val_rel_subtypes'] as $theRecord) {
$theRecord['rt_descr_short'] = $theRecord['rs_descr_short'];
unset ($theRecord['rs_descr_short']);
$theRecord['rt_descr'] = $theRecord['rs_descr'];
unset ($theRecord['rs_descr']);
$theRecord['allowed_categories'] = $theRecord['allowed_types'];
unset ($theRecord['allowed_types']);
$GLOBALS['TYPO3_DB']->exec_INSERTquery('tx_partner_val_rel_types',$theRecord);
$GLOBALS['TYPO3_DB']->debug('ext_update->main');
$out.= 'Relationship type record '.$theRecord['rt_descr_short'].' (UID '.$theRecord['uid'].') successfully migrated.<br />';
}
foreach ($records['tx_partner_relationships'] as $theRelationship) {
$update['type'] = $theRelationship['subtype'];
$GLOBALS['TYPO3_DB']->exec_UPDATEquery('tx_partner_relationships','uid='.$theRelationship['uid'],$update);
$GLOBALS['TYPO3_DB']->debug('ext_update->main');
$out.= 'Relationship record with UID '.$theRelationship['uid'].' successfully migrated.<br />';
}
$GLOBALS['TYPO3_DB']->admin_query('ALTER TABLE `tx_partner_relationships` DROP `subtype`');
$GLOBALS['TYPO3_DB']->debug('ext_update->main');
$out.= 'Field \'subtype\' successfully removed from table tx_partner_relationships.<br />';
$GLOBALS['TYPO3_DB']->admin_query('DROP TABLE `tx_partner_val_rel_subtypes`');
$GLOBALS['TYPO3_DB']->debug('ext_update->main');
$out.= 'Table tx_partner_val_rel_subtypes succesfully removed.<br />';
$out.= '<br />Done.';
}
return $out;
}
/**
* Checks if the update function needs to be available at all. It will only be available if there are records
* in the old table tx_partner_val_rel_subtypes and no records in the new table tx_partner_val_rel_types.
*
* @return boolean
*/
function access() {
$out = 0;
$records = $this->getRecords();
if ($records['all_tables']['tx_partner_val_rel_subtypes'] && $records['all_tables']['tx_partner_val_rel_types']) {
if (count($records['tx_partner_val_rel_subtypes']) > 0 and count($records['tx_partner_val_rel_types']) == 0) $out = 1;
}
return $out;
}
/**
* Gets all records from tx_partner_val_rel_subtypes and tx_partner_val_rel_types.
*
* @return array All records from tx_partner_val_rel_subtypes and tx_partner_val_rel_types
*/
function getRecords() {
$out = '';
// Get all tables in the current DB
$out['all_tables'] = $GLOBALS['TYPO3_DB']->admin_get_tables();
if ($out['all_tables']) {
if ($out['all_tables']['tx_partner_val_rel_subtypes']) {
$resOld = $GLOBALS['TYPO3_DB']->exec_SELECTquery('*', 'tx_partner_val_rel_subtypes', '');
if ($resOld) {
while ($rec = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($resOld)) {
$out['tx_partner_val_rel_subtypes'][$rec['uid']] = $rec;
}
}
}
if ($out['all_tables']['tx_partner_val_rel_types']) {
$resNew = $GLOBALS['TYPO3_DB']->exec_SELECTquery('*', 'tx_partner_val_rel_types', '');
if ($resNew) {
while ($rec = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($resNew)) {
$out['tx_partner_val_rel_types'][$rec['uid']] = $rec;
}
}
}
if ($out['all_tables']['tx_partner_relationships']) {
$resRel = $GLOBALS['TYPO3_DB']->exec_SELECTquery('*', 'tx_partner_relationships', '');
if ($resRel) {
while ($rec = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($resRel)) {
$out['tx_partner_relationships'][$rec['uid']] = $rec;
}
}
}
}
return $out;
}
}
if (defined('TYPO3_MODE') && $TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['ext/partner/class.ext_update.php']) {
include_once($TYPO3_CONF_VARS[TYPO3_MODE]['XCLASS']['ext/partner/class.ext_update.php']);
}
?>
