Notes

<?php
namespace PdpSyncronizepdp;

use PdpSyncronizepdpSyncpdp;
use PdpKasirTransaksikasir;
use PdpKasirgoelaTransaksikasirgoela;
use PdpKawasanFotokawasan;
use PdpTransaksitiketTiketkawasan;
use PdpTransaksitiketTiketmuseum;
use PdpParkirImportparkir;
use PdpParkirImportparkirdetail;
use PdpUmkmTransaksikasirtenant;
use PdpUmkmTransaksikasirtenantdetail;
use FncMasterMappingPdpparkirsinkron;
use PdpSyncronizepdpJurnalpdp;

use Input;
use DB;

class SyncpdpController extends BasicController {

public function __construct(){
// $this->model = new AnggaranSpd();
$this->user=Session::get('userNameAdmin');
$this->userlong=Session::get('userNameAdminLong');

}

public function index(){
if($this->user != '' || $this->userlong != ''){

$param = Input::all();

return View::make('Pdp.Syncronizepdp.index', [
'name' => $this->user,
'namelong' => $this->userlong,
'code' => 0,
]);
}else{
$wallidx=rand(1,7);
$data = array(
'wallidx' => $wallidx,
'message' => 'Session Habis',
);
return View::make('login',$data);
}
}

public function getBesali($tawal,$takhir){
if($this->user != '' || $this->userlong != ''){
$res = Transaksikasir::select('*',
DB::Raw('IF(trkasirBayar = 1, "Cash",
IF(trkasirBayar = 2, "Edc",
IF(trkasirBayar = 3, "Traveloka",
IF(trkasirBayar = 4, "Transfer",
IF(trkasirBayar = 5, "Lain-Lain",
""))))) as payment'),
DB::Raw('IF(trkasirNoTrace = "", "-",
IF(trkasirNoTrace = 0, "-",
trkasirNoTrace)) as noTrace')
)
->where('trkasirAprov','=',2)
->where('trkasirDraft','=',0)
->where(function($q) use($tawal,$takhir){
$q->where('trkasirDate','>=',$tawal)
->where('trkasirDate','<=',$takhir);
})->get();

return $res;
}else{
$wallidx=rand(1,7);
$data = array(
'wallidx' => $wallidx,
'message' => 'Session Habis',
);
return View::make('login',$data);
}
}

public function draftBesali(){
if($this->user != '' || $this->userlong != ''){
$param = Input::all();
$row = !empty($param['besali']) ? $param['besali'] : 0;
if ($row != 0) {
// return $tgawal;
for ($i = 1; $i < count($row); $i++) {

$val = new Syncpdp();
$val->dpKategori = $param['kat'.$row[$i]];
$val->dpKodeJurnal = 40911;//ini kode masih uji coba
$val->dpTglDraft = date("Y-m-d H:i:s");
$val->dpKode = $param['trkasirKode'.$row[$i]];
$val->dpTgl = $param['trkasirDate'.$row[$i]];
$val->dpShift = $param['trkasirUserName'.$row[$i]];
$val->dpTotal = $param['trkasirTotal'.$row[$i]];
$val->dpMBayar = $param['trkasirBayar'.$row[$i]];
$val->dpMNoTrace = $param['trkasirNoTrace'.$row[$i]];
$val->save();

DB::table('pdp_trkasir')
->where('trkasirKode', $param['trkasirKode'.$row[$i]])
->where('trkasirDate', $param['trkasirDate'.$row[$i]])
->update([
'trkasirDraft' => 1
]);
}

}
return $param;
}else{
$wallidx=rand(1,7);
$data = array(
'wallidx' => $wallidx,
'message' => 'Session Habis',
);
return View::make('login',$data);
}
}

public function getGoela($tawal,$takhir){
if($this->user != '' || $this->userlong != ''){
$res = Transaksikasirgoela::select('*',
DB::Raw('IF(trkasirBayar = 1, "Cash",
IF(trkasirBayar = 2, "Edc",
IF(trkasirBayar = 3, "Traveloka",
IF(trkasirBayar = 4, "Transfer",
IF(trkasirBayar = 5, "Lain-Lain",
""))))) as payment'),
DB::Raw('IF(trkasirNoTrace = "", "-",
IF(trkasirNoTrace = 0, "-",
trkasirNoTrace)) as noTrace')
)
->where('trkasirApprove','=',2)
->where('trkasirDraft','=',0)
->where(function($q) use($tawal,$takhir){
$q->where('trkasirDate','>=',$tawal)
->where('trkasirDate','<=',$takhir);
})->get();

return $res;
}else{
$wallidx=rand(1,7);
$data = array(
'wallidx' => $wallidx,
'message' => 'Session Habis',
);
return View::make('login',$data);
}
}

public function draftGoela(){
if($this->user != '' || $this->userlong != ''){
$param = Input::all();
$row = !empty($param['goela']) ? $param['goela'] : 0;
if ($row != 0) {
// return $tgawal;
for ($i = 1; $i < count($row); $i++) {

$val = new Syncpdp();
$val->dpKategori = $param['kat'.$row[$i]];
$val->dpTglDraft = date("Y-m-d H:i:s");
$val->dpKode = $param['trkasirKode'.$row[$i]];
$val->dpTgl = $param['trkasirDate'.$row[$i]];
$val->dpShift = $param['trkasirUserName'.$row[$i]];
$val->dpTotal = $param['trkasirTotal'.$row[$i]];
$val->dpMBayar = $param['trkasirBayar'.$row[$i]];
$val->dpMNoTrace = $param['trkasirNoTrace'.$row[$i]];
$val->save();

DB::table('pdp_trkasir_goela')
->where('trkasirKode', $param['trkasirKode'.$row[$i]])
->where('trkasirDate', $param['trkasirDate'.$row[$i]])
->update([
'trkasirDraft' => 1
]);
}

}
return $param;
}else{
$wallidx=rand(1,7);
$data = array(
'wallidx' => $wallidx,
'message' => 'Session Habis',
);
return View::make('login',$data);
}
}

public function getFotokawasan($tawal,$takhir){
if($this->user != '' || $this->userlong != ''){
$res = Fotokawasan::select('*',
DB::Raw('IF(ftBayar = 1, "Cash",
IF(ftBayar = 2, "Edc",
IF(ftBayar = 3, "Traveloka",
IF(ftBayar = 4, "Transfer",
IF(ftBayar = 5, "Lain-Lain",
""))))) as payment'),
DB::Raw('IF(ftKategori = 1, "Foto Prewedding",
IF(ftKategori = 2, "Foto Buku Kenangan",
IF(ftKategori = 3, "Foto Produk / Katalog",
IF(ftKategori = 4, "Foto Compliment",
IF(ftKategori = 5, "Take Video < 8 Jam",
IF(ftKategori = 5, "Take Video > 8 Jam",
"")))))) as kategori')
)
->where('ftDraft','=',0)
->where(function($q) use($tawal,$takhir){
$q->where('ftTglDaftar','>=',$tawal)
->where('ftTglDaftar','<=',$takhir);
})->get();

return $res;
}else{
$wallidx=rand(1,7);
$data = array(
'wallidx' => $wallidx,
'message' => 'Session Habis',
);
return View::make('login',$data);
}
}

public function draftFotokawasan(){
if($this->user != '' || $this->userlong != ''){
$param = Input::all();
$row = !empty($param['fotokawasan']) ? $param['fotokawasan'] : 0;
if ($row != 0) {
// return $tgawal;
for ($i = 1; $i < count($row); $i++) {

$val = new Syncpdp();
$val->dpKategori = $param['kat'.$row[$i]];
$val->dpTglDraft = date("Y-m-d H:i:s");
$val->dpKode = $param['ftNoForm'.$row[$i]];
$val->dpTgl = $param['ftTglDaftar'.$row[$i]];
$val->dpNmPenyewa = $param['ftNamaPenyewa'.$row[$i]];
$val->dpKatFoto = $param['ftKategori'.$row[$i]];
$val->dpTotal = $param['ftHarga'.$row[$i]];
$val->dpTotalExt = $param['ftDurExtand'.$row[$i]];
$val->dpMBayar = $param['ftBayar'.$row[$i]];
$val->save();

DB::table('pdp_trfotokawasan')
->where('ftNoForm', $param['ftNoForm'.$row[$i]])
->where('ftTglDaftar', $param['ftTglDaftar'.$row[$i]])
->update([
'ftDraft' => 1
]);
}

}
return $param;
}else{
$wallidx=rand(1,7);
$data = array(
'wallidx' => $wallidx,
'message' => 'Session Habis',
);
return View::make('login',$data);
}
}

public function getKawasan($tawal,$takhir){
if($this->user != '' || $this->userlong != ''){
$res = Tiketkawasan::select('*',
DB::Raw('SUM(trkJumTarif)-SUM(trkKompensasi) as totalsisa'),
DB::Raw('IF(trkBayar = 1, "Cash",
IF(trkBayar = 2, "Edc",
IF(trkBayar = 3, "Traveloka",
IF(trkBayar = 4, "Transfer",
IF(trkBayar = 5, "Lain-Lain",
""))))) as payment'),
DB::Raw('IF(trkTrace = null, "-",
IF(trkTrace = 0, "-",
trkTrace)) as noTrace')
)
->where('trkApproval','=',2)
->where('trkDraft','=',0)
->where(function($q) use($tawal,$takhir){
$q->where('trkDate','>=',$tawal)
->where('trkDate','<=',$takhir);
})->groupBy('trkId')->get();

return $res;
}else{
$wallidx=rand(1,7);
$data = array(
'wallidx' => $wallidx,
'message' => 'Session Habis',
);
return View::make('login',$data);
}
}

public function draftKawasan(){
if($this->user != '' || $this->userlong != ''){
$param = Input::all();
$row = !empty($param['kawasan']) ? $param['kawasan'] : 0;
if ($row != 0) {
// return $tgawal;
for ($i = 1; $i < count($row); $i++) {

$val = new Syncpdp();
$val->dpKategori = $param['kat'.$row[$i]];
$val->dpTglDraft = date("Y-m-d H:i:s");
$val->dpKode = $param['trkTiket'.$row[$i]];
$val->dpTgl = $param['trkDate'.$row[$i]];
$val->dpTotal = $param['trkJumTarif'.$row[$i]];
$val->dpMBayar = $param['trkBayar'.$row[$i]];
$val->dpMNoTrace = $param['trkTrace'.$row[$i]];
$val->save();

DB::table('pdp_trkawasan')
->where('trkTiket', $param['trkTiket'.$row[$i]])
->where('trkDate', $param['trkDate'.$row[$i]])
->update([
'trkDraft' => 1
]);
}

}
return $param;
}else{
$wallidx=rand(1,7);
$data = array(
'wallidx' => $wallidx,
'message' => 'Session Habis',
);
return View::make('login',$data);
}
}

public function getMuseum($tawal,$takhir){
if($this->user != '' || $this->userlong != ''){
$res = Tiketmuseum::select('*',
DB::Raw('SUM(trmTotalSeluruh)+SUM(trmPotongan)+SUM(trmTarifDp) as akhir'),
DB::Raw('IF(trmBayar = 1, "Cash",
IF(trmBayar = 2, "Edc",
IF(trmBayar = 3, "Traveloka",
IF(trmBayar = 4, "Transfer",
IF(trmBayar = 5, "Lain-Lain",
""))))) as payment'),
DB::Raw('IF(trmTrace = null, "-",
IF(trmTrace = 0, "-",
trmTrace)) as noTrace')
)
->where('trmApproval','=',2)
->where('trmDraft','=',0)
->where(function($q) use($tawal,$takhir){
$q->where('trmDate','>=',$tawal)
->where('trmDate','<=',$takhir);
})->groupBy('trmId')->get();

return $res;
}else{
$wallidx=rand(1,7);
$data = array(
'wallidx' => $wallidx,
'message' => 'Session Habis',
);
return View::make('login',$data);
}
}

public function draftMuseum(){
if($this->user != '' || $this->userlong != ''){
$param = Input::all();
$row = !empty($param['museum']) ? $param['museum'] : 0;
if ($row != 0) {
// return $tgawal;
for ($i = 1; $i < count($row); $i++) {

$val = new Syncpdp();
$val->dpKategori = $param['kat'.$row[$i]];
$val->dpTglDraft = date("Y-m-d H:i:s");
$val->dpKode = $param['trmTiket'.$row[$i]];
$val->dpTgl = $param['trmDate'.$row[$i]];
$val->dpTotal = $param['trmJumTarif'.$row[$i]];
$val->dpMBayar = $param['trmBayar'.$row[$i]];
$val->dpMNoTrace = $param['trmTrace'.$row[$i]];
$val->save();

DB::table('pdp_trmuseum')
->where('trmTiket', $param['trmTiket'.$row[$i]])
->where('trmDate', $param['trmDate'.$row[$i]])
->update([
'trmDraft' => 1
]);
}

}
return $param;
}else{
$wallidx=rand(1,7);
$data = array(
'wallidx' => $wallidx,
'message' => 'Session Habis',
);
return View::make('login',$data);
}
}

public function getParkir($tawal,$takhir){
if($this->user != '' || $this->userlong != ''){

$query = Importparkir::select('*',DB::Raw('SUM(pkTotal) as total'))
->where(function($q) use($tawal,$takhir){
$q->where('pkTgl','>=',$tawal)
->where('pkTgl','<=',$takhir);
})->groupBy('pkTgl')->get();



DB::table('pdp_tr_Prasinkron')
->where('psinTglAwal', '>=', $tawal)
->where('psinTglAwal', '<=', $takhir)
->delete();

DB::table('pdp_jurnaltemp')
->where('jurKategori', '=', 6)
->where('jurTanggal', '>=', $tawal)
->where('jurTanggal', '<=', $takhir)
->delete();

foreach ($query as $key => $val) {

$id = $val->pkId;
$total = $val->total;
$tgl = $val->pkTgl;

DB::table('pdp_tr_Prasinkron')
->insert([
'psinKategori' => 6,
'psinTglAwal' => $tgl,
'psinTanggal' => date("Y-m-d H:i:s"),
'psinTotal' => $total
]);


//JURNAL START
$idprasinkron = DB::table('pdp_tr_Prasinkron')->select('psinId')->orderBy('psinId','DESC')->first();

$getcoa=Pdpparkirsinkron::select('*')
->get();

foreach($getcoa as $key2 => $val2){

$idcoa = $val2->juId;
$kdasal= $val2->juKodeCoa;
$kddebet= $val2->juDebitCoa;
$nmdebet= $val2->juNmDebitCoa;
$kdkredit= $val2->juKreditCoa;
$nmkredit= $val2->juNmKreditCoa;

DB::table('pdp_jurnaltemp')
->insert([
'jurKategori' => 6,
'jurNama' => 'Tiket Parkir',
'jurHeadId' => $idprasinkron->psinId,
'jurTanggal' => $tgl,
'jurAsal' => $kdasal,
'jurDebet' => $kddebet,
'jurDebetNm' => $nmdebet,
'jurNilaiDebet' => $total,
'jurKredit' => ' ',
'jurKreditNm' => ' ',
'jurNilaiKredit' => 0,

]);


}

//JURNAL END

}

$res = DB::table('pdp_tr_Prasinkron')->select('*')
->where('psinKategori','=',6)
->where(function($q) use($tawal,$takhir){
$q->where('psinTglAwal', '>=', $tawal)
->where('psinTglAwal', '<=', $takhir);
})
->groupBy('psinId')
->get();



return $res;

}else{
$wallidx=rand(1,7);
$data = array(
'wallidx' => $wallidx,
'message' => 'Session Habis',
);
return View::make('login',$data);
}
}

public function draftParkir(){
if($this->user != '' || $this->userlong != ''){
$param = Input::all();
$row = !empty($param['parkir']) ? $param['parkir'] : 0;
if ($row != 0) {
// return $tgawal;
for ($i = 1; $i < count($row); $i++) {

$val = new Syncpdp();
$val->dpKategori = $param['kat'.$row[$i]];
$val->dpTglDraft = date("Y-m-d H:i:s");
$val->dpHeadId = $param['psinId'.$row[$i]];
$val->dpTgl = $param['psinTglAwal'.$row[$i]];
$val->dpTotal = $param['psinTotal'.$row[$i]];
$val->dpKategoriNama= "Tiket Parkir";

$val->save();

DB::table('pdp_tr_importdata')
->where('pkId', $param['psinId'.$row[$i]])
->where('pkTgl', $param['psinTglAwal'.$row[$i]])
->update([
'pkDraft' => 1
]);
}

}
return $param;
}else{
$wallidx=rand(1,7);
$data = array(
'wallidx' => $wallidx,
'message' => 'Session Habis',
);
return View::make('login',$data);
}
}

public function getUmkm($tawal,$takhir){
if($this->user != '' || $this->userlong != ''){
$res = Transaksikasirtenant::select('*',
DB::Raw('IF(trkasirBayar = 1, "Cash",
IF(trkasirBayar = 2, "Edc",
IF(trkasirBayar = 3, "Traveloka",
IF(trkasirBayar = 4, "Transfer",
IF(trkasirBayar = 5, "Lain-Lain",
""))))) as payment'),
DB::Raw('IF(trkasirNoTrace = "", "-",
IF(trkasirNoTrace = 0, "-",
trkasirNoTrace)) as noTrace')
)
->where('trkasirAprov','=',2)
->where('trkasirDraft','=',0)
->where(function($q) use($tawal,$takhir){
$q->where('trkasirDate','>=',$tawal)
->where('trkasirDate','<=',$takhir);
})->get();

return $res;
}else{
$wallidx=rand(1,7);
$data = array(
'wallidx' => $wallidx,
'message' => 'Session Habis',
);
return View::make('login',$data);
}
}

public function draftUmkm(){
if($this->user != '' || $this->userlong != ''){
$param = Input::all();
$row = !empty($param['umkm']) ? $param['umkm'] : 0;
if ($row != 0) {
// return $tgawal;
for ($i = 1; $i < count($row); $i++) {

$val = new Syncpdp();
$val->dpKategori = $param['kat'.$row[$i]];
// $val->dpKodeJurnal = 40911;//ini kode masih uji coba
$val->dpTglDraft = date("Y-m-d H:i:s");
$val->dpKode = $param['trkasirKode'.$row[$i]];
$val->dpTgl = $param['trkasirDate'.$row[$i]];
$val->dpShift = $param['trkasirUserName'.$row[$i]];
$val->dpTotal = $param['trkasirTotal'.$row[$i]];
$val->dpMBayar = $param['trkasirBayar'.$row[$i]];
$val->dpMNoTrace = $param['trkasirNoTrace'.$row[$i]];
$val->save();

DB::table('pdp_trkasir_tenant')
->where('trkasirKode', $param['trkasirKode'.$row[$i]])
->where('trkasirDate', $param['trkasirDate'.$row[$i]])
->update([
'trkasirDraft' => 1
]);
}

}
return $param;
}else{
$wallidx=rand(1,7);
$data = array(
'wallidx' => $wallidx,
'message' => 'Session Habis',
);
return View::make('login',$data);
}
}

//COA
public function getCoa($id,$kat){
if($this->user != '' || $this->userlong != ''){



if($kat == 1){
$kelompok = 'BESALI';
$jurAsal = 'Besali';
}
elseif($kat == 2){
$kelompok = 'KEDAI GOELA';
$jurAsal = 'Kedai Goela';
}
elseif($kat == 3){
$kelompok = 'FOTO KAWASAN';
$jurAsal = 'Foto Kawasan';
}
elseif($kat == 4){
$kelompok = 'TIKET KAWASAN';
$jurAsal = 'Tiket Kawasan';
}
elseif($kat == 5){
$kelompok = 'TIKET MUSEUM';
$jurAsal = 'Tiket Museum';
}
elseif($kat == 6){
$kelompok = 'TIKET PARKIR';
$jurAsal = 'Tiket Parkir';
}

$namajurnal = DB::table('pdp_tr_Prasinkron')->select('psinTglAwal as revNoLapor', 'psinTglAwal as revTanggal')->where('psinId','=',$id)->where('psinKategori','=',$kat)->get();

// if($kat==6){
// $namajurnal = Importparkir::select('pkId as revNoLapor', 'pkTgl as revTanggal')
// ->leftjoin('pdp_tr_importdata_detail','pkId','=','pkhHeadId')->where('pkId','=',$id)->get();
// }else{
// $namajurnal = DB::table('pdp_trkasir')->select('trkasirKode as revNoLapor', 'trkasirDate as revTanggal')
// ->leftjoin('pdp_trkasir_detail','trkasHeadId','=','trkasirId')->where('trkasirId','=',$id)->get();
// }

// $res = DB::table('ast_jurnaltemp')->select('jurId as id','jurDebet as kodedebet','jurNilaiDebet as nilaidebet','jurKredit as kodekredit','jurNilaiKredit as nilaikredit','msjenisNm as namacoadebet',DB::raw('concat("") as namacoakredit'))
// ->leftjoin('fnc_coa_msjenis','msjenisKd','=','jurdebet')
// ->where('jurHeadId','=',$id)
// ->where('jurAsal','=',$jurAsal)
// ->where('jurStatus','=',0)
// ->where('jurNilaiDebet','<>','');

// $res2 = DB::table('ast_jurnaltemp')->select('jurId as id','jurDebet as kodedebet','jurNilaiDebet as nilaidebet','jurKredit as kodekredit','jurNilaiKredit as nilaikredit',DB::raw('concat("") as namacoadebet'),'msjenisNm as namacoakredit')
// ->leftjoin('fnc_coa_msjenis','msjenisKd','=','jurKredit')
// ->where('jurHeadId','=',$id)
// ->where('jurAsal','=',$jurAsal)
// ->where('jurStatus','=',0)
// ->where('jurNilaiKredit','<>',0)
// ->orderby('jurId','asc')
// ->unionall($res)
// ->get();


$res = DB::table('pdp_jurnaltemp')->select('*','jurId as id','jurDebet as kodedebet','jurNilaiDebet as nilaidebet','jurKredit as kodekredit','jurNilaiKredit as nilaikredit', 'jurDebetNm as namacoadebet','jurKreditNm as namacoakredit')
// ->where('jurHeadId','=',$id)
->where('jurHeadId','=',$id)
->where('jurDebet','<>','')
->groupby('jurId')
;

$res2 = DB::table('pdp_jurnaltemp')->select('*','jurId as id','jurDebet as kodedebet','jurNilaiDebet as nilaidebet','jurKredit as kodekredit','jurNilaiKredit as nilaikredit', 'jurDebetNm as namacoadebet','jurKreditNm as namacoakredit')
// ->where('jurHeadId','=',$id)
->where('jurHeadId','=',$id)
->where('jurKredit','<>','')
->groupby('jurId')
->unionall($res)
->get();

$data = array(
'header' => $namajurnal,
'kelompok' => $kelompok,
'data' => $res2,
);

return $data;
}
else{
$wallidx=rand(1,7);
$data = array(
'wallidx' => $wallidx,
'message' => 'Session Habis',
);
return View::make('login',$data);
}
}

public function savejurnal($headid){
if($this->user != '' || $this->userlong != ''){
$param = Input::all();
$row = !empty($param['rowcount']) ? $param['rowcount'] : 0;

$detail = Jurnalpdp::where('jurHeadId', '=', $headid)->delete();

if ($row != 0) {
// return $tgawal;
for ($i = 1; $i < count($row); $i++) {
$val = new Jurnalpdp();
$val->jurHeadId = $param['jurHeadId'.$row[$i]];
$val->jurKategori = $param['jurKategori'.$row[$i]];
$val->jurNama = $param['jurNama'.$row[$i]];
$val->jurTanggal = $param['jurTanggal'.$row[$i]];
$val->jurAsal = $param['jurAsal'.$row[$i]];
$val->jurDebet = $param['jurDebet'.$row[$i]];
$val->jurKredit = $param['jurKredit'.$row[$i]];
$val->jurDebetNm = $param['jurDebetNm'.$row[$i]];
$val->jurKreditNm = $param['jurKreditNm'.$row[$i]];
$val->jurNilaiDebet = $this->convertToDecimal($param['jurNilaiDebet'.$row[$i]]);
$val->jurNilaiKredit = $this->convertToDecimal($param['jurNilaiKredit'.$row[$i]]);
$val->save();
}

}
return $param;
}else{
$wallidx=rand(1,7);
$data = array(
'wallidx' => $wallidx,
'message' => 'Session Habis',
);
return View::make('login',$data);
}
}

public function saveeditjurnal()
{
$param = Input::all();
// return $param;
$val = new Jurnalpdp();

$val->jurHeadId = $param['jurHeadId'];
$val->jurTanggal = $param['jurTanggal'];
$val->jurKategori = $param['jurKat'];
$val->jurDebet = $param['KdDebet'];
$val->jurDebetNm = $param['NmDebet'];
$val->jurKredit = $param['KdKredit'];
$val->jurKreditNm = $param['NmKredit'];


if($param['jurKat']==1){
$val->jurNama = 'Besali';
}elseif($param['jurKat']==2){
$val->jurNama = 'Goela';
}elseif($param['jurKat']==3){
$val->jurNama = 'Foto Kawasan';
}elseif($param['jurKat']==4){
$val->jurNama = 'Tiket Kawasan';
}elseif($param['jurKat']==5){
$val->jurNama = 'Tiket Museum';
}elseif($param['jurKat']==6){
$val->jurNama = 'Tiket Parkir';
}elseif($param['jurKat']==7){
$val->jurNama = 'Tenant Umkm';
}elseif($param['jurKat']==8){
$val->jurNama = 'Pendapatan Listrik';
}elseif($param['jurKat']==9){
$val->jurNama = 'Pendapatan Marketing';
}

// $val->trkasmenCreateUser = $this->user;
$val->save();

// $detail = Transaksikasirtenant2detail::leftjoin('mkt_ms_tenant', 'tId', '=', 'trkasmenKdMenu')->where('trkasmenHeadId', '=', $param['trkasmenHeadId'])->orderby('trkasmenId', 'DESC')->limit(1)->get();

$detail = Jurnalpdp::select('*','jurId as id','jurDebet as kodedebet','jurNilaiDebet as nilaidebet','jurKredit as kodekredit','jurNilaiKredit as nilaikredit','jurDebetNm as namacoadebet','jurKreditNm as namacoakredit')->where('jurKategori','=', $param['jurKat'])->where('jurHeadId','=', $param['jurHeadId'])->orderby('jurId', 'DESC')->limit(1)->get();

return $detail;
}

public function deljurnal($id)
{
if ($this->user != '' || $this->userlong != '') {


$val = Jurnalpdp::findOrFail($id);
$val->delete();
return $val;
// return Redirect::back();

} else {
$wallidx = rand(1, 7);
$data = array(
'wallidx' => $wallidx,
'message' => 'Session Habis',
);
return View::make('login', $data);
}
}

}