admin/include/insert.php

<?php
/**********************************************************
Function Library: insert.php
Original Author: Paul Bramscher <brams006@tc.umn.edu>
Last Modified: 09.30.2003 by Paul Bramscher
***********************************************************
Comments:
This library brings together all SQL insert functions for
LibData general setup tables.  Those pertaining to
CLPS and RQS are located in scribe_application.php and
subject_builder.php respectively.
***********************************************************
Table of Contents:

insertCoursesub
insertFaculty
insertFeature
insertInfotype
insertLibunit
insertLocation
insertResource
insertService
insertSingleField
insertStaff
insertStyle
insertSubject


**********************************************************/


/**********************************************************
Function: insertCoursesub
Author: Paul Bramscher
Last Modified: 06.03.2003
***********************************************************
Purpose:
Inserts a course subject.
**********************************************************/
function insertCoursesub($con, $campus_id, $cip_code, $coursesub, $coursesub_descr) {

        // Error flag
        $err_code = 0;  

        // Need for display/uniqueness
        $coursesub_display = $coursesub;
        $coursesub_search = textSearchmySQL($coursesub);

        // Check to see if already exists
        $exists = recordCount($con, "coursesub", "coursesub", $coursesub_search, "A");
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. '" . $coursesub_display . "' already exists in the course subject table.";
        }
        
        // Check for blank entry
        if ($coursesub == "") {
                $err_code = 2;
                $err_msg = "Failed.  Cannot enter a blank course subject.";
        }

        printf("<center><h3>Adding Course Subject...</h3>");

        // Table
        printf("<table width = \"60%%\" border = \"3\" cellpadding =\"4\" class=\"backLight\">");
        printf("<tr><td><br>");
        printf("<strong>Messages:</strong><br>");

        // Add only if this coursesub doesn't already exist, and something was supplied
        if ($err_code == 0) {

                // Clean up strings

                // Set up SQL
                $sql = "INSERT INTO coursesub (coursesub, coursesub_descr, cip_code, campus_id) VALUES ( ? ,  ? ,  ? ,  ? )";
        
                // Write the new row to the database
                if (!xx_prepare_execute($sql, $coursesub, $coursesub_descr, $cip_code, $campus_id)){
                        sql_err($con);
                        xx_query ("UNLOCK TABLES", $con);
                        bailout();
                }
                else {
                        printf("Added Course Subject <b>%s</b>.<BR>", $coursesub_display);
                        xx_query("UNLOCK TABLES", $con);
                }
        }
        else printf("%s", $err_msg);
        printf("<br><br>\n");
        printf("</td></tr></table>\n");
        printf("</center>\n");
}


/**********************************************************
Function: insertFaculty
Author: Paul Bramscher
Last Modified: 06.24.2003
***********************************************************
Purpose:
Inserts a faculty member.
**********************************************************/
function insertFaculty($con, $faculty_email, $faculty_firstname,
        $faculty_lastname, $faculty_account) {

        /*
        Faculty must have both a unique non-blank staff_account, and non-blank last name.
        */

        // Error flag
        $err_code = 0;  

        // Need for display/uniqueness
        $faculty_name_display = $faculty_firstname . " " . $faculty_lastname;
        $exists_id = existsFaculty($con, $faculty_firstname, $faculty_lastname);

        if ($exists_id > 0) {
                $err_code = 1;
                $err_msg = "Failed. '" . $faculty_name_display . "' already exists in the Faculty table.";
        }

        // Check for blank last name
        if ($faculty_lastname == "") {
                $err_code = 2;
                $err_msg = "Failed.  Cannot enter a blank Last Name.";
        }

        printf("<center><h3>Adding Faculty...</h3>");

        // Table
        printf("<table width = \"60%%\" border = \"3\" cellpadding =\"4\" class=\"backLight\">");
        printf("<tr><td><br>");
        printf("<strong>Messages:</strong><br>");

        // Add only if no errors encountered
        if ($err_code == 0) {

                // Clean up strings

                // Set up SQL
                $sql = "INSERT INTO faculty (faculty_lastname, faculty_firstname,
                        faculty_email, faculty_account) VALUES ( ? ,  ? ,  ? ,  ? )";
                
                // Write the new row to the database
                if (!xx_prepare_execute($sql, $faculty_lastname, $faculty_firstname, $faculty_email, $faculty_account)){
                        sql_err($con);
                        xx_query ("UNLOCK TABLES", $con);
                        bailout();
        }
                else {
                        printf("Added <b>%s</b> to the faculty table.<BR>\n", $faculty_name_display);
                        xx_query("UNLOCK TABLES", $con);
                }
        }
        
        else printf("%s", $err_msg);
        printf("<br><br>\n");
        printf("</td></tr></table>\n");
        printf("</center>\n");
}


