gaspower Posted January 26, 2008 Share Posted January 26, 2008 Hello, Below I have included a portion of code from a file that takes a csv file that contains a polygon coordinates and part number (199,31,282,32,269,115,205,114,ABC10136). The problem is that I have changed the parts numbers from C10136 to ABC10136. When using prior C10136, it would import with no errors, now that I am trying to import with ABC10136, I get the error product with such a model does not exist?? Can someone please guide me to where I can change in the code so I can use ABC10136. Thank you JR require('includes/application_top.php'); require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : ''); if (tep_not_null($action)) { switch ($action) { case 'bulk_insert': $target = "temp/"; $target = $target . basename($_FILES['uploaded']['name']) ; $file_name = basename($_FILES['uploaded']['name']); $ok=1; if(move_uploaded_file($_FILES['uploaded']['tmp_name'], $target)) { $messageStack->add("The file ".$file_name . " has been uploaded", 'error'); $image_maps_id = $HTTP_GET_VARS['iID']; $handle = fopen($target,"r"); $num =0; while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { /* $top_right_x = $data[0]; if(!$top_right_x) break; $top_right_y = $data[1]; $bottom_left_x = $data[2]; $bottom_left_y = $data[3]; $product_model = $data[4]; */ // new upload should take it as follows // $map_type = $data[0]; $coord1_x = $data[0]; $coord1_y = $data[1]; $coord2_x = $data[2]; $coord2_y = $data[3]; $coord3_x = $data[4]; $coord3_y = $data[5]; $coord4_x = $data[6]; $coord4_y = $data[7]; $coord5_x = $data[8]; $coord5_y = $data[9]; $coord6_x = $data[10]; $coord6_y = $data[11]; $product_model = $data[12]; // check for rectangle will be the fifth point wil not be a number // check for circle will be the fourth point will not be a number // otherwise it will be a polygon .. check for 0,0 point. if(!is_numeric($data[3])) // circle { $map_type = 3; $product_model = $data[3]; $coord2_y = -999999; $coord3_x = -999999; $coord3_y = -999999; $coord4_x = -999999; $coord4_y = -999999; $coord5_x = -999999; $coord5_y = -999999; $coord6_x = -999999; $coord6_y = -999999; echo "<br> this is a circle"; } elseif(!is_numeric($data[4])) { $map_type =1; $product_model = $data[4]; $coord3_x = -999999; $coord3_y = -999999; $coord4_x = -999999; $coord4_y = -999999; $coord5_x = -999999; $coord5_y = -999999; $coord6_x = -999999; $coord6_y = -999999; echo "<br> this is a rectagle"; } else // polygon { $map_type =2; if(!is_numeric($data[6])) // has 3 points { $product_model = $data[6]; $coord4_x = -999999; $coord4_y = -999999; $coord5_x = -999999; $coord5_y = -999999; $coord6_x = -999999; $coord6_y = -999999; } if(!is_numeric($data[8])) // has 4 points { $product_model = $data[8]; $coord5_x = -999999; $coord5_y = -999999; $coord6_x = -999999; $coord6_y = -999999; } elseif(!is_numeric($data[10])) // has 5 points { $product_model = $data[10]; $coord6_x = -999999; $coord6_y = -999999; } elseif(!is_numeric($data[12])) // has 6 points { $product_model = $data[12]; } echo "<br> this is a polygon"; } /* find the products_id */ $products_id_q = tep_db_query("select products_id from ". TABLE_PRODUCTS . " where products_model = '". $product_model ."'"); //$products_id_arr_chk = tep_db_fetch_array($products_id_q); if(tep_db_num_rows($products_id_q) == 0) { $messageStack->add("Product with such a product model: ". $product_model . " does not exist. Please check !!", 'error'); } else while($products_id_arr = tep_db_fetch_array($products_id_q)) { $products_id = $products_id_arr['products_id']; //check if the value exists // $image_coord_exist = tep_db_query('select image_maps_id from '.TABLE_IMAGE_MAPS_TO_PRODUCTS . ' where image_maps_id = '. $image_maps_id .' and products_id = '. $products_id . ' and top_right_x = ' . $top_right_x . ' and top_right_y = ' . $top_right_y . ' and bottom_left_x = '. $bottom_left_x . ' and bottom_left_y = '. $bottom_left_y); // modified code for the value existing check.. $image_coord_exist = tep_db_query('select image_maps_id from '.TABLE_IMAGE_MAPS_TO_PRODUCTS . ' where map_type = '. $map_type .' and coord1_x = '. $coord1_x . ' and coord1_y = ' . $coord1_y .' and coord2_x = '. $coord2_x . ' and coord2_y = ' . $coord2_y .' and coord3_x = '. $coord3_x . ' and coord3_y = ' . $coord3_y .' and coord4_x = '. $coord4_x . ' and coord4_y = ' . $coord4_y .' and coord5_x = '. $coord5_x . ' and coord5_y = ' . $coord5_y .' and coord6_x = '. $coord6_x . ' and coord6_y = ' . $coord6_y . ' and image_maps_id = '. $image_maps_id .' and products_id = '. $products_id); $image_coord_exist_arr = tep_db_fetch_array($image_coord_exist); if(!$image_coord_exist_arr) // insert if the coord doesnot exist { // find the new coordinate id $image_map_coord_id_count_q = tep_db_query("select count(image_map_coord_id) val from ". TABLE_IMAGE_MAPS_TO_PRODUCTS ); $image_map_coord_id_count_v = tep_db_fetch_array($image_map_coord_id_count_q); if($image_map_coord_id_count_v['val'] == 0) { $image_map_coord_id = 1; } else { $image_map_coord_id_q = tep_db_query("select max(image_map_coord_id) val from ". TABLE_IMAGE_MAPS_TO_PRODUCTS ); $image_map_coord_id_v = tep_db_fetch_array($image_map_coord_id_q); $image_map_coord_id = (int)$image_map_coord_id_v['val'] + 1; } echo $map_type; $sql_data_array = array('image_map_coord_id' => $image_map_coord_id, 'image_maps_id' =>$image_maps_id, 'products_id' => $products_id, /* 'top_right_x' => $top_right_x, 'top_right_y' => $top_right_y, 'bottom_left_x' => $bottom_left_x, 'bottom_left_y' => $bottom_left_y, */ 'map_type' => $map_type, 'coord1_x' => $coord1_x, 'coord1_y' => $coord1_y, 'coord2_x' => $coord2_x, 'coord2_y' => $coord2_y, 'coord3_x' => $coord3_x, 'coord3_y' => $coord3_y, 'coord4_x' => $coord4_x, 'coord4_y' => $coord4_y, 'coord5_x' => $coord5_x, 'coord5_y' => $coord5_y, 'coord6_x' => $coord6_x, 'coord6_y' => $coord6_y, 'status' => 1, 'coord_date_added' => 'now()', 'coord_last_modified' => 'now()' ); tep_db_perform(TABLE_IMAGE_MAPS_TO_PRODUCTS, $sql_data_array); $num ++; } else { $messageStack->add("Product with such a product model: ". $product_model . " already exists. Please check !!", 'error'); } } } fclose($handle); } else { $messageStack->add("Sorry, there was a problem uploading your file.", 'error'); } break; case 'setflag': if ( ($HTTP_GET_VARS['flag'] == '0') || ($HTTP_GET_VARS['flag'] == '1') ) { if (isset($HTTP_GET_VARS['pID'])) { tep_set_coord_status($HTTP_GET_VARS['pID'], $HTTP_GET_VARS['flag'],$HTTP_GET_VARS['iID']); } } tep_redirect(tep_href_link(FILENAME_IMAGE_MAPS, 'iID=' . $HTTP_GET_VARS['iID'] . '&pID=' . $HTTP_GET_VARS['pID']. '&type=coord')); break; case 'insert_image_map': case 'update_image_map': if (isset($HTTP_POST_VARS['iID'])) { $image_maps_id = tep_db_prepare_input($HTTP_POST_VARS['iID']); $image_maps_id = $HTTP_POST_VARS['iID']; } elseif(isset($HTTP_GET_VARS['iID'])) { $image_maps_id = tep_db_prepare_input($HTTP_GET_VARS['iID']); $image_maps_id = $HTTP_GET_VARS['iID']; } if($action == 'insert_image_map') { $image_map_q = tep_db_query("select max(image_maps_id) val from ". TABLE_IMAGE_MAPS ); $image_map_v = tep_db_fetch_array($image_map_q); $image_maps_id = (int)$image_map_v['val'] + 1; } $sort_order = tep_db_prepare_input($HTTP_POST_VARS['sort_order']); $sql_data_array = array('sort_order' => $sort_order); if ($action == 'insert_image_map') { $insert_sql_data = array('image_maps_id' => $image_maps_id, 'parent_id' => '0', 'date_added' => 'now()'); $sql_data_array = array_merge($sql_data_array, $insert_sql_data); tep_db_perform(TABLE_IMAGE_MAPS, $sql_data_array); } elseif ($action == 'update_image_map') { $update_sql_data = array('last_modified' => 'now()'); $sql_data_array = array_merge($sql_data_array, $update_sql_data); tep_db_perform(TABLE_IMAGE_MAPS, $sql_data_array, 'update', "image_maps_id = '" . (int)$image_maps_id . "'"); } $languages = tep_get_languages(); for ($i=0, $n=sizeof($languages); $i<$n; $i++) { $sql_data_array =array(); $insert_sql_data = array(); $image_maps_title_array = $HTTP_POST_VARS['image_maps_title']; $language_id = $languages[$i]['id']; $sql_data_array = array('image_maps_title' => tep_db_prepare_input($image_maps_title_array[$language_id])); //tep_db_query("the new value is ".tep_db_prepare_input($image_maps_title_array[$language_id])); if ($action == 'insert_image_map') { $insert_sql_data = array('image_maps_id' => $image_maps_id, 'language_id' => $languages[$i]['id']); $sql_data_array = array_merge($sql_data_array, $insert_sql_data); tep_db_perform(TABLE_IMAGE_MAPS_DESCRIPTION, $sql_data_array); } elseif ($action == 'update_image_map') { tep_db_perform(TABLE_IMAGE_MAPS_DESCRIPTION, $sql_data_array, 'update', "image_maps_id = '" . (int)$image_maps_id . "' and language_id = '" . (int)$language_id . "'"); } } $maps_main_image = new upload('maps_main_image'); $maps_main_image->set_destination(DIR_FS_CATALOG_IMAGES); if ($maps_main_image->parse() && $maps_main_image->save()) { tep_db_query("update " . TABLE_IMAGE_MAPS . " set maps_main_image = '" . tep_db_input($maps_main_image->filename) . "' where image_maps_id = '" . (int)$image_maps_id . "'"); } tep_redirect(tep_href_link(FILENAME_IMAGE_MAPS),'type=IM'); break; case 'delete_image_map_confirm': if (isset($HTTP_POST_VARS['iID'])) $image_maps_id = tep_db_prepare_input($HTTP_POST_VARS['iID']); if (isset($HTTP_GET_VARS['iID'])) $image_maps_id = tep_db_prepare_input($HTTP_GET_VARS['iID']); if($image_maps_id) { // tep_db_query("get something from somwhere ". $image_maps_id); tep_remove_image_map($image_maps_id); } tep_redirect(tep_href_link(FILENAME_IMAGE_MAPS),'type=IM'); break; case 'delete_coord_confirm': if (isset($HTTP_GET_VARS['pID'])) { $coord_id = tep_db_prepare_input($HTTP_GET_VARS['pID']); tep_db_query("delete from " . TABLE_IMAGE_MAPS_TO_PRODUCTS . " where image_map_coord_id = '" . (int)$coord_id . "'"); } tep_redirect(tep_href_link(FILENAME_IMAGE_MAPS, 'iID=' . $HTTP_GET_VARS['iID']. '&type=coord')); break; case 'insert_coord': case 'update_coord': // if (isset($HTTP_POST_VARS['right_top_x']) || isset($HTTP_POST_VARS['right_top_y']) || isset($HTTP_POST_VARS['left_bottom_x']) || isset($HTTP_POST_VARS['left_bottom_y'])) { // $action = 'new_coord'; // } else { if (isset($HTTP_GET_VARS['pID'])) $image_map_coord_id = tep_db_prepare_input($HTTP_GET_VARS['pID']); if (isset($HTTP_GET_VARS['iID'])) $image_maps_id = tep_db_prepare_input($HTTP_GET_VARS['iID']); // tep_db_query("select soemthign from somewhere ".$image_maps_id); $sql_data_array = array('image_maps_id' =>$image_maps_id, 'products_id' => tep_db_prepare_input($HTTP_POST_VARS['products_id']), /* 'top_right_x' => tep_db_prepare_input($HTTP_POST_VARS['top_right_x']), 'top_right_y' => tep_db_prepare_input($HTTP_POST_VARS['top_right_y']), 'bottom_left_x' => tep_db_prepare_input($HTTP_POST_VARS['bottom_left_x']), 'bottom_left_y' => tep_db_prepare_input($HTTP_POST_VARS['bottom_left_y']),*/ 'map_type' => tep_db_prepare_input($HTTP_POST_VARS['map_type']), 'coord1_x' => tep_db_prepare_input($HTTP_POST_VARS['coord1_x']), 'coord1_y' => tep_db_prepare_input($HTTP_POST_VARS['coord1_y']), 'coord2_x' => tep_db_prepare_input($HTTP_POST_VARS['coord2_x']), 'coord2_y' => tep_db_prepare_input($HTTP_POST_VARS['coord2_y']), 'coord3_x' => tep_db_prepare_input($HTTP_POST_VARS['coord3_x']), 'coord3_y' => tep_db_prepare_input($HTTP_POST_VARS['coord3_y']), 'coord4_x' => tep_db_prepare_input($HTTP_POST_VARS['coord4_x']), 'coord4_y' => tep_db_prepare_input($HTTP_POST_VARS['coord4_y']), 'coord5_x' => tep_db_prepare_input($HTTP_POST_VARS['coord5_x']), 'coord5_y' => tep_db_prepare_input($HTTP_POST_VARS['coord5_y']), 'coord6_x' => tep_db_prepare_input($HTTP_POST_VARS['coord6_x']), 'coord6_y' => tep_db_prepare_input($HTTP_POST_VARS['coord6_y']), 'status' => tep_db_prepare_input($HTTP_POST_VARS['products_status']) ); if($action == 'insert_coord') { $image_map_coord_id_q = tep_db_query("select max(image_map_coord_id) val from ". TABLE_IMAGE_MAPS_TO_PRODUCTS ); $image_map_coord_id_v = tep_db_fetch_array($image_map_coord_id_q); $image_map_coord_id = (int)$image_map_coord_id_v['val'] + 1; } if ($action == 'insert_coord') { $insert_sql_data = array( 'image_map_coord_id' => $image_map_coord_id, 'coord_date_added' => 'now()'); $sql_data_array = array_merge($sql_data_array, $insert_sql_data); tep_db_perform(TABLE_IMAGE_MAPS_TO_PRODUCTS, $sql_data_array); } elseif ($action == 'update_coord') { $update_sql_data = array('coord_last_modified' => 'now()'); $sql_data_array = array_merge($sql_data_array, $update_sql_data); tep_db_perform(TABLE_IMAGE_MAPS_TO_PRODUCTS, $sql_data_array, 'update', "image_map_coord_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and image_maps_id = '" . (int)$HTTP_GET_VARS['iID'] . "'"); } tep_redirect(tep_href_link(FILENAME_IMAGE_MAPS, 'iID=' . $image_maps_id . '&pID=' . $image_map_coord_id.'&type=coord')); // } break; } } // check if the catalog image directory exists if (is_dir(DIR_FS_CATALOG_IMAGES)) { if (!is_writeable(DIR_FS_CATALOG_IMAGES)) $messageStack->add(ERROR_CATALOG_IMAGE_DIRECTORY_NOT_WRITEABLE, 'error'); } else { $messageStack->add(ERROR_CATALOG_IMAGE_DIRECTORY_DOES_NOT_EXIST, 'error'); } ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> <script language="javascript" src="includes/general.js"></script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onload="SetFocus();"> <div id="spiffycalendar" class="text"></div> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"> <?php if ($action == 'new_coord') {/* 'image_maps_id' => tep_db_prepare_input($HTTP_POST_VARS['iID']), 'products_id' => tep_db_prepare_input($HTTP_POST_VARS['products_id']), 'right_top_x' => tep_db_prepare_input($HTTP_POST_VARS['right_top_x']), 'right_top_y' => tep_db_prepare_input($HTTP_POST_VARS['right_top_y']), 'left_bottom_x' => tep_db_prepare_input($HTTP_POST_VARS['left_bottom_x']), 'left_bottom_y' => tep_db_prepare_input($HTTP_POST_VARS['left_bottom_y']), 'status' => '1'*/ $parameters = array( 'products_id' => '', /* 'top_right_x' => '', 'top_right_y' => '', 'bottom_left_x' => '', 'bottom_left_y' => '',*/ 'map_type' =>'', 'coord1_x' =>'', 'coord1_y' =>'', 'coord2_x' =>'', 'coord2_y' =>'', 'coord3_x' =>'', 'coord3_y' =>'', 'coord4_x' =>'', 'coord4_y' =>'', 'coord5_x' =>'', 'coord5_y' =>'', 'coord6_x' =>'', 'coord6_y' =>'', 'status' => '', 'coord_date_added' => '', 'coord_last_modified' => '', 'image_maps_id' => ''); $pInfo = new objectInfo($parameters); if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) { $coords_query = tep_db_query( "select im2p.image_map_coord_id, im2p.image_maps_id, im2p.products_id, im2p.map_type, im2p.coord1_x,im2p.coord1_y, im2p.coord2_x,im2p.coord2_y, im2p.coord3_x,im2p.coord3_y, im2p.coord4_x,im2p.coord4_y, im2p.coord5_x,im2p.coord5_y, im2p.coord6_x,im2p.coord6_y, im2p.status,im2p.coord_date_added, im2p.coord_last_modified, imd.image_maps_title,p.products_model from ". TABLE_IMAGE_MAPS_TO_PRODUCTS ." im2p, " . TABLE_IMAGE_MAPS_DESCRIPTION . " imd, ". TABLE_PRODUCTS . " p where p.products_id = im2p.products_id and imd.image_maps_id = im2p.image_maps_id and language_id = '". (int)$languages_id . "' and im2p.image_map_coord_id = " . (int)$HTTP_GET_VARS['pID']); $coord = tep_db_fetch_array($coords_query); $pInfo->objectInfo($coord); } elseif (tep_not_null($HTTP_POST_VARS)) { $pInfo->objectInfo($HTTP_POST_VARS); } $languages = tep_get_languages(); if (!isset($pInfo->products_status)) $pInfo->products_status = '1'; switch ($pInfo->products_status) { case '0': $in_status = false; $out_status = true; break; case '1': default: $in_status = true; $out_status = false; } ?> <?php echo tep_draw_form('new_coord', FILENAME_IMAGE_MAPS, 'iID=' . $HTTP_GET_VARS['iID'] . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '') . '&action=new_coord_preview', 'post', 'enctype="multipart/form-data"'); ?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo sprintf(TEXT_NEW_PRODUCT_COORD, "in ".$pInfo->image_maps_title); ?></td> <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td><table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main" align="right"><?php echo TEXT_COORD_STATUS; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_radio_field('products_status', '1', $in_status) . ' ' . TEXT_COORD_AVAILABLE . ' ' . tep_draw_radio_field('products_status', '0', $out_status) . ' ' . TEXT_COORD_NOT_AVAILABLE; ?></td> </tr> <tr> <td colspan="1"><?php echo tep_draw_separator('pixel_trans.gif', '1', '5'); ?></td> </tr> <tr> <td class="main" align="right"><?php echo TEXT_COORD_PRODUCT_SELECT; ?> </td> Link to comment https://forums.phpfreaks.com/topic/87971-solved-help-with-associating-model-number-with-database/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.