/** * Show the form for editing the specified resource. * * @param int $id * @return Response */ public function edit($card_id, $id) { Card::findOrFail($card_id); $data[$this->card_id] = $card_id; $data['camp'] = Camp::select(DB::raw('X(geoPoint) as latitude, Y(geoPoint) as longitude,name,card_id,start_date,end_date,no_of_people,target,address,id,document,status,budget,comments,actual_budget,actual_orders,actual_deliver_time,village_details'), 'order')->findOrFail($id); return view('camps.edit', $data); }
/** * get the palnned goal completion for the specified cards with camps * params @int $id * * return array */ public static function get_panned_campgoals($id) { $pannedcamp = Camp::select(DB::Raw('sum(rb_camps.budget) as budget'), DB::Raw('count(rb_camps.id) as camps'), DB::Raw('sum(rb_camps.no_of_people) as total_villagers'), DB::Raw('sum(rb_camps.order) as orders'), DB::Raw('avg(rb_camps.deliver_time) as deliver_time')); $pannedcamp->join(static::$cards, static::$c_id, '=', 'camps.card_id'); $pannedcamp->where('camps.card_id', $id); return $pannedcamp->first(); }