PrintFormEdit();
}
if ($_POST["delete_num"] != null) {
//削除対象番号が入力されている場合
DeleteData();
} else {
if ($_POST["edit_num"] == null) {
//編集対象番号に入力がなければ
WriteData();
}
}
} else {
if (isset($_POST["edit_form"])) {
//編集フォームを入力した後の処理
PrintForm();
EditData();
}
}
}
ReadData();
//ファイルに掲示板のデータを書き込む関数
function WriteData()
{
$keijiban_file = 'keijiban.txt';
if (!file_exists($keijiban_file)) {
//ファイル作成
if (touch($keijiban_file)) {
chmod($keijiban_file, 0777);
}
}
$fp = fopen($keijiban_file, 'ab');
/** @var string $templateFolder */
/** @var string $componentPath */
/** @var CBitrixComponent $component */
$this->setFrameMode(true);
?>
<?
//D7 локализация
use \Bitrix\Main\Localization\Loc as LC;
?>
<div class="news-list">
<div class="block-title large container container-small"><?php
echo LC::getMessage('NEWS');
?>
</div>
<?foreach($arResult["ITEMS"] as $arItem):?>
<?
$this->AddEditAction($arItem['ID'], $arItem['EDIT_LINK'], CIBlock::GetArrayByID($arItem["IBLOCK_ID"], "ELEMENT_EDIT"));
$this->AddDeleteAction($arItem['ID'], $arItem['DELETE_LINK'], CIBlock::GetArrayByID($arItem["IBLOCK_ID"], "ELEMENT_DELETE"), array("CONFIRM" => GetMessage('CT_BNL_ELEMENT_DELETE_CONFIRM')));
?>
<div class="news-item">
<a class="container container-small item-link get-page-content" href="<?echo $arItem["DETAIL_PAGE_URL"]?>" data-href="<?echo $arItem["DETAIL_PAGE_URL"]?>?ajax=y">
<div class="item-date x-small">
<?echo EditData($arItem["DISPLAY_ACTIVE_FROM"],$GLOBALS['lang'])?>
</div>
<div class="item-title x-big"><?echo $arItem["NAME"]?></div>
<div class="item-anons"><?echo $arItem["PREVIEW_TEXT"];?></div>
</a>
</div>
<?endforeach;?>
</div>
} else {
if ($bariskon[0] == "Poc") {
$dansos = 0;
}
}
//selain pocokan dipotong dansos tanggal 03-03012
$_sqlpot = "SELECT koperasi.wajib, jamsostek.biaya\r\n\t\t from keanggotaan,jamsostek,koperasi\r\n\t\t where keanggotaan.koperasi=koperasi.stts\r\n\t and keanggotaan.jamsostek=jamsostek.stts\r\n\t\t and keanggotaan.id='{$bariscari['0']}'";
$hasilpot = bukaquery($_sqlpot);
$barispot = mysql_fetch_row($hasilpot);
$simwajib = $barispot[0];
$jamsostek = $barispot[1];
if (mysql_num_rows($hasilpot) != 0) {
$_sqlcari2 = "select potongan.id from potongan where \r\n potongan.tahun='{$tahun}' and\r\n potongan.bulan='{$bulan}' and id='{$bariscari['0']}'";
$hasilvalidasi = bukaquery($_sqlcari2);
if (mysql_num_rows($hasilvalidasi) != 0) {
EditData(" potongan ", "jamsostek='{$jamsostek}',dansos='{$dansos}',simwajib='{$simwajib}' where \r\n potongan.tahun='{$tahun}' and\r\n potongan.bulan='{$bulan}' and id='{$bariscari['0']}' ");
} elseif (mysql_num_rows($hasilvalidasi) == 0) {
InsertData(" potongan ", "'{$tahun}','{$bulan}','{$bariscari['0']}','{$jamsostek}','{$dansos}','{$simwajib}',\r\n \t\t\t\t '0','0','0','0','0','0','-' ");
}
}
}
$keyword = trim($_POST['keyword']);
$_sql = "SELECT pegawai.id, \r\n\t\t pegawai.nik,\r\n\t\t\t\tpegawai.nama,\r\n\t\t\t\tpegawai.departemen,\r\n\t\t\t\tkeanggotaan.koperasi, \r\n\t\t\t\tkeanggotaan.jamsostek, \t\t\t\t \r\n\t\t\t\tpotongan.jamsostek, \r\n\t\t\t\tpotongan.dansos, \r\n\t\t\t\tpotongan.simwajib, \r\n\t\t\t\tpotongan.angkop, \r\n\t\t\t\tpotongan.angla, \r\n\t\t\t\tpotongan.telpri, \r\n\t\t\t\tpotongan.pajak, \r\n\t\t\t\tpotongan.pribadi, \r\n\t\t\t\tpotongan.lain, \r\n\t\t\t\tpotongan.ktg\r\n\t\t\t\tFROM keanggotaan, potongan\r\n\t\t\t\tRIGHT OUTER JOIN pegawai ON potongan.id = pegawai.id\r\n\t\t\t\tAND tahun like '%" . $tahun . "%' and bulan like '%" . $bulan . "%' \r\n\t\t\t\tWHERE pegawai.stts_aktif<>'KELUAR' and keanggotaan.id=pegawai.id and pegawai.nik like '%" . $keyword . "%' or\r\n\t\t\t\tpegawai.stts_aktif<>'KELUAR' and keanggotaan.id=pegawai.id and pegawai.nama like '%" . $keyword . "%' or\r\n\t\t\t\tpegawai.stts_aktif<>'KELUAR' and keanggotaan.id=pegawai.id and pegawai.departemen like '%" . $keyword . "%' or\r\n\t\t\t\tpegawai.stts_aktif<>'KELUAR' and keanggotaan.id=pegawai.id and keanggotaan.koperasi like '%" . $keyword . "%' or\r\n\t\t\t\tpegawai.stts_aktif<>'KELUAR' and keanggotaan.id=pegawai.id and keanggotaan.jamsostek like '%" . $keyword . "%'\r\n\t\t\t\torder by pegawai.id ASC ";
$hasil = bukaquery($_sql);
$jumlah = mysql_num_rows($hasil);
$jml = 0;
if (mysql_num_rows($hasil) != 0) {
echo "<table width='2100px' border='0' align='center' cellpadding='0' cellspacing='0' class='tbl_form'>\r\n <tr class='head'>\r\n <td width='70px'><div align='center'><font size='2' face='Verdana'><strong>Proses</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>NIK</strong></font></div></td>\r\n <td width='250px'><div align='center'><font size='2' face='Verdana'><strong>Nama</strong></font></div></td>\r\n\t\t\t<td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Departemen</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Anggota Koperasi</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Anggota Jamsostek</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Jamsostek</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Dana Sosial</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Simpanan Wajib</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Angsuran Koperasi</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Angsuran Lain</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Telepon Pribadi</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Pajak</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Pribadi</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Lain-Lain</strong></font></div></td>\r\n <td width='100px'><div align='center'><font size='2' face='Verdana'><strong>Total Potongan</strong></font></div></td>\r\n <td width='200px'><div align='center'><font size='2' face='Verdana'><strong>Keterangan</strong></font></div></td>\r\n </tr>";
while ($baris = mysql_fetch_array($hasil)) {
$ttl = $baris[6] + $baris[7] + $baris[8] + $baris[9] + $baris[10] + $baris[11] + $baris[12] + $baris[13] + $baris[14];
$jml = $jml + $ttl;
$conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);
switch ($sAction) {
case "I":
// Display record
if (!LoadData($conn)) {
// Load record
$_SESSION[ewSessionMessage] = "No records found";
phpmkr_db_close($conn);
ob_end_clean();
header("Location: account.php");
exit;
}
break;
case "U":
// Update
if (EditData($conn)) {
// Update record
$_SESSION[ewSessionMessage] = "Update Record Successful";
phpmkr_db_close($conn);
ob_end_clean();
header("Location: job_success.php");
exit;
}
break;
}
include "top.php";
?>
<script type="text/javascript" src="scripts/ewp.js"></script>
<script type="text/javascript">
<!--
/** @var CBitrixComponentTemplate $this */
/** @var string $templateName */
/** @var string $templateFile */
/** @var string $templateFolder */
/** @var string $componentPath */
/** @var CBitrixComponent $component */
$this->setFrameMode(true);
use \Bitrix\Main\Localization\Loc as LC;
?>
<div class="page-aside-detail news-detail">
<div class="page-aside-header">
<div class="item-title large"><?php
echo $arResult["NAME"];
?>
</div>
<div class="item-date small"><?echo EditData($arItem["DISPLAY_ACTIVE_FROM"],$GLOBALS['lang'])?></div>
</div>
<div class="page-aside-body">
<?echo $arResult["DETAIL_TEXT"];?>
</div>
<div class="page-aside-footer">
<a href="/news/"><?php
echo LC::getMessage('ALLNEWS');
?>
</a>
</div>
</div>
<?/*
<div class="news-detail">
<?if($arParams["DISPLAY_PICTURE"]!="N" && is_array($arResult["DETAIL_PICTURE"])):?>
