Olu Amey
307 lines
17 KiB
PHP
307 lines
17 KiB
PHP
<?php
|
|
|
|
defined('BASEPATH') OR exit('No direct script access allowed');
|
|
|
|
class Dash extends Users_Controller {
|
|
|
|
function __construct() {
|
|
parent::__construct();
|
|
if (!isset($_SESSION['username']) or $_SESSION['username'] == '') {
|
|
redirect(home);
|
|
}
|
|
}
|
|
|
|
public function index() {
|
|
|
|
$data['username'] = $_SESSION['username']; // = $this->input->post('username');
|
|
$data['name'] = $_SESSION['name']; // = $this->input->post('username');
|
|
$data['firstname'] = $_SESSION['firstname']; // = $ret->firstname;
|
|
$data['lastname'] = $_SESSION['lastname']; // = $ret->lastname;
|
|
$data['email'] = $_SESSION['email']; // = $ret->email;
|
|
$data['member_id'] = $_SESSION['member_id']; // = $ret->email;
|
|
// print_r($_SESSION);
|
|
//Array ( [__ci_last_regenerate] => 1474689025 [username] => ses66181+1@gmail.com [name] => ses66181+1@gmail.com [firstname] => Olusesan [lastname] => Amey [email] => ses66181+1@gmail.com )
|
|
if (!isset($_SESSION['username']) or $_SESSION['username'] == '') {
|
|
redirect(home);
|
|
} else {
|
|
// load the Dash model now
|
|
$this->load->model('dash_model');
|
|
$out = $this->dash_model->getDashData($data);
|
|
|
|
$data = $this->getSessionArray();
|
|
|
|
// print_r($out[0]);
|
|
$data['active_task'] = $out['active_task'];
|
|
$data['active_pass_due'] = $out['active_pass_due'];
|
|
$data['current_balance'] = $out['current_balance'];
|
|
$data['new_message'] = $out['new_message'];
|
|
$data['total_jobs'] = $out['total_jobs'];
|
|
$data['offer_dash'] = '';
|
|
|
|
// Review to another location
|
|
|
|
$mysql = "SELECT to_char(mi.added, 'YYYY-MM-DD HH24:MI') AS added,jo.offer_code,mjs.title,"
|
|
. "m.firstname||' '||m.lastname AS Client "
|
|
. "FROM members_offer_interest mi "
|
|
. "LEFT JOIN members m ON m.id = mi.member_id "
|
|
. "LEFT JOIN members_jobs_offer jo ON jo.id=mi.offer_id "
|
|
. "LEFT JOIN members_jobs mjs ON mjs.id=jo.job_id "
|
|
. "WHERE jo.member_id =" . $_SESSION['member_id'] . " "
|
|
. "AND mi.status=1 AND jo.expire> now() + '-3 days' ORDER BY mi.added ASC";
|
|
|
|
|
|
$query = $this->db->query($mysql);
|
|
$data["offer_interest_count"] = $query->num_rows();
|
|
$_SESSION['offer_interest_count'] = $data["offer_interest_count"];
|
|
|
|
|
|
$mysql = "SELECT '<b>Project ID:</b>'||mc.contract||'<br><b>Title:</b>'||mc.title AS Project,m.firstname||' '||m.lastname AS Client,"
|
|
. " '<b>Timeline:</b> '||mc.timeline_days||' day(s)<br><b>Price:</b>'||mc.price*0.01 ,mc.description, "
|
|
. " (CASE WHEN mc.status = 1 AND mc.delivery_date > now() THEN 'Active' WHEN mc.status = 1 AND mc.delivery_date <now() THEN 'Past Due' "
|
|
. " WHEN mc.status = 4 THEN 'Review' ELSE 'Not Set' END) AS status "
|
|
. " FROM members_jobs_contract mc LEFT JOIN members m ON m.id=mc.client_id WHERE mc.member_id = " . $_SESSION['member_id'] . " AND mc.status IN (1,2) "
|
|
. " AND delivery_date < now()";
|
|
|
|
$query = $this->db->query($mysql);
|
|
$data["past_duejobs_count"] = $query->num_rows();
|
|
$_SESSION['past_duejobs_count'] = $data["past_duejobs_count"];
|
|
//======================= move it
|
|
/* Table Slider Data */
|
|
|
|
$jbx = "''/proj/thisjob''";
|
|
$mysql = "SELECT '<b>ID:</b><a href=\"#\" onclick=\"showJobModal('''||mc.contract||''');\" >'||mc.contract||'</a><br><b>Timeline:</b>'||mc.timeline_days||' day(s)<br><b>Price:</b>'||mc.price*0.01 AS Project,"
|
|
. " '<b>Title: </b>'||mc.title||'<br><b>Description: </b>'||mc.description AS description,"
|
|
. " (CASE WHEN mc.status=4 THEN '<input type=submit onclick=\"return post_nav_find_action($jbx, '||mc.id||')\" name=\"manage\" class=\"btn btn-info btn-xs btn-block\" value=\"Review\">' "
|
|
. " WHEN mc.status = 1 AND mc.delivery_date > now() THEN '<input type=submit onclick=\"return post_nav_find_action($jbx, '||mc.id||')\" name=\"manage\" class=\"btn btn-success btn-xs btn-block\" value=\"View\">' "
|
|
. " WHEN mc.status = 1 AND mc.delivery_date <now() THEN '<span class=\"label label-flat border-danger text-danger-600\">PastDue</span>' "
|
|
. " ELSE '<input type=submit onclick=\"return post_nav_find_action($jbx, '||mc.id||')\" name=\"manage\" class=\"btn btn-info btn-xs btn-block\" value=\"View\">' END) AS manage "
|
|
. " FROM members_jobs_contract mc LEFT JOIN members m ON m.id=mc.client_id "
|
|
. " WHERE mc.member_id = " . $_SESSION['member_id'] . " AND mc.status IN (1,2,4) AND mc.delivery_date > now() "
|
|
. " OR mc.client_id =" . $_SESSION['member_id'] . " AND mc.status IN (1,2,4) AND mc.delivery_date > now() LIMIT 4";
|
|
|
|
$query = $this->db->query($mysql);
|
|
|
|
|
|
$this->load->library('table');
|
|
$this->table->set_template($this->template);
|
|
$this->table->set_heading(array('data' => 'Job', 'style' => 'width:180px'), 'Title/Description', array('data' => '', 'style' => 'width:100px; cellpadding:0px;'));
|
|
|
|
$data['job_table'] = $this->table->generate($query);
|
|
|
|
|
|
$x = $this->dashTaskMessage();
|
|
$data['job_message_table'] = $x['job_message_table'];
|
|
/// End table data ===========================
|
|
|
|
|
|
|
|
/*
|
|
$this->load->library('table');
|
|
$this->table->set_template($this->template);
|
|
//$this->table->set_heading('Job', 'Client', 'Terms', 'Description', 'Manage', 'Status');
|
|
$mysql = 'SELECT jo.added::date,jo.member_id,j.title,'
|
|
. 'CASE WHEN jo.status = 1 THEN \'Pending\' ELSE \'Other\' END AS status'
|
|
. 'FROM members_jobs_offer jo LEFT JOIN members_jobs j ON j.id = jo.job_id LIMIT 5';
|
|
// $sqb =" ,'<button type=\"button\" class=\"btn btn-primary btn-xs\">View</button>' As View ";
|
|
$jbx = "''jobs/viewjob''";
|
|
$mysql = "SELECT jo.added::date,j.title,"
|
|
. 'CASE WHEN jo.status = 1 THEN \'Pending\' ELSE \'Other\' END AS status,'
|
|
. "'<input type=submit onclick=\"return post_nav_find_action($jbx,'''||jo.offer_code||''')\" name=\"manage\" class=\"btn btn-primary btn-xs\" value=\"View\">' AS View "
|
|
. "FROM members_jobs_offer jo LEFT JOIN members_jobs j ON j.id = jo.job_id "
|
|
. "WHERE jo.expire > now() AND jo.status = 1 "
|
|
. "AND jo.client_id = " . $_SESSION['member_id'] . "LIMIT 4";
|
|
|
|
$query = $this->db->query($mysql);
|
|
|
|
$num = $query->num_rows();
|
|
|
|
$data["dash_title"] = "Pending Offer(s)";
|
|
if ($num > 0) {
|
|
$this->table->set_heading('Added', 'Title', 'Status', '');
|
|
$data['offer_dash'] = $this->table->generate($query);
|
|
} else {
|
|
$data["offer_dash"] = "<div class=\"thumb\"><img src='assets/images/notask.png' alt=\"Active Projects\"></div>";
|
|
}
|
|
*/
|
|
|
|
$ya = array();
|
|
$ya = $this->dash_title();
|
|
$data["dash_title"] = $ya["dash_title"];
|
|
$data["offer_dash"] = $ya["offer_dash"];
|
|
|
|
$_SESSION['secure_data'] = $data; // all data needed for secure page
|
|
// print_r($_SESSION);
|
|
|
|
$this->load->view('users/view_header_user', $data);
|
|
$this->load->view('users/view_dash', $data);
|
|
$this->load->view('users/view_footer_user', $data);
|
|
}
|
|
}
|
|
|
|
private function dashTaskMessage() {
|
|
$data = array();
|
|
/*
|
|
wrenchboard=> select s.created,j.contract,j.title,j.id,j.status,j.delivery_date,substring(s.message,0,100) FROM members_jobs_contract j RIGHT JOIN jobs_contract_message s ON s.contract=j.contract WHERE j.member_id=3 or j.client_id = 3 AND j.status IN (1,4);
|
|
created | contract | title | id | status | delivery_date | substring
|
|
----------------------------+------------+-----------------------------------------------+----+--------+----------------------------+-----------------------------------------------------------------------------------------------------
|
|
2017-05-18 11:53:20.569399 | 7BW9B9R8BB | five thousand naira | 13 | 1 | 2017-08-02 14:19:38.711257 | This is a test of ajax send message
|
|
2017-05-18 12:03:30.685328 | 7B27RRBRB7 | 595Job Title Job Title Job Title Job Title932 | 15 | 4 | 2017-05-10 19:23:26.115394 | dldldldldldl
|
|
2017-05-18 12:03:44.137005 | 7B27RRBRB7 | 595Job Title Job Title Job Title Job Title932 | 15 | 4 | 2017-05-10 19:23:26.115394 | This is an empty list test
|
|
2017-05-18 12:04:00.228586 | 7B27RRBRB7 | 595Job Title Job Title Job Title Job Title932 | 15 | 4 | 2017-05-10 19:23:26.115394 | List should be populated now
|
|
2017-05-18 20:49:12.996077 | 7BW9B9R8BB | five thousand naira | 13 | 1 | 2017-08-02 14:19:38.711257 | About PayQuic\r +
|
|
| | | | | | PayQuic is global payments and airtime top-up company. Open for business 24/7, 365 d
|
|
2017-06-12 10:28:32.720786 | 601BBWRW48 | 595Job Title Job Title Job Title Job Title932 | 10 | 1 | 2017-08-09 16:08:43.503739 | <table><tbody><tr><td><div><span><br>can you share your controller method and did you tried <c
|
|
2017-06-12 10:28:41.932836 | 601BBWRW48 | 595Job Title Job Title Job Title Job Title932 | 10 | 1 | 2017-08-09 16:08:43.503739 | <table><tbody><tr><td><div><span><br>can you share your controller method and did you tried <c
|
|
|
|
*/
|
|
$jbx = "''/proj/thisjob''";
|
|
|
|
$mysql = " SELECT s.created,j.contract,j.title,j.id,j.status,j.delivery_date,substring(s.message,0,100),"
|
|
. " '<input type=submit onclick=\"return post_nav_find_action($jbx, '||j.id||')\" name=\"manage\" class=\"btn btn-success btn-xs btn-block\" value=\"View\">' "
|
|
. " FROM members_jobs_contract j "
|
|
. " RIGHT JOIN jobs_contract_message s ON s.contract=j.contract "
|
|
. " WHERE j.member_id=" . $_SESSION['member_id'] . " OR j.client_id = " . $_SESSION['member_id'] . " AND j.status IN (1,4)";
|
|
|
|
$mysql = " SELECT s.created::date ||'<br>'||j.contract AS date_contract,'<b>Title:</b>'||j.title||'<br>'||substring(s.message,0,90) as title_message,"
|
|
. " '<input type=submit onclick=\"return post_nav_find_action($jbx, '||j.id||')\" name=\"manage\" class=\"btn btn-success btn-xs btn-block\" value=\"View\">' "
|
|
. " FROM members_jobs_contract j "
|
|
. " RIGHT JOIN jobs_contract_message s ON s.contract=j.contract "
|
|
. " WHERE j.member_id=" . $_SESSION['member_id'] . " AND j.delivery_date IS NOT NULL AND j.delivery_date > now() OR j.client_id = " . $_SESSION['member_id'] . " AND j.status IN (1,4) AND j.delivery_date IS NOT NULL AND j.delivery_date > now() LIMIT 5";
|
|
|
|
$query = $this->db->query($mysql);
|
|
|
|
|
|
$this->load->library('table');
|
|
$this->table->set_template($this->template);
|
|
$this->table->set_heading(array('data' => 'Date', 'style' => 'width:180px'), 'Title/Message', array('data' => '', 'style' => 'width:100px; cellpadding:0px;'));
|
|
|
|
$data['job_message_table'] = $this->table->generate($query);
|
|
|
|
return $data;
|
|
}
|
|
|
|
private function dash_title() {
|
|
|
|
$offer_found = false;
|
|
|
|
$data = array();
|
|
$data['offer_dash'] = '';
|
|
$this->load->library('table');
|
|
$this->table->set_template($this->template);
|
|
|
|
$jbx = "''/jobs/viewjob''";
|
|
$mysql = "SELECT jo.added::date,j.title,"
|
|
. "'<input type=submit onclick=\"return post_nav_find_action($jbx,'''||jo.offer_code||''')\" name=\"manage\" class=\"btn btn-primary btn-xs\" value=\"View\">' AS View "
|
|
. "FROM members_jobs_offer jo LEFT JOIN members_jobs j ON j.id = jo.job_id "
|
|
. "WHERE jo.expire > now() AND jo.status = 1 "
|
|
. "AND jo.client_id = " . $_SESSION['member_id'] . " LIMIT 4";
|
|
// . 'CASE WHEN jo.status = 1 THEN \'Pending\' ELSE \'Other\' END AS status,'
|
|
$query = $this->db->query($mysql);
|
|
|
|
$num = $query->num_rows();
|
|
|
|
$data["dash_title"] = "Pending Offer(s)";
|
|
if ($num > 0) {
|
|
|
|
|
|
|
|
// array('data' => 'Added', 'style' => 'width:80px')
|
|
|
|
$this->table->set_heading(array('data' => 'Added', 'style' => 'width:80px'), 'Title', array('data' => '', 'style' => 'width:80px'));
|
|
$data['offer_dash'] = $this->table->generate($query);
|
|
$offer_found = true;
|
|
} else {
|
|
$data["offer_dash"] = "<div class=\"thumb\"><img src='assets/images/notask.png' alt=\"Active Projects\"></div>";
|
|
}
|
|
|
|
|
|
if ($offer_found == false) {
|
|
$data["dash_title"] = "<a href='/jobs/pendingoffer'>My Pending Offer(s)</a>";
|
|
$jbx = "''/jobs/viewmyjob''";
|
|
$mysql = "SELECT jo.added::date||'<br>'||jo.expire::date,j.title||'<br><b>To :</b>'||(CASE WHEN jo.public_view > 0 THEN '-Public View' ELSE jo.email END) AS tRec,"
|
|
. 'CASE WHEN jo.status = 1 AND jo.public_view =0 THEN \'Pending\' WHEN jo.status = 1 AND jo.public_view >0 THEN \'Active\' ELSE \'Other\' END AS status,'
|
|
. "'<input type=submit onclick=\"return post_nav_find_action($jbx,'''||jo.offer_code||''')\" name=\"manage\" class=\"btn btn-primary btn-xs\" value=\"View\">' AS View "
|
|
. "FROM members_jobs_offer jo LEFT JOIN members_jobs j ON j.id = jo.job_id "
|
|
. "WHERE jo.expire > now() AND jo.status = 1 "
|
|
. "AND jo.member_id = " . $_SESSION['member_id'] . " ORDER BY jo.id DESC LIMIT 4";
|
|
|
|
$query = $this->db->query($mysql);
|
|
|
|
$num = $query->num_rows();
|
|
|
|
if ($num > 0) {
|
|
// array('data' => 'Status', 'style' => 'width:150px')
|
|
//array('data' => 'Added', 'style' => 'width:150px')
|
|
//array('data' => 'Added', 'style' => 'width:150px')
|
|
|
|
$this->table->set_heading(array('data' => 'Added/Expire', 'style' => 'width:120px'), 'Title/Recipient', array('data' => 'Status', 'style' => 'width:100px'), array('data' => '', 'style' => 'width:100px'));
|
|
$data['offer_dash'] = $this->table->generate($query);
|
|
$offer_found = true;
|
|
}
|
|
}
|
|
|
|
return $data;
|
|
}
|
|
|
|
public function howitworks() {
|
|
$data = $this->getSessionArray();
|
|
|
|
$data['page_key'] = 'WRB_MAIN_HOWIT_WORK';
|
|
|
|
$data['txt_detail'] = $this->readFixedText($data['page_key']);
|
|
|
|
|
|
|
|
$data['txt_detail'] = str_replace("[how-it-worked-image-1]", "<img src='/assets/images/howitworks/howitworks-1.jpg' alt=''>", $data['txt_detail']);
|
|
$data['txt_detail'] = str_replace("[how-it-worked-image-2]", "<img src='/assets/images/howitworks/howitworks-2.jpg' alt=''>", $data['txt_detail']);
|
|
|
|
$data['page_title'] = "How it Works";
|
|
|
|
$this->load->view('users/view_header_user', $data);
|
|
$this->load->view('users/view_howitworks', $data);
|
|
$this->load->view('users/view_footer_user', $data);
|
|
//echo "here-here";
|
|
}
|
|
|
|
public function howfindwork() {
|
|
$data = $this->getSessionArray();
|
|
|
|
$data['page_key'] = 'WRB_MAIN_HOWIT_WORK';
|
|
|
|
$data['txt_detail'] = $this->readFixedText($data['page_key']);
|
|
|
|
|
|
|
|
$data['txt_detail'] = str_replace("[how-it-worked-image-1]", "<img src='/assets/images/howitworks/howitworks-1.jpg' alt=''>", $data['txt_detail']);
|
|
$data['txt_detail'] = str_replace("[how-it-worked-image-2]", "<img src='/assets/images/howitworks/howitworks-2.jpg' alt=''>", $data['txt_detail']);
|
|
|
|
$data['page_title'] = "How to find Job";
|
|
|
|
$this->load->view('users/view_header_user', $data);
|
|
$this->load->view('users/view_howfindjob', $data);
|
|
$this->load->view('users/view_footer_user', $data);
|
|
//echo "here-here";
|
|
}
|
|
|
|
public function howpostjob() {
|
|
$data = $this->getSessionArray();
|
|
|
|
$data['page_key'] = 'WRB_MAIN_HOWIT_WORK';
|
|
|
|
$data['txt_detail'] = $this->readFixedText($data['page_key']);
|
|
|
|
|
|
|
|
$data['txt_detail'] = str_replace("[how-it-worked-image-1]", "<img src='/assets/images/howitworks/howitworks-1.jpg' alt=''>", $data['txt_detail']);
|
|
$data['txt_detail'] = str_replace("[how-it-worked-image-2]", "<img src='/assets/images/howitworks/howitworks-2.jpg' alt=''>", $data['txt_detail']);
|
|
|
|
$data['page_title'] = "How to Post Job";
|
|
|
|
$this->load->view('users/view_header_user', $data);
|
|
$this->load->view('users/view_howpostjob', $data);
|
|
$this->load->view('users/view_footer_user', $data);
|
|
//echo "here-here";
|
|
}
|
|
|
|
}
|