edit_currency.php

通达OA部分源代码

<?
include "logincheck.php";
include "myconnect.php";
///////////////////////////////////////////////////////////////////////////////
///      THE CODE OF THIS SCRIPT HAS BEEN DEVELOPED BY SOFTBIZ SOLUTIONS  /////
///      AND IS MEANT TO BE USED ON THIS SITE ONLY AND IS NOT FOR REUSE,  /////
///      RESALE OR REDISTRIBUTION.                                        ///// 
///      IF YOU NOTICE ANY VIOLATION OF ABOVE PLEASE REPORT AT:           /////
///      [e-mail]                                         /////
///      http://www.softbizscripts.com                                    /////
///      http://www.softbizsolutions.com                                  /////  
///////////////////////////////////////////////////////////////////////////////

/////////add new code
if(count($_POST)>0)
{
			if (!get_magic_quotes_gpc()) {
			$sbcur_symbol=str_replace('$', '\$',addslashes($_REQUEST["sbcur_symbol"]));
			$sbcur_name=str_replace('$', '\$',addslashes($_REQUEST["sbcur_name"]));
			}
			else
			{
			$sbcur_symbol=str_replace('$', '\$',$_REQUEST["sbcur_symbol"]);
			$sbcur_name=str_replace('$', '\$',$_REQUEST["sbcur_name"]);
			}
		$errcnt=0;
		if(strlen(trim($_POST["sbcur_symbol"]))==0)
		{
			$errmsg[$errcnt]="Please specify Currency Symbol.";
			$errcnt++;
		}
	
		if(strlen(trim($_POST["sbcur_name"]))==0)
		{
			$errmsg[$errcnt]="Please specify Currency Code.";
			$errcnt++;
		}
		else
		{
			$rst=mysql_fetch_array(mysql_query("select * from sbbleads_currencies where
			sbcur_name='$sbcur_name' and sbcur_id<>".$_POST["id"]));
			if($rst)
			{
				$errmsg[$errcnt]="Currency already exists in the list.";
				$errcnt++;
			}
		}

if($errcnt==0)
{

    mysql_query("update sbbleads_currencies set sbcur_symbol='$sbcur_symbol',sbcur_name='$sbcur_name' 
	where sbcur_id=".$_POST["id"]);
	if(mysql_affected_rows()>0)
	{
	header("Location: "."manage_currency.php?msg=".urlencode("Currency has been updated."));
	die();
	}
	else
	{
	header("Location: "."edit_currency.php?id=".$_POST["id"]."&msg=".urlencode("Some error occurred. Please try again."));
	die();
	}
}
}
/////////////////////

function main()
{
global $errcnt,$errmsg;
$id=$_REQUEST["id"];
$cur=mysql_fetch_array(mysql_query("select * from sbbleads_currencies where sbcur_id=$id"));

$sbcur_symbol=$cur["sbcur_symbol"];
$sbcur_name=$cur["sbcur_name"];

?>
<script language="JavaScript1.1">
function Validator()
{

if ( frm1.sbcur_symbol.value=='' )
{
	alert("Please specify Currency Symbol");
	document.frm1.sbcur_symbol.focus();
	return (false);
}
if ( frm1.sbcur_name.value=='' )
{
	alert("Please specify Currency Code");
	document.frm1.sbcur_name.focus();
	return (false);
}
return (true);
}

</script>
<?

if(count($_POST)>0)
{
$sbcur_symbol=$_POST["sbcur_symbol"];
$sbcur_name=$_POST["sbcur_name"];
 
	if($errcnt<>0)
	{
	?>
<table width="90%" border="0" align="center" cellpadding="2" cellspacing="0" class="errorstyle">
  <tr> 
    <td colspan="2"><strong>&nbsp;Your request cannot be processed due to following 
      reasons</strong></td>
  </tr>
  <tr height="10"> 
    <td colspan="2"></td>
  </tr>
  <?

for ($i=0;$i<$errcnt;$i++)
{
?>
  <tr valign="top"> 
    <td width="6%">&nbsp;<?php echo $i+1;?></td>
    <td width="94%"><?php echo  $errmsg[$i]; ?></td>
  </tr>
  <?
}
?>
</table>
<?
	}
	}		

?>
<table width="90%" height="20" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td valign="top"> <div align="center"> 
        <table width="100%" border="0" cellspacing="10" cellpadding="2">
          <form action="edit_currency.php" method="post" name="frm1" id="frm1"  onSubmit="return Validator();" >
            <tr align="left" class="row1"> 
              <td height="25" colspan="3" bgcolor="#004080"><font size="3" face="Arial, Helvetica, sans-serif"><font color="#FFFFFF" size="2"><strong>&nbsp;Edit 
                Currency</strong></font></font></td>
            </tr>
            <tr class="row1"> 
              <td width="40%" align="right" bgcolor="#F5F5F5"> <div align="right"><font size="2" face="Arial, Helvetica, sans-serif"><strong>
                  <input name="id" type="hidden" id="id" value="<? echo $id;?>">
                  Currency Symbol:</strong></font></div></td>
              <TD align=left valign="top" class="onepxtable"><font color=red 
                        size=2 face="Arial, Helvetica, sans-serif">*</font></TD>
              <td width="60%"> <input name="sbcur_symbol" type="text" class="box" id="sbcur_symbol" value="<? echo $sbcur_symbol;?>"> 
              </td>
            </tr>
            <tr valign="top" class="row1"> 
              <td align="right" bgcolor="#F5F5F5"><font face="Verdana, Arial, Helvetica, sans-serif"><strong><font size="2" face="Arial, Helvetica, sans-serif">Currency 
                Code:</font></strong></font></td>
              <TD align=left class="onepxtable"><font color=red 
                        size=2 face="Arial, Helvetica, sans-serif">*</font></TD>
              <td><input name="sbcur_name" type="text" class="box" id="sbcur_name" value="<? echo $sbcur_name;?>"></td>
            </tr>
            <tr class="row1"> 
              <td width="40%" align="right" bgcolor="#F5F5F5"><font size="2" face="Arial, Helvetica, sans-serif">&nbsp;</font></td>
              <td width="6">&nbsp;</td>
              <td width="60%"> <input name="Submit" type="submit" class="submit" value="Update"></td>
            </tr>
          </form>
        </table>
      </div></td>
  </tr>
  <tr> 
    <td align="left" valign="top"> <div align="left"><font size="2" face="Arial, Helvetica, sans-serif"><strong>&nbsp;</strong></font></div></td>
  </tr>
</table>
<?
}//end main
include "template.php";
///////////////////////////////////////////////////////////////////////////////
///      THE CODE OF THIS SCRIPT HAS BEEN DEVELOPED BY SOFTBIZ SOLUTIONS  /////
///      AND IS MEANT TO BE USED ON THIS SITE ONLY AND IS NOT FOR REUSE,  /////
///      RESALE OR REDISTRIBUTION.                                        ///// 
///      IF YOU NOTICE ANY VIOLATION OF ABOVE PLEASE REPORT AT:           /////
///      [e-mail]                                         /////
///      http://www.softbizscripts.com                                    /////
///      http://www.softbizsolutions.com                                  /////  
///////////////////////////////////////////////////////////////////////////////


?>