Создание базы данных экспериментов с плазменным кристаллом

    if (isset($_POST['part_shape_edit'])) $part_shape_edit=$_POST['part_shape_edit']; else $part_shape_edit="";

    if (isset($_POST['part_input_edit'])) $part_input_edit=$_POST['part_input_edit']; else $part_input_edit="";

    if (isset($_POST['part_note_edit'])) $part_note_edit=$_POST['part_note_edit']; else $part_note_edit="";

    if (isset($_POST['who_engineer_edit'])) $who_engineer_edit=$_POST['who_engineer_edit']; else $who_engineer_edit="";

    if (isset($_POST['who_org_edit'])) $who_org_edit=$_POST['who_org_edit']; else $who_org_edit="";

    if (isset($_POST['who_place_edit'])) $who_place_edit=$_POST['who_place_edit']; else $who_place_edit="";

    if (isset($_POST['who_note_edit'])) $who_note_edit=$_POST['who_note_edit']; else $who_note_edit="";

    if (isset($_POST['tube_cathode_type_edit'])) $tube_cathode_type_edit=$_POST['tube_cathode_type_edit']; else $tube_cathode_type_edit="";

    if (isset($_POST['tube_cathode_square_edit'])) $tube_cathode_square_edit=$_POST['tube_cathode_square_edit']; else $tube_cathode_square_edit="";

    if (isset($_POST['tube_anode_square_edit'])) $tube_anode_square_edit=$_POST['tube_anode_square_edit']; else $tube_anode_square_edit="";

    if (isset($_POST['tube_cathode_material_edit'])) $tube_cathode_material_edit=$_POST['tube_cathode_material_edit']; else $tube_cathode_material_edit="";

    if (isset($_POST['tube_anode_material_edit'])) $tube_anode_material_edit=$_POST['tube_anode_material_edit']; else $tube_anode_material_edit="";

    if (isset($_POST['tube_electrode_distance_edit'])) $tube_electrode_distance_edit=$_POST['tube_electrode_distance_edit']; else $tube_electrode_distance_edit="";

    if (isset($_POST['tube_diameter_edit'])) $tube_diameter_edit=$_POST['tube_diameter_edit']; else $tube_diameter_edit="";

    if (isset($_POST['tube_note_edit'])) $tube_note_edit=$_POST['tube_note_edit']; else $tube_note_edit="";

    if (isset($_POST['power_shape_edit'])) $power_shape_edit=$_POST['power_shape_edit']; else $power_shape_edit="";

    if (isset($_POST['power_freq_edit'])) $power_freq_edit=$_POST['power_freq_edit']; else $power_freq_edit="";

    if (isset($_POST['power_voltage_edit'])) $power_voltage_edit=$_POST['power_voltage_edit']; else $power_voltage_edit="";

    if (isset($_POST['power_current_edit'])) $power_current_edit=$_POST['power_current_edit']; else $power_current_edit="";

    if (isset($_POST['power_note_edit'])) $power_note_edit=$_POST['power_note_edit']; else $power_note_edit="";

    if (isset($_POST['userfile'])) $userfile=$_POST['userfile']; else $userfile="";

    if (isset($_POST['exp_date_edit_Y'])) $exp_date_edit_Y=$_POST['exp_date_edit_Y']; else $exp_date_edit_Y="";

    if (isset($_POST['exp_date_edit_M'])) $exp_date_edit_M=$_POST['exp_date_edit_M']; else $exp_date_edit_M="";

    if (isset($_POST['exp_date_edit_D'])) $exp_date_edit_D=$_POST['exp_date_edit_D']; else $exp_date_edit_D="";

    if (isset($_POST['exp_note_edit'])) $exp_note_edit=$_POST['exp_note_edit']; else $exp_note_edit="";

    if (isset($_POST['material_edit'])) $material_edit=$_POST['material_edit']; else $material_edit="";

    if (isset($_POST['n'])) $n=$_POST['n']; else $n="";

    if (isset($_POST['action_button'])) $action_button=$_POST['action_button']; else $action_button="";

    if (isset($_POST['new_part_input_type'])) $new_part_input_type=$_POST['new_part_input_type']; else $new_part_input_type="";

    if (isset($_POST['new_cathode_material_type'])) $new_cathode_material_type=$_POST['new_cathode_material_type']; else $new_cathode_material_type="";

    if (isset($_POST['new_anode_material_type'])) $new_anode_material_type=$_POST['new_anode_material_type']; else $new_anode_material_type="";

    if (isset($_POST['new_power_shape_type'])) $new_power_shape_type=$_POST['new_power_shape_type']; else $new_power_shape_type="";

    if (isset($_POST['new_part_material_type'])) $new_part_material_type=$_POST['new_part_material_type']; else $new_part_material_type="";

    if (isset($_POST['userfile'])) $userfile=$_POST['userfile']; else $userfile=array();

    if ($exp_id_edit) {

    ////////////////////////////////////////////////////////////////////////////////////

    // Внесение изменений  в существующую запись

$result=mquery("select * from exp where exp_id='$exp_id_edit'");

$row=mysql_fetch_assoc($result);

mysql_free_result($result);

mquery("update results set results_note='$results_note_edit' where results_id='$row[exp_results]'");

umask(7);

$record_name=array("image", "behaviour", "control_static", "control_dynamic", "measurement", "evaluation");

$user_dir="files/".$exp_id_edit;

if (!is_dir($user_dir)) mkdir($user_dir);

for($i=$l=0; $i<sizeof($userfile); $i++) {

    $result_file=mquery("select results_$record_name[$i] from results where results_id='$row[exp_results]'");

    if (mysql_num_rows($result_file)) {

$delete_file=mysql_fetch_row($result_file);

mysql_free_result($result_file);

if ($delete_file[0]!="") {

    switch ($results_action[$i]) {

    case "1":

if ($userfile[$i]=="") continue 2;

unlink($user_dir."/".$delete_file[0]);

mquery("update results set results_$record_name[$i]='' where results_id='$row[exp_results]'");

break;

    case "2":

unlink($user_dir."/".$delete_file[0]);

mquery("update results set results_$record_name[$i]='' where results_id='$row[exp_results]'");

continue 2;

break;

    default: continue 2; break;

    }

}

    }

    if ($userfile[$i]=="") continue;

    $filename=$record_name[$i]."(".$row[exp_id].")".strrchr($userfile_name[$i], ".");

    $path_to_userfile=$user_dir."/".$filename;

    copy($userfile[$i], $path_to_userfile);

    $query_r[$l]="results_".$record_name[$i]."='$filename'";

    $l++;

}

if (count($query_r)) {

    $query=implode(",", $query_r);

    mquery("update results set $query where results_id='$row[exp_results]'");

}

mquery("update part set part_size_avg='$part_size_avg_edit', part_shape='$part_shape_edit', part_input='$part_input_edit', part_note='$part_note_edit' where part_id='$row[exp_part]'");

mquery("update who set who_engineer='$who_engineer_edit', who_org='$who_org_edit', who_place='$who_place_edit', who_note='$who_note_edit' where who_id='$row[exp_who]'");

mquery("update tube set tube_cathode_type='$tube_cathode_type_edit', tube_cathode_square='$tube_cathode_square_edit', tube_anode_square='$tube_anode_square_edit', tube_cathode_material='$tube_cathode_material_edit', tube_anode_material='$tube_anode_material_edit', tube_electrode_distance='$tube_electrode_distance_edit', tube_diameter='$tube_diameter_edit', tube_note='$tube_note_edit' where tube_id='$row[exp_tube]'");

mquery("update power set power_shape='$power_shape_edit', power_freq='$power_freq_edit', power_voltage='$power_voltage_edit', power_current='$power_current_edit', power_note='$power_note_edit' where power_id='$row[exp_power]'");

mquery("update exp set exp_date='$exp_date_edit_Y-$exp_date_edit_M-$exp_date_edit_D', exp_note='$exp_note_edit' where exp_id='$row[exp_id]'");

$welcome="Внесение изменений прошло успешно.";

    } else {

    ////////////////////////////////////////////////////////////////////////////////////

    // Добавление новой записи

if ($action_button=="Добавление записи (отчет)") {

    if ($part_input_edit=="###new_type_to_add") {

mquery("insert into part_input set part_input_type='$new_part_input_type'");

$row=mysql_fetch_assoc(mquery("select max(part_input_id) as t_new from part_input"));

$part_input_edit=$row['t_new'];

    }

    if ($tube_cathode_material_edit=="###new_type_to_add") {

mquery("insert into tube_electrode_material set electrode_material_type='$new_cathode_material_type'");

$row=mysql_fetch_assoc(mquery("select max(electrode_material_id) as t_new from tube_electrode_material"));

$tube_cathode_material_edit=$row['t_new'];

    }

    if ($tube_anode_material_edit=="###new_type_to_add") {

mquery("insert into tube_electrode_material set electrode_material_type='$new_anode_material_type'");

$row=mysql_fetch_assoc(mquery("select max(electrode_material_id) as t_new from tube_electrode_material"));

$tube_anode_material_edit=$row['t_new'];

    }

    if ($power_shape_edit=="###new_type_to_add") {

mquery("insert into power_shape set power_shape_type='$new_power_shape_type'");

$row=mysql_fetch_assoc(mquery("select max(power_shape_id) as t_new from power_shape"));

$power_shape_edit=$row['t_new'];

    }

}

 

mquery("insert into results set results_note='$results_note_edit'");

mquery("insert into part set part_size_avg='$part_size_avg_edit', part_shape='$part_shape_edit', part_input='$part_input_edit', part_note='$part_note_edit'");

mquery("insert into who set who_engineer='$who_engineer_edit', who_org='$who_org_edit', who_place='$who_place_edit', who_note='$who_note_edit'");

mquery("insert into tube set tube_cathode_type='$tube_cathode_type_edit', tube_cathode_square='$tube_cathode_square_edit', tube_anode_square='$tube_anode_square_edit', tube_cathode_material='$tube_cathode_material_edit', tube_anode_material='$tube_anode_material_edit', tube_electrode_distance='$tube_electrode_distance_edit', tube_diameter='$tube_diameter_edit', tube_note='$tube_note_edit'");

mquery("insert into power set power_shape='$power_shape_edit', power_freq='$power_freq_edit', power_voltage='$power_voltage_edit', power_current='$power_current_edit', power_note='$power_note_edit'");

 

$result=mquery("select max(part_id) as part_new, max(who_id) as who_new, max(tube_id) as tube_new, max(power_id) as power_new, max(results_id) as results_new from part, who, tube, power, results");

$row=mysql_fetch_assoc($result);

mysql_free_result($result);

 

$len="";

umask(7);

for ($i=0; $i<sizeof($userfile); $i++) $len.=$userfile[$i];

if ($len) {

    $record_name=array("image", "behaviour", "control_static", "control_dynamic", "measurement", "evaluation");

    $user_dir="files/".$exp_id_edit;

    if (!is_dir($user_dir)) mkdir($user_dir);

    for($i=$l=0; $i<sizeof($userfile); $i++) {

if ($userfile[$i]=="") continue;

$filename=$record_name[$i]."(".$row[exp_id].")".strrchr($userfile_name[$i], ".");

$path_to_userfile=$user_dir."/".$filename;

copy($userfile[$i], $path_to_userfile);

$query_r[$l]="results_".$record_name[$i]."='$filename'";

$l++;

    }

    if (count($query_r)) {

$query=implode(",", $query_r);

mquery("update results set $query where results_id='$row[results_new]'");

    }

}

 

$exp_part_edit=$row['part_new'];

$exp_who_edit=$row['who_new'];

$exp_tube_edit=$row['tube_new'];

$exp_power_edit=$row['power_new'];

$exp_results_edit=$row['results_new'];

 

mquery("insert into exp set exp_date='$exp_date_edit_Y-$exp_date_edit_M-$exp_date_edit_D', exp_part='$exp_part_edit', exp_who='$exp_who_edit', exp_tube='$exp_tube_edit', exp_power='$exp_power_edit', exp_results='$exp_results_edit', exp_note='$exp_note_edit'");

$result=mquery("select max(exp_id) as exp_new from exp");

$row=mysql_fetch_assoc($result);

mysql_free_result($result);

 

$result=mquery("select * from exp where exp_id='$row[exp_new]'");

$row=mysql_fetch_assoc($result);

mysql_free_result($result);

 

$welcome="Добавление новой записи прошло успешно.";

    }

   

    mquery("delete from part_material where part_material_id='$row[exp_part]'");

   

    if ($material_edit) {

if ($action_button=="Добавление записи (отчет)") {

    $p=0;

    for ($i=0; $i<sizeof($material_edit); $i++) {

if ($material_edit[$i]=="###new_type_to_add") {

    mquery("insert into part_material_type set part_material_type_type='".$new_part_material_type[$p++]."'");

    $row_mtr=mysql_fetch_assoc(mquery("select max(part_material_type_id) as t_new from part_material_type"));

    $material_edit[$i]=$row_mtr['t_new'];

}

    }

}

for ($i=0; $i<sizeof($material_edit); $i++) if ($material_edit[$i]) mquery("insert into part_material set part_material_id='$row[exp_part]', part_material_type='$material_edit[$i]'");

    } else mquery("insert into part_material set part_material_id='$row[exp_part]', part_material_type=1");

   

    mquery("delete from medium where medium_id='$row[exp_id]'");

   

    if ($n) {

$p=0;

for ($i=0; $i<$n; $i++) {

    if (!isset($gas_edit[0][$i])) continue;

    if ($gas_edit[0][$i]=="###new_type_to_add" and $action_button=="Добавление записи (отчет)") {

mquery("insert into medium_gas set medium_gas_type='".$new_gas_type[$p++]."'");

$row_gas=mysql_fetch_assoc(mquery("select max(medium_gas_id) as t_new from medium_gas"));

$gas_edit[0][$i]=$row_gas[t_new];

    }

    $query_gas="insert into medium set medium_id='$row[exp_id]', medium_gas='".$gas_edit[0][$i]."', medium_pressure='".$gas_edit[1][$i]."', medium_percentage='".$gas_edit[2][$i]."'";

    mquery($query_gas);

}

    } else {

mquery("insert into medium set medium_id='$row[exp_id]', medium_gas=1");

    }

   

    return "

