<?php /* Smarty version 2.6.19, created on 2024-06-15 03:31:20
         compiled from /www/exchange2/exchange/admin/templates/reports/accounts_journal/v2/xero_journals_xlsx.html */ ?>
<?php require_once(SMARTY_CORE_DIR . 'core.load_plugins.php');
smarty_core_load_plugins(array('plugins' => array(array('modifier', 'htmlentities', '/www/exchange2/exchange/admin/templates/reports/accounts_journal/v2/xero_journals_xlsx.html', 13, false),)), $this); ?>
<?php $this->assign('row_index', 2); ?>
<?php $this->assign('ledger_index', 2); ?>

<?php $_from = $this->_tpl_vars['xero_ledgers']; if (!is_array($_from) && !is_object($_from)) { settype($_from, 'array'); }if (count($_from)):
    foreach ($_from as $this->_tpl_vars['index'] => $this->_tpl_vars['ledger_list']):
?>
<?php $_from = $this->_tpl_vars['ledger_list']['values']; if (!is_array($_from) && !is_object($_from)) { settype($_from, 'array'); }if (count($_from)):
    foreach ($_from as $this->_tpl_vars['list_index'] => $this->_tpl_vars['ledger_code']):
?>
<tr>
    <td>=TEXT(System!O6,"yyyy-mm-dd")&amp;"  Weekly Trade Journals - W"&amp;WEEKNUM(System!O6,2)</td>
    <td>=System!O6</td>
    <td>="<?php echo $this->_tpl_vars['ledger_code']['2']; ?>
  W"&amp;WEEKNUM(System!O6,2)&amp;".<?php echo $this->_tpl_vars['ledger_list']['details']['group_index']; ?>
"</td>
    <td><?php echo $this->_tpl_vars['ledger_code']['1']; ?>
</td>
    <td>Tax Exempt (0%)</td>
    <td>=INDIRECT("System!H"&amp;MATCH(G<?php echo $this->_tpl_vars['row_index']; ?>
,System!B:B,0) + <?php echo $this->_tpl_vars['ledger_index']; ?>
)</td>
    <td><?php echo ((is_array($_tmp=$this->_tpl_vars['ledger_list']['details']['title'])) ? $this->_run_mod_handler('htmlentities', true, $_tmp) : htmlentities($_tmp)); ?>
</td>
</tr>
<?php $this->assign('row_index', $this->_tpl_vars['row_index']+1); ?>
<?php $this->assign('ledger_index', $this->_tpl_vars['ledger_index']+1); ?>
<?php endforeach; endif; unset($_from); ?>
<?php $this->assign('ledger_index', 2); ?>
<?php endforeach; endif; unset($_from); ?>
<?php $this->assign('row_index', $this->_tpl_vars['row_index']-1); ?>
<tr>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
    <td>Balance :</td>
    <td>=SUM(F2:F<?php echo $this->_tpl_vars['row_index']; ?>
)</td>
    <td></td>
</tr>