Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
TarkaFormatStyles.php	10.35 KB	-rwxr-xr-x
batch_wise_details.php	13.44 KB	-rwxr-xr-x
custom_mregistry.php	3.17 KB	-rwxr-xr-x
dash_board.php	1.38 KB	-rwxr-xr-x
error_message.ini	2.73 KB	-rwxr-xr-x
evaluation.php	15.84 KB	-rwxr-xr-x
execute_query.php	754 B	-rwxr-xr-x
freeze_marks.php	4.7 KB	-rwxr-xr-x
getMapAtEmployeeIdQuery.php	4.24 KB	-rwxr-xr-x
getRightValuesForLoggedinUser....	2.26 KB	-rwxr-xr-x
get_fm_emp_list.php	3.19 KB	-rwxr-xr-x
get_search_conditon.php	2.03 KB	-rwxr-xr-x
ggridGetQuery.php	1.55 KB	-rwxr-xr-x
month_year.php	2.59 KB	-rwxr-xr-x
parseini.php	777 B	-rwxr-xr-x
practical_entry_freezing witho...	9.3 KB	-rwxr-xr-x
practical_entry_freezing.js	12.07 KB	-rwxr-xr-x
practical_entry_freezing.php	12.11 KB	-rwxr-xr-x
practical_entry_freezing_02112...	11.73 KB	-rwxr-xr-x
practical_entry_freezing_91120...	12.14 KB	-rwxr-xr-x
practical_entry_freezing_new.p...	10.39 KB	-rwxr-xr-x
practical_marks_details.php	11.53 KB	-rwxr-xr-x
practical_marks_details22.php	10.14 KB	-rwxr-xr-x
practical_marks_misc.php	10.02 KB	-rwxr-xr-x
report_practical_misc.php	5.76 KB	-rwxr-xr-x
report_setup.php	86.43 KB	-rwxr-xr-x
transactions.php	50.14 KB	-rwxr-xr-x
user_report.php	6.21 KB	-rwxr-xr-x

Code Editor : practical_entry_freezing_9112017.php