<CENTER>$links</CENTER><BR>

<table align='center' cellspacing=1 cellpadding=0 class='mainheader'>

<tr class='mainheader'><td><img src='img/head.gif' alt='' width='8' height='8'> $action_button<br></td></tr>

<tr class='int'><td>$welcome</td></tr>

</table>

<BR><CENTER>$links</CENTER>

    ";

}

 

function DeleteExp($eid) {

    $result=mquery("SELECT * FROM exp WHERE exp_id='$eid'");

    $row=mysql_fetch_assoc($result);

    mysql_free_result($result);

   

    $result=mquery("SELECT * FROM results WHERE results_id='$row[exp_results]'");

    $row_r=mysql_fetch_assoc($result);

    mysql_free_result($result);

   

    $user_dir="files/".$row['exp_id']."/";

    if ($row_r['results_image'])   unlink($user_dir.$row_r['results_image']);

    if ($row_r['results_behaviour'])   unlink($user_dir.$row_r['results_behaviour']);

    if ($row_r['results_control_static'])  unlink($user_dir.$row_r['results_control_static']);

    if ($row_r['results_control_dynamic'])  unlink($user_dir.$row_r['results_control_dynamic']);

    if ($row_r['results_measurement'])   unlink($user_dir.$row_r['results_measurement']);

    if ($row_r['results_evaluation'])   unlink($user_dir.$row_r['results_evaluation']);

    if (is_dir($user_dir))    rmdir($user_dir);

   

    mquery("delete from part where part_id='$row[exp_part]'");

    mquery("delete from who where who_id='$row[exp_who]'");

    mquery("delete from tube where tube_id='$row[exp_tube]'");

    mquery("delete from power where power_id='$row[exp_power]'");

    mquery("delete from results where results_id='$row[exp_results]'");

    mquery("delete from part_material where part_material_id='$row[exp_part]'");

    mquery("delete from medium where medium_id='$row[exp_id]'");

    mquery("delete from exp where exp_id='$row[exp_id]'");

   

    return "

<table align='center' cellspacing=1 cellpadding=0 class='mainheader'>

<tr class='mainheader'><td><img src='img/head.gif' alt='' width='8' height='8'> Удаление записи</td><tr>

<tr class='header'><td>Удаление записи прошло успешно.</td></tr>

</table>

<center><br><a href='.?t=exp'>База данных</a></center>

    ";

}

 

