<?php include "../session.php"; include "header.php"; class Employee_without_Boss { function show_positions($common, $db_object, $user_id) { $path = $common->path; $xFile = $path . "templates/core/employees_without_boss.html"; $xTemplate = $common->return_file_content($db_object, $xFile); $position_table = $common->prefix_table("position"); $user_table = $common->prefix_table("user_table"); $selqry = "select {$user_table}.user_id,{$user_table}.username,{$user_table}.reg_date,{$user_table}.added_by,{$user_table}.position,{$position_table}.boss_no\nfrom {$user_table} left join {$position_table}\non {$user_table}.position={$position_table}.pos_id\nwhere {$user_table}.user_type='employee' and\n({$position_table}.boss_no is null or {$position_table}.boss_no=0) and\n{$user_table}.user_id<>1"; $userset = $db_object->get_rsltset($selqry); for ($i = 0; $i < count($userset); $i++) { $temp_added_user_id = $userset[$i]["added_by"]; $userset[$i]["added_by"] = $common->name_display($db_object, $temp_added_user_id); } $values["employee_loop"] = $userset; $xTemplate = $common->multipleloop_replace($db_object, $xTemplate, $values, $sel_arr); $vals = array(); $xTemplate = $common->direct_replace($db_object, $xTemplate, $vals); echo $xTemplate; } } $posobj = new Employee_without_Boss(); $posobj->show_positions($common, $db_object, $user_id); include "footer.php";
if ($user_id != 1) { $selqry = "select {$user_table}.user_id,{$user_table}.username,\ndate_format({$user_table}.reg_date,'%m.%d.%Y.%i:%s') as reg_date ,\n{$user_table}.added_by,{$user_table}.position,{$position_table}.boss_no\nfrom {$user_table} left join {$position_table}\non {$user_table}.position={$position_table}.pos_id\nwhere {$user_table}.user_type='employee' and\n({$position_table}.boss_no is null or {$position_table}.boss_no=0) and\n{$user_table}.user_id<>1 and {$user_table}.admin_id='{$user_id}'"; } else { $selqry = "select {$user_table}.user_id,{$user_table}.username,\ndate_format({$user_table}.reg_date,'%m.%d.%Y.%i:%s') as reg_date ,\n\n{$user_table}.added_by,{$user_table}.position,{$position_table}.boss_no\nfrom {$user_table} left join {$position_table}\non {$user_table}.position={$position_table}.pos_id\nwhere {$user_table}.user_type='employee' and\n({$position_table}.boss_no is null or {$position_table}.boss_no=0) and\n{$user_table}.user_id<>1"; } //-------------------if needed WE can add for a particular administrators direct reprorts // and $user_table.admin_id='$user_id'"; //---------------------------- $userset = $db_object->get_rsltset($selqry); if ($userset[0] == "") { echo $error_msg['cNoEmployeeNoBoss']; include_once "footer.php"; exit; } for ($i = 0; $i < count($userset); $i++) { $temp_username = $userset[$i]["username"]; $temp_id = $userset[$i]["user_id"]; $userset[$i]["username"] = $common->name_display($db_object, $temp_id); $temp_added_user_id = $userset[$i]["added_by"]; $userset[$i]["added_by"] = $common->name_display($db_object, $temp_added_user_id); } $values["employee_loop"] = $userset; $xTemplate = $common->multipleloop_replace($db_object, $xTemplate, $values, $sel_arr); $vals = array(); $xTemplate = $common->direct_replace($db_object, $xTemplate, $vals); echo $xTemplate; } } $posobj = new Employee_without_Boss(); $posobj->show_positions($common, $db_object, $user_id, $error_msg); include "footer.php";