Pada hari Sabtu,7 juli 2018 , Seperti biasa akan menceritakan pengalaman , langsung saja yah :D.
Selamat Pagi Gaes . Semoga Sehat Selalu .
Sudah terasa ya gaes 1 minggu terlewati . Pada hari Sabtu,7 Juli 2018 seperti biasa saya berangkat dari kosannya ke Duxeos . Pada hari itu saya belajar menggunakan template Grocery Crud di CodeIgniter . Seperti biasa saya download dulu Grocery Crud di website ini https://www.grocerycrud.com/ . seperti biasanya kita mengextrak lagi Codeigniter di folder xampp/htdocs., seperti biasa saya kita mengantikan nama folder codeigniter diganti sesuai keinginan anda . dan kita juga mengextrak file grocerycrud di folder codeigniter itu . Grocery adalah sebuah library yang sudah ada datanya mungkin seperti itu lah .. Bagaimana memasangnya ?..
Pertama kita buat database dulu nama nya example dan import database yang baru kita buat . Seperti biasa kita mengedit lagi di folder config . di file autoload,config,databases .
Ikuti coding seperti ini $autoload['libraries'] = array('Grocery_CRUD','database','session','xmlrpc');,$autoload['helper'] = array('url');,
Seperti biasa kita juga mengedit di config pada base_url $config['base_url'] = 'http://localhost/ci_grocery'; . Dan mengedit di database seperti ini $db['default'] = array(
'dsn' => '',
'hostname' => '127.0.0.1',
'username' => 'root',
'password' => '',
'database' => 'example',
'dbdriver' => 'mysqli',
'dbprefix' => '',
'pconnect' => FALSE,
'db_debug' => (ENVIRONMENT !== 'production'),
'cache_on' => FALSE,
'cachedir' => '',
'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'encrypt' => FALSE,
'compress' => FALSE,
'stricton' => FALSE,
'failover' => array(),
'save_queries' => TRUE
);
Kita membuat Controller dengan nama Data.php dan ketikan coding seperti ini
<?php
Class Data extends CI_Controller {
function __construct() {
parent::__construct();
}
function index() {
}
public function employees() {
// instance object
$crud = new grocery_CRUD();
// pilih tabel yang akan digunakan
$crud->set_table('employees');
// simpan hasilnya kedalam variabel output
$output = $crud->render();
// tampilkan di view
//$this->_example_output($output);
$this->load->view('template.php', $output);
}
}
dan buat lagi controller dengan nama Examples.php kodingkan seperti ini .
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Examples extends CI_Controller {
public function __construct()
{
parent::__construct();
$this->load->database();
$this->load->helper('url');
$this->load->library('grocery_CRUD');
}
public function _example_output($output = null)
{
$this->load->view('example.php',(array)$output);
}
public function offices()
{
$output = $this->grocery_crud->render();
$this->_example_output($output);
}
public function index()
{
$this->_example_output((object)array('output' => '' , 'js_files' => array() , 'css_files' => array()));
}
public function offices_management()
{
try{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('offices');
$crud->set_subject('Office');
$crud->required_fields('city');
$crud->columns('city','country','phone','addressLine1','postalCode');
$output = $crud->render();
$this->_example_output($output);
}catch(Exception $e){
show_error($e->getMessage().' --- '.$e->getTraceAsString());
}
}
public function employees_management()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('employees');
$crud->set_relation('officeCode','offices','city');
$crud->display_as('officeCode','Office City');
$crud->set_subject('Employee');
$crud->required_fields('lastName');
$crud->set_field_upload('file_url','assets/uploads/files');
$output = $crud->render();
$this->_example_output($output);
}
public function customers_management()
{
$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');
$output = $crud->render();
$this->_example_output($output);
}
public function orders_management()
{
$crud = new grocery_CRUD();
$crud->set_relation('customerNumber','customers','{contactLastName} {contactFirstName}');
$crud->display_as('customerNumber','Customer');
$crud->set_table('orders');
$crud->set_subject('Order');
$crud->unset_add();
$crud->unset_delete();
$output = $crud->render();
$this->_example_output($output);
}
public function products_management()
{
$crud = new grocery_CRUD();
$crud->set_table('products');
$crud->set_subject('Product');
$crud->unset_columns('productDescription');
$crud->callback_column('buyPrice',array($this,'valueToEuro'));
$output = $crud->render();
$this->_example_output($output);
}
public function valueToEuro($value, $row)
{
return $value.' €';
}
public function film_management()
{
$crud = new grocery_CRUD();
$crud->set_table('film');
$crud->set_relation_n_n('actors', 'film_actor', 'actor', 'film_id', 'actor_id', 'fullname','priority');
$crud->set_relation_n_n('category', 'film_category', 'category', 'film_id', 'category_id', 'name');
$crud->unset_columns('special_features','description','actors');
$crud->fields('title', 'description', 'actors' , 'category' ,'release_year', 'rental_duration', 'rental_rate', 'length', 'replacement_cost', 'rating', 'special_features');
$output = $crud->render();
$this->_example_output($output);
}
public function film_management_twitter_bootstrap()
{
try{
$crud = new grocery_CRUD();
$crud->set_theme('twitter-bootstrap');
$crud->set_table('film');
$crud->set_relation_n_n('actors', 'film_actor', 'actor', 'film_id', 'actor_id', 'fullname','priority');
$crud->set_relation_n_n('category', 'film_category', 'category', 'film_id', 'category_id', 'name');
$crud->unset_columns('special_features','description','actors');
$crud->fields('title', 'description', 'actors' , 'category' ,'release_year', 'rental_duration', 'rental_rate', 'length', 'replacement_cost', 'rating', 'special_features');
$output = $crud->render();
$this->_example_output($output);
}catch(Exception $e){
show_error($e->getMessage().' --- '.$e->getTraceAsString());
}
}
function multigrids()
{
$this->config->load('grocery_crud');
$this->config->set_item('grocery_crud_dialog_forms',true);
$this->config->set_item('grocery_crud_default_per_page',10);
$output1 = $this->offices_management2();
$output2 = $this->employees_management2();
$output3 = $this->customers_management2();
$js_files = $output1->js_files + $output2->js_files + $output3->js_files;
$css_files = $output1->css_files + $output2->css_files + $output3->css_files;
$output = "<h1>List 1</h1>".$output1->output."<h1>List 2</h1>".$output2->output."<h1>List 3</h1>".$output3->output;
$this->_example_output((object)array(
'js_files' => $js_files,
'css_files' => $css_files,
'output' => $output
));
}
public function offices_management2()
{
$crud = new grocery_CRUD();
$crud->set_table('offices');
$crud->set_subject('Office');
$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 employees_management2()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('employees');
$crud->set_relation('officeCode','offices','city');
$crud->display_as('officeCode','Office City');
$crud->set_subject('Employee');
$crud->required_fields('lastName');
$crud->set_field_upload('file_url','assets/uploads/files');
$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 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;
}
}
}
kita tidak perlu membuat View dan Model lagi karena sudah ada dari GroceryCrud tadi .
Sesudah itu saya mencoba mendownload Unity untuk Membuat AR .
Sesudah itu saya mencoba mendownload Unity untuk Membuat AR .
Sekian dari saya pengalaman hari ini .
Tetap Semangat !!!.