芝麻web文件管理V1.00

编辑当前文件:/home/p/r/i/prismawe/clients/canaldegap.fr_old/modules/CTLModuleMaker/function.createInstall.php

<?php
if(!isset($levels) || !isset($linktables)) exit;

$installmethod = '<?php
if(!isset($gCms)) exit;

// Typical Database Initialization
$db = &$this->cms->db;
$dict = NewDataDictionary($db);
		
// mysql-specific, but ignored by other database
$taboptarray = array("mysql" => "TYPE=MyISAM");
		
';

$leveldepth = 0;
$nblevel = count($levels);

foreach($levels as $level){
// ###################################### BEGINNING OF LEVEL

$leveldepth++;
$installmethod .= '
// Creates the '.$level[0].' table
$flds = "';

$firstfield = true;
foreach($level[4] as $field){
	$fieldtype = $this->GetDBFieldType($field[1], isset($field[5]['listmode'])?$field[5]['listmode']:false);
	if($field[0] == "id") $fieldtype = "I KEY";
	if($field[0] == "active" || $field[0] == "isdefault") $fieldtype = "L";

if(!in_array($field[1],array(11,13))){
		$installmethod .= ($firstfield?"":",").'
	'.$field[0].' '.$fieldtype;
		$firstfield = false;
	}
}
$installmethod .= ',
    date_modified ".CMS_ADODB_DT.",
	date_created ".CMS_ADODB_DT."
	";

$sqlarray = $dict->CreateTableSQL(cms_db_prefix()."module_'.$modulename.'_'.$level[0].'", $flds, $taboptarray);
$dict->ExecuteSQLArray($sqlarray);
$db->CreateSequence(cms_db_prefix()."module_'.$modulename.'_'.$level[0].'_seq");

';
// ###################################### END OF LEVEL
}

foreach($linktables as $linktable){

$installmethod .= '
// Creates the link table '.$linktable[0].'_has_'.$linktable[1].'
$flds = "
	'.$linktable[0].'_id I,
	'.$linktable[1].'_id I
	";

$sqlarray = $dict->CreateTableSQL(cms_db_prefix()."module_'.$modulename.'_'.$linktable[0].'_has_'.$linktable[1].'", $flds, $taboptarray);
$dict->ExecuteSQLArray($sqlarray);

}

if(count($listfields) > 0){

$installmethod .= '
// Create the fieldoptions table
$flds = "
	id I,
	field C(128),
	name C(32),
	item_order I
	";
$sqlarray = $dict->CreateTableSQL(cms_db_prefix()."module_'.$modulename.'_fieldoptions", $flds, $tabopt);
$dict->ExecuteSQLArray($sqlarray);
$db->CreateSequence(cms_db_prefix()."module_'.$modulename.'_fieldoptions_seq");

}

if(count($multiplefiles) > 0) {

$installmethod .= '
// Creates the table for multiple files
$flds = "
    fileid I,
	itemid I,
	fieldname C(64),
	filepath C(255)
	";

$sqlarray = $dict->CreateTableSQL(cms_db_prefix()."module_'.$modulename.'_multiplefilesfields", $flds, $taboptarray);
$dict->ExecuteSQLArray($sqlarray);
$db->CreateSequence(cms_db_prefix()."module_'.$modulename.'_multiplefilesfields_seq");

}

$installmethod .= '

// Creates the queries table
$flds = "
    id I,
	name C(64),
	what C(32),
	whereclause C(255),
	wherevalues C(255),
	queryorder C(32)
	";

$sqlarray = $dict->CreateTableSQL(cms_db_prefix()."module_'.$modulename.'_saved_queries", $flds, $taboptarray);
$dict->ExecuteSQLArray($sqlarray);
$db->CreateSequence(cms_db_prefix()."module_'.$modulename.'_saved_queries_seq");

