<?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;
}
}

$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"] == "addMemberForm")) {
  $insertSQL = sprintf("INSERT INTO members (first_name, middle_name, last_name, email, b_date, notes) VALUES (%s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['first_name'], "text"),
                       GetSQLValueString($_POST['middle_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);
  $Result = mysql_query($insertSQL, $Monqiboy) or die(mysql_error());
  $_SESSION['last_memberId'] = mysql_insert_id();
 	
}
 
// insert addresses
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "addressForm")) {
  $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);
  $Result = mysql_query($insertSQL, $Monqiboy) or die(mysql_error());
}


// Show active members Recordset table
mysql_select_db($database_Monqiboy, $Monqiboy);
$query_RsMembers = "SELECT * FROM members";
$RsMembers = mysql_query($query_RsMembers, $Monqiboy) or die(mysql_error());
$row_RsMembers = mysql_fetch_assoc($RsMembers);
$totalRows_RsMembers = mysql_num_rows($RsMembers);


//Show addresses recordset by memberId
$colname_RsAddresses = "-1";
if (isset($_SESSION['last_memberId'])) {
  $colname_RsAddresses = $_SESSION['last_memberId'];
}
mysql_select_db($database_Monqiboy, $Monqiboy);
$query_RsAddresses = sprintf("SELECT members_addresses.*, citystatezip.stateAb, citystatezip.city, citystatezip.state
							 	FROM (members_addresses LEFT JOIN citystatezip ON citystatezip.zip=members_addresses.zip)
							  WHERE members_addresses.member_id = %s", GetSQLValueString($colname_RsAddresses, "int"));
$RsAddresses = mysql_query($query_RsAddresses, $Monqiboy) or die(mysql_error());
$row_RsAddresses = mysql_fetch_assoc($RsAddresses);
$totalRows_RsAddresses = mysql_num_rows($RsAddresses);



// Recordset to XML (RsMembers)
if (isset($_GET['show_members'])) {
	header("Content-type: text/xml");
	header("Pragma: public");
	header("Cache-control: private");
	header("Expires: -1");
	$export_RsMembers="";
	if($export_RsMembers=="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_RsMembers."\">";
	if($totalRows_RsMembers > 0){
		$Start_Record = 0;
		$Num_Records = $totalRows_RsMembers;
		$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($RsMembers);
		do{
			if($Current_Record>=$Start_Record){
				echo "<record>";
				for ($x=0; $x<$totalColumns; $x++) {
					$field=mysql_field_name($RsMembers, $x);
					echo "<".$field."><"."![CD"."ATA[".htmlentities($row_RsMembers[$field])."]"."]></".$field.">";
				}
				echo "</record>";
			}
			$Current_Record=$Current_Record+1;
			if($Current_Record-$Start_Record==$Num_Records){break;}
		}while ($row_RsMembers = mysql_fetch_assoc($RsMembers)); 
	}else{
		//echo "<record></record>";
	}
	echo "</recordset>";
	die(); 
}

// Recordset to XML (RsAddresses)
if (isset($_GET['show_addr'])) {
	header("Content-type: text/xml");
	header("Pragma: public");
	header("Cache-control: private");
	header("Expires: -1");
	$export_RsAddresses="";
	if($export_RsAddresses=="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_RsAddresses."\">";
	if($totalRows_RsAddresses > 0){
		$Start_Record = 0;
		$Num_Records = $totalRows_RsAddresses;
		$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($RsAddresses);
		do{
			if($Current_Record>=$Start_Record){
				echo "<record>";
				for ($x=0; $x<$totalColumns; $x++) {
					$field=mysql_field_name($RsAddresses, $x);
					echo "<".$field."><"."![CD"."ATA[".htmlentities($row_RsAddresses[$field])."]"."]></".$field.">";
				}
				echo "</record>";
			}
			$Current_Record=$Current_Record+1;
			if($Current_Record-$Start_Record==$Num_Records){break;}
		}while ($row_RsAddresses = mysql_fetch_assoc($RsAddresses)); 
	}else{
		//echo "<record></record>";
	}
	echo "</recordset>";
	die(); 
}
?><!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>MonQi members</title>
<link rel="stylesheet" type="text/css" href="../yui/build/fonts/fonts-min.css" />
<link rel="stylesheet" type="text/css" href="../yui/build/tabview/assets/skins/sam/tabview.css" />
<link rel="stylesheet" type="text/css" href="../yui/build/container/assets/skins/sam/container.css" />
<script type="text/javascript" src="../yui/build/yahoo-dom-event/yahoo-dom-event.js"></script>
<script type="text/javascript" src="../yui/build/element/element-beta.js"></script>

<script type="text/javascript" src="../yui/build/tabview/tabview.js"></script>
<script src="../SpryAssets/xpath.js" type="text/javascript"></script>
<script src="../SpryAssets/SpryData.js" type="text/javascript"></script>
<script src="../SpryAssets/SpryDataUtils.js" type="text/javascript"></script>
<style type="text/css">
<!--
.yui-skin-sam #addNewMember {
	width: 500px;
}
-->
</style>
<script type="text/javascript">
<!--
var dsMembers = new Spry.Data.XMLDataSet("members.php?show_members=1", "recordset/record",{sortOnLoad:"first_name",sortOrderOnLoad:"ascending",useCache:false});
dsMembers.setColumnType("member_id", "number");
dsMembers.setColumnType("b_date", "date");
dsMembers.setColumnType("img_location", "image");

/*dsMembers.addObserver( {onDataChanged: function(ds, type) {
	var row = dsMembers.findRowsWithColumnValues()
)*/

var dsAddresses = new Spry.Data.XMLDataSet("members.php?show_addr=1", "recordset/record",{useCache:false});
dsAddresses.setColumnType("address_id", "number");
dsAddresses.setColumnType("member_id", "number");
dsAddresses.setColumnType("zip", "number");

//-->
</script>
<link href="../css/dataTable/DataTable.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style5 {font-size: 12px}
-->
</style>
</head>

<body class="yui-skin-sam">

<div id="listMembers">
  <div spry:region="dsMembers">
    <table>
      <tr>
        <td colspan="7">
       	  <div align="right">
           	<span class="style5">Add a new member</span> 
                <a href="#"> <img src="/images/add.png" alt="" width="23" height="22" border="0" align="absbottom" 
                 						class="a_no_border" onclick="slideReset()" /> 
               </a> 
          </div>
         </td>
      </tr>
      <tr>
        <th spry:sort="member_id">Member_id</th>
        <th spry:sort="first_name">First_name</th>
        <th>Middle_name</th>
        <th spry:sort="last_name">Last_name</th>
        <th>Email</th>
        <th width="73" class="left_dash-border">update</th>
        <th width="64" class="left_dash-border">delete</th>
      </tr>
      <tr spry:repeat="dsMembers" spry:setrow="dsMembers" spry:odd="odd" spry:even="even" spry:hover="hover" spry:select="select">
        <td>{member_id}</td>
        <td>{first_name}</td>
        <td>{middle_name}</td>
        <td>{last_name}</td>
        <td>{email}</td>
        <td valign="middle" class="left_dash-border"><div align="center"> <a href="#"><img src="/images/edit.png" alt="edit" width="16" height="16" 
                    class="a_no_border" onclick="MM_effectSlide('updateFormClass', 1000, '0%', '100%', false)"/> </a> </div></td>
        <td valign="middle" class="left_dash-border"><div align="center"> <a href="#"><img src="/images/delete.png" alt="delete" width="16" height="16"
                     class="a_no_border" onclick="MM_effectSlide('deleteConfirm', 1000, '0%', '100%', false)" /> </a> </div></td>
      </tr>
    </table>
    <br />
  </div>
</div>
<div id="addNewMember" class="yui-navset">
  <ul class="yui-nav">
    <li><a href="#tab1"><em>Personal Info:</em></a></li>
    <li class="selected"><a href="#tab2"><em>Addresses:</em></a></li>
    <li><a href="#tab3"><em>Phone Numbers:</em></a></li>
  </ul>
  <div class="yui-content">
    <div id="tab1">
      <p><strong>Add a new member</strong></p>
      <br />
      <form action="<?php echo $editFormAction; ?>" name="addMemberForm" id="addMemberForm" method="POST">
        <table border="0">
          <tr>
            <td colspan="2">Personal information:</td>
          </tr>
          <tr>
            <td>First name</td>
            <td><input type="text" name="first_name" id="first_name" /></td>
          </tr>
          <tr>
            <td>Middle name</td>
            <td><input type="text" name="middle_name" id="middle_name" /></td>
          </tr>
          <tr>
            <td>Last name</td>
            <td><input type="text" name="last_name" id="last_name" /></td>
          </tr>
          <tr>
            <td>e-mail address:</td>
            <td><input type="text" name="email" id="email" /></td>
          </tr>
          <tr>
            <td>Date of birth:</td>
            <td><input type="text" name="b_date" id="b_date" /></td>
          </tr>
          <tr>
            <td>Notes:</td>
            <td><label>
              <textarea name="notes" id="notes" cols="45" rows="5"></textarea>
            </label></td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td><input type="submit" name="submit" id="submit" value="add member" /></td>
          </tr>
        </table>
        <br />
        <input type="hidden" name="MM_insert" value="addMemberForm" />
      </form>
    </div>
    <div id="tab2">
      <form action="<?php echo $editFormAction; ?>" id="addressForm" name="addressForm" method="POST">
        <table width="400" border="0">
          <tr>
            <td colspan="2">Address information:
              <div align="right"></div></td>
          </tr>
          <tr>
            <td>street:</td>
            <td><input type="text" name="street" id="street" /></td>
          </tr>
          <tr>
            <td>apt:</td>
            <td><input type="text" name="apt_unit" id="apt_unit" /></td>
          </tr>
          <tr>
            <td>zip:</td>
            <td><input type="text" name="zip" id="zip" /></td>
          </tr>
          <tr>
            <td>submit</td>
            <td><input type="submit" name="submitAddr" id="submitAddr" value="Add Adrrees" /></td>
          </tr>
          <tr>
            <td><input name="member_id" type="text" id="member_id" value="<?php echo $_SESSION['last_memberId']; ?>" />
                <input name="MM_insert" type="hidden" id="MM_insert" value="addressForm" /></td>
            <td></td>
          </tr>
        </table>
        <input type="hidden" name="MM_insert" value="addressForm" />
</form>
    <br />
        <br />
        Assoiciated member's addresses:
        <br />
        <div spry:region="dsAddresses">
          <table>
            <tr>
              <th spry:sort="member_id">Member_id</th>
              <th>Street</th>
              <th>Apt_unit</th>
              <th>Zip</th>
              <th>StateAb</th>
              <th>City</th>
              <th>State</th>
            </tr>
            <tr spry:repeat="dsAddresses" spry:odd="odd" spry:even="even" spry:hover="hover" spry:select="select">
              <td>{member_id}</td>
              <td>{street}</td>
              <td>{apt_unit}</td>
              <td>{zip}</td>
              <td>{stateAb}</td>
              <td>{city}</td>
              <td>{state}</td>
            </tr>
          </table>
        </div>
    </div>
    <div id="tab3">
      <form id="addressForm2" name="phoneForm" method="post" action="">
        <table width="400" border="0">
          <tr>
            <td colspan="2">phone information:
              <div align="right"></div></td>
          </tr>
          <tr>
            <td>phone id</td>
            <td><input type="text" name="phone_id" id="phone_id" /></td>
          </tr>
          <tr>
            <td>location:</td>
            <td><input type="text" name="street2" id="street2" /></td>
          </tr>
          <tr>
            <td>phone number:</td>
            <td><input type="text" name="apt_unit2" id="apt_unit2" /></td>
          </tr>
          <tr>
            <td>submit</td>
            <td><input type="submit" name="submit3" id="submit3" value="Submit" /></td>
          </tr>
          <tr>
            <td><input name="member_id" type="hidden" id="member_id" value="<?php echo $_SESSION['last_memberId']; ?>" /></td>
            <td>&nbsp;</td>
          </tr>
        </table>
      </form>
      <p>&nbsp;</p>
    </div>
  </div>
</div>
<script language="javascript" type="text/javascript">
Spry.DataUtils.ServerAction('addMemberForm','','',false,'dsMembers','');
</script>
<script language="javascript" type="text/javascript">
Spry.DataUtils.ServerAction('addressForm','','',false,'dsAddresses','');
</script>
<script type="text/javascript">
    var tabView = new YAHOO.widget.TabView('addNewMember');
</script>
</body>
</html>
<?php
mysql_free_result($RsMembers);
mysql_free_result($RsAddresses);
?>