$stmt1->execute();
 if ($stmt1->error) {
     throw new Exception($stmt1->errno . ' ' . $stmt1->error . '<br/>There was an error submitting this request.  Please click the back button and try again.');
     exit;
 }
 $biz_mgr = $stmt1->fetch(PDO::FETCH_ASSOC);
 $mgrName = $biz_mgr['mgr_fname'] . " " . $biz_mgr['mgr_lname'];
 $mgrEmail = $biz_mgr['mgr_email'];
 $stmt1 = null;
 $conn1 = null;
 // ========================================================================================
 // ADD REQUEST TO DATABASE
 // using named placeholders
 // ========================================================================================
 $facil2_conn = new DBConnection('facil2');
 $conn2 = $facil2_conn->openConnection();
 $sql2 = "INSERT INTO addl_pay_request(`date_of_request` ,\n\t\t  `requester_fname` ,\n\t\t  `requester_lname` ,\n\t\t  `requester_phone` ,\n\t\t  `employee_fname` ,\n\t\t  `employee_lname` ,\n\t\t  `dept_name` ,\n\t\t  `dept_phone` ,\n\t\t  `reason_for_payment` ,\n\t\t  `work_start_date` ,\n\t\t  `work_end_date` ,\n\t\t  `job_title` ,\n\t\t  `description_of_work` ,\n\t\t  `work_classification` ,\n\t\t  `business_mgr`)\n\t\tVALUES (CURDATE(),\n\t\t  :req_fname ,\n\t\t  :req_lname ,\n\t\t  :req_phone ,\n\t\t  :emp_fname ,\n\t\t  :emp_lname ,\n\t\t  :dept_name ,\n\t\t  :dept_phone ,\n\t\t  :reason_for_payment ,\n\t\t  :work_start_date ,\n\t\t  :work_end_date ,\n\t\t  :job_title ,\n\t\t  :description_of_work ,\n\t\t  :work_classification ,\n\t\t  :biz_mgr\n\t\t  )";
 /*$sql2 = "INSERT INTO addl_pay_request(`date_of_request` ,
 		  `requester_fname` ,
 		  `requester_lname` ,
 		  `requester_phone` ,
 		  `employee_fname` ,
 		  `employee_lname` ,
 		  `dept_name` ,
 		  `dept_phone` ,
 		  `reason_for_payment` ,
 		  `work_start_date` ,
 		  `work_end_date` ,
 		  `job_title` ,
 		  `description_of_work` ,
 		  `work_classification` ,
Esempio n. 2
0
        //check if already responded
        if ($who == 'biz_mgr' && !IS_NULL($row['date_of_response'])) {
            Utilities::msg_alert("You have already responded to this request.", "");
            $disabled = 'disabled';
        }
        if ($who == 'admin' && !IS_NULL($row['date_admin_submit'])) {
            Utilities::msg_alert("This request was already processed and the notices were sent out.", "");
            $disabled = 'disabled';
        }
    }
    //end who = biz_mgr/admin
    // ==================================================================================
    // MYSQL DATABASE CONNECTION - facil_csc (stores dept,clerk,biz_mgr lists)
    // ==================================================================================
    $connector = new DBConnection('facil');
    $conn = $connector->openConnection();
    // ==================================================================================
    // BOOTSTRAP PAGE TOP WITH NAVIGATION
    // ==================================================================================
    $page_view = new PageView();
    $page_view->createHTMLHead('Additional Pay Form::Facilities and Services:: University of Rochester');
    echo "<body class='home blue'>";
    // class determines style of header: home, other...
    $page_view->createMainHeader();
    ?>
  

<main>           
	<div class="top_pad"> <!-- Padding matches height of Header -->
	
		<!-- // ==================================================================================