php_library/fboprime/rscs.inc

<?php
//$Header: /hl/cvsroots/gpl01/gpl01/webprojs/fboprime/sw/phplib/rscs.inc,v 1.7 2006/07/27 01:24:28 dashley Exp $
//--------------------------------------------------------------------------------------------------------------
//rscs.inc--FboPrime Database rscs Table Manipulation Functions
//Copyright (C) 2006  David T. Ashley
//
//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., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
//********************************************************************************
//Contains functions related to [operations on] the rscs table of the database.
//--------------------------------------------------------------------------------------------------------------
//
require_once("db.inc");
require_once("global.inc");
require_once("sguid.inc");
//
//--------------------------------------------------------------------------------------------------------------
//Constants for rscs table fields.
//
//Constants for the type field of the rscs table.
define("RSCS_TYPE_AIRCRAFT",                               0                         );
define("RSCS_TYPE_SIMULATOR",                              1                         );
define("RSCS_TYPE_FLIGHTINSTRUCTOR",                       2                         );
//
//Constants for the status field of the rscs table.
define("RSCS_STATUS_OFFLINE",                              0                         );
define("RSCS_STATUS_ONLINE",                               1                         );
//
//--------------------------------------------------------------------------------------------------------------
//Inserts a new record into the RSCS database, using the passed associative array to assign the fields.
//Each element of the associative array is indexed by a field name.
//
//The function returns the integer index of the record added.
//
//This operation cannot fail.  The autoincrement index is the primary key, so no duplicates or other
//error conditions are meaningful.
//
function RSCS_insert($arg)
   {
   global $GLOBAL_dbhandle;
   global $GLOBAL_dblocked;

   //Build the query string with each successive parameter.
   //
   //type
   //------
   if (! isset($arg["type"]))
      $pushval = RSCS_TYPE_AIRCRAFT;
   else
      $pushval = $arg["type"];
   $query_string = "INSERT INTO rscs SET type=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"";
   //
   //status
   //------
   if (! isset($arg["status"]))
      $pushval = RSCS_STATUS_ONLINE;
   else
      $pushval = $arg["status"];
   $query_string .= (", status=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"");
   //
   //disporder
   //---------
   if (! isset($arg["disporder"]))
      $pushval = 0;
   else
      $pushval = $arg["disporder"];
   $query_string .= (", disporder=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"");
   //
   //longdesc
   //--------
   if (! isset($arg["longdesc"]))
      $pushval = "";
   else
      $pushval = $arg["longdesc"];
   $query_string .= (", longdesc=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"");
   //
   //shortdesc
   //---------
   if (! isset($arg["shortdesc"]))
      $pushval = "";
   else
      $pushval = $arg["shortdesc"];
   $query_string .= (", shortdesc=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"");
   //
   //initials
   //--------
   if (! isset($arg["initials"]))
      $pushval = "";
   else
      $pushval = $arg["initials"];
   $query_string .= (", initials=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"");
   //
   //rstdtime
   //--------
   if (! isset($arg["rstdtime"]))
      $pushval = "UUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU";
   else
      $pushval = $arg["rstdtime"];
   $query_string .= (", rstdtime=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"");
   //
   //schedaheadhrs
   //-------------
   if (! isset($arg["schedaheadhrs"]))
      $pushval = (int) 0;
   else
      $pushval = $arg["schedaheadhrs"];
   $query_string .= (", schedaheadhrs=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"");
   //
   //usercorres
   //----------
   if (! isset($arg["usercorres"]))
      $pushval = (int) 0;
   else
      $pushval = $arg["usercorres"];
   $query_string .= (", usercorres=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"");
   //
   //crmodsguid
   //----------
   if (! isset($arg["crmodsguid"]))
      $pushval = SGUID_sguid();
   else
      $pushval = $arg["crmodsguid"];
   $query_string .= (", crmodsguid=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"");
   //
   //echo " " . $query_string . " ";

   //Execute the query to insert the record.
   $result = mysql_query($query_string, $GLOBAL_dbhandle);
   //
   //If the insert failed, our caller gets FALSE.
   if ($result == FALSE)
      {
      $rv = FALSE;
      }
   else
      {
      //The insert was successful.  Figure out the index that was assigned.
      $result = mysql_query("SELECT LAST_INSERT_ID()");

      //If we have a failure, the caller gets FALSE, otherwise the caller gets the
      //index.
      if ($result === FALSE)
         {
         $rv = FALSE;
         }
      else
         {
         //Pick apart the result.
         $row = mysql_fetch_array($result, MYSQL_NUM);

         //Extract the integer.
         $rv = $row[0];

         //Free the result memory.
         mysql_free_result($result);
         }
      }

   //Return the result.
   return($rv);
   }
//
//--------------------------------------------------------------------------------------------------------------
//Retrieves a two-dimensional array of elements containing full information about each resource that is
//online for the purpose of displaying the dayview scheduling page.  Resources are sorted by the 
//specified display order, then by type, then (as the ultimate tie-breaker), by index.
//
//If no resources are online, FALSE is returned.
//
function RSCS_rscs_list_dayview_online()
   {
   global $GLOBAL_dbhandle;

   $query_string = "SELECT * FROM rscs WHERE status="
                   .
                   RSCS_STATUS_ONLINE
                   .
                   " ORDER BY disporder, type, idx ASC";

   $result = mysql_query($query_string, $GLOBAL_dbhandle);

   //If the query did not go through successfully, return FALSE to the caller.
   //
   if ($result === FALSE)
      {
      return(FALSE);
      }

   //If the number of rows in the result set is 0, also give the caller FALSE.
   if (mysql_num_rows($result) <= 0)
      {
      //Technically, we got a result set, so free it.
      mysql_free_result($result);
   
      //The caller gets FALSE.
      return(FALSE);
      }

   //If we're here, we have a valid result set.  Each row of the returned array is 
   //the expected fields from the rscs table.

   //Copy out the results to the array we'll return.
   while ($row = mysql_fetch_assoc($result))
      {
      $rv[] = $row;
      }   

   //Free memory.
   mysql_free_result($result);

   //Give the caller the array.
   return($rv);
   }
//
//--------------------------------------------------------------------------------------------------------------
//End of $RCSfile: rscs.inc,v $.
//--------------------------------------------------------------------------------------------------------------
?>
1	dashley	35	<?php
2			//$Header: /hl/cvsroots/gpl01/gpl01/webprojs/fboprime/sw/phplib/rscs.inc,v 1.7 2006/07/27 01:24:28 dashley Exp $
3			//--------------------------------------------------------------------------------------------------------------
4			//rscs.inc--FboPrime Database rscs Table Manipulation Functions
5			//Copyright (C) 2006 David T. Ashley
6			//
7			//This program is free software; you can redistribute it and/or
8			//modify it under the terms of the GNU General Public License
9			//as published by the Free Software Foundation; either version 2
10			//of the License, or (at your option) any later version.
11			//
12			//This program is distributed in the hope that it will be useful,
13			//but WITHOUT ANY WARRANTY; without even the implied warranty of
14			//MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15			//GNU General Public License for more details.
16			//
17			//You should have received a copy of the GNU General Public License
18			//along with this program; if not, write to the Free Software
19			//Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
20			//********************************************************************************
21			//Contains functions related to [operations on] the rscs table of the database.
22			//--------------------------------------------------------------------------------------------------------------
23			//
24			require_once("db.inc");
25			require_once("global.inc");
26			require_once("sguid.inc");
27			//
28			//--------------------------------------------------------------------------------------------------------------
29			//Constants for rscs table fields.
30			//
31			//Constants for the type field of the rscs table.
32			define("RSCS_TYPE_AIRCRAFT", 0 );
33			define("RSCS_TYPE_SIMULATOR", 1 );
34			define("RSCS_TYPE_FLIGHTINSTRUCTOR", 2 );
35			//
36			//Constants for the status field of the rscs table.
37			define("RSCS_STATUS_OFFLINE", 0 );
38			define("RSCS_STATUS_ONLINE", 1 );
39			//
40			//--------------------------------------------------------------------------------------------------------------
41			//Inserts a new record into the RSCS database, using the passed associative array to assign the fields.
42			//Each element of the associative array is indexed by a field name.
43			//
44			//The function returns the integer index of the record added.
45			//
46			//This operation cannot fail. The autoincrement index is the primary key, so no duplicates or other
47			//error conditions are meaningful.
48			//
49			function RSCS_insert($arg)
50			{
51			global $GLOBAL_dbhandle;
52			global $GLOBAL_dblocked;
53
54			//Build the query string with each successive parameter.
55			//
56			//type
57			//------
58			if (! isset($arg["type"]))
59			$pushval = RSCS_TYPE_AIRCRAFT;
60			else
61			$pushval = $arg["type"];
62			$query_string = "INSERT INTO rscs SET type=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"";
63			//
64			//status
65			//------
66			if (! isset($arg["status"]))
67			$pushval = RSCS_STATUS_ONLINE;
68			else
69			$pushval = $arg["status"];
70			$query_string .= (", status=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"");
71			//
72			//disporder
73			//---------
74			if (! isset($arg["disporder"]))
75			$pushval = 0;
76			else
77			$pushval = $arg["disporder"];
78			$query_string .= (", disporder=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"");
79			//
80			//longdesc
81			//--------
82			if (! isset($arg["longdesc"]))
83			$pushval = "";
84			else
85			$pushval = $arg["longdesc"];
86			$query_string .= (", longdesc=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"");
87			//
88			//shortdesc
89			//---------
90			if (! isset($arg["shortdesc"]))
91			$pushval = "";
92			else
93			$pushval = $arg["shortdesc"];
94			$query_string .= (", shortdesc=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"");
95			//
96			//initials
97			//--------
98			if (! isset($arg["initials"]))
99			$pushval = "";
100			else
101			$pushval = $arg["initials"];
102			$query_string .= (", initials=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"");
103			//
104			//rstdtime
105			//--------
106			if (! isset($arg["rstdtime"]))
107			$pushval = "UUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU";
108			else
109			$pushval = $arg["rstdtime"];
110			$query_string .= (", rstdtime=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"");
111			//
112			//schedaheadhrs
113			//-------------
114			if (! isset($arg["schedaheadhrs"]))
115			$pushval = (int) 0;
116			else
117			$pushval = $arg["schedaheadhrs"];
118			$query_string .= (", schedaheadhrs=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"");
119			//
120			//usercorres
121			//----------
122			if (! isset($arg["usercorres"]))
123			$pushval = (int) 0;
124			else
125			$pushval = $arg["usercorres"];
126			$query_string .= (", usercorres=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"");
127			//
128			//crmodsguid
129			//----------
130			if (! isset($arg["crmodsguid"]))
131			$pushval = SGUID_sguid();
132			else
133			$pushval = $arg["crmodsguid"];
134			$query_string .= (", crmodsguid=\"" . mysql_real_escape_string ($pushval, $GLOBAL_dbhandle) . "\"");
135			//
136			//echo " " . $query_string . " ";
137
138			//Execute the query to insert the record.
139			$result = mysql_query($query_string, $GLOBAL_dbhandle);
140			//
141			//If the insert failed, our caller gets FALSE.
142			if ($result == FALSE)
143			{
144			$rv = FALSE;
145			}
146			else
147			{
148			//The insert was successful. Figure out the index that was assigned.
149			$result = mysql_query("SELECT LAST_INSERT_ID()");
150
151			//If we have a failure, the caller gets FALSE, otherwise the caller gets the
152			//index.
153			if ($result === FALSE)
154			{
155			$rv = FALSE;
156			}
157			else
158			{
159			//Pick apart the result.
160			$row = mysql_fetch_array($result, MYSQL_NUM);
161
162			//Extract the integer.
163			$rv = $row[0];
164
165			//Free the result memory.
166			mysql_free_result($result);
167			}
168			}
169
170			//Return the result.
171			return($rv);
172			}
173			//
174			//--------------------------------------------------------------------------------------------------------------
175			//Retrieves a two-dimensional array of elements containing full information about each resource that is
176			//online for the purpose of displaying the dayview scheduling page. Resources are sorted by the
177			//specified display order, then by type, then (as the ultimate tie-breaker), by index.
178			//
179			//If no resources are online, FALSE is returned.
180			//
181			function RSCS_rscs_list_dayview_online()
182			{
183			global $GLOBAL_dbhandle;
184
185			$query_string = "SELECT * FROM rscs WHERE status="
186			.
187			RSCS_STATUS_ONLINE
188			.
189			" ORDER BY disporder, type, idx ASC";
190
191			$result = mysql_query($query_string, $GLOBAL_dbhandle);
192
193			//If the query did not go through successfully, return FALSE to the caller.
194			//
195			if ($result === FALSE)
196			{
197			return(FALSE);
198			}
199
200			//If the number of rows in the result set is 0, also give the caller FALSE.
201			if (mysql_num_rows($result) <= 0)
202			{
203			//Technically, we got a result set, so free it.
204			mysql_free_result($result);
205
206			//The caller gets FALSE.
207			return(FALSE);
208			}
209
210			//If we're here, we have a valid result set. Each row of the returned array is
211			//the expected fields from the rscs table.
212
213			//Copy out the results to the array we'll return.
214			while ($row = mysql_fetch_assoc($result))
215			{
216			$rv[] = $row;
217			}
218
219			//Free memory.
220			mysql_free_result($result);
221
222			//Give the caller the array.
223			return($rv);
224			}
225			//
226			//--------------------------------------------------------------------------------------------------------------
227			//End of $RCSfile: rscs.inc,v $.
228			//--------------------------------------------------------------------------------------------------------------
229			?>