$requiredCols[] = 'title'; $requiredCols[] = 'www'; foreach ($requiredCols as $requiredCol) { if (!isset($user[$requiredCol])) { $user[$requiredCol] = ''; } } if (!isset($user['tx_multishop_source_id']) && $user['uid']) { $user['tx_multishop_source_id'] = $user['uid']; } $user = mslib_befe::rmNullValuedKeys($user); $query = $GLOBALS['TYPO3_DB']->INSERTquery('fe_users', $user); $res = $GLOBALS['TYPO3_DB']->sql_query($query); $uid = $GLOBALS['TYPO3_DB']->sql_insert_id(); if ($uid) { $user_check = mslib_fe::getUser($uid); $name = array(); if ($user['company'] != '') { $name[] = $user['company']; } if ($user['name'] != '' and !in_array($user['name'], $name)) { $name[] = $user['name']; } if ($user['email'] != '' and !in_array($user['email'], $name)) { $name[] = 'email: ' . $user['email']; } $content .= implode(" / ", $name) . ' has been added.<br />'; // custom hook that can be controlled by third-party // plugin if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/scripts/admin_pages/admin_customer_import.php']['msCustomerImporterInsertUserPostHook'])) { $params = array('user' => &$user, 'item' => &$item, 'user_check' => &$user_check, 'prefix_source_name' => $this->post['prefix_source_name']);
} if ($row['is_checkout']) { // lets find out how long the user did to finish the checkout $str2 = "SELECT crdate FROM tx_multishop_cart_contents c where c.session_id='" . $row['session_id'] . "' and c.id < '" . $row['id'] . "' and page_uid='" . $this->shop_pid . "' order by c.id asc limit 1"; $qry2 = $GLOBALS['TYPO3_DB']->sql_query($str2); $row2 = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry2); $time = $row['crdate'] - $row2['crdate']; if ($time >= 60) { $time_label = round($time / 60) . ' minutes'; } else { $time_label = $time . ' seconds'; } $tr_rows[] = '<th class="text-right" width="100">' . $this->pi_getLL('time_needed_to_finish_checkout') . '</th><td>' . $time_label . '</td>'; } else { if ($row['customer_id']) { $user = mslib_fe::getUser($row['customer_id']); $cart['user'] = $user; } } if ($cart['user']['username']) { $tr_rows[] = '<th class="text-right" width="100">' . $this->pi_getLL('username') . '</th><td>' . $cart['user']['username'] . '</td>'; } if ($cart['user']['first_name']) { $tr_rows[] = '<th class="text-right" width="100">' . $this->pi_getLL('name') . '</th><td>' . $cart['user']['first_name'] . ' ' . $cart['user']['middle_name'] . ' ' . $cart['user']['last_name'] . '</td>'; } if ($cart['user']['company']) { $tr_rows[] = '<th class="text-right" width="100">' . $this->pi_getLL('company') . '</th><td>' . $cart['user']['company'] . '</td>'; } if ($cart['user']['telephone']) { $tr_rows[] = '<th class="text-right" width="100">' . $this->pi_getLL('telephone') . '</th><td>' . $cart['user']['telephone'] . '</td>'; }
public function loginAsUser($uid, $section = '') { if (!is_numeric($uid)) { return false; } $user = mslib_fe::getUser($uid); if ($user['uid']) { $GLOBALS['TSFE']->fe_user->logoff(); $GLOBALS['TSFE']->loginUser = 0; $fe_user = $GLOBALS['TSFE']->fe_user; $fe_user->createUserSession(array('uid' => $uid)); $fe_user->user = $fe_user->getRawUserByUid($uid); $fe_user->fetchGroupData(); $GLOBALS['TSFE']->loginUser = 1; /* * Old style, dont use this anymore. use above approach which uses the $uid // auto login the user $loginData=array( 'uname'=>$user['username'], //usernmae 'uident'=>$user['password'], //password 'status'=>'login' ); $GLOBALS['TSFE']->fe_user->checkPid=0; //do not use a particular pid $info=$GLOBALS['TSFE']->fe_user->getAuthInfoArray(); $user=$GLOBALS['TSFE']->fe_user->fetchUserRecord($info['db_user'], $loginData['uname']); $GLOBALS['TSFE']->fe_user->createUserSession($user); */ // auto login the user if (is_numeric($this->conf['login_as_customer_target_pid'])) { $targetPid = $this->conf['login_as_customer_target_pid']; } else { $targetPid = $this->shop_pid; } $redirect_url = $this->FULL_HTTP_URL . mslib_fe::typolink($targetPid); //hook to let other plugins further manipulate the redirect link if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.mslib_befe.php']['loginAsUserRedirectLinkPreProc'])) { $params = array('user' => $user, 'redirect_url' => &$redirect_url, 'section' => &$section); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.mslib_befe.php']['loginAsUserRedirectLinkPreProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } } if ($redirect_url) { header("Location: " . $redirect_url); } exit; } }
<?php if (!defined('TYPO3_MODE')) { die('Access denied.'); } //add order if ($this->post['proceed_order']) { $unique_id = md5($this->post['first_name'] . $this->post['last_name'] . $this->post['company'] . $this->post['tx_multishop_pi1']['telephone']); if ($this->post['customer_id']) { $user = mslib_fe::getUser($this->post['customer_id']); if ($user['uid']) { $customer_id = $user['uid']; $this->post = array_merge($this->post, $user); $this->post['tx_multishop_pi1']['telephone'] = $this->post['telephone']; } } else { $str = "SELECT uid from fe_users where (username='******')"; $qry = $GLOBALS['TYPO3_DB']->sql_query($str); if ($GLOBALS['TYPO3_DB']->sql_num_rows($qry) > 0) { // use current account $row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry); $customer_id = $row['uid']; } } if (!$customer_id) { $insertArray = array(); $insertArray['page_uid'] = $this->shop_pid; $insertArray['company'] = $this->post['company']; $insertArray['name'] = $this->post['first_name'] . ' ' . $this->post['middle_name'] . ' ' . $this->post['last_name']; $insertArray['name'] = preg_replace('/\\s+/', ' ', $insertArray['name']); $insertArray['first_name'] = $this->post['first_name'];
<?php if (!defined('TYPO3_MODE')) { die('Access denied.'); } if ($this->ADMIN_USER) { $jsonData = array(); if (is_numeric($this->post['tx_multishop_pi1']['customer_id'])) { $customer = mslib_fe::getUser($this->post['tx_multishop_pi1']['customer_id']); if ($customer['uid']) { $actionButtons = array(); if ($customer['email']) { $actionLink = 'mailto:' . $customer['email']; $actionButtons['email'] = '<a href="' . $actionLink . '" class="btn btn-xs btn-default"><i class="fa fa-envelope-o"></i> ' . $this->pi_getLL('email') . '</a>'; } if ($customer['telephone']) { $actionLink = 'callto:' . $customer['telephone']; $actionButtons['call'] = '<a href="' . $actionLink . '" class="btn btn-xs btn-default"><i class="fa fa-phone-square"></i> ' . $this->pi_getLL('call') . '</a>'; } $address = array(); $address[] = rawurlencode($customer['address']); $address[] = rawurlencode($customer['zip']); $address[] = rawurlencode($customer['city']); $address[] = rawurlencode($customer['country']); $actionLink = 'http://maps.google.com/maps?daddr=' . implode('+', $address); $actionButtons['travel_guide'] = '<a href="' . $actionLink . '" rel="nofollow" target="_blank" class="btn btn-xs btn-default"><i class="fa fa-map-marker"></i> ' . $this->pi_getLL('travel_guide') . '</a>'; $jsonData['html'] = ''; if ($customer['company']) { $jsonData['html'] .= '<h1>' . $customer['company'] . '</h1>'; } if ($customer['name']) {
function sendCreateAccountConfirmationLetter($customer_id, $password = '') { if (!is_numeric($customer_id)) { return false; } $page = mslib_fe::getCMScontent('email_create_account_confirmation', $GLOBALS['TSFE']->sys_language_uid); if ($page[0]['content']) { $newCustomer = mslib_fe::getUser($customer_id); // loading the email confirmation letter eof // replacing the variables with dynamic values $array1 = array(); $array2 = array(); $array1[] = '###GENDER_SALUTATION###'; $array2[] = mslib_fe::genderSalutation($this->post['gender']); $array1[] = '###BILLING_COMPANY###'; $array2[] = $newCustomer['company']; $array1[] = '###FULL_NAME###'; $array2[] = $newCustomer['name']; $array1[] = '###BILLING_NAME###'; $array2[] = $newCustomer['name']; $array1[] = '###BILLING_FIRST_NAME###'; $array2[] = $newCustomer['first_name']; $array1[] = '###BILLING_LAST_NAME###'; $last_name = $newCustomer['last_name']; if ($newCustomer['middle_name']) { $last_name = $newCustomer['middle_name'] . ' ' . $last_name; } $array2[] = $last_name; $array1[] = '###CUSTOMER_EMAIL###'; $array2[] = $newCustomer['email']; $array1[] = '###BILLING_EMAIL###'; $array2[] = $newCustomer['email']; $array1[] = '###BILLING_ADDRESS###'; $array2[] = $newCustomer['address']; $array1[] = '###BILLING_TELEPHONE###'; $array2[] = $newCustomer['telephone']; $array1[] = '###BILLING_MOBILE###'; $array2[] = $newCustomer['mobile']; $array1[] = '###LONG_DATE###'; // ie woensdag 23 juni, 2010 $long_date = strftime($this->pi_getLL('full_date_format')); $array2[] = $long_date; $array1[] = '###CURRENT_DATE_LONG###'; // ie woensdag 23 juni, 2010 $long_date = strftime($this->pi_getLL('full_date_format')); $array2[] = $long_date; $array1[] = '###STORE_NAME###'; $array2[] = $this->ms['MODULES']['STORE_NAME']; $array1[] = '###CUSTOMER_ID###'; $array2[] = $customer_id; $link = $this->FULL_HTTP_URL . mslib_fe::typolink($this->shop_pid . ',2002', '&tx_multishop_pi1[page_section]=confirm_create_account&tx_multishop_pi1[hash]=' . $newCustomer['tx_multishop_code']); $array1[] = '###LINK###'; $array2[] = '<a href="' . $link . '" rel="noreferrer">' . htmlspecialchars($this->pi_getLL('click_here_to_confirm_registration')) . '</a>'; $array1[] = '###CONFIRMATION_LINK###'; $array2[] = '<a href="' . $link . '" rel="noreferrer">' . htmlspecialchars($this->pi_getLL('click_here_to_confirm_registration')) . '</a>'; $array1[] = '###USERNAME###'; $array2[] = $newCustomer['email']; $array1[] = '###PASSWORD###'; $array2[] = $password; if ($page[0]['content']) { $page[0]['content'] = str_replace($array1, $array2, $page[0]['content']); } if ($page[0]['name']) { $page[0]['name'] = str_replace($array1, $array2, $page[0]['name']); } $user = array(); $user['name'] = $newCustomer['first_name']; $user['email'] = $newCustomer['email']; mslib_fe::mailUser($user, $page[0]['name'], $page[0]['content'], $this->ms['MODULES']['STORE_EMAIL'], $this->ms['MODULES']['STORE_NAME']); return true; } }
function convertCartToOrder($cart) { // var for total amount $tax_separation = array(); $total_price = 0; $order = array(); $address = $cart['user']; // check for NULL, convert to empty string - typo3 v6.x related bug if (is_array($address) && count($address)) { foreach ($address as $key => $val) { if ($val == null || $val == null) { $address[$key] = ''; } } } // if store country is different from customer country and user provided valid VAT id, change VAT rate to zero $this->ms['MODULES']['DISABLE_VAT_RATE'] = 0; if ($this->ms['MODULES']['DISABLE_VAT_FOR_FOREIGN_CUSTOMERS_WITH_COMPANY_VAT_ID'] and $address['tx_multishop_vat_id']) { if (strtolower($address['country']) != strtolower($this->tta_shop_info['country'])) { $this->ms['MODULES']['DISABLE_VAT_RATE'] = 1; } } /* * always use *_tax and *_total_tax_rate, unless need different calc for country/region * WARNING: *_country_* and *_region_* not always have value, depends on the tax ruleset * ----------------------------------------------------------------------------------------- */ $orders_tax['shipping_tax'] = (string) $address['shipping_tax']; $orders_tax['shipping_country_tax'] = (string) $address['shipping_country_tax']; $orders_tax['shipping_region_tax'] = (string) $address['shipping_region_tax']; $orders_tax['shipping_total_tax_rate'] = (string) $address['shipping_total_tax_rate']; $orders_tax['shipping_country_tax_rate'] = (string) $address['shipping_country_tax_rate']; $orders_tax['shipping_region_tax_rate'] = (string) $address['shipping_region_tax_rate']; if ($this->ms['MODULES']['DISABLE_VAT_RATE']) { $orders_tax['shipping_tax'] = 0; $orders_tax['shipping_country_tax'] = 0; $orders_tax['shipping_region_tax'] = 0; $orders_tax['shipping_total_tax_rate'] = 0; $orders_tax['shipping_country_tax_rate'] = 0; $orders_tax['shipping_region_tax_rate'] = 0; } // ---------------------------------------------------------------------------------------- $orders_tax['payment_tax'] = (string) $address['payment_tax']; $orders_tax['payment_country_tax'] = (string) $address['payment_country_tax']; $orders_tax['payment_region_tax'] = (string) $address['payment_region_tax']; $orders_tax['payment_total_tax_rate'] = (string) $address['payment_total_tax_rate']; $orders_tax['payment_country_tax_rate'] = (string) $address['payment_country_tax_rate']; $orders_tax['payment_region_tax_rate'] = (string) $address['payment_region_tax_rate']; if ($this->ms['MODULES']['DISABLE_VAT_RATE']) { $orders_tax['payment_tax'] = 0; $orders_tax['payment_country_tax'] = 0; $orders_tax['payment_region_tax'] = 0; $orders_tax['payment_total_tax_rate'] = 0; $orders_tax['payment_country_tax_rate'] = 0; $orders_tax['payment_region_tax_rate'] = 0; } // ---------------------------------------------------------------------------------------- $grand_total = array(); $grand_total['shipping_tax'] = $orders_tax['shipping_tax']; $grand_total['payment_tax'] = $orders_tax['payment_tax']; $tax_separation[$orders_tax['shipping_total_tax_rate'] * 100]['shipping_tax'] += $orders_tax['shipping_tax']; $tax_separation[$orders_tax['payment_total_tax_rate'] * 100]['payment_tax'] += $orders_tax['payment_tax']; if ($this->ms['MODULES']['DISABLE_VAT_RATE']) { $grand_total['shipping_tax'] = 0; $grand_total['payment_tax'] = 0; $tax_separation[$orders_tax['shipping_total_tax_rate'] * 100]['shipping_tax'] = 0; $tax_separation[$orders_tax['payment_total_tax_rate'] * 100]['payment_tax'] = 0; if (!$this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT']) { $address['shipping_method_costs'] = mslib_fe::taxDecimalCrop($address['shipping_method_costs'], 2, false); $address['payment_method_costs'] = mslib_fe::taxDecimalCrop($address['payment_method_costs'], 2, false); } } // add shipping & payment costs if ($address['shipping_method_costs']) { $grand_total['shipping_cost'] = $address['shipping_method_costs']; $total_price = $total_price + $address['shipping_method_costs']; $tax_separation[$orders_tax['shipping_total_tax_rate'] * 100]['shipping_costs'] = $address['shipping_method_costs']; } if ($address['payment_method_costs']) { $grand_total['payment_cost'] = $address['payment_method_costs']; $total_price = $total_price + $address['payment_method_costs']; $tax_separation[$orders_tax['payment_total_tax_rate'] * 100]['payment_costs'] = $address['payment_method_costs']; } $customer_id = ''; // first the account if ($GLOBALS['TSFE']->fe_user->user['uid']) { $customer_id = $GLOBALS['TSFE']->fe_user->user['uid']; } else { $tmp_user = mslib_fe::getUser($address['email'], 'email'); if ($tmp_user['uid']) { $customer_id = $tmp_user['uid']; } } //hook to let other plugins further manipulate the create table query if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_user.php']['convertCartToOrderGetCustomerIdPreProc'])) { $params = array('address' => &$address, 'cart' => &$cart, 'customer_id' => &$customer_id); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_user.php']['convertCartToOrderGetCustomerIdPreProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } } if (!$customer_id) { // add new account $insertArray = array(); $insertArray['company'] = $address['company']; $insertArray['name'] = $address['first_name'] . ' ' . $address['middle_name'] . ' ' . $address['last_name']; $insertArray['name'] = preg_replace('/\\s+/', ' ', $insertArray['name']); $insertArray['first_name'] = $address['first_name']; $insertArray['middle_name'] = $address['middle_name']; $insertArray['last_name'] = $address['last_name']; $insertArray['username'] = $address['email']; $insertArray['email'] = $address['email']; if (!$address['street_name']) { // fallback for old custom checkouts $insertArray['building'] = $address['building']; $insertArray['street_name'] = $address['address']; $insertArray['address_number'] = $address['address_number']; $insertArray['address_ext'] = $address['address_ext']; $insertArray['address'] = $insertArray['street_name'] . ' ' . $insertArray['address_number'] . ($insertArray['address_ext'] ? '-' . $insertArray['address_ext'] : ''); $insertArray['address'] = preg_replace('/\\s+/', ' ', $insertArray['address']); } else { $insertArray['building'] = $address['building']; $insertArray['street_name'] = $address['street_name']; $insertArray['address_number'] = $address['address_number']; $insertArray['address_ext'] = $address['address_ext']; $insertArray['address'] = $address['address']; } $insertArray['zip'] = $address['zip']; $insertArray['telephone'] = $address['telephone']; $insertArray['city'] = $address['city']; $insertArray['country'] = $address['country']; $insertArray['tx_multishop_code'] = md5(uniqid('', true)); $insertArray['tstamp'] = time(); $insertArray['crdate'] = time(); if (isset($address['tx_multishop_newsletter']) && !empty($address['tx_multishop_newsletter'])) { $insertArray['tx_multishop_newsletter'] = $address['tx_multishop_newsletter']; } else { $insertArray['tx_multishop_newsletter'] = ''; } $insertArray['page_uid'] = $this->shop_pid; if (isset($address['password']) && !empty($address['password'])) { $insertArray['password'] = mslib_befe::getHashedPassword($address['password']); $insertArray['disable'] = 1; } else { $insertArray['password'] = mslib_befe::getHashedPassword(mslib_befe::generateRandomPassword(10)); } $insertArray['usergroup'] = $this->conf['fe_customer_usergroup']; $insertArray['pid'] = $this->conf['fe_customer_pid']; if (isset($this->cookie['HTTP_REFERER']) && !empty($this->cookie['HTTP_REFERER'])) { $insertArray['http_referer'] = $this->cookie['HTTP_REFERER']; } else { $insertArray['http_referer'] = ''; } $insertArray['ip_address'] = $this->server['REMOTE_ADDR']; if ($this->ms['MODULES']['CHECKOUT_DISPLAY_VAT_ID_INPUT'] && !empty($address['tx_multishop_vat_id'])) { $insertArray['tx_multishop_vat_id'] = $address['tx_multishop_vat_id']; } if ($this->ms['MODULES']['CHECKOUT_DISPLAY_COC_ID_INPUT'] && !empty($address['tx_multishop_coc_id'])) { $insertArray['tx_multishop_coc_id'] = $address['tx_multishop_coc_id']; } $insertArray['tx_multishop_quick_checkout'] = 1; if ($address['gender'] == 'm' or $address['gender'] == '0') { $insertArray['gender'] = '0'; } elseif ($address['gender'] == 'f' or $address['gender'] == '1') { $insertArray['gender'] = '1'; } $insertArray = mslib_befe::rmNullValuedKeys($insertArray); $query = $GLOBALS['TYPO3_DB']->INSERTquery('fe_users', $insertArray); $res = $GLOBALS['TYPO3_DB']->sql_query($query); if ($res) { $customer_id = $GLOBALS['TYPO3_DB']->sql_insert_id(); // ADD TT_ADDRESS RECORD $insertArray = array(); $insertArray['tstamp'] = time(); $insertArray['company'] = $address['company']; $insertArray['name'] = $address['first_name'] . ' ' . $address['middle_name'] . ' ' . $address['last_name']; $insertArray['name'] = preg_replace('/\\s+/', ' ', $insertArray['name']); $insertArray['first_name'] = $address['first_name']; $insertArray['middle_name'] = $address['middle_name']; $insertArray['last_name'] = $address['last_name']; $insertArray['email'] = $address['email']; if (!$address['street_name']) { // fallback for old custom checkouts $insertArray['building'] = $address['building']; $insertArray['street_name'] = $address['address']; $insertArray['address_number'] = $address['address_number']; $insertArray['address_ext'] = $address['address_ext']; $insertArray['address'] = $insertArray['street_name'] . ' ' . $insertArray['address_number'] . ($insertArray['address_ext'] ? '-' . $insertArray['address_ext'] : ''); $insertArray['address'] = preg_replace('/\\s+/', ' ', $insertArray['address']); } else { $insertArray['building'] = $address['building']; $insertArray['street_name'] = $address['street_name']; $insertArray['address_number'] = $address['address_number']; $insertArray['address_ext'] = $address['address_ext']; $insertArray['address'] = $address['address']; } $insertArray['zip'] = $address['zip']; $insertArray['phone'] = $address['telephone']; $insertArray['mobile'] = $address['mobile']; $insertArray['city'] = $address['city']; $insertArray['country'] = $address['country']; $insertArray['gender'] = $address['gender']; $insertArray['birthday'] = strtotime($address['birthday']); if ($address['gender'] == 'm') { $insertArray['title'] = 'Mr.'; } else { if ($address['gender'] == 'f') { $insertArray['title'] = 'Mrs.'; } } $insertArray['region'] = $address['state']; $insertArray['pid'] = $this->conf['fe_customer_pid']; $insertArray['page_uid'] = $this->shop_pid; $insertArray['tstamp'] = time(); $insertArray['tx_multishop_address_type'] = 'billing'; $insertArray['tx_multishop_default'] = 1; $insertArray['tx_multishop_customer_id'] = $customer_id; $insertArray = mslib_befe::rmNullValuedKeys($insertArray); $query = $GLOBALS['TYPO3_DB']->INSERTquery('tt_address', $insertArray); $res = $GLOBALS['TYPO3_DB']->sql_query($query); // send out the create account confirmation e-mail if (isset($address['password']) && !empty($address['password'])) { mslib_fe::sendCreateAccountConfirmationLetter($customer_id, $address['password']); } // insert delivery into tt_address if (!$address['different_delivery_address']) { $insertArray = array(); $insertArray['tstamp'] = time(); $insertArray['company'] = $address['company']; $insertArray['name'] = $address['first_name'] . ' ' . $address['middle_name'] . ' ' . $address['last_name']; $insertArray['name'] = preg_replace('/\\s+/', ' ', $insertArray['name']); $insertArray['first_name'] = $address['first_name']; $insertArray['middle_name'] = $address['middle_name']; $insertArray['last_name'] = $address['last_name']; $insertArray['email'] = $address['email']; if (!$address['street_name']) { // fallback for old custom checkouts $insertArray['building'] = $address['building']; $insertArray['street_name'] = $address['address']; $insertArray['address_number'] = $address['address_number']; $insertArray['address_ext'] = $address['address_ext']; $insertArray['address'] = $insertArray['street_name'] . ' ' . $insertArray['address_number'] . ($insertArray['address_ext'] ? '-' . $insertArray['address_ext'] : ''); $insertArray['address'] = preg_replace('/\\s+/', ' ', $insertArray['address']); } else { $insertArray['building'] = $address['building']; $insertArray['street_name'] = $address['street_name']; $insertArray['address_number'] = $address['address_number']; $insertArray['address_ext'] = $address['address_ext']; $insertArray['address'] = $address['address']; } $insertArray['zip'] = $address['zip']; $insertArray['phone'] = $address['telephone']; $insertArray['mobile'] = $address['mobile']; $insertArray['city'] = $address['city']; $insertArray['country'] = $address['country']; $insertArray['gender'] = $address['gender']; $insertArray['birthday'] = strtotime($address['birthday']); if ($address['gender'] == 'm') { $insertArray['title'] = 'Mr.'; } else { if ($address['gender'] == 'f') { $insertArray['title'] = 'Mrs.'; } } $insertArray['region'] = $address['state']; } else { $insertArray = array(); $insertArray['tx_multishop_customer_id'] = $customer_id; $insertArray['tstamp'] = time(); $insertArray['company'] = $address['delivery_company']; $insertArray['name'] = $address['delivery_first_name'] . ' ' . $address['delivery_middle_name'] . ' ' . $address['delivery_last_name']; $insertArray['name'] = preg_replace('/\\s+/', ' ', $insertArray['name']); $insertArray['first_name'] = $address['delivery_first_name']; $insertArray['middle_name'] = $address['delivery_middle_name']; $insertArray['last_name'] = $address['delivery_last_name']; $insertArray['email'] = $address['delivery_email']; if (!$address['delivery_street_name']) { // fallback for old custom checkouts $insertArray['building'] = $address['delivery_building']; $insertArray['street_name'] = $address['delivery_address']; $insertArray['address_number'] = $address['delivery_address_number']; $insertArray['address_ext'] = $address['delivery_address_ext']; $insertArray['address'] = $insertArray['street_name'] . ' ' . $insertArray['address_number'] . ($insertArray['address_ext'] ? '-' . $insertArray['address_ext'] : ''); $insertArray['address'] = preg_replace('/\\s+/', ' ', $insertArray['address']); } else { $insertArray['building'] = $address['delivery_building']; $insertArray['street_name'] = $address['delivery_street_name']; $insertArray['address_number'] = $address['delivery_address_number']; $insertArray['address_ext'] = $address['delivery_address_ext']; $insertArray['address'] = $address['delivery_address']; } $insertArray['zip'] = $address['delivery_zip']; $insertArray['phone'] = $address['delivery_telephone']; $insertArray['mobile'] = $address['delivery_mobile']; $insertArray['city'] = $address['delivery_city']; $insertArray['country'] = $address['delivery_country']; $insertArray['gender'] = $address['delivery_gender']; $insertArray['birthday'] = strtotime($address['delivery_birthday']); if ($address['delivery_gender'] == 'm') { $insertArray['title'] = 'Mr.'; } else { if ($address['delivery_gender'] == 'f') { $insertArray['title'] = 'Mrs.'; } } $insertArray['region'] = $address['delivery_state']; } $insertArray['pid'] = $this->conf['fe_customer_pid']; $insertArray['page_uid'] = $this->shop_pid; $insertArray['tstamp'] = time(); $insertArray['tx_multishop_customer_id'] = $customer_id; $insertArray['tx_multishop_address_type'] = 'delivery'; $insertArray['tx_multishop_default'] = 0; $insertArray = mslib_befe::rmNullValuedKeys($insertArray); $query = $GLOBALS['TYPO3_DB']->INSERTquery('tt_address', $insertArray); $res = $GLOBALS['TYPO3_DB']->sql_query($query); // ADD TT_ADDRESS RECORD EOF //hook to let other plugins further manipulate the create table query if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_user.php']['createUserPostProc'])) { $params = array('customer_id' => &$customer_id); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_user.php']['createUserPostProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } } } } else { // insert tt_address for existing customer if no record found if (!mslib_fe::getFeUserTTaddressDetails($customer_id, 'billing')) { // ADD TT_ADDRESS RECORD $insertArray = array(); $insertArray['tstamp'] = time(); $insertArray['company'] = $address['company']; $insertArray['name'] = $address['first_name'] . ' ' . $address['middle_name'] . ' ' . $address['last_name']; $insertArray['name'] = preg_replace('/\\s+/', ' ', $insertArray['name']); $insertArray['first_name'] = $address['first_name']; $insertArray['middle_name'] = $address['middle_name']; $insertArray['last_name'] = $address['last_name']; $insertArray['email'] = $address['email']; if (!$address['street_name']) { // fallback for old custom checkouts $insertArray['building'] = $address['building']; $insertArray['street_name'] = $address['address']; $insertArray['address_number'] = $address['address_number']; $insertArray['address_ext'] = $address['address_ext']; $insertArray['address'] = $insertArray['street_name'] . ' ' . $insertArray['address_number'] . ($insertArray['address_ext'] ? '-' . $insertArray['address_ext'] : ''); $insertArray['address'] = preg_replace('/\\s+/', ' ', $insertArray['address']); } else { $insertArray['building'] = $address['delivery_building']; $insertArray['street_name'] = $address['street_name']; $insertArray['address_number'] = $address['address_number']; $insertArray['address_ext'] = $address['address_ext']; $insertArray['address'] = $address['address']; } $insertArray['zip'] = $address['zip']; $insertArray['phone'] = $address['telephone']; $insertArray['mobile'] = $address['mobile']; $insertArray['city'] = $address['city']; $insertArray['country'] = $address['country']; $insertArray['gender'] = $address['gender']; $insertArray['birthday'] = strtotime($address['birthday']); if ($address['gender'] == 'm') { $insertArray['title'] = 'Mr.'; } else { if ($address['gender'] == 'f') { $insertArray['title'] = 'Mrs.'; } } $insertArray['region'] = $address['state']; $insertArray['pid'] = $this->conf['fe_customer_pid']; $insertArray['page_uid'] = $this->shop_pid; $insertArray['tstamp'] = time(); $insertArray['tx_multishop_address_type'] = 'billing'; $insertArray['tx_multishop_default'] = 1; $insertArray['tx_multishop_customer_id'] = $customer_id; $insertArray = mslib_befe::rmNullValuedKeys($insertArray); $query = $GLOBALS['TYPO3_DB']->INSERTquery('tt_address', $insertArray); $res = $GLOBALS['TYPO3_DB']->sql_query($query); } if (!mslib_fe::getFeUserTTaddressDetails($customer_id, 'delivery')) { // insert delivery into tt_address if (!$address['different_delivery_address']) { $insertArray = array(); $insertArray['tstamp'] = time(); $insertArray['company'] = $address['company']; $insertArray['name'] = $address['first_name'] . ' ' . $address['middle_name'] . ' ' . $address['last_name']; $insertArray['name'] = preg_replace('/\\s+/', ' ', $insertArray['name']); $insertArray['first_name'] = $address['first_name']; $insertArray['middle_name'] = $address['middle_name']; $insertArray['last_name'] = $address['last_name']; $insertArray['email'] = $address['email']; if (!$address['street_name']) { // fallback for old custom checkouts $insertArray['building'] = $address['building']; $insertArray['street_name'] = $address['address']; $insertArray['address_number'] = $address['address_number']; $insertArray['address_ext'] = $address['address_ext']; $insertArray['address'] = $insertArray['street_name'] . ' ' . $insertArray['address_number'] . ($insertArray['address_ext'] ? '-' . $insertArray['address_ext'] : ''); $insertArray['address'] = preg_replace('/\\s+/', ' ', $insertArray['address']); } else { $insertArray['building'] = $address['building']; $insertArray['street_name'] = $address['street_name']; $insertArray['address_number'] = $address['address_number']; $insertArray['address_ext'] = $address['address_ext']; $insertArray['address'] = $address['address']; } $insertArray['zip'] = $address['zip']; $insertArray['phone'] = $address['telephone']; $insertArray['mobile'] = $address['mobile']; $insertArray['city'] = $address['city']; $insertArray['country'] = $address['country']; $insertArray['gender'] = $address['gender']; $insertArray['birthday'] = strtotime($address['birthday']); if ($address['gender'] == 'm') { $insertArray['title'] = 'Mr.'; } else { if ($address['gender'] == 'f') { $insertArray['title'] = 'Mrs.'; } } $insertArray['region'] = $address['state']; } else { $insertArray = array(); $insertArray['tx_multishop_customer_id'] = $customer_id; $insertArray['tstamp'] = time(); $insertArray['company'] = $address['delivery_company']; $insertArray['name'] = $address['delivery_first_name'] . ' ' . $address['delivery_middle_name'] . ' ' . $address['delivery_last_name']; $insertArray['name'] = preg_replace('/\\s+/', ' ', $insertArray['name']); $insertArray['first_name'] = $address['delivery_first_name']; $insertArray['middle_name'] = $address['delivery_middle_name']; $insertArray['last_name'] = $address['delivery_last_name']; $insertArray['email'] = $address['delivery_email']; if (!$address['delivery_street_name']) { // fallback for old custom checkouts $insertArray['building'] = $address['building']; $insertArray['street_name'] = $address['delivery_address']; $insertArray['address_number'] = $address['delivery_address_number']; $insertArray['address_ext'] = $address['delivery_address_ext']; $insertArray['address'] = $insertArray['street_name'] . ' ' . $insertArray['address_number'] . ($insertArray['address_ext'] ? '-' . $insertArray['address_ext'] : ''); $insertArray['address'] = preg_replace('/\\s+/', ' ', $insertArray['address']); } else { $insertArray['building'] = $address['building']; $insertArray['street_name'] = $address['delivery_street_name']; $insertArray['address_number'] = $address['delivery_address_number']; $insertArray['address_ext'] = $address['delivery_address_ext']; $insertArray['address'] = $address['delivery_address']; } $insertArray['zip'] = $address['delivery_zip']; $insertArray['phone'] = $address['delivery_telephone']; $insertArray['mobile'] = $address['delivery_mobile']; $insertArray['city'] = $address['delivery_city']; $insertArray['country'] = $address['delivery_country']; $insertArray['gender'] = $address['delivery_gender']; $insertArray['birthday'] = strtotime($address['delivery_birthday']); if ($address['delivery_gender'] == 'm') { $insertArray['title'] = 'Mr.'; } else { if ($address['delivery_gender'] == 'f') { $insertArray['title'] = 'Mrs.'; } } $insertArray['region'] = $address['delivery_state']; } $insertArray['pid'] = $this->conf['fe_customer_pid']; $insertArray['page_uid'] = $this->shop_pid; $insertArray['tstamp'] = time(); $insertArray['tx_multishop_customer_id'] = $customer_id; $insertArray['tx_multishop_address_type'] = 'delivery'; $insertArray['tx_multishop_default'] = 0; $insertArray = mslib_befe::rmNullValuedKeys($insertArray); $query = $GLOBALS['TYPO3_DB']->INSERTquery('tt_address', $insertArray); $res = $GLOBALS['TYPO3_DB']->sql_query($query); } } if ($customer_id) { // now add the order $insertArray = array(); $insertArray['customer_id'] = $customer_id; $insertArray['page_uid'] = $this->shop_pid; if (isset($GLOBALS['TSFE']->fe_user->user['uid']) && !empty($GLOBALS['TSFE']->fe_user->user['uid'])) { $insertArray['cruser_id'] = $GLOBALS['TSFE']->fe_user->user['uid']; } else { $insertArray['cruser_id'] = ''; } $insertArray['customer_comments'] = $this->post['customer_comments']; $insertArray['billing_company'] = $address['company']; $insertArray['billing_first_name'] = $address['first_name']; $insertArray['billing_middle_name'] = $address['middle_name']; $insertArray['billing_last_name'] = $address['last_name']; $insertArray['billing_name'] = preg_replace('/ +/', ' ', $address['first_name'] . ' ' . $address['middle_name'] . ' ' . $address['last_name']); $insertArray['billing_email'] = $address['email']; $insertArray['billing_gender'] = $address['gender']; $insertArray['billing_birthday'] = strtotime($address['birthday']); if (!$address['street_name']) { // fallback for old custom checkouts $insertArray['billing_building'] = $address['building']; $insertArray['billing_street_name'] = $address['address']; $insertArray['billing_address_number'] = $address['address_number']; $insertArray['billing_address_ext'] = $address['address_ext']; $insertArray['billing_address'] = $insertArray['billing_street_name'] . ' ' . $insertArray['billing_address_number'] . ($insertArray['billing_address_ext'] ? '-' . $insertArray['billing_address_ext'] : ''); $insertArray['billing_address'] = preg_replace('/\\s+/', ' ', $insertArray['billing_address']); } else { $insertArray['billing_building'] = $address['building']; $insertArray['billing_street_name'] = $address['street_name']; $insertArray['billing_address_number'] = $address['address_number']; $insertArray['billing_address_ext'] = $address['address_ext']; $insertArray['billing_address'] = $address['address']; } /* $insertArray['billing_street_name'] = $address['street_name']; $insertArray['billing_address_number'] = $address['address_number']; $insertArray['billing_address_ext'] = $address['address_ext']; $insertArray['billing_address'] = $insertArray['billing_street_name'].' '.$insertArray['billing_address_number'].($insertArray['billing_address_ext']? '-'.$insertArray['billing_address_ext']:''); $insertArray['billing_address'] = preg_replace('/\s+/', ' ', $insertArray['billing_address']); */ $insertArray['billing_room'] = ''; $insertArray['billing_city'] = $address['city']; $insertArray['billing_zip'] = $address['zip']; $insertArray['billing_region'] = $address['state']; $insertArray['billing_country'] = $address['country']; $insertArray['billing_telephone'] = $address['telephone']; $insertArray['billing_mobile'] = $address['mobile']; $insertArray['billing_fax'] = ''; if ($this->ms['MODULES']['CHECKOUT_DISPLAY_VAT_ID_INPUT'] && !empty($address['tx_multishop_vat_id'])) { $insertArray['billing_vat_id'] = $address['tx_multishop_vat_id']; } if ($this->ms['MODULES']['CHECKOUT_DISPLAY_COC_ID_INPUT'] && !empty($address['tx_multishop_coc_id'])) { $insertArray['billing_coc_id'] = $address['tx_multishop_coc_id']; } if (!$address['different_delivery_address']) { $insertArray['delivery_email'] = $insertArray['billing_email']; $insertArray['delivery_company'] = $insertArray['billing_company']; $insertArray['delivery_first_name'] = $insertArray['billing_first_name']; $insertArray['delivery_middle_name'] = $insertArray['billing_middle_name']; $insertArray['delivery_last_name'] = $insertArray['billing_last_name']; $insertArray['delivery_telephone'] = $insertArray['billing_telephone']; $insertArray['delivery_mobile'] = $insertArray['billing_mobile']; $insertArray['delivery_gender'] = $insertArray['billing_gender']; $insertArray['delivery_building'] = $insertArray['billing_building']; $insertArray['delivery_street_name'] = $insertArray['billing_street_name']; $insertArray['delivery_address_number'] = $insertArray['billing_address_number']; $insertArray['delivery_address_ext'] = $insertArray['billing_address_ext']; $insertArray['delivery_address'] = $insertArray['billing_address']; $insertArray['delivery_zip'] = $insertArray['billing_zip']; $insertArray['delivery_city'] = $insertArray['billing_city']; $insertArray['delivery_country'] = $insertArray['billing_country']; $insertArray['delivery_telephone'] = $insertArray['billing_telephone']; $insertArray['delivery_region'] = $insertArray['billing_region']; $insertArray['delivery_name'] = $insertArray['billing_name']; $insertArray['delivery_birthday'] = $insertArray['billing_birthday']; } else { $insertArray['delivery_company'] = $address['delivery_company']; $insertArray['delivery_first_name'] = $address['delivery_first_name']; $insertArray['delivery_middle_name'] = $address['delivery_middle_name']; $insertArray['delivery_last_name'] = $address['delivery_last_name']; $insertArray['delivery_name'] = preg_replace('/ +/', ' ', $address['delivery_first_name'] . ' ' . $address['delivery_middle_name'] . ' ' . $address['delivery_last_name']); $insertArray['delivery_email'] = $address['delivery_email']; $insertArray['delivery_gender'] = $address['delivery_gender']; if (!$address['street_name']) { // fallback for old custom checkouts $insertArray['delivery_building'] = $address['delivery_building']; $insertArray['delivery_street_name'] = $address['delivery_address']; $insertArray['delivery_address_number'] = $address['delivery_address_number']; $insertArray['delivery_address_ext'] = $address['delivery_address_ext']; $insertArray['delivery_address'] = $insertArray['delivery_street_name'] . ' ' . $insertArray['delivery_address_number'] . ($insertArray['delivery_address_ext'] ? '-' . $insertArray['delivery_address_ext'] : ''); $insertArray['delivery_address'] = preg_replace('/\\s+/', ' ', $insertArray['delivery_address']); } else { $insertArray['delivery_building'] = $address['delivery_building']; $insertArray['delivery_street_name'] = $address['delivery_street_name']; $insertArray['delivery_address_number'] = $address['delivery_address_number']; $insertArray['delivery_address_ext'] = $address['delivery_address_ext']; $insertArray['delivery_address'] = $address['delivery_address']; } /* $insertArray['delivery_street_name'] = $address['delivery_street_name']; $insertArray['delivery_address_number'] = $address['delivery_address_number']; $insertArray['delivery_address_ext'] = $address['delivery_address_ext']; $insertArray['delivery_address'] = $insertArray['delivery_street_name'].' '.$insertArray['delivery_address_number'].($insertArray['delivery_address_ext']? '-'.$insertArray['delivery_address_ext']:''); $insertArray['delivery_address'] = preg_replace('/\s+/', ' ', $insertArray['delivery_address']); */ $insertArray['delivery_city'] = $address['delivery_city']; $insertArray['delivery_zip'] = $address['delivery_zip']; $insertArray['delivery_room'] = ''; $insertArray['delivery_region'] = $address['delivery_state']; $insertArray['delivery_country'] = $address['delivery_country']; $insertArray['delivery_telephone'] = $address['delivery_telephone']; $insertArray['delivery_mobile'] = $address['delivery_mobile']; $insertArray['delivery_fax'] = ''; $insertArray['delivery_vat_id'] = ''; $insertArray['delivery_birthday'] = strtotime($address['delivery_birthday']); } $insertArray['bill'] = 1; $insertArray['crdate'] = time(); $insertArray['shipping_method'] = $address['shipping_method']; $insertArray['shipping_method_label'] = $address['shipping_method_label']; $insertArray['payment_method'] = $address['payment_method']; $insertArray['payment_method_label'] = $address['payment_method_label']; $insertArray['shipping_method_costs'] = $address['shipping_method_costs']; $insertArray['payment_method_costs'] = $address['payment_method_costs']; $insertArray['hash'] = md5(uniqid('', true)); $insertArray['store_currency'] = $this->ms['MODULES']['CURRENCY_ARRAY']['cu_iso_3']; if (isset($this->ms['MODULES']['CUSTOMER_CURRENCY_ARRAY']['cu_iso_3']) && !empty($this->ms['MODULES']['CUSTOMER_CURRENCY_ARRAY']['cu_iso_3'])) { $insertArray['customer_currency'] = $this->ms['MODULES']['CUSTOMER_CURRENCY_ARRAY']['cu_iso_3']; } else { $insertArray['customer_currency'] = $this->ms['MODULES']['CURRENCY_ARRAY']['cu_iso_3']; } if (isset($this->cookie['currency_rate']) && !empty($this->cookie['currency_rate'])) { $insertArray['currency_rate'] = $this->cookie['currency_rate']; } else { $insertArray['currency_rate'] = 1; } $insertArray['language_id'] = $this->sys_language_uid; // get default orders status $status = mslib_fe::getDefaultOrdersStatus($this->sys_language_uid); $default_order_status_id = 0; if (is_array($status) && isset($status['id']) && $status['id'] > 0) { $default_order_status_id = $status['id']; } // set the order status based on payment method settings $payment_method = mslib_fe::loadPaymentMethod($address['payment_method']); $payment_method_vars = unserialize($payment_method['vars']); $payment_method_vars['default_order_status'] = (int) $payment_method_vars['default_order_status']; if (isset($payment_method_vars['default_order_status']) && is_numeric($payment_method_vars['default_order_status']) && $payment_method_vars['default_order_status'] > 0) { $default_order_status_id = $payment_method_vars['default_order_status']; } if ($default_order_status_id > 0) { $insertArray['status'] = $default_order_status_id; } else { $insertArray['status'] = ''; } if (isset($this->cookie['HTTP_REFERER']) && !empty($this->cookie['HTTP_REFERER'])) { $insertArray['http_referer'] = $this->cookie['HTTP_REFERER']; } else { $insertArray['http_referer'] = ''; } $insertArray['ip_address'] = $this->server['REMOTE_ADDR']; $insertArray['user_agent'] = $this->server['HTTP_USER_AGENT']; if (isset($address['expected_delivery_date'])) { $insertArray['expected_delivery_date'] = $address['expected_delivery_date']; } $user = mslib_fe::getUser($customer_id); $insertArray['payment_condition'] = ''; if (is_numeric($user['tx_multishop_payment_condition']) && $user['tx_multishop_payment_condition'] > 0) { $insertArray['payment_condition'] = $user['tx_multishop_payment_condition']; } //$insertArray['orders_tax_data'] = serialize($orders_tax); if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_multishop_pi1.php']['insertOrderPreProc'])) { // hook $params = array('ms' => $this->ms, 'address' => &$address, 'insertArray' => &$insertArray); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_multishop_pi1.php']['insertOrderPreProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } // hook oef } $insertArray = mslib_befe::rmNullValuedKeys($insertArray); $query = $GLOBALS['TYPO3_DB']->INSERTquery('tx_multishop_orders', $insertArray); $res = $GLOBALS['TYPO3_DB']->sql_query($query); // now add the order eof $orders_id = $GLOBALS['TYPO3_DB']->sql_insert_id(); if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_multishop_pi1.php']['insertOrderPostProc'])) { // hook $params = array('orders_id' => &$orders_id, 'insertArray' => &$insertArray, 'cart' => &$cart); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_multishop_pi1.php']['insertOrderPostProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } // hook oef } if (!$orders_id) { $subject = $this->FULL_HTTP_URL . ' - Convert cart to order failed'; $body = 'Warning. Convert cart to order failed.<br/>Website: ' . $this->FULL_HTTP_URL . '<br/>Error: ' . $GLOBALS['TYPO3_DB']->sql_error() . '<br/>Query:<br/>' . $query; $mailuser = array(); $mailuser['name'] = $this->ms['MODULES']['STORE_NAME']; $mailuser['email'] = $this->ms['MODULES']['STORE_EMAIL']; if ($this->ms['MODULES']['DEVELOPER_EMAIL']) { $mailuser['email'] = $this->ms['MODULES']['DEVELOPER_EMAIL']; } if ($mailuser['email']) { mslib_fe::mailUser($mailuser, $subject, $body, $this->ms['MODULES']['STORE_EMAIL'], $this->ms['MODULES']['STORE_NAME']); } } else { // now add the orders products if ($cart['user']['payment_method']) { $this->ms['payment_method'] = $cart['user']['payment_method']; } elseif ($cart['user']['shipping_method']) { $this->ms['shipping_method'] = $cart['user']['shipping_method']; } if (is_array($cart['products']) && count($cart['products'])) { foreach ($cart['products'] as $shopping_cart_item => $value) { if (is_numeric($value['products_id'])) { if ($this->ms['MODULES']['DISABLE_VAT_RATE']) { $value['tax_rate'] = 0; } $insertArray = array(); $insertArray['orders_id'] = $orders_id; $insertArray['products_id'] = $value['products_id']; $insertArray['categories_id'] = $value['categories_id']; // get all cats $cats = mslib_fe::Crumbar($value['categories_id']); $cats = array_reverse($cats); if (count($cats) > 0) { $i = 0; foreach ($cats as $cat) { $insertArray['categories_id_' . $i] = $cat['id']; $insertArray['categories_name_' . $i] = $cat['name']; $i++; } } // get all cats eof if (isset($value['manufacturers_id']) && !empty($value['manufacturers_id'])) { $insertArray['manufacturers_id'] = $value['manufacturers_id']; } else { $insertArray['manufacturers_id'] = ''; } if (isset($value['order_unit_id']) && !empty($value['order_unit_id'])) { $insertArray['order_unit_id'] = $value['order_unit_id']; } else { $insertArray['order_unit_id'] = ''; } if (isset($value['order_unit_name']) && !empty($value['order_unit_name'])) { $insertArray['order_unit_name'] = $value['order_unit_name']; } else { $insertArray['order_unit_name'] = ''; } if (isset($value['order_unit_code']) && !empty($value['order_unit_code'])) { $insertArray['order_unit_code'] = $value['order_unit_code']; } else { $insertArray['order_unit_code'] = ''; } $insertArray['qty'] = $value['qty']; $insertArray['products_tax'] = $value['tax_rate'] * 100; $insertArray['products_name'] = $value['products_name']; $insertArray['products_model'] = $value['products_model']; /* $insertArray['products_description']=$value['products_shortdescription']; if (is_array($value['attributes'])) { // loading the attributes //$insertArray['products_description'].="\n".strip_tags(mslib_fe::showAttributes($value['products_id'], '', $sessionData, 1)); $insertArray['products_description'].="\n".mslib_fe::showAttributes($value['products_id'], '', $sessionData, 1); // loading the attributes eof } */ $insertArray['products_price'] = $value['products_price']; $insertArray['final_price'] = $value['final_price']; $insertArray['product_capital_price'] = $value['product_capital_price']; $insertArray['type'] = 'P'; // P for Product, S for Subscription (returning-costs) $insertArray['ean_code'] = $value['ean_code']; $insertArray['sku_code'] = $value['sku_code']; $insertArray['vendor_code'] = $value['vendor_code']; $insertArray['products_tax_id'] = $value['tax_id']; // micro download if ($value['file_location'] || $value['file_remote_location']) { $insertArray['file_label'] = $value['file_label']; $insertArray['file_location'] = $value['file_location']; $insertArray['file_remote_location'] = $value['file_remote_location']; $insertArray['file_number_of_downloads'] = $value['file_number_of_downloads']; $insertArray['file_download_code'] = md5(uniqid(rand()) . uniqid(rand())); } // micro download eof /* * always use total_tax and total_tax_rate, unless need different calc for country/region * WARNING: country_* and region_* not always have value, depends on the tax ruleset * ----------------------------------------------------------------------------------------- */ $product_tax['country_tax_rate'] = (string) $value['country_tax_rate']; $product_tax['region_tax_rate'] = (string) $value['region_tax_rate']; $product_tax['total_tax_rate'] = (string) $value['tax_rate']; // ----------------------------------------------------------------------------------------- $product_tax['country_tax'] = (string) $value['country_tax']; $product_tax['region_tax'] = (string) $value['region_tax']; $product_tax['total_tax'] = (string) $value['tax']; $product_tax['total_attributes_tax'] = (string) $value['total_attributes_tax']; // ----------------------------------------------------------------------------------------- if (!$this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT'] || $this->ms['MODULES']['FORCE_CHECKOUT_SHOW_PRICES_INCLUDING_VAT']) { //$product_tax['total_tax']=mslib_fe::taxDecimalCrop($product_tax['total_tax'], 2, false); //$product_tax['total_attributes_tax']=mslib_fe::taxDecimalCrop($product_tax['total_attributes_tax'], 2, false); $product_tax['total_tax'] = round($product_tax['total_tax'], 2); $product_tax['total_attributes_tax'] = round($product_tax['total_attributes_tax'], 2); } if ($this->ms['MODULES']['DISABLE_VAT_RATE']) { $product_tax['country_tax_rate'] = 0; $product_tax['region_tax_rate'] = 0; $product_tax['total_tax_rate'] = 0; $product_tax['country_tax'] = 0; $product_tax['region_tax'] = 0; $product_tax['total_tax'] = 0; $product_tax['total_attributes_tax'] = 0; } // bugfixes bas $sub_total_excluding_vat['final_price'] = $sub_total['final_price'] + $value['final_price'] * $value['qty']; $sub_total['final_price'] = $sub_total['final_price'] + $value['final_price'] * $value['qty']; if (!$this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT'] || $this->ms['MODULES']['FORCE_CHECKOUT_SHOW_PRICES_INCLUDING_VAT']) { $sub_total['total_tax'] = $sub_total['total_tax'] + round($product_tax['total_tax'] * $value['qty'], 2); $sub_total['attributes_tax'] = $sub_total['attributes_tax'] + round($product_tax['total_attributes_tax'] * $value['qty'], 2); $total_order_tax['total_tax'] = $total_order_tax['total_tax'] + round($product_tax['total_tax'] * $value['qty'], 2); $total_order_tax['total_attributes_tax'] = $total_order_tax['total_attributes_tax'] + round($product_tax['total_attributes_tax'] * $value['qty'], 2); } else { $sub_total['total_tax'] = $sub_total['total_tax'] + $product_tax['total_tax'] * $value['qty']; $sub_total['attributes_tax'] = $sub_total['attributes_tax'] + $product_tax['total_attributes_tax'] * $value['qty']; $total_order_tax['total_tax'] = $total_order_tax['total_tax'] + $product_tax['total_tax'] * $value['qty']; $total_order_tax['total_attributes_tax'] = $total_order_tax['total_attributes_tax'] + $product_tax['total_attributes_tax'] * $value['qty']; } $insertArray['products_tax_data'] = serialize($product_tax); // separation of tax $tax_separation[$value['tax_rate'] * 100]['products_total_tax'] += $product_tax['total_tax'] * $value['qty'] + $product_tax['total_attributes_tax'] * $value['qty']; $tax_separation[$value['tax_rate'] * 100]['products_sub_total_excluding_vat'] += $value['final_price'] * $value['qty']; $tax_separation[$value['tax_rate'] * 100]['products_sub_total'] += ($value['final_price'] + $product_tax['total_tax'] + $product_tax['total_attributes_tax']) * $value['qty']; if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_multishop_pi1.php']['insertOrdersProductPreProc'])) { // hook $params = array('ms' => $this->ms, 'value' => $value, 'insertArray' => &$insertArray); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_multishop_pi1.php']['insertOrdersProductPreProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } // hook oef } // TYPO3 6.2 LTS NULL FIX $insertArray = mslib_befe::rmNullValuedKeys($insertArray); $query = $GLOBALS['TYPO3_DB']->INSERTquery('tx_multishop_orders_products', $insertArray); $res = $GLOBALS['TYPO3_DB']->sql_query($query); $orders_products_id = $GLOBALS['TYPO3_DB']->sql_insert_id(); if (!$orders_products_id) { error_log('ERROR:' . $GLOBALS['TYPO3_DB']->sql_error()); } // update orders_products sort_order $updateOrderProductsSortOrder = array(); $updateOrderProductsSortOrder['sort_order'] = $orders_products_id; $query = $GLOBALS['TYPO3_DB']->UPDATEquery('tx_multishop_orders_products', 'orders_products_id=\'' . $orders_products_id . '\'', $updateOrderProductsSortOrder); $res = $GLOBALS['TYPO3_DB']->sql_query($query); if ($this->ms['MODULES']['SUBTRACT_STOCK']) { $continue_update_stock = true; // hook to manipulate the continuity of update stock if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_mslib_cart.php']['updateStockPreProc'])) { // hook $params = array('ms' => $this->ms, 'value' => $value, 'continue_update_stock' => &$continue_update_stock); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_mslib_cart.php']['updateStockPreProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } // hook oef } // if ($continue_update_stock) { if ($this->ms['MODULES']['PRODUCT_ATTRIBUTES_STOCK']) { $sql_as_data = array(); $attributes_count = count($value['attributes']); foreach ($value['attributes'] as $attribute_key => $attribute_values) { $sql_as_data[] = '(pas.options_id = ' . $attribute_values['options_id'] . ' and pas.options_values_id = ' . $attribute_values['options_values_id'] . ')'; } $sql_as = "select pasg.group_id, pasg.attributes_stock from tx_multishop_products_attributes_stock_group pasg, tx_multishop_products_attributes_stock pas where pasg.products_id = " . $value['products_id'] . " and (" . implode(' or ', $sql_as_data) . ") and pasg.group_id = pas.group_id"; $res = $GLOBALS['TYPO3_DB']->sql_query($sql_as); $total_rows = $GLOBALS['TYPO3_DB']->sql_num_rows($res); $used_group = 0; if ($total_rows > 1) { $group_counter = array(); while ($rs_as = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) { $group_counter[$rs_as['group_id']] += 1; } foreach ($group_counter as $ref_group_id => $group_ctr_result) { if ($group_ctr_result == $attributes_count) { $used_group = $ref_group_id; break; } } } else { $rs_as = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res); $used_group = $rs_as['group_id']; } if ($used_group > 0) { $str = "update tx_multishop_products_attributes_stock_group set attributes_stock=(attributes_stock-" . $value['qty'] . ") where group_id='" . $used_group . "'"; $res = $GLOBALS['TYPO3_DB']->sql_query($str); } $str = "update tx_multishop_products set products_quantity=(products_quantity-" . $value['qty'] . ") where products_id='" . $value['products_id'] . "'"; $res = $GLOBALS['TYPO3_DB']->sql_query($str); $str = "select products_quantity, alert_quantity_threshold from tx_multishop_products where products_id='" . $value['products_id'] . "'"; $res = $GLOBALS['TYPO3_DB']->sql_query($str); $row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res); if ($row['products_quantity'] <= $row['alert_quantity_threshold']) { $page = mslib_fe::getCMScontent('email_alert_quantity_threshold_letter', $GLOBALS['TSFE']->sys_language_uid); if ($page[0]['content']) { // loading the email confirmation letter eof // replacing the variables with dynamic values $array1 = array(); $array2 = array(); $array1[] = '###ORDERED_QTY###'; $array2[] = $value['qty']; $array1[] = '###CURRENT_PRODUCT_QUANTITY###'; $array2[] = $row['products_id']; $array1[] = '###PRODUCT_ID###'; $array2[] = $row['products_quantity']; $array1[] = '###PRODUCT_NAME###'; $array2[] = $value['products_name']; $link_edit_prod = $this->FULL_HTTP_URL . mslib_fe::typolink($this->shop_pid . ',2003', 'tx_multishop_pi1[page_section]=edit_product&pid=' . $value['products_id'] . '&cid=' . $value['categories_id'] . '&action=edit_product'); $array1[] = '###DIRECT_EDIT_PRODUCT_LINK###'; $array2[] = '<a href="' . $link_edit_prod . '" target="_blank">' . htmlspecialchars($this->pi_getLL('admin_edit_product')) . '</a>'; // now mail a copy to the merchant $merchant = array(); $merchant['name'] = $this->ms['MODULES']['STORE_NAME']; $merchant['email'] = $this->ms['MODULES']['STORE_EMAIL']; $mailTo = array(); $mailTo[] = $merchant; //hook to let other plugins further manipulate the replacers if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_cart.php']['mailAlertQuantityThresholdPostProc'])) { $params = array('array1' => &$array1, 'array2' => &$array2, 'page' => &$page, 'mailTo' => &$mailTo); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_cart.php']['mailAlertQuantityThresholdPostProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } } //end of hook to let other plugins further manipulate the replacers if ($page[0]['content']) { $page[0]['content'] = str_replace($array1, $array2, $page[0]['content']); } if ($page[0]['name']) { $page[0]['name'] = str_replace($array1, $array2, $page[0]['name']); } foreach ($mailTo as $mailuser) { mslib_fe::mailUser($mailuser, $page[0]['name'], $page[0]['content'], $this->ms['MODULES']['STORE_EMAIL'], $this->ms['MODULES']['STORE_NAME']); } } } if ($row['products_quantity'] < 1) { // stock is negative or zero. lets disable the product $str = "update tx_multishop_products set products_status=0 where products_id='" . $value['products_id'] . "'"; $res = $GLOBALS['TYPO3_DB']->sql_query($str); } } else { // now decrease the stocklevel $str = "update tx_multishop_products set products_quantity=(products_quantity-" . $value['qty'] . ") where products_id='" . $value['products_id'] . "'"; $res = $GLOBALS['TYPO3_DB']->sql_query($str); $str = "select products_quantity, alert_quantity_threshold from tx_multishop_products where products_id='" . $value['products_id'] . "'"; $res = $GLOBALS['TYPO3_DB']->sql_query($str); $row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res); if ($row['products_quantity'] <= $row['alert_quantity_threshold']) { $page = mslib_fe::getCMScontent('email_alert_quantity_threshold_letter', $GLOBALS['TSFE']->sys_language_uid); if ($page[0]['content']) { // loading the email confirmation letter eof // replacing the variables with dynamic values $array1 = array(); $array2 = array(); $array1[] = '###ORDERED_QTY###'; $array2[] = $value['qty']; $array1[] = '###CURRENT_PRODUCT_QUANTITY###'; $array2[] = $row['products_quantity']; $array1[] = '###PRODUCT_NAME###'; $array2[] = $value['products_name']; $link_edit_prod = $this->FULL_HTTP_URL . mslib_fe::typolink($this->shop_pid . ',2003', 'tx_multishop_pi1[page_section]=edit_product&pid=' . $value['products_id'] . '&cid=' . $value['categories_id'] . '&action=edit_product'); $array1[] = '###DIRECT_EDIT_PRODUCT_LINK###'; $array2[] = '<a href="' . $link_edit_prod . '" target="_blank">edit product stock</a>'; // now mail a copy to the merchant $merchant = array(); $merchant['name'] = $this->ms['MODULES']['STORE_NAME']; $merchant['email'] = $this->ms['MODULES']['STORE_EMAIL']; $mailTo = array(); $mailTo[] = $merchant; //hook to let other plugins further manipulate the replacers if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_cart.php']['mailAlertQuantityThresholdPostProc'])) { $params = array('array1' => &$array1, 'array2' => &$array2, 'page' => &$page, 'mailTo' => &$mailTo); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_cart.php']['mailAlertQuantityThresholdPostProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } } //end of hook to let other plugins further manipulate the replacers if ($page[0]['content']) { $page[0]['content'] = str_replace($array1, $array2, $page[0]['content']); } if ($page[0]['name']) { $page[0]['name'] = str_replace($array1, $array2, $page[0]['name']); } foreach ($mailTo as $mailuser) { mslib_fe::mailUser($mailuser, $page[0]['name'], $page[0]['content'], $this->ms['MODULES']['STORE_EMAIL'], $this->ms['MODULES']['STORE_NAME']); } } } if ($row['products_quantity'] < 1) { if ($this->ms['MODULES']['DISABLE_PRODUCT_WHEN_NEGATIVE_STOCK']) { if (!$this->ms['MODULES']['ALLOW_ORDER_OUT_OF_STOCK_PRODUCT']) { // stock is negative or zero. lets turn off the product mslib_befe::disableProduct($value['products_id']); } } } // now decrease the stocklevel eof } } } if ($orders_products_id and is_array($value['attributes'])) { foreach ($value['attributes'] as $attribute_key => $attribute_values) { $str = "SELECT products_options_name,listtype from tx_multishop_products_options o where o.products_options_id='" . $attribute_key . "' "; $qry = $GLOBALS['TYPO3_DB']->sql_query($str); $row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry); // print_r($row['listtype']); switch ($row['listtype']) { case 'checkbox': $items = $attribute_values; break; default: $items = array($attribute_values); break; } foreach ($items as $item) { $attributes_tax['country_tax'] = (string) $item['country_tax']; $attributes_tax['region_tax'] = (string) $item['region_tax']; $attributes_tax['tax'] = (string) $item['tax']; if ($this->ms['MODULES']['DISABLE_VAT_RATE']) { $attributes_tax['country_tax'] = 0; $attributes_tax['region_tax'] = 0; $attributes_tax['tax'] = 0; } $insertAttributes = array(); $insertAttributes['orders_id'] = $orders_id; $insertAttributes['orders_products_id'] = $orders_products_id; $insertAttributes['products_options'] = $item['products_options_name']; $insertAttributes['products_options_values'] = $item['products_options_values_name']; $insertAttributes['options_values_price'] = $item['options_values_price']; $insertAttributes['price_prefix'] = $item['price_prefix']; $insertAttributes['products_options_id'] = $item['options_id']; $insertAttributes['products_options_values_id'] = $item['options_values_id']; $sub_total_excluding_vat['attributes_price'] += $item['price_prefix'] . $item['options_values_price'] * $value['qty']; $sub_total['attributes_price'] += $item['price_prefix'] . $item['options_values_price'] * $value['qty']; $insertAttributes['attributes_tax_data'] = serialize($attributes_tax); $insertAttributes = mslib_befe::rmNullValuedKeys($insertAttributes); $query = $GLOBALS['TYPO3_DB']->INSERTquery('tx_multishop_orders_products_attributes', $insertAttributes); $res = $GLOBALS['TYPO3_DB']->sql_query($query); } } } if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_multishop_pi1.php']['insertOrdersProductsPostProc'])) { // hook $params = array('ms' => $this->ms, 'orders_products_id' => $orders_products_id, 'insertArray' => $insertArray, 'insertAttributes' => $insertAttributes, 'cart' => $cart, 'cart_value' => $value); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_multishop_pi1.php']['insertOrdersProductsPostProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } // hook eof } } } } $updateArray = array(); $orders_tax['sub_total_excluding_vat'] = (string) array_sum($sub_total_excluding_vat); $orders_tax['sub_total'] = (string) array_sum($sub_total); if (!$this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT'] || $this->ms['MODULES']['FORCE_CHECKOUT_SHOW_PRICES_INCLUDING_VAT']) { $orders_tax['total_orders_tax'] = (string) round(array_sum($total_order_tax), 2); } else { $orders_tax['total_orders_tax'] = (string) array_sum($total_order_tax); } $orders_tax['total_orders_tax_including_discount'] = $orders_tax['total_orders_tax']; $grand_total['sub_total'] = array_sum($sub_total); if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_multishop_pi1.php']['insertOrdersTotalProc'])) { // hook $params = array('sub_total_excluding_vat' => &$sub_total_excluding_vat, 'sub_total' => &$sub_total, 'total_order_tax' => &$total_order_tax, 'orders_tax' => &$orders_tax, 'grand_total' => &$grand_total, 'cart' => $cart); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_multishop_pi1.php']['insertOrdersTotalProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } // hook eof } if ($cart['discount_type']) { switch ($cart['discount_type']) { case 'percentage': if (!$this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT'] || $this->ms['MODULES']['FORCE_CHECKOUT_SHOW_PRICES_INCLUDING_VAT']) { $discount_amount = $orders_tax['sub_total_excluding_vat'] / 100 * $cart['discount']; } else { $discount_amount = $orders_tax['sub_total'] / 100 * $cart['discount']; } $discount_percentage = $cart['discount']; break; case 'price': $discount_amount = $cart['discount']; if (!$this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT'] || $this->ms['MODULES']['FORCE_CHECKOUT_SHOW_PRICES_INCLUDING_VAT']) { $discount_percentage = $discount_amount / $orders_tax['sub_total_excluding_vat'] * 100; } else { $discount_percentage = $discount_amount / $orders_tax['sub_total'] * 100; } break; } if ($discount_amount) { if (!$this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT'] || $this->ms['MODULES']['FORCE_CHECKOUT_SHOW_PRICES_INCLUDING_VAT']) { $grand_total['sub_total_excluding_vat'] = $grand_total['sub_total_excluding_vat'] - $discount_amount; if ($this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT']) { $orders_tax['total_orders_tax_including_discount'] = round((1 - $discount_amount / $orders_tax['sub_total']) * $orders_tax['total_orders_tax_including_discount'], 2); } else { $orders_tax['total_orders_tax_including_discount'] = $orders_tax['total_orders_tax_including_discount'] / 100 * (100 - $discount_percentage); } } else { $grand_total['sub_total'] = $grand_total['sub_total'] - $discount_amount; if ($this->ms['MODULES']['SHOW_PRICES_INCLUDING_VAT']) { $orders_tax['total_orders_tax_including_discount'] = round((1 - $discount_amount / $orders_tax['sub_total']) * $orders_tax['total_orders_tax_including_discount'], 2); } else { $orders_tax['total_orders_tax_including_discount'] = $orders_tax['total_orders_tax_including_discount'] / 100 * (100 - $discount_percentage); } } } $updateArray['discount'] = $discount_amount; } $orders_tax['total_orders_tax'] += $orders_tax['shipping_tax']; $orders_tax['total_orders_tax'] += $orders_tax['payment_tax']; $orders_tax['total_orders_tax_including_discount'] += $orders_tax['shipping_tax']; $orders_tax['total_orders_tax_including_discount'] += $orders_tax['payment_tax']; $orders_tax['tax_separation'] = $tax_separation; if ($this->ms['MODULES']['DISABLE_VAT_RATE']) { $orders_tax['total_orders_tax'] = 0; } $orders_tax['grand_total'] = (string) array_sum($grand_total); $updateArray['orders_tax_data'] = serialize($orders_tax); $updateArray['grand_total'] = $orders_tax['grand_total']; if (!empty($cart['coupon_code'])) { $updateArray['coupon_code'] = $cart['coupon_code']; $updateArray['coupon_discount_type'] = $cart['discount_type']; $updateArray['coupon_discount_value'] = $cart['discount']; } $updateArray['orders_last_modified'] = time(); $query = $GLOBALS['TYPO3_DB']->UPDATEquery('tx_multishop_orders', 'orders_id=\'' . $orders_id . '\'', $updateArray); $res = $GLOBALS['TYPO3_DB']->sql_query($query); if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_multishop_pi1.php']['insertOrderDiscountPreProc'])) { // hook $params = array('ms' => $this->ms, 'orders_id' => $orders_id, 'cart' => &$cart); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_multishop_pi1.php']['insertOrderDiscountPreProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } // hook oef } if ($cart['discount']) { if ($cart['discount']) { if ($cart['coupon_code']) { $str = "update tx_multishop_coupons set times_used=(times_used+1) where code='" . addslashes($cart['coupon_code']) . "'"; $res = $GLOBALS['TYPO3_DB']->sql_query($str); $cart['coupon_code'] = ''; } $cart['discount'] = ''; $cart['discount_type'] = ''; } } mslib_befe::storeCustomerCartContent($cart, $customer_id, 1); // debug /* $order=mslib_fe::getOrder($orders_id); $ORDER_DETAILS=mslib_fe::printOrderDetailsTable($order,'email'); echo $ORDER_DETAILS; die(); */ if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_multishop_pi1.php']['insertOrderPostHook'])) { // hook $params = array('cart' => &$cart, 'orders_id' => &$orders_id); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_multishop_pi1.php']['insertOrderPostHook'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } // hook oef } $cart['products'] = array(); //unset($cart['user']); unset($cart['discount_type']); unset($cart['discount_amount']); //$GLOBALS['TSFE']->fe_user->setKey('ses', $this->cart_page_uid, $cart); //$GLOBALS['TSFE']->storeSessionData(); tx_mslib_cart::storeCart($cart); // unset the cart with original key $plain_cart_key = 'tx_multishop_cart'; if ($this->ms['MODULES']['CART_PAGE_UID']) { $plain_cart_key .= '_' . $this->ms['MODULES']['CART_PAGE_UID']; } $cart2 = $GLOBALS['TSFE']->fe_user->getKey('ses', $plain_cart_key); $cart2['products'] = array(); //unset($cart2['user']); unset($cart2['discount_type']); unset($cart2['discount_amount']); //TODO: plain cart key? //$GLOBALS['TSFE']->fe_user->setKey('ses', $plain_cart_key, $cart2); //$GLOBALS['TSFE']->storeSessionData(); tx_mslib_cart::storeCart($cart2); // custom error script for checkout if ($this->ms['MODULES']['ORDERS_CUSTOM_EXPORT_SCRIPT']) { if (strstr($this->ms['MODULES']['ORDERS_CUSTOM_EXPORT_SCRIPT'], "..")) { die('error in ORDERS_CUSTOM_EXPORT_SCRIPT value'); } else { require $this->DOCUMENT_ROOT . $this->ms['MODULES']['ORDERS_CUSTOM_EXPORT_SCRIPT'] . '.php'; } } require_once \TYPO3\CMS\Core\Utility\ExtensionManagementUtility::extPath('multishop') . 'pi1/classes/class.tx_mslib_order.php'; $mslib_order = \TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance('tx_mslib_order'); $mslib_order->init($this); $mslib_order->repairOrder($orders_id); // if grand total is zero we have to activate directly $order = mslib_fe::getOrder($orders_id); if ($order['orders_id'] and $order['grand_total'] < 0.001) { mslib_fe::updateOrderStatusToPaid($order['orders_id']); } if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_multishop_pi1.php']['insertOrderLastPostHook'])) { // hook $params = array('orders_id' => &$orders_id); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/class.tx_multishop_pi1.php']['insertOrderLastPostHook'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } // hook oef } return $orders_id; } } }
<?php if (!defined('TYPO3_MODE')) { die('Access denied.'); } $user = mslib_fe::getUser($this->get['tx_multishop_pi1']['hash'], 'code'); if ($user['uid'] and !$user['tx_multishop_optin_crdate']) { $updateArray = array(); $updateArray['disable'] = 0; $updateArray['tx_multishop_optin_crdate'] = time(); $updateArray['tx_multishop_optin_ip'] = \TYPO3\CMS\Core\Utility\GeneralUtility::getIndpEnv('REMOTE_ADDR'); $query = $GLOBALS['TYPO3_DB']->UPDATEquery('fe_users', 'uid=' . $user['uid'], $updateArray); $res = $GLOBALS['TYPO3_DB']->sql_query($query); // auto login the user $loginData = array('uname' => $user['username'], 'uident' => $user['password'], 'status' => 'login'); $GLOBALS['TSFE']->fe_user->checkPid = 0; //do not use a particular pid $info = $GLOBALS['TSFE']->fe_user->getAuthInfoArray(); $user = $GLOBALS['TSFE']->fe_user->fetchUserRecord($info['db_user'], $loginData['uname']); $GLOBALS['TSFE']->fe_user->createUserSession($user); $this->cart_page_uid .= '_' . $user['uid']; // auto login the user // RELOAD CART CONTENTS $query = $GLOBALS['TYPO3_DB']->SELECTquery('*', 'tx_multishop_cart_contents', 'customer_id=\'' . $user['uid'] . '\' and is_checkout=0', '', 'id desc', '1'); $res = $GLOBALS['TYPO3_DB']->sql_query($query); $row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res); if (is_array($row) && $row['contents']) { $cart = unserialize($row['contents']); //$GLOBALS['TSFE']->fe_user->setKey('ses', $this->cart_page_uid, $cart); //$GLOBALS['TSFE']->storeSessionData(); require_once \TYPO3\CMS\Core\Utility\ExtensionManagementUtility::extPath('multishop') . 'pi1/classes/class.tx_mslib_cart.php';
function createOrder($address) { if (is_numeric($address['uid'])) { $customer_id = $address['uid']; } else { if (!$address['email']) { return false; } $tmp_user = mslib_fe::getUser($address['email'], 'email'); if ($tmp_user['uid']) { $customer_id = $tmp_user['uid']; } } if (!$customer_id) { // add new account $insertArray = array(); $insertArray['page_uid'] = $this->shop_pid; $insertArray['company'] = $address['company']; $insertArray['name'] = $address['first_name'] . ' ' . $address['middle_name'] . ' ' . $address['last_name']; $insertArray['name'] = preg_replace('/\\s+/', ' ', $insertArray['name']); $insertArray['first_name'] = $address['first_name']; $insertArray['last_name'] = $address['last_name']; $insertArray['username'] = $address['email']; $insertArray['email'] = $address['email']; $insertArray['street_name'] = $address['street_name']; if (!$insertArray['street_name']) { $insertArray['street_name'] = $address['address']; } $insertArray['address_number'] = $address['address_number']; $insertArray['address_ext'] = $address['address_ext']; if ($address['address']) { $insertArray['address'] = $address['address']; } else { $insertArray['address'] = $insertArray['street_name'] . ' ' . $insertArray['address_number'] . $insertArray['address_ext']; $insertArray['address'] = preg_replace('/\\s+/', ' ', $insertArray['address']); } $insertArray['zip'] = $address['zip']; $insertArray['telephone'] = $address['telephone']; $insertArray['city'] = $address['city']; $insertArray['country'] = $address['country']; $insertArray['usergroup'] = $this->conf['fe_customer_usergroup']; $insertArray['pid'] = $this->conf['fe_customer_pid']; $insertArray['tstamp'] = time(); $insertArray['tx_multishop_newsletter'] = $address['tx_multishop_newsletter']; $insertArray['password'] = mslib_befe::getHashedPassword(mslib_befe::generateRandomPassword(10, $insertArray['username'])); $query = $GLOBALS['TYPO3_DB']->INSERTquery('fe_users', $insertArray); $res = $GLOBALS['TYPO3_DB']->sql_query($query); if ($res) { $customer_id = $GLOBALS['TYPO3_DB']->sql_insert_id(); } } if ($customer_id) { if ($this->ms['MODULES']['DISABLE_VAT_FOR_FOREIGN_CUSTOMERS_WITH_COMPANY_VAT_ID']) { // if store country is different than customer country change VAT rate to zero if ($address['country'] && $address['tx_multishop_vat_id']) { $iso_customer = mslib_fe::getCountryByName($address['country']); if ($iso_customer['cn_iso_nr'] != $this->ms['MODULES']['COUNTRY_ISO_NR']) { $this->ms['MODULES']['DISABLE_VAT_RATE'] = 1; } } // if store country is different than customer country change VAT rate to zero eof } // now add the order $insertArray = array(); $insertArray['customer_id'] = $customer_id; $insertArray['page_uid'] = $this->shop_pid; $insertArray['language_id'] = 0; if (is_numeric($address['language_id'])) { $insertArray['language_id'] = $address['language_id']; } $insertArray['status'] = ''; if (isset($address['status']) && $address['status'] > 0) { // Set order status $insertArray['status'] = $address['status']; } else { // get default orders status $status = mslib_fe::getDefaultOrdersStatus($this->sys_language_uid); if (is_array($status) && isset($status['id']) && $status['id'] > 0) { $insertArray['status'] = $status['id']; } } $insertArray['customer_comments'] = $this->post['customer_comments']; $insertArray['billing_company'] = $address['company']; $insertArray['billing_first_name'] = $address['first_name']; $insertArray['billing_middle_name'] = $address['middle_name']; $insertArray['billing_last_name'] = $address['last_name']; $insertArray['billing_name'] = preg_replace('/ +/', ' ', $address['first_name'] . ' ' . $address['middle_name'] . ' ' . $address['last_name']); $insertArray['billing_email'] = $address['email']; $insertArray['billing_gender'] = $address['gender']; $insertArray['billing_birthday'] = $address['birthday']; if (!$address['street_name']) { $address['street_name'] = $address['address']; } $insertArray['billing_building'] = $address['building']; $insertArray['billing_street_name'] = $address['street_name']; $insertArray['billing_address_number'] = $address['address_number']; $insertArray['billing_address_ext'] = $address['address_ext']; $insertArray['billing_address'] = $address['street_name'] . ' ' . $address['address_number'] . $address['address_ext']; $insertArray['billing_address'] = preg_replace('/\\s+/', ' ', $insertArray['billing_address']); $insertArray['billing_room'] = ''; $insertArray['billing_city'] = $address['city']; $insertArray['billing_zip'] = $address['zip']; $insertArray['billing_region'] = $address['state']; $insertArray['billing_country'] = $address['country']; $insertArray['billing_telephone'] = $address['telephone']; $insertArray['billing_mobile'] = $address['mobile']; $insertArray['billing_fax'] = ''; $insertArray['billing_vat_id'] = $address['tx_multishop_vat_id']; if (!$address['different_delivery_address']) { $insertArray['delivery_email'] = $insertArray['billing_email']; $insertArray['delivery_company'] = $insertArray['billing_company']; $insertArray['delivery_first_name'] = $insertArray['billing_first_name']; $insertArray['delivery_middle_name'] = $insertArray['billing_middle_name']; $insertArray['delivery_last_name'] = $insertArray['billing_last_name']; $insertArray['delivery_telephone'] = $insertArray['billing_telephone']; $insertArray['delivery_mobile'] = $insertArray['billing_mobile']; $insertArray['delivery_gender'] = $insertArray['billing_gender']; $insertArray['delivery_building'] = $insertArray['billing_building']; $insertArray['delivery_street_name'] = $insertArray['billing_street_name']; $insertArray['delivery_address'] = $insertArray['billing_address']; $insertArray['delivery_address_number'] = $insertArray['billing_address_number']; $insertArray['delivery_address_ext'] = $insertArray['billing_address_ext']; $insertArray['delivery_zip'] = $insertArray['billing_zip']; $insertArray['delivery_city'] = $insertArray['billing_city']; $insertArray['delivery_country'] = $insertArray['billing_country']; $insertArray['delivery_telephone'] = $insertArray['billing_telephone']; $insertArray['delivery_region'] = $insertArray['billing_region']; $insertArray['delivery_name'] = $insertArray['billing_name']; $insertArray['delivery_vat_id'] = $insertArray['billing_vat_id']; } else { $insertArray['delivery_company'] = $address['delivery_company']; $insertArray['delivery_first_name'] = $address['delivery_first_name']; $insertArray['delivery_middle_name'] = $address['delivery_middle_name']; $insertArray['delivery_last_name'] = $address['delivery_last_name']; $insertArray['delivery_name'] = preg_replace('/ +/', ' ', $address['delivery_first_name'] . ' ' . $address['delivery_middle_name'] . ' ' . $address['delivery_last_name']); $insertArray['delivery_email'] = $address['delivery_email']; $insertArray['delivery_gender'] = $address['delivery_gender']; if (!$address['delivery_street_name']) { $address['delivery_street_name'] = $address['delivery_address']; } $insertArray['delivery_building'] = $address['delivery_building']; $insertArray['delivery_street_name'] = $address['delivery_street_name']; $insertArray['delivery_address_number'] = $address['delivery_address_number']; $insertArray['delivery_address_ext'] = $address['delivery_address_ext']; $insertArray['delivery_address'] = $address['delivery_street_name'] . ' ' . $address['delivery_address_number'] . $address['delivery_address_ext']; $insertArray['delivery_address'] = preg_replace('/\\s+/', ' ', $insertArray['delivery_address']); $insertArray['delivery_city'] = $address['delivery_city']; $insertArray['delivery_zip'] = $address['delivery_zip']; $insertArray['delivery_room'] = ''; $insertArray['delivery_region'] = $address['delivery_state']; $insertArray['delivery_country'] = $address['delivery_country']; $insertArray['delivery_telephone'] = $address['delivery_telephone']; $insertArray['delivery_mobile'] = $address['delivery_mobile']; $insertArray['delivery_fax'] = ''; $insertArray['delivery_vat_id'] = $address['delivery_vat_id']; } $insertArray['bill'] = 1; if ($address['forceCustomCrdate']) { $insertArray['crdate'] = $address['forceCustomCrdate']; } else { $insertArray['crdate'] = time(); } $insertArray['shipping_method'] = $address['shipping_method']; $insertArray['shipping_method_label'] = $address['shipping_method_label']; $insertArray['payment_method'] = $address['payment_method']; $insertArray['payment_method_label'] = $address['payment_method_label']; $insertArray['shipping_method_costs'] = $address['shipping_method_costs']; $insertArray['payment_method_costs'] = $address['payment_method_costs']; $insertArray['payment_condition'] = $address['payment_condition']; $insertArray['debit_order'] = 0; if (isset($address['debit_order'])) { $insertArray['debit_order'] = $address['debit_order']; } $insertArray['store_currency'] = $this->ms['MODULES']['CURRENCY_ARRAY']['cu_iso_3']; $insertArray['customer_currency'] = $this->ms['MODULES']['CURRENCY_ARRAY']['cu_iso_3']; if (isset($address['customer_currency']) && $address['customer_currency'] != '') { $insertArray['customer_currency'] = $address['customer_currency']; } $insertArray['currency_rate'] = 1; if (isset($address['currency_rate']) && $address['currency_rate'] != '') { $insertArray['currency_rate'] = $address['currency_rate']; } // TYPO3 6.2 NULL VALUE BUGFIX if (!$insertArray['customer_comments']) { $insertArray['customer_comments'] = ''; } $insertArray['hash'] = md5(uniqid('', true)); if (isset($address['foreign_source_name'])) { $insertArray['foreign_source_name'] = $address['foreign_source_name']; } if (isset($address['foreign_orders_id'])) { $insertArray['foreign_orders_id'] = $address['foreign_orders_id']; } if (isset($address['http_referer'])) { $insertArray['http_referer'] = $address['http_referer']; } if (isset($address['expected_delivery_date'])) { $insertArray['expected_delivery_date'] = $address['expected_delivery_date']; } $types = array(); $types[] = 'billing'; $types[] = 'delivery'; foreach ($types as $type) { $str2 = 'select st.* from static_countries sc, static_territories st where sc.cn_short_en=\'' . addslashes($insertArray[$type . '_country']) . '\' and st.tr_iso_nr=sc.cn_parent_tr_iso_nr'; $query2 = $GLOBALS['TYPO3_DB']->sql_query($str2); $rows2 = $GLOBALS['TYPO3_DB']->sql_num_rows($query2); if ($rows2) { $row2 = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($query2); $insertArray[$type . '_tr_iso_nr'] = $row2['tr_iso_nr']; $insertArray[$type . '_tr_name_en'] = $row2['tr_name_en']; $str2 = 'select * from static_territories where tr_iso_nr=' . $row2['tr_parent_iso_nr']; $query2 = $GLOBALS['TYPO3_DB']->sql_query($str2); $rows2 = $GLOBALS['TYPO3_DB']->sql_num_rows($query2); if ($rows2) { $row2 = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($query2); $insertArray[$type . '_tr_parent_iso_nr'] = $row2['tr_iso_nr']; $insertArray[$type . '_tr_parent_name_en'] = $row2['tr_name_en']; } } } //hook to let other plugins further manipulate the replacers if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_order.php']['createOrderPreProc'])) { $params = array('insertArray' => &$insertArray); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_order.php']['createOrderPreProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } } foreach ($insertArray as $key => $val) { if (is_null($insertArray[$key])) { $insertArray[$key] = ''; } } $query = $GLOBALS['TYPO3_DB']->INSERTquery('tx_multishop_orders', $insertArray); $res = $GLOBALS['TYPO3_DB']->sql_query($query); // now add the order eof $orders_id = $GLOBALS['TYPO3_DB']->sql_insert_id(); //hook to let other plugins further manipulate the replacers if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_order.php']['createOrderPostProc'])) { $params = array('insertArray' => &$insertArray, 'orders_id' => &$orders_id); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_order.php']['createOrderPostProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } } if ($orders_id) { return $orders_id; } } }
<?php if (!defined('TYPO3_MODE')) { die('Access denied.'); } if (mslib_fe::loggedin()) { // user is already signed in $content .= $this->pi_getLL('you_are_already_signed_in'); } else { if ($this->get['tx_multishop_pi1']['createAccountNonOptInCompleted']) { $customerSession = $GLOBALS['TSFE']->fe_user->getKey('ses', 'tx_multishop_customer'); $customer_id = $customerSession['customer_id']; $newCustomer = mslib_fe::getUser($customer_id); $page = mslib_fe::getCMScontent('create_account_thank_you_page', $GLOBALS['TSFE']->sys_language_uid); if ($page[0]['content']) { // loading the email confirmation letter eof // replacing the variables with dynamic values $array1 = array(); $array2 = array(); $array1[] = '###GENDER_SALUTATION###'; $array2[] = mslib_fe::genderSalutation($newCustomer['gender']); $array1[] = '###BILLING_COMPANY###'; $array2[] = $newCustomer['company']; $array1[] = '###FULL_NAME###'; $array2[] = $newCustomer['name']; $array1[] = '###BILLING_NAME###'; $array2[] = $newCustomer['name']; $array1[] = '###BILLING_FIRST_NAME###'; $array2[] = $newCustomer['first_name']; $array1[] = '###BILLING_LAST_NAME###'; $last_name = $newCustomer['last_name'];
//} $jsonData_content .= ' <tr class="removeTableCellBorder msAdminSubtotalRow"> <td colspan="' . ($colspan + 1) . '"><hr></td> </tr>'; $jsonData_content .= ' <tr class="removeTableCellBorder msAdminSubtotalRow"> <td colspan="' . $colspan . '" class="text-right"><strong>' . ucfirst($this->pi_getLL('total')) . '</strong></td> <td class="text-right"><strong>' . mslib_fe::amount2Cents($order['grand_total'], $customer_currency, 1, 0) . '</strong></td> </tr>'; } $jsonData_content .= '</tbody></table> '; $extraDetails = array(); if ($order['cruser_id']) { $user = mslib_fe::getUser($order['cruser_id']); if ($user['username']) { $customer_edit_link = mslib_fe::typolink($this->shop_pid . ',2003', '&tx_multishop_pi1[page_section]=edit_customer&tx_multishop_pi1[cid]=' . $user['uid'] . '&action=edit_customer'); $extraDetails['right'][] = $this->pi_getLL('ordered_by') . ': <strong><a href="' . $customer_edit_link . '">' . $user['username'] . '</a></strong><br />'; } } if ($order['ip_address']) { $extraDetails['right'][] = $this->pi_getLL('ip_address', 'IP address') . ': <strong>' . $order['ip_address'] . '</strong><br />'; } if ($order['http_referer']) { $domain = parse_url($order['http_referer']); if ($domain['host']) { $extraDetails['left'][] = $this->pi_getLL('referrer', 'Referrer') . ': <strong><a href="' . $order['http_referer'] . '" target="_blank" rel="noreferrer">' . $domain['host'] . '</a></strong>'; } } if (count($extraDetails)) {
if ($database['orders_products'][$key]['orders_products_id']==$record2['orders_products_id']) { $database['orders_products'][$key]['products_price']=$database['orders_products'][$key]['products_price']-$record2['options_values_price']; $database['orders_products'][$key]['final_price']=$database['orders_products'][$key]['final_price']-$record2['options_values_price']; } } } } */ foreach ($database['orders'] as $key => $record) { $user = array(); $customer_id = ''; if (count($tx_multishop_customer_ids)) { $customer_id = $tx_multishop_customer_ids[$record['customers_id']]; $user = mslib_fe::getUser($customer_id, 'uid'); } else { $user = mslib_fe::getUser($record['customers_email_address'], 'email'); } if ($user['uid']) { $row = array(); $row['page_uid'] = $this->post['page_uid']; $row['customer_id'] = $user['uid']; $row['billing_name'] = $user['name']; $row['billing_first_name'] = $user['first_name']; $row['billing_last_name'] = $user['last_name']; $row['billing_company'] = $user['company']; $row['billing_building'] = $user['building']; $row['billing_address'] = $user['address']; $row['billing_address_number'] = $user['address_number']; $row['billing_address_ext'] = $user['address_ext']; $row['billing_city'] = $user['city']; $row['billing_zip'] = $user['zip'];
if ($this->ms['MODULES']['DISABLE_BIRTHDATE_IN_ADMIN_CUSTOMER_FORM']) { $subpartsTemplateWrapperRemove['###BIRTHDATE_BLOCK###'] = ''; } $subparts['template'] = $this->cObj->substituteMarkerArrayCached($subparts['template'], array(), $subpartsTemplateWrapperRemove); // load enabled countries to array $str2 = "SELECT * from static_countries sc, tx_multishop_countries_to_zones c2z, tx_multishop_shipping_countries c where c.page_uid='" . $this->showCatalogFromPage . "' and sc.cn_iso_nr=c.cn_iso_nr and c2z.cn_iso_nr=sc.cn_iso_nr group by c.cn_iso_nr order by sc.cn_short_en"; //$str2="SELECT * from static_countries c, tx_multishop_countries_to_zones c2z where c2z.cn_iso_nr=c.cn_iso_nr order by c.cn_short_en"; $qry2 = $GLOBALS['TYPO3_DB']->sql_query($str2); $enabled_countries = array(); while (($row2 = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry2)) != false) { $enabled_countries[] = $row2; } $regex = "/^[^\\\\W][a-zA-Z0-9\\\\_\\\\-\\\\.]+([a-zA-Z0-9\\\\_\\\\-\\\\.]+)*\\\\@[a-zA-Z0-9\\\\_\\\\-\\\\.]+([a-zA-Z0-9\\\\_\\\\-\\\\.]+)*\\\\.[a-zA-Z]{2,4}\$/"; $regex_for_character = "/[^0-9]\$/"; if (!$this->post && is_numeric($this->get['tx_multishop_pi1']['cid'])) { $user = mslib_fe::getUser($this->get['tx_multishop_pi1']['cid']); $this->post = $user; // custom hook that can be controlled by third-party plugin if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/scripts/admin_pages/includes/admin_edit_customer.php']['adminEditCustomerPreloadData'])) { $params = array('user' => $user); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/scripts/admin_pages/includes/admin_edit_customer.php']['adminEditCustomerPreloadData'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } } } $head = ''; $head .= ' <script type="text/javascript"> jQuery(document).ready(function($) { jQuery.h5Validate.addPatterns({ email: /^(([^<>()[\\]\\.,;:\\s@"]+(\\.[^<>()[\\]\\.,;:\\s@"]+)*)|(".+"))@((\\[[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3}])|(([a-zA-Z\\-0-9]+\\.)+[a-zA-Z]{2,}))$/
function saveUserData() { $checkEmail = mslib_fe::getUser($this->getEmail(), 'email'); // if quick_checkout == 1 then update the fe_users if ($checkEmail['tx_multishop_quick_checkout']) { $customer_id = $checkEmail['uid']; // add the user $updateArray = array(); if ($this->username) { $updateArray['username'] = $this->username; } else { $updateArray['username'] = $this->email; } $updateArray['email'] = $this->email; // fe user table holds integer as value: 0 is male, 1 is female // but in tt_address its varchar: m is male, f is female switch ($this->gender) { case '0': case 'm': // male $updateArray['gender'] = '0'; break; case '1': case 'f': // female $updateArray['gender'] = '1'; break; case '2': case 'c': // couple $updateArray['gender'] = '2'; break; } $updateArray['password'] = mslib_befe::getHashedPassword($this->password); $updateArray['first_name'] = $this->first_name; $updateArray['middle_name'] = $this->middle_name; $updateArray['last_name'] = $this->last_name; $updateArray['name'] = $this->name; $updateArray['company'] = $this->company; $updateArray['country'] = $this->country; $updateArray['street_name'] = $this->address; $updateArray['address_number'] = $this->address_number; $updateArray['address_ext'] = $this->address_ext; $updateArray['address'] = $updateArray['street_name'] . ' ' . $updateArray['address_number']; if ($updateArray['address_ext']) { $updateArray['address'] .= '-' . $updateArray['address_ext']; } $updateArray['address'] = preg_replace('/\\s+/', ' ', $updateArray['address']); $updateArray['zip'] = $this->zip; $updateArray['city'] = $this->city; $updateArray['telephone'] = $this->telephone; $updateArray['mobile'] = $this->mobile; if (isset($this->newsletter) && !empty($this->newsletter)) { $updateArray['tx_multishop_newsletter'] = $this->newsletter; } else { $updateArray['tx_multishop_newsletter'] = ''; } $updateArray['disable'] = 1; $updateArray['tstamp'] = time(); $updateArray['usergroup'] = $this->ref->conf['fe_customer_usergroup']; $updateArray['pid'] = $this->ref->conf['fe_customer_pid']; $updateArray['tx_multishop_code'] = md5(uniqid('', true)); $updateArray['crdate'] = time(); $updateArray['page_uid'] = $this->ref->shop_pid; $updateArray['tx_multishop_quick_checkout'] = 0; if (isset($this->ref->cookie['HTTP_REFERER']) && !empty($this->ref->cookie['HTTP_REFERER'])) { $updateArray['http_referer'] = $this->ref->cookie['HTTP_REFERER']; } else { $updateArray['http_referer'] = ''; } $updateArray['ip_address'] = $this->ref->REMOTE_ADDR; if (is_array($this->customFields) and count($this->customFields)) { foreach ($this->customFields as $key => $val) { $updateArray[$key] = $val; } } $query = $GLOBALS['TYPO3_DB']->UPDATEquery('fe_users', 'uid=\'' . $customer_id . '\'', $updateArray); $res = $GLOBALS['TYPO3_DB']->sql_query($query); if ($customer_id) { // ADD CUSTOMER_ID TO THE CART CONTENTS if ($customer_id) { $updateArray = array(); $updateArray['customer_id'] = $customer_id; $updateArray['page_uid'] = $this->ref->shop_pid; $str = $GLOBALS['TYPO3_DB']->UPDATEquery('tx_multishop_cart_contents', 'session_id=\'' . $customer_id . '\'', $updateArray); $res = $GLOBALS['TYPO3_DB']->sql_query($str); } //hook to let other plugins further manipulate the create table query if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_user.php']['updateUserPostProc'])) { $params = array('customer_id' => &$customer_id); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_user.php']['updateUserPostProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } } return $customer_id; } } else { // add the user $insertArray = array(); if ($this->username) { $insertArray['username'] = $this->username; } else { $insertArray['username'] = $this->email; } $insertArray['email'] = $this->email; // fe user table holds integer as value: 0 is male, 1 is female // but in tt_address its varchar: m is male, f is female switch ($this->gender) { case '0': case 'm': // male $insertArray['gender'] = '0'; break; case '1': case 'f': // female $insertArray['gender'] = '1'; break; case '2': case 'c': // couple $insertArray['gender'] = '2'; break; } $insertArray['password'] = mslib_befe::getHashedPassword($this->password); $insertArray['first_name'] = $this->first_name; $insertArray['middle_name'] = $this->middle_name; $insertArray['last_name'] = $this->last_name; $insertArray['name'] = $this->name; $insertArray['company'] = $this->company; $insertArray['country'] = $this->country; $insertArray['street_name'] = $this->address; $insertArray['address_number'] = $this->address_number; $insertArray['address_ext'] = $this->address_ext; $insertArray['address'] = $insertArray['street_name'] . ' ' . $insertArray['address_number']; if ($insertArray['address_ext']) { $insertArray['address'] .= '-' . $insertArray['address_ext']; } $insertArray['address'] = preg_replace('/\\s+/', ' ', $insertArray['address']); $insertArray['zip'] = $this->zip; $insertArray['city'] = $this->city; $insertArray['telephone'] = $this->telephone; $insertArray['mobile'] = $this->mobile; if (isset($this->newsletter) && !empty($this->newsletter)) { $insertArray['tx_multishop_newsletter'] = $this->newsletter; } else { $insertArray['tx_multishop_newsletter'] = ''; } $insertArray['disable'] = 1; $insertArray['tstamp'] = time(); $insertArray['usergroup'] = $this->ref->conf['fe_customer_usergroup']; $insertArray['pid'] = $this->ref->conf['fe_customer_pid']; $insertArray['tx_multishop_code'] = md5(uniqid('', true)); $insertArray['crdate'] = time(); $insertArray['page_uid'] = $this->ref->shop_pid; if (isset($this->ref->cookie['HTTP_REFERER']) && !empty($this->ref->cookie['HTTP_REFERER'])) { $insertArray['http_referer'] = $this->ref->cookie['HTTP_REFERER']; } else { $insertArray['http_referer'] = ''; } $insertArray['ip_address'] = $this->ref->REMOTE_ADDR; if (is_array($this->customFields) and count($this->customFields)) { foreach ($this->customFields as $key => $val) { $insertArray[$key] = $val; } } // TYPO3 6.2 is null bugfix foreach ($insertArray as $key => $val) { if (is_null($insertArray[$key])) { $insertArray[$key] = ''; } } //hook to let other plugins further manipulate the create table query if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_user.php']['createUserPreProc'])) { $params = array('insertArray' => &$insertArray); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_user.php']['createUserPreProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } } $query = $GLOBALS['TYPO3_DB']->INSERTquery('fe_users', $insertArray); $res = $GLOBALS['TYPO3_DB']->sql_query($query); if (!$res) { $error = $GLOBALS['TYPO3_DB']->sql_error(); } else { $customer_id = $GLOBALS['TYPO3_DB']->sql_insert_id(); // ADD CUSTOMER_ID TO THE CART CONTENTS if ($customer_id && $GLOBALS['TSFE']->fe_user->id) { $updateArray = array(); $updateArray['customer_id'] = $customer_id; $updateArray['page_uid'] = $this->ref->shop_pid; $str = $GLOBALS['TYPO3_DB']->UPDATEquery('tx_multishop_cart_contents', 'session_id=\'' . $GLOBALS['TSFE']->fe_user->id . '\'', $updateArray); $res = $GLOBALS['TYPO3_DB']->sql_query($str); } //hook to let other plugins further manipulate the create table query if (is_array($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_user.php']['createUserPostProc'])) { $params = array('customer_id' => &$customer_id); foreach ($GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']['ext/multishop/pi1/classes/class.tx_mslib_user.php']['createUserPostProc'] as $funcRef) { \TYPO3\CMS\Core\Utility\GeneralUtility::callUserFunction($funcRef, $params, $this); } } return $customer_id; } } return false; }