getTotalRow PHP代码示例

示例#1

0

显示文件

文件： kode_booking.php 项目： razordice/balecatur

function KodeBooking()
{
    //jumlah panjang karakter angka dan huruf.
    $length_abjad = "2";
    $length_angka = "4";
    //huruf yg dimasukan, kecuali I,L dan O
    $huruf = "ABCDEFGHJKMNPRSTUVWXYZ";
    //mulai proses generate huruf
    $i = 1;
    $txt_abjad = "";
    while ($i <= $length_abjad) {
        $txt_abjad .= $huruf[mt_rand(0, strlen($huruf))];
        $i++;
    }
    //mulai proses generate angka
    $datejam = date("His");
    $time_md5 = rand(time(), $datejam);
    $cut = substr($time_md5, 0, $length_angka);
    //mennggabungkan dan mengacak hasil generate huruf dan angka
    $acak = str_shuffle($txt_abjad . $cut);
    //menghitung dan memeriksa hasil generate di database menggunakan fungsi getTotalRow(),
    //jika hasil generate sudah ada di database maka proses generate akan diulang
    $cek = getTotalRow('SELECT kd_booking FROM booking WHERE kd_booking = "' . $acak . '"');
    if ($cek > 0) {
        $cek = KodeBooking();
    }
    return $acak;
}

示例#2

0

显示文件

文件： kebun_panen.php 项目： halimc17/magsys

