$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;