<?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> Cashbook Processing
        </h1>
        <a href="<?php  echo base_url(); ?>cashbook/cashbooksearch" class="col-md pull-right">Cashbook Statement</a>
        <b style="padding-left:5px;padding-right:5px;" class="pull-right"> | </b>
        <a href="<?php  echo base_url(); ?>cashbook" class="col-md pull-right">Process Cashbook</a>
        <b style="padding-left:5px;padding-right:5px;" class="pull-right"> | </b>
        <a href="<?php  echo base_url(); ?>cashbook_accounts" class="col-md pull-right">Add Cashbook Account</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() ?>cashbook" 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">Date</label><small class="req"> *</small>
                                <input autofocus="" id="date" name="date" placeholder="" type="date"
                                    class="form-control" value="<?php echo date("Y-m-d")?>" />
                                <span class="text-danger"><?php echo form_error('date'); ?></span>
                            </div>
                            <div class="form-group">
                                <label for="cashbook">Cashbook Account</label><small class="req"> *</small>
                                <select id="cashbook" name="cashbook" placeholder="" type="text" class="form-control">
                                    <option value="select"><?php echo $this->lang->line('select') ?></option>
                                    <?php 
												foreach ($cashbook_details->result() as $grup) {
												?>
                                    <option value="<?php echo $grup->cashbook_accounts; ?>">
                                        <?php echo $grup->cashbook_accounts; ?></option>
                                    <?php }
											?>
                                </select>
                                <span class="text-danger"><?php echo form_error('cashbook'); ?></span>
                            </div>
                            <div class="form-group">
                                <label for="module">Module Name</label><small class="req"> *</small>
                                <select id="class_id" name="module" placeholder="" type="text" class="form-control">
                                    <option value="select"><?php echo $this->lang->line('select') ?></option>
                                    <option>Learner</option>
                                    <option>Supplier</option>
                                    <option>Customer</option>
                                    <option>GL</option>
                                </select>
                                <span class="text-danger"><?php echo form_error('module'); ?></span>
                            </div>
                            <div class="form-group">
                                <label for="colour">Account Name</label><small class="req"> *</small>
                                <select id="section_id" name="account" class="form-control">
                                    <option value=""><?php echo $this->lang->line('select'); ?></option>
                                </select>
                                <span class="text-danger"><?php echo form_error('account'); ?></span>
                            </div>
                            <div class="form-group">
                                <label for="currency">MV Expense</label><small class="req"> ( Optional )</small>
                                <select id="mv_expense" name="mv_expense" placeholder="" type="text"
                                    class="form-control">
                                    <option>Select Motor Vehicle</option>
                                    <?php 
												foreach ($vehicle_list->result() as $grup) {
												?>
                                    <option value="<?php echo $grup->vehicle_no; ?>">
                                        <?php echo $grup->vehicle_model.' - '.$grup->manufacture_year; ?></option>
                                    <?php  }
											?>
                                </select>
                                <span class="text-danger"></span>
                            </div>
                            <div class="form-group">
                                <label for="colour">Reference</label><small class="req"> *</small>
                                <input autofocus="" id="receipt" name="receipt" placeholder="" type="text"
                                    class="form-control" value="<?php echo set_value('receipt'); ?>" />
                                <span class="text-danger"><?php echo form_error('receipt'); ?></span>
                            </div>
                            <div class="form-group">
                                <label for="currency">TR Code</label><small class="req"> *</small>
                                <select id="dr_cr" name="dr_cr" placeholder="" type="text" class="form-control">
                                    <option><?php echo $this->lang->line('select') ?></option>
                                    <option value="1"> Receipts</option>
                                    <option value="2"> Payments</option>
                                </select>
                                <span class="text-danger"><?php echo form_error('dr_cr'); ?></span>
                            </div>
                            <div class="form-group">
                                <label for="colour">Description</label><small class="req"> *</small>
                                <input autofocus="" id="description" name="description" placeholder="" type="text"
                                    class="form-control" value="<?php echo set_value('description'); ?>" />
                                <span class="text-danger"><?php echo form_error('description'); ?></span>
                            </div>
                            <div class="form-group">
                                <label for="amount">Amount</label><small class="req"> *</small>
                                <input autofocus="" id="amount" name="amount" placeholder="" type="text"
                                    class="form-control" value="<?php echo set_value('amount'); ?>" />
                                <span class="text-danger"><?php echo form_error('amount'); ?></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; ?> Transaction</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>Cashbook</th>
                                        <th>Module</th>
                                        
                                        <th>Description</th>
                                        <th>Reference (Receipt)</th>
                                        <th>Currency</th>
                                        <th>Deposits</th>
                                        <th>Payments</th>

                                    </tr>
                                </thead>
                                <tbody>
                                    <?php  
																
										 foreach ($cashbook_temp->result() as $row)  
										 {   
                                        ?>
                                    <tr>
                                        <td class="mailbox-name"><?php echo $row->date;?></td>
                                        <td class="mailbox-name"><?php echo $row->cashbook;?></td>
                                        <td class="mailbox-name"><?php echo $row->module;?></td>
                                      
                                        <td class="mailbox-name"><?php echo $row->description;?></td>
                                        <td class="mailbox-name"><?php echo $row->receipt;?></td>
                                        <td class="mailbox-name"><?php 
											
                                                $currency= $row->cashbook;

                                                $this->db->select('*');
                                                $this->db->from('cashbook_accounts');
                                                $this->db->where('cashbook_accounts', $currency);
                                                $query = $this->db->get();
                                                $result = $query->row();
												
												echo $result->currency;
											?></td>
                                        <td class="mailbox-name"><?php echo $row->debit;?></td>
                                        <td class="mailbox-name"><?php echo $row->credit;?></td>
                                    </tr>
                                    <?php } ?>
                                    <tr>
                                        <td>           
                                         <div class="btn-group pull-right">                                                    
                                                 <button class="btn btn-xs btn-primary processButton" title="Process">
                                                    <i class="fa fa-cogs"></i> Process
                                                 </button>
                                        </div>
                                          </td>
                                    </tr>
                                </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>
    $(document).ready(function () {
        $(".processButton").click(function () {
            if (confirm("Are you sure you want to process the transaction")) {
                $.ajax({
                    url: "<?php echo base_url('cashbook/delete_temp'); ?>", 
                    type: "POST",
                    success: function (response) {
                        alert("The transaction have been processed successfully!");
                        location.reload(); // Refresh the page to update the table
                    },
                    error: function () {
                        alert("An error occurred. Please try again.");
                    }
                });
            }
        });
    });
</script>
<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') {
                        // Only add the main GL account option if glname is valid
                        if (typeof obj.glname !== 'undefined' && obj.glname !== '' && obj.glname !== 'undefined') {
                            div_data += '<option value="' + obj.glid + '">' + obj.gl_code + " > " + obj.glname + '</option>';
                        }
                        // Only add the sub GL account option if subname is valid
                        if (typeof obj.subname !== 'undefined' && obj.subname !== '' && obj.subname !== 'undefined') {
                            div_data += '<option value="' + obj.glsub_id + '">' + obj.gl_code + " > " + obj.glsub_code + " > " + obj.subname + '</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') {
                        // Only add the main GL account option if glname is valid
                        if (typeof obj.glname !== 'undefined' && obj.glname !== '' && obj.glname !== 'undefined') {
                            div_data += '<option value="' + obj.glid + '">' + obj.gl_code + " > " + obj.glname + '</option>';
                        }
                        // Only add the sub GL account option if subname is valid
                        if (typeof obj.subname !== 'undefined' && obj.subname !== '' && obj.subname !== 'undefined') {
                            div_data += '<option value="' + obj.glsub_id + '">' + obj.gl_code + " > " + obj.glsub_code + " > " + obj.subname + '</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>
