$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 . '>'; }