$ctl = array();
# Control
$tmpWhere = json_encode($whereContArr);
$jsWhere = str_replace('"', "'", $tmpWhere);
$ctl[] = "<div align='center'><img class=delliconBig src=images/" . $_SESSION['theme'] . "/addbig.png title='" . $_SESSION['lang']['new'] . "' onclick=\"showAdd('" . $tipeVal . "')\"><br><span align='center'>" . $_SESSION['lang']['new'] . "</span></div>";
$ctl[] = "<div align='center'><img class=delliconBig src=images/" . $_SESSION['theme'] . "/list.png title='" . $_SESSION['lang']['list'] . "' onclick=\"defaultList('" . $tipeVal . "')\"><br><span align='center'>" . $_SESSION['lang']['list'] . "</span></div>";
# Search
$ctl[] = "<fieldset><legend><b>" . $_SESSION['lang']['find'] . "</b></legend>" . makeElement('sNoTrans', 'label', $_SESSION['lang']['notransaksi']) . makeElement('sNoTrans', 'text', '') . makeElement('sFind', 'btn', $_SESSION['lang']['find'], array('onclick' => "searchTrans('" . $tipe . "','" . $tipeVal . "')")) . "</fieldset>";
#=== Table Aktivitas
# Header
$header = array($_SESSION['lang']['nomor'], $_SESSION['lang']['organisasi'], $_SESSION['lang']['tanggal'], $_SESSION['lang']['nikmandor'], $_SESSION['lang']['nikmandor1'], $_SESSION['lang']['keraniproduksi'], $_SESSION['lang']['keranimuat'], 'updateby');
# Content
$cols = "notransaksi,kodeorg,tanggal,nikmandor,nikmandor1,nikasisten,keranimuat,jurnal,updateby";
$query = selectQuery($dbname, 'kebun_aktifitas', $cols, $whereCont . " and kodeorg='" . $_SESSION['empl']['lokasitugas'] . "'", "tanggal desc, notransaksi desc", false, 10, 1);
$data = fetchData($query);
$totalRow = getTotalRow($dbname, 'kebun_aktifitas', $whereCont);
if (!empty($data)) {
    $whereKarRow = "karyawanid in (";
    $notFirst = false;
    foreach ($data as $key => $row) {
        if ($row['jurnal'] == 1) {
            $data[$key]['switched'] = true;
        }
        $data[$key]['tanggal'] = tanggalnormal($row['tanggal']);
        unset($data[$key]['jurnal']);
        if ($notFirst == false) {
            if ($row['nikmandor'] != '') {
                $whereKarRow .= $row['nikmandor'];
                $notFirst = true;
            }
            if ($row['nikmandor1'] != '') {

示例#3

0

显示文件

文件： log_konosemen.php 项目： halimc17/magsys

$ctl[] = "<fieldset><legend><b>" . $_SESSION['lang']['find'] . "</b></legend>" . makeElement('sNoKonosemen', 'label', $_SESSION['lang']['nokonosemen']) . makeElement('sNoKonosemen', 'text', '') . makeElement('sFind', 'btn', $_SESSION['lang']['find'], array('onclick' => "searchTrans()")) . "</fieldset>";
#=== Table Aktivitas
# Header
$header = array($_SESSION['lang']['nokonosemen'], $_SESSION['lang']['nokonosemen'] . ' Expeditor', $_SESSION['lang']['pt'], $_SESSION['lang']['tanggal'], $_SESSION['lang']['tanggalberangkat'], $_SESSION['lang']['tanggaltiba'], 'postingterimaby');
//cari nama orang
$str = "select karyawanid, namakaryawan from " . $dbname . ".datakaryawan";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
    $nama[$bar->karyawanid] = $bar->namakaryawan;
}
# Content
$cols = "nokonosemen,nokonosemenexp,kodept,tanggal,tanggalberangkat,tanggaltiba,postingby,posting,postingkirim";
$order = "nokonosemen desc";
$query = selectQuery($dbname, 'log_konosemenht', $cols, null, $order, false, 10, 1);
$data = fetchData($query);
$totalRow = getTotalRow($dbname, 'log_suratjalanht');
foreach ($data as $key => $row) {
    if ($row['postingkirim'] == 1) {
        $data[$key]['switched'] = true;
    }
    if ($row['posting'] == 1) {
        $data[$key]['switched'] = true;
    }
    unset($data[$key]['posting']);
    unset($data[$key]['postingkirim']);
    $data[$key]['tanggal'] = tanggalnormal($row['tanggal']);
    $data[$key]['tanggalberangkat'] = tanggalnormal($row['tanggalberangkat']);
    $data[$key]['tanggaltiba'] = tanggalnormal($row['tanggaltiba']);
    if ($row['postingby'] != 0) {
        $data[$key]['postingby'] = $nama[$row['postingby']];
    } else {

示例#4

0

显示文件

文件： keu_slave_kasbank.php 项目： halimc17/magsys

             $where .= " and tanggal between '" . $tanggal1 . "' and '" . $tanggal2 . "' ";
         } elseif (!empty($tanggal1)) {
             $where .= " and tanggal >= '" . $tanggal1 . "'";
         } elseif (!empty($tanggal2)) {
             $where .= " and tanggal <= '" . $tanggal2 . "'";
         }
     }
 }
 # Header & Align
 $header = array($_SESSION['lang']['notransaksi'], $_SESSION['lang']['unitkerja'], $_SESSION['lang']['tanggal'], $_SESSION['lang']['noakun'], $_SESSION['lang']['tipe'], $_SESSION['lang']['matauang'], $_SESSION['lang']['jumlah'], 'Balance', $_SESSION['lang']['remark']);
 $align = explode(',', 'C,L,C,L,C,C,R,C');
 # Content
 $cols = "notransaksi,kodeorg,tanggal,noakun,tipetransaksi,matauang,jumlah,'balan',keterangan,posting";
 $query = selectQuery($dbname, 'keu_kasbankht', $cols, $where, "tanggal desc, notransaksi desc", false, $param['shows'], $param['page']);
 $data = fetchData($query);
 $totalRow = getTotalRow($dbname, 'keu_kasbankht', $where);
 $whereAkun = "";
 $whereOrg = "";
 $i = 0;
 foreach ($data as $key => $row) {
     if ($row['posting'] == 1) {
         $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'] . "'";

示例#5

0

显示文件

文件： log_slave_realisasispk.php 项目： halimc17/magsys

 if (isset($param['where'])) {
     $arrWhere = json_decode(str_replace('\\', '', $param['where']), true);
     if (!empty($arrWhere)) {
         foreach ($arrWhere as $key => $r1) {
             $where .= " and " . $r1[0] . " like '%" . $r1[1] . "%'";
         }
     }
 }
 # Header
 $header = array($_SESSION['lang']['kebun'], $_SESSION['lang']['notransaksi'], $_SESSION['lang']['tanggal'], $_SESSION['lang']['subunit'], $_SESSION['lang']['koderekanan'], $_SESSION['lang']['nilaikontrak'], $_SESSION['lang']['matauang'], $_SESSION['lang']['jumlahrealisasi'], $_SESSION['lang']['status']);
 # Content
 $cols = "kodeorg,notransaksi,tanggal,divisi,koderekanan,nilaikontrak,matauang";
 $query = selectQuery($dbname, 'log_spkht', $cols, $where . " order by tanggal desc", "", false, $param['shows'], $param['page']);
 $data = fetchData($query);
 // print_r($query);
 $totalRow = getTotalRow($dbname, 'log_spkht', $where);
 foreach ($data as $key => $row) {
     $data[$key]['tanggal'] = tanggalnormal($row['tanggal']);
     $data[$key]['nilaikontrak'] = number_format($row['nilaikontrak']);
     //=================ambil realisasi
     $data[$key]['realisasi'] = 0;
     $strx = "select sum(jumlahrealisasi) as test from " . $dbname . ".log_baspk \r\n                  where notransaksi='" . $data[$key]['notransaksi'] . "' and statusjurnal = '1'";
     $resx = mysql_query($strx);
     // print_R($strx);
     while ($barx = mysql_fetch_array($resx)) {
         $data[$key]['realisasi'] = number_format($barx['test']);
     }
     //lihat postingan-=============================
     $data[$key]['status'] = '';
     $strx = "select statusjurnal from " . $dbname . ".log_baspk \r\n                  where notransaksi='" . $data[$key]['notransaksi'] . "' and statusjurnal=0";
     $resx = mysql_query($strx);

示例#6

0

显示文件

文件： log_slave_konosemen.php 项目： halimc17/magsys

 $str = "select karyawanid, namakaryawan from " . $dbname . ".datakaryawan";
 $res = mysql_query($str);
 while ($bar = mysql_fetch_object($res)) {
     $nama[$bar->karyawanid] = $bar->namakaryawan;
 }
 # Header
 $header = array($_SESSION['lang']['nokonosemen'], $_SESSION['lang']['nokonosemen'] . ' Expeditor', $_SESSION['lang']['pt'], $_SESSION['lang']['tanggal'], $_SESSION['lang']['tanggalberangkat'], $_SESSION['lang']['tanggaltiba'], 'postingterimaby');
 # Content
 $cols = "nokonosemen,nokonosemenexp,kodept,tanggal,tanggalberangkat,tanggaltiba,postingby,posting,postingkirim";
 $order = "nokonosemen desc";
 $query = selectQuery($dbname, 'log_konosemenht', $cols, $where, $order, false, $param['shows'], $param['page']);
 $data = fetchData($query);
 if (empty($where)) {
     $where = null;
 }
 $totalRow = getTotalRow($dbname, 'log_konosemenht', $where);
 foreach ($data as $key => $row) {
     if ($row['postingkirim'] == 1) {
         $data[$key]['switched'] = true;
     }
     if ($row['posting'] == 1) {
         $data[$key]['switched'] = true;
     }
     unset($data[$key]['posting']);
     unset($data[$key]['postingkirim']);
     $data[$key]['tanggal'] = tanggalnormal($row['tanggal']);
     $data[$key]['tanggalberangkat'] = tanggalnormal($row['tanggalberangkat']);
     if (!empty($row['tanggaltiba'])) {
         $data[$key]['tanggaltiba'] = tanggalnormal($row['tanggaltiba']);
     }
     if ($row['postingby'] != 0) {

示例#7

0

显示文件

文件： kebun_slave_rencanapanen.php 项目： halimc17/magsys

     } else {
         $where .= null;
     }
 } else {
     $where .= null;
 }
 // exit("Error".$where);
 # Header
 $header = array($_SESSION['lang']['afdeling'], $_SESSION['lang']['blok'], $_SESSION['lang']['tanggal'], $_SESSION['lang']['bulan'], $_SESSION['lang']['tahun'], $_SESSION['lang']['jumlah'], $_SESSION['lang']['jumlahha'], $_SESSION['lang']['jumlahpremi'], $_SESSION['lang']['jumlahpokok']);
 # Content
 $optNamaOrg = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi');
 $cols = "kodeorg,kodeblok,tanggal,bulan,tahun,jumlah,jumlahha,jumlahpremi,jumlahpokok";
 $query = selectQuery($dbname, 'kebun_rencanapanen', $cols, $where, "", false, $param['shows'], $param['page']);
 //exit("error".$query);
 $data = fetchData($query);
 $totalRow = getTotalRow($dbname, 'kebun_rencanapanen', $where);
 foreach ($data as $key => $row) {
     $data[$key]['tanggal'] = tanggalnormal($row['tanggal']);
     $data[$key]['kodeorg'] = $optNamaOrg[$row['kodeorg']];
     $data[$key]['kodeblok'] = $row['kodeblok'];
 }
 # Make Table
 $tHeader = new rTable('headTable', 'headTableBody', $header, $data);
 #$tHeader->addAction('showDetail','Detail','images/'.$_SESSION['theme']."/detail.png");
 $tHeader->addAction('showEdit', 'Edit', 'images/' . $_SESSION['theme'] . "/edit.png");
 //$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");
 $tHeader->pageSetting($param['page'], $totalRow, $param['shows']);
 if (isset($arrWhere)) {

示例#8

0

显示文件

文件： pabrik_slave_pengolahan_03092015.php 项目： halimc17/magsys

             }
         }
     } else {
         $where .= null;
     }
 } else {
     $where .= null;
 }
 $where .= "  order by tanggal desc";
 # Header
 $header = array($_SESSION['lang']['nopengolahan'], $_SESSION['lang']['pabrik'], $_SESSION['lang']['tanggal'], $_SESSION['lang']['shift']);
 # Content
 $cols = "nopengolahan,kodeorg,tanggal,shift,posting";
 $query = selectQuery($dbname, 'pabrik_pengolahan', $cols, $where, "", false, $param['shows'], $param['page']);
 $data = fetchData($query);
 $totalRow = getTotalRow($dbname, 'pabrik_pengolahan', $where);
 foreach ($data as $key => $row) {
     $data[$key]['tanggal'] = tanggalnormal($row['tanggal']);
     if ($row['posting'] == 1) {
         $data[$key]['switched'] = true;
     }
     unset($data[$key]['posting']);
 }
 # Make Table
 $tHeader = new rTable('headTable', 'headTableBody', $header, $data);
 $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");
 $tHeader->addAction('detailPDF', 'Print Data Detail', 'images/' . $_SESSION['theme'] . "/pdf.jpg");
 $tHeader->_actions[3]->addAttr('event');

示例#9

0

显示文件

文件： log_realisasispk.php 项目： halimc17/magsys

$header = array($_SESSION['lang']['kebun'], $_SESSION['lang']['notransaksi'], $_SESSION['lang']['tanggal'], $_SESSION['lang']['subunit'], $_SESSION['lang']['koderekanan'], $_SESSION['lang']['nilaikontrak'], $_SESSION['lang']['matauang'], $_SESSION['lang']['jumlahrealisasi'], $_SESSION['lang']['status']);
# Content
$kdOrganisasi = $_SESSION['empl']['kodeorganisasi'];
$cols = "kodeorg,notransaksi,tanggal,divisi,koderekanan,nilaikontrak,matauang";
if ($_SESSION['empl']['tipelokasitugas'] == 'HOLDING') {
    $where = "length(kodeorg)=4";
} else {
    if ($_SESSION['empl']['tipelokasitugas'] == 'TRAKSI' or $_SESSION['empl']['tipelokasitugas'] == 'KANWIL') {
        $where = "length(kodeorg)=4 and kodeorg in (select kodeorganisasi from " . $dbname . ".organisasi where induk = '" . $kdOrganisasi . "')";
    } else {
        $where = "kodeorg='" . $_SESSION['empl']['lokasitugas'] . "'";
    }
}
$query = selectQuery($dbname, 'log_spkht', $cols, $where . " order by tanggal desc", "", false, 10, 1);
$data = fetchData($query);
$totalRow = getTotalRow($dbname, 'log_spkht');
foreach ($data as $key => $row) {
    $data[$key]['tanggal'] = tanggalnormal($row['tanggal']);
    $data[$key]['nilaikontrak'] = number_format($row['nilaikontrak']);
    //=================ambil realisasi
    $data[$key]['realisasi'] = 0;
    $strx = "select sum(jumlahrealisasi) from " . $dbname . ".log_baspk \r\n                  where notransaksi='" . $data[$key]['notransaksi'] . "' and statusjurnal = '1'";
    $resx = mysql_query($strx);
    while ($barx = mysql_fetch_array($resx)) {
        $data[$key]['realisasi'] = number_format($barx[0]);
    }
    //lihat postingan-=============================
    $data[$key]['status'] = '';
    $strx = "select statusjurnal from " . $dbname . ".log_baspk \r\n                  where notransaksi='" . $data[$key]['notransaksi'] . "' and statusjurnal=0";
    $resx = mysql_query($strx);
    if (mysql_num_rows($resx) > 0) {

示例#10

0

显示文件

文件： log_slave_suratjalan.php 项目： halimc17/magsys

 $res = mysql_query($str);
 while ($bar = mysql_fetch_object($res)) {
     $nama[$bar->karyawanid] = $bar->namakaryawan;
 }
 $optFranco = makeOption($dbname, 'setup_franco', 'id_franco,franco_name');
 # Header
 $header = array($_SESSION['lang']['nosj'], $_SESSION['lang']['pt'], $_SESSION['lang']['tanggal'], $_SESSION['lang']['tgl_kirim'], 'Release', $_SESSION['lang']['franco'], $_SESSION['lang']['tanggaltiba']);
 # Content
 $cols = "nosj,kodept,tanggal,tanggalkirim,postingby,franco,tanggaltiba,posting";
 $order = "nosj desc";
 $query = selectQuery($dbname, 'log_suratjalanht', $cols, $where, $order, false, $param['shows'], $param['page']);
 $data = fetchData($query);
 if (empty($where)) {
     $where = null;
 }
 $totalRow = getTotalRow($dbname, 'log_suratjalanht', $where);
 foreach ($data as $key => $row) {
     if ($row['posting'] == 1) {
         $data[$key]['switched'] = true;
     }
     unset($data[$key]['posting']);
     $data[$key]['tanggal'] = tanggalnormal($row['tanggal']);
     $data[$key]['tanggalkirim'] = tanggalnormal($row['tanggalkirim']);
     if (!empty($row['tanggaltiba'])) {
         $data[$key]['tanggaltiba'] = tanggalnormal($row['tanggaltiba']);
     }
     if ($row['postingby'] != 0) {
         $data[$key]['postingby'] = $nama[$row['postingby']];
     }
     $data[$key]['franco'] = $optFranco[$row['franco']];
 }

示例#11

0

显示文件

文件： pabrik_hasil.php 项目： halimc17/magsys

<?php 
#=== Prep Control & Search
$ctl = array();
# Control
$ctl[] = "<div align='center'><img class=delliconBig src=images/" . $_SESSION['theme'] . "/addbig.png title='" . $_SESSION['lang']['new'] . "' onclick=\"showAdd()\"><br><span align='center'>" . $_SESSION['lang']['new'] . "</span></div>";
$ctl[] = "<div align='center'><img class=delliconBig src=images/" . $_SESSION['theme'] . "/list.png title='" . $_SESSION['lang']['list'] . "' onclick=\"defaultList()\"><br><span align='center'>" . $_SESSION['lang']['list'] . "</span></div>";
# Search
$ctl[] = "<fieldset><legend><b>" . $_SESSION['lang']['find'] . "</b></legend>" . makeElement('sNoTrans', 'label', $_SESSION['lang']['notransaksi']) . makeElement('sNoTrans', 'text', '') . makeElement('sFind', 'btn', $_SESSION['lang']['find'], array('onclick' => "searchTrans()")) . "</fieldset>";
#=== Table Aktivitas
# Header
$header = array('Nomor', 'Tanggal', 'Pabrik', 'Kode Tangki', 'Kuantitas CPO', 'Kuantitas PK');
# Content
$cols = "notransaksi,tanggal,kodeorg,kodetangki,kuantitas,kernelquantity";
$query = selectQuery($dbname, 'pabrik_masukkeluartangki', $cols, "kodeorg='" . $_SESSION['empl']['lokasitugas'] . "'", "", false, 10, 1);
$data = fetchData($query);
$totalRow = getTotalRow($dbname, 'pabrik_masukkeluartangki');
foreach ($data as $key => $row) {
    $data[$key]['tanggal'] = tanggalnormal($row['tanggal']);
}
# Make Table
$tHeader = new rTable('headTable', 'headTableBody', $header, $data);
$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[1]->setAltImg('images/' . $_SESSION['theme'] . "/posted.png");
$tHeader->pageSetting(1, $totalRow, 10);
#echo "<pre>";
#print_r($tHeader);
#=== Display View
# Title & Control
OPEN_BOX();

示例#12

0

显示文件

文件： keu_slave_5mesinlaporan.php 项目： halimc17/magsys

                     $where .= " and " . $r1[0] . " like '%" . $r1[1] . "%'";
                 }
             }
         } else {
             $where = null;
         }
     } else {
         $where = null;
     }
     # Header
     $header = array($_SESSION['lang']['kodeorg'], $_SESSION['lang']['namalaporan'], $_SESSION['lang']['periode'], $_SESSION['lang']['ket1']);
     # Content
     $cols = "kodeorg,namalaporan,periode,ket1";
     $query = selectQuery($dbname, 'keu_5mesinlaporanht', $cols, $where, "", false, $param['shows'], $param['page']);
     $data = fetchData($query);
     $totalRow = getTotalRow($dbname, 'keu_5mesinlaporanht', $where);
     # Make Table
     $tHeader = new rTable('headTable', 'headTableBody', $header, $data);
     $tHeader->addAction('showEdit', 'Edit', 'images/' . $_SESSION['theme'] . "/edit.png");
     $tHeader->addAction('deleteData', 'Delete', 'images/' . $_SESSION['theme'] . "/delete.png");
     $tHeader->pageSetting($param['page'], $totalRow, $param['shows']);
     if (isset($param['where'])) {
         $tHeader->setWhere($arrWhere);
     }
     # View
     $tHeader->renderTable();
     break;
     # Form Add Header
 # Form Add Header
 case 'showAdd':
     // View

