Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

[delia]

But I figured it out - I uploaded the files again to be sure they were all there but it wasn't until I turned the subtotals back on and I did a new order did it work. So looks like turning off the subtotals screwed things up. Doesn't make any sense to me but it is working again.

[DivaVocals]

But I figured it out - I uploaded the files again to be sure they were all there but it wasn't until I turned the subtotals back on and I did a new order did it work. So looks like turning off the subtotals screwed things up. Doesn't make any sense to me but it is working again.

This is good information to note, and I'll figure out the best way to add it to the readme for the new version..

Out of curiosity, why would your client want to turn off the subtotals??

[delia]

um, because he didn't know any better? They are using the cart in an odd fashion so he turned off a lot of things. Never seen anyone do that before though.

[DivaVocals]

um, because he didn't know any better? They are using the cart in an odd fashion so he turned off a lot of things. Never seen anyone do that before though.

Oh.. Okay.. Got it.. I just wanted to make sure I wasn't missing some special use case I didn't know about.. Sounds like this is not something I even need to document.. unless I was documenting all the things NOT to do..

[delia]

I'm glad I can make someone laugh today! Thanks again, dearie!

[abcisme]

Hi All,

I'm running 1.3.9h no Super Orders or Tracker installed. I'm using Edit Orders v3.0. I have read about what's happening to me in this thread but there is no answer. I just have Spanish Language and English installed, the main language is Spanish, the problem is when Adding a Product, I select Category --- Subcategory and when displaying products they are displayed in mixed language, the first 3 products are displayed in Spanish then the next 5 are in English. What should I modify?

Regards.

I'm having this exact same problem, but with French. When adding a product to an order, some of the products are showing in English and some are in French. My default admin language is English. Is there any way to force Edit Orders to use the English language only?

[abcisme]

I'm having this exact same problem, but with French. When adding a product to an order, some of the products are showing in English and some are in French. My default admin language is English. Is there any way to force Edit Orders to use the English language only?

Here's a screenshot of what I mean:



There doesn't seem to be any rhyme or reason to it.

[Darkwander]

Greetings;

I am getting the following error on top of the page, am i suppose to follow the instructions and delete the file;

Error The auto-loader /home/delights/public_html/store/****/includes/auto_loaders/config.eo.php has not been deleted. For this module to work you must delete this file manually.

[abcisme]

I'm having this exact same problem, but with French. When adding a product to an order, some of the products are showing in English and some are in French. My default admin language is English. Is there any way to force Edit Orders to use the English language only?

Not sure if this is the correct code to modify, but can it be modified to somehow specify to select only products with a specific language_id?

        // ############################################################################
    //   Get List of All Products
    // ############################################################################

    //$result = zen_db_query("SELECT products_name, p.products_id, x.categories_name, ptc.categories_id FROM " . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id=p.products_id LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc ON ptc.products_id=p.products_id LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON cd.categories_id=ptc.categories_id LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " x ON x.categories_id=ptc.categories_id ORDER BY categories_id");
        $result = $db -> Execute("SELECT products_name, p.products_id, categories_name, ptc.categories_id FROM " . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id=p.products_id LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc ON ptc.products_id=p.products_id LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON cd.categories_id=ptc.categories_id ORDER BY categories_name");
        #hile($row = zen_db_fetch_array($result))         {
      while (!$result -> EOF){
            extract($result->fields,EXTR_PREFIX_ALL,"db");
            $ProductList[$db_categories_id][$db_products_id] = $db_products_name;
            $CategoryList[$db_categories_id] = $db_categories_name;
            $LastCategory = $db_categories_name;
         $result -> MoveNext();
        }

        // ksort($ProductList);

        $LastOptionTag = "";
        $ProductSelectOptions = "<option value='0'>Don't Add New Product" . $LastOptionTag . "\n";
        $ProductSelectOptions .= "<option value='0'>&nbsp;" . $LastOptionTag . "\n";
        foreach($ProductList as $Category => $Products)
        {
            $ProductSelectOptions .= "<option value='0'>$Category" . $LastOptionTag . "\n";
            $ProductSelectOptions .= "<option value='0'>---------------------------" . $LastOptionTag . "\n";
            asort($Products);
            foreach($Products as $Product_ID => $Product_Name)
            {
                $ProductSelectOptions .= "<option value='$Product_ID'> &nbsp; $Product_Name" . $LastOptionTag . "\n";
            }

            if($Category != $LastCategory)
            {
                $ProductSelectOptions .= "<option value='0'>&nbsp;" . $LastOptionTag . "\n";
                $ProductSelectOptions .= "<option value='0'>&nbsp;" . $LastOptionTag . "\n";
            }
        }
    // ############################################################################
    //   Add Products Steps
    // ############################################################################ 

[DivaVocals]

Wish I could help, but the answer is a LOT over my head.. Hopefully someone else in the community knows the answer and will share..

Not sure if this is the correct code to modify, but can it be modified to somehow specify to select only products with a specific language_id?

        // ############################################################################
    //   Get List of All Products
    // ############################################################################

    //$result = zen_db_query("SELECT products_name, p.products_id, x.categories_name, ptc.categories_id FROM " . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id=p.products_id LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc ON ptc.products_id=p.products_id LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON cd.categories_id=ptc.categories_id LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " x ON x.categories_id=ptc.categories_id ORDER BY categories_id");
        $result = $db -> Execute("SELECT products_name, p.products_id, categories_name, ptc.categories_id FROM " . TABLE_PRODUCTS . " p LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id=p.products_id LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc ON ptc.products_id=p.products_id LEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON cd.categories_id=ptc.categories_id ORDER BY categories_name");
        #hile($row = zen_db_fetch_array($result))         {
      while (!$result -> EOF){
            extract($result->fields,EXTR_PREFIX_ALL,"db");
            $ProductList[$db_categories_id][$db_products_id] = $db_products_name;
            $CategoryList[$db_categories_id] = $db_categories_name;
            $LastCategory = $db_categories_name;
         $result -> MoveNext();
        }

        // ksort($ProductList);

        $LastOptionTag = "";
        $ProductSelectOptions = "<option value='0'>Don't Add New Product" . $LastOptionTag . "\n";
        $ProductSelectOptions .= "<option value='0'>&nbsp;" . $LastOptionTag . "\n";
        foreach($ProductList as $Category => $Products)
        {
            $ProductSelectOptions .= "<option value='0'>$Category" . $LastOptionTag . "\n";
            $ProductSelectOptions .= "<option value='0'>---------------------------" . $LastOptionTag . "\n";
            asort($Products);
            foreach($Products as $Product_ID => $Product_Name)
            {
                $ProductSelectOptions .= "<option value='$Product_ID'> &nbsp; $Product_Name" . $LastOptionTag . "\n";
            }

            if($Category != $LastCategory)
            {
                $ProductSelectOptions .= "<option value='0'>&nbsp;" . $LastOptionTag . "\n";
                $ProductSelectOptions .= "<option value='0'>&nbsp;" . $LastOptionTag . "\n";
            }
        }
    // ############################################################################
    //   Add Products Steps
    // ############################################################################