1#@!#!123s

: / home / bmsnrajganj / public_html / erp / application / views / admin / examresult /
Filename : marksheet_old.php
back
<?php // Enable profiler in view
//$this->output->enable_profiler(TRUE);
 ?>
 <style>
       .inline-label {
        display: inline-block;
        margin-right: 10px;
    }
    .inline-select {
        display: inline-block;
        width: auto;
    }
 </style>
<div class="content-wrapper">
    <section class="content-header">
        <h1>
            <i class="fa fa-map-o"></i> <?php echo $this->lang->line('examinations'); ?> <small><?php echo $this->lang->line('student_fee1'); ?></small>  </h1>
    </section>
    <!-- Main content -->
    <section class="content">
        <div class="row">
            <div class="col-md-12">
                <div class="box box-primary">
                    <div class="box-header with-border">
                        <h3 class="box-title"><i class="fa fa-search"></i> <?php echo $this->lang->line('select_criteria'); ?></h3>
                    </div>
                    <div class="box-body">

                        <form role="form" action="<?php echo site_url('admin/examresult/marksheet') ?>" method="post" class="row">

                            <?php echo $this->customlib->getCSRF(); ?>
                            <div class="col-sm-6 col-lg-4 col-md-4">
                                <div class="form-group">
                                    <label><?php echo $this->lang->line('exam') . " " . $this->lang->line('group'); ?></label><small class="req"> *</small>
                                    <select autofocus="" id="exam_group_id" name="exam_group_id" class="form-control select2" >
                                        <option value=""><?php echo $this->lang->line('select'); ?></option>
                                        <?php
                                        foreach ($examgrouplist as $ex_group_key => $ex_group_value) {
                                            ?>
                                            <option value="<?php echo $ex_group_value->id ?>" <?php
                                            if (set_value('exam_group_id') == $ex_group_value->id) {
                                                echo "selected=selected";
                                            }
                                            ?>><?php echo $ex_group_value->name; ?></option>
                                                    <?php
                                                }
                                                ?>
                                    </select>
                                    <span class="text-danger"><?php echo form_error('exam_group_id'); ?></span>
                                </div>  
                            </div><!--./col-md-3-->
                            <div class="col-sm-6 col-lg-4 col-md-4">
                                <div class="form-group">   
                                    <label><?php echo $this->lang->line('exam'); ?></label><small class="req"> *</small>
                                    <select  id="exam_id" name="exam_id" class="form-control select2" >
                                        <option value=""><?php echo $this->lang->line('select'); ?></option>
                                    </select>
                                    <span class="text-danger"><?php echo form_error('exam_id'); ?></span>
                                </div>  
                            </div><!--./col-md-3-->
                            <div class="col-sm-6 col-lg-4 col-md-4">
                                <div class="form-group">  
                                    <label><?php echo $this->lang->line('session'); ?></label><small class="req"> *</small>
                                    <select  id="session_id" name="session_id" class="form-control" >
                                        <option value=""><?php echo $this->lang->line('select'); ?></option>
                                        <?php
                                        foreach ($sessionlist as $session) {
                                            ?>
                                            <option value="<?php echo $session['id'] ?>" <?php
                                            if (set_value('session_id') == $session['id']) {
                                                echo "selected=selected";
                                            }
                                            ?>><?php echo $session['session'] ?></option>
                                                    <?php
                                                }
                                                ?>
                                    </select>
                                    <span class="text-danger"><?php echo form_error('session_id'); ?></span>
                                </div>  
                            </div>
                            <div class="col-sm-6 col-lg-4 col-md-4">
                                <div class="form-group">   
                                    <label><?php echo $this->lang->line('class'); ?></label><small class="req"> *</small>
                                    <select id="class_id" name="class_id" class="form-control" >
                                        <option value=""><?php echo $this->lang->line('select'); ?></option>
                                        <?php
                                        foreach ($classlist as $class) {
                                            ?>
                                            <option value="<?php echo $class['id'] ?>" <?php
                                            if (set_value('class_id') == $class['id']) {
                                                echo "selected=selected";
                                            }
                                            ?>><?php echo $class['class'] ?></option>
                                                    <?php
                                                }
                                                ?>
                                    </select>
                                    <span class="text-danger"><?php echo form_error('class_id'); ?></span>
                                </div>  
                            </div>
                           
                            

                            <div class="col-sm-6 col-lg-4 col-md-4">
                                <div class="form-group"> 
                                    <label for="exampleInputEmail1"><?php echo $this->lang->line('section'); ?></label><small class="req"> *</small>
                                    <select  id="section_id" name="section_id" class="form-control" >
                                        <option value=""><?php echo $this->lang->line('select'); ?></option>
                                    </select>
                                    <span class="text-danger"><?php echo form_error('section_id'); ?></span>
                                </div>
                            </div>

                            <div class="col-sm-6 col-lg-4 col-md-4">

                                <div class="form-group">
                                    <label for="exampleInputEmail1"><?php echo $this->lang->line('marksheet') . " " . $this->lang->line('template') ?></label><small class="req"> *</small>
                                    <select  id="marksheet" name="marksheet" class="form-control" >
                                        <option value=""><?php echo $this->lang->line('select'); ?></option>
                                        <?php
                                        foreach ($marksheetlist as $marksheet) {
                                            ?>
                                            <option value="<?php echo $marksheet->id ?>" <?php
                                            if (set_value('marksheet') == $marksheet->id) {
                                                echo "selected=selected";
                                            }
                                            ?>><?php echo $marksheet->template; ?></option>
                                                    <?php
                                                }
                                                ?>
                                    </select>
                                    <span class="text-danger"><?php echo form_error('marksheet'); ?></span>
                                </div>
                            </div>
                             
                            <div class="col-sm-12">
                                <div class="form-group">
                                    <button type="submit" name="search" value="search_filter" class="btn btn-primary pull-right btn-sm checkbox-toggle"><i class="fa fa-search"></i> <?php echo $this->lang->line('search'); ?></button>
                                </div>
                            </div>
                        </form>

                    </div>

                    <?php
                    if (isset($studentList)) {
                        ?>
                        <!--printMarksheet-->
                        <!--target="_blank"-->
                        <form method="post" action="<?php echo base_url('admin/examresult/printmarksheet') ?>"  id="printMarksheet">
                            <input type="hidden" name="marksheet_template" value="<?php echo $marksheet_template; ?>">


                            <div class="box-header ptbnull"></div>  
                            <div class="box-header ptbnull">
                                <h3 class="box-title titlefix"><i class="fa fa-users"></i> <?php echo $this->lang->line('student'); ?> <?php echo $this->lang->line('list'); ?></h3>
                                
                                <button  class="btn btn-info btn-sm printSelected pull-right" type="submit" name="generate" title="generate multiple certificate"><?php echo $this->lang->line('generate'); ?></button>
                                <?php   if($i==8 || $i==6 || $i==4){ //$i==8 || $i==6  { ?>
                                <div class="pull-right" style="margin-right:20px;margin-left:20px;">
                                    <div class="">
                                        <label class="inline-label"><?php echo $this->lang->line('choose'); echo " Term"; ?></label>
                                        <select  id="term" name="term" class="form-control inline-select" onchange="updateHiddenInput()">
                                        <option value="" selected><?php echo $this->lang->line('select'); ?></option>
                                        <option value="1"><?php echo "Term 1"; ?></option>
                                        <option value="2"><?php echo "Term 2"; ?></option>
                                        <?php
                                            if ($examination_module == '6a') {
                                                echo '<option value="3">Term 3</option>';
                                            }
                                        ?>
                                    </select>
                                    <span class="text-danger"><?php echo form_error('term'); ?></span>
                                    </div>
                                </div>
                            
                            <?php    }   ?>
                            </div>
                            <div class="box-body">
                                <?php
                                
                                if($i!=4 && $i!=2 && $i!=6 && $i!=8 && $i!=3){ ?>
                                <input type="hidden" name="post_exam_id" value="<?php echo $exam_id; ?>">
                                 <input type="hidden" name="csa_post_exam_id" value="<?php echo $csa_exam_id; ?>">
                                <input type="hidden" name="i" value="<?php echo "0"; ?>">
                                <?php
                                }
                                else{
                                    ?>
                                    <input type="hidden" name="post_exam_id" value="<?php echo $arr_exam_id; ?>">
                                    <input type="hidden" name="csa_post_exam_id" value="<?php echo $csa_arr_exam_id; ?>">
                                    <input type="hidden" name="i" value="<?php echo $i;//($i==3)?6:$i; ?>">
                                    <!--<input type="hidden" name="term" id="hiddenTerm" value="<?php //echo ($i==6)?3:1; ?>">-->
                                    <?php
                                }
                                ?>
                                <script>
                                    function updateHiddenInput() {
                                      var termSelect = document.getElementById('term');
                                      var hiddenTerm = document.getElementById('hiddenTerm');
                                      hiddenTerm.value = termSelect.value;
                                    }
                                  </script>
                                <input type="hidden" name="post_exam_group_id" value="<?php echo $exam_group_id; ?>">
                                <div class="tab-pane active table-responsive no-padding" id="tab_1">
                                    <table class="table table-striped table-bordered table-hover" cellspacing="0" width="100%">
                                        <thead>
                                            <tr>
                                                <th><input type="checkbox" id="select_all" /></th>
                                                <th><?php echo $this->lang->line('admission_no'); ?></th>
                                                <th><?php echo $this->lang->line('student_name'); ?></th>
                                                <th><?php echo $this->lang->line('father_name'); ?></th>
                                                <th><?php echo $this->lang->line('date_of_birth'); ?></th>
                                                <th><?php echo $this->lang->line('gender'); ?></th>
                                                <th><?php echo $this->lang->line('category'); ?></th>
                                                <th class=""><?php echo $this->lang->line('mobile_no'); ?></th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            if (empty($studentList)) {
                                                ?>

                                                <?php
                                            } 
                                            else {
                                                
                                                $count = 1;
                                                //echo $i;
                                                //print_r($arr_exam_id);
                                                //print_r($studentList2);
                                                // print_r($examList);
                                                 //print_r($exam_group_connection);
                                                 //print_r($getExamGroupConnection);
                                                // echo count($examList);
                                                //echo "<br>".$exam_id."<br>";
                                                //print_r($exam_group_connection);
                                                // echo $exam_group_connection[0]->id."=>";//id 
                                                // echo $exam_group_connection[0]->exam_group_exam_connection_id."<br>"; //exam_group_exam_connection_id
                                                // echo $exam_group_connection[1]->id."=>";//id 
                                                // echo $exam_group_connection[1]->exam_group_exam_connection_id."<br>"; //exam_group_exam_connection_id
                                                // echo $exam_group_connection[2]->id."=>";//id 
                                                // echo $exam_group_connection[2]->exam_group_exam_connection_id."<br>"; //exam_group_exam_connection_id
                                                // echo $exam_group_connection[3]->id."=>";//id 
                                                // echo $exam_group_connection[3]->exam_group_exam_connection_id."<br>"; //exam_group_exam_connection_id
                                                
                                                if($i==4 || $i==2 || $i==6 || $i==8 || $i==3){
                                                //echo "<br>".$i."<br>";
                                                
                                                //print_r($studentList_final);
                                                $groupedData = array();

foreach ($studentList_final as $student) {
    $key = $student->admission_no . ' ' . $student->firstname . ' ' . $student->lastname;
    
    if (!isset($groupedData[$key])) {
        $groupedData[$key] = $student;
    } else {
        $groupedData[$key]->exam_group_class_batch_exam_student_id .= ', ' . $student->exam_group_class_batch_exam_student_id;
    }
}

$result = array_values($groupedData);

 $csa_groupedData = array();

foreach ($csa_studentList_final as $student) {
    $key = $student->admission_no . ' ' . $student->firstname . ' ' . $student->lastname;
    
    if (!isset($csa_groupedData[$key])) {
        $csa_groupedData[$key] = $student;
    } else {
        $csa_groupedData[$key]->exam_group_class_batch_exam_student_id .= ', ' . $student->exam_group_class_batch_exam_student_id;
    }
}

$csa_result = array_values($csa_groupedData);
//print_r($csa_result);
}
                                               








                                                
                                                if($i!=4 && $i!=2 && $i!=6 && $i!=8 && $i!=3){
                                               
                                                foreach ($studentList as $student_key => $student_value) {
                                                  
                                                    ?>
                                                    <tr>
                                                        <td class="text-center"><input type="checkbox" class="checkbox center-block"  name="exam_group_class_batch_exam_student_id[]" data-student_id="<?php echo $student_value->exam_group_class_batch_exam_student_id; ?>" value="<?php echo $student_value->exam_group_class_batch_exam_student_id; ?>">

                                                        </td>
                                                        <td><?php echo $student_value->admission_no; ?></td>
                                                        <td>
            <a href="<?php echo base_url(); ?>student/view/<?php echo $student_value->student_id; ?>"><?php echo $this->customlib->getFullName($student_value->firstname,$student_value->middlename,$student_value->lastname,$sch_setting->middlename,$sch_setting->lastname); ?>
                                                            </a>
                                                        </td>

                                                        <td><?php echo $student_value->father_name;
                                        ;
                                                    ?></td>
                                                        <td><?php 
															if (!empty($student_value->dob) && $student_value->dob != '0000-00-00') {
															echo date($this->customlib->getSchoolDateFormat(), $this->customlib->dateyyyymmddTodateformat($student_value->dob)); }?></td>
                                                        <td><?php echo $student_value->gender; ?></td>
                                                        <td><?php echo $student_value->category; ?></td>
                                                        <td><?php echo $student_value->mobileno; ?></td>
                                                    </tr>
                                                    <?php
                                                    $count++;
                                                }
                                            }
                                            else{
                                                // foreach ($result3 as $student_key => $student_value) {
                                                    foreach ($result as $student_key => $student_value) {
                                                    ?>
                                                    <tr>
                                                        <td class="text-center"><input type="checkbox" class="checkbox center-block"  name="exam_group_class_batch_exam_student_id[]" data-student_admission_no="<?php echo $student_value->admission_no; ?>" data-student_id="<?php echo $student_value->exam_group_class_batch_exam_student_id; ?>" value="<?php echo $student_value->exam_group_class_batch_exam_student_id; ?>">

                                                        </td>
                                                        <td><?php echo $student_value->admission_no; ?></td>
                                                        <td>
            <a href="<?php echo base_url(); ?>student/view/<?php echo $student_value->student_id; ?>"><?php echo $this->customlib->getFullName($student_value->firstname,$student_value->middlename,$student_value->lastname,$sch_setting->middlename,$sch_setting->lastname); ?>
                                                            </a>
                                                        </td>

                                                        <td><?php echo $student_value->father_name;
                                        ;
                                                    ?></td>
                                                        <td><?php 
															if (!empty($student_value->dob) && $student_value->dob != '0000-00-00') {
															echo date($this->customlib->getSchoolDateFormat(), $this->customlib->dateyyyymmddTodateformat($student_value->dob)); }?></td>
                                                        <td><?php echo $student_value->gender; ?></td>
                                                        <td><?php echo $student_value->category; ?></td>
                                                        <td><?php echo $student_value->mobileno; ?></td>
                                                    </tr>
                                                    <?php
                                                    $count++;
                                                }
                                            }
                                            }
                                            ?>
                                        </tbody>
                                    </table>
                                </div>                                                                           
                            </div>                                           

                        </form>
                    </div>
                    <?php
                }
                ?>
            </div>
        </div>
    </section>
