Olu Amey
106 lines
4.4 KiB
PHP
106 lines
4.4 KiB
PHP
<?php
|
|
|
|
defined('BASEPATH') OR exit('No direct script access allowed');
|
|
|
|
class Plb extends WRB_Controller {
|
|
|
|
public function index() {
|
|
$this->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 = "<table class='table table-striped table-hover table-bordered table-condensed'>";
|
|
|
|
foreach ($query->result_array() as $row) {
|
|
$myTable .= $this->makeMarketTableRow($row);
|
|
}
|
|
|
|
$myTable .="</table>";
|
|
// $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 "<tr><td style='width:100px;'><b>" . $row['offer_code'] . "</b></td><td>" . $row['title'] . "</td><td style='width:100px;'></td></tr>"
|
|
. "<tr><td colspan = '3'>" . $this->makeMarketDetailTableRow($row) . "</td></tr>";
|
|
}
|
|
|
|
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 "<table class='table table-striped table-hover table-bordered table-condensed'><tr><td colspan='2' ><b> Timeline:</b>" . $row['timeline_days'] . " day(s) - <b>Budget: </b> " . $row['price'] * 0.01 . " Naira</td></tr>"
|
|
. "<tr><td style='width:100px;'><b>Title</b></td><td>" . $row['title'] . "</td></tr>"
|
|
. "<tr><td><b>Description</b></td><td>" . $row['description'] . "</td></tr>"
|
|
. "<tr><td><b>Detail</b></td><td>" . $row['job_description'] . "</td></tr>"
|
|
. "<tr><td colspan='2' >Interests : <b>" . $data['interest'] . "</b> Expire:<b> " . $row['expire'] . "</b> </td></tr>"
|
|
. "<tr><td><b></b></td><td style='text-align:right;'><input type=submit id='submit_interest_" . $row['offer_code'] . "' name=\"mview\" onclick=\"return LoginInterest('" . $row['offer_code'] . "');\" class=\"btn btn-success btn-xs\" value=\"see more ?
|
|
\"></td></tr>"
|
|
. "</table> ";
|
|
}
|
|
|
|
}
|