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-');
<script>
dataKdvhc="<?php
echo $_SESSION['lang']['pilihdata'];
?>
";
</script>
<?php
// Options
$optUnit = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi', "LENGTH(kodeorganisasi)=4", 2);
$optDiv = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi', "induk='" . key($optUnit) . "'", 2);
$optBlok = makeOption($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi', "induk='" . key($optDiv) . "'", 2);
$optKode = makeOption($dbname, 'bgt_kode', 'kodebudget,nama', "kodebudget not in ('KONTRAK','TOOL')", 2, true);
$optKode[''] = $_SESSION['lang']['pilihdata'];
$optMethod = array('insert' => 'Insert', 'update' => 'Update');
// Onchange Organisasi
$qOrg = selectQuery($dbname, 'organisasi', 'kodeorganisasi,namaorganisasi,induk', "LENGTH(kodeorganisasi) > 5");
$resOrg = fetchData($qOrg);
$optOrg = array();
foreach ($resOrg as $row) {
if (strlen($row['kodeorganisasi']) == 6) {
if (!isset($optOrg[substr($row['kodeorganisasi'], 0, 4)][$row['kodeorganisasi']])) {
$optOrg[substr($row['kodeorganisasi'], 0, 4)][$row['kodeorganisasi']] = array('nama' => $row['kodeorganisasi'] . " - " . $row['namaorganisasi'], 'child' => array());
} else {
$optOrg[substr($row['kodeorganisasi'], 0, 4)][$row['kodeorganisasi']]['nama'] = $row['kodeorganisasi'] . " - " . $row['namaorganisasi'];
}
} else {
if (!isset($optOrg[substr($row['kodeorganisasi'], 0, 4)][substr($row['kodeorganisasi'], 0, 6)])) {
$optOrg[substr($row['kodeorganisasi'], 0, 4)][substr($row['kodeorganisasi'], 0, 6)] = array('nama' => '', 'child' => array($row['kodeorganisasi'] => $row['kodeorganisasi'] . " - " . $row['namaorganisasi']));
} else {
$optOrg[substr($row['kodeorganisasi'], 0, 4)][substr($row['kodeorganisasi'], 0, 6)]['child'][$row['kodeorganisasi']] = $row['kodeorganisasi'] . " - " . $row['namaorganisasi'];
}
<?php
session_start();
include 'function_DB.php';
$ppe_admin_dept = 3;
if ($_SESSION['department'] == 'LAB') {
$ppe_admin_dept = 3;
} else {
if ($_SESSION['department'] == 'API') {
$ppe_admin_dept = 2;
} else {
if ($_SESSION['department'] == 'PRODUCT') {
$ppe_admin_dept = 1;
}
}
}
$result = selectQuery("SELECT * FROM p_product_correspondence\n\t\t\t\t WHERE p_product_correspondence.ppc_pp_kod = " . $_SESSION['product_reg']['ppID'] . " \n\t\t\t\t AND ppc_div_id IN ( SELECT ppe_div_id FROM p_product_escalates WHERE ppe_pp_kod = " . $_SESSION['product_reg']['ppID'] . " and ppe_admin_dept = " . $ppe_admin_dept . " )");
echo json_encode($result);
function prosesAlokasi()
{
global $conn;
global $tanggal;
global $param;
global $dbname;
global $defSegment;
#1 ambil periode akuntansi
$str = "select tanggalmulai,tanggalsampai from " . $dbname . ".setup_periodeakuntansi where \r\n kodeorg ='" . $_SESSION['empl']['lokasitugas'] . "' and tutupbuku=0";
$tgmulai = '';
$tgsampai = '';
$res = mysql_query($str);
if (mysql_num_rows($res) < 1) {
exit("Error: Tidak ada periode akuntansi untuk induk " . $_SESSION['empl']['lokasitugas']);
}
while ($bar = mysql_fetch_object($res)) {
$tgsampai = $bar->tanggalsampai;
$tgmulai = $bar->tanggalmulai;
}
if ($tgmulai == '' || $tgsampai == '') {
exit("Error: Periode akuntasi tidak terdaftar");
}
#2 output pada jurnal kolom noreferensi ALK_KERJA_AB
$group = 'VHC1';
#ambil akun alokasi
$str = "select noakundebet from " . $dbname . ".keu_5parameterjurnal\r\n where jurnalid='" . $group . "' limit 1";
$res = mysql_query($str);
if (mysql_num_rows($res) < 1) {
exit("Error: No.Akun pada parameterjurnal belum ada untuk VHC1");
} else {
$bar = mysql_fetch_object($res);
$akunalok = $bar->noakundebet;
}
#3 ambil semua lokasi kegiatan
$str = "select sum(a.jumlah) as jlh,a.alokasibiaya,b.noakun,a.kodesegment from " . $dbname . ".vhc_rundt a\r\n left join " . $dbname . ".vhc_kegiatan b on a.jenispekerjaan=b.kodekegiatan\r\n left join " . $dbname . ".vhc_runht c on a.notransaksi=c.notransaksi \r\n where c.kodevhc='" . $param['kodevhc'] . "'\r\n and c.tanggal>='" . $tgmulai . "' and c.tanggal <='" . $tgsampai . "' and alokasibiaya!='' \r\n and jenispekerjaan!='' \r\n group by jenispekerjaan,noakun,alokasibiaya,kodesegment";
// if($param['kodevhc']=='B9530XR'){
// echo "Error".$str;exit();
// }
$res = mysql_query($str);
//echo mysql_error($conn);
$lokasi = array();
$biaya = array();
$jam = array();
$akun = array();
$kodeasset = array();
$segment = array();
$ttl = 0;
while ($bar = mysql_fetch_object($res)) {
#kusus jika project
if (substr($bar->alokasibiaya, 0, 2) == 'AK' or substr($bar->alokasibiaya, 0, 2) == 'PB') {
#ambil akun aktiva dalam konstruksi
$tipeasset = substr($bar->alokasibiaya, 3, 3);
$tipeasset = str_replace("0", "", $tipeasset);
$str1 = "select akunak from " . $dbname . ".sdm_5tipeasset where kodetipe='" . $tipeasset . "'";
$res1 = mysql_query($str1);
if (mysql_num_rows($res1) < 1) {
exit(" Error: Akun aktiva dalam konstruksi untuk " . $tipeasset . " beum disetting dari keuangan->setup->tipeasset");
} else {
while ($bar1 = mysql_fetch_object($res1)) {
if ($bar1->akunak == '') {
exit(" Error: Akun aktiva dalam konstruksi untuk " . $tipeasset . " beum disetting dari keuangan->setup->tipeasset");
} else {
$akun[] = $bar1->akunak;
}
}
$kodeasset[] = $bar->alokasibiaya;
$lokasi[] = $bar->alokasibiaya;
$jam[] = $bar->jlh;
$biaya[] = $bar->jlh * $param['jumlah'];
$kegiatan[] = '';
$segment[] = $bar->kodesegment;
}
} else {
$lokasi[] = $bar->alokasibiaya;
$akun[] = $bar->noakun;
$jam[] = $bar->jlh;
$biaya[] = $bar->jlh * $param['jumlah'];
$kegiatan[] = $bar->noakun . "01";
$kodeasset[] = '';
$segment[] = $bar->kodesegment;
}
}
// foreach ($jam as $key=>$val)
// {
// $biaya[$key] =$val*$param['jumlah'];
// }
foreach ($biaya as $key => $nilai) {
#periksa unit
$dataRes['header'] = array();
$dataRes['detail'] = array();
$intern = true;
$pengguna = substr($lokasi[$key], 0, 4);
if (substr($lokasi[$key], 0, 2) == 'AK' or substr($lokasi[$key], 0, 2) == 'PB') {
#khusus project
$str = "select kodeorg from " . $dbname . ".project where kode='" . $lokasi[$key] . "'";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$pengguna = $bar->kodeorg;
$lokasi[$key] = '';
}
}
#ambil piutang ke pengguna
$str = "select akunpiutang,jenis from " . $dbname . ".keu_5caco where kodeorg='" . $pengguna . "'";
$res = mysql_query($str);
$intraco = '';
$interco = '';
while ($bar = mysql_fetch_object($res)) {
if ($bar->jenis == 'intra') {
$intraco = $bar->akunpiutang;
} else {
$interco = $bar->akunpiutang;
}
}
#++++++++++++++++++++++++++++++++++++++
$akunpekerjaan = $akun[$key];
#++++++++++++++++++++++++++++++++++++++++
$ptpengguna = '';
$str = "select induk from " . $dbname . ".organisasi where kodeorganisasi='" . $pengguna . "'";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$ptpengguna = $bar->induk;
}
$ptGudang = '';
$str = "select induk from " . $dbname . ".organisasi where kodeorganisasi='" . $_SESSION['empl']['lokasitugas'] . "'";
$res = mysql_query($str);
while ($bar = mysql_fetch_object($res)) {
$ptGudang = $bar->induk;
}
#jika pt tidak sama maka pakai akun interco
$akunpengguna = '';
if ($ptGudang != $ptpengguna) {
#ambil akun interco
$intern = false;
$str = "select akunhutang from " . $dbname . ".keu_5caco where kodeorg='" . $_SESSION['empl']['lokasitugas'] . "' and jenis='inter'";
$res = mysql_query($str);
$akunpengguna = '';
while ($bar = mysql_fetch_object($res)) {
$akunpengguna = $bar->akunhutang;
}
$akunsendiri = $interco;
if ($akunpengguna == '') {
exit("Error: Akun intraco atau interco belum ada untuk unit " . $pengguna);
}
} else {
if ($pengguna != $_SESSION['empl']['lokasitugas']) {
#jika satu pt beda kebun
#ambil akun intraco
$intern = false;
$str = "select akunhutang from " . $dbname . ".keu_5caco where kodeorg='" . $_SESSION['empl']['lokasitugas'] . "' and jenis='intra'";
$res = mysql_query($str);
$akunpengguna = '';
while ($bar = mysql_fetch_object($res)) {
$akunpengguna = $bar->akunhutang;
}
$akunsendiri = $intraco;
if ($akunpengguna == '') {
exit("Error: Akun intraco atau interco belum ada untuk unit " . $pengguna);
}
} else {
$intern = true;
}
}
if ($intern) {
#proses data
$kodeJurnal = $group;
#======================== Nomor Jurnal =============================
# Get Journal Counter
$queryJ = selectQuery($dbname, 'keu_5kelompokjurnal', 'nokounter', "kodeorg='" . $_SESSION['org']['kodeorganisasi'] . "' and kodekelompok='" . $kodeJurnal . "' ");
$tmpKonter = fetchData($queryJ);
$konter = addZero($tmpKonter[0]['nokounter'] + 1, 3);
# Transform No Jurnal dari No Transaksi
$nojurnal = str_replace("-", "", $tanggal) . "/" . $_SESSION['empl']['lokasitugas'] . "/" . $kodeJurnal . "/" . $konter;
#======================== /Nomor Jurnal ============================
# Prep Header
$dataRes['header'] = array('nojurnal' => $nojurnal, 'kodejurnal' => $kodeJurnal, 'tanggal' => $tanggal, 'tanggalentry' => date('Ymd'), 'posting' => 1, 'totaldebet' => $biaya[$key], 'totalkredit' => -1 * $biaya[$key], 'amountkoreksi' => '0', 'noreferensi' => 'ALK_KERJA_AB', 'autojurnal' => '1', 'matauang' => 'IDR', 'kurs' => '1', 'revisi' => '0');
# Data Detail
$noUrut = 1;
# Debet
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => $tanggal, 'nourut' => $noUrut, 'noakun' => $akunpekerjaan, 'keterangan' => $param['periode'] . ':Biaya Kendaraan ' . $param['kodevhc'], 'jumlah' => $biaya[$key], 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $_SESSION['empl']['lokasitugas'], 'kodekegiatan' => $kegiatan[$key], 'kodeasset' => $kodeasset[$key], 'kodebarang' => '', 'nik' => 0, 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'ALK_KERJA_AB', 'noaruskas' => '', 'kodevhc' => $param['kodevhc'], 'nodok' => '', 'kodeblok' => $lokasi[$key], 'revisi' => '0', 'kodesegment' => $segment[$key]);
$noUrut++;
# Kredit
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => $tanggal, 'nourut' => $noUrut, 'noakun' => $akunalok, 'keterangan' => $param['periode'] . ':Alokasi biaya kend' . $param['kodevhc'], 'jumlah' => -1 * $biaya[$key], 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $_SESSION['empl']['lokasitugas'], 'kodekegiatan' => $kegiatan[$key], 'kodeasset' => '', 'kodebarang' => '', 'nik' => '0', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'ALK_KERJA_AB', 'noaruskas' => '', 'kodevhc' => $param['kodevhc'], 'nodok' => '', 'kodeblok' => $lokasi[$key], 'revisi' => '0', 'kodesegment' => $segment[$key]);
$noUrut++;
$insHead = insertQuery($dbname, 'keu_jurnalht', $dataRes['header']);
if (!mysql_query($insHead)) {
$headErr .= 'Insert Header Intern Error : ' . mysql_error() . "\n";
}
if (empty($headErr)) {
#>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Insert Detail
$detailErr = '';
foreach ($dataRes['detail'] as $row) {
$insDet = insertQuery($dbname, 'keu_jurnaldt', $row);
if (!mysql_query($insDet)) {
$detailErr .= "Insert Detail Intern Error : " . mysql_error() . "\n";
break;
}
}
if ($detailErr == '') {
# Header and Detail inserted
#>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Update Kode Jurnal
$updJurnal = updateQuery($dbname, 'keu_5kelompokjurnal', array('nokounter' => $konter), "kodeorg='" . $_SESSION['org']['kodeorganisasi'] . "' and kodekelompok='" . $kodeJurnal . "'");
if (!mysql_query($updJurnal)) {
echo "Update Kode Jurnal Error : " . mysql_error() . "\n";
# Rollback if Update Failed
$RBDet = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal . "'");
if (!mysql_query($RBDet)) {
echo "Rollback Delete Header Error : " . mysql_error() . "\n";
exit;
}
exit;
} else {
}
} else {
echo $detailErr;
# Rollback, Delete Header
$RBDet = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal . "'");
if (!mysql_query($RBDet)) {
echo "Rollback Delete Header Error : " . mysql_error();
exit;
}
}
} else {
echo $headErr;
exit;
}
} else {
# Data Detail
$noUrut = 1;
#proses data
$kodeJurnal = $group;
#======================== Nomor Jurnal =============================
# Get Journal Counter
$queryJ = selectQuery($dbname, 'keu_5kelompokjurnal', 'nokounter', "kodeorg='" . $_SESSION['org']['kodeorganisasi'] . "' and kodekelompok='" . $kodeJurnal . "' ");
$tmpKonter = fetchData($queryJ);
$konter = addZero($tmpKonter[0]['nokounter'] + 1, 3);
# Transform No Jurnal dari No Transaksi
$nojurnal = str_replace("-", "", $tanggal) . "/" . $_SESSION['empl']['lokasitugas'] . "/" . $kodeJurnal . "/" . $konter;
#======================== /Nomor Jurnal ============================
# Prep Header
$dataRes['header'] = array('nojurnal' => $nojurnal, 'kodejurnal' => $kodeJurnal, 'tanggal' => $tanggal, 'tanggalentry' => date('Ymd'), 'posting' => 1, 'totaldebet' => $biaya[$key], 'totalkredit' => -1 * $biaya[$key], 'amountkoreksi' => '0', 'noreferensi' => 'ALK_KERJA_AB', 'autojurnal' => '1', 'matauang' => 'IDR', 'kurs' => '1', 'revisi' => '0');
# Debet
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => $tanggal, 'nourut' => $noUrut, 'noakun' => $akunsendiri, 'keterangan' => $param['periode'] . ':Biaya Kendaraan ' . $param['kodevhc'], 'jumlah' => $biaya[$key], 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $_SESSION['empl']['lokasitugas'], 'kodekegiatan' => $kegiatan[$key], 'kodeasset' => '', 'kodebarang' => '', 'nik' => '0', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'ALK_KERJA_AB', 'noaruskas' => '', 'kodevhc' => $param['kodevhc'], 'nodok' => '', 'kodeblok' => '', 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
# Kredit
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => $tanggal, 'nourut' => $noUrut, 'noakun' => $akunalok, 'keterangan' => $param['periode'] . ':Alokasi biaya kend' . $param['kodevhc'], 'jumlah' => -1 * $biaya[$key], 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $_SESSION['empl']['lokasitugas'], 'kodekegiatan' => $kegiatan[$key], 'kodeasset' => '', 'kodebarang' => '', 'nik' => '0', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'ALK_KERJA_AB', 'noaruskas' => '', 'kodevhc' => $param['kodevhc'], 'nodok' => '', 'kodeblok' => '', 'revisi' => '0', 'kodesegment' => $defSegment);
$noUrut++;
$insHead = insertQuery($dbname, 'keu_jurnalht', $dataRes['header']);
if (!mysql_query($insHead)) {
$headErr .= 'Insert Header Ex.Self Error : ' . mysql_error() . "\n";
}
if (empty($headErr)) {
#>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Insert Detail
$detailErr = '';
foreach ($dataRes['detail'] as $row) {
$insDet = insertQuery($dbname, 'keu_jurnaldt', $row);
if (!mysql_query($insDet)) {
$detailErr .= "Insert Detail Ex.Self Error : " . mysql_error() . "\n";
break;
}
}
if ($detailErr == '') {
# Header and Detail inserted
#>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Update Kode Jurnal
$updJurnal = updateQuery($dbname, 'keu_5kelompokjurnal', array('nokounter' => $konter), "kodeorg='" . $_SESSION['org']['kodeorganisasi'] . "' and kodekelompok='" . $kodeJurnal . "'");
if (!mysql_query($updJurnal)) {
echo "Update Kode Jurnal Error : " . mysql_error() . "\n";
# Rollback if Update Failed
$RBDet = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal . "'");
if (!mysql_query($RBDet)) {
echo "Rollback Delete Header Error : " . mysql_error() . "\n";
exit;
}
exit;
} else {
}
} else {
echo $detailErr;
# Rollback, Delete Header
$RBDet = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal . "'");
if (!mysql_query($RBDet)) {
echo "Rollback Delete Header Error : " . mysql_error();
exit;
}
}
} else {
echo $headErr;
exit;
}
#+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
#sisi Pengguna
$kodeJurnal = $group;
#ambil periodeaktif pengguna
// $strd="select tanggalmulai,tanggalsampai from ".$dbname.".setup_periodeakuntansi where
// kodeorg='".$pengguna."' and tutupbuku=0";
//
// $resd=mysql_query($strd);
// $tgmulaid='';
// while($bard=mysql_fetch_object($resd))
// {
// $tgmulaid = $bard->tanggalmulai;
// }
// if($tgmulaid=='' or substr($tgmulaid,0,7)==substr($tanggal,0,7))#jika periode sama maka biarkan
$tgmulaid = $tanggal;
#======================== Nomor Jurnal =============================
# Get Journal Counter
$queryJ = selectQuery($dbname, 'keu_5kelompokjurnal', 'nokounter', "kodeorg='" . $ptpengguna . "' and kodekelompok='" . $kodeJurnal . "' ");
$tmpKonter = fetchData($queryJ);
$konter = addZero($tmpKonter[0]['nokounter'] + 1, 3);
# Transform No Jurnal dari No Transaksi
$nojurnal = str_replace("-", "", $tgmulaid) . "/" . $pengguna . "/" . $kodeJurnal . "/" . $konter;
#======================== /Nomor Jurnal ============================
# Prep Header
unset($dataRes['header']);
//ganti header
$dataRes['header'] = array('nojurnal' => $nojurnal, 'kodejurnal' => $kodeJurnal, 'tanggal' => $tgmulaid, 'tanggalentry' => date('Ymd'), 'posting' => 1, 'totaldebet' => $biaya[$key], 'totalkredit' => -1 * $biaya[$key], 'amountkoreksi' => '0', 'noreferensi' => 'ALK_KERJA_AB', 'autojurnal' => '1', 'matauang' => 'IDR', 'kurs' => '1', 'revisi' => '0');
//print_r($dataRes['header']);
//exit("Error");
# Debet 1
$noUrut = 1;
unset($dataRes['detail']);
//ganti header
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => $tgmulaid, 'nourut' => $noUrut, 'noakun' => $akunpekerjaan, 'keterangan' => $param['periode'] . ':Biaya Kendaraan ' . $param['kodevhc'], 'jumlah' => $biaya[$key], 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $pengguna, 'kodekegiatan' => $kegiatan[$key], 'kodeasset' => $kodeasset[$key], 'kodebarang' => '', 'nik' => '0', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'ALK_KERJA_AB', 'noaruskas' => '', 'kodevhc' => $param['kodevhc'], 'nodok' => '', 'kodeblok' => $lokasi[$key], 'revisi' => '0', 'kodesegment' => $segment[$key]);
$noUrut++;
# Kredit 1
$dataRes['detail'][] = array('nojurnal' => $nojurnal, 'tanggal' => $tgmulaid, 'nourut' => $noUrut, 'noakun' => $akunpengguna, 'keterangan' => $param['periode'] . ':Alokasi biaya kend' . $param['kodevhc'], 'jumlah' => -1 * $biaya[$key], 'matauang' => 'IDR', 'kurs' => '1', 'kodeorg' => $pengguna, 'kodekegiatan' => $kegiatan[$key], 'kodeasset' => '', 'kodebarang' => '', 'nik' => '0', 'kodecustomer' => '', 'kodesupplier' => '', 'noreferensi' => 'ALK_KERJA_AB', 'noaruskas' => '', 'kodevhc' => $param['kodevhc'], 'nodok' => '', 'kodeblok' => $lokasi[$key], 'revisi' => '0', 'kodesegment' => $segment[$key]);
$noUrut++;
$insHead = insertQuery($dbname, 'keu_jurnalht', $dataRes['header']);
if (!mysql_query($insHead)) {
$headErr .= 'Insert Header OSIDE Error : ' . mysql_error() . "\n";
}
if (empty($headErr)) {
#>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Insert Detail
$detailErr = '';
foreach ($dataRes['detail'] as $row) {
$insDet = insertQuery($dbname, 'keu_jurnaldt', $row);
if (!mysql_query($insDet)) {
$detailErr .= "Insert Detail OSIDE Error : " . mysql_error() . "\n" . $insDet;
break;
}
}
if ($detailErr == '') {
# Header and Detail inserted
#>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Update Kode Jurnal
$updJurnal = updateQuery($dbname, 'keu_5kelompokjurnal', array('nokounter' => $konter), "kodeorg='" . $ptpengguna . "' and kodekelompok='" . $kodeJurnal . "'");
if (!mysql_query($updJurnal)) {
echo "Update Kode Jurnal Error : " . mysql_error() . "\n";
# Rollback if Update Failed
$RBDet = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal . "'");
if (!mysql_query($RBDet)) {
echo "Rollback Delete Header Error : " . mysql_error() . "\n";
exit;
}
exit;
} else {
}
} else {
echo $detailErr;
# Rollback, Delete Header
$RBDet = deleteQuery($dbname, 'keu_jurnalht', "nojurnal='" . $nojurnal . "'");
if (!mysql_query($RBDet)) {
echo "Rollback Delete Header Error : " . mysql_error();
exit;
}
}
} else {
echo $headErr;
exit;
}
}
}
}
function Header()
{
global $conn;
global $dbname;
global $align;
global $length;
global $colArr;
global $title;
global $kdUnit;
global $kdBatch;
global $rData;
global $optNm;
# Alamat & No Telp
$query = selectQuery($dbname, 'organisasi', 'alamat,telepon', "kodeorganisasi='" . $_SESSION['org']['kodeorganisasi'] . "'");
$orgData = fetchData($query);
$width = $this->w - $this->lMargin - $this->rMargin;
$height = 15;
$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', 'B', 12);
// $this->Cell((20/100*$width)-5,$height,$_SESSION['lang']['laporanKendAb'],'',0,'L');
// $this->Ln();
$this->SetFont('Arial', '', 8);
$this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['unit'], '', 0, 'L');
$this->Cell(5, $height, ':', '', 0, 'L');
$this->Cell(45 / 100 * $width, $height, $optNm[$kdUnit], '', 0, 'L');
$this->Ln();
if ($kdBatch == '') {
$kdBatchdt = $_SESSION['lang']['all'];
} else {
$kdBatchdt = $kdBatch;
}
$this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['batch'], '', 0, 'L');
$this->Cell(5, $height, ':', '', 0, 'L');
$this->Cell(45 / 100 * $width, $height, $kdBatchdt, '', 0, 'L');
$this->Ln();
$this->SetFont('Arial', 'U', 12);
$this->Cell($width, $height, $_SESSION['lang']['laporanStockBIbit'], 0, 1, 'C');
$this->Ln();
$this->SetFont('Arial', 'B', 7);
$this->SetFillColor(220, 220, 220);
$this->Cell(3 / 100 * $width, $height, 'No', 1, 0, 'C', 1);
$this->Cell(8 / 100 * $width, $height, $_SESSION['lang']['batch'], 1, 0, 'C', 1);
$this->Cell(17 / 100 * $width, $height, $_SESSION['lang']['kodeorg'], 1, 0, 'C', 1);
$this->Cell(8 / 100 * $width, $height, $_SESSION['lang']['saldo'], 1, 0, 'C', 1);
$this->Cell(11 / 100 * $width, $height, $_SESSION['lang']['jenisbibit'], 1, 0, 'C', 1);
$this->Cell(8 / 100 * $width, $height, $_SESSION['lang']['tgltanam'] . " " . substr($_SESSION['lang']['afkirbibit'], 5), 1, 0, 'C', 1);
$this->Cell(8 / 100 * $width, $height, $_SESSION['lang']['umur'], 1, 1, 'C', 1);
}
foreach ($absResq as $rowq => $karq) {
if (count($periksa[$karq['karyawanid']]) < $jumlahh) {
$nx++;
$kotak .= $nx . "." . $karq['namakaryawan'] . "-" . $karq['subbagian'] . "\n";
}
}
if ($kotak != '') {
exit("Error:[ENG] There are absences that have not been recorded in the name of the following employees:" . "\n[IND] Masih ada karyawan yang belum memiliki absen (selain PHL)\n\n " . $kotak);
}
}
#end periksa absensi===========================================================================
#2 Get Jamsostek porsi==========================
#ambil semua komponen dari gajipokok khusus KHT dan Kontrak Harian=====================
$str1 = "select a.*,b.namakaryawan from " . $dbname . ".sdm_5gajipokok a left join \r\n " . $dbname . ".datakaryawan b on a.karyawanid=b.karyawanid\r\n where a.tahun=" . substr($tanggal1, 0, 4) . " and b.tipekaryawan in(2,3,6,4) and b.lokasitugas='" . $param['kodeorg'] . "' \r\n and (b.tanggalkeluar>='" . $tanggal1 . "' or b.tanggalkeluar='0000-00-00') and b.alokasi=0 \r\n and sistemgaji='Harian'";
$res1 = fetchData($str1);
$query6 = selectQuery($dbname, 'sdm_ho_hr_jms_porsi', 'value', "id='karyawan'");
$jmsRes = fetchData($query6);
$persenJms = $jmsRes[0]['value'] / 100;
$tjms = array();
foreach ($res1 as $idx => $val) {
#KHT dan Kontrak Harian
if ($id[$val['karyawanid']][0] == $val['karyawanid'] and ($tipekaryawan[$val['karyawanid']] == 'KHT' or $tipekaryawan[$val['karyawanid']] == 'Kontrak' or $tipekaryawan[$val['karyawanid']] == 'Kontrak Karya')) {
// #kurangkan pemotongan HK tidak dibayar
// if (array_key_exists($val['karyawanid'], $tdkdibayar)){
// if($val['idkomponen']=='1')#kurangkan hanya pada gaji pokok
// $val['jumlah']=$val['jumlah']-$tdkdibayar[$val['karyawanid']];#pengurangan HK tidak dibayar
// }
//Khusus KHT dan Kontrak harian tidak lagi dipotong pada gaji pokok, tetapi ditambah pada potongan HK diatas
//==============================================================================================================================
//filter jumlah hari
if ($val['idkomponen'] == 1 and $jumlahh > $pengurang) {
<?php
require_once 'master_validation.php';
require_once 'config/connection.php';
require_once 'lib/nangkoelib.php';
include_once 'lib/zMysql.php';
$pt = $_GET['pt'];
$periode = $_GET['periode'];
/* print"<pre>";
print_r($_GET);
print"<pre>";*/
//======================================
//ambil namapt
$query2 = selectQuery($dbname, 'organisasi', 'namaorganisasi', "kodeorganisasi='" . $pt . "'");
$orgData2 = fetchData($query2);
//echo"warning:masuk vvv";
if (strlen($pt) < 6) {
$kdOrg = "substr(b.blok,1,4)";
} else {
$kdOrg = "substr(b.blok,1,6)";
}
$strx = "select a.tanggal,b.* from " . $dbname . ".kebun_spbht a inner join " . $dbname . ".kebun_spbdt b on a.nospb=b.nospb \r\n\t\twhere a.tanggal like '%" . $periode . "%' and " . $kdOrg . "='" . $pt . "' order by a.tanggal asc ";
// echo"warning:".$strx;exit();
$stream = "\r\n\t\t\t<table>\r\n\t\t\t<tr><td colspan=11 align=center>" . $_SESSION['lang']['listSpb'] . "</td></tr>\r\n\t\t\t<tr><td colspan=3>" . $_SESSION['lang']['periode'] . ":" . $periode . "</td></tr>\r\n\t\t\t<tr><td colspan=3>" . $_SESSION['lang']['unit'] . ":" . $orgData2[0]['namaorganisasi'] . "</td></tr>\r\n\t\t\t<tr><td colspan=3> </td></tr>\r\n\t\t\t</table>\r\n\t\t\t<table border=1>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<td bgcolor=#DEDEDE align=center>No.</td>\r\n\t\t\t\t\t\t\t<td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['nospb'] . "</td>\r\n\t\t\t\t\t\t\t<td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['tanggal'] . "</td>\r\n\t\t\t\t\t\t\t<td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['blok'] . "</td>\r\n\t\t\t\t\t\t\t<td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['janjang'] . "</td>\r\n <td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['kgwb'] . "</td>\r\n\t\t\t\t\t\t\t<td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['bjr'] . "</td>\t\r\n\t\t\t\t\t\t\t<td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['brondolan'] . "</td>\t\r\n\t\t\t\t\t\t\t<td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['mentah'] . "</td>\t\r\n\t\t\t\t\t\t\t<td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['busuk'] . "</td>\t\r\n\t\t\t\t\t\t\t<td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['matang'] . "</td>\t\r\n\t\t\t\t\t\t\t<td bgcolor=#DEDEDE align=center>" . $_SESSION['lang']['lewatmatang'] . "</td>\t\r\n\t\t\t\t\t\t</tr>";
$resx = mysql_query($strx);
$row = mysql_fetch_row($resx);
if ($row < 1) {
$stream .= "\t<tr class=rowcontent>\r\n\t\t\t<td colspan=11 align=center>Not Found</td></tr>\r\n\t\t\t";
} else {
$no = 0;
$resx = mysql_query($strx);
function Header()
{
global $kodeorg;
global $thnbudget;
global $lebar1;
global $lebar2;
global $lebar3;
global $lebar4;
global $lebar5;
global $lebar6;
global $dbname;
global $kgolah;
global $jenis;
global $kgoil;
global $kgkernel;
global $kgcpo;
# 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(10 / 100 * $width - 5, $height, $_SESSION['lang']['produksi'] . " PP", '', 0, 'L');
$this->Cell(5, $height, ':', '', 0, 'L');
$this->Cell(8 / 100 * $width, $height, number_format($kgoil / 1000 . 'Ton', 0, ".", ","), '', 0, 'R');
$this->Cell(52 / 100 * $width, $height, '', '', 0, 'L');
$this->Cell(10 / 100 * $width - 5, $height, 'Printed By', '', 0, 'L');
$this->Cell(5, $height, ':', '', 0, 'L');
$this->Cell(15 / 100 * $width, $height, $_SESSION['empl']['name'], '', 1, 'L');
$this->Cell(10 / 100 * $width - 5, $height, $_SESSION['lang']['produksi'] . " CPO", '', 0, 'L');
$this->Cell(5, $height, ':', '', 0, 'L');
$this->Cell(8 / 100 * $width, $height, number_format($kgcpo / 1000 . 'Ton', 0, ".", ","), '', 0, 'R');
$this->Cell(52 / 100 * $width, '', '', 0, 'L');
$this->Cell(10 / 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(10 / 100 * $width - 5, $height, $_SESSION['lang']['produksi'] . " KER", '', 0, 'L');
$this->Cell(5, $height, ':', '', 0, 'L');
$this->Cell(8 / 100 * $width, $height, number_format($kgkernel / 1000 . 'Ton', 0, ".", ","), '', 1, 'R');
$this->Cell(10 / 100 * $width - 5, $height, 'TBS', '', 0, 'L');
$this->Cell(5, $height, ':', '', 0, 'L');
$this->Cell(8 / 100 * $width, $height, number_format($kgolah / 1000 . 'Ton', 0, ".", ","), '', 0, 'R');
$title = "BUDGET BIAYA " . $jenis . " PKS " . $kodeorg . " " . $thnbudget;
$this->Ln();
$this->SetFont('Arial', 'U', 10);
$this->Cell($width, $height, $title, 0, 1, 'C');
$this->Ln();
$this->SetFont('Arial', '', 9);
$this->SetFillColor(220, 220, 220);
$this->Cell($lebar1 / 100 * $width, $height, $_SESSION['lang']['nourut'], 1, 0, 'C', 1);
$this->Cell($lebar2 / 100 * $width, $height, $_SESSION['lang']['noakun'], 1, 0, 'C', 1);
$this->Cell($lebar3 / 100 * $width, $height, $_SESSION['lang']['namaakun'], 1, 0, 'C', 1);
$this->Cell($lebar4 / 100 * $width, $height, $_SESSION['lang']['jumlahrp'], 1, 0, 'C', 1);
$this->Cell($lebar5 / 100 * $width, $height, $_SESSION['lang']['rpperkg'], 1, 0, 'C', 1);
for ($i = 1; $i <= 12; $i++) {
if (strlen($i) == 1) {
$ii = "0" . $i;
} else {
$ii = $i;
}
if ($i != 12) {
$this->Cell($lebar6 / 100 * $width, $height, $ii . '(Rp)', 1, 0, 'C', 1);
} else {
$this->Cell($lebar6 / 100 * $width, $height, $ii . '(Rp)', 1, 1, 'C', 1);
}
}
}
function FindQuestionByQuestionType($questionType)
{
include_once 'sqlQuery.php';
$query = "select * from question\n where QuestionType = '{$questionType}'";
return selectQuery($query);
}
function Header()
{
global $conn;
global $dbname;
global $align;
global $length;
global $colArr;
global $title;
global $period;
global $periode;
global $kdOrg;
global $kdeOrg;
global $tgl1;
global $tgl2;
global $where;
global $jmlHari;
global $test;
global $nmOrg;
global $pilihan;
global $pilihan2;
$jmlHari = $jmlHari * 1.5;
$cols = 247.5;
# Alamat & No Telp
$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 * 4, $this->lMargin + $width, $this->tMargin + $height * 4);
$this->Ln();
$this->SetFont('Arial', 'B', 10);
$this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['laporanLembur'] . " (dalam " . $pilihan . ") " . $pilihan2, '', 0, 'L');
$this->Ln();
$this->Cell($width, $height, strtoupper("Rekapitulasi Lembur Karyawan") . " : " . $nmOrg, '', 0, 'C');
$this->Ln();
$this->Cell($width, $height, strtoupper($_SESSION['lang']['periode']) . " :" . tanggalnormal($tgl1) . " s.d. " . tanggalnormal($tgl2), '', 0, 'C');
$this->Ln();
$this->SetFont('Arial', 'B', 7);
$this->SetFillColor(220, 220, 220);
$this->Cell(2 / 100 * $width, $height, 'No', 1, 0, 'C', 1);
$this->Cell(5 / 100 * $width, $height, $_SESSION['lang']['nama'], 1, 0, 'C', 1);
$this->Cell(5 / 100 * $width, $height, $_SESSION['lang']['jabatan'], 1, 0, 'C', 1);
$this->Cell(5 / 100 * $width, $height, $_SESSION['lang']['bagian'], 1, 0, 'C', 1);
foreach ($test as $ar => $isi) {
$this->Cell(2.6 / 100 * $width, $height, substr($isi, 8, 2), 1, 0, 'C', 1);
$akhirX = $this->GetX();
}
$this->SetY($this->GetY());
$this->SetX($akhirX);
$this->Cell(4 / 100 * $width, $height, $_SESSION['lang']['jumlah'], 1, 1, 'C', 1);
}
$arrAsset[$bar->tipeasset]['kode'] = 'DEP' . substr($bar->tipeasset, 0, 2);
}
$poolAsset = array();
foreach ($arrAsset as $row) {
$poolAsset[$row['kode']] = $row['nilai'];
}
// Get List Akun dari Parameter Jurnal = 'DEP'
$optDep = makeOption($dbname, 'keu_5parameterjurnal', "jurnalid,noakunkredit", "kodeaplikasi='DEP'");
// Get Jurnal
foreach ($poolAsset as $kode => $nilai) {
// No Jurnal
$konter = '001';
$tanggal = $param['periode'] . "-28";
# Transform No Jurnal dari No Transaksi
$nojurnal = str_replace("-", "", $tanggal) . "/" . substr($param['kodeorg'], 0, 4) . "/" . $kode . "/" . $konter;
$qJurnal = selectQuery($dbname, 'keu_jurnaldt', "jumlah", "nojurnal='" . $nojurnal . "' and noakun='" . $optDep[$kode] . "'");
$resJurnal = fetchData($qJurnal);
if (empty($resJurnal)) {
exit("Warning: Depresiasi " . $kode . " belum terjurnal dengan benar");
} else {
if ($resJurnal[0]['jumlah'] + round($nilai, 2) > 0.01) {
exit("Warning: Depresiasi " . $kode . " belum terjurnal dengan benar");
}
}
}
#==================== /Prep Jurnal ====================================
createSaldoAwal($param['periode'], $tahunLanjut . '-' . addZero($bulanLanjut, 2), $param['kodeorg']);
#========================== Proses Insert dan Update ==========================
# Header and Detail inserted
# Update Status Tutup Buku
$queryUpd = updateQuery($dbname, 'setup_periodeakuntansi', array('tutupbuku' => 1), "kodeorg='" . $param['kodeorg'] . "' and periode='" . $param['periode'] . "'");
$primary .= "</table>";
$content = array();
# Setting drop down options
$optTopografi = makeOption($dbname, 'setup_topografi', 'topografi,keterangan');
$optTipeAng = getEnum($dbname, 'setup_kegiatannorma', 'tipeanggaran');
# Get Nama Barang
$whereNB = "";
foreach ($listInv as $key => $row) {
if ($key == 0) {
$whereNB .= "kodebarang=" . $row;
} else {
$whereNB .= " or kodebarang=" . $row;
}
}
if ($whereNB != "") {
$query = selectQuery($dbname, 'log_5masterbarang', 'kodebarang,namabarang,satuan', $whereNB);
$resBar = fetchData($query);
$namaBarang = array();
$satuanBarang = array();
foreach ($resBar as $row) {
$namaBarang[$row['kodebarang']] = $row['namabarang'];
$satuanBarang[$row['kodebarang']] = $row['satuan'];
}
}
# Masking Nama Barang
foreach ($data as $key => $row) {
$data[$key]['namabarang'] = $namaBarang[$row['kodebarang']];
}
# Editable Row
$j = 0;
if ($data != array()) {
function Header()
{
global $conn;
global $dbname;
global $align;
global $length;
global $colArr;
global $title;
global $jmlHari;
global $test;
global $klmpkAbsn;
global $tglDari;
global $tglSmp;
$cols = 247.5;
# Alamat & No Telp
$query = selectQuery($dbname, 'organisasi', 'alamat,telepon', "kodeorganisasi='" . $_SESSION['org']['kodeorganisasi'] . "'");
$orgData = fetchData($query);
$width = $this->w - $this->lMargin - $this->rMargin;
$height = 15;
$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', 'B', 10);
$this->Cell($width, $height, strtoupper("Payroll Remise I"), '', 0, 'C');
$this->Ln();
$this->Cell($width, $height, strtoupper($_SESSION['lang']['tanggal']) . " :" . tanggalnormal($tglDari) . " " . $_SESSION['lang']['sampai'] . " " . tanggalnormal($tglSmp), '', 0, 'C');
$this->Ln();
$this->Ln();
$this->SetFont('Arial', 'B', 6);
$this->SetFillColor(220, 220, 220);
$this->Cell(3 / 100 * $width, $height, 'No', 1, 0, 'C', 1);
$this->Cell(13 / 100 * $width, $height, $_SESSION['lang']['namakaryawan'], 1, 0, 'C', 1);
$this->Cell(7 / 100 * $width, $height, $_SESSION['lang']['tipekaryawan'], 1, 0, 'C', 1);
$this->Cell(10 / 100 * $width, $height, $_SESSION['lang']['gaji'], 1, 0, 'C', 1);
foreach ($test as $ar => $isi) {
$this->Cell(1.5 / 100 * $width, $height, substr($isi, 8, 2), 1, 0, 'C', 1);
$akhirX = $this->GetX();
}
$this->SetY($this->GetY());
$this->SetX($akhirX);
$sAbsen = "select kodeabsen from " . $dbname . ".sdm_5absensi order by kodeabsen";
$qAbsen = mysql_query($sAbsen) or die(mysql_error());
while ($rAbsen = mysql_fetch_assoc($qAbsen)) {
$this->Cell(2 / 100 * $width, $height, $rAbsen['kodeabsen'], 1, 0, 'C', 1);
}
$this->Cell(5 / 100 * $width, $height, $_SESSION['lang']['total'], 1, 1, 'C', 1);
}
function Header()
{
global $conn;
global $dbname;
global $align;
global $length;
global $colArr;
global $title;
global $period;
global $periode;
global $kdOrg;
global $kdeOrg;
global $tgl1;
global $tgl2;
global $where;
global $jmlHari;
global $test;
global $klmpkAbsn;
$jmlHari = $jmlHari * 1.5;
$cols = 247.5;
# Alamat & No Telp
$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 * 4, $this->lMargin + $width, $this->tMargin + $height * 4);
$this->Ln();
$this->SetFont('Arial', 'B', 10);
$this->Cell(20 / 100 * $width - 5, $height, $_SESSION['lang']['rkpAbsen'], '', 0, 'L');
$this->Ln();
$this->Ln();
$this->Cell($width, $height, strtoupper("Rekapitulasi Absensi Karyawan"), '', 0, 'C');
$this->Ln();
$this->Cell($width, $height, strtoupper($_SESSION['lang']['periode']) . " :" . tanggalnormal($tgl1) . " s.d. " . tanggalnormal($tgl2), '', 0, 'C');
$this->Ln();
$this->Ln();
$this->SetFont('Arial', 'B', 7);
$this->SetFillColor(220, 220, 220);
$this->Cell(3 / 100 * $width, $height, 'No', 1, 0, 'C', 1);
$this->Cell(13 / 100 * $width, $height, $_SESSION['lang']['nama'], 1, 0, 'C', 1);
$this->Cell(10 / 100 * $width, $height, $_SESSION['lang']['jabatan'], 1, 0, 'C', 1);
//$this->Cell($jmlHari/100*$width,$height-10,$_SESSION['lang']['tanggal'],1,0,'C',1);
$this->GetX();
$this->SetY($this->GetY());
$this->SetX($this->GetX() + $cols);
foreach ($test as $ar => $isi) {
$this->Cell(1.5 / 100 * $width, $height, substr($isi, 8, 2), 1, 0, 'C', 1);
//$cols+=1.5;
//$this->SetX($this->GetX()+$cols);
//$akhir=$this->SetX($this->GetX()+$cols);
$akhirX = $this->GetX();
}
$this->SetY($this->GetY());
$this->SetX($akhirX);
$sAbsen = "select kodeabsen from " . $dbname . ".sdm_5absensi order by kodeabsen";
$qAbsen = mysql_query($sAbsen) or die(mysql_error());
while ($rAbsen = mysql_fetch_assoc($qAbsen)) {
$klmpkAbsn[] = $rAbsen;
$this->Cell(2 / 100 * $width, $height, $rAbsen['kodeabsen'], 1, 0, 'C', 1);
}
$this->Cell(5 / 100 * $width, $height, $_SESSION['lang']['jumlah'], 1, 1, 'C', 1);
}
<?php
session_start();
include 'function_DB.php';
if (isset($_POST['eleId']) && isset($_SESSION['product_reg']['SectionS_PPID'])) {
$result["secSUploadsList"] = selectQuery("SELECT ppa_attachment,ppa_tkh_upd,ppa_attachment_rename,ppa_kod,ppa_pp_kod FROM p_product_attach WHERE ppa_rf_kod in (SELECT rpaf_kod FROM ref_product_attachment_field WHERE rpaf_formid='" . $_POST['eleId'] . "' ) AND ppa_pbs_kod=" . $_SESSION['product_reg']['SectionS_PPID']);
if ($_POST['eleId'] == "Certificate_Suitability_SectionS") {
$result["CSSBtnsHtml"] = "<div class=\"col-xs-2 btn-group\">\n\t\t\t\t\t<button type=\"button\" class=\"btn btn-sm btn-primary btn-block\" id=\"" . $_POST['eleId'] . "View\" disabled>View</button>\n\t\t\t\t</div>";
if (isset($result["secSUploadsList"])) {
if (count($result["secSUploadsList"]) == 1) {
$qPpa_Kod = 0;
$qPpaAttchRn = "";
foreach ($result["secSUploadsList"] as $currUpl) {
$qPpa_Kod = $currUpl["ppa_kod"];
$qPpaAttchRn = $currUpl["ppa_attachment_rename"];
}
$result["CSSBtnsHtml"] = "\n\t\t\t\t\t\t<div class=\"col-xs-2 btn-group\">\n\t\t\t\t\t\t\t<button type=\"button\" class=\"btn btn-sm btn-primary btn-block\" id=\"" . $_POST['eleId'] . "View\" onclick=\"window.open('" . $basePath . "product_reg/uploadFile/" . $qPpaAttchRn . "')\">View</button>\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\n\t\t";
}
}
}
echo json_encode($result);
}
<?php
include_once 'master_validation.php';
include_once 'lib/nangkoelib.php';
include_once 'lib/zLib.php';
include_once 'lib/formTable.php';
include_once 'lib/zPdfMaster.php';
$proses = $_GET['proses'];
$param = $_POST;
/** Report Prep **/
$where = null;
$cols = 'nosj,kodept,tanggal,tanggalkirim,tanggaltiba';
$colArr = explode(',', $cols);
$query = selectQuery($dbname, 'log_suratjalanht', $cols, $where, 'nosj desc');
$data = fetchData($query);
$title = "Delivery Order";
$align = explode(",", "L,L,L,L,L");
$length = explode(",", "20,20,20,20,20");
/** Output Format **/
switch ($proses) {
case 'pdf':
$pdf = new zPdfMaster('P', 'pt', 'A4');
$pdf->setAttr1($title, $align, $length, $colArr);
$width = $pdf->w - $pdf->lMargin - $pdf->rMargin;
$height = 12;
$pdf->AddPage();
$pdf->SetFillColor(255, 255, 255);
$pdf->SetFont('Arial', '', 9);
foreach ($data as $key => $row) {
$i = 0;
foreach ($row as $cont) {
