<?php 
/**
 * 123PHPSHOP
 * ============================================================================
 * 版权所有 2015 上海序程信息科技有限公司，并保留所有权利。
 * 网站地址: http://www.123PHPSHOP.com；
 * ----------------------------------------------------------------------------
 * 这是一个免费的软件。您可以在商业目的和非商业目的地前提下对程序除本声明之外的
 * 代码进行修改和使用；您可以对程序代码进行再发布，但一定请保留
 * 本声明和上海序程信息科技有限公司的联系方式！本软件中使用到的第三方代码版权属
 * 于原公司所有。上海序程信息科技有限公司拥有对本声明和123PHPSHOP软件使用的最终
 * 解释权！
 * ============================================================================
 *  作者:	123PHPSHOP团队
 *  手机:	13391334121
 *  邮箱:	service@123phpshop.com
 */
 ?><?php require_once('../../Connections/localhost.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $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']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
	
//		检查用户是否已经有了收货人记录，如果没有的话，那么自动设置为默认
	$is_default=0;
	$colname_consignees = "-1";
	if (isset($_SESSION['user_id'])) {
	  $colname_consignees = (get_magic_quotes_gpc()) ? $_SESSION['user_id'] : addslashes($_SESSION['user_id']);
	}
	mysql_select_db($database_localhost, $localhost);
	$query_consignees = sprintf("SELECT * FROM user_consignee WHERE is_delete=0 and user_id = %s order by is_default desc", $colname_consignees);
	$consignees = mysql_query($query_consignees, $localhost) or die(mysql_error());
 	$totalRows_consignees = mysql_num_rows($consignees);
	if($totalRows_consignees==0){
		$is_default=1;
	}
	
	$update_catalog = sprintf("update `user_consignee` set is_default=0 where user_id=%s and id != %s",$_SESSION['user_id'], $colname_consignee);
	$update_catalog_query = mysql_query($update_catalog, $localhost);
		
	
  $insertSQL = sprintf("INSERT INTO user_consignee (is_default,name, mobile, province, city, district, address, zip, user_id) VALUES (%s,%s, %s, %s, %s, %s, %s, %s, %s)",
  					   GetSQLValueString($is_default, "int"),
                       GetSQLValueString($_POST['name'], "text"),
                       GetSQLValueString($_POST['mobile'], "text"),
                       GetSQLValueString($_POST['province'], "text"),
                       GetSQLValueString($_POST['city'], "text"),
                       GetSQLValueString($_POST['district'], "text"),
                       GetSQLValueString($_POST['address'], "text"),
                       GetSQLValueString($_POST['zip'], "text"),
                       GetSQLValueString($_SESSION['user_id'], "int"));

  mysql_select_db($database_localhost, $localhost);
  $Result1 = mysql_query($insertSQL, $localhost) or die(mysql_error());
}

$colname_consignees = "-1";
if (isset($_SESSION['user_id'])) {
  $colname_consignees = (get_magic_quotes_gpc()) ? $_SESSION['user_id'] : addslashes($_SESSION['user_id']);
}
mysql_select_db($database_localhost, $localhost);
$query_consignees = sprintf("SELECT * FROM user_consignee WHERE is_delete=0 and user_id = %s order by is_default desc", $colname_consignees);
$consignees = mysql_query($query_consignees, $localhost) or die(mysql_error());
$row_consignees = mysql_fetch_assoc($consignees);
$totalRows_consignees = mysql_num_rows($consignees);
?><!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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<style type="text/css">
<!--
body {
	background-color: #f5f5f5;
}
table{
	border-collapse:collapse;
}
a{
	text-decoration:none;
	color:#005EA7;
}
-->
</style>
 <link href="../../css/common_user.css" rel="stylesheet" type="text/css" />
 <style type="text/css">
<!--
.STYLE3 {
	font-size: 14px;
	font-weight: bold;
}
-->
</style>
</head>

