当前位置: 首页>>代码示例>>PHP>>正文


PHP DbHelper::countRows方法代码示例

本文整理汇总了PHP中DbHelper::countRows方法的典型用法代码示例。如果您正苦于以下问题:PHP DbHelper::countRows方法的具体用法?PHP DbHelper::countRows怎么用?PHP DbHelper::countRows使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在DbHelper的用法示例。


在下文中一共展示了DbHelper::countRows方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: defined

defined('DIRECT_ACCESS_CHECK') or die('DIRECT ACCESS NOT ALLOWED');
/**
 * Copyright (c) 2013 EIRL DEVAUX J. - Medialoha.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the GNU Public License v3.0
 * which accompanies this distribution, and is available at
 * http://www.gnu.org/licenses/gpl.html
 *
 * Contributors:
 *     EIRL DEVAUX J. - Medialoha - initial API and implementation
 */
// count total number of issues
$total = DbHelper::countRows(TBL_ISSUES, null);
$nbResolved = DbHelper::countRows(TBL_ISSUES, ISSUE_STATE . '=' . IssueState::STATE_CLOSED);
$nbTesting = DbHelper::countRows(TBL_ISSUES, ISSUE_STATE . '=' . IssueState::STATE_TESTING);
$nbArchived = DbHelper::countRows(TBL_ISSUES, ISSUE_STATE . '=' . IssueState::STATE_ARCHIVED);
// count reports not fixed
$res = DBHelper::selectRows(TBL_ISSUES, ISSUE_STATE . ' NOT IN (' . ISSUE_STATE_ARCHIVED . ', ' . ISSUE_STATE_CLOSED . ', ' . ISSUE_STATE_TESTING . ')', null, ISSUE_PRIORITY . ', COUNT(' . ISSUE_ID . ') count', ISSUE_PRIORITY, null, true);
$nbNotFixed = 0;
$nbNotFixedCritical = 0;
$nbNotFixedNormal = 0;
$nbNotFixedLow = 0;
if (is_array($res)) {
    foreach ($res as $row) {
        $nbNotFixed += $row->count;
        switch ($row->issue_priority) {
            case IssuePriority::CRITICAL:
                $nbNotFixedCritical = $row->count;
                break;
            case IssuePriority::NORMAL:
                $nbNotFixedNormal = $row->count;
开发者ID:xi67,项目名称:MAB-LAB,代码行数:31,代码来源:home_issues_states_box.inc.php

示例2: foreach

)" ><i class="icon-folder-open" ></i>&nbsp;Archive selected</a></li>
   				<li class="text-left" ><a href="javascript:updateIssuesState(<?php 
echo REPORT_STATE_VIEWED;
?>
)" ><i class="icon-refresh" ></i>&nbsp;Re-open selected</a></li>
    			<li class="text-left" ><a href="javascript:delIssues()" ><i class="icon-trash" ></i>&nbsp;Delete selected</a></li>
		  	</ul>
			</div>
		</th>
	</tr>
</thead>
<tbody>
<?php 
$reporsJoin = " JOIN " . TBL_REPORTS . " ON " . TBL_ISSUES . "." . ISSUE_ID . " = " . TBL_REPORTS . "." . REPORT_ISSUE;
//$totalRows = DbHelper::countRows(TBL_ISSUES.$reporsJoin, ($mSelectedAppId>0?ISSUE_APP_ID.'='.$mSelectedAppId.' AND ':'').IssueHelper::buildIssuesWhereClause($filterOpts));
$totalRows = DbHelper::countRows(TBL_ISSUES, ($mSelectedAppId > 0 ? ISSUE_APP_ID . '=' . $mSelectedAppId . ' AND ' : '') . IssueHelper::buildIssuesWhereClause($filterOpts));
$issues = IssueHelper::fetchIssuesTable($filterOpts);
if (empty($issues)) {
    ?>
<tr><td colspan="8" class="muted" >No issues recorded yet...</td></tr><?php 
} else {
    $pos = 0;
    //$alreadyPrintedIssued = [];
    foreach ($issues as $issueArr) {
        $issue = Issue::createFromArray($issueArr);
        $reports = $issue->getReports();
        $priority = $issue->getPriority();
        $state = $issue->getState();
        $trClasses = ($pos++ % 2 == 0 ? 'even ' : 'odd ') . strtolower($state->getName());
        ?>
		<?php 
开发者ID:andi3000,项目名称:MAB-LAB,代码行数:31,代码来源:issues_table.inc.php

示例3: IN

         require_once 'pages/change_issue_dialog.php';
     } else {
         echo 'You missed report ids !';
     }
     break;
     //////// SET ISSUE FOR REPORTS
 //////// SET ISSUE FOR REPORTS
 case 'setReportsIssue':
     $reportIds = @$_POST['reportIds'];
     $currentIssueId = @$_POST['currentIssueId'];
     $newIssueId = @$_POST['newIssueId'];
     if (!empty($reportIds) && !empty($currentIssueId) && !empty($newIssueId)) {
         // update reports
         DbHelper::exec('UPDATE ' . TBL_REPORTS . ' SET ' . REPORT_ISSUE . '=' . $newIssueId . ' WHERE ' . REPORT_ID . ' IN (' . $reportIds . ')');
         // delete issue if no more reports attached
         $count = DbHelper::countRows(TBL_REPORTS, REPORT_ISSUE . '=' . $currentIssueId);
         if ($count == 0) {
             DbHelper::deleteIssues($currentIssueId);
         }
     } else {
         $error = "Invalid parameters !";
     }
     if ($error == null) {
         Helper::pushAlert(ALERT_SUCCESS, 'Reports switched with success !');
     } else {
         Helper::pushAlert(ALERT_ERROR, $error);
     }
     header('Location:index.php?p=' . PAGE_ID_ISSUES);
     break;
     //////// GET ISSUES TABLE
 //////// GET ISSUES TABLE
开发者ID:xi67,项目名称:MAB-LAB,代码行数:31,代码来源:issuescontroller.php


注:本文中的DbHelper::countRows方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。