2-;R$?1祧Wgբv~ar$qj8NSl"2#n\|P-j>ub}r]oP0̰Mc{8M6rS)SPEJ8-<ǻ]3 #!HXV)}~ n? 0:ޠGօ\4c˄iEbqhN&.lz0gJ2Q ,F/K:qbpb?- 3g1#Y< !~oM)t)%S%%#IvFkNHS/u2dDEuj1CGX;id?7NGJ,jsCjzkNQXɚ|ɸ=d.beQiZ jȳM+_,`.=M4{-cê1!xQI5L#\J Pv38G~ 0f]jҮ6.a˸IB@81Yªj< a@P9ϛ)0ȲH(®?i( *g?Yո=E $iTɥ,$I U%-PU/ɒF{@i\MXv#(qI my~g}ފXٜRqrT#kt + Q[Q6,Y_e|xN󕏑- ]m>R)l5q6VhaJRhy3lϷt u3u^YOo'@NfOh9GW=ӉT4`uH~D$Gk SWDѩ27M!#ϽWSya'ĶZ5in))rCC?K.wP3a)| (+<f84Pnf^{GQ-%TZGvnr8*xf Z]H<2$J1X' o憅:=)mXݗ}W"- 2, Ʒ$d?'?􃎣NP轪SjIKF6wh)g% -8ʲDM ΄_I0z;fYB:lMgNTFAzLVm tIoY"-)> t&bûLT!y{7jx w‹$=b躁#g,;HT1Spx\fh.:RVjq|W 6rP-KS%(|b0fqm#՟Շ]57X~sҶ&-!G9RS _{;UĈH =8=U[Np.yYe`)6vB)y {:n  ٨|R7Þ`ǯRF]vq>gbYiVՌ}3*4% +V~E>/bהrwF_9Uh݋]|XwgL=e:g:Qd!F-$dj/Ƈ#/]桭8ݫ3[eV\ɓkP\.\Nrq;X5}ۀjv Ҿ%b/!E׎HaF/fj;i+3f pX6<آ?1qz]Uu)})c#PLhULAN2UE?P!M i%8vlG Nbf4|̔$3S?7}1| ð4ڐR-` X$ }6sf»Oٱ[=kK^pE<7;rUKJjr bw݃W[&l mr(jog1v6Ȓnz%%I _ve-ӢQϼXZe%> Q ?;سw\)`+P L<IѮ}pYZP'gyTMuR>vV~j0&?KqN.6 оyYKj-C 'z_ev%tO v㛏 sD*% jiT1] ` fJYPjB4j+ߓ/Z_mpa^)NBDLJs YEmV9\LR^%,`ˎ 6Fc+h9ybԉ;L^ǒJZbK߸ گ~P%DQE6<cm/S{!_N  YJܟV؝z.߮ GRej[ͦ0vb5p6<`Wn ޯ#5K.>M;(X󐽝&ڎx%i)z_q=^ '7pbp0+Gbh)L*DɃ-;\cy&({ p<E[n=HjP<|˻gbukk&-=6W;)S0XO;#U/kuj)jI&½켌:.S}< n]pRK 8=:jxhH.%I2~G8o[̠iw<-4ee\;w0qWtD{(8[˜Ek'W?_ ϒ`X <:iQܱQ,nz"L4A(  N?=ƕq ӗ&ixŨ7\Z-5b=& JJJSAPqӁ`He)*C.z<-wY8/_dE#5)[0v+iӜZ&4c'/.x aߒgOYvoX&v{WZ{θj1"_z44˜:̜8]fЪjF "k LdYBE:|ٛ+^-D9:+j[3'Mk ;Y+ן qa8R!Ej!΅q3;b5pyu 7^sMdMS A$uz&! PQ3ߋfѴ_5ӷ]T)P`QeBhcL̚pv@]hШ;NP?GX$F10ŵяF#E0Ee,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')."" ; echo ""; 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; } function getDay($dayID) { $dayname = array("1=>","Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"); return $dayname[$dayID]; } /* 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 */ ?>