Пример #1
1
 public function index()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('store')->columns('name', 'owner', 'address', 'zipcode', 'city', 'state', 'country', 'telp1', 'telp2', 'fax', 'npwp', 'note')->display_as('npwp', 'NPWP')->display_as('zipcode', 'Zip Code')->display_as('telp1', 'Telp 1')->display_as('telp2', 'Telp 2')->fields('name', 'owner', 'address', 'zipcode', 'city', 'state', 'country', 'telp1', 'telp2', 'fax', 'npwp', 'note')->required_fields('name', 'owner', 'address', 'zipcode', 'city', 'state', 'country', 'telp1')->unset_read()->unset_add()->unset_delete()->callback_field('note', array($this, 'setTextarea'));
     $output = $crud->render();
     $this->render($output);
 }
Пример #2
0
 public function index($nombre_tabla = null)
 {
     $this->is_login();
     $id_grupo_usuario = (array) reset($this->ion_auth->get_users_groups($this->user->id)->result());
     // donde 1 es admin, 2 es ministerio, 3 el coordinador, 4 digitador, 5 externo
     if (in_array($id_grupo_usuario['id'], array(1, 2, 3, 4))) {
         if (!empty($nombre_tabla)) {
             // correr el procedimiento almacenado
             $this->load->model('tabla_model');
             $this->tabla_model->correr_procedimiento_almacenado($nombre_tabla);
             try {
                 $crud = new grocery_CRUD();
                 $crud->set_theme('flexigrid-inline-edit');
                 $crud->set_table($nombre_tabla);
                 // $crud->unset_edit();
                 $crud->unset_delete();
                 $output = $crud->render();
                 $this->_example_output($output);
             } catch (Exception $e) {
                 echo "el nombre de tabla no es valida";
             }
         } else {
             redirect('/', 'refresh');
         }
     } else {
         redirect('/', 'refresh');
     }
 }
Пример #3
0
 public function index()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('store')->columns('name', 'owner', 'address', 'zipcode', 'city', 'state', 'country', 'telp1', 'telp2', 'fax', 'npwp', 'note')->display_as('name', 'Nama Toko')->display_as('owner', 'Nama Pemilik')->display_as('address', 'Alamat')->display_as('zipcode', 'Kode Pos')->display_as('city', 'Kota')->display_as('state', 'Provinsi')->display_as('country', 'Negara')->display_as('npwp', 'NPWP')->display_as('note', 'Keterangan')->display_as('telp1', 'Telp 1')->display_as('telp2', 'Telp 2')->fields('name', 'owner', 'address', 'zipcode', 'city', 'state', 'country', 'telp1', 'telp2', 'fax', 'npwp', 'note')->required_fields('name', 'owner', 'address', 'zipcode', 'city', 'state', 'country', 'telp1')->unset_read()->unset_add()->unset_delete()->callback_field('note', array($this, 'setTextarea'));
     $output = $crud->render();
     $this->render($output);
 }
Пример #4
0
 public function productPlacing()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('warehouse_rack_detail')->display_as('id_rack', 'Rack Name')->display_as('id_product', 'Product Name')->columns('id_rack', 'id_product', 'stock')->set_relation('id_rack', 'warehouse_rack', 'name')->set_relation('id_product', 'product', 'name')->unset_fields('total')->callback_column('stock', array($this, 'addProductStockColumn'))->required_fields('id_rack', 'id_product')->unset_read();
     $output = $crud->render();
     $this->render($output);
 }
Пример #5
0
 public function category()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('category');
     $output = $crud->render();
     $this->_example_output($output);
 }
