function lbl_add_csv($link, $file, $fr_addr, $to_addr) { $row = 1; $handle = fopen($file, "r"); while (!feof($handle)) { $data = fgetcsv($handle, 300, ";"); $num = count($data); // Number of columns //echo "<p> $num полей в строке $row: <br /></p>\n"; //echo "String ".$row." Number of columns " .$num."<br><br>"; $row++; if ($row > 2) { $receiver = $data[0]; $date_lbl = $data[1]; $date = date_form($data[1]); $part_number = $data[2]; $quantity = $data[3]; $quantity = str_replace(" ", "", $quantity); $quantity = (int) $quantity; $action = 'add from csv'; $add = lbl_add($link, $action, $part_number, $quantity, $date, $receiver, $fr_addr, $to_addr); $len = get_max_id($link); $filepath = lbl_update($part_number, $quantity, $date_lbl, $receiver, $len); lbl_print($filepath); //echo $receiver . ' - ' . $date . ' - ' . $part_number . ' - ' . $quantity . "<br><br>"; } } fclose($handle); $labels_added = $row - 2; return $labels_added; }
$body->set("itemldontheme", $itemldontheme); $body->set("skilltypes", $skilltypes); $body->set("bodytypes", $bodytypes); $body->set("itemraces", $races); $body->set("itemsaugrestrict", $itemsaugrestrict); $body->set("itembagsize", $itembagsize); $body->set("world_containers", $world_containers); $body->set("itembardtype", $itembardtype); $body->set("itempointtype", $itempointtype); $body->set("itemcasttype", $itemcasttype); $body->set("proccasttype", $proccasttype); $body->set("worncasttype", $worncasttype); $body->set("focuscasttype", $focuscasttype); $body->set("scrollcasttype", $scrollcasttype); $body->set("yesno", $yesno); $body->set('newid', get_max_id()); $body->set("factions", factions_array()); $vars = getdate(); if ($vars) { foreach ($vars as $key => $value) { $body->set($key, $value); } } break; case 9: //Add Item check_authorization(); add_item(); $id = $_POST['id']; header("Location: index.php?editor=items&id={$id}&action=2"); exit;
header("Location: ./views/menu_scan.php"); } else { header("Location: ./views/menu.php"); } } switch ($action) { case 'add': // _______ADD_______ $fr_addr = 'SUPPLIER'; $to_addr = 'DROPZONE'; if (!empty($_POST)) { $date_lbl = $_POST['date']; $date = date_form($_POST['date']); $add = lbl_add($link, $action, $_POST['part_number'], $_POST['quantity'], $date, $_POST['receiver'], $fr_addr, $to_addr); if ($add) { $len = get_max_id($link); $filepath = lbl_update($_POST['part_number'], $_POST['quantity'], $date_lbl, $_POST['receiver'], $len); $command = lbl_print($filepath); //echo $command; header("Location: ./views/menu.php"); } else { $err_msg = "PART NUMBER DOESN'T EXIST!"; require_once "/views/error.php"; } } else { require_once "./views/label_add.php"; } break; case 'add_csv': // _______ADD from CSV_______ $fr_addr = 'SUPPLIER';