</table> <?php $rs = mysql_query($sql, cnnGeneral()); $gvalues = ""; $gnames = ""; $i = 0; $tds = ""; $mnt = 0; $sm = 0; while ($rw = mysql_fetch_array($rs)) { $val[] = round($rw[1] / 1000, 2); $lbl[] = $rw[0]; $sm += $rw[1]; $tds = $tds . "<tr>\n\t<td>{$rw['0']}</td>\n\t<td class='mny'>" . getFMoney($rw[1]) . "</td>\n\n\t</tr>"; $i++; } //echo $gnames; //echo $gvalues; $sm = getFMoney($sm); echo "<table width='100%' aling='center'>\n\t<tr>\n\t\t<th>Concepto</th>\n\t\t<th>Monto</th>\n\t</tr>\n\n\t{$tds}\n\n\t<tr>\n\t\t<td>Sumas</td>\n\t\t<td>{$sm}</td>\n\t</tr>\n\n\t</table>"; $x = new SAFEChart(); $x->setValues($val); $x->setLabels($lbl); $x->setTitle("INGRESOS ACUMULADOS EN UN RANGO DE FECHAS(Miles)"); $mFile = $x->Chart3DBAR(10000); open_flash_chart_object(768, 512, $mFile, true, "../"); echo getRawFooter(); ?> </body> </html>
$x2->setValues($valMC); $x2->setLabels($lblMC); $x2->setTitle("CIFRAS DE CAPTACION EN MILES"); $mFile2 = $x2->Chart3DBar(10000); open_flash_chart_object(648, 512, $mFile2, true, "../"); //==================================================================================================== //CREDITOS $lblMD = array(); $valMD = array(); $lblND = array(); $valND = array(); $W3 = "\tAND\n\t\t\t\t(`creditos_solicitud`.`saldo_actual` >0)\n\t\t\t\tAND\n\t\t\t\t(`creditos_solicitud`.`fecha_ministracion` >= '{$fecha_inicial}')\n\t\t\t\tAND\n\t\t\t\t(`creditos_solicitud`.`fecha_ministracion` <= '{$fecha_final}')\n"; $DCreds = $cSuc->getColocacionTotal($W3); $lblND[] = "Creditos"; $valND[] = $DCreds["numero"]; $lblMD[] = "Tot. Solicitado"; $valMD[] = round($DCreds["solicitado"] / 1000, 2); $lblMD[] = "Tot. Ministrado"; $valMD[] = round($DCreds["ministrado"] / 1000, 2); $lblMD[] = "Tot. Insoluto"; $valMD[] = round($DCreds["saldo"] / 1000, 2); $x2 = new SAFEChart(); $x2->setValues($valMD); $x2->setLabels($lblMD); $x2->setTitle("CIFRAS GENERALES DE CREDITOS(MILES)"); $mFile2 = $x2->Chart3DBar(20000); open_flash_chart_object(648, 512, $mFile2, true, "../"); echo getRawFooter(); ?> </body> </html>