<legend><i class="fa fa-users"></i> <?php
echo getDepartmentCenter($dp, $bt);
?>
» <small style="font-size:12px; font-weight:bold; color:darkgrey"><?php
echo getDepartmentCenterCourse($course_code, $bt);
?>
</small></legend>
<?php
} else {
?>
<legend><i class="fa fa-users"></i> <?php
echo getDepartmentCenter($dp, $bt);
?>
» <small style="font-size:12px; font-weight:bold; color:darkgrey"> All Students
</small></legend>
<?php
}
if (empty($course_code)) {
if ($bt == 'dept') {
$sql = "SELECT *\nFROM student_details s\nWHERE s.dept_center_code ={$dp} and belongs_to_center_dept='dept'\nORDER BY s.sl DESC ";
} elseif ($bt == 'center') {
$sql = "SELECT *\nFROM student_details s\nWHERE s.dept_center_code ={$dp} and belongs_to_center_dept='center'\nORDER BY s.sl DESC ";
}
} else {
if ($bt == 'dept') {
<th style="color:green">Action</th>
</tr>
</thead>
<?php
while ($r = mysql_fetch_array($cl)) {
?>
<tr>
<td style="color:#3b5999" align="center"><?php
echo $i;
?>
</td>
<td style="color:#3b5999" ><?php
echo getDepartmentCenter($r['dept_code'], $r['branch_type']);
?>
</td>
<?php
if ($r['status'] == 'N') {
?>
<td style="color:red;" align="center"><?php
if ($r['op_name'] != '' || !empty($r['op_name'])) {
echo $r['op_name'];
} else {
?>
<span title="This information is currently not available" class="label label-danger">N/A</span><?php
}
?>
</td>
$cx = $rowx['center_dept_code'];
$sess = $rowx['session'];
$feeid = $rowx['fee_id'];
$status = $rowx['status'];
$feecat = $rowx['fee_category_id'];
$proc = $rowx['course_fee_parameter'];
if ($proc == 'per_semester') {
$procedure = "Per Sem";
} else {
$procedure = "Per Year";
}
?>
<tr>
<td style="font-size: 11px;"><?php
echo getDepartmentCenter($cx, $bts);
?>
<br/><br/><span class="label label-primary"><?php
echo getDepartmentCenterCourse($dccode, $bts);
?>
</span></td>
<td style=""><span class="label label-default"><?php
echo getSemester($semcode);
?>
</span></td>
<td style="font-size:"><span class="label label-default"><?php
echo getSession($sess);
?>
</span></td>
<td style="font-size:"><span class="label label-default"><?php
$objPHPExcel->getActiveSheet()->getColumnDimension($col)->setAutoSize(true);
}
$F->setCellValue('A1', 'ID');
$F->setCellValue('B1', 'NAME');
$F->setCellValue('C1', 'USERID');
$F->setCellValue('D1', 'PASSWORD');
$F->setCellValue('E1', 'DEPARTMENT/CENTER');
$sql = "SELECT * from g_users where user_type='operator' order by dept_code desc";
$rs = mysql_query($sql);
$i = 1;
while ($r = mysql_fetch_array($rs)) {
$F->setCellValue('A' . $Line, $i);
$F->setCellValue('B' . $Line, $r['op_name']);
$F->setCellValue('C' . $Line, $r['user_name']);
$F->setCellValue('D' . $Line, $r['password']);
$F->setCellValue('E' . $Line, getDepartmentCenter($r['dept_code'], $r['branch_type']));
$i = $i + 1;
$Line = $Line + 1;
}
header('Content-Type: application/vnd.ms-excel');
$filename = 'DU Department Operators Excel Report-' . time() . ".xls";
header("Content-Disposition: attachment;filename=" . $filename);
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
//$objWriter->save(str_replace('.php', '.xls', __FILE__));
$objWriter->save('php://output');
exit;
function getDepartmentCenter($dccode, $btype)
{
if ($btype == 'center') {
$q14 = mysql_query("select * from center where center_code={$dccode}");
$F->setCellValue('K' . $Line, $r['dob']);
$F->setCellValue('L' . $Line, $r['sex']);
$F->setCellValue('M' . $Line, $r['community']);
$F->setCellValue('N' . $Line, $r['region']);
$F->setCellValue('O' . $Line, getFeeCategory($r['fee_category']));
$F->setCellValue('P' . $Line, $r['mb_no']);
$F->setCellValue('Q' . $Line, $r['email_id']);
$F->setCellValue('R' . $Line, getSemester($r['fee_paid_upto_semester_code']));
$F->setCellValue('S' . $Line, $reside);
$F->setCellValue('T' . $Line, $r['student_id']);
$F->setCellValue('U' . $Line, $r['password']);
$F->setCellValue('V' . $Line, getCreator($r['created_by_id']));
$Line = $Line + 1;
}
header('Content-Type: application/vnd.ms-excel');
$resolve = getDepartmentCenter($deptidcenterid, 'dept');
$resolvecourse = getDepartmentCenterCourse($courseid, 'dept');
$filename = 'DU Student Data- ' . $resolve . "-" . $resolvecourse . "-" . time() . ".xls";
header("Content-Disposition: attachment;filename=" . $filename);
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
//$objWriter->save(str_replace('.php', '.xls', __FILE__));
$objWriter->save('php://output');
exit;
function getDepartmentCenter($dccode, $btype)
{
if ($btype == 'center') {
$q14 = mysql_query("select * from center where center_code={$dccode}");
$c_name = mysql_fetch_array($q14);
return $c_name['center_name'];
} else {
<legend><i class="fa fa-users"></i> <?php
echo getDepartmentCenter($center_code, $bt);
?>
» <small style="font-size:12px; font-weight:bold; color:darkgrey"><?php
echo getDepartmentCenterCourse($center_course_code, $bt);
?>
</small></legend>
<?php
} else {
?>
<legend><i class="fa fa-users"></i> <?php
echo getDepartmentCenter($center_code, $bt);
?>
» <small style="font-size:12px; font-weight:bold; color:darkgrey"> All Students
</small></legend>
<?php
}
if ($center_course_code != 0) {
$sql = "SELECT *\nFROM student_details s\nWHERE s.dept_center_code ={$center_code} and s.dept_center_course_code={$center_course_code} \nand s.belongs_to_center_dept='center'\nORDER BY s.sl DESC ";
$F->setCellValue('L1', 'DEVELOPMENT FEE');
$F->setCellValue('M1', 'INTERNET FEE');
$F->setCellValue('N1', 'LABORATORY FEE');
$F->setCellValue('O1', 'STUDENT SAFETY INSURANCE');
$F->setCellValue('P1', 'SPORTS FEE');
$F->setCellValue('Q1', 'HOSTEL FEE');
$F->setCellValue('R1', 'GRAND TOTAL');
$F->setCellValue('S1', 'FEE CATEGORY');
$F->setCellValue('T1', 'FEE STATUS');
$F->setCellValue('U1', 'CREATOR');
$sql = "SELECT * from fee_structure ORDER BY fee_id desc";
$rs = mysql_query($sql);
while ($r = mysql_fetch_array($rs)) {
$bt = $r['type'];
$F->setCellValue('A' . $Line, $r['fee_id']);
$F->setCellValue('B' . $Line, getDepartmentCenter($r['center_dept_code'], $bt));
$F->setCellValue('C' . $Line, getDepartmentCenterCourse($r['course_code'], $bt));
$F->setCellValue('D' . $Line, getSession($r['session']));
$F->setCellValue('E' . $Line, getSemester($r['sem_year']));
$F->setCellValue('F' . $Line, $r['admission_fee']);
$F->setCellValue('G' . $Line, $r['course_fee_year_sem']);
$F->setCellValue('H' . $Line, $r['course_fee_parameter']);
$F->setCellValue('I' . $Line, $r['library_fee']);
$F->setCellValue('J' . $Line, $r['union_magazine']);
$F->setCellValue('K' . $Line, $r['saf_fee']);
$F->setCellValue('L' . $Line, $r['development_fee']);
$F->setCellValue('M' . $Line, $r['interent_fee']);
$F->setCellValue('N' . $Line, $r['laboratory_fee']);
$F->setCellValue('O' . $Line, $r['student_safety']);
$F->setCellValue('P' . $Line, $r['sports_fee']);
$F->setCellValue('Q' . $Line, $r['hostel_fee']);
$F->setCellValue('N' . $Line, $r['laboratory_fee']);
$F->setCellValue('O' . $Line, $r['student_safety']);
$F->setCellValue('P' . $Line, $r['sports_fee']);
$F->setCellValue('Q' . $Line, $r['hostel_fee']);
$F->setCellValue('R' . $Line, $r['total_fee']);
$F->setCellValue('S' . $Line, getFeeCategory($r['fee_category_id']));
if ($r['status'] == 1) {
$F->setCellValue('T' . $Line, "Active");
} else {
$F->setCellValue('T' . $Line, "Inactive");
}
$F->setCellValue('U' . $Line, getCreator($r['created_by_id']));
$Line = $Line + 1;
}
header('Content-Type: application/vnd.ms-excel');
$resolve = getDepartmentCenter($deptidcenterid, $bt);
$filename = 'DU Fee Structure Information- ' . $resolve . "-" . time() . ".xls";
header("Content-Disposition: attachment;filename=" . $filename);
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
//$objWriter->save(str_replace('.php', '.xls', __FILE__));
$objWriter->save('php://output');
exit;
function getDepartmentCenter($dccode, $btype)
{
if ($btype == 'center') {
$q14 = mysql_query("select * from center where center_code={$dccode}");
$c_name = mysql_fetch_array($q14);
return $c_name['center_name'];
} else {
//dept
<table class="no-border">
<thead class="no-border">
<tr>
<th style="width:50%; color:green"><strong>Department</strong><strong></th>
<th style=" color:green"><strong>Course</strong></th>
<th style=" color:green"><strong>Semester</strong></th>
<th style=" color:green"><strong>Roll#</strong></th>
<th style=" color:green"><strong>Regn#</strong></th>
</tr>
</thead>
<tbody class="no-border-x no-border-y">
<tr>
<td style="width:30%;"><?php
echo getDepartmentCenter($dept_center_code, $belongs_to_center_dept);
?>
</td>
<td><?php
echo getDepartmentCenterCourse($dept_center_course_code, $belongs_to_center_dept);
?>
</td>
<td><?php
echo getSemester($semester_code);
?>
</td>
<td><?php
if ($roll_no != 'Not Available') {
?>
<span class="label label-success"><?php
echo $roll_no;
