1#@!#!123s

: / home / bmsnrajganj / public_html / erp / application / views / admin / feesforward /
Filename : roll_number.php
back
<?php
$currency_symbol = $this->customlib->getSchoolCurrencyFormat();
?>
<!-- Select2 CSS -->
<link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />
<style>
.filestyle{
    height:80px !important;
}
</style>
<div class="content-wrapper" style="min-height: 946px;">
    <!-- Content Header (Page header) -->
    <section class="content-header">
        <h1>
            <i class="fa fa-money"></i> <?php echo $this->lang->line('fees_collection'); ?> </h1>
    </section>
    <!-- Main content -->
    <section class="content">
        <div class="row">  
            <form id='feesforward' action="<?php echo site_url('admin/feesforward/roll_number') ?>"  method="post" accept-charset="utf-8" enctype="multipart/form-data">
                <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 class="box-tools pull-right">
                            </div>
                        </div>

                        <div class="box-body">
                            <?php echo $this->customlib->getCSRF(); ?>
                            <div class="row">
                                <div class="col-md-12">                                   
                                    <?php if ($this->session->flashdata('msg')) { ?>
                                        <?php echo $this->session->flashdata('msg') ?>
                                    <?php } ?>
                                </div>
                            <!--inner boxes starts -->
                                <div class="col-md-4">                                   
                                    <div class="form-group">
                                        <label for="exampleInputEmail1"><?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
                                                $count++;
                                            }
                                            ?>
                                        </select>
                                        <span class="text-danger"><?php echo form_error('class_id'); ?></span>
                                    </div>
                                </div>
                                <div class="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-md-4">
    <div class="form-group">
        <label for="student_column">Student Table Column</label><small class="req"> *</small>
        <select id="student_column" name="student_column" class="form-control select2">
            <option value="">-- Select Column --</option>
            <?php
            // Add any system/internal columns you don't want to show in dropdown
            $excluded_fields = ['id', 'created_at', 'updated_at', 'password', 'deleted_at', 'remember_token', 'guardian_id','app_key','parent_id','state','city','pincode','promote_date','category_id','route_id','miscellaneous_id_1','miscellaneous_id_2','miscellaneous_id_3','miscellaneous_id_4','miscellaneous_fees','route_fees','hostel_fees','school_house_id','vehroute_id','hostel_room_id','is_active','guardian_name','guardian_relation','guardian_phone','guardian_occupation','guardian_qualification','guardian_address','guardian_email','guardian_pic','guardian_is','vehroute_id','hostel_room_id','hostel_id','transport_route_created_at','hostel_rooms_created_at','disable_at','parent_app_key','dis_note','dis_reason','note'];
            foreach ($columns as $col):
              if(!in_array($col,$excluded_fields)){
            ?>
              
                <option value="<?php echo $col; ?>"
                    <?php if (set_value('student_column') == $col) echo 'selected="selected"'; ?>>
                    <?php echo ucfirst(str_replace('_', ' ', $col)); ?>
                </option>
            
            <?php
                }
            endforeach; ?>
        </select>
        <span class="text-danger"><?php echo form_error('student_column'); ?></span>
    </div>
