$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(); CLOSE_BOX();
<?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">
} 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(); CLOSE_BOX();
<?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();