public function run()
{
App\Bantuan::truncate();
$data = array(array('id_user' => 2, 'id_bantuan' => 1, 'tahun' => 2015), array('id_user' => 2, 'id_bantuan' => 2, 'tahun' => 2015), array('id_user' => 2, 'id_bantuan' => 3, 'tahun' => 2015), array('id_user' => 3, 'id_bantuan' => 2, 'tahun' => 2015), array('id_user' => 4, 'id_bantuan' => 6, 'tahun' => 2015), array('id_user' => 5, 'id_bantuan' => 7, 'tahun' => 2015));
DB::table('app_bantuan')->insert($data);
}
public function run()
{
App\Bantuan::truncate();
$data = array(array('nama' => 'Bibit', 'jenis' => 'Pembudidaya'), array('nama' => 'Pakan', 'jenis' => 'Pembudidaya'), array('nama' => 'Tali', 'jenis' => 'Pembudidaya'), array('nama' => 'Para-para', 'jenis' => 'Pembudidaya'), array('nama' => 'Perahu', 'jenis' => 'Pembudidaya'), array('nama' => 'Perahu/Kapal', 'jenis' => 'Nelayan'), array('nama' => 'Alat Tangkap', 'jenis' => 'Nelayan'), array('nama' => 'Mesin', 'jenis' => 'Nelayan'));
DB::table('app_bantuan_master')->insert($data);
}
@foreach( $data_users as $du )
<option value="{{ $du->id }}" {{ $du->id == $user->id ? "selected":""}}>{{ $du->nik }} <b>-</b> {{ $du->name }} <b>-</b> {{ $du->nama_kelompok }}</option>
@endforeach
</select>
</div>
</div>
</div>
<div class="row">
<div class="col-sm-8">
<div class="form-group required" id="list-bantuan">
<label>Jenis Bantuan</label>
<select name="id_bantuan[]" class="full-width" data-init-plugin="select2" multiple="" required data-placeholder="Pilih Jenis Bantuan...">
<?php
$list_all_bantuan = App\Bantuan::where('jenis', $user->profesi)->get();
$list_bantuan = DB::table('app_bantuan as ab')->leftJoin('app_bantuan_master as abm', 'abm.id', '=', 'ab.id_bantuan')->select('abm.nama', 'abm.id')->where('ab.id_user', $user->id)->where('ab.tahun', $user->tahun_bantuan)->orderBy('ab.tahun', 'asc')->get();
foreach ($list_bantuan as $lb) {
$data_list_bantuan[] = $lb->id;
}
?>
@foreach( $list_all_bantuan as $lab )
<option value="{{ $lab->id }}" {{ in_array($lab->id, $data_list_bantuan) ? "selected":"" }}>{{ $lab->nama }}</option>
@endforeach
</select>
</div>
</div>
<div class="col-sm-4">
<div class="form-group">
