®ÈWþñduwÍË{žóÙAâý¬ÒÃ³*ôî19éÃÇH+ä«µª
Fß?µ4 ›Ü`ã-²¦"g>C@GæL½:‡\)®9ÐEÐbª§G]˜þ/ŠÔ‹=˜šp÷U¹þòYÉqD«x:EšuûWÚ©ü&cWü”àùÂµçÂw	Z 4¼Îñ-èyŸ®¬É‰îwS$(¦5iÔÍŸù"ŽAáÄ8oïÐ˜Ø}&¾ÇœaUs,å•Ùî€?e^Ø•µ1tz÷„þq‡a•Ü´L•G8]oœNõžŸ‡{Ï/†'-«l ‘žù"txyãþ»÷`»Â¦ÎŒô,¼a?ãKú½*•í¬ºWÊIB˜û ZKZ?àÑÒ…'£®Šg:e6ôZêí¶¶2u5}{WXB×Æ¶×I›¢3ÅXñ0Ó† YGÛ%qÒî<•“°¹ næ…Fe˜çàïI4»X¸€“ÌœÛï ØÅä)ÐVSP¿IóÔc\·¡2¦A^â¨PFÉ¼Õ£©}üƒ5·ƒDHÌüî?\ÞDvb¡Rƒ†oYõ6¤UdF§ä½Ùßø5´€¿¡îÁmÜ‘¤½„ƒÈwr¦—&_úzä°l/¹‡·œ¯\nAÃor‡˜î ûŒòqßUveûm¡7µÞù8’éçV/Xq‘åÊaá¼µ[HdÄ²½YñŠë½íiõ…œWïªI^`ižrg•©V„ý+Ù’ êÿ\—ã$cÏ„›‚´àÉ&ƒ•+Ö—ûð`šJs¸pÒ>Ùàvê'õßæ˜ªÿÂ-è½^¿áU¦öé°Ö•yoÙªÒ$Î–¦d´Fœ£_^¸]ë!å 
	ù3ûŸ1
