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; // 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 { $this->load->view('users/view_header_user', $data); $this->load->view('users/view_active', $data); $this->load->view('users/view_footer_user', $data); } } public function active() { $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; // 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 { $this->load->view('users/view_header_user', $data); $this->load->view('users/view_active', $data); $this->load->view('users/view_footer_user', $data); } } public function offerinterest() { $data = $this->getSessionArray(); $jaction = "''/jobs/jobinterest''"; $mysql = "SELECT to_char(mi.added, 'YYYY-MM-DD HH24:MI') AS added,jo.offer_code,mjs.title," . "m.firstname||' '||m.lastname AS Client," . " '

' AS view " . "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"; //jo.status=1 AND $this->load->library('pagination'); $config = array(); $query = $this->db->query($mysql); $config["total_rows"] = $query->num_rows(); $data['dash_title'] = "Public Offer Interset [" . $config["total_rows"] . "]"; $config["base_url"] = base_url() . "/jobs/offerinterest"; $config["per_page"] = 5; $config["uri_segment"] = 3; $config["num_links"] = 5; $config['full_tag_open'] = "

"; $config['full_tag_close'] = ""; $config['num_tag_open'] = '

'; $config['num_tag_close'] = '

'; $config['cur_tag_open'] = "

"; $config['cur_tag_close'] = "

"; $config['next_tag_open'] = "

"; $config['next_tagl_close'] = "

"; $config['prev_tag_open'] = "

"; $config['prev_tagl_close'] = "

"; $config['first_tag_open'] = "

"; $config['first_tagl_close'] = "

"; $config['last_tag_open'] = "

"; $config['last_tagl_close'] = "

"; $this->pagination->initialize($config); $page = ($this->uri->segment(3)) ? $this->uri->segment(3) : 0; $page = is_numeric($page) ? $page : 0; // '||jo.offer_code||'' AS added_code,mjs.title," . "m.firstname AS Client," . " '

' AS view " . "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 LIMIT " . $config["per_page"] . " OFFSET " . $page; //jo.status=1 AND $this->load->library('table'); $this->table->set_template($this->template); $query = $this->db->query($mysql); $this->table->set_heading(array('data' => 'Added/ID', 'style' => 'width:100px'), 'Title', 'Client', array('data' => 'Action', 'style' => 'width:70px')); /* $this->table->set_heading( array('data' => 'Added', 'style' => 'width:120px'), array('data' => 'Action', 'style' => 'width:100px')); */ $data['job_interest_table'] = $this->table->generate($query); $data["links"] = $this->pagination->create_links(); $this->load->view('users/view_header_user', $data); $this->load->view('jobs/view_pendinginterest', $data); $this->load->view('users/view_footer_user', $data); } public function jobinterest() { $data['message_list'] = ''; $interest_id = $this->input->post('interest_id'); $data = $this->getSessionArray(); $jaction = "''/jobs/jobinterest''"; $data['total_jobs_completed'] = $data['total_jobs_active'] = $data['total_jobs_uncompleted'] = $data['total_pending_offers'] = 0; $data['dash_title'] = 'Manage Offer Interset'; $mysql = "SELECT to_char(mi.added, 'YYYY-MM-DD') AS added,jo.offer_code,mjs.title," . "m.firstname AS Client,mi.offer_id,m.id AS client_id, mi.id AS interest_id,md.description AS client_description,m.added::date AS client_added," . " '

' ELSE '' END) AS Sel " . "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.offer_id=" . $row['offer_id'] . " " . "AND mi.id <> $interest_id ORDER BY mi.added ASC"; //AND jo.status=1 AND jo.expire> now() $query2 = $this->db->query($mysql); } else { } $this->load->library('table'); $this->table->set_template($this->template); $this->table->set_heading(array('data' => 'Added', 'style' => 'width:120px'), 'Interested Client', array('data' => 'Status', 'style' => 'width:90px'), array('data' => '', 'style' => 'width:90px')); $data['job_others_interest_table'] = $this->table->generate($query2); $this->load->view('users/view_header_user', $data); $this->load->view('jobs/view_manageinterest', $data); $this->load->view('users/view_footer_user', $data); } private function getMarketInterestMessage($offer_code, $client_id) { $data = $this->getSessionArray(); $member_id = $_SESSION['member_id']; $mysql = "SELECT m.firstname, s.added::date as msg_added,s.msg FROM members_messages s LEFT JOIN members m ON m.id=s.senders_id " . "WHERE s.msg_type='MRKTINT' AND s.memo='$offer_code' " . "AND s.member_id=$client_id AND s.senders_id = $member_id " . "OR s.member_id= $member_id AND s.senders_id=$client_id " . "ORDER BY s.id DESC LIMIT 4"; $query = $this->db->query($mysql); $tmsg = ""; foreach ($query->result() as $row) { $tmsg .= "" . $row->msg_added . " - From:" . $row->firstname; $tmsg .= "
"; $tmsg .= $row->msg; $tmsg .= "

