AJAX Attribute Manager support

[♥raiwa]

2 hours ago, radhavallabh said:

Hi dear;

Thanx that fixes the arrows  ...... but not the - ( remove) button it still is showing on the top row.  Attaching screenshot dear

in: admin/attributesManager/attributeManager.php

remove line 219:

	</td>

 

[radhavallabh]

1 hour ago, raiwa said:

in: admin/attributesManager/attributeManager.php

remove line 219:

	</td>

 

That fixes this issue dear...  

Thank you!

[radhavallabh]

1 hour ago, raiwa said:

in: admin/attributesManager/attributeManager.php

remove line 219:

	</td>

 

Dear as soon as the applied the change and the remove button fixed .... now the errors have also changed ...

[♥raiwa]

Nothing to do one with another. It's still the same error.

Revise your database. I can't give more support on this , it's your store's database.

[radhavallabh]

2 hours ago, raiwa said:

in: admin/attributesManager/attributeManager.php

remove line 219:

	</td>

 

One more small layout issue dear when we open the attribute the top level row does not match the width of the table. Attaching screenshot

[♥raiwa]

I'm working on an update to bootstrap buttons and icons which will address this as well as other minor issues.

[radhavallabh]

52 minutes ago, raiwa said:

Nothing to do one with another. It's still the same error.

Revise your database. I can't give more support on this , it's your store's database.

Thanx dear your previous advice of scanning database thoroughly .. helped me fixed the error..  

Thank you so much dear!

Very warm Regds./

radhavallabh

[♥raiwa]

Ajax Attribute Manager 3.3.0 beta

AJAX-AttributeManager-V3.3.0._CE_Phoenix_beta.zip

Requires:
OsCommerce Phoenix 1.0.5.9+ (tested with 1.0.7.9)
PHP 7.0 to 7.3

A  lot of changes, so please, give it a try and report back if there appear any issues.

+ removed duplicated language definitions. Thanks to @kgtee
+ fixed unbalanced table columns. Thanks to @radhavallabh
+ added table titles.
+ updated to bootstrap design elements (buttons, tables etc).
+ replaced image icons by fontawesome icons.
+ removed deprecated css
+ removed deprecated image icons
+ replaced jquery with native javascript in admin hooks. Thanks to @PiLLaO
+ removed qtpro support. It's now available in it's own tab on the product edit page.
+ updated sort order support modifications in cm_pi_options_attributes.php

Edited October 18, 2020 by raiwa

[♥raiwa]

Just tested under PHP 7.4 and it seems to work ok.

[♥raiwa]

Uploaded:

Ajax Attribute Manager 3.3.0

Requires:
OsCommerce Phoenix 1.0.5.9+ (tested with 1.0.7.9)
PHP 7.0 to 7.4

+ removed duplicated language definitions. Thanks to @kgtee
+ fixed unbalanced table columns. Thanks to @radhavallabh
+ added table titles.
+ updated to bootstrap design elements (buttons, tables etc).
+ replaced image icons by fontawesome icons.
+ removed deprecated css
+ removed deprecated image icons
+ replaced jquery with native javascript in admin hooks. Thanks to @PiLLaO
+ removed qtpro support. It's now available in it's own tab on the product edit page.
+ updated sort order support modifications in cm_pi_options_attributes.php

 

[radhavallabh]

On 10/24/2020 at 3:45 PM, raiwa said:

Uploaded:

Ajax Attribute Manager 3.3.0

Requires:
OsCommerce Phoenix 1.0.5.9+ (tested with 1.0.7.9)
PHP 7.0 to 7.4

+ removed duplicated language definitions. Thanks to @kgtee
+ fixed unbalanced table columns. Thanks to @radhavallabh
+ added table titles.
+ updated to bootstrap design elements (buttons, tables etc).
+ replaced image icons by fontawesome icons.
+ removed deprecated css
+ removed deprecated image icons
+ replaced jquery with native javascript in admin hooks. Thanks to @PiLLaO
+ removed qtpro support. It's now available in it's own tab on the product edit page.
+ updated sort order support modifications in cm_pi_options_attributes.php

 

Sorry for testing late dear , The new version does not seem to initialize on the product for me.. I have PM you the screenshot of my admin with error console.. Please can you check..

Thank you in advance;

Regds./

radhavallabh

[♥raiwa]

Uploaded:

Ajax Attribute Manager 3.3.1

Requires:
OsCommerce Phoenix 1.0.5.9+ (tested with 1.0.7.9)
PHP 7.0 to 7.4

Changes Version 3.3.1.:

