$DAO = new DocumentoDAO(); $resultado = $DAO->Listar("SELECT a.dat_ata, a.id, ac.assunto, ac.local, ac.destinatario, ac.observacao, a.cod_ata FROM " . MYSQL_BASE_ATAS . " a, " . MYSQL_BASE_ATAS_CONTEUDO . " ac WHERE a.id= ac.id_ata AND a.id = " . $id); foreach ($resultado as $item) { $documento->setDataAta($item['dat_ata']); $documento->setId($item['id']); $documento->setAssunto($item['assunto']); $documento->setLocal($item['local']); $documento->setDestinatario($item['destinatario']); $documento->setObservacao($item['observacao']); $documento->setCodDoc($item['cod_ata']); } // New Word Document // echo date('H:i:s'), ' Create new PhpWord object', EOL; $phpWord = new \PhpOffice\PhpWord\PhpWord(); $header = array('size' => 16, 'bold' => true, 'name' => 'Arial', 'align' => 'center'); $phpWord->addFontStyle('rStyle', array('name' => 'Arial', 'bold' => true)); $phpWord->addParagraphStyle('pStyle', array('align' => 'center')); $section = $phpWord->addSection(); /*Style da tabela*/ $styleTable = array('borderSize' => 6, 'borderColor' => '000000', 'cellMargin' => 10); $styleFirstRow = array('borderBottomSize' => 18, 'borderBottomColor' => '0000FF', 'bgColor' => 'FFFFFF'); $styleCell = array('valign' => 'center'); $styleCellBTLR = array('valign' => 'center', 'textDirection' => \PhpOffice\PhpWord\Style\Cell::TEXT_DIR_BTLR); $fontStyle = array('bold' => true, 'align' => 'center'); $localStyle = array('bold' => true, 'underline' => 'single'); $cellColSpan = array('gridSpan' => 2, 'valign' => 'center'); $phpWord->addTableStyle('Fancy Table', $styleTable, $styleFirstRow); /*Fim - Style da tabela*/ /*Cabe�alho*/ $subsequent = $section->addHeader(); /*Fim - Cabe�alho*/
<?php include_once 'Sample_Header.php'; // New Word document echo date('H:i:s'), ' Create new PhpWord object', EOL; $phpWord = new \PhpOffice\PhpWord\PhpWord(); // Begin code $section = $phpWord->addSection(); // Style definition $phpWord->addFontStyle('myOwnStyle', array('color' => 'FF0000')); $phpWord->addParagraphStyle('P-Style', array('spaceAfter' => 95)); $phpWord->addNumberingStyle('multilevel', array('type' => 'multilevel', 'levels' => array(array('format' => 'decimal', 'text' => '%1.', 'left' => 360, 'hanging' => 360, 'tabPos' => 360), array('format' => 'upperLetter', 'text' => '%2.', 'left' => 720, 'hanging' => 360, 'tabPos' => 720)))); $predefinedMultilevel = array('listType' => \PhpOffice\PhpWord\Style\ListItem::TYPE_NUMBER_NESTED); // Lists $section->addText(htmlspecialchars('Multilevel list.', ENT_COMPAT, 'UTF-8')); $section->addListItem(htmlspecialchars('List Item I', ENT_COMPAT, 'UTF-8'), 0, null, 'multilevel'); $section->addListItem(htmlspecialchars('List Item I.a', ENT_COMPAT, 'UTF-8'), 1, null, 'multilevel'); $section->addListItem(htmlspecialchars('List Item I.b', ENT_COMPAT, 'UTF-8'), 1, null, 'multilevel'); $section->addListItem(htmlspecialchars('List Item II', ENT_COMPAT, 'UTF-8'), 0, null, 'multilevel'); $section->addListItem(htmlspecialchars('List Item II.a', ENT_COMPAT, 'UTF-8'), 1, null, 'multilevel'); $section->addListItem(htmlspecialchars('List Item III', ENT_COMPAT, 'UTF-8'), 0, null, 'multilevel'); $section->addTextBreak(2); $section->addText(htmlspecialchars('Basic simple bulleted list.', ENT_COMPAT, 'UTF-8')); $section->addListItem(htmlspecialchars('List Item 1', ENT_COMPAT, 'UTF-8')); $section->addListItem(htmlspecialchars('List Item 2', ENT_COMPAT, 'UTF-8')); $section->addListItem(htmlspecialchars('List Item 3', ENT_COMPAT, 'UTF-8')); $section->addTextBreak(2); $section->addText(htmlspecialchars('Continue from multilevel list above.', ENT_COMPAT, 'UTF-8')); $section->addListItem(htmlspecialchars('List Item IV', ENT_COMPAT, 'UTF-8'), 0, null, 'multilevel'); $section->addListItem(htmlspecialchars('List Item IV.a', ENT_COMPAT, 'UTF-8'), 1, null, 'multilevel'); $section->addTextBreak(2);
<?php include_once 'Sample_Header.php'; // New Word document echo date('H:i:s'), ' Create new PhpWord object', EOL; $phpWord = new \PhpOffice\PhpWord\PhpWord(); // Define styles $fontStyle24 = array('size' => 24); $paragraphStyle24 = array('spacing' => 240, 'size' => 24); $fontStyleName = 'fontStyle'; $phpWord->addFontStyle($fontStyleName, array('size' => 9)); $paragraphStyleName = 'paragraphStyle'; $phpWord->addParagraphStyle($paragraphStyleName, array('spacing' => 480)); // New section $section = $phpWord->addSection(); $section->addText('Text break with no style:'); $section->addTextBreak(); $section->addText('Text break with defined font style:'); $section->addTextBreak(1, $fontStyleName); $section->addText('Text break with defined paragraph style:'); $section->addTextBreak(1, null, $paragraphStyleName); $section->addText('Text break with inline font style:'); $section->addTextBreak(1, $fontStyle24); $section->addText('Text break with inline paragraph style:'); $section->addTextBreak(1, null, $paragraphStyle24); $section->addText('Done.'); // Save file echo write($phpWord, basename(__FILE__, '.php'), $writers); if (!CLI) { include_once 'Sample_Footer.php'; }
$sectionStyle = array('pageSizeW' => 12240, 'pageSizeH' => 15840, 'marginLeft' => 360, 'marginRight' => 360, 'marginTop' => 360, 'marginBottom' => 360, 'headerHeight' => 0, 'footerHeight' => 0, 'colsNum' => 3, 'colsSpace' => 690, 'breakType' => 'continuous'); } $labelManager->setCollid($collid); $isEditor = 0; if ($symbUid) { if ($isAdmin || array_key_exists("CollAdmin", $userRights) && in_array($collid, $userRights["CollAdmin"]) || array_key_exists("CollEditor", $userRights) && in_array($collid, $userRights["CollEditor"])) { $isEditor = 1; } } if ($isEditor && $action) { $labelArr = $labelManager->getLabelArray($_POST['occid'], $speciesAuthors); } $phpWord = new \PhpOffice\PhpWord\PhpWord(); $phpWord->addParagraphStyle('firstLine', array('lineHeight' => 0.1, 'spaceAfter' => 0, 'keepNext' => true, 'keepLines' => true)); $phpWord->addParagraphStyle('lastLine', array('spaceAfter' => 300, 'lineHeight' => 0.1)); $phpWord->addFontStyle('dividerFont', array('size' => 1)); $phpWord->addParagraphStyle('barcodeonly', array('align' => 'center', 'lineHeight' => 1.0, 'spaceAfter' => 300, 'keepNext' => true, 'keepLines' => true)); $phpWord->addParagraphStyle('lheader', array('align' => 'center', 'lineHeight' => 1.0, 'spaceAfter' => 150, 'keepNext' => true, 'keepLines' => true)); $phpWord->addFontStyle('lheaderFont', array('bold' => true, 'size' => 14, 'name' => 'Arial')); $phpWord->addParagraphStyle('family', array('align' => 'right', 'lineHeight' => 1.0, 'spaceAfter' => 0, 'keepNext' => true, 'keepLines' => true)); $phpWord->addFontStyle('familyFont', array('size' => 10, 'name' => 'Arial')); $phpWord->addParagraphStyle('scientificname', array('align' => 'left', 'lineHeight' => 1.0, 'spaceAfter' => 0, 'keepNext' => true, 'keepLines' => true)); $phpWord->addFontStyle('scientificnameFont', array('bold' => true, 'italic' => true, 'size' => 11, 'name' => 'Arial')); $phpWord->addFontStyle('scientificnameinterFont', array('bold' => true, 'size' => 11, 'name' => 'Arial')); $phpWord->addFontStyle('scientificnameauthFont', array('size' => 11, 'name' => 'Arial')); $phpWord->addParagraphStyle('identified', array('align' => 'left', 'lineHeight' => 1.0, 'spaceAfter' => 0, 'indent' => 0.3125, 'keepNext' => true, 'keepLines' => true)); $phpWord->addFontStyle('identifiedFont', array('size' => 10, 'name' => 'Arial')); $phpWord->addParagraphStyle('loc1', array('spaceBefore' => 150, 'lineHeight' => 1.0, 'spaceAfter' => 0, 'align' => 'left', 'keepNext' => true, 'keepLines' => true)); $phpWord->addFontStyle('countrystateFont', array('size' => 11, 'bold' => true, 'name' => 'Arial')); $phpWord->addFontStyle('localityFont', array('size' => 11, 'name' => 'Arial')); $phpWord->addParagraphStyle('other', array('align' => 'left', 'lineHeight' => 1.0, 'spaceAfter' => 0, 'keepNext' => true, 'keepLines' => true));
$kurulusAd = $this->kurulusAd; $sektor = "MYK " . $bilgi["SEKTOR_ADI"] . " Sektör Komitesi"; $resmi = $bilgi["RESMI_GAZETE_TARIH"] != null ? $bilgi["RESMI_GAZETE_TARIH"] . " / " . $bilgi["RESMI_GAZETE_SAYI"] : ""; $karar = $bilgi["KARAR_TARIHI"] != null ? $bilgi["KARAR_TARIHI"] . " Tarih ve " . $bilgi["KARAR_SAYI"] . " Sayılı Karar" : "....... Tarih ve ....... Sayılı Karar"; $adH = $standart_bilgileri[0]["STANDART_ADI"]; $seviyeH = $standart_bilgileri[0]["SEVIYE_ADI"]; $kodH = $standart_bilgileri[0]["STANDART_KODU"]; $onayH = $standart_bilgileri[0]["KARAR_TARIHI"]; $revH = $standart_bilgileri[0]["REVIZYON_NO"]; $kodH = $kodH ? $kodH : ".............."; $onayH = $onayH ? $onayH : ".............."; $revH = $revH == '00' || $revH == '0' ? '...' : $revH; //Bilgiler Son // New Word Document // Baslik Style $phpWord->addFontStyle('rBasStyle', array('bold' => true, 'name' => 'Times New Roman', 'size' => 14)); $phpWord->addParagraphStyle('pBasStyle', array('align' => 'center', 'spaceAfter' => 100)); //İçerik Style $phpWord->addFontStyle('rIcStyle', array('name' => 'Times New Roman', 'size' => 12)); $phpWord->addParagraphStyle('pIcStyle', array('align' => 'center', 'spaceAfter' => 100)); //İçerikBas Style $phpWord->addFontStyle('rIcBasStyle', array('name' => 'Times New Roman', 'size' => 12, 'bold' => true)); $phpWord->addParagraphStyle('pIcStyle', array('align' => 'center', 'spaceAfter' => 100)); // New portrait section $section = $phpWord->createSection(array('orientation' => 'portrait')); // Kapak $section->addImage('images/myk_logo.jpg', array('width' => 152, 'height' => 187, 'align' => 'center')); $section->addTextBreak(3); $section->addText('ULUSAL MESLEK STANDARDI', 'rBasStyle', 'pBasStyle'); $section->addTextBreak(3); $section->addText($std, 'rBasStyle', 'pBasStyle');
$isEditor = 0; if ($symbUid) { if ($isAdmin || array_key_exists("CollAdmin", $userRights) && in_array($collid, $userRights["CollAdmin"]) || array_key_exists("CollEditor", $userRights) && in_array($collid, $userRights["CollEditor"])) { $isEditor = 1; } } if ($isEditor && $action) { $labelArr = $labelManager->getAnnoArray($_POST['detid'], $speciesAuthors); if ($clearQueue) { $labelManager->clearAnnoQueue($_POST['detid']); } } $phpWord = new \PhpOffice\PhpWord\PhpWord(); $phpWord->addParagraphStyle('firstLine', array('lineHeight' => 0.1, 'spaceAfter' => 0, 'keepNext' => true, 'keepLines' => true)); $phpWord->addParagraphStyle('lastLine', array('spaceAfter' => 50, 'lineHeight' => 0.1)); $phpWord->addFontStyle('dividerFont', array('size' => 1)); $phpWord->addParagraphStyle('header', array('align' => 'center', 'lineHeight' => 1.0, 'spaceAfter' => 40, 'keepNext' => true, 'keepLines' => true)); $phpWord->addParagraphStyle('footer', array('align' => 'center', 'lineHeight' => 1.0, 'spaceBefore' => 40, 'spaceAfter' => 0, 'keepNext' => true, 'keepLines' => true)); $phpWord->addFontStyle('headerfooterFont', array('bold' => true, 'size' => 9, 'name' => 'Arial')); $phpWord->addParagraphStyle('other', array('align' => 'left', 'lineHeight' => 1.0, 'spaceBefore' => 30, 'spaceAfter' => 0, 'keepNext' => true, 'keepLines' => true)); $phpWord->addParagraphStyle('scientificname', array('align' => 'left', 'lineHeight' => 1.0, 'spaceAfter' => 0, 'keepNext' => true, 'keepLines' => true)); $phpWord->addFontStyle('scientificnameFont', array('bold' => true, 'italic' => true, 'size' => 10, 'name' => 'Arial')); $phpWord->addFontStyle('scientificnameinterFont', array('bold' => true, 'size' => 10, 'name' => 'Arial')); $phpWord->addFontStyle('scientificnameauthFont', array('size' => 10, 'name' => 'Arial')); $phpWord->addFontStyle('identifiedFont', array('size' => 8, 'name' => 'Arial')); $tableStyle = array('width' => 100, 'borderColor' => '000000', 'borderSize' => 2, 'cellMargin' => 75); $colRowStyle = array('cantSplit' => true); $phpWord->addTableStyle('defaultTable', $tableStyle, $colRowStyle); $cellStyle = array('valign' => 'top'); $section = $phpWord->addSection($sectionStyle); foreach ($labelArr as $occid => $occArr) {
$numBoxes = 1; } else { $numBoxes = $invoiceArr['totalboxes']; } } else { if ($invoiceArr['totalboxesreturned'] == 1) { $numBoxes = 1; } else { $numBoxes = $invoiceArr['totalboxesreturned']; } } } if ($export) { $phpWord = new \PhpOffice\PhpWord\PhpWord(); $phpWord->addParagraphStyle('header', array('align' => 'center', 'lineHeight' => 1.0, 'spaceAfter' => 450)); $phpWord->addFontStyle('headerFont', array('size' => 12, 'bold' => true, 'name' => 'Arial')); $phpWord->addParagraphStyle('toAddress', array('align' => 'left', 'lineHeight' => 1.0, 'spaceBefore' => 0, 'spaceAfter' => 0)); $phpWord->addFontStyle('toAddressFont', array('size' => 10, 'name' => 'Arial')); $phpWord->addParagraphStyle('identifier', array('align' => 'right', 'lineHeight' => 1.0, 'spaceBefore' => 0, 'spaceAfter' => 0)); $phpWord->addFontStyle('identifierFont', array('size' => 10, 'bold' => true, 'name' => 'Arial')); $phpWord->addParagraphStyle('sendwhom', array('align' => 'left', 'lineHeight' => 1.0, 'spaceBefore' => 0, 'spaceAfter' => 0)); $phpWord->addFontStyle('sendwhomFont', array('size' => 10, 'name' => 'Arial')); $phpWord->addParagraphStyle('returnamtdue', array('align' => 'left', 'lineHeight' => 1.0, 'spaceBefore' => 0, 'spaceAfter' => 0)); $phpWord->addFontStyle('returnamtdueFont', array('size' => 10, 'bold' => true, 'name' => 'Arial')); $phpWord->addParagraphStyle('other', array('align' => 'left', 'lineHeight' => 1.0, 'spaceBefore' => 0, 'spaceAfter' => 0)); $phpWord->addFontStyle('otherFont', array('size' => 10, 'name' => 'Arial')); $tableStyle = array('width' => 100); $colRowStyle = array('cantSplit' => true); $phpWord->addTableStyle('headTable', $tableStyle, $colRowStyle); $cellStyle = array('valign' => 'top'); $section = $phpWord->addSection(array('pageSizeW' => 12240, 'pageSizeH' => 15840, 'marginLeft' => 1080, 'marginRight' => 1080, 'marginTop' => 1080, 'marginBottom' => 0, 'headerHeight' => 0, 'footerHeight' => 600));
<?php include_once 'Sample_Header.php'; // New Word Document echo date('H:i:s'), ' Create new PhpWord object', EOL; $phpWord = new \PhpOffice\PhpWord\PhpWord(); \PhpOffice\PhpWord\Settings::setCompatibility(false); // New portrait section $section = $phpWord->addSection(); // Add style definitions $phpWord->addParagraphStyle('pStyle', array('spacing' => 100)); $phpWord->addFontStyle('BoldText', array('bold' => true)); $phpWord->addFontStyle('ColoredText', array('color' => 'FF8080')); $phpWord->addLinkStyle('NLink', array('color' => '0000FF', 'underline' => \PhpOffice\PhpWord\Style\Font::UNDERLINE_SINGLE)); // Add text elements $textrun = $section->addTextRun('pStyle'); $textrun->addText(htmlspecialchars('This is some lead text in a paragraph with a following footnote. ', ENT_COMPAT, 'UTF-8'), 'pStyle'); $footnote = $textrun->addFootnote(); $footnote->addText(htmlspecialchars('Just like a textrun, a footnote can contain native texts. ', ENT_COMPAT, 'UTF-8')); $footnote->addText(htmlspecialchars('No break is placed after adding an element. ', ENT_COMPAT, 'UTF-8'), 'BoldText'); $footnote->addText(htmlspecialchars('All elements are placed inside a paragraph. ', ENT_COMPAT, 'UTF-8'), 'ColoredText'); $footnote->addTextBreak(); $footnote->addText(htmlspecialchars('But you can insert a manual text break like above, ', ENT_COMPAT, 'UTF-8')); $footnote->addText(htmlspecialchars('links like ', ENT_COMPAT, 'UTF-8')); $footnote->addLink('https://github.com/PHPOffice/PHPWord', htmlspecialchars('PHPWord on GitHub', ENT_COMPAT, 'UTF-8'), 'NLink'); $footnote->addText(htmlspecialchars(', image like ', ENT_COMPAT, 'UTF-8')); $footnote->addImage('resources/_earth.jpg', array('width' => 18, 'height' => 18)); $footnote->addText(htmlspecialchars(', or object like ', ENT_COMPAT, 'UTF-8')); $footnote->addObject('resources/_sheet.xls'); $footnote->addText(htmlspecialchars('But you can only put footnote in section, not in header or footer.', ENT_COMPAT, 'UTF-8')); $section->addText(htmlspecialchars('You can also create the footnote directly from the section making it wrap in a paragraph ' . 'like the footnote below this paragraph. But is is best used from within a textrun.', ENT_COMPAT, 'UTF-8'));
header('Content-Disposition: inline; filename="' . $file . '"'); header('Content-Type: application/vnd.openxmlformats-officedocument.wordprocessingml.document'); header('Content-Transfer-Encoding: binary'); header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); header('Expires: 0'); #$xmlWriter = \PhpOffice\PhpWord\IOFactory::createWriter($phpWord, 'Word2007'); #$xmlWriter->save("php://output"); \PhpOffice\PhpWord\Settings::setOutputEscapingEnabled(true); // New Word document // New section $section = $phpWord->addSection(); // Define styles $phpWord->addTitleStyle(1, array('size' => 35, 'bold' => true, 'color' => '#e83d84')); // Adding Text element with font customized using named font style... $pStyle = 'p'; $phpWord->addFontStyle($pStyle, array('name' => 'Arial', 'size' => 16, 'color' => '757575', 'bold' => false)); // Arc $section->addTitle($obj->title, 1); //$section->addText(htmlspecialchars_decode(strip_tags($obj->body)), $pStyle); WaffleHtml::addHtml($section, $obj->body); if ($obj->sidebar) { $sidebar = $phpWord->addSection(); $sidebar->addTitle("Sidebar", 1); //$sidebar->addText(strip_tags($obj->sidebar), $pStyle); WaffleHtml::addHtml($sidebar, $obj->sidebar); } $nav = $phpWord->addSection(); $nav->addTitle("Navigation", 1); foreach ($obj->nav as $anchor) { $nav->addLink($ME_URL . $anchor->slug, $anchor->title, array('name' => 'Arial', 'size' => 16, 'color' => 'e83d84', 'bold' => false)); if ($anchor->nav) {
<?php include_once 'Sample_Header.php'; // New Word document echo date('H:i:s'), ' Create new PhpWord object', EOL; $phpWord = new \PhpOffice\PhpWord\PhpWord(); // Define styles $fontStyleName = 'myOwnStyle'; $phpWord->addFontStyle($fontStyleName, array('color' => 'FF0000')); $paragraphStyleName = 'P-Style'; $phpWord->addParagraphStyle($paragraphStyleName, array('spaceAfter' => 95)); $multilevelNumberingStyleName = 'multilevel'; $phpWord->addNumberingStyle($multilevelNumberingStyleName, array('type' => 'multilevel', 'levels' => array(array('format' => 'decimal', 'text' => '%1.', 'left' => 360, 'hanging' => 360, 'tabPos' => 360), array('format' => 'upperLetter', 'text' => '%2.', 'left' => 720, 'hanging' => 360, 'tabPos' => 720)))); $predefinedMultilevelStyle = array('listType' => \PhpOffice\PhpWord\Style\ListItem::TYPE_NUMBER_NESTED); // New section $section = $phpWord->addSection(); // Lists $section->addText('Multilevel list.'); $section->addListItem('List Item I', 0, null, $multilevelNumberingStyleName); $section->addListItem('List Item I.a', 1, null, $multilevelNumberingStyleName); $section->addListItem('List Item I.b', 1, null, $multilevelNumberingStyleName); $section->addListItem('List Item II', 0, null, $multilevelNumberingStyleName); $section->addListItem('List Item II.a', 1, null, $multilevelNumberingStyleName); $section->addListItem('List Item III', 0, null, $multilevelNumberingStyleName); $section->addTextBreak(2); $section->addText('Basic simple bulleted list.'); $section->addListItem('List Item 1'); $section->addListItem('List Item 2'); $section->addListItem('List Item 3'); $section->addTextBreak(2); $section->addText('Continue from multilevel list above.');
<?php include_once 'Sample_Header.php'; // New Word document echo date('H:i:s'), ' Create new PhpWord object', EOL; $phpWord = new \PhpOffice\PhpWord\PhpWord(); // Begin code $fontStyle = array('size' => 24); $paragraphStyle = array('spacing' => 240, 'size' => 24); $phpWord->addFontStyle('fontStyle', array('size' => 9)); $phpWord->addParagraphStyle('paragraphStyle', array('spacing' => 480)); $fontStyle = array('size' => 24); $section = $phpWord->addSection(); $section->addText(htmlspecialchars('Text break with no style:', ENT_COMPAT, 'UTF-8')); $section->addTextBreak(); $section->addText(htmlspecialchars('Text break with defined font style:', ENT_COMPAT, 'UTF-8')); $section->addTextBreak(1, 'fontStyle'); $section->addText(htmlspecialchars('Text break with defined paragraph style:', ENT_COMPAT, 'UTF-8')); $section->addTextBreak(1, null, 'paragraphStyle'); $section->addText(htmlspecialchars('Text break with inline font style:', ENT_COMPAT, 'UTF-8')); $section->addTextBreak(1, $fontStyle); $section->addText(htmlspecialchars('Text break with inline paragraph style:', ENT_COMPAT, 'UTF-8')); $section->addTextBreak(1, null, $paragraphStyle); $section->addText(htmlspecialchars('Done.', ENT_COMPAT, 'UTF-8')); // Save file echo write($phpWord, basename(__FILE__, '.php'), $writers); if (!CLI) { include_once 'Sample_Footer.php'; }
$imgcontributorsArr = $singleExportArr['imgcontributors']; unset($singleExportArr['glossSciName']); unset($singleExportArr['references']); unset($singleExportArr['contributors']); unset($singleExportArr['imgcontributors']); ksort($referencesArr); ksort($contributorsArr); ksort($imgcontributorsArr); ksort($singleExportArr, SORT_STRING | SORT_FLAG_CASE); $fileName = $sciName . '_SingleLanguage'; } } $fileName = str_replace(" ", "_", $fileName); $phpWord = new \PhpOffice\PhpWord\PhpWord(); $phpWord->addParagraphStyle('titlePara', array('align' => 'center', 'lineHeight' => 1.0, 'spaceBefore' => 0, 'spaceAfter' => 0, 'keepNext' => true)); $phpWord->addFontStyle('titleFont', array('bold' => true, 'size' => 16, 'name' => 'Microsoft Sans Serif')); $phpWord->addParagraphStyle('transTermPara', array('align' => 'left', 'lineHeight' => 1.0, 'spaceBefore' => 0, 'spaceAfter' => 0, 'keepNext' => true)); $phpWord->addFontStyle('transTermTopicNodefFont', array('bold' => true, 'size' => 15, 'name' => 'Microsoft Sans Serif')); $phpWord->addFontStyle('transTermTopicDefFont', array('bold' => true, 'size' => 14, 'name' => 'Microsoft Sans Serif')); $phpWord->addParagraphStyle('transDefPara', array('align' => 'left', 'lineHeight' => 1.0, 'indent' => 0.78125, 'spaceBefore' => 0, 'spaceAfter' => 0, 'keepNext' => true)); $phpWord->addParagraphStyle('transDefList', array('align' => 'left', 'lineHeight' => 1.0, 'indent' => 0.78125, 'spaceBefore' => 0, 'spaceAfter' => 0, 'keepNext' => true)); $phpWord->addFontStyle('transMainTermNodefFont', array('bold' => false, 'size' => 12, 'name' => 'Microsoft Sans Serif', 'color' => '21304B')); $phpWord->addFontStyle('transTransTermNodefFont', array('bold' => false, 'size' => 12, 'name' => 'Microsoft Sans Serif', 'color' => '000000')); $phpWord->addFontStyle('transMainTermDefFont', array('bold' => true, 'size' => 12, 'name' => 'Microsoft Sans Serif', 'color' => '21304B')); $phpWord->addFontStyle('transTransTermDefFont', array('bold' => true, 'size' => 12, 'name' => 'Microsoft Sans Serif', 'color' => '000000')); $phpWord->addFontStyle('transDefTextFont', array('bold' => false, 'size' => 12, 'name' => 'Microsoft Sans Serif', 'color' => '000000')); $tableStyle = array('width' => 100, 'cellMargin' => 60); $colRowStyle = array('cantSplit' => true, 'exactHeight' => 180); $phpWord->addTableStyle('exportTable', $tableStyle, $colRowStyle); $nodefCellStyle = array('valign' => 'center', 'width' => 2520, 'borderSize' => 0, 'borderColor' => 'ffffff'); $imageCellStyle = array('valign' => 'top', 'width' => 2520, 'borderSize' => 0, 'borderColor' => 'ffffff');
/** * @Security("has_role('ROLE_USER')") */ private function downloadQRCodeFile(Rucher $rucher, $ruches) { //Création de l'objet phpWord pour le fichier word $phpWord = new \PhpOffice\PhpWord\PhpWord(); //Création du path pour gérer les fichiers temporaires $path = $this->get('kernel')->getRootDir() . "/../web/generate/"; //Ajout d'une section $section = $phpWord->addSection(); //Ajout d'un en-tête $phpWord->addFontStyle('eStyle', array('bold' => true, 'size' => 16)); $phpWord->addFontStyle('rStyle', array('size' => 14)); $header = $section->addHeader(); $headerTable = $header->addTable(); $headerTable->addRow(); $headerTable->addCell(\PhpOffice\PhpWord\Shared\Converter::cmToTwip(5))->addImage('logo.png', array('height' => 80)); $cellText = $headerTable->addCell(\PhpOffice\PhpWord\Shared\Converter::cmToTwip(11)); $cellText->addText(htmlspecialchars($rucher->getExploitation()->getNom()), 'eStyle', array('align' => 'right')); $cellText->addText(htmlspecialchars($rucher->getNom()), 'rStyle', array('align' => 'right')); //Ajout d'un pied de page $footer = $section->addFooter(); $footer->addPreserveText(htmlspecialchars('{PAGE}/{NUMPAGES}'), null, array('align' => 'right')); //Création du style des cellules $cellStyle = array('valign' => 'center'); $phpWord->addFontStyle('qStyle', array('size' => 12)); //Ajout de la table contenant les qr codes $table = $section->addTable(); //Nombre de ruches dans le fichier, utile pour créer une nouvelle ligne $nbRuches = 0; foreach ($ruches as $ruche) { //3 QRCodes par ligne if ($nbRuches % 3 === 0) { $table->addRow(\PhpOffice\PhpWord\Shared\Converter::cmToTwip(5.5)); } $nbRuches++; //Construction de l'url pour accéder à la ruche $url = $this->generateUrl('kg_beekeeping_management_view_ruche', array('ruche_id' => $ruche->getId()), true); //Construction du QRCode pointant sur l'url de la ruche $options = array('code' => $url, 'type' => 'qrcode', 'format' => 'png'); $barcode = $this->get('sgk_barcode.generator')->generate($options); //Path du fichier avec le QRCode $filename = 'qrcode' . $ruche->getId() . '.png'; //Sauvegarde du fichier file_put_contents($path . $filename, base64_decode($barcode)); //Ajout du QRCode dans le fichier ODT $cell = $table->addCell(\PhpOffice\PhpWord\Shared\Converter::cmToTwip(5.33), $cellStyle); $cell->addText(htmlspecialchars($ruche->getNom()), 'qStyle', array('align' => 'center')); $cell->addImage('generate/' . $filename, array('width' => 151.18, 'height' => 151.18, 'wrappingStyle' => 'behind', 'align' => 'center')); } //Ajout de cellules vides si ligne incomplète $reste = 3 - $nbRuches % 3; if ($reste < 3) { while ($reste > 0) { $cell = $table->addCell(\PhpOffice\PhpWord\Shared\Converter::cmToTwip(5.33), $cellStyle); $reste--; } } //Sauvegarde du fichier ODT $objWriter = \PhpOffice\PhpWord\IOFactory::createWriter($phpWord, 'Word2007'); $filename = $rucher->getId() . '_qr_codes_rucher_' . $rucher->getNom() . '.docx'; $objWriter->save($path . $filename, 'Word2007', true); //Récupération du contenu du fichier $content = file_get_contents($path . $filename); //Création de la réponse avec le contentu du fichier (pour le download) $response = new Response(); $response->headers->set('Content-Type', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'); $response->headers->set('Content-Disposition', 'attachment;filename="' . $filename); $response->setContent($content); //Suppression des fichiers créés durant la création du fichier word unlink($path . $filename); foreach ($ruches as $ruche) { $filename = 'qrcode' . $ruche->getId() . '.png'; unlink($path . $filename); } //Retour de la réponse return $response; }
<?php defined('_JEXEC') or die('Restricted access'); $atData = $this->atData; $atTar = $this->atTar; require_once 'libraries/PHPWord-master/src/PhpWord/Autoloader.php'; \PhpOffice\PhpWord\Autoloader::register(); $phpWord = new \PhpOffice\PhpWord\PhpWord(); // Baslik Style $phpWord->addFontStyle('rBasStyle', array('bold' => true, 'name' => 'Times New Roman', 'size' => 12)); $phpWord->addParagraphStyle('pBasStyle', array('align' => 'center', 'spaceAfter' => 100)); //İçerik Style $phpWord->addFontStyle('rIcStyle', array('name' => 'Times New Roman', 'size' => 12)); $phpWord->addParagraphStyle('pIcStyle', array('align' => 'center', 'spaceAfter' => 100)); //İçerikBas Style $phpWord->addFontStyle('rIcBasStyle', array('name' => 'Times New Roman', 'size' => 12, 'bold' => true)); $phpWord->addParagraphStyle('pIcStyle', array('align' => 'center', 'spaceAfter' => 100)); // New portrait section $section = $phpWord->addSection(array('orientation' => 'portrait')); $section->addText('EK-8', 'rBasStyle', array('align' => 'right')); $section->addText('Avrupa Topluluğu (AT) Yüklenicileri Tarafından 2.000 TL’nin Üstünde Yapılan Alımlara İlişkin Üçer Aylık Bildirim Tablosu', 'rBasStyle', array('align' => 'center')); $section->addText('(KDV İstisna Sertifikası alınan vergi idaresine gönderilecektir)', 'rIcStyle', array('align' => 'center')); $section->addTextBreak(1); $styleTable = array('borderSize' => 6, 'borderColor' => '000000', 'cellMarginLeft' => 20); $styleFirstRow = array('borderBottomSize' => 6, 'borderBottomColor' => '000000'); $styleCell = array('borderRightColor' => '000000', 'borderRightSize' => 6, 'valign' => 'center'); $fontStyleBold = array('bold' => true, 'name' => 'Times New Roman', 'size' => 12); $fontStyle = array('name' => 'Times New Roman', 'size' => 12); $phpWord->addTableStyle('Fancy Table', $styleTable, $styleFirstRow); $table = $section->addTable('Fancy Table'); $table->addRow();
/** * */ public function exportMemberProfile($id) { $user = User::find($id); if (!$user) { return Redirect::route('members')->with('mError', 'Cet utilisateur est introuvable !'); } $phpWord = new \PhpOffice\PhpWord\PhpWord(); $phpWord->addTitleStyle(1, array('name' => 'Tahoma', 'size' => 30, 'bold' => true), array('align' => 'center', 'spaceBefore' => true, 'spaceAfter' => true)); $phpWord->addTitleStyle(2, array('name' => 'Tahoma', 'size' => 14, 'color' => '666666', 'bold' => true), array('align' => 'center', 'spaceBefore' => true, 'spaceAfter' => true)); $phpWord->addFontStyle('defaultText', array('name' => 'Tahoma', 'size' => 12, 'spaceBefore' => true, 'spaceAfter' => true)); $section = $phpWord->addSection(array('marginTop' => \PhpOffice\PhpWord\Shared\Converter::cmToTwip(1), 'marginLeft' => \PhpOffice\PhpWord\Shared\Converter::cmToTwip(1), 'marginRight' => \PhpOffice\PhpWord\Shared\Converter::cmToTwip(1))); $textrun = $section->addTextRun('Heading1'); $textrun->addText($user->fullname); $section->addTextBreak(); $textrun = $section->addTextRun('Heading2'); $textrun->addText(htmlspecialchars($user->bio_short)); $section->addTextBreak(); $table = $section->addTable(); $table->addRow(); $cell1 = $table->addCell(\PhpOffice\PhpWord\Shared\Converter::cmToTwip(14)); foreach (explode("\n", htmlspecialchars($user->bio_long)) as $line) { $cell1->addText($line, 'defaultText'); } $cell1->addTextBreak(); if ($user->phone) { $cell1->addText(htmlspecialchars(sprintf('Tél: %s', $user->phoneFmt)), 'defaultText', array('align' => 'right')); } $cell1->addText(htmlspecialchars(sprintf('Email: %s', $user->email)), 'defaultText', array('align' => 'right')); if ($user->website) { $cell1->addText(htmlspecialchars($user->website), 'defaultText', array('align' => 'right')); } $cell2 = $table->addCell(\PhpOffice\PhpWord\Shared\Converter::cmToTwip(5)); $image_url = $user->largeAvatarUrl; $image_url = preg_replace('!^(.+)\\?.+$!', '$1', $image_url); if (false === strpos($image_url, 'http')) { $image_url = public_path() . $image_url; } $cell2->addImage($image_url, array('width' => \PhpOffice\PhpWord\Shared\Converter::cmToPixel(5))); $filename = sprintf('%s.docx', Str::slug($user->fullname)); $objWriter = \PhpOffice\PhpWord\IOFactory::createWriter($phpWord, 'Word2007'); $objWriter->save($filename); $content = file_get_contents($filename); unlink($filename); $headers = array("Content-Description" => "File Transfer", "Content-Transfer-Encoding" => "binary", "Content-type" => "application/vnd.openxmlformats-officedocument.wordprocessingml.document", "Content-Disposition" => "attachment; filename=" . $filename); return Response::make($content, 200, $headers); }
<?php include_once 'Sample_Header.php'; // New Word Document echo date('H:i:s'), ' Create new PhpWord object', EOL; $phpWord = new \PhpOffice\PhpWord\PhpWord(); // Define styles $paragraphStyleName = 'pStyle'; $phpWord->addParagraphStyle($paragraphStyleName, array('spacing' => 100)); $boldFontStyleName = 'BoldText'; $phpWord->addFontStyle($boldFontStyleName, array('bold' => true)); $coloredFontStyleName = 'ColoredText'; $phpWord->addFontStyle($coloredFontStyleName, array('color' => 'FF8080', 'bgColor' => 'FFFFCC')); $linkFontStyleName = 'NLink'; $phpWord->addLinkStyle($linkFontStyleName, array('color' => '0000FF', 'underline' => \PhpOffice\PhpWord\Style\Font::UNDERLINE_SINGLE)); // New portrait section $section = $phpWord->addSection(); // Add text run $textrun = $section->addTextRun($paragraphStyleName); $textrun->addText('Each textrun can contain native text, link elements or an image.'); $textrun->addText(' No break is placed after adding an element.', $boldFontStyleName); $textrun->addText(' Both '); $textrun->addText('superscript', array('superScript' => true)); $textrun->addText(' and '); $textrun->addText('subscript', array('subScript' => true)); $textrun->addText(' are also available.'); $textrun->addText(' All elements are placed inside a paragraph with the optionally given paragraph style.', $coloredFontStyleName); $textrun->addText(' Sample Link: '); $textrun->addLink('https://github.com/PHPOffice/PHPWord', 'PHPWord on GitHub', $linkFontStyleName); $textrun->addText(' Sample Image: '); $textrun->addImage('resources/_earth.jpg', array('width' => 18, 'height' => 18));
$identifier = 0; if ($loanId) { $identifier = $loanId; } elseif ($exchangeId) { $identifier = $exchangeId; } if ($institution) { $invoiceArr = $loanManager->getToAddress($institution); } else { $invoiceArr = $loanManager->getInvoiceInfo($identifier, $loanType); } $addressArr = $loanManager->getFromAddress($collId); if ($export) { $phpWord = new \PhpOffice\PhpWord\PhpWord(); $phpWord->addParagraphStyle('fromAddress', array('align' => 'left', 'lineHeight' => 1.0, 'spaceAfter' => 0, 'keepNext' => true, 'keepLines' => true)); $phpWord->addFontStyle('fromAddressFont', array('size' => 10, 'name' => 'Arial')); $phpWord->addParagraphStyle('toAddress', array('align' => 'left', 'indent' => 2, 'lineHeight' => 1.0, 'spaceAfter' => 0, 'keepNext' => true, 'keepLines' => true)); $phpWord->addFontStyle('toAddressFont', array('size' => 14, 'name' => 'Arial')); $section = $phpWord->addSection(array('pageSizeW' => 12240, 'pageSizeH' => 15840, 'marginLeft' => 360, 'marginRight' => 360, 'marginTop' => 360, 'marginBottom' => 360, 'headerHeight' => 0, 'footerHeight' => 0)); $textrun = $section->addTextRun('fromAddress'); $textrun->addText(htmlspecialchars($addressArr['institutionname'] . ' (' . $addressArr['institutioncode'] . ')'), 'fromAddressFont'); $textrun->addTextBreak(1); if ($addressArr['institutionname2']) { $textrun->addText(htmlspecialchars($addressArr['institutionname2']), 'fromAddressFont'); $textrun->addTextBreak(1); } if ($addressArr['address1']) { $textrun->addText(htmlspecialchars($addressArr['address1']), 'fromAddressFont'); $textrun->addTextBreak(1); } if ($addressArr['address2']) {
<?php include_once 'Sample_Header.php'; // New Word Document echo date('H:i:s'), ' Create new PhpWord object', EOL; $phpWord = new \PhpOffice\PhpWord\PhpWord(); $phpWord->addFontStyle('rStyle', array('bold' => true, 'italic' => true, 'size' => 16, 'allCaps' => true, 'doubleStrikethrough' => true)); $phpWord->addParagraphStyle('pStyle', array('alignment' => \PhpOffice\PhpWord\SimpleType\Jc::CENTER, 'spaceAfter' => 100)); $phpWord->addTitleStyle(1, array('bold' => true), array('spaceAfter' => 240)); // New portrait section $section = $phpWord->addSection(); // Simple text $section->addTitle(htmlspecialchars('Welcome to PhpWord', ENT_COMPAT, 'UTF-8'), 1); $section->addText(htmlspecialchars('Hello World!', ENT_COMPAT, 'UTF-8')); // Two text break $section->addTextBreak(2); // Defined style $section->addText(htmlspecialchars('I am styled by a font style definition.', ENT_COMPAT, 'UTF-8'), 'rStyle'); $section->addText(htmlspecialchars('I am styled by a paragraph style definition.', ENT_COMPAT, 'UTF-8'), null, 'pStyle'); $section->addText(htmlspecialchars('I am styled by both font and paragraph style.', ENT_COMPAT, 'UTF-8'), 'rStyle', 'pStyle'); $section->addTextBreak(); // Inline font style $fontStyle['name'] = 'Times New Roman'; $fontStyle['size'] = 20; $textrun = $section->addTextRun(); $textrun->addText(htmlspecialchars('I am inline styled ', ENT_COMPAT, 'UTF-8'), $fontStyle); $textrun->addText(htmlspecialchars('with ', ENT_COMPAT, 'UTF-8')); $textrun->addText(htmlspecialchars('color', ENT_COMPAT, 'UTF-8'), array('color' => '996699')); $textrun->addText(htmlspecialchars(', ', ENT_COMPAT, 'UTF-8')); $textrun->addText(htmlspecialchars('bold', ENT_COMPAT, 'UTF-8'), array('bold' => true)); $textrun->addText(htmlspecialchars(', ', ENT_COMPAT, 'UTF-8'));
if ($showAlphaTaxa) { $clManager->setShowAlphaTaxa(); } $clid = $clManager->getClid(); $pid = $clManager->getPid(); $isEditor = false; if ($isAdmin || array_key_exists("ClAdmin", $userRights) && in_array($clid, $userRights["ClAdmin"])) { $isEditor = true; } $taxaArray = array(); if ($clValue || $dynClid) { $taxaArray = $clManager->getTaxaList($pageNumber, 0); } $phpWord = new \PhpOffice\PhpWord\PhpWord(); $phpWord->addParagraphStyle('defaultPara', array('align' => 'left', 'lineHeight' => 1.0, 'spaceBefore' => 0, 'spaceAfter' => 0, 'keepNext' => true)); $phpWord->addFontStyle('titleFont', array('bold' => true, 'size' => 20, 'name' => 'Arial')); $phpWord->addFontStyle('topicFont', array('bold' => true, 'size' => 12, 'name' => 'Arial')); $phpWord->addFontStyle('textFont', array('size' => 12, 'name' => 'Arial')); $phpWord->addParagraphStyle('linePara', array('align' => 'left', 'lineHeight' => 1.0, 'spaceBefore' => 0, 'spaceAfter' => 0, 'keepNext' => true)); $phpWord->addParagraphStyle('familyPara', array('align' => 'left', 'lineHeight' => 1.0, 'spaceBefore' => 225, 'spaceAfter' => 75, 'keepNext' => true)); $phpWord->addFontStyle('familyFont', array('bold' => true, 'size' => 16, 'name' => 'Arial')); $phpWord->addParagraphStyle('scinamePara', array('align' => 'left', 'lineHeight' => 1.0, 'indent' => 0.3125, 'spaceBefore' => 0, 'spaceAfter' => 45, 'keepNext' => true)); $phpWord->addFontStyle('scientificnameFont', array('bold' => true, 'italic' => true, 'size' => 12, 'name' => 'Arial')); $phpWord->addParagraphStyle('notesvouchersPara', array('align' => 'left', 'lineHeight' => 1.0, 'indent' => 0.78125, 'spaceBefore' => 0, 'spaceAfter' => 45)); $phpWord->addParagraphStyle('imagePara', array('align' => 'center', 'lineHeight' => 1.0, 'spaceBefore' => 0, 'spaceAfter' => 0)); $tableStyle = array('width' => 100); $colRowStyle = array('cantSplit' => true, 'exactHeight' => 3750); $phpWord->addTableStyle('imageTable', $tableStyle, $colRowStyle); $imageCellStyle = array('valign' => 'center', 'width' => 2475, 'borderSize' => 15, 'borderColor' => '808080'); $blankCellStyle = array('valign' => 'center', 'width' => 2475, 'borderSize' => 15, 'borderColor' => '000000'); $section = $phpWord->addSection(array('pageSizeW' => 12240, 'pageSizeH' => 15840, 'marginLeft' => 1080, 'marginRight' => 1080, 'marginTop' => 1080, 'marginBottom' => 1080, 'headerHeight' => 0, 'footerHeight' => 0));
$identifier = 0; if ($loanId) { $identifier = $loanId; } elseif ($exchangeId) { $identifier = $exchangeId; } if ($institution) { $invoiceArr = $loanManager->getToAddress($institution); } else { $invoiceArr = $loanManager->getInvoiceInfo($identifier, $loanType); } $addressArr = $loanManager->getFromAddress($collId); if ($export) { $phpWord = new \PhpOffice\PhpWord\PhpWord(); $phpWord->addParagraphStyle('acctnum', array('align' => 'left', 'indent' => 5.5, 'lineHeight' => 1.0, 'spaceAfter' => 0, 'keepNext' => true, 'keepLines' => true)); $phpWord->addFontStyle('acctnumFont', array('size' => 8, 'name' => 'Arial')); $phpWord->addParagraphStyle('toAddress', array('align' => 'left', 'indent' => 6, 'lineHeight' => 1.0, 'spaceAfter' => 0, 'keepNext' => true, 'keepLines' => true)); $phpWord->addFontStyle('toAddressFont', array('size' => 12, 'name' => 'Arial')); $section = $phpWord->addSection(array('pageSizeW' => 13662.992125984, 'pageSizeH' => 5952.755905512, 'marginLeft' => 360, 'marginRight' => 360, 'marginTop' => 360, 'marginBottom' => 360, 'headerHeight' => 0, 'footerHeight' => 0)); $section->addTextBreak(5); if ($accountNum) { $section->addText(htmlspecialchars('Acct. #' . $accountNum), 'acctnumFont', 'acctnum'); } $section->addTextBreak(1); $textrun = $section->addTextRun('toAddress'); $textrun->addText(htmlspecialchars($invoiceArr['contact']), 'toAddressFont'); $textrun->addTextBreak(1); $textrun->addText(htmlspecialchars($invoiceArr['institutionname'] . ' (' . $invoiceArr['institutioncode'] . ')'), 'toAddressFont'); $textrun->addTextBreak(1); if ($invoiceArr['institutionname2']) { $textrun->addText(htmlspecialchars($invoiceArr['institutionname2']), 'toAddressFont');
include "libchart/libchart/classes/libchart.php"; $chart = new VerticalBarChart(700, 500); $dataSet = new XYDataSet(); $dataSet->addPoint(new Point("FCD", $read[0])); $dataSet->addPoint(new Point("First Class", $read[1])); $dataSet->addPoint(new Point("Second Class", $read[2])); $dataSet->addPoint(new Point("Fail", $read[3])); $chart->setDataSet($dataSet); //$chart->setUpperBound ( 120) ; $chart->setTitle("Maharaja institute of Technology, EC Branch, 8th Sem"); $chart->render("demo1.png"); // Creating the new document... $phpWord = new \PhpOffice\PhpWord\PhpWord(); $phpWord->addParagraphStyle('tStyle', array('align' => 'center', 'spaceAfter' => 100)); $phpWord->addParagraphStyle('nStyle', array('align' => 'justify')); $phpWord->addFontStyle('tFont', array('name' => 'Times New Roman', 'bold' => true, 'italic' => true, 'size' => 24, 'allCaps' => true)); $phpWord->addFontStyle('hFont', array('name' => 'Times New Roman', 'bold' => false, 'italic' => false, 'size' => 10, 'allCaps' => true)); $phpWord->addFontStyle('aFont', array('name' => 'Times New Roman', 'bold' => true, 'italic' => false, 'size' => 9)); $phpWord->addFontStyle('aFonti', array('name' => 'Times New Roman', 'bold' => true, 'italic' => true, 'size' => 9)); $phpWord->addFontStyle('nFont', array('name' => 'Times New Roman', 'bold' => false, 'italic' => false, 'size' => 10)); $phpWord->addNumberingStyle('multilevel', array('type' => 'multilevel', 'levels' => array(array('format' => 'upperRoman', 'text' => '%1.', 'left' => 360, 'hanging' => 360, 'tabPos' => 360), array('format' => 'upperLetter', 'text' => '%2.', 'left' => 720, 'hanging' => 360, 'tabPos' => 720)))); //Title $section = $phpWord->addSection(); $section->addText(htmlspecialchars("Maharaja Institute of Techonology"), 'tFont', 'tStyle'); $section->addTextBreak($lineSpace); /* $section = $phpWord->addSection(); //Abstract $section->addText("Branch: E&CE",'aFonti'); $section->addText("Semester: VIII",'aFonti'); $section->addTextBreak($lineSpace);
} if (!is_null($ending_date)) { $ending_date = strtotime($ending_date); $ending_date = date('Y-m-d', $ending_date); } $postal_name = $dataobject->postal_name; $postal_address = $dataobject->postal_address; $document_holder = $dataobject->document_holder; $document_holder_address = $dataobject->document_holder_address; /***************************************************************************** CREATING THE DOCUMENT TEMPLATE *****************************************************************************/ $phpWord = new \PhpOffice\PhpWord\PhpWord(); $section = $phpWord->addSection(); /***************************************************************************** FONTS *****************************************************************************/ $baseFont = 'baseText'; $phpWord->addFontStyle($baseFont, array('name' => 'Times New Roman', 'size' => 13, 'color' => '000000', 'bold' => false)); $titleFont = 'titleText'; $phpWord->addFontStyle($titleFont, array('name' => 'Times New Roman', 'size' => 15, 'color' => '000000', 'bold' => true)); /***************************************************************************** CONTENT OF COVER *****************************************************************************/ $section->addText(htmlspecialchars('ADATOK' . "\n" . "\n"), $titleFont); $section->addText(htmlspecialchars('CÉG NEVE: ' . $company_name . "\n" . 'VEZETŐ NEVE: ' . $manager_name . "\n" . 'VEZETŐ CÍME: ' . $manager_address . "\n" . 'TELEFON: ' . $company_phone . "\n" . 'EMAIL: ' . $company_email . "\n" . 'DÁTUM: ' . $starting_date . ' - ' . $ending_date . "\n" . 'POSTANÉV: ' . $postal_name . "\n" . 'POSTACÍM: ' . $postal_address . "\n" . "IRATŐRZŐ NEVE: " . $document_holder . "\n" . "IRATŐRZŐ CÍME: " . $document_holder_address), $baseFont); /***************************************************************************** CREATING THE WORD DOCUMENT *****************************************************************************/ $objWriter = \PhpOffice\PhpWord\IOFactory::createWriter($phpWord, 'Word2007'); $objWriter->save('../../cover.docx');
/* Note: any element you append to a document must reside inside of a Section. */ // Adding an empty Section to the document... $section = $phpWord->addSection(); // Adding Text element to the Section having font styled by default... $section->addText(htmlspecialchars('"Learn from yesterday, live for today, hope for tomorrow. ' . 'The important thing is not to stop questioning." ' . '(Albert Einstein)')); /* * Note: it's possible to customize font style of the Text element you add in three ways: * - inline; * - using named font style (new font style object will be implicitly created); * - using explicitly created font style object. */ // Adding Text element with font customized inline... $section->addText(htmlspecialchars('"Great achievement is usually born of great sacrifice, ' . 'and is never the result of selfishness." ' . '(Napoleon Hill)'), array('name' => 'Tahoma', 'size' => 10)); // Adding Text element with font customized using named font style... $fontStyleName = 'oneUserDefinedStyle'; $phpWord->addFontStyle($fontStyleName, array('name' => 'Tahoma', 'size' => 10, 'color' => '1B2232', 'bold' => true)); $section->addText(htmlspecialchars('"The greatest accomplishment is not in never falling, ' . 'but in rising again after you fall." ' . '(Vince Lombardi)'), $fontStyleName); // Adding Text element with font customized using explicitly created font style object... $fontStyle = new \PhpOffice\PhpWord\Style\Font(); $fontStyle->setBold(true); $fontStyle->setName('Tahoma'); $fontStyle->setSize(13); $myTextElement = $section->addText(htmlspecialchars('"Believe you can and you\'re halfway there." (Theodor Roosevelt)')); $myTextElement->setFontStyle($fontStyle); // Saving the document as OOXML file... $pro_name = "test"; ob_end_clean(); header("Pragma: public"); header("Expires: 0"); header("Cache-Control:must-revalidate, post-check=0, pre-check=0"); header("Content-Type:application/force-download");
// Every element you want to append to the word document is placed in a section. // New portrait section $sectionStyle = array('orientation' => 'portrait', 'marginTop' => 2 * $cmToTwips, 'marginBottom' => 2 * $cmToTwips, 'marginLeft' => 2 * $cmToTwips, 'marginRight' => 2 * $cmToTwips, 'headerHeight' => 1 * $cmToTwips, 'footerHeight' => 1 * $cmToTwips, 'colsNum' => 1); $section = $phpWord->addSection($sectionStyle); // Add header for all pages $header = $section->addHeader(); //$header->addText("Header"); $headerimage = $this->request->getThemeDirectoryPath() . "/graphics/logos/" . $this->request->config->get('report_img'); if (file_exists($headerimage)) { $header->addImage($headerimage, array('height' => 30, 'wrappingStyle' => 'inline')); } // Add footer $footer = $section->addFooter(); $footer->addPreserveText('{PAGE}/{NUMPAGES}', null, array('align' => 'right')); // Defining font style for headers $phpWord->addFontStyle('headerStyle', array('name' => 'Verdana', 'size' => 12, 'color' => '444477')); // Defining font style for display values $phpWord->addFontStyle('displayValueStyle', array('name' => 'Verdana', 'size' => 14, 'color' => '000000')); $styleHeaderFont = array('bold' => true, 'size' => 13, 'name' => 'Calibri'); $styleBundleNameFont = array('bold' => false, 'underline' => 'single', 'color' => '666666', 'size' => 11, 'name' => 'Calibri'); $styleContentFont = array('bold' => false, 'size' => 11, 'name' => 'Calibri'); // Define table style arrays $styleTable = array('borderSize' => 0, 'borderColor' => 'ffffff', 'cellMargin' => 80); $styleFirstRow = array('borderBottomSize' => 18, 'borderBottomColor' => '0000FF'); // Define cell style arrays $styleCell = array('valign' => 'center'); $styleCellBTLR = array('valign' => 'center'); // Define font style for first row $fontStyle = array('bold' => true, 'align' => 'center'); // Add table style $phpWord->addTableStyle('myOwnTableStyle', $styleTable, $styleFirstRow);
} $spanish = $language == 'span' ? 1 : 0; $identifier = 0; if ($loanId) { $identifier = $loanId; } elseif ($exchangeId) { $identifier = $exchangeId; } $invoiceArr = $loanManager->getInvoiceInfo($identifier, $loanType); $addressArr = $loanManager->getFromAddress($collId); $specTotal = $loanManager->getSpecTotal($loanId); $specList = $loanManager->getSpecList($loanId); if ($export) { $phpWord = new \PhpOffice\PhpWord\PhpWord(); $phpWord->addParagraphStyle('header', array('align' => 'left', 'lineHeight' => 1.0, 'spaceAfter' => 0, 'keepNext' => true, 'keepLines' => true)); $phpWord->addFontStyle('headerFont', array('size' => 14, 'name' => 'Arial')); $phpWord->addParagraphStyle('info', array('align' => 'left', 'lineHeight' => 1.0, 'spaceAfter' => 0, 'keepNext' => true, 'keepLines' => true)); $phpWord->addFontStyle('infoFont', array('size' => 11, 'name' => 'Arial')); $phpWord->addFontStyle('colHeaderFont', array('size' => 8, 'bold' => true, 'name' => 'Arial')); $phpWord->addFontStyle('colFont', array('size' => 8, 'name' => 'Arial')); $phpWord->addParagraphStyle('colHeadSpace', array('lineHeight' => 1.5, 'spaceAfter' => 0)); $phpWord->addParagraphStyle('colSpace', array('lineHeight' => 1.3, 'spaceAfter' => 0)); $tableHeadStyle = array('borderBottomSize' => 10, 'borderBottomColor' => '000000', 'width' => 100); $tableStyle = array('width' => 100); $colRowStyle = array('cantSplit' => true); $phpWord->addTableStyle('headerTable', $tableHeadStyle, $colRowStyle); $phpWord->addTableStyle('listTable', $tableStyle, $colRowStyle); $cellStyle = array('valign' => 'bottom'); $section = $phpWord->addSection(array('pageSizeW' => 12240, 'pageSizeH' => 15840, 'marginLeft' => 1080, 'marginRight' => 1080, 'marginTop' => 1080, 'marginBottom' => 1080, 'headerHeight' => 0, 'footerHeight' => 0)); $textrun = $section->addTextRun('header'); $textrun->addText(htmlspecialchars('List of specimens loaned to: ' . $invoiceArr['institutioncode']), 'headerFont');
$a_class = $this->template == 'panel/em-cartaz' ? 'active' : ''; $url = $app->createUrl('panel', 'em-cartaz'); echo "<li><a class='{$a_class}' href='{$url}'><span class='icon icon-em-cartaz'></span> Em Cartaz</a></li>"; }); $app->hook('GET(panel.em-cartaz-<<download|preview>>)', function () use($app, $defaultFrom, $defaultTo) { if (!$app->user->is('admin') && !$app->user->is('staff')) { //throw new MapasCulturais\Exceptions\PermissionDenied; $app->pass(); } $from = isset($this->getData['from']) ? new DateTime($this->getData['from']) : $defaultFrom; $to = isset($this->getData['to']) ? new DateTime($this->getData['to']) : $defaultTo; $phpWord = new \PhpOffice\PhpWord\PhpWord(); // Every element you want to append to the word document is placed in a section. // To create a basic section: $section = $phpWord->addSection(); $defaultFont = $phpWord->addFontStyle('defaultFont', array('name' => 'Arial', 'size' => 12)); $documentHead = $phpWord->addFontStyle('documentHead', array('name' => 'Arial', 'size' => 18, 'color' => '44AA88', 'bold' => true)); $eventTitleFont = $phpWord->addFontStyle('eventTitle', array('name' => 'Arial', 'size' => 12, 'color' => '880000', 'bold' => true)); $linguagemStyle = $phpWord->addFontStyle('linguagemStyle', array('name' => 'Arial', 'size' => 12, 'color' => 'FF0000', 'bold' => true)); $linguagens = array('Cinema', 'Dança', 'Teatro', 'Música Popular', 'Música Erudita', 'Exposição', 'Curso ou Oficina', 'Palestra, Debate ou Encontro'); $section->addText('ROTEIRO GERAL (SITE) REVISTA', $documentHead); $getEventTextBlock = function ($event) use($app) { // return "TEXT {$event->name}"; $eventText = trim($event->shortDescription); if (!empty($event->classificacaoEtaria)) { $eventText .= $event->classificacaoEtaria; } $eventText .= '. '; // Group occurrences by space $spaces = array(); foreach ($event->occurrences as $occurrence) {
public function gera_word() { $this->load->library('word2'); // Set writers $writers = array('Word2007' => 'docx', 'ODText' => 'odt', 'RTF' => 'rtf', 'HTML' => 'html', 'PDF' => 'pdf'); // Set PDF renderer if (Settings::getPdfRendererPath() === null) { $writers['PDF'] = null; } // Return to the caller script when runs by CLI //if (CLI) { // return; //} // Set titles and names //$pageHeading = str_replace('_', ' ', SCRIPT_FILENAME); $pageHeading = "page heading"; //$pageTitle = IS_INDEX ? 'Welcome to ' : "{$pageHeading} - "; $pageTitle = "titulo da pagina"; //$pageTitle .= 'PHPWord'; //$pageHeading = IS_INDEX ? '' : "<h1>{$pageHeading}</h1>"; // Populate samples $files = ''; if ($handle = opendir('.')) { while (false !== ($file = readdir($handle))) { if (preg_match('/^Sample_\\d+_/', $file)) { $name = str_replace('_', ' ', preg_replace('/(Sample_|\\.php)/', '', $file)); $files .= "<li><a href='{$file}'>{$name}</a></li>"; } } closedir($handle); } //include_once 'Sample_Header.php'; require_once APPPATH . "third_party/PHPWord2/PhpWord.php"; // New Word Document echo date('H:i:s'), " Create new PhpWord object"; $phpWord = new \PhpOffice\PhpWord\PhpWord(); $phpWord->addFontStyle('rStyle', array('bold' => true, 'italic' => true, 'size' => 16, 'allCaps' => true, 'doubleStrikethrough' => true)); $phpWord->addParagraphStyle('pStyle', array('align' => 'center', 'spaceAfter' => 100)); $phpWord->addTitleStyle(1, array('bold' => true), array('spaceAfter' => 240)); // New portrait section $section = $phpWord->addSection(); // Simple text $section->addTitle('Welcome to PhpWord', 1); $section->addText('Hello World!'); // Two text break $section->addTextBreak(2); // Defined style $section->addText('I am styled by a font style definition.', 'rStyle'); $section->addText('I am styled by a paragraph style definition.', null, 'pStyle'); $section->addText('I am styled by both font and paragraph style.', 'rStyle', 'pStyle'); $section->addPageBreak(); // Inline font style $fontStyle['name'] = 'Times New Roman'; $fontStyle['size'] = 20; $fontStyle['bold'] = true; $fontStyle['italic'] = true; $fontStyle['underline'] = 'dash'; $fontStyle['strikethrough'] = true; $fontStyle['superScript'] = true; $fontStyle['color'] = 'FF0000'; $fontStyle['fgColor'] = 'yellow'; $fontStyle['smallCaps'] = true; $section->addText('I am inline styled.', $fontStyle); $section->addTextBreak(); // Link $section->addLink('http://www.google.com', 'Google'); $section->addTextBreak(); // Image //$section->addImage('resources/_earth.jpg', array('width'=>18, 'height'=>18)); // Save file //echo write($phpWord, basename(__FILE__, '.php'), $writers); //if (!CLI) { //include_once 'Sample_Footer.php'; // } // Save file echo $this->write($phpWord, basename(__FILE__, '.php'), $writers); if (!CLI) { //include_once 'Sample_Footer.php'; } }