¢Û
co¸ZUÖ–KT¸žhi
­.Æ¦€ ÔÄD˜kZWµ„nKä¡K8XÕÿiõ)Þv#=ré5¬—ª¶þ>¶†{]N6ïª—d}dl;°òŸÌ<ú+Jm¾¡÷úÊpí °J`‘é ¦ýz"vÆ[Žg+”ipÛn:
ÕQOªRÏ²Q ðý™Ñ­Õ#V²0J«äû§0Ü;²à³q‹ÜSÙÙ(£«£Ñle„`TWÅ{Cá¼_xÙ¾²²)|û «nT'hÌœ´K™´tžÿù)Ü’¿°”3@¦Ô;^ŽØ’ðÜQüøhX­§YO¬z¥Äe¼Ãkâ’öò¬®_°9Îx¯€ñØŠŽæÁTi~¨(K®ßÅyIÚEÝä› ­hØgÊÖ?ŸË]ÒT%N‚qyõ +Âá¶1©	¾a6æØˆKZ_TTú–9Îx¯€ñØŠŽæÁTi~¨(K®ßÅyIÚEÝä› ­häÏÜÇ3'h¸4ýÃ3â«LágÉ#¢“9½ÙÎuú:I„ó<PÓrPQÿB¥ÜöCØöW;-Zè!¾o;ˆ=™z¯ÿ¹CØ52¯Ë ö0IUÿo6º`çlî±Ùžƒâ‚Ì€¦ íëîW­3:Îê‰[ÙódûêÛpÚïsªˆì é¡‹Âu@bq¢ß \!Ú–Yª‚™í÷ÊF¸1}	²ÞœÄ•NL@¡Ö£÷Dà¦_MãèuÚ­® múÐàd£¼÷G¿<¶¸ü§c+ap>>”€¢Éè[¯ÑQPÓCÓKmƒÃU øg<º””FañónúËšØ` :Î#¶Í9iúC-}¿F]ˆ §ÿ-,âó
p~w¥Û_Ù˜Mœˆ?JÅ5C¿<Ü\þŸ» ÒÝ7`Ú7¤b5Ï…#DxIQ•škâÂók©Ù°Çñ„øïZr}WWØŸ%Õ(CWº4ú¥º§˜ó÷Ük™¥<áå Üzz´H†À1‰NîêèÈ4vKÚ ½·H½C|*®¨å1¸ÓíHÜ¢‚ÿø•úfš–äù­Ì_Ë#†“uÚ­® múÐàd£¼÷G6^ZŽ8©Ä„jÉ K£]U øg<º””Fañónúk5%ëü·BèéôêÅ¥e! "êª»’íÓ]t32ï»Ÿ‰ãT¦yù…p±;ï»Ÿ‰ãT¦yù…p±;ÜµCÙHìñqLÇ!¢ù)GŒßwýMüÐã-¦‡‘Á”Tà‰oËOÄ‰±É9ùPÊ`±®cF,miõo{8'—™2}å4nlúZ«eÇØÓ’Od·€-%˜®˜MATó÷ïÖY|€ÙÄËãÔ…	w­¸lòv²PóÞC{&¶°ñ©þPà_aIl:^7òÕ ÷Á–9Þztó/Ç [iTÀG‘Á1ŠæÃ *ÎÊ„Â†¡ÊÏ´Å
4°g¡F¬”}ŸÃd¢NSÔœÎ UŒ	zœ8kÛ[ÇñÆ?ï»Ÿ‰ãT¦yù…p±;ï»Ÿ‰ãT¦yù…p±;ï»Ÿ‰ãT¦yù…p±;…Puñ£!L×=‘m‚ú©³úáŒp~;ÀS7}ýå¿ïž¡<-?°#è ü·wÑª?Ù×hfÎ@±'•ˆi5/ô*>Ýø,B„•òdÈo…„¦‡êRÉƒnOê×-ï‚w'd]—kÑFY]õueç®m
d±|ÛüjÐ4%÷u2k;Q6SÓLê&(îJ§åá‚Zô};n¸Pžp–¡ß!³õÐHÄ+…ª-ƒj8š&µ 2¹šŸT}ˆ<ovæhò£–Õº<üdófìp@íŒ9¿Ûe5_Ôr2YÖìUÝ¼… Ðîn‡ÚÀ‰ƒò«ëÒ»7§íy÷Àbš¬IÑV”vá®×
ç8­ŠT˜-H(à£eF£€ÝØ3Ù©²Ä’•‡DE&E{Ã¿ròv,q­x4ÆÚ§å¶Šez¢_~¢¨ª™ãy—](ïáö8ä®&“‘ŠµÀ‰#dflï}K/8ØÉó‚ù]ë;?ªd–‡¶hKP:Ç¬8Þq©)¡('[/ð¹îœoˆ$©¶edÏÖ³½[¹bž9ìü4¸L,`©…_©+LÎ¢î;¶SD·PÅÛ½Ï 	vKŒ.ÎžI.ÉÇëž;N?¤i·E’Òùš%×³ w¯pg´3¿qö9¹;¦#uÖü± UodRÊ¦ŒµOÿËì9³ÉjÒÑrRî©SÊs»Éñïõ™iÞ‚ée‹gå¦rNÀ§\¿;’ø@Íysf©_òEò­èï¢g$P°êŸ½YÚé½ž7 ’p‰L5·,îEOë^[CsŸðl<ÁiEvøa/J¿vÍ×vÇÿè6NÓæ&I};O0ÂÑ/–_

²w–´O¿ÈŠƒÙÆˆ ¢fM±Gy^>O’†µH0Ypâ”o—]”¸ŠêÊîÀš3FGrÏð­YÝ‰¥*â|v.
ài–À¹ ‹õc^†¿;ÊRn¡pIÑÀu0„NFÆ.Pe¬@´<h	ÆÍ-	|åàº!Óîìõá¡#Œ8,Gß`ãR$ù—p&‚ó)VÃ@9mÔÚq¥Ü­iê¿¬˜ ÿ3Ó–¿õïØÕpÓáÑ Êýem¯57IÇÞ „™Ð–É¸üòÂ¦üÓhzFˆÕ•PÚœ*«¤óš?OxjÆ­–Â ,Á´f¼\¡*Y'¦ÈÌpúIvBCÞw®E+e–âw„àeûöÃ§äí òODÝ›ÂÝ[kääˆÜ2ÎîZÎöüQI£‰€Wœà]ÔO….ÔÒØ¤Õ¿lK˜ÉRo5"Ì.”7PÍT	G´4UÙN“³d±Ý%‡üñt3‰î¼žIcðñ1ëX»|½úü{±›CŸ°ß£à8ð˜R8Z··®3·I(vb¹Ä~•“ÍSå¦ð)ÉA¹®AœòŸJGžgÛ ØãªM<ké$ô;c˜‚´Î–ËÅ.ŒS8'íè ›ç+hŸ@änDâ¾ŽåVIÎ‡Ö)Þ $þç¤R¯µ!ÔØÒÁÇW~Å[DŸ_Ò£¼ñ$ðê‚GSx9‘k	›Þ5®Ü¸­ê>Õ¸0n_Ôt;®_S'Ð²Sÿ#ü.«œÙow˜$ dñÍ¡xŒ`ñÊxqXÒcÉ¨Ó®wÙ4Œ$&þÌF¾^Ocë±ß’"*j¨Ü„¯‘c:Û‹{X5ø÷„’tÕÛÁÇAúnöþä÷.=L"¹é–¬òžBô7û7  gÓ‰nÈÝ,Ÿš#¦j¸Fk6œ4’`Nqâ'(˜çŒZ‹
ª‘×õW;{FFó ¶¢vŠ?MøÏGk)¬‡6€`Äš.2ÁŸH® §J§ÝÿÃÊ#	îO×³àýÝ›(ªLG—
¡bÔpš€ÌNzÑý[’aâØYÄz(G²{uÃÅG%CÆ&÷ÃÞ¥Þ_n¿Ö5…Xàù ½¬üÏ|oñj^»d2|z–ßi«N–0ÑSl4|kM`6ØdJ³¨½hfõ[²Kþ‚Æ¨-RÓ™ _]æG„Ì¾ÏÚ’·vd…Ü}àâërâ](ý£'gdfÖÅ$·µ€„¤ˆp`v­‡Ö†°5§ß•ZŸÊçÖŠ~æ¾†j
‰¶5s!+0Z*þ[Œ8±Øüä _‰Ok‘7oMEat ²Âï!;¼¿4wâf!Îæ´ %Öçá8,¨¡“ç~¡‘Ãyë@¢M»TßX9ƒ	ë|‡tmôSñçÁ²7»Ù\R}&B°oÅÍ¤Jy’{õ†Å«YnoV½:Ê^Ïi«‰ÞL‚iÒ
„™X†¶Æ¸a1ÙB¥…9ižü‚äã–þ8ú¤e ÿC¾8¿E·µ¿m¼y2<i˜YK‡\à$`[ß€Š^ÏÔ¬ÙüscÎÜüJëÆÌÒ=K:ÜòUÖSº>Ä‰MºíE=¥
9VÒME\®äzc/d<½x‘éƒT³·5»VæÏàí¶8IØ8Eæ’y­†Si©Êñ<Ë-%m>ãwX"«‡¶Øì«`1/°uÐî¼S8'íè ›ç+hŸ@änD0»êxpØEŒ;Qá´Ý_ŸýTm
ì ÈV¶-ó<EZ¹ð»ùƒO‘voÃ6¾;ØÙÌORëfi6A«™˜)]à3ÍÇ£@Œ5€cãÓÀ÷¸#’|1ð­8 ÖJ~*K/úà”û fU©Šœ4’`Nqâ'(˜çŒZ‹
ª9Ÿdô¯åUÚ-zˆS0J¸ÓS†ÐÐkK–8úO3'\Hïº$`[ß€Š^ÏÔ¬ÙüscÎÜüJëÆÌÒ=K:ÜE)ÊÞ#D©¤´Ú½éó”Šój­¶_½FUl„a“Âú$date_'  and ID in(select ID from student where recordType='Std' and labid='".$_SESSION['labid']."' )");
$stdatt=$present."/".$total;
if($total>0) $perStd=$present*100/$total; else $perStd=0;

