admin/include/insert.php

<?php
/**********************************************************
Function Library: insert.php
Original Author: Paul Bramscher <brams006@umn.edu>
Last Modified: 03.15.2004 by Paul Bramscher
***********************************************************
Comments:
This library brings together all SQL insert functions for
LibData general setup tables.  Those pertaining to
PageScribe and SubjectBuilder 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
insertVendor
**********************************************************/


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

        msgTableOpen(1, "Adding Course Subject...");
        printf("<b>Messages:</b><br>\n");

        // Error flag
        $err_code = 0;  

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

        // Check to see if already exists
        $exists = recordCount("coursesub", "coursesub", $coursesub_search, "A");
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. <b>" . $coursesub_display . "</b> 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.";
        }

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

                // Clean up strings
                if (strlen($coursesub) > 0) $coursesub = textInmySQL($coursesub);
                if (strlen($coursesub_descr) > 0) $coursesub_descr = textInmySQL($coursesub_descr);
                if (strlen($cip_code) > 0) $cip_code = textInmySQL($cip_code);

                // Set up SQL
                $sql = "INSERT INTO coursesub (coursesub, coursesub_descr, cip_code, campus_id) VALUES ('"
                        . $coursesub
                        . "', '"
                        . $coursesub_descr
                        . "', '"
                        . $cip_code
                        . "', "
                        . $campus_id
                        . ")";
        
                // Write the new row to the database
                if (mysql_tryquery($sql)) printf("Added Course Subject <b>%s</b>.", $coursesub_display);
        }
        else printf("%s", $err_msg);
        
        printf("<br><br>\n");
        msgTableClose();
}


/**********************************************************
Function: insertFaculty
Author: Paul Bramscher
Last Modified: 03.15.2004
***********************************************************
Purpose:
Inserts a faculty member.  Faculty must have a last name,
and unique first/last name pair.
**********************************************************/
function insertFaculty($faculty_email, $faculty_firstname,
        $faculty_lastname, $faculty_account) {

        msgTableOpen(1, "Adding Faculty...");
        printf("<b>Messages:</b><br>\n");       

        // Error flag
        $err_code = 0;  

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

        if ($exists_id > 0) {
                $err_code = 1;
                $err_msg = "Failed. <b>" . $faculty_name_display . "</b> 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.";
        }

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

                // Clean up strings
                if (strlen($faculty_lastname) > 0) $faculty_lastname = textInmySQL($faculty_lastname);
                if (strlen($faculty_firstname) > 0) $faculty_firstname = textInmySQL($faculty_firstname);
                if (strlen($faculty_email) > 0) $faculty_email = textInmySQL($faculty_email);
                if (strlen($faculty_account) > 0) $faculty_account = textInmySQL($faculty_account);

                // Set up SQL
                $sql = "INSERT INTO faculty (faculty_lastname, faculty_firstname,
                        faculty_email, faculty_account) VALUES ('"
                        . $faculty_lastname
                        . "', '"
                        . $faculty_firstname
                        . "', '"
                        . $faculty_email
                        . "', '"
                        . $faculty_account
                        . "')";

                // Write the new row to the database
                if (mysql_tryquery($sql)) printf("Added <b>%s</b> to the faculty table.", $faculty_name_display);
        }
        
        else printf("%s", $err_msg);
        
        printf("<br><br>\n");
        msgTableClose();
}


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

        msgTableOpen(1, "Adding Feature...");
        printf("<b>Messages:</b><br>\n");       

        // Error flag
        $err_code = 0;  

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

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

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

                // Clean up strings
                if (strlen($feature) > 0) $feature = textInmySQL($feature);
                if (strlen($image_alt) > 0) $image_alt = textInmySQL($image_alt);
                if (strlen($image_path) >0) $image_path = textInmySQL($image_path);

                // Set up SQL
                $sql = "INSERT INTO feature (feature, image_alt, image_path) VALUES ('"
                        . $feature
                        . "', '"
                        . $image_alt
                        . "', '"
                        . $image_path
                        . "')";
        
                // Write the new row to the database
                if (mysql_tryquery($sql)) printf("Added Feature <b>%s</b>.", $feature_display);

        }
        else printf("%s", $err_msg);
        
        printf("<br><br>\n");
        msgTableClose();
}


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

        msgTableOpen(1, "Adding Information Type...");
        printf("<b>Messages:</b><br>\n");

        // 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("infotype", "infotype", $infotype_search, "A");
        
        // If exists in the table
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. <b>" . $infotype_display . "</b> 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.";
        }

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

                // Clean up strings
                if (strlen($infotype) > 0) $infotype = textInmySQL($infotype);

                // Set up SQL
                $sql = "INSERT INTO infotype (infotype, masterinfotype_id, mastersubject_id) VALUES ('"
                        . $infotype
                        . "', "
                        . $masterinfotype_id
                        . ", "
                        . $mastersubject_id
                        . ")";
                
                // Write the new row to the database
                if (mysql_tryquery($sql)) printf("Added Information Type <b>%s</b>.", $infotype_display);
        }
        else printf("%s", $err_msg);
        
        printf("<br><br>\n");
        msgTableClose();
}


