public function get_list() { if ($this->input->is_ajax_request() && $this->input->post()) { $data_post = $this->input->post(); // $search = $data_post['search']; $limit = $data_post['length']; $offset = $data_post['start']; $columns = $data_post['columns']; $order_arr = $data_post['order']; $order_direction = strtoupper($order_arr[0]['dir']); $order_column = $order_arr[0]['column']; $order_column = $columns[$order_column]['data']; $data = $this->journals_model->get_list($data_post, $order_column, $order_direction, $limit, $offset); $json['data'] = array(); $i = $offset + 1; foreach ($data['rows'] as $row) { $journals_id = encode($row->journals_id); $row->no = $i++; $row->journals_date = sql_to_human($row->journals_date); $row->debit_txt = format_idr_currency($row->debit); $row->credit_txt = format_idr_currency($row->credit); $edit_url = base_url("accounting/journals/edit/{$journals_id}"); $row->action = "<button onclick='doEdit(\"{$edit_url}\")' title='Edit' class='btn btn-xs btn-success edit_btn')'><i class='fa fa-pencil'></i></button>\n <button title='Hapus' class='btn btn-xs btn-default' onclick='doDelete(\"{$journals_id}\", \"{$row->account_name}\")'><i class='fa fa-remove'></i></button>"; // $row->invoice = anchor("journals/view/{$journals_id}", $row->invoice, 'title="Klik untuk lebih lengkap" target="_blank"'); array_push($json['data'], $row); } $json['recordsTotal'] = $data['total']; $json['recordsFiltered'] = $data['total']; $json['draw'] = $data_post['draw']; echo json_encode($json); } else { echo 'Forbidden access!'; } }
public function print_report() { // error_reporting(0); $rows = $this->trial_balance_model->get_list($this->input->get()); if (count($rows) == 0) { echo "<script>alert('Tidak ada data!');close();</script>"; exit; } $data['rows'] = array(); $i = 1; foreach ($rows as $row) { $row->no = $i++; $row->debit_txt = '0'; $row->credit_txt = '0'; $saldo = $row->debit - $row->credit; if ($saldo > 0) { $row->debit_txt = format_idr_currency($saldo); $row->debit = $saldo; $row->credit = 0; } else { if ($saldo < 0) { $row->credit_txt = format_idr_currency(abs($saldo)); $row->debit = 0; $row->credit = abs($saldo); } else { $row->debit = 0; $row->credit = 0; } } array_push($data['rows'], $row); } $data['company_name'] = $this->_get_company_name(); $data['company_address'] = $this->_get_company_address(); $month = month_indo($this->input->get('month')); $data['period'] = $month . ' ' . $this->input->get('year'); $html = $this->load->view('trial_balance/print', $data, true); $this->load->library('tumbaspdf'); $title = "Neraca Saldo {$data['period']}"; $this->tumbaspdf->set_author("{$data['company_name']} - {$this->_user_name}"); $this->tumbaspdf->generate_pdf($html, $title); }
$credit_total = 0; foreach ($rows as $value) { echo "\n <tr>\n <td style='text-align:center'>{$no}</td>\n <td>" . sql_to_human($value->journals_date) . "</td>\n <td>{$value->transaction_id}</td>\n <td>{$value->account_no}</td>\n <td>{$value->account_name}</td>\n <td>{$value->remark}</td>\n <td style='text-align:right'>" . format_idr_currency($value->debit) . "</td>\n <td style='text-align:right'>" . format_idr_currency($value->credit) . "</td>\n </tr>\n "; $no++; $debit_total += $value->debit; $credit_total += $value->credit; } ?> <tr> <th colspan="6" class="right">Total</th> <th class="right"><?php echo format_idr_currency($debit_total); ?> </th> <th class="right"><?php echo format_idr_currency($credit_total); ?> </th> </tr> </table> <!-- <page_footer> <table style="width: 100%; font-size: 10px;" class="table_no_border"> <tr> <td style="width: 33%"><?php echo $buying->invoice; ?> </td> <td style="width: 34%" class="center"> [[page_cu]]/[[page_nb]] </td> <td style="width: 33%" class="right"><?php echo date('d M Y H:i:s'); ?>
echo "\n <tr>\n <td class='text-center'><button title='Hapus Baris' type='button' class='btn btn-xs btn-success' onclick='removeRow(this);'><i class='fa fa-minus'></i></button></td>\n <td>\n <select name='account_id[]' class='form-control account_id' onchange='changeAccount({$row_id})' id='account-id-{$row_id}'>\n <option value=''>- Pilih -</option>\n {$options}\n </select>\n </td>\n <td><input type='text' name='debit[]' id='debit-{$row_id}' class='form-control currency debit' onkeyup='doDebit({$row_id})' value='{$value->debit}'></td>\n <td><input type='text' name='credit[]' id='credit-{$row_id}' class='form-control currency credit' onkeyup='doCredit({$row_id})' value='{$value->credit}'></td>\n </tr>\n "; $row_id++; $total_debit += $value->debit; $total_credit += $value->credit; } ?> </tbody> <tfoot> <tr> <th colspan="2" class="text-right">Total</th> <th class="text-right"><span id="debit-total"><?php echo format_idr_currency($total_debit); ?> </span></th> <th class="text-right"><span id="credit-total"><?php echo format_idr_currency($total_credit); ?> </span></th> </tr> </tfoot> </table> </div> </div> <!--End table--> </div> <div class="box-footer text-right"> <button type="submit" class="btn btn-success" id="save_btn" data-loading-text="<i class='fa fa-refresh fa-spin'></i> Menyimpan..."><i class="fa fa-check"></i> Simpan</button> <button type="button" class="btn btn-default" id="close_btn"><i class="fa fa-close"></i> Tutup</button> </div> </form>
public function print_report() { // error_reporting(0); $label_account = ''; if ($this->input->get('account_id') == '0') { //all acount $view = 'ledger/print_all'; $rows = $this->ledger_model->get_report($this->input->get('month'), $this->input->get('year')); } else { //per account $view = 'ledger/print'; $rows = $this->ledger_model->get_report($this->input->get('month'), $this->input->get('year'), $this->input->get('account_id')); $label_account = "{$rows[0]->account_no} {$rows[0]->account_name}"; } if (count($rows) == 0) { echo "<script>alert('Tidak ada data!');close();</script>"; exit; } $saldo = 0; $data['rows'] = array(); $i = 1; $current_account_id = 0; foreach ($rows as $row) { if ($current_account_id != $row->account_id) { $i = 1; $saldo = 0; } $current_account_id = $row->account_id; $row->no = $i++; $row->journals_date = sql_to_human($row->journals_date); $row->debit_txt = format_idr_currency($row->debit); $row->credit_txt = format_idr_currency($row->credit); $row->saldo_debit = '0'; $row->saldo_credit = '0'; $saldo = $saldo + $row->debit - $row->credit; if ($saldo > 0) { $row->saldo_debit = format_idr_currency($saldo); } else { if ($saldo < 0) { $row->saldo_credit = format_idr_currency(abs($saldo)); } } array_push($data['rows'], $row); } $data['company_name'] = $this->_get_company_name(); $data['company_address'] = $this->_get_company_address(); $month = month_indo($this->input->get('month')); $data['period'] = $month . ' ' . $this->input->get('year'); $html = $this->load->view($view, $data, true); $this->load->library('tumbaspdf'); $title = "Buku Besar {$label_account} {$data['period']}"; $this->tumbaspdf->set_author("{$data['company_name']} - {$this->_user_name}"); $this->tumbaspdf->generate_pdf($html, $title); }
public function print_report() { // error_reporting(0); $rows = $this->worksheet_model->get_list($this->input->get()); if (count($rows) == 0) { echo "<script>alert('Tidak ada data!');close();</script>"; exit; } $data['rows'] = array(); $i = 1; foreach ($rows as $row) { $row->no = $i++; //Neraca Saldo $row->debit1_txt = '0'; $row->credit1_txt = '0'; if ($row->saldo1 > 0) { $row->debit1_txt = format_idr_currency($row->saldo1); $row->debit1 = $row->saldo1; $row->credit1 = 0; } else { if ($row->saldo1 < 0) { $row->credit1_txt = format_idr_currency(abs($row->saldo1)); $row->credit1 = abs($row->saldo1); $row->debit1 = 0; } else { $row->debit1 = 0; $row->credit1 = 0; } } //Penyesuaian $row->debit2_txt = '0'; $row->credit2_txt = '0'; if ($row->saldo2 > 0) { $row->debit2_txt = format_idr_currency($row->saldo2); $row->debit2 = $row->saldo2; $row->credit2 = 0; } else { if ($row->saldo2 < 0) { $row->credit2_txt = format_idr_currency(abs($row->saldo2)); $row->credit2 = abs($row->saldo2); $row->debit2 = 0; } else { $row->debit2 = 0; $row->credit2 = 0; } } //Neraca saldo setelah penyesuaian $row->debit3_txt = '0'; $row->credit3_txt = '0'; if ($row->saldo3 > 0) { $row->debit3_txt = format_idr_currency($row->saldo3); $row->debit3 = $row->saldo3; $row->credit3 = 0; } else { if ($row->saldo3 < 0) { $row->credit3_txt = format_idr_currency(abs($row->saldo3)); $row->credit3 = abs($row->saldo3); $row->debit3 = 0; } else { $row->debit3 = 0; $row->credit3 = 0; } } //Laba rugi $row->debit4_txt = '0'; $row->credit4_txt = '0'; if ($row->saldo4 > 0) { $row->debit4_txt = format_idr_currency($row->saldo4); $row->debit4 = $row->saldo4; $row->credit4 = 0; } else { if ($row->saldo4 < 0) { $row->credit4_txt = format_idr_currency(abs($row->saldo4)); $row->credit4 = abs($row->saldo4); $row->debit4 = 0; } else { $row->debit4 = 0; $row->credit4 = 0; } } //Neraca $row->debit5_txt = '0'; $row->credit5_txt = '0'; if ($row->saldo5 > 0) { $row->debit5_txt = format_idr_currency($row->saldo5); $row->debit5 = $row->saldo5; $row->credit5 = 0; } else { if ($row->saldo5 < 0) { $row->credit5_txt = format_idr_currency(abs($row->saldo5)); $row->credit5 = abs($row->saldo5); $row->debit5 = 0; } else { $row->debit5 = 0; $row->credit5 = 0; } } array_push($data['rows'], $row); } $data['company_name'] = $this->_get_company_name(); $data['company_address'] = $this->_get_company_address(); $month = month_indo($this->input->get('month')); $data['period'] = $month . ' ' . $this->input->get('year'); $html = $this->load->view('worksheet/print', $data, true); // $this->load->view('worksheet/print', $data); // die('nih lagiiiii'); $this->load->library('tumbaspdf'); $title = "Neraca Lajur {$data['period']}"; $this->tumbaspdf->set_author("{$data['company_name']} - {$this->_user_name}"); $this->tumbaspdf->generate_pdf($html, $title, 'L'); }
</tr> <tr> <th style="text-align:right;" colspan="9"></th> <th style="text-align:right;"><?php echo format_idr_currency($total1); ?> </th> <th style="text-align:right;"><?php echo format_idr_currency($total2); ?> </th> <th style="text-align:right;"><?php echo format_idr_currency($total3); ?> </th> <th style="text-align:right;"><?php echo format_idr_currency($total4); ?> </th> </tr> </table> <!-- <page_footer> <hr> <div style="text-align: right;"> <small><?php echo $company_address; ?> </small> </div> </page_footer>--> </page>
<th class="center">Diskon</th> <th class="center">Subtotal</th> </tr> <?php $no = 1; $grand_total = 0; foreach ($buying_item as $value) { echo "\n <tr>\n <td style='text-align:center; width: 5%;'>{$no}</td>\n <td style='width: 10%;'>{$value->item_code}</td>\n <td style='width: 40%'>{$value->item_name}</td>\n <td style='text-align:right; width: 11%;'>" . format_idr_currency($value->cost) . "</td>\n <td style='text-align:right; width: 11%;'>" . format_idr_currency($value->quantity) . "</td>\n <td style='text-align:right; width: 11%;'>" . format_idr_currency($value->discount) . "</td>\n <td style='text-align:right; width: 12%;'>" . format_idr_currency($value->total) . "</td>\n </tr>\n "; $no++; $grand_total += $value->total; } ?> <tr> <th colspan="6" class="right">Total</th> <th class="right"><?php echo format_idr_currency($grand_total); ?> </th> </tr> </table> <table class="table_no_border" style="width: 100%; margin-top: 50px"> <tr> <td class="center" style="width: 30%"> Penerima <br> <br> <br> <br> (________________) </td> <td style="width: 40%"></td>
public function print_report() { // error_reporting(0); $data = $this->input->get(); // $data['month_now'] = date('m'); // $data['year_now'] = date('Y'); //loss profit $rows = $this->financial_report_model->get_loss_profit_list($data['month'], $data['year']); $data['loss_profit'] = array(); $i = 1; foreach ($rows as $row) { $row->no = $i++; $row->debit_txt = '0'; $row->credit_txt = '0'; $saldo = $row->debit - $row->credit; if ($saldo > 0) { $row->debit_txt = format_idr_currency($saldo); $row->debit = $saldo; $row->credit = 0; } else { if ($saldo < 0) { $row->credit_txt = format_idr_currency(abs($saldo)); $row->debit = 0; $row->credit = abs($saldo); } else { $row->debit = 0; $row->credit = 0; } } array_push($data['loss_profit'], $row); } //capital change $rows = $this->financial_report_model->get_capital_changes_list($data['month'], $data['year']); $data['capital_changes'] = array(); $i = 1; foreach ($rows as $row) { $row->no = $i++; $row->debit_txt = '0'; $row->credit_txt = '0'; $saldo = $row->debit - $row->credit; if ($saldo > 0) { $row->debit_txt = format_idr_currency($saldo); $row->debit = $saldo; $row->credit = 0; } else { if ($saldo < 0) { $row->credit_txt = format_idr_currency(abs($saldo)); $row->debit = 0; $row->credit = abs($saldo); } else { $row->debit = 0; $row->credit = 0; } } array_push($data['capital_changes'], $row); } // $data['loss_profit_balance'] = $this->financial_report_model->get_loss_profit_balance($data['month_now'], $data['year_now']); // $data['loss_profit_label'] = ($data['loss_profit_balance'] > 0) ? 'Laba Bersih' : 'Rugi Bersih'; $rows = $this->financial_report_model->get_balance_list($data['month'], $data['year']); $data['balance'] = array(); $i = 1; foreach ($rows as $row) { $row->no = $i++; $row->debit_txt = '0'; $row->credit_txt = '0'; $saldo = $row->debit - $row->credit; if ($saldo > 0) { $row->debit_txt = format_idr_currency($saldo); $row->debit = $saldo; $row->credit = 0; } else { if ($saldo < 0) { $row->credit_txt = format_idr_currency(abs($saldo)); $row->debit = 0; $row->credit = abs($saldo); } else { $row->debit = 0; $row->credit = 0; } } array_push($data['balance'], $row); } if (count($data['loss_profit']) == 0) { echo "<script>alert('Tidak ada data!');close();</script>"; exit; } // $data['rows'] = array(); // $i = 1; // foreach ($rows as $row) { // $row->no = $i++; // $row->debit_txt = '0'; // $row->credit_txt = '0'; // $saldo = $row->debit - $row->credit; // if ($saldo > 0) { // $row->debit_txt = format_idr_currency($saldo); // $row->debit = $saldo; // $row->credit = 0; // } else if ($saldo < 0) { // $row->credit_txt = format_idr_currency(abs($saldo)); // $row->debit = 0; // $row->credit = abs($saldo); // } else { // $row->debit = 0; // $row->credit = 0; // } // // array_push($data['rows'], $row); // } $data['company_name'] = $this->_get_company_name(); $data['company_address'] = $this->_get_company_address(); $month = month_indo($this->input->get('month')); $data['period'] = $month . ' ' . $this->input->get('year'); $html = $this->load->view('financial_report/print', $data, true); $this->load->library('tumbaspdf'); $title = "Laporan Keuangan {$data['period']}"; $this->tumbaspdf->set_author("{$data['company_name']} - {$this->_user_name}"); $this->tumbaspdf->generate_pdf($html, $title); }