ps_user_address.inc

php做的网上商店系统。简单易懂

<?php


class ps_user_address {
  var $classname = "ps_user_address";

  /**************************************************************************
  ** name: validate_add()
  ** created by:
  ** description:
  ** parameters:
  ** returns:
  ***************************************************************************/
  function validate_add(&$d) {
    $valid = true;

    if (!$d["address_type_name"]) {
      $d["error"] .= "送货方式必需填写！<br>";
      $valid = false;
    }
    if (!$d["company"]) {
      $d["error"] .= "公司名称必需填写！<br>";
      $valid = false;
    }
    if (!$d["address"]) {
      $d["error"] .= "地址必需填写！<br>";
      $valid = false;
    }
    if (!$d["true_name"]) {
      $d["error"] .= "真实姓名必需填写！<br>";
      $valid = false;
    }
    if (!$d["country"]) {
      $d["error"] .= "国家必需填写！<br>";
      $valid = false;
    }
    if (!$d["zip"]) {
      $d["error"] .= "邮编必需填写！<br>";
      $valid = false;
    }
    if (!$d["phone"]) {
      $d["error"] .= "电话号码必需填写！<br>";
      $valid = false;
    }
    if (!$d["province"]) {
      $d["error"] .= "省份必需填写！<br>";
      $valid = false;
     }
     
    $db = new ps_DB;
    $q  = "SELECT * from user_info ";
    $q .= "WHERE address_type_name='" . $d["address_type_name"] . "' ";
    $q .= "AND address_type='" . $d["address_type"] . "' ";
    $q .= "AND user_id='" . $d["user_id"] . "'";
    $db->query($q);
    if ($db->next_record()) {
      $d["error"] .= "这个特定的地址标签已经存在.<br>";
      $valid = false;
    }
    return $valid;    
  }
  
  /**************************************************************************
  ** name: validate_delete()
  ** created by:
  ** description:
  ** parameters:
  ** returns:
  ***************************************************************************/
  function validate_delete(&$d) {

    if (!$d["user_info_id"]) {
      $d["error"] .= "请选择一个用户删除！.<br>";
      return false;
    }
    else {
      return true;
    }
  }

  /**************************************************************************
  ** name: validate_update()
  ** created by:
  ** description:
  ** parameters:
  ** returns:
  ***************************************************************************/
  function validate_update(&$d) {
    $valid = true;

    if (!$d["address_type_name"]) {
      $d["error"] .= "'Address Label'必需填写！<br>";
      $valid = false;
    }
    if (!$d["last_name"]) {
      $d["error"] .= "'Last Name'必需填写！<br>";
      $valid = false;
    }
    if (!$d["first_name"]) {
      $d["error"] .= "'First Name'必需填写！<br>";
      $valid = false;
    }
    return $valid;
  }
  
  /**************************************************************************
  ** name: add()
  ** created by:
  ** description:
  ** parameters:
  ** returns:
  ***************************************************************************/
  function add(&$d) {
    $hash_secret = "PHPShopIsCool";
    $db = new ps_DB;
    $timestamp = time();
    
    if (!$this->validate_add($d)) {
      return false;
    }
 
    $q = "INSERT INTO user_info (user_id,address_type,address_type_name,";
    $q .= "user_name,question,answer,true_name,year, month,dey,sex,";
    $q .= "card,email,company,";
    $q .= "phone,fax,address,zip,Country,province,";
    $q .= "cdate,mdate) VALUES ('";
    $q .= $d["user_id"] . "','";
    $q .= $d["address_type"] . "','";
    $q .= $d["address_type_name"] . "','";
    $q .= $d["user_name"] . "','";
    $q .= $d["question"] . "','";
    $q .= $d["answer"] . "','";
    $q .= $d["true_name"] . "','";
    $q .= $d["year"] . "','";
    $q .= $d["month"] . "','";
    $q .= $d["dey"] . "','";
    $q .= $d["fax"] . "','";
    $q .= $d["sex"] . "','";
    $q .= $d["card"] . "','";
    $q .= $d["email"] . "','";
    $q .= $d["company"] . "','";
    $q .= $d["phone"] . "','";
    $q .= $d["fax"] . "','";
    $q .= $d["address"] . "','";
    $q .= $d["zip"] . "','";              
    $q .= $d["country"] . "','";
    $q .= $d["province"] . "','";
    $q .= $timestamp . "','";
    $q .= $timestamp . "') ";
    $db->query($q);

    return true;
  }
  
  /**************************************************************************
   * name: update()
   * created by:
   * description:
   * parameters:
   * returns:
   **************************************************************************/
  function update(&$d) {
    $db = new ps_DB;
    $timestamp = time();
    
    if (!$this->validate_update($d)) {
      return false;
    }

    $q  = "UPDATE user_info set company='" . $d["company"] . "', ";
    $q .= "address_type='" . $d["address_type"] . "', ";
    $q .= "address_type_name='" . $d["address_type_name"] . "', ";
    $q .= "user_name='" . $d["user_name"] . "', ";
    $q .= "question='" . $d["question"] . "', ";
    $q .= "answer='" . $d["answer"] . "', ";
    $q .= "true_name='" . $d["true_name"] . "', ";
    $q .= "year='" . $d["year"] . "', ";
    $q .= "month='" . $d["month"] . "', ";
    $q .= "dey='" . $d["dey"] . "', ";
    $q .= "address='" . $d["address"] . "', ";
    $q .= "address_2='" . $d["address_2"] . "', ";
    $q .= "city='" . $d["city"] . "', ";
    $q .= "state='" . $d["state"] . "', ";
    $q .= "country='" . $d["country"] . "', ";
    $q .= "zip='" . $d["zip"] . "', ";
    $q .= "mdate='" . $timestamp . "' ";
    $q .= "WHERE user_info_id='" . $d["user_info_id"] . "'";
    $db->query($q);

    return true;
  }
  
  /**************************************************************************
  ** name: delete()
  ** created by:
  ** description:
  ** parameters:
  ** returns:
  ***************************************************************************/
  function delete(&$d) {
    $db = new ps_DB;
    
    if (!$this->validate_delete($d)) {
      return false;
    }

    $q  = "DELETE from user_info ";
    $q .= "WHERE user_info_id='" . $d["user_info_id"] . "'";
    $db->query($q);

    return true;
  }

}
?>