/main.css"> getAll($sql); $sqlparts = "UPDATE parts SET partnumber = '%s', description = '%s', lastcost = %0.5f, listprice = %0.5f, sellprice = %0.5f WHERE id = %d"; $chkparts = "SELECT id FROM parts WHERE partnumber = '%s'"; $delprice = "DELETE FROM prices WHERE parts_id = %d"; $insprice = "INSERT INTO prices (parts_id,pricegroup_id,price) VALUES (%d,%d,%0.5f)"; if ($_POST) while( list($key,$val) = each( $_POST['partnumber'] ) ) { $ok = true; if ( $_POST['oldpnr'][$key] != $val ) { $rs = $_SESSION['db']->getAll(sprintf($chkparts,$val)); if ( count($rs) > 0 ) { echo "$val doppelt
"; $ok = false; } } if ( $ok ) { echo "$key "; $sql = sprintf($sqlparts,$val,$_POST['description'][$key], strtr($_POST['lastcost'][$key] ,",","."), strtr($_POST['listprice'][$key],",","."), strtr($_POST['sellprice'][$key],",","."),$key); $rc = $_SESSION['db']->query($sql); if ( $rc and $prgr ) { $rc = $_SESSION['db']->begin(); $rc = $_SESSION['db']->query(sprintf($delprice,$key)); foreach( $prgr as $price ) { if ( $_POST[$price['id']][$key] ) { $rc = $_SESSION['db']->query(sprintf($insprice,$key,$price['id'],strtr($_POST[$price['id']][$key],",",".") ) ); if ( !$rc ) { $_SESSION['db']->rollback(); echo "Error Preisgruppe (".$price['pricegroup'].")
"; break; } } } $_SESSION['db']->commit(); echo "update ok
"; }; }; }; }; if ( isset( $_POST["such"] ) ) { $where = array('1=1'); $sql = "SELECT P.id as pid,P.partnumber,P.description,P.lastcost,P.listprice,P.sellprice,"; $sql .= "PC.pricegroup_id,PC.price,PC.id FROM parts P left join prices PC on P.id=PC.parts_id WHERE "; if ( isset($_POST['partnumber'] ) and $_POST['partnumber'] != '' ) $where[] = "partnumber ilike '".strtr($_POST['partnumber'],"*?","%_")."'"; if ( isset($_POST['description'] ) and $_POST['description'] != '' ) $where[] = "description ilike '".strtr($_POST['description'],"*?","%_")."%'"; if ( isset($_POST['partsgroup_id'] ) and $_POST['partsgroup_id'] != '' ) $where[] = "partsgroup_id = ".$_POST['partsgroup_id']; $sql .= implode(' and ',$where)." ORDER BY P.partnumber,PC.pricegroup_id"; $rs = $_SESSION['db']->getAll($sql); $lastid = 0; if ( $rs ) { $sql = "SELECT * FROM pricegroup ORDER by id"; $prgr = $_SESSION['db']->getAll($sql); $prices = array(); if ( $prgr ) foreach ($prgr as $row ) { $prices[$row['id']] = '';}; foreach ( $rs as $row ) { if ( $lastid != $row['pid'] ) { //$parts[$row['pid']] = array_merge(array_slice($row,0,6),$prices); //tut nicht wie es soll. Keine Ahnung warum. $parts[$row['pid']] = array_slice($row,0,6); if ( $prgr ) foreach ($prgr as $price ) { $parts[$row['pid']][$price['id']] = '';}; if ( $row['pricegroup_id'] ) $parts[$row['pid']][$row['pricegroup_id']] = $row['price']; $lastid = $row['pid']; } else { $parts[$lastid][$row['pricegroup_id']] = $row['price']; } }; } }; $partsgrp=getAllPG(); ?>
"; echo "IDArtNrArtikelEKListeVK"; $cnt = count($parts[0]); if ( $prgr ) foreach($prgr as $cell) { echo "".$cell['pricegroup'].""; }; echo "\n"; foreach ($parts as $row) { echo ''.$row['pid'].''; $pid = $row['pid']; unset($row['pid']); echo ''; while(list($key,$val) = each($row)) { if ( $key == 'description' ) { echo ''; } else { echo ''; } }; echo "\n"; }; echo "\n"; echo "
"; echo "
neue Suche"; } else { ?>
Artikelnummer
Artikel:
Warengruppe:
"; echo $menu['end_content']; ?>