$from_=getFirstDay($conn,$date_);
$to_=getLastDay($conn,$date_);
$admissionThisMonth=getName($conn,"select count(*) from student where status=0 and recordType='Std' and labid='".$_SESSION['labid']."' and (date_ between '$from_' and '$to_')  ");

?>
    <section class="section dashboard">
      <div class="row">

        <!-- Left side columns -->
        <div class="col-lg-8">
          <div class="row">

            <!-- Staff Attendance -->
            <div class="col-xxl-4 col-md-6">
              <div class="card info-card sales-card">

                <div class="filter">
                  <a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>
                  <ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">
                    <li class="dropdown-header text-start">
                      <h6>Filter</h6>
                    </li>

                    <li><a class="dropdown-item" href="#">Today</a></li>
                   
                  </ul>
                </div>

                <div class="card-body">
                  <h5 class="card-title">Staff Attendance<span>| Today</span></h5>
                  <div class="d-flex align-items-center">
                    <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                      <i class="bi bi-people"></i>
                    </div>
                    <div class="ps-3">
                      <h6><?php echo $att;?></h6> 
                      <span class="text-success small pt-1 fw-bold"><?php echo round($perStaff);?>%</span> <span class="text-muted small pt-2 ps-1">Presence</span>

                    </div>
                  </div>
                </div>

              </div>
            </div><!-- End  Card -->


            <!-- Staff Attendance -->
            <div class="col-xxl-4 col-md-6">
              <div class="card info-card sales-card">

                <div class="filter">
                  <a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>
                  <ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">
                    <li class="dropdown-header text-start">
                      <h6>Filter</h6>
                    </li>

                    <li><a class="dropdown-item" href="#">Today</a></li>
                  </ul>
                </div>

                <div class="card-body">
                  <h5 class="card-title">Student Attendance<span>| Today</span></h5>

                  <div class="d-flex align-items-center">
                    <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                      <i class="bi bi-people"></i>
                    </div>
                    <div class="ps-3">
                      <h6><a href='attendanceStdReport' target='_blank'><?php echo $stdatt;?></a></h6>
                      <span class="text-success small pt-1 fw-bold"><?php echo round($perStd);?>%</span> <span class="text-muted small pt-2 ps-1">Presence</span>

                    </div>
                  </div>
                </div>

              </div>
            </div><!-- End Sales Card -->

            <!-- Admissions Card -->
            <div class="col-xxl-4 col-md-6">
              <div class="card info-card sales-card">

                <div class="filter">
                  <a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>
                  <ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">
                    <li class="dropdown-header text-start">
                      <h6>Filter</h6>
                    </li>
                    <li><a class="dropdown-item" href="#" onclick='showExpMonth1("<?php echo $date_; ?>")'>This Month</a></li>                    
                  </ul>
                </div>

                <div class="card-body">
                  <h5 class="card-title">Admissions <span>| This Month</span></h5>

                  <div class="d-flex align-items-center">
                    <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                      <i class="bi bi-people"></i>
                    </div>
                    <div class="ps-3">
                      <h6><div id='divAdm'><?php echo round($admissionThisMonth);?></div></h6>
                      <span class="text-success small pt-1 fw-bold">%</span> <span class="text-muted small pt-2 ps-1">increase</span>

                    </div>
                  </div>
                </div>

              </div>
            </div><!-- End Sales Card -->


            <!-- Pending Approvals Card -->
            <div class="col-xxl-4 col-md-6">
              <div class="card info-card sales-card">

                <div class="filter">
                  <a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>
                  <ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">
                    <li class="dropdown-header text-start">
                      <h6>Filter</h6>
                    </li>

                    <li><a class="dropdown-item" href="#" onclick='
					
					
					("<?php echo $date_; ?>")'>Today</a></li>
                    <li><a class="dropdown-item" href="#" onclick='showExpMonth("<?php echo $date_; ?>")'>This Month</a></li>
                    
                  </ul>
                </div>

                <div class="card-body">
                  <h5 class="card-title">Expenses <span>| Today</span></h5>

                  <div class="d-flex align-items-center">
                    <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                      <i class="bi bi-cart"></i>
                    </div>
                    <div class="ps-3">
                      <h6><div id='divExp'><a href='<?php echo "Reports/expenses?from=$date_&to=$date_&anyvalue="?>' target='_blank'><?php echo round($Expenses);?></a></div></h6>
                      <span class="text-success small pt-1 fw-bold">%</span> <span class="text-muted small pt-2 ps-1">increase</span>

                    </div>
                  </div>
                </div>

              </div>
            </div><!-- End Sales Card -->


            <!-- Expnses Card -->
            <div class="col-xxl-4 col-md-6">
              <div class="card info-card sales-card">

                <div class="filter">
                  <a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>
                  <ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">
                    <li class="dropdown-header text-start">
                      <h6>Filter</h6>
                    </li>

                    <li><a class="dropdown-item" href="#" onclick='showExpDay1("<?php echo $date_; ?>")'>Today</a></li>
                    <li><a class="dropdown-item" href="#" onclick='showExpMonth1("<?php echo $date_; ?>")'>This Month</a></li>
                    
                  </ul>
                </div>

                <div class="card-body">
                  <h5 class="card-title">Approvals <span>| Today</span></h5>

                  <div class="d-flex align-items-center">
                    <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                      <i class="bi bi-cart"></i>
                    </div>
                    <div class="ps-3">
					
                      <h6><div id='divExp'><?php echo getName($conn,"select count(*) from expenses where (approvalStatus is null or approvalStatus=0) and recordType='expenses'  and date_='$date_' and labid='".$_SESSION['labid']."'  ");?></div></h6>
                      <span class="text-success small pt-1 fw-bold">%</span> <span class="text-muted small pt-2 ps-1">increase</span>

                    </div>
                  </div>
                </div>

              </div>
            </div><!-- End Sales Card -->


            <!-- Revenue Card -->
            <div class="col-xxl-4 col-md-6">
              <div class="card info-card revenue-card">

                <div class="filter">
                  <a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>
                  <ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">
                    <li class="dropdown-header text-start">
                      <h6>Filter</h6>
                    </li>

                    <li><a class="dropdown-item" href="#" onclick='showRecDay("<?php echo $date_; ?>")'>Today</a></li>
                    <li><a class="dropdown-item" href="#" onclick='showRecMonth("<?php echo $date_; ?>")' >This Month</a></li>
                    
                  </ul>
                </div>

                <div class="card-body">
                  <h5 class="card-title">Fee Collection <span>| Today</span></h5>
                  <div class="d-flex align-items-center">
                    <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                      <i class="bi bi-currency-">$</i>
                    </div>
                    <div class="ps-3">
                      <h6><div id='divRecovery'><a href='<?php echo"Reports/recovery?from=$date_&to=$date_" ?>' target='_blank'><?php echo $recovery?></a></div></h6>
                      <span class="text-success small pt-1 fw-bold">%</span> <span class="text-muted small pt-2 ps-1">increase</span>
                    </div>
                  </div>
                </div>
				


              </div>
            </div><!-- End Revenue Card -->
			
            <!-- Tuition Dues Card -->