/**********************************************************
Function: insertLibunit
Author: Paul Bramscher
Last Modified: 03.15.2004
***********************************************************
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.)

Library Units must have both a unique name and unique
abbreviation e.g. "Digital Library Developement Laboratory"
and "DLDL".
**********************************************************/
function insertLibunit($head_staff_id, $libunit, $libunit_abbrev) {

        // 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("libunit", "libunit", $libunit_search, "A");
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. <b>" . $libunit_display . "</b> already exists in the Library Unit table.";
        }

        // Check to see if libunit abbreviation already exists
        $exists = recordCount("libunit", "libunit_abbrev", $libunit_abbrev_search, "A");
        if ($exists > 0) {
                $err_code = 2;
                $err_msg = "Failed. <b>" . $libunit_abbrev_display . "</b> 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) {

                if (strlen($libunit) > 0) $libunit = textInmySQL($libunit);
                if (strlen($libunit_abbrev) > 0) $libunit_abbrev = textInmySQL($libunit_abbrev);

                $sql = "INSERT INTO libunit (libunit, libunit_abbrev, head_staff_id) VALUES ('"
                        . $libunit
                        . "', '"
                        . $libunit_abbrev
                        . "', "
                        . $head_staff_id
                        . ")";
                
                // Write the new row to the database
                mysql_tryquery ($sql);
                $libunit_id = mysql_insert_id();
                formLibunit($libunit_id);
        }
        else {
                msgTableOpen(1, "Adding Library Unit...");
                printf("<b>Messages:</b><br>\n");       
                printf("%s", $err_msg);
                printf("<br><br>\n");
                msgTableClose();        
        }
}


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

        msgTableOpen(1, "Adding Location...");
        printf("<b>Messages:</b><br>\n");

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

        // Error flag
        $err_code = 0;  

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

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

                // Clean up strings
                if (strlen($location) > 0) $location = textInmySQL($location);
                if (strlen($location_descr) > 0) $location_descr = textInmySQL($location_descr);
                if (strlen($campus) > 0) $campus = textInmySQL($campus);
                if (strlen($address1) > 0) $address1 = textInmySQL($address1);
                if (strlen($address2) > 0) $address2 = textInmySQL($address2);
                if (strlen($address3) > 0) $address3 = textInmySQL($address3);
                if (strlen($address4) > 0) $address4 = textInmySQL($address4);          
                if (strlen($telephone) > 0) $telephone = textInmySQL($telephone);
                if (strlen($mainURL) > 0) $mainURL = textInmySQL($mainURL);
                if (strlen($referenceURL) > 0) $referenceURL = textInmySQL($referenceURL);
                if (strlen($mapURL) > 0) $mapURL = textInmySQL($mapURL);
                if (strlen($hoursURL) > 0) $hoursURL = textInmySQL($hoursURL);          

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

                // Write the new row to the database
                if (mysql_tryquery($sql)) printf("Added <b>%s</b> location.", $location_display);

        }
        else printf("%s", $err_msg);
        
        printf("<br><br>\n");
        msgTableClose();

}


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

        // Error flag
        $err_code = 0;  

        // Check to see if already exists
        $exists = recordCount("resource", "title", $title, "A");
        
        // If exists in the table
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. <b>" . $title . "</b> 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
                if (strlen($annotation) > 0) $annotation = textInmySQL($annotation);
                if (strlen($author) > 0) $author = textInmySQL($author);
                if (strlen($call_no) > 0) $call_no = textInmySQL($call_no);
                if (strlen($cat_num) > 0) $cat_num = textInmySQL($cat_num);
                if (strlen($coverage_detail) > 0) $coverage_detail = textInmySQL($coverage_detail);
                if (strlen($edition) > 0) $edition = textInmySQL($edition);
                if (strlen($other_title) > 0) $other_title = textInmySQL($other_title);
                if (strlen($pub_date) > 0) $pub_date = textInmySQL($pub_date);
                if (strlen($publisher) > 0) $publisher = textInmySQL($publisher);
                if (strlen($sources_indexed) > 0) $sources_indexed = textInmySQL($sources_indexed);
                if (strlen($title) > 0) $title = textInmySQL($title);
                if (strlen($url) > 0) $url = textInmySQL($url);
                if (strlen($guide_url) > 0) $guide_url = textInmySQL($guide_url);               
                if (strlen($resource_message) > 0) $resource_message = textInmySQL($resource_message);
                if ($resource_status < 1) {
                        $resource_status = "";
                        $resource_message = "";
                }               

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

                // Write the new record to the database
                mysql_tryquery ($sql);
                $resource_id = mysql_insert_id();

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

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

        } // end insert new resource
        
        else {
                msgTableOpen(1, "Adding Resource...");
                printf("<b>Messages:</b><br>\n");       
                printf("%s", $err_msg);
                printf("<br><br>\n");
                msgTableClose();
        }

} // end function


