Help with Cart Issue

General PHP Help
#1

Hi There,

I am trying to add pictures to a print order page for a shopping cart, I am having a heck of a time figuring out the code for this modification, any help would be greatly appreciated!!

[php]<?php
/*
±-------------------------------------------------------------------------
| CubeCart v3
| ========================================
| by Alistair Brookbanks
| CubeCart is a Trade Mark of Devellion Limited
| Copyright Devellion Limited 2005 - 2006. All rights reserved.
| Devellion Limited,
| 5 Bridge Street,
| Bishops Stortford,
| HERTFORDSHIRE.
| CM23 2JU
| UNITED KINGDOM
| http://www.devellion.com
| UK Private Limited Company No. 5323904
| ========================================
| Web: http://www.cubecart.com
| Date: Tuesday, 17th July 2007
| Email: sales (at) cubecart (dot) com
| License Type: CubeCart is NOT Open Source Software and Limitations Apply
| Licence Info: http://www.cubecart.com/site/faq/license.php
±-------------------------------------------------------------------------
| orderForm.inc.php
| ========================================
| Makes Printable Order Form
±-------------------------------------------------------------------------
*/

// INCLUDE CORE VARIABLES & FUNCTIONS
include_once("../../../includes/global.inc.php");

// initiate db class
include_once("../../../classes/db.inc.php");
$db = new db();

include_once("../../../includes/functions.inc.php");

$config = fetchDbConfig("config");

$module = fetchDbConfig("Print_Order_Form");

// get session data
include_once("../../../includes/sessionStart.inc.php");
include_once("../../../includes/session.inc.php");

// initiate basket
include_once("../../../classes/cart.php");

$lang_folder = "";

if(empty($ccUserData[0]['lang'])){
	$lang_folder = $config['defaultLang'];
} else {
	$lang_folder = $ccUserData[0]['lang'];
}
include_once("../../../language/".$lang_folder."/lang.inc.php");

$cart = new cart();
$basket = $cart->cartContents($ccUserData[0]['basket']);

// get exchange rates etc override users curency if need be
if($module['multiCurrency']==0){
	$ccUserData[0]['currency'] = $config['defaultCurrency'];
}
include_once("../../../includes/currencyVars.inc.php");

// require template class
include_once("../../../classes/xtpl.php");

$print_order_form = new XTemplate("orderForm.tpl");

$result = $db->select("SELECT * FROM ".$glob['dbprefix']."CubeCart_order_sum INNER JOIN ".$glob['dbprefix']."CubeCart_customer ON ".$glob['dbprefix']."CubeCart_order_sum.customer_id = ".$glob['dbprefix']."CubeCart_customer.customer_id WHERE ".$glob['dbprefix']."CubeCart_order_sum.cart_order_id = ".$db->mySQLSafe($basket['cart_order_id']));

if($result == FALSE){
	header("Location: ".$glob['rootRel']."cart.php?cart.php&act=step2");
	exit;
}
include_once("../../../language/".$config['defaultLang']."/config.inc.php");
$print_order_form->assign("VAL_ISO",$charsetIso);

$print_order_form->assign("VAL_STORE_NAME",$config['storeName']);
$print_order_form->assign("VAL_STORE_URL",$glob['storeURL']);
$print_order_form->assign("LANG_INVOICE_TO",$lang['printOrderForm']['invoiceTo']);
$print_order_form->assign("VAL_INVOICE_NAME",$result[0]['name']);
$print_order_form->assign("VAL_INVOICE_ADD1",$result[0]['add_1']);
$print_order_form->assign("VAL_INVOICE_ADD2",$result[0]['add_2']);
$print_order_form->assign("VAL_INVOICE_TOWN",$result[0]['town']);
$print_order_form->assign("VAL_INVOICE_STATE",$result[0]['county']);
$print_order_form->assign("VAL_INVOICE_POSTCODE",$result[0]['postcode']);
$print_order_form->assign("VAL_INVOICE_COUNTRY",countryName($result[0]['country']));

