S.#	Name	qty	Retail	%age	Trade"; $itemID= odbc_result( $cur, 'itemID' ); $itemName= odbc_result( $cur, 'itemName' ); $size=strlen($itemName); $rPrice= round(odbc_result( $cur, 'rPrice' ),2); $percentage= odbc_result( $cur,'percentage'); $tPrice= round(odbc_result( $cur,'tPrice'),2); echo "
$cnt	$itemName	".odbc_result( $cur,'qty')."	$rPrice	$percentage	$tPrice"; //$amount+=odbc_result( $cur, 'tPrice' )*odbc_result( $cur, 'qty' ); } //if($cnt>0) echo "
Summary	".round($amount) ; echo "

S.#

Name

qty

Retail

%age

Trade"; $itemID= odbc_result( $cur, 'itemID' ); $itemName= odbc_result( $cur, 'itemName' ); $size=strlen($itemName); $rPrice= round(odbc_result( $cur, 'rPrice' ),2); $percentage= odbc_result( $cur,'percentage'); $tPrice= round(odbc_result( $cur,'tPrice'),2); echo "

$cnt

$itemName

".odbc_result( $cur,'qty')."

$rPrice

$percentage

$tPrice"; //$amount+=odbc_result( $cur, 'tPrice' )*odbc_result( $cur, 'qty' ); } //if($cnt>0) echo "

Summary

".round($amount) ; echo "

S.#	Date	Apt No.	Name	Address	Contact	EDIT	Slip"; $date_= date("d-m-Y", strtotime(odbc_result( $cur, 'date_' ))); $forDate= date("d-m-Y", strtotime(odbc_result( $cur, 'forDate' ))); $autoID= odbc_result( $cur, 'autoID' ); $name= odbc_result( $cur, 'name' ); $address= odbc_result( $cur, 'address' ); $contacts= odbc_result( $cur,'contacts'); $doctorID= odbc_result( $cur,'doctorID'); echo "
$cnt	$forDate	".odbc_result( $cur, 'aptNo' )."	$name	$address	$contacts	edit" ; echo "	Slip"; } echo "

S.#

Date

Apt No.

Name

Address

Contact

EDIT

Slip"; $date_= date("d-m-Y", strtotime(odbc_result( $cur, 'date_' ))); $forDate= date("d-m-Y", strtotime(odbc_result( $cur, 'forDate' ))); $autoID= odbc_result( $cur, 'autoID' ); $name= odbc_result( $cur, 'name' ); $address= odbc_result( $cur, 'address' ); $contacts= odbc_result( $cur,'contacts'); $doctorID= odbc_result( $cur,'doctorID'); echo "

$cnt

$forDate

".odbc_result( $cur, 'aptNo' )."

$name

$address

$contacts

edit" ; echo "

Slip"; } echo "

Serial	Account Name	Description	Opening	Balance	Order	EDIT	Ledger"; while( odbc_fetch_row( $cur ) ) { $ID= odbc_result( $cur, 'ID' ); $headName= odbc_result( $cur, 'headName' ); $headType= odbc_result( $cur, 'headType' ); $openingBalance= odbc_result( $cur, 'openingBalance' ); $order_= odbc_result( $cur, 'order_' ); $symbol= odbc_result( $cur, 'headDescription' ); echo "
$cnt	$headName	$symbol	$openingBalance	".round(odbc_result($cur,'Balance'))."	$order_	edit" ; echo "	ledger" ; $cnt+=1; } echo "

Serial

Account Name

Description

Opening

Balance

Order

EDIT

Ledger"; while( odbc_fetch_row( $cur ) ) { $ID= odbc_result( $cur, 'ID' ); $headName= odbc_result( $cur, 'headName' ); $headType= odbc_result( $cur, 'headType' ); $openingBalance= odbc_result( $cur, 'openingBalance' ); $order_= odbc_result( $cur, 'order_' ); $symbol= odbc_result( $cur, 'headDescription' ); echo "

$cnt

$headName

$symbol

$openingBalance

".round(odbc_result($cur,'Balance'))."

$order_

edit" ; echo "

ledger" ; $cnt+=1; } echo "

"; echo "
"; while( odbc_fetch_row( $cur ) ) { $ID= odbc_result( $cur, 'ID' ); $headName= odbc_result( $cur, 'headName' ); $headType= odbc_result( $cur, 'headType' ); $openingBalance= odbc_result( $cur, 'openingBalance' ); $order_= odbc_result( $cur, 'order_' ); $symbol= odbc_result( $cur, 'headDescription' ); echo "

Serial	Account Name	Order	Symbol	EDIT
$cnt	$headName	$order_	$symbol	edit" ; $cnt+=1; } echo "

"; }elseif (isset($_GET['headID4'])){ $query = "select * from accountsView where mainHeadID='".$_GET['headID4']."' order by stdName"; //$query= "select * from student where accountID>0 order by accountID desc"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "

S.#	Name	Address	Opening	Balance	Edit	Purchase	pReturn	Payments	Ledger"; $date_= date("d-m-Y", strtotime(odbc_result( $cur, 'date_' ))); $accountID= odbc_result( $cur, 'ID' ); $accountName= odbc_result( $cur, 'stdName' ); $address= odbc_result( $cur, 'address' ); $contacts= odbc_result( $cur,'contacts'); echo "
$cnt	$accountName	$address	".odbc_result($cur,'admFee')."	".odbc_result($cur,'Balance')."	Edit"; echo "	purchase"; echo "	PurReturn"; //echo "	sale"; //echo "	saleReturn"; echo "	Payments"; echo "	ledger" ; $cnt+=1; } echo "

"; }elseif (isset($_GET['getBalanceID'])){ //$query = "select Balance from accountsView where ID='".$_GET['getBalanceID']."' and recordType='Account'"; $query = "select Balance from accountsView where ID='".$_GET['getBalanceID']."' "; $cur= odbc_exec( $conn, $query ); //echo "

"; while( odbc_fetch_row( $cur ) ) { echo "

Balance: ".round(odbc_result($cur,'Balance'))."

"; } //echo "

"; } function getDay($dayID) { $dayname = array("1=>","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"); return $dayname[$dayID]; } ?>

Retail/Sale Price	"; //echo " Price/tabs : "; //echo " Nos of Tables : "; echo "
Percentage	"; echo "
Trade/Purchase Price	"; echo "
Opening	qty: %age:Unit: Batch: Expiry: Inv#:"; //echo "
Packing	"; //echo "
Stock Limit	"; //echo "
Barcode	"; echo "
"; echo "