Smopp_v2/input_data.php

<?
require_once 'PHPExcel_1.8.0_doc/Classes/PHPExcel.php';
include "functions";
if (!$logged_me_in_successfully234)
    return;

if ($new == "1")
{
    ?>
    <form action="?act=input_data" method="post">
    		<b>Введите данные новой задачи:</b>
    		<br>
                <p>Действие:                     
                    <select name="action_num">
                        <option value="1">Перемещение на склад длительного хранения</option>                        
                    </select></p>    		
                <p>Номер проекта (внешний документ): $<input name="project_number" minlength="6" maxlength="6"></p>
                <p>Номер палеты: <input name="pallet_number" minlength="13" maxlength="13"></p>
                <p>Текущая ячейка: <b><input name="c1" size="1" maxlength="3"> . <input name="c2" size="1" maxlength="3"> . <input name="c3" size="1" maxlength="3"> . <input name="c4" size="1" maxlength="3"></b></p>
                <p>Куда:    
                    <select name="where">
                        <option value="1">01</option>
                        <option value="2">02</option>
                        <option value="3">03</option>
                    </select></p>
                </p>                
                <input type="submit" value="Добавить">
            <input type="hidden" name="new" value="2">
            <input type="hidden" name="subtasks" value="0">
    	</form>
<?
}
else
{
    if (isset($assign_id) && isset($assign_act))
    {
        StartProject($assign_act, $assign_id);
    }

    if ($new == "2")
    {
        $current_cell = $c1.".".$c2.".".$c3.".".$c4;
        echo "<span style='color:green'><b>Запись добавлена!</b></span>";
        $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 "<span style='color:red'><b>Запись $del_id удалена!</b></span>";
        mysqli_query($link, "delete from input_tables where id =".$del_id);
    }
    else if ($new == "4") {

       // echo "<pre>",  print_r($_FILES),  "</pre>";
        if ( $_FILES  )
        {
            $data = XLSRead($_FILES['filename']['tmp_name'], 1);
            //TODO преобразовать файл в таблицу
            for ($i=3; $i<sizeof($data); $i++)
            {
                $action =  $data[$i]["D"];
                if ($action == '')
                    continue;
                $actarr = explode(' ',$action);

                $where = intval($data[$i]["P"]);
                $inner_id = intval($data[$i]["G"]);
                $action_name = $actarr[0];
                $pallet_number = $actarr[1];
                $project_number = $data[$i]["O"];
                $project_number[0] = '';
                $project_number = trim($project_number);
                $current_cell = $actarr[2];
                $action_num = 1;
                //echo 'палета '.$actarr[1].' по адресу '.$actarr[2].' ';
                //echo 'Row ' . $i . ' ID ' . $data[$i]["G"] . ' action ' . $data[$i]["D"] . ' whereto ' . $data[$i]["P"] . ' Внешний проект ' . $data[$i]["O"] . '<br>';


                $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."<br>";
                mysqli_query($link, $qstr);
            }
        }
    }
    else if ($new == "5")
    {
        mysqli_query($link, "delete from input_tables");
        echo "<span style='color: green'>Все задачи удалены!</span>";
    }
    echo "        <form id='form5' name='form5' method='post'>                        
            <input type='submit' value='Удалить все'>            
            <input type='hidden' name='new' value='5'>
        </form>";
   echo "<h3>Входные данные, компания ".$companyname.":</h3> <form id='form1' name='form1' method='post'>";
    $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 '<input type="checkbox" name="table' . $data_id . '"/>';
            echo "<b>$data_id:</b>";
        } else {
            echo "<b>$data_id:</b>";
            if ($status == 3)
                echo "<span style='color:green'><b>[Выполнено] </b></span>";
            else if ($status == 3)
                echo "<span style='color:blue'><b>[В работе] </b></span>";
        }
        $action_data = FindAction($action);
        echo "[Проект: <b>$$project_number</b>], <b>".$action_data["name"] ."[$action]</b> палеты <b>$pallet_number</b> из ячейки <b>$current_cell</b> на склад <b>0$whereto</b>";
        if ($status == 3)
            echo ", новая ячейка <span style='color:blue'><b>$new_cell</b></span>";
        else
            echo " <input type='button' onclick='DelInputData($data_id)' value='Удалить'>";
        if($status == 2)
            {
                echo
                    "<select name='assignees'>
                        <option value='1'>01</option>                                                
                    </select></p>";
                $query1 = mysqli_query($link, "select * from input_tables where company=$companyID");
            }
        else if($status == 1)
            echo "<input type='button' onclick='AssignTask($data_id, $action, $companyID)' value='Создать задачи'>";
        echo "<br>";
    }
    echo "</form>";

    echo "
        <form id='form2' name='form2' method='post'>

            <input type='submit' value='Создать новую таблицу'>            
            <input type='hidden' name='new' value='1'>
        </form>
    ";
    echo '  <input type="hidden" name="MAX_FILE_SIZE" value="300000">
  <form action="?act=input_data&new=4" method="post" enctype="multipart/form-data">
            <input type="submit" value="Загрузить новую таблицу из файла Excel:" onclick="return CheckXLS();">
            <input id="xlsload" type="file" name="filename"  accept=".xlsx,.xls"/><br>       
        
    </form>';
    //XLSRead();            <input type='button' value='На помеченные создать задачи'><input type='button' value='Помеченные удалить'><br><br>
}

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