5<?php require_once('../Connections/Monqiboy.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}}

// RecordSets
//--------------------------
//------- Active Members Recordset ------------
mysql_select_db($database_Monqiboy, $Monqiboy);
$query_activeMembers = "SELECT * FROM members ORDER BY member_id ASC";
$activeMembers = mysql_query($query_activeMembers, $Monqiboy) or die(mysql_error());
$row_activeMembers = mysql_fetch_assoc($activeMembers);
$totalRows_activeMembers = mysql_num_rows($activeMembers);

//----Recordset to XML
if (isset($_GET['show_member'])) {
	header("Content-type: text/xml");
	header("Pragma: public");
	header("Cache-control: private");
	header("Expires: -1");
	$export_activeMembers="";
	if($export_activeMembers=="1"){
		header("Content-Disposition: attachment; filename=recordset.xml");
		header("Content-Type: application/force-download");
	}
	echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>"; 
	echo "<recordset total=\"".$totalRows_activeMembers."\">";
	if($totalRows_activeMembers > 0){
		$Start_Record = 0;
		$Num_Records = $totalRows_activeMembers;
		$Current_Record = 0;
		if(isset($_POST['Start_Record']) && $_POST['Start_Record']!="" &&  isset($_POST['Num_Records']) && $_POST['Num_Records']!=""){
			$Start_Record = $_POST['Start_Record'];
			$Num_Records = $_POST['Num_Records'];
		}
		if(isset($_GET['Start_Record']) && $_GET['Start_Record']!="" &&  isset($_GET['Num_Records']) && $_GET['Num_Records']!=""){
			$Start_Record = $_GET['Start_Record'];
			$Num_Records = $_GET['Num_Records'];
		}
		$totalColumns=mysql_num_fields($activeMembers);
		do{
			if($Current_Record>=$Start_Record){
				echo "<record>";
				for ($x=0; $x<$totalColumns; $x++) {
					$field=mysql_field_name($activeMembers, $x);
					echo "<".$field."><"."![CD"."ATA[".htmlentities($row_activeMembers[$field])."]"."]></".$field.">";
				}
				echo "</record>";
			}
			$Current_Record=$Current_Record+1;
			if($Current_Record-$Start_Record==$Num_Records){break;}
		}while ($row_activeMembers = mysql_fetch_assoc($activeMembers)); 
	}else{
		//echo "<record></record>";
	}
	echo "</recordset>";
	die(); 
}



// FORMS OPERATIONS
//------------------------------------
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

	//Insert New Member
	//------------------
	if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "newMember")) {
	  $insertSQL = sprintf("INSERT INTO members (first_name, last_name, email, b_date, notes) VALUES (%s, %s, %s, %s, %s)",
						   GetSQLValueString($_POST['first_name'], "text"),
						   GetSQLValueString($_POST['last_name'], "text"),
						   GetSQLValueString($_POST['email'], "text"),
						   GetSQLValueString($_POST['b_date'], "date"),
						   GetSQLValueString($_POST['notes'], "text"));
	
	  mysql_select_db($database_Monqiboy, $Monqiboy);
	  $Result1 = mysql_query($insertSQL, $Monqiboy) or die(mysql_error());
	  $lastMemberId = mysql_insert_id();
	  $panel = 0;
	  $confirmCreated = '<p class=ok> member susccesfully created! ' .'  with the member id:  ' .$lastMemberId. '</p>';

	// Update last member inserted	
	//-----------------------------	
} elseif ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "updateMember")){
		
  $updateSQL = sprintf("UPDATE members SET first_name=%s, last_name=%s, email=%s, b_date=%s, notes=%s WHERE member_id=%s",
                       GetSQLValueString($_POST['first_name'], "text"),
                       GetSQLValueString($_POST['last_name'], "text"),
                       GetSQLValueString($_POST['email'], "text"),
                       GetSQLValueString($_POST['b_date'], "date"),
                       GetSQLValueString($_POST['notes'], "text"),
                       GetSQLValueString($_POST['member_id'], "int"));

  mysql_select_db($database_Monqiboy, $Monqiboy);
  $Result1 = mysql_query($updateSQL, $Monqiboy) or die(mysql_error());
  $lastMemberId = $_POST['member_id'];
  $panel = 0;
  $confirmCreated = '<p class=ok> member ' .$lastMemberId  .' personal info has been susccesfully updated! ' . '</p>';
}
	// Delete Last member Inserted 
