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);