<?php
$feeids="select ID from AccountHeads where headType='Fee' and headName in('Tuition','Tuition Fee','Monthly Fee')  and labid='".$_SESSION['labid']."' ";
//$transport=getName($conn,"select sum(amtPosted)-sum(amtReceived) from studentFee where feeID in($feeids) and stdID in(select ID from student where balance>0 and recordType='Std'  and status=0 and labid='".$_SESSION['labid']."')  "); 
$tuition=getName($conn,"select isnull(sum(amtPosted-amtReceived-discount),0) from studentFee where feeID in($feeids) and stdID in(select ID from student where balance>0 and status=0 and labid='".$_SESSION['labid']."'  )  "); 
?>			
            <div class="col-xxl-4 col-md-6">
              <div class="card info-card revenue-card">

                <div class="filter">
                  <a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>
                  <ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">
                    <li class="dropdown-header text-start">
                      <h6>Filter</h6>
                    </li>
                    <li><a class="dropdown-item" href="#">All</a></li>
                    
                  </ul>
                </div>

                <div class="card-body">
                  <h5 class="card-title">Tuition Dues<span>| All</span></h5>
                  <div class="d-flex align-items-center">
                    <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                      <i class="bi bi-people"></i>
                    </div>
                    <div class="ps-3">
                      <h6><?php echo $tuition?></h6>
                      <span class="text-success small pt-1 fw-bold">%</span> <span class="text-muted small pt-2 ps-1">increase</span>
                    </div>
                  </div>
                </div>
				


              </div>
            </div><!-- End Revenue Card -->
            <!-- Transport Dues Card -->