示例#13

0

显示文件

文件： pabrik_pengolahan.php 项目： halimc17/magsys

<?php 
#=== Prep Control & Search
$ctl = array();
# Control
$ctl[] = "<div align='center'><img class=delliconBig src=images/" . $_SESSION['theme'] . "/addbig.png title='" . $_SESSION['lang']['new'] . "' onclick=\"showAdd()\"><br><span align='center'>" . $_SESSION['lang']['new'] . "</span></div>";
$ctl[] = "<div align='center'><img class=delliconBig src=images/" . $_SESSION['theme'] . "/list.png title='" . $_SESSION['lang']['list'] . "' onclick=\"defaultList()\"><br><span align='center'>" . $_SESSION['lang']['list'] . "</span></div>";
# Search
$ctl[] = "<fieldset><legend><b>" . $_SESSION['lang']['find'] . "</b></legend>" . makeElement('sNoTrans', 'label', $_SESSION['lang']['nopengolahan']) . makeElement('sNoTrans', 'text', '') . makeElement('sFind', 'btn', $_SESSION['lang']['find'], array('onclick' => "searchTrans()")) . "</fieldset>";
#=== Table Aktivitas
# Header
$header = array($_SESSION['lang']['nopengolahan'], $_SESSION['lang']['pabrik'], $_SESSION['lang']['tanggal'], $_SESSION['lang']['shift']);
# Content
$cols = "nopengolahan,kodeorg,tanggal,shift,posting";
$query = selectQuery($dbname, 'pabrik_pengolahan', $cols, "kodeorg='" . $_SESSION['empl']['lokasitugas'] . "' order by tanggal desc", "", false, 10, 1);
$data = fetchData($query);
$totalRow = getTotalRow($dbname, 'pabrik_pengolahan');
/*foreach($data as $key=>$row) {
    $data[$key]['tanggal'] = tanggalnormal($row['tanggal']);
}*/
foreach ($data as $key => $row) {
    $data[$key]['tanggal'] = tanggalnormal($row['tanggal']);
    if ($row['posting'] == 1) {
        $data[$key]['switched'] = true;
    }
    unset($data[$key]['posting']);
}
# Make Table
$tHeader = new rTable('headTable', 'headTableBody', $header, $data);
#$tHeader->addAction('showDetail','Detail','images/'.$_SESSION['theme']."/detail.png");
$tHeader->addAction('showEdit', 'Edit', 'images/' . $_SESSION['theme'] . "/edit.png");
$tHeader->addAction('deleteData', 'Delete', 'images/' . $_SESSION['theme'] . "/delete.png");

