<?php
/*
*
* -------------------------------------------------------
* Nom de la classe :       shoppingcart
* Générateur :             gaggen-v3
* Date de la génération :  04.08.2008
* Nom du fichier :         shoppingcart.php
* Pour la table :          shoppingcart
* Pour la base  :          *******
* -------------------------------------------------------
*
*/
class shoppingcart
{
// **********************
// Déclaration des attributs
// **********************
protected $ID_ShoppingCart; // la clé autoincrémente
protected $IP;
protected $ID_Contact;
protected $ID_SponsorContact;
protected $CreationDate;
protected $ID_CreatedBy;
protected $Version;
protected $LastModificationDate;
protected $ID_LastModifiedBy;
// **********************
// Object parents ( clés étrangères de la base )
// utiliser les méthodes getParent[...]() pour charger les objets
// **********************
protected $Parent_Contact;
protected $Parent_SponsorContact;
protected $Parent_CreatedBy;
protected $Parent_LastModifiedBy;
// **********************
// Object enfants ( clés étrangères de la base )
// utiliser les méthodes get[...]() pour charger les collections objets
// **********************
protected $Shoppingcartline_ShoppingCart;
// **********************
// Constructeur (nouveau ou chargement)
// **********************
function shoppingcart($id = null)
{
global $connection;
if ((isset($id))&&($id!=0))
{
  $query="SELECT * FROM shoppingcart WHERE ID_ShoppingCart = $id";
  $result=sql_query($query,$connection);
  $row = sql_fetch_object($result);
  $this->ID_ShoppingCart = $row->ID_ShoppingCart;
  $this->IP = $row->IP;
  $this->ID_Contact = $row->ID_Contact;
  $this->ID_SponsorContact = $row->ID_SponsorContact;
  $this->CreationDate = $row->CreationDate;
  $this->ID_CreatedBy = $row->ID_CreatedBy;
  $this->Version = $row->Version;
  $this->LastModificationDate = $row->LastModificationDate;
  $this->ID_LastModifiedBy = $row->ID_LastModifiedBy;
}
}
// **********************
// Méthodes get et set pour les variables de la classe
// **********************
function getID_ShoppingCart()
{
return($this->ID_ShoppingCart);
}
function getIP()
{
return($this->IP);
}
function setIP($valeur)
{
$this->IP=$valeur; 
}
function getID_Contact()
{
return($this->ID_Contact);
}
function setID_Contact($valeur)
{
$this->ID_Contact=$valeur;
if (!is_null($this->Parent_Contact))
  getParent_Contact();
}
function getID_SponsorContact()
{
return($this->ID_SponsorContact);
}
function setID_SponsorContact($valeur)
{
$this->ID_SponsorContact=$valeur;
if (!is_null($this->Parent_SponsorContact))
  getParent_SponsorContact();
}
function getCreationDate()
{
return($this->CreationDate);
}
function setCreationDate($valeur)
{
$this->CreationDate=$valeur; 
}
function getID_CreatedBy()
{
return($this->ID_CreatedBy);
}
function setID_CreatedBy($valeur)
{
$this->ID_CreatedBy=$valeur;
if (!is_null($this->Parent_CreatedBy))
  getParent_CreatedBy();
}
function getVersion()
{
return($this->Version);
}
function setVersion($valeur)
{
$this->Version=$valeur; 
}
function getLastModificationDate()
{
return($this->LastModificationDate);
}
function setLastModificationDate($valeur)
{
$this->LastModificationDate=$valeur; 
}
function getID_LastModifiedBy()
{
return($this->ID_LastModifiedBy);
}
function setID_LastModifiedBy($valeur)
{
$this->ID_LastModifiedBy=$valeur;
if (!is_null($this->Parent_LastModifiedBy))
  getParent_LastModifiedBy();
}
// **********************
// Méthodes get et set pour les objets parents
// **********************
function getParent_Contact()
{
$this->Parent_Contact=new contact($this->ID_Contact);
}
function setParent_Contact($contact)
{
$this->ID_Contact=$contact->getID_Contact();
$this->Parent_Contact=$contact;
}
function getParent_SponsorContact()
{
$this->Parent_SponsorContact=new contact($this->ID_SponsorContact);
}
function setParent_SponsorContact($contact)
{
$this->ID_SponsorContact=$contact->getID_Contact();
$this->Parent_SponsorContact=$contact;
}
function getParent_CreatedBy()
{
$this->Parent_CreatedBy=new contact($this->ID_CreatedBy);
}
function setParent_CreatedBy($contact)
{
$this->ID_CreatedBy=$contact->getID_Contact();
$this->Parent_CreatedBy=$contact;
}
function getParent_LastModifiedBy()
{
$this->Parent_LastModifiedBy=new contact($this->ID_LastModifiedBy);
}
function setParent_LastModifiedBy($contact)
{
$this->ID_LastModifiedBy=$contact->getID_Contact();
$this->Parent_LastModifiedBy=$contact;
}
// **********************
// Méthodes get, set et add pour les objets enfants
// **********************
function getShoppingcartline_ShoppingCart()
{
global $connection;
if (is_null($this->Shoppingcartline_ShoppingCart))
{
  $query="SELECT * FROM shoppingcartline WHERE ID_ShoppingCart = $this->ID_ShoppingCart";
  $result=sql_query($query,$connection);
  while($row = sql_fetch_object($result,"shoppingcartline" ))
         {
             $this->addShoppingcartline_ShoppingCart($row);
         }
}
return ($this->Shoppingcartline_ShoppingCart);
}
function addShoppingcartline_ShoppingCart(shoppingcartline $shoppingcartline)
{
$shoppingcartline->setID_ShoppingCart($this->ID_ShoppingCart);
$this->Shoppingcartline_ShoppingCart[count($this->Shoppingcartline_ShoppingCart)]=$shoppingcartline;
}
function setShoppingcartline_ShoppingCart($childobjects)
{
$this->Shoppingcartline_ShoppingCart=$childobjects;
}
function saveShoppingcartline_ShoppingCart($transaction = null)
{
$count=count($this->Shoppingcartline_ShoppingCart);
$i=0;
while ($i<$count)
{
  $this->Shoppingcartline_ShoppingCart[$i]->setID_ShoppingCart($this->ID_ShoppingCart);
  $this->Shoppingcartline_ShoppingCart[$i]->save($transaction);
  $i++;
}
}
function deleteShoppingcartline_ShoppingCart($transaction = null)
{
$count=count($this->Shoppingcartline_ShoppingCart);
$i=0;
while ($i<$count)
{
  $this->Shoppingcartline_ShoppingCart[$i]->delete($transaction);
  $i++;
}
}
// **********************
// DELETE
// **********************
function delete($transaction = null)
{
global $connection;
if ((isset($this->ID_ShoppingCart))&&($this->ID_ShoppingCart!=0))
{
  //Version à 0 a la place ?
  $query = "UPDATE shoppingcart SET Version = -1 WHERE ID_ShoppingCart = $this->ID_ShoppingCart";
  //$query = "DELETE FROM shoppingcart WHERE ID_ShoppingCart = $this->ID_ShoppingCart";
  sql_query($query,$connection);
  return(sql_affected_rows($connection));
}
}
// **********************
// SAVE (INSERT ou UPDATE)
// **********************
function save($transaction = null)
{
global $connection;
global $transactionmode;
$fields = "";
$values = "";
$fieldsup = "";
$thistransaction = "Off";
if ((is_null($transaction))&&($transactionmode == 1))
{
  sql_starttransaction($connection);
  $transaction = "On";
  $thistransaction = "On";
}
$fields.= "`IP` ,";
$values .= " ".$this->IP.",";
$fieldsup.= "`IP` = ".$this->IP.", ";
$fields.= "`ID_Contact` ,";
$values .= " ".$this->ID_Contact.",";
$fieldsup.= "`ID_Contact` = ".$this->ID_Contact.", ";
$fields.= "`ID_SponsorContact` ,";
if (is_null($this->ID_SponsorContact))
{
$values .= "null, ";
$fieldsup.= "`ID_SponsorContact` = null ,";
}
else
{
$values .= " ".$this->ID_SponsorContact.",";
$fieldsup.= "`ID_SponsorContact` = ".$this->ID_SponsorContact.", ";
}
$fields.= "`CreationDate` ,";
$values .= "now() ,";
$fieldsup.= "`CreationDate` = '".$this->CreationDate."', ";
$fields.= "`ID_CreatedBy` ,";
$values .= " ".$this->ID_CreatedBy.",";
$fieldsup.= "`ID_CreatedBy` = ".$this->ID_CreatedBy.", ";
$fields.= "`Version` ,";
$values .= "1 ,";
$fieldsup.= "`Version` = ".$this->Version.", ";
$fields.= "`LastModificationDate` ,";
$values .= "now() ,";
$fieldsup.= "`LastModificationDate` = '".$this->LastModificationDate."', ";
$fields.= "`ID_LastModifiedBy` ,";
$values .= " ".$this->ID_LastModifiedBy.",";
$fieldsup.= "`ID_LastModifiedBy` = ".$this->ID_LastModifiedBy.", ";
if ((isset($this->ID_ShoppingCart))&&($this->ID_ShoppingCart!=0))
{
  $fieldsup = substr($fieldsup,0,strlen($fieldsup)-2);
  $query = "UPDATE shoppingcart SET $fieldsup WHERE ID_ShoppingCart = $this->ID_ShoppingCart";
  $result=sql_query($query,$connection);
  if (sql_error($connection))
  {
   $erreur=sql_error($connection)."<br>".$query;
   if ($transaction=="On" )
   {
    sql_rollbacktransaction($connection);
   }
   trigger_error($erreur,E_USER_ERROR);
  }
}
else
{
  $fields = substr($fields,0,strlen($fields)-1);
  $values = substr($values,0,strlen($values)-1);
  $query = "INSERT INTO shoppingcart ($fields ) VALUES ( $values )";
  sql_query($query,$connection);
  if (sql_error($connection))
  {
   $erreur=sql_error($connection)."<br>".$query;
   if ($transaction=="On" )
   {
    sql_rollbacktransaction($connection);
   }
   trigger_error($erreur,E_USER_ERROR);
  }
  else
   $this->ID_ShoppingCart=sql_insert_id($connection);
}
if (!is_null($this->Parent_Contact))
  $this->Parent_Contact->save($transaction);
if (!is_null($this->Parent_SponsorContact))
  $this->Parent_SponsorContact->save($transaction);
if (!is_null($this->Parent_CreatedBy))
  $this->Parent_CreatedBy->save($transaction);
if (!is_null($this->Parent_LastModifiedBy))
  $this->Parent_LastModifiedBy->save($transaction);
if (!is_null($this->Shoppingcartline_ShoppingCart))
  $this->saveShoppingcartline_ShoppingCart($transaction);
if (($transaction=="On" )&&($thistransaction=="On" ))
{
  sql_committransaction($connection);
  $transaction = null;
  $thistransaction = null;
}
return $this->ID_ShoppingCart;
}
//endofclass
}
?>

window.addEvent('domready', function(){
    toto = new Toto();
});