Exemplo n.º 1
0
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();
}
Exemplo n.º 2
0
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());
Exemplo n.º 3
0
}
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();
Exemplo n.º 5
0
//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);
Exemplo n.º 6
0
$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();
Exemplo n.º 8
0
//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();
Exemplo n.º 9
0
//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();
Exemplo n.º 12
0
//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();
Exemplo n.º 14
0
//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();
Exemplo n.º 16
0
//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();
Exemplo n.º 17
0
//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();
Exemplo n.º 18
0
 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();
 }
Exemplo n.º 19
0
//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();
Exemplo n.º 21
0
//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();
Exemplo n.º 22
0
//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();
Exemplo n.º 24
0
//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();
Exemplo n.º 27
0
<?
   //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();
Exemplo n.º 28
0
 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();
 }
Exemplo n.º 29
0
//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();
Exemplo n.º 30
0
//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();