PHP ewr_DetailFilterSQLの例

コード例 #1

ファイル: inv500ctb.php プロジェクト: nirantarnoy/st2

            }
        }
        ?>
<!-- Dynamic columns end -->
	</tr>
</thead>
<tbody>
<?php 
        if ($Page->TotalGrps == 0) {
            break;
        }
        // Show header only
        $Page->ShowHeader = FALSE;
    }
    // Build detail SQL
    $sWhere = ewr_DetailFilterSQL($Page->invid, $Page->getSqlFirstGroupField(), $Page->invid->GroupValue());
    if ($Page->PageFirstGroupFilter != "") {
        $Page->PageFirstGroupFilter .= " OR ";
    }
    $Page->PageFirstGroupFilter .= $sWhere;
    if ($Page->Filter != "") {
        $sWhere = "({$Page->Filter}) AND ({$sWhere})";
    }
    $sSql = ewr_BuildReportSql(str_replace("<DistinctColumnFields>", $Page->DistinctColumnFields, $Page->getSqlSelect()), $Page->getSqlWhere(), $Page->getSqlGroupBy(), "", $Page->getSqlOrderBy(), $sWhere, $Page->Sort);
    $rs = $conn->Execute($sSql);
    $rsdtlcnt = $rs ? $rs->RecordCount() : 0;
    if ($rsdtlcnt > 0) {
        $Page->GetRow(1);
    }
    while ($rs && !$rs->EOF) {
        $Page->RecCount++;

コード例 #2

ファイル: University_Vs_Rejected_Candidatesctb.php プロジェクト: vbalalla/project_CV_and_Recruitment_Management

><?php 
        echo $ReportLanguage->Phrase("Total");
        ?>
</div></td>
	</tr>
</thead>
<tbody>
<?php 
        if ($Page->TotalGrps == 0) {
            break;
        }
        // Show header only
        $Page->ShowHeader = FALSE;
    }
    // Build detail SQL
    $sWhere = ewr_DetailFilterSQL($Page->University, $Page->getSqlFirstGroupField(), $Page->University->GroupValue());
    if ($Page->PageFirstGroupFilter != "") {
        $Page->PageFirstGroupFilter .= " OR ";
    }
    $Page->PageFirstGroupFilter .= $sWhere;
    if ($Page->Filter != "") {
        $sWhere = "({$Page->Filter}) AND ({$sWhere})";
    }
    $sSql = ewr_BuildReportSql(str_replace("<DistinctColumnFields>", $Page->DistinctColumnFields, $Page->getSqlSelect()), $Page->getSqlWhere(), $Page->getSqlGroupBy(), "", $Page->getSqlOrderBy(), $sWhere, $Page->Sort);
    $rs = $conn->Execute($sSql);
    $rsdtlcnt = $rs ? $rs->RecordCount() : 0;
    if ($rsdtlcnt > 0) {
        $Page->GetRow(1);
    }
    while ($rs && !$rs->EOF) {
        $Page->RecCount++;

コード例 #3

ファイル: JobPosition_JobOfferedctb.php プロジェクト: vbalalla/project_CV_and_Recruitment_Management

><?php 
        echo $ReportLanguage->Phrase("Total");
        ?>
</div></td>
	</tr>
</thead>
<tbody>
<?php 
        if ($Page->TotalGrps == 0) {
            break;
        }
        // Show header only
        $Page->ShowHeader = FALSE;
    }
    // Build detail SQL
    $sWhere = ewr_DetailFilterSQL($Page->Job_Name, $Page->getSqlFirstGroupField(), $Page->Job_Name->GroupValue());
    if ($Page->PageFirstGroupFilter != "") {
        $Page->PageFirstGroupFilter .= " OR ";
    }
    $Page->PageFirstGroupFilter .= $sWhere;
    if ($Page->Filter != "") {
        $sWhere = "({$Page->Filter}) AND ({$sWhere})";
    }
    $sSql = ewr_BuildReportSql(str_replace("<DistinctColumnFields>", $Page->DistinctColumnFields, $Page->getSqlSelect()), $Page->getSqlWhere(), $Page->getSqlGroupBy(), "", $Page->getSqlOrderBy(), $sWhere, $Page->Sort);
    $rs = $conn->Execute($sSql);
    $rsdtlcnt = $rs ? $rs->RecordCount() : 0;
    if ($rsdtlcnt > 0) {
        $Page->GetRow(1);
    }
    while ($rs && !$rs->EOF) {
        $Page->RecCount++;