Plaincart :: adding PDF Brochure upload

[gi_canuck]

Hello I've been playing around with the plaincart from http://www.phpwebcommerce.com/  and so far it works great.  I am currently just trying it out to display products / product info only.  I was wondering if anyone could show me how to add a function to upload a PDF Brochure for the product... I guess I could just modify the image upload script (minus the thumbnail), but so far I wasn't quite successful.  Basically I just need to change the "processProduct.php"

 

 

_<?php

_{require_once '../../library/config.php';}

_{require_once '../library/functions.php';}

 

_checkUser();

 

_{$action = isset($_GET['action']) ? $_GET['action'] : '';}

 

_{switch ($action) {}

 

_{case 'addProduct' :}

_{addProduct();}

_break;

 

_{case 'modifyProduct' :}

_{modifyProduct();}

_break;

 

_{case 'deleteProduct' :}

_{deleteProduct();}

_break;

 

_{case 'deleteImage' :}

_{deleteImage();}

_break;

   

 

_{default :}

    _{// if action is not defined or unknown}

_{// move to main product page}

_{header('Location: index.php');}

_}

 

 

_{function addProduct()}

_{

    _{$catId      = $_POST['cboCategory'];}

    _{$name        = $_POST['txtName'];}

_{$description = $_POST['mtxDescription'];}

_{$price      = str_replace(',', '', (double)$_POST['txtPrice']);}

_{$qty        = (int)$_POST['txtQty'];}

 

_{$images = uploadProductImage('fleImage', SRV_ROOT . 'images/product/');}

 

_{$mainImage = $images['image'];}

_{$thumbnail = $images['thumbnail'];}

 

_{$sql  = "INSERT INTO tbl_product (cat_id, pd_name, pd_description, pd_price, pd_qty, pd_image, pd_thumbnail, pd_date)}

          _{VALUES ('$catId', '$name', '$description', $price, $qty, '$mainImage', '$thumbnail', NOW())";}

 

_{$result = dbQuery($sql);}

 

_{header("Location: index.php?catId=$catId");}

_}

 

_/*

_{Upload an image and return the uploaded image name}

_*/

_{function uploadProductImage($inputName, $uploadDir)}

_{

_{$image    = $_FILES[$inputName];}

_{$imagePath = '';}

_{$thumbnailPath = '';}

 

_{// if a file is given}

_{if (trim($image['tmp_name']) != '') {}

_{$ext = substr(strrchr($image['name'], "."), 1); //$extensions[$image['type']];}

 

_{// generate a random new file name to avoid name conflict}

_{$imagePath = md5(rand() * time()) . ".$ext";}

 

_{list($width, $height, $type, $attr) = getimagesize($image['tmp_name']);}

 

_{// make sure the image width does not exceed the}

_{// maximum allowed width}

_{if (LIMIT_PRODUCT_WIDTH && $width > MAX_PRODUCT_IMAGE_WIDTH) {}

_{$result    = createThumbnail($image['tmp_name'], $uploadDir . $imagePath, MAX_PRODUCT_IMAGE_WIDTH);}

_{$imagePath = $result;}

_{} else {}

_{$result = move_uploaded_file($image['tmp_name'], $uploadDir . $imagePath);}

_}

 

_{if ($result) {}

_{// create thumbnail}

_{$thumbnailPath =  md5(rand() * time()) . ".$ext";}

_{$result = createThumbnail($uploadDir . $imagePath, $uploadDir . $thumbnailPath, THUMBNAIL_WIDTH);}

 

_{// create thumbnail failed, delete the image}

_{if (!$result) {}

_{unlink($uploadDir . $imagePath);}

_{$imagePath = $thumbnailPath = '';}

_{} else {}

_{$thumbnailPath = $result;}

_}

_{} else {}

_{// the product cannot be upload / resized}

_{$imagePath = $thumbnailPath = '';}

_}

 

_}

 

 

_{return array('image' => $imagePath, 'thumbnail' => $thumbnailPath);}

_}

 

_/*

_{Modify a product}

_*/

_{function modifyProduct()}

_{

_{$productId  = (int)$_GET['productId'];}

    _{$catId      = $_POST['cboCategory'];}

    _{$name        = $_POST['txtName'];}

_{$description = $_POST['mtxDescription'];}

_{$price      = str_replace(',', '', $_POST['txtPrice']);}

_{$qty        = $_POST['txtQty'];}

 

_{$images = uploadProductImage('fleImage', SRV_ROOT . 'images/product/');}

 

_{$mainImage = $images['image'];}

_{$thumbnail = $images['thumbnail'];}

 

_{// if uploading a new image}

_{// remove old image}

_{if ($mainImage != '') {}

_{_deleteImage($productId);}

 

_{$mainImage = "'$mainImage'";}

_{$thumbnail = "'$thumbnail'";}

_{} else {}

_{// if we're not updating the image}

_{// make sure the old path remain the same}

_{// in the database}

_{$mainImage = 'pd_image';}

_{$thumbnail = 'pd_thumbnail';}

_}

 

_{$sql  = "UPDATE tbl_product}

          _{SET cat_id = $catId, pd_name = '$name', pd_description = '$description', pd_price = $price,}

      _{pd_qty = $qty, pd_image = $mainImage, pd_thumbnail = $thumbnail}

  _{WHERE pd_id = $productId";} 

 

_{$result = dbQuery($sql);}

 

_{header('Location: index.php');}  

_}

 

_/*

_{Remove a product}

_*/

_{function deleteProduct()}

_{

_{if (isset($_GET['productId']) && (int)$_GET['productId'] > 0) {}

_{$productId = (int)$_GET['productId'];}

_{} else {}

_{header('Location: index.php');}

_}

 

_{// remove any references to this product from}

_{// tbl_order_item and tbl_cart}

_{$sql = "DELETE FROM tbl_order_item}

        _{WHERE pd_id = $productId";}

_{dbQuery($sql);}

 

_{$sql = "DELETE FROM tbl_cart}

        _{WHERE pd_id = $productId";}

_{dbQuery($sql);}

 

_{// get the image name and thumbnail}

_{$sql = "SELECT pd_image, pd_thumbnail}

        _{FROM tbl_product}

_{WHERE pd_id = $productId";}

 

_{$result = dbQuery($sql);}

_{$row    = dbFetchAssoc($result);}

 

_{// remove the product image and thumbnail}

_{if ($row['pd_image']) {}

_{unlink(SRV_ROOT . 'images/product/' . $row['pd_image']);}

_{unlink(SRV_ROOT . 'images/product/' . $row['pd_thumbnail']);}

_}

 

_{// remove the product from database;}

_{$sql = "DELETE FROM tbl_product}

        _{WHERE pd_id = $productId";}

_{dbQuery($sql);}

 

_{header('Location: index.php?catId=' . $_GET['catId']);}

_}

 

 

_/*

_{Remove a product image}

_*/

_{function deleteImage()}

_{

_{if (isset($_GET['productId']) && (int)$_GET['productId'] > 0) {}

_{$productId = (int)$_GET['productId'];}

_{} else {}

_{header('Location: index.php');}

_}

 

_{$deleted = _deleteImage($productId);}

 

_{// update the image and thumbnail name in the database}

_{$sql = "UPDATE tbl_product}

_{SET pd_image = '', pd_thumbnail = ''}

_{WHERE pd_id = $productId";}

_{dbQuery($sql);}

 

_{header("Location: index.php?view=modify&productId=$productId");}

_}

 

_{function _deleteImage($productId)}

_{

_{// we will return the status}

_{// whether the image deleted successfully}

_{$deleted = false;}

 

_{$sql = "SELECT pd_image, pd_thumbnail}

        _{FROM tbl_product}

_{WHERE pd_id = $productId";}

_{$result = dbQuery($sql) or die('Cannot delete product image. ' . mysql_error());}

 

_{if (dbNumRows($result)) {}

_{$row = dbFetchAssoc($result);}

_{extract($row);}

 

_{if ($pd_image && $pd_thumbnail) {}

_{// remove the image file}

_{$deleted = @unlink(SRV_ROOT . "images/product/$pd_image");}

_{$deleted = @unlink(SRV_ROOT . "images/product/$pd_thumbnail");}

_}

_}

 

_{return $deleted;}

_}

 

 

 

 

_?>

 

 

This is the processProduct.php script...  Any help will be greatly appreciated... Thank you very much!!