$print_order_form->assign("LANG_DELIVER_TO",$lang['printOrderForm']['deliverTo']);
$print_order_form->assign("VAL_DELIVER_NAME",$result[0]['name_d']);
$print_order_form->assign("VAL_DELIVER_ADD1",$result[0]['add_1_d']);
$print_order_form->assign("VAL_DELIVER_ADD2",$result[0]['add_2_d']);
$print_order_form->assign("VAL_DELIVER_TOWN",$result[0]['town_d']);
$print_order_form->assign("VAL_DELIVER_STATE",$result[0]['county_d']);
$print_order_form->assign("VAL_DELIVER_POSTCODE",$result[0]['postcode_d']);
$print_order_form->assign("VAL_DELIVER_COUNTRY",$result[0]['country_d']);
	  
$print_order_form->assign("LANG_INVOICE_RECIEPT_FOR",$lang['printOrderForm']['postalOrderFor']);
$print_order_form->assign("LANG_ORDER_OF_TIME",$lang['printOrderForm']['orderOf']);
$print_order_form->assign("VAL_TIME_DATE",formatTime($result[0]['time']));
$print_order_form->assign("LANG_CART_ORDER_ID",$lang['printOrderForm']['orderID']);
$print_order_form->assign("VAL_CART_ORDER_ID",$basket['cart_order_id']);

$print_order_form->assign("LANG_PRODUCT",$lang['printOrderForm']['product']);
$print_order_form->assign("LANG_PRODUCT_CODE",$lang['printOrderForm']['code']);
$print_order_form->assign("LANG_QUANTITY",$lang['printOrderForm']['qty']);
$print_order_form->assign("LANG_PRICE",$lang['printOrderForm']['price']);



// repeat products 
$results = $db->select("SELECT * FROM ".$glob['dbprefix']."CubeCart_order_inv WHERE cart_order_id = ".$db->mySQLSafe($basket['cart_order_id']));
// start mod: Text Input Fields for Products, by Estelle
$textinput_config = fetchDbConfig("Text_Input_Mod");
if ($textinput_config['status']) {
	$textinputs = $db->select("SELECT * FROM ".$glob['dbprefix']."CubeCart_mod_textinput_order_inv, ".$glob['dbprefix']."CubeCart_order_inv as oi WHERE oi.id=order_inv_id AND cart_order_id=".$db->mySQLSafe($basket['cart_order_id']));
}
// end mod: Text Input Fields for Products, by Estelle

for($i=0;$i<count($results);$i++){
	$print_order_form->assign("VAL_PRODUCT_NAME",$results[$i]['name']);
	$print_order_form->assign("LANG_IMAGE",$results['printOrderForm']['image']);
	$print_order_form->assign("VAL_PRODUCT_OPTS",$results[$i]['product_options']);
	$print_order_form->assign("VAL_PRODUCT_CODE",$results[$i]['productCode']);
	$print_order_form->assign("VAL_PRODUCT_QUANTITY",$results[$i]['quantity']);
	$print_order_form->assign("VAL_PRODUCT_PRICE",priceFormat($results[$i]['price']));
	// start mod: Text Input Fields for Products, by Estelle
	if ($textinput_config['status']) {
		$text_input_string = "";
		for ($j=0; $j<count($textinputs); $j++) {
			if ($textinputs[$j]['order_inv_id'] == $results[$i]['id']) {
				$text_input_string .= $textinputs[$j]['title'].": ".nl2br(validHTML($textinputs[$j]['value']))."<br/>";
			}
		}
		if (empty($results[$i]['product_options'])) {
			$print_order_form->assign("VAL_PRODUCT_OPTS",$text_input_string);
		} else {
			$print_order_form->assign("VAL_PRODUCT_OPTS",$results[$i]['product_options']."<br/>".$text_input_string);
		}
	}
	// end mod: Text Input Fields for Products, by Estelle
	
	if(file_exists($GLOBALS['rootDir']."http://www.beautiful-baths.ca/cart/images/uploads/thumbs/thumb_".$results[$i]['image'])){
		
		$print_order_form->assign("SRC_PROD_THUMB",$GLOBALS['rootRel']."http://www.beautiful-baths.ca/cart/images/uploads/thumbs/thumb_".$results[$i]['image']);
	} else {
		$print_order_form->assign("SRC_PROD_THUMB",$GLOBALS['rootRel']."skins/".$config['skinDir']."http://www.beautiful-baths.ca/cart/styleImages/thumb_nophoto.gif");
	}

	$print_order_form->parse("order_form.repeat_order_inv");
}

