<?//@Copy nangkoelframework

require_once('master_validation.php');

include_once('lib/nangkoelib.php');

include_once('lib/zLib.php');

include_once('lib/rTable.php');

$proses = $_GET['proses'];

$param = $_POST;

switch($proses) {

# Daftar Header

case 'showHeadList':

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

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

$where = "";

if(!empty($arrWhere)) {

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

if($key==0) {

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

} else {

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

}

}

} else {

$where = null;

}

} else {

$where = null;

}

# Header

$header = array(

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

$_SESSION['lang']['namalaporan'],

$_SESSION['lang']['periode'],

$_SESSION['lang']['ket1']

);

# Content

$cols = "kodeorg,namalaporan,periode,ket1";

$query = selectQuery($dbname,'keu_5mesinlaporanht',$cols,$where,"",false,$param['shows'],$param['page']);

$data = fetchData($query);

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

# Make Table

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

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

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

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

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

$tHeader->setWhere($arrWhere);

}

# View

$tHeader->renderTable();

break;

# Form Add Header

case 'showAdd':

// View

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

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

break;

# Form Edit Header

case 'showEdit':

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

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

$data = fetchData($query);

echo formHeader('edit',$data[0]);

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

break;

# Proses Add Header

case 'add':

$data = $_POST;

// Error Trap

$warning = "";

if($data['namalaporan']=='') {$warning .= "Nama Laporan harus diisi\n";}

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

$cols = array('kodeorg','namalaporan','periode','ket1',

'ket2','ket3','ket4','ket5','ket6');

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

if(!mysql_query($query)) {

echo "DB Error : ".mysql_error();

}

break;

# Proses Edit Header

case 'edit':

$data = $_POST;

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

unset($data['kodeorg']);

unset($data['namalaporan']);

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

if(!mysql_query($query)) {

echo "DB Error : ".mysql_error();

}

break;

case 'delete':

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

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

if(!mysql_query($query)) {

echo "DB Error : ".mysql_error();

exit;

}

break;

default:

break;

}

function formHeader($mode,$data) {

}

?>