<div class="content-block"> <div class="content-title">List of Investors</div> <div class="form-item no-height"> </div> </div> <?php $rater = getRatertoProject($project['project_id']); print_r($rater); if ($rater == true) { //make true for actual result ?> <div class="content-block"> <div class="content-title"> <?php $rate = getAdminRatedStatus($project['project_id'], $_SESSION['uid']); $value = getAdminRateForProject($project['project_id'], $_SESSION['uid']); if ($project['seed_rating'] == 0) { $seed = 'N/A'; } else { $seed = $project['seed_rating']; } if ($rate == '1') { ?> <input type="button" class="buttonclick admin_rate_project_<?php echo $project['project_id']; ?> -rated" id="admin_rate_project" data-id="<?php echo $project['project_id']; ?>
function adminRateProject($value) { $project_id = $value['project_id']; $user_id = $_SESSION['uid']; global $db_con; $rated = getAdminRatedStatus($project_id, $user_id); if ($rated != '1') { $query = 'INSERT INTO `admin_rating` SET `project_id` = ' . $project_id . ', `user_id` = ' . $user_id . ', `feasibility` = ' . $value['fes'] . ', `uniqness` = ' . $value['uni'] . ', `growth_quality` = ' . $value['gro'] . ', `startup_easeness` = ' . $value['sta'] . ', `process_clarity` = ' . $value['pro'] . ', `risk_factor` = ' . $value['ris'] . ', `time_consumption` = ' . $value['tim'] . ', `redundancy_featured` = ' . $value['red'] . ', `impact` = ' . $value['imp'] . ', `profile` = ' . $value['prf'] . ', `rated`=1 '; $check = getIdFromSeed($project_id); //print_r($check); if ($check == false) { $qu = 'INSERT INTO `seed_rating_score` SET `project_id` = ' . $project_id . ', `feasibility` = ' . $value['fes'] . ', `uniqueness` = ' . $value['uni'] . ', `growth_quality` = ' . $value['gro'] . ', `startup_easeness` = ' . $value['sta'] . ', `process_clarity` = ' . $value['pro'] . ', `risk_factor` = ' . $value['ris'] . ', `time_consumption` = ' . $value['tim'] . ', `redundancy_featured` = ' . $value['red'] . ', `impact` = ' . $value['imp'] . ', `profile` = ' . $value['prf'] . ' '; $db_con->query($qu); // print_r($query); } else { $qu = 'UPDATE `seed_rating_score` SET `feasibility` = CONCAT(`feasibility`,",",' . $value['fes'] . '), `uniqueness` = CONCAT(`uniqueness`,",",' . $value['uni'] . '), `growth_quality` = CONCAT(`growth_quality`,",",' . $value['gro'] . '), `startup_easeness` = CONCAT(`startup_easeness`,",",' . $value['sta'] . '), `process_clarity` = CONCAT(`process_clarity`,",",' . $value['pro'] . '), `risk_factor` = CONCAT(`risk_factor`,",",' . $value['ris'] . '), `time_consumption` = CONCAT(`time_consumption`,",",' . $value['tim'] . '), `redundancy_featured` = CONCAT(`redundancy_featured`,",",' . $value['red'] . '), `impact` = CONCAT(`impact`,",",' . $value['imp'] . '), `profile` = CONCAT(`profile`,",",' . $value['prf'] . ') WHERE `project_id`=' . $project_id; $db_con->query($qu); } } else { $query = 'UPDATE `admin_rating` SET `feasibility` = ' . $value['fes'] . ', `uniqness` = ' . $value['uni'] . ', `growth_quality` = ' . $value['gro'] . ', `startup_easeness` = ' . $value['sta'] . ', `process_clarity` = ' . $value['pro'] . ', `risk_factor` = ' . $value['ris'] . ', `time_consumption` = ' . $value['tim'] . ', `redundancy_featured` = ' . $value['red'] . ', `impact` = ' . $value['imp'] . ', `profile` = ' . $value['prf'] . ' WHERE `project_id` = ' . $project_id . ' AND `user_id` = ' . $user_id; //print_r($query); } $id = $db_con->query($query); // $query = 'UPDATE `projects` SET `avr_rating` = (SELECT AVG(value) FROM `rating` WHERE `project_id` = ' . $project_id . ') WHERE `project_id` = ' . $project_id; // $db_con->query($query); return $id; }