function get_basket_id() { if ($basket = get_basket('id')) { return $basket->id; } return 0; }
public function confirm() { global $DB, $CFG; if ($basketid = get_basket_id()) { // Send invoice email to the user. $basket = get_basket(); $basket->itemized = get_invoice_html($basketid, 0, 0); // Notify shop admin. if (isset($CFG->commerce_admin_email)) { if (!($shopadmin = $DB->get_record('user', array('email' => $CFG->commerce_admin_email)))) { $shopadmin = new stdClass(); $shopadmin->email = $CFG->commerce_admin_email; if (empty($CFG->commerce_admin_firstname)) { $shopadmin->firstname = "Shop"; } else { $shopadmin->firstname = $CFG->commerce_admin_firstname; } if (empty($CFG->commerce_admin_lastname)) { $shopadmin->lastname = "Admin"; } else { $shopadmin->lastname = $CFG->commerce_admin_lastname; } $shopadmin->id = -999; } } else { $shopadmin = new stdClass(); $shopadmin->email = $CFG->support_email; if (empty($CFG->commerce_admin_firstname)) { $shopadmin->firstname = "Shop"; } else { $shopadmin->firstname = $CFG->commerce_admin_firstname; } if (empty($CFG->commerce_admin_lastname)) { $shopadmin->lastname = "Admin"; } else { $shopadmin->lastname = $CFG->commerce_admin_lastname; } $shopadmin->id = -999; } if ($user = $DB->get_record('user', array('id' => $basket->userid))) { EmailTemplate::send('invoice_ordercomplete', array('user' => $user, 'invoice' => $basket, 'sender' => $shopadmin)); // Notify shop admin. if (isset($CFG->commerce_admin_email)) { EmailTemplate::send('invoice_ordercomplete_admin', array('user' => $shopadmin, 'invoice' => $basket, 'sender' => $shopadmin)); } // Set status of invoice to unpaid. $DB->set_field('invoice', 'status', INVOICESTATUS_UNPAID, array('id' => $basketid)); return ''; } } return '<p class="error">' . get_string('pp_invoice_basketnolongeravailable', 'block_iomad_commerce') . '</p>'; }
/** * Validate and add a voucher to a basket * * @access public * @return void * **/ public function add_voucher() { $_voucher = $this->shop_voucher_model->validate($this->input->post('voucher'), get_basket()); if ($_voucher) { // Validated, add to basket $this->session->set_flashdata('success', '<strong>Success!</strong> Voucher has been applied to your basket.'); $this->shop_basket_model->add_voucher($_voucher->code); } else { // Failed to validate, feedback $this->session->set_flashdata('error', '<strong>Sorry,</strong> that voucher is not valid:<br />› ' . implode('<br />›', $this->shop_voucher_model->get_errors())); } // -------------------------------------------------------------------------- redirect($this->data['return']); }
function get_delivery_codes_list($request_data) { global $connection; // See if it is okay to open a basket... if (ActiveCycle::delivery_id() && (ActiveCycle::ordering_window() == 'open' || CurrentMember::auth_type('orderex'))) { // If requested to open-basket... if ($request_data['action'] == 'open_basket') { if ($request_data['site_id'] && $request_data['delivery_type']) { $site_id = $request_data['site_id']; $delivery_type = $request_data['delivery_type']; // First try an assigned delivery_id... then use the current active one $delivery_id = $request_data['delivery_id']; if (!$delivery_id) { $delivery_id = ActiveCycle::delivery_id(); } // First try an assigned member_id... then use the current session one $member_id = $request_data['member_id']; if (!$member_id) { $member_id = $_SESSION['member_id']; } // Update the basket $basket_info = open_update_basket(array('member_id' => $member_id, 'delivery_id' => $delivery_id, 'site_id' => $site_id, 'delivery_type' => $delivery_type)); } } else { $basket_info = get_basket($request_data['member_id'], $request_data['delivery_id']); } // // Ordering is open and there is no basket open yet // // Get this member's most recent delivery location // $query = ' // SELECT // '.NEW_TABLE_SITES.'.site_id, // '.NEW_TABLE_SITES.'.deltype // FROM // '.NEW_TABLE_BASKETS.' // LEFT JOIN // '.NEW_TABLE_SITES.' USING(site_id) // WHERE // '.NEW_TABLE_BASKETS.'.member_id = "'.mysql_real_escape_string($_SESSION['member_id']).'" // AND '.NEW_TABLE_SITES.'.inactive = "0" // ORDER BY // delivery_id DESC // LIMIT // 1'; // $result = mysql_query ($query, $connection) or die(debug_print ("ERROR: 548167 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); // if ($row = mysql_fetch_array ($result)) // { // $site_id_prior = $row['site_id']; // $deltype_prior = $row['deltype']; // } // Constrain this shopper's baskets to the site_type they are enabled to use $site_type_constraint = ''; if (CurrentMember::auth_type('member')) { $site_type_constraint .= ' ' . (strlen($site_type_constraint) > 0 ? 'OR ' : '') . 'site_type LIKE "%customer%"'; } if (CurrentMember::auth_type('institution')) { $site_type_constraint .= ' ' . (strlen($site_type_constraint) > 0 ? 'OR ' : '') . 'site_type LIKE "%institution%"'; } $site_type_constraint = ' AND (' . $site_type_constraint . ' )'; // Now get the list of all available delivery codes and flag the one // that corresponds to this member's prior order $query = ' SELECT ' . NEW_TABLE_SITES . '.site_id, ' . NEW_TABLE_SITES . '.site_short, ' . NEW_TABLE_SITES . '.site_long, ' . NEW_TABLE_SITES . '.delivery_type, ' . NEW_TABLE_SITES . '.site_description, ' . NEW_TABLE_SITES . '.delivery_charge, ' . NEW_TABLE_SITES . '.inactive, ' . TABLE_MEMBER . '.address_line1, ' . TABLE_MEMBER . '.work_address_line1 FROM (' . NEW_TABLE_SITES . ', ' . TABLE_MEMBER . ') WHERE ' . NEW_TABLE_SITES . '.inactive != "1" AND ' . TABLE_MEMBER . '.member_id = "' . mysql_real_escape_string($_SESSION['member_id']) . '"' . $site_type_constraint . ' ORDER BY site_long'; $result = mysql_query($query, $connection) or die(debug_print("ERROR: 671934 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__)); $site_id_array = array(); $delivery_type_array = array(); $display .= ' <div id="delivery_dropdown" class="dropdown"> <a href="' . $_SERVER['SCRIPT_NAME'] . '?action=delivery_list_only"><h1 class="delivery_select">' . ($basket_info['site_id'] ? 'Selected: ' . $basket_info['site_long'] : 'Select Location') . ' </h1></a> <div id="delivery_select"> <ul class="delivery_select">'; while ($row = mysql_fetch_array($result)) { // Simplify variables $site_id = $row['site_id']; $site_long = $row['site_long']; $delivery_type = $row['delivery_type']; $site_description = $row['site_description']; $delivery_charge = $row['delivery_charge']; $inactive = $row['inactive']; $address = $row['address_line1']; $work_address = $row['work_address_line1']; // Set up some text for the $delivery type (delivery or pickup) if ($delivery_type == 'P') { $delivery_type_text = 'Pick up your order here'; $delivery_type_class = 'delivery_type-p'; } elseif ($delivery_type == 'D') { $delivery_type_text_h = 'HOME delivery'; $delivery_type_text_w = 'WORK delivery'; if ($delivery_charge) { $delivery_type_text_h .= ' ($' . number_format($delivery_charge, 2) . ' charge)'; $delivery_type_text_w .= ' ($' . number_format($delivery_charge, 2) . ' charge)'; } $delivery_type_class = 'delivery_type-d'; } else { $delivery_type_text = ''; $delivery_type_class = ''; } // Process the inactive options if ($inactive == 0) { $show_site = true; $active_class = ' active'; $select_link_href = $_SERVER['SCRIPT_NAME'] . '?action=open_basket&site_id=' . $site_id . '&delivery_type=P'; $select_link_h_href = $_SERVER['SCRIPT_NAME'] . '?action=open_basket&site_id=' . $site_id . '&delivery_type=H'; $select_link_w_href = $_SERVER['SCRIPT_NAME'] . '?action=open_basket&site_id=' . $site_id . '&delivery_type=W'; $delivery_type_class .= 'a'; // color } elseif ($inactive == 2) { $show_site = true; $active_class = ' inactive'; $select_link_href = ''; $select_link_h_href = ''; $select_link_w_href = ''; $delivery_type_class .= 'i'; // color $delivery_type_text = '(Not available for pick up this cycle)'; // clobber the delivery type text $delivery_type_text_h = '(Not available for home delivery this cycle)'; // clobber the delivery type text $delivery_type_text_w = '(Not available for work delivery this cycle)'; // clobber the delivery type text } else { $show_site = false; $active_class = ' suspended'; $select_link_href = ''; $select_link_h_href = ''; $select_link_w_href = ''; $delivery_type_class .= 'i'; // color $delivery_type_text = '(Not available for pick up this cycle)'; // clobber the delivery type text $delivery_type_text_h = '(Not available for home delivery this cycle)'; // clobber the delivery type text $delivery_type_text_w = '(Not available for work delivery this cycle)'; // clobber the delivery type text } // Process current selection if ($site_id == CurrentBasket::site_id()) { $selected = true; $select_class = ' select'; $delivery_type_class .= 'c'; // color } else { $selected = 'false'; $select_class = ''; $delivery_type_class .= 'g'; // greyscale } if ($show_site == true) { if ($delivery_type == 'P') { $display .= ' <li class="' . $delivery_type_class . $active_class . $select_class . '" ' . ($select_link_href != '' ? 'onclick="javascript:location.href=\'' . $select_link_href : '') . '\';parent.close_delivery_selector();"> <span class="site_long">' . $site_long . '</span> <span class="site_action">' . $delivery_type_text . '</span> <span class="site_description">' . br2nl($site_description) . '</span> </li>'; } // For delivery_type = delivery, we will give an option for "home" if ($delivery_type == 'D' && $address) { if ($basket_info['delivery_type'] != 'H') { $select_class = ''; } $display .= ' <li class="' . $delivery_type_class . $active_class . $select_class . '" ' . ($select_link_h_href != '' ? 'onclick="javascript:location.href=\'' . $select_link_h_href : '') . '\';parent.close_delivery_selector();"> <span class="site_long">' . $site_long . '</span> <span class="site_action">' . $delivery_type_text_h . '</span> <span class="site_description"><strong>To home address:</strong> ' . $address . '<br>' . br2nl($site_description) . '</span> </li>'; } // For delivery_type = delivery, we will also give an option for "work" if ($delivery_type == 'D' && $work_address) { if ($basket_info['delivery_type'] != 'W') { $select_class = ''; } $display .= ' <li class="' . $delivery_type_class . $active_class . $select_class . '" ' . ($select_link_w_href != '' ? 'onclick="javascript:location.href=\'' . $select_link_w_href : '') . '\';parent.close_delivery_selector();"> <span class="site_long">' . $site_long . '</span> <span class="site_action">' . $delivery_type_text_w . '</span> <span class="site_description"><strong>To work address:</strong> ' . $work_address . '<br>' . br2nl($site_description) . '</span> </li>'; } } } $display .= ' </ul> </div> </div>'; } return $display; }
include_once 'func.get_basket_item.php'; include_once 'func.update_basket_item.php'; // $action = [set_weight|set_quantity|set_weight_quantity] $bpid = $_POST['bpid']; $action = $_POST['action']; if ($non_ajax_query == false) { $ship_quantity = $_POST['ship_quantity']; $weight = $_POST['weight']; } else { $ship_quantity = $_POST['ship_quantity' . $bpid]; $weight = $_POST['weight' . $bpid]; } // Information about the actual basket item $item_info = get_basket_item($bpid); $basket_id = $item_info['basket_id']; $basket_info = get_basket($basket_id); $out_of_stock = $item_info['quantity'] - $ship_quantity; // Update the basket $result_item_info = update_basket_item(array('action' => 'set_all_producer', 'basket_id' => $item_info['basket_id'], 'member_id' => $basket_info['member_id'], 'delivery_id' => $basket_info['delivery_id'], 'product_id' => $item_info['product_id'], 'product_version' => $item_info['product_version'], 'out_of_stock' => $out_of_stock, 'weight' => $weight)); // Synch the ledger $result_item_info = update_basket_item(array('action' => 'producer_synch_ledger', 'basket_id' => $item_info['basket_id'], 'member_id' => $basket_info['member_id'], 'delivery_id' => $basket_info['delivery_id'], 'product_id' => $item_info['product_id'], 'product_version' => $item_info['product_version'])); // Should be able to use $result_item_info from above but it is not working $result_item_info = get_basket_item($bpid); // Now set return values if (is_array($result_item_info)) { // Set the various fees: $customer_product_adjust_fee = 0; $producer_product_adjust_fee = 0; if (PAYS_PRODUCT_FEE == 'customer') { $customer_product_adjust_fee = $result_item_info['product_fee_percent'] / 100; } elseif (PAYS_PRODUCT_FEE == 'producer') {
function saveOrder($dt) { global $basket, $db; $goods = get_basket(); $stmt = mysqli_stmt_init($db); $sql = 'INSERT INTO orders(title,author,pubyear,price,quantity,orderid,datetime) VALUE(?,?,?,?,?,?,?)'; if (!mysqli_stmt_prepare($stmt, $sql)) { return false; } foreach ($goods as $item) { mysqli_stmt_bind_param($stmt, 'ssiiisi', $item['title'], $item['author'], $item['pubyear'], $item['price'], $item['quantity'], $basket['orderid'], $dt); mysqli_stmt_execute($stmt); } mysqli_stmt_close($stmt); setcookie('basket', '', time() - 3600); return true; }
function update_basket(array $data) { // debug_print ('INFO: Update Basket', $data); global $connection; // $member_id_you = $_SESSION['member_id']; $producer_id_you = $_SESSION['producer_id_you']; // Allow admins to override certain checks if the requested action is not for themselves $admin_override = true; if ($member_id_you == $data['member_id'] || !CurrentMember::auth_type('cashier')) { $admin_override = false; } // Set this value manually when converting from transactions to ledger accounting $admin_override = true; // Set flags for needed validations and operations switch ($data['action']) { // checkout will checkout all the items in the basket case 'checkout': $test_for_membership_privilege = true; $test_customer_ordering_window = true; $initiate_set_checkout = true; $initiate_checkout_items = true; break; // same as "checkout" but only synchs items that were already checked out // same as "checkout" but only synchs items that were already checked out case 'synch_ledger_items': $test_for_membership_privilege = true; $test_customer_ordering_window = true; $initiate_set_checkout = true; $synch_ledger_items = true; break; // set_uncheckout is currently disabled // set_uncheckout is currently disabled case 'set_checkout': $test_for_membership_privilege = true; $test_customer_ordering_window = true; $initiate_set_checkout = true; break; // un_checkout is currently disabled // un_checkout is currently disabled case 'un_checkout': $test_customer_ordering_window = true; $initiate_un_checkout = true; break; // update the site (Pickup|Home|Work) // update the site (Pickup|Home|Work) case 'set_site': $update_site = true; break; default: die(debug_print('ERROR: 679217 ', 'unexpected request', basename(__FILE__) . ' LINE ' . __LINE__)); break; } // Get information about the basket for this member // Prefer to access basket by basket_id if ($data['basket_id'] != 0) { $basket_info = get_basket($data['basket_id']); } elseif ($data['member_id'] != 0 && $data['delivery_id'] != 0) { $basket_info = get_basket($data['member_id'], $data['delivery_id']); } else { die(debug_print('ERROR: 970893 ', 'incomplete information to locate basket', basename(__FILE__) . ' LINE ' . __LINE__)); } // Check that we actually got some basket information if (!is_array($basket_info)) { die(debug_print('ERROR: 701854 ', 'basket does not exist', basename(__FILE__) . ' LINE ' . __LINE__)); } // Check that the member is not pending or discontinued if ($test_for_membership_privilege && !$admin_override) { if ($member_info['pending'] == 1 || $member_info['membership_discontinued'] == 1) { die(debug_print('ERROR: 974383 ', 'incorrect privilege to order', basename(__FILE__) . ' LINE ' . __LINE__)); } } // Check if shopping is closed for this order if ($test_customer_ordering_window && !$admin_override) { if (ActiveCycle::ordering_window() == 'closed') { die(debug_print('ERROR: 823186 ', 'customer ordering period is not in effect', basename(__FILE__) . ' LINE ' . __LINE__)); } } // Update the basket with a new site and information related to the new site if ($update_site) { debug_print("ERROR: 892573 ", "UPDATE DELCODE", basename(__FILE__) . ' LINE ' . __LINE__); if ($data['delivery_type'] == 'H' || $data['delivery_type'] == 'W') { $query_delivery_type = 'D'; } else { $query_delivery_type = $data['delivery_type']; } // P[ickup] // Could check for changes and abort otherwise, but this will force updating // delivery_postal_code just in case it might have changed. $query_site = ' SELECT delivery_charge, delivery_postal_code FROM ' . NEW_TABLE_SITES . ' WHERE site_id = "' . mysql_real_escape_string($data['site_id']) . '" AND delivery_type = "' . $query_delivery_type . '" AND inactive = "0" AND site_type = "customer"'; $result_site = mysql_query($query_site, $connection) or die(debug_print("ERROR: 892573 ", array($query_site, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__)); // Got we some information, then post the new information if ($row_site = mysql_fetch_array($result_site)) { $query_update_basket = ' UPDATE ' . NEW_TABLE_BASKETS . ' SET delivery_cost = "' . mysql_real_escape_string($row_site['delivery_charge']) . '", delivery_postal_code = "' . mysql_real_escape_string($row['delivery_postal_code']) . '", site_id = "' . mysql_real_escape_string($data['site_id']) . '", delivery_type = "' . mysql_real_escape_string($data['delivery_type']) . '" WHERE basket_id = "' . mysql_real_escape_string($basket_info['basket_id']) . '"'; $result_update_basket = mysql_query($query_update_basket, $connection) or die(debug_print("ERROR: 892764 ", array($query_update_basket, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__)); debug_print("INFO: 892573 ", $query_update_basket, basename(__FILE__) . ' LINE ' . __LINE__); // Update the $basket_info with changes $basket_info['delivery_cost'] = $row_site['delivery_charge']; $initiate_delivery_charge = true; } else { die(debug_print('ERROR: 898952 ', 'requested site does not exist or is not available', basename(__FILE__) . ' LINE ' . __LINE__)); } } // Change the checked_out setting on the basket // Do this early so the update_basket_item will process the ledger items (only if they are in a checked-out state) if ($initiate_set_checkout) { // Get the number of items in the basket that are checked out $query = ' SELECT ' . NEW_TABLE_PRODUCTS . '.tangible, COUNT(' . NEW_TABLE_BASKET_ITEMS . '.bpid) AS count FROM ' . NEW_TABLE_BASKET_ITEMS . ' LEFT JOIN ' . NEW_TABLE_PRODUCTS . ' USING(product_id,product_version) WHERE ' . NEW_TABLE_BASKET_ITEMS . '.basket_id = "' . mysql_real_escape_string($basket_info['basket_id']) . '" GROUP BY ' . NEW_TABLE_PRODUCTS . '.tangible'; $result = mysql_query($query, $connection) or die(debug_print("ERROR: 758023 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__)); while ($row = mysql_fetch_array($result)) { if ($row['tangible'] == '0') { $intangible_count = $row['count']; } if ($row['tangible'] == '1') { $tangible_count = $row['count']; } } // Preference is to set basket count to the number of *tangible* items in the basket if ($tangible_count > 0) { $checked_out = $tangible_count; } elseif ($intangible_count > 0) { $checked_out = 0 - $intangible_count; } else { $checked_out = 0; } $query = ' UPDATE ' . NEW_TABLE_BASKETS . ' SET checked_out = "' . mysql_real_escape_string($checked_out) . '" WHERE basket_id = "' . mysql_real_escape_string($basket_info['basket_id']) . '"'; $result = mysql_query($query, $connection) or die(debug_print("ERROR: 892764 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__)); // Sync the variable we just changed $basket_info['checked_out'] = $checked_out; // If there is an order cost (fixed), then post it (or clear it if wrongly set). if ($basket_info['order_cost'] != 0 && $basket_info['order_cost_type'] == 'fixed' && $basket_info['checked_out'] != 0) { // Add the order cost to the ledger for this basket $ledger_status = basket_item_to_ledger(array('transaction_group_id' => $data['transaction_group_id'], 'source_type' => 'member', 'source_key' => $data['member_id'], 'target_type' => 'internal', 'target_key' => 'order_cost', 'amount' => $basket_info['order_cost'], 'text_key' => 'order cost', 'posted_by' => $_SESSION['member_id'], 'basket_id' => $basket_info['basket_id'], 'site_id' => $basket_info['site_id'], 'delivery_id' => $basket_info['delivery_id'], 'match_keys' => array('source_type', 'source_key', 'target_type', 'target_key', 'text_key', 'basket_id'))); } elseif ($basket_info['order_cost'] != 0 && $basket_info['order_cost_type'] == 'percent' && $basket_info['checked_out'] != 0) { // First need to know the basket total to calculate the percent cost $query = ' SELECT SUM(amount) AS order_total FROM ' . NEW_TABLE_LEDGER . ' WHERE basket_id = "' . mysql_real_escape_string($basket_info['basket_id']) . '" AND (text_key = "quantity cost" OR text_key = "weight cost")'; $result = mysql_query($query, $connection) or die(debug_print("ERROR: 678304 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__)); if ($row = mysql_fetch_array($result)) { $order_total = $row['order_total']; $order_cost_total = round($row['order_total'] * $basket_info['order_cost'] / 100, 2); } // Add the order cost to the ledger for this basket $ledger_status = basket_item_to_ledger(array('transaction_group_id' => $data['transaction_group_id'], 'source_type' => 'member', 'source_key' => $data['member_id'], 'target_type' => 'internal', 'target_key' => 'order_cost', 'amount' => $basket_info['order_cost'], 'text_key' => 'order cost', 'posted_by' => $_SESSION['member_id'], 'basket_id' => $basket_info['basket_id'], 'site_id' => $basket_info['site_id'], 'delivery_id' => $basket_info['delivery_id'], 'match_keys' => array('source_type', 'source_key', 'target_type', 'target_key', 'text_key', 'basket_id'))); } } // For checkout, synchronize ledger entries to all basket_items if ($initiate_checkout_items || $synch_ledger_items) { // $initiate_checkout_items: check out all items and synch ledger // $synch_ledger_items: repost existing checked_out items to the ledger if ($synch_ledger_items) { // Restrict to just the checked_out items $query_where = ' AND checked_out != "0"'; } // Get the items currently in the basket $query_basket_items = ' SELECT bpid, product_id, product_version FROM ' . NEW_TABLE_BASKET_ITEMS . ' WHERE basket_id = "' . mysql_real_escape_string($basket_info['basket_id']) . '"' . $query_where; $result_basket_items = mysql_query($query_basket_items, $connection) or die(debug_print("ERROR: 892785 ", array($query_basket_items, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__)); // Go through all the basket items (or all the checked_out items) while ($row_basket_items = mysql_fetch_array($result_basket_items)) { $basket_item_info = update_basket_item(array('action' => 'synch_ledger', 'delivery_id' => $data['delivery_id'], 'member_id' => $data['member_id'], 'product_id' => $row_basket_items['product_id'], 'product_version' => $row_basket_items['product_version'])); if (!is_array($basket_item_info)) { die(debug_print("ERROR: 902784 ", 'update_basket_item() did not return array.', basename(__FILE__) . ' LINE ' . __LINE__)); } } } // This is done for any/all changes, so not conditional except for baskets that are not checked-out. if ($basket_info['checked_out'] != 0) { // If there is a delivery charge, then post it (or clear it if wrongly set). if ($basket_info['delivery_cost'] != 0 || $initiate_delivery_charge) { // Add the delivery cost to the ledger for this basket $ledger_status = basket_item_to_ledger(array('transaction_group_id' => $data['transaction_group_id'], 'source_type' => 'member', 'source_key' => $data['member_id'], 'target_type' => 'internal', 'target_key' => 'delivery_cost', 'amount' => $basket_info['delivery_cost'], 'text_key' => 'delivery cost', 'posted_by' => $_SESSION['member_id'], 'basket_id' => $basket_info['basket_id'], 'site_id' => $basket_info['site_id'], 'delivery_id' => $basket_info['delivery_id'], 'match_keys' => array('source_type', 'source_key', 'target_type', 'target_key', 'text_key', 'basket_id'))); } } // // For un_checkout, clear all ledger entries related to the basket and basket_items // // This will remove or clear the cost of ledger entries for all products in the basket // if ($initiate_un_checkout) // { // // Get the items currently in the basket // $query_basket_items = ' // SELECT // bpid, // product_id, // product_version // FROM '.NEW_TABLE_BASKET_ITEMS.' // WHERE basket_id = "'.mysql_real_escape_string($basket_info['basket_id']).'"'; // $result_basket_items = mysql_query($query_basket_items, $connection) or die(debug_print ("ERROR: 892785 ", array ($query_basket_items,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); // // Go through all the basket items // while ($row_basket_items = mysql_fetch_array($result_basket_items)) // { // // Problem: clear_item removes all quantity from the basket. We would like to leave the basket unchanged. // // ... but if we define that as the desired behavior, then we have something, at least... // $basket_item_info = update_basket_item (array( // 'action' => 'un_checkout', // 'delivery_id' => $data['delivery_id'], // 'member_id' => $data['member_id'], // 'product_id' => $row_basket_items['product_id'], // 'product_version' => $row_basket_items['product_version'], // 'post_even_if_zero' => 'YES' // )); // if ($basket_item_info != 'clear_item:'.$row_basket_items['bpid']) // { // return('error 100: expected "clear_item:'.$row_basket_items['bpid'].'" but got "'.$basket_item_info.'"'); // } // } // // And un-checkout the basket as well // // Remove the delivery cost from the ledger for this basket // $ledger_status = basket_item_to_ledger(array ( // 'source_type' => 'member', // 'source_key' => $data['member_id'], // 'target_type' => 'internal', // 'target_key' => 'delivery_cost', // 'amount' => 0, // 'text_key' => 'delivery cost', // 'posted_by' => $_SESSION['member_id'], // 'basket_id' => $basket_info['basket_id'], // 'site_id' => $basket_info['site_id'], // 'delivery_id' => $basket_info['delivery_id'], // 'match_keys' => array ('source_type','source_key','target_type','target_key','text_key','basket_id') // )); // } // // Change the checked_out setting on the basket // // Do this last so the update_basket_item will clear ledger items (only if they are in a checked-out state) // if ($initiate_un_checkout) // { // $query = ' // UPDATE '.NEW_TABLE_BASKETS.' // SET checked_out = "0" // WHERE basket_id = "'.mysql_real_escape_string($basket_info['basket_id']).'"'; // $result = mysql_query($query, $connection) or die(debug_print ("ERROR: 892764 ", array ($query,mysql_error()), basename(__FILE__).' LINE '.__LINE__)); // $basket_info['checked_out'] = 0; // } // At this point, all basket information has been updated, so we need to consider any changes to the ledger. // * messages link a message to this transaction // * post_even_if_zero 'YES' will delete the transaction is zero and a singleton // NEED TO ADD PAYPAL SURCHARGE CALCULATION // Return the new (possibly changed) basket_info array return $basket_info; }
function update_basket_item(array $data) { // debug_print ('INFO: Update Basket', $data); global $connection; // $member_id_you = $_SESSION['member_id']; $producer_id_you = $_SESSION['producer_id_you']; // Allow admins to override certain checks if the requested action is not for themselves $admin_override_not_set = false; if ($member_id_you == $data['member_id'] || !CurrentMember::auth_type('cashier')) { $admin_override_not_set = true; } // Set flags for needed validations and operations switch ($data['action']) { case 'set_quantity': $test_for_valid_product = true; $test_for_customer_privilege = true; $test_for_membership_privilege = true; $test_customer_ordering_window = true; $test_product_availability = true; $test_for_producer_privilege = true; $initiate_basket_item = true; $initiate_change_quantity = true; $initiate_set_message_to_producer = true; break; case 'set_message_to_producer': $test_for_valid_product = true; $test_customer_ordering_window = true; $initiate_set_message_to_producer = true; break; case 'set_outs': $test_for_valid_product = true; $test_for_producer_privilege = true; $test_basket_item_exists = true; $test_producer_update_window = true; $initiate_change_outs = true; break; case 'set_weight': $test_for_valid_product = true; $test_for_producer_privilege = true; $test_basket_item_exists = true; $test_producer_update_window = true; $initiate_change_weight = true; break; case 'checkout': $test_for_valid_product = true; $test_for_membership_privilege = true; $test_customer_ordering_window = true; $test_basket_item_exists = true; $initiate_set_message_to_producer = true; $initiate_synch_ledger = true; break; case 'set_all_producer': $test_for_valid_product = true; $test_basket_item_exists = true; $test_for_producer_privilege = true; $test_producer_update_window = true; $initiate_change_outs = true; $initiate_change_weight = true; break; case 'set_everything': $test_for_valid_product = true; $test_basket_item_exists = true; $test_customer_ordering_window = true; $initiate_change_quantity = true; $initiate_change_outs = true; $initiate_clear_weight = true; $initiate_clear_item = true; $initiate_set_message_to_producer = true; break; case 'clear_item': // Used when un_checking_out $test_for_valid_product = true; $test_basket_item_exists = true; $test_customer_ordering_window = true; $data['quantity'] = '0'; $data['out_of_stock'] = '0'; $data['weight'] = '0'; $initiate_change_quantity = true; $initiate_change_outs = true; $initiate_clear_weight = true; $initiate_clear_item = true; break; case 'synch_ledger': // Used when checking_out $test_for_valid_product = true; $test_basket_item_exists = true; $test_for_membership_privilege = true; $test_customer_ordering_window = true; $test_basket_item_exists = true; $initiate_synch_ledger = true; break; case 'producer_synch_ledger': // Used when checking_out $test_for_valid_product = true; $test_basket_item_exists = true; $test_for_producer_privilege = true; $test_producer_update_window = true; $initiate_synch_ledger = true; break; default: return 'Unexpected request ' . $action; break; } // Check if the product exists, regardless of $admin_override_not_set if ($test_for_valid_product) { $product_info = get_product($data['product_id'], $data['product_version'], $data['pvid']); if (!is_array($product_info)) { return 'Product not found in database'; } } // Get information about the basket for this member // This needs to be done before the availability check $basket_info = get_basket($data['member_id'], $data['delivery_id']); // See if we already have this basket_item if (is_array($basket_info)) { $basket_item_info = get_basket_item($basket_info['basket_id'], $data['product_id']); } else { return 'Basket does not exist'; } // Check for basket item if ($test_basket_item_exists && !is_array($basket_item_info)) { return 'Basket item does not exist'; } // Check if the basket is locked if ($basket_info['locked'] == 1) { return 'Basket is locked'; } // Check if this producer is permitted and enabled to sell if ($test_for_producer_privilege && $admin_override_not_set) { $producer_info = get_producer($product_info['producer_id']); if ($producer_info['unlisted_producer'] > 0 || $producer_info['pending'] == 1) { return 'Producer is restricted from selling'; } } // Check if the customer is allowed to purchase this product if ($test_for_customer_privilege && $admin_override_not_set) { $member_info = get_member($data['member_id']); $member_auth_type_array = explode(',', $member_info['auth_type']); // $product_info['listing_auth_type'] contains the *necessary* auth_type to buy this product // and $member_auth_type_array contains all the members' allowable auth_types // listing_auth_types archived and unlisted are not allowed for members, so can never be ordered if (!is_array($member_auth_type_array) || !in_array($product_info['listing_auth_type'], $member_auth_type_array)) { return 'Incorrect privilege to purchase requested product'; } } // Check that the member is not pending or discontinued if ($test_for_membership_privilege && $admin_override_not_set) { if ($member_info['pending'] == 1 || $member_info['membership_discontinued'] == 1) { return 'Incorrect privilege to order'; } } // Check if shopping is closed for this order if ($test_customer_ordering_window && $admin_override_not_set) { if (ActiveCycle::ordering_window() == 'closed') { return 'Customer ordering period is not in effect'; } } // Check if the product can be delivered to this site_id if ($test_product_availability && $admin_override_not_set) { if ($producer_info['available_site_ids'] != '' && !in_array($basket_info['site_id'], explode(',', $producer_info['available_site_ids']))) { return 'Producer does not sell at this location'; } } // Check if producer activity is taking place within the producer update window if ($test_producer_update_window && $producer_id_you && $admin_override_not_set) { if (ActiveCycle::producer_update_window() == 'closed') { return 'Producer update window is closed'; } } // Create an empty basket item if one does not already exist if ($initiate_basket_item && !is_array($basket_item_info)) { $query = ' INSERT INTO ' . NEW_TABLE_BASKET_ITEMS . ' ( /* bpid, */ basket_id, product_id, product_version, quantity, total_weight, product_fee_percent, subcategory_fee_percent, producer_fee_percent, taxable, out_of_stock, future_delivery, future_delivery_type, date_added ) SELECT ' . mysql_real_escape_string($basket_info['basket_id']) . ' AS basket_id, product_id, product_version, "0" AS quantity, "0" AS total_weight, product_fee_percent, subcategory_fee_percent, producer_fee_percent, taxable, "0" AS out_of_stock, future_delivery, future_delivery_type, NOW() AS date_added FROM ' . NEW_TABLE_PRODUCTS . ' LEFT JOIN ' . TABLE_SUBCATEGORY . ' USING(subcategory_id) LEFT JOIN ' . TABLE_CATEGORY . ' USING(category_id) LEFT JOIN ' . TABLE_PRODUCER . ' USING(producer_id) WHERE product_id = "' . mysql_real_escape_string($product_info['product_id']) . '" AND product_version = "' . mysql_real_escape_string($product_info['product_version']) . '"'; $result = mysql_query($query, $connection) or die(debug_print("ERROR: 748032 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__)); // Now get the basket information we just posted $basket_item_info = get_basket_item($basket_info['basket_id'], $data['product_id']); } // Update the quantity for this basket_item and adjust inventory accordingly if ($initiate_change_quantity) { $old_requested_quantity = $basket_item_info['quantity']; $old_out_of_stock = $basket_item_info['out_of_stock']; // The following code is built around adding/subtracting [quantity], so we will first adjust // the input to fit that method. If $data['quantity'] is like "+1" or "-2" then increment/decrement if (preg_match('/^([\\+\\-])(\\d+)$/', $data['quantity'], $matches)) { if ($matches[1] == '+') { $data['quantity'] = $matches[2]; } elseif ($matches[1] == '-') { $data['quantity'] = 0 - $matches[2]; } else { return 'Unexpected result 789830'; } } elseif (preg_match('/^(\\d+)$/', $data['quantity'], $matches)) { $data['quantity'] = $matches[1] - $old_requested_quantity; // Amount to increase the basket by } else { return 'Unexpected result 785932'; } // If this is an inventory-controlled item if ($product_info['inventory_id']) { $old_actual_quantity = $old_requested_quantity - $old_out_of_stock; // Note that available_inventory is the number of inventory_pull units available for this // particular product and might actually leave a few inventory items remaining. $available_inventory = floor($product_info['inventory_quantity'] / $product_info['inventory_pull']); $inventory_reduction = 0; // Just for sanity, make sure the old out_of_stock is not more than the old_requested_quantity if ($old_out_of_stock > $old_requested_quantity) { $old_out_of_stock = $old_requested_quantity; } // Add the request, no matter what (unless the quantity goes negative) $new_requested_quantity = $old_requested_quantity + $data['quantity']; // If we brought the requested quantity in the basket down to zero if ($new_requested_quantity <= 0) { // then set the new_requested_quantity to [all of it] $data['quantity'] = 0 - $old_requested_quantity; $new_requested_quantity = 0; // and set out_of_stock to zero (empty the basket completely) $new_out_of_stock = 0; } else { // We will begin by considering all of the new quantity as "out" $new_out_of_stock = $old_out_of_stock + $data['quantity']; } // At this point, the new_requested_quantity is correct, but we might // have set the new_out_of_stock incorrectly, so we will adjust that // according to the inventory available // Check if there is enough inventory to cover our entire out_of_stock request if ($available_inventory > $new_out_of_stock) { $inventory_reduction = $new_out_of_stock; $new_out_of_stock = 0; } else { $inventory_reduction = $available_inventory; // all of it $new_out_of_stock = $new_out_of_stock - $inventory_reduction; } } else { // If this somehow changed, then clear the out_of_stock setting $new_out_of_stock = 0; $inventory_reduction = 0; // Add the new requested quantity $new_requested_quantity = $old_requested_quantity + $data['quantity']; // And make sure it isn't less than zero if ($new_requested_quantity < 0) { $new_requested_quantity = 0; } } // Set these variables for use later $basket_item_info['quantity'] = $new_requested_quantity; $basket_item_info['out_of_stock'] = $new_out_of_stock; // Update the basket quantity and out_of_stock $query = ' UPDATE ' . NEW_TABLE_BASKET_ITEMS . ' SET quantity = "' . mysql_real_escape_string($new_requested_quantity) . '", out_of_stock = "' . mysql_real_escape_string($new_out_of_stock) . '" WHERE bpid = "' . mysql_real_escape_string($basket_item_info['bpid']) . '"'; $result = mysql_query($query, $connection) or die(debug_print("ERROR: 842075 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__)); // And update the inventory amount if ($inventory_reduction != 0) { // This does work with negative numbers for $new_requested_quantity $query = ' UPDATE ' . TABLE_INVENTORY . ' SET quantity = quantity + "' . mysql_real_escape_string($new_requested_quantity * $product_info['inventory_pull']) . '" WHERE inventory_id = "' . mysql_real_escape_string($product_info['inventory_id']) . '"'; $result = mysql_query($query, $connection) or die(debug_print("ERROR: 902784 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__)); } } else { $new_requested_quantity = $basket_item_info['quantity']; } // Change the "out" setting on this item if ($initiate_change_outs) { // If $data['out_of_stock'] is like "+1" or "-2" then increment/decrement if (preg_match('/^([\\+\\-])(\\d+)$/', $data['out_of_stock'], $matches)) { // Increase out_of_stock :: decreases actual order quantity if ($matches[1] == '+') { $new_out_of_stock = $basket_item_info['out_of_stock'] + $matches[2]; } elseif ($matches[1] == '-') { $new_out_of_stock = $basket_item_info['out_of_stock'] - $matches[2]; } else { return 'Unexpected result 578932'; } } elseif (preg_match('/^(\\d+)$/', $data['out_of_stock'], $matches)) { $new_out_of_stock = $matches[1]; } else { return 'Unexpected result 874042'; } // Make sure we have not outed more than the total quantity in the basket if ($new_out_of_stock > $basket_item_info['quantity']) { $new_out_of_stock = $basket_item_info['quantity']; } // Make sure we have not outed a negative number if ($new_out_of_stock < 0) { $new_out_of_stock = 0; } // Update the basket_item with the new quantities $query = ' UPDATE ' . NEW_TABLE_BASKET_ITEMS . ' SET out_of_stock = "' . mysql_real_escape_string($new_out_of_stock) . '" WHERE bpid = "' . mysql_real_escape_string($basket_item_info['bpid']) . '"'; $result = mysql_query($query, $connection) or die(debug_print("ERROR: 784303 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__)); } // Set a basket_item message for this item if ($initiate_set_message_to_producer && $basket_item_info['bpid'] && is_array($data['messages'])) { foreach ($data['messages'] as $message_type => $message) { // If there is a message, then add the message or replace an existing one if (strlen($message) > 0) { // Use [0]:orphaned message in case the description is not found $query_post_message = ' REPLACE INTO ' . NEW_TABLE_MESSAGES . ' SET message = "' . mysql_real_escape_string($message) . '", message_type_id = COALESCE(( SELECT message_type_id FROM ' . NEW_TABLE_MESSAGE_TYPES . ' WHERE key1_target = "basket_items.bpid" AND description = "' . mysql_real_escape_string($message_type) . '" LIMIT 1 ) ,0), referenced_key1 = "' . mysql_real_escape_string($basket_item_info['bpid']) . '"'; } else { $query_post_message = ' DELETE FROM ' . NEW_TABLE_MESSAGES . ' WHERE message_type_id = COALESCE(( SELECT message_type_id FROM ' . NEW_TABLE_MESSAGE_TYPES . ' WHERE key1_target = "basket_items.bpid" AND description = "' . mysql_real_escape_string($message_type) . '" LIMIT 1 ) ,0) AND referenced_key1 = "' . mysql_real_escape_string($basket_item_info['bpid']) . '"'; } $result_post_message = mysql_query($query_post_message, $connection) or die(debug_print("ERROR: 789021 ", array($query_post_message, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__)); } } // Clear any weight that might have been set for this item if ($initiate_clear_weight && $basket_item_info['random_weight']) { $total_weight = $data['weight']; $query = ' UPDATE ' . NEW_TABLE_BASKET_ITEMS . ' SET total_weight = "' . mysql_real_escape_string($total_weight) . '" WHERE bpid = "' . mysql_real_escape_string($basket_item_info['bpid']) . '"'; $result = mysql_query($query, $connection) or die(debug_print("ERROR: 890254 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__)); } // Update the weight for this item if ($initiate_change_weight && $basket_item_info['random_weight']) { $total_weight = $data['weight']; if ($new_requested_quantity - $new_out_of_stock) { $average_weight = $data['weight'] / ($new_requested_quantity - $new_out_of_stock); // // Check for weight in specified range (admins may override this check) // if (($average_weight < $basket_item_info['minimum_weight'] || // $average_weight > $basket_item_info['maximum_weight']) && // $admin_override_not_set) // { // return ('Random-weight item outside declared weight range'); // } } else { $average_weight = 0; $total_weight = 0; } $query = ' UPDATE ' . NEW_TABLE_BASKET_ITEMS . ' SET total_weight = "' . mysql_real_escape_string($total_weight) . '" WHERE bpid = "' . mysql_real_escape_string($basket_item_info['bpid']) . '"'; $result = mysql_query($query, $connection) or die(debug_print("ERROR: 520561 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__)); } if ($initiate_synch_ledger == true) { // If the requested action is just to synch the ledger, then we need to preset these values: $new_out_of_stock = $basket_item_info['out_of_stock']; $new_requested_quantity = $basket_item_info['quantity']; $product_tax_basis = 0; $fee_tax_basis = 0; // And make sure the basket is also checked out $test_info = update_basket(array('action' => 'set_checkout', 'basket_id' => $basket_info['basket_id'])); // Sync the checked_out field $basket_info['checked_out'] = $test_info['checked_out']; $query = ' UPDATE ' . NEW_TABLE_BASKET_ITEMS . ' SET checked_out = "1" WHERE bpid = "' . mysql_real_escape_string($basket_item_info['bpid']) . '"'; $result = mysql_query($query, $connection) or die(debug_print("ERROR: 893020 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__)); // Sync the checked_out field $basket_item_info['checked_out'] = "1"; } // If the quantity has become zero (i.e. out_of_stock == requested_quantity) then we don't want to // charge people for random weight items -- even if a weight is entered -- so clobber the weight if ($new_out_of_stock == $new_requested_quantity) { // i.e. There are no items in stock... then multiply certain costs by zero $basket_item_info['total_weight'] = 0; } // At this point, all basket_item information has been set, so we need to consider // changes in the ledger. This is done for any/all changes, so not conditional // except for baskets that are not checked-out. if ($basket_info['checked_out'] != 0) { // If this product is configured with an extra_charge, then post it if ($product_info['extra_charge'] != 0) { $extra_charge = ($new_requested_quantity - $new_out_of_stock) * $product_info['extra_charge']; // Assumption is that extra_charges are passed through to the producer // Should they/could they be held by the co-op??? $ledger_status = basket_item_to_ledger(array('transaction_group_id' => $data['transaction_group_id'], 'source_type' => 'member', 'source_key' => $data['member_id'], 'target_type' => 'producer', 'target_key' => $product_info['producer_id'], 'amount' => $extra_charge, 'text_key' => 'extra charge', 'posted_by' => $_SESSION['member_id'], 'basket_id' => $basket_info['basket_id'], 'bpid' => $basket_item_info['bpid'], 'site_id' => $basket_info['site_id'], 'delivery_id' => $basket_info['delivery_id'], 'pvid' => $product_info['pvid'], 'match_keys' => array('text_key', 'bpid'))); } // If this product is configured with a regular cost, then post it if ($product_info['unit_price'] != 0) { if ($product_info['random_weight'] == 1) { $total_price = $product_info['unit_price'] * $basket_item_info['total_weight']; $text_key = 'weight cost'; } elseif ($product_info['random_weight'] == 0) { $total_price = $product_info['unit_price'] * ($new_requested_quantity - $new_out_of_stock); $text_key = 'quantity cost'; } else { return 'Unexpected result 579210'; } // Start accumulating basis for taxation $product_tax_basis += $total_price; // Write the transaction to the ledger $ledger_status = basket_item_to_ledger(array('transaction_group_id' => $data['transaction_group_id'], 'source_type' => 'member', 'source_key' => $data['member_id'], 'target_type' => 'producer', 'target_key' => $product_info['producer_id'], 'amount' => $total_price, 'text_key' => $text_key, 'posted_by' => $_SESSION['member_id'], 'basket_id' => $basket_info['basket_id'], 'bpid' => $basket_item_info['bpid'], 'site_id' => $basket_info['site_id'], 'delivery_id' => $basket_info['delivery_id'], 'pvid' => $product_info['pvid'], 'match_keys' => array('text_key', 'bpid'))); } // If there is a product fee, post it if ($basket_item_info['product_fee_percent'] != 0 && PAYS_PRODUCT_FEE != 'nobody') { $product_adjust_amount = $basket_item_info['product_fee_percent'] * $total_price / 100; if (PAYS_PRODUCT_FEE == 'customer') { $source_type = 'member'; $source_key = $data['member_id']; // Accumulate basis for taxation $fee_tax_basis += $product_adjust_amount; } elseif (PAYS_PRODUCT_FEE == 'producer') { $source_type = 'producer'; $source_key = $product_info['producer_id']; } else { return 'No designated payee for product fee'; } // Post product fee to the ledger for each product $ledger_status = basket_item_to_ledger(array('transaction_group_id' => $data['transaction_group_id'], 'source_type' => $source_type, 'source_key' => $source_key, 'target_type' => 'internal', 'target_key' => 'product_fee', 'amount' => $product_adjust_amount, 'text_key' => 'product fee', 'posted_by' => $_SESSION['member_id'], 'basket_id' => $basket_info['basket_id'], 'bpid' => $basket_item_info['bpid'], 'site_id' => $basket_info['site_id'], 'delivery_id' => $basket_info['delivery_id'], 'pvid' => $product_info['pvid'], 'match_keys' => array('text_key', 'bpid'))); } // If there is a subcategory fee, post it if ($basket_item_info['subcategory_fee_percent'] != 0 && PAYS_SUBCATEGORY_FEE != 'nobody') { $subcategory_adjust_amount = $basket_item_info['subcategory_fee_percent'] * $total_price / 100; if (PAYS_SUBCATEGORY_FEE == 'customer') { $source_type = 'member'; $source_key = $data['member_id']; // Accumulate basis for taxation $fee_tax_basis += $subcategory_adjust_amount; } elseif (PAYS_SUBCATEGORY_FEE == 'producer') { $source_type = 'producer'; $source_key = $product_info['producer_id']; } else { return 'No designated payee for subcategory fee'; } // Post subcategory fee to the ledger for each product $ledger_status = basket_item_to_ledger(array('transaction_group_id' => $data['transaction_group_id'], 'source_type' => $source_type, 'source_key' => $source_key, 'target_type' => 'internal', 'target_key' => 'subcategory_fee', 'amount' => $subcategory_adjust_amount, 'text_key' => 'subcategory fee', 'posted_by' => $_SESSION['member_id'], 'basket_id' => $basket_info['basket_id'], 'bpid' => $basket_item_info['bpid'], 'site_id' => $basket_info['site_id'], 'delivery_id' => $basket_info['delivery_id'], 'pvid' => $product_info['pvid'], 'match_keys' => array('text_key', 'bpid'))); } // If there is a producer fee, post it if ($basket_item_info['producer_fee_percent'] != 0 && PAYS_PRODUCER_FEE != 'nobody') { $producer_adjust_amount = $basket_item_info['producer_fee_percent'] * $total_price / 100; if (PAYS_PRODUCER_FEE == 'customer') { $source_type = 'member'; $source_key = $data['member_id']; // Accumulate basis for taxation $fee_tax_basis += $producer_adjust_amount; } elseif (PAYS_PRODUCER_FEE == 'producer') { $source_type = 'producer'; $source_key = $product_info['producer_id']; } else { return 'No designated payee for producer fee'; } // Post producer fee to the ledger for each product $ledger_status = basket_item_to_ledger(array('transaction_group_id' => $data['transaction_group_id'], 'source_type' => $source_type, 'source_key' => $source_key, 'target_type' => 'internal', 'target_key' => 'producer_fee', 'amount' => $producer_adjust_amount, 'text_key' => 'producer fee', 'posted_by' => $_SESSION['member_id'], 'basket_id' => $basket_info['basket_id'], 'bpid' => $basket_item_info['bpid'], 'site_id' => $basket_info['site_id'], 'delivery_id' => $basket_info['delivery_id'], 'pvid' => $product_info['pvid'], 'match_keys' => array('text_key', 'bpid'))); } // If there is a customer fee, post it if ($basket_info['customer_fee_percent'] != 0 && PAYS_CUSTOMER_FEE != 'nobody') { $customer_adjust_amount = $basket_info['customer_fee_percent'] * $total_price / 100; if (PAYS_CUSTOMER_FEE == 'customer') { $source_type = 'member'; $source_key = $data['member_id']; // Accumulate basis for taxation $fee_tax_basis += $customer_adjust_amount; } elseif (PAYS_CUSTOMER_FEE == 'producer') { $source_type = 'producer'; $source_key = $product_info['producer_id']; } else { return 'No designated payee for customer fee'; } // Post customer fee to the ledger for each product $ledger_status = basket_item_to_ledger(array('transaction_group_id' => $data['transaction_group_id'], 'source_type' => $source_type, 'source_key' => $source_key, 'target_type' => 'internal', 'target_key' => 'customer_fee', 'amount' => $customer_adjust_amount, 'text_key' => 'customer fee', 'posted_by' => $_SESSION['member_id'], 'basket_id' => $basket_info['basket_id'], 'bpid' => $basket_item_info['bpid'], 'site_id' => $basket_info['site_id'], 'delivery_id' => $basket_info['delivery_id'], 'pvid' => $product_info['pvid'], 'match_keys' => array('text_key', 'bpid'))); } // If this is a taxable item, then collect all the requisite taxes if ($basket_item_info['taxable'] == 1 || COOP_FEE_IS_TAXED == 'always') { // Get the tax information... $query = ' SELECT tax_id, region_code, region_type, tax_percent FROM ' . NEW_TABLE_TAX_RATES . ' WHERE postal_code = "' . mysql_real_escape_string($basket_info['delivery_postal_code']) . '" AND order_id_start <= "' . mysql_real_escape_string($data['delivery_id']) . '" AND ( order_id_stop >= "' . mysql_real_escape_string($data['delivery_id']) . '" OR order_id_stop = "0" )'; $result = mysql_query($query, $connection) or die(debug_print("ERROR: 890236 ", array($query, mysql_error()), basename(__FILE__) . ' LINE ' . __LINE__)); while ($row = mysql_fetch_array($result)) { $text_key = $row['region_type'] . ' tax'; // e.g. 'county tax' // Just tax the item and not the fees if (COOP_FEE_IS_TAXED == 'never') { $tax_amount = $row['tax_percent'] * $product_tax_basis / 100; } elseif (COOP_FEE_IS_TAXED == 'on taxable items' || COOP_FEE_IS_TAXED == 'always' && $basket_item_info['taxable'] == 1) { $tax_amount = $row['tax_percent'] * ($product_tax_basis + $fee_tax_basis) / 100; } elseif (COOP_FEE_IS_TAXED == 'always' && $basket_item_info['taxable'] == 0) { $tax_amount = $row['tax_percent'] * $fee_tax_basis / 100; } $ledger_status = basket_item_to_ledger(array('transaction_group_id' => $data['transaction_group_id'], 'source_type' => 'member', 'source_key' => $data['member_id'], 'target_type' => 'tax', 'target_key' => $row['tax_id'], 'amount' => $tax_amount, 'text_key' => $text_key, 'posted_by' => $_SESSION['member_id'], 'basket_id' => $basket_info['basket_id'], 'bpid' => $basket_item_info['bpid'], 'site_id' => $basket_info['site_id'], 'delivery_id' => $basket_info['delivery_id'], 'pvid' => $product_info['pvid'], 'match_keys' => array('text_key', 'bpid'))); } } } return $basket_item_info; }
$blockpage = new blockpage($PAGE, $OUTPUT, 'iomad_commerce', 'block', 'review'); $blockpage->setup(); require_login(null, false); // Adds to $PAGE, creates $OUTPUT. $context = $PAGE->context; // Don't do the pre_order_review_processing on postback. if (array_key_exists('submitbutton', $_POST)) { $basket = get_basket(); $pp = get_payment_provider_instance($basket->checkout_method); } else { // Add the rest of the stuff to the basket invoice. $basket = get_basket(); $pp = get_payment_provider_instance($basket->checkout_method); $pp->pre_order_review_processing(); // Refresh basket info after processing. $basket = get_basket(); } $mform = new confirmation_form($PAGE->url, $basket, $pp); $mform->set_data($basket); $error = ''; if ($mform->is_cancelled()) { redirect('basket.php'); } else { if ($data = $mform->get_data()) { $error = $pp->confirm(); if (!$error) { redirect('confirm.php?u=' . $basket->reference); } } } $blockpage->display_header();
<?php // подключение библиотек require "inc/lib.inc.php"; require "inc/db.inc.php"; ?> <html> <head> <meta charset="UTF-8"> <title>Корзина пользователя</title> </head> <body> <h1>Ваша корзина</h1> <?php $goods = get_basket(); if (!is_array($goods)) { echo 'Error enter goods'; exit; } if ($goods) { echo '<p><a href="catalog.php">Незад до каталогу</a></p>'; } else { echo '<p>Ваша корзина пуста вернутися до <a href="catalog.php">каталогу</a></p>'; } ?> <table border="1" cellpadding="5" cellspacing="0" width="100%"> <tr> <th>N п/п</th> <th>Название</th> <th>Автор</th> <th>Год издания</th>