# Options
$optKebun = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi', "tipe='KEBUN'");
$optPeriod = array();
$optTp = array("" => $_SESSION['lang']['all'], "I" => "Inti", "P" => "Plasma");
$sData = "select distinct left(tanggal,7) as periode from " . $dbname . ".kebun_aktifitas order by tanggal desc";
$qData = mysql_query($sData) or die(mysql_error($conn));
while ($rData = mysql_fetch_assoc($qData)) {
$optPeriod[$rData['periode']] = $rData['periode'];
}
// for($i=date('Y')-1; $i <= date('Y')+1; $i++) {
// for($j=1;$j<=12;$j++) {
// $val = $i.'-'.str_pad($j,2,'0',STR_PAD_LEFT);
// $optPeriod[$val] = $val;
// }
// }
$fReport = new formReport('cropstatistic', 'kebun_slave_2crop', $_SESSION['lang']['cropstatistic']);
$fReport->addPrime('kebun', $_SESSION['lang']['kebun'], '', 'select', 'L', 20, $optKebun);
$fReport->addPrime('periode', $_SESSION['lang']['periode'], date('Y-m'), 'select', 'L', 15, $optPeriod);
$fReport->addPrime('intiplasma', $_SESSION['lang']['intiplasma'], '', 'select', 'L', 20, $optTp);
$fReport->_detailHeight = 60;
$fReport->_noPdf = true;
/** View **/
echo open_body();
?>
<script src="js/formReport.js"></script>
<script src="js/biReport.js"></script>
<link rel="stylesheet" type="text/css" href="style/zTable.css">
<?php
include 'master_mainMenu.php';
OPEN_BOX();
$fReport->render();
<?php
//@Copy nangkoelframework
require_once 'master_validation.php';
include_once 'lib/nangkoelib.php';
include_once 'lib/zLib.php';
include_once 'lib/formReport.php';
/** Controller **/
# Options
$optPT = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi', "tipe='PT'");
$optKebun = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi', "tipe='KEBUN' and induk='" . key($optPT) . "'", null, 1);
$optKebun[''] = $_SESSION['lang']['all'];
$optTipe = array('RAWAT' => 'Perawatan Kebun', 'BIBIT' => 'Perawatan Bibit');
$optTipeKebun = array('' => $_SESSION['lang']['all'], 'i' => 'Inti', 'p' => 'Plasma');
$fReport = new formReport('cropstatistic', 'kebun_slave_2accreport', $_SESSION['lang']['accreport']);
$fReport->addPrime('pt', $_SESSION['lang']['pt'], '', 'select', 'L', 20, $optPT);
$fReport->_primeEls[0]->_attr['onchange'] = "getKebun()";
$fReport->addPrime('kebun', $_SESSION['lang']['kebun'], '', 'select', 'L', 20, $optKebun);
$fReport->addPrime('tipekebun', $_SESSION['lang']['intiplasma'], '', 'select', 'L', 20, $optTipeKebun);
$fReport->addPrime('tanggal', "Per Tanggal", date('d-m-Y'), 'date', 'L', 15);
$fReport->addPrime('tipe', "Tipe", '', 'select', 'L', 20, $optTipe);
$fReport->_detailHeight = 60;
$fReport->_noPdf = true;
$fReport->_noExcel = true;
/** View **/
echo open_body();
?>
<script src="js/formReport.js"></script>
<script src="js/biReport.js"></script>
<script src="js/kebun_2accreport.js"></script>
<link rel="stylesheet" type="text/css" href="style/zTable.css">
$optKegiatan = makeOption($dbname, 'setup_kegiatan', 'kodekegiatan,namakegiatan1,kelompok', "kelompok in ('BBT', 'TB', 'TBM', 'TM')", '7', true);
} else {
$optKegiatan = makeOption($dbname, 'setup_kegiatan', 'kodekegiatan,namakegiatan,kelompok', "kelompok in ('BBT', 'TB', 'TBM', 'TM')", '7', true);
}
$optKegiatan[''] = $_SESSION['lang']['all'];
$optBarang[''] = $_SESSION['lang']['all'];
$str = "select distinct a.kodebarang, b.namabarang from " . $dbname . ".kebun_pakaimaterial a \r\n left join " . $dbname . ".log_5masterbarang b on a.kodebarang = b.kodebarang \r\n where a.kodebarang like '3%'\r\n order by a.kodebarang asc";
$que = mysql_query($str) or die(mysql_error());
while ($row = mysql_fetch_assoc($que)) {
$optBarang[$row['kodebarang']] = $row['kodebarang'] . ' ' . $row['namabarang'];
}
//INSERT INTO `bahasa` (`legend`, `ID`, `location`, `idx`, `MY`, `EN`, `TH`) VALUES ('lapmaterial', 'Laporan Pakai Material', 'kebun', NULL, 'Laporan Pakai Material', 'Material Usage Report', 'Material Usage Report');
if (!isset($_SESSION['lang']['lapmaterial'])) {
$_SESSION['lang']['lapmaterial'] = ucfirst('pakaimaterial');
}
$fReport = new formReport('pakaimaterial', 'kebun_slave_2pakaimaterial', $_SESSION['lang']['lapmaterial']);
$fReport->addPrime('kodeorg', $_SESSION['lang']['kodeorg'], '', 'select', 'L', 20, $optOrg);
$fReport->addPrime('periode', $_SESSION['lang']['periode'], '', 'bulantahun', 'L', 25);
#$fReport->addPrime('tahuntanam',$_SESSION['lang']['tahuntanam'],'','select','L',20,$optTahunTanam);
$fReport->addPrime('kegiatan', $_SESSION['lang']['kegiatan'], '', 'select', 'L', 20, $optKegiatan);
$fReport->addPrime('barang', $_SESSION['lang']['kodebarang'], '', 'select', 'L', 20, $optBarang);
/** View **/
echo open_body();
?>
<script language="JavaScript1.2" src="js/formReport.js"></script>
<script language="JavaScript1.2" src="js/biReport.js"></script>
<link rel="stylesheet" type="text/css" href="style/zTable.css">
<?php
include 'master_mainMenu.php';
OPEN_BOX();
$fReport->render();
<?php
//@Copy nangkoelframework
require_once 'master_validation.php';
include_once 'lib/nangkoelib.php';
include_once 'lib/zLib.php';
include_once 'lib/formReport.php';
/** Controller **/
# Options
$fReport = new formReport('kasharian', 'keu_slave_2kasHarian', $_SESSION['lang']['kasharian']);
if ($_SESSION['empl']['tipelokasitugas'] == 'HOLDING' or $_SESSION['empl']['tipelokasitugas'] == 'KANWIL') {
$optOrg = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi', "length(kodeorganisasi)=4");
$fReport->addPrime('kodeorg', $_SESSION['lang']['kodeorg'], '', 'select', 'L', 20, $optOrg);
}
// update Oct 17, 2011 begin
// $as=Array('0'=>'Seluruhnya');
$as = array();
// update Oct 17, 2011 end
$optAkun = makeOption($dbname, 'keu_5akun', 'noakun,namaakun', "kasbank=1");
$optAkun = $as + $optAkun;
$fReport->addPrime('noakun', $_SESSION['lang']['noakun'], '', 'select', 'L', 20, $optAkun);
$fReport->addPrime('periode', $_SESSION['lang']['periode'], date('d-m-Y'), 'period', 'L', 15);
$fReport->_detailHeight = 60;
/** View **/
echo open_body();
?>
<script language="JavaScript1.2" src="js/formReport.js"></script>
<script language="JavaScript1.2" src="js/biReport.js"></script>
<link rel="stylesheet" type="text/css" href="style/zTable.css">
<?php
include 'master_mainMenu.php';
<?php
//@Copy nangkoelframework
require_once 'master_validation.php';
include_once 'lib/nangkoelib.php';
include_once 'lib/zLib.php';
include_once 'lib/formReport.php';
/** Controller **/
# Options
$optCmp = makeOption($dbname, 'sdm_ho_component', 'id,name', "type='basic'", '0', true);
$optCmp[''] = $_SESSION['lang']['all'];
$fReport = new formReport('histgaji', 'sdm_slave_2histgaji', $_SESSION['lang']['histgaji']);
$fReport->addPrime('tahun', $_SESSION['lang']['tahun'], date('Y'), 'textnum', 'L', 4);
$fReport->addPrime('karyawan', $_SESSION['lang']['namakaryawan'], '', 'text', 'L', 20);
$fReport->addPrime('komponen', $_SESSION['lang']['idkomponen'], '', 'select', 'L', 20, $optCmp);
$fReport->addPrime('periode', $_SESSION['lang']['periode'], date('d-m-Y'), 'period', 'L', 15);
$fReport->_detailHeight = 60;
/** View **/
echo open_body();
?>
<script language="JavaScript1.2" src="js/formReport.js"></script>
<script language="JavaScript1.2" src="js/biReport.js"></script>
<link rel="stylesheet" type="text/css" href="style/zTable.css">
<?php
include 'master_mainMenu.php';
OPEN_BOX();
$fReport->render();
CLOSE_BOX();
echo close_body();
<?php
//@Copy nangkoelframework
require_once 'master_validation.php';
include_once 'lib/nangkoelib.php';
include_once 'lib/zLib.php';
include_once 'lib/formReport.php';
/** Controller **/
# Options
$optJabatan = makeOption($dbname, 'sdm_5jabatan', 'kodejabatan,namajabatan', null, '0', true);
$optJabatan[''] = $_SESSION['lang']['all'];
$fReport = new formReport('histkaryawan', 'sdm_slave_2histkaryawan', $_SESSION['lang']['histkaryawan']);
$fReport->addPrime('karyawan', $_SESSION['lang']['namakaryawan'], '', 'text', 'L', 20);
$fReport->addPrime('jabatan', $_SESSION['lang']['jabatan'], '', 'select', 'L', 20, $optJabatan);
$fReport->addPrime('periode', $_SESSION['lang']['tanggal'], date('d-m-Y'), 'period', 'L', 15);
$fReport->_detailHeight = 60;
/** View **/
echo open_body();
?>
<script src="js/formReport.js"></script>
<script src="js/biReport.js"></script>
<link rel="stylesheet" type="text/css" href="style/zTable.css">
<?php
include 'master_mainMenu.php';
OPEN_BOX();
$fReport->render();
CLOSE_BOX();
echo close_body();
