Changeset 598

Show
Ignore:
Timestamp:
02/24/08 19:01:04 (9 months ago)
Author:
stavros
Message:

BUG: Postgresql compatibility fix in DID usage page

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • branches/1.3/A2Billing_UI/Public/form_data/FG_var_diduse.inc

    r433 r598  
    1111        if ($inuse) { 
    1212                if (strlen($HD_Form -> FG_TABLE_CLAUSE)>0) $HD_Form -> FG_TABLE_CLAUSE.=" AND "; 
    13                 $HD_Form -> FG_TABLE_CLAUSE.=" (releasedate IS NULL OR releasedate = '0000-00-00 00:00:00') and activated=1"; 
     13                $HD_Form -> FG_TABLE_CLAUSE.=" (releasedate IS NULL OR releasedate < '1984-01-01 00:00:00') and activated=1"; 
    1414                $HD_Form -> FG_OTHER_BUTTON1 = true; 
    1515                $HD_Form -> FG_OTHER_BUTTON1_LINK="A2B_entity_did_use.php?posted=$posted&order=$order&sens=$sens&current_page=$current_page&did=$did&inuse=$inuse&atmenu=document&stitle=Document&actionbtn=release_did&did=|col0|"; 
    …… 
    2323} else { 
    2424        if (strlen($HD_Form -> FG_TABLE_CLAUSE)>0) $HD_Form -> FG_TABLE_CLAUSE.=" AND "; 
    25         $HD_Form -> FG_TABLE_CLAUSE.=" (releasedate IS NULL OR releasedate = '0000-00-00 00:00:00') and activated=1"; 
     25        $HD_Form -> FG_TABLE_CLAUSE.=" (releasedate IS NULL OR releasedate < '1984-01-01 00:00:00') and activated=1"; 
    2626        $HD_Form -> FG_TABLE_DEFAULT_ORDER = "id_did"; 
    2727        $HD_Form -> FG_TABLE_DEFAULT_SENS = "ASC"; 

  • experimental_v2/A2Billing_UI/Public/form_data/FG_var_diduse.inc

    r433 r598  
    1111        if ($inuse) { 
    1212                if (strlen($HD_Form -> FG_TABLE_CLAUSE)>0) $HD_Form -> FG_TABLE_CLAUSE.=" AND "; 
    13                 $HD_Form -> FG_TABLE_CLAUSE.=" (releasedate IS NULL OR releasedate = '0000-00-00 00:00:00') and activated=1"; 
     13                $HD_Form -> FG_TABLE_CLAUSE.=" (releasedate IS NULL OR releasedate < '1984-01-01 00:00:00') and activated=1"; 
    1414                $HD_Form -> FG_OTHER_BUTTON1 = true; 
    1515                $HD_Form -> FG_OTHER_BUTTON1_LINK="A2B_entity_did_use.php?posted=$posted&order=$order&sens=$sens&current_page=$current_page&did=$did&inuse=$inuse&atmenu=document&stitle=Document&actionbtn=release_did&did=|col0|"; 
    …… 
    2323} else { 
    2424        if (strlen($HD_Form -> FG_TABLE_CLAUSE)>0) $HD_Form -> FG_TABLE_CLAUSE.=" AND "; 
    25         $HD_Form -> FG_TABLE_CLAUSE.=" (releasedate IS NULL OR releasedate = '0000-00-00 00:00:00') and activated=1"; 
     25        $HD_Form -> FG_TABLE_CLAUSE.=" (releasedate IS NULL OR releasedate < '1984-01-01 00:00:00') and activated=1"; 
    2626        $HD_Form -> FG_TABLE_DEFAULT_ORDER = "id_did"; 
    2727        $HD_Form -> FG_TABLE_DEFAULT_SENS = "ASC"; 

  • trunk/A2Billing_UI/Public/form_data/FG_var_diduse.inc

    r433 r598  
    1111        if ($inuse) { 
    1212                if (strlen($HD_Form -> FG_TABLE_CLAUSE)>0) $HD_Form -> FG_TABLE_CLAUSE.=" AND "; 
    13                 $HD_Form -> FG_TABLE_CLAUSE.=" (releasedate IS NULL OR releasedate = '0000-00-00 00:00:00') and activated=1"; 
     13                $HD_Form -> FG_TABLE_CLAUSE.=" (releasedate IS NULL OR releasedate < '1984-01-01 00:00:00') and activated=1"; 
    1414                $HD_Form -> FG_OTHER_BUTTON1 = true; 
    1515                $HD_Form -> FG_OTHER_BUTTON1_LINK="A2B_entity_did_use.php?posted=$posted&order=$order&sens=$sens&current_page=$current_page&did=$did&inuse=$inuse&atmenu=document&stitle=Document&actionbtn=release_did&did=|col0|"; 
    …… 
    2323} else { 
    2424        if (strlen($HD_Form -> FG_TABLE_CLAUSE)>0) $HD_Form -> FG_TABLE_CLAUSE.=" AND "; 
    25         $HD_Form -> FG_TABLE_CLAUSE.=" (releasedate IS NULL OR releasedate = '0000-00-00 00:00:00') and activated=1"; 
     25        $HD_Form -> FG_TABLE_CLAUSE.=" (releasedate IS NULL OR releasedate < '1984-01-01 00:00:00') and activated=1"; 
    2626        $HD_Form -> FG_TABLE_DEFAULT_ORDER = "id_did"; 
    2727        $HD_Form -> FG_TABLE_DEFAULT_SENS = "ASC"; 


Google