/** * Remove reviews * * @access private * @param nil * @return content */ function removeReview() { //Load helpers $this->load->helper('reviews'); $project_id = $this->uri->segment('4'); $user_type = $this->uri->segment('5'); $userid = $this->uri->segment('6'); $toEmail = getUserDetails($userid, 'email'); $uname = getUserDetails($userid, 'user_name'); $num_rev = getUserDetails($userid, 'num_reviews'); //remove review $conditions = array('project_id' => $project_id, 'review_type' => $user_type); //pr($conditions);exit; $this->dispute_model->deleteReview($conditions); //Reduce number of reviews for user if ($this->db->affected_rows() == 1) { $rType = 'buyer_id'; if ($user_type == 2) { $rType = 'provider_id'; } $rating = getAvgReview($userid, $rType); $updateData = array('user_rating' => $rating, 'num_reviews' => $num_rev - 1); $this->skills_model->updateUsers($userid, $updateData); } //Get project details $conditions2 = array('projects.id' => $project_id); $res = $this->skills_model->getProjects($conditions2, 'projects.id,projects.project_name'); $prow = $res->row(); //Send Mail to users $conditionUserMail = array('email_templates.type' => 'remove_review'); $result = $this->email_model->getEmailSettings($conditionUserMail); $rowUserMailConent = $result->row(); //Update the details $splVars = array("!project_name" => site_url('project/view/' . $prow->id), "!user" => $uname, '!project_title' => $prow->project_name, '!site_title' => $this->config->item('site_title'), "!contact_url" => site_url('contact')); $mailSubject = strtr($rowUserMailConent->mail_subject, $splVars); $mailContent = strtr($rowUserMailConent->mail_body, $splVars); $toEmail = $toEmail; $fromEmail = $this->config->item('site_admin_mail'); $this->email_model->sendHtmlMail($toEmail, $fromEmail, $mailSubject, $mailContent); echo $this->lang->line("Review is removed"); }
echo $class; ?> "><?php echo getProjectStatus($reviewDetail->project_status); ?> </td> <td class="<?php echo $class; ?> "> <?php $buyer = getUserInfo($reviewDetail->buyer_id); ?> <?php $chj = getAvgReview($reviewDetail->buyer_id, 'buyer_id'); echo $buyer->user_name; ?> <img src="<?php echo image_url('rating_' . $chj . '.gif'); ?> " />( <a href="<?php echo site_url('buyer/review/' . $buyer->id); ?> "> <?php echo getNumReviews($reviewDetail->buyer_id, 'buyer_id') . " reviews"; ?> </a> )</td> <td class="<?php echo $class;
echo $class; ?> "><?php echo getProjectStatus($reviewDetail->project_status); ?> </td> <td class="<?php echo $class; ?> "> <?php $buyer = getUserInfo($reviewDetail->provider_id); ?> <?php $chj = getAvgReview($reviewDetail->provider_id, 'provider_id'); echo $buyer->user_name; ?> <img src="<?php echo image_url('rating_' . $chj . '.gif'); ?> " /> ( <a href="<?php echo site_url('programmer/review/' . $buyer->id); ?> "> <?php echo getNumReviews($reviewDetail->provider_id, 'provider_id') . " reviews"; ?> </a> ) </td> <td class="<?php