asdasd

<?php
/*
  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com/

  this module is (c) Copyright 2007 Zoid Technologies. All Rights Reserved. 
  http://zoidtechnologies.com/
*/

require_once("../includes/configure.php");
require_once("../includes/functions/sessions.php");
require_once("../includes/classes/upload.php");
require_once("../includes/classes/table_block.php");
require_once("../includes/classes/message_stack.php");
require_once("../includes/functions/general.php");
require_once("../includes/functions/database.php");
require_once("../includes/functions/html_output.php");

$messageStack = new messageStack;

class subproduct
{


	function summary()
	{
		$productid = isset($_REQUEST["productid"]) ? intval($_REQUEST["productid"]) : 0;
		if ($productid ==0)
		{
			$productid = isset($_REQUEST["pID"]) ? intval($_REQUEST["pID"]) : 0;
		}
		
              $query = tep_db_query("select * from family_product where products_id='" . (int)$productid . "'");

		print "<table border='1'>";
		print "<tr><th>image</th><th>description</th><th>price</th><th>shipping</th><th>Model</th><th>Blades</th><th>Edit and Delete</th></tr>"; 
		while (($result = tep_db_fetch_array($query)) !== false)
		{
			print "<tr>";
			print sprintf("<td><img src='%s%s%s' width='225px'></td><td>%s</td><td>%5.2f</td><td>%5.2f</td><td>%s</td><td>%s</td><td><a href=\"?action=delete&subproductid=%s&productid=%s\">Delete</a></td>", HTTP_CATALOG_SERVER, DIR_WS_IMAGES, $result["family_picture"], $result["family_desc"], $result["family_price"], $result["family_shipping"], $result["family_model"], $result["family_blades"], $result["subproductid"], $productid); 
			print "</tr>";
		}
		print "</table>";
	}

