public function postCancelar() { //return Input::all(); $this->response->Cancelar(Input::get('contratos'), Input::get('penaCapital'), Input::get('penaAccesorios'), Input::get('penaMoratorios'), Input::get('capital')); $cliente = DB::table('expediente')->where('id_expediente', Input::get('contratos'))->join('cliente', 'cliente.rfc', '=', 'expediente.fk_rfc')->select('cliente.nombre', 'cliente.ape_mate', 'cliente.ape_pate')->get()[0]; $terreno = DB::table('expediente')->where('id_expediente', Input::get('contratos'))->join('solicitud', 'solicitud.fk_expediente', '=', 'expediente.id_expediente')->join('lote', 'lote.id_lote', '=', 'solicitud.fk_lote')->join('manzana', 'manzana.id_manzana', '=', 'lote.fk_manzana')->join('desarrollo', 'desarrollo.id_desarrollo', '=', 'manzana.fk_desarrollo')->select('lote.lote', 'manzana.num_letra', 'desarrollo.nombre')->get()[0]; if (Input::get('capital') - Input::get('penaCapital') > 0) { $ImporteLiquido = Input::get('capital') - Input::get('penaCapital'); } else { $ImporteLiquido = 0; } $PHPWord = new PHPWord(); $document = $PHPWord->loadTemplate(dirname(__FILE__) . '/PHPWord/recibo_liquidacion.docx'); $fecha = explode('-', date('Y-m-d')); $document->setValue('dia', $fecha[2]); $document->setValue('mes', $fecha[1]); $document->setValue('anio', $fecha[0]); $document->setValue('cantidadDevuelta', '$' . $ImporteLiquido); $document->setValue('expediente', Input::get('contratos')); $document->setValue('Terreno', $terreno->lote); $document->setValue('Manzana', $terreno->num_letra); $document->setValue('Fraccionamiento', $terreno->nombre); $document->setValue('Penalizacion', Input::get('penalizacionCapital') . '%'); $document->setValue('PrecioVenta', '$' . Input::get('importeTotal')); $document->setValue('CapitalPagado', '$' . Input::get('capital')); $document->setValue('cantidadPenal', '$' . Input::get('penaCapital')); $document->setValue('ImporteLiquido', '$' . $ImporteLiquido); $document->setValue('Cliente', $cliente->nombre . " " . $cliente->ape_pate . " " . $cliente->ape_mate); $document->save(Input::get('contratos') . '_cancelacion.docx'); return View::make('cobranza/mensajeCobranza')->with('datos', array('seccion' => 'SICyA | Cobranza | Cancealr Terreno', 'cabecera' => 'Cancelando Contrato', 'icono' => 'glyphicon glyphicon-file', 'tipo_mensaje' => true, 'mensaje' => "Se ha Cancelado el Contrato.")); }
// Array Hari $array_hari = array(1 => 'Senin', 'Selasa', 'Rabu', 'Kamis', 'Jumat', 'Sabtu', 'Minggu'); $hari = $array_hari[date('N')]; //Format Tanggal $tanggal = date('j'); //Array Bulan $array_bulan = array(1 => 'Januari', 'Februari', 'Maret', 'April', 'Mei', 'Juni', 'Juli', 'Agustus', 'September', 'Oktober', 'November', 'Desember'); $bulan = $array_bulan[date('n')]; //Format Tahun $tahun = date('Y'); $bilangan = new Terbilang(); // Include the PHPWord.php, all other classes were loaded by an autoloader include '../../../../../plugin/PHPWord.php'; // Create a new PHPWord Object $PHPWord = new PHPWord(); $document = $PHPWord->loadTemplate('../../../../../config/Template/Amplop.docx'); $document->setValue('nama_pembeli', $nama_pembeli); $document->setValue('alamat', $alamat); $document->setValue('telepon', $tlp1); $path = 'E:\\'; $nama_file = "AMPLOP PPJB " . $nama_pembeli . " " . $tanggal . " " . $bulan . " " . $tahun . ".doc"; // $document->save('E:\\andonnikahTemplate.docx'); //$document->save('E:\\'.$nama_file); // At least write the document to webspace: $objWriter = PHPWord_IOFactory::createWriter($PHPWord, 'Word2007'); // // save as a random file in temp file $temp_file = tempnam(sys_get_temp_dir(), 'PHPWord'); $document->save($temp_file); // Your browser will name the file "myFile.docx" // regardless of what it's named on the server header("Content-Disposition: attachment; filename=\"" . basename($nama_file) . "\"");
/** * Executes index action * * @param sfRequest $request A request object */ public function executeIndex(sfWebRequest $request) { // Recuperar el Tramite y el Proceso $this->setLayout('descarga'); $template = Doctrine::getTable('ClaDocumentos')->findOneByClaTramiteIdAndClaProcesoId($request->getParameter('tramite'), $request->getParameter('proceso')); $seguimiento = Doctrine::getTable('ProcSeguimiento')->getTramite($request->getParameter('seguimiento')); $PHPWord = new PHPWord(); $filename = 'carta_' . $request->getParameter('tramite') . '_' . $request->getParameter('proceso') . '.docx'; $document = $PHPWord->loadTemplate(sfConfig::get('sf_root_dir') . '/archivos/templates/' . $template->getPath()); date_default_timezone_set('America/La_Paz'); setlocale(LC_TIME, 'spanish'); $document->setValue('fecha_carta', strftime("%d de %B de %Y")); foreach ($seguimiento->ProcFormularios as $formulario) { $tabla = Doctrine::getTable($formulario->ClaTabla->getDescripcion())->findOneById($formulario->getGetId()); if ($formulario->ClaTabla->getDescripcion() == 'DatPersonas') { $document->setValue('nombre_estudiante', $tabla->getNombreCompleto()); } } $document->save(sfConfig::get('sf_root_dir') . '/archivos/generados/' . $filename); // $guardar = new ClaDocumentos(); // $guardar->setClaTramiteId(1); // $guardar->setClaProcesoId(1); // $guardar->setPath($filename); // $guardar->save(); $this->filename = $filename; $this->enlace = sfConfig::get('sf_root_dir') . '/archivos/generados//' . $filename; }
/** * create new excel document * * @return void */ protected function _createDocument() { // this looks stupid, but the PHPDoc library is beta, so this is needed. otherwise the lib would create temp files in the template folder ;( $templateFile = $this->_getTemplateFilename(); $tempTemplateFile = Tinebase_Core::guessTempDir() . DIRECTORY_SEPARATOR . Tinebase_Record_Abstract::generateUID() . '.docx'; copy($templateFile, $tempTemplateFile); $this->_docObject = new PHPWord(); if ($templateFile !== NULL) { $this->_docTemplate = $this->_docObject->loadTemplate($tempTemplateFile); } unlink($tempTemplateFile); }
function createDoc($name = null) { $PHPWord = new PHPWord(); //return; $this->getData(); $template = $PHPWord->loadTemplate($this->modelliDir . $this->modello); foreach ($this->data as $tb => $data) { foreach ($data as $col => $val) { try { $val = mb_detect_encoding($val) == 'UTF-8' ? utf8_decode($val) : $val; $template->setValue("{$tb}.{$col}", $val); } catch (Exception $e) { echo "<p>{$tb}.{$col}</p>"; } } } $template->setValue("data", date("d/m/Y")); $pr = new pratica($this->pratica); $file = $name ? $pr->documenti . $name : $pr->documenti . $this->docName; $template->save($file); }
public Function GeraArquivoDoc() { $PHPWord = new PHPWord(); $arquivo_clinica = "../../../sgmo/laudo_modelo/$MY_PARAMETRO_ID/normal/$arquivo_laudo"; $document = $PHPWord->loadTemplate($arquivo_clinica); //caso seja necessário preencher o cabeçalho com os dados da clínica $document->setValue('nome_emp', " $clinica_rs"); $document->setValue('cnpj_emp', " $clinica_cnpj"); $document->setValue('rua_emp', " $endereco"); $document->setValue('tel_emp', " $tel_clinica"); $document->setValue('cidade_emp', " $cidade"); $document->setValue('estado_emp', " $estado"); //Dados do funcinário para preencher o cabeçalho $document->setValue('nome_func', " $funcionario"); $document->setValue('doc_func', " $doc_funcionario"); $document->setValue('empresa_func', " $empresa"); $document->setValue('dat_func', " $data_nascimento"); $document->setValue('func_funcionario', " $funcao"); $document->setValue('idade_func', " $idade"); $document->setValue('tel_func', " $telefone"); $document->setValue('idade_func', " $idade"); $document->setValue('data_exame_func', " $data_exame"); $document->setValue('medico_solicitante', " "); $document->setValue('medico_solicitante', " "); $document->setValue('convenio_func', " $clinica_rs"); $document->setValue('observacao', " XXXXXXXXXXXXXXXXXXXXXX"); //Marcações no documento $document->setValue('nx', "X"); $nome_arquivo = $funcionario . "_" . $numero_ficha; $arquivo = "laudados/" . removerAcento($nome_arquivo) . ".docx"; $document->save($arquivo); }
function htmltoword() { import('@.ORG.PHPWord', '', $ext = '.php'); $PHPWord = new PHPWord(); $content = <<<code \t<table cellspacing="0" cellpadding="0"><tbody><tr class="firstRow"><td width="95" valign="top" style="border: 1px solid windowtext; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td></tr><tr><td width="95" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;" rowspan="3"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr><td width="95" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px; word-break: break-all;">​<br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;" rowspan="3"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr><td width="95" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr><td width="95" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="189" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;" rowspan="2" colspan="2"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr><td width="95" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr><td width="95" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="95" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr></tbody></table> \t\t<table cellspacing="0" cellpadding="0"><tbody><tr class="firstRow"><td width="142" valign="top" style="border: 1px solid windowtext; padding: 0px 7px;" rowspan="3"><p class="edit-text">11111</p></td><td width="142" valign="top" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td></tr><tr><td width="426" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;" colspan="3"><p class="edit-text">444444</p></td></tr><tr><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr><td width="142" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr><td width="142" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;" rowspan="2"><p class="edit-text">22222</p></td><td width="426" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;" colspan="3"><p class="edit-text">33333</p></td></tr><tr><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr><td width="142" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr><td width="142" valign="top" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td><td width="142" valign="top" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0px 7px;"><br></td></tr></tbody></table> code; $content = <<<code <table width="100" cellspacing="0" cellpadding="0"><tbody><tr class="firstRow"><td width="2" style="border: 1px solid black; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;" rowspan="3"><p style="text-align:center"><strong><span style="font-family:宋体">接口名称</span></strong></p></td><td width="41" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;" colspan="3"><p style="text-align:center"><strong><span style="font-family:宋体">源头数据库</span>(From)</strong></p></td><td width="45" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;" colspan="3"><p style="text-align:center"><strong><span style="font-family:宋体">目标数据库</span>(To)</strong></p></td><td width="10" valign="top" style="border-width: 1px 1px 1px medium; border-style: solid solid solid none; border-color: black black black -moz-use-text-color; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;" rowspan="3"><p style="text-align:center"><strong><span style="font-family:宋体">说明</span></strong></p></td></tr><tr><td width="41" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;" colspan="3"><p style="text-align:left"><strong><span style="font-family:宋体">地址:</span>192.168.0.237</strong></p><p style="text-align:left"><strong><span style="font-family:宋体">数据库:</span>nydbexec</strong></p><p style="text-align:left"><strong><span style="font-family:宋体">端口:</span></strong></p><p style="text-align:left"><strong><span style="font-family:宋体">账号:</span>root</strong></p><p style="text-align:left"><strong><span style="font-family:宋体">密码:</span>tml123456</strong></p></td><td width="45" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;" colspan="3"><p style="text-align:left"><strong><span style="font-family:宋体">地址:</span>192.168.0.100</strong></p><p style="text-align:left"><strong><span style="font-family:宋体">数据库:</span>ufdata_101_2015</strong></p><p style="text-align:left"><strong><span style="font-family:宋体">端口:</span></strong></p><p style="text-align:left"><strong><span style="font-family:宋体">账号:</span>sa</strong></p><p style="text-align:left"><strong><span style="font-family:宋体">密码:</span></strong></p></td></tr><tr><td width="5" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;"><p style="text-align:center"><strong><span style="font-family:宋体">数据库表</span></strong></p></td><td width="5" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;"><p style="text-align:center"><strong><span style="font-family:宋体">属性</span></strong></p></td><td width="30" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;"><p style="text-align:center"><strong><span style="font-family:宋体">其他</span></strong></p></td><td width="2" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;"><p style="text-align:center"><strong><span style="font-family:宋体">数据库表</span></strong></p></td><td width="3" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;"><p style="text-align:center"><strong><span style="font-family:宋体">属性</span></strong></p></td><td width="39" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; background: rgb(242, 242, 242) none repeat scroll 0% 0%; padding: 0px 7px;"><p style="text-align:center"><strong><span style="font-family:宋体">其他</span></strong></p></td></tr><tr style=";height:120px"><td width="2" valign="top" height="120" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color black black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><p><span style="font-family: 宋体">薪资接口:</span></p><p><span style="font-family: 宋体">按需同步</span> <span style="font-family:宋体">按年份</span>+<span style="font-family:宋体">月份同步</span> <span style="font-family:宋体">,</span>pmp<span style="font-family:宋体">存出过程会按年份</span>+<span style="font-family:宋体">月份删除即将同步数据</span></p></td><td width="5" valign="top" height="120" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>U8<span style="font-family:宋体">数据源视图:</span> pmpgzview</p><p> </p></td><td width="5" valign="top" height="120" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>gzlbinfo.cgzdlname as <span style="font-family:宋体">工资大类</span>,</p><p>WA_GZData.cgzgradenum as <span style="font-family:宋体">类别编码</span>,</p><p>gzlbinfo.cgzgradename as <span style="font-family:宋体">类别名称</span>,</p><p>WA_GZData.cpsn_num AS <span style="font-family:宋体">人员编码</span> ,</p><p>hr_hi_person.cpsn_name as <span style="font-family:宋体">人员名称</span>,</p><p>WA_GZData.cDept_Num AS <span style="font-family:宋体">部门编码</span> ,</p><p>Department.cdepname as <span style="font-family:宋体">部门名称</span>,</p><p>WA_GZData.iPsnGrd_id AS iPsnGrd_id ,</p><p>WA_GZData.iYear AS <span style="font-family:宋体">年份</span> ,</p><p>iMonth AS <span style="font-family:宋体">月份</span> ,</p><p>iAccMonth AS iAccMonth ,</p><p>F_1 AS <span style="font-family:宋体">应发合计</span> ,</p><p>F_2 AS <span style="font-family:宋体">扣款合计</span> ,</p><p>F_3 AS <span style="font-family:宋体">实发合计</span> ,</p><p>F_4 AS <span style="font-family:宋体">本月扣零</span> ,</p><p>F_5 AS <span style="font-family:宋体">上月扣零</span> ,</p><p>F_6 AS <span style="font-family:宋体">代扣税</span> ,</p><p>F_7 AS <span style="font-family:宋体">计件工资</span> ,</p><p>WA_GZData.bLastFlag AS bLastFlag ,</p><p>WA_GZData.vStatus1 AS vStatus1 ,</p><p>WA_GZData.nStatus2 AS nStatus2 ,</p><p>WA_GZData.iRecordID AS iRecordID ,</p><p>F_1000 AS <span style="font-family:宋体">代付税</span> ,</p><p>F_1001 AS <span style="font-family:宋体">年终奖</span> ,</p><p>F_1002 AS <span style="font-family:宋体">年终奖代扣税</span> ,</p><p>F_1003 AS <span style="font-family:宋体">工资代扣税</span> ,</p><p>F_1004 AS <span style="font-family:宋体">扣税合计</span> ,</p><p>F_1005 AS <span style="font-family:宋体">年终奖代付税</span> ,</p><p>F_1006 AS <span style="font-family:宋体">工资代付税</span> ,</p><p>F_8 AS <span style="font-family:宋体">工资级别</span> ,</p><p>F_9 AS <span style="font-family:宋体">工资序列</span> ,</p><p>F_10 AS <span style="font-family:宋体">工资等级</span> ,</p><p>F_11 AS <span style="font-family:宋体">工资档次</span> ,</p><p>F_12 AS <span style="font-family:宋体">年岗位技能工资</span> ,</p><p>F_13 AS <span style="font-family:宋体">月工资</span> ,</p><p>F_14 AS <span style="font-family:宋体">月基薪</span> ,</p><p>F_15 AS <span style="font-family:宋体">月绩效</span> ,</p><p>F_16 AS <span style="font-family:宋体">年功工资</span> ,</p><p>F_17 AS <span style="font-family:宋体">加班工资</span> ,</p><p>F_18 AS <span style="font-family:宋体">月预扣风险金</span> ,</p><p>F_19 AS <span style="font-family:宋体">社保基数</span> ,</p><p>F_20 AS <span style="font-family:宋体">公积金基数</span> ,</p><p>F_21 AS <span style="font-family:宋体">养老保险金</span> ,</p><p>F_22 AS <span style="font-family:宋体">医疗保险金</span> ,</p><p>F_23 AS <span style="font-family:宋体">失业保险金</span> ,</p><p>F_24 AS <span style="font-family:宋体">生育保险金</span> ,</p><p>F_25 AS <span style="font-family:宋体">住房公积金</span> ,</p><p>F_26 AS <span style="font-family:宋体">社保调整</span> ,</p><p>F_27 AS <span style="font-family:宋体">计税金额</span> ,</p><p>F_28 AS <span style="font-family:宋体">其他免税项目</span> ,</p><p>F_29 AS <span style="font-family:宋体">应发小计</span> ,</p><p>F_30 AS <span style="font-family:宋体">通讯费扣款</span> ,</p><p>F_31 AS <span style="font-family:宋体">五险一金扣款</span> ,</p><p>F_32 AS <span style="font-family:宋体">病事缺扣款</span> ,</p><p>F_33 AS <span style="font-family:宋体">迟到扣款</span> ,</p><p>F_34 AS <span style="font-family:宋体">上月校错</span> ,</p><p>F_35 AS <span style="font-family:宋体">车贴</span> ,</p><p>F_36 AS <span style="font-family:宋体">财务挂账</span> ,</p><p>F_37 AS <span style="font-family:宋体">消财务挂账</span> ,</p><p>F_38 AS <span style="font-family:宋体">扣款小计</span> ,</p><p>F_39 AS <span style="font-family:宋体">一次性绩效发放</span> ,</p><p>F_40 AS <span style="font-family:宋体">季度绩效补差</span> ,</p><p>F_41 AS <span style="font-family:宋体">风险金调差</span> ,</p><p>F_42 AS <span style="font-family:宋体">本月实际计薪天数</span> ,</p><p>F_43 AS <span style="font-family:宋体">返风险金</span> ,</p><p>F_44 AS <span style="font-family:宋体">实习补助标准</span> ,</p><p>F_45 AS <span style="font-family:宋体">本月出勤率</span> ,</p><p>F_46 AS <span style="font-family:宋体">绩效考勤等级</span> ,</p><p>F_47 AS <span style="font-family:宋体">绩效摊销</span> ,</p><p>F_48 AS <span style="font-family:宋体">创新先进个人奖励</span> ,</p><p>F_49 AS <span style="font-family:宋体">缺勤天数</span> ,</p><p>F_50 AS <span style="font-family:宋体">平时加班天数</span> ,</p><p>F_51 AS <span style="font-family:宋体">迟到次数</span> ,</p><p>F_52 AS <span style="font-family:宋体">周末加班天数</span> ,</p><p>F_53 AS <span style="font-family:宋体">节假日加班天数</span></p></td><td width="30" valign="top" height="120" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p><span style="font-family: 宋体">调用实例:</span></p><p>CALL `pmpxzin` ( -- pmp <span style="font-family:宋体">平台的数据接口</span></p><p>'001', -- <span style="font-family:宋体">工资大类</span></p><p>'001' , -- <span style="font-family:宋体">类别编码</span></p><p>'<span style="font-family:宋体">基本工资</span>' , -- <span style="font-family: 宋体">类别名称</span></p><p>'100001', -- <span style="font-family:宋体">人员编码</span></p><p>2 , -- <span style="font-family:宋体">部门编码</span></p><p>NULL , -- iPsnGrd_id</p><p>NULL , -- iPsnAmt</p><p>2015 , -- <span style="font-family:宋体">年份</span></p><p>8, -- <span style="font-family:宋体">月份</span></p><p>NULL , -- iAccMonth</p><p>3882.44 , -- <span style="font-family: 宋体">应发合计</span> </p><p>283.838 , -- <span style="font-family: 宋体">扣款合计</span> </p><p>4883.83 , -- <span style="font-family: 宋体">实发合计</span> </p><p>789.38 , -- <span style="font-family: 宋体">本月扣零</span> </p><p>483.83 , -- <span style="font-family: 宋体">上月扣零</span> </p><p>38.83 , -- <span style="font-family: 宋体">代扣税</span> </p><p>448 , -- <span style="font-family: 宋体">计件工资</span> </p><p>NULL , -- bLastFlag</p><p>NULL , -- vStatus1</p><p>NULL , -- nStatus2</p><p>NULL , -- iRecordID</p><p>38.3 , -- <span style="font-family: 宋体">代付税</span> </p><p>3448.38 , -- <span style="font-family: 宋体">年终奖</span> </p><p>32.23 , -- <span style="font-family: 宋体">年终奖代扣税</span> </p><p>449.3 , -- <span style="font-family: 宋体">工资代扣税</span> </p><p>22.82 , -- <span style="font-family: 宋体">扣税合计</span> </p><p>382.3 , -- <span style="font-family: 宋体">年终奖代付税</span> </p><p>373.8 , -- <span style="font-family: 宋体">工资代付税</span> </p><p>1 , -- <span style="font-family: 宋体">工资级别</span> </p><p>2 , -- <span style="font-family: 宋体">工资序列</span> </p><p>3 , -- <span style="font-family: 宋体">工资等级</span> </p><p>4 , -- <span style="font-family: 宋体">工资档次</span> </p><p>5 , -- <span style="font-family: 宋体">年岗位技能工资</span> </p><p>8000 , -- <span style="font-family: 宋体">月工资</span> </p><p>4000 , -- <span style="font-family: 宋体">月基薪</span> </p><p>2000 , -- <span style="font-family: 宋体">月绩效</span> </p><p>283.83 , -- <span style="font-family: 宋体">年功工资</span> </p><p>44.38 , -- <span style="font-family: 宋体">加班工资</span> </p><p>4.38 , -- <span style="font-family: 宋体">月预扣风险金</span> </p><p>34.82 , -- <span style="font-family: 宋体">社保基数</span> </p><p>44.83 , -- <span style="font-family: 宋体">公积金基数</span> </p><p>442.83 , -- <span style="font-family: 宋体">养老保险金</span> </p><p>32 , -- <span style="font-family: 宋体">医疗保险金</span> </p><p>443.8 , -- <span style="font-family: 宋体">失业保险金</span> </p><p>44.38 , -- <span style="font-family: 宋体">生育保险金</span> </p><p>33.38 , -- <span style="font-family: 宋体">住房公积金</span> </p><p>44.38 , -- <span style="font-family: 宋体">社保调整</span> </p><p>1903.8, -- <span style="font-family:宋体">计税金额</span> </p><p>43.11, -- <span style="font-family:宋体">其他免税项目</span> </p><p>7889.34, -- <span style="font-family:宋体">应发小计</span> </p><p>48.3, -- <span style="font-family:宋体">通讯费扣款</span> </p><p>889.2, -- <span style="font-family:宋体">五险一金扣款</span> </p><p>37.38, -- <span style="font-family:宋体">病事缺扣款</span> </p><p>28.77, -- <span style="font-family:宋体">迟到扣款</span> </p><p>12.38, -- <span style="font-family:宋体">上月校错</span> </p><p>1500, -- <span style="font-family:宋体">车贴</span> </p><p>38.84, -- <span style="font-family:宋体">财务挂账</span> </p><p>38.83, -- <span style="font-family:宋体">消财务挂账</span> </p><p>503.38, -- <span style="font-family:宋体">扣款小计</span> </p><p>3834.2, -- <span style="font-family:宋体">一次性绩效发放</span> </p><p>889.43, -- <span style="font-family:宋体">季度绩效补差</span></p><p>48.38, -- <span style="font-family:宋体">风险金调差</span></p><p>28, -- <span style="font-family:宋体">本月实际计薪天数</span></p><p>238.48, -- <span style="font-family:宋体">返风险金</span></p><p>1000, -- <span style="font-family:宋体">实习补助标准</span></p><p>100, -- <span style="font-family:宋体">本月出勤率</span></p><p>2, -- <span style="font-family:宋体">绩效考勤等级</span></p><p>448.38, -- <span style="font-family:宋体">绩效摊销</span></p><p>343.28, -- <span style="font-family:宋体">创新先进个人奖励</span></p><p>13, -- <span style="font-family:宋体">缺勤天数</span></p><p>12, -- <span style="font-family:宋体">平时加班天数</span></p><p>11, -- <span style="font-family:宋体">迟到次数</span></p><p>22, -- <span style="font-family:宋体">周末加班天数</span></p><p>24 -- <span style="font-family:宋体">节假日加班天数</span></p><p>)</p></td><td width="2" valign="top" height="120" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>Pmp<span style="font-family:宋体">目标</span></p><p><span style="font-family: 宋体">存出过程:</span> pmpxzin</p></td><td width="3" valign="top" height="120" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>cgzdlname, -- <span style="font-family:宋体">工资大类</span></p><p>cgzgradenum , -- <span style="font-family:宋体">类别编码</span></p><p>cgzgradename , -- <span style="font-family:宋体">类别名称</span></p><p>cpsnnum , -- <span style="font-family:宋体">人员编码</span></p><p>cDeptNum , -- <span style="font-family:宋体">部门编码</span></p><p>iYear , -- <span style="font-family:宋体">年份</span></p><p>iMonth , -- <span style="font-family:宋体">月份</span></p><p>yingfaheji , -- <span style="font-family: 宋体">应发合计</span> </p><p>koukuanheji , -- <span style="font-family: 宋体">扣款合计</span> </p><p>shifaheji , -- <span style="font-family: 宋体">实发合计</span> </p><p>benyuekouling , -- <span style="font-family: 宋体">本月扣零</span> </p><p>shangyuekouling , -- <span style="font-family: 宋体">上月扣零</span> </p><p>daikoushui , -- <span style="font-family: 宋体">代扣税</span> </p><p>jijiangongzi , -- <span style="font-family: 宋体">计件工资</span> </p><p>daifushui , -- <span style="font-family: 宋体">代付税</span> </p><p>nianzhongjiang , -- <span style="font-family: 宋体">年终奖</span> </p><p>nianzhongjiangdaikou , -- <span style="font-family: 宋体">年终奖代扣税</span> </p><p>gongzidaikoushui , -- <span style="font-family: 宋体">工资代扣税</span> </p><p>koushuiheji , -- <span style="font-family: 宋体">扣税合计</span> </p><p>nianzhongjiangdaifus , -- <span style="font-family: 宋体">年终奖代付税</span> </p><p>gongzidaifushui , -- <span style="font-family: 宋体">工资代付税</span> </p><p>gongzijibie , -- <span style="font-family: 宋体">工资级别</span> </p><p>gongzixulie , -- <span style="font-family: 宋体">工资序列</span> </p><p>gongzidengji , -- <span style="font-family: 宋体">工资等级</span> </p><p>gongzidangci , -- <span style="font-family: 宋体">工资档次</span> </p><p>niangangweijinengong , -- <span style="font-family: 宋体">年岗位技能工资</span> </p><p>yuegongzi , -- <span style="font-family: 宋体">月工资</span> </p><p>yuejixin , -- <span style="font-family: 宋体">月基薪</span> </p><p>yuejixiao , -- <span style="font-family: 宋体">月绩效</span> </p><p>niangonggongzi , -- <span style="font-family: 宋体">年功工资</span> </p><p>jiabangongzi , -- <span style="font-family: 宋体">加班工资</span> </p><p>yueyukoufengxianjin , -- <span style="font-family: 宋体">月预扣风险金</span> </p><p>shebaojishu , -- <span style="font-family: 宋体">社保基数</span> </p><p>gongjijinjishu , -- <span style="font-family: 宋体">公积金基数</span> </p><p>yanglaobaoxianjin , -- <span style="font-family: 宋体">养老保险金</span> </p><p>yiliaobaoxianjin , -- <span style="font-family: 宋体">医疗保险金</span> </p><p>shiyebaoxianjin , -- <span style="font-family: 宋体">失业保险金</span> </p><p>shengyubaoxianjin , -- <span style="font-family: 宋体">生育保险金</span> </p><p>zhufanggongjijin , -- <span style="font-family: 宋体">住房公积金</span> </p><p>shebaodiaozheng , -- <span style="font-family: 宋体">社保调整</span> </p><p>jishuijine , -- <span style="font-family: 宋体">计税金额</span> </p><p>qitamianshuixiangmu , -- <span style="font-family: 宋体">其他免税项目</span> </p><p>yingfaxiaoji , -- <span style="font-family: 宋体">应发小计</span> </p><p>tongxunfeikoukuan , -- <span style="font-family: 宋体">通讯费扣款</span> </p><p>wuxianyijinkoukuan , -- <span style="font-family: 宋体">五险一金扣款</span> </p><p>bingshiquekoukuan , -- <span style="font-family: 宋体">病事缺扣款</span> </p><p>chidaokoukuan , -- <span style="font-family: 宋体">迟到扣款</span> </p><p>shangyuexiaocuo , -- <span style="font-family: 宋体">上月校错</span> </p><p>chetie , -- <span style="font-family: 宋体">车贴</span> </p><p>caiwuguazhang , -- <span style="font-family: 宋体">财务挂账</span> </p><p>xiaocaiwuguazhang , -- <span style="font-family: 宋体">消财务挂账</span> </p><p>koukuanxiaoji , -- <span style="font-family: 宋体">扣款小计</span> </p><p>yicixingjixiaofafang , -- <span style="font-family: 宋体">一次性绩效发放</span> </p><p>jidujixiaobucha , -- <span style="font-family:宋体">季度绩效补差</span></p><p>fengxianjindiaocha , -- <span style="font-family:宋体">风险金调差</span></p><p>benyueshijijixintian , -- <span style="font-family:宋体">本月实际计薪天数</span></p><p>fanfengxianjin , -- <span style="font-family:宋体">返风险金</span></p><p>shixibuzhubiaozhun , -- <span style="font-family:宋体">实习补助标准</span></p><p>benyuechuqinlv , -- <span style="font-family:宋体">本月出勤率</span></p><p>jixiaokaoqindengji , -- <span style="font-family:宋体">绩效考勤等级</span></p><p>jixiaotanxiao , -- <span style="font-family:宋体">绩效摊销</span></p><p>chuangxinxianjingere , -- <span style="font-family:宋体">创新先进个人奖励</span></p><p>queqintianshu , -- <span style="font-family:宋体">缺勤天数</span></p><p>pingshijiabantianshu , -- <span style="font-family:宋体">平时加班天数</span></p><p>chidaocishu , -- <span style="font-family:宋体">迟到次数</span></p><p>zhoumojiabantianshu , -- <span style="font-family:宋体">周末加班天数</span></p><p>jiejiarijiabantiansh -- <span style="font-family:宋体">节假日加班天数</span></p><p><span style="font-family: 宋体">(</span>67<span style="font-family:宋体">个字段)</span></p></td><td width="39" valign="top" height="120" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><br></td><td width="10" valign="top" height="120" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr style=";height:216px"><td width="2" valign="top" height="216" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color black black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><p><span style="font-family: 宋体">请假同步:</span></p><p>Pmp<span style="font-family:宋体">请假单终审后传递到</span>u8</p></td><td width="5" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>Pmp<span style="font-family:宋体">数据源视图:</span> pmpqjsurview</p></td><td width="5" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>yongyouorderno` AS <span style="font-family:宋体">创建人编码</span>,</p><p>mis_auto_ucjcm.`jieshuriqi AS <span style="font-family:宋体">结束时间</span>,</p><p> mis_auto_dtics.`u8leixingbianma` AS <span style="font-family:宋体">请假类型</span>,</p><p> ryinfoshenhe.name AS <span style="font-family:宋体">批准人</span>,</p><p> ryinfo.`name` AS <span style="font-family:宋体">创建人名</span>,</p><p> mis_auto_ucjcm.`kaishiriqi` AS <span style="font-family:宋体">开始时间</span>,</p><p>FROM_UNIXTIME(mis_auto_ucjcm.`createtime`,'%Y-%m-%d %H:%i:%s') AS <span style="font-family:宋体">创建时间</span>,</p><p> ryinfoqingjr.yongyouorderno AS <span style="font-family:宋体">请假人编码</span>,</p><p> mis_auto_ucjcm.qingjiashiyou AS <span style="font-family:宋体">请假原因</span>,</p><p> '' AS <span style="font-family:宋体">备注</span>,</p><p> mis_auto_ucjcm.`kaishiriqi` AS <span style="font-family:宋体">计划时间</span>,</p><p> ryinfoshenhe.yongyouorderno AS <span style="font-family:宋体">审核人编码</span>,</p><p> ryinfoshenhe.name AS <span style="font-family:宋体">审核人</span>,</p><p> process_info_history.`dotime` AS <span style="font-family:宋体">审核时间</span> ,</p><p>(CASE WHEN mis_auto_ucjcm.status=1 THEN '<span style="font-family:宋体">否</span>'</p><p> WHEN mis_auto_ucjcm.status=0 THEN '<span style="font-family:宋体">是</span>'</p><p> END ) AS <span style="font-family:宋体">审核状态</span></p><p> </p></td><td width="30" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p><span style="font-family: 宋体">调用实例:</span></p><p> </p><p>exec pmpqjwsc -- <span style="font-family:宋体">请假存储过程</span> <span style="font-family:宋体">调试</span></p><p> '100005', -- <span style="font-family:宋体">创建人编码</span></p><p> '2015-07-31 17:00' , -- <span style="font-family:宋体">结束时间</span> </p><p> 'BS00' , -- <span style="font-family:宋体">请假类型</span></p><p> '<span style="font-family:宋体">批准人名</span>' , -- <span style="font-family:宋体">批准人</span></p><p> '<span style="font-family:宋体">周庆红</span>' , -- <span style="font-family:宋体">创建人名</span></p><p> '2015-07-31 17:00' , -- <span style="font-family:宋体">开始日期</span> </p><p> '2015-07-31 17:00' , -- <span style="font-family:宋体">创建日期</span> </p><p> '100005' , --<span style="font-family:宋体">请假人编码</span></p><p> '<span style="font-family:宋体">请假原因</span>' , -- <span style="font-family:宋体">请假原因</span></p><p> ' <span style="font-family:宋体">备注说明</span> ' , --<span style="font-family:宋体">备注</span> </p><p> '2015-07-31 17:00' ,--<span style="font-family:宋体">计划时间</span></p><p> '100005' , -- <span style="font-family: 宋体">审核人编码</span> </p><p> '<span style="font-family:宋体">周庆红</span>' , -- <span style="font-family:宋体">审核人</span> </p><p> '2015-07-31 17:00' , -- <span style="font-family:宋体">审核时间</span> </p><p> 1 -- <span style="font-family:宋体">审核状态</span></p><p> </p><p> </p></td><td width="2" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p><span style="font-family: 宋体">目标:</span>U8<span style="font-family:宋体">存出过程</span> pmpqjwsc</p></td><td width="3" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>exec pmpqjwsc -- <span style="font-family:宋体">请假存储过程</span> <span style="font-family:宋体">调试</span></p><p> '100005', -- <span style="font-family:宋体">创建人编码</span></p><p> '2015-07-31 17:00' , -- <span style="font-family:宋体">结束时间</span> </p><p> 'BS00' , -- <span style="font-family:宋体">请假类型</span></p><p> '<span style="font-family:宋体">批准人名</span>' , -- <span style="font-family:宋体">批准人</span></p><p> '<span style="font-family:宋体">周庆红</span>' , -- <span style="font-family:宋体">创建人名</span></p><p> '2015-07-31 17:00' , -- <span style="font-family:宋体">开始日期</span> </p><p> '2015-07-31 17:00' , -- <span style="font-family:宋体">创建日期</span> </p><p> '100005' , -- <span style="font-family:宋体">请假人</span></p><p> '<span style="font-family:宋体">请假原因</span>' , -- <span style="font-family:宋体">请假原因</span></p><p> ' <span style="font-family:宋体">备注说明</span> ' , --<span style="font-family:宋体">备注</span> </p><p> '2015-07-31 17:00' ,--<span style="font-family:宋体">计划时间</span></p><p> '100005' , -- <span style="font-family: 宋体">审核人编码</span> </p><p> '<span style="font-family:宋体">周庆红</span>' , -- <span style="font-family:宋体">审核人</span> </p><p> '2015-07-31 17:00' , -- <span style="font-family:宋体">审核时间</span> </p><p> 1</p></td><td width="39" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><br></td><td width="10" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><br></td></tr><tr style=";height:216px"><td width="2" valign="top" height="216" style="border-width: medium 1px 1px; border-style: none solid solid; border-color: -moz-use-text-color black black; -moz-border-top-colors: none; -moz-border-right-colors: none; -moz-border-bottom-colors: none; -moz-border-left-colors: none; border-image: none; padding: 0px 7px;"><p><span style="font-family: 宋体">出差同步:</span></p><p>Pmp<span style="font-family:宋体">出差终审后传递到</span>u8</p></td><td width="5" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>Pmp<span style="font-family:宋体">数据源视图:</span> pmpccsurview</p></td><td width="5" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>ryinfo.yongyouorderno AS <span style="font-family:宋体">创建人编码</span>,</p><p>mis_auto_xeyis.`chuchajieshuoriqi` AS <span style="font-family:宋体">结束时间</span>,</p><p>ryinfochuc.`name`AS <span style="font-family:宋体">批准人</span>,</p><p>ryinfo.`name` AS <span style="font-family:宋体">创建人</span>,</p><p>mis_auto_xeyis.chuchakaishiriqi AS <span style="font-family:宋体">开始时间</span>,</p><p>mis_auto_xeyis.`createtime` AS <span style="font-family:宋体">创建时间</span>,</p><p>ryinfochucr.yongyouorderno AS <span style="font-family:宋体">出差人编码</span>,</p><p>mis_auto_vqzzh.`name` AS <span style="font-family:宋体">出差类型</span>,</p><p> mis_auto_xeyis.chuchashiyou AS <span style="font-family:宋体">出差事由</span>,</p><p> '' AS <span style="font-family:宋体">备注</span>,</p><p>ryinfochuc.`name` AS <span style="font-family:宋体">审核人名</span>,</p><p>process_info_history.`dotime` AS <span style="font-family:宋体">审核时间</span>,</p><p>(CASE WHEN mis_auto_xeyis.`status`='0' THEN '<span style="font-family:宋体">是</span>'</p><p> WHEN mis_auto_xeyis.`status`='1' THEN '<span style="font-family:宋体">否</span>' </p><p> END ) AS <span style="font-family:宋体">是否审核</span>,</p><p>ryinfochuc.yongyouorderno AS <span style="font-family:宋体">审核人编码</span>,</p></td><td width="30" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p> </p><p>exec pmpcc --<span style="font-family:宋体">出差调试</span> </p><p> 'demo', -- <span style="font-family: 宋体">创建人编码</span></p><p> '2015-08-04 00:00', -- <span style="font-family:宋体">结束时间</span></p><p> 'aaa', -- <span style="font-family: 宋体">批准人</span></p><p> 'demo', -- <span style="font-family: 宋体">创建人</span></p><p> '2015-08-03 00:00', -- <span style="font-family:宋体">开始时间</span></p><p> '2015-08-03 11:47:04', -- <span style="font-family:宋体">创建时间</span></p><p> '100001', -- <span style="font-family:宋体">出差人编码</span></p><p> 'DS01', -- <span style="font-family:宋体">出差类型</span></p><p> 'bbb', -- <span style="font-family: 宋体">出差事由</span></p><p> 'ccc111' , -- <span style="font-family:宋体">备注</span></p><p> 'demo',-- <span style="font-family:宋体">审核人名</span> </p><p> '2015-08-03 11:47:04' , -- <span style="font-family:宋体">审核时间</span> </p><p> 1 , -- <span style="font-family: 宋体">是否审核</span></p><p> 'demo' --<span style="font-family:宋体">审核人编码</span></p></td><td width="2" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p>U8<span style="font-family:宋体">目标:存出过程</span> pmpcc </p></td><td width="3" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><p> </p><p> exec pmpcc --<span style="font-family:宋体">出差调试</span> </p><p> 'demo', -- <span style="font-family: 宋体">创建人编码</span></p><p> '2015-08-04 00:00', -- <span style="font-family:宋体">结束时间</span></p><p> 'aaa', -- <span style="font-family: 宋体">批准人</span></p><p> 'demo', -- <span style="font-family: 宋体">创建人</span></p><p> '2015-08-03 00:00', -- <span style="font-family:宋体">开始时间</span></p><p> '2015-08-03 11:47:04', -- <span style="font-family:宋体">创建时间</span></p><p> '100001', -- <span style="font-family:宋体">出差人编码</span></p><p> 'DS01', -- <span style="font-family:宋体">出差类型</span></p><p> 'bbb', -- <span style="font-family: 宋体">出差事由</span></p><p> 'ccc111' , -- <span style="font-family:宋体">备注</span></p><p> 'demo',-- <span style="font-family:宋体">审核人名</span> </p><p> '2015-08-03 11:47:04' , -- <span style="font-family:宋体">审核时间</span> </p><p> 1 , -- <span style="font-family: 宋体">是否审核</span></p><p> 'demo' --<span style="font-family:宋体">审核人编码</span></p><p> </p></td><td width="39" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><br></td><td width="10" valign="top" height="216" style="border-width: medium 1px 1px medium; border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; padding: 0px 7px;"><br></td></tr></tbody></table>\t code; $content = htmlToWordXml($content); // dump($content); // exit; $PHPWord = new PHPWord(); // dump(htmlToWordXml($content)); // exit; $docfile = UPLOAD_SampleWord . "4444.docx"; $filenameUTF8 = UPLOAD_SampleWord . "5555.docx"; $document = $PHPWord->loadTemplate($docfile); $document->clearAllBiaoji(); $content = <<<code <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <w:document xmlns:ve="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:m="http://schemas.openxmlformats.org/officeDocument/2006/math" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:wp="http://schemas.openxmlformats.org/drawingml/2006/wordprocessingDrawing" xmlns:w10="urn:schemas-microsoft-com:office:word" xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main" xmlns:wne="http://schemas.microsoft.com/office/word/2006/wordml"><w:body>{$content}</w:body></w:document> code; // dump($content);exit; // $bookNamearr = array(); // $bookNamearr["wang"] = array( // "name" => "wang", // "showname" => "", // "original" => $content, // "value" => $content, // "is_datatable" => 0, // "istestarea" => 1 // ); // foreach($bookNamearr as $k => $v) // { // if($v["is_datatable"]){ // $data = array(); // $data["showname"] = $v["showname"]; // $data["value"]= $v["value"]; // $data["showtype"]= $v["showtype"]!==NULL?$v["showtype"]:0; // $data["showtitle"]= $v["showtitle"]!==NULL?$v["showtitle"]:0; // if(isset($v["colORrow"])){ // $data["colORrow"] = $v["colORrow"]; // } // if(is_array($v["value"]) && !isset($v["colORrow"])){ // foreach($v["value"] as $kk => $vv){ // $data["titleArr"][] = empty($vv["showname"])?"":$vv["showname"]; // } // } // $document->setValue($v["name"],$data); // }else{ // $document->setValue($v["name"],$v); // } // } // $document->clearTemplateTag(); // $document->save($filenameUTF8); // $filenameUTF8 = UPLOAD_SampleWord."6789.docx"; // $document = $PHPWord->loadTemplate($imgurl); $document->setStr($content); $document->save($filenameUTF8); header("Cache-Control: public"); header("Content-Type: application/force-download"); header("Content-Disposition: attachment; filename=" . basename($filenameUTF8)); readfile($filenameUTF8); }
<?php require_once '../PHPWord.php'; $PHPWord = new PHPWord(); $document = $PHPWord->loadTemplate('tort.docx'); $document->setValue('Value1', 'Sun'); $document->setValue('Value2', 'Mercury'); $document->setValue('Value3', 'Venus'); $document->setValue('Value4', 'Earth'); $document->setValue('Value5', 'Mars'); $document->setValue('Value6', 'Jupiter'); $document->setValue('Value7', 'Saturn'); $document->setValue('Value8', 'Uranus'); $document->setValue('Value9', 'Neptun'); $document->setValue('Value10', 'Pluto'); $document->setValue('weekday', date('l')); $document->setValue('time', date('H:i')); $document->save('Solarsystem.doc');
include 'functions.php'; // ---------------------------------------------------------------------------------------- $PHPWord = new PHPWord(); if ($_POST['type_doc'] == 'pre_dogovor') { //------------------------------------------------------------------------------------- // Принятие данных с форматом datepicker и обработка их, // информация приходит в виде объекта данных string с инфой: dd.mm.yy //------------------------------------------------------------------------------------- // Дата заключения договора $pre_date_of_dogovor = DateTime::createFromFormat('d.m.Y', $_POST['pre_date_of_dogovor']); $pre_day_of_dogovor = $pre_date_of_dogovor->format('d'); $pre_month_of_dogovor = $pre_date_of_dogovor->format('m'); $pre_year_of_dogovor = $pre_date_of_dogovor->format('Y'); // Если не требуется распарсить строку, то можно сразу же обращаться к данным через супермассив $_POST //------------------------------------------------------------------------------------- $document = $PHPWord->loadTemplate('pre_dogovor.docx'); //шаблон // Замена переменных $document->setValue('city', $_POST['pre_placeOfDogovor']); //Место заключения договора $document->setValue('dayOfDogovor', get_day_from_number($pre_day_of_dogovor)); //Дата заключения договора: день $document->setValue('monthOfDogovor', get_month_from_number($pre_month_of_dogovor)); //Дата заключения договора: месяц $document->setValue('yearOfDogovor', get_year_from_number($pre_year_of_dogovor)); //Дата заключения договора: год $document->setValue('pre_fio', $_POST['pre_fio']); //ФИО продавца $document->setValue('birthday_of_vendor', $_POST['pre_birthday_of_vendor']); //Дата рождения продавца $document->setValue('pre_passport', $_POST['pre_passport']);
if ($status == 2) { $query = "update CS_REGISTER_CUSTOMER_SERVICE set NOMOR_SURAT_TUNAI = NOMOR_SURAT_TUNAI + 1"; ex_false($conn->execute($query), $query); } else { if ($status == 1) { $query = "update CS_REGISTER_CUSTOMER_SERVICE set NOMOR_SURAT_KPR = NOMOR_SURAT_KPR + 1"; ex_false($conn->execute($query), $query); } } $query = "update RENCANA set NO_SURAT5 = '{$nomor_surat}', TANGGAL_SURAT5 = CONVERT(DATETIME,GETDATE(),105) \n\t\t\tWHERE KODE_BLOK = '{$id}'\n\t\t\tAND TANGGAL >= CONVERT(DATETIME,'01-{$bln}-{$thn}',105) \n\t\t\tAND TANGGAL < CONVERT(DATETIME,'01-{$next_bln}-{$next_thn}',105)"; ex_false($conn->execute($query), $query); $query = "update SPP set STATUS_WANPRESTASI = 1 \n\t\t\tWHERE KODE_BLOK = '{$id}' "; ex_false($conn->execute($query), $query); // Create a new PHPWord Object $PHPWord = new PHPWord(); $document = $PHPWord->loadTemplate('../../../../../surat/Surat_Wanprestasi.docx'); //header $document->setValue('tanggal_cetak', $tanggal_cetak); $document->setValue('nomor_surat', $nomor_surat); $document->setValue('nama_pembeli', $nama_pembeli); $document->setValue('alamat', $alamat); $document->setValue('telepon', $telepon); $document->setValue('tanggal_spp', $tanggal_spp); $document->setValue('nomor_spp', $nomor_spp); $document->setValue('tanggal_ppjb', $tanggal_ppjb); $document->setValue('nomor_ppjb', $nomor_ppjb); $document->setValue('tanggal_tempo', $tgl_tempo); $document->setValue('no_somasi1', $no_somasi1); $document->setValue('tgl_somasi1', $tgl_somasi1); $document->setValue('no_somasi2', $no_somasi2); $document->setValue('tgl_somasi2', $tgl_somasi2);
$nomor_surat_dahulu = $obj->fields['NO_SURAT3']; $tanggal_surat_dahulu = kontgl(tgltgl(date("d M Y", strtotime($obj->fields['TANGGAL_SURAT3'])))); if ($status == 2) { $query = "update CS_REGISTER_CUSTOMER_SERVICE set NOMOR_SURAT_TUNAI = NOMOR_SURAT_TUNAI + 1"; ex_false($conn->execute($query), $query); } else { if ($status == 1) { $query = "update CS_REGISTER_CUSTOMER_SERVICE set NOMOR_SURAT_KPR = NOMOR_SURAT_KPR + 1"; ex_false($conn->execute($query), $query); } } $query = "update RENCANA set NO_SURAT4 = '{$nomor_surat}', TANGGAL_SURAT4 = CONVERT(DATETIME,GETDATE(),105) \n\t\t\tWHERE KODE_BLOK = '{$id}'\n\t\t\tAND TANGGAL >= CONVERT(DATETIME,'01-{$bln}-{$thn}',105) \n\t\t\tAND TANGGAL < CONVERT(DATETIME,'01-{$next_bln}-{$next_thn}',105)"; ex_false($conn->execute($query), $query); // Create a new PHPWord Object $PHPWord = new PHPWord(); $document = $PHPWord->loadTemplate('../../../../../surat/Surat_Somasi_3.docx'); //header $document->setValue('tanggal_cetak', $tanggal_cetak); $document->setValue('nomor_surat', $nomor_surat); $document->setValue('nama_pembeli', $nama_pembeli); $document->setValue('alamat', $alamat); $document->setValue('telepon', $telepon); $document->setValue('tanggal_spp', $tanggal_spp); $document->setValue('tanggal_tempo', $tgl_tempo); $document->setValue('nomor_surat_dahulu', $nomor_surat_dahulu); $document->setValue('tanggal_surat_dahulu', $tanggal_surat_dahulu); $document->setValue('blok', $blok); $document->setValue('nomor', $nomor); $document->setValue('kav_bang', $kav_bang); $document->setValue('nilai', to_money($nilai) . ".00"); $document->setValue('bulan', $bulan);
// $template = str_replace("{ATTN_NAME}", $row['attn_name'],$template ); // $template = str_replace("{ATTN_PHONE}", $row['attn_phone'],$template); // $template = str_replace("{ATTN_EMAIL}", $row['attn_name'],$template); // $template = str_replace("{TEL}", $row['attn_tel'],$template); // $template = str_replace("{FAX}", $row['attn_fax'],$template); // $template = str_replace("{MADETOUR}", $row['groupprogram_code'],$template); // if(!empty($row['nationlity'])){ // $template = str_replace("{NATIONLITY}", translate('countries_dom','',$row['nationlity']),$template); // } // else{$template = str_replace("{NATIONLITY}", translate('countries_dom','',''),$template); } // $template = str_replace("{BOOKINGLINE}", $focus->get_bookingroom_detailview($record),$template); // $template = str_replace("{NOTES}", html_entity_decode(nl2br($row['notes'])),$template); // $template = str_replace("{CONVENTION}", html_entity_decode(nl2br($row['convention'])),$template); // $template = str_replace("{COST}", html_entity_decode(nl2br($row['cost'])),$template); // $template = str_replace("{INCLUDE}", html_entity_decode(nl2br($row['include'])),$template); // $template = str_replace("{DINING_PLAN}", html_entity_decode(nl2br($row['dining_plan'])),$template); // if($row['confirmed']== 0 ){ // $template = str_replace("{CONFIRM}", 'No',$template); // } // else {$template = str_replace("{CONFIRM}", 'Yes',$template); } // $template = str_replace("{DATE}", date("d/m/Y",strtotime($row['date'])),$template); // $template = str_replace("{DEPARMENT}", $row['deparment'],$template); $PHPWord = new PHPWord(); $document = $PHPWord->loadTemplate('modules/RoomBookings/tpls/roombooking_template.docx'); $document->setValue('To', $row['name']); $document->setValue('ToAddress', $row['hotel_address']); $document->setValue('ToContactName', $row['attn_hotel_name']); $document->setValue('ToContactPhone', $row['attn_hotel_phone']); $document->setValue('Phone', $row['hotel_tel']); $document->setValue('Fax', html_entity_decode(nl2br($row['convention']))); $document->output('modules/RoomBookings/Room-Booking.docx');
public function getDoc($expediente) { $cliente = $this->mysqli->query('select * from expediente, cliente where id_expediente="' . $expediente . '" and cliente.rfc=expediente.fk_rfc')->fetch_object(); //$cliente = DB::table('expediente')->where('id_expediente', $expediente)->join('cliente', 'cliente.rfc', '=', 'expediente.fk_rfc')->get()[0]; $lote = $this->mysqli->query('select * from expediente, solicitud, contrato, contrato_lote, lote, manzana, desarrollo where expediente.id_expediente="' . $expediente . '" and solicitud.fk_expediente=expediente.id_expediente and contrato.fk_solicitud=solicitud.id_solicitud and contrato_lote.fk_contrato=contrato.id_contrato and lote.id_lote=contrato_lote.fk_lote and manzana.id_manzana=lote.fk_manzana and desarrollo.id_desarrollo=manzana.fk_desarrollo')->fetch_object(); //$lote=DB::table('expediente')->where('id_expediente', $expediente)->join('solicitud', 'fk_expediente', '=','expediente.id_expediente')->join('contrato', 'contrato.fk_solicitud', '=','solicitud.id_solicitud')->join('contrato_lote','contrato_lote.fk_contrato', '=' ,'contrato.id_contrato')->join('lote','lote.id_lote', '=', 'contrato_lote.fk_lote')->join('manzana', 'manzana.id_manzana', '=', 'lote.fk_manzana')->join('desarrollo', 'desarrollo.id_desarrollo', '=', 'manzana.fk_desarrollo')->get()[0]; $contrato = $this->mysqli->query('select * from contrato where id_contrato=' . $lote->id_contrato)->fetch_object(); $categoria = $this->mysqli->query('select * from categoria where id_categoria=' . '"' . $lote->fk_categoria . '"')->fetch_object(); //$categoria = DB::table('categoria')->where('id_categoria', $lote->fk_categoria)->get()[0]; $cuenta = $this->mysqli->query('select * from cuenta where fk_contrato=' . $lote->id_contrato)->fetch_object(); //$cuenta = DB::table('cuenta')->where('fk_contrato', $lote->id_contrato)->get()[0]; $enganches = Estatica::getObjetos($this->mysqli->query('select * from enganche_parcial where fk_cuenta=' . $cuenta->id_cuenta)); //$enganches = DB::table('enganche_parcial')->where('fk_cuenta', $cuenta->id_cuenta)->get(); $partesContrato = DB::table('parte_contrato')->where('fk_desarrollo', $lote->fk_desarrollo)->get(); $ala_Firma = 0; $textoEnganches = ''; $bool_no_parciales = true; for ($e = 0; $e < count($enganches); $e++) { if (strtotime($enganches[$e]->fecha_promesa) > strtotime($contrato->fecha_realizacion)) { $textoEnganches = $textoEnganches . " Complemento de enganche por \$" . round($enganches[$e]->importe, 2) . ' ' . numtoletras(round($enganches[$e]->importe, 2)) . " que depositara en la fecha " . $enganches[$e]->fecha_promesa; $bool_no_parciales = false; } else { $ala_Firma += $enganches[$e]->importe; } } if ($bool_no_parciales == true) { $textoEnganches = 'Ningun enganche parcial.'; } $PHPWord = new PHPWord(); if ($lote->tipo_operacion == 1) { $document = $PHPWord->loadTemplate(dirname(__FILE__) . '/PHPWord/contrato_contado.docx'); } else { $document = $PHPWord->loadTemplate(dirname(__FILE__) . '/PHPWord/Plantilla_Contrato_Credito.docx'); $document->setValue('Plazo', $lote->plazo); $document->setValue('DiaCorte', $lote->dia_corte); $document->setValue('PlazoLetra', numtoletras_2($lote->plazo)); $lote->fecha_inicial_pago = explode('-', $lote->fecha_inicial_pago); $document->setValue('IniciaDia', $lote->fecha_inicial_pago[2]); for ($parte = 0; $parte < count($partesContrato); $parte++) { $document->setValue('Parte' . ($parte + 1), $partesContrato[$parte]->texto); } $document->setValue('MesInicia', $this->mes($lote->fecha_inicial_pago[1])); $document->setValue('AnioInicia', $lote->fecha_inicial_pago[0]); } $document->setValue('Contrato', $expediente); $document->setValue('Cliente', $cliente->nombre . " " . $cliente->ape_pate . " " . $cliente->ape_mate); $document->setValue('CP', $cliente->cp); if ($cliente->estado_civil == 1) { $document->setValue('Edo_Civil', 'Soltero'); $document->setValue('Regimen', ' '); } else { $document->setValue('Edo_Civil', 'Casado'); if ($cliente->regimenMatrimonial == 1) { $document->setValue('Regimen', ' bajo el regimen de Bienes mancomunados'); } else { $document->setValue('Regimen', 'bajo el regimen de Bienes separados'); } } $document->setValue('Profesion', $cliente->profesion); $document->setValue('RFC', $cliente->rfc); $document->setValue('CURP', $cliente->curp); $document->setValue('Tel_Casa', $cliente->telefono); $document->setValue('Tel_Celular', $cliente->movil); $document->setValue('Email', $cliente->email); $document->setValue('Calle', $cliente->calle); $document->setValue('No', $cliente->numero_casa); $document->setValue('Colonia', $cliente->colonia); $document->setValue('Nacionalidad', $cliente->nacionalidad); $document->setValue('Desarrollo', $lote->nombre); $document->setValue('Lote', $lote->lote); $document->setValue('LoteLetra', numtoletras_2($lote->lote)); $document->setValue('Manzana', $lote->num_letra); $document->setValue('ManzanaLetra', numtoletras_2($lote->num_letra)); $document->setValue('MtNorte', $lote->metlinor); $document->setValue('LindaNorte', $lote->metlinor); $document->setValue('MtSur', $lote->metlinsur); $document->setValue('LindaSur', $lote->lindasur); $document->setValue('MtOriente', $lote->metlinoeste); $document->setValue('LindaOriente', $lote->lindaoriente); $document->setValue('MtPoniente', $lote->metlineste); $document->setValue('LindaPoniente', $lote->lindaponiente); $document->setValue('Total', round($categoria->precio * $lote->superficie), 2); $document->setValue('TotalLetra', numtoletras(round($categoria->precio * $lote->superficie), 2)); $document->setValue('Precio_Metro', round($categoria->precio, 2)); $document->setValue('PrecioMetroLetra', numtoletras(round($categoria->precio, 2))); $document->setValue('Superficie', round($lote->superficie, 2)); $document->setValue('SuperficieLetra', numtoletras_2(round($lote->superficie, 2))); $document->setValue('SaldoFinanciar', round($cuenta->saldo_inicial)); $document->setValue('SaldoFinanciarLetra', numtoletras(round($cuenta->saldo_inicial))); $document->setValue('Enganche', round($ala_Firma)); $document->setValue('EngancheLetra', numtoletras(round($ala_Firma))); $document->setValue('Complementos', $textoEnganches); $lote->fecha_realizacion = explode("-", $lote->fecha_realizacion); $document->setValue('Dia', $lote->fecha_realizacion[2]); $document->setValue('Mes', $this->mes($lote->fecha_realizacion[1])); $document->setValue('Anio', $lote->fecha_realizacion[0]); $document->setValue('Referencia', $lote->fk_referencia); $document->setValue('Municipio', $cliente->municipio); $document->setValue('Complemento', $cliente->estado); if ($lote->tipo_operacion == 1) { $document->save($expediente . '_Contado.docx'); } else { $document->save($expediente . '_Credito.docx'); } }
public function GeraOitAlterado() { $CData = new Data(); $SqlOit = "SELECT * FROM oit_formulario WHERE my_parametro_id = " . $this->MyParametroId . " AND laudo_item_id =" . $this->getLaudoItemId(); $BD = New Database(); $Result = $BD->query($SqlOit); if ($Result->rowCount() == 0) { $this->setMsg("Não foram encontradas informações para este laudo, não será possível concluir a geração do arquivo\n\n"); $this->setStatusGeracao(false); } $LinhaOit = $Result->fetchAll(); $Cpf = $this->getCPF(); $DocOit = !isset($Cpf) ? "CPF " . $this->getCPF() : "RG: " . $this->getRG(); $_1a = $LinhaOit[0]["1a"]; $_1b = $LinhaOit[0]["1b"]; $_2a = $LinhaOit[0]["2a"]; $_2b_pequenas_opacidades_primarias = $LinhaOit[0]["2b_pequenas_opacidades_primarias"]; $_2b_pequenas_opacidades_secundarias = $LinhaOit[0]["2b_pequenas_opacidades_secundarias"]; $_2b_zonas_d = $LinhaOit[0]["2b_zonas_d"]; $_2c_profusao = $LinhaOit[0]["2c_profusao"]; $_2c_grandes_opacidades = $LinhaOit[0]["2c_grandes_opacidades"]; $_3a = $LinhaOit[0]["3a"]; $_3b_placas_neurais = $LinhaOit[0]["3b_placas_neurais"]; $_3b_parede_em_perfil_local = $LinhaOit[0]["3b_parede_em_perfil_local"]; $_3b_parede_em_perfil_calcificacao = $LinhaOit[0]["3b_parede_em_perfil_calcificacao"]; $_3b_frontal_local = $LinhaOit[0]["3b_frontal_local"]; $_3b_frontal_calcificacao = $LinhaOit[0]["3b_frontal_calcificacao"]; $_3b_diafragma_local = $LinhaOit[0]["3b_diafragma_local"]; $_3b_diafragma_calcificacao = $LinhaOit[0]["3b_diafragma_calcificacao"]; $_3b_outros_locais_local = $LinhaOit[0]["3b_outros_locais_local"]; $_3b_outros_locais_calcificacao = $LinhaOit[0]["3b_outros_locais_calcificacao"]; $_3b_combinado_0d = $LinhaOit[0]["3b_combinado_0d"]; $_3b_combinado_0e = $LinhaOit[0]["3b_combinado_0e"]; $_3b_combinado_d = $LinhaOit[0]["3b_combinado_d"]; $_3b_combinado_e = $LinhaOit[0]["3b_combinado_e"]; $_3c = $LinhaOit[0]["3c"]; $_3d_espessamento_pleural_difuso = $LinhaOit[0]["3d_espessamento_pleural_difuso"]; $_3d_parede_em_perfil_local = $LinhaOit[0]["3d_parede_em_perfil_local"]; $_3d_parede_em_perfil_calcificacao = $LinhaOit[0]["3d_parede_em_perfil_calcificacao"]; $_3d_frontal_local = $LinhaOit[0]["3d_frontal_local"]; $_3d_frontal_calcificacao = $LinhaOit[0]["3d_frontal_calcificacao"]; $_3d_combinado_0d = $LinhaOit[0]["3d_combinado_0d"]; $_3d_combinado_0e = $LinhaOit[0]["3d_combinado_0e"]; $_4a_outras_normalidades = $LinhaOit[0]["4a_outras_normalidades"]; $_4b_outras_normalidades = $LinhaOit[0]["4b_outras_normalidades"]; $_4c_comentarios = $LinhaOit[0]["4c_comentarios"]; $PHPWord = new PHPWord(); $ArquivoClinica = $this->VerificaDiretorioTemplateOIT(); $document = $PHPWord->loadTemplate($ArquivoClinica); //clínica $document->setValue('nome_emp', $this->getRazaoSocialClinica()); $document->setValue('cnpj_emp', $this->getCnpjClinica()); $document->setValue('rua_emp', $this->getEnderecoClinica()); $document->setValue('tel_emp', $this->getTelefoneClinica()); $document->setValue('cidade_emp', $this->getCidadeClinica()); $document->setValue('estado_emp', $this->getUFClinica()); //Funcionário $document->setValue('nome_func', $this->getFuncionario()); $document->setValue('doc_func', $DocOit); $document->setValue('empresa_func', $this->getRazaoSocialEmp()); $document->setValue('dat_func', $this->getDataNascimento()); $document->setValue('func_funcionario', $this->getFuncao()); $document->setValue('idade_func', $this->IdadeFunc); $document->setValue('tel_func', $this->TelefoneClinica); $document->setValue('data_exame_func', $CData->convertDataBrasileira($this->getDataRealizacao())); $document->setValue('observacao', "$_4c_comentarios"); //Marcações no documento //1A if ($_1a == 1) { $document->setValue('1a1', "X"); } else { $document->setValue('1a1', ""); }; if ($_1a == 2) { $document->setValue('1a2', "X"); } else { $document->setValue('1a2', ""); } if ($_1a == 3) { $document->setValue('1a3', "X"); } else { $document->setValue('1a3', ""); }; if ($_1a == 4) { $document->setValue('1a4', "X"); } else { $document->setValue('1a4', ""); }; //1B if ($_1b == "S") { $document->setValue('1bs', "X"); } else { $document->setValue('1bs', ""); }; if ($_1b == "N") { $document->setValue('1bn', "X"); } else { $document->setValue('1bn', ""); } //2A if ($_2a == "S") { $document->setValue('2as', "X"); } else { $document->setValue('2as', ""); } if ($_2a == "N") { $document->setValue('2an', "X"); } else { $document->setValue('2an', ""); } //2B Primária if ($_2b_pequenas_opacidades_primarias == "P") { $document->setValue('2bp', "X"); } else { $document->setValue('2bp', ""); } if ($_2b_pequenas_opacidades_primarias == "Q") { $document->setValue('2bq', "X"); } else { $document->setValue('2bq', ""); } if ($_2b_pequenas_opacidades_primarias == "R") { $document->setValue('2br', "X"); } else { $document->setValue('2br', ""); } if ($_2b_pequenas_opacidades_primarias == "S") { $document->setValue('2bs', "X"); } else { $document->setValue('2bs', ""); } if ($_2b_pequenas_opacidades_primarias == "T") { $document->setValue('2bt', "X"); } else { $document->setValue('2bt', ""); } if ($_2b_pequenas_opacidades_primarias == "U") { $document->setValue('2bu', "X"); } else { $document->setValue('2bu', ""); }; //2B Secundária if ($_2b_pequenas_opacidades_secundarias == "P") { $document->setValue('2bps', "X"); } else { $document->setValue('2bps', ""); } if ($_2b_pequenas_opacidades_secundarias == "Q") { $document->setValue('2bqs', "X"); } else { $document->setValue('2bqs', ""); } if ($_2b_pequenas_opacidades_secundarias == "R") { $document->setValue('2brs', "X"); } else { $document->setValue('2brs', ""); ; } if ($_2b_pequenas_opacidades_secundarias == "S") { $document->setValue('2bss', "X"); } else { $document->setValue('2bss', ""); } if ($_2b_pequenas_opacidades_secundarias == "T") { $document->setValue('2bts', "X"); } else { $document->setValue('2bts', ""); } if ($_2b_pequenas_opacidades_secundarias == "U") { $document->setValue('2bus', "X"); } else { $document->setValue('2bus', ""); } //2C Profusão if ($_2c_profusao == "0/-") { $document->setValue('0/-', "X"); } else { $document->setValue('0/-', ""); }; if ($_2c_profusao == "1/0") { $document->setValue('1/0', "X"); } else { $document->setValue('1/0', ""); }; if ($_2c_profusao == "2/1") { $document->setValue('2/1', "X"); } else { $document->setValue('2/1', ""); }; if ($_2c_profusao == "3/2") { $document->setValue('3/2', "X"); } else { $document->setValue('3/2', ""); }; if ($_2c_profusao == "0/0") { $document->setValue('0/0', "X"); } else { $document->setValue('0/0', ""); }; if ($_2c_profusao == "1/1") { $document->setValue('1/1', "X"); } else { $document->setValue('1/1', ""); }; if ($_2c_profusao == "2/2") { $document->setValue('2/2', "X"); } else { $document->setValue('2/2', ""); }; if ($_2c_profusao == "3/3") { $document->setValue('3/3', "X"); } else { $document->setValue('3/3', ""); }; if ($_2c_profusao == "0/1") { $document->setValue('0/1', "X"); } else { $document->setValue('0/1', ""); }; if ($_2c_profusao == "1/2") { $document->setValue('1/2', "X"); } else { $document->setValue('1/2', ""); }; if ($_2c_profusao == "1/2") { $document->setValue('1/2', "X"); } else { $document->setValue('1/2', ""); }; if ($_2c_profusao == "2/3") { $document->setValue('2/3', "X"); } else { $document->setValue('2/3', ""); }; if ($_2c_profusao == "3/+") { $document->setValue('3/+', "X"); } else { $document->setValue('3/+', ""); }; if ($_3a == "S") { $document->setValue('3as', "X"); $document->setValue('3an', ""); } elseif ($_3a == "N") { $document->setValue('3as', ""); $document->setValue('3an', "X"); } else { $document->setValue('3as', ""); $document->setValue('3an', ""); }; // 3B Placas Pleurais if ($_3b_placas_neurais == "S") { $document->setValue('3bs', "X"); $document->setValue('3bn', ""); } elseif ($_3b_placas_neurais == "N") { $document->setValue('3bn', "X"); $document->setValue('3bs', ""); } else { $document->setValue('3bn', ""); $document->setValue('3bs', ""); }; //3B Parede em Perfil if ($_3b_parede_em_perfil_local == "0") { $document->setValue('3parede_0_lo', "X"); } else { $document->setValue('3parede_0_lo', ""); } if ($_3b_parede_em_perfil_local == "D") { $document->setValue('3parede_d_lo', "X"); } else { $document->setValue('3parede_d_lo', ""); } if ($_3b_parede_em_perfil_local == "e") { $document->setValue('3parede_e_lo', "X"); } else { $document->setValue('3parede_e_lo', ""); } if ($_3b_parede_em_perfil_calcificacao == "0") { $document->setValue('3parede_0_cal', "X"); } else { $document->setValue('3parede_0_cal', ""); }; if ($_3b_parede_em_perfil_calcificacao == "D") { $document->setValue('3parede_d_cal', "X"); } else { $document->setValue('3parede_d_cal', ""); }; if ($_3b_parede_em_perfil_calcificacao == "E") { $document->setValue('3parede_e_cal', "X"); } else { $document->setValue('3parede_e_cal', ""); }; //3B Frontal if ($_3b_frontal_local == "0") { $document->setValue('3frontal_0_lo', "X"); } else { $document->setValue('3frontal_0_lo', ""); } if ($_3b_frontal_local == "D") { $document->setValue('3frontal_d_lo', "X"); } else { $document->setValue('3frontal_d_lo', ""); } if ($_3b_frontal_local == "E") { $document->setValue('3frontal_e_lo', "X"); } else { $document->setValue('3frontal_e_lo', ""); } if ($_3b_frontal_calcificacao == "0") { $document->setValue('3frontal_0_cal', "X"); } else { $document->setValue('3frontal_0_cal', ""); }; if ($_3b_frontal_calcificacao == "D") { $document->setValue('3frontal_d_cal', "X"); } else { $document->setValue('3frontal_d_cal', ""); }; if ($_3b_frontal_calcificacao == "e") { $document->setValue('3frontal_e_cal', "X"); } else { $document->setValue('3frontal_e_cal', ""); }; //3B Diafragma Local if ($_3b_diafragma_local == "0") { $document->setValue('3diafragma_0_lo', "X"); } else { $document->setValue('3diafragma_0_lo', ""); }; if ($_3b_diafragma_local == "D") { $document->setValue('3diafragma_d_lo', "X"); } else { $document->setValue('3diafragma_d_lo', ""); }; if ($_3b_diafragma_local == "E") { $document->setValue('3diafragma_e_lo', "X"); } else { $document->setValue('3diafragma_e_lo', ""); }; //3B Diafragma Calcificação if ($_3b_diafragma_calcificacao == "0") { $document->setValue('3diafragma_0_cal', "X"); } else { $document->setValue('3diafragma_0_cal', ""); }; if ($_3b_diafragma_calcificacao == "D") { $document->setValue('3diafragma_d_cal', "X"); } else { $document->setValue('3diafragma_d_cal', ""); }; if ($_3b_diafragma_calcificacao == "e") { $document->setValue('3diafragma_e_cal', "X"); } else { $document->setValue('3diafragma_e_cal', ""); }; //3B Outros Locais Calcificação if ($_3b_outros_locais_calcificacao == "0") { $document->setValue('outros_0_cal', "X"); } else { $document->setValue('outros_0_cal', ""); }; if ($_3b_outros_locais_calcificacao == "D") { $document->setValue('outros_d_cal', "X"); } else { $document->setValue('outros_d_cal', ""); }; if ($_3b_outros_locais_calcificacao == "E") { $document->setValue('outros_e_cal', "X"); } else { $document->setValue('outros_e_cal', ""); }; //3B Outros Locais if ($_3b_outros_locais_local == "0") { $document->setValue('outros_0_lo', "X"); } else { $document->setValue('outros_0_lo', ""); }; if ($_3b_outros_locais_local == "d") { $document->setValue('outros_d_lo', "X"); } else { $document->setValue('outros_d_lo', ""); }; if ($_3b_outros_locais_local == "e") { $document->setValue('outros_e_lo', "X"); } else { $document->setValue('outros_e_lo', ""); }; //3B extenção parede if ($_3b_combinado_0d == "0") { $document->setValue('3b_0d_0', "X"); } else { $document->setValue('3b_0d_0', ""); } if ($_3b_combinado_0d == "D") { $document->setValue('3b_0d_D', "X"); } else { $document->setValue('3b_0d_D', ""); } if ($_3b_combinado_0d == "1") { $document->setValue('3b_0d_1', "X"); } else { $document->setValue('3b_0d_1', ""); } if ($_3b_combinado_0d == "2") { $document->setValue('3b_0d_2', "X"); } else { $document->setValue('3b_0d_2', ""); } if ($_3b_combinado_0d == "3") { $document->setValue('3b_0d_3', "X"); } else { $document->setValue('3b_0d_3', ""); } if ($_3b_combinado_0e == "0") { $document->setValue('3b_0e_0', "X"); } else { $document->setValue('3b_0e_0', ""); } if ($_3b_combinado_0e == "E") { $document->setValue('3b_0e_E', "X"); } else { $document->setValue('3b_0e_E', ""); } if ($_3b_combinado_0e == "1") { $document->setValue('3b_0e_1', "X"); } else { $document->setValue('3b_0e_1', ""); } if ($_3b_combinado_0e == "2") { $document->setValue('3b_0e_2', "X"); } else { $document->setValue('3b_0e_2', ""); } if ($_3b_combinado_0e == "3") { $document->setValue('3b_0e_3', "X"); } else { $document->setValue('3b_0e_3', ""); } if ($_3b_combinado_d == "D") { $document->setValue('3d_D', "X"); } else { $document->setValue('3d_D', ""); } if ($_3b_combinado_d == "A") { $document->setValue('3d_a', "X"); } else { $document->setValue('3d_a', ""); } if ($_3b_combinado_d == "B") { $document->setValue('3d_b', "X"); } else { $document->setValue('3d_b', ""); } if ($_3b_combinado_d == "C") { $document->setValue('3d_c', "X"); } else { $document->setValue('3d_c', ""); } if ($_3b_combinado_e == "E") { $document->setValue('3e_E', "X"); } else { $document->setValue('3e_E', ""); } if ($_3b_combinado_e == "A") { $document->setValue('3e_a', "X"); } else { $document->setValue('3e_a', ""); } if ($_3b_combinado_e == "B") { $document->setValue('3e_b', "X"); } else { $document->setValue('3e_b', ""); } if ($_3b_combinado_e == "C") { $document->setValue('3e_c', "X"); } else { $document->setValue('3e_c', ""); } //3C if ($_3c == "0") { $document->setValue('3c0', "X"); } else { $document->setValue('3c0', ""); } if ($_3c == "D") { $document->setValue('3cD', "X"); } else { $document->setValue('3cD', ""); } if ($_3c == "E") { $document->setValue('3cE', "X"); } else { $document->setValue('3cE', ""); } // 3D if ($_3d_espessamento_pleural_difuso == "S") { $document->setValue('3ds', "X"); $document->setValue('3dn', ""); } elseif ($_3d_espessamento_pleural_difuso == "N") { $document->setValue('3dn', "X"); $document->setValue('3ds', ""); } else { $document->setValue('3dn', ""); $document->setValue('3ds', ""); }; //3B Parede em Perfil if ($_3d_parede_em_perfil_local == "0") { $document->setValue('3d0_local', "X"); } else { $document->setValue('3d0_local', ""); } if ($_3d_parede_em_perfil_local == "D") { $document->setValue('3dD_local', "X"); } else { $document->setValue('3dD_local', ""); }; if ($_3d_parede_em_perfil_local == "E") { $document->setValue('3dE_local', "X"); } else { $document->setValue('3dE_local', ""); } if ($_3d_parede_em_perfil_calcificacao == "0") { $document->setValue('3d0_calci', "X"); } else { $document->setValue('3d0_calci', ""); }; if ($_3d_parede_em_perfil_calcificacao == "D") { $document->setValue('3dD_calci', "X"); } else { $document->setValue('3dD_calci', ""); }; if ($_3d_parede_em_perfil_calcificacao == "E") { $document->setValue('3dE_calci', "X"); } else { $document->setValue('3dE_calci', ""); }; //3D Frontal if ($_3d_frontal_local == "0") { $document->setValue('3d0_front_local', "X"); } else { $document->setValue('3d0_front_local', ""); } if ($_3d_frontal_local == "D") { $document->setValue('3dD_front_local', "X"); } else { $document->setValue('3dD_front_local', ""); } if ($_3d_frontal_local == "E") { $document->setValue('3de_calci_local', "X"); } else { $document->setValue('3de_calci_local', ""); } if ($_3d_frontal_calcificacao == "0") { $document->setValue('3d0_front_calc', "X"); } else { $document->setValue('3d0_front_calc', ""); }; if ($_3d_frontal_calcificacao == "D") { $document->setValue('3dD_front_calc', "X"); } else { $document->setValue('3dD_front_calc', ""); }; if ($_3d_frontal_calcificacao == "E") { $document->setValue('3dE_front_calc', "X"); } else { $document->setValue('3dE_front_calc', ""); }; // COMBINADO if ($_3d_combinado_0d == "0") { $document->setValue('3d_d_comb_0', "X"); } else { $document->setValue('3d_d_comb_0', ""); } if ($_3d_combinado_0d == "D") { $document->setValue('3d_d_comb_D', "X"); } else { $document->setValue('3d_d_comb_D', ""); } if ($_3d_combinado_0d == "1") { $document->setValue('3d_d_comb_1', "X"); } else { $document->setValue('3d_d_comb_1', ""); } if ($_3d_combinado_0d == "2") { $document->setValue('3d_d_comb_2', "X"); } else { $document->setValue('3d_d_comb_2', ""); }; if ($_3d_combinado_0d == "3") { $document->setValue('3d_d_comb_3', "X"); } else { $document->setValue('3d_d_comb_3', ""); } // Outro Quadrado if ($_3d_combinado_0d == "0") { $document->setValue('3d_e_comb_0', "X"); } else { $document->setValue('3d_e_comb_0', ""); } if ($_3d_combinado_0d == "E") { $document->setValue('3d_e_comb_E', "X"); } else { $document->setValue('3d_e_comb_E', ""); } if ($_3d_combinado_0d == "1") { $document->setValue('3d_e_comb_1', "X"); } else { $document->setValue('3d_e_comb_1', ""); } if ($_3d_combinado_0d == "2") { $document->setValue('3d_e_comb_2', "X"); } else { $document->setValue('3d_e_comb_2', ""); }; if ($_3d_combinado_0d == "3") { $document->setValue('3d_e_comb_3', "X"); } else { $document->setValue('3d_e_comb_3', ""); } // 4A if ($_4a_outras_normalidades == "S") { $document->setValue('4as', "X"); $document->setValue('4an', ""); } elseif ($_4a_outras_normalidades == "N") { $document->setValue('4an', "X"); $document->setValue('4as', ""); } else { $document->setValue('4an', ""); $document->setValue('4as', ""); } // 4B Outras Anormalidades if ($_4b_outras_normalidades == "aa") { $document->setValue('4baa', "X"); } else { $document->setValue('4baa', ""); } if ($_4b_outras_normalidades == "at") { $document->setValue('4Bat', "X"); } else { $document->setValue('4Bat', ""); } if ($_4b_outras_normalidades == "ax") { $document->setValue('4Bax', "X"); } else { $document->setValue('4Bax', ""); } if ($_4b_outras_normalidades == "bu") { $document->setValue('4Bbu', "X"); } else { $document->setValue('4Bbu', ""); } if ($_4b_outras_normalidades == "ca") { $document->setValue('4Bca', "X"); } else { $document->setValue('4Bca', ""); } if ($_4b_outras_normalidades == "cg") { $document->setValue('4Bcg', "X"); } else { $document->setValue('4Bcg', ""); } if ($_4b_outras_normalidades == "cn") { $document->setValue('4Bcn', "X"); } else { $document->setValue('4Bcn', ""); } if ($_4b_outras_normalidades == "co") { $document->setValue('4Bco', "X"); } else { $document->setValue('4Bco', ""); } if ($_4b_outras_normalidades == "cp") { $document->setValue('4Bcp', "X"); } else { $document->setValue('4Bcp', ""); } if ($_4b_outras_normalidades == "cv") { $document->setValue('4Bcv', "X"); } else { $document->setValue('4Bcv', ""); } if ($_4b_outras_normalidades == "di") { $document->setValue('4Bdi', "X"); } else { $document->setValue('4Bdi', ""); } if ($_4b_outras_normalidades == "ef") { $document->setValue('4Bef', "X"); } else { $document->setValue('4Bef', ""); } if ($_4b_outras_normalidades == "em") { $document->setValue('4Bem', "X"); } else { $document->setValue('4Bem', ""); } if ($_4b_outras_normalidades == "es") { $document->setValue('4Bes', "X"); } else { $document->setValue('4Bes', ""); } if ($_4b_outras_normalidades == "fr") { $document->setValue('4Bfr', "X"); } else { $document->setValue('4Bfr', ""); } // Segunda linha if ($_4b_outras_normalidades == "hi") { $document->setValue('4Bhi', "X"); } else { $document->setValue('4Bhi', ""); } if ($_4b_outras_normalidades == "ho") { $document->setValue('4Bho', "X"); } else { $document->setValue('4Bho', ""); } if ($_4b_outras_normalidades == "id") { $document->setValue('4Bid', "X"); } else { $document->setValue('4Bid', ""); } if ($_4b_outras_normalidades == "ih") { $document->setValue('4Bih', "X"); } else { $document->setValue('4Bih', ""); } if ($_4b_outras_normalidades == "kl") { $document->setValue('4Bkl', "X"); } else { $document->setValue('4Bkl', ""); } if ($_4b_outras_normalidades == "me") { $document->setValue('4Bme', "X"); } else { $document->setValue('4Bme', ""); } if ($_4b_outras_normalidades == "pa") { $document->setValue('4Bpa', "X"); } else { $document->setValue('4Bpa', ""); } if ($_4b_outras_normalidades == "pb") { $document->setValue('4Bpb', "X"); } else { $document->setValue('4Bpb', ""); } if ($_4b_outras_normalidades == "pi") { $document->setValue('4Bpi', "X"); } else { $document->setValue('4Bpi', ""); } if ($_4b_outras_normalidades == "px") { $document->setValue('4Bpx', "X"); } else { $document->setValue('4Bpx', ""); } if ($_4b_outras_normalidades == "ra") { $document->setValue('4Bra', "X"); } else { $document->setValue('4Bra', ""); } if ($_4b_outras_normalidades == "rp") { $document->setValue('4Brp', "X"); } else { $document->setValue('4Brp', ""); } if ($_4b_outras_normalidades == "tb") { $document->setValue('4Btb', "X"); } else { $document->setValue('4Btb', ""); } if ($_4b_outras_normalidades == "od") { $document->setValue('4Bod', "X"); } else { $document->setValue('4Bod', ""); } $Arquivo = $this->getDiretorioParaGeracaoLaudo() . "/" . $this->getNomeLaudoGerado(); $document->save($Arquivo); return true; }
<?php $rootAddress = ''; require_once "phpword/PHPWord.php"; $dias = array("Domingo", "Lunes", "Martes", "Miercoles", "Jueves", "Viernes", "Sábado"); $meses = array("Enero", "Febrero", "Marzo", "Abril", "Mayo", "Junio", "Julio", "Agosto", "Septiembre", "Octubre", "Noviembre", "Diciembre"); $fecha = date('d') . 'días del mes de ' . $meses[date('n') - 1] . " del " . date('Y'); $word = new PHPWord(); $template = $word->loadTemplate($rootAddress . 'plantillas/PARA PPS.docx'); $template->setValue('${NOMBRE_ESTUDIANTE}', 'Luis Manuel Deras'); $template->setValue('${NUMERO_CUENTA}', '20112001640'); $template->setValue('${FECHA}', $fecha); $template->save('test3.docx');
$tanggal = date('j'); //Array Bulan $array_bulan = array(1 => 'Januari', 'Februari', 'Maret', 'April', 'Mei', 'Juni', 'Juli', 'Agustus', 'September', 'Oktober', 'November', 'Desember'); $bulan = $array_bulan[date('n')]; //Format Tahun $tahun = date('Y'); $bilangan = new Terbilang(); // Include the PHPWord.php, all other classes were loaded by an autoloader include '../../../../../plugin/PHPWord.php'; // Create a new PHPWord Object $PHPWord = new PHPWord(); $template = '../../../../../config/Template/' . $NAMA_FILE; $nama_template = $NAMA_JENIS; if (file_exists($template)) { $template = $template; $document = $PHPWord->loadTemplate($template); $document->setValue('nomor_ppjb', $nomor); $document->setValue('hari', $hari); $document->setValue('tanggal', $tanggal); $document->setValue('bulan', $bulan); $document->setValue('tahun', $tahun); $document->setValue('tahun_terbilang', $bilangan->eja($tahun)); $document->setValue('nama_pembeli', $nama_pembeli); $document->setValue('no_identitas', $no_identitas); $document->setValue('alamat', $alamat); $document->setValue('telp1', $tlp1); $document->setValue('telp3', $tlp3); $document->setValue('NAMA_PEJABAT', $NAMA_PEJABAT); $document->setValue('NAMA_JABATAN', $NAMA_JABATAN); $document->setValue('PEJABAT_PPJB', $PEJABAT_PPJB); $document->setValue('JABATAN_PPJB', $JABATAN_PPJB);
<?php require_once 'modules/AOS_PDF_Templates/phpword/PHPWord.php'; $PHPWord = new PHPWord(); $document = $PHPWord->loadTemplate('modules/AOS_PDF_Templates/vnlicacodephpword/demo_template.docx'); $document->setValue('${From}', 'Bùi Cao Học'); $document->setValue('{_address1_}', '123 Trương Định'); $document->output('modules/RoomBookings/abc.docx');
} switch ($act) { case 'print': $id = sqlReplace(trim($_GET['id'])); if (!empty($id)) { $row = getuserinfo($id); if (!$row) { alertInfo('数据不存在', '', 1); } require_once 'PHPWord.php'; $PHPWord = new PHPWord(); //复制模板文件,变成下载文件 $now = time(); $y_url = '../userfiles/print.docx'; $x_url = '../userfiles/docx/' . $now . '.docx'; $document = $PHPWord->loadTemplate($y_url); $document->setValue('name', $row['user_name']); //姓名 $document->setValue('phone', $row['user_phone']); //姓名 //文件内容替换完毕 保存 下载 $document->save($x_url); //header("Content-Type: application/force-download"); //header("Content-Disposition: attachment; filename=".basename($x_url)); //readfile($x_url); header("location:" . $x_url); } else { alertInfo('参数错误', '', 1); } break; }
function handleExport($post_id) { if (isset($_POST['filmExportType'])) { $type = $_POST['filmExportType']; $file = plugin_dir_path(__FILE__) . 'document_templates/' . $type . '.docx'; $postData = get_post($post_id, ARRAY_A); $slug = $postData['post_name']; $fileOut = plugin_dir_path(__FILE__) . 'document_templates/tmp/' . $type . '-' . $slug . '.docx'; $filename = basename($fileOut); if (!file_exists($file)) { return; } require_once plugin_dir_path(__FILE__) . 'vendors/phpword/PHPWord.php'; $PHPWord = new PHPWord(); $document = $PHPWord->loadTemplate($file); $fields = array('register_date', 'identity_code', 'title_orig', 'title', 'first_record_producer', 'application_provider', 'country', 'produce_date', 'director', 'type', 'genre', 'index', 'duration'); if ($type == 'filmo-indekso-pazyma') { } else { if ($type == 'iregistruoto-filmo-israsas') { $allRights = get_terms(array('film-right'), array('fields' => 'all', 'hide_empty' => false)); $filmRights = wp_get_post_terms($post_id, 'film-right', array('fields' => 'all')); } } ini_set('default_charset', 'utf-8'); foreach ($fields as $val) { $value = $this->outputField($val); if ($val == 'title_orig' && $value == '') { $value = $this->outputField('title'); } $document->setValue($val, $value); } if (isset($allRights)) { $table = '<w:tbl>'; $table .= '<w:tblPr>'; $table .= '<w:tblW w:w = "5000" w:type="pct"/>'; //$table .= '<w:tblCellSpacing w:w="50" w:type="dxa"/>'; // $table .= '<w:tblCellPadding w:w="250" w:type="dxa"/>'; $table .= '<w:tblCellMar> <w:top w:w="50" w:type="dxa"/> <w:start w:w="50" w:type="dxa"/> <w:bottom w:w="50" w:type="dxa"/> <w:end w:w="50" w:type="dxa"/> </w:tblCellMar>'; $table .= '<w:tblBorders> <w:top w:val="single" w:sz="1" w:space="0" w:color="cccccc" /> <w:bottom w:val="single" w:sz="1" w:space="0" w:color="cccccc" /> <w:start w:val="single" w:sz="1" w:space="0" w:color="cccccc" /> <w:end w:val="single" w:sz="1" w:space="0" w:color="cccccc" /> <w:insideH w:val="single" w:sz="1" w:space="0" w:color="cccccc" /> <w:insideV w:val="single" w:sz="1" w:space="0" w:color="cccccc" /> </w:tblBorders>'; $table .= '</w:tblPr>'; // foreach($allRights as $key => $val){ // $table .= '<w:tr>'; // $table .= '<w:tc><w:p><w:r><w:t>'; // $table .= $val->name; // $table .= '</w:t></w:r></w:p></w:tc>'; // $table .= '<w:tc><w:p><w:r><w:t>'; // $result = 'Ne'; // foreach ($filmRights as $key2 => $val2) { // if($val->term_id == $val2->term_id){ // $result = 'Taip'; // break; // } // } // $table .= $result; // $table .= '</w:t></w:r></w:p></w:tc>'; // $table .= '</w:tr>'; // } foreach ($allRights as $key => $val) { foreach ($filmRights as $key2 => $val2) { if ($val->term_id == $val2->term_id) { $table .= '<w:tr>'; $table .= '<w:tc><w:p><w:r><w:t>'; $table .= $val->name; $table .= '</w:t></w:r></w:p></w:tc>'; $table .= '<w:tc><w:p><w:r><w:t>'; $table .= 'Taip'; $table .= '</w:t></w:r></w:p></w:tc>'; $table .= '</w:tr>'; break; } } } $table .= '</w:tbl>'; $document->setValue('rights', $table); } $document->save($fileOut); unset($document); header("Cache-Control: public"); header("Content-Description: File Transfer"); header("Content-Disposition: attachment; filename={$filename}"); header('Content-Type: application/vnd.ms-word; charset=utf-8'); header("Content-Transfer-Encoding: binary"); readfile($fileOut); unlink($fileOut); exit; } }
<?php ini_set("memory_limit", "256M"); set_time_limit(10000); require "../config/main.php"; require_once "PHPWord.php"; $PHPWord = new PHPWord(); $for = mssql_fetch_array(mssql_query("select * from tbformatosresultados where codigo_for={$FORMATO_RES}")); $document = $PHPWord->loadTemplate("../../main/res/" . md5("FOR" . $FORMATO_RES)); $listStyle = array('listType' => PHPWord_Style_ListItem::TYPE_NUMBER); $sql2 = mssql_query("select \nCAMPO_FOR, TIPO_FOR from \ntbformatosresultados2\nwhere formato_for=" . $FORMATO_RES); while ($row2 = mssql_fetch_array($sql2)) { $res = ''; $res = @mssql_result(mssql_query("select valor_res from tbformatosresultados3\n\twhere formato_res=" . $FORMATO_RES . " and ods_res=" . $ODS_RES . "\n\tand campo_res='" . md5($row2["CAMPO_FOR"]) . "'"), 0, 0); if ($row2["TIPO_FOR"] == 4) { if ($res == 1) { $document->setValue($row2["CAMPO_FOR"], '</w:t><w:t xml:space="preserve"> - ' . utf8_encode($row2["CAMPO_FOR"]) . '<w:br/>'); } else { $document->setValue($row2["CAMPO_FOR"], ''); } } else { $document->setValue($row2["CAMPO_FOR"], utf8_encode($res)); } } $sql2 = mssql_query("select FORMATO_FOR, CAMPO_FOR, TIPO_FOR from tbformatosresultados2\ninner join TbProductos3 on\nFORMATO_FOR = FORMATO_FPR\nINNER JOIN TBEXPEDIENTES2 ON\nBAREMO_EXP = PRODUCTO_FPR\nWHERE CODIGO_EXP=" . $ODS_RES . " AND\nFORMATO_FOR <> " . $FORMATO_RES); while ($row2 = mssql_fetch_array($sql2)) { $res = ''; $res = @mssql_result(mssql_query("select valor_res from tbformatosresultados3\n\twhere formato_res=" . $row2["FORMATO_FOR"] . " and ods_res=" . $ODS_RES . "\n\tand campo_res='" . md5($row2["CAMPO_FOR"]) . "'"), 0, 0); if ($row2["TIPO_FOR"] == 4) { if ($res == 1) { $document->setValue($row2["CAMPO_FOR"], '</w:t><w:t xml:space="preserve"> - ' . utf8_encode($row2["CAMPO_FOR"]) . '<w:br/>');
$nmaks = "0000"; } elseif (strlen($data[nomor]) == 1) { $nmaks = "000" . $data[nomor]; } elseif (strlen($data[nomor]) == 2) { $nmaks = "00" . $data[nomor]; } elseif (strlen($data[nomor]) == 3) { $nmaks = "0" . $data[nomor]; } else { $nmaks = $data[nomor]; } if ($data['ekstension'] == 1) { $text_ijin = "perpanjangan"; } else { $text_ijin = "baru"; } $document = $PHPWord->loadTemplate('template/ijin-sendiri.docx'); $document->setValue('jenis_ijin', $text_ijin); $document->setValue('kebangsaan', $data['country']); $document->setValue('kebangsaan', $data['namanegara']); $document->setValue('alamat_jalan', $data_univ['alamat_jalan']); $document->setValue('kota', $data_univ['nama_wilayah']); $document->setValue('jabatan', $data[jabatan]); $document->setValue('universitas', $data[namauniversitas]); $document->setValue('no_surat', $data[nosrtrek]); $document->setValue('Value1', $UTILITY->format_tanggal_ind($data[tglsrtrek])); //no surat //$document->setValue('surat', 'xx'); if ($data[sex] == 1) { $sex = "Mr"; } else { $sex = "Ms";
public function test_nke3_install() { $PHPWord = new PHPWord(); $document = $PHPWord->loadTemplate($this->in . '/Template2-filigrane.docx'); $info2 = array("intro__c" => "Nous vous proposons au travers de cette offre de la qualité des produits nke pour votre First.", "Name" => "FIRST", "image__c" => $this->in . '/first-image1.png', "image2__c" => $this->in . '/first-image2.jpg', "products_std" => array(array('Name' => 'Multifonction TL25', 'option__c' => 'std', 'UnitPrice' => 10, 'Quantity' => 1), array('Name' => 'Support alu brossé', 'option__c' => 'std', 'UnitPrice' => 0, 'Quantity' => 1), array('Name' => 'compas Fluxgate', 'option__c' => 'std', 'UnitPrice' => 0, 'Quantity' => 1), array('Name' => 'télcommande filaire', 'option__c' => 'std', 'UnitPrice' => 0, 'Quantity' => 1), array('Name' => 'capteur sondeur + passe coque', 'option__c' => 'std', 'UnitPrice' => 0, 'Quantity' => 1), array('Name' => 'capteur loch roue à aubes + passe coque', 'option__c' => 'std', 'UnitPrice' => 0, 'Quantity' => 1), array('Name' => 'capteur anémo-girouette avec cable', 'option__c' => 'std', 'UnitPrice' => 0, 'Quantity' => 1), array('Name' => 'interface loch sondeur', 'option__c' => 'std', 'UnitPrice' => 0, 'Quantity' => 1), array('Name' => 'x 15 m de cable', 'option__c' => 'std', 'UnitPrice' => 0, 'Quantity' => 1), array('Name' => 'boite de connexion Bus', 'option__c' => 'std', 'UnitPrice' => 0, 'Quantity' => 1)), "products_std_amount" => 3452.48, "products_std_amount_ttc" => 4129.17, "lib_std__c" => "Pack régate", "products_opt1" => array(array('Name' => 'Multifonction Gyroplilot Graphic', 'option__c' => 'opt1', 'UnitPrice' => 100, 'Quantity' => 1), array('Name' => 'calculateur avec gyro intégré', 'option__c' => 'opt1', 'UnitPrice' => 0, 'Quantity' => 1), array('Name' => 'ensemble linéraire hydraulique type40', 'option__c' => 'opt1', 'UnitPrice' => 0, 'Quantity' => 1), array('Name' => 'convertisseur 12V/12V', 'option__c' => 'opt1', 'UnitPrice' => 0, 'Quantity' => 1), array('Name' => 'capteur angle de barre', 'option__c' => 'opt1', 'UnitPrice' => 0, 'Quantity' => 1), array('Name' => 'boîte connexion bus', 'option__c' => 'opt1', 'UnitPrice' => 0, 'Quantity' => 1), array('Name' => 'filtre alimentation', 'option__c' => 'opt1', 'UnitPrice' => 0, 'Quantity' => 1), array('Name' => 'x 15 m de câble bus', 'option__c' => 'opt1', 'UnitPrice' => 0, 'Quantity' => 1)), "products_opt1_amount" => 4741.88, "products_opt1_amount_ttc" => 5671.29, "lib_opt1__c" => "Pack Gyropilote type 40", "products_opt2" => array(array('Name' => 'Carbowind (capteur anémomètre giroutte HR 1,10m', 'option__c' => 'opt2', 'UnitPrice' => 100, 'Quantity' => 1), array('Name' => 'Cable carbowind avionic - 25m (17g/m)', 'option__c' => 'opt1', 'UnitPrice' => 0, 'Quantity' => 1), array('Name' => 'Capteur de vitesse Ultrason', 'option__c' => 'opt1', 'UnitPrice' => 0, 'Quantity' => 1), array('Name' => 'Compas Régatta (Gyrostabilisé 3 axes', 'option__c' => 'opt1', 'UnitPrice' => 0, 'Quantity' => 1)), "products_opt2_amount" => 3148.24, "products_opt2_amount_ttc" => 3765.29, "lib_opt2__c" => "Capteurs Haute Résolution", "products_opt3" => array(array('Name' => 'Processor Régatta', 'option__c' => 'opt2', 'UnitPrice' => 100, 'Quantity' => 1)), "products_opt3_amount" => 5129.4, "products_opt3_amount_ttc" => 6134.76, "lib_opt3__c" => "Capteurs vent réel 25HZ"); echo "\nInfo Template \n"; foreach ($info2 as $cle => $value) { if (strpos($cle, 'image') === 0) { switch ($cle) { case 'image__c': $cleimg = 'image1.png'; break; case 'image2__c': $cleimg = 'image2.jpg'; break; } $ret = $document->remplace_image($cleimg, $value); $this->assertTrue($ret, 'return of remplace_image'); echo 'SetValue ' . $cleimg . '= ' . $value . "\n"; } else { if (!is_array($value)) { $document->setValue($cle, $value); //echo 'SetValue '.$cle . '= '. $value."\n"; } else { $lstProd = array(); foreach ($value as $prod) { $lstProd[] = $prod['Quantity'] . ' ' . $prod['Name']; } $document->setValueList($cle, $lstProd); //echo 'SetValue '.$cle . '= '. implode(',',$lstProd)."\n"; } } } $document->save($this->out . '/Templatenke3-result.docx'); }
public function hoja_tramite() { $doc = $this->input->get_post('doc'); $nrodoc = $this->input->get_post('nrodoc'); $ini = $this->input->get_post('ini'); $fin = $this->input->get_post('fin'); $estado = "Dar Tramite"; $estado1 = "Dar Tramite"; $origen = "Tramite Documentario"; $origen1 = "Tramite Documentario"; if ($nrodoc % 2 == 0) { $doc1 = $nrodoc - 1; $doc2 = $nrodoc; } else { $doc1 = $nrodoc; $doc2 = $nrodoc + 1; } $filter = new stdClass(); $filter_not = new stdClass(); $filter->tipo_doc = $doc; $filter->nrodoc = $doc1; $filter->fecha_ini = str_replace('/', '-', $ini); $filter->fecha_fin = str_replace('/', '-', $fin); $var = $this->documento_model->listarDocumentoMovimiento($filter, $filter_not); $filter->tipo_doc = $doc; $filter->nrodoc = $doc2; $filter->fecha_ini = str_replace('/', '-', $ini); $filter->fecha_fin = str_replace('/', '-', $fin); $var1 = $this->documento_model->listarDocumentoMovimiento($filter, $filter_not); if ($var == "0") { $var = '[{"nroTramite":"","dependenciaMovimiento":"","tipo":"","fechaCreada":""}]'; $var = json_decode($var); $estado = ""; $origen = ""; } if ($var1 == "0") { $var1 = '[{"nroTramite":"","dependenciaMovimiento":"","tipo":"","fechaCreada":""}]'; $var1 = json_decode($var1); $estado1 = ""; $origen1 = ""; } $PHPWord = new PHPWord(); //Searching for values to replace $document = $PHPWord->loadTemplate('./plantilla/plantilla01.docx'); $document->setValue('Tramite', $var[0]->nroTramite); $document->setValue('Tramite2', $var1[0]->nroTramite); $document->setValue('Gerencia', $origen); $document->setValue('Gerencia2', $origen1); $document->setValue('Dependencia', $var[0]->dependenciaMovimiento); $document->setValue('Dependencia2', $var1[0]->dependenciaMovimiento); $document->setValue('Tipo', $var[0]->tipo); $document->setValue('Tipo2', $var1[0]->tipo); $document->setValue('Fecha', $var[0]->fechaCreada == "" ? "" : date('d/m/Y', strtotime($var[0]->fechaCreada))); $document->setValue('Fecha2', $var1[0]->fechaCreada == "" ? "" : date('d/m/Y', strtotime($var1[0]->fechaCreada))); $document->setValue('Estado', $estado); $document->setValue('Estado2', $estado1); // save as a random file in temp file $temp_file = tempnam(sys_get_temp_dir(), 'PHPWord'); $document->save($temp_file); header("Content-Disposition: attachment; filename='hoja_tramite.doc'"); header("Content-Type: application/vnd.ms-word; charset=utf-8"); readfile($temp_file); // or echo file_get_contents($temp_file); unlink($temp_file); // remove temp file }
public function generate($id = 0) { $this->load->library('PHPWord'); $this->load->helper('util'); $date = date('Y-m-d_H-i-s'); //if ($id==0); $data = $this->db->where('id_permohonan_peng_data', $id)->join($this->cms_complete_table_name('mas_jurusan'), 'id_jurusan=fk_id_jurusan')->get($this->cms_complete_table_name('permohonan_peng_data'))->result(); $PHPWord = new PHPWord(); //Generate Document foreach ($data as $d) { $document = $PHPWord->loadTemplate('assets/surat_keluar/Permohonan Pengambilan Data/peng_data.docx'); $document->setValue('nomor_surat', $d->nomor_surat); $document->setValue('lampiran', $d->lampiran); $document->setValue('kepada', $d->kepada); $document->setValue('di', $d->di); $document->setValue('nama_mahasiswa', $d->nama_mahasiswa); $document->setValue('npm', $d->npm); $document->setValue('jurusan', $d->nama_jurusan); $document->setValue('ketua_jurusan', $d->ketua_jurusan); $document->setValue('tanggal', tanggal(date('d-m-Y'))); $document->setValue('bulan', bulan_romawi(date('m'))); $document->setValue('tahun', date('Y')); ////open file//// $objWriter = PHPWord_IOFactory::createWriter($PHPWord, 'Word2007'); $filename = $d->npm . '-Surat_Permohonan_Peng_Data.docx'; $document->save($filename); header('Content-Description: File Transfer'); header('Content-Type: application/octet-stream'); header('Content-Disposition: attachment; filename=' . $filename); header('Content-Transfer-Encoding: binary'); header('Expires: 0'); header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); header('Pragma: public'); header('Content-Length: ' . filesize($filename)); flush(); readfile($filename); unlink($filename); // deletes the temporary file exit; } ////end of open file//// ///save file//// //$document->save('assets/docs/'.$d->nama_kar.'-'.$d->id_pegawai.'.docx'); //redirect(base_url().'assets/docs/'.$d->nama_kar.'-'.$d->id_pegawai.'.docx', 'assets/manage_pegawai'); ///end of save file//// }
public function cetak($id_pegawai = false, $tahun = false) { require_once $this->server_root . 'system/cms/libraries/PHPWord.php'; $PHPWord = new PHPWord(); $path = $this->server_root . 'assets/file/skp/template/'; $document = $PHPWord->loadTemplate($path . 'FORMAT_LEMBAR_PENILAIAN.docx'); $arr = $this->set_value(); foreach ($arr as $key => $field) { // dump($key); $document->setValue($key, $field); } // $a_penilai = $this->get_penilai_atasan($id_skp_penilai); // foreach($a_penilai as $k => $f){ // $document->setValue($k, $f); // } $path = $this->server_root . 'assets/file/skp/lembarpenilaian/' . $tahun . '/'; $document->save($path . $id_pegawai . '.docx'); }
//Format Tanggal Berbahasa Indonesia // Array Hari $array_hari = array(1 => 'Senin', 'Selasa', 'Rabu', 'Kamis', 'Jumat', 'Sabtu', 'Minggu'); $hari = $array_hari[date('N')]; //Format Tanggal $tanggal = date('j'); //Array Bulan $array_bulan = array(1 => 'Januari', 'Februari', 'Maret', 'April', 'Mei', 'Juni', 'Juli', 'Agustus', 'September', 'Oktober', 'November', 'Desember'); $bulan = $array_bulan[date('n')]; //Format Tahun $tahun = date('Y'); // Include the PHPWord.php, all other classes were loaded by an autoloader include '../../../../../plugin/PHPWord.php'; // Create a new PHPWord Object $PHPWord = new PHPWord(); $document = $PHPWord->loadTemplate('../../../../../surat/Surat_Pemberitahuan_Jatuh_Tempo.docx'); //header $document->setValue('nama_pembeli', $nama); $path = 'E:\\'; $namafile = "Surat_Pemberitahuan_Jatuh_Tempo_" . "_" . "_" . date('d F Y') . ".docx"; // $document->save('E:\\andonnikahTemplate.docx'); //$document->save('E:\\'.$nama_file); // At least write the document to webspace: $objWriter = PHPWord_IOFactory::createWriter($PHPWord, 'Word2007'); // // save as a random file in temp file $temp_file = tempnam(sys_get_temp_dir(), 'PHPWord'); $document->save($temp_file); // Your browser will name the file "myFile.docx" // regardless of what it's named on the server header('Content-Disposition: attachment; filename="' . rawurlencode($namafile) . '"'); header('Content-Transfer-Encoding: binary');
<?php // examples header("Content-type: text/html; charset=utf-8"); require_once '../PHPWord.php'; $PHPWord = new PHPWord(); $document = $PHPWord->loadTemplate('source.docx'); // simple parsing $document->setValue('{var1}', 'value'); $document->setValue('{var2}', 'Clone'); $document->setValue('{var3}', 'ONE', 1); // prepare data for tables $data1 = array('num' => array(1, 2, 3), 'color' => array('red', 'blue', 'green'), 'code' => array('ff0000', '0000ff', '00ff00')); $data2 = array('val1' => array(1, 2, 3), 'val2' => array('red', 'blue', 'green'), 'val3' => array('a', 'b', 'c')); $data3 = array('day' => array('Mon', 'Tue', 'Wed', 'Thu', 'Fri'), 'dt' => array(12, 14, 13, 11, 10), 'nt' => array(0, 2, 1, 2, -1), 'dw' => array('SSE at 3 mph', 'SE at 2 mph', 'S at 3 mph', 'S at 1 mph', 'Calm'), 'nw' => array('SSE at 1 mph', 'SE at 1 mph', 'S at 1 mph', 'Calm', 'Calm')); $data4 = array('val1' => array('blue 1', 'blue 2', 'blue 3'), 'val2' => array('green 1', 'green 2', 'green 3'), 'val3' => array('red 1', 'red 2', 'red 3')); // clone rows $document->cloneRow('TBL1', $data1); $document->cloneRow('TBL2', $data2); $document->cloneRow('DATA3', $data3); $document->cloneRow('T4', $data4); $document->cloneRow('DinamicTable', $data4); // save file $tmp_file = 'result.docx'; $document->save($tmp_file); print date("Y-m-d H:i:s") . " <br>"; print "source.docx → result.docx <br>"; print "complete.";
public function generate($id = 0) { $this->load->library('PHPWord'); $this->load->helper('util'); $date = date('Y-m-d_H-i-s'); //if ($id==0); $conf = $this->db->get($this->cms_complete_table_name('konfigurasi'))->result(); $data = $this->db->where('id_kelakuan_baik', $id)->join($this->cms_complete_table_name('mas_jurusan'), 'id_jurusan=fk_id_jurusan')->get($this->cms_complete_table_name('kelakuan_baik'))->result(); $PHPWord = new PHPWord(); //Generate Document foreach ($data as $d) { $document = $PHPWord->loadTemplate('assets/surat_keluar/Ket. Kelakuan Baik/kelakuan_baik.docx'); $document->setValue('nomor_surat', $d->nomor_surat); $document->setValue('nama_mahasiswa', $d->nama_mahasiswa); $document->setValue('npm', $d->npm); $document->setValue('tempat_lahir', $d->tempat_lahir); $document->setValue('tanggal_lahir', tanggal(date($d->tanggal_lahir))); $document->setValue('jurusan', $d->nama_jurusan); $document->setValue('semester', $d->semester); $document->setValue('tahun_akademis', $d->tahun_akademis); $document->setValue('tanggal', tanggal(date('d-m-Y'))); $document->setValue('bulan', bulan_romawi(date('m'))); $document->setValue('tahun', date('Y')); foreach ($conf as $c) { $document->setValue('nama_instansi', $c->nama_instansi); $document->setValue('alamat', $c->alamat); $document->setValue('status_akreditasi', $c->status_akreditasi); $document->setValue('nama_puket', $c->nama_puket); $document->setValue('pangkat_puket', $c->pangkat_puket); } ////open file//// $objWriter = PHPWord_IOFactory::createWriter($PHPWord, 'Word2007'); $filename = $d->npm . '-Surat_Kelakuan_Baik.docx'; $document->save($filename); header('Content-Description: File Transfer'); header('Content-Type: application/octet-stream'); header('Content-Disposition: attachment; filename=' . $filename); header('Content-Transfer-Encoding: binary'); header('Expires: 0'); header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); header('Pragma: public'); header('Content-Length: ' . filesize($filename)); flush(); readfile($filename); unlink($filename); // deletes the temporary file exit; } ////end of open file//// ///save file//// //$document->save('assets/docs/'.$d->nama_kar.'-'.$d->id_pegawai.'.docx'); //redirect(base_url().'assets/docs/'.$d->nama_kar.'-'.$d->id_pegawai.'.docx', 'assets/manage_pegawai'); ///end of save file//// }
foreach ((array) $cb_data as $id) { $query = "SELECT * FROM RESERVE WHERE KODE_BLOK = '{$id}'"; $obj = $conn->execute($query); $kode_blok = $obj->fields['KODE_BLOK']; $nama_calon_pembeli = $obj->fields['NAMA_CALON_PEMBELI']; $tanggal_reserve = tgltgl(date("d-m-Y", strtotime($obj->fields['TANGGAL_RESERVE']))); $berlaku_sampai = tgltgl(date("d-m-Y", strtotime($obj->fields['BERLAKU_SAMPAI']))); $alamat = $obj->fields['ALAMAT']; $telepon = $obj->fields['TELEPON']; $agen = $obj->fields['AGEN']; $koordinator = $obj->fields['KOORDINATOR']; $tanggal_cetak = date('d-m-Y H:i:s'); // Include the PHPWord.php, all other classes were loaded by an autoloader // Create a new PHPWord Object $PHPWord = new PHPWord(); $document = $PHPWord->loadTemplate('../../../../../config/Template/surat/spp/Surat_Reserve.doc'); //header $document->setValue('tanggal_cetak', $tanggal_cetak); $document->setValue('kode_blok', $kode_blok); $document->setValue('nama_calon_pembeli', $nama_calon_pembeli); $document->setValue('alamat', $alamat); $document->setValue('telepon', $telepon); $document->setValue('tanggal_reserve', $tanggal_reserve); $document->setValue('berlaku_sampai', $berlaku_sampai); $document->setValue('agen', $agen); $document->setValue('koordinator', $koordinator); $kode_blok = explode("/", $kode_blok); $kode_blok = implode("", $kode_blok); $nama_calon_pembeli = explode("/", $nama_calon_pembeli); $nama_calon_pembeli = implode("", $nama_calon_pembeli); $nama_file = "SURAT RESERVE " . trim($kode_blok) . " " . $nama_calon_pembeli . " " . $tanggal . " " . $bulan . " " . $tahun . ".doc";
<?php require_once 'PHPWord.php'; $PHPWord = new PHPWord(); $document = $PHPWord->loadTemplate('Templateku.docx'); foreach ($lhs as $row) { $typekendaraan = $row->type_kendaraan; $modelkendaraan = $row->model_kendaraan; $nopolisi = $row->no_polisi; $nokuasa = $row->no_kuasa; $tglkuasa = date("d-M-Y", strtotime($row->terbit_kuasa)); $nm_asuransi = $row->nm_asuransi; $id = $row->id_surat_tugas; $terimakuasa = date("d-M-Y", strtotime($row->terima_kuasa)); $nmtertanggung = $row->nm_tertanggung; $almt_tertanggung = $row->almt_tertanggung; $nopolis = $row->no_polis; $tglberlaku = date("d-M-Y", strtotime($row->tgl_berlaku)); $tglkedaluwarsa = date("d-M-Y", strtotime($row->tgl_kedaluwarsa)); $surveyor = $row->nm_surveyor; $ket = $row->uraian_singkat; $saksi1 = $row->saksi1; $almt_saksi1 = $row->almt_saksi1; $ket_saksi1 = $row->ket_saksi1; $saksi2 = $row->saksi2; $almt_saksi2 = $row->almt_saksi2; $ket_saksi2 = $row->ket_saksi2; $saksi3 = $row->saksi3; $almt_saksi3 = $row->almt_saksi3; $ket_saksi3 = $row->ket_saksi3; $saksi4 = $row->saksi4;