$where="catmer = ".$form["catmer"];
if ($form['catmer'] == 100) {
$where=1;
}
$ctrl_cm=0;
$result = gaz_dbi_dyn_query($gTables['artico'].'.*, '.$gTables['catmer'].'.descri AS descat,'.$gTables['catmer'].'.annota AS anncat', $gTables['artico'].' LEFT JOIN '.$gTables['catmer'].' ON catmer = '.$gTables['catmer'].'.codice', $where,'catmer ASC, '.$gTables['artico'].'.codice ASC');
if ($result) {
// Imposto totale valore giacenza by DF
$tot_val_giac = 0;
while ($r = gaz_dbi_fetch_array($result)) {
if ($r['catmer']<>$ctrl_cm ){
gaz_set_time_limit (30);
$ctrl_cm=$r['catmer'];
}
$mv=$gForm->getStockValue(false,$r['codice'],$date,null,$admin_aziend['decimal_price']);
$magval=array_pop($mv);
if ( $magval['q_g'] > 0 )
{
$form['a'][$r['codice']]['i_d'] = $r['descri'];
$form['a'][$r['codice']]['i_u'] = $r['unimis'];
$form['a'][$r['codice']]['v_a'] = $magval['v'];
$form['a'][$r['codice']]['v_r'] = $magval['v'];
$form['a'][$r['codice']]['i_a'] = $r['annota'];
$form['a'][$r['codice']]['i_g'] = $r['catmer'];
$form['a'][$r['codice']]['g_d'] = $r['descat'];
$form['a'][$r['codice']]['g_r'] = $magval['q_g'];
$form['a'][$r['codice']]['g_a'] = $magval['q_g'];
$form['a'][$r['codice']]['v_g'] = $magval['v_g'];
$form['vac_on'.$r['codice']] = '';
if ($magval['q_g'] < 0 ){
while (list($key, $mv) = each($m)) {
if ($ctr_mv != $mv['artico']) {
gaz_set_time_limit (30);
if (!empty($ctr_mv)) {
echo "\t<tr>\n";
echo "\t<td colspan=\"10\" align=\"right\"></td>\n";
echo "\t </tr>\n";
$sum=0.00;
}
echo "\t<tr>\n";
echo "\t<td colspan=\"10\">".$mv['artico']." - ".$mv['desart']."</td>\n";
echo "\t </tr>\n";
}
// passo tutte le variabili al metodo in modo da non costringere lo stesso a fare le query per ricavarsele
$magval= $gForm->getStockValue($mv['id_mov'],$mv['artico'],$mv['datreg'],$admin_aziend['stock_eval_method']);
$r_span=count($magval);
foreach ($magval as $mval) {
if ($ctrl_id <> $mv['id_mov']) {
echo "<tr><td class=\"FacetDataTD\" rowspan=\"$r_span\">".gaz_format_date($mv['datreg'])." id:".$mv['id_mov']."</td>";
echo "<td align=\"center\" class=\"FacetDataTD\" rowspan=\"$r_span\">".$mv['caumag'].'-'.substr($mv['descri'],0,20)."</td>";
echo "<td class=\"FacetDataTD\" rowspan=\"$r_span\">".substr($mv['desdoc'].' del '.gaz_format_date($mv['datdoc']).' - '.$mv['ragso1'].' '.$mv['ragso2'],0,85)."</td>";
echo "<td align=\"right\" class=\"FacetDataTD\" rowspan=\"$r_span\">".number_format($mv['prezzo'],$admin_aziend['decimal_price'],',','.')."</td>";
echo "<td align=\"right\" class=\"FacetDataTD\" rowspan=\"$r_span\">".$mv['unimis']."</td>\n";
} else {
echo "<tr>";
}
echo "<td align=\"right\" class=\"FacetDataTD\">".gaz_format_quantity($mval['q']*$mv['operat'],1,$admin_aziend['decimal_quantity'])."</td>";
if ($mv['operat']==1) {
echo "<td align=\"right\" class=\"FacetDataTD\">".number_format($mval['v'],$admin_aziend['decimal_price'],',','')."</td><td></td>";
} else {
$headers_artico = array_merge ( $headers_artico,array(
"Barcode" => "barcode",
"Duplica" => "",
"Cancella" => ""
));
}
$linkHeaders = new linkHeaders($headers_artico);
$linkHeaders -> output();
$recordnav = new recordnav($gTables['artico'], $where, $limit, $passo);
$recordnav -> output();
$gForm = new magazzForm();
while ($r = gaz_dbi_fetch_array($result)) {
gaz_set_time_limit (30);
$lastdoc=getLastDoc($r["codice"]);
$mv=$gForm->getStockValue(false,$r['codice']);
$magval=array_pop($mv);
$image_src = '';
if((!empty($r["image"]) || (file_exists("../../data/files/fotoart/".$r["codice"].".gif" )))){
if ( !empty( $r["image"] ) ) {
$image_src = '<img border="1px" height="20" src="../root/view.php?table=artico&value='.$r['codice'].'" />';
$boxover = "title=\"cssbody=[FacetInput] cssheader=[FacetButton] header=[".$r['annota']."] body=[<img src='../root/view.php?table=artico&value=".$r['codice']."'>] fade=[on] fadespeed=[0.03] \"";
} elseif (file_exists("../../data/files/fotoart/".$r["codice"].".gif" )) {
$image_src = '<img border="1px" height="20" src="../../data/files/fotoart/'.$r["codice"].'.gif" />';
$boxover = "title=\"cssbody=[FacetInput] cssheader=[FacetButton] header=[".$r['annota']."] body=[<img width='50%' height='50%' src='../../data/files/fotoart/".$r['codice'].".gif'>] fade=[on] fadespeed=[0.03] \"";
} else {
$image_src = "";
}
} else {
$boxover = "title=\"cssbody=[FacetInput] cssheader=[FacetButton] header=[".$r['annota']."] fade=[on] fadespeed=[0.03] \"";
}
$form['rows'][$old_key]['scorta'] = '';
$form['rows'][$old_key]['annota'] = '';
$form['rows'][$old_key]['pesosp'] = '';
if ($form['in_tiprig'] == 0 and !empty($form['in_codart'])) { //rigo normale
$form['rows'][$old_key]['annota'] = $artico['annota'];
$form['rows'][$old_key]['pesosp'] = $artico['peso_specifico'];
$form['rows'][$old_key]['unimis'] = $artico['unimis'];
$form['rows'][$old_key]['descri'] = $artico['descri'];
if ($form['listin'] == 2) {
$form['rows'][$old_key]['prelis'] = number_format($artico['preve2'],$admin_aziend['decimal_price'],'.','');
} elseif ($form['listin'] == 3) {
$form['rows'][$old_key]['prelis'] = number_format($artico['preve3'],$admin_aziend['decimal_price'],'.','');
} else {
$form['rows'][$old_key]['prelis'] = number_format($artico['preve1'],$admin_aziend['decimal_price'],'.','');
}
$mv=$upd_mm->getStockValue(false,$form['in_codart'],$form['annemi'].'-'.$form['mesemi'].'-'.$form['gioemi'],$admin_aziend['stock_eval_method']);
$magval=array_pop($mv);
$form['rows'][$old_key]['scorta'] = $magval['q_g'] - $artico['scorta'];
} elseif ($form['in_tiprig'] == 2) { //rigo descrittivo
$form['rows'][$old_key]['codart'] = "";
$form['rows'][$old_key]['annota'] = "";
$form['rows'][$old_key]['pesosp'] = "";
$form['rows'][$old_key]['unimis'] = "";
$form['rows'][$old_key]['quanti'] = 0;
$form['rows'][$old_key]['prelis'] = 0;
$form['rows'][$old_key]['codric'] = 0;
$form['rows'][$old_key]['sconto'] = 0;
$form['rows'][$old_key]['pervat'] = 0;
$form['rows'][$old_key]['tipiva'] = 0;
$form['rows'][$old_key]['ritenuta'] = 0;
$form['rows'][$old_key]['codvat'] = 0;
$form['rows'][$old_key]['annota'] = '';
$form['rows'][$old_key]['scorta'] = '';
$form['rows'][$old_key]['pesosp'] = '';
if ($form['in_tiprig'] == 0 and !empty($form['in_codart'])) { //rigo normale
$form['rows'][$old_key]['annota'] = $artico['annota'];
$form['rows'][$old_key]['pesosp'] = $artico['peso_specifico'];
$form['rows'][$old_key]['unimis'] = $artico['unimis'];
$form['rows'][$old_key]['descri'] = $artico['descri'];
if ($form['listin'] == 2) {
$form['rows'][$old_key]['prelis'] = number_format($artico['preve2'],$admin_aziend['decimal_price'],'.','');
} elseif ($form['listin'] == 3) {
$form['rows'][$old_key]['prelis'] = number_format($artico['preve3'],$admin_aziend['decimal_price'],'.','');
} else {
$form['rows'][$old_key]['prelis'] = number_format($artico['preve1'],$admin_aziend['decimal_price'],'.','');
}
$mv=$magazz->getStockValue(false,$form['in_codart'],$form['datemi_Y'].'-'.$form['datemi_M'].'-'.$form['datemi_D'],$admin_aziend['stock_eval_method']);
$magval=array_pop($mv);
$form['rows'][$old_key]['scorta'] = $magval['q_g'] - $artico['scorta'];
} elseif ($form['in_tiprig'] == 1) { //rigo forfait
$form['rows'][$old_key]['codart'] = "";
$form['rows'][$old_key]['unimis'] = "";
$form['rows'][$old_key]['quanti'] = 0;
$form['rows'][$old_key]['sconto'] = 0;
} else { // rigo descrittivo
$form['rows'][$old_key]['codart'] = "";
$form['rows'][$old_key]['annota'] = "";
$form['rows'][$old_key]['pesosp'] = "";
$form['rows'][$old_key]['unimis'] = "";
$form['rows'][$old_key]['quanti'] = 0;
$form['rows'][$old_key]['prelis'] = 0;
$form['rows'][$old_key]['codric'] = 0;