	function add()
	{


$blades[] = array('id' => '+blades', 'text' => '+Blades');
$blades[] = array('id' => 'null', 'text' => 'null');


		$productid = isset($_REQUEST["productid"]) ? intval($_REQUEST["productid"]) : 0;

		print "<html>\n";
		print "<head>\n";
		print "<title>add subproduct</title>\n";
		print "<script type='text/javascript' src='subproduct.js'></script>\n";
		print "</head>\n";
		print "<body>\n";
		print "<form name='subproductform' method='post' action='subproduct.php' enctype='multipart/form-data'>\n";
		print "<input type='hidden' name='action' value='insert' />\n";
		print "<input type='hidden' name='productid' value='{$productid}' />\n";
		print "<table bgcolor='#A0A0A0'>\n";
		print "<tr>\n";
		print "<td class='main'>family image</td>\n";
		print "<td class='main'>" . tep_draw_file_field("family_picture") . "</td>\n";
		print "</tr>\n";
		print "<tr>\n";
		print "<td class='main'>family Pic Large for Popup</td>\n";
		print "<td class='main'>" . tep_draw_file_field("family_pic_large") . "</td>\n";
		print "</tr>\n";
		print "<tr>\n";
		print "<td class='main'>family desc</td>\n";
		print "<td class='main' style='border: 1px solid black'>" . tep_draw_textarea_field("family_desc", "soft", "70", "15", "description") . "</td>\n";
		print "</tr>\n";
		print "<tr>\n";
		print "<td class='main'>family price</td>\n";
		print "<td class='main'>" . tep_draw_input_field("family_price", 0) . "</td>\n";
		print "</tr>\n";
		print "<tr>\n";
		print "<td class='main'>family shipping</td><td class='main'>" . tep_draw_input_field("family_shipping", 0) . "</td>\n";
		print "</tr>\n";
		print "<tr>\n";
		print "<td class='main'>Family Model</td>\n";
		print "<td class='main'>" . tep_draw_input_field("family_model") . "</td>\n";
		print "</tr>\n";
		print "<td class='main'>Family Blades</td>\n";
		print "<td class='main'>" . tep_draw_pull_down_menu('family_blades', $blades) . "</td>\n";
		print "</tr>\n";
		print "<tr><td><input type='submit' value='save'></td></tr>\n";
		print "</table>\n";
		print "</form>\n";
		print "<div id='subproductlist'></div>";
		$this->summary();
		print "</body>\n";
		print "</html>\n";


	}

function delete()
{

		$subproductid = isset($_REQUEST["subproductid"]) ? intval($_REQUEST["subproductid"]) : 0;
		if ($subproductid ==0)
		{
			$subproductid = isset($_REQUEST["pID"]) ? intval($_REQUEST["pID"]) : 0;
		}

//var_dump($_REQUEST);
// Do delete statement. 
 $query = tep_db_query("delete * from family_product where products_id='" . (int)$productid . "'");


$productid = isset($_REQUEST["productid"]) ? intval($_REQUEST["productid"]) : 0;


tep_redirect("subproduct.php?action=add&productid={$productid}");

}


Function edit()
{

		$subproductid = isset($_REQUEST["subproductid"]) ? intval($_REQUEST["subproductid"]) : 0;
		if ($subproductid ==0)
		{
			$subproductid = isset($_REQUEST["pID"]) ? intval($_REQUEST["pID"]) : 0;
		}
               
                   

$query = tep_db_query("select * from family_product where subproductid='" . (int)$subproductid . "'");
$row = mysql_fetch_assoc($query);
print_r($row);




$blades[] = array('id' => '+blades', 'text' => '+Blades');
$blades[] = array('id' => 'null', 'text' => 'null');



		print "<html>\n";
		print "<head>\n";
		print "<title>edit subproduct</title>\n";
		print "<script type='text/javascript' src='subproduct.js'></script>\n";
		print "</head>\n";
		print "<body>\n";
		print "<form name='subproductform' method='post' action='subproduct.php' enctype='multipart/form-data'>\n";
		print "<input type='hidden' name='action' value='update' />\n";
		print "<input type='hidden' name='subproductid' value='{$subproductid}' />\n";
		print "<table bgcolor='#A0A0A0'>\n";
		print "<tr>\n";
		print "<td class='main'>family image</td>\n";
		print "<td class='main'>" . tep_draw_file_field("family_picture") ." press browse to change small picture: $row[family_picture]</td>\n";
		print "</tr>\n";
		print "<tr>\n";
		print "<td class='main'>family Pic Large for Popup</td>\n";
		print "<td class='main'>" . tep_draw_file_field("family_pic_large") ." press browse to change large picture: $row[family_pic_large]</td>\n";
		print "</tr>\n";
		print "<tr>\n";
		print "<td class='main'>family desc</td>\n";
		print "<td class='main' style='border: 1px solid black'>" . tep_draw_textarea_field("family_desc", "soft", "70", "15", "$row[family_desc]") . "</td>\n";
		print "</tr>\n";
		print "<tr>\n";
		print "<td class='main'>family price</td>\n";
		print "<td class='main'>" . tep_draw_input_field("family_price", "$row[family_price]", 0) . "</td>\n";
		print "</tr>\n";
		print "<tr>\n";
		print "<td class='main'>family shipping</td><td class='main'>" . tep_draw_input_field("family_shipping", "$row[family_shipping]", 0) . "</td>\n";
		print "</tr>\n";
		print "<tr>\n";
		print "<td class='main'>Family Model</td>\n";
		print "<td class='main'>" . tep_draw_input_field("family_model", "$row[family_model]") . "</td>\n";
		print "</tr>\n";
		print "<td class='main'>Family Blades</td>\n";
		print "<td class='main'>" . tep_draw_pull_down_menu('family_blades', $blades) . "</td>\n";
		print "</tr>\n";
		print "<tr><td><input type='submit' value='save'></td></tr>\n";
		print "</table>\n";
		print "</form>\n";
		print "<div id='subproductlist'></div>";
		$this->summary();
		print "</body>\n";
		print "</html>\n";


	}

