Data validation multiple criteria - Ticketing system

vistit this in browser,press f12 view javascript

report... 

data initate

http://e.anyoupin.cn/EData/?s=Activity 

video 

https://v.douyin.com/AD1Bpsd

//select * from Activity_Planner;
cli_add_php~～
$real_table="Activity_Planner";
insert_replace($real_table);
$sql="select '<u>'||rowid||'</u>' rowA,* from $real_table order by rowid;";
$result=$db->query($sql)->fetchAll();
\multiquery\display_table($sql);?>
<div><b> 
Data_validation_multiple_criteria</b> <span>新增记录</span></div>
<form method="post" action="?p=Tools/DisTbl&g=sql"   autocomplete="off" >
<table id="oneline"><tbody><tr><td>rowid</td><td><input type="text" name="rowid" value=""></td></tr><tr><td>Date</td><td><input type="date" name="Date" value="2023-03-21"></td></tr>
<tr><td>Engineer_assign</td><td>
<?php
$name="Engineer_assign";
$sqlDatalist="select a.Engineer_assign from Engineer_assign a left join $real_table b using(Engineer_assign) where b.status is null or b.Status='Completed'";
echo_datalist($name,$sqlDatalist);
?>
</td></tr>
<tr><td>Task_description</td><td><input type="text" name="Task_description" value="aa" required="">
 </td></tr>
<tr><td>Status</td><td>
<?php
$name="Status";
$sqlDatalist="select Status from Status_of_Work";
echo_datalist($name,$sqlDatalist);
?>
</td></tr>
<tr><td>Other_observation</td><td><input type="text" name="Other_observation" value="bb" required="">
 </td></tr>
</tbody></table><input type="submit" id="submitForm" value="保存" style="height:2em">
</form>
～;
cli_add_script~～
const table = document.querySelector(".main_tbl");
for (let i = 0; i < table.rows.length; i++) {
  const cell = table.rows[i].cells[0];
const row=table.rows[i]
  cell.addEventListener("click", function() {
	let inputs=document.querySelectorAll('form input')
	for(let col=0;col<(inputs.length-1);col++){
inputs[col].value=row.cells[col].innerText
	
	}
  });
}
～;