load->model('placeModel'); } public function category() { $this->podbbangModel->updateCategory($this->input->post('id'), $this->input->post('category')); echo $this->db->affected_rows(); } public function church() { $this->data = ['page' => $this->getPage(__FUNCTION__), 'categories' => []]; $this->load->view('page', $this->data); } public function church_table() { $data = $this->placeModel->getTable(json_decode($this->input->raw_input_stream, true)); // echo $this->db->last_query(); $naverPlaceIds = array(); foreach($data['rows'] as $d) { array_push($naverPlaceIds, $d->NId); } $churchs = $this->db->where_in('NId', $naverPlaceIds)->get('cm_place_church')->result(); $churchIds = array(); foreach($churchs as $c) { array_push($churchIds, $c->Id); } $churchServices = count($churchIds) > 0 ? $this->db->where_in('ChurchId', $churchIds)->get('cm_church_service')->result() : array(); foreach($data['rows'] as $k => $v) { $data['rows'][$k]->Services = array(); foreach($churchs as $c) { if($c->NId == $v->NId) { foreach($c as $j => $a) { $data['rows'][$k]->{$j} = $a; } foreach($churchServices as $cs) { if($cs->ChurchId == $c->Id) { array_push($data['rows'][$k]->Services, $cs); } } } } $data['rows'][$k]->Address = $v->RoadAddress ? $v->RoadAddress : $v->Address; } $this->response($data); } public function delete() { $data = $this->restClient->deleteDeveloper(['developers' => array_column($this->input->post('selection'), 'id')]); $this->response(array( 'code' => 200, 'data' => [] )); } public function update() { foreach ($this->input->post('selection') as $developer) { $this->restClient->updateDeveloper([ 'name' => $developer['name'], 'description' => $developer['description'], 'id' => $developer['id'] ]); } $this->response(array( 'code' => 200, 'data' => [] )); } public function church_save() { if ($this->placeModel->saveChurch($this->input->post())) { $this->response(array( 'code' => 200, 'data' => [] )); } else { $this->response(array( 'code' => 500, 'data' => [] )); } } }