<?php
include "../session.php";
include "header.php";
class Employee_without_position
{
function show_employees($common, $db_object, $user_id)
{
$path = $common->path;
$xFile = $path . "templates/core/positions_without_employees.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.position,$user_table.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'";
//------here the query takes the positions that are all not in the usertable
$selqry = "select {$position_table}.pos_id,{$position_table}.position_name,{$position_table}.date_added,{$position_table}.added_by,{$user_table}.position from {$position_table} left join {$user_table} on {$position_table}.pos_id={$user_table}.position where {$user_table}.position is null";
$userset = $db_object->get_rsltset($selqry);
for ($i = 0; $i < count($userset); $i++) {
$temp_user_id = $userset[$i]["added_by"];
$userset[$i]["added_by"] = $common->name_display($db_object, $temp_user_id);
}
$values["employee_loop"] = $userset;
$xTemplate = $common->multipleloop_replace($db_object, $xTemplate, $values, $selarr);
$vals = array();
$xTemplate = $common->direct_replace($db_object, $xTemplate, $vals);
echo $xTemplate;
}
}
$empobj = new Employee_without_position();
$empobj->show_employees($common, $db_object, $user_id);
include "footer.php";
$admins_table = $common->prefix_table("admins");
//$selqry="select $user_table.user_id,$user_table.username,$user_table.position,$user_table.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'";
//------here the query takes the positions that are all not in the usertable
$selqry = "select position from {$user_table} where user_id='{$user_id}'";
$users_position = $db_object->get_a_line($selqry);
$directreports = $common->get_chain_below($users_position["position"], $db_object, $twodarr);
$belowpositions = @implode(",", $directreports);
//$selqry="select $position_table.pos_id,$position_table.position_name,$position_table.date_added,$position_table.added_by,$user_table.position from $position_table left join $user_table on $position_table.pos_id=$user_table.position where $user_table.position is null and $position_table.pos_id in ($belowpositions)";
$selqry = "select {$position_table}.pos_id,{$position_table}.position_name,\ndate_format({$position_table}.date_added,'%m.%d.%Y.%i:%s') as date_added ,{$position_table}.added_by,\n{$user_table}.position from\n{$position_table} left join {$user_table} on\n{$position_table}.pos_id={$user_table}.position\nleft join {$admins_table} on {$position_table}.pos_id={$admins_table}.pos_id where {$user_table}.position is null or '0' and {$admins_table}.user_id='{$user_id}'";
//echo $selqry;
//--------if needed you can add
$userset = $db_object->get_rsltset($selqry);
if ($userset[0] == "") {
echo $error_msg['cNoPositionNoEmployee'];
include_once "footer.php";
exit;
}
for ($i = 0; $i < count($userset); $i++) {
$temp_user_id = $userset[$i]["added_by"];
$userset[$i]["added_by"] = $common->name_display($db_object, $temp_user_id);
}
$values["employee_loop"] = $userset;
$xTemplate = $common->multipleloop_replace($db_object, $xTemplate, $values, $selarr);
$vals = array();
$xTemplate = $common->direct_replace($db_object, $xTemplate, $vals);
echo $xTemplate;
}
}
$empobj = new Employee_without_position();
$empobj->show_employees($common, $db_object, $user_id, $error_msg);
include "footer.php";