<?php
$feeids="select ID from AccountHeads where headType='Fee' and headName in('Transport','Transport Fee')  and labid='".$_SESSION['labid']."' ";
//$transport=getName($conn,"select sum(amtPosted)-sum(amtReceived) from studentFee where feeID in($feeids)  "); 
$transport=getName($conn,"select isnull(sum(amtPosted-amtReceived-discount),0) from studentFee where feeID in($feeids) and stdID in(select ID from student where status=0 and labid='".$_SESSION['labid']."'  )  "); 
?>			
            <div class="col-xxl-4 col-md-6">
              <div class="card info-card revenue-card">

                <div class="filter">
                  <a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>
                  <ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">
                    <li class="dropdown-header text-start">
                      <h6>Filter</h6>
                    </li>
                    <li><a class="dropdown-item" href="#">All</a></li>
                    
                  </ul>
                </div>

                <div class="card-body">
                  <h5 class="card-title">Transport Dues<span>| All</span></h5>
                  <div class="d-flex align-items-center">
                    <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                      <i class="bi bi-people"></i>
                    </div>
                    <div class="ps-3">
                      <h6><?php echo $transport?></h6>
                      <span class="text-success small pt-1 fw-bold">%</span> <span class="text-muted small pt-2 ps-1">increase</span>
                    </div>
                  </div>
                </div>
				


              </div>
            </div><!-- End Revenue Card -->


            <!-- Total Fee -->
            <div class="col-xxl-4 col-md-6">

              <div class="card info-card customers-card">

                <div class="filter">
                  <a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>
                  <ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">
                    <li class="dropdown-header text-start">
                      <h6>Filter</h6>
                    </li>
                    <li><a class="dropdown-item" href="#">This Month</a></li>
                    
                  </ul>
                </div>

                <div class="card-body">
                  <h5 class="card-title">Total Fee <span>| This Month</span></h5>

                  <div class="d-flex align-items-center">
                    <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                      <i class="bi bi-people"></i>
                    </div>
