$whereKarRow .= ")";
} else {
$whereKarRow = "";
}
$optKarRow = makeOption($dbname, 'datakaryawan', 'karyawanid,namakaryawan', $whereKarRow, '0', true);
# Data Show
$dataShow = $data;
foreach ($dataShow as $key => $row) {
$dataShow[$key]['nikmandor'] = $optKarRow[$row['nikmandor']];
$dataShow[$key]['nikmandor1'] = $optKarRow[$row['nikmandor1']];
$dataShow[$key]['nikasisten'] = $optKarRow[$row['nikasisten']];
$dataShow[$key]['keranimuat'] = $optKarRow[$row['keranimuat']];
$dataShow[$key]['updateby'] = $optKarRow[$row['updateby']];
}
# Posting --> Jabatan
$postJabatan = getPostingJabatan('panen');
# Make Table
$tHeader = new rTable('headTable', 'headTableBody', $header, $data, $dataShow);
#$tHeader->addAction('showDetail','Detail','images/'.$_SESSION['theme']."/detail.png");
$tHeader->addAction('showEdit', 'Edit', 'images/' . $_SESSION['theme'] . "/edit.png");
$tHeader->_actions[0]->addAttr($tipeVal);
$tHeader->addAction('deleteData', 'Delete', 'images/' . $_SESSION['theme'] . "/delete.png");
#$tHeader->addAction('approveData','Approve','images/'.$_SESSION['theme']."/approve.png");
$tHeader->addAction('postingData', 'Posting', 'images/' . $_SESSION['theme'] . "/posting.png");
$tHeader->_actions[2]->setAltImg('images/' . $_SESSION['theme'] . "/posted.png");
if (!in_array($_SESSION['empl']['kodejabatan'], $postJabatan)) {
$tHeader->_actions[2]->_name = '';
}
$tHeader->addAction('detailPDF', 'Print Data Detail', 'images/' . $_SESSION['theme'] . "/pdf.jpg");
$tHeader->_actions[3]->addAttr('event');
$tHeader->_actions[3]->addAttr($tipeVal);
$data[$key]['switched'] = true;
}
$data[$key]['tanggal'] = tanggalnormal($row['tanggal']);
unset($data[$key]['posting']);
# Build Condition
if ($i == 0) {
$whereAkun .= "noakun='" . $row['noakun'] . "'";
$whereOrg .= "kodeorganisasi='" . $row['kodeorg'] . "'";
} else {
$whereAkun .= " or noakun='" . $row['noakun'] . "'";
$whereOrg .= " or kodeorganisasi='" . $row['kodeorg'] . "'";
}
$i++;
}
# Posting --> Jabatan
$postJabatan = getPostingJabatan('keuangan');
# Options
if ($_SESSION['language'] == 'EN') {
$optAkun = makeOption($dbname, 'keu_5akun', 'noakun,namaakun1', $whereAkun);
} else {
$optAkun = makeOption($dbname, 'keu_5akun', 'noakun,namaakun', $whereAkun);
}
$optOrg = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi', $whereOrg);
# Mask Data Show
$dataShow = $data;
foreach ($dataShow as $key => $row) {
$dataShow[$key]['jumlah'] = number_format($row['jumlah'], 2);
$dataShow[$key]['noakun'] = $optAkun[$row['noakun']];
$dataShow[$key]['kodeorg'] = $optOrg[$row['kodeorg']];
#=====================tambahan ginting sebagai pembalance
$str = "select sum(jumlah) as jumlah from " . $dbname . ".keu_kasbankdt \n where notransaksi='" . $data[$key]['notransaksi'] . "' \n and kodeorg='" . $data[$key]['kodeorg'] . "' \n and tipetransaksi='" . $data[$key]['tipetransaksi'] . "'\n and noakun2a='" . $data[$key]['noakun'] . "'";
$user_online = $_SESSION['standard']['userid'];
$kdVhc = checkPostGet('kdVhc', '');
$sOrg = "select kodeorganisasi from " . $dbname . ".organisasi where tipe in ('KEBUN','KANWIL','TRAKSI')";
$qOrg = mysql_query($sOrg) or die(mysql_error());
$kodeOrg = "";
while ($rOrg = mysql_fetch_assoc($qOrg)) {
$kodeOrg .= "'" . $rOrg['kodeorganisasi'] . "',";
}
$svhc2 = "select kodeorg from " . $dbname . ".vhc_5master group by kodeorg";
//echo $svhc;
$qvhc2 = mysql_query($svhc2) or die(mysql_error());
while ($rvhc2 = mysql_fetch_assoc($qvhc2)) {
$kodeOrg .= "'" . $rvhc2['kodeorg'] . "',";
}
$pnjgn = strlen($kodeOrg) - 1;
$personPosting = getPostingJabatan('traksi');
switch ($proses) {
case 'load_data':
echo "<table cellspacing='1' border='0' class='sortable'>\r\n <thead>\r\n <tr class='rowheader'>\r\n <td>" . $_SESSION['lang']['notransaksi'] . "</td>\r\n <td>" . $_SESSION['lang']['tanggal'] . "</td>\r\n <td>" . $_SESSION['lang']['kodevhc'] . "</td>\r\n <td>" . $_SESSION['lang']['jenisvch'] . "</td>\r\n <td>Action</td>\r\n </tr>\r\n </thead>\r\n <tbody>";
$limit = 20;
$page = 0;
if (isset($_POST['page'])) {
$page = $_POST['page'];
if ($page < 0) {
$page = 0;
}
}
$offset = $page * $limit;
//$sql2="select count(*) as jmlhrow from ".$dbname.".vhc_penggantianht where kodeorg in (".substr($kodeOrg,0,$pnjgn).") order by `notransaksi` desc";
$sql2 = "select count(*) as jmlhrow from " . $dbname . ".vhc_penggantianht where \r\n\t\t\t kodevhc in (select distinct kodevhc from " . $dbname . ".vhc_5master where kodetraksi like '%" . $_SESSION['empl']['lokasitugas'] . "%')\r\n\t\t\t and posting=0 order by tanggal desc";
//where kodeorg like '%".$_SESSION['empl']['lokasitugas']."%' order by `notransaksi` desc";
} else {
$whereSupp .= ",'" . $row['koderekanan'] . "'";
}
}
$whereSupp .= ")";
} else {
$whereSupp = null;
}
$optSupp = makeOption($dbname, 'log_5supplier', 'supplierid,namasupplier', $whereSupp);
# Data Show
$dataShow = $data;
foreach ($dataShow as $key => $row) {
$dataShow[$key]['koderekanan'] = isset($optSupp[$row['koderekanan']]) ? $optSupp[$row['koderekanan']] : '';
$dataShow[$key]['nilaikontrak'] = number_format($row['nilaikontrak'], 0);
}
$postJabatan = getPostingJabatan('baspk');
# Make Table
$tHeader = new rTable('headTable', 'headTableBody', $header, $data, $dataShow);
$tHeader->addAction('showEdit', 'Edit', 'images/' . $_SESSION['theme'] . "/edit.png");
$tHeader->addAction('deleteData', 'Delete', 'images/' . $_SESSION['theme'] . "/delete.png");
$tHeader->addAction('postingData', 'Posting', 'images/' . $_SESSION['theme'] . "/posting.png");
$tHeader->_actions[2]->setAltImg('images/' . $_SESSION['theme'] . "/posted.png");
if ($_SESSION['empl']['tipelokasitugas'] != 'HOLDING') {
if (!in_array($_SESSION['empl']['kodejabatan'], $postJabatan)) {
$tHeader->_actions[2]->_name = '';
}
}
$tHeader->addAction('detailPDF', 'Print Data Detail', 'images/' . $_SESSION['theme'] . "/pdf.jpg");
$tHeader->_actions[3]->addAttr('event');
$tHeader->_switchException = array('detailPDF');
$tHeader->pageSetting($param['page'], $totalRow, $param['shows']);
}
} else {
$whereKarRow = "";
}
$optKarRow = makeOption($dbname, 'datakaryawan', 'karyawanid,namakaryawan,nik', $whereKarRow, 4);
# Data Show
$dataShow = $data;
foreach ($dataShow as $key => $row) {
isset($optKarRow[$row['nikmandor']]) ? $dataShow[$key]['nikmandor'] = $optKarRow[$row['nikmandor']] : null;
isset($optKarRow[$row['nikmandor1']]) ? $dataShow[$key]['nikmandor1'] = $optKarRow[$row['nikmandor1']] : null;
isset($optKarRow[$row['nikasisten']]) ? $dataShow[$key]['nikasisten'] = $optKarRow[$row['nikasisten']] : null;
isset($optKarRow[$row['keranimuat']]) ? $dataShow[$key]['keranimuat'] = $optKarRow[$row['keranimuat']] : null;
isset($optKarRow[$row['updateby']]) ? $dataShow[$key]['updateby'] = $optKarRow[$row['updateby']] : null;
}
# Posting --> Jabatan
$postJabatan = getPostingJabatan('rawatkebun');
# Make Table
$tHeader = new rTable('headTable', 'headTableBody', $header, $data, $dataShow);
$tHeader->_printAttr = array($tipeVal);
#$tHeader->addAction('showDetail','Detail','images/'.$_SESSION['theme']."/detail.png");
$tHeader->addAction('showEdit', 'Edit', 'images/' . $_SESSION['theme'] . "/edit.png");
$tHeader->_actions[0]->addAttr($tipeVal);
$tHeader->addAction('deleteData', 'Delete', 'images/' . $_SESSION['theme'] . "/delete.png");
#$tHeader->addAction('approveData','Approve','images/'.$_SESSION['theme']."/approve.png");
$tHeader->addAction('postingData', 'Posting', 'images/' . $_SESSION['theme'] . "/posting.png");
$tHeader->_actions[2]->setAltImg('images/' . $_SESSION['theme'] . "/posted.png");
if (!in_array($_SESSION['empl']['kodejabatan'], $postJabatan)) {
$tHeader->_actions[2]->_name = '';
}
$tHeader->addAction('detailPDF', 'Print Data Detail', 'images/' . $_SESSION['theme'] . "/pdf.jpg");
$tHeader->_actions[3]->addAttr('event');
# Data Show
$dataShow = $data;
foreach ($dataShow as $key => $row) {
isset($optKarRow[$row['nikmandor']]) ? $dataShow[$key]['nikmandor'] = $optKarRow[$row['nikmandor']] : null;
isset($optKarRow[$row['nikmandor1']]) ? $dataShow[$key]['nikmandor1'] = $optKarRow[$row['nikmandor1']] : null;
isset($optKarRow[$row['nikasisten']]) ? $dataShow[$key]['nikasisten'] = $optKarRow[$row['nikasisten']] : null;
isset($optKarRow[$row['keranimuat']]) ? $dataShow[$key]['keranimuat'] = $optKarRow[$row['keranimuat']] : null;
isset($optKarRow[$row['updateby']]) ? $dataShow[$key]['updateby'] = $optKarRow[$row['updateby']] : null;
}
# Posting --> Jabatan
if ($param['tipe'] == 'PNN') {
$app = 'panen';
} else {
$app = 'rawatkebun';
}
$postJabatan = getPostingJabatan($app);
# Make Table
$tHeader = new rTable('headTable', 'headTableBody', $header, $data, $dataShow);
#$tHeader->addAction('showDetail','Detail','images/'.$_SESSION['theme']."/detail.png");
$tHeader->addAction('showEdit', 'Edit', 'images/' . $_SESSION['theme'] . "/edit.png");
$tHeader->_actions[0]->addAttr($param['tipe']);
$tHeader->addAction('deleteData', 'Delete', 'images/' . $_SESSION['theme'] . "/delete.png");
#$tHeader->addAction('approveData','Approve','images/'.$_SESSION['theme']."/approve.png");
$tHeader->addAction('postingData', 'Posting', 'images/' . $_SESSION['theme'] . "/posting.png");
$tHeader->_actions[2]->setAltImg('images/' . $_SESSION['theme'] . "/posted.png");
if (!in_array($_SESSION['empl']['kodejabatan'], $postJabatan)) {
$tHeader->_actions[2]->_name = '';
}
//if($param['tipe']!='PNN') {
$tHeader->addAction('detailPDF', 'Print Data Detail', 'images/' . $_SESSION['theme'] . "/pdf.jpg");
$tHeader->_actions[3]->addAttr('event');