Example 1: a simple query to get data

$data = $this->My_model_name->table()->get()->result();

Example 2: a simple query with join statement to get data

$data = $this->My_model_name->table('t1')
              ->join('my_other_table_name AS t2', 't1.id_fk = t2.id_fk')
              ->get()->result();

~ Example 1: get the first row with primary key

$data = $this->My_model_name->find('INV-202010-0001');

~ Example 1: get the first row with other column

$data = $this->My_model_name->find(['status => 'active', 'is_stok' => 'Y']);

This method is exactly same as the find() method but if the return value is null then it will appear 404 page

~ Example 1: Insert one row

$this->My_model_name->insert([
  'field_name_1' => 'test1', 
  'field_name_2' => 'Testing1'
]);

~ Example 2: Insert multiple row bulk

$insert = [];
$insert[] = ['field_name_1' => 'test1', 'field_name_2' => 'Testing1'];
$insert[] = ['field_name_1' => 'test2', 'field_name_2' => 'Testing2'];
$this->My_model_name->insert($insert);

$this->My_model_name->update(['my_primary_key' => '1'], ['my_field_name' => 'new value']);

$this->My_model_name->updateIncrement(
	['kode_produk' => 'INV-202004-0001'],
	'jumlah_stok'
);

If the value of field jumlah_stok is 10 then the new value is 11

$this->My_model_name->updateDecrement(
	['kode_produk' => 'INV-202004-0001'],
	'jumlah_stok'
);

If the value of field jumlah_stok is 10 then the new value is 9

~ Example 1: where clause on primary key

$this->My_model_name->delete('INV-202004-0001');

~ Example 2: where custom field clause

$this->My_model_name->delete(['my_primary_key' => 'value']);

If you're using this method. You must define your field primary key on property model

<?php defined('BASEPATH') OR exit('No direct script access allowed');

use Eloquent\Eloquent;

class My_model_name extends Eloquent
{

  public $table = 'my_table_name';
  public $primary_key = 'my_field_name_id';

  public function __construct()
  {
    parent::__construct();
  }

}

Then, you can using this method & get the increment

$increment = $this->My_model_name->primaryKeyInc();

Firstly, The same as the primaryKeyInc() method, you must define your field primary key on property model

~ Example 1: Generate code & reset increment every month

  $pk = $this->My_model_name->primaryKey([
    "format" => "INV", 
    "separator" => "-",
    "digit_inc" => 5
  ]);

  # return value is: INV-202010-00001

~ Example 2: Generate code & non reset increment

  $pk = $this->My_model_name->primaryKey([
    "format" => "KTG", 
    "separator" => "",
    "digit_inc" => 6,
    "reset_monthly" => FALSE
  ]);

  # return value is: KTG000001