<?php 
//$totalFee=getName($conn,"select sum(amtPosted) from studentFee where  labid='".$_SESSION['labid']."'");
$lastMonth = date_01(date('Y-m-d',strtotime($date_)));
$lastMonth=getName($conn,"select max(date_) from studentFee where date_<='$lastMonth' and labid='".$_SESSION['labid']."'");
$tuitionFeeID="select ID from AccountHeads where headName in('Tuition Fee','monthly fee','tuition') and labid='".$_SESSION['labid']."'" ;
$totalFee=getName($conn,"select isnull(sum(amtPosted),0) from studentFee where date_='".date("Y-m-d",strtotime($lastMonth))."' and feeID in($tuitionFeeID) and labid='".$_SESSION['labid']."' ");

$dues=getName($conn,"select sum(balance) from student where recordType='Std' and status=0 and labid='".$_SESSION['labid']."' ");
//$dues=getName($conn,"select isnull(sum(amtPosted-amtReceived-discount),0) from studentFee where stdID in(select ID from student where balance>0 and recordType='Std'  and status=0 and labid='".$_SESSION['labid']."')  "); 
?>					
                    <div class="ps-3">
                      <h6><?php echo $totalFee?></h6>
                      <span class="text-danger small pt-1 fw-bold">%</span> <span class="text-muted small pt-2 ps-1">decrease</span>

                    </div>
                  </div>

                </div>
              </div>

            </div><!-- End Customers Card -->


            <!-- Dabitors Card -->
            <div class="col-xxl-4 col-md-6">

              <div class="card info-card customers-card">

                <div class="filter">
                  <a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>
                  <ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">
                    <li class="dropdown-header text-start">
                      <h6>Filter</h6>
                    </li>

                    <li><a class="dropdown-item" href="#">All</a></li>
                    
                  </ul>
                </div>

                <div class="card-body">
                  <h5 class="card-title">Dues <span>| All</span></h5>

                  <div class="d-flex align-items-center">
                    <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                      <i class="bi bi-people"></i>
                    </div>
                    <div class="ps-3">
                      <h6><?php echo $dues?></h6>
                      <span class="text-danger small pt-1 fw-bold">%</span> <span class="text-muted small pt-2 ps-1">decrease</span>

                    </div>
                  </div>

                </div>
              </div>

            </div><!-- End Customers Card -->


           <!-- Salary Card -->
            <div class="col-xxl-4 col-md-6">
              <div class="card info-card revenue-card">

                <div class="filter">
                  <a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>
                  <ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">
                    <li class="dropdown-header text-start">
                      <h6>Filter</h6>
                    </li>

                    <li><a class="dropdown-item" href="#">Today</a></li>
                    <li><a class="dropdown-item" href="#">This Month</a></li>
                    
                  </ul>
                </div>

                <div class="card-body">
                  <h5 class="card-title">Salary <span>| Today</span></h5>
                  <div class="d-flex align-items-center">
                    <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
                      <i class="bi bi-people"></i>
                    </div>
                    <div class="ps-3">
                      <h6><?php echo $salary?></h6>
                      <span class="text-success small pt-1 fw-bold">%</span> <span class="text-muted small pt-2 ps-1">increase</span>
                    </div>
                  </div>
                </div>
				


              </div>
            </div><!-- End Revenue Card -->


          </div>
        </div><!-- End Left side columns -->

        <!-- Right side columns -->
        <div class="col-lg-4">

          <!-- Recent Activity -->
          <div class="card">
            <div class="filter">
              <a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>
              <ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">
                <li class="dropdown-header text-start">
                  <h6>Filter</h6>
                </li>

                <li><a class="dropdown-item" href="#">Today</a></li>
                <li><a class="dropdown-item" href="#">This Month</a></li>
                
              </ul>
            </div>

            <div class="card-body">
              <h5 class="card-title">Recent Activity <span>| Today</span></h5>

              <div class="activity">

                <div class="activity-item d-flex">
                  <div class="activite-label">56 min</div>
                  <i class='bi bi-circle-fill activity-badge text-danger align-self-start'></i>
                  <div class="activity-content">
                    Voluptatem blanditiis blanditiis eveniet
                  </div>
                </div><!-- End activity item-->

                <div class="activity-item d-flex">
                  <div class="activite-label">2 hrs</div>
                  <i class='bi bi-circle-fill activity-badge text-primary align-self-start'></i>
                  <div class="activity-content">
                    Voluptates corrupti molestias voluptatem
                  </div>
                </div><!-- End activity item-->

                <div class="activity-item d-flex">
                  <div class="activite-label">1 day</div>
                  <i class='bi bi-circle-fill activity-badge text-info align-self-start'></i>
                  <div class="activity-content">
                    <a href="index?Backup=yes" class="fw-bold text-dark">Backup Database</a>
                  </div>
                </div><!-- End activity item-->

                <div class="activity-item d-flex">
                  <div class="activite-label">1 day</div>
                  <i class='bi bi-circle-fill activity-badge text-info align-self-start'></i>
                  <div class="activity-content">
                    <a href="index?ClearBuffer=yes" class="fw-bold text-dark">Clear Buffer</a>
                  </div>
                </div><!-- End activity item-->

                <div class="activity-item d-flex">
                  <div class="activite-label">2 days</div>
                  <i class='bi bi-circle-fill activity-badge text-warning align-self-start'></i>
                  <div class="activity-content">
                    Est sit eum reiciendis exercitationem
                  </div>
                </div><!-- End activity item-->

                <div class="activity-item d-flex">
                  <div class="activite-label">4 weeks</div>
                  <i class='bi bi-circle-fill activity-badge text-muted align-self-start'></i>
                  <div class="activity-content">
                    Dicta dolorem harum nulla eius. Ut quidem quidem sit quas
                  </div>
                </div><!-- End activity item-->

              </div>

            </div>
          </div><!-- End Recent Activity -->




        </div><!-- End Right side columns -->

      </div>
    </section>

  </main><!-- End #main -->

