/**
* Get instance of SqlSelect to build a select statement
*
* @return SqlSelect
* @throws Exception
*/
public function select()
{
if ($this->name == null) {
throw new Exception('not specified table name.');
}
Loader::load('SqlSelect', 'db');
$select = new SqlSelect($this->db, $this->name, $this->alias);
if ($this->schema != null) {
$select->setSchema($this->schema);
}
return $select;
}
echo implode('/', $siglas);
?>
<table border="1" width="100%" cellspacing="0" cellpadding="0" class="tab" align="center" bgcolor="#FFFFFF">
<tr><th >Tarea</th><th >Unidad de Medida</th>
<?php
$ord_anp = array();
$sql = "SELECT anp.siglas_anp,anp.id_anp FROM anp Inner Join categoria ON anp.id_categoria = categoria.id_categoria\r\n\t\t\tWHERE anp.id_anp IN (" . $anps . ") ORDER BY anp.id_anp";
$Q = new Consulta($sql);
while ($row = $Q->ConsultaVerRegistro()) {
echo "<th align='right'>" . $row[0] . "</th>";
$ord_anp[] = $row[1];
}
?>
</tr>
<?php
$obj = new SqlSelect('', $_SESSION["inrena_4"][2], $_SESSION["inrena_4"][1]);
$sql = $obj->set_sql(" nombre_tarea,t.id_tarea,medio_verificacion_tarea ", " AND pa.id_anp IN (" . $anps . ")", " t.id_tarea", " t.nombre_tarea");
$Qtarea = new Consulta($sql);
while ($rowt = $Qtarea->ConsultaVerRegistro()) {
$fila_tarea = "<tr><td width='200'>" . $rowt[0] . "</td><td width='200'>" . $rowt[2] . "</td>";
$monto_fila = 0;
foreach ($ord_anp as $anp) {
$sql_m = "SELECT sum(cantidad_metas_meses)\r\n\t\t\t\tFROM metas_meses mm \r\n\t\t\t\t\tInner Join asignacion_ff_anp_objetivos AS afao \r\n\t\t\t\t\t\tON afao.id_asignacion_ff_anp_objetivos=mm.id_ff_anp_subactividad\r\n\t\t\t\t\tInner Join asignacion_anp_objetivos aao \r\n\t\t\t\t\t\tON aao.id_asignacion_anp_objetivos = afao.id_asignacion_anp_objetivos\r\n\t\t\t\t\tInner Join presupuesto_anp as pa ON pa.id_presupuesto_anp = afao.id_presupuesto_anp \r\n\t\t\t\t\tInner Join presupuesto_ff as pf ON pf.id_presupuesto_ff = pa.id_presupuesto_ff\r\n\t\t\t\t\tInner Join fuente_financiamiento as ff ON ff.id_ff = pf.id_ff \r\n\t\t\t\tWHERE pf.id_axo_poa = '" . $_SESSION["inrena_4"][2] . "' AND id_tarea='" . $rowt[1] . "' AND pa.id_anp={$anp} \r\n\t\t\t\t\tAND pf.id_ff IN (" . $ff . ") " . permisos_fuente($_SESSION['inrena_4'][1]) . " GROUP BY pa.id_anp";
//die($sql_m);
$Qm = new Consulta($sql_m);
$monto = $Qm->ConsultaVerRegistro();
if ($monto[0] > 0) {
$fila_tarea .= "<td align='right'>" . num_format($monto[0]) . "</td>";
$monto_fila += $monto[0];
} else {
$fila_tarea .= "<td align='right'> </td>";
echo "<option value='{$idanp['2']}' {$estado} >{$idanp['0']} {$idanp['1']}</option>";
$n = 1;
}
?>
</select><br />
<?php
if ($n == 0) {
echo "<font color='ff0000'><strong>\r\n\t\t\t\t\tNo hay ANPs con Asiganaciones este Año</strong>\r\n\t\t\t\t\t</font>";
}
?>
</td>
</tr>
<tr><td align='center'>
<?php
if ($_POST[anp]) {
$obj = new SqlSelect($_POST[anp], $_SESSION["inrena_4"][2], $_SESSION["inrena_4"][1]);
$sqlff = $obj->set_sql("ff.id_fuentefinanciamiento,ff.id_ff,ff.siglas_ff", " ", "ff.id_ff", "ff.id_ff");
$Qff = new Consulta($sqlff);
?>
<br><br><strong>Seleccione Fuente de Financiamiento</strong><br>
<select name='lista_ff[]' size="10" multiple >
<?php
$m = 0;
while ($f_f = $Qff->ConsultaVerRegistro()) {
//$row_ff=table_row($f_f['id_fuentefinanciamiento'],"fuentefinanciamiento");
echo "<option value='" . $f_f[id_ff] . "'>" . $f_f[siglas_ff] . "</option>";
$m = 1;
}
?>
</select><br />
<?php
</font>
</td></tr></table>
<table border="0" width="100%" cellspacing="0" cellpadding="0" class="tab" align="center" bgcolor="#FFFFFF">
<tr><th >Tarea</th>
<?php
$ord_anp = array();
$sql = "SELECT anp.siglas_anp,anp.id_anp FROM anp Inner Join categoria ON anp.id_categoria = categoria.id_categoria\r\n\t\t\tWHERE anp.id_anp IN (" . $anps . ") ORDER BY anp.id_anp";
$Q = new Consulta($sql);
while ($row = $Q->ConsultaVerRegistro()) {
echo "<th align='right'>" . $row[0] . "</th>";
$ord_anp[] = $row[1];
}
?>
</tr>
<?php
$obj = new SqlSelect('', $_SESSION["inrena_4"][2], $_SESSION["inrena_4"][1]);
$sql = $obj->set_sql(" nombre_tarea,t.id_tarea ", " AND pa.id_anp IN (" . $anps . ")", " t.id_tarea", " t.nombre_tarea");
$Qtarea = new Consulta($sql);
while ($rowt = $Qtarea->ConsultaVerRegistro()) {
echo "<tr><td width='200'>" . $rowt[0] . "</td>";
foreach ($ord_anp as $array_anp) {
$sql_m = "SELECT sum(afao.monto_asignacion_ff_anp_objetivos)/{$cambio}\r\n\t\t\t\tFROM asignacion_ff_anp_objetivos AS afao \r\n\t\t\t\t\tInner Join asignacion_anp_objetivos aao \r\n\t\t\t\t\t\tON aao.id_asignacion_anp_objetivos = afao.id_asignacion_anp_objetivos\r\n\t\t\t\t\tInner Join presupuesto_anp as pa ON pa.id_presupuesto_anp = afao.id_presupuesto_anp \r\n\t\t\t\t\tInner Join presupuesto_ff as pf ON pf.id_presupuesto_ff = pa.id_presupuesto_ff\r\n\t\t\t\t\tInner Join fuente_financiamiento as ff ON ff.id_ff = pf.id_ff \r\n\t\t\t\t\tInner Join anp_objetivo_especifico aoesp \r\n\t\t\t\t\t\tON aoesp.id_anp_objetivo_especifico = aao.id_anp_objetivo_especifico \r\n\t\t\t\t\tInner Join tarea as t ON t.id_tarea = aao.id_tarea \r\n\t\t\t\t\tInner Join anp_objetivo_estrategico aoest \r\n\t\t\t\t\t\t\tON aoest.id_anp_objetivo_estrategico = aoesp.id_anp_objetivo_estrategico \r\n\t\t\t\t\tInner Join objetivo_estrategico oe ON oe.id_objetivo_estrategico = aoest.id_objetivo_estrategico \r\n\t\t\t\t\tInner Join anp a ON pa.id_anp = a.id_anp\r\n\t\t\t\t\tInner Join categoria ctg ON a.id_categoria=ctg.id_categoria \r\n\t\t\t\tWHERE pf.id_axo_poa = '" . $_SESSION["inrena_4"][2] . "' AND t.id_tarea='" . $rowt[1] . "' AND pa.id_anp={$array_anp} " . permisos_fuente($_SESSION['inrena_4'][1]) . " GROUP BY a.id_anp ORDER BY a.id_anp";
//die($sql_m);
$Qm = new Consulta($sql_m);
$monto = $Qm->ConsultaVerRegistro();
if ($monto[0] > 0) {
echo "<td align='right'>" . number_format($monto[0], 2, ".", ",") . "</td>";
} else {
echo "<td align='right'> </td>";
}
}
