<?php $currency_symbol = $this->customlib->getSchoolCurrencyFormat(); ?>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">

    <section class="content-header">
        <h1>
            <i class="fa fa-mortar-board"></i> School Details</h1>											 
								 <a href="<?php  echo base_url(); ?>school_type" class="col-md pull-right">Add School Type</a>
								 <b style="padding-left:5px;padding-right:5px;"class="pull-right"> | </b>
								 <a href="<?php  echo base_url(); ?>school_group" class="col-md pull-right">Add School Group</a> 
								 <b style="padding-left:5px;padding-right:5px;"class="pull-right"> | </b>
								 <a href="<?php  echo base_url(); ?>school_details" class="col-md pull-right">Add School Details</a>
    </section>

    <!-- Main content -->
    <section class="content">
        <div class="row">
            <?php
            if ($this->rbac->hasPrivilege('class', 'can_add')) {
                ?>  
                <div class="col-md-4">
                    <!-- Horizontal Form -->
                    <div class="box box-primary">
                        <div class="box-header with-border">
                            <h3 class="box-title"><?php echo $title;       ?></h3>
                        </div><!-- /.box-header -->
                        <form id="form1" action="<?php echo base_url() ?>school_details"  method="POST" accept-charset="utf-8">
                            <div class="box-body">
                                <?php if ($this->session->flashdata('msg')) { ?>
                                    <?php echo $this->session->flashdata('msg') ?>
                                <?php } ?>
                                <?php
                                if (isset($error_message)) {
                                    echo "<div class='alert alert-danger'>" . $error_message . "</div>";
                                }    
                                ?>
                                <?php echo $this->customlib->getCSRF(); ?>   
								<div class="form-group">
                                    <label for="colour">School Name</label><small class="req"> *</small>
                                    <input autofocus="" id="name" name="name" placeholder="" type="text" class="form-control"  value="<?php echo set_value('name'); ?>" />
                                    <span class="text-danger"><?php echo form_error('name'); ?></span>
                                </div>									 															
                                <div class="form-group">
                                    <label for="cashbook">School type</label><small class="req"> *</small>
										<select id="school_type" name="school_type" placeholder="" type="text" class="form-control" >
											<option value="select"><?php echo $this->lang->line('select') ?></option>
											<?php 
												foreach ($school_type->result() as $grup) {
												?>
									                <option value="<?php echo $grup->school_type; ?>" >  <?php echo $grup->school_type; ?></option>
											<?php }
											?>
										</select>
                                    <span class="text-danger"><?php echo form_error('school_type'); ?></span>
                                </div> 																			
								<div class="form-group">
                                    <label for="currency">School Group</label>
										<select id="school_group" name="school_group" placeholder="" type="text" class="form-control" >
											<option value="select"><?php echo $this->lang->line('select') ?></option>
											<?php 
												foreach ($school_group->result() as $grup) {
												?>
									                <option value="<?php echo $grup->school_group; ?>" >  <?php echo $grup->school_group; ?></option>
											<?php  }
											?>
										</select>
                                    <span class="text-danger"><?php echo form_error('school_group'); ?></span>
                                </div>                                   							
								<div class="form-group">
                                    <label for="colour">Contact Person</label><small class="req"> *</small>
                                    <input autofocus="" id="contact_person" name="contact_person" placeholder="" type="text" class="form-control"  value="<?php echo set_value('contact_person'); ?>" />
                                    <span class="text-danger"><?php echo form_error('contact_person'); ?></span>
                                </div>									
								<div class="form-group">
                                    <label for="colour">Contact Person Cell</label><small class="req"> *</small>
                                    <input autofocus="" id="contact_person_cell" name="contact_person_cell" placeholder="" type="text" class="form-control"  value="<?php echo set_value('contact_person_cell'); ?>" />
                                    <span class="text-danger"><?php echo form_error('contact_person_cell'); ?></span>
                                </div>								
								<div class="form-group">
                                    <label for="colour">School Address</label><small class="req"> *</small>
                                    <input autofocus="" id="address" name="address" placeholder="" type="text" class="form-control"  value="<?php echo set_value('address'); ?>" />
                                    <span class="text-danger"><?php echo form_error('address'); ?></span>
                                </div>								
								<div class="form-group">
                                    <label for="colour">School Email</label><small class="req"> *</small>
                                    <input autofocus="" id="email" name="email" placeholder="" type="text" class="form-control"  value="<?php echo set_value('email'); ?>" />
                                    <span class="text-danger"><?php echo form_error('email'); ?></span>
                                </div>								
                            </div><!-- /.box-body -->
                            <div class="box-footer">
                                <button type="submit" class="btn btn-info pull-right"><?php echo $this->lang->line('save'); ?></button>
                            </div>
                        </form>
                    </div>
                </div><!--/.col (right) -->
                <!-- left column -->
            <?php } ?>
            <div class="col-md-<?php
            if ($this->rbac->hasPrivilege('class', 'can_add')) {
                echo "8";
            } else {
                echo "12";
            }
            ?>">
                <!-- general form elements -->
                <div class="box box-primary">
                    <div class="box-header ptbnull">
                        <h3 class="box-title titlefix"><?php echo $title_list; ?></h3>
                        <div class="box-tools pull-right">
                        </div><!-- /.box-tools -->
                    </div><!-- /.box-header -->
                    <div class="box-body">
                        <div class="table-responsive mailbox-messages">
                            <div class="download_label"><?php echo $title_list; ?></div>
                            <table class="table table-striped table-bordered table-hover example">
                                <thead>
                                    <tr>
                                        <th>Date Captured</th>
                                        <th>Name</th>
                                        <th>School Type</th>
                                        <th>School Group</th>
                                        <th>Contact Person</th>
                                        <th>Person Phone</th>
                                        <th>Address</th>
                                        <th>Email</th>
                                        <th>Action</th>
                                       
                                    </tr>
                                </thead>
                                <tbody>
                                <?php  
																
										 foreach ($school_details->result() as $row)  
										 {   
                                        ?>
                                        <tr>
                                            <td class="mailbox-name"><?php echo $row->date;?></td>
                                            <td class="mailbox-name"><?php echo $row->name;?></td>
                                            <td class="mailbox-name"><?php echo $row->school_type;?></td>
                                            <td class="mailbox-name"><?php echo $row->school_group;?></td>
                                            <td class="mailbox-name"><?php echo $row->contact_person;?></td>
                                            <td class="mailbox-name"><?php echo $row->contact_person_cell;?></td>
                                            <td class="mailbox-name"><?php echo $row->address;?></td>
                                            <td class="mailbox-name"><?php echo $row->email;?></td>       
                                            <td class="mailbox-date pull-right">
                                                <?php
                                                if ($this->rbac->hasPrivilege('types', 'can_edit')) {
                                                    ?>  
                                                    <a href="<?php echo base_url(); ?>school_details/edit/<?php echo $row->id; ?>" class="btn btn-default btn-xs"  data-toggle="tooltip" title="<?php echo $this->lang->line('edit'); ?>">
                                                        <i class="fa fa-pencil"></i>
                                                    </a>
                                                    <?php
                                                }
                                                if ($this->rbac->hasPrivilege('types', 'can_delete')) {
                                                    ?>  
                                                    <a href="<?php echo base_url(); ?>school_details/delete/<?php echo $row->id; ?>"class="btn btn-default btn-xs"  data-toggle="tooltip" title="<?php echo $this->lang->line('delete'); ?>" onclick="return confirm('<?php echo $this->lang->line('delete_confirm') ?>');">
                                                        <i class="fa fa-remove"></i>
                                                    </a>
                                                <?php } ?>
                                            </td>											
                                        </tr>
									<?php } ?>
                                </tbody>
                            </table><!-- /.table -->



                        </div><!-- /.mail-box-messages -->
                    </div><!-- /.box-body -->
                </div>
            </div><!--/.col (left) -->
            <!-- right column -->

        </div>
        <div class="row">
            <!-- left column -->

            <!-- right column -->
            <div class="col-md-12">

            </div><!--/.col (right) -->
        </div>   <!-- /.row -->
    </section><!-- /.content -->
