Exemplo n.º 1
0
  //  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 {
    /*
Exemplo n.º 2
0
	 
  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
Exemplo n.º 3
0
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>";
    }
}
Exemplo n.º 4
0
    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" />