PHP sak_display_list примеры использования

Пример #1

Файл: report_tesis_director.php Проект: sergiokessler/perio

<?php

include_once 'header.php';
include_once 'share/data_display.php';
$sql = <<<END
    select 
        director,
        estado, 
        count(*) as cantidad
    from 
        tesis
    group by
        director,
        estado
END;
unset($params_list);
$params_list['sql_list'] = $sql;
$params_list['sql_data'] = array();
$params_list['primary_key'] = '';
echo sak_display_list($params_list);
include_once 'footer.php';

Пример #2

Файл: alumno.php Проект: sergiokessler/perio

require_once 'share/field_mapping.php';
//unset($params);
$params['table'] = 'alumno';
$params['sql_list'] = <<<END
    select
        *
    from
        alumno
END;
$params['sql_where'] = '';
$params['sql_order'] = ' order by nombre ';
$params['sql_data'] = null;
$params['primary_key'] = 'id';
$params['link_view']['field_name'] = 'id';
$params['link_view']['action'] = $params['table'] . '_select';
$field_meta['search']['legajo'] = 'Legajo';
$field_meta['search']['doc_nro'] = 'Nro Doc';
$field_meta['search']['nombre'] = 'Nombre';
include_once 'header.php';
echo sak_search_form($params, $field_meta);
$insert_title = 'Agregar un alumno nuevo';
$insert_url = 'index.php?action=' . $params['table'] . '_insert';
echo "<a href=\"{$insert_url}\">{$insert_title}</a>";
echo '<br>';
echo '<br>';
$buscar = (bool) isset($_REQUEST['btnSubmit']) && $_REQUEST['btnSubmit'] == 'Buscar';
if ($buscar) {
    $params = sak_search_form_process($params);
    echo sak_display_list($params, $field_mapping['tpm']);
}
include_once 'footer.php';

Пример #3

Файл: report_by_date.php Проект: sergiokessler/perio

$params1['sql_data'] = null;
$params1['enable_export'] = true;
$params2['sql_full'] = <<<END
    select
        fecha_hora::date as fecha,
        count(*) as cantidad
    from
        inscripcion
    group by
        fecha_hora::date
    order by
        fecha
END;
$params2['sql_data'] = null;
// <query>
// <UI>
include_once 'header.php';
if (isset($params['msg'])) {
    echo $params['msg'];
}
echo '<br>';
echo 'Cantidad de alumnos con inscripcion por dia:';
echo '<br>';
echo sak_display_list($params1);
echo '<br>';
echo '<br>';
echo 'Cantidad de inscripciones por dia:';
echo '<br>';
echo sak_display_list($params2);
echo '<br>';
include_once 'footer.php';

Пример #4

Файл: inscripcion_insert.php Проект: sergiokessler/perio

            break;
        } else {
            $msg = "El registro a sido cargado satisfactoriamente.";
        }
    }
    unset($params_cont);
    $params_cont['msg'] = $msg;
    $params_cont = params_encode($params_cont);
    $continue = 'action=' . $params['table'] . '&params=' . $params_cont;
    return;
}
// <UI>
include_once 'header.php';
if (isset($params['msg'])) {
    echo $params['msg'];
}
echo '<br>';
$params_alumno['sql_list'] = 'select * from alumno';
$params_alumno['sql_where'] = ' where id = ?';
$params_alumno['sql_order'] = '';
$params_alumno['sql_data'] = $_SESSION['alumno_id'];
echo sak_display_list($params_alumno);
echo '<br>';
$form->display();
echo '<br>';
if (isset($materia_id)) {
    echo '<hr width="60%">';
    echo $msg_comis;
    $form_comis->display();
}
include_once 'footer.php';