etraxis / etraxis-obsolete

// generate project selector

if ($form == 'projectform')

{

    $xml .= '<control name="project" required="' . get_html_resource(RES_REQUIRED3_ID) . '">'

          . '<label>' . get_html_resource(RES_PROJECT_ID) . '</label>'

          . '<combobox>';

    $rs = dal_query(DATABASE_DRIVER == DRIVER_ORACLE9 ? 'reminders/oracle/plist.sql' : 'reminders/plist.sql',

                    $_SESSION[VAR_USERID]);

    if ($rs->rows == 1)

    {

        debug_write_log(DEBUG_NOTICE, 'One project only is found.');

    }

    while (($row = $rs->fetch()))

    {

        $xml .= '<listitem value="' . $row['project_id'] . '">'

              . ustr2html($row['project_name'])

              . '</listitem>';

    }

    $xml .= '</combobox>'

          . '</control>';

}

elseif (isset($project_id))

{

    $xml .= '<control name="project" required="' . get_html_resource(RES_REQUIRED3_ID) . '">'

          . '<label>' . get_html_resource(RES_PROJECT_ID) . '</label>'

          . '<combobox>'

          . '<listitem value="' . $project_id . '">' . ustr2html($project_name) . '</listitem>'

          . '</combobox>'

          . '</control>';

}

// generate template selector

// generate template selector

if ($form == 'templateform')

{

    $xml .= '<control name="template" required="' . get_html_resource(RES_REQUIRED3_ID) . '">'

          . '<label>' . get_html_resource(RES_TEMPLATE_ID) . '</label>'

          . '<combobox>';

    $rs = dal_query(DATABASE_DRIVER == DRIVER_ORACLE9 ? 'reminders/oracle/tlist.sql' : 'reminders/tlist.sql',

                    $_SESSION[VAR_USERID],

                    $project_id);

    if ($rs->rows == 1)

    {

        debug_write_log(DEBUG_NOTICE, 'One template only is found.');

    }

    while (($row = $rs->fetch()))

    {

        $xml .= '<listitem value="' . $row['template_id'] . '">'

              . ustr2html($row['template_name'])

              . '</listitem>';

    }

    $xml .= '</combobox>'

          . '</control>';

}

elseif (isset($template_id))

{

    $xml .= '<control name="template" required="' . get_html_resource(RES_REQUIRED3_ID) . '">'

          . '<label>' . get_html_resource(RES_TEMPLATE_ID) . '</label>'

          . '<combobox>'

          . '<listitem value="' . $template_id . '">' . ustr2html($template_name) . '</listitem>'

          . '</combobox>'

          . '</control>';

}

// generate other reminder attributes