static function retrieve() { $array_query = explode('/', $_SERVER['REQUEST_URI']); array_shift($array_query); //extraemos el primer "/" if ($array_query[0] == APP_W) { //en caso de root array_shift($array_query); } if (end($array_query) == "") { //quitamos espacios en blanco del final array_pop($array_query); } self::$query = $array_query; //retorna valor a stati $query //var_dump($array_query); }
require_once '../includes/library.php'; include_once 'addon_functions.inc.php'; include_once 'addon_variables.inc.php'; //echo("ok"); //echo $_POST["id"]; //echo "status : ".$_POST["status"]; $status = securePost("status", VARTYPE_BOOL); $id = securePost("id", VARTYPE_INT); $message = securePost("comment", VARTYPE_TXT); $datetime = date("Y-m-d H:i:s"); echo $datetime; $updateDB = new request(); $updateDB->connectClass(); if ($status) { //When turning on $query = "INSERT INTO no_tasks_timer (task, owner, start) VALUES ({$id}, {$_SESSION['idSession']}, NOW())"; } else { //When turning off //Generate netOffice date from actual date $date = date("Y-m-d"); $duration = 1; //Generate duration from start time and present time //Update task time $query = "INSERT INTO no_tasks_time (project, task, owner, date, hours, comments, created, modified, encoder) \n\t\tVALUES ((SELECT project FROM no_tasks WHERE id = {$id} LIMIT 1), \n\t\t\t{$id}, \n\t\t\t{$_SESSION['idSession']}, \n\t\t\t'{$date}', \n\t\t\t(SELECT TIME_TO_SEC(TIMEDIFF( NOW(), start )) / 3600 \n\t\t\t\tFROM `no_tasks_timer` \n\t\t\t\tWHERE task = {$id} and owner = {$_SESSION['idSession']}), \n\t\t\t'{$message}', \n\t\t\tNOW(), \n\t\t\tNOW(), \n\t\t\t{$_SESSION['idSession']}); "; $updateDB->query($query); //Delete timer $query = "DELETE FROM no_tasks_timer WHERE owner = {$_SESSION['idSession']};"; } $updateDB->query($query); //echo "\n"; //echo $query;
$mail->ClearAddresses(); // Set email info $mail->FromName = $row[1]; $mail->From = $row[2]; $mail->AddAddress($row[2], $row[1]); $mail->Subject = $strings['daily_alert_subject']; // Set default priority until otherwise notified $mail->Priority = "3"; // Initialize body $body = ''; // Initialize counts $taskCount = 0; $subtaskCount = 0; // See if there are any tasks pending $query = "SELECT {$tasksTable}.id,\n {$tasksTable}.name,\n {$tasksTable}.priority, \n {$tasksTable}.status, \n {$tasksTable}.completion,\n {$tasksTable}.start_date, \n {$tasksTable}.due_date,\n {$tasksTable}.description,\n {$projectsTable}.id, \n {$projectsTable}.name\n FROM {$tasksTable}, {$projectsTable}, {$membersTable}\n WHERE {$tasksTable}.assigned_to = " . $assignedTo . "\n AND {$tasksTable}.status != 1 \n AND {$tasksTable}.due_date = '" . $today . "'\n AND {$tasksTable}.project = {$projectsTable}.id\n AND {$tasksTable}.assigned_to = {$membersTable}.id\n ORDER BY {$tasksTable}.priority"; $alertSub->query($query); // Create email body with link while ($alertSub->fetch()) { // Set task body if ($taskCount == 0) { $body .= $strings['alert_daily_task'] . "\n"; $body .= "----------------------------------\n\n"; } $body .= $strings['task'] . " : " . $row[1] . " (" . $row[0] . ") \n"; //$body .= $strings['project']." : ".$row[10]." (".$row[9].") \n"; $body .= $strings['project'] . " : " . $row[9] . "\n"; //$body .= $strings['link']." : ".$root."/general/login.php?url=tasks/viewtask.php?id=".$row[0]."\n"; $body .= $strings['link'] . " : " . $root . "/tasks/viewtask.php?id=" . $row[0] . "\n"; $body .= $strings['start_date'] . " : " . $row[5] . "\n"; $body .= $strings['due_date'] . " : " . $row[6] . "\n"; if ($row[4] == 0) {
$delta = 0; $totalDelta = 0; //*** New functioning - browse through open days and compare to DB records *** //Special case for Employer listing if ($displayStyle == TASKTIME_EMPLOYER) { //echo "TASKTIME_EMPLOYER"; //$project_group_addon="org.name ASC, "; //$org_group_addon="tim.project ASC, "; $projectsList = ""; foreach ($aEmployedProjectIDs as $work_package) { $wpProjectID = is_array($work_package[PROJECT_ID]) ? implode(",", $work_package[PROJECT_ID]) : $work_package[PROJECT_ID]; $projectsList = $wpProjectID; $tmpquery = "SELECT O.name, P.name, SUM(TT.hours) AS work\n\t\t\tFROM {$tableCollab["tasks_time"]} TT\n\t\t\tINNER JOIN {$tableCollab["projects"]} P ON TT.project = P.id\n\t\t\tINNER JOIN {$tableCollab["organizations"]} O ON P.organization = O.id\n\t\t\tWHERE TT.project IN ({$projectsList})\n\t\t\tGROUP BY P.name"; //echo $tmpquery; $listHours->connectClass(); $listHours->query($tmpquery); $totalHours = 0; $theor_weekly_hours = $work_package[PROJECT_WEEKLY_HOURS]; //$project_begin=new DateTime($work_package[PROJECT_BEGIN]); $project_begin = $work_package[PROJECT_BEGIN]; //echo $work_package[PROJECT_BEGIN]; //$project_now=new DateTime(); $project_now = "NOW"; //$project_duration_interval=date_diff($project_begin,$project_now); //$project_duration=($project_duration_interval->format("%d")); $project_duration_interval = date_diff_outdated($project_begin, $project_now, "w"); //echo $project_duration; //echo $project_duration_interval; while ($row = $listHours->fetch()) { $block2->openRow($db_date_index); $block2->cellRow("");
*/ /** * --- Task Timer --- * */ //Check if a running timer exists /** * TODO Check that idSession is numeric */ $timerToggleScript = ""; $activeTask = 0; $activeTaskStart = 0; $existingtasktimer = new request(); $query = "SELECT task, start FROM no_tasks_timer WHERE owner = {$_SESSION['idSession']} LIMIT 1"; $existingtasktimer->connectClass(); $existingtasktimer->query($query); if ($foundtasktimer = $existingtasktimer->fetch()) { // echo $foundtasktimer[0]; $activeTask = $foundtasktimer[0]; $activeTaskStart = $foundtasktimer[1]; } else { // echo "nothing found"; } //echo $_SESSION['idSession']; /** * TODO Add timer begin date and time at the end of task name */ //Add timer begin date and time at the end of task name // DEBUG // foreach ($_POST as $k => $v) { print "<font color=blue>\$_POST[$k] => $v</font><br>"; } // foreach ($_GET as $k => $v) { print "<font color=green>\$_GET[$k] => $v</font><br>"; }