PHP selectQuery函数代码示例

 function Header()
 {
     global $conn;
     global $dbname;
     global $align;
     global $length;
     global $colArr;
     global $title;
     global $kdOrg;
     global $tgl;
     # Bulan
     // $optBulan =
     # Alamat & No Telp
     $query = selectQuery($dbname, 'organisasi', 'alamat,telepon', "kodeorganisasi='" . $_SESSION['org']['kodeorganisasi'] . "'");
     $orgData = fetchData($query);
     $width = $this->w - $this->lMargin - $this->rMargin;
     $height = 12;
     $path = 'images/logo.jpg';
     $this->Image($path, $this->lMargin, $this->tMargin, 0, 55);
     $this->SetFont('Arial', 'B', 9);
     $this->SetFillColor(255, 255, 255);
     $this->SetX(100);
     $this->Cell($width - 100, $height, $_SESSION['org']['namaorganisasi'], 0, 1, 'L');
     $this->SetX(100);
     $this->Cell($width - 100, $height, $orgData[0]['alamat'], 0, 1, 'L');
     $this->SetX(100);
     $this->Cell($width - 100, $height, "Tel: " . $orgData[0]['telepon'], 0, 1, 'L');
     $this->Line($this->lMargin, $this->tMargin + $height * 4, $this->lMargin + $width, $this->tMargin + $height * 4);
     $this->Ln();
     $this->SetFont('Arial', '', 8);
     $this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['kodeorg'], '', 0, 'L');
     $this->Cell(5, $height, ':', '', 0, 'L');
     $this->Cell(45 / 100 * $width, $height, $_SESSION['empl']['lokasitugas'], '', 0, 'L');
     $this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['user'], '', 0, 'L');
     $this->Cell(5, $height, ':', '', 0, 'L');
     $this->Cell(15 / 100 * $width, $height, $_SESSION['standard']['username'], 0, 0, 'L');
     $this->Ln();
     $query2 = selectQuery($dbname, 'organisasi', 'namaorganisasi', "kodeorganisasi='" . $kdOrg . "'");
     $orgData2 = fetchData($query2);
     $this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['kebun'], '', 0, 'L');
     $this->Cell(5, $height, ':', '', 0, 'L');
     $this->Cell(45 / 100 * $width, $height, $orgData2[0]['namaorganisasi'], '', 0, 'L');
     $this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['tanggal'], '', 0, 'L');
     $this->Cell(5, $height, ':', '', 0, 'L');
     $this->Cell(15 / 100 * $width, $height, date('d-m-Y H:i:s'), '', 1, 'L');
     $this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['periode'], '', 0, 'L');
     $this->Cell(5, $height, ':', '', 0, 'L');
     $this->Cell(45 / 100 * $width, $height, $tgl[1] . "-" . $tgl[0], '', 0, 'L');
     $this->Ln();
     $this->SetFont('Arial', 'U', 12);
     $this->Cell($width, $height, $title, 0, 1, 'C');
     $this->Ln();
     $this->SetFont('Arial', 'B', 9);
     $this->SetFillColor(220, 220, 220);
     // $this->Cell(10/100*$width,$height,'No',1,0,'C',1);
     foreach ($colArr as $key => $head) {
         $this->Cell($length[$key] / 100 * $width, $height, $_SESSION['lang'][$head], 1, 0, 'C', 1);
     }
     $this->Ln();
 }

 function Header()
 {
     global $conn;
     global $dbname;
     global $align;
     global $length;
     global $colArr;
     global $title;
     global $nopp;
     global $tglSdt;
     global $statPP;
     $kdorg = explode("/", $nopp);
     # Bulan
     // $optBulan =
     # Alamat & No Telp
     $query = selectQuery($dbname, 'organisasi', 'alamat,telepon', "kodeorganisasi='" . $_SESSION['org']['kodeorganisasi'] . "'");
     $orgData = fetchData($query);
     $width = $this->w - $this->lMargin - $this->rMargin;
     $height = 12;
     $path = 'images/logo.jpg';
     $this->Image($path, $this->lMargin, $this->tMargin, 0, 55);
     $this->SetFont('Arial', 'B', 9);
     $this->SetFillColor(255, 255, 255);
     $this->SetX(100);
     $this->Cell($width - 100, $height, $_SESSION['org']['namaorganisasi'], 0, 1, 'L');
     $this->SetX(100);
     $this->Cell($width - 100, $height, $orgData[0]['alamat'], 0, 1, 'L');
     $this->SetX(100);
     $this->Cell($width - 100, $height, "Tel: " . $orgData[0]['telepon'], 0, 1, 'L');
     $this->Line($this->lMargin, $this->tMargin + $height * 4, $this->lMargin + $width, $this->tMargin + $height * 4);
     $this->Ln();
     $this->SetFont('Arial', '', 8);
     $this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['user'], '', 0, 'L');
     $this->Cell(5, $height, ':', '', 0, 'L');
     $this->Cell(45 / 100 * $width, $height, $_SESSION['standard']['username'], '', 0, 'L');
     $this->Ln();
     $this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['tanggal'], '', 0, 'L');
     $this->Cell(5, $height, ':', '', 0, 'L');
     $this->Cell(45 / 100 * $width, $height, date('d-m-Y H:i:s'), '', 0, 'L');
     $this->Ln();
     $this->Ln();
     $this->Ln();
     $this->SetFont('Arial', 'B', 10);
     $this->Cell($width, $height, strtoupper($_SESSION['lang']['riwayatPP']), 0, 1, 'C');
     $this->SetFont('Arial', 'B', 7);
     $this->SetFillColor(220, 220, 220);
     $this->Ln();
     $this->Cell(3 / 100 * $width, $height, 'No.', 1, 0, 'C', 1);
     $this->Cell(8 / 100 * $width, $height, $_SESSION['lang']['nopp'], 1, 0, 'C', 1);
     $this->Cell(18 / 100 * $width, $height, $_SESSION['lang']['namabarang'], 1, 0, 'C', 1);
     $this->Cell(18 / 100 * $width, $height, $_SESSION['lang']['status'], 1, 0, 'C', 1);
     $this->Cell(10 / 100 * $width, $height, $_SESSION['lang']['nopo'], 1, 0, 'C', 1);
     $this->Cell(5 / 100 * $width, $height, $_SESSION['lang']['tanggal'] . " PO", 1, 0, 'C', 1);
     $this->Cell(12 / 100 * $width, $height, $_SESSION['lang']['status'] . " PO", 1, 0, 'C', 1);
     $this->Cell(10 / 100 * $width, $height, $_SESSION['lang']['namasupplier'], 1, 0, 'C', 1);
     $this->Cell(10 / 100 * $width, $height, $_SESSION['lang']['rapbNo'], 1, 0, 'C', 1);
     $this->Cell(5 / 100 * $width, $height, $_SESSION['lang']['tanggal'], 1, 1, 'C', 1);
 }

 function Header()
 {
     global $conn;
     global $dbname;
     global $align;
     global $length;
     global $colArr;
     global $title;
     global $periode;
     //$periode=$_GET['column'];
     # Alamat & No Telp
     $query = selectQuery($dbname, 'organisasi', 'alamat,telepon', "kodeorganisasi='" . $_SESSION['org']['kodeorganisasi'] . "'");
     $orgData = fetchData($query);
     $width = $this->w - $this->lMargin - $this->rMargin;
     $height = 12;
     $path = 'images/logo.jpg';
     $this->Image($path, $this->lMargin, $this->tMargin, 0, 55);
     $this->SetFont('Arial', 'B', 9);
     $this->SetFillColor(255, 255, 255);
     $this->SetX(100);
     $this->Cell($width - 100, $height, $_SESSION['org']['namaorganisasi'], 0, 1, 'L');
     $this->SetX(100);
     $this->Cell($width - 100, $height, $orgData[0]['alamat'], 0, 1, 'L');
     $this->SetX(100);
     $this->Cell($width - 100, $height, "Tel: " . $orgData[0]['telepon'], 0, 1, 'L');
     $this->Line($this->lMargin, $this->tMargin + $height * 4, $this->lMargin + $width, $this->tMargin + $height * 4);
     $this->Ln();
     $this->SetFont('Arial', '', 8);
     $this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['user'], '', 0, 'L');
     $this->Cell(5, $height, ':', '', 0, 'L');
     $this->Cell(45 / 100 * $width, $height, ucfirst($_SESSION['standard']['username']), '', 0, 'L');
     /*   $this->Cell((20/100*$width)-5,$height,$_SESSION['lang']['periode'],'',0,'L');
          $this->Cell(5,$height,':','',0,'L');
          $this->Cell(15/100*$width,$height, $periode,0,0,'L');*/
     $this->Ln();
     $this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['tanggal'], '', 0, 'L');
     $this->Cell(5, $height, ':', '', 0, 'L');
     $this->Cell(45 / 100 * $width, $height, date('d-m-Y H:i:s'), '', 0, 'L');
     $this->Ln();
     $this->SetFont('Arial', 'U', 12);
     $this->Cell($width, $height, $_SESSION['lang']['rekomendasiPupuk'], 0, 1, 'C');
     $this->Ln();
     $this->SetFont('Arial', 'B', 9);
     $this->SetFillColor(220, 220, 220);
     // $this->Cell(10/100*$width,$height,'No',1,0,'C',1);
     /*foreach($colArr as $key=>$head) {
           $this->Cell($length[$key]/100*$width,$height,$_SESSION['lang'][$head],1,0,'C',1);
       }*/
     $this->Cell(3 / 100 * $width, $height, 'No', 1, 0, 'C', 1);
     $this->Cell(12 / 100 * $width, $height, $_SESSION['lang']['tahunpupuk'], 1, 0, 'C', 1);
     $this->Cell(21 / 100 * $width, $height, $_SESSION['lang']['afdeling'], 1, 0, 'C', 1);
     $this->Cell(12 / 100 * $width, $height, $_SESSION['lang']['blok'], 1, 0, 'C', 1);
     $this->Cell(13 / 100 * $width, $height, $_SESSION['lang']['tahuntanam'], 1, 0, 'C', 1);
     $this->Cell(16 / 100 * $width, $height, $_SESSION['lang']['jenisPupuk'], 1, 0, 'C', 1);
     $this->Cell(7 / 100 * $width, $height, $_SESSION['lang']['dosis'], 1, 0, 'C', 1);
     $this->Cell(7 / 100 * $width, $height, $_SESSION['lang']['satuan'], 1, 0, 'C', 1);
     $this->Cell(10 / 100 * $width, $height, $_SESSION['lang']['jenisbibit'], 1, 1, 'C', 1);
 }