示例#14

0

显示文件

文件： kebun_rencanapanen.php 项目： halimc17/magsys

# Options
$optAfd = getOrgBelow($dbname, $_SESSION['empl']['lokasitugas'], false, 'afdeling');
#$optAfd = makeOption($dbname,'organisasi','kodeorganisasi,namaorganisasi',
#  "kodeorganisasi='".$_SESSION['empl']['lokasitugas']."'");
$optBulan = optionMonth(substr($_SESSION['language'], 0, 1), 'long');
# Search
$ctl[] = "<fieldset><legend><b>" . $_SESSION['lang']['find'] . "</b></legend>" . makeElement('sAfdeling', 'label', $_SESSION['lang']['afdeling']) . makeElement('sAfdeling', 'select', '', array(), $optAfd) . "&nbsp;" . makeElement('sPeriode', 'label', $_SESSION['lang']['periode']) . makeElement('sBulan', 'select', '', array(), $optBulan) . "/" . makeElement('sTahun', 'text', date('Y'), array('style' => 'width:50px')) . makeElement('sFind', 'btn', $_SESSION['lang']['find'], array('onclick' => "searchTrans('" . $tipe . "','" . $tipeVal . "')")) . "</fieldset>";
#=== Table Aktivitas
# Header
$header = array($_SESSION['lang']['afdeling'], $_SESSION['lang']['blok'], $_SESSION['lang']['tanggal'], $_SESSION['lang']['bulan'], $_SESSION['lang']['tahun'], $_SESSION['lang']['jumlah'], $_SESSION['lang']['jumlahha'], $_SESSION['lang']['jumlahpremi'], $_SESSION['lang']['jumlahpokok']);
# Content
$optNamaOrg = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi');
$cols = "kodeorg,kodeblok,tanggal,bulan,tahun,jumlah,jumlahha,jumlahpremi,jumlahpokok";
$query = selectQuery($dbname, 'kebun_rencanapanen', $cols, "left(kodeorg,4)='" . $_SESSION['empl']['lokasitugas'] . "'", "", false, 10, 1);
$data = fetchData($query);
$totalRow = getTotalRow($dbname, 'kebun_rencanapanen');
foreach ($data as $key => $row) {
    $data[$key]['tanggal'] = tanggalnormal($row['tanggal']);
    $data[$key]['kodeorg'] = $optNamaOrg[$row['kodeorg']];
    $data[$key]['kodeblok'] = $row['kodeblok'];
}
# Make Table
$tHeader = new rTable('headTable', 'headTableBody', $header, $data);
#$tHeader->addAction('showDetail','Detail','images/'.$_SESSION['theme']."/detail.png");
$tHeader->addAction('showEdit', 'Edit', 'images/' . $_SESSION['theme'] . "/edit.png");
//$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");
$tHeader->pageSetting(1, $totalRow, 10);
$tHeader->setWhere($whereContArr);

PHP getTotalRow示例