$end_date = $end_day->format("%e"); $start_data_pretty[$i] = "{$start_month} {$start_date}-" . ($start_month == $end_month ? $end_date : "{$end_month} {$end_date}"); $start_data_linkable[$i] = urlencode($start_day->getDate()); // $starts[$i] = $start_day->format($df); $sql = "\n\t\t\tSELECT\n\t\t\t\ttask_log_creator,\n\t\t\t\tsum(task_log_hours) as hours\n\t\t\tFROM\n\t\t\t\ttask_log\n\t\t\tWHERE\n\t\t\t\ttask_log_date >= '" . $start_day->format(FMT_DATETIME_MYSQL) . "' \n\t\t\t\tAND task_log_date <= '" . $end_day->format(FMT_DATETIME_MYSQL) . "'\n\t\t\t\tAND task_log_creator in (" . implode(", ", $ids) . ")\n\t\t\tGROUP BY\n\t\t\t\ttask_log_creator\n\t\t\t"; //print "<pre>$sql</pre>"; $result = db_loadList($sql); foreach ($result as $row) { $people[$row['task_log_creator']][$i] = $row['hours']; } $date = $start_day->format("%Y-%m-%d") . " 12:00:00"; $start_day->setDate($date, DATE_FORMAT_ISO); $start_day->addDays(-7); } } $sql = "SELECT company_id, company_name FROM companies WHERE " . getPermsWhereClause("companies", "company_id") . " ORDER BY company_name"; //print "<pre>$sql</pre>"; $companies = arrayMerge(array(0 => $AppUI->_('All Entities')), db_loadHashList($sql)); $next_day = new CDate(); $next_day->copy($start_day); $next_day->addDays($week_count * 7 * 2); ?> <form name="frmCompanySelect" action="" method="get"> <input type="hidden" name="m" value="timecard"> <input type="hidden" name="report_type" value="weekly_by_user"> <input type="hidden" name="tab" value="<?php echo $tab; ?> "> <table cellspacing="1" cellpadding="2" border="0" width="100%"> <tr>
&start_date=<?php echo urlencode($next_date->getDate()); ?> "><img src="./images/next.gif" width="16" height="16" alt="<?php echo $AppUI->_('next'); ?> " border="0"></a></td> <?php if ($show_other_worksheets) { ?> <td align="right"> <select name="user_id" onChange="document.user_select.submit();"> <?php //$sql = "SELECT user_id, user_username, user_last_name //FROM users WHERE user_id=".$AppUI->user_id." or (".getPermsWhereClause("companies", "user_company").") ORDER BY user_last_name, user_first_name"; $sql = "SELECT users.user_contact,users.user_id,contacts.contact_first_name,contacts.contact_last_name,contacts.contact_id\n\t\tFROM users\n\t\tinner JOIN contacts on contact_id = user_contact\n\t\tWHERE users.user_contact = " . $AppUI->user_id . " or (" . getPermsWhereClause("companies", "user_company") . ") ORDER BY contact_last_name, contact_first_name"; $result = db_loadList($sql); foreach ($result as $user) { echo "<option value=\"" . $user["user_id"] . "\"" . ($user["user_id"] == $user_id ? "selected" : "") . ">" . $user["contact_last_name"] . " " . $user["contact_first_name"] . "</option>\n"; } ?> </select> </td> <td align="left" nowrap="nowrap"><a href="?m=timecard&tab=0&user_id=<?php echo $AppUI->user_id . '">[' . $AppUI->_('My Time Card') . "]</a></td>"; ?> <?php } ?> </tr> <?php
public static function getUserList() { global $AppUI; $q = new DBQuery(); $q->addQuery('users.user_contact,users.user_id,co.contact_first_name,co.contact_last_name,co.contact_id'); $q->addTable('users'); $q->addJoin('contacts', 'co', 'co.contact_id = users.user_contact', 'inner'); $q->addWhere('users.user_contact = ' . $AppUI->user_id . ' or (' . getPermsWhereClause('companies', 'user_company') . ')'); $q->addOrder('contact_first_name, contact_last_name'); $result = $q->loadList(); $retres = array(); foreach ($result as $user) { if (self::isUserActive($user["user_id"])) { $retres[] = $user; } } return $retres; }
//Based largely on the page with the same funtion in the existing TimeTrack module by ajdonnison. // check permissions $m = $AppUI->checkFileName(dPgetParam($_GET, 'm', getReadableModule())); $denyEdit = getDenyEdit($m); if ($denyEdit) { $AppUI->redirect("m=public&a=access_denied"); } require_once $AppUI->getSystemClass('date'); //***START MOD*** pedroa 20050609 require_once $AppUI->getModuleClass('projects'); global $AppUI; //***END MOD $df = $AppUI->getPref('SHDATEFORMAT'); $tid = isset($_GET['tid']) ? $_GET['tid'] : 0; $winnow_project = getPermsWhereClause("projects", "projects.project_id"); $winnow_tasks = getPermsWhereClause("tasks", "tasks.task_id"); //pull data // if we have a TID, then we editing an existing row $sql = " \nSELECT task_log.*, project_name, task_name, task_project, project_company \nFROM task_log\nLEFT JOIN tasks ON task_id = task_log_task\nLEFT JOIN projects ON project_id = task_project\nWHERE task_log_id = {$tid} \n\tAND {$winnow_project}\n\tAND {$winnow_tasks}\n"; db_loadHash($sql, $task); $is_new_record = !$tid; $task_found = $task['project_company'] != FALSE; $require_task_info = $is_new_record || $task_found; global $TIMECARD_CONFIG; //Prevent users from editing other ppls timecards. $can_edit_other_timesheets = $TIMECARD_CONFIG['minimum_edit_level'] >= $AppUI->user_type; if (!$can_edit_other_timesheets) { if (isset($_GET['tid']) && (isset($v['task_log_creator']) && $task['task_log_creator'] != $AppUI->user_id || !isset($task['task_log_creator']))) { $AppUI->redirect("m=public&a=access_denied"); } }