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(); }