Personalize-Ribbons Logo.

Need Help?
1-800-272-5729

Need Help?
1-800-272-5729

Shopping Cart

You have not put any items in your shopping cart.

$shoppingCart Cart\Classes\ShoppingCart (18)
  • Properties (18)
  • Available methods (22)
  • Static class properties
  • public CartHasDuplicatePrimaries -> boolean false
    $shoppingCart->CartHasDuplicatePrimaries
    public CartHasErrors -> boolean false
    $shoppingCart->CartHasErrors
    public CartMaster -> Cart\Classes\CartMasterRecord (10)
    $shoppingCart->CartMaster
    • Properties (10)
    • Available methods (9)
    • public BillingCustomerNumber -> null
      $shoppingCart->CartMaster->BillingCustomerNumber
      public CreditLimit -> null
      $shoppingCart->CartMaster->CreditLimit
      public OrderNumber -> string (15) "964821579414971"
      $shoppingCart->CartMaster->OrderNumber
      public PreferredPayment -> null
      $shoppingCart->CartMaster->PreferredPayment
      public PurchaseOrderRequired -> boolean false
      $shoppingCart->CartMaster->PurchaseOrderRequired
      public XML -> array (1)
      $shoppingCart->CartMaster->XML
      VFPData => array (5)
      $shoppingCart->CartMaster->XML['VFPData']
      partno => array (0)
      $shoppingCart->CartMaster->XML['VFPData']['partno']
      tagordergroup => array (0)
      $shoppingCart->CartMaster->XML['VFPData']['tagordergroup']
      tagorderxml => array (0)
      $shoppingCart->CartMaster->XML['VFPData']['tagorderxml']
      predefined => array (0)
      $shoppingCart->CartMaster->XML['VFPData']['predefined']
      import_meta => array (3)
      $shoppingCart->CartMaster->XML['VFPData']['import_meta']
      attempts_count => string (0) ""
      $shoppingCart->CartMaster->XML['VFPData']['import_meta']['attempts_count']
      last_attempt => string (0) ""
      $shoppingCart->CartMaster->XML['VFPData']['import_meta']['last_attempt']
      error => array (1)
      $shoppingCart->CartMaster->XML['VFPData']['import_meta']['error']
      @cdata => string (0) ""
      $shoppingCart->CartMaster->XML['VFPData']['import_meta']['error']['@cdata']
      public customerData -> array (60)
      $shoppingCart->CartMaster->customerData
      OrderNumber => string (15) "964821579414971"
      $shoppingCart->CartMaster->customerData['OrderNumber']
      OrderID => null
      $shoppingCart->CartMaster->customerData['OrderID']
      OrderStatus => string (13) "Not-Submitted"
      $shoppingCart->CartMaster->customerData['OrderStatus']
      cInfoCustNum => null
      $shoppingCart->CartMaster->customerData['cInfoCustNum']
      cInfoPrefix => null
      $shoppingCart->CartMaster->customerData['cInfoPrefix']
      cInfoFName => null
      $shoppingCart->CartMaster->customerData['cInfoFName']
      cInfoMName => null
      $shoppingCart->CartMaster->customerData['cInfoMName']
      cInfoLName => null
      $shoppingCart->CartMaster->customerData['cInfoLName']
      cInfoCompany => null
      $shoppingCart->CartMaster->customerData['cInfoCompany']
      cInfoAddressLine1 => null
      $shoppingCart->CartMaster->customerData['cInfoAddressLine1']
      cInfoAddressLine2 => null
      $shoppingCart->CartMaster->customerData['cInfoAddressLine2']
      cInfoCity => null
      $shoppingCart->CartMaster->customerData['cInfoCity']
      cInfoState => null
      $shoppingCart->CartMaster->customerData['cInfoState']
      cInfoPostalCode => null
      $shoppingCart->CartMaster->customerData['cInfoPostalCode']
      cInfoCountry => null
      $shoppingCart->CartMaster->customerData['cInfoCountry']
      cInfoPhone => null
      $shoppingCart->CartMaster->customerData['cInfoPhone']
      cInfoExt => null
      $shoppingCart->CartMaster->customerData['cInfoExt']
      cInfoEMail => null
      $shoppingCart->CartMaster->customerData['cInfoEMail']
      cInfoIsAddressResidential => null
      $shoppingCart->CartMaster->customerData['cInfoIsAddressResidential']
      TimeStamp => string (19) "2020-01-19 01:22:51"
      $shoppingCart->CartMaster->customerData['TimeStamp']
      cBillingCustNum => string (0) ""
      $shoppingCart->CartMaster->customerData['cBillingCustNum']
      cBillingSame => null
      $shoppingCart->CartMaster->customerData['cBillingSame']
      cBillingPrefix => null
      $shoppingCart->CartMaster->customerData['cBillingPrefix']
      cBillingFName => null
      $shoppingCart->CartMaster->customerData['cBillingFName']
      cBillingMName => null
      $shoppingCart->CartMaster->customerData['cBillingMName']
      cBillingLName => null
      $shoppingCart->CartMaster->customerData['cBillingLName']
      cBillingCompany => null
      $shoppingCart->CartMaster->customerData['cBillingCompany']
      cBillingAddressLine1 => null
      $shoppingCart->CartMaster->customerData['cBillingAddressLine1']
      cBillingAddressLine2 => null
      $shoppingCart->CartMaster->customerData['cBillingAddressLine2']
      cBillingCity => null
      $shoppingCart->CartMaster->customerData['cBillingCity']
      cBillingState => null
      $shoppingCart->CartMaster->customerData['cBillingState']
      cBillingPostal => null
      $shoppingCart->CartMaster->customerData['cBillingPostal']
      cBillingPhone => null
      $shoppingCart->CartMaster->customerData['cBillingPhone']
      cContactPhone => null
      $shoppingCart->CartMaster->customerData['cContactPhone']
      cBillingCountry => null
      $shoppingCart->CartMaster->customerData['cBillingCountry']
      cBillingExt => null
      $shoppingCart->CartMaster->customerData['cBillingExt']
      cBillingEmail => null
      $shoppingCart->CartMaster->customerData['cBillingEmail']
      cBillingSpecialInstructions => null
      $shoppingCart->CartMaster->customerData['cBillingSpecialInstructions']
      cContactCustNum => null
      $shoppingCart->CartMaster->customerData['cContactCustNum']
      cContactFName => null
      $shoppingCart->CartMaster->customerData['cContactFName']
      cContactLName => null
      $shoppingCart->CartMaster->customerData['cContactLName']
      cContactEmail => null
      $shoppingCart->CartMaster->customerData['cContactEmail']
      cContactExt => null
      $shoppingCart->CartMaster->customerData['cContactExt']
      AuthNumber => null
      $shoppingCart->CartMaster->customerData['AuthNumber']
      OrderCartCost => null
      $shoppingCart->CartMaster->customerData['OrderCartCost']
      OrderCartTax => null
      $shoppingCart->CartMaster->customerData['OrderCartTax']
      OrderShippingCost => null
      $shoppingCart->CartMaster->customerData['OrderShippingCost']
      OrderCartHandling => null
      $shoppingCart->CartMaster->customerData['OrderCartHandling']
      OrderFinalCost => null
      $shoppingCart->CartMaster->customerData['OrderFinalCost']
      OrderShippingCode => null
      $shoppingCart->CartMaster->customerData['OrderShippingCode']
      customerPaymentProfileId => null
      $shoppingCart->CartMaster->customerData['customerPaymentProfileId']
      customerProfileId => null
      $shoppingCart->CartMaster->customerData['customerProfileId']
      customerShippingAddressId => null
      $shoppingCart->CartMaster->customerData['customerShippingAddressId']
      AuthAmount => null
      $shoppingCart->CartMaster->customerData['AuthAmount']
      UserAgent => string (40) "CCBot/2.0 (https://commoncrawl.org/faq/)"
      $shoppingCart->CartMaster->customerData['UserAgent']
      ResponseDump => null
      $shoppingCart->CartMaster->customerData['ResponseDump']
      needByDate => null
      $shoppingCart->CartMaster->customerData['needByDate']
      expedite => null
      $shoppingCart->CartMaster->customerData['expedite']
      OrderLog => null
      $shoppingCart->CartMaster->customerData['OrderLog']
      BillingCustomer => array (2)
      $shoppingCart->CartMaster->customerData['BillingCustomer']
      PREF_PAY => null
      $shoppingCart->CartMaster->customerData['BillingCustomer']['PREF_PAY']
      CREDIT_LIM => null
      $shoppingCart->CartMaster->customerData['BillingCustomer']['CREDIT_LIM']
      private ColumnNames -> array (0)
      private DataBase -> string (17) "nametag_cart_test"
      private MySQL -> Common\Classes\MySQLi (7)
      • Properties (7)
      • Available methods (6)
      • private DataBase -> string (7) "ci_apps"
        private MyConnectionID -> mysqli (19)
        • Properties (19)
        • Available methods (43)
        • public affected_rows -> null
          public client_info -> null
          public client_version -> null
          public connect_errno -> null
          public connect_error -> null
          public errno -> null
          public error -> null
          public error_list -> null
          public field_count -> null
          public host_info -> null
          public info -> null
          public insert_id -> null
          public protocol_version -> null
          public server_info -> null
          public server_version -> null
          public sqlstate -> null
          public stat -> null
          public thread_id -> null
          public warning_count -> null
        • public autocommit($mode)
          public savepoint($name)
          public real_connect($host, $user, $password, $database, $port, $socket, $flags)
          public real_escape_string($string_to_escape)
          public reap_async_query()
          public escape_string($string_to_escape)
          public real_query($query)
          public release_savepoint($name)
          public rollback($flags, $name)
          public select_db($database)
          public prepare($query)
          public set_charset($charset)
          public set_opt($option, $value)
          public ssl_set($key, $cert, $certificate_authority, $certificate_authority_path, $cipher)
          public stat()
          public stmt_init()
          public store_result($flags)
          public thread_safe()
          public use_result()
          public query($query, $resultmode)
          public ping()
          public begin_transaction($flags, $name)
          public get_client_info()
          public change_user($user, $password, $database)
          public character_set_name()
          public close()
          public commit($flags, $name)
          public connect($host, $user, $password, $database, $port, $socket)
          public dump_debug_info()
          public debug($debug_options)
          public get_charset()
          public get_connection_stats()
          public get_server_info()
          public get_warnings()
          public init()
          public kill($connection_id)
          public multi_query($query)
          public __construct($host, $user, $password, $database, $port, $socket)
          public more_results()
          public next_result()
          public options($option, $value)
          public refresh($options)
          public static poll(array &$read, array &$write, array &$error, $sec, $usec)
          \mysqli::poll(array &$read, array &$write, array &$error, $sec, $usec)
        private MyNum -> integer 0
        private MyResultID -> mysqli_result (5)
        • Properties (5)
        • Available methods (14)
        • public current_field -> null
          public field_count -> null
          public lengths -> null
          public num_rows -> null
          public type -> null
        • public __construct()
          public close()
          public free()
          public data_seek($offset)
          public fetch_field()
          public fetch_fields()
          public fetch_field_direct($field_nr)
          public fetch_all($result_type)
          public fetch_array($result_type)
          public fetch_assoc()
          public fetch_object($class_name, array $params)
          public fetch_row()
          public field_seek($field_nr)
          public free_result()
        private PWD -> string (9) "540pp1NG!"
        private Server -> string (9) "127.0.0.1"
        private UID -> string (4) "cart"
      • public __construct($DataBase, $Server, $User, $Pass) A MySQL wrapper to provide connectivity.
        /**
        * A MySQL wrapper to provide connectivity.
        *
        * @category MySQL Database Connectivity
        * @author   J. B. Saige <jbspublic@gmail.com>
        * @version  2.15
        *
        * @param string $DataBase [optional] The name of the database.
        * @param string $Server   [optional] The name of the server.
        * @param string $User     [optional] The username.
        * @param string $Pass     [optional] The password.
        *
        * @throws \Exception
        */
        
        Defined in .../Common/Classes/MySQLi.php:52
        public __invoke($Query): string The resource ID of the Query Alias of runQuery.
        /**
        * Alias of runQuery.
        *
        * @param string $Query A query to pass to MySQL
        * @return string The resource ID of the Query
        * @throws \Exception
        */
        
        Defined in .../Common/Classes/MySQLi.php:72
        public runQuery($Query): string The resource ID of the Query This will run the query in the database.
        /**
        * This will run the query in the database.
        *
        * @param string $Query A query to pass to MySQL
        * @return string The resource ID of the Query
        * @throws \Exception
        */
        
        Defined in .../Common/Classes/MySQLi.php:84
        public numberOfResults(): array The next row from the database. This will get the number of results of the query, if there was any.
        /**
        * This will get the number of results of the query, if there was any.
        *
        * @return array The next row from the database.
        * @throws \Exception
        */
        
        Defined in .../Common/Classes/MySQLi.php:100
        public getRow(): array The next row from the database. This will get the results of the query, if there was any.
        /**
        * This will get the results of the query, if there was any.
        *
        * @return array The next row from the database.
        * @throws \Exception
        */
        
        Defined in .../Common/Classes/MySQLi.php:116
        public insertID(): int The ID number of the last INSERT statement. This will get the insert ID of the query.
        /**
        * This will get the insert ID of the query.
        *
        * @return int The ID number of the last INSERT statement.
        * @throws \Exception
        */
        
        Defined in .../Common/Classes/MySQLi.php:132
    • public __construct($UID, Common\Classes\MySQLi $MySQL, $Database) Contains and manipulates the data in nametag_cart.order_master.
      new \Cart\Classes\CartMasterRecord($UID, Common\Classes\MySQLi $MySQL, $Database)
      /**
      * Contains and manipulates the data in nametag_cart.order_master.
      *
      * @author Joshua B Saige <joshua@nametag.com>
      *
      * @param int    $UID   The User ID of the Cart
      * @param MySQLi $MySQL MySQL Connector
      * @param string $Database
      *
      * @throws \Exception
      */
      
      Defined in .../Cart/Classes/CartMasterRecord.php:55
      public setDatabase($Database)
      $shoppingCart->CartMaster->setDatabase($Database)
      /**
      * @param string $Database
      *
      * @throws \Exception
      */
      
      Defined in .../Cart/Classes/CartMasterRecord.php:100
      public loadCustomerByNumber($UniqueID)
      $shoppingCart->CartMaster->loadCustomerByNumber($UniqueID)
      /**
      * @param int $UniqueID Unique ID
      */
      
      Defined in .../Cart/Classes/CartMasterRecord.php:109
      public loadCustomer()
      $shoppingCart->CartMaster->loadCustomer()
      Defined in .../Cart/Classes/CartMasterRecord.php:115
      public updateCustomer()
      $shoppingCart->CartMaster->updateCustomer()
      Defined in .../Cart/Classes/CartMasterRecord.php:190
      public findUser($userNumber)
      $shoppingCart->CartMaster->findUser($userNumber)
      Defined in .../Cart/Classes/CartMasterRecord.php:275
      public findPasswordReset($uid)
      $shoppingCart->CartMaster->findPasswordReset($uid)
      Defined in .../Cart/Classes/CartMasterRecord.php:282
      private formatPhoneNumber()
      Defined in .../Cart/Classes/CartMasterRecord.php:231
      private getColumnNames(): array
      /**
      * @return array
      * @throws \Exception
      */
      
      Defined in .../Cart/Classes/CartMasterRecord.php:260
    public ItemBaseCosts -> integer 0
    $shoppingCart->ItemBaseCosts
    public ItemSetUpCost -> integer 0
    $shoppingCart->ItemSetUpCost
    public ItemTotalCost -> integer 0
    $shoppingCart->ItemTotalCost
    public ItemTotalWeight -> double 0
    $shoppingCart->ItemTotalWeight
    public Items -> array (0)
    $shoppingCart->Items
    public NumberOfItems -> integer 0
    $shoppingCart->NumberOfItems
    public OrderNumber -> string (15) "964821579414971"
    $shoppingCart->OrderNumber
    public OverrideQuantitiesByLine -> array (0)
    $shoppingCart->OverrideQuantitiesByLine
    public QuantityRules -> array (0)
    $shoppingCart->QuantityRules
    public ResponseDumpDecode -> null
    $shoppingCart->ResponseDumpDecode
    public XMLHelper -> null
    $shoppingCart->XMLHelper
    protected MyFile -> string (60) "/usr/home/nametag/ci-apps-test/Cart/Classes/ShoppingCart.php"
    • File (51.27KB)
    • -rwxr-xr-x 1002 1002 51.27KB Nov 29 2019 /usr/home/nametag/ci-apps-test/Cart/Classes/ShoppingCart.php
      
    private DataBase -> string (17) "nametag_cart_test"
    private Miner -> Common\Classes\Miner (19)
    • Properties (19)
    • Available methods (110)
    • Static class properties (26)
    • toString
    • private PdoConnection -> null
      private autoQuote -> boolean true
      private delete -> array (0)
      private from -> array (0)
      private groupBy -> array (0)
      private having -> array (0)
      private havingPlaceholderValues -> array (0)
      private insert -> string (0) ""
      private join -> array (0)
      private limit -> array (0)
      private option -> array (0)
      private orderBy -> array (0)
      private replace -> string (0) ""
      private select -> array (0)
      private set -> array (0)
      private setPlaceholderValues -> array (0)
      private update -> string (0) ""
      private where -> array (0)
      private wherePlaceholderValues -> array (0)
    • public __construct(PDO $PdoConnection, $autoQuote): Miner Constructor.
      /**
      * Constructor.
      *
      * @param  \PDO|null $PdoConnection optional PDO database connection
      * @param  bool $autoQuote optional auto-escape values, default true
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:293
      public mergeWhereInto(Common\Classes\Miner $Miner): Miner Merge this Miner's WHERE into the given Miner.
      /**
      * Merge this Miner's WHERE into the given Miner.
      *
      * @param  Miner $Miner to merge into
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1620
      public andHaving($column, $value, $operator, $quote): Miner Add an AND HAVING condition.
      /**
      * Add an AND HAVING condition.
      *
      * @param  string $column colum name
      * @param  mixed $value value
      * @param  string $operator optional comparison operator, default =
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1773
      public having($column, $value, $operator, $connector, $quote): Miner Add a HAVING condition.
      /**
      * Add a HAVING condition.
      *
      * @param  string $column colum name
      * @param  mixed $value value
      * @param  string $operator optional comparison operator, default =
      * @param  string $connector optional logical connector, default AND
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1758
      public closeHaving(): Miner Add a closing bracket for nesting HAVING conditions.
      /**
      * Add a closing bracket for nesting HAVING conditions.
      *
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1743
      public openHaving($connector): Miner Add an open bracket for nesting HAVING conditions.
      /**
      * Add an open bracket for nesting HAVING conditions.
      *
      * @param  string $connector optional logical connector, default AND
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1733
      public getGroupByString($includeText): string GROUP BY portion of the statement Get the GROUP BY portion of the statement as a string.
      /**
      * Get the GROUP BY portion of the statement as a string.
      *
      * @param  bool $includeText optional include 'GROUP BY' text, default true
      * @return string GROUP BY portion of the statement
      */
      
      Defined in .../Common/Classes/Miner.php:1704
      public mergeGroupByInto(Common\Classes\Miner $Miner): Miner Merge this Miner's GROUP BY into the given Miner.
      /**
      * Merge this Miner's GROUP BY into the given Miner.
      *
      * @param  Miner $Miner to merge into
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1689
      public groupBy($column, $order): Miner Add a GROUP BY column.
      /**
      * Add a GROUP BY column.
      *
      * @param  string $column column name
      * @param  string|null $order optional order direction, default none
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1675
      public getWherePlaceholderValues(): array WHERE placeholder values Get the WHERE placeholder values.
      /**
      * Get the WHERE placeholder values.
      *
      * @return array WHERE placeholder values
      */
      
      Defined in .../Common/Classes/Miner.php:1663
      public getWhereString($usePlaceholders, $includeText): string WHERE portion of the statement Get the WHERE portion of the statement as a string.
      /**
      * Get the WHERE portion of the statement as a string.
      *
      * @param  bool $usePlaceholders optional use ? placeholders, default true
      * @param  bool $includeText optional include 'WHERE' text, default true
      * @return string WHERE portion of the statement
      */
      
      Defined in .../Common/Classes/Miner.php:1646
      public whereNotBetween($column, $min, $max, $connector, $quote): Miner Add a NOT BETWEEN WHERE condition.
      /**
      * Add a NOT BETWEEN WHERE condition.
      *
      * @param  string $column column name
      * @param  mixed $min minimum value
      * @param  mixed $max maximum value
      * @param  string $connector optional logical connector, default AND
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1608
      public havingIn($column, array $values, $connector, $quote): Miner Add an IN WHERE condition.
      /**
      * Add an IN WHERE condition.
      *
      * @param  string $column column name
      * @param  array $values values
      * @param  string $connector optional logical connector, default AND
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1801
      public whereBetween($column, $min, $max, $connector, $quote): Miner Add a BETWEEN WHERE condition.
      /**
      * Add a BETWEEN WHERE condition.
      *
      * @param  string $column column name
      * @param  mixed $min minimum value
      * @param  mixed $max maximum value
      * @param  string $connector optional logical connector, default AND
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1593
      public whereNotIn($column, array $values, $connector, $quote): Miner Add a NOT IN WHERE condition.
      /**
      * Add a NOT IN WHERE condition.
      *
      * @param  string $column column name
      * @param  array $values values
      * @param  string $connector optional logical connector, default AND
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1578
      public whereIn($column, array $values, $connector, $quote): Miner Add an IN WHERE condition.
      /**
      * Add an IN WHERE condition.
      *
      * @param  string $column column name
      * @param  array $values values
      * @param  string $connector optional logical connector, default AND
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1564
      public orWhere($column, $value, $operator, $quote): Miner Add an OR WHERE condition.
      /**
      * Add an OR WHERE condition.
      *
      * @param  string $column colum name
      * @param  mixed $value value
      * @param  string $operator optional comparison operator, default =
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1550
      public andWhere($column, $value, $operator, $quote): Miner Add an AND WHERE condition.
      /**
      * Add an AND WHERE condition.
      *
      * @param  string $column colum name
      * @param  mixed $value value
      * @param  string $operator optional comparison operator, default =
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1536
      public where($column, $value, $operator, $connector, $quote): Miner Add a WHERE condition.
      /**
      * Add a WHERE condition.
      *
      * @param  string $column column name
      * @param  mixed $value value
      * @param  string $operator optional comparison operator, default =
      * @param  string $connector optional logical connector, default AND
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1521
      public closeWhere(): Miner Add a closing bracket for nesting WHERE conditions.
      /**
      * Add a closing bracket for nesting WHERE conditions.
      *
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1506
      public openWhere($connector): Miner Add an open bracket for nesting WHERE conditions.
      /**
      * Add an open bracket for nesting WHERE conditions.
      *
      * @param  string $connector optional logical connector, default AND
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1496
      public reset(PDO $PdoConnection, $autoQuote)
      Defined in .../Common/Classes/Miner.php:298
      public orHaving($column, $value, $operator, $quote): Miner Add an OR HAVING condition.
      /**
      * Add an OR HAVING condition.
      *
      * @param  string $column colum name
      * @param  mixed $value value
      * @param  string $operator optional comparison operator, default =
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1787
      public havingNotIn($column, array $values, $connector, $quote): Miner Add a NOT IN HAVING condition.
      /**
      * Add a NOT IN HAVING condition.
      *
      * @param  string $column column name
      * @param  array $values values
      * @param  string $connector optional logical connector, default AND
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1815
      public getJoinString(): string JOIN portion of the statement Get the JOIN portion of the statement as a string.
      /**
      * Get the JOIN portion of the statement as a string.
      *
      * @return string JOIN portion of the statement
      */
      
      Defined in .../Common/Classes/Miner.php:1181
      public getLimitString($includeText): string LIMIT portion of the statement Get the LIMIT portion of the statement as a string.
      /**
      * Get the LIMIT portion of the statement as a string.
      *
      * @param  bool $includeText optional include 'LIMIT' text, default true
      * @return string LIMIT portion of the statement
      */
      
      Defined in .../Common/Classes/Miner.php:2015
      public execute(): PDOStatement|false executed statement or false if failed Execute the statement using the PDO database connection.
      /**
      * Execute the statement using the PDO database connection.
      *
      * @return PDOStatement|false executed statement or false if failed
      */
      
      Defined in .../Common/Classes/Miner.php:2354
      public getPlaceholderValues(): array all placeholder values Get all placeholder values (SET, WHERE, and HAVING).
      /**
      * Get all placeholder values (SET, WHERE, and HAVING).
      *
      * @return array all placeholder values
      */
      
      Defined in .../Common/Classes/Miner.php:2343
      public getStatement($usePlaceholders): string full SQL statement Get the full SQL statement.
      /**
      * Get the full SQL statement.
      *
      * @param  bool $usePlaceholders optional use ? placeholders, default true
      * @return string full SQL statement
      */
      
      Defined in .../Common/Classes/Miner.php:2319
      public mergeInto(Common\Classes\Miner $Miner, $overrideLimit): Miner Merge this Miner into the given Miner.
      /**
      * Merge this Miner into the given Miner.
      *
      * @param  Miner $Miner to merge into
      * @param  bool $overrideLimit optional override limit, default true
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:2093
      public isDelete(): bool whether this is a DELETE statement Whether this is a DELETE statement.
      /**
      * Whether this is a DELETE statement.
      *
      * @return bool whether this is a DELETE statement
      */
      
      Defined in .../Common/Classes/Miner.php:2081
      public isUpdate(): bool whether this is an UPDATE statement Whether this is an UPDATE statement.
      /**
      * Whether this is an UPDATE statement.
      *
      * @return bool whether this is an UPDATE statement
      */
      
      Defined in .../Common/Classes/Miner.php:2071
      public isReplace(): bool whether this is a REPLACE statement Whether this is a REPLACE statement.
      /**
      * Whether this is a REPLACE statement.
      *
      * @return bool whether this is a REPLACE statement
      */
      
      Defined in .../Common/Classes/Miner.php:2061
      public isInsert(): bool whether this is an INSERT statement Whether this is an INSERT statement.
      /**
      * Whether this is an INSERT statement.
      *
      * @return bool whether this is an INSERT statement
      */
      
      Defined in .../Common/Classes/Miner.php:2051
      public isSelect(): bool whether this is a SELECT statement Whether this is a SELECT statement.
      /**
      * Whether this is a SELECT statement.
      *
      * @return bool whether this is a SELECT statement
      */
      
      Defined in .../Common/Classes/Miner.php:2041
      public getLimitOffset(): int|string LIMIT row number to start at Get the LIMIT row number to start at.
      /**
      * Get the LIMIT row number to start at.
      *
      * @return int|string LIMIT row number to start at
      */
      
      Defined in .../Common/Classes/Miner.php:2004
      public havingBetween($column, $min, $max, $connector, $quote): Miner Add a BETWEEN HAVING condition.
      /**
      * Add a BETWEEN HAVING condition.
      *
      * @param  string $column column name
      * @param  mixed $min minimum value
      * @param  mixed $max maximum value
      * @param  string $connector optional logical connector, default AND
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1831
      public getLimit(): int|string LIMIT on number of rows to return Get the LIMIT on number of rows to return.
      /**
      * Get the LIMIT on number of rows to return.
      *
      * @return int|string LIMIT on number of rows to return
      */
      
      Defined in .../Common/Classes/Miner.php:1994
      public mergeLimitInto(Common\Classes\Miner $Miner): Miner Merge this Miner's LIMIT into the given Miner.
      /**
      * Merge this Miner's LIMIT into the given Miner.
      *
      * @param  Miner $Miner to merge into
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1980
      public limit($limit, $offset): Miner Set the LIMIT on number of rows to return with optional offset.
      /**
      * Set the LIMIT on number of rows to return with optional offset.
      *
      * @param  int|string $limit number of rows to return
      * @param  int|string $offset optional row number to start at, default 0
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1966
      public getOrderByString($includeText): string ORDER BY portion of the statement Get the ORDER BY portion of the statement as a string.
      /**
      * Get the ORDER BY portion of the statement as a string.
      *
      * @param  bool $includeText optional include 'ORDER BY' text, default true
      * @return string ORDER BY portion of the statement
      */
      
      Defined in .../Common/Classes/Miner.php:1942
      public mergeOrderByInto(Common\Classes\Miner $Miner): Miner Merge this Miner's ORDER BY into the given Miner.
      /**
      * Merge this Miner's ORDER BY into the given Miner.
      *
      * @param  Miner $Miner to merge into
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1927
      public orderBy($column, $order): Miner Add a column to ORDER BY.
      /**
      * Add a column to ORDER BY.
      *
      * @param  string $column column name
      * @param  string $order optional order direction, default ASC
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1913
      public getHavingPlaceholderValues(): array HAVING placeholder values Get the HAVING placeholder values.
      /**
      * Get the HAVING placeholder values.
      *
      * @return array HAVING placeholder values
      */
      
      Defined in .../Common/Classes/Miner.php:1901
      public getHavingString($usePlaceholders, $includeText): string HAVING portion of the statement Get the HAVING portion of the statement as a string.
      /**
      * Get the HAVING portion of the statement as a string.
      *
      * @param  bool $usePlaceholders optional use ? placeholders, default true
      * @param  bool $includeText optional include 'HAVING' text, default true
      * @return string HAVING portion of the statement
      */
      
      Defined in .../Common/Classes/Miner.php:1884
      public mergeHavingInto(Common\Classes\Miner $Miner): Miner Merge this Miner's HAVING into the given Miner.
      /**
      * Merge this Miner's HAVING into the given Miner.
      *
      * @param  Miner $Miner to merge into
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1858
      public havingNotBetween($column, $min, $max, $connector, $quote): Miner Add a NOT BETWEEN HAVING condition.
      /**
      * Add a NOT BETWEEN HAVING condition.
      *
      * @param  string $column column name
      * @param  mixed $min minimum value
      * @param  mixed $max maximum value
      * @param  string $connector optional logical connector, default AND
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1846
      public getFromString($includeText): string FROM portion of the statement Get the FROM portion of the statement, including all JOINs, as a string.
      /**
      * Get the FROM portion of the statement, including all JOINs, as a string.
      *
      * @param  bool $includeText optional include 'FROM' text, default true
      * @return string FROM portion of the statement
      */
      
      Defined in .../Common/Classes/Miner.php:1226
      public __toString(): string full SQL statement Get the full SQL statement without value placeholders.
      /**
      * Get the full SQL statement without value placeholders.
      *
      * @return string full SQL statement
      */
      
      Defined in .../Common/Classes/Miner.php:2381
      public getUpdate(): string UPDATE table Get the UPDATE table.
      /**
      * Get the UPDATE table.
      *
      * @return string UPDATE table
      */
      
      Defined in .../Common/Classes/Miner.php:723
      public replace($table): Miner Set the REPLACE table.
      /**
      * Set the REPLACE table.
      *
      * @param  string $table REPLACE table
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:629
      public mergeDeleteInto(Common\Classes\Miner $Miner): Miner Merge this Miner's DELETE into the given Miner.
      /**
      * Merge this Miner's DELETE into the given Miner.
      *
      * @param  Miner $Miner to merge into
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:787
      public delete($table): Miner Add a table to DELETE from, or false if deleting from the FROM table.
      /**
      * Add a table to DELETE from, or false if deleting from the FROM table.
      *
      * @param  string|false $table optional table name, default false
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:764
      public getUpdateString($includeText): string UPDATE portion of the statement Get the UPDATE portion of the statement as a string.
      /**
      * Get the UPDATE portion of the statement as a string.
      *
      * @param  bool $includeText optional include 'UPDATE' text, default true
      * @return string UPDATE portion of the statement
      */
      
      Defined in .../Common/Classes/Miner.php:734
      public mergeJoinInto(Common\Classes\Miner $Miner): Miner Merge this Miner's JOINs into the given Miner.
      /**
      * Merge this Miner's JOINs into the given Miner.
      *
      * @param  Miner $Miner to merge into
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1131
      public mergeUpdateInto(Common\Classes\Miner $Miner): Miner Merge this Miner's UPDATE into the given Miner.
      /**
      * Merge this Miner's UPDATE into the given Miner.
      *
      * @param  Miner $Miner to merge into
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:707
      public update($table): Miner Set the UPDATE table.
      /**
      * Set the UPDATE table.
      *
      * @param  string $table UPDATE table
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:694
      public getReplaceString($includeText): string REPLACE portion of the statement Get the REPLACE portion of the statement as a string.
      /**
      * Get the REPLACE portion of the statement as a string.
      *
      * @param  bool $includeText optional include 'REPLACE' text, default true
      * @return string REPLACE portion of the statement
      */
      
      Defined in .../Common/Classes/Miner.php:669
      public getReplace(): string REPLACE table Get the REPLACE table.
      /**
      * Get the REPLACE table.
      *
      * @return string REPLACE table
      */
      
      Defined in .../Common/Classes/Miner.php:658
      public mergeReplaceInto(Common\Classes\Miner $Miner): Miner Merge this Miner's REPLACE into the given Miner.
      /**
      * Merge this Miner's REPLACE into the given Miner.
      *
      * @param  Miner $Miner to merge into
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:642
      public getInsertString($includeText): string INSERT portion of the statement Get the INSERT portion of the statement as a string.
      /**
      * Get the INSERT portion of the statement as a string.
      *
      * @param  bool $includeText optional include 'INSERT' text, default true
      * @return string INSERT portion of the statement
      */
      
      Defined in .../Common/Classes/Miner.php:604
      public quote($value): mixed|false escaped value or false if failed Safely escape a value for use in a statement.
      /**
      * Safely escape a value for use in a statement.
      *
      * @param  mixed $value value to escape
      * @return mixed|false escaped value or false if failed
      */
      
      Defined in .../Common/Classes/Miner.php:399
      public getInsert(): string INSERT table Get the INSERT table.
      /**
      * Get the INSERT table.
      *
      * @return string INSERT table
      */
      
      Defined in .../Common/Classes/Miner.php:593
      public mergeInsertInto(Common\Classes\Miner $Miner): Miner Merge this Miner's INSERT into the given Miner.
      /**
      * Merge this Miner's INSERT into the given Miner.
      *
      * @param  Miner $Miner to merge into
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:577
      public insert($table): Miner Set the INSERT table.
      /**
      * Set the INSERT table.
      *
      * @param  string $table INSERT table
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:564
      public getSelectString($includeText): string SELECT portion of the statement Get the SELECT portion of the statement as a string.
      /**
      * Get the SELECT portion of the statement as a string.
      *
      * @param  bool $includeText optional include 'SELECT' text, default true
      * @return string SELECT portion of the statement
      */
      
      Defined in .../Common/Classes/Miner.php:529
      public mergeSelectInto(Common\Classes\Miner $Miner): Miner Merge this Miner's SELECT into the given Miner.
      /**
      * Merge this Miner's SELECT into the given Miner.
      *
      * @param  Miner $Miner to merge into
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:512
      public select($column, $alias, $operator): Miner Add a SELECT column, table, or expression with optional alias.
      /**
      * Add a SELECT column, table, or expression with optional alias.
      *
      * @param  string $column column name, table name, or expression
      * @param  string $alias optional alias
      * @param  string|array|null $operator optional operator
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:495
      public distinct(): Miner Add DISTINCT execution option.
      /**
      * Add DISTINCT execution option.
      *
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:482
      public calcFoundRows(): Miner Add SQL_CALC_FOUND_ROWS execution option.
      /**
      * Add SQL_CALC_FOUND_ROWS execution option.
      *
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:472
      public mergeOptionsInto(Common\Classes\Miner $Miner): Miner Merge this Miner's execution options into the given Miner.
      /**
      * Merge this Miner's execution options into the given Miner.
      *
      * @param  Miner $Miner to merge into
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:458
      public getDeleteString($includeText): string DELETE portion of the statement Get the DELETE portion of the statement as a string.
      /**
      * Get the DELETE portion of the statement as a string.
      *
      * @param  bool $includeText optional include 'DELETE' text, default true
      * @return string DELETE portion of the statement
      */
      
      Defined in .../Common/Classes/Miner.php:808
      public set($column, $value, $quote, $operator): Miner Add one or more column values to INSERT, UPDATE, or REPLACE. The operators must ...
      /**
      * Add one or more column values to INSERT, UPDATE, or REPLACE.
      * The operators must take either 0 or 1 parameter, e.g.: NOW(), PASSWORD(string), FLOOR(float).
      *
      * @param  string|array $column column name or array of columns => values
      * @param  string|array|null $operator operator name or array of operators (keys ignored)
      * @param  mixed|null $value optional value for single column
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:852
      public option($option): Miner Add an execution option like DISTINCT or SQL_CALC_FOUND_ROWS.
      /**
      * Add an execution option like DISTINCT or SQL_CALC_FOUND_ROWS.
      *
      * @param  string $option execution option to add
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:422
      public getAutoQuote($override): bool Get whether values will be automatically escaped.
      /**
      * Get whether values will be automatically escaped.
      *
      * The $override parameter is for convenience in checking if a specific
      * value should be quoted differently than the rest. 'null' defers to the
      * global setting.
      *
      * @param  bool|null $override value-specific override for convenience
      * @return bool
      */
      
      Defined in .../Common/Classes/Miner.php:371
      public setPdoConnection(PDO $PdoConnection): Miner Set the PDO database connection to use in executing this statement.
      /**
      * Set the PDO database connection to use in executing this statement.
      *
      * @param  \PDO|null $PdoConnection optional PDO database connection
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:331
      public getPdoConnection(): \PDO|null Get the PDO database connection to use in executing this statement.
      /**
      * Get the PDO database connection to use in executing this statement.
      *
      * @return \PDO|null
      */
      
      Defined in .../Common/Classes/Miner.php:343
      public setAutoQuote($autoQuote): Miner Set whether to automatically escape values.
      /**
      * Set whether to automatically escape values.
      *
      * @param  bool|null $autoQuote whether to automatically escape values
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:354
      public rightJoin($table, $criteria, $alias): Miner Add a RIGHT JOIN table with optional ON criteria.
      /**
      * Add a RIGHT JOIN table with optional ON criteria.
      *
      * @param  string $table table name
      * @param  string|array $criteria optional ON criteria
      * @param  string $alias optional alias
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1120
      public leftJoin($table, $criteria, $alias): Miner Add a LEFT JOIN table with optional ON criteria.
      /**
      * Add a LEFT JOIN table with optional ON criteria.
      *
      * @param  string $table table name
      * @param  string|array $criteria optional ON criteria
      * @param  string $alias optional alias
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1107
      public autoQuote($value, $override): mixed|false value (escaped or original) or false if failed Safely escape a value if auto-quoting is enabled, or do nothing if disabled.
      /**
      * Safely escape a value if auto-quoting is enabled, or do nothing if
      * disabled.
      *
      * The $override parameter is for convenience in checking if a specific
      * value should be quoted differently than the rest. 'null' defers to the
      * global setting.
      *
      * @param  mixed $value value to escape (or not)
      * @param  bool|null $override value-specific override for convenience
      * @return mixed|false value (escaped or original) or false if failed
      */
      
      Defined in .../Common/Classes/Miner.php:388
      public join($table, $criteria, $type, $alias): Miner Add a JOIN table with optional ON criteria.
      /**
      * Add a JOIN table with optional ON criteria.
      *
      * @param  string $table table name
      * @param  string|array $criteria optional ON criteria
      * @param  string $type optional type of join, default INNER JOIN
      * @param  string $alias optional alias
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1068
      public innerJoin($table, $criteria, $alias): Miner Add an INNER JOIN table with optional ON criteria.
      /**
      * Add an INNER JOIN table with optional ON criteria.
      *
      * @param  string $table table name
      * @param  string|array $criteria optional ON criteria
      * @param  string $alias optional alias
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1094
      public getFromAlias(): string FROM table alias Get the FROM table alias.
      /**
      * Get the FROM table alias.
      *
      * @return string FROM table alias
      */
      
      Defined in .../Common/Classes/Miner.php:1036
      public getFrom(): string FROM table Get the FROM table.
      /**
      * Get the FROM table.
      *
      * @return string FROM table
      */
      
      Defined in .../Common/Classes/Miner.php:1026
      public mergeFromInto(Common\Classes\Miner $Miner): Miner Merge this Miner's FROM into the given Miner.
      /**
      * Merge this Miner's FROM into the given Miner.
      *
      * @param  Miner $Miner to merge into
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1012
      public from($table, $alias): Miner Set the FROM table with optional alias.
      /**
      * Set the FROM table with optional alias.
      *
      * @param  string $table table name
      * @param  string $alias optional alias
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:998
      public getSetPlaceholderValues(): array SET placeholder values Get the SET placeholder values.
      /**
      * Get the SET placeholder values.
      *
      * @return array SET placeholder values
      */
      
      Defined in .../Common/Classes/Miner.php:986
      public getSetString($usePlaceholders, $includeText): string SET portion of the statement Get the SET portion of the statement as a string.
      /**
      * Get the SET portion of the statement as a string.
      *
      * @param  bool $usePlaceholders optional use ? placeholders, default true
      * @param  bool $includeText optional include 'SET' text, default true
      * @return string SET portion of the statement
      */
      
      Defined in .../Common/Classes/Miner.php:954
      public mergeSetInto(Common\Classes\Miner $Miner): Miner Merge this Miner's SET into the given Miner.
      /**
      * Merge this Miner's SET into the given Miner.
      *
      * @param  Miner $Miner to merge into
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:938
      public values(array $values): Miner Add an array of columns => values to INSERT, UPDATE, or REPLACE.
      /**
      * Add an array of columns => values to INSERT, UPDATE, or REPLACE.
      *
      * @param  array $values columns => values
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:927
      public getOptionsString($includeTrailingSpace): string execution options portion of the statement Get the execution options portion of the statement as a string.
      /**
      * Get the execution options portion of the statement as a string.
      *
      * @param  bool $includeTrailingSpace optional include space after options
      * @return string execution options portion of the statement
      */
      
      Defined in .../Common/Classes/Miner.php:435
      private getSelectStatement($usePlaceholders): string full SELECT statement Get the full SELECT statement.
      /**
      * Get the full SELECT statement.
      *
      * @param  bool $usePlaceholders optional use ? placeholders, default true
      * @return string full SELECT statement
      */
      
      Defined in .../Common/Classes/Miner.php:2153
      private getInsertStatement($usePlaceholders): string full INSERT statement Get the full INSERT statement.
      /**
      * Get the full INSERT statement.
      *
      * @param  bool $usePlaceholders optional use ? placeholders, default true
      * @return string full INSERT statement
      */
      
      Defined in .../Common/Classes/Miner.php:2196
      private getReplaceStatement($usePlaceholders): string full REPLACE statement Get the full REPLACE statement.
      /**
      * Get the full REPLACE statement.
      *
      * @param  bool $usePlaceholders optional use ? placeholders, default true
      * @return string full REPLACE statement
      */
      
      Defined in .../Common/Classes/Miner.php:2219
      private getUpdateStatement($usePlaceholders): string full UPDATE statement Get the full UPDATE statement.
      /**
      * Get the full UPDATE statement.
      *
      * @param  bool $usePlaceholders optional use ? placeholders, default true
      * @return string full UPDATE statement
      */
      
      Defined in .../Common/Classes/Miner.php:2242
      private getDeleteStatement($usePlaceholders): string full DELETE statement Get the full DELETE statement.
      /**
      * Get the full DELETE statement.
      *
      * @param  bool $usePlaceholders optional use ? placeholders, default true
      * @return string full DELETE statement
      */
      
      Defined in .../Common/Classes/Miner.php:2280
      private getJoinCriteriaUsingPreviousTable($joinIndex, $table, $column): string ON join criteria Get an ON criteria string joining the specified table and column to the same col...
      /**
      * Get an ON criteria string joining the specified table and column to the
      * same column of the previous JOIN or FROM table.
      *
      * @param  int $joinIndex index of current join
      * @param  string $table current table name
      * @param  string $column current column name
      * @return string ON join criteria
      */
      
      Defined in .../Common/Classes/Miner.php:1149
      private isDeleteTableFrom(): bool whether the delete table is FROM Whether the FROM table is the single table to delete from.
      /**
      * Whether the FROM table is the single table to delete from.
      *
      * @return bool whether the delete table is FROM
      */
      
      Defined in .../Common/Classes/Miner.php:837
      private parseOperators($operator, $quote, $value): array Parses the operators and functions.
      /**
      * Parses the operators and functions.
      *
      * @param string|array $operator
      * @param bool|null $quote
      * @param string|null $value
      * @param array|null $parameters
      * @return array
      */
      
      Defined in .../Common/Classes/Miner.php:881
      private isJoinUnique($table, $alias): bool whether the join table and alias is unique Whether the join table and alias is unique (hasn't already been joined).
      /**
      * Whether the join table and alias is unique (hasn't already been joined).
      *
      * @param  string $table table name
      * @param  string $alias table alias
      * @return bool whether the join table and alias is unique
      */
      
      Defined in .../Common/Classes/Miner.php:1048
      private getCriteriaString(array &$criteria, $usePlaceholders, array &$placeholderValues): string WHERE or HAVING portion of the statement Get the WHERE or HAVING portion of the statement as a string.
      /**
      * Get the WHERE or HAVING portion of the statement as a string.
      *
      * @param  array $criteria WHERE or HAVING criteria
      * @param  bool $usePlaceholders optional use ? placeholders, default true
      * @param  array $placeholderValues optional placeholder values array
      * @return string WHERE or HAVING portion of the statement
      */
      
      Defined in .../Common/Classes/Miner.php:1398
      private criteriaNotBetween(array &$criteria, $column, $min, $max, $connector, $quote): Miner Add a NOT BETWEEN condition to the specified WHERE or HAVING criteria.
      /**
      * Add a NOT BETWEEN condition to the specified WHERE or HAVING criteria.
      *
      * @param  array $criteria WHERE or HAVING criteria
      * @param  string $column column name
      * @param  mixed $min minimum value
      * @param  mixed $max maximum value
      * @param  string $connector optional logical connector, default AND
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1383
      private criteriaBetween(array &$criteria, $column, $min, $max, $connector, $quote): Miner Add a BETWEEN condition to the specified WHERE or HAVING criteria.
      /**
      * Add a BETWEEN condition to the specified WHERE or HAVING criteria.
      *
      * @param  array $criteria WHERE or HAVING criteria
      * @param  string $column column name
      * @param  mixed $min minimum value
      * @param  mixed $max maximum value
      * @param  string $connector optional logical connector, default AND
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1365
      private criteriaNotIn(array &$criteria, $column, array $values, $connector, $quote): Miner Add a NOT IN condition to the specified WHERE or HAVING criteria.
      /**
      * Add a NOT IN condition to the specified WHERE or HAVING criteria.
      *
      * @param  array $criteria WHERE or HAVING criteria
      * @param  string $column column name
      * @param  array $values values
      * @param  string $connector optional logical connector, default AND
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1348
      private orCriteria(array &$criteria, $column, $value, $operator, $quote): Miner Add an OR condition to the specified WHERE or HAVING criteria.
      /**
      * Add an OR condition to the specified WHERE or HAVING criteria.
      *
      * @param  array $criteria WHERE or HAVING criteria
      * @param  string $column column name
      * @param  mixed $value value
      * @param  string $operator optional comparison operator, default =
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1316
      private criteria(array &$criteria, $column, $value, $operator, $connector, $quote): Miner Add a condition to the specified WHERE or HAVING criteria.
      /**
      * Add a condition to the specified WHERE or HAVING criteria.
      *
      * @param  array $criteria WHERE or HAVING criteria
      * @param  string $column column name
      * @param  mixed $value value
      * @param  string $operator optional comparison operator, default =
      * @param  string $connector optional logical connector, default AND
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1294
      private closeCriteria(array &$criteria): Miner Add a closing bracket for nesting conditions to the specified WHERE or HAVING cr...
      /**
      * Add a closing bracket for nesting conditions to the specified WHERE or
      * HAVING criteria.
      *
      * @param  array $criteria WHERE or HAVING criteria
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1275
      private openCriteria(array &$criteria, $connector): Miner Add an open bracket for nesting conditions to the specified WHERE or HAVING crit...
      /**
      * Add an open bracket for nesting conditions to the specified WHERE or
      * HAVING criteria.
      *
      * @param  array $criteria WHERE or HAVING criteria
      * @param  string $connector optional logical connector, default AND
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1260
      private criteriaIn(array &$criteria, $column, array $values, $connector, $quote): Miner Add an IN condition to the specified WHERE or HAVING criteria.
      /**
      * Add an IN condition to the specified WHERE or HAVING criteria.
      *
      * @param  array $criteria WHERE or HAVING criteria
      * @param  string $column column name
      * @param  array $values values
      * @param  string $connector optional logical connector, default AND
      * @param  bool|null $quote optional auto-escape value, default to global
      * @return Miner
      */
      
      Defined in .../Common/Classes/Miner.php:1332
    • const INNER_JOIN :: string (10) "INNER JOIN"
      \Common\Classes\Miner::INNER_JOIN
      const NOT_LIKE :: string (8) "NOT LIKE"
      \Common\Classes\Miner::NOT_LIKE
      const BRACKET_OPEN :: string (1) "("
      \Common\Classes\Miner::BRACKET_OPEN
      const ORDER_BY_DESC :: string (4) "DESC"
      \Common\Classes\Miner::ORDER_BY_DESC
      const ORDER_BY_ASC :: string (3) "ASC"
      \Common\Classes\Miner::ORDER_BY_ASC
      const IS_NOT :: string (6) "IS NOT"
      \Common\Classes\Miner::IS_NOT
      const IS :: string (2) "IS"
      \Common\Classes\Miner::IS
      const NOT_BETWEEN :: string (11) "NOT BETWEEN"
      \Common\Classes\Miner::NOT_BETWEEN
      const BETWEEN :: string (7) "BETWEEN"
      \Common\Classes\Miner::BETWEEN
      const NOT_REGEX :: string (10) "NOT REGEXP"
      \Common\Classes\Miner::NOT_REGEX
      const REGEX :: string (6) "REGEXP"
      \Common\Classes\Miner::REGEX
      const ILIKE :: string (5) "ILIKE"
      \Common\Classes\Miner::ILIKE
      const LIKE :: string (4) "LIKE"
      \Common\Classes\Miner::LIKE
      const LEFT_JOIN :: string (9) "LEFT JOIN"
      \Common\Classes\Miner::LEFT_JOIN
      const NOT_IN :: string (6) "NOT IN"
      \Common\Classes\Miner::NOT_IN
      const IN :: string (2) "IN"
      \Common\Classes\Miner::IN
      const GREATER_THAN_OR_EQUAL :: string (2) ">="
      \Common\Classes\Miner::GREATER_THAN_OR_EQUAL
      const GREATER_THAN :: string (1) ">"
      \Common\Classes\Miner::GREATER_THAN
      const LESS_THAN_OR_EQUAL :: string (2) "<="
      \Common\Classes\Miner::LESS_THAN_OR_EQUAL
      const LESS_THAN :: string (1) "<"
      \Common\Classes\Miner::LESS_THAN
      const NOT_EQUALS :: string (2) "!="
      \Common\Classes\Miner::NOT_EQUALS
      const EQUALS :: string (1) "="
      \Common\Classes\Miner::EQUALS
      const LOGICAL_OR :: string (2) "OR"
      \Common\Classes\Miner::LOGICAL_OR
      const LOGICAL_AND :: string (3) "AND"
      \Common\Classes\Miner::LOGICAL_AND
      const RIGHT_JOIN :: string (10) "RIGHT JOIN"
      \Common\Classes\Miner::RIGHT_JOIN
      const BRACKET_CLOSE :: string (1) ")"
      \Common\Classes\Miner::BRACKET_CLOSE
    private MySQL -> Common\Classes\MySQLi (7)
    • Properties (7)
    • Available methods (6)
    • private DataBase -> string (7) "ci_apps"
      private MyConnectionID -> mysqli (19)
      • Properties (19)
      • Available methods (43)
      • public affected_rows -> null
        public client_info -> null
        public client_version -> null
        public connect_errno -> null
        public connect_error -> null
        public errno -> null
        public error -> null
        public error_list -> null
        public field_count -> null
        public host_info -> null
        public info -> null
        public insert_id -> null
        public protocol_version -> null
        public server_info -> null
        public server_version -> null
        public sqlstate -> null
        public stat -> null
        public thread_id -> null
        public warning_count -> null
      • public autocommit($mode)
        public savepoint($name)
        public real_connect($host, $user, $password, $database, $port, $socket, $flags)
        public real_escape_string($string_to_escape)
        public reap_async_query()
        public escape_string($string_to_escape)
        public real_query($query)
        public release_savepoint($name)
        public rollback($flags, $name)
        public select_db($database)
        public prepare($query)
        public set_charset($charset)
        public set_opt($option, $value)
        public ssl_set($key, $cert, $certificate_authority, $certificate_authority_path, $cipher)
        public stat()
        public stmt_init()
        public store_result($flags)
        public thread_safe()
        public use_result()
        public query($query, $resultmode)
        public ping()
        public begin_transaction($flags, $name)
        public get_client_info()
        public change_user($user, $password, $database)
        public character_set_name()
        public close()
        public commit($flags, $name)
        public connect($host, $user, $password, $database, $port, $socket)
        public dump_debug_info()
        public debug($debug_options)
        public get_charset()
        public get_connection_stats()
        public get_server_info()
        public get_warnings()
        public init()
        public kill($connection_id)
        public multi_query($query)
        public __construct($host, $user, $password, $database, $port, $socket)
        public more_results()
        public next_result()
        public options($option, $value)
        public refresh($options)
        public static poll(array &$read, array &$write, array &$error, $sec, $usec)
        \mysqli::poll(array &$read, array &$write, array &$error, $sec, $usec)
      private MyNum -> integer 0
      private MyResultID -> mysqli_result (5)
      • Properties (5)
      • Available methods (14)
      • public current_field -> null
        public field_count -> null
        public lengths -> null
        public num_rows -> null
        public type -> null
      • public __construct()
        public close()
        public free()
        public data_seek($offset)
        public fetch_field()
        public fetch_fields()
        public fetch_field_direct($field_nr)
        public fetch_all($result_type)
        public fetch_array($result_type)
        public fetch_assoc()
        public fetch_object($class_name, array $params)
        public fetch_row()
        public field_seek($field_nr)
        public free_result()
      private PWD -> string (9) "540pp1NG!"
      private Server -> string (9) "127.0.0.1"
      private UID -> string (4) "cart"
    • public __construct($DataBase, $Server, $User, $Pass) A MySQL wrapper to provide connectivity.
      /**
      * A MySQL wrapper to provide connectivity.
      *
      * @category MySQL Database Connectivity
      * @author   J. B. Saige <jbspublic@gmail.com>
      * @version  2.15
      *
      * @param string $DataBase [optional] The name of the database.
      * @param string $Server   [optional] The name of the server.
      * @param string $User     [optional] The username.
      * @param string $Pass     [optional] The password.
      *
      * @throws \Exception
      */
      
      Defined in .../Common/Classes/MySQLi.php:52
      public __invoke($Query): string The resource ID of the Query Alias of runQuery.
      /**
      * Alias of runQuery.
      *
      * @param string $Query A query to pass to MySQL
      * @return string The resource ID of the Query
      * @throws \Exception
      */
      
      Defined in .../Common/Classes/MySQLi.php:72
      public runQuery($Query): string The resource ID of the Query This will run the query in the database.
      /**
      * This will run the query in the database.
      *
      * @param string $Query A query to pass to MySQL
      * @return string The resource ID of the Query
      * @throws \Exception
      */
      
      Defined in .../Common/Classes/MySQLi.php:84
      public numberOfResults(): array The next row from the database. This will get the number of results of the query, if there was any.
      /**
      * This will get the number of results of the query, if there was any.
      *
      * @return array The next row from the database.
      * @throws \Exception
      */
      
      Defined in .../Common/Classes/MySQLi.php:100
      public getRow(): array The next row from the database. This will get the results of the query, if there was any.
      /**
      * This will get the results of the query, if there was any.
      *
      * @return array The next row from the database.
      * @throws \Exception
      */
      
      Defined in .../Common/Classes/MySQLi.php:116
      public insertID(): int The ID number of the last INSERT statement. This will get the insert ID of the query.
      /**
      * This will get the insert ID of the query.
      *
      * @return int The ID number of the last INSERT statement.
      * @throws \Exception
      */
      
      Defined in .../Common/Classes/MySQLi.php:132
  • public __construct($UID, Common\Classes\MySQLi &$MySQL, $Database) The entire shopping cart.
    new \Cart\Classes\ShoppingCart($UID, Common\Classes\MySQLi &$MySQL, $Database)
    /**
    * The entire shopping cart.
    *
    * @param int    $UID   The User ID of the Cart
    * @param MySQLi $MySQL [OPTIONAL] The MySQL object to use, if one exists.
    * @param string $Database
    *
    * @throws \Exception
    */
    
    Defined in .../Cart/Classes/ShoppingCart.php:76
    public MakeXML($OrderNumber, $OrderID, AuthorizeNetAIM_Response $response, $customerData): null Generates the XML file for this order.
    $shoppingCart->MakeXML($OrderNumber, $OrderID, AuthorizeNetAIM_Response $response, $customerData)
    /**
    * Generates the XML file for this order.
    *
    * @param string                    $OrderID      The Internet ID for the order as in MOM
    * @param \AuthorizeNetAIM_Response $response     The ANResponse.
    * @param null                      $customerData The customer's data
    *
    * @return null
    */
    
    Defined in .../Cart/Classes/ShoppingCart.php:100
    public hasGiftWrap()
    $shoppingCart->hasGiftWrap()
    Defined in .../Cart/Classes/ShoppingCart.php:1031
    public checkForDuplicatePrimaries()
    $shoppingCart->checkForDuplicatePrimaries()
    Defined in .../Cart/Classes/ShoppingCart.php:1014
    public checkForBadItemIDs()
    $shoppingCart->checkForBadItemIDs()
    Defined in .../Cart/Classes/ShoppingCart.php:1000
    public checkForQuantityErrors(): bool Returns true on quantity errors.
    $shoppingCart->checkForQuantityErrors()
    /**
    * Returns true on quantity errors.
    *
    * @return bool
    */
    
    Defined in .../Cart/Classes/ShoppingCart.php:988
    public hasOnlyStockItems()
    $shoppingCart->hasOnlyStockItems()
    Defined in .../Cart/Classes/ShoppingCart.php:937
    public updateItemQuantity($LineNumber, $Quantity)
    $shoppingCart->updateItemQuantity($LineNumber, $Quantity)
    Defined in .../Cart/Classes/ShoppingCart.php:932
    public checkMOM($ItemID): null Check MOM for a matching ID
    $shoppingCart->checkMOM($ItemID)
    /**
    * Check MOM for a matching ID
    *
    * @param string $ItemID The ItemID or PartNumber
    *
    * @return null
    */
    
    Defined in .../Cart/Classes/ShoppingCart.php:890
    public deleteItem($index): void Delete the selected item from the cart.
    $shoppingCart->deleteItem($index)
    /**
    * Delete the selected item from the cart.
    *
    * @param int $index The line number of the item to delete.
    *
    * @return void
    */
    
    Defined in .../Cart/Classes/ShoppingCart.php:877
    public negateDuplicateSetupFeesOnVariants()
    $shoppingCart->negateDuplicateSetupFeesOnVariants()
    Defined in .../Cart/Classes/ShoppingCart.php:1042
    public addItem($ItemArray): void Add an item.
    $shoppingCart->addItem($ItemArray)
    /**
    * Add an item.
    *
    * @param array $ItemArray The array that contains the item information.
    *
    * @return void
    */
    
    Defined in .../Cart/Classes/ShoppingCart.php:380
    public loadQuantityRules(): void Load the quantity rules.
    $shoppingCart->loadQuantityRules()
    /**
    * Load the quantity rules.
    *
    * @return void
    */
    
    Defined in .../Cart/Classes/ShoppingCart.php:357
    public recalculateQuantityDiscounts()
    $shoppingCart->recalculateQuantityDiscounts()
    Defined in .../Cart/Classes/ShoppingCart.php:260
    public recalculatePrices()
    $shoppingCart->recalculatePrices()
    Defined in .../Cart/Classes/ShoppingCart.php:245
    public getTaxRate()
    $shoppingCart->getTaxRate()
    Defined in .../Cart/Classes/ShoppingCart.php:217
    public loadCartByNumber($UID): void Load a cart given a internet id number.
    $shoppingCart->loadCartByNumber($UID)
    /**
    * Load a cart given a internet id number.
    *
    * @param int $UID The unique id of the cart to load.
    *
    * @return void
    * @throws \Exception
    */
    
    Defined in .../Cart/Classes/ShoppingCart.php:181
    public getCartWeight()
    $shoppingCart->getCartWeight()
    Defined in .../Cart/Classes/ShoppingCart.php:131
    public setDatabase($Database)
    $shoppingCart->setDatabase($Database)
    Defined in .../Cart/Classes/ShoppingCart.php:125
    private deleteItemForUpdate($LineNumber): string This function will delete everything that floors to $LineNumber, the deleted dat...
    /**
    * This function will delete everything that floors to $LineNumber, the deleted data is returned.
    *
    * @param int $LineNumber The item line number to delete.
    *
    * @return string
    */
    
    Defined in .../Cart/Classes/ShoppingCart.php:918
    private loadCart(): void Load the cart using the number that this class already has.
    /**
    * Load the cart using the number that this class already has.
    *
    * @return void
    * @throws \Exception
    */
    
    Defined in .../Cart/Classes/ShoppingCart.php:193
    private postToDB($UID, $Line, $Item, $Qty, $Setup, $Referer): void This function will add the inputted data to the shopping cart.
    /**
    * This function will add the inputted data to the shopping cart.
    *
    * @param int    $UID     The Customer's ID, Shopping Cart ID, etc.
    * @param float  $Line    The line number to add, formatted as 12345.12345
    * @param string $Item    The MOM-ID or not.  Can be anything.
    * @param int    $Qty     The number of this item.  Sub lines may each have different qtys.
    * @param int(1) $Setup   A boolean int.  0 or 1.
    * @param string $Referer The HTTP_REFERER
    *
    * @return void
    */
    
    Defined in .../Cart/Classes/ShoppingCart.php:827
  • public static $ShippingComboModifier :: array (1)
    \Cart\Classes\ShoppingCart::$ShippingComboModifier
    0 => array (3)
    \Cart\Classes\ShoppingCart::$ShippingComboModifier[0]
    item => array (2)
    \Cart\Classes\ShoppingCart::$ShippingComboModifier[0]['item']
    0 => string (18) "/^(MB[P]?.*1000)/i"
    \Cart\Classes\ShoppingCart::$ShippingComboModifier[0]['item'][0]
    1 => string (11) "/^(MBINS)/i"
    \Cart\Classes\ShoppingCart::$ShippingComboModifier[0]['item'][1]
    match => string (3) "all"
    \Cart\Classes\ShoppingCart::$ShippingComboModifier[0]['match']
    weight_add_fixed => double 0.6
    \Cart\Classes\ShoppingCart::$ShippingComboModifier[0]['weight_add_fixed']
$_SESSION array (3)
UID => string (15) "964821579414971"
$_SESSION['UID']
BillingCustomerNumber => string (0) ""
$_SESSION['BillingCustomerNumber']
custnum => string (0) ""
$_SESSION['custnum']
Called from <ROOT>Cart/viewCart.php:126
  1. <ROOT>Cart/index.php:7