if ((isset($_POST['MM_delete'])) && ($_POST['MM_delete'] == "deleteMember")) {
	  $deleteSQL = sprintf("DELETE FROM members WHERE member_id=%s",
						   GetSQLValueString($_POST['member_id'], "int"));
	
	  mysql_select_db($database_Monqiboy, $Monqiboy);
	  $Result1 = mysql_query($deleteSQL, $Monqiboy) or die(mysql_error());
	  $confirmDelete =  '<p class=warning> member succesfully deleted! </p>' ;
	 }

//override values after post insert to auto fill form for update (once created)if needed

  	if ($_POST['MM_insert'] == "newMember") {
	$first_name = $_POST['first_name'];
	$last_name = $_POST['last_name'];
	$email = $_POST['email'];
	$b_date = $_POST['b_date'];
	$notes = $_POST['notes'];
	$title = $first_name .' ' .$last_name .' ' .$b_date;
	$submit = 'Save Changes';
	$MM_insert = 'updateMember';
	$reset = 'hidden';
	$delete = '';
	}
  	else {
	 $title = 'Add a new member';
	 $submit = 'Add this member';
	 $MM_insert = 'newMember';
	 $reset = 'reset';
	 $delete = 'hidden';
	}

 // override values after post from address form
if ($_POST['MM_insertAddr'] == "contactInfo") {
	$zip = $_POST['zip'];
	$street = $_POST['street'];
	$apt = $_POST['apt_unit'];
	$submitAddr = 'Save Changes';
	$MM_insertAddr = 'updateAddr';
	$title = $first_name .' ' .$last_name .' ' .$b_date .'not set';
	}
	else {
	$submitAddr = 'Add address';
	$MM_insertAddr = "contactInfo";
	}


// add addres
if ($_POST['MM_insertAddr'] == "contactInfo") {
  $insertSQL = sprintf("INSERT INTO members_addresses (member_id, street, apt_unit, zip) VALUES (%s, %s, %s, %s)",
                       GetSQLValueString($_POST['member_id'], "int"),
                       GetSQLValueString($_POST['street'], "text"),
                       GetSQLValueString($_POST['apt_unit'], "text"),
                       GetSQLValueString($_POST['zip'], "double"));

  mysql_select_db($database_Monqiboy, $Monqiboy);
  $Result1 = mysql_query($insertSQL, $Monqiboy) or die(mysql_error());
  $panel = 1;
  $lastMemberId = $_POST['member_id'];
  $confirmCreated = '<p class=ok> member ' .$lastMemberId  .' address has been susccesfully registered! ' . '</p>';

}




?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xmlns:spry="http://ns.adobe.com/spry">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>NEW MEMBER</title>

<link href="../SpryAssets/SprySlidingPanels.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
body {
margin: 0;
padding: 0;
}
#formHead {
	background: #ECF3FF;
}
.ok {
	color: #00CC33;
}
 
.style8 {
	font-family: "Times New Roman", Times, serif;
	font-weight: bold;
	font-style: italic;
}
.warning {color: #FF0000}

.divPosition {
	width: 420px;
	margin-left: 110px;
}

#notes {
	border-top: 1px dashed #CCCCCC;
	border-bottom: 1px dashed #CCCCCC;
	border-right-width: 0px;
	border-left-width: 0px;
	border-right-color: #CCCCCC;
	border-left-color: #CCCCCC;
}

