<? include_once('session.php');?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html dir="ltr"><head>
<title>Budget</title><meta http-equiv="Content-type" content="text/html; charset=ISO-8859-1">
<link href="default.css" rel="stylesheet" type="text/css">
<script type="text/javascript">
function formValidate(obj){
// alert('hi');
var obj = document.frm;
var chkCount = obj.counter.value;
for(var i=0;i<chkCount;i++){
var chkBox = eval('document.frm.chk'+i+'.checked');
var bTxt = eval('document.frm.bamt'+i+'.value');
if(chkBox == true && bTxt == ''){
alert('Please enter budget amount');
return false;
}
else
{
if(chkBox == true && isNaN(bTxt))
{
alert('Amount must be integer');
return false;
}
}
}
}
function countCheckboxes()
{
// alert('count');
var obj;
var count = 0;
var form = document.frm;
for (var i=0; i<form.elements.length; i++)
{
obj = form.elements[i];
if (obj.type == "checkbox" && obj.checked) {
count++;
}
}
if(count == 0)
{
alert('select ek atleast One ledger');
return false;
}
else{
document.getElementById('check').value = count;
}
}
var cnt =0;
function disable(obj)
{
if(document.getElementById(obj.id).checked)
{
document.getElementById('bamt'+obj.value).disabled=false;
showb('ledger'+obj.value);
cnt = obj.value;
}
else
{
if(document.getElementById(obj.id).checked==false)
{
document.getElementById('bamt'+obj.value).disabled=true;
document.getElementById('bamt'+obj.value).value =" ";
document.getElementById('txtHint'+obj.value).value =" ";
document.getElementById('txtHnt'+obj.value).value =" ";
}
}
}
function able(obj)
{
if(document.getElementById(obj.id).checked)
{
document.getElementById('bamt'+obj.value).disabled=false;
showe('ledger'+obj.value);
cnt = obj.value;
}
else
{
if(document.getElementById(obj.id).checked==false)
{
document.getElementById('bamt'+obj.value).disabled=true;
document.getElementById('bamt'+obj.value).value =" ";
document.getElementById('txtHint'+obj.value).value =" ";
document.getElementById('txtHnt'+obj.value).value =" ";
}
}
}
var xmlHttp;
function showb(str)
{
//alert('hi');
xmlHttp=GetXmlHttpObject();
if (xmlHttp==null)
{
alert ("Browser does not support HTTP Request");
return;
}
var userid = document.getElementById('userid').value;
var ledgerValue = document.getElementById(str).value;
var url="showbudget.php";
url=url+"?q="+ledgerValue;
url=url+"&uid="+userid;
url=url+"&sid="+Math.random();
xmlHttp.onreadystatechange=stateChanged;
xmlHttp.open("GET",url,true);
xmlHttp.send(null);
}
function stateChanged()
{
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{
document.getElementById("txtHint"+cnt).value=xmlHttp.responseText;
}
}
function GetXmlHttpObject()
{
var xmlHttp=null;
try
{
// Firefox, Opera 8.0+, Safari
xmlHttp=new XMLHttpRequest();
}
catch (e)
{
//Internet Explorer
try
{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}
var xmlHttp1;
function showe(str)
{
//alert('hi');
xmlHttp1=GetXmlHttpObject();
if (xmlHttp1==null)
{
alert ("Browser does not support HTTP Request");
return;
}
var userid = document.getElementById('userid').value;
var ledgerValue = document.getElementById(str).value;
var url="showbudget1.php";
url=url+"?q="+ledgerValue;
url=url+"&uid="+userid;
url=url+"&sid="+Math.random();
xmlHttp1.onreadystatechange=stateChanged1;
xmlHttp1.open("GET",url,true);
xmlHttp1.send(null);
}
function stateChanged1()
{
if (xmlHttp1.readyState==4 || xmlHttp1.readyState=="complete")
{
document.getElementById("txtHnt"+cnt).value=xmlHttp1.responseText;
}
}
function GetXmlHttpObject()
{
var xmlHttp1=null;
try
{
// Firefox, Opera 8.0+, Safari
xmlHttp1=new XMLHttpRequest();
}
catch (e)
{
//Internet Explorer
try
{
xmlHttp1=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
xmlHttp1=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp1;
}
function myPopup2() {
window.open( "popupledger.php", "myWindow",
"status = 1, height = 400, width = 600, resizable = 0" )
}
</script>
<style>
.textbox2{
BORDER-RIGHT: #000000 1px solid;
BORDER-TOP: #000000 1px solid;
FONT-SIZE: 9pt;
PADDING-BOTTOM: 1px;
BORDER-LEFT: #000000 1px solid;
COLOR: #000000;
PADDING-TOP: 1px;
BORDER-BOTTOM: #000000 1px solid;
FONT-FAMILY: Verdana, Arial, Helvetica, sans-serif;
}
</style>
<script type="text/javascript" src="time.js"></script>
<script src="currentdate.js"></script>
<script type="text/javascript" src="tigra_hints.js"></script>
<style>
.hintsClass {
font-family: tahoma, verdana, arial;
font-size: 12px;
background-color: #f0f0f0;
color: #000000;
border: 1px solid #808080;
padding: 5px;
}
.hintSource {
color: green;
text-decoration: underline;
cursor: pointer;
}
</style>
<SCRIPT TYPE="text/javascript">
<!--
// copyright 1999 Idocs, Inc. http://www.idocs.com
// Distribute this script freely but keep this notice in place
function numbersonly(myfield, e, dec)
{
var key;
var keychar;
if (window.event)
key = window.event.keyCode;
else if (e)
key = e.which;
else
return true;
keychar = String.fromCharCode(key);
// control keys
if ((key==null) || (key==0) || (key==8) ||
(key==9) || (key==13) || (key==27) )
return true;
// numbers
else if ((("0123456789").indexOf(keychar) > -1))
return true;
// decimal point jump
else if (dec && (keychar == "."))
{
myfield.form.elements[dec].focus();
return false;
}
else
return false;
}
//-->
</SCRIPT>
<?php
include_once('config2.php');
$userid = $_SESSION['userid'];
$sql="SELECT * FROM 0_ledger where user_id = $userid or user_id = 0";
$result=mysql_query($sql)or die('Query error:'.''.mysql_errno());
?>
</head>
<body onload="startTime(); currentdate();">
<?php include_once('header.php');
include_once('menu4.php');?>
<script language="JavaScript">
// configuration variable for the hint object, these setting will be shared among all hints created by this object
var HINTS_CFG = {
'wise' : true, // don't go off screen, don't overlap the object in the document
'margin' : 10, // minimum allowed distance between the hint and the window edge (negative values accepted)
'gap' : 0, // minimum allowed distance between the hint and the origin (negative values accepted)
'align' : 'tcbc', // align of the hint and the origin (by first letters origin's top|middle|bottom left|center|right to hint's top|middle|bottom left|center|right)
'css' : 'hintsClass', // a style class name for all hints, applied to DIV element (see style section in the header of the document)
'show_delay' : 50, // a delay between initiating event (mouseover for example) and hint appearing
'hide_delay' : 50, // a delay between closing event (mouseout for example) and hint disappearing
'follow' : false, // hint follows the mouse as it moves
'z-index' : 100, // a z-index for all hint layers
'IEfix' : false, // fix IE problem with windowed controls visible through hints (activate if select boxes are visible through the hints)
'IEtrans' : ['blendTrans(DURATION=.3)', 'blendTrans(DURATION=.3)'], // [show transition, hide transition] - nice transition effects, only work in IE5+
'opacity' : 100 // opacity of the hint in %%
};
// text/HTML of the hints
var HINTS_ITEMS = [
'If Last Budget is Null then <br> it means<br> no Budget of this<br> account is created in last month',
'If Last Actual Budget is Null then <br> it means no entry is passed in last month',
'tooltip for item3<br>This one is multi line',
'tooltip for item4',
'another sample tooltip with the <a href="http://www.softcomplex.com">link</a>'
];
var myHint = new THints (HINTS_ITEMS, HINTS_CFG);
</script>
<div class="clear">
</div>
<div id="menu2">
<ul>
<li><a href="cbudget.php" style="font-family:Verdana, Arial,Helvetica, sans-serif; font-size:14px">Create Budget</a></li>
<li><a href="budget.php" style="font-family:Verdana, Arial,Helvetica, sans-serif; font-size:14px">View Reports</a></li>
</ul>
</div>
<div class="clear"></div>
<center>
<table border="0" width="100%">
<tr>
<td width="20%"><font face="Courier New, Courier, mono" size="+1"><b>Create Entry</b></font></td>
<td align="center" width="50%"><b> Welcome <?= $_SESSION['username'];?></b></td>
<td align=
"right"><div id=
"txt1"></div></td>
</tr>
<tr>
<td class="titletext" style=""> </td>
<td align="right" class="titletext" colspan="2">Time:<span id="txt"></span></td>
</tr>
</table>
<div class="clear"></div>
<center><table width="100%"><tbody><tr>
<div id="_page_body">
<div class="clear"></div>
<br> <? include_once('msgbox.php'); ?> <br>
<form method="post" name="frm" action="addbudget.php" onSubmit="return formValidate(this);">
<input type="hidden" id='userid' name="userid" value="<?= $userid; ?>"
<div><center>
<table style="border-collapse: collapse;" cellpadding="3" cellspacing="3" align="center" border="1" bgcolor="#f9f9f9" border="2" bordercolor="#e1e1e1">
<tr>
<td class="tableheader">Select Month</td>
<td class="tableheader">Select Year</td>
</tr>
<tr>
<td align="center">
<select name="month" id="month" style="width:100px">
<option value="1" <? if( $_SESSION['month'] == "1") echo 'selected';?>>January</option>
<option value="2" <? if( $_SESSION['month'] == "2") echo 'selected';?>>Febuary</option>
<option value="3" <? if( $_SESSION['month'] == "3") echo 'selected';?>>March</option>
<option value="4" <? if( $_SESSION['month'] == "4") echo 'selected';?>>April</option>
<option value="5" <? if( $_SESSION['month'] == "5") echo 'selected';?>>May</option>
<option value="6" <? if( $_SESSION['month'] == "6") echo 'selected';?>>June</option>
<option value="7" <? if( $_SESSION['month'] == "7") echo 'selected';?>>July</option>
<option value="8" <? if( $_SESSION['month'] == "8") echo 'selected';?>>Augest</option>
<option value="9" <? if( $_SESSION['month'] == "9") echo 'selected';?>>September</option>
<option value="10" <? if( $_SESSION['month'] == "10") echo 'selected';?>>Octuber</option>
<option value="11" <? if( $_SESSION['month'] == "11") echo 'selected';?>>November</option>
<option value="12" <? if( $_SESSION['month'] == "12") echo 'selected';?>>December</option>
</select>
<td>
<select name="year" style="width:100px">
<?
$year = date(Y);
for($i=1;$i<=5;$i++)
{?>
<option value="<?= $year;?>"><?= $year ?></option>
<?$year = $year + 1;?>
<? }?>
?>
</select>
</td>
</tr>
</table>
<br>
<table style="border-collapse: collapse;" bgcolor="#f9f9f9" border="2" bordercolor="#e1e1e1" cellpadding="3" cellspacing="3" width="80%">
<tr>
<td class="tableheader">Select</td>
<td class="tableheader">Ledger Name</td>
<td class="tableheader">Budget Amount</td>
<td class="tableheader">Last month Budget</td>
<td class="tableheader">Last Actual</td>
</tr>
<?
$className = "evenrow";
$count=0;
while($row= mysql_fetch_array($result)) {
?>
<tr class="<?= $className ;?>">
<td align="center"><input type="checkbox" name="chk<?=$count;?>" id="chk<?=$count;?>" onClick="disable(this);able(this);" value="<?=$count;?>" <?if(isset($_SESSION['bamt'.$count])) echo 'checked'; ?>></td>
<td align="center"><?= $row['ledgerName'];?><input type="hidden" id='ledger<?=$count?>' name='ledger<?=$count?>' value="<?=$row['ledger_id'];?>"></td>
<td align="center"><input maxlength="8" type="text" value="<?= $_SESSION['bamt'.$count]?>" name="bamt<?=$count;?>" id="bamt<?=$count; ?>" onkeypress="return numbersonly(this,event)" class="textbox2" <?if(isset($_SESSION['bamt'.$count])) echo'enabled'; else echo 'disabled'; ?>></td>
<td align="center"><input type="text" value="<?if(isset($_SESSION['bamt'.$count])) echo $_SESSION['lastmonth'.$count]?>" name='lastmonth<?=$count;?>' id="txtHint<?=$count?>" class="textbox2" readonly="readonly" onmouseover="myHint.show(0, this)" onmouseout="myHint.hide()"/></td>
<td align="center"><input type="text" name='lastac<?=$count;?>' value="<?if(isset($_SESSION['bamt'.$count])) echo $_SESSION['lastac'.$count]?>" id="txtHnt<?=$count?>" class="textbox2" readonly="readonly" onmouseover="myHint.show(1, this)" onmouseout="myHint.hide()"/></td>
<? $count++;
if($className == 'evenrow')
{
$className = oddrow;
}
else
{
$className = evenrow;
}
}
?>
<tr>
<td colspan="5" align="center"><button type="button" onclick="return myPopup2();"><span>Add New Ledger</span></button></td>
</tr>
<!-- </tr>
<td align="center" colspan="2">Total</td>
<td align="center"><input type="text" readonly="readonly"></td>
<td align="center"><input type="text" readonly="readonly"></td>
<td align="center"><input type="text" readonly="readonly"></td>
</tr> -->
</tbody>
</table>
<br>
<button class="ajaxsubmit" type="submit" name="Process" id="Process" onclick="return countCheckboxes();"><span>Submit</span></button>
</center>
</center>
<input type="hidden" name="counter" value="<?=$count?>">
<input type="hidden" name="check" id='check'>
</form>
<br><div id="footer">
<?php include_once('footer.html');
for($i=0;$i<=$count;$i++)
{
if(isset($_SESSION['bamt'.$i]))
{
unset($_SESSION['bamt'.$i]);
}
}
?>
</body>
</html>
Unsolved 
Offline 
