Esempi in PHP per db_retrieve_agreements_data

Esempio n. 1

File: agreements.php Progetto: TIS-FMDP/Erasmus

function process_agreements()
{
    print '<b>Bilateral Agreements</b><br /><br />';
    if (isset($_GET['act'])) {
        if ($_POST['Edit'] === 'edit') {
            $agg = db_retrieve_agreements_data();
            edit_agreement($agg);
        } else {
            if ($_POST['Add'] === 'add') {
                add_agreement();
            } else {
                if ($_POST['Save'] === 'save') {
                    save_agreement();
                } else {
                    if ($_POST['Remove'] === 'remove') {
                        $agg = db_retrieve_agreements_data();
                        remove_record($agg);
                    } else {
                        if ($_POST['Remove'] === 'yes') {
                            yes_remove_agreement();
                        } else {
                            if (isset($_POST['upload10'])) {
                                upload_file_and_edit_agreement();
                            } else {
                                if ($_POST['DeleteFile'] === 'yes') {
                                    yes_delete_file_and_edit_agreement();
                                } else {
                                    if ($_POST['DeleteFile'] === 'no') {
                                        no_delete_file_and_edit_agreement();
                                    } else {
                                        foreach ($_POST as $var => $val) {
                                            if (strncmp($var, 'deletefile', 10) === 0) {
                                                delete_file_and_edit_agreement($var);
                                                break;
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }
    $columns = array('ID', 'University (country, code)', 'Valid FROM (YYYY/YYYY)', 'Valid TO (YYYY/YYYY)', 'Coordinator', 'Subject Area', 'Accepted levels', '# of students', 'Files');
    $agg = db_retrieve_agreements_data();
    $fagg = format_agreements_data($agg);
    show_table($columns, $fagg);
}

Esempio n. 2

File: travels.php Progetto: TIS-FMDP/Erasmus

function addedit_travel($tv)
{
    $column_labels = array('ID', 'Level', 'Agreement', 'Date FROM (Y-m-d)', 'Date TO (Y-m-d)', 'Student', 'Study program', 'Semester', 'Language:', 'Has level', 'Expected level', 'Soc.stip.', 'Handicap', 'Files', 'Courses', 'Notes', 'Cancelled', 'Year');
    $column_types = array('RDONLY', '*', '*', 'date', 'date', '*', '*', '*', '*', 'text', 'text', 'checkbox', 'checkbox', 'files', 'RDONLY', '100text', 'checkbox', '*');
    $aggr = db_retrieve_agreements_data(TRUE);
    $stds = db_students(TRUE);
    $sps = db_study_programs(TRUE);
    $langs = db_languages();
    //$cors = db_courses_for_an_exchange($tv[0]);
    $levels = array(array(1, "Bachelor"), array(2, "Master"), array(3, "Doctoral"));
    $years = selection_of_years();
    show_edit_form($column_labels, $tv, $column_types, array($levels, $aggr, $stds, $sps, array(array('W', 'winter'), array('S', 'summer')), $langs, $years));
}