setOutputEncoding('CP1251'); $data->read('pickLists/'.$pickListFiles[$k]); error_reporting(E_ALL ^ E_NOTICE); $pickList = ""; for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) { for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) { $pickList[$i][$j] .= $data->sheets[0]['cells'][$i][$j]; } } array_shift($pickList); //Remove heading row echo "

Despatch Check List

"; $j = 1; $total = 0; while($j < count($pickList)) //Loop through rows and carry out actions { //Look through array for particular product and add to search terms if (in_array($pickList[$j][12], $productSearchTerms) == false) # if product not present in list, then add. { $productSearchTerms[] = $pickList[$j][12]; $searchKey = array_search($pickList[$j][12], $productSearchTerms); $productSearchTerms[$searchKey][1] = $pickList[$j][11]; # Pick number $productSearchTerms[$searchKey][2] = $pickList[$j][14]; # Price } //Calculate Individual Product Quantities if (in_array($pickList[$j][12], $productSearchTerms) == true) { $productSearchTerms[$searchKey][3] += $pickList[$j][13]; # Add quantity of that product. } //Tabulate Data echo ""; echo ( "". "". "". "". "". "". "". "" ); echo ""; $total += $pickList[$j][14]; $j++; } echo "
".$j.".".$pickList[$j][2]."".$pickList[$j][3]."".$pickList[$j][9]."".$pickList[$j][11]."".$pickList[$j][12]."".$pickList[$j][13]."".$pickList[$j][14]."
"; echo "
"; echo "Total £".$total; rename ("pickLists\\".$pickListFiles[$k], "storedPickLists\\".$pickListFiles[$k]); $k++; } //Display individual product quantities //====================================== asort($productSearchTerms); $i=0; while ($i < count($productSearchTerms)) { //echo ($i.". ".$productSearchTerms[$i]."
"); echo ($i.". ".$productSearchTerms[$i]." | ".$productSearchTerms[$i][1]." | ".$productSearchTerms[$i][3]. " | ".$productSearchTerms[$i][3]*$productSearchTerms[$i][2]."
"); $i++; } ?>