Expenses

"; echo "

Keyword:From:

TO :

"; echo "

"; ?>

"; echo ""; //echo ""; echo ""; echo ""; //echo "

Voucher No.	"; echo "
Date	"; echo "
Expenses Head	+"; //echo " +"; //echo "
Description	"; echo "
Description	$description"; echo "
Amount	"; echo "
Contacts	"; echo "
Payment From	Balance: ".round($Balance)." "; echo "
File/Image	"; echo "
"; echo "

"; $expID= ""; $description= ""; $query= "select * from expensesView where date_ between '$from' and '$to' and description like'%$anyvalue%' and userID=".$_SESSION["userID"]." order by vno desc"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1;$total=0; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "

S.#	VNo.	Date	Head	Description	Amount	Edit	Del	Print"; $date_= date("d-m-Y", strtotime(odbc_result( $cur, 'date_' ))); $expID= odbc_result( $cur, 'expID' ); $description= odbc_result( $cur, 'description' ); $amount= round(odbc_result( $cur, 'amount' )); $total+=$amount; $vno= odbc_result( $cur,'vno'); $path_= odbc_result( $cur,'path_'); echo "
$cnt	$vno	$date_	".odbc_result( $cur,'expHead'); if($path_=="") echo "	$description"; else echo "	$description"; echo "	$amount	" ; echo "	" ; echo "	" ; //echo "	"; $cnt+=1; } if ($cnt==1) { echo "No Record Found"; }else{ echo "
Summary					$total" ; } echo "

"; odbc_close($conn); /* drop view dbo.accountsView CREATE VIEW dbo.accountsView AS SELECT AccountHeads_1.headName AS SubHeadName, AccountHeads_2.headName AS mainHeadName, AccountHeads_1.ID AS subHeadID, AccountHeads_2.ID AS mainHeadID, dbo.student.ID, dbo.student.stdName, dbo.student.contacts, dbo.student.address, dbo.student.Balance, dbo.student.admFee, dbo.student.Remarks, dbo.student.Date_ FROM dbo.AccountHeads AccountHeads_1 INNER JOIN dbo.AccountHeads AccountHeads_2 ON AccountHeads_1.headID = AccountHeads_2.ID INNER JOIN dbo.student ON AccountHeads_1.ID = dbo.student.sectionID WHERE (dbo.student.ID > 0 and dbo.student.recordType='Account') drop VIEW dbo.expensesView CREATE VIEW dbo.expensesView AS SELECT dbo.expenses.Vno, dbo.expenses.date_, dbo.expenses.description, dbo.expenses.amount, dbo.expenses.Type, dbo.expenses.userID, dbo.expenses.expID, dbo.expenses.paymentType, dbo.AccountHeads.headName AS expHead, dbo.AccountHeads.order_, dbo.student.stdName AS account FROM dbo.expenses INNER JOIN dbo.AccountHeads ON dbo.expenses.expID = dbo.AccountHeads.ID INNER JOIN dbo.student ON dbo.expenses.paymentType = dbo.student.ID WHERE (dbo.student.ID > 0 and dbo.student.recordType='Account') */ ?>