CiviCRM Community Forums (archive)

Where are the text strings located for civicrm_contribution.contribution_status_id?? I can't find them anywhere. Is this conversion handled somewhere in the php? Since everything else seems dynamically links to the database I wouldn't think so. I'm working on a system to pull that data off and yet I can't find where it's done....

Here's what I'm trying to do:

Print

SELECT civicrm_######.status_description (or whatever it's called...can't find)

WHERE civicrm_#####.status_id = civicrm_contribution.contribution_status_id

So basically if civicrm_contribution.contribution_status_id = 1 and that actually means 'Completed' or 'Pending' I'm trying to locate where in the schema the 'Completed', 'Pending', etc... strings are stored. Any ideas? I've looked all evening.

As Eileen said these values are coming from civicrm_option_group and civicrm_option_value tables.

here option group name is 'contribution_status'. Do check values from civicrm_option_value corresponding to contribution status option group.
query might be like :

SELECT   vals.value value,
         vals.name constantName,
         vals.label canBeModifyLabel
     FROM civicrm_option_value vals
LEFT JOIN civicrm_option_group grp  ON ( grp.id = vals.option_group_id )
   WHERE grp.name = 'contribution_status';

we consider column value as a status from civicrm_option_value.

to access these values check ( http://sandbox.civicrm.org/civicrm/admin/options?reset=1 )
find name = 'contribution_status' and click on "Multiple Choice Options" ( http://sandbox.civicrm.org/civicrm/admin/optionValue?reset=1&action=browse&gid=11 )

Here 'Title' ( civicrm_option_value.label ) can be modified and on user end we expose these strings ( viewable status on forms and in receipts )

click on 'Edit' -
here Name is constant string( civicrm_option_value.name ) and which is used for internal programing logic.

so if we want to update any contribution to Completed -  we pull civicm_option_value.value where civicrm_option_value.name = 'Completed'

To easily access these values in program -

require_once 'CRM/Contribute/PseudoConstant.php';
$contributionStatuses = CRM_Contribute_PseudoConstant::contributionStatus( null, 'name' );
$completedStatusId     = array_search( 'Completed', $contributionStatuses );

HTH

kiran