File/plugins/Figures/sql.inc.php

Description
Description | Functions

SQL query library for Figures plugin.

Functions
Description | Functions
sql_select_autofigures (line 87)

Select autofigures by user.

$with_globals toggles retrieval of system wide vars. $id_figure_var limits the result to a specific variable only.

  • stockmaniac-tables: figure_var
  • access: public
string sql_select_autofigures (int $id_user, [bool $with_globals = true], [bool $id_figure_var = null])
  • int $id_user
  • bool $with_globals
  • bool $id_figure_var
sql_select_figures (line 174)

Select available fundamental vars by user.

Optionally it will also select all system-wide variables (usefull with DBC::sql_get_indexedlist_result()) or a single variable only.

  • see: DBC::sql_get_indexedlist_result()
  • stockmaniac-tables: figure_var
  • access: public
string sql_select_figures (int $id_user, [bool $is_systemwide = false], [bool $without_autofigures = true], [array $include_figure_vars = false])
  • int $id_user
  • bool $is_systemwide
  • bool $without_autofigures
  • array $include_figure_vars
sql_select_figure_data (line 29)

Select fundamental data by user and position.

$width_globals toggles retrieval of system wide vars. $id_figure_data limits result to the requested record. $id_figure_var limits the result to contain values for a specific variable only.

  • stockmaniac-tables: figure_data, figure_var, position
  • access: public
string sql_select_figure_data (int $id_user, int $id_position, [bool $with_globals = true], [bool $id_figure_data = null], [bool $id_figure_var = null])
  • int $id_user
  • int $id_position
  • bool $with_globals
  • bool $id_figure_data
  • bool $id_figure_var
sql_store_figure_data (line 127)

Store fundamental data value in database.

ATTENTION:

  • it does not modify id_stock during UPDATE. This is desired behavior.

  • deprecated: use vo_*->store() to insert/update records
  • stockmaniac-tables: figure_data position
  • access: public
string sql_store_figure_data (int $id_user,  $id_position, array $data)
  • int $id_user
  • array $data
  • $id_position
sql_store_figure_var (line 218)

Store fundamental variable in database

  • deprecated: use vo_*->store() to insert/update records
  • stockmaniac-tables: figure_var
  • access: public
string sql_store_figure_var (int $id_user, object $vo_figure_var)
  • int $id_user
  • object $vo_figure_var

Documentation generated on Sun, 22 Aug 2010 11:20:25 +0200 by phpDocumentor 1.4.3