</div>

                                
                            </div>

                            <div class="">
                                <button type="submit" name="action" value ="search" class="btn btn-primary pull-right"><?php echo $this->lang->line('search'); ?></button>
                            </div>
                        </div>  

                        <?php
                        // echo $selected_column;
                        // print_r($selected_column);
                        // echo "<pre>";
                        // print_r($columns);
                        // echo "</pre>";
                        if (isset($student_due_fee)) {
                            ?>
                            <div class="box-header ptbnull"></div>   
                            <div class="">
                                <div class="box-header with-border">
                                    <h3 class="box-title titlefix"><?php echo $this->lang->line('roll_no'); //previous_session_balance_fees?></h3>
                                    <div class="pull-right">
                                        <span class="text text-danger pt6 bolds"><?php echo $this->lang->line('due_date'); ?>:</span> <?php echo set_value('due_date', $due_date_formated); ?>
                                        <input id="due_date" name="due_date" placeholder="" type="hidden" class="form-control date"  value="<?php echo set_value('due_date', $due_date_formated); ?>" readonly /> 
                                    </div>  
                                </div>
                                <div class="box-body">
                                    <?php
                                    if (!empty($student_due_fee)) {
                                        ?>

                                        <div class="row">
                                            <div class="col-md-12">
                                                <?php
                                                if ($is_update) {
                                                    ?>
                                                    <div class="alert alert-info"><?php echo $this->lang->line('roll_no');//previous_balance_already_forwarded ?></div>
                                                    <?php
                                                }
                                                ?>
                                            </div>
                                            <div class="row col-xs-12">
                                                <div class="col-md-4">                                            

                                                </div>
                                            </div>
                                            <div class="col-xs-12 table-responsive">
                                                <div class="download_label"><?php echo $this->lang->line('roll_no');//previous_session_balance_fees ?></div>
                                                <table class="table table-striped example">
                                                    <thead>
                                             <tr>
    <th class="text text-left">
        <?php echo $this->lang->line($display_column[0]) ?: ucfirst(str_replace('_', ' ', $display_column[0])); ?>
    </th>

    <th class="text text-left">
        <?php echo $this->lang->line($display_column[1]) ?: ucfirst(str_replace('_', ' ', $display_column[1])); ?>
    </th>

    <?php if ($sch_setting->admission_date) { ?>
        <th class="text text-left">
            <?php echo $this->lang->line($display_column[2]) ?: ucfirst(str_replace('_', ' ', $display_column[2])); ?>
        </th>
    <?php } ?>

    <?php if ($sch_setting->roll_no) { ?>
        <th class="text text-left">
            <?php echo $this->lang->line($display_column[3]) ?: ucfirst(str_replace('_', ' ', $display_column[3])); ?>
        </th>
    <?php } ?>

    <?php if ($sch_setting->father_name) { ?>
        <th class="text text-left">
            <?php echo $this->lang->line($display_column[4]) ?: ucfirst(str_replace('_', ' ', $display_column[4])); ?>
        </th>
    <?php } ?>
</tr>


                                                    </thead> 
                                                    <tbody>
                                                        <?php
                                                        $i = 1;
                                                        foreach ($student_due_fee as $due_fee_key => $due_fee_value) {
                                                            // print_r($due_fee_value);
                                                           
                                                            ?>
                                                            <tr>
                                                                <td>
                                                                    <input type="hidden" name="student_counter[]" value="<?php echo $i; ?>">
                                                                    <input type="hidden" name="id[<?php echo $i; ?>]" value="<?php echo $due_fee_value->id; ?>">
                                                                    
                                                                    <?php echo $due_fee_value-> {$display_column[0]} ?></td>  

                                                                <td><?php echo $due_fee_value->{$display_column[1]} ?></td>
                                                                
                                                     
                                                                    <td><?php echo $due_fee_value->{$display_column[2]} ?></td>
                                                                    
                                                                      <td><?php echo $due_fee_value->{$display_column[3]} ?></td>
                                          
                                                                    <td class="text text-right">
                                                    <!--<input type="text" name="<?php echo $display_column[4] . '[' . $i . ']'; ?>" class="form-control tddm200" value="<?php echo $due_fee_value->{$display_column[4]}; ?>">-->
                                                    
<?php
    $value = $due_fee_value->{$display_column[4]};
    $field_name = $display_column[4] . '[' . $i . ']';

    // Detect common date formats
    $is_date = preg_match('/^(\d{2}[\/\-]\d{2}[\/\-]\d{4}|\d{4}[\/\-]\d{2}[\/\-]\d{2})$/', $value);

    // Detect if it's an image URL or image path
    $is_image = filter_var($value, FILTER_VALIDATE_URL) || preg_match('/\.(jpg|jpeg|png|gif)$/i', $value) || $display_column[4] =="mother_pic" || $display_column[4] =="father_pic" || $display_column[4] == "image"  || $display_column[4] == "guardian_pic" ;

    // Format date to Y-m-d for <input type="date">
    $formatted_date = '';
    if ($is_date) {
        $formats = ['d-m-Y', 'd/m/Y', 'Y-m-d', 'Y/m/d'];
        foreach ($formats as $format) {
            $dt = DateTime::createFromFormat($format, $value);
            if ($dt && $dt->format($format) === $value) {
                $formatted_date = $dt->format('Y-m-d');
                break;
            }
        }
    }
?>

<?php if ($is_image): ?>
 <div style="display:flex; gap:10px; align-items:center;">
    <!-- Show existing image -->
    <img id="preview_<?php echo $i; ?>" src="<?php echo base_url($value); ?>" 
         alt="Image" width="60" height="60" 
         style="object-fit: cover; border:1px solid #ccc; border-radius:5px;">

    <!-- Upload field -->
    <input class="filestyle form-control" 
           type="file" 
           name="<?php echo $field_name; ?>" 
           id="file_<?php echo $i; ?>" 
           size="20" 
       
           onchange="previewImage('<?php echo $i; ?>')" />

    <!-- Optional: retain old image filename -->
    <input type="hidden" name="old_<?php echo $field_name; ?>" 
           value="<?php echo htmlspecialchars($value); ?>">
</div>

<?php elseif ($is_date && $formatted_date): ?>
    <input type="date" name="<?php echo $field_name; ?>" class="form-control tddm200" value="<?php echo $formatted_date; ?>">
<?php else: ?>
    <input type="text" name="<?php echo $field_name; ?>" class="form-control tddm200" value="<?php echo htmlspecialchars($value); ?>">
<?php endif; ?>




                                                                    <!--<input type="text" name="$display_column[4][<?php echo $i; ?>]" class="form-control tddm200" value="<?php echo $due_fee_value->{$display_column[4]}; ?>">-->
                                                                </td>
                                                              
                                                                  
                                                              
                                                            </tr>
                                                            <?php
                                                            $i++;
                                                        }
                                                        ?>
                                                    </tbody>

                                                </table>

                                            </div>
                                        </div>
                                        <div class="row">
                                            <div class="box-footer">
                                                <button type="submit" name="action" value="fee_submit" class="btn btn-primary pull-right"><?php echo $this->lang->line('save'); ?></button>
                                            </div>
                                        </div>

                                        <?php
                                    } else {
                                        ?>
                                        <div class="alert alert-info"><?php echo $this->lang->line('no_record_found'); ?>
                                        </div>
                                        <?php
                                    }
                                    ?>
                                </div>

                            </div>
                        </div> 
                        <?php
                    }
                    // echo "<pre>";
                    // print_r($test);
                    // echo "</pre>";
                    ?>

                </div>
            </form>
        </div>
    </section>
