Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
output	[ DIR ]	drwxrwxrwx
.Report_details_16042016.php	3.61 KB	-rw-r--r--
DownloadExamAppFormApplication...	4.51 KB	-rwxrwxrwx
PrintChallanEntryDetails.php	8.77 KB	-rwxrwxrwx
RvRtApplicationReport.php	8.76 KB	-rwxrwxrwx
appear_list_center_qp_wise.php	5.48 KB	-rwxrwxrwx
appear_list_qp_wise.php	5.34 KB	-rwxrwxrwx
batch_wise_details.php	4.44 KB	-rwxrwxrwx
report_admission_list.php	10.86 KB	-rwxrwxrwx
report_admission_list30062012....	6.67 KB	-rwxrwxrwx
report_admission_list_wop.php	10.25 KB	-rwxrwxrwx
report_admission_ticket.php	14.96 KB	-rwxrwxrwx
report_admission_ticket0310201...	10.74 KB	-rwxrwxrwx
report_admission_ticket0409201...	10.69 KB	-rwxrwxrwx
report_admission_ticket1403201...	10.76 KB	-rwxrwxrwx
report_admission_ticket2408.ph...	10.46 KB	-rwxrwxrwx
report_admission_ticket2408201...	10.47 KB	-rwxrwxrwx
report_admission_ticket_071020...	13.89 KB	-rwxrwxrwx
report_admission_ticket_distan...	14.14 KB	-rwxrwxrwx
report_admission_ticket_upto_o...	12.4 KB	-rwxrwxrwx
report_attendance_summary.php	7.75 KB	-rwxrwxrwx
report_batch_wise_details.php	7.93 KB	-rwxrwxrwx
report_batch_worksheet_details...	10.33 KB	-rwxrwxrwx
report_candidate_list.php	26.01 KB	-rwxrwxrwx
report_candidate_list1111.php	16.24 KB	-rwxrwxrwx
report_candidate_list22042013....	16.35 KB	-rwxrwxrwx
report_candidate_list24082012....	16.21 KB	-rwxrwxrwx
report_candidate_list26042013....	16.35 KB	-rwxrwxrwx
report_candidate_list_09052013...	16.42 KB	-rwxrwxrwx
report_candidate_list_before_f...	25.19 KB	-rwxrwxrwx
report_candidate_list_final.ph...	9.85 KB	-rwxrwxrwx
report_candidate_list_new.php	17.76 KB	-rwxrwxrwx
report_candidate_list_old.php	18.18 KB	-rwxrwxrwx
report_candidate_listmohan.php	16.21 KB	-rwxrwxrwx
report_candidate_listx.php	16.24 KB	-rwxrwxrwx
report_daliy_report.php	10.83 KB	-rwxrwxrwx
report_daliy_report_qp.php	9.79 KB	-rwxrwxrwx
report_degree_list.php	5.31 KB	-rwxrwxrwx
report_deviation_report.php	7.67 KB	-rwxrwxrwx
report_evaluation_report.php	9.31 KB	-rwxrwxrwx
report_marksPending.php	5.13 KB	-rwxrwxrwx
report_marks_deviation_report....	5.38 KB	-rwxrwxrwx
report_marks_entry_student_lis...	6.53 KB	-rwxrwxrwx
report_marks_entry_student_lis...	5.28 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	11.13 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	10.13 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	10.2 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	14.56 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	10.02 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	10.36 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	10.13 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	11.65 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	10.2 KB	-rwxrwxrwx
report_marks_entry_subwise_lis...	10.05 KB	-rwxrwxrwx
report_marksentry.php	7.12 KB	-rwxrwxrwx
report_online_eam.php	10.92 KB	-rwxrwxrwx
report_practical_marks_details...	13.35 KB	-rwxrwxrwx
report_practical_marks_details...	13.37 KB	-rwxrwxrwx
report_practical_marks_details...	13.22 KB	-rwxrwxrwx
report_ra_invigilators_dairy.p...	7.63 KB	-rwxrwxrwx
report_ra_qp_wise_student_coun...	5.84 KB	-rwxrwxrwx
report_ra_roomwise_register_no...	6.7 KB	-rwxrwxrwx
report_revaluation.php	4.45 KB	-rwxrwxrwx
report_subject_admcl_list.php	4.32 KB	-rwxrwxrwx
report_subject_general_list.ph...	10.89 KB	-rwxrwxrwx
subject_wise_student_list.php	6.77 KB	-rwxrwxrwx
teacher_report.php	9.89 KB	-rwxrwxrwx

