public function ie_companies_supported() { $result = IndustryExtension5::select(DB::raw('sum(micro) as micro_companies, sum(small) as small_companies, sum(medium) as medium_companies'))->where('report_date_id', $this->report_date_id)->where('institution_id', $this->institution_id)->get(); return $result; }
public function saveAs(Request $request) { // retrieve all records as collection $records = IndustryExtension5::select('report_date_id', 'institution_id', 'subsector_id', 'micro', 'small', 'medium', 'ie_field', 'level_c_male', 'level_c_female', 'level_b_male', 'level_b_female', 'level_a_male', 'level_a_female', 'remarks')->where('report_date_id', $request->report_date_id_source)->get(); if (count($records) > 0) { // update report date id to target report date id foreach ($records as $rec) { $rec->report_date_id = $request->report_date_id_target; } // insert into the table IndustryExtension5::insert($records->toArray()); // send a flash message $request->session()->flash('alert-success', 'Save as operation was successful!'); } else { // send a flash message $request->session()->flash('alert-danger', 'Save as operation failed! No records found from source.'); } return redirect('industry-extension-5'); }
public function medium($subsector_id) { $result = IndustryExtension5::where('report_date_id', $this->report_date_id)->where('institution_id', $this->institution_id)->where('subsector_id', $subsector_id)->sum('medium'); return $result; }
public function ie_supported_mse() { $result = IndustryExtension5::select(DB::raw('sum(micro) as micro, sum(small) as small, sum(micro) + sum(small) as total'))->whereIn('report_date_id', ReportDate::select('id')->where('petsa', $this->petsa)->lists('id'))->whereIn('institution_id', Institution::select('id')->where('region_id', $this->region_id)->lists('id'))->get(); return $result; }
public function ie_supported_mse() { $result = IndustryExtension5::select(DB::raw('sum(micro) as micro, sum(small) as small, sum(micro) + sum(small) as total'))->where('report_date_id', $this->report_date_id)->where('institution_id', $this->institution_id)->get(); return $result; }