$tahunLanjut = $tmpPeriod[0] + 1;
 } else {
     $bulanLanjut = $tmpPeriod[1] + 1;
     $tahunLanjut = $tmpPeriod[0];
 }
 # Prep Hari untuk periode selanjutnya
 $jmlHari = cal_days_in_month(CAL_GREGORIAN, $bulanLanjut, $tahunLanjut);
 $tglAwal = $tahunLanjut . '-' . addZero($bulanLanjut, 2) . '-01';
 $tglAkhir = $tahunLanjut . '-' . addZero($bulanLanjut, 2) . '-' . addZero($jmlHari, 2);
 #==================== /Prep Periode ===================================
 #==================== Prep Jurnal =====================================
 #=== Extract Data ====
 # Get PT
 $pt = getPT($dbname, $param['kodeorg']);
 if ($pt == false) {
     $pt = getHolding($dbname, $param['kodeorg']);
 }
 # Tanggal dan Kode Jurnal
 $tgl = $tmpPeriod[0] . $tmpPeriod[1] . cal_days_in_month(CAL_GREGORIAN, $tmpPeriod[1], $tmpPeriod[0]);
 $kodejurnal = 'CLSM';
 #==================== Journal Counter ==================
 $nojurnal = $tgl . "/" . $param['kodeorg'] . "/" . $kodejurnal . "/999";
 #==================== Journal Counter ==================
 # Cek apakah tahun sudah ditutup
 $qCek = selectQuery($dbname, 'keu_jurnalht', '*', "nojurnal='" . $nojurnal . "'");
 //        echo "error:".$qCek;
 //        exit;
 $resCek = fetchData($qCek);
 if (!empty($resCek)) {
     echo ' Error : This period has been closed(Before).';
     exit;
Exemplo n.º 2
0
function renderFormDetail($data, $mode = 'add', $num = 0)
{
    global $dbname;
    # Prepare Options
    $holding = getHolding($dbname, $data['kodeorg']);
    if ($holding != false) {
        $kelompok = array('' => '');
        $tmpKel = makeOption($dbname, 'setup_klpkegiatan', 'kodeklp,namakelompok', "kodeorg='" . $holding['kode'] . "'");
        foreach ($tmpKel as $key => $row) {
            $kelompok[$key] = $row;
        }
    } else {
        $kelompok = array();
    }
    $optCashFlow = makeOption($dbname, 'keu_5mesinlaporandt', 'nourut,keterangandisplay', "tipe='Detail' and namalaporan='CASH FLOW DIRECT'");
    $whereKeg = "(substr(noakun,1,2)='52' or substr(noakun,1,2)='64') and detail=1";
    $kegiatan = makeOption($dbname, 'keu_5akun', 'noakun,namaakun', $whereKeg, 1);
    if (!isset($_SESSION['org']['below'])) {
        $_SESSION['org']['below'] = getOrgBelow($dbname, $data['kodeorg']);
    }
    $orgBelow = $_SESSION['org']['below'];
    # Prepare Field
    if ($mode == 'add') {
        $disabled = '';
    } else {
        $disabled = 'disabled';
    }
    $els = array();
    $els[] = array(makeElement('kodebagian', 'label', $_SESSION['lang']['kodebagian']), makeElement('kodebagian', 'select', $data['kodebagian'], array('style' => 'width:250px', $disabled => $disabled), $orgBelow));
    $els[] = array(makeElement('kelompok', 'label', $_SESSION['lang']['kelompok']), makeElement('kelompok', 'select', $data['kelompok'], array('style' => 'width:250px', 'onchange' => "getKegiatan(this,'kodekegiatan')", 'disabled' => 'disabled'), $kelompok));
    $els[] = array(makeElement('kodekegiatan', 'label', $_SESSION['lang']['posbiaya']), makeElement('kodekegiatan', 'select', $data['kodekegiatan'], array('style' => 'width:250px', $disabled => $disabled), $kegiatan));
    $els[] = array(makeElement('noaruskas', 'label', $_SESSION['lang']['noaruskas']), makeElement('noaruskas', 'select', $data['noaruskas'], array('style' => 'width:250px'), $optCashFlow));
    $els[] = array(makeElement('kodebarang', 'label', $_SESSION['lang']['kodebarang']), makeElement('kodebarang', 'searchBarang', $data['kodebarang'], array('style' => 'width:70px', 'maxlength' => '10', 'onkeypress' => 'return tanpa_kutip(event)', 'readonly' => 'readonly', $disabled => $disabled)));
    /*$els[] = array(
    	makeElement('revisi','label',$_SESSION['lang']['revisi']),
    	makeElement('revisi','textnum',$data['revisi'],array('style'=>'width:70px','maxlength'=>'2',
    	    'onkeypress'=>'return angka_doang(event)',$disabled=>$disabled))
        );*/
    $els[] = array(makeElement('hargasatuan', 'label', $_SESSION['lang']['hargasatuan']), makeElement('hargasatuan', 'textnum', $data['hargasatuan'], array('style' => 'width:70px', 'readonly' => 'readonly')));
    $els[] = array(makeElement('jumlah', 'label', $_SESSION['lang']['jumlah']), makeElement('jumlah', 'textnum', $data['jumlah'], array('style' => 'width:70px', 'readonly' => 'readonly')));
    $els2 = array();
    $els2[] = array(makeElement('jan', 'label', $_SESSION['lang']['jan']), makeElement('jan', 'textnum', $data['jan'], array('style' => 'width:90px', 'maxlength' => '13', 'onkeypress' => 'return angka_doang(event)', 'onkeyup' => 'updateQty()')));
    $els2[] = array(makeElement('peb', 'label', $_SESSION['lang']['peb']), makeElement('peb', 'textnum', $data['peb'], array('style' => 'width:90px', 'maxlength' => '13', 'onkeypress' => 'return angka_doang(event)', 'onkeyup' => 'updateQty()')));
    $els2[] = array(makeElement('mar', 'label', $_SESSION['lang']['mar']), makeElement('mar', 'textnum', $data['mar'], array('style' => 'width:90px', 'maxlength' => '13', 'onkeypress' => 'return angka_doang(event)', 'onkeyup' => 'updateQty()')));
    $els2[] = array(makeElement('apr', 'label', $_SESSION['lang']['apr']), makeElement('apr', 'textnum', $data['apr'], array('style' => 'width:90px', 'maxlength' => '13', 'onkeypress' => 'return angka_doang(event)', 'onkeyup' => 'updateQty()')));
    $els2[] = array(makeElement('mei', 'label', $_SESSION['lang']['mei']), makeElement('mei', 'textnum', $data['mei'], array('style' => 'width:90px', 'maxlength' => '13', 'onkeypress' => 'return angka_doang(event)', 'onkeyup' => 'updateQty()')));
    $els2[] = array(makeElement('jun', 'label', $_SESSION['lang']['jun']), makeElement('jun', 'textnum', $data['jun'], array('style' => 'width:90px', 'maxlength' => '13', 'onkeypress' => 'return angka_doang(event)', 'onkeyup' => 'updateQty()')));
    $els2[] = array(makeElement('jul', 'label', $_SESSION['lang']['jul']), makeElement('jul', 'textnum', $data['jul'], array('style' => 'width:90px', 'maxlength' => '13', 'onkeypress' => 'return angka_doang(event)', 'onkeyup' => 'updateQty()')));
    $els2[] = array(makeElement('agt', 'label', $_SESSION['lang']['agt']), makeElement('agt', 'textnum', $data['agt'], array('style' => 'width:90px', 'maxlength' => '13', 'onkeypress' => 'return angka_doang(event)', 'onkeyup' => 'updateQty()')));
    $els2[] = array(makeElement('sep', 'label', $_SESSION['lang']['sep']), makeElement('sep', 'textnum', $data['sep'], array('style' => 'width:90px', 'maxlength' => '13', 'onkeypress' => 'return angka_doang(event)', 'onkeyup' => 'updateQty()')));
    $els2[] = array(makeElement('okt', 'label', $_SESSION['lang']['okt']), makeElement('okt', 'textnum', $data['okt'], array('style' => 'width:90px', 'maxlength' => '13', 'onkeypress' => 'return angka_doang(event)', 'onkeyup' => 'updateQty()')));
    $els2[] = array(makeElement('nov', 'label', $_SESSION['lang']['nov']), makeElement('nov', 'textnum', $data['nov'], array('style' => 'width:90px', 'maxlength' => '13', 'onkeypress' => 'return angka_doang(event)', 'onkeyup' => 'updateQty()')));
    $els2[] = array(makeElement('dec', 'label', $_SESSION['lang']['dec']), makeElement('dec', 'textnum', $data['dec'], array('style' => 'width:90px', 'maxlength' => '13', 'onkeypress' => 'return angka_doang(event)', 'onkeyup' => 'updateQty()')));
    $fieldStr = "##kodebagian##kodekegiatan##kelompok##revisi##kodebarang##hargasatuan" . "##jumlah##jan##peb##mar##apr##mei##jun##jul##agt##sep##okt##nov##dec";
    if ($mode == 'add') {
        $btn = makeElement('addDataDetailB', 'button', $_SESSION['lang']['save'], array('onclick' => 'addDataDetail()', 'style' => 'float:left;clear:both;'));
    } else {
        $btn = makeElement('editDataDetailB', 'button', $_SESSION['lang']['save'], array('onclick' => 'editDataDetail(' . $num . ')', 'style' => 'float:left;clear:both;'));
    }
    # Make Layout
    $form = genElTitle('Form Detail', $els);
    $form .= genElementMultiDim('Rincian Sebaran', $els2, 3);
    $form .= $btn;
    return $form;
}
    #=================== Posting Pengirim =====================================
    $param['tanggal'] = tanggalsystem($param['tanggal']);
    $where = "tanggal='" . $param['tanggal'] . "' and kodeorgpengirim='" . $param['kodeorgpengirim'] . "' and kodeorgpenerima='" . $param['kodeorgpenerima'] . "' and nogiro='" . $param['nogiro'] . "'";
    $query = updateQuery($dbname, 'keu_transferdana', array('postingkirim' => 1), $where);
    if (!mysql_query($query)) {
        echo "DB Error : " . mysql_error();
    }
} else {
    # Get PT
    $pt1 = getPT($dbname, $param['kodeorgpengirim']);
    if ($pt1 == false) {
        $pt1 = getHolding($dbname, $param['kodeorgpengirim']);
    }
    $pt2 = getPT($dbname, $param['kodeorgpenerima']);
    if ($pt2 == false) {
        $pt2 = getHolding($dbname, $param['kodeorgpenerima']);
    }
    #>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Akun Ayat Silang
    $ayatSilang = '1120400';
    #=================== Posting Penerima =====================================
    $param['tanggal'] = tanggalsystem($param['tanggal']);
    #============================ Extract Data ============================
    $where = "tanggal='" . $param['tanggal'] . "' and kodeorgpengirim='" . $param['kodeorgpengirim'] . "' and kodeorgpenerima='" . $param['kodeorgpenerima'] . "' and nogiro='" . $param['nogiro'] . "'";
    $query = selectQuery($dbname, 'keu_transferdana', '*', $where);
    $data = fetchData($query);
    # Kode Jurnal
    $queryKode = selectQuery($dbname, 'keu_5parameterjurnal', '*', "(noakunkredit<'" . $data[0]['noakunpengirim'] . "' and sampaikredit>'" . $data[0]['noakunpengirim'] . "') or " . "(noakundebet<'" . $data[0]['noakunpenerima'] . "' and sampaidebet>'" . $data[0]['noakunpenerima'] . "')");
    $resKode = fetchData($queryKode);
    foreach ($resKode as $row) {
        if (substr($row['jurnalid'], 1, 1) == 'K') {
            $kodejurnal1 = $row['jurnalid'];
Exemplo n.º 4
0
include 'lib/nangkoelib.php';
include_once 'lib/zLib.php';
echo open_body();
include 'master_mainMenu.php';
OPEN_BOX();
?>
<script language=javascript src='js/zMaster.js'></script>
<link rel=stylesheet type=text/css href=style/zTable.css>
  
<p align="left"><u><b><font face="Arial" size="5" color="#000080"><?php 
echo $_SESSION['lang']['statustanam'];
?>
</font></b></u></p>
<?php 
#======Select Prep======
$optOrg = getHolding($dbname, $_SESSION['org']['kodeorganisasi'], true);
#======End Select Prep======
#=======Form============
echo "<div style='margin-bottom:30px'>";
$els = array();
# Fields
$els[] = array(makeElement('kode', 'label', $_SESSION['lang']['kode']), makeElement('kode', 'text', '', array('style' => 'width:100px', 'maxlength' => '10', 'onkeypress' => 'return tanpa_kutip(event)')));
$els[] = array(makeElement('keterangan', 'label', $_SESSION['lang']['keterangan']), makeElement('keterangan', 'text', '', array('style' => 'width:250px', 'maxlength' => '50', 'onkeypress' => 'return tanpa_kutip(event)')));
$els[] = array(makeElement('kodeorg', 'label', $_SESSION['lang']['kodeorg']), makeElement('kodeorg', 'select', '', array('style' => 'width:250px'), $optOrg));
# Fields
$fieldStr = '##kode##keterangan##kodeorg';
$fieldArr = explode("##", substr($fieldStr, 2, strlen($fieldStr) - 2));
# Button
$els['btn'] = array(genFormBtn($fieldStr, 'kebun_5sttanam', "##kode##kodeorg"));
# Generate Field
echo genElement($els);