Пример #6
0
 public function index()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('retail')->columns('id_retail', 'date', 'id_staff', 'dpp', 'ppn', 'discount_price', 'grand_total', 'paid')->display_as('id_retail', 'No Nota Retail')->display_as('id_staff', 'Staff')->display_as('dpp', 'DPP')->display_as('ppn', 'PPN')->display_as('date', 'Tanggal Transaksi')->display_as('discount_price', 'Diskon')->display_as('pain', 'Jumlah Bayar')->display_as('grand_total', 'Grand Total')->callback_column('dpp', array($this, 'currencyFormat'))->callback_column('ppn', array($this, 'currencyFormat'))->callback_column('discount_price', array($this, 'currencyFormat'))->callback_column('grand_total', array($this, 'currencyFormat'))->callback_column('paid', array($this, 'currencyFormat'))->set_relation('id_staff', 'staff', 'name')->add_action('Detail', '', '', 'read-icon', array($this, 'checkout'))->unset_read()->unset_add()->unset_edit()->unset_delete()->order_by('id_retail', 'desc');
     $output = $crud->render();
     $this->render($output);
 }
Пример #7
0
 public function index()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('customer')->columns('name', 'alias_name1', 'alias_name2', 'owner', 'npwp', 'address', 'zipcode', 'city', 'state', 'country', 'plafond', 'telp1', 'telp2')->display_as('npwp', 'NPWP')->display_as('name', 'Nama Konsumen')->display_as('alias_name1', 'Nama Faktur 1')->display_as('alias_name2', 'Nama Faktur 2')->display_as('address', 'Alamat')->display_as('zipcode', 'Kode Pos')->display_as('city', 'Kota')->display_as('state', 'Provinsi')->display_as('country', 'Negara')->display_as('telp1', 'Telp 1')->display_as('plafond', 'Plafon')->callback_column('plafond', array($this, 'currencyFormat'))->display_as('telp1', 'Telp 1')->display_as('telp2', 'Telp 2')->display_as('owner', 'Direktur')->fields('name', 'alias_name1', 'alias_name2', 'owner', 'npwp', 'address', 'zipcode', 'city', 'state', 'country', 'plafond', 'telp1', 'telp2')->required_fields('name', 'address', 'city', 'state', 'country', 'plafond', 'telp1')->unset_read();
     $output = $crud->render();
     $this->render($output);
 }
Пример #8
0
 public function index()
 {
     try {
         // General
         $crud = new grocery_CRUD();
         $crud->set_language("french");
         $crud->set_theme('bootstrap');
         $crud->set_table('sos_gen_frequence');
         $crud->set_subject('Fréquence');
         //relations
         //Master/child relations
         //Visual
         $crud->columns('name_frequence');
         $crud->display_as('name_frequence', 'Fréquence');
         $crud->order_by('name_frequence', 'desc');
         //unsets
         //Requireds
         $crud->required_fields('name_frequence');
         //Callbacks
         //field Types
         // Actions
         // Renders
         $output = $crud->render();
         $menu = new stdClass();
         $menu->n1 = true;
         $menu->lien3_3_1 = false;
         $menu->status = $this->session->userdata('status');
         $header = $this->navigation->home_f($menu);
         $data = array('output' => $output, 'header' => $header);
         $this->_example_output($data);
     } catch (Exception $e) {
         show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
     }
 }
Пример #9
0
 public function index()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('sales_order_return')->columns('id_sales_order_return', 'date', 'id_staff', 'id_sales_order')->display_as('id_sales_order', 'No Faktur Jual')->display_as('id_staff', 'Staff')->display_as('date', 'Tanggal Transaksi')->display_as('id_sales_order_return', 'No Faktur Retur')->set_relation('id_staff', 'staff', 'name')->add_action('Detail', '', '', 'read-icon', array($this, 'checkout'))->unset_read()->unset_add()->unset_edit()->unset_delete()->order_by('id_sales_order_return', 'desc');
     $output = $crud->render();
     $this->render($output);
 }