"; } return $tmsg; } public function jobinterest_modal() { $interest_id = $this->input->get('interest_id'); $data = $this->getSessionArray(); $mysql = "SELECT to_char(mi.added, 'YYYY-MM-DD') AS added,jo.offer_code,mjs.title," . "m.firstname AS Client,mi.offer_id,m.id AS client_id, mi.id AS interest_id,md.description AS client_description,m.added::date AS client_added," . " '

' AS view " . "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 " . "LEFT JOIN members_detail md ON md.member_id=m.id " . "WHERE jo.member_id =" . $_SESSION['member_id'] . " " . " AND mi.id=" . $interest_id . " " . "AND jo.status=1 AND mi.status = 1 AND jo.expire> now() ORDER BY mi.added ASC"; $query = $this->db->query($mysql); $num = $query->num_rows(); if ($num > 0) { $row = $query->row_array(); //$data['added'] = $row['added']; $data['client'] = $row['client']; //$data['title'] = $row['title']; //$data['offer_code'] = $row['offer_code']; //$data['interest_id'] = $row['interest_id']; // The interested member id is here $data['client_description'] = $row['client_description']; $data['skills_set'] = $this->getUserSavedSkillsSet($row['client_id']); } else { $data["client"] = "Undefined"; $data["client_description"] = "Failed to load client"; $data["skills_set"] = ""; } $this->load->view('jobs/view_manageinterest_modal', $data); } public function loaduserSkills() { $member_id = $this->input->get('interest_id'); $data = $this->getSessionArray(); $mysql = "SELECT to_char(m.added, 'YYYY-MM-DD') AS added,m.firstname AS client,m.id AS client_id," . "md.description AS client_description " . "FROM members m " . "LEFT JOIN members_detail md ON md.member_id=m.id " . "WHERE m.id=" . $_SESSION['member_id']; $query = $this->db->query($mysql); $num = $query->num_rows(); if ($num > 0) { $row = $query->row_array(); $data['client'] = $row['client']; $data['client_description'] = $row['client_description']; } else { $data["client"] = "Undefined"; $data["client_description"] = "No entry yet..."; $data["skills_set"] = ""; } $data['skills_set'] = $this->getUserSavedSkillsSet($member_id); $this->load->view('jobs/view_manageinterest_modal', $data); } public function offerdetail_modal() { $contract_id = trim($this->input->get('contact_id')); $data = $this->getSessionArray(); $mysql = " SELECT j.title,j.price,j.timeline_days,j.job_detail,j.description FROM members_jobs j LEFT JOIN members_jobs_offer jo ON jo.job_id = j.id WHERE jo.offer_code='$contract_id' "; $query = $this->db->query($mysql); $num = $query->num_rows(); if ($num > 0) { $data = $query->row_array(); $data['contract_id'] = $contract_id; $this->load->view('jobs/modals/view_offerdetail_modal', $data); } } public function jobdetail_modal() { $contract_id = trim($this->input->get('contact_id')); $data = $this->getSessionArray(); $mysql = " SELECT title,price,delivery_date,job_detail,description,delivery_date FROM members_jobs_contract WHERE contract='$contract_id' "; $query = $this->db->query($mysql); $num = $query->num_rows(); if ($num > 0) { $data = $query->row_array(); $data['contract_id'] = $contract_id; $this->load->view('jobs/modals/view_jobdetail_modal', $data); } } public function jobinterest_modal_BAK() { $interest_id = $this->input->get('interest_id'); $data = $this->getSessionArray(); $mysql = "SELECT to_char(mi.added, 'YYYY-MM-DD') AS added,jo.offer_code,mjs.title," . "m.firstname AS Client,mi.offer_id,m.id AS client_id, mi.id AS interest_id,md.description AS client_description,m.added::date AS client_added," . " '

