PHP WidgetUtilの例

コード例 #1

ファイル: payroll_by_agency_gross_ot_pay.tpl.php プロジェクト: ecs-hk/Checkbook

<table id="table_<?php 
echo widget_unique_identifier($node);
?>
" class="<?php 
echo $node->widgetConfig->gridConfig->html_class;
?>
">
  <thead>
    <tr>
        <th class='text'><?php 
echo WidgetUtil::generateLabelMapping("agency_name");
?>
</th>
        <th class='number'><?php 
echo WidgetUtil::generateLabelMapping("amount");
?>
</th>
        <th>&nbsp</th>
    </tr>
  </thead>
  <tbody>
  <?php 
if (isset($node->data) && is_array($node->data)) {
    foreach ($node->data as $datarow) {
        echo "<tr>";
        echo "<td><div>" . $datarow['agency_agency_agency_name'] . "</div></td>";
        echo "<td>" . ($isByGrossPay ? $datarow['total_gross_pay'] : $datarow['total_overtime_pay']) . "</td>";
        echo "<td>&nbsp</td>";
        echo "</tr>";
    }

コード例 #2

ファイル: contract_summary.tpl.php プロジェクト: ecs-hk/Checkbook

* 
* You should have received a copy of the GNU Affero General Public License
* along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
$records = $node->data;
if (is_array($records)) {
    $row = $records[0];
    $title = eval($node->widgetConfig->summaryView->templateTitleEval);
    $label = $node->widgetConfig->summaryView->templateLabel;
    $value = eval($node->widgetConfig->summaryView->templateLabelEval);
    $ytdspending = WidgetUtil::getLabel("ytd_spending");
    $oamnt = WidgetUtil::getLabel("original_amount");
    $camnt = WidgetUtil::getLabel("current_amount");
    $puprose = WidgetUtil::getLabel("contract_purpose");
    $vendor = WidgetUtil::getLabel("prime_vendor");
    $agency = WidgetUtil::getLabel("contract_agency");
    $purpose_value = strtoupper($row['contract_purpose_contract_purpose']);
    $agency_value = strtoupper($row['agency_agency_agency_name']);
    $summaryContent = <<<EOD
<div class="contract-details-heading">
\t<div class="contract-id">
\t\t<h2 class="contract-title">{$title}</h2>
\t</div>
\t<div class="dollar-amounts">
        <div class="total-spending-contract-amount">
            {$row['formatted_total_contract_amount_sum']}
            <div class="amount-title">Total Contract<div align="center">{$amount}Amount</div></div>
        </div>
        <div class="ytd-spending-amount">
            {$row['formatted_check_amount_sum']}
            <div class="amount-title">{$ytdspending}</div>

コード例 #3

ファイル: nyc_payroll_summary_by_month.tpl.php プロジェクト: ecs-hk/Checkbook

    $total_other_payments = custom_number_formatter_format($results['total_other_payments'], 2, '$');
    $total_overtime_pay = custom_number_formatter_format($results['total_overtime_pay'], 2, '$');
    $total_salaried_employees = number_format($results['total_salaried_employees@checkbook:payroll_year_month']);
    $total_hourly_employees = number_format($results['total_hourly_employees@checkbook:payroll_year_month']);
    $total_employees = number_format($results['total_employees@checkbook:payroll_year_month']);
    $year = $results['year_year'];
    $month = $results['month_month'];
    $yearType = $results['year_type_year_type'];
    $year_value = _getYearValueFromID($year);
    $month_num = _getMonthValueFromId($month);
    if (isset($month_num)) {
        $dateObj = DateTime::createFromFormat('!m', $month_num);
        $month_value = $dateObj->format('F');
    }
    $yeartype = 'FY';
    if (_getRequestParamValue('yeartype') == 'C') {
        $yeartype = 'CY';
    }
    if (_getRequestParamValue('smnid') == 491) {
        $total_overtime_employees_label = WidgetUtil::getLabel('total_no_of_ot_employees') . ':';
        $overtime_employees_value = number_format($results['total_overtime_employees']);
    }
    $table = "\r\n<div id='payroll-tx-static-content'>\r\n<div class='payroll-year-month'><span class='label'>" . WidgetUtil::getLabel('month') . ": </span><span class='data'> {$month_value} </span> &nbsp;&nbsp;|&nbsp;&nbsp;<span class='label'>" . WidgetUtil::getLabel('year') . ":</span><span class='data'> {$yeartype} {$year_value}</span></div>\r\n    <table id='payroll-tx-static-content-table'>\r\n        <tr>\r\n            <td width='50%'><strong>" . WidgetUtil::getLabel('annual_salary') . "</strong>: {$total_annual_salary}</td>\r\n            <td width='50%'><strong>" . WidgetUtil::getLabel('total_no_of_employees') . "</strong>: {$total_employees}</td>\r\n        </tr>\r\n        <tr>\r\n            <td><strong>" . WidgetUtil::getLabel('gross_pay') . "</strong>: {$total_gross_pay}</td>\r\n            <td><strong>" . WidgetUtil::getLabel('total_no_of_sal_employees') . "</strong>: {$total_salaried_employees}</td>\r\n        </tr>\r\n        <tr>\r\n            <td><strong>" . WidgetUtil::getLabel('base_pay') . "</strong>:{$total_base_pay}</td>\r\n            <td><strong>" . WidgetUtil::getLabel('total_no_of_non_sal_employees') . "</strong>: {$total_hourly_employees}</td>\r\n        </tr>\r\n        <tr>\r\n            <td><strong>" . WidgetUtil::getLabel('other_pay') . "</strong>: {$total_other_payments}</td>\r\n            <td><strong>" . WidgetUtil::getLabel('overtime_pay') . "</strong>: {$total_overtime_pay}</td>\r\n        </tr>";
    if (isset($overtime_employees_value)) {
        $table .= "<tr>";
        $table .= "<td><strong>{$total_overtime_employees_label} </strong> {$overtime_employees_value}</td>";
        $table .= "</tr>";
    }
    $table .= "</table></div>";
    print $table;
}

コード例 #4

ファイル: budget_highchart.tpl.php プロジェクト: ecs-hk/Checkbook

include_once 'budget_title.php';
include_once 'page_title.php';
include_once 'export_link.php';
?>


<table id="table_<?php 
echo widget_unique_identifier($node);
?>
" class="<?php 
echo $node->widgetConfig->gridConfig->html_class;
?>
">
    <thead>
    <?php 
echo "<tr><th class='number'>" . WidgetUtil::generateLabelMapping("fiscal_year") . "</th>\r\n        <th class='number'>" . WidgetUtil::generateLabelMapping("committed") . " </th>\r\n        <th class='number'>" . WidgetUtil::generateLabelMapping("remaining") . "</th>\r\n        <th>&nbsp</th>\r\n        </tr>\n";
?>
    </thead>

    <tbody>
    <?php 
if (isset($node->data) && is_array($node->data)) {
    foreach ($node->data as $datarow) {
        echo "<tr>";
        echo '<td>' . $datarow['year_year'] . '</td>';
        echo '<td>' . $datarow['budget_committed'] . '</td>';
        echo '<td>' . $datarow['budget_remaining'] . '</td>';
        echo "<td>&nbsp</td>";
        echo "</tr>";
    }
}

コード例 #5

ファイル: spending_highchart_contract_disbursement.tpl.php プロジェクト: ecs-hk/Checkbook

        <tr><th class='text'><?php 
echo WidgetUtil::generateLabelMapping("contract_id");
?>
</th>
            <th class='number-left'><?php 
echo WidgetUtil::generateLabelMapping("spending_amount");
?>
</th>
            <th>&nbsp;&nbsp;</th>
            <th class='text'><?php 
echo WidgetUtil::generateLabelMapping("prime_vendor");
?>
</th>
            <th class='text'><?php 
echo WidgetUtil::generateLabelMapping("contract_agency");
?>
</th>
            <th>&nbsp</th>
        </tr>

        </thead>

        <tbody>
        <?php 
if (isset($node->data) && is_array($node->data)) {
    foreach ($node->data as $datarow) {
        $vendor_name = $datarow['vendor_vendor_legal_name'];
        echo '<tr>
                <td><div>' . $datarow['document_id_document_id'] . '</div></td>
                <td>' . $datarow['check_amount_sum'] . '</td>

コード例 #6

ファイル: nyc_payroll_summary.tpl.php プロジェクト: ecs-hk/Checkbook

* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
* GNU Affero General Public License for more details.
* 
* You should have received a copy of the GNU Affero General Public License
* along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
$results = $node->data[0];
if ($results) {
    $total_annual_salary = custom_number_formatter_format($results['total_annual_salary'], 2, '$');
    $total_gross_pay = custom_number_formatter_format($results['total_gross_pay'], 2, '$');
    $total_base_pay = custom_number_formatter_format($results['total_base_pay'], 2, '$');
    $total_other_payments = custom_number_formatter_format($results['total_other_payments'], 2, '$');
    $total_overtime_pay = custom_number_formatter_format($results['total_overtime_pay'], 2, '$');
    $total_salaried_employees = number_format($results['total_salaried_employees@checkbook:payroll_year']);
    $total_hourly_employees = number_format($results['total_hourly_employees@checkbook:payroll_year']);
    $total_employees = number_format($results['total_employees@checkbook:payroll_year']);
    $year = $results['year_year'];
    $yearType = $results['year_type_year_type'];
    if (_getRequestParamValue('smnid') == 322) {
        $total_overtime_employees = number_format($results['total_overtime_employees']);
        $total_overtime_employees_label = WidgetUtil::getLabel('total_no_of_ot_employees') . ':';
    }
    $table = "\r\n<div id='payroll-tx-static-content'>\r\n    <table id='payroll-tx-static-content-table'>\r\n        <tr>\r\n            <td width='50%'><strong>" . WidgetUtil::getLabel('annual_salary') . "</strong>: {$total_annual_salary}</td>\r\n            <td width='50%'><strong>" . WidgetUtil::getLabel('total_no_of_employees') . "</strong>: {$total_employees}</td>\r\n        </tr>\r\n        <tr>\r\n            <td><strong>" . WidgetUtil::getLabel('gross_pay_ytd') . "</strong>: {$total_gross_pay}</td>\r\n            <td><strong>" . WidgetUtil::getLabel('total_no_of_sal_employees') . "</strong>: {$total_salaried_employees}</td>\r\n        </tr>\r\n        <tr>\r\n            <td><strong>" . WidgetUtil::getLabel('base_pay_ytd') . "</strong>: {$total_base_pay}</td>\r\n            <td><strong>" . WidgetUtil::getLabel('total_no_of_non_sal_employees') . "</strong>: {$total_hourly_employees}</td>\r\n        </tr>\r\n        <tr>\r\n            <td><strong>" . WidgetUtil::getLabel('other_pay_1_ytd') . "</strong>: {$total_other_payments}</td>\r\n            <td><strong>" . WidgetUtil::getLabel('overtime_pay_1_ytd') . "</strong>: {$total_overtime_pay}</td>\r\n        </tr>";
    if (isset($total_overtime_employees)) {
        $table .= "<tr>";
        $table .= "<td><strong>{$total_overtime_employees_label} </strong> {$total_overtime_employees}</td>";
        $table .= "</tr>";
    }
    $table .= "</table></div>";
    print $table;
}

コード例 #7

ファイル: contracts_cta_history.tpl.php プロジェクト: ecs-hk/Checkbook

 $curr_amount_sum = 0;
 foreach ($items as $item) {
     $curr_amount_sum = $item['maximum_contract_amount'];
     $orig_amount_sum = $item['original_contract_amount'];
     break;
 }
 echo "<td class='number'><div>" . custom_number_formatter_format($curr_amount_sum, 2, '$') . "</div></td>";
 echo "<td class='number endCol'><div>" . custom_number_formatter_format($orig_amount_sum, 2, '$') . "</div></td>";
 echo "</tr>";
 $count1 += 1;
 echo "<tr id='showHidectahis" . $key . "' class='showHide " . $class1 . "' " . $showCondition . ">";
 $showCondition = "style='display:none'";
 echo "<td colspan='4' >";
 echo "<div class='scroll'>";
 echo "<table class='sub-table col9'>";
 echo "<thead>\n                  <tr>\n                    <th class='number thVNum'>" . WidgetUtil::generateLabelMapping("version_number") . "</th>\n                    <th class='text thStartDate'>" . WidgetUtil::generateLabelMapping("start_date") . "</th>\n                    <th class='text thEndDate'>" . WidgetUtil::generateLabelMapping("end_date") . "</th>\n                    <th class='text thRegDate'>" . WidgetUtil::generateLabelMapping("reg_date") . "</th>\n                    <th class='text thLastMDate'>" . WidgetUtil::generateLabelMapping("last_mod_date") . "</th>\n                    <th class='number thCurAmt'>" . WidgetUtil::generateLabelMapping("current_amount") . "</th>\n                    <th class='number thOrigAmt'>" . WidgetUtil::generateLabelMapping("original_amount") . "</th>\n                    <th class='number thIncDec'>" . WidgetUtil::generateLabelMapping("increase_decrease") . "</th>\n                    <th class='text thVerStat status'>" . WidgetUtil::generateLabelMapping("version_status") . "</th>\n                  </tr></thead><tbody>";
 $count = 0;
 foreach ($items as $item) {
     if ($count % 2 == 0) {
         $class = "class=\"odd\"";
     } else {
         $class = "class=\"even\"";
     }
     echo "<tr " . $class . ">";
     echo "<td class='number thVNum' ><div>" . $item['document_version'] . "</div></td>";
     echo "<td class='text thStartDate'><div>" . $item['start_date'] . "</div></td>";
     echo "<td class='text thEndDate'><div>" . $item['end_date'] . "</div></td>";
     echo "<td class='text thRegDate'><div>" . $reg_date . "</div></td>";
     if (isset($item['cif_received_date'])) {
         echo "<td class='text thLastMDate'><div>" . $item['cif_received_date'] . "</div></td>";
     } elseif (trim($item['document_version']) == "1") {

コード例 #8

ファイル: contract_modification.tpl.php プロジェクト: ecs-hk/Checkbook

    $pdiff = WidgetUtil::getLabel("percent_diff");
    $purpose = WidgetUtil::getLabel("contract_purpose");
    $agency = WidgetUtil::getLabel("contract_agency");
    $vendor = WidgetUtil::getLabel("vendor_name");
    $vendor_value = $row['vendor_vendor_legal_name'];
    $smnid = _getRequestParamValue('smnid');
    if ($smnid == 722) {
        $purpose = WidgetUtil::getLabel("sub_contract_purpose");
        $vendor = WidgetUtil::getLabel("sub_vendor_name");
        $vendor_value = strtoupper($row['subvendor_subvendor_legal_name']);
    } else {
        if ($smnid == 782) {
            $vendor = WidgetUtil::getLabel("associated_prime_vendor");
        } else {
            if ($smnid == 366 || $smnid == 480) {
                $vendor = WidgetUtil::getLabel("prime_vendor");
            }
        }
    }
    $purpose_value = strtoupper($row['contract_purpose_contract_purpose']);
    $agency_value = strtoupper($row['agency_agency_agency_name']);
    $summaryContent = <<<EOD
<div class="contract-details-heading">
\t<div class="contract-id">
\t\t<h2 class="contract-title">{$node->widgetConfig->summaryView->templateTitle}</h2>
\t</div>
\t<div class="dollar-amounts">
\t\t<div class="spent-to-date">
\t\t\t{$spentToDateAmount}
            <div class="amount-title">{$spnttodt}</div>
\t\t</div>

コード例 #9

ファイル: contracts_cta_spending_history.tpl.php プロジェクト: ecs-hk/Checkbook

 echo "<td class='text'><div><a class=\"showHide {$showClass}\"></a> FY " . $key . "</div></td>";
 echo "<td class='text'><div>" . count($items) . " Transactions</div></td>";
 $showClass = 'open';
 $check_amount_sum = 0;
 foreach ($items as $item) {
     $check_amount_sum += $item['check_amount'];
 }
 echo "<td class='number endCol'><div>" . custom_number_formatter_format($check_amount_sum, 2, '$') . "</div></td>";
 echo "</tr>";
 $count1 += 1;
 echo "<tr id='showHidectaspe" . $key . "' class='showHide " . $class1 . "' " . $showCondition . ">";
 $showCondition = "style='display:none'";
 echo "<td colspan='3' >";
 echo "<div class='scroll'>";
 echo "<table class='sub-table col6'>";
 echo "<thead><tr><th class='text th1'><div><span>Date</span></div></th>\n                           <th class='text th2'>" . WidgetUtil::generateLabelMapping("document_id") . "</th>\n                           <th class='number th3'>" . WidgetUtil::generateLabelMapping("check_amount") . "</th>\n                           <th class='text th4'>" . WidgetUtil::generateLabelMapping("expense_category") . "</th>\n                           <th class='text th5'>" . WidgetUtil::generateLabelMapping("agency_name") . "</th>\n                           <th class='text th6'>" . WidgetUtil::generateLabelMapping("dept_name") . "</th></tr></thead><tbody>";
 $count = 0;
 foreach ($items as $item) {
     if ($count % 2 == 0) {
         $class = "class=\"odd\"";
     } else {
         $class = "class=\"even\"";
     }
     echo "<tr " . $class . ">";
     echo "<td class='text td1'><div>" . $item['date@checkbook:date_id/check_eft_issued_date_id@checkbook:disbursement_line_item_details'] . "</div></td>";
     echo "<td class='text td2'><div>" . $item['document_id'] . "</div></td>";
     echo "<td class='number td3'><div>" . custom_number_formatter_format($item['check_amount'], 2, '$') . "</div></td>";
     echo "<td class='text td4'><div>" . $item['expenditure_object_name'] . "</div></td>";
     echo "<td class='text td5'><div>" . $item['agency_name'] . "</div></td>";
     echo "<td class='text td6'><div>" . $item['department_name'] . "</div></td>";
     echo "</tr>";

コード例 #10

ファイル: contract_transactions_summary.tpl.php プロジェクト: ecs-hk/Checkbook

<?php

/**
* This file is part of the Checkbook NYC financial transparency software.
* 
* Copyright (C) 2012, 2013 New York City
* 
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
* 
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
* GNU Affero General Public License for more details.
* 
* You should have received a copy of the GNU Affero General Public License
* along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
$output = '';
foreach ($node->data as $key => $value) {
    $output .= '<div class="field-label">' . WidgetUtil::getLabel('contract_id') . ': </div><div class="field-items">' . $value['contract_id'] . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('contract_status') . ': </div><div class="field-items">' . $value['status'] . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('vendor_name') . ': </div><div class="field-items">' . $value['vendor_name'] . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('current_amount') . ': </div><div class="field-items">' . custom_number_formatter_format($value['current_amount'], 2, '$') . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('original_amount') . ': </div><div class="field-items">' . custom_number_formatter_format($value['original_amount'], 2, '$') . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('contract_purpose') . ': </div><div class="field-items">' . $value['description'] . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('start_date') . ': </div><div class="field-items">' . $value['start_date'] . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('end_date') . ': </div><div class="field-items">' . $value['end_date'] . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('contract_type') . ': </div><div class="field-items">' . $value['agreement_type_name'] . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('spent_to_date') . ': </div><div class="field-items">' . $value['spent_to_date'] . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('recv_date') . ': </div><div class="field-items">' . $value['receive_date'] . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('agency_name') . ': </div><div class="field-items">' . $value['agency_name'] . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('voucher_amount') . ': </div><div class="field-items">' . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('reg_date') . ': </div><div class="field-items">' . $value['registered_date'] . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('award_method') . ': </div><div class="field-items">' . $value['award_method_name'] . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('encumbered_amount') . ': </div><div class="field-items">' . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('version_number') . ': </div><div class="field-items">' . $value['document_version'] . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('apt_pin') . ': </div><div class="field-items">' . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('pin') . ': </div><div class="field-items">' . $value['pin'] . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('loc_site') . ': </div><div class="field-items">' . $value['worksites_name'] . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('sol_per_cont') . ': </div><div class="field-items">' . $value['number_solicitation'] . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('fms_doc') . ': </div><div class="field-items">' . $value['document_code'] . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('resp_per_sol') . ': </div><div class="field-items">' . $value['number_responses'] . '</div>' . '<div class="field-label">' . WidgetUtil::getLabel('fms_doc_id') . ': </div><div class="field-items">' . $value['parent_contract_id'] . '</div>';
}
print $output;

コード例 #11

ファイル: sub_vendor_summary.tpl.php プロジェクト: ecs-hk/Checkbook

    if (_getRequestParamValue('smnid') == 719) {
        $percent_spending_value = '';
        $percent_spending = '';
        $associated_prime_vendor_value = $row['prime_vendor_prime_vendor_legal_name'];
        $associated_prime_vendor = WidgetUtil::getLabel("associated_prime_vendor");
        $associated_prime_vendor = '<br><b>' . $associated_prime_vendor . ':</b> ' . $associated_prime_vendor_value;
        $no_of_subcontracts_value = $row['total_sub_contracts'];
        $no_of_subcontracts = WidgetUtil::getLabel("num_sub_contracts");
        $totcontamnt_value = '';
        $totcontamnt = '';
    }
    if (_getRequestParamValue('smnid') == 763 || _getRequestParamValue('smnid') == 748) {
        $percent_spending_value = $row['percent_spending'];
        $percent_spending = WidgetUtil::getLabel("percent_spending");
        $no_of_subcontracts_value = $row['total_sub_contracts'];
        $no_of_subcontracts = WidgetUtil::getLabel("num_sub_contracts");
    }
    $summaryContent = <<<EOD
<div class="contract-details-heading">
\t<div class="contract-id">
\t\t<h2 class="contract-title">{$title}</h2>
\t\t<div class="spending-tx-subtitle"><b>{$label}</b>: {$value}<br><b>{$mwbe_category_label}</b>: {$mwbe_category} {$associated_prime_vendor}</div>
\t</div>
\t<div class="dollar-amounts">
\t    <div class="total-spending-contract-amount">
            {$totcontamnt_value}
            <div class="amount-title">{$totcontamnt}</div>
        </div>
        <div class="ytd-spending-amount">
            {$row['formatted_check_amount_sum']}
            <div class="amount-title">{$ytdspending}</div>

コード例 #12

ファイル: contract_transactions_spending_fy.tpl.php プロジェクト: ecs-hk/Checkbook

* it under the terms of the GNU Affero General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
* 
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
* GNU Affero General Public License for more details.
* 
* You should have received a copy of the GNU Affero General Public License
* along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
$output = '';
$output .= '<table><tr><th>' . WidgetUtil::getLabel('fiscal_year') . '</th>
                       <th>' . WidgetUtil::getLabel('no_of_transactions') . '</th>
                       <th>' . WidgetUtil::getLabel('contract_status') . 'Amount spent to Date</th>
                   </tr>';
$transactions = array();
$count = 1;
foreach ($node->data as $key => $value) {
    $transactions[$value['fiscal_year']][$count]['fiscal_year'] = $value['fiscal_year'];
    $transactions[$value['fiscal_year']][$count]['date'] = $value['date'];
    $transactions[$value['fiscal_year']][$count]['expense_id'] = $value['expense_id'];
    $transactions[$value['fiscal_year']][$count]['check_amount'] = $value['check_amount'];
    $count++;
}
foreach ($transactions as $key => $value) {
    $show_data .= '<tbody id="hidden_data" style="display:none"><tr><th>Date</th><th>Expense ID</th><th>Amount</th></tr>';
    foreach ($value as $a => $b) {
        $amount_spent += $b['check_amount'];
        $show_data .= '<tr><td>' . $b['date'] . '</td>

コード例 #13

ファイル: agency_summary.tpl.php プロジェクト: ecs-hk/Checkbook

    $agency_name = WidgetUtil::getLabel("agency_name");
    $ytdspending = WidgetUtil::getLabel("ytd_spending");
    if (_getRequestParamValue('smnid') == 759 || _getRequestParamValue('smnid') == 746 || _getRequestParamValue('smnid') == 780) {
        $percent_spending_value = $row['percent_spending'];
        $percent_spending = WidgetUtil::getLabel("percent_spending");
    }
    if (_getRequestParamValue('smnid') == 716) {
        $percent_spending_value = '';
        $percent_spending = '';
        $ytdspending = WidgetUtil::getLabel("ytd_spending_sub_vendors");
        $percent_paid_value = $row['sub_vendors_percent_paid_formatted'];
        $percent_paid = WidgetUtil::getLabel("sub_vendors_percent_paid");
        $no_of_subvendors_value = $row['sub_vendor_count'];
        $no_of_subvendors = WidgetUtil::getLabel("num_sub_vendors");
        $ytd_spending_agency_value = $row['ytd_spending_agency_formatted'];
        $ytd_spending_agency = WidgetUtil::getLabel("ytd_spending_agency");
    }
    //sub_vendors_percent_paid_formatted
    $summaryContent = <<<EOD
<div class="contract-details-heading">
\t<div class="contract-id">
\t\t<h2 class="contract-title">{$title}</h2>
\t\t<div class="spending-tx-subtitle"><b>{$label}</b>: {$value}</div>
\t</div>
\t<div class="dollar-amounts">
        <div class="ytd-spending-amount">
            {$row['formatted_check_amount_sum']}
            <div class="amount-title">{$ytdspending}</div>
        </div>
        <div class="number-of-subvendors">
            {$no_of_subvendors_value}

コード例 #14

ファイル: revenue_highchart.tpl.php プロジェクト: ecs-hk/Checkbook

include_once 'page_title.php';
include_once 'export_link.php';
?>



<table id="table_<?php 
echo widget_unique_identifier($node);
?>
" class="<?php 
echo $node->widgetConfig->gridConfig->html_class;
?>
">
    <thead>
    <?php 
echo "<tr><th class='number'>" . WidgetUtil::generateLabelMapping("year") . "</th>\r\n        <th class='number'>" . WidgetUtil::generateLabelMapping("recognized") . " </th>\r\n        <th class='number'>" . WidgetUtil::generateLabelMapping("remaining") . "</th>\r\n        <th>&nbsp</th>        \r\n        </tr>\n";
?>
    </thead>

    <tbody>
    <?php 
foreach ($node->data as $datarow) {
    echo "<tr>";
    echo '<td>' . $datarow['year_year_year_value'] . '</td>';
    echo '<td>' . $datarow['revenue_amount_sum'] . '</td>';
    echo '<td>' . $datarow['remaining'] . '</td>';
    echo "<td>&nbsp</td>";
    echo "</tr>";
}
?>
    </tbody>

コード例 #15

ファイル: contracts_ma_history.tpl.php プロジェクト: ecs-hk/Checkbook

 echo "<tr id='showHidemashis" . $key . "' class='showHide " . $class1 . "' " . $showCondition . ">";
 $showCondition = "style='display:none'";
 echo "<td colspan='4' >";
 echo "<div class='scroll'>";
 echo "<table class='sub-table col9'>";
 //For IE9, tables cannot have line breaks between table elements
 echo "<thead><tr>";
 echo "<th class='number thVNum'>" . WidgetUtil::generateLabelMapping("version_number") . "</th>";
 echo "<th class='text thStartDate'>" . WidgetUtil::generateLabelMapping("start_date") . "</th>";
 echo "<th class='text thEndDate'>" . WidgetUtil::generateLabelMapping("end_date") . "</th>";
 echo "<th class='text thRegDate'>" . WidgetUtil::generateLabelMapping("reg_date") . "</th>";
 echo "<th class='text thLastMDate'>" . WidgetUtil::generateLabelMapping("last_mod_date") . "</th>";
 echo "<th class='number thCurAmt'>" . WidgetUtil::generateLabelMapping("current_amount") . "</th>";
 echo "<th class='number thOrigAmt'>" . WidgetUtil::generateLabelMapping("original_amount") . "</th>";
 echo "<th class='number thIncDec'>" . WidgetUtil::generateLabelMapping("increase_decrease") . "</th>";
 echo "<th class='text thVerStat'>" . WidgetUtil::generateLabelMapping("version_status") . "</th>";
 echo "</tr></thead><tbody>";
 $count = 0;
 foreach ($items as $item) {
     if ($count % 2 == 0) {
         $class = "class=\"inner odd\"";
     } else {
         $class = "class=\"inner even\"";
     }
     echo "<tr " . $class . ">";
     echo "<td class='number thVNum'><div>" . $item['document_version'] . "</div></td>";
     echo "<td class='text thStartDate'><div>" . $item['start_date'] . "</div></td>";
     echo "<td class='text thEndDate'><div>" . $item['end_date'] . "</div></td>";
     echo "<td class='text thRegDate'><div>" . $reg_date . "</div></td>";
     if (isset($item['cif_received_date'])) {
         echo "<td class='text thLastMDate'><div>" . $item['cif_received_date'] . "</div></td>";

コード例 #16

ファイル: exp_category_summary.tpl.php プロジェクト: ecs-hk/Checkbook

* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
* GNU Affero General Public License for more details.
* 
* You should have received a copy of the GNU Affero General Public License
* along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
$records = $node->data;
if (is_array($records)) {
    $row = $records[0];
    $title = eval($node->widgetConfig->summaryView->templateTitleEval);
    $label = $node->widgetConfig->summaryView->templateLabel;
    $value = eval($node->widgetConfig->summaryView->templateLabelEval);
    $ytdspending = WidgetUtil::getLabel("ytd_spending");
    $expcat = WidgetUtil::getLabel("expense_category");
    $percent_spending = WidgetUtil::getLabel("percent_spending");
    $percent_spending_value = $row['percent_spending'];
    if (_getRequestParamValue('smnid') == 22) {
        $percent_spending = '';
        $percent_spending_value = '';
    }
    $summaryContent = <<<EOD
<div class="contract-details-heading">
\t<div class="contract-id">
\t\t<h2 class="contract-title">{$title}</h2>
\t\t<div class="spending-tx-subtitle"><b>{$label}</b>: {$value}</div>
\t</div>
\t<div class="dollar-amounts">
        <div class="ytd-spending-amount">
            {$row['formatted_check_amount_sum']}
            <div class="amount-title">{$ytdspending}</div>

コード例 #17

ファイル: WidgetUtil.php プロジェクト: ecs-hk/Checkbook

 static function generateTable($table_definition, $is_main = true)
 {
     $html = '';
     $border = "";
     //        $border = 'border: 1px solid black !important; ';
     $header_title = isset($table_definition["header"]["title"]) ? $table_definition["header"]["title"] : null;
     $header_columns = isset($table_definition["header"]["columns"]) ? $table_definition["header"]["columns"] : null;
     $table_body = isset($table_definition["body"]) ? $table_definition["body"] : null;
     $table_rows = isset($table_definition["body"]["rows"]) ? $table_definition["body"]["rows"] : null;
     //Title
     if ($header_title) {
         $html .= $header_title;
     }
     if ($is_main) {
         $html .= "<table class='dataTable outerTable' style='border: 1px solid #CACACA;'>";
     } else {
         $html .= "<table class='sub-table dataTable'>";
     }
     //Header row
     if ($header_columns) {
         $html .= "<thead>";
         $html .= "<tr>";
         //            $html .= "<tr style='border: 1px solid black !important;'>";
         $html .= WidgetUtil::generateHeaderColumns($header_columns);
         $html .= "</tr>";
         $html .= "</thead>";
     }
     //Table body
     if (isset($table_body)) {
         $html .= "<tbody>";
         //Table rows
         if (isset($table_rows)) {
             $alternating_row_count = 0;
             $inner_tbl_count = 0;
             $outer_table_count = 0;
             for ($row_index = 0; $row_index < count($table_rows); $row_index++) {
                 if (isset($table_rows[$row_index]['columns'])) {
                     if ($alternating_row_count % 2 == 0) {
                         $class = "even outer";
                     } else {
                         $class = "odd outer";
                     }
                     $alternating_row_count++;
                     WidgetUtil::populateMaxColumnLength($table_rows);
                     //                        $html .= "<tr class='".$class."' style='border: 1px solid black !important;'>";
                     $html .= "<tr class='" . $class . "' >";
                     $html .= WidgetUtil::generateColumns($table_rows[$row_index]['columns']);
                     $html .= "</tr>";
                 } elseif (isset($table_rows[$row_index]['child_tables'])) {
                     $display_main = $outer_table_count > 0 ? "display: none;" : "";
                     $outer_table_count++;
                     $col_span = count($table_rows[$row_index - 1]['columns']);
                     $html .= "<tr class='showHide' style='" . $display_main . "'>";
                     $html .= "<td colspan='" . $col_span . "'>";
                     $html .= "<div>";
                     for ($tbl_index = 0; $tbl_index < count($table_rows[$row_index]['child_tables']); $tbl_index++) {
                         //                            $html .= "<tr class='showHide' style='border: 1px solid black !important;'>";
                         $html .= WidgetUtil::generateTable($table_rows[$row_index]['child_tables'][$tbl_index]);
                     }
                     $html .= "</div>";
                     $html .= "</td>";
                     $html .= "</tr>";
                 } elseif (isset($table_rows[$row_index]['embed_node'])) {
                     $display_main = $outer_table_count > 0 ? "display: none;" : "";
                     $outer_table_count++;
                     $col_span = count($table_rows[$row_index - 1]['columns']);
                     $html .= "<tr class='showHide' style='" . $display_main . "'>";
                     $html .= "<td colspan='" . $col_span . "'>";
                     $html .= "<div>";
                     for ($tbl_index = 0; $tbl_index < count($table_rows[$row_index]['embed_node']); $tbl_index++) {
                         //                            $html .= "<tr class='showHide' style='border: 1px solid black !important;'>";
                         $html .= $table_rows[$row_index]['embed_node'][$tbl_index];
                     }
                     $html .= "</div>";
                     $html .= "</td>";
                     $html .= "</tr>";
                 } elseif (isset($table_rows[$row_index]['inner_table'])) {
                     $display = $inner_tbl_count > 0 ? "display: none;" : "";
                     $inner_tbl_count++;
                     $col_span = count($table_rows[$row_index - 1]['columns']);
                     //                        $html .= "<tr class='showHide' style='".$display." border: 1px solid black !important;'>";
                     $html .= "<tr class='showHide' style='" . $display . "'>";
                     $html .= "<td colspan='" . $col_span . "'>";
                     $html .= "<div class='scroll'>";
                     $html .= WidgetUtil::generateTable($table_rows[$row_index]['inner_table'], false);
                     $html .= "</div>";
                     $html .= "</td>";
                     $html .= "</tr>";
                 }
             }
         }
         $html .= "</tbody>";
     } else {
         $html .= "<tbody>";
         $html .= "<tr class='odd'>";
         $html .= "<td class='dataTables_empty' valign='top' colspan='" . count($header_columns) . "'>";
         $html .= "<div id='no-records-datatable' class='clearfix'>";
         $html .= "<span>No Matching Records Found</span>";
         $html .= "</div>";
         $html .= "</td>";
         $html .= "</tr>";
         $html .= "</tbody>";
     }
     $html .= "</table>";
     return $html;
 }

コード例 #18

ファイル: sub_contract.tpl.php プロジェクト: ecs-hk/Checkbook

if (is_array($records)) {
    $row = $records[0];
    $originalAmount = custom_number_formatter_format($row['original_amount_sum'], 2, '$');
    $currentAmount = custom_number_formatter_format($row['current_amount_sum'], 2, '$');
    $spentToDateAmount = custom_number_formatter_format($row['spending_amount_sum'], 2, '$');
    $cont_id = WidgetUtil::getLabel("contract_id");
    $spnttodt = WidgetUtil::getLabel("spent_to_date");
    $oamnt = WidgetUtil::getLabel("original_amount");
    $camnt = WidgetUtil::getLabel("current_amount");
    $purpose = WidgetUtil::getLabel("contract_purpose");
    $agency = WidgetUtil::getLabel("contract_agency");
    $vendor = WidgetUtil::getLabel("sub_vendor_name");
    if (_getRequestParamValue('smnid') == 721) {
        $purpose = WidgetUtil::getLabel("sub_contract_purpose");
        $associated_prime_vendor_value = strtoupper($row['vendor_vendor_legal_name']);
        $associated_prime_vendor = WidgetUtil::getLabel("associated_prime_vendor");
    }
    $agency_value = strtoupper($row['agency_agency_agency_name']);
    $purpose_value = strtoupper($row['contract_purpose_contract_purpose']);
    $vendor_value = strtoupper($row['subvendor_subvendor_legal_name']);
    $summaryContent = <<<EOD
<div class="contract-details-heading">
\t<div class="contract-id">
\t\t<h2 class="contract-title">{$node->widgetConfig->summaryView->templateTitle}</h2>
\t</div>
\t<div class="dollar-amounts">
\t\t<div class="spent-to-date">
\t\t\t{$spentToDateAmount}
            <div class="amount-title">{$spnttodt}</div>
\t\t</div>
\t\t<div class="original-amount">

コード例 #19

ファイル: contracts_highchart_active_agency_vendor.tpl.php プロジェクト: ecs-hk/Checkbook

  <thead>
    <tr>

        <?php 
if ($isAgencyPage) {
    echo "<th class='text'>" . WidgetUtil::generateLabelMapping("contract_agency") . "</th>";
} else {
    echo "<th class='text'>" . WidgetUtil::generateLabelMapping("prime_vendor") . "</th>";
}
?>
      <th class='number'><?php 
echo WidgetUtil::generateLabelMapping("no_of_contracts");
?>
</th>
      <th class='number'><?php 
echo WidgetUtil::generateLabelMapping("current_amount");
?>
</th>
      <th>&nbsp</th>
    </tr>
  </thead>
  <tbody>
  <?php 
if (isset($node->data) && is_array($node->data)) {
    foreach ($node->data as $datarow) {
        echo "<tr>";
        echo "<td><div>" . $datarow[$rowname] . "</div></td>";
        echo "<td>" . $datarow['total_contracts'] . "</td>";
        echo "<td>" . $datarow['current_amount_sum'] . "</td>";
        echo '<td>&nbsp</td>';
        echo "</tr>";

コード例 #20

ファイル: expense.tpl.php プロジェクト: ecs-hk/Checkbook

    }
    if ($smnid == 370 || $smnid == 786 || $smnid == 727) {
        $dynamicLabel = WidgetUtil::getLabel("contract_agency");
    }
    if ($smnid == 454 || $smnid == 787 || $smnid == 728) {
        $dynamicLabel = WidgetUtil::getLabel("industry_name");
    }
    if ($smnid == 453 || $smnid == 788 || $smnid == 729) {
        $dynamicLabel = WidgetUtil::getLabel("contract_size");
    }
    $originalAmount = custom_number_formatter_format($row['original_amount_sum'], 2, '$');
    $currentAmount = custom_number_formatter_format($row['current_amount_sum'], 2, '$');
    $spentToDateAmount = custom_number_formatter_format($row['spending_amount_sum'], 2, '$');
    $spnttodt = WidgetUtil::getLabel("spent_to_date");
    $oamnt = WidgetUtil::getLabel("original_amount");
    $camnt = WidgetUtil::getLabel("current_amount");
    $totalContracts = number_format($row['total_contracts']);
    $summaryContent = <<<EOD
<div class="contract-details-heading">
\t<div class="contract-id">
\t\t<h2 class="contract-title">{$node->widgetConfig->summaryView->templateTitle}</h2>
\t</div>
\t<div class="dollar-amounts">
\t\t<div class="spent-to-date">
\t\t\t{$spentToDateAmount}
            <div class="amount-title">{$spnttodt}</div>
\t\t</div>
\t\t<div class="original-amount">
\t\t    {$originalAmount}
            <div class="amount-title">{$oamnt}</div>
\t\t</div>

コード例 #21

ファイル: contracts_cta_spending_top.tpl.php プロジェクト: ecs-hk/Checkbook

$index_spending = 0;
foreach ($node->results_prime_vendor_info as $vendor => $vendor_summary) {
    $open = $index_spending == 0 ? '' : 'open';
    //Main table columns
    $tbl_spending['body']['rows'][$index_spending]['columns'] = array(array('value' => "<a class='showHide " . $open . " expandTwo' ></a>" . $vendor_summary['vendor_name'], 'type' => 'text'), array('value' => custom_number_formatter_format($vendor_summary['current_amount'], 2, '$'), 'type' => 'number'), array('value' => custom_number_formatter_format($vendor_summary['original_amount'], 2, '$'), 'type' => 'number'), array('value' => custom_number_formatter_format($vendor_summary['spent_to_date'], 2, '$'), 'type' => 'number'));
    if (_getRequestParamValue("datasource") != "checkbook_oge") {
        $contract_vendor_details = '<div id = "contract_history">';
        $nid = 426;
        $node = node_load($nid);
        node_build_content($node);
        $contract_vendor_details .= drupal_render($node->content);
        $contract_vendor_details .= '</div>';
        $spending_vendor_details = '<div id = "spending_transactions">';
        $nid = 427;
        $node = node_load($nid);
        node_build_content($node);
        $spending_vendor_details .= drupal_render($node->content);
        $spending_vendor_details .= '</div>';
    }
    $index_spending++;
    $tbl_spending['body']['rows'][$index_spending]['embed_node'] = array($contract_vendor_details, $spending_vendor_details);
    $index_spending++;
}
$html = "<div class='contracts-spending-top'>" . WidgetUtil::generateTable($tbl_spending) . "</div>";
echo $html;
?>

コード例 #22

ファイル: payroll_by_gross_ot_pay.tpl.php プロジェクト: ecs-hk/Checkbook

include_once 'payroll_title.php';
include_once 'page_title.php';
include_once 'export_link.php';
?>

<table id="table_<?php 
echo widget_unique_identifier($node);
?>
" class="<?php 
echo $node->widgetConfig->gridConfig->html_class;
?>
">
    <thead>
      <tr>
            <th class='text'><?php 
echo WidgetUtil::generateLabelMapping("month");
?>
</th>
            <?php 
echo $hidePrevLabel ? "" : "<th class='number'><div><span>{$SeriesPreviousYearLabel}</span></div></th>";
?>
            <th class='number'><div><span><?php 
echo $SeriesCurrentYearLabel;
?>
</span></div></th>
            <th>&nbsp</th>
      </tr>
    </thead>
    <tbody>
    <?php 
$months = array();

コード例 #23

ファイル: contract.tpl.php プロジェクト: ecs-hk/Checkbook

if (is_array($records)) {
    $row = $records[0];
    $originalAmount = custom_number_formatter_format($row['original_amount_sum'], 2, '$');
    $currentAmount = custom_number_formatter_format($row['current_amount_sum'], 2, '$');
    $spentToDateAmount = custom_number_formatter_format($row['spending_amount_sum'], 2, '$');
    $cont_id = WidgetUtil::getLabel("contract_id");
    $spnttodt = WidgetUtil::getLabel("spent_to_date");
    $oamnt = WidgetUtil::getLabel("original_amount");
    $camnt = WidgetUtil::getLabel("current_amount");
    $purpose = WidgetUtil::getLabel("contract_purpose");
    $agency = WidgetUtil::getLabel("contract_agency");
    $smnid = _getRequestParamValue('smnid');
    $dynamicLabel = $node->widgetConfig->summaryView->entityColumnLabel;
    $dynamicValue = strtoupper($row[$node->widgetConfig->summaryView->entityColumnName]);
    if (!isset($dynamicLabel)) {
        $dynamicLabel = WidgetUtil::getLabel("vendor_name");
    }
    $agency_value = strtoupper($row['agency_agency_agency_name']);
    $purpose_value = strtoupper($row['contract_purpose_contract_purpose']);
    $summaryContent = <<<EOD
<div class="contract-details-heading">
\t<div class="contract-id">
\t\t<h2 class="contract-title">{$node->widgetConfig->summaryView->templateTitle}</h2>
\t</div>
\t<div class="dollar-amounts">
\t\t<div class="spent-to-date">
\t\t\t{$spentToDateAmount}
            <div class="amount-title">{$spnttodt}</div>
\t\t</div>
\t\t<div class="original-amount">
\t\t    {$originalAmount}

コード例 #24

ファイル: budget_department_highchart.tpl.php プロジェクト: ecs-hk/Checkbook

*/
include_once 'budget_title.php';
include_once 'page_title.php';
include_once 'export_link.php';
?>

<table id="table_<?php 
echo widget_unique_identifier($node);
?>
" class="<?php 
echo $node->widgetConfig->gridConfig->html_class;
?>
">
    <thead>
    <?php 
echo "<tr><th class='text'>" . WidgetUtil::generateLabelMapping("dept_name") . "</th>\r\n        <th class='number'>" . WidgetUtil::generateLabelMapping("committed") . " </th>\r\n        <th class='number'>" . WidgetUtil::generateLabelMapping("remaining") . "</th>\r\n        <th>&nbsp</th>\r\n        </tr>\n";
?>
    </thead>

    <tbody>
<?php 
if (isset($node->data) && is_array($node->data)) {
    foreach ($node->data as $datarow) {
        echo "<tr>";
        echo '<td>' . $datarow['department_name_department_name'] . '</td>';
        echo '<td>' . $datarow['budget_committed'] . '</td>';
        echo '<td>' . $datarow['budget_remaining'] . '</td>';
        echo "<td>&nbsp</td>";
        echo "</tr>";
    }
}

コード例 #25

ファイル: spending_highchart_prime_vendor.tpl.php プロジェクト: ecs-hk/Checkbook

<table id="table_<?php 
echo widget_unique_identifier($node);
?>
" class="<?php 
echo $node->widgetConfig->gridConfig->html_class;
?>
">
  <thead>
    <tr>
        <th class='text'><?php 
echo WidgetUtil::generateLabelMapping("prime_vendor");
?>
</th>
        <th class='number'><?php 
echo WidgetUtil::generateLabelMapping("spending_amount");
?>
</th>
        <th>&nbsp</th>
    </tr>
  </thead>
  <tbody>
  <?php 
if (isset($node->data) && is_array($node->data)) {
    foreach ($node->data as $datarow) {
        echo "<tr>";
        echo "<td><div>" . $datarow['prime_vendor_prime_vendor_legal_name'] . "</div></td>";
        echo "<td>" . $datarow['check_amount_sum'] . "</td>";
        echo "<td>&nbsp</td>";
        echo "</tr>";
    }

コード例 #26

ファイル: contracts_oge_cta_all_vendor_info.tpl.php プロジェクト: ecs-hk/Checkbook

$tbl['header']['columns'] = array(array('value' => WidgetUtil::generateLabelMappingNoDiv("prime_vendor_name"), 'type' => 'text'), array('value' => $node->widget_count_label, 'type' => 'number'), array('value' => WidgetUtil::generateLabelMappingNoDiv("spent_to_date"), 'type' => 'number'), array('value' => WidgetUtil::generateLabelMappingNoDiv("prime_vendor_address"), 'type' => 'text'));
$vendor_cont_count = array();
foreach ($node->vendor_contracts_count as $vendor_cont) {
    $vendor_cont_count[$vendor_cont['vendor_id']]['count'] = $vendor_cont['count'];
    $vendor_cont_count[$vendor_cont['vendor_id']]['count'] = $vendor_cont['count'];
}
$count = 0;
if (count($node->vendors_list) > 0) {
    foreach ($node->vendors_list as $vendor) {
        $spending_link = "/spending/transactions/vendor/" . $vendor['vendor_id'] . "/datasource/checkbook_oge/newwindow";
        if (preg_match("/newwindow/", $_GET['q'])) {
            $vendor_name = $vendor['vendor_name'];
        } else {
            $vendor_name = "<a href='/contracts_landing/status/A/year/" . _getCurrentYearID() . "/yeartype/B/agency/" . $vendor['agency_id'] . "/datasource/checkbook_oge/vendor/" . $vendor['vendor_id'] . "?expandBottomCont=true'>" . $vendor['vendor_name'] . "</a>";
        }
        $spent_to_date_value = custom_number_formatter_format($vendor['check_amount_sum'], 2, '$');
        if (preg_match("/newwindow/", $_GET['q'])) {
            $spent_to_date_link = custom_number_formatter_format($vendor['check_amount_sum'], 2, '$');
        } else {
            $spent_to_date_link = "<a class='new_window' target='_new' href='" . $spending_link . "'>" . custom_number_formatter_format($vendor['check_amount_sum'], 2, '$') . "</a>";
        }
        //Main table columns
        $tbl['body']['rows'][$count]['columns'] = array(array('value' => $vendor_name, 'type' => 'text'), array('value' => $vendor_cont_count[$vendor['vendor_id']]['count'], 'type' => 'number'), array('value' => $spent_to_date_value, 'type' => 'number_link', 'link_value' => $spent_to_date_link), array('value' => $vendor['address'], 'type' => 'text'));
        $count++;
    }
}
$html = WidgetUtil::generateTable($tbl);
echo $html;
?>

コード例 #27

ファイル: table_by_list.tpl.php プロジェクト: ecs-hk/Checkbook

  <?php 
if (isset($node->widgetConfig->caption_column)) {
    echo '<caption>' . $node->data[0][$node->widgetConfig->caption_column] . '</caption>';
} else {
    if (isset($node->widgetConfig->caption)) {
        echo '<caption>' . $node->widgetConfig->caption . '</caption>';
    }
}
?>
  <thead>
  <?php 
echo "<tr>";
foreach ($node->widgetConfig->table_columns as $row) {
    if (check_node_flag_visibilty($row->visibility_flag, $node)) {
        if (!isset($row->datasource) || isset($row->datasource) && $row->datasource == _getRequestParamValue('datasource')) {
            $label = isset($row->labelAlias) ? WidgetUtil::generateLabelMapping($row->labelAlias) : $row->label;
            $fn = $row->adjustLabelFunction;
            if (isset($fn) && function_exists($fn)) {
                $label = $fn($label);
            } else {
                if (isset($row->evalLabel) && $row->evalLabel) {
                    $label = eval("return {$row->label};");
                }
            }
            $headerClass = $row->headerClass ? ' class="' . $row->headerClass . '"' : '';
            echo "<th{$headerClass}>" . $label . "</th>";
        }
    }
}
echo "</tr>\n";
?>

コード例 #28

ファイル: revenue_revcat_highchart.tpl.php プロジェクト: ecs-hk/Checkbook

include_once 'page_title.php';
include_once 'export_link.php';
?>



<table id="table_<?php 
echo widget_unique_identifier($node);
?>
" class="<?php 
echo $node->widgetConfig->gridConfig->html_class;
?>
">
    <thead>
    <?php 
echo "<tr><th class='text'>" . WidgetUtil::generateLabelMapping("revenue_category") . "</th>\r\n        <th class='number'>" . WidgetUtil::generateLabelMapping("recognized") . " </th>\r\n        <th class='number'>" . WidgetUtil::generateLabelMapping("remaining") . "</th>\r\n        <th>&nbsp</th>        \r\n        </tr>\n";
?>
    </thead>

    <tbody>
    <?php 
foreach ($node->data as $datarow) {
    echo "<tr>";
    echo '<td>' . $datarow['category_category_revenue_category_name'] . '</td>';
    echo '<td>' . $datarow['revenue_amount_sum'] . '</td>';
    echo '<td>' . $datarow['remaining'] . '</td>';
    echo "<td>&nbsp</td>";
    echo "</tr>";
}
?>
    </tbody>

コード例 #29

ファイル: employee_agency_payroll_summary.tpl.php プロジェクト: ecs-hk/Checkbook

    }
    $employeeData .= "<div id='emp-agency-detail-records'>";
    foreach ($node->data as $data) {
        $typeOfEmployment = $data['employment_type_employment_type'];
        $year = $data['year_year'];
        $yearType = $data['year_type_year_type'];
        $agency = strtoupper($data['agency_agency_agency_name']);
        $agencyUrl = "<a href='/payroll/agency/{$data['agency_agency']}/yeartype/{$yearType}/year/{$year}'>{$agency}</a>";
        $title = strtolower($data['employee_employee_civil_service_title']);
        //$title = str_replace('( ', '(', ucwords(str_replace('(', '( ', $title)));
        $title = mb_convert_case($title, MB_CASE_TITLE, "UTF-8");
        //this works too
        $table = "<div class='emp-agency-detail-record'><table id='emp-agency-detail-record-table'>";
        $table .= '<div id="payroll-emp-trans-name">
                        <span class="payroll-label">Title: </span>
                        <span class="payroll-value" >' . $title . '</span>
                    </div>';
        $table .= "<tr>\r\n                        <td width='60%'><strong>" . WidgetUtil::getLabel('agency_name') . "</strong>: {$agencyUrl}</td>\r\n                        <td width='40%'><strong>" . WidgetUtil::getLabel('gross_pay_ytd') . "</strong>:\$" . number_format($data['total_gross_pay'], 2) . "</td>\r\n                   </tr>";
        $table .= "<tr>\r\n                        <td><strong>" . WidgetUtil::getLabel('payroll_type') . "</strong>: " . strtoupper($data['employment_type_employment_type']) . "</td>\r\n                        <td><strong>" . WidgetUtil::getLabel('base_pay_ytd') . "</strong>: \$" . number_format($data['total_base_salary'], 2) . "</td>\r\n                   </tr>";
        $table .= "<tr>\r\n                        <td><strong>" . ($typeOfEmployment == 'Salaried' ? WidgetUtil::getLabel('annual_salary') : WidgetUtil::getLabel('pay_rate')) . "</strong>: \$" . number_format($data['max_annual_salary'], 2) . "</td>\r\n                        <td><strong>" . WidgetUtil::getLabel('other_pay_1_ytd') . "</strong>: \$" . number_format($data['total_other_payments'], 2) . "</td>\r\n                   </tr>";
        $table .= "<tr>\r\n                        <td ><strong>" . WidgetUtil::getLabel('overtime_pay_1_ytd') . "</strong>: \$" . number_format($data['total_overtime_amount'], 2) . "</td>\r\n                    </tr>";
        $table .= "</table></div>";
        $employeeData .= $table;
    }
    if (count($node->data) > 1) {
        $employeeData .= "</div><div id='next-emp' href='#'></div></div>";
    } else {
        $employeeData .= "</div></div>";
    }
    print $employeeData;
}