ここの情報は古いです。ご理解頂いた上でお取り扱いください。

Changeset 3418


Ignore:
Timestamp:
Jul 17, 2007, 3:13:40 PM (12 years ago)
Author:
ToshihiroK
Message:

Postgres対応admin、biz部分修正。

Location:
OpenPNE/branches/prj/postgres/2_8_1
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/prj/postgres/2_8_1/webapp/modules/admin/lib/db_admin.php

    r3402 r3418  
    740740                } else {
    741741                    if ($value['name'] == "PNE_POINT") {
    742                         $sql .= ' ORDER BY cast(value as signed)';
     742                        $sql .= ' ORDER BY cast(value as integer)';
    743743                    } else {
    744744                        $sql .= ' ORDER BY value';
  • OpenPNE/branches/prj/postgres/2_8_1/webapp_biz/modules/biz/lib/mysql_functions.php

    r3402 r3418  
    707707        $sql = 'SELECT * FROM biz_todo WHERE biz_todo_id IN ('.$ids.')' .
    708708                ' AND due_datetime > ? AND due_datetime <= ?';
     709        $max_day = date("t", mktime(0,0,0,intval($month),1,intval($year) ));
    709710        $params = array(
    710             sprintf('%04d-%02d', intval($year), intval($month)) . '-00 00:00:00',
    711             sprintf('%04d-%02d', intval($year), intval($month)) . '-31 23:59:59'
     711            sprintf('%04d-%02d', intval($year), intval($month)) . '-01 00:00:00',
     712            sprintf('%04d-%02d', intval($year), intval($month)) . '-' . $max_day . ' 23:59:59'
    712713        );
    713714        $list = db_get_all($sql, $params);
Note: See TracChangeset for help on using the changeset viewer.