" . $row["category"] . "-" . $row["skill"] . "

"; return $skills; } public function procinterest() { // url: "/jobs/procinterest?proc=ACCEPT&interest_id=" + interest_id // url: "/jobs/procinterest?proc=REJECT&interest_id=" + interest_id // url: "/jobs/procinterest?proc=CANCEL&interest_id=" + interest_id $data = $this->getSessionArray(); $data['interest_id'] = $this->input->get('interest_id'); $proc = $this->input->get('proc'); $data['interest'] = 0; switch ($proc) { case 'ACCEPT': $data['interest'] = JOB_INTEREST_ACCEPT; break; case 'REJECT': $data['interest'] = JOB_INTEREST_REJECT; break; case 'CANCEL': $data['interest'] = JOB_INTEREST_CANCEL; break; } if ($data['interest'] > 0) { $data['action'] = WRENCHBOARD_JOB_PROC_INTEREST; $this->load->model('backend_model'); $out = array(); $res = $this->backend_model->wrenchboard_api($data, $out); if ($res == PHP_CREATED_OK) { echo 'Success - ' . $out['status']; } else { echo 'Error - ' . $out['status']; } } // echo "AMEYE $interest_id $proc "; } private function vjobinterest() { // //echo 'ameye'; $data = $this->getSessionArray(); $data['dash_title'] = 'Yes Public Offer Interset'; $mysql = "SELECT to_char(mi.added, 'YYYY-MM-DD HH24:MI') AS added,jo.offer_code,mjs.title," . "m.firstname||' '||m.lastname AS Client," . " '

' AS view " . "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 jo.status=1 AND jo.expire> now() ORDER BY mi.added ASC"; $this->load->library('table'); $this->table->set_template($this->template); $query = $this->db->query($mysql); $this->table->set_heading(array('data' => 'Added', 'style' => 'width:140px'), 'Code', 'Title', 'Client', array('data' => 'Action', 'style' => 'width:90px')); $data['job_interest_table'] = $this->table->generate($query); $this->load->view('users/view_header_user', $data); $this->load->view('jobs/vofferinterest', $data); $this->load->view('users/view_footer_user', $data); } public function viewjob() { $data = $this->getSessionArray(); $jobOfferID = $this->input->post('jobOfferID'); $data['jobOfferID'] = $jobOfferID; if ($jobOfferID != '') { $this->load->model('job_model'); $out = $this->job_model->loadJobOffer($_SESSION['member_id'], $jobOfferID); // print_r($out); if ($out['result'] == 1) { $data["added_date"] = $out["added_date"]; $data["title"] = $out["title"]; $data["description"] = $out["description"]; $data["timeline_days"] = $out["timeline_days"]; $data["price"] = $out["price"]; $data["offer_code"] = $out["offer_code"]; $data["job_description"] = $out["job_description"]; $date = date_create($out["expire"]); $out["expire"] = date_format($date, 'Y-m-d H:i'); $data["expire"] = $out["expire"]; $this->load->view('users/view_header_user', $data); $this->load->view('jobs/view_viewjoboffer', $data); $this->load->view('users/view_footer_user', $data); } else { redirect('dash'); // go back to dash if not valid } } else { redirect('dash'); // go back to dash if not valid } } public function market() { $data = array(); $data = $this->getSessionArray(); $data['offer_dash'] = ''; $this->load->library('table'); $this->table->set_template($this->template); $data["dash_title"] = "Available Jobs & Tasks"; $mysql = 'SELECT 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 expire> now() AND 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'] = ''; } $_SESSION['secure_data'] = $data; // all data needed for secure page $data['page_title'] = "Available Jobs & Tasks"; $this->load->view('users/view_header_user', $data); $this->load->view('jobs/view_market', $data); $this->load->view('users/view_footer_user', $data); } private function makeMarketTableRow($row) { return "" . $row['offer_code'] . "" . $row['title'] . "" . "

