/[dtapublic]/to_be_filed/webprojs/fboprime/sw/phplib/resvx.inc
ViewVC logotype

Contents of /to_be_filed/webprojs/fboprime/sw/phplib/resvx.inc

Parent Directory Parent Directory | Revision Log Revision Log


Revision 31 - (show annotations) (download)
Sat Oct 8 18:44:20 2016 UTC (7 years, 5 months ago) by dashley
File size: 62008 byte(s)
Initial commit.
1 <?php
2 //$Header: /home/dashley/cvsrep/e3ft_gpl01/e3ft_gpl01/webprojs/fboprime/sw/phplib/resvx.inc,v 1.6 2006/08/13 00:50:00 dashley Exp $
3 //--------------------------------------------------------------------------------------------------------------
4 //resvx.inc--FboPrime Database resv Table Manipulation Functions (Not Scheduler Critical)
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 //Copyright 2006 David T. Ashley
22 //-------------------------------------------------------------------------------------------------
23 //This source code and any program in which it is compiled/used is provided under the GNU GENERAL
24 //PUBLIC LICENSE, Version 3, full license text below.
25 //-------------------------------------------------------------------------------------------------
26 // GNU GENERAL PUBLIC LICENSE
27 // Version 3, 29 June 2007
28 //
29 // Copyright (C) 2007 Free Software Foundation, Inc. <http://fsf.org/>
30 // Everyone is permitted to copy and distribute verbatim copies
31 // of this license document, but changing it is not allowed.
32 //
33 // Preamble
34 //
35 // The GNU General Public License is a free, copyleft license for
36 //software and other kinds of works.
37 //
38 // The licenses for most software and other practical works are designed
39 //to take away your freedom to share and change the works. By contrast,
40 //the GNU General Public License is intended to guarantee your freedom to
41 //share and change all versions of a program--to make sure it remains free
42 //software for all its users. We, the Free Software Foundation, use the
43 //GNU General Public License for most of our software; it applies also to
44 //any other work released this way by its authors. You can apply it to
45 //your programs, too.
46 //
47 // When we speak of free software, we are referring to freedom, not
48 //price. Our General Public Licenses are designed to make sure that you
49 //have the freedom to distribute copies of free software (and charge for
50 //them if you wish), that you receive source code or can get it if you
51 //want it, that you can change the software or use pieces of it in new
52 //free programs, and that you know you can do these things.
53 //
54 // To protect your rights, we need to prevent others from denying you
55 //these rights or asking you to surrender the rights. Therefore, you have
56 //certain responsibilities if you distribute copies of the software, or if
57 //you modify it: responsibilities to respect the freedom of others.
58 //
59 // For example, if you distribute copies of such a program, whether
60 //gratis or for a fee, you must pass on to the recipients the same
61 //freedoms that you received. You must make sure that they, too, receive
62 //or can get the source code. And you must show them these terms so they
63 //know their rights.
64 //
65 // Developers that use the GNU GPL protect your rights with two steps:
66 //(1) assert copyright on the software, and (2) offer you this License
67 //giving you legal permission to copy, distribute and/or modify it.
68 //
69 // For the developers' and authors' protection, the GPL clearly explains
70 //that there is no warranty for this free software. For both users' and
71 //authors' sake, the GPL requires that modified versions be marked as
72 //changed, so that their problems will not be attributed erroneously to
73 //authors of previous versions.
74 //
75 // Some devices are designed to deny users access to install or run
76 //modified versions of the software inside them, although the manufacturer
77 //can do so. This is fundamentally incompatible with the aim of
78 //protecting users' freedom to change the software. The systematic
79 //pattern of such abuse occurs in the area of products for individuals to
80 //use, which is precisely where it is most unacceptable. Therefore, we
81 //have designed this version of the GPL to prohibit the practice for those
82 //products. If such problems arise substantially in other domains, we
83 //stand ready to extend this provision to those domains in future versions
84 //of the GPL, as needed to protect the freedom of users.
85 //
86 // Finally, every program is threatened constantly by software patents.
87 //States should not allow patents to restrict development and use of
88 //software on general-purpose computers, but in those that do, we wish to
89 //avoid the special danger that patents applied to a free program could
90 //make it effectively proprietary. To prevent this, the GPL assures that
91 //patents cannot be used to render the program non-free.
92 //
93 // The precise terms and conditions for copying, distribution and
94 //modification follow.
95 //
96 // TERMS AND CONDITIONS
97 //
98 // 0. Definitions.
99 //
100 // "This License" refers to version 3 of the GNU General Public License.
101 //
102 // "Copyright" also means copyright-like laws that apply to other kinds of
103 //works, such as semiconductor masks.
104 //
105 // "The Program" refers to any copyrightable work licensed under this
106 //License. Each licensee is addressed as "you". "Licensees" and
107 //"recipients" may be individuals or organizations.
108 //
109 // To "modify" a work means to copy from or adapt all or part of the work
110 //in a fashion requiring copyright permission, other than the making of an
111 //exact copy. The resulting work is called a "modified version" of the
112 //earlier work or a work "based on" the earlier work.
113 //
114 // A "covered work" means either the unmodified Program or a work based
115 //on the Program.
116 //
117 // To "propagate" a work means to do anything with it that, without
118 //permission, would make you directly or secondarily liable for
119 //infringement under applicable copyright law, except executing it on a
120 //computer or modifying a private copy. Propagation includes copying,
121 //distribution (with or without modification), making available to the
122 //public, and in some countries other activities as well.
123 //
124 // To "convey" a work means any kind of propagation that enables other
125 //parties to make or receive copies. Mere interaction with a user through
126 //a computer network, with no transfer of a copy, is not conveying.
127 //
128 // An interactive user interface displays "Appropriate Legal Notices"
129 //to the extent that it includes a convenient and prominently visible
130 //feature that (1) displays an appropriate copyright notice, and (2)
131 //tells the user that there is no warranty for the work (except to the
132 //extent that warranties are provided), that licensees may convey the
133 //work under this License, and how to view a copy of this License. If
134 //the interface presents a list of user commands or options, such as a
135 //menu, a prominent item in the list meets this criterion.
136 //
137 // 1. Source Code.
138 //
139 // The "source code" for a work means the preferred form of the work
140 //for making modifications to it. "Object code" means any non-source
141 //form of a work.
142 //
143 // A "Standard Interface" means an interface that either is an official
144 //standard defined by a recognized standards body, or, in the case of
145 //interfaces specified for a particular programming language, one that
146 //is widely used among developers working in that language.
147 //
148 // The "System Libraries" of an executable work include anything, other
149 //than the work as a whole, that (a) is included in the normal form of
150 //packaging a Major Component, but which is not part of that Major
151 //Component, and (b) serves only to enable use of the work with that
152 //Major Component, or to implement a Standard Interface for which an
153 //implementation is available to the public in source code form. A
154 //"Major Component", in this context, means a major essential component
155 //(kernel, window system, and so on) of the specific operating system
156 //(if any) on which the executable work runs, or a compiler used to
157 //produce the work, or an object code interpreter used to run it.
158 //
159 // The "Corresponding Source" for a work in object code form means all
160 //the source code needed to generate, install, and (for an executable
161 //work) run the object code and to modify the work, including scripts to
162 //control those activities. However, it does not include the work's
163 //System Libraries, or general-purpose tools or generally available free
164 //programs which are used unmodified in performing those activities but
165 //which are not part of the work. For example, Corresponding Source
166 //includes interface definition files associated with source files for
167 //the work, and the source code for shared libraries and dynamically
168 //linked subprograms that the work is specifically designed to require,
169 //such as by intimate data communication or control flow between those
170 //subprograms and other parts of the work.
171 //
172 // The Corresponding Source need not include anything that users
173 //can regenerate automatically from other parts of the Corresponding
174 //Source.
175 //
176 // The Corresponding Source for a work in source code form is that
177 //same work.
178 //
179 // 2. Basic Permissions.
180 //
181 // All rights granted under this License are granted for the term of
182 //copyright on the Program, and are irrevocable provided the stated
183 //conditions are met. This License explicitly affirms your unlimited
184 //permission to run the unmodified Program. The output from running a
185 //covered work is covered by this License only if the output, given its
186 //content, constitutes a covered work. This License acknowledges your
187 //rights of fair use or other equivalent, as provided by copyright law.
188 //
189 // You may make, run and propagate covered works that you do not
190 //convey, without conditions so long as your license otherwise remains
191 //in force. You may convey covered works to others for the sole purpose
192 //of having them make modifications exclusively for you, or provide you
193 //with facilities for running those works, provided that you comply with
194 //the terms of this License in conveying all material for which you do
195 //not control copyright. Those thus making or running the covered works
196 //for you must do so exclusively on your behalf, under your direction
197 //and control, on terms that prohibit them from making any copies of
198 //your copyrighted material outside their relationship with you.
199 //
200 // Conveying under any other circumstances is permitted solely under
201 //the conditions stated below. Sublicensing is not allowed; section 10
202 //makes it unnecessary.
203 //
204 // 3. Protecting Users' Legal Rights From Anti-Circumvention Law.
205 //
206 // No covered work shall be deemed part of an effective technological
207 //measure under any applicable law fulfilling obligations under article
208 //11 of the WIPO copyright treaty adopted on 20 December 1996, or
209 //similar laws prohibiting or restricting circumvention of such
210 //measures.
211 //
212 // When you convey a covered work, you waive any legal power to forbid
213 //circumvention of technological measures to the extent such circumvention
214 //is effected by exercising rights under this License with respect to
215 //the covered work, and you disclaim any intention to limit operation or
216 //modification of the work as a means of enforcing, against the work's
217 //users, your or third parties' legal rights to forbid circumvention of
218 //technological measures.
219 //
220 // 4. Conveying Verbatim Copies.
221 //
222 // You may convey verbatim copies of the Program's source code as you
223 //receive it, in any medium, provided that you conspicuously and
224 //appropriately publish on each copy an appropriate copyright notice;
225 //keep intact all notices stating that this License and any
226 //non-permissive terms added in accord with section 7 apply to the code;
227 //keep intact all notices of the absence of any warranty; and give all
228 //recipients a copy of this License along with the Program.
229 //
230 // You may charge any price or no price for each copy that you convey,
231 //and you may offer support or warranty protection for a fee.
232 //
233 // 5. Conveying Modified Source Versions.
234 //
235 // You may convey a work based on the Program, or the modifications to
236 //produce it from the Program, in the form of source code under the
237 //terms of section 4, provided that you also meet all of these conditions:
238 //
239 // a) The work must carry prominent notices stating that you modified
240 // it, and giving a relevant date.
241 //
242 // b) The work must carry prominent notices stating that it is
243 // released under this License and any conditions added under section
244 // 7. This requirement modifies the requirement in section 4 to
245 // "keep intact all notices".
246 //
247 // c) You must license the entire work, as a whole, under this
248 // License to anyone who comes into possession of a copy. This
249 // License will therefore apply, along with any applicable section 7
250 // additional terms, to the whole of the work, and all its parts,
251 // regardless of how they are packaged. This License gives no
252 // permission to license the work in any other way, but it does not
253 // invalidate such permission if you have separately received it.
254 //
255 // d) If the work has interactive user interfaces, each must display
256 // Appropriate Legal Notices; however, if the Program has interactive
257 // interfaces that do not display Appropriate Legal Notices, your
258 // work need not make them do so.
259 //
260 // A compilation of a covered work with other separate and independent
261 //works, which are not by their nature extensions of the covered work,
262 //and which are not combined with it such as to form a larger program,
263 //in or on a volume of a storage or distribution medium, is called an
264 //"aggregate" if the compilation and its resulting copyright are not
265 //used to limit the access or legal rights of the compilation's users
266 //beyond what the individual works permit. Inclusion of a covered work
267 //in an aggregate does not cause this License to apply to the other
268 //parts of the aggregate.
269 //
270 // 6. Conveying Non-Source Forms.
271 //
272 // You may convey a covered work in object code form under the terms
273 //of sections 4 and 5, provided that you also convey the
274 //machine-readable Corresponding Source under the terms of this License,
275 //in one of these ways:
276 //
277 // a) Convey the object code in, or embodied in, a physical product
278 // (including a physical distribution medium), accompanied by the
279 // Corresponding Source fixed on a durable physical medium
280 // customarily used for software interchange.
281 //
282 // b) Convey the object code in, or embodied in, a physical product
283 // (including a physical distribution medium), accompanied by a
284 // written offer, valid for at least three years and valid for as
285 // long as you offer spare parts or customer support for that product
286 // model, to give anyone who possesses the object code either (1) a
287 // copy of the Corresponding Source for all the software in the
288 // product that is covered by this License, on a durable physical
289 // medium customarily used for software interchange, for a price no
290 // more than your reasonable cost of physically performing this
291 // conveying of source, or (2) access to copy the
292 // Corresponding Source from a network server at no charge.
293 //
294 // c) Convey individual copies of the object code with a copy of the
295 // written offer to provide the Corresponding Source. This
296 // alternative is allowed only occasionally and noncommercially, and
297 // only if you received the object code with such an offer, in accord
298 // with subsection 6b.
299 //
300 // d) Convey the object code by offering access from a designated
301 // place (gratis or for a charge), and offer equivalent access to the
302 // Corresponding Source in the same way through the same place at no
303 // further charge. You need not require recipients to copy the
304 // Corresponding Source along with the object code. If the place to
305 // copy the object code is a network server, the Corresponding Source
306 // may be on a different server (operated by you or a third party)
307 // that supports equivalent copying facilities, provided you maintain
308 // clear directions next to the object code saying where to find the
309 // Corresponding Source. Regardless of what server hosts the
310 // Corresponding Source, you remain obligated to ensure that it is
311 // available for as long as needed to satisfy these requirements.
312 //
313 // e) Convey the object code using peer-to-peer transmission, provided
314 // you inform other peers where the object code and Corresponding
315 // Source of the work are being offered to the general public at no
316 // charge under subsection 6d.
317 //
318 // A separable portion of the object code, whose source code is excluded
319 //from the Corresponding Source as a System Library, need not be
320 //included in conveying the object code work.
321 //
322 // A "User Product" is either (1) a "consumer product", which means any
323 //tangible personal property which is normally used for personal, family,
324 //or household purposes, or (2) anything designed or sold for incorporation
325 //into a dwelling. In determining whether a product is a consumer product,
326 //doubtful cases shall be resolved in favor of coverage. For a particular
327 //product received by a particular user, "normally used" refers to a
328 //typical or common use of that class of product, regardless of the status
329 //of the particular user or of the way in which the particular user
330 //actually uses, or expects or is expected to use, the product. A product
331 //is a consumer product regardless of whether the product has substantial
332 //commercial, industrial or non-consumer uses, unless such uses represent
333 //the only significant mode of use of the product.
334 //
335 // "Installation Information" for a User Product means any methods,
336 //procedures, authorization keys, or other information required to install
337 //and execute modified versions of a covered work in that User Product from
338 //a modified version of its Corresponding Source. The information must
339 //suffice to ensure that the continued functioning of the modified object
340 //code is in no case prevented or interfered with solely because
341 //modification has been made.
342 //
343 // If you convey an object code work under this section in, or with, or
344 //specifically for use in, a User Product, and the conveying occurs as
345 //part of a transaction in which the right of possession and use of the
346 //User Product is transferred to the recipient in perpetuity or for a
347 //fixed term (regardless of how the transaction is characterized), the
348 //Corresponding Source conveyed under this section must be accompanied
349 //by the Installation Information. But this requirement does not apply
350 //if neither you nor any third party retains the ability to install
351 //modified object code on the User Product (for example, the work has
352 //been installed in ROM).
353 //
354 // The requirement to provide Installation Information does not include a
355 //requirement to continue to provide support service, warranty, or updates
356 //for a work that has been modified or installed by the recipient, or for
357 //the User Product in which it has been modified or installed. Access to a
358 //network may be denied when the modification itself materially and
359 //adversely affects the operation of the network or violates the rules and
360 //protocols for communication across the network.
361 //
362 // Corresponding Source conveyed, and Installation Information provided,
363 //in accord with this section must be in a format that is publicly
364 //documented (and with an implementation available to the public in
365 //source code form), and must require no special password or key for
366 //unpacking, reading or copying.
367 //
368 // 7. Additional Terms.
369 //
370 // "Additional permissions" are terms that supplement the terms of this
371 //License by making exceptions from one or more of its conditions.
372 //Additional permissions that are applicable to the entire Program shall
373 //be treated as though they were included in this License, to the extent
374 //that they are valid under applicable law. If additional permissions
375 //apply only to part of the Program, that part may be used separately
376 //under those permissions, but the entire Program remains governed by
377 //this License without regard to the additional permissions.
378 //
379 // When you convey a copy of a covered work, you may at your option
380 //remove any additional permissions from that copy, or from any part of
381 //it. (Additional permissions may be written to require their own
382 //removal in certain cases when you modify the work.) You may place
383 //additional permissions on material, added by you to a covered work,
384 //for which you have or can give appropriate copyright permission.
385 //
386 // Notwithstanding any other provision of this License, for material you
387 //add to a covered work, you may (if authorized by the copyright holders of
388 //that material) supplement the terms of this License with terms:
389 //
390 // a) Disclaiming warranty or limiting liability differently from the
391 // terms of sections 15 and 16 of this License; or
392 //
393 // b) Requiring preservation of specified reasonable legal notices or
394 // author attributions in that material or in the Appropriate Legal
395 // Notices displayed by works containing it; or
396 //
397 // c) Prohibiting misrepresentation of the origin of that material, or
398 // requiring that modified versions of such material be marked in
399 // reasonable ways as different from the original version; or
400 //
401 // d) Limiting the use for publicity purposes of names of licensors or
402 // authors of the material; or
403 //
404 // e) Declining to grant rights under trademark law for use of some
405 // trade names, trademarks, or service marks; or
406 //
407 // f) Requiring indemnification of licensors and authors of that
408 // material by anyone who conveys the material (or modified versions of
409 // it) with contractual assumptions of liability to the recipient, for
410 // any liability that these contractual assumptions directly impose on
411 // those licensors and authors.
412 //
413 // All other non-permissive additional terms are considered "further
414 //restrictions" within the meaning of section 10. If the Program as you
415 //received it, or any part of it, contains a notice stating that it is
416 //governed by this License along with a term that is a further
417 //restriction, you may remove that term. If a license document contains
418 //a further restriction but permits relicensing or conveying under this
419 //License, you may add to a covered work material governed by the terms
420 //of that license document, provided that the further restriction does
421 //not survive such relicensing or conveying.
422 //
423 // If you add terms to a covered work in accord with this section, you
424 //must place, in the relevant source files, a statement of the
425 //additional terms that apply to those files, or a notice indicating
426 //where to find the applicable terms.
427 //
428 // Additional terms, permissive or non-permissive, may be stated in the
429 //form of a separately written license, or stated as exceptions;
430 //the above requirements apply either way.
431 //
432 // 8. Termination.
433 //
434 // You may not propagate or modify a covered work except as expressly
435 //provided under this License. Any attempt otherwise to propagate or
436 //modify it is void, and will automatically terminate your rights under
437 //this License (including any patent licenses granted under the third
438 //paragraph of section 11).
439 //
440 // However, if you cease all violation of this License, then your
441 //license from a particular copyright holder is reinstated (a)
442 //provisionally, unless and until the copyright holder explicitly and
443 //finally terminates your license, and (b) permanently, if the copyright
444 //holder fails to notify you of the violation by some reasonable means
445 //prior to 60 days after the cessation.
446 //
447 // Moreover, your license from a particular copyright holder is
448 //reinstated permanently if the copyright holder notifies you of the
449 //violation by some reasonable means, this is the first time you have
450 //received notice of violation of this License (for any work) from that
451 //copyright holder, and you cure the violation prior to 30 days after
452 //your receipt of the notice.
453 //
454 // Termination of your rights under this section does not terminate the
455 //licenses of parties who have received copies or rights from you under
456 //this License. If your rights have been terminated and not permanently
457 //reinstated, you do not qualify to receive new licenses for the same
458 //material under section 10.
459 //
460 // 9. Acceptance Not Required for Having Copies.
461 //
462 // You are not required to accept this License in order to receive or
463 //run a copy of the Program. Ancillary propagation of a covered work
464 //occurring solely as a consequence of using peer-to-peer transmission
465 //to receive a copy likewise does not require acceptance. However,
466 //nothing other than this License grants you permission to propagate or
467 //modify any covered work. These actions infringe copyright if you do
468 //not accept this License. Therefore, by modifying or propagating a
469 //covered work, you indicate your acceptance of this License to do so.
470 //
471 // 10. Automatic Licensing of Downstream Recipients.
472 //
473 // Each time you convey a covered work, the recipient automatically
474 //receives a license from the original licensors, to run, modify and
475 //propagate that work, subject to this License. You are not responsible
476 //for enforcing compliance by third parties with this License.
477 //
478 // An "entity transaction" is a transaction transferring control of an
479 //organization, or substantially all assets of one, or subdividing an
480 //organization, or merging organizations. If propagation of a covered
481 //work results from an entity transaction, each party to that
482 //transaction who receives a copy of the work also receives whatever
483 //licenses to the work the party's predecessor in interest had or could
484 //give under the previous paragraph, plus a right to possession of the
485 //Corresponding Source of the work from the predecessor in interest, if
486 //the predecessor has it or can get it with reasonable efforts.
487 //
488 // You may not impose any further restrictions on the exercise of the
489 //rights granted or affirmed under this License. For example, you may
490 //not impose a license fee, royalty, or other charge for exercise of
491 //rights granted under this License, and you may not initiate litigation
492 //(including a cross-claim or counterclaim in a lawsuit) alleging that
493 //any patent claim is infringed by making, using, selling, offering for
494 //sale, or importing the Program or any portion of it.
495 //
496 // 11. Patents.
497 //
498 // A "contributor" is a copyright holder who authorizes use under this
499 //License of the Program or a work on which the Program is based. The
500 //work thus licensed is called the contributor's "contributor version".
501 //
502 // A contributor's "essential patent claims" are all patent claims
503 //owned or controlled by the contributor, whether already acquired or
504 //hereafter acquired, that would be infringed by some manner, permitted
505 //by this License, of making, using, or selling its contributor version,
506 //but do not include claims that would be infringed only as a
507 //consequence of further modification of the contributor version. For
508 //purposes of this definition, "control" includes the right to grant
509 //patent sublicenses in a manner consistent with the requirements of
510 //this License.
511 //
512 // Each contributor grants you a non-exclusive, worldwide, royalty-free
513 //patent license under the contributor's essential patent claims, to
514 //make, use, sell, offer for sale, import and otherwise run, modify and
515 //propagate the contents of its contributor version.
516 //
517 // In the following three paragraphs, a "patent license" is any express
518 //agreement or commitment, however denominated, not to enforce a patent
519 //(such as an express permission to practice a patent or covenant not to
520 //sue for patent infringement). To "grant" such a patent license to a
521 //party means to make such an agreement or commitment not to enforce a
522 //patent against the party.
523 //
524 // If you convey a covered work, knowingly relying on a patent license,
525 //and the Corresponding Source of the work is not available for anyone
526 //to copy, free of charge and under the terms of this License, through a
527 //publicly available network server or other readily accessible means,
528 //then you must either (1) cause the Corresponding Source to be so
529 //available, or (2) arrange to deprive yourself of the benefit of the
530 //patent license for this particular work, or (3) arrange, in a manner
531 //consistent with the requirements of this License, to extend the patent
532 //license to downstream recipients. "Knowingly relying" means you have
533 //actual knowledge that, but for the patent license, your conveying the
534 //covered work in a country, or your recipient's use of the covered work
535 //in a country, would infringe one or more identifiable patents in that
536 //country that you have reason to believe are valid.
537 //
538 // If, pursuant to or in connection with a single transaction or
539 //arrangement, you convey, or propagate by procuring conveyance of, a
540 //covered work, and grant a patent license to some of the parties
541 //receiving the covered work authorizing them to use, propagate, modify
542 //or convey a specific copy of the covered work, then the patent license
543 //you grant is automatically extended to all recipients of the covered
544 //work and works based on it.
545 //
546 // A patent license is "discriminatory" if it does not include within
547 //the scope of its coverage, prohibits the exercise of, or is
548 //conditioned on the non-exercise of one or more of the rights that are
549 //specifically granted under this License. You may not convey a covered
550 //work if you are a party to an arrangement with a third party that is
551 //in the business of distributing software, under which you make payment
552 //to the third party based on the extent of your activity of conveying
553 //the work, and under which the third party grants, to any of the
554 //parties who would receive the covered work from you, a discriminatory
555 //patent license (a) in connection with copies of the covered work
556 //conveyed by you (or copies made from those copies), or (b) primarily
557 //for and in connection with specific products or compilations that
558 //contain the covered work, unless you entered into that arrangement,
559 //or that patent license was granted, prior to 28 March 2007.
560 //
561 // Nothing in this License shall be construed as excluding or limiting
562 //any implied license or other defenses to infringement that may
563 //otherwise be available to you under applicable patent law.
564 //
565 // 12. No Surrender of Others' Freedom.
566 //
567 // If conditions are imposed on you (whether by court order, agreement or
568 //otherwise) that contradict the conditions of this License, they do not
569 //excuse you from the conditions of this License. If you cannot convey a
570 //covered work so as to satisfy simultaneously your obligations under this
571 //License and any other pertinent obligations, then as a consequence you may
572 //not convey it at all. For example, if you agree to terms that obligate you
573 //to collect a royalty for further conveying from those to whom you convey
574 //the Program, the only way you could satisfy both those terms and this
575 //License would be to refrain entirely from conveying the Program.
576 //
577 // 13. Use with the GNU Affero General Public License.
578 //
579 // Notwithstanding any other provision of this License, you have
580 //permission to link or combine any covered work with a work licensed
581 //under version 3 of the GNU Affero General Public License into a single
582 //combined work, and to convey the resulting work. The terms of this
583 //License will continue to apply to the part which is the covered work,
584 //but the special requirements of the GNU Affero General Public License,
585 //section 13, concerning interaction through a network will apply to the
586 //combination as such.
587 //
588 // 14. Revised Versions of this License.
589 //
590 // The Free Software Foundation may publish revised and/or new versions of
591 //the GNU General Public License from time to time. Such new versions will
592 //be similar in spirit to the present version, but may differ in detail to
593 //address new problems or concerns.
594 //
595 // Each version is given a distinguishing version number. If the
596 //Program specifies that a certain numbered version of the GNU General
597 //Public License "or any later version" applies to it, you have the
598 //option of following the terms and conditions either of that numbered
599 //version or of any later version published by the Free Software
600 //Foundation. If the Program does not specify a version number of the
601 //GNU General Public License, you may choose any version ever published
602 //by the Free Software Foundation.
603 //
604 // If the Program specifies that a proxy can decide which future
605 //versions of the GNU General Public License can be used, that proxy's
606 //public statement of acceptance of a version permanently authorizes you
607 //to choose that version for the Program.
608 //
609 // Later license versions may give you additional or different
610 //permissions. However, no additional obligations are imposed on any
611 //author or copyright holder as a result of your choosing to follow a
612 //later version.
613 //
614 // 15. Disclaimer of Warranty.
615 //
616 // THERE IS NO WARRANTY FOR THE PROGRAM, TO THE EXTENT PERMITTED BY
617 //APPLICABLE LAW. EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT
618 //HOLDERS AND/OR OTHER PARTIES PROVIDE THE PROGRAM "AS IS" WITHOUT WARRANTY
619 //OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO,
620 //THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
621 //PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE PROGRAM
622 //IS WITH YOU. SHOULD THE PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF
623 //ALL NECESSARY SERVICING, REPAIR OR CORRECTION.
624 //
625 // 16. Limitation of Liability.
626 //
627 // IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING
628 //WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MODIFIES AND/OR CONVEYS
629 //THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY
630 //GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE
631 //USE OR INABILITY TO USE THE PROGRAM (INCLUDING BUT NOT LIMITED TO LOSS OF
632 //DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD
633 //PARTIES OR A FAILURE OF THE PROGRAM TO OPERATE WITH ANY OTHER PROGRAMS),
634 //EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF
635 //SUCH DAMAGES.
636 //
637 // 17. Interpretation of Sections 15 and 16.
638 //
639 // If the disclaimer of warranty and limitation of liability provided
640 //above cannot be given local legal effect according to their terms,
641 //reviewing courts shall apply local law that most closely approximates
642 //an absolute waiver of all civil liability in connection with the
643 //Program, unless a warranty or assumption of liability accompanies a
644 //copy of the Program in return for a fee.
645 //
646 // END OF TERMS AND CONDITIONS
647 //
648 // How to Apply These Terms to Your New Programs
649 //
650 // If you develop a new program, and you want it to be of the greatest
651 //possible use to the public, the best way to achieve this is to make it
652 //free software which everyone can redistribute and change under these terms.
653 //
654 // To do so, attach the following notices to the program. It is safest
655 //to attach them to the start of each source file to most effectively
656 //state the exclusion of warranty; and each file should have at least
657 //the "copyright" line and a pointer to where the full notice is found.
658 //
659 // <one line to give the program's name and a brief idea of what it does.>
660 // Copyright (C) <year> <name of author>
661 //
662 // This program is free software: you can redistribute it and/or modify
663 // it under the terms of the GNU General Public License as published by
664 // the Free Software Foundation, either version 3 of the License, or
665 // (at your option) any later version.
666 //
667 // This program is distributed in the hope that it will be useful,
668 // but WITHOUT ANY WARRANTY; without even the implied warranty of
669 // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
670 // GNU General Public License for more details.
671 //
672 // You should have received a copy of the GNU General Public License
673 // along with this program. If not, see <http://www.gnu.org/licenses/>.
674 //
675 //Also add information on how to contact you by electronic and paper mail.
676 //
677 // If the program does terminal interaction, make it output a short
678 //notice like this when it starts in an interactive mode:
679 //
680 // <program> Copyright (C) <year> <name of author>
681 // This program comes with ABSOLUTELY NO WARRANTY; for details type `show w'.
682 // This is free software, and you are welcome to redistribute it
683 // under certain conditions; type `show c' for details.
684 //
685 //The hypothetical commands `show w' and `show c' should show the appropriate
686 //parts of the General Public License. Of course, your program's commands
687 //might be different; for a GUI interface, you would use an "about box".
688 //
689 // You should also get your employer (if you work as a programmer) or school,
690 //if any, to sign a "copyright disclaimer" for the program, if necessary.
691 //For more information on this, and how to apply and follow the GNU GPL, see
692 //<http://www.gnu.org/licenses/>.
693 //
694 // The GNU General Public License does not permit incorporating your program
695 //into proprietary programs. If your program is a subroutine library, you
696 //may consider it more useful to permit linking proprietary applications with
697 //the library. If this is what you want to do, use the GNU Lesser General
698 //Public License instead of this License. But first, please read
699 //<http://www.gnu.org/philosophy/why-not-lgpl.html>.
700 //-------------------------------------------------------------------------------------------------
701 //********************************************************************************
702 //Contains functions related to [operations on] the usrs table of the database that
703 //aren't necessary for the operation of the dayview scheduler.
704 //--------------------------------------------------------------------------------------------------------------
705 //
706 require_once("config.inc");
707 require_once("dbx.inc");
708 require_once("dt8.inc");
709 require_once("global.inc");
710 require_once("sguid.inc");
711 require_once("stimex.inc");
712 require_once("resv.inc");
713 //
714 //--------------------------------------------------------------------------------------------------------------
715 //Description
716 // Adds or modifies a RESV record. Certain parameters specify what is expected.
717 //
718 //Inputs
719 // action_in
720 // Enumerated type. Possibilities are:
721 // "A" : Add new.
722 // "M" : Modify existing.
723 //
724 // rec_in
725 // The data about the record to add or modify, as an associative array.
726 //
727 // Adding a record:
728 // a)The index must be absent (it is assigned automatically by the database).
729 // b)The userid must be included and must be globally unique, otherwise an error will be
730 // returned and the record won't be added.
731 // c)Fields out of range or defective will be corrected, and warnings will be returned.
732 // The record will, however, be added if possible.
733 // c)All fields not present in the associative array will be assigned default values.
734 // d)The creation/modification SGUID is handled automatically and may not be included in the
735 // associative array.
736 //
737 // Modifying a record:
738 // a)The record is specified by either index or userid. If both are specified, they must
739 // correspond to an existing record and must be consistent.
740 // b)Fields not included in the associative array are not touched.
741 // c)The creation/modification SGUID is handled automatically. If this field is included
742 // in the associative array, it means to check this against what is in the database
743 // and error out on editing collision if the value doesn't match what is in the database.
744 //
745 //Outputs
746 // result_code_out
747 // Adding a record:
748 // 0 if the operation failed, or the index if it succeeded.
749 // Modifying an existing record.
750 // 0 if the operation failed or 1 if it succeeds.
751 //
752 // errors_out
753 // If any errors resulted, an associative array of integers specifying the errors per the defined
754 // constants, or FALSE otherwise.
755 //
756 // warnings_out
757 // If any warnings resulted, an associative array of integers specifying the warnings per the
758 // defined constants, or FALSE otherwise.
759 //
760 //Database Locking
761 // Locking is performed per the recursive method described in the documentation. If, for example,
762 // the client wishes to call this function from within a larger critical section, as long as the
763 // client uses the recursive locking method, everything will operate correctly.
764 //
765 function RESV_record_add_modify($action_in, $rec_in, &$result_code_out, &$errors_out, &$warnings_out)
766 {
767 global $GLOBAL_dbhandle;
768 global $GLOBAL_dblocked;
769 global $CONFIG_FBO_USER_CATEGORIES;
770 global $GLOBAL_stime_string;
771
772 $in_termination_sequence = FALSE;
773 $errors_out = FALSE;
774 $warnings_out = FALSE;
775
776
777 if (!$in_termination_sequence)
778 {
779 //Lock the database using the recursive critical section method (discussed in the
780 //manual). This is necessary because the test for presence and the insert have to
781 //be combined atomically.
782 $db_was_locked = $GLOBAL_dblocked;
783 if (! $GLOBAL_dblocked)
784 {
785 DB_db_lock();
786 $GLOBAL_dblocked = TRUE;
787 }
788
789
790 if ($action_in == "A")
791 {
792 //Form the query strings. There are two different types, depending on whether
793 //we are adding or modifying a record.
794 //
795 //For adding, the string will be of the form:
796 // INSERT INTO usrs SET fn1=val1, fn2=val2, etc.
797 //
798 //For modifying, the string will be of the form:
799 // UPDATE usrs SET fn1=val1, fn2=val2, etc. WHERE idx=val.
800 //
801 if (!$in_termination_sequence)
802 {
803 //Obtain an SGUID to for the create/modification stamp.
804 //
805 $crmodsguid = SGUID_sguid();
806 }
807 }
808 else
809 {
810 //Modify
811 //
812 }
813
814 } //End if not in termination sequence.
815
816 //Unlock the database (if it was locked) using the recursive critical section
817 //method.
818 if (! $db_was_locked)
819 {
820 DB_db_unlock();
821 $GLOBAL_dblocked = FALSE;
822 }
823
824 //-----------------------------------------------------------
825 //Clean up the output parameters to go back to the caller.
826 //
827 if ($in_termination_sequence)
828 {
829 $result_code_out = 0;
830 }
831 else if ($result_code_out == -1)
832 {
833 //Something went wrong with the query. Return 0 as the
834 //error code.
835 $result_code_out = 0;
836 }
837 else
838 {
839 //The result code contains the index of what was added.
840 }
841
842 if (isset($errors_out_local))
843 {
844 $errors_out = $errors_out_local;
845 }
846 else
847 {
848 $errors_out = FALSE;
849 }
850
851 if (isset($warnings_out_local))
852 {
853 $warnings_out = $warnings_out_local;
854 }
855 else
856 {
857 $warnings_out = FALSE;
858 }
859 }
860 //
861 //--------------------------------------------------------------------------------------------------------------
862 //Retrieves the reservations for an individual user that:
863 // a)Are owned by the user OR
864 // b)Are instructional appointments with the user as the flight instructor.
865 // c)End at or after the current time (i.e. are currently in progress or in the future).
866 // d)Are not banner reservations.
867 //
868 //Results returned are information about the reservation except description, as an associative
869 //array in order from now to the future.
870 //
871 //If no such reservations exist, FALSE is returned.
872 //
873 function RESV_usrs_cur_future_resv_a($useridx_in, $curtime_in)
874 {
875 global $GLOBAL_dblocked;
876 global $GLOBAL_dbhandle;
877
878 //Lock the database using the recursive protocol. This is done to be sure that nobody
879 //deletes the user or the resource during this operation.
880 $db_was_locked = $GLOBAL_dblocked;
881 if (! $GLOBAL_dblocked)
882 {
883 DB_db_lock();
884 $GLOBAL_dblocked = TRUE;
885 }
886
887 //See if the user record exists. If not, can't go further, and return FALSE.
888 //
889 $userinfo = USRS_retrieve_by_idx($useridx_in);
890 if ($userinfo === FALSE)
891 {
892 if (! $db_was_locked)
893 {
894 DB_db_unlock();
895 $GLOBAL_dblocked = FALSE;
896 }
897
898 return(FALSE);
899 }
900
901 //Figure out if the user is a flight instructor or not. This is done by
902 //looking at the resources to see if there is a resource that points back to the
903 //user.
904 //
905 //Form the query string.
906 $query_string = "SELECT idx FROM rscs WHERE usercorres=\""
907 .
908 mysql_real_escape_string((string)$useridx_in, $GLOBAL_dbhandle)
909 .
910 "\"";
911
912 //Execute the query.
913 $result = mysql_query($query_string, $GLOBAL_dbhandle);
914
915 if ($result === FALSE)
916 {
917 //Unknown query failure. Return FALSE to the caller. No need to free,
918 //as this is not a result.
919 $rscs_corresponding = FALSE;
920 }
921 else
922 {
923 //Figure out how many rows in the result.
924 $nrows = mysql_num_rows($result);
925
926 if ($nrows == 0)
927 {
928 //No rows in the result. The query failed to give us a record, but still
929 //we need to free the result set.
930
931 //Free the result.
932 mysql_free_result($result);
933
934 //The caller gets FALSE. No record with that SID.
935 $rscs_corresponding = FALSE;
936 }
937 else
938 {
939 //We have at least one record. Assume just one, because the IDX is supposed
940 //to be unique.
941 $resource_record = mysql_fetch_assoc($result); //Get the associative record.
942 $rscs_corresponding = $resource_record["idx"];
943
944 //Free the result.
945 mysql_free_result($result);
946 }
947 }
948
949 //Form and execute the query to get the relevant reservations. The query is slightly
950 //more complex if the user is also a flight instructor.
951 if ($rscs_corresponding === FALSE)
952 {
953 //User who is not a flight instructor.
954 $query_string = "SELECT idx,type,useridx,alias,"
955 .
956 "finstid,finsttimestart,finsttimeend,"
957 .
958 "acftsimid,acftsimtimestart,acftsimtimeend,"
959 .
960 "resvtimestart,resvtimeend "
961 .
962 "FROM resv WHERE useridx=\""
963 .
964 $useridx_in
965 .
966 "\" AND type!=\"" . RESV_TYPE_BANNER . "\" AND resvtimeend>=\""
967 .
968 $curtime_in
969 .
970 "\" ORDER BY resvtimeend ASC, idx ASC";
971 //echo "<pre>\n";
972 //print_r($query_string);
973 //echo "</pre>\n";
974 }
975 else
976 {
977 //User who is a flight instructor.
978 $query_string = "SELECT idx,type,useridx,alias,"
979 .
980 "finstid,finsttimestart,finsttimeend,"
981 .
982 "acftsimid,acftsimtimestart,acftsimtimeend,"
983 .
984 "resvtimestart,resvtimeend "
985 .
986 "FROM resv WHERE (useridx=\""
987 .
988 $useridx_in
989 .
990 "\" OR finstid=\"" . $rscs_corresponding . "\") AND type!=\"" . RESV_TYPE_BANNER . "\" AND resvtimeend>=\""
991 .
992 $curtime_in
993 .
994 "\" ORDER BY resvtimeend ASC, idx ASC";
995
996 //echo "<pre>\n";
997 //print_r($query_string);
998 //echo "</pre>\n";
999 }
1000
1001 //Run the query, get the result.
1002 $result = mysql_query($query_string, $GLOBAL_dbhandle);
1003
1004 //If the query did not go through successfully, return FALSE to the caller.
1005 //
1006 if ($result === FALSE)
1007 {
1008 $rv = FALSE;
1009 }
1010 //
1011 //If the number of rows in the result set is 0, also give the caller FALSE.
1012 else if (mysql_num_rows($result) <= 0)
1013 {
1014 //Technically, we got a result set, so free it.
1015 mysql_free_result($result);
1016
1017 //The caller gets FALSE signaling no data.
1018 $rv = FALSE;
1019 }
1020 else
1021 {
1022 //If we're here, we have a valid result set. Each row of the returned array is
1023 //the expected fields from the resv table.
1024
1025 //Copy out the results to the array we'll return.
1026 while ($row = mysql_fetch_assoc($result))
1027 {
1028 $rv[] = $row;
1029 }
1030
1031 //Free memory.
1032 mysql_free_result($result);
1033 }
1034
1035 //Unlock the database (if it was locked) using the recursive critical section
1036 //method.
1037 if (! $db_was_locked)
1038 {
1039 DB_db_unlock();
1040 $GLOBAL_dblocked = FALSE;
1041 }
1042
1043 //Return the agreed-on result to the caller.
1044 return($rv);
1045 }
1046 //
1047 //--------------------------------------------------------------------------------------------------------------
1048 //Retrieves the reservations for an individual user that:
1049 // a)Are owned by the user OR
1050 // b)Are instructional appointments with the user as the flight instructor.
1051 // c)End before the current time (i.e. have fully finished).
1052 // d)Are not banner reservations.
1053 //
1054 //Results returned are information about the reservation except description, as an associative
1055 //array in order from now to the future.
1056 //
1057 //If no such reservations exist, FALSE is returned.
1058 //
1059 function RESV_usrs_past_resv_a($useridx_in, $curtime_in)
1060 {
1061 global $GLOBAL_dblocked;
1062 global $GLOBAL_dbhandle;
1063
1064 //Lock the database using the recursive protocol. This is done to be sure that nobody
1065 //deletes the user or the resource during this operation.
1066 $db_was_locked = $GLOBAL_dblocked;
1067 if (! $GLOBAL_dblocked)
1068 {
1069 DB_db_lock();
1070 $GLOBAL_dblocked = TRUE;
1071 }
1072
1073 //See if the user record exists. If not, can't go further, and return FALSE.
1074 //
1075 $userinfo = USRS_retrieve_by_idx($useridx_in);
1076 if ($userinfo === FALSE)
1077 {
1078 if (! $db_was_locked)
1079 {
1080 DB_db_unlock();
1081 $GLOBAL_dblocked = FALSE;
1082 }
1083
1084 return(FALSE);
1085 }
1086
1087 //Figure out if the user is a flight instructor or not. This is done by
1088 //looking at the resources to see if there is a resource that points back to the
1089 //user.
1090 //
1091 //Form the query string.
1092 $query_string = "SELECT idx FROM rscs WHERE usercorres=\""
1093 .
1094 mysql_real_escape_string((string)$useridx_in, $GLOBAL_dbhandle)
1095 .
1096 "\"";
1097
1098 //Execute the query.
1099 $result = mysql_query($query_string, $GLOBAL_dbhandle);
1100
1101 if ($result === FALSE)
1102 {
1103 //Unknown query failure. Return FALSE to the caller. No need to free,
1104 //as this is not a result.
1105 $rscs_corresponding = FALSE;
1106 }
1107 else
1108 {
1109 //Figure out how many rows in the result.
1110 $nrows = mysql_num_rows($result);
1111
1112 if ($nrows == 0)
1113 {
1114 //No rows in the result. The query failed to give us a record, but still
1115 //we need to free the result set.
1116
1117 //Free the result.
1118 mysql_free_result($result);
1119
1120 //The caller gets FALSE. No record with that SID.
1121 $rscs_corresponding = FALSE;
1122 }
1123 else
1124 {
1125 //We have at least one record. Assume just one, because the IDX is supposed
1126 //to be unique.
1127 $resource_record = mysql_fetch_assoc($result); //Get the associative record.
1128 $rscs_corresponding = $resource_record["idx"];
1129
1130 //Free the result.
1131 mysql_free_result($result);
1132 }
1133 }
1134
1135 //Form and execute the query to get the relevant reservations. The query is slightly
1136 //more complex if the user is also a flight instructor.
1137 if ($rscs_corresponding === FALSE)
1138 {
1139 //User who is not a flight instructor.
1140 $query_string = "SELECT idx,type,useridx,alias,"
1141 .
1142 "finstid,finsttimestart,finsttimeend,"
1143 .
1144 "acftsimid,acftsimtimestart,acftsimtimeend,"
1145 .
1146 "resvtimestart,resvtimeend "
1147 .
1148 "FROM resv WHERE useridx=\""
1149 .
1150 $useridx_in
1151 .
1152 "\" AND type!=\"" . RESV_TYPE_BANNER . "\" AND resvtimeend<\""
1153 .
1154 $curtime_in
1155 .
1156 "\" ORDER BY resvtimeend DESC, idx ASC";
1157 //echo "<pre>\n";
1158 //print_r($query_string);
1159 //echo "</pre>\n";
1160 }
1161 else
1162 {
1163 //User who is a flight instructor.
1164 $query_string = "SELECT idx,type,useridx,alias,"
1165 .
1166 "finstid,finsttimestart,finsttimeend,"
1167 .
1168 "acftsimid,acftsimtimestart,acftsimtimeend,"
1169 .
1170 "resvtimestart,resvtimeend "
1171 .
1172 "FROM resv WHERE (useridx=\""
1173 .
1174 $useridx_in
1175 .
1176 "\" OR finstid=\"" . $rscs_corresponding . "\") AND type!=\"" . RESV_TYPE_BANNER . "\" AND resvtimeend<\""
1177 .
1178 $curtime_in
1179 .
1180 "\" ORDER BY resvtimeend DESC, idx ASC";
1181
1182 //echo "<pre>\n";
1183 //print_r($query_string);
1184 //echo "</pre>\n";
1185 }
1186
1187 //Run the query, get the result.
1188 $result = mysql_query($query_string, $GLOBAL_dbhandle);
1189
1190 //If the query did not go through successfully, return FALSE to the caller.
1191 //
1192 if ($result === FALSE)
1193 {
1194 $rv = FALSE;
1195 }
1196 //
1197 //If the number of rows in the result set is 0, also give the caller FALSE.
1198 else if (mysql_num_rows($result) <= 0)
1199 {
1200 //Technically, we got a result set, so free it.
1201 mysql_free_result($result);
1202
1203 //The caller gets FALSE signaling no data.
1204 $rv = FALSE;
1205 }
1206 else
1207 {
1208 //If we're here, we have a valid result set. Each row of the returned array is
1209 //the expected fields from the resv table.
1210
1211 //Copy out the results to the array we'll return.
1212 while ($row = mysql_fetch_assoc($result))
1213 {
1214 $rv[] = $row;
1215 }
1216
1217 //Free memory.
1218 mysql_free_result($result);
1219 }
1220
1221 //Unlock the database (if it was locked) using the recursive critical section
1222 //method.
1223 if (! $db_was_locked)
1224 {
1225 DB_db_unlock();
1226 $GLOBAL_dblocked = FALSE;
1227 }
1228
1229 //Return the agreed-on result to the caller.
1230 return($rv);
1231 }
1232 //
1233 //--------------------------------------------------------------------------------------------------------------
1234 //Returns the time for a reservation display time.
1235 //
1236 function RESV_time_string_a($st_in)
1237 {
1238 //Split apart the hour and minute as integers.
1239 sscanf(SubStr($st_in, 10, 4), "%02d%02d", $hour, $minute);
1240
1241 if (CONFIG_TIME_FORMAT_24HR)
1242 {
1243 $rv = sprintf("%02d:%02d", $hour, $minute);
1244 }
1245 else
1246 {
1247 if ($hour == 0)
1248 {
1249 $rv = sprintf("12:%02d a.m.", $minute);
1250 }
1251 else if ($hour == 12)
1252 {
1253 $rv = sprintf("12:%02d p.m.", $minute);
1254 }
1255 else if ($hour > 12)
1256 {
1257 $rv = sprintf("%d:%02d p.m.", $hour-12, $minute);
1258 }
1259 else
1260 {
1261 $rv = sprintf("%d:%02d a.m.", $hour, $minute);
1262 }
1263 }
1264
1265 return($rv);
1266 }
1267 //
1268 //--------------------------------------------------------------------------------------------------------------
1269 //Returns the date for a reservation display date.
1270 //
1271 function RESV_date_string_a($st_in)
1272 {
1273 if (CONFIG_DATE_FORMAT_EUROPEAN)
1274 {
1275 $rv = SubStr($st_in, 2, 4) . "/" . SubStr($st_in, 6, 2) . "/" . SubStr($st_in, 8, 2);
1276 }
1277 else
1278 {
1279 $rv = SubStr($st_in, 6, 2) . "/" . SubStr($st_in, 8, 2) . "/" . SubStr($st_in, 2, 4);
1280 }
1281
1282 return($rv);
1283 }
1284 //
1285 //--------------------------------------------------------------------------------------------------------------
1286 //Returns the text corresponding to the date range for printout of reservations. If the two
1287 //STIMEs correspond to the same date, the date is compressed into one.
1288 //
1289 function RESV_date_range_string_a($st_start_in, $st_end_in)
1290 {
1291 if (SubStr($st_start_in, 0, 10) == SubStr($st_end_in, 0, 10))
1292 {
1293 //Dates are the same, so can just do the date once.
1294 $rv = RESV_date_string_a($st_start_in)
1295 .
1296 " ("
1297 .
1298 STIME_dow_string_a($st_start_in)
1299 .
1300 ") "
1301 .
1302 RESV_time_string_a($st_start_in)
1303 .
1304 " - "
1305 .
1306 RESV_time_string_a($st_end_in);
1307 }
1308 else
1309 {
1310 //Dates are different so must do it twice.
1311 $rv = RESV_date_string_a($st_start_in)
1312 .
1313 " ("
1314 .
1315 STIME_dow_string_a($st_start_in)
1316 .
1317 ") "
1318 .
1319 RESV_time_string_a($st_start_in)
1320 .
1321 " - "
1322 .
1323 RESV_date_string_a($st_end_in)
1324 .
1325 " ("
1326 .
1327 STIME_dow_string_a($st_end_in)
1328 .
1329 ") "
1330 .
1331 RESV_time_string_a($st_end_in);
1332 }
1333
1334 //Tack on the duration.
1335 $rv = $rv . " (" . STIME_diff_string_a($st_start_in, $st_end_in) . ")";
1336
1337 return($rv);
1338 }
1339 //
1340 //--------------------------------------------------------------------------------------------------------------
1341 //Returns the text corresponding to a given reservation, flight instructor first. If the date
1342 //and time for the aircraft/simulator and flight instructor are the same, only one string is returned.
1343 //
1344 function RESV_resv_date_string_a($resv_in, $personstring, $acftsimstring)
1345 {
1346 if (($resv_in["finstid"] != 0) && ($resv_in["acftsimid"] != 0))
1347 {
1348 //Both a flight instructor and an aircraft.
1349 if (($resv_in["finsttimestart"] == $resv_in["acftsimtimestart"]) && ($resv_in["finsttimeend"] == $resv_in["acftsimtimeend"]))
1350 {
1351 //Start and end time of the instructor and aircraft are the same. Can combine them.
1352 //
1353 $rv = RESV_date_range_string_a($resv_in["finsttimestart"], $resv_in["finsttimeend"]);
1354 }
1355 else
1356 {
1357 //Start and end time of instructor and aircraft are different. Cannot combine them.
1358 $rv = $personstring
1359 .
1360 " "
1361 .
1362 RESV_date_range_string_a($resv_in["finsttimestart"], $resv_in["finsttimeend"])
1363 .
1364 ", "
1365 .
1366 $acftsimstring
1367 .
1368 " "
1369 .
1370 RESV_date_range_string_a($resv_in["acftsimtimestart"], $resv_in["acftsimtimeend"])
1371 ;
1372 }
1373
1374 }
1375 else if (($resv_in["finstid"] == 0) && ($resv_in["acftsimid"] != 0))
1376 {
1377 //Aircraft but no flight instructor.
1378 $rv = RESV_date_range_string_a($resv_in["acftsimtimestart"], $resv_in["acftsimtimeend"]);
1379 }
1380 else if (($resv_in["finstid"] != 0) && ($resv_in["acftsimid"] == 0))
1381 {
1382 //Flight instructor but no aircraft.
1383 $rv = RESV_date_range_string_a($resv_in["finsttimestart"], $resv_in["finsttimeend"]);
1384 }
1385 else
1386 {
1387 //Should never be here. Return the empty string to be safe.
1388 $rv = "";
1389 }
1390
1391 return($rv);
1392 }
1393 //
1394 //--------------------------------------------------------------------------------------------------------------
1395 //End of $RCSfile: resvx.inc,v $.
1396 //--------------------------------------------------------------------------------------------------------------
1397 ?>

dashley@gmail.com
ViewVC Help
Powered by ViewVC 1.1.25