public function getallrate() { $obj = new helpers(); $resultsPerPage = 3; $paged = Input::get('page'); $product_id = Input::get('product_id'); if ($paged > 0) { $page_limit = $resultsPerPage * $paged; $next_check_page = $page_limit + 3; } else { $page_limit = 0; $next_check_page = 1; } $rating = DB::table('product_rating')->leftJoin('brandmembers', 'brandmembers.id', '=', 'product_rating.user_id')->select('product_rating.*', 'brandmembers.username as buser')->where('product_rating.status', 1)->where('product_rating.product_id', $product_id)->orderBy('product_rating.created_on', 'DESC')->skip($page_limit)->take($resultsPerPage)->get(); // For Next load more $rating_count_arr = DB::table('product_rating')->leftJoin('brandmembers', 'brandmembers.id', '=', 'product_rating.user_id')->select('product_rating.*')->where('product_rating.status', 1)->where('product_rating.product_id', $product_id)->skip($next_check_page)->take($resultsPerPage)->get(); foreach ($rating as $prate) { ?> <div class="rating_block clearfix"> <h5 class="text-capitalize"><?php echo $prate->rating_title; ?> </h5> <div class="total_rev"><p> “ <?php echo $prate->comment; ?> ”</p> <div class="ratn_box"> <div id="rate<?php echo $prate->rating_id; ?> "></div> </div> </div> <div class="bot_rev"> <p class="author pull-left">Authored by <a href=""><?php echo !empty($prate->username) ? $prate->username : $prate->buser; ?> </a> </p> <p class="date pull-left"><?php echo $obj->time_elapsed_string(strtotime($prate->created_on)); ?> </p> </div> </div> <script> $(document).ready(function(){ $('#rate<?php echo $prate->rating_id; ?> ').raty({ readOnly: true, score: <?php echo $prate->rating_value; ?> , starHalf : '<?php echo url(); ?> /public/frontend/css/images/star-half.png', starOff : '<?php echo url(); ?> /public/frontend/css/images/star-off.png', starOn : '<?php echo url(); ?> /public/frontend/css/images/star-on.png' , }); }); </script> <?php } // if(count($rating) == $resultsPerPage){ if (count($rating_count_arr) > 0) { ?> <!-- <button class="loadmore" data-page="<?php echo $paged + 1; ?> ">Load More</button> --> <div class="wrap_load"> <a href="javascript:void(0);" class="btn btn-special loadmore" data-page="<?php echo $paged + 1; ?> ">View More Reviews</a><span class="disable_click"></span> </div> <?php } // else{ // echo "<h3>No More Rating</h3>"; // } }