try { //Standard $dataFees["gibbonFinanceInvoiceID1"] = $row["gibbonFinanceInvoiceID"]; $sqlFees = "(SELECT gibbonFinanceInvoiceFee.gibbonFinanceInvoiceFeeID, gibbonFinanceInvoiceFee.feeType, gibbonFinanceFeeCategory.name AS category, gibbonFinanceFee.name AS name, gibbonFinanceFee.fee AS fee, gibbonFinanceFee.description AS description, gibbonFinanceInvoiceFee.gibbonFinanceFeeID AS gibbonFinanceFeeID, gibbonFinanceInvoiceFee.gibbonFinanceFeeCategoryID AS gibbonFinanceFeeCategoryID, sequenceNumber FROM gibbonFinanceInvoiceFee JOIN gibbonFinanceFee ON (gibbonFinanceInvoiceFee.gibbonFinanceFeeID=gibbonFinanceFee.gibbonFinanceFeeID) JOIN gibbonFinanceFeeCategory ON (gibbonFinanceFee.gibbonFinanceFeeCategoryID=gibbonFinanceFeeCategory.gibbonFinanceFeeCategoryID) WHERE gibbonFinanceInvoiceID=:gibbonFinanceInvoiceID1 AND feeType='Standard')"; $sqlFees .= " UNION "; //Ad Hoc $dataFees["gibbonFinanceInvoiceID2"] = $row["gibbonFinanceInvoiceID"]; $sqlFees .= "(SELECT gibbonFinanceInvoiceFee.gibbonFinanceInvoiceFeeID, gibbonFinanceInvoiceFee.feeType, gibbonFinanceFeeCategory.name AS category, gibbonFinanceInvoiceFee.name AS name, gibbonFinanceInvoiceFee.fee, gibbonFinanceInvoiceFee.description AS description, NULL AS gibbonFinanceFeeID, gibbonFinanceInvoiceFee.gibbonFinanceFeeCategoryID AS gibbonFinanceFeeCategoryID, sequenceNumber FROM gibbonFinanceInvoiceFee JOIN gibbonFinanceFeeCategory ON (gibbonFinanceInvoiceFee.gibbonFinanceFeeCategoryID=gibbonFinanceFeeCategory.gibbonFinanceFeeCategoryID) WHERE gibbonFinanceInvoiceID=:gibbonFinanceInvoiceID2 AND feeType='Ad Hoc')"; $sqlFees .= " ORDER BY sequenceNumber"; $resultFees = $connection2->prepare($sqlFees); $resultFees->execute($dataFees); } catch (PDOException $e) { print "<div class='error'>" . $e->getMessage() . "</div>"; } while ($rowFees = $resultFees->fetch()) { makeFeeBlock($guid, $connection2, $feeCount, "edit", $rowFees["feeType"], $rowFees["gibbonFinanceFeeID"], $rowFees["name"], $rowFees["description"], $rowFees["gibbonFinanceFeeCategoryID"], $rowFees["fee"], $rowFees["category"]); $feeCount++; } ?> </div> <div style='width: 100%; padding: 0px 0px 0px 0px'> <div class="ui-state-default_dud" style='padding: 0px; height: 40px'> <table class='blank' cellspacing='0' style='width: 100%'> <tr> <td style='width: 50%'> <script type="text/javascript"> var feeCount=<?php print $feeCount; ?> ; </script>
You should have received a copy of the GNU General Public License along with this program. If not, see <http://www.gnu.org/licenses/>. */ include "../../functions.php"; include "../../config.php"; include "./moduleFunctions.php"; //New PDO DB connection try { $connection2 = new PDO("mysql:host={$databaseServer};dbname={$databaseName};charset=utf8", $databaseUsername, $databasePassword); $connection2->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $connection2->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); } catch (PDOException $e) { echo $e->getMessage(); } @session_start(); //Set timezone from session variable date_default_timezone_set($_SESSION[$guid]["timezone"]); $id = $_GET["id"]; $mode = $_GET["mode"]; $feeType = $_GET["feeType"]; $gibbonFinanceFeeID = $_GET["gibbonFinanceFeeID"]; $name = $_GET["name"]; $description = $_GET["description"]; $gibbonFinanceFeeCategoryID = $_GET["gibbonFinanceFeeCategoryID"]; $fee = $_GET["fee"]; $category = NULL; if (isset($_GET["category"])) { $category = $_GET["category"]; } makeFeeBlock($guid, $connection2, $id, $mode, $feeType, $gibbonFinanceFeeID, $name, $description, $gibbonFinanceFeeCategoryID, $fee, $category);