Code Editor : report_daliy_report.php

<?php
function generateDaliyReport($aobj_context)
{	
	include_once($aobj_context->main_src."/src/format.php");
	session_start();
	$college_code = $_SESSION['collcode']; 
    $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC);  
    
	//echo $college_code; 
	$degree_code_start = $aobj_context->mobj_data["degree_code_start"]; 
	$degree_code_end = $aobj_context->mobj_data["degree_code_end"]; 
	
	$date_start = substr("0000000000".db_date_Format($aobj_context->mobj_data["Date_start"]),-10); 
	$date_end   = substr("ZZZZZZZZZZ".db_date_Format($aobj_context->mobj_data["Date_end"]),-10);
	 
	$session     = $aobj_context->mobj_data["session"]; 
	
	$exam_start = substr("0".$aobj_context->mobj_data["exam_start"],-1);  
	$exam_end   = substr("Z".$aobj_context->mobj_data["exam_end"],-1);   
	
	$sub_start   = substr("00000".$aobj_context->mobj_data["sub_start"],-5); 
	$sub_end     = substr("ZZZZZ".$aobj_context->mobj_data["sub_end"],-5); 
	
	 
	
	$main_src_obj=(explode("/",$_SERVER["REQUEST_URI"]));
	$main_src=$main_src_obj[1];
	$pdf_writer_class=$aobj_context->main_src."/maya-pdf/fpdf.php";
	$root_pdf_file_download=$aobj_context->main_src."/Report_details/output/report_daliy_rpt.pdf";

include($pdf_writer_class);		
	$pdf= new FPDF(); //Landscape
	
	$pdf->SetFont('Times','',10);
	$pdf->SetMargins(20,8);		
	$pdf->AliasNbPages();
	
	$page_header_university = "select FUNIVNAME,FTOWN, date_format(now(),'%d/%m/%Y') as date from control";
	$lobj_page_header_university = $aobj_context->mobj_db->GetRow($page_header_university);
	
	$page_header_college ="select concat('[',FCOLLCODE,']  ',FCOLLNAME,', ',FTOWN) as college_name
							from college where FCOLLCODE='{$college_code}'";
	$lobj_page_header_college = $aobj_context->mobj_db->GetRow($page_header_college);

