芝麻web文件管理V1.00

编辑当前文件:/home/qrafawbu/kwesioben.com/accufy/application/views/admin/user/reports/taxes.php

<form method="GET" class="sort_report_form validate-form" action="<?php echo base_url('admin/reports/sales_tax') ?>">
                        <div class="reprt-box">
                          <div class="row pl-15">
                              <div class="col-md-2 col-xs-12 mt-5 pl-0">
                                  <select class="form-control single_select report_type" required name="report_type">
                                      <option value=""><?php echo trans('report-types') ?></option>
                                      <option <?php echo(isset($_GET['report_type']) && $_GET['report_type'] == 1) ? 'selected' : ''; ?> value="1"><?php echo trans('paid-unpaid') ?></option>
                                      <option <?php echo(isset($_GET['report_type']) && $_GET['report_type'] == 2) ? 'selected' : ''; ?> value="2"><?php echo trans('paid') ?></option>
                                  </select>
                              </div>

<div class="col-md-2 col-xs-12 mt-5 pl-0">
                                  <div class="input-group">
                                      <input type="text" class="inv-dpick form-control datepicker" placeholder="From" name="start" value="<?php if(isset($_GET['start'])){echo $_GET['start'];} ?>" autocomplete="off">
                                      <span class="input-group-addon"><i class="fa fa-calendar"></i></span>
                                  </div>
                                  <small><?php echo trans('start-date') ?></small>
                              </div>

<div class="col-md-2 col-xs-12 mt-5 pl-0">
                                  <div class="input-group">
                                      <input type="text" class="inv-dpick form-control datepicker" placeholder="To" name="end" value="<?php if(isset($_GET['end'])){echo $_GET['end'];} ?>" autocomplete="off">
                                      <span class="input-group-addon"><i class="fa fa-calendar"></i></span>
                                  </div>
                                  <small><?php echo trans('end-date') ?></small>
                              </div>
                              <div class="col-md-6 col-xs-12 mt-5 pl-0 text-right">
                                <button type="submit" class="btn btn-info btn-report"><i class="fa fa-search"></i> <?php echo trans('show-report') ?></button>
                              </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>

<?php $i=1; foreach ($taxes as $tax): ?>
                      <tr id="row_<?php echo html_escape($tax->id); ?>">
                          
                          <td><strong><?php echo $tax->tax_name.' ('.round($tax->rate).'%)'; ?></strong></td>
                          
                          <td>
                            <?php $total_subtotal = 0; $total_sale = 0; foreach ($tax->type as $type): ?>
                              <?php foreach ($type->sales as $sale): ?>
                                <?php 
                                  $total_sale += $sale->convert_total;
                                  $total_subtotal += $sale->sub_total;
                                ?>
                              <?php endforeach ?>
                            <?php endforeach ?>
                            <?php echo price_formatted($total_sale, $this->business->id); ?>
                          </td>

<td>
                            <?php $sale_tax = $total_subtotal*$tax->rate/100; ?>
                            <?php echo price_formatted(convert_payment($sale_tax, $tax->currency), $this->business->id); ?>
                          </td>

<td>
                            <?php $total_pur_subtotal = 0; $total_purchase = 0; foreach ($tax->type as $type): ?>
                              <?php foreach ($type->purchases as $purchase): ?>
                                <?php 
                                  $total_purchase += $purchase->convert_total;
                                  $total_pur_subtotal += $purchase->sub_total;
                                ?>
                              <?php endforeach ?>
                            <?php endforeach ?>
                            <?php echo price_formatted($total_purchase, $this->business->id); ?>
                          </td>

<td>
                            <?php $purchase_tax = $total_pur_subtotal*$tax->rate/100; ?>
                            <?php echo price_formatted(convert_payment($purchase_tax, $tax->currency), $this->business->id); ?>
                          </td>

<td>
                            <?php echo price_formatted(convert_payment($sale_tax-$purchase_tax, $tax->currency), $this->business->id); ?>
                          </td>
                         
                      </tr>

<?php 
                        $sale_tax_sum += $sale_tax; 
                        $purchase_tax_sum += $purchase_tax; 
                        $net_tax_sum += $sale_tax+$purchase_tax; 
                      ?>

<?php $i++; endforeach; ?>
                  </tbody>

<thead class="bg-light">
                      <tr>
                          <th class="fs-20"><?php echo trans('total') ?></th>
                          <th></th>
                          <th class="fs-20"><?php echo price_formatted(convert_payment($sale_tax_sum, $tax->currency), $this->business->id); ?></th>
                          <th></th>
                          <th class="fs-20"><?php echo price_formatted(convert_payment($purchase_tax_sum, $tax->currency), $this->business->id); ?></th>
                          <th class="fs-20"><?php echo price_formatted(convert_payment($net_tax_sum, $tax->currency), $this->business->id); ?></th>
                      </tr>
                  </thead>

</table>
            </div>
           
        </div>
    </section>
</div>