2024-07-26 14:38:14 +02:00
< ? php
/*
* Copyright ( c ) 2022 OpenXE project
*/
use Xentral\Components\Database\Exception\QueryFailureException ;
use Xentral\Modules\SystemNotification\Service\NotificationMessageData ;
use Xentral\Modules\SystemNotification\Service\NotificationService ;
class Seriennummern {
function __construct ( $app , $intern = false ) {
$this -> app = $app ;
if ( $intern )
return ;
$this -> app -> ActionHandlerInit ( $this );
2024-07-28 13:42:28 +02:00
$this -> app -> ActionHandler ( " list " , " seriennummern_artikel_list " );
2024-08-03 13:27:45 +02:00
$this -> app -> ActionHandler ( " nummern_list " , " seriennummern_nummern_list " );
2024-09-17 09:50:47 +02:00
$this -> app -> ActionHandler ( " lieferscheine_list " , " seriennummern_lieferscheine_list " );
$this -> app -> ActionHandler ( " wareneingaenge_list " , " seriennummern_wareneingaenge_list " );
2024-07-26 14:38:14 +02:00
$this -> app -> ActionHandler ( " enter " , " seriennummern_enter " );
$this -> app -> ActionHandler ( " delete " , " seriennummern_delete " );
2024-08-06 15:07:57 +02:00
$this -> app -> ActionHandler ( " remove " , " seriennummern_remove " );
2024-08-21 12:45:19 +02:00
$this -> app -> ActionHandler ( " minidetail_lieferscheinposition " , " seriennummern_lieferscheinpos_minidetail " );
2024-09-19 21:21:43 +02:00
$this -> app -> ActionHandler ( " minidetail_wareneingangposition " , " seriennummern_wareneingang_minidetail " );
2024-08-04 22:05:35 +02:00
$this -> app -> ActionHandler ( " minidetail " , " seriennummern_minidetail " );
2024-07-26 14:38:14 +02:00
$this -> app -> DefaultActionHandler ( " list " );
$this -> app -> ActionHandlerListen ( $app );
}
public function Install () {
/* Fill out manually later */
}
static function TableSearch ( & $app , $name , $erlaubtevars ) {
switch ( $name ) {
case " seriennummern_list " :
$allowed [ 'seriennummern_list' ] = array ( 'list' );
2024-08-06 15:07:57 +02:00
// $heading = array('Artikel-Nr.','Artikel', 'Seriennummer','Erfasst am','Eingelagert','Adresse','Lieferschein','Lieferdatum', 'Menü');
2024-08-21 12:45:19 +02:00
$heading = array ( '' , '' , 'Artikel-Nr.' , 'Artikel' , 'Seriennummer' , 'Erfasst am' , 'Eingelagert' , 'Menü' );
$width = array ( '1%' , '1%' , '10%' , '20%' , '20%' , '10%' , '1%' , '1%' ); // Fill out manually later
2024-07-26 14:38:14 +02:00
// columns that are aligned right (numbers etc)
// $alignright = array(4,5,6,7,8);
2024-08-06 15:07:57 +02:00
// $findcols = array('a.nummer', 'a.name_de', 's.seriennummer','s.datum','s.eingelagert','lh.adresse_name','lh.belegnr','lh.datum','s.id');
2024-08-21 12:45:19 +02:00
$findcols = array ( 's.id' , 's.id' , 'a.nummer' , 'a.name_de' , 's.seriennummer' , 's.datum' , 's.eingelagert' , 's.id' );
2024-07-28 13:42:28 +02:00
$searchsql = array ( 'a.nummer' , 'a.name_de' , 's.seriennummer' );
2024-07-26 14:38:14 +02:00
$defaultorder = 1 ;
$defaultorderdesc = 0 ;
$aligncenter = array ();
$alignright = array ();
$numbercols = array ();
$sumcol = array ();
$dropnbox = " '<img src=./themes/new/images/details_open.png class=details>' AS `open`, CONCAT('<input type= \" checkbox \" name= \" auswahl[] \" value= \" ',s.id,' \" />') AS `auswahl` " ;
2024-08-21 12:45:19 +02:00
$moreinfo = true ; // Allow drop down details
2024-07-26 14:38:14 +02:00
// $moreinfoaction = "lieferschein"; // specify suffix for minidetail-URL to allow different minidetails
2024-08-21 12:45:19 +02:00
$menucol = 1 ; // Set id col for moredata/menu
2024-07-26 14:38:14 +02:00
$menu = " <table cellpadding=0 cellspacing=0><tr><td nowrap> " . " <a href= \" # \" onclick=DeleteDialog( \" index.php?module=seriennummern&action=delete&id=%value% \" );> " . " <img src= \" themes/ { $app -> Conf -> WFconf [ 'defaulttheme' ] } /images/delete.svg \" border= \" 0 \" ></a> " . " </td></tr></table> " ;
2024-08-03 20:11:59 +02:00
$lieferschein_link = array (
'<a href="index.php?module=lieferschein&action=edit&id=' ,
[ 'sql' => 'lh.lieferschein' ],
'">' ,
[ 'sql' => 'lh.belegnr' ],
'</a>' ,
);
2024-08-06 15:07:57 +02:00
$sql_columns = "
s . id ,
2024-08-21 12:45:19 +02:00
$dropnbox ,
2024-08-06 15:07:57 +02:00
CONCAT ( '<a href=\"index.php?module=artikel&action=edit&id=' , a . id , '\">' , a . nummer , '</a>' ) as nummer ,
a . name_de ,
s . seriennummer ,
" . $app->erp ->FormatDateTime( " s . datum " ). " ,
if ( s . eingelagert , 'Ja' , 'Nein' ),
s . id
2024-08-03 20:11:59 +02:00
" ;
$sql_tables = "
2024-07-26 14:38:14 +02:00
seriennummern s
INNER JOIN
artikel a ON s . artikel = a . id
2024-08-03 20:11:59 +02:00
LEFT JOIN (
SELECT DISTINCT
slp . seriennummer ,
a . id adresse ,
a . name adresse_name ,
l . datum ,
l . id lieferschein ,
l . belegnr
FROM
2024-09-27 18:23:38 +02:00
seriennummern_beleg_position slp
2024-08-03 20:11:59 +02:00
INNER JOIN lieferschein_position lp ON
2024-09-27 18:23:38 +02:00
lp . id = slp . beleg_position
2024-08-03 20:11:59 +02:00
INNER JOIN lieferschein l ON
l . id = lp . lieferschein
INNER JOIN adresse a ON
a . id = l . adresse
2024-09-27 18:23:38 +02:00
WHERE slp . beleg_typ = 'lieferschein'
2024-08-03 20:11:59 +02:00
ORDER BY
l . datum
DESC
,
l . id
DESC
) lh ON lh . seriennummer = s . id
2024-07-26 14:38:14 +02:00
" ;
2024-07-28 13:42:28 +02:00
$artikel_id = $app -> User -> GetParameter ( 'seriennummern_artikel_id' );
$where = " (a.id = ' " . $artikel_id . " ' OR ' " . $artikel_id . " ' = '') " ;
2024-08-03 20:11:59 +02:00
$count = " SELECT COUNT(DISTINCT s.id) FROM " . $sql_tables . " WHERE " . $where ;
2024-07-28 13:42:28 +02:00
// Toggle filters
$app -> Tpl -> Add ( 'JQUERYREADY' , " $ ('#verfuegbar').click( function() { fnFilterColumn1( 0 ); } ); " );
2024-08-03 20:11:59 +02:00
$app -> Tpl -> Add ( 'JQUERYREADY' , " $ ('#ausgelagert').click( function() { fnFilterColumn2( 0 ); } ); " );
$app -> Tpl -> Add ( 'JQUERYREADY' , " $ ('#versendet').click( function() { fnFilterColumn3( 0 ); } ); " );
2024-07-28 13:42:28 +02:00
2024-08-03 20:11:59 +02:00
for ( $r = 1 ; $r <= 3 ; $r ++ ) {
2024-07-28 13:42:28 +02:00
$app -> Tpl -> Add ( 'JAVASCRIPT' , '
function fnFilterColumn ' . $r . ' ( i )
{
if ( oMoreData ' . $r . $name . ' == 1 )
oMoreData ' . $r . $name . ' = 0 ;
else
oMoreData ' . $r . $name . ' = 1 ;
$ ( \ '#' . $name . ' \ ' ) . dataTable () . fnFilter (
\ ' \ ' ,
i ,
0 , 0
);
}
' );
}
$more_data1 = $app -> Secure -> GetGET ( " more_data1 " );
if ( $more_data1 == 1 ) {
2024-08-03 13:27:45 +02:00
$where .= " AND s.eingelagert = 1 " ;
2024-07-28 13:42:28 +02:00
} else {
}
$more_data2 = $app -> Secure -> GetGET ( " more_data2 " );
if ( $more_data2 == 1 ) {
2024-08-03 20:11:59 +02:00
$where .= " AND s.eingelagert = 0 " ;
2024-07-28 13:42:28 +02:00
} else {
}
2024-08-03 20:11:59 +02:00
$more_data3 = $app -> Secure -> GetGET ( " more_data3 " );
if ( $more_data3 == 1 ) {
$where .= " AND lh.seriennummer IS NOT NULL " ;
} else {
}
$groupby = " GROUP BY s.id " ;
$sql = " SELECT SQL_CALC_FOUND_ROWS " . $sql_columns . " FROM " . $sql_tables ;
// echo($sql." WHERE ".$where." ".$groupby);
// echo($count);
2024-07-26 14:38:14 +02:00
break ;
case " seriennummern_artikel_list " :
$allowed [ 'seriennummern_artikel_list' ] = array ( 'list' );
2024-08-04 14:22:13 +02:00
$heading = array ( 'Artikel-Nr.' , 'Artikel' , 'Lagermenge' , 'Nummern verfügbar' , 'Nummern ausgeliefert' , 'Nummern gesamt' , 'Menü' , '' );
2024-08-06 15:07:57 +02:00
$width = array ( '10%' , '90%' , '1%' , '1%' , '1%' , '1%' , '1%' ); // Fill out manually later
2024-07-26 14:38:14 +02:00
// columns that are aligned right (numbers etc)
// $alignright = array(4,5,6,7,8);
2024-08-04 14:22:13 +02:00
$findcols = array ( 'a.nummer' , 'a.name_de' , 'null' , 'null' , 'null' , 'null' , 'null' , 'null' );
2024-07-26 14:38:14 +02:00
$searchsql = array ( 'a.name_de' , 'a.nummer' );
$menucol = 1 ;
$defaultorder = 1 ;
$defaultorderdesc = 0 ;
$aligncenter = array ();
2024-08-04 14:22:13 +02:00
$alignright = array ( 3 , 4 , 5 , 6 , 7 );
2024-07-26 14:38:14 +02:00
$numbercols = array ();
$sumcol = array ();
$dropnbox = " '<img src=./themes/new/images/details_open.png class=details>' AS `open`, CONCAT('<input type= \" checkbox \" name= \" auswahl[] \" value= \" ',a.id,' \" />') AS `auswahl` " ;
// $moreinfo = true; // Allow drop down details
// $moreinfoaction = "lieferschein"; // specify suffix for minidetail-URL to allow different minidetails
// $menucol = 11; // Set id col for moredata/menu
$menu_link = array (
'<a href="index.php?module=seriennummern&action=enter&artikel=' ,
[ 'sql' => 'a.id' ],
'">' ,
2024-07-27 11:41:05 +02:00
'<img src="./themes/' . $app -> Conf -> WFconf [ 'defaulttheme' ] . '/images/add.png" title="Neue Seriennummern erfassen" border="0">' ,
2024-07-28 13:42:28 +02:00
'</a>' ,
'<a href="index.php?module=seriennummern&action=nummern_list&artikel=' ,
[ 'sql' => 'a.id' ],
'">' ,
'<img src="./themes/' . $app -> Conf -> WFconf [ 'defaulttheme' ] . '/images/lupe.svg" title="Seriennummern anzeigen" border="0">' ,
2024-07-26 14:38:14 +02:00
'</a>'
);
$sql = " SELECT SQL_CALC_FOUND_ROWS
a . id ,
CONCAT ( '<a href=\"index.php?module=artikel&action=edit&id=' , a . id , '\">' , a . nummer , '</a>' ) as nummer ,
a . name_de ,
2024-07-27 11:41:05 +02:00
" . $app->erp ->FormatMenge('auf_lager.anzahl'). " ,
2024-08-03 20:11:59 +02:00
SUM ( if ( s . eingelagert = 1 , 1 , 0 )),
SUM ( if ( s . eingelagert = 0 , 1 , 0 )),
2024-07-26 14:38:14 +02:00
SUM ( if ( s . id IS NULL , 0 , 1 )),
" . $app->erp ->ConcatSQL( $menu_link ). " ,
a . id
FROM
artikel a
LEFT JOIN
(
SELECT
a . id ,
a . nummer ,
a . name_de name ,
SUM ( lpi . menge ) anzahl
FROM
artikel a
INNER JOIN lager_platz_inhalt lpi ON
a . id = lpi . artikel
WHERE
a . seriennummern <> 'keine' AND a . seriennummern <> ''
GROUP BY
a . id
) auf_lager ON auf_lager . id = a . id
LEFT JOIN
2024-08-03 20:11:59 +02:00
seriennummern s ON s . artikel = a . id
2024-07-26 14:38:14 +02:00
" ;
$where = " a.seriennummern <> 'keine' AND a.seriennummern <> '' " ;
$groupby = " GROUP BY a.id " ;
2024-08-03 20:11:59 +02:00
$count = " SELECT count(DISTINCT a.id) FROM artikel a WHERE " . $where ;
// echo($sql." WHERE ".$where." ".$groupby);
// echo($count);
2024-07-26 14:38:14 +02:00
break ;
case " seriennummern_lieferscheine_list " :
$allowed [ 'seriennummern_artikel_list' ] = array ( 'list' );
2024-09-17 09:50:47 +02:00
$heading = array ( 'Lieferschein' , 'Datum' , 'Adresse' , 'Menge Artikel' , 'Nummern zugeordnet' , 'Nummern fehlen' , 'Menü' , '' );
2024-08-06 15:07:57 +02:00
$width = array ( '10%' , '10%' , '20%' , '1%' , '1%' , '1%' , '1%' , '1%' , '1%' ); // Fill out manually later
2024-07-26 14:38:14 +02:00
// columns that are aligned right (numbers etc)
2024-08-04 14:22:13 +02:00
$alignright = array ( 4 , 5 , 6 , 7 );
2024-07-26 14:38:14 +02:00
2024-08-04 14:22:13 +02:00
$findcols = array ( 'l.belegnr' , 'l.datum' , 'adr.name' , 'null' , 'null' , 'null' , 'null' , 'null' );
2024-08-03 13:27:45 +02:00
$searchsql = array ( 'l.belegnr' );
2024-07-26 14:38:14 +02:00
$defaultorder = 1 ;
$defaultorderdesc = 0 ;
$aligncenter = array ();
$numbercols = array ();
$sumcol = array ();
2024-08-03 13:27:45 +02:00
$dropnbox = " '<img src=./themes/new/images/details_open.png class=details>' AS `open`, CONCAT('<input type= \" checkbox \" name= \" auswahl[] \" value= \" ',l.id,' \" />') AS `auswahl` " ;
2024-07-26 14:38:14 +02:00
2024-08-03 13:27:45 +02:00
//$menu = "<table cellpadding=0 cellspacing=0><tr><td nowrap>" . "<a href=\"index.php?module=seriennummern&action=edit&id=%value%\"><img src=\"./themes/{$app->Conf->WFconf['defaulttheme']}/images/edit.svg\" border=\"0\"></a> <a href=\"#\" onclick=DeleteDialog(\"index.php?module=seriennummern&action=delete&id=%value%\");>" . "<img src=\"themes/{$app->Conf->WFconf['defaulttheme']}/images/delete.svg\" border=\"0\"></a>" . "</td></tr></table>";
2024-07-26 14:38:14 +02:00
2024-08-03 13:27:45 +02:00
$menu_link = array (
2024-08-06 15:07:57 +02:00
'<a href="index.php?module=seriennummern&action=enter&lieferschein=' ,
[ 'sql' => 'l.id' ],
2024-08-15 18:12:58 +02:00
'&from=seriennummern">' ,
2024-08-06 15:07:57 +02:00
'<img src="./themes/' . $app -> Conf -> WFconf [ 'defaulttheme' ] . '/images/edit.svg" title="Seriennummern erfassen" border="0">' ,
2024-08-03 13:27:45 +02:00
'</a>' ,
);
2024-07-26 14:38:14 +02:00
2024-08-03 20:11:59 +02:00
$lieferschein_link = array (
'<a href="index.php?module=lieferschein&action=edit&id=' ,
[ 'sql' => 'l.id' ],
'">' ,
[ 'sql' => 'l.belegnr' ],
'</a>' ,
);
2024-09-27 19:09:43 +02:00
$sql_columns = "
2024-08-03 13:27:45 +02:00
l . id ,
2024-08-03 20:11:59 +02:00
" . $app->erp ->ConcatSQL( $lieferschein_link ). " ,
2024-08-03 13:27:45 +02:00
" . $app->erp ->FormatDate( " l . datum " ). " ,
adr . name ,
2024-09-27 19:09:43 +02:00
" . $app->erp ->FormatMengeFuerFormular( " SUM ( menge ) " ). " ,
2024-09-28 12:30:41 +02:00
SUM ( COALESCE ( menge_nummern , 0 )),
" . $app->erp ->FormatMengeFuerFormular( " if ( SUM ( menge ) > SUM ( COALESCE ( menge_nummern , 0 )), SUM ( menge ) - SUM ( COALESCE ( menge_nummern , 0 )), 0 ) " ). " ,
2024-08-03 13:27:45 +02:00
" . $app->erp ->ConcatSQL( $menu_link ). " ,
2024-09-27 19:09:43 +02:00
l . id " ;
$sql_tables = "
2024-08-03 13:27:45 +02:00
lieferschein_position lp
INNER JOIN lieferschein l ON
l . id = lp . lieferschein
INNER JOIN artikel a ON
a . id = lp . artikel
INNER JOIN adresse adr ON
adr . id = l . adresse
2024-09-27 19:09:43 +02:00
LEFT JOIN (
SELECT
beleg_position ,
COUNT ( id ) menge_nummern
FROM
seriennummern_beleg_position
WHERE
beleg_typ = 'lieferschein'
GROUP BY
beleg_position
) sbp
ON sbp . beleg_position = lp . id
2024-07-26 14:38:14 +02:00
" ;
2024-08-06 15:07:57 +02:00
$where = " (a.seriennummern <> 'keine') " ;
// Toggle filters
$app -> Tpl -> Add ( 'JQUERYREADY' , " $ ('#altelieferscheine').click( function() { fnFilterColumn1( 0 ); } ); " );
for ( $r = 1 ; $r <= 1 ; $r ++ ) {
$app -> Tpl -> Add ( 'JAVASCRIPT' , '
function fnFilterColumn ' . $r . ' ( i )
{
if ( oMoreData ' . $r . $name . ' == 1 )
oMoreData ' . $r . $name . ' = 0 ;
else
oMoreData ' . $r . $name . ' = 1 ;
$ ( \ '#' . $name . ' \ ' ) . dataTable () . fnFilter (
\ ' \ ' ,
i ,
0 , 0
);
}
' );
}
$more_data1 = $app -> Secure -> GetGET ( " more_data1 " );
if ( $more_data1 == 1 ) {
} else {
$where .= " AND (l.datum >= (SELECT DATE(MIN(datum)) FROM seriennummern WHERE artikel = a.id)) " ;
}
2024-09-27 19:09:43 +02:00
$sql = " SELECT SQL_CALC_FOUND_ROWS " . $sql_columns . " FROM " . $sql_tables ;
$count = " SELECT COUNT(DISTINCT l.id) FROM " . $sql_tables . " WHERE " . $where ;
2024-08-03 13:27:45 +02:00
$groupby = " GROUP BY l.id " ;
2024-08-04 22:05:35 +02:00
break ;
2024-09-17 09:50:47 +02:00
case " seriennummern_wareneingaenge_list " :
$allowed [ 'seriennummern_wareneingaenge_list' ] = array ( 'list' );
$heading = array ( 'Paket-Nr.' , 'Datum' , 'Adresse' , 'Menge Artikel' , 'Nummern zugeordnet' , 'Nummern fehlen' , 'Menü' , '' );
$width = array ( '10%' , '10%' , '20%' , '1%' , '1%' , '1%' , '1%' , '1%' , '1%' ); // Fill out manually later
// columns that are aligned right (numbers etc)
$alignright = array ( 4 , 5 , 6 , 7 );
$findcols = array ( 'pa.id' , 'pa.datum' , 'adr.name' , 'null' , 'null' , 'null' , 'null' , 'null' );
$searchsql = array ( 'adr.name' );
$defaultorder = 1 ;
$defaultorderdesc = 0 ;
$aligncenter = array ();
$numbercols = array ();
$sumcol = array ();
$dropnbox = " '<img src=./themes/new/images/details_open.png class=details>' AS `open`, CONCAT('<input type= \" checkbox \" name= \" auswahl[] \" value= \" ',l.id,' \" />') AS `auswahl` " ;
//$menu = "<table cellpadding=0 cellspacing=0><tr><td nowrap>" . "<a href=\"index.php?module=seriennummern&action=edit&id=%value%\"><img src=\"./themes/{$app->Conf->WFconf['defaulttheme']}/images/edit.svg\" border=\"0\"></a> <a href=\"#\" onclick=DeleteDialog(\"index.php?module=seriennummern&action=delete&id=%value%\");>" . "<img src=\"themes/{$app->Conf->WFconf['defaulttheme']}/images/delete.svg\" border=\"0\"></a>" . "</td></tr></table>";
$menu_link = array (
'<a href="index.php?module=seriennummern&action=enter&wareneingang=' ,
[ 'sql' => 'pa.id' ],
'&from=seriennummern">' ,
'<img src="./themes/' . $app -> Conf -> WFconf [ 'defaulttheme' ] . '/images/edit.svg" title="Seriennummern erfassen" border="0">' ,
'</a>'
);
$wareneingang_link = array (
'<a href="index.php?module=wareneingang&action=distriinhalt&id=' ,
[ 'sql' => 'pa.id' ],
'">' ,
[ 'sql' => 'pa.id' ],
'</a>'
);
$sql = "
SELECT
pa . id ,
" . $app->erp ->ConcatSQL( $wareneingang_link ). " ,
" . $app->erp ->FormatDate( " pa . datum " ). " ,
adr . name adresse ,
2024-09-28 12:30:41 +02:00
" . $app->erp ->FormatMengeFuerFormular( " SUM ( menge ) " ). " menge ,
SUM ( COALESCE ( menge_nummern , 0 )),
" . $app->erp ->FormatMengeFuerFormular( " if ( SUM ( menge ) > SUM ( COALESCE ( menge_nummern , 0 )), SUM ( menge ) - SUM ( COALESCE ( menge_nummern , 0 )), 0 ) " ). " ,
2024-09-17 09:50:47 +02:00
" . $app->erp ->ConcatSQL( $menu_link ). "
FROM
paketannahme pa
INNER JOIN paketdistribution pd ON
pd . paketannahme = pa . id
INNER JOIN adresse adr ON
adr . id = pa . adresse
INNER JOIN artikel a ON
a . id = pd . artikel
2024-09-28 12:30:41 +02:00
LEFT JOIN (
SELECT
beleg_position ,
COUNT ( id ) menge_nummern
FROM
seriennummern_beleg_position
WHERE
beleg_typ = 'wareneingang'
GROUP BY
beleg_position
) sbp
ON sbp . beleg_position = pd . id
2024-09-17 09:50:47 +02:00
" ;
$where = " (a.seriennummern <> 'keine') " ;
// Toggle filters
$app -> Tpl -> Add ( 'JQUERYREADY' , " $ ('#geschlossenewareneingaenge').click( function() { fnFilterColumn1( 0 ); } ); " );
for ( $r = 1 ; $r <= 1 ; $r ++ ) {
$app -> Tpl -> Add ( 'JAVASCRIPT' , '
function fnFilterColumn ' . $r . ' ( i )
{
if ( oMoreData ' . $r . $name . ' == 1 )
oMoreData ' . $r . $name . ' = 0 ;
else
oMoreData ' . $r . $name . ' = 1 ;
$ ( \ '#' . $name . ' \ ' ) . dataTable () . fnFilter (
\ ' \ ' ,
i ,
0 , 0
);
}
' );
}
$more_data1 = $app -> Secure -> GetGET ( " more_data1 " );
if ( $more_data1 == 1 ) {
} else {
$where .= " AND (pa.status <> 'abgeschlossen') " ;
}
$count = " SELECT COUNT(DISTINCT pd.paketannahme) FROM
paketdistribution pd
INNER JOIN paketannahme pa ON pa . id = pd . paketannahme
2024-09-27 18:23:38 +02:00
INNER JOIN seriennummern_beleg_position spd
ON spd . beleg_typ = 'wareneingang' AND spd . beleg_position = pd . id
2024-09-17 09:50:47 +02:00
INNER JOIN artikel a ON
a . id = pd . artikel
" . " WHERE " . $where ;
$groupby = " GROUP BY pa.id " ;
break ;
2024-08-04 22:05:35 +02:00
case " seriennummern_lieferschein_positionen " :
2024-09-19 21:21:43 +02:00
$allowed [ 'seriennummern_lieferschein_positionen' ] = array ( 'list' );
2024-08-06 15:07:57 +02:00
$heading = array ( '' , '' , 'Position' , 'Artikel-Nr.' , 'Artikel' , 'Menge' , 'Nummern zugeordnet' , 'Nummern fehlen' , 'Menü' );
2024-08-04 22:05:35 +02:00
$width = array ( '1%' , '1%' , '10%' , '10%' , '20%' ); // Fill out manually later
$lieferschein_id = $app -> User -> GetParameter ( 'seriennummern_lieferschein_id' );
// columns that are aligned right (numbers etc)
$alignright = array ( 6 , 7 , 8 , 9 );
$findcols = array ( 'lp.id' , 'lp.id' , 'lp.sort' , 'a.nummer' , 'a.name_de' , 'null' , 'null' , 'null' , 'null' , 'null' , 'null' );
$searchsql = array ( 'l.belegnr' );
$moreinfo = true ; // Allow drop down details
2024-08-21 12:45:19 +02:00
$moreinfoaction = " _lieferscheinposition " ; // specify suffix for minidetail-URL to allow different minidetails
2024-08-04 22:05:35 +02:00
$menucol = 1 ; // Set id col for moredata/menu
$defaultorder = 1 ;
$defaultorderdesc = 0 ;
$aligncenter = array ();
$numbercols = array ();
$sumcol = array ();
$dropnbox = " '<img src=./themes/new/images/details_open.png class=details>' AS `open`, CONCAT('<input type= \" checkbox \" name= \" auswahl[] \" value= \" ',lp.id,' \" />') AS `auswahl` " ;
2024-08-21 12:45:19 +02:00
$menu = " <a href= \" # \" onclick=DeleteDialog( \" index.php?module=seriennummern&action=remove&id=%value%&from=lieferschein \" );> " . " <img src= \" themes/ { $app -> Conf -> WFconf [ 'defaulttheme' ] } /images/delete.svg \" border= \" 0 \" ></a> " ;
2024-08-04 22:05:35 +02:00
$lieferschein_link = array (
'<a href="index.php?module=lieferschein&action=edit&id=' ,
[ 'sql' => 'l.id' ],
'">' ,
[ 'sql' => 'l.belegnr' ],
'</a>' ,
);
$sql = " SELECT SQL_CALC_FOUND_ROWS
lp . id ,
$dropnbox ,
lp . sort ,
2024-09-19 21:21:43 +02:00
CONCAT ( '<a href=\"index.php?module=artikel&action=edit&id=' , a . id , '\">' , a . nummer , '</a>' ) as nummer ,
2024-08-04 22:05:35 +02:00
a . name_de ,
" . $app->erp ->FormatMengeFuerFormular( " menge " ). " ,
SUM ( if ( slp . id IS NULL , 0 , 1 )),
" . $app->erp ->FormatMengeFuerFormular( " menge - SUM ( if ( slp . id IS NULL , 0 , 1 )) " ). " ,
2024-08-06 15:07:57 +02:00
lp . id
2024-08-04 22:05:35 +02:00
FROM
lieferschein_position lp
2024-09-27 18:23:38 +02:00
LEFT JOIN seriennummern_beleg_position slp
ON slp . beleg_typ = 'lieferschein' AND slp . beleg_position = lp . id
2024-08-04 22:05:35 +02:00
INNER JOIN lieferschein l ON
l . id = lp . lieferschein
INNER JOIN artikel a ON
a . id = lp . artikel
INNER JOIN adresse adr ON
adr . id = l . adresse
" ;
$where = " (a.seriennummern <> 'keine') AND (l.id = ' " . $lieferschein_id . " ') " ;
$count = " SELECT COUNT(DISTINCT lp.lieferschein) FROM
lieferschein_position lp
2024-09-27 18:23:38 +02:00
LEFT JOIN seriennummern_beleg_position slp
ON slp . beleg_typ = 'lieferschein' AND slp . beleg_position = lp . id
2024-08-04 22:05:35 +02:00
INNER JOIN lieferschein l ON
l . id = lp . lieferschein
INNER JOIN artikel a ON
a . id = lp . artikel
" . " WHERE " . $where ;
$groupby = " GROUP BY lp.id " ;
2024-08-07 12:11:32 +02:00
$orderby = " ORDER BY lp.sort ASC " ;
2024-08-04 22:05:35 +02:00
// echo($sql." WHERE ".$where." ".$groupby);
2024-07-26 14:38:14 +02:00
break ;
2024-09-19 21:21:43 +02:00
case 'seriennummern_wareneingang_positionen' :
$allowed [ 'seriennummern_wareneingang_positionen' ] = array ( 'list' );
$heading = array ( '' , '' , 'Position' , 'Artikel-Nr.' , 'Artikel' , 'Menge' , 'Nummern zugeordnet' , 'Nummern fehlen' , 'Menü' );
$width = array ( '1%' , '1%' , '10%' , '10%' , '20%' ); // Fill out manually later
$wareneingang_id = $app -> User -> GetParameter ( 'seriennummern_wareneingang_id' );
// columns that are aligned right (numbers etc)
$alignright = array ( 6 , 7 , 8 , 9 );
$findcols = array ( 'pd.id' , 'pd.id' , 'pd.id' , 'a.nummer' , 'a.name_de' , 'null' , 'null' , 'null' , 'null' , 'null' , 'null' );
$searchsql = array ( 'w.id' );
$moreinfo = true ; // Allow drop down details
$moreinfoaction = " _wareneingangposition " ; // specify suffix for minidetail-URL to allow different minidetails
$menucol = 1 ; // Set id col for moredata/menu
$defaultorder = 1 ;
$defaultorderdesc = 0 ;
$aligncenter = array ();
$numbercols = array ();
$sumcol = array ();
$dropnbox = " '<img src=./themes/new/images/details_open.png class=details>' AS `open`, CONCAT('<input type= \" checkbox \" name= \" auswahl[] \" value= \" ',pd.id,' \" />') AS `auswahl` " ;
$menu = " <a href= \" # \" onclick=DeleteDialog( \" index.php?module=seriennummern&action=remove&id=%value%&from=wareneingang \" );> " . " <img src= \" themes/ { $app -> Conf -> WFconf [ 'defaulttheme' ] } /images/delete.svg \" border= \" 0 \" ></a> " ;
$wareneingang_link = array (
'<a href="index.php?module=wareneingang&action=edit&id=' ,
[ 'sql' => 'w.id' ],
'">' ,
[ 'sql' => 'w.id' ],
'</a>' ,
);
$sql = " SELECT SQL_CALC_FOUND_ROWS
pd . id ,
$dropnbox ,
pd . id ,
CONCAT ( '<a href=\"index.php?module=artikel&action=edit&id=' , a . id , '\">' , a . nummer , '</a>' ) as nummer ,
a . name_de ,
" . $app->erp ->FormatMengeFuerFormular( " menge " ). " ,
SUM ( if ( spd . id IS NULL , 0 , 1 )),
" . $app->erp ->FormatMengeFuerFormular( " menge - SUM ( if ( spd . id IS NULL , 0 , 1 )) " ). " ,
pd . id
FROM
paketdistribution pd
2024-09-27 18:23:38 +02:00
LEFT JOIN seriennummern_beleg_position spd
ON spd . beleg_typ = 'wareneingang' AND spd . beleg_position = pd . id
2024-09-19 21:21:43 +02:00
INNER JOIN paketannahme pa ON
pa . id = pd . paketannahme
INNER JOIN artikel a ON
a . id = pd . artikel
INNER JOIN adresse adr ON
adr . id = pa . adresse
" ;
$where = " (a.seriennummern <> 'keine') AND (pa.id = ' " . $wareneingang_id . " ') " ;
$count = " SELECT COUNT(DISTINCT pd.id) FROM
paketdistribution pd
2024-09-27 18:23:38 +02:00
LEFT JOIN seriennummern_beleg_position spd
ON spd . beleg_typ = 'wareneingang' AND spd . beleg_position = pd . id
2024-09-19 21:21:43 +02:00
INNER JOIN paketannahme pa ON
pa . id = pd . paketannahme
INNER JOIN artikel a ON
a . id = pd . artikel
" . " WHERE " . $where ;
$groupby = " GROUP BY pd.id " ;
$orderby = " ORDER BY pd.id ASC " ;
// echo($sql." WHERE ".$where." ".$groupby);
break ;
2024-07-26 14:38:14 +02:00
}
$erg = false ;
foreach ( $erlaubtevars as $k => $v ) {
if ( isset ( $$v )) {
$erg [ $v ] = $$v ;
}
}
return $erg ;
}
2024-07-28 13:42:28 +02:00
function seriennummern_menu () {
2024-09-19 21:21:43 +02:00
$from = $this -> app -> Secure -> GetGET ( 'from' );
$artikel = $this -> app -> Secure -> GetGET ( 'artikel' );
switch ( $from ) {
case 'artikel' :
$this -> app -> erp -> MenuEintrag ( " index.php?module=artikel&action=edit&id= " . $artikel , " Zurück " );
break ;
}
2024-07-26 14:38:14 +02:00
$this -> app -> erp -> MenuEintrag ( " index.php?module=seriennummern&action=list " , " Übersicht " );
2024-07-28 13:42:28 +02:00
$this -> app -> erp -> MenuEintrag ( " index.php?module=seriennummern&action=nummern_list " , " Seriennummern " );
2024-08-03 13:27:45 +02:00
$this -> app -> erp -> MenuEintrag ( " index.php?module=seriennummern&action=lieferscheine_list " , " Lieferscheine " );
2024-09-17 09:50:47 +02:00
$this -> app -> erp -> MenuEintrag ( " index.php?module=seriennummern&action=wareneingaenge_list " , " Wareneingänge " );
2024-07-28 13:42:28 +02:00
// $this->app->erp->MenuEintrag("index.php", "Zurück");
}
2024-09-18 20:12:54 +02:00
2024-07-28 13:42:28 +02:00
function seriennummern_nummern_list () {
2024-08-03 20:11:59 +02:00
$this -> seriennummern_menu ();
2024-09-17 09:50:47 +02:00
$this -> seriennummern_menu_checks ();
2024-09-19 21:21:43 +02:00
2024-07-28 13:42:28 +02:00
// For transfer to tablesearch
$artikel_id = $this -> app -> Secure -> GetGET ( 'artikel' );
$this -> app -> User -> SetParameter ( 'seriennummern_artikel_id' , $artikel_id );
if ( empty ( $artikel_id )) {
$this -> app -> Tpl -> Set ( 'ARTIKEL_HIDDEN' , " hidden " );
} else {
$artikel = $this -> app -> DB -> SelectRow ( " SELECT name_de, nummer FROM artikel WHERE id =' " . $artikel_id . " ' " );
$check_seriennummern = $this -> seriennummern_check_serials ( $artikel_id );
$check_seriennummern = $check_seriennummern [ 0 ];
$this -> app -> Tpl -> SetText ( 'KURZUEBERSCHRIFT1' , 'Anzeigen' );
$this -> app -> Tpl -> SetText ( 'KURZUEBERSCHRIFT2' , $artikel [ 'name_de' ] . " (Artikel " . $artikel [ 'nummer' ] . " ) " );
$anzahl_fehlt = $check_seriennummern [ 'menge_auf_lager' ] - $check_seriennummern [ 'menge_nummern' ];
if ( $anzahl_fehlt == 0 ) {
$this -> app -> Tpl -> addMessage ( 'success' , 'Seriennummern vollständig.' );
}
if ( $anzahl_fehlt < 0 ) {
$anzahl_fehlt = 0 ;
}
$letzte_seriennummer = ( string ) $this -> app -> DB -> Select ( " SELECT seriennummer FROM seriennummern WHERE artikel = ' " . $artikel_id . " ' ORDER BY id DESC LIMIT 1 " );
$this -> app -> Tpl -> Set ( 'LETZTE' , $letzte_seriennummer );
$this -> app -> Tpl -> Set ( 'ANZAHL' , $anzahl_fehlt );
$this -> app -> Tpl -> Set ( 'ARTIKEL_ID' , $artikel_id );
$this -> app -> Tpl -> Set ( 'ARTIKELNUMMER' , '<a href="index.php?module=artikel&action=edit&id=' . $check_seriennummern [ 'id' ] . '">' . $check_seriennummern [ 'nummer' ] . '</a>' );
$this -> app -> Tpl -> Set ( 'ARTIKEL' , $check_seriennummern [ 'name' ]);
$this -> app -> Tpl -> Set ( 'ANZLAGER' , $check_seriennummern [ 'menge_auf_lager' ]);
$this -> app -> Tpl -> Set ( 'ANZVORHANDEN' , $check_seriennummern [ 'menge_nummern' ]);
$this -> app -> Tpl -> Set ( 'ANZFEHLT' , $anzahl_fehlt );
}
$this -> app -> YUI -> TableSearch ( 'TAB1' , 'seriennummern_list' , " show " , " " , " " , basename ( __FILE__ ), __CLASS__ );
2024-08-04 22:05:35 +02:00
2024-07-28 13:42:28 +02:00
$this -> app -> Tpl -> Parse ( 'PAGE' , " seriennummern_nummern_list.tpl " );
}
2024-09-17 09:50:47 +02:00
function seriennummern_menu_checks () {
2024-07-28 13:42:28 +02:00
$this -> seriennummern_check_and_message ( null );
2024-09-18 20:12:54 +02:00
$this -> seriennummern_check_and_message_delivery_notes ( null );
$this -> seriennummern_check_and_message_incoming_goods ( null );
2024-09-17 09:50:47 +02:00
}
function seriennummern_artikel_list () {
$this -> seriennummern_menu ();
$this -> seriennummern_menu_checks ();
2024-07-28 13:42:28 +02:00
$this -> app -> YUI -> TableSearch ( 'TAB1' , 'seriennummern_artikel_list' , " show " , " " , " " , basename ( __FILE__ ), __CLASS__ );
2024-07-26 14:38:14 +02:00
$this -> app -> Tpl -> Parse ( 'PAGE' , " seriennummern_list.tpl " );
}
2024-08-03 13:27:45 +02:00
function seriennummern_lieferscheine_list () {
$this -> seriennummern_menu ();
2024-09-17 09:50:47 +02:00
$this -> seriennummern_menu_checks ();
2024-08-03 13:27:45 +02:00
$this -> app -> YUI -> TableSearch ( 'TAB1' , 'seriennummern_lieferscheine_list' , " show " , " " , " " , basename ( __FILE__ ), __CLASS__ );
2024-08-06 15:07:57 +02:00
$this -> app -> Tpl -> Parse ( 'PAGE' , " seriennummern_lieferscheine_list.tpl " );
2024-08-03 13:27:45 +02:00
}
2024-09-17 09:50:47 +02:00
function seriennummern_wareneingaenge_list () {
$this -> seriennummern_menu ();
$this -> seriennummern_menu_checks ();
$this -> app -> YUI -> TableSearch ( 'TAB1' , 'seriennummern_wareneingaenge_list' , " show " , " " , " " , basename ( __FILE__ ), __CLASS__ );
$this -> app -> Tpl -> Parse ( 'PAGE' , " seriennummern_wareneingaenge_list.tpl " );
}
2024-07-28 13:42:28 +02:00
2024-07-26 14:38:14 +02:00
public function seriennummern_delete () {
$id = ( int ) $this -> app -> Secure -> GetGET ( 'id' );
2024-08-06 15:07:57 +02:00
if ( $id ) {
2024-09-19 21:21:43 +02:00
if (
2024-09-27 18:23:38 +02:00
! $this -> app -> DB -> Select ( " SELECT id FROM `seriennummern_beleg_position` WHERE `seriennummer` = ' { $id } ' " )
2024-09-19 21:21:43 +02:00
) {
2024-08-06 15:07:57 +02:00
$this -> app -> DB -> Delete ( " DELETE FROM `seriennummern` WHERE `id` = ' { $id } ' " );
$this -> app -> Tpl -> addMessage ( 'error' , 'Der Eintrag wurde gelöscht' );
} else {
2024-09-19 21:21:43 +02:00
$this -> app -> Tpl -> addMessage ( 'error' , 'Der Eintrag kann nicht gelöscht werden da eine Zuordnung existiert!' );
2024-08-06 15:07:57 +02:00
}
$this -> seriennummern_nummern_list ();
2024-07-26 14:38:14 +02:00
}
2024-08-06 15:07:57 +02:00
}
public function seriennummern_remove () {
2024-08-21 12:45:19 +02:00
$id = ( int ) $this -> app -> Secure -> GetGET ( 'id' );
$from = $this -> app -> Secure -> GetGET ( 'from' );
2024-09-19 21:21:43 +02:00
if ( empty ( $id )) {
return ;
}
switch ( $from ) {
case 'lieferschein' :
$sql = " SELECT l.id, l.schreibschutz FROM lieferschein l INNER JOIN lieferschein_position lp ON l.id = lp.lieferschein WHERE lp.id = ' " . $id . " ' LIMIT 1 " ;
$lieferschein = $this -> app -> DB -> SelectRow ( $sql );
if ( $lieferschein [ 'schreibschutz' ]) {
$msg = $this -> app -> erp -> base64_url_encode ( " <div class= \" error \" >Der Lieferschein ist schreibgeschützt.</div> " );
} else {
2024-09-27 18:23:38 +02:00
$sql = " SELECT seriennummer FROM seriennummern_beleg_position WHERE beleg_typ = 'lieferschein' AND `beleg_position` = ' { $id } ' " ;
2024-09-19 21:21:43 +02:00
$seriennummer_ids = $this -> app -> DB -> SelectArr ( $sql );
2024-09-27 18:23:38 +02:00
if ( ! $this -> app -> DB -> Delete ( " DELETE FROM `seriennummern_beleg_position` WHERE beleg_typ = 'lieferschein' AND `beleg_position` = ' { $id } ' " )) {
2024-09-19 21:21:43 +02:00
$msg = $this -> app -> erp -> base64_url_encode ( " <div class= \" error \" >Die Einträge wurden nicht gelöscht!</div> " );
} else {
$msg = $this -> app -> erp -> base64_url_encode ( " <div class= \" success \" >Die Einträge wurden gelöscht.</div> " );
if ( ! empty ( $seriennummer_ids )) {
$sql = " UPDATE seriennummern SET eingelagert = 1, logdatei = CURRENT_TIMESTAMP WHERE id IN ( " . implode ( ', ' , array_column ( $seriennummer_ids , 'seriennummer' )) . " ) " ;
$this -> app -> DB -> Update ( $sql );
}
2024-08-21 12:45:19 +02:00
}
2024-09-19 21:21:43 +02:00
}
$this -> app -> Location -> execute ( " index.php?module=seriennummern&action=enter&lieferschein= " . $lieferschein [ 'id' ] . " &msg= $msg &from= $from " );
break ;
case 'wareneingang' :
$sql = " SELECT pa.id, pa.status FROM paketannahme pa INNER JOIN paketdistribution pd ON pa.id = pd.paketannahme WHERE pd.id = ' " . $id . " ' LIMIT 1 " ;
$wareneingang = $this -> app -> DB -> SelectRow ( $sql );
if ( $wareneingang [ 'status' ] == 'abgeschlossen' ) {
$msg = $this -> app -> erp -> base64_url_encode ( " <div class= \" error \" >Der Wareneingang ist abgeschlossen.</div> " );
} else {
2024-09-27 18:23:38 +02:00
$sql = " SELECT seriennummer FROM seriennummern_beleg_position WHERE beleg_typ = 'wareneingang' AND `beleg_position` = ' { $id } ' " ;
2024-09-19 21:21:43 +02:00
$seriennummer_ids = $this -> app -> DB -> SelectArr ( $sql );
2024-09-27 18:23:38 +02:00
if ( ! $this -> app -> DB -> Delete ( " DELETE FROM `seriennummern_beleg_position` WHERE beleg_typ = 'wareneingang' AND `beleg_position` = ' { $id } ' " )) {
2024-09-19 21:21:43 +02:00
$msg = $this -> app -> erp -> base64_url_encode ( " <div class= \" error \" >Die Einträge wurden nicht gelöscht!</div> " );
} else {
$msg = $this -> app -> erp -> base64_url_encode ( " <div class= \" success \" >Die Einträge wurden gelöscht.</div> " );
if ( ! empty ( $seriennummer_ids )) {
$sql = " UPDATE seriennummern SET eingelagert = 0, logdatei = CURRENT_TIMESTAMP WHERE id IN ( " . implode ( ', ' , array_column ( $seriennummer_ids , 'seriennummer' )) . " ) " ;
$this -> app -> DB -> Update ( $sql );
}
}
}
$this -> app -> Location -> execute ( " index.php?module=seriennummern&action=enter&wareneingang= " . $wareneingang [ 'id' ] . " &msg= $msg &from= $from " );
break ;
}
2024-07-26 14:38:14 +02:00
}
function seriennummern_enter () {
$this -> app -> erp -> MenuEintrag ( " index.php?module=seriennummern&action=list " , " Zurück zur Übersicht " );
2024-08-04 22:05:35 +02:00
$task = " " ;
2024-08-15 18:12:58 +02:00
$from = $this -> app -> Secure -> GetGET ( 'from' );
2024-07-26 14:38:14 +02:00
$artikel_id = ( int ) $this -> app -> Secure -> GetGET ( 'artikel' );
2024-08-04 22:05:35 +02:00
if ( ! empty ( $artikel_id )) {
$artikel = $this -> app -> DB -> SelectRow ( " SELECT name_de, nummer FROM artikel WHERE id =' " . $artikel_id . " ' " );
$this -> app -> Tpl -> SetText ( 'KURZUEBERSCHRIFT1' , 'Erfassen' );
$this -> app -> Tpl -> SetText ( 'KURZUEBERSCHRIFT2' , $artikel [ 'name_de' ] . " (Artikel " . $artikel [ 'nummer' ] . " ) " );
2024-09-19 21:21:43 +02:00
$this -> app -> Tpl -> SetText ( 'LEGEND' , '<a href="index.php?module=artikel&action=edit&id=' . $artikel_id . '">' . $artikel [ 'name_de' ] . ' (Artikel ' . $artikel [ 'nummer' ] . ')</a>' , html : true );
2024-08-04 22:05:35 +02:00
$task = " artikel " ;
}
2024-07-26 14:38:14 +02:00
2024-09-19 21:21:43 +02:00
$wareneingang_id = ( int ) $this -> app -> Secure -> GetGET ( 'wareneingang' );
if ( ! empty ( $wareneingang_id )) {
$this -> app -> User -> SetParameter ( 'seriennummern_wareneingang_id' , $wareneingang_id );
$this -> app -> Tpl -> SetText ( 'KURZUEBERSCHRIFT1' , 'Erfassen' );
$this -> app -> Tpl -> SetText ( 'KURZUEBERSCHRIFT2' , 'Wareneingang ' . $wareneingang_id );
$this -> app -> Tpl -> SetText ( 'LEGEND' , '<a href="index.php?module=wareneingang&action=distriinhalt&id=' . $wareneingang_id . '">Wareneingang ' . $wareneingang_id . '</a>' , html : true );
$task = " wareneingang " ;
}
2024-08-04 22:05:35 +02:00
$lieferschein_id = ( int ) $this -> app -> Secure -> GetGET ( 'lieferschein' );
if ( ! empty ( $lieferschein_id )) {
$this -> app -> User -> SetParameter ( 'seriennummern_lieferschein_id' , $lieferschein_id );
$lieferschein = $this -> app -> DB -> SelectRow ( " SELECT belegnr FROM lieferschein WHERE id =' " . $lieferschein_id . " ' " );
$this -> app -> Tpl -> SetText ( 'KURZUEBERSCHRIFT1' , 'Erfassen' );
$this -> app -> Tpl -> SetText ( 'KURZUEBERSCHRIFT2' , 'Lieferschein ' . $lieferschein [ 'belegnr' ]);
2024-09-19 21:21:43 +02:00
$this -> app -> Tpl -> SetText ( 'LEGEND' , '<a href="index.php?module=lieferschein&action=edit&id=' . $lieferschein_id . '">Lieferschein ' . $lieferschein [ 'belegnr' ] . '</a>' , html : true );
2024-08-04 22:05:35 +02:00
$task = " lieferschein " ;
}
2024-07-26 14:38:14 +02:00
2024-08-03 20:11:59 +02:00
$allowold = $this -> app -> Secure -> GetPOST ( 'allowold' );
2024-07-26 14:38:14 +02:00
$submit = $this -> app -> Secure -> GetPOST ( 'submit' );
$seriennummern = array ();
$seriennummern_text = $this -> app -> Secure -> GetPOST ( 'seriennummern' );
$seriennummern = explode ( '\n' , str_replace ([ '\r' ], '' , $seriennummern_text ));
switch ( $submit ) {
2024-08-06 15:07:57 +02:00
case 'assistent' :
$praefix = $this -> app -> Secure -> GetPOST ( 'praefix' );
$start = $this -> app -> Secure -> GetPOST ( 'start' );
$postfix = $this -> app -> Secure -> GetPOST ( 'postfix' );
$anzahl = ( int ) $this -> app -> Secure -> GetPOST ( 'anzahl' );
while ( $anzahl ) {
$seriennummern [] = $praefix . $start . $postfix ;
$anzahl -- ;
$start ++ ;
}
break ;
2024-07-26 14:38:14 +02:00
case 'hinzufuegen' :
2024-08-04 22:05:35 +02:00
$eingabescan = $this -> app -> Secure -> GetPOST ( 'eingabescan' );
$eingabe = $this -> app -> Secure -> GetPOST ( 'eingabe' );
2024-07-26 14:38:14 +02:00
if ( ! empty ( $eingabe )) {
$seriennummern [] = $eingabe ;
}
2024-08-04 22:05:35 +02:00
if ( ! empty ( $eingabescan )) {
$seriennummern [] = $eingabescan ;
}
2024-07-26 14:38:14 +02:00
break ;
2024-08-04 22:05:35 +02:00
case 'einlagern' :
2024-07-26 14:38:14 +02:00
$seriennummern_not_written = array ();
2024-08-03 20:11:59 +02:00
$seriennummern_already_exist = array ();
$seriennummern_old_not_allowed = array ();
2024-07-26 14:38:14 +02:00
foreach ( $seriennummern as $seriennummer ) {
$seriennummer = trim ( $seriennummer );
if ( empty ( $seriennummer )) {
continue ;
}
2024-08-03 20:11:59 +02:00
$sql = " SELECT id, eingelagert FROM seriennummern WHERE seriennummer = ' " . $this -> app -> DB -> real_escape_string ( $seriennummer ) . " ' AND artikel = ' " . $artikel_id . " ' " ;
$check_existing = $this -> app -> DB -> SelectRow ( $sql );
if ( empty ( $check_existing )) { // New serial
$sql = " INSERT INTO seriennummern (seriennummer, artikel, logdatei, eingelagert) VALUES (' " . $this -> app -> DB -> real_escape_string ( $seriennummer ) . " ', ' " . $artikel_id . " ', CURRENT_TIMESTAMP, 1) " ;
try {
$this -> app -> DB -> Insert ( $sql );
} catch ( mysqli_sql_exception $e ) {
$error = true ;
$seriennummern_not_written [] = $seriennummer ;
}
} else {
if ( $check_existing [ 'eingelagert' ]) { // Old serial, already here
$seriennummern_already_exist [] = $seriennummer ;
} else { // Old serial, returning
if ( $allowold ) {
$sql = " UPDATE seriennummern SET eingelagert = 1, logdatei = CURRENT_TIMESTAMP WHERE seriennummer = ' " . $this -> app -> DB -> real_escape_string ( $seriennummer ) . " ' AND artikel = ' " . $artikel_id . " ' " ;
$this -> app -> DB -> Update ( $sql );
} else {
$seriennummern_old_not_allowed [] = $seriennummer ;
}
}
}
2024-07-26 14:38:14 +02:00
}
2024-08-03 20:11:59 +02:00
if ( ! empty ( $seriennummern_already_exist )) {
$this -> app -> Tpl -> addMessage ( 'error' , 'Seriennummern existieren bereits: ' . implode ( ', ' , $seriennummern_already_exist ));
}
if ( ! empty ( $seriennummern_old_not_allowed )) {
$this -> app -> Tpl -> addMessage ( 'error' , 'Seriennummern bereits ausgeliefert: ' . implode ( ', ' , $seriennummern_old_not_allowed ));
}
if ( ! empty ( $seriennummern_not_written )) {
$this -> app -> Tpl -> addMessage ( 'error' , 'Seriennummern konnten nicht gespeichert werden: ' . implode ( ', ' , $seriennummern_not_written ));
2024-07-26 14:38:14 +02:00
}
2024-08-03 20:11:59 +02:00
$seriennummern = array_merge ( $seriennummern_not_written , $seriennummern_already_exist , $seriennummern_old_not_allowed );
2024-07-26 14:38:14 +02:00
break ;
2024-08-06 15:07:57 +02:00
case 'lieferscheinzuordnen' :
if ( empty ( $lieferschein_id )) {
break ;
2024-07-26 14:38:14 +02:00
}
2024-08-06 15:07:57 +02:00
$auswahl = $this -> app -> Secure -> GetPOST ( 'auswahl' );
if ( ! empty ( $auswahl )) {
if ( count ( $auswahl ) > 1 ) {
$this -> app -> Tpl -> addMessage ( 'error' , 'Bitte eine oder keine Position anklicken' );
break ;
}
$lieferschein_position = $auswahl [ 0 ];
2024-09-27 19:09:43 +02:00
$sql_auswahl = " AND artikel IN (SELECT artikel FROM lieferschein_position WHERE id = ' " . $lieferschein_position . " ') " ;
2024-08-06 15:07:57 +02:00
}
$seriennummern_not_written = array ();
$seriennummern_dont_exist = array ();
$seriennummern_ambigious = array ();
2024-09-19 21:21:43 +02:00
foreach ( $seriennummern as $seriennummer ) {
$seriennummer = trim ( $seriennummer );
2024-08-06 15:07:57 +02:00
if ( empty ( $seriennummer )) {
continue ;
}
$sql = " SELECT id, artikel FROM seriennummern WHERE eingelagert = 1 AND seriennummer = ' " . $this -> app -> DB -> real_escape_string ( $seriennummer ) . " ' " . $sql_auswahl ;
2024-09-19 21:21:43 +02:00
$check_existing = $this -> app -> DB -> SelectArr ( $sql );
2024-08-06 15:07:57 +02:00
if ( empty ( $check_existing )) {
$seriennummern_dont_exist [] = $seriennummer ;
} else if ( count ( $check_existing ) > 1 ) {
$seriennummern_ambigious [] = $seriennummer ;
} else {
$check_lieferschein = $this -> seriennummern_check_delivery_notes ( $lieferschein_id , ignore_date : true );
$written = false ;
foreach ( $check_lieferschein as $position ) {
$menge_offen = $position [ 'menge_lieferschein' ] - $position [ 'menge_nummern' ];
if ( $menge_offen > 0 ) {
if ( empty ( $lieferschein_position )) {
$lieferschein_position = $position [ 'lieferschein_position' ];
}
if ( $lieferschein_position == $position [ 'lieferschein_position' ]) {
2024-09-27 18:23:38 +02:00
$sql = " INSERT INTO seriennummern_beleg_position (beleg_typ, beleg_position, seriennummer) VALUES ('lieferschein',' " . $lieferschein_position . " ',' " . $check_existing [ 0 ][ 'id' ] . " ') " ;
2024-08-06 15:07:57 +02:00
$this -> app -> DB -> Insert ( $sql );
2024-08-21 12:45:19 +02:00
$sql = " UPDATE seriennummern SET eingelagert = 0, logdatei = CURRENT_TIMESTAMP WHERE id = ' " . $check_existing [ 0 ][ 'id' ] . " ' " ;
$this -> app -> DB -> Update ( $sql );
2024-08-06 15:07:57 +02:00
$written = true ;
}
}
}
if ( ! $written ) {
$seriennummern_not_written [] = $seriennummer ;
}
}
}
if ( ! empty ( $seriennummern_dont_exist )) {
2024-08-21 12:45:19 +02:00
$this -> app -> Tpl -> addMessage ( 'error' , 'Seriennummern nicht verfügbar: ' . implode ( ', ' , $seriennummern_dont_exist ));
2024-08-06 15:07:57 +02:00
}
if ( ! empty ( $seriennummern_ambigious )) {
$this -> app -> Tpl -> addMessage ( 'error' , 'Seriennummern nicht eindeutig: ' . implode ( ', ' , $seriennummern_ambigious ));
}
$seriennummern = array_merge ( $seriennummern_not_written , $seriennummern_ambigious , $seriennummern_dont_exist );
2024-09-19 21:21:43 +02:00
break ;
case 'wareneingangzuordnen' :
if ( empty ( $wareneingang_id )) {
break ;
}
$auswahl = $this -> app -> Secure -> GetPOST ( 'auswahl' );
$auswahl_ok = true ;
if ( ! empty ( $auswahl )) {
if ( count ( $auswahl ) > 1 ) {
$auswahl_ok = false ;
}
} else {
$auswahl_ok = false ;
}
if ( ! $auswahl_ok ) {
$this -> app -> Tpl -> addMessage ( 'error' , 'Bitte genau eine Position anklicken' );
break ;
}
$wareneingang_position = $auswahl [ 0 ];
$artikel_id = $this -> app -> DB -> Select ( " SELECT artikel FROM paketdistribution pd WHERE pd.id =' " . $wareneingang_position . " ' LIMIT 1 " );
$seriennummern_not_written = array ();
$seriennummern_already_exist = array ();
$seriennummern_old_not_allowed = array ();
foreach ( $seriennummern as $seriennummer ) {
$seriennummer = trim ( $seriennummer );
if ( empty ( $seriennummer )) {
continue ;
}
$sql = " SELECT id, eingelagert FROM seriennummern WHERE seriennummer = ' " . $this -> app -> DB -> real_escape_string ( $seriennummer ) . " ' AND artikel = ' " . $artikel_id . " ' " ;
$check_existing = $this -> app -> DB -> SelectRow ( $sql );
if ( empty ( $check_existing )) { // New serial
$sql = " INSERT INTO seriennummern (seriennummer, artikel, logdatei, eingelagert) VALUES (' " . $this -> app -> DB -> real_escape_string ( $seriennummer ) . " ', ' " . $artikel_id . " ', CURRENT_TIMESTAMP, 1) " ;
try {
$this -> app -> DB -> Insert ( $sql );
$seriennummer_id = $this -> app -> DB -> GetInsertId ();
2024-09-28 12:30:41 +02:00
$sql = " INSERT INTO seriennummern_beleg_position (beleg_typ, seriennummer, beleg_position) VALUES ('wareneingang',' " . $seriennummer_id . " ', ' " . $wareneingang_position . " ') " ;
2024-09-19 21:21:43 +02:00
$this -> app -> DB -> Insert ( $sql );
} catch ( mysqli_sql_exception $e ) {
$error = true ;
$seriennummern_not_written [] = $seriennummer ;
}
} else {
if ( $check_existing [ 'eingelagert' ]) { // Old serial, already here
$seriennummern_already_exist [] = $seriennummer ;
} else { // Old serial, returning
if ( $allowold ) {
$seriennummer_id = $this -> app -> DB -> Select ( " SELECT id FROM seriennummern WHERE seriennummer = ' " . $this -> app -> DB -> real_escape_string ( $seriennummer ) . " ' AND artikel = ' " . $artikel_id . " ' " );
$sql = " UPDATE seriennummern SET eingelagert = 1, logdatei = CURRENT_TIMESTAMP WHERE id = ' " . $seriennummer_id . " ' " ;
$this -> app -> DB -> Update ( $sql );
2024-09-28 12:30:41 +02:00
$sql = " INSERT INTO seriennummern_beleg_position (beleg_typ, seriennummer, beleg_position) VALUES ('wareneingang',' " . $seriennummer_id . " ', ' " . $wareneingang_position . " ') " ;
2024-09-19 21:21:43 +02:00
$this -> app -> DB -> Insert ( $sql );
} else {
$seriennummern_old_not_allowed [] = $seriennummer ;
}
}
}
}
if ( ! empty ( $seriennummern_already_exist )) {
$this -> app -> Tpl -> addMessage ( 'error' , 'Seriennummern existieren bereits: ' . implode ( ', ' , $seriennummern_already_exist ));
}
if ( ! empty ( $seriennummern_old_not_allowed )) {
$this -> app -> Tpl -> addMessage ( 'error' , 'Seriennummern bereits ausgeliefert: ' . implode ( ', ' , $seriennummern_old_not_allowed ));
}
if ( ! empty ( $seriennummern_not_written )) {
$this -> app -> Tpl -> addMessage ( 'error' , 'Seriennummern konnten nicht gespeichert werden: ' . implode ( ', ' , $seriennummern_not_written ));
}
$seriennummern = array_merge ( $seriennummern_not_written , $seriennummern_already_exist , $seriennummern_old_not_allowed );
2024-08-06 15:07:57 +02:00
2024-07-26 14:38:14 +02:00
break ;
2024-08-04 22:05:35 +02:00
}
2024-07-26 14:38:14 +02:00
$seriennummern = array_unique ( $seriennummern );
2024-08-06 15:07:57 +02:00
$complete = false ;
2024-08-04 22:05:35 +02:00
switch ( $task ) {
case 'artikel' :
2024-08-06 15:07:57 +02:00
$this -> app -> Tpl -> Set ( 'LIEFERSCHEIN_HIDDEN' , " hidden= \" true \" " );
2024-09-19 21:21:43 +02:00
$this -> app -> Tpl -> Set ( 'WARENEINGANG_HIDDEN' , " hidden= \" true \" " );
$this -> app -> Tpl -> Set ( 'BELEG_HIDDEN' , " hidden= \" true \" " );
2024-08-04 22:05:35 +02:00
$check_seriennummern = $this -> seriennummern_check_serials ( $artikel_id );
$check_seriennummern = $check_seriennummern [ 0 ];
$anzahl_fehlt = $check_seriennummern [ 'menge_auf_lager' ] - $check_seriennummern [ 'menge_nummern' ];
if ( $anzahl_fehlt == 0 ) {
$this -> app -> Tpl -> addMessage ( 'success' , 'Seriennummern vollständig.' );
}
2024-07-26 14:38:14 +02:00
2024-08-04 22:05:35 +02:00
if ( $anzahl_fehlt < 0 ) {
$anzahl_fehlt = 0 ;
}
$letzte_seriennummer = ( string ) $this -> app -> DB -> Select ( " SELECT seriennummer FROM seriennummern WHERE artikel = ' " . $artikel_id . " ' ORDER BY id DESC LIMIT 1 " );
$regex_result = array ( preg_match ( '/(.*?)(\d+)(?!.*\d)(.*)/' , $letzte_seriennummer , $matches ));
$this -> app -> Tpl -> Set ( 'LETZTE' , $letzte_seriennummer );
$this -> app -> Tpl -> Set ( 'PRAEFIX' , $matches [ 1 ]);
$this -> app -> Tpl -> Set ( 'START' , $matches [ 2 ] + 1 );
$this -> app -> Tpl -> Set ( 'POSTFIX' , $matches [ 3 ]);
$this -> app -> Tpl -> Set ( 'ANZAHL' , $anzahl_fehlt );
2024-07-26 14:38:14 +02:00
2024-08-04 22:05:35 +02:00
$this -> app -> Tpl -> Set ( 'ARTIKELNUMMER' , '<a href="index.php?module=artikel&action=edit&id=' . $check_seriennummern [ 'id' ] . '">' . $check_seriennummern [ 'nummer' ] . '</a>' );
2024-07-26 14:38:14 +02:00
2024-08-04 22:05:35 +02:00
$this -> app -> Tpl -> Set ( 'ARTIKEL' , $check_seriennummern [ 'name' ]);
$this -> app -> Tpl -> Set ( 'ANZLAGER' , $check_seriennummern [ 'menge_auf_lager' ]);
$this -> app -> Tpl -> Set ( 'ANZVORHANDEN' , $check_seriennummern [ 'menge_nummern' ]);
$this -> app -> Tpl -> Set ( 'ANZFEHLT' , $anzahl_fehlt );
2024-08-06 15:07:57 +02:00
$this -> app -> Tpl -> Set ( 'SERIENNUMMERN' , implode ( " \n " , $seriennummern ));
$artikel_id = $this -> app -> Secure -> GetGET ( 'artikel' );
$this -> app -> User -> SetParameter ( 'seriennummern_artikel_id' , $artikel_id );
$this -> app -> YUI -> TableSearch ( 'POSITIONEN' , 'seriennummern_list' , " show " , " " , " " , basename ( __FILE__ ), __CLASS__ );
2024-08-04 22:05:35 +02:00
break ;
case 'lieferschein' :
2024-08-15 18:12:58 +02:00
switch ( $from ) {
case 'lieferschein' :
$this -> app -> erp -> MenuEintrag ( " index.php?module=lieferschein&action=edit&id= " . $lieferschein_id , " Zurück " );
break ;
case 'seriennummern' :
$this -> app -> erp -> MenuEintrag ( " index.php?module=seriennummern&action=lieferscheine_list " , " Zurück " );
break ;
}
2024-08-04 22:05:35 +02:00
$this -> app -> Tpl -> Set ( 'ARTIKEL_HIDDEN' , " hidden " );
2024-09-19 21:21:43 +02:00
$this -> app -> Tpl -> Set ( 'WARENEINGANG_HIDDEN' , " hidden= \" true \" " );
2024-08-04 22:05:35 +02:00
2024-08-06 15:07:57 +02:00
$check_lieferschein = $this -> seriennummern_check_delivery_notes ( $lieferschein_id , ignore_date : true );
if ( empty ( $check_lieferschein )) {
$this -> app -> Tpl -> AddMessage ( 'success' , 'Seriennummern vollständig.' );
2024-09-19 21:21:43 +02:00
$this -> app -> Tpl -> Set ( 'EINGABE_HIDDEN' , 'hidden' );
} else {
2024-09-28 12:30:41 +02:00
$check_lieferschein_alle = $this -> seriennummern_check_delivery_notes ( $lieferschein_id , ignore_date : true , only_missing : false );
$menge_lieferschein = array_sum ( array_column ( $check_lieferschein_alle , 'menge_lieferschein' ));
$menge_nummern = array_sum ( array_column ( $check_lieferschein_alle , 'menge_nummern' ));
2024-09-19 21:21:43 +02:00
$anzahl_fehlt = $menge_lieferschein - $menge_nummern ;
if ( $anzahl_fehlt < 0 ) {
$anzahl_fehlt = 0 ;
}
$this -> app -> Tpl -> Set ( 'ANZBELEG' , $menge_lieferschein );
$this -> app -> Tpl -> Set ( 'ANZVORHANDEN' , $menge_nummern );
$this -> app -> Tpl -> Set ( 'ANZFEHLT' , $anzahl_fehlt );
$artikel_lieferschein = $this -> app -> DB -> SelectArr ( " SELECT artikel FROM lieferschein_position WHERE lieferschein = ' " . $lieferschein_id . " ' " );
$sql = "
SELECT
DISTINCT s . seriennummer
FROM
seriennummern s
WHERE
s . artikel = " . $check_lieferschein[0] ['artikel']. "
AND s . eingelagert = 1
ORDER BY s . id ASC
LIMIT 1
" ;
$letzte_seriennummer = ( string ) $this -> app -> DB -> Select ( $sql );
$regex_result = array ( preg_match ( '/(.*?)(\d+)(?!.*\d)(.*)/' , $letzte_seriennummer , $matches ));
$this -> app -> Tpl -> Set ( 'LETZTE' , $letzte_seriennummer );
$this -> app -> Tpl -> Set ( 'PRAEFIX' , $matches [ 1 ]);
$this -> app -> Tpl -> Set ( 'START' , $matches [ 2 ]);
$this -> app -> Tpl -> Set ( 'POSTFIX' , $matches [ 3 ]);
2024-09-28 12:30:41 +02:00
$anzahl_vorschlag = $check_lieferschein [ 0 ][ 'menge_lieferschein' ] - $check_lieferschein [ 0 ][ 'menge_nummern' ];
if ( $anzahl_vorschlag < 0 ) {
$anzahl_vorschlag = 0 ;
2024-09-19 21:21:43 +02:00
}
2024-09-28 12:30:41 +02:00
$this -> app -> Tpl -> Set ( 'ANZAHL' , $anzahl_vorschlag );
2024-09-19 21:21:43 +02:00
}
2024-09-28 12:30:41 +02:00
2024-09-19 21:21:43 +02:00
$this -> app -> YUI -> TableSearch ( 'POSITIONEN' , 'seriennummern_lieferschein_positionen' , " show " , " " , " " , basename ( __FILE__ ), __CLASS__ );
$this -> app -> YUI -> AutoComplete ( " eingabe " , " seriennummerverfuegbar " , 0 , " &lieferschein= $lieferschein_id " );
$this -> app -> Tpl -> Set ( 'SERIENNUMMERN' , implode ( " \n " , $seriennummern ));
break ;
case 'wareneingang' :
switch ( $from ) {
case 'wareneingang' :
$this -> app -> erp -> MenuEintrag ( " index.php?module=wareneingang&action=distriinhalt&id= " . $wareneingang_id , " Zurück " );
break ;
case 'seriennummern' :
$this -> app -> erp -> MenuEintrag ( " index.php?module=seriennummern&action=wareneingaenge_list " , " Zurück " );
break ;
}
$this -> app -> Tpl -> Set ( 'LIEFERSCHEIN_HIDDEN' , " hidden " );
$this -> app -> Tpl -> Set ( 'ARTIKEL_HIDDEN' , " hidden " );
$check_wareneingang = $this -> seriennummern_check_incoming_goods ( $wareneingang_id );
if ( empty ( $check_wareneingang )) {
$this -> app -> Tpl -> AddMessage ( 'success' , 'Seriennummern vollständig.' );
2024-08-06 15:07:57 +02:00
$this -> app -> Tpl -> Set ( 'EINGABE_HIDDEN' , 'hidden' );
2024-09-28 12:30:41 +02:00
} else {
$check_wareneingang_alle = $this -> seriennummern_check_incoming_goods ( $wareneingang_id , only_missing : false );
2024-08-06 15:07:57 +02:00
2024-09-28 12:30:41 +02:00
$menge_wareneingang = array_sum ( array_column ( $check_wareneingang_alle , 'menge_wareneingang' ));
$menge_nummern = array_sum ( array_column ( $check_wareneingang_alle , 'menge_nummern' ));
$anzahl_fehlt = $menge_wareneingang - $menge_nummern ;
2024-08-06 15:07:57 +02:00
2024-09-28 12:30:41 +02:00
if ( $anzahl_fehlt < 0 ) {
$anzahl_fehlt = 0 ;
}
2024-08-06 15:07:57 +02:00
2024-09-28 12:30:41 +02:00
$this -> app -> Tpl -> Set ( 'ANZBELEG' , $menge_wareneingang );
$this -> app -> Tpl -> Set ( 'ANZVORHANDEN' , $menge_nummern );
$this -> app -> Tpl -> Set ( 'ANZFEHLT' , $anzahl_fehlt );
2024-08-06 15:07:57 +02:00
2024-09-28 12:30:41 +02:00
$artikel_wareneingang = $this -> app -> DB -> SelectArr ( " SELECT artikel FROM paketdistribution WHERE paketannahme = ' " . $wareneingang_id . " ' " );
2024-07-26 14:38:14 +02:00
2024-09-28 12:30:41 +02:00
$sql = "
SELECT
DISTINCT s . seriennummer
FROM
seriennummern s
WHERE
s . artikel = " . $check_wareneingang[0] ['artikel']. "
ORDER BY s . id DESC
LIMIT 1
" ;
2024-07-26 14:38:14 +02:00
2024-09-28 12:30:41 +02:00
$letzte_seriennummer = ( string ) $this -> app -> DB -> Select ( $sql );
$regex_result = array ( preg_match ( '/(.*?)(\d+)(?!.*\d)(.*)/' , $letzte_seriennummer , $matches ));
$this -> app -> Tpl -> Set ( 'LETZTE' , $letzte_seriennummer );
$this -> app -> Tpl -> Set ( 'PRAEFIX' , $matches [ 1 ]);
$this -> app -> Tpl -> Set ( 'START' , $matches [ 2 ] + 1 );
$this -> app -> Tpl -> Set ( 'POSTFIX' , $matches [ 3 ]);
2024-08-04 22:05:35 +02:00
2024-09-28 12:30:41 +02:00
$anzahl_vorschlag = $check_wareneingang [ 0 ][ 'menge_wareneingang' ] - $check_wareneingang [ 0 ][ 'menge_nummern' ];
if ( $anzahl_vorschlag < 0 ) {
$anzahl_vorschlag = 0 ;
}
$this -> app -> Tpl -> Set ( 'ANZAHL' , $anzahl_vorschlag );
2024-08-06 15:07:57 +02:00
}
2024-09-19 21:21:43 +02:00
$this -> app -> YUI -> TableSearch ( 'POSITIONEN' , 'seriennummern_wareneingang_positionen' , " show " , " " , " " , basename ( __FILE__ ), __CLASS__ );
2024-09-28 12:30:41 +02:00
$this -> app -> YUI -> AutoComplete ( " eingabe " , " seriennummerverfuegbar " );
2024-08-04 22:05:35 +02:00
2024-09-19 21:21:43 +02:00
$this -> app -> Tpl -> Set ( 'SERIENNUMMERN' , implode ( " \n " , $seriennummern ));
2024-08-04 22:05:35 +02:00
break ;
default :
exit ();
break ;
}
2024-07-26 14:38:14 +02:00
$this -> app -> Tpl -> Parse ( 'PAGE' , " seriennummern_enter.tpl " );
}
2024-09-18 20:12:54 +02:00
/* --------------------------------------------
CHECKS
-------------------------------------------- */
2024-07-26 14:38:14 +02:00
/*
* Check if all serial numbers are given
* Return array of article ids
*/
public function seriennummern_check_serials ( $artikel_id = null ) : array {
$sql = "
SELECT
auf_lager . id ,
nummer ,
name ,
2024-07-27 11:41:05 +02:00
" . $this->app ->erp->FormatMenge('auf_lager.anzahl'). " menge_auf_lager ,
2024-07-26 14:38:14 +02:00
COALESCE ( nummern_verfuegbar . anzahl , 0 ) menge_nummern
FROM
(
SELECT
a . id ,
a . nummer ,
a . name_de name ,
SUM ( lpi . menge ) anzahl
FROM
artikel a
INNER JOIN lager_platz_inhalt lpi ON
a . id = lpi . artikel
WHERE
a . seriennummern <> 'keine' AND a . seriennummern <> '' AND ( a . id = '".$artikel_id."' OR '".$artikel_id."' = '' )
GROUP BY
a . id
) auf_lager
LEFT JOIN (
SELECT
artikel ,
2024-08-03 20:11:59 +02:00
SUM ( if ( eingelagert , 1 , 0 )) anzahl
2024-07-26 14:38:14 +02:00
FROM
seriennummern
GROUP BY
artikel
) nummern_verfuegbar
ON
auf_lager . id = nummern_verfuegbar . artikel
GROUP BY
auf_lager . id
" ;
$result = $this -> app -> DB -> SelectArr ( $sql );
return ( empty ( $result ) ? array () : $result );
}
2024-08-03 13:27:45 +02:00
2024-09-17 09:50:47 +02:00
/*
* Check if all incoming goods notes have serials
* Return array of incoming goods note positions and head information
*/
2024-09-18 20:12:54 +02:00
public function seriennummern_check_incoming_goods ( $wareneingang_id = null , $only_missing = true , $group_wareneingang = false ) : array {
2024-09-17 09:50:47 +02:00
if ( $group_wareneingang ) {
$sql_we = " '' " ;
$sql_we_group = " " ;
} else {
2024-09-28 12:30:41 +02:00
$sql_we = " pd.id " ;
$sql_we_group = " , pd.id " ;
2024-09-17 09:50:47 +02:00
}
$sql = "
SELECT SQL_CALC_FOUND_ROWS
pa . id wareneingang ,
pa . id belegnr ,
$sql_we wareneingang_position ,
a . id artikel ,
a . nummer artikel_nummer ,
a . name_de ,
" . $this->app ->erp->FormatMenge('SUM(menge)'). " menge_wareneingang ,
SUM ( COALESCE ( menge_nummern , 0 )) menge_nummern
FROM
paketdistribution pd
INNER JOIN paketannahme pa ON
pa . id = pd . paketannahme
INNER JOIN artikel a ON
a . id = pd . artikel
LEFT JOIN (
SELECT
2024-09-27 18:23:38 +02:00
beleg_position ,
2024-09-17 09:50:47 +02:00
COUNT ( * ) menge_nummern
FROM
2024-09-27 18:23:38 +02:00
seriennummern_beleg_position spd
WHERE
spd . beleg_typ = 'wareneingang'
2024-09-17 09:50:47 +02:00
GROUP BY
2024-09-27 18:23:38 +02:00
spd . beleg_position
) spd ON spd . beleg_position = pd . id
2024-09-17 09:50:47 +02:00
WHERE
( a . seriennummern <> 'keine' )
2024-09-18 20:12:54 +02:00
AND pa . status <> 'abgeschlossen'
2024-09-17 09:50:47 +02:00
AND ( pa . id = '".$wareneingang_id."' OR '".$wareneingang_id."' = '' )
GROUP BY
pa . id
$sql_we_group
" ;
if ( $only_missing ) {
$sql .= " HAVING menge_wareneingang <> menge_nummern " ;
}
$result = $this -> app -> DB -> SelectArr ( $sql );
return ( empty ( $result ) ? array () : $result );
}
2024-08-03 13:27:45 +02:00
/*
* Check if all delivery notes have serials
* Return array of delivery note positions and head information
2024-07-26 14:38:14 +02:00
*/
2024-08-07 12:11:32 +02:00
public function seriennummern_check_delivery_notes ( $lieferschein_id = null , $ignore_date = false , $only_missing = true , $group_lieferschein = false ) : array {
if ( $group_lieferschein ) {
$sql_lp = " '' " ;
$sql_lp_group = " " ;
} else {
$sql_lp = " lp.id " ;
$sql_lp_group = " , lp.id " ;
}
2024-08-03 13:27:45 +02:00
$sql = "
2024-08-03 20:11:59 +02:00
SELECT SQL_CALC_FOUND_ROWS
2024-08-06 15:07:57 +02:00
l . id lieferschein ,
l . belegnr belegnr ,
2024-08-07 12:11:32 +02:00
$sql_lp lieferschein_position ,
2024-08-06 15:07:57 +02:00
a . id artikel ,
a . nummer artikel_nummer ,
a . name_de ,
" . $this->app ->erp->FormatMenge('SUM(menge)'). " menge_lieferschein ,
SUM ( COALESCE ( menge_nummern , 0 )) menge_nummern
2024-08-03 20:11:59 +02:00
FROM
2024-08-06 15:07:57 +02:00
lieferschein_position lp
2024-08-03 20:11:59 +02:00
INNER JOIN lieferschein l ON
l . id = lp . lieferschein
INNER JOIN artikel a ON
a . id = lp . artikel
2024-08-06 15:07:57 +02:00
LEFT JOIN (
SELECT
2024-09-27 18:23:38 +02:00
beleg_position ,
2024-08-06 15:07:57 +02:00
COUNT ( * ) menge_nummern
FROM
2024-09-27 18:23:38 +02:00
seriennummern_beleg_position slp
WHERE slp . beleg_typ = 'lieferschein'
2024-08-06 15:07:57 +02:00
GROUP BY
2024-09-27 18:23:38 +02:00
slp . beleg_position
) slp ON slp . beleg_position = lp . id
2024-08-03 20:11:59 +02:00
WHERE
2024-08-06 15:07:57 +02:00
( a . seriennummern <> 'keine' )
AND (
2024-08-03 20:11:59 +02:00
l . datum >= (
2024-08-06 15:07:57 +02:00
SELECT
2024-09-17 09:50:47 +02:00
COALESCE ( DATE ( MIN ( datum )), CURRENT_DATE ())
2024-08-06 15:07:57 +02:00
FROM
seriennummern
WHERE
artikel = a . id
) OR ( '".$ignore_date."' <> '' )
)
AND ( l . id = '".$lieferschein_id."' OR '".$lieferschein_id."' = '' )
2024-08-13 12:12:55 +02:00
AND l . belegnr <> ''
2024-08-03 20:11:59 +02:00
GROUP BY
2024-08-07 12:11:32 +02:00
l . id
$sql_lp_group
2024-08-03 13:27:45 +02:00
" ;
2024-08-06 15:07:57 +02:00
if ( $only_missing ) {
2024-08-07 12:11:32 +02:00
$sql .= " HAVING menge_lieferschein <> menge_nummern " ;
2024-08-06 15:07:57 +02:00
}
2024-08-03 13:27:45 +02:00
$result = $this -> app -> DB -> SelectArr ( $sql );
return ( empty ( $result ) ? array () : $result );
}
2024-09-18 20:12:54 +02:00
/* --------------------------------------------
NOTIFICATIONS
-------------------------------------------- */
2024-08-03 13:27:45 +02:00
protected function seriennummern_create_notification_artikel ( $artikel_id , $action , $title = 'Seriennummern' , $message = 'Meldung' , $button = 'Ok' )
2024-07-26 14:38:14 +02:00
{
// Notification erstellen
2024-07-27 11:41:05 +02:00
$notification_message = new NotificationMessageData ( 'default' , $title );
$artikel = $this -> app -> DB -> SelectRow ( " SELECT name_de, nummer FROM artikel WHERE id = ' " . $artikel_id . " ' LIMIT 1 " );
$notification_message -> setMessage ( $message . ' Artikel (' . $artikel [ 'nummer' ] . ') ' . $artikel [ 'name' ]);
$notification_message -> addTags ([ 'seriennummern' ]);
$notification_message -> setPriority ( true );
2024-07-26 14:38:14 +02:00
$messageButtons = [
[
2024-07-27 11:41:05 +02:00
'text' => $button ,
'link' => sprintf ( 'index.php?module=seriennummern&action=' . $action . '&artikel=%s' , $artikel_id ),
2024-07-26 14:38:14 +02:00
]
];
2024-07-27 11:41:05 +02:00
$notification_message -> setOption ( 'buttons' , $messageButtons );
2024-07-26 14:38:14 +02:00
/** @var NotificationService $notification */
$notification = $this -> app -> Container -> get ( 'NotificationService' );
2024-07-27 11:41:05 +02:00
$notification -> createFromData ( $this -> app -> User -> GetID (), $notification_message );
}
2024-08-03 13:27:45 +02:00
protected function seriennummern_create_notification_lieferschein ( $lieferschein_id , $action , $title = 'Seriennummern' , $message = 'Meldung' , $button = 'Ok' )
{
// Notification erstellen
$notification_message = new NotificationMessageData ( 'default' , $title );
$lieferschein = $this -> app -> DB -> SelectRow ( " SELECT belegnr FROM lieferschein WHERE id = ' " . $lieferschein_id . " ' LIMIT 1 " );
$notification_message -> setMessage ( $message . ' Lieferschein ' . $lieferschein [ 'belegnr' ]);
$notification_message -> addTags ([ 'seriennummern' ]);
$notification_message -> setPriority ( true );
$messageButtons = [
[
'text' => $button ,
'link' => sprintf ( 'index.php?module=seriennummern&action=' . $action . '&lieferschein=%s' , $lieferschein_id ),
]
];
$notification_message -> setOption ( 'buttons' , $messageButtons );
/** @var NotificationService $notification */
$notification = $this -> app -> Container -> get ( 'NotificationService' );
$notification -> createFromData ( $this -> app -> User -> GetID (), $notification_message );
}
2024-09-18 20:12:54 +02:00
/* --------------------------------------------
CHECKS AND NOTIFICATIONS
-------------------------------------------- */
2024-07-27 11:41:05 +02:00
/*
* Check if new numbers need to be entered , if yes , create notification
*/
2024-09-18 20:12:54 +02:00
public function seriennummern_check_and_notification_stock_added ( int $artikel_id ) {
2024-07-27 11:41:05 +02:00
$check_seriennummern = $this -> seriennummern_check_serials ( $artikel_id );
if ( $check_seriennummern [ 0 ][ 'menge_nummern' ] < $check_seriennummern [ 0 ][ 'menge_auf_lager' ]) {
2024-08-03 13:27:45 +02:00
$this -> seriennummern_create_notification_artikel ( $artikel_id , 'enter' , 'Seriennummern' , 'Bitte Seriennummern für Einlagerung erfassen' , 'Zur Eingabe' );
2024-07-27 11:41:05 +02:00
}
2024-09-18 20:12:54 +02:00
}
2024-07-27 11:41:05 +02:00
/*
2024-08-15 18:12:58 +02:00
* Check if numbers need to be entered after stock removal , if yes , create notification or message
2024-07-27 11:41:05 +02:00
*/
2024-09-18 20:12:54 +02:00
public function seriennummern_check_and_notification_delivery_note ( int $lieferschein_id ) {
2024-08-03 20:11:59 +02:00
$check_delivery_notes = $this -> seriennummern_check_delivery_notes ( $lieferschein_id );
if ( ! empty ( $check_delivery_notes )) {
2024-09-18 20:12:54 +02:00
$this -> seriennummern_create_notification_lieferschein ( $lieferschein_id , 'enter' , 'Seriennummern' , 'Bitte Seriennummern für Lieferschein erfassen' , 'Zur Eingabe' );
2024-07-27 11:41:05 +02:00
}
2024-08-21 12:45:19 +02:00
return ( $check_delivery_notes );
2024-07-26 14:38:14 +02:00
}
2024-08-04 22:05:35 +02:00
2024-09-18 20:12:54 +02:00
/* --------------------------------------------
CHECKS AND MESSAGES MODULE HEADER
-------------------------------------------- */
function seriennummern_check_and_message ( $artikel_id ) {
$check_seriennummern = $this -> seriennummern_check_serials ( $artikel_id );
if ( ! empty ( $check_seriennummern )) {
$artikel_minus_id_links = array ();
$artikel_plus_id_links = array ();
foreach ( $check_seriennummern as $artikel_id ) {
if ( $artikel_id [ 'menge_nummern' ] < $artikel_id [ 'menge_auf_lager' ]) {
$artikel_minus_id_links [] = '<a href="index.php?module=seriennummern&action=enter&artikel=' . $artikel_id [ 'id' ] . '">' . $artikel_id [ 'nummer' ] . '</a>' ;
}
else if ( $artikel_id [ 'menge_nummern' ] > $artikel_id [ 'menge_auf_lager' ]) {
$artikel_plus_id_links [] = '<a href="index.php?module=seriennummern&action=nummern_list&artikel=' . $artikel_id [ 'id' ] . '">' . $artikel_id [ 'nummer' ] . '</a>' ;
}
}
if ( ! empty ( $artikel_minus_id_links )) {
$this -> app -> YUI -> Message ( 'warning' , 'Seriennummern fehlen für Artikel: ' . implode ( ', ' , $artikel_minus_id_links ));
}
if ( ! empty ( $artikel_plus_id_links )) {
$this -> app -> YUI -> Message ( 'warning' , 'Seriennummern Überschuss für Artikel: ' . implode ( ', ' , $artikel_plus_id_links ));
}
}
}
function seriennummern_check_and_message_incoming_goods ( $wareneingang_id ) {
$check_incoming_goods = $this -> seriennummern_check_incoming_goods ( $wareneingang_id , group_wareneingang : true );
if ( ! empty ( $check_incoming_goods )) {
if ( empty ( $wareneingang_id )) {
$wareneingang_minus_links = array ();
$wareneingang_plus_links = array ();
foreach ( $check_incoming_goods as $check_delivery_note ) {
if ( $check_delivery_note [ 'anzahl_nummern' ] < $check_delivery_note [ 'menge_wareneingang' ]) {
$wareneingang_minus_links [] = '<a href="index.php?module=seriennummern&action=enter&wareneingang=' . $check_delivery_note [ 'wareneingang' ] . '">' . $check_delivery_note [ 'belegnr' ] . '</a>' ;
}
else if ( $check_delivery_note [ 'anzahl_nummern' ] > $check_delivery_note [ 'menge' ]) {
$wareneingang_plus_links [] = '<a href="index.php?module=seriennummern&action=nummern_list&wareneingang=' . $check_delivery_note [ 'wareneingang' ] . '">' . $check_delivery_note [ 'belegnr' ] . '</a>' ;
}
}
if ( ! empty ( $wareneingang_minus_links )) {
$this -> app -> YUI -> Message ( 'warning' , 'Seriennummern fehlen für Wareneingang: ' . implode ( ', ' , $wareneingang_minus_links ));
}
if ( ! empty ( $wareneingang_plus_links )) {
$this -> app -> YUI -> Message ( 'warning' , 'Seriennummern Überschuss für Wareneingang: ' . implode ( ', ' , $wareneingang_plus_links ));
}
}
else {
$this -> app -> Tpl -> Add ( 'MESSAGE' , " <div class= \" warning \" >Seriennummern unvollständig!<input type= \" button \" value= \" Jetzt erfassen \" onclick= \" window.location.href='index.php?module=seriennummern&action=enter&from=wareneingang&wareneingang= $wareneingang_id ' \" ></div> " );
}
}
return ( $check_incoming_goods );
}
function seriennummern_check_and_message_delivery_notes ( $lieferschein_id ) {
$check_delivery_notes = $this -> seriennummern_check_delivery_notes ( $lieferschein_id , group_lieferschein : true );
if ( ! empty ( $check_delivery_notes )) {
if ( empty ( $lieferschein_id )) {
$lieferschein_minus_links = array ();
$lieferschein_plus_links = array ();
foreach ( $check_delivery_notes as $check_delivery_note ) {
if ( $check_delivery_note [ 'anzahl_nummern' ] < $check_delivery_note [ 'menge_lieferschein' ]) {
$lieferschein_minus_links [] = '<a href="index.php?module=seriennummern&action=enter&lieferschein=' . $check_delivery_note [ 'lieferschein' ] . '">' . $check_delivery_note [ 'belegnr' ] . '</a>' ;
}
else if ( $check_delivery_note [ 'anzahl_nummern' ] > $check_delivery_note [ 'menge' ]) {
$lieferschein_plus_links [] = '<a href="index.php?module=seriennummern&action=nummern_list&lieferschein=' . $check_delivery_note [ 'lieferschein' ] . '">' . $check_delivery_note [ 'belegnr' ] . '</a>' ;
}
}
if ( ! empty ( $lieferschein_minus_links )) {
$this -> app -> YUI -> Message ( 'warning' , 'Seriennummern fehlen für Lieferschein: ' . implode ( ', ' , $lieferschein_minus_links ));
}
if ( ! empty ( $lieferschein_plus_links )) {
$this -> app -> YUI -> Message ( 'warning' , 'Seriennummern Überschuss für Lieferschein: ' . implode ( ', ' , $lieferschein_plus_links ));
}
} else {
$this -> app -> Tpl -> Add ( 'MESSAGE' , " <div class= \" warning \" >Seriennummern unvollständig!<input type= \" button \" value= \" Jetzt erfassen \" onclick= \" window.location.href='index.php?module=seriennummern&action=enter&from=lieferschein&lieferschein= $lieferschein_id ' \" ></div> " );
}
}
return ( $check_delivery_notes );
}
/*
MINIDETAILS
*/
public function seriennummern_minidetail ( $parsetarget = '' , $menu = true ) {
2024-08-04 22:05:35 +02:00
$id = $this -> app -> Secure -> GetGET ( 'id' );
if ( $parsetarget == '' )
{
$tmp = new EasyTable ( $this -> app );
2024-09-27 18:23:38 +02:00
$tmp -> Query ( " SELECT
CONCAT (
UCASE ( LEFT ( sbp . beleg_typ , 1 )),
SUBSTRING ( sbp . beleg_typ , 2 )
) AS Belegtyp ,
COALESCE ( l . belegnr , w . id ) AS Beleg ,
2024-09-28 12:30:41 +02:00
" . $this->app ->erp->FormatDate('COALESCE(l.datum,w.datum)'). " AS Datum ,
2024-09-27 18:23:38 +02:00
COALESCE ( al . name , aw . name ) AS Adresse
FROM seriennummern_beleg_position sbp
LEFT JOIN lieferschein_position lp ON sbp . beleg_typ = 'lieferschein' AND lp . id = sbp . beleg_position
LEFT JOIN lieferschein l ON l . id = lp . lieferschein
LEFT JOIN adresse al ON al . id = l . adresse
LEFT JOIN paketdistribution pd ON sbp . beleg_typ = 'wareneingang' AND pd . id = sbp . beleg_position
LEFT JOIN paketannahme w ON w . id = pd . paketannahme
LEFT JOIN adresse aw ON aw . id = w . adresse
2024-09-28 12:30:41 +02:00
WHERE sbp . seriennummer = '$id'
ORDER BY COALESCE ( l . datum , w . datum ) DESC "
2024-09-27 18:23:38 +02:00
, 0 , " " );
2024-09-18 20:12:54 +02:00
$tmp -> DisplayNew ( 'TAB1' , " Adresse " , " noAction " );
2024-08-04 22:05:35 +02:00
$this -> app -> Tpl -> Output ( 'emptytab.tpl' );
$this -> app -> ExitXentral ();
}
2024-09-18 20:12:54 +02:00
}
public function seriennummern_lieferscheinpos_minidetail ( $parsetarget = '' , $menu = true ) {
2024-08-21 12:45:19 +02:00
$id = $this -> app -> Secure -> GetGET ( 'id' );
if ( $parsetarget == '' )
{
$tmp = new EasyTable ( $this -> app );
2024-09-27 18:23:38 +02:00
$tmp -> Query ( " SELECT s.seriennummer FROM seriennummern s INNER JOIN seriennummern_beleg_position slp ON slp.beleg_typ = 'lieferschein' AND slp.seriennummer = s.id WHERE slp.beleg_position =' $id ' " , 0 , " " );
2024-09-18 20:12:54 +02:00
$tmp -> DisplayNew ( 'TAB1' , " Seriennummern " , " noAction " );
2024-08-21 12:45:19 +02:00
$this -> app -> Tpl -> Output ( 'emptytab.tpl' );
$this -> app -> ExitXentral ();
}
2024-09-18 20:12:54 +02:00
}
2024-09-19 21:21:43 +02:00
public function seriennummern_wareneingang_minidetail ( $parsetarget = '' , $menu = true ) {
$id = $this -> app -> Secure -> GetGET ( 'id' );
if ( $parsetarget == '' )
{
$tmp = new EasyTable ( $this -> app );
2024-09-27 18:23:38 +02:00
$tmp -> Query ( " SELECT s.seriennummer FROM seriennummern s INNER JOIN seriennummern_beleg_position spd ON spd.beleg_typ = 'wareneingang' AND spd.seriennummer = s.id WHERE spd.beleg_position =' $id ' " , 0 , " " );
2024-09-19 21:21:43 +02:00
$tmp -> DisplayNew ( 'TAB1' , " Seriennummern " , " noAction " );
$this -> app -> Tpl -> Output ( 'emptytab.tpl' );
$this -> app -> ExitXentral ();
}
}
2024-09-18 20:12:54 +02:00
2024-08-04 22:05:35 +02:00
}