/**********************************************************
Function: insertFeature
Author: Paul Bramscher
Last Modified: 05.21.2003
***********************************************************
Purpose:
Inserts a feature.
**********************************************************/
function insertFeature($con, $feature, $image_alt, $image_path) {

        // Error flag
        $err_code = 0;  

        // Need for display/uniqueness
        $feature_display = $feature;
        $feature_search = textSearchmySQL($feature);

        // Check to see if already exists
        $exists = recordCount($con, "feature", "feature", $feature_search, "A");
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. '" . $feature_display . "' already exists in the feature table.";
        }
        
        // Check for blank entry
        if ($feature == "") {
                $err_code = 2;
                $err_msg = "Failed.  Cannot enter a blank feature.";
        }

        printf("<center><h3>Adding Feature...</h3>");

        // Table
        printf("<table width = \"60%%\" border = \"3\" cellpadding =\"4\" class=\"backLight\">");
        printf("<tr><td><br>");
        printf("<strong>Messages:</strong><br>");

        // Add only if this feature doesn't already exist, and something was supplied
        if ($err_code == 0) {

                // Clean up strings

                // Set up SQL
                $sql = "INSERT INTO feature (feature, image_alt, image_path) VALUES ( ? ,  ? ,  ? )";
        
                // Write the new row to the database
                if (!xx_prepare_execute($sql, $feature, $image_alt, $image_path)){
                        sql_err($con);
                        xx_query ("UNLOCK TABLES", $con);
                        bailout();
        }
                else {
                        printf("Added Feature <b>%s</b>.<BR>", $feature_display);
                        xx_query("UNLOCK TABLES", $con);
                }
        }
        else printf("%s", $err_msg);
        printf("<br><br>\n");
        printf("</td></tr></table>\n");
        printf("</center>\n");
}


/**********************************************************
Function: insertInfotype
Author: Paul Bramscher
Last Modified: 05.21.2003
***********************************************************
Purpose:
Inserts an information type.
**********************************************************/
function insertInfotype($con, $infotype, $masterinfotype_id, $mastersubject_id) {

        // Error flag
        $err_code = 0;  

        // Need for display/uniqueness purposes
        $infotype_display = $infotype;
        $infotype_search = textSearchmySQL($infotype);
        
        // Check to see if already exists
        $exists = recordCount($con, "infotype", "infotype", $infotype_search, "A");
        
        // If exists in the table
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. '" . $infotype_display . "' already exists in the Information Type table.";
        }
        
        // Check for blank entry
        if ($infotype == "") {
                $err_code = 2;
                $err_msg = "Failed.  Must supply some value for the Information Type name.";
        }


        printf("<center><h3>Adding Information Type...</h3>");

        // Table
        printf("<table width = \"60%%\" border = \"3\" cellpadding =\"4\" class=\"backLight\">");
        printf("<tr><td><br>");
        printf("<strong>Messages:</strong><br>");

        // Add only if this infotype doesn't already exist
        if ($err_code == 0) {

                // Clean up strings

                // Set up SQL
                $sql = "INSERT INTO infotype (infotype, masterinfotype_id, mastersubject_id) VALUES ( ? ,  ? ,  ? )";
                
                // Write the new row to the database
                if (!xx_prepare_execute($sql, $infotype, $masterinfotype_id, $mastersubject_id)){
                        sql_err($con);
                        xx_query ("UNLOCK TABLES", $con);
                        bailout();
                }
                else {
                        printf("Added Information Type <b>%s</b>.<BR>", $infotype_display);
                        xx_query("UNLOCK TABLES", $con);
                }
        }

        else printf("%s<BR><BR>", $err_msg);

        // Close the table
        printf("<BR>");
        printf("</td></tr></table>");
        printf("</center>");
}