function findUsersByNamePwd($userName, $psw)
{
    // 包含数据库操作文件
    include_once 'sqlQuery.php';
    // 生成sql语句
    $query = "select * from userinfo\n        where Account = '{$userName}' and PWD = '{$psw}'";
    // 返回结果
    return selectQuery($query);
}

function FindTestResultByUserPaper($userID, $paperID)
{
    //包含数据库操作文件
    include_once 'sqlQuery.php';
    //生成sql语句
    $query = "select * from testresult\n    where UserID = {$userID} and  PaperID = {$paperID}";
    //返回结果
    return selectQuery($query);
}

 /**
  * getParam
  * Get Parameter Jurnal based on kodeaplikasi dan kodejurnal
  */
 public function getParam($holding, $kodeApp, $kodeJurnal)
 {
     global $dbname;
     $qParam = selectQuery($dbname, 'keu_5parameterjurnal', 'noakundebet,noakunkredit,sampaidebet,sampaikredit', "kodeorg='" . $holding . "' and kodeaplikasi='" . $kodeApp . "' and jurnalid='" . $kodeJurnal . "' and aktif=1");
     $resParam = fetchData($qParam);
     if (empty($resParam)) {
         return array();
     } else {
         return $resParam[0];
     }
 }

function checkIfUserAlreadyHasThisUrl($url, $userID)
{
    $query = "SELECT * from links where url = ? and userID = ?";
    $params = [$url, $userID];
    $result = selectQuery($query, $params);
    if (count($result) == 1) {
        return 0;
    } else {
        return 1;
    }
}

 function Header()
 {
     global $conn;
     global $dbname;
     global $bulan;
     global $tahun;
     # Alamat & No Telp
     $query = selectQuery($dbname, 'organisasi', 'alamat,telepon', "kodeorganisasi='" . $_SESSION['org']['kodeorganisasi'] . "'");
     $orgData = fetchData($query);
     $sPeriode = "select distinct periode from " . $dbname . ".setup_periodeakuntansi where kodeorg='" . $_SESSION['empl']['lokasitugas'] . "'\r\n            and tutupbuku = 0";
     $qPeriode = mysql_query($sPeriode) or die(mysql_error());
     $rPeriode = mysql_fetch_assoc($qPeriode);
     $width = $this->w - $this->lMargin - $this->rMargin;
     $height = 12;
     $path = 'images/logo.jpg';
     $this->Image($path, $this->lMargin, $this->tMargin, 0, 55);
     $this->SetFont('Arial', 'B', 9);
     $this->SetFillColor(255, 255, 255);
     $this->SetX(100);
     $this->Cell($width - 100, $height, $_SESSION['org']['namaorganisasi'], 0, 1, 'L');
     $this->SetX(100);
     $this->Cell($width - 100, $height, $orgData[0]['alamat'], 0, 1, 'L');
     $this->SetX(100);
     $this->Cell($width - 100, $height, "Tel: " . $orgData[0]['telepon'], 0, 1, 'L');
     $this->Line($this->lMargin, $this->tMargin + $height * 4, $this->lMargin + $width, $this->tMargin + $height * 4);
     $this->Ln();
     $this->SetFont('Arial', '', 8);
     $this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['kodeorg'], '', 0, 'L');
     $this->Cell(5, $height, ':', '', 0, 'L');
     $this->Cell(45 / 100 * $width, $height, $_SESSION['empl']['lokasitugas'], '', 0, 'L');
     $this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['periode'], '', 0, 'L');
     $this->Cell(5, $height, ':', '', 0, 'L');
     $this->Cell(15 / 100 * $width, $height, $rPeriode['periode'], 0, 0, 'L');
     $this->Ln();
     $this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['user'], '', 0, 'L');
     $this->Cell(5, $height, ':', '', 0, 'L');
     $this->Cell(45 / 100 * $width, $height, $_SESSION['standard']['username'], '', 0, 'L');
     $this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['tanggal'], '', 0, 'L');
     $this->Cell(5, $height, ':', '', 0, 'L');
     $this->Cell(15 / 100 * $width, $height, date('d-m-Y H:i:s'), '', 1, 'L');
     $this->Ln();
     $this->SetFont('Arial', 'U', 12);
     $this->Cell($width, $height, strtoupper($this->_title), 0, 1, 'C');
     if ($this->_noThead == false) {
         $this->Ln();
         $this->SetFont('Arial', 'B', 9);
         $this->SetFillColor(220, 220, 220);
         foreach ($this->_colArr as $key => $head) {
             $this->Cell($this->_length[$key] / 100 * $width, $height, $_SESSION['lang'][$head], 1, 0, 'C', 1);
         }
         $this->Ln();
     }
 }

 public function challenge()
 {
     global $cn;
     // DB読込み(メンバーテーブルから認証)
     $strSQL = "select a.member_id, a.login_pwd as pass, a.login_pwd_md5 as hashed_pass, a.pass_salt, a.name1, a.name2, a.disp_name, a.email, a.nickname, a.api_key, a.force_chpwd, a.login_ok_ymd " . "from v_member_header a " . "where login_id = '{$_REQUEST['email']}' ";
     $result = selectQuery($cn, $strSQL);
     if ($row = getRow($result)) {
         RCMSUser::setLogin($row, $_REQUEST['login_save']);
         LoginHistory::write($cn, RCMSUser::getUser());
         $_SESSION["password_inputted"] = 1;
         return array(true, $_REQUEST['login_save'] == 1);
     }
     return array(true, $_REQUEST['login_save'] == 1);
 }

 function Header()
 {
     global $conn;
     global $dbname;
     global $align;
     global $length;
     global $colArr;
     global $title;
     global $dataTR;
     $dataTR = explode(",", $_GET['column']);
     # Alamat & No Telp
     $query = selectQuery($dbname, 'organisasi', 'alamat,telepon', "kodeorganisasi='" . $_SESSION['org']['kodeorganisasi'] . "'");
     $orgData = fetchData($query);
     $width = $this->w - $this->lMargin - $this->rMargin;
     $height = 12;
     $path = 'images/logo.jpg';
     $this->Image($path, $this->lMargin, $this->tMargin, 0, 55);
     $this->SetFont('Arial', 'B', 9);
     $this->SetFillColor(255, 255, 255);
     $this->SetX(100);
     $this->Cell($width - 100, $height, $_SESSION['org']['namaorganisasi'], 0, 1, 'L');
     $this->SetX(100);
     $this->Cell($width - 100, $height, $orgData[0]['alamat'], 0, 1, 'L');
     $this->SetX(100);
     $this->Cell($width - 100, $height, "Tel: " . $orgData[0]['telepon'], 0, 1, 'L');
     $this->Line($this->lMargin, $this->tMargin + $height * 4, $this->lMargin + $width, $this->tMargin + $height * 4);
     $this->Ln();
     //                $this->SetFont('Arial','',8);
     //                $this->Cell((20/100*$width)-5,$height,$_SESSION['lang']['user'],'',0,'L');
     //                $this->Cell(5,$height,':','',0,'L');
     //                $this->Cell(45/100*$width,$height,$_SESSION['standard']['username'],'',0,'L');
     //
     //                $this->Ln();
     //                $this->Cell((20/100*$width)-5,$height,$_SESSION['lang']['tanggal'],'',0,'L');
     //                $this->Cell(5,$height,':','',0,'L');
     //                $this->Cell(45/100*$width,$height,date('d-m-Y H:i:s'),'',0,'L');
     $this->Ln();
     $this->SetFont('Arial', 'U', 11);
     $this->Cell($width, $height, $_SESSION['lang']['pengirimanBibit'], 0, 1, 'C');
     $this->Ln(35);
     //                $this->SetFont('Arial','B',9);
     //                $this->SetFillColor(220,220,220);
     // $this->Cell(10/100*$width,$height,'No',1,0,'C',1);
     /*foreach($colArr as $key=>$head) {
           $this->Cell($length[$key]/100*$width,$height,$_SESSION['lang'][$head],1,0,'C',1);
       }*/
 }