</div>

<script type="text/javascript">
 $(document).ready(function () {
        $('.select2').select2();

    });
    var date_format = '<?php echo $result = strtr($this->customlib->getSchoolDateFormat(), ['d' => 'dd', 'm' => 'mm', 'Y' => 'yyyy']) ?>';
    var class_id = '<?php echo set_value('class_id') ?>';
    var section_id = '<?php echo set_value('section_id') ?>';
    var session_id = '<?php echo set_value('session_id') ?>';
    var exam_group_id = '<?php echo set_value('exam_group_id') ?>';
    var exam_id = '<?php echo set_value('exam_id') ?>';
    getSectionByClass(class_id, section_id);
    getExamByExamgroup(exam_group_id, exam_id);
    $(document).on('change', '#exam_group_id', function (e) {
        $('#exam_id').html("");
        var exam_group_id = $(this).val();
        getExamByExamgroup(exam_group_id, 0);
    });

    $(document).on('change', '#class_id', function (e) {
        $('#section_id').html("");
        var class_id = $(this).val();
        getSectionByClass(class_id, 0);
    });

    function getSectionByClass(class_id, section_id) {
        if (class_id != "") {
            $('#section_id').html("");
            var base_url = '<?php echo base_url() ?>';
            var div_data = '<option value=""><?php echo $this->lang->line('select'); ?></option>';

            $.ajax({
                type: "GET",
                url: base_url + "sections/getByClass",
                data: {'class_id': class_id},
                dataType: "json",
                beforeSend: function () {
                    $('#section_id').addClass('dropdownloading');
                },
                success: function (data) {
                    $.each(data, function (i, obj)
                    {
                        var sel = "";
                        if (section_id == obj.section_id) {
                            sel = "selected";
                        }
                        div_data += "<option value=" + obj.section_id + " " + sel + ">" + obj.section + "</option>";
                    });
                    $('#section_id').append(div_data);
                },
                complete: function () {
                    $('#section_id').removeClass('dropdownloading');
                }
            });
        }
    }

    function getExamByExamgroup(exam_group_id, exam_id) {

        if (exam_group_id !== "") {
            $('#exam_id').html("");
            var base_url = '<?php echo base_url() ?>';
            var div_data = '<option value=""><?php echo $this->lang->line('select'); ?></option>';


            $.ajax({
                type: "POST",
                url: base_url + "admin/examgroup/getExamByExamgroup",
                data: {'exam_group_id': exam_group_id},
                dataType: "json",
                beforeSend: function () {
                    $('#exam_id').addClass('dropdownloading');
                },
                success: function (data) {
                    $.each(data, function (i, obj)
                    {
                        if(obj.is_csa==0){
                        var sel = "";
                        if (exam_id === obj.id) {
                            sel = "selected";
                        }
                        div_data += "<option value=" + obj.id + " " + sel + ">" + obj.exam + "</option>";
                        }
                    });

                    $('#exam_id').append(div_data);
                    $('#exam_id').trigger('change');
                },
                complete: function () {
                    $('#exam_id').removeClass('dropdownloading');
                }
            });
        }
    }