/**********************************************************
Function: insertService
Author: Paul Bramscher
Last Modified: 03.15.2004
***********************************************************
Purpose:
Inserts a service.
**********************************************************/
function insertService($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("service", "service", $service_search, "A");
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. <b>" . $service_display . "</b> 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
                if (strlen($address1) > 0) $address1 = textInmySQL($address1);
                if (strlen($address2) > 0) $address2 = textInmySQL($address2);
                if (strlen($address3) > 0) $address3 = textInmySQL($address3);
                if (strlen($address4) > 0) $address4 = textInmySQL($address4);
                if (strlen($email) > 0) $email = textInmySQL($email);
                if (strlen($fax) > 0) $fax = textInmySQL($fax);
                if (strlen($service) > 0) $service = textInmySQL($service);
                if (strlen($serviceDescr) > 0) $serviceDescr = textInmySQL($serviceDescr);
                if (strlen($serviceURL) > 0) $serviceURL = textInmySQL($serviceURL);
                if (strlen($telephone) > 0) $telephone = textInmySQL($telephone);

                // Set up SQL
                $sql = "INSERT INTO service (address1, address2, address3, address4,
                                email, fax, nonaff, service, serviceDescr, serviceURL,
                                telephone) VALUES ('"
                        . $address1
                        . "', '"
                        . $address2
                        . "', '"
                        . $address3
                        . "', '"
                        . $address4
                        . "', '"
                        . $email
                        . "', '"
                        . $fax
                        . "', '"
                        . $nonaff
                        . "', '"
                        . $service
                        . "', '"
                        . $serviceDescr
                        . "', '"
                        . $serviceURL
                        . "', '"
                        . $telephone
                        . "')";
                
                // Write the new row to the database
                mysql_tryquery ($sql);
                $service_id = mysql_insert_id();
                formService($service_id);
        }

        else {
                msgTableOpen(1, "Adding Service...");
                printf("<b>Messages:</b><br>\n");       
                printf("%s", $err_msg);
                printf("<br><br>\n");
                msgTableClose();
        }

}


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

        msgTableOpen(1, "Adding " . $display . "...");
        printf("<b>Messages:</b><br>\n");       

        // 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($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.";
        }

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

                // Clean up strings
                $newValue  = textInmySQL($newValue);

                // Build the SQL
                $sql = "INSERT INTO "
                        . $table
                        ." ("
                        . $field
                        . ") VALUES ('"
                        . $newValue
                        . "')";

                mysql_tryquery ($sql);
                $new_id = mysql_insert_id();
                printf("%s <b>%s</b> successfully added.", $display, $newValue_display);
        }
        else printf ("%s", $err_msg);
        
        printf("<br><br>\n");
        msgTableClose();
}


