<?php
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";
* @copyright 2011
*/
include 'baseClassExport.php';
require_once 'clsMsDocGenerator.php';
//var_dump($term_result);
function vnstr($str)
{
$unicode = array('a' => 'á|à|ả|ã|ạ|ă|ắ|ặ|ằ|ẳ|ẵ|â|ấ|ầ|ẩ|ẫ|ậ', 'd' => 'đ', 'e' => 'é|è|ẻ|ẽ|ẹ|ê|ế|ề|ể|ễ|ệ', 'i' => 'í|ì|ỉ|ĩ|ị', 'o' => 'ó|ò|ỏ|õ|ọ|ô|ố|ồ|ổ|ỗ|ộ|ơ|ớ|ờ|ở|ỡ|ợ', 'u' => 'ú|ù|ủ|ũ|ụ|ư|ứ|ừ|ử|ữ|ự', 'y' => 'ý|ỳ|ỷ|ỹ|ỵ', 'A' => 'Á|À|Ả|Ã|Ạ|Ă|Ắ|Ặ|Ằ|Ẳ|Ẵ|Â|Ấ|Ầ|Ẩ|Ẫ|Ậ', 'D' => 'Đ', 'E' => 'É|È|Ẻ|Ẽ|Ẹ|Ê|Ế|Ề|Ể|Ễ|Ệ', 'I' => 'Í|Ì|Ỉ|Ĩ|Ị', 'O' => 'Ó|Ò|Ỏ|Õ|Ọ|Ô|Ố|Ồ|Ổ|Ỗ|Ộ|Ơ|Ớ|Ờ|Ở|Ỡ|Ợ', 'U' => 'Ú|Ù|Ủ|Ũ|Ụ|Ư|Ứ|Ừ|Ử|Ữ|Ự', 'Y' => 'Ý|Ỳ|Ỷ|Ỹ|Ỵ');
foreach ($unicode as $nonUnicode => $uni) {
$str = preg_replace("/({$uni})/i", $nonUnicode, $str);
}
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);
public function export()
{
$map['id'] = array('in', $_REQUEST['id']);
$orders = $this->dao->where($map)->select();
Vendor('MsDocGenerator');
$doc = new clsMsDocGenerator();
$doc->addParagraph('网站订单', array('text-align' => '"center"', 'font-size' => '16pt', 'font-weight' => 'bold'));
$i = 0;
$count = count($orders);
$this->assign('all_count', $count);
foreach ($orders as $o) {
$this->assign('i', $i);
$_GET['id'] = $o['id'];
$this->orders();
$doc->addParagraph($this->fetch('Orders-word'));
$i++;
$doc->addParagraph("<br clear=all style='page-break-before:always;' />");
}
$doc->output('订单列表');
}
function executeExportword()
{
global $controller, $ClassDir, $UploadDir;
require_once $ClassDir . 'MsDocGenerator.class.php';
$doc = new clsMsDocGenerator();
$apf_contact = DB_DataObject::factory('ApfContact');
$apf_contact->get($apf_contact->escape($controller->getID()));
$doc->setDocumentCharset("gbk");
$doc->setDocumentLang("setDocumentLang");
$doc->addParagraph($apf_contact->getName());
$apf_contact->getPhoto() ? $doc->addParagraph($doc->addImage($UploadDir . $apf_contact->getPhoto(), 80, 80)) : "";
$filename = date("Y_m_d") . $apf_contact->getName() . ".doc";
$doc->output($filename);
exit;
}
