public function crud()
{
$crud = new grocery_CRUD();
$crud->set_theme(THEMA_CRUD);
$crud->set_table('quadra');
$crud->set_subject('Quadra');
//@todo$crud->where('situacao_id', 2); //apenas ativos
$crud->required_fields('descricao', 'tipo_quadra_id', '');
$crud->columns('id', 'descricao', 'tipo_quadra_id', 'situacao_quadra_id');
$crud->edit_fields('descricao', 'tipo_quadra_id', 'situacao_quadra_id');
$crud->add_fields('descricao', 'tipo_quadra_id', 'situacao_quadra_id');
//relacionamentos
$crud->set_relation('situacao_quadra_id', 'situacao_quadra', 'descricao');
$crud->set_relation('tipo_quadra_id', 'tipo_quadra', 'descricao');
$crud->callback_insert(array($this, 'create'));
$crud->callback_delete(array($this, 'delete'));
$contents = $crud->render();
$this->template->set('titulo', 'Manter Quadra');
$this->template->set('subtitle', 'Quadra');
$this->template->load('template_teste', 'crudpage', $contents);
}
public function crud()
{
$crud = new grocery_CRUD();
$crud->set_theme(THEMA_CRUD);
$crud->set_table('usuario');
$crud->set_subject('Usuarios');
$crud->required_fields('nome', 'login', 'email', 'tipo_usuario_id', 'situacao_id');
$crud->columns('nome', 'login', 'email', 'tipo_usuario_id', 'situacao_id');
$crud->edit_fields('nome', 'login', 'email', 'tipo_usuario_id', 'situacao_id');
$crud->add_fields('nome', 'login', 'email', 'tipo_usuario_id');
$crud->set_relation('tipo_usuario_id', 'tipo_usuario', 'descricao');
$crud->set_relation('situacao_id', 'situacao', 'descricao');
$crud->callback_insert(array($this, 'create'));
$crud->callback_delete(array($this, 'delete'));
$crud->callback_update(array($this, 'update'));
$crud->where('situacao_id', 1);
$crud->or_where('situacao_id', 2);
$contents = $crud->render();
// $this->load->view('template_crud', $contents);
$this->template->set('titulo', 'Manter Usuário');
$this->template->set('subtitle', 'Usuário');
// nome do template , nome da view
$this->template->load('template_teste', 'crudpage', $contents);
}
function main()
{
$user_login = $this->ion_auth->user()->row();
$colid = $user_login->col_id;
$userId = $user_login->user_id;
$state_id = $user_login->state_id;
$user_groups = $this->ion_auth->get_users_groups($userId)->row();
$ul_type = $user_groups->ul_type;
$user_id = $this->session->userdata('user_id');
$crud = new grocery_CRUD();
$crud->set_table('announcement');
$crud->set_subject('pengumuman');
$crud->unset_delete();
$crud->callback_delete(array($this, 'delete_ann'));
$crud->unset_columns('ann_status_push');
if ($ul_type == 'KV') {
$crud->set_primary_key('ann_id', 'announcement_college');
$crud->set_relation('user_id', 'user', 'user_name');
$crud->set_relation('ann_id', 'announcement_college', 'col_id');
$crud->set_relation_n_n('Kolej', 'announcement_college', 'college', 'ann_id', 'col_id', 'col_name');
// $crud->callback_add_field('Kolej',array($this,'add_field_kolej'));
$crud->callback_after_insert(array($this, 'insert_announcement_college'));
$crud->field_type('ann_open_date', 'date');
$crud->field_type('ann_close_date', 'date');
$crud->field_type('user_id', 'hidden', $userId);
$crud->field_type('ann_status_push', 'hidden', 1);
$crud->field_type('ann_status', 'dropdown', array('1' => 'Aktif', '0' => 'Tak Aktif'));
$crud->display_as('ann_title', 'Perkara')->display_as('ann_id', 'Id')->display_as('ann_content', 'Pengumuman')->display_as('ann_open_date', 'Tarikh Mula')->display_as('ann_close_date', 'Tarikh Akhir')->display_as('ann_status', 'Status Pengumuman')->display_as('user_id', 'Pengguna')->display_as('college', 'Kolej Vokasional');
// $crud->callback_field('ann_title',array($this,'fc_ann_tite')); - FDP
// $crud->callback_field('ann_content',array($this,'fc_ann_content')); - FDP
// $crud->callback_field('ann_open_date',array($this,'fc_ann_open_date')); - FDP
// $crud->callback_field('ann_close_date',array($this,'fc_ann_close_date')); - FDP
// $crud->callback_field('ann_status',array($this,'fc_ann_status')); - FDP
// $crud->callback_field('college',array($this,'fc_college')); - FDP
$crud->where('j7f822d59.col_id', $colid);
$crud->unset_fields('Kolej');
$crud->required_fields('ann_title', 'ann_content', 'ann_open_date', 'ann_close_date', 'ann_status');
} elseif ($ul_type == 'LP') {
$crud->set_relation('user_id', 'user', 'user_name');
$crud->set_relation_n_n('Kolej', 'announcement_college', 'college', 'ann_id', 'col_id', 'col_name');
$crud->callback_after_insert(array($this, 'insert_announcement_college'));
$crud->field_type('ann_open_date', 'date');
$crud->field_type('ann_close_date', 'date');
$crud->field_type('user_id', 'hidden', $user_id);
$crud->field_type('ann_status_push', 'hidden', 1);
$crud->field_type('ann_status', 'dropdown', array('1' => 'Aktif', '0' => 'Tak Aktif'));
$crud->display_as('ann_title', 'Perkara')->display_as('ann_content', 'Pengumuman')->display_as('ann_open_date', 'Tarikh Mula')->display_as('ann_close_date', 'Tarikh Akhir')->display_as('ann_status', 'Status Pengumuman')->display_as('user_id', 'Pengguna')->display_as('college', 'Kolej Vokasional');
// $crud->callback_field('ann_title',array($this,'fc_ann_tite')); - FDP
// $crud->callback_field('ann_content',array($this,'fc_ann_content')); - FDP
// $crud->callback_field('ann_open_date',array($this,'fc_ann_open_date')); - FDP
// $crud->callback_field('ann_close_date',array($this,'fc_ann_close_date')); - FDP
// $crud->callback_field('ann_status',array($this,'fc_ann_status')); - FDP
// $crud->callback_field('college',array($this,'fc_college')); - FDP
$crud->required_fields('ann_title', 'ann_content', 'ann_open_date', 'ann_close_date', 'ann_status');
}
$output = $crud->render();
$js = '<script>$(document).ready(function()
{
$("#addStudent").validationEngine();
});</script>';
$header = $js . "<legend><h3>Penyenggaraan Pengumuman</h3></legend>";
$this->_main_output($output, $header);
}
public function add_receivable_amount($primary_key)
{
$_SESSION['receivable_id'] = NULL;
//select the next receivable amount number
$result = $this->max_receivable_amount_number();
if ($result != NULL) {
foreach ($result as $row) {
$number = $row->number;
$number++;
//go to the next number
if ($number == 1) {
$number = "UT0001";
}
$receivable_amount_number = $number;
}
} else {
//start generating receivable_amount numbers
$receivable_amount_number = "UT0001";
}
$where = array("receivable_id" => $primary_key, "receivable_amount_status" => 0);
$crud = new grocery_CRUD();
$crud->where($where);
$crud->set_subject('Receivable Amount');
$crud->set_table('receivable_amount');
$crud->columns('receivable_amount_date', 'receivable_amount_number', 'receivable_amount_name', 'receivable_amount_amount');
$crud->fields('receivable_amount_name', 'receivable_amount_amount', 'receivable_amount_number', 'receivable_id');
$crud->field_type('receivable_amount_number', 'hidden', $receivable_amount_number);
$crud->field_type('receivable_id', 'hidden', $primary_key);
$crud->add_action('Print', base_url() . 'img/icons/icon-48-print.png', 'front_office/print_receivable_amount');
$crud->display_as('receivable_amount_date', 'Date');
$crud->display_as('receivable_amount_name', 'Item');
$crud->display_as('receivable_amount_amount', 'Amount');
$crud->display_as('receivable_amount_number', 'Receipt Number');
$crud->required_fields("receivable_amount_name", "receivable_amount_amount");
$_SESSION['receivable_id'] = $primary_key;
$_SESSION['table'] = "receivable_amount";
$crud->callback_delete(array($this, 'delete_log'));
$output = $crud->render();
$this->_example_output3($output);
}