"; } public function showinterest() { $data = $this->getSessionArray(); $data['offer_code'] = $this->input->get('job_contract'); $data['member_id'] = $_SESSION['member_id']; // just maing sure $data['action'] = WRENCHBOARD_JOB_SEND_INTEREST; $this->load->model('backend_model'); $out = array(); $res = $this->backend_model->wrenchboard_api($data, $out); if ($res == PHP_CREATED_OK) { echo 'Success - ' . $out['status']; } else { echo 'Error - ' . $out['status']; } } public function marketrmessage() { $data = $this->getSessionArray(); // echo 'Ameye'; $data['offer_code'] = $this->input->get('offer_code'); $data['yourmessage'] = $this->input->get('yourmessage'); $data['member_id'] = $_SESSION['member_id']; // just maing sure $data['msg_type'] = 'JOB'; $data['action'] = WRENCHBOARD_JOB_SEND_QUESTION; // $this->load->model('backend_model'); $out = array(); $out['status'] = ''; $res = $this->wrenchboard_api($data, $out); if ($res == PHP_CREATED_OK) { echo 'Success - Message sent' . $out['status']; } else { echo 'Error - ' . $out['status']; } } public function offermessage() { $data = $this->getSessionArray(); // echo 'Ameye'; $data['offer_code'] = $this->input->get('offer_code'); $data['yourmessage'] = $this->input->get('yourmessage'); $data['interest_id'] = $this->input->get('interest_id'); $data['member_id'] = $_SESSION['member_id']; // just maing sure $data['msg_type'] = 'MRKTINT'; // MARKET INTEREST $data['action'] = WRENCHBOARD_JOB_MRKTINT_QUEST; // $this->load->model('backend_model'); $out = array(); $out['status'] = ''; $res = $this->wrenchboard_api($data, $out); // print_r($out); if ($res == PHP_CREATED_OK) { //echo rand(100,999)." " .$out['client_id']; echo $this->getMarketInterestMessage( $data['offer_code'], $out['client_id'] ); //'Success - Message sent' . $out['status']; } else { echo 'Error - ' . $out['status']; } } public function marketdetail() { $myTable = ''; $offer_code = $this->input->get('job_contract'); $mysql = "SELECT jo.id AS offer_id,jo.offer_code,mj.title,mj.description,mj.timeline_days,mj.price,jo.job_description,jo.expire::date 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.offer_code ='" . $offer_code . "' "; $query = $this->db->query($mysql); $num = $query->num_rows(); if ($num > 0) { $row = $query->row_array(); $myTable = ""; $myTable .= $this->makeMarketDetailTableRow($row); $myTable .="

"; } echo $myTable; } 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 "" . $row['offer_code'] . " Timeline:" . $row['timeline_days'] . " day(s) - Budget: " . $row['price'] * 0.01 . " Naira" . "Title" . $row['title'] . "" . "Description" . $row['description'] . "" . "Detail" . $row['job_description'] . "" . "Interests : " . $data['interest'] . " Expire: " . $row['expire']." " . "" . "If you have any questions about this task :" . "

" . "" . " "; } public function viewmyjob() { $data = $this->getSessionArray(); $jobOfferID = $this->input->post('jobOfferID'); $data['jobOfferID'] = $jobOfferID; if ($jobOfferID != '') { $this->load->model('job_model'); $out = $this->job_model->readMyloadJobOffer($_SESSION['member_id'], $jobOfferID); // print_r($out); if ($out['result'] == 1) { $data["job_sent_to"] = $out["job_sent_to"]; $data["added_date"] = $out["added_date"]; $data["title"] = $out["title"]; $data["description"] = $out["description"]; $data["timeline_days"] = $out["timeline_days"]; $data["price"] = $out["price"]; $data["offer_code"] = $out["offer_code"]; $data["job_description"] = $out["job_description"]; $date = date_create($out["expire"]); $out["expire"] = date_format($date, 'Y-m-d H:i'); $data["expire"] = $out["expire"]; $data['job_link'] = 'https://'.$_SERVER['HTTP_HOST']."/plb/viewjob/".$out['offer_code']; $this->load->view('users/view_header_user', $data); $this->load->view('jobs/view_viewmyjoboffer', $data); $this->load->view('users/view_footer_user', $data); } else { redirect('dash'); // go back to dash if not valid } } else { redirect('dash'); // go back to dash if not valid } } public function pendingoffer() { $data = array(); $data = $this->getSessionArray(); $data['offer_dash'] = ''; $this->load->library('table'); $this->table->set_template($this->template); $data["offer_dash"] = "

$\"Active$

