Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
output	[ DIR ]	drwxr-xr-x
DownloadExamAppFormApplication...	4.49 KB	-rwxr-xr-x
DownloadRvRtAckApplications.ph...	4.6 KB	-rwxr-xr-x
PrintChallanEntryDetails.php	8.26 KB	-rwxr-xr-x
RvRtApplicationReport.php	8.76 KB	-rwxr-xr-x
appear_list_center_qp_wise.php	7.33 KB	-rwxr-xr-x
appear_list_center_qp_wise_280...	7.32 KB	-rwxr-xr-x
appear_list_qp_wise.php	5.66 KB	-rwxr-xr-x
batch_wise_details.php	4.45 KB	-rwxr-xr-x
code39.php	6.38 KB	-rwxr-xr-x
college_degree_details.php	4.57 KB	-rwxr-xr-x
generatePostAdmissionTicket.ph...	39.19 KB	-rwxr-xr-x
hallticketcomm.php	29.47 KB	-rwxr-xr-x
htdegreesum.php	4.93 KB	-rwxr-xr-x
marls_subjectwise.php	10.22 KB	-rwxr-xr-x
practical_marks_report.php	5.31 KB	-rwxr-xr-x
report_admission_details.php	26.8 KB	-rwxr-xr-x
report_admission_list.php	10 KB	-rwxr-xr-x
report_admission_list_wop.php	10.31 KB	-rwxr-xr-x
report_admission_listnehu.php	24.67 KB	-rwxr-xr-x
report_admission_ticket.php	43.84 KB	-rwxr-xr-x
report_admission_ticket1110201...	33.93 KB	-rwxr-xr-x
report_admission_ticket1511201...	39.7 KB	-rwxr-xr-x
report_admission_ticket_before...	13.33 KB	-rwxr-xr-x
report_admission_ticket_kus.ph...	16.15 KB	-rwxr-xr-x
report_admission_ticketcopy.ph...	32.41 KB	-rwxr-xr-x
report_admission_ticketkswu.ph...	15.07 KB	-rwxr-xr-x
report_admission_ticketold.php	30.03 KB	-rwxr-xr-x
report_admission_ticketoldform...	30.91 KB	-rwxr-xr-x
report_attendance_sheet.php	12.43 KB	-rwxr-xr-x
report_attendance_summary.php	9.06 KB	-rwxr-xr-x
report_bacth_preparation_dairy...	6.67 KB	-rwxr-xr-x
report_batch_practical_dairy.p...	15.19 KB	-rwxr-xr-x
report_batch_wise_details.php	7.65 KB	-rwxr-xr-x
report_batch_wise_detailsold.p...	7.41 KB	-rwxr-xr-x
report_batch_worksheet_details...	10.92 KB	-rwxr-xr-x
report_bundle_dispatch.php	7.78 KB	-rwxr-xr-x
report_candidate_list.php	25.88 KB	-rwxr-xr-x
report_candidate_list_before_f...	25.19 KB	-rwxr-xr-x
report_candidate_list_before_s...	19.8 KB	-rwxr-xr-x
report_daliy_report.php	10.87 KB	-rwxr-xr-x
report_daliy_report_qp.php	10.01 KB	-rwxr-xr-x
report_daliy_report_qp_new.php	9.93 KB	-rwxr-xr-x
report_daliy_report_qp_wait.ph...	9.9 KB	-rwxr-xr-x
report_degree_list.php	4.71 KB	-rwxr-xr-x
report_deviation_report.php	7.67 KB	-rwxr-xr-x
report_evaluation_report.php	9.31 KB	-rwxr-xr-x
report_iamarks_pending.php	6.58 KB	-rwxr-xr-x
report_marks_deviation_report....	5.38 KB	-rwxr-xr-x
report_marks_elementwise.php	3.87 KB	-rwxr-xr-x
report_marks_elementwisenew.ph...	4.67 KB	-rwxr-xr-x
report_marks_entry_student_lis...	5.6 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	12.88 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	10.13 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	9.16 KB	-rwxr-xr-x
report_marks_entry_subwise_lis...	10.05 KB	-rwxr-xr-x
report_marks_pending.php	12.02 KB	-rwxr-xr-x
report_online_eam.php	11.59 KB	-rwxr-xr-x
report_practical_marks_details...	13.35 KB	-rwxr-xr-x
report_practical_marks_details...	13.9 KB	-rwxr-xr-x
report_practical_misc.php	8.09 KB	-rwxr-xr-x
report_qpcount_univ.php	5.93 KB	-rwxr-xr-x
report_ra_exl_report.php	5.74 KB	-rwxr-xr-x
report_ra_invigilator_dairy.ph...	16.53 KB	-rwxr-xr-x
report_ra_invigilator_dairy_12...	19.45 KB	-rwxr-xr-x
report_ra_invigilator_dairy_ol...	14.46 KB	-rwxr-xr-x
report_ra_invigilator_dairy_ol...	15.77 KB	-rwxr-xr-x
report_ra_invigilators_dairy.p...	8.35 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	7.43 KB	-rwxr-xr-x
report_ra_qp_wise_student_coun...	7.29 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	10.43 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	11.3 KB	-rwxr-xr-x
report_ra_roomwise_register_no...	11.31 KB	-rwxr-xr-x
report_revaluation.php	6.42 KB	-rwxr-xr-x
report_sectionwiselist.php	4.61 KB	-rwxr-xr-x
report_subject_admcl_list.php	3.48 KB	-rwxr-xr-x
report_subject_general_list.ph...	4.13 KB	-rwxr-xr-x
revaluation.php	15.65 KB	-rwxr-xr-x
roomallotmantsummary.php	3.5 KB	-rwxr-xr-x
roomwise_register_nos_list.php	17.28 KB	-rwxr-xr-x
roomwise_register_nos_list_120...	16.5 KB	-rwxr-xr-x
s	32.36 KB	-rwxr-xr-x
stringspliter.php	693 B	-rwxr-xr-x
subject_wise_student_list.php	6.2 KB	-rwxr-xr-x
teacher_report.php	8.11 KB	-rwxr-xr-x
topsheet.php	8.09 KB	-rwxr-xr-x

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,12);		
	$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);
   //var_dump($get_daliy_data);die();
   // 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