<?php
include "../session.php";
include "header.php";
class EmployeewithoutPosition
{
function show_details($common, $db_object, $user_id)
{
$path = $common->path;
$xFile = $path . "templates/core/employee_without_position.html";
$xTemplate = $common->return_file_content($db_object, $xFile);
$user_table = $common->prefix_table("user_table");
$position_table = $common->prefix_table("position");
$selqry = "select {$user_table}.user_id,{$user_table}.username,{$user_table}.added_by,\n{$user_table}.position,\ndate_format({$user_table}.reg_date,'%m.%d.%Y.%i:%s') as reg_date from {$user_table} left join {$position_table} on {$position_table}.pos_id={$user_table}.position where {$user_table}.position is null and {$user_table}.user_type<>'external'";
$userset = $db_object->get_rsltset($selqry);
for ($i = 0; $i < count($userset); $i++) {
$temp_id = $userset[$i]["user_id"];
$userset[$i]["username"] = $common->name_display($db_object, $temp_id);
$temp_ad_user_id = $userset[$i]["added_by"];
$userset[$i]["added_by"] = $common->name_display($db_object, $temp_ad_user_id);
}
$values["employee_loop"] = $userset;
$xTemplate = $common->multipleloop_replace($db_object, $xTemplate, $values, $sel_arr);
$xTemplate = $common->direct_replace($db_object, $xTemplate, $vals);
echo $xTemplate;
}
}
$empobj = new EmployeewithoutPosition();
$empobj->show_details($common, $db_object, $user_id);
include "footer.php";
$xFile = $path . "templates/career/core_data/employee_without_position.html";
$xTemplate = $common->return_file_content($db_object, $xFile);
$user_table = $common->prefix_table("user_table");
$position_table = $common->prefix_table("position");
$admins_table = $common->prefix_table("admins");
if ($user_id != 1) {
$selqry = "select {$user_table}.user_id,{$user_table}.username,\n{$user_table}.added_by,\n{$user_table}.position,\ndate_format({$user_table}.reg_date,'%m.%d.%Y.%i:%s') as reg_date \nfrom {$user_table} left join {$position_table} on {$position_table}.pos_id={$user_table}.position where {$user_table}.position is null or {$user_table}.position='0' and {$user_table}.user_type<>'external' and {$user_table}.admin_id='{$user_id}'";
} else {
$selqry = "select {$user_table}.user_id,{$user_table}.username,\n{$user_table}.added_by,\n{$user_table}.position,\ndate_format({$user_table}.reg_date,'%m.%d.%Y.%i:%s') as reg_date \nfrom {$user_table} left join {$position_table} on {$position_table}.pos_id={$user_table}.position where {$user_table}.position is null or {$user_table}.position='0' and {$user_table}.user_type<>'external'";
}
$userset = $db_object->get_rsltset($selqry);
if ($userset[0] == "") {
echo $error_msg['cNoEmployeeNoPosition'];
include_once "footer.php";
exit;
}
for ($i = 0; $i < count($userset); $i++) {
$temp_id = $userset[$i]["user_id"];
$userset[$i]["username"] = $common->name_display($db_object, $temp_id);
$temp_ad_user_id = $userset[$i]["added_by"];
$userset[$i]["added_by"] = $common->name_display($db_object, $temp_ad_user_id);
}
$values["employee_loop"] = $userset;
$xTemplate = $common->multipleloop_replace($db_object, $xTemplate, $values, $sel_arr);
$xTemplate = $common->direct_replace($db_object, $xTemplate, $vals);
echo $xTemplate;
}
}
$empobj = new EmployeewithoutPosition();
$empobj->show_details($common, $db_object, $user_id, $error_msg);
include "footer.php";