function prodHasProbFlds($pp_kod, $adminDept)
{
    $hasProbFlds = false;
    $sql3 = "SELECT COUNT(*) as probFldsCnt FROM p_product_correspondence ";
    $sql3 .= " WHERE p_product_correspondence.ppc_pp_kod = " . $pp_kod;
    $sql3 .= " AND p_product_correspondence.ppc_admin_yes = 0 ";
    $sql3 .= " AND p_product_correspondence.ppc_admin_dept = " . $adminDept;
    // echo $sql3;
    $result3 = selectQuery($sql3, 1);
    if ($result3) {
        if (isset($result3) && isset($result3["probFldsCnt"]) && $result3["probFldsCnt"]) {
            // echo "here";
            $hasProbFlds = true;
        }
    }
    return $hasProbFlds;
}

 function Header()
 {
     global $conn;
     global $dbname;
     global $periode;
     $cols = 247.5;
     $query = selectQuery($dbname, 'organisasi', 'alamat,telepon', "kodeorganisasi='" . $_SESSION['org']['kodeorganisasi'] . "'");
     $orgData = fetchData($query);
     $width = $this->w - $this->lMargin - $this->rMargin;
     $height = 20;
     $path = 'images/logo.jpg';
     $this->Image($path, $this->lMargin, $this->tMargin, 0, 55);
     $this->SetFont('Arial', 'B', 9);
     $this->SetFillColor(255, 255, 255);
     $this->SetX(100);
     $this->Cell($width - 100, $height, $_SESSION['org']['namaorganisasi'], 0, 1, 'L');
     $this->SetX(100);
     $this->Cell($width - 100, $height, $orgData[0]['alamat'], 0, 1, 'L');
     $this->SetX(100);
     $this->Cell($width - 100, $height, "Tel: " . $orgData[0]['telepon'], 0, 1, 'L');
     $this->Line($this->lMargin, $this->tMargin + $height * 3, $this->lMargin + $width, $this->tMargin + $height * 3);
     $this->SetFont('Arial', 'B', 10);
     $this->Cell($width, $height, "Laporan Biaya per Blok ", '', 0, 'C');
     $this->Ln();
     $this->Cell($width, $height, strtoupper($_SESSION['lang']['periode']) . " : " . substr($periode, 5, 2) . "-" . substr($periode, 0, 4), '', 0, 'C');
     $this->Ln();
     $this->SetFont('Arial', 'B', 10);
     $this->SetFillColor(220, 220, 220);
     $this->SetX(80);
     $this->Cell(7 / 100 * $width, $height, "No.", 1, 0, 'C', 1);
     $this->Cell(15 / 100 * $width, $height, $_SESSION['lang']['kodeblok'], 1, 0, 'C', 1);
     $this->Cell(14 / 100 * $width, $height, $_SESSION['lang']['tahuntanam'], 1, 0, 'C', 1);
     $this->Cell(15 / 100 * $width, $height, $_SESSION['lang']['luas'], 1, 0, 'C', 1);
     $this->Cell(15 / 100 * $width, $height, $_SESSION['lang']['statusblok'], 1, 0, 'C', 1);
     $this->Cell(15 / 100 * $width, $height, $_SESSION['lang']['totalbiaya'], 1, 0, 'C', 1);
 }

 $optOrg = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi', $where, '0');
 $whereKary = "";
 $i = 0;
 foreach ($optOrg as $key => $row) {
     if ($i == 0) {
         $whereKary .= "lokasitugas='" . $key . "'";
     } else {
         $whereKary .= " or lokasitugas='" . $key . "'";
     }
     $i++;
 }
 $optKary = makeOption($dbname, 'datakaryawan', 'karyawanid,namakaryawan', $whereKary, '0');
 # Get Data
 $where = "kodeorg='" . $param['kodeorg'] . "' and shift=" . $param['shift'];
 $cols = "nik";
 $query = selectQuery($dbname, 'pabrik_5shiftanggota', $cols, $where);
 $data = fetchData($query);
 $dataShow = $data;
 foreach ($dataShow as $key => $row) {
     $dataShow[$key]['nik'] = $optKary[$row['nik']];
 }
 # Form
 $theForm2 = new uForm('kasbankForm', $_SESSION['lang']['form'] . " " . $_SESSION['lang']['anggotashif']);
 $theForm2->addEls('nik', $_SESSION['lang']['nik'], '', 'select', 'L', 20, $optKary);
 # Table
 $theTable2 = new uTable('kasbankTable', $_SESSION['lang']['tabel'] . " " . $_SESSION['lang']['anggotashif'], $cols, $data, $dataShow);
 # FormTable
 $formTab2 = new uFormTable('ftPrestasi', $theForm2, $theTable2, null, array('kodeorg##shift'));
 $formTab2->_target = "pabrik_slave_5shift";
 #== Display View
 # Draw Tab

 function Header()
 {
     //declarasi header variabel
     global $conn;
     global $dbname;
     global $align;
     global $length;
     global $colArr;
     global $title;
     global $nmOrg;
     global $kdOrg;
     global $kdAst;
     global $nmAst;
     global $thnPer;
     global $nmAsst;
     global $namakar;
     global $selisih;
     global $where;
     //alamat PT minanga dan logo
     $query = selectQuery($dbname, 'organisasi', 'alamat,telepon', "kodeorganisasi='" . $_SESSION['org']['kodeorganisasi'] . "'");
     $orgData = fetchData($query);
     $width = $this->w - $this->lMargin - $this->rMargin;
     $height = 20;
     if ($_SESSION['org']['kodeorganisasi'] == 'HIP') {
         $path = 'images/hip_logo.jpg';
     } else {
         if ($_SESSION['org']['kodeorganisasi'] == 'SIL') {
             $path = 'images/sil_logo.jpg';
         } else {
             if ($_SESSION['org']['kodeorganisasi'] == 'SIP') {
                 $path = 'images/sip_logo.jpg';
             }
         }
     }
     $this->Image($path, $this->lMargin, $this->tMargin, 0, 55);
     $this->SetFont('Arial', 'B', 9);
     $this->SetFillColor(255, 255, 255);
     $this->SetX(100);
     $this->Cell($width - 100, $height, $_SESSION['org']['namaorganisasi'], 0, 1, 'L');
     $this->SetX(100);
     $this->Cell($width - 100, $height, $orgData[0]['alamat'], 0, 1, 'L');
     $this->SetX(100);
     $this->Cell($width - 100, $height, "Tel: " . $orgData[0]['telepon'], 0, 1, 'L');
     $this->Line($this->lMargin, $this->tMargin + $height * 4, $this->lMargin + $width, $this->tMargin + $height * 4);
     $this->Ln();
     //tutup logo dan alamat
     //untuk sub judul
     $this->SetFont('Arial', 'B', 10);
     $this->Cell(20 / 100 * $width - 5, $height, "Asset List", '', 0, 'L');
     $this->Ln();
     $this->SetFont('Arial', '', 8);
     $this->Cell(100 / 100 * $width - 5, $height, "Printed By : " . $namakar[$_SESSION['standard']['userid']], '', 0, 'R');
     $this->Ln();
     $this->Cell(100 / 100 * $width - 5, $height, "Date : " . date('d-m-Y'), '', 0, 'R');
     $this->Ln();
     $this->Cell(100 / 100 * $width - 5, $height, "Time : " . date('h:i:s'), '', 0, 'R');
     $this->Ln();
     $this->Ln();
     //tutup sub judul
     //judul tengah
     $this->SetFont('Arial', 'B', 12);
     $this->Cell($width, $height, strtoupper("Asset List " . "{$nmAst}") . " " . $_SESSION['lang']['periode'] . ":" . $kdAst, '', 0, 'C');
     $this->Ln();
     $this->Cell($width, $height, strtoupper("{$nmOrg}"), '', 0, 'C');
     $this->Ln();
     $this->Ln();
     //tutup judul tengah
     //isi atas tabel
     $this->SetFont('Arial', 'B', 6);
     $this->SetFillColor(220, 220, 220);
     $this->Cell(2 / 100 * $width, $height, "No", 1, 0, 'C', 1);
     $this->Cell(7 / 100 * $width, $height, $_SESSION['lang']['kodeorganisasi'], 1, 0, 'C', 1);
     $this->Cell(7 / 100 * $width, $height, $_SESSION['lang']['kodeasset'], 1, 0, 'C', 1);
     $this->Cell(7 / 100 * $width, $height, $_SESSION['lang']['thnperolehan'], 1, 0, 'C', 1);
     $this->Cell(15 / 100 * $width, $height, $_SESSION['lang']['namaasset'], 1, 0, 'C', 1);
     //$this->Cell(5/100*$width,$height,$_SESSION['lang']['status'],1,0,'C',1);
     $this->Cell(9 / 100 * $width, $height, $_SESSION['lang']['hargaperolehan'], 1, 0, 'C', 1);
     $this->Cell(9 / 100 * $width, $height, $_SESSION['lang']['jumlahbulanpenyusutan'], 1, 0, 'C', 1);
     $this->Cell(6 / 100 * $width, $height, $_SESSION['lang']['usia'] . " (" . $_SESSION['lang']['bulan'] . ")", 1, 0, 'C', 1);
     $this->Cell(6 / 100 * $width, $height, $_SESSION['lang']['sisa'] . " (" . $_SESSION['lang']['bulan'] . ")", 1, 0, 'C', 1);
     $this->Cell(9 / 100 * $width, $height, $_SESSION['lang']['akumulasipenyusutan'], 1, 0, 'C', 1);
     $this->Cell(9 / 100 * $width, $height, $_SESSION['lang']['nilaibuku'], 1, 0, 'C', 1);
     $this->Cell(9 / 100 * $width, $height, $_SESSION['lang']['awalpenyusutan'], 1, 0, 'C', 1);
     $this->Cell(6 / 100 * $width, $height, $_SESSION['lang']['bulanan'], 1, 1, 'C', 1);
     //tutup isi tabel
 }

