extension_add.php

<?php
session_start();

include 'header_valid.php';
include 'header_mysql.php';
include 'functions_manifest.php';
connect_db();

$sub_cat_counter=150;

//processing of change atts



function extension_list()
{
    $sql="SELECT id_item_cat, weight, cat, sub_cat, name
FROM  `item_has_cat` 
INNER JOIN item ON Item.Item_has_Cat_id_item_cat = Item_has_cat.id_item_cat
GROUP BY id_item_cat";
    
    $result=mysql_query($sql);
    
    //$rek=mysql_fetch_array($result);
    //return $rek;
    
    return $result;
}


for($d=0;$d<$sub_cat_counter;$d++)
{
    $name_change="change".$d;
    if(isset($_POST[$name_change]))
    {
        
        echo "submit".$name_change;
        if(!empty($_POST['atts']))
        {
            echo "SUB ";
         echo $id_c=$_POST['sub_cat'];   
            
         echo $atts=$_POST['atts'];
         
         //here we insert
         
         $sql="UPDATE sub_cat SET atts='$atts' WHERE id_c='$id_c'";
         query_select($sql);
       
        }
    }
    if(isset($_POST['item_types']))
    {
        echo "Item types ";
          echo $id_c=$_POST['sub_cat'];   
            
         echo $itemtypes=$_POST['item_types'];
        
         $sql="UPDATE sub_cat SET item_type='$itemtypes' WHERE id_c='$id_c'";
         query_select($sql);
    }
    
    
   // echo $name_change."</BR>";

}















//fixing bug if form set once. Seems to solve problem. Item only doesnt apper on the bottom

if(isset($_POST['Submit']))
{
    redirect("categories_add.php",0);
    
    
}



function redirect($gdzie, $czas)
{
    echo "<head><meta http-equiv=\"Refresh\" content=\"$czas; URL=$gdzie\" /></head>";
}

function dup_row($count)
{
 if($count="0")
   return 0;    
 else
 {
     
 }   
}
function test_string($rek)
{
if($rek=='1')
  $result="Yes";
 else
  $result="No";
	
	return $result ;
}

function add_db($sql)
{
	 
	 
   $result=mysql_query($sql) or die(mysql_error());
	return $result;
}

$barcode=$_POST['barcode'];
$item=$_POST['item'];
$brand=$_POST['brand'];
$serial=$_POST['serial'];
$pat=$_POST['pat'];
$fun=$_POST['fun'];
$cln=$_POST['cln'];
$vis=$_POST['vis'];
$defect=$_POST['defect'];
$rdy=$_POST['rdy'];

$connect=mysql_connect('localhost','root','krasnal')
  or die(mysql_error());

mysql_select_db('dbs3');


$sql='SELECT Name_sub,sub_cat.kind,weight,name_cat,category.id,id_c FROM Sub_cat'
         //. ' INNER JOIN Origin ON Origin.origin_id= Site.Origin_origin_id'
         . ' INNER JOIN Weight ON Weight.id=Sub_cat.Weight_id'
         . ' INNER JOIN Category ON Category.id=Sub_cat.Category_id';


$sql="SELECT * FROM weee_extension";


$result=add_db($sql);


    
    
$sql_cat_read="SELECT * FROM Category";
//$sql_cat="INSERT INTO Weight(weight) Values('$weight')";

$result_sub=add_db($sql_cat_read);    
$count_cat=0;		
while($rek1 = mysql_fetch_array($result_sub,1))  
   {
     $i++; 
     $count_cat++;
    // $users[$i]=$rek["post_code"];    
     $names[$i]=$rek1["name_cat"];
     $origin[$i]=$rek1["id"];
     //$batch_date[$i]=$rek["batch_date"];  
    // echo $users[$i].$names[$i];
   }
  /// echo "Nie ustalono site place ani zmienna ani przekazanie";		
		

$weight=$_POST["batch_date"];
$name_sub_cat=$_POST['name_sub_cat'];
$name_cat=$_POST['site_location'];

///echo $weight;
///echo "Name_sub";
///echo $name_sub_cat;
?>
<HTML>
<HEAD>

<link rel="stylesheet" href="layout.css " type="text/css">
<link rel="stylesheet" href="form_cat.css " type="text/css">
</HEAD>
<BODY>