</script>
<script>

    $(document).on('submit', 'form#printMarksheet', function (e) {

        e.preventDefault();
        var form = $(this);
        var session_id = $("#session_id option:selected").text();//$("#session_id").val();
        var class_id = $("#class_id").val();
        var section_id = $("#section_id").val();
        var subsubmit_button = $(this).find(':submit');
        
        // Disable the submit button to prevent multiple clicks
    subsubmit_button.prop('disabled', true);
    
        var formdata = form.serializeArray();
        formdata.push({ name: "session_id", value: session_id });
        formdata.push({ name: "class_id", value: class_id });
        formdata.push({ name: "section_id", value: section_id });
//console.log(formdata);
var list_selected =  $('form#printMarksheet input[name="exam_group_class_batch_exam_student_id[]"]:checked').length;
var csaResult = <?php echo json_encode($csa_result); ?>;
    //console.log(csaResult);
 
        
if(!(csaResult === null || csaResult === undefined || csaResult === "")){
    var csa_exam_group_class_batch_exam_student_id=[];
        var list_selectedCheckboxChecked = $('form#printMarksheet input[name="exam_group_class_batch_exam_student_id[]"]:checked').length > 0;//$("input[name='fee_partial_checkbox']:checked").length > 0;
//console.log(list_selectedCheckboxChecked);
      if (list_selectedCheckboxChecked) { //|| feePartialCheckboxChecked
 $.each($("form#printMarksheet input[name='exam_group_class_batch_exam_student_id[]']:checked"), function () {
 //student_id
 var student_admission_no = $(this).data('student_admission_no');
            //console.log(student_admission_no);
            // Use the find() method to search for the admission_no
    var csa_student = csaResult.find(function(item) {
        return item.admission_no == student_admission_no;
    });
    
    // If the student is found, push the exam_group_class_batch_exam_student_id into the array
if (csa_student) {
    csa_exam_group_class_batch_exam_student_id.push(csa_student.exam_group_class_batch_exam_student_id);
}
            
 });
}
//console.log(cse_exam_group_class_batch_exam_student_id);
for(var i=0;i<csa_exam_group_class_batch_exam_student_id.length;i++){
formdata.push({ name: "csa_exam_group_class_batch_exam_student_id[]", value: csa_exam_group_class_batch_exam_student_id[i] });
}
}
      if(list_selected > 0){
        $.ajax({
            type: "POST",
            url: form.attr('action'),
            data: formdata, // serializes the form's elements.
            dataType: "JSON", // serializes the form's elements.
            beforeSend: function () {
                subsubmit_button.button('loading');
            },
            success: function (response)
            {
                Popup(response.page);
            },
            error: function (xhr) { // if error occured

                alert("Error occured.please try again");
                subsubmit_button.button('reset');
            },
            complete: function () {
                subsubmit_button.button('reset');
                subsubmit_button.prop('disabled', false);
                form.data('submitting', false);
            }
        });
      }else{
         confirm("<?php echo $this->lang->line('please_select_student'); ?>");
      }
    });


    $(document).on('click', '#select_all', function () {
        $(this).closest('table').find('td input:checkbox').prop('checked', this.checked);
    });

