ps_vendor.inc

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

<?php
/*
 * The ps_vendor class
 *
 * Copyright (c) Edikon Corporation.  All rights reserved.
 * Distributed under the phpShop Public License (pSPL) Version 1.0.
 *
 * $Id: ps_vendor.inc,v 1.1.1.1 2004/07/27 14:59:53 pablo Exp $
 *
 */


class ps_vendor {
  var $classname = "ps_vendor";
  var $error;


  /**************************************************************************
  ** name: validate_add()
  ** created by:
  ** description:
  ** parameters:
  ** returns:
  ***************************************************************************/ 
  function validate_add(&$d) {
    $db = new ps_DB;

    $q = "SELECT * from vendor";
    $db->query($q);
    if ($db->next_record()) {
      $d["error"] = "ERROR:  This version of phpShop only supports one vendor.";
      return false;
    } 
    if (!validate_image($d,"vendor_thumb_image","vendor")) {
      return false;
    }
    if (!validate_image($d,"vendor_full_image","vendor")) {
      return false;
    }
    if (!$d["vendor_name"]) {
      $d["error"] = "ERROR:  You must enter a name for the vendor.";
      return False;	
    }
    if (!$d["contact_email"]) {
      $d["error"]  = "ERROR:  You must enter an email address for the vendor ";
      $d["error"] .= "contact.";
      return False;
    }
    if (!validate_email($d["contact_email"])) {
      $d["error"]  = "ERROR:  Please provide a valide email address for the ";
      $d["error"] .= "vendor contact.";
      return False;
    } 
    else {
      return True;
    }
  }
  
  /**************************************************************************
  ** name: validate_delete()
  ** created by:
  ** description:
  ** parameters:
  ** returns:
  ***************************************************************************/    
function validate_delete(&$d) {
    $db = new ps_DB;

    if (!$d["vendor_id"]) {
      $d["error"] = "Please select a vendor to delete.";
      return False;
    }
    $q = "SELECT * FROM product where vendor_id='" . $d["vendor_id"] . "'";
    $db->query($q);
    if ($db->next_record()) {
      $d["error"]  = "ERROR:  This vendor still has products.  ";
      $d["error"] .= "Delete all products first.";
      return False;
    }

    /* Get the image filenames from the database */
    $db = new ps_DB;
    $q  = "SELECT vendor_thumb_image,vendor_full_image ";
    $q .= "FROM vendor ";
    $q .= "WHERE vendor_id='" . $d["vendor_id"] . "'";
    $db->query($q);
    $db->next_record();
 
    /* Validate vendor_thumb_image */
    $d["vendor_thumb_image_curr"] = $db->f("vendor_thumb_image");
    $d["vendor_thumb_image_name"] = "none";
    if (!validate_image($d,"vendor_thumb_image","vendor")) {
      return false;
    }
 
    /* Validate vendor_full_image */
    $d["vendor_full_image_curr"] = $db->f("vendor_full_image");
    $d["vendor_full_image_name"] = "none";
    if (!validate_image($d,"vendor_full_image","vendor")) {
      return false;
    }

    return True;
  }

  /**************************************************************************
  ** name: validate_update()
  ** created by:
  ** description:
  ** parameters:
  ** returns:
  ***************************************************************************/    
function validate_update(&$d) {
    
    if (!$d["vendor_name"]) {
      $d["error"] = "ERROR:  You must enter a name for the vendor.";
      return False;	
    }
    if (!validate_image($d,"vendor_thumb_image","vendor")) {
      return false;
    }
    if (!validate_image($d,"vendor_full_image","vendor")) {
      return false;
    }
    if (!$d["contact_email"]) {
      $d["error"]  = "ERROR:  You must enter an email address for the vendor ";
      $d["error"] .= "contact.";
      return False;
    }
    if (!validate_email($d["contact_email"])) {
      $d["error"]  = "ERROR:  Please provide a valide email address for the ";
      $d["error"] .= "vendor contact.";
      return False;
    } 
    else {
      return True;
    }
  }
  
