Smopp_v2/projects_old.php

<?
require_once 'PHPExcel_1.8.0_doc/Classes/PHPExcel.php';
//include "functions";

if (!$logged_me_in_successfully234)
    return;

if ($new == "1")
{
    AddNewTaskType();
}
else
{
    if (isset($assign_id) && isset($assign_act))
    {
        if (StartProject($assign_act, $assign_id))
            TasksAssign('',true);
    }

    if ($new == "2")
    {
        echo "<span style='color:green'><b>Запись добавлена!</b></span>";
        $qstr = "insert into projects_locotech (action, company, status, loco_type,loco_number,depo,depo_service ) values (".$action_num.",".$companyID.",1,'$loco_type',$loco_number,'$depo','$depo_service' )";
        //echo ' qstr '.$qstr;
        mysqli_query($link, $qstr);
    }
    else if ($new == "3")
    {
        echo "<span style='color:red'><b>Запись $del_id удалена!</b></span>";
        mysqli_query($link, "delete from projects_locotech where id =".$del_id);
    }
    else if ($new == "4") {
        echo "<p style='color: red'>Не предоставлен образец входного документа!</p>";
        /*
       // 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 projects_locotech (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 projects_locotech");
        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 projects_locotech where company=$companyID");
    while ($res1 = mysqli_fetch_array($query1)) {
        $data_id = $res1['id'];
        $action = $res1['action'];
        $status = intval($res1['status']);
        $loco_type = $res1['loco_type'];
        $loco_number = intval($res1['loco_number']);
        $depo = $res1['depo'];
        $depo_service = $res1['depo_service'];

        if ($status == 1) {
            //echo '<input type="checkbox" name="table' . $data_id . '"/>';
            echo "<span style='color:green'><b>$data_id:</b></span>";
        }
        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>".$action_data["name"] ."[$action]</b> тип <b>$loco_type</b> №<b>$loco_number</b> Депо <b>$depo</b>";
        if ($status == 3)
            echo ", новая ячейка <span style='color:blue'><b>$new_cell</b></span>";
        else
            echo " <input type='button' onclick='DelProj($data_id)' value='Удалить'>";
        if($status == 2)
            {
                echo
                    "<select name='assignees'>
                        <option value='1'>01</option>                                                
                    </select></p>";
                $query1 = mysqli_query($link, "select * from projects_locotech 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=projects&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 AddNewProject()
{
    echo '
    <form action="?act=projects" method="post">
    		<b>Введите данные нового проекта:</b>
    		<br><br>
                <p>Действие проекта:
                    <select name="action_num">';
                    ActionsForm(FindActions());
                echo '
                    </select></p>

                    <p>Серия локомотива:
                        <select name="loco_type">
                            <option value="Э5К">Э5К</option>
                            <option value="2ЭС5К">2ЭС5К</option>
                            <option value="3ЭС5К3">3ЭС5К</option>
                        </select></p>
                    </p>
                    <p>Номер локомотива: <input name="loco_number" minlength="6" maxlength="6"></p>
                    <p>Депо приписки:
                        <select name="depo">
                            <option value="ТЧЭ-9">ТЧЭ-9</option>
                        </select></p>
                    </p>
                    <p>Депо сервисного обслуживания:
                        <select name="depo_service">
                            <option value="Братское">Братское</option>
                        </select></p>
                    </p>
                <input type="submit" value="Добавить">
            <input type="hidden" name="new" value="2">
            <input type="hidden" name="subtasks" value="0">
    	</form>';
}

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