Wduw{Aó*19<@\N iW GfBd"ECCJQT_61oo慚`-ԺnD M ~a>fbJf=MKn,}59҄B=!د_C3FD}ңo|.ݰ>{] ;W RQ~"^pi3|~@/ h+1]{~[|BZyDQYrK_Ba0ͱ@ɲXvd3 pUIV(ǣw5+)ՒZױc>_#k٠A}i-kOH6{#%]ܿ 7YrDqӣca7s\nBs%KBlT 8JOpL-Ch[b`[yK'UQUl[sbp0+Gbh7#@@hOl7cdiwkq_R*=T$9`l֕Q unm=؃-6&~颺L֖}l\|I^~sp=1lmh}$摊i-6&~颺L֖}P7ew\ }5!7VX^p S+3tS`^ v'#d~6=EQ4#T ޒ\u-0ZNSe3FUaeig!֐#-V=F;w"B'SώAW,`^ v'#d~ngRrG(B'SώAW,`^ v'#d~ %䟱D!KrMu2=̥-6&~颺L֖}l\|I^]0̋PiL C@bcs yr\CIWҁ?~F]㇕S*q=f'OFG.^@VMD7斡L?F^=t9LJy#Tw1laVΉi6Umܳ?# }oo+B W#Fa<sMT!=__/j8,\O/Z:mz1mW:VCjۀښgz$+3Gh.~֠--y~Hz#O 9VgŽ~`fՄ+W3BVީ8b;zIƕ3肳OAg m)Sw7n eoCsFS/"pj(Y2_mbp$]?Q@:|O2й=&0؁8XTSTxŴ|OmFND=VwlX#1 eEPwYKȂ͝1) p.iks_qu&H[ŃDvGχ{aP՚cP$*0x5cV{၈^[fOqqzrb "IHm 5㄂ZC3Z!۞_%m0"1{OUFUvhK;rOya%*:{7F8,~y!;2Pr= [,Չ7.ELsQ0~07GTy\Ѳkz!siG`. #Uehe'7J",w(TL//Z.g+ֽ7Z6K8OUZt#Bg+tȁ7^L^C(Z狱2w\08fv}"ȱp*4]!28> $| /`*Dp>F<ܤVK(ǶB5?`ɽκ'Ofe5JސrN.6a'@!Pe@~A_))zS#3*  GVe3f01ouP= ްgFHy$~)u&Z;>&նR1r`F7._C?{]QVcW4.=P9e*i a높k-A8R=SFPG`Ft_dE#5)[0*A],{c`.3ui`? آU3t`_xγt ysE]5?׆oḦwuMfކP82Iz[4X R+F/<4v( ^Ԅd\{$lFBb5JN} dlMſ=xFYpT9giADb+SEQV]khėTHNl'̤U+u"ŽQy# 61RK;B۸V-usD.|IAKxQ:^/M4&BbUjK+3$!P1*:o- /4ΰ<fg7:n`P\Df%*o6.i~0]PXoH8$qg>*:?D4˶[=C~*j&;5=a=k4$^Ps ::޽eWpGw_@dga iL(4 2-zxS|.oM'Gʻ(~C*j\[#0mҌ1<@|/L!TQ!niRikȸw4qF6ilk, '܊khr+GCXc•ޱfE,6ƚ3zEao\}{HY-ḭx_4)T#ƘBY:?D4˶[=C~*j&;5=a=k4$^Ps ::޽eWpGw_@dga iL(4 2-hE.j~֖{Ƥ ۰? &wBz8ɤ,Z .^ݨ]l"7'Vq 7Mc-zv2&,J:@qK$6o~oSuG& Qguwv=i]& JJJ800z^[56͟{X|qXV=N3yj#dzߌ˃>,Mkſsa3u٢*?ZycKi'|k P9kL7@\ϘAET>\(ZFYYx'@ܡXBuU VfOk3Q5cz+ AECzhW # QQD$!>i^ojp0(7d&UnXJЉjָ1N_3 XMo bct%۷Ħlp#`9Bydߤ$x> ظUQ{22mV !U%yXbp+|7E?;g_x'USk\tm>-B{JQ\N)c.JM佬եw?ɰl61DB$?o͵j]?w8| g!8$&ޑGw!uBXhxcM=SKWEcription= $_POST['description']; $from=$date_ = date('Y-m-d',strtotime($_POST['date_'])); $monthYear = date('Y-m-01',strtotime($_POST['monthYear'])); $amount= $_POST['amount']; $contacts= $_POST['contacts']; $vno= $_POST['vno']; $referenceNo= $_POST['referenceNo']; $paymentType=$_POST['paymentType']; if($_SESSION['labid']==7){ // form khaqab coal company only if($expID!=3797) $referenceNo=""; // for fraight only } $isAllowed=false; //if(getName($conn,"select Balance from student where ID='$paymentType' and recordType='$recordType'")<$amount){ $curRecord=$expID."".$description."".$contacts."".$referenceNo."".$date_."".$paymentType; if ($vno==""){ if(!isset($_SESSION['preRecord']) or $_SESSION['preRecord']!=$curRecord){ if(canSave($conn,"expenses2")=="0"){ $vno= getName( $conn, "select isnull(max(vno),0)+1 from expenses" ); $query="insert into expenses (monthYear,recordType,referenceNo,labid,contacts,paymentType,description,expID,amount,vno,date_,userID) values('$monthYear','$recordType','$referenceNo','".$_SESSION['labid']."','$contacts','$paymentType','$description','$expID','$amount','$vno','$date_',".$_SESSION['userID'].")"; $cur= odbc_exec( $conn, $query ); $isAllowed=true; $_SESSION['preRecord']=$curRecord; } } }else{ if(canUpdate($conn,"expenses2")=="0"){ $query="update expenses set monthYear='$monthYear',referenceNo='$referenceNo',contacts='$contacts',paymentType='$paymentType',description='$description',expID='$expID',amount='$amount',date_='$date_',userID='".$_SESSION['userID']."' where recordType='$recordType' and vno='$vno' and labid='".$_SESSION['labid']."' "; $cur= odbc_exec( $conn, $query ); $isAllowed=true; } } //echo "



".$query; if($isAllowed==true){ odbc_exec($conn,"delete from ledger where vno='$vno' and labid='".$_SESSION['labid']."' and recordType='$recordType' " ); if($paymentType!="" and $paymentType>0){ //Cash Credit $query="insert into ledger(monthYear,recordType,accountID,remarks,credit,vno,date_,userID,labid) values('$monthYear','$recordType','$paymentType','$description','$amount','$vno','$date_',".$_SESSION['userID'].",".$_SESSION['labid'].")"; $cur= odbc_exec($conn,$query ); $cur=calculateBalance($conn,$paymentType); //echo "



".$query; } //Expenses Debit $query="insert into ledger(monthYear,recordType,accountID,remarks,debit,vno,date_,userID,labid) values('$monthYear','$recordType','$expID','$description','$amount','$vno','$date_',".$_SESSION['userID'].",".$_SESSION['labid'].")"; $cur= odbc_exec( $conn, $query ); $cur=calculateBalance($conn,$expID); $temp_name=$_FILES["fileToUpload"]["tmp_name"]; $imageFileType = pathinfo($temp_name,PATHINFO_EXTENSION); $picname="exp-".$vno."_".basename($_FILES["fileToUpload"]["name"]); $target_file = $_SESSION['photosFolder']."/".$picname; if(move_uploaded_file($temp_name, $target_file)){ $oldImg=getName($conn,"select path_ from expenses where vno='$vno' and labid='".$_SESSION['labid']."'"); if ($oldImg!="") unlink($_SESSION['photosFolder']."/$oldImg"); $query="update expenses set path_='$picname' where vno='$vno' and labid='".$_SESSION['labid']."'"; $cur= odbc_exec( $conn, $query ); } //echo ""; } //exit(); } $monthYear = date('Y-m',strtotime($monthYear)); $referenceNo=$contacts=$expID= "";$description= ""; $amount= "";$vno= "";$Department= "";$anyvalue= ""; $description= ""; $Status=0; $vno=""; $Salary=0; //$date_ = date('Y-m-d',time()); if (isset($_REQUEST['anyvalue'])) $anyvalue=$_REQUEST['anyvalue']; if (isset($_GET['referenceNo'])) { // for Kharan Coal only $referenceNo = $_GET['referenceNo']; $expID="3797"; // fraight $amount=getName($conn,"select (qty*tPrice)+discount from iteminout where invno='$referenceNo' and labid='".$_SESSION['labid']."' "); $query = "select * from expenses where referenceNo='$referenceNo' and labid='".$_SESSION['labid']."' "; //echo $query; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { $from=$date_= date("Y-m-d", strtotime(odbc_result( $cur, 'date_' ))); $expID= odbc_result( $cur, 'expID' ); $description= odbc_result($cur,'description'); $amount= round(odbc_result( $cur, 'amount' )); $vno= odbc_result( $cur,'vno'); $paymentType= odbc_result( $cur,'paymentType'); $contacts= odbc_result( $cur,'contacts'); $referenceNo= odbc_result( $cur,'referenceNo'); } } if (isset($_GET['vno'])) { //$vno = $_GET['vno']; $query = "select * from expenses where vno='".$_GET['vno']."' and labid='".$_SESSION['labid']."'"; //$query = "select * from expenses where vno=? and labid=?"; //$arr=array($_GET['vno'],$_SESSION['labid']); //echo $query; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { $from=$date_= date("Y-m-d", strtotime(odbc_result( $cur, 'date_' ))); $monthYear= date("Y-m", strtotime(odbc_result( $cur, 'monthYear' ))); $expID= odbc_result( $cur, 'expID' ); $description= odbc_result($cur,'description'); $amount= round(odbc_result( $cur, 'amount' )); $vno= odbc_result( $cur,'vno'); $paymentType= odbc_result( $cur,'paymentType'); $contacts= odbc_result( $cur,'contacts'); $referenceNo= odbc_result( $cur,'referenceNo'); } } ?> HOME
Voucher No."; ?>
Reference No
Date
for the Month
Expenses Head
Description
Amount
Contact No.
Payment From
File/Image
"; //echo "
"; //echo ""; //echo ""; if($_SESSION['labid']==9){ //echo ""; if($referenceNo=="") $referenceNo=getName($conn,"select isnull(max(referenceNo),0)+1 from expenses where labid='".$_SESSION['labid']."' "); echo "Voucher No."; }else{ echo ""; } //echo "Voucher No."; //echo "Date"; echo "Expenses_Head +"; //echo " +"; //echo "Description"; //echo "Amount"; //echo "Contacts"; echo "Payment From +"; //echo " +"; //echo " "; //echo "File/Image"; //echo ""; echo "
"; */ $expID= ""; $description= ""; //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.expenses2.Vno, dbo.expenses2.date_, dbo.expenses2.description, dbo.expenses2.amount, dbo.expenses2.Type, dbo.expenses2.userID, dbo.expenses2.expID, dbo.expenses2.paymentType, dbo.AccountHeads.headName AS expHead, dbo.AccountHeads.order_, dbo.student.stdName AS account FROM dbo.expenses2 INNER JOIN dbo.AccountHeads ON dbo.expenses2.expID = dbo.AccountHeads.ID INNER JOIN dbo.student ON dbo.expenses2.paymentType = dbo.student.ID WHERE (dbo.student.ID > 0 and dbo.student.recordType='Account') */ ?>
"; echo "
"; echo ""; echo ""; ?> "; //$query= "select * from expensesView where labid='".$_SESSION['labid']."' and date_ between '$from' and '$to' and description like'%$anyvalue%' and userID=".$_SESSION["userID"]." order by vno desc"; $query= "select * from expenses where recordType='$recordType' and labid='".$_SESSION['labid']."' and date_ between '$from' and '$to' "; if($anyvalue!=""){ $ids="select ID from AccountHeads where headName like'%$anyvalue%' and headType='expenses' and labid='".$_SESSION['labid']."' "; $query.=" and description like'%$anyvalue%' or expID in($ids) "; } $query.=" order by date_ asc,vno desc"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1;$total=0; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
#DateDescriptionAmount"; $date_=getAfghaniDate($conn,odbc_result($cur,'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$date_"; //.getHead($conn,odbc_result( $cur,'expID')); if($path_=="") echo "$description"; else echo "$description"; echo "$amount"; /* if(odbc_result( $cur,'approvalStatus')==0){ echo "Pending"; }elseif(odbc_result( $cur,'approvalStatus')==1){ echo "Approved"; }else{ //$badge="badge bg-info";$status='New'; echo "Cancelled"; } */ echo "" ; echo "" ; echo "" ; //echo ""; $cnt+=1; } if ($cnt>1) { echo "
Total$total" ; echo "
"; } ?>