<?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.8 2000/09/13 16:37:21 pfmartin 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 市場價 shopper group */    $q = "INSERT INTO shopper_group (";    $q .= "vendor_id,";    $q .= "shopper_group_name,";    $q .= "shopper_group_desc) VALUES ('";    $q .= $d["vendor_id"] . "',";    $q .= "'市場價',";    $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"] . "'";