/inc/amfphp/Amfphp/Services/ec_admin_shipping.php
PHP | 1824 lines | 1361 code | 178 blank | 285 comment | 488 complexity | fcc5d47394b6ccfe9eb69ccb0e263db2 MD5 | raw file
Large files files are truncated, but you can click here to view the full file
- <?php
- /*
- ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
- ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
- //All Code and Design is copyrighted by Level Four Development, llc
- //
- //Level Four Development, LLC provides this code "as is" without warranty of any kind, either express or implied,
- //including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.
- //
- //Only licnesed users may use this code and storfront for live purposes. All other use is prohibited and may be
- //subject to copyright violation laws. If you have any questions regarding proper use of this code, please
- //contact Level Four Development, llc and EasyCart prior to use.
- //
- //All use of this storefront is subject to our terms of agreement found on Level Four Development, llc's website.
- ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
- ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
- */
- class ec_admin_shipping
- {
-
- function ec_admin_shipping() {
- /*load our connection settings
- if( file_exists( '../../../../wp-easycart-data/connection/ec_conn.php' ) ) {
- require_once('../../../../wp-easycart-data/connection/ec_conn.php');
- } else {
- require_once('../../../connection/ec_conn.php');
- };*/
-
- //set our connection variables
- $dbhost = DB_HOST;
- $dbname = DB_NAME;
- $dbuser = DB_USER;
- $dbpass = DB_PASSWORD;
- global $wpdb;
- define ('WP_PREFIX', $wpdb->prefix);
- //make a connection to our database
- $this->conn = mysql_connect($dbhost, $dbuser, $dbpass);
- mysql_select_db ($dbname);
- mysql_query("SET CHARACTER SET utf8", $this->conn);
- mysql_query("SET NAMES 'utf8'", $this->conn);
- }
-
-
- //secure all of the services for logged in authenticated users only
- public function _getMethodRoles($methodName){
- if($methodName == 'upstest') return array('admin');
- else if($methodName == 'uspstest') return array('admin');
- else if($methodName == 'fedextest') return array('admin');
- else if($methodName == 'dhltest') return array('admin');
- else if($methodName == 'ausposttest') return array('admin');
- else if($methodName == 'getshippingsettings') return array('admin');
- else if($methodName == 'updateshippingmethodsetting') return array('admin');
- else if($methodName == 'updateshippingsettings') return array('admin');
- else if($methodName == 'getups') return array('admin');
- else if($methodName == 'deleteups') return array('admin');
- else if($methodName == 'updateups') return array('admin');
- else if($methodName == 'addups') return array('admin');
- else if($methodName == 'getusps') return array('admin');
- else if($methodName == 'deleteusps') return array('admin');
- else if($methodName == 'updateusps') return array('admin');
- else if($methodName == 'addusps') return array('admin');
- else if($methodName == 'getfedex') return array('admin');
- else if($methodName == 'deletefedex') return array('admin');
- else if($methodName == 'updatefedex') return array('admin');
- else if($methodName == 'addfedex') return array('admin');
- else if($methodName == 'getauspost') return array('admin');
- else if($methodName == 'deleteauspost') return array('admin');
- else if($methodName == 'updateauspost') return array('admin');
- else if($methodName == 'addauspost') return array('admin');
- else if($methodName == 'getdhl') return array('admin');
- else if($methodName == 'deletedhl') return array('admin');
- else if($methodName == 'updatedhl') return array('admin');
- else if($methodName == 'adddhl') return array('admin');
- else if($methodName == 'updateexpeditedrates') return array('admin');
- else if($methodName == 'getmethodshippingrates') return array('admin');
- else if($methodName == 'deleteshippingmethodrate') return array('admin');
- else if($methodName == 'updateshippingmethodrate') return array('admin');
- else if($methodName == 'addshippingmethodrate') return array('admin');
- else if($methodName == 'getweightshippingrates') return array('admin');
- else if($methodName == 'deleteshippingweightrate') return array('admin');
- else if($methodName == 'updateshippingweightrate') return array('admin');
- else if($methodName == 'addshippingweightrate') return array('admin');
- else if($methodName == 'getpriceshippingrates') return array('admin');
- else if($methodName == 'deleteshippingpricerate') return array('admin');
- else if($methodName == 'updateshippingpricerate') return array('admin');
- else if($methodName == 'addshippingpricerate') return array('admin');
- else if($methodName == 'getquantityshippingrates') return array('admin');
- else if($methodName == 'deleteshippingquantityrate') return array('admin');
- else if($methodName == 'updateshippingquantityrate') return array('admin');
- else if($methodName == 'addshippingquantityrate') return array('admin');
- else if($methodName == 'getzonedetails') return array('admin');
- else if($methodName == 'deletezonedetails') return array('admin');
- else if($methodName == 'insertzonedetails') return array('admin');
- else if($methodName == 'getshippingzones') return array('admin');
- else if($methodName == 'deleteshippingzone') return array('admin');
- else if($methodName == 'insertshippingzone') return array('admin');
- else return null;
- }
-
- //HELPER - used to escape out SQL calls
- function escape($sql)
- {
- $args = func_get_args();
- foreach($args as $key => $val)
- {
- $args[$key] = mysql_real_escape_string($val);
- }
-
- $args[0] = $sql;
- return call_user_func_array('sprintf', $args);
- }
-
- /////////////////////////////////////////////////////////////////////////////////
- //Shipping Testers
- /////////////////////////////////////////////////////////////////////////////////
- function upstest() {
-
- $db = new ec_db_admin( );
- $setting_row = $db->get_settings( );
- $settings = new ec_setting( $setting_row );
-
- $message = "";
-
- if( $setting_row->ups_access_license_number && $setting_row->ups_user_id && $setting_row->ups_password && $setting_row->ups_ship_from_zip && $setting_row->ups_shipper_number && $setting_row->ups_country_code && $setting_row->ups_weight_type ){
-
- if( !class_exists( "ec_shipper" ) ){
- include( WP_PLUGIN_DIR . "/" . EC_PLUGIN_DIRECTORY . '/inc/classes/shipping/ec_shipper.php' );
- }
- if( !class_exists( "ec_ups" ) ){
- include( WP_PLUGIN_DIR . "/" . EC_PLUGIN_DIRECTORY . '/inc/classes/shipping/ec_ups.php' );
- }
-
- // Run test of the settings
- $ups_class = new ec_ups( $settings );
- $ups_response = $ups_class->get_rate_test( "01", $setting_row->ups_ship_from_zip, $setting_row->ups_country_code, "1" );
- $ups_xml = new SimpleXMLElement($ups_response);
-
- if( $ups_xml->Response->ResponseStatusCode == "1" ){
- $result = 1;
- }else if( $ups_xml->Response->Error->ErrorCode == "111210" ){
- $result = 3;
- $message = "The zip + country combination you have entered as your ship from location is invalid.";
- }else{
- $result = 3;
- $message = (string) $ups_xml->Response->Error->ErrorDescription[0];
- }
- }else{
- $result = 3;
- $message = "You are missing some of the required settings. Please ensure you have something entered for the license number, user id, password, postal code, and shipper number.";
- }
-
- if( $setting_row->ups_conversion_rate <= 0 ){
- $result = 2;
- $message = "You have the conversion rate set to zero or less, which is typically an invalid value. This will return zero or less shipping values every time.";
- }
-
- $finalresults = new StdClass;
- if ($result == 1) {
- //if success (green light)
- $finalresults->success_code = 1;
- $finalresults->success_message = 'success';
- } else if ($result == 2) {
- //if problem (yellow light)
- $finalresults->success_code = 2;
- $finalresults->success_message = $message;
- } else if ($result == 3) {
- //if error (red light)
- $finalresults->success_code = 3;
- $finalresults->success_message = $message;
- }
- $returnArray[] = $finalresults;
- return $returnArray;
- }
-
- function uspstest() {
-
- $db = new ec_db_admin( );
- $setting_row = $db->get_settings( );
- $settings = new ec_setting( $setting_row );
- $message = "";
-
- if( $setting_row->usps_user_name && $setting_row->usps_ship_from_zip ){
-
- if( !class_exists( "ec_shipper" ) ){
- include( WP_PLUGIN_DIR . "/" . EC_PLUGIN_DIRECTORY . '/inc/classes/shipping/ec_shipper.php' );
- }
- if( !class_exists( "ec_usps" ) ){
- include( WP_PLUGIN_DIR . "/" . EC_PLUGIN_DIRECTORY . '/inc/classes/shipping/ec_usps.php' );
- }
-
- $usps_class = new ec_usps( $settings );
- $usps_response = $usps_class->get_rate_test( "PRIORITY", $setting_row->usps_ship_from_zip, "US", "1" );
- $usps_xml = new SimpleXMLElement( $usps_response );
-
- if( $usps_xml->Number ){
- $result = 3;
- $message = (string) $usps_xml->Description;
- }else if( $usps_xml->Package[0]->Error ){
- $result = 3;
- $message = (string) $usps_xml->Package[0]->Error->Description[0];
- }else{
- $result = 1;
- }
- }else{
- $result = 3;
- $message = "You are missing some of the required settings. Please ensure you have something entered for the user name and ship from postal code.";
- }
-
- $finalresults = new StdClass;
- if ($result == 1) {
- //if success (green light)
- $finalresults->success_code = 1;
- $finalresults->success_message = 'success';
- } else if ($result == 2) {
- //if problem (yellow light)
- $finalresults->success_code = 2;
- $finalresults->success_message = 'There was a problem with your configuration or transmitting.';
- } else if ($result == 3) {
- //if error (red light)
- $finalresults->success_code = 3;
- $finalresults->success_message = $message;
- }
- $returnArray[] = $finalresults;
- return $returnArray;
- }
-
- function fedextest() {
-
- $db = new ec_db_admin( );
- $setting_row = $db->get_settings( );
- $settings = new ec_setting( $setting_row );
-
- if( $setting_row->fedex_key && $setting_row->fedex_account_number && $setting_row->fedex_meter_number && $setting_row->fedex_password && $setting_row->fedex_ship_from_zip && $setting_row->fedex_weight_units && $setting_row->fedex_country_code ){
-
- if( !class_exists( "ec_shipper" ) ){
- include( WP_PLUGIN_DIR . "/" . EC_PLUGIN_DIRECTORY . '/inc/classes/shipping/ec_shipper.php' );
- }
- if( !class_exists( "ec_fedex" ) ){
- include( WP_PLUGIN_DIR . "/" . EC_PLUGIN_DIRECTORY . '/inc/classes/shipping/ec_fedex.php' );
- }
-
- $fedex_class = new ec_fedex( $settings );
- $fedex_response = $fedex_class->get_rate_test( "FEDEX_GROUND", $setting_row->fedex_ship_from_zip, $setting_row->fedex_country_code, "1" );
-
- if( $fedex_response->HighestSeverity == 'FAILURE' || $fedex_response->HighestSeverity == 'ERROR' || $fedex_response->HighestSeverity == 'WARNING' ){
- if( isset( $fedex_response->Notifications ) ){
- $result = 3;
-
- if( $fedex_response->Notifications->Code == "1000" )
- $message = "FedEx returned an authentication error, meaning your access key + password was not a valid login in their system. It could also mean that you have or have not checked the test mode option to match with the account you are using.";
- else if( $fedex_response->Notifications->Code == "556" )
- $message = "There are no available services from the selected postal code + country. Likely you have an invalid postal code or have not selected the correct country to match.";
- else if( $fedex_response->Notifications->Code == "803" )
- $message = "FedEx has told us the meter number you have entered is incorrect.";
- else if( $fedex_response->Notifications->Code == "860" )
- $message = "FedEx has told us the account number you have entered is incorrect.";
- else
- $message = print_r( $fedex_response->Notifications, true );
-
- }else{
- $result = 3;
- $message= "Unknown error occurred.";
- }
- }else{
- $result = 1;
- }
- }else{
- $result = 3;
- $message = "You are missing some of the required settings. Please ensure you have something entered for the access key, account number, meter number, postal code, and password.";
- }
-
- if( $setting_row->fedex_conversion_rate <= 0 ){
- $result = 2;
- $message = "You have the conversion rate set to zero or less, which is typically an invalid value. This will return zero or less shipping values every time.";
- }
-
- $finalresults = new StdClass;
- if ($result == 1) {
- //if success (green light)
- $finalresults->success_code = 1;
- $finalresults->success_message = 'success';
- } else if ($result == 2) {
- //if problem (yellow light)
- $finalresults->success_code = 2;
- $finalresults->success_message = $message;
- } else if ($result == 3) {
- //if error (red light)
- $finalresults->success_code = 3;
- $finalresults->success_message = $message;
- }
- $returnArray[] = $finalresults;
- return $returnArray;
- }
-
- function dhltest() {
-
- $db = new ec_db_admin( );
- $setting_row = $db->get_settings( );
- $settings = new ec_setting( $setting_row );
-
- if( $setting_row->dhl_site_id && $setting_row->dhl_password && $setting_row->dhl_ship_from_country && $setting_row->dhl_ship_from_zip && $setting_row->dhl_weight_unit ){
-
- if( !class_exists( "ec_shipper" ) ){
- include( WP_PLUGIN_DIR . "/" . EC_PLUGIN_DIRECTORY . '/inc/classes/shipping/ec_shipper.php' );
- }
- if( !class_exists( "ec_dhl" ) ){
- include( WP_PLUGIN_DIR . "/" . EC_PLUGIN_DIRECTORY . '/inc/classes/shipping/ec_dhl.php' );
- }
-
- $dhl_class = new ec_dhl( $settings );
- $dhl_response = $dhl_class->get_rate_test( "N", $setting_row->dhl_ship_from_zip, $setting_row->dhl_ship_from_country, "1" );
- $dhl_xml = new SimpleXMLElement( $dhl_response );
-
- if( $dhl_xml && $dhl_xml->Response && $dhl_xml->Response->Status && $dhl_xml->Response->Status->ActionStatus && $dhl_xml->Response->Status->ActionStatus == "Error" ){
- $result = 3;
- if( $dhl_xml->Response->Status->Condition->ConditionCode == '100' ){
- $message = "DHL failed because the site ID and/or password provided is incorrect.";
- }else{
- $message = print_r( $dhl_xml->Response->Status->Condition, true );
- }
- }else if( $dhl_xml && $dhl_xml->GetQuoteResponse && $dhl_xml->GetQuoteResponse->Note && $dhl_xml->GetQuoteResponse->Note->Condition ){
- $result = 3;
- $message = ( string ) $dhl_xml->GetQuoteResponse->Note->Condition->ConditionData;
- }else{
- $result = 1;
- }
- }else{
- $result = 3;
- $message = "You are missing some of the required settings. Please ensure you have something entered for the Site ID, Password, and Postal Code.";
- }
-
- $finalresults = new StdClass;
- if ($result == 1) {
- //if success (green light)
- $finalresults->success_code = 1;
- $finalresults->success_message = 'success';
- } else if ($result == 2) {
- //if problem (yellow light)
- $finalresults->success_code = 2;
- $finalresults->success_message = 'There was a problem with your configuration or transmitting.';
- } else if ($result == 3) {
- //if error (red light)
- $finalresults->success_code = 3;
- $finalresults->success_message = $message;
- }
- $returnArray[] = $finalresults;
- return $returnArray;
-
- }
-
- function ausposttest() {
-
- $db = new ec_db_admin( );
- $setting_row = $db->get_settings( );
- $settings = new ec_setting( $setting_row );
-
- if( $setting_row->auspost_api_key && $setting_row->auspost_ship_from_zip ){
-
- if( !class_exists( "ec_shipper" ) ){
- include( WP_PLUGIN_DIR . "/" . EC_PLUGIN_DIRECTORY . '/inc/classes/shipping/ec_shipper.php' );
- }
- if( !class_exists( "ec_auspost" ) ){
- include( WP_PLUGIN_DIR . "/" . EC_PLUGIN_DIRECTORY . '/inc/classes/shipping/ec_auspost.php' );
- }
-
- $auspost_class = new ec_auspost( $settings );
- $auspost_response = $auspost_class->get_rate_test( "AUS_PARCEL_EXPRESS", $setting_row->auspost_ship_from_zip, "AU", "1" );
-
- if( !$auspost_response ){
- $result = 3;
- $message = "No response was returned from Australia Post, this means your key is incorrect or the postal code entered is not a valid Australian postal code.";
- }else
- $result = 1;
- }else{
- $result = 3;
- $message = "You are missing some of the required settings. Please ensure you have something entered for the API key and the postal code.";
- }
-
- $finalresults = new StdClass;
- if ($result == 1) {
- //if success (green light)
- $finalresults->success_code = 1;
- $finalresults->success_message = 'success';
- } else if ($result == 2) {
- //if problem (yellow light)
- $finalresults->success_code = 2;
- $finalresults->success_message = 'There was a problem with your configuration or transmitting.';
- } else if ($result == 3) {
- //if error (red light)
- $finalresults->success_code = 3;
- $finalresults->success_message = $message;
- }
- $returnArray[] = $finalresults;
- return $returnArray;
-
- }
-
- /////////////////////////////////////////////////////////////////////////////////
- //Shipping Zones
- /////////////////////////////////////////////////////////////////////////////////
-
- function getzonedetails($zone_id) {
- //Create SQL Query
- $sql = $this->escape("SELECT ec_zone_to_location.*, ec_country.*, ec_state.*
- FROM
- ec_zone_to_location
- LEFT JOIN ec_country ON (ec_zone_to_location.iso2_cnt = ec_country.iso2_cnt)
- LEFT JOIN ec_state ON (ec_zone_to_location.code_sta = ec_state.code_sta)
- WHERE
- ec_zone_to_location.zone_id = '".$zone_id."' ORDER BY ec_country.name_cnt ASC");
- // Run query on database
- $result = mysql_query($sql);
- //if results, convert to an array for use in flash
- if(mysql_num_rows($result) > 0) {
- while ($row=mysql_fetch_object($result)) {
- $returnArray[] = $row;
- }
- return($returnArray); //return array results if there are some
- } else {
- $returnArray[] = "noresults";
- return $returnArray; //return noresults if there are no results
- }
- }
-
- function deletezonedetails($keyfield, $zone_id) {
- //convert object to array
- //$keyfield = (array)$keyfield;
- //$zone_id = (array)$zone_id;
- //Create SQL Query
- $deletesql = $this->escape("DELETE FROM ec_zone_to_location WHERE ec_zone_to_location.zone_to_location_id = '".$keyfield."'");
- //Run query on database;
- mysql_query($deletesql);
- //if results, convert to an array for use in flash
- if(!mysql_error()) {
- //Create SQL Query
- $sql = $this->escape("SELECT ec_zone_to_location.*, ec_country.*, ec_state.*
- FROM
- ec_zone_to_location
- LEFT JOIN ec_country ON (ec_zone_to_location.iso2_cnt = ec_country.iso2_cnt)
- LEFT JOIN ec_state ON (ec_zone_to_location.code_sta = ec_state.code_sta)
- WHERE
- ec_zone_to_location.zone_id = '".$zone_id."' ORDER BY ec_country.name_cnt ASC");
- // Run query on database
- $result = mysql_query($sql);
- //if results, convert to an array for use in flash
- if(mysql_num_rows($result) > 0) {
- while ($row=mysql_fetch_object($result)) {
- $returnArray[] = $row;
- }
- return($returnArray); //return array results if there are some
- } else {
- $returnArray[] = "noresults";
- return $returnArray; //return noresults if there are no results
- }
- } else {
- $returnArray[] = "error";
- return $returnArray; //return noresults if there are no results
- }
- }
- function insertzonedetails($zone_id, $zonecountry, $zonestate) {
-
- $sql = sprintf("Insert into ec_zone_to_location(ec_zone_to_location.zone_to_location_id, ec_zone_to_location.zone_id, ec_zone_to_location.iso2_cnt, ec_zone_to_location.code_sta)
- values(null, '%s', '%s', '%s')",
- mysql_real_escape_string($zone_id),
- mysql_real_escape_string($zonecountry),
- mysql_real_escape_string($zonestate));
- //Run query on database;
- mysql_query($sql);
- //if results, convert to an array for use in flash
- if(!mysql_error()) {
- //Create SQL Query
- $sql = $this->escape("SELECT ec_zone_to_location.*, ec_country.*, ec_state.*
- FROM
- ec_zone_to_location
- LEFT JOIN ec_country ON (ec_zone_to_location.iso2_cnt = ec_country.iso2_cnt)
- LEFT JOIN ec_state ON (ec_zone_to_location.code_sta = ec_state.code_sta)
- WHERE
- ec_zone_to_location.zone_id = '".$zone_id."' ORDER BY ec_country.name_cnt ASC");
- // Run query on database
- $result = mysql_query($sql);
- //if results, convert to an array for use in flash
- if(mysql_num_rows($result) > 0) {
- while ($row=mysql_fetch_object($result)) {
- $returnArray[] = $row;
- }
- return($returnArray); //return array results if there are some
- } else {
- $returnArray[] = "noresults";
- return $returnArray; //return noresults if there are no results
- }
- } else {
- $returnArray[] ="error";
- return($returnArray); //return array results if there are some
- }
- }
-
-
-
-
-
- function getshippingzones() {
- //Create SQL Query
- $sql = $this->escape("SELECT ec_zone.* FROM ec_zone ORDER BY ec_zone.zone_id ASC");
- // Run query on database
- $result = mysql_query($sql);
- //if results, convert to an array for use in flash
- if(mysql_num_rows($result) > 0) {
- while ($row=mysql_fetch_object($result)) {
- $returnArray[] = $row;
- }
- return($returnArray); //return array results if there are some
- } else {
- $returnArray[] = "noresults";
- return $returnArray; //return noresults if there are no results
- }
- }
-
- function deleteshippingzone($keyfield) {
- //Create SQL Query
- $deletesql = $this->escape("DELETE FROM ec_zone WHERE ec_zone.zone_id = '%s'", $keyfield);
- //Run query on database;
- mysql_query($deletesql);
-
- $deletesql = $this->escape("DELETE FROM ec_zone_to_location WHERE ec_zone_to_location.zone_id = '".$keyfield."'");
- //Run query on database;
- mysql_query($deletesql);
-
- //if results, convert to an array for use in flash
- if(!mysql_error()) {
- $returnArray[] ="success";
- return($returnArray); //return array results if there are some
- } else {
- $returnArray[] = "error";
- return $returnArray; //return noresults if there are no results
- }
- }
- function insertshippingzone($zonename) {
-
- $sql = sprintf("Insert into ec_zone(ec_zone.zone_id, ec_zone.zone_name)
- values(null, '%s')",
- mysql_real_escape_string($zonename));
- //Run query on database;
- mysql_query($sql);
- //if results, convert to an array for use in flash
- if(!mysql_error()) {
- $returnArray[] ="success";
- return($returnArray); //return array results if there are some
- } else {
- $returnArray[] ="error";
- return($returnArray); //return array results if there are some
- }
- }
-
-
-
-
-
-
-
-
-
-
-
-
- /////////////////////////////////////////////////////////////////////////////////
- //Shipping Settings
- /////////////////////////////////////////////////////////////////////////////////
-
-
- function getshippingsettings() {
- //Create SQL Query
- $query= mysql_query("SELECT SQL_CALC_FOUND_ROWS ec_setting.shipping_method, ec_setting.shipping_expedite_rate, ec_setting.shipping_handling_rate, ec_setting.ups_access_license_number, ec_setting.ups_user_id, ec_setting.ups_password, ec_setting.ups_ship_from_zip, ec_setting.ups_shipper_number, ec_setting.ups_country_code, ec_setting.ups_weight_type, ec_setting.ups_conversion_rate, ec_setting.usps_user_name, ec_setting.usps_ship_from_zip, ec_setting.fedex_key, ec_setting.fedex_account_number, ec_setting.fedex_meter_number, ec_setting.fedex_password, ec_setting.fedex_ship_from_zip, ec_setting.fedex_weight_units, ec_setting.fedex_country_code, ec_setting.fedex_conversion_rate, ec_setting.fedex_test_account, ec_setting.auspost_api_key, ec_setting.auspost_ship_from_zip, ec_setting.dhl_site_id, ec_setting.dhl_password, ec_setting.dhl_ship_from_country, ec_setting.dhl_ship_from_zip, ec_setting.dhl_weight_unit, ec_setting.dhl_test_mode, ec_setting.fraktjakt_customer_id, ec_setting.fraktjakt_login_key, ec_setting.fraktjakt_conversion_rate, ec_setting.fraktjakt_test_mode, ec_setting.fraktjakt_address, ec_setting.fraktjakt_city, ec_setting.fraktjakt_state, ec_setting.fraktjakt_zip, ec_setting.fraktjakt_country FROM ec_setting WHERE ec_setting.setting_id = 1");
- $totalquery=mysql_query("SELECT FOUND_ROWS()");
- $totalrows = mysql_fetch_object($totalquery);
-
- //if results, convert to an array for use in flash
- if(mysql_num_rows($query) > 0) {
- while ($row=mysql_fetch_object($query)) {
- $row->totalrows=$totalrows;
- $returnArray[] = $row;
- }
- return($returnArray); //return array results if there are some
- } else {
- $returnArray[] = "noresults";
- return $returnArray; //return noresults if there are no results
- }
- }
-
- function updateshippingmethodsetting($shippingmethod, $handlingcharge) {
-
- //Create SQL Query
- $sql = sprintf("UPDATE ec_setting SET ec_setting.shipping_method='%s', ec_setting.shipping_handling_rate='%s' WHERE ec_setting.setting_id = 1",
- mysql_real_escape_string($shippingmethod),
- mysql_real_escape_string($handlingcharge));
- //Run query on database;
- mysql_query($sql);
- //if no errors, return their current Client ID
- //if results, convert to an array for use in flash
- if(!mysql_error()) {
- $returnArray[] ="success";
- return($returnArray); //return array results if there are some
- } else {
- $sqlerror = mysql_error();
- $error = explode(" ", $sqlerror);
- if ($error[0] == "Duplicate") {
- $returnArray[] = "duplicate";
- return $returnArray; //return noresults if there are no results
- } else {
- $returnArray[] = "error";
- return $returnArray; //return noresults if th ere are no results
- }
- }
- }
-
-
- function updateshippingsettings($shippingsettings) {
- //convert object to array
- $shippingsettings = (array)$shippingsettings;
- //Create SQL Query
- $sql = sprintf("UPDATE ec_setting SET ec_setting.shipping_method='%s', ec_setting.shipping_handling_rate='%s', ec_setting.ups_access_license_number='%s', ec_setting.ups_user_id='%s', ec_setting.ups_password='%s', ec_setting.ups_ship_from_zip='%s', ec_setting.ups_shipper_number='%s', ec_setting.ups_country_code='%s', ec_setting.ups_weight_type='%s', ec_setting.ups_conversion_rate ='%s', ec_setting.usps_user_name='%s', ec_setting.usps_ship_from_zip='%s', ec_setting.fedex_key='%s', ec_setting.fedex_account_number='%s', ec_setting.fedex_meter_number='%s', ec_setting.fedex_password='%s', ec_setting.fedex_ship_from_zip='%s', ec_setting.fedex_weight_units='%s', ec_setting.fedex_country_code='%s', ec_setting.fedex_conversion_rate ='%s', ec_setting.fedex_test_account='%s', ec_setting.auspost_api_key = '%s', ec_setting.auspost_ship_from_zip = '%s' , ec_setting.dhl_site_id = '%s', ec_setting.dhl_password = '%s', ec_setting.dhl_ship_from_country = '%s', ec_setting.dhl_ship_from_zip = '%s', ec_setting.dhl_weight_unit = '%s', ec_setting.dhl_test_mode = '%s', ec_setting.fraktjakt_customer_id = '%s', ec_setting.fraktjakt_login_key = '%s', ec_setting.fraktjakt_conversion_rate = '%s', ec_setting.fraktjakt_test_mode = '%s', ec_setting.fraktjakt_address = '%s', ec_setting.fraktjakt_city = '%s', ec_setting.fraktjakt_state = '%s', ec_setting.fraktjakt_zip = '%s', ec_setting.fraktjakt_country = '%s' WHERE ec_setting.setting_id = 1",
- mysql_real_escape_string($shippingsettings['shippingmethod']),
- mysql_real_escape_string($shippingsettings['handlingcharge']),
- mysql_real_escape_string($shippingsettings['ups_access_license_number']),
- mysql_real_escape_string($shippingsettings['ups_user_id']),
- mysql_real_escape_string($shippingsettings['ups_password']),
- mysql_real_escape_string($shippingsettings['ups_ship_from_zip']),
- mysql_real_escape_string($shippingsettings['ups_shipper_number']),
- mysql_real_escape_string($shippingsettings['ups_country_code']),
- mysql_real_escape_string($shippingsettings['ups_weight_type']),
- mysql_real_escape_string($shippingsettings['ups_conversion_rate']),
- mysql_real_escape_string($shippingsettings['usps_user_name']),
- mysql_real_escape_string($shippingsettings['usps_ship_from_zip']),
- mysql_real_escape_string($shippingsettings['fedex_key']),
- mysql_real_escape_string($shippingsettings['fedex_account_number']),
- mysql_real_escape_string($shippingsettings['fedex_meter_number']),
- mysql_real_escape_string($shippingsettings['fedex_password']),
- mysql_real_escape_string($shippingsettings['fedex_ship_from_zip']),
- mysql_real_escape_string($shippingsettings['fedex_weight_units']),
- mysql_real_escape_string($shippingsettings['fedex_country_code']),
- mysql_real_escape_string($shippingsettings['fedex_conversion_rate']),
- mysql_real_escape_string($shippingsettings['fedex_test_account']),
- mysql_real_escape_string($shippingsettings['auspost_api_key']),
- mysql_real_escape_string($shippingsettings['auspost_ship_from_zip']),
- mysql_real_escape_string($shippingsettings['dhl_site_id']),
- mysql_real_escape_string($shippingsettings['dhl_password']),
- mysql_real_escape_string($shippingsettings['dhl_ship_from_country']),
- mysql_real_escape_string($shippingsettings['dhl_ship_from_zip']),
- mysql_real_escape_string($shippingsettings['dhl_weight_unit']),
- mysql_real_escape_string($shippingsettings['dhl_test_mode']),
- mysql_real_escape_string($shippingsettings['fj_customerid']),
- mysql_real_escape_string($shippingsettings['fj_loginkey']),
- mysql_real_escape_string($shippingsettings['fj_conversionrate']),
- mysql_real_escape_string($shippingsettings['fj_testmode']),
- mysql_real_escape_string($shippingsettings['fj_address']),
- mysql_real_escape_string($shippingsettings['fj_city']),
- mysql_real_escape_string($shippingsettings['fj_state']),
- mysql_real_escape_string($shippingsettings['fj_zip']),
- mysql_real_escape_string($shippingsettings['fj_country']));
- //Run query on database;
- mysql_query($sql);
- //return mysql_error();
- //if no errors, return their current Client ID
- //if results, convert to an array for use in flash
- if(!mysql_error()) {
- $returnArray[] ="success";
- return($returnArray); //return array results if there are some
- } else {
- //$sqlerror = mysql_error();
- $error = explode(" ", $sqlerror);
- if ($error[0] == "Duplicate") {
- $returnArray[] = "duplicate";
- return $returnArray; //return noresults if there are no results
- } else {
- $returnArray[] = "error";
- return $returnArray; //return noresults if there are no results
- }
- }
- }
-
- /////////////////////////////////////////////////////////////////////////////////
- //DHL BASED SHIPPING
- /////////////////////////////////////////////////////////////////////////////////
-
- function getdhl() {
- //Create SQL Query
- $query= mysql_query("SELECT SQL_CALC_FOUND_ROWS ec_shippingrate.* FROM ec_shippingrate WHERE ec_shippingrate.is_dhl_based = 1 ORDER BY ec_shippingrate.shipping_order ASC");
- $totalquery=mysql_query("SELECT FOUND_ROWS()");
- $totalrows = mysql_fetch_object($totalquery);
-
- //if results, convert to an array for use in flash
- if(mysql_num_rows($query) > 0) {
- while ($row=mysql_fetch_object($query)) {
- $row->totalrows=$totalrows;
- $returnArray[] = $row;
- }
- return($returnArray); //return array results if there are some
- } else {
- $returnArray[] = "noresults";
- return $returnArray; //return noresults if there are no results
- }
- }
-
- function deletedhl($keyfield) {
- //Create SQL Query
- $deletesql = $this->escape("DELETE FROM ec_shippingrate WHERE ec_shippingrate.shippingrate_id = '%s'", $keyfield);
- //Run query on database;
- mysql_query($deletesql);
-
- //if no errors, return their current Client ID
- //if results, convert to an array for use in flash
- if(!mysql_error()) {
- $returnArray[] ="success";
- return($returnArray); //return array results if there are some
- } else {
- $returnArray[] = "error";
- return $returnArray; //return noresults if there are no results
- }
- }
- function updatedhl($keyfield, $info) {
- //convert object to array
- $info = (array)$info;
-
- //Create SQL Query
- if($info['shippingoverride'] != '') {
- $sql = sprintf("Replace into ec_shippingrate(ec_shippingrate.shippingrate_id, ec_shippingrate.shipping_label, ec_shippingrate.shipping_code, ec_shippingrate.shipping_order, ec_shippingrate.shipping_override_rate, ec_shippingrate.is_dhl_based, ec_shippingrate.zone_id)
- values('".$keyfield."', '%s', '%s','%s', '%s', 1, '%s')",
- mysql_real_escape_string($info['shippinglabel']),
- mysql_real_escape_string($info['shippingcode']),
- mysql_real_escape_string($info['shipping_order']),
- mysql_real_escape_string($info['shippingoverride']),
- mysql_real_escape_string($info['zoneid']));
- } else {
- $sql = sprintf("Replace into ec_shippingrate(ec_shippingrate.shippingrate_id, ec_shippingrate.shipping_label, ec_shippingrate.shipping_code, ec_shippingrate.shipping_order, ec_shippingrate.shipping_override_rate, ec_shippingrate.is_dhl_based, ec_shippingrate.zone_id)
- values('".$keyfield."', '%s', '%s', '%s', null, 1, '%s')",
- mysql_real_escape_string($info['shippinglabel']),
- mysql_real_escape_string($info['shippingcode']),
- mysql_real_escape_string($info['shipping_order']),
- mysql_real_escape_string($info['zoneid']));
- }
- //Run query on database;
- mysql_query($sql);
- //if no errors, return their current Client ID
- //if results, convert to an array for use in flash
- if(!mysql_error()) {
- $returnArray[] ="success";
- return($returnArray); //return array results if there are some
- } else {
- $sqlerror = mysql_error();
- $error = explode(" ", $sqlerror);
- if ($error[0] == "Duplicate") {
- $returnArray[] = "duplicate";
- return $returnArray; //return noresults if there are no results
- } else {
- $returnArray[] = "error";
- return $returnArray; //return noresults if there are no results
- }
- }
- }
- function adddhl($info) {
- //convert object to array
- $info = (array)$info;
-
- //Create SQL Query
- if($info['shippingoverride'] != '') {
- $sql = sprintf("Insert into ec_shippingrate(ec_shippingrate.shippingrate_id, ec_shippingrate.shipping_label, ec_shippingrate.shipping_code, ec_shippingrate.shipping_order, ec_shippingrate.shipping_override_rate, ec_shippingrate.is_dhl_based, ec_shippingrate.zone_id)
- values(null, '%s', '%s','%s','%s', 1, '%s')",
- mysql_real_escape_string($info['shippinglabel']),
- mysql_real_escape_string($info['shippingcode']),
- mysql_real_escape_string($info['shipping_order']),
- mysql_real_escape_string($info['shippingoverride']),
- mysql_real_escape_string($info['zoneid']));
- } else {
- $sql = sprintf("Insert into ec_shippingrate(ec_shippingrate.shippingrate_id, ec_shippingrate.shipping_label, ec_shippingrate.shipping_code, ec_shippingrate.shipping_order, ec_shippingrate.shipping_override_rate, ec_shippingrate.is_dhl_based, ec_shippingrate.zone_id)
- values(null, '%s', '%s', '%s', null, 1, '%s')",
- mysql_real_escape_string($info['shippinglabel']),
- mysql_real_escape_string($info['shippingcode']),
- mysql_real_escape_string($info['shipping_order']),
- mysql_real_escape_string($info['zoneid']));
- }
- //Run query on database;
- mysql_query($sql);
- //if no errors, return their current Client ID
- //if results, convert to an array for use in flash
- if(!mysql_error()) {
- $returnArray[] ="success";
- return($returnArray); //return array results if there are some
- } else {
- $sqlerror = mysql_error();
- $error = explode(" ", $sqlerror);
- if ($error[0] == "Duplicate") {
- $returnArray[] = "duplicate";
- return $returnArray; //return noresults if there are no results
- } else {
- $returnArray[] = mysql_error();
- return $returnArray; //return noresults if there are no results
- }
- }
- }
-
-
- /////////////////////////////////////////////////////////////////////////////////
- //AUS POST BASED SHIPPING
- /////////////////////////////////////////////////////////////////////////////////
-
- function getauspost() {
- //Create SQL Query
- $query= mysql_query("SELECT SQL_CALC_FOUND_ROWS ec_shippingrate.* FROM ec_shippingrate WHERE ec_shippingrate.is_auspost_based = 1 ORDER BY ec_shippingrate.shipping_order ASC");
- $totalquery=mysql_query("SELECT FOUND_ROWS()");
- $totalrows = mysql_fetch_object($totalquery);
-
- //if results, convert to an array for use in flash
- if(mysql_num_rows($query) > 0) {
- while ($row=mysql_fetch_object($query)) {
- $row->totalrows=$totalrows;
- $returnArray[] = $row;
- }
- return($returnArray); //return array results if there are some
- } else {
- $returnArray[] = "noresults";
- return $returnArray; //return noresults if there are no results
- }
- }
-
- function deleteauspost($keyfield) {
- //Create SQL Query
- $deletesql = $this->escape("DELETE FROM ec_shippingrate WHERE ec_shippingrate.shippingrate_id = '%s'", $keyfield);
- //Run query on database;
- mysql_query($deletesql);
-
- //if no errors, return their current Client ID
- //if results, convert to an array for use in flash
- if(!mysql_error()) {
- $returnArray[] ="success";
- return($returnArray); //return array results if there are some
- } else {
- $returnArray[] = "error";
- return $returnArray; //return noresults if there are no results
- }
- }
- function updateauspost($keyfield, $info) {
- //convert object to array
- $info = (array)$info;
-
- //Create SQL Query
- if($info['shippingoverride'] != '') {
- $sql = sprintf("Replace into ec_shippingrate(ec_shippingrate.shippingrate_id, ec_shippingrate.shipping_label, ec_shippingrate.shipping_code, ec_shippingrate.shipping_order, ec_shippingrate.shipping_override_rate, ec_shippingrate.is_auspost_based, ec_shippingrate.zone_id)
- values('".$keyfield."', '%s', '%s','%s', '%s', 1, '%s')",
- mysql_real_escape_string($info['shippinglabel']),
- mysql_real_escape_string($info['shippingcode']),
- mysql_real_escape_string($info['shipping_order']),
- mysql_real_escape_string($info['shippingoverride']),
- mysql_real_escape_string($info['zoneid']));
- } else {
- $sql = sprintf("Replace into ec_shippingrate(ec_shippingrate.shippingrate_id, ec_shippingrate.shipping_label, ec_shippingrate.shipping_code, ec_shippingrate.shipping_order, ec_shippingrate.shipping_override_rate, ec_shippingrate.is_auspost_based, ec_shippingrate.zone_id)
- values('".$keyfield."', '%s', '%s', '%s', null, 1, '%s')",
- mysql_real_escape_string($info['shippinglabel']),
- mysql_real_escape_string($info['shippingcode']),
- mysql_real_escape_string($info['shipping_order']),
- mysql_real_escape_string($info['zoneid']));
- }
- //Run query on database;
- mysql_query($sql);
- //if no errors, return their current Client ID
- //if results, convert to an array for use in flash
- if(!mysql_error()) {
- $returnArray[] ="success";
- return($returnArray); //return array results if there are some
- } else {
- $sqlerror = mysql_error();
- $error = explode(" ", $sqlerror);
- if ($error[0] == "Duplicate") {
- $returnArray[] = "duplicate";
- return $returnArray; //return noresults if there are no results
- } else {
- $returnArray[] = "error";
- return $returnArray; //return noresults if there are no results
- }
- }
- }
- function addauspost($info) {
- //convert object to array
- $info = (array)$info;
-
- //Create SQL Query
- if($info['shippingoverride'] != '') {
- $sql = sprintf("Insert into ec_shippingrate(ec_shippingrate.shippingrate_id, ec_shippingrate.shipping_label, ec_shippingrate.shipping_code, ec_shippingrate.shipping_order, ec_shippingrate.shipping_override_rate, ec_shippingrate.is_auspost_based, ec_shippingrate.zone_id)
- values(null, '%s', '%s','%s','%s', 1, '%s')",
- mysql_real_escape_string($info['shippinglabel']),
- mysql_real_escape_string($info['shippingcode']),
- mysql_real_escape_string($info['shipping_order']),
- mysql_real_escape_string($info['shippingoverride']),
- mysql_real_escape_string($info['zoneid']));
- } else {
- $sql = sprintf("Insert into ec_shippingrate(ec_shippingrate.shippingrate_id, ec_shippingrate.shipping_label, ec_shippingrate.shipping_code, ec_shippingrate.shipping_order, ec_shippingrate.shipping_override_rate, ec_shippingrate.is_auspost_based, ec_shippingrate.zone_id)
- values(null, '%s', '%s', '%s', null, 1, '%s')",
- mysql_real_escape_string($info['shippinglabel']),
- mysql_real_escape_string($info['shippingcode']),
- mysql_real_escape_string($info['shipping_order']),
- mysql_real_escape_string($info['zoneid']));
- }
- //Run query on database;
- mysql_query($sql);
- //if no errors, return their current Client ID
- //if results, convert to an array for use in flash
- if(!mysql_error()) {
- $returnArray[] ="success";
- return($returnArray); //return array results if there are some
- } else {
- $sqlerror = mysql_error();
- $error = explode(" ", $sqlerror);
- if ($error[0] == "Duplicate") {
- $returnArray[] = "duplicate";
- return $returnArray; //return noresults if there are no results
- } else {
- $returnArray[] = mysql_error();
- return $returnArray; //return noresults if there are no results
- }
- }
- }
- /////////////////////////////////////////////////////////////////////////////////
- //UPS BASED SHIPPING
- /////////////////////////////////////////////////////////////////////////////////
-
- function getups() {
- //Create SQL Query
- $query= mysql_query("SELECT SQL_CALC_FOUND_ROWS ec_shippingrate.* FROM ec_shippingrate WHERE ec_shippingrate.is_ups_based = 1 ORDER BY ec_shippingrate.shipping_order ASC");
- $totalquery=mysql_query("SELECT FOUND_ROWS()");
- $totalrows = mysql_fetch_object($totalquery);
-
- //if results, convert to an array for use in flash
- if(mysql_num_rows($query) > 0) {
- while ($row=mysql_fetch_object($query)) {
- $row->totalrows=$totalrows;
- $returnArray[] = $row;
- }
- return($returnArray); //return array results if there are some
- } else {
- $returnArray[] = "noresults";
- return $returnArray; //return noresults if there are no results
- }
- }
-
- function deleteups($keyfield) {
- //Create SQL Query
- $deletesql = $this->escape("DELETE FROM ec_shippingrate WHERE ec_shippingrate.shippingrate_id = '%s'", $keyfield);
- //Run query on database;
- mysql_query($deletesql);
-
- //if no errors, return their current Client ID
- //if results, convert to an array for use in flash
- if(!mysql_error()) {
- $returnArray[] ="success";
- return($returnArray); //return array results if there are some
- } else {
- $returnArray[] = "error";
- return $returnArray; //return noresults if there are no results
- }
- }
- function updateups($keyfield, $info) {
- //convert object to array
- $info = (array)$info;
-
- //Create SQL Query
- if($info['shippingoverride'] != '') {
- $sql = sprintf("Replace into ec_shippingrate(ec_shippingrate.shippingrate_id, ec_shippingrate.shipping_label, ec_shippingrate.shipping_code, ec_shippingrate.shipping_order, ec_shippingrate.shipping_override_rate, ec_shippingrate.is_ups_based, ec_shippingrate.zone_id)
- values('".$keyfield."', '%s', '%s','%s', '%s', 1, '%s')",
- mysql_real_escape_string($info['shippinglabel']),
- mysql_real_escape_string($info['shippingcode']),
- mysql_real_escape_string($info['shipping_order']),
- mysql_real_escape_string($info['shippingoverride']),
- mysql_real_escape_string($info['zoneid']));
- } else {
- $sql = sprintf("Replace into ec_shippingrate(ec_shippingrate.shippingrate_id, ec_shippingrate.shipping_label, ec_shippingrate.shipping_code, ec_shippingrate.shipping_order, ec_shippingrate.shipping_override_rate, ec_shippingrate.is_ups_based, ec_shippingrate.zone_id)
- values('".$keyfield."', '%s', '%s', '%s', null, 1, '%s')",
- mysql_real_escape_string($info['shippinglabel']),
- mysql_real_escape_string($info['shippingcode']),
- mysql_real_escape_string($info['shipping_order']),
- mysql_real_escape_string($info['zoneid']));
- }
-
-
- //Run query on database;
- mysql_query($sql);
- //if no errors, return their current Client ID
- //if results, convert to an array for use in flash
- if(!mysql_error()) {
- $returnArray[] ="success";
- return($returnArray); //return array results if there are some
- } else {
- $sqlerror = mysql_error();
- $error = explode(" ", $sqlerror);
- if ($error[0] == "Duplicate") {
- $returnArray[] = "duplicate";
- return $returnArray; //return noresults if there are no results
- } else {
- $returnArray[] = "error";
- return $returnArray; //return noresults if there are no results
- }
- }
- }
- function addups($info) {
- //convert object to array
- $info = (array)$info;
-
- //Create SQL Query
- if($info['shippingoverride'] != '') {
- $sql = sprintf("Insert into ec_shippingrate(ec_shippingrate.shippingrate_id, ec_shippingrate.shipping_label, ec_shippingrate.shipping_code, ec_shippingrate.shipping_order, ec_shippingrate.shipping_override_rate, ec_shippingrate.is_ups_based, ec_shippingrate.zone_id)
- values(null, '%s', '%s','%s','%s', 1, '%s')",
- mysql_real_escape_string($info['shippinglabel']),
- mysql_real_escape_string($info['shippingcode']),
- mysql_real_escape_string($info['shipping_order']),
- mysql_real_escape_string($info['shippingoverride']),
- mysql_real_escape_string($info['zoneid']));
- } else {
- $sql = sprintf("Insert into ec_shippingrate(ec_shippingrate.shippingrate_id, ec_shippingrate.shipping_label, ec_shippingrate.shipping_code, ec_shippingrate.shipping_order, ec_shippingrate.shipping_override_rate, ec_shippingrate.is_ups_based, ec_shippingrate.zone_id)
- values(null, '%s', '%s', '%s', null, 1, '%s')",
- mysql_real_escape_string($info['shippinglabel']),
- mysql_real_escape_string($info['shippingcode']),
- mysql_real_escape_string($info['shipping_order']),
- mysql_real_escape_string($info['zoneid']));
- }
- //Run query on database;
- mysql_query($sql);
- //if no errors, return their current Client ID
- //if results, convert to an array for use in flash
- if(!mysql_error()) {
- $returnArray[] ="success";
- return($returnArray); //return array results if there are some
- } else {
- $sqlerror = mysql_error();
- $error = explode(" ", $sqlerror);
- if ($error[0] == "Duplicate") {
- $returnArray[] = "duplicate";
- return $returnArray; //return noresults if there are no results
- } else {
- $returnArray[] = mysql_error();
- return $returnArray; //return noresults if there are no results
- }
- }
- }
-
- /////////////////////////////////////////////////////////////////////////////////
- //USPS BASED SHIPPING
- /////////////////////////////////////////////////////////////////////////////////
-
- function getusps() {
- //Create SQL Query
- $query= mysql_query("SELECT SQL_CALC_FOUND_ROWS ec_shippingrate.* FROM ec_shippingrate WHERE ec_shippingrate.is_usps_based = 1 ORDER BY ec_shippingrate.shipping_order ASC");
- $totalquery=mysql_query("SELECT FOUND_ROWS()");
- $totalrows = mysql_fetch_object($totalquery);
-
- //if results, convert to an array for use in flash
- if(mysql_num_rows($query) > 0) {
- while ($row=mysql_fetch_object($query)) {
- $row->totalrows=$totalrows;
- $returnArray[] = $row;
- }
- return($returnArray); //return array results if there are some
- } else {
- $returnArray[] = "noresults";
- return $returnArray; //return noresults if there are no results
- }
- }
-
- function deleteusps($keyfield) {
- //Create SQL Query
- $deletesql = $this->escape("DELETE FROM ec_shippingrate WHERE ec_shippingrate.shippingrate_id = '%s'", $keyfield);
- //Run query on database;
- mysql_query($deletesql);
-
- //if no errors, return their current Client ID
- //if results, convert to an array for use in flash
- if(!mysql_error()) {
- $returnArray[] ="success";
- return($returnArray); //return array results if there are some
- } else {
- $returnArray[] = "error";
- return $returnArray; //return noresults if there are no results
- }
- }
- function updateusps($keyfield, $info) {
- //convert object to array
- $info = (array)$info;
-
- //Create SQL Query
- if($info['shippingoverride'] != '') {
- $sql = sprintf("Replace into ec_shippingrate(ec_shippingrate.shippingrate_id, ec_shippingrate.shipping_label, ec_shippingrate.shipping_code, ec_shippingrate.shipping_order, ec_shippingrate.shipping_override_rate, ec_shippingrate.is_usps_based, ec…
Large files files are truncated, but you can click here to view the full file