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;
}
