Zen Cart Logo
Forums / All Other Contributions/Addons / Custom Field in Admin orders super_orders

Custom Field in Admin orders super_orders

Views: 615

Results 1 to 1 of 1
24 Jan 2012, 3:34 PM
#1
sbbemn avatar

sbbemn

Zen Follower

Join Date:
Jan 2010
Posts:
182
Plugin Contributions:
0

Custom Field in Admin orders super_orders

Hello,

I am adding fields to save on the order to track any costs due to our errors or manufacturer errors. Later, I'll get this to easy populate at the end of the year.

I believe I am a bit confused on the actual code for the storage of the entry into the order's table.

I have Added each one at a time to the SQL Patches

ALTER TABLE orders_products ADD products_erprod_cost varchar(32) NOT NULL after products_model;
ALTER TABLE orders_products ADD products_ership_cost varchar(32) NOT NULL after products_model;
ALTER TABLE orders_products ADD products_nonerprod_cost varchar(32) NOT NULL after products_model;
ALTER TABLE orders_products ADD products_nonership_cost varchar(32) NOT NULL after products_model;

Then here is my code on super_orders......

		<table border=1 width=400><tr class="dataTableHeadingRow">
	<tr><td colspan=4 class="dataTableHeadingContent" align="center"><b>Error Costs</b></td>

	<tr>
            <td class="dataTableHeadingContent" align="middle">Err Product</td>
            <td class="dataTableHeadingContent" align="middle">Err Ship</td>		
            <td class="dataTableHeadingContent" align="middle">NON-Err Product</td>
            <td class="dataTableHeadingContent" align="middle">NON-Err Ship</td>
	</tr>
<?php
    for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {
 
echo '<td class="dataTableContent" align="middle" valign="top">'. zen_draw_input_field('products_erprod_cost',$order->products[$i]['id'],$order->products[$i]['products_erprod_cost'],'size=5').'</td>';
echo '<td class="dataTableContent" align="middle" valign="top">'. zen_draw_input_field('products_ership_cost',$order->products[$i]['id'],$order->products[$i]['products_ership_cost'],'size=5').'</td>';
echo '<td class="dataTableContent" align="middle" valign="top">'. zen_draw_input_field('products_nonerprod_cost',$order->products[$i]['id'],$order->products[$i]['products_nonerprod_cost'],'size=5').'</td>';
echo '<td class="dataTableContent" align="middle" valign="top">'. zen_draw_input_field('products_nonership_cost',$order->products[$i]['id'],$order->products[$i]['products_nonership_cost'],'size=5').'</td>';
	echo "</tr>";
	}
?>
		</table>	

The result is odd - 6058 and 6039 fill the fields and * Required is displayed under them?

I am obviously missing something here. Any help? Thanks!