/**********************************************************
Function: insertLibunit
Author: Paul Bramscher
Last Modified: 05.22.2003
***********************************************************
Purpose:
Inserts the supplied library unit information into the
database, and calls formLibunit back again, if the
insert passed a few checks (unique, no blank values, etc.)
**********************************************************/
function insertLibunit($con, $head_staff_id, $libunit, $libunit_abbrev) {

        /*
        Library Units must have both a unique name and unique abbreviation
        e.g. "Digital Library Developement Laboratory" and "DLDL"
        Additionally, empty values are not allowed.
        */

        // Error flag
        $err_code = 0;  

        // Need for display/uniqueness purposes
        $libunit_display = $libunit;
        $libunit_abbrev_display = $libunit_abbrev;
        $libunit_search = textSearchmySQL($libunit);
        $libunit_abbrev_search = textSearchmySQL($libunit_abbrev);

        // Check to see if libunit already exists
        $exists = recordCount($con, "libunit", "libunit", $libunit_search, "A");
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. '" . $libunit_display . "' already exists in the Library Unit table.";
        }

        // Check to see if libunit abbreviation already exists
        $exists = recordCount($con, "libunit", "libunit_abbrev", $libunit_abbrev_search, "A");
        if ($exists > 0) {
                $err_code = 2;
                $err_msg = "Failed. '" . $libunit_abbrev_display . "' abbreviation already exists in the Library Unit table.";
        }

        // Check for blank linunit entry
        if ($libunit == "") {
                $err_code = 3;
                $err_msg = "Failed.  Cannot enter a blank Library Unit.";
        }

        // Check for blank linunit abbrev entry
        if ($libunit_abbrev == "") {
                $err_code = 4;
                $err_msg = "Failed.  Cannot enter a blank Library Unit abbreviation.";
        }

        // Add only if no errors encountered
        if ($err_code == 0) {


                $sql = "INSERT INTO libunit (libunit, libunit_abbrev, head_staff_id) VALUES ( ? ,  ? ,  ? )";
                
                // Write the new row to the database
                xx_query ("LOCK TABLE libunit WRITE", $con);
                if (!xx_prepare_execute($sql, $libunit, $libunit_abbrev, $head_staff_id)){
                        sql_err($con);
                        xx_query ("UNLOCK TABLES", $con);
                        bailout();
        }
                else {
                        // $libunit_id = xx_insert_id($con)
                        $insert_res = xx_prepare_execute("select 1 as id from libunit where libunit = ? and libunit_abbrev = ? and head_staff_id = ?", $libunit, $libunit_abbrev, $head_staff_id);
                        list($libunit_id) = $insert_res->fetchRow(DB_FETCHMODE_ORDERED);
                        xx_query("UNLOCK TABLES", $con);
                        formLibunit($con, $libunit_id);
                }
        }
        
        else {
                printf("<center><h3>Adding Library Unit...</h3>");

                // Table
                printf("<table width = \"60%%\" border = \"3\" cellpadding =\"4\" class=\"backLight\">\n");
                printf("<tr><td><br>\n");
                printf("<strong>Messages:</strong><br>\n");
                printf("%s", $err_msg);
                printf("<BR><BR>\n");
                printf("</td></tr></table>\n");
                printf("</center>\n");
        }
}


/**********************************************************
Function: insertLocation
Author: Paul Bramscher
Last Modified: 06.16.2003
***********************************************************
Purpose:
Inserts a library/location.
**********************************************************/
function insertLocation($con, $address1, $address2, $address3,
        $address4, $campus, $hoursURL, $location, $location_descr, $mainURL,
        $mapURL, $referenceURL, $telephone) {

        // Need for display purposes
        $location_display = $location;
        $location_search = textSearchmySQL($location);

        // Error flag
        $err_code = 0;  

        // Check to see if already exists
        $exists = recordCount($con, "location", "location", $location_search, "A");
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. '" . $location_display . "' already exists in the location table.";
        }
        
        // Check for blank entry
        if ($location == "") {
                $err_code = 2;
                $err_msg = "Failed.  Cannot enter a blank location.";
        }

        printf("<center><h3>Adding Location...</h3>\n");

        // Table
        printf("<table width = \"60%%\" border = \"3\" cellpadding =\"4\" class=\"backLight\">\n");
        printf("<tr><td><br>\n");
        printf("<strong>Messages:</strong><br>\n");

        // Add only if this location doesn't already exist, and something was supplied
        if ($err_code == 0) {

                // Clean up strings

                // Set up SQL
                $sql = "INSERT INTO location (location, location_descr, campus, address1,
                                address2, address3, address4, telephone, mainURL, referenceURL,
                                mapURL, hoursURL) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? )";

                // Write the new row to the database
                if (!xx_prepare_execute($sql, $location, $location_descr, $campus, $address1, $address2, $address3, $address4, $telephone, $mainURL, $referenceURL, $mapURL, $hoursURL)){
                        sql_err($con);
                        xx_query ("UNLOCK TABLES", $con);
                        bailout();
                }
                else {

                        printf("Added <b>%s</b> location.", $location_display);
                        xx_query("UNLOCK TABLES", $con);
                }
        }
        
        else printf("%s", $err_msg);
        printf("<br><br>\n");
        printf("</td></tr></table>\n");
        printf("</center>\n");

}


