function GetCetakGeneralHTML($param_arr) { $output = ''; $output .= '<table id="table-piutang" class="grid-table-container" border="0" cellspacing="0" cellpadding="0" width="98%" style="margin-left:10px;margin-right:10px;margin-top:10px;padding:5px 5px 5px 5px;"> <tr> <td valign="top">'; $output .= '<table class="grid-table" border="0" cellspacing="0" cellpadding="0"> <tr> <td class="HeaderLeft"><img border="0" alt="" src="../Styles/sikp/Images/Spacer.gif"></td> <td class="th"><strong style="font-size:25px;">LAPORAN TARGET DAN REALISASI</strong></td> <td class="HeaderRight"><img border="0" alt="" src="../Styles/sikp/Images/Spacer.gif"></td> </tr> </table>'; //$output .= '<div align="right"><a href="#" onClick="downloadGeneral();"> Download Excel </a></div>'; $output .= '<h3>BIDANG PAJAK PENDAFTARAN & PAJAK PENETAPAN</h3>'; $output .= '<h3>PERIODE : ' . $param_arr["pajak_periode"] . ' s.d ' . $param_arr["pajak_periode1"] . '</h3> <br/>'; $output .= '<table class="report" cellspacing="0" cellpadding="4px" width="100%"> <tr style="background:#282A68;color:#FFFFFF; font-size:15px;">'; $output .= '<th width="150">JENIS PAJAK</th>'; $output .= '<th width="150">TARGET</th>'; $output .= '<th width="150">REALISASI</th>'; //$output .= '<th width="150">PIUTANG</th>'; $output .= '<th width="150">KETERANGAN SELISIH</th>'; $output .= '</tr>'; $date_awal = $param_arr['date_awal']; $date_akhir = $param_arr['date_akhir']; $dbConn = new clsDBConnSIKP(); $query = "SELECT a.p_vat_type_id, upper(a.vat_code) AS jenis_pajak, upper(substring(a.vat_code from 7)) as pajak_text, b.vat_code, b.p_vat_type_dtl_id\r\n\t\t\t\tFROM p_vat_type AS a \r\n\t\t\t\tLEFT JOIN p_vat_type_dtl as b ON a.p_vat_type_id = b.p_vat_type_id\r\n\t\t\t\tWHERE a.p_vat_type_id NOT IN (7,9) AND b.p_vat_type_dtl_id NOT IN (12, 23, 30, 31, 42, 43)\r\n\t\t\t\tORDER BY a.p_vat_type_id ASC, b.vat_code ASC"; $dbConn->query($query); $data = array(); while ($dbConn->next_record()) { $data["p_vat_type_id"][] = $dbConn->f("p_vat_type_id"); $data["jenis_pajak"][] = $dbConn->f("jenis_pajak"); $data["pajak_text"][] = $dbConn->f("pajak_text"); $data["vat_code"][] = $dbConn->f("vat_code"); $data["p_vat_type_dtl_id"][] = $dbConn->f("p_vat_type_dtl_id"); $data["date_awal"][] = $date_awal; $data["date_akhir"][] = $date_akhir; } $dbConn->close(); $pajak_text = ''; $pajak_text = $data['pajak_text'][0]; $item = array(); $total_target_ = 0; $total_realisasi_ = 0; $total_piutang_ = 0; $total_selisih_ = 0; $grand_total_target_ = 0; $grand_total_realisasi_ = 0; $grand_total_selisih_ = 0; $grand_total_piutang_ = 0; for ($i = 0; $i < count($data['vat_code']); $i++) { $item = getDataRow($param_arr['p_year_period_id'], $data['p_vat_type_id'][$i], $data['date_awal'][$i], $data['date_akhir'][$i], $data['p_vat_type_dtl_id'][$i]); if ($pajak_text == $data['pajak_text'][$i]) { if ($data['p_vat_type_id'][$i] == 1 or $data['p_vat_type_id'][$i] == 2 or $data['p_vat_type_id'][$i] == 3) { $output .= '<tr>'; $output .= '<td>' . $data['vat_code'][$i] . '</td>'; $output .= '<td align="right">' . number_format($item['target'], 0, ',', '.') . ' </td>'; $output .= '<td align="right">' . number_format($item['realisasiDanPiutang'], 0, ',', '.') . '</td>'; //$output .= '<td align="right">'.number_format($item['realisasi'], 0, ',', '.').'</td>'; //$output .= '<td align="right">'.number_format($item['piutang'], 0, ',', '.').'</td>'; $output .= '<td align="right">' . number_format($item['selisih'], 0, ',', '.') . '</td>'; $output .= '</tr>'; } $total_target_ += $item['target']; $total_realisasi_ += $item['realisasiDanPiutang']; //$total_realisasi_ += $item['realisasi']; //$total_piutang_ += $item['piutang']; $total_selisih_ += $item['selisih']; } else { $output .= '<tr style="background:#498CD6;font-weight:bold;color:#FFFFFF;">'; $output .= '<td style="padding-left:20px;"> JUMLAH ' . $pajak_text . '</td>'; $output .= '<td align="right"> ' . number_format($total_target_, 0, ',', '.') . ' </td>'; $output .= '<td align="right"> ' . number_format($total_realisasi_, 0, ',', '.') . '</td>'; //$output .= '<td align="right"> '.number_format($total_piutang_, 0, ',', '.').'</td>'; $output .= '<td align="right"> ' . number_format($total_selisih_, 0, ',', '.') . ' </td>'; $output .= '</tr>'; /*GRAND TOTATL */ $grand_total_target_ += $total_target_; $grand_total_realisasi_ += $total_realisasi_; $grand_total_piutang_ += $total_piutang_; $grand_total_selisih_ += $total_selisih_; /*END GRAND TOTAL */ $pajak_text = $data['pajak_text'][$i]; $total_target_ = 0; $total_realisasi_ = 0; $total_piutang_ = 0; $total_selisih_ = 0; if ($data['p_vat_type_id'][$i] == 1 or $data['p_vat_type_id'][$i] == 2 or $data['p_vat_type_id'][$i] == 3) { $output .= '<tr>'; $output .= '<td>' . $data['vat_code'][$i] . '</td>'; $output .= '<td align="right">' . number_format($item['target'], 0, ',', '.') . ' </td>'; $output .= '<td align="right">' . number_format($item['realisasiDanPiutang'], 0, ',', '.') . '</td>'; //$output .= '<td align="right">'.number_format($item['realisasi'], 0, ',', '.').'</td>'; //$output .= '<td align="right">'.number_format($item['piutang'], 0, ',', '.').'</td>'; $output .= '<td align="right">' . number_format($item['selisih'], 0, ',', '.') . '</td>'; $output .= '</tr>'; } $total_target_ += $item['target']; $total_realisasi_ += $item['realisasiDanPiutang']; //$total_realisasi_ += $item['realisasi']; //$total_piutang_ += $item['piutang']; $total_selisih_ += $item['selisih']; } } $output .= '<tr style="background:#498CD6;font-weight:bold;color:#FFFFFF;">'; $output .= '<td style="padding-left:20px;"> JUMLAH ' . $pajak_text . '</td>'; $output .= '<td align="right"> ' . number_format($total_target_, 0, ',', '.') . ' </td>'; $output .= '<td align="right"> ' . number_format($total_realisasi_, 0, ',', '.') . '</td>'; //$output .= '<td align="right"> '.number_format($total_piutang_, 0, ',', '.').'</td>'; $output .= '<td align="right"> ' . number_format($total_selisih_, 0, ',', '.') . ' </td>'; $output .= '</tr>'; $itemReklame = getDataRowReklame($param_arr['p_year_period_id'], $date_awal, $date_akhir); $output .= '<tr style="background:#498CD6;font-weight:bold;color:#FFFFFF;">'; $output .= '<td style="padding-left:20px;"> JUMLAH REKLAME </td>'; $output .= '<td align="right"> ' . number_format($itemReklame['target'], 0, ',', '.') . ' </td>'; $output .= '<td align="right"> ' . number_format($itemReklame['realisasiDanPiutang'], 0, ',', '.') . '</td>'; //$output .= '<td align="right"> '.number_format($itemReklame['realisasi'], 0, ',', '.').'</td>'; //$output .= '<td align="right"> '.number_format($itemReklame['piutang'], 0, ',', '.').'</td>'; $output .= '<td align="right"> ' . number_format($itemReklame['selisih'], 0, ',', '.') . ' </td>'; $output .= '</tr>'; /*GRAND TOTATL */ $grand_total_target_ += $total_target_ + $itemReklame['target']; $grand_total_realisasi_ += $total_realisasi_ + $itemReklame['realisasiDanPiutang']; //$grand_total_realisasi_ += $total_realisasi_ + $itemReklame['realisasi']; //$grand_total_piutang_ += $total_piutang_ + $itemReklame['piutang']; $grand_total_selisih_ += $total_selisih_ + $itemReklame['selisih']; /*END GRAND TOTAL */ $output .= '<tr style="background:#000000;font-weight:bold;font-size:14px;color:#FFFFFF;">'; $output .= '<td style="padding-left:20px;"> JUMLAH TOTAL </td>'; $output .= '<td align="right"> ' . number_format($grand_total_target_, 0, ',', '.') . ' </td>'; $output .= '<td align="right"> ' . number_format($grand_total_realisasi_, 0, ',', '.') . '</td>'; //$output .= '<td align="right"> '.number_format($grand_total_piutang_, 0, ',', '.').'</td>'; $output .= '<td align="right"> ' . number_format($grand_total_selisih_, 0, ',', '.') . ' </td>'; $output .= '</tr>'; $output .= '<tr> <td colspan="4" align="right" style="text-align:right;font-size:15px;color:#282A68;">TIM IT Disyanjak@2014 www.disyanjak.bandung.go.id</td> </tr>'; $output .= '</table>'; $output .= '</td></tr>'; $output .= '</table>'; return $output; }
function GetCetakGeneralHTML($param_arr) { $output = ''; $output .= '<table id="table-piutang" class="grid-table-container" border="0" cellspacing="0" cellpadding="0" width="70%" style="margin-left:10px;padding:5px 5px 5px 5px;"> <tr> <td valign="top">'; $output .= '<table class="grid-table" border="0" cellspacing="0" cellpadding="0"> <tr> <td class="HeaderLeft"><img border="0" alt="" src="../Styles/sikp/Images/Spacer.gif"></td> <td class="th"><strong>LAPORAN TARGET DAN REALISASI</strong></td> <td class="HeaderRight"><img border="0" alt="" src="../Styles/sikp/Images/Spacer.gif"></td> </tr> </table>'; //$output .= '<div align="right"><a href="#" onClick="downloadGeneral();"> Download Excel </a></div>'; $output .= '<h3>BIDANG PAJAK PENDAFTARAN & PAJAK PENETAPAN</h3>'; $output .= '<h3>PERIODE : ' . $param_arr["pajak_periode"] . ' s.d ' . $param_arr["pajak_periode1"] . '</h3> <br/>'; $output .= '<table class="report" cellspacing="0" cellpadding="4px" width="100%"> <tr style="background:#498CD6;color:#FFFFFF;">'; $output .= '<th width="150">JENIS PAJAK</th>'; $output .= '<th width="150">TARGET</th>'; $output .= '<th width="150">REALISASI</th>'; //$output .= '<th width="150">DENDA</th>'; $output .= '<th width="150">KETERANGAN SELISIH</th>'; $output .= '</tr>'; $date_awal = getDateAwal($param_arr['p_finance_period_id']); $date_akhir = getDateAkhir($param_arr['p_finance_period_id1']); $dbConn = new clsDBConnSIKP(); $query = "SELECT a.p_vat_type_id, upper(a.vat_code) AS jenis_pajak, upper(substring(a.vat_code from 7)) as pajak_text \r\n\t\t\t\tFROM p_vat_type AS a\r\n\t\t\t\tWHERE a.p_vat_type_id NOT IN (7) \r\n\t\t\t\tORDER BY a.p_vat_type_id ASC"; $dbConn->query($query); $data = array(); while ($dbConn->next_record()) { $data["p_vat_type_id"][] = $dbConn->f("p_vat_type_id"); $data["jenis_pajak"][] = $dbConn->f("jenis_pajak"); $data["pajak_text"][] = $dbConn->f("pajak_text"); $data["date_awal"][] = $date_awal; $data["date_akhir"][] = $date_akhir; } $dbConn->close(); $pajak_text = ''; $pajak_text = $data['pajak_text'][0]; $item = array(); $total_target_ = 0; $total_realisasi_ = 0; $total_piutang_ = 0; $total_selisih_ = 0; $total_denda_ = 0; $grand_total_target_ = 0; $grand_total_realisasi_ = 0; $grand_total_selisih_ = 0; $grand_total_piutang_ = 0; $grand_total_denda_ = 0; for ($i = 0; $i < count($data['jenis_pajak']); $i++) { $result = array(); /*$output .= '<tr>'; $output .= '<td>'.$data['jenis_pajak'][$i].'</td>'; $output .= '<td align="right">target</td>'; $output .= '<td align="right">realisasi</td>'; $output .= '<td align="right">denda</td>'; $output .= '<td align="right">selisih</td>'; $output .= '</tr>';*/ $result = getDataRow($param_arr['p_year_period_id'], $data['p_vat_type_id'][$i], $data['date_awal'][$i], $data['date_akhir'][$i]); //print_r($result);exit; $item['realisasiDanPiutang'] = 0; $item['denda'] = 0; $item['target'] = 0; $ayat_sebelum = $result[0]['p_vat_type_dtl_id']; $ayat_sebelum_kode = $result[0]['ayat']; //echo count($result);exit; for ($counter = 0; $counter < count($result); $counter++) { if ($result[$counter]['p_vat_type_dtl_id'] != $ayat_sebelum) { if ($data["p_vat_type_id"][$i] == 1 || $data["p_vat_type_id"][$i] == 2 || $data["p_vat_type_id"][$i] == 3 || $data["p_vat_type_id"][$i] == 4) { $output .= '<tr>'; $output .= '<td>' . $ayat_sebelum_kode . '</td>'; $output .= '<td align="right">' . number_format($item['target'], 0, ',', '.') . ' </td>'; $output .= '<td align="right">' . number_format($item['realisasiDanPiutang'], 0, ',', '.') . '</td>'; $output .= '<td align="right">' . number_format($item['realisasiDanPiutang'] + $item['denda'] - $item['target'], 0, ',', '.') . '</td>'; $output .= '</tr>'; } $total_target_ = $total_target_ + $item['target']; $total_realisasi_ = $total_realisasi_ + $item['realisasiDanPiutang']; $total_selisih_ = $total_selisih_ + ($item['realisasiDanPiutang'] - $item['target']); $item['realisasiDanPiutang'] = $result[$counter]['realisasi_amt'] + $result[$counter]['debt_amt']; $item['denda'] = $result[$counter]['denda_pokok'] + $result[$counter]['denda_piutang']; $item['target'] = $result[$counter]['target_amount']; $ayat_sebelum = $result[$counter]['p_vat_type_dtl_id']; $ayat_sebelum_kode = $result[$counter]['ayat']; $item['target'] = $result[$counter]['target_amount']; } else { $item['realisasiDanPiutang'] = $item['realisasiDanPiutang'] + $result[$counter]['realisasi_amt'] + $result[$counter]['debt_amt']; $item['denda'] = $item['denda'] + $result[$counter]['denda_pokok'] + $result[$counter]['denda_piutang']; $item['target'] = $item['target'] + $result[$counter]['target_amount']; } } //AYAT TERAKHIR if ($data["p_vat_type_id"][$i] == 1 || $data["p_vat_type_id"][$i] == 2 || $data["p_vat_type_id"][$i] == 3 || $data["p_vat_type_id"][$i] == 4) { $output .= '<tr>'; $output .= '<td>' . $ayat_sebelum_kode . '</td>'; $output .= '<td align="right">' . number_format($item['target'], 0, ',', '.') . ' </td>'; $output .= '<td align="right">' . number_format($item['realisasiDanPiutang'], 0, ',', '.') . '</td>'; $output .= '<td align="right">' . number_format($item['realisasiDanPiutang'] + $item['denda'] - $item['target'], 0, ',', '.') . '</td>'; $output .= '</tr>'; } //DENDA if ($data["p_vat_type_id"][$i] == 1 || $data["p_vat_type_id"][$i] == 2 || $data["p_vat_type_id"][$i] == 3 || $data["p_vat_type_id"][$i] == 4) { $output .= '<tr>'; $output .= '<td>DENDA</td>'; $output .= '<td align="right">' . number_format(0, 0, ',', '.') . ' </td>'; $output .= '<td align="right">' . number_format($item['denda'], 0, ',', '.') . '</td>'; $output .= '<td align="right">' . number_format($item['denda'] - 0, 0, ',', '.') . '</td>'; $output .= '</tr>'; } $total_target_ = $total_target_ + $item['target']; $total_realisasi_ = $total_realisasi_ + $item['realisasiDanPiutang'] + $item['denda']; $total_selisih_ = $total_selisih_ + ($item['realisasiDanPiutang'] + $item['denda'] - $item['target']); //TOTAL PER JENIS PAJAK $output .= '<tr style="background:#498CD6;font-weight:bold;color:#FFFFFF;">'; $output .= '<td style="padding-left:20px;"> JUMLAH ' . $data["pajak_text"][$i] . '</td>'; $output .= '<td align="right"> ' . number_format($total_target_, 0, ',', '.') . ' </td>'; $output .= '<td align="right"> ' . number_format($total_realisasi_, 0, ',', '.') . '</td>'; $output .= '<td align="right"> ' . number_format($total_selisih_, 0, ',', '.') . ' </td>'; $output .= '</tr>'; $grand_total_target_ = $grand_total_target_ + $total_target_; $grand_total_realisasi_ = $grand_total_realisasi_ + $total_realisasi_; $grand_total_selisih_ = $grand_total_selisih_ + $total_selisih_; $item['realisasiDanPiutang'] = $result[$counter]['realisasi_amt'] + $result[$counter]['debt_amt']; $item['denda'] = $result[$counter]['denda_pokok'] + $result[$counter]['denda_piutang']; $item['target'] = $result[$counter]['target_amount']; $ayat_sebelum = $result[$counter]['p_vat_type_dtl_id']; $ayat_sebelum_kode = $result[$counter]['ayat']; $item['target'] = $result[$counter]['target_amount']; $total_target_ = 0; $total_realisasi_ = 0; $total_selisih_ = 0; } $output .= '<tr style="background:#000000;font-weight:bold;font-size:14px;color:#FFFFFF;">'; $output .= '<td style="padding-left:20px;"> JUMLAH TOTAL </td>'; $output .= '<td align="right"> ' . number_format($grand_total_target_, 0, ',', '.') . ' </td>'; $output .= '<td align="right"> ' . number_format($grand_total_realisasi_, 0, ',', '.') . '</td>'; $output .= '<td align="right"> ' . number_format($grand_total_selisih_, 0, ',', '.') . ' </td>'; $output .= '</tr>'; $output .= '</table>'; return $output; }
function getTableBody($result, stdClass $fieldsFilter, array $atributos, $totalRegistros) { $return = $footer = $html = ''; $groupId = 0; $subgroupId = 0; if (isResult($result) && !empty($fieldsFilter->head['campos'])) { $total = 0; while ($row = mysql_fetch_array($result)) { if ($groupId != $row['groupId'] && $subgroupId != $row['subgroupId']) { $colspans = getColspanRow(count($fieldsFilter->head['campos']), count($fieldsFilter->body['campos'])); if ($groupId > 0 && $subgroupId > 0) { $footer = getTableFooter($fieldsFilter->body['campos'], $atributos['fieldTotal'], $total, '', ''); } $groupId = $row['groupId']; $subgroupId = $row['subgroupId']; $dataRowHead = getDataRow($row, $fieldsFilter->head['campos'], $fieldsFilter->head['args'], $colspans['head']); $dataRowBody = getDataRow($row, $fieldsFilter->body['campos'], $fieldsFilter->body['args'], $colspans['body'], $atributos['fieldTotal']); $eventHead = !empty($dataRowHead['args']) && !empty($fieldsFilter->head['url']) ? "ondblclick=sendRow(this,\"{$fieldsFilter->head['url']}&{$dataRowHead['args']}\",\"{$fieldsFilter->head['panel']}\");" : ''; $html .= "{$footer}<tr {$eventHead} >{$dataRowHead['html']}</tr>"; $total = $dataRowBody['value']; $eventBody = !empty($dataRowBody['args']) && !empty($fieldsFilter->body['url']) ? "ondblclick=sendRow(this,\"{$fieldsFilter->body['url']}&{$dataRowBody['args']}\",\"{$fieldsFilter->body['panel']}\");" : ''; $html .= "<tr {$eventBody} >{$dataRowBody['html']}</tr>"; } else { $colspans = getColspanRow(count($fieldsFilter->head['campos']), count($fieldsFilter->body['campos'])); $dataRowBody = getDataRow($row, $fieldsFilter->body['campos'], $fieldsFilter->body['args'], $colspans['body'], $atributos['fieldTotal']); $total += $dataRowBody['value']; $eventBody = !empty($dataRowBody['args']) ? "ondblclick=sendRow(this,\"{$fieldsFilter->body['url']}&{$dataRowBody['args']}\",\"{$fieldsFilter->body['panel']}\");" : ''; $html .= "<tr {$eventBody} >{$dataRowBody['html']}</tr>"; } } $footer = getTableFooter($fieldsFilter->body['campos'], $atributos['fieldTotal'], $total, '', ''); $return = '<tbody>' . $html . $footer . '</tbody>'; } elseif (isResult($result) && !empty($fieldsFilter->body['campos'])) { $total = 0; while ($row = mysql_fetch_array($result)) { $i .= '1'; $checked = getChecked($row, $atributos['checked']); $colspans = getColspanRow(count($fieldsFilter->head['campos']), count($fieldsFilter->body['campos'])); $dataRowBody = getDataRow($row, $fieldsFilter->body['campos'], $fieldsFilter->body['args'], $colspans['body'], $atributos['fieldTotal']); $eventBody = !empty($dataRowBody['args']) && !empty($fieldsFilter->body['url']) ? "ondblclick=sendRow(this,\"{$fieldsFilter->body['url']}&{$dataRowBody['args']}\",\"{$fieldsFilter->body['panel']}\");" : ''; $html .= "<tr {$eventBody} >{$checked}{$dataRowBody['html']}</tr>"; $total += $dataRowBody['value']; } $footer = getTableFooter($fieldsFilter->body['campos'], $atributos['fieldTotal'], $total, $atributos['checked'], 'tfoot', $totalRegistros); $return = '<tbody>' . $html . '</tbody>' . $footer; } return $return; }
function getTableBody($result, stdClass $fieldsFilter, array $atributos, $totalRegistros, $SUMMARY_COLS_CSS = null) { ## DEFINIENDO la variable GET pagina-start para la url de los registros $paginador = explode(',', $atributos['paginador']); ////CONSTRUYE PARTE DE LA URL DEL PAGINADOR $urlSeg = explode('?', $paginador[1]); $urlSegA = $urlSeg[1]; $urlSegB = explode('=', $urlSegA); $urlSegUrl = $urlSegB[0]; $paginaStart = is_int((int) get('' . $urlSegUrl . 'pagina-start')) && (int) get('' . $urlSegUrl . 'pagina-start') > 0 ? get('' . $urlSegUrl . 'pagina-start') : 1; ## FIN DEFINICIÓN la variable GET pagina-start para la url de los registros $return = $footer = $html = ''; $groupId = 0; if (isResult($result) && !empty($fieldsFilter->head['campos'])) { $total = 0; while ($row = mysql_fetch_array($result)) { if ($groupId != $row['groupId']) { $colspans = getColspanRow(count($fieldsFilter->head['campos']), count($fieldsFilter->body['campos'])); if ($groupId > 0) { $footer = getTableFooter($fieldsFilter->body['campos'], $atributos['fieldTotal'], $total, '', ''); } $groupId = $row['groupId']; $dataRowHead = getDataRow($row, $fieldsFilter->head['campos'], $fieldsFilter->head['args'], $colspans['head']); $dataRowBody = getDataRow($row, $fieldsFilter->body['campos'], $fieldsFilter->body['args'], $colspans['body'], $atributos['fieldTotal'], $SUMMARY_COLS_CSS); $eventHead = !empty($dataRowHead['args']) && !empty($fieldsFilter->head['url']) ? "onclick=sendRow(this,\"{$fieldsFilter->head['url']}&{$dataRowHead['args']}\",\"{$fieldsFilter->head['panel']}\");" : ''; $html .= "{$footer}<tr {$eventHead} >{$dataRowHead['html']}</tr>"; $total = $dataRowBody['value']; $eventBody = !empty($dataRowBody['args']) && !empty($fieldsFilter->body['url']) ? "onclick=sendRow(this,\"{$fieldsFilter->body['url']}&pagina-start={$paginaStart}&{$dataRowBody['args']}\",\"{$fieldsFilter->body['panel']}\");" : ''; $html .= "<tr {$eventBody} >{$dataRowBody['html']}</tr>"; } else { $colspans = getColspanRow(count($fieldsFilter->head['campos']), count($fieldsFilter->body['campos'])); $dataRowBody = getDataRow($row, $fieldsFilter->body['campos'], $fieldsFilter->body['args'], $colspans['body'], $atributos['fieldTotal'], $SUMMARY_COLS_CSS); $total += $dataRowBody['value']; $eventBody = !empty($dataRowBody['args']) ? "onclick=sendRow(this,\"{$fieldsFilter->body['url']}&pagina-start={$paginaStart}&{$dataRowBody['args']}\",\"{$fieldsFilter->body['panel']}\");" : ''; $html .= "<tr {$eventBody} >{$dataRowBody['html']}</tr>"; } } $footer = getTableFooter($fieldsFilter->body['campos'], $atributos['fieldTotal'], $total, '', ''); // var_dump($total); $return = '<tbody>' . $html . $footer . '</tbody>'; } elseif (isResult($result) && !empty($fieldsFilter->body['campos'])) { $total = 0; while ($row = mysql_fetch_array($result)) { $checked = getChecked($row, $atributos['checked']); $colspans = getColspanRow(count($fieldsFilter->head['campos']), count($fieldsFilter->body['campos'])); $dataRowBody = getDataRow($row, $fieldsFilter->body['campos'], $fieldsFilter->body['args'], $colspans['body'], $atributos['fieldTotal'], $SUMMARY_COLS_CSS); $eventBody = !empty($dataRowBody['args']) && !empty($fieldsFilter->body['url']) ? "onclick=sendRow(this,\"{$fieldsFilter->body['url']}&pagina-start={$paginaStart}&{$dataRowBody['args']}\",\"{$fieldsFilter->body['panel']}\");" : ''; $html .= "<tr {$eventBody} >{$checked}{$dataRowBody['html']}</tr>"; $total += $dataRowBody['value']; } $footer = getTableFooter($fieldsFilter->body['campos'], $atributos['fieldTotal'], $total, $atributos['checked'], 'tfoot', $totalRegistros); $return = '<tbody>' . $html . '</tbody>' . $footer; } return $return; }