<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> </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> </td>"; echo "</tr>"; }
* * 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>
$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> | <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; }
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> </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> </td>"; echo "</tr>"; } }
<tr><th class='text'><?php echo WidgetUtil::generateLabelMapping("contract_id"); ?> </th> <th class='number-left'><?php echo WidgetUtil::generateLabelMapping("spending_amount"); ?> </th> <th> </th> <th class='text'><?php echo WidgetUtil::generateLabelMapping("prime_vendor"); ?> </th> <th class='text'><?php echo WidgetUtil::generateLabelMapping("contract_agency"); ?> </th> <th> </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>
* 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; }
$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") {
$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>
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>";
<?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;
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>
* 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>
$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}
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> </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> </td>"; echo "</tr>"; } ?> </tbody>
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>";
* 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>
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; }
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">
<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> </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> </td>'; echo "</tr>";
} 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>
$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; ?>
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> </th> </tr> </thead> <tbody> <?php $months = array();
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}
*/ 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> </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> </td>"; echo "</tr>"; } }
<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> </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> </td>"; echo "</tr>"; }
$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; ?>
<?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"; ?>
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> </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> </td>"; echo "</tr>"; } ?> </tbody>
} $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; }