$print_order_form->assign("LANG_SHIPPING_METHOD",$lang['printOrderForm']['shippingMethod']);
$print_order_form->assign("VAL_SHIPPING_METHOD",$result[0]['shipMethod']);  
$print_order_form->assign("LANG_SUBTOTAL",$lang['printOrderForm']['subtotal']);
$print_order_form->assign("VAL_SUBTOTAL",priceFormat($result[0]['subtotal']));
$print_order_form->assign("LANG_TOTAL_TAX",$lang['printOrderForm']['totalTax']);
$print_order_form->assign("VAL_TOTAL_TAX",priceFormat($result[0]['total_tax']));
$print_order_form->assign("LANG_SHIPPING",$lang['printOrderForm']['totalShipping']);
$print_order_form->assign("VAL_SHIPPING",priceFormat($result[0]['total_ship']));
$print_order_form->assign("LANG_GRAND_TOTAL",$lang['printOrderForm']['grandTotal']);
$print_order_form->assign("VAL_GRAND_TOTAL",priceFormat($result[0]['prod_total']));

if($module['cheque'] == 1){
	$print_order_form->assign("LANG_PAY_BY_CHEQUE",$lang['printOrderForm']['payByCheck']);
	$print_order_form->assign("VAL_MAKE_CHEQUES_PAYABLE_TO",$lang['printOrderForm']['payTo']." ".$module['payableTo'].".");
	$print_order_form->parse("order_form.check_true");
}

if($module['card'] == 1){
	$print_order_form->assign("LANG_PAY_BY_CARD",$lang['printOrderForm']['payByCard']);
	$print_order_form->assign("LANG_CARD_TYPE",$lang['printOrderForm']['cardType']);
	
	$cards = explode(",",$module['cards']);
	
	if(is_array($cards)){
		foreach($cards as $key => $value){
		$print_order_form->assign("VAL_CARD_NAME",$value);
		$print_order_form->parse("order_form.card_true.repeat_card");
		}
	}
	
	$print_order_form->assign("LANG_CARD_NO",$lang['printOrderForm']['cardNo']);
	$print_order_form->assign("LANG_3_DIG_ID",$lang['printOrderForm']['3-4DigiId']);
	$print_order_form->assign("LANG_EXPIRE_DATE",$lang['printOrderForm']['expiryDate']);
	$print_order_form->assign("LANG_ISSUE_DATE",$lang['printOrderForm']['issueDate']);
	$print_order_form->assign("LANG_ISSUE_NUMBER",$lang['printOrderForm']['issueNo']);
	$print_order_form->assign("LANG_SIGNATURE",$lang['printOrderForm']['signature']);
	$print_order_form->parse("order_form.card_true");
}


