function check_duplicate_record_csvdata($data) { $grade = 0; // initialise grade $match_by = $_SESSION['match']; $item_name = htmlspecialchars($data[1], ENT_QUOTES); $mfg_name = htmlspecialchars($data[3], ENT_QUOTES); $mfg_show = ''; $dup_status = ''; $import_status = 'N'; $dup_field = ''; $check = "<input type='checkbox' class='check' name='upload'>"; $duplicate = 'Duplicate Record In CSV'; $insert_values = array($data[0], $item_name, $data[2], $mfg_name, $data[4], $data[5], @$data[6], $mfg_show, $duplicate, $grade, $dup_status, $import_status, $dup_field); insert_results_indb($insert_values, $import_status); }
function match_pos_upc($data, $item_upc, $mfg_code) { global $dbs, $pdo; $csvupc = check_csvupc_matchby_both($item_upc); $stn_sku = stn_sku($mfg_code, $data[0], $data[4]); $item_upc = $data[2]; $item_namedb = htmlspecialchars($data[1], ENT_QUOTES); $mfg_namedb = htmlspecialchars($data[3], ENT_QUOTES); $no_match = "NO MATCH"; $dup_field = ''; $dup_status = ''; $grade = 0; $import = 'N'; if ($csvupc != 'no') { $prod_code = $csvupc; $csvupc = strtoupper(substr($prod_code, 8)); $query = "SELECT\r\n\t\t\t\t\tproduct_sku, stn_sku, product_name,\r\n\t\t\t\t\tproduct_upc, product_isbn, product_ean, mfg_id\r\n\t\t\t\t\tFROM stn_products \r\n\t\t\t\t\tWHERE {$prod_code}=:item_upc\r\n\t\t\t\t "; $query_both = $dbs->prepare($query); $query_both->bindParam(":item_upc", $item_upc, PDO::PARAM_STR); $query_both->execute(); $count = $query_both->rowCount(); if ($count > 1) { $elements = $query_both->fetchALL(PDO::FETCH_ASSOC); get_matchup_results_both($data, $elements, $stn_sku, $csvupc); } else { $elements = $query_both->fetch(PDO::FETCH_ASSOC); get_matchup_result_both($data, $elements, $stn_sku, $csvupc); } } elseif ($csvupc == 'no' && $item_upc[0] == '0') { $item_upc = ltrim($item_upc, '0'); $csvupc = check_trimmedcsvupc_matchby_both($item_upc); if ($csvupc != 'no') { $prod_code = $csvupc; $csvupc = strtoupper(substr($prod_code, 8)); $item_upc = "%{$item_upc}"; $query = "SELECT \r\n\t\t\t\t\t\tproduct_sku, stn_sku, product_name, product_upc,\r\n\t\t\t\t\t\tproduct_isbn, product_ean, mfg_id\r\n\t\t\t\t\t\tFROM stn_products\r\n\t\t\t\t\t\tWHERE {$prod_code} LIKE :item_upc\r\n\t\t\t\t\t "; $query_both = $dbs->prepare($query); $query_both->bindParam(":item_upc", $item_upc, PDO::PARAM_STR); $query_both->execute(); $count = $query_both->rowCount(); if ($count > 1) { $elements = $query_both->fetchALL(PDO::FETCH_ASSOC); get_matchup_results_both($data, $elements, $stn_sku, $csvupc); } else { $elements = $query_both->fetch(PDO::FETCH_ASSOC); get_matchup_result_both($data, $elements, $stn_sku, $csvupc); } } else { $mfg_show = get_mfg_name($mfg_code); $insert_values = array($data[0], $item_namedb, $data[2], $mfg_namedb, $data[4], $data[5], $data[6], $mfg_show, $no_match, $grade, $dup_status, $import, $dup_field); insert_results_indb($insert_values, $import); } } else { $mfg_show = get_mfg_name($mfg_code); $insert_values = array($data[0], $item_namedb, $data[2], $mfg_namedb, $data[4], $data[5], $data[6], $mfg_show, $no_match, $grade, $dup_status, $import, $dup_field); insert_results_indb($insert_values, $import); } }