<?php 
function getPracticalEntryFreezeDetails($aobj_context)
{
	session_start();	
	$college_code = $_SESSION['collcode'];
	$user_type = $_SESSION['user_type'];
	 
	$aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
	$subject_code = $aobj_context->mobj_data["subject_code"]; 	
    $degree = trim($aobj_context->mobj_data["degree_code"]); 	
    $exam_no = trim($aobj_context->mobj_data["exam_no"]);     
    $subject = trim($aobj_context->mobj_data["subject"]);     
    $g_freeze_time = trim($aobj_context->mobj_data["g_freeze_time"]);  
	
	 
	$get_subject = " select  s.FDEGREE,s.FEXAMNO,s.FSUBCODE,s.FBATCH,ifnull(pf.fintexamcode,'') as fintexamcode,ifnull(pf.fextexamcode,'') as fextexamcode,
				ifnull(pf.fbatchcnt,'') as fbatchcnt,ifnull(pf.fpresent,'') as fpresent,ifnull(pf.fchief,'') as fchief,
				ifnull(pf.fclerk,'') as fclerk,
				ifnull(pf.fgroup,'') as fgroup,
				ifnull(pf.fsession,'') as fsession,
				ifnull(ffreezed,'F') as FFREEZED,
				ifnull(PRINTFREEZED,'F') as PRINTFREEZED,
				GROUP_CONCAT(distinct  if(abs(FMarks11)<1,0,abs(FMarks11)) separator '') as tot_marks,	
				pf.FBATCH as freezed_batch,date_format(ifnull(pf.FEXAMDATE,'00/00/0000'),'%d/%m/%Y') as FEXAMDATE,pf.FEXAMTIME 
				from marks_pr  s  inner join  subject sub 
				on s.FDEGREE=sub.FDEGREE and s.FEXAMNO=sub.FEXAMNO and s.FSUBCODE=sub.FCSUBCODE
				left join practical_entry_freeze pf
				on pf.FDEGREE=s.FDEGREE and pf.FEXAM=s.FEXAMNO and pf.FCSUBCODE=s.FSUBCODE 
				and pf.FCOLLCODE=s.FCOLLCODE
				and lpad(s.FBATCH,2,'0')=lpad(pf.FBATCH,2,'0')
				where  s.fdegree =  '{$degree}'				   
				and  s.fexamno='{$exam_no}'
				and  s.FSUBCODE='{$subject}'
				and s.FCOLLCODE='{$college_code}' and s.FBATCH>0
				group by s.FDEGREE,s.FEXAMNO,s.FSUBCODE,s.FBATCH ";
				   
	$obj_get_details = $aobj_context->mobj_db->GetAll($get_subject);	
	$col_span=7;
    if($g_freeze_time=='TIMETABLE')
	$col_span=4;
	 
	   	$e_data.="<table  width='90%'  class='tr_ventor_row' align='center' cellspacing='0' cellpadding='0' border='0' >";
		$e_data.="<th align='left' colspan='{$col_span}' class='ui-jqgrid-titlebar ui-widget-header ui-corner-tl ui-corner-tr ui-helper' style='font-size:12px; padding-left:6px; height:22px;'>Practical Entry Freeze Details </th>";		
		$e_data.="<tr  class='ui-state-default ui-jqgrid-hdiv'>";
		$e_data.="<td  align=center style='padding:2px; width:24px; border-bottom:1px solid #C5DBEC; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; border-bottom:1px solid #C5DBEC;'>Sl No</td>";
		$e_data.="<td align=center  style='padding:2px;  width:60px; border-bottom:1px solid #C5DBEC;border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;  border-bottom:1px solid #C5DBEC;'>Batch</td>";
		$e_data.="<td  align=center style='padding:2px; width:20px; border-bottom:1px solid #C5DBEC; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;  border-bottom:1px solid #C5DBEC;'>Exam Date</td>"; 
		$e_data.="<td  align=center style='padding:2px; width:20px; border-bottom:1px solid #C5DBEC; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;  border-bottom:1px solid #C5DBEC;'>Exam Time</td>"; 
		if($g_freeze_time=='FREEZE')
		{
			$e_data.="<td  align=center style='padding:2px; width:20px; border-bottom:1px solid #C5DBEC; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;  border-bottom:1px solid #C5DBEC;'>Freeze Entry</td>"; 
			$e_data.="<td  align=center style='padding:2px; width:20px; border-bottom:1px solid #C5DBEC; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;  border-bottom:1px solid #C5DBEC;'>Freeze Print</td>"; 
			
			$e_data.="<td  align=center style='padding:2px; width:20px; border-bottom:1px solid #C5DBEC; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC;  border-bottom:1px solid #C5DBEC;'>Print</td>"; 
		}
		$e_data.="</tr>";		
		$sl_no=1;
		for($m=0;$m<count($obj_get_details);$m++)
		{		
			$FSUBCODE=$obj_get_details[$m]['FCSUBCODE']; 
			$FBATCH=$obj_get_details[$m]['FBATCH']; 
			$FEXAMDATE=$obj_get_details[$m]['FEXAMDATE']; 
			$tot_marks=$obj_get_details[$m]['tot_marks']; 
			$FFREEZED=$obj_get_details[$m]['FFREEZED']; 
			$PRINTFREEZED=$obj_get_details[$m]['PRINTFREEZED']; 
			
			$fchief   = $obj_get_details[$m]['fchief']; 
			$fclerk   = $obj_get_details[$m]['fclerk']; 
			$fgroup   = $obj_get_details[$m]['fgroup']; 
			$fsession = $obj_get_details[$m]['fsession'];
			
			$fpresent     = $obj_get_details[$m]['fpresent']; 
			$fbatchcnt    = $obj_get_details[$m]['fbatchcnt']; 
			$fintexamcode = $obj_get_details[$m]['fintexamcode']; 
			$fextexamcode = $obj_get_details[$m]['fextexamcode']; 
			
			 
			$FEXAMTIME=$obj_get_details[$m]['FEXAMTIME']; 
			$freezed_batch=$obj_get_details[$m]['freezed_batch']; 
			 
			$report_link="GenerateBatchWorkSheetsFromLink({$m});"; 
			$fc_checked="";
			
			$fc_print_checked="";
			$diasable = "";
			$fc_print_disabled="disabled=true;";
			if($FFREEZED=="T")
			{
				$report_link="GeneratePracticalMarksReportsFromLink({$m});"; 
				$fc_checked = "checked  disabled=true;";
				$diasable = "disabled";
				if(strtolower($user_type)=='superuser')	
				$fc_checked=" checked";
				if($PRINTFREEZED=="T")
				{
					 
					$fc_print_disabled="disabled=true;";
					if(strtolower($user_type)=='superuser')	
					$fc_print_disabled = "";
				 	$fc_print_checked=" checked";
				}
				else
				{
					$fc_print_disabled = "";
				}
			
			}
				
			if($k%2==0)
			{
				$class='tbl_row';
			}
			else
			{
				$class='tbl_row1'; 
			}  
			 $e_data.="<tr class='ui-widget-content jqgrow'>";
			 $e_data.="<td class='tbl_row_new' align='center' style='width:20px; border-left:1px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' id='batch_sl_no_{$m}'>{$sl_no} 
			 <input type = 'hidden' id= 'fintcode_{$m}' value = '{$fintexamcode}' >
			 <input type = 'hidden' id= 'fextcode_{$m}' value = '{$fextexamcode}' >
			 <input type = 'hidden' id= 'fbatchcode_{$m}' value = '{$fbatchcnt}' >
			 <input type = 'hidden' id= 'fprecode_{$m}' value = '{$fpresent}' >
			  <input type = 'hidden' id= 'fchief_{$m}' value = '{$fchief}' >
			 <input type = 'hidden' id= 'fclerk_{$m}' value = '{$fclerk}' >
			 <input type = 'hidden' id= 'fgroup_{$m}' value = '{$fgroup}' >
			 <input type = 'hidden' id= 'fsession_{$m}' value = '{$fsession}' >
			 </td>";
			 $e_data.="<td class='tbl_row_new' align='center' style='width:50px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' id='batch_{$m}'>{$FBATCH} </td>";
			 if($g_freeze_time=='FREEZE')
			 {
			 $e_data.="<td class='tbl_row_new' align='center'  style='width:100px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' id='date_{$m}'>";			
			 $e_data.=" <div id='input_div_97' class=' imageInputWrapperDate' style='width:120px;'>
						 <input id='practical_entry_freeze_exam_date_{$m}'  class='inputWithImge ElementCount'  type='text' style='background-color:#e1e1e1; width:100px; border:0px;' value='{$FEXAMDATE}' />
						 <script>$('#practical_entry_freeze_exam_date_{$m}').datepicker({showOn: 'button',showButtonPanel: true, changeMonth: true,	changeYear: true,dateFormat:'dd/mm/yy',buttonImage: 'images/date.gif', buttonImageOnly: true});</script>
						 </div></td>";
			 }	
			else
			 {
			 $e_data.="<td class='tbl_row_new' align='center'  style='width:100px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' id='date_{$m}'>";			
			 $e_data.=" <div id='input_div_97' class=' imageInputWrapperDate' style='width:120px;'>
						 <input id='practical_entry_freeze_exam_date_{$m}' {$diasable} class='inputWithImge ElementCount' onkeydown = 'dmydateformat(event,this.id)' maxlength = 10 type='text' style='width:100px; border:0px;' value='{$FEXAMDATE}' />
						 <script>$('#practical_entry_freeze_exam_date_{$m}').datepicker({showOn: 'button',showButtonPanel: true, changeMonth: true,	changeYear: true,dateFormat:'dd/mm/yy',buttonImage: 'images/date.gif', buttonImageOnly: true});</script>
						 </div></td>";
			 }
			 if($g_freeze_time=='FREEZE')
			 {
				$e_data.="<td class='tbl_row_new' align='center'   style=' width:100px; border-right:1px solid #C5DBEC;  padding:2px;'><input type='text'  style='background-color:#e1e1e1;' value='{$FEXAMTIME}' id='time_{$m}'></td>";
			 }
			 else
			 {
			   $e_data.="<td class='tbl_row_new' align='center'  style='width:100px; border-right:1px solid #C5DBEC;  padding:2px;'><input type='text' {$diasable} value='{$FEXAMTIME}'  id='time_{$m}'></td>";
			 }
			$freeze_dis="";
			 if($g_freeze_time=='TIMETABLE' || $tot_marks<=0 )
			  $freeze_dis=" disabled=true; ";
			$hide_freeze="";
			 if($g_freeze_time=='TIMETABLE' )
			  $hide_freeze=" display:none; ";
			  
			 $e_data.="<td class='tbl_row_new' align='center' style='{$hide_freeze};width:100px; border-right:1px solid #C5DBEC;  padding:2px;'><input  id='fmacas_FCSTATUS_check_{$m}' type='checkbox' {$fc_checked} {$freeze_dis}  ></td>"; 
			 $e_data.="<td class='tbl_row_new' align='center' style='{$hide_freeze};width:100px; border-right:1px solid #C5DBEC;  padding:2px;'><input  id='fmacas_print_check_{$m}' type='checkbox' {$fc_print_checked} {$fc_print_disabled}  ></td>"; 
			 
			  if($g_freeze_time=='FREEZE')
			 $e_data.="<td class='tbl_row_new' align='center' style='width:100px; border-left:0px solid #C5DBEC; border-right:1px solid #C5DBEC; padding:2px;' id='report_{$m}'><a href='#'  style='cursor:pointer;color:blue;' onclick='{$report_link}'>Report</a></td>";			 
			 $e_data.="</tr>";   
			 $k++;
			 $sl_no++;
		}	
		$arr['html_data']=$e_data;		  
		$arr['freeze_data']=$obj_get_details;		  
		$arr['total_count']=$m;	
	 
		
		if($obj_get_details)	
	      echo $aobj_context->mobj_output->ToJSONEnvelope($arr,0,"success"); 
	    else
	      echo $aobj_context->mobj_output->ToJSONEnvelope($arr,-1,"Failure");
    return;
		
}

${this.title}

Code Editor : practical_entry_freezing_9112017.php