function reporte($ano, $idEveUsr) { global $db, $db2, $workbook, $mscIdUsuario, $hoy; // HTTP headers HeaderingExcel('chasisTrackingActual.xls'); // Creating the first worksheet $worksheet1 =& $workbook->add_worksheet('Hoja1'); $fntTit =& $workbook->add_format(); $fntTit->set_size(12); $fntTit->set_bold(); $fntTit->set_color('#E0D196'); // Font Black Normal $fntFit =& $workbook->add_format(); $fntFit->set_size(10); $fntBlk =& $workbook->add_format(); $fntBlk->set_size(10); $fntBlk->set_color('black'); $fntBlk->set_bold(); $fntEnc =& $workbook->add_format(); $fntEnc->set_size(10); $fntEnc->set_color('black'); $fntEnc->set_bold(); $fntEnc->set_align('center'); $fntEnc->set_fg_color('silver'); $fntEnc->set_pattern(); $cliente = getValueTable("cliente", "D_CLIENTE", "id_cliente", $idCliente); $usuario = getValueTable("Nombre", "USUARIO", "Id_usuario", $mscIdUsuario); // Encabezado $pais = getValueTable("pais", "INFO", "id_info", 1); $worksheet1->write_string(0, 0, "SION :: Mediteranean Shipping Company {$pais}, S.A. DE C.V.", $fntTit); $worksheet1->write_string(2, 0, "Reporte : Tracking-Actual", $fntFit); $worksheet1->write_string(3, 0, "Fecha : {$hoy} ", $fntFit); $worksheet1->write_string(2, 4, "Modulo : Intermodal", $fntFit); $worksheet1->write_string(3, 4, "Elaboro: {$usuario} ", $fntFit); // Sub-Encabezado $worksheet1->set_column(0, 0, 15); $worksheet1->set_column(1, 1, 7); $worksheet1->set_column(2, 2, 15); $worksheet1->set_column(3, 3, 30); $worksheet1->set_column(4, 5, 13); $worksheet1->set_column(6, 6, 17); $worksheet1->set_column(7, 7, 30); $worksheet1->set_column(8, 8, 20); $worksheet1->set_column(9, 9, 40); $worksheet1->write_string(5, 0, "No.Chasis", $fntEnc); $worksheet1->write_string(5, 1, "Tipo", $fntEnc); $worksheet1->write_string(5, 2, "Conte", $fntEnc); $worksheet1->write_string(5, 3, "Movimiento", $fntEnc); $worksheet1->write_string(5, 4, "Fecha", $fntEnc); $worksheet1->write_string(5, 5, "Hora", $fntEnc); $worksheet1->write_string(5, 6, "Transportista", $fntEnc); $worksheet1->write_string(5, 7, "Predio", $fntEnc); $worksheet1->write_string(5, 8, "Booking", $fntEnc); $worksheet1->write_string(5, 9, "Notas", $fntEnc); $r = 6; // INCLUIR DATOS $workbook->close(); }
require_once 'Worksheet.php'; require_once 'Workbook.php'; require_once 'connect.php'; $id_get = $_POST['id_get']; $semester = $_POST['semester']; $sy = $_POST['sy']; function HeaderingExcel($filename) { header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename={$filename}"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0,pre-check=0"); header("Pragma: public"); } // HTTP headers HeaderingExcel('teacher.xls'); // Creating a workbook $workbook = new excel("-"); // Creating the first worksheet $worksheet1 =& $workbook->add_worksheet('teacher'); $worksheet1->freeze_panes(1, 0); $worksheet1->set_column(0, 0, 25); $worksheet1->set_column(1, 1, 20); $worksheet1->set_column(1, 2, 20); $worksheet1->set_column(1, 3, 20); $worksheet1->set_column(1, 4, 20); $worksheet1->set_column(1, 5, 20); $worksheet1->set_column(1, 6, 20); //row $worksheet1->set_row(8, 50); $query = mysql_query("select * from schedule where teacher='{$id_get}' and semester='{$semester}' and sy='{$sy}'") or die(mysql_error());
} if (isset($_GET["klui"]) && $_GET["klui"] != "" && $_GET["klui"] != "0") { $filter .= "AND klui = '" . $_GET["klui"] . "'"; } $posisi = $_GET["posisi"]; $batas = $_GET["lim"]; $query = "SELECT\n\t\t\t\t\t\t\t\t\ta.id_perusahaan, a.nama, a.alamat,\n\t\t\t\t\t\t\t\t\ta_k.kecamatan, a_kel.kelurahan,\n\t\t\t\t\t\t\t\t\ta.telpon, a.kode_pos,\n\t\t\t\t\t\t\t\t\ta.nomor_akte,a.tgl_pendirian, \n\t\t\t\t\t\t\t\t\ta_j.jenis, a_s.status,\n\t\t\t\t\t\t\t\t\ta.nama_pemilik, a.nama_pengurus,\n\t\t\t\t\t\t\t\t\ta.alamat_pemilik, a.alamat_pengurus,a_m.status,a_mod.modal,\n\t\t\t\t\t\t\t\t\ta_tbl.wnilk, a_tbl.wnipr, a_tbl.wnalk, a_tbl.wnapr, c.nama_bagian ,a.klui\n\t\t\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\t\tdb_jamsostek a\n\t\t\t\t\t\t\t\t\tLEFT JOIN t_jenis_usaha a_j ON a.jenis_usaha = a_j.id_jenis_usaha\n\t\t\t\t\t\t\t\t\tLEFT JOIN t_status_milik a_m ON a.id_status_pemilik = a_m.id_status\n\t\t\t\t\t\t\t\t\tLEFT JOIN t_status_modal a_mod ON a.id_status_permodalan = a_mod.id_status\n\t\t\t\t\t\t\t\t\tLEFT JOIN t_status a_s ON a.id_status_perusahaan = a_s.id_status\n\t\t\t\t\t\t\t\t\tLEFT JOIN t_kecamatan a_k ON a.kec = a_k.id_kecamatan\n\t\t\t\t\t\t\t\t\tLEFT JOIN t_kelurahan a_kel ON a.kel = a_kel.id_kelurahan\n\t\t\t\t\t\t\t\t\tLEFT JOIN tbl_tenagakerja_jamsos a_tbl ON a.id_perusahaan = a_tbl.id_perusahaan\n\t\t\t\t\t\t\t\t\tLEFT JOIN kbli c ON a.klui = c.kode_bagian\n\t\t\t\t\t\t\t\t\twhere {$filter}\n\t\t\t\t\t\t\t\t\torder by nama asc \n\t\t\t\t\t\t\t\t\tlimit " . $posisi . "," . $batas . ""; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Daftar_perusahaan.xls'); $workbook = new Workbook("-"); $worksheet =& $workbook->add_worksheet("Sheet "); $a =& $workbook->add_format(); $a->set_size(14); $a->set_bold(); $a->set_align('center'); $b =& $workbook->add_format(); $b->set_border(1); $b->set_pattern(); $b->set_fg_color('cyan'); $c =& $workbook->add_format(); $c->set_border(1); $worksheet->write_string(0, 0, "Tabel Data Perusahaan", $a); //$worksheet->write_string(0,0,$query,$a); $worksheet->merge_cells(0, 0, 0, 21);
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_berkas_selesai.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
//menyertakan semua class yang diperlukan require_once 'OLEwriter.php'; require_once 'BIFFwriter.php'; require_once 'Worksheet.php'; require_once 'Workbook.php'; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } //http headers HeaderingExcel('test2.xls'); //membuat workbook $workbook = new Workbook("-"); //membuat worksheet pertama $fBold =& $workbook->add_format(); $fBold->set_bold(); $fItalic =& $workbook->add_format(); $fItalic->set_italic(); $fUnderline =& $workbook->add_format(); $fUnderline->set_underline(1); $fUnderline2 =& $workbook->add_format(); $fUnderline2->set_underline(2); $fBesar =& $workbook->add_format(); $fBesar->set_size(50); $fUnderlineItalic =& $workbook->add_format(); $fUnderlineItalic->set_underline(1);
$tahun_ini = date('Y'); if ($bulan > 6) { $tahun_ajaran = $tahun_ini - 1994; } else { $tahun_ajaran = $tahun_ini - 1995; } $tahun_ajaran++; //Query data yang akan di export ke Excel mysql_select_db($database_cn_dbpas, $cn_dbpas); $query_rs_calsis = "SELECT * FROM t_calon_siswa WHERE KD_TAHUN_AJARAN = '{$tahun_ajaran}' ORDER BY NO_CALSIS DESC"; $rs_calsis = mysql_query($query_rs_calsis, $cn_dbpas) or die(mysql_error()); $row_rs_calsis = mysql_fetch_assoc($rs_calsis); $totalRows_rs_calsis = mysql_num_rows($rs_calsis); $total = $totalRows_rs_calsis; //http headers HeaderingExcel('CalonSiswa.xls'); //membuat workbook $workbook = new Workbook("-"); $worksheet1 =& $workbook->add_worksheet("Calon Siswa"); $judul =& $workbook->add_format(); //Memformat header (judul) tabel dengan font bold, horiz rata tengah dan verical rata tengah $judul->set_bold(); $judul->set_align('center'); $judul->set_align('vcenter'); $jdl =& $workbook->add_format(); //Memformat Judul dengan font tebal, wanrna biru, hiriz rata kiri, verti rata tengah dan ukuran font 12 $jdl->set_bold(); $jdl->set_color('blue'); $jdl->set_align('left'); $jdl->set_align('vcenter'); $jdl->set_size(12);
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_iplk_selesai.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_wl_belum.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_wl.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_berkas_arsip.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_berkas_serah.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_resi.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_berkas_proses.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
//include all support file require_once 'OLEwriter.php'; require_once 'BIFFwriter.php'; require_once 'Worksheet.php'; require_once 'Workbook.php'; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } //http headers HeaderingExcel('test4.xls'); //make a workbook $workbook = new Workbook("-"); //make first worksheet $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fBesar =& $workbook->add_format(); $fBesar->set_size(20); $fKutipan =& $workbook->add_format(); $fKutipan->set_align('right'); $fKutipan->set_italic(); $fKutipan->set_size(8); $fKutipan->set_color('blue'); $fList =& $workbook->add_format();
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_pengaduan_mediator.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_pp.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_pp_proses.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
function reporte($idNaviera) { global $db, $db2, $workbook, $sesIdUsuario, $hoy; // HTTP headers HeaderingExcel('recap.xls'); // Creating the first worksheet $worksheet1 =& $workbook->add_worksheet('Hoja1'); $fntTit =& $workbook->add_format(); $fntTit->set_size(12); $fntTit->set_bold(); $fntTit->set_color('#E0D196'); // Font Black Normal $fntFit =& $workbook->add_format(); $fntFit->set_size(10); $fntBlk =& $workbook->add_format(); $fntBlk->set_size(10); $fntBlk->set_color('black'); $fntBlk->set_bold(); $fntEnc =& $workbook->add_format(); $fntEnc->set_size(10); $fntEnc->set_color('black'); $fntEnc->set_bold(); $fntEnc->set_align('center'); $fntEnc->set_fg_color('silver'); $fntEnc->set_pattern(); $usuario = getValueTable("usuario", "USUARIO", "id_usuario", $sesIdUsuario); $naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNaviera); // Encabezado $worksheet1->write_string(0, 0, "TRANSPORTES MALEJA S.A. DE C.V.", $fntTit); $worksheet1->write_string(2, 0, "Reporte : Recapitulación", $fntFit); $worksheet1->write_string(3, 0, "Fecha : {$hoy} ", $fntFit); $worksheet1->write_string(4, 0, "Naviera : {$naviera} ", $fntFit); $worksheet1->write_string(2, 4, "Modulo : Inventario ", $fntFit); $worksheet1->write_string(3, 4, "Elaboro: {$usuario} ", $fntFit); // Sub-Encabezado $worksheet1->set_column(0, 10, 15); // ---------------------------------------------------------- // EL TREBOL // ---------------------------------------------------------- $worksheet1->write_string(6, 0, ".:: El Trébol ::.", $fntEnc); $worksheet1->write_string(7, 0, "Total", $fntEnc); $worksheet1->write_string(7, 1, "Dañados", $fntEnc); $worksheet1->write_string(7, 2, "A", $fntEnc); $worksheet1->write_string(7, 3, "B", $fntEnc); $worksheet1->write_string(7, 4, "C", $fntEnc); $worksheet1->write_string(7, 5, "D", $fntEnc); $worksheet1->write_string(7, 6, "FG", $fntEnc); $worksheet1->write_string(7, 7, "GC", $fntEnc); $worksheet1->write_string(8, 0, "20' DC", $fntEnc); $worksheet1->write_string(9, 0, "40' DC", $fntEnc); $worksheet1->write_string(10, 0, "40' HC", $fntEnc); // 20 DC $dc20DM = getCountConte('trebol', $idNaviera, '20DC', 'DM'); $worksheet1->write_number(8, 1, $dc20DM, $fntFit); $dc20A = getCountConte('trebol', $idNaviera, '20DC', 'A'); $worksheet1->write_number(8, 2, $dc20A, $fntFit); $dc20B = getCountConte('trebol', $idNaviera, '20DC', 'B'); $worksheet1->write_number(8, 3, $dc20B, $fntFit); $dc20C = getCountConte('trebol', $idNaviera, '20DC', 'C'); $worksheet1->write_number(8, 4, $dc20C, $fntFit); $dc20D = getCountConte('trebol', $idNaviera, '20DC', 'D'); $worksheet1->write_number(8, 5, $dc20D, $fntFit); $dc20FG = getCountConte('trebol', $idNaviera, '20DC', 'FG'); $worksheet1->write_number(8, 6, $dc20FG, $fntFit); $dc20GC = getCountConte('trebol', $idNaviera, '20DC', 'GC'); $worksheet1->write_number(8, 7, $dc20GC, $fntFit); // 40 DC $dc40DM = getCountConte('trebol', $idNaviera, '40DC', 'DM'); $worksheet1->write_number(9, 1, $dc40DM, $fntFit); $dc40A = getCountConte('trebol', $idNaviera, '40DC', 'A'); $worksheet1->write_number(9, 2, $dc40A, $fntFit); $dc40B = getCountConte('trebol', $idNaviera, '40DC', 'B'); $worksheet1->write_number(9, 3, $dc40B, $fntFit); $dc40C = getCountConte('trebol', $idNaviera, '40DC', 'C'); $worksheet1->write_number(9, 4, $dc40C, $fntFit); $dc40D = getCountConte('trebol', $idNaviera, '40DC', 'D'); $worksheet1->write_number(9, 5, $dc40D, $fntFit); $dc40FG = getCountConte('trebol', $idNaviera, '40DC', 'FG'); $worksheet1->write_number(9, 6, $dc40FG, $fntFit); $dc40GC = getCountConte('trebol', $idNaviera, '40DC', 'GC'); $worksheet1->write_number(9, 7, $dc40GC, $fntFit); // 40 HC $dc40HCDM = getCountConte('trebol', $idNaviera, '40HC', 'DM'); $worksheet1->write_number(10, 1, $dc40HCDM, $fntFit); $dc40HCA = getCountConte('trebol', $idNaviera, '40HC', 'A'); $worksheet1->write_number(10, 2, $dc40HCA, $fntFit); $dc40HCB = getCountConte('trebol', $idNaviera, '40HC', 'B'); $worksheet1->write_number(10, 3, $dc40HCB, $fntFit); $dc40HCC = getCountConte('trebol', $idNaviera, '40HC', 'C'); $worksheet1->write_number(10, 4, $dc40HCC, $fntFit); $dc40HCD = getCountConte('trebol', $idNaviera, '40HC', 'D'); $worksheet1->write_number(10, 5, $dc40HCD, $fntFit); $dc40HCFG = getCountConte('trebol', $idNaviera, '40HC', 'FG'); $worksheet1->write_number(10, 6, $dc40HCFG, $fntFit); $dc40HCGC = getCountConte('trebol', $idNaviera, '40HC', 'GC'); $worksheet1->write_number(10, 7, $dc40HCGC, $fntFit); // ---------------------------------------------------------- // EL PINO // ---------------------------------------------------------- $worksheet1->write_string(13, 0, ".:: El Pino ::.", $fntEnc); $worksheet1->write_string(14, 0, "Total", $fntEnc); $worksheet1->write_string(14, 1, "Dañados", $fntEnc); $worksheet1->write_string(14, 2, "A", $fntEnc); $worksheet1->write_string(14, 3, "B", $fntEnc); $worksheet1->write_string(14, 4, "C", $fntEnc); $worksheet1->write_string(14, 5, "D", $fntEnc); $worksheet1->write_string(14, 6, "FG", $fntEnc); $worksheet1->write_string(14, 7, "GC", $fntEnc); $worksheet1->write_string(15, 0, "20' DC", $fntEnc); $worksheet1->write_string(16, 0, "40' DC", $fntEnc); $worksheet1->write_string(17, 0, "40' HC", $fntEnc); // 20 DC $dc20DM = getCountConte('pino', $idNaviera, '20DC', 'DM'); $worksheet1->write_number(15, 1, $dc20DM, $fntFit); $dc20A = getCountConte('pino', $idNaviera, '20DC', 'A'); $worksheet1->write_number(15, 2, $dc20A, $fntFit); $dc20B = getCountConte('pino', $idNaviera, '20DC', 'B'); $worksheet1->write_number(15, 3, $dc20B, $fntFit); $dc20C = getCountConte('pino', $idNaviera, '20DC', 'C'); $worksheet1->write_number(15, 4, $dc20C, $fntFit); $dc20D = getCountConte('pino', $idNaviera, '20DC', 'D'); $worksheet1->write_number(15, 5, $dc20D, $fntFit); $dc20FG = getCountConte('pino', $idNaviera, '20DC', 'FG'); $worksheet1->write_number(15, 6, $dc20FG, $fntFit); $dc20GC = getCountConte('pino', $idNaviera, '20DC', 'GC'); $worksheet1->write_number(15, 7, $dc20GC, $fntFit); // 40 DC $dc40DM = getCountConte('pino', $idNaviera, '40DC', 'DM'); $worksheet1->write_number(16, 1, $dc40DM, $fntFit); $dc40A = getCountConte('pino', $idNaviera, '40DC', 'A'); $worksheet1->write_number(16, 2, $dc40A, $fntFit); $dc40B = getCountConte('pino', $idNaviera, '40DC', 'B'); $worksheet1->write_number(16, 3, $dc40B, $fntFit); $dc40C = getCountConte('pino', $idNaviera, '40DC', 'C'); $worksheet1->write_number(16, 4, $dc40C, $fntFit); $dc40D = getCountConte('pino', $idNaviera, '40DC', 'D'); $worksheet1->write_number(16, 5, $dc40D, $fntFit); $dc40FG = getCountConte('pino', $idNaviera, '40DC', 'FG'); $worksheet1->write_number(16, 6, $dc40FG, $fntFit); $dc40GC = getCountConte('pino', $idNaviera, '40DC', 'GC'); $worksheet1->write_number(16, 7, $dc40GC, $fntFit); // 40 HC $dc40HCDM = getCountConte('pino', $idNaviera, '40HC', 'DM'); $worksheet1->write_number(17, 1, $dc40HCDM, $fntFit); $dc40HCA = getCountConte('pino', $idNaviera, '40HC', 'A'); $worksheet1->write_number(17, 2, $dc40HCA, $fntFit); $dc40HCB = getCountConte('pino', $idNaviera, '40HC', 'B'); $worksheet1->write_number(17, 3, $dc40HCB, $fntFit); $dc40HCC = getCountConte('pino', $idNaviera, '40HC', 'C'); $worksheet1->write_number(17, 4, $dc40HCC, $fntFit); $dc40HCD = getCountConte('pino', $idNaviera, '40HC', 'D'); $worksheet1->write_number(17, 5, $dc40HCD, $fntFit); $dc40HCFG = getCountConte('pino', $idNaviera, '40HC', 'FG'); $worksheet1->write_number(17, 6, $dc40HCFG, $fntFit); $dc40HCGC = getCountConte('pino', $idNaviera, '40HC', 'GC'); $worksheet1->write_number(17, 7, $dc40HCGC, $fntFit); // ---------------------------------------------------------- // EL ARBOL // ---------------------------------------------------------- $worksheet1->write_string(20, 0, ".:: El Arbol ::.", $fntEnc); $worksheet1->write_string(21, 0, "Total", $fntEnc); $worksheet1->write_string(21, 1, "Dañados", $fntEnc); $worksheet1->write_string(21, 2, "A", $fntEnc); $worksheet1->write_string(21, 3, "B", $fntEnc); $worksheet1->write_string(21, 4, "C", $fntEnc); $worksheet1->write_string(21, 5, "D", $fntEnc); $worksheet1->write_string(21, 6, "FG", $fntEnc); $worksheet1->write_string(21, 7, "GC", $fntEnc); $worksheet1->write_string(22, 0, "20' DC", $fntEnc); $worksheet1->write_string(23, 0, "40' DC", $fntEnc); $worksheet1->write_string(24, 0, "40' HC", $fntEnc); // 20 DC $dc20DM = getCountConte('arbol', $idNaviera, '20DC', 'DM'); $worksheet1->write_number(22, 1, $dc20DM, $fntFit); $dc20A = getCountConte('arbol', $idNaviera, '20DC', 'A'); $worksheet1->write_number(22, 2, $dc20A, $fntFit); $dc20B = getCountConte('arbol', $idNaviera, '20DC', 'B'); $worksheet1->write_number(22, 3, $dc20B, $fntFit); $dc20C = getCountConte('arbol', $idNaviera, '20DC', 'C'); $worksheet1->write_number(22, 4, $dc20C, $fntFit); $dc20D = getCountConte('arbol', $idNaviera, '20DC', 'D'); $worksheet1->write_number(22, 5, $dc20D, $fntFit); $dc20FG = getCountConte('arbol', $idNaviera, '20DC', 'FG'); $worksheet1->write_number(22, 6, $dc20FG, $fntFit); $dc20GC = getCountConte('arbol', $idNaviera, '20DC', 'GC'); $worksheet1->write_number(22, 7, $dc20GC, $fntFit); // 40 DC $dc40DM = getCountConte('arbol', $idNaviera, '40DC', 'DM'); $worksheet1->write_number(23, 1, $dc40DM, $fntFit); $dc40A = getCountConte('arbol', $idNaviera, '40DC', 'A'); $worksheet1->write_number(23, 2, $dc40A, $fntFit); $dc40B = getCountConte('arbol', $idNaviera, '40DC', 'B'); $worksheet1->write_number(23, 3, $dc40B, $fntFit); $dc40C = getCountConte('arbol', $idNaviera, '40DC', 'C'); $worksheet1->write_number(23, 4, $dc40C, $fntFit); $dc40D = getCountConte('arbol', $idNaviera, '40DC', 'D'); $worksheet1->write_number(23, 5, $dc40D, $fntFit); $dc40FG = getCountConte('arbol', $idNaviera, '40DC', 'FG'); $worksheet1->write_number(23, 6, $dc40FG, $fntFit); $dc40GC = getCountConte('arbol', $idNaviera, '40DC', 'GC'); $worksheet1->write_number(23, 7, $dc40GC, $fntFit); // 40 HC $dc40HCDM = getCountConte('arbol', $idNaviera, '40HC', 'DM'); $worksheet1->write_number(24, 1, $dc40HCDM, $fntFit); $dc40HCA = getCountConte('arbol', $idNaviera, '40HC', 'A'); $worksheet1->write_number(24, 2, $dc40HCA, $fntFit); $dc40HCB = getCountConte('arbol', $idNaviera, '40HC', 'B'); $worksheet1->write_number(24, 3, $dc40HCB, $fntFit); $dc40HCC = getCountConte('arbol', $idNaviera, '40HC', 'C'); $worksheet1->write_number(24, 4, $dc40HCC, $fntFit); $dc40HCD = getCountConte('arbol', $idNaviera, '40HC', 'D'); $worksheet1->write_number(24, 5, $dc40HCD, $fntFit); $dc40HCFG = getCountConte('arbol', $idNaviera, '40HC', 'FG'); $worksheet1->write_number(24, 6, $dc40HCFG, $fntFit); $dc40HCGC = getCountConte('arbol', $idNaviera, '40HC', 'GC'); $worksheet1->write_number(24, 7, $dc40HCGC, $fntFit); $workbook->close(); }
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_iplk_proses.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('data_potensial.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_imta.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_dpkk.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_berkas_sudah_lengkap.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_pp_selesai.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_berkas_arsip_sudah.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_pengaduan_selesai.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
<? //ini_set('max_execution_time', 0); set_time_limit(10); require_once($_SERVER['DOCUMENT_ROOT']."/siskeu_smk2/lib/WriteExcel/Worksheet.php"); require_once($_SERVER['DOCUMENT_ROOT']."/siskeu_smk2/lib/WriteExcel/Workbook.php"); require_once("headering_excel.php"); require_once("business/rekap_siswa.class.php"); $idKelas = $_GET['i']; $jenjangKelas = $_GET['j']; $nama_file = 'presensi.ods'; HeaderingExcel($nama_file); $workbook = new Workbook('-'); $h3 = & $workbook->add_format(); $h3->set_bold(); $h3->set_size(11); $h3->set_align('center'); $h3->set_align('vcenter'); $h3->set_text_wrap(); $h4 = & $workbook->add_format(); $h4->set_bold(); $h4->set_size(10); $h4->set_align('center'); $h4->set_align('vcenter'); $h4->set_border(1); $h4->set_text_wrap();
function reporte($idNaviera) { global $db, $db2, $workbook, $sesIdUsuario, $hoy; $sesIdOficina = $_SESSION['sesIdOficina']; $oficina = getValueTable("oficina", "OFICINA", "id_oficina", $sesIdOficina); $oficina = strtoupper($oficina); // HTTP headers HeaderingExcel('recap.xls'); // Creating the first worksheet $worksheet1 =& $workbook->add_worksheet('Hoja1'); $fntTit =& $workbook->add_format(); $fntTit->set_size(12); $fntTit->set_bold(); $fntTit->set_color('#E0D196'); // Font Black Normal $fntFit =& $workbook->add_format(); $fntFit->set_size(10); $fntBlk =& $workbook->add_format(); $fntBlk->set_size(10); $fntBlk->set_color('black'); $fntBlk->set_bold(); $fntEnc =& $workbook->add_format(); $fntEnc->set_size(10); $fntEnc->set_color('black'); $fntEnc->set_bold(); $fntEnc->set_align('center'); $fntEnc->set_fg_color('silver'); $fntEnc->set_pattern(); $usuario = getValueTable("usuario", "USUARIO", "id_usuario", $sesIdUsuario); $naviera = getValueTable("naviera", "NAVIERA", "id_naviera", $idNaviera); // Encabezado $worksheet1->write_string(0, 0, "MODULO DE PATIO", $fntTit); $worksheet1->write_string(2, 0, "Reporte : Recapitulación - {$oficina} ", $fntFit); $worksheet1->write_string(3, 0, "Fecha : {$hoy} ", $fntFit); $worksheet1->write_string(4, 0, "Naviera : {$naviera} ", $fntFit); $worksheet1->write_string(2, 4, "Modulo : Inventario ", $fntFit); $worksheet1->write_string(3, 4, "Elaboro: {$usuario} // ", $fntFit); // Sub-Encabezado $worksheet1->set_column(0, 10, 15); // ---------------------------------------------------------- // OFICINA X // ---------------------------------------------------------- $worksheet1->write_string(6, 0, ".:: {$oficina} ::.", $fntEnc); $worksheet1->write_string(7, 0, "Total", $fntEnc); $worksheet1->write_string(7, 1, "Dañados", $fntEnc); $worksheet1->write_string(7, 2, "A", $fntEnc); $worksheet1->write_string(7, 3, "B", $fntEnc); $worksheet1->write_string(7, 4, "C", $fntEnc); $worksheet1->write_string(7, 5, "D", $fntEnc); $worksheet1->write_string(7, 6, "FG", $fntEnc); $worksheet1->write_string(7, 7, "GC", $fntEnc); $worksheet1->write_string(8, 0, "20' DC", $fntEnc); $worksheet1->write_string(9, 0, "40' DC", $fntEnc); $worksheet1->write_string(10, 0, "40' HC", $fntEnc); // 20 DC $dc20DM = getCountConte($sesIdOficina, $idNaviera, '20DC', 'DM'); $worksheet1->write_number(8, 1, $dc20DM, $fntFit); $dc20A = getCountConte($sesIdOficina, $idNaviera, '20DC', 'A'); $worksheet1->write_number(8, 2, $dc20A, $fntFit); $dc20B = getCountConte($sesIdOficina, $idNaviera, '20DC', 'B'); $worksheet1->write_number(8, 3, $dc20B, $fntFit); $dc20C = getCountConte($sesIdOficina, $idNaviera, '20DC', 'C'); $worksheet1->write_number(8, 4, $dc20C, $fntFit); $dc20D = getCountConte($sesIdOficina, $idNaviera, '20DC', 'D'); $worksheet1->write_number(8, 5, $dc20D, $fntFit); $dc20FG = getCountConte($sesIdOficina, $idNaviera, '20DC', 'FG'); $worksheet1->write_number(8, 6, $dc20FG, $fntFit); $dc20GC = getCountConte($sesIdOficina, $idNaviera, '20DC', 'GC'); $worksheet1->write_number(8, 7, $dc20GC, $fntFit); // 40 DC $dc40DM = getCountConte($sesIdOficina, $idNaviera, '40DC', 'DM'); $worksheet1->write_number(9, 1, $dc40DM, $fntFit); $dc40A = getCountConte($sesIdOficina, $idNaviera, '40DC', 'A'); $worksheet1->write_number(9, 2, $dc40A, $fntFit); $dc40B = getCountConte($sesIdOficina, $idNaviera, '40DC', 'B'); $worksheet1->write_number(9, 3, $dc40B, $fntFit); $dc40C = getCountConte($sesIdOficina, $idNaviera, '40DC', 'C'); $worksheet1->write_number(9, 4, $dc40C, $fntFit); $dc40D = getCountConte($sesIdOficina, $idNaviera, '40DC', 'D'); $worksheet1->write_number(9, 5, $dc40D, $fntFit); $dc40FG = getCountConte($sesIdOficina, $idNaviera, '40DC', 'FG'); $worksheet1->write_number(9, 6, $dc40FG, $fntFit); $dc40GC = getCountConte($sesIdOficina, $idNaviera, '40DC', 'GC'); $worksheet1->write_number(9, 7, $dc40GC, $fntFit); // 40 HC $dc40HCDM = getCountConte($sesIdOficina, $idNaviera, '40HC', 'DM'); $worksheet1->write_number(10, 1, $dc40HCDM, $fntFit); $dc40HCA = getCountConte($sesIdOficina, $idNaviera, '40HC', 'A'); $worksheet1->write_number(10, 2, $dc40HCA, $fntFit); $dc40HCB = getCountConte($sesIdOficina, $idNaviera, '40HC', 'B'); $worksheet1->write_number(10, 3, $dc40HCB, $fntFit); $dc40HCC = getCountConte($sesIdOficina, $idNaviera, '40HC', 'C'); $worksheet1->write_number(10, 4, $dc40HCC, $fntFit); $dc40HCD = getCountConte($sesIdOficina, $idNaviera, '40HC', 'D'); $worksheet1->write_number(10, 5, $dc40HCD, $fntFit); $dc40HCFG = getCountConte($sesIdOficina, $idNaviera, '40HC', 'FG'); $worksheet1->write_number(10, 6, $dc40HCFG, $fntFit); $dc40HCGC = getCountConte($sesIdOficina, $idNaviera, '40HC', 'GC'); $worksheet1->write_number(10, 7, $dc40HCGC, $fntFit); $workbook->close(); }
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_pengaduan.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();
//define(K_LIBRARIES,'libraries'); //include("connect.php"); if ($_GET["mode"] == '1') { define('_FCEE_EXEC', '1'); require_once '../../../libraries/dinsos.php'; $resi = $_GET["link"]; $mode = $_GET["mode"]; function HeaderingExcel($filename) { header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename={$filename}"); header("Expires:0"); header("Cache-Control:must-revalidate,post-check=0,pre-check=0"); header("Pragma: public"); } HeaderingExcel('Laporan_imta_habis.xls'); require_once '../../../libraries/excel-lib/OLEwriter.php'; require_once '../../../libraries/excel-lib/BIFFwriter.php'; require_once '../../../libraries/excel-lib/Worksheet.php'; require_once '../../../libraries/excel-lib/Workbook.php'; $workbook = new Workbook("-"); $fJudul =& $workbook->add_format(); $fJudul->set_bold(); $fJudul->set_pattern(1); $fJudul->set_fg_color($color = 'red'); $fList =& $workbook->add_format(); $fList->set_border(1); $fList_title =& $workbook->add_format(); $fList_title->set_border(1); $fList_title->set_bold(); $fList_title->set_merge();