/**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function edit($id)
 {
     $report_dates = ReportDate::lists('petsa', 'id');
     $saving_graduate = SavingGraduate::findOrFail($id);
     $sectors = Sector::all()->lists('name', 'id');
     $subsectors = Subsector::findOrFail($saving_graduate->subsector->id)->lists('name', 'id');
     return view('tviadmin.saving_graduates.edit', compact('saving_graduate', 'sectors', 'subsectors', 'report_dates'));
 }
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function edit($id)
 {
     $report_dates = ReportDate::lists('petsa', 'id');
     $job_placement_graduate = JobPlacementGraduate::findOrFail($id);
     $sectors = Sector::all()->lists('name', 'id');
     $subsectors = Subsector::findOrFail($job_placement_graduate->occupation->subsector->id)->lists('name', 'id');
     $occupations = Occupation::findOrFail($job_placement_graduate->occupation->id)->lists('name', 'id');
     return view('tviadmin.job_placement_graduates.edit', compact('job_placement_graduate', 'sectors', 'subsectors', 'occupations', 'report_dates'));
 }
 public function getEdit($key)
 {
     $id = Crypt::decrypt($key);
     $bienlicencia = BienLicencia::find($id);
     $categorias = Categoria::all();
     $centrocostos = CentroCosto::all();
     $sectors = Sector::all();
     return view('bienlicencia/edit')->with("centrocostos", $centrocostos)->with("sectors", $sectors)->with("categorias", $categorias)->with("bienlicencia", $bienlicencia);
 }
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function edit($id)
 {
     $user = Auth::user();
     $report_dates = ReportDate::lists('petsa', 'id');
     $industry_extension1 = IndustryExtension1::findOrFail($id);
     $sectors = Sector::all()->lists('name', 'id');
     $subsectors = Subsector::findOrFail($industry_extension1->subsector->id)->lists('name', 'id');
     return view('tviadmin.industry_extension1s.edit', array('industry_extension1' => $industry_extension1, 'report_dates' => $report_dates, 'sectors' => $sectors, 'subsectors' => $subsectors));
 }
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function edit($id)
 {
     $report_dates = ReportDate::lists('petsa', 'id');
     $assessment_transferee = AssessmentTransferee::findOrFail($id);
     $sectors = Sector::all()->lists('name', 'id');
     $subsectors = Subsector::findOrFail($assessment_transferee->occupation->subsector->id)->lists('name', 'id');
     $occupations = Occupation::findOrFail($assessment_transferee->occupation->id)->lists('name', 'id');
     return view('tviadmin.assessment_transferees.edit', compact('assessment_transferee', 'sectors', 'subsectors', 'occupations', 'report_dates'));
 }
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function edit($id)
 {
     $report_dates = ReportDate::lists('petsa', 'id');
     $cooperative_training_transferee = CooperativeTrainingTransferee::findOrFail($id);
     $sectors = Sector::all()->lists('name', 'id');
     $subsectors = Subsector::findOrFail($cooperative_training_transferee->occupation->subsector->id)->lists('name', 'id');
     $occupations = Occupation::findOrFail($cooperative_training_transferee->occupation->id)->lists('name', 'id');
     return view('tviadmin.cooperative_training_transferees.edit', compact('cooperative_training_transferee', 'sectors', 'subsectors', 'occupations', 'report_dates'));
 }
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function edit($id)
 {
     $report_dates = ReportDate::lists('petsa', 'id');
     $dropout_shortterm = DropoutShortTermTrainee::findOrFail($id);
     $sectors = Sector::all()->lists('name', 'id');
     $subsectors = Subsector::findOrFail($dropout_shortterm->occupation->subsector->id)->lists('name', 'id');
     $occupations = Occupation::findOrFail($dropout_shortterm->occupation->id)->lists('name', 'id');
     return view('tviadmin.dropout_short_term.edit', compact('dropout_shortterm', 'sectors', 'subsectors', 'occupations', 'report_dates'));
 }
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function edit($id)
 {
     $user = Auth::user();
     $report_dates = ReportDate::lists('petsa', 'id');
     $formal_training = FormalTraining::findOrFail($id);
     $sectors = Sector::all()->lists('name', 'id');
     $subsectors = Subsector::findOrFail($formal_training->occupation->subsector->id)->lists('name', 'id');
     $occupations = Occupation::findOrFail($formal_training->occupation->id)->lists('name', 'id');
     return view('tviadmin.formal_trainings.edit', array('formal_training' => $formal_training, 'report_dates' => $report_dates, 'sectors' => $sectors, 'subsectors' => $subsectors, 'occupations' => $occupations));
 }
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function edit($id)
 {
     $user = Auth::user();
     $report_dates = ReportDate::lists('petsa', 'id');
     $dropout_transferee = DropoutTransferee::findOrFail($id);
     $sectors = Sector::all()->lists('name', 'id');
     $subsectors = Subsector::findOrFail($dropout_transferee->occupation->subsector->id)->lists('name', 'id');
     $occupations = Occupation::findOrFail($dropout_transferee->occupation->id)->lists('name', 'id');
     return view('tviadmin.dropout_transferees.edit', compact('dropout_transferee', 'sectors', 'subsectors', 'occupations', 'report_dates'));
 }
示例#10
0
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function edit($id)
 {
     $user = Auth::user();
     $report_dates = ReportDate::lists('petsa', 'id');
     $assessment = Assessment::findOrFail($id);
     $sectors = Sector::all()->lists('name', 'id');
     $subsectors = Subsector::findOrFail($assessment->occupation->subsector->id)->lists('name', 'id');
     $occupations = Occupation::findOrFail($assessment->occupation->id)->lists('name', 'id');
     return view('tviadmin.assessments.edit', array('assessment' => $assessment, 'report_dates' => $report_dates, 'sectors' => $sectors, 'subsectors' => $subsectors, 'occupations' => $occupations));
 }
示例#11
0
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function edit($id)
 {
     $user = Auth::user();
     $report_dates = ReportDate::lists('petsa', 'id');
     $graduate = Graduate::findOrFail($id);
     $sectors = Sector::all()->lists('name', 'id');
     $subsectors = Subsector::findOrFail($graduate->occupation->subsector->id)->lists('name', 'id');
     $occupations = Occupation::findOrFail($graduate->occupation->id)->lists('name', 'id');
     return view('tviadmin.graduates.edit', compact('graduate', 'sectors', 'subsectors', 'occupations', 'report_dates'));
 }
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function edit($id)
 {
     $user = Auth::user();
     $report_dates = ReportDate::lists('petsa', 'id');
     $short_term_training = ShortTermTraining::findOrFail($id);
     $sectors = Sector::all()->lists('name', 'id');
     $subsectors = Subsector::findOrFail($short_term_training->occupation->subsector->id)->lists('name', 'id');
     $occupations = Occupation::findOrFail($short_term_training->occupation->id)->lists('name', 'id');
     $competencies = Occupation::findOrFail($short_term_training->occupation->id)->competencies()->lists('name', 'id');
     return view('tviadmin.short_term_trainings.edit', array('short_term_training' => $short_term_training, 'report_dates' => $report_dates, 'sectors' => $sectors, 'subsectors' => $subsectors, 'occupations' => $occupations, 'competencies' => $competencies));
 }
示例#13
0
 public function district(Request $request)
 {
     $district_id = $request->input('district');
     $districts = District::where('id', '=', $district_id)->get();
     $sectors = Sector::where('district_id', "=", $district_id)->get();
     foreach ($sectors as $sector) {
         $sectors_ids[] = $sector->id;
     }
     $cells = Cell::whereIn('sector_id', $sectors_ids)->get();
     foreach ($cells as $cell) {
         $cells_ids[] = $cell->id;
     }
     $markets = Market::whereIn('cell_id', $cells_ids)->get();
     foreach ($markets as $market) {
         $markets_ids[] = $market->id;
     }
     $prices = Price::whereIn('market_id', $markets_ids)->get();
     return view('reports.district')->with('districts', $districts)->with('sectors', $sectors)->with('prices', $prices);
 }
示例#14
0
<?php

$sectors = \App\Sector::orderBy('name', 'asc')->get();
?>

<div class="col-md-8 col-md-offset-2">

@if($submitButtonText=='Update')

    <?php 
$subsectors = \App\Sector::find($sector_id)->subsectors->sortBy('name')->lists('name', 'id');
$occupations = \App\Subsector::find($subsector_id)->occupations->sortBy('name')->lists('name', 'id');
?>

    <div class="form-group">
            {!! Form::label('name', 'Competency Name : ') !!}
            {!! Form::text('name', null, ['placeholder' => 'Competency Name',
                                          'class' => 'form-control',
                                          'value' => '{{ old("name") }}']) !!}
        </div>

        <div class="form-group">
            {!! Form::label('code', 'Competency Code : ') !!}
            {!! Form::text('code', null, ['placeholder' => 'Competency Code',
                                          'class' => 'form-control',
                                          'value' => '{{ old("code") }}']) !!}
        </div>

        <div class="form-group">
            {!! Form::label('active', 'Is Active? : ') !!}
            {!! Form::select('active', array('1' => 'True',
 /**
  * Show the form for creating a new resource.
  *
  * @return Response
  */
 public function addNew()
 {
     $sector = Sector::all();
     return view('add', ['sector' => $sector]);
 }