<body>
<p class="phpshop123_user_title">添加收货地址</p>
</ br>
 <form method="post" name="form1" id="new_consignee_form" action="<?php echo $editFormAction; ?>">
  <table align="center" class="phpshop123_user_form_box">
    <tr valign="baseline">
      <td nowrap align="right">收货人:</td>
      <td><input name="name" type="text" value="" size="32" maxlength="10"></td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">手机:</td>
      <td><input name="mobile" type="text" value="" size="32" maxlength="11"></td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">省市:</td>
      <td><?php include($_SERVER['DOCUMENT_ROOT'].'/widget/area/index.php');?></td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">地址:</td>
      <td><input name="address" type="text" value="" size="32" maxlength="32"></td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">邮编:</td>
      <td><input name="zip" type="text" value="" size="32" maxlength="6"></td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">&nbsp;</td>
      <td><input type="submit" value="添加"></td>
    </tr>
  </table>
   <input type="hidden" name="MM_insert" value="form1">
</form>
  <?php if ($totalRows_consignees > 0) { // Show if recordset not empty ?>
    <p class="phpshop123_user_title">收货地址列表</p>
    <table width="100%" border="0" cellpadding="0">
      <tr>
        <td><table width="100%" border="0" cellpadding="0" bgcolor="#FFFFFF">
          <tr>
            <td>&nbsp;</td>
          </tr>
          <tr bordercolor="#E6E6E6">
            <td><?php do { ?>
                 
            <table width="100%" border="2" cellpadding="5" cellspacing="0" bordercolor="#e6e6e6">
              <tr>
                <td><table width="100%" border="0" cellpadding="0" bordercolor="#e6e6e6">
                  <tr>
                    <td height="35"><span class="STYLE3"><?php echo $row_consignees['name']; ?></span></td>
                    <td><?php if($row_consignees['is_default']=='1'){?>
					<div style="text-align:center;width:52px;height:20px;line-height:20px;background-color:#ffaa45;color:#fff;">默认地址</div>
					<?php } ?></td>
                    <td height="35"><div align="right"><a href="remove.php?id=<?php echo $row_consignees['id']; ?>">删除</a></div></td>
                  </tr>
                  <tr>
                    <td width="70"><div align="right">收货人：</div></td>
                    <td><?php echo $row_consignees['name']; ?></td>
                    <td>&nbsp;</td>
                  </tr>
                  <tr>
                    <td width="70"><div align="right">所在地区：</div></td>
                    <td><?php echo $row_consignees['province']; ?><?php echo $row_consignees['city']; ?><?php echo $row_consignees['district']; ?></td>
                    <td>&nbsp;</td>
                  </tr>
                  <tr>
                    <td width="70"><div align="right">地址：</div></td>
                    <td><?php echo $row_consignees['address']; ?></td>
                    <td>&nbsp;</td>
                  </tr>
                  <tr>
                    <td width="70"><div align="right">手机：</div></td>
                    <td><?php echo $row_consignees['mobile']; ?></td>
                    <td>&nbsp;</td>
                  </tr>
                  <tr>
                    <td width="70"><div align="right">邮编：</div></td>
                    <td><?php echo $row_consignees['zip']; ?></td>
                    <td>&nbsp;</td>
                  </tr>
                  <tr>
                    <td width="70"><div align="right"></div></td>
                    <td>&nbsp;</td>
                    <td><div align="right"><a href="update.php?id=<?php echo $row_consignees['id']; ?>">更新 </a> <a href="default.php?id=<?php echo $row_consignees['id']; ?>">设为默认</a></div></td>
                  </tr>
                </table></td>
              </tr>
            </table> <br><?php } while ($row_consignees = mysql_fetch_assoc($consignees)); ?></td>
          </tr>
          <tr>
            <td>&nbsp;</td>
          </tr>
        </table></td>
      </tr>
  </table>
    <?php } // Show if recordset not empty ?>
 	 
<script language="JavaScript" type="text/javascript" src="../../js/jquery-1.7.2.min.js"></script>
<script language="JavaScript" type="text/javascript" src="../../js/jquery.validate.min.js"></script>
<script>
$().ready(function(){
 	$("#new_consignee_form").validate({
        rules: {
             name: {
                required: true,
				minlength: 2,
             },
            mobile: {
                required: true,
                minlength: 11,
				digits:true   
            },
            address: {
                required: true,
                minlength: 3   
            },
 			zip: {
                required: true,
                minlength: 6,
				digits:true
            }
        } 
    });
});</script>
  
</body>
</html>
<?php
mysql_free_result($consignees);
?>