ps_vendor.inc

phpShop是一个基于php的分布式电子商务模块

    return True;
  }

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

    /* Delete Image files */
    if (!process_images($d)) {
      return false;
    }

    $q = "DELETE from vendor where vendor_id='" . $d["vendor_id"] . "'";
    $db->query($q);
    $db->next_record();

    return True;
  }

  /**************************************************************************
  ** name: get_user_vendor_id
  ** created by: jep
  ** description:
  ** parameters:
  ** returns:
  ***************************************************************************/
  function get_user_vendor_id() {
    global $auth;

    $db = new ps_DB;

    $q  = "SELECT vendor_id FROM auth_user_vendor ";
    $q .= "WHERE user_id='" . $auth["user_id"] . "'";
    $db->query($q);
    $db->next_record();
    return $db->f("vendor_id");
  }

  /**************************************************************************
   * name: find()
   * created by:
   * description:
   * parameters:
   * returns:
   **************************************************************************/
  function find($d, $start=0) {
    $db = new ps_DB;
    
    if ($d["vendor_thumb_image"] == "none") {
      $d["vendor_thumb_image"] = "";
    }
    if ($d["vendor_full_image"] == "none") {
      $d["vendor_full_image"] = "";
    }
    
    if ($d["vendor_category_id"] == "0") {
      $d["vendor_category_id"] = "";
    } 
    $q = "SELECT * from vendor where vendor_name LIKE '%" . $d["vendor_name"] . "%'";
    $q .= " AND contact_last_name LIKE '%" . $d["contact_last_name"] . "%'";
    $q .= " AND contact_first_name LIKE '%" . $d["contact_first_name"] . "%'";
    $q .= " AND contact_middle_name LIKE '%" . $d["contact_middle_name"] . "%'";
    $q .= " AND contact_title LIKE '%" . $d["contact_title"] . "%'";
    $q .= " AND contact_phone_1 LIKE '%" . $d["contact_phone_1"] . "%'";
    $q .= " AND contact_phone_2 LIKE '%" . $d["contact_phone_2"] . "%'";
    $q .= " AND contact_fax LIKE '%" . $d["contact_fax"] . "%'";
    $q .= " AND contact_email LIKE '%" . $d["contact_email"] . "%'";
    $q .= " AND vendor_phone LIKE '%" . $d["vendor_phone"] . "%'";
    $q .= " AND vendor_address_1 LIKE '%" . $d["vendor_address_1"] . "%'";
    $q .= " AND vendor_address_2 LIKE '%" . $d["vendor_address_2"] . "%'";
    $q .= " AND vendor_city LIKE '%" . $d["vendor_city"] . "%'";
    $q .= " AND vendor_state LIKE '%" . $d["vendor_state"] . "%'";
    $q .= " AND vendor_country LIKE '%" . $d["vendor_country"] . "%'";
    $q .= " AND vendor_zip LIKE '%" . $d["vendor_zip"] . "%'";
    $q .= " AND vendor_store_name LIKE '%" . $d["vendor_store_name"] . "%'";
    $q .= " AND vendor_store_desc LIKE '%" . $d["vendor_store_desc"] . "%'";
    $q .= " AND vendor_category_id LIKE '%" . $d["vendor_category_id"] . "%'";
    $q .= " AND vendor_thumb_image LIKE '%" . $d["vendor_thumb_image"] . "%'";
    $q .= " AND vendor_full_image LIKE '%" . $d["vendor_full_image"] . "%'";
    $q .= " AND vendor_currency LIKE '%" . $d["vendor_currency"] . "%'";

    $db->query($q);
    $db->next_record();
    if ($db->num_rows() == 1) {
      return "?vid=" . $db->f("vendor_id");
    }
    $t = new phpshop_Table;
    $t->query = $q;
    $t->table = "vendor";
    $t->start = $start;
    // Select fields to display
    $t->fields = array(
		       "vendor_id",
		       "vendor_name",
		       "vendor_store_desc"
		       );
    
    // Set column header names
    $t->map_cols = array(
			 "vendor_id" => "Vendor ID",
			 "vendor_name" => "Vendor Name",
			 "vendor_store_desc" => "Vendor Description"
			 );
    $t->show_table();    
    return True;
  }


  /**************************************************************************
   * name: listVendor()
   * created by:
   * description: Creates a list of SELECT recods using vendor name and vendor id.
   * parameters:
   * returns: array of values
   **************************************************************************/
  function get_name($vendor_id,$product_id="") {

    // Returns the vendor name corresponding to a vendor_id;
    $db = new ps_DB;

    if ($vendor_id) {
      $q = "SELECT vendor_name FROM vendor WHERE vendor_id = '$vendor_id'";
    } elseif ($product_id) {
      $q  = "SELECT vendor_name FROM product,vendor ";
      $q .= "WHERE product_id = '$product_id' ";
      $q .= "AND product.vendor_id = vendor.vendor_id ";
    } else {
      /* ERROR: No arguments were specified. */
      return 0;
    }
    
    $db->query($q);
    $db->next_record();
    return $db->f("vendor_name");
  }


  /**************************************************************************
   * name: set_vendor()
   * created by:
   * description: Creates a list of SELECT recods using vendor name and vendor id.
   * parameters:
   * returns: array of values
   **************************************************************************/
  function set_vendor($d) {
    global $ps_vendor_id, $sess;
 
    $ps_vendor_id = $d["vendor_id"];
    return True;

  }

  /**************************************************************************
  ** name: listVendor()
  ** created by:
  ** description: Creates a list of SELECT recods using vendor name and 
  **              vendor id.
  ** parameters:
  ** returns: array of values
  ***************************************************************************/
  function list_vendor($vendor_id=0) {
    global $ps_vendor_id, $sess;

    // Creates a form drop down list and prints it
    $db = new ps_DB;
    
    $q = "SELECT count(*) as rowcnt FROM vendor ORDER BY vendor_name";
    $db->query($q);
    $db->next_record();
    $rowcnt = $db->f("rowcnt");
 
    // If only one vendor do not show list 
    if ($rowcnt == 1) 
       return True;

    $q = "SELECT * FROM vendor ORDER BY vendor_name";
    $db->query($q);
   
    $code = "<form action=" . SECUREURL . " METHOD=POST>\n";
    $code .= "<INPUT TYPE=hidden name=page value=admin/index>\n";
    $code .= "<INPUT TYPE=hidden name=func value=setVendor>\n";
    $code .= $sess->hidden_session() . "\n";
    $code .= "<select name=vendor_id>\n";
    while ($db->next_record()) {     
      $code .= "  <option value=\"" . $db->f("vendor_id") . "\"";
      if ($db->f("vendor_id") == $vendor_id) { 
	$code .= " selected"; 
      }
      $code .= ">" . $db->f("vendor_name") . "</option>\n";
    }
    $code .= "</select><BR>\n";
    $code .= "<input type=submit name=go value=go>\n";
    $code .= "</FONT>";
    print $code;
  }

  /****************************************************************************
   *    function: validate_email
   *  created by: Gregory Day
   * description: Validates an e-mail address.  Only checks that the format
   *              is valid.  It does not validate that the address will
   *              work.
   *  parameters: $email: Email address to validate
   *     returns: true: Email address is valid
   *             false: Email address is not valid 
   ****************************************************************************/

  function validate_email ( $email ) {

   if(ereg('^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*$', $email)) {      return(true);
   }
   else {
      return(false);
   }
  } // validate_email() 

  /**************************************************************************
  ** name: get_field
  ** created by: pablo
  ** description:
  ** parameters:
  ** returns:
  ***************************************************************************/
  function get_field($vendor_id, $field_name) {
    $db = new ps_DB;

    $q = "SELECT $field_name FROM vendor WHERE vendor_id='$vendor_id'";
    $db->query($q);
    if ($db->next_record()) {
       return $db->f($field_name);
    }
    else {
       return False;
    }
  }


  /**************************************************************************
  ** name: show_image()
  ** created by: pablo
  ** description:  Shows the image send in the $image field.
  **               $args are appended to the IMG tag.
  ** parameters:
  ** returns:
  ***************************************************************************/
  function show_image($image, $args="") {
    
    global $ps_vendor_id;
   
    if ($SERVER_PORT == "443")
        $url = SECUREURL;
    else
        $url = URL;
 
    $url = $this->get_field($ps_vendor_id,"vendor_image_path");
    $url .= "vendor/";
    if (!isset($image) || ($image == "")) {
    	$url .= "noimage.gif";
    } else {
    	$url .= $image;
    }
    echo "<IMG SRC=$url $args>\n";
    
    return True;
  }
}
?>