query("select sum(value) as sum from ecmproducts_history_states where ecmproduct_id='".$id."' and ecmstock_id='c7afd71a-4c3a-bde4-138d-4acaee1644e4'");
$rr=$GLOBALS['db']->fetchByAssoc($ww);
$i=mysql_num_rows($GLOBALS['db']->query("select distinct date from ecmproducts_history_states"));
$v=$rr['sum'];
return @$v/$i;
}
function getPurchase($id){
$r=$GLOBALS['db']->fetchByAssoc($GLOBALS['db']->query("select sum(i.quantity*i.purchase_price) as sum from ecminvoiceoutitems as i inner join ecminvoiceouts as e on e.id=i.ecminvoiceout_id where e.deleted='0' and e.status='accepted' and i.deleted='0' and i.ecmproduct_id='".$id."' and e.register_date like '".date("Y")."%'"));
return $r['sum'];
}
$w=$GLOBALS['db']->query("select id,code,name from ecmproducts where product_active='1' and deleted='0'");
while($r=$GLOBALS['db']->fetchByAssoc($w)){
@$r['rotation']=12*(getPurchase($r['id'])/$mmm)/getRotation($r['id']);
$row[]=$r;
}
$row=multisort($row,array(array('key'=>'rotation','sort'=>'desc')));
echo '