master

分支 (1)

管理

管理

master

daloradiusHanHuaBan
/
bill-payments-new.php

<?php
/*
 *********************************************************************************************************
 * daloRADIUS - RADIUS Web Platform
 * Copyright (C) 2007 - Liran Tal <[email protected]> All Rights Reserved.
 *
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 2
 * of the License, or (at your option) any later version.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 *
 *********************************************************************************************************
 *
 * Authors:	Liran Tal <[email protected]>
 * 			Filippo Maria Del Prete <[email protected]>
 *
 *********************************************************************************************************
 */

    include ("library/checklogin.php");
    $operator = $_SESSION['operator_user'];

	include('library/check_operator_perm.php');

	isset($_POST['payment_invoice_id']) ? $payment_invoice_id = $_POST['payment_invoice_id'] : $payment_invoice_id = "";
	isset($_POST['payment_amount']) ? $payment_amount = $_POST['payment_amount'] : $payment_amount = "";
	isset($_POST['payment_date']) ? $payment_date = $_POST['payment_date'] : $payment_date = "";
	isset($_POST['payment_type_id']) ? $payment_type_id = $_POST['payment_type_id'] : $payment_type_id = "";
	isset($_POST['payment_notes']) ? $paymentnotes = $_POST['payment_notes'] : $payment_notes = "";

	$logAction = "";
	$logDebugSQL = "";

	if (isset($_POST["submit"])) {
		$payment_invoice_id = $_POST['payment_invoice_id'];
		$payment_amount = $_POST['payment_amount'];
		$payment_date = $_POST['payment_date'];
		$payment_type_id = $_POST['payment_type_id'];
		$payment_notes = $_POST['payment_notes'];

		include 'library/opendb.php';

		$sql = "SELECT * FROM ".$configValues['CONFIG_DB_TBL_DALOPAYMENTS']." WHERE invoice_id=".$dbSocket->escapeSimple($payment_invoice_id)." AND amount=".$dbSocket->escapeSimple($payment_amount)." AND date='".$dbSocket->escapeSimple($payment_date)."'";
		$res = $dbSocket->query($sql);
		$logDebugSQL .= $sql . "\n";

		if ($res->numRows() == 0) {
			if (trim($payment_invoice_id) != "" and trim($payment_amount)!="" and trim($payment_date)!="") {

				$currDate = date('Y-m-d H:i:s');
				$currBy = $_SESSION['operator_user'];

				// insert apyment type info
				$sql = "INSERT INTO ".$configValues['CONFIG_DB_TBL_DALOPAYMENTS'].
					" (id, invoice_id, amount,date,type_id, notes, ".
					"  creationdate, creationby, updatedate, updateby) ".
					" VALUES (0, ".$dbSocket->escapeSimple($payment_invoice_id).", ".
					"".$dbSocket->escapeSimple($payment_amount).", ".
					"'".$dbSocket->escapeSimple($payment_date)."', ".
					"'".$dbSocket->escapeSimple($payment_type_id)."', ".
					"'".$dbSocket->escapeSimple($payment_notes)."', ".
					" '$currDate', '$currBy', NULL, NULL)";
				$res = $dbSocket->query($sql);
				$logDebugSQL .= $sql . "\n";

				$successMsg = "Added to database new payment for invoice: <b>$payment_invoice_id</b> <br/>";
				$successMsg .= "<a href='bill-invoice-edit.php?invoice_id=$payment_invoice_id'> Show Invoice $payment_invoice_id </a>";
				$logAction .= "Successfully added new payment for invoice [$payment_invoice_id] on page: ";


			} else {
				$failureMsg = "you must provide an invoice, an amount and a date ";
				$logAction .= "Failed adding new payment for invoice [$payment_invoice_id] on page: ";
			}
		} else {
			$failureMsg = "You have tried to add a paymente that already exist in the database for the invoice: $payment_invoice_id";
			$logAction .= "Failed adding new payment already in database for invoice [$payment_invoice_id] on page: ";
		}

		include 'library/closedb.php';

	}

	isset($_GET['payment_invoice_id']) ? $invoice_id = $_GET['payment_invoice_id'] : $invoice_id = "";
	isset($_GET['payment_date']) ? $payment_date = $_GET['payment_date'] : $payment_date = date('Y-m-d H:i:s');


	include_once('library/config_read.php');
    $log = "visited page: ";

?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<title>daloRADIUS</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="css/1.css" type="text/css" media="screen,projection" />
<link rel="stylesheet" type="text/css" href="library/js_date/datechooser.css">
<!--[if lte IE 6.5]>
<link rel="stylesheet" type="text/css" href="library/js_date/select-free.css"/>
<![endif]-->
</head>
<script src="library/js_date/date-functions.js" type="text/javascript"></script>
<script src="library/js_date/datechooser.js" type="text/javascript"></script>
<script type="text/javascript" src="library/javascript/pages_common.js"></script>
<script type="text/javascript" src="library/javascript/ajax.js"></script>
<script type="text/javascript" src="library/javascript/dynamic_attributes.js"></script>
<script type="text/javascript" src="library/javascript/ajaxGeneric.js"></script>
<?php
	include_once ("library/tabber/tab-layout.php");
?>

<?php

	include ("menu-bill-payments.php");

?>

<div id="contentnorightbar">

	<h2 id="Intro"><a href="#" onclick="javascript:toggleShowDiv('helpPage')"><?php echo $l['Intro']['paymentsnew.php'] ?>
	<h144>+</h144></a></h2>

	<div id="helpPage" style="display:none;visibility:visible" >
		<?php echo $l['helpPage']['paymentsnew'] ?>
		<br/>
	</div>
	<?php
		include_once('include/management/actionMessages.php');
	?>

	<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">