/**********************************************************
Function: insertResource
Author: Paul Bramscher
Last Modified: 04.21.2003
***********************************************************
Purpose:
Inserts a resource.
**********************************************************/
function insertResource($con, $annotation, $author, $call_no, $cat_num,
        $coverage_detail, $edition, $infotype_id, $mastersubject_id, $other_title,
        $pub_date, $publisher, $sess_staff_account, $sources_indexed, $title, $url) {

        // Error flag
        $err_code = 0;  

        // Check to see if already exists
        $exists = recordCount($con, "resource", "title", $title, "A");
        
        // If exists in the table
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. '" . $title . "' already exists in the Resource table.";
        }
        
        // Check for blank entry
        if ($title == "") {
                $err_code = 2;
                $err_msg = "Failed.  Must supply some value for the Title field.";
        }
        
        // Proceed only if no errors
        if ($err_code == 0) {

                // Clean up strings

                // Build the SQL
                $sql = "INSERT INTO resource (annotation, author, call_no, cat_num,
                        coverage_detail, date_created, date_modified, edition,
                        infotype_id, other_title, pub_date, publisher, sources_indexed,
                        title, url, account_created) VALUES ( ? ,  ? ,  ? ,  ? ,  ? , now(), now(),  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? )";

                // Debugging
                // printf("sql was: %s<BR>", $sql);

                // Write the new record to the database
                xx_query ("LOCK TABLE resource WRITE", $con);
                if (!xx_prepare_execute($sql, $annotation, $author, $call_no, $cat_num, $coverage_detail, $edition, $infotype_id, $other_title, $pub_date, $publisher, $sources_indexed, $title, $url, $sess_staff_account)){
                        sql_err($con);
                        xx_query ("UNLOCK TABLES", $con);
                        bailout();
                }
                else {
                        // $resource_id = xx_insert_id($con)
                        $insert_res = xx_prepare_execute("select 1 as id from resource where annotation = ? and author = ? and call_no = ? and cat_num = ? and coverage_detail = ? and date_created = ? and date_modified = ? and edition = ? and infotype_id = ? and other_title = ? and pub_date = ? and publisher = ? and sources_indexed = ? and title = ? and url = ? and account_created = ?", $annotation, $author, $call_no, $cat_num, $coverage_detail, $edition, $infotype_id, $other_title, $pub_date, $publisher, $sources_indexed, $title, $url, $sess_staff_account);
                        list($resource_id) = $insert_res->fetchRow(DB_FETCHMODE_ORDERED);
                        xx_query("UNLOCK TABLES", $con);

                        // Now set up this resource with its first mastersubject
                        // Note that id#1 = N/A and id#2 = (All), and are not used here.
                        if ($mastersubject_id > 2) {       
                                $sql = "INSERT INTO res_mastersubject (resource_id, mastersubject_id) VALUES ( ? ,  ? )";

                                // Write the new res_mastersubject to the database
                                xx_query ("LOCK TABLE res_mastersubject WRITE", $con);
                                if (!xx_prepare_execute($sql, $resource_id, $mastersubject_id)){
                                        sql_err($con);
                                        xx_query ("UNLOCK TABLES", $con);
                                        bailout();
                                }
                                else {
                                        xx_query("UNLOCK TABLES", $con);
                                }
                        }
                }

                // Call the formResource page back, in case user wants to edit further
                formResource($con, $resource_id, 0, 0, '');

        } // end insert new resource
        
        else {
                printf("<center><h3>Adding Resource...</h3>");

                // Table
                printf("<table width = \"60%%\" border = \"3\" cellpadding =\"4\" class=\"backLight\">\n");
                printf("<tr><td><br>\n");
                printf("<strong>Messages:</strong><br>\n");
                printf("%s", $err_msg);
                printf("<BR><BR>\n");
                printf("</td></tr></table>\n");
                printf("</center>\n");
        } // end error messages

} // end function


