= ? And dw_spec.specID = ? And dw_spec.specSite = ? Group By dw_cypher.cypherID, dw_user.userFirst, dw_user.userLast Order By dw_cypher.cypherManuDate Desc, dw_spec.specOrder "; if(!$cypher_query = mysqli_prepared_query($link, $sql, "sii", array($startDate, $_GET['p'], $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); }else{ $sql=" Select dw_cypher.cypherID, dw_cypher.cypherText, dw_cypher.cypherOrderID, dw_spec.specText, dw_cypher.cypherFirstUnit, dw_cypher.cypherLastUnit, dw_cypher.cypherPartPallet, dw_cypher.cypherKGsmade, dw_spec.specKGperPallet, dw_spec.specBagSize, dw_spec.specID, dw_cypher.cypherManuDate, dw_spec.specBagSize, dw_user.userID From dw_spec Right Join dw_cypher On dw_spec.specID = dw_cypher.cypherSpec Left Join dw_user On dw_cypher.cypherModUser = dw_user.userID Where ucase(substr(dw_spec.specText, 1, 3)) != 'AMF' And dw_cypher.cypherActive = 1 And dw_spec.specStyle = 1 And dw_spec.specActive = 1 And dw_cypher.cypherManuDate >= ? And dw_spec.specSite = ? Group By dw_cypher.cypherID, dw_user.userFirst, dw_user.userLast Order By dw_cypher.cypherManuDate Desc, dw_spec.specOrder "; if(!$cypher_query = mysqli_prepared_query($link, $sql, "si", array($startDate, $_SESSION['userSite']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); } require "inc/get_units.php"; foreach($cypher_query as $cypher_row){ $unitinfo = get_units($cypher_row['cypherID']); //this is used to get data for table $sql=" # get damages Select Sum(dw_damages.damageBags) As SumOfDamageBags From dw_damages Where dw_damages.damageDate = ? And dw_damages.damageSite = ? And dw_damages.damageSpec = ? "; if(!$damage_query = mysqli_prepared_query($link, $sql, "sii", array($cypher_row['cypherManuDate'], $_SESSION['userSite'], $cypher_row['specID']), __FILE__, __LINE__)) reporterror(get_error(), $sql, $_SERVER['REQUEST_URI'], __FILE__, __LINE__); $damage_row = $damage_query[0]; if($damage_row['SumOfDamageBags']=="" || $damage_row['SumOfDamageBags']==null) $damage_row['SumOfDamageBags']=0; if($cypher_row['specBagSize']==0) $fiftysix = $cypher_row['specKGperPallet']; else $fiftysix = $cypher_row['specKGperPallet']/$cypher_row['specBagSize']; $meanweight = $cypher_row['specBagSize']; if($cypher_row['cypherFirstUnit']!="" && $cypher_row['cypherFirstUnit']!=null) $firstunit = $cypher_row['cypherFirstUnit']; else $firstunit = $unitinfo[0]; if($firstunit=="") $firstunit="-"; //need something here so people can click on it if($cypher_row['cypherLastUnit']!="" && $cypher_row['cypherLastUnit']!=null) $lastunit = $cypher_row['cypherLastUnit']; else $lastunit = $unitinfo[1]; if($lastunit=="") $lastunit="-"; //need something here so people can click on it //$units = number_format($unitinfo[2]); if(!function_exists('addletter')) require "inc/addletter.php"; $firstunitforcalc=(int)addletter(substr($firstunit,0,1), substr($firstunit,1)); //add a number at the start instead of a letter $lastunitforcalc =(int)addletter(substr($lastunit ,0,1), substr($lastunit ,1)); $units = number_format($lastunitforcalc-$firstunitforcalc,0,"",""); if($firstunit!='-' && $units<1) $units = 1; if($cypher_row['cypherPartPallet']>0 && $damage_row['SumOfDamageBags']<1){ $bagsmade = ((($units-1)*$fiftysix)+$cypher_row['cypherPartPallet']); $bagtooltip = "(((".$units."-1)*".$fiftysix.")+".$cypher_row['cypherPartPallet'].")"; }else if($cypher_row['cypherPartPallet']>0 && $damage_row['SumOfDamageBags']>0){ $bagsmade = (((($units-1)*$fiftysix)+$cypher_row['cypherPartPallet'])-$damage_row['SumOfDamageBags']); $bagtooltip = "((((".$units."-1)*".$fiftysix.")+".$cypher_row['cypherPartPallet'].")-".$damage_row['SumOfDamageBags'].")"; }else if($cypher_row['cypherPartPallet']<1 && $damage_row['SumOfDamageBags']>0){ $bagsmade = (($units*$fiftysix)-$damage_row['SumOfDamageBags']); $bagtooltip = "((".$units."*".$fiftysix.")-".$damage_row['SumOfDamageBags'].")"; }else{ $bagsmade = $units*$fiftysix; $bagtooltip = $units."*".$fiftysix; } if($bagsmade<0) $bagsmade=0; if($firstunit!='-' && $bagsmade<1) $bagsmade = 1; if($cypher_row['userID']=='0') $class="text-success"; else $class=""; echo " "; if($debug) echo " "; if($cypher_row['cypherKGsmade']==0 || $cypher_row['cypherKGsmade']==null) $cypherKGsmade = $bagsmade*$meanweight; else $cypherKGsmade = $cypher_row['cypherKGsmade']; $totalkgs += $cypherKGsmade; echo " "; } echo ""; ?>

Product

First unit

Last unit

Pallets made

Items per pallet

Part pallet items

Damages

Items made

Avg weight

KGs made

Remove

"; if($debug) echo "[".$cypher_row['cypherID']."] "; echo date('d/m/y',strtotime($cypher_row['cypherManuDate']))." "; if($_SESSION['cypherorbatch']==0) echo $cypher_row['cypherText']; if($_SESSION['cypherorbatch']==1) echo $cypher_row['cypherOrderID']; if($_SESSION['cypherorbatch']==2) echo $cypher_row['cypherText']." ".$cypher_row['cypherOrderID']; echo "

".$cypher_row['specText']."

".$firstunit."

".$lastunit."

".$units."

".number_format($fiftysix)."

".number_format($cypher_row['cypherPartPallet'])."

".number_format($damage_row['SumOfDamageBags'])."

".number_format($bagsmade)."

".number_format($meanweight,3)."

".number_format($cypherKGsmade)."

Total

".number_format($totalkgs)."