PHP request::query方法代码示例

 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>"; }