芝麻web文件管理V1.00

编辑当前文件:/home/prismawe/clients/canaldegap.fr_old/modules/jurisprudences/method.install.php

<?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");

// Creates the categorie table
$flds = "
	description X,
	id I KEY,
	name C(64),
	alias C(64),
	item_order I,
	active L,
	isdefault L,
    date_modified ".CMS_ADODB_DT.",
	date_created ".CMS_ADODB_DT."
	";

$sqlarray = $dict->CreateTableSQL(cms_db_prefix()."module_jurisprudences_categorie", $flds, $taboptarray);
$dict->ExecuteSQLArray($sqlarray);
$db->CreateSequence(cms_db_prefix()."module_jurisprudences_categorie_seq");

// Creates the jugement table
$flds = "
	question X,
	clefs C(255),
	juridiction C(255),
	dossier C(255),
	datejuge ".CMS_ADODB_DT.",
	resume X,
	fichier1 C(255),
	fichier2 C(255),
	parent I,
	id I KEY,
	name C(64),
	alias C(64),
	item_order I,
	active L,
	isdefault L,
    date_modified ".CMS_ADODB_DT.",
	date_created ".CMS_ADODB_DT."
	";

$sqlarray = $dict->CreateTableSQL(cms_db_prefix()."module_jurisprudences_jugement", $flds, $taboptarray);
$dict->ExecuteSQLArray($sqlarray);
$db->CreateSequence(cms_db_prefix()."module_jurisprudences_jugement_seq");

// 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_jurisprudences_saved_queries", $flds, $taboptarray);
$dict->ExecuteSQLArray($sqlarray);
$db->CreateSequence(cms_db_prefix()."module_jurisprudences_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());
    $this->SetPreference("listtemplate_categorie","list_default");
    $this->SetPreference("listtemplate_jugement","list_default");

$template = '<h3>{$item->name}</h3>
<p>{$labels->question}:<br/>{$item->question}</p>
<p>{$labels->clefs}: {$item->clefs}</p>
<p>{$labels->juridiction}: {$item->juridiction}</p>
<p>{$labels->dossier}: {$item->dossier}</p>
<p>{$labels->datejuge}: {$item->datejuge}</p>
<p>{$labels->resume}:<br/>{$item->resume}</p>
{if $item->fichier1 != ""}<p>{$labels->fichier1}: <a href="{$item->fichier1->url}">{$item->fichier1->filepath}</a> ({$item->fichier1->size_wformat})</p>{/if}
{if $item->fichier2 != ""}<p>{$labels->fichier2}: <a href="{$item->fichier2->url}">{$item->fichier2->filepath}</a> ({$item->fichier2->size_wformat})</p>{/if}
';
$this->SetTemplate("final_default",$template,$this->GetName());
$this->SetPreference("finaltemplate","final_default");

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

// CREATING PERMISSIONS :

// permissions
$this->CreatePermission("jurisprudences_normaluser", "jurisprudences: Normal user");
$this->CreatePermission("jurisprudences_advanced", "jurisprudences: Advanced");
	$this->CreatePermission("jurisprudences_manage_categorie", "jurisprudences: Manage categorie");
	$this->CreatePermission("jurisprudences_manage_jugement", "jurisprudences: Manage jugement");
// activating default preferences
	$defprefs = array("tabdisplay_categorie","searchmodule_index_categorie","tabdisplay_jugement","searchmodule_index_jugement","newitemsfirst_jugement","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("jurisprudences_added");
	$this->CreateEvent("jurisprudences_modified");
	$this->CreateEvent("jurisprudences_deleted");
	
// prepare information for an eventual upgrade
	$this->SetPreference("makerversion","1.8.9.3");

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