示例#16
0
 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     DB::table('sectors')->truncate();
     $gasabo = array("Bumbogo", "Gatsata", "Jali", "Gikomero", "Gisozi", "Jabana", "Kinyinya", "Ndera", "Nduba", "Rusororo", "Rutunga", " Kacyiru", "Kimihurura", "Kimironko", "Remera");
     foreach ($gasabo as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 1]);
     }
     $kicukiro = array("Gahanga", "Gatenga", "Gikondo", "Kagarama", "Kanombe", "Kicukiro", "Kigarama", "Masaka", "Niboye", "Nyarugunga");
     foreach ($kicukiro as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 2]);
     }
     $nyarugenge = array("Gitega", "Kanyinya", "Kigali", "Kimisagara", "Mageragere", "Muhima", "Nyakabanda", "Nyamirambo", "Nyarugenge", "Rwezamenyo");
     foreach ($nyarugenge as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 3]);
     }
     $burera = array("Bungwe", "Butaro", "Cyanika", "Cyeru", "Gahunga", "Gatebe", "Gitovu", "Kagogo", "Kinoni", "Kinyababa", "Kivuye", "Nemba", "Rugarama", "Rugendabari", "Ruhunde", "Rusarabuge", "Rwerere");
     foreach ($burera as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 4]);
     }
     $gicumbi = array(" Bukure", "Bwisige", "Byumba", "Cyumba", "Giti", "Kaniga", "Manyagiro", "Miyove", "Kageyo", " Mukarange", " Muko", "Mutete", "Nyamiyaga", "Nyankenke II", "Rubaya", "Rukomo", "Rushaki", "Rutare", "Ruvune", "Rwamiko", "Shangasha");
     foreach ($gicumbi as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 5]);
     }
     $gakenke = array("Busengo", "Coko", " Cyabingo", "Gakenke", "Gashenyi", "Mugunga", "Janja", "Kamubuga", "Karambo", "Kivuruga", "Mataba", "Minazi", "Muhondo", "Muyongwe", " Muzo", " Nemba", " Ruli", "Rusasa", "Rushashi");
     foreach ($gakenke as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 6]);
     }
     $musanze = array("Busogo", "Cyuve", "Gacaca", "Gashaki", "Gataraga", "Kimonyi", "Kinigi", " Muhoza", " Muko", "Musanze", "Nkotsi", "Nyange", " Remera", "Rwaza", "Shingiro");
     foreach ($musanze as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 7]);
     }
     $rulindo = array("Base", "Burega", " Bushoki", "Buyoga", "Cyinzuzi", "Cyungo", " Kinihira", "Kisaro", " Masoro", " Mbogo", "Murambi", "Ngoma", " Ntarabana", "Rukozo", "Rusiga", "Shyorongi", "Tumba");
     foreach ($rulindo as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 8]);
     }
     $gisagara = array("Gikonko", "Gishubi", "Kansi", " Kibilizi", "Kigembe", " Mamba", "Muganza", "Mugombwa", " Mukindo", " Musha", "Ndora", "Nyanza", "Save");
     foreach ($gisagara as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 9]);
     }
     $huye = array("Gishamvu", " Karama", "Kigoma", " Kinazi", " Maraba", " Mbazi", "Mukura", "Ngoma", "Ruhashya", " Huye", " Rusatira", "Rwaniro", " Simbi", "Tumba");
     foreach ($huye as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 10]);
     }
     $kamonyi = array("Gacurabwenge", " Karama", "Kayenzi", " Kayumbu", "Mugina", "Musambira", "Ngamba", "Nyamiyaga", "Nyarubaka", "Rugalika", " Rukoma", "Runda");
     foreach ($kamonyi as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 11]);
     }
     $muhanga = array("Muhanga", "Cyeza", " Kibangu", "Kiyumba", "Mushishiro", " Kabacuzi", " Nyabinoni", " Nyamabuye", " Nyarusange", " Rongi", " Rugendabari", "Shyogwe");
     foreach ($muhanga as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 12]);
     }
     $nyamagabe = array(" Buruhukiro", "Cyanika", "Gatare", "Kaduha", "Kamegeli", "Kibirizi", "Kibumbwe", "Kitabi", " Mbazi", " Mugano", "Musange", "Musebeya", " Mushubi", " Nkomane", "Gasaka", "Tare", "Uwinkingi");
     foreach ($nyamagabe as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 13]);
     }
     $nyanza = array("Busasamana", "Busoro", " Cyabakamyi", "Kibirizi", "Kigoma", "Mukingo", " Muyira", " Ntyazo", "Nyagisozi", "Rwabicuma");
     foreach ($nyanza as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 14]);
     }
     $nyaruguru = array("Cyahinda", " Busanze", "Kibeho", "Mata", " Munini", "Kivu", "Ngera", " Ngoma", " Nyabimata", " Nyagisozi", "Muganza", " Ruheru", " Ruramba", "Rusenge");
     foreach ($nyaruguru as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 15]);
     }
     $ruhango = array("Kinazi", "Byimana", "Bweramana", " Mbuye", " Ruhango", " Mwendo", "Kinihira", " Ntongwe", "Kabagari");
     foreach ($ruhango as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 16]);
     }
     $bugesera = array("Gashora", "Juru", " Kamabuye", " Ntarama", " Mareba", " Mayange", " Musenyi", " Mwogo", " Ngeruka", " Nyamata", " Nyarugenge", "Rilima", " Ruhuha", " Rweru", "Shyara");
     foreach ($bugesera as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 17]);
     }
     $gatsibo = array("Gasange", "Gatsibo", "Gitoki", "Kabarore", " Kageyo", " Kiramuruzi", " Kiziguro", " Muhura", " Murambi", " Ngarama", " Nyagihanga", " Remera", "Rugarama", "Rwimbogo");
     foreach ($gatsibo as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 18]);
     }
     $kayonza = array("Gahini", "Kabare", "Kabarondo", "Mukarange", "Murama", " Murundi", " Mwiri", " Ndego", "Nyamirama", "Rukara", "Ruramira", "Rwinkwavu");
     foreach ($kayonza as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 19]);
     }
     $kirehe = array("Gahara", "Gatore", " Kigarama", "Kigina", " Kirehe", "Mahama", "Mpanga", "Musaza", "Mushikiri", " Nasho", " Nyamugari", "Nyarubuye");
     foreach ($kirehe as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 20]);
     }
     $ngoma = array("Gashanda", "Jarama", "Karembo", "Kazo", "Kibungo", " Mugesera", " Murama", "Mutenderi", " Remera", " Rukira", "Rukumberi", " Rurenge", "Sake ", "Zaza");
     foreach ($ngoma as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 21]);
     }
     $nyagatare = array("Rwimiyaga", "Karangazi", "Nyagatare", "Katabagemu", "Rukomo", "Tabagwe", "Musheli", "Gatunda", "Mimuli", "Karama", "Matimba", "Mukama", "Rwempasha", "Kiyombe");
     foreach ($nyagatare as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 22]);
     }
     $rwamagana = array("Fumbwe", "Gahengeri", "Gishari", "Karenge", " Kigabiro", "Muhazi", " Munyaga", " Munyiginya", " Musha", "Muyumbu", " Mwulire", "Nyakariro", " Nzige", "Rubona");
     foreach ($rwamagana as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 23]);
     }
     $karongi = array();
     foreach ($karongi as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 24]);
     }
     $ngororero = array("Bwira", "Gatumba", "Hindiro", "Kabaya", " Kageyo", " Kavumu", " Matyazo", " Muhanda", " Muhororo", "Ndaro", "Ngororero", " Nyange", "Sovu");
     foreach ($ngororero as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 25]);
     }
     $nyabihu = array("Bigogwe", "Jenda", "Jomba", "Kabatwa", " Karago", "Kintobo", " Mukamira", " Muringa", " Rambura", "Rugera", " Rurembo", "Shyira");
     foreach ($nyabihu as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 26]);
     }
     $nyamasheke = array("Ruharambuga", "Bushekeri", "Bushenge", "Cyato", "Gihombo", " Kagano", " Kanjongo", "Karambi", "Karengera", "Kirimbi", " Macuba", "Nyabitekeri", " Mahembe", "Rangiro", "Shangi");
     foreach ($nyamasheke as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 27]);
     }
     $rubavu = array("Bugeshi", "Busasamana", "Cyanzarwe", "Gisenyi", " Kanama", "Kanzenze", "Mudende", "Nyakiliba", " Nyamyumba", " Nyundo", " Rubavu", "Rugerero");
     foreach ($rubavu as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 28]);
     }
     $rustiro = array("Boneza", "Gihango", "Kigeyo", " Kivumu", "Manihira", " Mukura", " Murunda", " Musasa", "Mushonyi", " Mushubati", " Nyabirasi", " Ruhango", "Rusebeya");
     foreach ($rustiro as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 29]);
     }
     $rusizi = array("Bugarama", "Butare", "Bweyeye", " Gikundamvura", "Gashonga", "Giheke", "Gihundwe", "Gitambi", "Kamembe", " Muganza", "Mururu", "Nkanka", "Nkombo", " Nkungu", "Nyakabuye", " Nyakarenzo", " Nzahaha", "Rwimbogo");
     foreach ($rusizi as $value) {
         Sector::create(['sector_name' => $value, 'district_id' => 30]);
     }
 }
