public function index()
{
//$data['main_content'] = 'login_form';
//$this->load->view('includes/template',$data);
//$this->load->view('admin/configuration');
//$this->load->view('admin/homepage');
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('ips_ordertracking');
$crud->set_subject('Sales Tracking');
$crud->required_fields('NAME');
$crud->columns('ordertrackingid', 'orderid', 'name', 'orderdate');
// $crud->columns('fullfillment','orderdate','orderid','returnid','itemrece','caseid','product','status');
//$crud->fields('ordertrackingid','orderid','name','orderdate');
$crud->callback_column('ordertrackingid', array($this, '_callback_webpage_url'));
$crud->callback_column('orderdate', array($this, '_callback_dateformat'));
// $crud->fields('NAME');
// $crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
// $crud->callback_after_insert(array($this, 'fullfillmentid_generation'));
$output = $crud->render();
$state = $crud->getState();
if ($state == 'add') {
redirect('store/addtracking');
}
// $this->grocery_crud->set_table('ips_login');
// $output = $this->grocery_crud->render();
$this->_example_output($output);
}
function configuracion()
{
$crud = new grocery_CRUD();
$crud->set_table('usuarios');
$crud->set_theme('datatables');
$crud->set_language('spanish');
$crud->set_subject('Usuario');
$state = $crud->getState();
$state_info = $crud->getStateInfo();
if ($state == 'list' || $state == 'success') {
redirect('user/dashboard');
} else {
$crud->unset_add();
$crud->unset_delete();
$crud->field_type('usuario', 'readonly');
$crud->field_type('clave', 'password');
$crud->field_type('id_cliente', 'hidden');
$crud->field_type('id_nivel', 'hidden');
$crud->field_type('row_id', 'hidden');
$crud->field_type('id_estatus', 'hidden');
$crud->set_field_upload('foto', 'assets/uploads/users/');
$output = $crud->render();
$data['titulo'] = "CONFIGURACION DE USUARIO";
$this->load->view('include/head', $output);
$this->load->view('include/header', $data);
$this->load->view('admin/output');
$this->load->view('include/footer', $data);
$this->load->view('admin/librerias');
}
}
function perfil()
{
$crud = new grocery_CRUD();
$crud->where('row_id', $this->session->userdata('user_id'));
$crud->set_table('usuarios');
$crud->set_theme('datatables');
$crud->set_language('spanish');
$crud->set_subject('Usuario');
$state = $crud->getState();
if ($state == 'list' || $state == 'success') {
redirect('user/dashboard');
} else {
$crud->unset_add();
$crud->unset_delete();
$crud->field_type('usuario', 'readonly');
$crud->field_type('clave', 'password');
$crud->field_type('id_nivel', 'hidden');
$crud->field_type('row_id', 'hidden');
$crud->field_type('id_estatus', 'hidden');
$crud->set_field_upload('foto', 'assets/uploads/users/');
$output = $crud->render();
$data['titulo'] = "Configuración de Usuario";
$this->load->view('include/head');
$this->load->view('include/header');
$this->load->view('include/sidebar');
$this->load->view('admin/main', $data);
$this->load->view('admin/grocery_crud', $output);
$this->load->view('include/footer');
}
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('bootstrap');
$crud->set_table('user');
$crud->set_subject('Gebruiker');
// hide fields
$crud->columns('is_super_user', 'is_active', 'screen_name', 'email', 'gebruikersgroepen');
// new_password and new_password repeat are needed to make formvalidation work
// id is needed to make the email unique check work
$crud->fields('id', 'is_active', 'screen_name', 'email', 'gebruikersgroepen', 'password', 'new_password', 'new_password_repeat');
$crud->required_fields('email', 'screen_name', 'is_active');
$crud->set_relation_n_n('gebruikersgroepen', 'user_x_user_group', 'user_group', 'user_id', 'user_group_id', 'name');
$crud->field_type('id', 'hidden');
$crud->field_type('new_password_repeat', 'hidden');
$crud->field_type('password', 'hidden');
$crud->display_as('is_active', 'Actief');
$crud->display_as('screen_name', 'Schermnaam');
$crud->display_as('is_super_user', '');
$crud->display_as('new_password', 'Wachtwoord');
if ($crud->getState() == 'read') {
$crud->field_type('new_password', 'hidden');
} else {
$crud->callback_field('new_password', array($this, 'edit_field_callback_new_password'));
}
$crud->field_type('is_active', 'dropdown', array('yes' => 'ja', 'no' => 'nee'));
$crud->callback_column('is_active', array($this, 'callback_list_is_active'));
$crud->callback_column('is_super_user', array($this, 'callback_list_is_super_user'));
$crud->callback_before_insert(array($this, 'before_insert_update_callback'));
$crud->callback_before_update(array($this, 'before_insert_update_callback'));
$crud->callback_after_insert(array($this, 'after_insert_callback'));
$crud->callback_after_update(array($this, 'after_update_callback'));
if ($crud->getState() === 'update_validation' or $crud->getState() === 'insert_validation') {
$crud->set_rules('email', 'E-mail', 'required|valid_email|callback_email_unique_check');
$crud->set_rules('screen_name', 'Schermnaam', 'required');
if ($this->input->post('new_password') != '' or !$this->input->post('id')) {
$crud->set_rules('new_password', 'Nieuw wachtwoord', 'required|min_length[10]|matches[new_password_repeat]');
$crud->set_rules('new_password_repeat', 'Herhaal nieuw wachtwoord', '');
}
$this->form_validation->set_message('matches', 'De wachtwoorden zijn niet aan elkaar gelijk.');
}
// render the crud HTML
$crud_output = $crud->render();
//get the needed css and javascript files
$this->javascript_files = $crud->get_js_files();
$this->css_files = $crud->get_css_files();
// put the crud content in the right position
$this->views['content'] = $crud_output->output;
$this->css[] = $this->load->view('admin/user/css/index.css', array(), true);
// add javascript and css to make the password generate and change function possible
if ($crud->getState() === 'add' or $crud->getState() === 'edit') {
$this->css[] = $this->load->view('admin/user/css/edit_user.css', array(), true);
$this->javascript[] = $this->load->view('admin/user/js/edit_user.js', array(), true);
}
// create the layout-HTML and show it to the user
$this->_layout();
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('hotels');
$crud->set_subject('Hotels');
$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);
//var_dump($agents);
// $crud->set_relation('hotel_agent_id', 'io_users', '{first_name} {last_name}', array('active' => 1));
$crud->display_as('hotel_agent_id', 'Agent Name');
$crud->display_as('hotel_name', 'Hotel Name');
$crud->display_as('hotel_rooms', 'Rooms');
$crud->display_as('hotel_tariffs', 'Tariffs');
$crud->display_as('hotel_country', 'Country');
$crud->display_as('hotel_city', 'City');
$crud->display_as('hotel_street', 'Street');
$crud->display_as('hotel_state', 'State');
$crud->display_as('hotel_postCode', 'PostCode');
$crud->display_as('hotel_phoneNumber', 'Phone Number');
$crud->display_as('hotel_emailId', 'Email ID');
$crud->display_as('hotel_website', 'Website');
$crud->display_as('hotel_facebook', 'Facebook');
$crud->display_as('hotel_googleMap', 'Google Map');
$crud->display_as('hotel_related', 'Related Hotels');
$crud->display_as('hotel_status', 'Status');
$crud->columns('hotel_name', 'hotel_agent_id', 'hotel_phoneNumber', 'hotel_website', 'hotel_facebook', 'hotel_googleMap', 'hotel_status');
$crud->required_fields('hotel_agent_id');
$crud->field_type('hotel_stars', 'dropdown', range(0, 5));
/*
* For related hotels
* on add list all the hotels
* on edit, list all except own name
*/
$hrf = array();
if ($crud->getState() == 'edit') {
$hrf = $this->generic_model->get_by('hotels', array('hotel_status' => 1, 'hotel_id !=' => $crud->getStateInfo()->primary_key), 'hotel_id');
} else {
$hrf = $this->generic_model->get_by('hotels', array('hotel_status' => 1), 'hotel_id');
}
$hrf = $this->generic_model->array_from_db($hrf, 'hotel_id, hotel_name');
$crud->field_type('hotel_related', 'multiselect', $hrf);
$crud->callback_column('hotel_image', array($this, 'set_image'));
$crud->set_field_upload('hotel_image', $this->upload_path);
$hf = $this->generic_model->get_by('hotel_facilities', array('hf_status' => 1), 'hf_id');
$hf = $this->generic_model->array_from_db($hf, 'hf_id, hf_facility');
$crud->field_type('hotel_facilities', 'multiselect', $hf);
$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('hotel_room_facilities', 'multiselect', $hrf);
$crud->unique_fields('hotel_slug');
$crud->add_action('Photo Gallery', '', 'hotels/gallery', 'ui-icon ui-icon-image');
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Hotels', 'pagedesc' => 'Hotels', 'contenttitle' => 'Hotels List Records');
$this->load->view('gc_admin_wrapper', $data);
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('flexigrid');
$crud->set_table('hotels');
$crud->set_subject('Hotels');
// $crud->set_relation('hotel_agent_id', 'io_users', '{first_name} {last_name}');
$agent_id = $this->ion_auth->user()->row()->id;
$crud->where('hotel_agent_id', $agent_id);
$crud->field_type('hotel_agent_id', 'hidden', $agent_id);
// $crud->display_as('hotel_agent_id', 'Agent Name');
$crud->display_as('hotel_name', 'Hotel Name');
$crud->display_as('hotel_rooms', 'rooms');
$crud->display_as('hotel_tariffs', 'tariffs');
$crud->display_as('hotel_country', 'Country');
$crud->display_as('hotel_city', 'City');
$crud->display_as('hotel_street', 'Street');
$crud->display_as('hotel_state', 'State');
$crud->display_as('hotel_postCode', 'PostCode');
$crud->display_as('hotel_phoneNumber', 'Phone Number');
$crud->display_as('hotel_emailId', 'Email ID');
$crud->display_as('hotel_website', 'Website');
$crud->display_as('hotel_facebook', 'Facebook');
$crud->display_as('hotel_googleMap', 'GoogleMap');
$crud->display_as('hotel_status', 'Status');
$crud->columns('hotel_name', 'hotel_phoneNumber', 'hotel_website', 'hotel_facebook', 'hotel_googleMap', 'hotel_status');
$crud->callback_column('hotel_image', array($this, 'set_image'));
$crud->set_field_upload('hotel_image', $this->upload_path);
/*
* For related hotels
* on add list all the hotels
* on edit, list all except own name
*/
if ($crud->getState() == 'edit') {
$hrf = $this->generic_model->get_by('hotels', array('hotel_status' => 1, 'hotel_agent_id' => $this->ion_auth->get_user_id(), 'hotel_id !=' => $crud->getStateInfo()->primary_key), 'hotel_id');
} else {
$hrf = $this->generic_model->get_by('hotels', array('hotel_status' => 1, 'hotel_agent_id' => $this->ion_auth->get_user_id()), 'hotel_id');
}
// 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('hotel_related', 'multiselect', $hrf);
$hf = $this->generic_model->get_by('hotel_facilities', array('hf_status' => 1), 'hf_id');
$hf = $this->generic_model->array_from_db($hf, 'hf_id, hf_facility');
$crud->field_type('hotel_facilities', 'multiselect', $hf);
$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('hotel_room_facilities', 'multiselect', $hrf);
$crud->add_action('Photo Gallery', '', 'agents/hotels/gallery', 'ui-icon ui-icon-image');
$output = $crud->render();
$data = array('main_content' => 'list', 'output' => $output, 'pagetitle' => 'Hotels', 'pagedesc' => 'Hotels', 'contenttitle' => 'Hotels List Records', 'left_menu' => 'agents_menu');
$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 placing()
{
$crud = new grocery_CRUD();
$state = $crud->getState();
if ($state == 'add') {
$productField = $this->ModWarehouse->getProductOnlyForDropdown();
$crud->field_type('id_product', 'dropdown', $productField);
} else {
$crud->set_relation('id_product', 'product', 'name');
}
$crud->set_table('warehouse_rack_detail')->display_as('id_rack', 'Nama Rak')->display_as('id_product', 'Nama Produk')->display_as('stock', 'Stok')->display_as('satuan', 'Produk Satuan')->columns('id_rack', 'parent', 'id_product', 'satuan', 'stock')->set_relation('id_rack', 'warehouse_rack', 'name')->unset_add_fields('parent', 'total')->unset_edit_fields('parent', 'total')->callback_column('stock', array($this, 'addProductStockColumn'))->callback_column('satuan', array($this, 'setProdukSatuan'))->callback_column('parent', array($this, 'setParentRack'))->required_fields('id_rack', 'id_product')->callback_edit_field('id_product', array($this, 'setProductField'))->unset_read();
$output = $crud->render();
// $this->render($output);
$this->parser->parse('placing.tpl', $output);
}
public function index($log_type = NULL)
{
$this->load->model('shared/log_model');
$this->config->load('grocery_crud');
$this->config->set_item('grocery_crud_character_limiter', 0);
$crud = new grocery_CRUD();
if ($crud->getState() == 'list') {
// get all known log types
$log_types = $this->log_model->get_log_types();
$this->views['content'] = $this->load->view('admin/log/action_selector', array('log_types' => $log_types, 'selected_log_type' => $log_type), TRUE);
$this->javascript[] = $this->load->view('admin/log/js/action_selector.js', NULL, TRUE);
}
if (!is_null($log_type) && $log_type != 'ajax_list' && $log_type != 'export' && $log_type != 'print' && $log_type != 'ajax_list_info') {
$crud->where(array('action' => $log_type));
$crud->unset_columns('action');
}
$crud->set_theme('bootstrap');
$crud->set_table('log');
$crud->set_subject('Logs');
// Op twee velden orderen. Grocerycrud houd zich niet aan de Codeigniter active record
// maar dit werkt.
$crud->order_by('date_created desc, id', 'desc');
$crud->columns('date_created', 'action', 'message', 'user_id');
$crud->set_relation('user_id', 'user', 'screen_name');
$crud->display_as('user_id', 'Gebruiker');
$crud->display_as('date_created', 'Tijd');
$crud->display_as('action', 'Actie');
$crud->display_as('message', 'Bericht');
$crud->display_as('ip_hash', 'IP-hash');
$crud->unset_add();
$crud->unset_edit();
$crud->unset_delete();
// render the crud HTML
$crud_output = $crud->render();
//get the needed css and javascript files
$this->javascript_files = $crud->get_js_files();
$this->css_files = $crud->get_css_files();
if (isset($this->views['content'])) {
$this->views['content'] .= $crud_output->output;
} else {
$this->views['content'] = $crud_output->output;
}
$this->_layout();
}
public function index()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_model('My_Custom_model');
$crud->set_table('ips_ordertracking', 'ips_productitems');
$crud->set_subject('Sales Tracking');
$crud->required_fields('NAME');
// void set_relation_n_n( string $field_name, string $relation_table, string $selection_table, string $primary_key_alias_to_this_table, string $primary_key_alias_to_selection_table , string $title_field_selection_table [ , string $priority_field_relation ] )
$crud->set_relation_n_n('orderdetails', 'ips_ordertracking', 'ips_productitems', 'ips_ordertracking', 'ordertrackingid', 'description', 'category');
// $crud->set_relation('ordertrackingid','ips_productitems','description');
// $crud->columns('ordertrackingid','fullfillment','orderdate','orderid','returnid','itemrece','caseid','product','status','Action');
// $crud->display_as('orderdate','Order Date')->display_as('orderid','Order ID')->display_as('returnid','Sales Return ID')->display_as('itemrece','Item Received')->display_as('caseid','Case ID')->display_as('product','Product Condition')->display_as('ordertrackingid','ID');
$crud->columns('ordertrackingid', 'orderid', 'description', 'category', 'product', 'itemrece', 'cost', 'mrp', 'Action');
$crud->display_as('orderid', 'Order ID')->display_as('itemrece', 'Item Received')->display_as('product', 'Product Condition')->display_as('ordertrackingid', 'ID')->display_as('description', 'Product Name')->display_as('category', 'Category')->display_as('cost', 'Recovery Min')->display_as('mrp', 'Recovery Max');
$crud->callback_column('ordertrackingid', array($this, '_callback_webpage_url'));
$crud->callback_column('orderdate', array($this, '_callback_dateformat'));
$crud->callback_column('fullfillment', array($this, '_callback_fullfillment'));
// $crud->callback_column('product',array($this,'_callback_product'));
$crud->callback_column('status', array($this, '_callback_status'));
$crud->callback_column('itemrece', array($this, '_callback_itemrece'));
$crud->callback_column('cost', array($this, '_callback_recovery_min'));
$crud->callback_column('mrp', array($this, '_callback_recovery_max'));
$crud->callback_column('Action', array($this, '_callback_viewpage_url'));
$crud->unset_edit();
$crud->unset_read();
$crud->unset_delete();
// $crud->callback_after_insert(array($this, 'fullfillmentid_generation'));
$output = $crud->render();
$state = $crud->getState();
if ($state == 'add') {
redirect('store/addtracking');
}
if ($state == 'view') {
redirect('store/viewtracking');
}
// $this->grocery_crud->set_table('ips_login');
// $output = $this->grocery_crud->render();
$this->_example_output($output);
}
function administracion($ID = NULL)
{
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('beneficiary');
/* Le asignamos un nombre */
$crud->set_subject('Beneficiario');
/* Asignamos el idioma español */
$crud->set_language('spanish');
$state = $crud->getState();
switch ($state) {
case 'success':
if ($ID != NULL && $ID != 'success') {
//echo "success ID = " . $ID . ", state = " . $state;
$crud->where('ProductID', $ID);
}
break;
case 'list':
if ($ID != NULL) {
//echo "list ID = " . $ID . ", state = " . $state;
$crud->where('ProductID', $ID);
}
break;
case 'add':
if ($ID != "add") {
$crud->field_type('ProductID', 'hidden', $ID);
} else {
$crud->set_relation('ProductID', 'product', 'ProductID');
}
//echo "add ID = " . $ID . ", state = " . $state;
break;
default:
//echo "default ID = " . $ID . ", state = " . $state;
$crud->set_relation('ProductID', 'product', 'ProductID');
}
/* Aqui le decimos a grocery que estos campos son obligatorios */
$crud->required_fields('BeneficiaryID', 'ProductID', 'Name', 'Lastname', 'IdentType', 'Ident', 'BirthDate', 'Address', 'City');
/* Aqui le indicamos que campos deseamos mostrar */
$crud->columns('BeneficiaryID', 'ProductID', 'Name', 'Lastname', 'IdentType', 'Ident', 'BirthDate', 'Address', 'City', 'Phone1', 'Phone2', 'Phone3', 'Mail', 'Facebook', 'Twitter', 'Facebook', 'Skype', 'Company');
$crud->display_as('BeneficiaryID', 'ID');
$crud->display_as('ProductID', 'ID Producto');
$crud->display_as('Name', 'Nombre');
$crud->display_as('Lastname', 'Apellido');
$crud->display_as('IdentType', 'Tipo Identificación');
$crud->display_as('Ident', 'Identificación');
$crud->display_as('BirthDate', 'Fecha Nacimiento');
$crud->display_as('Address', 'Dirección');
$crud->display_as('City', 'Ciudad');
$crud->display_as('Phone1', 'Teléfono 1');
$crud->display_as('Phone2', 'Teléfono 2');
$crud->display_as('Phone3', 'Teléfono 3');
$crud->display_as('Company', 'Empresa');
/* Generamos la tabla */
$output = $crud->render();
/* La cargamos en la vista situada en */
$this->load->view('Beneficiary/administracion', $output);
} catch (Exception $e) {
/* Si algo sale mal cachamos el error y lo mostramos */
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
function _callback_province($value, $primarykey)
{
$html = '<link type="text/css" rel="stylesheet" href="' . base_url() . '/assets/grocery_crud/css/jquery_plugins/chosen/chosen.css" />';
$html .= '<script src="' . base_url() . '/assets/grocery_crud/js/jquery_plugins/jquery.chosen.min.js"></script>';
$html .= '<script src="' . base_url() . '/assets/grocery_crud/js/jquery_plugins/config/jquery.chosen.config.js"></script>';
$empty_select = '<select name="province" class="chosen-select" data-placeholder="Select Province" style="width: 300px; display: none;">';
$empty_select_closed = '</select>';
$province = null;
$listingID = null;
$crud = new grocery_CRUD();
$state = $crud->getState();
//CHECK FOR A URI VALUE AND MAKE SURE ITS ON THE EDIT STATE
if ($state == 'edit') {
$state_info = $crud->getStateInfo();
$listingID = $state_info->primary_key;
$placeID = $this->shared_model->get_place_id($listingID, 'crop_history', 'crophist_id');
$data = $this->shared_model->get_by_place_id($placeID);
$province = $data->province;
}
$empty_select .= '<option value=""></option>';
$db = $this->shared_model->get_province();
//APPEND THE OPTION FIELDS WITH VALUES FROM THE STATES PER THE COUNTRY ID
foreach ($db->result() as $row) {
if ($row->province == $province) {
$empty_select .= '<option value="' . $row->province . '" selected="selected">' . $row->province . '</option>';
} else {
$empty_select .= '<option value="' . $row->province . '">' . $row->province . '</option>';
}
}
//RETURN SELECTION COMBO
return $html . $empty_select . $empty_select_closed;
}
public function email_configuration()
{
try {
$crud = new grocery_CRUD();
$state = $crud->getState();
$crud->set_table('tbl_email_konfigurasi');
$crud->set_subject('Konfigurasi Email');
$crud->fields('useragent', 'protocol', 'mailpath', 'smtp_host', 'smtp_user', 'name', 'smtp_pass', 'smtp_port', 'smtp_timeout', 'smtp_crypto', 'wordwrap', 'wrapchars', 'mailtype', 'charset', 'validate', 'priority', 'crlf', 'newline', 'bcc_batch_mode', 'bcc_batch_size');
$crud->columns('smtp_host', 'smtp_user', 'name');
$crud->unset_read();
$sitemap = $this->get_sitemap();
$output = $crud->render($sitemap);
$this->load->view('theme/theme_default', $output);
} catch (Execption $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
function empty_subcategoria_select()
{
$empty_select = '<select name="IdSubcategoria" class="chosen-select" data-placeholder="Seleccione SubCategoría">';
$empty_select_closed = '</select>';
$listingID = $this->uri->segment(4);
$crud = new grocery_CRUD();
$state = $crud->getState();
if (isset($listingID) && $state == "edit") {
$this->db->select('IdCategoria, IdSubcategoria')->from('producto')->where('IdProducto', $listingID);
$db = $this->db->get();
$row = $db->row(0);
$idCategoria = $row->IdCategoria;
$idSubcategoria = $row->IdSubcategoria;
$this->db->select('*')->from('subcategoriaproducto')->where('IdCategoria', $idCategoria)->order_by('Nombre');
$db = $this->db->get();
foreach ($db->result() as $row) {
if ($row->IdSubcategoria == $idSubcategoria) {
$empty_select .= '<option value="' . $row->IdSubcategoria . '" selected="selected">' . $row->Nombre . '</option>';
} else {
$empty_select .= '<option value="' . $row->IdSubcategoria . '">' . $row->Nombre . '</option>';
}
}
return $empty_select . $empty_select_closed;
} else {
return $empty_select . $empty_select_closed;
}
}
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 persutujuan_daftar_kegiatan_berkas()
{
try {
$crud = new grocery_CRUD();
$state = $crud->getState();
$id_kegiatan_transaksi = $this->uri->segment(3);
$crud->where('id_kegiatan_transaksi', $id_kegiatan_transaksi);
$crud->set_table('tbl_kegiatan_transaksi_berkas');
$crud->set_subject('Daftar Berkas Pegawai');
$crud->set_field_upload('berkas', 'assets/uploads/berkas');
$crud->fields('no', 'judul', 'berkas', 'keterangan');
$crud->columns('no', 'judul', 'berkas', 'keterangan');
$crud->order_by('id_kegiatan_transaksi_berkas', 'desc');
//$crud->change_field_type('nama_depan', 'readonly');
$crud->unset_save();
$crud->unset_add();
$crud->unset_edit();
$crud->unset_read();
$crud->unset_delete();
$sitemap = $this->get_sitemap();
$output = $crud->render($sitemap);
$this->load->view('theme/theme_pegawai', $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 supervisor_management()
{
$id = $this->ion_auth->user()->row()->id;
$this->load->library('grocery_CRUD');
try {
$crud = new grocery_CRUD();
$this->load->library('user_agent');
if ($this->agent->is_mobile() && $this->agent->is_tablet() === FALSE) {
$crud->set_theme('bootstrap');
$crud->unset_search();
} else {
$crud->set_theme('datatables');
//datatables, flexigrid, bootstrap
}
$crud->set_table('users');
$crud->set_subject('Supervisor');
$crud->columns('username', 'password_visible', 'su_branch_id', 'su_can_uploadhotdeal');
$crud->required_fields('username', 'password_visible', 'su_branch_id');
$crud->fields('username', 'password_visible', 'su_branch_id', 'su_can_uploadhotdeal');
$crud->display_as('password_visible', 'Password');
$crud->display_as('su_branch_id', 'Branch');
$crud->display_as('su_can_uploadhotdeal', 'Able to upload food & beverage');
$crud->callback_add_field('su_branch_id', array($this, '_selected_branch_callback'));
//For add page set pre-selected value if got pass in brach id
$crud->field_type('su_branch_id', 'dropdown', $this->ion_auth->get_merchant_branch_list($id));
//For view show the branch list text
$crud->callback_insert(array($this, 'supervisor_insert_callback'));
$crud->callback_update(array($this, 'supervisor_update_callback'));
$crud->set_rules('username', 'Username', 'trim|required|callback_supervisor_username_check');
$crud->field_type('su_can_uploadhotdeal', 'true_false');
$controller = 'merchant';
$function = 'profile';
$crud->set_lang_string('insert_success_message', 'Your data has been successfully stored into the database.
<script type="text/javascript">
var originallocation = window.location.pathname;
if(originallocation.indexOf("/supervisor/add") > -1)
{
window.location = "' . site_url($controller . '/' . $function) . '";
}
</script>
<div style="display:none">
');
$crud->set_lang_string('update_success_message', 'Your data has been successfully stored into the database.
<script type="text/javascript">
var originallocation = window.location.pathname;
if(originallocation.indexOf("/supervisor/edit") > -1)
{
window.location = "' . site_url($controller . '/' . $function) . '";
}
</script>
<div style="display:none">
');
$crud->set_lang_string('form_save_and_go_back', 'Save and View Supervisor');
$crud->set_lang_string('form_update_and_go_back', 'Update and View Supervisor');
$crud->unset_export();
$crud->unset_print();
$crud->unset_read();
$state = $crud->getState();
//filter that this is supervisor type user and it is under this merchant
$crud->where('su_merchant_id', $id);
$crud->where('main_group_id', $this->group_id_supervisor);
$output = $crud->render();
return $output;
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
function office_management()
{
if ($this->userconfig->perfil == 'ADMIN') {
$crud = new grocery_CRUD();
$this->load->library('googlemaps');
$crud->set_theme('datatables');
$crud->set_table('sucursales');
$crud->set_subject('sucursales');
$crud->columns('nombre');
$crud->fields('nombre', 'latitud', 'longitud');
$crud->required_fields('nombre');
$crud->display_as('nombre', 'Nombre sucursal');
$output = $crud->render();
$output->op = 'office_management';
$state = $crud->getState();
$state_info = $crud->getStateInfo();
$primary_key = '-1';
if ($state == 'edit') {
$this->load->model('sqlexteded');
$primary_key = $state_info->primary_key;
$sucursal = $this->sqlexteded->getLatLngOficce($primary_key);
$config['center'] = $sucursal->latitud . ', ' . $sucursal->longitud;
$config['zoom'] = '14';
$config['map_width'] = '98%';
//$config['onclick'] = 'alert(\'You just clicked at: \' + event.latLng.lat() + \', \' + event.latLng.lng());';
$this->googlemaps->initialize($config);
$marker = array();
$marker['position'] = $config['center'];
$marker['draggable'] = TRUE;
$marker['animation'] = 'DROP';
$marker['icon'] = base_url() . 'assets/images/colegio.png';
$marker['ondragend'] = "\$('#field-latitud').val(event.latLng.lat()); \$('#field-longitud').val(event.latLng.lng());";
$this->googlemaps->add_marker($marker);
$output->map = $this->googlemaps->create_map();
}
$output->state = $state;
$output->primary_key = $primary_key;
$this->_admin_output($output);
} else {
$this->close();
}
}
function administracion($ID = NULL)
{
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');
//$crud->set_theme('datatables');
/* Seleccionmos el nombre de la tabla de nuestra base de datos*/
$crud->set_table('charge');
/* Le asignamos un nombre */
$crud->set_subject('Movimientos');
/* Asignamos el idioma español */
$crud->set_language('spanish');
$state = $crud->getState();
switch ($state) {
case 'success':
if ($ID != NULL && $ID != 'success') {
//echo "success ID = " . $ID . ", state = " . $state;
$crud->where('ProductID', $ID);
}
break;
case 'list':
if ($ID != NULL) {
//echo "list ID = " . $ID . ", state = " . $state;
$crud->where('ProductID', $ID);
}
break;
case 'add':
if ($ID != "add") {
$crud->field_type('ProductID', 'hidden', $ID);
} else {
$crud->set_relation('ProductID', 'product', 'ProductID');
}
//echo "add ID = " . $ID . ", state = " . $state;
break;
default:
//echo "default ID = " . $ID . ", state = " . $state;
$crud->set_relation('ProductID', 'product', 'ProductID');
}
$crud->set_relation('MethodID', 'method', 'Description');
$crud->set_relation('ChConceptID', 'concept', 'Description');
/* Aqui le decimos a grocery que estos campos son obligatorios */
$crud->required_fields('ChargeID', 'ProductID', 'Reference', 'ChargeDate', 'ChargeType', 'ChConceptID', 'Value', 'MethodID', 'Entity');
/* Aqui le indicamos que campos deseamos mostrar */
$crud->columns('ChargeID', 'ProductID', 'Reference', 'ChargeDate', 'ChargeType', 'ChConceptID', 'Value', 'MethodID', 'Entity', 'Comment');
$crud->display_as('ChargeID', 'ID');
$crud->display_as('ProductID', 'Producto');
$crud->display_as('Reference', 'Referencia');
$crud->display_as('ChargeDate', 'Fecha Movimiento');
$crud->display_as('ChargeType', 'Tipo Movimiento');
$crud->display_as('ChConceptID', 'Concepto');
$crud->display_as('Value', 'Valor');
$crud->display_as('MethodID', 'Metodo');
$crud->display_as('Entity', 'Entidad');
$crud->display_as('Comment', 'Comentario');
$crud->set_rules('Value', 'Valor', 'numeric|greater_than[0]|callback_ValidBalance');
//http://www.grocerycrud.com/documentation/options_functions/set_rules
$crud->set_rules('ChargeType', 'Tipo Movimiento', 'in_list[Credito]');
// Log User_ID
$crud->callback_before_insert(array($this, 'Set_User_ID'));
// Procesos posteriores al registro del movimiento
$crud->callback_after_insert(array($this, 'ProcessCharge'));
// No permite borrado, actualizacion de movimientos
$crud->change_field_type('user_id', 'invisible');
$crud->unset_delete();
$crud->unset_edit();
//$crud->set_rules('Value', 'Valor', 'callback_ValidBalance');
/* Generamos la tabla */
$output = $crud->render();
/* La cargamos en la vista situada en */
$this->load->view('Charge/administracion', $output);
} catch (Exception $e) {
/* Si algo sale mal cachamos el error y lo mostramos */
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function daftar_kegiatan_status($status = NULL)
{
try {
$status = $this->uri->segment(3);
$id_user = $this->get_user_login();
$crud = new grocery_CRUD();
$state = $crud->getState();
$crud->set_table('view_kegiatan_transaksi');
$crud->set_primary_key('id_kegiatan_transaksi');
$crud->where("id_user", $id_user);
$crud->where("status", $status);
$crud->set_subject('Daftar Kegiatan');
$crud->columns('subunsur', 'butir', 'satuan_hasil', 'angka_kredit', 'keterangan');
$crud->callback_column('butir', array($this, '_callback_daftar_kegiatan_column'));
$crud->callback_column('subunsur', array($this, '_callback_daftar_kegiatan_column'));
$crud->callback_column('satuan_hasil', array($this, '_callback_daftar_kegiatan_column'));
//$crud->add_action('Edit', '', 'pegawai/daftar_kegiatan_transaksi/edit/','fa fa-pencil');
$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());
}
}
public function paragraph()
{
if (!is_super_user()) {
redirect(site_url('admin/help'));
}
$this->load->config('grocery_crud');
$this->config->set_item('grocery_crud_text_editor_type', 'minimal');
$crud = new grocery_CRUD();
$crud->set_theme('bootstrap');
$crud->set_table('help_paragraph');
$crud->set_subject("Documentatie alinea's");
$crud->unset_add_fields('date_modified');
$crud->unset_edit_fields('page_id', 'date_modified');
$crud->field_type('date_created', 'invisible');
$crud->field_type('user_id', 'invisible');
$crud->field_type('order', 'hidden');
$crud->callback_add_field('page_id', array($this, 'paragraph_callback_add_field_page_id'));
$crud->callback_before_insert(array($this, 'paragraph_callback_before_insert'));
$crud->callback_before_update(array($this, 'paragraph_callback_before_update'));
$crud->callback_after_insert(array($this, 'save_to_sql'));
$crud->callback_after_update(array($this, 'save_to_sql'));
$crud->callback_after_delete(array($this, 'save_to_sql'));
$crud->required_fields('key', 'title', 'content', 'is_visible');
// render the crud HTML
$crud_output = $crud->render();
if ($crud->getState() == 'list') {
redirect(site_url('admin/help'));
} else {
if ($crud->getState() == 'success') {
$this->session->set_flashdata('form_submit', 'success');
$this->session->set_flashdata('form_message', 'Alinea met succes opgeslagen.');
$state = $crud->getStateInfo();
$this->load->model('admin/help_model');
$paragraph = $this->help_model->get_paragraph($state->primary_key, 'off');
redirect(site_url('admin/help/index/' . $paragraph['page_id'] . '#' . $paragraph['key']));
}
}
$this->javascript_files = $crud->get_js_files();
$this->css_files = $crud->get_css_files();
$this->views['content'] = $crud_output->output;
$this->_layout();
}
public function index($language = '')
{
// bepaal de taal
$data['languages'] = $this->config->item('languages');
$data['language_data'] = $this->config->item('language_data');
if (!in_array($language, $data['languages'])) {
$data['language'] = $data['languages'][0];
} else {
$data['language'] = $language;
}
// voor de callback
$this->language = $data['language'];
$crud = new grocery_CRUD();
$crud->set_theme('bootstrap');
$crud->set_table('app_email');
$crud->set_subject('E-mail');
$crud->where('language', $data['language']);
$crud->unset_print();
$crud->unset_export();
$crud->unset_read();
if (!is_super_user()) {
$crud->unset_add();
$crud->unset_delete();
$fields = array('subject', 'message');
// get email if state is edit to retrieve availability for from and to
if ($crud->getState() == 'edit' || $crud->getState() == 'update' || $crud->getState() == 'update_validation' || $crud->getState() == 'read') {
// edit state -> get item
$email_id = $this->uri->rsegment($this->uri->total_rsegments());
if (intval($email_id)) {
$this->load->model('admin/app_email_model');
$email = $this->app_email_model->get_by_id($email_id);
if ($email['from_available'] == 'yes') {
$fields[] = 'from_name';
$fields[] = 'from_email';
}
if ($email['to_available'] == 'yes') {
$fields[] = 'to_name';
$fields[] = 'to_email';
}
}
}
$crud->fields($fields);
$crud->required_fields($fields);
$crud->columns('subject', 'message');
} else {
$crud->required_fields('key', 'subject', 'from_available', 'to_available', 'template');
$crud->columns('key', 'subject', 'message', 'from_available', 'to_available', 'template');
}
$crud->display_as('key', 'Sleutel')->display_as('subject', 'Onderwerp')->display_as('message', 'Bericht')->display_as('from_available', 'Afzender')->display_as('to_available', 'Ontvanger')->display_as('from_name', 'Naam afzender')->display_as('from_email', 'E-mail afzender')->display_as('to_name', 'Naam ontvanger')->display_as('to_email', 'E-mail ontvanger');
$crud->field_type('from_available', 'dropdown', array('no' => 'Instellen in code', 'yes' => 'Instellen in CMS'));
$crud->field_type('to_available', 'dropdown', array('no' => 'Instellen in code', 'yes' => 'Instellen in CMS'));
$crud->callback_before_insert(array($this, 'before_insert_callback'));
$crud->change_field_type('language', 'invisible');
// render the crud HTML
$crud_output = $crud->render();
$this->javascript_files = $crud->get_js_files();
$this->css_files = $crud->get_css_files();
$data['state'] = $crud->getState();
$this->javascript[] = $this->load->view('admin/email/js/index.js', NULL, TRUE);
$this->views['content'] = $this->load->view('admin/email/index', $data, TRUE);
$this->views['content'] .= $crud_output->output;
$this->_layout();
}
function administracion($ID = NULL, $parent_table = NULL, $fieldID = NULL, $field_show = NULL)
{
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');
$crud->set_theme('datatables');
/* Seleccionamos el nombre de la tabla de nuestra base de datos*/
$crud->set_table('product');
/* Le asignamos un nombre */
$crud->set_subject('Producto');
/* Asignamos el idioma español */
$crud->set_language('spanish');
/* ALA - 10/11/2015 : Condiciona invocación maestro detalle */
$state = $crud->getState();
//echo " ID = " . $ID . ", state = " . $state . ", parent_table = " . $parent_table . "FieldID = " . $fieldID;
switch ($state) {
case 'success':
if (is_numeric($ID)) {
//echo "success ID = " . $ID . ", state = " . $state;
$crud->where($fieldID, $ID);
}
$crud->set_relation('PrClientID', 'client', 'Ident');
$crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}');
break;
case 'list':
if (is_numeric($ID)) {
//echo "list ID = " . $ID . ", state = " . $state;
$crud->where($fieldID, $ID);
}
$crud->set_relation('PrClientID', 'client', 'Ident');
$crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}');
break;
case 'add':
if ($parent_table == NULL) {
$crud->set_relation('PrClientID', 'client', 'Ident');
$crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}');
} elseif ($parent_table == 'client') {
$crud->field_type('PrClientID', 'hidden', $ID);
$crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}');
} elseif ($parent_table == 'vendor') {
$crud->field_type('PrVendorID', 'hidden', $ID);
$crud->set_relation('PrClientID', 'client', 'Ident');
}
//echo "add ID = " . $ID . ", state = " . $state;
break;
case "read":
$crud->set_relation('PrClientID', 'client', 'Ident');
$crud->set_relation('PrVendorID', 'vendor', '{Name} {Lastname}');
}
$crud->set_relation('PrProductCatalogID', 'productcatalog', 'Description');
/* Aqui le decimos a grocery que estos campos son obligatorios */
$crud->required_fields('ProductID', 'PrProductCatalogID', 'Contract', 'PrClientID', 'PrVendorID', 'StartDate', 'EndDate', 'Balance');
/* Aqui le indicamos que campos deseamos mostrar */
$crud->columns('ProductID', 'PrProductCatalogID', 'Contract', 'PrClientID', 'PrVendorID', 'StartDate', 'EndDate', 'Balance');
$crud->display_as('ProductID', 'ID');
$crud->display_as('PrProductCatalogID', 'Producto');
$crud->display_as('Contract', 'Contrato');
$crud->display_as('PrClientID', 'Cliente');
$crud->display_as('PrVendorID', 'Vendedor');
$crud->display_as('StartDate', 'Fecha Inicio Vigencia');
$crud->display_as('EndDate', 'Fecha Fin Vigencia');
$crud->display_as('Balance', 'Saldo');
$crud->set_rules('EndDate', 'Fecha Vigencia', 'callback_ValidProd');
//http://www.grocerycrud.com/documentation/options_functions/set_rules
$crud->unset_add_fields('Balance');
$crud->unset_edit_fields('Balance');
$crud->add_action('Beneficiarios', base_url() . 'assets/uploads/detalle.png', 'Beneficiary/administracion');
$crud->add_action('Movimientos', base_url() . 'assets/uploads/money.png', 'Charge/administracion');
// Procesos posteriores a la venta
$crud->callback_after_insert(array($this, 'Process_Sale'));
/* Generamos la tabla */
$output = $crud->render();
/* La cargamos en la vista situada en
/applications/views/product/administracion.php */
$this->load->view('Product/administracion', $output);
} catch (Exception $e) {
/* Si algo sale mal cachamos el error y lo mostramos */
//log_message($e->getMessage().' --- '.$e->getTraceAsString());
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
public function table()
{
// redirect if user isn't logged in
if (!$this->ion_auth->logged_in()) {
redirect('/');
}
$crud = new grocery_CRUD();
$crud->where('user_id', $this->user->id);
$crud->set_table('New_userStocks')->fields('company_id', 'boughtDate', 'boughtPrice', 'shares', 'boughtCommission', 'soldDate', 'soldPrice', 'soldCommission', 'scInspired', 'userNotes', 'expert_id')->set_subject('Investment')->columns('company_id', 'boughtDate', 'userNotes', 'boughtPrice', 'shares', 'boughtCommission', 'soldDate', 'soldPrice', 'soldCommission', 'profit')->display_as('company_id', 'Company<br>(Chart for last 6 months)')->display_as('boughtDate', 'Bought<br>(Chart since buy)')->display_as('boughtPrice', 'Purchase Price')->display_as('shares', 'Shares')->display_as('boughtCommission', 'Bought Commission Cost')->display_as('soldCommission', 'Selling Commission Cost')->display_as('soldDate', 'Sold')->display_as('soldPrice', 'Sale<br>or<br>Current<br>Price')->callback_insert(array($this, '_callback_insert'))->callback_column('soldPrice', array($this, '_callback_SoldPrice'))->field_type('userNotes', 'text')->field_type('user_id', 'readonly')->callback_column('profit', array($this, '_callback_Profit'))->display_as('scInspired', 'StockChase Inspired')->display_as('userNotes', 'Notes')->callback_column($this->unique_field_name('company_id'), array($this, '_callback_company_url'))->callback_column('boughtDate', array($this, '_callback_boughtDate'))->callback_column('userNotes', array($this, '_callback_Price'))->set_relation('company_id', 'New_company', '{name}')->set_relation('expert_id', 'New_expert', '{name}<!--{id}-->');
if ($crud->getState() == 'list') {
$crud->display_as('boughtCommission', '+Cost')->set_relation('company_id', 'New_company', '{symbol} {name}')->display_as('soldCommission', '+Cost');
}
if ($crud->getState() == 'add') {
$this->input->user_id = $this->user->id;
}
$crud->field_type('scInspired', 'true_false', array('No', 'Yes'));
$crud->field_type('boughtDate', 'date');
$crud->required_fields('company_id');
$detailoutput = '';
$table_view = $crud->render();
$this->template->title('My Portfolio');
$this->template->build('portfoliog', $table_view);
//$this->load->view('example.php',$crud->render());//<input id='field-boughtDate' name='boughtDate' type='text' value='' maxlength='10' class='datepicker-input' />
}
function generate_coupon()
{
$crud = new grocery_CRUD();
//$this->load->library('controllers/admin');
$crud->set_theme('datatables');
$crud->set_table('coupon_code');
$crud->set_subject('Coupon Code');
$output = $crud->render();
$state = $crud->getState();
$state_info = $crud->getStateInfo();
if ($state == 'add') {
//$this->load->view('generate_coupon_code.php');
$this->generate_coupon_code();
} else {
$this->_example_output($output);
}
}
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 customers_management2()
{
$crud = new grocery_CRUD();
$crud->set_table('customers');
$crud->columns('customerName', 'contactLastName', 'phone', 'city', 'country', 'salesRepEmployeeNumber', 'creditLimit');
$crud->display_as('salesRepEmployeeNumber', 'from Employeer')->display_as('customerName', 'Name')->display_as('contactLastName', 'Last Name');
$crud->set_subject('Customer');
$crud->set_relation('salesRepEmployeeNumber', 'employees', 'lastName');
$crud->set_crud_url_path(site_url(strtolower(__CLASS__ . "/" . __FUNCTION__)), site_url(strtolower(__CLASS__ . "/multigrids")));
$output = $crud->render();
if ($crud->getState() != 'list') {
$this->_example_output($output);
} else {
return $output;
}
}
public function tim_penilai()
{
try {
$crud = new grocery_CRUD();
$state = $crud->getState();
$crud->where('user_kategori', 'penilai');
$crud->set_table('view_user');
$crud->set_primary_key('id_user');
$crud->set_subject('Tim Penilai');
$crud->set_relation_n_n('Users', 'tbl_penilai_user', 'tbl_user', 'id_user_penilai', 'id_user_pegawai', 'nama_depan', NULL, array('id_user_kategori' => 3));
$crud->fields('nama_depan', 'Users');
$crud->columns('nama_depan', 'nip', 'jenjang_jabatan', 'jenjang_golongan');
$crud->display_as("Users", "Pegawai")->display_as("nama_depan", "Tim Penilai");
$crud->order_by('nama_belakang', 'asc');
//$crud->change_field_type('nama_depan', 'readonly');
$crud->unset_save();
$crud->unset_read();
$crud->unset_delete();
$sitemap = $this->get_sitemap();
$output = $crud->render($sitemap);
$this->load->view('theme/theme_default', $output);
} catch (Exception $e) {
show_error($e->getMessage() . ' --- ' . $e->getTraceAsString());
}
}
