Введите данные новой задачи:

Действие:

Номер проекта (внешний документ): $

Номер палеты:

Текущая ячейка: . . .

Куда:

Запись добавлена!"; $qstr = "insert into input_tables (project_number, pallet_number, current_cell, action, whereto, company, status) values (".$project_number.",".$pallet_number.",'".$current_cell."',".$action.",".$where.",".$companyID.",1)"; // echo "query string ".$qstr; mysqli_query($link, $qstr); } else if ($new == "3") { echo "Запись $del_id удалена!"; mysqli_query($link, "delete from input_tables where id =".$del_id); } else if ($new == "4") { // echo "
",  print_r($_FILES),  "
"; if ( $_FILES ) { $data = XLSRead($_FILES['filename']['tmp_name'], 1); //TODO преобразовать файл в таблицу for ($i=3; $i'; $qstr = "insert into input_tables (id_inner, project_number, pallet_number, current_cell, action, whereto, company, status) values (".$inner_id.",".$project_number.",".$pallet_number.",'".$current_cell."',".$action_num.",".$where.",".$companyID.",1)"; //echo "query string ".$qstr."
"; mysqli_query($link, $qstr); } } } else if ($new == "5") { mysqli_query($link, "delete from input_tables"); echo "Все задачи удалены!"; } echo "
"; echo "

Входные данные, компания ".$companyname.":

"; $query1 = mysqli_query($link, "select * from input_tables where company=$companyID"); while ($res1 = mysqli_fetch_array($query1)) { $data_id = $res1['id']; $project_number = $res1['project_number']; $pallet_number = $res1['pallet_number']; $current_cell = $res1['current_cell']; $action = $res1['ProjectType']; $whereto = $res1['whereto']; $new_cell = $res1['new_cell']; $status = intval($res1['status']); if ($status == 1) { echo ''; echo "$data_id:"; } else { echo "$data_id:"; if ($status == 3) echo "[Выполнено] "; else if ($status == 3) echo "[В работе] "; } $action_data = FindAction($action); echo "[Проект: $$project_number], ".$action_data["name"] ."[$action] палеты $pallet_number из ячейки $current_cell на склад 0$whereto"; if ($status == 3) echo ", новая ячейка $new_cell"; else echo " "; if($status == 2) { echo "

"; $query1 = mysqli_query($link, "select * from input_tables where company=$companyID"); } else if($status == 1) echo ""; echo "
"; } echo "
"; echo "
"; echo '

'; //XLSRead();

} function GetSelected($whereto, $num) { if ($whereto == $num) return 'selected'; return ''; } ?>