示例#17
0
 public function getEdit($key)
 {
     $id = Crypt::decrypt($key);
     $inventario = Inventario::find($id);
     $categorias = Categoria::all();
     $centrocostos = CentroCosto::all();
     $sectors = Sector::all();
     return view('inventario/edit')->with("centrocostos", $centrocostos)->with("sectors", $sectors)->with("categorias", $categorias)->with("inventario", $inventario);
 }
示例#18
0
<?php

$sectors = \App\Sector::orderBy('name', 'asc')->lists('name', 'id');
?>

<div class="col-md-8 col-md-offset-2">

@if($submitButtonText=='Update')

    <div class="form-group">
        {!! Form::label('name', 'Sector Name : ') !!}
        {!! Form::text('name', null, ['placeholder' => 'Sub-sector Name',
                                      'class' => 'form-control',
                                      'value' => '{{ old("name") }}']) !!}
    </div>

    <div class="form-group">
        {!! Form::label('sector_id', 'Sector : ') !!}
        {!! Form::select('sector_id', $sectors, null, ['class' => 'form-control']) !!}
    </div>

    <div class="form-group">
        {!! Form::label('active', 'Is Active? : ') !!}
        {!! Form::select('active', array('1' => 'True',
                                        '0' => 'False'
                                      ), $active,
                                      ['class' => 'form-control']) !!}
    </div>

