addSelectColumn (self::US2_RATE_CARD_ID);
$C->add (self::STORE_ID, $StoreId);
$C->add (self::PRODUCT_ID, $ProductId);
$Rs = self::doSelectRs($C);
while( $Rs->next() ) return $Rs->get(1);
return 0;
}
public static function GetByProductId ($ProductId=0)
{
$arrayRateCardId = array();
$C = new Criteria();
$C->addSelectColumn (self::US2_RATE_CARD_ID);
$C->addAnd (self::PRODUCT_ID, $ProductId);
$C->addAnd (self::ACTIVE_YN, 'Y');
$C->addDescendingOrderByColumn (self::START_DATE);
$Rs = self::doSelectRs($C);
while( $Rs->next() ) $arrayRateCardId[] = $Rs->get(1);
return $arrayRateCardId;
}
/**
*
* @param type $RateCardId
* @param type $StartDate
* @return type date or false if not found
*/
public static function GetLastUsedRateCardDate($RateCardId=0, $StartDate='1980-01-01')
{
$LastDate = false;
$C = new Criteria();
$C->add(Us2OrderProductPeer::PRODUCT_RATE_CARD_ID, $RateCardId);
$C->add(Us2OrderProductPeer::ADDED_DATE, $StartDate, Criteria::GREATER_THAN);
$C->addDescendingOrderByColumn(Us2OrderProductPeer::ADDED_DATE);
$C->add(Us2OrderProductPeer::ORDER_HANDLING_STATUS_ID, 9, Criteria::LESS_THAN);
$C->addSelectColumn(Us2OrderProductPeer::ADDED_DATE);
$C->addJoin(Us2OrderProductPeer::ORDER_ID , Us2OrderPeer::ORDER_ID);
$C->add(Us2OrderPeer::ORDER_HANDLING_STATUS_ID, 9, Criteria::LESS_THAN);
$C->setLimit(1);
$Rs = Us2OrderProductPeer::doSelectRs($C);
while($Rs->next())
{
$LastDate = $Rs->getString(1);
}
// echo "" . print_r($Rs, true) . "
";
return $LastDate;
}
}