Пример #10
0
 public function index()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('principal')->columns('name', 'email', 'address', 'zipcode', 'city', 'state', 'country', 'telp1', 'telp2', 'npwp', 'siup', 'pbf', 'pbak', 'fak')->display_as('npwp', 'NPWP')->display_as('name', 'Nama Prinsipal')->display_as('address', 'Alamat')->display_as('zipcode', 'Kode Pos')->display_as('city', 'Kota')->display_as('state', 'Provinsi')->display_as('country', 'Negara')->display_as('telp1', 'Telp 1')->display_as('telp2', 'Telp 2')->display_as('siup', 'SIUP')->display_as('pbf', 'PBF')->display_as('pbak', 'PBAK')->display_as('fak', 'FAK')->fields('name', 'email', 'address', 'zipcode', 'city', 'state', 'country', 'telp1', 'telp2', 'npwp', 'siup', 'pbf', 'pbak', 'fak')->required_fields('name', 'address', 'city', 'state', 'country', 'telp1')->set_rules('email', 'Email', 'valid_email')->unset_read();
     $output = $crud->render();
     $this->render($output);
 }
Пример #11
0
 protected function generate_crud($table, $subject = '')
 {
     // create CRUD object
     $this->load->library('Grocery_CRUD');
     $crud = new grocery_CRUD();
     $crud->set_table($table);
     // auto-generate subject
     if (empty($subject)) {
         $crud->set_subject(humanize(singular($table)));
     }
     // load settings from: application/config/grocery_crud.php
     $this->load->config('grocery_crud');
     $this->mCrudUnsetFields = $this->config->item('grocery_crud_unset_fields');
     if ($this->config->item('grocery_crud_unset_jquery')) {
         $crud->unset_jquery();
     }
     if ($this->config->item('grocery_crud_unset_jquery_ui')) {
         $crud->unset_jquery_ui();
     }
     if ($this->config->item('grocery_crud_unset_print')) {
         $crud->unset_print();
     }
     if ($this->config->item('grocery_crud_unset_export')) {
         $crud->unset_export();
     }
     if ($this->config->item('grocery_crud_unset_read')) {
         $crud->unset_read();
     }
     foreach ($this->config->item('grocery_crud_display_as') as $key => $value) {
         $crud->display_as($key, $value);
     }
     // other custom logic to be done outside
     $this->mCrud = $crud;
     return $crud;
 }
Пример #12
0
 public function old()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('sales_order')->columns('id_sales_order', 'id_proposal', 'id_customer', 'id_staff', 'date', 'due_date', 'dpp', 'ppn', 'discount_price', 'grand_total', 'status_ppn', 'paid')->display_as('id_sales_order', 'No Faktur')->display_as('id_proposal', 'No Proposal')->display_as('id_customer', 'Nama Konsumen')->display_as('id_staff', 'Staff')->display_as('date', 'Tanggal Transaksi')->display_as('due_date', 'Jatuh Tempo')->display_as('discount_price', 'Diskon')->display_as('grand_total', 'Grand Total')->display_as('status_ppn', 'Status PPN')->display_as('dpp', 'DPP')->display_as('ppn', 'PPN')->display_as('pain', 'Terbayar')->callback_column('dpp', array($this, 'currencyFormat'))->callback_column('ppn', array($this, 'currencyFormat'))->callback_column('discount_price', array($this, 'currencyFormat'))->callback_column('grand_total', array($this, 'currencyFormat'))->callback_column('paid', array($this, 'currencyFormat'))->callback_column('status_ppn', array($this, '_callback_status_ppn'))->set_relation('id_customer', 'customer', 'name')->set_relation('id_staff', 'staff', 'name')->add_action('Detail', '', '', 'read-icon', array($this, 'checkout'))->where('active', '0')->unset_read()->unset_add()->unset_edit()->unset_delete()->order_by('id_sales_order', 'desc');
     $output = $crud->render();
     $this->render($output);
 }
Пример #13
0
 public function index()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('bank_info')->columns('id_principal', 'bank_name', 'bank_account', 'bank_beneficiary_name', 'bank_city', 'bank_branch')->display_as('id_principal', 'Principal Name')->display_as('bank_name', 'Bank Name')->display_as('bank_account', 'Bank Account')->display_as('bank_beneficiary_name', 'Bank Beneficiary Name')->display_as('bank_city', 'Bank City')->display_as('bank_branch', 'Bank Branch')->set_relation('id_principal', 'principal', 'name')->fields('id_principal', 'bank_name', 'bank_account', 'bank_beneficiary_name', 'bank_city', 'bank_branch')->required_fields('id_principal', 'bank_account', 'bank_beneficiary_name')->unset_read();
     $output = $crud->render();
     $this->render($output);
 }