.hidden {
	display: none;
}

.style10 {color: #0000CC}

-->
</style>

<style type="text/css">

.SlidingPanels {
	width: 500px;
	height: 500px;
}
.SlidingPanelsContent {
	width: 500px;
	height:500px;
}

.p1 {
	
}
.p2 {
}
.p3 {
}

#addNewMemberSlides.SlidingPanels {
	float: left;
}
#addNewMemberSlides .SlidingPanelsContentGroup {
	float: left;
	width: 10000px;
}
#addNewMemberSlides .SlidingPanelsContent {
	float: left;
}

</style>
<script src="../SpryAssets/SpryEffects.js" type="text/javascript"></script>
<script src="../SpryAssets/SprySlidingPanels.js" type="text/javascript"></script>
<script src="../SpryAssets/SpryData.js" type="text/javascript"></script>
<script src="../SpryAssets/SpryDataUtils.js" type="text/javascript"></script>
<script src="../SpryAssets/xpath.js" type="text/javascript"></script>
<script type="text/javascript">
<!--
var ds_members = new Spry.Data.XMLDataSet("newMember.php?show_member=1", "recordset/record",{useCache:false});
ds_members.setColumnType("member_id", "number");
ds_members.setColumnType("b_date", "date");
ds_members.setColumnType("img_location", "image");
//-->
</script>
<link href="../css/dataTable/DataTable.css" rel="stylesheet" type="text/css" />
</head>

<body>
<?php if (!isset($panel)) {$panel = 0;} ?>
<div id="formHead">
  <h2><img src="../images/untitled.jpg" alt="" width="107" height="106" align="middle" /> <span class="style8"><?php echo $title; ?></span></h2>
</div>
<div id="addNewMemberSlides" class="SlidingPanels" tabindex="0">
  <div class="SlidingPanelsContentGroup">
    <div id="personal_info" class="SlidingPanelsContent p1">
      <form id="newMember" name="newMember" method="POST" action="<?php echo $editFormAction; ?>">
        <table width="400" border="0">
          <tr>
            <td>First name<br />
                <input type="text" name="first_name" id="first_name" value="<?php echo $first_name; ?>" /></td>
            <td>Last name<br />
                <input type="text" name="last_name" id="last_name" value="<?php echo $last_name; ?>" /></td>
          </tr>
          <tr>
            <td>e-mail address<br />
                <input type="text" name="email" id="email" value="<?php echo $email; ?>" /></td>
            <td>&nbsp;</td>
          </tr>
          <tr>
            <td>Date of birth<br />
                <input type="text" name="b_date" id="b_date" value="<?php echo $b_date; ?>" /></td>
            <td>&nbsp;</td>
          </tr>
          <tr>
            <td colspan="2">Notes<br />
                <textarea name="notes" id="notes" cols="45" rows="5"><?php echo $notes; ?></textarea></td>
          </tr>
          <tr>
            <td colspan="2"><a href="#" onclick="sp.showPanel('address'); return false;">Add contact information</a> - You can do this later</td>
          </tr>
          <tr>
            <td><input type="hidden" name="member_id" id="member_id" value="<?php echo $lastMemberId; ?>" />
                <input type="hidden" name="MM_insert" value="<?php echo $MM_insert; ?>" /></td>
            <td>&nbsp;</td>
          </tr>
          <tr>
            <td colspan="2"><input type="submit" name="addMember" id="addMember" value="<?php echo $submit; ?>" />
              |<span class="warning">Cancel</span>|
              <input type="<?php echo $reset; ?>" name="reset" id="reset" value="Start over" />
              <input class="<?php echo $delete; ?>" type="image" name="MM_delete" id="MM_delete" value="deleteMember" 
                                        src="../images/trash_can.jpg" width="60" height="60" border="0"
                                        onClick="javascript:return confirm('Are you sure you want to delete this member?')" /></td>
          </tr>
        </table>
      </form>
    </div>
    <div id="address" class="SlidingPanelsContent p2">
      <p>Add contact information:<br />
          <br />
      </p>
      <form id="contactInfo" name="contactInfo" method="POST" action="<?php echo $editFormAction; ?>">
        Address:<br />
        <table width="400" border="0">
          <tr>
            <td>Street<br />
              <input type="text" name="street" id="street" value="<?php echo $street; ?>" /></td>
            <td>Apt / Unit / Floor<br />
              <input type="text" name="apt_unit" id="apt_unit" value="<?php echo $apt; ?>" /></td>
          </tr>
          <tr>
            <td>zip code<br />
              <input type="text" name="zip" id="zip" value="<?php echo $zip; ?>" /></td>
            <td>&nbsp;</td>
          </tr>
          <tr>
            <td><input type="hidden" name="member_id" id="member_id" value="<?php echo $lastMemberId; ?>" />
            <input name="addressId" type="hidden" id="addressId" value="<?php mysql_insert_id; ?>" /></td>
            <td>
              <input type="submit" name="submitAddr" id="submitAddr" value="<?php echo $submitAddr; ?>" />
           </td>
          </tr>
        </table>
        <input type="hidden" name="MM_insertAddr" value="<?php echo $MM_insertAddr; ?>" />
      </form>
    </div>
    <div id="phone_numbers" class="SlidingPanelsContent p3"> Phone Numbers:<br />
      <form id="phones" name="phones" method="post" action="">
        <table width="400" border="0">
          <tr>
            <td>Location<br />
            <input type="text" name="location" id="location" value="<?php echo $location; ?>" /></td>
            <td>Phonenumber:<br />
            <input type="text" name="phone" id="phone" value="<?php echo $phone; ?>" /></td>
          </tr>
          
          <tr>
            <td><input type="text" name="member_id" id="member_id" value="<?php echo $lastMemberId; ?>" />
            <td><input type="submit" name="submitPhone" id="submitPhone" value="<?php echo $submitPhone; ?>" />
            </td>
          </tr>
        </table>
      </form>
    </div>
  </div>
