Changeset 4387 for trunk/include/dblayer

Timestamp:

Nov 29, 2009, 3:06:16 PM (14 years ago)

Author:

nikrou

Message:

Feature_1255:

• bug fix : function pwg_db_get_recent_period_expression
• add extra fields for select based on "order by"

File:

• trunk/include/dblayer/functions_mysql.inc.php (modified) (1 diff)

trunk/include/dblayer/functions_mysql.inc.php

@@ -459 +459 @@
 }
 
-function pwg_db_get_recent_period_expression($period, $date='CURRENT_DATE')
-{
-  if ($date!='CURRENT_DATE')
-  {
-    $date = '\''.$date.'\'';
-  }
-
-  return 'SUBDATE('.$date.',INTERVAL '.$period.' DAY)';
-}
-
-function pwg_db_get_recent_period($period, $date='CURRENT_DATE')
-{
-  $query = '
-SELECT '.pwg_db_get_recent_period_expression($period);
-  list($d) = pwg_db_fetch_row(pwg_query($query));
-
-  return $d;
+function pwg_db_concat_ws($string, $separaor)
+{
+  return 'CONCAT_WS(\''.$separaor.'\','. $string.')';
+}
+
+function pwg_db_cast_to_text($string)
+{
+  return 'CAST('.$string.' AS CHAR)';
 }