Gecko [ www.bigdataconsulting.fr ]

Name	Size	Permission	Date
ajax	[ DIR ]	drwxr-xr-x	2023-12-15 13:44
boxes	[ DIR ]	drwxr-xr-x	2023-12-15 13:44
class	[ DIR ]	drwxr-xr-x	2023-12-15 13:44
data	[ DIR ]	drwxr-xr-x	2023-12-15 13:44
db	[ DIR ]	drwxr-xr-x	2023-12-15 13:44
filemanagerdol	[ DIR ]	drwxr-xr-x	2023-12-15 13:44
js	[ DIR ]	drwxr-xr-x	2023-12-15 13:44
lib	[ DIR ]	drwxr-xr-x	2023-12-15 13:44
login	[ DIR ]	drwxr-xr-x	2023-12-15 13:44
menus	[ DIR ]	drwxr-xr-x	2023-12-15 13:44
modules	[ DIR ]	drwxr-xr-x	2023-12-15 13:44
tpl	[ DIR ]	drwxr-xr-x	2023-12-15 13:44
triggers	[ DIR ]	drwxr-xr-x	2023-12-15 13:44
actions_addupdatedelete.inc.php	19.69 KB	-rw-r--r--	2023-12-15 13:44
actions_builddoc.inc.php	5.57 KB	-rw-r--r--	2023-12-15 13:44
actions_changeselectedfields.inc.php	1.57 KB	-rw-r--r--	2023-12-15 13:44
actions_comments.inc.php	2.55 KB	-rw-r--r--	2023-12-15 13:44
actions_dellink.inc.php	2.58 KB	-rw-r--r--	2023-12-15 13:44
actions_extrafields.inc.php	12.94 KB	-rw-r--r--	2023-12-15 13:44
actions_fetchobject.inc.php	2.03 KB	-rw-r--r--	2023-12-15 13:44
actions_lineupdown.inc.php	2.57 KB	-rw-r--r--	2023-12-15 13:44
actions_linkedfiles.inc.php	13.71 KB	-rw-r--r--	2023-12-15 13:44
actions_massactions.inc.php	64.01 KB	-rw-r--r--	2023-12-15 13:44
actions_printing.inc.php	3.29 KB	-rw-r--r--	2023-12-15 13:44
actions_sendmails.inc.php	19.03 KB	-rw-r--r--	2023-12-15 13:44
actions_setmoduleoptions.inc.php	5.35 KB	-rw-r--r--	2023-12-15 13:44
actions_setnotes.inc.php	3.95 KB	-rw-r--r--	2023-12-15 13:44
antispamimage.php	1.9 KB	-rw-r--r--	2023-12-15 13:44
bookmarks_page.php	6.12 KB	-rw-r--r--	2023-12-15 13:44
commonfieldsinexport.inc.php	2.01 KB	-rw-r--r--	2023-12-15 13:44
commonfieldsinimport.inc.php	2.01 KB	-rw-r--r--	2023-12-15 13:44
customreports.php	63.3 KB	-rw-r--r--	2023-12-15 13:44
datepicker.php	9.55 KB	-rw-r--r--	2023-12-15 13:44
doxygen.php	1.74 KB	-rw-r--r--	2023-12-15 13:44
extrafieldsinexport.inc.php	2.88 KB	-rw-r--r--	2023-12-15 13:44
extrafieldsinimport.inc.php	2.89 KB	-rw-r--r--	2023-12-15 13:44
get_info.php	8.04 KB	-rw-r--r--	2023-12-15 13:44
get_menudiv.php	8.24 KB	-rw-r--r--	2023-12-15 13:44
multicompany_page.php	5.21 KB	-rw-r--r--	2023-12-15 13:44
photos_resize.php	23.26 KB	-rw-r--r--	2023-12-15 13:44
search.php	4.94 KB	-rw-r--r--	2023-12-15 13:44
search_page.php	4.96 KB	-rw-r--r--	2023-12-15 13:44
tools.php	1.59 KB	-rw-r--r--	2023-12-15 13:44
website.inc.php	11.99 KB	-rw-r--r--	2023-12-15 13:44

Rename

<?php

// $keyforselect = name of main table
// keyforelement = name of picto
// $keyforaliasextra = a key to avoid conflict with extrafields of other objects

if (empty($keyforselect) || empty($keyforelement) || empty($keyforaliasextra)) {
	//print $keyforselet.' - '.$keyforelement.' - '.$keyforaliasextra;
	dol_print_error('', 'include of file extrafieldsinexport.inc.php was done but var $keyforselect or $keyforelement or $keyforaliasextra was not set');
	exit;
}

// Add extra fields
$sql = "SELECT name, label, type, param, fieldcomputed, fielddefault FROM ".MAIN_DB_PREFIX."extrafields";
$sql .= " WHERE elementtype = '".$this->db->escape($keyforselect)."' AND type <> 'separate' AND entity IN (0, ".((int) $conf->entity).') ORDER BY pos ASC';
//print $sql;
$resql = $this->db->query($sql);
if ($resql) {    // This can fail when class is used on old database (during migration for example)
	while ($obj = $this->db->fetch_object($resql)) {
		$fieldname = $keyforaliasextra.'.'.$obj->name;
		$fieldlabel = ucfirst($obj->label);
		$typeFilter = "Text";
		$typefield = preg_replace('/\(.*$/', '', $obj->type); // double(24,8) -> double
		switch ($typefield) {
			case 'int':
			case 'integer':
			case 'double':
			case 'price':
				$typeFilter = "Numeric";
				break;
			case 'date':
			case 'datetime':
			case 'timestamp':
				$typeFilter = "Date";
				break;
			case 'boolean':
				$typeFilter = "Boolean";
				break;
			case 'checkbox':
			case 'select':
				if (!empty($conf->global->EXPORT_LABEL_FOR_SELECT)) {
					$tmpparam = jsonOrUnserialize($obj->param); // $tmpparam may be array with 'options' = array(key1=>val1, key2=>val2 ...)
					if ($tmpparam['options'] && is_array($tmpparam['options'])) {
						$typeFilter = "Select:".$obj->param;
					}
				}
				break;
			case 'sellist':
				$tmp = '';
				$tmpparam = jsonOrUnserialize($obj->param); // $tmp may be array 'options' => array 'c_currencies:code_iso:code_iso' => null
				if (is_array($tmpparam) && array_key_exists('options', $tmpparam) &&  $tmpparam['options'] && is_array($tmpparam['options'])) {
					$tmpkeys = array_keys($tmpparam['options']);
					$tmp = array_shift($tmpkeys);
				}
				if (preg_match('/[a-z0-9_]+:[a-z0-9_]+:[a-z0-9_]+/', $tmp)) {
					$typeFilter = "List:".$tmp;
				}
				break;
		}
		if ($obj->type != 'separate') {
			// If not a computed field
			if (empty($obj->fieldcomputed)) {
				$this->export_fields_array[$r][$fieldname] = $fieldlabel;
				$this->export_TypeFields_array[$r][$fieldname] = $typeFilter;
				$this->export_entities_array[$r][$fieldname] = $keyforelement;
			} else {
				// If this is a computed field
				$this->export_fields_array[$r][$fieldname] = $fieldlabel;
				$this->export_TypeFields_array[$r][$fieldname] = $typeFilter.'Compute';
				$this->export_special_array[$r][$fieldname] = $obj->fieldcomputed;
				$this->export_entities_array[$r][$fieldname] = $keyforelement;
			}
		}
	}
}
// End add axtra fields