save_settings(); } $user_id = get_current_user_id(); $DefaultDate = get_user_option('timesheet_defaultdate', $user_id); if (!$DefaultDate) { $DefaultDate='Monday Last Week'; } echo "
"; if ($queue_approval->employee_approver_check('false')==1) { $common->show_datestuff(); echo ""; $sql = "select ID, display_name, user_login from {$wpdb->users} where ID <> {$user_id} order by display_name"; $users = $db->get_results($sql); echo ""; $sql = "select * from {$wpdb->prefix}timesheet_approvers where user_id = {$user_id}"; $approver_info = $db->get_row($sql); echo ""; echo ""; } if ($queue_invoice->employee_invoicer_check()!=0) { $primary_sort_col = get_user_option('time_sheets_invoicing_primary_sort_col', $user_id); $primary_sort_order = get_user_option('time_sheets_invoicing_primary_sort_order', $user_id); $secondary_sort_col = get_user_option('time_sheets_invoicing_secondary_sort_col', $user_id); $secondary_sort_order = get_user_option('time_sheets_invoicing_secondary_sort_order', $user_id); if ($primary_sort_col=='') { $primary_sort_col = 'c.ClientName'; } if ($primary_sort_order=='') { $primary_sort_order='asc'; } if ($secondary_sort_col=='') { $secondary_sort_col = 't.start_date'; } if ($secondary_sort_order=='') { $secondary_sort_order='asc'; } echo ""; } if ($options['users_override_location']) { $menu_location = get_user_option('time_sheets_menu_location', $user_id); echo ""; } if ($options['user_specific_date_format']) { $user_date = get_user_option('user_date_format', $user_id); echo ""; } echo ""; echo "
Default Date:
Transfer Approval Team to:
(You can not undo this)
I conform that I want to move my team to the above approver.
Backup Approver:
Backup Approver Expires On:
Invoice List Sort Order
Time Sheets Below:
Custom Date Format: Documentation on Date Formatting
Use of a non-ISO date format can cause search issues when searching for old time sheets.
"; if ($queue_approval->employee_approver_check('false')==1) { echo " "; } } function save_settings() { global $wpdb; $options = get_option('time_sheets'); $common = new time_sheets_common(); $queue_approval = new time_sheets_queue_approval(); $db = new time_sheets_db(); $user_id = get_current_user_id(); update_user_option( $user_id, 'timesheet_defaultdate', $_POST['default_date'], false); if ($_POST['transfer_to_user_id'] != '') { if ($_POST['approve_change']) { $sql = "insert into {$wpdb->prefix}timesheet_approvers (user_id) values (%d)"; $parms = array(intval($_POST['transfer_to_user_id'])); $db->query($sql, $parms); $sql = "update {$wpdb->prefix}timesheet_approvers_approvies set approver_user_id = %d where approver_user_id = %d"; $parms = array(intval($_POST['transfer_to_user_id']), $user_id); $db->query($sql, $parms); echo '

Employees Transferred.

'; } else { echo '

Team was not transferred as approval check box was not checked.

'; } } if ($_POST['backup_user_id']) { $sql = "update {$wpdb->prefix}timesheet_approvers set backup_user_id = %d, backup_expires_on = '%s' where user_id = {$user_id}"; $parms = array(intval($_POST['backup_user_id']), date("Y-m-d", strtotime($_POST['backup_expires_on']))); } else { $sql = "update {$wpdb->prefix}timesheet_approvers set backup_user_id = NULL, backup_expires_on = NULL where user_id = {$user_id}"; $parms = array(); } $db->query($sql, $parms); if ($queue_approval->employee_approver_check('false')==1) { $primary_sort_col = $_POST['primary_sort_col']; $primary_sort_order = $_POST['primary_sort_order']; $secondary_sort_col = $_POST['secondary_sort_col']; $secondary_sort_order = $_POST['secondary_sort_order']; if ($primary_sort_col == 'Client') { $primary_sort_col = 'c.ClientName'; } elseif ($primary_sort_col == 'First Billed Date') { $primary_sort_col = 'c.first_billed_day'; } elseif ($primary_sort_col == 'Project Name') { $primary_sort_col = 'cp.ProjectName'; } elseif ($primary_sort_col == 'Start Date') { $primary_sort_col = 't.start_date'; } elseif ($primary_sort_col == 'Time Sheet') { $primary_sort_col = 't.timesheet_id'; } elseif ($primary_sort_col == 'User') { $primary_sort_col = 'u.display_name'; } else { $primary_sort_col = 'c.ClientName'; } if ($primary_sort_order == 'Ascending') { $primary_sort_order = 'asc'; } else { $primary_sort_order = 'desc'; } if ($secondary_sort_col == 'Client') { $secondary_sort_col = 'c.ClientName'; } elseif ($secondary_sort_col == 'First Billed Date') { $secondary_sort_col = 'c.first_billed_day'; } elseif ($secondary_sort_col == 'Project Name') { $secondary_sort_col = 'cp.ProjectName'; } elseif ($secondary_sort_col == 'Start Date') { $secondary_sort_col = 't.start_date'; } elseif ($secondary_sort_col == 'Time Sheet') { $secondary_sort_col = 't.timesheet_id'; } elseif ($secondary_sort_col == 'User') { $secondary_sort_col = 'u.display_name'; } else { $secondary_sort_col = 'c.ClientName'; } if ($secondary_sort_order == 'Ascending') { $secondary_sort_order = 'asc'; } else { $secondary_sort_order = 'desc'; } update_user_option($user_id, 'time_sheets_invoicing_primary_sort_col', $primary_sort_col, false); update_user_option($user_id, 'time_sheets_invoicing_primary_sort_order', $primary_sort_order, false); update_user_option($user_id, 'time_sheets_invoicing_secondary_sort_col', $secondary_sort_col, false); update_user_option($user_id, 'time_sheets_invoicing_secondary_sort_order', $secondary_sort_order, false); } if ($_POST['menu_location']) { update_user_option($user_id, 'time_sheets_menu_location', intval($_POST['menu_location']), false); } else { delete_user_option($user_id, 'time_sheets_menu_location', false); } if ($options['user_specific_date_format']) { update_user_option($user_id, 'user_date_format', sanitize_text_field($_POST['user_date_format']), false); } else { delete_user_option($user_id, 'user_date_format', false); } echo '

Settings updated.

'; } }