Changeset 3418 for OpenPNE/branches/prj/postgres/2_8_1/webapp_biz/modules/biz/lib/mysql_functions.php

Timestamp:

Jul 17, 2007, 3:13:40 PM (16 years ago)

Author:

ToshihiroK

Message:

Postgres対応admin、biz部分修正。

File:

• OpenPNE/branches/prj/postgres/2_8_1/webapp_biz/modules/biz/lib/mysql_functions.php (modified) (1 diff)

OpenPNE/branches/prj/postgres/2_8_1/webapp_biz/modules/biz/lib/mysql_functions.php

@@ -707 +707 @@
         $sql = 'SELECT * FROM biz_todo WHERE biz_todo_id IN ('.$ids.')' .
                 ' AND due_datetime > ? AND due_datetime <= ?';
+        $max_day = date("t", mktime(0,0,0,intval($month),1,intval($year) ));
         $params = array(
-            sprintf('%04d-%02d', intval($year), intval($month)) . '-00 00:00:00',
-            sprintf('%04d-%02d', intval($year), intval($month)) . '-31 23:59:59'
+            sprintf('%04d-%02d', intval($year), intval($month)) . '-01 00:00:00',
+            sprintf('%04d-%02d', intval($year), intval($month)) . '-' . $max_day . ' 23:59:59'
         );
         $list = db_get_all($sql, $params);