prefix}timesheet t
where t.invoiced = 1 and t.payrolled = 0";
$count = $db->get_var($sql);
return $count;
}
function show_payroll_list() {
global $wpdb;
$db = new time_sheets_db();
$main = new time_sheets_main();
$queue_approval = new time_sheets_queue_approval();
$approver = $queue_approval->employee_approver_check();
$options = get_option('time_sheets');
$common = new time_sheets_common();
$timesheets = $this->return_payroll_list();
if ($timesheets) {
echo "";
} else {
echo "No time sheets to process for payroll.";
}
}
function payroll_timesheet(){
$entry = new time_sheets_entry();
if ($_GET['action']=='preinvoice') {
$entry->show_timesheet();
} else {
echo "
";
$this->show_payroll_list();
echo "
";
}
}
function do_timesheet_rejectpayroll() {
global $wpdb;
$db = new time_sheets_db();
$user_id = get_current_user_id();
$sql = "update {$wpdb->prefix}timesheet
set invoiced = 0,
invoiced_by = NULL,
invoiced_date = NULL
where timesheet_id = %d";
$params = array(intval($_GET['timesheet_id']));
$db->query($sql, $params);
echo '
Timesheet has been rejected.
';
}
function return_payroll_list() {
global $wpdb;
$db = new time_sheets_db();
$sql = "select t.timesheet_id, u.user_login, t.start_date, c.ClientName client_name, cp.ProjectName project_name, t.invoiceid, cp.notes, t.per_diem_days, t.hotel_charges, t.rental_car_charges, t.tolls, t.other_expenses, t.mileage, t.flight_cost, u.display_name
from {$wpdb->prefix}timesheet t
JOIN {$wpdb->prefix}timesheet_clients c ON t.ClientId = c.ClientId
JOIN {$wpdb->prefix}timesheet_client_projects cp ON t.ProjectId = cp.ProjectId
join {$wpdb->users} u on t.user_id = u.ID
where t.invoiced = 1 and payrolled = 0
order by t.start_date";
$timesheets = $db->get_results($sql);
return $timesheets;
}
function do_timesheet_payroll(){
global $wpdb;
$db = new time_sheets_db();
$user_id = get_current_user_id();
check_admin_referer( 'timesheet_payroll_processing' );
$timesheets = $this->return_payroll_list();
foreach ($timesheets as $timesheet) {
$valuename = "timesheet_{$timesheet->timesheet_id}";
if ($_GET[$valuename] == 1) {
$sql = "update {$wpdb->prefix}timesheet
set payrolled= 1,
payrolled_by = {$user_id},
payrolled_on = CURDATE()
where timesheet_id = {$timesheet->timesheet_id}";
$db->query($sql);
}
}
echo '
Timesheet(s) have been updated.
';
}
function employee_payroll_check() {
global $wpdb;
$user_id = get_current_user_id();
$db = new time_sheets_db();
$sql = "select count(*) from {$wpdb->prefix}timesheet_payrollers where user_id = {$user_id}";
$count = $db->get_var($sql);
return $count;
}
}