	function update()
	{
		global $messageStack, $HTTP_POST_VARS, $HTTP_GET_VARS;

		$subproductid = isset($_POST["subproductid"]) ? intval($_POST["subproductid"]) : 0;

 $productid = isset($_REQUEST["productid"]) ? intval($_REQUEST["productid"]) : 0;

		$image = new upload("family_picture");
        $image->set_destination(DIR_FS_CATALOG_IMAGES);
        if ($image->parse() && $image->save()) 
        {
          $image = $image->filename;
        } 
        else 
        {
        	var_dump($messageStack);
        	return;
        }

	$image_x = new upload("family_pic_large");
        $image_x->set_destination(DIR_FS_CATALOG_IMAGES);
        if ($image_x->parse() && $image_x->save()) 
        {
          $image_x = $image_x->filename;
        } 
        else 
        {
        	var_dump($messageStack);
        	return;
        }
//          var_dump($image_x);
       var_dump($HTTP_POST_VARS);
        $dat = array("products_id" => (int)tep_db_prepare_input($subproductid), 
        	"family_picture" => $image,
                "family_pic_large" => $image_x,  
        	"family_desc" => tep_db_prepare_input($HTTP_POST_VARS["family_desc"]), 
        	"family_price" => tep_db_prepare_input($HTTP_POST_VARS["family_price"]), 
			"family_model" => tep_db_prepare_input($HTTP_POST_VARS["family_model"]),
                        "family_blades" => tep_db_prepare_input($HTTP_POST_VARS["family_blades"]), 
        	"family_shipping" => tep_db_prepare_input($HTTP_POST_VARS["family_shipping"]));
			
        tep_db_perform("family_product", $dat, "update");
        tep_redirect("subproduct.php?action=add&productid={$productid}");
        return;
	}



	function insert()
	{
		global $messageStack, $HTTP_POST_VARS, $HTTP_GET_VARS;

		$productid = isset($_POST["productid"]) ? intval($_POST["productid"]) : 0;

		$image = new upload("family_picture");
        $image->set_destination(DIR_FS_CATALOG_IMAGES);
        if ($image->parse() && $image->save()) 
        {
          $image = $image->filename;
        } 
        else 
        {
        	var_dump($messageStack);
        	return;
        }

	$image_x = new upload("family_pic_large");
        $image_x->set_destination(DIR_FS_CATALOG_IMAGES);
        if ($image_x->parse() && $image_x->save()) 
        {
          $image_x = $image_x->filename;
        } 
        else 
        {
        	var_dump($messageStack);
        	return;
        }
//          var_dump($image_x);
//        var_dump($HTTP_POST_VARS);
        $dat = array("products_id" => (int)tep_db_prepare_input($productid), 
        	"family_picture" => $image,
                "family_pic_large" => $image_x,  
        	"family_desc" => tep_db_prepare_input($HTTP_POST_VARS["family_desc"]), 
        	"family_price" => tep_db_prepare_input($HTTP_POST_VARS["family_price"]), 
			"family_model" => tep_db_prepare_input($HTTP_POST_VARS["family_model"]),
                        "family_blades" => tep_db_prepare_input($HTTP_POST_VARS["family_blades"]), 
        	"family_shipping" => tep_db_prepare_input($HTTP_POST_VARS["family_shipping"]));
			
        tep_db_perform("family_product", $dat, "insert");
        tep_redirect("subproduct.php?action=add&productid={$productid}");
        return;
	}
	
	function main()
	{
		tep_db_connect();
		$action = isset($_REQUEST["action"]) ? $_REQUEST["action"] : null;

		switch ($action)
		{
			case "summary":
				$this->summary();
				break;
			case "add":
				$this->add();
				break;
			case "insert":
				$this->insert();
				break;
                        case "delete":
				$this->delete();
				break;
                        case "edit":
				$this->edit();
				break;
                        case "update":
				$this->update();
				break;

			default:
				print "unknown mode";
				break;
		}
		tep_db_close();
	}
}

$sp = new subproduct();
$sp->main();


?>