(/ESCb6Ѐ_p5MT&.`=%7<8Zz67QI3ۨ&fj8[I|I4 d< X;2G Up]'|2_B?tC7N[WݯFhS{4ÉI>*#zrarjMU Sሒ3~PsjI[0U4ʷN=Wi>#D|"` KMM[pFL?+BXxۙSC8( }@fTIɣo(SZq\jV"MIBC/Y&v=&24j 1'եTP:W2-jnT>xgJd1:W:ɞ!otQJ%HCam)ޏk3bǹn8a Ô %:b %Ėy; ck;GBq\`:auFe g7| *äMK݆1wL;4_.R؏ӂ hЃBEF3AskqLIյ۠" fPU $ .~..-"b 8Dd^;Zm|ħs\ʹo )9,R\>z~4x`|P tƎ:$;$<9yP8mMGpe:w.F,Y.cO`1c_|@Ifʻ"7BNH}qmHM-Tbr qPGv`ꨃUwBz8ɤ,5Ǭ8/ Y5.SYa"^g0tG llM!n[{Ur|Ddɯ@rL2#xS?nh(c8"0hbq#':x!0*sU uFVz@Y944˜:̜8]u@`QYsyއMvJFXI/u8lT$M".SRVAۋ/-zźHg2\[/l%q;1b#$B $ۄÀ ;ݐrI0h{n"2DMУ %8Y$Lʅ!Д'n4Ó .YG r_ٱ^ [!?=d@.o/6Z{Ql7Ṱ\~`%lVeCFn/ %`sx)XNM:ȉyzކP82Iz"ډ[9ɛ>/ٗEK@Ѥqׇ0\;XAڵ Ouj|Yͅ]=w {M##vc9](@u=Ch%3.,Joȹ%+´uNwG5e&H(z.du)D D܄ a3'=!ҿ꒘G:I.M?j@[6#%e5fCH#)FEt"-s BA%}u+dqRC 0oKH |ϟJ=zv0=^oXK!lqNۯ*=R 9FP4;>RA KO. }"NTP>oQ$L;a;oe5fCH#)FEt"-s BAH{j BjȨO#NSFEGa~]M U =Qi[?'RͶA`2^FP>äC|8jA`  ?@!J{WDRP J?:MW}4@sEtSYT\ʠ}Bh {,IA~^Wf)0 MWUH mY/bD_k75ٳ/X+켵^qw jN9X~l]έo,9dGmݩmo'oϙl*ٽcPL'bZcf^[MԖFӛ7-7-Gúzk\olE yjhH%X8|:ezs4 .x'Ҋ x%]#0E5CY0>A~>= M=~B|ATbl2'Ķy=gQt(>!=Ԥ;@|/-DOܸ+Wl% {LJ\/iljE#-CX#1̄ ՚خq:ou<wR3w)]r̅cO\T;~3BZ1dLNEBxFؤF1k6KD EXMޮM>1}(z.du)D"G/ͩ?BV9Nmj(I#]출Bdxauaњ;=LMAkI}GuR*=R 9FP4;U:,~lbğЇLĥxm6wFAt`ꌪJo76+d+t$0+k=T?2c:m$)bo@,r:Ŏtr`oTm=޹Y҇} O8te[b ?1'gQyܛy7J0;aUX43hD,t6 J_rotect($con,$_GET['delvno']); $actid = getName($con,"select actid from sale2 where invno='$invno' and LabID='$LabID'"); $query = "delete from sale2 where invno='$invno' and LabID='$LabID'"; mysqli_query($con,$query); mysqli_query($con,"delete from ledger where saleno='$invno' and LabID='$LabID' "); $invno = $remarks = $amount = $actype = $saleRate =""; unset($_SESSION['preRecord']); $date_ = date('Y-m-d',time()); } //$ret=getName($con,"select name,balance from accounts where id='$actid' and LabID='$LabID' "); //echo "

".$ret[0]." (Balance=".round($ret[1]).")

" ; $query=getName($con,"select CONCAT(name,' (Balance=', balance,')') from accounts where id='$actid' and LabID='$LabID' "); echo "

".$query."

" ; ?>
ADD/UPDATE INVOICE
Date
Description
Amount
Rate
Sale Rate From Account"; ?>
Save // echo "
#DateRemarksAmountRatesaleRateEditAmountProfitDelete"; //$query = "select invno,remarks,amount,saleRate,Date_,type,time_,rate from sale2 where LabID='$LabID' and actid='$actid' order by date_ desc,time_ desc limit 20"; $query = "select * from sale2 where LabID='$LabID' and actid='$actid' order by date_ desc,time_ desc limit 20"; $cnt=1; $run = mysqli_query($con,$query); while ($row=mysqli_fetch_array($run)){ $vno = $row['invno']; echo "
$cnt".date('d-m-Y',strtotime($row['date_']))." ".date('h:i A',strtotime($row['time_'])); echo "".$row['remarks']."".$row['amount']."".$row['discount']; echo "".$row['extracharges'].""; //echo "delete"; echo "".round($row['amount']*$row['discount']); //Amount echo "".round($row['amount']*$row['extracharges']-$row['amount']*$row['discount']); echo ""; //echo "".date('h:i A',strtotime($row['time_'])); $cnt+=1; } mysqli_close($con); ?>