芝麻web文件管理V1.00

编辑当前文件:/home/p/r/i/prismawe/clients/canaldegap.fr_old/modules/faq/action.editterm.php

<?php
if (!isset($gCms)) exit;
$admintheme = $gCms->variables["admintheme"];
if(isset($params["cancel"]) || ($this->GetPreference("restrict_permissions",false) && !$this->CheckPermission("faq_advanced") && !$this->CheckPermission("faq_manage_terme")) ){
	$newparams = array("active_tab" => "terme");
	if(!isset($params["cancel"]))	$newparams["module_message"] = $this->Lang("error_denied");
	$this->Redirect($id, "defaultadmin", $returnid, $newparams);
}

$db =& $this->GetDb();

if($this->GetPreference("use_hierarchy",false)){
	$parentoptions = $this->get_admin_hierarchyoptions("terme",false);
}else{
	$parentoptions = $this->get_options("rubrique");
}
if( isset($params["deletefile"]) && $params["deletefile"] > 0 ){
	// this is for the multiple files fields (additionnal tabs)
	$query = "DELETE FROM ".cms_db_prefix()."module_faq_multiplefilesfields WHERE fileid=? LIMIT 1";
	if($db->Execute( $query, array($params["deletefile"]) ))	echo $this->ShowMessage($this->Lang("message_modified"));
}

if(isset($params["termid"])) {
	// if we are working on an item that exists, we load it. We must do this even when the form is submitted, otherwise we won't have the file fields
	$items = $this->get_level_terme(array("id"=>$params["termid"]));
	$item = $items[0];
}