</div>

<p> Navigate by id: <a href="#" onclick="sp.showPanel('personal_info'); return false;">Personal Information</a> | <a href="#" onclick=
"sp.showPanel('address'); return false;">Addresses</a> | <a href="#" onclick="sp.showPanel('phone_numbers'); return false;">Phone numbers</a> | </p>

<!-- Spry Active Members Table-->
<div spry:region="ds_members">
  <table>
    <tr>
      <th spry:sort="member_id">Member_id</th>
      <th spry:sort="first_name">First_name</th>
      <th spry:sort="last_name">Last_name</th>
      <th>Email</th>
      <th>B_date</th>
      <th>Img_location</th>
      <th>Notes</th>
    </tr>
    <tr spry:repeat="ds_members" spry:setrow="ds_members" spry:odd="odd" spry:even="even" spry:hover="hover" spry:select="select">
      <td>{member_id}</td>
      <td>{first_name}</td>
      <td>{last_name}</td>
      <td>{email}</td>
      <td>{b_date}</td>
      <td><img src="{img_location}"/></td>
      <td>{notes}</td>
    </tr>
  </table>
</div>

<pre><?php print_r($_POST); ?></pre>
<pre><?php echo 'member id: ' .$lastMemberId; ?></pre>
<!-- confirmations insert delete -->
<?php if(isset($confirmDelete)) {
                                echo  $confirmDelete;
                                }
                                elseif 
                                    (isset($confirmCreated)) {
                                    echo $confirmCreated;
                                    }
                            ?>
 
<script type="text/javascript">
var sp = new Spry.Widget.SlidingPanels('addNewMemberSlides', {defaultPanel: <?php echo $panel; ?>});
</script>

</body>
</html>
<?php
mysql_free_result($activeMembers);
?>