public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('hotel_rooms');
$crud->set_subject('Hotel Rooms');
// $crud->unset_fields('ht_id');
$crud->display_as('room_hotel', 'Hotel Name');
$crud->display_as('hotel_title', 'Room Name');
$crud->display_as('room_desc', 'Room Description');
$crud->display_as('room_basic_price', 'Selling Price');
$crud->display_as('room_cost_price', 'Cost Price');
$crud->display_as('room_market_price', 'Market Price');
$crud->display_as('room_service_charge', 'Service Charge');
$crud->display_as('room_vat', 'VAT');
$crud->columns(array('room_hotel', 'room_title', 'room_vat', 'room_service_charge', 'room_cost_price', 'room_basic_price', 'room_basic_discount', 'room_order', 'room_quantity', 'room_added_on', 'room_status'));
$crud->callback_column('room_basic_price', array($this, 'set_price'));
//
$crud->callback_read_field('room_basic_price', array($this, 'set_price'));
// crud library modified SAM for read_field
$crud->callback_column('room_basic_discount', array($this, 'set_price'));
//
$crud->callback_read_field('room_basic_discount', array($this, 'set_price'));
// crud library modified SAM for read_field
$crud->callback_add_field('room_cost_price', function ($value, $primary_key) {
return "USD <input id='field-room_cost_price' class='form-control' name='room_cost_price' type='text' value='' maxlength='20'>";
});
$crud->callback_add_field('room_market_price', function ($value, $primary_key) {
return "USD <input id='field-room_market_price' class='form-control' name='room_market_price' type='text' value='' maxlength='20'>";
});
$crud->callback_edit_field('room_cost_price', function ($value, $primary_key) {
return "USD <input id='field-room_cost_price' class='form-control' name='room_cost_price' type='text' value='{$value}' maxlength='20'>";
});
$crud->callback_edit_field('room_market_price', function ($value, $primary_key) {
return "USD <input id='field-room_market_price' class='form-control' name='room_market_price' type='text' value='{$value}' maxlength='20'>";
});
$crud->callback_add_field('room_basic_price', function ($value, $primary_key) {
return "USD <input id='field-room_basic_price' class='form-control' name='room_basic_price' type='text' value='' maxlength='20'>";
});
$crud->callback_edit_field('room_basic_price', function ($value, $primary_key) {
return "USD <input id='field-room_basic_price' class='form-control' name='room_basic_price' type='text' value='{$value}' maxlength='20'>";
});
$crud->callback_add_field('room_basic_discount', function ($value, $primary_key) {
return "USD <input id='field-room_basic_discount' class='form-control' name='room_basic_discount' type='text' value='' maxlength='20'>";
});
$crud->callback_edit_field('room_basic_discount', function ($value, $primary_key) {
return "USD <input id='field-room_basic_discount' class='form-control' name='room_basic_discount' type='text' value='{$value}' maxlength='20'>";
});
$crud->set_relation('room_hotel', 'hotels', '{hotel_name}');
$hrf = $this->generic_model->get_by('hotel_room_facilities', array('hrf_status' => 1), 'hrf_id');
$hrf = $this->generic_model->array_from_db($hrf, 'hrf_id, hrf_facility');
$crud->field_type('room_facilities', 'multiselect', $hrf);
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Hotel Tariffs', 'pagedesc' => 'Hotel Tariffs', 'contenttitle' => 'Hotel Tariffs List Records');
$this->load->view('gc_admin_wrapper', $data);
}
public function index($categoryid = 0)
{
$session_data = $this->session->userdata('logged_in');
$data['username'] = $session_data['username'];
$data['lo'] = 2;
//value used to identify section movie or celebrity
$data['categoryid'] = $categoryid;
//value used to identify section movie or celebrity
if ($categoryid != 0) {
$data['cat_id'] = $categoryid;
$cat_title = $this->category->getTitle($categoryid);
$data['cat_title'] = $cat_title . " - Movies";
$form_subject = $cat_title;
$crud = new grocery_CRUD();
$crud->set_table('dbx_movies');
$crud->where('catid', $categoryid);
$crud->set_subject('Movie');
$crud->required_fields('title', 'year');
$crud->columns('title');
// $crud->callback_column('name',array($this,'link_title'));
// $crud->set_rules('title','Title','trim|required|xss_clean|is_unique[dbx_categories.title]');
$crud->add_action('Large Image', '', '', 'custom_icon limg-icon img_crop', array($this, 'set_imgurl'));
$crud->add_action('Small Image', '', '', 'custom_icon simg-icon img_crop', array($this, 'set_imgurl'));
$crud->fields('catid', 'title', 'year', 'release_date', 'cast', 'director', 'producer', 'music', 'writer', 'lyrics', 'synopsis', 'seo_url', 'ownerid', 'created_date', 'lastupdate_date');
// $crud->field_type('catid', 'hidden', $categoryid);
$crud->set_relation('catid', 'dbx_categories', 'title', array('type' => 'M'), null, $categoryid);
$crud->display_as('catid', 'Category');
//
$crud->callback_add_field('cast', array($this, 'add_field_cast'));
$crud->callback_add_field('synopsis', array($this, 'add_field_synopsis'));
$crud->callback_edit_field('cast', array($this, 'edit_field_cast'));
$crud->callback_edit_field('synopsis', array($this, 'edit_field_synopsis'));
$crud->change_field_type('ownerid', 'invisible');
$crud->change_field_type('created_date', 'invisible');
$crud->change_field_type('seo_url', 'invisible');
$crud->change_field_type('lastupdate_date', 'invisible');
$crud->callback_before_insert(array($this, 'before_insert'));
$crud->callback_before_update(array($this, 'before_update'));
$crud->callback_after_insert(array($this, 'after_insert'));
$crud->unset_jquery();
$state = $crud->getState();
// echo($state);
$data['state'] = $state;
$output = $crud->render($data);
$this->load->view('header_view', $data);
$this->load->view('movies_view', $output);
$this->load->view('footer_view', $data);
}
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('booking_refunds');
$crud->set_subject('Booking Refund');
$crud->unset_add();
$crud->unset_delete();
// $crud->unset_columns('booking_ref_no');
$crud->unset_fields('booking_ref_no');
$crud->field_type('refund_status', 'dropdown', array('1' => 'Requested', '0' => 'Rejected', '2' => 'Refunded'));
// $crud->field_type('refund_status', 'dropdown', array('1'=>'Requested', '0'=>'Rejected', '2' => 'Refunded'));
// $crud->callback_column('refund_status', function($value, $primary_key){
// $status = array('1'=>'Requested', '0'=>'Rejected', '2' => 'Refunded');
// return $status[$value];
// });
$crud->field_type('item_type', 'readonly');
$crud->callback_column('item_type', function ($value, $primary_key) {
return ucfirst($value);
});
$crud->callback_edit_field('item_type', function ($value, $primary_key) {
return ucfirst($value);
});
// $crud->callback_before_update(array($this, 'modified_date_callback'));
$crud->callback_column('booking_ref_no', array($this, '_show_invoice'));
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Booking Refund', 'pagedesc' => 'Booking Refund', 'contenttitle' => 'Booking Refund List Records');
$this->load->view('gc_admin_wrapper', $data);
}
public function index($categoryid = 0)
{
$session_data = $this->session->userdata('logged_in');
$data['username'] = $session_data['username'];
$data['lo'] = 1;
//value used to identify section movie or celebrity
if ($categoryid != 0) {
$data['cat_id'] = $categoryid;
$cat_title = $this->category->getTitle($categoryid);
$data['cat_title'] = $cat_title . " ";
$form_subject = $cat_title;
$crud = new grocery_CRUD();
$crud->set_table('dbx_celebrities');
$crud->where('catid', $categoryid);
$crud->set_subject($form_subject);
$crud->required_fields('name');
$crud->columns('name');
// $crud->callback_column('name',array($this,'link_title'));
// $crud->set_rules('title','Title','trim|required|xss_clean|is_unique[dbx_categories.title]');
$crud->add_action('Large Image', '', '', 'custom_icon limg-icon img_crop', array($this, 'set_imgurl'));
$crud->add_action('Small Image', '', '', 'custom_icon simg-icon img_crop', array($this, 'set_imgurl'));
$crud->fields('catid', 'name', 'alt_name1', 'alt_name2', 'alt_name3', 'alt_name4', 'title', 'desc', 'sign', 'birth_date', 'birth_place', 'first_film', 'awards', 'height', 'weight', 'seo_url', 'ownerid', 'created_date', 'lastupdate_date');
// $crud->field_type('catid', 'hidden', $categoryid);
$crud->set_relation('catid', 'dbx_categories', 'title', array('type' => 'C'), null, $categoryid);
$crud->display_as('catid', 'Category');
$crud->callback_add_field('desc', array($this, 'add_field_desc'));
$crud->callback_add_field('awards', array($this, 'add_field_awards'));
$crud->callback_edit_field('desc', array($this, 'edit_field_desc'));
$crud->callback_edit_field('awards', array($this, 'edit_field_awards'));
$crud->field_type('sign', 'dropdown', array('Aries' => 'Aries', 'Taurus' => 'Taurus', 'Gemini1' => 'Gemini', 'Cancer' => 'Cancer', 'Leo' => 'Leo', 'Virgo' => 'Virgo', 'Libra' => 'Libra', 'Scorpio' => 'Scorpio', 'Sagittarius' => 'Sagittarius', 'Capricorn' => 'Capricorn', 'Aquarius' => 'Aquarius', 'Pisces' => 'Pisces'));
$crud->change_field_type('ownerid', 'invisible');
$crud->change_field_type('created_date', 'invisible');
$crud->change_field_type('seo_url', 'invisible');
$crud->change_field_type('lastupdate_date', 'invisible');
$crud->callback_before_insert(array($this, 'before_insert'));
$crud->callback_before_update(array($this, 'before_update'));
$crud->unset_jquery();
$output = $crud->render($data);
$this->load->view('header_view', $data);
$this->load->view('celebrities_view', $output);
$this->load->view('footer_view', $data);
}
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('bookings');
$crud->set_subject('Bookings');
// $agents = $this->ion_auth->get_all_agents();
// $user = $this->ion_auth->user()->row();
// $agents += array($user->id => $user->first_name . " " . $user->last_name);
// $crud->field_type('hotel_agent_id', 'dropdown', $agents);
$crud->set_relation('booking_agent', 'io_users', '{first_name} {last_name} [{email}]', array('active' => 1));
$crud->set_relation('agent_id', 'io_users', '{first_name} {last_name} [{email}]', array('active' => 1));
$crud->set_relation('booking_to', 'io_users', '{first_name} {last_name} [{email}]', array('active' => 1));
$crud->display_as('agent_id', 'Agent of Hotel/Package');
$crud->display_as('booking_company_commission', 'Company Commission');
$crud->display_as('booking_status', 'Status (Change Status)');
$crud->display_as('booking_agent', 'Booked By');
// $crud->display_as('hotel_name', 'Hotel Name');
// $crud->display_as('hotel_rooms', 'Rooms');
// $crud->display_as('hotel_tariffs', 'Tariffs');
$crud->field_type('booking_ref_no', 'readonly');
$crud->field_type('paypal_transaction_id', 'readonly');
$crud->field_type('booking_agent_commission', 'readonly');
$crud->field_type('booking_company_commission', 'readonly');
$crud->field_type('booking_type', 'readonly');
$crud->field_type('booking_item_title', 'readonly');
$crud->field_type('booking_date', 'readonly');
$crud->field_type('booking_payment_type', 'readonly');
$crud->field_type('booking_total', 'readonly');
$crud->field_type('booking_agent', 'readonly');
$crud->field_type('agent_id', 'readonly');
$crud->field_type('booking_to', 'readonly');
$crud->unset_columns('booking_item', 'booking_subitem', 'booking_paymethod_tax', 'ip_address', 'booking_nights');
$crud->unset_fields('booking_item', 'booking_subitem', 'booking_paymethod_tax', 'ip_address', 'booking_nights');
$crud->where('agent_id', $this->ion_auth->get_user_id());
// $crud->columns('hotel_name', 'hotel_agent_id', 'hotel_phoneNumber', 'hotel_website', 'hotel_facebook' ,'hotel_googleMap', 'hotel_status');
// $state = $crud->getState();
//
// if($state =='list' || $state =='ajax_list')
// {
$crud->set_js("assets/frontend/js/custom_functions_sam.js");
// }
$crud->add_action('Conversation', 'http://www.grocerycrud.com/assets/uploads/general/smiley.png', '', 'ui-icon-image', array($this, '_booking_conversation'));
$crud->callback_column('booking_ref_no', array($this, '_show_invoice'));
$crud->callback_edit_field('booking_status', array($this, '_edit_field_callback'));
$crud->callback_column('booking_status', array($this, '_booking_status'));
$crud->unset_add();
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Bookings', 'pagedesc' => 'Bookings', 'contenttitle' => 'Booking List Records', 'left_menu' => 'agents_menu');
$this->load->view('gc_admin_wrapper', $data);
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_table('usrmgr');
$crud->change_field_type('password', 'password');
$crud->callback_edit_field('password', array($this, 'decrypt_password_callback'));
$crud->columns('username', 'nama_lengkap', 'email', 'level', 'blokir');
$crud->callback_before_insert(array($this, 'encrypt_password_callback'));
$crud->callback_before_update(array($this, 'encrypt_password_callback'));
$crud->set_subject('Users');
$crud->fields('nama_lengkap', 'username', 'password', 'email', 'level', 'access_control', 'blokir');
$crud->required_fields('nama_lengkap', 'username', 'level', 'blokir');
$crud->set_relation_n_n('access_control', 'usrmgr_access', 'modul', 'id_users', 'id_modul', 'nama_modul', 'priority');
//$crud->set_relation('salesRepEmployeeNumber','employees','lastName');
$output = $crud->render();
$data['subject'] = 'Pengaturan Pengguna';
$data['content'] = $this->load->view('crud.php', $output, true);
$this->load->view('base_theme', $data);
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('hotel_tariffs');
$crud->set_subject('Hotel Tariffs');
// $crud->unset_fields('ht_id');
$crud->display_as('hotels_hotel_id', 'Hotel Name');
$crud->display_as('ht_hotelRoom', 'Hotel Room');
$crud->display_as('ht_hotelTariffs', 'Hotel Tariffs');
$crud->callback_column('ht_hotelTariffs', array($this, 'set_price'));
$crud->callback_read_field('ht_hotelTariffs', array($this, 'set_price'));
// crud library modified SAM for read_field
$crud->callback_add_field('ht_hotelTariffs', array($this, 'add_price1'));
$crud->callback_edit_field('ht_hotelTariffs', array($this, 'edit_price1'));
$crud->set_relation('hotels_hotel_id', 'hotels', '{hotel_name}');
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Hotel Tariffs', 'pagedesc' => 'Hotel Tariffs', 'contenttitle' => 'Hotel Tariffs List Records');
$this->load->view('gc_admin_wrapper', $data);
}
public function user()
{
$this->load->model('login_model');
if ($this->__check_auth()) {
if ($this->login_model->get_access_level() >= 10) {
try {
// new object
$crud = new grocery_CRUD();
// sets table to use
$crud->set_table('user');
$crud->set_subject('Utilisateur');
// callbacks for password editing
$crud->callback_edit_field('password_hash', array($this, '__clean_field'));
$crud->callback_before_insert(array($this, '__password_user_before_insert'));
$crud->callback_before_update(array($this, '__password_user_before_update'));
// links foreign keys
$crud->set_relation('user_type_id', 'user_type', 'name');
$crud->set_relation('user_state_id', 'user_state', 'name');
$crud->set_relation('department_id', 'department', 'name');
// renders the table in output
$output = $crud->render();
// sets some text to determine which table is edited
$output->current = 'Utilisateur';
// display all
$this->_view_output($output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
} else {
show_error('L\'utilisateur n\'a pas les privilèges nécessaires.');
die;
}
} else {
// if not authentified send back to login
redirect('login');
}
}
function users()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('user');
$crud->display_as('login', 'Username');
$crud->display_as('user_name', 'Name');
$crud->set_subject('User');
$crud->columns('login', 'user_type', 'user_name', 'email', 'mobile');
$crud->required_fields('login', 'user_type', 'user_name', 'email', 'mobile');
$crud->set_rules('email', 'Email', 'trim|required|valid_email');
$crud->change_field_type('password', 'password');
// Cripatare password
$crud->callback_before_insert(array($this, 'encrypt_password_callback'));
$crud->callback_edit_field('password', array($this, 'set_password_input_to_empty'));
$crud->callback_before_update(array($this, 'encrypt_password_callback'));
//$crud->callback_edit_field('password',array($this,'decrypt_password_callback'));
// Realatii baza de date
//$crud->set_relation('grup','grup','grup_name');
//$crud->set_field_upload('imagine_monitor','assets/uploads/files');
$crud->field_type('user_type', 'dropdown', array('admin' => 'admin', 'user' => 'user'));
$output = $crud->render();
$this->_admin_output($output);
}
public function hotel_rooms()
{
$agent_id = $this->ion_auth->user()->row()->id;
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('hotel_rooms');
$crud->set_subject('Hotel Rooms');
// $crud->unset_fields('ht_id');
$crud->display_as('room_hotel', 'Hotel Name');
$crud->display_as('hotel_title', 'Room Name');
$crud->display_as('room_desc', 'Room Description');
$crud->columns(array('room_hotel', 'room_title', 'room_basic_price', 'room_basic_discount', 'room_order', 'room_quantity', 'room_added_on', 'room_status'));
$crud->callback_column('room_basic_price', array($this, 'set_price'));
//
$crud->callback_read_field('room_basic_price', array($this, 'set_price'));
// crud library modified SAM for read_field
$crud->callback_column('room_basic_discount', array($this, 'set_price'));
//
$crud->callback_read_field('room_basic_discount', array($this, 'set_price'));
// crud library modified SAM for read_field
//
$crud->callback_add_field('room_basic_price', function ($value, $primary_key) {
return "USD <input id='field-room_basic_price' class='form-control' name='room_basic_price' type='text' value='' maxlength='20'>";
});
$crud->callback_edit_field('room_basic_price', function ($value, $primary_key) {
return "USD <input id='field-room_basic_price' class='form-control' name='room_basic_price' type='text' value='{$value}' maxlength='20'>";
});
$crud->callback_add_field('room_basic_discount', function ($value, $primary_key) {
return "USD <input id='field-room_basic_discount' class='form-control' name='room_basic_discount' type='text' value='' maxlength='20'>";
});
$crud->callback_edit_field('room_basic_discount', function ($value, $primary_key) {
return "USD <input id='field-room_basic_discount' class='form-control' name='room_basic_discount' type='text' value='{$value}' maxlength='20'>";
});
$hrf = $this->generic_model->get_by('hotel_room_facilities', array('hrf_status' => 1), 'hrf_id');
$hrf = $this->generic_model->array_from_db($hrf, 'hrf_id, hrf_facility');
$crud->field_type('room_facilities', 'multiselect', $hrf);
$agent_hotels = $this->db->select('hotel_id')->get_where('hotels', array('hotel_status' => 1, 'hotel_agent_id' => $agent_id))->result();
// var_dump($agent_hotels);
//getting only rooms that belong to hotels of the agent
foreach ($agent_hotels as $k => $v) {
$hotels_id[] = $v->hotel_id;
}
$ids = '(0)';
if (!empty($hotels_id)) {
$ids = '(';
$ids .= implode(',', $hotels_id);
$ids .= ')';
}
//custom where_in function like in CI
$crud->in_where('room_hotel', $ids);
// $crud->set_relation('room_hotel', 'hotels', '{hotel_name}');
/*
* for hotels list added by agent
*/
$hrf = $this->generic_model->get_by('hotels', array('hotel_status' => 1, 'hotel_agent_id' => $this->ion_auth->get_user_id()), 'hotel_id');
$hrf = $this->generic_model->array_from_db($hrf, 'hotel_id, hotel_name');
$crud->field_type('room_hotel', 'dropdown', $hrf);
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Hotel Rooms', 'pagedesc' => 'Hotel Rooms', 'contenttitle' => 'Hotel Room List Records', 'left_menu' => 'agents_menu');
$this->load->view('gc_admin_wrapper', $data);
}
public function kegiatan_butir()
{
try {
$this->load->model("kegiatan_m");
$data = $this->kegiatan_m->get_kegiatan_subunsur(array("id_kegiatan_subunsur" => $this->uri->segment(4)));
$subunsur = isset($data[0]->subunsur) ? $data[0]->subunsur : "";
$subjek = ' <a href="' . base_url() . 'admin/kegiatan_subunsur/' . $this->uri->segment(3) . '">
Butir Kegiatan </a>: ' . $subunsur . '';
$crud = new grocery_CRUD();
$state = $crud->getState();
$crud->where('tbl_kegiatan_butir.id_kegiatan_subunsur', $this->uri->segment(4));
$crud->set_table('tbl_kegiatan_butir');
$crud->set_subject($subjek);
//$crud->getModel()->set_add_value('order_date', date("Y-m-d"));
$crud->set_relation('change_by', 'tbl_user', 'email');
$crud->set_relation('id_kegiatan_subunsur', 'tbl_kegiatan_subunsur', 'subunsur');
$crud->set_relation_n_n('Jenjang', 'tbl_kegiatan_jenjang', 'tbl_jenjang_jabatan', 'id_kegiatan_butir', 'id_jenjang_jabatan', 'jenjang_jabatan', NULL, array('id_jenjang_auditor' => $this->uri->segment(3)));
$crud->required_fields('Jenjang ', 'butir', 'angka_kredit', 'satuan_hasil');
//$crud->unique_fields('butir');
$crud->fields('Jenjang', 'id_kegiatan_subunsur', 'kode', 'butir', 'angka_kredit', 'satuan_hasil');
$crud->columns('Jenjang', 'id_kegiatan_subunsur', 'kode', 'butir', 'angka_kredit', 'satuan_hasil');
$crud->display_as('id_kegiatan_subunsur', 'Sub Unsur');
$crud->order_by('id_kegiatan_butir', 'asc');
$crud->callback_before_update(array($this, 'get_change_by_callback'));
$crud->callback_before_insert(array($this, 'kegiatan_butir_before_insert_callback'));
$crud->callback_field('change_date', array($this, 'format_date_callback'));
$crud->change_field_type('change_by', 'readonly');
$crud->change_field_type('change_date', 'readonly');
$crud->callback_add_field('id_kegiatan_subunsur', array($this, 'kegiatan_butir_form_callback'));
$crud->callback_edit_field('id_kegiatan_subunsur', array($this, 'kegiatan_butir_form_callback'));
$crud->unset_read();
$crud->unset_save();
$sitemap = $this->get_sitemap();
$output = $crud->render($sitemap);
$this->load->view('theme/theme_default', $output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function config()
{
$crud = new grocery_CRUD();
$crud->set_table('cms_config');
$crud->set_subject('Configuration');
$crud->columns('config_name', 'value', 'description');
$crud->edit_fields('config_name', 'value', 'description');
$crud->add_fields('config_name', 'value', 'description');
$crud->display_as('config_name', 'Configuration Key')->display_as('value', 'Configuration Value')->display_as('description', 'Description');
$crud->unset_texteditor('description');
$crud->unset_texteditor('value');
if ($crud->getState() == 'edit') {
$crud->callback_edit_field('config_name', array($this, 'read_only_config_name'));
$crud->callback_edit_field('description', array($this, 'read_only_config_description'));
}
$output = $crud->render();
$this->view('main/config', $output, 'main_config_management');
}
function peserta_kkn_management_all()
{
$session = isset($_SESSION['username_belajar']) ? $_SESSION['username_belajar'] : '';
if ($session != "") {
$pecah = explode("|", $session);
$data["NIM"] = $pecah[0];
$data["NAMA"] = $pecah[1];
$data["STATUS"] = $pecah[3];
if ($data["STATUS"] == "Admin") {
try {
/* This is only for the autocompletion */
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
//$crud->where('SUDAH','2');
$crud->set_table('KKN_MHS');
$crud->set_language("indonesian");
$crud->display_as('NIM', 'Data Pribadi');
$crud->set_relation('NIM', 'D_MAHASISWA', 'Nim :{NIM}, Angkatan :{ANGKATAN},Nama :{NAMA},Jk: {J_KELAMIN},Asal: {ALAMAT_MHS}, Golongan Darah: {GOL_DARAH},HP Mhs: {HP_MHS},Telp Keluarga: {TELP_MHS}');
$crud->display_as('FAK', 'Fakultas')->display_as('NO', 'No Pendaftaran')->display_as('ALAMAT_JOGJA', 'Alamat di Jogja')->display_as('NM_KEC_JOGJA', 'Kec di Jogja')->display_as('NM_KAB_JOGJA', 'Kab di Jogja')->display_as('PRESTASI', 'Keahlian')->display_as('RT_JOGJA', 'RT di Jogja')->display_as('DESA_JOGJA', 'Desa di Jogja')->display_as('KODE_POS_JOGJA', 'Kod Pos di Jogja')->display_as('TRANSPORTASI', 'Transportasi')->display_as('PATH_SK_DOKTER', 'Upload SK Dokter')->display_as('PATH_SK_GOLONGAN_DARAH', 'Upload SK Gol Darah')->display_as('PATH_SK_CUTI', 'Upload SK Cuti Kerja')->display_as('PATH_SK_TIDAK_HAMIL', 'Upload SK Tidak Hamil');
$crud->unset_edit();
$crud->unset_delete();
$crud->unset_edit_fields('SUDAH');
$crud->unset_add();
$crud->unset_add_fields('NO', 'SUDAH');
$crud->set_subject('Peserta KKN');
$crud->required_fields('ALAMAT_JOGJA');
$crud->columns('NIM', 'FAK', 'ALAMAT_JOGJA', 'PRESTASI', 'NM_KEC_JOGJA', 'NM_KAB_JOGJA');
$crud->set_field_upload('PATH_SK_DOKTER', 'assets/kesehatan');
$crud->set_field_upload('PATH_SK_GOLONGAN_DARAH', 'assets/goldarah');
$crud->set_field_upload('PATH_SK_CUTI', 'assets/cutikerja');
$crud->set_field_upload('PATH_SK_TIDAK_HAMIL', 'assets/tidakhamil');
//$crud->edit_fields('NIM','KD_FAK','ALAMAT_JOGJA','PRESTASI','KD_KEC','KD_KAB');
$crud->callback_edit_field('NIM', array($this, 'edit_field_callback_nim'));
$crud->callback_edit_field('NO', array($this, 'edit_field_callback_no'));
$output = $crud->render();
$this->_manage_output($output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
} else {
?>
<script type="text/javascript" language="javascript">
alert("Anda tidak berhak masuk ke Control Panel Admin...!!!");
</script>
<?php
echo "<meta http-equiv='refresh' content='0; url=" . base_url() . "kkn'>";
}
} else {
?>
<script type="text/javascript" language="javascript">
alert("Anda belum Log In...!!!\nAnda harus Log In untuk mengakses halaman ini...!!!");
</script>
<?php
echo "<meta http-equiv='refresh' content='0; url=" . base_url() . "kkn'>";
}
}
public function index()
{
$crud = new grocery_CRUD();
$user_id = $this->ion_auth->user()->row()->id;
$crud->set_table('packages');
$crud->set_subject('Packages');
$crud->unset_fields('package_id');
$crud->unset_columns('package_id');
$crud->unset_columns('package_thingsToConsider');
$crud->unset_columns('package_weatherCondition');
$crud->unset_columns('package_itinerary');
$crud->display_as('package_weatherCondition', 'Weather Condition');
$crud->display_as('package_thingsToConsider', 'Things to consider');
$crud->display_as('package_adventureRegion', 'Adventure Region');
$crud->display_as('package_basic_price', 'Price');
$crud->display_as('package_basic_before_discount', 'Before Discount Price');
$crud->display_as('package_related', 'Related Packages');
$crud->set_field_upload('package_image', $this->upload_path);
$crud->unique_fields('package_slug');
$crud->where('package_agent', $user_id);
$crud->set_relation('package_category', 'packages_types_settings', 'sett_name', 'sett_type = "ttypes"', 'sett_id');
$crud->field_type('package_agent', 'hidden', $user_id);
$this->load->model('agents_m');
/*
* For related packages
* on add list all the packages created by the agent
* on edit, list all except own name
*/
if ($crud->getState() == 'edit') {
$hrf = $this->db->select('package_id, package_title')->get_where('packages', array('package_status' => 1, 'package_agent' => $user_id, 'package_id !=' => $crud->getStateInfo()->primary_key))->result();
} else {
$hrf = $this->db->select('package_id, package_title')->get_where('packages', array('package_status' => 1, 'package_agent' => $user_id))->result();
}
$hrf = $this->agents_m->array_from_db($hrf, 'package_id, package_title');
// empty data for multiselect field generates error
if (empty($hrf)) {
$hrf = array('');
} else {
$hrf = $this->generic_model->array_from_db($hrf, 'hotel_id, hotel_name');
}
$crud->field_type('package_related', 'multiselect', $hrf);
$crud->callback_column('package_image', array($this, 'set_image'));
$crud->callback_read_field('package_basic_price', array($this, 'set_price'));
$crud->callback_read_field('package_basic_discount', array($this, 'set_price'));
$crud->callback_column('package_basic_price', array($this, 'set_price'));
$crud->callback_column('package_basic_discount', array($this, 'set_price'));
$crud->callback_add_field('package_basic_price', function ($value, $primary_key) {
return "USD <input id='field-package_basic_price' class='form-control' name='package_basic_price' type='text' value='{$value}' maxlength='20'>";
});
$crud->callback_add_field('package_basic_discount', function ($value, $primary_key) {
return "USD <input id='field-package_basic_discount' class='form-control' name='package_basic_discount' type='text' value='{$value}' maxlength='20'>";
});
$crud->callback_edit_field('package_basic_price', function ($value, $primary_key) {
return "USD <input id='field-package_basic_price' class='form-control' name='package_basic_price' type='text' value='{$value}' maxlength='20'>";
});
$crud->callback_edit_field('package_basic_discount', function ($value, $primary_key) {
return "USD <input id='field-package_basic_discount' class='form-control' name='package_basic_discount' type='text' value='{$value}' maxlength='20'>";
});
$crud->add_action('Photo Gallery', '', 'agents/packages/gallery', 'ui-icon ui-icon-image');
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Packages', 'pagedesc' => 'Packages', 'contenttitle' => 'Packages List Records', 'left_menu' => 'agents_menu');
$this->load->view('gc_admin_wrapper', $data);
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_table('packages');
$crud->set_subject('Packages');
$crud->unset_fields('package_id');
$crud->unset_columns('package_id');
$crud->unset_columns('package_thingsToConsider');
$crud->unset_columns('package_weatherCondition');
$crud->unset_columns('package_itinerary');
$crud->display_as('package_weatherCondition', 'Weather Condition');
$crud->display_as('package_thingsToConsider', 'Things to consider');
$crud->display_as('package_adventureRegion', 'Adventure Region');
$crud->display_as('package_cost_price', 'Cost Price');
$crud->display_as('package_basic_price', 'Selling Price');
$crud->display_as('package_market_price', 'Market Price');
$crud->display_as('package_service_charge', 'Service Charge');
$crud->display_as('package_vat', 'VAT');
$crud->display_as('package_basic_price', 'Price');
$crud->display_as('package_basic_before_discount', 'Before Discount Price');
$crud->display_as('package_related', 'Related Packages');
$crud->set_field_upload('package_image', $this->upload_path);
$crud->unique_fields('package_slug');
$agents = $this->ion_auth->get_all_agents();
$user = $this->ion_auth->user()->row();
$agents += array($user->id => $user->first_name . " " . $user->last_name);
$crud->field_type('package_agent', 'dropdown', $agents);
$crud->required_fields('package_agent');
/*
* For related packages
* on add list all the packages
* on edit, list all except own name
*/
if ($crud->getState() == 'edit') {
$hrf = $this->generic_model->get_by('packages', array('package_status' => 1, 'package_id !=' => $crud->getStateInfo()->primary_key), 'package_id');
} else {
$hrf = $this->generic_model->get_by('packages', array('package_status' => 1), 'package_id');
}
$hrf = $this->generic_model->array_from_db($hrf, 'package_id, package_title');
$crud->field_type('package_related', 'multiselect', $hrf);
// $crud->set_relation('package_agent', 'agents', '{agent_companyName}');
//$agents = $this->ion_auth->get_all_agents();
// $crud->field_type('package_agent', 'dropdown', $agents);
// $crud->field_type('package_agent', 'hidden', $this->ion_auth->user()->row()->id);
$crud->field_type('package_difficulty', 'dropdown', array('1' => 'Easy', '2' => 'Basic', '3' => 'Beginner', '4' => 'Intermediate', '5' => 'Advanced'));
$crud->set_relation('package_category', 'packages_types_settings', 'sett_name', 'sett_type = "ttypes"', 'sett_id');
$crud->callback_column('package_image', array($this, 'set_image'));
$crud->callback_column('package_basic_price', array($this, 'set_price'));
$crud->callback_column('package_basic_discount', array($this, 'set_price'));
$crud->callback_read_field('package_basic_price', array($this, 'set_price'));
$crud->callback_read_field('package_basic_discount', array($this, 'set_price'));
$crud->callback_add_field('package_cost_price', function ($value, $primary_key) {
return "USD <input id='field-package_cost_price' class='form-control' name='package_cost_price' type='text' value='' maxlength='20'>";
});
/*$crud->callback_add_field('package_difficulty', function ($value, $primary_key) {
return '<select id="field-package_difficulty" class="form-control" name="package_difficulty">
<option value="1" data-html="Easy">Easy</option>
<option value="2" data-html="Basic">Basic</option>
<option value="3" data-html="Beginner">Beginner</option>
<option value="3" data-html="Intermediate">Intermediate</option>
<option value="3" data-html="Advanced">Advanced</option>
</select>';
});*/
$crud->callback_add_field('package_market_price', function ($value, $primary_key) {
return "USD <input id='field-package_market_price' class='form-control' name='package_market_price' type='text' value='' maxlength='20'>";
});
$crud->callback_edit_field('package_cost_price', function ($value, $primary_key) {
return "USD <input id='field-package_cost_price' class='form-control' name='package_cost_price' type='text' value='{$value}' maxlength='20'>";
});
$crud->callback_edit_field('package_market_price', function ($value, $primary_key) {
return "USD <input id='field-package_market_price' class='form-control' name='package_market_price' type='text' value='{$value}' maxlength='20'>";
});
$crud->callback_add_field('package_basic_price', function () {
return "USD <input id='field-package_basic_price' class='form-control' name='package_basic_price' type='text' value='' maxlength='20'>";
});
$crud->callback_add_field('package_basic_discount', function () {
return "USD <input id='field-package_basic_discount' class='form-control' name='package_basic_discount' type='text' value='' maxlength='20'>";
});
$crud->callback_edit_field('package_basic_price', function ($value, $primary_key) {
return "USD <input id='field-package_basic_price' class='form-control' name='package_basic_price' type='text' value='{$value}' maxlength='20'>";
});
$crud->callback_edit_field('package_basic_discount', function ($value, $primary_key) {
return "USD <input id='field-package_basic_discount' class='form-control' name='package_basic_discount' type='text' value='{$value}' maxlength='20'>";
});
$crud->unique_fields('package_slug');
$crud->add_action('Photo Gallery', '', 'packages/gallery', 'ui-icon ui-icon-image');
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Packages', 'pagedesc' => 'Packages', 'contenttitle' => 'Packages List Records');
$this->load->view('gc_admin_wrapper', $data);
}
public function daftar_kegiatan_transaksi()
{
try {
$this->load->model("kegiatan_m");
$id_kegiatan_butir = $this->uri->segment(4);
$kegiatan_butir = $this->kegiatan_m->detail_kegiatan_butir(array("id_kegiatan_butir" => $id_kegiatan_butir));
$unsur = isset($kegiatan_butir[0]->unsur) ? $kegiatan_butir[0]->unsur : "";
$subunsur = isset($kegiatan_butir[0]->subunsur) ? $kegiatan_butir[0]->subunsur : "";
$butir = isset($kegiatan_butir[0]->butir) ? $kegiatan_butir[0]->butir : "";
$crud = new grocery_CRUD();
$state = $crud->getState();
$crud->set_table('tbl_kegiatan_transaksi');
$crud->set_relation('change_by', 'tbl_user', 'email');
$crud->set_relation('id_kegiatan_butir', 'tbl_kegiatan_butir', 'butir');
if ($this->uri->segment(3) == 2) {
$crud->required_fields('tanggal_kegiatan', 'tanggal_kegiatan_selesai');
$crud->set_rules('tanggal_kegiatan', 'Tanggal Mulai', 'required|callback_tanggal_mulai_check');
} else {
$crud->required_fields('tanggal_kegiatan', 'tanggal_kegiatan_selesai');
}
$crud->required_fields('tanggal_kegiatan', 'tanggal_kegiatan_selesai');
$crud->set_primary_key('id_kegiatan_transaksi');
$crud->where("tbl_kegiatan_transaksi.id_kegiatan_butir", $id_kegiatan_butir);
$crud->where("tbl_kegiatan_transaksi.id_user", $this->get_user_login());
//$crud->where("id_jenjang", $id_jenjang);
$subjek = '
<a href="' . base_url() . 'pegawai/daftar_kegiatan/' . $this->uri->segment(3) . '">
' . $unsur . ' </a> <i class="fa fa-angle-double-right"></i>
' . $subunsur . ' <i class="fa fa-angle-double-right"></i>
' . $butir . '';
$crud->set_subject($subjek);
//$crud->set_field_upload('bukti','assets/uploads/berkas');
$crud->columns('tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'keterangan', 'angka_kredit', 'status');
if (strtolower($unsur) != 'pengawasan') {
$crud->fields('id_kegiatan_butir', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'lembur', 'keterangan', 'angka_kredit', 'status', 'id_user');
} else {
$crud->fields('id_kegiatan_butir', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'lembur', 'keterangan', 'angka_kredit', 'status', 'id_user');
}
$crud->add_action('Form Spmt', '', 'pegawai/form_spmt/' . $id_kegiatan_butir, 'fa fa-file-archive-o');
$crud->add_action('Unggah Bukti', '', 'pegawai/daftar_kegiatan_berkas', 'fa fa-upload');
$crud->display_as("id_kegiatan_butir", "Butir Kegiatan")->display_as("tanggal_kegiatan", "Tanggal Mulai")->display_as("tanggal_kegiatan_selesai", "Tanggal Selesai")->display_as("id_user", "Oleh")->display_as("change_date", "Tanggal")->display_as("id_periode", "Periode")->display_as("id_kegiatan_jabatan", "Bertindak Sebagai");
$crud->callback_add_field('id_kegiatan_butir', array($this, '_form_get_butir_callback'));
$crud->callback_edit_field('id_kegiatan_butir', array($this, '_form_get_butir_callback'));
$crud->callback_before_update(array($this, 'get_change_by_callback'));
//$crud->callback_before_insert(array($this,'_daftar_kegiatan_transaksi_form_callback'));
$crud->callback_add_field('id_user', array($this, '_form_get_user_callback'));
$crud->callback_edit_field('id_user', array($this, '_form_get_user_callback'));
$crud->change_field_type('change_by', 'readonly');
$crud->change_field_type('change_date', 'readonly');
$crud->change_field_type('status', 'readonly');
$crud->change_field_type('angka_kredit', 'readonly');
//$crud->unset_delete();
//$crud->unset_edit();
//$crud->unset_add();
$crud->unset_read();
$sitemap = $this->get_sitemap();
$output = $crud->render($sitemap);
$this->load->view('theme/theme_pegawai', $output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
function _set_common_report_crud($columns)
{
$crud = new grocery_CRUD();
// default columns excludes: token address_id simply because FMS/FMS-endpoint doesn't use them
$default_columns = array('report_id', 'status', 'requested_datetime', 'updated_datetime', 'expected_datetime', 'priority', 'category_id', 'media_url', 'status_notes', 'description', 'agency_responsible', 'service_notice', 'address', 'postal_code', 'lat', 'long', 'device_id', 'source_client', 'account_id', 'first_name', 'last_name', 'email', 'phone', 'engineer');
$columns = $columns ? $columns : $default_columns;
foreach ($columns as &$colname) {
if ($colname == 'report_id') {
$colname = 'xxx_report_id';
}
}
$crud->columns($columns);
$crud->order_by('requested_datetime', 'desc');
$crud->edit_fields($default_columns);
$crud->set_theme('twitter-bootstrap');
$crud->set_table('reports');
$crud->set_subject('Report');
$crud->set_relation('category_id', 'categories', 'category_name', null, 'category_name ASC');
$crud->set_relation('priority', 'priorities', 'prio_name', null, 'prio_value ASC');
$crud->set_relation('status', 'statuses', 'status_name', null, 'status_name ASC');
$crud->set_primary_key('url_slug', 'agencies');
$crud->set_relation('agency_responsible', 'agencies', 'name', null, 'name ASC');
$crud->set_relation('source_client', 'open311_clients', '<a href="admin/open311_clients/{id}">{name}</a>', null, 'name ASC');
$crud->display_as('client_id', 'Client');
$crud->callback_column('media_url', array($this, '_linkify'));
$crud->callback_column('external_id', array($this, '_get_external_url'));
$crud->callback_edit_field('media_url', array($this, '_text_media_url_field'));
$crud->display_as('requested_datetime', 'Received')->display_as('updated_datetime', 'Last Updated')->display_as('expected_datetime', 'Expected')->display_as('category_id', 'Category')->display_as('media_url', 'Media URL');
$external_id_col_name = config_item('external_id_col_name');
$crud->display_as('external_id', empty($external_id_col_name) ? 'External ID' : $external_id_col_name);
$crud->unset_texteditor('description', 'address', 'status_notes', 'service_notice');
$crud->add_action('View', site_url('assets/fms-endpoint/images/report.png'), 'admin/report');
$crud->callback_column('xxx_report_id', array($this, '_report_id_link_field'));
$crud->callback_column('requested_datetime', array($this, '_report_datetime_field'));
$crud->callback_column('updated_datetime', array($this, '_report_datetime_field'));
$crud->callback_column('description', array($this, '_report_description_field'));
$crud->callback_column($this->unique_field_name('status'), array($this, '_report_status_button'));
$crud->callback_column($this->unique_field_name('category_id'), array($this, '_report_category_button'));
$crud->display_as('xxx_report_id', 'ID');
$crud->callback_edit_field('xxx_report_id', array($this, '_read_only_report_id_field'));
//$crud->fields($default_columns);
//$crud->field_type('updated_datetime','invisible');
//$crud->callback_before_update(function($post_array){
// $post_array['updated_datetime'] = date('Y-m-d H:i:s');
// return $post_array;
//});
$crud->callback_field('updated_datetime', array($this, '_set_update_time'));
$crud->callback_field('requested_datetime', array($this, '_set_requested_datetime'));
$crud->field_type('report_id', 'readonly');
$crud->callback_before_update(array($this, '_fix_zero_prio_callback'));
$crud->callback_after_update(array($this, '_check_for_status_update_after'));
if (!$this->ion_auth->is_admin()) {
$crud->unset_delete();
}
// If we're not an admin restrict list to reports we have permissions for
if (!$this->ion_auth->is_admin()) {
return $this->filter_query_permissions($crud);
} else {
return $crud;
}
}
function _set_common_report_crud($columns)
{
$crud = new grocery_CRUD();
// default columns excludes: token address_id simply because FMS/FMS-endpoint doesn't use them
$default_columns = array('report_id', 'status', 'requested_datetime', 'priority', 'category_id', 'external_id', 'media_url', 'status_notes', 'description', 'agency_responsible', 'service_notice', 'updated_datetime', 'expected_datetime', 'address', 'postal_code', 'lat', 'long', 'email', 'device_id', 'source_client', 'account_id', 'first_name', 'last_name', 'phone', 'engineer');
$columns = $columns ? $columns : $default_columns;
foreach ($columns as &$colname) {
if ($colname == 'report_id') {
$colname = 'xxx_report_id';
}
}
$crud->columns($columns);
$crud->edit_fields($default_columns);
$crud->set_theme('flexigrid');
$crud->set_table('reports');
$crud->set_subject('Problem report');
$crud->set_relation('category_id', 'categories', 'category_name', null, 'category_name ASC');
$crud->set_relation('priority', 'priorities', '<span class="fmse-prio fmse-prio{prio_value}">{prio_name}</span>', null, 'prio_value ASC');
$crud->set_relation('status', 'statuses', '<span class="fmse-status-{is_closed}">{status_name}</span>', null, 'status_name ASC');
$crud->set_relation('source_client', 'open311_clients', '<a href="/admin/open311_clients/{id}">{name}</a>', null, 'name ASC');
$crud->display_as('client_id', 'Client');
$crud->callback_column('media_url', array($this, '_linkify'));
$crud->callback_column('external_id', array($this, '_get_external_url'));
$crud->callback_edit_field('media_url', array($this, '_text_media_url_field'));
$crud->display_as('requested_datetime', 'Received')->display_as('updated_datetime', 'Updated')->display_as('expected_datetime', 'Expected')->display_as('category_id', 'Category')->display_as('media_url', 'Media URL');
$external_id_col_name = config_item('external_id_col_name');
$crud->display_as('external_id', empty($external_id_col_name) ? 'External ID' : $external_id_col_name);
$crud->unset_texteditor('address', 'status_notes', 'service_notice');
$crud->add_action('View', '/assets/fms-endpoint/images/report.png', 'admin/report');
$crud->callback_column('xxx_report_id', array($this, '_report_id_link_field'));
$crud->display_as('xxx_report_id', 'ID');
$crud->callback_edit_field('xxx_report_id', array($this, '_read_only_report_id_field'));
$crud->callback_before_update(array($this, '_fix_zero_prio_callback'));
$crud->callback_after_update(array($this, '_check_for_status_update_after'));
return $crud;
}
public function usuarios()
{
$crud = new grocery_CRUD();
$crud->set_table('usuario');
$crud->set_subject('Usuario');
$crud->required_fields('username');
$crud->columns('username', 'idperfil', 'password');
$crud->fields('username', 'idperfil', 'password');
$crud->change_field_type('password', 'password');
$crud->set_relation('idperfil', 'cat_perfil', 'descripcion');
$crud->callback_before_insert(array($this, 'encrypt_password_callback'));
$crud->callback_before_update(array($this, 'encrypt_password_callback'));
$crud->callback_edit_field('password', array($this, 'decrypt_password_callback'));
$output = $crud->render();
$this->_menu_output($output);
}
function campa_dependencia($id)
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('tp_campa');
$crud->set_subject('campa');
$crud->set_language('spanish');
$crud->fields('nombre', 'anio', 'tema', 'tipo', 'clasificacion_campa', 'etiquetas', 'objetivo', 'periodicidad_inicio', 'periodicidad_fin', 'depen', 'costo_total', 'status');
$crud->columns('nombre', 'anio', 'periodicidad_inicio', 'periodicidad_fin', 'dependencia_aux', 'costo_total', 'monto_gastado');
$crud->edit_fields('nombre', 'anio', 'tema', 'tipo', 'clasificacion_campa', 'etiquetas', 'objetivo', 'periodicidad_inicio', 'periodicidad_fin', 'depen', 'costo_total', 'status');
$crud->display_as('anio', 'Año')->display_as('periodicidad_inicio', 'Inicio')->display_as('periodicidad_fin', 'Fin')->display_as('dependencia_aux', 'Dependencia')->display_as('status', 'Estatus')->display_as('depen', 'Dependencia')->display_as('costo_total', 'Costo estimado (variable no pública)')->display_as('clasificacion_campa', 'Categoría de la campaña')->display_as('etiquetas', 'Etiquetas (separado por comas)');
$crud->callback_column('dependencia_aux', array($this, 'hacer_vinculo_dependencia_campa'));
$crud->callback_column('monto_gastado', array($this, 'obtener_monto_gastado'));
$crud->callback_column('costo_total', array($this, 'formato_dinero_costo_total'));
$crud->required_fields('nombre', 'anio', 'tema', 'depen', 'tipo', 'clasificacion_campa', 'objetivo', 'periodicidad_inicio', 'periodicidad_fin', 'costo_total', 'status');
$crud->callback_edit_field('depen', array($this, 'editar_dependencia_solicitante'));
$crud->callback_edit_field('anio', array($this, 'editar_anio_campa'));
$crud->callback_edit_field('etiquetas', array($this, 'editar_etiquetas'));
$crud->unset_add();
$crud->unset_export();
$crud->unset_print();
$crud->set_rules('costo_total', 'Costo de la campaña', 'integer');
$crud->where('depen', $id);
$crud->set_relation('tipo', 'tp_tipo_campa', 'tipo');
$crud->set_relation('clasificacion_campa', 'tp_clasificacion_campa', 'descripcion_clasificacion', null, 'id_clasificacion_campa');
$crud->set_relation('depen', 'tp_dependencia', 'dependencia');
$crud->set_relation('status', 'tp_status_campa', 'status');
$crud->add_action('Banners de la campaña', base_url() . 'imagenes/banners.png', '', '', array($this, 'modificar_url_banners'));
$crud->add_action('Facturas de la campaña', base_url() . 'imagenes/facturas.png', '', '', array($this, 'modificar_url_facturas'));
$crud->add_action('Videos de la campaña', base_url() . 'imagenes/videos.png', '', '', array($this, 'modificar_url_videos'));
$crud->add_action('Audios de la campaña', base_url() . 'imagenes/audios.png', '', '', array($this, 'modificar_url_audios'));
$crud->add_action('ver todos los datos', base_url() . 'imagenes/lupa.gif', '', '', array($this, 'modificar_url_detalle_registro'));
$crud->callback_before_delete(array($this, 'eliminar_campa'));
$crud->callback_before_update(array($this, 'actualizar_etiquetas'));
$output = $crud->render();
$data['opcion'] = 'campa';
$data['nombre_usuario'] = $this->modelo->nombre_usuario($this->session->userdata('id_usuario'));
$data['logo'] = $this->modelo->logo();
$data['url_logo'] = $this->modelo->url_logo();
$data['logo_opcional'] = $this->modelo->logo_opcional();
$data['url_logo_opcional'] = $this->modelo->url_logo_opcional();
$this->load->view('cabecera', $data);
$dependencia = $this->modelo->obtener_nombre_dependencia($id);
$data['opcion_campa'] = 'campas_dependencia';
$data['dependencia'] = $dependencia;
$this->load->view('opciones_campa', $data);
$this->load->view('campa', $output);
$data['campa_dependencia'] = '';
$data['id'] = $id;
$this->load->view('opciones_banner_imagen_otros', $data);
$this->load->view('regresar');
$this->load->view('pie');
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
function contrato_dependencia($id)
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('tp_contratos');
$crud->set_subject('contratos');
$crud->set_language('spanish');
$crud->fields('fecha_celebracion', 'num_contrato', 'monto_contrato', 'monto_gastado', 'fecha_inicio', 'depen', 'dependencia_aux', 'medio', 'medio_aux');
$crud->columns('fecha_celebracion', 'num_contrato', 'monto_contrato', 'monto_gastado', 'fecha_inicio', 'fecha_fin', 'dependencia_aux', 'medio_aux');
$crud->edit_fields('fecha_celebracion', 'num_contrato', 'monto_contrato', 'objeto_contrato', 'fecha_inicio', 'fecha_fin', 'archivo', 'depen', 'medio', 'modalidad', 'motivoadj', 'partidapres');
$crud->callback_column('dependencia_aux', array($this, 'hacer_vinculo_dependencia_medio'));
$crud->callback_column('medio_aux', array($this, 'hacer_vinculo_contrato_medio'));
$crud->callback_column('monto_gastado', array($this, 'obtener_monto_gastado'));
$crud->callback_column('monto_contrato', array($this, 'formato_dinero_monto_contratado'));
$crud->display_as('fecha_celebracion', 'Fecha de celebración')->display_as('num_contrato', 'Número de contrato')->display_as('fecha_inicio', 'Fecha inicial')->display_as('fecha_fin', 'Fecha de término')->display_as('depen', 'Dependencia')->display_as('motivoadj', 'Motivo de adjudicación')->display_as('partidapres', 'Partida presupuestal')->display_as('dependencia_aux', 'Dependencia')->display_as('medio_aux', 'Medio')->display_as('archivo', 'Contrato digitalizado');
$crud->required_fields('fecha_celebracion', 'num_contrato', 'monto_contrato', 'objeto_contrato', 'fecha_inicio', 'fecha_fin', 'depen', 'medio');
$crud->callback_add_field('depen', array($this, 'editar_dependencia_contratante'));
$crud->callback_edit_field('depen', array($this, 'editar_dependencia_contratante'));
$crud->unset_add();
$crud->unset_export();
$crud->unset_print();
$crud->where('depen', $id);
$crud->set_field_upload('archivo', 'archivos/contratos');
$crud->add_action('Facturas del contrato', base_url() . 'imagenes/facturas.png', '', '', array($this, 'modificar_url_facturas'));
$crud->add_action('ver todos los datos', base_url() . 'imagenes/lupa.gif', '', '', array($this, 'modificar_url_detalle_registro'));
$crud->set_relation('depen', 'tp_dependencia', 'dependencia');
$crud->set_relation('medio', 'tp_medios', 'nombre_comercial');
$crud->set_relation('modalidad', 'tp_modalidad_contratos', 'modalidad');
$crud->callback_before_delete(array($this, 'eliminar_contrato'));
$output = $crud->render();
$data['opcion'] = 'contratos';
$data['nombre_usuario'] = $this->modelo->nombre_usuario($this->session->userdata('id_usuario'));
$data['logo'] = $this->modelo->logo();
$data['url_logo'] = $this->modelo->url_logo();
$data['logo_opcional'] = $this->modelo->logo_opcional();
$data['url_logo_opcional'] = $this->modelo->url_logo_opcional();
$this->load->view('cabecera', $data);
$dependencia = $this->modelo->obtener_nombre_dependencia($id);
$data['opcion_contrato'] = 'contratos_dependencia';
$data['dependencia'] = $dependencia;
$this->load->view('opciones_contrato', $data);
$this->load->view('contratos', $output);
$data['contratos_dependencia'] = '';
$data['id'] = $id;
$this->load->view('opciones_banner_imagen_otros', $data);
$this->load->view('regresar');
$this->load->view('pie');
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
function buscar()
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('tp_dependencia');
$crud->set_subject('dependencia');
$crud->set_language('spanish');
$crud->fields('id_dependencia', 'dependencia');
$crud->required_fields('dependencia', 'tipo');
$crud->columns('dependencia');
$crud->edit_fields('dependencia', 'tipo');
$crud->unset_add();
$crud->unset_export();
$crud->unset_print();
$crud->add_action('Campañas de la dependencia', base_url() . 'imagenes/campa.png', '', '', array($this, 'modificar_url_campa'));
$crud->add_action('Contratos de la dependencia', base_url() . 'imagenes/contratos.png', '', '', array($this, 'modificar_url_contratos'));
$crud->callback_add_field('tipo', array($this, 'agregar_tipo'));
$crud->callback_edit_field('tipo', array($this, 'editar_tipo'));
$crud->callback_column('dependencia', array($this, 'nombre_completo'));
$dato = $this->input->post('buscar');
$crud->like('dependencia', "{$dato}");
$crud->callback_before_delete(array($this, 'eliminar_dependencia'));
$output = $crud->render();
$data['opcion'] = 'dependencias';
$data['nombre_usuario'] = $this->modelo->nombre_usuario($this->session->userdata('id_usuario'));
$data['logo'] = $this->modelo->logo();
$data['url_logo'] = $this->modelo->url_logo();
$data['logo_opcional'] = $this->modelo->logo_opcional();
$data['url_logo_opcional'] = $this->modelo->url_logo_opcional();
$this->load->view('cabecera', $data);
$data['opcion_dependencia'] = 'buscar';
$this->load->view('opciones_dependencia', $data);
$this->load->view('dependencias', $output);
$this->load->view('pie');
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
function user_owner()
{
if ($this->session->userdata('perfil') == 'admin') {
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('usuarios');
$crud->set_subject('Dueños de talleres');
$crud->columns('id_taller', 'usuario_nombres', 'usuario_mail', 'usuario_telf');
//$crud->fields('usuario_nombres', 'usuario_usuario', 'usuario_password','usuario_mail', 'usuario_telf');
//$crud->change_field_type('id_taller', 'hidden', );
$crud->change_field_type('usuario_perfil', 'hidden', 'owner');
$crud->change_field_type('id_sucursales', 'hidden', '0');
$crud->required_fields('usuario_nombres', 'id_taller', 'usuario_usuario', 'usuario_mail', 'usuario_telf');
$crud->display_as('usuario_nombres', 'Nombres dueño');
$crud->display_as('usuario_usuario', 'Login');
$crud->display_as('usuario_mail', 'Mail');
$crud->display_as('usuario_telf', 'Telf.');
$crud->display_as('usuario_password', 'Password');
$crud->display_as('id_taller', 'Nombre Taller');
$crud->change_field_type('usuario_password', 'password');
$crud->unset_read();
$crud->callback_edit_field('usuario_password', array($this, 'set_password_input_to_empty'));
$crud->callback_add_field('usuario_password', array($this, 'set_password_input_to_empty'));
$crud->set_relation('id_taller', 'talleres', 'taller_nombre');
$crud->callback_before_update(array($this, 'encrypt_password_callback'));
$crud->callback_before_insert(array($this, 'encrypt_password_callback'));
$crud->callback_edit_field('usuario_perfil', array($this, 'set_user_owner'));
$crud->callback_add_field('usuario_perfil', array($this, 'set_user_owner'));
//$crud->callback_edit_field('id_taller',array($this,'set_admin_taller'));
//$crud->callback_add_field('id_taller',array($this,'set_admin_taller'));
$crud->where('usuario_perfil =', 'owner');
$output = $crud->render();
$output->op = 'user_management';
$this->_example_output($output);
//$data['titulo'] = 'Bienvenido Administrador';
//$this->load->view('admin_view',$data);
} else {
$this->close();
}
}
public function kegiatan_lama()
{
$status = $this->input->get("status");
$crud = new grocery_CRUD();
$crud->where("tbl_kegiatan_transaksi.status", "Lama");
$crud->set_table('tbl_kegiatan_transaksi');
$crud->set_subject('Kegiatan Lama');
$crud->set_relation('change_by', 'tbl_user', 'email');
$crud->set_relation('id_user', 'tbl_user', '{nama_depan} {nama_belakang}');
$crud->set_relation('id_kegiatan_butir', 'view_kegiatan_butir', '{unsur} - {subunsur} - {butir}');
$crud->set_primary_key('id_kegiatan_butir', 'view_kegiatan_butir');
$crud->required_fields('tanggal_kegiatan', 'tanggal_kegiatan_selesai');
$crud->fields('id_user', 'id_kegiatan_butir', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'lembur', 'keterangan', 'status', 'change_by', 'change_date');
$crud->columns('id_user', 'id_kegiatan_butir', 'tanggal_kegiatan', 'tanggal_kegiatan_selesai', 'status');
$crud->display_as("id_kegiatan_butir", "Butir Kegiatan")->display_as("tanggal_kegiatan", "Tanggal Mulai")->display_as("tanggal_kegiatan_selesai", "Tanggal Selesai")->display_as("id_user", "Oleh")->display_as("change_date", "Tanggal")->display_as("id_periode", "Periode")->display_as("id_kegiatan_jabatan", "Bertindak Sebagai");
$crud->callback_add_field('id_user', array($this, '_form_get_user_callback'));
$crud->callback_edit_field('id_user', array($this, '_form_get_user_callback'));
$crud->callback_add_field('status', array($this, '_kegiatan_lama_get_status_callback'));
$crud->callback_edit_field('status', array($this, '_kegiatan_lama_get_status_callback'));
$crud->callback_before_update(array($this, 'get_change_by_callback'));
$crud->callback_before_insert(array($this, 'get_change_by_callback'));
$crud->callback_field('change_date', array($this, 'format_date_callback'));
$crud->change_field_type('id_user', 'readonly');
$crud->change_field_type('change_by', 'readonly');
$crud->change_field_type('change_date', 'readonly');
$crud->add_action('Unggah Bukti', '', 'pegawai/daftar_kegiatan_berkas', 'fa fa-upload');
$crud->unset_read();
$crud->order_by('id_kegiatan_transaksi', 'desc');
$sitemap = $this->get_sitemap();
$output = $crud->render($sitemap);
$this->load->view('theme/theme_pegawai', $output);
}
function user_managervehicle()
{
if ($this->userconfig->perfil == 'ADMIN' or $this->userconfig->perfil == 'CALL') {
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('usuarios');
$crud->set_subject('Rutas');
//$crud->columns('nombre','idsucursal','codigo','pais','departamento','ciudad','direccion','telefono','perfil');
$crud->columns('idsucursal', 'nombre');
$crud->fields('idsucursal', 'nombre', 'codigo', 'pais', 'departamento', 'ciudad', 'perfil');
$crud->required_fields('idsucursal', 'nombre', 'perfil');
$crud->display_as('nombre', 'Ruta');
$crud->change_field_type('perfil', 'hidden');
$crud->change_field_type('codigo', 'hidden');
$crud->change_field_type('pais', 'hidden');
$crud->change_field_type('departamento', 'hidden');
$crud->change_field_type('ciudad', 'hidden');
if ($this->userconfig->perfil == 'ADMIN') {
$crud->set_relation('idsucursal', 'sucursales', 'nombre');
} else {
$crud->set_relation('idsucursal', 'sucursales', 'nombre', 'id IN ("' . $this->userconfig->idsucursal . '")');
}
$crud->display_as('idsucursal', 'Sucursal');
$crud->callback_edit_field('perfil', array($this, 'set_user_cust'));
$crud->callback_add_field('perfil', array($this, 'set_user_cust'));
$crud->callback_before_update(array($this, 'encrypt_password_callback'));
$crud->callback_before_insert(array($this, 'encrypt_password_callback'));
$crud->callback_after_insert(array($this, 'set_code_rutas'));
$crud->where('perfil =', 'CUST');
$crud->order_by('idsucursal,nombre');
if ($this->userconfig->perfil != 'ADMIN') {
$crud->where('idsucursal =', $this->userconfig->idsucursal);
}
$output = $crud->render();
$output->op = 'user_management';
$this->_admin_output($output);
} else {
$this->close();
}
}
function facturas_campa($id)
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('tp_detalle_factura');
$crud->set_subject('Desglose');
$crud->set_language('spanish');
$crud->fields('factura', 'factura_aux', 'medio', 'dependencia_contratante', 'contrato', 'concepto', 'unidades', 'monto_concepto', 'dependencia_s', 'campa_factura');
$crud->display_as('dependencia_s', 'Dependencia solicitante')->display_as('campa_factura', 'Campaña')->display_as('factura_aux', 'Factura')->display_as('concepto', 'Subconcepto')->display_as('monto_concepto', 'Monto subconcepto');
$crud->unset_add();
$crud->unset_export();
$crud->unset_print();
$crud->columns('factura', 'medio', 'dependencia_contratante', 'concepto', 'unidades', 'monto_concepto');
$crud->edit_fields('concepto', 'unidades', 'monto_concepto', 'dependencia_s', 'campa_factura');
$crud->required_fields('concepto', 'unidades', 'monto_concepto', 'dependencia_s', 'campa_factura');
$crud->callback_edit_field('dependencia_s', array($this, 'editar_dependencia_solicitante'));
$crud->callback_edit_field('campa_factura', array($this, 'editar_campa'));
$crud->where('campa_factura', $id);
$crud->set_relation('factura', 'tp_factura', 'num_factura');
$crud->set_relation('dependencia_s', 'tp_dependencia', 'dependencia');
$crud->set_relation('campa_factura', 'tp_campa', 'nombre');
$crud->callback_after_upload(array($this, 'obtener_imagen_upload'));
$crud->callback_column('medio', array($this, 'hacer_vinculo_medio'));
$crud->callback_column('dependencia_contratante', array($this, 'hacer_vinculo_dependencia_contratante'));
$crud->callback_column('monto_concepto', array($this, 'formato_dinero_monto_concepto'));
$output = $crud->render();
$data['opcion'] = 'facturas';
$data['nombre_usuario'] = $this->modelo->nombre_usuario($this->session->userdata('id_usuario'));
$data['logo'] = $this->modelo->logo();
$data['url_logo'] = $this->modelo->url_logo();
$data['logo_opcional'] = $this->modelo->logo_opcional();
$data['url_logo_opcional'] = $this->modelo->url_logo_opcional();
$this->load->view('cabecera', $data);
$data['opcion_factura'] = 'detalle_factura';
$num_factura = "";
$facturas = $this->modelo->obtener_numero_factura($id);
foreach ($facturas->result() as $fila) {
$num_factura = $fila->num_factura;
}
$data['num_factura'] = $num_factura;
$this->load->view('opciones_facturas', $data);
$data['nuevo_detalle'] = '';
$data['id'] = $id;
$this->load->view('opciones_banner_imagen_otros', $data);
$totales = $this->modelo->totales_detalle_factura_campa($id);
$data['totales'] = $totales;
$this->load->view('total_detalle_factura', $data);
$this->load->view('factura', $output);
$this->load->view('regresar');
$this->load->view('pie');
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
function buscar()
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('tp_medios');
$crud->set_subject('medios');
$crud->set_language('spanish');
$crud->fields('razon_social', 'nombre_comercial', 'padron_proveedor', 'clasificacion', 'clasificacion_aux', 'cobertura');
$crud->columns('razon_social', 'nombre_comercial', 'padron_proveedor', 'clasificacion_aux', 'cobertura');
$crud->display_as('razon_social', 'Razón social')->display_as('nombre_comercial', 'Nombre comercial')->display_as('padron_proveedor', 'Número de proveedor')->display_as('clasificacion_aux', 'Clasificación')->display_as('cobertura', 'Cobertura')->display_as('perfil_demografico', 'Perfil demográfico')->display_as('tarifario', 'Tarifario')->display_as('ver_tarifario', '¿publicar tarifario?')->display_as('acta_constitutiva', 'Acta constitutiva')->display_as('curriculum_empresarial', 'Currículum empresarial')->display_as('ficha_tecnica', 'Ficha técnica')->display_as('ver_ficha_tecnica', '¿publicar ficha técnica?');
$crud->required_fields('razon_social', 'nombre_comercial', 'padron_proveedor', 'clasificacion', 'cobertura');
$crud->edit_fields('razon_social', 'nombre_comercial', 'padron_proveedor', 'clasificacion', 'cobertura', 'perfil_demografico', 'tarifario', 'ver_tarifario', 'acta_constitutiva', 'curriculum_empresarial', 'ficha_tecnica', 'ver_ficha_tecnica');
$crud->set_subject('medio');
$crud->unset_add();
$crud->unset_export();
$crud->unset_print();
$crud->set_relation('clasificacion', 'tp_clasificacion', 'descripcion_clasificacion');
$crud->set_relation('cobertura', 'tp_cobertura', 'cobertura');
$crud->set_field_upload('acta_constitutiva', 'archivos/actas_constitutivas');
$crud->set_field_upload('curriculum_empresarial', 'archivos/curriculum_empresarial');
$crud->set_field_upload('tarifario', 'archivos/tarifarios');
$crud->set_field_upload('ficha_tecnica', 'archivos/fichas_tecnica');
$crud->callback_after_upload(array($this, 'obtener_imagen_upload'));
$crud->callback_column('clasificacion_aux', array($this, 'columna_clasificacion'));
$crud->add_action('Contratos del medio', base_url() . 'imagenes/contratos.png', '', '', array($this, 'modificar_url_contratos'));
$crud->add_action('Facturas del medio', base_url() . 'imagenes/facturas.png', '', '', array($this, 'modificar_url_facturas'));
$crud->add_action('ver todos los datos', base_url() . 'imagenes/lupa.gif', '', '', array($this, 'modificar_url_detalle_registro'));
$dato = $this->input->post('buscar');
$crud->like('razon_social', "{$dato}");
$crud->or_like('nombre_comercial', "{$dato}");
$crud->or_like('descripcion_clasificacion', "{$dato}");
$crud->callback_add_field('ver_tarifario', array($this, 'agregar_ver_tarifario'));
$crud->callback_edit_field('ver_tarifario', array($this, 'editar_ver_tarifario'));
$crud->callback_add_field('ver_ficha_tecnica', array($this, 'agregar_ver_ficha_tecnica'));
$crud->callback_edit_field('ver_ficha_tecnica', array($this, 'editar_ver_ficha_tecnica'));
$crud->callback_before_delete(array($this, 'eliminar_medio'));
$output = $crud->render();
$data['opcion'] = 'medios';
$data['nombre_usuario'] = $this->modelo->nombre_usuario($this->session->userdata('id_usuario'));
$data['logo'] = $this->modelo->logo();
$data['url_logo'] = $this->modelo->url_logo();
$data['logo_opcional'] = $this->modelo->logo_opcional();
$data['url_logo_opcional'] = $this->modelo->url_logo_opcional();
$this->load->view('cabecera', $data);
$data['opcion_medio'] = 'buscar';
$this->load->view('opciones_medios', $data);
$this->load->view('medios', $output);
$this->load->view('pie');
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
function facturas_contrato($id)
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('tp_factura');
$crud->set_subject('factura');
$crud->set_language('spanish');
$crud->fields('num_factura', 'fecha', 'concepto_general', 'monto_total', 'dependencia_contratante', 'dependencia_contratante_aux', 'medio_id', 'medio_aux', 'contrato', 'contrato_aux');
$crud->columns('num_factura', 'fecha', 'concepto_general', 'monto_total', 'dependencia_contratante_aux', 'medio_aux', 'contrato_aux');
$crud->edit_fields('num_factura', 'fecha', 'concepto_general', 'monto_total', 'medio_id', 'dependencia_contratante', 'contrato');
$crud->callback_column('dependencia_contratante_aux', array($this, 'hacer_vinculo_dependencia_medio'));
$crud->callback_column('contrato_aux', array($this, 'hacer_vinculo_contrato_factura'));
$crud->callback_column('medio_aux', array($this, 'hacer_vinculo_contrato_medio'));
$crud->callback_column('monto_total', array($this, 'formato_dinero_monto_total'));
$crud->display_as('num_factura', 'Número de factura')->display_as('dependencia_contratante_aux', 'Dependencia contratante')->display_as('contrato_aux', 'Contrato')->display_as('medio_aux', 'Medio')->display_as('medio_id', 'Medio');
$crud->required_fields('num_factura', 'fecha', 'concepto_general', 'monto_total', 'dependencia_contratante', 'medio_id', 'contrato');
$crud->unset_add();
$crud->unset_export();
$crud->unset_print();
$crud->callback_edit_field('dependencia_contratante', array($this, 'editar_dependencia_contratante'));
$crud->callback_edit_field('medio_id', array($this, 'editar_medio'));
$crud->callback_edit_field('contrato', array($this, 'editar_contrato'));
$crud->where('contrato', $id);
$crud->add_action('Desglose de la factura', base_url() . 'imagenes/detalle.png', '', '', array($this, 'modificar_url_detalle'));
$crud->add_action('Factura digitalizada', base_url() . 'imagenes/imagenes.png', '', '', array($this, 'modificar_url_imagenes'));
$crud->set_relation('dependencia_contratante', 'tp_dependencia', 'dependencia');
$crud->set_relation('medio_id', 'tp_medios', 'nombre_comercial');
$crud->set_relation('contrato', 'tp_contratos', 'num_contrato');
$crud->callback_before_delete(array($this, 'eliminar_factura'));
$output = $crud->render();
$data['opcion'] = 'facturas';
$data['nombre_usuario'] = $this->modelo->nombre_usuario($this->session->userdata('id_usuario'));
$data['logo'] = $this->modelo->logo();
$data['url_logo'] = $this->modelo->url_logo();
$data['logo_opcional'] = $this->modelo->logo_opcional();
$data['url_logo_opcional'] = $this->modelo->url_logo_opcional();
$this->load->view('cabecera', $data);
$data['opcion_factura'] = 'facturas_contrato';
$contrato = $this->modelo->obtener_numero_contrato($id);
$data['contrato'] = $contrato;
$this->load->view('opciones_facturas', $data);
$this->load->view('factura', $output);
$data['facturas_contrato'] = '';
$data['id'] = $id;
$this->load->view('opciones_banner_imagen_otros', $data);
$this->load->view('regresar');
$this->load->view('pie');
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
function buscar()
{
try {
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('tp_presupuesto');
$crud->set_subject('presupuesto');
$crud->set_language('spanish');
$crud->fields('id_presupuesto', 'anio', 'monto_total');
$crud->edit_fields('anio', 'monto_total');
$crud->columns('anio', 'monto_total');
$crud->display_as('anio', 'Año')->display_as('monto_total', 'Monto total');
$crud->required_fields('anio', 'monto_total');
$crud->unset_export();
$crud->unset_print();
$crud->set_subject('presupuesto');
$crud->add_action('Desglose del presupuesto', base_url() . 'imagenes/detalle.png', '', '', array($this, 'modificar_url_desglose'));
$crud->callback_column('monto_total', array($this, 'formato_dinero'));
$crud->callback_before_delete(array($this, 'eliminar_presupuesto'));
$crud->callback_edit_field('anio', array($this, 'editar_anio_presupuesto'));
$dato = $this->input->post('buscar');
$crud->like('anio', "{$dato}");
$crud->or_like('monto_total', "{$dato}");
$output = $crud->render();
$data['opcion'] = 'presupuesto';
$data['nombre_usuario'] = $this->modelo->nombre_usuario($this->session->userdata('id_usuario'));
$data['logo'] = $this->modelo->logo();
$data['url_logo'] = $this->modelo->url_logo();
$data['logo_opcional'] = $this->modelo->logo_opcional();
$data['url_logo_opcional'] = $this->modelo->url_logo_opcional();
$this->load->view('cabecera', $data);
$data['opcion_presupuesto'] = 'ver_presupuesto';
$this->load->view('opciones_presupuesto', $data);
$this->load->view('presupuesto', $output);
$this->load->view('pie');
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