/**********************************************************
Function: insertSingleField
Author: Paul Bramscher
Last Modified: 05.21.2003
***********************************************************
Purpose:
Inserts any single field value into any table.
**********************************************************/
function insertSingleField($con, $display, $field, $newValue, $table){

        // Error flag
        $err_code = 0;  

        // Need for display/uniqueness purposes
        $newValue_search = textSearchmySQL($newValue);
        $newValue_display = $newValue;  

        // Check to see if already exists
        $exists = recordCount($con, $table, $field, $newValue_search, "A");
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. <b>"
                        . $newValue_display
                        . "</b> already exists in the "
                        . $display
                        . " table.";
        }
        
        // Check for blank entry
        if ($newValue == "") {
                $err_code = 2;
                $err_msg = "Failed.  Cannot enter a blank <b>"
                        . $display
                        . "</b> value.";
        }

        // Draw page heading
        printf("<center><h3>Adding New %s</h3>", $display);

        printf("<table width =\"50%%\" border = \"3\" class=\"backLight\">");
        printf("<tr><td><b>Messages:</b><br>");

        // Add only if this item doesn't already exist, and a value was supplied
        if ($err_code == 0){

                // Clean up strings

                // Build the SQL
                $sql = "INSERT INTO  ?  ( ? ) VALUES ( ? )";

                // Debugging
                // printf("sql was: %s<br>", $sql);

                if (!xx_prepare_execute($sql, $table, $field, $newValue)){
                        sql_err($sql);
                        xx_query ("UNLOCK TABLES", $con);
                        bailout();
                }
                else {
                        // $new_id = xx_insert_id($con)
                        $insert_res = xx_prepare_execute("select 1 as id from ? where  ?  = ?", $table, $field, $newValue);
                        list($new_id) = $insert_res->fetchRow(DB_FETCHMODE_ORDERED);
                        xx_query ("UNLOCK TABLES", $con);
                        printf("%s <b>%s</b> successfully added.\n", $display, $newValue_display);
                }
        }

        else printf ("%s\n", $err_msg); 
        printf("<br><br></td></tr></table>");
        printf("</center>");
}


/**********************************************************
Function: insertService
Author: Paul Bramscher
Last Modified: 05.21.2003
***********************************************************
Purpose:
Inserts a service.
**********************************************************/
function insertService($con, $address1, $address2, $address3, $address4,
        $email, $fax, $nonaff, $service, $serviceDescr, $serviceURL, $telephone) {

        // Error flag
        $err_code = 0;  

        // Need for display/uniqueness
        $service_display = $service;
        $service_search = textSearchmySQL($service);

        // Check to see if already exists
        $exists = recordCount($con, "service", "service", $service_search, "A");
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. '" . $service_display . "' already exists in the service table.";
        }
        
        // Check for blank entry
        if ($service == "") {
                $err_code = 2;
                $err_msg = "Failed.  Cannot enter a blank service.";
        }

        // Add only if this service doesn't already exist, and something was supplied
        if ($err_code == 0) {

                // Clean up strings

                // Set up SQL
                $sql = "INSERT INTO service (address1, address2, address3, address4,
                                email, fax, nonaff, service, serviceDescr, serviceURL,
                                telephone) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? )";
                
                // Write the new row to the database
                xx_query ("LOCK TABLE service WRITE", $con);
                if (!xx_prepare_execute($sql, $address1, $address2, $address3, $address4, $email, $fax, $nonaff, $service, $serviceDescr, $serviceURL, $telephone)){
                        sql_err($con);
                        xx_query ("UNLOCK TABLES", $con);
                        bailout();
                }
                else {
                        // $service_id = xx_insert_id($con)
                        $insert_res = xx_prepare_execute("select 1 as id from service where address1 = ? and address2 = ? and address3 = ? and address4 = ? and email = ? and fax = ? and nonaff = ? and service = ? and serviceDescr = ? and serviceURL = ? and telephone = ?", $address1, $address2, $address3, $address4, $email, $fax, $nonaff, $service, $serviceDescr, $serviceURL, $telephone);
                        list($service_id) = $insert_res->fetchRow(DB_FETCHMODE_ORDERED);
                        xx_query("UNLOCK TABLES", $con);
                        formService($con, $service_id);                 
                }
        }
        else {
                // Draw page heading
                printf("<center><h3>Adding New Service...</h3>");

                printf("<table width =\"50%%\" border = \"3\" class=\"backLight\">");
                printf("<tr><td><b>Messages:</b><br>"); 
        
                printf ("%s\n", $err_msg); 
                printf("<br><br></td></tr></table>");
                printf("</center>");
        }

}


