public function update_product_rating_count($productId, $updateArr) { $totalRating = total_rating($updateArr['rating1'], $updateArr['rating2'], $updateArr['rating3'], $updateArr['rating4'], $updateArr['rating5']); $avgRating = total_avrage_rating($updateArr['rating1'], $updateArr['rating2'], $updateArr['rating3'], $updateArr['rating4'], $updateArr['rating5']); $updateOpt = array('productRating1' => $updateArr['rating1'], 'productRating2' => $updateArr['rating2'], 'productRating3' => $updateArr['rating3'], 'productRating4' => $updateArr['rating4'], 'productRating5' => $updateArr['rating5'], 'totalProductRating' => $totalRating, 'avgProductRating' => $avgRating, 'lastModifiedDt' => date('Y-m-d H:i:s'), 'lastModifiedBy' => $this->session->userdata('userId')); $this->db->where(array('productId' => $productId, 'active' => 1)); $this->db->update('product_rating_count', $updateOpt); return $this->db->affected_rows(); }
function total_avrage_rating($rating_1 = 0, $rating_2 = 0, $rating_3 = 0, $rating_4 = 0, $rating_5 = 0) { $totalDiv = total_rating($rating_1, $rating_2, $rating_3, $rating_4, $rating_5); $rating_1 = rating1($rating_1); $rating_2 = rating2($rating_2); $rating_3 = rating3($rating_3); $rating_4 = rating4($rating_4); $rating_5 = rating5($rating_5); $total = total_rating($rating_1, $rating_2, $rating_3, $rating_4, $rating_5); $avrage = $total / $totalDiv; return $avrage; }