jobViewPage('');
}
public function viewjob() {
$offerCode = ($this->uri->segment(3)) ? $this->uri->segment(3) : 0;
$this->jobViewPage($offerCode);
}
private function jobViewPage($offerCode) {
/* $data['sitename'] = 'home';
$this->load->view('templates/header_boxed', $data);
$this->load->view('users/view_index');
$this->load->view('users/view_external_footer');
* */
// $this->load->view('users/view_index');
// $this->load->view('users/view_external_footer');
$data = array();
$mysql = "SELECT jo.expire,jo.id AS offer_id, jo.offer_code,mj.title,mj.description,mj.timeline_days,mj.price,jo.job_description FROM members_jobs_offer jo "
. " LEFT JOIN members_jobs mj ON mj.id=jo.job_id "
. " WHERE mj.status=1 AND jo.status=1 "
. " AND jo.expire> now() AND jo.offer_code='" . $offerCode . "' AND jo.public_view > 0";
$query = $this->db->query($mysql);
$num = $query->num_rows();
if ($num > 0) {
$myTable = "";
foreach ($query->result_array() as $row) {
$myTable .= $this->makeMarketTableRow($row);
}
$myTable .="
";
// $this->table->set_heading('Added/Expire', 'Title/Recipient', 'Status', '');
$data['market_table'] = $myTable; // $this->table->generate($query);
// $offer_found = true;
} else {
$data['market_table'] = '';
}
$mysql2 = " SELECT o.*,j.title,j.description,j.timeline_days,j.price,j FROM members_jobs_offer o "
. " LEFT JOIN members_jobs j ON j.id =o.job_id "
. " WHERE o.public_view =1 AND o.offer_code<>'" . $offerCode . "' AND o.expire> now() AND o.status=1 ORDER BY o.id DESC LIMIT 50";
$query = $this->db->query($mysql2);
$data["numof_other_jobs"] = $query->num_rows();
$data["job_data"] = $query->result();
/*
$mysql2 = " SELECT o.*,j.title,j.description,j.timeline_days,j.price,j FROM members_jobs_offer o "
. " LEFT JOIN members_jobs j ON j.id =o.job_id "
. " WHERE o.public_view =1 AND o.offer_code<>'" . $offerCode . "' AND o.expire> now() ORDER BY o.id DESC LIMIT 50";
$query = $this->db->query($mysql2);
$data["numof_other_jobs"] = $query->num_rows();
$data["job_data"] = $query->result();
*/
$this->load->view('templates/view_header_market', $data);
$this->load->view('site/view_market', $data);
$this->load->view('templates/view_footer_market', $data);
}
private function makeMarketTableRow($row) {
return "| " . $row['offer_code'] . " | " . $row['title'] . " | |
"
. "| " . $this->makeMarketDetailTableRow($row) . " |
";
}
private function makeMarketDetailTableRow($row) {
$data['interest'] = 0;
$mysql = "SELECT count(*) AS interest FROM members_offer_interest WHERE offer_id=" . $row['offer_id'];
$query = $this->db->query($mysql);
if ($query->num_rows() > 0) {
$data = $query->row_array();
}
return " ";
}
}