CiviCRM Community Forums (archive)

you might want to edit and add debug statements to the file:

CRM/Contact/Form/Search/Custom/PriceSet.php

and figure out whats happening and why. If you do find a bug, please submit a patch to fix it

thanx

lobo

hi, thanks for the feedback.
I will add debrug statements to see where it goes wrong.
And yes it is an upgrade, but i don't think that's the problem.

last night i also tried it in the demo and in the sandbox, both give 0 as the price results
You can see it here:
http://drupal.demo.civicrm.org/civicrm/contact/search/custom?_qf_Custom_display=true&qfKey=4c965800c72e74fa9e1c0626f624d198

What is the best way to get debug results from the file
CRM/Contact/Form/Search/Custom/PriceSet.php ?

thanx

Kurt

Hi, i've been trying some things today.
I'm a php coder, but not that familiar with civi.
I think the problem lies in updating the temporary table used to combine search results from different tables.
So maybe there's something wrong with the SQL statements. I'm looking into that for the moment. I will try to rewrite part of the SQL statements using INNER JOIN.
The first part seems to work as the participant list is shown in the output, but the part that is used to update the numbers for different price sets returns no results it seems.

I keep working on it, but every hint is welcome.

thanks

Kurt

Hi,

for what its worth, i think i found a solution for my problem.
I don't know if this is a good fix, but it works for us.

i did replace the SQL statements around line 114
with this
$sql="
SELECT c.contact_id,
       c.participant_id,
       v.id AS option_value_id,
       l.qty
FROM {$this->_tableName} c INNER JOIN civicrm_line_item l,
     civicrm_option_group g,
     civicrm_option_value v
WHERE c.participant_id = l.entity_id
AND   l.option_group_id = g.id
AND   v.option_group_id = g.id
AND   v.label = l.label
ORDER BY c.id, v.id
";
I did remove some things from the original because i don't use contributions or payments.

this is the original code

   $sql = "
SELECT c.id as contact_id,
       p.id as participant_id,
       v.id as option_value_id,
       l.qty
FROM   civicrm_contact c,
       civicrm_contribution o,
       civicrm_participant  p,
       civicrm_participant_payment pp,
       civicrm_line_item    l,
       civicrm_option_group g,
       civicrm_option_value v
WHERE  c.id = o.contact_id
AND    c.id = p.contact_id
AND    p.event_id = {$this->_eventID}
AND    pp.contribution_id = o.id
AND    pp.participant_id  = p.id
AND    o.id = l.entity_id
AND    l.option_group_id = g.id
AND    v.option_group_id = g.id
AND    v.label = l.label
ORDER BY c.id, v.id
";

thanx

Kurt