Expand|Select|Wrap|Line Numbers
- <?php
- require_once("connection/connection.php");
- ?>
- <?php $userid = $_GET['user']; ?>
- <html>
- <head>
- <title>subok lang</title>
- <link rel="stylesheet" type="text/css" href="css/sinusubok.css"/>
- <script type="text/javascript" src="js/js-jquery-1.4.2.min.js"></script>
- <script type="text/javascript">
- $(document).ready(function () {
- var dt = $("#sumreport #currents").length;
- var dts = $("#sumreport #priors").length;
- alls = dt + dts;
- if(alls>=8){
- alert("you have reach the verdict!");
- document.getElementById("btnadd").disabled = true;
- document.getElementById("btnadd1").disabled = true;
- }
- });
- var numero;
- var duplicate;
- var sample = 1;
- var inputtop = 10;
- function addinput(){
- numero = document.createElement("input");
- duplicate = document.createElement("input");
- numero.setAttribute('name', 'obli1'+ sample);
- duplicate.setAttribute('name', "duplicate");
- numero.setAttribute('placeholder', 'Obligation_request'+ sample);
- numero.setAttribute('type', 'text');
- duplicate.setAttribute('type', 'hidden');
- duplicate.setAttribute('value', sample);
- numero.style.marginTop = inputtop + 'px';
- document.getElementById('obli').appendChild(numero);
- document.getElementById('obli').appendChild(duplicate);
- sample++;
- }
- </script>
- </head>
- <body>
- <div id="wrapper">
- <div id="side">
- <div id="current">
- <form name="frmcur" id="frmcur" method="post" action="">
- <input type="text" name="txtcred" id="txtcred" placeholder="Creditor"/><br/><br/>
- <div id="obli">
- <input type="text" name="txtobli" id="txtobli" placeholder="Obligation Request"/><button type="button" onclick="addinput()">Add</button><br/><br/>
- </div>
- <select type="text" name="optobli" id="optobli">
- <option value="1">1 Personal Service</option>
- <option value="2">2 Financial Expenses</option>
- </select><br/><br/>
- <input type="text" name="txtgross" id="txtgross" placeholder="Gross Amount"/><br/><br/>
- <input type="text" name="txttax" id="txttax" placeholder="Withholding Tax"/><br/><br/>
- <button onclick = "counters()" type="submit" id="btnadd" name="btnadd">Add Creditor</button>
- <?php
- if(!empty($_POST['frmcur'])){
- }
- else{
- if(isset($_POST['btnadd'])){
- $credname = $_POST['txtcred'];
- $obli = $_POST['txtobli'];
- $opt1 = $_POST['optobli'];
- $gross = $_POST['txtgross'];
- $tax = $_POST['txttax'];
- $ctr = $_POST['duplicate'];
- for($x=0;$x<$ctr;$x++){
- $thevalue = $_POST['obli1'+$x];
- }
- echo"<script>alert('$thevalue');</script>";
- if(empty($credname)|| empty($obli)|| empty($opt1)|| empty($gross)|| empty($tax)){
- }
- else{
- $query1 = "INSERT INTO temp_current (user_id,credname,obli,allotment,gross,tax)
- VALUES ({$userid},'{$credname}','{$obli}','{$opt1}','{$gross}','{$tax}')";
- mysql_query($query1,$connect);
- header("Location:sinusubok.php?user={$userid}");
- }
- }
- }
- ?>
- </form>
- </div>
- <div id="prior">
- <form id="frmprior" name="frmprior" method="post" action="">
- <input type="text" name="txtcred1" id="txtcred1" placeholder="Creditor"/><br/><br/>
- <input type="text" name="txtobli1" id="txtobli1" placeholder="Obligation Request"/><br/><br/>
- <select type="text" name="optobli1" id="optobli1">
- <option value = "1">Personal Service</option>
- <option value = "2">Financial Expenses</option>
- </select><br/><br/>
- <input type="text" name="txtgross1" id="txtgross1" placeholder="Gross Amount"/><br/><br/>
- <input type="text" name="txttax1" id="txttax1" placeholder="Withholding Tax"/><br/><br/>
- <button type="submit" id="btnadd1" name="btnadd1">Add Prior</button>
- <?php
- if(!empty($_POST['frmprior'])){
- }
- else{
- if(isset($_POST['btnadd1'])){
- $credname1 = $_POST['txtcred1'];
- $obli1 = $_POST['txtobli1'];
- $opt11 = $_POST['optobli1'];
- $gross1 = $_POST['txtgross1'];
- $tax1 = $_POST['txttax1'];
- if(empty($credname1)||empty($obli1)||empty($opt11)||empty($gross1)||empty($tax1)){
- }
- else{
- $query11 = "INSERT INTO temp_prior (user_id,credname,obli,allotment,gross,tax)
- VALUES ({$userid},'{$credname1}','{$obli1}','{$opt11}','{$gross1}','{$tax1}')";
- mysql_query($query11,$connect);
- header("Location:sinusubok.php?user={$userid}");
- }
- }
- }
- ?>
- </form>
- </div>
- <div name="summary" id="summary">
- <form id="frmrep" name="frmrep" method="post">
- <table id="sumreport" BORDER=2 CELLPADDING=4>
- <tr>
- <td colspan="8" style="text-align:center;" >Summary of Report</td>
- </tr>
- <tr>
- <td>Name</td>
- <td>Obligation Request</td>
- <td>Allotment Class</td>
- <td>Gross Amount</td>
- <td>Withholding Tax</td>
- <td>Net Amount</td>
- <td>Remarks</td>
- </tr>
- <tr>
- <td colspan="8" style="text-align:center;">Current</td>
- </tr>
- <?php
- $queryaccount = "SELECT * FROM temp_current";
- $accounts = mysql_query($queryaccount,$connect);
- $countaccount = mysql_num_rows($accounts);
- while($resultaccount = mysql_fetch_array($accounts))
- {
- $crdname = $resultaccount['credname'];
- $oblit = $resultaccount['obli'];
- $allot = $resultaccount['allotment'];
- $grows = $resultaccount['gross'];
- $taxes = $resultaccount['tax'];
- $net = $grows-$taxes;
- ?>
- <tr id="currents">
- <td><?php echo $crdname;?></td>
- <td><?php echo $oblit;?></td>
- <td><?php echo $allot;?></td>
- <td><?php echo $grows;?></td>
- <td><?php echo $taxes;?></td>
- <td><?php echo $net?></td>
- <td></td>
- </tr>
- <?php
- }?>
- <tr>
- <td colspan="8" style="text-align:center;">Prior</td>
- </tr>
- <?php
- $queryaccount1 = "SELECT * FROM temp_prior";
- $accounts1 = mysql_query($queryaccount1,$connect);
- $countaccount1 = mysql_num_rows($accounts1);
- while($resultaccount1 = mysql_fetch_array($accounts1))
- {
- $crdname1 = $resultaccount1['credname'];
- $oblit1 = $resultaccount1['obli'];
- $allot1 = $resultaccount1['allotment'];
- $grows1 = $resultaccount1['gross'];
- $taxes1 = $resultaccount1['tax'];
- $nets = $grows1-$taxes;
- ?>
- <tr id="priors">
- <td><?php echo $crdname1;?></td>
- <td><?php echo $oblit1;?></td>
- <td><?php echo $allot1;?></td>
- <td><?php echo $grows1;?></td>
- <td><?php echo $taxes1;?></td>
- <td><?php echo $nets?></td>
- <td></td>
- </tr>
- <?php
- }?>
- </table>
- <button id="btngen" name="btngen" type="submit">Generate</button>
- <?php
- if(!empty($_POST['frmrep'])){
- }
- else{
- if(isset($_POST['btngen'])){
- header("Location:generate_report.php");
- }
- }
- ?>
- </form>
- </div>
- </div>
- </body>
- </html>