Esempio n. 1
0
?>

<div style='position:relative; margin-top:10px; z-index:1;'>
	<div class='left-ribbon' style='position:relative !important; left:0; float:left;'></div>
	<div class='bg-left-ribbon f-left' style='width:300px;'>
		<div class='f-sambung f-putih' style='padding:2px 5px; font-size:35px;'>Grafik Waste</div>
	</div>
	<div class='left-ribbon rotate-180'style='margin-top:-20px; margin-left:38px; position:relative !important; float:left;'></div>
		<div class='cb'></div>
</div>
<div style='background:white; position:relative; border:solid 1px #ccc; width:93%; margin-top:-50px; margin-left:40px; height:auto; padding-top:40px; padding-left:10px; padding-right:15px; padding-bottom:15px'>
	<a href='display_awal'><div class='close-gal' style='z-index:1;background:url(_asset/_images/ribbon-kembali.png)no-repeat; width:130px; height:61px; background-size:130px; position:absolute; top:5; right:-10;'></div></a>
	
	<?php 
$d_new_bln = mfa(msq($kon, "select bulan, tahun from t_waste order by tahun, bulan desc limit 1"));
$nama_bulan_grafik = no_echo_bulan($d_new_bln['bulan']);
echo "\r\n\t<script>\r\n\t\t\$(function () {\r\n\t\t    \$('#container').highcharts({\r\n\t\t        data: {\r\n\t\t            table: 'datatable'\r\n\t\t        },\r\n\t\t        chart: {\r\n\t\t            type: 'column'\r\n\t\t        },\r\n\t\t        title: {\r\n\t\t            text: 'Grafik {$mode} {$brand} {$nama_bulan_grafik} {$d_new_bln['tahun']}'\r\n\t\t        },\r\n\t\t        yAxis: {\r\n\t\t            allowDecimals: false,\r\n\t\t            title: {\r\n\t\t                text: 'Jumlah (%)'\r\n\t\t            }\r\n\t\t        },\r\n\t\t        tooltip: {\r\n\t\t            formatter: function () {\r\n\t\t                return '<b>' + this.series.name + '</b><br/>' +\r\n\t\t                    this.point.y + ' ' + this.point.name.toLowerCase();\r\n\t\t            }\r\n\t\t        }\r\n\t\t    });\r\n\t\t});\r\n\r\n\t\tfunction ambil_bln_grafik()\r\n\t\t{\r\n\t\t\tvar thn = \$('#thn_grafik').val();\r\n\t\t\t\$.ajax({\r\n\t\t\t\ttype: 'POST',\r\n\t\t\t\turl: 'aksi_ambil_bulan_grafik',\r\n\t\t\t\tdata: {thn:thn},\r\n\t\t\t\tdataType: 'html',\r\n\t\t\t\tsuccess: function(msg)\r\n\t\t\t\t{\r\n\t\t\t\t\t\$('#w-bln-grafik').fadeIn();\r\n\t\t\t\t\t\$('#w-mode-grafik').fadeIn();\r\n\t\t\t\t\t\$('#w-cari-grafik').fadeIn();\r\n\t\t\t\t\t\$('#bln_grafik').html(msg);\r\n\t\t\t\t}\r\n\t\t\t});\r\n\t\t\t\r\n\t\t\treturn false;\r\n\t\t}\r\n\r\n\t\tfunction cbb_tampilan()\r\n\t\t{\r\n\t\t\tvar tampilan = \$('#mode_grafik').val();\r\n\t\t\tif(tampilan=='produk')\r\n\t\t\t{\r\n\t\t\t\t\$('#w-brand-grafik').fadeIn();\r\n\t\t\t}\r\n\t\t\telse if(tampilan=='item')\r\n\t\t\t{\r\n\t\t\t\t\$('#w-brand-grafik').fadeIn();\r\n\t\t\t}\r\n\t\t\telse\r\n\t\t\t{\r\n\t\t\t\t\$('#w-brand-grafik').fadeOut();\r\n\t\t\t\t\$('#w-produk-grafik').fadeOut();\r\n\t\t\t\t\$('#w-item-grafik').fadeOut();\r\n\t\t\t}\r\n\t\t}\r\n\r\n\t\tfunction cbb_brand()\r\n\t\t{\r\n\t\t\tvar brand = \$('#brand_grafik').val();\r\n\t\t\tvar mode = \$('#mode_grafik').val();\r\n\t\t\t\$.ajax({\r\n\t\t\t\ttype: 'POST',\r\n\t\t\t\turl: 'aksi_ambil_produk_grafik',\r\n\t\t\t\tdata: {brand:brand},\r\n\t\t\t\tdataType: 'html',\r\n\t\t\t\tsuccess: function(msg)\r\n\t\t\t\t{\r\n\t\t\t\t\tif(mode=='item')\r\n\t\t\t\t\t{\r\n\t\t\t\t\t\t\$('#w-produk-grafik').fadeIn();\r\n\t\t\t\t\t\t\$('#produk_grafik').html(msg);\r\n\t\t\t\t\t}\r\n\t\t\t\t}\r\n\t\t\t});\r\n\t\t\t\r\n\t\t\treturn false;\r\n\t\t}\r\n\t</script>\r\n\t";
?>
	<form method='POST' action='display_grafikWaste'>
		<table cellspacing='10'>
			<tr>
				<td>
					Tahun<br>
					<select class='cb-gr' name='thn' id='thn_grafik' onchange='ambil_bln_grafik();'>
						<option value=''>Pilih tahun</option>
						<?php 
