= '". $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 const_id='7'";
$selShipping .= " AND status='1'";
$selShipping .= ";";
$resShipping = pg_query($conn, $selShipping) or die (pg_last_error(). "
". $selShipping. "
");
$shippingCount = pg_num_rows($resShipping);
if ($shippingCount == 0)
$shippingCount = 1;
//else
// $shippingCount += 1;
$t_name[$iCount] = $t_name[$iCount]. "[". $shippingCount. "]";
}
// 搬入累計の計算
$selShippingTotal = "SELECT * FROM qgis.concrete_shipping_record";
$selShippingTotal .= " WHERE record_date >= '". date("Y-m-d 00:00:00"). "'";
$selShippingTotal .= " AND record_date <= '". date("Y-m-d 23:59:59"). "'";
$selShippingTotal .= " AND const_id='7'";
$selShippingTotal .= " AND status='2'";
$selShippingTotal .= ";";
$resShippingTotal = pg_query($conn, $selShippingTotal) or die (pg_last_error(). "
". $selShippingTotal. "
");
$shippingTotalCount = pg_num_rows($resShippingTotal);
$lat_php = join(",", $lat);
$lon_php = join(",", $lon);
$w_status_php = join(",", $w_status);
$t_name_php = join(",", $t_name);
?>
トップ画面