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	<?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	?>