Exemplo n.º 1
0
<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'];
        ?>
Exemplo n.º 2
0
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;
}