// echo "<tr><td>".$rek["name_cat"]."</td><td> ".$rek["Name"]." </td><td> ".$rek["Street"]." </td><td> ".$rek["House"]." </td><td> ".$rek["Date_Sold"]."</td><td>".$rek["Price"]." �</td></tr><br />"; //} echo "</table> "; */ $preset_on = 1; if ($preset_on == 1) { $v_pat = 2; $v_fun = 2; $v_cln = 2; $v_vis = 2; $v_frm = 3; $v_rin = 3; $v_fuse = 2; } echo "PRE" . $V_BAR_EX; $V_BAR_EX = swap_hash($V_BAR_EX); //if we add trime here that works fine no % at the end20 $url = 'add_barcode.php?' . 'bar_ex=' . $v_bar_exist . '&' . 'v_pat=' . $v_pat . '&' . 'v_fun=' . $v_fun . '&' . 'v_cln=' . $v_cln . '&' . 'v_vis=' . $v_vis . '&' . 'v_frm=' . $v_frm . '&' . 'v_rin=' . $v_rin . '&' . 'v_fuse=' . $v_fuse . '&' . 's_item=' . $s_item . '&' . 's_brand=' . $s_brand . '&' . 's_serial=' . $s_serial . '&' . 'V_BARCODE=' . $V_BAR_EX . '&' . 'V_ITEM=' . $V_ITEM . '&' . 'V_BRAND=' . $V_BRAND . '&' . 'V_SERIAL=' . $V_SERIAL . '&' . 'MESSG=' . $MESSG; if ($v_com == 1) { $url .= "&V_COMU=" . $V_COMU; } if ($meter_out > 0) { $url .= "&meter_out=" . $meter_out; } if ($v_bar_exist == 1) { //$url.="&block_test=1"; if ($v_test_bar_id == -1) { $url .= "&block_test=1"; } } else { /*
echo mysql_query($sql); } */ //$str = strtoupper($str); //if (get_magic_quotes_gpc()) /* MAIN APPLICATION STARTS HERE >>>>>>>>>>>>>>>>>>>>>>>>>> */ //change again hash format into native backslash format. EVERY RECEIVED BARCODE is checked if no hash is there. Every interation is safe to eliminate wrong db format $barcode = swap_hash($_POST["barcode"]); //$barcode=strtoupper($_POST['barcode']); echo '</br> barcode receved from post' . $barcode; $item = $_POST['item']; //Type of Item: DVD, TV $brand = $_POST['brand']; //Company name. JVC $serial = $_POST['serial']; //PART NUMBER $pat = $_POST['pat']; $fun = $_POST['fun']; $cln = $_POST['cln']; $vis = $_POST['vis']; $defect = $_POST['defect']; $rdy = $_POST['rdy']; //if ready to use
function show_site($user_st) { connect_db(); $sql_select = "SELECT * FROM Barcode INNER JOIN Item ON Item.id_item=Barcode.Item_id_item WHERE stock_in=1 AND user_2='{$user_st}' ORDER BY Barcode.date DESC"; //if(isset($_SESSION['site_id_s'])AND $SESSION['site_id_s']>0) //{ $site_id_site = $_SESSION['site_id_s']; $sql_select = "SELECT * FROM Barcode INNER JOIN Item ON Item.id_item=Barcode.Item_id_item WHERE stock_in=1 AND user_2='{$user_st}' AND Site_site_id='{$site_id_site}' ORDER BY Barcode.date DESC"; //} $result = query_select($sql_select); while ($rek = mysql_fetch_array($result)) { $bar_id_test = $rek['id_Barcode']; $sql_test = "SELECT * FROM test WHERE Barcode_id_Barcode='{$bar_id_test}'"; $result_test = mysql_query($sql_test); $rek_test = mysql_fetch_array($result_test); echo "<tr><td>"; echo $rek["Barcode"]; echo "</td><td>"; echo $rek["stock_in"]; echo "</td><td>"; echo $rek["stock_out"]; //echo "sdfsdf"; echo "</td><td>"; echo $rek["Item_id_item"]; echo "</td><td>"; echo $rek["date"]; echo "</td><td>"; echo $rek["name"]; echo "</td><td>"; echo $rek["brand"]; echo "</td><td>"; echo $rek["pn"]; echo "</td><td>"; echo $rek["user_2"]; echo "#"; echo "</td><td>"; echo $rek["Site_site_id"]; echo "</td><td>"; echo "Stocked-in"; if (mysql_num_rows($result_test) > 0) { echo "</td><td>"; echo "Tested"; } else { echo "</td><td>"; $url = "add_barcode.php?test_stock=1&V_BARCODE="; $url .= swap_hash($rek['Barcode']); echo "<a href=" . $url . "> Test it </a>"; } echo "</td></tr>"; } }
VALUES ('$id_item_l','$pre' ) "; //echo mysql_query($insert5); */ if ($rdy == 0) { $update1 = "UPDATE `test` SET `disposal`='1' WHERE `id_test`='{$last_id_t}'"; echo $last_id_t; //echo mysql_query($update1) or die("Blad w zapytaniu!"); } $update2 = "UPDATE `test` SET `state`='{$state1}' WHERE `id_test`='{$last_id_t}'"; // mysql_query($update2) or die("Blad w zapytaniu!"); //that was redireted to sell intem pro the sam form, not good may be mistake here //optional $barcode = swap_hash($barcode); $url = "sell_item.php?test=" . $barcode . "&MESSG=2"; //concat($url,$check); redirect($url, $TEST_T); exit; } ?> <HTML> <HEAD> <link rel="stylesheet" href="layout.css " type="text/css" /> <link href="design.css" rel="stylesheet" type="text/css" /> <link rel="stylesheet" href="design.css" type="text/css" />