$sql = "select convenio, count(solicitud) AS 'numero', SUM(monto_solicitado) AS 'total_colocado' FROM solicitudes {$si_es_por_fecha} AND monto_solicitado>=0.99 GROUP BY convenio"; $rs = mysql_query($sql); //echo $sql; $gvalues = ""; $gnames = ""; $i = 0; $tds = ""; $mnt = 0; $sm = 0; $nm = 0; while ($rw = mysql_fetch_array($rs)) { $val[] = round($rw[2] / 1000, 2); $lbl[] = $rw[0]; $sm = $sm + $rw[2]; $nm = $nm + $rw[1]; $tds = $tds . "<tr>\n\t<td>{$rw['0']}</td>\n\t<td>{$rw['1']}</td>\n\t<td class='mny'>" . getFMoney($rw[2]) . "</td>\n\t</tr>"; $i++; } //echo $gnames; //echo $gvalues; echo "<table >\n\t<tr>\n\t\t<th>Tipo de Convenio</th>\n\t\t<th>Numero Solicitado</th>\n\t\t<th>Cantidad</th>\n\t</tr>\n\t\n\t{$tds}\n\t\n\t<tr>\n\t\t<td>Sumas</td>\n\t\t<th>{$nm}</th>\n\t\t<th class='mny'>" . getFMoney($sm) . "</th>\n\t</tr>\n\t</td>"; $x = new SAFEChart(); $x->setValues($val); $x->setLabels($lbl); $x->setTitle("REPORTE DE SOLICITUDES DE CREDITO EN FECHA DADA(Miles)"); $mFile = $x->Chart3DBAR(2500); open_flash_chart_object(768, 512, $mFile, true, "../"); echo getRawFooter(); ?> </body> </html>
</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>
</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 += round($rw[1] / 1000, 2); $tds = $tds . "<tr>\n\t<td>{$rw['0']}</td>\n\t<td class='mny'>" . getFMoney(round($rw[1] / 1000, 2)) . "</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<th class='mny'>{$sm}</th>\n\t</tr>\n\n\t</table>"; $x = new SAFEChart(); $x->setValues($val); $x->setLabels($lbl); $x->setTitle("DEPOSITOS DE CAPTACION POR SUCURSAL EN UN RANGO DE FECHAS(MILES)"); $mFile = $x->Chart3DBAR(20000); open_flash_chart_object(768, 512, $mFile, true, "../"); echo getRawFooter(); ?> </body> </html>