.
*
* Vue balance des comptes
*
* @package vues
*/
$this->load->view('bs_header');
$this->load->view('bs_menu');
$this->load->view('bs_banner');
$this->lang->load('comptes');
echo '
';
echo checkalert($this->session);
$title = $this->lang->line($title_key);
if ($codec) {
$title .= nbs() . $this->lang->line('comptes_label_class') . nbs() . $codec;
}
if ($codec2) {
$title .= nbs() . $this->lang->line('comptes_label_to') . nbs() . $codec2;
}
echo heading($title, 3);
echo form_hidden('controller_url', controller_url($controller), '"id"="controller_url"');
$values = $this->lang->line("comptes_balance_general");
echo $this->lang->line("comptes_label_date") . ':
';
echo br(2);
// --------------------------------------------------------------------------------------------------
// Filtre
echo form_hidden('filter_active', $filter_active);
$tab = 3;
echo form_fieldset($this->lang->line("gvv_str_filter"), array('class' => 'coolfieldset filtre mb-3 mt-3',
'title' => $this->lang->line("gvv_str_filter_tooltip")));
echo "
";
echo form_open(controller_url($controller) . "/filterValidation/" , array('name' => 'saisie') );
echo "
\n";
echo $this->lang->line("comptes_label_balance") . " . " . radio_field('general', $general, $values, 'onchange=balance_general();');
echo " |
";
echo $this->lang->line("comptes_label_soldes") . ": " . enumerate_radio_fields($this->lang->line("comptes_filter_active_select"), 'filter_solde', $filter_solde);
echo " |
";
echo form_input(array('type' => 'submit', 'name' => 'button', 'value' => $this->lang->line("gvv_str_select")));
echo nbs();
echo form_input(array('type' => 'submit', 'name' => 'button', 'value' => $this->lang->line("gvv_str_display")));
echo " |
\n";
echo form_close();
echo "
";
echo form_fieldset_close();
// --------------------------------------------------------------------------------------------------
// Data
$solde_deb = '';
$solde_cred = '';
$total_debit = $total['debit'];
$total_credit = $total['credit'];
if ($total_debit > $total_credit) {
$solde_deb = euro($total_debit - $total_credit);
} else {
$solde_cred = euro($total_credit - $total_debit);
}
$footer = [];
if ($detail) {
$footer[] = ['', $this->lang->line("comptes_label_totals"), euro($total['debit']), euro($total['credit']), euro($total['solde_debit']), euro($total['solde_credit']), '', ''];
$footer[] = ['', $this->lang->line("comptes_label_totals_balance"), euro($total['solde_debit']), euro($total['solde_credit']), '', ''];
}
$footer[] = ['', $this->lang->line("comptes_label_balance"), $solde_deb, $solde_cred, '', ''];
if ($general) {
$fields = array ( 'codec', 'nom', 'solde_debit', 'solde_credit' );
$res = array();
foreach ($select_result as $row) {
//var_dump($row);
$row['nom'] = anchor(base_url() . 'index.php' . '/comptes/page/' . $row['codec'], $row['nom']);
$res[] = $row;
}
$select_result = $res;
} else {
$fields = array ( 'codec', 'id', 'solde_debit', 'solde_credit' );
}
$attrs = array(
'controller' => $controller,
'actions' => array ('edit', 'delete'),
'mode' => ($has_modification_rights && ! $general) ? "rw" : "ro",
'footer' => $footer,
'fields' => $fields,
'class' => "datatable table table-striped");
echo $this->gvvmetadata->table("vue_comptes", $attrs, $select_result, "");
$csv_url = "$controller/balance_csv";
$pdf_url = "$controller/balance_pdf";
if (isset($codec)) {
$csv_url .= "/$codec";
$pdf_url .= "/$codec";
if (isset($codec2)) {
$csv_url .= "/$codec2";
$pdf_url .= "/$codec2";
}
}
$bar = array(
array('label' => "Excel", 'url' => $csv_url, 'role' => 'ca'),
array('label' => "Pdf", 'url' => $pdf_url, 'role' => 'ca'),
);
echo button_bar4($bar);
echo br(2);
echo p($this->lang->line("comptes_warning"));
//echo "? " . $this->session->userdata('return_url');
echo '
';
?>