$where = "notransaksi='" . $param['notransaksi'] . "' and kodekegiatan='" . $param['kodekegiatan'] . "'";
$query = "delete from `" . $dbname . "`.`log_spkdt` where " . $where;
if (!mysql_query($query)) {
echo "DB Error : " . mysql_error();
exit;
}
} else {
exit('Error:Realisasi sudah terisi');
}
break;
case 'updKegiatan':
if (substr($param['kodeblok'], 2, 1) == '-') {
$optAct = makeOption($dbname, 'project_dt', 'kegiatan,namakegiatan,kegiatan', "kodeproject='" . $param['kodeblok'] . "'", 4);
} else {
$optBlokStat = makeOption($dbname, 'setup_blok', 'kodeorg,statusblok,kodeorg', "kodeorg='" . $param['kodeblok'] . "'");
if (strlen(getFirstKey($optBlokStat)) == 10) {
$whereAct = "kelompok='" . getFirstContent($optBlokStat) . "' and status = '1'";
} else {
$whereAct = "status = '1'";
}
$optAct = makeOption($dbname, 'setup_kegiatan', 'kodekegiatan,namakegiatan,satuan,noakun', $whereAct, '6');
}
echo json_encode($optAct);
break;
case 'updSatuan':
$strSatuan = "select * from " . $dbname . ".setup_kegiatan where kodekegiatan='" . $param['kodekegiatan'] . "'";
$qrySatuan = mysql_query($strSatuan) or die(mysql_error($conn));
$resSatuan = mysql_fetch_object($qrySatuan);
if (isset($resSatuan->satuan)) {
$satuan = $resSatuan->satuan;
} else {
function formHeader($mode, $data)
{
global $dbname;
# Default Value
if (empty($data)) {
$data['kodeorg'] = '';
$data['notransaksi'] = '0';
$data['tanggal'] = '';
$data['divisi'] = '';
$data['koderekanan'] = '';
$data['matauang'] = 'IDR';
$data['nilaikontrak'] = '0';
$data['keterangan'] = '';
$data['dari'] = '';
$data['sampai'] = '';
} else {
$data['nilaikontrak'] = number_format($data['nilaikontrak']);
}
# Disabled Primary
if ($mode == 'edit') {
$disabled = 'disabled';
} else {
$disabled = '';
}
# Options
if ($_SESSION['empl']['tipelokasitugas'] == 'TRAKSI' or $_SESSION['empl']['tipelokasitugas'] == 'HOLDING' or $_SESSION['empl']['tipelokasitugas'] == 'KANWIL') {
$whereOrg = "length(kodeorganisasi)=4";
} else {
$whereOrg = "kodeorganisasi='" . $_SESSION['empl']['lokasitugas'] . "'";
}
$optOrg = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi', $whereOrg);
if ($data['divisi'] == '') {
if ($_SESSION['empl']['tipelokasitugas'] == 'TRAKSI') {
$whereDiv = "induk='" . getFirstKey($optOrg) . "'";
} else {
$whereDiv = "induk='" . $_SESSION['empl']['lokasitugas'] . "'";
}
// $whereDiv .= " or kodeorganisasi='".getFirstKey($optOrg)."'";
} else {
$whereDiv = "kodeorganisasi='" . $data['divisi'] . "'";
}
$optDiv = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi', $whereDiv);
#tambahkan dari project=================================================================
//$str="select kode,nama from ".$dbname.".project where kodeorg='".$_SESSION['empl']['lokasitugas']."' and posting=0";
//$res=mysql_query($str);
//while($bar=mysql_fetch_object($res))
//{
// $optDiv[$bar->kode]="[Project]-".$bar->nama;
//}
$optDiv[''] = "Project";
if ($data['ppnnilaikontrak'] == '1') {
$valueChk = 'checked';
} else {
$valueChk = '';
}
#===================================================================================
$optSup = makeOption($dbname, 'log_5supplier', 'supplierid,namasupplier', "left(kodekelompok,1)='K' OR left(kodekelompok,1)='T'");
$optmatauang = makeOption($dbname, 'setup_matauang', 'kode,kode');
$els = array();
if ($_SESSION['empl']['tipelokasitugas'] == 'TRAKSI' or $_SESSION['empl']['tipelokasitugas'] == 'HOLDING' or $_SESSION['empl']['tipelokasitugas'] == 'KANWIL') {
$els[] = array(makeElement('kodeorg', 'label', $_SESSION['lang']['kodeorg']), makeElement('kodeorg', 'select', $data['kodeorg'], array('style' => 'width:150px', $disabled => $disabled, 'onchange' => 'updSub()'), $optOrg));
} else {
$els[] = array(makeElement('kodeorg', 'label', $_SESSION['lang']['kebun']), makeElement('kodeorg', 'select', $data['kodeorg'], array('style' => 'width:150px', $disabled => $disabled), $optOrg));
}
$els[] = array(makeElement('notransaksi', 'label', $_SESSION['lang']['notransaksi']), makeElement('notransaksi', 'text', $data['notransaksi'], array('style' => 'width:150px', 'maxlength' => '25', $disabled => $disabled)));
$els[] = array(makeElement('tanggal', 'label', $_SESSION['lang']['tanggal']), makeElement('tanggal', 'text', $data['tanggal'], array('style' => 'width:150px', 'readonly' => 'readonly', 'onmousemove' => 'setCalendar(this.id)')));
$els[] = array(makeElement('divisi', 'label', $_SESSION['lang']['subunit']), makeElement('divisi', 'select', $data['divisi'], array('style' => 'width:150px', $disabled => $disabled), $optDiv));
$els[] = array(makeElement('koderekanan', 'label', $_SESSION['lang']['koderekanan']), makeElement('koderekanan', 'select', $data['koderekanan'], array('style' => 'width:150px'), $optSup));
$els[] = array(makeElement('matauang', 'label', $_SESSION['lang']['matauang']), makeElement('matauang', 'select', $data['matauang'], '', $optmatauang));
$els[] = array(makeElement('nilaikontrak', 'label', $_SESSION['lang']['nilaikontrak']), makeElement('nilaikontrak', 'textnum', $data['nilaikontrak'], array('style' => 'width:150px', 'maxlength' => '15', 'this.value=remove_comma(this);onchange' => 'this.value = _formatted(this)')));
// $els[] = array(
// makeElement('lblppn','label','Include Ppn'),
// makeElement('ppnnilaikontrak','checkbox','',array($valueChk=>''))
// );
$els[] = array(makeElement('keterangan', 'label', $_SESSION['lang']['project']), makeElement('keterangan', 'text', $data['keterangan'], array('style' => 'width:150px', 'maxlength' => '50')));
$els[] = array(makeElement('dari', 'label', $_SESSION['lang']['dari']), makeElement('dari', 'text', $data['dari'], array('style' => 'width:150px', 'readonly' => 'readonly', 'onmousemove' => 'setCalendar(this.id)')));
$els[] = array(makeElement('sampai', 'label', $_SESSION['lang']['sampai']), makeElement('sampai', 'text', $data['sampai'], array('style' => 'width:150px', 'readonly' => 'readonly', 'onmousemove' => 'setCalendar(this.id)')));
if ($mode == 'add') {
$els['btn'] = array(makeElement('addHead', 'btn', $_SESSION['lang']['save'], array('onclick' => "addDataTable()")));
} elseif ($mode == 'edit') {
$els['btn'] = array(makeElement('editHead', 'btn', $_SESSION['lang']['save'], array('onclick' => "editDataTable()")));
}
if ($mode == 'add') {
$content = genElementMultiDim($_SESSION['lang']['addheader'], $els, 2);
} elseif ($mode == 'edit') {
$content = genElementMultiDim($_SESSION['lang']['editheader'], $els, 2);
}
// Ambil Akun PPn dan Pph
$optPajak = makeOption($dbname, 'setup_parameterappl', 'kodeparameter,nilai', "kodeaplikasi = 'TX' and kodeparameter in ('PPNINV','PPHSPK')");
$pph = explode(',', $optPajak['PPHSPK']);
$whereAkun = "";
$whereAkun .= "noakun in ('" . $optPajak['PPNINV'] . "','" . implode("','", $pph) . "')";
$optAkun = makeOption($dbname, 'keu_5akun', 'noakun,namaakun', "(" . $whereAkun . ") and detail=1", '2');
//print_r($optAkun);
// Pajak
$content .= "<fieldset><legend>" . $_SESSION['lang']['detail'] . " " . $_SESSION['lang']['pajak'] . "</legend>";
$content .= "<div><table>";
$listPpn = array();
foreach ($optAkun as $noakun => $namaakun) {
$listPpn[] = $noakun;
setIt($data['tax'][$noakun], 0);
$content .= "<tr>";
$content .= "<td>" . $namaakun . "</td>";
$content .= "<td>" . makeElement('tax' . $noakun, 'textnum', $data['tax'][$noakun]) . "</td>";
$content .= "</tr>";
}
$content .= "</table></div>";
$content .= "</fieldset>";
$content .= makeElement('listPpn', 'hidden', json_encode($listPpn));
return $content;
}
}
$contentFrame[0] .= $formTab2->prep();
#================ Absensi Tab =============================
# Get Data
$where = "notransaksi='" . $param['notransaksi'] . "'";
$cols = "nourut,nik,absensi,jhk,umr,insentif";
$query = selectQuery($dbname, 'kebun_kehadiran', $cols, $where);
$data = fetchData($query);
$dataShow = $data;
foreach ($dataShow as $key => $row) {
$dataShow[$key]['nik'] = $optKary[$row['nik']];
$dataShow[$key]['absensi'] = $optAbs[$row['absensi']];
$dataShow[$key]['umr'] = number_format($row['umr'], 0);
}
#=============================== Get UMR ==============================
$firstKary = getFirstKey($optKary);
$qUMR = selectQuery($dbname, 'sdm_5gajipokok', 'sum(jumlah) as nilai', "karyawanid=" . $firstKary . " and tahun=" . date('Y') . " and idkomponen in (1,31)");
$Umr = fetchData($qUMR);
#=============================== Get UMR ==============================
# Form
$theForm1 = new uForm('absensiForm', $_SESSION['lang']['form'] . ' ' . $_SESSION['lang']['absensi'], 2);
$theForm1->addEls('nourut', $_SESSION['lang']['nourut'], '0', 'textnum', 'R', 3);
$theForm1->_elements[0]->_attr['disabled'] = 'disabled';
$theForm1->addEls('nik', $_SESSION['lang']['nik'], '', 'select', 'L', 25, $optKary);
$theForm1->_elements[1]->_attr['onchange'] = 'updateUMR(this)';
$theForm1->addEls('absensi', $_SESSION['lang']['absensi'], 'H', 'select', 'L', 25, $optAbs);
$theForm1->addEls('jhk', $_SESSION['lang']['jhk'], '0', 'textnum', 'R', 10);
$theForm1->_elements[3]->_attr['onkeyup'] = "totalVal();cekVal(this,'Abs','Hk');updateUMR2()";
$theForm1->addEls('umr', $_SESSION['lang']['umrhari'], 0, 'textnum', 'R', 10);
#$theForm1->_elements[4]->_attr['onkeyup'] = "totalVal();cekVal(this,'Abs','Umr')";
$theForm1->_elements[4]->_attr['onkeyup'] = "totalVal();";
function createMenu($id, $name, $items, $activeItem = '', $additionalElements = '', $zIndex = 100, $width = 42)
{
if (strpos(getAgent(), 'Internet Explorer') === 0) {
$width_new = $width + 5;
} else {
$width_new = $width - 1;
}
ksort($items);
$length = count($items) - 1;
$items_tmp = array_reverse($items, false);
$openList = array();
for ($i = 0; $i <= $length; $i++) {
$openList[$i] = 0;
}
$lastLevel = 0;
$items = array();
foreach ($items_tmp as $dn => $cn) {
$dn = strstr($dn, 'cn=');
$level = count(explode(',', $dn)) - 1;
$img = array();
if ($level > $lastLevel) {
$openList[$lastLevel]++;
}
if ($level >= 1) {
for ($i = 1; $i <= $level; $i++) {
if ($openList[$i] > 0 and $i != $level) {
$img[] = '<img src="img/bar.jpg" style="border:none;">';
} elseif ($openList[$i] === 0 and $i != $level) {
$img[] = '<img src="img/blank.jpg" style="border:none;">';
} elseif ($i == $level) {
if ($level == $lastLevel or $openList[$level] > 0) {
$img[] = '<img src="img/arrow2.jpg" style="border:none;">';
} else {
$img[] = '<img src="img/arrow.jpg" style="border:none;">';
}
}
}
}
if ($level < $lastLevel and $openList[$level] > 0) {
$openList[$level]--;
}
$items[$cn] = $img;
$lastLevel = $level;
}
$additionalElementsSize = 0;
if (is_array($additionalElements) and count($additionalElements) >= 1) {
foreach ($additionalElements as $key => $val) {
$items[$val] = array();
}
$additionalElementsSize = count($additionalElements);
}
$items = array_reverse($items, true);
if (!array_key_exists($activeItem, $items)) {
$activeItem = getFirstKey($items);
}
$length = count($items);
echo '<div class="menu" style="z-index:' . $zIndex . ';' . ($width != 42 ? 'width:' . $width_new . 'px;margin-right:4px;' : '') . '">';
echo '<ul' . ($width != 42 ? ' style="width:' . $width_new . 'px;" ' : '') . '>';
//echo '<li'.(($width!=42)?' style="width:'.$width_new.'px;" ':'').'><a class="hide"'.(($width!=42)?' style="width:'.$width_new.'px;" ':'').' id='.$id.'-activeItem style="vertical-align:middle;" href=# onclick="dropdownOpen(\''.$id.'\');">'.$activeItem.'</a>';
echo '<li' . ($width != 42 ? ' style="width:' . $width_new . 'px;" ' : '') . '><a class="hide"' . ($width != 42 ? ' style="width:' . $width_new . 'px;" ' : '') . ' id=' . $id . '-activeItem style="vertical-align:middle;" href=# onclick="document.getElementById(\'' . $id . '\').style.display=\'block\';">' . $activeItem . '</a>';
// onclick="dropdownOpen(\''.$id.'\');"
echo '<ul id=' . $id . '>';
$index = 1;
foreach ($items as $cn => $img) {
if ($additionalElementsSize == $index) {
$addStyle = 'style="background:#ffffff;border-bottom:1px dashed #6699cc;"';
} else {
$addStyle = '';
}
if ($index < $length) {
echo '<li><div class=defaultElement ' . $addStyle . '>';
} else {
echo '<li><div class=bottomElement>';
}
echo '<table cellpadding=0 cellspacing=0 border=0 style="background:#ffffff;"><tr>';
foreach ($img as $key => $val) {
echo '<td style="width:10px;height:15px;">' . $val . '</td>';
}
//echo '<td style="height:15px;vertical-align:middle;"><a href=# title="'.$cn.'" onclick="dropdownClose(\''.$id.'\', \''.$name.'\', \''.$cn.'\');" style="border:none;text-align:left;padding-left:0px;">'.$cn.'</a></td></tr></table></div>';
echo '<td style="height:15px;vertical-align:middle;"><a href=# title="' . $cn . '" onclick="document.getElementById(\'' . $id . '\').style.display=\'none\'; document.getElementById(\'' . $id . '-activeItem\').innerHTML=\'' . $cn . '\'; document.getElementById(\'' . $name . '\').value=\'' . $cn . '\';" style="border:none;text-align:left;padding-left:0px;">' . $cn . '</a></td></tr></table></div>';
$index++;
}
echo '</ul>';
echo '</li>';
echo '</ul>';
echo '</div>';
echo '<input type=hidden id=' . $name . ' name=' . $name . ' value=' . $activeItem . '>';
}