+ fixed notice errors for new product. Thanks to @jonwix for the report
+ removed obsolete script type declarations. Thanks to @radhavallabh for the report and testing
+ removed deprecated sql support.

[♥raiwa]

Update instructions for compatibility with Phoenix 1.0.7.10 options attributes sort order:

In admin/attributeManager/classes/attributesManagerConfig.class.php

change line 69 to:

         $this->add('AM_USE_SORT_ORDER' , true);

change line 74-75 to:

		$this->add('AM_FIELD_OPTION_SORT_ORDER','sort_order'); // Sort column on Products_options table
		$this->add('AM_FIELD_OPTION_VALUE_SORT_ORDER','sort_order'); // Sort column on product_attributes table

 

Edited October 30, 2020 by raiwa

[Omar_one]

 @raiwa   I get this error 
 

1054 - Unknown column 'aa2t.sort_order' in 'order clause'

select * from am_templates at left join am_attributes_to_templates aa2t using(template_id) order by at.template_id, aa2t.sort_order

 

[♥raiwa]

You are on Phoenix 1. 0.7.10?

[Omar_one]

9 minutes ago, raiwa said:

You are on Phoenix 1. 0.7.10?

Yes .. Phoenix 1. 0.7.10

[♥raiwa]

Hi Omar @Omar_one,

Have a look in your database table "am_attributes_to_templates".

If you have already a column called "products_options_sort_order", just change the name to "sort_order".

If you do not have it, run the following script:

ALTER TABLE am_attributes_to_templates ADD(`sort_order` int default 0)

I'll include full support for the core sort order including an update script in the the next update.

[Omar_one]

@raiwa thank you that fixed ,,  
 

5 hours ago, raiwa said:

If you have already a column called "products_options_sort_order", just change the name to "sort_order".

 

[♥raiwa]

@Omar_one and others:

There are some hardcoded instances of "products_options_sort_order" which need to be changed to "sort_order" in:

- admin\attributeManager\classes\attributeManager.class.php
- admin\attributeManager\classes\attributeManagerConfig.class.php

[Omar_one]

22 hours ago, raiwa said:

@Omar_one and others:

There are some hardcoded instances of "products_options_sort_order" which need to be changed to "sort_order" in:

- admin\attributeManager\classes\attributeManager.class.php
- admin\attributeManager\classes\attributeManagerConfig.class.php

and in /includes/modules/content/product_info/cm_pi_options_attributes

[♥raiwa]

3 minutes ago, Omar_one said:

and in /includes/modules/content/product_info/cm_pi_options_attributes

it's supposed to be used the core module which includes this now already

[♥raiwa]

Uploaded:

Ajax Attribute Manager 3.3.2

Requires:
OsCommerce Phoenix 1.0.7.10+ REQUIRED!
PHP 7.0 to 7.4

Changes Version 3.3.2.:

+ added support for Phoenix 1.0.7.10 core sort order
+ removed optional product_options_sort_order support
+ added auto update script for product_options_sort_order to core sort order columns.
+ normalized spacing and indents.
+ updated custom database functions to use core functions.
+ modernized coding to match core standards

*********************************************************************
If you were using attributes/options sort order from previous versions:
    - Make a database backup for security if something gets messed up.
    - On first load of this version, the old sort order entries will be migrated to the new core sort order columns.
    - Check your database for success after you loaded the new attributes manager.

    - Use the product info options/attributes sort order content module included in Phoenix 1.0.7.10
*********************************************************************

 

 

[jonwix]

Thanks for the quick update

[Fredi]

Hello Rainer!

I've been using your wonderful module for many years now, but at OsCommers.
Installed the latest version on my Phoenix test store 1.0.7.10 When I enter it, there is a warning:
Notice: Undefined offset: 222 in /admin/attributeManager/classes/attributeManager.class.php on line 237
Notice: Undefined offset: 229 in /admin/attributeManager/classes/attributeManager.class.php on line 237

In the old store I also use the weight and attribute images add-ons. These 2 additions have not been updated for many years and do not correspond to modern PCP versions. Special issue with "Attribute Image" that requires a big change to the products_attributes.php file
I tried it, but not everything worked out.

File \admin\attributeManager\languages\russian\attributeManager.php
has an unreadable format (encoding does not correspond to UTF-8).
I fixed that, new translation in the attached file. 

Please replace it in your Attribute Manager.

Thank you for your wonderful and easy-to-use addon. I really want it to work correctly in Phoenix.

attributeManager.zip

[Fredi]

Hello dear Rainer.

Please tell me if there is a solution to the question I asked?