<?php
/*
  Wrapper SQL functions
  Copyright (c) 2002,2003 Gilbert Cao (hika)
  All rights reserved.

  This program is free software; you can redistribute it and/or modify
  it under the terms of the GNU General Public License as published by
  the Free Software Foundation; either version 2 of the License, or
  (at your option) any later version.

  This program is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU General Public License for more details.

  You should have received a copy of the GNU General Public License
  along with this program; if not, write to the Free Software
  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
*/

  /* WRAPPER SQL */
  function DAY($expr) {
    if (defined("USE_MYSQL"))
      return "DAYOFMONTH(".$expr.")";
    else if (defined("USE_PGSQL"))
      return "DATE_PART('day', ".$expr.")";
  }
  
  function MONTH($expr) {
    if (defined("USE_MYSQL"))
      return "MONTH(".$expr.")";
    else if (defined("USE_PGSQL"))
      return "DATE_PART('month', ".$expr.")";
  }
  
  function YEAR($expr) {
    if (defined("USE_MYSQL"))
      return "YEAR(".$expr.")";
    else if (defined("USE_PGSQL"))
      return "DATE_PART('year', ".$expr.")";
  }
  
  function SYSDATE() {
    if (defined("USE_MYSQL"))
      return "sysdate()";
    else if (defined("USE_PGSQL"))
      return "now()";
  }
  
  function UNIX_TIMESTAMP($expr) {
    if (defined("USE_MYSQL"))
      return "UNIX_TIMESTAMP(".$expr.")";
    else if (defined("USE_PGSQL"))
      return "EXTRACT(EPOCH FROM ".$expr.")";
  }
  # Since PHP 5.3.X, native PHP function date_add() exists
  function __DATE_ADD($expr, $value, $interval) {
    if (defined("USE_MYSQL"))
      return "DATE_ADD(".$expr.", INTERVAL ".$value." ".strtoupper($interval).")";
    else if (defined("USE_PGSQL"))
      return $expr." + interval '".$value." ".strtolower($interval)."'";
  }
  
  # Since PHP 5.3.X, native PHP function date_diff() exists
  function __DATE_DIFF($interval, $expr1, $expr2) {
    if (defined("USE_MYSQL")) {
      switch($interval) {
      case "d":
        return "TO_DAYS(".$expr1.") - TO_DAYS(".$expr2.")";
      }
    }
    else if (defined("USE_PGSQL")) {
      switch($interval) {
      case "d":
        return "DATE_PART('day', ".$expr1." - ".$expr2.")";
      }
    }
  }  
  
  function LIMIT($offset, $number) {
    if (defined("USE_MYSQL"))
      return "LIMIT ".$offset.", ".$number;
    else if (defined("USE_PGSQL"))
      return "LIMIT ".$number." OFFSET ".$offset;
  }
  
  function TO_BOOL($value) {
    if (defined("USE_MYSQL"))
      return $value;
    else if (defined("USE_PGSQL"))
      return ($value ? "TRUE" : "FALSE" );
  }

  function BINARY($bin) {
    if (defined("USE_MYSQL"))
      return "'".addslashes($bin)."'";
    else if (defined("USE_PGSQL")) {
      $search = array(chr(92), chr(0), chr(39));
      $replace = array("\\\\134", "\\\\000", "\\\\047");
      return "'".str_replace($search, $replace, $bin)."'";
    }
  }
  
  function SHOW_BINARY($bin) {
    if (defined("USE_MYSQL"))
      echo $bin;
    else if (defined("USE_PGSQL"))
      echo stripcslashes($bin);
  }
  
  function STRING_SQL($value) {
    if (defined("USE_MYSQL")) {
      if (is_null($value))
        return "NULL";
      return "'".addslashes($value)."'";
    }
    else if (defined("USE_PGSQL")) {
      if (is_null($value))
        return "NULL";
      return "'".addslashes($value)."'";
    }
  }
  
  function DATE_SQL($day, $month, $year, $hour = 0, $minute = 0, $second = 0) {
    if (defined("USE_MYSQL"))
      return "'".$year."-".$month."-".$day." ".$hour.":".$minute.":".$second."'";
    else if (defined("USE_PGSQL"))
      return "'".$year."-".$month."-".$day." ".$hour.":".$minute.":".$second."'";
  }
  
  function SAFE_DATE_SQL($value) {
    if (ereg("^([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})\ ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})\$", $value, $array_result)) {
      if ((checkdate($array_result[2], $array_result[3], $array_result[1]))
      && ($array_result[4] < 24)
      && ($array_result[5] < 60)
      && ($array_result[6] < 60)) {
        return "'".$array_result[1]."-".$array_result[2]."-".$array_result[3]." ".
               $array_result[4].":".$array_result[5].":".$array_result[6]."'";
      }
    }
    return "NULL";
  }

  function NUM_SQL($value, $decimal = 0) {
    if (defined("USE_MYSQL")) {
      if (is_null($value))
        return "NULL";
      return str_replace(",", ".", round($value, $decimal));
    }
    else if (defined("USE_PGSQL")) {
      if (is_null($value))
        return "NULL";
      return str_replace(",", ".", round($value, $decimal));
    }
  }
  
  if (defined("USE_MYSQL")) {
    include_once("mysql.php");
  }
  else if (defined("USE_PGSQL")) {
    include_once("pgsql.php"); 
  }
?>