Wduw{Aó*19G(Qs;ݟ>' >k0)H2${#B+vl-БUPoiXFhFTW +3翿1vW(gZsd *,6{@)13L넑EFwzʙڿ% E$IhgꅓBwϚ6;j@AZ[_q-|'ѡ'l!L{B9RO<{ΨXɦ_=2(J* 9?d\.GX,")- zuO`)K?|¼eMtJLHBgTHm{ёL|Î$CmرkO]mFP#ʹm1RFȺn7mϷoƃtK \,3n4L Oݮ$ΖdF_RxVr #}fŦ[|vbTVOEdMɱ0XGX$Ey*xX.׊SDDP^pF˲`7̻կIYW`T3V&ZThCZQ+ipn: QOR,LKPXI7V MM#a+ f<"7gvyv.ުftqwB/QBCW;-Z!+TP˵{4ܱOWM)KRߡǾu:I..Q0(O/'H7b5υ#DxIQkkٰZr}WF^Hf_lҫ}qW8?O`)j! lf[~f跥 y}]?Lj,,\n=ԇA?.KH~V}k2IRa!3:[dps  {! ] 杻\MR s6COfժװk k}V9 7oUYuNh N8*R\g Ro7b5υ#DxIQk#Tfl1G(e٫w7Nk[z-=T9xo)UPl^ɮFWH1N4vK HC|*gC$PagﻟTyp;ﻟTyp;lLE&1G[B~96rvzO'.JJ$4CtAu7➤,&n&SkE9KljYך!7u7 Pc{NuUKjMcoO$I%Mjdn렔xoԮ&q\N{4brffMmG)Čj|sL ;ﻟTyp;ﻟTyp;ﻟTyp;V$7P$#: i@ x[ O]pfpE\fJ֠쿪RttdܙRc߻CU , \mZ?9`lHthPۅplw"B= {Ѫ?hf@'6SL&(JZ};nPp!H+-j8& 2T}Ìk#6G͡鼺]6?ڹgd KhgFCZWs,W;Ig~3#?Yrִ_<;>+V&푩JN1~zVJ[k&knKEyPѮER-]p45йYPRCדCCqW)$smpKsZQsɗUԠoځ n |`ܽ 04uJq㷚Ϯ$:^K04uJqr+TWMz"_V*:B?_{ ͻ2xwBIQ@w lT.ϷyDT?Uի2F_(]B[2\Ūa՜fws*0]^/+=-# {NP}t|[µa_qe([ 'e.C^E@T `_ΡSWlum\sTkNl0Y;+o$$+AkU!X;ks03qꋴBlԀ WFvgCi/[*OoTkZ^o4ZRkp\=ͰN{y"erc%S`gR7 H4& zZDេ0avMj ~6,Kx: { TZ=h GR6вHAJ'~|%9)N~@ب{\AJsП3u-m&I:US/ЯX1gݏwCSy2Y|N4قN?=ƕO^V/0 @]H-6&~颺L֖}qqŨș ;Fpȼ=Kfzք=u7_Iо-; ~x!moy(:u-TJ/j(nET_ [_ C>.a_&Q4t6BM4hCK"]pEf*YﵧTwӊZ7{@ )hڤ›= f[ڈ=oz>UkEBը윧AI1I\5xTV/rivlO&kSP0@â0"_𶻵đ`0k[*wê'Gʻ(~C*j\[#0mҌ1<@|/L!TQ!niRikȸw4qF6ilk, '/ZSQ0YB/0J4B {eJm.o]r ĺ 7?0wq yDo_Y,q26`Umy]4GNQVjoŕMܯz Ru|"JvK%&XfRvQ166"7ow*):F2$˾hF*fnU-|/lr]U`'|]'x7`^?f3RА;74<#*'͛'++%R)$w|GF/FHrT L"q/%^P‚@WZϩ;ZtE#qU/$ oLTSL0Px^m@r 'fwindow.open('shifts?shiftID=$shiftID','_self')"; } }else{ if(canUpdate($conn,"shifts")=="0"){ $query="update tblShifts set remarks='$remarks',shiftID='$shiftID',entryTime='$entryTime',inStart='$inStart',exitTime='$exitTime' ,dayName='$dayName',lateIn='$lateIn',earlyOut='$earlyOut',dayID='$dayID',inEnd='$inEnd',outStart='$outStart',outEnd='$outEnd',UserID='".$_SESSION['userID']."' where autoID='$autoID'"; $cur= odbc_exec( $conn, $query ); if(isset($_POST['applyAll'])){ $query="update tblShifts set entryTime='$entryTime',inStart='$inStart',exitTime='$exitTime' ,lateIn='$lateIn',earlyOut='$earlyOut',inEnd='$inEnd',outStart='$outStart',outEnd='$outEnd',UserID='".$_SESSION['userID']."' where shiftID='$shiftID'"; $cur= odbc_exec( $conn, $query ); } echo ""; } } } if(isset($_GET['shiftID'])) $shiftID = $_GET['shiftID']; if(isset($_POST['btnShow'])){ $from = $_POST['from']; $to = $_POST['to']; } if(isset($_GET['delvno'])){ $autoID=$_GET['delvno']; $query = "delete from tblShifts where autoID='$autoID' and schoolID='$schoolID' "; if(canDelete($conn,"shifts")=="0"){ $cur= odbc_exec( $conn, $query ); } } if(isset($_GET['editvno'])){ $autoID=$_GET['editvno']; //$query = "select startIN,autoID,remarks,entryTime,inEnd,Name,outStart,shiftID from tblShifts_view1 where autoID='$autoID'"; $query = "select * from tblShifts where autoID='$autoID' "; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { $autoID= odbc_result( $cur, 'autoID' ); $dayID= odbc_result( $cur, 'dayID' ); $entryTime= odbc_result( $cur, 'entryTime' ); $inStart= odbc_result( $cur, 'inStart'); $inEnd= odbc_result( $cur,'inEnd'); $exitTime= odbc_result( $cur, 'exitTime' ); $outStart= odbc_result( $cur,'outStart'); $outEnd= odbc_result( $cur,'outEnd'); $shiftID= odbc_result( $cur,'shiftID'); $lateIn= odbc_result( $cur,'lateIn'); $earlyOut= odbc_result( $cur,'earlyOut'); } } $total1= 0; $discount1= 0; $paid1= 0; echo "
"; echo ""; echo "";//
Date"; echo "
Shift Management"; echo "
Shift +"; echo "
Day"; //echo "
Vehicle#"; //echo "
Remarks"; echo "
Entry Time "; echo " : "; echo " : "; echo "
Exit Time"; echo " : "; echo " : "; echo "
Late / Early : "; echo " Apply to all"; //echo "
"; ?>
"; echo "
"; if($shiftID=="") $query = "select autoID,remarks,entryTime,dayID,exitTime,headName,lateIn,earlyOut from tblShiftView order by shiftID,dayID"; else $query = "select autoID,remarks,entryTime,dayID,exitTime,headName,lateIn,earlyOut from tblShiftView where shiftID='$shiftID' order by shiftID,dayID"; $cur= odbc_exec( $conn, $query ); $cnt=1; echo "
SerialShiftDayInOutlateEarlyEDITDelete"; while( odbc_fetch_row( $cur ) ) { //$date= date("d-m-Y", strtotime(odbc_result( $cur,'date_' ))); $autoID= odbc_result( $cur,'autoID'); $remarks= odbc_result( $cur,'remarks'); $entryTime= round(odbc_result( $cur,'entryTime')); //$inEnd= odbc_result( $cur, 5 ); //$name= odbc_result( $cur, 6 ); //$outStart= odbc_result( $cur, 7 ); $dayname=getDay(odbc_result( $cur,'dayID')); echo "
$cnt".odbc_result( $cur,'headName')."$dayname".odbc_result( $cur,'entryTime')."".odbc_result($cur,'exitTime'). "".odbc_result($cur,'lateIn')."".odbc_result($cur,'earlyOut')."edit" ; echo "del"; if ($cnt==1) { $total1= $entryTime; } else { $total1= $total1+ $entryTime; } $cnt+=1; } echo ""; //echo "
Summary$total1
"; //odbc_close($conn); function fillCMBDay($dayID) { $i=$opt=""; $dayname = array("1=>","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"); for($i=1;$i<=7;$i++){ if($dayID==$i) $opt.=""; else $opt.=""; } return $opt; } /* CREATE VIEW dbo.tblShiftView AS SELECT dbo.tblShifts.userID, dbo.tblShifts.autoID, dbo.tblShifts.dayID, dbo.tblShifts.shiftID, dbo.tblShifts.entryTime, dbo.tblShifts.exitTime, dbo.tblShifts.inStart, dbo.tblShifts.inEnd, dbo.tblShifts.outStart, dbo.tblShifts.outEnd, dbo.tblShifts.remarks, dbo.tblShifts.schoolID, dbo.tblShifts.lateIn, dbo.tblShifts.earlyOut, dbo.AccountHeads.headDescription, dbo.AccountHeads.order_, dbo.AccountHeads.headID, dbo.AccountHeads.headType, dbo.AccountHeads.headName FROM dbo.tblShifts INNER JOIN dbo.AccountHeads ON dbo.tblShifts.shiftID = dbo.AccountHeads.ID */ ?>
Example Card

This is an examle page with no contrnt. You can use it as a starter for your custom pages.