// INSERTING DEFAULT TEMPLATES
	$template = \'<h2>{$leveltitle}</h2>
{if $itemcount > 0}
<ul>
{foreach from=$itemlist item="item"}
	<li {if $item->is_selected}class="active"{/if}>{$item->detaillink}</li>
{/foreach}
</ul>
{if $page_pagenumbers}
<div id="pagemenu" style="text-align: center;">
{$page_previous}  {$page_showing}/{$page_totalitems}  {$page_next}<br/>
{$page_pagenumbers}
</div>
{/if}
{else}
<p>{$error_msg}</p>
{/if}
\';
$this->SetTemplate("list_default",$template,$this->GetName());';
$lastlevel = false;
foreach($levels as $level){
	$lastlevel = $level;
	$installmethod .= '
    $this->SetPreference("listtemplate_'.$level[0].'","list_default");';
}
if($infos['templatelevel'] == 0){
	$template = '<h3>{$item->name}</h3>
';
	$defaultfields = $this->GetDefaultFields();
	foreach($lastlevel[4] as $field){
		if(!in_array($field[0],$defaultfields)){
			switch($field[1]){
				case 6:
				case 7:
					$template .= '<p>{$labels->'.$field[0].'}: ';
					if($field[5]['listmode'] == 1 || $field[5]['listmode'] == 3){
						$template .= '{$item->'.$field[0].'_namevalue}</p>
';	
					}else{
						$template .= '
{foreach from=$item->'.$field[0].'_namevalue item="onevalue"}{if $tmpflag}, {/if}{$onevalue}{assign var="tmpflag" value=true}{/foreach}</p>
';
					}
					break;
				case 12:
					$template .= '{if $item->'.$field[0].'}<p>{$labels->'.$field[0].'}</p>{/if}
';
					break;
				case 8:
					$template .= '{if $item->'.$field[0].' != ""}<p>{$item->'.$field[0].'->image}</p>{/if}
';
					break;
				case 9:
					$template .= '{if $item->'.$field[0].' != ""}<p>{$labels->'.$field[0].'}: <a href="{$item->'.$field[0].'->url}">{$item->'.$field[0].'->filepath}</a> ({$item->'.$field[0].'->size_wformat})</p>{/if}
';
					break;
				case 11:
					$template .= '{if count($item->'.$field[0].') > 0}<br/>
	<fieldset><legend>{$labels->'.$field[0].'}:</legend>
		<ul>{foreach from=$item->'.$field[0].' item="file"}
			<li><a href="{$file->url}">{$file->filepath}</a> ({$file->size_wformat})</li>
		{/foreach}</ul>
	</fieldset><br/>
{/if}
';
					break;
				case 13:
					$hasthumb = ($field[5]["thumb"] != '');
					$template .= '{if count($item->'.$field[0].') > 0}<br/>
	<fieldset><legend>{$labels->'.$field[0].'}:</legend><ul>
		{foreach from=$item->'.$field[0].' item="file"}
			<li>'.($hasthumb?'<a href="{$file->url}"><img src="{$file->thumbnail}" border="0" alt=""/></a>':'<a href="{$file->url}">{$file->filepath}</a> ({$file->imagesize}, {$file->size_wformat})').'
		{/foreach}</ul>
	</fieldset><br/>
{/if}
';
					break;
				default:
					$template .= '<p>{$labels->'.$field[0].'}:'.($field[1]==5?'<br/>':' ').'{$item->'.$field[0].'}</p>
';
					break;
			}
		}
	}
	$installmethod .= '

$template = \''.$template.'\';
$this->SetTemplate("final_default",$template,$this->GetName());
$this->SetPreference("finaltemplate","final_default");
';
}

$installmethod .= '
$template = \'<p>{$error_msg}</p>
{if $backlink}<p>{$backlink}</p>{/if}\';
$this->SetTemplate("no_result",$template,$this->GetName());

// CREATING PERMISSIONS :

// permissions
$this->CreatePermission("'.$modulename.'_normaluser", "'.$modulename.': Normal user");
$this->CreatePermission("'.$modulename.'_advanced", "'.$modulename.': Advanced");';

$defprefs = '';
foreach($levels as $level){
	$installmethod .= '
	$this->CreatePermission("'.$modulename.'_manage_'.$level[0].'", "'.$modulename.': Manage '.$level[0].'");';
	$defprefs .= '"tabdisplay_'.$level[0].'","searchmodule_index_'.$level[0].'",';
	if($level[8])	$defprefs .= '"newitemsfirst_'.$level[0].'",';
}
if(isset($infos["editablealias"]) && $infos["editablealias"])	$defprefs .= '"editablealias",';
if(isset($infos["deletefiles"]) && $infos["deletefiles"])	$defprefs .= '"deletefiles",';
$installmethod .= '
// activating default preferences
	$defprefs = array('.$defprefs.'"restrict_permissions","orderbyname","display_filter","display_instantsearch","display_instantsort","showthumbnails","load_nbchildren","use_session");
	foreach($defprefs as $onepref)	$this->SetPreference($onepref,true);
	$this->SetPreference("emptytemplate","**");

// events
	$this->CreateEvent("'.$modulename.'_added");
	$this->CreateEvent("'.$modulename.'_modified");
	$this->CreateEvent("'.$modulename.'_deleted");
	
// prepare information for an eventual upgrade
	$this->SetPreference("makerversion","'.$this->GetVersion().'");

// put mention into the admin log
	$this->Audit( 0, $this->Lang("friendlyname"), $this->Lang("installed",$this->GetVersion()));

?'.'>
';