Пример #14
0
 function categorias()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('categorias');
     $output = $crud->render();
     $this->load->view('main/ventas', $output);
 }
Пример #15
0
 public function index()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('bank_info')->columns('id_principal', 'bank_name', 'bank_account', 'bank_beneficiary_name', 'bank_city', 'bank_branch')->display_as('id_principal', 'Nama Prinsipal')->display_as('bank_name', 'Nama Bank')->display_as('bank_account', 'No Rekening')->display_as('bank_beneficiary_name', 'Nama Rekening')->display_as('bank_city', 'Kota')->display_as('bank_branch', 'Cabang')->set_relation('id_principal', 'principal', 'name')->fields('id_principal', 'bank_name', 'bank_account', 'bank_beneficiary_name', 'bank_city', 'bank_branch')->required_fields('id_principal', 'bank_account', 'bank_beneficiary_name')->unset_read();
     $output = $crud->render();
     $this->render($output);
 }
Пример #16
0
 public function group()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('staff_group')->columns('name_group', 'note', 'jml_user')->fields('name_group', 'note')->display_as('name_group', 'Group Name')->display_as('jml_user', 'Jumlah User')->required_fields('name_group')->callback_column('jml_user', array($this, 'countJmlUser'))->callback_field('note', array($this, 'setTextarea'))->add_action('Update Role', '', '', 'read-icon', array($this, 'addUpdateRoleAction'))->unset_read();
     $output = $crud->render();
     $this->renderGroup($output);
 }
Пример #17
0
 public function index()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('purchase_order')->columns('id_purchase_order', 'id_principal', 'id_staff', 'status_ppn', 'date', 'due_date', 'total', 'dpp', 'ppn', 'discount_price', 'grand_total')->display_as('id_purchase_order', 'No Faktur')->display_as('status_ppn', 'Status PPn')->display_as('id_principal', 'Principal')->display_as('id_staff', 'Staff')->display_as('date', 'Tanggal Transaksi')->display_as('due_date', 'Jatuh Tempo')->display_as('discount_price', 'Discount')->display_as('grand_total', 'Grand Total')->callback_column('status_ppn', array($this, '_callback_status_ppn'))->callback_column('total', array($this, 'currencyFormat'))->callback_column('dpp', array($this, 'currencyFormat'))->callback_column('ppn', array($this, 'currencyFormat'))->callback_column('discount_price', array($this, 'currencyFormat'))->callback_column('grand_total', array($this, 'currencyFormat'))->set_relation('id_principal', 'principal', 'name')->set_relation('id_staff', 'staff', 'name')->add_action('Detail', '', '', 'read-icon', array($this, 'checkout'))->add_action('Attach', '\\assets\\grocery_crud\\themes\\flexigrid\\css\\images\\attachment-icon.png', '', '', array($this, 'attach_file'))->unset_read()->unset_add()->unset_edit()->unset_delete()->order_by('id_purchase_order', 'desc');
     $output = $crud->render();
     $this->render($output);
 }
Пример #18
0
 public function index()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('customer')->columns('name', 'owner', 'npwp', 'address', 'zipcode', 'city', 'state', 'country', 'plafond', 'telp1', 'telp2')->display_as('npwp', 'NPWP')->display_as('zipcode', 'Zip Code')->display_as('telp1', 'Telp 1')->display_as('telp2', 'Telp 2')->display_as('owner', 'Direktur')->fields('name', 'owner', 'npwp', 'address', 'zipcode', 'city', 'state', 'country', 'plafond', 'telp1', 'telp2')->required_fields('name', 'owner', 'npwp', 'address', 'zipcode', 'city', 'state', 'country', 'plafond', 'telp1')->unset_read();
     $output = $crud->render();
     $this->render($output);
 }
