fetchByAssoc($GLOBALS['db']->query("select name from ecmstocks 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("ecmstockin.price_in","ecmstockin.date_in","ecmstockin.quantity_in","ecmstockin.quantity_out","ecmstockin.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 ecmstockins.*,ecmproducts.name as product_name,ecmstockdocins.name as pz_name from ecmstockins inner join ecmproducts on ecmproducts.id=ecmstockins.product_id inner join ecmstockdocins on ecmstockdocins.id=ecmstockins.pz_id where ecmstockins.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]=="ecmstockin.date_in")print ''; elseif($c[$i]=="ecmstockin.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("ecmstockin.","",$c[$i])].'

'; ?>