/**********************************************************
Function: insertStaff
Author: Paul Bramscher
Last Modified: 03.15.2004
***********************************************************
Purpose:
Inserts the supplied staffperson information, and calls
formStaff back again if the insert was valid.   Staff must
have, at a minimum, a last name, first name, and unique
staff account name.  Uniqueness is enforced only on
staff_account.
**********************************************************/
function insertStaff($access_id, $first_name,
        $last_name, $sess_access_level, $staff_account,
        $staff_email, $stafftitle_id) {

        // 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("staff", "staff_account", $staff_account_search, "A");
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. <b>" . $staff_account_display . "</b> 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("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
                if (strlen($first_name) > 0) $first_name = textInmySQL($first_name);
                if (strlen($last_name) > 0) $last_name = textInmySQL($last_name);
                if (strlen($staff_account) > 0) $staff_account = textInmySQL($staff_account);
                if (strlen($staff_email) > 0) $staff_email = textInmySQL($staff_email);

                // Set up SQL
                $sql = "INSERT INTO staff (access_id, first_name, last_name, stafftitle_id,
                        staff_account, staff_email) VALUES ("
                        . $access_id
                        . ", '"
                        . $first_name
                        . "', '"
                        . $last_name
                        . "', "
                        . $stafftitle_id
                        . ", '"
                        . $staff_account
                        . "', '"
                        . $staff_email
                        . "')";
                
                // Write the new row to the database
                mysql_tryquery ($sql);
                $staff_id = mysql_insert_id();
                
                // Call staff form back
                formStaff($staff_id);
        }
        else {
                msgTableOpen(1, "Adding Staff...");
                printf("<b>Messages:</b><br>\n");       
                printf("%s", $err_msg);
                printf("<br><br>\n");
                msgTableClose();
        }
}