function GetExpUID($eid) {

    $result=mquery("SELECT uid FROM exp WHERE eid='$eid'");

    if (!mysql_num_rows($result)) {

mysql_free_result($result);

return false;

    }

    $row=mysql_fetch_assoc($result);

    mysql_free_result($result);

    return $row['uid'];

}

 

function ExpExists($eid) {

    if (mysql_num_rows(mquery("SELECT exp_id FROM exp WHERE exp_id='$eid'"))) return true;

    else return false;

}

 

function GetRules() {

    $rules['show']=array('title'=>"Просмотр", 'space'=>array('deny'=>"Запрещен", 'allow'=>"Разрешен"));

    $rules['add']=array('title'=>"Добавление", 'space'=>array('deny'=>"Запрещено", 'allow'=>"Разрешено"));

    $rules['edit']=array('title'=>"Редактировние", 'space'=>array('deny'=>"Запрещено", 'allow'=>"Разрешено"));

    $rules['delete']=array('title'=>"Удаление", 'space'=>array('deny'=>"Запрещено", 'allow'=>"Разрешено"));

    return $rules;

}

 

function GetCreateTable() {

    return array(

'cathode_type'=>array(

    'create'=>"CREATE TABLE cathode_type (cathode_id int(10) unsigned NOT NULL auto_increment, cathode_type varchar(255) default NULL, PRIMARY KEY  (cathode_id)) TYPE=MyISAM",

    'insert'=>array("INSERT INTO cathode_type VALUES (1,'Не указан')")

),

'exp'=>array(

    'create'=>"CREATE TABLE exp (exp_id int(10) unsigned NOT NULL auto_increment, exp_date date default NULL, exp_who int(10) unsigned default NULL, exp_part int(10) unsigned default NULL, exp_tube int(10) unsigned default NULL, exp_power int(10) unsigned default NULL, exp_results int(10) unsigned default NULL, exp_note text, PRIMARY KEY  (exp_id)) TYPE=MyISAM",