  /**************************************************************************
   * name: add()
   * created by:
   * description:
   * parameters:
   * returns:
   **************************************************************************/
  function add(&$d) {
    $db = new ps_DB;
    $timestamp = time();

    if (!$this->validate_add($d)) {
      return False;
    }

    if (!process_images($d)) {
      return false;
    }

    $q = "INSERT INTO vendor (";
    $q .= "vendor_name,";
    $q .= "contact_last_name,";
    $q .= "contact_first_name,";
    $q .= "contact_middle_name,";
    $q .= "contact_title,";
    $q .= "contact_phone_1,";
    $q .= "contact_phone_2,";
    $q .= "contact_fax,";
    $q .= "contact_email,";
    $q .= "vendor_phone,";
    $q .= "vendor_address_1,";
    $q .= "vendor_address_2,";
    $q .= "vendor_city,";
    $q .= "vendor_state,";
    $q .= "vendor_country,";
    $q .= "vendor_zip,";
    $q .= "vendor_store_name,";
    $q .= "vendor_store_desc,";
    $q .= "vendor_category_id,";
    $q .= "vendor_image_path,";
    $q .= "vendor_thumb_image,";
    $q .= "vendor_full_image,";
    $q .= "vendor_currency,";
    $q .= "cdate,mdate) VALUES ('";
    $q .= $d["vendor_name"] . "','";
    $q .= $d["contact_last_name"] . "','";
    $q .= $d["contact_first_name"] . "','";
    $q .= $d["contact_middle_name"] . "','";
    $q .= $d["contact_title"] . "','";
    $q .= $d["contact_phone_1"] . "','";
    $q .= $d["contact_phone_2"] . "','";
    $q .= $d["contact_fax"] . "','";
    $q .= $d["contact_email"] . "','";
    $q .= $d["vendor_phone"] . "','";
    $q .= $d["vendor_address_1"] . "','";
    $q .= $d["vendor_address_2"] . "','";
    $q .= $d["vendor_city"] . "','";
    $q .= $d["vendor_state"] . "','";
    $q .= $d["vendor_country"] . "','";
    $q .= $d["vendor_zip"] . "','";
    $q .= $d["vendor_store_name"] . "','";
    $q .= $d["vendor_store_desc"] . "','";
    $q .= $d["vendor_category_id"] . "','";
    $q .= $d["vendor_image_path"] . "','";
    $q .= $d["vendor_thumb_image"] . "','";
    $q .= $d["vendor_full_image"] . "','";
    $q .= $d["vendor_currency"] . "','";
    $q .= "$timestamp','$timestamp')";
    $db->query($q);
    $db->next_record();

    // Get the assigned vendor_id //
    $q  = "SELECT vendor_id FROM vendor ";
    $q .= "WHERE vendor_name = '" . $d["vendor_name"] . "' ";
    $q .= "AND cdate = $timestamp";
    $db->query($q);
    $db->next_record();
    $d["vendor_id"] = $db->f("vendor_id");

    /* Insert -default- shopper group */
    $q = "INSERT INTO shopper_group (";
    $q .= "vendor_id,";
    $q .= "shopper_group_name,";
    $q .= "shopper_group_desc) VALUES ('";
    $q .= $d["vendor_id"] . "',";
    $q .= "'-default-',";
    $q .= "'Default shopper group.')";
    $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;
    }

    if (!process_images($d)) {
      return false;
    }

    $q = "UPDATE vendor set vendor_name='" . $d["vendor_name"] . "',";
    $q .= "contact_last_name='" . $d["contact_last_name"] . "',";
    $q .= "contact_first_name='" . $d["contact_first_name"] . "',";
    $q .= "contact_middle_name='" . $d["contact_middle_name"] . "',";
    $q .= "contact_title='" . $d["contact_title"] . "',";
    $q .= "contact_phone_1='" . $d["contact_phone_1"] . "',";
    $q .= "contact_phone_2='" . $d["contact_phone_2"] . "',";
    $q .= "contact_fax='" . $d["contact_fax"] . "',";
    $q .= "contact_email='" . $d["contact_email"] . "',";
    $q .= "vendor_phone='" . $d["vendor_phone"] . "',";
    $q .= "vendor_address_1='" . $d["vendor_address_1"] . "',";
    $q .= "vendor_address_2='" . $d["vendor_address_2"] . "',";
    $q .= "vendor_city='" . $d["vendor_city"] . "',";
    $q .= "vendor_state='" . $d["vendor_state"] . "',";
    $q .= "vendor_country='" . $d["vendor_country"] . "',";
    $q .= "vendor_zip='" . $d["vendor_zip"] . "',";
    $q .= "vendor_store_name='" . $d["vendor_store_name"] . "',";
    $q .= "vendor_store_desc='" . $d["vendor_store_desc"] . "',";
    $q .= "vendor_category_id='" . $d["vendor_category_id"] . "',";
    if ($d["vendor_image_path"])
    $q .= "vendor_image_path='" . $d["vendor_image_path"] . "',";
    $q .= "vendor_thumb_image='" . $d["vendor_thumb_image"] . "',";
    $q .= "vendor_full_image='" . $d["vendor_full_image"] . "',";
    $q .= "vendor_currency='" . $d["vendor_currency"] . "',";
    $q .= "mdate='$timestamp' ";
    $q .= "WHERE vendor_id='" . $d["vendor_id"] . "'";    
    $db->query($q);
    $db->next_record();