/**********************************************************
Function: insertStyle
Author: Paul Bramscher
Last Modified: 03.15.2004
***********************************************************
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($css_file, $footer_file, $header_file,
        $style_title) {

        msgTableOpen(1, "Adding Style...");
        printf("<b>Messages:</b><br>\n");

        // 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("style", "style_title", $style_title_search, "A");
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. <b>" . $style_title_display . "</b> already exists in the style table.";
        }
        
        // Check for blank entry
        if ($style_title == "") {
                $err_code = 2;
                $err_msg = "Failed.  Cannot enter a blank style.";
        }

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

                // Clean up strings
                if (strlen($css_file) > 0) $css_file = textInmySQL($css_file);
                if (strlen($footer_file) > 0) $footer_file = textInmySQL($footer_file);
                if (strlen($header_file) > 0) $header_file = textInmySQL($header_file);
                if (strlen($style_title) > 0) $style_title = textInmySQL($style_title);
                
                // Set up SQL
                $sql = "INSERT INTO style (css_file, footer_file, header_file, style_title) VALUES ('"
                        . $css_file
                        . "', '"
                        . $footer_file
                        . "', '"
                        . $header_file
                        . "', '"
                        . $style_title
                        . "')";
                
                // Write the new row to the database
                if (mysql_tryquery($sql)) printf("Added <b>%s</b> style.", $style_title_display);
        }
        else printf("%s", $err_msg);
        
        printf("<br><br>\n");
        msgTableClose();
}


/**********************************************************
Function: insertSubject
Author: Paul Bramscher
Last Modified: 03.15.2004
***********************************************************
Purpose:
Inserts a subject.  If successful, calls formSubject
back again.
**********************************************************/
function insertSubject($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("subject", "subject", $subject_search, "A");
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. <b>" . $subject_display . "</b> 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
                $subject = textInmySQL($subject);
                if (strlen($subject_descr) > 0) $subject_descr = textInmySQL($subject_descr);

                // Set up SQL
                $sql  = "INSERT INTO subject (subject, subject_descr, sublocation_id, rqs_date_created, rqs_account_created) VALUES ('"
                        . $subject
                        . "', '"
                        . $subject_descr
                        . "', "
                        . $sublocation_id
                        . ", now(), '"
                        . $sess_staff_account
                        . "')";
                mysql_tryquery ($sql);
                $subject_id = mysql_insert_id();

                // Insert this staff person as an assigned staff member to this subject
                $sql = "INSERT INTO sub_staff (subject_id, staff_id) VALUES ("
                        . $subject_id
                        . ", "
                        . $sess_staff_id
                        . ")";
                mysql_tryquery($sql);                           
                formSubject($subject_id);
        }

        else {
                msgTableOpen(1, "Adding Subject...");
                printf("<b>Messages:</b><br>\n");       
                printf("%s", $err_msg);
                printf("<br><br>\n");
                msgTableClose();
        }

}


/**********************************************************
Function: insertVendor
Author: Paul Bramscher
Last Modified: 03.15.2004
***********************************************************
Purpose:
Inserts a vendor.
**********************************************************/
function insertVendor($vendor, $vendor_descr,
        $vendor_message, $vendor_status) {
 
        msgTableOpen(1, "Adding Vendor...");
        printf("<b>Messages:</b><br>\n");
 
        // Error flag
        $err_code = 0;  
 
        // Need for display/uniqueness
        $vendor_display = $vendor;
        $vendor_search = textSearchmySQL($vendor);
 
        // Check to see if already exists
        $exists = recordCount("vendor", "vendor", $vendor_search, "A");
        if ($exists > 0) {
                $err_code = 1;
                $err_msg = "Failed. <b>" . $vendor_display . "</b> already exists in the vendor table.";
        }
        
        // Check for blank entry
        if ($vendor == "") {
                $err_code = 2;
                $err_msg = "Failed.  Cannot enter a blank vendor.";
        }
 
        // Add only if this vendor doesn't already exist, and something was supplied
        if ($err_code == 0) {
        
                // Clean up strings
                if (strlen($vendor) > 0) $vendor = textInmySQL($vendor);
                if (strlen($vendor_descr) > 0) $vendor_descr = textInmySQL($vendor_descr);
                if (strlen($vendor_message) >0) $vendor_message = textInmySQL($vendor_message);
                if ($vendor_status < 1) {
                        $vendor_status = "";
                        $vendor_message = "";
                }
                
                // Set up SQL
                $sql = "INSERT INTO vendor (vendor, vendor_descr, vendor_message, vendor_status) VALUES ('"
                        . $vendor
                        . "', '"
                        . $vendor_descr
                        . "', '"
                        . $vendor_message
                        . "', '"
                        . $vendor_status
                        . "')";
                if (mysql_tryquery($sql)) printf("Added Vendor <b>%s</b>.", $vendor_display);

        }
        else printf("%s", $err_msg);
        printf("<br><br>\n");
        msgTableClose();
}
?>