= '". $enableDateTime. "'";
if (strcmp($WORK_STATUS, 0) != 0)
{
$sql .= " AND work_status='". $WORK_STATUS. "'";
}
$sql .= " ORDER BY regdatetime;";
$res = pg_query($conn, $sql) or die (pg_last_error(). "
". $sql. "
");
$Ct = pg_num_rows($res);
for($iCount = 0; $iCount < $Ct; $iCount++)
{
$row = pg_fetch_array($res, $iCount);
$lat[$iCount] = $row["lat"];
$lon[$iCount] = $row["lon"];
$w_status[$iCount] = $row["work_status"];
$t_name[$iCount] = $row["terminal_name"];
$selShipping = "SELECT * FROM qgis.concrete_shipping_record";
$selShipping .= " WHERE android_id='". $row["android_id"]. "'";
$selShipping .= " AND record_date >= '". date("Y-m-d 00:00:00"). "'";
$selShipping .= " AND record_date <= '". date("Y-m-d 23:59:59"). "'";
$selShipping .= " AND status='2'";
$selShipping .= ";";
$resShipping = pg_query($conn, $selShipping) or die (pg_last_error(). "
". $selShipping. "
");
$shippingCount = pg_num_rows($resShipping);
$t_name[$iCount] = $t_name[$iCount]. "[". $shippingCount. "]";
}
$lat_php = join(",", $lat);
$lon_php = join(",", $lon);
$w_status_php = join(",", $w_status);
$t_name_php = join(",", $t_name);
?>
トップ画面