PHP fit Examples

Example #1

File: samelevel_fit.php Project: nloadholtes/people-prodigy

        $career_goals = $common->prefix_table("career_goals");
        $model_percent_fit = $common->prefix_table("models_percent_fit");
        $sql = "select same_level from {$career_goals} where user_id='{$user_id}' and interest='lot'";
        $res = $db_object->get_single_column($sql);
        if (count($res) > 0) {
            $fam = @implode(",", $res);
            $family_ids = "(" . $fam . ")";
            $sql = "select model_id from {$model_factor_1} where family in {$family_ids}";
            $sql_res = $db_object->get_single_column($sql);
            if ($sql_res[0] != "") {
                $model_ids = @implode(",", $sql_res);
                $models = "(" . $model_ids . ")";
                $qry = "select avg(percent_fit) as percent from {$model_percent_fit} where model_id in {$models}\n\t\t\t\t\n\t\t\t\tand user_id ='{$user_id}'";
                $percent = $db_object->get_a_line($qry);
                $percent = $percent[0];
            }
        } else {
            $percent = 0;
        }
        $total = 100;
        $heads = array(array("Same Level", 3, "c"));
        $array = array($percent, $total);
        $vals = $image->return_Array($array);
        $image->init(150, 150, $vals);
        $image->draw_heading($heads);
        $image->set_legend_percent();
        $image->display($filename);
    }
}
$obj = new fit();
$obj->samelevel_fit($db_object, $common, $image, $user_id, $model_id);

Example #2

File: technical_fit.php Project: nloadholtes/people-prodigy

<?php

include_once "../session.php";
class fit
{
    function technical_fit($db_object, $common, $image, $user_id)
    {
        $models_percent_fit = $common->prefix_table("models_percent_fit");
        $sql = "select avg(percent_fit) as percent from \n\t\t\n\t\t{$models_percent_fit} where user_id='{$user_id}' and skill_type='t'";
        $res = $db_object->get_a_line($sql);
        $percent = $res[0];
        if ($percent == "") {
            $percent = 0;
        }
        $total = 100;
        $heads = array(array("Technical Fit", 3, "c"));
        $array = array($percent, $total);
        $vals = $image->return_Array($array);
        $image->init(150, 150, $vals);
        $image->draw_heading($heads);
        $image->set_legend_percent();
        $image->display($filename);
    }
}
$obj = new fit();
$obj->technical_fit($db_object, $common, $image, $user_id);

Example #3

File: onelevel_up_fit.php Project: nloadholtes/people-prodigy

        $career_goals = $common->prefix_table("career_goals");
        $model_percent_fit = $common->prefix_table("models_percent_fit");
        $sql = "select onelevel_up from {$career_goals} where user_id='{$user_id}' and interest='lot'";
        $res = $db_object->get_single_column($sql);
        if (count($res) > 0) {
            $fam = @implode(",", $res);
            $family_ids = "(" . $fam . ")";
            $sql = "select model_id from {$model_factor_1} where family in {$family_ids}";
            $sql_res = $db_object->get_single_column($sql);
            if ($sql_res[0] != "") {
                $model_ids = @implode(",", $sql_res);
                $models = "(" . $model_ids . ")";
                $qry = "select avg(percent_fit) as percent from {$model_percent_fit} where model_id in {$models}\n\t\t\t\t\n\t\t\t\tand user_id ='{$user_id}'";
                $percent = $db_object->get_a_line($qry);
                $percent = $percent[0];
            }
        } else {
            $percent = 0;
        }
        $total = 100;
        $heads = array(array("Onelevel Up", 3, "c"));
        $array = array($percent, $total);
        $vals = $image->return_Array($array);
        $image->init(150, 150, $vals);
        $image->draw_heading($heads);
        $image->set_legend_percent();
        $image->display($filename);
    }
}
$obj = new fit();
$obj->onelevel_up_fit($db_object, $common, $image, $user_id);

Example #4

File: reports_samelevel_fit.php Project: nloadholtes/people-prodigy

                $family_ids = @implode(",", $fly_res);
                $fly = "(" . $family_ids . ")";
                $sql = "select model_id from {$model_factors_1} where family in {$fly}";
                $model_arr = $db_object->get_single_column($sql);
                if (count($model_arr) > 0) {
                    $model_ids = @implode(",", $model_arr);
                    $models = "(" . $model_ids . ")";
                    $sql = "select avg(percent_fit) as percent from {$model_percent_fit} where model_id in {$models} \n\t\t\t\t\t\n\t\t\t\t\tand user_id='{$user}'";
                    $percent_arr = $db_object->get_a_line($sql);
                    $total_percent += $percent_arr[0];
                    $count++;
                }
            }
        }
        if ($count >= 1) {
            $percent = $total_percent / $count;
        } else {
            $percent = 0;
        }
        $total = 100;
        $heads = array(array("Same Level Fit", 3, "c"));
        $array = array($percent, $total);
        $vals = $image->return_Array($array);
        $image->init(150, 150, $vals);
        $image->draw_heading($heads);
        $image->set_legend_percent();
        $image->display($filename);
    }
}
$obj = new fit();
$obj->avg_percent_fit_iskill($db_object, $common, $image, $user_id);

Example #5

File: interpersonal_fit.php Project: nloadholtes/people-prodigy

<?php

include_once "../session.php";
class fit
{
    function interpersonal_fit($db_object, $common, $image, $user_id)
    {
        $models_percent_fit = $common->prefix_table("models_percent_fit");
        $sql = "select avg(percent_fit) as percent from {$models_percent_fit} \n\t\t\n\t\twhere user_id='{$user_id}' and skill_type='i'";
        $res = $db_object->get_a_line($sql);
        $percent = $res[0];
        if ($percent == "") {
            $percent = 0;
        }
        $total = 100;
        $heads = array(array("Inter Personal Fit", 3, "c"));
        $array = array($percent, $total);
        $vals = $image->return_Array($array);
        $image->init(150, 150, $vals);
        $image->draw_heading($heads);
        $image->set_legend_percent();
        $image->display($filename);
    }
}
$obj = new fit();
$obj->interpersonal_fit($db_object, $common, $image, $user_id);