0 and (SES_PARAM3 like '%".$_SESSION['eq_stock_param3_1']."%' or SES_PARAM3 like '%".$_SESSION['eq_stock_param3_2']."%' or SES_PARAM3 like '%".$_SESSION['eq_stock_param3_3']."%') and SES_TYPE=(select DIC_ID from sys_dictionaries where DIC_TYPE='DRS_DEV_TYPE' and DIC_NAME='ARMATURE')"); //$wynik = mysql_query("select SES_ID,SES_EQU_ID,EQU_NAME,EQU_PARAM_01,EQU_PARAM_02,MCF_NAME,sum(SES_VALUE) TOT_VAL,(select sum(SDE_VALUE) from seg_dev_equipments_rel where SDE_PARAM3='".$_SESSION['syndis_eq_stock']."' and SDE_DRS_EQU_ID=SES_EQU_ID) TOT_STOCK from seg_equipments_stock,seg_equipments left join seg_manufacturers on EQU_MCF_ID=MCF_ID where SES_EQU_ID=EQU_ID and SES_PARAM3='".$_SESSION['syndis_eq_stock']."' and SES_TYPE=15 GROUP BY SES_EQU_ID order by EQU_NAME"); unset($tmp307Array); $tmp307Array = sqlGetResAsArray("select SES_EQU_ID,EQU_NAME,EQU_PARAM_01,EQU_PARAM_02,MCF_NAME,sum(SES_VALUE) TOT_VAL,(select sum(SDE_VALUE) from seg_dev_equipments_rel where SDE_PARAM3='".$_SESSION['syndis_eq_stock']."' and SDE_DRS_EQU_ID=SES_EQU_ID) TOT_STOCK from seg_equipments_stock,seg_equipments left join seg_manufacturers on EQU_MCF_ID=MCF_ID where SES_EQU_ID=EQU_ID and SES_PARAM3='".$_SESSION['syndis_eq_stock']."' and SES_TYPE=15 GROUP BY SES_EQU_ID order by EQU_NAME"); for ($i=0; $i "; } ?>
".$tmp307Array[$i]['EQU_NAME']."$sql_2 $sql_6 ".$tmp307Array[$i]['EQU_PARAM_02']."$sql_7 ".$tmp307Array[$i]['MCF_NAME']."$sql_3 ".round($tmp307Array[$i]['TOT_VAL'] - $tmp307Array[$i]['TOT_STOCK'],2)."$sql_4
'>