<?

//@Copy nangkoelframework

require_once('master_validation.php');

include_once('lib/nangkoelib.php');

include_once('lib/zLib.php');

include_once('lib/zFunction.php');

include_once('lib/rTable.php');

$proses = $_GET['proses'];

$param = $_POST;

switch($proses) {

# Daftar Header

case 'showHeadList':

$kdOrganisasi = $_SESSION['empl']['kodeorganisasi'];

if($_SESSION['empl']['tipelokasitugas']=='HOLDING'){

$where = "length(kodeorg)=4";

}else if($_SESSION['empl']['tipelokasitugas']=='TRAKSI' or

$_SESSION['empl']['tipelokasitugas']=='KANWIL') {

$where = "length(kodeorg)=4 and kodeorg in (select kodeorganisasi from ".$dbname.".organisasi where induk = '".$kdOrganisasi."')";

} else {

$where = "kodeorg='".$_SESSION['empl']['lokasitugas']."'";

}

if(isset($param['where'])) {

$arrWhere = json_decode(str_replace('\\','',$param['where']),true);

if(!empty($arrWhere)) {

foreach($arrWhere as $key=>$r1) {

$where .= " and ".$r1[0]." like '%".$r1[1]."%'";

}

}

}

# Header

$header = array(

$_SESSION['lang']['kodeorg'],

$_SESSION['lang']['notransaksi'],

$_SESSION['lang']['tanggal'],

$_SESSION['lang']['subunit'],

$_SESSION['lang']['koderekanan'],

$_SESSION['lang']['nilaikontrak'],

$_SESSION['lang']['dari'],

$_SESSION['lang']['sampai'],

$_SESSION['lang']['jumlahrealisasi'],

$_SESSION['lang']['status']

);

# Content

$cols = "kodeorg,notransaksi,tanggal,divisi,koderekanan,nilaikontrak,dari,sampai";

$query = selectQuery($dbname,'log_spkht',$cols,$where." order by tanggal desc","",false,$param['shows'],$param['page']);

//exit("Error:".$query);

$data = fetchData($query);

$totalRow = getTotalRow($dbname,'log_spkht',$where);

// Get Ppn Masukan

$qPpn = selectQuery($dbname,'setup_parameterappl','nilai',"kodeaplikasi='TX' and kodeparameter='PPNINV'");

$resPpn = fetchData($qPpn);

$ppn = '%';

if(!empty($resPpn)) $ppn = $resPpn[0]['nilai'];

foreach($data as $key=>$row) {

$data[$key]['tanggal'] = tanggalnormal($row['tanggal']);

$data[$key]['dari'] = tanggalnormal($row['dari']);

$data[$key]['sampai'] = tanggalnormal($row['sampai']);

//=================ambil realisasi

$data[$key]['realisasi'] =0;

$strx="select sum(jumlahrealisasi) from ".$dbname.".log_baspk

where notransaksi='".$data[$key]['notransaksi']."'";

$resx=mysql_query($strx);

while($barx=mysql_fetch_array($resx))

{

$data[$key]['realisasi']= number_format($barx[0]);

}

//lihat postingan-=============================

$data[$key]['status'] ='';

$strx="select statusjurnal from ".$dbname.".log_baspk

where notransaksi='".$data[$key]['notransaksi']."'

and blokspkdt = '".$data[$key]['divisi']."' and statusjurnal=0";

$resx=mysql_query($strx);

if(mysql_num_rows($resx)>0)

$data[$key]['status'] ='?';

else if($data[$key]['realisasi']==0 and $data[$key]['status']=='')

$data[$key]['status'] ='?';

else

$data[$key]['status'] ='Ready for Posting';

//cek postingan spkht

$stru="select posting from ".$dbname.".log_spkht where notransaksi='".$data[$key]['notransaksi']."'";

$resu=mysql_query($stru);

$post=0;

while($baru=mysql_fetch_array($resu))

{

$post=$baru[0];

}

if($post==1)

$data[$key]['status']='Posted';

// Get Pajak

$qPajak = selectQuery($dbname,'log_spk_tax',"noakun,nilai","notransaksi='".

$row['notransaksi']."' and kodeorg='".$row['kodeorg']."'");

$resPajak = fetchData($qPajak);

if(!empty($resPajak)) {

foreach($resPajak as $r) {

if($ppn==$r['noakun']) {

$data[$key]['nilaikontrak'] += $r['nilai'];

} else {

$data[$key]['nilaikontrak'] -= $r['nilai'];

}

}

}

}

# Options

if(!empty($data)) {

$whereSupp = "supplierid in (";

foreach($data as $key=>$row) {

if($key==0) {

$whereSupp .= "'".$row['koderekanan']."'";

} else {

$whereSupp .= ",'".$row['koderekanan']."'";

}

}

$whereSupp .= ")";

} else {

$whereSupp = null;

}

$optSupp = makeOption($dbname,'log_5supplier','supplierid,namasupplier',

$whereSupp);

# Data Show

$dataShow = $data;

foreach($dataShow as $key=>$row) {

$dataShow[$key]['koderekanan'] = isset($optSupp[$row['koderekanan']])? $optSupp[$row['koderekanan']]: '';

$dataShow[$key]['nilaikontrak'] = number_format($row['nilaikontrak'],0);

}

$postJabatan = getPostingJabatan('baspk');

# Make Table

$tHeader = new rTable('headTable','headTableBody',$header,$data,$dataShow);

$tHeader->addAction('showEdit','Edit','images/'.$_SESSION['theme']."/edit.png");

$tHeader->addAction('deleteData','Delete','images/'.$_SESSION['theme']."/delete.png");

$tHeader->addAction('postingData','Posting','images/'.$_SESSION['theme']."/posting.png");

$tHeader->_actions[2]->setAltImg('images/'.$_SESSION['theme']."/posted.png");

if($_SESSION['empl']['tipelokasitugas']!='HOLDING'){

if(!in_array($_SESSION['empl']['kodejabatan'],$postJabatan)) {

$tHeader->_actions[2]->_name='';

}

}

$tHeader->addAction('detailPDF','Print Data Detail','images/'.$_SESSION['theme']."/pdf.jpg");

$tHeader->_actions[3]->addAttr('event');

$tHeader->_switchException = array('detailPDF');

$tHeader->pageSetting($param['page'],$totalRow,$param['shows']);

if(isset($param['where'])) {

$tHeader->setWhere($arrWhere);

}

# View

$tHeader->renderTable();

break;

# Form Add Header

case 'showAdd':

// View

echo formHeader('add',array());

echo "<div id='detailField' style='clear:both'></div>";

break;

# Form Edit Header

case 'showEdit':

// Data Header

$where = "notransaksi='".$param['notransaksi']."' and kodeorg='".$param['kodeorg']."'";

$query = selectQuery($dbname,'log_spkht',"*",$where);

$tmpData = fetchData($query);

$data = $tmpData[0];

$data['tanggal'] = tanggalnormal($data['tanggal']);

$data['dari'] = tanggalnormal($data['dari']);

$data['sampai'] = tanggalnormal($data['sampai']);

// Data Pajak

$qTax = selectQuery($dbname,'log_spk_tax',"*",$where);

$resTax = fetchData($qTax);

$data['tax'] = array();

foreach($resTax as $row) {

$data['tax'][$row['noakun']] = $row['nilai'];

}

echo formHeader('edit',$data);

echo "<div id='detailField' style='clear:both'></div>";

break;

# Proses Add Header

case 'add':

$data = $_POST;

// Error Trap

$warning = "";

if($data['notransaksi']=='') {$warning .= "No SPK harus diisi\n";}

if($data['tanggal']=='') {$warning .= "Tanggal harus diisi\n";}

if($data['kodeorg']=='') {$warning = "Lokasi Tugas harus Kebun\n";}

if($warning!=''){echo "Warning :\n".$warning;exit;}

$data['tanggal'] = tanggalsystem($data['tanggal']);

$data['dari'] = tanggalsystem($data['dari']);

$data['sampai'] = tanggalsystem($data['sampai']);

$data['nilaikontrak'] = str_replace(',','',$data['nilaikontrak']);

$data['matauang'] = $data['matauang'];

$data['ppnnilaikontrak'] = '0';

unset($data['tax']);

if(empty($data['dari'])) $data['dari'] = '0000-00-00';

if(empty($data['sampai'])) $data['sampai'] = '0000-00-00';

$cols = array('kodeorg','notransaksi','tanggal','divisi',

'koderekanan','nilaikontrak','dari','sampai','keterangan','matauang','ppnnilaikontrak');

$query = insertQuery($dbname,'log_spkht',$data,$cols);

//exit("Error:".$query);

if(!mysql_query($query)) {

echo "DB Error : ".mysql_error();

} else {

// Insert Detail Pajak

$dataIns = array();

foreach($param['tax'] as $akun=>$nilai) {

if($nilai > 0) {

$dataIns[] = array(

'kodeorg' => $param['kodeorg'],

'notransaksi' => $param['notransaksi'],

'noakun' => $akun,

'nilai' => $nilai

);

}

}

if(!empty($dataIns)) {

$qIns = insertQuery($dbname,'log_spk_tax',$dataIns);

if(!mysql_query($qIns)) {

exit("Insert Tax Error: ".mysql_error());

}

}

}

break;

# Proses Edit Header

case 'edit':

$data = $_POST;

$where = "notransaksi='".$data['notransaksi']."'";

unset($data['notransaksi']);

$data['tanggal'] = tanggalsystem($data['tanggal']);

$data['dari'] = tanggalsystem($data['dari']);

$data['sampai'] = tanggalsystem($data['sampai']);

$data['nilaikontrak'] = str_replace(',','',$data['nilaikontrak']);

$data['matauang'] = $data['matauang'];

$data['ppnnilaikontrak'] = '0';

unset($data['tax']);

$query = updateQuery($dbname,'log_spkht',$data,$where);

//exit("Error:".$query);

if(!mysql_query($query)) {

echo "DB Error : ".mysql_error();

} else {

// Delete Pajak

$qDel = deleteQuery($dbname,'log_spk_tax',

"notransaksi='".$param['notransaksi']."'");

if(!mysql_query($qDel)) {

exit("Delete Tax Error: ".mysql_error());

} else {

// Insert Detail Pajak

$dataIns = array();print_r($param);

foreach($param['tax'] as $akun=>$nilai) {

if($nilai > 0) {

$dataIns[] = array(

'kodeorg' => $param['kodeorg'],

'notransaksi' => $param['notransaksi'],

'noakun' => $akun,

'nilai' => $nilai

);

}

}

$qIns = insertQuery($dbname,'log_spk_tax',$dataIns);echo $qIns;

if(!mysql_query($qIns)) {

exit("Insert Tax Error: ".mysql_error());

}

}

}

break;

case 'delete':

//================periksa realisasi

$m =0;

$strx="select sum(jumlahrealisasi) from ".$dbname.".log_baspk

where notransaksi='".$param['notransaksi']."' and statusjurnal = '1'";

$resx=mysql_query($strx);

while($barx=mysql_fetch_array($resx))

{

$m= $barx[0];

}

//lihat postingan-=============================

$n ='';

$strx="select statusjurnal from ".$dbname.".log_baspk

where notransaksi='".$param['notransaksi']."' and statusjurnal=0";

$resx=mysql_query($strx);

if(mysql_num_rows($resx)>0)

$n ='?';

if($n=='' and $m==0)

{

//=================================

$where = "notransaksi='".$param['notransaksi']."'";

$query = "delete from `".$dbname."`.`log_spkht` where ".$where;

if(!mysql_query($query)) {

echo "DB Error : ".mysql_error();

exit;

}

}

else

{

exit('Error:Realisasi sudah terisi');

}

break;

case 'updSub':

$whereDiv = "induk='".$param['kodeorg']."' or kodeorganisasi='".

$param['kodeorg']."'";

$optDiv = makeOption($dbname,'organisasi','kodeorganisasi,namaorganisasi',$whereDiv);

#tambahkan dari project=================================================================

//$str="select kode,nama from ".$dbname.".project where kodeorg='".$_SESSION['empl']['lokasitugas']."' and posting=0";

//$res=mysql_query($str);

//while($bar=mysql_fetch_object($res))

//{

// $optDiv[$bar->kode]="[Project]-".$bar->nama;

//}

$optDiv[''] = "Project";

#===================================================================================

echo json_encode($optDiv);

break;

default:

break;

}

function formHeader($mode,$data) {

}

?>