function browse($purchase_order_number) { $sql = "select p.no_bukti,p.date_paid,p.how_paid,p.how_paid_account_id,\n\t\tp.amount_paid,p.paid_by,p.check_number\n\t\tfrom payables_payments p \n\t\twhere purchase_order_number='{$purchase_order_number}'"; $this->load->helper('browse_helper'); return browse_simple($sql, "Data Pembayaran", 500, 300, "dgPay"); }
function index() { echo "\n <link rel=\"stylesheet\" type=\"text/css\" href=\"" . base_url() . "js/jquery-ui/themes/default/easyui.css\">\n <link rel=\"stylesheet\" type=\"text/css\" href=\"" . base_url() . "js/jquery-ui/themes/icon.css\">\n <link rel=\"stylesheet\" type=\"text/css\" href=\"" . base_url() . "js/jquery-ui/themes/demo.css\">\n <script src=\"" . base_url() . "js/jquery/jquery-1.8.0.min.js\"></script> \n <script src=\"" . base_url() . "js/jquery-ui/jquery.easyui.min.js\"></script> \n "; $sql = "select customer_number,company,phone,city,country,street from customers"; echo browse_simple($sql); }
function view($id, $message = null) { $id = urldecode($id); $inventory = $this->inventory_model->get_by_id($id)->row(); $data = $this->set_defaults($inventory); $data['id'] = $id; $data['mode'] = 'view'; $data['message'] = $message; $sql = "select q.item_number,i.description,q.gudang,sum(q.qty_masuk)-sum(q.qty_keluar) as quantity \n\t\t\t\tfrom qry_kartustock_union q left join inventory i on i.item_number=q.item_number \n\t\t\t\twhere q.item_number='{$id}' \t\t\n\t\t\t\tgroup by q.item_number,i.description,q.gudang "; $data['qty_gudang'] = browse_simple($sql); $data['inventory_account'] = account($data['inventory_account']); $data['sales_account'] = account($data['sales_account']); $data['cogs_account'] = account($data['cogs_account']); $data['tax_account'] = account($data['tax_account']); $this->template->display_form_input($this->file_view, $data, ''); }
function view_jurnal($gl_id) { $gl_id = urldecode($gl_id); $sql = "select account,account_description\n\t\t,debit,credit,custsuppbank as ref,org_id,transaction_id as id from gl_transactions g\n\t\tleft join chart_of_accounts c on c.id=g.account_id\n\t\twhere gl_id='{$gl_id}'"; $s = "\n\t\t\t<link rel=\"stylesheet\" type=\"text/css\" href=\"" . base_url() . "js/jquery-ui/themes/default/easyui.css\">\n\t\t\t<link rel=\"stylesheet\" type=\"text/css\" href=\"" . base_url() . "js/jquery-ui/themes/icon.css\">\n\t\t\t<link rel=\"stylesheet\" type=\"text/css\" href=\"" . base_url() . "js/jquery-ui/themes/demo.css\">\n\t\t\t<script src=\"" . base_url() . "js/jquery-ui/jquery.easyui.min.js\"></script> \n\t\t"; echo $s . " " . browse_simple($sql); }
function list_by_invoice($invoice) { $invoice = urldecode($invoice); $s = "\n\t\t<link rel=\"stylesheet\" type=\"text/css\" href=\"" . base_url() . "js/jquery-ui/themes/default/easyui.css\">\n\t\t<link rel=\"stylesheet\" type=\"text/css\" href=\"" . base_url() . "js/jquery-ui/themes/icon.css\">\n\t\t<link rel=\"stylesheet\" type=\"text/css\" href=\"" . base_url() . "js/jquery-ui/themes/demo.css\">\n\t\t<script src=\"" . base_url() . "js/jquery-ui/jquery.easyui.min.js\"></script> \n\t\t"; $this->load->model('payables_model'); $bill_id = $this->payables_model->get_bill_id($invoice); echo $s . browse_simple('select no_bukti,date_paid,how_paid,how_paid_account_id, amount_paid,line_number,bill_id from payables_payments where bill_id=' . $bill_id); }
function browse($nomor) { $sql = "select p.item_number,i.description,p.quantity \n\t,p.unit,p.price,p.discount,p.total_price,coa.account,coa.account_description,p.line_number\n\tfrom purchase_order_lineitems p\n\tleft join inventory i on i.item_number=p.item_number\n\tleft join chart_of_accounts coa on coa.id=p.inventory_account\n\twhere purchase_order_number='{$nomor}'"; $this->load->helper('browse_helper'); return browse_simple($sql, "Data Barang / Jasa", 500, 300, "dgItem"); }
function view_receive($purchase_order_number) { $purchase_order_number = urldecode($purchase_order_number); $this->load->model('inventory_products_model'); $sql = "select distinct shipment_id,\n date_received,warehouse_code,receipt_by \n from inventory_products\n where receipt_type='PO' \n and purchase_order_number='{$purchase_order_number}'"; //$data['list_receive']=$this->inventory_products_model->list_receive($purchase_order_number); $data['list_receive'] = browse_simple($sql, "Daftar Penerimaan atas nomor po [" . $purchase_order_number . "]", 400, 0, "dgItem", "cmdButtons"); $po = $this->purchase_order_model->get_by_id($purchase_order_number)->row(); $data['supplier_number'] = $po->supplier_number; $data['supplier_info'] = $this->supplier_model->info($po->supplier_number); $data['purchase_order_number'] = $purchase_order_number; $this->template->display('purchase/list_receive', $data); }
function view_detail($nomor) { $sql = "select ip.item_number,i.description,ip.quantity_received as qty\n ,ip.unit,ip.cost,ip.id\n from inventory_products ip\n left join inventory i on i.item_number=ip.item_number\n where shipment_id='{$nomor}'"; $s = "\n <link rel=\"stylesheet\" type=\"text/css\" href=\"" . base_url() . "js/jquery-ui/themes/default/easyui.css\">\n <link rel=\"stylesheet\" type=\"text/css\" href=\"" . base_url() . "js/jquery-ui/themes/icon.css\">\n <link rel=\"stylesheet\" type=\"text/css\" href=\"" . base_url() . "js/jquery-ui/themes/demo.css\">\n <script src=\"" . base_url() . "js/jquery-ui/jquery.easyui.min.js\"></script> \n "; echo $s . " " . browse_simple($sql); }
function view_delivery($sales_order_number) { $this->load->model('invoice_model'); $sql = "select distinct invoice_number as nomor_surat_jalan,\n\t\t\tinvoice_date as tanggal,sales_order_number,warehouse_code \n\t\t\tfrom invoice\n\t\t\twhere invoice_type='D' \n\t\t\tand sales_order_number='{$sales_order_number}'"; $data['list_delivery'] = browse_simple($sql, "Daftar Pengiriman atas nomor sales order [" . $sales_order_number . "]", 400, 0, "dgItem", "cmdButtons"); $sales = $this->sales_order_model->get_by_id($sales_order_number)->row(); $data['sold_to_customer'] = $sales->sold_to_customer; $data['customer_info'] = $this->customer_model->info($sales->sold_to_customer); $data['sales_order_number'] = $sales_order_number; $this->template->display('sales/list_delivery', $data); }
function browse($nomor) { $sql = "select p.item_number,i.description,p.quantity \n\t,p.unit,p.price,p.discount,p.amount,coa.account,coa.account_description,p.line_number\n\tfrom invoice_lineitems p\n\tleft join inventory i on i.item_number=p.item_number\n\tleft join chart_of_accounts coa on coa.id=p.revenue_acct_id\n\twhere invoice_number='{$nomor}'"; $this->load->helper('browse_helper'); return browse_simple($sql, "Data Barang / Jasa", 700, null, "dgItem"); }
function view($id, $message = null) { $id = urldecode($id); $inventory = $this->inventory_model->get_by_id($id)->row(); $data = $this->set_defaults($inventory); $data['id'] = $id; $data['mode'] = 'view'; $data['message'] = $message; $sql = "select q.item_number,i.description,q.gudang,sum(q.qty_masuk)-sum(q.qty_keluar) as quantity \n \t\tfrom qry_kartustock_union q left join inventory i on i.item_number=q.item_number \n\t\twhere q.item_number='{$id}' \t\t\n \t\tgroup by q.item_number,i.description,q.gudang "; $data['qty_gudang'] = browse_simple($sql); $data['inventory_account'] = account($data['inventory_account']); $data['sales_account'] = account($data['sales_account']); $data['cogs_account'] = account($data['cogs_account']); $data['tax_account'] = account($data['tax_account']); $data['quantity_in_stock'] = $this->inventory_model->quantity_in_stock($id); $supp_name = ""; if ($query = $this->db->query("select supplier_name \n\t\t from suppliers where supplier_number='" . $inventory->supplier_number . "'")) { if ($row = $query->row()) { $supp_name = $row->supplier_name; } } $data['supplier_name'] = $supp_name; $this->session->set_userdata('_right_menu', 'inventory/inventory_menu'); $this->template->display_form_input($this->file_view, $data, ''); }
function crdb($cmd, $faktur) { if ($cmd == "list") { $sql = "select c.kodecrdb,c.tanggal,c.transtype,c.amount,c.keterangan\n\t from crdb_memo c\n\t where c.docnumber='{$faktur}'"; $table = browse_simple($sql, 'Daftar Cr Dr Memo', 600, 600, 'dgCrDb'); $btn = link_button("Addnew", "addnew_crdb()", "edit"); $btn .= link_button("Remove", "remove_crdb()", "remove"); $btn .= link_button("Refresh", "refresh_crdb()", "ok"); $scr = "\n\t\t\t\t<script src=\"" . base_url() . "js/jquery/jquery-1.8.0.min.js\"></script>\n\t\t\t\t<script src=\"" . base_url() . "js/jquery-ui/jquery.easyui.min.js\"></script>\n\t\t\t"; echo $btn . $table; } }
function view_detail($nomor) { $nomor = urldecode($nomor); $sql = "select p.item_number,i.description,p.quantity \n ,p.unit,p.price,p.amount,p.line_number\n from invoice_lineitems p\n left join inventory i on i.item_number=p.item_number\n where invoice_number='{$nomor}'"; echo browse_simple($sql); }
function browse_sql($sql) { $data['message'] = ''; $data['library_src'] = $this->library_src; $data['script_head'] = $this->script_head; $fm = $this->_ci->session->userdata('_left_menu'); $data['_left_menu'] = $fm == '' ? '' : $this->_ci->load->view($fm, $data, true); $fm = $this->_ci->session->userdata('_right_menu'); $data['_right_menu'] = $fm == '' ? '' : $this->_ci->load->view($fm, $data, true); $data['_header'] = $this->_ci->load->view('template/standard/header', $data, true); $data['_footer'] = $this->_ci->load->view('template/standard/footer', $data, true); $data['_content'] = browse_simple($sql); $this->_ci->load->view('template/standard/template.php', $data); }