sebekx1 Posted February 1, 2020 Share Posted February 1, 2020 Witam, Jak dodać kolumnę na liście produktów w panelu administarycnym, aby była widoczna cena hurtowa oprócz tego co jest czyli cena podstawowa i cena ostateczna?? Chciałbym aby przy eksporcie do excela produktów miał również cenę zakupu bo nigdzie czegoś takiego nie ma Link to comment Share on other sites More sharing options...
endriu107 Posted February 1, 2020 Share Posted February 1, 2020 Dla wersji 1.6 i 1.7 są różne pliki do edycji. Link to comment Share on other sites More sharing options...
sebekx1 Posted February 1, 2020 Author Share Posted February 1, 2020 1.6 Link to comment Share on other sites More sharing options...
endriu107 Posted February 1, 2020 Share Posted February 1, 2020 Plik do edycji to controllers/admin/AdminProductController.php tam musisz dodać kolumnę gdzieś w okolicy 200 wiersza są definiowane poszczególne pola możesz tam dodać $this->fields_list['wholesale_price'] = array( 'title' => $this->l('Cena zakupu'), 'type' => 'price', 'align' => 'text-left', 'filter_key' => 'a!wholesale_price' ); Być może trzeba będzie jeszcze do zapytania sql dodać obsługę tego pola, nie pamiętam czy jest. Link to comment Share on other sites More sharing options...
sebekx1 Posted February 2, 2020 Author Share Posted February 2, 2020 wstawiełm ten kod ale na stronie nic się nie zmieniło, kolumna nie dodana endriu107 a mógłbyś krok po korku powiedzieć jak do zapytania sql dodać obsługę tego pola?? Link to comment Share on other sites More sharing options...
endriu107 Posted February 2, 2020 Share Posted February 2, 2020 Kolumna mimo wszystko powinna się dodać, jeśli sie nie dodała to zrobiłeś coś źle. Link to comment Share on other sites More sharing options...
sebekx1 Posted February 2, 2020 Author Share Posted February 2, 2020 $id_shop = Shop::isFeatureActive() && Shop::getContext() == Shop::CONTEXT_SHOP? (int)$this->context->shop->id : 'a.id_shop_default'; $this->_join .= ' JOIN `'._DB_PREFIX_.'product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = '.$id_shop.') LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON ('.$alias.'.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = '.$id_shop.') LEFT JOIN `'._DB_PREFIX_.'shop` shop ON (shop.id_shop = '.$id_shop.') LEFT JOIN `'._DB_PREFIX_.'image_shop` image_shop ON (image_shop.`id_product` = a.`id_product` AND image_shop.`cover` = 1 AND image_shop.id_shop = '.$id_shop.') LEFT JOIN `'._DB_PREFIX_.'image` i ON (i.`id_image` = image_shop.`id_image`) LEFT JOIN `'._DB_PREFIX_.'product_download` pd ON (pd.`id_product` = a.`id_product` AND pd.`active` = 1)'; $this->_select .= 'shop.`name` AS `shopname`, a.`id_shop_default`, '; $this->_select .= $alias_image.'.`id_image` AS `id_image`, cl.`name` AS `name_category`, '.$alias.'.`price`, 0 AS `price_final`, a.`is_virtual`, pd.`nb_downloadable`, sav.`quantity` AS `sav_quantity`, '.$alias.'.`active`, IF(sav.`quantity`<=0, 1, 0) AS `badge_danger`'; if ($join_category) { $this->_join .= ' INNER JOIN `'._DB_PREFIX_.'category_product` cp ON (cp.`id_product` = a.`id_product` AND cp.`id_category` = '.(int)$this->_category->id.') '; $this->_select .= ' , cp.`position`, '; } $this->_use_found_rows = false; $this->_group = ''; $this->fields_list = array(); $this->fields_list['id_product'] = array( 'title' => $this->l('ID'), 'align' => 'center', 'class' => 'fixed-width-xs', 'type' => 'int' ); $this->fields_list['image'] = array( 'title' => $this->l('Image'), 'align' => 'center', 'image' => 'p', 'orderby' => false, 'filter' => false, 'search' => false ); $this->fields_list['name'] = array( 'title' => $this->l('Name'), 'filter_key' => 'b!name' ); $this->fields_list['reference'] = array( 'title' => $this->l('Reference'), 'align' => 'left', ); if (Shop::isFeatureActive() && Shop::getContext() != Shop::CONTEXT_SHOP) { $this->fields_list['shopname'] = array( 'title' => $this->l('Default shop'), 'filter_key' => 'shop!name', ); } else { $this->fields_list['name_category'] = array( 'title' => $this->l('Category'), 'filter_key' => 'cl!name', ); } $this->fields_list['wholesale_price'] = array( 'title' => $this->l('Cena zakupu'), 'type' => 'price', 'align' => 'text-left', 'filter_key' => 'a!wholesale_price' ); $this->fields_list['price'] = array( 'title' => $this->l('Base price'), 'type' => 'price', 'align' => 'text-right', 'filter_key' => 'a!price' ); $this->fields_list['price_final'] = array( 'title' => $this->l('Final price'), 'type' => 'price', 'align' => 'text-right', 'havingFilter' => true, 'orderby' => false, 'search' => false ); if (Configuration::get('PS_STOCK_MANAGEMENT')) { $this->fields_list['sav_quantity'] = array( 'title' => $this->l('Quantity'), 'type' => 'int', 'align' => 'text-right', 'filter_key' => 'sav!quantity', 'orderby' => true, 'badge_danger' => true, //'hint' => $this->l('This is the quantity available in the current shop/group.'), ); } $this->fields_list['active'] = array( 'title' => $this->l('Status'), 'active' => 'status', 'filter_key' => $alias.'!active', 'align' => 'text-center', 'type' => 'bool', 'class' => 'fixed-width-sm', 'orderby' => false ); if ($join_category && (int)$this->id_current_category) { $this->fields_list['position'] = array( 'title' => $this->l('Position'), 'filter_key' => 'cp!position', 'align' => 'center', 'position' => 'position' ); } } wstawiłem tak jak powyżej przed, price i price_final Link to comment Share on other sites More sharing options...
endriu107 Posted February 2, 2020 Share Posted February 2, 2020 Czyli powinno działać, jeśli nie jest to sprawa związana z cache przeglądarki to może być tak że jakoś moduł nadpisuje ten plik i zmian należy dokonać w override. Link to comment Share on other sites More sharing options...
sebekx1 Posted February 2, 2020 Author Share Posted February 2, 2020 (edited) cache czyszczone.. nawet jak wyrzuciłem name_category to nie znikło - żadnych zmian pomożesz jak to zrobić? Edited February 2, 2020 by sebekx1 (see edit history) Link to comment Share on other sites More sharing options...
sebekx1 Posted February 2, 2020 Author Share Posted February 2, 2020 ok, działa nie wiem czemu ale przy wrzucaniu pliku na ftp dodawało drugi plik o takiej samej nazwie ale małymi literami usunąłem oba dodałem ponowanie i cyka 😉 dzięki za pomoc Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now