function transaksiSubmit()
{
$data = Input::all();
$schedule = Rentschedule::findRentschedule($data['RENT_SCHEDULE_ID'])->first();
unset($data['_token']);
$schedule_id = $data['RENT_SCHEDULE_ID'];
unset($data['RENT_SCHEDULE_ID']);
$costumer = $data;
$data['RENT_TRANSACTION_PRICE'] = $schedule['RENT_SCHEDULE_PRICE'];
unset($data['_token']);
$data['RENT_TRANSACTION_DATE'] = date('y-m-d');
$data['RENT_TRANSACTION_CREATEBY'] = Session::get('id');
unset($data['COSTUMER_EMAIL'], $data['COSTUMER_NAME'], $data['COSTUMER_TELP']);
$data['RENT_TRANSACTION_PRICE'] = Session::get('duration');
if (!is_null(Session::get('id')) and Session::get('hak') == 'COSTUMER') {
$data['MEMBER_ID'] = Session::get('id');
} else {
Costumer::insert($costumer);
$id = DB::getPdo()->lastInsertId();
$data['COSTUMER_ID'] = $id;
}
Renttransaction::insert($data);
$detail_transaksi = ['RENT_TRANSACTION_ID' => DB::getPdo()->lastInsertId(), 'RENT_SCHEDULE_ID' => $schedule_id];
Renttransactiondetail::insert($detail_transaksi);
return redirect::to('/');
}
function getTransaksi()
{
$transaksi = Renttransaction::getAllTransaction()->join('RENT_SCHEDULE', 'RENT_SCHEDULE.RENT_SCHEDULE_ID', '=', 'RENT_TRANSACTION.RENT_SCHEDULE_ID')->join('VEHICLE', 'VEHICLE.VEHICLE_ID', '=', 'RENT_SCHEDULE.VEHICLE_ID')->where('VEHICLE.PARTNER_ID', '=', Session::get('id'));
return Datatables::of($transaksi)->addColumn('action', function ($transaksi) {
return '<button class="btn btn-xs btn-primary" id="' . $transaksi->RENT_TRANSACTION_ID . '"><i class="fa fa-pencil"></i></button>';
})->make(true);
}
function editStatus()
{
$data = Input::all();
unset($data['_token']);
$transaction = Renttransaction::findTransaction($data['RENT_TRANSACTION_ID']);
$data['RENT_TRANSACTION_UPDATE'] = date('y-m-d H:i:s');
print_r($data);
$transaction->update($data);
return back();
}