@elseif($submitButtonText=='Save')
示例#19
0
 public function postDelete(Request $request)
 {
     $sector = Sector::findOrFail($request->input("_id"));
     $sector->delete();
     return redirect("sector")->with('success', 'delete');
 }
示例#20
0
Route::filter('rta', function () {
    if (!Auth::check() || !Auth::user()->isRTAAdmin()) {
        /*return App::abort(404);*/
        return redirect('/auth/login');
    }
});
Route::filter('tvi', function () {
    if (!Auth::check() || !Auth::user()->isTVIAdmin()) {
        /*return App::abort(404);*/
        return redirect('/auth/login');
    }
});
Route::group(array('middleware' => 'auth'), function () {
    Route::get('load-sub-sectors', function () {
        $input = Input::get('option');
        $sector = \App\Sector::find($input);
        $subsectors = $sector->subsectors()->where('active', true)->orderBy('name', 'asc');
        return Response::make($subsectors->get(['id', 'name']));
    });
    Route::get('load-occupations', function () {
        $input = Input::get('option');
        $subsector = \App\Subsector::find($input);
        $occupations = $subsector->occupations()->where('active', true)->orderBy('name', 'asc');
        return Response::make($occupations->get(['id', 'name']));
    });
    Route::get('load-competencies', function () {
        $input = Input::get('option');
        $occupation = \App\Occupation::find($input);
        $competencies = $occupation->competencies()->where('active', true)->orderBy('name', 'asc');
        return Response::make($competencies->get(['id', 'name']));
    });
示例#21
0
 public function for_print_rpt1_non_gov_drop_grad($id)
 {
     $user = Auth::user();
     $region = Region::findOrFail($user->region_id);
     $report_date = ReportDate::findOrFail($id);
     $rpt1 = new RTAReport1NonGovernment($report_date->id, $user->region_id);
     // get occupations
     $occupations = Occupation::whereIn('id', DropoutGraduate::select('occupation_id')->where('report_date_id', $id)->whereIn('institution_id', Institution::select('id')->where('region_id', $region->id)->where('ownership', '!=', 'Public')->lists('id'))->lists('occupation_id'))->orderBy('name')->get();
     // get sectors
     $sectors = Sector::whereIn('id', Subsector::select('sector_id')->whereIn('id', $occupations->lists('subsector_id'))->get())->get();
     // get subsectors
     $subsectors = Subsector::whereIn('id', $occupations->lists('subsector_id'))->get();
     return view('rtaadmin.print_rpt1nongov_7', compact('rpt1', 'region', 'report_date', 'sectors', 'subsectors', 'occupations'));
 }
示例#22
0
 public function getEdit($key)
 {
     $id = Crypt::decrypt($key);
     $bienregistro = BienRegistro::find($id);
     $categorias = Categoria::all();
     $centrocostos = CentroCosto::all();
     $sectors = Sector::all();
     $bienregistros = BienRegistro::all();
     $json = array();
     foreach ($bienregistros as $bienregistro) {
         array_push($json, $bienregistro->descripcion);
     }
     $json = json_encode($json);
     return view('bienregistro/edit')->with("json", $json)->with("centrocostos", $centrocostos)->with("sectors", $sectors)->with("categorias", $categorias)->with("bienregistro", $bienregistro);
 }
示例#23
0
});
/*
|--------------------------------------------------------------------------
| User Routes
|--------------------------------------------------------------------------
|         here is where all user's route located 
|
*/
Route::get('getDistrict', function () {
    $prov_id = Input::get('prov_id');
    $district = District::where('province_id', '=', $prov_id)->get();
    return Response::json($district);
});
Route::get('getSector', function () {
    $distr_id = Input::get('distr_id');
    $sector = Sector::where('district_id', '=', $distr_id)->get();
    return Response::json($sector);
});
Route::get('getCell', function () {
    $sect_id = Input::get('sect_id');
    $cell = Cell::where('sector_id', '=', $sect_id)->get();
    return Response::json($cell);
});
Route::get('getMarket', function () {
    $cell_id = Input::get('cell_id');
    $mark = Market::where('cell_id', '=', $cell_id)->get();
    return Response::json($mark);
});
Route::get('index', ['uses' => 'UserController@index', 'as' => 'index']);
Route::post('signup', ['uses' => 'UserController@signUp', 'as' => 'signup', 'middleware' => ['guest']]);
Route::get('signup', ['as' => 'signup', 'uses' => 'UserController@index']);
示例#24
0
 /**
  * Show the form for creating a new resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function create()
 {
     $sectors = Sector::all();
     return view('members.create', compact('sectors'));
 }
示例#25
0
 public function delete($id)
 {
     $sector = Sector::findOrFail($id);
     return view('sysadmin.sectors.delete', compact('sector'));
 }