CiviCRM Community Forums (archive)

Hi:

I need to get the PriceSet for an Event.
If I call the PriceSet API, I get something like this:

{
   "is_error":0,
   "version":3,
   "count":5,
   "values":[{
      "id":"1",
      "name":"default_contribution_amount",
      "title":"Contribution Amount",
      "is_active":"1",
      "extends":"2",
      "is_quick_config":"1",
      "is_reserved":"1",
      "entity":{
         "civicrm_contribution":["2"]
      }
   },
   {
      "id":"5",
      "name":"prueba_pagos",
      "title":"Prueba Pagos",
      "is_active":"1",
      "extends":"1",
      "financial_type_id":"4",
      "is_quick_config":"1",
      "is_reserved":"0",
      "entity":{
         "civicrm_event":["7"]
      }
   }]
}

What I need to know is how can I filter this call to get only the second record. I think it maybe something like:

civicrm_api('PriceSet','Get', array(
                                                        'version' => '3',
                                                        'field' => 'event_type',
                                                        'related_entity' => array('civicrm_event' => 5)
                                                        ));

But I can't get this to work.
Thanks in advance

Maybe this might help somebody. I have managed to do this by using the core functionality of CiviCRM.

First would be to get the event_id and then the magic happens below:

$discountId = CRM_Core_BAO_Discount::findSet($params['event_id'], 'civicrm_event');
if ($discountId) {
$priceSetId = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_Discount', $discountId, 'price_set_id');
}
else {
$priceSetId = CRM_Price_BAO_PriceSet::getFor('civicrm_event', $params['event_id']);
}

// get price set options, - CRM-5209
if ($priceSetId) {
$setDetails = CRM_Price_BAO_PriceSet::getSetDetail($priceSetId, TRUE, TRUE);

$lowestAmount = 1000000;
foreach($setDetails as $val1) {
  foreach ($val1['fields'] as $price) {
  foreach ($price['options'] as $priceSet) {
  if($priceSet['amount'] < $lowestAmount){
  $lowestAmount = $priceSet['amount'];
  }
  }
  }
}

$params['lowest_price'] = $lowestAmount;

return civicrm_api3_create_success($params);
}else{
$params['no_priceset'] = 1;
return $params;
}
For me, this code is used to get the lowest ticket price available for an event.

Hope this helps.