/**********************************************************
Function: insertStaff
Author: Paul Bramscher
Last Modified: 06.23.2003
***********************************************************
Purpose:
Inserts the supplied staffperson information, and calls
formStaff back again if the insert was valid.
**********************************************************/
function insertStaff($con, $access_id, $first_name,
        $last_name, $sess_access_level, $staff_account, $staff_email, $stafftitle_id) {

        /*
        Staff must have, at a minimum, a last name, first name, and unique staff account name.
        Uniqueness is enforced only on staff_account.
        */

        // Error flag
        $err_code = 0;  

        // Need for display/uniqueness purposes
        $staff_account_display = $staff_account;
        $staff_account_search = textSearchmySQL($staff_account);

        // Check to see if the account name already exists
        $exists = recordCount($con, "staff", "staff_account", $staff_account_search, "A");
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. '" . $staff_account_display . "' already exists in the Staff table.";
        }

        // Check for blank first name or last name
        if ($first_name == "" || $last_name == "") {
                $err_code = 2;
                $err_msg = "Failed.  A first and last name must be supplied for all staff.";
        }

        // Check for blank staff account
        if ($staff_account == "") {
                $err_code = 3;
                $err_msg = "Failed.  A staff account (x500 if applicable) must be supplied for all staff.";
        }

        // Check for access level higher than current access
        $this_access_level = lookupfield($con, "access", "access_id", $access_id, "access_level");
        if ($this_access_level > $sess_access_level) {
                $err_code = 4;
                $err_msg = "Failed.  You may not create staff with higher privileges than your own.";
        }

        // Add only if no errors encountered
        if ($err_code == 0) {

                // Clean up strings

                // Set up SQL
                $sql = "INSERT INTO staff (access_id, first_name, last_name, stafftitle_id,
                        staff_account, staff_email) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? )";

                // Debugging
                // printf("sql was: %s<br><br>\n", $sql);
                
                // Write the new row to the database
                xx_query ("LOCK TABLE staff WRITE", $con);
                if (!xx_prepare_execute($sql, $access_id, $first_name, $last_name, $stafftitle_id, $staff_account, $staff_email)){
                        sql_err($con);
                        xx_query ("UNLOCK TABLES", $con);
                        bailout();
        }
                else {

                        // Success, call formStaff back.
                        // $staff_id = xx_insert_id($con)
                        $insert_res = xx_prepare_execute("select 1 as id from staff where access_id = ? and first_name = ? and last_name = ? and stafftitle_id = ? and staff_account = ? and staff_email = ?", $access_id, $first_name, $last_name, $stafftitle_id, $staff_account, $staff_email);
                        list($staff_id) = $insert_res->fetchRow(DB_FETCHMODE_ORDERED);
                        xx_query("UNLOCK TABLES", $con);
                        formStaff($con, $staff_id);
                }
        }
        else {
                // Failure message box
                printf("<center><h3>Adding Staff...</h3>\n");
                printf("<table width = \"60%%\" border = \"3\" cellpadding =\"4\" class=\"backLight\">\n");
                printf("<tr><td><br>\n");
                printf("<strong>Messages:</strong><br>\n");
                printf("%s", $err_msg);
                printf("<br><br>\n");
                printf("</td></tr></table>\n");
                printf("</center>\n");
        }
}