Пример #19
0
 function administracion()
 {
     if (!$this->tank_auth->is_logged_in()) {
         redirect('/auth/login/');
     }
     try {
         /* Creamos el objeto */
         $crud = new grocery_CRUD();
         /* Seleccionamos el tema */
         $crud->set_theme('flexigrid');
         /* Seleccionmos el nombre de la tabla de nuestra base de datos*/
         $crud->set_table('method');
         /* Le asignamos un nombre */
         $crud->set_subject('Metodo');
         /* Asignamos el idioma español */
         $crud->set_language('spanish');
         /* Aqui le decimos a grocery que estos campos son obligatorios */
         $crud->required_fields('MethodID', 'Description');
         /* Aqui le indicamos que campos deseamos mostrar */
         $crud->columns('MethodID', 'Description');
         $crud->display_as('MethodID', 'ID');
         $crud->display_as('Description', 'Descripci&oacuten');
         /* Generamos la tabla */
         $output = $crud->render();
         /* La cargamos en la vista situada en */
         $this->load->view('Method/administracion', $output);
     } catch (Exception $e) {
         /* Si algo sale mal cachamos el error y lo mostramos */
         show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
     }
 }
Пример #20
0
 public function index()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('proposal')->columns('id_proposal', 'date_created', 'id_customer', 'id_staff', 'status_ppn', 'type')->display_as('id_proposal', 'No Proposal')->display_as('id_customer', 'Konsumen')->display_as('id_staff', 'Staff')->display_as('date_created', 'Tanggal Pembuatan')->set_relation('id_customer', 'customer', 'name')->set_relation('id_staff', 'staff', 'name')->display_as('status_ppn', 'Status PPn')->callback_column('status_ppn', array($this, '_callback_status_ppn'))->callback_column('type', array($this, '_callback_type'))->add_action('Detail', '', '', 'read-icon', array($this, 'checkout'))->where('status', '2')->unset_read()->unset_add()->unset_edit()->unset_delete();
     $output = $crud->render();
     $this->render($output);
 }
Пример #21
0
 public function index()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('delivery_order')->columns('id_delivery_order', 'id_sales_order', 'date_printed', 'date_sending', 'id_staff')->display_as('id_delivery_order', 'No Order Kirim')->display_as('id_sales_order', 'No Faktur Jual')->display_as('id_staff', 'Staff Pengiriman')->display_as('date_printed', 'Tanggal Pembuatan')->display_as('date_sending', 'Tanggal Pengiriman')->set_relation('id_staff', 'staff', 'name')->add_action('Detail', '', '', 'read-icon', array($this, 'checkout'))->unset_read()->unset_add()->unset_edit()->unset_delete()->order_by('id_delivery_order', 'desc');
     $output = $crud->render();
     $this->render($output);
 }
Пример #22
0
 public function unit()
 {
     $this->session->set_userdata('selected_table', 'product_unit');
     $crud = new grocery_CRUD();
     $crud->set_table('product_unit')->columns('unit', 'prefix_code', 'value', 'note')->add_fields('unit', 'prefix_code', 'value', 'note')->edit_fields('unit', 'prefix_code', 'value', 'note')->required_fields('unit', 'value', 'prefix_code')->display_as('prefix_code', 'Prefix Code')->callback_field('note', array($this, 'setTextarea'))->callback_before_insert(array($this, 'checkPrefixCode'))->unset_read();
     $output = $crud->render();
     $this->render($output);
 }
Пример #23
0
 public function group()
 {
     $crud = new grocery_CRUD();
     // roles column is just for dummy column, because GC cannot search a custom column
     $crud->set_table('staff_group')->columns('name_group', 'note', 'roles')->fields('name_group', 'note')->display_as('name_group', 'Nama Bagian')->display_as('roles', 'Jumlah Pengguna')->display_as('note', 'Keterangan')->required_fields('name_group')->callback_column('roles', array($this, 'countJmlUser'))->callback_field('note', array($this, 'setTextarea'))->add_action('Update Role', '', '', 'read-icon', array($this, 'addUpdateRoleAction'))->unset_read();
     $output = $crud->render();
     $this->renderGroup($output);
 }