<div class="tabber">

	<div class="tabbertab" title="<?php echo $l['title']['PaymentInfo']; ?>">

	<fieldset>

		<h302> <?php echo $l['title']['PaymentInfo']; ?> </h302>
		<br/>

		<ul>

		<li class='fieldset'>
		<label for='name' class='form'><?php echo $l['all']['PaymentInvoiceID'] ?></label>
		<input name='payment_invoice_id' type='text' id='payment_invoice_id' value='<?php echo $invoice_id ?>' tabindex=100 />
		<img src='images/icons/comment.png' alt='Tip' border='0' onClick="javascript:toggleShowDiv('paymentInvoiceTooltip')" />

		<div id='paymentInvoiceTooltip'  style='display:none;visibility:visible' class='ToolTip'>
			<img src='images/icons/comment.png' alt='Tip' border='0' />
			<?php echo $l['Tooltip']['paymentInvoiceTooltip'] ?>
		</div>
		</li>

		<li class='fieldset'>
   		<label for='payment_amount' class='form'><?php echo $l['all']['PaymentAmount'] ?></label>
   		<input class='integer5len' name='payment_amount' type='text' id='payment_amount' value='000.00' tabindex=103 />
                   <img src="images/icons/bullet_arrow_up.png" alt="+" onclick="javascript:changeInteger('payment_amount','increment')" />
                   <img src="images/icons/bullet_arrow_down.png" alt="-" onclick="javascript:changeInteger('payment_amount','decrement')"/>
   		<img src='images/icons/comment.png' alt='Tip' border='0' onClick="javascript:toggleShowDiv('amountTooltip')" />

   		<div id='amountTooltip'  style='display:none;visibility:visible' class='ToolTip'>
   			<img src='images/icons/comment.png' alt='Tip' border='0' />
   			<?php echo $l['Tooltip']['amountTooltip'] ?>
   		</div>
   		</li>

		<label for='payment_date' class='form'><?php echo $l['all']['PaymentDate']?></label>
   		<input value='<?php echo $payment_date ?>' id='payment_date' name='payment_date'  tabindex=108 />
   		<img src="library/js_date/calendar.gif" onclick="showChooser(this, 'payment_date', 'chooserSpan', 1950, <?= date('Y', time());?>, 'Y-m-d H:i:s', true);">
		<br/>

   		<li class='fieldset'>
   		<label for='payment_type_id' class='form'><?php echo $l['all']['PaymentType']?></label>
   		<?php
   		        include_once('include/management/populate_selectbox.php');
   		        populate_payment_type_id("Select Payment Type", "payment_type_id");
   		?>
   		<img src='images/icons/comment.png' alt='Tip' border='0' onClick="javascript:toggleShowDiv('paymentTypeIdTooltip')" />
   		<div id='paymentTypeIdTooltip'  style='display:none;visibility:visible' class='ToolTip'>
   			<img src='images/icons/comment.png' alt='Tip' border='0' />
   			<?php echo $l['Tooltip']['paymentTypeIdTooltip'] ?>
   		</div>
   		</li>

		<li class='fieldset'>
		<label for='payment_notes' class='form'><?php echo $l['all']['PaymentNotes'] ?></label>
		<textarea name='payment_notes'  class='form' tabindex=101 ></textarea>
		<img src='images/icons/comment.png' alt='Tip' border='0' onClick="javascript:toggleShowDiv('paymentNotesTooltip')" />

		<div id='paymentNotesTooltip'  style='display:none;visibility:visible' class='ToolTip'>
			<img src='images/icons/comment.png' alt='Tip' border='0' />
			<?php echo $l['Tooltip']['paymentNotesTooltip'] ?>
		</div>
		</li>

		<li class='fieldset'>
		<br/>
		<hr><br/>
		<input type='submit' name='submit' value='<?php echo $l['buttons']['apply'] ?>' tabindex=10000 class='button' />
		</li>

		</ul>
	</fieldset>

	</div>


	<div class="tabbertab" title="<?php echo $l['title']['Optional']; ?>">

<fieldset>

        <h302> Optional </h302>
        <br/>

        <br/>
        <h301> Other </h301>
        <br/>

        <br/>
        <label for='creationdate' class='form'><?php echo $l['all']['CreationDate'] ?></label>
        <input disabled value='<?php if (isset($creationdate)) echo $creationdate ?>' tabindex=313 />
        <br/>

        <label for='creationby' class='form'><?php echo $l['all']['CreationBy'] ?></label>
        <input disabled value='<?php if (isset($creationby)) echo $creationby ?>' tabindex=314 />
        <br/>

        <label for='updatedate' class='form'><?php echo $l['all']['UpdateDate'] ?></label>
        <input disabled value='<?php if (isset($updatedate)) echo $updatedate ?>' tabindex=315 />
        <br/>

        <label for='updateby' class='form'><?php echo $l['all']['UpdateBy'] ?></label>
        <input disabled value='<?php if (isset($updateby)) echo $updateby ?>' tabindex=316 />
        <br/>


        <br/><br/>
        <hr><br/>

        <input type='submit' name='submit' value='<?php echo $l['buttons']['apply'] ?>' tabindex=10000
                class='button' />

</fieldset>


	</div>
	<div id="chooserSpan" class="dateChooser select-free" style="display: none; visibility: hidden; width: 160px;"></div>

</div>

	</form>

<?php
	include('include/config/logging.php');
?>

		</div>

		<div id="footer">

<?php
	include 'page-footer.php';
?>


		</div>

</div>
</div>


</body>
</html>