$content = generate_content($pdf, $p_version_id, $work_packages, $no_work_package_bug_ids, false, false);
$pdf = $content[0];
$chapter_counter = $content[1];
if ($type_options[1] == '1') {
$pdf->SetFont('Arial', 'B', 12);
$pdf->SetFillColor(255, 255, 255);
$pdf->Cell(95, 6, $chapter_counter . ' ' . utf8_decode(plugin_lang_get('editor_expenses_overview')), 0, 0, 'L', 1);
$pdf->Cell(95, 6, $pdf->PageNo(), 0, 0, 'R', 1);
$pdf->SetFont('Arial', '', 12);
$pdf->Ln();
}
$pdf->Cell(0, 0, '', 'T');
$pdf->Ln(20);
}
/** print core */
$content = generate_content($pdf, $p_version_id, $work_packages, $no_work_package_bug_ids, $type_options[0], true);
$pdf = $content[0];
$chapter_counter = $content[1];
$pdf->Ln(20);
/** print expeneses overview */
if ($type_options[1] == '1') {
$pdf->Title($chapter_counter . ' ' . utf8_decode(plugin_lang_get('editor_expenses_overview')));
$pdf = generate_expenses_overview($pdf, $p_version_id, $work_packages, $no_work_package_bug_ids);
}
/** generate pdf */
$pdf->Output();
}
/**
* Print table body from directory
*
* @param $pdf
$user_link = '<a href="' . rss_append_sid("$board_url/memberlist.$phpEx", "mode=viewprofile&u=" . $user_data[$row[$row_creator]]['user_id']) . '">' . $user_data[$row[$row_creator]]['username'] . '</a>';
$stats = $user->lang['POSTED'] . ' ' . $user->lang['POST_BY_AUTHOR'] . ' ' . $user_link . ' • ' . $user->lang['POSTED_ON_DATE'] . ' ' . $user->format_date($row['topic_time']). ' • ' . $user->lang['REPLIES'] . ' ' . $row['topic_replies'] . ' • ' . $user->lang['VIEWS'] . ' ' . $row['topic_views'];
break;
}
// Does post have an attachment? If so, add it to the list
$attach_list = array();
if (isset($row['post_attachment']) && $row['post_attachment'] && $config['rss_allow_attachments'])
{
$attach_list[] = $row['post_id'];
}
$template->assign_block_vars('items', array(
'TITLE' => ( $row[$row_title] ) ? $row[$row_title] : $row[$row_title2],
'LINK' => htmlspecialchars($item_link),
'DESCRIPTION' => ( $row_text != '' && $show_text) ? generate_content($row[$row_text], $row[$row_uid], $row[$row_bit], $attach_list, $row['post_id'], $row['forum_id']) : '',
'STATISTICS' => ( !$config['rss_items_statistics'] ) ? '' : $user->lang['STATISTICS'] . ' : ' . $stats,
'PUBDATE' => ( !$config['rss_items_statistics'] ) ? '' : date2822(false, $row[$row_date]),
'CATEGORY' => ( !$config['rss_items_statistics'] ) ? '' : "$board_url/viewforum.$phpEx?f={$row['forum_id']}",
'CATEGORY_NAME' => ( !$config['rss_items_statistics'] ) ? '' : utf8_htmlspecialchars($row['forum_name']),
'AUTHOR' => ( !$config['rss_items_statistics'] ) ? '' : ( ($user_data[$row[$row_creator]]['user_allow_viewemail']) ? $user_data[$row[$row_creator]]['user_email'] : $config['board_email'] ) . ' (' . $user_data[$row[$row_creator]]['username'] . ')',
'GUID' => htmlspecialchars($item_link),
));
unset($attach_list);
}
// Set custom template for styles area
$template->set_custom_template($phpbb_root_path . 'styles', 'rss');
// the rss template is never stored in the database
add_field($section, 'dow', $row, array('Monday Ind1', 'Tuesday Ind1', 'Wednesday Ind1', 'Thursday Ind1', 'Friday Ind1', 'Saturday Ind1', 'Sunday Ind1'));
$section->room_id = $room_key;
$section_key = array_search($section, $section_table);
if ($section_key === false) {
$section_key = count($section_table);
$section_table[] = $section;
}
// student_section
$student_section = new stdClass();
$student_section->student_id = $student_key;
$student_section->section_id = $section_key;
if (!in_array($student_section, $student_section_table)) {
$student_section_table[] = $student_section;
}
}
fclose($csvfile);
unset($professor_table[0]);
unset($course_table[0]);
unset($section_table[0]);
unset($building_table[0]);
unset($room_table[0]);
// generate SQL and write it to stdout
fwrite(STDOUT, "USE banner;\n");
generate_content('student', $student_table, $student_types, 'id');
generate_content('professor', $professor_table, $professor_types, 'id');
generate_content('course', $course_table, $course_types, 'id');
generate_content('section', $section_table, $section_types, 'id');
generate_content('building', $building_table, $building_types, 'id');
generate_content('room', $room_table, $room_types, 'id');
generate_content('student_section', $student_section_table, $student_section_types, array('student_id', 'section_id'), false);
