function auto_checkout_by_location($location_id)
{
    $query = <<<SQL
SELECT
    t.`id`,
    t.`registration_id`,
    t.`checked_in`,
    t.`checked_out`,
    t.`created`,
    t.`modified`
FROM
    `tracking` t
    INNER JOIN `registration` r ON t.`registration_id` = r.`id`
WHERE
    r.`location_id` = :location_id
    AND t.`checked_out` IS NULL
SQL;
    $dbaccess = new db_access();
    $dbaccess->open_connection();
    $checkins = $dbaccess->fetch_all($query, array(get_db_param(':location_id', $location_id, PDO::PARAM_INT)), true);
    $query = <<<SQL
UPDATE `tracking`
SET
    `checked_out` = :now,
    `modified` = :now
WHERE `id` = :tracking_id;
SQL;
    foreach ($checkins as $checkin) {
        $dbaccess->update($query, array(get_db_param(':tracking_id', $checkin['id'], PDO::PARAM_INT), get_db_param(':now', get_db_now(), PDO::PARAM_STR)), true);
    }
    $dbaccess->close_connection();
    return json_decode(json_encode($data), FALSE);
}
 function getAddress($query)
 {
     global $t_address;
     $sqlQueryString = "SELECT * FROM '" . $t_address . "' WHERE address LIKE '%" . $query . "%'";
     $a = new db_access();
     return $a->prepareSentence($sqlQueryString);
 }
function searchQuery($code, $searchQuery)
{
    $dbConnection = new db_access();
    $result = false;
    //en caso que tenga código
    if ($code) {
        switch ($code) {
            case ':na':
                $result = $dbConnection->getName($searchQuery);
                break;
            case ':co':
                $result = $dbConnection->getCode($searchQuery);
                break;
            case ':ip':
                $result = $dbConnection->getIp($searchQuery);
                break;
            case ':ad':
                $result = $dbConnection->getAddress($searchQuery);
                break;
            default:
                $result = false;
        }
        //en caso que NO tenga código
    } else {
        $result = array_merge($dbConnection->getName($searchQuery), $dbConnection->getIp($searchQuery), $dbConnection->getAddress($searchQuery), $dbConnection->getCode($searchQuery));
    }
    return $result;
}
Beispiel #4
0
function db_query($sql)
{
    $connect = new db_access();
    $connect->initialize();
    $connect->connect();
    $result = mysql_query($sql);
    if (!$result) {
        die("Unable to query database" . mysql_error() . "\n" . $sql);
    }
    return $result;
}
Beispiel #5
0
 if ($database == 'mysql') {
     if ($db_host && $db_user && $db_name) {
         $sc = new db_mysql();
         $sc->connect($db_host, $db_user, $db_pass, $db_name, $CFG['db_expires'], $CFG['db_charset'], $CFG['pconnect']);
     } else {
         $sc =& $db;
     }
 } else {
     if ($database == 'mssql') {
         require DT_ROOT . '/include/db_mssql.class.php';
         $sc = new db_mssql();
         $sc->connect($db_host, $db_user, $db_pass, $db_name);
     } else {
         if ($database == 'access') {
             require DT_ROOT . '/include/db_access.class.php';
             $sc = new db_access();
             $sc->connect(DT_ROOT . '/' . $db_host, $db_user, $db_pass, $db_table);
         } else {
             msg('配置文件错误');
         }
     }
 }
 $key = strpos($db_key, '.') !== false ? trim(substr(strrchr($db_key, '.'), 1)) : $db_key;
 if (!isset($fid)) {
     $r = $sc->get_one("SELECT min({$db_key}) AS fid FROM {$db_table} WHERE {$db_key}>{$lastid} {$db_condition}");
     $fid = $r['fid'] ? $r['fid'] : 0;
 }
 if (!isset($tid)) {
     $r = $sc->get_one("SELECT max({$db_key}) AS tid FROM {$db_table} WHERE {$db_key}>{$lastid} {$db_condition}");
     $tid = $r['tid'] ? $r['tid'] : 0;
 }
Beispiel #6
0
<?php

@(include_once 'config.php');
@(include_once 'database.php');
@(include_once 'functions.php');
$connect = new db_access();
$connect->initialize();
$connect->connect();