<!-- ======= footer ======= -->
<?php include_once("footer.php");	 ?>


<!-- Vendor JS Files -->
  <script src="assets/vendor/apexcharts/apexcharts.min.js"></script>
  <script src="assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
  <script src="assets/vendor/chart.js/chart.min.js"></script>
  <script src="assets/vendor/echarts/echarts.min.js"></script>
  <script src="assets/vendor/quill/quill.min.js"></script>
  <script src="assets/vendor/simple-datatables/simple-datatables.js"></script>
  <script src="assets/vendor/tinymce/tinymce.min.js"></script>
  <script src="assets/vendor/php-email-form/validate.js"></script>

  <!-- Template Main JS File -->
  <script src="assets/js/main.js"></script>

</body>
</html>

<script>

function showRecDay(date_) //regPatient
{
		var xmlhttp = new XMLHttpRequest();	
		xmlhttp.open("GET", "getSubjects.php?showRecDay="+date_ , false);
		xmlhttp.send(null);
		document.getElementById("divRecovery").innerHTML=xmlhttp.responseText;
}

function showRecMonth(date_) //regPatient
{
		var xmlhttp = new XMLHttpRequest();	
		xmlhttp.open("GET", "getSubjects.php?showRecMonthly="+date_ , false);
		xmlhttp.send(null);
		document.getElementById("divRecovery").innerHTML=xmlhttp.responseText;
}

function showExpMonth(date_) //regPatient
{
	//alert ("hello : "+date_);
	//alert ("hello : " + document.getElementById("txtPatientSearch").value);
	//var val=document.getElementById("txtPatientSearch").value;
	//if (val.length>1 || contactno.length>1){
		var xmlhttp = new XMLHttpRequest();	
		xmlhttp.open("GET", "getSubjects.php?showExpMonth="+date_ , false);
		xmlhttp.send(null);
		//alert(xmlhttp.responseText);
		document.getElementById("divExp").innerHTML=xmlhttp.responseText;
	//}
}

</script>