<?php

session_start();
include_once 'lib/nangkoelib.php';
include_once 'lib/zLib.php';
#=========== Page Prep =============
$mode = $_POST['mode'];
$num = $_POST['num'];
$idK = $_POST['karyawanid'];
#=========== Get Data ==============
$where = "karyawanid=" . $idK;
$query = selectQuery($dbname, 'datakaryawan', '*', $where);
$data = fetchData($query);
if ($mode == 'add') {
    foreach ($data[0] as $key => $row) {
        $data[0][$key] = '';
    }
}
#=========== Prepare Tab and Content ==================
$hfrm = array('Utama', 'Perkawinan', 'Pendidikan', 'Alamat', 'Pangalaman Kerja', 'Riwayat', 'Penghargaan', 'Inventaris', 'Kondite');
$frm = array('Utama', makeElement('perkawinan', 'button', 'Refresh', array('onclick' => "refreshTab('perkawinan','" . $mode . "')")) . "<div id='tabPerkawinan'></div>", makeElement('pendidikan', 'button', 'Refresh', array('onclick' => "refreshTab('pendidikan','" . $mode . "')")) . "<div id='tabPendidikan'></div>", makeElement('alamat', 'button', 'Refresh', array('onclick' => "refreshTab('alamat','" . $mode . "')")) . "<div id='tabAlamat'></div>", makeElement('pengalamankerja', 'button', 'Refresh', array('onclick' => "refreshTab('pengalamankerja','" . $mode . "')")) . "<div id='tabPengalamanKerja'></div>", makeElement('riwayat', 'button', 'Refresh', array('onclick' => "refreshTab('riwayat','" . $mode . "')")) . "<div id='tabRiwayat'></div>", makeElement('penghargaan', 'button', 'Refresh', array('onclick' => "refreshTab('penghargaan','" . $mode . "')")) . "<div id='tabPenghargaan'></div>", makeElement('inventaris', 'button', 'Refresh', array('onclick' => "refreshTab('inventaris','" . $mode . "')")) . "<div id='tabInventaris'></div>", makeElement('kondite', 'button', 'Refresh', array('onclick' => "refreshTab('kondite','" . $mode . "')")) . "<div id='tabKondite'></div>");
#=========== Tab Utama =============
# Prep Options
$optOrg = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi');
$optPend = makeOption($dbname, 'sdm_5pendidikan', 'levelpendidikan,pendidikan');
$optJab = makeOption($dbname, 'sdm_5jabatan', 'kodejabatan,namajabatan');
$optGol = makeOption($dbname, 'sdm_5golongan', 'golongan,keterangan');
$optGender = array('P' => $_SESSION['lang']['pria'], 'W' => $_SESSION['lang']['wanita']);
$optStatMarr = array('Bujang' => $_SESSION['lang']['bujang'], 'Menikah' => $_SESSION['lang']['menikah'], 'Janda' => $_SESSION['lang']['janda'], 'Duda' => $_SESSION['lang']['duda']);
$optAgama = array('Islam' => $_SESSION['lang']['islam'], 'Protestan' => $_SESSION['lang']['protestan'], 'Katolik' => $_SESSION['lang']['katolik'], 'Hindu' => $_SESSION['lang']['hindu'], 'Budha' => $_SESSION['lang']['budha'], 'Konghucu' => $_SESSION['lang']['konghucu'], 'Lainnya' => $_SESSION['lang']['lain']);
$optBlood = array('A+' => 'A+', 'A-' => 'A-', 'B+' => 'B+', 'B-' => 'B-', 'O+' => 'O+', 'O-' => 'O-', 'AB+' => 'AB+', 'AB-' => 'AB-');