// CHECK IF THE FORM IS BEING SUBMITTED :
// (we must detect all kinds of submit buttons, including files, since information must be saved before we go to file submission)
if (isset($params["submit"]) || 
	isset($params["apply"]) 
	)
{
	debug_buffer("Edit Form has been submitted".__LINE__);

// RETRIEVING THE FORM VALUES (and escaping it, if needed)
	if(!isset($item)) $item = new stdClass();
	if(isset($params["termitem_order"])) $item->item_order = $params["termitem_order"];
	$item->definition = $params["termdefinition"];
		$item->parent = $params["termparent"];
		$item->name = $params["termname"];
		
	if($this->GetPreference("editable_aliases",false)){
		if(isset($params["termalias"])){
			$tmpalias = $this->plcreatealias(trim($params["termalias"]));
			$item->alias = $tmpalias == ""?$this->plcreatealias($item->name):$tmpalias;
		}else{
			$item->alias = $this->plcreatealias($item->name);
		}
	}else{
		$item->alias = $this->plcreatealias($item->name);
	}
	
	$autoincrementalias = $this->GetPreference("autoincrement_alias",false);

// CHECK IF THE NEEDED VALUES ARE THERE
	if(	!isset($params["termdefinition"]) || $params["termdefinition"] == ""
		 || !isset($params["termname"]) || $params["termname"] == ""
		 )
	{
		echo $this->ShowErrors($this->Lang("error_missginvalue"));
	}elseif(!$autoincrementalias && false == $this->checkalias("module_faq_terme", $item->alias, isset($params["termid"])?$params["termid"]:false)){
		echo $this->ShowErrors($this->Lang("error_alreadyexists"));
	}else{
		############ DOING THE UPDATE

if($autoincrementalias){
			$basealias = $item->alias;
			$tmpalias = $item->alias;
			$i = 1;
			while(!$this->checkalias("module_faq_terme", $tmpalias, isset($params["termid"])?$params["termid"]:false)){
				$tmpalias = $basealias."_".$i;
				$i++;
			}
			$item->alias = $tmpalias;
		}

// FIELDS TO UPDATE
		$query = (isset($item->id)?"UPDATE ":"INSERT INTO ").cms_db_prefix()."module_faq_terme SET 
			definition=?,
			parent=?,
			name=?,
		alias=?,
		date_modified=?,
		active=".(isset($item->active)?$item->active:1).",
		isdefault=".(isset($item->isdefault)?$item->isdefault:0)."";
			
		// VALUES
		$values = array($item->definition,
			$item->parent,
			addslashes($item->name),$item->alias,str_replace("'","",$db->DBTimeStamp(time())));

if(isset($item->id)){
			$event = "faq_modified";
			$query .= " WHERE id=?;";
			array_push($values,$item->id);
		}else{
			// NEW ITEM
			$query .= ", date_created=?";
			$values[] = str_replace("'","",$db->DBTimeStamp(time()));
			$event = "faq_added";
			// get a new id from the sequence table
			$item->id = $db->GenID(cms_db_prefix()."module_faq_terme_seq");
			if($this->GetPreference("newitemsfirst_terme",false)){
				// new items get to the top - so we must put all other items down from one step, and then set this item's order to 1
				$query2 = "UPDATE ".cms_db_prefix()."module_faq_terme SET item_order=(item_order+1) WHERE parent=?";
				$db->Execute($query2, array($item->parent));
				$query .= ",item_order=1, id=".$item->id;
			}else{
				// new items get to the bottom - so we must set the item_order to the number of items + 1
				$item_order = $this->countsomething("terme","id",array("parent"=>$item->parent)) + 1;
				$query .= ",item_order=".$item_order.", id=".$item->id;
			}
		}
		$db->Execute($query, $values);

if(isset($params["oldparent"]) && $params["oldparent"] != $item->parent){
		// the item is changing parent, and we're ordering by parents
		
		if($this->GetPreference("newitemsfirst_terme",false)){
			// new items get to the top
			
			// UPDATE THE ORDER OF THE ITEMS WITH THE OLD PARENT
			$query = "UPDATE ".cms_db_prefix()."module_faq_terme SET item_order=(item_order-1) WHERE item_order > ? AND parent=?";
			$db->Execute($query, array($item->item_order, $params["oldparent"]));
			// GET NEW ITEM ORDER
			$item->item_order = $this->countsomething("terme","id",array("parent"=>$item->parent)) + 1;
			$query = "UPDATE ".cms_db_prefix()."module_faq_terme SET item_order=? WHERE id=?";
			$db->Execute($query, array($item->item_order, $item->id));

}else{

// UPDATE THE ORDER OF THE ITEMS WITH THE OLD PARENT
			$query = "UPDATE ".cms_db_prefix()."module_faq_terme SET item_order=(item_order-1) WHERE item_order > ? AND parent=?";
			$db->Execute($query, array($item->item_order, $params["oldparent"]));
			// UPDATE NEW PARENT
			$query = "UPDATE ".cms_db_prefix()."module_faq_terme SET item_order=(item_order+1) WHERE parent=?";
			$db->Execute($query, array($item->parent));
			// GET NEW ITEM ORDER
			$item->item_order = 1;
			$query = "UPDATE ".cms_db_prefix()."module_faq_terme SET item_order=? WHERE id=?";
			$db->Execute($query, array($item->item_order, $item->id));
		
		}
	}

$redirect = true;
		//if(mysql_affected_rows()){	// mysql-only
		if($db->Affected_Rows()){
			if($this->GetPreference("searchmodule_index_terme",false)){
				// IF ANYTHING WAS MODIFIED, WE MUST UPDATE THE SEARCH INDEX AND SEND AN EVENT...
				if(isset($event))	$this->SendEvent($event, array("what"=>"terme", "itemid" => $item->id, "alias"=>$item->alias));
				debug_buffer("SEARHC INDEX WAS UPDATED ".__LINE__);
				$module =& $this->GetModuleInstance("Search");
				if($module) {
					$text = "$item->definition $item->name";
					$module->AddWords($this->GetName(), $item->id, "terme", $text, NULL);
				}
			}
		}elseif(mysql_error()){
			// do not redirect :
			$redirect = false;
			echo $this->ShowErrors(mysql_error());
		}

// REDIRECTING...
			if($redirect == false){
			}elseif(isset($params["apply"])){
				echo $this->ShowMessage($this->Lang("message_modified"));
			}else{
				$params = array("module_message" => $this->Lang("message_modified"), "active_tab"=>"terme");
				$this->Redirect($id, "defaultadmin", $returnid, $params);	
			}
	}
	// END OF FORM SUBMISSION
}

/* ## PREPARING SMARTY ELEMENTS
CreateInputText : (id,name,value,size,maxlength)
CreateTextArea : (wysiwyg,id,text,name)
CreateInputSelectList : (id,name,items,selecteditems,size)
CreateInputDropdown : (id,name,items,sindex,svalue)
*/

