Exemplo n.º 1
0
     $reconciliation_dr_total = 0;
 }
 /* Reconciliation Balance - Cr */
 $this->db->select_sum('amount', 'crtotal')->from('entry_items')->join('entries', 'entries.id = entry_items.entry_id')->where('entry_items.ledger_id', $ledger_id)->where('entry_items.dc', 'C')->where('entry_items.reconciliation_date IS NOT NULL');
 $cr_total_q = $this->db->get();
 if ($cr_total = $cr_total_q->row()) {
     $reconciliation_cr_total = $cr_total->crtotal;
 } else {
     $reconciliation_cr_total = 0;
 }
 $reconciliation_total = $reconciliation_dr_total - $reconciliation_cr_total;
 $reconciliation_pending = $clbalance - $reconciliation_total;
 /* Ledger and Reconciliation Summary */
 echo "<table class=\"reconciliation-summary\">";
 echo "<tr>";
 echo "<td><b>Opening Balance</b></td><td>" . convert_opening($opbalance, $optype) . "</td>";
 echo "<td width=\"20px\"></td>";
 echo "<td><b>Reconciliation Pending</b></td><td>" . convert_amount_dc($reconciliation_pending) . "</td>";
 echo "</tr>";
 echo "<tr>";
 echo "<td><b>Closing Balance</b></td><td>" . convert_amount_dc($clbalance) . "</td>";
 echo "<td width=\"20px\"></td>";
 echo "<td><b>Reconciliation Total</b></td><td>" . convert_amount_dc($reconciliation_total) . "</td>";
 echo "</tr>";
 echo "</table>";
 echo "<br />";
 if (!$print_preview) {
     $this->db->select('entries.id as entries_id, entries.number as entries_number, entries.date as entries_date, entries.narration as entries_narration, entries.entry_type as entries_entry_type, entry_items.id as entry_items_id, entry_items.amount as entry_items_amount, entry_items.dc as entry_items_dc, entry_items.reconciliation_date as entry_items_reconciliation_date');
     if ($reconciliation_type == 'all') {
         $this->db->from('entries')->join('entry_items', 'entries.id = entry_items.entry_id')->where('entry_items.ledger_id', $ledger_id)->order_by('entries.date', 'asc')->order_by('entries.number', 'asc')->limit($pagination_counter, $page_count);
     } else {
Exemplo n.º 2
0
echo "<table border=0 cellpadding=5 class=\"simple-table trial-balance-table\">";
echo "<thead><tr><th>Ledger Account</th><th>O/P Balance</th><th>C/L Balance</th><th>Dr Total</th><th>Cr Total</th></tr></thead>";
$this->load->model('Ledger_model');
$all_ledgers = $this->Ledger_model->get_all_ledgers();
$odd_even = "odd";
foreach ($all_ledgers as $ledger_id => $ledger_name) {
    if ($ledger_id == 0) {
        continue;
    }
    echo "<tr class=\"tr-" . $odd_even . "\">";
    echo "<td>";
    echo anchor('report/ledgerst/' . $ledger_id, $ledger_name, array('title' => $ledger_name . ' Ledger Statement', 'class' => 'anchor-link-a'));
    echo "</td>";
    echo "<td>";
    list($opbal_amount, $opbal_type) = $this->Ledger_model->get_op_balance($ledger_id);
    echo convert_opening($opbal_amount, $opbal_type);
    echo "</td>";
    echo "<td>";
    $clbal_amount = $this->Ledger_model->get_ledger_balance($ledger_id);
    echo convert_amount_dc($clbal_amount);
    echo "</td>";
    echo "<td>";
    $dr_total = $this->Ledger_model->get_dr_total($ledger_id);
    if ($dr_total) {
        echo $dr_total;
        $temp_dr_total += $dr_total;
    } else {
        echo "0";
    }
    echo "</td>";
    echo "<td>";
Exemplo n.º 3
0
 function account_st_main($c = 0)
 {
     $this->counter = $c;
     if ($this->id != 0) {
         echo "<tr class=\"tr-group\">";
         echo "<td class=\"td-group\">";
         echo $this->print_space($this->counter);
         if ($this->id <= 4) {
             echo "&nbsp;<strong>" . $this->name . "</strong>";
         } else {
             echo "&nbsp;" . $this->name;
         }
         echo "</td>";
         echo "<td>Group Account</td>";
         echo "<td>-</td>";
         echo "<td>-</td>";
         if ($this->id <= 4) {
             echo "<td class=\"td-actions\"></tr>";
         } else {
             echo "<td class=\"td-actions\">" . anchor('group/edit/' . $this->id, "Edit", array('title' => 'Edit Group', 'class' => 'red-link'));
             echo " &nbsp;" . anchor('group/delete/' . $this->id, img(array('src' => asset_url() . "images/icons/delete.png", 'border' => '0', 'alt' => 'Delete group')), array('class' => "confirmClick", 'title' => "Delete Group")) . "</td>";
         }
         echo "</tr>";
     }
     foreach ($this->children_groups as $id => $data) {
         $this->counter++;
         $data->account_st_main($this->counter);
         $this->counter--;
     }
     if (count($this->children_ledgers) > 0) {
         $this->counter++;
         foreach ($this->children_ledgers as $id => $data) {
             echo "<tr class=\"tr-ledger\">";
             echo "<td class=\"td-ledger\">";
             echo $this->print_space($this->counter);
             echo "&nbsp;" . anchor('report/ledgerst/' . $data['id'], $data['name'], array('title' => $data['name'] . ' Ledger Statement', 'style' => 'color:#000000'));
             echo "</td>";
             echo "<td>Ledger Account</td>";
             echo "<td>" . convert_opening($data['opbalance'], $data['optype']) . "</td>";
             echo "<td>" . convert_amount_dc($data['total']) . "</td>";
             echo "<td class=\"td-actions\">" . anchor('ledger/edit/' . $data['id'], 'Edit', array('title' => "Edit Ledger", 'class' => 'red-link'));
             echo " &nbsp;" . anchor('ledger/delete/' . $data['id'], img(array('src' => asset_url() . "images/icons/delete.png", 'border' => '0', 'alt' => 'Delete Ledger')), array('class' => "confirmClick", 'title' => "Delete Ledger")) . "</td>";
             echo "</tr>";
         }
         $this->counter--;
     }
 }
Exemplo n.º 4
0
 function print_tree($account_tree)
 {
     self::$counter++;
     foreach ($account_tree as $row) {
         if ($row['id'] > 0) {
             echo "<tr class=\"tr-group\">";
             if ($row['id'] <= 4) {
                 echo "<td><strong>" . self::print_spaces(self::$counter) . $row['name'] . "</strong></td>";
                 echo "<td>Group</td>";
                 echo "<td>-</td>";
                 echo "<td>-</td>";
                 echo "<td class=\"td-actions\">";
                 echo "</td>";
                 echo "</tr>";
             } else {
                 echo "<td>" . self::print_spaces(self::$counter) . $row['name'] . "</td>";
                 echo "<td>Group</td>";
                 echo "<td>-</td>";
                 echo "<td>-</td>";
                 echo "<td class=\"td-actions\">" . anchor('group/edit/' . $row['id'], "Edit", array('title' => 'Edit Group', 'class' => 'red-link'));
                 echo " &nbsp;" . anchor('group/delete/' . $row['id'], img(array('src' => asset_url() . "images/icons/delete.png", 'border' => '0', 'alt' => 'Delete Group')), array('class' => "confirmClick", 'title' => "Delete Group")) . "</td>";
                 echo "</tr>";
             }
         }
         if ($row['sub_ledgers']) {
             self::$counter++;
             foreach ($row['sub_ledgers'] as $row_item) {
                 echo "<tr>";
                 echo "<td>" . self::print_spaces(self::$counter) . $row_item['name'] . "</td>";
                 echo "<td>Ledger</td>";
                 echo "<td>" . convert_opening($row_item['op_balance'], $row_item['op_balance_dc']) . "</td>";
                 echo "<td>" . convert_amount_dc($row_item['cl_balance']) . "</td>";
                 echo "<td class=\"td-actions\">" . anchor('ledger/edit/' . $row_item['id'], "Edit", array('title' => 'Edit Ledger', 'class' => 'red-link'));
                 echo " &nbsp;" . anchor('ledger/delete/' . $row_item['id'], img(array('src' => asset_url() . "images/icons/delete.png", 'border' => '0', 'alt' => 'Delete Ledger')), array('class' => "confirmClick", 'title' => "Delete Ledger")) . "</td>";
                 echo "</tr>";
             }
             self::$counter--;
         }
         if ($row['sub_groups']) {
             foreach ($row['sub_groups'] as $row_item) {
                 self::print_tree($row_item);
             }
         }
     }
     self::$counter--;
 }
Exemplo n.º 5
0
     $page_count = 0;
     $this->db->select('entries.id as entries_id, entries.number as entries_number, entries.date as entries_date, entries.narration as entries_narration, entries.entry_type as entries_entry_type, entry_items.amount as entry_items_amount, entry_items.dc as entry_items_dc');
     $this->db->from('entries')->join('entry_items', 'entries.id = entry_items.entry_id')->where('entry_items.ledger_id', $ledger_id)->order_by('entries.date', 'asc')->order_by('entries.number', 'asc');
     $ledgerst_q = $this->db->get();
 }
 echo "<table border=0 cellpadding=5 class=\"simple-table ledgerst-table\">";
 echo "<thead><tr><th>Date</th><th>No.</th><th>Ledger Name</th><th>Type</th><th>Dr Amount</th><th>Cr Amount</th><th>Balance</th></tr></thead>";
 $odd_even = "odd";
 $cur_balance = 0;
 if ($page_count <= 0) {
     /* Opening balance */
     if ($optype == "D") {
         echo "<tr class=\"tr-balance\"><td colspan=6>Opening Balance</td><td>" . convert_opening($opbalance, $optype) . "</td></tr>";
         $cur_balance = float_ops($cur_balance, $opbalance, '+');
     } else {
         echo "<tr class=\"tr-balance\"><td colspan=6>Opening Balance</td><td>" . convert_opening($opbalance, $optype) . "</td></tr>";
         $cur_balance = float_ops($cur_balance, $opbalance, '-');
     }
 } else {
     /* Opening balance */
     if ($optype == "D") {
         $cur_balance = float_ops($cur_balance, $opbalance, '+');
     } else {
         $cur_balance = float_ops($cur_balance, $opbalance, '-');
     }
     /* Calculating previous balance */
     $this->db->select('entries.id as entries_id, entries.number as entries_number, entries.date as entries_date, entries.entry_type as entries_entry_type, entry_items.amount as entry_items_amount, entry_items.dc as entry_items_dc');
     $this->db->from('entries')->join('entry_items', 'entries.id = entry_items.entry_id')->where('entry_items.ledger_id', $ledger_id)->order_by('entries.date', 'asc')->order_by('entries.number', 'asc')->limit($page_count, 0);
     $prevbal_q = $this->db->get();
     foreach ($prevbal_q->result() as $row) {
         if ($row->entry_items_dc == "D") {