Exemplo n.º 1
0
    $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);
Exemplo n.º 2
0
         $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";
Exemplo n.º 4
0
         } 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']);
Exemplo n.º 5
0
    }
} 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');
Exemplo n.º 6
0
 # 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');