</script>
<script type="text/javascript">

    var base_url = '<?php echo base_url() ?>';
    function Popup(data)
    {

        var frame1 = $('<iframe />');
        frame1[0].name = "frame1";
        $("body").append(frame1);
        var frameDoc = frame1[0].contentWindow ? frame1[0].contentWindow : frame1[0].contentDocument.document ? frame1[0].contentDocument.document : frame1[0].contentDocument;
        frameDoc.document.open();
//Create a new HTML document.
        frameDoc.document.write('<html>');
        frameDoc.document.write('<head>');
        frameDoc.document.write('<title></title>');
         //frameDoc.document.write('<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">');
        // frameDoc.document.write('<link rel="stylesheet" href="' + base_url + 'admin/examresult/style.css">');
        frameDoc.document.write('<link rel="stylesheet" href="<?php echo base_url(); ?>backend/bootstrap/css/bootstrap.min.4.5.2.css">');
        frameDoc.document.write('</head> ');
        frameDoc.document.write('<body>');
        frameDoc.document.write(data);
        frameDoc.document.write('</body>');
        frameDoc.document.write('</html>');
        frameDoc.document.close();
        setTimeout(function () {
            window.frames["frame1"].focus();
            window.frames["frame1"].print();
            frame1.remove();
        }, 500);//100 //5000
//         frame1.on('load', function() {
//     window.frames["frame1"].focus();
//     window.frames["frame1"].print();
//     frame1.remove();
// });
        return true;
    }
</script>