Jump to content

sanl

Members
  • Posts

    83
  • Joined

  • Last visited

1 Follower

Profile Information

  • Location
    Lithuania
  • Activity
    Developer

sanl's Achievements

Newbie

Newbie (1/14)

3

Reputation

  1. I have 5 main categories and about 390 sub + sub sub categories. So If im using horizontal top menu module I see too big menu in my screen. The main problem - spaces between categories and sub-sub categories. Is it possible to hide it? My menu: http://prntscr.com/4gz38m I found that: .sf-menu li li li ul { width: 220px; } Is for my sub - sub categories. But If i write: display: none , i have same results. How to hide sub sub cats and solve problem with empty spaces? To get normal drop down menu..
  2. Same problem, i Have about 20 categories and half of them have sub categories. And this empty space required lot of space. I really dont understand how mega drop down menu works.
  3. Is it possible to hide only sub - sub cats ? Gadgets -> sub1 , sub2 , sub3. In original css file I can see gadgets -> sub1 (sub1-sub , sub1-subcat, sub1-subcat3) , sub2 (sub2-subcat , sub2-subcat) and etc..
  4. So try the first code: You will se reference code which is clickable and if u click that reference code it open order.
  5. Hello, I have 2 customers groups: default and wholesale_group. In wholesale_group I have group discount 30% for all products. And If I would like to do clearance or special product discount I always do discount for only customers (default group). So If retail price <= wholesale group price, wholesale_group clients should see retail price with reduction not with group reduction. I tryed to do it in classess/product.php, but I couldn`t get price with reduction to compare: if dealer { if (retailprice <= wholesale_group_price) { $ price = $price - specific reduction } else { $price = $price - $group-reduction } Should I do it in product.php file or i must do it in product.js file?
  6. <a class="color-myaccount" href="javascript:showOrder(1, {$order.id_order|intval}, '{$link->getPageLink('order-detail', true)|escape:'html':'UTF-8'}');"> {Order::getUniqReferenceOf($order.id_order)} </a> This is code which u should edit. theme/history.tpl file (59 line on ps16). Change to: <a class="color-myaccount" href="javascript:showOrder(1, {$order.id_order|intval}, '{$link->getPageLink('order-detail', true)|escape:'html':'UTF-8'}');"> {l s='-'} </a> I tryed, it works. And if u want to edit selected order just check theme/js/history.js file. As I can see.
  7. Hello, I have product: weights 20 kg. But I have this product 10 qnt - red color and 10 black color. So I made combination: Weight red color - 10 qnt , weight black color - 10 qnt. If I would like to export a bit information about my products how should I do with quantities? Variable: $product[ 'quantity' ] works perfect if product dont have such combinations. But how to get correct quantity? Now I see quantity: 0 to this product, but I have 20 qnt ! I tryed $combinations[ $row[ 'id_product_attribute' ] ][ 'quantity' ] = intval( $row[ 'quantity' ] ); Any could help me? How to check: IF product has combinations { $quantity-combiation } else { $product['quantity'] But I think I need make array of combiations with quantities? Mh..
  8. It works , thank u:) I used sql = " MY QUERY >= ('$VARIABLE') " Also I tryed Tools:getValue $myVar = strval(Tools::getValue('date')); Thank u!
  9. Okey, im trying to get result without form. Im using default mymodule module (prestashop16 for developers how to create module) where I can change MYMODULE_NAME so I have just change this input type: from text to date. I would like to use this input to get date and use this date in my sql query. $sql = 'SELECT cu.firstname , cu.lastname , cu.email FROM ps_customer cu WHERE cu.date_add >= $my_module_name' If i use cu.date_add >= ('2014-07-24') it works. IF i use $my_module_name (as i said I change this variable input to date type so it should be date). I got error: PrestaShopDatabaseException - Unknown column '$my_module_name' in 'where clause'. Full error: http://prntscr.com/4654iq After settings block I include tpl file which table where is my data from DB. Everything works fine, but I can`t figure out how to get input date value and use it in my sql query.
  10. I still got 0 results. In back office page I would like to see list of customers WHERE date_add > $getdate. PHP CODE: $date22= Tools::getValue('getdate'); sql = 'SELECT firstname, lastname FROM ps_customers WHERE date add >= $date22; TPL FILE code: <input id="getdate" type="date" name="getdate">
  11. I have a variable $getdate in my php file. And I have input in TPL file: <input type="date" name="getdate"> Customer can choose a date and how to get this input value from TPL file to my php variable? $getdate variable in php file help me to make a sql request.
  12. May u help me with such thing? I have SQL query for example get customer firstname and lastname who has newsleter and print it in TPL file. $sql = 'SELECT firstname, lastname, id_customer FROM ps_customer WHERE newsletter = "1" '; while($row=mysql_fetch_array($sql)) { $custdata[] = array( "firstname" => $row[0], "lastname" => $row[1], "id_customer" => $row[2] ); } $this->context->smarty->assign("custdata", $custdata); AND this is my TPL FILE: {foreach $custdata as $item} {$item.firstname}:{$item.lastname} {/foreach} Error: ( ! ) Notice: Undefined variable: custdata in C:\wamp\www\b\modules\mymodule\controllers\front\display.php on line 32 ( ! ) Warning: mysql_fetch_array() expects parameter 1 to be resource, string given in C:\wamp\www\b\modules\mymodule\controllers\front\display.php on line 24 If u can give me a clear example which is working with PS16.
  13. Hello, I have a few problems. 1) I have all My data in .xls file, but I cant save it to .CSV cuz I got uknown unicode. How to do? My module not exporting in UTF8, but I noticed that default prestashop export to .CSV in utf8. 2) Other problem.. I got 10 categories in 4 languages. I exported all languages and tryed to import in new shop. Now I have 40 categories. How to do import with all 4 languages?
  14. I migrate my categories DB (ps_Category, ps_Category_group, ps_Category_product, ps_Category_shop) to SQL and import that SQL file to other shop. I can see all categories in BO -> categories but if I would like to add products in BO -> products -> ASSOCATIONS i can see only 1 old category. So where are my new categories? Where is my mistake?
  15. No,im not looking to migrate. I need only to have my customers, products and categories in new 1.6 prestashop clean shop. How to import all categories with sub - categories? And how to import all products? car2cart help me to do this?
×
×
  • Create New...