<?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; }