本文整理匯總了PHP中app\City::whereRaw方法的典型用法代碼示例。如果您正苦於以下問題：PHP City::whereRaw方法的具體用法？PHP City::whereRaw怎麽用？PHP City::whereRaw使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類app\City的用法示例。
在下文中一共展示了City::whereRaw方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: edit
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$data = Employee::find($id);
$province = Province::all();
$cities = City::all();
$citmin = City::whereRaw('id = (select min(`id`) from cities)')->get();
$citmax = City::whereRaw('id = (select max(`id`) from cities)')->get();
$grade = Grade::all();
$jabatans = Jabatan::all();
$pt = array('sd' => 'SD', 'smp' => 'SMP', 'sma' => 'SMA', 'd3' => 'D3', 's1' => 'S1', 'S2' => 'S2');
$citsel = unserialize($data->id_cities);
$tls = Teamleader::where('id_users', $data->id)->get();
$pos = ProjectOfficer::where('id_users', $data->id)->get();
$adms = Admin::where('id_users', $data->id)->get();
return view('dropmin/data/edit')->with('data', $data)->with('province', $province)->with('grade', $grade)->with('tls', $tls)->with('pos', $pos)->with('adms', $adms)->with('jabatans', $jabatans)->with('pt', $pt)->with('citsel', $citsel)->with('cities', $cities);
}示例2: edit
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
// Start Check Authorization
/**
* 1. FullAccess - 1
* 2. HRD - 3
* 3. Creator - 5
* 4. Handler - 7
*/
$invalid_auth = 1;
$authRole = Auth::user()->UserRoles->role;
if ($authRole == 7 or $authRole == 1 or $authRole == 3) {
$invalid_auth = 0;
}
if ($invalid_auth == 1) {
Alert::error('Anda tidak memilik akses ini')->persistent('close');
return redirect('data/list');
}
// End Check Authorization
$data = Employee::find($id);
$province = Province::all();
$cities = City::all();
$citmin = City::whereRaw('id = (select min(`id`) from cities)')->get();
$citmax = City::whereRaw('id = (select max(`id`) from cities)')->get();
$grade = Grade::all();
$jabatans = Jabatan::all();
$pt = array('sd' => 'SD', 'smp' => 'SMP', 'sma' => 'SMA', 'd3' => 'D3', 's1' => 'S1', 'S2' => 'S2');
$citsel = unserialize($data->id_cities);
$tls = Teamleader::where('id_users', $data->id)->get();
$pos = ProjectOfficer::where('id_users', $data->id)->get();
$adms = Admin::where('id_users', $data->id)->get();
return view('dropmin/data/edit')->with('data', $data)->with('province', $province)->with('grade', $grade)->with('tls', $tls)->with('pos', $pos)->with('adms', $adms)->with('jabatans', $jabatans)->with('pt', $pt)->with('citsel', $citsel)->with('cities', $cities);
}