ID;
$common = new time_sheets_common();
if ($user_id == 0) {
echo "You must be logged in to view this page.";
return;
}
$common->show_datestuff();
echo "
";
$this->search_timesheet();
echo "
";
$common->show_clients_on_retainer(1);
echo "
";
}
function search_timesheet_sc(){
return $this->search_timesheet(0);
}
function search_timesheet($display=1) {
$user = wp_get_current_user();
$user_id = $user->ID;
$common = new time_sheets_common();
$approval = new time_sheets_queue_approval();
$options = get_option('time_sheets');
$page = '';
if ($user_id == 0) {
$page = $page . "You must be logged in to view this page.";
return $page;
}
$start_date = isset($_GET['start_date']) ? $common->f_date($common->clean_from_db($_GET['start_date'])) : "";
$end_date = isset($_GET['end_date']) ? $common->f_date($common->clean_from_db($_GET['end_date'])) : "";
$include_completed = isset($_GET['include_completed']) ? $common->clean_from_db($_GET['include_completed']) : "";
if (isset($_GET['include_me'])) {
$include_me = ' checked';
} else {
IF (!isset($_GET['submit'])) {
$include_me = ' checked';
} else {
$include_me = '';
}
}
if (isset($_GET['show_all_templates'])) {
$show_all_templates = ' checked';
} else {
$show_all_templates = '';
}
if (isset($_GET['filter_by_client'])) {
$filter_by_client = ' checked';
} else {
$filter_by_client = '';
}
if (!isset($_GET['start_date'])) {
$start_date = date('Y-m-d', strtotime("-1 Year"));
$start_date = $common->f_date($start_date);
$show_all_templates = ' checked';
}
if (!isset($_GET['end_date'])) {
$end_date = date('Y-m-d', strtotime("+1 Day"));
$end_date = $common->f_date($end_date);
}
$v_start_date = date('Y-m-d', strtotime($start_date));
$v_end_date = date('Y-m-d', strtotime($end_date));
$page = $page . '";
if ($approval->employee_approver_check()<> 0) {
$page = $page . "
";
}
$page = $page . "";
if (is_admin()) {
$page = $page . "";
}
$page = $page . $this->run_timesheet_search($start_date, $end_date, $include_me);
if (!isset($_GET['start_date']) || isset($options['allow_recurring_timesheets'])) {
if (isset($_GET['show_all_templates'])) {
$start_date = '0000-01-01';
$end_date = '9999-12-31';
}
$page = $page . $this->run_timesheet_template_search($start_date, $end_date, $include_me);
}
if ($display==1) {
echo $page;
} else {
return $page;
}
}
function mark_timesheets_week_complete ($timesheet_id) {
global $wpdb;
$db = new time_sheets_db();
$user = wp_get_current_user();
$user_id = $user->ID;
$options = get_option('time_sheets');
$common = new time_sheets_common();
$entry = new time_sheets_entry();
$sql = "select ProjectId, total_hours from {$wpdb->prefix}timesheet where timesheet_id=%d";
$params=array(intval($timesheet_id));
$timesheet = $db->get_row($sql, $params);
$sql = "update {$wpdb->prefix}timesheet
set marked_complete_by=$user_id,
marked_complete_date = CURDATE(),
week_complete = 1
where timesheet_id=%d";
$params=array(intval($timesheet_id));
$db->query($sql, $params);
$sql = "update {$wpdb->prefix}timesheet_client_projects
set HoursUsed=HoursUsed+$timesheet->total_hours
where ProjectId=%d";
$params=array($timesheet->ProjectId);
$db->query($sql, $params);
$entry->set_project_inactive_on_date($timesheet->ProjectId);
$sql = "delete from {$wpdb->prefix}timesheet_reject_message_queue
where timesheet_id = %d";
$params=array(intval($timesheet_id));
$db->query($sql, $params);
#Archive the change
$common->archive_records ('timesheet', 'timesheet_archive', "timesheet_id", intval($timesheet_id), '=', 'UPDATED');
$entry->email_on_submission($timesheet_id);
}
function run_timesheet_search_query($start_date, $end_date, $include_me, $timesheet_table) {
global $wpdb;
$db = new time_sheets_db();
$user = wp_get_current_user();
$user_id = $user->ID;
$options = get_option('time_sheets');
$common = new time_sheets_common();
$sql = "select t.*, c.ClientName client_name, cp.ProjectName, u.display_name,
monday_nb+tuesday_nb+wednesday_nb+thursday_nb+friday_nb+saturday_nb+sunday_nb as total_nb
from {$timesheet_table} 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.start_date between %s and %s";
if (!isset($_GET['include_completed'])) {
$sql = "{$sql} and week_complete = 0";
}
if (!isset($_GET['include_all'])) {
if ($include_me != '') {
$sql = $sql." and (t.user_id={$user_id} /*b1*/";
}
}else {
$sql = $sql." and (1=1";
}
if (isset($_GET['include_all_team'])) {
IF ($include_me == '') {
$sql = $sql." and (";
} else {
$sql = $sql." or ";
}
$sql = $sql." t.user_id in (select approvie_user_id from {$wpdb->prefix}timesheet_approvers_approvies where approver_user_id = {$user_id}) )";
} elseif (isset($_GET['team_member'])) {
IF ($include_me == '') {
$sql = $sql." and (";
} else {
$sql = $sql." or ";
}
$sql = $sql." t.user_id = {$common->intval($_GET['team_member'])} /*b2*/ )";
} else {
$sql = $sql." )";
}
if (isset($_GET['filter_by_client'])) {
if ($_GET['ClientId']) {
$sql = $sql." and t.ClientId = {$common->intval($_GET['ClientId'])} ";
}
if ($_GET['ProjectId']) {
$sql = $sql." and t.ProjectId = {$common->intval($_GET['ProjectId'])} ";
}
}
$sql = "{$sql}
order by t.start_date desc, c.ClientName asc, cp.ProjectName asc
";
$params = array($common->mysql_date($start_date), $common->mysql_date($end_date));
$timesheets = $db->get_results($sql, $params);
return $timesheets;
}
function update_bulk_loop($start_date, $end_date, $include_me) {
global $wpdb;
$db = new time_sheets_db();
$user = wp_get_current_user();
$user_id = $user->ID;
$options = get_option('time_sheets');
$common = new time_sheets_common();
$ids = '';
$timesheets = $this->run_timesheet_search_query($start_date, $end_date, $include_me, "{$wpdb->prefix}timesheet");
if ($timesheets) {
foreach ($timesheets as $timesheet) {
if (isset($_GET['week_complete_' . $timesheet->timesheet_id])) {
$this->mark_timesheets_week_complete($timesheet->timesheet_id);
$ids = $ids . $timesheet->timesheet_id . ', ';
}
}
$ids = substr($ids,0,strlen($ids)-2);
if ($ids=="") {
return "