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);
}