if($module['bank'] == 1){
	$print_order_form->assign("LANG_PAY_BY_WIRE",$lang['printOrderForm']['payByTransfer']);
	$print_order_form->assign("LANG_BANK_NAME",$lang['printOrderForm']['bankName']);
	$print_order_form->assign("VAL_BANK_NAME",$module['bankName']);
	$print_order_form->assign("LANG_ACCOUNT_NAME",$lang['printOrderForm']['accountName']);
	$print_order_form->assign("VAL_ACCOUNT_NAME",$module['accName']);
	$print_order_form->assign("LANG_SORT_CODE",$lang['printOrderForm']['sortCode']);
	$print_order_form->assign("VAL_SORT_CODE",$module['sortCode']);
	$print_order_form->assign("LANG_AC_NO",$lang['printOrderForm']['accountNo']);
	$print_order_form->assign("VAL_AC_NO",$module['acNo']);
	$print_order_form->assign("LANG_SWIFT_CODE",$lang['printOrderForm']['swiftCode']);
	$print_order_form->assign("VAL_SWIFT_CODE",$module['swiftCode']);
	$print_order_form->assign("LANG_ADDRESS",$lang['printOrderForm']['bankAddress']);
	$print_order_form->assign("VAL_ADDRESS",$module['address']);
	$print_order_form->parse("order_form.bank_true");
}

if(!empty($module['notes'])){
$print_order_form->assign("VAL_CUST_NOTES",$module['notes']);
$print_order_form->parse("order_form.cust_notes");
}

$print_order_form->assign("LANG_THANK_YOU",$lang['printOrderForm']['thanks']);
$print_order_form->assign("LANG_SEND_TO",$lang['printOrderForm']['postalAddress']);
$print_order_form->assign("VAL_STORE_ADDRESS",$config['storeAddress']);

// empty basket
$basket = $cart->emptyCart();

$print_order_form->parse(“order_form”);

$print_order_form->out(“order_form”);

// add affilate tracking code/module
$affiliateModule = $db->select("SELECT folder, default FROM ".$glob[‘dbprefix’].“CubeCart_Modules WHERE module=‘affiliate’ AND status = 1”);

if($affiliateModule == TRUE) {

	for($i=0; $i<count($affiliateModule); $i++){
		
		include("../../../modules/affiliate/".$affiliateModule[$i]['folder']."/tracker.inc.php");
		// VARS AVAILABLE
		// Order Id Number $basket['cart_order_id']
		// Order Total $order[0]['prod_total']
		//$basket['cart_order_id'] = $_POST['x_invoice_num'];
		$order[0]['prod_total'] = $result[0]['prod_total'];
		echo $affCode;
	
	}

}

?>[/php]

Here is the template file:

  <!-- BEGIN: repeat_order_inv --> 

  <tr>

    <td class="copyText" colspan="2"><table width="100%" border="0" cellpadding="7" cellspacing="0" style="padding: 7px;">
      <!-- BEGIN: repeat_order_inv -->
      <tr>
        <td class="copyText"><div align="center"><img src="{SRC_PROD_THUMB}" alt="{TXT_TITLE}" border="0" title="{TXT_TITLE}" /></div></td>
      </tr>
      <!-- END: repeat_order_inv -->
    </table></td>
    <td class="copyText">{VAL_PRODUCT_NAME}<br />

{VAL_PRODUCT_OPTS} 

    <td class="copyText">{VAL_PRODUCT_CODE}</td>

    <td class="copyText">{VAL_PRODUCT_QUANTITY}</td>

  </tr>

  <!-- END: repeat_order_inv -->
#2

well if you are trying to add just static images to the template then do not look at the php file unless you are trying to add product pictures which require different pictures per page. There is another page that is missing and that is where these values like this {VAL_PRODUCT_OPTS} are defined. If you find that page then you might be able to select from product pictures there and define your own for the images IMAGE_1=$row[‘image1’] etc.
I dont know if you have a decent computer with some decent ram but if you do a good option I do is, I use notepad++ , I will drop all the files of a website on to notepad++ then you can do a search “Find All in All Opened Documents” for the “{VAL_PRODUCT_OPTS}”, this will show you exactly where the definitions page is located and you can go there and do what you got to do!
No matter what every good programmer should use notepadd++ because it rocks! 8)

Sponsor our Newsletter | Privacy Policy | Terms of Service