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);
