Jump to content


Photo

Need help with mysql update quiry..


  • Please log in to reply
No replies to this topic

#1 fatum112

fatum112
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 12 September 2006 - 12:49 PM

Hi,

i'm trying to make a mambo virtuemart mod,
i'm currently trying to make a script so i can update the product quantety, subtotal, and total price..

i need this all in one..

the current script without any update function is:

<?php
			  $dbt = new ps_DB;
			  $qt  = "SELECT product_quantity,order_item_name,order_item_sku,product_id,product_item_price,product_final_price, product_attribute
						FROM `#__{vm}_order_item`
						WHERE #__{vm}_order_item.order_id='$order_id' ";
			  $dbt->query($qt);
			  $i = 0;
			  
			  while ($dbt->next_record()){
				if ($i++ % 2) 
				   $bgcolor=SEARCH_COLOR_1;
				else
				  $bgcolor=SEARCH_COLOR_2;
				$t = $dbt->f("product_quantity") * $dbt->f("product_final_price");
				
			  ?>
			  <tr bgcolor="<?php echo $bgcolor; ?>" valign="top"> 
				<td width="5%"> <?php $dbt->p("product_quantity") ?></td>
				<td width="42%"><?php $dbt->p("order_item_name"); 
				  echo "<br /><font size=\"-2\">" . ps_product::getDescriptionWithTax($dbt->f("product_attribute")) . "</font>"; 
				  ?>
				</td>
				<td width="9%"><?php  $dbt->p("order_item_sku") ?>&nbsp;</td>
				<td width="12%" align="right"><?php 
					echo $CURRENCY_DISPLAY->getFullValue($dbt->f("product_item_price"), 5);  
					
					?></td>
				<td width="12%" align="right"><?php echo $CURRENCY_DISPLAY->getFullValue($dbt->f("product_final_price"));  ?></td>
				<td width="19%" align="right"><?php echo $CURRENCY_DISPLAY->getFullValue($t); ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
			  </tr>
			  <?php 
			  } 
			  ?> 
			  <tr> 
				<td colspan="6">&nbsp; </td>
			  </tr>
			  <tr> 
				<td width="5%">&nbsp;</td>
				<td width="42%">&nbsp;</td>
				<td colspan="3"><div align="right"><strong> <?php echo $VM_LANG->_PHPSHOP_ORDER_PRINT_SUBTOTAL ?>: </strong></div></td>
				<td width="19%"><div align="right"><?php echo $CURRENCY_DISPLAY->getFullValue($db->f("order_subtotal"), 5); ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div></td>
			  </tr>
	  <?php
			  /* COUPON DISCOUNT */
			$coupon_discount = $db->f("coupon_discount");
			
	  
			if( PAYMENT_DISCOUNT_BEFORE == '1') {
			  if ($db->f("order_discount") != 0) {
	  ?>
			  <tr>
				 <td width="5%">&nbsp;</td>
				<td width="42%">&nbsp;</td>
				<td colspan="3"><div  align="right"><strong><?php 
				  if( $db->f("order_discount") > 0)
					echo $VM_LANG->_PHPSHOP_PAYMENT_METHOD_LIST_DISCOUNT;
				  else
					echo $VM_LANG->_PHPSHOP_FEE;
					?>:</div></strong></td>
				<td width="19%"><div  align="right"><?php
					  if ($db->f("order_discount") > 0 )
					 echo "-" . $CURRENCY_DISPLAY->getFullValue(abs($db->f("order_discount")));
				elseif ($db->f("order_discount") < 0 )
					 echo "+" . $CURRENCY_DISPLAY->getFullValue(abs($db->f("order_discount"))); ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div>
				  </td>
			  </tr>
			  
			  <?php 
			  } 
			  if( $coupon_discount > 0 || $coupon_discount < 0) {
	  ?>
			  <tr>
				<td colspan="5"><div align="right"><?php echo $VM_LANG->_PHPSHOP_COUPON_DISCOUNT ?>:</div>
				</td> 
				<td><div align="right"><?php
				  echo "- ".$CURRENCY_DISPLAY->getFullValue( $coupon_discount ); ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div>
				</td>
			  </tr>
			  <?php
			  }
			}
	  ?>
			  
			  <tr> 
				<td width="5%">&nbsp;</td>
				<td width="42%">&nbsp;</td>
				<td colspan="3"><div align="right"><strong><?php echo $VM_LANG->_PHPSHOP_ORDER_PRINT_TOTAL_TAX ?>: </div></strong></td>
				<td width="19%"><div align="right"><?php echo $CURRENCY_DISPLAY->getFullValue($db->f("order_tax")) ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div></td>
			  </tr>
			  <tr> 
				<td width="5%">&nbsp;</td>
				<td width="42%">&nbsp;</td>
				<td colspan="3"><div align="right"><strong><?php echo $VM_LANG->_PHPSHOP_ORDER_PRINT_SHIPPING ?>: </div></strong></td>
				<td width="19%"><div align="right"><?php echo $CURRENCY_DISPLAY->getFullValue($db->f("order_shipping")) ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div></td>
			  </tr>
			  <tr> 
				<td width="5%">&nbsp;</td>
				<td width="42%">&nbsp;</td>
				<td colspan="3"><div align="right"><strong><?php echo $VM_LANG->_PHPSHOP_ORDER_PRINT_SHIPPING_TAX ?>: </div></strong></td>
				<td width="19%"><div align="right"><?php echo $CURRENCY_DISPLAY->getFullValue($db->f("order_shipping_tax")) ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div></td>
			  </tr>
	  <?php
			if( PAYMENT_DISCOUNT_BEFORE != '1') {
			  if ($db->f("order_discount") != 0) {
	  ?>
			  <tr> 
				<td width="5%">&nbsp;</td>
				<td width="42%">&nbsp;</td>
				<td colspan="3"><div align="right"><strong><?php 
				  if( $db->f("order_discount") > 0)
					echo $VM_LANG->_PHPSHOP_PAYMENT_METHOD_LIST_DISCOUNT;
				  else
					echo $VM_LANG->_PHPSHOP_FEE;
					?>:</strong></div></td>
				<td width="19%"><div align="right"><?php
					  if ($db->f("order_discount") > 0 )
					 echo "-" . $CURRENCY_DISPLAY->getFullValue(abs($db->f("order_discount")));
				elseif ($db->f("order_discount") < 0 )
					 echo "+" . $CURRENCY_DISPLAY->getFullValue(abs($db->f("order_discount"))); ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div>
				  </td>
			  </tr>
			  
			  <?php 
			  } 
			  if( $coupon_discount > 0 || $coupon_discount < 0) {
	  ?>
			  <tr> 
				<td width="5%">&nbsp;</td>
				<td width="42%">&nbsp;</td>
				<td colspan="3"><div align="right"><strong><?php echo $VM_LANG->_PHPSHOP_COUPON_DISCOUNT ?>:</div></strong>
				</td> 
				<td><div align="right"><?php
				  echo "- ".$CURRENCY_DISPLAY->getFullValue( $coupon_discount ); ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div>
				</td>
			  </tr>
			  <?php
			  }
			}
	  ?>
			  <tr>
				<td width="5%">&nbsp;</td>
				<td width="42%">&nbsp;</td>
				<td colspan="3"><div align="right"><strong><?php echo $VM_LANG->_PHPSHOP_CART_TOTAL ?>:</div> </strong></td>
				<td width="19%"><div align="right"><strong><?php echo $CURRENCY_DISPLAY->getFullValue($db->f("order_total")); ?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div></strong>
				  </td>


now i need to make a script to update the quantety, total price and subtotal all at once to the database,
anyone a idea?
(PS: for anyone that helps will be placed in the copyright file when the full mod is released.)

Regards,
Marco




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users