Page 78 of 78 FirstFirst ... 2868767778
Results 771 to 776 of 776
  1. #771
    Join Date
    Feb 2009
    Location
    atlanta GA
    Posts
    244
    Plugin Contributions
    0

    Default Re: Super Orders v4.0 Support Thread (for ZC v1.5.x)

    Is it possible to use this plugin to create a order for a customer ? I have one that is older and couldn't figure out how to make an account. So i made one for them and just sent them an invoice for payment from square. However I would like to print them up and packing slip and have a place in the future where they can look up their order information. I have installed the add customer plugin already. Just need none to add orders to those customers.

    zencart 1.5.6c
    php 7.4
    Zencart 1.5.6c PHP 7.2 Order Replacement AC Adapters and Power Cords Online www.missingcord.com

  2. #772
    Join Date
    Sep 2012
    Location
    Upstate South Carolina
    Posts
    95
    Plugin Contributions
    2

    Default Re: Super Orders v4.0 Support Thread (for ZC v1.5.x)

    Yes, you can create an order on behalf of a customer. It includes the Purchase Order payment module. That allows you to bill them after checkout, then collect and apply payment later.

  3. #773
    Join Date
    Nov 2022
    Location
    St-Lambert, Canada
    Posts
    13
    Plugin Contributions
    0

    Default Re: Super Orders v4.0 Support Thread

    Hello, After upgrading from zencart 1.55f + SO 4.09 to zencart 1.57d + SO 5.0. (using PHP 743, MySql 555) I got this error message when I try to excute "Cash report"

    #6 require(D:\xampp734\htdocs\pechesud\bureau\super_report_cash.php) called at [D:\xampp734\htdocs\pechesud\bureau\index.php:11]
    --> PHP Fatal error: 1146:Table 'bdpechesud.zen_so_payment_types_description' doesn't exist :: SELECT ptd.payment_type_full
    FROM zen_so_payment_types pt
    LEFT JOIN zen_so_payment_types_description ptd ON ptd.payment_type_id = pt.payment_type_id
    AND ptd.language_id = 3
    WHERE pt.payment_type_code LIKE ''
    LIMIT 1 ==> (as called by) D:\xampp734\htdocs\pechesud\bureau\includes\functions\extra_functions\super_orde rs_functions.php on line 150 <== in D:\xampp734\htdocs\pechesud\includes\classes\db\mysql\query_factory.php on line 171.


    What I did:
    0-Uninstall SO with a_super_orders_uninstall.sql in my V155f database
    1-I delete all Deprecated files
    2-Upgrade Zencart database with (zc_install)
    3-Copy all new files from 1_Base_Files into the ROOT
    4-Open Zencart in Admin section
    5-SO update passed without error

    But it seems missing on table in my database : so_payment_types_description

    Does someone know how I create recreate this table, I didn't find where this table is create.

    Thanks

  4. #774
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    8,957
    Plugin Contributions
    309

    Default Re: Super Orders v4.0 Support Thread

    I have updated the Github link on this plugin's home page to point to @strelitzia's repo.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  5. #775
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    8,957
    Plugin Contributions
    309

    Default Re: Super Orders v4.0 Support Thread

    > But it seems missing on table in my database : so_payment_types_description
    > Does someone know how I create recreate this table, I didn't find where this table is create.

    You'll need to remove (or change) the prefix per your configuration.

    Code:
    -- phpMyAdmin SQL Dump
    -- version 5.2.0
    -- https://www.phpmyadmin.net/
    --
    -- Host: localhost:8889
    -- Generation Time: Nov 24, 2022 at 06:05 PM
    -- Server version: 5.7.34
    -- PHP Version: 8.1.11
    
    SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
    START TRANSACTION;
    SET time_zone = "+00:00";
    
    
    /*!40101 SET @[email protected]@CHARACTER_SET_CLIENT */;
    /*!40101 SET @[email protected]@CHARACTER_SET_RESULTS */;
    /*!40101 SET @[email protected]@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8mb4 */;
    
    --
    -- Database: `security`
    --
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table `zen_so_payment_types`
    --
    
    CREATE TABLE `zen_so_payment_types` (
      `payment_type_id` int(11) NOT NULL,
      `language_id` int(11) NOT NULL DEFAULT '1',
      `payment_type_code` varchar(4) NOT NULL,
      `payment_type_full` varchar(20) NOT NULL
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    
    --
    -- Dumping data for table `zen_so_payment_types`
    --
    
    INSERT INTO `zen_so_payment_types` (`payment_type_id`, `language_id`, `payment_type_code`, `payment_type_full`) VALUES
    (1, 1, 'CA', 'Cash'),
    (2, 1, 'CK', 'Check'),
    (3, 1, 'MO', 'Money Order'),
    (4, 1, 'WU', 'Western Union'),
    (5, 1, 'ADJ', 'Adjustment'),
    (6, 1, 'REF', 'Refund'),
    (7, 1, 'CC', 'Credit Card'),
    (8, 1, 'MC', 'MasterCard'),
    (9, 1, 'VISA', 'Visa'),
    (10, 1, 'AMEX', 'American Express'),
    (11, 1, 'DISC', 'Discover'),
    (12, 1, 'DINE', 'Diners Club'),
    (13, 1, 'SOLO', 'Solo'),
    (14, 1, 'MAES', 'Maestro'),
    (15, 1, 'JCB', 'JCB');
    
    --
    -- Indexes for dumped tables
    --
    
    --
    -- Indexes for table `zen_so_payment_types`
    --
    ALTER TABLE `zen_so_payment_types`
      ADD PRIMARY KEY (`payment_type_id`),
      ADD UNIQUE KEY `type_code` (`payment_type_code`),
      ADD KEY `type_code_2` (`payment_type_code`);
    
    --
    -- AUTO_INCREMENT for dumped tables
    --
    
    --
    -- AUTO_INCREMENT for table `zen_so_payment_types`
    --
    ALTER TABLE `zen_so_payment_types`
      MODIFY `payment_type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
    COMMIT;
    
    /*!40101 SET [email protected]_CHARACTER_SET_CLIENT */;
    /*!40101 SET [email protected]_CHARACTER_SET_RESULTS */;
    /*!40101 SET [email protected]_COLLATION_CONNECTION */;
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  6. #776
    Join Date
    Nov 2022
    Location
    St-Lambert, Canada
    Posts
    13
    Plugin Contributions
    0

    Default Re: Super Orders v4.0 Support Thread

    I check the source code and I really don't understand why so_payment_types_description table is needed to get the payment type description, the information is already inside SO_PAYMENT_TYPES, so I change this file :

    Edit /admin/includes/functions/extra_functions/super_orders_functions.php

    Find the function below, comment the original SQL query and add the new SQL query, that fixes the "cash report" issue

    function zen_get_payment_type_name($payment_type_code, $language_id = '')
    {
    global $db;

    if (empty($language_id)) {
    $language_id = $_SESSION['languages_id'];
    }
    // $payment_type = $db->Execute("SELECT ptd.payment_type_full
    // FROM " . TABLE_SO_PAYMENT_TYPES . " pt
    // LEFT JOIN " . TABLE_SO_PAYMENT_TYPES_DESCRIPTION . " ptd ON ptd.payment_type_id = pt.payment_type_id
    // AND ptd.language_id = " . (int)$language_id . "
    // WHERE pt.payment_type_code LIKE '" . $payment_type_code . "'
    // LIMIT 1");

    $payment_type = $db->Execute("SELECT payment_type_full
    FROM " . TABLE_SO_PAYMENT_TYPES . " WHERE language_id = " . (int)$language_id . "
    AND payment_type_code LIKE '" . $payment_type_code . "' LIMIT 1");


    return $payment_type->fields['payment_type_full'];
    }

 

 
Page 78 of 78 FirstFirst ... 2868767778

Similar Threads

  1. v150 Edit Orders v4.0 Support Thread
    By DivaVocals in forum Addon Admin Tools
    Replies: 1758
    Last Post: 12 Jan 2023, 02:51 AM
  2. Edit Orders v3.0 for ZC 1.3.9 [Support Thread]
    By DivaVocals in forum All Other Contributions/Addons
    Replies: 656
    Last Post: 18 Apr 2016, 06:28 PM
  3. v139h Super Orders v3.0 Support Thread (for ZC v1.3.9)
    By DivaVocals in forum All Other Contributions/Addons
    Replies: 1018
    Last Post: 28 Apr 2014, 11:38 PM
  4. OLD Super Orders 2.0 (See v3.0 thread instead)
    By BlindSide in forum All Other Contributions/Addons
    Replies: 2019
    Last Post: 17 Jan 2012, 05:43 AM
  5. RE: Super Orders v3.0 Support Thread
    By Johnnyd in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 22 Jun 2011, 09:28 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR