2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZhosd *,6{@)13L넑^<}؏5(8!vͳg^~Y*u I(o0 =J4y%%;w a+N Y($)54XH% }AJh(e2b6EUSv'|9 [Z }65.w˃9ظY+/[qJyQ´Ky5qg&& lװ8hc3gMM֠N Ő-X\ &ʺ_ۺ [NhQP|W:Uj~@t44y Ź4km(G`42ؕ1tzqa[̺[D\uk螌Gt 4 ~۪y5V~ ǹhm0u|aד)eVU1pO-KZDQYrK_Ba0ͱR`cc)uzrŃMǗj *mNhs*^X0Mp{i])'a.՞#`b493ާ/FգrFbsoY01\Zo|:-r7ʎLҞ\ga$|R4^`D٭a$47Otu]gm56 % m($ߟ .Gy1H 'SDzoviR~gAbʯ;ЦHg\bQv)5SXoMp[ A! FW=4wJ:N >F)ǰX>Î9x-o-\NcL3z{+KA\[^`r֣1 +Dzw?d{8zVφ;ԏK.#\P4`GU R2˚T(._dE#5)[0j CQpSOvȵxLY`и n'ͯuyiyx'ku1,}RJ7To {U R2˚T(.**q7T١]d i LX3O]\@Q432MU}Me,6f$ѡ B7<\AC]g`AV4Ƀb0~Nk O==/M4&Bb>T{`ԧ@KE̮I o\/Ya>62F$layȷn+ytL|xt =&NS& U֖wgͿ ۔G䆴 OzIF7Z7.&5S&yni3QｈnXż0*_<[XZjWa$x}0e!h׬_7M,my>Kȉb`0/n)$!Rfy"q>\Se)Mfv͡9I}EoP 3<[Vfwd(MzgioȘ9˞2d}C3-S㹧z\*U[PEȻ1!}fU_̶-v$U_=D[Y0>2b9}(Wy#N!U76=v?<7 a$L_nX$-wX^N`!%#`A;q GB(B]T=ӦhA$!n“PV/C:uyb/u5 -{jnEBVb*d"$,zn%!ejuX11 tG% 9P l+ٓVf:J.G ".round($percentage).""; /* echo ""; $adminAnswer=getName($conn,"select adminAnswer from staffAssesment where empID='$empID' and date_='$date_' and questionID='$questionID' "); if($adminAnswer=='1') echo " YES No Null"; elseif($adminAnswer=='0') echo " YES No Null"; else echo " YES No Null"; */ $marks=getName($conn,"select marks from staffAssesment where empID='$empID' and date_='$date_' and questionID='$questionID' "); echo ""; $marks=getName($conn,"select marksAdmin from staffAssesment where empID='$empID' and date_='$date_' and questionID='$questionID' "); echo ""; $adminRemarks=getName($conn,"select adminRemarks from staffAssesment where empID='$empID' and date_='$date_' and questionID='$questionID' "); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $cnt+=1; } } $marks=getName($conn,"select headName from feeHeads where ID='$questionID' "); //symbol/marks $percentage=getName($conn,"select sum(percentage) from staffAssesment where empID='$empID' and questionID='".$questionID."' and (Date_ BETWEEN '$from' AND '$to')"); if($percentage>1){ $answer=$percentage*$marks/100; }else{ $qry="select count(*) from staffAssesment where answer in(0,1) and empID='$empID' and questionID='".$questionID."' and (Date_ BETWEEN '$from' AND '$to')"; $total=getName($conn,"select count(*) from staffAssesment where answer in(0,1) and empID='$empID' and questionID='".$questionID."' and (Date_ BETWEEN '$from' AND '$to')"); if($total>0){ $yes=getName($conn,"select count(*) from staffAssesment where answer=1 and empID='".$empID."' and questionID='".$questionID."' and (Date_ BETWEEN '$from' AND '$to')"); $percentage=$yes*100/$total; $answer=$percentage*$marks/100; }else{ $answer=0; } } echo "Marks".round($answer).""; echo ""; exit(); } if(isset($_POST['btnShow'])){ $amount = $_POST['amount']; $block = $_POST['block']; $ret=addHead($conn,$amount,'MonthlyAllowance') ; $from = date('Y-m-d',strtotime($_POST['from'])); $to = date('Y-m-d',strtotime($_POST['to'])); }else{ $block=getName($conn,"select block from employee where empID='$empID'"); } if(isset($_POST['btnSave'])){ $empID = $_POST['empID']; $cnt = $_POST['cnt']; $proforma = $_POST['proforma']; $date_ = date('Y-m-d',strtotime($_POST['date_'])); for ($i=1; $i<$cnt; $i++) { $questionID = "questionID$i"; $questionID = $_POST[$questionID]; $answer = "answer$i"; $answer = $_POST[$answer]; $description = "description$i"; $description = $_POST[$description]; $percentageFormula = "percentageFormula$i"; $percentageFormula = $_POST[$percentageFormula]; if($percentageFormula<>""){ $arr=explode("/",$percentageFormula); if(count($arr)>1) $percentage=$arr[0]*100/$arr[1]; else $percentage=$percentageFormula; }else{ $percentage ="";// $_POST[$percentage]; } $description = iconv("UTF-8", "Windows-1252", $description); $query="delete from staffAssesment where empID='$empID' and questionID='$questionID' and date_='$date_' "; $cur= odbc_exec($conn,$query ); $query="insert into staffAssesment(userID,percentageFormula,percentage,empID,date_,questionID,answer,description) values('".$_SESSION['UserID']."','$percentageFormula','$percentage','$empID','$date_','$questionID','$answer',N'$description')"; //echo "
".$query; $cur= odbc_exec( $conn, $query ); } } if(isset($_POST['btnSaveChanges'])){ $empID = $_POST['empID']; $cnt = $_POST['cnt']; $proforma = $_POST['proforma']; $date_ = date('Y-m-d',strtotime($_POST['date_'])); for ($i=1; $i<$cnt; $i++) { $questionID = "questionID$i"; $questionID = $_POST[$questionID]; $adminAnswer = "adminAnswer$i"; $adminAnswer = $_POST[$adminAnswer]; $adminRemarks = "adminRemarks$i"; $adminRemarks = $_POST[$adminRemarks]; $query="update staffAssesment set adminAnswer='$adminAnswer',adminRemarks='$adminRemarks',userID='".$_SESSION['UserID']."' where empID='$empID' and questionID='$questionID' and date_='$date_' "; //echo "
".$query; $cur= odbc_exec( $conn, $query ); } } if(isset($_POST['btnDelete'])){ $date_ = date('Y-m-d',strtotime($_POST['date_'])); $query = "delete from staffAssesment where empID='$empID' and date_='$date_' "; $cur= odbc_exec( $conn, $query ); } if(isset($_POST['btnShowDayValue'])){ $from=$to=$date_=date('Y-m-d',strtotime($_POST['date_'])); //$query = "select * from staffAssesment where empID='$empID' and date_='$date_' "; //$cur= odbc_exec( $conn, $query ); } if(isset($_POST['btnShowDayValue'])){ $from=$to=$date_=date('Y-m-d',strtotime($_POST['date_'])); $empID=$_POST['empID']; } ?>
"; echo ""; echo ""; echo ""; echo ""; $cnt++; } echo ""; echo ""; // // ?>
STAFF ASSISTMENT DAILY
Date "; echo ""; echo fillCMB($conn,$empID,"select distinct empID,empname from employee where status=1 order by empname"); echo " "; ?>
Add Questions (+)Yes/No(20/25)%ageDescriptionAdmin (Y/N) Admin Remarks ".odbc_result($cur,'description').""; $answer=getName($conn,"select answer from staffAssesment where empID='$empID' and date_='$date_' and questionID='".odbc_result($cur,'ID')."' "); $description=getName($conn,"select description from staffAssesment where empID='$empID' and date_='$date_' and questionID='".odbc_result($cur,'ID')."' "); if($answer=='1') echo " YES No Null"; elseif($answer=='0') echo " YES No Null"; else echo " YES No Null"; $percentage=getName($conn,"select percentage from staffAssesment where empID='$empID' and date_='$date_' and questionID='".odbc_result($cur,'ID')."' "); $percentageFormula=getName($conn,"select percentageFormula from staffAssesment where empID='$empID' and date_='$date_' and questionID='".odbc_result($cur,'ID')."' "); echo "".round($percentage).""; $adminAnswer=getName($conn,"select adminAnswer from staffAssesment where empID='$empID' and date_='$date_' and questionID='".odbc_result($cur,'ID')."' "); $adminRemarks=getName($conn,"select adminRemarks from staffAssesment where empID='$empID' and date_='$date_' and questionID='".odbc_result($cur,'ID')."' "); if($adminAnswer=='1') echo " YES No Null"; elseif($adminAnswer=='0') echo " YES No Null"; else echo " YES No Null"; echo "
Block "; ?> From : To : Amount
""){ if(count($ids)>0){ for($x=0;$x
S.#QuestionMarks"; for($y=0;$y".$empname; $totalall[$y]=0; } } $marks=getName($conn,"select headName from feeHeads where ID='".$questionids[$x]."' "); //symbol/marks $totalmarks1[$x]=$marks; echo "
".($x+1)."".$questions[$x]."".$totalmarks1[$x]; for($y=0;$y1){ //$answer=getName($conn,"select sum(percentage) from staffAssesment where empID='".$ids[$y]."' and questionID='".$questionids[$x]."' and (Date_ BETWEEN '$from' AND '$to')"); $answer=$percentage*$totalmarks1[$x]/100; }else{ $qry="select count(*) from staffAssesment where answer in(0,1) and empID='".$ids[$y]."' and questionID='".$questionids[$x]."' and (Date_ BETWEEN '$from' AND '$to')"; $total=getName($conn,"select count(*) from staffAssesment where answer in(0,1) and empID='".$ids[$y]."' and questionID='".$questionids[$x]."' and (Date_ BETWEEN '$from' AND '$to')"); if($total>0){ $yes=getName($conn,"select count(*) from staffAssesment where answer=1 and empID='".$ids[$y]."' and questionID='".$questionids[$x]."' and (Date_ BETWEEN '$from' AND '$to')"); $percentage=$yes*100/$total; $answer=$percentage*$totalmarks1[$x]/100; }else{ $answer=0; } } //echo "".$questionids[$x]."=($yes/$total)".round($answer); */ $answer=getName($conn,"select sum(marksAdmin) from staffAssesment where empID='".$ids[$y]."' and questionID='".$questionids[$x]."' and (Date_ BETWEEN '$from' AND '$to')"); echo "".round($answer).""; //$total1+=$answer; $totalall[$y]+=$answer; } //$totalall[$x]=$total1; } echo "
Summary"; $total1=$obtMarksTotal=0; for($x=0;$x".$total1; for($y=0;$y".round($totalall[$y]); //$obtMarksTotal+=$totalall[$y]; } // echo "
Days"; $tdays=getName($conn,"select count(distinct date_) from staffAssesment where (Date_ BETWEEN '$from' AND '$to')"); echo "".$tdays; for($y=0;$y".$days." %:".round($per); $totalall[$y]+=$per; } //add days marks $obtMarksTotal=0; echo "
Total Marks"; $tdays=getName($conn,"select count(distinct date_) from staffAssesment where (Date_ BETWEEN '$from' AND '$to')"); echo "".$tdays; for($y=0;$y".round($totalall[$y]); $obtMarksTotal+=$totalall[$y]; } echo "
Allowance"; echo "".$amount; for($y=0;$y".round($totalall[$y]/$obtMarksTotal*$amount); } echo "
"; } } /* $ids=getName($conn,"select distinct empid from staffAssesment where (Date_ BETWEEN '$from' AND '$to') order by empID"); $questions=getName($conn,"select description from feeHeads where headType='staffQuestions' order by order_"); $questionids=getName($conn,"select ID from feeHeads where headType='staffQuestions' order by order_"); //echo "cnt=".count($questions); for($x=0;$x
S.#Name"; for($y=0;$y".$questions[$y]; } echo "
Total Days"; for($y=0;$y".$answer; } } $empname=getName($conn,"select empname from employee where empID='".$ids[$x]."' "); echo "
".($x+1)."".$empname; for($y=0;$y".$answer; } } echo "
"; if ($x==1) echo "No Record Found"; */ odbc_close($conn); ?>