url = "http://infoapp2.infocentro.gob.ve"; // $notific->message = "La planificación de la actividad:\n Hola"; // $notific->sendTelegram(); ?>

Filtrar planificación

" class="form-control">
UID " class="form-control">
Código info " class="form-control">
Estado
Linea de acción
Desde
" class="form-control">
Hasta
" class="form-control">
prepare("SELECT * FROM infocentros WHERE upper(cod)='$code_info'"); $row->execute(); $data = $row->fetchAll(PDO::FETCH_ASSOC)[0]; $info_id = isset($data["id"]) ? $data["id"] : "0"; } $CantidadMostrar = 30; $url_pag_atras = ""; $url_pag_adelante = ""; // Validado la variable GET $compag = (int)(!isset($_GET['pag']) || $_GET['pag'] == "") ? 1 : $_GET['pag']; $user_region = $_SESSION['user_region']; $user_id = $_SESSION['user_id']; $date_ini = date_create($start_at_q); $date_end = date_create($finish_at_q); $start_at = $date_ini->format('Y-m-d'); $finish_at = $date_end->format('Y-m-d'); // $start_at = $_GET["start_at"]; // $finish_at = $_GET["finish_at"]; // echo $start_at ; // echo $finish_at ; // echo $_GET["start_at"] ; $users = array(); if ((isset($_GET["q"]) || isset($_GET["estado"]) || isset($_GET["start_at"]) || isset($_GET["finish_at"]) || isset($_GET["uid"]) || isset($_GET["linea_accion"]) || isset($_GET["info_id"])) && ($q != "" || $_GET["estado"] != "" || $_GET["start_at"] != "" || $_GET["finish_at"] != "" || $uid_q != "" || $linea_accion_q != "" || $_GET["info_id"] != "")) { $sql = "SELECT * from reports where is_active='1' AND status_activity='0' AND "; $sql_dow = "SELECT * from reports where is_active='1' AND status_activity='0' AND "; if ($q != "") { $sql .= " (report_type like '%$q%' or activity_title like '%$q%' or line_action like '%$q%' or estate like '%$q%' or code_info='$q' or responsible_dni='$q') "; $sql_dow .= " (report_type like '%$q%' or activity_title like '%$q%' or line_action like '%$q%' or estate like '%$q%' or code_info='$q' or responsible_dni='$q') "; } if ($uid_q != "") { if ($q != "") { $sql .= ' and '; $sql_dow .= ' and '; } $sql .= " user_id='" . $uid_q . "'"; $sql_dow .= " user_id='" . $uid_q . "'"; } if ($code_info != "") { if ($_GET["q"] != "" || $_GET["uid"] != "") { $sql .= ' and '; $sql_dow .= ' and '; } $sql .= " reports.info_id='" . $info_id . "'"; $sql_dow .= " reports.info_id='" . $info_id . "'"; } if ($linea_accion_q != "") { if ($q != "" or $uid_q != "" or $code_info != "") { $sql .= ' and '; $sql_dow .= ' and '; } if ($_GET["linea_accion"] == "Participación digital" || $_GET["linea_accion"] == "Comunidades de participación digital") { $sql .= " (reports.line_action='Medios digitales' or reports.line_action='Tejiendo redes' or reports.line_action='Infocentro adentro' or reports.line_action='Sistematización de Experiencias' or reports.line_action='" . $_GET["linea_accion"] . "')"; $sql_dow .= " (reports.line_action='Medios digitales' or reports.line_action='Tejiendo redes' or reports.line_action='Infocentro adentro' or reports.line_action='Sistematización de Experiencias' or reports.line_action='" . $_GET["linea_accion"] . "')"; } else if ($_GET["linea_accion"] == "Comunidades de aprendizaje") { $sql .= " (reports.line_action='Formación a la medida' or reports.line_action='" . $_GET["linea_accion"] . "')"; $sql_dow .= " (reports.line_action='Formación a la medida' or reports.line_action='" . $_GET["linea_accion"] . "')"; } else if ($_GET["linea_accion"] == "Medios digitales") { $sql .= " (reports.line_action='Tejiendo redes' or reports.line_action='" . $_GET["linea_accion"] . "')"; $sql_dow .= " (reports.line_action='Tejiendo redes' or reports.line_action='" . $_GET["linea_accion"] . "')"; } else if ($_GET["linea_accion"] == "Acceso abierto") { $sql .= " (reports.line_action='Unidades socio-productivas' or reports.line_action='" . $_GET["linea_accion"] . "')"; $sql_dow .= " (reports.line_action='Unidades socio-productivas' or reports.line_action='" . $_GET["linea_accion"] . "')"; } else { $sql .= " (reports.line_action='" . $_GET["linea_accion"] . "')"; $sql_dow .= " (reports.line_action='" . $_GET["linea_accion"] . "')"; } // $sql .= " line_action='".$linea_accion_q."'"; // $sql_dow .= " line_action='".$linea_accion_q."'"; } if ($estado_q != "") { if ($_GET["q"] != "" or $uid_q != "" or $linea_accion_q != "" or $code_info != "") { $sql .= ' and '; $sql_dow .= ' and '; } $sql .= " estate='" . $estado_q . "'"; $sql_dow .= " estate='" . $estado_q . "'"; } if ($_GET["start_at"] != "" and $_GET["finish_at"] != "") { if ($_GET["q"] != "" or $linea_accion_q != "" or $_GET["estado"] != "" or $_GET["uid"] != "" or $code_info != "") { $sql .= " and "; $sql_dow .= " and "; } // $sql .= " date_ini >= TO_DATE('" . $start_at . "', 'DD-MM-YYYY') and date_ini <= TO_DATE('" . $finish_at . "', 'DD-MM-YYYY')"; // $sql_dow .= " date_ini >= TO_DATE('" . $start_at . "', 'DD-MM-YYYY') and date_ini <= TO_DATE('" . $finish_at . "', 'DD-MM-YYYY')"; $sql .= " date_ini BETWEEN '" . $start_at . "' and '" . $finish_at . "'"; $sql_dow .= " date_ini BETWEEN '" . $start_at . "' and '" . $finish_at . "'"; } if ($_GET["start_at"] != "" and $_GET["finish_at"] == "") { if ($_GET["q"] != "" or $linea_accion_q != "" or $_GET["estado"] != "" or $_GET["uid"] != "" or $code_info != "") { $sql .= ' and '; $sql_dow .= ' and '; } // $sql .= " date_ini >= TO_DATE('" . $start_at . "', 'DD-MM-YYYY')"; // $sql_dow .= " date_ini >= TO_DATE('" . $start_at . "', 'DD-MM-YYYY')"; $sql .= " date_ini >= '" . $start_at . "'"; $sql_dow .= " date_ini >= '" . $start_at . "'"; } if ($_SESSION["user_type"] == 4 || $_SESSION["user_type"] == 5 || $_SESSION["user_type"] == 6 || $_SESSION["user_type"] == 7 || $_SESSION["user_type"] == 9 || $_SESSION["user_type"] == 10) { $param = $sql; } else if ($_SESSION["user_type"] == 3 || $_SESSION["user_type"] == 8) { $param = $sql . " and estate='" . $user_region . "' "; $sql_dow = $sql_dow . " and estate='" . $user_region . "' "; } else { $param = $sql . " and user_id='" . $user_id . "' "; $sql_dow = $sql_dow . " and user_id='" . $user_id . "' "; } $conn = DatabasePg::connectPg(); // $sql .= " AND"; // $sql .= " reports.is_active='1' AND reports.status_activity='1' AND reports.estate!=''"; // $sql .= " AND reports.date_ini between '2024-01-01' and '2024-12-31'"; // $sql .= " group by " . $fields; // $sql .= " order by reports.datetime desc"; // $sql_dw .= $sql; $stmt = $conn->prepare($param); $stmt->execute(); $TotalReg = $stmt->rowCount(); $param .= " order by date_ini desc LIMIT " . $CantidadMostrar . " OFFSET " . (($compag - 1) * $CantidadMostrar); $sql_dow .= " order by date_ini desc"; $stmt = $conn->prepare($param); $stmt->execute(); $data = $stmt->fetchAll(PDO::FETCH_ASSOC); $users = $data; // $total = ReportActivityData::getBySQL($param); // $TotalReg = count($total); // $users = ReportActivityData::getBySQL($param . " order by date_pub asc LIMIT " . (($compag - 1) * $CantidadMostrar) . " , " . $CantidadMostrar); // Asigna url de paginacion $url_pag = "prepare($sql); $stmt->execute(); $TotalReg = $stmt->rowCount(); $sql .= " LIMIT " . $CantidadMostrar . " OFFSET " . (($compag - 1) * $CantidadMostrar); $stmt = $conn->prepare($sql); $stmt->execute(); $data = $stmt->fetchAll(PDO::FETCH_ASSOC); $users = $data; // $users = ReportActivityData::getBySQL($sql); // $TotalReg = 0; $url_pag = " 0) { $TotalRegistro = ceil($TotalReg / $CantidadMostrar); } $DB_name = "reporte_planif"; // echo $param_csv; ?>
Programar actividad

