<?php
// ==================================================================
//
// WARNING : Do not edit this file by hand.  This file was created
// by SoProMach.  Edit the definition files and re-generate to make
// modifications.  Making modifications to this file directly will
// result in loss of work when the file is re-generated.
//
// ==================================================================
//
// StoreBookSS.php

require_once("pgdb.php");

require_once("StoreBookWithNamesValue.php"); 
require_once("StoreBookValue.php"); 

  // ===================================================================
  // SQL selects for each value object
  define('StoreBookSelectStoreBookWithNamesValue' ,"select StoreBook1.storeId,StoreBook1.bookId,StoreBook1.quantity,Store1.name,Book1.title from StoreBook StoreBook1 ,Store Store1 ,Book Book1  where StoreBook1.storeId = Store1.storeId and StoreBook1.bookId = Book1.bookId ");

  define('StoreBookSelectStoreBookValue' ,"select StoreBook1.storeId,StoreBook1.bookId,StoreBook1.quantity from StoreBook StoreBook1  ");


class StoreBookSS {
  // ===================================================================
  // SS methods
  
  //--------------------------------------------------------------------
  function getStoreBookValue(
    $storeId
    ,$bookId
    ) 
  {
      $params = array();
      $params[] = $storeId;
      $params[] = $bookId;
  
       $sql = StoreBookSelectStoreBookValue
           . " where "
           . "  StoreBook1.storeId = ?  and StoreBook1.bookId = ? "
        ;

      return
       pgdb_firstRow(
         pgdb_runSqlP($sql,
            create_function('$rs',
                '$t = new StoreBookValue(); $t->setFromRow($rs); return $t;'),$params
       )
      );
   
  }
  
  //--------------------------------------------------------------------
  /**
    * returns array of StoreBookValue
    */
  function getAllStoreBookValue(
    $orderBy
    ) 
  {
      $params = array();
  
       $sql = StoreBookSelectStoreBookValue
        ;

      if(!empty($orderBy)){
        $sql = $sql . " order by " . $orderBy;
      }

      return
         pgdb_runSqlP($sql,
            create_function('$rs',
                '$t = new StoreBookValue(); $t->setFromRow($rs); return $t;'),$params
      );
   
  }
  
  //--------------------------------------------------------------------
  function add(
    $value
    ) 
  {

    $sql = "insert into StoreBook ( " . 
       "storeId " .
       ",bookId " .
       ",quantity " .
      " ) values ( " .
       "? " .
       ",? " .
       ",? " .
      ")";

    $params = array();
    $params[] = $value->getStoreId();
    $params[] = $value->getBookId();
    $params[] = $value->getQuantity();
     
    pgdb_runSqlP($sql,null,$params);
   
  }
  
  //--------------------------------------------------------------------
  function update(
    $value
    ) 
  {

    $sql = "update StoreBook set " .
       "quantity = ? " .
       " where " .
       "storeId = ? " .
       " and bookId = ? " .
       "";
    $params = array();
    $params[] = $value->getQuantity();
    $params[] = $value->getStoreId();
    $params[] = $value->getBookId();
     
    pgdb_runSqlP($sql,null,$params);
   
  }
  
  //--------------------------------------------------------------------
  function delete(
    $storeId
    ,$bookId
    ) 
  {

    $sql = "delete from StoreBook where " .
       "storeId = ? " .
       " and bookId = ? " .
       "";
    $params = array();
    $params[] = $storeId;
    $params[] = $bookId;

    pgdb_runSqlP($sql,null,$params);
   
  }

  //--------------------------------------------------------------------
  function getStoreBookWithNamesValue(
    $storeId
    ,$bookId
    ) 
  {
      $params = array();
      $params[] = $storeId;
      $params[] = $bookId;
  
       $sql = StoreBookSelectStoreBookWithNamesValue
           . " and "
           . "  StoreBook1.storeId = ?  and StoreBook1.bookId = ? "
        ;

      return
       pgdb_firstRow(
         pgdb_runSqlP($sql,
            create_function('$rs',
                '$t = new StoreBookWithNamesValue(); $t->setFromRow($rs); return $t;'),$params
       )
      );
   
  }
  
  //--------------------------------------------------------------------
  /**
    * returns array of StoreBookWithNamesValue
    */
  function getAllStoreBookWithNamesValue(
    $orderBy
    ) 
  {
      $params = array();
  
       $sql = StoreBookSelectStoreBookWithNamesValue
        ;

      if(!empty($orderBy)){
        $sql = $sql . " order by " . $orderBy;
      }

      return
         pgdb_runSqlP($sql,
            create_function('$rs',
                '$t = new StoreBookWithNamesValue(); $t->setFromRow($rs); return $t;'),$params
      );
   
  }
}

//
// ==================================================================
//
// WARNING : Do not edit this file by hand.  This file was created
// by SoProMach.  Edit the definition files and re-generate to make
// modifications.  Making modifications to this file directly will
// result in loss of work when the file is re-generated.
//
// ==================================================================
?>