\n";
$out .= "\n";
$out .= "\n";
$out .= "\n";
$out .= "\n";
$out .= "<Contractor Date='".$date_e[2]."-".$date_e[1]."-".$date_e[0]."'>\n";
$out .= "<FIO>\n";
$Cad_Eng_FIO = explode(" ", trim($_POST['Cad_Eng_FIO']));
$out .= "<Surname>";//Фамилия
$out .= $Cad_Eng_FIO[0];
$out .= "</Surname>\n";
$out .= "<First>";//Имя
$out .= $Cad_Eng_FIO[1];
$out .= "</First>\n";
if(isset($Cad_Eng_FIO[2])){
$out .= "<Patronymic>";//Отчество
$out .= $Cad_Eng_FIO[2];
$out .= "</Patronymic>\n";
}
$out .= "</FIO>\n";
$out .= "<N_Certificate>".$_POST['Cad_Eng_N_Certificate']."</N_Certificate>\n";
$out .= "<Telephone>".$_POST['Cad_Eng_Telephone']."</Telephone>\n";
$out .= "<Address>".$_POST['Cad_Eng_Address']."</Address>\n";
$out .= "<E_mail>".$_POST['Cad_Eng_E_mail']."</E_mail>\n";
$out .= "<Organization>".$_POST['Cad_Org_name']."</Organization>\n";
$out .= "</Contractor>\n";
if($_POST['Purpose']){
$out .= "<Purpose>".$_POST['Purpose']."</Purpose>\n";
}
$out .= "<Reason>".$_POST['Reason']."</Reason>\n";
$out .= "<Client Date = '".$date_g[2]."-".$date_g[1]."-".$date_g[0]."'>\n";
if($_POST['Client'] == "Person"){
$out .= "<Person>";//Физические лица
$out .= "<FIO>";//Фамилия, имя, отчество для Физ. лиц
$ClientFIO = explode(" ", trim($_POST['Clientfio']));
$out .= "<Surname>";//Фамилия
$out .= $ClientFIO[0];
$out .= "</Surname>";
$out .= "<First>";//Имя
$out .= $ClientFIO[1];
$out .= "</First>";
if(isset($ClientFIO[2])){
$out .= "<Patronymic>";//Отчество
$out .= $ClientFIO[2];
$out .= "</Patronymic>";
}
$out .= "</FIO>";
$out .= "</Person>";
}
if($_POST['Client'] == "Organization"){
$out .= "<Organization>";//Юридические лица
$out .= "<Name>";//Полное наименование
$out .= $_POST['org_name'];
$out .= "</Name>";
$out .= "<Agent>";//Представитель
$ClientFIO = explode(" ", trim($_POST['org_fio']));
$out .= "<Surname>";//Фамилия
$out .= $ClientFIO[0];
$out .= "</Surname>";
$out .= "<First>";//Имя
$out .= $ClientFIO[1];
$out .= "</First>";
if(isset($ClientFIO[2])){
$out .= "<Patronymic>";//Отчество
$out .= $ClientFIO[2];
$out .= "</Patronymic>";
}
$out .= "<Appointment>";//Должность
$out .= $_POST['org_app'];
$out .= "</Appointment>";
$out .= "</Agent>";
$out .= "</Organization>";
}
if($_POST['Client'] == "Governance"){
$out .= "<Governance>";//Орган государственной власти, орган местного самоуправления
$out .= "<Name>";//Полное наименование
$out .= $_POST['gov_name'];
$out .= "</Name>";
$out .= "<Agent>";//Представитель
$ClientFIO = explode(" ", trim($_POST['gov_fio']));
$out .= "<Surname>";//Фамилия
$out .= $ClientFIO[0];
$out .= "</Surname>";
$out .= "<First>";//Имя
$out .= $ClientFIO[1];
$out .= "</First>";
if(isset($ClientFIO[2])){
$out .= "<Patronymic>";//Отчество
$out .= $ClientFIO[2];
$out .= "</Patronymic>";
}
$out .= "<Appointment>";//Должность
$out .= $_POST['gov_app'];
$out .= "</Appointment>";
$out .= "</Agent>";
$out .= "</Governance>";
}
if($_POST['Client'] == "Foreign_Organization"){
$out .= "<Foreign_Organization>";
$out .= "<Name>";//Полное наименование
$out .= $_POST['for_name'];
$out .= "</Name>";
$out .= "<Country>";//Наименование страны регистрации (инкорпорации)
$out .= $_POST['for_country'];
$out .= "</Country>";
$out .= "<Agent>";//Представитель
$ClientFIO = explode(" ", trim($_POST['for_fio']));
$out .= "<Surname>";//Фамилия
$out .= $ClientFIO[0];
$out .= "</Surname>";
$out .= "<First>";//Имя
$out .= $ClientFIO[1];
$out .= "</First>";
if(isset($ClientFIO[2])){
$out .= "<Patronymic>";//Отчество
$out .= $ClientFIO[2];
$out .= "</Patronymic>";
}
$out .= "<Appointment>";//Должность
$out .= $_POST['for_app'];
$out .= "</Appointment>";
$out .= "</Agent>";
$out .= "</Foreign_Organization>";
}
$out .= "</Client>\n";
$out .= "\n";
$out .= "\n";
$out .= "\n";
for($i = 1; $i <= $_POST['add_new_parcel_']; $i++){
$out .= "\n";
$out .= "".$_POST['CadastralBlock'.$i]."\n";
if($_POST['numprev'.$i] > 0){
$out .= "\n";
for($j = 1; $j <= $_POST['numprev'.$i]; $j++){
$out .= "".$_POST['prevnum'.$i.'_'.$j]."\n";
}
$out .= "\n";
}
if($_POST['numprovide'.$i] > 0 || $_POST['commpar'.$i] == "on" || $_POST['numprovidedef'.$i] > 0){
$out .= "\n";
for($j = 1; $j <= $_POST['numprovide'.$i]; $j++){
$out .= "".$_POST['provide'.$i.'_'.$j]."\n";
}
for($j = 1; $j <= $_POST['numprovidedef'.$i]; $j++){
$out .= "".$_POST['provide_def'.$i.'_'.$j]."\n";
}
if($_POST['commpar'.$i] == "on"){
$out .= "Земли общего пользования\n";
}
$out .= "\n";
}
if($_POST['numinner'.$i] > 0){
$out .= "\n";
for($j = 1; $j <= $_POST['numinner'.$i]; $j++){
$out .= "".$_POST['inner'.$i.'_'.$j]."\n";
}
$out .= "\n";
}
$out .= "\n";
$out .= "".$_POST['TotalArea'.$i]."\n";
$out .= "055\n";
if($_POST['TotalIncuracy'.$i] < 1){
$out .= "1\n";
}else{
$out .= "".$_POST['TotalIncuracy'.$i]."\n";
}
$out .= "\n";
$out .= "\n";
$out .= "".$_POST['OKATO'.$i]."\n";
$out .= "".$_POST['KLADR'.$i]."\n";
if($_POST['Postal_Code'.$i]){
$out .= "".$_POST['Postal_Code'.$i]."\n";
}
$out .= "".$_POST['region'.$i]."\n";
if($_POST['District'.$i]){
$out .= "\n";
}
if($_POST['City'.$i]){
$out .= "\n";
}
if($_POST['City_District'.$i]){
$out .= "\n";
}
if($_POST['Soviet_Village'.$i]){
$out .= "\n";
}
if($_POST['Locality'.$i]){
$out .= "\n";
}
if($_POST['Street_Name'.$i]){
$out .= "\n";
}
if($_POST['Level1_Name'.$i]){
$out .= "\n";
}
if($_POST['Level2_Name'.$i]){
$out .= "\n";
}
if($_POST['Level3_Name'.$i]){
$out .= "\n";
}
if($_POST['Level4_Name'.$i]){
$out .= "\n";
}
if($_POST['note'.$i]){
$out .= "".$_POST['note'.$i]."\n";
}
$out .= "\n";
$out .= "\n";
$out .= "\n";
if($_POST['add_new_sub_parcel_']){
$counter = 0;
for($j = 1; $j <= $_POST['add_new_sub_parcel_']; $j++){
if($_POST['ownparcel'.$j] == $i){
$counter++;
$sub_par_num[$counter] = $j;
}
}
if($counter){
$out .= "\n";
for($j = 1; $j <= $counter; $j++){
$out .= "\n";
$out .= "\n";
$out .= "".$_POST['SubParArea'.$sub_par_num[$j]]."\n";
$out .= "055\n";
$out .= "".$_POST['SubParInc'.$sub_par_num[$j]]."\n";
$out .= "\n";
$out .= "\n";
$out .= "".$_POST['EncName'.$sub_par_num[$j]]."\n";
$out .= "".$_POST['EncType'.$sub_par_num[$j]]."\n";
$out .= "\n";
$out .= "\n";
$out .= "\n";
for($k = 1; $k <= $_POST['total_sub_points'.$sub_par_num[$j]]; $k++){
$out .= "\n";
$input = $_POST['input_sub_number'.$sub_par_num[$j].'_'.$k];
if($input[0] == "н"){
$Num_Geopoint = "";
for($m = 1; $m < strlen($_POST['input_sub_number'.$sub_par_num[$j].'_'.$k]); $m++)
$Num_Geopoint .= $input[$m];
$out .= "\n";
}else{
$Num_Geopoint = $_POST['input_sub_number'.$sub_par_num[$j].'_'.$k];
$out .= "\n";
}
$out .= "\n";
}
$out .= "\n";
$out .= "\n";
$out .= "\n";
}
$out .= "\n";
}
}
if($_POST['totalcont'.$i] == 1){
$out .= "\n";
$out .= "\n";
for($j = 1; $j <= $_POST['m_total_point'.$i.'_1']; $j++){
$out .= "\n";
$input = $_POST['m_point_num'.$i.'_1_'.$j];
if($input[0] == "н"){
$Num_Geopoint = "";
for($m = 1; $m < strlen($_POST['m_point_num'.$i.'_1_'.$j]); $m++)
$Num_Geopoint .= $input[$m];
$out .= "\n";
}else{
$Num_Geopoint = $_POST['m_point_num'.$i.'_1_'.$j];
$out .= "\n";
}
$out .= "\n";
}
$out .= "\n";
for($j = 1; $j <= $_POST['total_parts'.$i.'_1']; $j++){
$out .= "\n";
for($k = 1; $k <= $_POST['total_part_points'.$i.'_1_'.$j]; $k++){
$out .= "\n";
$input = $_POST['p_point_num'.$i.'_1_'.$j.'_'.$k];
if($input[0] == "н"){
$Num_Geopoint = "";
for($m = 1; $m < strlen($_POST['p_point_num'.$i.'_1_'.$j.'_'.$k]); $m++)
$Num_Geopoint .= $input[$m];
$out .= "\n";
}else{
$Num_Geopoint = $_POST['p_point_num'.$i.'_1_'.$j.'_'.$k];
$out .= "\n";
}
$out .= "\n";
}
$out .= "\n";
}
if($_POST['m_edge_len'.$i.'_1_1']){
$out .= "\n";
for($j = 1; $j <= ($_POST['m_total_point'.$i.'_1'] - 1); $j++){
if($j != ($_POST['m_total_point'.$i.'_1'] - 1)){
$out .= "\n";
}else{
$out .= "\n";
}
$out .= "\n";
if($_POST['m_edge_len'.$i.'_1_'.$j]){
$out .= "".$_POST['m_edge_len'.$i.'_1_'.$j]."\n";
}
if($_POST['m_edge_def'.$i.'_1_'.$j]){
$out .= "".$_POST['m_edge_def'.$i.'_1_'.$j]."\n";
}
$out .= "\n";
$out .= "\n";
}
for($j = 1; $j <= $_POST['total_parts'.$i.'_1']; $j++){
for($k = 1; $k <= ($_POST['total_part_points'.$i.'_1_'.$j] - 1); $k++){
if($_POST['p_edge_len'.$i.'_1_'.$j.'_1']){
if($k != ($_POST['total_part_points'.$i.'_1_'.$j] - 1)){
$out .= "\n";
}
else{
$out .= "\n";
}
$out .= "\n";
if($_POST['p_edge_len'.$i.'_1_'.$j.'_'.$k]){
$out .= "".$_POST['p_edge_len'.$i.'_1_'.$j.'_'.$k]."\n";
}
if($_POST['p_edge_def'.$i.'_1_'.$j.'_'.$k]){
$out .= "".$_POST['p_edge_def'.$i.'_1_'.$j.'_'.$k]."\n";
}
$out .= "\n";
}
$out .= "\n";
}
}
$out .= "\n";
}
$out .= "\n";
}
if($_POST['totalcont'.$i] > 1){
$out .= "\n";
for($j = 1; $j <= $_POST['totalcont'.$i]; $j++){
$out .= "\n";
$out .= "\n";
$out .= "".$_POST['area'.$i.'_'.$j]."\n";
$out .= "055\n";
if(round($_POST['delta'.$i.'_'.$j]) < 1){
$out .= "1\n";
}else{
$out .= "".round($_POST['delta'.$i.'_'.$j])."\n";
}
$out .= "\n";
$out .= "\n";
$out .= "\n";
for($k = 1; $k <= $_POST['m_total_point'.$i.'_'.$j]; $k++){
$out .= "\n";
$input = $_POST['m_point_num'.$i.'_'.$j.'_'.$k];
if($input[0] == "н"){
$Num_Geopoint = "";
for($m = 1; $m < strlen($_POST['m_point_num'.$i.'_'.$j.'_'.$k]); $m++)
$Num_Geopoint .= $input[$m];
$out .= "\n";
}else{
$Num_Geopoint = $_POST['m_point_num'.$i.'_'.$j.'_'.$k];
$out .= "\n";
}
$out .= "\n";
}
$out .= "\n";
for($k = 1; $k <= $_POST['total_parts'.$i.'_'.$j]; $k++){
$out .= "\n";
for($l = 1; $l <= $_POST['total_part_points'.$i.'_'.$j.'_'.$k]; $l++){
$out .= "\n";
$input = $_POST['p_point_num'.$i.'_'.$j.'_'.$k.'_'.$l];
if($input[0] == "н"){
$Num_Geopoint = "";
for($m = 1; $m < strlen($_POST['p_point_num'.$i.'_'.$j.'_'.$k.'_'.$l]); $m++)
$Num_Geopoint .= $input[$m];
$out .= "\n";
}else{
$Num_Geopoint = $_POST['p_point_num'.$i.'_'.$j.'_'.$k.'_'.$l];
$out .= "\n";
}
$out .= "\n";
}
$out .= "\n";
}
if($_POST['m_edge_len'.$i.'_'.$j.'_1']){
$out .= "\n";
for($k = 1; $k <= ($_POST['m_total_point'.$i.'_'.$j] - 1); $k++){
if($k != ($_POST['m_total_point'.$i.'_'.$j] - 1)){
$out .= "\n";
}else{
$out .= "\n";
}
$out .= "\n";
if($_POST['m_edge_len'.$i.'_'.$j.'_'.$k]){
$out .= "".$_POST['m_edge_len'.$i.'_'.$j.'_'.$k]."\n";
}
if($_POST['m_edge_def'.$i.'_'.$j.'_'.$k]){
$out .= "".$_POST['m_edge_def'.$i.'_'.$j.'_'.$k]."\n";
}
$out .= "\n";
$out .= "\n";
}
for($k = 1; $k <= $_POST['total_parts'.$i.'_'.$j]; $k++){
for($l = 1; $l <= ($_POST['total_part_points'.$i.'_'.$j.'_'.$k] - 1); $l++){
if($_POST['p_edge_len'.$i.'_'.$j.'_'.$k.'_1']){
if($l != ($_POST['total_part_points'.$i.'_'.$j.'_'.$k] - 1)){
$out .= "\n";
}
else{
$out .= "\n";
}
$out .= "\n";
if($_POST['p_edge_len'.$i.'_'.$j.'_'.$k.'_'.$l]){
$out .= "".$_POST['p_edge_len'.$i.'_'.$j.'_'.$k.'_'.$l]."\n";
}
if($_POST['p_edge_def'.$i.'_'.$j.'_'.$k.'_'.$l]){
$out .= "".$_POST['p_edge_def'.$i.'_'.$j.'_'.$k.'_'.$l]."\n";
}
$out .= "\n";
}
$out .= "\n";
}
}
$out .= "\n";
}
$out .= "\n";
$out .= "\n";
}
$out .= "\n";
}
if($_POST['Lim_Min'.$i]){
$out .= "\n";
$out .= "".$_POST['Lim_Min'.$i]."\n";
$out .= "055\n";
$out .= "\n";
}
if($_POST['Lim_Max'.$i]){
$out .= "\n";
$out .= "".$_POST['Lim_Max'.$i]."\n";
$out .= "055\n";
$out .= "\n";
}
$out .= "\n";
}
for($i = 1; $i <= $_POST['add_new_rel_parcel_']; $i++){
$out .= "\n";
$out .= "\n";
$out .= "\n";
$out .= "\n";
for($j = 1; $j <= $_POST['total_old_points'.$i]; $j++){
$out .= "\n";
$input = $_POST['input_old_number'.$i.'_'.$j];
if($input[0] == "н"){
$Num_Geopoint = "";
for($m = 1; $m < strlen($_POST['input_old_number'.$i.'_'.$j]); $m++)
$Num_Geopoint .= $input[$m];
$out .= "\n";
}else{
$Num_Geopoint = $_POST['input_old_number'.$i.'_'.$j];
$out .= "\n";
}
$out .= "\n";
}
for($j = 1; $j <= $_POST['total_new_points'.$i]; $j++){
$out .= "\n";
$input = $_POST['input_new_number'.$i.'_'.$j];
if($input[0] == "н"){
$Num_Geopoint = "";
for($m = 1; $m < strlen($_POST['input_new_number'.$i.'_'.$j]); $m++)
$Num_Geopoint .= $input[$m];
$out .= "\n";
}else{
$Num_Geopoint = $_POST['input_new_number'.$i.'_'.$j];
$out .= "\n";
}
$out .= "\n";
}
$out .= "\n";
$out .= "\n";
$out .= "\n";
$out .= "\n";
}
$out .= "\n";
$out .= "\n";
$out .= "\n";
$out .= "\n";
$out .= "\n";
$out .= "\n";
if($_POST['add_new_doc_'] > 0){
$out .= "\n";
for($i = 1; $i <= $_POST['add_new_doc_']; $i++){
$f = fopen("DocumentsTP.csv", "r");
$data = fgetcsv($f, 1000, ';');
for($j = 1;;$j++){
if($data[0] == $_POST['select_doc_'.$i])
{
$docname = $data[1];
break;
}
$data = fgetcsv($f, 1000, ';');
}
$out .= "\n"; //Реквизиты документов
$out .= ""; //Код документа
if($_POST['select_doc_'.$i][0] == "8"){
$_POST['select_doc_'.$i] = "00".$_POST['select_doc_'.$i];
}
$out .= $_POST['select_doc_'.$i];
$out .= "\n";
$out .= ""; //Наименование документа
$out .= $docname;
$out .= "\n";
if($_POST['Series'.$i] != ""){
$out .= "";
$out .= $_POST['Series'.$i];
$out .= "\n";
}
if($_POST['Number'.$i] != ""){
$out .= "";
$out .= $_POST['Number'.$i];
$out .= "\n";
}
if($_POST['Date'.$i] != ""){
$docd = explode(".", $_POST['Date'.$i]);
$out .= "";
$out .= $docd[2]."-".$docd[1]."-".$docd[0];
$out .= "\n";
}
if($_POST['IssueOrgan'.$i] != ""){
$out .= "";
$out .= $_POST['IssueOrgan'.$i];
$out .= "\n";
}
if($_POST['NumberReg'.$i] != ""){
$out .= "";
$out .= $_POST['NumberReg'.$i];
$out .= "\n";
}
if($_POST['DateReg'.$i] != ""){
$docd = explode(".", $_POST['DateReg'.$i]);
$out .= "";
$out .= $docd[2]."-".$docd[1]."-".$docd[0];
$out .= "\n";
}
if($_POST['Started'.$i] != "" || $_POST['Stopped'.$i] != ""){
$out .= "";
if($_POST['Started'.$i] != ""){
$docd = explode(".", $_POST['Started'.$i]);
$out .= "";
$out .= $docd[2]."-".$docd[1]."-".$docd[0];
$out .= "";
}
if($_POST['Stopped'.$i] != ""){
$docd = explode(".", $_POST['Stopped'.$i]);
$out .= "";
$out .= $docd[2]."-".$docd[1]."-".$docd[0];
$out .= "";
}
$out .= "\n";
}
if($_POST['Register'.$i] != ""){
$out .= "";
$out .= $_POST['Register'.$i];
$out .= "\n";
}
if($_POST['Desc'.$i] != ""){
$out .= "";
$out .= $_POST['Desc'.$i];
$out .= "\n";
}
if($_POST['IssueOrgan_Code'.$i] != ""){
$out .= "";
$out .= $_POST['IssueOrgan_Code'.$i];
$out .= "\n";
}
if($_POST['Img_Name'.$i] != ""){
if(strpos($_POST['Img_Name'.$i], "C:") !== false){
$ImgName = explode('\\', $_POST['Img_Name'.$i]);
$_POST['Img_Name'.$i] = $ImgName[2];
}
$out .= "";
$out .= "";
$out .= "\n";
}
$out .= "\n";
}
$out .= "\n";
}
if($_POST['add_new_geo_point_'] > 0){
$out .= "\n";
for($i = 1; $i <= $_POST['add_new_geo_point_']; $i++){
$out .= "\n";
$out .= "".$_POST['geoname_'.$i]."\n";
$out .= "".$_POST['geotype_'.$i]."\n";
$out .= "".$_POST['geoclass_'.$i]."\n";
$out .= "".$_POST['geox_'.$i]."\n";
$out .= "".$_POST['geoy_'.$i]."\n";
$out .= "\n";
}
$out .= "\n";
}
if($_POST['add_new_app_'] > 0){
$out .= "\n";
for($i = 1; $i <= $_POST['add_new_app_']; $i++){
$dev = explode("$", $_POST['device_'.$i]);
$out .= "\n";
$out .= "".$dev[0]."\n";
$out .= "".$dev[1]."\n";
$out .= "".$dev[2]."\n";
$out .= "\n";
}
$out .= "\n";
}
$out .= "\n";
if($_POST['survey_file']){
$out .= "\n";
$out .= "\n";
$out .= "\n";
}
$out .= "\n";
$out .= $_POST['conclusion'];
$out .= "\n";
if($_POST['geo_file']){
$out .= "\n";
$out .= "\n";
$out .= "\n";
}
if($_POST['pos_file']){
$out .= "\n";
$out .= "\n";
$out .= "\n";
}
$out .= "\n";
$out .= "\n";
$out .= "\n";
if($_POST['act_file']){
$out .= "\n";
$out .= "\n";
$out .= "\n";
}
if($_POST['add_new_doc_'] > 0){
$out .= "\n";
for($i = 1; $i <= $_POST['add_new_doc_']; $i++){
$f = fopen("DocumentsTP.csv", "r");
$data = fgetcsv($f, 1000, ';');
for($j = 1;;$j++){
if($data[0] == $_POST['select_doc_'.$i])
{
$docname = $data[1];
break;
}
$data = fgetcsv($f, 1000, ';');
}
$out .= "\n"; //Реквизиты документов
$out .= ""; //Код документа
$out .= $_POST['select_doc_'.$i];
$out .= "\n";
$out .= ""; //Наименование документа
$out .= $docname;
$out .= "\n";
if($_POST['Series'.$i] != ""){
$out .= "";
$out .= $_POST['Series'.$i];
$out .= "\n";
}
if($_POST['Number'.$i] != ""){
$out .= "";
$out .= $_POST['Number'.$i];
$out .= "\n";
}
if($_POST['Date'.$i] != ""){
$docd = explode(".", $_POST['Date'.$i]);
$out .= "";
$out .= $docd[2]."-".$docd[1]."-".$docd[0];
$out .= "\n";
}
if($_POST['IssueOrgan'.$i] != ""){
$out .= "";
$out .= $_POST['IssueOrgan'.$i];
$out .= "\n";
}
if($_POST['NumberReg'.$i] != ""){
$out .= "";
$out .= $_POST['NumberReg'.$i];
$out .= "\n";
}
if($_POST['DateReg'.$i] != ""){
$docd = explode(".", $_POST['DateReg'.$i]);
$out .= "";
$out .= $docd[2]."-".$docd[1]."-".$docd[0];
$out .= "\n";
}
if($_POST['Started'.$i] != "" || $_POST['Stopped'.$i] != ""){
$out .= "";
if($_POST['Started'.$i] != ""){
$docd = explode(".", $_POST['Started'.$i]);
$out .= "";
$out .= $docd[2]."-".$docd[1]."-".$docd[0];
$out .= "";
}
if($_POST['Stopped'.$i] != ""){
$docd = explode(".", $_POST['Stopped'.$i]);
$out .= "";
$out .= $docd[2]."-".$docd[1]."-".$docd[0];
$out .= "";
}
$out .= "\n";
}
if($_POST['Register'.$i] != ""){
$out .= "";
$out .= $_POST['Register'.$i];
$out .= "\n";
}
if($_POST['Desc'.$i] != ""){
$out .= "";
$out .= $_POST['Desc'.$i];
$out .= "\n";
}
if($_POST['IssueOrgan_Code'.$i] != ""){
$out .= "";
$out .= $_POST['IssueOrgan_Code'.$i];
$out .= "\n";
}
if($_POST['Img_Name'.$i] != ""){
if(strpos($_POST['Img_Name'.$i], "C:") !== false){
$ImgName = explode('\\', $_POST['Img_Name'.$i]);
$_POST['Img_Name'.$i] = $ImgName[2];
}
$out .= "";
$out .= "";
$out .= "\n";
}
$out .= "\n";
}
$out .= "\n";
}
$out .= "";
$output = iconv("Windows-1251", "UTF-8", $out);
$fout = fopen($_SESSION['userdir']."/GKUZU_".$GUID.".xml", "w");
fwrite($fout, $output);
fclose($fout);
$tpo = "new\n";
$tpo .= "Method;".$_POST['Method']."\n";
$tpo .= "Reason;".$_POST['Reason']."\n";
$tpo .= "Purpose;".$_POST['Purpose']."\n";
$tpo .= "Cad_Eng_FIO;".$_POST['Cad_Eng_FIO']."\n";
$tpo .= "Cad_Eng_N_Certificate;".$_POST['Cad_Eng_N_Certificate']."\n";
$tpo .= "Cad_Eng_Telephone;".$_POST['Cad_Eng_Telephone']."\n";
$tpo .= "Cad_Eng_E_mail;".$_POST['Cad_Eng_E_mail']."\n";
$tpo .= "Cad_Eng_Address;".$_POST['Cad_Eng_Address']."\n";
$tpo .= "Cad_Org_name;".$_POST['Cad_Org_name']."\n";
$tpo .= "Date_End;".$_POST['Date_End']."\n";
$tpo .= "add_new_app_;".$_POST['add_new_app_']."\n";
for($i = 1; $i <= $_POST['add_new_app_']; $i++){
$tpo .= $_POST['device_'.$i]."\n";
}
$tpo .= "Client;".$_POST['Client']."\n";
if($_POST['Client'] == "Person"){
$tpo .= "Clientfio;".$_POST['Clientfio']."\n";
}
if($_POST['Client'] == "Organization"){
$tpo .= "org_name;".$_POST['org_name']."\n";
$tpo .= "org_fio;".$_POST['org_fio']."\n";
$tpo .= "org_app;".$_POST['org_app']."\n";
}
if($_POST['Client'] == "Governance"){
$tpo .= "gov_name;".$_POST['gov_name']."\n";
$tpo .= "gov_fio;".$_POST['gov_fio']."\n";
$tpo .= "gov_app;".$_POST['gov_app']."\n";
}
if($_POST['Client'] == "Foreign_Organization"){
$tpo .= "for_name;".$_POST['for_name']."\n";
$tpo .= "for_country;".$_POST['for_country']."\n";
$tpo .= "for_fio;".$_POST['for_fio']."\n";
$tpo .= "for_app;".$_POST['for_app']."\n";
}
$tpo .= "Date_Get;".$_POST['Date_Get']."\n";
$tpo .= "add_new_doc_;".$_POST['add_new_doc_']."\n";
for($i = 1; $i <= $_POST['add_new_doc_']; $i++){
$tpo .= "Code_Document;".$_POST['select_doc_'.$i]."\n";
$tpo .= "Series;".$_POST['Series'.$i]."\n";
$tpo .= "Number;".$_POST['Number'.$i]."\n";
$tpo .= "Date;".$_POST['Date'.$i]."\n";
$tpo .= "IssueOrgan;".$_POST['IssueOrgan'.$i]."\n";
$tpo .= "NumberReg;".$_POST['NumberReg'.$i]."\n";
$tpo .= "DateReg;".$_POST['DateReg'.$i]."\n";
$tpo .= "Started;".$_POST['Started'.$i]."\n";
$tpo .= "Stopped;".$_POST['Stopped'.$i]."\n";
$tpo .= "Register;".$_POST['Register'.$i]."\n";
$tpo .= "Desc;".$_POST['Desc'.$i]."\n";
$tpo .= "IssueOrgan_Code;".$_POST['IssueOrgan_Code'.$i]."\n";
$tpo .= "Img_Name;".$_POST['Img_Name'.$i]."\n";
}
$tpo .= "coord_sys;".$_POST['coord_sys']."\n";
$tpo .= "add_new_geo_point_;".$_POST['add_new_geo_point_']."\n";
for($i = 1; $i <= $_POST['add_new_geo_point_']; $i++){
$tpo .= "PName;".$_POST['geoname_'.$i]."\n";
$tpo .= "PKind;".$_POST['geotype_'.$i]."\n";
$tpo .= "PKlass;".$_POST['geoclass_'.$i]."\n";
$tpo .= "OrdX;".$_POST['geox_'.$i]."\n";
$tpo .= "OrdY;".$_POST['geoy_'.$i]."\n";
}
$tpo .= "add_new_parcel_;".$_POST['add_new_parcel_']."\n";
for($i = 1; $i <= $_POST['add_new_parcel_']; $i++){
$tpo .= "Definition;".$_POST['Definition'.$i]."\n";
$tpo .= "CadastralBlock;".$_POST['CadastralBlock'.$i]."\n";
$tpo .= "Category;".$_POST['Category'.$i]."\n";
$tpo .= "ByDoc;".$_POST['ByDoc'.$i]."\n";
$tpo .= "Util;".$_POST['Util'.$i]."\n";
$tpo .= "Lim_Min;".$_POST['Lim_Min'.$i]."\n";
$tpo .= "Lim_Max;".$_POST['Lim_Max'.$i]."\n";
$tpo .= "OKATO;".$_POST['OKATO'.$i]."\n";
$tpo .= "KLADR;".$_POST['KLADR'.$i]."\n";
$tpo .= "Postal_Code;".$_POST['Postal_Code'.$i]."\n";
$tpo .= "region_type;".$_POST['region_type'.$i]."\n";
$tpo .= "region;".$_POST['region'.$i]."\n";
$tpo .= "District_type;".$_POST['District_type'.$i]."\n";
$tpo .= "District;".$_POST['District'.$i]."\n";
$tpo .= "City_type;".$_POST['City_type'.$i]."\n";
$tpo .= "City;".$_POST['City'.$i]."\n";
$tpo .= "City_District;".$_POST['City_District'.$i]."\n";
$tpo .= "Soviet_Village;".$_POST['Soviet_Village'.$i]."\n";
$tpo .= "Locality_type;".$_POST['Locality_type'.$i]."\n";
$tpo .= "Locality;".$_POST['Locality'.$i]."\n";
$tpo .= "Street_Type;".$_POST['Street_Type'.$i]."\n";
$tpo .= "Street_Name;".$_POST['Street_Name'.$i]."\n";
$tpo .= "Level1_Type;".$_POST['Level1_Type'.$i]."\n";
$tpo .= "Level1_Name;".$_POST['Level1_Name'.$i]."\n";
$tpo .= "Level2_Type;".$_POST['Level2_Type'.$i]."\n";
$tpo .= "Level2_Name;".$_POST['Level2_Name'.$i]."\n";
$tpo .= "Level3_Type;".$_POST['Level3_Type'.$i]."\n";
$tpo .= "Level3_Name;".$_POST['Level3_Name'.$i]."\n";
$tpo .= "Level4_Type;".$_POST['Level4_Type'.$i]."\n";
$tpo .= "Level4_Name;".$_POST['Level4_Name'.$i]."\n";
$tpo .= "note;".$_POST['note'.$i]."\n";
$tpo .= "numprev;".$_POST['numprev'.$i]."\n";
for($j = 1; $j <= $_POST['numprev'.$i]; $j++){
$tpo .= $_POST['prevnum'.$i.'_'.$j]."\n";
}
$tpo .= "commpar;".$_POST['commpar'.$i]."\n";
$tpo .= "numprovide;".$_POST['numprovide'.$i]."\n";
for($j = 1; $j <= $_POST['numprovide'.$i]; $j++){
$tpo .= $_POST['provide'.$i.'_'.$j]."\n";
}
$tpo .= "numprovidedef;".$_POST['numprovidedef'.$i]."\n";
for($j = 1; $j <= $_POST['numprovidedef'.$i]; $j++){
$tpo .= $_POST['provide_def'.$i.'_'.$j]."\n";
}
$tpo .= "numinner;".$_POST['numinner'.$i]."\n";
for($j = 1; $j <= $_POST['numinner'.$i]; $j++){
$tpo .= $_POST['inner'.$i.'_'.$j]."\n";
}
$tpo .= "totalcont;".$_POST['totalcont'.$i]."\n";
for($j = 1; $j <= $_POST['totalcont'.$i]; $j++){
$tpo .= "area;".$_POST['area'.$i.'_'.$j]."\n";
$tpo .= "precision;".$_POST['precision'.$i.'_'.$j]."\n";
$tpo .= "m_total_point;".$_POST['m_total_point'.$i.'_'.$j]."\n";
for($k = 1; $k <= $_POST['m_total_point'.$i.'_'.$j]; $k++){
$tpo .= $_POST['m_point_num'.$i.'_'.$j.'_'.$k].";";
$tpo .= $_POST['m_point_x'.$i.'_'.$j.'_'.$k].";";
$tpo .= $_POST['m_point_y'.$i.'_'.$j.'_'.$k].";";
$tpo .= $_POST['m_point_zac'.$i.'_'.$j.'_'.$k]."\n";
}
for($k = 1; $k <= ($_POST['m_total_point'.$i.'_'.$j] - 1); $k++){
$tpo .= $_POST['m_edge_len'.$i.'_'.$j.'_'.$k].";";
$tpo .= $_POST['m_edge_def'.$i.'_'.$j.'_'.$k]."\n";
}
$tpo .= "total_parts;".$_POST['total_parts'.$i.'_'.$j]."\n";
for($k = 1; $k <= $_POST['total_parts'.$i.'_'.$j]; $k++){
$tpo .= "total_part_points;".$_POST['total_part_points'.$i.'_'.$j.'_'.$k]."\n";
for($l = 1; $l <= $_POST['total_part_points'.$i.'_'.$j.'_'.$k]; $l++){
$tpo .= $_POST['p_point_num'.$i.'_'.$j.'_'.$k.'_'.$l].";";
$tpo .= $_POST['p_point_x'.$i.'_'.$j.'_'.$k.'_'.$l].";";
$tpo .= $_POST['p_point_y'.$i.'_'.$j.'_'.$k.'_'.$l].";";
$tpo .= $_POST['p_point_zac'.$i.'_'.$j.'_'.$k.'_'.$l]."\n";
}
for($l = 1; $l <= ($_POST['total_part_points'.$i.'_'.$j.'_'.$k] - 1); $l++){
$tpo .= $_POST['p_edge_len'.$i.'_'.$j.'_'.$k.'_'.$l].";";
$tpo .= $_POST['p_edge_def'.$i.'_'.$j.'_'.$k.'_'.$l]."\n";
}
}
}
}
$tpo .= "add_new_rel_parcel_;".$_POST['add_new_rel_parcel_']."\n";
for($i = 1; $i <= $_POST['add_new_rel_parcel_']; $i++){
$tpo .= "Rel_Cad_Num;".$_POST['Rel_Cad_Num'.$i]."\n";
$tpo .= "rel_precision;".$_POST['rel_precision'.$i]."\n";
$tpo .= "total_old_points;".$_POST['total_old_points'.$i]."\n";
for($j = 1; $j <= $_POST['total_old_points'.$i]; $j++){
$tpo .= $_POST['input_old_number'.$i.'_'.$j].";";
$tpo .= $_POST['input_old_cx'.$i.'_'.$j].";";
$tpo .= $_POST['input_old_cy'.$i.'_'.$j].";";
$tpo .= $_POST['input_old_lock'.$i.'_'.$j]."\n";
}
$tpo .= "total_new_points;".$_POST['total_new_points'.$i]."\n";
for($j = 1; $j <= $_POST['total_new_points'.$i]; $j++){
$tpo .= $_POST['input_new_number'.$i.'_'.$j].";";
$tpo .= $_POST['input_new_cx'.$i.'_'.$j].";";
$tpo .= $_POST['input_new_cy'.$i.'_'.$j].";";
$tpo .= $_POST['input_new_lock'.$i.'_'.$j]."\n";
}
}
$tpo .= "add_new_sub_parcel_;".$_POST['add_new_sub_parcel_']."\n";
for($i = 1; $i <= $_POST['add_new_sub_parcel_']; $i++){
$tpo .= "SubParDef;".$_POST['SubParDef'.$i]."\n";
$tpo .= "ownparcel;".$_POST['ownparcel'.$i]."\n";
$tpo .= "realty;".$_POST['realty'.$i]."\n";
$tpo .= "EncName;".$_POST['EncName'.$i]."\n";
$tpo .= "EncType;".$_POST['EncType'.$i]."\n";
$tpo .= "sub_precision;".$_POST['sub_precision'.$i]."\n";
$tpo .= "SubParArea;".$_POST['SubParArea'.$i]."\n";
$tpo .= "SubParInc;".$_POST['SubParInc'.$i]."\n";
$tpo .= "total_sub_points;".$_POST['total_sub_points'.$i]."\n";
for($j = 1; $j <= $_POST['total_sub_points'.$i]; $j++){
$tpo .= $_POST['input_sub_number'.$i.'_'.$j].";";
$tpo .= $_POST['input_sub_cx'.$i.'_'.$j].";";
$tpo .= $_POST['input_sub_cy'.$i.'_'.$j].";";
$tpo .= $_POST['input_sub_lock'.$i.'_'.$j]."\n";
}
}
$tpo .= "survey_file;".$_POST['survey_file']."\n";
$tpo .= "act_file;".$_POST['act_file']."\n";
$tpo .= "geo_file;".$_POST['geo_file']."\n";
$tpo .= "pos_file;".$_POST['pos_file']."\n";
$tpo .= "par_file;".$_POST['par_file']."\n";
$tpo .= "conclusion\n";
$tpo .= $conclusion;
$fout = fopen($_SESSION['userdir']."/GKUZU_".$GUID.".tpo", "w");
fwrite($fout, $tpo);
fclose($fout);
//-------------------------------------------------------------------------------------------------------------------------
//Титульный лист
$objPHPExcel = PHPExcel_IOFactory::load("excel/templates/1 Титульный лист.xls");
$objPHPExcel->setActiveSheetIndex(0);
$listnum += 2;
for($i = 1;; $i++){
if(!isset($_POST['pages'.$i])){
break;
}
if($_POST['pages'.$i] != ""){
$listnum += $_POST['pages'.$i];
}
}
$objPHPExcel->getActiveSheet()->setCellValue('CU7', $listnum);
$objPHPExcel->getActiveSheet()->setCellValue('F17', "V");
if($_POST['Client'] == "Person"){
$objPHPExcel->getActiveSheet()->setCellValue('B29', iconv("Windows-1251", "UTF-8", $_POST['Clientfio']));
$fio = explode(" ", $_POST['Clientfio']);
$name = $fio[1];
$patr = $fio[2];
if($patr != ""){
$tmp = "/ ".$fio[0]." ".$name[0].". ".$patr[0].". /";
}else{
$tmp = "/ ".$fio[0]." ".$name[0].". /";
}
$objPHPExcel->getActiveSheet()->setCellValue('B32', iconv("Windows-1251", "UTF-8", $tmp));
}
if($_POST['Client'] == "Organization"){
$objPHPExcel->getActiveSheet()->setCellValue('B29', iconv("Windows-1251", "UTF-8", $_POST['org_name']));
$fio = explode(" ", $_POST['org_fio']);
$name = $fio[1];
$patr = $fio[2];
if($patr != ""){
$tmp = "/ ".$fio[0]." ".$name[0].". ".$patr[0].". /";
}else{
$tmp = "/ ".$fio[0]." ".$name[0].". /";
}
$objPHPExcel->getActiveSheet()->setCellValue('L31', iconv("Windows-1251", "UTF-8", $tmp));
$objPHPExcel->getActiveSheet()->setCellValue('B32', iconv("Windows-1251", "UTF-8", $_POST['org_app']));
}
if($_POST['Client'] == "Governance"){
$objPHPExcel->getActiveSheet()->setCellValue('B29', iconv("Windows-1251", "UTF-8", $_POST['gov_name']));
$fio = explode(" ", $_POST['gov_fio']);
$name = $fio[1];
$patr = $fio[2];
if($patr != ""){
$tmp = "/ ".$fio[0]." ".$name[0].". ".$patr[0].". /";
}else{
$tmp = "/ ".$fio[0]." ".$name[0].". /";
}
$objPHPExcel->getActiveSheet()->setCellValue('L31', iconv("Windows-1251", "UTF-8", $tmp));
$objPHPExcel->getActiveSheet()->setCellValue('B32', iconv("Windows-1251", "UTF-8", $_POST['gov_app']));
}
if($_POST['Client'] == "Foreign_Organization"){
$objPHPExcel->getActiveSheet()->setCellValue('B29', iconv("Windows-1251", "UTF-8", $_POST['for_name'].", Страна регистрации: ".$_POST['for_country']));
}
if($_POST['Contractor'] == "Cadastral_Engineer"){
$objPHPExcel->getActiveSheet()->setCellValue('AW38', iconv("Windows-1251", "UTF-8", $_POST['Cad_Eng_FIO']));
$objPHPExcel->getActiveSheet()->setCellValue('BF40', iconv("Windows-1251", "UTF-8", $_POST['Cad_Eng_N_Certificate']));
$objPHPExcel->getActiveSheet()->setCellValue('X42', iconv("Windows-1251", "UTF-8", $_POST['Cad_Eng_Telephone']));
$objPHPExcel->getActiveSheet()->setCellValue('B45', iconv("Windows-1251", "UTF-8", "Адрес: ".$_POST['Cad_Eng_Address']));
$objPHPExcel->getActiveSheet()->setCellValue('B46', iconv("Windows-1251", "UTF-8", "E-Mail: ".$_POST['Cad_Eng_E_mail']));
$objPHPExcel->getActiveSheet()->setCellValue('W48', iconv("Windows-1251", "UTF-8", $_POST['Cad_Org_name']));
$fio = explode(" ", $_POST['Cad_Eng_FIO']);
$name = $fio[1];
$patr = $fio[2];
if($patr != ""){
$tmp = "/ ".$fio[0]." ".$name[0].". ".$patr[0].". /";
}else{
$tmp = "/ ".$fio[0]." ".$name[0].". /";
}
$objPHPExcel->getActiveSheet()->setCellValue('L50', iconv("Windows-1251", "UTF-8", $tmp));
}
if($_POST['Contractor'] == "Cadastral_Organization"){
$objPHPExcel->getActiveSheet()->setCellValue('AW38', iconv("Windows-1251", "UTF-8", $_POST['Cad_Org_Officer']));
$objPHPExcel->getActiveSheet()->setCellValue('BF40', iconv("Windows-1251", "UTF-8", $_POST['Cad_Org_Document']));
$objPHPExcel->getActiveSheet()->setCellValue('X42', iconv("Windows-1251", "UTF-8", $_POST['Cad_Org_Telephone']));
$objPHPExcel->getActiveSheet()->setCellValue('B45', iconv("Windows-1251", "UTF-8", "Адрес: ".$_POST['Cad_Org_Address']));
$objPHPExcel->getActiveSheet()->setCellValue('B46', iconv("Windows-1251", "UTF-8", "E-Mail: ".$_POST['Cad_Org_E_mail']));
$objPHPExcel->getActiveSheet()->setCellValue('W48', iconv("Windows-1251", "UTF-8", $_POST['Cad_Org_name']));
}
$month['01'] = 'января';
$month['02'] = 'февраля';
$month['03'] = 'марта';
$month['04'] = 'апреля';
$month['05'] = 'мая';
$month['06'] = 'июня';
$month['07'] = 'июля';
$month['08'] = 'августа';
$month['09'] = 'сентября';
$month['10'] = 'октября';
$month['11'] = 'ноября';
$month['12'] = 'декабря';
$date_e = explode(".", $_POST['Date_End']);
$date_g = explode(".", $_POST['Date_Get']);
$objPHPExcel->getActiveSheet()->setCellValue('BW33', iconv("Windows-1251", "UTF-8", $date_g[0]));
$objPHPExcel->getActiveSheet()->setCellValue('CD33', iconv("Windows-1251", "UTF-8", $month[$date_g[1]]));
$objPHPExcel->getActiveSheet()->setCellValue('CT33', iconv("Windows-1251", "UTF-8", $date_g[2]));
$objPHPExcel->getActiveSheet()->setCellValue('BW50', iconv("Windows-1251", "UTF-8", $date_e[0]));
$objPHPExcel->getActiveSheet()->setCellValue('CD50', iconv("Windows-1251", "UTF-8", $month[$date_e[1]]));
$objPHPExcel->getActiveSheet()->setCellValue('CT50', iconv("Windows-1251", "UTF-8", $date_e[2]));
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save($_SESSION['userdir']."/GUOKS_".$dname."/1 Титульный лист.xlsx");
//-------------------------------------------------------------------------------------------------------------------------
//Содержание
$objPHPExcel = PHPExcel_IOFactory::load("excel/templates/2 Содержание.xls");
$objPHPExcel->setActiveSheetIndex(0);
//$listcounter[$listnum] = "Заключение кадастрового инженера";
$objPHPExcel->getActiveSheet()->setCellValue('A7', "1");
$objPHPExcel->getActiveSheet()->setCellValue('I7', iconv("Windows-1251", "UTF-8", "Титульный лист"));
$objPHPExcel->getActiveSheet()->setCellValue('CP7', "1");
$objPHPExcel->getActiveSheet()->setCellValue('A8', "2");
$objPHPExcel->getActiveSheet()->setCellValue('I8', iconv("Windows-1251", "UTF-8", "Содержание"));
$objPHPExcel->getActiveSheet()->setCellValue('CP8', "2");
$objPHPExcel->getActiveSheet()->setCellValue('A9', "3");
$objPHPExcel->getActiveSheet()->setCellValue('I9', iconv("Windows-1251", "UTF-8", "Исходные данные"));
$objPHPExcel->getActiveSheet()->setCellValue('CP9', "3");
$objPHPExcel->getActiveSheet()->setCellValue('A10', "4");
$objPHPExcel->getActiveSheet()->setCellValue('I10', iconv("Windows-1251", "UTF-8", "Сведения о выполненых измерениях и расчетах"));
$objPHPExcel->getActiveSheet()->setCellValue('CP10', "4");
$objPHPExcel->getActiveSheet()->setCellValue('A11', "5");
$objPHPExcel->getActiveSheet()->setCellValue('I11', iconv("Windows-1251", "UTF-8", "Описание местоположения здания на земельном участке"));
$objPHPExcel->getActiveSheet()->setCellValue('CP11', "5");
$n = 0;
for($i = 5;; $i++){
if($listcounter[$i] == "Описание местоположения здания на земельном участке"){
$n++;
}
if($listcounter[$i] == "Характеристики здания"){
break;
}
}
$objPHPExcel->getActiveSheet()->setCellValue('A12', "6");
$objPHPExcel->getActiveSheet()->setCellValue('I12', iconv("Windows-1251", "UTF-8", "Характеристики здания"));
$objPHPExcel->getActiveSheet()->setCellValue('CP12', 5+$n);
if($_POST['conclusion'] != ""){
$objPHPExcel->getActiveSheet()->setCellValue('A13', "7");
$objPHPExcel->getActiveSheet()->setCellValue('I13', iconv("Windows-1251", "UTF-8", "Заключение кадастрового инженера"));
$objPHPExcel->getActiveSheet()->setCellValue('CP13', 6+$n);
$conclusion = 0;
}else{
$n--;
$conclusion = -1;
}
$objPHPExcel->getActiveSheet()->setCellValue('A'.(14 + $conclusion), (8 + $conclusion));
$objPHPExcel->getActiveSheet()->setCellValue('I'.(14 + $conclusion), iconv("Windows-1251", "UTF-8", "Схема геодезических построений"));
$objPHPExcel->getActiveSheet()->setCellValue('CP'.(14 + $conclusion), 7+$n);
$objPHPExcel->getActiveSheet()->setCellValue('A'.(15 + $conclusion), (9 + $conclusion));
$objPHPExcel->getActiveSheet()->setCellValue('I'.(15 + $conclusion), iconv("Windows-1251", "UTF-8", "Схема расположения здания на земельном участке"));
$objPHPExcel->getActiveSheet()->setCellValue('CP'.(15 + $conclusion), 8+$n);
$objPHPExcel->getActiveSheet()->setCellValue('A'.(16 + $conclusion), (10 + $conclusion));
$objPHPExcel->getActiveSheet()->setCellValue('I'.(16 + $conclusion), iconv("Windows-1251", "UTF-8", "Чертеж контура здания"));
$objPHPExcel->getActiveSheet()->setCellValue('CP'.(16 + $conclusion), 9+$n);
$p = 0;
for($i = 1;;$i++){
if(!isset($_POST['select_doc_'.$i])){
break;
}
$f = fopen("DocumentsTP.csv", "r");
$data = fgetcsv($f, 1000, ';');
if($_POST['pages'.$i] != ""){
$p++;
for($j = 1;;$j++){
if($data[0] == $_POST['select_doc_'.$i])
{
$docname = $data[1];
break;
}
$data = fgetcsv($f, 1000, ';');
}
$k = $i + 1;
if($_POST['conclusion'] != ""){
$pages = 1;
}else{
$pages = 0;
}
if(isset($_POST['select_doc_'.$k])){
$objPHPExcel->getActiveSheet()->insertNewRowBefore(16+$p+ $conclusion,1);
$objPHPExcel->getActiveSheet()->mergeCells('A'.(16+$p+ $conclusion).':H'.(16+$p+ $conclusion));
$objPHPExcel->getActiveSheet()->mergeCells('I'.(16+$p+ $conclusion).':CO'.(16+$p+ $conclusion));
$objPHPExcel->getActiveSheet()->mergeCells('CP'.(16+$p+ $conclusion).':DD'.(16+$p+ $conclusion));
}
if(isset($_POST['select_doc_'.$i])){
$objPHPExcel->getActiveSheet()->setCellValue('A'.(16+$p+ $conclusion), 9+$p+$pages);
$objPHPExcel->getActiveSheet()->setCellValue('I'.(16+$p+ $conclusion), iconv("Windows-1251", "UTF-8", $docname));
$objPHPExcel->getActiveSheet()->setCellValue('CP'.(16+$p+ $conclusion), "-");
}
}else{
continue;
}
}
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save($_SESSION['userdir']."/GUOKS_".$dname."/2 Содержание.xlsx");
//-------------------------------------------------------------------------------------------------------------------------
//Создаём файл XML
$output = iconv("Windows-1251", "UTF-8", $out);
$fout = fopen($_SESSION['userdir']."/GUOKS_".$dname.".xml", "w");
fwrite($fout, $output);
fclose($fout);
//------------------------------------------------------------------------
//Создаём файлы декларации
//------------------------------------------------------------------------
$out = $_POST['Contractor']."\n";//Динамические элементы
$out .= $_POST['Client']."\n";
$out .= "8\n";
$out .= "add_new_doc;".$_POST['add_new_doc_']."\n";
$out .= "add_new_kart;".$_POST['add_new_kart_']."\n";
$out .= "add_new_geo_point;".$_POST['add_new_geo_point_']."\n";
$out .= "add_new_app;".$_POST['add_new_app_']."\n";
$out .= "add_new_mat;".$_POST['add_new_mat_']."\n";
$out .= "add_new_parent;".$_POST['add_new_parent_']."\n";
$out .= "add_new_obj;".$_POST['add_new_obj_']."\n";
$out .= "add_new_number_oks;".$_POST['add_new_number_oks_']."\n";
$out .= $_POST['numcont']."\n";
for($i = 1; $i <= $_POST['numcont']; $i++){
$k = 0;
for($j = 1; $j <= $_POST['numpoints'.$i]; $j++){
if(!isset($_POST['input_cx'.$i.'_'.$j])){
continue;
}
$k++;
}
$out .= $k."\n";
}
//Кадастровый инженер
if($_POST['Contractor'] == "Cadastral_Engineer"){
$out .= "Cad_Eng_FIO;".$_POST['Cad_Eng_FIO']."\n";
$out .= "Cad_Eng_N_Certificate;".$_POST['Cad_Eng_N_Certificate']."\n";
$out .= "Cad_Eng_INN;".$_POST['Cad_Eng_INN']."\n";
$out .= "Cad_Eng_Telephone;".$_POST['Cad_Eng_Telephone']."\n";
$out .= "Cad_Eng_E_mail;".$_POST['Cad_Eng_E_mail']."\n";
$out .= "Cad_Eng_Address;".$_POST['Cad_Eng_Address']."\n";
$out .= "Cad_Org_name;".$_POST['Cad_Org_name']."\n";
$out .= "Cad_Org_OGRN;".$_POST['Cad_Org_OGRN']."\n";
$out .= "Cad_Org_Telephone;".$_POST['Cad_Org_Telephone']."\n";
$out .= "Cad_Org_E_mail;".$_POST['Cad_Org_E_mail']."\n";
$out .= "Cad_Org_Address;".$_POST['Cad_Org_Address']."\n";
}
if($_POST['Contractor'] == "Cadastral_Organization"){
$out .= "Cad_Org_name;".$_POST['Cad_Org_name']."\n";
$out .= "Cad_Org_OGRN;".$_POST['Cad_Org_OGRN']."\n";
$out .= "Cad_Org_Officer;".$_POST['Cad_Org_Officer']."\n";
$out .= "Cad_Org_Telephone;".$_POST['Cad_Org_Telephone']."\n";
$out .= "Cad_Org_E_mail;".$_POST['Cad_Org_E_mail']."\n";
$out .= "Cad_Org_Address;".$_POST['Cad_Org_Address']."\n";
}
$out .= "Date_End;".$_POST['Date_End']."\n";
for($i = 1; $i <= $_POST['add_new_obj_']; $i++){
$out .= "objnum_".$i.";".$_POST['objnum_'.$i]."\n";
}
//Приборы
for($i = 1; $i <= $_POST['add_new_app_']; $i++){
$out .= "device_".$i.";".$_POST['device_'.$i]."\n";
}
//Заказчик
if($_POST['Client'] == "Person"){
$out .= "Clientfio;".$_POST['Clientfio']."\n";
}
if($_POST['Client'] == "Organization"){
$out .= "org_name;".$_POST['org_name']."\n";
$out .= "org_fio;".$_POST['org_fio']."\n";
$out .= "org_app;".$_POST['org_app']."\n";
}
if($_POST['Client'] == "Governance"){
$out .= "gov_name;".$_POST['gov_name']."\n";
$out .= "gov_fio;".$_POST['gov_fio']."\n";
$out .= "gov_app;".$_POST['gov_app']."\n";
}
if($_POST['Client'] == "Foreign_Organization"){
$out .= "for_name;".$_POST['for_name']."\n";
$out .= "for_country;".$_POST['for_country']."\n";
$out .= "for_fio;".$_POST['for_fio']."\n";
$out .= "for_app;".$_POST['for_app']."\n";
}
$out .= "Date_Get;".$_POST['Date_Get']."\n";
//Характеристики здания
$out .= "Cad_Number;".$_POST['Cad_Number']."\n";
for($i = 1; $i <= $_POST['add_new_parent_']; $i++){
$out .= "Parent_CadastralNumber".$i.";".$_POST['Parent_CadastralNumber'.$i]."\n";
}
for($i = 1; $i <= $_POST['add_new_number_oks_']; $i++){
$out .= "okslist".$i.";".$_POST['okslist'.$i]."\n";
$out .= "Old_Number_OKS".$i.";".$_POST['Old_Number_OKS'.$i]."\n";
$out .= "date_given".$i.";".$_POST['date_given'.$i]."\n";
$out .= "org_given".$i.";".$_POST['org_given'.$i]."\n";
}
$out .= "OKATO;".$_POST['OKATO']."\n";
$out .= "KLADR;".$_POST['KLADR']."\n";
$out .= "Postal_Code;".$_POST['Postal_Code']."\n";
$out .= "region_type;".$_POST['region_type']."\n";
$out .= "region;".$_POST['region']."\n";
$out .= "District_type;".$_POST['District_type']."\n";
$out .= "District;".$_POST['District']."\n";
$out .= "City_type;".$_POST['City_type']."\n";
$out .= "City;".$_POST['City']."\n";
$out .= "City_District;".$_POST['City_District']."\n";
$out .= "Soviet_Village;".$_POST['Soviet_Village']."\n";
$out .= "Locality_type;".$_POST['Locality_type']."\n";
$out .= "Locality;".$_POST['Locality']."\n";
$out .= "Street_Type;".$_POST['Street_Type']."\n";
$out .= "Street_Name;".$_POST['Street_Name']."\n";
$out .= "Level1_Type;".$_POST['Level1_Type']."\n";
$out .= "Level1_Name;".$_POST['Level1_Name']."\n";
$out .= "Level2_Type;".$_POST['Level2_Type']."\n";
$out .= "Level2_Name;".$_POST['Level2_Name']."\n";
$out .= "Level3_Type;".$_POST['Level3_Type']."\n";
$out .= "Level3_Name;".$_POST['Level3_Name']."\n";
$out .= "Level4_Type;".$_POST['Level4_Type']."\n";
$out .= "Level4_Name;".$_POST['Level4_Name']."\n";
$out .= "Name_consolidation;".$_POST['Name_consolidation']."\n";
$out .= "Other;".$_POST['Other']."\n";
$out .= "note;".$_POST['note']."\n";
$out .= "dAss_b;".$_POST['dAss_b']."\n";
$out .= "Floors;".$_POST['Floors']."\n";
$out .= "Sub_Floors;".$_POST['Sub_Floors']."\n";
//Материалы
for($i = 1; $i <= $_POST['add_new_mat_']; $i++){
$out .= "select_mat_".$i.";".$_POST['select_mat_'.$i]."\n";
}
$out .= "Ent_Year;".$_POST['Ent_Year']."\n";
$out .= "Fin_Year;".$_POST['Fin_Year']."\n";
$out .= "Area;".$_POST['Area']."\n";
//Документы
for($i = 1; $i <= $_POST['add_new_doc_']; $i++){
$out .= "select_doc_".$i.";".$_POST['select_doc_'.$i]."\n";
$out .= "Series".$i.";".$_POST['Series'.$i]."\n";
$out .= "Number".$i.";".$_POST['Number'.$i]."\n";
$out .= "Date".$i.";".$_POST['Date'.$i]."\n";
$out .= "IssueOrgan".$i.";".$_POST['IssueOrgan'.$i]."\n";
$out .= "NumberReg".$i.";".$_POST['NumberReg'.$i]."\n";
$out .= "DateReg".$i.";".$_POST['DateReg'.$i]."\n";
$out .= "Started".$i.";".$_POST['Started'.$i]."\n";
$out .= "Stopped".$i.";".$_POST['Stopped'.$i]."\n";
$out .= "Register".$i.";".$_POST['Register'.$i]."\n";
$out .= "Img_Name".$i.";".$_POST['Img_Name'.$i]."\n";
$out .= "URL".$i.";".$_POST['URL'.$i]."\n";
$out .= "Desc".$i.";".$_POST['Desc'.$i]."\n";
$out .= "IssueOrgan_Code".$i.";".$_POST['IssueOrgan_Code'.$i]."\n";
$out .= "pages".$i.";".$_POST['pages'.$i]."\n";
}
$out .= "coord_sys;".$_POST['coord_sys']."\n";
for($i = 1; $i <= $_POST['add_new_geo_point_']; $i++){
$out .= "geoname_".$i.";".$_POST['geoname_'.$i]."\n";
$out .= "geotype_".$i.";".$_POST['geotype_'.$i]."\n";
$out .= "geoclass_".$i.";".$_POST['geoclass_'.$i]."\n";
$out .= "geox_".$i.";".$_POST['geox_'.$i]."\n";
$out .= "geoy_".$i.";".$_POST['geoy_'.$i]."\n";
}
for($i = 1; $i <= $_POST['add_new_kart_']; $i++){
$out .= "Kart_Kind".$i.";".$_POST['Kart_Kind'.$i]."\n";
$out .= "Kart_Scale".$i.";".$_POST['Kart_Scale'.$i]."\n";
$out .= "Kart_Form".$i.";".$_POST['Kart_Form'.$i]."\n";
$out .= "Kart_Date_Create".$i.";".$_POST['Kart_Date_Create'.$i]."\n";
$out .= "Kart_Date_Update".$i.";".$_POST['Kart_Date_Update'.$i]."\n";
$out .= "kSeries".$i.";".$_POST['kSeries'.$i]."\n";
$out .= "kNumber".$i.";".$_POST['kNumber'.$i]."\n";
$out .= "kDate".$i.";".$_POST['kDate'.$i]."\n";
$out .= "kIssueOrgan".$i.";".$_POST['kIssueOrgan'.$i]."\n";
$out .= "kNumberReg".$i.";".$_POST['kNumberReg'.$i]."\n";
$out .= "kDateReg".$i.";".$_POST['kDateReg'.$i]."\n";
$out .= "kStarted".$i.";".$_POST['kStarted'.$i]."\n";
$out .= "kStopped".$i.";".$_POST['kStopped'.$i]."\n";
$out .= "kRegister".$i.";".$_POST['kRegister'.$i]."\n";
$out .= "kImg_Name".$i.";".$_POST['kImg_Name'.$i]."\n";
$out .= "kURL".$i.";".$_POST['kURL'.$i]."\n";
$out .= "kDesc".$i.";".$_POST['kDesc'.$i]."\n";
$out .= "kIssueOrgan_Code".$i.";".$_POST['kIssueOrgan_Code'.$i]."\n";
}
for($i = 1; $i <= $_POST['numcont']; $i++){
$k = 1;
$out .= "input_methodname".$i.";".$_POST['input_methodname'.$i]."\n";
$out .= "input_formula".$i.";".$_POST['input_formula'.$i]."\n";
$out .= "input_precisionvalue".$i.";".$_POST['input_precisionvalue'.$i]."\n";
for($j = 1; $j <= $_POST['numpoints'.$i]; $j++){
if(!isset($_POST['input_cx'.$i.'_'.$j])){
continue;
}
$out .= "input_number".$i."_".$k.";".$_POST['input_number'.$i.'_'.$j]."\n";
$out .= "input_cx".$i."_".$k.";".$_POST['input_cx'.$i.'_'.$j]."\n";
$out .= "input_cy".$i."_".$k.";".$_POST['input_cy'.$i.'_'.$j]."\n";
$k++;
}
}
$out .= "conclusion;".$_POST['conclusion'];
$fout = fopen($_SESSION['userdir']."/GUOKS_".$dname.".tpo", "w");
fwrite($fout, $out);
fclose($fout);
//------------------------------------------------------------------------
if(isset($_POST['submit1'])){
$file=$_SESSION['userdir']."/GUOKS_".$dname.".tpo";
header("Content-type: application/zip");
header("Content-Disposition: attachment; filename=GUOKS_".$dname.".tpo");
readfile($file);
}
if(isset($_POST['submit'])){
$zip = new ZipArchive();
$zip->open($_SESSION['userdir']."/GUOKS_".$dname.".zip", ZIPARCHIVE::CREATE);
$filecontents = file_get_contents($_SESSION['userdir']."/GUOKS_".$dname.".xml");
$zip->addFromString("GUOKS_".$dname.".xml", $filecontents);
$filecontents = file_get_contents($_SESSION['userdir']."/GUOKS_".$dname.".tpo");
$zip->addFromString("GUOKS_".$dname.".tpo", $filecontents);
$zip->addEmptyDir("Images");
$filecontents = file_get_contents($_SESSION['userdir']."/GUOKS_".$dname."/1 Титульный лист.xlsx");
$filename = iconv('windows-1251', 'cp866', "1 Титульный лист.xlsx");
$zip->addFromString("Images/".$filename, $filecontents);
$filecontents = file_get_contents($_SESSION['userdir']."/GUOKS_".$dname."/2 Содержание.xlsx");
$filename = iconv('windows-1251', 'cp866', "2 Содержание.xlsx");
$zip->addFromString("Images/".$filename, $filecontents);
$filecontents = file_get_contents($_SESSION['userdir']."/GUOKS_".$dname."/3 Исходные данные.xlsx");
$filename = iconv('windows-1251', 'cp866', "3 Исходные данные.xlsx");
$zip->addFromString("Images/".$filename, $filecontents);
$filecontents = file_get_contents($_SESSION['userdir']."/GUOKS_".$dname."/4 Сведения о выполненых измерениях и расчетах.xlsx");
$filename = iconv('windows-1251', 'cp866', "4 Сведения о выполненых измерениях и расчетах.xlsx");
$zip->addFromString("Images/".$filename, $filecontents);
$n = 0;
for($i = 1; $i <= $pc; $i++){
$filecontents = file_get_contents($_SESSION['userdir']."/GUOKS_".$dname."/".(4 + $i)." Описание местоположения здания на земельном участке.xlsx");
$filename = iconv('windows-1251', 'cp866', (4 + $i)." Описание местоположения здания на земельном участке.xlsx");
$zip->addFromString("Images/".$filename, $filecontents);
$n++;
}
$filecontents = file_get_contents($_SESSION['userdir']."/GUOKS_".$dname."/".(5 + $n)." Характеристики здания.xlsx");
$filename = iconv('windows-1251', 'cp866', (5 + $n)." Характеристики здания.xlsx");
$zip->addFromString("Images/".$filename, $filecontents);
if($_POST['conclusion'] != ""){
$filecontents = file_get_contents($_SESSION['userdir']."/GUOKS_".$dname."/".(6 + $n)." Заключение кадастрового инженера.xlsx");
$filename = iconv('windows-1251', 'cp866', (6 + $n)." Заключение кадастрового инженера.xlsx");
$zip->addFromString("Images/".$filename, $filecontents);
}
$zip->close();
/*
$zip = new ZipArchive();
$zip->open($_SESSION['userdir']."/GKUZU_".$GUID.".zip", ZIPARCHIVE::CREATE);
$filecontents = file_get_contents($_SESSION['userdir']."/GKUZU_".$GUID.".xml");
$zip->addFromString("GKUZU_".$GUID.".xml", $filecontents);
$filecontents = file_get_contents($_SESSION['userdir']."/GKUZU_".$GUID.".tpo");
$zip->addFromString("GKUZU_".$GUID.".tpo", $filecontents);
$zip->addEmptyDir("Images");
$zip->close();
*/
//------------------------------
function libxml_display_error($error)
{
$return = "
\n";
switch ($error->level) {
case LIBXML_ERR_WARNING:
$return .= "Warning $error->code: ";
break;
case LIBXML_ERR_ERROR:
$return .= "Error $error->code: ";
break;
case LIBXML_ERR_FATAL:
$return .= "Fatal Error $error->code: ";
break;
}
$return .= trim($error->message);
if ($error->file) {
$return .= " in $error->file";
}
$return .= " on line $error->line\n";
return $return;
}
function libxml_display_errors() {
$errors = libxml_get_errors();
foreach ($errors as $error) {
print libxml_display_error($error);
}
libxml_clear_errors();
}
// Enable user error handling
libxml_use_internal_errors(true);
$xml = new DOMDocument();
$xml->load($_SESSION['userdir']."/GKUZU_".$GUID.".xml");
if(!$xml->schemaValidate('C:\Разработка\doc_V04_STD_MP\V04_STD_MP\STD_MP.xsd')){
print 'При проверке документа возникли ошибки:';
libxml_display_errors();
}else{
$file=$_SESSION['userdir']."/GKUZU_".$GUID.".zip";
$size = filesize($file);
header("Content-type: application/zip");
header("Content-Length: ".$size);
header("Content-Disposition: attachment; filename=GKUZU_".$GUID.".zip");
readfile($file);
}
?>