Exemplos de CRM_Member_DAO_Membership::query em PHP

Exemplo n.º 1

Arquivo: GenerateData.php Projeto: FundingWorks/civicrm-core

 private function addMembershipLog()
 {
     $membership = new CRM_Member_DAO_Membership();
     $membership->query("SELECT id FROM civicrm_membership");
     while ($membership->fetch()) {
         $ids[] = $membership->id;
     }
     foreach ($ids as $id) {
         $membership = new CRM_Member_DAO_Membership();
         $membership->id = $id;
         $membershipLog = new CRM_Member_DAO_MembershipLog();
         if ($membership->find(TRUE)) {
             $membershipLog->membership_id = $membership->id;
             $membershipLog->status_id = $membership->status_id;
             $membershipLog->start_date = self::repairDate($membership->start_date);
             $membershipLog->end_date = self::repairDate($membership->end_date);
             $membershipLog->modified_id = $membership->contact_id;
             $membershipLog->modified_date = date("Ymd");
             $membershipLog->membership_type_id = $membership->membership_type_id;
             $membershipLog->save();
         }
         $membershipLog = NULL;
     }
 }

Exemplo n.º 2

Arquivo: GenerateReportData.php Projeto: ksecor/civicrm

 function addMembershipLog()
 {
     $membership = new CRM_Member_DAO_Membership();
     $membership->query("SELECT id FROM civicrm_membership");
     while ($membership->fetch()) {
         $ids[] = $membership->id;
     }
     require_once 'CRM/Member/DAO/MembershipLog.php';
     foreach ($ids as $id) {
         $membership = new CRM_Member_DAO_Membership();
         $membership->id = $id;
         $membershipLog = new CRM_Member_DAO_MembershipLog();
         if ($membership->find(true)) {
             $membershipLog->membership_id = $membership->id;
             $membershipLog->status_id = $membership->status_id;
             $membershipLog->start_date = self::repairDate($membership->start_date);
             $membershipLog->end_date = self::repairDate($membership->end_date);
             $membershipLog->modified_id = $membership->contact_id;
             $membershipLog->modified_date = date("Ymd");
             $membershipLog->save();
         }
         $membershipLog = null;
     }
 }