+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Model-View-Controller (https://forum.codeigniter.com/forumdisplay.php?fid=10)
+--- Thread: Using something like a helper in model (/showthread.php?tid=80381)
Using something like a helper in model - sprhld - 10-26-2021
Hi there!
How to start...
I have three tables with, let's say, "comments", "pages" and "somethingelse". All have a colmn "slug", which is the ID in the URL to access them directly. For all this three tables I have a model and in all three models is the same method "createSlug()" which is doing exactly the same: creating a slug, check it against the database an increment a sufix to the next one or a free one between others.PHP Code:
public function crtSlug(string $name, $test = FALSE)
{
// Slug is made of the name/label
$slug = mb_url_title($name, '-', TRUE);
// check usage
$chk = $this->builder()
->select('slug')
->like('slug', $slug, 'after');
$used = $chk->get()->getResult();
// create an array with all used _n IDs
$usedDB = [];
$i = '0';
foreach ($used AS $str)
{
$sub = explode('_', $str->slug);
if (empty($sub['1']))
array_push($usedDB, '0');
else
array_push($usedDB, $sub['1']);
$i++;
}
// create an array with the content lines
$rowsCnt = range('0', $i+1);
// compare both arrays and save the missing numbers
$next = array_diff($rowsCnt, $usedDB);
// create slug with the first number of a reseted array
// and return it
return mb_url_title($name.'_'.reset($next), '-', TRUE);
}
My first Idea was to create a helper, but as you see, the method uses the model and the helper has no access to the "builder()".
So my question is: how to create global method which are only works local, in the specific model?
Thanks!
RE: Using something like a helper in model - includebeer - 10-26-2021
You can create a base model class that contains crtSlug() and make your three models extend this base class.
RE: Using something like a helper in model - sprhld - 10-26-2021
Oh, that was easy :-) I thought, it would be a problem to use the builder.
For all other noobs like me, here is what I did:
First, I extend the Model:
PHP Code:
<?php
namespace App\Models;
class BaseModel extends Model
{
/**
* Creates a slug from a given name and increase sufix if slug is in use
* @param $name STRING to make a slug from
* @return string
*/
public function crtSlug(string $name)
{
/* Stuff like above */
}
}
PHP Code:
<?php
namespace App\Models;
class PageModel extends BaseModel
{
/* use $this->crtSlug(); in every method here as you want */
}
Thank you!
RE: Using something like a helper in model - includebeer - 10-26-2021
Cool, glad it solved your problem!
RE: Using something like a helper in model - sprhld - 11-01-2021
And I found more ;-)
My method to create a slug is always used on INSERT and UPDATE. In that case, you can make use of events:
https://codeigniter.com/user_guide/models/model.html#model-events
It's on my todo-list for my program...