fetchByAssoc($GLOBALS['db']->query("select name from ecmproductstockindexs where id='".$_REQUEST['stock_id']."'")); $name=$r['name']; function sortLink($order_by,$sorder,$title) { if($order_by==$_REQUEST['order_by']) { if($sorder=="desc") { $img='

'; $s="asc"; } else { $img='

'; $s="desc"; } } else { $img='

'; $s=$sorder; } return ''.$title.' '.$img.''; } $c=array("ecmproductstockindexin.price_in","ecmproductstockindexin.date_in","ecmproductstockindexin.quantity_in","ecmproductstockindexin.quantity_out","ecmproductstockindexin.pz_id"); $t=array($mod_strings['LBL_PRICE'],$mod_strings['LBL_DATE'],$mod_strings['LBL_QTY_IN'],$mod_strings['LBL_QTY_OUT'],$mod_strings['LBL_PZ']); $sorder=$_REQUEST['sorder']; print '

Products List:

'; print ''; print ''; for($i=0;$i'.sortLink($corder_by,$sorder,$t[$i]).''; } print ''; print ''; print ''; $z="select ecmproductstockindexins.*,ecmproducts.name as product_name,ecmproductstockindexdocins.name as pz_name from ecmproductstockindexins inner join ecmproducts on ecmproducts.id=ecmproductstockindexins.product_id inner join ecmproductstockindexdocins on ecmproductstockindexdocins.id=ecmproductstockindexins.pz_id where ecmproductstockindexins.stock_id='".$_REQUEST['stock_id']."' order by ".$_REQUEST['order_by']." ".$_REQUEST['sorder']; $result = $GLOBALS['db']->query($z); while($row=$GLOBALS['db']->fetchByAssoc($result)) { print ''; print ''; for($i=0;$i'.$row['pz_name'].''; elseif($c[$i]=="ecmproductstockindexin.date_in")print ''; elseif($c[$i]=="ecmproductstockindexin.price_in")print ''; else print ''; } } print ''; } print '

'.sortLink("ecmproducts.name",$sorder,$mod_strings['LBL_PRODUCT_NAME']).'
'.$row['product_name'].'	'.$timedate->to_display($row['date_in'],"Y-m-d",$timedate->get_date_format()).'	'.number_format($row['price_in'],2,$GLOBALS['sugar_config']['default_decimal_seperator'],$GLOBALS['sugar_config']['default_number_grouping_seperator']).'	'.$row[str_replace("ecmproductstockindexin.","",$c[$i])].'

'; ?>