PHP CRM_Event_DAO_Participant::query Examples

Programming Language: PHP

Method/Function: query

Examples at hotexamples.com: 1

PHP CRM_Event_DAO_Participant::query - 1 examples found. These are the top rated real world PHP examples of CRM_Event_DAO_Participant::query extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

find(11)

export(4)

fields(3)

_fields(3)

import(3)

_links(3)

save(2)

free(2)

selectAdd(2)

delete(2)

copyValues(2)

fetch(1)

_export(1)

_import(1)

query(1)

_fieldKeys(1)

__construct(1)

Example #1

Show file

File: GenerateData.php Project: FundingWorks/civicrm-core

 private function addLineItemParticipants()
 {
     $participant = new CRM_Event_DAO_Participant();
     $participant->query("INSERT INTO civicrm_line_item (`entity_table`, `entity_id`, contribution_id, `price_field_id`, `label`, `qty`, `unit_price`, `line_total`, `participant_count`, `price_field_value_id`, `financial_type_id`)\nSELECT 'civicrm_participant', cp.id, cpp.contribution_id, cpfv.price_field_id, cpfv.label, 1, cpfv.amount, cpfv.amount as line_total, 0, cpfv.id, cpfv.financial_type_id FROM civicrm_participant cp LEFT JOIN civicrm_participant_payment cpp ON cpp.participant_id = cp.id\nLEFT JOIN civicrm_price_set_entity cpe ON cpe.entity_id = cp.event_id LEFT JOIN civicrm_price_field cpf ON cpf.price_set_id = cpe.price_set_id LEFT JOIN civicrm_price_field_value cpfv ON cpfv.price_field_id = cpf.id WHERE cpfv.label = cp.fee_level");
 }