<div id="banner">

<IMG SRC="weee/WEEE%20Collection%20v3_html_m5ab1a91a.jpg" WIDTH=180 HEIGHT=151 align="right">
<BR><BR>
<IMG SRC="weee/WEEE%20Collection%20v3_html_m6a98edc9.jpg" WIDTH=449 HEIGHT=51 HSPACE=3 VSPACE=3>
<BR>
</div>
</BR></BR>

<div id="tabel_wrap_out"></BR>
    </br>
    <center><p style=""><h3>WEEE extention item list </h3></p></center>
    </br>
    
    
<table id="tabel_out" border="1"  >


    
<tr><td>ID WEEE ext.</td><td>Item type</td><td>WEEE Extension</td><td></td><td>Weight category</td></tr>
<?php




$tab = array();
for($z=0;$z<=1000;$z++)
   $tab[$z]=0;

while($rek = mysql_fetch_array($result,MYSQL_BOTH)) { //changed from 1 
   $i++;  
   //if($tab[$rek["id_test"]]<'1')
   //{
   echo "<form action='sub_cat_revise.php' method='POST'>";
   echo '<tr style="bgcolor:whitesmoke;"><td>'.$rek[0].'</td>'; 
	 echo '<td>'.$rek[1].'</td>';
	 echo '<td>'.$rek[2].'</td>';
	   
	 //echo '<td>'.$rek["sum_weight"].'</td>';
	// echo '<td>'.$rek["Name_sub"].'</td>';
          //echo '<input type="hidden" name="nr" value="'.$i.'">'; 
           echo '<input type="hidden" name="submitted" value="1" >';
           echo '<input type="hidden" name="sub_cat'.$i.'" value="'.$rek['id_c'].'">';       
          
           //echo "<td><input type='Submit' name='revise".$i."' value='revision'></td>";
           //header("Location: sub_cat_revise.php");
          echo $att= manifest_dbi_get_att_sub_cat($rek['id_c']);
          // echo '<td>';
           
           echo '<td>';
           //each time take one selected
           echo "</form>";
           echo '<form action="extension_add.php" method="POST">';
           echo '<td>';
           $selected=manifest_dbi_get_att_name(manifest_dbi_get_att_sub_cat($id_c)); //selected one
           $id_c=$rek['id_c'];
           
           
           $ext_list=extension_list();
           
           echo '<select name="atts">';
           for($z=0;$z<=53;$z++)
           {
               $rek_list=mysql_fetch_array($ext_list);
               
               
               if($rek_list[0]==$rek[2])
                    echo '<option value="'.$z.'" selected >'.$rek_list[4].'</option>';
               else           
           echo '<option value="'.$z.'" >'.$rek_list[4].'</option>';
           }
           echo '</select>';
           echo '</td>';
           echo '<input type="hidden" name="sub_cat" value="'.$id_c.'">';
           
           
          // echo '<td>';
           //item types
           
           /*
           echo '<select name="item_types">';
           for($z=0;$z<=manifest_dbi_number_elements_item_types();$z++)
           {
               if(manifest_dbi_get_item_type_sub_cat($id_c)==$z)
                    echo '<option value="'.$z.'" selected >'.  manifest_dbi_get_item_type_name($z).'</option>';
               else   
           echo '<option value="'.$z.'" >'.  manifest_dbi_get_item_type_name($z).'</option>';
           }
           echo '</select>';
           
            * echo '</td>';
            */
          // echo '<td>';
          // echo '<input type="text" name="att'.$i.'" value="'.$att.'">';
         //  echo '</td>';
           echo '<td>';
           echo '<input type="Submit" name="change'.$i.'" value="Change">';
           echo '</td>';
         echo '</form>';
           echo '</td>';
	   echo '</tr>';
     //}
  
	  //$tab[$rek["id_test"]]+=1;
}
  


