public function __toString()
{
/**
* poa = product options atributes
*/
$update_fields = array();
$db = Database::Instance();
$uri = Uri::Instance();
$string = null;
$tienda_id = (int) $uri->segment("edit");
if (request::method() == 'post' and is_array(@$_POST['igallery_h'])) {
$db->query("DELETE FROM product_images where product_id_product = {$tienda_id}");
$ic = 0;
if (@$_FILES['igallery'] != "") {
$arrf = $this->reArrayFiles($_FILES['igallery']);
}
foreach ($_POST['igallery_h'] as $value) {
// echo Kohana::debug($value);
// echo Kohana::debug($arrf[$ic]);
if (@$arrf[$ic]['name'] != "") {
$value = $this->upimg($arrf[$ic]);
}
// echo Kohana::debug($value);
// echo "INSERT INTO product_images (product_id_product ,pi_image) VALUES ('$tienda_id','$value')";
if ($value != "") {
try {
$db->query("INSERT INTO product_images (product_id_product ,pi_image) VALUES ('{$tienda_id}','{$value}')");
} catch (Exception $e) {
echo Kohana::debug('Error: ' . "\n" . $e->getMessage() . "\n");
}
}
$ic++;
}
}
try {
$r = $db->query("SELECT * FROM product_images WHERE product_id_product = {$tienda_id}");
$string = View::factory("extras/galleryimage")->set("imgs", $r)->render();
} catch (Exception $e) {
echo Kohana::debug('Error: ' . "\n" . $e->getMessage() . "\n");
}
return $string;
}
public static function GalleryImage()
{
$uri = Uri::Instance();
$id = (int) $uri->segment('id');
$db = Database::Instance();
$r = $db->query("SELECT * FROM product_images WHERE product_id_product = {$id}");
$str = null;
$ct = 0;
foreach ($r as $row) {
$str .= '
<a rel="prettyPhoto[grp]" id="imggal_' . $ct . '" href="' . basics::upload() . $row->pi_image . '" class="gallery" >a
</a>';
$ct++;
}
return $str;
}
public static function GetSchemaCategory_SelDisplay()
{
$initlevel = 1;
$html = null;
$new_array = array();
$table = new fpp_category_Model();
$orm = $table->db2cls();
$orm->limit = null;
$checksub = true;
$uri = Uri::Instance();
$itemid = (int) $uri->segment("items");
$rl1 = $orm->fetch_where(array('enable' => '1'), array('cat_id' => 'ASC', 'order_cat' => 'DESC'));
foreach ($rl1 as $row) {
if ($row->cat_id == $initlevel) {
$new_array[$row->id_category] = $row;
$new_array[$row->id_category]->sub = array();
} else {
$nnew_array[$row->id_category] = $row;
$nnew_array2[$row->cat_id][] = $row;
if ($row->cat_id == $itemid) {
$new_array[$itemid]->sub[] = $row;
$checksub = false;
}
}
}
if ($checksub and @$nnew_array[$itemid]->cat_id != "") {
$cidn12 = $nnew_array[$itemid]->cat_id;
$arraycid = $nnew_array2[$cidn12];
$new_array[$cidn12]->sub = $arraycid;
}
foreach ($new_array as $row) {
$name_category = Basic::TransVar("name_category");
$href = html::anchor("category/items/" . @$row->id_category, @$row->{$name_category});
$img = $row->image_category != "" ? html::image(basics::upload() . $row->image_category) : null;
if (!(@$row->id_category == '')) {
$html .= "<li class='supcat'>{$img} {$href}</li>";
foreach ($row->sub as $sub) {
$href = html::anchor("category/items/" . $sub->id_category, $sub->{$name_category});
$html .= "<li class='subcat'>{$href}</li>";
}
// $html .= "</ul>";
}
}
// echo Kohana::debug($new_array);
return $html;
}