</div><!-- /.content-wrapper -->
<script type="text/javascript">
    function getSectionByClass(class_id, section_id) {
        if (class_id != "" && section_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 + "cashbook/getByModule",
                data: {'class_id': class_id},
                dataType: "json",
                success: function (data) {
                    $.each(data, function (i, obj)
                    {
                        var sel = "";
                        if (section_id == obj.section_id) {
                            sel = "selected";
                        }
						if( class_id == 'Learner'){
							div_data += "<option value=" +obj.firstname +" "+ obj.lastname + ">" +obj.firstname +" "+ obj.lastname + "</option>";
						}
						else if( class_id == 'Supplier'){
							div_data += "<option value=" + obj.name + ">" + obj.name + "</option>";
						}							
						else if( class_id == 'GL'){
							div_data += "<option value=" + obj.name + ">" + obj.name + "</option>";
						}						
						else if( class_id == 'Customer'){
							div_data += "<option value=" + obj.name + ">" + obj.name + "</option>";
						}
						else{
							div_data += "<option value=" + obj.name + " " + sel + ">" + obj.name + "</option>";
						}
                    });
                    $('#section_id').append(div_data);
                }
            });
        }
    }

    $(document).ready(function () {
        var class_id = $('#class_id').val();
        var section_id = '<?php echo set_value('section_id') ?>';
        getSectionByClass(class_id, section_id);
        $(document).on('change', '#class_id', function (e) {
            $('#section_id').html("");
            var class_id = $(this).val();
            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 + "cashbook/getByModule",
                data: {'class_id': class_id},
                dataType: "json",
                success: function (data) {
                    $.each(data, function (i, obj)
                    {
						if( class_id == 'Learner'){
							div_data += "<option value=" +obj.firstname +" "+ obj.lastname + ">" +obj.firstname +" "+ obj.lastname + "</option>";
						}
						else if( class_id == 'Supplier'){
							div_data += "<option value=" + obj.name + ">" + obj.name + "</option>";
						}							
						else if( class_id == 'GL'){
							div_data += "<option value=" + obj.name + ">" + obj.name + "</option>";
						}						
						else if( class_id == 'Customer'){
							div_data += "<option value=" + obj.name + ">" + obj.name + "</option>";
						}
						else{
							div_data += "<option value=" + obj.name +">" + obj.name + "</option>";
						}
                        
                    });
                    $('#section_id').append(div_data);
                }
            });
        });
    });
</script>