"; $data["dash_title"] = "My Pending Offer(s)"; $jbx = "''/jobs/viewmyjob''"; $mysql = "SELECT jo.added::date||'
'||jo.expire::date,j.title||'
To :'||jo.email AS tRec," . 'CASE WHEN jo.status = 1 THEN \'Pending\' ELSE \'Other\' END AS status,' . "'' 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'] . "LIMIT 400"; $mysql = "SELECT jo.added::date||'
'||jo.expire::date,j.title||'
To :'||(CASE WHEN jo.public_view > 0 THEN '-Public View' ELSE jo.email END) AS tRec," . "'' 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 400"; // . '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,' $query = $this->db->query($mysql); $num = $query->num_rows(); if ($num > 0) { // array('data' => 'Added/Expire', 'style' => 'width:100px') $this->table->set_heading(array('data' => 'Added/Expire', 'style' => 'width:100px'), 'Title/Recipient', array('data' => ' ', 'style' => 'width:80px')); $data['offer_dash'] = $this->table->generate($query); $offer_found = true; } $_SESSION['secure_data'] = $data; // all data needed for secure page $data['page_title'] = "my Market Job(s)"; $this->load->view('users/view_header_user', $data); $this->load->view('jobs/view_pendingoffer', $data); $this->load->view('users/view_footer_user', $data); } public function jobgrp() { if (!isset($_SESSION['username']) or $_SESSION['username'] == '') { redirect(home); return; } $data = $this->getSessionArray(); $data["job_message"] = ""; $data["group_id"] = 0; if ($_POST && isset($_POST['del'])) { $group_id = $this->input->post('del'); $data['job_message'] = $this->deleteMemberGroup($group_id); } else if ($_POST && isset($_POST['delmember'])) { $data["group_id"] = $this->input->post('group_id') + 0; $member_id = $this->input->post('delmember') + 0; $data['job_message'] = $this->deleteMemberGroupMember($data["group_id"], $member_id); } else if ($_POST && isset($_POST['group_id'])) { $data["group_id"] = $this->input->post('group_id') + 0; $data['job_message'] = $this->addMemberGroupMember($data["group_id"]); } else if ($_POST) { $group_name = trim($this->input->post('group_name')); // echo 'ameye....'.$group_name ; $x = array(); $x['member_id'] = $_SESSION['member_id']; $x['group_name'] = $group_name; $x['action'] = WRENCHBOARD_JOB_CREATE_GROUP; $this->load->model('backend_model'); $out = array(); $res = $this->backend_model->wrenchboard_api($x, $out); if ($res == PHP_CREATED_OK) { // print_r($out); } else { $data['job_message'] = 'Unable to create job group...'; } } list($data['group_table'], $groups) = $this->getMembersJobGroup($data["group_id"]); if (count($groups) > 0) { if ($data["group_id"] > 0) { $data["group_name"] = $groups[$data["group_id"]]; } else { $data["group_name"] = reset($groups); $data["group_id"] = key($groups); } $data['group_member_table'] = $this->addGroupMemberForm($data["group_id"]) . $this->getJobGroupMembers($data["group_id"]); } else { $data["group_id"] = 0; $data["group_name"] = ""; $data["group_member_table"] = "Please add a group"; } $this->load->view('users/view_header_user', $data); $this->load->view('jobs/view_jobgroup', $data); $this->load->view('users/view_footer_user', $data); } public function jobgrp_members() { if (!isset($_SESSION['username']) or $_SESSION['username'] == '') { echo "Denied"; return; } $group_id = $this->input->get('group_id'); echo $this->addGroupMemberForm($group_id) . $this->getJobGroupMembers($group_id); } private function deleteMemberGroup($group_id) { $this->load->model('job_model'); return $this->job_model->deleteMemberGroup($group_id); } private function deleteMemberGroupMember($group_id, $group_member_id) { $this->load->model('job_model'); return $this->job_model->deleteMemberGroupMember($group_id, $group_member_id); } private function addMemberGroupMember($group_id) { $firstname = $this->input->post('firstname'); $lastname = $this->input->post('lastname'); $email = $this->input->post('email'); if ($firstname == '') return 'Invalid first name'; if ($lastname == '') return 'Invalid last name'; if ($email == '' || !filter_var($email, FILTER_VALIDATE_EMAIL)) return 'Invalid_e-mail'; $this->load->model('job_model'); return $this->job_model->addMemberGroupMember($group_id, $firstname, $lastname, $email); } private function getJobGroupMembers($group_id) { $this->load->model('job_model'); return $this->job_model->getJobGroupMembers($group_id); } private function getMembersJobGroup($sel) { $this->load->model('job_model'); return $this->job_model->getMembersJobGroup($sel); } private function addGroupMemberForm($group_id) { $this->load->model('job_model'); return $this->job_model->addGroupMemberForm($group_id); } public function create() { $data = $this->getSessionArray(); $mybalance = 0; $data['job_message'] = ''; // print_r($_SESSION); $title = NULL; $description = NULL; $job_detail = NULL; $timeline = NULL; // $timeline_days = NULL; $price = NULL; $submit = NULL; extract($_POST); $redirected = false; if ($_POST) { $in = array(); $in['title'] = $title; $in['description'] = $description; $in['timeline_days'] = $timeline; $in['job_detail'] =$this->input->post('job_detail'); // Somehow this doesnt show when large $job_detail; $in['price'] = $price * 100; $in['member_id'] = $_SESSION['member_id']; $this->load->model('job_model'); if ($this->job_model->verifyJobInputs($in) == true) { $in['action'] = WRENCHBOARD_JOB_CREATEJOB; $this->load->model('backend_model'); $out = array(); $res = $this->backend_model->wrenchboard_api($in, $out); if ($res == PHP_CREATED_OK) { // print_r($out); if ($out['job_id'] > 0) { $this->processingJob($out['job_id']); $redirected = true; } } else { $data['job_message'] = 'Unable to create job...'; } } else { $data['job_message'] = 'Enter all required fields'; } } if ($redirected == false) { $this->load->model('dash_model'); $out = $this->dash_model->getDashData($data); $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']; $this->load->view('users/view_header_user', $data); $this->load->view('jobs/view_create', $data); $this->load->view('users/view_footer_user', $data); } } public function processjob() { $jobID = $this->input->post('jobID'); if ($jobID > 0) { $this->processingJob($jobID); // $data = $this->getSessionArray(); } else { redirect('/jobs/manage'); } } public function jobagree() { $data = $this->getSessionArray(); //echo 'Ameye-- '. rand(100,999); //print_r($this->input->post()); if ($_POST) { $in = array(); $in['action'] = WRENCHBOARD_ACCOUNT_TERMS; $in['action_item'] = ACCOUNT_AGREE_JOBS; $in['member_id'] = $_SESSION['member_id']; $this->load->model('backend_model'); $out = array(); $res = $this->backend_model->wrenchboard_api($in, $out); if ($res == PHP_API_OK) { redirect('/jobs/create'); } } $data['page_key'] = 'WRB_POST_JOB_TERM'; $data['txt_detail'] = $this->readFixedText($data['page_key']); $this->load->view('users/view_header_user', $data); $this->load->view('jobs/view_jobagree', $data); $this->load->view('users/view_footer_user', $data); } private function processingJob($jobID) { // $jobID = $this->input->post('jobID'); if ($jobID > 0) { $data = $this->getSessionArray(); $this->load->model('combo_model'); $data['my_job_group'] = $this->combo_model->getUserJobGroupCombo('job_group', $_SESSION['member_id'], ''); $data['my_post_duration'] = $this->combo_model->getJobPostDuration('job_duration', 0); $this->load->library('table'); $this->table->set_template($this->template); $mysql = "SELECT title,description,timeline_days||' day(s)', price*0.01||'Naira' AS price, created::date" . " FROM members_jobs WHERE id =" . $jobID . " AND member_id = " . $_SESSION['member_id']; $query = $this->db->query($mysql); $this->table->set_heading('Title', 'Description', 'Timeline', 'Price', 'Created'); $data['job_table'] = $this->table->generate($query); $this->load->model('job_model'); // too bad I have to run again $jobData = $this->job_model->getJob($jobID); $data['job_description'] = $jobData->job_detail; $data['jobID'] = $jobID; $this->load->view('users/view_header_user', $data); $this->load->view('jobs/view_joboffer', $data); $this->load->view('users/view_footer_user', $data); } else { redirect('/jobs/manage'); } // echo "process job " . $jobID; } public function viewjob_accept() { // echo 'home....0'; $this->concludeOffer(OFFER_ACCEPT); } public function viewjob_reject() { //echo 'home....1'; $this->concludeOffer(OFFER_REJECT); } public function viewjob_cancel() { //echo 'home....1'; $this->concludeOffer(OFFER_CANCEL); } public function viewjob_sendtome() { $this->concludeOffer(OFFER_SENDTOME); } private function concludeOffer($offer_result) { //WRENCHBOARD_JOB_OFFER_CONCLUDE $jobOfferID = $this->input->get('jobOfferID'); $in = array(); $in['offer_code'] = $jobOfferID; $in['member_id'] = $_SESSION['member_id']; $in['offer_result'] = $offer_result; $in['action'] = WRENCHBOARD_JOB_OFFER_CONCLUDE; $this->load->model('backend_model'); $out = array(); $res = $this->backend_model->wrenchboard_api($in, $out); if ($out["result"] == "OK") { switch ($offer_result) { case OFFER_ACCEPT: echo "You have accepted this offer and we have notified the client. Please go to manage page to continue "; break; case OFFER_REJECT: echo "You have rejected this offer and we have notified the client."; break; case OFFER_CANCEL: echo "You have cancelled this offer and we have notified the recipient."; break; } } // print_r($out); } public function processjob_individ() { $jobID = $this->input->get('jobID'); $email = $this->input->get('rec_email'); $descr = urldecode( $this->input->get('jobdescription') ); if ($jobID == '' || $jobID < 1) { echo "Invalid job ID"; return; } if ($email == '' || !filter_var($email, FILTER_VALIDATE_EMAIL)) { echo "Invalid recipient e-mail"; return; } if ($descr == '') { echo "Missing job description"; return; } // echo $descr; $this->sendIndividualJobOffer($jobID, $email, $descr); } public function processjob_group() { $jobID = $this->input->get('jobID'); $group = $this->input->get('job_group'); $descr = urldecode( $this->input->get('jobdescription') ); if ($jobID == '' || $jobID < 1) { echo "Invalid job ID"; return; } if ($group == '' || $group < 1) { echo "Invalid group"; return; } if ($descr == '') { echo "Missing job description"; return; } $group_member_count = 0; $mysql = "SELECT count(id) AS m_count FROM members_job_groupmember WHERE group_id = $group AND member_id= ". $_SESSION['member_id']; $query = $this->db->query($mysql); if ( $query->num_rows()> 0 ) { $qr = $query->result_array(); // print_r($qr); $group_member_count = $qr[0]['m_count']; } if( $group_member_count == 0 ) { echo "cannot send job to empty group"; return; } // echo $jobID." ".$group; $this->sendGroupJobOffer($jobID, $group, $descr); } public function processjob_public() { $jobID = $this->input->get('jobID'); $job_duration = $this->input->get('job_duration'); $descr = urldecode( $this->input->get('jobdescription') ); if ($jobID == '' || $jobID < 1) { echo "Invalid job ID"; return; } if ($job_duration == '' || $job_duration < 1) { echo "Invalid Duration"; return; } if ($descr == '') { echo "Missing job description"; return; } $this->sendPublicJobOffer($jobID, $job_duration, $descr); // echo 'Ameye'; } private function sendPublicJobOffer($jobID, $duration, $descr) { // this function will handle the call to backend // to manage the sending of offer to group of people $in["job_id"] = $jobID; $in["duration"] = $duration; $in["job_description"] = $descr; $in['member_id'] = $_SESSION['member_id']; //var_dump($in); $in['action'] = WRENCHBOARD_JOB_OFFER_PUBLIC; $this->load->model('backend_model'); $out = array(); $res = $this->backend_model->wrenchboard_api($in, $out); $out["status"] = ''; //$res = $this->wrenchboard_api($in, $out); // print_r($out); if ($res == PHP_CREATED_OK) { // echo "Offer sent to public"; echo "

We have placed this offer in the public domain. This offer would expire in days you have specified. You will receive email alerts if anybody is interested.

"; } else { echo "

Unable to send offer :" . $out["status"] . "

"; } //echo 'Group Result'; } private function sendIndividualJobOffer($jobID, $email, $descr) { // this function will handle sending offer to invidual $in["job_id"] = $jobID; $in["email"] = $email; $in["job_description"] = $descr; $in['member_id'] = $_SESSION['member_id']; // var_dump($in); $in['action'] = WRENCHBOARD_JOB_OFFER_INDVI; $this->load->model('backend_model'); $out = array(); $res = $this->backend_model->wrenchboard_api($in, $out); if ($res == PHP_CREATED_OK) { // echo "Offer sent"; echo "

We have notified the user/email about this offer. This offer would expire in a day if the recipient did nothing.

"; } else { echo "

We are unable to send the offer to the recipient. This is usually caused by an insufficient balance in your account to pay for the task.

"; } // echo 'Individual Result'; } private function sendGroupJobOffer($jobID, $group, $descr) { // this function will handle the call to backend // to manage the sending of offer to group of people $in["job_id"] = $jobID; $in["group_id"] = $group; $in["job_description"] = $descr; $in['member_id'] = $_SESSION['member_id']; //var_dump($in); $in['action'] = WRENCHBOARD_JOB_OFFER_GROUP; $this->load->model('backend_model'); $out = array(); $res = $this->backend_model->wrenchboard_api($in, $out); if ($res == PHP_CREATED_OK) { echo "

We have notified each members by email about this offer. This offer would automatically expire in a day if the recipient(s) did nothing.

"; } else { // echo "Unable to send offer"; echo "

We are unable to send the offer to the recipient. This is usually caused by an insufficient balance in your account to pay for the task.

"; } //echo 'Group Result'; } public function deletejob() { $data = $this->getSessionArray(); $jobID = $this->input->get('job_id'); if ($jobID != '' AND $jobID > 0) { $in["job_id"] = $jobID; $in['member_id'] = $_SESSION['member_id']; $in['action'] = WRENCHBOARD_JOB_DELETEJOB; $this->load->model('backend_model'); $out = array(); $this->backend_model->wrenchboard_api($in, $out); echo $out['status']; } } public function manage() { $data = $this->getSessionArray(); $this->load->library('table'); $this->table->set_template($this->template); $jbx = "''/jobs/processjob''"; $mysql = "SELECT 'Date: '||created::date||'
Timeline: '||timeline_days||' day(s)'||'
Price: '||price*0.01||' ' AS Job," . " 'Title: '||title||'
Description: '||description AS detail, " . " '

' AS manage" . " FROM members_jobs WHERE member_id = " . $_SESSION['member_id'] . " AND status=1 ORDER BY id DESC"; $this->load->library('pagination'); $config = array(); $query = $this->db->query($mysql); $config["total_rows"] = $query->num_rows(); $config["base_url"] = base_url() . "/jobs/manage"; $config["per_page"] = 5; $config["uri_segment"] = 3; $config["num_links"] = 5; $config['full_tag_open'] = "

"; $config['full_tag_close'] = ""; $config['num_tag_open'] = '

'; $config['num_tag_close'] = '

'; $config['cur_tag_open'] = "

"; $config['cur_tag_close'] = "

"; $config['next_tag_open'] = "

"; $config['next_tagl_close'] = "

"; $config['prev_tag_open'] = "

"; $config['prev_tagl_close'] = "

"; $config['first_tag_open'] = "

"; $config['first_tagl_close'] = "

"; $config['last_tag_open'] = "

"; $config['last_tagl_close'] = "

"; $this->pagination->initialize($config); $page = ($this->uri->segment(3)) ? $this->uri->segment(3) : 0; $mysql = "SELECT 'Date: '||created::date||'
Timeline: '||timeline_days||' day(s)'||'
Price: '||price*0.01||' ' AS Job," . " 'Title: '||title||'
Description: '||description AS detail, " . " '

' AS manage" . " FROM members_jobs WHERE member_id = " . $_SESSION['member_id'] . " AND status=1 ORDER BY id DESC LIMIT " . $config["per_page"] . " OFFSET " . $page; $query = $this->db->query($mysql); $this->table->set_heading(array('data' => 'Job/Task', 'style' => 'width:150px'), 'Title/Description', array('data' => 'Manage', 'style' => 'width:120px')); $data["links"] = $this->pagination->create_links(); // array('data' => 'Del.', 'style' => 'width:80px') $data['page_title'] = "Manage Job(s)"; $data['job_table'] = $this->table->generate($query); $this->load->view('users/view_header_user', $data); $this->load->view('jobs/view_manage', $data); $this->load->view('users/view_footer_user', $data); } }