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">