$q_thn = msq($kon, "select tahun from t_waste group by tahun");
while ($d_thn = mfa($q_thn)) {
    echo "<option>{$d_thn['tahun']}</option>";
}
?>
Esempio n. 2
0
         echo "<option value='{$d_item['item_desc']}'>{$d_item['item_desc']}</option>";
     }
     break;
 case "ambil_produk_grafik":
     $brand = $_POST['brand'];
     $q_produk = msq($kon, "select SUBSTRING_INDEX(item_desc, ' ', 2) as kata from t_waste group by kata having kata like '%{$brand}%'");
     echo "<option value=''>Pilih Produk</option>";
     while ($d_produk = mfa($q_produk)) {
         echo "<option value='{$d_produk['kata']}'>{$d_produk['kata']}</option>";
     }
     break;
 case "ambil_bulan_grafik":
     $thn = $_POST['thn'];
     $q = msq($kon, "select * from t_waste where tahun='{$thn}' group by bulan order by bulan");
     while ($d = mfa($q)) {
         $name = no_echo_bulan($d['bulan']);
         echo "\r\n\t\t\t\t\t\t<option value='{$d['bulan']}'>{$name}</option>\r\n\t\t\t\t\t";
     }
     break;
 case "ambil_mesin":
     $id_bagian = $_POST['id_bagian'];
     $q = msq($kon, "select * from t_mesin where id_bagian='{$id_bagian}' order by nama");
     while ($d = mfa($q)) {
         echo "\r\n\t\t\t\t\t\t<option value='{$d['id_mesin']}'>{$d['nama']}</option>\r\n\t\t\t\t\t";
     }
     break;
 case "ambil_tugas":
     $id_bagian = $_POST['id_bagian'];
     $id_mesin = $_POST['id_mesin'];
     if ($id_bagian == '2') {
         $q = msq($kon, "select * from t_tugas where id_bagian='{$id_bagian}' order by id_tugas limit 1");
Esempio n. 3
0
<?php

cek_err();
cek_suc();
echo "\r\n\t<script>\r\n\t\tdocument.title = 'Tambah Waste | DISPLAY PRD'\r\n\t</script>\r\n\t<script>\r\n\t\t\$(document).ready(function(){\r\n\t\t\t\$('.menu3').addClass('sidebar-dash-aktif');\r\n\t\t});\r\n\r\n\t\t\r\n\t</script>\r\n\t\t<div class='title-admin'>\r\n\t\t\t<div style='padding:20px; height:142px; background:rgba(0,0,0,0.4)'>\r\n\t\t\t\t<div style='font-size:70px; margin-right:15px; margin-top:10px;' class='f-putih f-symbol'>?</div>\r\n\t\t\t\t\t<div class='f-putih f24 f-segoe' style='padding:15px; margin-top:50px;'>Import Data Waste<br><div style='margin-top:7px;' class='f-segoe f-putih f16'><i>Form untuk menambahkan data waste...</i></div></div>\r\n\t\t\t</div>\r\n\t\t</div>\r\n\t\t<div class='title-dash'>\r\n\t\t\t<div class='f14'><a href='#' class='link-biru'>DISPLAY PRD</a> <span class='f-none f-symbol1'>&#215;</span> File</div>\r\n\t\t</div>\r\n\t\t\r\n\t\t<div class='wrapper-tengah'>\r\n\t\t\t<div class='wrapper-form' style='width:500px;'>\r\n\t\t\t<div class='title-form'><span class='f-symbol mr10'>?</span>IMPORT DATA WASTE</div>\r\n\t\t\t\t<div class='pd15'>\r\n\t\t\t\t\t<div class='psn'></div>\r\n\t\t\t\t\t<form method='POST' action='aksi_import_waste' id='form_input' enctype='multipart/form-data'>\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t\t<div class='form-grup'>\r\n\t\t\t\t\t\t\t<div class='label-form'>Tahun</div>\r\n\t\t\t\t\t\t\t<select name='thn' class='form'>\r\n\t\t\t\t\t\t\t\t";
for ($thn = date('Y'); $thn >= date('Y', strtotime('-1 year')); $thn--) {
    echo "<option value='{$thn}'>{$thn}</option>";
}
echo "\r\n\t\t\t\t\t\t\t</select>";
echo "\r\n\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t<div class='form-grup'>\r\n\t\t\t\t\t\t\t<div class='label-form'>Bulan</div>\r\n\t\t\t\t\t\t\t<select name='bln' class='form'>\r\n\t\t\t\t\t\t\t\t";
for ($bln = 1; $bln <= 12; $bln++) {
    $nameBln = no_echo_bulan($bln);
    echo "<option value='{$bln}'>{$nameBln}</option>";
}
echo "\r\n\t\t\t\t\t\t\t</select>";
echo "\r\n\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t<div class='form-grup'>\r\n\t\t\t\t\t\t\t<div class='label-form'>File <i>(berupa file excel dengan format .xls)</i></div>\r\n\t\t\t\t\t\t\t<input type='file' id='src-gbr' name='file' required>\r\n\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t<button class='bkirim transi-3' value='kirim' name='kirim'><span class='f-symbol1 f-none' style='margin-right:20px;'>?</span>IMPORT DATA</button>\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t</form>\r\n\t\t\t\t</div>\t\t\r\n\t\t\t</div>\t\t\r\n\t\t</div>\t\t\r\n\t\t\r\n\t";
unset($_SESSION['suc']);
unset($_SESSION['err']);
Esempio n. 4
0
echo "\r\n\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t<div class='animated fadeInRight'>\r\n\t\t\t\t\t\t";
if ($j_ultah == 0) {
    echo "<p align='center' style='padding:20px;' class='f24'>Tidak ada</p>";
} else {
    echo "\r\n\t\t\t\t\t\t\t\t<article class='grid_3  carousel-article' style='margin-top:20px;'>\r\n\r\n\t\t\t\t                    <div style='display: block; text-align: start; position: relative; top: auto; right: auto; bottom: auto; left: auto; width: 220px; height: 90px; margin: 0px; overflow: hidden;' class='caroufredsel_wrapper'>\r\n\t\t\t\t                    <ul style='text-align: left; float: none; position: absolute; top: 0px; right: auto; bottom: auto; left: 0px; margin: 0px; width: 1540px; height: 90px;' id='foo3' class='carousel-li'>\r\n\t\t\t\t                    \t";
    $q_text = msq($kon, "select *, day(tgl_lhr) as tgl, month(tgl_lhr) as bln, year(tgl_lhr) as thn from t_karyawan having tgl=day(now()) and bln=month(now())");
    while ($d_text = mfa($q_text)) {
        $umur = date('Y') - substr($d_text['tgl_lhr'], 0, 4);
        echo "\r\n\t\t\t\t\t                    \t<li>\r\n\t\t\t\t\t                            <p align='center'><span class='f24' style='color:#2bac68;'>{$d_text['nama']}</span><br><span class='f16'>{$umur} thn</span></p>\r\n\t\t\t\t\t                        </li>";
    }
    echo "\r\n\t\t\t\t                    </ul></div>\r\n\r\n\t\t\t\t                    \r\n\t\t\t\t                </article>\r\n\t\t\t\t                <script>\r\n\t\t\t\t                \$('#foo3').carouFredSel({\r\n\t\t\t\t\t                items: 1,\r\n\t\t\t\t\t                auto: true,\r\n\t\t\t\t\t                scroll: 1\r\n\t\t\t\t\t            });\r\n\t\t\t\t                </script>\r\n\t\t\t\t                ";
}
echo "\r\n\t\t\t\t        </div>\r\n\t\t\t\t\t<div class='wr-left-ribbon'>\r\n\t\t\t\t\t\t<div class='left-ribbon'></div>\r\n\t\t\t\t\t\t<div class='bg-left-ribbon'>\r\n\t\t\t\t\t\t\t<div class='wr-icon-ribbon'><div class='f-symbol f-none'>,\t</div></div>\r\n\t\t\t\t\t\t\t<div class='pd10 f-segoe f-putih' style='margin-left:60px;'>ACARA BULAN INI</div>\r\n\r\n\t\t\t\t\t\t\t<div style='margin-top:15px;' class='animated fadeInRight'>\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t";
$q_event = msq($kon, "select * from t_event where month(waktu_mulai)=month(now()) and year(waktu_mulai)=year(now()) and day(waktu_mulai)>=day(now()) order by waktu_mulai limit 2");
$j_event = mnr($q_event);
if ($j_event == 0) {
    echo "\r\n\t\t\t\t\t\t\t\t\t\t\t<p align='center'><div class='f-symbol f-none t-center' style='font-size:50px; color:#2bac68;'>;</div></p>\r\n\t\t\t\t\t\t\t\t\t\t\t<p align='center' class='f-segoe f20'>Tidak ada event bulan ini</p>\r\n\t\t\t\t\t\t\t\t\t\t\t";
} else {
    while ($d_event = mfa($q_event)) {
        $tgl1 = substr($d_event['waktu_mulai'], 8, 2);
        $bln1 = substr(no_echo_bulan(substr($d_event['waktu_mulai'], 5, 2)), 0, 3);
        $thn1 = substr($d_event['waktu_mulai'], 0, 4);
        $jam1 = substr($d_event['waktu_mulai'], 11, 5);
        $tgl2 = substr($d_event['waktu_akhir'], 8, 2);
        $bln2 = substr(no_echo_bulan(substr($d_event['waktu_akhir'], 5, 2)), 0, 3);
        $thn2 = substr($d_event['waktu_akhir'], 0, 4);
        $jam2 = substr($d_event['waktu_akhir'], 11, 5);
        echo "\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t<div style='border-bottom:solid 1px #ccc; padding:15px;' class='f-segoe'>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class='f20'>{$d_event['judul']}</span>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<div style='margin-top:5px; font-family:calibri;'>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class='f16'><span class='f-symbol f-none' style='color:#85c557;padding-right:10px;'>;</span>{$tgl1} {$bln1} {$thn1} - {$tgl2} {$bln2} {$thn2}</div>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class='f15'><span class='f-symbol f-none' style='color:#85c557;padding-right:10px;'>:</span>{$jam1} - {$jam2}</div>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class='f16'><span class='f-symbol f-none' style='color:#85c557;padding-right:20px;'>u</span>{$d_event['tempat']}</div>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t\t\t\t\t\t\t";
    }
}
echo "\r\n\t\t\t\t\t\t\t\t\t<div class='cb'></div>\r\n\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t</div>\r\n\t\t\t\t\t\t</div>\r\n\t\t\t\t\t</div>\r\n\t\t\t\t</div>\r\n\r\n\t\t\t</div>\r\n\t\t</div>\r\n\t";