include_once "lib/class.php";
if ($_GET['fun'] == 'creadoc') {
require_once 'lib/clsMsDocGenerator.php';
require_once "lib/db_mysql.php";
$db = new db_local();
//ANNO CORRENTE
//$db->query("SELECT anagrafiche.id as 'resp',nome,cognome,tel1,email,gite.*,UNIX_TIMESTAMP(dataeora) as 'data' FROM anagrafiche, gite WHERE YEAR(dataeora) = ".date("Y")." AND anagrafiche.id = gite.idresp AND approvata = 1 ORDER BY dataeora;");
//ANNO CORRENTE e FUTURI
$db->query("SELECT anagrafiche.id as 'resp',nome,cognome,tel1,email,gite.*,UNIX_TIMESTAMP(dataeora) as 'data' FROM anagrafiche, gite WHERE YEAR(dataeora) >= " . date("Y") . " AND anagrafiche.id = gite.idresp AND approvata = 1 ORDER BY dataeora;");
$doc = new clsMsDocGenerator();
//$doc->addParagraph('Elenco gite approvate '.date("Y"), array('text-align' => 'center', 'font-size' => '16pt', 'font-weight' => 'bold'));
$doc->addParagraph('Elenco gite approvate', array('text-align' => 'center', 'font-size' => '16pt', 'font-weight' => 'bold'));
$doc->addParagraph('');
$doc->addParagraph('');
while ($db->next_record()) {
$doc->startTable(array('align' => 'center', 'width' => '10cm'));
//$aligns = array('center','center');
$doc->addParagraph($giorni[date("w", $db->record['data'])] . " " . substr($db->record['dataeora'], 8, 2) . " " . $mesi[date("n", $db->record['data'])] . " - " . $db->record['titolo'] . "<br><br>", array('font-weight' => 'bold', 'font-size' => '18px', 'font-family' => 'Comic Sans MS', 'width' => '10cm'));
$cols = array();
$strCol = "Itinerario:<br>";
$strCol .= $db->record['itinerario'] . "<br>" . $db->record['descrizione'];
$cols[] = $strCol;
$strCol = "<br>";
if ($db->record['tipogita'] == 'B') {
$strCol .= "Bici";
} elseif ($db->record['tipogita'] == 'BT') {
$strCol .= "Bici + Treno";
} else {
$strCol .= "Vedi Descrizione";
}
$strCol .= "<br>";
}
return $str;
}
$doc = new clsMsDocGenerator();
$format = array('text-align' => 'center', 'font-weight' => 'bold', 'font-size' => '18pt', 'color' => 'blue');
$doc->addParagraph('<img src="../file/bk_hcm.gif"/>Truong Dai hoc Bach Khoa Tp. Ho Chi Minh', $format);
$format = array('text-align' => 'center', 'font-weight' => 'bold', 'font-size' => '18pt', 'color' => 'blue');
$doc->addParagraph('BANG DIEM SINH VIEN', $format);
$format = array('text-align' => 'center', 'font-weight' => 'bold', 'font-size' => '20pt', 'color' => 'red');
$doc->addParagraph(vnstr($r['student_name']) . '-' . $r['student_id'], $format);
foreach ($term_result as $term_result_) {
$doc->newPage();
$format = array('font-weight' => 'bold', 'font-size' => '15pt', 'color' => 'grey');
$name = 'HK ' . substr($term_result_['ten_hk'], -1, 1) . ' Nam hoc ' . substr($term_result_['ten_hk'], 0, 4) . '-' . substr($term_result_['ten_hk'], 4, 4);
$doc->addParagraph($name, $format);
$doc->startTable();
$format = array('font-weight' => 'bold', 'font-size' => '15pt', 'color' => 'grey', 'background-color' => '#800000', 'FontFamily' => 'Times New Roman', 'width' => '200pt');
$tieude = array('Ma MH', 'Ten MH', 'So TC', 'Kiem tra', 'Thi', 'TB');
$aligns = array('center', 'center', 'center', 'center', 'center', 'center');
$valigns = array('middle', 'middle', 'center', 'center', 'center', 'center');
$doc->addTableRow($tieude, $aligns, $valigns, $format);
foreach ($term_result_['detail'] as $term_result__) {
$format = array('font-size' => '13pt', 'color' => 'grey');
$cols = array();
$cols[0] = $term_result__['subject_id'];
$cols[1] = vnstr($term_result__['subject_name']);
$cols[2] = $term_result__['credit'];
$cols[3] = $term_result__['mid_term'] == null ? '---' : $term_result__['mid_term'];
$cols[4] = $term_result__['end_term'] == null ? '---' : $term_result__['end_term'];
$cols[5] = $term_result__['avg'] == null ? '---' : $term_result__['avg'];
$doc->addTableRow($cols, $aligns, $valigns, $format);
