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>'; }
$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 = ''; } if (isset($_GET['id'])) { $id = $_GET['id'];
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>'; }