addedit.php

<?php 
##
## holiday module - A dotProject module for keeping track of holidays
##
## Sensorlink AS (c) 2006
## Vegard Fiksdal (fiksdal@sensorlink.no)
##

$holiday_id = defVal( @$_GET["holiday_id"], 0);
$holiday_white = defVal( @$_GET["white"], -1);

// Create date objects
$log_start_date         = dPgetParam( $_POST, "log_start_date", 0 );
$log_end_date           = dPgetParam( $_POST, "log_end_date", 0 );
$start_date = intval( $log_start_date ) ? new CDate( $log_start_date ) : new CDate();
$end_date   = intval( $log_end_date )   ? new CDate( $log_end_date ) : new CDate();
$holiday_description = dPgetParam( $_POST, "holiday_description", '');
$holiday_annual = dPgetParam( $_POST, "holiday_annual", 0);
        
$action = @$_REQUEST["action"];
if($action) {
        if( $action == "add" ) {
                $sql = "INSERT INTO holiday (holiday_description,holiday_start_date,holiday_end_date,holiday_white,holiday_annual) ";
                $sql.= "VALUES ('";
                $sql.= $holiday_description;
                $sql.= "','";
                $sql.= $start_date->format(FMT_DATETIME_MYSQL);
                $sql.= "','";
                $sql.= $end_date->format(FMT_DATETIME_MYSQL);
                $sql.= "','";
                $sql.= $holiday_white;
                $sql.= "','";
                $sql.= $holiday_annual;
                $sql.= "')";
                $okMsg = "Holiday registered";
        } else if ( $action == "update" ) {
                $sql = "UPDATE holiday SET ";
                $sql.= "holiday_description = '" . $holiday_description . "', ";
                $sql.= "holiday_start_date = '" . $start_date->format(FMT_DATETIME_MYSQL) . "', ";
                $sql.= "holiday_end_date = '" . $end_date->format(FMT_DATETIME_MYSQL) . "', ";
                $sql.= "holiday_annual = '" . $holiday_annual . "' ";
                $sql.= "WHERE holiday_id = " . $holiday_id;
                $okMsg = "Holiday updated";
        }
        else if ( $action == "del" ) {
		$sql = "DELETE FROM holiday WHERE holiday_id = ".$holiday_id;
                $okMsg = "Holiday removed";
	}
        if(!db_exec($sql)) {
                $AppUI->setMsg( db_error() );
        } else {
                $AppUI->setMsg( $okMsg );
        }
	$AppUI->redirect();
}

// pull the holiday from the database
db_loadHash( "SELECT * FROM holiday WHERE holiday_id = $holiday_id", $holiday );

if($holiday_white == -1)
{
	$holiday_white = $holiday['holiday_white'];
}

?>

<script language="javascript">
var calendarField = '';
function popCalendar( field ){
        calendarField = field;
        idate = eval( 'document.AddEdit.log_' + field + '.value' );
        window.open( 'index.php?m=public&a=calendar&dialog=1&callback=setCalendar&date=' + idate, 'calwin', 'width=250, height=220, scollbars=false' );
}
function setCalendar( idate, fdate ) {
        fld_date = eval( 'document.AddEdit.log_' + calendarField );
        fld_fdate = eval( 'document.AddEdit.' + calendarField );
        fld_date.value = idate;
        fld_fdate.value = fdate;
}
function delIt() {
	document.AddEdit.action.value = "del";
	document.AddEdit.submit();
}

</script>


<form name="AddEdit" method="post">				
<table width="100%" border="0" cellpadding="0" cellspacing="1">
<input name="action" type="hidden" value="<?php echo $holiday_id ? "update" : "add"  ?>">
<tr>
	<td><img src="./images/icons/tasks.gif" alt="" border="0"></td>
	<td align='left' nowrap='nowrap' width='100%'><h1>
	<?php 
		if($holiday_white)
		{
			echo $AppUI->_( $holiday_id ? 'Edit holiday' : 'New holiday' );
		}
		else
		{
			echo $AppUI->_( $holiday_id ? 'Edit workday' : 'New workday' );
		}
	?>
	</h1></td>
</tr>
</table>

<table border="0" cellpadding="4" cellspacing="0" width="98%">
<tr>
	<td width="50%" align="right">
		<a href="javascript:delIt()"><img align="absmiddle" src="./images/icons/stock_delete-16.png" width="16" height="16" alt="" border="0"><?php echo $AppUI->_( $holiday_white ? 'Delete holiday' : 'Delete workday' );?></a>
	</td>
</tr>
</table>

<table border="1" cellpadding="4" cellspacing="0" width="98%" class="std">
<tr><td align="CENTER">

        <?php echo $AppUI->_( 'Start date' );?>
        <input type="hidden" name="log_start_date" value="<?php echo $start_date->format( FMT_TIMESTAMP_DATE );?>" />
        <input type="text" name="start_date" onChange="copyDate()" value="<?php echo $start_date->format( $AppUI->getPref('SHDATEFORMAT') );?>" class="text" disabled="disabled" />
        <a href="#" onClick="popCalendar('start_date')" >
        <img src="./images/calendar.gif" width="24" height="12" title="<?php echo $AppUI->_('Calendar');?>" border="0" />
        </a>

        <?php echo $AppUI->_( 'End date' );?>
        <input type="hidden" name="log_end_date" value="<?php echo $end_date->format( FMT_TIMESTAMP_DATE );?>" />
        <input type="text" name="end_date" value="<?php echo $end_date->format( $AppUI->getPref('SHDATEFORMAT') );?>" class="text" disabled="disabled" size="20" />
        <a href="#" onClick="popCalendar('end_date')">
        <img src="./images/calendar.gif" width="24" height="12" title="<?php echo $AppUI->_('Calendar');?>" border="0" />
        </a>

	<td>
        <?php echo $AppUI->_( 'Annual' );?>
	<input type="checkbox" value="1" name="holiday_annual" <?php if($holiday["holiday_annual"]){?>checked="checked"<?php }?> />
	</td>

	<td>
        <?php echo $AppUI->_( 'Description' );?>
        <input type="text" class="text" SIZE="100%" name="holiday_description" value="<?php echo $holiday["holiday_description"];?>">
	</td>
</td></tr>

<table border="0" cellspacing="0" cellpadding="3" width="98%">
<tr>
	<td height="40" width="30%">&nbsp;</td>
	<td  height="40" width="35%" align="right">
		<table>
		<tr>
			<td>
				<input class="button" type="button" name="cancel" value="<?php echo $AppUI->_('cancel'); ?>" onClick="javascript:if(confirm('<?php echo $AppUI->_('Are you sure you want to cancel?', UI_OUTPUT_JS); ?>')){location.href = '?<?php echo $AppUI->getPlace();?>';}">
			</td>
			<td>
				<input class="button" type="button" name="btnFuseAction" value="<?php echo $AppUI->_('save'); ?>" onClick="submit()">
			</td>
		</tr>
		</table>
	</td>
</tr>
</table>	
	
</table>
</form>		
</body>
</html>