0) { ?>
Programar actividad CSV XLSX 0) { ?>
Hay " . $TotalReg . " Registros . La cantidad se dividió a " . $TotalRegistro . " páginas para mostrar de " . $CantidadMostrar . " en " . $CantidadMostrar . "" . "

"; ?>
SELECCIONE'; $specific = ($user["specific_action"] != '') ? $user["specific_action"] : 'SELECCIONE'; $training = ($user["training_type"] != '') ? $user["training_type"] : '-'; $taller = ($user["tipo_taller"] != '') ? $user["tipo_taller"] : 'Tipo de taller'; if ($user["specific_action"] == "Formación en habilidades digitales") { $data_activity = $planning_line_action . " % " . $type . " % " . $specific . " % " . $training . " % " . $taller; } else { $data_activity = $planning_line_action . " % " . $type . " % " . $specific . " % " . $training; } // admin_edit a otros if ($_SESSION["user_id"] == $user["user_id"]) { $admin_edit = 1; } else if ($_SESSION["user_id"] != $user["user_id"] && ($_SESSION["user_type"] == 4 || $_SESSION["user_type"] == 5 || $_SESSION["user_type"] == 6 || $_SESSION["user_type"] == 7 || $_SESSION["user_type"] == 8 || $_SESSION["user_type"] == 9)) { $admin_edit = 1; } else { $admin_edit = 0; } // sacamos la fecha de inicio $date_pub_end = explode("/", $user["date_pub"]); if (count($date_pub_end) > 1) { $date_pub = date("d/m/Y", strtotime($date_pub_end[0])) . " - " . date("d/m/Y", strtotime($date_pub_end[1])); } else { $date_pub = date("d/m/Y", strtotime($user["date_pub"])); } ?> '; ?> '; ?> '; ?> '; ?> '; ?> '; ?> '; } ?> > " . $taller; ?> > " . $taller; ?>

