Ejemplo n.º 1
0
            }
        }
    }
}
if (!$error) {
    $_SESSION["aps_range"] = $_POST ? $range : 10;
    $_SESSION["aps_range_start"] = $_POST && $range == 50 ? $range_start : "";
    $_SESSION["aps_range_end"] = $_POST && $range == 50 ? $range_end : "";
    // render results
    $tday = date("Y-m-d");
    $tdayStart = $tday . " 00:00:00";
    $tmrwStart = date("Y-m-d", time() + 60 * 60 * 24) . " 00:00:00";
    $dayAfterTmrwStart = date("Y-m-d", time() + 60 * 60 * 24 * 2) . " 00:00:00";
    $thisYearWeek = date("Y") . date("W");
    $nextYearWeek = date("Y", time() + 60 * 60 * 24 * 7) . date("W", time() + 60 * 60 * 24 * 7);
    $qBeef = BookingsHelper::getRowQueryBeef();
    // defaults to today
    switch ($range) {
        default:
        case 10:
            // today
            $qw = "\nWHERE\n b.statii_id != '6'\n AND\n(b.meet >= '{$tdayStart}' and b.meet < '{$tmrwStart}')\nOR\n(b.arrive >= '{$tdayStart}' and b.arrive < '{$tmrwStart}')\nAND\nb.statii_id != '6'\n";
            $qt = "\n(b.meet >= '{$tdayStart}' and b.meet < '{$tmrwStart}') AS use_depart,\n(b.arrive >= '{$tdayStart}' and b.arrive < '{$tmrwStart}') AS use_arrive\n";
            break;
        case 20:
            // tomorrow
            $qw = "\nWHERE\nb.statii_id != '6'\nAND\n(b.meet >= '{$tmrwStart}' and b.meet < '{$dayAfterTmrwStart}')\nOR\n(b.arrive >= '{$tmrwStart}' and b.arrive < '{$dayAfterTmrwStart}')\nAND b.statii_id != 6\n";
            $qt = "\n(b.meet >= '{$tmrwStart}' and b.meet < '{$dayAfterTmrwStart}') AS use_depart,\n(b.arrive >= '{$tmrwStart}' and b.arrive < '{$dayAfterTmrwStart}') AS use_arrive\n";
            break;
        case 30:
            // this week