public function __toString()
{
/* Construyendo el Query */
$new_array = array();
if (@$this->args->schema == "0k") {
$html = 1;
$table = new fpp_category_Model();
$orm = $table->db2cls();
$orm->limit = null;
$rl1 = $orm->fetch_all(array('cat_id' => 'ASC', 'order_cat' => 'DESC'));
foreach ($rl1 as $row) {
if ($row->cat_id == $this->args->initlevel) {
$new_array[$row->id_category] = $row;
$new_array[$row->id_category]->sub = array();
} else {
$new_array[$row->cat_id]->sub[] = $row;
}
}
foreach ($new_array as $row) {
if (!(@$row->id_category == '')) {
$drop[$row->id_category] = $row->name_category;
foreach ($row->sub as $sub) {
$drop[$sub->id_category] = " " . $sub->name_category;
}
// $html .= "</ul>";
} else {
$row = @$row->sub[0];
$drop[$row->id_category] = $row->name_category;
}
}
} else {
$select[] = $this->args->db_value . ' as value ';
$select[] = $this->args->db_label . ' as label ';
$one_to_one = $this->db->from($this->args->db_table)->select($select)->get();
/* Construyendo el Array del Dropdown */
$drop = array();
foreach ($one_to_one as $row) {
$drop[$row->value] = $row->label;
}
}
$html = $this->AjaxConstruct(form::dropdown($this->field_name, @$drop, $this->field_value));
return $html;
}
function OrderCat($one_to_one, $agroup, $str_json)
{
if (@$this->args->schema == "0k") {
$html = 1;
$table = new fpp_category_Model();
$orm = $table->db2cls();
$orm->limit = null;
$rl1 = $orm->fetch_all(array('cat_id' => 'ASC', 'order_cat' => 'DESC'));
foreach ($rl1 as $row) {
if ($row->cat_id == $this->args->initlevel) {
$new_array[$row->id_category] = $row;
$new_array[$row->id_category]->sub = array();
} else {
$new_array[$row->cat_id]->sub[] = $row;
}
}
foreach ($new_array as $row) {
if (!(@$row->id_category == '')) {
$drop[$row->id_category] = $row->name_category;
foreach ($row->sub as $sub) {
$drop[$sub->id_category] = " " . $sub->name_category;
}
// $html .= "</ul>";
} else {
$row = @$row->sub[0];
$drop[$row->id_category] = $row->name_category;
}
}
} else {
foreach ($one_to_one as $row) {
if ($agroup == TRUE) {
$vl = $row->group;
$vl = $str_json->{$vl};
$drop[$vl][$row->value] = $row->label;
} else {
$drop[$row->value] = $row->label;
}
}
}
return $drop;
}
public static function getUrlById($id)
{
$cache = Cache::instance();
$tprefix = Basic::TransVar('t');
$uid = $tprefix . 'Category__getUrlById__' . $id;
$url = $cache->get($uid);
if (!$url) {
$id = (int) $id;
$orm = new stdClass();
$table = new fpp_category_Model();
$orm = $table->db2cls($id);
$name_category = Basic::TransVar("name_category");
$tr_content_page = Basic::TransVar("content_page");
$name = $orm->{$name_category};
$titleurl = Basic::urlizar($name);
$url = html::anchor("category/items/" . $id . '/' . $titleurl, $name);
// $url = html::anchor(url::base()."category/{$id}/{$titleurl}",(($view_name) ? $title : ""));
$cache->set($uid, $url, array(), 3600);
}
return $url;
}