$add_new=1;
if($add_new==1)
{
    
    
    
    
    //echo "w funkcji";
$sql='INSERT INTO Sub_cat'
         //. ' INNER JOIN Origin ON Origin.origin_id= Site.Origin_origin_id'
         . ' INNER JOIN Weight ON Weight.id=Sub_cat.Weight_id'
         . ' INNER JOIN Category ON Category.id=Sub_cat.Category_id';

//$weight=$batch_date;
$name_cat;
$name_sub_cat;


$sql_transaction="BEGIN
INSERT INTO Weight(weight) 
  VALUES('$weight');
  set v_weight_id = last_insert_id();
INSERT INTO Category (name_cat) 
  VALUES('$name_cat');

INSERT INTO Sub_cat (Category_id, Weight_id) 
  VALUES(LAST_INSERT_ID(),v_weight_id,'$name_sub_cat');

COMMIT";





$weight=$_POST['batch_date'];
$name_sub_cat=$_POST['name_sub_cat'];
$name_cat=$_POST['site_location'];
//echo $weight;

if(!empty($_POST['batch_date'])AND !empty($_POST['name_sub_cat'])AND !empty($_POST['site_location']))
{
$sql_weight="INSERT INTO Weight(weight) Values('$weight')";
$result=add_db($sql_weight);

$we=mysql_insert_id();
//echo $we;
$sql_cat_read="SELECT * FROM Category";

$sql_cat="INSERT INTO Sub_cat(Category_id,Weight_id,Name_sub,kind) Values('$name_cat','$we','$name_sub_cat','2')";

$result=add_db($sql_cat);
}


/**
 * $result=add_db($sql_cat_read);
 *      while($rek=mysql_fetch_array($result))
 *      {
 *           
 *      }
 */


$weight=0;
$name_sub_cat=0;
unset($weight);
unset($name_sub_cat);

///A place for code of categories
























//$result=add_db($sql_subcat);
//if($result)
// echo "Dodano tranzakcje";
}

?>


</table>
    </BR>
    
    
    
 <?php
 
 /*
echo "<center><form action='categories_add.php' method='POST'>";



echo "Category";

echo '<select style="padding:10px;margin:10px" name="site_location" size="1" autofocus>';

for($z=0;$z<=$count_cat;$z++)
{
  echo '<option value="'.$origin[$z].'">'.$names[$z].'</option>';

}
echo '</select>';

 

//switched
echo '<input style="padding:10px;margin:10px" type="text" placeholder="Weight" name="batch_date" value="'.htmlentities($weight).'">';
echo '<input style="padding:10px;margin:10px" type="text" placeholder="Item type" name="name_sub_cat" value="'.htmlentities($name_sub_cat).'">';


echo '<input type="hidden" name="submitted" value="1" >';


echo "<input style='padding:10px;margin:10px' type='submit' name='Submit' value='Add an item to manifest' align='right'>";

 echo "</form>";
 echo "</table></center>"; 

 //fixing bug - no infinit loop
 //redirect("categories.php",0);
 
  
  */
 
?>   
        
    
    
    
    
    
    
    
    
    
    
    
    
</div> 

  

    
    
    
    
    
    
    
    
    
    
    
<div id="buttons_out"> 
  <h4>
  
  
 <p class="submit">  
      <a href="index.php"> <button class="submit">Return</button> </a> 
      
    </p>  


</h4>       
</div>
<?php
/*
$sql = "SELECT *FROM Sub_cat INNER JOIN Category ON Category.id = Sub_cat.Category_id INNER JOIN Weight ON Weight.id = Sub_cat.Weight_id";
$sql1= "SELECT name_cat,type_2 from Category";

$serwer="localhost";
$login="root";
$haslo="krasnal";
$baza="scm";
 
     

    if (mysql_connect($serwer, $login, $haslo) and mysql_select_db($baza)) { 
         
        $wynik = mysql_query($sql1) 
        or die("Blad w zapytaniu!"); 
         
        mysql_close(); 
    } 
    else echo "Cannot Connect"; 



echo " <table border='1' > <tr><td>CATEGORY OF WEEE COLLECTED</td><td>WEIGHT (In Kg)</td></tr>";

$i=0;
while($rek = mysql_fetch_array($wynik,1)) { 
   $i++;  
   echo "<tr><td>Category ".$rek["type_2"].". ".$rek["name_cat"]."</td><td> ".$tab[$i]." </td></tr>"; 
}


//while($rek = mysql_fetch_array($wynik,1)) { 
  //  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> "
*/
?>
<br><BR>
<?php
//<IMG SRC="weee/WEEE%20Collection%20v3_html_594f4c37.jpg" WIDTH=642 HEIGHT=127>
?>
</BODY>
</HTML>