Untitled

<?php

//fetch.php

$connect = new PDO('mysql:host=localhost;dbname=manpower', 'root', '');

$query = "
SELECT * FROM supplier_job WHERE jobStatus='offline' order by jobID DESC
";
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
$output = '';
foreach($result as $row)
{
    $rating = count_rating($row['jobID'], $connect);
    $color = '';
    $output .= '

 <ul class="list-inline" data-rating="'.$rating.'" title="Average Rating - '.$rating.'">
 ';

    for($count=1; $count<=5; $count++)
    {
        if($count <= $rating)
        {
            $color = 'color:#ffcc00;';
        }
        else
        {
            $color = 'color:#ccc;';
        }
        $output .= '<li title="'.$count.'" jobID="'.$row['jobID'].'-'.$count.'" data-index="'.$count.'"  data-job_id="'.$row['jobID'].'" data-rating="'.$rating.'" class="rating" style="cursor:pointer; '.$color.' font-size:16px;">&#9733;</li>';
    }
    $output .= '
 </ul>
 ';
}
echo $output;

function count_rating($job_id, $connect)
{
    $output = 0;
    $query = "SELECT AVG(rating) as rating FROM ratings WHERE job_id = '".$job_id."'";
    $statement = $connect->prepare($query);
    $statement->execute();
    $result = $statement->fetchAll();
    $total_row = $statement->rowCount();
    if($total_row > 0)
    {
        foreach($result as $row)
        {
            $output = round($row["rating"]);
        }
    }
    return $output;
}


?>

<?php
$servername="localhost";
$username="root";
$password="";
$databasename="manpower";

//create connection
$conn=mysqli_connect($servername,$username,$password,$databasename);

    $queryJob="SELECT * FROM supplier_job WHERE jobStatus='offline' order by jobID DESC";

    $resultJob=mysqli_query($conn,$queryJob);
    if(mysqli_num_rows($resultJob)>0){
        while($rowJob=mysqli_fetch_assoc($resultJob)){

            $locationID=$rowJob['locationID'];
            $queryLocation="SELECT * FROM location WHERE locID='$locationID'";
            $resultLocation=mysqli_query($conn,$queryLocation);

            $rowLocation=mysqli_fetch_assoc($resultLocation);
            $locationName=$rowLocation['locName'];
            $locationAddress=$rowLocation['locStreet'].", ".$rowLocation['locVillage'].", ".$rowLocation['locCity'];


            echo "
<html>
<head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script>
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>

<div class='single-post d-flex flex-row'><div class='thumb'>
                    <img src='../img/img-worker/post.png' alt=''>
                    </div>
                <div class='details'>
                    <div class='title d-flex flex-row justify-content-between'>
                        <div class='titles'>
                            <a href=''><h4>".$rowJob['jobTitle']."<small> Published on ".$rowJob['jobPublished']."</small></h4></a>
                            <h6>By ".$locationName."</h6>
                          <span id="job_list"></span>


                        </div>
                        <ul>
                            <li><a class='btn btn-primary' href='./query_boxes/supplier_jobs_accept_accept_jobs.php?jobID=".$rowJob['jobID']."'>Apply</a></li>
                        </ul>
                    </div>
                    <p >".$rowJob['jobCount']." pieces needs to do ".$rowJob['jobType'].". Every manpower member has to work at most ".$rowJob['jobPeriod']." days.
                    <strong></strong> Job should be complete within ".$rowJob['jobPeriod']." days.</p>

                    <h5>Job Nature: ".$rowJob['jobNature']."</h5>
                    <p class='address'><span class=''></span>".$locationAddress."</p>
                    <p class='address'><span class=''></span>".$rowJob['workersJoined']." joined.</p>
                </div></div>


        </html>

        ";


        }
    }

?>
<script>
    $(document).ready(function(){

        load_supplier_jobs_accept_data();

        function load_supplier_jobs_accept_data()
        {
            $.ajax({
                url:"fetchrate.php",
                method:"POST",
                success:function(data)
                {
                    $('#job_list').html(data);
                }
            });
        }

        $(document).on('mouseenter', '.rating', function(){
            var supplier_jobs_accept = $(this).data("supplier_jobs_accept");
            var job_id = $(this).data('job_id');
            remove_background(job_id);
            for(var count = 1; count<=supplier_jobs_accept; count++)
            {
                $('#'+job_id+'-'+count).css('color', '#ffcc00');
            }
        });

        function remove_background(job_id)
        {
            for(var count = 1; count <= 5; count++)
            {
                $('#'+job_id+'-'+count).css('color', '#ccc');
            }
        }

        $(document).on('mouseleave', '.rating', function(){
            var supplier_jobs_accept = $(this).data("supplier_jobs_accept");
            var job_id = $(this).data('job_id');
            var rating = $(this).data("rating");
            remove_background(job_id);
            //alert(rating);
            for(var count = 1; count<=rating; count++)
            {
                $('#'+job_id+'-'+count).css('color', '#ffcc00');
            }
        });

        $(document).on('click', '.rating', function(){
            var supplier_jobs_accept = $(this).data("supplier_jobs_accept");
            var job_id = $(this).data('job_id');
            $.ajax({
                url:"insert_rating.php",
                method:"POST",
                data:{supplier_jobs_accept:supplier_jobs_accept, job_id:job_id},
                success:function(data)
                {
                    if(data == 'done')
                    {
                        load_supplier_jobs_accept_data();
                        alert("You have rate "+supplier_jobs_accept +" out of 5");
                    }
                    else
                    {
                        alert("There is some problem in System");
                    }
                }
            });

        });

    });
</script>