$page_header_degree = "select concat('[',FDEGREE,'] - ', FDESCPN,space(2),'-',space(2),FEXAMDATE) as Degree_name, FADYEAR  
							from degree where FDEGREE = '{$degree_code_start}' ";
	$lobj_page_header_degree = $aobj_context->mobj_db->GetRow($page_header_degree);	
	$pdf->aobj_context =$aobj_context ;
	$pdf->WhichReport = 'ReportDaliy';
	$pdf->FUNIVNAME = $lobj_page_header_university[FUNIVNAME];
	$pdf->FTOWN = $lobj_page_header_university[FTOWN];
	$pdf->date_1 = $lobj_page_header_university['date'];
	$pdf->college_name = $lobj_page_header_college['college_name'];
	$pdf->Degree_name = $lobj_page_header_degree['Degree_name'];	
	$pdf->RFROM= $aobj_context->mobj_data["Date_start"];
	$pdf->RTO= $date_end;	
	$pdf->EXM_START= $exam_start;	
	$pdf->EXM_END= $aobj_context->mobj_data["Date_end"];
	
	$get_fcsubcode_from_both_table = "select sub.FDEGREE, sub.FEXAMNO,sub.FCSUBCODE,
	concat('[ ',sub.FCSUBCODE,' ]', space(2), sub.FSUBNAME, space(2), '( ',sub.FSSUBNAME,' )') as subject_desp
										from colldesp cd inner join subject sub on 
										cd.FDEGREE = sub.FDEGREE and cd.FCSUBCODE=sub.FCSUBCODE and cd.FEXAMNO = sub.FEXAMNO 
										where cd.FCOLLCODE='{$college_code}' and 
										cd.FDEGREE>='{$degree_code_start}' and cd.FDEGREE<='{$degree_code_end}' 
										and cd.FDOE>='{$date_start}' and cd.FDOE<='{$date_end}' 
										and cd.FSESSION='{$session}' and 
										cd.FEXAMNO>='{$exam_start}' and cd.FEXAMNO<='{$exam_end}' 
										and sub.FCSUBCODE>='{$sub_start}' and sub.FCSUBCODE<='{$sub_end}' and cd.FDELETED='F' 
										union
										select a.FDEGREE, a.FEXAMNO, a.FCSUBCODE,
										concat('[ ',sub.FCSUBCODE,' ]', space(2), sub.FSUBNAME, space(2), '( ',sub.FSSUBNAME,' )') as subject_desp
										from absent a inner join subject sub on
							a.FDEGREE = sub.FDEGREE and 
							a.FCSUBCODE=sub.FCSUBCODE and
							a.FEXAMNO = sub.FEXAMNO where 
										a.FDEGREE>='{$degree_code_start}' and a.FDEGREE<='{$degree_code_end}' and 
										a.FEXAMNO>='{$exam_start}' and a.FEXAMNO<='{$exam_end}' and 
										a.FCSUBCODE>='{$sub_start}' and a.FCSUBCODE<='{$sub_end}' 
										and a.FDELETED='F' group by a.FABSTYPE,a.FCSUBCODE";	
		$lobj_get_fcsubcode_from_both_table = $aobj_context->mobj_db->GetAll($get_fcsubcode_from_both_table);
	$pdf->Subject_name=$lobj_get_fcsubcode_from_both_table[0][FCSUBCODE];
 
	 $get_daliy_data= "  select cd.FDEGREE, cd.FEXAMNO,cd.FCSUBCODE,
							concat('[ ',sub.FCSUBCODE,' ]', space(2), sub.FSUBNAME, space(2), '( ',sub.FSSUBNAME,' )') as subject_desp,
							FNOBUNDLE,FTOTSCRIPT 
							from colldesp cd inner join subject sub on
							cd.FDEGREE = sub.FDEGREE and 
							cd.FCSUBCODE=sub.FCSUBCODE and
							cd.FEXAMNO = sub.FEXAMNO
							where  
							cd.FCOLLCODE='{$college_code}' and
							cd.FDEGREE>='{$degree_code_start}' and cd.FDEGREE<='{$degree_code_end}' and 
							cd.FDOE>='{$date_start}' and cd.FDOE<='{$date_end}'  and
							cd.FSESSION='{$session}' and
							cd.FEXAMNO>='{$exam_start}' and cd.FEXAMNO<='{$exam_end}' and
							cd.FCSUBCODE>='{$sub_start}' and cd.FCSUBCODE<='{$sub_end}' and
							cd.FDELETED='F' "; 
	 					
   $lobj_get_daliy_data = $aobj_context->mobj_db->GetAll($get_daliy_data);
   // FSESSION='{$session}' and
   //FDOE>='{$date_start}' and FDOE<='{$date_end}'  and
	$get_daliy_absent_data= " select a.FABSTYPE as type,concat('[ ',sub.FCSUBCODE,' ]', space(2), sub.FSUBNAME, space(2), '( ',sub.FSSUBNAME,' )') as subject_desp,
								a.FCSUBCODE,GROUP_CONCAT(a.FREGNO SEPARATOR '  ') as RegNo 
								from absent a 
								inner join subject sub on
								a.FDEGREE = sub.FDEGREE and 
								a.FCSUBCODE=sub.FCSUBCODE and
								a.FEXAMNO = sub.FEXAMNO
								where 
								a.FDEGREE>='{$degree_code_start}' and a.FDEGREE<='{$degree_code_end}' and 
								a.FEXAMNO>='{$exam_start}' and a.FEXAMNO<='{$exam_end}' and
								a.FCSUBCODE>='{$sub_start}' and a.FCSUBCODE<='{$sub_end}' and 
								a.FDELETED='F' and  a.FCOLLCODE='{$college_code}'
								group by a.FABSTYPE,a.FCSUBCODE" ;	
   $lobj_get_daliy_absent_data = $aobj_context->mobj_db->GetAll($get_daliy_absent_data);
  // echo $get_daliy_absent_data; die();  
   /*  echo "<pre>";
   var_dump($lobj_get_daliy_absent_data ); die();  */
 
	$pdf->Subject_name = $lobj_get_daliy_data[0]['subject_desp'];   
	$pdf->Subject_name=(empty($pdf->Subject_name))?$lobj_get_daliy_absent_data[0]['subject_desp']:$pdf->Subject_name; 
	$pdf->AddPage();		
	$pdf->SetFont('Times','',9);	
	
  $check_same_deg_code = $lobj_get_fcsubcode_from_both_table[0]['FDEGREE'];  
  $check_same_sub_code = $lobj_get_fcsubcode_from_both_table[0]['FCSUBCODE'];
	
	$arr_w = array(70,80,90,40,120,23);
	$arr_h = array(5,8);
	$pdf->Ln(10);
	$flag_same_sub =0;
	foreach($lobj_get_fcsubcode_from_both_table as $key => $value)
	{
		$bundle_flag=1;
		$flag_ab =1;
		$flag_mp =1;
		if($value['FCSUBCODE']== $check_same_sub_code)	// total script
		 {
			
			$flag_same_sub=1;
		 }
		 else
		 {
			$check_same_deg_code = $value['FDEGREE'];
			$check_same_sub_code = $value['FCSUBCODE'];
			$pdf->Subject_name = $value['subject_desp'];
			$pdf->AddPage();
			$flag_same_sub=1;
			$pdf->Ln(10);
		 }
		if($flag_same_sub)	 
		{
			
			foreach($lobj_get_daliy_data as $key => $value)    // absent
			{
				 
				if($check_same_sub_code == $value['FCSUBCODE'])
				{
				$pdf->Cell($arr_w[5],$arr_h[1],'','0',0,'L');
				$pdf->Cell($arr_w[1],$arr_h[1],'Total Number of Bundles','LT',0,'L');
				$pdf->Cell($arr_w[3],$arr_h[1],$value['FNOBUNDLE'],'1',1,'C');	
				$pdf->Cell($arr_w[5],$arr_h[1],'','R',0,'L');
				$pdf->Cell($arr_w[1],$arr_h[1],'Total Number of Scripts','LB',0,'L');		
				$pdf->Cell($arr_w[3],$arr_h[1],$value['FTOTSCRIPT'],'1',1,'C');	
				$bundle_flag=0;
				}
			}
			   if($bundle_flag)
				{
				$pdf->Cell($arr_w[5],$arr_h[1],'','0',0,'L');
				$pdf->Cell($arr_w[1],$arr_h[1],'Total Number of Bundles','LT',0,'L');
				$pdf->Cell($arr_w[3],$arr_h[1],'0','1',1,'C');	
				$pdf->Cell($arr_w[5],$arr_h[1],'','R',0,'L');
				$pdf->Cell($arr_w[1],$arr_h[1],'Total Number of Scripts','LB',0,'L');		
				$pdf->Cell($arr_w[3],$arr_h[1],'0','1',1,'C');					
				} 
			
							//$pdf->Ln(20);
			foreach($lobj_get_daliy_absent_data as $key => $value)    // absent
			{
				$temp_reg = '';
				$pdf->Subject_name=(empty($pdf->Subject_name))?$value['subject_desp']:$pdf->Subject_name; 
				if($check_same_sub_code == $value['FCSUBCODE'])
				{
					$count_reg = explode("  ",$value['RegNo']);					
					
	//  ab					
				if($value['type'] == 'A')
					{
						$pdf->Ln(15);
						$pdf->Cell($arr_w[5],$arr_h[1],'','0',0,'L');
						$pdf->Cell($arr_w[4],$arr_h[1],'Total Absents:   '.count($count_reg),'1',1,'L');
						$pdf->Cell($arr_w[5],$arr_h[1],'','0',0,'L');
						 $pdf->MultiCell($arr_w[4],$arr_h[1],$value['RegNo'],1,"L");
						//$pdf->Cell($arr_w[4],$arr_h[1],$value['RegNo'],'1',1,'L');
						//echo $value['RegNo']."<br>";
						$flag_ab =0;						
					}
					/* else  if($value['type'] != 'M' && !$flag_ab)
					{
						$pdf->Ln(15);
						$pdf->Cell($arr_w[5],$arr_h[1],'','0',0,'L');
						$pdf->Cell($arr_w[4],$arr_h[1],'Total Absents:   '.'0','1',1,'L');
						$pdf->Cell($arr_w[5],$arr_h[1],'','0',0,'L');
						$pdf->Cell($arr_w[4],$arr_h[1],'','1',1,'L');	
						$flag_ab =0;
					} */
		//  mp			
					if($value['type'] == 'M')
					{
						$pdf->Ln(15);
						$pdf->Cell($arr_w[5],$arr_h[1],'','0',0,'L');
						$pdf->Cell($arr_w[4],$arr_h[1],'Total Malpractice / Unfair Means:  '.count($count_reg),'1',1,'L');						
						$pdf->Cell($arr_w[5],$arr_h[1],'','0',0,'L');
						$pdf->Cell($arr_w[4],$arr_h[1],$value['RegNo'],'1',1,'L');
						$flag_mp =0;
					}
					/* else if($value['type'] == 'A' && !$flag_mp)
					{
						$pdf->Ln(15);
						$pdf->Cell($arr_w[5],$arr_h[1],'','0',0,'L');
						$pdf->Cell($arr_w[4],$arr_h[1],'Total Malpractice / Unfair Means:  '.'0','1',1,'L');						
						$pdf->Cell($arr_w[5],$arr_h[1],'','0',0,'L');
						$pdf->Cell($arr_w[4],$arr_h[1],'','1',1,'L');
						$flag_mp=0;
					} */
				}
            } $flag_same_sub=0;	
				if($flag_ab) {
						$pdf->Ln(15);
						$pdf->Cell($arr_w[5],$arr_h[1],'','0',0,'L');
						$pdf->Cell($arr_w[4],$arr_h[1],'Total Absents:   '.'0','1',1,'L');
						$pdf->Cell($arr_w[5],$arr_h[1],'','0',0,'L');
						$pdf->Cell($arr_w[4],$arr_h[1],'','1',1,'L');	
						$flag_ab =0;
					}
				if($flag_mp)
					{
						$pdf->Ln(15);
						$pdf->Cell($arr_w[5],$arr_h[1],'','0',0,'L');
						$pdf->Cell($arr_w[4],$arr_h[1],'Total Malpractice / Unfair Means:  '.'0','1',1,'L');						
						$pdf->Cell($arr_w[5],$arr_h[1],'','0',0,'L');
						$pdf->Cell($arr_w[4],$arr_h[1],'','1',1,'L');
						$flag_mp=0;
					} 				
		}			
		/* else //if($value['FCSUBCODE'] != $check_same_sub_code)	
		 {
			$check_same_deg_code = $value['FDEGREE'];
			$check_same_sub_code = $value['FCSUBCODE'];
			$pdf->AddPage();
			$pdf->Cell($arr_w[3],$arr_h[1],'','0',0,'L');
			$pdf->Cell($arr_w[1],$arr_h[1],'Total Number of Bundles','LT',0,'L');
			$pdf->Cell($arr_w[3],$arr_h[1],$value['FNOBUNDLE'],'1',1,'C');	
			$pdf->Cell($arr_w[3],$arr_h[1],'','R',0,'L');
			$pdf->Cell($arr_w[1],$arr_h[1],'Total Number of Scripts','LB',0,'L');		
			$pdf->Cell($arr_w[3],$arr_h[1],$value['FTOTSCRIPT'],'1',1,'C');			
		 }  */
	}	
 
	$pdf->Output("report_daliy_rpt.pdf","D");
}
?>

${this.title}

Code Editor : report_daliy_report.php