/**********************************************************
Function: insertStyle
Author: Paul Bramscher
Last Modified: 05.22.2003
***********************************************************
Purpose:
Inserts a style type.  Note that css_file, footer_file, and
header_file fields are merely pointers to those files.
No error checking is done here to ensure their existence
and permissions settings.  This must be accomplished by
someone with proper OS access.
**********************************************************/
function insertStyle($con, $css_file, $footer_file, $header_file, $style_title) {

        // Error flag
        $err_code = 0;  

        // Need for display/uniqueness
        $style_title_display = $style_title;
        $style_title_search = textSearchmySQL($style_title);

        // Check to see if already exists
        $exists = recordCount($con, "style", "style_title", $style_title_search, "A");
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. '" . $style_title_display . "' already exists in the style table.";
        }
        
        // Check for blank entry
        if ($style_title == "") {
                $err_code = 2;
                $err_msg = "Failed.  Cannot enter a blank style.";
        }

        printf("<center><h3>Adding Style...</h3>");

        // Table
        printf("<table width = \"60%%\" border = \"3\" cellpadding =\"4\" class=\"backLight\">");
        printf("<tr><td><br>");
        printf("<strong>Messages:</strong><br>");

        // Add only if this style doesn't already exist, and something was supplied
        if ($err_code == 0) {

                // Clean up strings
                
                // Set up SQL
                $sql = "INSERT INTO style (css_file, footer_file, header_file, style_title) VALUES ( ? ,  ? ,  ? ,  ? )";
                
                // Write the new row to the database
                if (!xx_prepare_execute($sql, $css_file, $footer_file, $header_file, $style_title)){
                        sql_err($con);
                        xx_query ("UNLOCK TABLES", $con);
                        bailout();
                }
                else {
                        xx_query("UNLOCK TABLES", $con);                        
                        printf("Added <b>%s</b> style.<br><br>\n", $style_title_display);
                }
        }
        else printf("%s", $err_msg);
        printf("<br><br>\n");
        printf("</td></tr></table>\n");
        printf("</center>\n");
}


/**********************************************************
Function: insertSubject
Author: Paul Bramscher
Last Modified: 09.23.2003
***********************************************************
Purpose:
Inserts a subject.  If successful, calls formSubject
back again.
**********************************************************/
function insertSubject($con, $sess_staff_account, $sess_staff_id, $subject, $subject_descr, $sublocation_id) {

        // Error flag
        $err_code = 0;  

        // Need for display/uniqueness purposes
        $subject_display = $subject;
        $subject_search = textSearchmySQL($subject);

        // Check to see if already exists
        $exists = recordCount($con, "subject", "subject", $subject_search, "A");
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. '" . $subject_display . "' already exists in the subject table.";
        }
        
        // Check for blank entry
        if ($subject == "") {
                $err_code = 2;
                $err_msg = "Failed.  Cannot enter a blank subject.";
        }

        // Add only if this subject doesn't already exist, and something was supplied
        if ($err_code == 0) {

                // Clean up strings

                // Set up SQL
                $sql  = "INSERT INTO subject (subject, subject_descr, sublocation_id, rqs_date_created, rqs_account_created) VALUES ( ? ,  ? ,  ? , now(),  ? )";
                
                // Write the new row to the database
                xx_query ("LOCK TABLE subject WRITE", $con);
                if (!xx_prepare_execute($sql, $subject, $subject_descr, $sublocation_id, $sess_staff_account)){
                        sql_err($con);
                        xx_query ("UNLOCK TABLES", $con);
                        bailout();
                }
                else {
                        // $subject_id = xx_insert_id($con)
                        $insert_res = xx_prepare_execute("select 1 as id from subject where subject = ? and subject_descr = ? and sublocation_id = ? and rqs_account_created = ?", $subject, $subject_descr, $sublocation_id, $sess_staff_account);
                        list($subject_id) = $insert_res->fetchRow(DB_FETCHMODE_ORDERED);
                        xx_query("UNLOCK TABLES", $con);

                        // Insert this staff person as an assigned staff member to this subject
                        $sql = "INSERT INTO sub_staff (subject_id, staff_id) VALUES ( ? ,  ? )";
                                
                        if (!xx_prepare_execute($sql, $subject_id, $sess_staff_id)){
                                sql_err($con);
                                xx_query ("UNLOCK TABLES", $con);
                                bailout();
                        }
                        else {          
                                xx_query("UNLOCK TABLES", $con);
                        }
                        
                        formSubject($con, $subject_id);
                } // good write of subject
        }

        else {
        
                printf("<center><h3>Adding subject...</h3>");

                // Table
                printf("<table width = \"60%%\" border = \"3\" cellpadding =\"4\" class=\"backLight\">");
                printf("<tr><td><br>");
                printf("<strong>Messages:</strong><br>");

                printf("%s<BR><BR>", $err_msg);
                printf("</td></tr></table>");
                printf("</center>");
        }

} // function
?>