Fecha de actividad Infocentro Estado Línea de acción Título de la actividad Acciones
PERSONAL
 &id=&code_info=&estado=&participantes=&start_at=&finish_at=&pag=" type="button" rel="tooltip" class="btn btn-warning btn-sm"> &id=&code_info=&estado=&participantes=&start_at=&finish_at=&pag=" type="button" rel="tooltip" class="btn btn-warning btn-sm"> &id=&code_info=&estado=&participantes=&start_at=&finish_at=&pag=" type="button" rel="tooltip" class="btn btn-warning btn-sm"> &id=&code_info=&estado=&participantes=&start_at=&finish_at=&pag=" type="button" rel="tooltip" class="btn btn-warning btn-sm"> &id=&code_info=&estado=&participantes=&start_at=&finish_at=&pag=" type="button" rel="tooltip" class="btn btn-warning btn-sm">
No hay reportes

"; $total_fem = 0; $total_mas = 0; } ?>
0) { ?>
"; //Se resta y suma con el numero de pag actual con el cantidad de //numeros a mostrar $Desde = $compag - (ceil($CantidadMostrar / 2) - 1); $Hasta = $compag + (ceil($CantidadMostrar / 2) - 1); //Se valida $Desde = ($Desde < 1) ? 1 : $Desde; $Hasta = ($Hasta < $CantidadMostrar) ? $CantidadMostrar : $Hasta; //Se muestra los numeros de paginas for ($i = $Desde; $i <= $Hasta; $i++) { //Se valida la paginacion total //de registros if ($i <= $TotalRegistro) { //Validamos la pag activo if ($i == $compag) { echo $url_pag . $i . "\" class=\"btn btn-primary btn-sm\"active\">" . $i . " "; } else { echo $url_pag . $i . "\" class=\"btn btn-info btn-sm\">" . $i . " "; } } } // echo " "; echo $url_pag . $IncrimentNum . "\" class=\"btn btn-info btn-sm\"> "; ?>