$this->smarty->assign("definition_label", $this->Lang("terme_definition"));
$this->smarty->assign("definition_input", $this->CreateTextArea(true,$id,isset($item)?$item->definition:"","termdefinition"));
$this->smarty->assign("name_label", $this->Lang("name"));
$this->smarty->assign("name_input", $this->CreateInputText($id,"termname",isset($item)?$item->name:"",50,64));
$this->smarty->assign("parent_label", $this->Lang("rubrique"));
$this->smarty->assign("parent_input", $this->CreateInputDropdown($id,"termparent",$parentoptions,-1,isset($item)?$item->parent:0));if(isset($item)) $this->CreateInputHidden($id, "oldparent", $item->parent);
if($this->GetPreference("editable_aliases",false)){
	$this->smarty->assign("alias_label", $this->Lang("alias"));
	$this->smarty->assign("alias_input", $this->CreateInputText($id,"termalias",isset($item)?$item->alias:"",50,64));
	$this->smarty->assign("itemalias",false);
}else{
	$this->smarty->assign("itemalias",isset($item->alias)?"(alias : ".$item->alias.")":false);
	$this->smarty->assign("alias_input", false);
}

$this->smarty->assign("edittitle", $this->Lang("edit_terme"));

$this->smarty->assign("submit", $this->CreateInputSubmit($id, "submit", lang("submit")));
$this->smarty->assign("apply", (isset($item) && isset($item->id))?$this->CreateInputSubmit($id, "apply", lang("apply")):"");
$this->smarty->assign("cancel", $this->CreateInputSubmit($id, "cancel", lang("cancel")));

// DISPLAYING
if(isset($item) && isset($item->id)){
	$this->smarty->assign("filter", false);
	$this->smarty->assign("reorder", false);
	$this->smarty->assign("instantsearch", false);
	$this->smarty->assign("tableid", false);
	
	$tab = isset($params["active_tab"])?$params["active_tab"]:"terme";
	echo $this->StartTabHeaders();
		echo $this->SetTabHeader("terme", $this->Lang("terme"), ($tab=="terme"?true:false));echo $this->SetTabHeader("fichiers", $this->Lang("terme_fichiers"), ($tab=="fichiers"?true:false));
		
	echo $this->EndTabHeaders();
	echo $this->StartTabContent();
	echo $this->StartTab("terme");

echo $this->CreateFormStart($id, "editterm", $returnid);
		echo $this->ProcessTemplate("editterm.tpl");
		echo $this->CreateInputHidden($id, "termid", $item->id);
		if(isset($item) && isset($item->parent)) echo $this->CreateInputHidden($id, "oldparent", $item->parent);
		echo $this->CreateInputHidden($id, "termitem_order", $item->item_order);
		echo $this->CreateFormEnd();
	
	echo $this->EndTab();
	
	echo $this->StartTab("fichiers");
		$newparams = array("termid"=>$item->id,"field"=>"terme_fichiers","tablename"=>"faq_multiplefilesfields","prefix"=>"term", "startdir"=>"uploads/pdf/", "addfiles"=>true, "active_tab"=>"fichiers","mode"=>"other");
		echo "<p>".$this->Lang("warning_tab")."</p>";
		$item->fichiers = $this->getaddfiles("terme_fichiers",$item->id,true);
		if(count($item->fichiers)>0){			
			$this->smarty->assign("addnew", $this->CreateLink($id, "browsefiles", $returnid, $admintheme->DisplayImage("icons/system/newobject.gif", "","","","systemicon")." ".$this->Lang("addafile"), $newparams));
			$adminshow = array(	array($this->Lang("filename"), "thelink"), array($this->Lang("filesize"), "size_wformat"), array($this->Lang("Actions"), "deletelink")	);
			$itemlist = array();
			foreach($item->fichiers as $addfile){
				$addfile->thelink = $addfile->pic.' <a href="../uploads'.$addfile->filepath.'" target="blank">'.$addfile->filepath."</a>";
				$addfile->deletelink = $this->CreateLink($id, "editterm", $returnid, $admintheme->DisplayImage("icons/system/delete.gif", $this->lang("delete"),"","","systemicon"), array("termid"=>$item->id, "deletefile"=>$addfile->fileid, "active_tab"=>"fichiers"));
				$itemlist[] = $addfile;
			}
			$this->smarty->assign("itemlist", $itemlist);
			$this->smarty->assign("adminshow", $adminshow);			
			echo $this->ProcessTemplate("adminpanel.tpl");
			
		}else{
			echo "<p>".$this->CreateLink($id, "browsefiles", $returnid, $admintheme->DisplayImage("icons/system/newobject.gif", "","","","systemicon")." ".$this->Lang("addafile"), $newparams)."</p>";
		}
	echo $this->EndTab();
	
	echo $this->EndTabContent();

}else{
	echo $this->CreateFormStart($id, "editterm", $returnid);
	echo $this->ProcessTemplate("editterm.tpl");
	echo $this->CreateFormEnd();
}
?>