Location: PHPKode > projects > Phpgw Time Tracking Add On App > timetrack/editprofile.php
<?php
  /**************************************************************************\
  * phpgwtimetrack - phpGroupWare addon application                          *
  * http://phpgwtimetrack.sourceforge.net                                    *
  * Written by Robert Schader <hide@address.com>                         *
  * --------------------------------------------                             *
  *  This program is free software; you can redistribute it and/or modify it *
  *  under the terms of the GNU General Public License as published by the   *
  *  Free Software Foundation; either version 2 of the License, or (at your  *
  *  option) any later version.                                              *
  \**************************************************************************/

  /* $Id: editprofile.php,v 1.4 2001/01/12 22:14:35 rschader Exp $ */

if($submit) {
  $phpgw_info["flags"] = array("noheader" => True, "nonavbar" => True);
}

  $phpgw_info["flags"]["enable_nextmatchs_class"] = "True";
  $phpgw_info["flags"]["currentapp"] = "timetrack";
  include("../header.inc.php");
  if (! $con)
     Header("Location: " . $phpgw->link("profiles.php"));

  if ($submit) {
	// Leave out any error checking for now, because most fields are not mandatory
	// at this point. I can add error checking later if I run into problems.
	$loc = implode(",",$n_location);
	$table_locks=array('employee_profiles');
	$phpgw->db->lock($table_locks);
	$p_sql = "UPDATE employee_profiles SET title='" . addslashes($n_title)
		. "',phone_number='" . addslashes($n_phone_number)
		. "',comments='" . addslashes($n_comments)
		. "',mobilephn='" . addslashes($n_mobilephn)
		. "',pager='" . addslashes($n_pager)
		. "',hire_date='" . addslashes($n_hire_date)
        . "',yearly_vacation_hours='$n_yvac_hours'"
		. ",vacation_hours_used_todate='$n_vhours_utd'"
		. ",location_id='$loc'"
		. " WHERE con='$con'";
	// test echo the sql:

	//echo "Profile SQL statement is: <br>" . $p_sql . "<br>";
	// Do the sql
	$phpgw->db->query($p_sql);
	// Unlock the tables
	$phpgw->db->unlock();

        Header("Location: " . $phpgw->link("profiles.php"));
        exit;
  }		// if $submit

  $phpgw->db->query("select * from employee_profiles where con='$con'");
  $phpgw->db->next_record();
  // Get all the required fields so I can query the employee_stats table too
  $n_owner = $phpgw->db->f("owner");
  $n_title = $phpgw->db->f("title");
  $n_phone_number = $phpgw->db->f("phone_number");
  $n_comments = stripslashes($phpgw->db->f("comments"));
  $n_mobilephn = $phpgw->db->f("mobilephn");
  $n_pager = $phpgw->db->f("pager");
  // add support for picture later
  // Note: no picture support needed, just drop pic in hr/images dir named for login
  $n_hire_date = $phpgw->db->f("hire_date");
  $n_yvac_hours = $phpgw->db->f("yearly_vacation_hours");
  $n_vhours_utd = $phpgw->db->f("vacation_hours_used_todate");
  $n_location_id = $phpgw->db->f("location_id");
  $n_inout = $phpgw->db->f("inout");
  ?>
  <h1><center>Edit Profile</center></h1><p><br>
     <form method="POST" action="<?php echo $phpgw->link();?>">
      <input type="hidden" name="con" value="<?php echo $con; ?>">
       <?php
         if ($error) {
            echo "<center>" . lang("Error") . ":$error</center>";
         }
       ?>
      <center>
       <table border=0 width=65%>
        <tr> 
         <td><?php echo lang("LoginID"); ?></td>
	 <td><?php echo $n_owner; ?></td>
        </tr>
        <tr>
         <td><?php echo lang("Title"); ?></td>
         <td><input name="n_title" value="<?php echo $n_title; ?>"></td>
        </tr>
        <tr>
         <td><?php echo lang("Phone"); ?></td>
         <td><input name="n_phone_number" value="<?php echo $n_phone_number; ?>"></td>
        </tr>
	<tr>
         <td><?php echo lang("Mobile"); ?></td>
         <td><input name="n_mobilephn" value="<?php echo $n_mobilephn; ?>"></td>
        </tr>
	<tr>
         <td><?php echo lang("Pager"); ?></td>
         <td><input name="n_pager" value="<?php echo $n_pager; ?>"></td>
        </tr>
	<tr>
         <td><?php echo lang("Date Hired"); ?></td>
         <td><input name="n_hire_date" value="<?php echo $n_hire_date; ?>"></td>
        </tr>
	<tr>
         <td><?php echo lang("vacation hours per Year"); ?></td>
         <td><input name="n_yvac_hours" value="<?php echo $n_yvac_hours; ?>"></td>
        </tr>
	<tr>
         <td><?php echo lang("Vacation hours used"); ?></td>
         <td><input name="n_vhours_utd" value="<?php echo $n_vhours_utd; ?>"></td>
        </tr>
	<tr>
	 <td><?php echo lang("Location"); ?></td>
	 <td><select name="n_location[]"><?php
                   $phpgw->db->query("select * from locations");
                   while ($phpgw->db->next_record()) {
                    $locid = $phpgw->db->f("location_id");
                    echo "<option value=\"" . $locid . "\"";
                    if ( $locid == $n_location_id) {
                     echo " selected";
                    }
                    echo ">" . $phpgw->db->f("location_name") . "</option>";
                   }
                ?>
           </select></td>
	</tr>
	<tr>
         <td><?php echo lang("Comments"); ?></td>
         <td><textarea name="n_comments" cols="30" rows="4"
	      wrap="virtual"><?php echo $n_comments; ?></textarea></td>
        </tr>
	</table>
	<input type="submit" name="submit" value="<?php echo lang("submit"); ?>">
      </center>
     </form>
   <?php
   $phpgw->common->phpgw_footer();
?>
Return current item: Phpgw Time Tracking Add On App