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; } }
/** * Returns the list of fields that can be exported * * @param bool $prefix * * @return array */ static function &export($prefix = false) { if (!self::$_export) { self::$_export = array(); $fields = self::fields(); foreach ($fields as $name => $field) { if (CRM_Utils_Array::value('export', $field)) { if ($prefix) { self::$_export['membership_log'] =& $fields[$name]; } else { self::$_export[$name] =& $fields[$name]; } } } } return self::$_export; }
/** * Function to delete membership log record * * @param int $membershipTypeId * @static */ static function del($membershipID) { $membershipLog = new CRM_Member_DAO_MembershipLog(); $membershipLog->membership_id = $membershipID; return $membershipLog->delete(); }
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; } }