Пример #24
0
 public function course_3()
 {
     $crud = new grocery_CRUD();
     $crud->set_theme('datatables');
     $crud->set_table('course_3');
     $output = $crud->render();
     $this->_example_output($output);
 }
Пример #25
0
 function viewMultiSubReport()
 {
     $id = $this->uri->segment(3);
     $crudViewMultiSubReport = new grocery_CRUD();
     $crudViewMultiSubReport->set_theme('datatables')->set_table('v_list_spj')->set_primary_key('ID', 'v_list_spj')->set_subject('List Sub Report SPJ')->where('id_perjalanan =', $id)->columns('ID', 'Nama_Staff', 'Nomor_SPT', 'Tanggal_Berangkat', 'Tanggal_Kembali', 'Subdit_Kegiatan')->add_action('SPPD', '../../assets/images/pdf.png', 'report/cetakSppd')->add_action('Kwitansi', '../../assets/images/pdf.png', 'report/cetakKuitansi')->callback_column('Tanggal_Berangkat', array($this, 'day'))->callback_column('Tanggal_Kembali', array($this, 'day'))->unset_export()->unset_delete()->unset_add()->unset_edit()->unset_read()->unset_print();
     $outputViewMultiSubReport = $crudViewMultiSubReport->render();
     $this->_sub_report_output($outputViewMultiSubReport);
 }
Пример #26
0
 public function getClinicsInfo()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('clinics');
     $crud->columns('name', 'address', 'phone', 'description', 'review', 'birthRateLess35', 'birthRate35To40', 'birthRateMore40', 'services');
     $output = $crud->render();
     $this->_example_output($output);
 }
Пример #27
0
 public function sifatSurat()
 {
     $crud = new grocery_CRUD();
     $crud->set_table('sifatSurat');
     //$crud->columns('nomorSurat','perihal','tanggal');
     $output = $crud->render();
     $this->_outputs($output);
 }
Пример #28
0
 public function index()
 {
     $crud = new grocery_CRUD();
     $crud->set_subject('Home');
     $crud->set_table('tbl_dokter');
     $output = $crud->render();
     $this->load->view('vhome.php', $output);
 }
Пример #29
0
 public function debitAlert()
 {
     $crud = new grocery_CRUD();
     $where = "((SELECT DATEDIFF(sales_order.`due_date`, '{$this->curDate}') AS days) < 14) AND (sales_order.`due_date` > '{$this->curDate}') AND (sales_order.`status_paid` = 0)";
     $crud->where($where)->order_by('due_date', 'asc')->set_table('sales_order')->columns('id_sales_order', 'id_customer', 'date', 'due_date', 'grand_total', 'paid', 'debit')->display_as('id_sales_order', 'No Faktur')->display_as('name', 'Nama Pelanggan')->display_as('date', 'Tanggal Transaksi')->display_as('due_date', 'Jatuh Tempo')->display_as('grand_total', 'Tagihan')->display_as('paid', 'Terbayar')->display_as('debit', 'Piutang')->callback_column('debit', array($this, 'getBalance'))->callback_column('grand_total', array($this, 'currencyFormat'))->callback_column('paid', array($this, 'currencyFormat'))->set_relation('id_customer', 'customer', 'name')->unset_operations();
     $extra = 'Informasi Tagihan Piutang';
     $output = $crud->render($extra);
     $this->render($output);
 }
Пример #30
0
 public function index()
 {
     $crud = new grocery_CRUD();
     $crud->set_theme('flexigrid');
     $crud->set_table('reviews');
     $output = $crud->render();
     $data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Reviews', 'pagedesc' => 'Reviews');
     $this->load->view('gc_admin_wrapper', $data);
 }