| |
|
|
| | Здрасте всем:):)
До меня кто-то уже написал код, а я должна заставить заработать:((
<?//security and other functions
require('includes/application_top.php');
tep_check_permissions('MAITENANCE_CATEGORIES', true);
//currencies
require(DIR_WS_CLASSES . 'currencies.php');
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/general.js"></script>
<script>
function validar(){
if(newoption.newoptionname.value.length==0){
alert("Please Insert the Option name");
return false;
}
return true;
}
function validatedit(){
if(editoption.editfield.value.length==0){
alert("Please Insert the new Option name");
return false;
}
return true;
}
function confirmdelete(url, action, optionid){
var agree=confirm("Do you really want to delete the option?");
if(agree)
self.location.href=url+'?action='+action+'&optionid='+optionid;
return false;
}
function editfield(url, action, optionid, page, url_add){
self.location.href=url+'?action='+action+'&optionid='+optionid+'&pagina='+page+url_add;
return false;
}
</script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onload="SetFocus();">
<div id="spiffycalendar" class="text"></div>
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->
<!-- body //-->
<table border="1" width="100%" cellspacing="2" cellpadding="2">
<tr>
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</table></td>
<td valign="top">
<!-- body_text //-->
<table width="100%">
<tr class="pageHeading"><td>Categories</td></tr>
<?php
echo "<tr><td> ";
//*************************PHP SCRIPT FOR ACTIONS*********************************
$action=$_GET["action"];
$b_search = false; //added by Dikla 04/11/09
$url_add='';
if($action=="addoption"){
$newoption=tep_db_prepare_input($_GET["newoptionname"]);
$newoptioncode=tep_db_prepare_input($_GET["newoptioncode"]);
$duplicate=tep_db_query("SELECT event_category_id, event_category_name FROM " . TABLE_EVENT_CATEGORY_TYPES . " WHERE event_category_name='".$newoption."'");
if(tep_db_num_rows($duplicate)){
$dupli=mysql_fetch_array($duplicate);
echo "<span class='smallText'><font color='red' face='verdana, arial, tahoma'>The option '".$dupli['event_category_name'] ."' already exists with ID ".$dupli['event_category_id']."</font>";
}else{
$data_query=array("event_category_name"=>$newoption,
"event_category_code"=>$newoptioncode );
if(tep_check_permissions('MAITENANCE_CATEGORIES')<=2 && tep_check_permissions('MAITENANCE_CATEGORIES') != false)
$success=tep_db_perform(TABLE_EVENT_CATEGORY_TYPES,$data_query);
if($success){
$newoptionid=tep_db_insert_id();
echo "<span class='smallText'><font color='red' face='verdana, arial, tahoma'>Option inserted successfully (new ID: ".$newoptionid.") </font>";
}//end success
}//end num rows
mysql_free_result($duplicate);
}else if($action=="delete"){
$optionid=$_GET["optionid"];
$optionused=tep_db_query("SELECT count(event_ticket_id) FROM " . TABLE_EVENT_TICKETS . " WHERE event_ticket_category_id=".$optionid);
if(tep_db_num_rows($optionused)){
echo "<span class='smallText'><font color='red' face='verdana, arial, tahoma'>This option is being used in other events. It cannot be deleted. </font>";
}else{
if(tep_check_permissions('MAITENANCE_CATEGORIES') == 1)
$delete=tep_db_query("DELETE FROM " . TABLE_EVENT_CATEGORY_TYPES . " WHERE event_category_id=".$optionid);
if($delete){
echo "<span class='smallText'><font color='red' face='verdana, arial, tahoma'>Option deleted successfully</font>";
}
}
}else if($action=="edit"){
$newoptionname=$_GET["editfield"];
$newoptioncode=$_GET["editcode"];
$optionid=$_GET['optionid'];
$duplicate=tep_db_query("SELECT event_category_id, event_category_name, event_category_code FROM " . TABLE_EVENT_CATEGORY_TYPES . " WHERE event_category_name='".$newoptionname."' AND event_category_code='".$newoptioncode."'");
if(tep_db_num_rows($duplicate)){
$dupli=mysql_fetch_array($duplicate);
echo "<span class='smallText'><font color='red' face='verdana, arial, tahoma'>ATTENTION: The option '".$dupli['event_category_name'] ."' already exists with ID ".$dupli['event_category_id'].". Option not edited.</font>";
}else{
if(tep_check_permissions('MAITENANCE_CATEGORIES') == 1)
$editsuccess=tep_db_query("UPDATE " . TABLE_EVENT_CATEGORY_TYPES . " SET event_category_name='".$newoptionname."',event_category_code='".$newoptioncode."' WHERE event_category_id=".$optionid);
if($editsuccess){
echo "<span class='smallText'><font color='red' face='verdana, arial, tahoma'>Option edited successfully</font>";
}
}
//**Dikla 04/11/09
}
if($_GET['search']=="true"){
$term = $_GET["q"];
if ($term != "")
{
$b_search = true;
$q=$term;
$q = strtoupper($q);
$url_add = "&search=true&q=".$term;
}
}
if($b_search)
echo '<span class="main"><br><b>Search Results for "'.$term.'" :<b><br></span>';
//end of change
//******************************* END PHP SCRIPT *******************************
echo "</td></tr>";
?>
<?php
if(tep_check_permissions('MAITENANCE_CATEGORIES') < 3 && tep_check_permissions('MAITENANCE_CATEGORIES') >=1){ ?>
<tr><td colspan="3">
<form action="products_attributes.php" name="newoption" onSubmit="return validar();" method="GET">
<input type="hidden" name="action" value="addoption">
<span class="main">New option: </span>
<input type="text" name="newoptionname" maxlength="32">
<span class="main">New option Code: </span>
<input type="text" name="newoptioncode" maxlength="10" size="10">
<input type="submit" value="Add">
</form>
</td>
</tr>
<!-- Dikla 04/11/09-->
<tr><td colspan="3">
<div style="background-color:#DBE4F5;width:35%;padding-left:5px" >
<form action="<?=$_SERVER['PHP_SELF']?>" name="search" method="GET">
<input type="hidden" name="search" value="true">
<span class="main">Search Categories: </span>
<input type="text" name="q" maxlength="32">
<input type="submit" value="Search">
<?php if($b_search){ ?>
<a href="products_attributes.php" ><input type="button" value="Back"></a>
<?php }?>
</form></div>
</td>
</tr>
<!-- end of change -->
<?php
}
$MAX_RESULTADOS=30;
$pagina=$_GET['pagina'];
if(!$pagina){
$pagina=1;
}
$startquery=($pagina-1)*$MAX_RESULTADOS;
$endquery=$MAX_RESULTADOS;
//**Dikla 04/11/09
if($b_search){
$query="SELECT event_category_id, event_category_name, event_category_code FROM " . TABLE_EVENT_CATEGORY_TYPES ." WHERE upper(event_category_name) LIKE '%$q%' OR upper(event_category_code) LIKE '%$q%' ORDER BY event_category_name";
}else{
$query="SELECT event_category_id, event_category_name, event_category_code FROM " . TABLE_EVENT_CATEGORY_TYPES ." ORDER BY event_category_name";
}
//we first want to know how many options there are on the database
$numoptions=tep_db_query($query);
$nop=tep_db_num_rows($numoptions);
mysql_free_result($numoptions);
$totalpages=ceil($nop/$MAX_RESULTADOS);
//then we will limit the results and show them by pages
$query.=" LIMIT ".$startquery.", ". $endquery;
$optionsondb=tep_db_query($query);
?>
<tr class="smallText"><td>Pages:
<?
for($pag=1;$pag<=$totalpages;$pag++){
if($pag!=$pagina)
echo "<a href='".$_SERVER['PHP_SELF']."?pagina=".$pag."'>". $pag. "</a>";
else
echo "<span class='smalltext'><b>" . $pag . "</b></span>";
if($pag<$totalpages)
echo " ";
}
?>
</td></tr>
<tr>
<!-- *********************LEFT TABLE ************************ -->
<td width="50%">
<table width="100%" cellspacing="0" cellpadding="2">
<tr class="dataTableHeadingRow">
<td width="50">ID</td>
<td>Option Name</td>
<td>Option Code</td>
<?php
if(tep_check_permissions('MAITENANCE_CATEGORIES') == 1){
echo "<td>Action</td>";
}
?>
</tr>
<? if(tep_db_num_rows($optionsondb)){
while($opt=mysql_fetch_array($optionsondb)){
if($cont==floor($MAX_RESULTADOS/2)){
//we have filled half of the max options to the first table. We close TD and open TR with a new table
?>
</table>
</td>
<td width="50%" valign="top">
<table width="100%" cellspacing="0" cellpadding="2">
<tr class="dataTableHeadingRow">
<td width="50">ID</td><td>Option Name</td><td>Option Code</td><td>Action</td>
</tr>
</td>
<?}
echo "<tr align='center'";
if(floor($cont/2) == ($cont/2)){
echo "class='attributes-odd' >";
}else{
echo "class='attributes-even' >";
}
echo "<td class='Main'>".$opt['products_options_id']."</td>";
if($_GET["optionid"])
$optionid=$_GET["optionid"];
if(($action=="goingtoedit") && ($optionid==$opt['event_category_id'])){
echo "<form name='editoption' onSubmit='validatedit();' action='".$_SERVER['PHP_SELF']."' >";
if($b_search){
echo "<input type='hidden' name='search' value='true'>";
echo "<input type='hidden' name='q' value='".$term."'>";
}
echo "<input type='hidden' name='pagina' value='".$pagina."'>";?>
<input type='hidden' name='action' value='edit'>
<input type='hidden' name='optionid' value='<? echo $optionid;?>'>
<td align="center"><input type='text' name='editfield' id='editfield' maxlength='32' size="<?=strlen($opt['event_category_name'])+5?>" value="<? echo $opt['event_category_name']; ?>"></td>
<td align="center"><input type='text' name='editcode' id='editfield' maxlength='10' size="<?=strlen($opt['event_category_code'])+5?>" value="<? echo $opt['event_category_code']; ?>"></td>
<td width="30%"><input type='submit' value='OK'> <input type="button" value="Cancel" onClick="self.location.href='<? echo $_SERVER['PHP_SELF']; ?>?pagina=<? echo $pagina.$url_add; ?>';"></td>
</form><?
}else{
echo "<td class='Main'>".$opt['event_category_name']."</td>";
echo "<td class='Main'>".$opt['event_category_code']."</td>";
if(tep_check_permissions('MAITENANCE_CATEGORIES') == 1){
?>
<td class='Main' width="30%">
<input type="button" value="Edit" onClick="<?PHP echo tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=goingtoedit&optionid='.$opt[event_category_id].'&pagina=$pagina.$url_add'); ?>;"
<input type='button' value='Delete' onClick="<?PHP echo tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=confirmdelete&optionid='.$opt['event_category_id']); ?>;" >
<!--<input type="button" value="Edit" onClick="editfield('< ? echo $_SERVER['PHP_SELF']; ?>', 'goingtoedit', < ? echo $opt['event_category_id']; ?>, '< ?=$pagina?>', '< ?=$url_add?>');"> -->
<!--<input type='button' value='Delete' onClick="confirmdelete' < ? echo $_SERVER['PHP_SELF']; ?>', 'delete', < ? echo $opt['event_category_id']; ?>);" >-->
</td>
<?
} // end if check permissions
}
?>
</tr>
<?
$cont++;
}
if($cont<29){?>
</table>
</td>
<td width="50%"><table width="100%"><tr><td> </td></tr>
<?}
}else{
echo "<tr class='Main' align='center'><td colspan='3'>No options found on Database</td></tr>";
}
?>
</td></tr>
</table>
</td>
<!-- ********************* END TABLE ********************** -->
</tr>
</table>
<!-- body_text_eof //-->
</tr>
</table>
<!-- body_eof //-->
<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
|
Помогите пожалуйста......
Заранее спасибо | |
| |
|
|
| |
|
|
| |
для: kaya
(07.04.2010 в 11:50)
| | | "Заставить заработать", это очень условная задача :)
Что этот скрипт должен делать? Что не работает? Какие ошибки вы получаете? Что вы уже понимаете, а что вам нужно пояснить? | |
| |
|
|
