本文整理汇总了PHP中Operator::createOperatorList方法的典型用法代码示例。如果您正苦于以下问题：PHP Operator::createOperatorList方法的具体用法？PHP Operator::createOperatorList怎么用？PHP Operator::createOperatorList使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Operator的用法示例。
在下文中一共展示了Operator::createOperatorList方法的8个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: showMeetingUI
function showMeetingUI()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
$operator = new Operator();
$operator->createOperatorList();
if ($this->meetingid != '') {
$q = "SELECT *,DATE_FORMAT(Meeting_Date,'%d-%m-%Y') as mdt,Participants FROM Meeting\n\tWHERE Meeting_ID={$this->meetingid}";
if (!($res = $cxn->query($q))) {
exit("error (showMeetingUI): {$cxn->error}");
}
$n = $res->num_rows;
if ($n > 0) {
$r = mysqli_fetch_assoc($res);
$this->conductedby = $r['Conductedby'];
$this->meetingdatedb = $r['Meeting_Date'];
$this->participants = $r['Participants'];
$this->meetingdatedb = $r['Meeting_Date'];
$this->meetingdate = $r['mdt'];
$this->agenda = $r['Agenda'];
$this->participants = $r['Participants'];
$qp = "SELECT * FROM Meeting_Points WHERE Meeting_ID={$this->meetingid}";
if (!($resp = $cxn->query($qp))) {
exit("error (showMeetingUI2) {$qp}: {$cxn->error}");
}
$i = 0;
while ($rr = mysqli_fetch_assoc($resp)) {
$this->pointsdiscussed[$i] = $rr['Point_Discussed'];
$this->meetingpointid[$i] = $rr['Meeting_Point_ID'];
$i++;
}
}
}
echo '<fieldset><legend>Meeting Details</legend>';
$sel = new selectlist("Conductedby", $operator->getOperatorList(), 'Meeting Conducted By', 'Operator_ID', 'Operator_Name', 'class="required"', $this->conductedby, '1');
echo '<p><label>Meeting Date</label><input id="meetingdate" name="meetingdate" class="required" value="' . $this->meetingdate . '"><input id="meetingdatedb" name="meetingdatedb" type="hidden" value="' . $this->meetingdatedb . '"></p>';
echo '<p><label>Meeting Agenda</label><textarea id="agenda" name="agenda" cols="45" rows="5" class="required">' . $this->agenda . '</textarea></p>';
echo '<p><label>Meeting Participants</label></p>';
$operator->createOperatorGrid($this->participants);
echo '</fieldset>';
echo '<table id="points" width="100%" class="u"><tr><th align="center">Points Discussed</th><th>';
echo '<th><input type="button" id="addpoint" value="Add Row"></th></tr>';
if (isset($this->meetingpointid)) {
$i = 0;
$j = count($this->pointsdiscussed);
while ($i < $j) {
echo '<tr><td colspan="2"><textarea id="pointsdiscussed[' . $i . ']" name="pointsdiscussed[' . $i . ']" rows="3" cols="40" class="required">' . $this->pointsdiscussed[$i] . '</textarea></td>
<input type="hidden" id="meetingpointid[' . $i . ']" name="meetingpointid[' . $i . ']" value="' . $this->meetingpointid[$i] . '"></tr>';
$i++;
}
} else {
echo '<tr><td colspan="2"><textarea id="pointsdiscussed[0]" name="pointsdiscussed[0]" rows="3" cols="40" class="required"></textarea></td></tr>';
}
echo '</table>';
}示例2: selectlist
$id = 'Drawing_ID';
}
$sel = new selectlist($id, $part->getPartList(), 'Select Part No', 'Drawing_ID', 'name', $req, '');
break;
case 'operator':
$operator = new Operator();
if (isset($_GET['insp'])) {
$operator->setInsp();
}
if (isset($_GET['class'])) {
$class = "class=required";
} else {
$class = '';
}
if (isset($_GET['method'])) {
$operator->createOperatorList();
if ($_GET['method'] == 'grid') {
$operator->createOperatorGrid();
}
} else {
$operator->createOperatorList();
$sel = new selectlist("Operator_ID", $operator->getOperatorList(), 'Select Name', 'Operator_ID', 'Operator_Name', $class, '', '1');
}
break;
case 'operation':
$ope = new Operation();
if (isset($_GET['req'])) {
$req = 'class=required';
} else {
$req = '';
}示例3: showNCUI
function showNCUI()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
$ncd = $ncddb = $stage = $quantity = $pd = $ef = $ca = $tm = $fd = $tddb = $fddb = $nctypeid = $ncno = $cont = '';
if ($this->nonconformanceid != '') {
$q = "SELECT *,DATE_FORMAT(NC_Date,'%d-%m-%Y') as nd,DATE_FORMAT(Finished_Date,'%d-%m-%Y') as fd FROM NonConformance \n\t\tWHERE NonConformance_ID={$this->nonconformanceid}";
if (!($res = $cxn->query($q))) {
exit("error : {$cxn->error}");
}
$row = mysqli_fetch_assoc($res);
$stage = $row['Stage'];
$quantity = $row['NC_Qty'];
$ncddb = $row['NC_Date'];
$ncd = $row['nd'];
$pd = $row['Problem_Description'];
$ef = $row['Effectiveness'];
$ca = $row['Corr_Action'];
$fd = $row['fd'];
$fddb = $row['Finished_Date'];
$nctypeid = $row['NC_Type_ID'];
$ncno = $row['NC_NO'];
$cont = $row['Containment'];
$corr = $row['Correction'];
$qwhy = "SELECT * FROM NC_Root_Cause WHERE NonConformance_ID={$this->nonconformanceid} ORDER BY NC_Root_Cause_ID ASC";
if (!($resw = $cxn->query($qwhy))) {
exit("error : {$cxn->error}");
}
$i = 0;
while ($r = mysqli_fetch_assoc($resw)) {
$why[$i] = $r['Why'];
$reason[$i] = $r['Reason'];
$ncrcid[$i] = $r['NC_Root_Cause_ID'];
$i++;
}
$qop = "SELECT *,DATE_FORMAT(Target_Date,'%d-%m-%Y') as td FROM NC_Team_Members WHERE NonConformance_ID={$this->nonconformanceid}";
if (!($resqop = $cxn->query($qop))) {
exit("error : {$cxn->error}");
}
$tm = $resqop->num_rows;
}
$anynct = new Anylist();
$anynct->createList('NC_Type');
echo <<<_END
<fieldset><legend>Non Conformance Details</legend>
<p><label>NC Date</label><input id="ncd" name="ncd" class="required" value="{$ncd}"><input type="hidden" id="ncddb" name="ncddb" value="{$ncddb}"></p>
<p><label>NC Number</label><input id="ncnumber" name="ncnumber" class="required" value="{$ncno}"></p>
<p><label>NC Stage</label><input id="stage" name="stage" class="required" value="{$stage}"></p>
<p><label>NC Qty</label><input id="quantity" name="quantity" class="required number" value="{$quantity}"></p>
_END;
$sel = new selectlist('NC_Type_ID', $anynct->anylist, 'Select NC Type', 'NC_Type_ID', 'NC_Type', 'class="required"', $nctypeid, '1');
echo <<<_END
<p><label>Problem Description</label><textarea id="problemdescription" name="problemdescription" class="required" rows="5" cols="40">{$pd}</textarea></p>
<p><label>Containment Action</label><textarea id="containment" name="containment" class="required" rows="5" cols="40">{$cont}</textarea></p>
<p><label>Correction</label><textarea id="correction" name="correction" class="required" rows="5" cols="40">{$corr}</textarea></p>
<p><label>Root Cause Analysis</label><input type="button" id="rcbutton" value="Add Row"></p>
<table id="rootcause" width="100%" class="u"><tr><th align="center">Why</th><th align="center">Reason</th></tr>
_END;
if (isset($why)) {
$i = 0;
$j = count($why);
while ($i < $j) {
echo '<tr><td><input type="hidden" id="ncrcid[' . $i . ']" name="ncrcid[' . $i . ']" value="' . $ncrcid[$i] . '"><textarea rows="3" cols="35" id="why[' . $i . ']" name="why[' . $i . ']" class="required">' . $why[$i] . '</textarea></td>
<td><textarea rows="3" cols="35" id="reason[' . $i . ']" name="reason[' . $i . ']" class="required">' . $reason[$i] . '</textarea></td></tr>';
$i++;
}
} else {
echo <<<_END
<tr><td><textarea id="why[0]" name="why[0]" rows="3" cols="35" class="required"></textarea></td><td><textarea id="reason[0]" rows="3" cols="35" name="reason[0]" class="required"></textarea></td></tr>
<tr><td><textarea id="why[1]" name="why[1]" rows="3" cols="35" class="required"></textarea></td><td><textarea id="reason[1]" rows="3" cols="35" name="reason[1]" class="required"></textarea></td></tr>
<tr><td><textarea id="why[2]" name="why[2]" rows="3" cols="35" class="required"></textarea></td><td><textarea id="reason[2]" rows="3" cols="35" name="reason[2]" class="required"></textarea></td></tr>
_END;
}
echo <<<_END
</table>
<p><label>Corrective Action</label><textarea id="correctiveaction" name="correctiveaction" class="required" rows="5" cols="40">{$ca}</textarea></p>
<p><label>Preventive Action Team Members</label><input type="button" id="addmember" value="Add Team Member"></p>
<table id="tm" width="100%" class="u"><tr><th align="center">Name</th><th align="center">Department</th><th align="center">Work Desc.</th><th align="center">Target Date</th><th align="center">Remarks</th></tr>
_END;
$ope = new Operator();
$ope->createOperatorList();
$any = new Anylist();
$any->createList('Department');
if ($tm > 0) {
$i = 0;
while ($rop = mysqli_fetch_assoc($resqop)) {
echo '<tr><td><input type="hidden" id="nctmid[' . $i . ']" name="nctmid[' . $i . ']" value="' . $rop['NC_Team_Member_ID'] . '">';
$sel = new selectlist("teammember[" . $i . "]", $ope->getOperatorList(), 'Select Member Name', 'Operator_ID', 'Operator_Name', 'class="required"', $rop['Team_Member_ID'], '');
echo '</td><td>';
$sel = new selectlist("department[" . $i . "]", $any->anylist, 'Select Department', 'Department', 'Department', 'class="required"', $rop['Department'], '');
// <input id="department['.$i.']" name="department['.$i.']" class="required" value="'.$rop['Department'].'">
echo '</td><td><input id="work[' . $i . ']" name="work[' . $i . ']" class="required" value="' . $rop['Work'] . '" size="75"></td>';
echo '<td><input id="tdate[' . $i . ']" name="tdate[' . $i . ']" class="required" value="' . $rop['td'] . '"></td><td><input id="memberremarks[' . $i . ']" name="memberremarks[' . $i . ']" value="' . $rop['Remarks'] . '"></td>';
echo '<input type="hidden" id="tdatedb[' . $i . ']" name="tdatedb[' . $i . ']" value="' . $rop['Target_Date'] . '"></tr>';
$i++;
}
} else {
echo '<tr><td>';
$sel = new selectlist("teammember[0]", $ope->getOperatorList(), 'Select Member Name', 'Operator_ID', 'Operator_Name', 'class="required"', '', '');
//.........这里部分代码省略.........
示例4: Operator
$message = '<p>' . $upload->upload_success() . '</p>';
print "{$message}";
} else {
$message = $upload->show_errors();
print "{$message}";
}
}
}
} else {
if (isset($_GET['ui'])) {
$nc->showNCUI();
}
if (isset($_GET['newtmrow'])) {
$id = $_GET['id'];
$ope = new Operator();
$ope->createOperatorList();
$any = new Anylist();
$any->createList('Department');
echo '<tr><td>';
$sel = new selectlist("teammember[" . $id . "]", $ope->getOperatorList(), 'Select Member Name', 'Operator_ID', 'Operator_Name', 'class="required"', '', '');
echo '</td><td>';
$sel = new selectlist("department[" . $id . "]", $any->anylist, 'Select Department', 'Department', 'Department', 'class="required"', '', '');
echo '</td><td><input id="work[' . $id . ']" name="work[' . $id . ']" class="required"></td>';
echo '<td><input id="tdate[' . $id . ']" name="tdate[' . $id . ']" class="required"></td><td><input id="memberremarks[' . $id . ']" name="memberremarks[' . $id . ']"></td>';
echo '<input type="hidden" id="tdatedb[' . $id . ']" name="tdatedb[' . $id . ']"></tr>';
}
if (isset($_GET['nclid'])) {
$nc->setValue('nonconformanceid', $_GET['nclid']);
$nc->showNCUI();
}
if (isset($_GET['sgid'])) {示例5: showTrainingPlanUI
function showTrainingPlanUI()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
$operator = new Operator();
$operator->createOperatorList();
$qu = new Question();
if ($this->planid != '') {
$q = "SELECT *,DATE_FORMAT(Training_Start_Date,'%d-%m-%Y') as sdt,DATE_FORMAT(Training_End_Date,'%d-%m-%Y') as edt,\n\t(SELECT GROUP_CONCAT(Trainee_ID) FROM Plan_Trainee as pt WHERE pt.Training_Plan_ID={$this->planid}) as trainees FROM Training_Plan as tp \n\tWHERE Training_Plan_ID={$this->planid}";
if (!($res = $cxn->query($q))) {
exit("error (showTrainingPlanUI): {$cxn->error}");
}
$n = $res->num_rows;
if ($n > 0) {
$r = mysqli_fetch_assoc($res);
$this->trainer = $r['Trainer_Name'];
$this->startdatedb = $r['Training_Start_Date'];
$this->startdate = $r['sdt'];
$this->enddatedb = $r['Training_End_Date'];
$this->enddate = $r['edt'];
$this->trainees = $r['trainees'];
$this->plandesc = $r['Training_Desc'];
$this->questionid = $r['Question_ID'];
$this->evaluaterid = $r['Evaluater_ID'];
}
}
echo '<fieldset><legend>Training Details</legend>';
echo '<p><label>Trainer Name</label><input id="trainer" name="trainer" class="required" value="' . $this->trainer . '"></p>';
$sel = new selectlist("Evaluater_ID", $operator->getOperatorList(), 'Select Name', 'Operator_ID', 'Operator_Name', 'class="required"', $this->evaluaterid, '1');
echo '<p><label>Training Start Date</label><input id="startdate" name="startdate" class="required" value="' . $this->startdate . '"><input id="startdatedb" name="startdatedb" type="hidden" value="' . $this->startdatedb . '"></p>';
echo '<p><label>Training End Date</label><input id="enddate" name="enddate" class="required" value="' . $this->enddate . '"><input id="enddatedb" name="enddatedb" type="hidden" value="' . $this->enddatedb . '"></p>';
echo '<p><label>Training Description</label><textarea id="plandesc" name="plandesc" cols="45" rows="5" class="required">' . $this->plandesc . '</textarea></p>';
echo '</fieldset>';
echo '<fieldset><legend>Select Trainees</legend>';
$operator->createOperatorGrid($this->trainees);
echo '</fieldset>';
}示例6: showActivityUI
//.........这里部分代码省略.........
print "Error You Can Edit only Your Log!!";
exit;
}
if (in_array($this->activityid, $this->production)) {
$qe = "SELECT cust.Customer_ID,Machine_ID,comp.Drawing_ID,ope.Operation_ID,Batch_ID,Operator_ID,prod.Program_NO,Quantity,Remarks,actl.Activity_ID,\n\t\t\t\t\t\tDATE_FORMAT(Start_Date_Time,'%d-%m-%Y %h:%i%p') as sdte,Start_Date_Time,DATE_FORMAT(End_Date_Time,'%d-%m-%Y %h:%i%p') as edte,End_Date_Time FROM ActivityLog as actl \n\t\t\t\t\t\tINNER JOIN Production AS prod ON prod.Activity_Log_ID=actl.Activity_Log_ID\n\t\t\t\t\t\tINNER JOIN Operation as ope ON ope.Operation_ID=prod.Operation_ID\n\t\t\t\t\t\tINNER JOIN Component as comp ON comp.Drawing_ID=ope.Drawing_ID\n\t\t\t\t\t\tINNER JOIN Customer as cust ON cust.Customer_ID=comp.Customer_ID WHERE actl.Activity_Log_ID={$this->activitylogid}";
//print("<br>$qe");
if (!($rese = $cxn->query($qe))) {
echo "error :", $cxn->error;
exit;
}
$rowe = mysqli_fetch_assoc($rese);
$ac = new Activity();
$ac->setActivityID($rowe['Activity_ID']);
$ac->createActivityList();
$sel = new selectlist('Activity_ID', $ac->getActivityList(), 'Select Activity', 'Activity_ID', 'Activity_Name', 'class="required"', $rowe['Activity_ID'], '1');
$mc = new Machine();
$mc->createMachineList();
$sel = new selectlist('Machine_ID', $mc->getMachineList(), 'Select Machine', 'Machine_ID', 'mnslno', 'class="required"', $rowe['Machine_ID'], '1');
$cust = new Customer();
$cust->createCustomerList();
$sel = new selectlist('Customer_ID', $cust->getCustomerList(), 'Select Customer', 'Customer_ID', 'Customer_Name_Short', 'class="required"', $rowe['Customer_ID'], '1');
$part = new Part();
$part->createPartList($rowe['Customer_ID']);
$req = 'class=required';
echo '<div id="drawe">';
$selc = new selectlist('Drawing_ID', $part->getPartList(), 'Select Drawing', 'Drawing_ID', 'name', 'class="required"', $rowe['Drawing_ID'], '1');
echo '</div>';
$ope = new Operation();
$ope->createOperationList($rowe['Drawing_ID']);
echo '<div id="operatione">';
$sel = new selectlist('Operation_ID', $ope->getOperationList(), 'Select Operation', 'Operation_ID', 'Operation_Desc', 'class="required"', $rowe['Operation_ID'], '1');
echo '</div>';
$operator = new Operator();
$operator->createOperatorList();
$sel = new selectlist("Operator_ID", $operator->getOperatorList(), 'Select Name', 'Operator_ID', 'Operator_Name', 'class="required"', $rowe['Operator_ID'], '1');
$bn = new Batch();
$bn->setPartID($rowe['Drawing_ID']);
$bn->createBatchList();
echo '<div id="batche">';
$sel = new selectlist('Batch_ID', $bn->getBatchList(), 'Select Batch', 'Batch_ID', 'Mfg_Batch_NO', 'class="required"', $rowe['Batch_ID'], '1');
echo '</div>';
echo <<<_END
\t\t\t\t\t\t<fieldset>
\t\t\t\t\t\t<legend>Activity Details</legend>
\t\t \t\t\t\t<p>
\t\t \t\t\t\t<label>Start Date and Time</label>
\t\t \t\t\t\t<input id="sdt" name="sdt" rclass="equired" value="{$rowe['sdte']}"/>
\t\t \t\t\t\t<input id="sdtdb" name="sdtdb" type="hidden" value="{$rowe['Start_Date_Time']}">
\t\t \t\t\t\t</p>
\t\t \t\t\t\t<p>
\t\t \t\t\t\t<label>End Date and Time</label>
\t\t \t\t\t\t<input id="edt" name="edt" class="required" value="{$rowe['edte']}"/>
\t\t \t\t\t\t<input id="edtdb" name="edtdb" type="hidden" value="{$rowe['End_Date_Time']}">
\t\t \t\t\t\t</p>
\t\t \t\t\t\t<p>
\t\t \t\t\t\t<label>Program No</label>
\t\t \t\t\t\t<input id="programno" name="programno" class="required" value="{$rowe['Program_NO']}"/>
\t\t \t\t\t\t</p>
\t\t \t\t\t\t<p>
\t\t \t\t\t\t<label>Quantity</label>
\t\t \t\t\t\t<input id="quantity" name="quantity" class="required number" value="{$rowe['Quantity']}"/>
\t\t \t\t\t\t</p>
\t\t \t\t\t\t<p>
\t\t \t\t\t\t<label>Remarks</label>
\t\t \t\t\t\t<textarea id="remarks" name="remarks" rows="5" cols="40" maxlength="300">{$rowe['Remarks']}</textarea>示例7: nonProdRow
function nonProdRow()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
if ($this->commitid != '') {
$q = "SELECT *,DATE_FORMAT(Start_Date_Time,'%d-%m-%Y') as sdt,DATE_FORMAT(End_Date_Time,'%d-%m-%Y') as edt,DATE_FORMAT(Qualification_Date,'%d-%m-%Y') as qdt,DATE_FORMAT(Done_Date,'%d-%m-%Y') as ddt\n\t FROM Routecard WHERE Batch_ID={$this->batchid} AND Commit_ID={$this->commitid} AND Operation_ID={$this->operationid}";
if (!($res = $cxn->query($q))) {
exit("error (nonprodrow) {$q} : {$cxn->error}");
}
//print("<br>$q");
if ($res->num_rows > 0) {
$r = mysqli_fetch_assoc($res);
$this->startdate = $r['sdt'];
$this->enddate = $r['edt'];
$this->startdatedb = $r['Start_Date_Time'];
$this->enddatedb = $r['End_Date_Time'];
$this->acceptedqty = $r['Accepted_Qty'];
$this->rejectedqty = $r['Rejected_Qty'];
$this->ncqty = $r['NC_Qty'];
$this->inspectedby = $r['Done_BY'];
$this->inspdatedb = $r['Done_Date'];
$this->approvaldate = $r['qdt'];
$this->approvaldatedb = $r['Qualification_Date'];
$this->approverid = $r['Qualified_BY'];
$this->ncrem = $r['NC_Remarks'];
$this->rejrem = $r['Rej_Remarks'];
$this->remarks = $r['Remarks'];
$this->routecardid = $r['Routecard_ID'];
}
$this->displayCommitedQty();
$ope = new Operator();
$ope->createOperatorList();
echo '<table class="tl">
<tr><th>Operation Start Date</th><td><input id="sdt" name="sdt" value="' . $this->startdate . '"><input id="sdtdb" name="sdtdb" type="hidden" value="' . $this->startdatedb . '"></td></tr>
<tr><th>Operation End Date</th><td><input id="edt" name="edt" value="' . $this->enddate . '"><input id="edtdb" name="edtdb" type="hidden" value="' . $this->enddatedb . '"></td></tr>
<tr><th>Accepted Quantity</th><td><input id="acceptedqty" name="acceptedqty" value="' . $this->acceptedqty . '" class="required"></td></tr>
<tr><th>Rejected Quantity</th><td><input id="rejectedqty" name="rejectedqty" value="' . $this->rejectedqty . '">Rejection Remarks<input id="rejrem" name="rejrem" size="50"></td></tr>
<tr><th>Non Conforming Quantity</th><td><input id="ncqty" name="ncqty" value="' . $this->ncqty . '">NonConf. Remarks<input id="ncrem" name="ncrem" size="50"></td></tr>
<tr><th>Done By</th><td>';
$sel = new selectlist("doneby", $ope->getOperatorList(), 'Select Name', 'Operator_ID', 'Operator_Name', 'class="required"', $this->inspectedby, '');
echo '</td></tr>
<tr><th>Re Qualified By</th><td>';
$sel = new selectlist("qualifiedby", $ope->getOperatorList(), 'Select Name', 'Operator_ID', 'Operator_Name', 'class="required"', $this->approverid, '');
echo '</td></tr>';
echo '<tr><th>Re Qualification Date</th><td><input id="approvaldate" name="approvaldate" value="' . $this->approvaldate . '"><input id="approvaldatedb" name="approvaldatedb" type="hidden" value="' . $this->approvaldatedb . '">';
echo '</td></tr>';
if ($this->routecardid != '') {
echo '<tr><td><input type="hidden" name="routecardid" id="routecardid" value="' . $this->routecardid . '"></td></tr>';
}
echo '</table>';
}
}示例8: showECNUI
function showECNUI()
{
$db = Database::getInstance();
$cxn = $db->getConnection();
$tm = '';
if ($this->ecnid != '') {
$q = "SELECT *,DATE_FORMAT(Request_Date,'%d-%m-%Y') as rdt FROM ECN WHERE ECN_ID={$this->ecnid}";
if (!($res = $cxn->query($q))) {
exit("error : {$cxn->error}");
}
$row = mysqli_fetch_assoc($res);
$this->ecnno = $row['ECN_NO'];
$this->problemdescription = $row['Problem_Description'];
$this->solutionrequirement = $row['Solution_Requirement'];
// $this->requesterid=$row['Requetser_ID'];
$this->requestdate = $row['rdt'];
$this->requestdatedb = $row['Request_Date'];
$this->disposition = $row['Disposition'];
$qop = "SELECT *,DATE_FORMAT(Target_Date,'%d-%m-%Y') as td FROM ECN_Team_Members WHERE ECN_ID={$this->ecnid}";
if (!($resqop = $cxn->query($qop))) {
exit("error : {$cxn->error}");
}
$tm = $resqop->num_rows;
}
$ope = new Operator();
$ope->createOperatorList();
echo '<fieldset><legend>Engineering Change Note Details</legend>';
echo '<p><label>ECN Date</label><input id="ecnd" name="ecnd" class="required" value="' . $this->requestdate . '"><input type="hidden" id="ecnddb" name="ecnddb" value="' . $this->requestdatedb . '"></p>';
echo '<p><label>ECN No</label><input id="ecnno" name="ecnno" class="required" value="' . $this->ecnno . '"></p>';
echo '<p><label>Problem Description/Reason for Change</label><textarea id="problemdescription" name="problemdescription" class="required" rows="5" cols="40">' . $this->problemdescription . '</textarea></p>';
echo '<p><label>Solution Requirement</label><textarea id="solutionrequirement" name="solutionrequirement" class="required" rows="5" cols="40">' . $this->solutionrequirement . '</textarea></p>';
echo '<p><label>Team Members</label><input type="button" id="addmember" value="Add Team Member"></p>';
echo '<table id="tm" width="100%" class="u"><tr><th align="center">Name</th><th align="center">Department</th><th align="center">Work Desc.</th><th align="center">Target Date</th><th align="center">Remarks</th></tr>';
$any = new Anylist();
$any->createList('Department');
if ($tm > 0) {
$i = 0;
while ($rop = mysqli_fetch_assoc($resqop)) {
echo '<tr><td><input type="hidden" id="ecntmid[' . $i . ']" name="ecntmid[' . $i . ']" value="' . $rop['ECN_Team_Member_ID'] . '">';
$sel = new selectlist("teammember[" . $i . "]", $ope->getOperatorList(), 'Select Member Name', 'Operator_ID', 'Operator_Name', 'class="required"', $rop['Team_Member_ID'], '');
echo '</td><td>';
$sel = new selectlist("department[" . $i . "]", $any->anylist, 'Select Department', 'Department', 'Department', 'class="required"', $rop['Department'], '');
// <input id="department['.$i.']" name="department['.$i.']" class="required" value="'.$rop['Department'].'">
echo '</td><td><input id="work[' . $i . ']" name="work[' . $i . ']" class="required" value="' . $rop['Work'] . '" size="75"></td>';
echo '<td><input id="tdate[' . $i . ']" name="tdate[' . $i . ']" class="required" value="' . $rop['td'] . '"></td><td><input id="memberremarks[' . $i . ']" name="memberremarks[' . $i . ']" value="' . $rop['Remarks'] . '"></td>';
echo '<input type="hidden" id="tdatedb[' . $i . ']" name="tdatedb[' . $i . ']" value="' . $rop['Target_Date'] . '"></tr>';
$i++;
}
} else {
echo '<tr><td>';
$sel = new selectlist("teammember[0]", $ope->getOperatorList(), 'Select Member Name', 'Operator_ID', 'Operator_Name', 'class="required"', '', '');
echo '</td><td>';
$sel = new selectlist("department[0]", $any->anylist, 'Select Department', 'Department', 'Department', 'class="required"', '', '');
echo '</td><td><input id="work[0]" name="work[0]" class="required" size="75"></td>';
echo '<td><input id="tdate[0]" name="tdate[0]" class="required"></td><td><input id="memberremarks[0]" name="memberremarks[0]" size="75"></td>';
echo '<input type="hidden" id="tdatedb[0]" name="tdatedb[0]"></tr>';
}
echo '</table>';
if ($this->ecnid != '') {
echo '<p><label>Closing Remarks</label><input name="appremarks" size="75" id="appremarks"><input type="button" Value="Approve and Close NC Log" id="abutton"></p>';
self::showLogimages();
}
echo '<input class="submit" type="submit" value="Save"/>';
}