</div>


<script type="text/javascript">


    $(document).ready(function () {

        var class_id = $('#class_id').val();
        var section_id = '<?php echo set_value('section_id', 0) ?>';
        var hostel_id = $('#hostel_id').val();
        var hostel_room_id = '<?php echo set_value('hostel_room_id', 0) ?>';

        getSectionByClass(class_id, section_id);
    });

    $(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');
                }
            });
        }
    }



</script>



<script type="text/javascript">
    $(document).ready(function () {
        $.extend($.fn.dataTable.defaults, {
            searching: true,
            ordering: true,
            paging: false,
            retrieve: true,
            destroy: true,
            info: false
        });
    });
 

</script>

<!-- jQuery -->
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>

<!-- Select2 JS -->
<script src="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/js/select2.min.js"></script>
<script>
$(document).ready(function() {
    $('.select2').select2({
        placeholder: "-- Select Column --",
        allowClear: true,
        width: '100%'
    });
});
</script>
<script>
function previewImage(index) {
    var input = document.getElementById('file_' + index);
    var preview = document.getElementById('preview_' + index);

    if (input.files && input.files[0]) {
        var file = input.files[0];
        var maxSize = 60 * 1024; // 60 KB

        if (file.size > maxSize) {
            alert('Image size exceeds the limit of 60 KB. Please choose a smaller image.');
            input.value = ''; // Clear input
            return;
        }

        var reader = new FileReader();

        reader.onload = function (e) {
            preview.src = e.target.result;
        };

        reader.readAsDataURL(file);
    }
}
</script>