public function delete($id)
{
$this->db->trans_start();
# remove company task
$this->load->model("CompanyTaskModel");
$task = new CompanyTaskModel();
$task->delete_by_company($id);
# remove company achievement
$this->load->model("AchievementModel");
$achievement = new AchievementModel();
$achievement->delete_by_company($id);
# remove people and people photo
$this->load->model("PeopleModel");
$people = new PeopleModel();
$people->delete_by_company($id);
# remove company activity
$this->load->model("CompanyActivityModel");
$activity = new CompanyActivityModel();
$activity->delete_by_company($id);
# remove company photo
$this->load->model("CompanyPhotoModel");
$photo = new CompanyPhotoModel();
$photo->delete_by_company($id);
# remove follower record
$this->load->model("FollowerModel");
$follower = new FollowerModel();
$follower->delete_by_company($id);
# remove all job, application and bookmark
$this->load->model("JobModel");
$job = new JobModel();
$job->delete_by_company($id);
# remove all section, application and bookmark
$this->load->model("CompanySectionModel");
$job = new CompanySectionModel();
$job->delete_by_company($id);
# remove the company itself
$condition = array(CompanyModel::$primary_key => $id);
$this->db->delete(CompanyModel::$table_name, $condition);
$this->db->trans_complete();
return $this->db->trans_status();
}
