PHP Membership::LoadArrayByStartDateRange示例

示例#1

文件： reports.php 项目： alcf/chms

 protected function dtgNewMembers_Bind()
 {
     $dtAfterValue = new QDateTime($this->dtxAfterValue->Text);
     $dtBeforeValue = new QDateTime($this->dtxBeforeValue->Text);
     $this->dtgNewMembers->TotalItemCount = Membership::CountArrayByStartDateRange($dtAfterValue, $dtBeforeValue);
     $objMembershipArray = Membership::LoadArrayByStartDateRange($dtAfterValue, $dtBeforeValue, $this->dtgNewMembers->LimitClause);
     $this->dtgNewMembers->DataSource = $objMembershipArray;
 }

示例#2

文件： newMembers.php 项目： alcf/chms

 protected function dtgNewMembers_Bind()
 {
     $dtAfterValue = new QDateTime($this->dtxAfterValue->Text);
     $dtBeforeValue = new QDateTime($this->dtxBeforeValue->Text);
     $objcondition = QQ::Equal(QQN::Membership()->Person->AttributeValue->Attribute->Name, 'Post-2016');
     $this->dtgNewMembers->TotalItemCount = Membership::CountArrayByStartDateRange($dtAfterValue, $dtBeforeValue, $objcondition);
     $objMembershipArray = Membership::LoadArrayByStartDateRange($dtAfterValue, $dtBeforeValue, $objcondition, $this->dtgNewMembers->LimitClause);
     $this->dtgNewMembers->DataSource = $objMembershipArray;
     $this->iTotalCount = count($objMembershipArray);
     $this->CalculateMaritalAndAgeStatus($objMembershipArray);
     $this->CalculateAttributeStatistics($objMembershipArray);
 }

示例#3

文件： export_to_excel.php 项目： alcf/chms

<?php

require dirname(__FILE__) . '/../../includes/prepend.inc.php';
QApplication::Authenticate();
$dtAfterValue = new QDateTime(QApplication::PathInfo(0));
$dtBeforeValue = new QDateTime(QApplication::PathInfo(1));
$bIsExit = false;
if (QApplication::PathInfo(2) == "exit") {
    $bIsExit = true;
}
$objMembershipArray;
if ($bIsExit) {
    $objMembershipArray = Membership::LoadArrayByEndDateRange($dtAfterValue, $dtBeforeValue, QQ::All());
} else {
    $objMembershipArray = Membership::LoadArrayByStartDateRange($dtAfterValue, $dtBeforeValue, QQ::All());
}
$iTotalCount = count($objMembershipArray);
if (!$objMembershipArray || !QApplication::PathInfo(0) || !QApplication::PathInfo(1)) {
    if ($bIsExit) {
        QApplication::Redirect('/individuals/report_exit_members.php');
    } else {
        QApplication::Redirect('/individuals/reports.php');
    }
}
// Disable strict no-cache for IE due to IE issues with downloading no-cache items
if (QApplication::IsBrowser(QBrowserType::InternetExplorer)) {
    header("Pragma:");
    header("Expires:");
}
header('Content-Type: text/csv');
header('Content-Disposition: attachment; filename=MemberReport.csv');